root/dev/common/autoupgrade.php @ 47

<?php
require_once("db.php");
function check_commenttable()
{
    $qry = new DBQuery();
    $query = 'select count(*) from kb3_comments';
    $result = mysql_query($query);
    if ($result)
    {
        check_commenttablerow();
        return;
    }
    $query = 'CREATE TABLE `kb3_comments` (
`ID` INT NOT NULL AUTO_INCREMENT ,
`kll_id` INT NOT NULL ,
`comment` TEXT NOT NULL ,
`name` TINYTEXT NOT NULL ,
`posttime` TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL,
PRIMARY KEY ( `ID` )
) TYPE = MYISAM';
    $qry->execute($query);
}

function check_commenttablerow()
{
    $qry = new DBQuery();
    $query = 'select count(posttime) from kb3_comments';
    $result = mysql_query($query);
    if ($result)
    {
        $query = 'ALTER TABLE `kb3_comments` CHANGE `ID` `id` INT( 11 ) NOT NULL AUTO_INCREMENT';
        $qry->execute($query);
        return;
    }
    $query = 'ALTER TABLE `kb3_comments` ADD `posttime` TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL';
    $qry->execute($query);
}

function check_shipvaltable()
{
    $qry = new DBQuery();
    $query = 'select count(*) from kb3_ships_values';
    $result = mysql_query($query);
    if ($result)
    {
        return;
    }
    $query = 'CREATE TABLE `kb3_ships_values` (
`shp_id` INT( 11 ) NOT NULL ,
`shp_value` BIGINT( 4 ) NOT NULL ,
INDEX ( `shp_id` )
) TYPE = MYISAM ;';
    $qry->execute($query);
}

?>