From 183cc31c0b5f812c0f0fcd8a292e378a9695417f Mon Sep 17 00:00:00 2001 From: Paul Duncan Date: Fri, 29 Jul 2016 23:59:53 -0400 Subject: add backend for project tag prefix and hook secret, remove expires_at --- data/init.yaml | 31 +++++++++++++++++++++++++++++-- 1 file changed, 29 insertions(+), 2 deletions(-) (limited to 'data/init.yaml') 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) ) - | -- cgit v1.2.3