DROP TABLE IF EXISTS `promo`;

CREATE TABLE `promo`? (

? `id` int NOT NULL,

? `promo_naem` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',

? `start_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',

? `item_id` int NOT NULL DEFAULT 0,

? `promo_item_price` double NOT NULL DEFAULT 0,

? PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_unicode_ci ROW_FORMAT = Dynamic;

SET FOREIGN_KEY_CHECKS = 1;