diff options
Diffstat (limited to 'data/init.yaml')
| -rw-r--r-- | data/init.yaml | 45 |
1 files changed, 32 insertions, 13 deletions
diff --git a/data/init.yaml b/data/init.yaml index 4f260b4..46a1e11 100644 --- a/data/init.yaml +++ b/data/init.yaml @@ -45,6 +45,18 @@ init_sql: ) - | + 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, @@ -159,18 +171,6 @@ init_sql: ) - | - 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 file_id INTEGER NOT NULL @@ -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, @@ -322,6 +322,25 @@ init_sql: ) - | + 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, |