root/dev/common/autoupgrade.php @ 44

<?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)
    {
        check_commenttablerow();
        return;
    }
    $query = 'ALTER TABLE `kb3_comments` ADD `posttime` TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL';
    $qry->execute($query);
}
?>