-- +goose Up
-- The content now lives in the per-blog databases (see 00006 in split.go);
-- the control database keeps only users and the blog registry.
DROP TABLE menu_items, modules, sections, images, posts, pages;
ALTER TABLE blogs DROP COLUMN title, DROP COLUMN tagline, DROP COLUMN theme, DROP COLUMN updated_at;
ALTER TABLE blogs ALTER COLUMN db_name SET NOT NULL;

-- +goose Down
-- Not reversible: the content is gone from this database. Restore from a backup instead.