· 6 years ago · Oct 02, 2019, 08:56 AM
1CREATE TABLE IF NOT EXISTS `promos` (
2 `id` int(11) NOT NULL AUTO_INCREMENT,
3 `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
4 `description` text COLLATE utf8mb4_unicode_ci NULL,
5 `image` VARCHAR(255) NULL,
6 `active` tinyint(1) NOT NULL DEFAULT '1' COMMENT 'Активность раздела',
7 `sort` int(1) NOT NULL DEFAULT '0',
8 PRIMARY KEY (`id`)
9) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Промо акции' AUTO_INCREMENT=1 ;