CREATE TABLE IF NOT EXISTS `gebruikers` (
`user_id` int(11) NOT NULL auto_increment,
`aanmeld_datum` datetime NOT NULL,
`datum` datetime NOT NULL,
`account_code` mediumint(9) NOT NULL,
`username` varchar(10) NOT NULL,
`wachtwoord` varchar(32) NOT NULL,
`email` varchar(40) NOT NULL,
`ip_aangemeld` varchar(15) NOT NULL,
`ip_ingelogd` varchar(15) NOT NULL,
`premiumaccount` int(4) NOT NULL default '1',
`admin` tinyint(1) NOT NULL default '0',
`test` tinyint(2) NOT NULL,
`spec` tinyint(3) NOT NULL default '0',
`wereld` varchar(6) NOT NULL,
`silver` int(10) unsigned NOT NULL default '75',
`gold` int(10) unsigned NOT NULL default '0',
`bank` int(10) unsigned NOT NULL default '0',
`storten` tinyint(1) NOT NULL default '5',
`stelen` tinyint(1) NOT NULL default '3',
`races` tinyint(4) NOT NULL default '5',
`races_winst` int(11) NOT NULL default '0',
`races_verlies` int(11) NOT NULL default '0',
`werkervaring` int(10) NOT NULL,
`reclame` tinyint(1) NOT NULL default '0',
`online` varchar(10) NOT NULL,
`voornaam` varchar(12) NOT NULL,
`achternaam` varchar(12) NOT NULL,
`geb_datum` date NOT NULL,
`land` varchar(14) NOT NULL,
`character` varchar(7) NOT NULL,
`profiel` longtext NOT NULL,
`teamzien` tinyint(1) NOT NULL default '1',
`badgeszien` tinyint(1) NOT NULL default '0',
`dueluitnodiging` tinyint(1) NOT NULL default '1',
`buddy` text NOT NULL,
`blocklist` text NOT NULL,
`huis` varchar(5) NOT NULL default 'doos',
`geluksrad` tinyint(1) NOT NULL default '3',
`wiequiz` datetime NOT NULL,
`rank` tinyint(2) NOT NULL default '1',
`rankexp` int(9) unsigned NOT NULL default '0',
`rankexpnodig` int(9) NOT NULL default '245',
`soortwerk` tinyint(2) NOT NULL,
`werktijd` smallint(3) NOT NULL,
`werktijdbegin` datetime NOT NULL,
`pokecentertijd` smallint(3) NOT NULL,
`pokecentertijdbegin` datetime NOT NULL,
`gevangenistijd` smallint(3) NOT NULL,
`gevangenistijdbegin` datetime NOT NULL,
`captcha_time` int(11) NOT NULL,
`captcha_tevaak_fout` int(11) NOT NULL,
`aantalpokemon` int(9) unsigned NOT NULL,
`badges` tinyint(2) NOT NULL,
`pagina` varchar(20) NOT NULL,
`gewonnen` int(8) NOT NULL,
`verloren` int(8) NOT NULL,
`eigekregen` tinyint(1) NOT NULL default '0',
`lvl_choose` varchar(6) NOT NULL,
`pok_gezien` text NOT NULL,
`pok_bezit` text NOT NULL,
`pok_gehad` text NOT NULL,
PRIMARY KEY (`user_id`),
KEY `naam` (`username`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=6693 ;