aboutsummaryrefslogtreecommitdiffstats
path: root/internal/db/migrations/00004_section_placement.sql
diff options
context:
space:
mode:
Diffstat (limited to 'internal/db/migrations/00004_section_placement.sql')
-rw-r--r--internal/db/migrations/00004_section_placement.sql13
1 files changed, 0 insertions, 13 deletions
diff --git a/internal/db/migrations/00004_section_placement.sql b/internal/db/migrations/00004_section_placement.sql
deleted file mode 100644
index c36787e..0000000
--- a/internal/db/migrations/00004_section_placement.sql
+++ /dev/null
@@ -1,13 +0,0 @@
--- +goose Up
--- Announcements are placed in a column (left, main, right) at its top or bottom.
-ALTER TABLE sections DROP CONSTRAINT sections_placement_check;
-UPDATE sections SET placement = CASE placement WHEN 'above' THEN 'main-top' WHEN 'below' THEN 'main-bottom' ELSE 'left-top' END;
-ALTER TABLE sections ALTER COLUMN placement SET DEFAULT 'main-top';
-ALTER TABLE sections ADD CONSTRAINT sections_placement_check
- CHECK (placement IN ('left-top', 'left-bottom', 'main-top', 'main-bottom', 'right-top', 'right-bottom'));
-
--- +goose Down
-ALTER TABLE sections DROP CONSTRAINT sections_placement_check;
-UPDATE sections SET placement = CASE placement WHEN 'main-top' THEN 'above' WHEN 'main-bottom' THEN 'below' ELSE 'sidebar' END;
-ALTER TABLE sections ALTER COLUMN placement SET DEFAULT 'above';
-ALTER TABLE sections ADD CONSTRAINT sections_placement_check CHECK (placement IN ('above', 'below', 'sidebar'));