+abstract class driver implements driver_interface

+ * {@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}

+ * {@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);

+}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@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;

+

+/**

+* SQLite3 Database Abstraction Layer

+* Minimum Requirement: 3.6.15+

+* @package dbal

+*/

+class sqlite3 extends \phpbb\db\driver\driver

+{

+ /**

+ * @var string Stores errors during connection setup in case the driver is not available

+ */

+ protected $connect_error = '';

+

+ /**

+ * @var \SQLite3 The SQLite3 database object to operate against

+ */

+ protected $dbo = null;

+

+ /**

+ * {@inheritDoc}

+ */

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

+ {

+ $this->persistency = false;

+ $this->user = $sqluser;

+ $this->server = $sqlserver . (($port) ? ':' . $port : '');

+ $this->dbname = $database;

+

+ if (!class_exists('SQLite3', false))

+ {

+ $this->connect_error = 'SQLite3 not found, is the extension installed?';

+ return $this->sql_error('');

+ }

+

+ try

+ {

+ $this->dbo = new \SQLite3($this->server, SQLITE3_OPEN_READWRITE | SQLITE3_OPEN_CREATE);

+ $this->db_connect_id = true;

+ }

+ catch (Exception $e)

+ {

+ return array('message' => $e->getMessage());

+ }

+

+ return true;

+ }

+

+ /**

+ * {@inheritDoc}

+ */

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

+ {

+ global $cache;

+

+ if (!$use_cache || empty($cache) || ($this->sql_server_version = $cache->get('sqlite_version')) === false)

+ {

+ $version = \SQLite3::version();

+

+ $this->sql_server_version = $version['versionString'];

+

+ if (!empty($cache) && $use_cache)

+ {

+ $cache->put('sqlite_version', $this->sql_server_version);

+ }

+ }

+

+ return ($raw) ? $this->sql_server_version : 'SQLite ' . $this->sql_server_version;

+ }

+

+ /**

+ * SQL Transaction

+ *

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

+ * begin, commit, rollback

+ * @return bool Success/failure of the transaction query

+ */

+ protected function _sql_transaction($status = 'begin')

+ {

+ switch ($status)

+ {

+ case 'begin':

+ return $this->dbo->exec('BEGIN IMMEDIATE');

+ break;

+

+ case 'commit':

+ return $this->dbo->exec('COMMIT');

+ break;

+

+ case 'rollback':

+ return $this->dbo->exec('ROLLBACK');

+ break;

+ }

+

+ return true;

+ }

+

+ /**

+ * {@inheritDoc}

+ */

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

+ {

+ if ($query != '')

+ {

+ global $cache;

+

+ // EXPLAIN only in extra debug mode

+ if (defined('DEBUG'))

+ {

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

+ }

+

+ $this->last_query_text = $query;

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

+ $this->sql_add_num_queries($this->query_result);

+

+ if ($this->query_result === false)

+ {

+ if (($this->query_result = @$this->dbo->query($query)) === false)

+ {

+ $this->sql_error($query);

+ }

+

+ if (defined('DEBUG'))

+ {

+ $this->sql_report('stop', $query);

+ }

+

+ if ($cache && $cache_ttl)

+ {

+ $this->query_result = $cache->sql_save($this, $query, $this->query_result, $cache_ttl);

+ }

+ }

+ else if (defined('DEBUG'))

+ {

+ $this->sql_report('fromcache', $query);

+ }

+ }

+ else

+ {

+ return false;

+ }

+

+ return $this->query_result;

+ }

+

+ /**

+ * 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

+ */

+ protected function _sql_query_limit($query, $total, $offset = 0, $cache_ttl = 0)

+ {

+ $this->query_result = false;

+

+ // if $total is set to 0 we do not want to limit the number of rows

+ if ($total == 0)

+ {

+ $total = -1;

+ }

+

+ $query .= "\n LIMIT " . ((!empty($offset)) ? $offset . ', ' . $total : $total);

+

+ return $this->sql_query($query, $cache_ttl);

+ }

+

+ /**

+ * {@inheritDoc}

+ */

+ public function sql_affectedrows()

+ {

+ return ($this->db_connect_id) ? $this->dbo->changes() : false;

+ }

+

+ /**

+ * {@inheritDoc}

+ */

+ public function sql_fetchrow($query_id = false)

+ {

+ global $cache;

+

+ if ($query_id === false)

+ {

+ $query_id = $this->query_result;

+ }

+

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

+ {

+ return $cache->sql_fetchrow($query_id);

+ }

+

+ return is_object($query_id) ? $query_id->fetchArray(SQLITE3_ASSOC) : false;

+ }

+

+ /**

+ * {@inheritDoc}

+ */

+ public function sql_nextid()

+ {

+ return ($this->db_connect_id) ? $this->dbo->lastInsertRowID() : false;

+ }

+

+ /**

+ * {@inheritDoc}

+ */

+ public function sql_freeresult($query_id = false)

+ {

+ global $cache;

+

+ if ($query_id === false)

+ {

+ $query_id = $this->query_result;

+ }

+

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

+ {

+ return $cache->sql_freeresult($query_id);

+ }

+

+ if ($query_id)

+ {

+ return @$query_id->finalize();

+ }

+ }

+

+ /**

+ * {@inheritDoc}

+ */

+ public function sql_escape($msg)

+ {

+ return \SQLite3::escapeString($msg);

+ }

+

+ /**

+ * {@inheritDoc}

+ *

+ * For SQLite an underscore is a not-known character...

+ */

+ public function sql_like_expression($expression)

+ {

+ // Unlike LIKE, GLOB is case sensitive (unfortunatly). SQLite users need to live with it!

+ // We only catch * and ? here, not the character map possible on file globbing.

+ $expression = str_replace(array(chr(0) . '_', chr(0) . '%'), array(chr(0) . '?', chr(0) . '*'), $expression);

+

+ $expression = str_replace(array('?', '*'), array("\?", "\*"), $expression);

+ $expression = str_replace(array(chr(0) . "\?", chr(0) . "\*"), array('?', '*'), $expression);

+

+ return 'GLOB \'' . $this->sql_escape($expression) . '\'';

+ }

+

+ /**

+ * return sql error array

+ *

+ * @return array

+ */

+ protected function _sql_error()

+ {

+ if (class_exists('SQLite3', false))

+ {

+ $error = array(

+ 'message' => $this->dbo->lastErrorMsg(),

+ 'code' => $this->dbo->lastErrorCode(),

+ );

+ }

+ else

+ {

+ $error = array(

+ 'message' => $this->connect_error,

+ 'code' => '',

+ );

+ }

+

+ return $error;

+ }

+

+ /**

+ * Build db-specific query data

+ *

+ * @param string $stage Available stages: FROM, WHERE

+ * @param mixed $data A string containing the CROSS JOIN query or an array of WHERE clauses

+ *

+ * @return string The db-specific query fragment

+ */

+ protected function _sql_custom_build($stage, $data)

+ {

+ return $data;

+ }

+

+ /**

+ * Close sql connection

+ *

+ * @return bool False if failure

+ */

+ protected function _sql_close()

+ {

+ return $this->dbo->close();

+ }

+

+ /**

+ * Build db-specific report

+ *

+ * @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

+ */

+ protected function _sql_report($mode, $query = '')

+ {

+ switch ($mode)

+ {

+ case 'start':

+

+ $explain_query = $query;

+ if (preg_match('/UPDATE ([a-z0-9_]+).*?WHERE(.*)/s', $query, $m))

+ {

+ $explain_query = 'SELECT * FROM ' . $m[1] . ' WHERE ' . $m[2];

+ }

+ else if (preg_match('/DELETE FROM ([a-z0-9_]+).*?WHERE(.*)/s', $query, $m))

+ {

+ $explain_query = 'SELECT * FROM ' . $m[1] . ' WHERE ' . $m[2];

+ }

+

+ if (preg_match('/^SELECT/', $explain_query))

+ {

+ $html_table = false;

+

+ if ($result = $this->dbo->query("EXPLAIN QUERY PLAN $explain_query"))

+ {

+ while ($row = $result->fetchArray(SQLITE3_ASSOC))

+ {

+ $html_table = $this->sql_report('add_select_row', $query, $html_table, $row);

+ }

+ }

+

+ if ($html_table)

+ {

+ $this->html_hold .= '</table>';

+ }

+ }

+

+ break;

+

+ case 'fromcache':

+ $endtime = explode(' ', microtime());

+ $endtime = $endtime[0] + $endtime[1];

+

+ $result = $this->dbo->query($query);

+ while ($void = $result->fetchArray(SQLITE3_ASSOC))

+ {

+ // Take the time spent on parsing rows into account

+ }

+

+ $splittime = explode(' ', microtime());

+ $splittime = $splittime[0] + $splittime[1];

+

+ $this->sql_report('record_fromcache', $query, $endtime, $splittime);

+

+ break;

+ }

+ }

+}

