· 7 years ago · Jan 27, 2019, 02:08 PM
1DROP TABLE IF EXISTS `gearloadouts`;
2CREATE TABLE IF NOT EXISTS `gearloadouts` (
3 `id` int(11) NOT NULL AUTO_INCREMENT,
4 `pid` varchar(30) NOT NULL DEFAULT '0',
5 `side` varchar(30) NOT NULL DEFAULT '0',
6 `gearname` varchar(128) NOT NULL DEFAULT '0',
7 `gearitems` longtext NOT NULL,
8 `yitems` longtext NOT NULL,
9 `tmp` int(2) NOT NULL DEFAULT 0,
10 `insert_time` timestamp NOT NULL DEFAULT current_timestamp(),
11 PRIMARY KEY (`id`)
12) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;