1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
| CREATE TABLE `countries` (
`countries_id` int(11) NOT NULL auto_increment,
`countries_name` varchar(64) NOT NULL default '',
`countries_iso_code_2` char(2) NOT NULL default '',
`countries_iso_code_3` char(3) NOT NULL default '',
`address_format_id` int(11) NOT NULL default '0',
PRIMARY KEY (`countries_id`),
KEY `IDX_COUNTRIES_NAME` (`countries_name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=240 ;
--
-- Contenu de la table `countries`
--
INSERT INTO `countries` (`countries_id`, `countries_name`, `countries_iso_code_2`, `countries_iso_code_3`, `address_format_id`) VALUES
(1, 'Afghanistan', 'AF', 'AFG', 1),
(2, 'Albania', 'AL', 'ALB', 1), |
Partager