From 3a025b56affdd19bf1ee5c92a4ace7d0c5ffb481 Mon Sep 17 00:00:00 2001
From: Matthias Andreas Benkard <code@mail.matthias.benkard.de>
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(-)

(limited to 'schema.sql')

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

