From 3a025b56affdd19bf1ee5c92a4ace7d0c5ffb481 Mon Sep 17 00:00:00 2001 From: Matthias Andreas Benkard Date: Wed, 2 Mar 2011 18:01:45 +0100 Subject: Database schema: Improve column naming. --- schema.sql | 10 +++++----- 1 file 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( -- cgit v1.2.3