3X2yfBiJ

1/*
2Navicat MySQL Data Transfer
3
4Source Server         : acerp
5Source Server Version : 50545
6Source Host           : localhost:3306
7Source Database       : acerp
8
9Target Server Type    : MYSQL
10Target Server Version : 50545
11File Encoding         : 65001
12
13Date: 2020-01-21 16:48:53
14*/
15
16SET FOREIGN_KEY_CHECKS=0;
17
18-- ----------------------------
19-- Table structure for group_ranks
20-- ----------------------------
21DROP TABLE IF EXISTS `group_ranks`;
22CREATE TABLE `group_ranks` (
23  `rank` int(255) NOT NULL,
24  `name` varchar(255) NOT NULL,
25  `male_figure` varchar(255) NOT NULL,
26  `female_figure` varchar(255) NOT NULL,
27  `pay` int(255) NOT NULL,
28  `commands` varchar(255) NOT NULL,
29  `workrooms` varchar(255) NOT NULL,
30  `limit` int(255) NOT NULL
31) ENGINE=InnoDB DEFAULT CHARSET=utf8;
32
33-- ----------------------------
34-- Table structure for groups
35-- ----------------------------
36DROP TABLE IF EXISTS `groups`;
37CREATE TABLE `groups` (
38  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
39  `name` varchar(50) NOT NULL,
40  `desc` varchar(255) NOT NULL,
41  `badge` varchar(50) NOT NULL,
42  `owner_id` int(11) unsigned NOT NULL,
43  `created` int(50) NOT NULL,
44  `room_id` int(10) unsigned NOT NULL DEFAULT '0',
45  `state` enum('0','1','2') NOT NULL DEFAULT '0',
46  `colour1` int(11) NOT NULL DEFAULT '242424',
47  `colour2` int(11) NOT NULL DEFAULT '242424',
48  `admindeco` enum('0','1') NOT NULL DEFAULT '1',
49  `forum_enabled` enum('0','1') NOT NULL DEFAULT '0',
50  `has_chat` enum('1','0') NOT NULL DEFAULT '0',
51  `gtypes` enum('Gangs','Groups','Jobs') NOT NULL DEFAULT 'Groups',
52  PRIMARY KEY (`id`),
53  UNIQUE KEY `id` (`id`) USING BTREE,
54  KEY `room_id` (`room_id`) USING BTREE,
55  KEY `owner` (`owner_id`) USING BTREE
56) ENGINE=InnoDB AUTO_INCREMENT=89 DEFAULT CHARSET=latin1;