Rq2rRCvK

1--// change_busOnlineTime
2-- Migration SQL that makes the change goes here.
3
4CREATE TABLE `vistar_marshrut`.`billingDateInrevals` (
5`id` int(11) NOT NULL AUTO_INCREMENT,
6`start_date` datetime NOT NULL,
7`end_date` datetime NOT NULL, 
8PRIMARY KEY (`id`)
9) ENGINE=InnoDB DEFAULT CHARSET=utf8
10GO
11
12ALTER TABLE `vistar_marshrut`.`busOnlineTimes` ADD `billing_time_id` int(11)
13GO
14ALTER TABLE `vistar_marshrut`.`busOnlineTimes` ADD CONSTRAINT `bus_online_times_ibfk_2` FOREIGN KEY (`billing_time_id`) REFERENCES `billingDateInrevals` (`id`)
15GO
16ALTER TABLE `vistar_marshrut`.`busOnlineTimes` DROP `start_date`
17GO
18ALTER TABLE `vistar_marshrut`.`busOnlineTimes` DROP `end_date`
19GO
20
21--//@UNDO
22-- SQL to undo the change goes here.
23
24ALTER TABLE `vistar_marshrut`.`busOnlineTimes` ADD `start_date` datetime NOT NULL
25GO
26ALTER TABLE `vistar_marshrut`.`busOnlineTimes` ADD `end_date` datetime NOT NULL
27GO
28ALTER TABLE `vistar_marshrut`.`busOnlineTimes` DROP FOREIGN KEY `bus_online_times_ibfk_2`
29GO
30ALTER TABLE `vistar_marshrut`.`busOnlineTimes` DROP `billing_time_id`
31GO
32DROP TABLE IF EXISTS `vistar_marshrut`.`billingDateInrevals`
33GO