· 6 years ago · May 25, 2019, 07:52 PM
1CREATE TABLE `my_db_name`.`_my_table_name_new` (
2 `my_table_name_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
3 `tour_id` int(11) unsigned NOT NULL,
4 `status` enum('new','pending','approved','rejected','deleted') NOT NULL DEFAULT 'new',
5 `fields` varchar(600) NOT NULL,
6 `comment` text NOT NULL,
7 `reject_reasons` varchar(500) DEFAULT NULL,
8 `reject_text` varchar(1000) DEFAULT NULL,
9 `creation_timestamp` datetime NOT NULL,
10 `requester_user_type` enum('staff','supplier') DEFAULT NULL,
11 `update_timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
12 `update_user_type` enum('staff','supplier','reseller','customer','cron_job') DEFAULT NULL,
13 `update_user_id` int(10) unsigned DEFAULT NULL,
14 PRIMARY KEY (`my_table_name_id`),
15 KEY `tour_id_status` (`tour_id`,`status`)
16) ENGINE=InnoDB AUTO_INCREMENT=483132 DEFAULT CHARSET=utf8 COMMENT='5.6' ;
17
18ALTER TABLE `my_db_name`.`_my_table_name_new` ADD COLUMN approve_text TEXT AFTER reject_text;
19
20DROP TABLE IF EXISTS `_my_table_name_new` /* generated by server */
21
22CREATE TABLE `my_db_name`.`_my_table_name_new` (
23 `my_table_name_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
24 `tour_id` int(11) unsigned NOT NULL,
25 `status` enum('new','pending','approved','rejected','deleted') NOT NULL DEFAULT 'new',
26 `fields` varchar(600) NOT NULL,
27 `comment` text NOT NULL,
28 `reject_reasons` varchar(500) DEFAULT NULL,
29 `reject_text` varchar(1000) DEFAULT NULL,
30 `creation_timestamp` datetime NOT NULL,
31 `requester_user_type` enum('staff','supplier') DEFAULT NULL,
32 `update_timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
33 `update_user_type` enum('staff','supplier','reseller','customer','cron_job') DEFAULT NULL,
34 `update_user_id` int(10) unsigned DEFAULT NULL,
35 PRIMARY KEY (`my_table_name_id`),
36 KEY `tour_id_status` (`tour_id`,`status`)
37 ) ENGINE=InnoDB AUTO_INCREMENT=483132 DEFAULT CHARSET=utf8 COMMENT='5.6' ;
38
39ALTER TABLE `my_db_name`.`_my_table_name_new` ADD COLUMN approve_text TEXT AFTER reject_text ;
40
41CREATE DEFINER=`migrator`@`10.81.0.0/255.255.0.0` TRIGGER `pt_osc_my_db_name_my_table_name_del` AFTER DELETE ON `my_db_name`.`my_table_name` FOR EACH ROW DELETE IGNORE FROM `my_db_name`.`_my_table_name_new` WHERE `my_db_name`.`_my_table_name_new`.`my_table_name_id` <=> OLD.`my_table_name_id` ;
42
43CREATE DEFINER=`migrator`@`10.81.0.0/255.255.0.0` TRIGGER `pt_osc_my_db_name_my_table_name_upd` AFTER UPDATE ON `my_db_name`.`my_table_name` FOR EACH ROW BEGIN DELETE IGNORE FROM `my_db_name`.`_my_table_name_new` WHERE !(OLD.`my_table_name_id` <=> NEW.`my_table_name_id`) AND `my_db_name`.`_my_table_name_new`.`my_table_name_id` <=> OLD.`my_table_name_id`;REPLACE INTO `my_db_name`.`_my_table_name_new` (`my_table_name_id`, `tour_id`, `status`, `fields`, `comment`, `reject_reasons`, `reject_text`, `creation_timestamp`, `requester_user_type`, `update_timestamp`, `update_user_type`, `update_user_id`) VALUES (NEW.`my_table_name_id`, NEW.`tour_id`, NEW.`status`, NEW.`fields`, NEW.`comment`, NEW.`reject_reasons`, NEW.`reject_text`, NEW.`creation_timestamp`, NEW.`requester_user_type`, NEW.`update_timestamp`, NEW.`update_user_type`, NEW.`update_user_id`);END
44
45CREATE DEFINER=`migrator`@`10.81.0.0/255.255.0.0` TRIGGER `pt_osc_my_db_name_my_table_name_ins` AFTER INSERT ON `my_db_name`.`my_table_name` FOR EACH ROW REPLACE INTO `my_db_name`.`_my_table_name_new` (`my_table_name_id`, `tour_id`, `status`, `fields`, `comment`, `reject_reasons`, `reject_text`, `creation_timestamp`, `requester_user_type`, `update_timestamp`, `update_user_type`, `update_user_id`) VALUES (NEW.`my_table_name_id`, NEW.`tour_id`, NEW.`status`, NEW.`fields`, NEW.`comment`, NEW.`reject_reasons`, NEW.`reject_text`, NEW.`creation_timestamp`, NEW.`requester_user_type`, NEW.`update_timestamp`, NEW.`update_user_type`, NEW.`update_user_id`)
46
47ANALYZE TABLE `my_db_name`.`_my_table_name_new` /* pt-online-schema-change */
48
49RENAME TABLE `my_db_name`.`my_table_name` TO `my_db_name`.`_my_table_name_old`, `my_db_name`.`_my_table_name_new` TO `my_db_name`.`my_table_name`
50
51DROP TABLE IF EXISTS `_my_table_name_old` /* generated by server */
52
53DROP TRIGGER IF EXISTS `my_db_name`.`pt_osc_my_db_name_my_table_name_del`
54
55DROP TRIGGER IF EXISTS `my_db_name`.`pt_osc_my_db_name_my_table_name_upd`
56
57DROP TRIGGER IF EXISTS `my_db_name`.`pt_osc_my_db_name_my_table_name_ins`