· 7 years ago · Dec 31, 2018, 03:04 AM
1/*
2Navicat MySQL Data Transfer
3Source Server : Localhost
4Source Server Version : 50714
5Source Host : localhost:3306
6Source Database : nopixel
7Target Server Type : MYSQL
8Target Server Version : 50714
9File Encoding : 65001
10Date: 2016-10-14 23:03:08
11*/
12
13SET FOREIGN_KEY_CHECKS=0;
14
15USE rwdatabase;
16
17-- ----------------------------
18-- Table structure for garage
19-- ----------------------------
20DROP TABLE IF EXISTS `garage`;
21CREATE TABLE `garage` (
22 `license` varchar(32) NOT NULL,
23 `class` varchar(32) NOT NULL,
24 `color` varchar(32) NOT NULL,
25 `finish` varchar(32) NOT NULL,
26 `rims` varchar(32) NOT NULL,
27 `owner` varchar(32) NOT NULL,
28 `statuses` text NOT NULL,
29 `windows` int(1) NOT NULL DEFAULT '0',
30 `lights` int(1) NOT NULL DEFAULT '0',
31 PRIMARY KEY (`license`)
32) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
33
34-- ----------------------------
35-- Table structure for mail
36-- ----------------------------
37DROP TABLE IF EXISTS `mail`;
38CREATE TABLE `mail` (
39 `message` varchar(32) NOT NULL,
40 `title` varchar(32) NOT NULL,
41 `sender` varchar(32) NOT NULL,
42 `receiver` varchar(32) NOT NULL
43) ENGINE=InnoDB DEFAULT CHARSET=latin1;
44
45-- ----------------------------
46-- Records of mail
47-- ----------------------------
48
49-- ----------------------------
50-- Table structure for messages
51-- ----------------------------
52DROP TABLE IF EXISTS `messages`;
53CREATE TABLE `messages` (
54 `message` varchar(64) NOT NULL,
55 `title` varchar(64) NOT NULL,
56 `sender` varchar(64) NOT NULL,
57 `receiver` varchar(64) NOT NULL
58) ENGINE=InnoDB DEFAULT CHARSET=latin1;
59
60-- ----------------------------
61-- Records of messages
62-- ----------------------------
63
64-- ----------------------------
65-- Table structure for users
66-- ----------------------------
67DROP TABLE IF EXISTS `users`;
68CREATE TABLE `users` (
69 `uid` varchar(50) DEFAULT NULL,
70 `name` varchar(50) DEFAULT NULL,
71 `items` varchar(1500) NOT NULL,
72 `cash` int(13) NOT NULL,
73 `bank` int(13) NOT NULL,
74 `cop` int(13) NOT NULL,
75 `ems` int(13) NOT NULL,
76 `position` varchar(50) NOT NULL,
77 `bankaccount` int(11) NOT NULL AUTO_INCREMENT,
78 `phoneBackground` varchar(50) NOT NULL,
79 `messages` varchar(5000) NOT NULL,
80 `statuses` text NOT NULL,
81 `houselevel` enum('1','2','3') NOT NULL DEFAULT '1',
82 `housecontent` text NOT NULL,
83 `shopcontent` text NOT NULL,
84 `shopname` varchar(32) NOT NULL,
85 `mafia` enum('0','1','2','3','4','5','6') NOT NULL DEFAULT '0',
86 `fire` enum('0','1','2','3','4','5','6') NOT NULL DEFAULT '0',
87 `legal` enum('0','1','2','3') NOT NULL DEFAULT '0',
88 `prison` tinyint(1) NOT NULL DEFAULT '0',
89 `prisonreason` varchar(32) NOT NULL,
90 PRIMARY KEY (`bankaccount`),
91 UNIQUE KEY `uid` (`uid`)
92) ENGINE=InnoDB AUTO_INCREMENT=89 DEFAULT CHARSET=latin1;
93
94-- ----------------------------
95-- Table structure for wanted
96-- ----------------------------
97DROP TABLE IF EXISTS `wanted`;
98CREATE TABLE `wanted` (
99 `suspectID` varchar(32) NOT NULL,
100 `officerGUID` varchar(32) NOT NULL,
101 `charges` text NOT NULL,
102 `status` tinyint(1) NOT NULL DEFAULT '0',
103 `evidence` text NOT NULL
104) ENGINE=InnoDB DEFAULT CHARSET=utf8;