425 |
florian |
1 |
# phpMyAdmin SQL Dump
|
|
|
2 |
# version 2.5.6
|
|
|
3 |
# http://www.phpmyadmin.net
|
|
|
4 |
#
|
|
|
5 |
# Serveur: localhost
|
|
|
6 |
# Généré le : Jeudi 21 Juillet 2005 à 20:03
|
|
|
7 |
# Version du serveur: 4.1.12
|
|
|
8 |
# Version de PHP: 4.3.11
|
|
|
9 |
#
|
|
|
10 |
# Base de données: `educenvi`
|
|
|
11 |
#
|
|
|
12 |
|
|
|
13 |
# --------------------------------------------------------
|
|
|
14 |
|
|
|
15 |
#
|
|
|
16 |
# Structure de la table `carto_ACTION`
|
|
|
17 |
#
|
|
|
18 |
|
|
|
19 |
DROP TABLE IF EXISTS `carto_ACTION`;
|
|
|
20 |
CREATE TABLE `carto_ACTION` (
|
|
|
21 |
`CA_ID_Projet_Carto` int(11) NOT NULL default '0',
|
|
|
22 |
`CA_ID_Carte` varchar(32) NOT NULL default '',
|
|
|
23 |
`CA_ID_Zone_geo` varchar(255) NOT NULL default '',
|
|
|
24 |
`CA_Type_zone` int(11) NOT NULL default '0',
|
|
|
25 |
`CA_Action` varchar(10) NOT NULL default '',
|
|
|
26 |
`CA_ID_Carte_destination` varchar(32) NOT NULL default '',
|
|
|
27 |
PRIMARY KEY (`CA_ID_Projet_Carto`,`CA_ID_Carte`,`CA_ID_Zone_geo`,`CA_Type_zone`,`CA_ID_Carte_destination`,`CA_Action`),
|
|
|
28 |
KEY `CA_PROJECT` (`CA_ID_Carte`)
|
|
|
29 |
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
|
|
|
30 |
|
|
|
31 |
#
|
|
|
32 |
# Contenu de la table `carto_ACTION`
|
|
|
33 |
#
|
|
|
34 |
|
|
|
35 |
INSERT INTO `carto_ACTION` VALUES (1, 'afrique', '0', 2, 'Recharger', '');
|
|
|
36 |
INSERT INTO `carto_ACTION` VALUES (1, 'afrique', 'ao', 2, 'Stop', '');
|
|
|
37 |
INSERT INTO `carto_ACTION` VALUES (1, 'afrique', 'bf', 2, 'Stop', '');
|
|
|
38 |
INSERT INTO `carto_ACTION` VALUES (1, 'afrique', 'bi', 2, 'Stop', '');
|
|
|
39 |
INSERT INTO `carto_ACTION` VALUES (1, 'afrique', 'bj', 2, 'Stop', '');
|
|
|
40 |
INSERT INTO `carto_ACTION` VALUES (1, 'afrique', 'bw', 2, 'Stop', '');
|
|
|
41 |
INSERT INTO `carto_ACTION` VALUES (1, 'afrique', 'cd', 2, 'Stop', '');
|
|
|
42 |
INSERT INTO `carto_ACTION` VALUES (1, 'afrique', 'cf', 2, 'Stop', '');
|
|
|
43 |
INSERT INTO `carto_ACTION` VALUES (1, 'afrique', 'cg', 2, 'Stop', '');
|
|
|
44 |
INSERT INTO `carto_ACTION` VALUES (1, 'afrique', 'ci', 2, 'Stop', '');
|
|
|
45 |
INSERT INTO `carto_ACTION` VALUES (1, 'afrique', 'cm', 2, 'Stop', '');
|
|
|
46 |
INSERT INTO `carto_ACTION` VALUES (1, 'afrique', 'cv', 2, 'Stop', '');
|
|
|
47 |
INSERT INTO `carto_ACTION` VALUES (1, 'afrique', 'dj', 2, 'Stop', '');
|
|
|
48 |
INSERT INTO `carto_ACTION` VALUES (1, 'afrique', 'dz', 2, 'Stop', '');
|
|
|
49 |
INSERT INTO `carto_ACTION` VALUES (1, 'afrique', 'eg', 2, 'Stop', '');
|
|
|
50 |
INSERT INTO `carto_ACTION` VALUES (1, 'afrique', 'er', 2, 'Stop', '');
|
|
|
51 |
INSERT INTO `carto_ACTION` VALUES (1, 'afrique', 'et', 2, 'Stop', '');
|
|
|
52 |
INSERT INTO `carto_ACTION` VALUES (1, 'afrique', 'ga', 2, 'Stop', '');
|
|
|
53 |
INSERT INTO `carto_ACTION` VALUES (1, 'afrique', 'gh', 2, 'Stop', '');
|
|
|
54 |
INSERT INTO `carto_ACTION` VALUES (1, 'afrique', 'gm', 2, 'Stop', '');
|
|
|
55 |
INSERT INTO `carto_ACTION` VALUES (1, 'afrique', 'gn', 2, 'Stop', '');
|
|
|
56 |
INSERT INTO `carto_ACTION` VALUES (1, 'afrique', 'gq', 2, 'Stop', '');
|
|
|
57 |
INSERT INTO `carto_ACTION` VALUES (1, 'afrique', 'gw', 2, 'Stop', '');
|
|
|
58 |
INSERT INTO `carto_ACTION` VALUES (1, 'afrique', 'ke', 2, 'Stop', '');
|
|
|
59 |
INSERT INTO `carto_ACTION` VALUES (1, 'afrique', 'km', 2, 'Stop', '');
|
|
|
60 |
INSERT INTO `carto_ACTION` VALUES (1, 'afrique', 'lr', 2, 'Stop', '');
|
|
|
61 |
INSERT INTO `carto_ACTION` VALUES (1, 'afrique', 'ls', 2, 'Stop', '');
|
|
|
62 |
INSERT INTO `carto_ACTION` VALUES (1, 'afrique', 'ly', 2, 'Stop', '');
|
|
|
63 |
INSERT INTO `carto_ACTION` VALUES (1, 'afrique', 'ma', 2, 'Stop', '');
|
|
|
64 |
INSERT INTO `carto_ACTION` VALUES (1, 'afrique', 'mg', 2, 'Stop', '');
|
|
|
65 |
INSERT INTO `carto_ACTION` VALUES (1, 'afrique', 'ml', 2, 'Stop', '');
|
|
|
66 |
INSERT INTO `carto_ACTION` VALUES (1, 'afrique', 'mr', 2, 'Stop', '');
|
|
|
67 |
INSERT INTO `carto_ACTION` VALUES (1, 'afrique', 'mu', 2, 'Stop', '');
|
|
|
68 |
INSERT INTO `carto_ACTION` VALUES (1, 'afrique', 'mw', 2, 'Stop', '');
|
|
|
69 |
INSERT INTO `carto_ACTION` VALUES (1, 'afrique', 'mz', 2, 'Stop', '');
|
|
|
70 |
INSERT INTO `carto_ACTION` VALUES (1, 'afrique', 'na', 2, 'Stop', '');
|
|
|
71 |
INSERT INTO `carto_ACTION` VALUES (1, 'afrique', 'ne', 2, 'Stop', '');
|
|
|
72 |
INSERT INTO `carto_ACTION` VALUES (1, 'afrique', 'ng', 2, 'Stop', '');
|
|
|
73 |
INSERT INTO `carto_ACTION` VALUES (1, 'afrique', 'rw', 2, 'Stop', '');
|
|
|
74 |
INSERT INTO `carto_ACTION` VALUES (1, 'afrique', 'sc', 2, 'Stop', '');
|
|
|
75 |
INSERT INTO `carto_ACTION` VALUES (1, 'afrique', 'sd', 2, 'Stop', '');
|
|
|
76 |
INSERT INTO `carto_ACTION` VALUES (1, 'afrique', 'sl', 2, 'Stop', '');
|
|
|
77 |
INSERT INTO `carto_ACTION` VALUES (1, 'afrique', 'sn', 2, 'Stop', '');
|
|
|
78 |
INSERT INTO `carto_ACTION` VALUES (1, 'afrique', 'so', 2, 'Stop', '');
|
|
|
79 |
INSERT INTO `carto_ACTION` VALUES (1, 'afrique', 'st', 2, 'Stop', '');
|
|
|
80 |
INSERT INTO `carto_ACTION` VALUES (1, 'afrique', 'sz', 2, 'Stop', '');
|
|
|
81 |
INSERT INTO `carto_ACTION` VALUES (1, 'afrique', 'td', 2, 'Stop', '');
|
|
|
82 |
INSERT INTO `carto_ACTION` VALUES (1, 'afrique', 'tg', 2, 'Stop', '');
|
|
|
83 |
INSERT INTO `carto_ACTION` VALUES (1, 'afrique', 'tn', 2, 'Stop', '');
|
|
|
84 |
INSERT INTO `carto_ACTION` VALUES (1, 'afrique', 'tz', 2, 'Stop', '');
|
|
|
85 |
INSERT INTO `carto_ACTION` VALUES (1, 'afrique', 'ug', 2, 'Stop', '');
|
|
|
86 |
INSERT INTO `carto_ACTION` VALUES (1, 'afrique', 'za', 2, 'Stop', '');
|
|
|
87 |
INSERT INTO `carto_ACTION` VALUES (1, 'afrique', 'zm', 2, 'Stop', '');
|
|
|
88 |
INSERT INTO `carto_ACTION` VALUES (1, 'afrique', 'zw', 2, 'Stop', '');
|
|
|
89 |
INSERT INTO `carto_ACTION` VALUES (1, 'asie', '0', 2, 'Recharger', '');
|
|
|
90 |
INSERT INTO `carto_ACTION` VALUES (1, 'asie', 'bd', 2, 'Stop', '');
|
|
|
91 |
INSERT INTO `carto_ACTION` VALUES (1, 'asie', 'bn', 2, 'Stop', '');
|
|
|
92 |
INSERT INTO `carto_ACTION` VALUES (1, 'asie', 'bt', 2, 'Stop', '');
|
|
|
93 |
INSERT INTO `carto_ACTION` VALUES (1, 'asie', 'cn', 2, 'Stop', '');
|
|
|
94 |
INSERT INTO `carto_ACTION` VALUES (1, 'asie', 'id', 2, 'Stop', '');
|
|
|
95 |
INSERT INTO `carto_ACTION` VALUES (1, 'asie', 'in', 2, 'Stop', '');
|
|
|
96 |
INSERT INTO `carto_ACTION` VALUES (1, 'asie', 'jp', 2, 'Stop', '');
|
|
|
97 |
INSERT INTO `carto_ACTION` VALUES (1, 'asie', 'kh', 2, 'Stop', '');
|
|
|
98 |
INSERT INTO `carto_ACTION` VALUES (1, 'asie', 'kp', 2, 'Stop', '');
|
|
|
99 |
INSERT INTO `carto_ACTION` VALUES (1, 'asie', 'kr', 2, 'Stop', '');
|
|
|
100 |
INSERT INTO `carto_ACTION` VALUES (1, 'asie', 'kz', 2, 'Stop', '');
|
|
|
101 |
INSERT INTO `carto_ACTION` VALUES (1, 'asie', 'la', 2, 'Stop', '');
|
|
|
102 |
INSERT INTO `carto_ACTION` VALUES (1, 'asie', 'lk', 2, 'Stop', '');
|
|
|
103 |
INSERT INTO `carto_ACTION` VALUES (1, 'asie', 'mm', 2, 'Stop', '');
|
|
|
104 |
INSERT INTO `carto_ACTION` VALUES (1, 'asie', 'mn', 2, 'Stop', '');
|
|
|
105 |
INSERT INTO `carto_ACTION` VALUES (1, 'asie', 'mv', 2, 'Stop', '');
|
|
|
106 |
INSERT INTO `carto_ACTION` VALUES (1, 'asie', 'my', 2, 'Stop', '');
|
|
|
107 |
INSERT INTO `carto_ACTION` VALUES (1, 'asie', 'np', 2, 'Stop', '');
|
|
|
108 |
INSERT INTO `carto_ACTION` VALUES (1, 'asie', 'ph', 2, 'Stop', '');
|
|
|
109 |
INSERT INTO `carto_ACTION` VALUES (1, 'asie', 'rua', 2, 'Stop', '');
|
|
|
110 |
INSERT INTO `carto_ACTION` VALUES (1, 'asie', 'sg', 2, 'Stop', '');
|
|
|
111 |
INSERT INTO `carto_ACTION` VALUES (1, 'asie', 'th', 2, 'Stop', '');
|
|
|
112 |
INSERT INTO `carto_ACTION` VALUES (1, 'asie', 'tw', 2, 'Stop', '');
|
|
|
113 |
INSERT INTO `carto_ACTION` VALUES (1, 'asie', 'vn', 2, 'Stop', '');
|
|
|
114 |
INSERT INTO `carto_ACTION` VALUES (1, 'continent', '0', 1, 'Recharger', '');
|
|
|
115 |
INSERT INTO `carto_ACTION` VALUES (1, 'continent', '1', 1, 'Aller_a', 'afrique');
|
|
|
116 |
INSERT INTO `carto_ACTION` VALUES (1, 'continent', '2', 1, 'Aller_a', 'namerique');
|
|
|
117 |
INSERT INTO `carto_ACTION` VALUES (1, 'continent', '3', 1, 'Aller_a', 'asie');
|
|
|
118 |
INSERT INTO `carto_ACTION` VALUES (1, 'continent', '4', 1, 'Aller_a', 'europe');
|
|
|
119 |
INSERT INTO `carto_ACTION` VALUES (1, 'continent', '5', 1, 'Aller_a', 'oceanie');
|
|
|
120 |
INSERT INTO `carto_ACTION` VALUES (1, 'continent', '6', 1, 'Aller_a', 'samerique');
|
|
|
121 |
INSERT INTO `carto_ACTION` VALUES (1, 'continent', '7', 1, 'Aller_a', 'moyenorient');
|
|
|
122 |
INSERT INTO `carto_ACTION` VALUES (1, 'europe', '0', 2, 'Recharger', '');
|
|
|
123 |
INSERT INTO `carto_ACTION` VALUES (1, 'europe', 'al', 2, 'Stop', '');
|
|
|
124 |
INSERT INTO `carto_ACTION` VALUES (1, 'europe', 'an', 2, 'Stop', '');
|
|
|
125 |
INSERT INTO `carto_ACTION` VALUES (1, 'europe', 'at', 2, 'Stop', '');
|
|
|
126 |
INSERT INTO `carto_ACTION` VALUES (1, 'europe', 'ba', 2, 'Stop', '');
|
|
|
127 |
INSERT INTO `carto_ACTION` VALUES (1, 'europe', 'be', 2, 'Stop', '');
|
|
|
128 |
INSERT INTO `carto_ACTION` VALUES (1, 'europe', 'bg', 2, 'Stop', '');
|
|
|
129 |
INSERT INTO `carto_ACTION` VALUES (1, 'europe', 'by', 2, 'Stop', '');
|
|
|
130 |
INSERT INTO `carto_ACTION` VALUES (1, 'europe', 'ch', 2, 'Stop', '');
|
|
|
131 |
INSERT INTO `carto_ACTION` VALUES (1, 'europe', 'cy', 2, 'Stop', '');
|
|
|
132 |
INSERT INTO `carto_ACTION` VALUES (1, 'europe', 'cz', 2, 'Stop', '');
|
|
|
133 |
INSERT INTO `carto_ACTION` VALUES (1, 'europe', 'de', 2, 'Stop', '');
|
|
|
134 |
INSERT INTO `carto_ACTION` VALUES (1, 'europe', 'dk', 2, 'Stop', '');
|
|
|
135 |
INSERT INTO `carto_ACTION` VALUES (1, 'europe', 'ee', 2, 'Stop', '');
|
|
|
136 |
INSERT INTO `carto_ACTION` VALUES (1, 'europe', 'es', 2, 'Stop', '');
|
|
|
137 |
INSERT INTO `carto_ACTION` VALUES (1, 'europe', 'fi', 2, 'Stop', '');
|
|
|
138 |
INSERT INTO `carto_ACTION` VALUES (1, 'europe', 'fr', 2, 'Aller_a', 'france');
|
|
|
139 |
INSERT INTO `carto_ACTION` VALUES (1, 'europe', 'gr', 2, 'Stop', '');
|
|
|
140 |
INSERT INTO `carto_ACTION` VALUES (1, 'europe', 'hr', 2, 'Stop', '');
|
|
|
141 |
INSERT INTO `carto_ACTION` VALUES (1, 'europe', 'hu', 2, 'Stop', '');
|
|
|
142 |
INSERT INTO `carto_ACTION` VALUES (1, 'europe', 'ie', 2, 'Stop', '');
|
|
|
143 |
INSERT INTO `carto_ACTION` VALUES (1, 'europe', 'is', 2, 'Stop', '');
|
|
|
144 |
INSERT INTO `carto_ACTION` VALUES (1, 'europe', 'it', 2, 'Stop', '');
|
|
|
145 |
INSERT INTO `carto_ACTION` VALUES (1, 'europe', 'li', 2, 'Stop', '');
|
|
|
146 |
INSERT INTO `carto_ACTION` VALUES (1, 'europe', 'lt', 2, 'Stop', '');
|
|
|
147 |
INSERT INTO `carto_ACTION` VALUES (1, 'europe', 'lu', 2, 'Stop', '');
|
|
|
148 |
INSERT INTO `carto_ACTION` VALUES (1, 'europe', 'lv', 2, 'Stop', '');
|
|
|
149 |
INSERT INTO `carto_ACTION` VALUES (1, 'europe', 'mc', 2, 'Stop', '');
|
|
|
150 |
INSERT INTO `carto_ACTION` VALUES (1, 'europe', 'md', 2, 'Stop', '');
|
|
|
151 |
INSERT INTO `carto_ACTION` VALUES (1, 'europe', 'mk', 2, 'Stop', '');
|
|
|
152 |
INSERT INTO `carto_ACTION` VALUES (1, 'europe', 'mt', 2, 'Stop', '');
|
|
|
153 |
INSERT INTO `carto_ACTION` VALUES (1, 'europe', 'nl', 2, 'Stop', '');
|
|
|
154 |
INSERT INTO `carto_ACTION` VALUES (1, 'europe', 'no', 2, 'Stop', '');
|
|
|
155 |
INSERT INTO `carto_ACTION` VALUES (1, 'europe', 'pl', 2, 'Stop', '');
|
|
|
156 |
INSERT INTO `carto_ACTION` VALUES (1, 'europe', 'pt', 2, 'Stop', '');
|
|
|
157 |
INSERT INTO `carto_ACTION` VALUES (1, 'europe', 'ro', 2, 'Stop', '');
|
|
|
158 |
INSERT INTO `carto_ACTION` VALUES (1, 'europe', 'ru', 2, 'Stop', '');
|
|
|
159 |
INSERT INTO `carto_ACTION` VALUES (1, 'europe', 'se', 2, 'Stop', '');
|
|
|
160 |
INSERT INTO `carto_ACTION` VALUES (1, 'europe', 'si', 2, 'Stop', '');
|
|
|
161 |
INSERT INTO `carto_ACTION` VALUES (1, 'europe', 'sk', 2, 'Stop', '');
|
|
|
162 |
INSERT INTO `carto_ACTION` VALUES (1, 'europe', 'sm', 2, 'Stop', '');
|
|
|
163 |
INSERT INTO `carto_ACTION` VALUES (1, 'europe', 'ua', 2, 'Stop', '');
|
|
|
164 |
INSERT INTO `carto_ACTION` VALUES (1, 'europe', 'uk', 2, 'Stop', '');
|
|
|
165 |
INSERT INTO `carto_ACTION` VALUES (1, 'europe', 'yu', 2, 'Stop', '');
|
|
|
166 |
INSERT INTO `carto_ACTION` VALUES (1, 'france', '1', 4, 'Stop', '');
|
|
|
167 |
INSERT INTO `carto_ACTION` VALUES (1, 'france', '10', 4, 'Stop', '');
|
|
|
168 |
INSERT INTO `carto_ACTION` VALUES (1, 'france', '11', 4, 'Stop', '');
|
|
|
169 |
INSERT INTO `carto_ACTION` VALUES (1, 'france', '12', 4, 'Stop', '');
|
|
|
170 |
INSERT INTO `carto_ACTION` VALUES (1, 'france', '13', 4, 'Stop', '');
|
|
|
171 |
INSERT INTO `carto_ACTION` VALUES (1, 'france', '14', 4, 'Stop', '');
|
|
|
172 |
INSERT INTO `carto_ACTION` VALUES (1, 'france', '15', 4, 'Stop', '');
|
|
|
173 |
INSERT INTO `carto_ACTION` VALUES (1, 'france', '16', 4, 'Stop', '');
|
|
|
174 |
INSERT INTO `carto_ACTION` VALUES (1, 'france', '17', 4, 'Stop', '');
|
|
|
175 |
INSERT INTO `carto_ACTION` VALUES (1, 'france', '18', 4, 'Stop', '');
|
|
|
176 |
INSERT INTO `carto_ACTION` VALUES (1, 'france', '19', 4, 'Stop', '');
|
|
|
177 |
INSERT INTO `carto_ACTION` VALUES (1, 'france', '2', 4, 'Stop', '');
|
|
|
178 |
INSERT INTO `carto_ACTION` VALUES (1, 'france', '20', 4, 'Stop', '');
|
|
|
179 |
INSERT INTO `carto_ACTION` VALUES (1, 'france', '21', 4, 'Stop', '');
|
|
|
180 |
INSERT INTO `carto_ACTION` VALUES (1, 'france', '22', 4, 'Stop', '');
|
|
|
181 |
INSERT INTO `carto_ACTION` VALUES (1, 'france', '23', 4, 'Stop', '');
|
|
|
182 |
INSERT INTO `carto_ACTION` VALUES (1, 'france', '24', 4, 'Stop', '');
|
|
|
183 |
INSERT INTO `carto_ACTION` VALUES (1, 'france', '25', 4, 'Stop', '');
|
|
|
184 |
INSERT INTO `carto_ACTION` VALUES (1, 'france', '26', 4, 'Stop', '');
|
|
|
185 |
INSERT INTO `carto_ACTION` VALUES (1, 'france', '27', 4, 'Stop', '');
|
|
|
186 |
INSERT INTO `carto_ACTION` VALUES (1, 'france', '28', 4, 'Stop', '');
|
|
|
187 |
INSERT INTO `carto_ACTION` VALUES (1, 'france', '29', 4, 'Stop', '');
|
|
|
188 |
INSERT INTO `carto_ACTION` VALUES (1, 'france', '3', 4, 'Stop', '');
|
|
|
189 |
INSERT INTO `carto_ACTION` VALUES (1, 'france', '30', 4, 'Stop', '');
|
|
|
190 |
INSERT INTO `carto_ACTION` VALUES (1, 'france', '31', 4, 'Stop', '');
|
|
|
191 |
INSERT INTO `carto_ACTION` VALUES (1, 'france', '32', 4, 'Stop', '');
|
|
|
192 |
INSERT INTO `carto_ACTION` VALUES (1, 'france', '33', 4, 'Stop', '');
|
|
|
193 |
INSERT INTO `carto_ACTION` VALUES (1, 'france', '34', 4, 'Stop', '');
|
|
|
194 |
INSERT INTO `carto_ACTION` VALUES (1, 'france', '35', 4, 'Stop', '');
|
|
|
195 |
INSERT INTO `carto_ACTION` VALUES (1, 'france', '36', 4, 'Stop', '');
|
|
|
196 |
INSERT INTO `carto_ACTION` VALUES (1, 'france', '37', 4, 'Stop', '');
|
|
|
197 |
INSERT INTO `carto_ACTION` VALUES (1, 'france', '38', 4, 'Stop', '');
|
|
|
198 |
INSERT INTO `carto_ACTION` VALUES (1, 'france', '39', 4, 'Stop', '');
|
|
|
199 |
INSERT INTO `carto_ACTION` VALUES (1, 'france', '4', 4, 'Stop', '');
|
|
|
200 |
INSERT INTO `carto_ACTION` VALUES (1, 'france', '40', 4, 'Stop', '');
|
|
|
201 |
INSERT INTO `carto_ACTION` VALUES (1, 'france', '41', 4, 'Stop', '');
|
|
|
202 |
INSERT INTO `carto_ACTION` VALUES (1, 'france', '42', 4, 'Stop', '');
|
|
|
203 |
INSERT INTO `carto_ACTION` VALUES (1, 'france', '43', 4, 'Stop', '');
|
|
|
204 |
INSERT INTO `carto_ACTION` VALUES (1, 'france', '44', 4, 'Stop', '');
|
|
|
205 |
INSERT INTO `carto_ACTION` VALUES (1, 'france', '45', 4, 'Stop', '');
|
|
|
206 |
INSERT INTO `carto_ACTION` VALUES (1, 'france', '46', 4, 'Stop', '');
|
|
|
207 |
INSERT INTO `carto_ACTION` VALUES (1, 'france', '47', 4, 'Stop', '');
|
|
|
208 |
INSERT INTO `carto_ACTION` VALUES (1, 'france', '48', 4, 'Stop', '');
|
|
|
209 |
INSERT INTO `carto_ACTION` VALUES (1, 'france', '49', 4, 'Stop', '');
|
|
|
210 |
INSERT INTO `carto_ACTION` VALUES (1, 'france', '5', 4, 'Stop', '');
|
|
|
211 |
INSERT INTO `carto_ACTION` VALUES (1, 'france', '50', 4, 'Stop', '');
|
|
|
212 |
INSERT INTO `carto_ACTION` VALUES (1, 'france', '51', 4, 'Stop', '');
|
|
|
213 |
INSERT INTO `carto_ACTION` VALUES (1, 'france', '52', 4, 'Stop', '');
|
|
|
214 |
INSERT INTO `carto_ACTION` VALUES (1, 'france', '53', 4, 'Stop', '');
|
|
|
215 |
INSERT INTO `carto_ACTION` VALUES (1, 'france', '54', 4, 'Stop', '');
|
|
|
216 |
INSERT INTO `carto_ACTION` VALUES (1, 'france', '55', 4, 'Stop', '');
|
|
|
217 |
INSERT INTO `carto_ACTION` VALUES (1, 'france', '56', 4, 'Stop', '');
|
|
|
218 |
INSERT INTO `carto_ACTION` VALUES (1, 'france', '57', 4, 'Stop', '');
|
|
|
219 |
INSERT INTO `carto_ACTION` VALUES (1, 'france', '58', 4, 'Stop', '');
|
|
|
220 |
INSERT INTO `carto_ACTION` VALUES (1, 'france', '59', 4, 'Stop', '');
|
|
|
221 |
INSERT INTO `carto_ACTION` VALUES (1, 'france', '6', 4, 'Stop', '');
|
|
|
222 |
INSERT INTO `carto_ACTION` VALUES (1, 'france', '60', 4, 'Stop', '');
|
|
|
223 |
INSERT INTO `carto_ACTION` VALUES (1, 'france', '61', 4, 'Stop', '');
|
|
|
224 |
INSERT INTO `carto_ACTION` VALUES (1, 'france', '62', 4, 'Stop', '');
|
|
|
225 |
INSERT INTO `carto_ACTION` VALUES (1, 'france', '63', 4, 'Stop', '');
|
|
|
226 |
INSERT INTO `carto_ACTION` VALUES (1, 'france', '64', 4, 'Stop', '');
|
|
|
227 |
INSERT INTO `carto_ACTION` VALUES (1, 'france', '65', 4, 'Stop', '');
|
|
|
228 |
INSERT INTO `carto_ACTION` VALUES (1, 'france', '66', 4, 'Stop', '');
|
|
|
229 |
INSERT INTO `carto_ACTION` VALUES (1, 'france', '67', 4, 'Stop', '');
|
|
|
230 |
INSERT INTO `carto_ACTION` VALUES (1, 'france', '68', 4, 'Stop', '');
|
|
|
231 |
INSERT INTO `carto_ACTION` VALUES (1, 'france', '69', 4, 'Stop', '');
|
|
|
232 |
INSERT INTO `carto_ACTION` VALUES (1, 'france', '7', 4, 'Stop', '');
|
|
|
233 |
INSERT INTO `carto_ACTION` VALUES (1, 'france', '70', 4, 'Stop', '');
|
|
|
234 |
INSERT INTO `carto_ACTION` VALUES (1, 'france', '71', 4, 'Stop', '');
|
|
|
235 |
INSERT INTO `carto_ACTION` VALUES (1, 'france', '72', 4, 'Stop', '');
|
|
|
236 |
INSERT INTO `carto_ACTION` VALUES (1, 'france', '73', 4, 'Stop', '');
|
|
|
237 |
INSERT INTO `carto_ACTION` VALUES (1, 'france', '74', 4, 'Stop', '');
|
|
|
238 |
INSERT INTO `carto_ACTION` VALUES (1, 'france', '75', 4, 'Stop', '');
|
|
|
239 |
INSERT INTO `carto_ACTION` VALUES (1, 'france', '76', 4, 'Stop', '');
|
|
|
240 |
INSERT INTO `carto_ACTION` VALUES (1, 'france', '77', 4, 'Stop', '');
|
|
|
241 |
INSERT INTO `carto_ACTION` VALUES (1, 'france', '78', 4, 'Stop', '');
|
|
|
242 |
INSERT INTO `carto_ACTION` VALUES (1, 'france', '79', 4, 'Stop', '');
|
|
|
243 |
INSERT INTO `carto_ACTION` VALUES (1, 'france', '8', 4, 'Stop', '');
|
|
|
244 |
INSERT INTO `carto_ACTION` VALUES (1, 'france', '80', 4, 'Stop', '');
|
|
|
245 |
INSERT INTO `carto_ACTION` VALUES (1, 'france', '81', 4, 'Stop', '');
|
|
|
246 |
INSERT INTO `carto_ACTION` VALUES (1, 'france', '82', 4, 'Stop', '');
|
|
|
247 |
INSERT INTO `carto_ACTION` VALUES (1, 'france', '83', 4, 'Stop', '');
|
|
|
248 |
INSERT INTO `carto_ACTION` VALUES (1, 'france', '84', 4, 'Stop', '');
|
|
|
249 |
INSERT INTO `carto_ACTION` VALUES (1, 'france', '85', 4, 'Stop', '');
|
|
|
250 |
INSERT INTO `carto_ACTION` VALUES (1, 'france', '86', 4, 'Stop', '');
|
|
|
251 |
INSERT INTO `carto_ACTION` VALUES (1, 'france', '87', 4, 'Stop', '');
|
|
|
252 |
INSERT INTO `carto_ACTION` VALUES (1, 'france', '88', 4, 'Stop', '');
|
|
|
253 |
INSERT INTO `carto_ACTION` VALUES (1, 'france', '89', 4, 'Stop', '');
|
|
|
254 |
INSERT INTO `carto_ACTION` VALUES (1, 'france', '9', 4, 'Stop', '');
|
|
|
255 |
INSERT INTO `carto_ACTION` VALUES (1, 'france', '90', 4, 'Stop', '');
|
|
|
256 |
INSERT INTO `carto_ACTION` VALUES (1, 'france', '91', 4, 'Stop', '');
|
|
|
257 |
INSERT INTO `carto_ACTION` VALUES (1, 'france', '92', 4, 'Stop', '');
|
|
|
258 |
INSERT INTO `carto_ACTION` VALUES (1, 'france', '93', 4, 'Stop', '');
|
|
|
259 |
INSERT INTO `carto_ACTION` VALUES (1, 'france', '94', 4, 'Stop', '');
|
|
|
260 |
INSERT INTO `carto_ACTION` VALUES (1, 'france', '95', 4, 'Stop', '');
|
|
|
261 |
INSERT INTO `carto_ACTION` VALUES (1, 'france', '971', 4, 'Stop', '');
|
|
|
262 |
INSERT INTO `carto_ACTION` VALUES (1, 'france', '972', 4, 'Stop', '');
|
|
|
263 |
INSERT INTO `carto_ACTION` VALUES (1, 'france', '973', 4, 'Stop', '');
|
|
|
264 |
INSERT INTO `carto_ACTION` VALUES (1, 'france', '974', 4, 'Stop', '');
|
|
|
265 |
INSERT INTO `carto_ACTION` VALUES (1, 'france', '975', 4, 'Stop', '');
|
|
|
266 |
INSERT INTO `carto_ACTION` VALUES (1, 'france', '976', 4, 'Stop', '');
|
|
|
267 |
INSERT INTO `carto_ACTION` VALUES (1, 'france', '980', 4, 'Stop', '');
|
|
|
268 |
INSERT INTO `carto_ACTION` VALUES (1, 'france', '986', 4, 'Stop', '');
|
|
|
269 |
INSERT INTO `carto_ACTION` VALUES (1, 'france', '987', 4, 'Stop', '');
|
|
|
270 |
INSERT INTO `carto_ACTION` VALUES (1, 'france', '988', 4, 'Stop', '');
|
|
|
271 |
INSERT INTO `carto_ACTION` VALUES (1, 'france', '99', 4, 'Recharger', '');
|
|
|
272 |
INSERT INTO `carto_ACTION` VALUES (1, 'moyenorient', '0', 2, 'Recharger', '');
|
|
|
273 |
INSERT INTO `carto_ACTION` VALUES (1, 'moyenorient', 'ae', 2, 'Stop', '');
|
|
|
274 |
INSERT INTO `carto_ACTION` VALUES (1, 'moyenorient', 'af', 2, 'Stop', '');
|
|
|
275 |
INSERT INTO `carto_ACTION` VALUES (1, 'moyenorient', 'am', 2, 'Stop', '');
|
|
|
276 |
INSERT INTO `carto_ACTION` VALUES (1, 'moyenorient', 'az', 2, 'Stop', '');
|
|
|
277 |
INSERT INTO `carto_ACTION` VALUES (1, 'moyenorient', 'bh', 2, 'Stop', '');
|
|
|
278 |
INSERT INTO `carto_ACTION` VALUES (1, 'moyenorient', 'ge', 2, 'Stop', '');
|
|
|
279 |
INSERT INTO `carto_ACTION` VALUES (1, 'moyenorient', 'il', 2, 'Stop', '');
|
|
|
280 |
INSERT INTO `carto_ACTION` VALUES (1, 'moyenorient', 'iq', 2, 'Stop', '');
|
|
|
281 |
INSERT INTO `carto_ACTION` VALUES (1, 'moyenorient', 'ir', 2, 'Stop', '');
|
|
|
282 |
INSERT INTO `carto_ACTION` VALUES (1, 'moyenorient', 'jo', 2, 'Stop', '');
|
|
|
283 |
INSERT INTO `carto_ACTION` VALUES (1, 'moyenorient', 'kg', 2, 'Stop', '');
|
|
|
284 |
INSERT INTO `carto_ACTION` VALUES (1, 'moyenorient', 'kw', 2, 'Stop', '');
|
|
|
285 |
INSERT INTO `carto_ACTION` VALUES (1, 'moyenorient', 'lb', 2, 'Stop', '');
|
|
|
286 |
INSERT INTO `carto_ACTION` VALUES (1, 'moyenorient', 'om', 2, 'Stop', '');
|
|
|
287 |
INSERT INTO `carto_ACTION` VALUES (1, 'moyenorient', 'pk', 2, 'Stop', '');
|
|
|
288 |
INSERT INTO `carto_ACTION` VALUES (1, 'moyenorient', 'ps', 2, 'Stop', '');
|
|
|
289 |
INSERT INTO `carto_ACTION` VALUES (1, 'moyenorient', 'qa', 2, 'Stop', '');
|
|
|
290 |
INSERT INTO `carto_ACTION` VALUES (1, 'moyenorient', 'sa', 2, 'Stop', '');
|
|
|
291 |
INSERT INTO `carto_ACTION` VALUES (1, 'moyenorient', 'sy', 2, 'Stop', '');
|
|
|
292 |
INSERT INTO `carto_ACTION` VALUES (1, 'moyenorient', 'tj', 2, 'Stop', '');
|
|
|
293 |
INSERT INTO `carto_ACTION` VALUES (1, 'moyenorient', 'tm', 2, 'Stop', '');
|
|
|
294 |
INSERT INTO `carto_ACTION` VALUES (1, 'moyenorient', 'tr', 2, 'Stop', '');
|
|
|
295 |
INSERT INTO `carto_ACTION` VALUES (1, 'moyenorient', 'uz', 2, 'Stop', '');
|
|
|
296 |
INSERT INTO `carto_ACTION` VALUES (1, 'moyenorient', 'ye', 2, 'Stop', '');
|
|
|
297 |
INSERT INTO `carto_ACTION` VALUES (1, 'namerique', '0', 2, 'Recharger', '');
|
|
|
298 |
INSERT INTO `carto_ACTION` VALUES (1, 'namerique', 'ag', 2, 'Stop', '');
|
|
|
299 |
INSERT INTO `carto_ACTION` VALUES (1, 'namerique', 'bb', 2, 'Stop', '');
|
|
|
300 |
INSERT INTO `carto_ACTION` VALUES (1, 'namerique', 'bs', 2, 'Stop', '');
|
|
|
301 |
INSERT INTO `carto_ACTION` VALUES (1, 'namerique', 'bz', 2, 'Stop', '');
|
|
|
302 |
INSERT INTO `carto_ACTION` VALUES (1, 'namerique', 'ca', 2, 'Stop', '');
|
|
|
303 |
INSERT INTO `carto_ACTION` VALUES (1, 'namerique', 'cr', 2, 'Stop', '');
|
|
|
304 |
INSERT INTO `carto_ACTION` VALUES (1, 'namerique', 'cu', 2, 'Stop', '');
|
|
|
305 |
INSERT INTO `carto_ACTION` VALUES (1, 'namerique', 'dm', 2, 'Stop', '');
|
|
|
306 |
INSERT INTO `carto_ACTION` VALUES (1, 'namerique', 'gd', 2, 'Stop', '');
|
|
|
307 |
INSERT INTO `carto_ACTION` VALUES (1, 'namerique', 'gl', 2, 'Stop', '');
|
|
|
308 |
INSERT INTO `carto_ACTION` VALUES (1, 'namerique', 'gt', 2, 'Stop', '');
|
|
|
309 |
INSERT INTO `carto_ACTION` VALUES (1, 'namerique', 'hn', 2, 'Stop', '');
|
|
|
310 |
INSERT INTO `carto_ACTION` VALUES (1, 'namerique', 'ht', 2, 'Stop', '');
|
|
|
311 |
INSERT INTO `carto_ACTION` VALUES (1, 'namerique', 'jm', 2, 'Stop', '');
|
|
|
312 |
INSERT INTO `carto_ACTION` VALUES (1, 'namerique', 'lc', 2, 'Stop', '');
|
|
|
313 |
INSERT INTO `carto_ACTION` VALUES (1, 'namerique', 'mx', 2, 'Stop', '');
|
|
|
314 |
INSERT INTO `carto_ACTION` VALUES (1, 'namerique', 'ni', 2, 'Stop', '');
|
|
|
315 |
INSERT INTO `carto_ACTION` VALUES (1, 'namerique', 'pa', 2, 'Stop', '');
|
|
|
316 |
INSERT INTO `carto_ACTION` VALUES (1, 'namerique', 'sv', 2, 'Stop', '');
|
|
|
317 |
INSERT INTO `carto_ACTION` VALUES (1, 'namerique', 'tt', 2, 'Stop', '');
|
|
|
318 |
INSERT INTO `carto_ACTION` VALUES (1, 'namerique', 'us', 2, 'Stop', '');
|
|
|
319 |
INSERT INTO `carto_ACTION` VALUES (1, 'namerique', 'vc', 2, 'Stop', '');
|
|
|
320 |
INSERT INTO `carto_ACTION` VALUES (1, 'oceanie', '0', 2, 'Recharger', '');
|
|
|
321 |
INSERT INTO `carto_ACTION` VALUES (1, 'oceanie', 'au', 2, 'Stop', '');
|
|
|
322 |
INSERT INTO `carto_ACTION` VALUES (1, 'oceanie', 'fj', 2, 'Stop', '');
|
|
|
323 |
INSERT INTO `carto_ACTION` VALUES (1, 'oceanie', 'fm', 2, 'Stop', '');
|
|
|
324 |
INSERT INTO `carto_ACTION` VALUES (1, 'oceanie', 'ki', 2, 'Stop', '');
|
|
|
325 |
INSERT INTO `carto_ACTION` VALUES (1, 'oceanie', 'mh', 2, 'Stop', '');
|
|
|
326 |
INSERT INTO `carto_ACTION` VALUES (1, 'oceanie', 'nr', 2, 'Stop', '');
|
|
|
327 |
INSERT INTO `carto_ACTION` VALUES (1, 'oceanie', 'nz', 2, 'Stop', '');
|
|
|
328 |
INSERT INTO `carto_ACTION` VALUES (1, 'oceanie', 'pg', 2, 'Stop', '');
|
|
|
329 |
INSERT INTO `carto_ACTION` VALUES (1, 'oceanie', 'pw', 2, 'Stop', '');
|
|
|
330 |
INSERT INTO `carto_ACTION` VALUES (1, 'oceanie', 'sb', 2, 'Stop', '');
|
|
|
331 |
INSERT INTO `carto_ACTION` VALUES (1, 'oceanie', 'to', 2, 'Stop', '');
|
|
|
332 |
INSERT INTO `carto_ACTION` VALUES (1, 'oceanie', 'tv', 2, 'Stop', '');
|
|
|
333 |
INSERT INTO `carto_ACTION` VALUES (1, 'oceanie', 'vu', 2, 'Stop', '');
|
|
|
334 |
INSERT INTO `carto_ACTION` VALUES (1, 'oceanie', 'ws', 2, 'Stop', '');
|
|
|
335 |
INSERT INTO `carto_ACTION` VALUES (1, 'samerique', '0', 2, 'Recharger', '');
|
|
|
336 |
INSERT INTO `carto_ACTION` VALUES (1, 'samerique', 'ar', 2, 'Stop', '');
|
|
|
337 |
INSERT INTO `carto_ACTION` VALUES (1, 'samerique', 'bo', 2, 'Stop', '');
|
|
|
338 |
INSERT INTO `carto_ACTION` VALUES (1, 'samerique', 'br', 2, 'Stop', '');
|
|
|
339 |
INSERT INTO `carto_ACTION` VALUES (1, 'samerique', 'cl', 2, 'Stop', '');
|
|
|
340 |
INSERT INTO `carto_ACTION` VALUES (1, 'samerique', 'co', 2, 'Stop', '');
|
|
|
341 |
INSERT INTO `carto_ACTION` VALUES (1, 'samerique', 'ec', 2, 'Stop', '');
|
|
|
342 |
INSERT INTO `carto_ACTION` VALUES (1, 'samerique', 'gy', 2, 'Stop', '');
|
|
|
343 |
INSERT INTO `carto_ACTION` VALUES (1, 'samerique', 'pe', 2, 'Stop', '');
|
|
|
344 |
INSERT INTO `carto_ACTION` VALUES (1, 'samerique', 'py', 2, 'Stop', '');
|
|
|
345 |
INSERT INTO `carto_ACTION` VALUES (1, 'samerique', 'sr', 2, 'Stop', '');
|
|
|
346 |
INSERT INTO `carto_ACTION` VALUES (1, 'samerique', 'uy', 2, 'Stop', '');
|
|
|
347 |
INSERT INTO `carto_ACTION` VALUES (1, 'samerique', 've', 2, 'Stop', '');
|
|
|
348 |
|
|
|
349 |
# --------------------------------------------------------
|
|
|
350 |
|
|
|
351 |
#
|
|
|
352 |
# Structure de la table `carto_CONTINENT`
|
|
|
353 |
#
|
|
|
354 |
|
|
|
355 |
DROP TABLE IF EXISTS `carto_CONTINENT`;
|
|
|
356 |
CREATE TABLE `carto_CONTINENT` (
|
|
|
357 |
`CC_ID_Continent` tinyint(4) unsigned NOT NULL default '0',
|
|
|
358 |
`CC_Intitule_continent` varchar(100) NOT NULL default '',
|
|
|
359 |
`CC_Couleur_R` tinyint(4) unsigned NOT NULL default '0',
|
|
|
360 |
`CC_Couleur_V` tinyint(4) unsigned NOT NULL default '0',
|
|
|
361 |
`CC_Couleur_B` tinyint(4) unsigned NOT NULL default '0'
|
|
|
362 |
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
|
|
|
363 |
|
|
|
364 |
#
|
|
|
365 |
# Contenu de la table `carto_CONTINENT`
|
|
|
366 |
#
|
|
|
367 |
|
|
|
368 |
INSERT INTO `carto_CONTINENT` VALUES (1, 'Afrique', 60, 174, 15);
|
|
|
369 |
INSERT INTO `carto_CONTINENT` VALUES (2, 'Amérique du Nord', 128, 218, 141);
|
|
|
370 |
INSERT INTO `carto_CONTINENT` VALUES (3, 'Asie', 189, 179, 25);
|
|
|
371 |
INSERT INTO `carto_CONTINENT` VALUES (4, 'Europe', 0, 128, 218);
|
|
|
372 |
INSERT INTO `carto_CONTINENT` VALUES (5, 'Océanie', 206, 0, 0);
|
|
|
373 |
INSERT INTO `carto_CONTINENT` VALUES (6, 'Amérique du Sud', 255, 125, 0);
|
|
|
374 |
INSERT INTO `carto_CONTINENT` VALUES (7, 'Moyen-Orient', 0, 0, 255);
|
|
|
375 |
INSERT INTO `carto_CONTINENT` VALUES (0, ' ', 255, 255, 255);
|
|
|
376 |
|
|
|
377 |
# --------------------------------------------------------
|
|
|
378 |
|
|
|
379 |
#
|
|
|
380 |
# Structure de la table `carto_DEPARTEMENT`
|
|
|
381 |
#
|
|
|
382 |
|
|
|
383 |
DROP TABLE IF EXISTS `carto_DEPARTEMENT`;
|
|
|
384 |
CREATE TABLE `carto_DEPARTEMENT` (
|
|
|
385 |
`CD_ID_Departement` smallint(3) unsigned NOT NULL default '0',
|
|
|
386 |
`CD_Intitule_departement` varchar(100) NOT NULL default '',
|
|
|
387 |
`CD_Couleur_R` tinyint(3) unsigned NOT NULL default '0',
|
|
|
388 |
`CD_Couleur_V` tinyint(3) unsigned NOT NULL default '0',
|
|
|
389 |
`CD_Couleur_B` tinyint(3) unsigned NOT NULL default '0',
|
|
|
390 |
`CD_ID_Region` int(10) unsigned NOT NULL default '0',
|
|
|
391 |
`CD_ID_Pays` char(3) NOT NULL default '',
|
|
|
392 |
PRIMARY KEY (`CD_ID_Departement`)
|
|
|
393 |
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
|
|
|
394 |
|
|
|
395 |
#
|
|
|
396 |
# Contenu de la table `carto_DEPARTEMENT`
|
|
|
397 |
#
|
|
|
398 |
|
|
|
399 |
INSERT INTO `carto_DEPARTEMENT` VALUES (1, 'Ain', 0, 204, 51, 22, 'fr');
|
|
|
400 |
INSERT INTO `carto_DEPARTEMENT` VALUES (2, 'Aisne', 240, 240, 255, 19, 'fr');
|
|
|
401 |
INSERT INTO `carto_DEPARTEMENT` VALUES (3, 'Allier', 255, 125, 125, 3, 'fr');
|
|
|
402 |
INSERT INTO `carto_DEPARTEMENT` VALUES (4, 'Alpes-de-Haute-Provence', 51, 51, 153, 21, 'fr');
|
|
|
403 |
INSERT INTO `carto_DEPARTEMENT` VALUES (5, 'Hautes-Alpes', 51, 51, 204, 21, 'fr');
|
|
|
404 |
INSERT INTO `carto_DEPARTEMENT` VALUES (6, 'Alpes-Maritimes', 51, 51, 102, 21, 'fr');
|
|
|
405 |
INSERT INTO `carto_DEPARTEMENT` VALUES (7, 'Ardèche', 0, 102, 51, 22, 'fr');
|
|
|
406 |
INSERT INTO `carto_DEPARTEMENT` VALUES (8, 'Ardennes', 0, 255, 0, 8, 'fr');
|
|
|
407 |
INSERT INTO `carto_DEPARTEMENT` VALUES (9, 'Ariège', 255, 102, 102, 16, 'fr');
|
|
|
408 |
INSERT INTO `carto_DEPARTEMENT` VALUES (10, 'Aube', 50, 255, 50, 8, 'fr');
|
|
|
409 |
INSERT INTO `carto_DEPARTEMENT` VALUES (11, 'Aude', 102, 51, 0, 13, 'fr');
|
|
|
410 |
INSERT INTO `carto_DEPARTEMENT` VALUES (12, 'Aveyron', 255, 153, 0, 16, 'fr');
|
|
|
411 |
INSERT INTO `carto_DEPARTEMENT` VALUES (13, 'Bouches-du-Rhône', 0, 0, 153, 21, 'fr');
|
|
|
412 |
INSERT INTO `carto_DEPARTEMENT` VALUES (14, 'Calvados', 150, 150, 255, 4, 'fr');
|
|
|
413 |
INSERT INTO `carto_DEPARTEMENT` VALUES (15, 'Cantal', 255, 175, 175, 3, 'fr');
|
|
|
414 |
INSERT INTO `carto_DEPARTEMENT` VALUES (16, 'Charente', 175, 255, 175, 20, 'fr');
|
|
|
415 |
INSERT INTO `carto_DEPARTEMENT` VALUES (17, 'Charente-Maritime', 150, 255, 150, 20, 'fr');
|
|
|
416 |
INSERT INTO `carto_DEPARTEMENT` VALUES (18, 'Cher', 125, 255, 255, 7, 'fr');
|
|
|
417 |
INSERT INTO `carto_DEPARTEMENT` VALUES (19, 'Corrèze', 255, 255, 150, 14, 'fr');
|
|
|
418 |
INSERT INTO `carto_DEPARTEMENT` VALUES (20, 'Corse', 51, 255, 204, 9, 'fr');
|
|
|
419 |
INSERT INTO `carto_DEPARTEMENT` VALUES (21, 'Côte-d\'Or', 50, 151, 255, 5, 'fr');
|
|
|
420 |
INSERT INTO `carto_DEPARTEMENT` VALUES (22, 'Côtes-d\'Armor', 75, 75, 255, 6, 'fr');
|
|
|
421 |
INSERT INTO `carto_DEPARTEMENT` VALUES (23, 'Creuse', 255, 255, 125, 14, 'fr');
|
|
|
422 |
INSERT INTO `carto_DEPARTEMENT` VALUES (24, 'Dordogne', 102, 153, 102, 2, 'fr');
|
|
|
423 |
INSERT INTO `carto_DEPARTEMENT` VALUES (25, 'Doubs', 255, 255, 50, 10, 'fr');
|
|
|
424 |
INSERT INTO `carto_DEPARTEMENT` VALUES (26, 'Drôme', 1, 51, 51, 22, 'fr');
|
|
|
425 |
INSERT INTO `carto_DEPARTEMENT` VALUES (27, 'Eure', 204, 255, 0, 11, 'fr');
|
|
|
426 |
INSERT INTO `carto_DEPARTEMENT` VALUES (28, 'Eure-et-Loir', 0, 255, 255, 7, 'fr');
|
|
|
427 |
INSERT INTO `carto_DEPARTEMENT` VALUES (29, 'Finistère', 25, 25, 255, 6, 'fr');
|
|
|
428 |
INSERT INTO `carto_DEPARTEMENT` VALUES (30, 'Gard', 255, 204, 0, 13, 'fr');
|
|
|
429 |
INSERT INTO `carto_DEPARTEMENT` VALUES (31, 'Haute-Garonne', 204, 102, 102, 16, 'fr');
|
|
|
430 |
INSERT INTO `carto_DEPARTEMENT` VALUES (32, 'Gers', 204, 153, 51, 16, 'fr');
|
|
|
431 |
INSERT INTO `carto_DEPARTEMENT` VALUES (33, 'Gironde', 153, 204, 153, 2, 'fr');
|
|
|
432 |
INSERT INTO `carto_DEPARTEMENT` VALUES (34, 'Hérault', 204, 153, 0, 13, 'fr');
|
|
|
433 |
INSERT INTO `carto_DEPARTEMENT` VALUES (35, 'Ille-et-Vilaine', 100, 100, 255, 6, 'fr');
|
|
|
434 |
INSERT INTO `carto_DEPARTEMENT` VALUES (36, 'Indre', 100, 255, 255, 7, 'fr');
|
|
|
435 |
INSERT INTO `carto_DEPARTEMENT` VALUES (37, 'Indre-et-Loire', 75, 255, 255, 7, 'fr');
|
|
|
436 |
INSERT INTO `carto_DEPARTEMENT` VALUES (38, 'Isère', 51, 102, 102, 22, 'fr');
|
|
|
437 |
INSERT INTO `carto_DEPARTEMENT` VALUES (39, 'Jura', 255, 255, 75, 10, 'fr');
|
|
|
438 |
INSERT INTO `carto_DEPARTEMENT` VALUES (40, 'Landes', 153, 255, 153, 2, 'fr');
|
|
|
439 |
INSERT INTO `carto_DEPARTEMENT` VALUES (41, 'Loir-et-Cher', 50, 255, 255, 7, 'fr');
|
|
|
440 |
INSERT INTO `carto_DEPARTEMENT` VALUES (42, 'Loire', 0, 153, 51, 22, 'fr');
|
|
|
441 |
INSERT INTO `carto_DEPARTEMENT` VALUES (43, 'Haute-Loire', 255, 200, 200, 3, 'fr');
|
|
|
442 |
INSERT INTO `carto_DEPARTEMENT` VALUES (44, 'Loire-Atlantique', 255, 0, 0, 18, 'fr');
|
|
|
443 |
INSERT INTO `carto_DEPARTEMENT` VALUES (45, 'Loiret', 25, 255, 255, 7, 'fr');
|
|
|
444 |
INSERT INTO `carto_DEPARTEMENT` VALUES (46, 'Lot', 204, 102, 0, 16, 'fr');
|
|
|
445 |
INSERT INTO `carto_DEPARTEMENT` VALUES (47, 'Lot-et-Garonne', 204, 255, 204, 2, 'fr');
|
|
|
446 |
INSERT INTO `carto_DEPARTEMENT` VALUES (48, 'Lozére', 153, 102, 0, 13, 'fr');
|
|
|
447 |
INSERT INTO `carto_DEPARTEMENT` VALUES (49, 'Maine-et-Loire', 255, 100, 100, 18, 'fr');
|
|
|
448 |
INSERT INTO `carto_DEPARTEMENT` VALUES (50, 'Manche', 125, 125, 255, 4, 'fr');
|
|
|
449 |
INSERT INTO `carto_DEPARTEMENT` VALUES (51, 'Marne', 25, 255, 25, 8, 'fr');
|
|
|
450 |
INSERT INTO `carto_DEPARTEMENT` VALUES (52, 'Haute-Marne', 75, 255, 75, 8, 'fr');
|
|
|
451 |
INSERT INTO `carto_DEPARTEMENT` VALUES (53, 'Mayenne', 255, 75, 75, 18, 'fr');
|
|
|
452 |
INSERT INTO `carto_DEPARTEMENT` VALUES (54, 'Meurthe-et-Moselle', 102, 0, 102, 15, 'fr');
|
|
|
453 |
INSERT INTO `carto_DEPARTEMENT` VALUES (55, 'Meuse', 153, 0, 153, 15, 'fr');
|
|
|
454 |
INSERT INTO `carto_DEPARTEMENT` VALUES (56, 'Morbihan', 50, 50, 255, 6, 'fr');
|
|
|
455 |
INSERT INTO `carto_DEPARTEMENT` VALUES (57, 'Moselle', 204, 0, 204, 15, 'fr');
|
|
|
456 |
INSERT INTO `carto_DEPARTEMENT` VALUES (58, 'Nièvre', 100, 151, 255, 5, 'fr');
|
|
|
457 |
INSERT INTO `carto_DEPARTEMENT` VALUES (59, 'Nord', 153, 153, 51, 17, 'fr');
|
|
|
458 |
INSERT INTO `carto_DEPARTEMENT` VALUES (60, 'Oise', 225, 225, 255, 19, 'fr');
|
|
|
459 |
INSERT INTO `carto_DEPARTEMENT` VALUES (61, 'Orne', 175, 175, 255, 4, 'fr');
|
|
|
460 |
INSERT INTO `carto_DEPARTEMENT` VALUES (62, 'Pas-de-Calais', 102, 102, 51, 17, 'fr');
|
|
|
461 |
INSERT INTO `carto_DEPARTEMENT` VALUES (63, 'Puy-de-Dôme', 255, 150, 150, 3, 'fr');
|
|
|
462 |
INSERT INTO `carto_DEPARTEMENT` VALUES (64, 'Pyrénnées-Atlantiques', 102, 255, 102, 2, 'fr');
|
|
|
463 |
INSERT INTO `carto_DEPARTEMENT` VALUES (65, 'Hautes-Pyrénnées', 153, 102, 51, 16, 'fr');
|
|
|
464 |
INSERT INTO `carto_DEPARTEMENT` VALUES (66, 'Pyrénnées-Orientales', 51, 51, 0, 13, 'fr');
|
|
|
465 |
INSERT INTO `carto_DEPARTEMENT` VALUES (67, 'Bas-Rhin', 204, 204, 51, 1, 'fr');
|
|
|
466 |
INSERT INTO `carto_DEPARTEMENT` VALUES (68, 'Haut-Rhin', 153, 153, 0, 1, 'fr');
|
|
|
467 |
INSERT INTO `carto_DEPARTEMENT` VALUES (69, 'Rhône', 0, 255, 51, 22, 'fr');
|
|
|
468 |
INSERT INTO `carto_DEPARTEMENT` VALUES (70, 'Haute-Saône', 255, 255, 0, 10, 'fr');
|
|
|
469 |
INSERT INTO `carto_DEPARTEMENT` VALUES (71, 'Saône-et-Loire', 150, 151, 255, 5, 'fr');
|
|
|
470 |
INSERT INTO `carto_DEPARTEMENT` VALUES (72, 'Sarthe', 255, 25, 25, 18, 'fr');
|
|
|
471 |
INSERT INTO `carto_DEPARTEMENT` VALUES (73, 'Savoie', 51, 153, 153, 22, 'fr');
|
|
|
472 |
INSERT INTO `carto_DEPARTEMENT` VALUES (74, 'Haute-Savoie', 0, 204, 204, 22, 'fr');
|
|
|
473 |
INSERT INTO `carto_DEPARTEMENT` VALUES (75, 'Paris', 199, 255, 175, 12, 'fr');
|
|
|
474 |
INSERT INTO `carto_DEPARTEMENT` VALUES (76, 'Seine-Maritime', 204, 204, 0, 11, 'fr');
|
|
|
475 |
INSERT INTO `carto_DEPARTEMENT` VALUES (77, 'Seine-et-Marne', 199, 255, 75, 12, 'fr');
|
|
|
476 |
INSERT INTO `carto_DEPARTEMENT` VALUES (78, 'Yvelines', 199, 255, 25, 12, 'fr');
|
|
|
477 |
INSERT INTO `carto_DEPARTEMENT` VALUES (79, 'Deux-Sèvres', 100, 255, 100, 20, 'fr');
|
|
|
478 |
INSERT INTO `carto_DEPARTEMENT` VALUES (80, 'Somme', 200, 200, 255, 19, 'fr');
|
|
|
479 |
INSERT INTO `carto_DEPARTEMENT` VALUES (81, 'Tarn', 153, 102, 102, 16, 'fr');
|
|
|
480 |
INSERT INTO `carto_DEPARTEMENT` VALUES (82, 'Tarn-et-Garonne', 153, 51, 0, 16, 'fr');
|
|
|
481 |
INSERT INTO `carto_DEPARTEMENT` VALUES (83, 'Var', 0, 0, 204, 21, 'fr');
|
|
|
482 |
INSERT INTO `carto_DEPARTEMENT` VALUES (84, 'Vaucluse', 0, 0, 102, 21, 'fr');
|
|
|
483 |
INSERT INTO `carto_DEPARTEMENT` VALUES (85, 'Vendée', 255, 50, 50, 18, 'fr');
|
|
|
484 |
INSERT INTO `carto_DEPARTEMENT` VALUES (86, 'Vienne', 125, 255, 125, 20, 'fr');
|
|
|
485 |
INSERT INTO `carto_DEPARTEMENT` VALUES (87, 'Haute-Vienne', 255, 255, 100, 14, 'fr');
|
|
|
486 |
INSERT INTO `carto_DEPARTEMENT` VALUES (88, 'Vosges', 255, 0, 255, 15, 'fr');
|
|
|
487 |
INSERT INTO `carto_DEPARTEMENT` VALUES (89, 'Yonne', 0, 151, 255, 5, 'fr');
|
|
|
488 |
INSERT INTO `carto_DEPARTEMENT` VALUES (90, 'Territoire-de-Belfort', 255, 255, 25, 10, 'fr');
|
|
|
489 |
INSERT INTO `carto_DEPARTEMENT` VALUES (91, 'Essonne', 199, 255, 50, 12, 'fr');
|
|
|
490 |
INSERT INTO `carto_DEPARTEMENT` VALUES (92, 'Hauts-de-Seine', 199, 255, 100, 12, 'fr');
|
|
|
491 |
INSERT INTO `carto_DEPARTEMENT` VALUES (93, 'Seine-Saint-Denis', 199, 255, 125, 12, 'fr');
|
|
|
492 |
INSERT INTO `carto_DEPARTEMENT` VALUES (94, 'Val-de-Marne', 199, 255, 150, 12, 'fr');
|
|
|
493 |
INSERT INTO `carto_DEPARTEMENT` VALUES (95, 'Val-d\'Oise', 199, 255, 0, 12, 'fr');
|
|
|
494 |
INSERT INTO `carto_DEPARTEMENT` VALUES (99, 'Etranger', 255, 255, 255, 900, '');
|
|
|
495 |
INSERT INTO `carto_DEPARTEMENT` VALUES (971, 'Guadeloupe', 161, 161, 25, 900, 'fr');
|
|
|
496 |
INSERT INTO `carto_DEPARTEMENT` VALUES (972, 'Martinique', 161, 161, 125, 900, 'fr');
|
|
|
497 |
INSERT INTO `carto_DEPARTEMENT` VALUES (973, 'Guyane', 161, 161, 200, 900, 'fr');
|
|
|
498 |
INSERT INTO `carto_DEPARTEMENT` VALUES (974, 'Réunion', 161, 161, 225, 900, 'fr');
|
|
|
499 |
INSERT INTO `carto_DEPARTEMENT` VALUES (975, 'St-Pierre-et-Miquelon', 25, 161, 161, 900, 'fr');
|
|
|
500 |
INSERT INTO `carto_DEPARTEMENT` VALUES (976, 'Mayotte', 125, 161, 161, 900, 'fr');
|
|
|
501 |
INSERT INTO `carto_DEPARTEMENT` VALUES (980, 'Monaco', 1, 1, 1, 900, 'fr');
|
|
|
502 |
INSERT INTO `carto_DEPARTEMENT` VALUES (986, 'Wallis-et-Futuna', 200, 161, 161, 900, 'fr');
|
|
|
503 |
INSERT INTO `carto_DEPARTEMENT` VALUES (987, 'Polynésie-Française', 225, 161, 161, 900, 'fr');
|
|
|
504 |
INSERT INTO `carto_DEPARTEMENT` VALUES (988, 'Nouvelle-Calédonie', 225, 225, 161, 900, 'fr');
|
|
|
505 |
|
|
|
506 |
# --------------------------------------------------------
|
|
|
507 |
|
|
|
508 |
#
|
|
|
509 |
# Structure de la table `carto_DESCRIPTION_CARTE`
|
|
|
510 |
#
|
|
|
511 |
|
|
|
512 |
DROP TABLE IF EXISTS `carto_DESCRIPTION_CARTE`;
|
|
|
513 |
CREATE TABLE `carto_DESCRIPTION_CARTE` (
|
|
|
514 |
`CDC_ID_Carte` varchar(32) NOT NULL default '',
|
|
|
515 |
`CDC_Titre_carte` varchar(100) NOT NULL default '',
|
|
|
516 |
`CDC_Infos_carte` mediumblob NOT NULL,
|
|
|
517 |
`CDC_Carte_fond` varchar(100) NOT NULL default '',
|
|
|
518 |
`CDC_Carte_masque` varchar(100) NOT NULL default '',
|
|
|
519 |
`CDC_ID_Zone_geo_carte` varchar(255) NOT NULL default '',
|
|
|
520 |
`CDC_Type_zone_carte` int(10) unsigned NOT NULL default '0',
|
|
|
521 |
`CDC_Type_zone_contenu_carte` int(10) unsigned NOT NULL default '0',
|
|
|
522 |
KEY `CM_PROJECT` (`CDC_ID_Carte`)
|
|
|
523 |
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
|
|
|
524 |
|
|
|
525 |
#
|
|
|
526 |
# Contenu de la table `carto_DESCRIPTION_CARTE`
|
|
|
527 |
#
|
|
|
528 |
|
|
|
529 |
INSERT INTO `carto_DESCRIPTION_CARTE` VALUES ('europe', 'Europe', '', 'europe.png', 'europe_masque.png', '4', 1, 2);
|
|
|
530 |
INSERT INTO `carto_DESCRIPTION_CARTE` VALUES ('france', 'France', '', 'france_region.png', 'france_masque.png', 'fr', 2, 4);
|
|
|
531 |
INSERT INTO `carto_DESCRIPTION_CARTE` VALUES ('continent', 'Monde', '', 'monde5c.png', 'monde_masque5c.png', '', 0, 1);
|
|
|
532 |
INSERT INTO `carto_DESCRIPTION_CARTE` VALUES ('afrique', 'Afrique', '', 'afrique.png', 'afrique_masque.png', '1', 1, 2);
|
|
|
533 |
INSERT INTO `carto_DESCRIPTION_CARTE` VALUES ('oceanie', 'Océanie', '', 'oceanie.png', 'oceanie_masque.png', '5', 1, 2);
|
|
|
534 |
INSERT INTO `carto_DESCRIPTION_CARTE` VALUES ('namerique', 'Amérique du Nord', '', 'namerique.png', 'namerique_masque.png', '2', 1, 2);
|
|
|
535 |
INSERT INTO `carto_DESCRIPTION_CARTE` VALUES ('samerique', 'Amérique du Sud', '', 'samerique.png', 'samerique_masque.png', '6', 1, 2);
|
|
|
536 |
INSERT INTO `carto_DESCRIPTION_CARTE` VALUES ('asie', 'Asie - Extrême Orient', '', 'asie.png', 'asie_masque.png', '3', 1, 2);
|
|
|
537 |
INSERT INTO `carto_DESCRIPTION_CARTE` VALUES ('moyenorient', 'Moyen-Orient', '', 'moyenorient.png', 'moyenorient_masque.png', '7', 1, 2);
|
|
|
538 |
|
|
|
539 |
# --------------------------------------------------------
|
|
|
540 |
|
|
|
541 |
#
|
|
|
542 |
# Structure de la table `carto_PAYS`
|
|
|
543 |
#
|
|
|
544 |
|
|
|
545 |
DROP TABLE IF EXISTS `carto_PAYS`;
|
|
|
546 |
CREATE TABLE `carto_PAYS` (
|
|
|
547 |
`CP_ID_Pays` char(3) NOT NULL default '',
|
|
|
548 |
`CP_Langue_intitule` char(3) NOT NULL default '',
|
|
|
549 |
`CP_Intitule_pays` varchar(100) NOT NULL default '',
|
|
|
550 |
`CP_Intitule_capitale` varchar(100) NOT NULL default '',
|
|
|
551 |
`CP_Couleur_R` tinyint(3) unsigned NOT NULL default '0',
|
|
|
552 |
`CP_Couleur_V` tinyint(3) unsigned NOT NULL default '0',
|
|
|
553 |
`CP_Couleur_B` tinyint(3) unsigned NOT NULL default '0',
|
|
|
554 |
`CP_ID_Continent` tinyint(4) unsigned NOT NULL default '0',
|
|
|
555 |
PRIMARY KEY (`CP_ID_Pays`)
|
|
|
556 |
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
|
|
|
557 |
|
|
|
558 |
#
|
|
|
559 |
# Contenu de la table `carto_PAYS`
|
|
|
560 |
#
|
|
|
561 |
|
|
|
562 |
INSERT INTO `carto_PAYS` VALUES ('af', 'fr', 'Afghanistan', 'Kaboul', 60, 140, 60, 7);
|
|
|
563 |
INSERT INTO `carto_PAYS` VALUES ('za', 'fr', 'Afrique du Sud', 'Pretoria', 255, 25, 25, 1);
|
|
|
564 |
INSERT INTO `carto_PAYS` VALUES ('al', 'fr', 'Albanie', 'Tirana', 150, 150, 255, 4);
|
|
|
565 |
INSERT INTO `carto_PAYS` VALUES ('dz', 'fr', 'Algérie', 'Alger', 255, 25, 75, 1);
|
|
|
566 |
INSERT INTO `carto_PAYS` VALUES ('de', 'fr', 'Allemagne', 'Berlin', 255, 75, 75, 4);
|
|
|
567 |
INSERT INTO `carto_PAYS` VALUES ('an', 'fr', 'Andorre', 'Andorre la vielle', 51, 51, 51, 4);
|
|
|
568 |
INSERT INTO `carto_PAYS` VALUES ('ao', 'fr', 'Angola', 'Luanda', 255, 25, 125, 1);
|
|
|
569 |
INSERT INTO `carto_PAYS` VALUES ('ag', 'fr', 'Antigua et Barbuda', 'St Jean', 200, 100, 0, 2);
|
|
|
570 |
INSERT INTO `carto_PAYS` VALUES ('sa', 'fr', 'Arabie Saoudite', 'Riyad', 60, 100, 60, 7);
|
|
|
571 |
INSERT INTO `carto_PAYS` VALUES ('ar', 'fr', 'Argentine', 'Buenos Aires', 20, 220, 120, 6);
|
|
|
572 |
INSERT INTO `carto_PAYS` VALUES ('am', 'fr', 'Arménie', 'Erevan', 60, 180, 60, 7);
|
|
|
573 |
INSERT INTO `carto_PAYS` VALUES ('au', 'fr', 'Australie', 'Canberra', 255, 25, 25, 5);
|
|
|
574 |
INSERT INTO `carto_PAYS` VALUES ('at', 'fr', 'Autriche', 'Vienne', 179, 179, 179, 4);
|
|
|
575 |
INSERT INTO `carto_PAYS` VALUES ('az', 'fr', 'Azerbaïdjan', 'Bakou', 60, 240, 60, 7);
|
|
|
576 |
INSERT INTO `carto_PAYS` VALUES ('bs', 'fr', 'Bahamas', 'Nassau', 200, 100, 50, 2);
|
|
|
577 |
INSERT INTO `carto_PAYS` VALUES ('bh', 'fr', 'Bahreïn', 'Manama', 140, 0, 0, 7);
|
|
|
578 |
INSERT INTO `carto_PAYS` VALUES ('bd', 'fr', 'Bangladesh', 'Dhaka', 140, 40, 0, 3);
|
|
|
579 |
INSERT INTO `carto_PAYS` VALUES ('bb', 'fr', 'Barbade', 'Bridgetown', 200, 100, 75, 2);
|
|
|
580 |
INSERT INTO `carto_PAYS` VALUES ('be', 'fr', 'Belgique', 'Bruxelles', 204, 204, 204, 4);
|
|
|
581 |
INSERT INTO `carto_PAYS` VALUES ('bz', 'fr', 'Bélize', 'Belmopan', 200, 100, 100, 2);
|
|
|
582 |
INSERT INTO `carto_PAYS` VALUES ('bj', 'fr', 'Bénin', 'Porto-Novo', 255, 25, 175, 1);
|
|
|
583 |
INSERT INTO `carto_PAYS` VALUES ('bt', 'fr', 'Bhoutan', 'Timphou', 140, 80, 0, 3);
|
|
|
584 |
INSERT INTO `carto_PAYS` VALUES ('by', 'fr', 'Biélorussie', 'Minsk', 225, 255, 225, 4);
|
|
|
585 |
INSERT INTO `carto_PAYS` VALUES ('bo', 'fr', 'Bolivie', 'La Paz', 120, 220, 120, 6);
|
|
|
586 |
INSERT INTO `carto_PAYS` VALUES ('ba', 'fr', 'Bosnie-Herzégovine', 'Sarajevo', 255, 25, 25, 4);
|
|
|
587 |
INSERT INTO `carto_PAYS` VALUES ('bw', 'fr', 'Botswana', 'Gaborone', 255, 25, 225, 1);
|
|
|
588 |
INSERT INTO `carto_PAYS` VALUES ('br', 'fr', 'Brésil', 'Brasillia', 250, 220, 120, 6);
|
|
|
589 |
INSERT INTO `carto_PAYS` VALUES ('bn', 'fr', 'Brunei Darusalam', 'Bandar Seri Begawan', 140, 120, 0, 3);
|
|
|
590 |
INSERT INTO `carto_PAYS` VALUES ('bg', 'fr', 'Bulgarie', 'Sofia', 75, 75, 255, 4);
|
|
|
591 |
INSERT INTO `carto_PAYS` VALUES ('bf', 'fr', 'Burkina Faso', 'Ouagadougou', 255, 150, 25, 1);
|
|
|
592 |
INSERT INTO `carto_PAYS` VALUES ('bi', 'fr', 'Burundi', 'Bujumbura', 255, 150, 75, 1);
|
|
|
593 |
INSERT INTO `carto_PAYS` VALUES ('kh', 'fr', 'Cambodge', 'Phnom Penh', 140, 140, 0, 3);
|
|
|
594 |
INSERT INTO `carto_PAYS` VALUES ('cm', 'fr', 'Cameroun', 'Yaoundé', 255, 150, 125, 1);
|
|
|
595 |
INSERT INTO `carto_PAYS` VALUES ('ca', 'fr', 'Canada', 'Ottawa', 200, 100, 125, 2);
|
|
|
596 |
INSERT INTO `carto_PAYS` VALUES ('cv', 'fr', 'Cap Vert', 'Praia', 25, 100, 150, 1);
|
|
|
597 |
INSERT INTO `carto_PAYS` VALUES ('cl', 'fr', 'Chili', 'Santiago', 220, 20, 120, 6);
|
|
|
598 |
INSERT INTO `carto_PAYS` VALUES ('cn', 'fr', 'Chine', 'Pékin', 140, 180, 0, 3);
|
|
|
599 |
INSERT INTO `carto_PAYS` VALUES ('cy', 'fr', 'Chypre', 'Nicosie', 200, 200, 255, 4);
|
|
|
600 |
INSERT INTO `carto_PAYS` VALUES ('co', 'fr', 'Colombie', 'Bogota', 220, 120, 120, 6);
|
|
|
601 |
INSERT INTO `carto_PAYS` VALUES ('km', 'fr', 'Comores', 'Moroni', 255, 150, 175, 1);
|
|
|
602 |
INSERT INTO `carto_PAYS` VALUES ('cr', 'fr', 'Costa Rica', 'San José', 200, 100, 150, 2);
|
|
|
603 |
INSERT INTO `carto_PAYS` VALUES ('ci', 'fr', 'Côte d\'Ivoire', 'Yamoussoukro', 255, 150, 225, 1);
|
|
|
604 |
INSERT INTO `carto_PAYS` VALUES ('hr', 'fr', 'Croatie', 'Zaghreb', 255, 225, 225, 4);
|
|
|
605 |
INSERT INTO `carto_PAYS` VALUES ('cu', 'fr', 'Cuba', 'La Havane', 200, 100, 175, 2);
|
|
|
606 |
INSERT INTO `carto_PAYS` VALUES ('dk', 'fr', 'Danemark', 'Copenhague', 25, 255, 25, 4);
|
|
|
607 |
INSERT INTO `carto_PAYS` VALUES ('dj', 'fr', 'Djibouti', 'Djibouti', 255, 250, 25, 1);
|
|
|
608 |
INSERT INTO `carto_PAYS` VALUES ('dm', 'fr', 'Dominique', 'Roseau', 200, 100, 250, 2);
|
|
|
609 |
INSERT INTO `carto_PAYS` VALUES ('eg', 'fr', 'Egypte', 'Le Caire', 255, 250, 75, 1);
|
|
|
610 |
INSERT INTO `carto_PAYS` VALUES ('sv', 'fr', 'Salvador', 'San Salvador', 200, 200, 0, 2);
|
|
|
611 |
INSERT INTO `carto_PAYS` VALUES ('ae', 'fr', 'Emirats Arabes Unis', 'Abou Dabi', 140, 220, 0, 7);
|
|
|
612 |
INSERT INTO `carto_PAYS` VALUES ('ec', 'fr', 'Equateur', 'Quito', 220, 250, 120, 6);
|
|
|
613 |
INSERT INTO `carto_PAYS` VALUES ('er', 'fr', 'Erythrée', 'Asmara', 255, 250, 125, 1);
|
|
|
614 |
INSERT INTO `carto_PAYS` VALUES ('es', 'fr', 'Espagne', 'Madrid', 102, 102, 102, 4);
|
|
|
615 |
INSERT INTO `carto_PAYS` VALUES ('ee', 'fr', 'Estonie', 'Tallin', 125, 255, 125, 4);
|
|
|
616 |
INSERT INTO `carto_PAYS` VALUES ('us', 'fr', 'Etats-Unis', 'Washington', 200, 200, 100, 2);
|
|
|
617 |
INSERT INTO `carto_PAYS` VALUES ('et', 'fr', 'Ethiopie', 'Addis-Abeba', 255, 250, 175, 1);
|
|
|
618 |
INSERT INTO `carto_PAYS` VALUES ('fj', 'fr', 'Fidji', 'Suva', 255, 25, 75, 5);
|
|
|
619 |
INSERT INTO `carto_PAYS` VALUES ('fi', 'fr', 'Finlande', 'Helsinki', 100, 255, 100, 4);
|
|
|
620 |
INSERT INTO `carto_PAYS` VALUES ('fr', 'fr', 'France', 'Paris', 77, 77, 77, 4);
|
|
|
621 |
INSERT INTO `carto_PAYS` VALUES ('ga', 'fr', 'Gabon', 'Libreville', 25, 50, 255, 1);
|
|
|
622 |
INSERT INTO `carto_PAYS` VALUES ('gm', 'fr', 'Gambie', 'Banjul', 75, 50, 255, 1);
|
|
|
623 |
INSERT INTO `carto_PAYS` VALUES ('ge', 'fr', 'Géorgie', 'T\'billisi', 170, 15, 50, 7);
|
|
|
624 |
INSERT INTO `carto_PAYS` VALUES ('gh', 'fr', 'Ghana', 'Accra', 125, 50, 255, 1);
|
|
|
625 |
INSERT INTO `carto_PAYS` VALUES ('gr', 'fr', 'Grèce', 'Athènes', 175, 175, 255, 4);
|
|
|
626 |
INSERT INTO `carto_PAYS` VALUES ('gd', 'fr', 'Grenade', 'Saint-Georges', 200, 200, 125, 2);
|
|
|
627 |
INSERT INTO `carto_PAYS` VALUES ('gl', 'fr', 'Groenland', 'Nuuk', 200, 200, 250, 2);
|
|
|
628 |
INSERT INTO `carto_PAYS` VALUES ('gt', 'fr', 'Guatémala', 'Guatemala', 0, 100, 200, 2);
|
|
|
629 |
INSERT INTO `carto_PAYS` VALUES ('gw', 'fr', 'Guinée Bissau', 'Bissau', 175, 50, 255, 1);
|
|
|
630 |
INSERT INTO `carto_PAYS` VALUES ('gq', 'fr', 'Guinée équatoriale', 'Malabo', 225, 50, 255, 1);
|
|
|
631 |
INSERT INTO `carto_PAYS` VALUES ('gy', 'fr', 'Guyana', 'Georgetown', 20, 0, 160, 6);
|
|
|
632 |
INSERT INTO `carto_PAYS` VALUES ('ht', 'fr', 'Haïti', 'Port au Prince', 50, 100, 200, 2);
|
|
|
633 |
INSERT INTO `carto_PAYS` VALUES ('hn', 'fr', 'Honduras', 'Tegucigalpa', 75, 100, 200, 2);
|
|
|
634 |
INSERT INTO `carto_PAYS` VALUES ('hu', 'fr', 'Hongrie', 'Budapest', 255, 175, 175, 4);
|
|
|
635 |
INSERT INTO `carto_PAYS` VALUES ('in', 'fr', 'Inde', 'New Delhi', 255, 0, 0, 3);
|
|
|
636 |
INSERT INTO `carto_PAYS` VALUES ('id', 'fr', 'Indonésie', 'Jakarta', 255, 40, 0, 3);
|
|
|
637 |
INSERT INTO `carto_PAYS` VALUES ('iq', 'fr', 'Irak', 'Bagdad', 255, 80, 0, 7);
|
|
|
638 |
INSERT INTO `carto_PAYS` VALUES ('ir', 'fr', 'Iran', 'Téhéran', 255, 120, 0, 7);
|
|
|
639 |
INSERT INTO `carto_PAYS` VALUES ('ie', 'fr', 'Irlande', 'Dublin', 0, 255, 0, 4);
|
|
|
640 |
INSERT INTO `carto_PAYS` VALUES ('is', 'fr', 'Islande', 'Reykjavik', 255, 50, 50, 4);
|
|
|
641 |
INSERT INTO `carto_PAYS` VALUES ('il', 'fr', 'Israël', 'Tel-Aviv', 255, 160, 0, 7);
|
|
|
642 |
INSERT INTO `carto_PAYS` VALUES ('it', 'fr', 'Italie', 'Rome', 153, 153, 153, 4);
|
|
|
643 |
INSERT INTO `carto_PAYS` VALUES ('jm', 'fr', 'Jamaïque', 'Kingston', 100, 100, 200, 2);
|
|
|
644 |
INSERT INTO `carto_PAYS` VALUES ('jp', 'fr', 'Japon', 'Tokyo', 255, 200, 0, 3);
|
|
|
645 |
INSERT INTO `carto_PAYS` VALUES ('jo', 'fr', 'Jordanie', 'Amman', 255, 240, 0, 7);
|
|
|
646 |
INSERT INTO `carto_PAYS` VALUES ('kz', 'fr', 'Kazakhstan', 'Astana', 0, 100, 255, 3);
|
|
|
647 |
INSERT INTO `carto_PAYS` VALUES ('ke', 'fr', 'Kenya', 'Nairobo', 25, 150, 255, 1);
|
|
|
648 |
INSERT INTO `carto_PAYS` VALUES ('kg', 'fr', 'Kirghizstan', 'Bichkek', 40, 100, 255, 7);
|
|
|
649 |
INSERT INTO `carto_PAYS` VALUES ('ki', 'fr', 'Kiribati', 'Tarawa', 255, 25, 125, 5);
|
|
|
650 |
INSERT INTO `carto_PAYS` VALUES ('kw', 'fr', 'Koweït', 'Keweït', 80, 100, 255, 7);
|
|
|
651 |
INSERT INTO `carto_PAYS` VALUES ('ls', 'fr', 'Lesotho', 'Maseru', 75, 150, 255, 1);
|
|
|
652 |
INSERT INTO `carto_PAYS` VALUES ('lv', 'fr', 'Lettonie', 'Rïga', 150, 255, 150, 4);
|
|
|
653 |
INSERT INTO `carto_PAYS` VALUES ('lb', 'fr', 'Liban', 'Beyrouth', 120, 100, 255, 7);
|
|
|
654 |
INSERT INTO `carto_PAYS` VALUES ('lr', 'fr', 'Libéria', 'Monrovia', 125, 150, 255, 1);
|
|
|
655 |
INSERT INTO `carto_PAYS` VALUES ('ly', 'fr', 'Libye', 'Tripoli', 175, 150, 255, 1);
|
|
|
656 |
INSERT INTO `carto_PAYS` VALUES ('li', 'fr', 'Liechtenstein', 'Vaduz', 0, 255, 255, 4);
|
|
|
657 |
INSERT INTO `carto_PAYS` VALUES ('lt', 'fr', 'Lituanie', 'Vinius', 175, 255, 175, 4);
|
|
|
658 |
INSERT INTO `carto_PAYS` VALUES ('lu', 'fr', 'Luxembourg', 'Luxembourg', 229, 229, 229, 4);
|
|
|
659 |
INSERT INTO `carto_PAYS` VALUES ('mk', 'fr', 'Macédoine', 'Skopje', 125, 125, 255, 4);
|
|
|
660 |
INSERT INTO `carto_PAYS` VALUES ('mg', 'fr', 'Madagascar', 'Antananarivo', 225, 150, 255, 1);
|
|
|
661 |
INSERT INTO `carto_PAYS` VALUES ('my', 'fr', 'Malaisie', 'Kuala Lumpur', 140, 100, 255, 3);
|
|
|
662 |
INSERT INTO `carto_PAYS` VALUES ('mw', 'fr', 'Malawi', 'Lilongwe', 25, 250, 255, 1);
|
|
|
663 |
INSERT INTO `carto_PAYS` VALUES ('mv', 'fr', 'Maldives', 'Malé', 160, 100, 255, 3);
|
|
|
664 |
INSERT INTO `carto_PAYS` VALUES ('ml', 'fr', 'Mali', 'Bamoko', 75, 250, 255, 1);
|
|
|
665 |
INSERT INTO `carto_PAYS` VALUES ('mt', 'fr', 'Malte', 'La Valette', 225, 225, 255, 4);
|
|
|
666 |
INSERT INTO `carto_PAYS` VALUES ('ma', 'fr', 'Maroc', 'Rabat', 125, 250, 255, 1);
|
|
|
667 |
INSERT INTO `carto_PAYS` VALUES ('mh', 'fr', 'Marshall', 'Majuro', 255, 25, 175, 5);
|
|
|
668 |
INSERT INTO `carto_PAYS` VALUES ('mu', 'fr', 'Maurice', 'Port-Louis', 175, 250, 255, 1);
|
|
|
669 |
INSERT INTO `carto_PAYS` VALUES ('mr', 'fr', 'Mauritanie', 'Nouakchott', 25, 255, 50, 1);
|
|
|
670 |
INSERT INTO `carto_PAYS` VALUES ('mx', 'fr', 'Mexique', 'Mexico', 125, 100, 200, 2);
|
|
|
671 |
INSERT INTO `carto_PAYS` VALUES ('fm', 'fr', 'Micronésie', 'Palikir', 255, 25, 225, 5);
|
|
|
672 |
INSERT INTO `carto_PAYS` VALUES ('md', 'fr', 'Moldavie', 'Chisinau', 25, 25, 255, 4);
|
|
|
673 |
INSERT INTO `carto_PAYS` VALUES ('mc', 'fr', 'Monaco', 'Monaco', 50, 255, 255, 4);
|
|
|
674 |
INSERT INTO `carto_PAYS` VALUES ('mn', 'fr', 'Mongolie', 'Oulan-Bator', 180, 100, 255, 3);
|
|
|
675 |
INSERT INTO `carto_PAYS` VALUES ('mz', 'fr', 'Mozambique', 'Maputo', 75, 255, 50, 1);
|
|
|
676 |
INSERT INTO `carto_PAYS` VALUES ('na', 'fr', 'Namibie', 'Windhoek', 125, 255, 50, 1);
|
|
|
677 |
INSERT INTO `carto_PAYS` VALUES ('nr', 'fr', 'Nauru', 'Yaren District', 255, 75, 25, 5);
|
|
|
678 |
INSERT INTO `carto_PAYS` VALUES ('np', 'fr', 'Népal', 'Kathmandou', 200, 100, 255, 3);
|
|
|
679 |
INSERT INTO `carto_PAYS` VALUES ('ni', 'fr', 'Nicaragua', 'Managua', 150, 100, 200, 2);
|
|
|
680 |
INSERT INTO `carto_PAYS` VALUES ('ne', 'fr', 'Niger', 'Niamey', 175, 255, 50, 1);
|
|
|
681 |
INSERT INTO `carto_PAYS` VALUES ('ng', 'fr', 'Nigéria', 'Abuja', 225, 255, 50, 1);
|
|
|
682 |
INSERT INTO `carto_PAYS` VALUES ('no', 'fr', 'Norvège', 'Oslo', 50, 255, 50, 4);
|
|
|
683 |
INSERT INTO `carto_PAYS` VALUES ('nz', 'fr', 'Nouvelle-Zélande', 'Wellington', 255, 75, 75, 5);
|
|
|
684 |
INSERT INTO `carto_PAYS` VALUES ('om', 'fr', 'Oman', 'Mascate', 220, 100, 255, 7);
|
|
|
685 |
INSERT INTO `carto_PAYS` VALUES ('ug', 'fr', 'Ouganda', 'Kampala', 25, 255, 150, 1);
|
|
|
686 |
INSERT INTO `carto_PAYS` VALUES ('uz', 'fr', 'Ouzbekistan', 'Tachkent', 240, 100, 255, 7);
|
|
|
687 |
INSERT INTO `carto_PAYS` VALUES ('pk', 'fr', 'Pakistan', 'Islamabad', 0, 255, 0, 7);
|
|
|
688 |
INSERT INTO `carto_PAYS` VALUES ('pw', 'fr', 'Palau', 'Koror', 255, 75, 125, 5);
|
|
|
689 |
INSERT INTO `carto_PAYS` VALUES ('ps', 'fr', 'Palestine', 'Jérusalem', 40, 255, 0, 7);
|
|
|
690 |
INSERT INTO `carto_PAYS` VALUES ('pa', 'fr', 'Panama', 'Panama', 175, 100, 200, 2);
|
|
|
691 |
INSERT INTO `carto_PAYS` VALUES ('pg', 'fr', 'Papouasie - Nouvelle Guinée', 'Port Moresby', 255, 75, 175, 5);
|
|
|
692 |
INSERT INTO `carto_PAYS` VALUES ('py', 'fr', 'Paraguay', 'Assomption', 20, 120, 160, 6);
|
|
|
693 |
INSERT INTO `carto_PAYS` VALUES ('nl', 'fr', 'Pays-Bas', 'Amsterdam', 245, 245, 245, 4);
|
|
|
694 |
INSERT INTO `carto_PAYS` VALUES ('pe', 'fr', 'Pérou', 'Lima', 20, 160, 160, 6);
|
|
|
695 |
INSERT INTO `carto_PAYS` VALUES ('ph', 'fr', 'Philippines', 'Manille', 80, 255, 0, 3);
|
|
|
696 |
INSERT INTO `carto_PAYS` VALUES ('pl', 'fr', 'Pologne', 'Varsovie', 255, 100, 100, 4);
|
|
|
697 |
INSERT INTO `carto_PAYS` VALUES ('pt', 'fr', 'Portugal', 'Lisbonne', 26, 26, 26, 4);
|
|
|
698 |
INSERT INTO `carto_PAYS` VALUES ('qa', 'fr', 'Qatar', 'Doha', 120, 255, 0, 7);
|
|
|
699 |
INSERT INTO `carto_PAYS` VALUES ('cf', 'fr', 'République Centrafricaine', 'Bangui', 75, 255, 150, 1);
|
|
|
700 |
INSERT INTO `carto_PAYS` VALUES ('kr', 'fr', 'République de Corée', 'Séoul', 140, 255, 0, 3);
|
|
|
701 |
INSERT INTO `carto_PAYS` VALUES ('cd', 'fr', 'République Démocratique du Congo', 'Kinshasa', 125, 255, 150, 1);
|
|
|
702 |
INSERT INTO `carto_PAYS` VALUES ('kp', 'fr', 'République Populaire Démocratique de Corée', 'Pyongyang', 180, 255, 0, 3);
|
|
|
703 |
INSERT INTO `carto_PAYS` VALUES ('cz', 'fr', 'République Tchèque', 'Prague', 255, 125, 125, 4);
|
|
|
704 |
INSERT INTO `carto_PAYS` VALUES ('ro', 'fr', 'Roumanie', 'Bucarest', 50, 50, 255, 4);
|
|
|
705 |
INSERT INTO `carto_PAYS` VALUES ('uk', 'fr', 'Royaume-Uni', 'Londres', 255, 0, 0, 4);
|
|
|
706 |
INSERT INTO `carto_PAYS` VALUES ('ru', 'fr', 'Russie', 'Moscou', 200, 255, 200, 4);
|
|
|
707 |
INSERT INTO `carto_PAYS` VALUES ('rw', 'fr', 'Rwanda', 'Kigali', 175, 255, 150, 1);
|
|
|
708 |
INSERT INTO `carto_PAYS` VALUES ('sm', 'fr', 'San Marin', 'Saint marin', 25, 255, 255, 4);
|
|
|
709 |
INSERT INTO `carto_PAYS` VALUES ('vc', 'fr', 'Saint Vincent et les Grenadines', 'Kingston', 200, 100, 200, 2);
|
|
|
710 |
INSERT INTO `carto_PAYS` VALUES ('lc', 'fr', 'Sainte Lucie', 'Castries', 0, 100, 100, 2);
|
|
|
711 |
INSERT INTO `carto_PAYS` VALUES ('sb', 'fr', 'Salomon', 'Honiara', 255, 75, 225, 5);
|
|
|
712 |
INSERT INTO `carto_PAYS` VALUES ('ws', 'fr', 'Samoa', 'Apia', 255, 125, 25, 5);
|
|
|
713 |
INSERT INTO `carto_PAYS` VALUES ('st', 'fr', 'Sao Tomé et Principe', 'Sao Tomé', 25, 255, 250, 1);
|
|
|
714 |
INSERT INTO `carto_PAYS` VALUES ('sn', 'fr', 'Sénégal', 'Dakar', 75, 255, 250, 1);
|
|
|
715 |
INSERT INTO `carto_PAYS` VALUES ('sc', 'fr', 'Seychelles', 'Victoria', 100, 255, 250, 1);
|
|
|
716 |
INSERT INTO `carto_PAYS` VALUES ('sl', 'fr', 'Sierra Leone', 'Freetown', 125, 255, 250, 1);
|
|
|
717 |
INSERT INTO `carto_PAYS` VALUES ('sg', 'fr', 'Singapour', 'Singapour', 200, 255, 0, 3);
|
|
|
718 |
INSERT INTO `carto_PAYS` VALUES ('sk', 'fr', 'Slovaquie', 'Bratislava', 255, 150, 150, 4);
|
|
|
719 |
INSERT INTO `carto_PAYS` VALUES ('si', 'fr', 'Slovénie', 'Ljubljana', 255, 200, 200, 4);
|
|
|
720 |
INSERT INTO `carto_PAYS` VALUES ('so', 'fr', 'Somalie', 'Mogadiscio', 175, 255, 250, 1);
|
|
|
721 |
INSERT INTO `carto_PAYS` VALUES ('sd', 'fr', 'Soudan', 'Khartoum', 151, 151, 25, 1);
|
|
|
722 |
INSERT INTO `carto_PAYS` VALUES ('lk', 'fr', 'Sri Lanka', 'Sri Jayawardhanapura', 220, 255, 0, 3);
|
|
|
723 |
INSERT INTO `carto_PAYS` VALUES ('se', 'fr', 'Suède', 'Stokholm', 75, 255, 75, 4);
|
|
|
724 |
INSERT INTO `carto_PAYS` VALUES ('ch', 'fr', 'Suisse', 'Berne', 128, 128, 128, 4);
|
|
|
725 |
INSERT INTO `carto_PAYS` VALUES ('sr', 'fr', 'Surinam', 'Paramaribo', 20, 160, 250, 6);
|
|
|
726 |
INSERT INTO `carto_PAYS` VALUES ('sz', 'fr', 'Swaziland', 'Mbabe', 151, 151, 75, 1);
|
|
|
727 |
INSERT INTO `carto_PAYS` VALUES ('sy', 'fr', 'Syrie', 'Damas', 240, 255, 0, 7);
|
|
|
728 |
INSERT INTO `carto_PAYS` VALUES ('tj', 'fr', 'Tadjikistan', 'Douchanbé', 0, 100, 50, 7);
|
|
|
729 |
INSERT INTO `carto_PAYS` VALUES ('tz', 'fr', 'Tanzanie', 'Dar es Salaam', 151, 151, 125, 1);
|
|
|
730 |
INSERT INTO `carto_PAYS` VALUES ('td', 'fr', 'Tchad', 'Ndjamena', 151, 151, 175, 1);
|
|
|
731 |
INSERT INTO `carto_PAYS` VALUES ('th', 'fr', 'Thaïlande', 'Bangkok', 50, 100, 50, 3);
|
|
|
732 |
INSERT INTO `carto_PAYS` VALUES ('tg', 'fr', 'Togo', 'Lomé', 151, 151, 225, 1);
|
|
|
733 |
INSERT INTO `carto_PAYS` VALUES ('to', 'fr', 'Tonga', 'Nuku\'alofa', 25, 125, 225, 5);
|
|
|
734 |
INSERT INTO `carto_PAYS` VALUES ('tt', 'fr', 'Trinité et Tobago', 'Port d\'Espagne', 75, 100, 100, 2);
|
|
|
735 |
INSERT INTO `carto_PAYS` VALUES ('tn', 'fr', 'Tunisie', 'Tunis', 25, 151, 151, 1);
|
|
|
736 |
INSERT INTO `carto_PAYS` VALUES ('tm', 'fr', 'Turkmenistan', 'Asgabad', 100, 100, 50, 7);
|
|
|
737 |
INSERT INTO `carto_PAYS` VALUES ('tr', 'fr', 'Turquie', 'Ankara', 150, 100, 50, 7);
|
|
|
738 |
INSERT INTO `carto_PAYS` VALUES ('tv', 'fr', 'Tuvalu', 'Funafuti', 25, 175, 25, 5);
|
|
|
739 |
INSERT INTO `carto_PAYS` VALUES ('ua', 'fr', 'Ukraine', 'Kiev', 0, 0, 255, 4);
|
|
|
740 |
INSERT INTO `carto_PAYS` VALUES ('uy', 'fr', 'Uruguay', 'Montevideo', 220, 220, 60, 6);
|
|
|
741 |
INSERT INTO `carto_PAYS` VALUES ('vu', 'fr', 'Vanuatu', 'Port-Vila', 255, 125, 175, 5);
|
|
|
742 |
INSERT INTO `carto_PAYS` VALUES ('ve', 'fr', 'Vénézuéla', 'Caracas', 220, 60, 60, 6);
|
|
|
743 |
INSERT INTO `carto_PAYS` VALUES ('vn', 'fr', 'Vietnam', 'Hanoï', 200, 100, 50, 3);
|
|
|
744 |
INSERT INTO `carto_PAYS` VALUES ('ye', 'fr', 'Yémen', 'Sanaa', 250, 100, 50, 7);
|
|
|
745 |
INSERT INTO `carto_PAYS` VALUES ('yu', 'fr', 'Yougoslavie', 'Belgrade', 100, 100, 255, 4);
|
|
|
746 |
INSERT INTO `carto_PAYS` VALUES ('zm', 'fr', 'Zambie', 'Lusaka', 75, 151, 151, 1);
|
|
|
747 |
INSERT INTO `carto_PAYS` VALUES ('zw', 'fr', 'Zimbabwe', 'Harare', 225, 151, 151, 1);
|
|
|
748 |
INSERT INTO `carto_PAYS` VALUES ('cg', 'fr', 'Congo', 'Brazzaville', 175, 151, 151, 1);
|
|
|
749 |
INSERT INTO `carto_PAYS` VALUES ('gn', 'fr', 'Guinée', 'Conakry', 125, 151, 151, 1);
|
|
|
750 |
INSERT INTO `carto_PAYS` VALUES ('la', 'fr', 'Laos', 'Vientiane', 160, 200, 250, 3);
|
|
|
751 |
INSERT INTO `carto_PAYS` VALUES ('mm', 'fr', 'Birmanie', 'Rangoon', 210, 200, 250, 3);
|
|
|
752 |
INSERT INTO `carto_PAYS` VALUES ('rua', 'fr', 'Russie (Asie)', 'Moscou', 0, 125, 125, 3);
|
|
|
753 |
INSERT INTO `carto_PAYS` VALUES ('tw', 'fr', 'Taïwan', 'Taïpei', 0, 200, 250, 3);
|
|
|
754 |
INSERT INTO `carto_PAYS` VALUES ('0', '', ' ', ' ', 255, 255, 255, 0);
|
|
|
755 |
|
|
|
756 |
# --------------------------------------------------------
|
|
|
757 |
|
|
|
758 |
#
|
|
|
759 |
# Structure de la table `carto_PROJET`
|
|
|
760 |
#
|
|
|
761 |
|
|
|
762 |
DROP TABLE IF EXISTS `carto_PROJET`;
|
|
|
763 |
CREATE TABLE `carto_PROJET` (
|
|
|
764 |
`CP_ID_Projet` int(10) unsigned NOT NULL default '0',
|
|
|
765 |
`CP_Nom_projet` varchar(100) NOT NULL default '',
|
|
|
766 |
`CP_Description_projet` text,
|
|
|
767 |
PRIMARY KEY (`CP_ID_Projet`)
|
|
|
768 |
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
|
|
|
769 |
|
|
|
770 |
#
|
|
|
771 |
# Contenu de la table `carto_PROJET`
|
|
|
772 |
#
|
|
|
773 |
|
|
|
774 |
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\'.');
|
|
|
775 |
|
|
|
776 |
# --------------------------------------------------------
|
|
|
777 |
|
|
|
778 |
#
|
|
|
779 |
# Structure de la table `carto_REGION`
|
|
|
780 |
#
|
|
|
781 |
|
|
|
782 |
DROP TABLE IF EXISTS `carto_REGION`;
|
|
|
783 |
CREATE TABLE `carto_REGION` (
|
|
|
784 |
`CR_ID_Region` int(11) NOT NULL default '0',
|
|
|
785 |
`CR_Intitule_region` varchar(100) NOT NULL default '',
|
|
|
786 |
`CR_Couleur_R` tinyint(3) unsigned NOT NULL default '0',
|
|
|
787 |
`CR_Couleur_V` tinyint(3) unsigned NOT NULL default '0',
|
|
|
788 |
`CR_Couleur_B` tinyint(3) unsigned NOT NULL default '0',
|
|
|
789 |
`CR_ID_Pays` char(3) NOT NULL default '',
|
|
|
790 |
PRIMARY KEY (`CR_ID_Region`)
|
|
|
791 |
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
|
|
|
792 |
|
|
|
793 |
#
|
|
|
794 |
# Contenu de la table `carto_REGION`
|
|
|
795 |
#
|
|
|
796 |
|
|
|
797 |
INSERT INTO `carto_REGION` VALUES (1, 'Alsace', 51, 153, 153, 'fr');
|
|
|
798 |
INSERT INTO `carto_REGION` VALUES (2, 'Aquitaine', 51, 51, 204, 'fr');
|
|
|
799 |
INSERT INTO `carto_REGION` VALUES (3, 'Auvergne', 51, 51, 153, 'fr');
|
|
|
800 |
INSERT INTO `carto_REGION` VALUES (4, 'Basse-Normandie', 102, 102, 255, 'fr');
|
|
|
801 |
INSERT INTO `carto_REGION` VALUES (5, 'Bourgogne', 0, 204, 204, 'fr');
|
|
|
802 |
INSERT INTO `carto_REGION` VALUES (6, 'Bretagne', 102, 102, 204, 'fr');
|
|
|
803 |
INSERT INTO `carto_REGION` VALUES (7, 'Centre', 51, 204, 102, 'fr');
|
|
|
804 |
INSERT INTO `carto_REGION` VALUES (8, 'Champagne-Ardenne', 153, 255, 255, 'fr');
|
|
|
805 |
INSERT INTO `carto_REGION` VALUES (9, 'Corse', 0, 0, 102, 'fr');
|
|
|
806 |
INSERT INTO `carto_REGION` VALUES (10, 'Franche-Comté', 0, 102, 102, 'fr');
|
|
|
807 |
INSERT INTO `carto_REGION` VALUES (11, 'Haute-Normandie', 153, 153, 255, 'fr');
|
|
|
808 |
INSERT INTO `carto_REGION` VALUES (12, 'Ile-de-France', 0, 102, 51, 'fr');
|
|
|
809 |
INSERT INTO `carto_REGION` VALUES (13, 'Languedoc-Roussillon', 0, 0, 204, 'fr');
|
|
|
810 |
INSERT INTO `carto_REGION` VALUES (14, 'Limousin', 51, 51, 102, 'fr');
|
|
|
811 |
INSERT INTO `carto_REGION` VALUES (15, 'Lorraine', 102, 204, 204, 'fr');
|
|
|
812 |
INSERT INTO `carto_REGION` VALUES (16, 'Midi-Pyrénnées', 51, 51, 255, 'fr');
|
|
|
813 |
INSERT INTO `carto_REGION` VALUES (17, 'Nord-Pas-de-Calais', 153, 204, 204, 'fr');
|
|
|
814 |
INSERT INTO `carto_REGION` VALUES (18, 'Pays-de-la-Loire', 102, 102, 153, 'fr');
|
|
|
815 |
INSERT INTO `carto_REGION` VALUES (19, 'Picardie', 153, 153, 204, 'fr');
|
|
|
816 |
INSERT INTO `carto_REGION` VALUES (20, 'Poitou-Charentes', 102, 102, 102, 'fr');
|
|
|
817 |
INSERT INTO `carto_REGION` VALUES (21, 'Provence-Alpes-Côte-d\'Azur', 0, 0, 153, 'fr');
|
|
|
818 |
INSERT INTO `carto_REGION` VALUES (22, 'Rhône-Alpes', 0, 0, 255, 'fr');
|
|
|
819 |
INSERT INTO `carto_REGION` VALUES (900, ' ', 255, 255, 255, '');
|
|
|
820 |
|
|
|
821 |
# --------------------------------------------------------
|
|
|
822 |
|
|
|
823 |
#
|
|
|
824 |
# Structure de la table `carto_TYPE_ZONE`
|
|
|
825 |
#
|
|
|
826 |
|
|
|
827 |
DROP TABLE IF EXISTS `carto_TYPE_ZONE`;
|
|
|
828 |
CREATE TABLE `carto_TYPE_ZONE` (
|
|
|
829 |
`CTZ_ID_Type_zone` int(11) NOT NULL default '0',
|
|
|
830 |
`CTZ_Intitule_type_zone` varchar(100) NOT NULL default '',
|
|
|
831 |
`CTZ_Nom_table` varchar(100) NOT NULL default '',
|
|
|
832 |
PRIMARY KEY (`CTZ_ID_Type_zone`)
|
|
|
833 |
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
|
|
|
834 |
|
|
|
835 |
#
|
|
|
836 |
# Contenu de la table `carto_TYPE_ZONE`
|
|
|
837 |
#
|
|
|
838 |
|
|
|
839 |
INSERT INTO `carto_TYPE_ZONE` VALUES (1, 'Continent', 'carto_COULEUR_CONTINENT');
|
|
|
840 |
INSERT INTO `carto_TYPE_ZONE` VALUES (2, 'Pays', 'carto_COULEUR_PAYS');
|
|
|
841 |
INSERT INTO `carto_TYPE_ZONE` VALUES (3, 'Région', 'carto_COULEUR_REGION');
|
|
|
842 |
INSERT INTO `carto_TYPE_ZONE` VALUES (4, 'Département', 'carto_COULEUR_DEPARTEMENT');
|
|
|
843 |
INSERT INTO `carto_TYPE_ZONE` VALUES (0, 'Monde', '');
|
|
|
844 |
|
|
|
845 |
# --------------------------------------------------------
|
|
|
846 |
|
|
|
847 |
#
|
|
|
848 |
# Structure de la table `carto_communes`
|
|
|
849 |
#
|
|
|
850 |
|
|
|
851 |
DROP TABLE IF EXISTS `carto_communes`;
|
|
|
852 |
CREATE TABLE `carto_communes` (
|
|
|
853 |
`cc_code_insee` int(10) unsigned NOT NULL default '0',
|
|
|
854 |
`cc_code_couleur_rouge` tinyint(3) unsigned NOT NULL default '0',
|
|
|
855 |
`cc_code_couleur_vert` tinyint(3) unsigned NOT NULL default '0',
|
|
|
856 |
`cc_code_couleur_bleu` tinyint(3) unsigned NOT NULL default '0',
|
|
|
857 |
PRIMARY KEY (`cc_code_insee`)
|
|
|
858 |
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
|
|
|
859 |
|
|
|
860 |
#
|
|
|
861 |
# Contenu de la table `carto_communes`
|
|
|
862 |
#
|
|
|
863 |
|
|
|
864 |
|
|
|
865 |
# --------------------------------------------------------
|
|
|
866 |
|
|
|
867 |
#
|
|
|
868 |
# Structure de la table `carto_config`
|
|
|
869 |
#
|
|
|
870 |
|
|
|
871 |
DROP TABLE IF EXISTS `carto_config`;
|
|
|
872 |
CREATE TABLE `carto_config` (
|
|
|
873 |
`cc_menu_id` int(11) NOT NULL default '0',
|
|
|
874 |
`cc_table1` varchar(255) NOT NULL default '',
|
|
|
875 |
`cc_table2` varchar(255) NOT NULL default '',
|
|
|
876 |
`cc_pays` char(3) NOT NULL default '',
|
|
|
877 |
`cc_cp` varchar(7) NOT NULL default '',
|
|
|
878 |
`cc_sql` varchar(255) NOT NULL default '',
|
|
|
879 |
PRIMARY KEY (`cc_menu_id`)
|
|
|
880 |
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
|
|
|
881 |
|
|
|
882 |
#
|
|
|
883 |
# Contenu de la table `carto_config`
|
|
|
884 |
#
|
|
|
885 |
|