diff options
| author | Frederick Muriuki Muriithi | 2023-03-13 06:25:13 +0300 |
|---|---|---|
| committer | Frederick Muriuki Muriithi | 2023-03-13 06:25:13 +0300 |
| commit | 3dee24dc1e05893b49ace052ab61899e49a03bb7 (patch) | |
| tree | a53e02f1c89288ed9808ff058fe9b258d6c39c56 /migrations/auth/20221110_01_WtZ1I-create-resources-table.py | |
| parent | 08ab26292b9ed2da9e91a683f38c6e1f532af4ee (diff) | |
| download | genenetwork3-3dee24dc1e05893b49ace052ab61899e49a03bb7.tar.gz | |
Add 'ON UPDATE/DELETE' clauses to foreign keys.
Diffstat (limited to 'migrations/auth/20221110_01_WtZ1I-create-resources-table.py')
| -rw-r--r-- | migrations/auth/20221110_01_WtZ1I-create-resources-table.py | 7 |
1 files changed, 5 insertions, 2 deletions
diff --git a/migrations/auth/20221110_01_WtZ1I-create-resources-table.py b/migrations/auth/20221110_01_WtZ1I-create-resources-table.py index 09ed891..0b769b8 100644 --- a/migrations/auth/20221110_01_WtZ1I-create-resources-table.py +++ b/migrations/auth/20221110_01_WtZ1I-create-resources-table.py @@ -15,8 +15,11 @@ steps = [ resource_name TEXT NOT NULL, resource_category_id TEXT NOT NULL, PRIMARY KEY(group_id, resource_id), - FOREIGN KEY(group_id) REFERENCES groups(group_id), - FOREIGN KEY(resource_category_id) REFERENCES resource_categories(resource_category_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") |