﻿-- phpMyAdmin SQL Dump
-- version 2.10.1
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Generatie Tijd: 01 Aug 2008 om 13:02
-- Server versie: 4.1.10
-- PHP Versie: 5.2.1

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

-- 
-- Database: `crime_dbscene`
-- 

-- --------------------------------------------------------

-- 
-- Tabel structuur voor tabel `allies`
-- 

CREATE TABLE `allies` (
  `login` varchar(16) NOT NULL default '0',
  `person` varchar(16) NOT NULL default '0',
  `time` int(4) NOT NULL default '0',
  `log` varchar(60) NOT NULL default ''
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

-- 
-- Tabel structuur voor tabel `autorace`
-- 

CREATE TABLE `autorace` (
  `id` int(4) NOT NULL auto_increment,
  `racer` varchar(250) NOT NULL default '',
  `auto_id` int(255) NOT NULL default '0',
  `auto_naam` varchar(255) NOT NULL default '',
  `land` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

-- 
-- Tabel structuur voor tabel `banklogs`
-- 

CREATE TABLE `banklogs` (
  `van` varchar(255) NOT NULL default '',
  `voor` varchar(255) NOT NULL default '',
  `soort` varchar(255) NOT NULL default '',
  `aantal` varchar(255) NOT NULL default '',
  `datum` datetime NOT NULL default '0000-00-00 00:00:00',
  `ip` varchar(255) NOT NULL default '',
  KEY `van` (`van`),
  KEY `voor` (`voor`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

-- 
-- Tabel structuur voor tabel `belservice`
-- 

CREATE TABLE `belservice` (
  `id` int(10) NOT NULL auto_increment,
  `gebruikersnaam` varchar(255) NOT NULL default '',
  `datum` varchar(255) NOT NULL default '',
  `ip` varchar(255) NOT NULL default '',
  `anoniem` int(1) NOT NULL default '0',
  `product` varchar(255) NOT NULL default '',
  `layoutcode` int(6) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=143 ;

-- --------------------------------------------------------

-- 
-- Tabel structuur voor tabel `belspel`
-- 

CREATE TABLE `belspel` (
  `id` int(10) NOT NULL auto_increment,
  `login` varchar(255) NOT NULL default '', 
  `bellers` char(3) NOT NULL default '0',
  `winnaar` varchar(225) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `belspel`
-- 


-- --------------------------------------------------------

-- 
-- Tabel structuur voor tabel `bescherming`
-- 

CREATE TABLE `bescherming` (
  `id` int(1) NOT NULL auto_increment,
  `type` int(1) NOT NULL default '0',
  `minuten` int(255) NOT NULL default '0',
  `prijs` int(255) NOT NULL default '0',
  `naam` varchar(255) NOT NULL default '',
  `time` int(255) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

-- --------------------------------------------------------

-- 
-- Tabel structuur voor tabel `blackjack`
-- 

CREATE TABLE `blackjack` (
  `id` bigint(20) NOT NULL auto_increment,
  `login` varchar(150) NOT NULL default '',
  `inzet` int(255) NOT NULL default '0',
  `kaart` varchar(255) NOT NULL default '',
  `kaartpic` varchar(255) NOT NULL default '',
  `aas` varchar(255) NOT NULL default '',
  `dealer` varchar(255) NOT NULL default '',
  `dealerpic` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=291 ;

-- --------------------------------------------------------

-- 
-- Tabel structuur voor tabel `creditmarkt`
-- 

CREATE TABLE `creditmarkt` (
  `id` int(10) NOT NULL auto_increment,
  `amount_credits` int(10) NOT NULL default '0',
  `price` int(10) NOT NULL default '0',
  `stuksprijs` float NOT NULL default '0',
  `aanbieder` varchar(20) NOT NULL default '',
  `koper` varchar(20) NOT NULL default '',
  `verkocht` enum('0','1') NOT NULL default '0',
  `info` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=43 ;

-- --------------------------------------------------------

-- 
-- Tabel structuur voor tabel `donatielogs`
-- 

CREATE TABLE `donatielogs` (
  `id` int(10) NOT NULL auto_increment,
  `van` varchar(255) NOT NULL default '',
  `naar` varchar(255) NOT NULL default '',
  `ip` varchar(255) NOT NULL default '',
  `bedrag` int(255) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `van` (`van`),
  KEY `naar` (`naar`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

-- 
-- Tabel structuur voor tabel `EA_buildings`
-- 

CREATE TABLE `EA_buildings` (
  `id` int(11) NOT NULL auto_increment,
  `type` varchar(225) NOT NULL default '',
  `city` varchar(225) NOT NULL default '',
  `owner` varchar(225) NOT NULL default 'unowned',
  `start` datetime NOT NULL default '0000-00-00 00:00:00',
  `price` bigint(11) NOT NULL default '0',
  `production` datetime NOT NULL default '0000-00-00 00:00:00',
  `profit` bigint(50) NOT NULL default '0',
  `active` int(11) NOT NULL default '0',
  `amount` int(50) NOT NULL default '0',
  `takefrom` tinyint(1) NOT NULL default '1',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=61 ;

-- --------------------------------------------------------

-- 
-- Tabel structuur voor tabel `emails`
-- 

CREATE TABLE `emails` (
  `email` varchar(250) NOT NULL default '',
  `login` varchar(255) NOT NULL default ''
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

-- 
-- Tabel structuur voor tabel `forum_ban`
-- 

CREATE TABLE `forum_ban` (
  `id` int(20) NOT NULL auto_increment,
  `gebruikersnaam` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

-- 
-- Tabel structuur voor tabel `forum_categorien`
-- 

CREATE TABLE `forum_categorien` (
  `id` int(11) NOT NULL auto_increment,
  `naam` varchar(200) NOT NULL default '',
  `beschrijving` varchar(255) NOT NULL default '',
  `show` set('ja','nee') NOT NULL default 'ja',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;

-- --------------------------------------------------------

-- 
-- Tabel structuur voor tabel `forum_onderwerpen`
-- 

CREATE TABLE `forum_onderwerpen` (
  `id` int(1) NOT NULL auto_increment,
  `gebruikersnaam` varchar(255) NOT NULL default '',
  `titel` text NOT NULL,
  `bericht` text NOT NULL,
  `type` int(3) NOT NULL default '0',
  `datum` datetime NOT NULL default '0000-00-00 00:00:00',
  `laatstereply` datetime NOT NULL default '0000-00-00 00:00:00',
  `cat` int(10) NOT NULL default '0',
  `show` varchar(100) NOT NULL default 'ja',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=43 ;

-- --------------------------------------------------------

-- 
-- Tabel structuur voor tabel `forum_reacties`
-- 

CREATE TABLE `forum_reacties` (
  `id` int(10) NOT NULL auto_increment,
  `gebruikersnaam` varchar(225) NOT NULL default '',
  `bericht` text NOT NULL,
  `forumid` int(255) NOT NULL default '0',
  `datum` datetime NOT NULL default '0000-00-00 00:00:00',
  `ip` varchar(255) NOT NULL default '',
  `cat` int(10) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=211 ;

-- --------------------------------------------------------

-- 
-- Tabel structuur voor tabel `handdruk`
-- 

CREATE TABLE `handdruk` (
  `id` int(2) NOT NULL auto_increment,
  `naam` varchar(250) NOT NULL default '',
  `inzet` int(250) NOT NULL default '0',
  `titel` varchar(250) NOT NULL default '',
  `land` varchar(250) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=34 ;

-- --------------------------------------------------------

-- 
-- Tabel structuur voor tabel `helpdesk`
-- 

CREATE TABLE `helpdesk` (
  `id` int(11) NOT NULL auto_increment,
  `login` varchar(25) NOT NULL default '',
  `operator` varchar(25) NOT NULL default '',
  `categorie` varchar(50) NOT NULL default '0',
  `onderwerp` varchar(30) NOT NULL default '',
  `vraag` text NOT NULL,
  `antwoord` text NOT NULL,
  `behandelt` varchar(20) NOT NULL default 'Nee',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=27 ;

-- --------------------------------------------------------

-- 
-- Tabel structuur voor tabel `lottery`
-- 

CREATE TABLE `lottery` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(225) NOT NULL default '',
  `active` tinyint(1) NOT NULL default '1',
  `ticketprice` mediumint(11) NOT NULL default '2500',
  `ticketssold` mediumint(11) NOT NULL default '0',
  `pot` bigint(11) NOT NULL default '0',
  `winner` varchar(16) NOT NULL default 'Niemand',
  `winner-login` varchar(16) NOT NULL default '',
  `start` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

-- 
-- Tabel structuur voor tabel `lottery-tickets`
-- 

CREATE TABLE `lottery-tickets` (
  `id` int(11) NOT NULL auto_increment,
  `login` varchar(225) NOT NULL default '',
  `lotterynr` mediumint(11) NOT NULL default '0',
  `date` datetime NOT NULL default '0000-00-00 00:00:00',
  `IP` varchar(225) NOT NULL default '0.0.0.0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

-- 
-- Tabel structuur voor tabel `missie`
-- 

CREATE TABLE `missie` (
  `id` int(1) NOT NULL auto_increment,
  `gebruikersnaam` varchar(255) NOT NULL default '',
  `ip` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

-- --------------------------------------------------------

-- 
-- Tabel structuur voor tabel `nieuws`
-- 

CREATE TABLE `nieuws` (
  `id` int(11) NOT NULL auto_increment,
  `auteur` varchar(255) NOT NULL default '',
  `bericht` text NOT NULL,
  `datum` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

-- 
-- Tabel structuur voor tabel `nummerspel`
-- 

CREATE TABLE `nummerspel` (
  `owner` varchar(250) default 'BuLLeT',
  `spel` int(255) default '1',
  `land` int(10) NOT NULL default '0',
  `tijd` datetime NOT NULL default '0000-00-00 00:00:00',
  `vw` int(11) NOT NULL default '0',
  `maximum` int(255) NOT NULL default '50000',
  `bank` int(11) NOT NULL default '5000',
  KEY `land` (`land`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

-- 
-- Tabel structuur voor tabel `orgcrime`
-- 

CREATE TABLE `orgcrime` (
  `id` int(1) NOT NULL auto_increment,
  `leider` varchar(255) NOT NULL default '',
  `wapen` varchar(255) NOT NULL default '',
  `bom` varchar(255) NOT NULL default '',
  `chauffeur` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

-- 
-- Tabel structuur voor tabel `poll`
-- 

CREATE TABLE `poll` (
  `id` int(11) NOT NULL auto_increment,
  `vraag` varchar(200) NOT NULL default '',
  `actief` int(1) NOT NULL default '0',
  `datum` int(20) NOT NULL default '0',
  `keuze1` varchar(50) NOT NULL default '',
  `keuze2` varchar(50) NOT NULL default '',
  `keuze3` varchar(50) NOT NULL default '',
  `keuze4` varchar(50) NOT NULL default '',
  `keuze5` varchar(50) NOT NULL default '',
  `keuze6` varchar(50) NOT NULL default '',
  `keuze7` varchar(50) NOT NULL default '',
  `keuze8` varchar(50) NOT NULL default '',
  `keuze9` varchar(50) NOT NULL default '',
  `keuze10` varchar(50) NOT NULL default '',
  `antwoord1` int(11) NOT NULL default '0',
  `antwoord2` int(11) NOT NULL default '0',
  `antwoord3` int(11) NOT NULL default '0',
  `antwoord4` int(11) NOT NULL default '0',
  `antwoord5` int(11) NOT NULL default '0',
  `antwoord6` int(11) NOT NULL default '0',
  `antwoord7` int(11) NOT NULL default '0',
  `antwoord8` int(11) NOT NULL default '0',
  `antwoord9` int(11) NOT NULL default '0',
  `antwoord10` int(11) NOT NULL default '0',
  `gestemd` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

-- --------------------------------------------------------

-- 
-- Tabel structuur voor tabel `route66`
-- 

CREATE TABLE `route66` (
  `login` varchar(16) NOT NULL default '',
  `driver` varchar(16) NOT NULL default '',
  `stad` varchar(255) NOT NULL default '',
  `ready1` char(1) NOT NULL default '',
  `ready2` char(1) NOT NULL default '',
  `car` int(4) NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

-- 
-- Tabel structuur voor tabel `veiling`
-- 

CREATE TABLE `veiling` (
  `id` int(11) NOT NULL auto_increment,
  `plaatser` varchar(255) NOT NULL default '',
  `soort` int(11) NOT NULL default '0',
  `anoniem` int(11) NOT NULL default '0',
  `hoeveel` bigint(255) NOT NULL default '0',
  `bieder` varchar(255) NOT NULL default '',
  `bod` bigint(255) NOT NULL default '0',
  `tijd` datetime NOT NULL default '0000-00-00 00:00:00',
  `vid` varchar(255) NOT NULL default '0',
  `veiltijd` int(255) NOT NULL default '3600',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

-- 
-- Tabel structuur voor tabel `veilingboden`
-- 

CREATE TABLE `veilingboden` (
  `id` int(255) NOT NULL auto_increment,
  `veilid` int(255) NOT NULL default '0',
  `login` varchar(255) NOT NULL default '',
  `bod` bigint(255) NOT NULL default '0',
  `tijd` datetime NOT NULL default '0000-00-00 00:00:00',
  `anoniem` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

-- 
-- Tabel structuur voor tabel `vipitems`
-- 

CREATE TABLE `vipitems` (
  `id` int(255) NOT NULL auto_increment,
  `naam` varchar(255) NOT NULL default '',
  `url` varchar(255) NOT NULL default '',
  `attack` int(255) NOT NULL default '0',
  `defence` int(255) NOT NULL default '0',
  `prijs` int(255) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

-- --------------------------------------------------------

-- 
-- Tabel structuur voor tabel `[5050]`
-- 

CREATE TABLE `[5050]` (
  `id` int(2) NOT NULL default '0',
  `owner` varchar(16) NOT NULL default 'BuLLeT',
  `prijs` int(7) NOT NULL default '1000',
  `bank` int(11) NOT NULL default '500000',
  `spel` int(1) NOT NULL default '1',
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

-- 
-- Tabel structuur voor tabel `[auto]`
-- 

CREATE TABLE `[auto]` (
  `id` int(255) NOT NULL auto_increment,
  `soort` int(3) NOT NULL default '0',
  `schade` int(3) NOT NULL default '0',
  `owner` varchar(36) NOT NULL default '0',
  `land` int(10) NOT NULL default '1',
  `tekoop` int(10) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2901 ;

-- --------------------------------------------------------

-- 
-- Tabel structuur voor tabel `[buildings]`
-- 

CREATE TABLE `[buildings]` (
  `type` varchar(225) NOT NULL default 'slot',
  `city` varchar(225) NOT NULL default '',
  `owner` varchar(225) NOT NULL default 'No-ID',
  `start` datetime NOT NULL default '0000-00-00 00:00:00',
  `price` int(11) NOT NULL default '1000',
  `production` datetime NOT NULL default '0000-00-00 00:00:00',
  `profit` int(50) NOT NULL default '0',
  `active` int(11) NOT NULL default '5000',
  `amount` int(50) NOT NULL default '500',
  `bank` bigint(55) NOT NULL default '0',
  KEY `type` (`type`),
  KEY `city` (`city`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

-- 
-- Tabel structuur voor tabel `[casinoo]`
-- 

CREATE TABLE `[casinoo]` (
  `owner` varchar(250) default 'BuLLeT',
  `spel` int(250) default '3',
  `land` varchar(255) NOT NULL default '0',
  `tijd` datetime NOT NULL default '0000-00-00 00:00:00',
  `vw` int(255) NOT NULL default '0',
  `maximum` int(255) NOT NULL default '50000',
  `casinobank` bigint(255) NOT NULL default '5000',
  KEY `owner` (`owner`),
  KEY `land` (`land`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

-- 
-- Tabel structuur voor tabel `[casino]`
-- 

CREATE TABLE `[casino]` (
  `owner` varchar(250) default '0',
  `spel` int(250) default NULL,
  `land` varchar(255) NOT NULL default '',
  `tijd` datetime NOT NULL default '0000-00-00 00:00:00',
  `vw` varchar(255) NOT NULL default '',
  `maximum` int(255) NOT NULL default '3000',
  `bank` varchar(255) NOT NULL default '300'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

-- 
-- Tabel structuur voor tabel `[clans]`
-- 

CREATE TABLE `[clans]` (
  `name` varchar(33) NOT NULL default '',
  `owner` varchar(16) NOT NULL default '',
  `started` datetime NOT NULL default '0000-00-00 00:00:00',
  `type` int(1) NOT NULL default '1',
  `info` text NOT NULL,
  `clicks` bigint(5) NOT NULL default '0',
  `clickstoday` int(3) NOT NULL default '0',
  `cash` bigint(9) NOT NULL default '5000',
  `bank` bigint(9) NOT NULL default '10000',
  `bankleft` int(2) NOT NULL default '10',
  `bankmax` int(5) NOT NULL default '10000',
  `attwins` int(6) NOT NULL default '0',
  `attlosses` int(6) NOT NULL default '0',
  `defwins` int(6) NOT NULL default '0',
  `deflosses` int(6) NOT NULL default '0',
  `homes` int(3) NOT NULL default '5',
  `money_lvl1` int(3) NOT NULL default '0',
  `money_lvl2` int(3) NOT NULL default '0',
  `money_lvl3` int(3) NOT NULL default '0',
  `def_lvl1` int(255) NOT NULL default '0',
  `def_lvl2` int(3) NOT NULL default '0',
  `def_lvl3` int(3) NOT NULL default '0',
  `IPs` text NOT NULL,
  `avatarc` varchar(255) NOT NULL default 'http://www.members.lycos.nl/waroffline/images/NoPic%2520copy.jpg',
  `leeft` int(4) NOT NULL default '0',
  `hob` text NOT NULL,
  `money_lvl9` bigint(3) NOT NULL default '0',
  `money_lvl10` bigint(3) NOT NULL default '0',
  `berichten` int(255) NOT NULL default '0',
  `bes` int(2) NOT NULL default '0',
  `nachtclub` bigint(3) NOT NULL default '0',
  `cafee` bigint(3) NOT NULL default '0',
  `restaurant` bigint(3) NOT NULL default '0',
  `snackbar` bigint(3) NOT NULL default '0',
  `casino` bigint(3) NOT NULL default '0',
  `land` int(255) unsigned zerofill NOT NULL default '000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001000',
  PRIMARY KEY  (`name`),
  KEY `owner` (`owner`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

-- 
-- Tabel structuur voor tabel `[coffeshop]`
-- 

CREATE TABLE `[coffeshop]` (
  `id` int(2) NOT NULL default '0',
  `owner` varchar(16) NOT NULL default '',
  `aantal` int(5) NOT NULL default '0',
  `prijs` int(3) NOT NULL default '0',
  `code` int(2) NOT NULL default '0',
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

-- 
-- Tabel structuur voor tabel `[cron]`
-- 

CREATE TABLE `[cron]` (
  `time` datetime default NULL,
  `name` varchar(16) NOT NULL default '',
  PRIMARY KEY  (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

-- 
-- Tabel structuur voor tabel `[dealen]`
-- 

CREATE TABLE `[dealen]` (
  `wiet` int(5) default NULL,
  `hash` int(5) default NULL,
  `LSD` int(5) default NULL,
  `speed` int(5) default NULL,
  `vuurwerk` int(5) default NULL,
  `heroine` int(5) default NULL,
  `XTC` int(5) default NULL,
  `prijs` int(2) default NULL,
  KEY `prijs` (`prijs`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

-- 
-- Tabel structuur voor tabel `[drank]`
-- 

CREATE TABLE `[drank]` (
  `land` int(10) NOT NULL default '0',
  `verandertijd` datetime NOT NULL default '0000-00-00 00:00:00',
  `prijs1` int(10) NOT NULL default '0',
  `prijs2` int(10) NOT NULL default '0',
  `prijs3` int(10) NOT NULL default '0',
  `prijs4` int(10) NOT NULL default '0',
  `prijs5` int(10) NOT NULL default '0',
  `prijs6` int(11) NOT NULL default '0',
  `prijs7` int(11) NOT NULL default '0',
  KEY `land` (`land`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

-- 
-- Tabel structuur voor tabel `[drugs]`
-- 

CREATE TABLE `[drugs]` (
  `land` int(10) NOT NULL default '0',
  `verandertijd` datetime NOT NULL default '0000-00-00 00:00:00',
  `prijs1` int(10) NOT NULL default '0',
  `prijs2` int(10) NOT NULL default '0',
  `prijs3` int(10) NOT NULL default '0',
  `prijs4` int(10) NOT NULL default '0',
  `prijs5` int(10) NOT NULL default '0',
  KEY `land` (`land`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

-- 
-- Tabel structuur voor tabel `[getallen]`
-- 

CREATE TABLE `[getallen]` (
  `id` int(255) NOT NULL auto_increment,
  `owner` varchar(16) NOT NULL default '',
  `winst` int(9) NOT NULL default '0',
  `aantalx` int(5) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;

-- --------------------------------------------------------

-- 
-- Tabel structuur voor tabel `[keno]`
-- 

CREATE TABLE `[keno]` (
  `land` int(5) NOT NULL default '0',
  `owner` varchar(255) NOT NULL default 'BuLLeT',
  `geld` int(255) NOT NULL default '1000',
  `beheer` int(255) NOT NULL default '0',
  `winst` int(255) NOT NULL default '0',
  KEY `land` (`land`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

-- 
-- Tabel structuur voor tabel `[landen]`
-- 

CREATE TABLE `[landen]` (
  `id` int(6) NOT NULL auto_increment,
  `area` int(3) NOT NULL default '0',
  `land` varchar(128) NOT NULL default '',
  `aantal` int(3) NOT NULL default '0',
  `prijs` varchar(128) NOT NULL default '',
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=47 ;

-- --------------------------------------------------------

-- 
-- Tabel structuur voor tabel `[logs]`
-- 

CREATE TABLE `[logs]` (
  `time` datetime default NULL,
  `IP` varchar(32) default NULL,
  `forwardedFor` varchar(32) default NULL,
  `login` varchar(16) default NULL,
  `person` varchar(16) default NULL,
  `code` int(10) default NULL,
  `area` varchar(32) default NULL,
  `com` varchar(255) NOT NULL default '',
  KEY `login` (`login`),
  KEY `person` (`person`),
  KEY `code` (`code`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

-- 
-- Tabel structuur voor tabel `[messages]`
-- 

CREATE TABLE `[messages]` (
  `id` int(9) NOT NULL auto_increment,
  `IP` varchar(32) NOT NULL default '',
  `forwardedFor` varchar(32) default NULL,
  `time` datetime default NULL,
  `from` varchar(250) default NULL,
  `to` varchar(16) default NULL,
  `subject` varchar(50) NOT NULL default '',
  `message` text NOT NULL,
  `read` int(1) NOT NULL default '0',
  `inbox` int(1) default '1',
  `outbox` int(1) default '1',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=9126 ;

-- --------------------------------------------------------

-- 
-- Tabel structuur voor tabel `[online]`
-- 

CREATE TABLE `[online]` (
  `time` datetime default NULL,
  `IP` varchar(32) default NULL,
  `login` varchar(16) NOT NULL default '',
  `validate` varchar(32) default NULL,
  PRIMARY KEY  (`login`),
  KEY `IP` (`IP`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

-- 
-- Tabel structuur voor tabel `[orgcrime]`
-- 

CREATE TABLE `[orgcrime]` (
  `id` int(100) NOT NULL auto_increment,
  `name1` varchar(100) default NULL,
  `name2` varchar(100) default NULL,
  `name3` varchar(100) default NULL,
  `name4` varchar(100) default NULL,
  `WEA` int(1) NOT NULL default '0',
  `BEA` int(1) NOT NULL default '0',
  `DRA` int(1) NOT NULL default '0',
  `wapens` varchar(100) NOT NULL default '',
  `kogels` int(100) NOT NULL default '0',
  `bommen` varchar(100) NOT NULL default '',
  `aantal` int(100) NOT NULL default '0',
  `auto` varchar(100) NOT NULL default '',
  `klaar` int(1) NOT NULL default '0',
  `autoid` int(255) NOT NULL default '0',
  `autos` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=41 ;

-- --------------------------------------------------------

-- 
-- Tabel structuur voor tabel `[redlight]`
-- 

CREATE TABLE `[redlight]` (
  `id` int(5) NOT NULL auto_increment,
  `land` varchar(100) NOT NULL default '',
  `gebruik` int(1) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;

-- --------------------------------------------------------

-- 
-- Tabel structuur voor tabel `[reizen]`
-- 

CREATE TABLE `[reizen]` (
  `land` int(255) NOT NULL auto_increment,
  `tijd` datetime NOT NULL default '0000-00-00 00:00:00',
  `ltijd` datetime NOT NULL default '0000-00-00 00:00:00',
  `owner` varchar(255) NOT NULL default '',
  `geld` int(20) NOT NULL default '0',
  `winst` int(255) NOT NULL default '0',
  `klanten` int(150) NOT NULL default '0',
  PRIMARY KEY  (`land`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;

-- --------------------------------------------------------

-- 
-- Tabel structuur voor tabel `[roulet]`
-- 

CREATE TABLE `[roulet]` (
  `id` int(2) NOT NULL auto_increment,
  `owner` varchar(16) NOT NULL default '',
  `winst` int(9) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;

-- --------------------------------------------------------

-- 
-- Tabel structuur voor tabel `[smilies]`
-- 

CREATE TABLE `[smilies]` (
  `smilies_id` smallint(5) unsigned NOT NULL auto_increment,
  `code` varchar(50) default NULL,
  `smile_url` varchar(100) default NULL,
  `emoticon` varchar(75) default NULL,
  PRIMARY KEY  (`smilies_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=39 ;

-- --------------------------------------------------------

-- 
-- Tabel structuur voor tabel `[temp]`
-- 

CREATE TABLE `[temp]` (
  `id` int(16) NOT NULL auto_increment,
  `time` datetime default NULL,
  `login` varchar(16) default NULL,
  `IP` varchar(32) default NULL,
  `forwardedFor` varchar(32) default NULL,
  `code` int(10) unsigned NOT NULL default '0',
  `area` varchar(32) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=8460 ;

-- --------------------------------------------------------

-- 
-- Tabel structuur voor tabel `[users]`
-- 

CREATE TABLE `[users]` (
  `id` int(4) NOT NULL auto_increment,
  `signup` datetime default '0000-00-00 00:00:00',
  `login` varchar(16) default NULL,
  `pass` varchar(32) default NULL,
  `level` int(3) NOT NULL default '1',
  `IP` varchar(32) default NULL,
  `email` varchar(64) default NULL,
  `code` varchar(25) NOT NULL default '',
  `actief` int(1) NOT NULL default '1',
  `admin` int(1) NOT NULL default '0',
  `type` int(1) default NULL,
  `url` varchar(128) NOT NULL default '/images/noavatar.gif',
  `info` text,
  `avaurl` varchar(128) NOT NULL default '0',
  `gijzel` int(2) NOT NULL default '10',
  `orgtime` datetime NOT NULL default '0000-00-00 00:00:00',
  `orgstart` int(1) default '0',
  `orgtype` varchar(255) NOT NULL default '',
  `orgleider` varchar(255) NOT NULL default '',
  `gevangenis` datetime NOT NULL default '0000-00-00 00:00:00',
  `gevangenistijd` int(250) NOT NULL default '0',
  `bescherming` datetime NOT NULL default '0000-00-00 00:00:00',
  `beschermingtijd` int(250) NOT NULL default '0',
  `auto` datetime NOT NULL default '0000-00-00 00:00:00',
  `autotime` int(11) NOT NULL default '0',
  `getaway` datetime NOT NULL default '0000-00-00 00:00:00',
  `transp` int(6) NOT NULL default '0',
  `strength` int(11) NOT NULL default '0',
  `won` int(11) NOT NULL default '0',
  `lost` int(11) NOT NULL default '0',
  `clan` varchar(26) NOT NULL default '',
  `misdaad` datetime NOT NULL default '0000-00-00 00:00:00',
  `coffeshop` int(1) NOT NULL default '0',
  `rtijd` datetime NOT NULL default '0000-00-00 00:00:00',
  `rtijden` int(2) NOT NULL default '0',
  `land` int(2) NOT NULL default '1',
  `belcredits` int(5) default '0',
  `drugs` int(100) NOT NULL default '0',
  `huur` datetime NOT NULL default '0000-00-00 00:00:00',
  `huur1` int(255) NOT NULL default '0',
  `werken` datetime NOT NULL default '0000-00-00 00:00:00',
  `werken1` int(255) NOT NULL default '0',
  `bankmax` int(4) NOT NULL default '500000',
  `inclevel` int(4) NOT NULL default '0',
  `attlevnew` int(4) NOT NULL default '0',
  `attlevel` int(4) NOT NULL default '0',
  `deflevnew` int(4) NOT NULL default '0',
  `deflevel` int(4) NOT NULL default '0',
  `untlevel` int(7) NOT NULL default '0',
  `autocrime` int(2) NOT NULL default '2',
  `huurm` int(5) NOT NULL default '2',
  `HS` int(10) NOT NULL default '0',
  `uitbraken` int(11) NOT NULL default '0',
  `auto2` int(9) NOT NULL default '0',
  `sms` int(1) NOT NULL default '0',
  `klaar` int(11) NOT NULL default '0',
  `rank` int(255) NOT NULL default '1',
  `rankvord` varchar(255) NOT NULL default '0.00',
  `misdaadl` int(100) NOT NULL default '0',
  `misdaadtime` int(11) NOT NULL default '0',
  `aantal` int(9) NOT NULL default '100',
  `opdruktijd1` int(255) NOT NULL default '0',
  `opdruktijd` datetime NOT NULL default '0000-00-00 00:00:00',
  `picture` varchar(128) NOT NULL default '/images/n.jpg',
  `Provincie` int(11) NOT NULL default '0',
  `status` int(11) NOT NULL default '0',
  `allies` text,
  `enemies` text,
  `cartime` datetime NOT NULL default '0000-00-00 00:00:00',
  `cash` bigint(255) NOT NULL default '5000',
  `bank` bigint(255) NOT NULL default '20000',
  `clicks` int(4) NOT NULL default '0',
  `clickstoday` int(3) NOT NULL default '0',
  `landowner` int(3) NOT NULL default '0',
  `attack` bigint(255) NOT NULL default '0',
  `defence` bigint(255) NOT NULL default '0',
  `cdonatie` bigint(20) NOT NULL default '0',
  `crimes` int(255) NOT NULL default '0',
  `attwins` int(6) NOT NULL default '0',
  `attlosses` int(6) NOT NULL default '0',
  `defwins` int(6) NOT NULL default '0',
  `deflosses` int(6) NOT NULL default '0',
  `clanlevel` int(3) NOT NULL default '0',
  `showonline` int(1) NOT NULL default '1',
  `online` datetime NOT NULL default '0000-00-00 00:00:00',
  `activated` int(1) NOT NULL default '0',
  `IPs` text,
  `blocklist` text,
  `pin` varchar(32) default NULL,
  `forumcrew` int(1) NOT NULL default '0',
  `aanval` int(10) NOT NULL default '20',
  `A6` int(5) NOT NULL default '0',
  `A7` int(6) NOT NULL default '0',
  `posts` int(10) NOT NULL default '0',
  `kliklink` int(4) NOT NULL default '0',
  `verbannen` int(1) NOT NULL default '0',
  `clandonatie` bigint(255) NOT NULL default '0',
  `Mobieltje` int(1) NOT NULL default '1',
  `clannaam` varchar(255) NOT NULL default '',
  `clanrecht` int(9) NOT NULL default '0',
  `drug` int(50) NOT NULL default '0',
  `drug1` int(50) NOT NULL default '0',
  `drug2` int(50) NOT NULL default '0',
  `drug3` int(50) NOT NULL default '0',
  `drug4` int(50) NOT NULL default '0',
  `drug5` int(50) NOT NULL default '0',
  `drug6` int(50) NOT NULL default '0',
  `auto1` int(255) NOT NULL default '0',
  `vipdagen` int(250) NOT NULL default '0',
  `naamoptie` int(3) NOT NULL default '0',
  `logincode` varchar(255) NOT NULL default '',
  `opvraag` int(2) NOT NULL default '0',
  `ramen` int(5) NOT NULL default '0',
  `bitches` int(5) NOT NULL default '0',
  `bitchesgezocht` int(1) NOT NULL default '0',
  `hulpadmin` int(1) NOT NULL default '0',
  `gstart` int(2) NOT NULL default '0',
  `allie` text NOT NULL,
  `euro` char(1) NOT NULL default '€',
  `prijs` varchar(20) NOT NULL default '0',
  `alliep` varchar(20) NOT NULL default '1000000000',
  `race` varchar(200) NOT NULL default '',
  `pimprecht` varchar(255) NOT NULL default '',
  `melding` set('ja','nee') NOT NULL default 'ja',
  `msn` char(2) NOT NULL default '0',
  `respectpunten` int(11) NOT NULL default '100',
  `respect` int(11) NOT NULL default '0',
  `pc` datetime NOT NULL default '0000-00-00 00:00:00',
  `kladblok` text NOT NULL,
  `pimpnaam` varchar(50) NOT NULL default '',
  `pimpkleur` varchar(50) NOT NULL default '',
  `muziek` varchar(255) NOT NULL default '',
  `cokefabriek` int(1) NOT NULL default '0',  
  `coketijd` datetime NOT NULL default '0000-00-00 00:00:00',  
  `verkooptijd` datetime NOT NULL default '0000-00-00 00:00:00',  
  `runner` int(1) NOT NULL default '0',  
  `cokeverkoop` int(255) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `login` (`login`),
  KEY `level` (`level`),
  FULLTEXT KEY `IPs` (`IPs`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4271 ;

-- --------------------------------------------------------

-- 
-- Tabel structuur voor tabel `[veiling]`
-- 

CREATE TABLE `[veiling]` (
  `id` bigint(100) NOT NULL auto_increment,
  `tijd` datetime NOT NULL default '0000-00-00 00:00:00',
  `plaatser` varchar(32) default NULL,
  `item` int(1) NOT NULL default '0',
  `land` varchar(100) NOT NULL default '',
  `bod` bigint(255) NOT NULL default '0',
  `beginbod` int(16) NOT NULL default '0',
  `bieder` varchar(32) NOT NULL default 'bieder',
  `info` varchar(200) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

-- 
-- Tabel structuur voor tabel `[weapons]`
-- 

CREATE TABLE `[weapons]` (
  `id` int(4) NOT NULL auto_increment,
  `lim` int(2) NOT NULL default '0',
  `name` varchar(30) NOT NULL default '',
  `area` int(2) default NULL,
  `costs` int(7) default NULL,
  `url` varchar(40) default NULL,
  `attack` int(5) default NULL,
  `defence` int(5) default NULL,
  `max` text,
  `eval` text,
  `error` text,
  `extra` text,
  `Bazooka` int(5) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=97 ;

-- --------------------------------------------------------

--  
-- Tabel structuur voor tabel `[cokefabriek]`  
--  

CREATE TABLE `[cokefabriek]` (  
  `land` int(2) NOT NULL default '0',  
  `nummer` int(2) NOT NULL default '0',  
  `owner` varchar(16) NOT NULL default '',  
  `coke` bigint(255) NOT NULL default '0',  
  `runner1` varchar(16) NOT NULL default '',  
  `runner2` varchar(16) NOT NULL default '',  
  `runner3` varchar(16) NOT NULL default '',  
  `runner4` varchar(16) NOT NULL default '',  
  `runner5` varchar(16) NOT NULL default '',  
  `runner6` varchar(16) NOT NULL default '',  
  `runner7` varchar(16) NOT NULL default '',  
  `runner8` varchar(16) NOT NULL default ''  
) ENGINE=MyISAM DEFAULT CHARSET=latin1;  

--  
-- Gegevens worden uitgevoerd voor tabel `[cokefabriek]`  
--  

INSERT INTO `[cokefabriek]` VALUES(1, 2, '', 10500, '', '', '', '', '', '', '', '');  
INSERT INTO `[cokefabriek]` VALUES(1, 1, '', 10500, '', '', '', '', '', '', '', '');  
INSERT INTO `[cokefabriek]` VALUES(1, 3, '', 10500, '', '', '', '', '', '', '', '');  
INSERT INTO `[cokefabriek]` VALUES(1, 3, '', 10500, '', '', '', '', '', '', '', '');

-- --------------------------------------------------------

--   
-- Tabel structuur voor tabel `[runnertemp]`  
--   

CREATE TABLE `[runnertemp]` (  
  `owner` varchar(16) NOT NULL default '',  
  `land` int(1) NOT NULL default '0',  
  `runner` varchar(16) NOT NULL default '',  
  `runnernr` int(1) NOT NULL default '0',  
  `nummer` int(1) NOT NULL default '0'  
) ENGINE=MyISAM DEFAULT CHARSET=latin1;  

--   
-- Gegevens worden uitgevoerd voor tabel `[runnertemp]`  
--   

INSERT INTO `[runnertemp]` (`owner`, `land`, `runner`, `runnernr`, `nummer`) VALUES ('Bcitch', 1, 'onlinescar', 0, 1),  
('Bcitch', 1, 'IBelieve', 0, 3);
