Database schema: Add a global_id column to the article_revisions table in order to simplify data migration.

1 files changed, 3 insertions, 1 deletions

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(