· 9 years ago · Oct 02, 2016, 06:36 PM
1-- phpMyAdmin SQL Dump
2-- version 4.2.9.1
3-- http://www.phpmyadmin.net
4--
5-- Host: localhost:3306
6-- Generation Time: Feb 04, 2015 at 10:34 AM
7-- Server version: 5.5.40-log
8-- PHP Version: 5.4.33
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13
14/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
15/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
16/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
17/*!40101 SET NAMES utf8 */;
18
19--
20-- Database: `ms558.nitrado.net`
21--
22
23DELIMITER $$
24--
25-- Procedures
26--
27CREATE DEFINER=`ms558.nitrado.net`@`localhost` PROCEDURE `deleteDeadVehicles`()
28BEGIN
29
30 DELETE FROM `vehicles` WHERE `alive` = 0;
31
32END$$
33
34CREATE DEFINER=`ms558.nitrado.net`@`localhost` PROCEDURE `deleteOldGangs`()
35BEGIN
36
37 DELETE FROM `gangs` WHERE `active` = 0;
38
39END$$
40
41CREATE DEFINER=`ms558.nitrado.net`@`localhost` PROCEDURE `deleteOldHouses`()
42BEGIN
43
44 DELETE FROM `houses` WHERE `owned` = 0;
45
46END$$
47
48CREATE DEFINER=`ms558.nitrado.net`@`localhost` PROCEDURE `resetLifeVehicles`()
49BEGIN
50
51 UPDATE vehicles SET `active`= 0;
52
53END$$
54
55DELIMITER ;
56
57-- --------------------------------------------------------
58
59--
60-- Table structure for table `gangs`
61--
62
63CREATE TABLE IF NOT EXISTS `gangs` (
64`id` int(11) NOT NULL,
65 `owner` varchar(32) DEFAULT NULL,
66 `name` varchar(32) DEFAULT NULL,
67 `members` text,
68 `maxmembers` int(2) DEFAULT '8',
69 `bank` int(100) DEFAULT '0',
70 `active` tinyint(4) DEFAULT '1'
71) ENGINE=InnoDB DEFAULT CHARSET=latin1;
72
73-- --------------------------------------------------------
74
75--
76-- Table structure for table `houses`
77--
78
79CREATE TABLE IF NOT EXISTS `houses` (
80`id` int(11) NOT NULL,
81 `pid` varchar(32) NOT NULL,
82 `pos` varchar(64) DEFAULT NULL,
83 `inventory` text,
84 `containers` text,
85 `owned` tinyint(4) DEFAULT '0',
86 `security` text NOT NULL
87) ENGINE=InnoDB DEFAULT CHARSET=latin1;
88
89-- --------------------------------------------------------
90
91--
92-- Table structure for table `players`
93--
94
95CREATE TABLE IF NOT EXISTS `players` (
96`uid` int(12) NOT NULL,
97 `name` varchar(32) NOT NULL,
98 `playerid` varchar(50) NOT NULL,
99 `cash` int(100) NOT NULL DEFAULT '0',
100 `bankacc` int(100) NOT NULL DEFAULT '0',
101 `coplevel` enum('0','1','2','3','4','5','6','7','8') NOT NULL DEFAULT '0',
102 `cop_licenses` text,
103 `civ_licenses` text,
104 `med_licenses` text,
105 `cop_gear` text NOT NULL,
106 `med_gear` text NOT NULL,
107 `mediclevel` enum('0','1','2','3','4') NOT NULL DEFAULT '0',
108 `arrested` tinyint(1) NOT NULL DEFAULT '0',
109 `aliases` text NOT NULL,
110 `adminlevel` enum('0','1','2','3','4','5') NOT NULL DEFAULT '0',
111 `donatorlvl` enum('0','1') NOT NULL DEFAULT '0',
112 `civ_gear` text NOT NULL,
113 `blacklist` tinyint(1) NOT NULL DEFAULT '0',
114 `ASF_licenses` text NOT NULL,
115 `ASF_gear` text NOT NULL,
116 `ASFlevel` enum('0','1','2','3','4','5','6') NOT NULL,
117 `bounties` text,
118 `jail_time` int(11) NOT NULL DEFAULT '0'
119) ENGINE=InnoDB AUTO_INCREMENT=41 DEFAULT CHARSET=latin1;
120
121--
122-- Dumping data for table `players`
123--
124
125-- --------------------------------------------------------
126
127--
128-- Table structure for table `vehicles`
129--
130
131CREATE TABLE IF NOT EXISTS `vehicles` (
132`id` int(12) NOT NULL,
133 `side` varchar(15) NOT NULL,
134 `classname` varchar(32) NOT NULL,
135 `type` varchar(12) NOT NULL,
136 `pid` varchar(32) NOT NULL,
137 `alive` tinyint(1) NOT NULL DEFAULT '1',
138 `active` tinyint(1) NOT NULL DEFAULT '0',
139 `plate` int(20) NOT NULL,
140 `color` int(20) NOT NULL,
141 `inventory` varchar(500) NOT NULL
142) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=latin1;
143
144--
145-- Dumping data for table `vehicles`
146--
147
148--
149-- Indexes for dumped tables
150--
151
152
153--
154-- Indexes for table `gangs`
155--
156ALTER TABLE `gangs`
157 ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `name_UNIQUE` (`name`);
158
159--
160-- Indexes for table `houses`
161--
162ALTER TABLE `houses`
163 ADD PRIMARY KEY (`id`,`pid`);
164
165--
166-- Indexes for table `players`
167--
168ALTER TABLE `players`
169 ADD PRIMARY KEY (`uid`), ADD UNIQUE KEY `playerid` (`playerid`), ADD KEY `name` (`name`), ADD KEY `blacklist` (`blacklist`);
170
171--
172-- Indexes for table `vehicles`
173--
174ALTER TABLE `vehicles`
175 ADD PRIMARY KEY (`id`), ADD KEY `side` (`side`), ADD KEY `pid` (`pid`), ADD KEY `type` (`type`);
176
177--
178-- AUTO_INCREMENT for dumped tables
179--
180
181--
182-- AUTO_INCREMENT for table `gangs`
183--
184ALTER TABLE `gangs`
185MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
186--
187-- AUTO_INCREMENT for table `houses`
188--
189ALTER TABLE `houses`
190MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
191--
192-- AUTO_INCREMENT for table `players`
193--
194ALTER TABLE `players`
195MODIFY `uid` int(12) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=41;
196--
197-- AUTO_INCREMENT for table `vehicles`
198--
199ALTER TABLE `vehicles`
200MODIFY `id` int(12) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=34;
201/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
202/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
203/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;