diff options
Diffstat (limited to 'migrations/auth/20221110_02_z1dWf-create-mrna-resources-table.py')
-rw-r--r-- | migrations/auth/20221110_02_z1dWf-create-mrna-resources-table.py | 25 |
1 files changed, 0 insertions, 25 deletions
diff --git a/migrations/auth/20221110_02_z1dWf-create-mrna-resources-table.py b/migrations/auth/20221110_02_z1dWf-create-mrna-resources-table.py deleted file mode 100644 index d3f97ac..0000000 --- a/migrations/auth/20221110_02_z1dWf-create-mrna-resources-table.py +++ /dev/null @@ -1,25 +0,0 @@ -""" -Create 'mrna_resources' table - -NOTE: One "mRNA dataset" should only ever be linked to one and only one resource object. - One "resource object" should only ever be linked to one and only one "mRNA dataset". -""" - -from yoyo import step - -__depends__ = {'20221110_01_WtZ1I-create-resources-table'} - -steps = [ - step( - """ - CREATE TABLE IF NOT EXISTS mrna_resources( - group_id TEXT NOT NULL, - resource_id TEXT PRIMARY KEY, - dataset_id TEXT NOT NULL UNIQUE, - FOREIGN KEY(group_id, resource_id) - REFERENCES resources(group_id, resource_id) - ON UPDATE CASCADE ON DELETE RESTRICT - ) WITHOUT ROWID - """, - "DROP TABLE IF EXISTS mrna_resources") -] |