8DEupqcA

1CREATE TABLE IF NOT EXISTS `shop_product_focus_campaign` (
2  `id` int(11) NOT NULL AUTO_INCREMENT,
3  `name` int(11) NOT NULL,
4  `period_from` date NOT NULL,
5  `period_to` date NOT NULL,
6  `order_by` int(11) NOT NULL,
7  `last_modifed_on` datetime NOT NULL,
8  `created_on` datetime NOT NULL,
9  `voided_on` datetime NOT NULL,
10  PRIMARY KEY (`id`)
11);
12
13
14CREATE TABLE `rhino`.`shop_product_focus` (
15`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
16`campaign_id` INT NOT NULL ,
17`product_id` INT NOT NULL ,
18`custom_title` VARCHAR( 255 ) NOT NULL ,
19`order_by` INT NOT NULL ,
20`last_modified_on` DATETIME NOT NULL ,
21`created_on` DATETIME NOT NULL ,
22`voided_on` DATETIME NOT NULL
23);
24
25
26ALTER TABLE `shop_product_focus_campaign` CHANGE `name` `name` VARCHAR( 255 ) NOT NULL