- 'firebird' => array(

- 'INT:' => 'INTEGER',

- 'BINT' => 'DOUBLE PRECISION',

- 'UINT' => 'INTEGER',

- 'UINT:' => 'INTEGER',

- 'TINT:' => 'INTEGER',

- 'USINT' => 'INTEGER',

- 'BOOL' => 'INTEGER',

- 'VCHAR' => 'VARCHAR(255) CHARACTER SET NONE',

- 'VCHAR:' => 'VARCHAR(%d) CHARACTER SET NONE',

- 'CHAR:' => 'CHAR(%d) CHARACTER SET NONE',

- 'XSTEXT' => 'BLOB SUB_TYPE TEXT CHARACTER SET NONE',

- 'STEXT' => 'BLOB SUB_TYPE TEXT CHARACTER SET NONE',

- 'TEXT' => 'BLOB SUB_TYPE TEXT CHARACTER SET NONE',

- 'MTEXT' => 'BLOB SUB_TYPE TEXT CHARACTER SET NONE',

- 'XSTEXT_UNI'=> 'VARCHAR(100) CHARACTER SET UTF8',

- 'STEXT_UNI' => 'VARCHAR(255) CHARACTER SET UTF8',

- 'TEXT_UNI' => 'BLOB SUB_TYPE TEXT CHARACTER SET UTF8',

- 'MTEXT_UNI' => 'BLOB SUB_TYPE TEXT CHARACTER SET UTF8',

- 'TIMESTAMP' => 'INTEGER',

- 'DECIMAL' => 'DOUBLE PRECISION',

- 'DECIMAL:' => 'DOUBLE PRECISION',

- 'PDECIMAL' => 'DOUBLE PRECISION',

- 'PDECIMAL:' => 'DOUBLE PRECISION',

- 'VCHAR_UNI' => 'VARCHAR(255) CHARACTER SET UTF8',

- 'VCHAR_UNI:'=> 'VARCHAR(%d) CHARACTER SET UTF8',

- 'VCHAR_CI' => 'VARCHAR(255) CHARACTER SET UTF8',

- 'VARBINARY' => 'CHAR(255) CHARACTER SET NONE',

- ),

-

- var $supported_dbms = array('firebird', 'mssql', 'mssqlnative', 'mysql_40', 'mysql_41', 'oracle', 'postgres', 'sqlite', 'sqlite3');

- case 'firebird':

- $sql = 'SELECT rdb$relation_name

- FROM rdb$relations

- WHERE rdb$view_source is null

- AND rdb$system_flag = 0';

- break;

-

- case 'firebird':

- case 'firebird':

-

- case 'firebird':

- if ($create_sequence)

- {

- $statements[] = "CREATE GENERATOR {$table_name}_gen;";

- $statements[] = "SET GENERATOR {$table_name}_gen TO 0;";

-

- $trigger = "CREATE TRIGGER t_$table_name FOR $table_name\n";

- $trigger .= "BEFORE INSERT\nAS\nBEGIN\n";

- $trigger .= "\tNEW.{$create_sequence} = GEN_ID({$table_name}_gen, 1);\nEND;";

- $statements[] = $trigger;

- }

- break;

- case 'firebird':

- $sql = "SELECT RDB\$FIELD_NAME as FNAME

- FROM RDB\$RELATION_FIELDS

- WHERE RDB\$RELATION_NAME = '" . strtoupper($table) . "'";

- break;

-

- case 'firebird':

- $sql = "SELECT LOWER(RDB\$INDEX_NAME) as index_name

- FROM RDB\$INDICES

- WHERE RDB\$RELATION_NAME = '" . strtoupper($table_name) . "'

- AND RDB\$UNIQUE_FLAG IS NULL

- AND RDB\$FOREIGN_KEY IS NULL";

- $col = 'index_name';

- break;

-

- case 'firebird':

- case 'firebird':

- $sql = "SELECT LOWER(RDB\$INDEX_NAME) as index_name

- FROM RDB\$INDICES

- WHERE RDB\$RELATION_NAME = '" . strtoupper($table_name) . "'

- AND RDB\$UNIQUE_FLAG IS NOT NULL

- AND RDB\$FOREIGN_KEY IS NULL";

- $col = 'index_name';

- break;

-

- case 'firebird':

- case 'firebird':

- $sql .= " {$column_type} ";

- $return_array['column_type_sql_type'] = " {$column_type} ";

-

- if (!is_null($column_data[1]))

- {

- $sql .= 'DEFAULT ' . ((is_numeric($column_data[1])) ? $column_data[1] : "'{$column_data[1]}'") . ' ';

- $return_array['column_type_sql_default'] = ((is_numeric($column_data[1])) ? $column_data[1] : "'{$column_data[1]}'") . ' ';

- }

-

- $sql .= 'NOT NULL';

-

- // This is a UNICODE column and thus should be given it's fair share

- if (preg_match('/^X?STEXT_UNI|VCHAR_(CI|UNI:?)/', $column_data[0]))

- {

- $sql .= ' COLLATE UNICODE';

- }

-

- $return_array['auto_increment'] = false;

- if (isset($column_data[2]) && $column_data[2] == 'auto_increment')

- {

- $return_array['auto_increment'] = true;

- }

-

- break;

-

- case 'firebird':

- // Does not support AFTER statement, only POSITION (and there you need the column position)

- $statements[] = 'ALTER TABLE ' . $table_name . ' ADD "' . strtoupper($column_name) . '" ' . $column_data['column_type_sql'];

- break;

-

- case 'firebird':

- $statements[] = 'ALTER TABLE ' . $table_name . ' DROP "' . strtoupper($column_name) . '"';

- break;

-

- case 'firebird':

- case 'firebird':

- $sql = 'SELECT RDB$GENERATOR_NAME as gen

- FROM RDB$GENERATORS

- WHERE RDB$SYSTEM_FLAG = 0

- AND RDB$GENERATOR_NAME = \'' . strtoupper($table_name) . "_GEN'";

- $result = $this->db->sql_query($sql);

-

- // does a generator exist?

- if ($row = $this->db->sql_fetchrow($result))

- {

- $statements[] = "DROP GENERATOR {$row['gen']};";

- }

- $this->db->sql_freeresult($result);

- break;

-

- case 'firebird':

- case 'firebird':

- case 'firebird':

- case 'firebird':

- $sql = "SELECT LOWER(RDB\$INDEX_NAME) as index_name

- FROM RDB\$INDICES

- WHERE RDB\$RELATION_NAME = '" . strtoupper($table_name) . "'

- AND RDB\$UNIQUE_FLAG IS NULL

- AND RDB\$FOREIGN_KEY IS NULL";

- $col = 'index_name';

- break;

-

- case 'firebird':

- case 'firebird':

- // Change type...

- if (!empty($column_data['column_type_sql_default']))

- {

- $statements[] = 'ALTER TABLE ' . $table_name . ' ALTER COLUMN "' . strtoupper($column_name) . '" TYPE ' . ' ' . $column_data['column_type_sql_type'];

- $statements[] = 'ALTER TABLE ' . $table_name . ' ALTER COLUMN "' . strtoupper($column_name) . '" SET DEFAULT ' . ' ' . $column_data['column_type_sql_default'];

- }

- else

- {

- // TODO: try to change pkey without removing trigger, generator or constraints. ATM this query may fail.

- $statements[] = 'ALTER TABLE ' . $table_name . ' ALTER COLUMN "' . strtoupper($column_name) . '" TYPE ' . ' ' . $column_data['column_type_sql_type'];

- }

- break;

-