/*
Navicat MySQL Data Transfer

Source Server         : caca
Source Server Version : 50718
Source Host           : localhost:3306
Source Database       : gta5_gamemode_essential

Target Server Type    : MYSQL
Target Server Version : 50718
File Encoding         : 65001

Date: 2017-04-14 13:16:34
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for bans
-- ----------------------------
DROP TABLE IF EXISTS `bans`;
CREATE TABLE `bans` (
  `id` varchar(50) NOT NULL,
  `reason` varchar(150) NOT NULL,
  `expires` datetime NOT NULL,
  `banned` int(255) NOT NULL DEFAULT '0',
  `banner` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for plugins_data
-- ----------------------------
DROP TABLE IF EXISTS `plugins_data`;
CREATE TABLE `plugins_data` (
  `weapons` varchar(5000) NOT NULL,
  `vehicles` varchar(10000) NOT NULL,
  `identifier` varchar(50) NOT NULL,
  PRIMARY KEY (`identifier`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for users
-- ----------------------------
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
  `identifier` varchar(50) NOT NULL,
  `group` varchar(50) NOT NULL,
  `money` int(255) NOT NULL,
  `banned` int(255) NOT NULL DEFAULT '0',
  `banreason` varchar(50) NOT NULL DEFAULT '0',
  `permission_level` int(255) NOT NULL,
  `job` varchar(20) NOT NULL DEFAULT '0',
  PRIMARY KEY (`identifier`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET FOREIGN_KEY_CHECKS=1;
