From 0557ef64e2bd1161fd98a5dff6e45aea8e0d7567 Mon Sep 17 00:00:00 2001 From: Paul Duncan Date: Sat, 30 Jul 2016 15:10:14 -0400 Subject: add site assets and remove set_default --- data/init.yaml | 19 +++++++++++++++++++ 1 file changed, 19 insertions(+) (limited to 'data/init.yaml') diff --git a/data/init.yaml b/data/init.yaml index f9a8ac1..de78d23 100644 --- a/data/init.yaml +++ b/data/init.yaml @@ -266,6 +266,25 @@ init_sql: PRIMARY KEY (site_id, domain) ) + - | + CREATE TABLE site_assets ( + site_id INTEGER NOT NULL + REFERENCES sites(site_id), + + -- asset type + type_id INTEGER NOT NULL + REFERENCES asset_types(type_id), + + -- asset path + path TEXT NOT NULL + CHECK (LENGTH(path) > 0), + + -- load order + sort_order INTEGER NOT NULL, + + PRIMARY KEY (site_id, type_id, path) + ) + - | CREATE TABLE states ( state_id INTEGER PRIMARY KEY, -- cgit v1.2.3