HavePermission($Permission)) {
exit;
}
header("Content-type: text/html; charset=utf-8");
\Logging\CreateLogging("db.struct.php");
// 创建索引，如果表不存在则会自动创建表
$structInfo = array(
"GameRoles" => array(
array(
array("Channel" => 1, "AccountID" => 1),
array("unique" => true),
)
),
"ServerRoles" => array(
array(
array("Channel" => 1, "AccountID" => 1),
array(),
),
array(
array("Channel" => 1, "PlayerID" => 1),
array(),
),
array(
array("Channel" => 1, "ServerID" => 1),
array(),
),
array(
array("Channel" => 1, "AccountID" => 1, "ServerID" => 1),
array("unique" => true),
)
),
"GameServerInfo" => array(
array(
array("Channel" => 1, "ServerID" => 1),
array("unique" => true),
)
),
"EventReportBug" => array(
array(
array("Channel" => 1, "Time" => -1),
array(),
)
),
"GMTLog" => array(
array(
array("Permission" => 1, "OPTime" => -1),
array(),
)
),
"UserToken" => array(
array(
array("Channel" => 1, "UserGuid" => 1),
array(),
)
),
"PayOrder" => array(
array(
array("OrderID" => 1),
array(),
),
array(
array("Channel" => 1, "ServerID" => 1, "State" => 1, "Createtime" => -1),
array(),
),
array(
array("Channel" => 1, "State" => 1, "PayTime" => -1),
array(),
),
array(
array("PayTime" => 1),
array(),
),
),
"ServerEvent" => array(
array(
array("Key" => 1),
array("unique" => true),
)
),
"AccountFirstLogin" => array(
array(
array("Channel" => 1, "CreateYMD" => 1),
array(),
),
array(
array("Channel" => 1, "AccountID" => 1),
array("unique" => true),
),
),
"AccountFirstLoginReport" => array(
array(
array("Channel" => 1, "CreateYMD" => 1),
array(),
),
array(
array("Channel" => 1, "ReportYMD" => -1),
array(),
),
),
"AccountFirstPay" => array(
array(
array("Channel" => 1, "PayYMD" => 1),
array(),
),
array(
array("Channel" => 1, "AccountID" => 1),
array("unique" => true),
),
),
"AccountFirstPayReport" => array(
array(
array("Channel" => 1, "FirstPayYMD" => 1),
array(),
),
array(
array("Channel" => 1, "ReportYMD" => -1),
array(),
),
),
"AccountDayActive" => array(
array(
array("Channel" => 1, "ActiveYMD" => 1),
array(),
),
array(
array("Channel" => 1, "AccountID" => 1, "ActiveYMD" => 1),
array("unique" => true),
),
),
"DailyReport" => array(
array(
array("Channel" => 1, "YMD" => -1),
array("unique" => true),
),
),
"CoupontypeGroup" => array(
array(
array("Channel" => 1, "AccountID" => 1, "ServerID" => 1),
array("unique" => true),
)
)
);
foreach ($structInfo as $collectionName => $indexList) {
foreach ($indexList as $indexInfo) {
$indexArray = $indexInfo[0];
$indexParam = $indexInfo[1];
$logInfo = "EnsureIndex => " . $collectionName . " index:" . print_r($indexArray, true) . " param:" . print_r($indexParam, true);
if (\DBOper\EnsureIndex($collectionName, $indexArray, $indexParam)) {
\Logging\LogInfo($logInfo);
echo $logInfo, "
";
} else {
echo "";
echo "Error: ", $logInfo, "
";
echo "";
}
}
}
echo "OK", "
";