+<?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

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

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

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

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

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

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

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

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

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

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

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

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

+ 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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

+<?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);

+ }

+}

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

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

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

+<?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);

+ }

+}

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

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

+<?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 Public License v2

+*

+*/

+

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

+

+class beta3 extends \phpbb\db\migration\migration

+{

+ static public function depends_on()

+ {

+ return array(

+ '\phpbb\db\migration\data\v310\beta2',

+ '\phpbb\db\migration\data\v310\auth_provider_oauth2',

+ '\phpbb\db\migration\data\v310\board_contact_name',

+ '\phpbb\db\migration\data\v310\jquery_update2',

+ '\phpbb\db\migration\data\v310\live_searches_config',

+ '\phpbb\db\migration\data\v310\prune_shadow_topics',

+ );

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('config.update', array('version', '3.1.0-b3')),

+ );

+ }

+}

+<?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

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

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

+ '\phpbb\db\migration\data\v310\migrations_table',

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

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

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

+<?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 live_searches_config extends \phpbb\db\migration\migration

+{

+ public function effectively_installed()

+ {

+ return isset($this->config['allow_live_searches']);

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('config.add', array('allow_live_searches', '1')),

+ );

+ }

+}

+<?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',

+ ),

+ );

+ }

+}

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

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

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

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

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

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

