diff options
Diffstat (limited to 'internal/db/migrations/blog/00008_page_outro.sql')
| -rw-r--r-- | internal/db/migrations/blog/00008_page_outro.sql | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/internal/db/migrations/blog/00008_page_outro.sql b/internal/db/migrations/blog/00008_page_outro.sql new file mode 100644 index 0000000..e795df0 --- /dev/null +++ b/internal/db/migrations/blog/00008_page_outro.sql @@ -0,0 +1,9 @@ +-- +goose Up +-- A page can carry text after its posts as well as before them, in the same +-- format as the intro (one format column per page). +ALTER TABLE pages + ADD COLUMN outro_md text NOT NULL DEFAULT '', + ADD COLUMN outro_html text NOT NULL DEFAULT ''; + +-- +goose Down +ALTER TABLE pages DROP COLUMN outro_md, DROP COLUMN outro_html; |