+namespace phpbb\db\driver;

+abstract class driver implements driver_interface

+ $this->sql_layer = substr(get_class($this), strlen('phpbb\db\driver\\'));

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ // If we are within a transaction we will not open another one, but enclose the current one to not loose data (preventing auto commit)

+ // If there was a previously opened transaction we do not commit yet...

+ // but count back the number of inner transactions

+ // Check if there is a transaction (no transaction can happen if

+ // there was an error, with a combined rollback and error returning enabled)

+ * {@inheritDoc}

+ else if ($query == 'UPDATE' || $query == 'SELECT' || $query == 'DELETE')

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ global $cache, $starttime, $phpbb_root_path, $phpbb_path_helper, $user;

+ <link href="' . htmlspecialchars($phpbb_path_helper->update_web_root_path($phpbb_root_path) . $phpbb_path_helper->get_adm_relative_path()) . 'style/admin.css" rel="stylesheet" type="text/css" media="screen" />

+ * {@inheritDoc}

+ * {@inheritDoc}

+<?php

+/**

+*

+* @package dbal

+* @copyright (c) 2014 phpBB Group

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+*

+*/

+

+namespace phpbb\db\driver;

+

+interface driver_interface

+{

+ /**

+ * Gets the exact number of rows in a specified table.

+ *

+ * @param string $table_name Table name

+ * @return string Exact number of rows in $table_name.

+ */

+ public function get_row_count($table_name);

+

+ /**

+ * Gets the estimated number of rows in a specified table.

+ *

+ * @param string $table_name Table name

+ * @return string Number of rows in $table_name.

+ * Prefixed with ~ if estimated (otherwise exact).

+ */

+ public function get_estimated_row_count($table_name);

+

+ /**

+ * Run LOWER() on DB column of type text (i.e. neither varchar nor char).

+ *

+ * @param string $column_name The column name to use

+ * @return string A SQL statement like "LOWER($column_name)"

+ */

+ public function sql_lower_text($column_name);

+

+ /**

+ * Display sql error page

+ *

+ * @param string $sql The SQL query causing the error

+ * @return mixed Returns the full error message, if $this->return_on_error

+ * is set, null otherwise

+ */

+ public function sql_error($sql = '');

+

+ /**

+ * Returns whether results of a query need to be buffered to run a

+ * transaction while iterating over them.

+ *

+ * @return bool Whether buffering is required.

+ */

+ public function sql_buffer_nested_transactions();

+

+ /**

+ * Run binary OR operator on DB column.

+ *

+ * @param string $column_name The column name to use

+ * @param int $bit The value to use for the OR operator,

+ * will be converted to (1 << $bit). Is used by options,

+ * using the number schema... 0, 1, 2...29

+ * @param string $compare Any custom SQL code after the check (e.g. "= 0")

+ * @return string A SQL statement like "$column | (1 << $bit) {$compare}"

+ */

+ public function sql_bit_or($column_name, $bit, $compare = '');

+

+ /**

+ * Version information about used database

+ *

+ * @param bool $raw Only return the fetched sql_server_version

+ * @param bool $use_cache Is it safe to retrieve the value from the cache

+ * @return string sql server version

+ */

+ public function sql_server_info($raw = false, $use_cache = true);

+

+ /**

+ * Return on error or display error message

+ *

+ * @param bool $fail Should we return on errors, or stop

+ * @return null

+ */

+ public function sql_return_on_error($fail = false);

+

+ /**

+ * Build sql statement from an array

+ *

+ * @param string $query Should be on of the following strings:

+ * INSERT, INSERT_SELECT, UPDATE, SELECT, DELETE

+ * @param array $assoc_ary Array with "column => value" pairs

+ * @return string A SQL statement like "c1 = 'a' AND c2 = 'b'"

+ */

+ public function sql_build_array($query, $assoc_ary = array());

+

+ /**

+ * Fetch all rows

+ *

+ * @param mixed $query_id Already executed query to get the rows from,

+ * if false, the last query will be used.

+ * @return mixed Nested array if the query had rows, false otherwise

+ */

+ public function sql_fetchrowset($query_id = false);

+

+ /**

+ * SQL Transaction

+ *

+ * @param string $status Should be one of the following strings:

+ * begin, commit, rollback

+ * @return mixed Buffered, seekable result handle, false on error

+ */

+ public function sql_transaction($status = 'begin');

+

+ /**

+ * Build a concatenated expression

+ *

+ * @param string $expr1 Base SQL expression where we append the second one

+ * @param string $expr2 SQL expression that is appended to the first expression

+ * @return string Concatenated string

+ */

+ public function sql_concatenate($expr1, $expr2);

+

+ /**

+ * Build a case expression

+ *

+ * Note: The two statements action_true and action_false must have the same

+ * data type (int, vchar, ...) in the database!

+ *

+ * @param string $condition The condition which must be true,

+ * to use action_true rather then action_else

+ * @param string $action_true SQL expression that is used, if the condition is true

+ * @param mixed $action_false SQL expression that is used, if the condition is false

+ * @return string CASE expression including the condition and statements

+ */

+ public function sql_case($condition, $action_true, $action_false = false);

+

+ /**

+ * Build sql statement from array for select and select distinct statements

+ *

+ * Possible query values: SELECT, SELECT_DISTINCT

+ *

+ * @param string $query Should be one of: SELECT, SELECT_DISTINCT

+ * @param array $array Array with the query data:

+ * SELECT A comma imploded list of columns to select

+ * FROM Array with "table => alias" pairs,

+ * (alias can also be an array)

+ * Optional: LEFT_JOIN Array of join entries:

+ * FROM Table that should be joined

+ * ON Condition for the join

+ * Optional: WHERE Where SQL statement

+ * Optional: GROUP_BY Group by SQL statement

+ * Optional: ORDER_BY Order by SQL statement

+ * @return string A SQL statement ready for execution

+ */

+ public function sql_build_query($query, $array);

+

+ /**

+ * Fetch field

+ * if rownum is false, the current row is used, else it is pointing to the row (zero-based)

+ *

+ * @param string $field Name of the column

+ * @param mixed $rownum Row number, if false the current row will be used

+ * and the row curser will point to the next row

+ * Note: $rownum is 0 based

+ * @param mixed $query_id Already executed query to get the rows from,

+ * if false, the last query will be used.

+ * @return mixed String value of the field in the selected row,

+ * false, if the row does not exist

+ */

+ public function sql_fetchfield($field, $rownum = false, $query_id = false);

+

+ /**

+ * Fetch current row

+ *

+ * @param mixed $query_id Already executed query to get the rows from,

+ * if false, the last query will be used.

+ * @return mixed Array with the current row,

+ * false, if the row does not exist

+ */

+ public function sql_fetchrow($query_id = false);

+

+ /**

+ * Returns SQL string to cast a string expression to an int.

+ *

+ * @param string $expression An expression evaluating to string

+ * @return string Expression returning an int

+ */

+ public function cast_expr_to_bigint($expression);

+

+ /**

+ * Get last inserted id after insert statement

+ *

+ * @return string Autoincrement value of the last inserted row

+ */

+ public function sql_nextid();

+

+ /**

+ * Add to query count

+ *

+ * @param bool $cached Is this query cached?

+ * @return null

+ */

+ public function sql_add_num_queries($cached = false);

+

+ /**

+ * Build LIMIT query

+ *

+ * @param string $query The SQL query to execute

+ * @param int $total The number of rows to select

+ * @param int $offset

+ * @param int $cache_ttl Either 0 to avoid caching or

+ * the time in seconds which the result shall be kept in cache

+ * @return mixed Buffered, seekable result handle, false on error

+ */

+ public function sql_query_limit($query, $total, $offset = 0, $cache_ttl = 0);

+

+ /**

+ * Base query method

+ *

+ * @param string $query The SQL query to execute

+ * @param int $cache_ttl Either 0 to avoid caching or

+ * the time in seconds which the result shall be kept in cache

+ * @return mixed Buffered, seekable result handle, false on error

+ */

+ public function sql_query($query = '', $cache_ttl = 0);

+

+ /**

+ * Returns SQL string to cast an integer expression to a string.

+ *

+ * @param string $expression An expression evaluating to int

+ * @return string Expression returning a string

+ */

+ public function cast_expr_to_string($expression);

+

+ /**

+ * Connect to server

+ *

+ * @param string $sqlserver Address of the database server

+ * @param string $sqluser User name of the SQL user

+ * @param string $sqlpassword Password of the SQL user

+ * @param string $database Name of the database

+ * @param mixed $port Port of the database server

+ * @param bool $persistency

+ * @param bool $new_link Should a new connection be established

+ * @return mixed Connection ID on success, string error message otherwise

+ */

+ public function sql_connect($sqlserver, $sqluser, $sqlpassword, $database, $port = false, $persistency = false, $new_link = false);

+

+ /**

+ * Run binary AND operator on DB column.

+ * Results in sql statement: "{$column_name} & (1 << {$bit}) {$compare}"

+ *

+ * @param string $column_name The column name to use

+ * @param int $bit The value to use for the AND operator,

+ * will be converted to (1 << $bit). Is used by

+ * options, using the number schema: 0, 1, 2...29

+ * @param string $compare Any custom SQL code after the check (for example "= 0")

+ * @return string A SQL statement like: "{$column} & (1 << {$bit}) {$compare}"

+ */

+ public function sql_bit_and($column_name, $bit, $compare = '');

+

+ /**

+ * Free sql result

+ *

+ * @param mixed $query_id Already executed query result,

+ * if false, the last query will be used.

+ * @return null

+ */

+ public function sql_freeresult($query_id = false);

+

+ /**

+ * Return number of sql queries and cached sql queries used

+ *

+ * @param bool $cached Should we return the number of cached or normal queries?

+ * @return int Number of queries that have been executed

+ */

+ public function sql_num_queries($cached = false);

+

+ /**

+ * Run more than one insert statement.

+ *

+ * @param string $table Table name to run the statements on

+ * @param array $sql_ary Multi-dimensional array holding the statement data

+ * @return bool false if no statements were executed.

+ */

+ public function sql_multi_insert($table, $sql_ary);

+

+ /**

+ * Return number of affected rows

+ *

+ * @return mixed Number of the affected rows by the last query

+ * false if no query has been run before

+ */

+ public function sql_affectedrows();

+

+ /**

+ * DBAL garbage collection, close SQL connection

+ *

+ * @return mixed False if no connection was opened before,

+ * Server response otherwise

+ */

+ public function sql_close();

+

+ /**

+ * Seek to given row number

+ *

+ * @param mixed $rownum Row number the curser should point to

+ * Note: $rownum is 0 based

+ * @param mixed $query_id ID of the query to set the row cursor on

+ * if false, the last query will be used.

+ * $query_id will then be set correctly

+ * @return bool False if something went wrong

+ */

+ public function sql_rowseek($rownum, &$query_id);

+

+ /**

+ * Escape string used in sql query

+ *

+ * @param string $msg String to be escaped

+ * @return string Escaped version of $msg

+ */

+ public function sql_escape($msg);

+

+ /**

+ * Correctly adjust LIKE expression for special characters

+ * Some DBMS are handling them in a different way

+ *

+ * @param string $expression The expression to use. Every wildcard is

+ * escaped, except $this->any_char and $this->one_char

+ * @return string A SQL statement like: "LIKE 'bertie_%'"

+ */

+ public function sql_like_expression($expression);

+

+ /**

+ * Explain queries

+ *

+ * @param string $mode Available modes: display, start, stop,

+ * add_select_row, fromcache, record_fromcache

+ * @param string $query The Query that should be explained

+ * @return mixed Either a full HTML page, boolean or null

+ */

+ public function sql_report($mode, $query = '');

+

+ /**

+ * Build IN or NOT IN sql comparison string, uses <> or = on single element

+ * arrays to improve comparison speed

+ *

+ * @param string $field Name of the sql column that shall be compared

+ * @param array $array Array of values that are (not) allowed

+ * @param bool $negate true for NOT IN (), false for IN ()

+ * @param bool $allow_empty_set If true, allow $array to be empty,

+ * this function will return 1=1 or 1=0 then.

+ * @return string A SQL statement like: "IN (1, 2, 3, 4)" or "= 1"

+ */

+ public function sql_in_set($field, $array, $negate = false, $allow_empty_set = false);

+}

+namespace phpbb\db\driver;

+class firebird extends \phpbb\db\driver\driver

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ if ($cache && !is_object($query_id) && $cache->sql_exists($query_id))

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+namespace phpbb\db\driver;

+class mssql extends \phpbb\db\driver\driver

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ $row[$key] = ($value === ' ' || $value === null) ? '' : $value;

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ if ($cache && !is_object($query_id) && $cache->sql_exists($query_id))

+ if (isset($this->open_queries[(int) $query_id]))

+ unset($this->open_queries[(int) $query_id]);

+ * {@inheritDoc}

+namespace phpbb\db\driver;

