-- phpMyAdmin SQL Dump
-- version 3.2.0.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Sep 10, 2010 at 05:23 PM
-- Server version: 5.1.36
-- PHP Version: 5.3.0
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
--
-- Database: `mr187_test`
--
-- --------------------------------------------------------
--
-- Table structure for table `accounts`
--
CREATE TABLE IF NOT EXISTS `accounts` (
`Username` text NOT NULL,
`Password` text NOT NULL,
`Cash` int(11) NOT NULL,
`Model` int(11) NOT NULL,
`Crash` int(11) NOT NULL,
`Age` int(11) NOT NULL,
`PosX` float NOT NULL,
`PosY` float NOT NULL,
`PosZ` float NOT NULL,
`Health` float NOT NULL,
`Armour` float NOT NULL,
`Int` int(11) NOT NULL,
`World` int(11) NOT NULL,
`PayDay` int(11) NOT NULL,
`PayCheck` int(11) NOT NULL,
`Account` int(11) NOT NULL,
`ConnectTime` int(11) NOT NULL,
`Member` int(11) NOT NULL,
`Rank` int(11) NOT NULL,
`Weed` int(11) NOT NULL,
`Crack` int(11) NOT NULL,
`Cocaine` int(11) NOT NULL,
`HouseKey` int(11) NOT NULL,
`BizKey` int(11) NOT NULL,
`CarKey1` int(11) NOT NULL,
`CarKey2` int(11) NOT NULL,
`CarKey3` int(11) NOT NULL,
`Admin` int(11) NOT NULL,
`Helper` int(11) NOT NULL,
`Banned` int(11) NOT NULL,
`DrugTime` int(11) NOT NULL,
`HouseEnter` int(11) NOT NULL,
`BizzEnter` int(11) NOT NULL,
`GunLic` int(11) NOT NULL,
`DriveLic` int(11) NOT NULL,
`PhoneNum` int(11) NOT NULL,
`Job` int(11) NOT NULL,
`Jailed` int(11) NOT NULL,
`JailTime` int(11) NOT NULL,
`Weapon0` int(11) NOT NULL,
`Weapon1` int(11) NOT NULL,
`Weapon2` int(11) NOT NULL,
`Weapon3` int(11) NOT NULL,
`Weapon4` int(11) NOT NULL,
`Weapon5` int(11) NOT NULL,
`Weapon6` int(11) NOT NULL,
`Weapon7` int(11) NOT NULL,
`Weapon8` int(11) NOT NULL,
`Weapon9` int(11) NOT NULL,
`Weapon10` int(11) NOT NULL,
`Weapon11` int(11) NOT NULL,
`Weapon12` int(11) NOT NULL,
`Ammo0` int(11) NOT NULL,
`Ammo1` int(11) NOT NULL,
`Ammo2` int(11) NOT NULL,
`Ammo3` int(11) NOT NULL,
`Ammo4` int(11) NOT NULL,
`Ammo5` int(11) NOT NULL,
`Ammo6` int(11) NOT NULL,
`Ammo7` int(11) NOT NULL,
`Ammo8` int(11) NOT NULL,
`Ammo9` int(11) NOT NULL,
`Ammo10` int(11) NOT NULL,
`Ammo11` int(11) NOT NULL,
`Ammo12` int(11) NOT NULL,
`WantedLevel` int(11) NOT NULL,
`DonateRank` int(11) NOT NULL,
`Mask` int(11) NOT NULL,
`MaskID` int(11) NOT NULL,
`Cellphone` int(11) NOT NULL,
`Crimes` int(11) NOT NULL,
`Arrest` int(11) NOT NULL,
`Changes` int(11) NOT NULL,
`MarriedTo` text NOT NULL,
`Accent` text NOT NULL,
`AdmName` text NOT NULL,
`Married` int(11) NOT NULL,
`Warrent` int(11) NOT NULL,
`Sex` int(11) NOT NULL,
`Tutorial` int(11) NOT NULL,
`CarTicket` int(11) NOT NULL,
`DonateTime` int(11) NOT NULL,
`Ajails` int(11) NOT NULL,
`Bans` int(11) NOT NULL,
`Kicks` int(11) NOT NULL,
`AdminPass` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `accounts`
--
-- --------------------------------------------------------
--
-- Table structure for table `vehicles`
--
CREATE TABLE IF NOT EXISTS `vehicles` (
`Model` int(11) NOT NULL,
`X` float NOT NULL,
`Y` float NOT NULL,
`Z` float NOT NULL,
`Angle` float NOT NULL,
`Color1` int(11) NOT NULL,
`Color2` int(11) NOT NULL,
`Owner` text NOT NULL,
`Owned` int(11) NOT NULL,
`Value` int(11) NOT NULL,
`Lock` int(11) NOT NULL,
`Fuel` int(11) NOT NULL,
`Donate` int(11) NOT NULL,
`Mod0` int(11) NOT NULL,
`Mod1` int(11) NOT NULL,
`Mod2` int(11) NOT NULL,
`Mod3` int(11) NOT NULL,
`Mod4` int(11) NOT NULL,
`Mod5` int(11) NOT NULL,
`Mod6` int(11) NOT NULL,
`Mod7` int(11) NOT NULL,
`Mod8` int(11) NOT NULL,
`Mod9` int(11) NOT NULL,
`vehicleid` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `vehicles`
--