+<?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,

+ 'field_show_on_vt' => 1,

+ 'field_show_on_ml' => 0,

+ 'field_show_profile' => 1,

+ 'field_hide' => 0,

+ 'field_no_view' => 0,

+ 'field_active' => 1,

+ 'field_is_contact' => 1,

+ 'field_contact_desc' => '',

+ 'field_contact_url' => '',

+ );

+

+ protected $user_column_name = 'user_aim';

+}

+<?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_cleanup extends \phpbb\db\migration\migration

+{

+ public function effectively_installed()

+ {

+ return !$this->db_tools->sql_column_exists($this->table_prefix . 'users', 'user_aim');

+ }

+

+ static public function depends_on()

+ {

+ return array(

+ '\phpbb\db\migration\data\v310\profilefield_aol',

+ );

+ }

+

+ public function update_schema()

+ {

+ return array(

+ 'drop_columns' => array(

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

+ 'user_aim',

+ ),

+ ),

+ );

+ }

+

+ public function revert_schema()

+ {

+ return array(

+ 'add_columns' => array(

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

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

+ ),

+ ),

+ );

+ }

+}

+<?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_change_load_settings extends \phpbb\db\migration\migration

+{

+ static public function depends_on()

+ {

+ return array(

+ '\phpbb\db\migration\data\v310\profilefield_aol_cleanup',

+ );

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('config.update', array('load_cpf_memberlist', '1')),

+ array('config.update', array('load_cpf_pm', '1')),

+ array('config.update', array('load_cpf_viewprofile', '1')),

+ array('config.update', array('load_cpf_viewtopic', '1')),

+ );

+ }

+}

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

+<?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_contact_field extends \phpbb\db\migration\migration

+{

+ public function effectively_installed()

+ {

+ return $this->db_tools->sql_column_exists($this->table_prefix . 'profile_fields', 'field_is_contact');

+ }

+

+ static public function depends_on()

+ {

+ return array(

+ '\phpbb\db\migration\data\v310\profilefield_on_memberlist',

+ );

+ }

+

+ public function update_schema()

+ {

+ return array(

+ 'add_columns' => array(

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

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

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

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

+ ),

+ ),

+ );

+ }

+

+ public function revert_schema()

+ {

+ return array(

+ 'drop_columns' => array(

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

+ 'field_is_contact',

+ 'field_contact_desc',

+ 'field_contact_url',

+ ),

+ ),

+ );

+ }

+}

+<?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_icq extends \phpbb\db\migration\profilefield_base_migration

