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
| CREATE TABLE `departement` (
`NUMDEPT` char(2) NOT NULL default '',
`NUMREGION` char(32) NOT NULL default '',
`NOMDEPT` char(32) default NULL,
PRIMARY KEY (`NUMDEPT`),
KEY `FK_DEPARTEMENT_REGION` (`NUMREGION`)
) TYPE=MyISAM;
--
-- Contenu de la table `departement`
--
INSERT INTO `departement` VALUES ('1', '22', 'Ain');
INSERT INTO `departement` VALUES ('2', '20', 'Aisne');
INSERT INTO `departement` VALUES ('3', '3', 'Allier');
INSERT INTO `departement` VALUES ('4', '18', 'Alpes de haute provence');
INSERT INTO `departement` VALUES ('5', '18', 'Hautes alpes');
INSERT INTO `departement` VALUES ('6', '18', 'Alpes maritimes');
INSERT INTO `departement` VALUES ('7', '22', 'Ardèche');
INSERT INTO `departement` VALUES ('8', '8', 'Ardennes');
INSERT INTO `departement` VALUES ('9', '16', 'Ariège');
INSERT INTO `departement` VALUES ('10', '8', 'Aube');
INSERT INTO `departement` VALUES ('11', '13', 'Aude');
INSERT INTO `departement` VALUES ('12', '16', 'Aveyron');
INSERT INTO `departement` VALUES ('21', '5', 'Côte d\'or');
INSERT INTO `departement` VALUES ('22', '6', 'Côtes d\'Armor'); |
Partager