+abstract class mssql_base extends \phpbb\db\driver\driver

+ * {@inheritDoc}

+namespace phpbb\db\driver;

+class mssql_odbc extends \phpbb\db\driver\mssql_base

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ if ($cache && !is_object($query_id) && $cache->sql_exists($query_id))

+namespace phpbb\db\driver;

+class mssqlnative extends \phpbb\db\driver\mssql_base

+ var $m_insert_id = null;

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ $row[$key] = ($value === ' ' || $value === null) ? '' : $value;

+ * {@inheritDoc}

+ * {@inheritDoc}

+ if ($cache && !is_object($query_id) && $cache->sql_exists($query_id))

+

+namespace phpbb\db\driver;

+class mysql extends \phpbb\db\driver\mysql_base

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ if ($cache && !is_object($query_id) && $cache->sql_exists($query_id))

+ * {@inheritDoc}

+namespace phpbb\db\driver;

+abstract class mysql_base extends \phpbb\db\driver\driver

+ * {@inheritDoc}

+ * {@inheritDoc}

+namespace phpbb\db\driver;

+class mysqli extends \phpbb\db\driver\mysql_base

+ * {@inheritDoc}

+ function sql_connect($sqlserver, $sqluser, $sqlpassword, $database, $port = false, $persistency = false, $new_link = false)

+ $port = (!$port) ? null : $port;

+ $socket = null;

+ $port = null;

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+namespace phpbb\db\driver;

+class oracle extends \phpbb\db\driver\driver

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ if ($cache && !is_object($query_id) && $cache->sql_exists($query_id))

+ * {@inheritDoc}

+namespace phpbb\db\driver;

+class postgres extends \phpbb\db\driver\driver

+ * {@inheritDoc}

+ $collector = new \phpbb\error_collector;

+ $collector = new \phpbb\error_collector;

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ $temp_result = @pg_fetch_assoc($temp_q_id, null);

+ * {@inheritDoc}

+ if ($cache && !is_object($query_id) && $cache->sql_exists($query_id))

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ while ($row = @pg_fetch_assoc($result, null))

+ while ($void = @pg_fetch_assoc($result, null))

+namespace phpbb\db\driver;

+class sqlite extends \phpbb\db\driver\driver

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ if ($cache && !is_object($query_id) && $cache->sql_exists($query_id))

+ * {@inheritDoc}

+ * {@inheritDoc}

+ *

+namespace phpbb\db\migration\data\v30x;

+

+class local_url_bbcode extends \phpbb\db\migration\migration

+ return array('\phpbb\db\migration\data\v30x\release_3_0_12_rc1');

+ $acp_bbcodes = new \acp_bbcodes();

+<?php

+/**

+*

+* @package migration

+* @copyright (c) 2014 phpBB Group

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+*

+*/

+

+namespace phpbb\db\migration\data\v30x;

+

+class release_3_0_0 extends \phpbb\db\migration\migration