+{

+ static public function depends_on()

+ {

+ return array(

+ '\phpbb\db\migration\data\v310\profilefield_contact_field',

+ );

+ }

+

+ protected $profilefield_name = 'phpbb_icq';

+

+ protected $profilefield_database_type = array('VCHAR', '');

+

+ protected $profilefield_data = array(

+ 'field_name' => 'phpbb_icq',

+ 'field_type' => 'profilefields.type.string',

+ 'field_ident' => 'phpbb_icq',

+ 'field_length' => '20',

+ 'field_minlen' => '3',

+ 'field_maxlen' => '15',

+ 'field_novalue' => '',

+ 'field_default_value' => '',

+ 'field_validation' => '[0-9]+',

+ 'field_required' => 0,

+ 'field_show_novalue' => 0,

+ 'field_show_on_reg' => 0,

+ 'field_show_on_pm' => 1,

+ 'field_show_on_vt' => 1,

+ 'field_show_profile' => 1,

+ 'field_hide' => 0,

+ 'field_no_view' => 0,

+ 'field_active' => 1,

+ 'field_is_contact' => 1,

+ 'field_contact_desc' => 'SEND_ICQ_MESSAGE',

+ 'field_contact_url' => 'https://www.icq.com/people/%s/',

+ );

+

+ protected $user_column_name = 'user_icq';

+}

+<?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_icq_cleanup extends \phpbb\db\migration\migration

+{

+ public function effectively_installed()

+ {

+ return !$this->db_tools->sql_column_exists($this->table_prefix . 'users', 'user_icq');

+ }

+

+ static public function depends_on()

+ {

+ return array(

+ '\phpbb\db\migration\data\v310\profilefield_icq',

+ );

+ }

+

+ public function update_schema()

+ {

+ return array(

+ 'drop_columns' => array(

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

+ 'user_icq',

+ ),

+ ),

+ );

+ }

+

+ public function revert_schema()

+ {

+ return array(

+ 'add_columns' => array(

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

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

+ ),

+ ),

+ );

+ }

+}

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

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

+<?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_location_cleanup extends \phpbb\db\migration\migration

+{

+ public function effectively_installed()

+ {

+ return !$this->db_tools->sql_column_exists($this->table_prefix . 'users', 'user_from');

+ }

+

+ static public function depends_on()

+ {

+ return array(

+ '\phpbb\db\migration\data\v310\profilefield_location',

+ );

+ }

+

+ public function update_schema()

+ {

+ return array(

+ 'drop_columns' => array(

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

+ 'user_from',

+ ),

+ ),

+ );

+ }

+

+ public function revert_schema()

+ {

+ return array(

+ 'add_columns' => array(

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

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

+ ),

+ ),

+ );

+ }

+}

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

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

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

+<?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_website extends \phpbb\db\migration\profilefield_base_migration

+{

+ static public function depends_on()

+ {

+ return array(

+ '\phpbb\db\migration\data\v310\profilefield_on_memberlist',

+ '\phpbb\db\migration\data\v310\profilefield_icq_cleanup',

+ );

+ }

+

+ protected $profilefield_name = 'phpbb_website';

+

+ protected $profilefield_database_type = array('VCHAR', '');

+

+ protected $profilefield_data = array(

+ 'field_name' => 'phpbb_website',

+ 'field_type' => 'profilefields.type.url',

+ 'field_ident' => 'phpbb_website',

+ 'field_length' => '40',

+ 'field_minlen' => '12',

+ '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,

+ 'field_show_on_vt' => 1,

+ 'field_show_on_ml' => 1,

+ 'field_show_profile' => 1,

+ 'field_hide' => 0,

+ 'field_no_view' => 0,

+ 'field_active' => 1,

+ 'field_is_contact' => 1,

+ 'field_contact_desc' => 'VISIT_WEBSITE',

+ 'field_contact_url' => '%s',

+ );

+

+ protected $user_column_name = 'user_website';

+}

+<?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_website_cleanup extends \phpbb\db\migration\migration

+{

+ public function effectively_installed()

+ {

+ return !$this->db_tools->sql_column_exists($this->table_prefix . 'users', 'user_website');

+ }

+

+ static public function depends_on()

+ {

+ return array(

+ '\phpbb\db\migration\data\v310\profilefield_website',

+ );

+ }

+

+ public function update_schema()

+ {

+ return array(

+ 'drop_columns' => array(

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

+ 'user_website',

+ ),

+ ),

+ );

+ }

+

+ public function revert_schema()

+ {

+ return array(

+ 'add_columns' => array(

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

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

+ ),

+ ),

+ );

+ }

+}

+<?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_wlm extends \phpbb\db\migration\profilefield_base_migration

