From 8ffde2e23c21ccae81f34c34ef115993719d34eb Mon Sep 17 00:00:00 2001 From: Paul Duncan Date: Wed, 27 Jul 2016 09:28:50 -0400 Subject: add page assets --- data/init.yaml | 45 ++++++++++++++++++++++++++++++++------------- 1 file changed, 32 insertions(+), 13 deletions(-) (limited to 'data/init.yaml') diff --git a/data/init.yaml b/data/init.yaml index 4f260b4..46a1e11 100644 --- a/data/init.yaml +++ b/data/init.yaml @@ -44,6 +44,18 @@ init_sql: is_active BOOLEAN NOT NULL DEFAULT false ) + - | + CREATE TABLE asset_types ( + type_id INTEGER PRIMARY KEY, + name TEXT UNIQUE NOT NULL + CHECK (LENGTH(name) > 0) + ) + + - | + INSERT INTO asset_types(type_id, name) VALUES + (1, 'script'), + (2, 'style') + - | CREATE TABLE themes ( theme_id INTEGER PRIMARY KEY, @@ -158,18 +170,6 @@ init_sql: UNIQUE (theme_id, file_path) ) - - | - CREATE TABLE theme_asset_types ( - type_id INTEGER PRIMARY KEY, - name TEXT UNIQUE NOT NULL - CHECK (LENGTH(name) > 0) - ) - - - | - INSERT INTO theme_asset_types(type_id, name) VALUES - (1, 'script'), - (2, 'style') - - | CREATE TABLE theme_assets ( -- theme file @@ -178,7 +178,7 @@ init_sql: -- asset type type_id INTEGER NOT NULL - REFERENCES theme_asset_types(type_id), + REFERENCES asset_types(type_id), -- load order sort_order INTEGER NOT NULL, @@ -321,6 +321,25 @@ init_sql: REFERENCES themes(theme_id) ) + - | + CREATE TABLE page_assets ( + post_id INTEGER NOT NULL + REFERENCES posts(post_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 (post_id, type_id, path) + ) + - | CREATE TABLE sessions ( id TEXT PRIMARY KEY, -- cgit v1.2.3