Add comment support to article template, add support for multiple page templates.

1 files changed, 15 insertions, 4 deletions

diff --git a/schema.sql b/schema.sql
index 914398c..909f6b3 100644
--- a/schema.sql
+++ b/schema.sql
@@ -40,11 +40,20 @@ CREATE TABLE login_certificates(
   FOREIGN KEY ("user") REFERENCES users
 );
 
-CREATE TABLE articles(
-  id SERIAL NOT NULL,
+CREATE TABLE article_types(
+  id            SERIAL NOT NULL,
+  name          VARCHAR,
+  page_template VARCHAR,
   PRIMARY KEY (id)
 );
 
+CREATE TABLE articles(
+  id   SERIAL  NOT NULL,
+  type INTEGER NOT NULL,
+  PRIMARY KEY (id),
+  FOREIGN KEY (type) REFERENCES article_types
+);
+
 CREATE TABLE article_aliases(
   alias   VARCHAR NOT NULL,
   article INTEGER NOT NULL,
@@ -66,11 +75,13 @@ CREATE TABLE article_revisions(
   title     VARCHAR   NOT NULL,
   content   VARCHAR   NOT NULL,
   author    INTEGER,
-  format    varchar   NOT NULL,
+  format    VARCHAR   NOT NULL,
+  status    VARCHAR   NOT NULL,
   PRIMARY KEY (id),
   FOREIGN KEY (article) REFERENCES articles,
   FOREIGN KEY (author)  REFERENCES users,
-  CHECK (format IN ('html'))
+  CHECK (format IN ('html')),
+  CHECK (status IN ('draft', 'published', 'syndicated'))
 );
 
 CREATE TABLE article_revision_characteristics(