-- Lake photo details: alt text, credit, year, permission note and a description,
-- for every gallery file and for the lake's cover photo. All nullable: existing rows keep nulls.
ALTER TABLE `lake_files`
    ADD COLUMN `alt_text` VARCHAR(255) NULL,
    ADD COLUMN `credit` VARCHAR(255) NULL,
    ADD COLUMN `year` VARCHAR(20) NULL,
    ADD COLUMN `permission` VARCHAR(255) NULL,
    ADD COLUMN `description` TEXT NULL;

ALTER TABLE `lakes`
    ADD COLUMN `cover_alt_text` VARCHAR(255) NULL,
    ADD COLUMN `cover_credit` VARCHAR(255) NULL,
    ADD COLUMN `cover_year` VARCHAR(20) NULL,
    ADD COLUMN `cover_permission` VARCHAR(255) NULL,
    ADD COLUMN `cover_description` TEXT NULL;