用sql命令来手动操作分表
CREATE TABLE `destoon_news_data_30` (
`itemid` bigint(20) unsigned NOT NULL DEFAULT '0',
`content` longtext NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='公司新闻内容_30';
同时参考文件:/admin/global.func.php
function split_content($moduleid, $part) {
global $CFG, $MODULE;
$table = DT_PRE.$moduleid.'_'.$part;
$fd = $moduleid == 4 ? 'userid' : 'itemid';
if(DB::version() > '4.1' && $CFG['db_charset']) {
$type = " ENGINE=MyISAM DEFAULT CHARSET=".$CFG['db_charset'];
} else {
$type = " TYPE=MyISAM";
}
DB::query("CREATE TABLE IF NOT EXISTS `{$table}` (`{$fd}` bigint(20) unsigned NOT NULL default '0',`content` longtext NOT NULL,PRIMARY KEY (`{$fd}`))".$type." COMMENT='".$MODULE[$moduleid]['name']."内容_".$part."'");
}
function split_sell($part) {
global $CFG, $MODULE;
$sql = file_get(DT_ROOT.'/file/setting/split_sell.sql');
$sql or dalert('请检查文件file/setting/split_sell.sql是否存在');
$sql = str_replace('destoon_sell', DT_PRE.'sell_5_'.$part, $sql);
if(DB::version() > '4.1' && $CFG['db_charset']) {
$sql .= " ENGINE=MyISAM DEFAULT CHARSET=".$CFG['db_charset'];
} else {
$sql .= " TYPE=MyISAM";
}
$sql .= " COMMENT='".$MODULE[5]['name']."分表_".$part."';";
DB::query($sql);
}