add backend for project tag prefix and hook secret, remove expires_at

1 files changed, 29 insertions, 2 deletions

diff --git a/data/init.yaml b/data/init.yaml
index 46a1e11..34a0595 100644
--- a/data/init.yaml
+++ b/data/init.yaml
@@ -272,7 +272,9 @@ init_sql:
                   REFERENCES states(state_id),
 
       posted_at   TIMESTAMP WITH TIME ZONE,
-      expires_at  TIMESTAMP WITH TIME ZONE,
+
+      -- TODO: add window for visibility
+      -- expires_at  TIMESTAMP WITH TIME ZONE,
 
       name        TEXT NOT NULL DEFAULT '',
 
@@ -307,8 +309,33 @@ init_sql:
       post_id     INTEGER PRIMARY KEY
                   REFERENCES posts(post_id),
 
+      -- repository url
       repo_url    TEXT NOT NULL DEFAULT ''
-                  CHECK (repo_url NOT LIKE '% %')
+                  CHECK (repo_url NOT LIKE '% %'),
+
+      -- prefix to strip from release tags
+      tag_prefix      TEXT NOT NULL DEFAULT ''
+                      CHECK (tag_prefix NOT LIKE '% %'),
+
+      -- secret string used for hooks
+      hook_secret TEXT NOT NULL DEFAULT ''
+                  CHECK (hook_secret NOT LIKE '% %')
+    )
+
+  - |
+    CREATE TABLE project_releases (
+      post_id     INTEGER NOT NULL
+                  REFERENCES posts(post_id),
+
+      name        TEXT NOT NULL CHECK (
+                    LENGTH(name) > 0 AND
+                    name NOT LIKE '% %'
+                  ),
+
+      created_at  TIMESTAMP WITH TIME ZONE
+                  NOT NULL DEFAULT CURRENT_TIMESTAMP,
+
+      PRIMARY KEY (post_id, name)
     )
 
   - |