· 9 years ago · Nov 21, 2016, 09:18 PM
1--- Code: ---
2-- phpMyAdmin SQL Dump
3-- version 3.2.0.1
4-- http://www.phpmyadmin.net
5--
6-- Host: localhost
7-- Generation Time: Sep 10, 2010 at 05:23 PM
8-- Server version: 5.1.36
9-- PHP Version: 5.3.0
10
11SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
12
13--
14-- Database: `mr187_test`
15--
16
17-- --------------------------------------------------------
18
19--
20-- Table structure for table `accounts`
21--
22
23CREATE TABLE IF NOT EXISTS `accounts` (
24 `Username` text NOT NULL,
25 `Password` text NOT NULL,
26 `Cash` int(11) NOT NULL,
27 `Model` int(11) NOT NULL,
28 `Crash` int(11) NOT NULL,
29 `Age` int(11) NOT NULL,
30 `PosX` float NOT NULL,
31 `PosY` float NOT NULL,
32 `PosZ` float NOT NULL,
33 `Health` float NOT NULL,
34 `Armour` float NOT NULL,
35 `Int` int(11) NOT NULL,
36 `World` int(11) NOT NULL,
37 `PayDay` int(11) NOT NULL,
38 `PayCheck` int(11) NOT NULL,
39 `Account` int(11) NOT NULL,
40 `ConnectTime` int(11) NOT NULL,
41 `Member` int(11) NOT NULL,
42 `Rank` int(11) NOT NULL,
43 `Weed` int(11) NOT NULL,
44 `Crack` int(11) NOT NULL,
45 `Cocaine` int(11) NOT NULL,
46 `HouseKey` int(11) NOT NULL,
47 `BizKey` int(11) NOT NULL,
48 `CarKey1` int(11) NOT NULL,
49 `CarKey2` int(11) NOT NULL,
50 `CarKey3` int(11) NOT NULL,
51 `Admin` int(11) NOT NULL,
52 `Helper` int(11) NOT NULL,
53 `Banned` int(11) NOT NULL,
54 `DrugTime` int(11) NOT NULL,
55 `HouseEnter` int(11) NOT NULL,
56 `BizzEnter` int(11) NOT NULL,
57 `GunLic` int(11) NOT NULL,
58 `DriveLic` int(11) NOT NULL,
59 `PhoneNum` int(11) NOT NULL,
60 `Job` int(11) NOT NULL,
61 `Jailed` int(11) NOT NULL,
62 `JailTime` int(11) NOT NULL,
63 `Weapon0` int(11) NOT NULL,
64 `Weapon1` int(11) NOT NULL,
65 `Weapon2` int(11) NOT NULL,
66 `Weapon3` int(11) NOT NULL,
67 `Weapon4` int(11) NOT NULL,
68 `Weapon5` int(11) NOT NULL,
69 `Weapon6` int(11) NOT NULL,
70 `Weapon7` int(11) NOT NULL,
71 `Weapon8` int(11) NOT NULL,
72 `Weapon9` int(11) NOT NULL,
73 `Weapon10` int(11) NOT NULL,
74 `Weapon11` int(11) NOT NULL,
75 `Weapon12` int(11) NOT NULL,
76 `Ammo0` int(11) NOT NULL,
77 `Ammo1` int(11) NOT NULL,
78 `Ammo2` int(11) NOT NULL,
79 `Ammo3` int(11) NOT NULL,
80 `Ammo4` int(11) NOT NULL,
81 `Ammo5` int(11) NOT NULL,
82 `Ammo6` int(11) NOT NULL,
83 `Ammo7` int(11) NOT NULL,
84 `Ammo8` int(11) NOT NULL,
85 `Ammo9` int(11) NOT NULL,
86 `Ammo10` int(11) NOT NULL,
87 `Ammo11` int(11) NOT NULL,
88 `Ammo12` int(11) NOT NULL,
89 `WantedLevel` int(11) NOT NULL,
90 `DonateRank` int(11) NOT NULL,
91 `Mask` int(11) NOT NULL,
92 `MaskID` int(11) NOT NULL,
93 `Cellphone` int(11) NOT NULL,
94 `Crimes` int(11) NOT NULL,
95 `Arrest` int(11) NOT NULL,
96 `Changes` int(11) NOT NULL,
97 `MarriedTo` text NOT NULL,
98 `Accent` text NOT NULL,
99 `AdmName` text NOT NULL,
100 `Married` int(11) NOT NULL,
101 `Warrent` int(11) NOT NULL,
102 `Sex` int(11) NOT NULL,
103 `Tutorial` int(11) NOT NULL,
104 `CarTicket` int(11) NOT NULL,
105 `DonateTime` int(11) NOT NULL,
106 `Ajails` int(11) NOT NULL,
107 `Bans` int(11) NOT NULL,
108 `Kicks` int(11) NOT NULL,
109 `AdminPass` text NOT NULL
110) ENGINE=MyISAM DEFAULT CHARSET=latin1;
111
112--
113-- Dumping data for table `accounts`
114--
115
116
117-- --------------------------------------------------------
118
119--
120-- Table structure for table `vehicles`
121--
122
123CREATE TABLE IF NOT EXISTS `vehicles` (
124 `Model` int(11) NOT NULL,
125 `X` float NOT NULL,
126 `Y` float NOT NULL,
127 `Z` float NOT NULL,
128 `Angle` float NOT NULL,
129 `Color1` int(11) NOT NULL,
130 `Color2` int(11) NOT NULL,
131 `Owner` text NOT NULL,
132 `Owned` int(11) NOT NULL,
133 `Value` int(11) NOT NULL,
134 `Lock` int(11) NOT NULL,
135 `Fuel` int(11) NOT NULL,
136 `Donate` int(11) NOT NULL,
137 `Mod0` int(11) NOT NULL,
138 `Mod1` int(11) NOT NULL,
139 `Mod2` int(11) NOT NULL,
140 `Mod3` int(11) NOT NULL,
141 `Mod4` int(11) NOT NULL,
142 `Mod5` int(11) NOT NULL,
143 `Mod6` int(11) NOT NULL,
144 `Mod7` int(11) NOT NULL,
145 `Mod8` int(11) NOT NULL,
146 `Mod9` int(11) NOT NULL,
147 `vehicleid` int(11) NOT NULL
148) ENGINE=MyISAM DEFAULT CHARSET=latin1;
149
150--
151-- Dumping data for table `vehicles`
152--