The queries are stored in the utils.php as functions.
function getQuery_Create__comment()
{
$query = "CREATE TABLE `vpo_comment` (
`id` INT(10) NOT NULL auto_increment,
`contentid` INT(10) NOT NULL default '0',
`component` VARCHAR(50) NOT NULL default '',
`ip` VARCHAR(15) NOT NULL default '',
`userid` int(11),
`usertype` VARCHAR(25) NOT NULL default 'Unregistered',
`date` DATETIME NOT NULL default '0000-00-00 00:00:00',
`name` VARCHAR(30) NOT NULL default '',
`email` VARCHAR(50) NOT NULL default '',
`website` VARCHAR(100) NOT NULL default '',
`notify` TINYINT(1) NOT NULL default '0',
`title` VARCHAR(50) NOT NULL default '',
`comment` TEXT NOT NULL,
`published` TINYINT(1) NOT NULL default '0',
`voting_yes` INT(10) NOT NULL default '0',
`voting_no` INT(10) NOT NULL default '0',
`parentid` INT(10) NOT NULL default '-1',
`importedtable` VARCHAR(30) NOT NULL default '',
`importedid` INT(10) NOT NULL default '0',
`importedparentid` INT(10) NOT NULL default '-1',
PRIMARY KEY (`id`)) type=MyISAM;";
return $query;
}
function getQuery_Create__comment_setting()
{
/* in case of change, don't forget to update the JOSC_josComment class */
$query = "CREATE TABLE `vpo_comment_setting` (
`id` INT(11) NOT NULL auto_increment,
`set_name` VARCHAR(50) NOT NULL default '',
`set_component` VARCHAR(50) NOT NULL default '',
`set_sectionid` INT(11) NOT NULL default '0',
`params` text NOT NULL,
PRIMARY KEY (`id`)) type=MyISAM";
return $query;
}
function getQuery_Create__comment_captcha()
{
$query = "CREATE TABLE IF NOT EXISTS `vpo_comment_captcha` (
`ID` int(11) NOT NULL auto_increment,
`insertdate` datetime NOT NULL default '0000-00-00 00:00:00',
`referenceid` varchar(100) NOT NULL default '',
`hiddentext` varchar(100) NOT NULL default '',
PRIMARY KEY (`ID`)) type=MyISAM";
return $query;
}
function getQuery_Create__comment_voting()
{
$query = "CREATE TABLE IF NOT EXISTS `vpo_comment_voting` (
`id` INT(10) NOT NULL default '0',
`ip` VARCHAR(15) NOT NULL default '',
`time` INTEGER NOT NULL default '0') type=MyISAM";
return $query;
}
