Subversion Repositories Applications.papyrus

Rev

Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
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