19AzrpBn

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
18-- ----------------------------
19-- Table structure for garage
20-- ----------------------------
21DROP TABLE IF EXISTS `garage`;
22CREATE TABLE `garage` (
23  `license` varchar(32) NOT NULL,
24  `class` varchar(32) NOT NULL,
25  `color` varchar(32) NOT NULL,
26  `finish` varchar(32) NOT NULL,
27  `rims` varchar(32) NOT NULL,
28  `owner` varchar(32) NOT NULL,
29  `statuses` text NOT NULL,
30  `windows` int(1) NOT NULL DEFAULT '0',
31  `lights` int(1) NOT NULL DEFAULT '0',
32  PRIMARY KEY (`license`)
33) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
34
35-- ----------------------------
36-- Table structure for mail
37-- ----------------------------
38DROP TABLE IF EXISTS `mail`;
39CREATE TABLE `mail` (
40  `message` varchar(32) NOT NULL,
41  `title` varchar(32) NOT NULL,
42  `sender` varchar(32) NOT NULL,
43  `receiver` varchar(32) NOT NULL
44) ENGINE=InnoDB DEFAULT CHARSET=latin1;
45
46-- ----------------------------
47-- Table structure for messages
48-- ----------------------------
49DROP TABLE IF EXISTS `messages`;
50CREATE TABLE `messages` (
51  `message` varchar(64) NOT NULL,
52  `title` varchar(64) NOT NULL,
53  `sender` varchar(64) NOT NULL,
54  `receiver` varchar(64) NOT NULL
55) ENGINE=InnoDB DEFAULT CHARSET=latin1;
56
57-- ----------------------------
58-- Table structure for users
59-- ----------------------------
60DROP TABLE IF EXISTS `users`;
61CREATE TABLE `users` (
62  `uid` varchar(50) DEFAULT NULL,
63  `name` varchar(50) DEFAULT NULL,
64  `items` varchar(1500) NOT NULL,
65  `cash` int(13) NOT NULL,
66  `bank` int(13) NOT NULL,
67  `cop` int(13) NOT NULL,
68  `ems` int(13) NOT NULL,
69  `position` varchar(50) NOT NULL,
70  `bankaccount` int(11) NOT NULL AUTO_INCREMENT,
71  `phoneBackground` varchar(50) NOT NULL,
72  `messages` varchar(5000) NOT NULL,
73  `statuses` text NOT NULL,
74  `houselevel` enum('1','2','3') NOT NULL DEFAULT '1',
75  `housecontent` text NOT NULL,
76  `shopcontent` text NOT NULL,
77  `shopname` varchar(32) NOT NULL,
78  `mafia` enum('0','1','2','3','4','5','6') NOT NULL DEFAULT '0',
79  `fire` enum('0','1','2','3','4','5','6') NOT NULL DEFAULT '0',
80  `legal` enum('0','1','2','3') NOT NULL DEFAULT '0',
81  `prison` tinyint(1) NOT NULL DEFAULT '0',
82  `prisonreason` varchar(32) NOT NULL,
83  PRIMARY KEY (`bankaccount`),
84  UNIQUE KEY `uid` (`uid`)
85) ENGINE=InnoDB AUTO_INCREMENT=89 DEFAULT CHARSET=latin1;
86
87-- ----------------------------
88-- Table structure for wanted
89-- ----------------------------
90DROP TABLE IF EXISTS `wanted`;
91CREATE TABLE `wanted` (
92  `suspectID` varchar(32) NOT NULL,
93  `officerGUID` varchar(32) NOT NULL,
94  `charges` text NOT NULL,
95  `status` tinyint(1) NOT NULL DEFAULT '0',
96  `evidence` text NOT NULL
97) ENGINE=InnoDB DEFAULT CHARSET=utf8;