diff options
| author | Paul Duncan <pabs@pablotron.org> | 2016-07-30 15:10:14 -0400 |
|---|---|---|
| committer | Paul Duncan <pabs@pablotron.org> | 2016-07-30 15:10:14 -0400 |
| commit | 0557ef64e2bd1161fd98a5dff6e45aea8e0d7567 (patch) | |
| tree | 2960808d40679eb3059a8bbf22d389e81b5cb83d /data/init.yaml | |
| parent | e6ebc011f255596f09fec40f69049514d52bebef (diff) | |
| download | guff-0557ef64e2bd1161fd98a5dff6e45aea8e0d7567.tar.bz2 guff-0557ef64e2bd1161fd98a5dff6e45aea8e0d7567.zip | |
add site assets and remove set_default
Diffstat (limited to 'data/init.yaml')
| -rw-r--r-- | data/init.yaml | 19 |
1 files changed, 19 insertions, 0 deletions
diff --git a/data/init.yaml b/data/init.yaml index f9a8ac1..de78d23 100644 --- a/data/init.yaml +++ b/data/init.yaml @@ -267,6 +267,25 @@ init_sql: ) - | + 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, |