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,