diff options
Diffstat (limited to 'phpBB')
| -rw-r--r-- | phpBB/includes/db/firebird.php | 216 | ||||
| -rw-r--r-- | phpBB/includes/db/mssql-odbc.php | 2 | ||||
| -rw-r--r-- | phpBB/includes/functions_admin.php | 11 | ||||
| -rw-r--r-- | phpBB/install/install.php | 2 | ||||
| -rw-r--r-- | phpBB/install/schemas/firebird_schema.sql | 2651 |
5 files changed, 1815 insertions, 1067 deletions
diff --git a/phpBB/includes/db/firebird.php b/phpBB/includes/db/firebird.php index 663d99063a..c745e5cb02 100644 --- a/phpBB/includes/db/firebird.php +++ b/phpBB/includes/db/firebird.php @@ -1,23 +1,15 @@ <?php -/*************************************************************************** - * firebird.php - * ------------------- - * begin : Saturday, Feb 13, 2001 - * copyright :(C) 2001 The phpBB Group - * email : support@phpbb.com - * - * $Id$ - * - ***************************************************************************/ - -/*************************************************************************** - * - * This program is free software; you can redistribute it and/or modify - * it under the terms of the GNU General Public License as published by - * the Free Software Foundation; either version 2 of the License, or - * (at your option) any later version. - * - ***************************************************************************/ +// ------------------------------------------------------------- +// +// $Id$ +// +// FILENAME : firebird.php +// STARTED : Sat Feb 13, 2001 +// COPYRIGHT : © 2001, 2003 phpBB Group +// WWW : http://www.phpbb.com/ +// LICENCE : GPL vs2.0 [ see /docs/COPYING ] +// +// ------------------------------------------------------------- if (!defined('SQL_LAYER')) { @@ -30,25 +22,28 @@ class sql_db var $query_result; var $return_on_error = false; var $transaction = false; - var $sql_report = ''; var $sql_time = 0; + var $num_queries = 0; + var $open_queries = array(); - function sql_connect($sqlserver, $sqluser, $sqlpassword, $database = '', $port = '', $persistency = false) - { - $this->open_queries = array(); - $this->num_queries = 0; + var $last_query_text = ''; + function sql_connect($sqlserver, $sqluser, $sqlpassword, $database, $port = false, $persistency = false) + { $this->persistency = $persistency; $this->user = $sqluser; $this->password = $sqlpassword; - $this->server = $sqlserver; + $this->server = $sqlserver . (($port) ? ':' . $port : ''); + $this->dbname = $database; - $this->db_connect_id =($this->persistency) ? @ibase_pconnect($this->server, $this->user, $this->password, false, false, 3) : @ibase_connect($this->server, $this->user, $this->password, false, false, 3); + $this->db_connect_id = ($this->persistency) ? @ibase_pconnect($this->server . ':' . $this->dbname, $this->user, $this->password, false, false, 3) : @ibase_connect($this->server . ':' . $this->dbname, $this->user, $this->password, false, false, 3); return ($this->db_connect_id) ? $this->db_connect_id : $this->sql_error(''); } + // // Other base methods + // function sql_close() { if (!$this->db_connect_id) @@ -56,9 +51,14 @@ class sql_db return false; } - if (count($this->open_queries)) + if ($this->transaction) + { + @ibase_commit($this->db_connect_id); + } + + if (sizeof($this->open_queries)) { - foreach($this->open_queries as $query_id) + foreach ($this->open_queries as $i_query_id => $query_id) { @ibase_free_query($query_id); } @@ -79,19 +79,19 @@ class sql_db function sql_transaction($status = 'begin') { - switch($status) + switch ($status) { case 'begin': $this->transaction = true; break; case 'commit': - $result = ibase_commit(); + $result = @ibase_commit(); $this->transaction = false; break; case 'rollback': - $result = ibase_rollback(); + $result = @ibase_rollback(); $this->transaction = false; break; @@ -103,95 +103,34 @@ class sql_db } // Base query method - function sql_query($query = '', $expire_time = 0) + function sql_query($query = '', $cache_ttl = 0) { if ($query != '') { global $cache; - if (!$expire_time || !$cache->sql_load($query, $expire_time)) - { - if ($expire_time) - { - $cache_result = true; - } + $this->last_query_text = $query; + $this->query_result = ($cache_ttl && method_exists($cache, 'sql_load')) ? $cache->sql_load($query) : false; - $this->query_result = false; + if (!$this->query_result) + { $this->num_queries++; - if (!empty($_GET['explain'])) - { - global $starttime; - - $curtime = explode(' ', microtime()); - $curtime = $curtime[0] + $curtime[1] - $starttime; - } - - if (($this->query_result = ibase_query($query, $this->db_connect_id)) === FALSE) + if (($this->query_result = @ibase_query($this->db_connect_id, $query)) === false) { $this->sql_error($query); } - if (!$this->transaction && (strpos($query, 'INSERT') === 0 || strpos($query, 'UPDATE') === 0)) + // TODO: have to debug the commit states in firebird + if (!$this->transaction) { - echo $query; - ibase_commit(); + @ibase_commit_ret(); } - if (!empty($_GET['explain'])) + if ($cache_ttl && method_exists($cache, 'sql_save')) { - $endtime = explode(' ', microtime()); - $endtime = $endtime[0] + $endtime[1] - $starttime; - - $this->sql_report .= "<pre>Query:\t" . htmlspecialchars(preg_replace('/[\s]*[\n\r\t]+[\n\r\s\t]*/', "\n\t", $query)) . "\n\n"; - - if ($this->query_result) - { - $this->sql_report .= "Time before: $curtime\nTime after: $endtime\nElapsed time: <b>" .($endtime - $curtime) . "</b>\n</pre>"; - } - else - { - $error = $this->sql_error(); - $this->sql_report .= '<b>FAILED</b> - SQL Error ' . $error['code'] . ': ' . htmlspecialchars($error['message']) . '<br><br><pre>'; - } - - $this->sql_time += $endtime - $curtime; -/* - if (preg_match('/^SELECT/', $query)) - { - $html_table = FALSE; - if ($result = mysql_query("EXPLAIN $query", $this->db_connect_id)) - { - while($row = mysql_fetch_assoc($result)) - { - if (!$html_table && count($row)) - { - $html_table = TRUE; - $this->sql_report .= "<table width=100% border=1 cellpadding=2 cellspacing=1>\n"; - $this->sql_report .= "<tr>\n<td><b>" . implode("</b></td>\n<td><b>", array_keys($row)) . "</b></td>\n</tr>\n"; - } - $this->sql_report .= "<tr>\n<td>" . implode(" </td>\n<td>", array_values($row)) . " </td>\n</tr>\n"; - } - } - - if ($html_table) - { - $this->sql_report .= '</table><br>'; - } - } -*/ - $this->sql_report .= "<hr>\n"; + $cache->sql_save($query, $this->query_result, $cache_ttl); } - - $this->open_queries[] = $this->query_result; - } - - $this->last_query_text[$this->query_result] = $query; - - if (!empty($cache_result)) - { - $cache->sql_save($query, $this->query_result); - @ibase_free_result(array_pop($this->open_queries)); } } else @@ -202,21 +141,20 @@ class sql_db return ($this->query_result) ? $this->query_result : false; } - function sql_query_limit($query, $total, $offset = 0, $expire_time = 0) - { - if ($query != '') + function sql_query_limit($query, $total, $offset = 0, $cache_ttl = 0) + { + if ($query != '') { - $this->query_result = false; - $this->num_queries++; + $this->query_result = false; $query = 'SELECT FIRST ' . $total . ((!empty($offset)) ? ' SKIP ' . $offset : '') . substr($query, 6); - return $this->sql_query($query, $expire_time); - } - else - { - return false; - } + return $this->sql_query($query, $cache_ttl); + } + else + { + return false; + } } // Idea for this from Ikonboard @@ -231,7 +169,7 @@ class sql_db $values = array(); if ($query == 'INSERT') { - foreach($assoc_ary as $key => $var) + foreach ($assoc_ary as $key => $var) { $fields[] = $key; @@ -245,16 +183,16 @@ class sql_db } else { - $values[] =(is_bool($var)) ? intval($var) : $var; + $values[] = (is_bool($var)) ? intval($var) : $var; } } - $query = '(' . implode(', ', $fields) . ') VALUES(' . implode(', ', $values) . ')'; + $query = ' (' . implode(', ', $fields) . ') VALUES (' . implode(', ', $values) . ')'; } - else if ($query == 'UPDATE') + else if ($query == 'UPDATE' || $query == 'SELECT') { $values = array(); - foreach($assoc_ary as $key => $var) + foreach ($assoc_ary as $key => $var) { if (is_null($var)) { @@ -266,16 +204,19 @@ class sql_db } else { - $values[] =(is_bool($var)) ? "$key = " . intval($var) : "$key = $var"; + $values[] = (is_bool($var)) ? "$key = " . intval($var) : "$key = $var"; } } - $query = implode(', ', $values); + $query = implode(($query == 'UPDATE') ? ', ' : ' AND ', $values); } return $query; } // Other query methods + // + // NOTE :: Want to remove _ALL_ reliance on sql_numrows from core code ... + // don't want this here by a middle Milestone function sql_numrows($query_id = false) { return FALSE; @@ -283,10 +224,11 @@ class sql_db function sql_affectedrows() { - return ($this->query_result !== FALSE) ? TRUE : FALSE; // Does this work? + // hmm, maybe doing something similar as in mssql-odbc.php? + return ($this->query_result) ? true : false; } - function sql_fetchrow($query_id = 0) + function sql_fetchrow($query_id = false) { global $cache; @@ -295,20 +237,27 @@ class sql_db $query_id = $this->query_result; } - if ($cache->sql_exists($query_id)) + if (isset($cache->sql_rowset[$query_id])) { return $cache->sql_fetchrow($query_id); } $row = array(); - foreach (get_object_vars(ibase_fetch_object($query_id, IBASE_TEXT)) as $key => $value) + $cur_row = @ibase_fetch_object($query_id, IBASE_TEXT); + + if (!$cur_row) + { + return false; + } + + foreach (get_object_vars($cur_row) as $key => $value) { $row[strtolower($key)] = trim(str_replace("\\0", "\0", str_replace("\\n", "\n", $value))); } return ($query_id) ? $row : false; } - function sql_fetchrowset($query_id = 0) + function sql_fetchrowset($query_id = false) { if (!$query_id) { @@ -319,10 +268,12 @@ class sql_db { unset($this->rowset[$query_id]); unset($this->row[$query_id]); - while($this->rowset[$query_id] = get_object_vars(@ibase_fetch_object($query_id, IBASE_TEXT ))) + + while ($this->rowset[$query_id] = get_object_vars(@ibase_fetch_object($query_id, IBASE_TEXT))) { $result[] = $this->rowset[$query_id]; } + return $result; } else @@ -342,7 +293,9 @@ class sql_db { if ($rownum > -1) { - $result = @mysql_result($query_id, $rownum, $field); + // NOTE: Let's see how often we use this one and how fast we can produce a working query. ;D + // At the moment we are not taking advantage of this feature. + trigger_error('ROWNUM > 0 in sql_fetchfield not supported, please file a bug report.'); } else { @@ -393,7 +346,7 @@ class sql_db function sql_nextid() { - if ($this->query_result && preg_match('#^INSERT[\t\n ]+INTO[\t\n ]+([a-z0-9\_\-]+)#is', $this->last_query_text[$query_id], $tablename)) + if ($this->query_result && preg_match('#^INSERT[\t\n ]+INTO[\t\n ]+([a-z0-9\_\-]+)#is', $this->last_query_text, $tablename)) { $query = "SELECT GEN_ID('" . $tablename[1] . "_gen', 0) AS new_id FROM RDB\$DATABASE"; @@ -416,6 +369,11 @@ class sql_db $query_id = $this->query_result; } + if (!$this->transaction && $query_id) + { + @ibase_commit(); + } + return ($query_id) ? @ibase_free_result($query_id) : false; } diff --git a/phpBB/includes/db/mssql-odbc.php b/phpBB/includes/db/mssql-odbc.php index 75ef7b1ac9..f48e4b6428 100644 --- a/phpBB/includes/db/mssql-odbc.php +++ b/phpBB/includes/db/mssql-odbc.php @@ -256,7 +256,7 @@ class sql_db $row_offset = ($total) ? $offset : ''; $num_rows = ($total) ? $total : $offset; - $query = 'SELECT TOP ' . ($row_offset + $num_rows) . ' ' . preg_replace('/^SELECT/', '', $query); + $query = 'SELECT TOP ' . ($row_offset + $num_rows) . ' ' . substr($query, 6); return $this->sql_query($query, $cache_ttl); } diff --git a/phpBB/includes/functions_admin.php b/phpBB/includes/functions_admin.php index 8a49053345..7aba44595a 100644 --- a/phpBB/includes/functions_admin.php +++ b/phpBB/includes/functions_admin.php @@ -1501,7 +1501,7 @@ function split_sql_file($sql, $delimiter) for ($i = 0; $i < $token_count; $i++) { // Don't wanna add an empty string as the last thing in the array. - if ($i != $token_count - 1 || strlen($tokens[$i] > 0)) + if ($i != $token_count - 1) { // This is the total number of single quotes in the token. $total_quotes = preg_match_all("#'#", $tokens[$i], $matches); @@ -1639,12 +1639,12 @@ function cache_moderators() switch (SQL_LAYER) { case 'mysql': - case 'mysql4': $sql = 'INSERT INTO ' . MODERATOR_TABLE . ' (forum_id, user_id, username, group_id, groupname) VALUES ' . implode(', ', preg_replace('#^(.*)$#', '(\1)', $m_sql)); $db->sql_query($sql); break; + case 'mysql4': case 'mssql': case 'sqlite': $sql = 'INSERT INTO ' . MODERATOR_TABLE . ' (forum_id, user_id, username, group_id, groupname) @@ -1949,10 +1949,10 @@ if (class_exists('auth')) switch (SQL_LAYER) { case 'mysql': - case 'mysql4': $sql = 'VALUES ' . implode(', ', preg_replace('#^(.*?)$#', '(\1)', $sql_subary)); break; + case 'mysql4': case 'mssql': case 'sqlite': $sql = implode(' UNION ALL ', preg_replace('#^(.*?)$#', 'SELECT \1', $sql_subary)); @@ -2091,12 +2091,15 @@ if (class_exists('auth')) switch (SQL_LAYER) { case 'mysql': - case 'mysql4': $sql .= (($sql != '') ? ', ' : '') . "('$option', " . $type_sql[$type] . ")"; break; + + case 'mysql4': case 'mssql': + case 'sqlite': $sql .= (($sql != '') ? ' UNION ALL ' : '') . " SELECT '$option', " . $type_sql[$type]; break; + default: $sql = 'INSERT INTO ' . ACL_OPTIONS_TABLE . " (auth_option, is_global, is_local) VALUES ($option, " . $type_sql[$type] . ")"; diff --git a/phpBB/install/install.php b/phpBB/install/install.php index cf18d6f6bf..9532474c96 100644 --- a/phpBB/install/install.php +++ b/phpBB/install/install.php @@ -83,7 +83,7 @@ $available_dbms = array( 'LABEL' => 'FireBird', 'SCHEMA' => 'firebird', 'MODULE' => 'interbase', - 'DELIM' => ';', + 'DELIM' => ';;', 'COMMENTS' => 'remove_remarks' ), 'mysql' => array( diff --git a/phpBB/install/schemas/firebird_schema.sql b/phpBB/install/schemas/firebird_schema.sql index 6e0deb02ff..a5eeb65efc 100644 --- a/phpBB/install/schemas/firebird_schema.sql +++ b/phpBB/install/schemas/firebird_schema.sql @@ -4,999 +4,1786 @@ # $Id$ # -# Table: phpbb_attachments +# phpbb_attachments CREATE TABLE phpbb_attachments ( - attach_id INTEGER DEFAULT 0 NOT NULL, - post_id INTEGER DEFAULT 0 NOT NULL, - privmsgs_id INTEGER DEFAULT 0 NOT NULL, - user_id_from INTEGER NOT NULL, - user_id_to INTEGER NOT NULL -); - -CREATE INDEX phpbb_attachments_attach_id ON phpbb_attachments (attach_id); -CREATE INDEX phpbb_attachments_privmsgs_id ON phpbb_attachments (privmsgs_id); - -# Table: phpbb_attach_desc -CREATE TABLE phpbb_attach_desc ( attach_id INTEGER NOT NULL, + post_msg_id INTEGER DEFAULT 0 NOT NULL, + topic_id INTEGER DEFAULT 0 NOT NULL, + in_message INTEGER DEFAULT 0 NOT NULL, + poster_id INTEGER DEFAULT 0 NOT NULL, physical_filename VARCHAR(255) NOT NULL, real_filename VARCHAR(255) NOT NULL, - download_count INTEGER DEFAULT 0 NOT NULL, - comment VARCHAR(255) DEFAULT '', + download_count INTEGER DEFAULT 0 NOT NULL, + comment VARCHAR(255), extension VARCHAR(100), mimetype VARCHAR(100), - filesize INTEGER NOT NULL, - filetime INTEGER DEFAULT 0 NOT NULL, - thumbnail SMALLINT DEFAULT 0 NOT NULL, - PRIMARY KEY (attach_id) -); - -CREATE GENERATOR phpbb_attach_desc_gen; -SET GENERATOR phpbb_attach_desc_gen TO 0; -CREATE INDEX phpbb_attach_desc_filetime ON phpbb_attach_desc (filetime); -CREATE INDEX phpbb_attach_desc_filesize ON phpbb_attach_desc (filesize); - -CREATE TRIGGER phpbb_attach_desc_trig - FOR phpbb_attach_desc BEFORE INSERT - AS BEGIN - IF (NEW.attach_id IS NULL) THEN - NEW.attach_id = GEN_ID(phpbb_attach_desc_gen, 1)| - END; - -# Table: phpbb_auth_groups -CREATE TABLE phpbb_auth_groups ( - group_id INTEGER DEFAULT 0 NOT NULL, - forum_id INTEGER DEFAULT 0 NOT NULL, - auth_option_id SMALLINT DEFAULT 0 NOT NULL, - auth_setting SMALLINT DEFAULT 0 NOT NULL -); + filesize INTEGER DEFAULT 0 NOT NULL, + filetime INTEGER DEFAULT 0 NOT NULL, + thumbnail INTEGER DEFAULT 0 NOT NULL +);; -CREATE INDEX phpbb_auth_groups_group_id ON phpbb_auth_groups (group_id); -CREATE INDEX phpbb_auth_groups_option_id ON phpbb_auth_groups (auth_option_id); +# phpbb_auth_groups +CREATE TABLE phpbb_auth_groups ( + group_id INTEGER DEFAULT 0 NOT NULL, + forum_id INTEGER DEFAULT 0 NOT NULL, + auth_option_id INTEGER DEFAULT 0 NOT NULL, + auth_setting INTEGER DEFAULT 0 NOT NULL +);; -# Table: phpbb_auth_options +# phpbb_auth_options CREATE TABLE phpbb_auth_options ( - auth_option_id SMALLINT NOT NULL, - auth_option CHAR(20) NOT NULL, - is_global SMALLINT DEFAULT 0 NOT NULL, - is_local SMALLINT DEFAULT 0 NOT NULL, - founder_only SMALLINT DEFAULT 0 NOT NULL, - PRIMARY KEY (auth_option_id) -); - -CREATE GENERATOR phpbb_auth_options_gen; -SET GENERATOR phpbb_auth_options_gen TO 0; -CREATE INDEX phpbb_auth_options_auth_option ON phpbb_auth_options (auth_option); - -CREATE TRIGGER phpbb_auth_options_trig - FOR phpbb_auth_options BEFORE INSERT - AS BEGIN - IF (NEW.auth_option_id IS NULL) THEN - NEW.auth_option_id = GEN_ID(phpbb_auth_options_gen, 1)| - END; - -# Table: phpbb_auth_presets + auth_option_id INTEGER NOT NULL, + auth_option VARCHAR(20) NOT NULL, + is_global INTEGER DEFAULT 0 NOT NULL, + is_local INTEGER DEFAULT 0 NOT NULL, + founder_only INTEGER DEFAULT 0 NOT NULL +);; + +# phpbb_auth_presets CREATE TABLE phpbb_auth_presets ( - preset_id SMALLINT NOT NULL, - preset_name VARCHAR(50) NOT NULL, - preset_user_id INTEGER NOT NULL, - preset_type VARCHAR(2) NOT NULL, - preset_data BLOB SUB_TYPE 1, - PRIMARY KEY (preset_id) -); - -CREATE GENERATOR phpbb_auth_presets_gen; -SET GENERATOR phpbb_auth_presets_gen TO 0; -CREATE INDEX phpbb_auth_presets_type ON phpbb_auth_presets (preset_type); - -CREATE TRIGGER phpbb_auth_presets_trig - FOR phpbb_auth_presets BEFORE INSERT - AS BEGIN - IF (NEW.preset_id IS NULL) THEN - NEW.preset_id = GEN_ID(phpbb_auth_presets_gen, 1)| - END; - -# Table: phpbb_auth_users + preset_id INTEGER NOT NULL, + preset_name VARCHAR(50) NOT NULL, + preset_user_id INTEGER DEFAULT 0 NOT NULL, + preset_type VARCHAR(2) NOT NULL, + preset_data BLOB SUB_TYPE TEXT NOT NULL +);; + +# phpbb_auth_users CREATE TABLE phpbb_auth_users ( - user_id INTEGER DEFAULT 0 NOT NULL, - forum_id INTEGER DEFAULT 0 NOT NULL, - auth_option_id SMALLINT DEFAULT 0 NOT NULL, - auth_setting SMALLINT DEFAULT 0 NOT NULL -); + user_id INTEGER DEFAULT 0 NOT NULL, + forum_id INTEGER DEFAULT 0 NOT NULL, + auth_option_id INTEGER DEFAULT 0 NOT NULL, + auth_setting INTEGER DEFAULT 0 NOT NULL +);; -CREATE INDEX phpbb_auth_users_user_id ON phpbb_auth_users (user_id); -CREATE INDEX phpbb_auth_users_option_id ON phpbb_auth_users (auth_option_id); - -# Table: 'phpbb_banlist' +# phpbb_banlist CREATE TABLE phpbb_banlist ( - ban_id INTEGER NOT NULL, - ban_userid INTEGER DEFAULT 0 NOT NULL, - ban_ip VARCHAR(40) DEFAULT '' NOT NULL, - ban_email VARCHAR(50) DEFAULT '' NOT NULL, - ban_start INTEGER DEFAULT 0 NOT NULL, - ban_end INTEGER DEFAULT 0 NOT NULL, - ban_exclude SMALLINT DEFAULT 0 NOT NULL, - ban_reason VARCHAR(255), - ban_give_reason VARCHAR(255) DEFAULT '' NOT NULL, - PRIMARY KEY (ban_id) -); - -CREATE GENERATOR phpbb_banlist_gen; -SET GENERATOR phpbb_banlist_gen TO 0; - -CREATE TRIGGER phpbb_banlist_trig - FOR phpbb_banlist BEFORE INSERT - AS BEGIN - IF (NEW.ban_id IS NULL) THEN - NEW.ban_id = GEN_ID(phpbb_banlist_gen, 1)| - END; - -# Table: 'phpbb_cache' + ban_id INTEGER NOT NULL, + ban_userid INTEGER DEFAULT 0 NOT NULL, + ban_ip VARCHAR(40) NOT NULL, + ban_email VARCHAR(50) NOT NULL, + ban_start INTEGER DEFAULT 0 NOT NULL, + ban_end INTEGER DEFAULT 0 NOT NULL, + ban_exclude INTEGER DEFAULT 0 NOT NULL, + ban_reason VARCHAR(255) NOT NULL, + ban_give_reason VARCHAR(255) NOT NULL +);; + +# phpbb_bbcodes +CREATE TABLE phpbb_bbcodes ( + bbcode_id INTEGER DEFAULT 0 NOT NULL, + bbcode_tag VARCHAR(16) NOT NULL, + bbcode_match VARCHAR(255) NOT NULL, + bbcode_tpl BLOB SUB_TYPE TEXT NOT NULL, + first_pass_match VARCHAR(255) NOT NULL, + first_pass_replace VARCHAR(255) NOT NULL, + second_pass_match VARCHAR(255) NOT NULL, + second_pass_replace BLOB SUB_TYPE TEXT NOT NULL +);; + +# phpbb_bookmarks +CREATE TABLE phpbb_bookmarks ( + topic_id INTEGER DEFAULT 0 NOT NULL, + user_id INTEGER DEFAULT 0 NOT NULL, + order_id INTEGER DEFAULT 0 NOT NULL +);; + +# phpbb_bots +CREATE TABLE phpbb_bots ( + bot_id INTEGER NOT NULL, + bot_active INTEGER DEFAULT 1 NOT NULL, + bot_name VARCHAR(255) NOT NULL, + user_id INTEGER DEFAULT 0 NOT NULL, + bot_agent VARCHAR(255) NOT NULL, + bot_ip VARCHAR(255) NOT NULL +);; + +# phpbb_cache CREATE TABLE phpbb_cache ( - var_name VARCHAR(255) NOT NULL, - var_ts INTEGER DEFAULT 0 NOT NULL, - var_data TEXT DEFAULT '' NOT NULL, - PRIMARY KEY (var_name) -); + var_name VARCHAR(200) NOT NULL, + var_expires INTEGER DEFAULT 0 NOT NULL, + var_data BLOB SUB_TYPE TEXT NOT NULL +);; -# Table: 'phpbb_config' +# phpbb_config CREATE TABLE phpbb_config ( - config_name VARCHAR(50) NOT NULL, - config_value VARCHAR(255) NOT NULL, - is_dynamic SMALLINT DEFAULT 0 NOT NULL, - PRIMARY KEY (config_name) -); - -CREATE INDEX phpbb_config_is_dynamic ON phpbb_config (is_dynamic); + config_name VARCHAR(200) NOT NULL, + config_value VARCHAR(255) NOT NULL, + is_dynamic INTEGER DEFAULT 0 NOT NULL +);; -# Table: 'phpbb_confirm' +# phpbb_confirm CREATE TABLE phpbb_confirm ( - confirm_id CHAR(32) DEFAULT '' NOT NULL, - session_id CHAR(32) DEFAULT '' NOT NULL, - code CHAR(6) DEFAULT '' NOT NULL, - PRIMARY KEY (session_id, confirm_id) -); + confirm_id VARCHAR(32) NOT NULL, + session_id VARCHAR(32) NOT NULL, + code VARCHAR(6) NOT NULL +);; - -# Table: 'phpbb_disallow' +# phpbb_disallow CREATE TABLE phpbb_disallow ( - disallow_id INTEGER NOT NULL, - disallow_username VARCHAR(30), - PRIMARY KEY (disallow_id) -); - -CREATE GENERATOR phpbb_disallow_gen; -SET GENERATOR phpbb_disallow_gen TO 0; - -CREATE TRIGGER phpbb_disallow_trig - FOR phpbb_disallow BEFORE INSERT - AS BEGIN - IF (NEW.disallow_id IS NULL) THEN - NEW.disallow_id = GEN_ID(phpbb_disallow_gen, 1)| - END; - -# Table: 'phpbb_extensions' -CREATE TABLE phpbb_extensions ( - extension_id INTEGER NOT NULL, - group_id INTEGER DEFAULT 0 NOT NULL, - extension VARCHAR(100) DEFAULT '' NOT NULL, - comment VARCHAR(100) DEFAULT '' NOT NULL, - PRIMARY KEY (extension_id) -); - -CREATE GENERATOR phpbb_extensions_gen; -SET GENERATOR phpbb_extensions_gen TO 0; - -CREATE TRIGGER phpbb_extensions_trig - FOR phpbb_extensions BEFORE INSERT - AS BEGIN - IF (NEW.extension_id IS NULL) THEN - NEW.extension_id = GEN_ID(phpbb_extensions_gen, 1)| - END; - -# Table: 'phpbb_extension_groups' + disallow_id INTEGER NOT NULL, + disallow_username VARCHAR(30) NOT NULL +);; + +# phpbb_drafts +CREATE TABLE phpbb_drafts ( + draft_id INTEGER NOT NULL, + user_id INTEGER DEFAULT 0 NOT NULL, + topic_id INTEGER DEFAULT 0 NOT NULL, + forum_id INTEGER DEFAULT 0 NOT NULL, + save_time INTEGER DEFAULT 0 NOT NULL, + draft_subject VARCHAR(60), + draft_message BLOB SUB_TYPE TEXT NOT NULL +);; + +# phpbb_extension_groups CREATE TABLE phpbb_extension_groups ( group_id INTEGER NOT NULL, - group_name VARCHAR(20) DEFAULT '' NOT NULL, - cat_id SMALLINT DEFAULT 0 NOT NULL, - allow_group SMALLINT DEFAULT 0 NOT NULL, - download_mode SMALLINT DEFAULT 1 NOT NULL, - upload_icon VARCHAR(100) DEFAULT '' NOT NULL, - max_filesize INTEGER DEFAULT 0 NOT NULL, - PRIMARY KEY (group_id) -); - -CREATE GENERATOR phpbb_extension_groups_gen; -SET GENERATOR phpbb_extension_groups_gen TO 0; - -CREATE TRIGGER phpbb_extension_groups_trig - FOR phpbb_extension_groups BEFORE INSERT - AS BEGIN - IF (NEW.group_id IS NULL) THEN - NEW.group_id = GEN_ID(phpbb_extension_groups_gen, 1)| - END; - -# Table: 'phpbb_forums' -CREATE TABLE phpbb_forums ( - forum_id SMALLINT NOT NULL, - parent_id SMALLINT NOT NULL, - left_id SMALLINT NOT NULL, - right_id SMALLINT NOT NULL, - forum_parents BLOB SUB_TYPE 1, - forum_name VARCHAR(150) NOT NULL, - forum_desc BLOB SUB_TYPE 1, - forum_link VARCHAR(200) DEFAULT '' NOT NULL, - forum_password VARCHAR(32) DEFAULT '' NOT NULL, - forum_style SMALLINT DEFAULT 0 NOT NULL, - forum_image VARCHAR(50) DEFAULT '' NOT NULL, - forum_topics_per_page SMALLINT DEFAULT 0 NOT NULL, - forum_type SMALLINT DEFAULT 0 NOT NULL, - forum_status SMALLINT DEFAULT 0 NOT NULL, - forum_posts INTEGER DEFAULT 0 NOT NULL, - forum_topics INTEGER DEFAULT 0 NOT NULL, - forum_topics_real INTEGER DEFAULT 0 NOT NULL, - forum_last_post_id INTEGER DEFAULT 0 NOT NULL, - forum_last_poster_id INTEGER DEFAULT 0 NOT NULL, - forum_last_post_time INTEGER DEFAULT 0 NOT NULL, - forum_last_poster_name VARCHAR(30) DEFAULT '' NOT NULL, - forum_flags SMALLINT DEFAULT 0 NOT NULL, - display_on_index SMALLINT DEFAULT 1 NOT NULL, - enable_icons SMALLINT DEFAULT 1 NOT NULL, - enable_prune SMALLINT DEFAULT 0 NOT NULL, - prune_next INTEGER DEFAULT 0 NOT NULL, - prune_days SMALLINT DEFAULT 0 NOT NULL, - prune_freq SMALLINT DEFAULT 0 NOT NULL, - PRIMARY KEY (forum_id) -); - -CREATE GENERATOR phpbb_forums_gen; -SET GENERATOR phpbb_forums_gen TO 0; -CREATE INDEX phpbb_forums_left_id ON phpbb_forums (left_id); -CREATE INDEX phpbb_forums_last_post_id ON phpbb_forums (forum_last_post_id); - -CREATE TRIGGER phpbb_forums_trig - FOR phpbb_forums BEFORE INSERT - AS BEGIN - IF (NEW.forum_id IS NULL) THEN - NEW.forum_id = GEN_ID(phpbb_forums_gen, 1)| - END; - -# Table: phpbb_forum_access + group_name VARCHAR(20) NOT NULL, + cat_id INTEGER DEFAULT 0 NOT NULL, + allow_group INTEGER DEFAULT 0 NOT NULL, + download_mode INTEGER DEFAULT 1 NOT NULL, + upload_icon VARCHAR(100) NOT NULL, + max_filesize INTEGER DEFAULT 0 NOT NULL, + allowed_forums BLOB SUB_TYPE TEXT NOT NULL, + allow_in_pm INTEGER DEFAULT 0 NOT NULL +);; + +# phpbb_extensions +CREATE TABLE phpbb_extensions ( + extension_id INTEGER NOT NULL, + group_id INTEGER DEFAULT 0 NOT NULL, + extension VARCHAR(100) NOT NULL +);; + +# phpbb_forum_access CREATE TABLE phpbb_forum_access ( - forum_id INTEGER DEFAULT 0 NOT NULL, - user_id INTEGER DEFAULT 0 NOT NULL, - session_id CHAR(32) DEFAULT '' NOT NULL, - PRIMARY KEY (forum_id,user_id,session_id) -); + forum_id INTEGER DEFAULT 0 NOT NULL, + user_id INTEGER DEFAULT 0 NOT NULL, + session_id VARCHAR(32) NOT NULL +);; -# Table: 'phpbb_forums_marking' +# phpbb_forums +CREATE TABLE phpbb_forums ( + forum_id INTEGER NOT NULL, + parent_id INTEGER DEFAULT 0 NOT NULL, + left_id INTEGER DEFAULT 0 NOT NULL, + right_id INTEGER DEFAULT 0 NOT NULL, + forum_parents BLOB SUB_TYPE TEXT, + forum_name VARCHAR(150) NOT NULL, + forum_desc BLOB SUB_TYPE TEXT, + forum_link VARCHAR(200) NOT NULL, + forum_password VARCHAR(32) NOT NULL, + forum_style INTEGER, + forum_image VARCHAR(50) NOT NULL, + forum_rules BLOB SUB_TYPE TEXT NOT NULL, + forum_rules_link VARCHAR(200) NOT NULL, + forum_rules_flags INTEGER DEFAULT 0 NOT NULL, + forum_rules_bbcode_bitfield INTEGER DEFAULT 0 NOT NULL, + forum_rules_bbcode_uid VARCHAR(5) NOT NULL, + forum_topics_per_page INTEGER DEFAULT 0 NOT NULL, + forum_type INTEGER DEFAULT 0 NOT NULL, + forum_status INTEGER DEFAULT 0 NOT NULL, + forum_posts INTEGER DEFAULT 0 NOT NULL, + forum_topics INTEGER DEFAULT 0 NOT NULL, + forum_topics_real INTEGER DEFAULT 0 NOT NULL, + forum_last_post_id INTEGER DEFAULT 0 NOT NULL, + forum_last_poster_id INTEGER DEFAULT 0 NOT NULL, + forum_last_post_time INTEGER DEFAULT 0 NOT NULL, + forum_last_poster_name VARCHAR(30), + forum_flags INTEGER DEFAULT 0 NOT NULL, + display_on_index INTEGER DEFAULT 1 NOT NULL, + enable_indexing INTEGER DEFAULT 1 NOT NULL, + enable_icons INTEGER DEFAULT 1 NOT NULL, + enable_prune INTEGER DEFAULT 0 NOT NULL, + prune_next INTEGER, + prune_days INTEGER DEFAULT 0 NOT NULL, + prune_viewed INTEGER DEFAULT 0 NOT NULL, + prune_freq INTEGER DEFAULT 0 NOT NULL +);; + +# phpbb_forums_marking CREATE TABLE phpbb_forums_marking ( - user_id INTEGER DEFAULT 0 NOT NULL, - forum_id INTEGER DEFAULT 0 NOT NULL, - mark_time INTEGER DEFAULT 0 NOT NULL, - PRIMARY KEY (user_id, forum_id) -); + user_id INTEGER DEFAULT 0 NOT NULL, + forum_id INTEGER DEFAULT 0 NOT NULL, + mark_time INTEGER DEFAULT 0 NOT NULL +);; -# Table: 'phpbb_forums_watch' +# phpbb_forums_watch CREATE TABLE phpbb_forums_watch ( - forum_id SMALLINT DEFAULT 0 NOT NULL, - user_id INTEGER DEFAULT 0 NOT NULL, - notify_status SMALLINT DEFAULT 0 NOT NULL -); - -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); -CREATE INDEX phpbb_forums_watch_status ON phpbb_forums_watch (notify_status); + forum_id INTEGER DEFAULT 0 NOT NULL, + user_id INTEGER DEFAULT 0 NOT NULL, + notify_status INTEGER DEFAULT 0 NOT NULL +);; -# Table: 'phpbb_groups' +# phpbb_groups CREATE TABLE phpbb_groups ( - group_id INTEGER NOT NULL, - group_type SMALLINT DEFAULT 1 NOT NULL, - group_name VARCHAR(40) DEFAULT '' NOT NULL, - group_display SMALLINT DEFAULT 0 NOT NULL, - group_avatar VARCHAR(100) DEFAULT '' NOT NULL, - group_avatar_type SMALLINT DEFAULT 0 NOT NULL, - group_rank INTEGER DEFAULT 0 NOT NULL, - group_colour VARCHAR(6) DEFAULT '' NOT NULL, - group_description VARCHAR(255) DEFAULT '' NOT NULL, - PRIMARY KEY (group_id) -); - -CREATE GENERATOR phpbb_groups_gen; -SET GENERATOR phpbb_groups_gen TO 0; - -CREATE TRIGGER phpbb_groups_trig - FOR phpbb_groups BEFORE INSERT - AS BEGIN - IF (NEW.group_id IS NULL) THEN - NEW.group_id = GEN_ID(phpbb_groups_gen, 1)| - END; - -# Table: 'phpbb_groups_moderator' -CREATE TABLE phpbb_groups_moderator ( - group_id INTEGER NOT NULL, - user_id INTEGER NOT NULL -); - -# Table: 'phpbb_icons' + group_id INTEGER NOT NULL, + group_type INTEGER DEFAULT 1 NOT NULL, + group_name VARCHAR(40) NOT NULL, + group_display INTEGER DEFAULT 0 NOT NULL, + group_avatar VARCHAR(100) NOT NULL, + group_avatar_type INTEGER DEFAULT 0 NOT NULL, + group_avatar_width INTEGER DEFAULT 0 NOT NULL, + group_avatar_height INTEGER DEFAULT 0 NOT NULL, + group_rank INTEGER DEFAULT -1 NOT NULL, + group_colour VARCHAR(6) NOT NULL, + group_sig_chars INTEGER DEFAULT 0 NOT NULL, + group_receive_pm INTEGER DEFAULT 0 NOT NULL, + group_message_limit INTEGER DEFAULT 0 NOT NULL, + group_chgpass INTEGER DEFAULT 0 NOT NULL, + group_description VARCHAR(255) NOT NULL, + group_legend INTEGER DEFAULT 1 NOT NULL +);; + +# phpbb_icons CREATE TABLE phpbb_icons ( - icons_id SMALLINT NOT NULL, - icons_url VARCHAR(50), - icons_width SMALLINT NOT NULL, - icons_height SMALLINT NOT NULL, - icons_order SMALLINT NOT NULL, - display_on_posting SMALLINT DEFAULT 1 NOT NULL, - PRIMARY KEY (icons_id) -); - -CREATE GENERATOR phpbb_icons_gen; -SET GENERATOR phpbb_icons_gen TO 0; - -CREATE TRIGGER phpbb_icons_trig - FOR phpbb_icons BEFORE INSERT - AS BEGIN - IF (NEW.icons_id IS NULL) THEN - NEW.icons_id = GEN_ID(phpbb_icons_gen, 1)| - END; - -# Table: 'phpbb_lang' + icons_id INTEGER NOT NULL, + icons_url VARCHAR(50), + icons_width INTEGER DEFAULT 0 NOT NULL, + icons_height INTEGER DEFAULT 0 NOT NULL, + icons_order INTEGER DEFAULT 0 NOT NULL, + display_on_posting INTEGER DEFAULT 1 NOT NULL +);; + +# phpbb_lang CREATE TABLE phpbb_lang ( - lang_id SMALLINT NOT NULL, - lang_iso VARCHAR(5) NOT NULL, - lang_dir VARCHAR(30) NOT NULL, - lang_english_name VARCHAR(30), - lang_local_name VARCHAR(100), - lang_author VARCHAR(100), - PRIMARY KEY (lang_id) -); - -CREATE GENERATOR phpbb_lang_gen; -SET GENERATOR phpbb_lang_gen TO 0; - -CREATE TRIGGER phpbb_lang_trig - FOR phpbb_lang BEFORE INSERT - AS BEGIN - IF (NEW.lang_id IS NULL) THEN - NEW.lang_id = GEN_ID(phpbb_lang_gen, 1)| - END; - -# Table: 'phpbb_log_moderator' -CREATE TABLE phpbb_log_moderator ( - log_id INTEGER DEFAULT 0 NOT NULL, - user_id INTEGER DEFAULT 0 NOT NULL, - forum_id INTEGER DEFAULT 0 NOT NULL, - topic_id INTEGER DEFAULT 0 NOT NULL, - log_ip VARCHAR(40) NOT NULL, - log_time INTEGER NOT NULL, - log_operation BLOB SUB_TYPE 1, - log_data BLOB SUB_TYPE 1, - PRIMARY KEY (log_id) -); - -CREATE GENERATOR phpbb_log_moderator_gen; -SET GENERATOR phpbb_log_moderator_gen TO 0; -CREATE INDEX phpbb_log_moderator_forum ON phpbb_log_moderator (forum_id); -CREATE INDEX phpbb_log_moderator_topic ON phpbb_log_moderator (topic_id); -CREATE INDEX phpbb_log_moderator_user ON phpbb_log_moderator (user_id); - -CREATE TRIGGER phpbb_log_moderator_trig - FOR phpbb_log_moderator BEFORE INSERT - AS BEGIN - IF (NEW.log_id IS NULL) THEN - NEW.log_id = GEN_ID(phpbb_log_moderator_gen, 1)| - END; - -# Table: 'phpbb_log_admin' -CREATE TABLE phpbb_log_admin ( + lang_id INTEGER NOT NULL, + lang_iso VARCHAR(5) NOT NULL, + lang_dir VARCHAR(30) NOT NULL, + lang_english_name VARCHAR(30), + lang_local_name VARCHAR(100), + lang_author VARCHAR(100) +);; + +# phpbb_log +CREATE TABLE phpbb_log ( log_id INTEGER NOT NULL, - user_id INTEGER DEFAULT 0 NOT NULL, + log_type INTEGER DEFAULT 0 NOT NULL, + user_id INTEGER DEFAULT 0 NOT NULL, + forum_id INTEGER DEFAULT 0 NOT NULL, + topic_id INTEGER DEFAULT 0 NOT NULL, + reportee_id INTEGER DEFAULT 0 NOT NULL, log_ip VARCHAR(40) NOT NULL, - log_time INTEGER NOT NULL, - log_operation BLOB SUB_TYPE 1, - log_data BLOB SUB_TYPE 1, - PRIMARY KEY (log_id) -); - -CREATE GENERATOR phpbb_log_admin_gen; -SET GENERATOR phpbb_log_admin_gen TO 0; -CREATE INDEX phpbb_log_admin_user_id ON phpbb_log_admin (user_id); - -CREATE TRIGGER phpbb_log_admin_trig - FOR phpbb_log_admin BEFORE INSERT - AS BEGIN - IF (NEW.log_id IS NULL) THEN - NEW.log_id = GEN_ID(phpbb_log_admin_gen, 1)| - END; - -# Table: 'phpbb_moderator_cache' -CREATE TABLE phpbb_moderator_cache ( - forum_id INTEGER NOT NULL, - user_id INTEGER, - username CHAR(30), - group_id INTEGER, - groupname CHAR(30), - display_on_index SMALLINT DEFAULT 1 NOT NULL -); + log_time INTEGER DEFAULT 0 NOT NULL, + log_operation BLOB SUB_TYPE TEXT, + log_data BLOB SUB_TYPE TEXT +);; -CREATE INDEX phpbb_mod_cache_disp ON phpbb_moderator_cache (display_on_index); -CREATE INDEX phpbb_mod_cache_forum ON phpbb_moderator_cache (forum_id); - -# Table: 'phpbb_vote_results' +# phpbb_moderator_cache +CREATE TABLE phpbb_moderator_cache ( + forum_id INTEGER DEFAULT 0 NOT NULL, + user_id INTEGER DEFAULT 0 NOT NULL, + username VARCHAR(30) NOT NULL, + group_id INTEGER DEFAULT 0 NOT NULL, + groupname VARCHAR(30) NOT NULL, + display_on_index INTEGER DEFAULT 1 NOT NULL +);; + +# phpbb_modules +CREATE TABLE phpbb_modules ( + module_id INTEGER NOT NULL, + module_type VARCHAR(3) NOT NULL, + module_title VARCHAR(50) NOT NULL, + module_filename VARCHAR(50) NOT NULL, + module_order INTEGER DEFAULT 0 NOT NULL, + module_enabled INTEGER DEFAULT 1 NOT NULL, + module_subs BLOB SUB_TYPE TEXT NOT NULL, + module_acl VARCHAR(255) NOT NULL +);; + +# phpbb_poll_results CREATE TABLE phpbb_poll_results ( - poll_option_id SMALLINT DEFAULT 0 NOT NULL, - topic_id INTEGER DEFAULT 0 NOT NULL, - poll_option_text VARCHAR(255) DEFAULT '' NOT NULL, - poll_option_total INTEGER DEFAULT 0 NOT NULL -); + poll_option_id INTEGER DEFAULT 0 NOT NULL, + topic_id INTEGER DEFAULT 0 NOT NULL, + poll_option_text VARCHAR(255) NOT NULL, + poll_option_total INTEGER DEFAULT 0 NOT NULL +);; -CREATE INDEX phpbb_poll_results_id ON phpbb_poll_results (poll_option_id); -CREATE INDEX phpbb_poll_results_topic_id ON phpbb_poll_results (topic_id); - -# Table: 'phpbb_vote_voters' +# phpbb_poll_voters CREATE TABLE phpbb_poll_voters ( - topic_id INTEGER DEFAULT 0 NOT NULL, - poll_option_id SMALLINT DEFAULT 0 NOT NULL, - vote_user_id INTEGER DEFAULT 0 NOT NULL, - vote_user_ip VARCHAR(40) DEFAULT '' NOT NULL -); - -CREATE INDEX phpbb_poll_voters_topic ON phpbb_poll_voters (topic_id); -CREATE INDEX phpbb_poll_voters_vote_user ON phpbb_poll_voters (vote_user_id); -CREATE INDEX phpbb_poll_voters_vote_ip ON phpbb_poll_voters (vote_user_ip); + topic_id INTEGER DEFAULT 0 NOT NULL, + poll_option_id INTEGER DEFAULT 0 NOT NULL, + vote_user_id INTEGER DEFAULT 0 NOT NULL, + vote_user_ip VARCHAR(40) NOT NULL +);; -# Table: 'phpbb_posts' +# phpbb_posts CREATE TABLE phpbb_posts ( - post_id INTEGER NOT NULL, - topic_id INTEGER DEFAULT 0 NOT NULL, - forum_id SMALLINT DEFAULT 0 NOT NULL, - poster_id INTEGER DEFAULT 0 NOT NULL, - icon_id SMALLINT DEFAULT 1 NOT NULL, - poster_ip VARCHAR(40) DEFAULT '' NOT NULL, - post_time INTEGER DEFAULT 0 NOT NULL, - post_approved SMALLINT DEFAULT 1 NOT NULL, - post_reported SMALLINT DEFAULT 0 NOT NULL, - enable_bbcode SMALLINT DEFAULT 1 NOT NULL, - enable_html SMALLINT DEFAULT 0 NOT NULL, - enable_smilies SMALLINT DEFAULT 1 NOT NULL, - enable_magic_url SMALLINT DEFAULT 1 NOT NULL, - enable_sig SMALLINT DEFAULT 1 NOT NULL, - post_username VARCHAR(30) DEFAULT '', - post_subject VARCHAR(60) DEFAULT '', - post_text BLOB SUB_TYPE 1 DEFAULT '' NOT NULL, - post_checksum VARCHAR(32) DEFAULT '' NOT NULL, - post_encoding VARCHAR(11) DEFAULT 'iso-8859-15' NOT NULL, - post_attachment SMALLINT DEFAULT 0 NOT NULL, - bbcode_bitfield INTEGER DEFAULT 0 NOT NULL, - bbcode_uid VARCHAR(10) DEFAULT '' NOT NULL, - post_edit_time INTEGER DEFAULT 0 NOT NULL, - post_edit_count SMALLINT DEFAULT 0 NOT NULL, - post_edit_locked SMALLINT DEFAULT 0 NOT NULL, - PRIMARY KEY (post_id) -); - -CREATE GENERATOR phpbb_posts_gen; -SET GENERATOR phpbb_posts_gen TO 0; -CREATE INDEX phpbb_posts_forum_id ON phpbb_posts (forum_id); -CREATE INDEX phpbb_posts_topic_id ON phpbb_posts (topic_id); -CREATE INDEX phpbb_posts_poster_ip ON phpbb_posts (poster_ip); -CREATE INDEX phpbb_posts_poster_id ON phpbb_posts (poster_id); -CREATE INDEX phpbb_posts_post_apv ON phpbb_posts (post_approved); - -CREATE TRIGGER phpbb_posts_trig - FOR phpbb_posts BEFORE INSERT - AS BEGIN - IF (NEW.post_id IS NULL) THEN - NEW.post_id = GEN_ID(phpbb_posts_gen, 1)| - END; - -# Table: 'phpbb_privmsgs' + post_id INTEGER NOT NULL, + topic_id INTEGER DEFAULT 0 NOT NULL, + forum_id INTEGER DEFAULT 0 NOT NULL, + poster_id INTEGER DEFAULT 0 NOT NULL, + icon_id INTEGER DEFAULT 1 NOT NULL, + poster_ip VARCHAR(40) NOT NULL, + post_time INTEGER DEFAULT 0 NOT NULL, + post_approved INTEGER DEFAULT 1 NOT NULL, + post_reported INTEGER DEFAULT 0 NOT NULL, + enable_bbcode INTEGER DEFAULT 1 NOT NULL, + enable_html INTEGER DEFAULT 0 NOT NULL, + enable_smilies INTEGER DEFAULT 1 NOT NULL, + enable_magic_url INTEGER DEFAULT 1 NOT NULL, + enable_sig INTEGER DEFAULT 1 NOT NULL, + post_username VARCHAR(30), + post_subject VARCHAR(60), + post_text BLOB SUB_TYPE TEXT, + post_checksum VARCHAR(32) NOT NULL, + post_encoding VARCHAR(11) DEFAULT 'iso-8859-15' NOT NULL, + post_attachment INTEGER DEFAULT 0 NOT NULL, + bbcode_bitfield INTEGER DEFAULT 0 NOT NULL, + bbcode_uid VARCHAR(5) NOT NULL, + post_edit_time INTEGER DEFAULT 0 NOT NULL, + post_edit_reason VARCHAR(100), + post_edit_user INTEGER DEFAULT 0 NOT NULL, + post_edit_count INTEGER DEFAULT 0 NOT NULL, + post_edit_locked INTEGER DEFAULT 0 NOT NULL +);; + +# phpbb_privmsgs CREATE TABLE phpbb_privmsgs ( - privmsgs_id INTEGER NOT NULL, - privmsgs_attachment SMALLINT DEFAULT 0 NOT NULL, - privmsgs_type SMALLINT DEFAULT 0 NOT NULL, - privmsgs_subject VARCHAR(60) DEFAULT 0 NOT NULL, - privmsgs_from_userid INTEGER DEFAULT 0 NOT NULL, - privmsgs_to_userid INTEGER DEFAULT 0 NOT NULL, - privmsgs_date INTEGER DEFAULT 0 NOT NULL, - privmsgs_ip VARCHAR(40) NOT NULL, - privmsgs_enable_bbcode SMALLINT DEFAULT 1 NOT NULL, - privmsgs_enable_html SMALLINT DEFAULT 0 NOT NULL, - privmsgs_enable_smilies SMALLINT DEFAULT 1 NOT NULL, - privmsgs_attach_sig SMALLINT DEFAULT 1 NOT NULL, - privmsgs_text BLOB SUB_TYPE 1, - privmsgs_bbcode_uid VARCHAR(10) DEFAULT 0 NOT NULL, - PRIMARY KEY (privmsgs_id) -); - -CREATE GENERATOR phpbb_privmsgs_gen; -SET GENERATOR phpbb_privmsgs_gen TO 0; -CREATE INDEX phpbb_privmsgs_from_userid ON phpbb_privmsgs (privmsgs_from_userid); -CREATE INDEX phpbb_privmsgs_to_userid ON phpbb_privmsgs (privmsgs_to_userid); - -CREATE TRIGGER phpbb_privmsgs_trig - FOR phpbb_privmsgs BEFORE INSERT - AS BEGIN - IF (NEW.privmsgs_id IS NULL) THEN - NEW.privmsgs_id = GEN_ID(phpbb_privmsgs_gen, 1)| - END; - -# Table: 'phpbb_ranks' + msg_id INTEGER NOT NULL, + root_level INTEGER DEFAULT 0 NOT NULL, + author_id INTEGER DEFAULT 0 NOT NULL, + icon_id INTEGER DEFAULT 1 NOT NULL, + author_ip VARCHAR(40) NOT NULL, + message_time INTEGER DEFAULT 0 NOT NULL, + message_reported INTEGER DEFAULT 0 NOT NULL, + enable_bbcode INTEGER DEFAULT 1 NOT NULL, + enable_html INTEGER DEFAULT 0 NOT NULL, + enable_smilies INTEGER DEFAULT 1 NOT NULL, + enable_magic_url INTEGER DEFAULT 1 NOT NULL, + enable_sig INTEGER DEFAULT 1 NOT NULL, + message_subject VARCHAR(60), + message_text BLOB SUB_TYPE TEXT, + message_edit_reason VARCHAR(100), + message_edit_user INTEGER DEFAULT 0 NOT NULL, + message_checksum VARCHAR(32) NOT NULL, + message_encoding VARCHAR(11) DEFAULT 'iso-8859-15' NOT NULL, + message_attachment INTEGER DEFAULT 0 NOT NULL, + bbcode_bitfield INTEGER DEFAULT 0 NOT NULL, + bbcode_uid VARCHAR(5) NOT NULL, + message_edit_time INTEGER DEFAULT 0 NOT NULL, + message_edit_count INTEGER DEFAULT 0 NOT NULL, + to_address BLOB SUB_TYPE TEXT, + bcc_address BLOB SUB_TYPE TEXT +);; + +# phpbb_privmsgs_folder +CREATE TABLE phpbb_privmsgs_folder ( + folder_id INTEGER NOT NULL, + user_id INTEGER DEFAULT 0 NOT NULL, + folder_name VARCHAR(40) NOT NULL, + pm_count INTEGER DEFAULT 0 NOT NULL +);; + +# phpbb_privmsgs_rules +CREATE TABLE phpbb_privmsgs_rules ( + rule_id INTEGER NOT NULL, + user_id INTEGER DEFAULT 0 NOT NULL, + rule_check INTEGER DEFAULT 0 NOT NULL, + rule_connection INTEGER DEFAULT 0 NOT NULL, + rule_string VARCHAR(255) NOT NULL, + rule_user_id INTEGER DEFAULT 0 NOT NULL, + rule_group_id INTEGER DEFAULT 0 NOT NULL, + rule_action INTEGER DEFAULT 0 NOT NULL, + rule_folder_id INTEGER DEFAULT 0 NOT NULL +);; + +# phpbb_privmsgs_to +CREATE TABLE phpbb_privmsgs_to ( + msg_id INTEGER DEFAULT 0 NOT NULL, + user_id INTEGER DEFAULT 0 NOT NULL, + author_id INTEGER DEFAULT 0 NOT NULL, + deleted INTEGER DEFAULT 0 NOT NULL, + new INTEGER DEFAULT 1 NOT NULL, + unread INTEGER DEFAULT 1 NOT NULL, + replied INTEGER DEFAULT 0 NOT NULL, + marked INTEGER DEFAULT 0 NOT NULL, + forwarded INTEGER DEFAULT 0 NOT NULL, + folder_id INTEGER DEFAULT 0 NOT NULL +);; + +# phpbb_profile_fields +CREATE TABLE phpbb_profile_fields ( + field_id INTEGER NOT NULL, + field_name VARCHAR(50) NOT NULL, + field_desc VARCHAR(255) NOT NULL, + field_type INTEGER DEFAULT 0 NOT NULL, + field_ident VARCHAR(20) NOT NULL, + field_length VARCHAR(20) NOT NULL, + field_minlen VARCHAR(255) NOT NULL, + field_maxlen VARCHAR(255) NOT NULL, + field_novalue VARCHAR(255) NOT NULL, + field_default_value VARCHAR(255) DEFAULT '0' NOT NULL, + field_validation VARCHAR(20) NOT NULL, + field_required INTEGER DEFAULT 0 NOT NULL, + field_show_on_reg INTEGER DEFAULT 0 NOT NULL, + field_hide INTEGER DEFAULT 0 NOT NULL, + field_active INTEGER DEFAULT 0 NOT NULL, + field_order INTEGER DEFAULT 0 NOT NULL +);; + +# phpbb_profile_fields_data +CREATE TABLE phpbb_profile_fields_data ( + user_id INTEGER DEFAULT 0 NOT NULL +);; + +# phpbb_profile_fields_lang +CREATE TABLE phpbb_profile_fields_lang ( + field_id INTEGER DEFAULT 0 NOT NULL, + lang_id INTEGER DEFAULT 0 NOT NULL, + option_id INTEGER DEFAULT 0 NOT NULL, + field_type INTEGER DEFAULT 0 NOT NULL, + valueCol VARCHAR(255) NOT NULL +);; + +# phpbb_profile_lang +CREATE TABLE phpbb_profile_lang ( + field_id INTEGER DEFAULT 0 NOT NULL, + lang_id INTEGER DEFAULT 0 NOT NULL, + lang_name VARCHAR(255) NOT NULL, + lang_explain BLOB SUB_TYPE TEXT NOT NULL, + lang_default_value VARCHAR(255) NOT NULL +);; + +# phpbb_ranks CREATE TABLE phpbb_ranks ( - rank_id SMALLINT NOT NULL, - rank_title VARCHAR(50) NOT NULL, - rank_min INTEGER DEFAULT 0 NOT NULL, - rank_special SMALLINT DEFAULT 0, - rank_image VARCHAR(100), - PRIMARY KEY (rank_id) -); - -CREATE GENERATOR phpbb_ranks_gen; -SET GENERATOR phpbb_ranks_gen TO 0; - -CREATE TRIGGER phpbb_ranks_trig - FOR phpbb_ranks BEFORE INSERT - AS BEGIN - IF (NEW.rank_id IS NULL) THEN - NEW.rank_id = GEN_ID(phpbb_ranks_gen, 1)| - END; - -# Table: 'phpbb_ratings' + rank_id INTEGER NOT NULL, + rank_title VARCHAR(50) NOT NULL, + rank_min INTEGER DEFAULT 0 NOT NULL, + rank_special INTEGER DEFAULT 0 , + rank_image VARCHAR(100) +);; + +# phpbb_ratings CREATE TABLE phpbb_ratings ( - post_id INTEGER DEFAULT 0 NOT NULL, - user_id SMALLINT DEFAULT 0 NOT NULL, - rating SMALLINT DEFAULT 0 NOT NULL -); + post_id INTEGER DEFAULT 0 NOT NULL, + user_id INTEGER DEFAULT 0 NOT NULL, + rating INTEGER DEFAULT 0 NOT NULL +);; -CREATE INDEX phpbb_ratings_post_id ON phpbb_ratings (post_id); -CREATE INDEX phpbb_ratings_user_id ON phpbb_ratings (user_id); - -# Table: 'phpbb_reports_reasons' +# phpbb_reports +CREATE TABLE phpbb_reports ( + report_id INTEGER NOT NULL, + reason_id INTEGER DEFAULT 0 NOT NULL, + post_id INTEGER DEFAULT 0 NOT NULL, + msg_id INTEGER DEFAULT 0 NOT NULL, + user_id INTEGER DEFAULT 0 NOT NULL, + user_notify INTEGER DEFAULT 0 NOT NULL, + report_time INTEGER DEFAULT 0 NOT NULL, + report_text BLOB SUB_TYPE TEXT NOT NULL +);; + +# phpbb_reports_reasons CREATE TABLE phpbb_reports_reasons ( reason_id INTEGER NOT NULL, - reason_priority SMALLINT DEFAULT 0 NOT NULL, - reason_name VARCHAR(255) DEFAULT '' NOT NULL, - reason_description BLOB SUB_TYPE 1 NOT NULL, - PRIMARY KEY (reason_id) -); - -CREATE GENERATOR phpbb_reports_reasons_gen; -SET GENERATOR phpbb_reports_reasons_gen TO 0; - -CREATE TRIGGER phpbb_reports_reasons_trig - FOR phpbb_reports_reasons BEFORE INSERT - AS BEGIN - IF (NEW.reason_id IS NULL) THEN - NEW.reason_id = GEN_ID(phpbb_reports_reasons_gen, 1)| - END; - -# Table: 'phpbb_reports' -CREATE TABLE phpbb_reports ( - report_id SMALLINT NOT NULL, - reason_id SMALLINT DEFAULT 0 NOT NULL, - post_id INTEGER DEFAULT 0 NOT NULL, - user_id INTEGER DEFAULT 0 NOT NULL, - user_notify SMALLINT DEFAULT 0 NOT NULL, - report_time INTEGER DEFAULT 0 NOT NULL, - report_text BLOB SUB_TYPE 1 NOT NULL, - PRIMARY KEY (report_id) -); - -CREATE GENERATOR phpbb_reports_gen; -SET GENERATOR phpbb_reports_gen TO 0; - -CREATE TRIGGER phpbb_reports_trig - FOR phpbb_reports BEFORE INSERT - AS BEGIN - IF (NEW.report_id IS NULL) THEN - NEW.report_id = GEN_ID(phpbb_reports_gen, 1)| - END; - -# Table: phpbb_search_results -CREATE TABLE phpbb_search_results ( - search_id INTEGER DEFAULT 0 NOT NULL, - session_id VARCHAR(32) DEFAULT '' NOT NULL, - search_array BLOB SUB_TYPE 1 NOT NULL, - PRIMARY KEY (search_id) -); + reason_priority INTEGER DEFAULT 0 NOT NULL, + reason_name VARCHAR(255) NOT NULL, + reason_description BLOB SUB_TYPE TEXT NOT NULL +);; -CREATE INDEX phpbb_search_results_session_id ON phpbb_search_results (session_id); +# phpbb_search_results +CREATE TABLE phpbb_search_results ( + search_id INTEGER DEFAULT 0 NOT NULL, + session_id VARCHAR(32) NOT NULL, + search_time INTEGER DEFAULT 0 NOT NULL, + search_array BLOB SUB_TYPE TEXT NOT NULL +);; -# Table: phpbb_search_wordlist +# phpbb_search_wordlist CREATE TABLE phpbb_search_wordlist ( + word_text VARCHAR(50) NOT NULL, word_id INTEGER NOT NULL, - word_text VARCHAR(50) DEFAULT '' NOT NULL, - word_common SMALLINT DEFAULT 0 NOT NULL, - PRIMARY KEY (word_id) -); - -CREATE INDEX phpbb_search_wordlist_text ON phpbb_search_wordlist (word_text); -CREATE INDEX phpbb_search_wordlist_common ON phpbb_search_wordlist (word_common); + word_common INTEGER DEFAULT 0 NOT NULL +);; -# Table: phpbb_search_wordmatch +# phpbb_search_wordmatch CREATE TABLE phpbb_search_wordmatch ( - post_id INTEGER DEFAULT 0 NOT NULL, - word_id INTEGER DEFAULT 0 NOT NULL, - title_match SMALLINT DEFAULT 0 NOT NULL -); + post_id INTEGER DEFAULT 0 NOT NULL, + word_id INTEGER DEFAULT 0 NOT NULL, + title_match INTEGER DEFAULT 0 NOT NULL +);; -CREATE INDEX phpbb_search_wordmatch_post ON phpbb_search_wordmatch (post_id); -CREATE INDEX phpbb_search_wordmatch_word ON phpbb_search_wordmatch (word_id); - -# Table: 'phpbb_sessions' +# phpbb_sessions CREATE TABLE phpbb_sessions ( - session_id VARCHAR(32) DEFAULT '' NOT NULL, - session_user_id INTEGER DEFAULT 0 NOT NULL, - session_last_visit INTEGER DEFAULT 0 NOT NULL, - session_start INTEGER DEFAULT 0 NOT NULL, - session_time INTEGER DEFAULT 0 NOT NULL, - session_ip VARCHAR(40) DEFAULT 0 NOT NULL, - session_browser VARCHAR(100) DEFAULT '' NOT NULL, - session_page VARCHAR(100) DEFAULT 0 NOT NULL, - session_allow_viewonline SMALLINT DEFAULT 1 NOT NULL, - PRIMARY KEY (session_id) -); - -CREATE INDEX phpbb_sessions_session_time ON phpbb_sessions (session_time); - -# Table: 'phpbb_smilies' + session_id VARCHAR(32) NOT NULL, + session_user_id INTEGER DEFAULT 0 NOT NULL, + session_last_visit INTEGER DEFAULT 0 NOT NULL, + session_start INTEGER DEFAULT 0 NOT NULL, + session_time INTEGER DEFAULT 0 NOT NULL, + session_ip VARCHAR(40) DEFAULT '0' NOT NULL, + session_browser VARCHAR(100), + session_page VARCHAR(100) NOT NULL, + session_viewonline INTEGER DEFAULT 1 NOT NULL, + session_admin INTEGER DEFAULT 0 NOT NULL +);; + +# phpbb_sitelist +CREATE TABLE phpbb_sitelist ( + site_id INTEGER NOT NULL, + site_ip VARCHAR(40) NOT NULL, + site_hostname VARCHAR(255) NOT NULL, + ip_exclude INTEGER DEFAULT 0 NOT NULL +);; + +# phpbb_smilies CREATE TABLE phpbb_smilies ( - smile_id SMALLINT NOT NULL, - code CHAR(10) DEFAULT '' NOT NULL, - emoticon CHAR(50) DEFAULT '' NOT NULL, - smile_url CHAR(50) DEFAULT '' NOT NULL, - smile_width SMALLINT DEFAULT 0 NOT NULL, - smile_height SMALLINT DEFAULT 0 NOT NULL, - smile_order SMALLINT DEFAULT 1 NOT NULL, - display_on_posting SMALLINT DEFAULT 1 NOT NULL, - PRIMARY KEY (smile_id) -); - -CREATE GENERATOR phpbb_smilies_gen; -SET GENERATOR phpbb_smilies_gen TO 0; - -CREATE TRIGGER phpbb_smilies_trig - FOR phpbb_smilies BEFORE INSERT - AS BEGIN - IF (NEW.smile_id IS NULL) THEN - NEW.smile_id = GEN_ID(phpbb_smilies_gen, 1)| - END; - -# Table: 'phpbb_styles' + smile_id INTEGER NOT NULL, + code VARCHAR(10), + emoticon VARCHAR(50), + smile_url VARCHAR(50), + smile_width INTEGER DEFAULT 0 NOT NULL, + smile_height INTEGER DEFAULT 0 NOT NULL, + smile_order INTEGER DEFAULT 0 NOT NULL, + display_on_posting INTEGER DEFAULT 1 NOT NULL +);; + +# phpbb_styles CREATE TABLE phpbb_styles ( - style_id SMALLINT NOT NULL, - template_id CHAR(50) DEFAULT '' NOT NULL, - theme_id SMALLINT DEFAULT 0 NOT NULL, - imageset_id SMALLINT DEFAULT 0 NOT NULL, - style_name CHAR(30) DEFAULT '' NOT NULL, - PRIMARY KEY (style_id) -); - -CREATE GENERATOR phpbb_styles_gen; -SET GENERATOR phpbb_styles_gen TO 0; -CREATE INDEX phpbb_styles_template_id ON phpbb_styles (template_id); -CREATE INDEX phpbb_styles_theme_id ON phpbb_styles (theme_id); -CREATE INDEX phpbb_styles_imageset_id ON phpbb_styles (imageset_id); - -CREATE TRIGGER phpbb_styles_trig - FOR phpbb_styles BEFORE INSERT - AS BEGIN - IF (NEW.style_id IS NULL) THEN - NEW.style_id = GEN_ID(phpbb_styles_gen, 1)| - END; - -# Table: 'phpbb_styles_template' + style_id INTEGER NOT NULL, + style_name VARCHAR(30) NOT NULL, + style_copyright VARCHAR(50) NOT NULL, + style_active INTEGER DEFAULT 1 NOT NULL, + template_id INTEGER DEFAULT 0 NOT NULL, + theme_id INTEGER DEFAULT 0 NOT NULL, + imageset_id INTEGER DEFAULT 0 NOT NULL +);; + +# phpbb_styles_imageset +CREATE TABLE phpbb_styles_imageset ( + imageset_id INTEGER NOT NULL, + imageset_name VARCHAR(30) NOT NULL, + imageset_copyright VARCHAR(50) NOT NULL, + imageset_path VARCHAR(30) NOT NULL, + site_logo VARCHAR(200) NOT NULL, + btn_post VARCHAR(200) NOT NULL, + btn_post_pm VARCHAR(200) NOT NULL, + btn_reply VARCHAR(200) NOT NULL, + btn_reply_pm VARCHAR(200) NOT NULL, + btn_locked VARCHAR(200) NOT NULL, + btn_profile VARCHAR(200) NOT NULL, + btn_pm VARCHAR(200) NOT NULL, + btn_delete VARCHAR(200) NOT NULL, + btn_info VARCHAR(200) NOT NULL, + btn_quote VARCHAR(200) NOT NULL, + btn_search VARCHAR(200) NOT NULL, + btn_edit VARCHAR(200) NOT NULL, + btn_report VARCHAR(200) NOT NULL, + btn_email VARCHAR(200) NOT NULL, + btn_www VARCHAR(200) NOT NULL, + btn_icq VARCHAR(200) NOT NULL, + btn_aim VARCHAR(200) NOT NULL, + btn_yim VARCHAR(200) NOT NULL, + btn_msnm VARCHAR(200) NOT NULL, + btn_jabber VARCHAR(200) NOT NULL, + btn_online VARCHAR(200) NOT NULL, + btn_offline VARCHAR(200) NOT NULL, + btn_friend VARCHAR(200) NOT NULL, + btn_foe VARCHAR(200) NOT NULL, + icon_unapproved VARCHAR(200) NOT NULL, + icon_reported VARCHAR(200) NOT NULL, + icon_attach VARCHAR(200) NOT NULL, + icon_post VARCHAR(200) NOT NULL, + icon_post_new VARCHAR(200) NOT NULL, + icon_post_latest VARCHAR(200) NOT NULL, + icon_post_newest VARCHAR(200) NOT NULL, + forum VARCHAR(200) NOT NULL, + forum_new VARCHAR(200) NOT NULL, + forum_locked VARCHAR(200) NOT NULL, + forum_link VARCHAR(200) NOT NULL, + sub_forum VARCHAR(200) NOT NULL, + sub_forum_new VARCHAR(200) NOT NULL, + folder VARCHAR(200) NOT NULL, + folder_moved VARCHAR(200) NOT NULL, + folder_posted VARCHAR(200) NOT NULL, + folder_new VARCHAR(200) NOT NULL, + folder_new_posted VARCHAR(200) NOT NULL, + folder_hot VARCHAR(200) NOT NULL, + folder_hot_posted VARCHAR(200) NOT NULL, + folder_hot_new VARCHAR(200) NOT NULL, + folder_hot_new_posted VARCHAR(200) NOT NULL, + folder_locked VARCHAR(200) NOT NULL, + folder_locked_posted VARCHAR(200) NOT NULL, + folder_locked_new VARCHAR(200) NOT NULL, + folder_locked_new_posted VARCHAR(200) NOT NULL, + folder_sticky VARCHAR(200) NOT NULL, + folder_sticky_posted VARCHAR(200) NOT NULL, + folder_sticky_new VARCHAR(200) NOT NULL, + folder_sticky_new_posted VARCHAR(200) NOT NULL, + folder_announce VARCHAR(200) NOT NULL, + folder_announce_posted VARCHAR(200) NOT NULL, + folder_announce_new VARCHAR(200) NOT NULL, + folder_announce_new_posted VARCHAR(200) NOT NULL, + folder_global VARCHAR(200) NOT NULL, + folder_global_posted VARCHAR(200) NOT NULL, + folder_global_new VARCHAR(200) NOT NULL, + folder_global_new_posted VARCHAR(200) NOT NULL, + poll_left VARCHAR(200) NOT NULL, + poll_center VARCHAR(200) NOT NULL, + poll_right VARCHAR(200) NOT NULL, + attach_progress_bar VARCHAR(200) NOT NULL, + user_icon1 VARCHAR(200) NOT NULL, + user_icon2 VARCHAR(200) NOT NULL, + user_icon3 VARCHAR(200) NOT NULL, + user_icon4 VARCHAR(200) NOT NULL, + user_icon5 VARCHAR(200) NOT NULL, + user_icon6 VARCHAR(200) NOT NULL, + user_icon7 VARCHAR(200) NOT NULL, + user_icon8 VARCHAR(200) NOT NULL, + user_icon9 VARCHAR(200) NOT NULL, + user_icon10 VARCHAR(200) NOT NULL +);; + +# phpbb_styles_template CREATE TABLE phpbb_styles_template ( - template_id SMALLINT NOT NULL, - template_name CHAR(30) DEFAULT '' NOT NULL, - template_path CHAR(50) DEFAULT '' NOT NULL, - poll_length SMALLINT DEFAULT 0 NOT NULL, - pm_box_length SMALLINT DEFAULT 0 NOT NULL, - bbcode_bitfield INT DEFAULT 0 NOT NULL, - PRIMARY KEY (template_id) -); - -CREATE GENERATOR phpbb_styles_template_gen; -SET GENERATOR phpbb_styles_template_gen TO 0; - -CREATE TRIGGER phpbb_styles_template_trig - FOR phpbb_styles_template BEFORE INSERT - AS BEGIN - IF (NEW.template_id IS NULL) THEN - NEW.template_id = GEN_ID(phpbb_styles_template_gen, 1)| - END; - -# Table: 'phpbb_styles_theme' + template_id INTEGER NOT NULL, + template_name VARCHAR(30) NOT NULL, + template_copyright VARCHAR(50) NOT NULL, + template_path VARCHAR(30) NOT NULL, + bbcode_bitfield INTEGER DEFAULT 0 NOT NULL, + template_storedb INTEGER DEFAULT 0 NOT NULL +);; + +# phpbb_styles_template_data +CREATE TABLE phpbb_styles_template_data ( + template_id INTEGER DEFAULT 0 NOT NULL, + template_filename VARCHAR(50) NOT NULL, + template_included BLOB SUB_TYPE TEXT NOT NULL, + template_mtime INTEGER DEFAULT 0 NOT NULL, + template_data BLOB SUB_TYPE TEXT +);; + +# phpbb_styles_theme CREATE TABLE phpbb_styles_theme ( - theme_id SMALLINT NOT NULL, - theme_name CHAR(60) DEFAULT '' NOT NULL, - css_external CHAR(100) DEFAULT '' NOT NULL, - css_data BLOB SUB_TYPE 1, - PRIMARY KEY (theme_id) -); - -CREATE GENERATOR phpbb_styles_theme_gen; -SET GENERATOR phpbb_styles_theme_gen TO 0; - -CREATE TRIGGER phpbb_styles_theme_trig - FOR phpbb_styles_theme BEFORE INSERT - AS BEGIN - IF (NEW.theme_id IS NULL) THEN - NEW.theme_id = GEN_ID(phpbb_styles_theme_gen, 1)| - END; - -# Table: 'phpbb_styles_imageset' -CREATE TABLE phpbb_styles_imageset ( - imageset_id SMALLINT NOT NULL, - imageset_name CHAR(100), - imageset_path CHAR(30), - btn_post CHAR(200) DEFAULT '' NOT NULL, - btn_post_pm CHAR(200) DEFAULT '' NOT NULL, - btn_reply CHAR(200) DEFAULT '' NOT NULL, - btn_reply_pm CHAR(200) DEFAULT '' NOT NULL, - btn_locked CHAR(200) DEFAULT '' NOT NULL, - btn_profile CHAR(200) DEFAULT '' NOT NULL, - btn_pm CHAR(200) DEFAULT '' NOT NULL, - btn_delete CHAR(200) DEFAULT '' NOT NULL, - btn_ip CHAR(200) DEFAULT '' NOT NULL, - btn_quote CHAR(200) DEFAULT '' NOT NULL, - btn_search CHAR(200) DEFAULT '' NOT NULL, - btn_edit CHAR(200) DEFAULT '' NOT NULL, - btn_report CHAR(200) DEFAULT '' NOT NULL, - btn_email CHAR(200) DEFAULT '' NOT NULL, - btn_www CHAR(200) DEFAULT '' NOT NULL, - btn_icq CHAR(200) DEFAULT '' NOT NULL, - btn_aim CHAR(200) DEFAULT '' NOT NULL, - btn_yim CHAR(200) DEFAULT '' NOT NULL, - btn_msnm CHAR(200) DEFAULT '' NOT NULL, - btn_jabber CHAR(200) DEFAULT '' NOT NULL, - btn_online CHAR(200) DEFAULT '' NOT NULL, - btn_offline CHAR(200) DEFAULT '' NOT NULL, - btn_topic_watch CHAR(200) DEFAULT '' NOT NULL, - btn_topic_unwatch CHAR(200) DEFAULT '' NOT NULL, - icon_unapproved CHAR(200) DEFAULT '' NOT NULL, - icon_reported CHAR(200) DEFAULT '' NOT NULL, - icon_attach CHAR(200) DEFAULT '' NOT NULL, - icon_post CHAR(200) DEFAULT '' NOT NULL, - icon_post_new CHAR(200) DEFAULT '' NOT NULL, - icon_post_latest CHAR(200) DEFAULT '' NOT NULL, - icon_post_newest CHAR(200) DEFAULT '' NOT NULL, - forum CHAR(200) DEFAULT '' NOT NULL, - forum_new CHAR(200) DEFAULT '' NOT NULL, - forum_locked CHAR(200) DEFAULT '' NOT NULL, - forum_link CHAR(200) DEFAULT '' NOT NULL, - sub_forum CHAR(200) DEFAULT '' NOT NULL, - sub_forum_new CHAR(200) DEFAULT '' NOT NULL, - folder CHAR(200) DEFAULT '' NOT NULL, - folder_posted CHAR(200) DEFAULT '' NOT NULL, - folder_new CHAR(200) DEFAULT '' NOT NULL, - folder_new_posted CHAR(200) DEFAULT '' NOT NULL, - folder_hot CHAR(200) DEFAULT '' NOT NULL, - folder_hot_posted CHAR(200) DEFAULT '' NOT NULL, - folder_hot_new CHAR(200) DEFAULT '' NOT NULL, - folder_hot_new_posted CHAR(200) DEFAULT '' NOT NULL, - folder_locked CHAR(200) DEFAULT '' NOT NULL, - folder_locked_posted CHAR(200) DEFAULT '' NOT NULL, - folder_locked_new CHAR(200) DEFAULT '' NOT NULL, - folder_locked_new_posted CHAR(200) DEFAULT '' NOT NULL, - folder_sticky CHAR(200) DEFAULT '' NOT NULL, - folder_sticky_posted CHAR(200) DEFAULT '' NOT NULL, - folder_sticky_new CHAR(200) DEFAULT '' NOT NULL, - folder_sticky_new_posted CHAR(200) DEFAULT '' NOT NULL, - folder_announce CHAR(200) DEFAULT '' NOT NULL, - folder_announce_posted CHAR(200) DEFAULT '' NOT NULL, - folder_announce_new CHAR(200) DEFAULT '' NOT NULL, - folder_announce_new_posted CHAR(200) DEFAULT '' NOT NULL, - poll_left CHAR(200) DEFAULT '' NOT NULL, - poll_center CHAR(200) DEFAULT '' NOT NULL, - poll_right CHAR(200) DEFAULT '' NOT NULL, - PRIMARY KEY (imageset_id) -); - -CREATE GENERATOR phpbb_styles_imageset_gen; -SET GENERATOR phpbb_styles_imageset_gen TO 0; - -CREATE TRIGGER phpbb_styles_imageset_trig - FOR phpbb_styles_imageset BEFORE INSERT - AS BEGIN - IF (NEW.imageset_id IS NULL) THEN - NEW.imageset_id = GEN_ID(phpbb_styles_imageset_gen, 1)| - END; - -# Table: 'phpbb_topics' + theme_id INTEGER NOT NULL, + theme_name VARCHAR(30) NOT NULL, + theme_copyright VARCHAR(50) NOT NULL, + theme_path VARCHAR(30) NOT NULL, + theme_storedb INTEGER DEFAULT 0 NOT NULL, + theme_mtime INTEGER DEFAULT 0 NOT NULL, + theme_data BLOB SUB_TYPE TEXT NOT NULL +);; + +# phpbb_topics CREATE TABLE phpbb_topics ( - topic_id INTEGER NOT NULL, - forum_id INTEGER DEFAULT 0 NOT NULL, - icon_id SMALLINT DEFAULT 1 NOT NULL, - topic_attachment SMALLINT DEFAULT 0 NOT NULL, - topic_approved SMALLINT DEFAULT 1 NOT NULL, - topic_reported SMALLINT DEFAULT 0 NOT NULL, - topic_title VARCHAR(60) NOT NULL, - topic_poster INTEGER DEFAULT 0 NOT NULL, - topic_time INTEGER DEFAULT 0 NOT NULL, - topic_views INTEGER DEFAULT 0 NOT NULL, - topic_replies INTEGER DEFAULT 0 NOT NULL, - topic_replies_real INTEGER DEFAULT 0 NOT NULL, - topic_status SMALLINT DEFAULT 0 NOT NULL, - topic_type SMALLINT DEFAULT 0 NOT NULL, - topic_first_post_id INTEGER DEFAULT 0 NOT NULL, - topic_first_poster_name VARCHAR(30), - topic_last_post_id INTEGER DEFAULT 0 NOT NULL, - topic_last_poster_id INTEGER DEFAULT 0 NOT NULL, - topic_last_poster_name VARCHAR(30), - topic_last_post_time INTEGER DEFAULT 0 NOT NULL, - topic_last_view_time INTEGER DEFAULT 0 NOT NULL, - topic_moved_id INTEGER DEFAULT 0 NOT NULL, - poll_title VARCHAR(255) DEFAULT '' NOT NULL, - poll_start INTEGER DEFAULT 0 NOT NULL, - poll_length INTEGER DEFAULT 0 NOT NULL, - poll_max_options SMALLINT DEFAULT 1 NOT NULL, - poll_last_vote INTEGER, - PRIMARY KEY (topic_id) -); - -CREATE GENERATOR phpbb_topics_gen; -SET GENERATOR phpbb_topics_gen TO 0; -CREATE INDEX phpbb_topics_forum_id ON phpbb_topics (forum_id); -CREATE INDEX phpbb_topics_moved_id ON phpbb_topics (topic_moved_id); -CREATE INDEX phpbb_topics_last_post_time ON phpbb_topics (topic_last_post_time); -CREATE INDEX phpbb_topics_last_poll_vote ON phpbb_topics (poll_last_vote); -CREATE INDEX phpbb_topics_type ON phpbb_topics (topic_type); - -CREATE TRIGGER phpbb_topics_trig - FOR phpbb_topics BEFORE INSERT - AS BEGIN - IF (NEW.topic_id IS NULL) THEN - NEW.topic_id = GEN_ID(phpbb_topics_gen, 1)| - END; - -# Table: 'phpbb_topic_marking' + topic_id INTEGER NOT NULL, + forum_id INTEGER DEFAULT 0 NOT NULL, + icon_id INTEGER DEFAULT 1 NOT NULL, + topic_attachment INTEGER DEFAULT 0 NOT NULL, + topic_approved INTEGER DEFAULT 1 NOT NULL, + topic_reported INTEGER DEFAULT 0 NOT NULL, + topic_title VARCHAR(60) NOT NULL, + topic_poster INTEGER DEFAULT 0 NOT NULL, + topic_time INTEGER DEFAULT 0 NOT NULL, + topic_time_limit INTEGER DEFAULT 0 NOT NULL, + topic_views INTEGER DEFAULT 0 NOT NULL, + topic_replies INTEGER DEFAULT 0 NOT NULL, + topic_replies_real INTEGER DEFAULT 0 NOT NULL, + topic_status INTEGER DEFAULT 0 NOT NULL, + topic_type INTEGER DEFAULT 0 NOT NULL, + topic_first_post_id INTEGER DEFAULT 0 NOT NULL, + topic_first_poster_name VARCHAR(30), + topic_last_post_id INTEGER DEFAULT 0 NOT NULL, + topic_last_poster_id INTEGER DEFAULT 0 NOT NULL, + topic_last_poster_name VARCHAR(30), + topic_last_post_time INTEGER DEFAULT 0 NOT NULL, + topic_last_view_time INTEGER DEFAULT 0 NOT NULL, + topic_moved_id INTEGER DEFAULT 0 NOT NULL, + topic_bumped INTEGER DEFAULT 0 NOT NULL, + topic_bumper INTEGER DEFAULT 0 NOT NULL, + poll_title VARCHAR(255) NOT NULL, + poll_start INTEGER DEFAULT 0 NOT NULL, + poll_length INTEGER DEFAULT 0 NOT NULL, + poll_max_options INTEGER DEFAULT 1 NOT NULL, + poll_last_vote INTEGER DEFAULT 0 , + poll_vote_change INTEGER DEFAULT 0 NOT NULL +);; + +# phpbb_topics_marking CREATE TABLE phpbb_topics_marking ( - user_id INTEGER DEFAULT 0 NOT NULL, - topic_id INTEGER DEFAULT 0 NOT NULL, - mark_type SMALLINT DEFAULT 0 NOT NULL, - mark_time INTEGER DEFAULT 0 NOT NULL, - PRIMARY KEY (user_id, topic_id) -); - -# Table: 'phpbb_topics_watch' + user_id INTEGER DEFAULT 0 NOT NULL, + topic_id INTEGER DEFAULT 0 NOT NULL, + mark_type INTEGER DEFAULT 0 NOT NULL, + mark_time INTEGER DEFAULT 0 NOT NULL +);; + +# phpbb_topics_watch CREATE TABLE phpbb_topics_watch ( - topic_id INTEGER DEFAULT 0 NOT NULL, - user_id INTEGER DEFAULT 0 NOT NULL, - notify_status SMALLINT DEFAULT 0 NOT NULL -); - -CREATE INDEX phpbb_topics_watch_topic ON phpbb_topics_watch (topic_id); -CREATE INDEX phpbb_topics_watch_user ON phpbb_topics_watch (user_id); -CREATE INDEX phpbb_topics_watch_status ON phpbb_topics_watch (notify_status); - -# Table: 'phpbb_ucp_modules' -CREATE TABLE phpbb_ucp_modules ( - module_id INTEGER DEFAULT 0 NOT NULL, - module_title VARCHAR(50) DEFAULT '' NOT NULL, - module_filename VARCHAR(50) DEFAULT '' NOT NULL, - module_order INTEGER DEFAULT 0 NOT NULL, - PRIMARY KEY (module_id) -); - -CREATE GENERATOR phpbb_ucp_modules_gen; -SET GENERATOR phpbb_ucp_modules_gen TO 0; -CREATE INDEX phpbb_ucp_modules_order ON phpbb_ucp_modules (module_order); - -CREATE TRIGGER phpbb_ucp_modules_trig - FOR phpbb_ucp_modules BEFORE INSERT - AS BEGIN - IF (NEW.module_id IS NULL) THEN - NEW.module_id = GEN_ID(phpbb_ucp_modules_gen, 1)| - END; - -# Table: 'phpbb_user_group' -CREATE TABLE phpbb_user_group ( - group_id INTEGER DEFAULT 0 NOT NULL, - user_id INTEGER DEFAULT 0 NOT NULL, - user_pending SMALLINT -); + topic_id INTEGER DEFAULT 0 NOT NULL, + user_id INTEGER DEFAULT 0 NOT NULL, + notify_status INTEGER DEFAULT 0 NOT NULL +);; -CREATE INDEX phpbb_user_group_user_id ON phpbb_user_group (user_id); -CREATE INDEX phpbb_user_group_group_id ON phpbb_user_group (group_id); +# phpbb_user_group +CREATE TABLE phpbb_user_group ( + group_id INTEGER DEFAULT 0 NOT NULL, + user_id INTEGER DEFAULT 0 NOT NULL, + group_leader INTEGER DEFAULT 0 NOT NULL, + user_pending INTEGER +);; -# Table: 'phpbb_users' +# phpbb_users CREATE TABLE phpbb_users ( - user_id INTEGER NOT NULL, - user_active SMALLINT DEFAULT 1, - user_founder SMALLINT DEFAULT 0 NOT NULL, - group_id INTEGER DEFAULT 0 NOT NULL, - user_permissions BLOB SUB_TYPE 1 DEFAULT '', - user_ip VARCHAR(40), - user_regdate INTEGER DEFAULT 0 NOT NULL, - username VARCHAR(30) NOT NULL, - user_password VARCHAR(32) NOT NULL, - user_email VARCHAR(60), - user_birthday VARCHAR(10) DEFAULT '' NOT NULL, - user_lastvisit INTEGER DEFAULT 0 NOT NULL, - user_lastpage VARCHAR(100) DEFAULT '' NOT NULL, - user_karma SMALLINT DEFAULT 3 NOT NULL, - user_min_karma SMALLINT DEFAULT -5 NOT NULL, - user_startpage VARCHAR(100) DEFAULT '', - user_colour VARCHAR(6) DEFAULT '' NOT NULL, - user_posts INTEGER DEFAULT 0 NOT NULL, - user_lang VARCHAR(30) DEFAULT '' NOT NULL, - user_timezone decimal(5,2) DEFAULT 0 NOT NULL, - user_dst SMALLINT DEFAULT 0 NOT NULL, - user_dateformat VARCHAR(15) DEFAULT 'd M Y H:i' NOT NULL, - user_style SMALLINT DEFAULT 1 NOT NULL, - user_rank INTEGER DEFAULT 0 NOT NULL, - user_new_privmsg SMALLINT DEFAULT 0 NOT NULL, - user_unread_privmsg SMALLINT DEFAULT 0 NOT NULL, - user_last_privmsg INTEGER DEFAULT 0 NOT NULL, - user_emailtime INTEGER, - user_sortby_type VARCHAR(1) DEFAULT '' NOT NULL, - user_sortby_dir VARCHAR(1) DEFAULT '' NOT NULL, - user_show_days SMALLINT DEFAULT 0 NOT NULL, - user_viewimg SMALLINT DEFAULT 1 NOT NULL, - user_notify SMALLINT DEFAULT 0 NOT NULL, - user_notify_pm SMALLINT DEFAULT 1 NOT NULL, - user_popup_pm SMALLINT DEFAULT 0 NOT NULL, - user_viewflash SMALLINT DEFAULT 1 NOT NULL, - user_viewsmilies SMALLINT DEFAULT 1 NOT NULL, - user_viewsigs SMALLINT DEFAULT 1 NOT NULL, - user_viewavatars SMALLINT DEFAULT 1 NOT NULL, - user_viewcensors SMALLINT DEFAULT 1 NOT NULL, - user_attachsig SMALLINT DEFAULT 1 NOT NULL, - user_allowhtml SMALLINT DEFAULT 1 NOT NULL, - user_allowbbcode SMALLINT DEFAULT 1 NOT NULL, - user_allowsmile SMALLINT DEFAULT 1 NOT NULL, - user_allowavatar SMALLINT DEFAULT 1 NOT NULL, - user_allow_pm SMALLINT DEFAULT 1 NOT NULL, - user_allow_email SMALLINT DEFAULT 1 NOT NULL, - user_allow_viewonline SMALLINT DEFAULT 1 NOT NULL, - user_allow_viewemail SMALLINT DEFAULT 1 NOT NULL, - user_allow_massemail SMALLINT DEFAULT 1 NOT NULL, - user_avatar VARCHAR(100) DEFAULT '' NOT NULL, - user_avatar_type SMALLINT DEFAULT 0 NOT NULL, - user_avatar_width SMALLINT DEFAULT 0 NOT NULL, - user_avatar_height SMALLINT DEFAULT 0 NOT NULL, - user_sig BLOB SUB_TYPE 1, - user_sig_bbcode_uid VARCHAR(5) DEFAULT '' NOT NULL, - user_sig_bbcode_bitfield INTEGER DEFAULT 0 NOT NULL, - user_from VARCHAR(100) DEFAULT '' NOT NULL, - user_icq VARCHAR(15) DEFAULT '' NOT NULL, - user_aim VARCHAR(255) DEFAULT '' NOT NULL, - user_yim VARCHAR(255) DEFAULT '' NOT NULL, - user_msnm VARCHAR(255) DEFAULT '' NOT NULL, - user_jabber VARCHAR(255) DEFAULT '' NOT NULL, - user_website VARCHAR(100) DEFAULT '' NOT NULL, - user_actkey VARCHAR(32) DEFAULT '' NOT NULL, - user_newpasswd VARCHAR(32) DEFAULT '' NOT NULL, - user_occ VARCHAR(255) DEFAULT '' NOT NULL, - user_interests VARCHAR(255) DEFAULT '' NOT NULL, - PRIMARY KEY (user_id) -); - -CREATE GENERATOR phpbb_users_gen; -SET GENERATOR phpbb_users_gen TO 0; -CREATE INDEX phpbb_users_user_birthday ON phpbb_users (user_birthday); - -CREATE TRIGGER phpbb_users_trig - FOR phpbb_users BEFORE INSERT - AS BEGIN - IF (NEW.user_id IS NULL) THEN - NEW.user_id = GEN_ID(phpbb_users_gen, 1)| - END; - -# Table: 'phpbb_words' + user_id INTEGER NOT NULL, + user_type INTEGER DEFAULT 0 NOT NULL, + group_id INTEGER DEFAULT 3 NOT NULL, + user_permissions BLOB SUB_TYPE TEXT NOT NULL, + user_ip VARCHAR(40) NOT NULL, + user_regdate INTEGER DEFAULT 0 NOT NULL, + username VARCHAR(30) NOT NULL, + user_password VARCHAR(32) NOT NULL, + user_passchg INTEGER DEFAULT 0 NOT NULL, + user_email VARCHAR(60) NOT NULL, + user_email_hash DOUBLE PRECISION DEFAULT 0 NOT NULL, + user_birthday VARCHAR(10) NOT NULL, + user_lastvisit INTEGER DEFAULT 0 NOT NULL, + user_lastpost_time INTEGER DEFAULT 0 NOT NULL, + user_lastpage VARCHAR(100) NOT NULL, + user_last_confirm_key VARCHAR(10) NOT NULL, + user_warnings INTEGER DEFAULT 0 NOT NULL, + user_posts INTEGER DEFAULT 0 NOT NULL, + user_lang VARCHAR(30) NOT NULL, + user_timezone DOUBLE PRECISION DEFAULT 0 NOT NULL, + user_dst INTEGER DEFAULT 0 NOT NULL, + user_dateformat VARCHAR(15) DEFAULT 'd M Y H:i' NOT NULL, + user_style INTEGER DEFAULT 0 NOT NULL, + user_rank INTEGER DEFAULT 0 , + user_colour VARCHAR(6) NOT NULL, + user_new_privmsg INTEGER DEFAULT 0 NOT NULL, + user_unread_privmsg INTEGER DEFAULT 0 NOT NULL, + user_last_privmsg INTEGER DEFAULT 0 NOT NULL, + user_message_rules INTEGER DEFAULT 0 NOT NULL, + user_full_folder INTEGER DEFAULT -3 NOT NULL, + user_emailtime INTEGER DEFAULT 0 NOT NULL, + user_sortby_type VARCHAR(1) NOT NULL, + user_sortby_dir VARCHAR(1) NOT NULL, + user_show_days INTEGER DEFAULT 0 NOT NULL, + user_notify INTEGER DEFAULT 0 NOT NULL, + user_notify_pm INTEGER DEFAULT 1 NOT NULL, + user_notify_type INTEGER DEFAULT 0 NOT NULL, + user_allow_pm INTEGER DEFAULT 1 NOT NULL, + user_allow_email INTEGER DEFAULT 1 NOT NULL, + user_allow_viewonline INTEGER DEFAULT 1 NOT NULL, + user_allow_viewemail INTEGER DEFAULT 1 NOT NULL, + user_allow_massemail INTEGER DEFAULT 1 NOT NULL, + user_options INTEGER DEFAULT 893 NOT NULL, + user_avatar VARCHAR(100) NOT NULL, + user_avatar_type INTEGER DEFAULT 0 NOT NULL, + user_avatar_width INTEGER DEFAULT 0 NOT NULL, + user_avatar_height INTEGER DEFAULT 0 NOT NULL, + user_sig BLOB SUB_TYPE TEXT NOT NULL, + user_sig_bbcode_uid VARCHAR(5) NOT NULL, + user_sig_bbcode_bitfield INTEGER DEFAULT 0 NOT NULL, + user_from VARCHAR(100) NOT NULL, + user_icq VARCHAR(15) NOT NULL, + user_aim VARCHAR(255) NOT NULL, + user_yim VARCHAR(255) NOT NULL, + user_msnm VARCHAR(255) NOT NULL, + user_jabber VARCHAR(255) NOT NULL, + user_website VARCHAR(100) NOT NULL, + user_occ VARCHAR(255) NOT NULL, + user_interests VARCHAR(255) NOT NULL, + user_actkey VARCHAR(32) NOT NULL, + user_newpasswd VARCHAR(32) NOT NULL +);; + +# phpbb_words CREATE TABLE phpbb_words ( - word_id INTEGER NOT NULL, - word CHAR(100) DEFAULT '' NOT NULL, - replacement CHAR(100) DEFAULT '' NOT NULL, - PRIMARY KEY (word_id) -); - -CREATE GENERATOR phpbb_words_gen; -SET GENERATOR phpbb_words_gen TO 0; - -CREATE TRIGGER phpbb_words_trig - FOR phpbb_words BEFORE INSERT - AS BEGIN - IF (NEW.word_id IS NULL) THEN - NEW.word_id = GEN_ID(phpbb_words_gen, 1)| - END; + word_id INTEGER NOT NULL, + word VARCHAR(100) NOT NULL, + replacement VARCHAR(100) NOT NULL +);; + +# phpbb_zebra +CREATE TABLE phpbb_zebra ( + user_id INTEGER DEFAULT 0 NOT NULL, + zebra_id INTEGER DEFAULT 0 NOT NULL, + friend INTEGER DEFAULT 0 NOT NULL, + foe INTEGER DEFAULT 0 NOT NULL +);; + +ALTER TABLE phpbb_attachments +ADD PRIMARY KEY ( + attach_id +);; + +CREATE INDEX filesize1 +ON phpbb_attachments( + filesize +);; + +CREATE INDEX filetime2 +ON phpbb_attachments( + filetime +);; + +CREATE INDEX post_msg_id4 +ON phpbb_attachments( + post_msg_id +);; + +CREATE INDEX poster_id5 +ON phpbb_attachments( + poster_id +);; + +CREATE INDEX topic_id6 +ON phpbb_attachments( + topic_id +);; + +CREATE INDEX auth_option_id7 +ON phpbb_auth_groups( + auth_option_id +);; + +CREATE INDEX group_id8 +ON phpbb_auth_groups( + group_id +);; + +ALTER TABLE phpbb_auth_options +ADD PRIMARY KEY ( + auth_option_id +);; + +CREATE INDEX auth_option9 +ON phpbb_auth_options( + auth_option +);; + +ALTER TABLE phpbb_auth_presets +ADD PRIMARY KEY ( + preset_id +);; + +CREATE INDEX preset_type10 +ON phpbb_auth_presets( + preset_type +);; + +CREATE INDEX auth_option_id11 +ON phpbb_auth_users( + auth_option_id +);; + +CREATE INDEX user_id12 +ON phpbb_auth_users( + user_id +);; + +ALTER TABLE phpbb_banlist +ADD PRIMARY KEY ( + ban_id +);; + +ALTER TABLE phpbb_bbcodes +ADD PRIMARY KEY ( + bbcode_id +);; + +CREATE INDEX order_id13 +ON phpbb_bookmarks( + order_id +);; + +CREATE INDEX topic_user_id14 +ON phpbb_bookmarks( + topic_id, + user_id +);; + +ALTER TABLE phpbb_bots +ADD PRIMARY KEY ( + bot_id +);; + +CREATE INDEX bot_active15 +ON phpbb_bots( + bot_active +);; + +ALTER TABLE phpbb_cache +ADD PRIMARY KEY ( + var_name +);; + +ALTER TABLE phpbb_config +ADD PRIMARY KEY ( + config_name +);; + +CREATE INDEX is_dynamic16 +ON phpbb_config( + is_dynamic +);; + +ALTER TABLE phpbb_confirm +ADD PRIMARY KEY ( + session_id, + confirm_id +);; + +ALTER TABLE phpbb_disallow +ADD PRIMARY KEY ( + disallow_id +);; + +ALTER TABLE phpbb_drafts +ADD PRIMARY KEY ( + draft_id +);; + +CREATE INDEX save_time17 +ON phpbb_drafts( + save_time +);; + +ALTER TABLE phpbb_extension_groups +ADD PRIMARY KEY ( + group_id +);; + +ALTER TABLE phpbb_extensions +ADD PRIMARY KEY ( + extension_id +);; + +ALTER TABLE phpbb_forum_access +ADD PRIMARY KEY ( + forum_id, + user_id, + session_id +);; + +ALTER TABLE phpbb_forums +ADD PRIMARY KEY ( + forum_id +);; + +CREATE INDEX forum_last_post_id18 +ON phpbb_forums( + forum_last_post_id +);; + +CREATE INDEX left_right_id19 +ON phpbb_forums( + left_id, + right_id +);; + +ALTER TABLE phpbb_forums_marking +ADD PRIMARY KEY ( + user_id, + forum_id +);; + +CREATE INDEX forum_id20 +ON phpbb_forums_watch( + forum_id +);; + +CREATE INDEX notify_status21 +ON phpbb_forums_watch( + notify_status +);; + +CREATE INDEX user_id22 +ON phpbb_forums_watch( + user_id +);; + +ALTER TABLE phpbb_groups +ADD PRIMARY KEY ( + group_id +);; + +CREATE INDEX group_legend23 +ON phpbb_groups( + group_legend +);; + +ALTER TABLE phpbb_icons +ADD PRIMARY KEY ( + icons_id +);; + +ALTER TABLE phpbb_lang +ADD PRIMARY KEY ( + lang_id +);; + +ALTER TABLE phpbb_log +ADD PRIMARY KEY ( + log_id +);; + +CREATE INDEX forum_id24 +ON phpbb_log( + forum_id +);; + +CREATE INDEX log_type25 +ON phpbb_log( + log_type +);; + +CREATE INDEX reportee_id26 +ON phpbb_log( + reportee_id +);; + +CREATE INDEX topic_id27 +ON phpbb_log( + topic_id +);; + +CREATE INDEX user_id28 +ON phpbb_log( + user_id +);; + +CREATE INDEX display_on_index29 +ON phpbb_moderator_cache( + display_on_index +);; + +CREATE INDEX forum_id30 +ON phpbb_moderator_cache( + forum_id +);; + +ALTER TABLE phpbb_modules +ADD PRIMARY KEY ( + module_id +);; + +CREATE INDEX module_type31 +ON phpbb_modules( + module_type, + module_enabled +);; + +CREATE INDEX poll_option_id32 +ON phpbb_poll_results( + poll_option_id +);; + +CREATE INDEX topic_id33 +ON phpbb_poll_results( + topic_id +);; + +CREATE INDEX vote_user_id35 +ON phpbb_poll_voters( + vote_user_id +);; + +CREATE INDEX vote_user_ip36 +ON phpbb_poll_voters( + vote_user_ip +);; + +ALTER TABLE phpbb_posts +ADD PRIMARY KEY ( + post_id +);; + +CREATE INDEX forum_id37 +ON phpbb_posts( + forum_id +);; + +CREATE INDEX post_approved38 +ON phpbb_posts( + post_approved +);; + +CREATE INDEX post_time39 +ON phpbb_posts( + post_time +);; + +CREATE INDEX poster_id40 +ON phpbb_posts( + poster_id +);; + +CREATE INDEX poster_ip41 +ON phpbb_posts( + poster_ip +);; + +CREATE INDEX topic_id42 +ON phpbb_posts( + topic_id +);; + +ALTER TABLE phpbb_privmsgs +ADD PRIMARY KEY ( + msg_id +);; + +CREATE INDEX author_id43 +ON phpbb_privmsgs( + author_id +);; + +CREATE INDEX author_ip44 +ON phpbb_privmsgs( + author_ip +);; + +CREATE INDEX message_time45 +ON phpbb_privmsgs( + message_time +);; + +CREATE INDEX root_level46 +ON phpbb_privmsgs( + root_level +);; + +ALTER TABLE phpbb_privmsgs_folder +ADD PRIMARY KEY ( + folder_id +);; + +CREATE INDEX user_id47 +ON phpbb_privmsgs_folder( + user_id +);; + +ALTER TABLE phpbb_privmsgs_rules +ADD PRIMARY KEY ( + rule_id +);; + +CREATE INDEX msg_id48 +ON phpbb_privmsgs_to( + msg_id +);; + +CREATE INDEX user_id49 +ON phpbb_privmsgs_to( + user_id, + folder_id +);; + +ALTER TABLE phpbb_profile_fields +ADD PRIMARY KEY ( + field_id +);; + +CREATE INDEX field_order50 +ON phpbb_profile_fields( + field_order +);; + +CREATE INDEX field_type51 +ON phpbb_profile_fields( + field_type +);; + +ALTER TABLE phpbb_profile_fields_data +ADD PRIMARY KEY ( + user_id +);; + +ALTER TABLE phpbb_profile_fields_lang +ADD PRIMARY KEY ( + field_id, + lang_id, + option_id +);; + +ALTER TABLE phpbb_profile_lang +ADD PRIMARY KEY ( + field_id, + lang_id +);; + +ALTER TABLE phpbb_ranks +ADD PRIMARY KEY ( + rank_id +);; + +CREATE INDEX post_id52 +ON phpbb_ratings( + post_id +);; + +CREATE INDEX user_id53 +ON phpbb_ratings( + user_id +);; + +ALTER TABLE phpbb_reports +ADD PRIMARY KEY ( + report_id +);; + +ALTER TABLE phpbb_reports_reasons +ADD PRIMARY KEY ( + reason_id +);; + +ALTER TABLE phpbb_search_results +ADD PRIMARY KEY ( + search_id +);; + +CREATE INDEX session_id54 +ON phpbb_search_results( + session_id +);; + +ALTER TABLE phpbb_search_wordlist +ADD PRIMARY KEY ( + word_text +);; + +CREATE INDEX word_id55 +ON phpbb_search_wordlist( + word_id +);; + +ALTER TABLE phpbb_sessions +ADD PRIMARY KEY ( + session_id +);; + +CREATE INDEX session_time57 +ON phpbb_sessions( + session_time +);; + +CREATE INDEX session_user_id58 +ON phpbb_sessions( + session_user_id +);; + +ALTER TABLE phpbb_sitelist +ADD PRIMARY KEY ( + site_id +);; + +ALTER TABLE phpbb_smilies +ADD PRIMARY KEY ( + smile_id +);; + +ALTER TABLE phpbb_styles +ADD PRIMARY KEY ( + style_id +);; + +CREATE UNIQUE INDEX style_name59 +ON phpbb_styles( + style_name +);; + +CREATE INDEX imageset_id60 +ON phpbb_styles( + imageset_id +);; + +CREATE INDEX template_id61 +ON phpbb_styles( + template_id +);; + +CREATE INDEX theme_id62 +ON phpbb_styles( + theme_id +);; + +CREATE UNIQUE INDEX imageset_name63 +ON phpbb_styles_imageset( + imageset_name +);; + +ALTER TABLE phpbb_styles_imageset +ADD PRIMARY KEY ( + imageset_id +);; + +ALTER TABLE phpbb_styles_template +ADD PRIMARY KEY ( + template_id +);; + +CREATE UNIQUE INDEX template_name64 +ON phpbb_styles_template( + template_name +);; + +CREATE INDEX template_filename65 +ON phpbb_styles_template_data( + template_filename +);; + +CREATE INDEX template_id66 +ON phpbb_styles_template_data( + template_id +);; + +ALTER TABLE phpbb_styles_theme +ADD PRIMARY KEY ( + theme_id +);; + +CREATE UNIQUE INDEX theme_name67 +ON phpbb_styles_theme( + theme_name +);; + +ALTER TABLE phpbb_topics +ADD PRIMARY KEY ( + topic_id +);; + +CREATE INDEX forum_id68 +ON phpbb_topics( + forum_id +);; + +CREATE INDEX forum_id_type69 +ON phpbb_topics( + forum_id, + topic_type +);; + +CREATE INDEX topic_last_post_time70 +ON phpbb_topics( + topic_last_post_time +);; + +ALTER TABLE phpbb_topics_marking +ADD PRIMARY KEY ( + user_id, + topic_id +);; + +CREATE INDEX notify_status71 +ON phpbb_topics_watch( + notify_status +);; + +CREATE INDEX topic_id72 +ON phpbb_topics_watch( + topic_id +);; + +CREATE INDEX user_id73 +ON phpbb_topics_watch( + user_id +);; + +CREATE INDEX group_id74 +ON phpbb_user_group( + group_id +);; + +CREATE INDEX group_leader75 +ON phpbb_user_group( + group_leader +);; + +CREATE INDEX user_id76 +ON phpbb_user_group( + user_id +);; + +CREATE INDEX user_birthday77 +ON phpbb_users( + user_birthday +);; + +CREATE INDEX user_email_hash78 +ON phpbb_users( + user_email_hash +);; + +CREATE INDEX username79 +ON phpbb_users( + username +);; + +ALTER TABLE phpbb_words +ADD PRIMARY KEY ( + word_id +);; + +CREATE INDEX user_id80 +ON phpbb_zebra( + user_id +);; + +CREATE INDEX zebra_id81 +ON phpbb_zebra( + zebra_id +);; + +CREATE GENERATOR G_phpbb_attachmentsattach_idGen;; + +SET GENERATOR G_phpbb_attachmentsattach_idGen TO 0;; + +CREATE GENERATOR b_auth_optionsauth_option_idGen;; + +SET GENERATOR b_auth_optionsauth_option_idGen TO 0;; + +CREATE GENERATOR G_auth_presetspreset_idGen;; + +SET GENERATOR G_auth_presetspreset_idGen TO 0;; + +CREATE GENERATOR G_phpbb_banlistban_idGen3;; + +SET GENERATOR G_phpbb_banlistban_idGen3 TO 0;; + +CREATE GENERATOR G_phpbb_botsbot_idGen4;; + +SET GENERATOR G_phpbb_botsbot_idGen4 TO 0;; + +CREATE GENERATOR G_phpbb_disallowdisallow_idGen5;; + +SET GENERATOR G_phpbb_disallowdisallow_idGen5 TO 0;; + +CREATE GENERATOR G_phpbb_draftsdraft_idGen6;; + +SET GENERATOR G_phpbb_draftsdraft_idGen6 TO 0;; + +CREATE GENERATOR pbb_extension_groupsgroup_idGen;; + +SET GENERATOR pbb_extension_groupsgroup_idGen TO 0;; + +CREATE GENERATOR phpbb_extensionsextension_idGen;; + +SET GENERATOR phpbb_extensionsextension_idGen TO 0;; + +CREATE GENERATOR G_phpbb_forumsforum_idGen9;; + +SET GENERATOR G_phpbb_forumsforum_idGen9 TO 0;; + +CREATE GENERATOR G_phpbb_groupsgroup_idGen10;; + +SET GENERATOR G_phpbb_groupsgroup_idGen10 TO 0;; + +CREATE GENERATOR G_phpbb_iconsicons_idGen11;; + +SET GENERATOR G_phpbb_iconsicons_idGen11 TO 0;; + +CREATE GENERATOR G_phpbb_langlang_idGen12;; + +SET GENERATOR G_phpbb_langlang_idGen12 TO 0;; + +CREATE GENERATOR G_phpbb_loglog_idGen13;; + +SET GENERATOR G_phpbb_loglog_idGen13 TO 0;; + +CREATE GENERATOR G_phpbb_modulesmodule_idGen14;; + +SET GENERATOR G_phpbb_modulesmodule_idGen14 TO 0;; + +CREATE GENERATOR G_phpbb_postspost_idGen15;; + +SET GENERATOR G_phpbb_postspost_idGen15 TO 0;; + +CREATE GENERATOR G_phpbb_privmsgsmsg_idGen16;; + +SET GENERATOR G_phpbb_privmsgsmsg_idGen16 TO 0;; + +CREATE GENERATOR bb_privmsgs_folderfolder_idGen1;; + +SET GENERATOR bb_privmsgs_folderfolder_idGen1 TO 0;; + +CREATE GENERATOR phpbb_privmsgs_rulesrule_idGen1;; + +SET GENERATOR phpbb_privmsgs_rulesrule_idGen1 TO 0;; + +CREATE GENERATOR hpbb_profile_fieldsfield_idGen1;; + +SET GENERATOR hpbb_profile_fieldsfield_idGen1 TO 0;; + +CREATE GENERATOR G_phpbb_ranksrank_idGen20;; + +SET GENERATOR G_phpbb_ranksrank_idGen20 TO 0;; + +CREATE GENERATOR G_phpbb_reportsreport_idGen21;; + +SET GENERATOR G_phpbb_reportsreport_idGen21 TO 0;; + +CREATE GENERATOR bb_reports_reasonsreason_idGen2;; + +SET GENERATOR bb_reports_reasonsreason_idGen2 TO 0;; + +CREATE GENERATOR hpbb_search_wordlistword_idGen2;; + +SET GENERATOR hpbb_search_wordlistword_idGen2 TO 0;; + +CREATE GENERATOR G_phpbb_sitelistsite_idGen24;; + +SET GENERATOR G_phpbb_sitelistsite_idGen24 TO 0;; + +CREATE GENERATOR G_phpbb_smiliessmile_idGen25;; + +SET GENERATOR G_phpbb_smiliessmile_idGen25 TO 0;; + +CREATE GENERATOR G_phpbb_stylesstyle_idGen26;; + +SET GENERATOR G_phpbb_stylesstyle_idGen26 TO 0;; + +CREATE GENERATOR G_styles_imagesetimageset_idGen;; + +SET GENERATOR G_styles_imagesetimageset_idGen TO 0;; + +CREATE GENERATOR G_styles_templatetemplate_idGen;; + +SET GENERATOR G_styles_templatetemplate_idGen TO 0;; + +CREATE GENERATOR G_phpbb_styles_themetheme_idGen;; + +SET GENERATOR G_phpbb_styles_themetheme_idGen TO 0;; + +CREATE GENERATOR G_phpbb_topicstopic_idGen30;; + +SET GENERATOR G_phpbb_topicstopic_idGen30 TO 0;; + +CREATE GENERATOR G_phpbb_usersuser_idGen31;; + +SET GENERATOR G_phpbb_usersuser_idGen31 TO 0;; + +CREATE GENERATOR G_phpbb_wordsword_idGen32;; + +SET GENERATOR G_phpbb_wordsword_idGen32 TO 0;; + +CREATE TRIGGER tG_phpbb_attachmentsattach_idGe FOR phpbb_attachments +BEFORE INSERT +AS +BEGIN + NEW.attach_id = GEN_ID(G_phpbb_attachmentsattach_idGen, 1); +END;; + +CREATE TRIGGER tb_auth_optionsauth_option_idGe FOR phpbb_auth_options +BEFORE INSERT +AS +BEGIN + NEW.auth_option_id = GEN_ID(b_auth_optionsauth_option_idGen, 1); +END;; + +CREATE TRIGGER t_phpbb_auth_presetspreset_idGe FOR phpbb_auth_presets +BEFORE INSERT +AS +BEGIN + NEW.preset_id = GEN_ID(G_auth_presetspreset_idGen, 1); +END;; + +CREATE TRIGGER GetNextG_phpbb_banlistban_idGen FOR phpbb_banlist +BEFORE INSERT +AS +BEGIN + NEW.ban_id = GEN_ID(G_phpbb_banlistban_idGen3, 1); +END;; + +CREATE TRIGGER GetNextG_phpbb_botsbot_idGen4 FOR phpbb_bots +BEFORE INSERT +AS +BEGIN + NEW.bot_id = GEN_ID(G_phpbb_botsbot_idGen4, 1); +END;; + +CREATE TRIGGER tG_phpbb_disallowdisallow_idGen FOR phpbb_disallow +BEFORE INSERT +AS +BEGIN + NEW.disallow_id = GEN_ID(G_phpbb_disallowdisallow_idGen5, 1); +END;; + +CREATE TRIGGER etNextG_phpbb_draftsdraft_idGen FOR phpbb_drafts +BEFORE INSERT +AS +BEGIN + NEW.draft_id = GEN_ID(G_phpbb_draftsdraft_idGen6, 1); +END;; + +CREATE TRIGGER tpbb_extension_groupsgroup_idGe FOR phpbb_extension_groups +BEFORE INSERT +AS +BEGIN + NEW.group_id = GEN_ID(pbb_extension_groupsgroup_idGen, 1); +END;; + +CREATE TRIGGER tphpbb_extensionsextension_idGe FOR phpbb_extensions +BEFORE INSERT +AS +BEGIN + NEW.extension_id = GEN_ID(phpbb_extensionsextension_idGen, 1); +END;; + +CREATE TRIGGER etNextG_phpbb_forumsforum_idGen FOR phpbb_forums +BEFORE INSERT +AS +BEGIN + NEW.forum_id = GEN_ID(G_phpbb_forumsforum_idGen9, 1); +END;; + +CREATE TRIGGER tNextG_phpbb_groupsgroup_idGen1 FOR phpbb_groups +BEFORE INSERT +AS +BEGIN + NEW.group_id = GEN_ID(G_phpbb_groupsgroup_idGen10, 1); +END;; + +CREATE TRIGGER etNextG_phpbb_iconsicons_idGen1 FOR phpbb_icons +BEFORE INSERT +AS +BEGIN + NEW.icons_id = GEN_ID(G_phpbb_iconsicons_idGen11, 1); +END;; + +CREATE TRIGGER GetNextG_phpbb_langlang_idGen12 FOR phpbb_lang +BEFORE INSERT +AS +BEGIN + NEW.lang_id = GEN_ID(G_phpbb_langlang_idGen12, 1); +END;; + +CREATE TRIGGER GetNextG_phpbb_loglog_idGen13 FOR phpbb_log +BEFORE INSERT +AS +BEGIN + NEW.log_id = GEN_ID(G_phpbb_loglog_idGen13, 1); +END;; + +CREATE TRIGGER extG_phpbb_modulesmodule_idGen1 FOR phpbb_modules +BEFORE INSERT +AS +BEGIN + NEW.module_id = GEN_ID(G_phpbb_modulesmodule_idGen14, 1); +END;; + +CREATE TRIGGER GetNextG_phpbb_postspost_idGen1 FOR phpbb_posts +BEFORE INSERT +AS +BEGIN + NEW.post_id = GEN_ID(G_phpbb_postspost_idGen15, 1); +END;; + +CREATE TRIGGER tNextG_phpbb_privmsgsmsg_idGen1 FOR phpbb_privmsgs +BEFORE INSERT +AS +BEGIN + NEW.msg_id = GEN_ID(G_phpbb_privmsgsmsg_idGen16, 1); +END;; + +CREATE TRIGGER tbb_privmsgs_folderfolder_idGen FOR phpbb_privmsgs_folder +BEFORE INSERT +AS +BEGIN + NEW.folder_id = GEN_ID(bb_privmsgs_folderfolder_idGen1, 1); +END;; + +CREATE TRIGGER tphpbb_privmsgs_rulesrule_idGen FOR phpbb_privmsgs_rules +BEFORE INSERT +AS +BEGIN + NEW.rule_id = GEN_ID(phpbb_privmsgs_rulesrule_idGen1, 1); +END;; + +CREATE TRIGGER thpbb_profile_fieldsfield_idGen FOR phpbb_profile_fields +BEFORE INSERT +AS +BEGIN + NEW.field_id = GEN_ID(hpbb_profile_fieldsfield_idGen1, 1); +END;; + +CREATE TRIGGER GetNextG_phpbb_ranksrank_idGen2 FOR phpbb_ranks +BEFORE INSERT +AS +BEGIN + NEW.rank_id = GEN_ID(G_phpbb_ranksrank_idGen20, 1); +END;; + +CREATE TRIGGER extG_phpbb_reportsreport_idGen2 FOR phpbb_reports +BEFORE INSERT +AS +BEGIN + NEW.report_id = GEN_ID(G_phpbb_reportsreport_idGen21, 1); +END;; + +CREATE TRIGGER tbb_reports_reasonsreason_idGen FOR phpbb_reports_reasons +BEFORE INSERT +AS +BEGIN + NEW.reason_id = GEN_ID(bb_reports_reasonsreason_idGen2, 1); +END;; + +CREATE TRIGGER thpbb_search_wordlistword_idGen FOR phpbb_search_wordlist +BEFORE INSERT +AS +BEGIN + NEW.word_id = GEN_ID(hpbb_search_wordlistword_idGen2, 1); +END;; + +CREATE TRIGGER NextG_phpbb_sitelistsite_idGen2 FOR phpbb_sitelist +BEFORE INSERT +AS +BEGIN + NEW.site_id = GEN_ID(G_phpbb_sitelistsite_idGen24, 1); +END;; + +CREATE TRIGGER NextG_phpbb_smiliessmile_idGen2 FOR phpbb_smilies +BEFORE INSERT +AS +BEGIN + NEW.smile_id = GEN_ID(G_phpbb_smiliessmile_idGen25, 1); +END;; + +CREATE TRIGGER tNextG_phpbb_stylesstyle_idGen2 FOR phpbb_styles +BEFORE INSERT +AS +BEGIN + NEW.style_id = GEN_ID(G_phpbb_stylesstyle_idGen26, 1); +END;; + +CREATE TRIGGER t_styles_imagesetimageset_idGen FOR phpbb_styles_imageset +BEFORE INSERT +AS +BEGIN + NEW.imageset_id = GEN_ID(G_styles_imagesetimageset_idGen, 1); +END;; + +CREATE TRIGGER t_styles_templatetemplate_idGen FOR phpbb_styles_template +BEFORE INSERT +AS +BEGIN + NEW.template_id = GEN_ID(G_styles_templatetemplate_idGen, 1); +END;; + +CREATE TRIGGER t_phpbb_styles_themetheme_idGen FOR phpbb_styles_theme +BEFORE INSERT +AS +BEGIN + NEW.theme_id = GEN_ID(G_phpbb_styles_themetheme_idGen, 1); +END;; + +CREATE TRIGGER tNextG_phpbb_topicstopic_idGen3 FOR phpbb_topics +BEFORE INSERT +AS +BEGIN + NEW.topic_id = GEN_ID(G_phpbb_topicstopic_idGen30, 1); +END;; + +CREATE TRIGGER GetNextG_phpbb_usersuser_idGen3 FOR phpbb_users +BEFORE INSERT +AS +BEGIN + NEW.user_id = GEN_ID(G_phpbb_usersuser_idGen31, 1); +END;; + +CREATE TRIGGER GetNextG_phpbb_wordsword_idGen3 FOR phpbb_words +BEFORE INSERT +AS +BEGIN + NEW.word_id = GEN_ID(G_phpbb_wordsword_idGen32, 1); +END;; |