From 5abf2496a9bbc9426c92d73de721ada2b6a5522f Mon Sep 17 00:00:00 2001 From: Matthias Andreas Benkard Date: Wed, 2 Mar 2011 17:25:56 +0100 Subject: Database schema: Add a global_id column to the article_revisions table in order to simplify data migration. --- schema.sql | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-) diff --git a/schema.sql b/schema.sql index 909f6b3..63d227f 100644 --- a/schema.sql +++ b/schema.sql @@ -77,11 +77,13 @@ CREATE TABLE article_revisions( author INTEGER, format VARCHAR NOT NULL, status VARCHAR NOT NULL, + global_id VARCHAR, PRIMARY KEY (id), FOREIGN KEY (article) REFERENCES articles, FOREIGN KEY (author) REFERENCES users, CHECK (format IN ('html')), - CHECK (status IN ('draft', 'published', 'syndicated')) + CHECK (status IN ('draft', 'published', 'syndicated')), + UNIQUE (global_id) ); CREATE TABLE article_revision_characteristics( -- cgit v1.2.3