1 files changed, 10 insertions, 0 deletions
diff --git a/internal/db/migrations/blog/00009_gizmo_style.sql b/internal/db/migrations/blog/00009_gizmo_style.sql
new file mode 100644
index 0000000..1af8733
--- /dev/null
+++ b/internal/db/migrations/blog/00009_gizmo_style.sql
@@ -0,0 +1,10 @@
+-- +goose Up
+-- A fourth look for announcements: a box framed in the link colour, with
+-- boxes in the same spot sitting side by side on wide screens.
+ALTER TABLE sections DROP CONSTRAINT sections_style_check;
+ALTER TABLE sections ADD CONSTRAINT sections_style_check CHECK (style IN ('plain', 'note', 'warning', 'gizmo'));
+
+-- +goose Down
+UPDATE sections SET style = 'plain' WHERE style = 'gizmo';
+ALTER TABLE sections DROP CONSTRAINT sections_style_check;
+ALTER TABLE sections ADD CONSTRAINT sections_style_check CHECK (style IN ('plain', 'note', 'warning'));