-- +goose Up
-- Special pages (00013) were dropped before release: the kind column and the
-- hidden-files table go, the migration stays so databases that ran it still
-- match the chain.
DROP TABLE page_hidden_files;
ALTER TABLE pages DROP COLUMN kind;

-- +goose Down
ALTER TABLE pages ADD COLUMN kind text NOT NULL DEFAULT 'posts'
    CHECK (kind IN ('posts', 'gallery'));
CREATE TABLE page_hidden_files (
    page_id bigint NOT NULL REFERENCES pages(id) ON DELETE CASCADE,
    file_id uuid   NOT NULL REFERENCES files(id) ON DELETE CASCADE,
    PRIMARY KEY (page_id, file_id)
);