+{

+ public function effectively_installed()

+ {

+ return phpbb_version_compare($this->config['version'], '3.0.0', '>=');

+ }

+

+ public function update_schema()

+ {

+ return array(

+ 'add_tables' => array(

+ $this->table_prefix . 'attachments' => array(

+ 'COLUMNS' => array(

+ 'attach_id' => array('UINT', NULL, 'auto_increment'),

+ 'post_msg_id' => array('UINT', 0),

+ 'topic_id' => array('UINT', 0),

+ 'in_message' => array('BOOL', 0),

+ 'poster_id' => array('UINT', 0),

+ 'is_orphan' => array('BOOL', 1),

+ 'physical_filename' => array('VCHAR', ''),

+ 'real_filename' => array('VCHAR', ''),

+ 'download_count' => array('UINT', 0),

+ 'attach_comment' => array('TEXT_UNI', ''),

+ 'extension' => array('VCHAR:100', ''),

+ 'mimetype' => array('VCHAR:100', ''),

+ 'filesize' => array('UINT:20', 0),

+ 'filetime' => array('TIMESTAMP', 0),

+ 'thumbnail' => array('BOOL', 0),

+ ),

+ 'PRIMARY_KEY' => 'attach_id',

+ 'KEYS' => array(

+ 'filetime' => array('INDEX', 'filetime'),

+ 'post_msg_id' => array('INDEX', 'post_msg_id'),

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

+ 'poster_id' => array('INDEX', 'poster_id'),

+ 'is_orphan' => array('INDEX', 'is_orphan'),

+ ),

+ ),

+

+ $this->table_prefix . 'acl_groups' => array(

+ 'COLUMNS' => array(

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

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

+ 'auth_option_id' => array('UINT', 0),

+ 'auth_role_id' => array('UINT', 0),

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

+ ),

+ 'KEYS' => array(

+ 'group_id' => array('INDEX', 'group_id'),

+ 'auth_opt_id' => array('INDEX', 'auth_option_id'),

+ 'auth_role_id' => array('INDEX', 'auth_role_id'),

+ ),

+ ),

+

+ $this->table_prefix . 'acl_options' => array(

+ 'COLUMNS' => array(

+ 'auth_option_id' => array('UINT', NULL, 'auto_increment'),

+ 'auth_option' => array('VCHAR:50', ''),

+ 'is_global' => array('BOOL', 0),

+ 'is_local' => array('BOOL', 0),

+ 'founder_only' => array('BOOL', 0),

+ ),

+ 'PRIMARY_KEY' => 'auth_option_id',

+ 'KEYS' => array(

+ 'auth_option' => array('INDEX', 'auth_option'),

+ ),

+ ),

+

+ $this->table_prefix . 'acl_roles' => array(

+ 'COLUMNS' => array(

+ 'role_id' => array('UINT', NULL, 'auto_increment'),

+ 'role_name' => array('VCHAR_UNI', ''),

+ 'role_description' => array('TEXT_UNI', ''),

+ 'role_type' => array('VCHAR:10', ''),

+ 'role_order' => array('USINT', 0),

+ ),

+ 'PRIMARY_KEY' => 'role_id',

+ 'KEYS' => array(

+ 'role_type' => array('INDEX', 'role_type'),

+ 'role_order' => array('INDEX', 'role_order'),

+ ),

+ ),

+

+ $this->table_prefix . 'acl_roles_data' => array(

+ 'COLUMNS' => array(

+ 'role_id' => array('UINT', 0),

+ 'auth_option_id' => array('UINT', 0),

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

+ ),

+ 'PRIMARY_KEY' => array('role_id', 'auth_option_id'),

+ 'KEYS' => array(

+ 'ath_op_id' => array('INDEX', 'auth_option_id'),

+ ),

+ ),

+

+ $this->table_prefix . 'acl_users' => array(

+ 'COLUMNS' => array(

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

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

+ 'auth_option_id' => array('UINT', 0),

+ 'auth_role_id' => array('UINT', 0),

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

+ ),

+ 'KEYS' => array(

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

+ 'auth_option_id' => array('INDEX', 'auth_option_id'),

+ 'auth_role_id' => array('INDEX', 'auth_role_id'),

+ ),

+ ),

+

+ $this->table_prefix . 'banlist' => array(

+ 'COLUMNS' => array(

+ 'ban_id' => array('UINT', NULL, 'auto_increment'),

+ 'ban_userid' => array('UINT', 0),

+ 'ban_ip' => array('VCHAR:40', ''),

+ 'ban_email' => array('VCHAR_UNI:100', ''),

+ 'ban_start' => array('TIMESTAMP', 0),

+ 'ban_end' => array('TIMESTAMP', 0),

+ 'ban_exclude' => array('BOOL', 0),

+ 'ban_reason' => array('VCHAR_UNI', ''),

+ 'ban_give_reason' => array('VCHAR_UNI', ''),

+ ),

+ 'PRIMARY_KEY' => 'ban_id',

+ 'KEYS' => array(

+ 'ban_end' => array('INDEX', 'ban_end'),

+ 'ban_user' => array('INDEX', array('ban_userid', 'ban_exclude')),

+ 'ban_email' => array('INDEX', array('ban_email', 'ban_exclude')),

+ 'ban_ip' => array('INDEX', array('ban_ip', 'ban_exclude')),

+ ),

+ ),

+

+ $this->table_prefix . 'bbcodes' => array(

+ 'COLUMNS' => array(

+ 'bbcode_id' => array('TINT:3', 0),

+ 'bbcode_tag' => array('VCHAR:16', ''),

+ 'bbcode_helpline' => array('VCHAR_UNI', ''),

+ 'display_on_posting' => array('BOOL', 0),

+ 'bbcode_match' => array('TEXT_UNI', ''),

+ 'bbcode_tpl' => array('MTEXT_UNI', ''),

+ 'first_pass_match' => array('MTEXT_UNI', ''),

+ 'first_pass_replace' => array('MTEXT_UNI', ''),

+ 'second_pass_match' => array('MTEXT_UNI', ''),

+ 'second_pass_replace' => array('MTEXT_UNI', ''),

+ ),

+ 'PRIMARY_KEY' => 'bbcode_id',

+ 'KEYS' => array(

+ 'display_on_post' => array('INDEX', 'display_on_posting'),

+ ),

+ ),

+

+ $this->table_prefix . 'bookmarks' => array(

+ 'COLUMNS' => array(

+ 'topic_id' => array('UINT', 0),

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

+ ),

+ 'PRIMARY_KEY' => array('topic_id', 'user_id'),

+ ),

+

+ $this->table_prefix . 'bots' => array(

+ 'COLUMNS' => array(

+ 'bot_id' => array('UINT', NULL, 'auto_increment'),

+ 'bot_active' => array('BOOL', 1),

+ 'bot_name' => array('STEXT_UNI', ''),

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

+ 'bot_agent' => array('VCHAR', ''),

+ 'bot_ip' => array('VCHAR', ''),

+ ),

+ 'PRIMARY_KEY' => 'bot_id',

+ 'KEYS' => array(

+ 'bot_active' => array('INDEX', 'bot_active'),

+ ),

+ ),

+

+ $this->table_prefix . 'config' => array(

+ 'COLUMNS' => array(

+ 'config_name' => array('VCHAR', ''),

+ 'config_value' => array('VCHAR_UNI', ''),

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

+ ),

+ 'PRIMARY_KEY' => 'config_name',

+ 'KEYS' => array(

+ 'is_dynamic' => array('INDEX', 'is_dynamic'),

+ ),

+ ),

+

+ $this->table_prefix . 'confirm' => array(

+ 'COLUMNS' => array(

+ 'confirm_id' => array('CHAR:32', ''),

+ 'session_id' => array('CHAR:32', ''),

+ 'confirm_type' => array('TINT:3', 0),

+ 'code' => array('VCHAR:8', ''),

+ 'seed' => array('UINT:10', 0),

+ ),

+ 'PRIMARY_KEY' => array('session_id', 'confirm_id'),

+ 'KEYS' => array(

+ 'confirm_type' => array('INDEX', 'confirm_type'),

+ ),

+ ),

+

+ $this->table_prefix . 'disallow' => array(

+ 'COLUMNS' => array(

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

+ 'disallow_username' => array('VCHAR_UNI:255', ''),

+ ),

+ 'PRIMARY_KEY' => 'disallow_id',

+ ),

+

+ $this->table_prefix . 'drafts' => array(

+ 'COLUMNS' => array(

+ 'draft_id' => array('UINT', NULL, 'auto_increment'),

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

+ 'topic_id' => array('UINT', 0),

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

+ 'save_time' => array('TIMESTAMP', 0),

+ 'draft_subject' => array('XSTEXT_UNI', ''),

+ 'draft_message' => array('MTEXT_UNI', ''),

+ ),

+ 'PRIMARY_KEY' => 'draft_id',

+ 'KEYS' => array(

+ 'save_time' => array('INDEX', 'save_time'),

+ ),

+ ),

+

+ $this->table_prefix . 'extensions' => array(

+ 'COLUMNS' => array(

+ 'extension_id' => array('UINT', NULL, 'auto_increment'),

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

+ 'extension' => array('VCHAR:100', ''),

+ ),

+ 'PRIMARY_KEY' => 'extension_id',

+ ),

+

+ $this->table_prefix . 'extension_groups' => array(

+ 'COLUMNS' => array(

+ 'group_id' => array('UINT', NULL, 'auto_increment'),

+ 'group_name' => array('VCHAR_UNI', ''),

+ 'cat_id' => array('TINT:2', 0),

+ 'allow_group' => array('BOOL', 0),

+ 'download_mode' => array('BOOL', 1),

+ 'upload_icon' => array('VCHAR', ''),

+ 'max_filesize' => array('UINT:20', 0),

+ 'allowed_forums' => array('TEXT', ''),

+ 'allow_in_pm' => array('BOOL', 0),

+ ),

+ 'PRIMARY_KEY' => 'group_id',

+ ),

+

+ $this->table_prefix . 'forums' => array(

+ 'COLUMNS' => array(

+ 'forum_id' => array('UINT', NULL, 'auto_increment'),

+ 'parent_id' => array('UINT', 0),

+ 'left_id' => array('UINT', 0),

+ 'right_id' => array('UINT', 0),

+ 'forum_parents' => array('MTEXT', ''),

+ 'forum_name' => array('STEXT_UNI', ''),

+ 'forum_desc' => array('TEXT_UNI', ''),

+ 'forum_desc_bitfield' => array('VCHAR:255', ''),

+ 'forum_desc_options' => array('UINT:11', 7),

+ 'forum_desc_uid' => array('VCHAR:8', ''),

+ 'forum_link' => array('VCHAR_UNI', ''),

+ 'forum_password' => array('VCHAR_UNI:40', ''),

+ 'forum_style' => array('USINT', 0),

+ 'forum_image' => array('VCHAR', ''),

+ 'forum_rules' => array('TEXT_UNI', ''),

+ 'forum_rules_link' => array('VCHAR_UNI', ''),

+ 'forum_rules_bitfield' => array('VCHAR:255', ''),

+ 'forum_rules_options' => array('UINT:11', 7),

+ 'forum_rules_uid' => array('VCHAR:8', ''),

+ 'forum_topics_per_page' => array('TINT:4', 0),

+ 'forum_type' => array('TINT:4', 0),

+ 'forum_status' => array('TINT:4', 0),

+ 'forum_posts' => array('UINT', 0),

+ 'forum_topics' => array('UINT', 0),

+ 'forum_topics_real' => array('UINT', 0),

+ 'forum_last_post_id' => array('UINT', 0),

+ 'forum_last_poster_id' => array('UINT', 0),

+ 'forum_last_post_subject' => array('XSTEXT_UNI', ''),

+ 'forum_last_post_time' => array('TIMESTAMP', 0),

+ 'forum_last_poster_name'=> array('VCHAR_UNI', ''),

+ 'forum_last_poster_colour'=> array('VCHAR:6', ''),

+ 'forum_flags' => array('TINT:4', 32),

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

+ 'enable_indexing' => array('BOOL', 1),

+ 'enable_icons' => array('BOOL', 1),

+ 'enable_prune' => array('BOOL', 0),

+ 'prune_next' => array('TIMESTAMP', 0),

+ 'prune_days' => array('UINT', 0),

+ 'prune_viewed' => array('UINT', 0),

+ 'prune_freq' => array('UINT', 0),

+ ),

+ 'PRIMARY_KEY' => 'forum_id',

+ 'KEYS' => array(

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

+ 'forum_lastpost_id' => array('INDEX', 'forum_last_post_id'),

+ ),

+ ),

+

+ $this->table_prefix . 'forums_access' => array(

+ 'COLUMNS' => array(

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

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

+ 'session_id' => array('CHAR:32', ''),

+ ),

+ 'PRIMARY_KEY' => array('forum_id', 'user_id', 'session_id'),

+ ),

+

+ $this->table_prefix . 'forums_track' => array(

+ 'COLUMNS' => array(

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

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

+ 'mark_time' => array('TIMESTAMP', 0),

+ ),

+ 'PRIMARY_KEY' => array('user_id', 'forum_id'),

+ ),

+

+ $this->table_prefix . 'forums_watch' => array(

+ 'COLUMNS' => array(

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

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

+ 'notify_status' => array('BOOL', 0),

+ ),

+ 'KEYS' => array(

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

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

+ 'notify_stat' => array('INDEX', 'notify_status'),

+ ),

+ ),

+

+ $this->table_prefix . 'groups' => array(

+ 'COLUMNS' => array(

+ 'group_id' => array('UINT', NULL, 'auto_increment'),

+ 'group_type' => array('TINT:4', 1),

+ 'group_founder_manage' => array('BOOL', 0),

+ 'group_name' => array('VCHAR_CI', ''),

+ 'group_desc' => array('TEXT_UNI', ''),

+ 'group_desc_bitfield' => array('VCHAR:255', ''),

+ 'group_desc_options' => array('UINT:11', 7),

+ 'group_desc_uid' => array('VCHAR:8', ''),

+ 'group_display' => array('BOOL', 0),

+ 'group_avatar' => array('VCHAR', ''),

+ 'group_avatar_type' => array('TINT:2', 0),

+ 'group_avatar_width' => array('USINT', 0),

+ 'group_avatar_height' => array('USINT', 0),

+ 'group_rank' => array('UINT', 0),

+ 'group_colour' => array('VCHAR:6', ''),

+ 'group_sig_chars' => array('UINT', 0),

+ 'group_receive_pm' => array('BOOL', 0),

+ 'group_message_limit' => array('UINT', 0),

+ 'group_legend' => array('BOOL', 1),

+ ),

+ 'PRIMARY_KEY' => 'group_id',

+ 'KEYS' => array(

+ 'group_legend' => array('INDEX', 'group_legend'),

+ ),

+ ),

+

+ $this->table_prefix . 'icons' => array(

+ 'COLUMNS' => array(

+ 'icons_id' => array('UINT', NULL, 'auto_increment'),

+ 'icons_url' => array('VCHAR', ''),

+ 'icons_width' => array('TINT:4', 0),

+ 'icons_height' => array('TINT:4', 0),

+ 'icons_order' => array('UINT', 0),

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

+ ),

+ 'PRIMARY_KEY' => 'icons_id',

+ 'KEYS' => array(

+ 'display_on_posting' => array('INDEX', 'display_on_posting'),

+ ),

+ ),

+

+ $this->table_prefix . 'lang' => array(

+ 'COLUMNS' => array(

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

+ 'lang_iso' => array('VCHAR:30', ''),

+ 'lang_dir' => array('VCHAR:30', ''),

+ 'lang_english_name' => array('VCHAR_UNI:100', ''),

+ 'lang_local_name' => array('VCHAR_UNI:255', ''),

+ 'lang_author' => array('VCHAR_UNI:255', ''),

+ ),

+ 'PRIMARY_KEY' => 'lang_id',

+ 'KEYS' => array(

+ 'lang_iso' => array('INDEX', 'lang_iso'),

+ ),

+ ),

+

+ $this->table_prefix . 'log' => array(

+ 'COLUMNS' => array(

+ 'log_id' => array('UINT', NULL, 'auto_increment'),

+ 'log_type' => array('TINT:4', 0),

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

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

+ 'topic_id' => array('UINT', 0),

+ 'reportee_id' => array('UINT', 0),

+ 'log_ip' => array('VCHAR:40', ''),

+ 'log_time' => array('TIMESTAMP', 0),

+ 'log_operation' => array('TEXT_UNI', ''),

+ 'log_data' => array('MTEXT_UNI', ''),

+ ),

+ 'PRIMARY_KEY' => 'log_id',

+ 'KEYS' => array(

+ 'log_type' => array('INDEX', 'log_type'),

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

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

+ 'reportee_id' => array('INDEX', 'reportee_id'),

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

+ ),

+ ),

+

+ $this->table_prefix . 'moderator_cache' => array(

+ 'COLUMNS' => array(

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

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

+ 'username' => array('VCHAR_UNI:255', ''),

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

+ 'group_name' => array('VCHAR_UNI', ''),

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

+ ),

+ 'KEYS' => array(

+ 'disp_idx' => array('INDEX', 'display_on_index'),

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

+ ),

+ ),

+

+ $this->table_prefix . 'modules' => array(

+ 'COLUMNS' => array(

+ 'module_id' => array('UINT', NULL, 'auto_increment'),

+ 'module_enabled' => array('BOOL', 1),

+ 'module_display' => array('BOOL', 1),

+ 'module_basename' => array('VCHAR', ''),

+ 'module_class' => array('VCHAR:10', ''),

+ 'parent_id' => array('UINT', 0),

+ 'left_id' => array('UINT', 0),

+ 'right_id' => array('UINT', 0),

+ 'module_langname' => array('VCHAR', ''),

+ 'module_mode' => array('VCHAR', ''),

+ 'module_auth' => array('VCHAR', ''),

+ ),

+ 'PRIMARY_KEY' => 'module_id',

+ 'KEYS' => array(

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

+ 'module_enabled' => array('INDEX', 'module_enabled'),

+ 'class_left_id' => array('INDEX', array('module_class', 'left_id')),

+ ),

+ ),

+

+ $this->table_prefix . 'poll_options' => array(

+ 'COLUMNS' => array(

+ 'poll_option_id' => array('TINT:4', 0),

+ 'topic_id' => array('UINT', 0),

+ 'poll_option_text' => array('TEXT_UNI', ''),

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

+ ),

+ 'KEYS' => array(

+ 'poll_opt_id' => array('INDEX', 'poll_option_id'),

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

+ ),

+ ),

+

+ $this->table_prefix . 'poll_votes' => array(

+ 'COLUMNS' => array(

+ 'topic_id' => array('UINT', 0),

+ 'poll_option_id' => array('TINT:4', 0),

+ 'vote_user_id' => array('UINT', 0),

+ 'vote_user_ip' => array('VCHAR:40', ''),

+ ),

+ 'KEYS' => array(

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

+ 'vote_user_id' => array('INDEX', 'vote_user_id'),

+ 'vote_user_ip' => array('INDEX', 'vote_user_ip'),

+ ),

+ ),

+

+ $this->table_prefix . 'posts' => array(

+ 'COLUMNS' => array(

+ 'post_id' => array('UINT', NULL, 'auto_increment'),

+ 'topic_id' => array('UINT', 0),

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

+ 'poster_id' => array('UINT', 0),

+ 'icon_id' => array('UINT', 0),

+ 'poster_ip' => array('VCHAR:40', ''),

+ 'post_time' => array('TIMESTAMP', 0),

+ 'post_approved' => array('BOOL', 1),

+ 'post_reported' => array('BOOL', 0),

+ 'enable_bbcode' => array('BOOL', 1),

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

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

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

+ 'post_username' => array('VCHAR_UNI:255', ''),

+ 'post_subject' => array('XSTEXT_UNI', '', 'true_sort'),

+ 'post_text' => array('MTEXT_UNI', ''),

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

+ 'post_attachment' => array('BOOL', 0),

+ 'bbcode_bitfield' => array('VCHAR:255', ''),

+ 'bbcode_uid' => array('VCHAR:8', ''),

+ 'post_postcount' => array('BOOL', 1),

+ 'post_edit_time' => array('TIMESTAMP', 0),

+ 'post_edit_reason' => array('STEXT_UNI', ''),

+ 'post_edit_user' => array('UINT', 0),

+ 'post_edit_count' => array('USINT', 0),

+ 'post_edit_locked' => array('BOOL', 0),

+ ),

+ 'PRIMARY_KEY' => 'post_id',

+ 'KEYS' => array(

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

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

+ 'poster_ip' => array('INDEX', 'poster_ip'),

+ 'poster_id' => array('INDEX', 'poster_id'),

+ 'post_approved' => array('INDEX', 'post_approved'),

+ 'tid_post_time' => array('INDEX', array('topic_id', 'post_time')),

+ ),

+ ),

+

+ $this->table_prefix . 'privmsgs' => array(

+ 'COLUMNS' => array(

+ 'msg_id' => array('UINT', NULL, 'auto_increment'),

+ 'root_level' => array('UINT', 0),

+ 'author_id' => array('UINT', 0),

+ 'icon_id' => array('UINT', 0),

+ 'author_ip' => array('VCHAR:40', ''),

+ 'message_time' => array('TIMESTAMP', 0),

+ 'enable_bbcode' => array('BOOL', 1),

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

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

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

+ 'message_subject' => array('XSTEXT_UNI', ''),

+ 'message_text' => array('MTEXT_UNI', ''),

+ 'message_edit_reason' => array('STEXT_UNI', ''),

+ 'message_edit_user' => array('UINT', 0),

+ 'message_attachment' => array('BOOL', 0),

+ 'bbcode_bitfield' => array('VCHAR:255', ''),

+ 'bbcode_uid' => array('VCHAR:8', ''),

+ 'message_edit_time' => array('TIMESTAMP', 0),

+ 'message_edit_count' => array('USINT', 0),

+ 'to_address' => array('TEXT_UNI', ''),

+ 'bcc_address' => array('TEXT_UNI', ''),

+ ),

+ 'PRIMARY_KEY' => 'msg_id',

+ 'KEYS' => array(

+ 'author_ip' => array('INDEX', 'author_ip'),

+ 'message_time' => array('INDEX', 'message_time'),

+ 'author_id' => array('INDEX', 'author_id'),

+ 'root_level' => array('INDEX', 'root_level'),

+ ),

+ ),

+

+ $this->table_prefix . 'privmsgs_folder' => array(

+ 'COLUMNS' => array(

+ 'folder_id' => array('UINT', NULL, 'auto_increment'),

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

+ 'folder_name' => array('VCHAR_UNI', ''),

+ 'pm_count' => array('UINT', 0),

+ ),

+ 'PRIMARY_KEY' => 'folder_id',

+ 'KEYS' => array(

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

+ ),

+ ),

+

+ $this->table_prefix . 'privmsgs_rules' => array(

+ 'COLUMNS' => array(

+ 'rule_id' => array('UINT', NULL, 'auto_increment'),

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

+ 'rule_check' => array('UINT', 0),

+ 'rule_connection' => array('UINT', 0),

+ 'rule_string' => array('VCHAR_UNI', ''),

+ 'rule_user_id' => array('UINT', 0),

+ 'rule_group_id' => array('UINT', 0),

+ 'rule_action' => array('UINT', 0),

+ 'rule_folder_id' => array('INT:11', 0),

+ ),

+ 'PRIMARY_KEY' => 'rule_id',

+ 'KEYS' => array(

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

+ ),

+ ),

+

+ $this->table_prefix . 'privmsgs_to' => array(

+ 'COLUMNS' => array(

+ 'msg_id' => array('UINT', 0),

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

+ 'author_id' => array('UINT', 0),

+ 'pm_deleted' => array('BOOL', 0),

+ 'pm_new' => array('BOOL', 1),

+ 'pm_unread' => array('BOOL', 1),

+ 'pm_replied' => array('BOOL', 0),

+ 'pm_marked' => array('BOOL', 0),

+ 'pm_forwarded' => array('BOOL', 0),

+ 'folder_id' => array('INT:11', 0),

+ ),

+ 'KEYS' => array(

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

+ 'author_id' => array('INDEX', 'author_id'),

+ 'usr_flder_id' => array('INDEX', array('user_id', 'folder_id')),

+ ),

+ ),

+

+ $this->table_prefix . 'profile_fields' => array(

+ 'COLUMNS' => array(

+ 'field_id' => array('UINT', NULL, 'auto_increment'),

+ 'field_name' => array('VCHAR_UNI', ''),

+ 'field_type' => array('TINT:4', 0),

+ 'field_ident' => array('VCHAR:20', ''),

+ 'field_length' => array('VCHAR:20', ''),

+ 'field_minlen' => array('VCHAR', ''),

+ 'field_maxlen' => array('VCHAR', ''),

+ 'field_novalue' => array('VCHAR_UNI', ''),

+ 'field_default_value' => array('VCHAR_UNI', ''),

+ 'field_validation' => array('VCHAR_UNI:20', ''),

+ 'field_required' => array('BOOL', 0),

+ 'field_show_on_reg' => array('BOOL', 0),

+ 'field_hide' => array('BOOL', 0),

+ 'field_no_view' => array('BOOL', 0),

+ 'field_active' => array('BOOL', 0),

+ 'field_order' => array('UINT', 0),

+ ),

+ 'PRIMARY_KEY' => 'field_id',

+ 'KEYS' => array(

+ 'fld_type' => array('INDEX', 'field_type'),

+ 'fld_ordr' => array('INDEX', 'field_order'),

+ ),

+ ),

+

+ $this->table_prefix . 'profile_fields_data' => array(

+ 'COLUMNS' => array(

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

+ ),

+ 'PRIMARY_KEY' => 'user_id',

+ ),

+

+ $this->table_prefix . 'profile_fields_lang' => array(

+ 'COLUMNS' => array(

+ 'field_id' => array('UINT', 0),

+ 'lang_id' => array('UINT', 0),

+ 'option_id' => array('UINT', 0),

+ 'field_type' => array('TINT:4', 0),

+ 'lang_value' => array('VCHAR_UNI', ''),

+ ),

+ 'PRIMARY_KEY' => array('field_id', 'lang_id', 'option_id'),

+ ),

+

+ $this->table_prefix . 'profile_lang' => array(

+ 'COLUMNS' => array(

+ 'field_id' => array('UINT', 0),

+ 'lang_id' => array('UINT', 0),

+ 'lang_name' => array('VCHAR_UNI', ''),

+ 'lang_explain' => array('TEXT_UNI', ''),

+ 'lang_default_value' => array('VCHAR_UNI', ''),

+ ),

+ 'PRIMARY_KEY' => array('field_id', 'lang_id'),

+ ),

+

+ $this->table_prefix . 'ranks' => array(

+ 'COLUMNS' => array(

+ 'rank_id' => array('UINT', NULL, 'auto_increment'),

+ 'rank_title' => array('VCHAR_UNI', ''),

+ 'rank_min' => array('UINT', 0),

+ 'rank_special' => array('BOOL', 0),

+ 'rank_image' => array('VCHAR', ''),

+ ),

+ 'PRIMARY_KEY' => 'rank_id',

+ ),

+

+ $this->table_prefix . 'reports' => array(

+ 'COLUMNS' => array(

+ 'report_id' => array('UINT', NULL, 'auto_increment'),

+ 'reason_id' => array('USINT', 0),

+ 'post_id' => array('UINT', 0),

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

+ 'user_notify' => array('BOOL', 0),

+ 'report_closed' => array('BOOL', 0),

+ 'report_time' => array('TIMESTAMP', 0),

+ 'report_text' => array('MTEXT_UNI', ''),

+ ),

+ 'PRIMARY_KEY' => 'report_id',

+ ),

+

+ $this->table_prefix . 'reports_reasons' => array(

+ 'COLUMNS' => array(

+ 'reason_id' => array('USINT', NULL, 'auto_increment'),

+ 'reason_title' => array('VCHAR_UNI', ''),

+ 'reason_description' => array('MTEXT_UNI', ''),

+ 'reason_order' => array('USINT', 0),

+ ),

+ 'PRIMARY_KEY' => 'reason_id',

+ ),

+

+ $this->table_prefix . 'search_results' => array(

+ 'COLUMNS' => array(

+ 'search_key' => array('VCHAR:32', ''),

+ 'search_time' => array('TIMESTAMP', 0),

+ 'search_keywords' => array('MTEXT_UNI', ''),

+ 'search_authors' => array('MTEXT', ''),

+ ),

+ 'PRIMARY_KEY' => 'search_key',

+ ),

+

+ $this->table_prefix . 'search_wordlist' => array(

+ 'COLUMNS' => array(

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

+ 'word_text' => array('VCHAR_UNI', ''),

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

+ 'word_count' => array('UINT', 0),

+ ),

+ 'PRIMARY_KEY' => 'word_id',

+ 'KEYS' => array(

+ 'wrd_txt' => array('UNIQUE', 'word_text'),

+ 'wrd_cnt' => array('INDEX', 'word_count'),

+ ),

+ ),

+

+ $this->table_prefix . 'search_wordmatch' => array(

+ 'COLUMNS' => array(

+ 'post_id' => array('UINT', 0),

+ 'word_id' => array('UINT', 0),

+ 'title_match' => array('BOOL', 0),

+ ),

+ 'KEYS' => array(

+ 'unq_mtch' => array('UNIQUE', array('word_id', 'post_id', 'title_match')),

+ 'word_id' => array('INDEX', 'word_id'),

+ 'post_id' => array('INDEX', 'post_id'),

+ ),

+ ),

+

+ $this->table_prefix . 'sessions' => array(

+ 'COLUMNS' => array(

+ 'session_id' => array('CHAR:32', ''),

+ 'session_user_id' => array('UINT', 0),

+ 'session_last_visit' => array('TIMESTAMP', 0),

+ 'session_start' => array('TIMESTAMP', 0),

+ 'session_time' => array('TIMESTAMP', 0),

+ 'session_ip' => array('VCHAR:40', ''),

+ 'session_browser' => array('VCHAR:150', ''),

+ 'session_forwarded_for' => array('VCHAR:255', ''),

+ 'session_page' => array('VCHAR_UNI', ''),

+ 'session_viewonline' => array('BOOL', 1),

+ 'session_autologin' => array('BOOL', 0),

+ 'session_admin' => array('BOOL', 0),

+ ),

+ 'PRIMARY_KEY' => 'session_id',

+ 'KEYS' => array(

+ 'session_time' => array('INDEX', 'session_time'),

+ 'session_user_id' => array('INDEX', 'session_user_id'),

+ ),

+ ),

+

+ $this->table_prefix . 'sessions_keys' => array(

+ 'COLUMNS' => array(

+ 'key_id' => array('CHAR:32', ''),

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

+ 'last_ip' => array('VCHAR:40', ''),

+ 'last_login' => array('TIMESTAMP', 0),

+ ),

+ 'PRIMARY_KEY' => array('key_id', 'user_id'),

+ 'KEYS' => array(

+ 'last_login' => array('INDEX', 'last_login'),

+ ),

+ ),

+

+ $this->table_prefix . 'sitelist' => array(

+ 'COLUMNS' => array(

+ 'site_id' => array('UINT', NULL, 'auto_increment'),

+ 'site_ip' => array('VCHAR:40', ''),

+ 'site_hostname' => array('VCHAR', ''),

+ 'ip_exclude' => array('BOOL', 0),

+ ),

+ 'PRIMARY_KEY' => 'site_id',

+ ),

+

+ $this->table_prefix . 'smilies' => array(

+ 'COLUMNS' => array(

+ 'smiley_id' => array('UINT', NULL, 'auto_increment'),

+// We may want to set 'code' to VCHAR:50 or check if unicode support is possible... at the moment only ASCII characters are allowed.

+ 'code' => array('VCHAR_UNI:50', ''),

+ 'emotion' => array('VCHAR_UNI:50', ''),

+ 'smiley_url' => array('VCHAR:50', ''),

+ 'smiley_width' => array('USINT', 0),

+ 'smiley_height' => array('USINT', 0),

+ 'smiley_order' => array('UINT', 0),

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

+ ),

+ 'PRIMARY_KEY' => 'smiley_id',

+ 'KEYS' => array(

+ 'display_on_post' => array('INDEX', 'display_on_posting'),

+ ),

+ ),

+

+ $this->table_prefix . 'styles' => array(

+ 'COLUMNS' => array(

+ 'style_id' => array('USINT', NULL, 'auto_increment'),

+ 'style_name' => array('VCHAR_UNI:255', ''),

+ 'style_copyright' => array('VCHAR_UNI', ''),

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

+ 'template_id' => array('USINT', 0),

+ 'theme_id' => array('USINT', 0),

+ 'imageset_id' => array('USINT', 0),

+ ),

+ 'PRIMARY_KEY' => 'style_id',

+ 'KEYS' => array(

+ 'style_name' => array('UNIQUE', 'style_name'),

+ 'template_id' => array('INDEX', 'template_id'),

+ 'theme_id' => array('INDEX', 'theme_id'),

+ 'imageset_id' => array('INDEX', 'imageset_id'),

+ ),

+ ),

+

+ $this->table_prefix . 'styles_template' => array(

+ 'COLUMNS' => array(

+ 'template_id' => array('USINT', NULL, 'auto_increment'),

+ 'template_name' => array('VCHAR_UNI:255', ''),

+ 'template_copyright' => array('VCHAR_UNI', ''),

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

+ 'bbcode_bitfield' => array('VCHAR:255', 'kNg='),

+ 'template_storedb' => array('BOOL', 0),

+ ),

+ 'PRIMARY_KEY' => 'template_id',

+ 'KEYS' => array(

+ 'tmplte_nm' => array('UNIQUE', 'template_name'),

+ ),

+ ),

+

+ $this->table_prefix . 'styles_template_data' => array(

+ 'COLUMNS' => array(

+ 'template_id' => array('USINT', 0),

+ 'template_filename' => array('VCHAR:100', ''),

+ 'template_included' => array('TEXT', ''),

+ 'template_mtime' => array('TIMESTAMP', 0),

+ 'template_data' => array('MTEXT_UNI', ''),

+ ),

+ 'KEYS' => array(

+ 'tid' => array('INDEX', 'template_id'),

+ 'tfn' => array('INDEX', 'template_filename'),

+ ),

+ ),

+

+ $this->table_prefix . 'styles_theme' => array(

+ 'COLUMNS' => array(

+ 'theme_id' => array('USINT', NULL, 'auto_increment'),

+ 'theme_name' => array('VCHAR_UNI:255', ''),

+ 'theme_copyright' => array('VCHAR_UNI', ''),

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

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

+ 'theme_mtime' => array('TIMESTAMP', 0),

+ 'theme_data' => array('MTEXT_UNI', ''),

+ ),

+ 'PRIMARY_KEY' => 'theme_id',

+ 'KEYS' => array(

+ 'theme_name' => array('UNIQUE', 'theme_name'),

+ ),

+ ),

+

+ $this->table_prefix . 'styles_imageset' => array(

+ 'COLUMNS' => array(

+ 'imageset_id' => array('USINT', NULL, 'auto_increment'),

+ 'imageset_name' => array('VCHAR_UNI:255', ''),

+ 'imageset_copyright' => array('VCHAR_UNI', ''),

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

+ ),

+ 'PRIMARY_KEY' => 'imageset_id',

+ 'KEYS' => array(

+ 'imgset_nm' => array('UNIQUE', 'imageset_name'),

+ ),

+ ),

+

+ $this->table_prefix . 'styles_imageset_data' => array(

+ 'COLUMNS' => array(

+ 'image_id' => array('USINT', NULL, 'auto_increment'),

+ 'image_name' => array('VCHAR:200', ''),

+ 'image_filename' => array('VCHAR:200', ''),

+ 'image_lang' => array('VCHAR:30', ''),

+ 'image_height' => array('USINT', 0),

+ 'image_width' => array('USINT', 0),

+ 'imageset_id' => array('USINT', 0),

+ ),

+ 'PRIMARY_KEY' => 'image_id',

+ 'KEYS' => array(

+ 'i_d' => array('INDEX', 'imageset_id'),

+ ),

+ ),

+

+ $this->table_prefix . 'topics' => array(

+ 'COLUMNS' => array(

+ 'topic_id' => array('UINT', NULL, 'auto_increment'),

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

+ 'icon_id' => array('UINT', 0),

+ 'topic_attachment' => array('BOOL', 0),

+ 'topic_approved' => array('BOOL', 1),

+ 'topic_reported' => array('BOOL', 0),

+ 'topic_title' => array('XSTEXT_UNI', '', 'true_sort'),

+ 'topic_poster' => array('UINT', 0),

+ 'topic_time' => array('TIMESTAMP', 0),

+ 'topic_time_limit' => array('TIMESTAMP', 0),

+ 'topic_views' => array('UINT', 0),

+ 'topic_replies' => array('UINT', 0),

+ 'topic_replies_real' => array('UINT', 0),

+ 'topic_status' => array('TINT:3', 0),

+ 'topic_type' => array('TINT:3', 0),

+ 'topic_first_post_id' => array('UINT', 0),

+ 'topic_first_poster_name' => array('VCHAR_UNI', ''),

+ 'topic_first_poster_colour' => array('VCHAR:6', ''),

+ 'topic_last_post_id' => array('UINT', 0),

+ 'topic_last_poster_id' => array('UINT', 0),

+ 'topic_last_poster_name' => array('VCHAR_UNI', ''),

+ 'topic_last_poster_colour' => array('VCHAR:6', ''),

+ 'topic_last_post_subject' => array('XSTEXT_UNI', ''),

+ 'topic_last_post_time' => array('TIMESTAMP', 0),

+ 'topic_last_view_time' => array('TIMESTAMP', 0),

+ 'topic_moved_id' => array('UINT', 0),

+ 'topic_bumped' => array('BOOL', 0),

+ 'topic_bumper' => array('UINT', 0),

+ 'poll_title' => array('STEXT_UNI', ''),

+ 'poll_start' => array('TIMESTAMP', 0),

+ 'poll_length' => array('TIMESTAMP', 0),

+ 'poll_max_options' => array('TINT:4', 1),

+ 'poll_last_vote' => array('TIMESTAMP', 0),

+ 'poll_vote_change' => array('BOOL', 0),

+ ),

+ 'PRIMARY_KEY' => 'topic_id',

+ 'KEYS' => array(

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

+ 'forum_id_type' => array('INDEX', array('forum_id', 'topic_type')),

+ 'last_post_time' => array('INDEX', 'topic_last_post_time'),

+ 'topic_approved' => array('INDEX', 'topic_approved'),

+ 'forum_appr_last' => array('INDEX', array('forum_id', 'topic_approved', 'topic_last_post_id')),

+ 'fid_time_moved' => array('INDEX', array('forum_id', 'topic_last_post_time', 'topic_moved_id')),

+ ),

+ ),

+

+ $this->table_prefix . 'topics_track' => array(

+ 'COLUMNS' => array(

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

+ 'topic_id' => array('UINT', 0),

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

+ 'mark_time' => array('TIMESTAMP', 0),

+ ),

+ 'PRIMARY_KEY' => array('user_id', 'topic_id'),

+ 'KEYS' => array(

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

+ ),

+ ),

+

+ $this->table_prefix . 'topics_posted' => array(

+ 'COLUMNS' => array(

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

+ 'topic_id' => array('UINT', 0),

+ 'topic_posted' => array('BOOL', 0),

+ ),

+ 'PRIMARY_KEY' => array('user_id', 'topic_id'),

+ ),

+

+ $this->table_prefix . 'topics_watch' => array(

+ 'COLUMNS' => array(

+ 'topic_id' => array('UINT', 0),

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

+ 'notify_status' => array('BOOL', 0),

+ ),

+ 'KEYS' => array(

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

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

+ 'notify_stat' => array('INDEX', 'notify_status'),

+ ),

+ ),

+

+ $this->table_prefix . 'user_group' => array(

+ 'COLUMNS' => array(

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

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

+ 'group_leader' => array('BOOL', 0),

+ 'user_pending' => array('BOOL', 1),

+ ),

+ 'KEYS' => array(

+ 'group_id' => array('INDEX', 'group_id'),

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

+ 'group_leader' => array('INDEX', 'group_leader'),

+ ),

+ ),

+

+ $this->table_prefix . 'users' => array(

+ 'COLUMNS' => array(

+ 'user_id' => array('UINT', NULL, 'auto_increment'),

+ 'user_type' => array('TINT:2', 0),

+ 'group_id' => array('UINT', 3),

+ 'user_permissions' => array('MTEXT', ''),

+ 'user_perm_from' => array('UINT', 0),

+ 'user_ip' => array('VCHAR:40', ''),

+ 'user_regdate' => array('TIMESTAMP', 0),

+ 'username' => array('VCHAR_CI', ''),

+ 'username_clean' => array('VCHAR_CI', ''),

+ 'user_password' => array('VCHAR_UNI:40', ''),

+ 'user_passchg' => array('TIMESTAMP', 0),

+ 'user_pass_convert' => array('BOOL', 0),

+ 'user_email' => array('VCHAR_UNI:100', ''),

+ 'user_email_hash' => array('BINT', 0),

+ 'user_birthday' => array('VCHAR:10', ''),

+ 'user_lastvisit' => array('TIMESTAMP', 0),

+ 'user_lastmark' => array('TIMESTAMP', 0),

+ 'user_lastpost_time' => array('TIMESTAMP', 0),

+ 'user_lastpage' => array('VCHAR_UNI:200', ''),

+ 'user_last_confirm_key' => array('VCHAR:10', ''),

+ 'user_last_search' => array('TIMESTAMP', 0),

+ 'user_warnings' => array('TINT:4', 0),

+ 'user_last_warning' => array('TIMESTAMP', 0),

+ 'user_login_attempts' => array('TINT:4', 0),

+ 'user_inactive_reason' => array('TINT:2', 0),

+ 'user_inactive_time' => array('TIMESTAMP', 0),

+ 'user_posts' => array('UINT', 0),

+ 'user_lang' => array('VCHAR:30', ''),

+ 'user_timezone' => array('DECIMAL', 0),

+ 'user_dst' => array('BOOL', 0),

+ 'user_dateformat' => array('VCHAR_UNI:30', 'd M Y H:i'),

+ 'user_style' => array('USINT', 0),

+ 'user_rank' => array('UINT', 0),

+ 'user_colour' => array('VCHAR:6', ''),

+ 'user_new_privmsg' => array('INT:4', 0),

+ 'user_unread_privmsg' => array('INT:4', 0),

+ 'user_last_privmsg' => array('TIMESTAMP', 0),

+ 'user_message_rules' => array('BOOL', 0),

+ 'user_full_folder' => array('INT:11', -3),

+ 'user_emailtime' => array('TIMESTAMP', 0),

+ 'user_topic_show_days' => array('USINT', 0),

+ 'user_topic_sortby_type' => array('VCHAR:1', 't'),

+ 'user_topic_sortby_dir' => array('VCHAR:1', 'd'),

+ 'user_post_show_days' => array('USINT', 0),

+ 'user_post_sortby_type' => array('VCHAR:1', 't'),

+ 'user_post_sortby_dir' => array('VCHAR:1', 'a'),

+ 'user_notify' => array('BOOL', 0),

+ 'user_notify_pm' => array('BOOL', 1),

+ 'user_notify_type' => array('TINT:4', 0),

+ 'user_allow_pm' => array('BOOL', 1),

+ 'user_allow_viewonline' => array('BOOL', 1),

+ 'user_allow_viewemail' => array('BOOL', 1),

+ 'user_allow_massemail' => array('BOOL', 1),

+ 'user_options' => array('UINT:11', 895),

+ 'user_avatar' => array('VCHAR', ''),

+ 'user_avatar_type' => array('TINT:2', 0),

+ 'user_avatar_width' => array('USINT', 0),

+ 'user_avatar_height' => array('USINT', 0),

+ 'user_sig' => array('MTEXT_UNI', ''),

+ 'user_sig_bbcode_uid' => array('VCHAR:8', ''),

+ 'user_sig_bbcode_bitfield' => array('VCHAR:255', ''),

+ 'user_from' => array('VCHAR_UNI:100', ''),

+ 'user_icq' => array('VCHAR:15', ''),

+ 'user_aim' => array('VCHAR_UNI', ''),

+ 'user_yim' => array('VCHAR_UNI', ''),

+ 'user_msnm' => array('VCHAR_UNI', ''),

+ 'user_jabber' => array('VCHAR_UNI', ''),

+ 'user_website' => array('VCHAR_UNI:200', ''),

+ 'user_occ' => array('TEXT_UNI', ''),

+ 'user_interests' => array('TEXT_UNI', ''),

+ 'user_actkey' => array('VCHAR:32', ''),

+ 'user_newpasswd' => array('VCHAR_UNI:40', ''),

+ 'user_form_salt' => array('VCHAR_UNI:32', ''),

+

+ ),

+ 'PRIMARY_KEY' => 'user_id',

+ 'KEYS' => array(

+ 'user_birthday' => array('INDEX', 'user_birthday'),

+ 'user_email_hash' => array('INDEX', 'user_email_hash'),

+ 'user_type' => array('INDEX', 'user_type'),

+ 'username_clean' => array('UNIQUE', 'username_clean'),

+ ),

+ ),

+

+ $this->table_prefix . 'warnings' => array(

+ 'COLUMNS' => array(

+ 'warning_id' => array('UINT', NULL, 'auto_increment'),

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

+ 'post_id' => array('UINT', 0),

+ 'log_id' => array('UINT', 0),

+ 'warning_time' => array('TIMESTAMP', 0),

+ ),

+ 'PRIMARY_KEY' => 'warning_id',

+ ),

+

+ $this->table_prefix . 'words' => array(

+ 'COLUMNS' => array(

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

+ 'word' => array('VCHAR_UNI', ''),

+ 'replacement' => array('VCHAR_UNI', ''),

+ ),

+ 'PRIMARY_KEY' => 'word_id',

+ ),

+

+ $this->table_prefix . 'zebra' => array(

+ 'COLUMNS' => array(

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

+ 'zebra_id' => array('UINT', 0),

+ 'friend' => array('BOOL', 0),

+ 'foe' => array('BOOL', 0),

+ ),

+ 'PRIMARY_KEY' => array('user_id', 'zebra_id'),

+ ),

+ ),

+ );

+ }

+

+ public function revert_schema()

+ {

+ return array(

+ 'drop_tables' => array(

+ $this->table_prefix . 'attachments',

+ $this->table_prefix . 'acl_groups',

+ $this->table_prefix . 'acl_options',

+ $this->table_prefix . 'acl_roles',

+ $this->table_prefix . 'acl_roles_data',

+ $this->table_prefix . 'acl_users',

+ $this->table_prefix . 'banlist',

+ $this->table_prefix . 'bbcodes',

+ $this->table_prefix . 'bookmarks',

+ $this->table_prefix . 'bots',

+ $this->table_prefix . 'config',

+ $this->table_prefix . 'confirm',

+ $this->table_prefix . 'disallow',

+ $this->table_prefix . 'drafts',

+ $this->table_prefix . 'extensions',

+ $this->table_prefix . 'extension_groups',

+ $this->table_prefix . 'forums',

+ $this->table_prefix . 'forums_access',

+ $this->table_prefix . 'forums_track',

+ $this->table_prefix . 'forums_watch',

+ $this->table_prefix . 'groups',

+ $this->table_prefix . 'icons',

+ $this->table_prefix . 'lang',

+ $this->table_prefix . 'log',

+ $this->table_prefix . 'moderator_cache',

+ $this->table_prefix . 'modules',

+ $this->table_prefix . 'poll_options',

+ $this->table_prefix . 'poll_votes',

+ $this->table_prefix . 'posts',

+ $this->table_prefix . 'privmsgs',

+ $this->table_prefix . 'privmsgs_folder',

+ $this->table_prefix . 'privmsgs_rules',

+ $this->table_prefix . 'privmsgs_to',

+ $this->table_prefix . 'profile_fields',

+ $this->table_prefix . 'profile_fields_data',

+ $this->table_prefix . 'profile_fields_lang',

+ $this->table_prefix . 'profile_lang',

+ $this->table_prefix . 'ranks',

+ $this->table_prefix . 'reports',

+ $this->table_prefix . 'reports_reasons',

+ $this->table_prefix . 'search_results',

+ $this->table_prefix . 'search_wordlist',

+ $this->table_prefix . 'search_wordmatch',

+ $this->table_prefix . 'sessions',

+ $this->table_prefix . 'sessions_keys',

+ $this->table_prefix . 'sitelist',

+ $this->table_prefix . 'smilies',

+ $this->table_prefix . 'styles',

+ $this->table_prefix . 'styles_template',

+ $this->table_prefix . 'styles_template_data',

+ $this->table_prefix . 'styles_theme',

+ $this->table_prefix . 'styles_imageset',

+ $this->table_prefix . 'styles_imageset_data',

+ $this->table_prefix . 'topics',

+ $this->table_prefix . 'topics_track',

+ $this->table_prefix . 'topics_posted',

+ $this->table_prefix . 'topics_watch',

+ $this->table_prefix . 'user_group',

+ $this->table_prefix . 'users',

+ $this->table_prefix . 'warnings',

+ $this->table_prefix . 'words',

+ $this->table_prefix . 'zebra',

+ ),

+ );

+ }

+}

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+namespace phpbb\db\migration\data\v30x;

