· 7 years ago · Dec 12, 2018, 12:28 PM
1CREATE TABLE IF NOT EXISTS `personnages_v2` (
2 `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
3 `nom` varchar(50) COLLATE utf8_general_ci NOT NULL,
4 `degats` tinyint(3) unsigned NOT NULL DEFAULT '0',
5 `timeEndormi` int(10) unsigned NOT NULL DEFAULT '0',
6 `type` enum('magicien','guerrier') COLLATE utf8_general_ci NOT NULL,
7 `atout` tinyint(3) unsigned NOT NULL DEFAULT '0',
8 PRIMARY KEY (`id`)
9 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;