diff options
Diffstat (limited to 'internal/db/migrations/blog/00005_search.sql')
| -rw-r--r-- | internal/db/migrations/blog/00005_search.sql | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/internal/db/migrations/blog/00005_search.sql b/internal/db/migrations/blog/00005_search.sql new file mode 100644 index 0000000..59bb4bd --- /dev/null +++ b/internal/db/migrations/blog/00005_search.sql @@ -0,0 +1,11 @@ +-- +goose Up +-- One more layout module: the search box. +ALTER TABLE modules DROP CONSTRAINT modules_kind_check; +ALTER TABLE modules ADD CONSTRAINT modules_kind_check + CHECK (kind IN ('title', 'logo', 'menu', 'archive', 'recent', 'html', 'rss', 'text', 'sitemap', 'tags', 'tagcloud', 'search')); + +-- +goose Down +DELETE FROM modules WHERE kind = 'search'; +ALTER TABLE modules DROP CONSTRAINT modules_kind_check; +ALTER TABLE modules ADD CONSTRAINT modules_kind_check + CHECK (kind IN ('title', 'logo', 'menu', 'archive', 'recent', 'html', 'rss', 'text', 'sitemap', 'tags', 'tagcloud')); |