1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38
| -- Structure de la table `regions`
CREATE TABLE IF NOT EXISTS `regions` (
`id_region` int(4) NOT NULL AUTO_INCREMENT,
`id_country` int(4) NOT NULL,
`name_region` varchar(255) NOT NULL,
PRIMARY KEY (`id_region`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2970 ;
--
-- Contenu de la table `regions`
--
INSERT INTO `regions` (`id_region`, `id_country`, `name_region`) VALUES
(1, 1, 'Alsace'),
(2, 1, 'Aquitaine'),
(3, 1, 'Auvergne');
-- Structure de la table `country`
CREATE TABLE IF NOT EXISTS `country` (
`id` int(3) NOT NULL,
`name_country` varchar(255) NOT NULL,
`name_country_uppercase` varchar(255) NOT NULL,
`country_slug` varchar(255) NOT NULL,
`code` varchar(255) NOT NULL,
UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Contenu de la table `country`
--
INSERT INTO `country` (`id`, `name_country`, `name_country_uppercase`, `country_slug`, `code`) VALUES
(1, 'France', 'FRANCE', 'france', 'fr'),
(2, 'Afghanistan', 'AFGHANISTAN', 'afghanistan', 'af'),
(3, 'Afrique du sud', 'AFRIQUE DU SUD', 'afrique-du-sud', 'za'),
(4, 'Albanie', 'ALBANIE', 'albanie', 'al'); |
Partager