7yvVUkRt

1/*
2Navicat MySQL Data Transfer
3
4Source Server         : Localhost
5Source Server Version : 50714
6Source Host           : localhost:3306
7Source Database       : nopixel
8
9Target Server Type    : MYSQL
10Target Server Version : 50714
11File Encoding         : 65001
12
13Date: 2016-10-14 23:03:08
14*/
15
16SET FOREIGN_KEY_CHECKS=0;
17
18CREATE DATABASE IF NOT EXISTS rwdatabase /*!40100 DEFAULT CHARACTER SET latin1 */;
19USE rwdatabase;
20
21-- ----------------------------
22-- Table structure for garage
23-- ----------------------------
24DROP TABLE IF EXISTS `garage`;
25CREATE TABLE `garage` (
26  `license` varchar(32) NOT NULL,
27  `class` varchar(32) NOT NULL,
28  `color` varchar(32) NOT NULL,
29  `finish` varchar(32) NOT NULL,
30  `rims` varchar(32) NOT NULL,
31  `owner` varchar(32) NOT NULL,
32  `statuses` text NOT NULL,
33  `windows` int(1) NOT NULL DEFAULT '0',
34  `lights` int(1) NOT NULL DEFAULT '0',
35  PRIMARY KEY (`license`)
36) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
37
38-- ----------------------------
39-- Table structure for mail
40-- ----------------------------
41DROP TABLE IF EXISTS `mail`;
42CREATE TABLE `mail` (
43  `message` varchar(32) NOT NULL,
44  `title` varchar(32) NOT NULL,
45  `sender` varchar(32) NOT NULL,
46  `receiver` varchar(32) NOT NULL
47) ENGINE=InnoDB DEFAULT CHARSET=latin1;
48
49  `messages` varchar(5000) NOT NULL,
50  `statuses` text NOT NULL,
51  `houselevel` enum('1','2','3') NOT NULL DEFAULT '1',
52  `housecontent` text NOT NULL,
53  `shopcontent` text NOT NULL,
54  `shopname` varchar(32) NOT NULL,
55  `mafia` enum('0','1','2','3','4','5','6') NOT NULL DEFAULT '0',
56  `fire` enum('0','1','2','3','4','5','6') NOT NULL DEFAULT '0',
57  `legal` enum('0','1','2','3') NOT NULL DEFAULT '0',
58  `prison` tinyint(1) NOT NULL DEFAULT '0',
59  `prisonreason` varchar(32) NOT NULL,
60  PRIMARY KEY (`bankaccount`),
61  UNIQUE KEY `uid` (`uid`)
62) ENGINE=InnoDB AUTO_INCREMENT=89 DEFAULT CHARSET=latin1;
63
64-- ----------------------------
65-- Table structure for wanted
66-- ----------------------------
67DROP TABLE IF EXISTS `wanted`;
68CREATE TABLE `wanted` (
69  `suspectID` varchar(32) NOT NULL,
70  `officerGUID` varchar(32) NOT NULL,
71  `charges` text NOT NULL,
72  `status` tinyint(1) NOT NULL DEFAULT '0',
73  `evidence` text NOT NULL
74) ENGINE=InnoDB DEFAULT CHARSET=utf8;