aboutsummaryrefslogtreecommitdiffstats
path: root/internal/db/migrations/control/00002_sections.sql
diff options
context:
space:
mode:
Diffstat (limited to 'internal/db/migrations/control/00002_sections.sql')
-rw-r--r--internal/db/migrations/control/00002_sections.sql19
1 files changed, 0 insertions, 19 deletions
diff --git a/internal/db/migrations/control/00002_sections.sql b/internal/db/migrations/control/00002_sections.sql
deleted file mode 100644
index 388cb17..0000000
--- a/internal/db/migrations/control/00002_sections.sql
+++ /dev/null
@@ -1,19 +0,0 @@
--- +goose Up
--- Announcements: blog-wide notices shown on every page and post.
-CREATE TABLE sections (
- id bigserial PRIMARY KEY,
- blog_id bigint NOT NULL REFERENCES blogs(id) ON DELETE CASCADE,
- title text NOT NULL DEFAULT '',
- body_md text NOT NULL DEFAULT '',
- body_html text NOT NULL DEFAULT '',
- placement text NOT NULL DEFAULT 'above' CHECK (placement IN ('above', 'below', 'sidebar')),
- style text NOT NULL DEFAULT 'note' CHECK (style IN ('plain', 'note', 'warning')),
- enabled boolean NOT NULL DEFAULT true,
- sort_order integer NOT NULL DEFAULT 0,
- created_at timestamptz NOT NULL DEFAULT now(),
- updated_at timestamptz NOT NULL DEFAULT now()
-);
-CREATE INDEX sections_blog ON sections (blog_id, sort_order, id);
-
--- +goose Down
-DROP TABLE sections;