Location: PHPKode > projects > phpMyVisites > phpmv2/core/include/updates/update-2.3beta1.php
<?php
	
$allQueries = array(
'DROP TABLE IF EXISTS '.T_PDF_CONFIG,
"CREATE TABLE ".T_PDF_CONFIG." (
  idpdf int(10) unsigned NOT NULL auto_increment,
  name_pdf varchar(90) default NULL,
  params_pdf longblob,
  PRIMARY KEY  (idpdf)
) TYPE=MyISAM
",
'DROP TABLE IF EXISTS '.T_PDF_SITE_USER,
"CREATE TABLE ".T_PDF_SITE_USER." (
  `idsite` int(10) unsigned NOT NULL default '0',
  `login` varchar(20) NOT NULL default '0',
  `idpdf` int(10) unsigned NOT NULL,
  PRIMARY KEY  (`idsite`,`login`,`idpdf`)
) TYPE=MyISAM
",
//"ALTER TABLE ".T_SITE." DROP `idpdf`",
"ALTER TABLE ".T_SITE."  ADD `idpdf` INT( 10 ) DEFAULT '-1' NOT NULL AFTER `params_names`",
//"ALTER TABLE ".T_SITE." DROP `path_theme`",
"ALTER TABLE ".T_SITE."  ADD `path_theme` varchar(255) default 'default' NOT NULL AFTER `idpdf`",
//"ALTER TABLE ".T_VISIT."  DROP `javascript",
"ALTER TABLE ".T_VISIT."  ADD `javascript` tinyint(1) DEFAULT '0' NOT NULL AFTER `java`",
//"ALTER TABLE ".T_VISIT."  DROP `cookie`",
"ALTER TABLE ".T_VISIT."  ADD `cookie` tinyint(1) DEFAULT '0' NOT NULL AFTER `windowsmedia`"
);

foreach($allQueries as $query)
{
	query($query);
}	
	
	
?>
Return current item: phpMyVisites