· 10 years ago · Feb 25, 2016, 06:21 PM
1-- phpMyAdmin SQL Dump
2-- version 3.4.11.1deb2+deb7u1
3-- http://www.phpmyadmin.net
4--
5-- Hoszt: localhost
6-- Létrehozás ideje: 2015. márc. 16. 05:38
7-- Szerver verzió: 5.5.40
8-- PHP verzió: 5.4.36-0+deb7u3
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-- Adatbázis: `BestLifeMTA1`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Tábla szerkezet: `3dtext`
27--
28
29CREATE TABLE IF NOT EXISTS `3dtext` (
30 `textID` int(10) unsigned NOT NULL AUTO_INCREMENT,
31 `text` text NOT NULL,
32 `x` float NOT NULL,
33 `y` float NOT NULL,
34 `z` float NOT NULL,
35 `interior` tinyint(3) unsigned NOT NULL,
36 `dimension` int(10) unsigned NOT NULL,
37 PRIMARY KEY (`textID`)
38) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
39
40-- --------------------------------------------------------
41
42--
43-- Tábla szerkezet: `accounts`
44--
45
46CREATE TABLE IF NOT EXISTS `accounts` (
47 `id` int(22) NOT NULL AUTO_INCREMENT,
48 `username` varchar(255) NOT NULL,
49 `loginhash` varchar(255) NOT NULL,
50 `password` varchar(70) NOT NULL,
51 `email` varchar(40) DEFAULT NULL,
52 `country` varchar(40) DEFAULT NULL,
53 `friendsmessage` mediumtext,
54 `mtausername` varchar(40) DEFAULT NULL,
55 `adminnote` mediumtext,
56 `warns` int(5) NOT NULL DEFAULT '0',
57 `muted` tinyint(1) NOT NULL DEFAULT '0',
58 `appstate` tinyint(3) DEFAULT NULL,
59 `apphandler` varchar(40) DEFAULT NULL,
60 `banned` tinyint(3) NOT NULL DEFAULT '0',
61 `banned_reason` mediumint(9) DEFAULT NULL,
62 `banned_by` varchar(40) DEFAULT NULL,
63 `ip` varchar(15) DEFAULT NULL,
64 `admin` int(5) DEFAULT '0',
65 `adminduty` tinyint(3) DEFAULT '0',
66 `adminjail` tinyint(4) DEFAULT '0',
67 `adminjail_time` int(5) DEFAULT '0',
68 `adminjail_permanent` tinyint(5) DEFAULT '0',
69 `adminjail_by` varchar(40) DEFAULT NULL,
70 `adminjail_reason` mediumtext,
71 `donator` tinyint(3) DEFAULT '0',
72 `lastlogin` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
73 `mtaserial` varchar(32) DEFAULT NULL,
74 `globalooc` tinyint(4) DEFAULT '1',
75 `hiddenadmin` tinyint(3) DEFAULT '0',
76 `serial` varchar(50) NOT NULL DEFAULT '0',
77 `adminreports` int(35) NOT NULL DEFAULT '0',
78 `chatbubbles` tinyint(4) NOT NULL DEFAULT '1',
79 `pmblocked` int(11) NOT NULL DEFAULT '0',
80 `adblocked` int(11) NOT NULL DEFAULT '0',
81 `newsblocked` int(11) NOT NULL DEFAULT '0',
82 `donatorchat` int(11) NOT NULL DEFAULT '1',
83 `master` tinyint(3) NOT NULL DEFAULT '0',
84 `masterduty` tinyint(4) NOT NULL DEFAULT '0',
85 `ucplogged` int(3) NOT NULL,
86 `vip` int(11) NOT NULL DEFAULT '0',
87 `vipend` datetime NOT NULL,
88 `jarmu` enum('igen','nem') NOT NULL DEFAULT 'nem',
89 PRIMARY KEY (`id`)
90) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=13 ;
91
92--
93-- A tábla adatainak kiÃratása `accounts`
94--
95
96INSERT INTO `accounts` (`id`, `username`, `loginhash`, `password`, `email`, `country`, `friendsmessage`, `mtausername`, `adminnote`, `warns`, `muted`, `appstate`, `apphandler`, `banned`, `banned_reason`, `banned_by`, `ip`, `admin`, `adminduty`, `adminjail`, `adminjail_time`, `adminjail_permanent`, `adminjail_by`, `adminjail_reason`, `donator`, `lastlogin`, `mtaserial`, `globalooc`, `hiddenadmin`, `serial`, `adminreports`, `chatbubbles`, `pmblocked`, `adblocked`, `newsblocked`, `donatorchat`, `master`, `masterduty`, `ucplogged`, `vip`, `vipend`, `jarmu`) VALUES
97(1, 'Exmine', '0C8B7BBBA8EE3C14E32708CC6B44C062E0027DDA6C24B5A8795F5305A5B57A36', '42D41CBD57CB8AD011346CEDF5087123', NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, NULL, NULL, '89.132.38.42', 11, 1, 0, 0, 0, NULL, NULL, 0, '2014-07-24 12:15:55', 'F03EB1845DF533E0ADEF6DAED42464A1', 1, 0, '0', 0, 1, 0, 0, 0, 1, 0, 0, 0, 0, '0000-00-00 00:00:00', 'nem'),
98(2, 'Reaper', '5A99D6D1B74ACBA7BBAF7DBF991F28F6079374E9C891624D8CFC0F79EF209987', '1E0F288600E13565A200E4FAEA994103', NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, NULL, NULL, '84.225.197.249', 11, 1, 0, 0, 0, NULL, NULL, 0, '2014-07-24 22:31:51', 'C5AFAA1404B345D70A9EA8B1B6C242E4', 1, 0, '0', 0, 1, 0, 0, 0, 1, 0, 0, 0, 0, '0000-00-00 00:00:00', 'nem'),
99(3, 'vakika', 'F1D0A3BA6E9E39A0B5F8729E4C23EDA90E2036BFD9C17AFAD921D227917A74C9', 'BCC2BD847099A89AD312AFADFEA930D1', NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, NULL, NULL, '84.3.225.241', 9, 1, 0, 0, 0, NULL, NULL, 0, '2014-07-23 17:27:23', '3BD08363188D7D46B4D38AFC64BF2133', 1, 0, '0', 0, 1, 0, 0, 0, 1, 0, 0, 0, 0, '0000-00-00 00:00:00', 'nem'),
100(4, 'Acs95', '04F618D87D36F178D2BAC9B3E806712E8D925D7647849C1F9A3C3B501B830BBE', '2093B60F091C449CF28E3B0BB029F5C6', NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, NULL, NULL, '89.134.188.159', 0, 0, 0, 0, 0, NULL, NULL, 0, '2014-07-24 12:16:22', '9269B5A3759D17D776A24F2E58B88FF4', 1, 0, '0', 0, 1, 0, 0, 0, 1, 0, 0, 0, 0, '0000-00-00 00:00:00', 'nem'),
101(8, 'Leonka', 'D9906BFF7757BD66331DA25144670029C1D399C5815297546A381A658936C1CB', '1FAEC06C5B9FD5F9D2AE772DC54C2E24', 'hoattila2000@gmail.com', NULL, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, NULL, NULL, NULL, 10, 0, 0, 0, 0, NULL, NULL, 0, '2015-03-15 18:09:31', NULL, 1, 0, '0', 0, 1, 0, 0, 0, 1, 0, 0, 0, 0, '0000-00-00 00:00:00', 'nem'),
102(9, 'George Spencer', '851B9CAF78677828E93423D906D083BC4B48703056FB10EA601F2A15C985ED02', '4558BE5993D873A696FA2D42C48418A8', 'asd.asd@asd.hu', NULL, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, NULL, NULL, NULL, 10, 0, 0, 0, 0, NULL, NULL, 0, '2015-03-15 17:40:41', NULL, 1, 0, '0', 0, 1, 0, 0, 0, 1, 0, 0, 0, 0, '0000-00-00 00:00:00', 'nem'),
103(10, 'dakher', 'DB2DD09C8C6878524FCD96F8BACC6F43C84DCE6233FAE34966548FD53BE1D637', 'DDAB294E1494F64F387C30D6E0D0BC8D', 'dakher2@gmail.com', NULL, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, NULL, NULL, NULL, 9, 0, 0, 0, 0, NULL, NULL, 0, '2015-03-15 18:09:29', NULL, 1, 0, '0', 0, 1, 0, 0, 0, 1, 0, 0, 0, 0, '0000-00-00 00:00:00', 'nem'),
104(11, 'Carlos', 'F67A2C681B8A00DB1D59C861F2CF7749AEF9E31C60E23EC52AA2FFBBB90FF965', 'CC55CE9361B7C2545535266CE2DB6E42', 'egyrpsgammer@gmail.com', NULL, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, NULL, NULL, NULL, 12, 0, 0, 0, 0, NULL, NULL, 0, '2015-03-15 21:39:06', NULL, 1, 0, '0', 0, 1, 0, 0, 0, 1, 0, 0, 0, 0, '0000-00-00 00:00:00', 'nem'),
105(12, 'Carlos12', 'F1EE1A62330E19948B9E8B6C9FD53603', 'F1EE1A62330E19948B9E8B6C9FD53603', 'egyrpsgammer@gmail.com', NULL, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, NULL, NULL, NULL, 12, 0, 0, 0, 0, NULL, NULL, 0, '2015-03-15 20:02:40', NULL, 1, 0, '0', 0, 1, 0, 0, 0, 1, 0, 0, 0, 0, '0000-00-00 00:00:00', 'nem');
106
107-- --------------------------------------------------------
108
109--
110-- Tábla szerkezet: `achievements`
111--
112
113CREATE TABLE IF NOT EXISTS `achievements` (
114 `id` int(11) NOT NULL AUTO_INCREMENT,
115 `date` varchar(10) DEFAULT NULL,
116 `achievementid` int(11) DEFAULT NULL,
117 `account` int(11) DEFAULT NULL,
118 PRIMARY KEY (`id`)
119) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
120
121-- --------------------------------------------------------
122
123--
124-- Tábla szerkezet: `atms`
125--
126
127CREATE TABLE IF NOT EXISTS `atms` (
128 `id` int(10) NOT NULL AUTO_INCREMENT,
129 `x` float DEFAULT NULL,
130 `y` float DEFAULT NULL,
131 `z` float DEFAULT NULL,
132 `dimension` int(11) DEFAULT NULL,
133 `interior` int(11) DEFAULT NULL,
134 `rotation` float DEFAULT NULL,
135 `deposit` int(11) DEFAULT '0',
136 `limit` int(11) DEFAULT '5000',
137 PRIMARY KEY (`id`)
138) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
139
140-- --------------------------------------------------------
141
142--
143-- Tábla szerkezet: `bans`
144--
145
146CREATE TABLE IF NOT EXISTS `bans` (
147 `id` int(11) NOT NULL AUTO_INCREMENT,
148 `accountid` int(11) NOT NULL,
149 `serial` varchar(32) NOT NULL,
150 `ip` text NOT NULL,
151 `charactername` varchar(100) NOT NULL,
152 `accountname` varchar(100) NOT NULL,
153 `end` datetime NOT NULL,
154 `reason` varchar(500) NOT NULL,
155 `bannolta` varchar(500) NOT NULL,
156 PRIMARY KEY (`id`)
157) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
158
159-- --------------------------------------------------------
160
161--
162-- Tábla szerkezet: `bemutatkoz`
163--
164
165CREATE TABLE IF NOT EXISTS `bemutatkoz` (
166 `ki` int(11) NOT NULL,
167 `kit` int(11) NOT NULL
168) ENGINE=InnoDB DEFAULT CHARSET=latin1;
169
170-- --------------------------------------------------------
171
172--
173-- Tábla szerkezet: `cellphones`
174--
175
176CREATE TABLE IF NOT EXISTS `cellphones` (
177 `id` int(11) NOT NULL AUTO_INCREMENT,
178 `owner` int(11) NOT NULL,
179 `contracttype` int(11) NOT NULL,
180 `active` int(11) NOT NULL,
181 `itemValue` int(11) NOT NULL,
182 `notepad` text NOT NULL,
183 PRIMARY KEY (`id`)
184) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
185
186-- --------------------------------------------------------
187
188--
189-- Tábla szerkezet: `characters`
190--
191
192CREATE TABLE IF NOT EXISTS `characters` (
193 `charactername` varchar(40) NOT NULL,
194 `id` int(11) NOT NULL AUTO_INCREMENT,
195 `x` float NOT NULL DEFAULT '0',
196 `y` float NOT NULL DEFAULT '0',
197 `z` float NOT NULL DEFAULT '100',
198 `faction_id` int(11) DEFAULT '-1',
199 `transport` int(11) DEFAULT '1',
200 `gender` int(11) DEFAULT '1',
201 `skincolor` int(11) DEFAULT '1',
202 `weight` varchar(22) DEFAULT '70',
203 `height` varchar(22) DEFAULT '170',
204 `muscles` int(11) DEFAULT '70',
205 `fat` int(11) DEFAULT '10',
206 `description` mediumtext,
207 `account` int(11) NOT NULL,
208 `skin` int(11) NOT NULL,
209 `lastarea` varchar(255) DEFAULT NULL,
210 `age` varchar(22) DEFAULT NULL,
211 `fingerprint` varchar(255) DEFAULT NULL,
212 `lang1` int(11) DEFAULT NULL,
213 `lang2` int(11) DEFAULT NULL,
214 `lang3` int(11) DEFAULT NULL,
215 `lang1skill` int(11) DEFAULT NULL,
216 `lang2skill` int(11) DEFAULT NULL,
217 `lang3skill` int(11) DEFAULT NULL,
218 `money` bigint(20) NOT NULL DEFAULT '80000',
219 `cked` int(11) DEFAULT '0',
220 `currlang` int(11) DEFAULT NULL,
221 `ck_info` mediumtext,
222 `faction_rank` int(11) DEFAULT '0',
223 `fightstyle` int(10) DEFAULT '0',
224 `casualskin` int(11) DEFAULT '0',
225 `cuffed` int(11) DEFAULT '0',
226 `restrainedby` int(11) DEFAULT '0',
227 `restrainedobj` int(11) DEFAULT '0',
228 `blindfold` int(11) NOT NULL DEFAULT '0',
229 `faction_leader` int(11) DEFAULT '0',
230 `weapons` varchar(255) DEFAULT NULL,
231 `ammo` varchar(255) DEFAULT NULL,
232 `bankmoney` bigint(20) DEFAULT '120000',
233 `radiochannel` float DEFAULT '100',
234 `car_license` tinyint(3) DEFAULT '0',
235 `gun_license` tinyint(3) DEFAULT '0',
236 `interior_id` int(11) DEFAULT '0',
237 `dimension_id` int(11) DEFAULT '0',
238 `health` int(11) DEFAULT '100',
239 `armor` int(11) DEFAULT '0',
240 `hoursplayed` int(11) DEFAULT '0',
241 `timeinserver` int(11) DEFAULT '0',
242 `phoneoff` tinyint(3) DEFAULT '0',
243 `truckingwage` int(11) DEFAULT '0',
244 `truckingruns` int(11) DEFAULT '0',
245 `fish` int(11) DEFAULT '0',
246 `rook` int(11) DEFAULT '0',
247 `tyrese` int(11) DEFAULT '0',
248 `stevie` int(11) DEFAULT '0',
249 `hunter` int(11) DEFAULT '0',
250 `pdjail` int(11) DEFAULT '0',
251 `pdjail_time` int(11) DEFAULT '0',
252 `marriedto` int(11) DEFAULT '0',
253 `maxvehicles` int(11) DEFAULT '2',
254 `lastlogin` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
255 `rotation` float DEFAULT '0',
256 `cellnumber` bigint(20) DEFAULT NULL,
257 `dutyskin` int(11) DEFAULT '0',
258 `duty` tinyint(3) DEFAULT '0',
259 `job` int(5) DEFAULT '0',
260 `jobcontract` int(5) DEFAULT '0',
261 `photos` int(20) DEFAULT '0',
262 `deaths` int(11) NOT NULL DEFAULT '0',
263 `pdjail_station` int(11) NOT NULL DEFAULT '-1',
264 `tag` tinyint(4) NOT NULL DEFAULT '0',
265 `dolgozott` enum('igen','nem') NOT NULL DEFAULT 'nem',
266 `fuvarok` int(11) NOT NULL DEFAULT '0',
267 `drog` int(11) NOT NULL DEFAULT '0',
268 `lastdrog` datetime NOT NULL,
269 `edrog` int(11) NOT NULL DEFAULT '0',
270 `ehseg` int(11) NOT NULL DEFAULT '0',
271 `almossag` int(11) NOT NULL DEFAULT '0',
272 `korhaz` enum('0','1') NOT NULL DEFAULT '0',
273 `maxhaz` int(11) NOT NULL,
274 `mskill` int(11) NOT NULL DEFAULT '0',
275 `fskill` int(11) NOT NULL DEFAULT '0',
276 `anick` varchar(20) NOT NULL,
277 `walkingstyle` int(11) NOT NULL DEFAULT '0',
278 PRIMARY KEY (`id`)
279) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=12 ;
280
281--
282-- A tábla adatainak kiÃratása `characters`
283--
284
285INSERT INTO `characters` (`charactername`, `id`, `x`, `y`, `z`, `faction_id`, `transport`, `gender`, `skincolor`, `weight`, `height`, `muscles`, `fat`, `description`, `account`, `skin`, `lastarea`, `age`, `fingerprint`, `lang1`, `lang2`, `lang3`, `lang1skill`, `lang2skill`, `lang3skill`, `money`, `cked`, `currlang`, `ck_info`, `faction_rank`, `fightstyle`, `casualskin`, `cuffed`, `restrainedby`, `restrainedobj`, `blindfold`, `faction_leader`, `weapons`, `ammo`, `bankmoney`, `radiochannel`, `car_license`, `gun_license`, `interior_id`, `dimension_id`, `health`, `armor`, `hoursplayed`, `timeinserver`, `phoneoff`, `truckingwage`, `truckingruns`, `fish`, `rook`, `tyrese`, `stevie`, `hunter`, `pdjail`, `pdjail_time`, `marriedto`, `maxvehicles`, `lastlogin`, `rotation`, `cellnumber`, `dutyskin`, `duty`, `job`, `jobcontract`, `photos`, `deaths`, `pdjail_station`, `tag`, `dolgozott`, `fuvarok`, `drog`, `lastdrog`, `edrog`, `ehseg`, `almossag`, `korhaz`, `maxhaz`, `mskill`, `fskill`, `anick`, `walkingstyle`) VALUES
286('Zack_Davis', 1, 2131.23, -1149.4, 24.2652, -1, 0, 0, 1, '91', '196', 0, 0, 'Izmos, sármos, magas, fiatal, aki élvezi az élet szép dolgait\n', 1, 23, 'Jefferson', '28', '9C9068DEF561747354975E380C479BCA', 1, NULL, NULL, 100, NULL, NULL, 2775652175, 0, 1, NULL, 0, 0, 0, 0, 0, 0, 0, 0, '', '', 120000, 100, 0, 0, 0, 0, 100, 100, 0, 680, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2, '2014-07-24 13:41:18', 168.75, 15001, 0, 0, 0, 0, 0, 1, -1, 0, 'nem', 0, 0, '0000-00-00 00:00:00', 0, 8, 0, '0', 0, 0, 0, 'Davis', 122),
287('Winkle_Austin', 2, 2121.15, -1146.78, 25.8169, -1, 0, 0, 1, '65', '190', 0, 0, 'Egy fehér,jóképü,izmos ember!\n', 2, 23, 'Jefferson', '26', 'CEC9B8E2A11E59F4714020DFE72350A1', 1, NULL, NULL, 100, NULL, NULL, 99038347836, 0, 1, NULL, 0, 0, 0, 0, 0, 0, 0, 0, '', '', 120000, 100, 0, 0, 0, 0, 100, 0, 0, 185, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2, '2014-07-24 23:08:15', 254.153, 15002, 0, 0, 0, 0, 0, 0, -1, 0, 'nem', 0, 0, '0000-00-00 00:00:00', 0, 13, 0, '0', 0, 0, 0, 'nil', 0),
288('Lakatos_Nintendo', 3, 1815.44, -1629.54, 13.3649, -1, 0, 0, 1, '95', '182', 0, 0, 'Egy kan cigány aki szereti zolikát\n', 3, 1, 'Idlewood', '32', 'F24F3477F5111C16A48B254195B5F225', 1, NULL, NULL, 100, NULL, NULL, 9999966956521, 0, 1, NULL, 0, 0, 0, 0, 0, 0, 0, 0, '', '', 120000, 100, 0, 0, 0, 0, 88, 0, 0, 22, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2, '2014-07-23 17:50:03', 126.963, 15003, 0, 0, 0, 0, 0, 0, -1, 0, 'nem', 0, 0, '0000-00-00 00:00:00', 0, -120, 0, '0', 0, 0, 0, '', 0),
289('Raymond_Calitri', 4, 1696.06, -1156.03, 23.4599, -1, 0, 0, 1, '85', '180', 0, 0, 'Egy igazi fasza gyerek aki igazi autó szakértö akinek mindene a fa és a várósban csak ÃÂcs.\n', 4, 170, 'Downtown Los Santos', '28', '76F8105D41D7E34581637C41650A01FE', 1, NULL, NULL, 100, NULL, NULL, 80000, 0, 1, NULL, 0, 0, 0, 0, 0, 0, 0, 0, '', '', 120000, 100, 0, 0, 0, 0, 100, 0, 0, 72, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2, '2014-07-24 13:30:36', 83.8242, 15004, 0, 0, 0, 0, 0, 0, -1, 0, 'nem', 0, 0, '0000-00-00 00:00:00', 0, 23, 0, '0', 0, 0, 0, 'ÃÂcs', 0),
290('Leon_Brasco', 8, 606.226, -1228.18, 17.8508, -1, 1, 0, 0, '75', '200', 0, 0, 'Leon Brasco vagyok egy erős és bátor férfi aki szeret a barátaival mászkálni.\n', 8, 107, 'Richman', '20', 'F6A884D1012B6DD78CCC4ADC6C734605', 16, NULL, NULL, 100, NULL, NULL, 80000, 0, 1, NULL, 0, 0, 0, 0, 0, 0, 0, 0, '', '', 120000, 100, 0, 0, 0, 0, 98, 0, 0, 47, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2, '2015-03-15 18:09:31', 282.33, 15008, 0, 0, 0, 0, 0, 0, -1, 0, 'nem', 0, 0, '0000-00-00 00:00:00', 0, 0, 0, '0', 0, 0, 0, 'Atesz', 0),
291('George_Spencer', 9, 632.896, -1649.77, 15.5257, -1, 1, 0, 1, '90', '187', 0, 0, 'Én egy sámor ifjú vagyok aki epic :Dddddddddddddddddddddddddddddddddddddddd\n', 9, 30, 'Rodeo', '26', '4E58346EE47E568627018084347576D3', 16, NULL, NULL, 100, NULL, NULL, 80000, 0, 1, NULL, 0, 0, 0, 0, 0, 0, 0, 0, '', '', 120000, 100, 0, 0, 0, 0, 100, 0, 0, 20, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2, '2015-03-15 17:40:41', 226.226, 15009, 0, 0, 0, 0, 0, 0, -1, 0, 'nem', 0, 0, '0000-00-00 00:00:00', 0, 0, 0, '0', 0, 0, 0, '', 0),
292('Nicholas_Flaming', 10, 606.225, -1228.18, 17.8508, -1, 1, 0, 0, '165', '175', 0, 0, 'asdaasdasaddsadsadassadsadsadsaddsadasDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDD\n', 10, 107, 'Richman', '18', '891F763CB04CCECD442B0BB8EFD9A27F', 16, NULL, NULL, 100, NULL, NULL, 80000, 0, 1, NULL, 0, 0, 0, 0, 0, 0, 0, 0, '', '', 120000, 100, 0, 0, 0, 0, 100, 0, 0, 11, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2, '2015-03-15 18:09:29', 282.33, 15010, 0, 0, 0, 0, 0, 0, -1, 0, 'nem', 0, 0, '0000-00-00 00:00:00', 0, 0, 0, '0', 0, 0, 0, 'Dakher', 0),
293('Carlos_Stark', 11, -687.47, -1903.81, 4.96672, 1, 1, 0, 1, '78', '189', 0, 0, '\nasdfadtgwatgarwegwa tnwagadsgajwerjafjdsafjadfjfdsagafdgdsfgdsfasdfsadf\n', 11, 37, 'Back o Beyond', '22', '1786D746C3F6BA1DEB3BE4CFDC89930E', 16, NULL, NULL, 100, NULL, NULL, 2500000, 0, 1, NULL, 1, 0, 0, 0, 0, 0, 0, 1, '', '', 120000, 100, 0, 0, 0, 0, 100, 0, 0, 19, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2, '2015-03-15 21:39:06', 275.033, 15011, -1, 0, 0, 0, 0, 0, -1, 0, 'nem', 0, 0, '0000-00-00 00:00:00', 0, 0, 0, '0', 0, 0, 0, 'Alukard', 0);
294
295-- --------------------------------------------------------
296
297--
298-- Tábla szerkezet: `characterssetup`
299--
300
301CREATE TABLE IF NOT EXISTS `characterssetup` (
302 `id` int(11) NOT NULL AUTO_INCREMENT,
303 `charactersid` int(128) NOT NULL,
304 `freerent` int(1) NOT NULL DEFAULT '1',
305 `freetax` int(1) NOT NULL DEFAULT '1',
306 `frakcioboost` int(1) NOT NULL DEFAULT '1',
307 `alkalmiboost` int(1) NOT NULL DEFAULT '1',
308 `freerentend` datetime NOT NULL,
309 `freetaxend` datetime NOT NULL,
310 `frakcioboostend` datetime NOT NULL,
311 `alkalmiboostend` datetime NOT NULL,
312 PRIMARY KEY (`id`)
313) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
314
315-- --------------------------------------------------------
316
317--
318-- Tábla szerkezet: `contacts`
319--
320
321CREATE TABLE IF NOT EXISTS `contacts` (
322 `id` int(11) NOT NULL,
323 `characterName` text NOT NULL,
324 `phoneNumber` int(11) NOT NULL
325) ENGINE=MyISAM DEFAULT CHARSET=latin1;
326
327-- --------------------------------------------------------
328
329--
330-- Tábla szerkezet: `dancers`
331--
332
333CREATE TABLE IF NOT EXISTS `dancers` (
334 `id` int(11) NOT NULL AUTO_INCREMENT,
335 `x` float DEFAULT NULL,
336 `y` float DEFAULT NULL,
337 `z` float DEFAULT NULL,
338 `rotation` float DEFAULT NULL,
339 `skin` int(11) DEFAULT NULL,
340 `type` int(11) DEFAULT NULL,
341 `interior` int(11) DEFAULT NULL,
342 `dimension` int(11) DEFAULT NULL,
343 `offset` int(11) DEFAULT NULL,
344 PRIMARY KEY (`id`)
345) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
346
347-- --------------------------------------------------------
348
349--
350-- Tábla szerkezet: `elevators`
351--
352
353CREATE TABLE IF NOT EXISTS `elevators` (
354 `id` int(11) NOT NULL AUTO_INCREMENT,
355 `x` decimal(10,6) DEFAULT '0.000000',
356 `y` decimal(10,6) DEFAULT '0.000000',
357 `z` decimal(10,6) DEFAULT '0.000000',
358 `tpx` decimal(10,6) DEFAULT '0.000000',
359 `tpy` decimal(10,6) DEFAULT '0.000000',
360 `tpz` decimal(10,6) DEFAULT '0.000000',
361 `dimensionwithin` int(5) DEFAULT '0',
362 `interiorwithin` int(5) DEFAULT '0',
363 `dimension` int(5) DEFAULT '0',
364 `interior` int(5) DEFAULT '0',
365 `car` tinyint(4) unsigned DEFAULT '0',
366 `disabled` tinyint(3) unsigned DEFAULT '0',
367 UNIQUE KEY `id` (`id`)
368) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
369
370-- --------------------------------------------------------
371
372--
373-- Tábla szerkezet: `emailaccounts`
374--
375
376CREATE TABLE IF NOT EXISTS `emailaccounts` (
377 `id` int(11) NOT NULL AUTO_INCREMENT,
378 `username` varchar(35) NOT NULL,
379 `password` varchar(35) NOT NULL,
380 `creator` varchar(20) NOT NULL,
381 PRIMARY KEY (`id`)
382) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
383
384-- --------------------------------------------------------
385
386--
387-- Tábla szerkezet: `emails`
388--
389
390CREATE TABLE IF NOT EXISTS `emails` (
391 `id` int(11) NOT NULL AUTO_INCREMENT,
392 `date` varchar(25) NOT NULL,
393 `sender` varchar(25) NOT NULL,
394 `receiver` varchar(20) NOT NULL,
395 `subject` varchar(35) NOT NULL,
396 `message` varchar(150) NOT NULL,
397 `inbox` int(11) NOT NULL,
398 `outbox` int(11) NOT NULL,
399 PRIMARY KEY (`id`)
400) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
401
402-- --------------------------------------------------------
403
404--
405-- Tábla szerkezet: `factions`
406--
407
408CREATE TABLE IF NOT EXISTS `factions` (
409 `id` int(10) NOT NULL AUTO_INCREMENT,
410 `name` varchar(40) DEFAULT NULL,
411 `bankbalance` bigint(20) DEFAULT '0',
412 `type` int(11) DEFAULT NULL,
413 `rank_1` varchar(90) DEFAULT NULL,
414 `rank_2` varchar(90) DEFAULT NULL,
415 `rank_3` varchar(90) DEFAULT NULL,
416 `rank_4` varchar(90) DEFAULT NULL,
417 `rank_5` varchar(90) DEFAULT NULL,
418 `rank_6` varchar(90) DEFAULT NULL,
419 `rank_7` varchar(90) DEFAULT NULL,
420 `rank_8` varchar(90) DEFAULT NULL,
421 `rank_9` varchar(90) DEFAULT NULL,
422 `rank_10` varchar(90) DEFAULT NULL,
423 `rank_11` varchar(90) DEFAULT NULL,
424 `rank_12` varchar(90) DEFAULT NULL,
425 `rank_13` varchar(90) DEFAULT NULL,
426 `rank_14` varchar(90) DEFAULT NULL,
427 `rank_15` varchar(90) DEFAULT NULL,
428 `wage_1` int(11) DEFAULT NULL,
429 `wage_2` int(11) DEFAULT NULL,
430 `wage_3` int(11) DEFAULT NULL,
431 `wage_4` int(11) DEFAULT NULL,
432 `wage_5` int(11) DEFAULT NULL,
433 `wage_6` int(11) DEFAULT NULL,
434 `wage_7` int(11) DEFAULT NULL,
435 `wage_8` int(11) DEFAULT NULL,
436 `wage_9` int(11) DEFAULT NULL,
437 `wage_10` int(11) DEFAULT NULL,
438 `wage_11` int(11) DEFAULT NULL,
439 `wage_12` int(11) DEFAULT NULL,
440 `wage_13` int(11) DEFAULT NULL,
441 `wage_14` int(11) DEFAULT NULL,
442 `wage_15` int(11) DEFAULT NULL,
443 `motd` mediumtext,
444 `rank_16` varchar(90) DEFAULT NULL,
445 `rank_17` varchar(90) DEFAULT NULL,
446 `rank_18` varchar(90) DEFAULT NULL,
447 `rank_19` varchar(90) DEFAULT NULL,
448 `rank_20` varchar(90) DEFAULT NULL,
449 `wage_16` int(11) DEFAULT NULL,
450 `wage_17` int(11) DEFAULT NULL,
451 `wage_18` int(11) DEFAULT NULL,
452 `wage_19` int(11) DEFAULT NULL,
453 `wage_20` int(11) DEFAULT NULL,
454 PRIMARY KEY (`id`)
455) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
456
457--
458-- A tábla adatainak kiÃratása `factions`
459--
460
461INSERT INTO `factions` (`id`, `name`, `bankbalance`, `type`, `rank_1`, `rank_2`, `rank_3`, `rank_4`, `rank_5`, `rank_6`, `rank_7`, `rank_8`, `rank_9`, `rank_10`, `rank_11`, `rank_12`, `rank_13`, `rank_14`, `rank_15`, `wage_1`, `wage_2`, `wage_3`, `wage_4`, `wage_5`, `wage_6`, `wage_7`, `wage_8`, `wage_9`, `wage_10`, `wage_11`, `wage_12`, `wage_13`, `wage_14`, `wage_15`, `motd`, `rank_16`, `rank_17`, `rank_18`, `rank_19`, `rank_20`, `wage_16`, `wage_17`, `wage_18`, `wage_19`, `wage_20`) VALUES
462(1, 'Szerelők', 0, 5, 'Rang #1', 'Rang #2', 'Rang #3', 'Rang #4', 'Rang #5', 'Rang #6', 'Rang #7', 'Rang #8', 'Rang #9', 'Rang #10', 'Rang #11', 'Rang #12', 'Rang #13', 'Rang #14', 'Rang #15', 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 'Welcome to the faction.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
463
464-- --------------------------------------------------------
465
466--
467-- Tábla szerkezet: `friends`
468--
469
470CREATE TABLE IF NOT EXISTS `friends` (
471 `friend` int(11) DEFAULT NULL,
472 `id` int(11) DEFAULT NULL
473) ENGINE=MyISAM DEFAULT CHARSET=latin1;
474
475-- --------------------------------------------------------
476
477--
478-- Tábla szerkezet: `fuelpeds`
479--
480
481CREATE TABLE IF NOT EXISTS `fuelpeds` (
482 `id` int(11) NOT NULL AUTO_INCREMENT,
483 `skin` int(11) NOT NULL DEFAULT '29',
484 `posX` float DEFAULT NULL,
485 `posY` float DEFAULT NULL,
486 `posZ` float DEFAULT NULL,
487 `rotZ` float DEFAULT NULL,
488 `name` varchar(70) DEFAULT 'Gas station',
489 `priceratio` float DEFAULT '1',
490 PRIMARY KEY (`id`)
491) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
492
493-- --------------------------------------------------------
494
495--
496-- Tábla szerkezet: `hirdetofal`
497--
498
499CREATE TABLE IF NOT EXISTS `hirdetofal` (
500 `id` int(11) NOT NULL AUTO_INCREMENT,
501 `charactersid` int(128) NOT NULL,
502 `szoveg` varchar(120) NOT NULL,
503 `feladas` datetime NOT NULL,
504 PRIMARY KEY (`id`)
505) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
506
507-- --------------------------------------------------------
508
509--
510-- Tábla szerkezet: `interiors`
511--
512
513CREATE TABLE IF NOT EXISTS `interiors` (
514 `id` int(10) NOT NULL AUTO_INCREMENT,
515 `x` float DEFAULT NULL,
516 `y` float DEFAULT NULL,
517 `z` float DEFAULT NULL,
518 `type` tinyint(4) DEFAULT NULL,
519 `owner` int(11) DEFAULT NULL,
520 `locked` tinyint(4) NOT NULL DEFAULT '0',
521 `cost` int(15) DEFAULT '0',
522 `name` varchar(255) DEFAULT NULL,
523 `interior` int(11) DEFAULT NULL,
524 `interiorx` float DEFAULT NULL,
525 `interiory` float DEFAULT NULL,
526 `interiorz` float DEFAULT NULL,
527 `dimensionwithin` int(11) DEFAULT NULL,
528 `interiorwithin` int(11) DEFAULT NULL,
529 `angle` float DEFAULT NULL,
530 `angleexit` float DEFAULT NULL,
531 `max_items` int(11) DEFAULT NULL,
532 `fee` int(10) DEFAULT '0',
533 `disabled` tinyint(4) DEFAULT '0',
534 `supplies` int(11) DEFAULT '10000',
535 `safepositionX` float DEFAULT NULL,
536 `safepositionY` float DEFAULT NULL,
537 `safepositionZ` float DEFAULT NULL,
538 `safepositionRZ` float DEFAULT NULL,
539 `garazs` enum('igen','nem') NOT NULL DEFAULT 'nem',
540 PRIMARY KEY (`id`)
541) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
542
543-- --------------------------------------------------------
544
545--
546-- Tábla szerkezet: `itemek`
547--
548
549CREATE TABLE IF NOT EXISTS `itemek` (
550 `id` int(11) NOT NULL AUTO_INCREMENT,
551 `elementID` int(11) NOT NULL DEFAULT '0',
552 `elementtype` enum('szef','auto','jatekos','fold','hatizsak') NOT NULL,
553 `itemID` int(11) NOT NULL,
554 `itemValue` int(11) NOT NULL DEFAULT '0',
555 `wX` varchar(500) NOT NULL DEFAULT '0',
556 `wY` varchar(500) NOT NULL DEFAULT '0',
557 `wZ` varchar(500) NOT NULL DEFAULT '0',
558 `wRot` varchar(500) NOT NULL DEFAULT '0',
559 `wCreateDate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
560 `createDate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
561 `wInterior` int(11) NOT NULL DEFAULT '0',
562 `wDimension` int(11) NOT NULL DEFAULT '0',
563 `slot` int(11) NOT NULL DEFAULT '1',
564 `db` int(11) NOT NULL DEFAULT '1',
565 PRIMARY KEY (`id`)
566) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=87 ;
567
568--
569-- A tábla adatainak kiÃratása `itemek`
570--
571
572INSERT INTO `itemek` (`id`, `elementID`, `elementtype`, `itemID`, `itemValue`, `wX`, `wY`, `wZ`, `wRot`, `wCreateDate`, `createDate`, `wInterior`, `wDimension`, `slot`, `db`) VALUES
573(1, 0, 'fold', 143, 1, '1466.2228', '-1738.7966', '12.546875', '0', '2014-07-25 22:53:54', '2014-04-06 13:26:09', 0, 0, 0, 1),
574(6, 1, 'jatekos', 3, 1, '0', '0', '0', '0', '0000-00-00 00:00:00', '2014-07-23 18:38:38', 0, 0, 0, 1),
575(8, 3, 'jatekos', 16, 1, '0', '0', '0', '0', '0000-00-00 00:00:00', '2014-07-23 19:28:01', 0, 0, 0, 1),
576(9, 3, 'jatekos', 17, 1, '0', '0', '0', '0', '0000-00-00 00:00:00', '2014-07-23 19:28:01', 0, 0, 1, 1),
577(11, 3, 'jatekos', 136, 484598, '0', '0', '0', '0', '0000-00-00 00:00:00', '2014-07-23 19:28:02', 0, 0, 3, 1),
578(12, 3, 'jatekos', 2, 58054, '0', '0', '0', '0', '0000-00-00 00:00:00', '2014-07-23 19:28:02', 0, 0, 4, 1),
579(13, 3, 'jatekos', 7, 1, '0', '0', '0', '0', '0000-00-00 00:00:00', '2014-07-23 19:28:02', 0, 0, 5, 1),
580(17, 3, 'jatekos', 3, 2, '0', '0', '0', '0', '0000-00-00 00:00:00', '2014-07-23 19:33:24', 0, 0, 2, 1),
581(24, 1, 'jatekos', 3, 8, '0', '0', '0', '0', '0000-00-00 00:00:00', '2014-07-24 14:18:38', 0, 0, 1, 1),
582(25, 4, 'jatekos', 16, 170, '0', '0', '0', '0', '0000-00-00 00:00:00', '2014-07-24 14:18:49', 0, 0, 0, 1),
583(26, 4, 'jatekos', 17, 1, '0', '0', '0', '0', '0000-00-00 00:00:00', '2014-07-24 14:18:49', 0, 0, 1, 1),
584(27, 4, 'jatekos', 143, 1, '0', '0', '0', '0', '0000-00-00 00:00:00', '2014-07-24 14:18:49', 0, 0, 2, 1),
585(28, 4, 'jatekos', 136, 950082, '0', '0', '0', '0', '0000-00-00 00:00:00', '2014-07-24 14:18:50', 0, 0, 3, 1),
586(29, 4, 'jatekos', 2, 57391, '0', '0', '0', '0', '0000-00-00 00:00:00', '2014-07-24 14:18:50', 0, 0, 4, 1),
587(30, 4, 'jatekos', 7, 1, '0', '0', '0', '0', '0000-00-00 00:00:00', '2014-07-24 14:18:50', 0, 0, 5, 1),
588(31, 4, 'jatekos', 1, 1, '0', '0', '0', '0', '0000-00-00 00:00:00', '2014-07-24 14:18:50', 0, 0, 6, 1),
589(32, 4, 'jatekos', 12, 1, '0', '0', '0', '0', '0000-00-00 00:00:00', '2014-07-24 14:18:50', 0, 0, 7, 1),
590(33, 4, 'jatekos', 15, 1, '0', '0', '0', '0', '0000-00-00 00:00:00', '2014-07-24 14:18:50', 0, 0, 8, 1),
591(34, 2, 'jatekos', 3, 9, '0', '0', '0', '0', '0000-00-00 00:00:00', '2014-07-25 00:36:13', 0, 0, 0, 1),
592(35, 2, 'jatekos', 3, 10, '0', '0', '0', '0', '0000-00-00 00:00:00', '2014-07-25 00:36:14', 0, 0, 1, 1),
593(36, 2, 'jatekos', 3, 11, '0', '0', '0', '0', '0000-00-00 00:00:00', '2014-07-25 00:36:14', 0, 0, 2, 1),
594(37, 2, 'jatekos', 3, 12, '0', '0', '0', '0', '0000-00-00 00:00:00', '2014-07-25 00:36:15', 0, 0, 3, 1),
595(38, 2, 'jatekos', 3, 13, '0', '0', '0', '0', '0000-00-00 00:00:00', '2014-07-25 00:36:15', 0, 0, 4, 1),
596(39, 2, 'jatekos', 3, 14, '0', '0', '0', '0', '0000-00-00 00:00:00', '2014-07-25 00:36:15', 0, 0, 5, 1),
597(40, 2, 'jatekos', 3, 15, '0', '0', '0', '0', '0000-00-00 00:00:00', '2014-07-25 00:36:15', 0, 0, 6, 1),
598(41, 2, 'jatekos', 3, 16, '0', '0', '0', '0', '0000-00-00 00:00:00', '2014-07-25 00:39:08', 0, 0, 7, 1),
599(42, 2, 'jatekos', 3, 17, '0', '0', '0', '0', '0000-00-00 00:00:00', '2014-07-25 00:41:08', 0, 0, 8, 1),
600(43, 2, 'jatekos', 3, 18, '0', '0', '0', '0', '0000-00-00 00:00:00', '2014-07-25 00:41:10', 0, 0, 9, 1),
601(44, 2, 'jatekos', 3, 19, '0', '0', '0', '0', '0000-00-00 00:00:00', '2014-07-25 00:45:22', 0, 0, 10, 1),
602(45, 2, 'jatekos', 3, 20, '0', '0', '0', '0', '0000-00-00 00:00:00', '2014-07-25 00:45:23', 0, 0, 11, 1),
603(46, 2, 'jatekos', 3, 21, '0', '0', '0', '0', '0000-00-00 00:00:00', '2014-07-25 00:45:24', 0, 0, 12, 1),
604(47, 2, 'jatekos', 3, 22, '0', '0', '0', '0', '0000-00-00 00:00:00', '2014-07-25 00:59:45', 0, 0, 13, 1),
605(48, 2, 'jatekos', 3, 23, '0', '0', '0', '0', '0000-00-00 00:00:00', '2014-07-25 00:59:52', 0, 0, 14, 1),
606(49, 2, 'jatekos', 3, 24, '0', '0', '0', '0', '0000-00-00 00:00:00', '2014-07-25 01:01:49', 0, 0, 15, 1),
607(50, 2, 'jatekos', 3, 25, '0', '0', '0', '0', '0000-00-00 00:00:00', '2014-07-25 01:03:09', 0, 0, 16, 1),
608(51, 7, 'jatekos', 16, 68, '1466.2228', '-1738.7966', '12.546875', '0', '2014-07-25 22:53:54', '2014-07-25 22:50:02', 0, 0, 6, 1),
609(52, 5, 'jatekos', 17, 1, '1468.2914', '-1739.7352', '12.546875', '0', '2014-07-25 22:53:53', '2014-07-25 22:50:02', 0, 0, 2, 1),
610(53, 7, 'jatekos', 143, 1, '1465.8347', '-1739.6825', '12.546875', '0', '2014-07-25 22:53:51', '2014-07-25 22:50:02', 0, 0, 7, 1),
611(54, 5, 'jatekos', 136, 783039, '1466.871', '-1740.4991', '12.546875', '0', '2014-07-25 22:53:56', '2014-07-25 22:50:02', 0, 0, 1, 1),
612(55, 5, 'jatekos', 2, 95055, '1464.7397', '-1738.4896', '12.546875', '0', '2014-07-25 22:53:57', '2014-07-25 22:50:02', 0, 0, 3, 1),
613(56, 5, 'jatekos', 7, 1, '1466.683', '-1739.3359', '12.546875', '0', '2014-07-25 22:53:59', '2014-07-25 22:50:02', 0, 0, 0, 1),
614(57, 5, 'jatekos', 1, 1, '0', '0', '0', '0', '0000-00-00 00:00:00', '2014-07-25 22:50:02', 0, 0, 6, 1),
615(58, 5, 'jatekos', 12, 1, '0', '0', '0', '0', '0000-00-00 00:00:00', '2014-07-25 22:50:02', 0, 0, 7, 1),
616(59, 5, 'jatekos', 15, 1, '0', '0', '0', '0', '0000-00-00 00:00:00', '2014-07-25 22:50:02', 0, 0, 8, 1),
617(60, 6, 'jatekos', 16, 1, '0', '0', '0', '0', '0000-00-00 00:00:00', '2014-07-25 22:51:10', 0, 0, 0, 1),
618(61, 6, 'jatekos', 17, 1, '0', '0', '0', '0', '0000-00-00 00:00:00', '2014-07-25 22:51:10', 0, 0, 1, 1),
619(62, 6, 'jatekos', 143, 1, '0', '0', '0', '0', '0000-00-00 00:00:00', '2014-07-25 22:51:10', 0, 0, 2, 1),
620(63, 6, 'jatekos', 136, 832751, '0', '0', '0', '0', '0000-00-00 00:00:00', '2014-07-25 22:51:10', 0, 0, 3, 1),
621(64, 6, 'jatekos', 2, 236, '0', '0', '0', '0', '0000-00-00 00:00:00', '2014-07-25 22:51:10', 0, 0, 4, 1),
622(65, 0, 'fold', 7, 1, '1461.816', '-1745.9812', '12.988201', '0', '2014-07-25 22:54:08', '2014-07-25 22:51:10', 0, 0, 5, 1),
623(66, 6, 'jatekos', 1, 1, '0', '0', '0', '0', '0000-00-00 00:00:00', '2014-07-25 22:51:10', 0, 0, 6, 1),
624(67, 6, 'jatekos', 12, 1, '0', '0', '0', '0', '0000-00-00 00:00:00', '2014-07-25 22:51:10', 0, 0, 7, 1),
625(68, 6, 'jatekos', 15, 1, '0', '0', '0', '0', '0000-00-00 00:00:00', '2014-07-25 22:51:10', 0, 0, 8, 1),
626(69, 7, 'jatekos', 16, 23, '0', '0', '0', '0', '0000-00-00 00:00:00', '2014-07-25 22:51:48', 0, 0, 0, 1),
627(70, 7, 'jatekos', 17, 1, '0', '0', '0', '0', '0000-00-00 00:00:00', '2014-07-25 22:51:48', 0, 0, 1, 1),
628(71, 7, 'jatekos', 143, 1, '0', '0', '0', '0', '0000-00-00 00:00:00', '2014-07-25 22:51:48', 0, 0, 2, 1),
629(72, 7, 'jatekos', 136, 569092, '0', '0', '0', '0', '0000-00-00 00:00:00', '2014-07-25 22:51:48', 0, 0, 3, 1),
630(73, 7, 'jatekos', 2, 40869, '0', '0', '0', '0', '0000-00-00 00:00:00', '2014-07-25 22:51:48', 0, 0, 4, 1),
631(74, 7, 'jatekos', 7, 1, '0', '0', '0', '0', '0000-00-00 00:00:00', '2014-07-25 22:51:48', 0, 0, 5, 1),
632(75, 7, 'jatekos', 1, 1, '0', '0', '0', '0', '0000-00-00 00:00:00', '2014-07-25 22:51:48', 0, 0, 6, 1),
633(76, 7, 'jatekos', 12, 1, '0', '0', '0', '0', '0000-00-00 00:00:00', '2014-07-25 22:51:48', 0, 0, 7, 1),
634(77, 7, 'jatekos', 15, 1, '0', '0', '0', '0', '0000-00-00 00:00:00', '2014-07-25 22:51:48', 0, 0, 8, 1),
635(78, 8, 'jatekos', 2, 1, '0', '0', '0', '0', '0000-00-00 00:00:00', '2015-03-15 18:31:35', 0, 0, 0, 1),
636(79, 9, 'jatekos', 2, 1, '0', '0', '0', '0', '0000-00-00 00:00:00', '2015-03-15 18:31:36', 0, 0, 0, 1),
637(81, 10, 'jatekos', 2, 1, '0', '0', '0', '0', '0000-00-00 00:00:00', '2015-03-15 19:05:30', 0, 0, 35, 1),
638(83, 11, 'jatekos', 3, 26, '0', '0', '0', '0', '0000-00-00 00:00:00', '2015-03-15 22:24:17', 0, 0, 0, 1),
639(84, 11, 'jatekos', 3, 27, '0', '0', '0', '0', '0000-00-00 00:00:00', '2015-03-15 22:29:56', 0, 0, 1, 1),
640(85, 11, 'jatekos', 3, 28, '0', '0', '0', '0', '0000-00-00 00:00:00', '2015-03-15 22:32:52', 0, 0, 2, 1),
641(86, 11, 'jatekos', 3, 29, '0', '0', '0', '0', '0000-00-00 00:00:00', '2015-03-15 22:35:44', 0, 0, 3, 1);
642
643-- --------------------------------------------------------
644
645--
646-- Tábla szerkezet: `items`
647--
648
649CREATE TABLE IF NOT EXISTS `items` (
650 `itemValue` int(90) DEFAULT NULL,
651 `itemID` int(11) DEFAULT NULL,
652 `type` int(11) DEFAULT NULL,
653 `owner` int(11) DEFAULT NULL,
654 `index` int(255) NOT NULL AUTO_INCREMENT,
655 PRIMARY KEY (`index`)
656) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
657
658-- --------------------------------------------------------
659
660--
661-- Tábla szerkezet: `lottery`
662--
663
664CREATE TABLE IF NOT EXISTS `lottery` (
665 `characterid` int(11) DEFAULT NULL,
666 `ticketnumber` int(11) DEFAULT NULL
667) ENGINE=MyISAM DEFAULT CHARSET=latin1;
668
669-- --------------------------------------------------------
670
671--
672-- Tábla szerkezet: `mdcusers`
673--
674
675CREATE TABLE IF NOT EXISTS `mdcusers` (
676 `user_name` varchar(20) NOT NULL,
677 `id` int(11) NOT NULL AUTO_INCREMENT,
678 `password` varchar(20) NOT NULL DEFAULT '123',
679 `high_command` int(1) DEFAULT '0',
680 PRIMARY KEY (`id`)
681) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
682
683-- --------------------------------------------------------
684
685--
686-- Tábla szerkezet: `nevjegyzek`
687--
688
689CREATE TABLE IF NOT EXISTS `nevjegyzek` (
690 `id` int(11) NOT NULL AUTO_INCREMENT,
691 `kinek` int(11) NOT NULL,
692 `telefonszam` varchar(100) NOT NULL,
693 `felveve` datetime NOT NULL,
694 PRIMARY KEY (`id`)
695) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
696
697-- --------------------------------------------------------
698
699--
700-- Tábla szerkezet: `objects`
701--
702
703CREATE TABLE IF NOT EXISTS `objects` (
704 `id` int(11) NOT NULL AUTO_INCREMENT,
705 `interior` int(11) NOT NULL,
706 `dimension` int(11) NOT NULL,
707 `model` int(11) NOT NULL,
708 `posX` float NOT NULL,
709 `posY` float NOT NULL,
710 `posZ` float NOT NULL,
711 `rotX` float NOT NULL,
712 `rotY` float NOT NULL,
713 `rotZ` float NOT NULL,
714 `solid` int(11) NOT NULL,
715 PRIMARY KEY (`id`)
716) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
717
718-- --------------------------------------------------------
719
720--
721-- Tábla szerkezet: `publicphones`
722--
723
724CREATE TABLE IF NOT EXISTS `publicphones` (
725 `id` int(11) NOT NULL DEFAULT '0',
726 `x` float NOT NULL,
727 `y` float NOT NULL,
728 `z` float NOT NULL,
729 `dimension` int(11) NOT NULL,
730 PRIMARY KEY (`id`)
731) ENGINE=MyISAM DEFAULT CHARSET=latin1;
732
733-- --------------------------------------------------------
734
735--
736-- Tábla szerkezet: `settings`
737--
738
739CREATE TABLE IF NOT EXISTS `settings` (
740 `id` int(11) NOT NULL AUTO_INCREMENT,
741 `value` mediumtext,
742 `name` mediumtext,
743 PRIMARY KEY (`id`)
744) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;
745
746--
747-- A tábla adatainak kiÃratása `settings`
748--
749
750INSERT INTO `settings` (`id`, `value`, `name`) VALUES
751(1, '15', 'tax'),
752(2, '10', 'incometax'),
753(3, '15024630', 'lotteryjackpot'),
754(4, '0000-00-00 00:00:00', 'boltrablas'),
755(5, '2013-12-19 17:03:07', 'bankrablas');
756
757-- --------------------------------------------------------
758
759--
760-- Tábla szerkezet: `shops`
761--
762
763CREATE TABLE IF NOT EXISTS `shops` (
764 `id` int(11) NOT NULL AUTO_INCREMENT,
765 `x` double DEFAULT '0',
766 `y` double DEFAULT '0',
767 `z` double DEFAULT '0',
768 `interior` int(9) DEFAULT '0',
769 `dimension` int(9) DEFAULT '0',
770 `rotation` double DEFAULT '0',
771 `shoptype` int(10) DEFAULT '0',
772 `skin` int(10) DEFAULT '0',
773 `nev` varchar(50) NOT NULL,
774 PRIMARY KEY (`id`)
775) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
776
777-- --------------------------------------------------------
778
779--
780-- Tábla szerkezet: `sms`
781--
782
783CREATE TABLE IF NOT EXISTS `sms` (
784 `id` int(11) NOT NULL AUTO_INCREMENT,
785 `date` datetime NOT NULL,
786 `character` int(11) NOT NULL,
787 `money` varchar(500) NOT NULL,
788 PRIMARY KEY (`id`)
789) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
790
791-- --------------------------------------------------------
792
793--
794-- Tábla szerkezet: `speedcams`
795--
796
797CREATE TABLE IF NOT EXISTS `speedcams` (
798 `id` int(11) NOT NULL AUTO_INCREMENT,
799 `x` float NOT NULL,
800 `y` float NOT NULL,
801 `z` float NOT NULL,
802 `interior` int(11) NOT NULL,
803 `dimension` int(11) NOT NULL,
804 `maxspeed` float NOT NULL,
805 `radius` float NOT NULL DEFAULT '7',
806 `enabled` int(11) NOT NULL DEFAULT '1',
807 PRIMARY KEY (`id`)
808) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
809
810-- --------------------------------------------------------
811
812--
813-- Tábla szerkezet: `suspectcrime`
814--
815
816CREATE TABLE IF NOT EXISTS `suspectcrime` (
817 `id` int(11) NOT NULL AUTO_INCREMENT,
818 `suspect_name` varchar(36) NOT NULL,
819 `time` varchar(35) NOT NULL,
820 `date` varchar(35) NOT NULL,
821 `officers` varchar(35) NOT NULL,
822 `ticket` varchar(35) NOT NULL,
823 `arrest` varchar(35) NOT NULL,
824 `fine` varchar(35) NOT NULL,
825 `ticket_price` float NOT NULL,
826 `arrest_price` float NOT NULL,
827 `fine_price` float NOT NULL,
828 `illegal_items` varchar(50) NOT NULL,
829 `details` varchar(350) NOT NULL,
830 `done_by` varchar(35) NOT NULL,
831 PRIMARY KEY (`id`)
832) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
833
834-- --------------------------------------------------------
835
836--
837-- Tábla szerkezet: `suspectdetails`
838--
839
840CREATE TABLE IF NOT EXISTS `suspectdetails` (
841 `id` int(11) NOT NULL AUTO_INCREMENT,
842 `suspect_name` varchar(50) DEFAULT 'S',
843 `birth` varchar(25) DEFAULT NULL,
844 `ethnicy` varchar(25) DEFAULT NULL,
845 `cell` int(25) DEFAULT NULL,
846 `gender` varchar(11) NOT NULL,
847 `address` varchar(50) NOT NULL,
848 `other` varchar(70) NOT NULL,
849 `is_wanted` tinyint(4) NOT NULL,
850 `wanted_reason` varchar(50) NOT NULL,
851 `wanted_punishment` varchar(50) NOT NULL,
852 `wanted_by` varchar(50) NOT NULL,
853 `photo` varchar(50) NOT NULL,
854 `done_by` varchar(50) NOT NULL,
855 `occupation` varchar(45) NOT NULL,
856 PRIMARY KEY (`id`)
857) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
858
859-- --------------------------------------------------------
860
861--
862-- Tábla szerkezet: `tags`
863--
864
865CREATE TABLE IF NOT EXISTS `tags` (
866 `id` int(11) NOT NULL AUTO_INCREMENT,
867 `x` decimal(10,6) DEFAULT NULL,
868 `y` decimal(10,6) DEFAULT NULL,
869 `z` decimal(10,6) DEFAULT NULL,
870 `interior` int(5) DEFAULT NULL,
871 `dimension` int(5) DEFAULT NULL,
872 `rx` decimal(10,6) DEFAULT NULL,
873 `ry` decimal(10,6) DEFAULT NULL,
874 `rz` decimal(10,6) DEFAULT NULL,
875 `modelid` int(5) DEFAULT NULL,
876 `creationdate` datetime DEFAULT NULL,
877 `creator` int(11) NOT NULL DEFAULT '-1',
878 UNIQUE KEY `id` (`id`)
879) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
880
881-- --------------------------------------------------------
882
883--
884-- Tábla szerkezet: `terulet`
885--
886
887CREATE TABLE IF NOT EXISTS `terulet` (
888 `id` int(11) NOT NULL AUTO_INCREMENT,
889 `frakcio` int(11) NOT NULL DEFAULT '-1',
890 PRIMARY KEY (`id`)
891) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
892
893-- --------------------------------------------------------
894
895--
896-- Tábla szerkezet: `vehicles`
897--
898
899CREATE TABLE IF NOT EXISTS `vehicles` (
900 `id` int(11) NOT NULL AUTO_INCREMENT,
901 `model` int(10) DEFAULT NULL,
902 `x` float DEFAULT NULL,
903 `y` float DEFAULT NULL,
904 `z` float DEFAULT NULL,
905 `rotx` float DEFAULT NULL,
906 `roty` float DEFAULT NULL,
907 `rotz` float DEFAULT NULL,
908 `color1` tinyint(4) NOT NULL DEFAULT '0',
909 `color2` tinyint(4) NOT NULL DEFAULT '0',
910 `faction` int(11) DEFAULT '0',
911 `owner` int(11) DEFAULT '0',
912 `plate` varchar(25) DEFAULT NULL,
913 `currx` float DEFAULT NULL,
914 `curry` float DEFAULT NULL,
915 `currz` float DEFAULT NULL,
916 `currrx` float DEFAULT NULL,
917 `currry` float DEFAULT NULL,
918 `currrz` float DEFAULT NULL,
919 `locked` tinyint(4) DEFAULT '0',
920 `interior` int(11) DEFAULT '0',
921 `currinterior` int(11) DEFAULT '0',
922 `dimension` int(11) DEFAULT '0',
923 `currdimension` int(11) DEFAULT '0',
924 `tintedwindows` tinyint(4) DEFAULT '0',
925 `fuel` int(11) DEFAULT '100',
926 `panelStates` varchar(35) DEFAULT '[ [ 0, 0, 0, 0, 0, 0, 0 ] ]',
927 `engine` tinyint(4) DEFAULT '0',
928 `wheelStates` varchar(35) DEFAULT '[ [ 0, 0, 0, 0 ] ]',
929 `lights` tinyint(4) DEFAULT '0',
930 `hp` float DEFAULT '1000',
931 `doorStates` varchar(255) DEFAULT '[ [ 0, 0, 0, 0, 0, 0 ] ]',
932 `sirens` tinyint(4) NOT NULL DEFAULT '1',
933 `handbrake` tinyint(4) NOT NULL DEFAULT '0',
934 `Impounded` tinyint(4) DEFAULT '0',
935 `job` int(11) DEFAULT '0',
936 `paintjob` int(11) DEFAULT '4',
937 `upgrades` varchar(255) DEFAULT '[ [ 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 ] ]',
938 `rent` tinyint(1) NOT NULL DEFAULT '0',
939 `rentcost` int(11) NOT NULL DEFAULT '0',
940 `lred` int(11) NOT NULL DEFAULT '255',
941 `lgreen` int(11) NOT NULL DEFAULT '255',
942 `lblue` int(11) NOT NULL DEFAULT '255',
943 `kilometerek` varchar(5000) NOT NULL DEFAULT '0',
944 `olajszint` varchar(50) NOT NULL DEFAULT '40',
945 `akkumlator` varchar(50) NOT NULL DEFAULT '100',
946 `berelheto` enum('igen','nem') NOT NULL DEFAULT 'nem',
947 `pc` int(11) NOT NULL DEFAULT '0',
948 `turbo` int(11) NOT NULL DEFAULT '0',
949 `torol` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
950 `vip` enum('igen','nem') NOT NULL DEFAULT 'nem',
951 `r` int(11) DEFAULT NULL,
952 `g` int(11) DEFAULT NULL,
953 `b` int(11) DEFAULT NULL,
954 `r2` int(11) DEFAULT '255',
955 `b2` int(11) DEFAULT '255',
956 `g2` int(11) DEFAULT '255',
957 `motor` int(11) NOT NULL DEFAULT '0',
958 `r1` int(11) DEFAULT NULL,
959 `g1` int(11) DEFAULT NULL,
960 `b1` int(11) DEFAULT NULL,
961 PRIMARY KEY (`id`)
962) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=30 ;
963
964--
965-- A tábla adatainak kiÃratása `vehicles`
966--
967
968INSERT INTO `vehicles` (`id`, `model`, `x`, `y`, `z`, `rotx`, `roty`, `rotz`, `color1`, `color2`, `faction`, `owner`, `plate`, `currx`, `curry`, `currz`, `currrx`, `currry`, `currrz`, `locked`, `interior`, `currinterior`, `dimension`, `currdimension`, `tintedwindows`, `fuel`, `panelStates`, `engine`, `wheelStates`, `lights`, `hp`, `doorStates`, `sirens`, `handbrake`, `Impounded`, `job`, `paintjob`, `upgrades`, `rent`, `rentcost`, `lred`, `lgreen`, `lblue`, `kilometerek`, `olajszint`, `akkumlator`, `berelheto`, `pc`, `turbo`, `torol`, `vip`, `r`, `g`, `b`, `r2`, `b2`, `g2`, `motor`, `r1`, `g1`, `b1`) VALUES
969(26, 492, -266.831, -1685.52, 14.4803, 1.0437, 349.909, 344.872, 1, 1, -1, 11, 'LN4 4365', -266.831, -1685.52, 14.4803, 1.0437, 349.909, 344.872, 0, 0, 0, 0, 0, 0, 100, '[ [ 2, 0, 0, 0, 0, 2, 0 ] ]', 0, '[ [ 0, 0, 0, 0 ] ]', 1, 958, '[ [ 0, 0, 0, 0, 0, 0 ] ]', 0, 0, 0, 0, 4, '[ [ 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 ] ]', 0, 0, 255, 255, 255, '0', '40', '100', 'nem', 0, 0, '0000-00-00 00:00:00', 'nem', NULL, NULL, NULL, 255, 255, 255, 0, NULL, NULL, NULL),
970(27, 560, -264.455, -1660.13, 14.987, 0, 0, 76.9906, 2, 2, -1, 11, 'IY0 2955', -264.455, -1660.13, 14.987, 0, 0, 76.9906, 0, 0, 0, 0, 0, 0, 100, '[ [ 1, 0, 0, 0, 0, 1, 0 ] ]', 1, '[ [ 0, 0, 0, 0 ] ]', 2, 535.5, '[ [ 0, 0, 0, 0, 2, 0 ] ]', 0, 0, 0, 0, 4, '[ [ 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 ] ]', 0, 0, 255, 255, 255, '0', '40', '100', 'nem', 0, 0, '0000-00-00 00:00:00', 'nem', NULL, NULL, NULL, 255, 255, 255, 0, NULL, NULL, NULL),
971(28, 411, 23.488, -2696.86, 40.6958, 0, 0, 247.682, 6, 6, -1, 11, 'XD6 4817', 23.488, -2696.86, 40.6958, 0, 0, 247.682, 0, 0, 0, 0, 0, 0, 100, '[ [ 0, 0, 0, 0, 0, 0, 0 ] ]', 0, '[ [ 0, 0, 0, 0 ] ]', 1, 1000, '[ [ 0, 0, 0, 0, 0, 0 ] ]', 0, 0, 0, 0, 4, '[ [ 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 ] ]', 0, 0, 255, 255, 255, '0', '40', '100', 'nem', 0, 0, '0000-00-00 00:00:00', 'nem', NULL, NULL, NULL, 255, 255, 255, 0, NULL, NULL, NULL),
972(29, 411, -687.47, -1903.81, 4.96672, 2.96082, 0.241699, 275.076, 0, 0, -1, 11, 'KJ1 5359', -687.47, -1903.81, 4.96672, 2.96082, 0.241699, 275.076, 1, 0, 0, 0, 0, 0, 100, '[ [ 2, 0, 0, 0, 0, 3, 1 ] ]', 1, '[ [ 0, 0, 0, 0 ] ]', 2, 677.5, '[ [ 0, 2, 0, 0, 0, 0 ] ]', 0, 0, 0, 0, 4, '[ [ 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 ] ]', 0, 0, 255, 255, 255, '0', '40', '100', 'nem', 0, 0, '0000-00-00 00:00:00', 'nem', NULL, NULL, NULL, 255, 255, 255, 0, NULL, NULL, NULL);
973
974-- --------------------------------------------------------
975
976--
977-- Tábla szerkezet: `weltitems`
978--
979
980CREATE TABLE IF NOT EXISTS `weltitems` (
981 `id` mediumint(100) NOT NULL AUTO_INCREMENT,
982 `Name` varchar(24) DEFAULT NULL,
983 `Menge` int(18) DEFAULT NULL,
984 `Verschmutzer` varchar(32) DEFAULT NULL,
985 `xPos` float(20,15) DEFAULT NULL,
986 `yPos` float(20,15) DEFAULT NULL,
987 `zPos` float(20,15) DEFAULT NULL,
988 `Interior` int(3) DEFAULT '0',
989 `Dimension` int(3) DEFAULT '0',
990 PRIMARY KEY (`id`)
991) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
992
993-- --------------------------------------------------------
994
995--
996-- Tábla szerkezet: `wiretransfers`
997--
998
999CREATE TABLE IF NOT EXISTS `wiretransfers` (
1000 `id` int(11) NOT NULL AUTO_INCREMENT,
1001 `from` varchar(15) DEFAULT NULL,
1002 `to` varchar(15) DEFAULT NULL,
1003 `amount` int(11) DEFAULT NULL,
1004 `type` tinyint(4) DEFAULT NULL,
1005 `time` time NOT NULL DEFAULT '02:04:00',
1006 `deposit` int(11) NOT NULL DEFAULT '0',
1007 `limit` int(11) DEFAULT NULL,
1008 `reason` varchar(40) DEFAULT NULL,
1009 `date` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
1010 PRIMARY KEY (`id`)
1011) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
1012
1013-- --------------------------------------------------------
1014
1015--
1016-- Tábla szerkezet: `worlditems`
1017--
1018
1019CREATE TABLE IF NOT EXISTS `worlditems` (
1020 `id` int(11) NOT NULL AUTO_INCREMENT,
1021 `itemid` int(11) DEFAULT NULL,
1022 `itemvalue` int(11) DEFAULT NULL,
1023 `x` float DEFAULT '0',
1024 `y` float DEFAULT '0',
1025 `z` float DEFAULT '0',
1026 `interior` int(11) DEFAULT '0',
1027 `dimension` int(11) DEFAULT '0',
1028 `rz` float DEFAULT '0',
1029 `creator` int(11) DEFAULT NULL,
1030 `creationdate` date DEFAULT NULL,
1031 PRIMARY KEY (`id`)
1032) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
1033
1034/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
1035/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
1036/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;