Skip to content

M
mentha
Switch branch/tag
Find file
BlameHistoryPermalink
qa_add_grab_platform_id.sql 555 Bytes
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 
-- Deploy mimas-qa:qa_add_grab_platform_id to mysql

BEGIN;

--
-- Add field platform_id to answer
--
ALTER TABLE `api_answer` ADD COLUMN `platform_id` varchar(40);
ALTER TABLE `api_answer` ADD COLUMN `platform_tag` varchar(100);
--
-- Add field platform_id to question
--
ALTER TABLE `api_question` ADD COLUMN `platform_id` varchar(40);
ALTER TABLE `api_question` ADD COLUMN `platform_tag` varchar(100);

CREATE INDEX `api_answer_cb857215` ON `api_answer` (`platform_id`);
CREATE INDEX `api_question_cb857215` ON `api_question` (`platform_id`);

COMMIT;