CCubridSchema

public function compareTableNames($name1,$name2)
{
    return parent::compareTableNames(strtolower($name1),strtolower($name2));
}

protected function createColumn($column)
{
    $c=new CCubridColumnSchema;
    $c->name=$column['Field'];
    $c->rawName=$this->quoteColumnName($c->name);
    $c->allowNull=$column['Null']==='YES';
    $c->isPrimaryKey=strpos($column['Key'],'PRI')!==false;
    $c->isForeignKey=false;
    $c->init($column['Type'],$column['Default']);
    $c->autoIncrement=strpos(strtolower($column['Extra']),'auto_increment')!==false;

    return $c;
}

protected function findColumns($table)
{
    // it may be good to use CUBRID PHP API to retrieve column info.
    $sql='SHOW COLUMNS FROM '.$table->rawName;
    try
    {
        $columns=$this->getDbConnection()->createCommand($sql)->queryAll();
    }
    catch(Exception $e)
    {
        return false;
    }
    foreach($columns as $column)
    {
        $c=$this->createColumn($column);
        $table->columns[$c->name]=$c;
    }
    return true;
}

protected function findConstraints($table)
{
    $schemas=$this->getDbConnection()->getPdoInstance()->cubrid_schema(PDO::CUBRID_SCH_IMPORTED_KEYS,$table->name);

    foreach($schemas as $schema)
    {
        $table->foreignKeys[$schema["FKCOLUMN_NAME"]]=array($schema["PKTABLE_NAME"],$schema["PKCOLUMN_NAME"]);
        if(isset($table->columns[$schema["FKCOLUMN_NAME"]]))
            $table->columns[$schema["FKCOLUMN_NAME"]]->isForeignKey=true;
    }
}

protected function findPrimaryKeys($table)
{
    $pks=$this->getDbConnection()->getPdoInstance()->cubrid_schema(PDO::CUBRID_SCH_PRIMARY_KEY,$table->name);

    foreach($pks as $pk)
    {
        $c = $table->columns[$pk['ATTR_NAME']];
        $c->isPrimaryKey = true;

        if($table->primaryKey===null)
            $table->primaryKey=$c->name;
        elseif(is_string($table->primaryKey))
            $table->primaryKey=array($table->primaryKey,$c->name);
        else
            $table->primaryKey[]=$c->name;
        if($c->autoIncrement)
            $table->sequenceName='';
    }
}

protected function findTableNames($schema='')
{
    // CUBRID does not allow to look into another database from within another connection.
    // If necessary user has to establish a connection to that particular database and
    // query to show all tables. For this reason if a user executes this funtion
    // we will return all table names of the currently connected database.
    return $this->getDbConnection()->createCommand('SHOW TABLES')->queryColumn();
}

protected function getServerVersion()
{
    $version=$this->getDbConnection()->getAttribute(PDO::ATTR_SERVER_VERSION);
    $digits=array();
    preg_match('/(\d+)\.(\d+)\.(\d+).(\d+)/', $version, $digits);
    return floatval($digits[1].'.'.$digits[2].$digits[3].'.'.$digits[4]);
}

protected function loadTable($name)
{
    $table=new CCubridTableSchema;
    $this->resolveTableNames($table,$name);

    if($this->findColumns($table))
    {
        $this->findPrimaryKeys($table);
        $this->findConstraints($table);
        return $table;
    }
    else
        return null;
}

public function quoteSimpleColumnName($name)
{
    return '`'.$name.'`';
}

public function quoteSimpleTableName($name)
{
    return '`'.$name.'`';
}

public function resetSequence($table,$value=null)
{
    if($table->sequenceName!==null)
    {
        if($value===null)
            $value=$this->getDbConnection()->createCommand("SELECT MAX(`{$table->primaryKey}`) FROM {$table->rawName}")->queryScalar()+1;
        else
            $value=(int)$value;
        $this->getDbConnection()->createCommand("ALTER TABLE {$table->rawName} AUTO_INCREMENT=$value")->execute();
    }
}

protected function resolveTableNames($table,$name)
{
    $parts=explode('.',str_replace('`','',$name));
    if(isset($parts[1]))
    {
        $table->schemaName=$parts[0];
        $table->name=$parts[1];
        $table->rawName=$this->quoteTableName($table->schemaName).'.'.$this->quoteTableName($table->name);
    }
    else
    {
        $table->name=$parts[0];
        $table->rawName=$this->quoteTableName($table->name);
    }
}