+{

+ static public function depends_on()

+ {

+ return array(

+ '\phpbb\db\migration\data\v310\profilefield_website_cleanup',

+ );

+ }

+

+ protected $profilefield_name = 'phpbb_wlm';

+

+ protected $profilefield_database_type = array('VCHAR', '');

+

+ protected $profilefield_data = array(

+ 'field_name' => 'phpbb_wlm',

+ 'field_type' => 'profilefields.type.string',

+ 'field_ident' => 'phpbb_wlm',

+ '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,

+ 'field_show_on_vt' => 1,

+ 'field_show_on_ml' => 0,

+ 'field_show_profile' => 1,

+ 'field_hide' => 0,

+ 'field_no_view' => 0,

+ 'field_active' => 1,

+ 'field_is_contact' => 1,

+ 'field_contact_desc' => '',

+ 'field_contact_url' => '',

+ );

+

+ protected $user_column_name = 'user_msnm';

+}

+<?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_wlm_cleanup extends \phpbb\db\migration\migration

+{

+ public function effectively_installed()

+ {

+ return !$this->db_tools->sql_column_exists($this->table_prefix . 'users', 'user_msnm');

+ }

+

+ static public function depends_on()

+ {

+ return array(

+ '\phpbb\db\migration\data\v310\profilefield_wlm',

+ );

+ }

+

+ public function update_schema()

+ {

+ return array(

+ 'drop_columns' => array(

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

+ 'user_msnm',

+ ),

+ ),

+ );

+ }

+

+ public function revert_schema()

+ {

+ return array(

+ 'add_columns' => array(

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

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

+ ),

+ ),

+ );

+ }

+}

+<?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_yahoo extends \phpbb\db\migration\profilefield_base_migration

+{

+ static public function depends_on()

+ {

+ return array(

+ '\phpbb\db\migration\data\v310\profilefield_wlm_cleanup',

+ );

+ }

+

+ protected $profilefield_name = 'phpbb_yahoo';

+

+ protected $profilefield_database_type = array('VCHAR', '');

+

+ protected $profilefield_data = array(

+ 'field_name' => 'phpbb_yahoo',

+ 'field_type' => 'profilefields.type.string',

+ 'field_ident' => 'phpbb_yahoo',

+ '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,

+ 'field_show_on_vt' => 1,

+ 'field_show_on_ml' => 0,

+ 'field_show_profile' => 1,

+ 'field_hide' => 0,

+ 'field_no_view' => 0,

+ 'field_active' => 1,

+ 'field_is_contact' => 1,

+ 'field_contact_desc' => 'SEND_YIM_MESSAGE',

+ 'field_contact_url' => 'http://edit.yahoo.com/config/send_webmesg?.target=%s&amp;.src=pg',

+ );

+

+ protected $user_column_name = 'user_yim';

+}

+<?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_yahoo_cleanup extends \phpbb\db\migration\migration

+{

+ public function effectively_installed()

+ {

+ return !$this->db_tools->sql_column_exists($this->table_prefix . 'users', 'user_yim');

+ }

+

+ static public function depends_on()

+ {

+ return array(

+ '\phpbb\db\migration\data\v310\profilefield_yahoo',

+ );

+ }

+

+ public function update_schema()

+ {

+ return array(

+ 'drop_columns' => array(

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

+ 'user_yim',

+ ),

+ ),

+ );

+ }

+

+ public function revert_schema()

+ {

+ return array(

+ 'add_columns' => array(

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

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

+ ),

+ ),

+ );

+ }

+}

+<?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 prune_shadow_topics extends \phpbb\db\migration\migration

+{

+ static public function depends_on()

+ {

+ return array('\phpbb\db\migration\data\v310\dev');

+ }

+

+ public function update_schema()

+ {

+ return array(

+ 'add_columns' => array(

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

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

+ 'prune_shadow_days' => array('UINT', 7),

+ 'prune_shadow_freq' => array('UINT', 1),

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

+ ),

+ ),

+ );

+ }

+

+ public function revert_schema()

+ {

+ return array(

+ 'drop_columns' => array(

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

+ 'enable_shadow_prune',

+ 'prune_shadow_days',

+ 'prune_shadow_freq',

+ 'prune_shadow_next',

+ ),

+ ),

+ );

+ }

+}

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

+<?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 captcha_plugin

+*

+* Reset the captcha setting to the default plugin if the defined 'captcha_plugin' is missing.

+*/

+class reset_missing_captcha_plugin 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(

+ (!is_file($this->phpbb_root_path . "includes/captcha/plugins/{$this->config['captcha_plugin']}_plugin." . $this->php_ext)),

+ array('config.update', array('captcha_plugin', 'phpbb_captcha_nogd')),

+ )),

+ );

+ }

+}

+<?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;

+

+/**

+ * Migration to convert the Soft Delete MOD for 3.0

+ *

+ * https://www.phpbb.com/customise/db/mod/soft_delete/

+ */

