Umb7EM1i

1-- ----------------------------
2-- Table structure for `vehicles`
3-- ----------------------------
4DROP TABLE IF EXISTS `vehicles`;
5CREATE TABLE `vehicles` (
6  `id` int(6) NOT NULL AUTO_INCREMENT,
7  `side` varchar(16) NOT NULL,
8  `classname` varchar(64) NOT NULL,
9  `type` varchar(16) NOT NULL,
10  `pid` varchar(17) NOT NULL,
11  `alive` tinyint(1) NOT NULL DEFAULT '1',
12  `blacklist` tinyint(1) NOT NULL DEFAULT '0',
13  `active` tinyint(1) NOT NULL DEFAULT '0',
14  `insure` tinyint(1) NOT NULL DEFAULT '0',
15  `plate` int(20) NOT NULL,
16  `color` int(20) NOT NULL,
17  `inventory` text NOT NULL,
18  `gear` text NOT NULL,
19  `fuel` double NOT NULL DEFAULT '1',
20  `damage` varchar(256) NOT NULL,
21  `insert_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
22  PRIMARY KEY (`id`),
23  KEY `side` (`side`),
24  KEY `pid` (`pid`),
25  KEY `type` (`type`)
26) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4;