personnages.sql

télécharger

CREATE TABLE `personnages` 
(`id`            smallint(5)     not null     auto_increment,
 `nom`           varchar(50)     COLLATE latin1_general_ci    not null,
 `puissance`     int,
 `degats`        int,
 `experience`    int,
 `niveau`        int,
 PRIMARY KEY   (`id`)
 );

INSERT INTO personnages ( `nom`, `puissance`, `degats`, `experience`, `niveau`)
VALUES 
 ('Roi',        80, 0, 50, 13),
 ('Reine',      50, 0, 50, 12),
 ('Fou',        20, 0, 20, 11),
 ('Tour',       20, 0, 50, 10),
 ('Combattant', 80, 0, 50, 9),
 ('Soldat',     50, 0, 20, 8),
 ('Garde',      50, 0, 20, 7),
 ('Fantassin',  50, 0, 20, 6),
 ('Alerte',     20, 0, 50, 5),
 ('Déesse',     20, 0, 80, 4),
 ('Amazone',    20, 0, 50, 3)
;