· 5 years ago · Feb 23, 2020, 04:04 PM
1CREATE TABLE IF NOT EXISTS `gangs` (
2 `id` int(11) NOT NULL AUTO_INCREMENT,
3 `owner` varchar(32) DEFAULT NULL,
4 `name` varchar(32) DEFAULT NULL,
5 `tag` varchar(45) NOT NULL,
6 `members` text,
7 `maxmembers` int(3) DEFAULT '8',
8 `coins` int(11) NOT NULL DEFAULT '0',
9 `gang_shop` tinyint(1) NOT NULL DEFAULT '0',
10 `drug_island` tinyint(1) NOT NULL DEFAULT '0',
11 `bank` int(100) DEFAULT '0',
12 `active` tinyint(1) DEFAULT '1',
13 `insert_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
14 `skin_buyed` tinyint(1) NOT NULL DEFAULT '0',
15 `skins_buyed` tinyint(1) NOT NULL DEFAULT '0',
16 PRIMARY KEY (`id`),
17 UNIQUE KEY `name_UNIQUE` (`name`)
18) ENGINE=InnoDB AUTO_INCREMENT=42 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;