<?php
include "funcs.php";
$sql = mysql_query("
CREATE TABLE IF NOT EXISTS `wcddl_blacklist` (
`url` varchar(255) NOT NULL,
PRIMARY KEY (`url`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
CREATE TABLE IF NOT EXISTS `wcddl_config` (
`config_name` varchar(200) NOT NULL,
`config_val` text NOT NULL,
`config_group` varchar(30) NOT NULL default 'misc',
PRIMARY KEY (`config_name`),
KEY `config_group` (`config_group`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
CREATE TABLE IF NOT EXISTS `wcddl_downloads` (
`id` int(11) NOT NULL auto_increment,
`sid` int(5) NOT NULL,
`title` varchar(200) NOT NULL,
`type` varchar(20) NOT NULL,
`url` text NOT NULL,
`dat` varchar(15) NOT NULL,
`views` int(5) NOT NULL,
`rating` int(5) NOT NULL,
PRIMARY KEY (`id`),
KEY `sid` (`sid`,`title`,`type`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
CREATE TABLE IF NOT EXISTS `wcddl_queue` (
`id` int(11) NOT NULL auto_increment,
`sid` int(5) NOT NULL,
`title` varchar(200) NOT NULL,
`type` varchar(20) NOT NULL,
`url` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
CREATE TABLE IF NOT EXISTS `wcddl_recents` (
`query` varchar(200) NOT NULL,
`searches` int(5) NOT NULL,
PRIMARY KEY (`query`),
KEY `searches` (`searches`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
CREATE TABLE IF NOT EXISTS `wcddl_sites` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(200) NOT NULL,
`url` text NOT NULL,
`email` varchar(200) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
CREATE TABLE IF NOT EXISTS `wcddl_whitelist` (
`url` varchar(255) NOT NULL,
PRIMARY KEY (`url`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
");
?>