CREATE TABLE IF NOT EXISTS `vbtube_tubes` (
`tubeid` int(20) unsigned NOT NULL auto_increment,
`categoryid` int(3) unsigned NOT NULL default '0',
`forumid` int(10) unsigned NOT NULL default '0',
`userid` int(20) unsigned NOT NULL default '0',
`username` varchar(70) NOT NULL default '',
`email` varchar(70) NOT NULL default '',
`title` mediumtext,
`vidlang` varchar(50) NOT NULL default '',
`link` varchar(170) NOT NULL default '',
`link1` longtext NOT NULL,
`link2` longtext NOT NULL,
`link3` longtext NOT NULL,
`link1img` varchar(250) NOT NULL default '',
`mediatype` varchar(50) NOT NULL default '',
`site` varchar(50) NOT NULL default '',
`aboutme` longtext,
`active` varchar(1) NOT NULL default '0',
`tube` varchar(50) NOT NULL default '',
`views` int(30) unsigned NOT NULL default '0',
`votes` int(10) unsigned NOT NULL default '0',
`rates` int(10) unsigned NOT NULL default '0',
`rating` double(5,2) unsigned NOT NULL default '0.00',
`keywords` varchar(250) NOT NULL default '',
`joindate` int(10) unsigned NOT NULL default '0',
`reviewid` int(10) unsigned NOT NULL default '0',
`positive` int(10) unsigned NOT NULL default '0',
`negative` int(10) unsigned NOT NULL default '0',
`reported` varchar(1) NOT NULL default '0',
`reporteruser` varchar(50) NOT NULL default '',
`reportreason` mediumtext,
`reportcategory` varchar(50) NOT NULL default '',
PRIMARY KEY (`tubeid`)
) TYPE=MyISAM
CREATE TABLE IF NOT EXISTS `vbtube_lastkeywords` (
`keywordid` int(50) unsigned NOT NULL auto_increment,
`lastkeywords` varchar(250) NOT NULL default '',
`username` varchar(250) NOT NULL default '',
`userid` int(20) unsigned NOT NULL default '0',
`userip` varchar(250) NOT NULL default '',
PRIMARY KEY (`keywordid`)
) TYPE=MyISAM
CREATE TABLE IF NOT EXISTS `vbtube_lastwatched` (
`lastwid` int(50) unsigned NOT NULL auto_increment,
`userid` int(30) NOT NULL,
`title` mediumtext,
`link` varchar(170) NOT NULL default '',
`link1img` varchar(250) NOT NULL default '',
PRIMARY KEY (`lastwid`)
) TYPE=MyISAM
CREATE TABLE IF NOT EXISTS `vbtube_favourites` (
`id` int(30) NOT NULL auto_increment,
`title` mediumtext,
`aboutme` mediumtext,
`link` varchar(250) NOT NULL,
`link1img` varchar(250) NOT NULL,
`userid` int(30) NOT NULL,
`tubeid` int(30) NOT NULL,
`reviewid` INT(20) NOT NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM
CREATE TABLE IF NOT EXISTS `vbtube_categories` (
`categoryid` int(3) unsigned NOT NULL auto_increment,
`title` varchar(250) NOT NULL default '',
`display` varchar(2) NOT NULL default '0',
`cattype` varchar(2) NOT NULL default '0',
`totaltubes` int(50) unsigned NOT NULL default '0',
`forumid` int(5) unsigned NOT NULL default '0',
PRIMARY KEY (`categoryid`)
) TYPE=MyISAM
CREATE TABLE IF NOT EXISTS `vbtube_ratings` (
`ratingid` int(10) unsigned NOT NULL auto_increment,
`tubeid` int(10) unsigned default NULL,
`userid` int(10) unsigned default NULL,
`rate` int(3) unsigned default NULL,
`postdate` datetime default NULL,
PRIMARY KEY (`ratingid`)
) TYPE=MyISAM