7CJj2BqW

1[13:57] Good4Lucky: lol
2[13:57] Good4Lucky: well if yes
3[13:57] Good4Lucky: wait a second
4[13:58] Good4Lucky: use this sql and this work
5[13:58] Good4Lucky: 
6 USE `altislife`;
7
8CREATE TABLE `message` (
9  `id` int(12) NOT NULL AUTO_INCREMENT,
10  `de` varchar(20) NOT NULL,
11  `deUID` varchar(50) NOT NULL,
12  `toP` varchar(20) NOT NULL,
13  `toUID` varchar(50) NOT NULL,
14  `message` text NOT NULL,
15  `nowtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
16  PRIMARY KEY (`id`)
17) ENGINE=InnoDB AUTO_INCREMENT=1484 DEFAULT CHARSET=latin1;
18
19DROP TABLE IF EXISTS `xphone`;
20CREATE TABLE `xphone`  (
21  `uid` int(12) NOT NULL AUTO_INCREMENT,
22  `pid` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
23  `playtime` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '\"[0,0,0]\"',
24  `insert_time` timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP,
25  `last_seen` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP(0),
26  `numero` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
27  `contact` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
28  PRIMARY KEY (`uid`) USING BTREE,
29  UNIQUE INDEX `playerid`(`pid`) USING BTREE
30) ENGINE = InnoDB AUTO_INCREMENT = 84 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Compact;
31
32DROP TABLE IF EXISTS `xphoneinsure`;
33CREATE TABLE `xphoneinsure`  (
34  `id` int(6) NOT NULL AUTO_INCREMENT,
35  `pid` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
36  `plate` int(20) NOT NULL,
37  `insure` int(1) NOT NULL DEFAULT 0,
38  `fourriere` tinyint(1) NOT NULL DEFAULT 0,
39  PRIMARY KEY (`id`) USING BTREE,
40  INDEX `pid`(`pid`) USING BTREE
41) ENGINE = InnoDB AUTO_INCREMENT = 310 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
42 
43[13:59] Good4Lucky: the modify is just remove the 
44 CREATE TABLE IF NOT EXISTS `message`; 
45 before the 
46 CREATE TABLE 'message'
47[13:59] Good4Lucky: and the tables will created ^^