+

+class release_3_0_1 extends \phpbb\db\migration\migration

+ return array('\phpbb\db\migration\data\v30x\release_3_0_1_rc1');

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+namespace phpbb\db\migration\data\v30x;

+

+class release_3_0_10 extends \phpbb\db\migration\migration

+ return array('\phpbb\db\migration\data\v30x\release_3_0_10_rc3');

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+namespace phpbb\db\migration\data\v30x;

+

+class release_3_0_10_rc1 extends \phpbb\db\migration\migration

+ return array('\phpbb\db\migration\data\v30x\release_3_0_9');

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+namespace phpbb\db\migration\data\v30x;

+

+class release_3_0_10_rc2 extends \phpbb\db\migration\migration

+ return array('\phpbb\db\migration\data\v30x\release_3_0_10_rc1');

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+namespace phpbb\db\migration\data\v30x;

+

+class release_3_0_10_rc3 extends \phpbb\db\migration\migration

+ return array('\phpbb\db\migration\data\v30x\release_3_0_10_rc2');

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+namespace phpbb\db\migration\data\v30x;

+

+class release_3_0_11 extends \phpbb\db\migration\migration

+ return array('\phpbb\db\migration\data\v30x\release_3_0_11_rc2');

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+namespace phpbb\db\migration\data\v30x;

