From 926d094d4136f457f732bdba4b092226e44a1930 Mon Sep 17 00:00:00 2001
From: Frederick Muriuki Muriithi
Date: Wed, 22 Mar 2023 08:20:39 +0300
Subject: auth: Remove the tables used for linking data to resources

The way data is linked to the resources needs to be reworked. This commit
removes all the existing migration scripts that created the tables formerly
used for linking data in preparation for reworking the system.
---
 ...0216_01_dgWjv-create-linked-group-data-table.py | 26 ----------------------
 1 file changed, 26 deletions(-)
 delete mode 100644 migrations/auth/20230216_01_dgWjv-create-linked-group-data-table.py

(limited to 'migrations/auth/20230216_01_dgWjv-create-linked-group-data-table.py')

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")
-]
-- 
cgit v1.2.3