prefix('multimenu05')." ( ";
$sql .= "id int(5) unsigned NOT NULL auto_increment,";
$sql .= "title varchar(150) NOT NULL default '',";
$sql .= "hide tinyint(1) unsigned NOT NULL default '0',";
$sql .= "link varchar(255) default NULL,";
$sql .= "weight tinyint(4) unsigned NOT NULL default '0',";
$sql .= "target varchar(10) default NULL,";
$sql .= "groups varchar(255) default NULL,";
$sql .= "PRIMARY KEY (id)";
$sql .= ") TYPE=MyISAM;";
print $sql."...";
if ( $xoopsDB->query ( $sql ) ) {
print "
Created Table 'multimenu05' ok
";
} else {
print "
'multimenu05'...It failed. Please make this SQL reference and work manually.
";
}
$sql = "CREATE TABLE ".$xoopsDB->prefix('multimenu06')." ( ";
$sql .= "id int(5) unsigned NOT NULL auto_increment,";
$sql .= "title varchar(150) NOT NULL default '',";
$sql .= "hide tinyint(1) unsigned NOT NULL default '0',";
$sql .= "link varchar(255) default NULL,";
$sql .= "weight tinyint(4) unsigned NOT NULL default '0',";
$sql .= "target varchar(10) default NULL,";
$sql .= "groups varchar(255) default NULL,";
$sql .= "PRIMARY KEY (id)";
$sql .= ") TYPE=MyISAM;";
print $sql."...";
if ( $xoopsDB->query ( $sql ) ) {
print "
Created Table 'multimenu06' ok
";
} else {
print "
'multimenu06'...It failed. Please make this SQL reference and work manually.
";
}
$sql = "CREATE TABLE ".$xoopsDB->prefix('multimenu07')." ( ";
$sql .= "id int(5) unsigned NOT NULL auto_increment,";
$sql .= "title varchar(150) NOT NULL default '',";
$sql .= "hide tinyint(1) unsigned NOT NULL default '0',";
$sql .= "link varchar(255) default NULL,";
$sql .= "weight tinyint(4) unsigned NOT NULL default '0',";
$sql .= "target varchar(10) default NULL,";
$sql .= "groups varchar(255) default NULL,";
$sql .= "PRIMARY KEY (id)";
$sql .= ") TYPE=MyISAM;";
print $sql."...";
if ( $xoopsDB->query ( $sql ) ) {
print "
Created Table 'multimenu07' ok
";
} else {
print "
'multimenu07'...It failed. Please make this SQL reference and work manually.
";
}
$sql = "CREATE TABLE ".$xoopsDB->prefix('multimenu08')." ( ";
$sql .= "id int(5) unsigned NOT NULL auto_increment,";
$sql .= "title varchar(150) NOT NULL default '',";
$sql .= "hide tinyint(1) unsigned NOT NULL default '0',";
$sql .= "link varchar(255) default NULL,";
$sql .= "weight tinyint(4) unsigned NOT NULL default '0',";
$sql .= "target varchar(10) default NULL,";
$sql .= "groups varchar(255) default NULL,";
$sql .= "PRIMARY KEY (id)";
$sql .= ") TYPE=MyISAM;";
print $sql."...";
if ( $xoopsDB->query ( $sql ) ) {
print "
Created Table 'multimenu08' ok
";
} else {
print "
'multimenu08'...It failed. Please make this SQL reference and work manually.
";
}
xoops_cp_footer();
exit;
}
}
?>
The user who updates from version 1.13 series to version 1.14 series needs this processing. |