ALTER TABLE photo ADD column pub ENUM('private', 'public') DEFAULT 'private' NOT NULL;

