public function __construct()
{
if ($db = CModelConnectDB::getInstance()) {
$this->setDbConn($db);
}
}
public function createTable($tableName, $tableInfoArray)
{
$db = CModelConnectDB::getInstance();
$strQuery = "CREATE TABLE `" . $tableName . "` (";
foreach ($tableInfoArray as $nameRecord => $fieldsArray) {
$strQuery .= $nameRecord . " ";
foreach ($fieldsArray as $key => $value) {
switch ($key) {
case "type":
$strQuery .= " " . $value;
break;
case "default":
$strQuery .= " DEFAULT " . $value;
break;
case "constraint":
$strQuery .= " CONSTRAINT " . $value;
break;
case "index":
$strQuery .= " INDEX " . $value;
break;
case "length":
$strQuery .= "(" . $value . ")";
break;
case "auto_increment":
$strQuery .= $value ? " auto_increment" : "";
break;
case "not_null":
$strQuery .= $value ? " not null" : "";
break;
case "unique":
$strQuery .= $value ? " unique" : "";
break;
case "key":
$strQuery .= " " . $value . " key";
break;
default:
break;
}
}
$strQuery .= ", ";
}
$strQuery = substr($strQuery, 0, -2);
$strQuery .= ")";
$db->exec($strQuery);
}
