
DROP TABLE was_openai_author_attribute;
DROP TABLE was_openai_author_attribute_label;
DROP TABLE was_openai_author_attribute_assign;
DROP TABLE was_openai_author_quirk;
DROP TABLE was_openai_author_quirk_assign;

ALTER TABLE was_openai_author
DROP COLUMN `user_id`,
DROP COLUMN `author_narrative`,
ADD COLUMN `author_prompt` TEXT NOT NULL AFTER `author_thumbnail`,
ADD COLUMN `author_membership_level` enum('STARTER', 'PREMIUM', 'PPLUS') DEFAULT 'PPLUS' AFTER `author_prompt`,
ADD COLUMN `author_order` int(11) unsigned NOT NULL AFTER `openai_author_id`;