From 8ffde2e23c21ccae81f34c34ef115993719d34eb Mon Sep 17 00:00:00 2001
From: Paul Duncan <pabs@pablotron.org>
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')
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