function ddc_gentable_o($obj, $sql)
{
$sa = new ddc_raw();
foreach ($obj->cols as $e) {
// $sa->addcol($e['name'],$e['type'],$e['null'],$e['default'],$e['sequence'],$e['comment']);
$sa->addcol($e['name'], $e['sql_type'], $e['sql_null'], $e['sql_default'], $e['sql_sequence'], $e['sql_comment']);
}
foreach ($obj->keys as $e) {
// function addcol_to_key($key,$name,$sub)
$sa->addcol_to_key($e['key'], $e['name'], $e['sub']);
}
$sa->ctbl = $obj->name;
if ($sql->query("SHOW COLUMNS FROM `" . $sql->esc($obj->name) . "`")) {
$sb = new ddc_raw();
$sb->load_table($obj->name, $sql);
$sb->gen_changes($sa);
$v = $sb->commit_changes($sql);
if ($v) {
print $v;
}
} else {
$res = $sql->query($sa->create_query($obj->name));
if (!$res) {
die($sql->err());
}
}
}
$sql->query("CREATE TABLE `{$testtbl}` (`id_prod` int(11) NOT NULL auto_increment, `doorname` varchar(255) default NULL, `fillmodel` int(11) default NULL, `filltype` decimal(11,5) unsigned zerofill default NULL comment 'tyutfytuy', `boxtype` varchar(255) default NULL, `sheight` int(11) default NULL, `swidth` int(11) default NULL, `sthickness` int(11) default NULL, `isglass` varchar(5) default NULL, `glassincluded` varchar(5) default NULL, `decoration` varchar(255) default NULL, `glassing` int(11) default NULL, `fillet` int(11) default NULL, `store_rests` double default NULL, `rests_date` datetime NOT NULL default '2007-09-26 00:00:00', `price` double default NULL, `price_currency` char(3) default 'RUR', PRIMARY KEY (`id_prod`,`fillmodel`,`sheight`), key (`doorname`(10)) )");
//$sql->query("CREATE TABLE `$testtbl` (`id_prod` int(11) NOT NULL auto_increment, `doorname` varchar(255) default NULL, `fillmodel` int(11) default NULL, PRIMARY KEY (`id_prod`), key (doorname(10)) )");
// function addcol($name,$type,$null,$default,$extra,$comment)
ddc_gentable_n('t1', array(array('id', 'int', 0, NULL, 'auto_increment', NULL), array('t1', 'varchar(100)', 1, NULL, NULL, NULL), array('t2', 'varchar(100)', 1, NULL, NULL, NULL), array('in', 'bigint', 1, NULL, NULL, NULL), array('mf', 'int', 1, NULL, NULL, NULL), array('in2', 'bigint', 1, NULL, NULL, NULL)), array(array('PRIMARY', 'id', NULL), array('1', 't1', 12), array('1', 't2', 12), array('1', 'in', NULL)), $sql);
$v1 = new ddc_raw();
$v1->load_table($testtbl, $sql);
print "<HTML>";
//$r=$sql->query("SHOW COLUMNS FROM `$testtbl`");
//var_dump($v1->cols);
$v1->print_cols();
$v1->print_keys();
//var_dump($v1->keys);
//$v1->delcol('doorname');$v1->delcol('fillmodel');$v1->delcol('filltype');
print $v1->create_query('test');
$v2 = new ddc_raw();
$v2->addcol('test', 'varchar(10)', 1, NULL, NULL, NULL);
$v2->addcol('test1', 'varchar(10)', 1, NULL, NULL, NULL);
$v2->addcol('test2', 'varchar(10)', 1, NULL, NULL, NULL);
$v2->addcol('test3', 'varchar(10)', 1, NULL, NULL, NULL);
$v2->addcol('id', 'int(10) unsigned auto_increment', 1, NULL, NULL, NULL);
$v2->addcol('doorname', 'varchar(10)', 1, NULL, NULL, NULL);
$v2->addcol_to_key('PRIMARY', 'id', NULL);
$v2->addcol_to_key('PRIMARY', 'test', 5);
$v1->gen_changes($v2);
$v1->print_querys();
$r = $v1->commit_changes($sql);
if ($r) {
echo $r;
}
print "Script processing took " . (microtime(true) - $profiler) . " sec<br>";
print $sql->qcnt . ' querys, took ' . $sql->querytime . ' sec';
