aboutsummaryrefslogtreecommitdiffstats
path: root/internal/db/migrations/blog/00011_post_hide_date.sql
diff options
context:
space:
mode:
Diffstat (limited to 'internal/db/migrations/blog/00011_post_hide_date.sql')
-rw-r--r--internal/db/migrations/blog/00011_post_hide_date.sql7
1 files changed, 7 insertions, 0 deletions
diff --git a/internal/db/migrations/blog/00011_post_hide_date.sql b/internal/db/migrations/blog/00011_post_hide_date.sql
new file mode 100644
index 0000000..5af11ed
--- /dev/null
+++ b/internal/db/migrations/blog/00011_post_hide_date.sql
@@ -0,0 +1,7 @@
+-- +goose Up
+-- A per-post override of the theme's "show the date" switch, for evergreen
+-- posts on a blog that otherwise dates everything.
+ALTER TABLE posts ADD COLUMN hide_date boolean NOT NULL DEFAULT false;
+
+-- +goose Down
+ALTER TABLE posts DROP COLUMN hide_date;