ZBKjcuSw

1DROP TABLE IF EXISTS `orders_packages`;
2CREATE TABLE `orders_packages` (
3  `orders_packages_id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
4  `orders_id` INT(11) UNSIGNED NOT NULL,
5  `orders_packages_status` INT(11) UNSIGNED NOT NULL,
6  `delivery_tracker_id` VARCHAR(255) NULL DEFAULT NULL,
7  `date_delivery_real` TIMESTAMP NULL DEFAULT NULL,
8  `orders_packages_number` INT(11) UNSIGNED NOT NULL DEFAULT '1',
9  `is_deleted` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0',
10  PRIMARY KEY (`orders_packages_id`),
11  UNIQUE INDEX `orders_id_orders_packages_number` (`orders_id`, `orders_packages_number`),
12  INDEX `orders_packages_status` (`orders_packages_status`),
13  INDEX `delivery_tracker_id` (`delivery_tracker_id`)
14)
15  COLLATE='utf8_general_ci'
16  ENGINE=InnoDB
17;