function mdl_alert_table()
{
foreach ($this->adminStatus as $_key => $_value) {
$_arr_status[] = $_key;
}
$_str_status = implode("','", $_arr_status);
foreach ($this->adminTypes as $_key => $_value) {
$_arr_types[] = $_key;
}
$_str_types = implode("','", $_arr_types);
$_arr_col = $this->mdl_column();
$_arr_alert = array();
if (!in_array("admin_nick", $_arr_col)) {
$_arr_alert["admin_nick"] = array("ADD", "varchar(30) NOT NULL COMMENT '昵称'");
}
if (in_array("admin_id", $_arr_col)) {
$_arr_alert["admin_id"] = array("CHANGE", "smallint NOT NULL AUTO_INCREMENT COMMENT 'ID'", "admin_id");
}
if (in_array("admin_status", $_arr_col)) {
$_arr_alert["admin_status"] = array("CHANGE", "enum('" . $_str_status . "') NOT NULL COMMENT '状态'", "admin_status");
}
if (in_array("admin_pass", $_arr_col)) {
$_arr_alert["admin_pass"] = array("CHANGE", "char(32) NOT NULL COMMENT '密码'", "admin_pass");
}
if (in_array("admin_rand", $_arr_col)) {
$_arr_alert["admin_rand"] = array("CHANGE", "char(6) NOT NULL COMMENT '随机串'", "admin_rand");
}
if (!in_array("admin_type", $_arr_col)) {
$_arr_alert["admin_type"] = array("ADD", "enum('" . $_str_types . "') NOT NULL COMMENT '状态'");
}
$_str_alert = "y0201111";
if ($_arr_alert) {
$_reselt = $this->obj_db->alert_table(BG_DB_TABLE . "admin", $_arr_alert);
if ($_reselt) {
$_str_alert = "y020106";
$_arr_adminData = array("admin_status" => $_arr_status[0]);
$this->obj_db->update(BG_DB_TABLE . "admin", $_arr_adminData, "LENGTH(admin_status)<1");
//将 admin_status 字段为空的记录,更新为默认值
$_arr_adminData = array("admin_type" => $_arr_types[0]);
$this->obj_db->update(BG_DB_TABLE . "admin", $_arr_adminData, "LENGTH(admin_type)<1");
//将 admin_type 字段为空的记录,更新为默认值
}
}
return array("alert" => $_str_alert);
}