'TIMESTAMP' => 'int(11) UNSIGNED',

'DECIMAL' => 'decimal(5,2)',

'VCHAR_BIN' => 'varchar(252) BINARY',

'VARBINARY' => 'varbinary(255)',

),

'TIMESTAMP' => 'INTEGER',

'DECIMAL' => 'DOUBLE PRECISION',

'VCHAR_BIN' => 'VARCHAR(252)',

'VARBINARY' => 'CHAR(255)',

),

'TIMESTAMP' => '[int]',

'DECIMAL' => '[float]',

'VCHAR_BIN' => '[nvarchar] (252)',

'VARBINARY' => '[varbinary] (255)',

),

'TIMESTAMP' => 'number(11)',

'DECIMAL' => 'number(5, 2)',

'VCHAR_BIN' => 'varchar2(252)',

'VARBINARY' => 'raw(255)',

),

'sqlite' => array(

'INT:' => 'int(%d)',

'BINT' => 'bigint(20)',

'TINT:' => 'tinyint(%d)',

'VCHAR' => 'varchar(255)',

'VCHAR:' => 'varchar(%d)',

'CHAR:' => 'char(%d)',

'STEXT' => 'text(65535)',

'TEXT' => 'text(65535)',

'MTEXT' => 'mediumtext(16777215)',

'DECIMAL' => 'decimal(5,2)',

'VCHAR_BIN' => 'varchar(252)',

'VARBINARY' => 'blob',

),

case 'firebird':

$line = "#\n# Firebird Schema for phpBB 3.x - (c) phpBB Group, 2005\n#\n# \$I" . "d: $\n#\n\n";

break;

case 'sqlite':

case 'oracle':

$line = "/*\n Oracle Schema for phpBB 3.x - (c) phpBB Group, 2005\n\n \$I" . "d: $\n\n*/\n\n";

break;

case 'postgres':

$line = "/*\n PostgreSQL Schema for phpBB 3.x - (c) phpBB Group, 2005\n\n \$I" . "d: $\n\n*/\n\n";

$line .= "BEGIN;\n\n";

break;

}

case 'mssql':

case 'oracle':

case 'postgres':

break;

}

case 'sqlite':

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

{

}

else

{

$line .= "\t{$column_name} {$column_type} ";

}

$line .= 'NOT NULL ';

$line .= (!is_null($column_data[1])) ? "DEFAULT '{$column_data[1]}'" : '';

$line .= ",\n";

}

$line .= "\t[{$column_name}] {$column_type} ";

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

{

}

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

case 'oracle':

$line .= "\t{$column_name} {$column_type} ";

$line .= (!is_null($column_data[1])) ? "DEFAULT '{$column_data[1]}' " : '';

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

{

$line .= "\n);;\n\n";

break;

case 'mssql':

$line = substr($line, 0, -2);

$line .= "\n) ON [PRIMARY]" . (($textimage) ? ' TEXTIMAGE_ON [PRIMARY]' : '') . "\n";

$line .= "ALTER TABLE {$table_name} ADD PRIMARY KEY (" . implode(', ', $table_data['PRIMARY_KEY']) . ");;\n\n";

break;

case 'mssql':

$line .= "ALTER TABLE [{$table_name}] WITH NOCHECK ADD \n";

$line .= "\tCONSTRAINT [PK_{$table_name}] PRIMARY KEY CLUSTERED \n";

$line = substr($line, 0, -2);

$line .= "\n);\n\n";

break;

}

// Write Keys

case 'postgres':

$line .= ($key_data[0] == 'INDEX') ? 'CREATE INDEX' : '';

$line .= ($key_data[0] == 'UNIQUE') ? 'CREATE UNIQUE INDEX' : '';

$line .= " {$table_name}_{$key_name} ON {$table_name} (" . implode(', ', $key_data[1]) . ");\n";

break;

}

$line .= "\nCREATE GENERATOR {$table_name}_gen;;\n";

$line .= 'SET GENERATOR ' . $table_name . "_gen TO 0;;\n\n";

$line .= "BEFORE INSERT\nAS\nBEGIN\n";

$line .= "\tNEW.{$generator} = GEN_ID({$table_name}_gen, 1);\nEND;;\n\n";

}

{

$line .= "\nCREATE SEQUENCE {$table_name}_seq\n/\n\n";

$line .= "BEFORE INSERT ON {$table_name}\n";

$line .= "FOR EACH ROW WHEN (\n";

$line .= "\tnew.{$generator} IS NULL OR new.{$generator} = 0\n";

switch ($dbms)

{

case 'firebird':

break;

case 'mssql':

'auth_setting' => array('TINT:2', 0),

),

'KEYS' => array(

),

);

),

'PRIMARY_KEY' => 'bbcode_id',

'KEYS' => array(

),

);

$schema_data['phpbb_config'] = array(

'COLUMNS' => array(

'config_value' => array('VCHAR', ''),

'is_dynamic' => array('BOOL', 0),

),

$schema_data['phpbb_disallow'] = array(

'COLUMNS' => array(

'disallow_id' => array('UINT', NULL, 'auto_increment'),

),

'PRIMARY_KEY' => 'disallow_id',

);

'PRIMARY_KEY' => 'forum_id',

'KEYS' => array(

'left_right_id' => array('INDEX', array('left_id', 'right_id')),

),

);

