k8yVDzEs

1CREATE TABLE IF NOT EXISTS `owned_vehicle` (
2
3  `owner` varchar(22) NOT NULL,
4
5  `state` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'State of the car',
6
7  `plate` varchar(12) NOT NULL,
8
9  `vehicle` longtext,
10
11  `type` varchar(20) NOT NULL DEFAULT 'car',
12
13  `job` varchar(20) NOT NULL,
14
15  `x` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT '0',
16
17  `y` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT '0',
18
19  `z` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT '0',
20
21  `h` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT '0',
22
23  `health` int(11) DEFAULT '0',
24
25  `nitro` varchar(50) NOT NULL DEFAULT 'nao',
26
27  `lockcheck` varchar(50) NOT NULL DEFAULT 'nao',
28
29  `lastid` int(20) DEFAULT NULL,
30
31  PRIMARY KEY (`plate`)
32
33) ENGINE=InnoDB DEFAULT CHARSET=latin1;