+

+class release_3_0_11_rc1 extends \phpbb\db\migration\migration

+ return array('\phpbb\db\migration\data\v30x\release_3_0_10');

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+namespace phpbb\db\migration\data\v30x;

+

+class release_3_0_11_rc2 extends \phpbb\db\migration\migration

+ return array('\phpbb\db\migration\data\v30x\release_3_0_11_rc1');

+<?php

+/**

+*

+* @package migration

+* @copyright (c) 2013 phpBB Group

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+*

+*/

+

+namespace phpbb\db\migration\data\v30x;

+

+class release_3_0_12 extends \phpbb\db\migration\migration

+{

+ public function effectively_installed()

+ {

+ return phpbb_version_compare($this->config['version'], '3.0.12', '>=') && phpbb_version_compare($this->config['version'], '3.1.0-dev', '<');

+ }

+

+ static public function depends_on()

+ {

+ return array('\phpbb\db\migration\data\v30x\release_3_0_12_rc3');

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('if', array(

+ phpbb_version_compare($this->config['version'], '3.0.12', '<'),

+ array('config.update', array('version', '3.0.12')),

+ )),

+ );

+ }

+}

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+namespace phpbb\db\migration\data\v30x;

+

+class release_3_0_12_rc1 extends \phpbb\db\migration\migration

