summaryrefslogtreecommitdiff
path: root/schema.sql
diff options
context:
space:
mode:
Diffstat (limited to 'schema.sql')
-rw-r--r--schema.sql4
1 files changed, 2 insertions, 2 deletions
diff --git a/schema.sql b/schema.sql
index b4ce0bc..1efe049 100644
--- a/schema.sql
+++ b/schema.sql
@@ -116,11 +116,11 @@ CREATE TABLE comment_revisions(
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,
+ submitter_ip INET,
+ submitter_user_agent VARCHAR,
PRIMARY KEY (id),
FOREIGN KEY (comment) REFERENCES comments,
FOREIGN KEY (author) REFERENCES users,