aboutsummaryrefslogtreecommitdiff
path: root/migrations/auth/20221110_01_WtZ1I-create-resources-table.py
diff options
context:
space:
mode:
Diffstat (limited to 'migrations/auth/20221110_01_WtZ1I-create-resources-table.py')
-rw-r--r--migrations/auth/20221110_01_WtZ1I-create-resources-table.py26
1 files changed, 0 insertions, 26 deletions
diff --git a/migrations/auth/20221110_01_WtZ1I-create-resources-table.py b/migrations/auth/20221110_01_WtZ1I-create-resources-table.py
deleted file mode 100644
index abc8895..0000000
--- a/migrations/auth/20221110_01_WtZ1I-create-resources-table.py
+++ /dev/null
@@ -1,26 +0,0 @@
-"""
-Create 'resources' table
-"""
-
-from yoyo import step
-
-__depends__ = {'20221109_01_HbD5F-add-resource-meta-field-to-resource-categories-field'}
-
-steps = [
- step(
- """
- CREATE TABLE IF NOT EXISTS resources(
- group_id TEXT NOT NULL,
- resource_id TEXT NOT NULL,
- resource_name TEXT NOT NULL UNIQUE,
- resource_category_id TEXT NOT NULL,
- PRIMARY KEY(group_id, resource_id),
- FOREIGN KEY(group_id) REFERENCES groups(group_id)
- ON UPDATE CASCADE ON DELETE RESTRICT,
- FOREIGN KEY(resource_category_id)
- REFERENCES resource_categories(resource_category_id)
- ON UPDATE CASCADE ON DELETE RESTRICT
- ) WITHOUT ROWID
- """,
- "DROP TABLE IF EXISTS resources")
-]