CREATE TABLE carte_2 ( x INT( 3 ) NULL , y INT( 3 ) NULL , usines INT( 10 ) NULL , habitants INT( 10 ) NULL , armee INT( 10 ) NULL , argent INT( 10 ) NULL , couleur VARCHAR( 10 ) NULL , nom VARCHAR( 20 ) NULL , id_user INT( 10 ) NULL ) ENGINE = MYISAM ;INSERT INTO compteur (titre, contenu) VALUES ('carte_2', 0);UPDATE compteur SET contenu = '2' WHERE titre = 'nombre_carte' AND contenu = 1 AND contenu2 = '' LIMIT 1 ; INSERT INTO amadeus.carte_2 (x, y, usines, habitants, armee, argent, couleur, nom, id_user) VALUES ('0' , '0', '0', '0', '0', '0', "grey","Ville neutre" , 0);INSERT INTO amadeus.carte_2 (x, y, usines, habitants, armee, argent, couleur, nom, id_user) VALUES ('0' , '1', '0', '0', '0', '0', "grey","Ville neutre" , 0);INSERT INTO amadeus.carte_2 (x, y, usines, habitants, armee, argent, couleur, nom, id_user) VALUES ('0' , '2', '0', '0', '0', '0', "grey","Ville neutre" , 0);INSERT INTO amadeus.carte_2 (x, y, usines, habitants, armee, argent, couleur, nom, id_user) VALUES ('0' , '3', '0', '0', '0', '0', "grey","Ville neutre" , 0);INSERT INTO amadeus.carte_2 (x, y, usines, habitants, armee, argent, couleur, nom, id_user) VALUES ('0' , '4', '0', '0', '0', '0', "grey","Ville neutre" , 0);INSERT INTO amadeus.carte_2 (x, y, usines, habitants, armee, argent, couleur, nom, id_user) VALUES ('0' , '5', '0', '0', '0', '0', "grey","Ville neutre" , 0);INSERT INTO amadeus.carte_2 (x, y, usines, habitants, armee, argent, couleur, nom, id_user) VALUES ('0' , '6', '0', '0', '0', '0', "grey","Ville neutre" , 0);INSERT INTO amadeus.carte_2 (x, y, usines, habitants, armee, argent, couleur, nom, id_user) VALUES ('0' , '7', '0', '0', '0', '0', "grey","Ville neutre" , 0);INSERT INTO amadeus.carte_2 (x, y, usines, habitants, armee, argent, couleur, nom, id_user) VALUES ('1' , '0', '0', '0', '0', '0', "grey","Ville neutre" , 0);INSERT INTO amadeus.carte_2 (x, y, usines, habitants, armee, argent, couleur, nom, id_user) VALUES ('1' , '1', '0', '0', '0', '0', "grey","Ville neutre" , 0);INSERT INTO amadeus.carte_2 (x, y, usines, habitants, armee, argent, couleur, nom, id_user) VALUES ('1' , '2', '0', '0', '0', '0', "grey","Ville neutre" , 0);INSERT INTO amadeus.carte_2 (x, y, usines, habitants, armee, argent, couleur, nom, id_user) VALUES ('1' , '3', '0', '0', '0', '0', "grey","Ville neutre" , 0);INSERT INTO amadeus.carte_2 (x, y, usines, habitants, armee, argent, couleur, nom, id_user) VALUES ('1' , '4', '0', '0', '0', '0', "grey","Ville neutre" , 0);INSERT INTO amadeus.carte_2 (x, y, usines, habitants, armee, argent, couleur, nom, id_user) VALUES ('1' , '5', '0', '0', '0', '0', "grey","Ville neutre" , 0);INSERT INTO amadeus.carte_2 (x, y, usines, habitants, armee, argent, couleur, nom, id_user) VALUES ('1' , '6', '0', '0', '0', '0', "grey","Ville neutre" , 0);INSERT INTO amadeus.carte_2 (x, y, usines, habitants, armee, argent, couleur, nom, id_user) VALUES ('1' , '7', '0', '0', '0', '0', "grey","Ville neutre" , 0);INSERT INTO amadeus.carte_2 (x, y, usines, habitants, armee, argent, couleur, nom, id_user) VALUES ('2' , '0', '0', '0', '0', '0', "grey","Ville neutre" , 0);INSERT INTO amadeus.carte_2 (x, y, usines, habitants, armee, argent, couleur, nom, id_user) VALUES ('2' , '1', '0', '0', '0', '0', "grey","Ville neutre" , 0);INSERT INTO amadeus.carte_2 (x, y, usines, habitants, armee, argent, couleur, nom, id_user) VALUES ('2' , '2', '0', '0', '0', '0', "grey","Ville neutre" , 0);INSERT INTO amadeus.carte_2 (x, y, usines, habitants, armee, argent, couleur, nom, id_user) VALUES ('2' , '3', '0', '0', '0', '0', "grey","Ville neutre" , 0);INSERT INTO amadeus.carte_2 (x, y, usines, habitants, armee, argent, couleur, nom, id_user) VALUES ('2' , '4', '0', '0', '0', '0', "grey","Ville neutre" , 0);INSERT INTO amadeus.carte_2 (x, y, usines, habitants, armee, argent, couleur, nom, id_user) VALUES ('2' , '5', '0', '0', '0', '0', "grey","Ville neutre" , 0);INSERT INTO amadeus.carte_2 (x, y, usines, habitants, armee, argent, couleur, nom, id_user) VALUES ('2' , '6', '0', '0', '0', '0', "grey","Ville neutre" , 0);INSERT INTO amadeus.carte_2 (x, y, usines, habitants, armee, argent, couleur, nom, id_user) VALUES ('2' , '7', '0', '0', '0', '0', "grey","Ville neutre" , 0);INSERT INTO amadeus.carte_2 (x, y, usines, habitants, armee, argent, couleur, nom, id_user) VALUES ('3' , '0', '0', '0', '0', '0', "grey","Ville neutre" , 0);INSERT INTO amadeus.carte_2 (x, y, usines, habitants, armee, argent, couleur, nom, id_user) VALUES ('3' , '1', '0', '0', '0', '0', "grey","Ville neutre" , 0);INSERT INTO amadeus.carte_2 (x, y, usines, habitants, armee, argent, couleur, nom, id_user) VALUES ('3' , '2', '0', '0', '0', '0', "grey","Ville neutre" , 0);INSERT INTO amadeus.carte_2 (x, y, usines, habitants, armee, argent, couleur, nom, id_user) VALUES ('3' , '3', '0', '0', '0', '0', "grey","Ville neutre" , 0);INSERT INTO amadeus.carte_2 (x, y, usines, habitants, armee, argent, couleur, nom, id_user) VALUES ('3' , '4', '0', '0', '0', '0', "grey","Ville neutre" , 0);INSERT INTO amadeus.carte_2 (x, y, usines, habitants, armee, argent, couleur, nom, id_user) VALUES ('3' , '5', '0', '0', '0', '0', "grey","Ville neutre" , 0);INSERT INTO amadeus.carte_2 (x, y, usines, habitants, armee, argent, couleur, nom, id_user) VALUES ('3' , '6', '0', '0', '0', '0', "grey","Ville neutre" , 0);INSERT INTO amadeus.carte_2 (x, y, usines, habitants, armee, argent, couleur, nom, id_user) VALUES ('3' , '7', '0', '0', '0', '0', "grey","Ville neutre" , 0);INSERT INTO amadeus.carte_2 (x, y, usines, habitants, armee, argent, couleur, nom, id_user) VALUES ('4' , '0', '0', '0', '0', '0', "grey","Ville neutre" , 0);INSERT INTO amadeus.carte_2 (x, y, usines, habitants, armee, argent, couleur, nom, id_user) VALUES ('4' , '1', '0', '0', '0', '0', "grey","Ville neutre" , 0);INSERT INTO amadeus.carte_2 (x, y, usines, habitants, armee, argent, couleur, nom, id_user) VALUES ('4' , '2', '0', '0', '0', '0', "grey","Ville neutre" , 0);INSERT INTO amadeus.carte_2 (x, y, usines, habitants, armee, argent, couleur, nom, id_user) VALUES ('4' , '3', '0', '0', '0', '0', "grey","Ville neutre" , 0);INSERT INTO amadeus.carte_2 (x, y, usines, habitants, armee, argent, couleur, nom, id_user) VALUES ('4' , '4', '0', '0', '0', '0', "grey","Ville neutre" , 0);INSERT INTO amadeus.carte_2 (x, y, usines, habitants, armee, argent, couleur, nom, id_user) VALUES ('4' , '5', '0', '0', '0', '0', "grey","Ville neutre" , 0);INSERT INTO amadeus.carte_2 (x, y, usines, habitants, armee, argent, couleur, nom, id_user) VALUES ('4' , '6', '0', '0', '0', '0', "grey","Ville neutre" , 0);INSERT INTO amadeus.carte_2 (x, y, usines, habitants, armee, argent, couleur, nom, id_user) VALUES ('4' , '7', '0', '0', '0', '0', "grey","Ville neutre" , 0);INSERT INTO amadeus.carte_2 (x, y, usines, habitants, armee, argent, couleur, nom, id_user) VALUES ('5' , '0', '0', '0', '0', '0', "grey","Ville neutre" , 0);INSERT INTO amadeus.carte_2 (x, y, usines, habitants, armee, argent, couleur, nom, id_user) VALUES ('5' , '1', '0', '0', '0', '0', "grey","Ville neutre" , 0);INSERT INTO amadeus.carte_2 (x, y, usines, habitants, armee, argent, couleur, nom, id_user) VALUES ('5' , '2', '0', '0', '0', '0', "grey","Ville neutre" , 0);INSERT INTO amadeus.carte_2 (x, y, usines, habitants, armee, argent, couleur, nom, id_user) VALUES ('5' , '3', '0', '0', '0', '0', "grey","Ville neutre" , 0);INSERT INTO amadeus.carte_2 (x, y, usines, habitants, armee, argent, couleur, nom, id_user) VALUES ('5' , '4', '0', '0', '0', '0', "grey","Ville neutre" , 0);INSERT INTO amadeus.carte_2 (x, y, usines, habitants, armee, argent, couleur, nom, id_user) VALUES ('5' , '5', '0', '0', '0', '0', "grey","Ville neutre" , 0);INSERT INTO amadeus.carte_2 (x, y, usines, habitants, armee, argent, couleur, nom, id_user) VALUES ('5' , '6', '0', '0', '0', '0', "grey","Ville neutre" , 0);INSERT INTO amadeus.carte_2 (x, y, usines, habitants, armee, argent, couleur, nom, id_user) VALUES ('5' , '7', '0', '0', '0', '0', "grey","Ville neutre" , 0);INSERT INTO amadeus.carte_2 (x, y, usines, habitants, armee, argent, couleur, nom, id_user) VALUES ('6' , '0', '0', '0', '0', '0', "grey","Ville neutre" , 0);INSERT INTO amadeus.carte_2 (x, y, usines, habitants, armee, argent, couleur, nom, id_user) VALUES ('6' , '1', '0', '0', '0', '0', "grey","Ville neutre" , 0);INSERT INTO amadeus.carte_2 (x, y, usines, habitants, armee, argent, couleur, nom, id_user) VALUES ('6' , '2', '0', '0', '0', '0', "grey","Ville neutre" , 0);INSERT INTO amadeus.carte_2 (x, y, usines, habitants, armee, argent, couleur, nom, id_user) VALUES ('6' , '3', '0', '0', '0', '0', "grey","Ville neutre" , 0);INSERT INTO amadeus.carte_2 (x, y, usines, habitants, armee, argent, couleur, nom, id_user) VALUES ('6' , '4', '0', '0', '0', '0', "grey","Ville neutre" , 0);INSERT INTO amadeus.carte_2 (x, y, usines, habitants, armee, argent, couleur, nom, id_user) VALUES ('6' , '5', '0', '0', '0', '0', "grey","Ville neutre" , 0);INSERT INTO amadeus.carte_2 (x, y, usines, habitants, armee, argent, couleur, nom, id_user) VALUES ('6' , '6', '0', '0', '0', '0', "grey","Ville neutre" , 0);INSERT INTO amadeus.carte_2 (x, y, usines, habitants, armee, argent, couleur, nom, id_user) VALUES ('6' , '7', '0', '0', '0', '0', "grey","Ville neutre" , 0);INSERT INTO amadeus.carte_2 (x, y, usines, habitants, armee, argent, couleur, nom, id_user) VALUES ('7' , '0', '0', '0', '0', '0', "grey","Ville neutre" , 0);INSERT INTO amadeus.carte_2 (x, y, usines, habitants, armee, argent, couleur, nom, id_user) VALUES ('7' , '1', '0', '0', '0', '0', "grey","Ville neutre" , 0);INSERT INTO amadeus.carte_2 (x, y, usines, habitants, armee, argent, couleur, nom, id_user) VALUES ('7' , '2', '0', '0', '0', '0', "grey","Ville neutre" , 0);INSERT INTO amadeus.carte_2 (x, y, usines, habitants, armee, argent, couleur, nom, id_user) VALUES ('7' , '3', '0', '0', '0', '0', "grey","Ville neutre" , 0);INSERT INTO amadeus.carte_2 (x, y, usines, habitants, armee, argent, couleur, nom, id_user) VALUES ('7' , '4', '0', '0', '0', '0', "grey","Ville neutre" , 0);INSERT INTO amadeus.carte_2 (x, y, usines, habitants, armee, argent, couleur, nom, id_user) VALUES ('7' , '5', '0', '0', '0', '0', "grey","Ville neutre" , 0);INSERT INTO amadeus.carte_2 (x, y, usines, habitants, armee, argent, couleur, nom, id_user) VALUES ('7' , '6', '0', '0', '0', '0', "grey","Ville neutre" , 0);INSERT INTO amadeus.carte_2 (x, y, usines, habitants, armee, argent, couleur, nom, id_user) VALUES ('7' , '7', '0', '0', '0', '0', "grey","Ville neutre" , 0);
une fois générée.
Partager