51G95a0m

1#1:
2ALTER TABLE players ADD idcard_data_civ varchar(500) NOT NULL DEFAULT '"[]"';
3ALTER TABLE players ADD idcard_data_cop varchar(500) NOT NULL DEFAULT '"[]"';
4ALTER TABLE players ADD idcard_data_med varchar(500) NOT NULL DEFAULT '"[]"';
5
6#2:
7CREATE TABLE IF NOT EXISTS `sold_objects` (
8  `id` int(11) NOT NULL AUTO_INCREMENT,
9  `olduid` varchar(17) NOT NULL,
10  `newuid` varchar(17) NOT NULL,
11  `index_value` varchar(17) NOT NULL,
12  `object_classname` tinytext NOT NULL,
13  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
14  PRIMARY KEY (`id`)
15) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
16
17#3:
18CREATE TABLE IF NOT EXISTS `locker` (
19	`id` int(11) NOT NULL AUTO_INCREMENT,
20	`uid` varchar(17) NOT NULL,
21	`active` tinyint(1) NOT NULL DEFAULT '1',
22	`side` char(50) NOT NULL,
23	`level` int(11) NOT NULL DEFAULT '1',
24	`open` tinyint(1) NOT NULL DEFAULT '0',
25	`locker_dbprimary` text NOT NULL,
26	`locker_dbhandgun` text NOT NULL,
27	`locker_dbattach` text NOT NULL,
28	`locker_clothing` text NOT NULL,
29	`locker_vests` text NOT NULL,
30	`locker_backpack` text NOT NULL,
31	`locker_other` text NOT NULL,
32	`locker_items` text NOT NULL,
33	`locker_virtitems` text NOT NULL,
34	`created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
35	`updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
36	PRIMARY KEY (`id`)
37) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8mb4;