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.

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")
-]