populate sites api and site list

1 files changed, 57 insertions, 18 deletions

diff --git a/data/init.yaml b/data/init.yaml
index 34a0595..f9a8ac1 100644
--- a/data/init.yaml
+++ b/data/init.yaml
@@ -41,7 +41,7 @@ init_sql:
 
       password    TEXT NOT NULL DEFAULT '',
 
-      is_active   BOOLEAN NOT NULL DEFAULT false
+      is_active   BOOLEAN NOT NULL DEFAULT 0
     )
 
   - |
@@ -88,7 +88,7 @@ init_sql:
 
       -- is this a system theme?
       -- note: system themes are located in system_dir/themes/<slug>/
-      is_system     BOOLEAN NOT NULL DEFAULT false
+      is_system     BOOLEAN NOT NULL DEFAULT 0
     )
 
   - |
@@ -188,32 +188,67 @@ init_sql:
 
   - |
     CREATE TABLE sites (
-      site_id     INTEGER PRIMARY KEY,
+      site_id       INTEGER PRIMARY KEY,
+
+      -- make sure slug is lowercase, does not begin with a dot, and
+      -- does not contain slashes
+      slug          TEXT UNIQUE NOT NULL CHECK (
+                      LENGTH(slug) > 0 AND
+                      slug = LOWER(slug) AND
+                      slug NOT LIKE '.%' AND
+                      slug NOT LIKE '%/%'
+                    ),
 
-      -- make sure name does not begin with a dot or
+      -- make sure slug does not begin with a dot or
       -- contain slashes
-      name        TEXT UNIQUE NOT NULL CHECK (
-                    LENGTH(name) > 0 AND
-                    name NOT LIKE '.%' AND
-                    name NOT LIKE '%/%'
-                  ),
+      name          TEXT UNIQUE NOT NULL
+                    CHECK (LENGTH(name) > 0),
+
+      -- site description
+      body          TEXT NOT NULL DEFAULT '',
+
+      -- site description
+      lang          TEXT NOT NULL DEFAULT 'en-US' CHECK (
+                      -- e.g. 'en' or 'en-US'
+                      (LENGTH(lang) = 2 OR LENGTH(lang) = 5) AND
+                      (lang LIKE '__' OR lang LIKE '__-__')
+                    ),
 
       -- date that site was created
-      created_at  TIMESTAMP WITH TIME ZONE NOT NULL
-                  DEFAULT CURRENT_TIMESTAMP,
+      created_at    TIMESTAMP WITH TIME ZONE NOT NULL
+                    DEFAULT CURRENT_TIMESTAMP,
 
       -- theme for this site
-      theme_id    INTEGER NOT NULL
-                  REFERENCES themes(theme_id),
+      theme_id      INTEGER NOT NULL
+                    REFERENCES themes(theme_id),
+
+      -- disabled: too fucking complicated with "is_default"
+      -- is this site active
+      -- is_active     BOOLEAN NOT NULL DEFAULT 0,
 
-      is_active   BOOLEAN NOT NULL DEFAULT false,
+      -- is this the default site
+      is_default    BOOLEAN NOT NULL DEFAULT 0,
 
-      is_default  BOOLEAN NOT NULL DEFAULT false
+      -- use full body for rss and atom feeds
+      is_full_feed  BOOLEAN NOT NULL DEFAULT 1
     )
 
   - |
-    INSERT INTO sites(site_id, name, theme_id, is_active, is_default) VALUES
-      (1, 'default', 1, 1, 1)
+    INSERT INTO sites (
+      site_id,
+      slug,
+      name,
+      body,
+      theme_id,
+      is_default
+    ) VALUES (
+      1,
+      'default',
+      'Default',
+      'True guff stuff.',
+      1,
+      1
+    )
 
   - |
     CREATE TABLE site_domains (
@@ -224,7 +259,11 @@ init_sql:
                     LENGTH(domain) > 0 AND
                     domain = LOWER(domain) AND
                     domain NOT LIKE '% %'
-                  )
+                  ),
+
+      sort_order  INTEGER NOT NULL,
+
+      PRIMARY KEY (site_id, domain)
     )
 
   - |