summaryrefslogtreecommitdiffstats
path: root/migrations
diff options
context:
space:
mode:
authorMatthias Beyer <mail@beyermatthias.de>2021-02-05 15:28:42 +0100
committerMatthias Beyer <mail@beyermatthias.de>2021-02-05 15:30:21 +0100
commit2a1e017c063c462da3702e0227cb075643013988 (patch)
treee28c9b7d3dc96a3d83d3da9384effdd92b506e6a /migrations
parent2852e1b6e9a3987d923e6fe774172a00a12b9192 (diff)
Remove "tree" from submit
This removes the "tree" column from the "submits" table. This is because we do not store the build-tree in the database anymore. We don't actually need this feature and we can always re-build the tree from an old commit in the repository. Thus, this is not required anymore. Also, it is less easy to do as soon as the internal implementation changes from a "tree" structure to a "DAG" structure. Signed-off-by: Matthias Beyer <mail@beyermatthias.de>
Diffstat (limited to 'migrations')
-rw-r--r--migrations/2021-02-05-142606_remove-package-tree-json-from-submit/down.sql5
-rw-r--r--migrations/2021-02-05-142606_remove-package-tree-json-from-submit/up.sql5
2 files changed, 10 insertions, 0 deletions
diff --git a/migrations/2021-02-05-142606_remove-package-tree-json-from-submit/down.sql b/migrations/2021-02-05-142606_remove-package-tree-json-from-submit/down.sql
new file mode 100644
index 0000000..a7348ee
--- /dev/null
+++ b/migrations/2021-02-05-142606_remove-package-tree-json-from-submit/down.sql
@@ -0,0 +1,5 @@
+-- This file should undo anything in `up.sql`
+ALTER TABLE
+ submits
+ADD COLUMN
+ tree JSONB NOT NULL
diff --git a/migrations/2021-02-05-142606_remove-package-tree-json-from-submit/up.sql b/migrations/2021-02-05-142606_remove-package-tree-json-from-submit/up.sql
new file mode 100644
index 0000000..531d746
--- /dev/null
+++ b/migrations/2021-02-05-142606_remove-package-tree-json-from-submit/up.sql
@@ -0,0 +1,5 @@
+-- Your SQL goes here
+ALTER TABLE
+ submits
+DROP COLUMN
+ tree