+ static public function depends_on()

+ return array('\phpbb\db\migration\data\v30x\release_3_0_11');

+<?php

+/**

+*

+* @package migration

+* @copyright (c) 2013 phpBB Group

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+*

+*/

+

+namespace phpbb\db\migration\data\v30x;

+

+class release_3_0_12_rc2 extends \phpbb\db\migration\migration

+{

+ public function effectively_installed()

+ {

+ return phpbb_version_compare($this->config['version'], '3.0.12-RC2', '>=') && phpbb_version_compare($this->config['version'], '3.1.0-dev', '<');

+ }

+

+ static public function depends_on()

+ {

+ return array('\phpbb\db\migration\data\v30x\release_3_0_12_rc1');

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('if', array(

+ phpbb_version_compare($this->config['version'], '3.0.12-RC2', '<'),

+ array('config.update', array('version', '3.0.12-RC2')),

+ )),

+ );

+ }

+}

+<?php

+/**

+*

+* @package migration

+* @copyright (c) 2013 phpBB Group

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+*

+*/

+

+namespace phpbb\db\migration\data\v30x;

+

+class release_3_0_12_rc3 extends \phpbb\db\migration\migration

+{

+ public function effectively_installed()

+ {

+ return phpbb_version_compare($this->config['version'], '3.0.12-RC3', '>=') && phpbb_version_compare($this->config['version'], '3.1.0-dev', '<');

+ }

+

+ static public function depends_on()

+ {

+ return array('\phpbb\db\migration\data\v30x\release_3_0_12_rc2');

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('if', array(

+ phpbb_version_compare($this->config['version'], '3.0.12-RC3', '<'),

+ array('config.update', array('version', '3.0.12-RC3')),

+ )),

+ );

+ }

+}

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+namespace phpbb\db\migration\data\v30x;

+

+class release_3_0_1_rc1 extends \phpbb\db\migration\migration

+ static public function depends_on()

+ {

+ return array('\phpbb\db\migration\data\v30x\release_3_0_0');

+ }

+

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+namespace phpbb\db\migration\data\v30x;

+

+class release_3_0_2 extends \phpbb\db\migration\migration

+ return array('\phpbb\db\migration\data\v30x\release_3_0_2_rc2');

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+namespace phpbb\db\migration\data\v30x;

+

+class release_3_0_2_rc1 extends \phpbb\db\migration\migration

+ return array('\phpbb\db\migration\data\v30x\release_3_0_1');

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+namespace phpbb\db\migration\data\v30x;

+

+class release_3_0_2_rc2 extends \phpbb\db\migration\migration

+ return array('\phpbb\db\migration\data\v30x\release_3_0_2_rc1');

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+namespace phpbb\db\migration\data\v30x;

+

+class release_3_0_3 extends \phpbb\db\migration\migration

+ return array('\phpbb\db\migration\data\v30x\release_3_0_3_rc1');

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+namespace phpbb\db\migration\data\v30x;

+

+class release_3_0_3_rc1 extends \phpbb\db\migration\migration

+ return array('\phpbb\db\migration\data\v30x\release_3_0_2');

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+namespace phpbb\db\migration\data\v30x;

+

+class release_3_0_4 extends \phpbb\db\migration\migration

+ return array('\phpbb\db\migration\data\v30x\release_3_0_4_rc1');

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+namespace phpbb\db\migration\data\v30x;

+

+class release_3_0_4_rc1 extends \phpbb\db\migration\migration

+ return array('\phpbb\db\migration\data\v30x\release_3_0_3');

+ // Update the Custom Profile Fields based on previous settings to the new \format

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+namespace phpbb\db\migration\data\v30x;

+

+class release_3_0_5 extends \phpbb\db\migration\migration

+ return array('\phpbb\db\migration\data\v30x\release_3_0_5_rc1part2');

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+namespace phpbb\db\migration\data\v30x;

+

+class release_3_0_5_rc1 extends \phpbb\db\migration\migration

+ return array('\phpbb\db\migration\data\v30x\release_3_0_4');

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+namespace phpbb\db\migration\data\v30x;

+

+class release_3_0_5_rc1part2 extends \phpbb\db\migration\migration

+ return array('\phpbb\db\migration\data\v30x\release_3_0_5_rc1');

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+namespace phpbb\db\migration\data\v30x;

+

+class release_3_0_6 extends \phpbb\db\migration\migration

+ return array('\phpbb\db\migration\data\v30x\release_3_0_6_rc4');

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+namespace phpbb\db\migration\data\v30x;

+

+class release_3_0_6_rc1 extends \phpbb\db\migration\migration

+ return array('\phpbb\db\migration\data\v30x\release_3_0_5');

+ $auth_admin = new \auth_admin();

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+namespace phpbb\db\migration\data\v30x;

+

+class release_3_0_6_rc2 extends \phpbb\db\migration\migration

+ return array('\phpbb\db\migration\data\v30x\release_3_0_6_rc1');

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+namespace phpbb\db\migration\data\v30x;

+

+class release_3_0_6_rc3 extends \phpbb\db\migration\migration

+ return array('\phpbb\db\migration\data\v30x\release_3_0_6_rc2');

+ // Update the Custom Profile Fields based on previous settings to the new \format

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+namespace phpbb\db\migration\data\v30x;

+

+class release_3_0_6_rc4 extends \phpbb\db\migration\migration

+ return array('\phpbb\db\migration\data\v30x\release_3_0_6_rc3');

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+namespace phpbb\db\migration\data\v30x;

+

+class release_3_0_7 extends \phpbb\db\migration\migration

+ return array('\phpbb\db\migration\data\v30x\release_3_0_7_rc2');

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+namespace phpbb\db\migration\data\v30x;

+

+class release_3_0_7_pl1 extends \phpbb\db\migration\migration

+ return array('\phpbb\db\migration\data\v30x\release_3_0_7');

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+namespace phpbb\db\migration\data\v30x;

+

+class release_3_0_7_rc1 extends \phpbb\db\migration\migration

+ return array('\phpbb\db\migration\data\v30x\release_3_0_6');

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+namespace phpbb\db\migration\data\v30x;

+

+class release_3_0_7_rc2 extends \phpbb\db\migration\migration

+ return array('\phpbb\db\migration\data\v30x\release_3_0_7_rc1');

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+namespace phpbb\db\migration\data\v30x;

+

+class release_3_0_8 extends \phpbb\db\migration\migration

+ return array('\phpbb\db\migration\data\v30x\release_3_0_8_rc1');

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+namespace phpbb\db\migration\data\v30x;

+

+class release_3_0_8_rc1 extends \phpbb\db\migration\migration

+ return array('\phpbb\db\migration\data\v30x\release_3_0_7_pl1');

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+namespace phpbb\db\migration\data\v30x;

+

+class release_3_0_9 extends \phpbb\db\migration\migration

+ return array('\phpbb\db\migration\data\v30x\release_3_0_9_rc4');

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+namespace phpbb\db\migration\data\v30x;

+

+class release_3_0_9_rc1 extends \phpbb\db\migration\migration

+ return array('\phpbb\db\migration\data\v30x\release_3_0_8');

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+namespace phpbb\db\migration\data\v30x;

+

+class release_3_0_9_rc2 extends \phpbb\db\migration\migration

+ return array('\phpbb\db\migration\data\v30x\release_3_0_9_rc1');

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+namespace phpbb\db\migration\data\v30x;

+

+class release_3_0_9_rc3 extends \phpbb\db\migration\migration

+ return array('\phpbb\db\migration\data\v30x\release_3_0_9_rc2');

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+namespace phpbb\db\migration\data\v30x;

+

+class release_3_0_9_rc4 extends \phpbb\db\migration\migration

+ return array('\phpbb\db\migration\data\v30x\release_3_0_9_rc3');

+<?php

+/**

+*

+* @package migration

+* @copyright (c) 2014 phpBB Group

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+*

+*/

+

+namespace phpbb\db\migration\data\v310;

+

+class acp_prune_users_module extends \phpbb\db\migration\migration

+{

+ public function effectively_installed()

+ {

+ $sql = 'SELECT module_id

+ FROM ' . MODULES_TABLE . "

+ WHERE module_class = 'acp'

+ AND module_langname = 'ACP_CAT_USERS'";

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

+ $acp_cat_users_id = (int) $this->db->sql_fetchfield('module_id');

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

+

+ $sql = 'SELECT parent_id

+ FROM ' . MODULES_TABLE . "

+ WHERE module_class = 'acp'

+ AND module_basename = 'acp_prune'

+ AND module_mode = 'users'";

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

+ $acp_prune_users_parent = (int) $this->db->sql_fetchfield('parent_id');

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

+

+ // Skip migration if "Users" category has been deleted

+ // or the module has already been moved to that category

+ return !$acp_cat_users_id || $acp_cat_users_id === $acp_prune_users_parent;

+ }

+

+ static public function depends_on()

+ {

+ return array('\phpbb\db\migration\data\v310\beta1');

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('custom', array(array($this, 'move_prune_users_module'))),

+ );

+ }

+

+ public function move_prune_users_module()

