NNNr7BfE

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