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, 25 deletions

diff --git a/migrations/auth/20221110_02_z1dWf-create-mrna-resources-table.py b/migrations/auth/20221110_02_z1dWf-create-mrna-resources-table.py
deleted file mode 100644
index d3f97ac..0000000
--- a/migrations/auth/20221110_02_z1dWf-create-mrna-resources-table.py
+++ /dev/null
@@ -1,25 +0,0 @@
-"""
-Create 'mrna_resources' table
-
-NOTE: One "mRNA dataset" should only ever be linked to one and only one resource object.
-      One "resource object" should only ever be linked to one and only one "mRNA dataset".
-"""
-
-from yoyo import step
-
-__depends__ = {'20221110_01_WtZ1I-create-resources-table'}
-
-steps = [
-    step(
-        """
-        CREATE TABLE IF NOT EXISTS mrna_resources(
-            group_id TEXT NOT NULL,
-            resource_id TEXT PRIMARY KEY,
-            dataset_id TEXT NOT NULL UNIQUE,
-            FOREIGN KEY(group_id, resource_id)
-              REFERENCES resources(group_id, resource_id)
-              ON UPDATE CASCADE ON DELETE RESTRICT
-        ) WITHOUT ROWID
-        """,
-        "DROP TABLE IF EXISTS mrna_resources")
-]