· 8 years ago · Jun 15, 2018, 03:06 AM
1CREATE TABLE IF NOT EXISTS `site_hotcampaigns` (
2 `id` int(11) NOT NULL AUTO_INCREMENT,
3 `order_id` int(11) NOT NULL DEFAULT '1',
4 `enabled` enum('0','1') NOT NULL DEFAULT '1',
5 `image_url` text NOT NULL,
6 `caption` text NOT NULL,
7 `descr` text NOT NULL,
8 `url` text NOT NULL,
9 PRIMARY KEY (`id`)
10) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;