# Base de donnees: `territoires`
# 

# --------------------------------------------------------

#
# Structure de la table `c2z`
#

CREATE TABLE `c2z` (
  `insee` char(5) NOT NULL default '',
  `zoid` int(11) NOT NULL default '0',
  PRIMARY KEY  (`insee`,`zoid`)
) TYPE=MyISAM;

#
# Contenu de la table `c2z`
#

INSERT INTO `c2z` VALUES ('04001', 5);
INSERT INTO `c2z` VALUES ('04004', 4);
INSERT INTO `c2z` VALUES ('04007', 4);
INSERT INTO `c2z` VALUES ('04009', 5);
INSERT INTO `c2z` VALUES ('04017', 5);
INSERT INTO `c2z` VALUES ('04019', 5);
INSERT INTO `c2z` VALUES ('04020', 5);
INSERT INTO `c2z` VALUES ('04021', 1);
INSERT INTO `c2z` VALUES ('04021', 5);
INSERT INTO `c2z` VALUES ('04024', 5);
INSERT INTO `c2z` VALUES ('04028', 5);
INSERT INTO `c2z` VALUES ('04030', 4);
INSERT INTO `c2z` VALUES ('04031', 5);
INSERT INTO `c2z` VALUES ('04035', 4);
INSERT INTO `c2z` VALUES ('04036', 5);
INSERT INTO `c2z` VALUES ('04039', 4);
INSERT INTO `c2z` VALUES ('04040', 1);
INSERT INTO `c2z` VALUES ('04040', 5);
INSERT INTO `c2z` VALUES ('04046', 5);
INSERT INTO `c2z` VALUES ('04047', 5);
INSERT INTO `c2z` VALUES ('04054', 5);
INSERT INTO `c2z` VALUES ('04055', 5);
INSERT INTO `c2z` VALUES ('04059', 5);
INSERT INTO `c2z` VALUES ('04070', 2);
INSERT INTO `c2z` VALUES ('04070', 5);
INSERT INTO `c2z` VALUES ('04072', 5);
INSERT INTO `c2z` VALUES ('04074', 2);
INSERT INTO `c2z` VALUES ('04074', 5);
INSERT INTO `c2z` VALUES ('04079', 5);
INSERT INTO `c2z` VALUES ('04081', 4);
INSERT INTO `c2z` VALUES ('04084', 5);
INSERT INTO `c2z` VALUES ('04092', 4);
INSERT INTO `c2z` VALUES ('04094', 3);
INSERT INTO `c2z` VALUES ('04094', 4);
INSERT INTO `c2z` VALUES ('04097', 5);
INSERT INTO `c2z` VALUES ('04107', 4);
INSERT INTO `c2z` VALUES ('04108', 5);
INSERT INTO `c2z` VALUES ('04110', 1);
INSERT INTO `c2z` VALUES ('04110', 5);
INSERT INTO `c2z` VALUES ('04112', 3);
INSERT INTO `c2z` VALUES ('04113', 2);
INSERT INTO `c2z` VALUES ('04113', 5);
INSERT INTO `c2z` VALUES ('04121', 5);
INSERT INTO `c2z` VALUES ('04122', 1);
INSERT INTO `c2z` VALUES ('04122', 5);
INSERT INTO `c2z` VALUES ('04123', 5);
INSERT INTO `c2z` VALUES ('04124', 4);
INSERT INTO `c2z` VALUES ('04135', 4);
INSERT INTO `c2z` VALUES ('04144', 4);
INSERT INTO `c2z` VALUES ('04148', 4);
INSERT INTO `c2z` VALUES ('04155', 5);
INSERT INTO `c2z` VALUES ('04157', 4);
INSERT INTO `c2z` VALUES ('04166', 4);
INSERT INTO `c2z` VALUES ('04167', 2);
INSERT INTO `c2z` VALUES ('04167', 5);
INSERT INTO `c2z` VALUES ('04171', 4);
INSERT INTO `c2z` VALUES ('04172', 4);
INSERT INTO `c2z` VALUES ('04173', 4);
INSERT INTO `c2z` VALUES ('04177', 1);
INSERT INTO `c2z` VALUES ('04177', 5);
INSERT INTO `c2z` VALUES ('04180', 5);
INSERT INTO `c2z` VALUES ('04181', 5);
INSERT INTO `c2z` VALUES ('04182', 4);
INSERT INTO `c2z` VALUES ('04182', 5);
INSERT INTO `c2z` VALUES ('04184', 4);
INSERT INTO `c2z` VALUES ('04186', 4);
INSERT INTO `c2z` VALUES ('04187', 5);
INSERT INTO `c2z` VALUES ('04189', 3);
INSERT INTO `c2z` VALUES ('04189', 4);
INSERT INTO `c2z` VALUES ('04191', 5);
INSERT INTO `c2z` VALUES ('04199', 4);
INSERT INTO `c2z` VALUES ('04203', 5);
INSERT INTO `c2z` VALUES ('04204', 5);
INSERT INTO `c2z` VALUES ('04205', 5);
INSERT INTO `c2z` VALUES ('04214', 5);
INSERT INTO `c2z` VALUES ('04217', 1);
INSERT INTO `c2z` VALUES ('04217', 5);
INSERT INTO `c2z` VALUES ('04230', 4);
INSERT INTO `c2z` VALUES ('04235', 5);
INSERT INTO `c2z` VALUES ('04237', 5);
INSERT INTO `c2z` VALUES ('04518', 4);

