diff options
Diffstat (limited to 'migrations/auth/20230216_01_dgWjv-create-linked-group-data-table.py')
-rw-r--r-- | migrations/auth/20230216_01_dgWjv-create-linked-group-data-table.py | 26 |
1 files changed, 0 insertions, 26 deletions
diff --git a/migrations/auth/20230216_01_dgWjv-create-linked-group-data-table.py b/migrations/auth/20230216_01_dgWjv-create-linked-group-data-table.py deleted file mode 100644 index 890eeef..0000000 --- a/migrations/auth/20230216_01_dgWjv-create-linked-group-data-table.py +++ /dev/null @@ -1,26 +0,0 @@ -""" -Create linked_group_data table -""" - -from yoyo import step - -__depends__ = {'20230210_02_lDK14-create-system-admin-role'} - -steps = [ - step( - """ - CREATE TABLE IF NOT EXISTS linked_group_data( - group_id TEXT NOT NULL, - dataset_type TEXT NOT NULL, - dataset_or_trait_id TEXT NOT NULL, - dataset_name TEXT NOT NULL, - dataset_fullname TEXT NOT NULL, - accession_id TEXT DEFAULT NULL, - PRIMARY KEY(group_id, dataset_type, dataset_or_trait_id), - FOREIGN KEY (group_id) REFERENCES groups(group_id) - ON UPDATE CASCADE ON DELETE RESTRICT, - CHECK (dataset_type IN ('mRNA', 'Genotype', 'Phenotype')) - ) WITHOUT ROWID - """, - "DROP TABLE IF EXISTS linked_group_data") -] |