-- phpMyAdmin SQL Dump
-- version 3.4.5
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Apr 29, 2012 at 04:04 AM
-- Server version: 5.5.16
-- PHP Version: 5.3.8
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
--
-- Database: `rpserver`
--
-- --------------------------------------------------------
--
-- Table structure for table `accounts`
--
CREATE TABLE IF NOT EXISTS `accounts` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`username` text,
`password` text,
`registerdate` datetime DEFAULT NULL,
`lastlogin` datetime DEFAULT NULL,
`ip` text,
`admin` tinyint(3) unsigned DEFAULT '0',
`hiddenadmin` tinyint(3) unsigned DEFAULT '0',
`adminduty` tinyint(3) unsigned DEFAULT '0',
`adminjail` tinyint(3) unsigned DEFAULT '0',
`adminjail_time` int(11) DEFAULT NULL,
`adminjail_by` text,
`adminjail_reason` text,
`banned` tinyint(3) unsigned DEFAULT '0',
`banned_by` text,
`banned_reason` text,
`muted` tinyint(3) unsigned DEFAULT '0',
`globalooc` tinyint(3) unsigned DEFAULT '1',
`country` text,
`friendsmessage` text,
`adminjail_permanent` tinyint(3) unsigned DEFAULT '0',
`adminreports` int(11) DEFAULT '0',
`warns` tinyint(3) unsigned DEFAULT '0',
`chatbubbles` tinyint(3) unsigned NOT NULL DEFAULT '1',
`adminnote` text,
`appstate` tinyint(1) DEFAULT '0',
`appdatetime` datetime DEFAULT NULL,
`appreason` longtext,
`email` text,
`help` int(1) NOT NULL DEFAULT '1',
`adblocked` int(1) NOT NULL DEFAULT '0',
`newsblocked` int(1) NOT NULL DEFAULT '0',
`mtaserial` text,
`d_addiction` text,
`loginhash` varchar(64) DEFAULT NULL,
`credits` int(11) NOT NULL DEFAULT '0',
`transfers` int(11) DEFAULT '0',
`monitored` varchar(255) NOT NULL DEFAULT 'New Player',
UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC AUTO_INCREMENT=2 ;
--
-- Dumping data for table `accounts`
--
INSERT INTO `accounts` (`id`, `username`, `password`, `registerdate`, `lastlogin`, `ip`, `admin`, `hiddenadmin`, `adminduty`, `adminjail`, `adminjail_time`, `adminjail_by`, `adminjail_reason`, `banned`, `banned_by`, `banned_reason`, `muted`, `globalooc`, `country`, `friendsmessage`, `adminjail_permanent`, `adminreports`, `warns`, `chatbubbles`, `adminnote`, `appstate`, `appdatetime`, `appreason`, `email`, `help`, `adblocked`, `newsblocked`, `mtaserial`, `d_addiction`, `loginhash`, `credits`, `transfers`, `monitored`) VALUES
(1, 'OverDrive', '1EE92F90C952D3D685D70427B135C32F', NULL, NULL, '192.168.1.2', 6, 0, 0, 0, NULL, NULL, NULL, 0, NULL, NULL, 0, 1, NULL, 'Sample Message', 0, 0, 0, 1, NULL, 3, NULL, NULL, NULL, 1, 0, 0, '37B935477D87EFDED627D4F489497644', NULL, 'Dy6klMCr9kVoFRW8tzI3TziqL1vjEoo2OL63u4DrIXoWbRJAGvT08f6i67iKQuA9', 0, 0, 'New Player');
-- --------------------------------------------------------
--
-- Table structure for table `adminhistory`
--
CREATE TABLE IF NOT EXISTS `adminhistory` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`user` int(10) unsigned NOT NULL,
`user_char` text NOT NULL,
`admin` int(10) unsigned NOT NULL,
`admin_char` text NOT NULL,
`date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`action` tinyint(3) unsigned NOT NULL,
`duration` int(10) unsigned NOT NULL,
`reason` text NOT NULL,
`hiddenadmin` tinyint(3) unsigned NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `apb`
--
CREATE TABLE IF NOT EXISTS `apb` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`description` text NOT NULL,
`doneby` int(11) NOT NULL,
`time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `applications`
--
CREATE TABLE IF NOT EXISTS `applications` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`accountID` int(11) NOT NULL,
`dateposted` datetime NOT NULL,
`content` text NOT NULL,
`datereviewed` datetime DEFAULT NULL,
`adminID` int(11) DEFAULT NULL,
`adminNote` text,
`adminAction` int(11) NOT NULL DEFAULT '1',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `atms`
--
CREATE TABLE IF NOT EXISTS `atms` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`x` decimal(10,6) DEFAULT '0.000000',
`y` decimal(10,6) DEFAULT '0.000000',
`z` decimal(10,6) DEFAULT '0.000000',
`rotation` decimal(10,6) DEFAULT '0.000000',
`dimension` int(5) DEFAULT '0',
`interior` int(5) DEFAULT '0',
`deposit` tinyint(3) unsigned DEFAULT '0',
`limit` int(10) unsigned DEFAULT '5000',
UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC AUTO_INCREMENT=2 ;
--
-- Dumping data for table `atms`
--
INSERT INTO `atms` (`id`, `x`, `y`, `z`, `rotation`, `dimension`, `interior`, `deposit`, `limit`) VALUES
(1, 589.611328, -1253.958984, 17.800000, 21.000000, 0, 0, 1, 0);
-- --------------------------------------------------------
--
-- Table structure for table `characters`
--
CREATE TABLE IF NOT EXISTS `characters` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`charactername` text,
`account` int(11) DEFAULT '0',
`x` float DEFAULT '0',
`y` float DEFAULT '0',
`z` float DEFAULT '0',
`rotation` float DEFAULT '0',
`interior_id` int(5) DEFAULT '0',
`dimension_id` int(5) DEFAULT '0',
`health` float DEFAULT '100',
`armor` float DEFAULT '0',
`skin` int(3) DEFAULT '264',
`money` bigint(20) DEFAULT '250',
`gender` int(1) DEFAULT '0',
`cuffed` int(11) DEFAULT '0',
`duty` int(3) DEFAULT '0',
`cellnumber` int(30) DEFAULT '0',
`fightstyle` int(2) DEFAULT '4',
`pdjail` int(1) DEFAULT '0',
`pdjail_time` int(11) DEFAULT '0',
`job` int(3) DEFAULT '0',
`cked` int(1) DEFAULT '0',
`lastarea` text,
`age` int(3) DEFAULT '18',
`faction_id` int(11) DEFAULT '-1',
`faction_rank` int(2) DEFAULT '1',
`faction_perks` text,
`transport` int(1) DEFAULT '0',
`skincolor` int(1) DEFAULT '0',
`weight` int(3) DEFAULT '180',
`height` int(3) DEFAULT '180',
`description` text,
`deaths` int(11) DEFAULT '0',
`faction_leader` int(1) DEFAULT '0',
`fingerprint` text,
`casualskin` int(3) DEFAULT '0',
`bankmoney` bigint(20) DEFAULT '500',
`car_license` int(1) DEFAULT '0',
`gun_license` int(1) DEFAULT '0',
`tag` int(3) DEFAULT '1',
`hoursplayed` int(11) DEFAULT '0',
`pdjail_station` int(1) DEFAULT '0',
`timeinserver` int(2) DEFAULT '0',
`restrainedobj` int(11) DEFAULT '0',
`restrainedby` int(11) DEFAULT '0',
`dutyskin` int(3) DEFAULT '-1',
`fish` int(10) unsigned NOT NULL DEFAULT '0',
`truckingruns` int(10) unsigned NOT NULL DEFAULT '0',
`truckingwage` int(10) unsigned NOT NULL DEFAULT '0',
`phoneoff` tinyint(4) NOT NULL DEFAULT '0',
`blindfold` tinyint(4) NOT NULL DEFAULT '0',
`lang1` tinyint(2) DEFAULT '1',
`lang1skill` tinyint(3) DEFAULT '100',
`lang2` tinyint(2) DEFAULT '0',
`lang2skill` tinyint(3) DEFAULT '0',
`lang3` tinyint(2) DEFAULT '0',
`lang3skill` tinyint(3) DEFAULT '0',
`currlang` tinyint(1) DEFAULT '1',
`lastlogin` datetime DEFAULT NULL,
`creationdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`election_candidate` tinyint(3) unsigned NOT NULL DEFAULT '0',
`election_canvote` tinyint(3) unsigned NOT NULL DEFAULT '0',
`election_votedfor` int(10) unsigned NOT NULL DEFAULT '0',
`jobcontract` tinyint(3) unsigned NOT NULL DEFAULT '0',
`marriedto` int(10) unsigned NOT NULL DEFAULT '0',
`photos` int(10) unsigned NOT NULL DEFAULT '0',
`maxvehicles` int(4) unsigned NOT NULL DEFAULT '5',
`ck_info` text,
`alcohollevel` float NOT NULL,
`active` tinyint(1) NOT NULL DEFAULT '1',
UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC AUTO_INCREMENT=2 ;
--
-- Dumping data for table `characters`
--
INSERT INTO `characters` (`id`, `charactername`, `account`, `x`, `y`, `z`, `rotation`, `interior_id`, `dimension_id`, `health`, `armor`, `skin`, `money`, `gender`, `cuffed`, `duty`, `cellnumber`, `fightstyle`, `pdjail`, `pdjail_time`, `job`, `cked`, `lastarea`, `age`, `faction_id`, `faction_rank`, `faction_perks`, `transport`, `skincolor`, `weight`, `height`, `description`, `deaths`, `faction_leader`, `fingerprint`, `casualskin`, `bankmoney`, `car_license`, `gun_license`, `tag`, `hoursplayed`, `pdjail_station`, `timeinserver`, `restrainedobj`, `restrainedby`, `dutyskin`, `fish`, `truckingruns`, `truckingwage`, `phoneoff`, `blindfold`, `lang1`, `lang1skill`, `lang2`, `lang2skill`, `lang3`, `lang3skill`, `currlang`, `lastlogin`, `creationdate`, `election_candidate`, `election_canvote`, `election_votedfor`, `jobcontract`, `marriedto`, `photos`, `maxvehicles`, `ck_info`, `alcohollevel`, `active`) VALUES
(1, 'Rachel_Dawson', 1, 1342.99, -1697.49, 31.844, 337.211, 0, 0, 68.2353, 0, 93, 998925648, 1, 0, 0, 15001, 4, 0, 0, 0, 0, 'Commerce', 23, 125, 20, '[ [ 9, 15 ] ]', 0, 1, 63, 157, '__________________________________________________________________________\\n', 0, 1, 'F1E199764935A15FC9C9CB594FF7601E', 93, 0, 1, 0, 1, 2, 0, 61, 0, 0, -1, 0, 0, 0, 0, 0, 1, 100, 0, 0, 0, 0, 1, '2012-04-29 00:49:05', '2012-04-28 20:28:31', 0, 0, 0, 0, 0, 0, 5, NULL, 0, 1);
-- --------------------------------------------------------
--
-- Table structure for table `computers`
--
CREATE TABLE IF NOT EXISTS `computers` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`posX` float(10,5) NOT NULL,
`posY` float(10,5) NOT NULL,
`posZ` float(10,5) NOT NULL,
`rotX` float(10,5) NOT NULL,
`rotY` float(10,5) NOT NULL,
`rotZ` float(10,5) NOT NULL,
`interior` int( NOT NULL,
`dimension` int( NOT NULL,
`model` int( NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `dancers`
--
CREATE TABLE IF NOT EXISTS `dancers` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`x` float NOT NULL,
`y` float NOT NULL,
`z` float NOT NULL,
`rotation` float NOT NULL,
`skin` smallint(5) unsigned NOT NULL,
`type` tinyint(3) unsigned NOT NULL,
`interior` int(10) unsigned NOT NULL,
`dimension` int(10) unsigned NOT NULL,
`offset` tinyint(3) unsigned NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `donators`
--
CREATE TABLE IF NOT EXISTS `donators` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`accountID` int(11) NOT NULL,
`charID` int(11) NOT NULL DEFAULT '-1',
`perkID` int(4) NOT NULL,
`perkValue` varchar(10) NOT NULL DEFAULT '1',
`expirationDate` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `don_transactions`
--
CREATE TABLE IF NOT EXISTS `don_transactions` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`transaction_id` varchar(64) NOT NULL,
`donator_email` varchar(255) NOT NULL,
`amount` double NOT NULL,
`original_request` text,
`dt` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
`handled` smallint(1) DEFAULT '0',
`username` varchar(50) NOT NULL,
`realamount` double NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `don_transaction_failed`
--
CREATE TABLE IF NOT EXISTS `don_transaction_failed` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`output` text NOT NULL,
`ip` varchar(30) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `elevators`
--
CREATE TABLE IF NOT EXISTS `elevators` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`x` decimal(10,6) DEFAULT '0.000000',
`y` decimal(10,6) DEFAULT '0.000000',
`z` decimal(10,6) DEFAULT '0.000000',
`tpx` decimal(10,6) DEFAULT '0.000000',
`tpy` decimal(10,6) DEFAULT '0.000000',
`tpz` decimal(10,6) DEFAULT '0.000000',
`dimensionwithin` int(5) DEFAULT '0',
`interiorwithin` int(5) DEFAULT '0',
`dimension` int(5) DEFAULT '0',
`interior` int(5) DEFAULT '0',
`car` tinyint(3) unsigned DEFAULT '0',
`disabled` tinyint(3) unsigned DEFAULT '0',
UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `emailaccounts`
--
CREATE TABLE IF NOT EXISTS `emailaccounts` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`username` text,
`password` text,
`creator` int(11) DEFAULT NULL,
UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `emails`
--
CREATE TABLE IF NOT EXISTS `emails` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`date` datetime NOT NULL,
`sender` text,
`receiver` text,
`subject` text,
`message` text,
`inbox` int(1) NOT NULL DEFAULT '0',
`outbox` int(1) NOT NULL DEFAULT '0',
UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `factions`
--
CREATE TABLE IF NOT EXISTS `factions` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` text,
`bankbalance` bigint(20) DEFAULT NULL,
`type` int(11) DEFAULT NULL,
`rank_1` text,
`rank_2` text,
`rank_3` text,
`rank_4` text,
`rank_5` text,
`rank_6` text,
`rank_7` text,
`rank_8` text,
`rank_9` text,
`rank_10` text,
`rank_11` text,
`rank_12` text,
`rank_13` text,
`rank_14` text,
`rank_15` text,
`rank_16` text,
`rank_17` text,
`rank_18` text,
`rank_19` text,
`rank_20` text,
`wage_1` int(11) DEFAULT '100',
`wage_2` int(11) DEFAULT '100',
`wage_3` int(11) DEFAULT '100',
`wage_4` int(11) DEFAULT '100',
`wage_5` int(11) DEFAULT '100',
`wage_6` int(11) DEFAULT '100',
`wage_7` int(11) DEFAULT '100',
`wage_8` int(11) DEFAULT '100',
`wage_9` int(11) DEFAULT '100',
`wage_10` int(11) DEFAULT '100',
`wage_11` int(11) DEFAULT '100',
`wage_12` int(11) DEFAULT '100',
`wage_13` int(11) DEFAULT '100',
`wage_14` int(11) DEFAULT '100',
`wage_15` int(11) DEFAULT '100',
`wage_16` int(11) DEFAULT '100',
`wage_17` int(11) DEFAULT '100',
`wage_18` int(11) DEFAULT '100',
`wage_19` int(11) DEFAULT '100',
`wage_20` int(11) DEFAULT '100',
`motd` text,
`note` text,
UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC AUTO_INCREMENT=126 ;
--
-- Dumping data for table `factions`
--
INSERT 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`, `rank_16`, `rank_17`, `rank_18`, `rank_19`, `rank_20`, `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`, `wage_16`, `wage_17`, `wage_18`, `wage_19`, `wage_20`, `motd`, `note`) VALUES
(1, 'Los Santos Police Department', 0, 2, 'Suspended / On Leave', 'Student', 'Cadet', 'PO I', 'PO II', 'PO III', 'Detective I', 'Detective II', 'Detective III', 'Detective Seargeant', 'Seargeant I', 'Seargeant II', 'Lieutenant', 'Captain', 'Commander', 'Deputy Chief of Police', 'Assistant Chief of Police', 'Chief of Police', 'Dynamic Rank #19', 'Dynamic Rank #20', 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 'Welcome to the faction.', ''),
(2, 'Los Santos Medical Services', 0, 4, 'Dynamic Rank #1', 'Dynamic Rank #2', 'Dynamic Rank #3', 'Dynamic Rank #4', 'Dynamic Rank #5', 'Dynamic Rank #6', 'Dynamic Rank #7', 'Dynamic Rank #8', 'Dynamic Rank #9', 'Dynamic Rank #10', 'Dynamic Rank #11', 'Dynamic Rank #12', 'Dynamic Rank #13', 'Dynamic Rank #14', 'Dynamic Rank #15', 'Dynamic Rank #16', 'Dynamic Rank #17', 'Dynamic Rank #18', 'Dynamic Rank #19', 'Dynamic Rank #20', 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 'Welcome to the faction.', ''),
(3, 'Government of Los Santos', 509, 3, 'Dynamic Rank #1', 'Dynamic Rank #2', 'Dynamic Rank #3', 'Dynamic Rank #4', 'Dynamic Rank #5', 'Dynamic Rank #6', 'Dynamic Rank #7', 'Dynamic Rank #8', 'Dynamic Rank #9', 'Dynamic Rank #10', 'Dynamic Rank #11', 'Dynamic Rank #12', 'Dynamic Rank #13', 'Dynamic Rank #14', 'Dynamic Rank #15', 'Dynamic Rank #16', 'Dynamic Rank #17', 'Dynamic Rank #18', 'Dynamic Rank #19', 'Dynamic Rank #20', 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 'Welcome to the faction.', ''),
(4, 'Los Santos Fire Department', 0, 4, 'Dynamic Rank #1', 'Dynamic Rank #2', 'Dynamic Rank #3', 'Dynamic Rank #4', 'Dynamic Rank #5', 'Dynamic Rank #6', 'Dynamic Rank #7', 'Dynamic Rank #8', 'Dynamic Rank #9', 'Dynamic Rank #10', 'Dynamic Rank #11', 'Dynamic Rank #12', 'Dynamic Rank #13', 'Dynamic Rank #14', 'Dynamic Rank #15', 'Dynamic Rank #16', 'Dynamic Rank #17', 'Dynamic Rank #18', 'Dynamic Rank #19', 'Dynamic Rank #20', 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 'Welcome to the faction.', ''),
(20, 'San Andreas Network', 0, 6, 'Dynamic Rank #1', 'Dynamic Rank #2', 'Dynamic Rank #3', 'Dynamic Rank #4', 'Dynamic Rank #5', 'Dynamic Rank #6', 'Dynamic Rank #7', 'Dynamic Rank #8', 'Dynamic Rank #9', 'Dynamic Rank #10', 'Dynamic Rank #11', 'Dynamic Rank #12', 'Dynamic Rank #13', 'Dynamic Rank #14', 'Dynamic Rank #15', 'Dynamic Rank #16', 'Dynamic Rank #17', 'Dynamic Rank #18', 'Dynamic Rank #19', 'Dynamic Rank #20', 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 'Welcome to the faction.', ''),
(30, 'Hex Tow ''n Go', 0, 5, 'Dynamic Rank #1', 'Dynamic Rank #2', 'Dynamic Rank #3', 'Dynamic Rank #4', 'Dynamic Rank #5', 'Dynamic Rank #6', 'Dynamic Rank #7', 'Dynamic Rank #8', 'Dynamic Rank #9', 'Dynamic Rank #10', 'Dynamic Rank #11', 'Dynamic Rank #12', 'Dynamic Rank #13', 'Dynamic Rank #14', 'Dynamic Rank #15', 'Dynamic Rank #16', 'Dynamic Rank #17', 'Dynamic Rank #18', 'Dynamic Rank #19', 'Dynamic Rank #20', 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 'Welcome to the faction.', ''),
(125, 'Uni-Tel', 0, 5, 'Suspended', 'On Leave', 'Trainee Warehouse Worker', 'Trainee Salesman', 'Dynamic Rank #5', 'Dynamic Rank #6', 'Dynamic Rank #7', 'Dynamic Rank #8', 'Dynamic Rank #9', 'Dynamic Rank #10', 'Dynamic Rank #11', 'Dynamic Rank #12', 'Dynamic Rank #13', 'Dynamic Rank #14', 'Dynamic Rank #15', 'Dynamic Rank #16', 'Dynamic Rank #17', 'Dynamic Rank #18', 'Dynamic Rank #19', 'CEO', 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 'Welcome to the faction.', 'nub\n');
-- --------------------------------------------------------
--
-- Table structure for table `forgotdetails`
--
CREATE TABLE IF NOT EXISTS `forgotdetails` (
`uniquekey` text,
`account` int(11) DEFAULT '0',
`keytimestamp` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Table structure for table `friends`
--
CREATE TABLE IF NOT EXISTS `friends` (
`id` int(10) unsigned NOT NULL,
`friend` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`,`friend`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=latin1 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC;
-- --------------------------------------------------------
--
-- Table structure for table `fuelpeds`
--
CREATE TABLE IF NOT EXISTS `fuelpeds` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`posX` float NOT NULL,
`posY` float NOT NULL,
`posZ` float NOT NULL,
`rotZ` float NOT NULL,
`skin` int(3) NOT NULL,
`priceratio` int(3) NOT NULL,
`name` varchar(50) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
--
-- Dumping data for table `fuelpeds`
--
INSERT INTO `fuelpeds` (`id`, `posX`, `posY`, `posZ`, `rotZ`, `skin`, `priceratio`, `name`) VALUES
(1, 1941.5, -1769.29, 13.6406, 91.5477, 50, 5, 'Chad_Ballocks'),
(2, 1941.5, -1776.36, 13.6406, 92.8222, 50, 5, 'Robert_Edeworth');
-- --------------------------------------------------------
--
-- Table structure for table `fuelstations`
--
CREATE TABLE IF NOT EXISTS `fuelstations` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`x` decimal(10,6) DEFAULT '0.000000',
`y` decimal(10,6) DEFAULT '0.000000',
`z` decimal(10,6) DEFAULT '0.000000',
`interior` int(5) DEFAULT '0',
`dimension` int(5) DEFAULT '0',
UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `gates`
--
CREATE TABLE IF NOT EXISTS `gates` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`objectID` int(11) NOT NULL,
`startX` float NOT NULL,
`startY` float NOT NULL,
`startZ` float NOT NULL,
`startRX` float NOT NULL,
`startRY` float NOT NULL,
`startRZ` float NOT NULL,
`endX` float NOT NULL,
`endY` float NOT NULL,
`endZ` float NOT NULL,
`endRX` float NOT NULL,
`endRY` float NOT NULL,
`endRZ` float NOT NULL,
`gateType` tinyint(3) unsigned NOT NULL,
`autocloseTime` int(4) NOT NULL,
`movementTime` int(4) NOT NULL,
`objectDimension` int(11) NOT NULL,
`objectInterior` int(11) NOT NULL,
`gateSecurityParameters` text,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `interiors`
--
CREATE TABLE IF NOT EXISTS `interiors` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`x` float DEFAULT '0',
`y` float DEFAULT '0',
`z` float DEFAULT '0',
`type` int(1) DEFAULT '0',
`owner` int(11) DEFAULT '-1',
`locked` int(1) DEFAULT '0',
`cost` int(11) DEFAULT '0',
`name` text,
`interior` int(5) DEFAULT '0',
`interiorx` float DEFAULT '0',
`interiory` float DEFAULT '0',
`interiorz` float DEFAULT '0',
`dimensionwithin` int(5) DEFAULT '0',
`interiorwithin` int(5) DEFAULT '0',
`angle` float DEFAULT '0',
`angleexit` float DEFAULT '0',
`max_items` int(5) DEFAULT '0',
`rentable` int(1) DEFAULT '0',
`rent` int(11) DEFAULT '0',
`money` int(11) DEFAULT '0',
`items` text,
`items_values` text,
`tennant` int(11) DEFAULT '-1',
`supplies` int(11) DEFAULT '100',
`safepositionX` float DEFAULT NULL,
`safepositionY` float DEFAULT NULL,
`safepositionZ` float DEFAULT NULL,
`safepositionRZ` float DEFAULT NULL,
`fee` int(10) unsigned DEFAULT '0',
`disabled` tinyint(3) unsigned DEFAULT '0',
`lastused` datetime DEFAULT NULL,
UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC AUTO_INCREMENT=9 ;
--
-- Dumping data for table `interiors`
--
INSERT INTO `interiors` (`id`, `x`, `y`, `z`, `type`, `owner`, `locked`, `cost`, `name`, `interior`, `interiorx`, `interiory`, `interiorz`, `dimensionwithin`, `interiorwithin`, `angle`, `angleexit`, `max_items`, `rentable`, `rent`, `money`, `items`, `items_values`, `tennant`, `supplies`, `safepositionX`, `safepositionY`, `safepositionZ`, `safepositionRZ`, `fee`, `disabled`, `lastused`) VALUES
(1, 1555.07, -1675.63, 16.1953, 2, 0, 0, 0, 'Los Santos Police Department', 10, 246.37, 107.51, 1003.21, 0, 0, 0, 271.073, 0, 0, 0, 0, NULL, NULL, -1, 100, NULL, NULL, NULL, NULL, 0, 0, '2012-04-29 00:00:00'),
(2, 1481.02, -1771.63, 18.7958, 2, 0, 0, 0, 'City Hall', 3, 390.44, 173.91, 1008.38, 0, 0, 90, 271.073, 0, 0, 0, 0, NULL, NULL, -1, 100, NULL, NULL, NULL, NULL, 0, 0, '2012-04-28 21:39:05'),
(3, 2037.57, -1404.76, 17.2511, 2, 0, 0, 0, 'Los Santos Emergency Medical Services', 3, 390.44, 173.91, 1008.38, 0, 0, 90, 273.556, 0, 0, 0, 0, NULL, NULL, -1, 100, NULL, NULL, NULL, NULL, 0, 0, NULL),
(4, 1712.27, -1129.74, 24.0859, 2, 0, 0, 0, 'Fire Department | Station 60', 3, 390.44, 173.91, 1008.38, 0, 0, 90, 0.326843, 0, 0, 0, 0, NULL, NULL, -1, 100, NULL, NULL, NULL, NULL, 0, 0, NULL),
(5, 1487.73, -1010.26, 26.8438, 1, -1, 1, 0, 'San Andreas Network', 3, 390.44, 173.91, 1008.38, 0, 0, 90, 0.639954, 0, 0, 0, 0, NULL, NULL, -1, 100, NULL, NULL, NULL, NULL, 0, 0, NULL),
(6, 1494.04, -2386.69, 13.5469, 1, -1, 1, 0, 'Los Santos International Airport', 3, 390.44, 173.91, 1008.38, 0, 0, 178.907, 181.434, 0, 0, 0, 0, NULL, NULL, -1, 100, NULL, NULL, NULL, NULL, 0, 0, NULL),
(7, 1111.5, -1795.56, 16.5938, 2, 0, 0, 0, 'Department of motor vehicles', 5, 226.56, 1114.19, 1080.99, 0, 0, 270, 270.787, 0, 0, 0, 0, NULL, NULL, -1, 100, NULL, NULL, NULL, NULL, 0, 0, '2012-04-28 21:51:46'),
(8, 914.195, -1004.17, 37.9887, 1, 1, 0, 0, 'Uni-Tel', 32, 2079.89, 477.98, 41.85, 0, 0, 0, 177.1, 0, 0, 0, 0, NULL, NULL, -1, 100, NULL, NULL, NULL, NULL, 0, 0, '2012-04-28 21:52:44');
-- --------------------------------------------------------
--
-- Table structure for table `items`
--
CREATE TABLE IF NOT EXISTS `items` (
`index` int(10) unsigned NOT NULL AUTO_INCREMENT,
`type` tinyint(3) unsigned NOT NULL,
`owner` int(10) unsigned NOT NULL,
`itemID` int(10) NOT NULL,
`itemValue` text NOT NULL,
PRIMARY KEY (`index`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC AUTO_INCREMENT=14 ;
--
-- Dumping data for table `items`
--
INSERT INTO `items` (`index`, `type`, `owner`, `itemID`, `itemValue`) VALUES
(1, 1, 1, 16, '93'),
(2, 1, 1, 17, '1'),
(3, 1, 1, 18, '1'),
(4, 1, 1, 3, '1'),
(5, 1, 1, 5, '8'),
(6, 1, 1, 3, '2'),
(8, 1, 1, 77, '1'),
(9, 1, 1, 115, '4:1:Knife'),
(10, 1, 1, 71, '125'),
(11, 1, 1, 3, '3'),
(12, 1, 1, 3, '4'),
(13, 1, 1, 119, '#01 - CEO - R.Dawson');
-- --------------------------------------------------------
--
-- Table structure for table `logtable`
--
CREATE TABLE IF NOT EXISTS `logtable` (
`time` datetime NOT NULL,
`action` int(2) NOT NULL,
`source` varchar(12) NOT NULL,
`affected` text NOT NULL,
`content` text
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Table structure for table `lottery`
--
CREATE TABLE IF NOT EXISTS `lottery` (
`characterid` int(255) NOT NULL,
`ticketnumber` int(3) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC;
-- --------------------------------------------------------
--
-- Table structure for table `mdcusers`
--
CREATE TABLE IF NOT EXISTS `mdcusers` (
`user_name` varchar(20) NOT NULL,
`password` varchar(20) NOT NULL DEFAULT '123',
`high_command` int(1) DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC;
-- --------------------------------------------------------
--
-- Table structure for table `objects`
--
CREATE TABLE IF NOT EXISTS `objects` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`model` int(6) NOT NULL DEFAULT '0',
`posX` float(12,7) NOT NULL DEFAULT '0.0000000',
`posY` float(12,7) NOT NULL DEFAULT '0.0000000',
`posZ` float(12,7) NOT NULL DEFAULT '0.0000000',
`rotX` float(12,7) NOT NULL DEFAULT '0.0000000',
`rotY` float(12,7) NOT NULL DEFAULT '0.0000000',
`rotZ` float(12,7) NOT NULL DEFAULT '0.0000000',
`interior` int(5) NOT NULL,
`dimension` int(5) NOT NULL,
`comment` varchar(50) DEFAULT NULL,
`solid` int(1) NOT NULL DEFAULT '1',
`doublesided` int(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `paynspray`
--
CREATE TABLE IF NOT EXISTS `paynspray` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`x` decimal(10,6) DEFAULT '0.000000',
`y` decimal(10,6) DEFAULT '0.000000',
`z` decimal(10,6) DEFAULT '0.000000',
`dimension` int(5) DEFAULT '0',
`interior` int(5) DEFAULT '0',
UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC AUTO_INCREMENT=9 ;
--
-- Dumping data for table `paynspray`
--
INSERT INTO `paynspray` (`id`, `x`, `y`, `z`, `dimension`, `interior`) VALUES
(1, 487.242188, -1741.555664, 10.832272, 0, 0),
(2, 1024.963867, -1023.606445, 31.805906, 0, 0),
(3, 2063.466797, -1830.992188, 13.251081, 0, 0),
(4, 1545.098633, -1663.876953, 5.890625, 0, 0),
(5, 720.349609, -456.050781, 16.335938, 0, 0),
(6, 2811.736328, -2153.569336, 1583.233887, 839, 2),
(7, 1911.286133, -1776.229492, 12.952327, 0, 0),
(8, 1517.291992, -1672.346680, 29.099415, 0, 0);
-- --------------------------------------------------------
--
-- Table structure for table `phone_contacts`
--
CREATE TABLE IF NOT EXISTS `phone_contacts` (
`phone` int(11) NOT NULL,
`entryName` varchar(30) NOT NULL,
`entryNumber` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Table structure for table `phone_settings`
--
CREATE TABLE IF NOT EXISTS `phone_settings` (
`phonenumber` int(1) NOT NULL,
`turnedon` smallint(1) unsigned NOT NULL DEFAULT '1',
`secretnumber` smallint(1) unsigned NOT NULL DEFAULT '0',
`ringtone` smallint(1) NOT NULL DEFAULT '1',
`phonebook` varchar(40) DEFAULT NULL,
`boughtby` int(11) NOT NULL DEFAULT '-1',
PRIMARY KEY (`phonenumber`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `phone_settings`
--
INSERT INTO `phone_settings` (`phonenumber`, `turnedon`, `secretnumber`, `ringtone`, `phonebook`, `boughtby`) VALUES
(298, 1, 0, 1, NULL, -1);
-- --------------------------------------------------------
--
-- Table structure for table `publicphones`
--
CREATE TABLE IF NOT EXISTS `publicphones` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`x` float NOT NULL,
`y` float NOT NULL,
`z` float NOT NULL,
`dimension` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `settings`
--
CREATE TABLE IF NOT EXISTS `settings` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` text,
`value` text,
UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC AUTO_INCREMENT=9 ;
--
-- Dumping data for table `settings`
--
INSERT INTO `settings` (`id`, `name`, `value`) VALUES
(1, 'motd', 'Carmods are back || Hit F2 if you need the assistance of an admin.'),
(2, 'amotd', 'Found any bugs? Report them to Jector(Rachel Dawson) or Amir Stewart'),
(3, 'globalsupplies', '7920'),
(4, 'lotteryjackpot', '72060'),
(5, 'welfare', '200'),
(6, 'tax', '10'),
(7, 'incometax', '10'),
(8, 'garagestates', '[ { "1": true, "2": true, "3": false, "4": true, "5": true, "6": true, "7": true, "8": true, "9": true, "10": true, "11": true, "12": true, "13": false, "14": false, "15": true, "16": true, "17": true, "18": true, "19": true, "20": true, "21": true, "22": true, "23": true, "24": true, "25": true, "26": true, "27": true, "28": true, "29": true, "30": true, "31": true, "32": true, "33": true, "34": true, "35": true, "36": true, "37": true, "38": true, "39": true, "40": true, "41": true, "42": true, "43": true, "44": true, "45": true, "46": true, "47": true, "48": true, "49": true, "0": true } ]');
-- --------------------------------------------------------
--
-- Table structure for table `shops`
--
CREATE TABLE IF NOT EXISTS `shops` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`x` float DEFAULT '0',
`y` float DEFAULT '0',
`z` float DEFAULT '0',
`dimension` int(5) DEFAULT '0',
`interior` int(5) DEFAULT '0',
`shoptype` tinyint(4) DEFAULT '0',
`rotation` float NOT NULL DEFAULT '0',
`skin` int(11) DEFAULT '-1',
UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `speedcams`
--
CREATE TABLE IF NOT EXISTS `speedcams` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`x` float(11,7) NOT NULL DEFAULT '0.0000000',
`y` float(11,7) NOT NULL DEFAULT '0.0000000',
`z` float(11,7) NOT NULL DEFAULT '0.0000000',
`interior` int(3) NOT NULL DEFAULT '0' COMMENT 'Stores the location of the pernament speedcams',
`dimension` int(5) NOT NULL DEFAULT '0',
`maxspeed` int(4) NOT NULL DEFAULT '120',
`radius` int(4) NOT NULL DEFAULT '2',
`enabled` smallint(1) DEFAULT '1',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;
--
-- Dumping data for table `speedcams`
--
INSERT INTO `speedcams` (`id`, `x`, `y`, `z`, `interior`, `dimension`, `maxspeed`, `radius`, `enabled`) VALUES
(2, 1349.7988281, -1399.8105469, 13.3075285, 0, 0, 95, 24, 1),
(3, 1592.7099609, -1732.2382812, 13.3828125, 0, 0, 65, 16, 1);
-- --------------------------------------------------------
--
-- Table structure for table `speedingviolations`
--
CREATE TABLE IF NOT EXISTS `speedingviolations` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`carID` int(11) NOT NULL,
`time` datetime NOT NULL,
`speed` int(5) NOT NULL,
`area` varchar(50) NOT NULL,
`personVisible` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `suspectcrime`
--
CREATE TABLE IF NOT EXISTS `suspectcrime` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`suspect_name` text,
`time` text,
`date` text,
`officers` text,
`ticket` int(11) DEFAULT NULL,
`arrest` int(11) DEFAULT NULL,
`fine` int(11) DEFAULT NULL,
`ticket_price` text,
`arrest_price` text,
`fine_price` text,
`illegal_items` text,
`details` text,
`done_by` text,
UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `suspectdetails`
--
CREATE TABLE IF NOT EXISTS `suspectdetails` (
`suspect_name` text,
`birth` text,
`gender` text,
`ethnicy` text,
`cell` int(5) DEFAULT '0',
`occupation` text,
`address` text,
`other` text,
`is_wanted` int(1) DEFAULT '0',
`wanted_reason` text,
`wanted_punishment` text,
`wanted_by` text,
`photo` text,
`done_by` text
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Table structure for table `tags`
--
CREATE TABLE IF NOT EXISTS `tags` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`x` decimal(10,6) DEFAULT NULL,
`y` decimal(10,6) DEFAULT NULL,
`z` decimal(10,6) DEFAULT NULL,
`interior` int(5) DEFAULT NULL,
`dimension` int(5) DEFAULT NULL,
`rx` decimal(10,6) DEFAULT NULL,
`ry` decimal(10,6) DEFAULT NULL,
`rz` decimal(10,6) DEFAULT NULL,
`modelid` int(5) DEFAULT NULL,
`creationdate` datetime DEFAULT NULL,
`creator` int(11) NOT NULL DEFAULT '-1',
UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `tc_comments`
--
CREATE TABLE IF NOT EXISTS `tc_comments` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`poster` int(11) NOT NULL,
`ip` varchar(50) NOT NULL,
`message` text NOT NULL,
`posted` int(25) NOT NULL,
`type` int(1) NOT NULL,
`ticket` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `tc_tickets`
--
CREATE TABLE IF NOT EXISTS `tc_tickets` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`creator` int(11) NOT NULL,
`posted` int(25) NOT NULL,
`subject` varchar(100) NOT NULL,
`message` text NOT NULL,
`status` int(1) NOT NULL,
`lastpost` int(25) NOT NULL,
`assigned` int(11) NOT NULL,
`IP` varchar(50) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `tempinteriors`
--
CREATE TABLE IF NOT EXISTS `tempinteriors` (
`id` int(11) NOT NULL,
`posX` float NOT NULL,
`posY` float DEFAULT NULL,
`posZ` float DEFAULT NULL,
`interior` int(5) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Table structure for table `tempobjects`
--
CREATE TABLE IF NOT EXISTS `tempobjects` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`model` int(6) NOT NULL DEFAULT '0',
`posX` float(12,7) NOT NULL DEFAULT '0.0000000',
`posY` float(12,7) NOT NULL DEFAULT '0.0000000',
`posZ` float(12,7) NOT NULL DEFAULT '0.0000000',
`rotX` float(12,7) NOT NULL DEFAULT '0.0000000',
`rotY` float(12,7) NOT NULL DEFAULT '0.0000000',
`rotZ` float(12,7) NOT NULL DEFAULT '0.0000000',
`interior` int(5) NOT NULL,
`dimension` int(5) NOT NULL,
`comment` varchar(50) DEFAULT NULL,
`solid` int(1) NOT NULL DEFAULT '1',
`doublesided` int(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `vehicles`
--
CREATE TABLE IF NOT EXISTS `vehicles` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`model` int(3) DEFAULT '0',
`x` decimal(10,6) DEFAULT '0.000000',
`y` decimal(10,6) DEFAULT '0.000000',
`z` decimal(10,6) DEFAULT '0.000000',
`rotx` decimal(10,6) DEFAULT '0.000000',
`roty` decimal(10,6) DEFAULT '0.000000',
`rotz` decimal(10,6) DEFAULT '0.000000',
`currx` decimal(10,6) DEFAULT '0.000000',
`curry` decimal(10,6) DEFAULT '0.000000',
`currz` decimal(10,6) DEFAULT '0.000000',
`currrx` decimal(10,6) DEFAULT '0.000000',
`currry` decimal(10,6) DEFAULT '0.000000',
`currrz` decimal(10,6) DEFAULT '0.000000',
`fuel` int(3) DEFAULT '100',
`engine` int(1) DEFAULT '0',
`locked` int(1) DEFAULT '0',
`lights` int(1) DEFAULT '0',
`sirens` int(1) DEFAULT '0',
`paintjob` int(11) DEFAULT '0',
`hp` float DEFAULT '1000',
`color1` varchar(50) DEFAULT '0',
`color2` varchar(50) DEFAULT '0',
`color3` varchar(50) DEFAULT '0',
`color4` varchar(50) DEFAULT '0',
`plate` text,
`faction` int(11) DEFAULT '-1',
`owner` int(11) DEFAULT '-1',
`job` int(11) DEFAULT '-1',
`tintedwindows` int(1) DEFAULT '0',
`dimension` int(5) DEFAULT '0',
`interior` int(5) DEFAULT '0',
`currdimension` int(5) DEFAULT '0',
`currinterior` int(5) DEFAULT '0',
`enginebroke` int(1) DEFAULT '0',
`items` text,
`itemvalues` text,
`Impounded` int(3) DEFAULT '0',
`handbrake` int(1) DEFAULT '0',
`safepositionX` float DEFAULT NULL,
`safepositionY` float DEFAULT NULL,
`safepositionZ` float DEFAULT NULL,
`safepositionRZ` float DEFAULT NULL,
`upgrades` varchar(150) DEFAULT '[ [ 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 ] ]',
`wheelStates` varchar(30) DEFAULT '[ [ 0, 0, 0, 0 ] ]',
`panelStates` varchar(40) DEFAULT '[ [ 0, 0, 0, 0, 0, 0, 0 ] ]',
`doorStates` varchar(30) DEFAULT '[ [ 0, 0, 0, 0, 0, 0 ] ]',
`odometer` int(15) DEFAULT '0',
`headlights` varchar(30) DEFAULT '[ [ 255, 255, 255 ] ]',
`variant1` tinyint(3) unsigned NOT NULL DEFAULT '255',
`variant2` tinyint(3) unsigned NOT NULL DEFAULT '255',
UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC AUTO_INCREMENT=5 ;
--
-- Dumping data for table `vehicles`
--
INSERT INTO `vehicles` (`id`, `model`, `x`, `y`, `z`, `rotx`, `roty`, `rotz`, `currx`, `curry`, `currz`, `currrx`, `currry`, `currrz`, `fuel`, `engine`, `locked`, `lights`, `sirens`, `paintjob`, `hp`, `color1`, `color2`, `color3`, `color4`, `plate`, `faction`, `owner`, `job`, `tintedwindows`, `dimension`, `interior`, `currdimension`, `currinterior`, `enginebroke`, `items`, `itemvalues`, `Impounded`, `handbrake`, `safepositionX`, `safepositionY`, `safepositionZ`, `safepositionRZ`, `upgrades`, `wheelStates`, `panelStates`, `doorStates`, `odometer`, `headlights`, `variant1`, `variant2`) VALUES
(1, 409, 541.406250, -1291.089844, 17.080635, 0.000000, 0.000000, 29.998169, 1100.066406, -1802.304688, 13.989842, 13.222046, 2.960815, 260.035400, 99, 1, 0, 1, 0, 0, 912.82, '[ [ 1, 1, 0 ] ]', '[ [ 0 ] ]', '[ [ ] ]', '[ [ ] ]', 'KX2 5692', -1, 1, -1, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, '[ [ 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 ] ]', '[ [ 0, 0, 0, 0 ] ]', '[ [ 0, 2, 0, 0, 0, 2, 0 ] ]', '[ [ 2, 0, 0, 0, 0, 0 ] ]', 1072, '[ [ 255, 255, 255 ] ]', 255, 255),
(2, 560, 2136.503906, -1145.796875, 24.661764, 0.000000, 0.000000, 337.999878, 1966.869141, -1780.372070, -105.339905, 13.666992, 32.568970, 102.260742, 92, 1, 0, 1, 0, 0, 966.056, '[ [ 17, 1, 17 ] ]', '[ [ 1 ] ]', '[ [ ] ]', '[ [ ] ]', 'IT5 9322', -1, 1, -1, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, '[ [ 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 ] ]', '[ [ 0, 0, 0, 0 ] ]', '[ [ 0, 0, 0, 0, 0, 0, 1 ] ]', '[ [ 0, 2, 0, 0, 0, 0 ] ]', 1819, '[ [ 255, 255, 255 ] ]', 255, 255),
(3, 480, 541.405273, -1291.088867, 17.022371, 359.774780, 0.000000, 29.998169, 541.405273, -1291.088867, 17.022371, 0.000000, 0.000000, 29.998169, 100, 0, 1, 0, 0, 0, 1000, '[ [ 73, 45, 73 ] ]', '[ [ 45 ] ]', '[ [ ] ]', '[ [ ] ]', 'RD2 2212', -1, 1, -1, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, '[ [ 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 ] ]', '[ [ 0, 0, 0, 0 ] ]', '[ [ 0, 0, 0, 0, 0, 0, 0 ] ]', '[ [ 0, 0, 0, 0, 0, 0 ] ]', 0, '[ [ 255, 255, 255 ] ]', 255, 255),
(4, 480, 547.405273, -1291.088867, 17.028622, 359.774780, 0.000000, 29.998169, 1943.609375, -1770.748047, 13.238859, 2.460938, 4.279175, 56.200562, 94, 1, 0, 1, 0, 0, 421.49, '[ [ 6, 6, 6 ] ]', '[ [ 6 ] ]', '[ [ ] ]', '[ [ ] ]', 'IN9 6294', -1, 1, -1, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, '[ [ 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 ] ]', '[ [ 0, 0, 0, 0 ] ]', '[ [ 1, 0, 0, 0, 2, 2, 1 ] ]', '[ [ 2, 2, 2, 2, 0, 0 ] ]', 2169, '[ [ 255, 255, 255 ] ]', 255, 255);
-- --------------------------------------------------------
--
-- Table structure for table `wiretransfers`
--
CREATE TABLE IF NOT EXISTS `wiretransfers` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`from` int(11) NOT NULL,
`to` int(11) NOT NULL,
`amount` int(11) NOT NULL,
`reason` text NOT NULL,
`time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`type` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;
--
-- Dumping data for table `wiretransfers`
--
INSERT INTO `wiretransfers` (`id`, `from`, `to`, `amount`, `reason`, `time`, `type`) VALUES
(1, -57, 1, 2, 'BANKINTEREST', '2012-04-28 23:00:22', 6),
(2, 1, -3, 502, 'VEHICLETAX', '2012-04-28 23:00:22', 6),
(3, 1, -3, 0, 'VEHICLETAX', '2012-04-29 00:00:22', 6);
-- --------------------------------------------------------
--
-- Table structure for table `worlditems`
--
CREATE TABLE IF NOT EXISTS `worlditems` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`itemid` int(11) DEFAULT '0',
`itemvalue` text,
`x` float DEFAULT '0',
`y` float DEFAULT '0',
`z` float DEFAULT '0',
`dimension` int(5) DEFAULT '0',
`interior` int(5) DEFAULT '0',
`creationdate` datetime DEFAULT NULL,
`rz` float DEFAULT '0',
`creator` int(10) unsigned DEFAULT '0',
`protected` int(11) NOT NULL DEFAULT '0',
UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;