Jsd1ymyN

1Erreur
2Requête SQL :
3
4DELIMITER ;
5
6-- --------------------------------------------------------
7
8--
9-- Table structure for table `players`
10--
11
12CREATE TABLE IF NOT EXISTS `players` (
13  `uid` int(12) NOT NULL AUTO_INCREMENT,
14  `name` varchar(32) NOT NULL,
15  `aliases` text NOT NULL,
16  `playerid` varchar(64) NOT NULL,
17  `cash` int(100) NOT NULL DEFAULT '0',
18  `bankacc` int(100) NOT NULL DEFAULT '0',
19  `coplevel` enum('0','1','2','3','4','5','6','7') NOT NULL DEFAULT '0',
20  `mediclevel` enum('0','1','2','3','4','5') NOT NULL DEFAULT '0',
21  `civ_licenses` text NOT NULL,
22  `cop_licenses` text NOT NULL,
23  `med_licenses` text NOT NULL,
24  `civ_gear` text NOT NULL,
25  `cop_gear` text NOT NULL,
26  `med_gear` text NOT NULL,
27  `civ_stats` varchar(32) NOT NULL DEFAULT '"[100,100,0]"',
28  `cop_stats` varchar(32) NOT NULL DEFAULT '"[100,100,0]"',
29  `med_stats` varchar(32) NOT NULL DEFAULT '"[100,100,0]"',
30  `arrested` tinyint(1) NOT NULL DEFAULT '0',
31  `adminlevel` enum('0','1','2','3','4','5') NOT[...]
32
33MySQL a répondu: Documentation
34
35#1293 - Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause