· 6 years ago · Jun 30, 2019, 02:40 PM
1CREATE TABLE IF NOT EXISTS `locker` (
2 `id` int(11) NOT NULL AUTO_INCREMENT,
3 `uid` varchar(17) NOT NULL,
4 `active` tinyint(1) NOT NULL DEFAULT '1',
5 `side` char(50) NOT NULL,
6 `level` int(11) NOT NULL DEFAULT '1',
7 `open` tinyint(1) NOT NULL DEFAULT '0',
8 `locker_dbprimary` text NOT NULL,
9 `locker_dbhandgun` text NOT NULL,
10 `locker_dbattach` text NOT NULL,
11 `locker_clothing` text NOT NULL,
12 `locker_vests` text NOT NULL,
13 `locker_backpack` text NOT NULL,
14 `locker_other` text NOT NULL,
15 `locker_items` text NOT NULL,
16 `locker_virtitems` text NOT NULL,
17 `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
18 `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
19 PRIMARY KEY (`id`)
20) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8mb4;