# --------------------------------------------------------

#
# Structure de la table `communes`
#

CREATE TABLE `communes` (
  `insee` varchar(5) NOT NULL default '',
  `nom` varchar(30) default NULL,
  `habitants` int(11) default NULL,
  PRIMARY KEY  (`insee`)
) TYPE=MyISAM;

#
# Contenu de la table `communes`
#

INSERT INTO `communes` VALUES ('04001', 'Aiglun', 1038);
INSERT INTO `communes` VALUES ('04004', 'Allemagne-en-Provence', 379);
INSERT INTO `communes` VALUES ('04070', 'Digne-les-Bains', 16017);
INSERT INTO `communes` VALUES ('04005', 'Allons', 81);
INSERT INTO `communes` VALUES ('04006', 'Allos', 637);
INSERT INTO `communes` VALUES ('04007', 'Angles', 67);
INSERT INTO `communes` VALUES ('04008', 'Annot', 988);
INSERT INTO `communes` VALUES ('04009', 'Archail', 7);
INSERT INTO `communes` VALUES ('04012', 'Aubenas-les-Alpes', 62);
INSERT INTO `communes` VALUES ('04013', 'Aubignosc', 428);
INSERT INTO `communes` VALUES ('04016', 'Authon', 33);
INSERT INTO `communes` VALUES ('04017', 'Auzet', 87);
INSERT INTO `communes` VALUES ('04018', 'Banon', 878);
INSERT INTO `communes` VALUES ('04019', 'Barcelonnette', 2793);
INSERT INTO `communes` VALUES ('04020', 'Barles', 114);
INSERT INTO `communes` VALUES ('04021', 'Barras', 121);
INSERT INTO `communes` VALUES ('04022', 'Barrème', 433);
INSERT INTO `communes` VALUES ('04023', 'Bayons', 198);
INSERT INTO `communes` VALUES ('04024', 'Beaujeu', 152);
INSERT INTO `communes` VALUES ('04025', 'Beauvezer', 278);
INSERT INTO `communes` VALUES ('04026', 'Bellaffaire', 142);
INSERT INTO `communes` VALUES ('04027', 'Bevons', 131);
INSERT INTO `communes` VALUES ('04028', 'Beynes', 114);
INSERT INTO `communes` VALUES ('04030', 'Blieux', 59);
INSERT INTO `communes` VALUES ('04031', 'Bras-d\'Asse', 395);
INSERT INTO `communes` VALUES ('04032', 'Braux', 118);
INSERT INTO `communes` VALUES ('04033', 'Bréole (La)', 325);
INSERT INTO `communes` VALUES ('04034', 'Brillanne (La)', 765);
INSERT INTO `communes` VALUES ('04035', 'Brunet', 218);
INSERT INTO `communes` VALUES ('04036', 'Brusquet (Le)', 966);
INSERT INTO `communes` VALUES ('04037', 'Caire (Le)', 76);
INSERT INTO `communes` VALUES ('04039', 'Castellane', 1508);
INSERT INTO `communes` VALUES ('04040', 'Castellard-Melan (Le)', 52);
INSERT INTO `communes` VALUES ('04041', 'Castellet (Le)', 202);
INSERT INTO `communes` VALUES ('04042', 'Castellet-lès-Sausses', 106);
INSERT INTO `communes` VALUES ('04045', 'Céreste', 1036);
INSERT INTO `communes` VALUES ('04046', 'Chaffaut-Saint-Jurson (Le)', 672);
INSERT INTO `communes` VALUES ('04047', 'Champtercier', 693);
INSERT INTO `communes` VALUES ('04049', 'Chéteau-Arnoux-Saint-Auban', 4970);
INSERT INTO `communes` VALUES ('04050', 'Châteaufort', 28);
INSERT INTO `communes` VALUES ('04051', 'Châteauneuf-Miravail', 68);
INSERT INTO `communes` VALUES ('04053', 'Châteauneuf-Val-Saint-Donat', 348);
INSERT INTO `communes` VALUES ('04054', 'Châteauredon', 96);
INSERT INTO `communes` VALUES ('04055', 'Chaudon-Norante', 129);
INSERT INTO `communes` VALUES ('04057', 'Clamensane', 131);
INSERT INTO `communes` VALUES ('04058', 'Claret', 249);
INSERT INTO `communes` VALUES ('04059', 'Clumanc', 154);
INSERT INTO `communes` VALUES ('04061', 'Colmars', 378);
INSERT INTO `communes` VALUES ('04062', 'Condamine-Châtelard (La)', 166);
INSERT INTO `communes` VALUES ('04063', 'Corbières', 791);
INSERT INTO `communes` VALUES ('04065', 'Cruis', 551);
INSERT INTO `communes` VALUES ('04066', 'Curbans', 292);
INSERT INTO `communes` VALUES ('04067', 'Curel', 57);
INSERT INTO `communes` VALUES ('04068', 'Dauphin', 796);
INSERT INTO `communes` VALUES ('04069', 'Demandolx', 94);
INSERT INTO `communes` VALUES ('04072', 'Draix', 86);
INSERT INTO `communes` VALUES ('04073', 'Enchastrayes', 504);
INSERT INTO `communes` VALUES ('04074', 'Entrages', 85);
INSERT INTO `communes` VALUES ('04075', 'Entrepierres', 312);
INSERT INTO `communes` VALUES ('04076', 'Entrevaux', 742);
INSERT INTO `communes` VALUES ('04077', 'Entrevennes', 163);
INSERT INTO `communes` VALUES ('04079', 'Escale (L\')', 1166);
INSERT INTO `communes` VALUES ('04081', 'Esparron-de-Verdon', 312);
INSERT INTO `communes` VALUES ('04084', 'Estoublon', 337);
INSERT INTO `communes` VALUES ('04086', 'Faucon-de-Barcelonnette', 208);
INSERT INTO `communes` VALUES ('04085', 'Faucon-du-Caire', 35);
INSERT INTO `communes` VALUES ('04087', 'Fontienne', 116);
INSERT INTO `communes` VALUES ('04088', 'Forcalquier', 4302);
INSERT INTO `communes` VALUES ('04090', 'Fugeret (Le)', 168);
INSERT INTO `communes` VALUES ('04091', 'Ganagobie', 91);
INSERT INTO `communes` VALUES ('04092', 'Garde (La)', 56);
INSERT INTO `communes` VALUES ('04093', 'Gigors', 41);
INSERT INTO `communes` VALUES ('04094', 'Gréoux-les-Bains', 1921);
INSERT INTO `communes` VALUES ('04177', 'Hautes-Duyes', 27);
INSERT INTO `communes` VALUES ('04095', 'Hospitalet (L\')', 78);
INSERT INTO `communes` VALUES ('04096', 'Jausiers', 892);
INSERT INTO `communes` VALUES ('04097', 'Javie (La)', 335);
INSERT INTO `communes` VALUES ('04099', 'Lambruisse', 70);
INSERT INTO `communes` VALUES ('04100', 'Larche', 83);
INSERT INTO `communes` VALUES ('04101', 'Lardiers', 124);
INSERT INTO `communes` VALUES ('04102', 'Lauzet-Ubaye (Le)', 203);
INSERT INTO `communes` VALUES ('04104', 'Limans', 289);
INSERT INTO `communes` VALUES ('04106', 'Lurs', 347);
INSERT INTO `communes` VALUES ('04107', 'Majastres', 8);
INSERT INTO `communes` VALUES ('04108', 'Malijai', 1628);
INSERT INTO `communes` VALUES ('04109', 'Mallefougasse-Augés', 136);
INSERT INTO `communes` VALUES ('04110', 'Mallemoisson', 994);
INSERT INTO `communes` VALUES ('04111', 'Mane', 1169);
INSERT INTO `communes` VALUES ('04112', 'Manosque', 19602);
INSERT INTO `communes` VALUES ('04113', 'Marcoux', 402);
INSERT INTO `communes` VALUES ('04115', 'Méailles', 87);
INSERT INTO `communes` VALUES ('04116', 'Mées (Les)', 2925);
INSERT INTO `communes` VALUES ('04118', 'Melve', 114);
INSERT INTO `communes` VALUES ('04161', 'Méolans-Revel', 284);
INSERT INTO `communes` VALUES ('04120', 'Meyronnes', 44);
INSERT INTO `communes` VALUES ('04121', 'Mézel', 536);
INSERT INTO `communes` VALUES ('04122', 'Mirabeau', 394);
INSERT INTO `communes` VALUES ('04123', 'Mison', 849);
INSERT INTO `communes` VALUES ('04124', 'Montagnac-Montpezat', 321);
INSERT INTO `communes` VALUES ('04126', 'Montclar', 399);
INSERT INTO `communes` VALUES ('04127', 'Montfort', 385);
INSERT INTO `communes` VALUES ('04128', 'Montfuron', 166);
INSERT INTO `communes` VALUES ('04129', 'Montjustin', 60);
INSERT INTO `communes` VALUES ('04130', 'Montlaux', 132);
INSERT INTO `communes` VALUES ('04132', 'Montsalier', 92);
INSERT INTO `communes` VALUES ('04133', 'Moriez', 178);
INSERT INTO `communes` VALUES ('04134', 'Motte-du-Caire (La)', 484);
INSERT INTO `communes` VALUES ('04135', 'Moustiers-Sainte-Marie', 625);
INSERT INTO `communes` VALUES ('04136', 'Mure-Argens (La)', 249);
INSERT INTO `communes` VALUES ('04137', 'Nibles', 42);
INSERT INTO `communes` VALUES ('04138', 'Niozelles', 199);
INSERT INTO `communes` VALUES ('04139', 'Noyers-sur-Jabron', 337);
INSERT INTO `communes` VALUES ('04140', 'Omergues (Les)', 99);
INSERT INTO `communes` VALUES ('04141', 'Ongles', 278);
INSERT INTO `communes` VALUES ('04142', 'Oppedette', 56);
INSERT INTO `communes` VALUES ('04143', 'Oraison', 4114);
INSERT INTO `communes` VALUES ('04144', 'Palud-sur-Verdon (La)', 297);
INSERT INTO `communes` VALUES ('04145', 'Peipin', 1049);
INSERT INTO `communes` VALUES ('04148', 'Peyroules', 136);
INSERT INTO `communes` VALUES ('04149', 'Peyruis', 2217);
INSERT INTO `communes` VALUES ('04150', 'Piégut', 123);
INSERT INTO `communes` VALUES ('04151', 'Pierrerue', 404);
INSERT INTO `communes` VALUES ('04152', 'Pierrevert', 3280);
INSERT INTO `communes` VALUES ('04154', 'Pontis', 45);
INSERT INTO `communes` VALUES ('04155', 'Prads-Haute-Bléone', 145);
INSERT INTO `communes` VALUES ('04156', 'Puimichel', 237);
INSERT INTO `communes` VALUES ('04157', 'Puimoisson', 551);
INSERT INTO `communes` VALUES ('04518', 'Quinson', 350);
INSERT INTO `communes` VALUES ('04159', 'Redortiers', 68);
INSERT INTO `communes` VALUES ('04160', 'Reillanne', 1322);
INSERT INTO `communes` VALUES ('04162', 'Revest-des-Brousses', 200);
INSERT INTO `communes` VALUES ('04163', 'Revest-du-Bion', 463);
INSERT INTO `communes` VALUES ('04164', 'Revest-Saint-Martin', 84);
INSERT INTO `communes` VALUES ('04166', 'Riez', 1667);
INSERT INTO `communes` VALUES ('04167', 'Robine-sur-Galabre (La)', 257);
INSERT INTO `communes` VALUES ('04169', 'Rochegiron (La)', 92);
INSERT INTO `communes` VALUES ('04170', 'Rochette (La)', 53);
INSERT INTO `communes` VALUES ('04171', 'Rougon', 85);
INSERT INTO `communes` VALUES ('04172', 'Roumoules', 631);
INSERT INTO `communes` VALUES ('04173', 'Saint-André-les-Alpes', 818);
INSERT INTO `communes` VALUES ('04174', 'Saint-Benoét', 112);
INSERT INTO `communes` VALUES ('04178', 'Saint-Etienne-les-Orgues', 873);
INSERT INTO `communes` VALUES ('04179', 'Saint-Geniez', 90);
INSERT INTO `communes` VALUES ('04180', 'Saint-Jacques', 36);
INSERT INTO `communes` VALUES ('04181', 'Saint-Jeannet', 38);
INSERT INTO `communes` VALUES ('04182', 'Saint-Julien-d\'Asse', 124);
INSERT INTO `communes` VALUES ('04183', 'Saint-Julien-du-Verdon', 108);
INSERT INTO `communes` VALUES ('04184', 'Saint-Jurs', 151);
INSERT INTO `communes` VALUES ('04186', 'Saint-Laurent-du-Verdon', 74);
INSERT INTO `communes` VALUES ('04187', 'Saint-Lions', 32);
INSERT INTO `communes` VALUES ('04188', 'Saint-Maime', 661);
INSERT INTO `communes` VALUES ('04189', 'Saint-Martin-de-Brômes', 403);
INSERT INTO `communes` VALUES ('04190', 'Saint-Martin-les-Eaux', 104);
INSERT INTO `communes` VALUES ('04191', 'Saint-Martin-lès-Seyne', 22);
INSERT INTO `communes` VALUES ('04192', 'Saint-Michel-l\'Observatoire', 901);
INSERT INTO `communes` VALUES ('04193', 'Saint-Paul-sur-Ubaye', 190);
INSERT INTO `communes` VALUES ('04194', 'Saint-Pierre', 73);
INSERT INTO `communes` VALUES ('04195', 'Saint-Pons', 641);
INSERT INTO `communes` VALUES ('04198', 'Saint-Vincent-les-Forts', 203);
INSERT INTO `communes` VALUES ('04199', 'Saint-Vincent-sur-Jabron', 192);
INSERT INTO `communes` VALUES ('04175', 'Sainte-Croix-à-Lauze', 72);
INSERT INTO `communes` VALUES ('04176', 'Sainte-Croix-de-Verdon', 102);
INSERT INTO `communes` VALUES ('04197', 'Sainte-Tulle', 3052);
INSERT INTO `communes` VALUES ('04200', 'Salignac', 399);
INSERT INTO `communes` VALUES ('04201', 'Saumane', 83);
INSERT INTO `communes` VALUES ('04202', 'Sausses', 65);
INSERT INTO `communes` VALUES ('04203', 'Selonnet', 404);
INSERT INTO `communes` VALUES ('04204', 'Senez', 145);
INSERT INTO `communes` VALUES ('04205', 'Seyne', 1440);
INSERT INTO `communes` VALUES ('04206', 'Sigonce', 319);
INSERT INTO `communes` VALUES ('04207', 'Sigoyer', 75);
INSERT INTO `communes` VALUES ('04208', 'Simiane-la-Rotonde', 532);
INSERT INTO `communes` VALUES ('04209', 'Sisteron', 6964);
INSERT INTO `communes` VALUES ('04210', 'Soleilhas', 95);
INSERT INTO `communes` VALUES ('04211', 'Sourribes', 138);
INSERT INTO `communes` VALUES ('04214', 'Tartonne', 131);
INSERT INTO `communes` VALUES ('04216', 'Thèze', 144);
INSERT INTO `communes` VALUES ('04217', 'Thoard', 646);
INSERT INTO `communes` VALUES ('04218', 'Thorame-Basse', 151);
INSERT INTO `communes` VALUES ('04219', 'Thorame-Haute', 174);
INSERT INTO `communes` VALUES ('04220', 'Thuiles (Les)', 344);
INSERT INTO `communes` VALUES ('04222', 'Turriers', 297);
INSERT INTO `communes` VALUES ('04224', 'Ubraye', 85);
INSERT INTO `communes` VALUES ('04226', 'Uvernet-Fours', 614);
INSERT INTO `communes` VALUES ('04227', 'Vachères', 257);
INSERT INTO `communes` VALUES ('04043', 'Val-de-Chalvagne', 27);
INSERT INTO `communes` VALUES ('04228', 'Valavoire', 214);
INSERT INTO `communes` VALUES ('04229', 'Valbelle', 48);
INSERT INTO `communes` VALUES ('04230', 'Valensole', 2334);
INSERT INTO `communes` VALUES ('04231', 'Valernes', 231);
INSERT INTO `communes` VALUES ('04233', 'Vaumeilh', 197);
INSERT INTO `communes` VALUES ('04234', 'Venterol', 197);
INSERT INTO `communes` VALUES ('04235', 'Verdaches', 48);
INSERT INTO `communes` VALUES ('04236', 'Vergons', 108);
INSERT INTO `communes` VALUES ('04237', 'Vernet (Le)', 104);
INSERT INTO `communes` VALUES ('04240', 'Villars-Colmars', 209);
INSERT INTO `communes` VALUES ('04241', 'Villemus', 111);
INSERT INTO `communes` VALUES ('04242', 'Villeneuve', 2964);
INSERT INTO `communes` VALUES ('04244', 'Volonne', 1514);
INSERT INTO `communes` VALUES ('04245', 'Volx', 2690);

