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

(limited to 'schema.sql')

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