'KEYS' => array(

'forum_id' => array('INDEX', 'forum_id'),

'user_id' => array('INDEX', 'user_id'),

),

);

'display_on_posting' => array('BOOL', 1),

),

'PRIMARY_KEY' => 'icons_id',

);

$schema_data['phpbb_lang'] = array(

'COLUMNS' => array(

'forum_id' => array('UINT', 0),

'user_id' => array('UINT', 0),

'group_id' => array('UINT', 0),

'group_name' => array('VCHAR', ''),

'display_on_index' => array('BOOL', 1),

),

'KEYS' => array(

'forum_id' => array('INDEX', 'forum_id'),

),

);

'poll_option_total' => array('UINT', 0),

),

'KEYS' => array(

'topic_id' => array('INDEX', 'topic_id'),

),

);

'enable_smilies' => array('BOOL', 1),

'enable_magic_url' => array('BOOL', 1),

'enable_sig' => array('BOOL', 1),

'post_subject' => array('XSTEXT', ''),

'post_text' => array('MTEXT', ''),

'post_checksum' => array('VCHAR:32', ''),

),

'KEYS' => array(

'msg_id' => array('INDEX', 'msg_id'),

),

);

),

'PRIMARY_KEY' => 'field_id',

'KEYS' => array(

),

);

$schema_data['phpbb_search_wordlist'] = array(

'COLUMNS' => array(

'word_id' => array('UINT', NULL, 'auto_increment'),

'word_common' => array('BOOL', 0),

),

'KEYS' => array(

),

);

),

'PRIMARY_KEY' => 'smiley_id',

'KEYS' => array(

),

);

$schema_data['phpbb_styles'] = array(

'COLUMNS' => array(

'style_id' => array('TINT:4', NULL, 'auto_increment'),

'style_copyright' => array('VCHAR', ''),

'style_active' => array('BOOL', 1),

'template_id' => array('TINT:4', 0),

$schema_data['phpbb_styles_template'] = array(

'COLUMNS' => array(

'template_id' => array('TINT:4', NULL, 'auto_increment'),

'template_copyright' => array('VCHAR', ''),

'template_path' => array('VCHAR:100', ''),

'bbcode_bitfield' => array('VARBINARY', array('default' => '', 'mysql' => '0x90D8', 'mssql' => '0x90D8', 'oracle' => '90D8', 'postgres' => '\220\330')),

),

'PRIMARY_KEY' => 'template_id',

'KEYS' => array(

),

);

'template_data' => array('MTEXT', ''),

),

'KEYS' => array(

),

);

$schema_data['phpbb_styles_theme'] = array(

'COLUMNS' => array(

'theme_id' => array('TINT:4', NULL, 'auto_increment'),

'theme_copyright' => array('VCHAR', ''),

'theme_path' => array('VCHAR:100', ''),

'theme_storedb' => array('BOOL', 0),

$schema_data['phpbb_styles_imageset'] = array(

'COLUMNS' => array(

'imageset_id' => array('TINT:4', NULL, 'auto_increment'),

'imageset_copyright' => array('VCHAR', ''),

'imageset_path' => array('VCHAR:100', ''),

'site_logo' => array('VCHAR:200', ''),

'poll_left' => array('VCHAR:200', ''),

'poll_center' => array('VCHAR:200', ''),

'poll_right' => array('VCHAR:200', ''),

'user_icon1' => array('VCHAR:200', ''),

'user_icon2' => array('VCHAR:200', ''),

'user_icon3' => array('VCHAR:200', ''),

),

'PRIMARY_KEY' => 'imageset_id',

'KEYS' => array(

),

);

),

'PRIMARY_KEY' => 'topic_id',

'KEYS' => array(

),

);

'KEYS' => array(

'topic_id' => array('INDEX', 'topic_id'),

'user_id' => array('INDEX', 'user_id'),

),

);

/**

*/

{

/*

This first section is optional, however its probably the best method

of running phpBB on Oracle. If you already have a tablespace and user created

/*

CREATE TABLESPACE "PHPBB"

LOGGING

SIZE 10M

AUTOEXTEND ON NEXT 10M

MAXSIZE 100M;

CONNECT phpbb/phpbb_password;

*/

EOF;

*/

CREATE FUNCTION _varchar_ci_equal(varchar_ci, varchar_ci) RETURNS boolean AS 'SELECT LOWER($1) = LOWER($2)' LANGUAGE SQL STRICT;

CREATE FUNCTION _varchar_ci_not_equal(varchar_ci, varchar_ci) RETURNS boolean AS 'SELECT LOWER($1) != LOWER($2)' LANGUAGE SQL STRICT;

CREATE FUNCTION _varchar_ci_less_than(varchar_ci, varchar_ci) RETURNS boolean AS 'SELECT LOWER($1) < LOWER($2)' LANGUAGE SQL STRICT;

CREATE FUNCTION _varchar_ci_greater_than(varchar_ci, varchar_ci) RETURNS boolean AS 'SELECT LOWER($1) > LOWER($2)' LANGUAGE SQL STRICT;

CREATE FUNCTION _varchar_ci_greater_equals(varchar_ci, varchar_ci) RETURNS boolean AS 'SELECT LOWER($1) >= LOWER($2)' LANGUAGE SQL STRICT;

CREATE OPERATOR <(

PROCEDURE = _varchar_ci_less_than,

LEFTARG = varchar_ci,

SORT1= <);

EOF;

}

?> \ No newline at end of file