JjRPEFAE

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