+ {

+ $sql = 'SELECT module_id

+ FROM ' . MODULES_TABLE . "

+ WHERE module_class = 'acp'

+ AND module_basename = 'acp_prune'

+ AND module_mode = 'users'";

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

+ $acp_prune_users_id = (int) $this->db->sql_fetchfield('module_id');

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

+

+ $sql = 'SELECT module_id

+ FROM ' . MODULES_TABLE . "

+ WHERE module_class = 'acp'

+ AND module_langname = 'ACP_CAT_USERS'";

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

+ $acp_cat_users_id = (int) $this->db->sql_fetchfield('module_id');

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

+

+ if (!class_exists('\acp_modules'))

+ {

+ include($this->phpbb_root_path . 'includes/acp/acp_modules.' . $this->php_ext);

+ }

+ $module_manager = new \acp_modules();

+ $module_manager->module_class = 'acp';

+ $module_manager->move_module($acp_prune_users_id, $acp_cat_users_id);

+ }

+}

+<?php

+/**

+*

+* @package migration

+* @copyright (c) 2013 phpBB Group

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+*

+*/

+

+namespace phpbb\db\migration\data\v310;

+

+class acp_style_components_module extends \phpbb\db\migration\migration

+{

+ public function effectively_installed()

+ {

+ $sql = 'SELECT module_id

+ FROM ' . MODULES_TABLE . "

+ WHERE module_class = 'acp'

+ AND module_langname = 'ACP_STYLE_COMPONENTS'";

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

+ $module_id = $this->db->sql_fetchfield('module_id');

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

+

+ return $module_id == false;

+ }

+

+ static public function depends_on()

+ {

+ return array('\phpbb\db\migration\data\v310\dev');

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('module.remove', array(

+ 'acp',

+ false,

+ 'ACP_STYLE_COMPONENTS',

+ )),

+ );

+ }

+}

+<?php

+/**

+*

+* @package migration

+* @copyright (c) 2013 phpBB Group

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+*

+*/

+

+namespace phpbb\db\migration\data\v310;

+

+class allow_cdn extends \phpbb\db\migration\migration

+{

+ public function effectively_installed()

+ {

+ return isset($this->config['allow_cdn']);

+ }

+

+ static public function depends_on()

+ {

+ return array(

+ '\phpbb\db\migration\data\v310\jquery_update',

+ );

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('config.add', array('allow_cdn', (int) $this->config['load_jquery_cdn'])),

+ array('config.remove', array('load_jquery_cdn')),

+ );

+ }

+}

+<?php

+/**

+*

+* @package migration

+* @copyright (c) 2013 phpBB Group

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+*

+*/

+

+namespace phpbb\db\migration\data\v310;

+

+class alpha1 extends \phpbb\db\migration\migration

+{

+ static public function depends_on()

+ {

+ return array(

+ '\phpbb\db\migration\data\v30x\local_url_bbcode',

+ '\phpbb\db\migration\data\v30x\release_3_0_12',

+ '\phpbb\db\migration\data\v310\acp_style_components_module',

+ '\phpbb\db\migration\data\v310\allow_cdn',

+ '\phpbb\db\migration\data\v310\auth_provider_oauth',

+ '\phpbb\db\migration\data\v310\avatars',

+ '\phpbb\db\migration\data\v310\boardindex',

+ '\phpbb\db\migration\data\v310\config_db_text',

+ '\phpbb\db\migration\data\v310\forgot_password',

+ '\phpbb\db\migration\data\v310\mod_rewrite',

+ '\phpbb\db\migration\data\v310\mysql_fulltext_drop',

+ '\phpbb\db\migration\data\v310\namespaces',

+ '\phpbb\db\migration\data\v310\notifications_cron',

+ '\phpbb\db\migration\data\v310\notification_options_reconvert',

+ '\phpbb\db\migration\data\v310\plupload',

+ '\phpbb\db\migration\data\v310\signature_module_auth',

+ '\phpbb\db\migration\data\v310\softdelete_mcp_modules',

+ '\phpbb\db\migration\data\v310\teampage',

+ );

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('config.update', array('version', '3.1.0-a1')),

+ );

+ }

+}

+<?php

+/**

+*

+* @package migration

+* @copyright (c) 2013 phpBB Group

+* @license http://opensource.org/licenses/gpl-2.0.php GNU Public License v2

+*

+*/

+

+namespace phpbb\db\migration\data\v310;

+

+class alpha2 extends \phpbb\db\migration\migration

+{

+ static public function depends_on()

+ {

+ return array(

+ '\phpbb\db\migration\data\v310\alpha1',

+ '\phpbb\db\migration\data\v310\notifications_cron_p2',

+ );

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('config.update', array('version', '3.1.0-a2')),

+ );

+ }

+}

+<?php

+/**

+*

+* @package migration

+* @copyright (c) 2014 phpBB Group

+* @license http://opensource.org/licenses/gpl-2.0.php GNU Public License v2

+*

+*/

+

+namespace phpbb\db\migration\data\v310;

+

+class alpha3 extends \phpbb\db\migration\migration

+{

+ static public function depends_on()

+ {

+ return array(

+ '\phpbb\db\migration\data\v310\alpha2',

+ '\phpbb\db\migration\data\v310\avatar_types',

+ '\phpbb\db\migration\data\v310\passwords',

+ '\phpbb\db\migration\data\v310\profilefield_types',

+ );

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('config.update', array('version', '3.1.0-a3')),

+ );

+ }

+}

+<?php

+/**

+*

+* @package migration

+* @copyright (c) 2013 phpBB Group

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+*

+*/

+

+namespace phpbb\db\migration\data\v310;

+

+class auth_provider_oauth extends \phpbb\db\migration\migration

+{

+ public function effectively_installed()

+ {

+ return $this->db_tools->sql_table_exists($this->table_prefix . 'auth_provider_oauth');

+ }

+

+ public function update_schema()

+ {

+ return array(

+ 'add_tables' => array(

+ $this->table_prefix . 'oauth_tokens' => array(

+ 'COLUMNS' => array(

+ 'user_id' => array('UINT', 0), // phpbb_users.user_id

+ 'session_id' => array('CHAR:32', ''), // phpbb_sessions.session_id used only when user_id not set

+ 'provider' => array('VCHAR', ''), // Name of the OAuth provider

+ 'oauth_token' => array('MTEXT', ''), // Serialized token

+ ),

+ 'KEYS' => array(

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

+ 'provider' => array('INDEX', 'provider'),

+ ),

+ ),

+ $this->table_prefix . 'oauth_accounts' => array(

+ 'COLUMNS' => array(

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

+ 'provider' => array('VCHAR', ''),

+ 'oauth_provider_id' => array('TEXT_UNI', ''),

+ ),

+ 'PRIMARY_KEY' => array(

+ 'user_id',

+ 'provider',

+ ),

+ ),

+ ),

+ );

+ }

+

+ public function revert_schema()

+ {

+ return array(

+ 'drop_tables' => array(

+ $this->table_prefix . 'oauth_tokens',

+ $this->table_prefix . 'oauth_accounts',

+ ),

+ );

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('module.add', array(

+ 'ucp',

+ 'UCP_PROFILE',

+ array(

+ 'module_basename' => 'ucp_auth_link',

+ 'modes' => array('auth_link'),

+ ),

+ )),

+ );

+ }

+}

+<?php

+/**

+*

+* @package migration

+* @copyright (c) 2014 phpBB Group

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+*

+*/

+

+namespace phpbb\db\migration\data\v310;

+

+class auth_provider_oauth2 extends \phpbb\db\migration\migration

+{

+ static public function depends_on()

+ {

+ return array(

+ '\phpbb\db\migration\data\v310\auth_provider_oauth',

+ );

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('custom', array(

+ array($this, 'update_auth_link_module_auth'),

+ )),

+ );

+ }

+

+ public function update_auth_link_module_auth()

+ {

+ $sql = 'UPDATE ' . MODULES_TABLE . "

+ SET module_auth = 'authmethod_oauth'

+ WHERE module_class = 'ucp'

+ AND module_basename = 'ucp_auth_link'

+ AND module_mode = 'auth_link'

+ AND module_auth = ''";

+ $this->db->sql_query($sql);

+ }

+}

+<?php

+/**

+*

+* @package migration

+* @copyright (c) 2013 phpBB Group

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+*

+*/

+

+namespace phpbb\db\migration\data\v310;

+

+class avatar_types extends \phpbb\db\migration\migration

+{

+ /**

+ * @var avatar type map

+ */

+ protected $avatar_type_map = array(

+ AVATAR_UPLOAD => 'avatar.driver.upload',

+ AVATAR_REMOTE => 'avatar.driver.remote',

+ AVATAR_GALLERY => 'avatar.driver.local',

+ );

+

+ static public function depends_on()

+ {

+ return array(

+ '\phpbb\db\migration\data\v310\dev',

+ '\phpbb\db\migration\data\v310\avatars',

+ );

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('custom', array(array($this, 'update_user_avatar_type'))),

+ array('custom', array(array($this, 'update_group_avatar_type'))),

+ );

+ }

+

+ public function update_user_avatar_type()

+ {

+ foreach ($this->avatar_type_map as $old => $new)

+ {

+ $sql = 'UPDATE ' . $this->table_prefix . "users

+ SET user_avatar_type = '$new'

+ WHERE user_avatar_type = '$old'";

+ $this->db->sql_query($sql);

+ }

+ }

+

+ public function update_group_avatar_type()

+ {

+ foreach ($this->avatar_type_map as $old => $new)

+ {

+ $sql = 'UPDATE ' . $this->table_prefix . "groups

+ SET group_avatar_type = '$new'

+ WHERE group_avatar_type = '$old'";

+ $this->db->sql_query($sql);

+ }

+ }

+}

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+namespace phpbb\db\migration\data\v310;

+

+class avatars extends \phpbb\db\migration\migration

+ return array('\phpbb\db\migration\data\v30x\release_3_0_11');

+<?php

+/**

+*

+* @package migration

+* @copyright (c) 2014 phpBB Group

+* @license http://opensource.org/licenses/gpl-2.0.php GNU Public License v2

+*

+*/

+

+namespace phpbb\db\migration\data\v310;

+

+class beta1 extends \phpbb\db\migration\migration

+{

+ static public function depends_on()

+ {

+ return array(

+ '\phpbb\db\migration\data\v310\alpha3',

+ '\phpbb\db\migration\data\v310\passwords_p2',

+ '\phpbb\db\migration\data\v310\postgres_fulltext_drop',

+ '\phpbb\db\migration\data\v310\profilefield_change_load_settings',

+ '\phpbb\db\migration\data\v310\profilefield_location',

+ '\phpbb\db\migration\data\v310\soft_delete_mod_convert2',

+ '\phpbb\db\migration\data\v310\ucp_popuppm_module',

+ );

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('config.update', array('version', '3.1.0-b1')),

+ );

+ }

+}

+<?php

+/**

+*

+* @package migration

+* @copyright (c) 2014 phpBB Group

+* @license http://opensource.org/licenses/gpl-2.0.php GNU Public License v2

+*

+*/

+

+namespace phpbb\db\migration\data\v310;

+

+class beta2 extends \phpbb\db\migration\migration

+{

+ static public function depends_on()

+ {

+ return array(

+ '\phpbb\db\migration\data\v310\beta1',

+ '\phpbb\db\migration\data\v310\acp_prune_users_module',

+ '\phpbb\db\migration\data\v310\profilefield_location_cleanup',

+ );

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('config.update', array('version', '3.1.0-b2')),

+ );

+ }

+}

+<?php

+/**

+*

+* @package migration

+* @copyright (c) 2014 phpBB Group

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+*

+*/

+

+namespace phpbb\db\migration\data\v310;

+

+class board_contact_name extends \phpbb\db\migration\migration

+{

+ public function effectively_installed()

+ {

+ return isset($this->config['board_contact_name']);

+ }

+

+ static public function depends_on()

+ {

+ return array('\phpbb\db\migration\data\v310\beta2');

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('config.add', array('board_contact_name', '')),

+ );

+ }

+}

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+namespace phpbb\db\migration\data\v310;

+

+class boardindex extends \phpbb\db\migration\migration

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+namespace phpbb\db\migration\data\v310;

+

+class config_db_text extends \phpbb\db\migration\migration

+ return array('\phpbb\db\migration\data\v30x\release_3_0_11');

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+namespace phpbb\db\migration\data\v310;

+

+class dev extends \phpbb\db\migration\migration

+ '\phpbb\db\migration\data\v310\extensions',

+ '\phpbb\db\migration\data\v310\style_update_p2',

+ '\phpbb\db\migration\data\v310\timezone_p2',

+ '\phpbb\db\migration\data\v310\reported_posts_display',

+ '\phpbb\db\migration\data\v310\migrations_table',

+ $module_manager = new \acp_modules();

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+namespace phpbb\db\migration\data\v310;

+

+class extensions extends \phpbb\db\migration\migration

+ return array('\phpbb\db\migration\data\v30x\release_3_0_11');

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+namespace phpbb\db\migration\data\v310;

+

+class forgot_password extends \phpbb\db\migration\migration

