blob: 647325f9db7213df45c926fd0e15751a24e115dc (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
|
"""
Create linked-phenotype-data table
"""
from yoyo import step
__depends__ = {'20230306_02_7GnRY-add-system-user-list-privilege-to-system-administrator-and-group-leader-roles'}
steps = [
step(
"""
CREATE TABLE IF NOT EXISTS linked_phenotype_data
-- Link the data in MariaDB to user groups in the auth system
(
data_link_id TEXT NOT NULL PRIMARY KEY, -- A new ID for the auth system
group_id TEXT NOT NULL, -- The user group the data is linked to
SpeciesId TEXT NOT NULL, -- The species in MariaDB
InbredSetId TEXT NOT NULL, -- The traits group in MariaDB
PublishFreezeId TEXT NOT NULL, -- The dataset Id in MariaDB
dataset_name TEXT, -- dataset Name in MariaDB
dataset_fullname, -- dataset FullName in MariaDB
dataset_shortname, -- dataset ShortName in MariaDB
PublishXRefId TEXT NOT NULL, -- The trait's ID in MariaDB
FOREIGN KEY (group_id)
REFERENCES groups(group_id) ON UPDATE CASCADE ON DELETE RESTRICT
UNIQUE (SpeciesId, InbredSetId, PublishFreezeId, PublishXRefId)
) WITHOUT ROWID
""",
"DROP TABLE IF EXISTS linked_phenotype_data")
]
|
