CREATE TABLE `Verbannen` ( `IPadres` varchar(255) NOT NULL default '', `Datum` varchar(255) NOT NULL default '', `Opmerkingen` text NOT NULL, `Verbannen` char(1) NOT NULL default '0' ) TYPE=MyISAM;
CREATE TABLE `admin_controle` ( `id` int(11) NOT NULL auto_increment, `leden_admin` char(1) NOT NULL default '0', `linkpartner_admin` char(1) NOT NULL default '0', `script_admin` char(1) NOT NULL default '0', `artikel_admin` char(1) NOT NULL default '0', `sitekeuring_admin` char(1) NOT NULL default '0', `functie_admin` char(1) NOT NULL default '0', `nieuws_admin` char(1) NOT NULL default '0', `poll_admin` char(1) NOT NULL default '0', `banner_admin` char(1) NOT NULL default '0', `link_admin` char(1) NOT NULL default '0', `forum_admin` char(1) NOT NULL default '0', `download_admin` char(1) NOT NULL default '0', PRIMARY KEY (`id`) ) TYPE=MyISAM;
CREATE TABLE `download_categorie` ( `id` int(11) NOT NULL auto_increment, `naam` varchar(255) NOT NULL default '', `downloads` varchar(255) NOT NULL default '0', PRIMARY KEY (`id`) ) TYPE=MyISAM;
CREATE TABLE `download_downloads` ( `id` int(11) NOT NULL auto_increment, `cid` varchar(255) NOT NULL default '0', `auteur` varchar(255) NOT NULL default '0', `bericht` longtext NOT NULL, `datum` varchar(255) NOT NULL default '', `bewerktdoor` varchar(255) NOT NULL default '', `naam` varchar(255) NOT NULL default '', `gekeurd` char(1) NOT NULL default '0', `reacties` varchar(255) NOT NULL default '0', `url` varchar(255) NOT NULL default '', `kliks` varchar(255) NOT NULL default '0', PRIMARY KEY (`id`) ) TYPE=MyISAM;
CREATE TABLE `forum` ( `id` int(4) NOT NULL auto_increment, `catid` int(4) NOT NULL default '0', `onderwerp` varchar(250) NOT NULL default '', `bericht` longtext NOT NULL, `datum` varchar(250) NOT NULL default '', `poster` varchar(250) NOT NULL default '', `status` varchar(140) NOT NULL default 'open', `laatste_datum` varchar(250) NOT NULL default '', `sticky_topic` int(2) NOT NULL default '0', `poll` int(1) NOT NULL default '0', `mededeling` int(50) NOT NULL default '0', `gelezen` longtext NOT NULL, `bewerktdoor` varchar(255) NOT NULL default '0', `ip` varchar(255) NOT NULL default '0.0.0.0', UNIQUE KEY `id` (`id`) ) TYPE=MyISAM;
CREATE TABLE `forum_cats` ( `id` int(4) NOT NULL auto_increment, `naam` varchar(250) NOT NULL default '', UNIQUE KEY `id` (`id`) ) TYPE=MyISAM;
CREATE TABLE `forum_poll` ( `id` int(5) NOT NULL auto_increment, `vraag` varchar(250) NOT NULL default 'none', `stemmen` varchar(250) NOT NULL default '0', `aantal` int(2) NOT NULL default '0', `keuze1` varchar(250) NOT NULL default '1', `keuze2` varchar(250) NOT NULL default '2', `keuze3` varchar(250) NOT NULL default '3', `keuze4` varchar(250) NOT NULL default '4', `keuze5` varchar(250) NOT NULL default '0', `andwoord1` int(5) NOT NULL default '0', `andwoord2` int(5) NOT NULL default '0', `andwoord3` int(5) NOT NULL default '0', `andwoord4` int(5) NOT NULL default '0', `andwoord5` int(5) NOT NULL default '0', `pollid` int(1) NOT NULL default '1', `status` int(5) NOT NULL default '1', UNIQUE KEY `id` (`id`) ) TYPE=MyISAM;
CREATE TABLE `forum_poll_ips` ( `id` int(5) NOT NULL auto_increment, `ip` varchar(20) NOT NULL default '0', `pollid` varchar(250) NOT NULL default '0', UNIQUE KEY `id` (`id`) ) TYPE=MyISAM;
CREATE TABLE `forum_poll_tijdelijk` ( `id` int(11) NOT NULL auto_increment, `poster` varchar(255) NOT NULL default '0', `bericht` longtext NOT NULL, `onderwerp` varchar(255) NOT NULL default '', `catid` char(2) NOT NULL default '0', `status` varchar(255) NOT NULL default '0', PRIMARY KEY (`id`) ) TYPE=MyISAM;
CREATE TABLE `forum_reacties` ( `id` int(4) NOT NULL auto_increment, `tid` varchar(20) NOT NULL default '', `poster` varchar(250) NOT NULL default '', `bericht` text NOT NULL, `datum` varchar(255) NOT NULL default '', `ip` varchar(255) NOT NULL default '0.0.0.0', `bewerktdoor` varchar(11) NOT NULL default '0', UNIQUE KEY `id` (`id`) ) TYPE=MyISAM;
CREATE TABLE `forum_sub_cats` ( `id` int(5) NOT NULL auto_increment, `catid` int(5) NOT NULL default '0', `naam` varchar(250) NOT NULL default '0', `beschrijving` text NOT NULL, `crew` int(2) NOT NULL default '0', `mods` text NOT NULL, `gesloten` char(2) NOT NULL default '0', `post_crew` char(1) NOT NULL default '0', UNIQUE KEY `id` (`id`) ) TYPE=MyISAM;
CREATE TABLE `forum_tracker` ( `id` int(11) NOT NULL auto_increment, `topicid` varchar(255) NOT NULL default '0', `ledenid` varchar(255) NOT NULL default '0', PRIMARY KEY (`id`) ) TYPE=MyISAM;
CREATE TABLE `infobar_ips` ( `id` int(11) NOT NULL auto_increment, `ip` varchar(255) NOT NULL default '0.0.0.0', `klik` char(1) NOT NULL default '0', PRIMARY KEY (`id`) ) TYPE=MyISAM;
CREATE TABLE `jaar` ( `id` int(11) NOT NULL auto_increment, `inhoud2` varchar(255) NOT NULL default '', `inhoud` varchar(255) NOT NULL default '0000', `type` char(1) NOT NULL default '3', PRIMARY KEY (`id`) ) TYPE=MyISAM;
CREATE TABLE `leden` ( `id` int(11) NOT NULL auto_increment, `gebruikersnaam` varchar(255) NOT NULL default '', `wachtwoord` varchar(255) NOT NULL default '', `naam` varchar(255) NOT NULL default '', `email` varchar(255) NOT NULL default '', `status` varchar(255) NOT NULL default '1', `thema` varchar(255) NOT NULL default 'standaard', `ip` varchar(255) NOT NULL default '0.0.0.0', `geband` varchar(255) NOT NULL default '0', `aangemeld` datetime NOT NULL default '0000-00-00 00:00:00', `posts` int(11) NOT NULL default '0', `forum_topics` int(11) NOT NULL default '0', `forum_reacties` int(11) NOT NULL default '0', `waarschuwingen` varchar(255) NOT NULL default '0', `optie_avatar` varchar(255) NOT NULL default '1', `optie_onderschrift` varchar(255) NOT NULL default '1', `showmail` varchar(255) NOT NULL default '1', `nieuwsbrief` varchar(255) NOT NULL default '1', `opties_forum_max` varchar(255) NOT NULL default '15', `avatar` varchar(255) NOT NULL default 'no_ava.jpg', `ip_aangemeld` varchar(255) NOT NULL default '0.0.0.0', `last_on` varchar(255) NOT NULL default '', `last_action` varchar(255) NOT NULL default '', `homepage` varchar(255) NOT NULL default '', `icq` varchar(255) NOT NULL default '', `msn` varchar(255) NOT NULL default '', `geb1` char(2) NOT NULL default '', `geb2` char(2) NOT NULL default '', `geb3` varchar(4) NOT NULL default '', `woonplaats` varchar(255) NOT NULL default '', `ondertitel` varchar(255) NOT NULL default '', `onderschrift` longtext NOT NULL, `php` char(1) NOT NULL default '0', `mysql` char(1) NOT NULL default '0', `html` char(1) NOT NULL default '0', `javascript` char(1) NOT NULL default '0', `design` char(1) NOT NULL default '0', `flash` char(1) NOT NULL default '0', PRIMARY KEY (`id`) ) TYPE=MyISAM;
CREATE TABLE `link_categorie` ( `id` int(11) NOT NULL auto_increment, `naam` varchar(255) NOT NULL default '', `links` varchar(255) NOT NULL default '0', PRIMARY KEY (`id`) ) TYPE=MyISAM;
CREATE TABLE `link_links` ( `id` int(11) NOT NULL auto_increment, `cid` varchar(255) NOT NULL default '0', `auteur` varchar(255) NOT NULL default '0', `bericht` longtext NOT NULL, `datum` varchar(255) NOT NULL default '', `bewerktdoor` varchar(255) NOT NULL default '', `naam` varchar(255) NOT NULL default '', `gekeurd` char(1) NOT NULL default '0', `reacties` varchar(255) NOT NULL default '0', `naam_url` varchar(255) NOT NULL default '', `kliks` varchar(255) NOT NULL default '0', PRIMARY KEY (`id`) ) TYPE=MyISAM;
CREATE TABLE `linkpartners` ( `id` int(11) NOT NULL auto_increment, `url` varchar(255) NOT NULL default '', `inhits` int(11) NOT NULL default '0', `uithits` int(11) NOT NULL default '0', `ips_uit` longtext NOT NULL, `ips_in` longtext NOT NULL, `site_titel` varchar(255) NOT NULL default '', `actief` char(1) NOT NULL default '0', `email` varchar(255) NOT NULL default '', `ip` varchar(255) NOT NULL default '0.0.0.0', PRIMARY KEY (`id`) ) TYPE=MyISAM;
CREATE TABLE `log` ( `id` int(5) NOT NULL auto_increment, `hits` int(20) NOT NULL default '1', `time` int(5) NOT NULL default '0', `page` varchar(250) NOT NULL default 'Onbekend', `browser` varchar(250) NOT NULL default 'Onbekend', `os` varchar(250) NOT NULL default 'Onbekend', `ip` varchar(15) NOT NULL default '', `provider` varchar(250) NOT NULL default 'Onbekend', `land` varchar(250) NOT NULL default '', `day` char(2) NOT NULL default '', `month` char(2) NOT NULL default '', `year` char(2) NOT NULL default '', PRIMARY KEY (`id`) ) TYPE=MyISAM;
CREATE TABLE `nieuws` ( `id` int(11) NOT NULL auto_increment, `door` varchar(255) NOT NULL default '0', `titel` varchar(255) NOT NULL default '', `bericht` longtext NOT NULL, `datum` varchar(255) NOT NULL default '', `ip` varchar(255) NOT NULL default '0.0.0.0', `reacties` varchar(255) NOT NULL default '0', PRIMARY KEY (`id`) ) TYPE=MyISAM;
CREATE TABLE `online` ( `id` int(11) NOT NULL auto_increment, `wie` varchar(255) NOT NULL default '', `pagina` varchar(255) NOT NULL default '', `time` varchar(255) NOT NULL default '', `ingelogd` datetime NOT NULL default '0000-00-00 00:00:00', `ip` varchar(255) NOT NULL default '0.0.0.0', PRIMARY KEY (`id`) ) TYPE=MyISAM;
CREATE TABLE `poll` ( `id` int(5) NOT NULL auto_increment, `vraag` varchar(250) NOT NULL default 'none', `stemmen` varchar(250) NOT NULL default '0', `aantal` int(2) NOT NULL default '0', `keuze1` varchar(250) NOT NULL default '1', `keuze2` varchar(250) NOT NULL default '2', `keuze3` varchar(250) NOT NULL default '3', `keuze4` varchar(250) NOT NULL default '4', `keuze5` varchar(250) NOT NULL default '0', `andwoord1` int(5) NOT NULL default '0', `andwoord2` int(5) NOT NULL default '0', `andwoord3` int(5) NOT NULL default '0', `andwoord4` int(5) NOT NULL default '0', `andwoord5` int(5) NOT NULL default '0', `ip` text NOT NULL, `poster` varchar(140) NOT NULL default '0', `status` int(1) NOT NULL default '1', `reacties` varchar(255) NOT NULL default '0', UNIQUE KEY `id` (`id`) ) TYPE=MyISAM;
CREATE TABLE `poll_ips` ( `id` int(5) NOT NULL auto_increment, `ip` varchar(20) NOT NULL default '0', `pollid` varchar(250) NOT NULL default '0', UNIQUE KEY `id` (`id`) ) TYPE=MyISAM;
CREATE TABLE `priveberichten` ( `id` int(11) NOT NULL auto_increment, `gelezen` varchar(255) NOT NULL default '0', `door` varchar(255) NOT NULL default '0', `naar` varchar(255) NOT NULL default '0', `onderwerp` varchar(255) NOT NULL default 'Onbekend', `datum` varchar(255) NOT NULL default '', `ip` varchar(255) NOT NULL default '0.0.0.0', `opslaan` varchar(255) NOT NULL default '0', `bericht` longtext NOT NULL, PRIMARY KEY (`id`) ) TYPE=MyISAM;
CREATE TABLE `rating` ( `id` int(11) NOT NULL auto_increment, `wat` varchar(255) NOT NULL default '', `watid` varchar(255) NOT NULL default '', `cijfer` char(2) NOT NULL default '0', `stemmen` varchar(255) NOT NULL default '0', `ip` longtext NOT NULL, PRIMARY KEY (`id`) ) TYPE=MyISAM;
CREATE TABLE `reacties` ( `id` int(11) NOT NULL auto_increment, `wat` varchar(255) NOT NULL default '', `watid` varchar(255) NOT NULL default '0', `auteur` varchar(255) NOT NULL default '0', `bericht` longtext NOT NULL, `datum` varchar(255) NOT NULL default '', `ip` varchar(255) NOT NULL default '0.0.0.0', `bewerktdoor` varchar(255) NOT NULL default '0', PRIMARY KEY (`id`) ) TYPE=MyISAM;
CREATE TABLE `reclame_banner` ( `id` int(11) NOT NULL auto_increment, `url_banner` varchar(255) NOT NULL default '', `url_site` varchar(255) NOT NULL default '', `kliks_uit` varchar(255) NOT NULL default '0', `kliks_in` varchar(255) NOT NULL default '0', `shows` varchar(255) NOT NULL default '0', `actief` varchar(255) NOT NULL default '0', `ips` longtext NOT NULL, `ips_in` longtext NOT NULL, `groot` char(1) NOT NULL default '0', PRIMARY KEY (`id`) ) TYPE=MyISAM;
CREATE TABLE `script_categorie` ( `id` int(11) NOT NULL auto_increment, `naam` varchar(255) NOT NULL default '', `scripts` varchar(255) NOT NULL default '0', PRIMARY KEY (`id`) ) TYPE=MyISAM;
CREATE TABLE `script_scripts` ( `id` int(11) NOT NULL auto_increment, `cid` varchar(255) NOT NULL default '0', `auteur` varchar(255) NOT NULL default '0', `bericht` longtext NOT NULL, `datum` varchar(255) NOT NULL default '', `bewerktdoor` varchar(255) NOT NULL default '', `naam` varchar(255) NOT NULL default '', `gekeurd` char(1) NOT NULL default '0', `reacties` varchar(255) NOT NULL default '0', PRIMARY KEY (`id`) ) TYPE=MyISAM;
CREATE TABLE `sitekeuring` ( `id` int(11) NOT NULL auto_increment, `titel` varchar(255) NOT NULL default '', `auteur` varchar(255) NOT NULL default '', `datum` datetime NOT NULL default '0000-00-00 00:00:00', `keur` char(1) NOT NULL default '0', `url` varchar(255) NOT NULL default '', PRIMARY KEY (`id`) ) TYPE=MyISAM;
CREATE TABLE `statistieken` ( `id` int(11) NOT NULL auto_increment, `type` varchar(255) NOT NULL default '0', `jaar` varchar(255) NOT NULL default '0000', `maand` varchar(255) NOT NULL default '00', `dag` varchar(255) NOT NULL default '00', `uur` varchar(255) NOT NULL default '00', `minuut` varchar(255) NOT NULL default '00', `seconden` varchar(255) NOT NULL default '00', `ip` varchar(255) NOT NULL default '0.0.0.0', `date` date NOT NULL default '0000-00-00', `datum` datetime NOT NULL default '0000-00-00 00:00:00', `tijd` time NOT NULL default '00:00:00', PRIMARY KEY (`id`) ) TYPE=MyISAM;
|