summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--schema.sql10
1 files changed, 5 insertions, 5 deletions
diff --git a/schema.sql b/schema.sql
index 788228d..f8faadd 100644
--- a/schema.sql
+++ b/schema.sql
@@ -98,11 +98,11 @@ CREATE TABLE article_revision_characteristics(
);
CREATE TABLE article_revision_parenthood(
- parent_id INTEGER NOT NULL,
- child_id INTEGER NOT NULL,
- PRIMARY KEY (parent_id, child_id),
- FOREIGN KEY (parent_id) REFERENCES article_revisions,
- FOREIGN KEY (child_id) REFERENCES article_revisions
+ parent INTEGER NOT NULL,
+ child INTEGER NOT NULL,
+ PRIMARY KEY (parent, child),
+ FOREIGN KEY (parent) REFERENCES article_revisions,
+ FOREIGN KEY (child) REFERENCES article_revisions
);
CREATE TABLE comment_revisions(