# --------------------------------------------------------

#
# Structure de la table `typeszones`
#

CREATE TABLE `typeszones` (
  `toid` int(11) NOT NULL default '0',
  `nom` varchar(50) default NULL,
  PRIMARY KEY  (`toid`)
) TYPE=MyISAM;

#
# Contenu de la table `typeszones`
#

INSERT INTO `typeszones` VALUES (1, 'Communauté de communes');
INSERT INTO `typeszones` VALUES (2, 'Pays');
INSERT INTO `typeszones` VALUES (3, 'Parc naturel régional');

# --------------------------------------------------------

#
# Structure de la table `zones`
#

CREATE TABLE `zones` (
  `zoid` int(11) NOT NULL default '0',
  `nom` varchar(50) default NULL,
  `typezone` int(11) default NULL,
  PRIMARY KEY  (`zoid`)
) TYPE=MyISAM;

#
# Contenu de la table `zones`
#

INSERT INTO `zones` VALUES (1, 'Communauté de Communes des Duyes-et-Bléone', 1);
INSERT INTO `zones` VALUES (2, 'Communauté de Communes des Trois-Vallées', 1);
INSERT INTO `zones` VALUES (4, 'Parc naturel régional du Verdon', 3);
INSERT INTO `zones` VALUES (5, 'Pays Dignois', 2);
INSERT INTO `zones` VALUES (3, 'Communauté Luberon Durance Verdon', 1);