/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;

CREATE DATABASE IF NOT EXISTS `SAMP_1` /*!40100 DEFAULT CHARACTER SET utf8 */;
USE `SAMP_1`;


CREATE TABLE IF NOT EXISTS `bans` (
  `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `ip` VARCHAR(15) NOT NULL,
  `name` VARCHAR(24) NOT NULL,
  `by` VARCHAR(255) NOT NULL,
  `date` VARCHAR(255) NOT NULL,
  `reason` VARCHAR(255) NOT NULL,
  UNIQUE KEY `id` (`id`),
  UNIQUE KEY `ip` (`ip`,`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



CREATE TABLE IF NOT EXISTS `boxer` (
  `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `wins` INT(11) NOT NULL,
  `name` VARCHAR(255) NOT NULL,
  `loses` INT(11) NOT NULL,
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



CREATE TABLE IF NOT EXISTS `business` (
  `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `owned` tinyint(4) NOT NULL DEFAULT '0',
  `ownerid` tinyint(1) DEFAULT '0',
  `owner` VARCHAR(255) NOT NULL DEFAULT 'The State',
  `message` VARCHAR(255) NOT NULL,
  `extortionby` VARCHAR(255) NOT NULL DEFAULT 'No-one',
  `enX` FLOAT DEFAULT NULL,
  `enY` FLOAT DEFAULT NULL,
  `enZ` FLOAT DEFAULT NULL,
  `exX` FLOAT DEFAULT NULL,
  `exY` FLOAT DEFAULT NULL,
  `exZ` FLOAT DEFAULT NULL,
  `levelneeded` INT(4) NOT NULL DEFAULT '0',
  `price` INT(11) NOT NULL DEFAULT '0',
  `entrancecost` INT(11) NOT NULL DEFAULT '0',
  `till` INT(11) NOT NULL DEFAULT '0',
  `locked` tinyint(1) NOT NULL DEFAULT '0',
  `interior` INT(3) NOT NULL DEFAULT '0',
  `products` INT(11) NOT NULL DEFAULT '0',
  `maxproducts` INT(11) NOT NULL DEFAULT '0',
  `productprice` INT(11) NOT NULL DEFAULT '0',
  `virtualworld` INT(5) NOT NULL DEFAULT '0',
  `interiornr` INT(5) NOT NULL DEFAULT '0',
  `issbizz` tinyint(1) NOT NULL DEFAULT '0',
  UNIQUE KEY `id` (`id`),
  KEY `issbizz` (`issbizz`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



CREATE TABLE IF NOT EXISTS `channels` (
  `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `admin` VARCHAR(255) NOT NULL DEFAULT 'No-one',
  `motd` VARCHAR(255) NOT NULL,
  `password` VARCHAR(255) NOT NULL DEFAULT 'NoPass',
  `needpass` tinyint(1) NOT NULL DEFAULT '0',
  `lock` tinyint(1) NOT NULL DEFAULT '0',
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



CREATE TABLE IF NOT EXISTS `character_kills` (
  `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `sendername` VARCHAR(255) NOT NULL,
  `giveplayer` VARCHAR(255) NOT NULL,
  `used` tinyint(1) NOT NULL DEFAULT '0',
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



CREATE TABLE IF NOT EXISTS `drugs` (
  `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `planter` VARCHAR(25) NOT NULL,
  `posx` FLOAT NOT NULL,
  `posy` FLOAT NOT NULL,
  `posz` FLOAT NOT NULL,
  `time` INT(11) NOT NULL,
  `planted` INT(11) NOT NULL,
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



CREATE TABLE IF NOT EXISTS `events` (
  `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `value` VARCHAR(255) NOT NULL,
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



CREATE TABLE IF NOT EXISTS `families` (
  `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(255) NOT NULL DEFAULT '',
  `motd` VARCHAR(255) NOT NULL,
  `color` INT(11) NOT NULL DEFAULT '-1',
  `leader` VARCHAR(255) NOT NULL,
  `members` INT(11) NOT NULL DEFAULT '0',
  `spawnX` FLOAT NOT NULL,
  `spawnY` FLOAT NOT NULL,
  `spawnZ` FLOAT NOT NULL,
  `spawnA` FLOAT NOT NULL,
  `interior` INT(11) NOT NULL DEFAULT '0',
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



CREATE TABLE IF NOT EXISTS `logs` (
  `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `key` VARCHAR(255) NOT NULL,
  `message` VARCHAR(255) NOT NULL,
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



CREATE TABLE IF NOT EXISTS `motd` (
  `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `value` VARCHAR(255) NOT NULL,
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



CREATE TABLE IF NOT EXISTS `papers` (
  `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `maker` VARCHAR(255) NOT NULL,
  `title` VARCHAR(255) NOT NULL,
  `safesaving` tinyint(1) NOT NULL DEFAULT '1',
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



CREATE TABLE IF NOT EXISTS `paper_messages` (
  `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `pid` BIGINT(20) UNSIGNED NOT NULL,
  `message` VARCHAR(255) NOT NULL,
  UNIQUE KEY `id` (`id`),
  KEY `pid` (`pid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



CREATE TABLE IF NOT EXISTS `properties` (
  `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `enX` FLOAT DEFAULT NULL,
  `enY` FLOAT DEFAULT NULL,
  `enZ` FLOAT DEFAULT NULL,
  `exX` FLOAT DEFAULT NULL,
  `exY` FLOAT DEFAULT NULL,
  `exZ` FLOAT DEFAULT NULL,
  `hlX` INT(11) DEFAULT NULL,
  `hlY` INT(11) DEFAULT NULL,
  `hlZ` INT(11) DEFAULT NULL,
  `arX` INT(11) DEFAULT NULL,
  `arY` INT(11) DEFAULT NULL,
  `arZ` INT(11) DEFAULT NULL,
  `owner` VARCHAR(255) DEFAULT NULL,
  `description` VARCHAR(255) DEFAULT NULL,
  `price` INT(11) DEFAULT NULL,
  `health` tinyint(1) DEFAULT NULL,
  `armour` tinyint(1) DEFAULT NULL,
  `interior` INT(5) DEFAULT NULL,
  `locked` tinyint(1) DEFAULT NULL,
  `owned` tinyint(1) DEFAULT NULL,
  `rooms` INT(11) DEFAULT NULL,
  `rentable` tinyint(1) DEFAULT NULL,
  `rentprice` INT(11) DEFAULT NULL,
  `takings` INT(11) DEFAULT NULL,
  `levelneeded` INT(4) DEFAULT NULL,
  `world` INT(11) DEFAULT NULL,
  `drugs` INT(11) DEFAULT NULL,
  `materials` INT(11) DEFAULT NULL,
  `message` VARCHAR(255) DEFAULT NULL,
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



CREATE TABLE IF NOT EXISTS `property_weapons` (
  `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `pid` BIGINT(20) UNSIGNED NOT NULL,
  `weapon` INT(11) NOT NULL DEFAULT '0',
  `ammo` INT(11) NOT NULL DEFAULT '0',
  UNIQUE KEY `id` (`id`),
  KEY `pid` (`pid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



CREATE TABLE IF NOT EXISTS `security` (
  `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `offset` INT(11) NOT NULL,
  `value` INT(11) NOT NULL,
  UNIQUE KEY `id` (`id`),
  UNIQUE KEY `offset` (`offset`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



CREATE TABLE IF NOT EXISTS `simple_values` (
  `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `key` VARCHAR(255) NOT NULL,
  `offset` INT(11) NOT NULL,
  `value` INT(11) NOT NULL,
  UNIQUE KEY `id` (`id`),
  KEY `offset` (`offset`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



CREATE TABLE IF NOT EXISTS `trunks` (
  `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `armour` FLOAT NOT NULL,
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



CREATE TABLE IF NOT EXISTS `trunk_weapons` (
  `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `tid` BIGINT(20) UNSIGNED NOT NULL,
  `weapon` INT(11) NOT NULL,
  `ammo` INT(11) NOT NULL,
  UNIQUE KEY `id` (`id`),
  KEY `tid` (`tid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



CREATE TABLE IF NOT EXISTS `users` (
  `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(24) NOT NULL,
  `password` VARCHAR(129) NOT NULL,
  `level` INT(11) DEFAULT '1',
  `spawn` INT(11) DEFAULT '9',
  `vip` INT(11) DEFAULT NULL,
  `viptokens` INT(11) NOT NULL DEFAULT '0',
  `testerlevel` INT(11) DEFAULT NULL,
  `helperlevel` INT(11) DEFAULT NULL,
  `adminlevel` INT(11) DEFAULT NULL,
  `regularrank` INT(11) DEFAULT NULL,
  `upgradepoints` INT(11) DEFAULT NULL,
  `connectedtime` INT(11) DEFAULT NULL,
  `registered` tinyint(1) DEFAULT NULL,
  `sex` INT(2) DEFAULT NULL,
  `age` INT(4) DEFAULT NULL,
  `gps` tinyint(1) DEFAULT NULL,
  `origin` INT(2) DEFAULT NULL,
  `ck` tinyint(1) DEFAULT NULL,
  `muted` tinyint(1) DEFAULT NULL,
  `frozen` tinyint(1) DEFAULT NULL,
  `blind` tinyint(1) DEFAULT NULL,
  `respect` INT(11) DEFAULT NULL,
  `money` INT(20) DEFAULT NULL,
  `bank` INT(20) DEFAULT NULL,
  `crimes` INT(11) DEFAULT NULL,
  `crimereason` VARCHAR(255) DEFAULT NULL,
  `wantedlevel` INT(11) DEFAULT NULL,
  `kills` INT(11) DEFAULT NULL,
  `deaths` INT(11) DEFAULT NULL,
  `arrested` tinyint(1) DEFAULT NULL,
  `wanteddeath` INT(11) DEFAULT NULL,
  `phonebook` INT(11) DEFAULT NULL,
  `lottonr` INT(11) DEFAULT NULL,
  `fishes` INT(11) DEFAULT NULL,
  `biggestfish` INT(11) DEFAULT NULL,
  `job` tinyint(1) DEFAULT NULL,
  `paycheck` INT(11) DEFAULT NULL,
  `headvalue` INT(11) DEFAULT NULL,
  `jailed` tinyint(1) DEFAULT NULL,
  `jailtime` INT(11) DEFAULT NULL,
  `canrobtime` INT(11) DEFAULT NULL,
  `materials` INT(11) DEFAULT NULL,
  `drugs` INT(11) DEFAULT NULL,
  `leader` INT(11) DEFAULT NULL,
  `member` INT(11) DEFAULT NULL,
  `fmember` INT(11) DEFAULT NULL,
  `rank` INT(11) DEFAULT NULL,
  `charac` INT(11) DEFAULT NULL,
  `contracttime` INT(11) DEFAULT NULL,
  `health` FLOAT DEFAULT '50',
  `armour` FLOAT DEFAULT NULL,
  `interior` INT(11) DEFAULT NULL,
  `interiornr` INT(11) DEFAULT NULL,
  `local` INT(11) DEFAULT NULL,
  `team` INT(11) DEFAULT NULL,
  `model` INT(11) DEFAULT NULL,
  `phonenr` INT(11) DEFAULT NULL,
  `car` INT(11) DEFAULT NULL,
  `car2` INT(11) DEFAULT NULL,
  `house` INT(11) DEFAULT NULL,
  `bizz` INT(11) DEFAULT NULL,
  `posX` INT(11) DEFAULT NULL,
  `posY` INT(11) DEFAULT NULL,
  `posZ` INT(11) DEFAULT NULL,
  `passport` tinyint(1) DEFAULT NULL,
  `cartime` INT(11) DEFAULT NULL,
  `payday` INT(11) DEFAULT NULL,
  `paydayhad` INT(11) DEFAULT NULL,
  `watch` tinyint(1) DEFAULT NULL,
  `crashed` tinyint(1) DEFAULT NULL,
  `wins` INT(11) DEFAULT NULL,
  `loses` INT(11) DEFAULT NULL,
  `tutorial` tinyint(1) DEFAULT NULL,
  `virworld` INT(11) DEFAULT NULL,
  `fuel` INT(11) DEFAULT NULL,
  `married` tinyint(1) DEFAULT NULL,
  `marriedto` VARCHAR(255) DEFAULT NULL,
  `fishtool` tinyint(1) DEFAULT NULL,
  `whyleft` VARCHAR(255) DEFAULT NULL,
  `lighter` INT(11) DEFAULT NULL,
  `cigarettes` INT(11) DEFAULT NULL,
  `ddmanager` INT(11) DEFAULT NULL,
  `onduty` tinyint(1) DEFAULT NULL,
  `warnings` INT(11) DEFAULT NULL,
  `swat` INT(11) DEFAULT NULL,
  `fighting` INT(11) DEFAULT NULL,
  `boxing` INT(11) DEFAULT NULL,
  `kneehead` INT(11) DEFAULT NULL,
  `kungfu` INT(11) DEFAULT NULL,
  `grabkick` INT(11) DEFAULT NULL,
  `elbow` INT(11) DEFAULT NULL,
  `tactical` INT(11) DEFAULT NULL,
  `specialf` INT(11) DEFAULT NULL,
  `dutybanned` tinyint(1) DEFAULT NULL,
  `ddticket` INT(11) DEFAULT NULL,
  `ddsticket` INT(11) DEFAULT NULL,
  `speedo` INT(11) DEFAULT NULL,
  `hydradriver` INT(11) DEFAULT NULL,
  `hunterdriver` INT(11) DEFAULT NULL,
  `rhinodriver` INT(11) DEFAULT NULL,
  `predatordriver` INT(11) DEFAULT NULL,
  `viewpms` INT(11) DEFAULT NULL,
  `appearlist` INT(11) DEFAULT NULL,
  `ammunationtime` INT(11) DEFAULT NULL,
  `tutorialdone` INT(11) DEFAULT NULL,
  `regularcount` INT(11) DEFAULT NULL,
  `passporttime` INT(11) DEFAULT NULL,
  `officertime` INT(11) DEFAULT NULL,
  `shiftname` INT(11) DEFAULT NULL,
  `atc` INT(11) DEFAULT NULL,
  `atcradio` INT(11) DEFAULT NULL,
  `pending` INT(11) DEFAULT NULL,
  `pendinginfo` VARCHAR(255) DEFAULT NULL,
  `chatmode` INT(11) DEFAULT NULL,
  `tazerbullets` INT(11) DEFAULT NULL,
  `ip` VARCHAR(255) DEFAULT NULL,
  `lastlogged` VARCHAR(255) DEFAULT NULL,
  `changed` INT(11) DEFAULT NULL,
  `registereddate` VARCHAR(255) DEFAULT NULL,
  `bizzentered` INT(11) DEFAULT NULL,
  `houseentered` INT(11) DEFAULT NULL,
  `decoder` INT(11) DEFAULT NULL,
  `banned` tinyint(1) DEFAULT NULL,
  `incar` BIGINT(20) UNSIGNED NOT NULL DEFAULT '9999',
  `weed` INT(11) NOT NULL DEFAULT '0',
  `seeds` INT(11) NOT NULL DEFAULT '0',
  UNIQUE KEY `id` (`id`),
  UNIQUE KEY `name` (`name`),
  KEY `incar` (`incar`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



CREATE TABLE IF NOT EXISTS `user_achievements` (
  `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `uid` BIGINT(20) UNSIGNED NOT NULL,
  `offset` INT(11) NOT NULL,
  `value` INT(1) NOT NULL DEFAULT '0',
  UNIQUE KEY `id` (`id`),
  UNIQUE KEY `uid_2` (`uid`,`offset`),
  KEY `uid` (`uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



CREATE TABLE IF NOT EXISTS `user_aliases` (
  `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(24) NOT NULL,
  `ip` VARCHAR(15) NOT NULL,
  UNIQUE KEY `id` (`id`),
  UNIQUE KEY `name` (`name`,`ip`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



CREATE TABLE IF NOT EXISTS `user_inv_weapons` (
  `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `uid` BIGINT(20) UNSIGNED NOT NULL,
  `offset` INT(11) NOT NULL,
  `weapon` INT(3) NOT NULL,
  `ammo` INT(11) NOT NULL,
  UNIQUE KEY `id` (`id`),
  UNIQUE KEY `uid_2` (`uid`,`offset`),
  KEY `uid` (`uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



CREATE TABLE IF NOT EXISTS `user_licenses` (
  `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `uid` BIGINT(20) UNSIGNED NOT NULL,
  `key` VARCHAR(255) NOT NULL,
  `is` tinyint(1) NOT NULL DEFAULT '0',
  UNIQUE KEY `id` (`id`),
  UNIQUE KEY `uid_2` (`uid`,`key`),
  KEY `uid` (`uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



CREATE TABLE IF NOT EXISTS `user_notes` (
  `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `uid` BIGINT(20) UNSIGNED NOT NULL,
  `offset` INT(11) NOT NULL,
  `message` VARCHAR(255) NOT NULL,
  UNIQUE KEY `id` (`id`),
  UNIQUE KEY `uid_2` (`uid`,`offset`),
  KEY `uid` (`uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



CREATE TABLE IF NOT EXISTS `user_perks` (
  `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `uid` BIGINT(20) UNSIGNED NOT NULL,
  `key` VARCHAR(255) NOT NULL,
  `is` tinyint(1) NOT NULL DEFAULT '0',
  UNIQUE KEY `id` (`id`),
  UNIQUE KEY `uid_2` (`uid`,`key`),
  KEY `uid` (`uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



CREATE TABLE IF NOT EXISTS `user_punishments` (
  `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `uid` BIGINT(20) UNSIGNED NOT NULL,
  `offset` INT(11) NOT NULL,
  `message` VARCHAR(255) NOT NULL,
  UNIQUE KEY `id` (`id`),
  UNIQUE KEY `uid_2` (`uid`,`offset`),
  KEY `uid` (`uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



CREATE TABLE IF NOT EXISTS `user_skills` (
  `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `uid` BIGINT(20) UNSIGNED NOT NULL,
  `key` VARCHAR(255) NOT NULL,
  `value` INT(11) NOT NULL DEFAULT '0',
  UNIQUE KEY `id` (`id`),
  UNIQUE KEY `uid_2` (`uid`,`key`),
  KEY `uid` (`uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



CREATE TABLE IF NOT EXISTS `user_weapons` (
  `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `uid` BIGINT(20) UNSIGNED NOT NULL,
  `offset` INT(11) NOT NULL,
  `weapon` INT(3) NOT NULL,
  `ammo` INT(11) NOT NULL,
  UNIQUE KEY `id` (`id`),
  UNIQUE KEY `uid_2` (`uid`,`offset`),
  KEY `uid` (`uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



CREATE TABLE IF NOT EXISTS `vehicles` (
  `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `model` INT(3) NOT NULL DEFAULT '0',
  `locX` FLOAT NOT NULL DEFAULT '0',
  `locY` FLOAT NOT NULL DEFAULT '0',
  `locZ` FLOAT NOT NULL DEFAULT '0',
  `angle` FLOAT NOT NULL DEFAULT '0',
  `color1` INT(3) NOT NULL DEFAULT '0',
  `color2` INT(3) NOT NULL DEFAULT '0',
  `ownerId` INT(11) NOT NULL DEFAULT '0',
  `owner` VARCHAR(255) NOT NULL DEFAULT '0',
  `locked` tinyint(1) NOT NULL DEFAULT '0',
  `paintjob` INT(11) NOT NULL DEFAULT '0',
  `virtualworld` INT(11) NOT NULL DEFAULT '0',
  `code` INT(11) NOT NULL DEFAULT '0',
  `plate` VARCHAR(128) NOT NULL DEFAULT '',
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



CREATE TABLE IF NOT EXISTS `vehicle_components` (
  `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `value` INT(11) NOT NULL,
  `slotId` INT(3) NOT NULL,
  `vehicleId` BIGINT(20) UNSIGNED NOT NULL,
  UNIQUE KEY `id` (`id`),
  KEY `vehicleId` (`vehicleId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;