UeYt03Vq

1SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
2SET time_zone = "+00:00";
3
4DELIMITER $$
5CREATE PROCEDURE `deleteEconomyPrices`()
6TRUNCATE `economy`$$
7
8
9CREATE PROCEDURE `deleteOldGangs`()
10DELETE FROM `gangs` WHERE `active` = 0$$
11CREATE PROCEDURE `resetLifeVehicles`()
12UPDATE vehicles SET `active`= 0;$$
13CREATE PROCEDURE `deleteDeadVehicles`()
14DELETE FROM `vehicles` WHERE `alive` = 0;$$
15CREATE PROCEDURE `deleteOldMessages`()
16TRUNCATE TABLE `messages`$$
17CREATE PROCEDURE `deleteOldHouses`()
18DELETE FROM `houses` WHERE `owned` = 0$$
19
20CREATE PROCEDURE `setEconomyPrices`()
21    NO SQL
22INSERT INTO `economy` (`numero`, `ressource`, `sellprice`, `buyprice`, `varprice`, `minprice`, `maxprice`, `factor`, `shoptype`) VALUES
23(1, 'apple', 50, 65, 1, 1, 60, '1', 'market'),
24(2, 'heroinu', 2250, 0, 5, 1, 4000, '0', 'heroin'),
25(3, 'heroinp', 4500, 0, 10, 1, 5000, '2', 'heroin'),
26(4, 'salema', 45, 55, 1, 1, 100, '4', 'fishmarket'),
27(5, 'ornate', 40, 50, 1, 1, 100, '4', 'fishmarket'),
28(6, 'mackerel', 175, 200, 1, 1, 1000, '4', 'fishmarket'),
29(7, 'tuna', 700, 900, 1, 1, 2000, '4', 'fishmarket'),
30(8, 'mullet', 250, 300, 1, 1, 1000, '4', 'fishmarket'),
31(9, 'catshark', 300, 350, 1, 1, 1000, '4', 'fishmarket'),
32(10, 'rabbit', 65, 75, 1, 1, 500, '0', 'market'),
33(11, 'oilp', 2250, 0, 2, 1, 3500, '3', 'oil'),
34(12, 'turtle', 5750, 15000, 10, 1, 8000, '0', 'wongs'),
35(13, 'water', 0, 10, 0, 1, 25, '0', 'market'),
36(14, 'coffee', 0, 10, 0, 1, 75, '0', 'cop'),
37(15, 'turtlesoup', 4500, 15000, 0, 1, 5000, '0', 'wongs'),
38(16, 'donuts', 0, 10, 0, 1, 200, '0', 'cop'),
39(17, 'marijuana', 3000, 0, 10, 1, 6000, '2', 'heroin'),
40(18, 'tbacon', 25, 75, 0, 1, 75, '0', 'market'),
41(19, 'lockpick', 750, 4000, 0, 1, 4100, '0', 'market'),
42(20, 'redgull', 750, 1000, 0, 1, 1200, '0', 'market'),
43(21, 'peach', 65, 70, 1, 1, 100, '1', 'market'),
44(22, 'cocaine', 2500, 0, 5, 1, 4500, '0', 'heroin'),
45(23, 'cocainep', 5000, 0, 10, 1, 8000, '2', 'heroin'),
46(24, 'diamond', 1500, 0, 3, 1, 2000, '3', 'diamond'),
47(25, 'diamondc', 3000, 0, 3, 1, 6000, '3', 'diamond'),
48(26, 'iron_r', 1500, 0, 3, 1, 3000, '3', 'iron'),
49(27, 'copper_r', 1000, 0, 3, 1, 1500, '3', 'iron'),
50(28, 'salt_r', 2500, 0, 3, 1, 5000, '3', 'salt'),
51(29, 'glass', 1500, 0, 3, 1, 3000, '3', 'glass'),
52(30, 'fuelF', 10, 500, 0, 1, 1500, '0', 'market'),
53(31, 'spikeStrip', 0, 10, 0, 1, 2000, '0', 'cop'),
54(32, 'cement', 1000, 0, 3, 1, 8000, '3', 'cement'),
55(33, 'goldbar', 90000, 0, 0, 1, 180000, '0', 'goldbar'),
56(34, 'blastingcharge', 10000, 50000, 0, 1, 50000, '0', 'market'),
57(35, 'boltcutter', 5000, 8000, 0, 1, 5000, '0', 'market'),
58(36, 'defusekit', 0, 10, 0, 1, 2500, '0', 'cop'),
59(37, 'storagesmall', 10, 125000, 0, 1, 10, '0', 'market'),
60(38, 'storagebig', 10, 250000, 0, 1, 10, '0', 'market'),
61(39, 'pickaxe', 700, 1200, 0, 1, 750, '0', 'market'),
62(40, 'methu', 1875, 3750, 5, 1, 3600, '2', 'heroin'),
63(41, 'methp', 3750, 0, 10, 1, 6500, '2', 'heroin'),
64(42, 'bottledwhiskey', 5500, 3750, 5, 1, 6000, '2', 'speakeasy'),
65(43, 'bottledbeer', 750, 1250, 5, 1, 1450, '2', 'speakeasy'),
66(44, 'whiskey', 1250, 5500, 4, 1, 2500, '2', 'speakeasy'),
67(45, 'wine', 1000, 4000, 2, 1, 4500, '2', 'beer'),
68(46, 'grapes', 70, 95, 2, 1, 140, '2', 'market'),
69(47, 'battery', 50, 100, 0, 1, 100, '2', 'market'),
70(48, 'painkillers', 250, 500, 0, 1, 500, '2', 'pharmacy'),
71(49, 'mash', 500, 2500, 1, 1, 1500, '2', 'bar'),
72(50, 'rye', 2000, 0, 2, 1, 3500, '2', 'bar'),
73(51, 'morphium', 100, 1500, 0, 1, 1500, '2', 'pharmacy'),
74(52, 'yeast', 2000, 0, 2, 1, 3500, '2', 'pharmacy'),
75(53, 'cornmeal', 200, 500, 2, 1, 750, '2', 'bar'),
76(54, 'bottles', 50, 100, 1, 1, 100, '2', 'bar'),
77(55, 'uranium', 10000, 0, 8, 1, 12500, '2', 'uranium'),
78(56, 'kidney', 9000, 15000, 0, 1, 16750, '2', 'pharmacy'),
79(57, 'scalpel', 1000, 7500, 0, 1, 7500, '2', 'pharmacy'),
80(58, 'beerp', 550, 3750, 3, 1, 1500, '2', 'speakeasy'),
81(59, 'mauer', 5, 10, 0, 1, 10, '2', 'cop'),
82(60, 'zipties', 5, 500, 0, 1, 500, '2', 'market'),
83(61, 'puranium', 250, 1000, 0, 1, 1000, '2', 'uranium'),
84(62, 'ipuranium', 3500, 9000, 0, 1, 9000, '2', 'uranium')$$
85DELIMITER ;
86
87--
88-- Table structure for table `players`
89--
90
91CREATE TABLE IF NOT EXISTS `players` (
92  `uid` int(12) NOT NULL AUTO_INCREMENT,
93  `name` varchar(32) NOT NULL,
94  `playerid` varchar(50) NOT NULL,
95  `cash` int(100) NOT NULL DEFAULT '0',
96  `bankacc` int(100) NOT NULL DEFAULT '0',
97  `coplevel` enum('0','1','2','3','4','5','6') NOT NULL DEFAULT '0',
98  `cop_licenses` text,
99  `civ_licenses` text,
100  `med_licenses` text,
101  `cop_gear` text NOT NULL,
102  `med_gear` text NOT NULL,
103  `mediclevel` enum('0','1','2') NOT NULL DEFAULT '0',
104  `arrested` tinyint(1) NOT NULL DEFAULT '0',
105  `aliases` text NOT NULL,
106  `adminlevel` enum('0','1','2','3') NOT NULL DEFAULT '0',
107  `donatorlvl` enum('0','1','2','3') NOT NULL DEFAULT '0',
108  `civ_gear` text NOT NULL,
109  `blacklist` tinyint(1) NOT NULL DEFAULT '0',
110  `jail_time` int(11) NOT NULL DEFAULT '0',
111  PRIMARY KEY (`uid`),
112  UNIQUE KEY `playerid` (`playerid`),
113  KEY `name` (`name`),
114  KEY `blacklist` (`blacklist`)
115) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=12 ;
116
117-- --------------------------------------------------------
118
119--
120-- Table structure for table `vehicles`
121--
122
123CREATE TABLE IF NOT EXISTS `vehicles` (
124  `id` int(12) NOT NULL AUTO_INCREMENT,
125  `side` varchar(15) NOT NULL,
126  `classname` varchar(32) NOT NULL,
127  `type` varchar(12) NOT NULL,
128  `pid` varchar(32) NOT NULL,
129  `alive` tinyint(1) NOT NULL DEFAULT '1',
130  `active` tinyint(1) NOT NULL DEFAULT '0',
131  `plate` int(20) NOT NULL,
132  `color` int(20) NOT NULL,
133  `inventory` varchar(500) NOT NULL,
134  PRIMARY KEY (`id`),
135  KEY `side` (`side`),
136  KEY `pid` (`pid`),
137  KEY `type` (`type`)
138) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
139
140-- --------------------------------------------------------
141
142--
143-- Table structure for table `economy`
144--
145
146
147CREATE TABLE IF NOT EXISTS `economy` (
148  `numero` int(12) NOT NULL,
149  `ressource` varchar(32) NOT NULL,
150  `sellprice` int(100) NOT NULL DEFAULT '0',
151  `buyprice` int(100) NOT NULL DEFAULT '0',
152  `varprice` int(100) NOT NULL,
153  `minprice` int(100) NOT NULL,
154  `maxprice` int(100) NOT NULL,
155  `factor` enum('0','1','2','3','4','5','6','7') NOT NULL DEFAULT '0',
156  `shoptype` text NOT NULL,
157  PRIMARY KEY (`numero`)
158) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=63 ;
159
160
161-- --------------------------------------------------------
162
163
164--
165-- Daten für Tabelle `economy`
166--
167
168INSERT INTO `economy` (`numero`, `ressource`, `sellprice`, `buyprice`, `varprice`, `minprice`, `maxprice`, `factor`, `shoptype`) VALUES
169(1, 'apple', 50, 65, 1, 1, 60, '1', 'market'),
170(2, 'heroinu', 2250, 0, 5, 1, 4000, '0', 'heroin'),
171(3, 'heroinp', 4500, 0, 10, 1, 5000, '2', 'heroin'),
172(4, 'salema', 45, 55, 1, 1, 100, '4', 'fishmarket'),
173(5, 'ornate', 40, 50, 1, 1, 100, '4', 'fishmarket'),
174(6, 'mackerel', 175, 200, 1, 1, 1000, '4', 'fishmarket'),
175(7, 'tuna', 700, 900, 1, 1, 2000, '4', 'fishmarket'),
176(8, 'mullet', 250, 300, 1, 1, 1000, '4', 'fishmarket'),
177(9, 'catshark', 300, 350, 1, 1, 1000, '4', 'fishmarket'),
178(10, 'rabbit', 65, 75, 1, 1, 500, '0', 'market'),
179(11, 'oilp', 2250, 0, 2, 1, 3500, '3', 'oil'),
180(12, 'turtle', 5750, 15000, 10, 1, 8000, '0', 'wongs'),
181(13, 'water', 0, 10, 0, 1, 25, '0', 'market'),
182(14, 'coffee', 0, 10, 0, 1, 75, '0', 'cop'),
183(15, 'turtlesoup', 4500, 15000, 0, 1, 5000, '0', 'wongs'),
184(16, 'donuts', 0, 10, 0, 1, 200, '0', 'cop'),
185(17, 'marijuana', 3000, 0, 10, 1, 6000, '2', 'heroin'),
186(18, 'tbacon', 25, 75, 0, 1, 75, '0', 'market'),
187(19, 'lockpick', 750, 4000, 0, 1, 4100, '0', 'market'),
188(20, 'redgull', 750, 1000, 0, 1, 1200, '0', 'market'),
189(21, 'peach', 65, 70, 1, 1, 100, '1', 'market'),
190(22, 'cocaine', 2500, 0, 5, 1, 4500, '0', 'heroin'),
191(23, 'cocainep', 5000, 0, 10, 1, 8000, '2', 'heroin'),
192(24, 'diamond', 1500, 0, 3, 1, 2000, '3', 'diamond'),
193(25, 'diamondc', 3000, 0, 3, 1, 6000, '3', 'diamond'),
194(26, 'iron_r', 1500, 0, 3, 1, 3000, '3', 'iron'),
195(27, 'copper_r', 1000, 0, 3, 1, 1500, '3', 'iron'),
196(28, 'salt_r', 2500, 0, 3, 1, 5000, '3', 'salt'),
197(29, 'glass', 1500, 0, 3, 1, 3000, '3', 'glass'),
198(30, 'fuelF', 10, 500, 0, 1, 1500, '0', 'market'),
199(31, 'spikeStrip', 0, 10, 0, 1, 2000, '0', 'cop'),
200(32, 'cement', 1000, 0, 3, 1, 8000, '3', 'cement'),
201(33, 'goldbar', 90000, 0, 0, 1, 180000, '0', 'goldbar'),
202(34, 'blastingcharge', 10000, 50000, 0, 1, 50000, '0', 'market'),
203(35, 'boltcutter', 5000, 8000, 0, 1, 5000, '0', 'market'),
204(36, 'defusekit', 0, 10, 0, 1, 2500, '0', 'cop'),
205(37, 'storagesmall', 10, 125000, 0, 1, 10, '0', 'market'),
206(38, 'storagebig', 10, 250000, 0, 1, 10, '0', 'market'),
207(39, 'pickaxe', 700, 1200, 0, 1, 750, '0', 'market'),
208(40, 'methu', 1875, 3750, 5, 1, 3600, '2', 'heroin'),
209(41, 'methp', 3750, 0, 10, 1, 6500, '2', 'heroin'),
210(42, 'bottledwhiskey', 5500, 3750, 5, 1, 6000, '2', 'speakeasy'),
211(43, 'bottledbeer', 750, 1250, 5, 1, 1450, '2', 'speakeasy'),
212(44, 'whiskey', 1250, 5500, 4, 1, 2500, '2', 'speakeasy'),
213(45, 'wine', 1000, 4000, 2, 1, 4500, '2', 'beer'),
214(46, 'grapes', 70, 95, 2, 1, 140, '2', 'market'),
215(47, 'battery', 50, 100, 0, 1, 100, '2', 'market'),
216(48, 'painkillers', 250, 500, 0, 1, 500, '2', 'pharmacy'),
217(49, 'mash', 500, 2500, 1, 1, 1500, '2', 'bar'),
218(50, 'rye', 2000, 0, 2, 1, 3500, '2', 'bar'),
219(51, 'morphium', 100, 1500, 0, 1, 1500, '2', 'pharmacy'),
220(52, 'yeast', 2000, 0, 2, 1, 3500, '2', 'pharmacy'),
221(53, 'cornmeal', 200, 500, 2, 1, 750, '2', 'bar'),
222(54, 'bottles', 50, 100, 1, 1, 100, '2', 'bar'),
223(55, 'uranium', 10000, 0, 8, 1, 12500, '2', 'uranium'),
224(56, 'kidney', 9000, 15000, 0, 1, 16750, '2', 'pharmacy'),
225(57, 'scalpel', 1000, 7500, 0, 1, 7500, '2', 'pharmacy'),
226(58, 'beerp', 550, 3750, 3, 1, 1500, '2', 'speakeasy'),
227(59, 'mauer', 5, 10, 0, 1, 10, '2', 'cop'),
228(60, 'zipties', 5, 500, 0, 1, 500, '2', 'market'),
229(61, 'puranium', 250, 1000, 0, 1, 1000, '2', 'uranium'),
230(62, 'ipuranium', 3500, 9000, 0, 1, 9000, '2', 'uranium');
231
232
233--
234-- Table structure for table `houses`
235-- Needed for extDB latest update on git
236--
237
238CREATE TABLE IF NOT EXISTS `houses` (
239  `id` int(11) NOT NULL AUTO_INCREMENT,
240  `pid` varchar(32) NOT NULL,
241  `pos` varchar(64) DEFAULT NULL,
242  `inventory` text,
243  `containers` text,
244  `owned` tinyint(4) DEFAULT '0',
245  PRIMARY KEY (`id`,`pid`)
246) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;
247
248-- --------------------------------------------------------
249
250--
251-- Table structure for table `gangs`
252-- Needed for extDB latest update on git
253--
254
255CREATE TABLE IF NOT EXISTS `gangs` (
256  `id` int(11) NOT NULL AUTO_INCREMENT,
257  `owner` varchar(32) DEFAULT NULL,
258  `name` varchar(32) DEFAULT NULL,
259  `members` text,
260  `maxmembers` int(2) DEFAULT '8',
261  `bank` int(100) DEFAULT '0',
262  `active` tinyint(4) DEFAULT '1',
263  PRIMARY KEY (`id`),
264  UNIQUE KEY `name_UNIQUE` (`name`)
265) ENGINE=InnoDB DEFAULT CHARSET=latin1;
266
267
268-- --------------------------------------------------------
269
270
271--
272-- Table structure for table `messages`
273-- Needed for extDB latest update on git
274--
275CREATE TABLE IF NOT EXISTS `messages` (
276  `uid` int(12) NOT NULL AUTO_INCREMENT,
277  `fromID` varchar(50) NOT NULL,
278  `toID` varchar(50) NOT NULL,
279  `message` text,
280  `fromName` varchar(32) NOT NULL,
281  `toName` varchar(32) NOT NULL,
282  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
283  PRIMARY KEY (`uid`)
284) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=13 ;