+ return array('\phpbb\db\migration\data\v30x\release_3_0_11');

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+namespace phpbb\db\migration\data\v310;

+

+class jquery_update extends \phpbb\db\migration\migration

+ '\phpbb\db\migration\data\v310\dev',

+<?php

+/**

+*

+* @package migration

+* @copyright (c) 2014 phpBB Group

+* @license http://opensource.org/licenses/gpl-2.0.php GNU Public License v2

+*

+*/

+

+namespace phpbb\db\migration\data\v310;

+

+class jquery_update2 extends \phpbb\db\migration\migration

+{

+ public function effectively_installed()

+ {

+ return $this->config['load_jquery_url'] !== '//ajax.googleapis.com/ajax/libs/jquery/1.8.3/jquery.min.js';

+ }

+

+ static public function depends_on()

+ {

+ return array(

+ '\phpbb\db\migration\data\v310\jquery_update',

+ );

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('config.update', array('load_jquery_url', '//ajax.googleapis.com/ajax/libs/jquery/1.11.0/jquery.min.js')),

+ );

+ }

+

+}

+<?php

+/**

+*

+* @package migration

+* @copyright (c) 2014 phpBB Group

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+*

+*/

+

+namespace phpbb\db\migration\data\v310;

+

+class migrations_table extends \phpbb\db\migration\migration

+{

+ public function effectively_installed()

+ {

+ return $this->db_tools->sql_table_exists($this->table_prefix . 'migrations');

+ }

+

+ public function update_schema()

+ {

+ return array(

+ 'add_tables' => array(

+ $this->table_prefix . 'migrations' => array(

+ 'COLUMNS' => array(

+ 'migration_name' => array('VCHAR', ''),

+ 'migration_depends_on' => array('TEXT', ''),

+ 'migration_schema_done' => array('BOOL', 0),

+ 'migration_data_done' => array('BOOL', 0),

+ 'migration_data_state' => array('TEXT', ''),

+ 'migration_start_time' => array('TIMESTAMP', 0),

+ 'migration_end_time' => array('TIMESTAMP', 0),

+ ),

+ 'PRIMARY_KEY' => 'migration_name',

+ ),

+ ),

+ );

+ }

+

+ public function revert_schema()

+ {

+ return array(

+ 'drop_tables' => array(

+ $this->table_prefix . 'migrations',

+ ),

+ );

+ }

+}

+<?php

+/**

+*

+* @package migration

+* @copyright (c) 2013 phpBB Group

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+*

+*/

+

+namespace phpbb\db\migration\data\v310;

+

+class mod_rewrite extends \phpbb\db\migration\migration

+{

+ static public function depends_on()

+ {

+ return array(

+ '\phpbb\db\migration\data\v310\dev',

+ );

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('config.add', array('enable_mod_rewrite', '0')),

+ );

+ }

+}

+<?php

+/**

+*

+* @package migration

+* @copyright (c) 2013 phpBB Group

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+*

+*/

+

+namespace phpbb\db\migration\data\v310;

+

+class mysql_fulltext_drop extends \phpbb\db\migration\migration

+{

+ public function effectively_installed()

+ {

+ // This migration is irrelevant for all non-MySQL DBMSes.

+ return strpos($this->db->sql_layer, 'mysql') === false;

+ }

+

+ static public function depends_on()

+ {

+ return array(

+ '\phpbb\db\migration\data\v310\dev',

+ );

+ }

+

+ public function update_schema()

+ {

+ /*

+ * Drop FULLTEXT indexes related to MySQL fulltext search.

+ * Doing so is equivalent to dropping the search index from the ACP.

+ * Possibly time-consuming recreation of the search index (i.e.

+ * FULLTEXT indexes) is left as a task to the admin to not

+ * unnecessarily stall the upgrade process. The new search index will

+ * then require about 40% less table space (also see PHPBB3-11621).

+ */

+ return array(

+ 'drop_keys' => array(

+ $this->table_prefix . 'posts' => array(

+ 'post_subject',

+ 'post_text',

+ 'post_content',

+ ),

+ ),

+ );

+ }

+}

+<?php

+/**

+*

+* @package migration

+* @copyright (c) 2012 phpBB Group

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+*

+*/

+

+namespace phpbb\db\migration\data\v310;

+

+class namespaces extends \phpbb\db\migration\migration

+{

+ static public function depends_on()

+ {

+ return array(

+ '\phpbb\db\migration\data\v310\dev',

+ );

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('if', array(

+ (preg_match('#^phpbb_search_#', $this->config['search_type'])),

+ array('config.update', array('search_type', str_replace('phpbb_search_', '\\phpbb\\search\\', $this->config['search_type']))),

+ )),

+ );

+ }

+}

+namespace phpbb\db\migration\data\v310;

+

+class notification_options_reconvert extends \phpbb\db\migration\migration

+ return array('\phpbb\db\migration\data\v310\notifications_schema_fix');

+ array('custom', array(array($this, 'purge_notifications'))),

+ public function purge_notifications()

+ {

+ $sql = 'DELETE FROM ' . $this->table_prefix . 'user_notifications';

+ $this->sql_query($sql);

+ }

+

+ public function convert_notifications($start)

+ $insert_buffer = new \phpbb\db\sql_insert_buffer($this->db, $this->table_prefix . 'user_notifications');

+ return $this->perform_conversion($insert_buffer, $start);

+ * @param \phpbb\db\sql_insert_buffer $insert_buffer

+ * @param int $start Start of staggering step

+ * @return mixed int start of the next step, null if the end was reached

+ public function perform_conversion(\phpbb\db\sql_insert_buffer $insert_buffer, $start)

+ $limit = 250;

+ $converted_users = 0;

+ FROM ' . $this->table_prefix . 'users

+ ORDER BY user_id';

+ $result = $this->db->sql_query_limit($sql, $limit, $start);

+ $converted_users++;

+

+ if ($converted_users < $limit)

+ {

+ // No more users left, we are done...

+ return;

+ }

+

+ return $start + $limit;

+ * @param \phpbb\db\sql_insert_buffer $insert_buffer

+ protected function add_method_rows(\phpbb\db\sql_insert_buffer $insert_buffer, $item_type, $item_id, $user_id, array $methods)

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+namespace phpbb\db\migration\data\v310;

+

+class notifications extends \phpbb\db\migration\migration

+ return array('\phpbb\db\migration\data\v310\dev');

+ 'notification_id' => array('UINT', null, 'auto_increment'),

+<?php

+/**

+*

+* @package migration

+* @copyright (c) 2013 phpBB Group

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+*

+*/

+

+namespace phpbb\db\migration\data\v310;

+

+class notifications_cron extends \phpbb\db\migration\migration

+{

+ static public function depends_on()

+ {

+ return array('\phpbb\db\migration\data\v310\notifications');

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('config.add', array('read_notification_expire_days', 30)),

+ array('config.add', array('read_notification_last_gc', 0)), // last run

+ array('config.add', array('read_notification_gc', (60 * 60 * 24))), // seconds between run; 1 day

+ );

+ }

+}

+<?php

+/**

+*

+* @package migration

+* @copyright (c) 2013 phpBB Group

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+*

+*/

+

+namespace phpbb\db\migration\data\v310;

+

+class notifications_cron_p2 extends \phpbb\db\migration\migration

+{

+ static public function depends_on()

+ {

+ return array('\phpbb\db\migration\data\v310\notifications_cron');

+ }

+

+ public function update_data()

+ {

+ return array(

+ // Make read_notification_last_gc dynamic.

+ array('config.remove', array('read_notification_last_gc')),

+ array('config.add', array('read_notification_last_gc', 0, 1)),

+ );

+ }

+}

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+namespace phpbb\db\migration\data\v310;

+

+class notifications_schema_fix extends \phpbb\db\migration\migration

+ return array('\phpbb\db\migration\data\v310\notifications');

+ 'notification_type_id' => array('USINT', null, 'auto_increment'),

+ 'notification_id' => array('UINT:10', null, 'auto_increment'),

+ 'notification_id' => array('UINT', null, 'auto_increment'),

+<?php

+/**

+*

+* @package migration

+* @copyright (c) 2013 phpBB Group

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+*

+*/

+

+namespace phpbb\db\migration\data\v310;

+

+class passwords extends \phpbb\db\migration\migration

+{

+ static public function depends_on()

+ {

+ return array('\phpbb\db\migration\data\v30x\release_3_0_11');

+ }

+

+ public function update_schema()

+ {

+ return array(

+ 'change_columns' => array(

+ $this->table_prefix . 'users' => array(

+ 'user_password' => array('VCHAR:255', ''),

+ ),

+ $this->table_prefix . 'forums' => array(

+ 'forum_password' => array('VCHAR:255', ''),

+ ),

+ ),

+ );

+ }

+

+ public function revert_schema()

+ {

+ return array(

+ 'change_columns' => array(

+ $this->table_prefix . 'users' => array(

+ 'user_password' => array('VCHAR:40', ''),

+ ),

+ $this->table_prefix . 'forums' => array(

+ 'forum_password' => array('VCHAR:40', ''),

+ ),

+ ),

+ );

+ }

+}

+<?php

+/**

+*

+* @package migration

+* @copyright (c) 2014 phpBB Group

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+*

+*/

+

+namespace phpbb\db\migration\data\v310;

+

+class passwords_p2 extends \phpbb\db\migration\migration

+{

+ static public function depends_on()

+ {

+ return array('\phpbb\db\migration\data\v310\passwords');

+ }

+

+ public function update_schema()

+ {

+ return array(

+ 'change_columns' => array(

+ $this->table_prefix . 'users' => array(

+ 'user_newpasswd' => array('VCHAR:255', ''),

+ ),

+ ),

+ );

+ }

+

+ public function revert_schema()

+ {

+ return array(

+ 'change_columns' => array(

+ $this->table_prefix . 'users' => array(

+ 'user_newpasswd' => array('VCHAR:40', ''),

+ ),

+ ),

+ );

+ }

+}

+<?php

+/**

+*

+* @package migration

+* @copyright (c) 2013 phpBB Group

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+*

+*/

+

+namespace phpbb\db\migration\data\v310;

+

+class plupload extends \phpbb\db\migration\migration

+{

+ public function effectively_installed()

+ {

+ return isset($this->config['plupload_last_gc']) &&

+ isset($this->config['plupload_salt']);

+ }

+

+ static public function depends_on()

+ {

+ return array('\phpbb\db\migration\data\v310\dev');

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('config.add', array('plupload_last_gc', 0)),

+ array('config.add', array('plupload_salt', unique_id())),

+ );

+ }

+}

+<?php

+/**

+*

+* @package migration

+* @copyright (c) 2013 phpBB Group

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+*

+*/

+

+namespace phpbb\db\migration\data\v310;

+

+class postgres_fulltext_drop extends \phpbb\db\migration\migration

+{

+ public function effectively_installed()

+ {

+ // This migration is irrelevant for all non-PostgreSQL DBMSes.

+ return strpos($this->db->sql_layer, 'postgres') === false;

+ }

+

+ static public function depends_on()

+ {

+ return array(

+ '\phpbb\db\migration\data\v310\dev',

+ );

+ }

+

+ public function update_schema()

+ {

+ /*

+ * Drop FULLTEXT indexes related to PostgreSQL fulltext search.

+ * Doing so is equivalent to dropping the search index from the ACP.

+ * Possibly time-consuming recreation of the search index (i.e.

+ * FULLTEXT indexes) is left as a task to the admin to not

+ * unnecessarily stall the upgrade process. The new search index will

+ * then require about 40% less table space (also see PHPBB3-11040).

+ */

+ return array(

+ 'drop_keys' => array(

+ $this->table_prefix . 'posts' => array(

+ 'post_subject',

+ 'post_text',

+ 'post_content',

+ ),

+ ),

+ );

+ }

+}

+<?php

+/**

+*

+* @package migration

+* @copyright (c) 2014 phpBB Group

+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+*

+*/

+

+namespace phpbb\db\migration\data\v310;

+

+class profilefield_aol extends \phpbb\db\migration\profilefield_base_migration

+{

+ static public function depends_on()

+ {

+ return array(

+ '\phpbb\db\migration\data\v310\profilefield_yahoo_cleanup',

+ );

+ }

+

+ protected $profilefield_name = 'phpbb_aol';

+

+ protected $profilefield_database_type = array('VCHAR', '');

+

+ protected $profilefield_data = array(

+ 'field_name' => 'phpbb_aol',

+ 'field_type' => 'profilefields.type.string',

+ 'field_ident' => 'phpbb_aol',

+ 'field_length' => '40',

+ 'field_minlen' => '5',

+ 'field_maxlen' => '255',

+ 'field_novalue' => '',

+ 'field_default_value' => '',

+ 'field_validation' => '.*',

+ 'field_required' => 0,

+ 'field_show_novalue' => 0,

+ 'field_show_on_reg' => 0,

+ 'field_show_on_pm' => 1,