summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--schema.sql23
1 files changed, 13 insertions, 10 deletions
diff --git a/schema.sql b/schema.sql
index f8faadd..8c2287d 100644
--- a/schema.sql
+++ b/schema.sql
@@ -65,8 +65,9 @@ CREATE TABLE article_aliases(
);
CREATE TABLE comments(
- id SERIAL NOT NULL,
- article INTEGER NOT NULL,
+ id SERIAL NOT NULL,
+ article INTEGER NOT NULL,
+ global_id VARCHAR,
PRIMARY KEY (id),
FOREIGN KEY (article) REFERENCES articles
);
@@ -106,14 +107,16 @@ CREATE TABLE article_revision_parenthood(
);
CREATE TABLE comment_revisions(
- id SERIAL NOT NULL,
- comment INTEGER NOT NULL,
- date TIMESTAMP DEFAULT now(),
- content VARCHAR NOT NULL,
- author INTEGER,
- format VARCHAR NOT NULL,
- status VARCHAR NOT NULL,
- article_revision INTEGER,
+ id SERIAL NOT NULL,
+ comment INTEGER NOT NULL,
+ date TIMESTAMP DEFAULT now(),
+ content VARCHAR NOT NULL,
+ author INTEGER,
+ submitter_ip INET,
+ submitter_user_agent VARCHAR,
+ format VARCHAR NOT NULL,
+ status VARCHAR NOT NULL,
+ article_revision INTEGER,
PRIMARY KEY (id),
FOREIGN KEY (comment) REFERENCES comments,
FOREIGN KEY (author) REFERENCES users,