+class soft_delete_mod_convert extends \phpbb\db\migration\migration

+{

+ static public function depends_on()

+ {

+ return array(

+ '\phpbb\db\migration\data\v310\alpha3',

+ );

+ }

+

+ public function effectively_installed()

+ {

+ return !$this->db_tools->sql_column_exists($this->table_prefix . 'posts', 'post_deleted');

+ }

+

+ public function update_data()

+ {

+ return array(

+ array('permission.remove', array('m_harddelete', true)),

+ array('permission.remove', array('m_harddelete', false)),

+

+ array('custom', array(array($this, 'convert_posts'))),

+ array('custom', array(array($this, 'convert_topics'))),

+ );

+ }

+

+ public function convert_posts($start)

+ {

+ $content_visibility = $this->get_content_visibility();

+

+ $limit = 250;

+ $i = 0;

+

+ $sql = 'SELECT p.*, t.topic_first_post_id, t.topic_last_post_id

+ FROM ' . $this->table_prefix . 'posts p, ' . $this->table_prefix . 'topics t

+ WHERE p.post_deleted > 0

+ AND t.topic_id = p.topic_id';

+ $result = $this->db->sql_query_limit($sql, $limit, $start);

+

+ while ($row = $this->db->sql_fetchrow($result))

+ {

+ $content_visibility->set_post_visibility(

+ ITEM_DELETED,

+ $row['post_id'],

+ $row['topic_id'],

+ $row['forum_id'],

+ $row['post_deleted'],

+ $row['post_deleted_time'],

+ '',

+ ($row['post_id'] == $row['topic_first_post_id']) ? true : false,

+ ($row['post_id'] == $row['topic_last_post_id']) ? true : false

+ );

+

+ $i++;

+ }

+

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

+

+ if ($i == $limit)

+ {

+ return $start + $i;

+ }

+ }

+

+ public function convert_topics($start)

+ {

+ $content_visibility = $this->get_content_visibility();

+

+ $limit = 100;

+ $i = 0;

+

+ $sql = 'SELECT *

+ FROM ' . $this->table_prefix . 'topics

+ WHERE topic_deleted > 0';

+ $result = $this->db->sql_query_limit($sql, $limit, $start);

+

+ while ($row = $this->db->sql_fetchrow($result))

+ {

+ $content_visibility->set_topic_visibility(

+ ITEM_DELETED,

+ $row['topic_id'],

+ $row['forum_id'],

+ $row['topic_deleted'],

+ $row['topic_deleted_time'],

+ ''

+ );

+

+ $i++;

+ }

+

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

+

+ if ($i == $limit)

+ {

+ return $start + $i;

+ }

+ }

+

+ protected function get_content_visibility()

+ {

+ return new \phpbb\content_visibility(

+ new \phpbb\auth\auth(),

+ $this->db,

+ new \phpbb\user(),

+ $this->phpbb_root_path,

+ $this->php_ext,

+ $this->table_prefix . 'forums',

+ $this->table_prefix . 'posts',

+ $this->table_prefix . 'topics',

+ $this->table_prefix . 'users'

+ );

+ }

+}

+<?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;

+

+/**

+ * Migration to convert the Soft Delete MOD for 3.0

+ *

+ * https://www.phpbb.com/customise/db/mod/soft_delete/

+ */

+class soft_delete_mod_convert2 extends \phpbb\db\migration\migration

+{

+ static public function depends_on()

+ {

+ return array(

+ '\phpbb\db\migration\data\v310\soft_delete_mod_convert',

+ );

+ }

+

+ public function effectively_installed()

+ {

+ return !$this->db_tools->sql_column_exists($this->table_prefix . 'posts', 'post_deleted');

+ }

+

+ public function update_schema()

+ {

+ return array(

+ 'drop_columns' => array(

+ $this->table_prefix . 'forums' => array('forum_deleted_topic_count', 'forum_deleted_reply_count'),

+ $this->table_prefix . 'posts' => array('post_deleted', 'post_deleted_time'),

+ $this->table_prefix . 'topics' => array('topic_deleted', 'topic_deleted_time', 'topic_deleted_reply_count'),

+ ),

+ );

+ }

+

+ public function revert_schema()

+ {

+ return array(

+ 'add_columns' => array(

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

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

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

+ ),

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

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

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

+ ),

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

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

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

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

+ ),

+ ),

+ );

+ }

+}

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

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

+ if (!$start)

