· 8 years ago · Apr 03, 2018, 12:36 PM
1CREATE TABLE IF NOT EXISTS `search_frame` (
2 `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
3 `contragentId` bigint(20) unsigned DEFAULT '0',
4 `frameType` enum('searchHotel','searchPacket','searchTours','searchTransport') DEFAULT NULL,
5 `domain` varchar(512) NOT NULL,
6 `name` varchar(64) NOT NULL,
7 `lang` enum('RU','EN','UA','PL') NOT NULL,
8 PRIMARY KEY (`id`)
9) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=0;