INSERT INTO `gen_application` ( `gap_id_application` , `gap_nom` , `gap_description` , `gap_chemin` , `gap_bool_applette` ) VALUES ( '19', 'Inscription', 'Gestionnaire des inscriptions au bottin', 'client/bottin/inscription.php', '0' ); INSERT INTO `gen_application` ( `gap_id_application` , `gap_nom` , `gap_description` , `gap_chemin` , `gap_bool_applette` ) VALUES ( '14', 'Cartographie', 'Cartographie associée au bottin', 'client/bottin/cartographie.php', '0' ); INSERT INTO `gen_application` ( `gap_id_application` , `gap_nom` , `gap_description` , `gap_chemin` , `gap_bool_applette` ) VALUES ( '15', 'Annuaire', 'Annuaire associée au bottin', 'client/bottin/annuaire.php', '0' ); INSERT INTO `gen_application` ( `gap_id_application` , `gap_nom` , `gap_description` , `gap_chemin` , `gap_bool_applette` ) VALUES ( '22', 'Cartographie google associée au bottin', 'Cartographie google associée au bottin', 'client/bottin/annuaire.php', '0' ); INSERT INTO `gen_application` ( `gap_id_application` , `gap_nom` , `gap_description` , `gap_chemin` , `gap_bool_applette` ) VALUES ( '23', 'Administration de l\'annuaire', '', 'client/bottin/annuaire_backoffice.php', '0' ); -- -- Structure de la table `annuaire` -- CREATE TABLE `annuaire` ( `a_id` int(11) unsigned NOT NULL default '0', `a_ce_i18n` varchar(8) NOT NULL default '', `a_nom` varchar(32) NOT NULL default '', `a_prenom` varchar(32) NOT NULL default '', `a_profession` varchar(255) NOT NULL default '', `a_mot_de_passe` varchar(32) NOT NULL default 'X X', `a_mail` varchar(128) NOT NULL default '', `a_nom_wikini` varchar(255) NOT NULL default '', `a_adresse1` text, `a_adresse2` text, `a_telephone` varchar(32) NOT NULL default '', `a_fax` varchar(32) NOT NULL default '', `a_code_postal` varchar(32) default NULL, `a_ville` varchar(255) default NULL, `a_ce_pays` char(3) default NULL, `a_region` varchar(255) default NULL, `a_code_insee_commune` varchar(255) default NULL, `a_numero_dpt` int(10) unsigned default NULL, `a_date_inscription` datetime NOT NULL default '0000-00-00 00:00:00', `a_est_structure` tinyint(3) unsigned NOT NULL default '0', `a_structure` varchar(255) NOT NULL default '', `a_appartient_structure` int(10) unsigned NOT NULL default '0', `a_sigle_structure` varchar(64) NOT NULL default '', `a_num_agrement_fpc` varchar(64) NOT NULL default '', `a_lettre` tinyint(3) unsigned NOT NULL default '0', `a_site_internet` varchar(255) default NULL, `a_voir_sur_carto` tinyint(3) unsigned NOT NULL default '0', `a_logo` varchar(255) NOT NULL default '', `a_latitude` float NOT NULL default '0', `a_longitude` float NOT NULL default '0', `a_ce_id_inscription` tinyint(3) unsigned NOT NULL default '0', PRIMARY KEY (`a_id`) ); -- -------------------------------------------------------- -- -- Structure de la table `inscription_demande` -- DROP TABLE IF EXISTS `inscription_demande`; CREATE TABLE IF NOT EXISTS `inscription_demande` ( `id_identifiant_session` varchar(32) NOT NULL default '', `id_donnees` text NOT NULL, `id_date` date NOT NULL default '0000-00-00', PRIMARY KEY (`id_identifiant_session`) ); -- -------------------------------------------------------- -- -- Structure de la table `inscription_template` -- DROP TABLE IF EXISTS `inscription_template`; CREATE TABLE `inscription_template` ( `it_id_template` smallint(5) unsigned NOT NULL default '0', `it_ce_inscription` tinyint(3) unsigned NOT NULL default '0', `it_nom_template` varchar(255) NOT NULL default '', `it_i18n` varchar(5) NOT NULL default '', `it_template` text NOT NULL, `it_documentation` text NOT NULL, PRIMARY KEY (`it_id_template`,`it_ce_inscription`,`it_i18n`) ) ; -- -------------------------------------------------------- -- -- Contenu de la table `inscription_template` -- INSERT INTO `inscription_template` VALUES (1, 1, 'Modèle de la page d\'accueil de l\'inscription', 'fr-FR', '

Réseau

\r\nInscription :\r\n', ''); INSERT INTO `inscription_template` VALUES (2, 1, 'Mail pour confirmer une inscription (corps)', 'fr-FR', 'Bonjour,\r\n\r\nNous avons bien reçu votre demande d\'inscription au site,p\r\n\r\nPour confirmer, veuillez cliquer sur le lien ci-dessous :\r\n{URL_INSCRIPTION}\r\n\r\nL\'équipe. ', '{URL_INSCRIPTION} sera remplacé par l\'url de l\'inscription'); INSERT INTO `inscription_template` VALUES (3, 1, 'Template de l\'inscription', 'fr-FR', 'champs_mail***a_mail***Adresse mail***40***255*** *** *** ***1***1\r\ntexte***a_nom***Nom***30***50*** *** *** ***1***0\r\ntexte***a_prenom***Prénom***30***50*** *** *** ***1***0\r\nmot_de_passe***a_mot_de_passe***Mot de passe****10***10***Erreur***Répéter le mot de passe***1***Vous devez saisir un mot de passe***\r\ntexte***a_adresse1***Adresse***30***50*** *** *** ***1***0\r\ntexte***a_adresse2***Adresse (suite)***30***50*** *** *** ***0***0\r\ntexte***a_code_postal***Code postal***8***8*** *** *** ***1***0\r\ntexte***a_ville***Ville***30***50*** *** *** ***1***0\r\nliste***a_ce_pays***Pays***400*** ***fr***gen_i18n_pays,gip_id_pays,gip_nom_pays_traduit,gip_id_i18n,fr-FR***gip_id_pays*** ***\r\ntexte***a_telephone***Téléphone***15***15*** *** *** ***0***0\r\nlabelhtml*** ***
*** *** *** *** *** *** \r\ncheckbox***a_lettre***Je souhaite recevoir la lettre d\'actualité*** *** ***1*** *** *** \r\n', 'type***mon_du_champs_dans_base***label_en_français***taille_en_caractère***
longueur_maximum(maxlength)***valeur_par_defaut***table_source(pour les listes)***
col_identifiant(pour les listes)***champs_obligatoire(0 ou 1)***
apparaitre_dans_le moteur_de_recherche(0 ou 1):'); INSERT INTO `inscription_template` VALUES (4, 1, 'Mail pour confirmer une inscription (sujet)', 'fr-FR', '[mon_site.fr] Demande d\'inscription', 'une phrase simple'); INSERT INTO `inscription_template` VALUES (5, 1, 'Modèle mail mot de passe perdu (sujet)', 'fr-FR', 'Changement de mot de passe', 'Un texte simple pour le sujet de l\'email'); INSERT INTO `inscription_template` VALUES (6, 1, 'Modèle mail mot de passe perdu (corps)', 'fr-FR', 'Votre nouveau mot de passe : {MOT_DE_PASSE}\r\n\r\nCe mot de passe vous permet de modifier les informations vous concernant dans le site de mon_site.fr.\r\n\r\nIdentifiez-vous sur l\'un de ces sites, puis vous pourrez changer votre mot de passe en cliquant sur "Modifier votre inscription".\r\n\r\n', 'Utiliser la variable {MOT_DE_PASSE} pour afficher le nouveau mot de passe.'); INSERT INTO `inscription_template` VALUES (7, 1, 'Mail après modération acceptée (sujet)', 'fr-FR', '[mon_site] Confirmation d\'inscription', 'Une phrase simple'); INSERT INTO `inscription_template` VALUES (8, 1, 'Mail après modération acceptée (corps)', 'fr-FR', 'Bienvenue à la plateforme . \r\n\r\n\r\nVotre inscription sur la plateforme collaborative http://mon_site.fr a bien été prise en compte.\r\n\r\nVous pouvez maintenant retourner sur le site afin de vous identifiez et d\'accéder à l\'ensemble des fonctionnalités collaboratives.\r\n\r\n\r\nCe que vous propose la plateforme : \r\n- \r\n\r\nL\'équipe ', 'Un texte simple.'); INSERT INTO `inscription_template` VALUES (9, 1, 'Modèle du titre du formulaire', 'fr-FR', '

Ajout d\'un nouveau membre acteur

', 'Modele du titre du formulaire (ce qui precede le formulaire).'); INSERT INTO `inscription_template` VALUES (10, 1, 'Message après demande d\'inscription modére', 'fr-FR', '

Demande d\'inscription réseau

\r\n

\r\n
\r\nVotre demande d\'inscription à la plate-forme a bien été prise en compte. \r\n
\r\nElle a été transmise au modérateur du réseau. \r\n
\r\nVous recevrez un email de confirmation lorsque ce modérateur aura rendu effective votre inscription.\r\n
\r\n
\r\nCordialement\r\n

\r\nL\'équipe.
', 'Un message en HTML, penser à mettre un titre .. balise h1'); CREATE TABLE `inscription_configuration` ( `ic_id_inscription` tinyint(3) unsigned NOT NULL default '0', `ic_nom_inscription` varchar(255) NOT NULL default '1', `ic_url_bazar` varchar(255) NOT NULL default '', `ic_inscription_modere` tinyint(4) NOT NULL default '0', `ic_mail_moderateur` text NOT NULL, `ic_from_mail_confirmation` varchar(255) NOT NULL default '', `ic_utilise_nom_wiki` tinyint(4) NOT NULL default '1', `ic_genere_nom_wiki` tinyint(4) NOT NULL default '0', `ic_utilise_reecriture_url` tinyint(4) NOT NULL default '0', `ic_url_prefixe` varchar(255) NOT NULL default '', `ic_mail_valide_inscription` tinyint(4) NOT NULL default '0', `ic_mail_admin_apres_inscription` text NOT NULL, `ic_mail_inscription_news` varchar(255) NOT NULL default '', `ic_mail_desinscription_news` varchar(255) NOT NULL default '', PRIMARY KEY (`ic_id_inscription`) ); INSERT INTO `inscription_configuration` (`ic_id_inscription`, `ic_nom_inscription`, `ic_url_bazar`, `ic_inscription_modere`, `ic_mail_moderateur`, `ic_from_mail_confirmation`, `ic_utilise_nom_wiki`, `ic_genere_nom_wiki`, `ic_utilise_reecriture_url`, `ic_url_prefixe`, `ic_mail_valide_inscription`, `ic_mail_admin_apres_inscription`, `ic_mail_inscription_news`, `ic_mail_desinscription_news`) VALUES (1, 'inscription grand public', '', 0, '', '', 1, 1, 0, 'ins_', 0, '', '', ''); CREATE TABLE `inscription_attente` ( `ia_id_inscription` varchar(255) NOT NULL default '', `ia_donnees` text NOT NULL, `ia_date` date NOT NULL default '0000-00-00', PRIMARY KEY (`ia_id_inscription`) ); -- -------------------------------------------------------- -- -- Structure de la table `interwikini_users` pour faire des inscriptions avec wikini (OPTIONNELLE) -- DROP TABLE IF EXISTS `interwikini_users`; CREATE TABLE `interwikini_users` ( `name` varchar(80) NOT NULL default '', `password` varchar(32) NOT NULL default '', `email` varchar(50) NOT NULL default '', `motto` text NOT NULL, `revisioncount` int(10) unsigned NOT NULL default '20', `changescount` int(10) unsigned NOT NULL default '50', `doubleclickedit` enum('Y','N') NOT NULL default 'Y', `signuptime` datetime NOT NULL default '0000-00-00 00:00:00', `show_comments` enum('Y','N') NOT NULL default 'N', PRIMARY KEY (`name`), KEY `idx_name` (`name`), KEY `idx_signuptime` (`signuptime`) ); -- -------------------------------------------------------- -- -- Structure de la table `gen_departement` -- DROP TABLE IF EXISTS `gen_departement`; CREATE TABLE `gen_departement` ( `gd_id_departement` int(11) NOT NULL default '0', `gd_nom` varchar(100) NOT NULL default '', `gd_region` int(11) NOT NULL default '900', PRIMARY KEY (`gd_id_departement`) ); -- -- Contenu de la table `gen_departement` -- INSERT INTO `gen_departement` VALUES (1, 'Ain', 22); INSERT INTO `gen_departement` VALUES (2, 'Aisne', 19); INSERT INTO `gen_departement` VALUES (3, 'Allier', 3); INSERT INTO `gen_departement` VALUES (4, 'Alpes-de-Haute-Provence', 21); INSERT INTO `gen_departement` VALUES (5, 'Hautes-Alpes', 21); INSERT INTO `gen_departement` VALUES (6, 'Alpes-Maritimes', 21); INSERT INTO `gen_departement` VALUES (7, 'Ardèche', 22); INSERT INTO `gen_departement` VALUES (8, 'Ardennes', 8); INSERT INTO `gen_departement` VALUES (9, 'Ariège', 16); INSERT INTO `gen_departement` VALUES (10, 'Aube', 8); INSERT INTO `gen_departement` VALUES (11, 'Aude', 13); INSERT INTO `gen_departement` VALUES (12, 'Aveyron', 16); INSERT INTO `gen_departement` VALUES (13, 'Bouches-du-Rhône', 21); INSERT INTO `gen_departement` VALUES (14, 'Calvados', 4); INSERT INTO `gen_departement` VALUES (15, 'Cantal', 3); INSERT INTO `gen_departement` VALUES (16, 'Charente', 20); INSERT INTO `gen_departement` VALUES (17, 'Charente-Maritime', 20); INSERT INTO `gen_departement` VALUES (18, 'Cher', 7); INSERT INTO `gen_departement` VALUES (19, 'Corrèze', 14); INSERT INTO `gen_departement` VALUES (20, 'Corse', 9); INSERT INTO `gen_departement` VALUES (21, 'Côte-d''Or', 5); INSERT INTO `gen_departement` VALUES (22, 'Côtes-d''Armor', 6); INSERT INTO `gen_departement` VALUES (23, 'Creuse', 14); INSERT INTO `gen_departement` VALUES (24, 'Dordogne', 2); INSERT INTO `gen_departement` VALUES (25, 'Doubs', 10); INSERT INTO `gen_departement` VALUES (26, 'Drôme', 22); INSERT INTO `gen_departement` VALUES (27, 'Eure', 11); INSERT INTO `gen_departement` VALUES (28, 'Eure-et-Loir', 7); INSERT INTO `gen_departement` VALUES (29, 'Finistère', 6); INSERT INTO `gen_departement` VALUES (30, 'Gard', 13); INSERT INTO `gen_departement` VALUES (31, 'Haute-Garonne', 16); INSERT INTO `gen_departement` VALUES (32, 'Gers', 16); INSERT INTO `gen_departement` VALUES (33, 'Gironde', 2); INSERT INTO `gen_departement` VALUES (34, 'Hérault', 13); INSERT INTO `gen_departement` VALUES (35, 'Ille-et-Vilaine', 6); INSERT INTO `gen_departement` VALUES (36, 'Indre', 7); INSERT INTO `gen_departement` VALUES (37, 'Indre-et-Loire', 7); INSERT INTO `gen_departement` VALUES (38, 'Isère', 22); INSERT INTO `gen_departement` VALUES (39, 'Jura', 10); INSERT INTO `gen_departement` VALUES (40, 'Landes', 2); INSERT INTO `gen_departement` VALUES (41, 'Loir-et-Cher', 7); INSERT INTO `gen_departement` VALUES (42, 'Loire', 22); INSERT INTO `gen_departement` VALUES (43, 'Haute-Loire', 3); INSERT INTO `gen_departement` VALUES (44, 'Loire-Atlantique', 18); INSERT INTO `gen_departement` VALUES (45, 'Loiret', 7); INSERT INTO `gen_departement` VALUES (46, 'Lot', 16); INSERT INTO `gen_departement` VALUES (47, 'Lot-et-Garonne', 2); INSERT INTO `gen_departement` VALUES (48, 'Lozére', 13); INSERT INTO `gen_departement` VALUES (49, 'Maine-et-Loire', 18); INSERT INTO `gen_departement` VALUES (50, 'Manche', 4); INSERT INTO `gen_departement` VALUES (51, 'Marne', 8); INSERT INTO `gen_departement` VALUES (52, 'Haute-Marne', 8); INSERT INTO `gen_departement` VALUES (53, 'Mayenne', 18); INSERT INTO `gen_departement` VALUES (54, 'Meurthe-et-Moselle', 15); INSERT INTO `gen_departement` VALUES (55, 'Meuse', 15); INSERT INTO `gen_departement` VALUES (56, 'Morbihan', 6); INSERT INTO `gen_departement` VALUES (57, 'Moselle', 15); INSERT INTO `gen_departement` VALUES (58, 'Nièvre', 5); INSERT INTO `gen_departement` VALUES (59, 'Nord', 17); INSERT INTO `gen_departement` VALUES (60, 'Oise', 19); INSERT INTO `gen_departement` VALUES (61, 'Orne', 4); INSERT INTO `gen_departement` VALUES (62, 'Pas-de-Calais', 17); INSERT INTO `gen_departement` VALUES (63, 'Puy-de-Dôme', 3); INSERT INTO `gen_departement` VALUES (64, 'Pyrénées-Atlantiques', 2); INSERT INTO `gen_departement` VALUES (65, 'Hautes-Pyrénées', 16); INSERT INTO `gen_departement` VALUES (66, 'Pyrénées-Orientales', 13); INSERT INTO `gen_departement` VALUES (67, 'Bas-Rhin', 1); INSERT INTO `gen_departement` VALUES (68, 'Haut-Rhin', 1); INSERT INTO `gen_departement` VALUES (69, 'Rhône', 22); INSERT INTO `gen_departement` VALUES (70, 'Haute-Saône', 10); INSERT INTO `gen_departement` VALUES (71, 'Saône-et-Loire', 5); INSERT INTO `gen_departement` VALUES (72, 'Sarthe', 18); INSERT INTO `gen_departement` VALUES (73, 'Savoie', 22); INSERT INTO `gen_departement` VALUES (74, 'Haute-Savoie', 22); INSERT INTO `gen_departement` VALUES (75, 'Paris', 12); INSERT INTO `gen_departement` VALUES (76, 'Seine-Maritime', 11); INSERT INTO `gen_departement` VALUES (77, 'Seine-et-Marne', 12); INSERT INTO `gen_departement` VALUES (78, 'Yvelines', 12); INSERT INTO `gen_departement` VALUES (79, 'Deux-Sèvres', 20); INSERT INTO `gen_departement` VALUES (80, 'Somme', 19); INSERT INTO `gen_departement` VALUES (81, 'Tarn', 16); INSERT INTO `gen_departement` VALUES (82, 'Tarn-et-Garonne', 16); INSERT INTO `gen_departement` VALUES (83, 'Var', 21); INSERT INTO `gen_departement` VALUES (84, 'Vaucluse', 21); INSERT INTO `gen_departement` VALUES (85, 'Vendée', 18); INSERT INTO `gen_departement` VALUES (86, 'Vienne', 20); INSERT INTO `gen_departement` VALUES (87, 'Haute-Vienne', 14); INSERT INTO `gen_departement` VALUES (88, 'Vosges', 15); INSERT INTO `gen_departement` VALUES (89, 'Yonne', 5); INSERT INTO `gen_departement` VALUES (90, 'Territoire-de-Belfort', 10); INSERT INTO `gen_departement` VALUES (91, 'Essonne', 12); INSERT INTO `gen_departement` VALUES (92, 'Hauts-de-Seine', 12); INSERT INTO `gen_departement` VALUES (93, 'Seine-Saint-Denis', 12); INSERT INTO `gen_departement` VALUES (94, 'Val-de-Marne', 12); INSERT INTO `gen_departement` VALUES (95, 'Val-d''Oise', 12); INSERT INTO `gen_departement` VALUES (99, 'Etranger', 900); INSERT INTO `gen_departement` VALUES (971, 'Guadeloupe', 900); INSERT INTO `gen_departement` VALUES (972, 'Martinique', 900); INSERT INTO `gen_departement` VALUES (973, 'Guyane', 900); INSERT INTO `gen_departement` VALUES (974, 'Réunion', 900); INSERT INTO `gen_departement` VALUES (975, 'St-Pierre-et-Miquelon', 900); INSERT INTO `gen_departement` VALUES (976, 'Mayotte', 900); INSERT INTO `gen_departement` VALUES (980, 'Monaco', 900); INSERT INTO `gen_departement` VALUES (986, 'Wallis-et-Futuna', 900); INSERT INTO `gen_departement` VALUES (987, 'Polynésie-Française', 900); INSERT INTO `gen_departement` VALUES (988, 'Nouvelle-Calédonie', 900); INSERT INTO `gen_departement` VALUES (900, '', 900); # # Structure de la table `carto_ACTION` # CREATE TABLE `carto_ACTION` ( `CA_ID_Projet_Carto` int(11) NOT NULL default '0', `CA_ID_Carte` varchar(32) NOT NULL default '', `CA_ID_Zone_geo` varchar(255) NOT NULL default '', `CA_Type_zone` int(11) NOT NULL default '0', `CA_Action` varchar(10) NOT NULL default '', `CA_ID_Carte_destination` varchar(32) NOT NULL default '', PRIMARY KEY (`CA_ID_Projet_Carto`,`CA_ID_Carte`,`CA_ID_Zone_geo`,`CA_Type_zone`,`CA_ID_Carte_destination`,`CA_Action`), KEY `CA_PROJECT` (`CA_ID_Carte`) ); # # Contenu de la table `carto_ACTION` # INSERT INTO `carto_ACTION` VALUES (1, 'afrique', '0', 2, 'Recharger', ''); INSERT INTO `carto_ACTION` VALUES (1, 'afrique', 'ao', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'afrique', 'bf', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'afrique', 'bi', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'afrique', 'bj', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'afrique', 'bw', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'afrique', 'cd', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'afrique', 'cf', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'afrique', 'cg', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'afrique', 'ci', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'afrique', 'cm', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'afrique', 'cv', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'afrique', 'dj', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'afrique', 'dz', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'afrique', 'eg', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'afrique', 'er', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'afrique', 'et', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'afrique', 'ga', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'afrique', 'gh', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'afrique', 'gm', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'afrique', 'gn', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'afrique', 'gq', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'afrique', 'gw', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'afrique', 'ke', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'afrique', 'km', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'afrique', 'lr', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'afrique', 'ls', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'afrique', 'ly', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'afrique', 'ma', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'afrique', 'mg', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'afrique', 'ml', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'afrique', 'mr', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'afrique', 'mu', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'afrique', 'mw', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'afrique', 'mz', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'afrique', 'na', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'afrique', 'ne', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'afrique', 'ng', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'afrique', 'rw', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'afrique', 'sc', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'afrique', 'sd', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'afrique', 'sl', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'afrique', 'sn', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'afrique', 'so', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'afrique', 'st', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'afrique', 'sz', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'afrique', 'td', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'afrique', 'tg', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'afrique', 'tn', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'afrique', 'tz', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'afrique', 'ug', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'afrique', 'za', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'afrique', 'zm', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'afrique', 'zw', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'asie', '0', 2, 'Recharger', ''); INSERT INTO `carto_ACTION` VALUES (1, 'asie', 'bd', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'asie', 'bn', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'asie', 'bt', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'asie', 'cn', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'asie', 'id', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'asie', 'in', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'asie', 'jp', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'asie', 'kh', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'asie', 'kp', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'asie', 'kr', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'asie', 'kz', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'asie', 'la', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'asie', 'lk', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'asie', 'mm', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'asie', 'mn', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'asie', 'mv', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'asie', 'my', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'asie', 'np', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'asie', 'ph', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'asie', 'rua', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'asie', 'sg', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'asie', 'th', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'asie', 'tw', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'asie', 'vn', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'continent', '0', 1, 'Recharger', ''); INSERT INTO `carto_ACTION` VALUES (1, 'continent', '1', 1, 'Aller_a', 'afrique'); INSERT INTO `carto_ACTION` VALUES (1, 'continent', '2', 1, 'Aller_a', 'namerique'); INSERT INTO `carto_ACTION` VALUES (1, 'continent', '3', 1, 'Aller_a', 'asie'); INSERT INTO `carto_ACTION` VALUES (1, 'continent', '4', 1, 'Aller_a', 'europe'); INSERT INTO `carto_ACTION` VALUES (1, 'continent', '5', 1, 'Aller_a', 'oceanie'); INSERT INTO `carto_ACTION` VALUES (1, 'continent', '6', 1, 'Aller_a', 'samerique'); INSERT INTO `carto_ACTION` VALUES (1, 'continent', '7', 1, 'Aller_a', 'moyenorient'); INSERT INTO `carto_ACTION` VALUES (1, 'europe', '0', 2, 'Recharger', ''); INSERT INTO `carto_ACTION` VALUES (1, 'europe', 'al', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'europe', 'an', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'europe', 'at', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'europe', 'ba', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'europe', 'be', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'europe', 'bg', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'europe', 'by', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'europe', 'ch', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'europe', 'cy', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'europe', 'cz', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'europe', 'de', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'europe', 'dk', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'europe', 'ee', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'europe', 'es', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'europe', 'fi', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'europe', 'fr', 2, 'Aller_a', 'france'); INSERT INTO `carto_ACTION` VALUES (1, 'europe', 'gr', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'europe', 'hr', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'europe', 'hu', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'europe', 'ie', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'europe', 'is', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'europe', 'it', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'europe', 'li', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'europe', 'lt', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'europe', 'lu', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'europe', 'lv', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'europe', 'mc', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'europe', 'md', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'europe', 'mk', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'europe', 'mt', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'europe', 'nl', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'europe', 'no', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'europe', 'pl', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'europe', 'pt', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'europe', 'ro', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'europe', 'ru', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'europe', 'se', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'europe', 'si', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'europe', 'sk', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'europe', 'sm', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'europe', 'ua', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'europe', 'uk', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'europe', 'yu', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'france', '1', 4, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'france', '10', 4, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'france', '11', 4, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'france', '12', 4, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'france', '13', 4, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'france', '14', 4, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'france', '15', 4, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'france', '16', 4, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'france', '17', 4, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'france', '18', 4, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'france', '19', 4, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'france', '2', 4, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'france', '20', 4, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'france', '21', 4, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'france', '22', 4, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'france', '23', 4, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'france', '24', 4, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'france', '25', 4, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'france', '26', 4, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'france', '27', 4, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'france', '28', 4, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'france', '29', 4, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'france', '3', 4, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'france', '30', 4, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'france', '31', 4, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'france', '32', 4, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'france', '33', 4, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'france', '34', 4, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'france', '35', 4, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'france', '36', 4, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'france', '37', 4, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'france', '38', 4, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'france', '39', 4, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'france', '4', 4, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'france', '40', 4, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'france', '41', 4, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'france', '42', 4, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'france', '43', 4, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'france', '44', 4, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'france', '45', 4, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'france', '46', 4, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'france', '47', 4, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'france', '48', 4, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'france', '49', 4, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'france', '5', 4, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'france', '50', 4, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'france', '51', 4, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'france', '52', 4, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'france', '53', 4, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'france', '54', 4, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'france', '55', 4, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'france', '56', 4, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'france', '57', 4, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'france', '58', 4, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'france', '59', 4, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'france', '6', 4, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'france', '60', 4, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'france', '61', 4, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'france', '62', 4, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'france', '63', 4, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'france', '64', 4, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'france', '65', 4, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'france', '66', 4, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'france', '67', 4, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'france', '68', 4, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'france', '69', 4, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'france', '7', 4, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'france', '70', 4, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'france', '71', 4, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'france', '72', 4, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'france', '73', 4, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'france', '74', 4, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'france', '75', 4, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'france', '76', 4, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'france', '77', 4, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'france', '78', 4, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'france', '79', 4, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'france', '8', 4, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'france', '80', 4, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'france', '81', 4, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'france', '82', 4, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'france', '83', 4, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'france', '84', 4, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'france', '85', 4, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'france', '86', 4, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'france', '87', 4, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'france', '88', 4, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'france', '89', 4, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'france', '9', 4, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'france', '90', 4, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'france', '91', 4, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'france', '92', 4, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'france', '93', 4, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'france', '94', 4, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'france', '95', 4, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'france', '971', 4, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'france', '972', 4, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'france', '973', 4, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'france', '974', 4, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'france', '975', 4, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'france', '976', 4, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'france', '980', 4, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'france', '986', 4, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'france', '987', 4, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'france', '988', 4, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'france', '99', 4, 'Recharger', ''); INSERT INTO `carto_ACTION` VALUES (1, 'moyenorient', '0', 2, 'Recharger', ''); INSERT INTO `carto_ACTION` VALUES (1, 'moyenorient', 'ae', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'moyenorient', 'af', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'moyenorient', 'am', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'moyenorient', 'az', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'moyenorient', 'bh', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'moyenorient', 'ge', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'moyenorient', 'il', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'moyenorient', 'iq', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'moyenorient', 'ir', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'moyenorient', 'jo', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'moyenorient', 'kg', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'moyenorient', 'kw', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'moyenorient', 'lb', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'moyenorient', 'om', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'moyenorient', 'pk', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'moyenorient', 'ps', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'moyenorient', 'qa', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'moyenorient', 'sa', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'moyenorient', 'sy', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'moyenorient', 'tj', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'moyenorient', 'tm', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'moyenorient', 'tr', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'moyenorient', 'uz', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'moyenorient', 'ye', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'namerique', '0', 2, 'Recharger', ''); INSERT INTO `carto_ACTION` VALUES (1, 'namerique', 'ag', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'namerique', 'bb', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'namerique', 'bs', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'namerique', 'bz', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'namerique', 'ca', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'namerique', 'cr', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'namerique', 'cu', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'namerique', 'dm', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'namerique', 'gd', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'namerique', 'gl', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'namerique', 'gt', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'namerique', 'hn', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'namerique', 'ht', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'namerique', 'jm', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'namerique', 'lc', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'namerique', 'mx', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'namerique', 'ni', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'namerique', 'pa', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'namerique', 'sv', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'namerique', 'tt', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'namerique', 'us', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'namerique', 'vc', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'oceanie', '0', 2, 'Recharger', ''); INSERT INTO `carto_ACTION` VALUES (1, 'oceanie', 'au', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'oceanie', 'fj', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'oceanie', 'fm', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'oceanie', 'ki', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'oceanie', 'mh', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'oceanie', 'nr', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'oceanie', 'nz', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'oceanie', 'pg', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'oceanie', 'pw', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'oceanie', 'sb', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'oceanie', 'to', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'oceanie', 'tv', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'oceanie', 'vu', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'oceanie', 'ws', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'samerique', '0', 2, 'Recharger', ''); INSERT INTO `carto_ACTION` VALUES (1, 'samerique', 'ar', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'samerique', 'bo', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'samerique', 'br', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'samerique', 'cl', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'samerique', 'co', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'samerique', 'ec', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'samerique', 'gy', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'samerique', 'pe', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'samerique', 'py', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'samerique', 'sr', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'samerique', 'uy', 2, 'Stop', ''); INSERT INTO `carto_ACTION` VALUES (1, 'samerique', 've', 2, 'Stop', ''); # -------------------------------------------------------- # # Structure de la table `carto_CONTINENT` # CREATE TABLE `carto_CONTINENT` ( `CC_ID_Continent` tinyint(4) unsigned NOT NULL default '0', `CC_Intitule_continent` varchar(100) NOT NULL default '', `CC_Couleur_R` tinyint(4) unsigned NOT NULL default '0', `CC_Couleur_V` tinyint(4) unsigned NOT NULL default '0', `CC_Couleur_B` tinyint(4) unsigned NOT NULL default '0' ); # # Contenu de la table `carto_CONTINENT` # INSERT INTO `carto_CONTINENT` VALUES (1, 'Afrique', 60, 174, 15); INSERT INTO `carto_CONTINENT` VALUES (2, 'Amérique du Nord', 128, 218, 141); INSERT INTO `carto_CONTINENT` VALUES (3, 'Asie', 189, 179, 25); INSERT INTO `carto_CONTINENT` VALUES (4, 'Europe', 0, 128, 218); INSERT INTO `carto_CONTINENT` VALUES (5, 'Océanie', 206, 0, 0); INSERT INTO `carto_CONTINENT` VALUES (6, 'Amérique du Sud', 255, 125, 0); INSERT INTO `carto_CONTINENT` VALUES (7, 'Moyen-Orient', 0, 0, 255); INSERT INTO `carto_CONTINENT` VALUES (0, ' ', 255, 255, 255); # -------------------------------------------------------- # # Structure de la table `carto_DEPARTEMENT` # CREATE TABLE `carto_DEPARTEMENT` ( `CD_ID_Departement` smallint(3) unsigned NOT NULL default '0', `CD_Intitule_departement` varchar(100) NOT NULL default '', `CD_Couleur_R` tinyint(3) unsigned NOT NULL default '0', `CD_Couleur_V` tinyint(3) unsigned NOT NULL default '0', `CD_Couleur_B` tinyint(3) unsigned NOT NULL default '0', `CD_ID_Region` int(10) unsigned NOT NULL default '0', `CD_ID_Pays` char(3) NOT NULL default '', PRIMARY KEY (`CD_ID_Departement`) ); # # Contenu de la table `carto_DEPARTEMENT` # INSERT INTO `carto_DEPARTEMENT` VALUES (1, 'Ain', 0, 204, 51, 22, 'fr'); INSERT INTO `carto_DEPARTEMENT` VALUES (2, 'Aisne', 240, 240, 255, 19, 'fr'); INSERT INTO `carto_DEPARTEMENT` VALUES (3, 'Allier', 255, 125, 125, 3, 'fr'); INSERT INTO `carto_DEPARTEMENT` VALUES (4, 'Alpes-de-Haute-Provence', 51, 51, 153, 21, 'fr'); INSERT INTO `carto_DEPARTEMENT` VALUES (5, 'Hautes-Alpes', 51, 51, 204, 21, 'fr'); INSERT INTO `carto_DEPARTEMENT` VALUES (6, 'Alpes-Maritimes', 51, 51, 102, 21, 'fr'); INSERT INTO `carto_DEPARTEMENT` VALUES (7, 'Ardèche', 0, 102, 51, 22, 'fr'); INSERT INTO `carto_DEPARTEMENT` VALUES (8, 'Ardennes', 0, 255, 0, 8, 'fr'); INSERT INTO `carto_DEPARTEMENT` VALUES (9, 'Ariège', 255, 102, 102, 16, 'fr'); INSERT INTO `carto_DEPARTEMENT` VALUES (10, 'Aube', 50, 255, 50, 8, 'fr'); INSERT INTO `carto_DEPARTEMENT` VALUES (11, 'Aude', 102, 51, 0, 13, 'fr'); INSERT INTO `carto_DEPARTEMENT` VALUES (12, 'Aveyron', 255, 153, 0, 16, 'fr'); INSERT INTO `carto_DEPARTEMENT` VALUES (13, 'Bouches-du-Rhône', 0, 0, 153, 21, 'fr'); INSERT INTO `carto_DEPARTEMENT` VALUES (14, 'Calvados', 150, 150, 255, 4, 'fr'); INSERT INTO `carto_DEPARTEMENT` VALUES (15, 'Cantal', 255, 175, 175, 3, 'fr'); INSERT INTO `carto_DEPARTEMENT` VALUES (16, 'Charente', 175, 255, 175, 20, 'fr'); INSERT INTO `carto_DEPARTEMENT` VALUES (17, 'Charente-Maritime', 150, 255, 150, 20, 'fr'); INSERT INTO `carto_DEPARTEMENT` VALUES (18, 'Cher', 125, 255, 255, 7, 'fr'); INSERT INTO `carto_DEPARTEMENT` VALUES (19, 'Corrèze', 255, 255, 150, 14, 'fr'); INSERT INTO `carto_DEPARTEMENT` VALUES (20, 'Corse', 51, 255, 204, 9, 'fr'); INSERT INTO `carto_DEPARTEMENT` VALUES (21, 'Côte-d\'Or', 50, 151, 255, 5, 'fr'); INSERT INTO `carto_DEPARTEMENT` VALUES (22, 'Côtes-d\'Armor', 75, 75, 255, 6, 'fr'); INSERT INTO `carto_DEPARTEMENT` VALUES (23, 'Creuse', 255, 255, 125, 14, 'fr'); INSERT INTO `carto_DEPARTEMENT` VALUES (24, 'Dordogne', 102, 153, 102, 2, 'fr'); INSERT INTO `carto_DEPARTEMENT` VALUES (25, 'Doubs', 255, 255, 50, 10, 'fr'); INSERT INTO `carto_DEPARTEMENT` VALUES (26, 'Drôme', 1, 51, 51, 22, 'fr'); INSERT INTO `carto_DEPARTEMENT` VALUES (27, 'Eure', 204, 255, 0, 11, 'fr'); INSERT INTO `carto_DEPARTEMENT` VALUES (28, 'Eure-et-Loir', 0, 255, 255, 7, 'fr'); INSERT INTO `carto_DEPARTEMENT` VALUES (29, 'Finistère', 25, 25, 255, 6, 'fr'); INSERT INTO `carto_DEPARTEMENT` VALUES (30, 'Gard', 255, 204, 0, 13, 'fr'); INSERT INTO `carto_DEPARTEMENT` VALUES (31, 'Haute-Garonne', 204, 102, 102, 16, 'fr'); INSERT INTO `carto_DEPARTEMENT` VALUES (32, 'Gers', 204, 153, 51, 16, 'fr'); INSERT INTO `carto_DEPARTEMENT` VALUES (33, 'Gironde', 153, 204, 153, 2, 'fr'); INSERT INTO `carto_DEPARTEMENT` VALUES (34, 'Hérault', 204, 153, 0, 13, 'fr'); INSERT INTO `carto_DEPARTEMENT` VALUES (35, 'Ille-et-Vilaine', 100, 100, 255, 6, 'fr'); INSERT INTO `carto_DEPARTEMENT` VALUES (36, 'Indre', 100, 255, 255, 7, 'fr'); INSERT INTO `carto_DEPARTEMENT` VALUES (37, 'Indre-et-Loire', 75, 255, 255, 7, 'fr'); INSERT INTO `carto_DEPARTEMENT` VALUES (38, 'Isère', 51, 102, 102, 22, 'fr'); INSERT INTO `carto_DEPARTEMENT` VALUES (39, 'Jura', 255, 255, 75, 10, 'fr'); INSERT INTO `carto_DEPARTEMENT` VALUES (40, 'Landes', 153, 255, 153, 2, 'fr'); INSERT INTO `carto_DEPARTEMENT` VALUES (41, 'Loir-et-Cher', 50, 255, 255, 7, 'fr'); INSERT INTO `carto_DEPARTEMENT` VALUES (42, 'Loire', 0, 153, 51, 22, 'fr'); INSERT INTO `carto_DEPARTEMENT` VALUES (43, 'Haute-Loire', 255, 200, 200, 3, 'fr'); INSERT INTO `carto_DEPARTEMENT` VALUES (44, 'Loire-Atlantique', 255, 0, 0, 18, 'fr'); INSERT INTO `carto_DEPARTEMENT` VALUES (45, 'Loiret', 25, 255, 255, 7, 'fr'); INSERT INTO `carto_DEPARTEMENT` VALUES (46, 'Lot', 204, 102, 0, 16, 'fr'); INSERT INTO `carto_DEPARTEMENT` VALUES (47, 'Lot-et-Garonne', 204, 255, 204, 2, 'fr'); INSERT INTO `carto_DEPARTEMENT` VALUES (48, 'Lozére', 153, 102, 0, 13, 'fr'); INSERT INTO `carto_DEPARTEMENT` VALUES (49, 'Maine-et-Loire', 255, 100, 100, 18, 'fr'); INSERT INTO `carto_DEPARTEMENT` VALUES (50, 'Manche', 125, 125, 255, 4, 'fr'); INSERT INTO `carto_DEPARTEMENT` VALUES (51, 'Marne', 25, 255, 25, 8, 'fr'); INSERT INTO `carto_DEPARTEMENT` VALUES (52, 'Haute-Marne', 75, 255, 75, 8, 'fr'); INSERT INTO `carto_DEPARTEMENT` VALUES (53, 'Mayenne', 255, 75, 75, 18, 'fr'); INSERT INTO `carto_DEPARTEMENT` VALUES (54, 'Meurthe-et-Moselle', 102, 0, 102, 15, 'fr'); INSERT INTO `carto_DEPARTEMENT` VALUES (55, 'Meuse', 153, 0, 153, 15, 'fr'); INSERT INTO `carto_DEPARTEMENT` VALUES (56, 'Morbihan', 50, 50, 255, 6, 'fr'); INSERT INTO `carto_DEPARTEMENT` VALUES (57, 'Moselle', 204, 0, 204, 15, 'fr'); INSERT INTO `carto_DEPARTEMENT` VALUES (58, 'Nièvre', 100, 151, 255, 5, 'fr'); INSERT INTO `carto_DEPARTEMENT` VALUES (59, 'Nord', 153, 153, 51, 17, 'fr'); INSERT INTO `carto_DEPARTEMENT` VALUES (60, 'Oise', 225, 225, 255, 19, 'fr'); INSERT INTO `carto_DEPARTEMENT` VALUES (61, 'Orne', 175, 175, 255, 4, 'fr'); INSERT INTO `carto_DEPARTEMENT` VALUES (62, 'Pas-de-Calais', 102, 102, 51, 17, 'fr'); INSERT INTO `carto_DEPARTEMENT` VALUES (63, 'Puy-de-Dôme', 255, 150, 150, 3, 'fr'); INSERT INTO `carto_DEPARTEMENT` VALUES (64, 'Pyrénnées-Atlantiques', 102, 255, 102, 2, 'fr'); INSERT INTO `carto_DEPARTEMENT` VALUES (65, 'Hautes-Pyrénnées', 153, 102, 51, 16, 'fr'); INSERT INTO `carto_DEPARTEMENT` VALUES (66, 'Pyrénnées-Orientales', 51, 51, 0, 13, 'fr'); INSERT INTO `carto_DEPARTEMENT` VALUES (67, 'Bas-Rhin', 204, 204, 51, 1, 'fr'); INSERT INTO `carto_DEPARTEMENT` VALUES (68, 'Haut-Rhin', 153, 153, 0, 1, 'fr'); INSERT INTO `carto_DEPARTEMENT` VALUES (69, 'Rhône', 0, 255, 51, 22, 'fr'); INSERT INTO `carto_DEPARTEMENT` VALUES (70, 'Haute-Saône', 255, 255, 0, 10, 'fr'); INSERT INTO `carto_DEPARTEMENT` VALUES (71, 'Saône-et-Loire', 150, 151, 255, 5, 'fr'); INSERT INTO `carto_DEPARTEMENT` VALUES (72, 'Sarthe', 255, 25, 25, 18, 'fr'); INSERT INTO `carto_DEPARTEMENT` VALUES (73, 'Savoie', 51, 153, 153, 22, 'fr'); INSERT INTO `carto_DEPARTEMENT` VALUES (74, 'Haute-Savoie', 0, 204, 204, 22, 'fr'); INSERT INTO `carto_DEPARTEMENT` VALUES (75, 'Paris', 199, 255, 175, 12, 'fr'); INSERT INTO `carto_DEPARTEMENT` VALUES (76, 'Seine-Maritime', 204, 204, 0, 11, 'fr'); INSERT INTO `carto_DEPARTEMENT` VALUES (77, 'Seine-et-Marne', 199, 255, 75, 12, 'fr'); INSERT INTO `carto_DEPARTEMENT` VALUES (78, 'Yvelines', 199, 255, 25, 12, 'fr'); INSERT INTO `carto_DEPARTEMENT` VALUES (79, 'Deux-Sèvres', 100, 255, 100, 20, 'fr'); INSERT INTO `carto_DEPARTEMENT` VALUES (80, 'Somme', 200, 200, 255, 19, 'fr'); INSERT INTO `carto_DEPARTEMENT` VALUES (81, 'Tarn', 153, 102, 102, 16, 'fr'); INSERT INTO `carto_DEPARTEMENT` VALUES (82, 'Tarn-et-Garonne', 153, 51, 0, 16, 'fr'); INSERT INTO `carto_DEPARTEMENT` VALUES (83, 'Var', 0, 0, 204, 21, 'fr'); INSERT INTO `carto_DEPARTEMENT` VALUES (84, 'Vaucluse', 0, 0, 102, 21, 'fr'); INSERT INTO `carto_DEPARTEMENT` VALUES (85, 'Vendée', 255, 50, 50, 18, 'fr'); INSERT INTO `carto_DEPARTEMENT` VALUES (86, 'Vienne', 125, 255, 125, 20, 'fr'); INSERT INTO `carto_DEPARTEMENT` VALUES (87, 'Haute-Vienne', 255, 255, 100, 14, 'fr'); INSERT INTO `carto_DEPARTEMENT` VALUES (88, 'Vosges', 255, 0, 255, 15, 'fr'); INSERT INTO `carto_DEPARTEMENT` VALUES (89, 'Yonne', 0, 151, 255, 5, 'fr'); INSERT INTO `carto_DEPARTEMENT` VALUES (90, 'Territoire-de-Belfort', 255, 255, 25, 10, 'fr'); INSERT INTO `carto_DEPARTEMENT` VALUES (91, 'Essonne', 199, 255, 50, 12, 'fr'); INSERT INTO `carto_DEPARTEMENT` VALUES (92, 'Hauts-de-Seine', 199, 255, 100, 12, 'fr'); INSERT INTO `carto_DEPARTEMENT` VALUES (93, 'Seine-Saint-Denis', 199, 255, 125, 12, 'fr'); INSERT INTO `carto_DEPARTEMENT` VALUES (94, 'Val-de-Marne', 199, 255, 150, 12, 'fr'); INSERT INTO `carto_DEPARTEMENT` VALUES (95, 'Val-d\'Oise', 199, 255, 0, 12, 'fr'); INSERT INTO `carto_DEPARTEMENT` VALUES (99, 'Etranger', 255, 255, 255, 900, ''); INSERT INTO `carto_DEPARTEMENT` VALUES (971, 'Guadeloupe', 161, 161, 25, 900, 'fr'); INSERT INTO `carto_DEPARTEMENT` VALUES (972, 'Martinique', 161, 161, 125, 900, 'fr'); INSERT INTO `carto_DEPARTEMENT` VALUES (973, 'Guyane', 161, 161, 200, 900, 'fr'); INSERT INTO `carto_DEPARTEMENT` VALUES (974, 'Réunion', 161, 161, 225, 900, 'fr'); INSERT INTO `carto_DEPARTEMENT` VALUES (975, 'St-Pierre-et-Miquelon', 25, 161, 161, 900, 'fr'); INSERT INTO `carto_DEPARTEMENT` VALUES (976, 'Mayotte', 125, 161, 161, 900, 'fr'); INSERT INTO `carto_DEPARTEMENT` VALUES (980, 'Monaco', 1, 1, 1, 900, 'fr'); INSERT INTO `carto_DEPARTEMENT` VALUES (986, 'Wallis-et-Futuna', 200, 161, 161, 900, 'fr'); INSERT INTO `carto_DEPARTEMENT` VALUES (987, 'Polynésie-Française', 225, 161, 161, 900, 'fr'); INSERT INTO `carto_DEPARTEMENT` VALUES (988, 'Nouvelle-Calédonie', 225, 225, 161, 900, 'fr'); # -------------------------------------------------------- # # Structure de la table `carto_DESCRIPTION_CARTE` # CREATE TABLE `carto_DESCRIPTION_CARTE` ( `CDC_ID_Carte` varchar(32) NOT NULL default '', `CDC_Titre_carte` varchar(100) NOT NULL default '', `CDC_Infos_carte` mediumblob NOT NULL, `CDC_Carte_fond` varchar(100) NOT NULL default '', `CDC_Carte_masque` varchar(100) NOT NULL default '', `CDC_ID_Zone_geo_carte` varchar(255) NOT NULL default '', `CDC_Type_zone_carte` int(10) unsigned NOT NULL default '0', `CDC_Type_zone_contenu_carte` int(10) unsigned NOT NULL default '0', KEY `CM_PROJECT` (`CDC_ID_Carte`) ); # # Contenu de la table `carto_DESCRIPTION_CARTE` # INSERT INTO `carto_DESCRIPTION_CARTE` VALUES ('europe', 'Europe', '', 'europe.png', 'europe_masque.png', '4', 1, 2); INSERT INTO `carto_DESCRIPTION_CARTE` VALUES ('france', 'France', '', 'france_region.png', 'france_masque.png', 'fr', 2, 4); INSERT INTO `carto_DESCRIPTION_CARTE` VALUES ('continent', 'Monde', '', 'monde5c.png', 'monde_masque5c.png', '', 0, 1); INSERT INTO `carto_DESCRIPTION_CARTE` VALUES ('afrique', 'Afrique', '', 'afrique.png', 'afrique_masque.png', '1', 1, 2); INSERT INTO `carto_DESCRIPTION_CARTE` VALUES ('oceanie', 'Océanie', '', 'oceanie.png', 'oceanie_masque.png', '5', 1, 2); INSERT INTO `carto_DESCRIPTION_CARTE` VALUES ('namerique', 'Amérique du Nord', '', 'namerique.png', 'namerique_masque.png', '2', 1, 2); INSERT INTO `carto_DESCRIPTION_CARTE` VALUES ('samerique', 'Amérique du Sud', '', 'samerique.png', 'samerique_masque.png', '6', 1, 2); INSERT INTO `carto_DESCRIPTION_CARTE` VALUES ('asie', 'Asie - Extrême Orient', '', 'asie.png', 'asie_masque.png', '3', 1, 2); INSERT INTO `carto_DESCRIPTION_CARTE` VALUES ('moyenorient', 'Moyen-Orient', '', 'moyenorient.png', 'moyenorient_masque.png', '7', 1, 2); # -------------------------------------------------------- # # Structure de la table `carto_PAYS` # CREATE TABLE `carto_PAYS` ( `CP_ID_Pays` char(3) NOT NULL default '', `CP_Langue_intitule` char(3) NOT NULL default '', `CP_Intitule_pays` varchar(100) NOT NULL default '', `CP_Intitule_capitale` varchar(100) NOT NULL default '', `CP_Couleur_R` tinyint(3) unsigned NOT NULL default '0', `CP_Couleur_V` tinyint(3) unsigned NOT NULL default '0', `CP_Couleur_B` tinyint(3) unsigned NOT NULL default '0', `CP_ID_Continent` tinyint(4) unsigned NOT NULL default '0', PRIMARY KEY (`CP_ID_Pays`) ); # # Contenu de la table `carto_PAYS` # INSERT INTO `carto_PAYS` VALUES ('af', 'fr', 'Afghanistan', 'Kaboul', 60, 140, 60, 7); INSERT INTO `carto_PAYS` VALUES ('za', 'fr', 'Afrique du Sud', 'Pretoria', 255, 25, 25, 1); INSERT INTO `carto_PAYS` VALUES ('al', 'fr', 'Albanie', 'Tirana', 150, 150, 255, 4); INSERT INTO `carto_PAYS` VALUES ('dz', 'fr', 'Algérie', 'Alger', 255, 25, 75, 1); INSERT INTO `carto_PAYS` VALUES ('de', 'fr', 'Allemagne', 'Berlin', 255, 75, 75, 4); INSERT INTO `carto_PAYS` VALUES ('an', 'fr', 'Andorre', 'Andorre la vielle', 51, 51, 51, 4); INSERT INTO `carto_PAYS` VALUES ('ao', 'fr', 'Angola', 'Luanda', 255, 25, 125, 1); INSERT INTO `carto_PAYS` VALUES ('ag', 'fr', 'Antigua et Barbuda', 'St Jean', 200, 100, 0, 2); INSERT INTO `carto_PAYS` VALUES ('sa', 'fr', 'Arabie Saoudite', 'Riyad', 60, 100, 60, 7); INSERT INTO `carto_PAYS` VALUES ('ar', 'fr', 'Argentine', 'Buenos Aires', 20, 220, 120, 6); INSERT INTO `carto_PAYS` VALUES ('am', 'fr', 'Arménie', 'Erevan', 60, 180, 60, 7); INSERT INTO `carto_PAYS` VALUES ('au', 'fr', 'Australie', 'Canberra', 255, 25, 25, 5); INSERT INTO `carto_PAYS` VALUES ('at', 'fr', 'Autriche', 'Vienne', 179, 179, 179, 4); INSERT INTO `carto_PAYS` VALUES ('az', 'fr', 'Azerbaïdjan', 'Bakou', 60, 240, 60, 7); INSERT INTO `carto_PAYS` VALUES ('bs', 'fr', 'Bahamas', 'Nassau', 200, 100, 50, 2); INSERT INTO `carto_PAYS` VALUES ('bh', 'fr', 'Bahreïn', 'Manama', 140, 0, 0, 7); INSERT INTO `carto_PAYS` VALUES ('bd', 'fr', 'Bangladesh', 'Dhaka', 140, 40, 0, 3); INSERT INTO `carto_PAYS` VALUES ('bb', 'fr', 'Barbade', 'Bridgetown', 200, 100, 75, 2); INSERT INTO `carto_PAYS` VALUES ('be', 'fr', 'Belgique', 'Bruxelles', 204, 204, 204, 4); INSERT INTO `carto_PAYS` VALUES ('bz', 'fr', 'Bélize', 'Belmopan', 200, 100, 100, 2); INSERT INTO `carto_PAYS` VALUES ('bj', 'fr', 'Bénin', 'Porto-Novo', 255, 25, 175, 1); INSERT INTO `carto_PAYS` VALUES ('bt', 'fr', 'Bhoutan', 'Timphou', 140, 80, 0, 3); INSERT INTO `carto_PAYS` VALUES ('by', 'fr', 'Biélorussie', 'Minsk', 225, 255, 225, 4); INSERT INTO `carto_PAYS` VALUES ('bo', 'fr', 'Bolivie', 'La Paz', 120, 220, 120, 6); INSERT INTO `carto_PAYS` VALUES ('ba', 'fr', 'Bosnie-Herzégovine', 'Sarajevo', 255, 25, 25, 4); INSERT INTO `carto_PAYS` VALUES ('bw', 'fr', 'Botswana', 'Gaborone', 255, 25, 225, 1); INSERT INTO `carto_PAYS` VALUES ('br', 'fr', 'Brésil', 'Brasillia', 250, 220, 120, 6); INSERT INTO `carto_PAYS` VALUES ('bn', 'fr', 'Brunei Darusalam', 'Bandar Seri Begawan', 140, 120, 0, 3); INSERT INTO `carto_PAYS` VALUES ('bg', 'fr', 'Bulgarie', 'Sofia', 75, 75, 255, 4); INSERT INTO `carto_PAYS` VALUES ('bf', 'fr', 'Burkina Faso', 'Ouagadougou', 255, 150, 25, 1); INSERT INTO `carto_PAYS` VALUES ('bi', 'fr', 'Burundi', 'Bujumbura', 255, 150, 75, 1); INSERT INTO `carto_PAYS` VALUES ('kh', 'fr', 'Cambodge', 'Phnom Penh', 140, 140, 0, 3); INSERT INTO `carto_PAYS` VALUES ('cm', 'fr', 'Cameroun', 'Yaoundé', 255, 150, 125, 1); INSERT INTO `carto_PAYS` VALUES ('ca', 'fr', 'Canada', 'Ottawa', 200, 100, 125, 2); INSERT INTO `carto_PAYS` VALUES ('cv', 'fr', 'Cap Vert', 'Praia', 25, 100, 150, 1); INSERT INTO `carto_PAYS` VALUES ('cl', 'fr', 'Chili', 'Santiago', 220, 20, 120, 6); INSERT INTO `carto_PAYS` VALUES ('cn', 'fr', 'Chine', 'Pékin', 140, 180, 0, 3); INSERT INTO `carto_PAYS` VALUES ('cy', 'fr', 'Chypre', 'Nicosie', 200, 200, 255, 4); INSERT INTO `carto_PAYS` VALUES ('co', 'fr', 'Colombie', 'Bogota', 220, 120, 120, 6); INSERT INTO `carto_PAYS` VALUES ('km', 'fr', 'Comores', 'Moroni', 255, 150, 175, 1); INSERT INTO `carto_PAYS` VALUES ('cr', 'fr', 'Costa Rica', 'San José', 200, 100, 150, 2); INSERT INTO `carto_PAYS` VALUES ('ci', 'fr', 'Côte d\'Ivoire', 'Yamoussoukro', 255, 150, 225, 1); INSERT INTO `carto_PAYS` VALUES ('hr', 'fr', 'Croatie', 'Zaghreb', 255, 225, 225, 4); INSERT INTO `carto_PAYS` VALUES ('cu', 'fr', 'Cuba', 'La Havane', 200, 100, 175, 2); INSERT INTO `carto_PAYS` VALUES ('dk', 'fr', 'Danemark', 'Copenhague', 25, 255, 25, 4); INSERT INTO `carto_PAYS` VALUES ('dj', 'fr', 'Djibouti', 'Djibouti', 255, 250, 25, 1); INSERT INTO `carto_PAYS` VALUES ('dm', 'fr', 'Dominique', 'Roseau', 200, 100, 250, 2); INSERT INTO `carto_PAYS` VALUES ('eg', 'fr', 'Egypte', 'Le Caire', 255, 250, 75, 1); INSERT INTO `carto_PAYS` VALUES ('sv', 'fr', 'Salvador', 'San Salvador', 200, 200, 0, 2); INSERT INTO `carto_PAYS` VALUES ('ae', 'fr', 'Emirats Arabes Unis', 'Abou Dabi', 140, 220, 0, 7); INSERT INTO `carto_PAYS` VALUES ('ec', 'fr', 'Equateur', 'Quito', 220, 250, 120, 6); INSERT INTO `carto_PAYS` VALUES ('er', 'fr', 'Erythrée', 'Asmara', 255, 250, 125, 1); INSERT INTO `carto_PAYS` VALUES ('es', 'fr', 'Espagne', 'Madrid', 102, 102, 102, 4); INSERT INTO `carto_PAYS` VALUES ('ee', 'fr', 'Estonie', 'Tallin', 125, 255, 125, 4); INSERT INTO `carto_PAYS` VALUES ('us', 'fr', 'Etats-Unis', 'Washington', 200, 200, 100, 2); INSERT INTO `carto_PAYS` VALUES ('et', 'fr', 'Ethiopie', 'Addis-Abeba', 255, 250, 175, 1); INSERT INTO `carto_PAYS` VALUES ('fj', 'fr', 'Fidji', 'Suva', 255, 25, 75, 5); INSERT INTO `carto_PAYS` VALUES ('fi', 'fr', 'Finlande', 'Helsinki', 100, 255, 100, 4); INSERT INTO `carto_PAYS` VALUES ('fr', 'fr', 'France', 'Paris', 77, 77, 77, 4); INSERT INTO `carto_PAYS` VALUES ('ga', 'fr', 'Gabon', 'Libreville', 25, 50, 255, 1); INSERT INTO `carto_PAYS` VALUES ('gm', 'fr', 'Gambie', 'Banjul', 75, 50, 255, 1); INSERT INTO `carto_PAYS` VALUES ('ge', 'fr', 'Géorgie', 'T\'billisi', 170, 15, 50, 7); INSERT INTO `carto_PAYS` VALUES ('gh', 'fr', 'Ghana', 'Accra', 125, 50, 255, 1); INSERT INTO `carto_PAYS` VALUES ('gr', 'fr', 'Grèce', 'Athènes', 175, 175, 255, 4); INSERT INTO `carto_PAYS` VALUES ('gd', 'fr', 'Grenade', 'Saint-Georges', 200, 200, 125, 2); INSERT INTO `carto_PAYS` VALUES ('gl', 'fr', 'Groenland', 'Nuuk', 200, 200, 250, 2); INSERT INTO `carto_PAYS` VALUES ('gt', 'fr', 'Guatémala', 'Guatemala', 0, 100, 200, 2); INSERT INTO `carto_PAYS` VALUES ('gw', 'fr', 'Guinée Bissau', 'Bissau', 175, 50, 255, 1); INSERT INTO `carto_PAYS` VALUES ('gq', 'fr', 'Guinée équatoriale', 'Malabo', 225, 50, 255, 1); INSERT INTO `carto_PAYS` VALUES ('gy', 'fr', 'Guyana', 'Georgetown', 20, 0, 160, 6); INSERT INTO `carto_PAYS` VALUES ('ht', 'fr', 'Haïti', 'Port au Prince', 50, 100, 200, 2); INSERT INTO `carto_PAYS` VALUES ('hn', 'fr', 'Honduras', 'Tegucigalpa', 75, 100, 200, 2); INSERT INTO `carto_PAYS` VALUES ('hu', 'fr', 'Hongrie', 'Budapest', 255, 175, 175, 4); INSERT INTO `carto_PAYS` VALUES ('in', 'fr', 'Inde', 'New Delhi', 255, 0, 0, 3); INSERT INTO `carto_PAYS` VALUES ('id', 'fr', 'Indonésie', 'Jakarta', 255, 40, 0, 3); INSERT INTO `carto_PAYS` VALUES ('iq', 'fr', 'Irak', 'Bagdad', 255, 80, 0, 7); INSERT INTO `carto_PAYS` VALUES ('ir', 'fr', 'Iran', 'Téhéran', 255, 120, 0, 7); INSERT INTO `carto_PAYS` VALUES ('ie', 'fr', 'Irlande', 'Dublin', 0, 255, 0, 4); INSERT INTO `carto_PAYS` VALUES ('is', 'fr', 'Islande', 'Reykjavik', 255, 50, 50, 4); INSERT INTO `carto_PAYS` VALUES ('il', 'fr', 'Israël', 'Tel-Aviv', 255, 160, 0, 7); INSERT INTO `carto_PAYS` VALUES ('it', 'fr', 'Italie', 'Rome', 153, 153, 153, 4); INSERT INTO `carto_PAYS` VALUES ('jm', 'fr', 'Jamaïque', 'Kingston', 100, 100, 200, 2); INSERT INTO `carto_PAYS` VALUES ('jp', 'fr', 'Japon', 'Tokyo', 255, 200, 0, 3); INSERT INTO `carto_PAYS` VALUES ('jo', 'fr', 'Jordanie', 'Amman', 255, 240, 0, 7); INSERT INTO `carto_PAYS` VALUES ('kz', 'fr', 'Kazakhstan', 'Astana', 0, 100, 255, 3); INSERT INTO `carto_PAYS` VALUES ('ke', 'fr', 'Kenya', 'Nairobo', 25, 150, 255, 1); INSERT INTO `carto_PAYS` VALUES ('kg', 'fr', 'Kirghizstan', 'Bichkek', 40, 100, 255, 7); INSERT INTO `carto_PAYS` VALUES ('ki', 'fr', 'Kiribati', 'Tarawa', 255, 25, 125, 5); INSERT INTO `carto_PAYS` VALUES ('kw', 'fr', 'Koweït', 'Keweït', 80, 100, 255, 7); INSERT INTO `carto_PAYS` VALUES ('ls', 'fr', 'Lesotho', 'Maseru', 75, 150, 255, 1); INSERT INTO `carto_PAYS` VALUES ('lv', 'fr', 'Lettonie', 'Rïga', 150, 255, 150, 4); INSERT INTO `carto_PAYS` VALUES ('lb', 'fr', 'Liban', 'Beyrouth', 120, 100, 255, 7); INSERT INTO `carto_PAYS` VALUES ('lr', 'fr', 'Libéria', 'Monrovia', 125, 150, 255, 1); INSERT INTO `carto_PAYS` VALUES ('ly', 'fr', 'Libye', 'Tripoli', 175, 150, 255, 1); INSERT INTO `carto_PAYS` VALUES ('li', 'fr', 'Liechtenstein', 'Vaduz', 0, 255, 255, 4); INSERT INTO `carto_PAYS` VALUES ('lt', 'fr', 'Lituanie', 'Vinius', 175, 255, 175, 4); INSERT INTO `carto_PAYS` VALUES ('lu', 'fr', 'Luxembourg', 'Luxembourg', 229, 229, 229, 4); INSERT INTO `carto_PAYS` VALUES ('mk', 'fr', 'Macédoine', 'Skopje', 125, 125, 255, 4); INSERT INTO `carto_PAYS` VALUES ('mg', 'fr', 'Madagascar', 'Antananarivo', 225, 150, 255, 1); INSERT INTO `carto_PAYS` VALUES ('my', 'fr', 'Malaisie', 'Kuala Lumpur', 140, 100, 255, 3); INSERT INTO `carto_PAYS` VALUES ('mw', 'fr', 'Malawi', 'Lilongwe', 25, 250, 255, 1); INSERT INTO `carto_PAYS` VALUES ('mv', 'fr', 'Maldives', 'Malé', 160, 100, 255, 3); INSERT INTO `carto_PAYS` VALUES ('ml', 'fr', 'Mali', 'Bamoko', 75, 250, 255, 1); INSERT INTO `carto_PAYS` VALUES ('mt', 'fr', 'Malte', 'La Valette', 225, 225, 255, 4); INSERT INTO `carto_PAYS` VALUES ('ma', 'fr', 'Maroc', 'Rabat', 125, 250, 255, 1); INSERT INTO `carto_PAYS` VALUES ('mh', 'fr', 'Marshall', 'Majuro', 255, 25, 175, 5); INSERT INTO `carto_PAYS` VALUES ('mu', 'fr', 'Maurice', 'Port-Louis', 175, 250, 255, 1); INSERT INTO `carto_PAYS` VALUES ('mr', 'fr', 'Mauritanie', 'Nouakchott', 25, 255, 50, 1); INSERT INTO `carto_PAYS` VALUES ('mx', 'fr', 'Mexique', 'Mexico', 125, 100, 200, 2); INSERT INTO `carto_PAYS` VALUES ('fm', 'fr', 'Micronésie', 'Palikir', 255, 25, 225, 5); INSERT INTO `carto_PAYS` VALUES ('md', 'fr', 'Moldavie', 'Chisinau', 25, 25, 255, 4); INSERT INTO `carto_PAYS` VALUES ('mc', 'fr', 'Monaco', 'Monaco', 50, 255, 255, 4); INSERT INTO `carto_PAYS` VALUES ('mn', 'fr', 'Mongolie', 'Oulan-Bator', 180, 100, 255, 3); INSERT INTO `carto_PAYS` VALUES ('mz', 'fr', 'Mozambique', 'Maputo', 75, 255, 50, 1); INSERT INTO `carto_PAYS` VALUES ('na', 'fr', 'Namibie', 'Windhoek', 125, 255, 50, 1); INSERT INTO `carto_PAYS` VALUES ('nr', 'fr', 'Nauru', 'Yaren District', 255, 75, 25, 5); INSERT INTO `carto_PAYS` VALUES ('np', 'fr', 'Népal', 'Kathmandou', 200, 100, 255, 3); INSERT INTO `carto_PAYS` VALUES ('ni', 'fr', 'Nicaragua', 'Managua', 150, 100, 200, 2); INSERT INTO `carto_PAYS` VALUES ('ne', 'fr', 'Niger', 'Niamey', 175, 255, 50, 1); INSERT INTO `carto_PAYS` VALUES ('ng', 'fr', 'Nigéria', 'Abuja', 225, 255, 50, 1); INSERT INTO `carto_PAYS` VALUES ('no', 'fr', 'Norvège', 'Oslo', 50, 255, 50, 4); INSERT INTO `carto_PAYS` VALUES ('nz', 'fr', 'Nouvelle-Zélande', 'Wellington', 255, 75, 75, 5); INSERT INTO `carto_PAYS` VALUES ('om', 'fr', 'Oman', 'Mascate', 220, 100, 255, 7); INSERT INTO `carto_PAYS` VALUES ('ug', 'fr', 'Ouganda', 'Kampala', 25, 255, 150, 1); INSERT INTO `carto_PAYS` VALUES ('uz', 'fr', 'Ouzbekistan', 'Tachkent', 240, 100, 255, 7); INSERT INTO `carto_PAYS` VALUES ('pk', 'fr', 'Pakistan', 'Islamabad', 0, 255, 0, 7); INSERT INTO `carto_PAYS` VALUES ('pw', 'fr', 'Palau', 'Koror', 255, 75, 125, 5); INSERT INTO `carto_PAYS` VALUES ('ps', 'fr', 'Palestine', 'Jérusalem', 40, 255, 0, 7); INSERT INTO `carto_PAYS` VALUES ('pa', 'fr', 'Panama', 'Panama', 175, 100, 200, 2); INSERT INTO `carto_PAYS` VALUES ('pg', 'fr', 'Papouasie - Nouvelle Guinée', 'Port Moresby', 255, 75, 175, 5); INSERT INTO `carto_PAYS` VALUES ('py', 'fr', 'Paraguay', 'Assomption', 20, 120, 160, 6); INSERT INTO `carto_PAYS` VALUES ('nl', 'fr', 'Pays-Bas', 'Amsterdam', 245, 245, 245, 4); INSERT INTO `carto_PAYS` VALUES ('pe', 'fr', 'Pérou', 'Lima', 20, 160, 160, 6); INSERT INTO `carto_PAYS` VALUES ('ph', 'fr', 'Philippines', 'Manille', 80, 255, 0, 3); INSERT INTO `carto_PAYS` VALUES ('pl', 'fr', 'Pologne', 'Varsovie', 255, 100, 100, 4); INSERT INTO `carto_PAYS` VALUES ('pt', 'fr', 'Portugal', 'Lisbonne', 26, 26, 26, 4); INSERT INTO `carto_PAYS` VALUES ('qa', 'fr', 'Qatar', 'Doha', 120, 255, 0, 7); INSERT INTO `carto_PAYS` VALUES ('cf', 'fr', 'République Centrafricaine', 'Bangui', 75, 255, 150, 1); INSERT INTO `carto_PAYS` VALUES ('kr', 'fr', 'République de Corée', 'Séoul', 140, 255, 0, 3); INSERT INTO `carto_PAYS` VALUES ('cd', 'fr', 'République Démocratique du Congo', 'Kinshasa', 125, 255, 150, 1); INSERT INTO `carto_PAYS` VALUES ('kp', 'fr', 'République Populaire Démocratique de Corée', 'Pyongyang', 180, 255, 0, 3); INSERT INTO `carto_PAYS` VALUES ('cz', 'fr', 'République Tchèque', 'Prague', 255, 125, 125, 4); INSERT INTO `carto_PAYS` VALUES ('ro', 'fr', 'Roumanie', 'Bucarest', 50, 50, 255, 4); INSERT INTO `carto_PAYS` VALUES ('uk', 'fr', 'Royaume-Uni', 'Londres', 255, 0, 0, 4); INSERT INTO `carto_PAYS` VALUES ('ru', 'fr', 'Russie', 'Moscou', 200, 255, 200, 4); INSERT INTO `carto_PAYS` VALUES ('rw', 'fr', 'Rwanda', 'Kigali', 175, 255, 150, 1); INSERT INTO `carto_PAYS` VALUES ('sm', 'fr', 'San Marin', 'Saint marin', 25, 255, 255, 4); INSERT INTO `carto_PAYS` VALUES ('vc', 'fr', 'Saint Vincent et les Grenadines', 'Kingston', 200, 100, 200, 2); INSERT INTO `carto_PAYS` VALUES ('lc', 'fr', 'Sainte Lucie', 'Castries', 0, 100, 100, 2); INSERT INTO `carto_PAYS` VALUES ('sb', 'fr', 'Salomon', 'Honiara', 255, 75, 225, 5); INSERT INTO `carto_PAYS` VALUES ('ws', 'fr', 'Samoa', 'Apia', 255, 125, 25, 5); INSERT INTO `carto_PAYS` VALUES ('st', 'fr', 'Sao Tomé et Principe', 'Sao Tomé', 25, 255, 250, 1); INSERT INTO `carto_PAYS` VALUES ('sn', 'fr', 'Sénégal', 'Dakar', 75, 255, 250, 1); INSERT INTO `carto_PAYS` VALUES ('sc', 'fr', 'Seychelles', 'Victoria', 100, 255, 250, 1); INSERT INTO `carto_PAYS` VALUES ('sl', 'fr', 'Sierra Leone', 'Freetown', 125, 255, 250, 1); INSERT INTO `carto_PAYS` VALUES ('sg', 'fr', 'Singapour', 'Singapour', 200, 255, 0, 3); INSERT INTO `carto_PAYS` VALUES ('sk', 'fr', 'Slovaquie', 'Bratislava', 255, 150, 150, 4); INSERT INTO `carto_PAYS` VALUES ('si', 'fr', 'Slovénie', 'Ljubljana', 255, 200, 200, 4); INSERT INTO `carto_PAYS` VALUES ('so', 'fr', 'Somalie', 'Mogadiscio', 175, 255, 250, 1); INSERT INTO `carto_PAYS` VALUES ('sd', 'fr', 'Soudan', 'Khartoum', 151, 151, 25, 1); INSERT INTO `carto_PAYS` VALUES ('lk', 'fr', 'Sri Lanka', 'Sri Jayawardhanapura', 220, 255, 0, 3); INSERT INTO `carto_PAYS` VALUES ('se', 'fr', 'Suède', 'Stokholm', 75, 255, 75, 4); INSERT INTO `carto_PAYS` VALUES ('ch', 'fr', 'Suisse', 'Berne', 128, 128, 128, 4); INSERT INTO `carto_PAYS` VALUES ('sr', 'fr', 'Surinam', 'Paramaribo', 20, 160, 250, 6); INSERT INTO `carto_PAYS` VALUES ('sz', 'fr', 'Swaziland', 'Mbabe', 151, 151, 75, 1); INSERT INTO `carto_PAYS` VALUES ('sy', 'fr', 'Syrie', 'Damas', 240, 255, 0, 7); INSERT INTO `carto_PAYS` VALUES ('tj', 'fr', 'Tadjikistan', 'Douchanbé', 0, 100, 50, 7); INSERT INTO `carto_PAYS` VALUES ('tz', 'fr', 'Tanzanie', 'Dar es Salaam', 151, 151, 125, 1); INSERT INTO `carto_PAYS` VALUES ('td', 'fr', 'Tchad', 'Ndjamena', 151, 151, 175, 1); INSERT INTO `carto_PAYS` VALUES ('th', 'fr', 'Thaïlande', 'Bangkok', 50, 100, 50, 3); INSERT INTO `carto_PAYS` VALUES ('tg', 'fr', 'Togo', 'Lomé', 151, 151, 225, 1); INSERT INTO `carto_PAYS` VALUES ('to', 'fr', 'Tonga', 'Nuku\'alofa', 25, 125, 225, 5); INSERT INTO `carto_PAYS` VALUES ('tt', 'fr', 'Trinité et Tobago', 'Port d\'Espagne', 75, 100, 100, 2); INSERT INTO `carto_PAYS` VALUES ('tn', 'fr', 'Tunisie', 'Tunis', 25, 151, 151, 1); INSERT INTO `carto_PAYS` VALUES ('tm', 'fr', 'Turkmenistan', 'Asgabad', 100, 100, 50, 7); INSERT INTO `carto_PAYS` VALUES ('tr', 'fr', 'Turquie', 'Ankara', 150, 100, 50, 7); INSERT INTO `carto_PAYS` VALUES ('tv', 'fr', 'Tuvalu', 'Funafuti', 25, 175, 25, 5); INSERT INTO `carto_PAYS` VALUES ('ua', 'fr', 'Ukraine', 'Kiev', 0, 0, 255, 4); INSERT INTO `carto_PAYS` VALUES ('uy', 'fr', 'Uruguay', 'Montevideo', 220, 220, 60, 6); INSERT INTO `carto_PAYS` VALUES ('vu', 'fr', 'Vanuatu', 'Port-Vila', 255, 125, 175, 5); INSERT INTO `carto_PAYS` VALUES ('ve', 'fr', 'Vénézuéla', 'Caracas', 220, 60, 60, 6); INSERT INTO `carto_PAYS` VALUES ('vn', 'fr', 'Vietnam', 'Hanoï', 200, 100, 50, 3); INSERT INTO `carto_PAYS` VALUES ('ye', 'fr', 'Yémen', 'Sanaa', 250, 100, 50, 7); INSERT INTO `carto_PAYS` VALUES ('yu', 'fr', 'Yougoslavie', 'Belgrade', 100, 100, 255, 4); INSERT INTO `carto_PAYS` VALUES ('zm', 'fr', 'Zambie', 'Lusaka', 75, 151, 151, 1); INSERT INTO `carto_PAYS` VALUES ('zw', 'fr', 'Zimbabwe', 'Harare', 225, 151, 151, 1); INSERT INTO `carto_PAYS` VALUES ('cg', 'fr', 'Congo', 'Brazzaville', 175, 151, 151, 1); INSERT INTO `carto_PAYS` VALUES ('gn', 'fr', 'Guinée', 'Conakry', 125, 151, 151, 1); INSERT INTO `carto_PAYS` VALUES ('la', 'fr', 'Laos', 'Vientiane', 160, 200, 250, 3); INSERT INTO `carto_PAYS` VALUES ('mm', 'fr', 'Birmanie', 'Rangoon', 210, 200, 250, 3); INSERT INTO `carto_PAYS` VALUES ('rua', 'fr', 'Russie (Asie)', 'Moscou', 0, 125, 125, 3); INSERT INTO `carto_PAYS` VALUES ('tw', 'fr', 'Taïwan', 'Taïpei', 0, 200, 250, 3); INSERT INTO `carto_PAYS` VALUES ('0', '', ' ', ' ', 255, 255, 255, 0); # -------------------------------------------------------- # # Structure de la table `carto_PROJET` # CREATE TABLE `carto_PROJET` ( `CP_ID_Projet` int(10) unsigned NOT NULL default '0', `CP_Nom_projet` varchar(100) NOT NULL default '', `CP_Description_projet` text, PRIMARY KEY (`CP_ID_Projet`) ); # # Contenu de la table `carto_PROJET` # INSERT INTO `carto_PROJET` VALUES (1, 'Actions génériques', 'La carte des continents appelle les cartes des pays de chaque continent. La carte du continent Europe appelle la carte des départements français pour le pays \'fr\'.'); # -------------------------------------------------------- # # Structure de la table `carto_REGION` # CREATE TABLE `carto_REGION` ( `CR_ID_Region` int(11) NOT NULL default '0', `CR_Intitule_region` varchar(100) NOT NULL default '', `CR_Couleur_R` tinyint(3) unsigned NOT NULL default '0', `CR_Couleur_V` tinyint(3) unsigned NOT NULL default '0', `CR_Couleur_B` tinyint(3) unsigned NOT NULL default '0', `CR_ID_Pays` char(3) NOT NULL default '', PRIMARY KEY (`CR_ID_Region`) ); # # Contenu de la table `carto_REGION` # INSERT INTO `carto_REGION` VALUES (1, 'Alsace', 51, 153, 153, 'fr'); INSERT INTO `carto_REGION` VALUES (2, 'Aquitaine', 51, 51, 204, 'fr'); INSERT INTO `carto_REGION` VALUES (3, 'Auvergne', 51, 51, 153, 'fr'); INSERT INTO `carto_REGION` VALUES (4, 'Basse-Normandie', 102, 102, 255, 'fr'); INSERT INTO `carto_REGION` VALUES (5, 'Bourgogne', 0, 204, 204, 'fr'); INSERT INTO `carto_REGION` VALUES (6, 'Bretagne', 102, 102, 204, 'fr'); INSERT INTO `carto_REGION` VALUES (7, 'Centre', 51, 204, 102, 'fr'); INSERT INTO `carto_REGION` VALUES (8, 'Champagne-Ardenne', 153, 255, 255, 'fr'); INSERT INTO `carto_REGION` VALUES (9, 'Corse', 0, 0, 102, 'fr'); INSERT INTO `carto_REGION` VALUES (10, 'Franche-Comté', 0, 102, 102, 'fr'); INSERT INTO `carto_REGION` VALUES (11, 'Haute-Normandie', 153, 153, 255, 'fr'); INSERT INTO `carto_REGION` VALUES (12, 'Ile-de-France', 0, 102, 51, 'fr'); INSERT INTO `carto_REGION` VALUES (13, 'Languedoc-Roussillon', 0, 0, 204, 'fr'); INSERT INTO `carto_REGION` VALUES (14, 'Limousin', 51, 51, 102, 'fr'); INSERT INTO `carto_REGION` VALUES (15, 'Lorraine', 102, 204, 204, 'fr'); INSERT INTO `carto_REGION` VALUES (16, 'Midi-Pyrénnées', 51, 51, 255, 'fr'); INSERT INTO `carto_REGION` VALUES (17, 'Nord-Pas-de-Calais', 153, 204, 204, 'fr'); INSERT INTO `carto_REGION` VALUES (18, 'Pays-de-la-Loire', 102, 102, 153, 'fr'); INSERT INTO `carto_REGION` VALUES (19, 'Picardie', 153, 153, 204, 'fr'); INSERT INTO `carto_REGION` VALUES (20, 'Poitou-Charentes', 102, 102, 102, 'fr'); INSERT INTO `carto_REGION` VALUES (21, 'Provence-Alpes-Côte-d\'Azur', 0, 0, 153, 'fr'); INSERT INTO `carto_REGION` VALUES (22, 'Rhône-Alpes', 0, 0, 255, 'fr'); INSERT INTO `carto_REGION` VALUES (900, ' ', 255, 255, 255, ''); # -------------------------------------------------------- # # Structure de la table `carto_TYPE_ZONE` # CREATE TABLE `carto_TYPE_ZONE` ( `CTZ_ID_Type_zone` int(11) NOT NULL default '0', `CTZ_Intitule_type_zone` varchar(100) NOT NULL default '', `CTZ_Nom_table` varchar(100) NOT NULL default '', PRIMARY KEY (`CTZ_ID_Type_zone`) ); # # Contenu de la table `carto_TYPE_ZONE` # INSERT INTO `carto_TYPE_ZONE` VALUES (1, 'Continent', 'carto_COULEUR_CONTINENT'); INSERT INTO `carto_TYPE_ZONE` VALUES (2, 'Pays', 'carto_COULEUR_PAYS'); INSERT INTO `carto_TYPE_ZONE` VALUES (3, 'Région', 'carto_COULEUR_REGION'); INSERT INTO `carto_TYPE_ZONE` VALUES (4, 'Département', 'carto_COULEUR_DEPARTEMENT'); INSERT INTO `carto_TYPE_ZONE` VALUES (0, 'Monde', ''); # -------------------------------------------------------- # # Structure de la table `carto_communes` # CREATE TABLE `carto_communes` ( `cc_code_insee` int(10) unsigned NOT NULL default '0', `cc_code_couleur_rouge` tinyint(3) unsigned NOT NULL default '0', `cc_code_couleur_vert` tinyint(3) unsigned NOT NULL default '0', `cc_code_couleur_bleu` tinyint(3) unsigned NOT NULL default '0', PRIMARY KEY (`cc_code_insee`) ); # # Contenu de la table `carto_communes` # # -------------------------------------------------------- CREATE TABLE `carto_config` ( `cc_menu_id` int(11) NOT NULL default '0', `cc_titre_carto` varchar(255) NOT NULL, `cc_table1` varchar(255) NOT NULL default '', `cc_table2` varchar(255) NOT NULL default '', `cc_pays` varchar(255) NOT NULL, `cc_cp` varchar(255) NOT NULL, `cc_sql` text NOT NULL, `cc_ce_premiere_carte` int(11) NOT NULL, PRIMARY KEY (`cc_menu_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Contenu de la table `carto_config` -- INSERT INTO `carto_config` (`cc_menu_id`, `cc_titre_carto`, `cc_table1`, `cc_table2`, `cc_pays`, `cc_cp`, `cc_sql`, `cc_ce_premiere_carte`) VALUES (12, 'hghg', 'annuaire', '0', 'a_ce_pays', 'a_code_postal', '', 1); CREATE TABLE `carto_zone_hierarchie` ( `czh_id_zone` int(10) unsigned NOT NULL, `czh_id_zone_pere` int(10) unsigned NOT NULL, `czh_nom` varchar(255) NOT NULL, `czh_code_alpha` varchar(255) NOT NULL, `czh_i18n` varchar(5) NOT NULL, `czh_fichier_masque` varchar(255) NOT NULL, `czh_fichier_image` varchar(255) NOT NULL, `czh_coloration` tinyint(1) NOT NULL, `czh_nom_table_info_couleur` varchar(255) NOT NULL, `czh_identifiant_table_info_couleur` varchar(255) NOT NULL, `czh_champs_jointure_annuaire` varchar(255) NOT NULL, `czh_sql_complementaire` varchar(255) NOT NULL, `czh_nom_champs_id` varchar(255) NOT NULL, `czh_nom_champs_id_pere` varchar(255) NOT NULL, `czh_nom_champs_intitule` varchar(255) NOT NULL, `czh_nom_champs_couleur_R` varchar(255) NOT NULL, `czh_nom_champs_couleur_V` varchar(255) NOT NULL, `czh_nom_champs_couleur_B` varchar(255) NOT NULL, PRIMARY KEY (`czh_id_zone`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; # # Contenu de la table `carto_zone_hierarchie` # INSERT INTO `carto_zone_hierarchie` VALUES (1, 0, 'Monde', 'continent', 'fr-FR', 'monde_masque5c.png', 'monde5c.png', 1, 'carto_CONTINENT', '', 'a_ce_continent', '', 'CC_ID_Continent', '', 'CC_Intitule_continent', 'CC_Couleur_R', 'CC_Couleur_V', 'CC_Couleur_B'); INSERT INTO `carto_zone_hierarchie` VALUES (2, 1, 'Europe', 'europe', 'fr-FR', 'europe_masque.png', 'europe.png', 1, 'carto_PAYS', '4', 'a_ce_pays', '', 'CP_ID_Pays', 'CP_ID_Continent', 'CP_Intitule_pays', 'CP_Couleur_R', 'CP_Couleur_V', 'CP_Couleur_B'); INSERT INTO `carto_zone_hierarchie` VALUES (3, 2, 'France', 'france', 'fr-FR', 'france_masque.png', 'france.png', 1, 'carto_DEPARTEMENT', 'fr', 'bfvl_valeur', 'france.bfvl_ce_liste=19 and france.bfvl_ce_fiche=bf_id_fiche', 'CD_ID_Departement', 'CD_ID_Pays', 'CD_Intitule_departement', 'CD_Couleur_R', 'CD_Couleur_V', 'CD_Couleur_B'); INSERT INTO `carto_zone_hierarchie` VALUES (4, 3, 'Drôme', 'drome', 'fr-FR', 'carte_drome_masque.png', 'carte_drome.png', 1, 'carto_DROME', '26', 'bfvl_valeur', 'drome.bfvl_ce_liste=29 and drome.bfvl_ce_fiche=bf_id_fiche', 'cd_id', 'cd_id_pays', 'cd_nom', 'cd_rouge', 'cd_vert', 'cd_bleu');