+ {

+ // Preserve the forum_posts value for link forums as it represents redirects.

+ $sql = 'UPDATE ' . $this->table_prefix . 'forums

+ SET forum_posts_approved = forum_posts

+ WHERE forum_type = ' . FORUM_LINK;

+ $this->db->sql_query($sql);

+ }

+

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

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

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

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

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

+ public function update_timezones($start)

+ $start = (int) $start;

+ $limit = 500;

+ $converted = 0;

+

+ $update_blocks = array();

+ $sql = 'SELECT user_id, user_timezone, user_dst

+ FROM ' . $this->table_prefix . 'users

+ ORDER BY user_id ASC';

+ $result = $this->db->sql_query_limit($sql, $limit, $start);

+ $converted++;

+

+ // In case this is somehow run twice on a row.

+ // Otherwise it would just end up as UTC on the second run

+ if (is_numeric($row['user_timezone']))

+ {

+ $update_blocks[$row['user_timezone'] . ':' . $row['user_dst']][] = (int) $row['user_id'];

+ }

+ }

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

+

+ // Update blocks of users who share the same timezone/dst

+ foreach ($update_blocks as $timezone => $user_ids)

+ {

+ $timezone = explode(':', $timezone);

+ $converted_timezone = $this->convert_phpbb30_timezone($timezone[0], $timezone[1]);

+

+ SET user_timezone = '" . $this->db->sql_escape($converted_timezone) . "'

+ WHERE " . $this->db->sql_in_set('user_id', $user_ids);

+

+ if ($converted == $limit)

+ {

+ // There are still more to convert

+ return $start + $limit;

+ }

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

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

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

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

+ /** @var \phpbb\db\driver\driver_interface */

+ * @param \phpbb\db\driver\driver_interface $db

+ public function __construct(\phpbb\config\config $config, \phpbb\db\driver\driver_interface $db, \phpbb\db\tools $db_tools, $phpbb_root_path, $php_ext, $table_prefix)

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

+<?php

+/**

+*

+* @package db

+* @copyright (c) 2014 phpBB Group

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

+*

+*/

+

+namespace phpbb\db\migration;

+

+/**

+* The schema generator generates the schema based on the existing migrations

+*

+* @package db

+*/

+class schema_generator

+{

+ /** @var \phpbb\config\config */

+ protected $config;

+

+ /** @var \phpbb\db\driver\driver_interface */

+ protected $db;

+

+ /** @var \phpbb\db\tools */

+ protected $db_tools;

+

+ /** @var array */

+ protected $class_names;

+

+ /** @var string */

+ protected $table_prefix;

+

+ /** @var string */

+ protected $phpbb_root_path;

+

+ /** @var string */

+ protected $php_ext;

+

+ /** @var array */

+ protected $tables;

+

+ /** @var array */

+ protected $dependencies = array();

+

+ /**

+ * Constructor

+ */

+ public function __construct(array $class_names, \phpbb\config\config $config, \phpbb\db\driver\driver_interface $db, \phpbb\db\tools $db_tools, $phpbb_root_path, $php_ext, $table_prefix)

+ {

+ $this->config = $config;

+ $this->db = $db;

+ $this->db_tools = $db_tools;

+ $this->class_names = $class_names;

+ $this->phpbb_root_path = $phpbb_root_path;

+ $this->php_ext = $php_ext;

+ $this->table_prefix = $table_prefix;

+ }

+

+ /**

+ * Loads all migrations and their application state from the database.

+ *

+ * @return array

+ */

+ public function get_schema()

+ {

+ if (!empty($this->tables))

+ {

+ return $this->tables;

+ }

+

+ $migrations = $this->class_names;

+

+ $tree = array();

+ $check_dependencies = true;

+ while (!empty($migrations))

+ {

+ foreach ($migrations as $migration_class)

+ {

+ $open_dependencies = array_diff($migration_class::depends_on(), $tree);

+

+ if (empty($open_dependencies))

+ {

+ $migration = new $migration_class($this->config, $this->db, $this->db_tools, $this->phpbb_root_path, $this->php_ext, $this->table_prefix);

+ $tree[] = $migration_class;

+ $migration_key = array_search($migration_class, $migrations);

+

+ foreach ($migration->update_schema() as $change_type => $data)

+ {

+ if ($change_type === 'add_tables')

+ {

+ foreach ($data as $table => $table_data)

+ {

+ $this->tables[$table] = $table_data;

+ }

+ }

+ else if ($change_type === 'drop_tables')

+ {

+ foreach ($data as $table)

+ {

+ unset($this->tables[$table]);

+ }

+ }

+ else if ($change_type === 'add_columns')

+ {

+ foreach ($data as $table => $add_columns)

+ {

+ foreach ($add_columns as $column => $column_data)

+ {

+ $this->tables[$table]['COLUMNS'][$column] = $column_data;

+ }

+ }

+ }

+ else if ($change_type === 'change_columns')

+ {

+ foreach ($data as $table => $change_columns)

+ {

+ foreach ($change_columns as $column => $column_data)

+ {

+ $this->tables[$table]['COLUMNS'][$column] = $column_data;

+ }

+ }

+ }

+ else if ($change_type === 'drop_columns')

+ {

+ foreach ($data as $table => $drop_columns)

+ {

+ if (is_array($drop_columns))

+ {

+ foreach ($drop_columns as $column)

+ {

+ unset($this->tables[$table]['COLUMNS'][$column]);

+ }

+ }

+ else

+ {

+ unset($this->tables[$table]['COLUMNS'][$drop_columns]);

+ }

+ }

+ }

+ else if ($change_type === 'add_unique_index')

+ {

+ foreach ($data as $table => $add_index)

+ {

+ foreach ($add_index as $key => $index_data)

+ {

+ $this->tables[$table]['KEYS'][$key] = array('UNIQUE', $index_data);

+ }

+ }

+ }

+ else if ($change_type === 'add_index')

+ {

+ foreach ($data as $table => $add_index)

+ {

+ foreach ($add_index as $key => $index_data)

+ {

+ $this->tables[$table]['KEYS'][$key] = array('INDEX', $index_data);

+ }

+ }

+ }

+ else if ($change_type === 'drop_keys')

+ {

+ foreach ($data as $table => $drop_keys)

+ {

+ foreach ($drop_keys as $key)

+ {

+ unset($this->tables[$table]['KEYS'][$key]);

+ }

+ }

+ }

+ else

+ {

+ var_dump($change_type);

+ }

+ }

+ unset($migrations[$migration_key]);

+ }

+ else if ($check_dependencies)

+ {

+ $this->dependencies = array_merge($this->dependencies, $open_dependencies);

+ }

+ }

+

+ // Only run this check after the first run

+ if ($check_dependencies)

+ {

+ $this->check_dependencies();

+ $check_dependencies = false;

+ }

+ }

+

+ ksort($this->tables);

+ return $this->tables;

+ }

+

+ /**

+ * Check if one of the migrations files' dependencies can't be resolved

+ * by the supplied list of migrations

+ *

+ * @throws UnexpectedValueException If a dependency can't be resolved

+ */

+ protected function check_dependencies()

+ {

+ // Strip duplicate values from array

+ $this->dependencies = array_unique($this->dependencies);

+

+ foreach ($this->dependencies as $dependency)

+ {

+ if (!in_array($dependency, $this->class_names))

+ {

+ throw new \UnexpectedValueException("Unable to resolve the dependency '$dependency'");

+ }

+ }

+ }

+}

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

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

+ /** @var \phpbb\db\driver\driver_interface */

+ * @param \phpbb\db\driver\driver_interface $db

+ * @param \phpbb\cache\service $cache

+ public function __construct(\phpbb\db\driver\driver_interface $db, \phpbb\cache\service $cache, \phpbb\user $user, $phpbb_root_path, $php_ext, $modules_table)

+ public function add($class, $parent = 0, $data = array())

+ public function remove($class, $parent = 0, $module = '')

+ return $this->remove($class, $parent, $module['module_langname']);

+ $module_ids[] = (int) $module;

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

+ /** @var \phpbb\db\driver\driver_interface */

+ * @param \phpbb\db\driver\driver_interface $db

+ * @param \phpbb\cache\service $cache

+ public function __construct(\phpbb\db\driver\driver_interface $db, \phpbb\cache\service $cache, \phpbb\auth\auth $auth, $phpbb_root_path, $php_ext)

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

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

+ /** @var \phpbb\db\driver\driver_interface */

+ public function __construct(\phpbb\config\config $config, \phpbb\db\driver\driver_interface $db, \phpbb\db\tools $db_tools, $migrations_table, $phpbb_root_path, $php_ext, $table_prefix, $tools, \phpbb\db\migration\helper $helper)

+ if ($reverse)

+ {

+ return false;

+ }

+ else

+ {

+ return array(

+ $parameters[0],

+ array($last_result),

+ );

+ }

+ /** @var \phpbb\db\driver\driver_interface */

+ * @param \phpbb\db\driver\driver_interface $db