--
-- Tabelstructuur voor tabel `users`
--
CREATE TABLE IF NOT EXISTS `users` (
`login` varchar(16) collate latin1_german1_ci default NULL,
`hoermissie` int(255) NOT NULL default '0',
`pimpdiploma` varchar(255) collate latin1_german1_ci NOT NULL default '0',
`email` varchar(64) collate latin1_german1_ci default NULL,
`contant` bigint(255) NOT NULL default '100000',
`bank` bigint(255) NOT NULL default '20000',
`killers` int(5) NOT NULL default '0',
`pass` varchar(32) collate latin1_german1_ci default NULL,
`rank` varchar(100) collate latin1_german1_ci NOT NULL default '1',
`health` int(11) NOT NULL default '100',
`bankleft` int(1) NOT NULL default '15',
`power` bigint(255) default '0',
`callcredits` int(255) NOT NULL default '10',
`vipdays` int(5) NOT NULL default '0',
`city` int(2) NOT NULL default '1',
`familie` varchar(26) collate latin1_german1_ci NOT NULL,
`id` int(4) NOT NULL auto_increment,
`info` text collate latin1_german1_ci NOT NULL,
`maffia` int(5) NOT NULL default '0',
`IP` varchar(32) character set latin1 default NULL,
`activationcode` int(10) NOT NULL default '0',
`signup` datetime default NULL,
`online` datetime NOT NULL default '0000-00-00 00:00:00',
`online2` varchar(5) character set latin1 NOT NULL default 'nee',
`rankvord` varchar(100) character set latin1 NOT NULL default '0',
`passdecoded` varchar(32) character set latin1 default NULL,
`safe` int(5) NOT NULL default '12',
`respect` int(5) NOT NULL default '0',
`geefeer` int(5) NOT NULL default '0',
`kogels` int(255) NOT NULL default '0',
`attwins` int(30) NOT NULL default '0',
`attlost` int(30) NOT NULL default '0',
`bankpas` int(5) NOT NULL default '0',
`kluis` int(5) NOT NULL default '0',
`zwitserse` int(5) NOT NULL default '0',
`deagle` int(5) NOT NULL default '0',
`pepperspray` int(5) NOT NULL default '0',
`knuppel` int(5) NOT NULL default '0',
`sigp` int(5) NOT NULL default '0',
`c4` int(5) NOT NULL default '0',
`m16` int(5) NOT NULL default '0',
`cornershot` int(5) NOT NULL default '0',
`pitbull` int(5) NOT NULL default '0',
`sniper` int(5) NOT NULL default '0',
`swatgun` int(5) NOT NULL default '0',
`bazooka` int(5) NOT NULL default '0',
`bodyguards` int(5) NOT NULL default '0',
`warboot` int(5) NOT NULL default '0',
`atoombom` int(5) NOT NULL default '0',
`tank` int(5) NOT NULL default '0',
`scud` int(5) NOT NULL default '0',
`satteliet` int(5) NOT NULL default '0',
`spacestation` int(5) NOT NULL default '0',
`hoerenhuis` int(5) NOT NULL default '0',
`switchblade` int(5) NOT NULL default '0',
`voornaam` varchar(32) collate latin1_german1_ci default NULL,
`achternaam` varchar(32) collate latin1_german1_ci default NULL,
`geslacht` varchar(32) collate latin1_german1_ci default NULL,
`postcode` varchar(32) collate latin1_german1_ci default NULL,
`catchmails` int(5) NOT NULL default '1',
`kladblok` text character set latin1 NOT NULL,
`bezitiets` int(5) NOT NULL default '0',
`vermoord` int(5) NOT NULL default '0',
`admin` int(5) NOT NULL default '0',
`vakantie` int(5) NOT NULL default '0',
`bankstandard` int(5) NOT NULL default '15',
`dagenrente` int(5) NOT NULL default '0',
`maxaccounts` int(5) NOT NULL default '0',
`famlevel` int(5) NOT NULL default '0',
`moderator` int(5) NOT NULL default '0',
`forumposts` int(10) NOT NULL default '0',
`hoofdwaarde` bigint(255) NOT NULL default '0',
`moordenaar` varchar(16) collate latin1_german1_ci default NULL,
`moordpremie` bigint(255) NOT NULL default '0',
`moorddatum` varchar(32) character set latin1 NOT NULL default '00-00-00',
`vordering` int(255) NOT NULL default '0',
`gevangenis` int(255) NOT NULL default '0',
`steel` datetime NOT NULL,
`steeltijd` int(255) NOT NULL default '0',
`killcount` int(255) NOT NULL default '0',
`drugsmax` int(255) NOT NULL default '1',
`nederwietupgr` int(255) NOT NULL default '0',
`paddoupgr` int(255) NOT NULL default '0',
`xtcupgr` int(255) NOT NULL default '0',
`lsdupgr` int(255) NOT NULL default '0',
`speedupgr` int(255) NOT NULL default '0',
`opiumupgr` int(255) NOT NULL default '0',
`nederwiet` int(255) NOT NULL default '0',
`paddo` int(255) NOT NULL default '0',
`xtc` int(255) NOT NULL default '0',
`lsd` int(255) NOT NULL default '0',
`speed` int(255) NOT NULL default '0',
`opium` int(255) NOT NULL default '0',
`autojatten` int(10) NOT NULL default '600',
`autojattijd` datetime NOT NULL default '0000-00-00 00:00:00',
`werktijd` int(10) NOT NULL default '180',
`werken` datetime NOT NULL default '0000-00-00 00:00:00',
`baktijd` datetime NOT NULL default '0000-00-00 00:00:00',
`kluisgeld` bigint(255) NOT NULL default '0',
`zwitsersegeld` bigint(255) NOT NULL default '0',
`zwitsersehalen` bigint(255) NOT NULL default '50000000',
`zwitsersestorten` bigint(255) NOT NULL default '5000000',
`aankomst` varchar(20) character set latin1 default NULL,
`aankomststad` int(5) NOT NULL default '0',
`vliegen` datetime NOT NULL default '0000-00-00 00:00:00',
`puntenblackjack` int(5) NOT NULL default '0',
`puntencomp` int(5) NOT NULL default '0',
`kaarten` text character set latin1,
`kaartencomp` text character set latin1,
`draaitijd` datetime NOT NULL default '0000-00-00 00:00:00',
`draaien` int(40) NOT NULL default '10800',
`loten` int(4) NOT NULL default '0',
`hlronde` int(5) NOT NULL default '0',
`hlgetal` int(5) NOT NULL default '0',
`hl` int(50) NOT NULL default '300',
`hltijd` datetime NOT NULL default '0000-00-00 00:00:00',
`roulette` int(4) NOT NULL default '0',
`aangevallen` int(10) NOT NULL default '0',
`aanval` int(5) NOT NULL default '15',
`aanvaltijd` datetime NOT NULL default '0000-00-00 00:00:00',
`missionsfixed` text character set latin1,
`inzet` int(10) NOT NULL default '0',
`fbibom` int(10) NOT NULL default '0',
`stationkaarten` int(40) NOT NULL default '0',
`vliegveldkaarten` varchar(40) collate latin1_german1_ci NOT NULL default '0',
`chatlog` text character set latin1,
`chatlog_hulp` text character set latin1,
`kicked` int(5) NOT NULL default '0',
`oc` int(40) NOT NULL default '0',
`octijd` datetime NOT NULL default '0000-00-00 00:00:00',
`woning` varchar(5) collate latin1_german1_ci NOT NULL default 'Geen',
`woningtekst` text collate latin1_german1_ci NOT NULL,
`woonplaats` varchar(255) collate latin1_german1_ci NOT NULL,
`huisnaam` text collate latin1_german1_ci NOT NULL,
`strafpunten` int(5) NOT NULL,
`winkel` datetime NOT NULL,
`getawaytijd` int(15) NOT NULL,
`winkeltijd` int(15) NOT NULL,
`famvordering` int(255) NOT NULL default '0',
`steel2` datetime NOT NULL,
`steeltijd2` int(255) NOT NULL default '0',
`riptijd` int(15) NOT NULL,
`ripdeal` datetime NOT NULL,
`drank` int(15) NOT NULL,
`zak` int(15) NOT NULL,
`drankt` datetime NOT NULL,
`xp` int(15) NOT NULL default '10',
`scooterjatten` int(10) NOT NULL default '600',
`scooterjattijd` datetime NOT NULL default '0000-00-00 00:00:00',
`opgehaald` int(1) NOT NULL,
`code` int(10) NOT NULL default '918273645',
`opgehaald2` int(10) NOT NULL default '0',
`partner_trow` varchar(10) collate latin1_german1_ci NOT NULL default '',
`grup` varchar(10) collate latin1_german1_ci NOT NULL default '',
`mislukt` int(5) NOT NULL default '0',
`winst` int(255) NOT NULL default '0',
`fraudetijd` varchar(255) collate latin1_german1_ci NOT NULL default '0',
`gelukt` int(5) NOT NULL default '0',
`type` int(1) NOT NULL default '0',
`ramen` int(255) NOT NULL default '0',
`hoeren` int(255) NOT NULL default '0',
`hoerenwerkend` int(255) NOT NULL default '0',
`hoerpimped` int(255) NOT NULL default '0',
`tabakmax` int(255) NOT NULL default '1',
`vannelleupgr` int(255) NOT NULL default '0',
`drumupgr` int(255) NOT NULL default '0',
`lmupgr` int(255) NOT NULL default '0',
`kentupgr` int(255) NOT NULL default '0',
`panterupgr` int(255) NOT NULL default '0',
`vannelle` int(255) NOT NULL default '0',
`drum` int(255) NOT NULL default '0',
`lm` int(255) NOT NULL default '0',
`kent` int(255) NOT NULL default '0',
`panter` int(255) NOT NULL default '0',
`pruimtabak` int(255) NOT NULL default '0',
`pruimtabakupgr` int(255) NOT NULL default '0',
`ban` varchar(255) collate latin1_german1_ci NOT NULL default '0',
`ban2` text collate latin1_german1_ci NOT NULL,
`ban3` varchar(50) collate latin1_german1_ci NOT NULL default '0000-00-00',
PRIMARY KEY (`id`),
FULLTEXT KEY `moordenaar` (`moordenaar`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_german1_ci AUTO_INCREMENT=75 ;
-- --------------------------------------------------------
Toon Meer