summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorMatthias Andreas Benkard <code@mail.matthias.benkard.de>2011-03-02 18:01:45 +0100
committerMatthias Andreas Benkard <code@mail.matthias.benkard.de>2011-03-02 18:01:45 +0100
commit3a025b56affdd19bf1ee5c92a4ace7d0c5ffb481 (patch)
tree86afcf801123c399a7a7a3ef2927872afd16a816
parent018bdbf096cc7de6795413568e1ce1b56490aa6a (diff)
Database schema: Improve column naming.
-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(