{

global $cache;

$this->last_query_text = $query;

$this->query_result = ($cache_ttl && method_exists($cache, 'sql_load')) ? $cache->sql_load($query) : false;

$result_id = @mssql_query('SELECT @@IDENTITY', $this->db_connect_id);

if ($result_id)

{

{

@mssql_free_result($result_id);

}

@mssql_free_result($result_id);

}

{

$this->sql_report('start', $query);

}

$this->last_query_text = $query;

$this->query_result = ($cache_ttl && method_exists($cache, 'sql_load')) ? $cache->sql_load($query) : false;

case 'mssql':

case 'mssql_odbc':

$sql_query = preg_replace('#\# MSSQL IDENTITY (phpbb_[a-z_]+) (ON|OFF) \##s', 'SET IDENTITY_INSERT \1 \2', $sql_query);

case 'postgres':

$sql_query = preg_replace('#\# POSTGRES (BEGIN|COMMIT) \##s', '\1; ', $sql_query);

default:

//$sql_query = preg_replace('#\# MSSQL IDENTITY (phpbb_[a-z_]+) (ON|OFF) \##s', '', $sql_query);

case 'mssql':

case 'mssql_odbc':

$sql_query = preg_replace('#\# MSSQL IDENTITY (phpbb_[a-z_]+) (ON|OFF) \##s', 'SET IDENTITY_INSERT \1 \2', $sql_query);

case 'postgres':

$sql_query = preg_replace('#\# POSTGRES (BEGIN|COMMIT) \##s', '\1; ', $sql_query);

default:

//$sql_query = preg_replace('#\# MSSQL IDENTITY (phpbb_[a-z_]+) (ON|OFF) \##s', '', $sql_query);

auth_setting INTEGER DEFAULT 0 NOT NULL

);;

CREATE INDEX phpbb_auth_groups_group_id ON phpbb_auth_groups(group_id);;

auth_setting INTEGER DEFAULT 0 NOT NULL

);;

CREATE INDEX phpbb_auth_users_user_id ON phpbb_auth_users(user_id);;

ALTER TABLE phpbb_bbcodes ADD PRIMARY KEY (bbcode_id);;

# phpbb_bookmarks

# phpbb_cache

CREATE TABLE phpbb_cache (

var_expires INTEGER DEFAULT 0 NOT NULL,

var_data BLOB SUB_TYPE TEXT

);;

ALTER TABLE phpbb_forums ADD PRIMARY KEY (forum_id);;

CREATE INDEX phpbb_forums_left_right_id ON phpbb_forums(left_id, right_id);;

CREATE GENERATOR phpbb_forums_gen;;

);;

CREATE INDEX phpbb_forums_watch_forum_id ON phpbb_forums_watch(forum_id);;

CREATE INDEX phpbb_forums_watch_user_id ON phpbb_forums_watch(user_id);;

display_on_index INTEGER DEFAULT 1 NOT NULL

);;

CREATE INDEX phpbb_moderator_cache_forum_id ON phpbb_moderator_cache(forum_id);;

module_id INTEGER NOT NULL,

module_enabled INTEGER DEFAULT 1 NOT NULL,

module_display INTEGER DEFAULT 1 NOT NULL,

module_class VARCHAR(10) NOT NULL,

parent_id INTEGER NOT NULL,

left_id INTEGER NOT NULL,

poll_option_total INTEGER DEFAULT 0 NOT NULL

);;

CREATE INDEX phpbb_poll_results_topic_id ON phpbb_poll_results(topic_id);;

ALTER TABLE phpbb_profile_fields ADD PRIMARY KEY (field_id);;

CREATE INDEX phpbb_profile_fields_field_type ON phpbb_profile_fields(field_type);;

CREATE GENERATOR phpbb_profile_fields_gen;;

lang_id INTEGER DEFAULT 0 NOT NULL,

option_id INTEGER DEFAULT 0 NOT NULL,

field_type INTEGER DEFAULT 0 NOT NULL,

);;

ALTER TABLE phpbb_profile_fields_lang ADD PRIMARY KEY (field_id, lang_id, option_id);;

# phpbb_styles

CREATE TABLE phpbb_styles (

style_id INTEGER NOT NULL,

style_copyright VARCHAR(255) NOT NULL,

style_active INTEGER DEFAULT 1 NOT NULL,

template_id INTEGER DEFAULT 0 NOT NULL,

# phpbb_styles_imageset

CREATE TABLE phpbb_styles_imageset (

imageset_id INTEGER NOT NULL,

imageset_copyright VARCHAR(255) NOT NULL,

imageset_path VARCHAR(100) NOT NULL,

site_logo VARCHAR(200) NOT NULL,

ALTER TABLE phpbb_styles_imageset ADD PRIMARY KEY (imageset_id);;

CREATE GENERATOR phpbb_styles_imageset_gen;;

SET GENERATOR phpbb_styles_imageset_gen TO 0;;

# phpbb_styles_template

CREATE TABLE phpbb_styles_template (

template_id INTEGER NOT NULL,

template_copyright VARCHAR(255) NOT NULL,

template_path VARCHAR(100) NOT NULL,

bbcode_bitfield INTEGER DEFAULT 0 NOT NULL,

ALTER TABLE phpbb_styles_template ADD PRIMARY KEY (template_id);;

# phpbb_styles_template_data

template_data BLOB SUB_TYPE TEXT

);;

CREATE GENERATOR phpbb_styles_template_data_gen;;

SET GENERATOR phpbb_styles_template_data_gen TO 0;;

BEFORE INSERT

AS

BEGIN

# phpbb_styles_theme

CREATE TABLE phpbb_styles_theme (

theme_id INTEGER NOT NULL,

theme_copyright VARCHAR(255) NOT NULL,

theme_path VARCHAR(100) NOT NULL,

theme_storedb INTEGER DEFAULT 0 NOT NULL,

CREATE INDEX phpbb_topics_forum_id ON phpbb_topics(forum_id);;

CREATE INDEX phpbb_topics_forum_id_type ON phpbb_topics(forum_id, topic_type);;

CREATE GENERATOR phpbb_topics_gen;;

SET GENERATOR phpbb_topics_gen TO 0;;

notify_status INTEGER DEFAULT 0 NOT NULL

);;

CREATE INDEX phpbb_topics_watch_topic_id ON phpbb_topics_watch(topic_id);;

CREATE INDEX phpbb_topics_watch_user_id ON phpbb_topics_watch(user_id);;

user_perm_from INTEGER DEFAULT 0 NOT NULL,

user_ip VARCHAR(40) NOT NULL,

user_regdate INTEGER DEFAULT 0 NOT NULL,

user_password VARCHAR(40) NOT NULL,

user_passchg INTEGER DEFAULT 0 NOT NULL,

user_email VARCHAR(100) NOT NULL,

warning_id INTEGER NOT NULL,

user_id INTEGER DEFAULT 0 NOT NULL,

post_id INTEGER DEFAULT 0 NOT NULL,

);;

ALTER TABLE phpbb_warnings ADD PRIMARY KEY (warning_id);;

'DELETE_BACKUP' => 'Delete Backup',

'DOWNLOAD_BACKUP' => 'Download Backup',

'RESTORE_SUCCESS' => 'The Database has been successfully restored.<br /><br />Your board should be back to the state it was when the backup was made.',

));

?> \ No newline at end of file