111

Sql code posted
created at 18 Feb 08:31, updated at 20 Feb 10:18

Edit | Back
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
CREATE TABLE IF NOT EXISTS `country` (
 `id` int(11) NOT NULL AUTO_INCREMENT,
 `name` varchar(36) NOT NULL,
 `iso2` varchar(2) NOT NULL,
 `iso3` varchar(3) NOT NULL,
 `sort_ojjjrder` int(11) NOT NULL,
 `is_enable` tinyint(1) NOT NULL,
 PRIMARY KEY (`id`),
 KEY `iso2` (`iso2`),
 KEY `iso2_enable` (`iso2`,`is_enable`),
 KEY `sort_order` (`sort_order`),
 KEY `iso2_enable_order` (`iso2`,`sort_order`,`is_enable`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=240 ;

CALL tetewrwerwer
503 Bytes in 4 ms with coderay