-- phpMyAdmin SQL Dump
-- version 3.5.0
-- http://www.phpmyadmin.net
--
-- Machine: localhost
-- Genereertijd: 12 apr 2012 om 14:04
-- Serverversie: 5.1.60-log
-- PHP-Versie: 5.2.17
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 */;
--
-- Databank: `hfwrageb_T2K`
--
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `crimz_leden`
--
CREATE TABLE IF NOT EXISTS `crimz_leden` (
`login` varchar(255) NOT NULL DEFAULT '',
`ervaring` int(255) NOT NULL DEFAULT '0',
`email` varchar(255) NOT NULL DEFAULT '',
`wachtwoord` varchar(255) NOT NULL DEFAULT '',
`ip` varchar(255) NOT NULL DEFAULT '',
`VIP` varchar(225) NOT NULL DEFAULT '0',
`lvl` int(255) NOT NULL DEFAULT '0',
`exp` int(255) NOT NULL DEFAULT '0',
`genoegexp` int(255) NOT NULL DEFAULT '10',
`hp` int(100) NOT NULL DEFAULT '100',
`misdaadkans` int(100) NOT NULL DEFAULT '50',
`credits` bigint(255) NOT NULL DEFAULT '20',
`misdaadtijd` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`hoofd` varchar(255) NOT NULL DEFAULT '',
`arm1` varchar(255) NOT NULL DEFAULT 'm911',
`lichaam` varchar(255) NOT NULL DEFAULT '',
`voeten` varchar(255) NOT NULL DEFAULT '',
`arm2` varchar(255) NOT NULL DEFAULT '',
`power` int(255) NOT NULL DEFAULT '0',
`kogels` bigint(255) NOT NULL DEFAULT '7',
`geld` bigint(255) NOT NULL DEFAULT '200',
`eagle` bigint(255) NOT NULL DEFAULT '0',
`eaglegold` bigint(255) NOT NULL DEFAULT '0',
`eagleelite` bigint(255) NOT NULL DEFAULT '0',
`uzi` bigint(255) NOT NULL DEFAULT '0',
`ak47gold` bigint(255) NOT NULL DEFAULT '0',
`uzielite` bigint(255) NOT NULL DEFAULT '0',
`m911` bigint(255) NOT NULL DEFAULT '1',
`revolver` bigint(255) NOT NULL DEFAULT '0',
`revolvergold` bigint(255) NOT NULL DEFAULT '0',
`revolverelite` bigint(255) NOT NULL DEFAULT '0',
`ak47` bigint(255) NOT NULL DEFAULT '0',
`ak47elite` bigint(255) NOT NULL DEFAULT '0',
`grenade` bigint(255) NOT NULL DEFAULT '0',
`grenadegold` bigint(255) NOT NULL DEFAULT '0',
`grenadeelite` bigint(255) NOT NULL DEFAULT '0',
`gevangenistijd` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`autokans` int(255) NOT NULL DEFAULT '50',
`autotijd` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`drugs` bigint(255) NOT NULL DEFAULT '1',
`citroenc1` int(225) NOT NULL,
`fiatdoblo` int(225) NOT NULL,
`renaultgrandscenic` int(225) NOT NULL,
`audia3` int(225) NOT NULL,
`opelastra` int(225) NOT NULL,
`fordmondeo` int(225) NOT NULL,
`citroenc4picasso` int(225) NOT NULL,
`alfaromeospider` int(225) NOT NULL,
`audia4` int(225) NOT NULL,
`citroenc8` int(225) NOT NULL,
`volkswagentouareg` int(225) NOT NULL,
`jaguarxf` int(225) NOT NULL,
`toyotalandcruiser` int(225) NOT NULL,
`landroverdiscovery` int(225) NOT NULL,
`volvoxc90` int(225) NOT NULL,
`ferrarif430` int(225) NOT NULL,
`online` datetime NOT NULL,
`rang` int(255) NOT NULL,
`blauwshirt` bigint(255) NOT NULL,
`geenwachttijd` datetime NOT NULL,
`tip` smallint(255) NOT NULL DEFAULT '0',
`aanvallen` int(255) NOT NULL DEFAULT '0',
`aanvallenverloren` int(255) NOT NULL DEFAULT '0',
`respect` int(255) NOT NULL DEFAULT '1',
`respectpunten` int(6) NOT NULL DEFAULT '0',
`respecttijd` datetime NOT NULL,
`aanvaltijd` datetime NOT NULL,
`pet` bigint(255) NOT NULL,
`spijkerbroek` bigint(255) NOT NULL,
`benen` varchar(255) NOT NULL,
`spijkerbroekgold` bigint(255) NOT NULL,
`spijkerbroekelite` bigint(255) NOT NULL,
`sportschoenen` bigint(255) NOT NULL,
`sportschoenenelite` bigint(255) NOT NULL,
`sportschoenengold` bigint(255) NOT NULL,
`mp5` bigint(255) NOT NULL,
`mp5gold` bigint(255) NOT NULL,
`mp5elite` bigint(255) NOT NULL,
`rozeshirt` bigint(255) NOT NULL,
`blauweschoenen` bigint(255) NOT NULL,
`blauweschoenengold` bigint(255) NOT NULL,
`blauweschoenenelite` bigint(255) NOT NULL,
`job` int(255) NOT NULL DEFAULT '0',
`grenadegreen` bigint(255) NOT NULL,
`mp5green` bigint(255) NOT NULL,
`shotgungreen` bigint(255) NOT NULL,
`harpoongreen` bigint(255) NOT NULL,
`radtijd` datetime NOT NULL,
`bezitweergeven` int(100) NOT NULL DEFAULT '0',
`infotekst` text NOT NULL,
`uzigold` bigint(255) NOT NULL DEFAULT '0',
`klikmissie1` datetime NOT NULL,
`msn` datetime NOT NULL,
`kluis` bigint(255) NOT NULL DEFAULT '500',
`ban` int(255) NOT NULL DEFAULT '0',
`mod` int(255) NOT NULL DEFAULT '0',
`kortebroek` bigint(255) NOT NULL,
`donkerebroek` bigint(255) NOT NULL,
`donkerebroekgreen` bigint(255) NOT NULL,
`zwartewerkschoenen` bigint(255) NOT NULL,
`groenemust` bigint(255) NOT NULL,
`groenemustgold` bigint(255) NOT NULL,
`groenemustelite` bigint(255) NOT NULL,
`groenshirt` bigint(255) NOT NULL,
`groenshirtgold` bigint(255) NOT NULL,
`groenshirtelite` bigint(255) NOT NULL,
`groenshirtgreen` bigint(255) NOT NULL,
`donkerrozeshirt` bigint(255) NOT NULL,
`roodshirt` bigint(255) NOT NULL,
`paarsshirt` bigint(255) NOT NULL,
`klikmissiedubbel` int(255) NOT NULL,
`eaglebruin` bigint(255) NOT NULL,
`uzibruin` bigint(255) NOT NULL,
`revolverbruin` bigint(255) NOT NULL,
`ak47bruin` bigint(255) NOT NULL,
`grenadebruin` bigint(255) NOT NULL,
`mp5bruin` bigint(255) NOT NULL,
`avatarpack` int(255) NOT NULL DEFAULT '0',
`avatar` varchar(255) NOT NULL DEFAULT 'nopic.gif',
`geenlimiet` int(255) NOT NULL DEFAULT '0',
`racetijd` datetime NOT NULL,
`extrapower` int(255) NOT NULL DEFAULT '0',
`geenwachttijdrace` datetime NOT NULL,
`stempunten` int(255) NOT NULL DEFAULT '1',
`getaltijd` datetime NOT NULL,
`familie_id` int(255) NOT NULL,
`familie_rang` int(255) NOT NULL,
`m16blauw` bigint(255) NOT NULL,
`skorpionblauw` bigint(255) NOT NULL,
`m203blauw` bigint(255) NOT NULL,
`g36cblauw` bigint(255) NOT NULL,
`m4m203blauw` bigint(255) NOT NULL,
`uniek_kerstmuts` bigint(255) NOT NULL,
`uniek_kerstschoenen` bigint(255) NOT NULL,
`uniek_kerstshirt` bigint(255) NOT NULL,
`uniek_kerstbroek` bigint(255) NOT NULL,
`emailontvangen` int(255) NOT NULL DEFAULT '1',
`status` int(255) NOT NULL DEFAULT '0',
`starcount` int(255) NOT NULL DEFAULT '0',
`header_scroll1` int(255) NOT NULL DEFAULT '1000',
`header_scroll2` int(255) NOT NULL DEFAULT '1100',
`body_color_table` varchar(255) NOT NULL DEFAULT 'dcdacd',
`header_verbergen` int(255) NOT NULL DEFAULT '0',
`body_tekst` int(255) NOT NULL DEFAULT '12',
`eaglebruin_rood` bigint(255) NOT NULL,
`eaglebruin_groen` bigint(255) NOT NULL,
`eaglebruin_blauw` bigint(255) NOT NULL,
`eaglebruin_zwart` bigint(255) NOT NULL,
`eaglebruin_roze` bigint(255) NOT NULL,
`diamant_rood` bigint(225) NOT NULL,
`diamant_groen` bigint(225) NOT NULL,
`diamant_blauw` bigint(225) NOT NULL,
`diamant_zwart` bigint(225) NOT NULL,
`diamant_roze` bigint(225) NOT NULL,
`m16blauw_rood` bigint(255) NOT NULL,
`m16blauw_groen` bigint(255) NOT NULL,
`m16blauw_blauw` bigint(255) NOT NULL,
`m16blauw_zwart` bigint(255) NOT NULL,
`m16blauw_roze` bigint(255) NOT NULL,
`sms` int(255) NOT NULL,
`smsstatus` int(225) NOT NULL DEFAULT '0',
`uniek_paarsepet` bigint(255) NOT NULL,
`header_keuze` int(255) NOT NULL DEFAULT '2',
`ak47_rood` bigint(255) NOT NULL,
`ak47_groen` bigint(255) NOT NULL,
`ak47_blauw` bigint(255) NOT NULL,
`ak47_zwart` bigint(255) NOT NULL,
`ak47_roze` bigint(255) NOT NULL,
`grenade_rood` bigint(255) NOT NULL,
`grenade_groen` bigint(255) NOT NULL,
`grenade_blauw` bigint(255) NOT NULL,
`grenade_zwart` bigint(255) NOT NULL,
`grenade_roze` bigint(255) NOT NULL,
`slottijd` datetime NOT NULL,
`specpoints` int(255) NOT NULL DEFAULT '0',
`tijdmachine` int(255) NOT NULL DEFAULT '0',
`geldbespaarder` int(255) NOT NULL DEFAULT '0',
`racemonster` int(255) NOT NULL DEFAULT '0',
`gokfreak` int(255) NOT NULL DEFAULT '0',
`politievriend` int(255) NOT NULL DEFAULT '0',
`klikmissie2` datetime NOT NULL,
`menustyle` int(255) NOT NULL DEFAULT '1',
`missie_1` int(255) NOT NULL DEFAULT '0',
`missie_2` int(255) NOT NULL DEFAULT '0',
`missie_3` int(255) NOT NULL DEFAULT '0',
`missie_4` int(255) NOT NULL DEFAULT '0',
`missie_5` int(255) NOT NULL DEFAULT '0',
`missie_6` int(255) NOT NULL DEFAULT '0',
`missie_7` int(255) NOT NULL DEFAULT '0',
`missie_8` int(255) NOT NULL DEFAULT '0',
`missie_9` int(255) NOT NULL DEFAULT '0',
`missie_10` int(255) NOT NULL DEFAULT '0',
`uzibruin_rood` bigint(255) NOT NULL,
`uzibruin_groen` bigint(255) NOT NULL,
`uzibruin_blauw` bigint(255) NOT NULL,
`uzibruin_zwart` bigint(255) NOT NULL,
`uzibruin_roze` bigint(255) NOT NULL,
`revolverbruin_zwart` bigint(255) NOT NULL,
`revolverbruin_roze` bigint(255) NOT NULL,
`ak47bruin_blauw` bigint(255) NOT NULL,
`grenadebruin_blauw` bigint(255) NOT NULL,
`mp5bruin_blauw` bigint(255) NOT NULL,
`skorpionblauw_roze` bigint(255) NOT NULL,
`m203blauw_roze` bigint(255) NOT NULL,
`g36cblauw_roze` bigint(255) NOT NULL,
`m4m203blauw_roze` bigint(255) NOT NULL,
`uniek_groenejas` bigint(255) NOT NULL,
`uniek_zilverenschoen` bigint(255) NOT NULL,
`waarschuwingen` int(2) NOT NULL DEFAULT '0',
`tommygun` bigint(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!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 */;
Toon Meer