-

-

- case 'mysql':

- case 'mysql4':

- $sql = 'VALUES ' . implode(', ', preg_replace('#^(.*?)$#', '(\1)', $sql_subary));

- break;

-

- 'mysql_40',

-<?php

-/**

-*

-* This file is part of the phpBB Forum Software package.

-*

-* @copyright (c) phpBB Limited <https://www.phpbb.com>

-* @license GNU General Public License, version 2 (GPL-2.0)

-*

-* For full copyright and license information, please see

-* the docs/CREDITS.txt file.

-*

-*/

-

-/**

-* This file creates SQL statements to upgrade phpBB on MySQL 3.x/4.0.x to 4.1.x/5.x

-*/

-

-//

-// Security message:

-//

-// This script is potentially dangerous.

-// Remove or comment the next line (die(".... ) to enable this script.

-// Do NOT FORGET to either remove this script or disable it after you have used it.

-//

-die("Please read the first lines of this script for instructions on how to enable it");

-

-define('IN_PHPBB', true);

-$phpbb_root_path = (defined('PHPBB_ROOT_PATH')) ? PHPBB_ROOT_PATH : './';

-$phpEx = substr(strrchr(__FILE__, '.'), 1);

-include($phpbb_root_path . 'common.' . $phpEx);

-

-$prefix = $table_prefix;

-

-$newline = "\n";

-

-if (PHP_SAPI !== 'cli')

-{

- $newline = '<br>';

-}

-

-$sql = 'DESCRIBE ' . POSTS_TABLE . ' post_text';

-$result = $db->sql_query($sql);

-

-$row = $db->sql_fetchrow($result);

-

-$db->sql_freeresult($result);

-

-$mysql_indexer = $drop_index = false;

-

-if (strtolower($row['Type']) === 'mediumtext')

-{

- $mysql_indexer = true;

-}

-

-if (strtolower($row['Key']) === 'mul')

-{

- $drop_index = true;

-}

-

-echo "USE $dbname;$newline$newline";

-

-

-@set_time_limit(0);

-

-$finder = new \phpbb\finder(new \phpbb\filesystem\filesystem(), $phpbb_root_path);

-$classes = $finder->core_path('phpbb/')

- ->directory('/db/migration/data')

- ->get_classes();

-

-$factory = new \phpbb\db\tools\factory();

-$db_tools = $factory->get($db, true);

-

-$schema_generator = new \phpbb\db\migration\schema_generator($classes, $config, $db, $db_tools, $phpbb_root_path, $phpEx, $table_prefix);

-$schema_data = $schema_generator->get_schema();

-$dbms_type_map = \phpbb\db\tools\tools::get_dbms_type_map();

-

-foreach ($schema_data as $table_name => $table_data)

-{

- $table_name = str_replace('phpbb_', $prefix, $table_name);

- // Write comment about table

- echo "# Table: '{$table_name}'$newline";

-

- // Create Table statement

- $generator = $textimage = false;

-

- // Do we need to DROP a fulltext index before we alter the table?

- if ($table_name == ($prefix . 'posts') && $drop_index)

- {

- echo "ALTER TABLE {$table_name}{$newline}";

- echo "DROP INDEX post_text,{$newline}DROP INDEX post_subject,{$newline}DROP INDEX post_content;{$newline}{$newline}";

- }

-

- $line = "ALTER TABLE {$table_name} $newline";

-

- // Table specific so we don't get overlap

- $modded_array = array();

-

- // Write columns one by one...

- foreach ($table_data['COLUMNS'] as $column_name => $column_data)

- {

- // Get type

- if (strpos($column_data[0], ':') !== false)

- {

- list($orig_column_type, $column_length) = explode(':', $column_data[0]);

- $column_type = sprintf($dbms_type_map['mysql_41'][$orig_column_type . ':'], $column_length);

-

- if (isset($dbms_type_map['mysql_40'][$orig_column_type . ':']['limit']) &&

- isset($dbms_type_map['mysql_40'][$orig_column_type . ':']['limit'][0]))

- {

- switch ($dbms_type_map['mysql_40'][$orig_column_type . ':']['limit'][0])

- {

- case 'mult':

- if (($column_length * $dbms_type_map['mysql_40'][$orig_column_type . ':']['limit'][1]) > $dbms_type_map['mysql_40'][$orig_column_type . ':']['limit'][2])

- {

- $modded_array[$column_name] = $column_type;

- }

- break;

- }

- }

-

- $orig_column_type .= ':';

- }

- else

- {

- $orig_column_type = $column_data[0];

- $other_column_type = $dbms_type_map['mysql_40'][$column_data[0]];

- if ($other_column_type == 'text' || $other_column_type == 'blob')

- {

- $modded_array[$column_name] = $column_type;

- }

- $column_type = $dbms_type_map['mysql_41'][$column_data[0]];

- }

-

- // Adjust default value if db-dependent specified

- if (is_array($column_data[1]))

- {

- $column_data[1] = (isset($column_data[1][$dbms])) ? $column_data[1][$dbms] : $column_data[1]['default'];

- }

-

- $line .= "\tMODIFY {$column_name} {$column_type} ";

-

- // For hexadecimal values do not use single quotes

- if (!is_null($column_data[1]) && substr($column_type, -4) !== 'text' && substr($column_type, -4) !== 'blob')

- {

- $line .= (strpos($column_data[1], '0x') === 0) ? "DEFAULT {$column_data[1]} " : "DEFAULT '{$column_data[1]}' ";

- }

- $line .= 'NOT NULL';

-

- if (isset($column_data[2]))

- {

- if ($column_data[2] == 'auto_increment')

- {

- $line .= ' auto_increment';

- }

- else if ($column_data[2] == 'true_sort')

- {

- $line .= ' COLLATE utf8_unicode_ci';

- }

- else if ($column_data[2] == 'no_sort')

- {

- $line .= ' COLLATE utf8_bin';

- }

- }

- else if (preg_match('/(?:var)?char|(?:medium)?text/i', $column_type))

- {

- $line .= ' COLLATE utf8_bin';

- }

-

- $line .= ",$newline";

- }

-

- // Write Keys

- if (isset($table_data['KEYS']))

- {

- foreach ($table_data['KEYS'] as $key_name => $key_data)

- {

- $temp = '';

- if (!is_array($key_data[1]))

- {

- $key_data[1] = array($key_data[1]);

- }

-

- $temp .= ($key_data[0] == 'INDEX') ? "\tADD KEY" : '';

- $temp .= ($key_data[0] == 'UNIQUE') ? "\tADD UNIQUE" : '';

- $repair = false;

- foreach ($key_data[1] as $key => $col_name)

- {

- if (isset($modded_array[$col_name]))

- {

- $repair = true;

- }

- }

- if ($repair)

- {

- $line .= "\tDROP INDEX " . $key_name . ",$newline";

- $line .= $temp;

- $line .= ' ' . $key_name . ' (' . implode(', ', $key_data[1]) . "),$newline";

- }

- }

- }

-

- //$line .= "\tCONVERT TO CHARACTER SET `utf8`$newline";

- $line .= "\tDEFAULT CHARSET=utf8 COLLATE=utf8_bin;$newline$newline";

-

- echo $line . "$newline";

-

- // Do we now need to re-add the fulltext index? ;)

- if ($table_name == ($prefix . 'posts') && $drop_index)

- {

- echo "ALTER TABLE $table_name ADD FULLTEXT (post_subject), ADD FULLTEXT (post_text), ADD FULLTEXT post_content (post_subject, post_text);{$newline}";

- }

-}

- <p>All SQL should be cross-DB compatible, if DB specific SQL is used alternatives must be provided which work on all supported DB's (MySQL3/4/5, MSSQL (7.0 and 2000), PostgreSQL (8.3+), SQLite, Oracle8, ODBC (generalised if possible)).</p>

- case 'mysql':

- case 'mysql4':

- case 'mysql4':

- case 'mysql4':

- case 'mysql':

- case 'mysql4':

- case 'mysql4':

- $sql = 'DELETE ' . (($db->get_sql_layer() === 'mysqli' || version_compare($db->sql_server_info(true), '4.1', '>=')) ? 'z.*' : ZEBRA_TABLE) . '

- case 'mysql':

- case 'mysql4':

- case 'mysql':

- case 'mysql4':

- $sql = 'VALUES ' . implode(', ', preg_replace('#^(.*?)$#', '(\1)', $sql_subary));

- break;

-

- // Thanks MySQL, for silently converting...

- case 'mysql':

- case 'mysql4':

- if (version_compare($src_db->sql_server_info(true, false), '4.1.3', '>='))

- {

- $convert->mysql_convert = true;

- }

- $convert->src_truncate_statement = 'TRUNCATE TABLE ';

- break;

-

- case 'mysql':

- case 'mysql4':

- // Can we use IGNORE with this DBMS?

- $sql_ignore = (strpos($db->get_sql_layer(), 'mysql') === 0 && !defined('DEBUG')) ? 'IGNORE ' : '';

- $insert_query = 'INSERT ' . $sql_ignore . 'INTO ' . $schema['target'] . ' (';

- case 'mysql':

- $map_dbms = 'mysql_40';

- break;

-

- case 'mysql4':

- if (version_compare($db->sql_server_info(true), '4.1.3', '>='))

- {

- $map_dbms = 'mysql_41';

- }

- else

- {

- $map_dbms = 'mysql_40';

- }

- break;

-

- case 'mysql_40':

- $create_sql = 'CREATE TABLE ' . USERCONV_TABLE . ' (

- user_id mediumint(8) NOT NULL,

- username_clean blob NOT NULL

- )';

- break;

-

- 'DB_OPTION_MYSQL' => 'MySQL',

-<?php

-/**

-*

-* This file is part of the phpBB Forum Software package.

-*

-* @copyright (c) phpBB Limited <https://www.phpbb.com>

-* @license GNU General Public License, version 2 (GPL-2.0)

-*

-* For full copyright and license information, please see

-* the docs/CREDITS.txt file.

-*

-*/

-

-namespace phpbb\db\driver;

-

-/**

-* MySQL4 Database Abstraction Layer

-* Compatible with:

-* MySQL 3.23+

-* MySQL 4.0+

-* MySQL 4.1+

-* MySQL 5.0+

-*/

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

-{

- var $multi_insert = true;

- var $connect_error = '';

-

- /**

- * {@inheritDoc}

- */

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

- {

- $this->persistency = $persistency;

- $this->user = $sqluser;

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

- $this->dbname = $database;

-

- $this->sql_layer = 'mysql4';

-

- if ($this->persistency)

- {

- if (!function_exists('mysql_pconnect'))

- {

- $this->connect_error = 'mysql_pconnect function does not exist, is mysql extension installed?';

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

- }

- $this->db_connect_id = @mysql_pconnect($this->server, $this->user, $sqlpassword);

- }

- else

- {

- if (!function_exists('mysql_connect'))

- {

- $this->connect_error = 'mysql_connect function does not exist, is mysql extension installed?';

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

- }

- $this->db_connect_id = @mysql_connect($this->server, $this->user, $sqlpassword, $new_link);

- }

-

- if ($this->db_connect_id && $this->dbname != '')

- {

- if (@mysql_select_db($this->dbname, $this->db_connect_id))

- {

- // Determine what version we are using and if it natively supports UNICODE

- if (version_compare($this->sql_server_info(true), '4.1.0', '>='))

- {

- @mysql_query("SET NAMES 'utf8'", $this->db_connect_id);

-

- // enforce strict mode on databases that support it

- if (version_compare($this->sql_server_info(true), '5.0.2', '>='))

- {

- $result = @mysql_query('SELECT @@session.sql_mode AS sql_mode', $this->db_connect_id);

- if ($result)

- {

- $row = mysql_fetch_assoc($result);

- mysql_free_result($result);

- $modes = array_map('trim', explode(',', $row['sql_mode']));

- }

- else

- {

- $modes = array();

- }

-

- // TRADITIONAL includes STRICT_ALL_TABLES and STRICT_TRANS_TABLES

- if (!in_array('TRADITIONAL', $modes))

- {

- if (!in_array('STRICT_ALL_TABLES', $modes))

- {

- $modes[] = 'STRICT_ALL_TABLES';

- }

-

- if (!in_array('STRICT_TRANS_TABLES', $modes))

- {

- $modes[] = 'STRICT_TRANS_TABLES';

- }

- }

-

- $mode = implode(',', $modes);

- @mysql_query("SET SESSION sql_mode='{$mode}'", $this->db_connect_id);

- }

- }

- else if (version_compare($this->sql_server_info(true), '4.0.0', '<'))

- {

- $this->sql_layer = 'mysql';

- }

-

- return $this->db_connect_id;

- }

- }

-

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

- }

-

- /**

- * {@inheritDoc}

- */

- function sql_server_info($raw = false, $use_cache = true)

- {

- global $cache;

-

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

- {

- $result = @mysql_query('SELECT VERSION() AS version', $this->db_connect_id);

- if ($result)

- {

- $row = mysql_fetch_assoc($result);

- mysql_free_result($result);

-

- $this->sql_server_version = $row['version'];

-

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

- {

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

- }

- }

- }

-

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

- }

-

- /**

- * SQL Transaction

- * @access private

- */

- function _sql_transaction($status = 'begin')

- {

- switch ($status)

- {

- case 'begin':

- return @mysql_query('BEGIN', $this->db_connect_id);

- break;

-

- case 'commit':

- return @mysql_query('COMMIT', $this->db_connect_id);

- break;

-

- case 'rollback':

- return @mysql_query('ROLLBACK', $this->db_connect_id);

- break;

- }

-

- return true;

- }

-

- /**

- * {@inheritDoc}

- */

- function sql_query($query = '', $cache_ttl = 0)

- {

- if ($query != '')

- {

- global $cache;

-

- if ($this->debug_sql_explain)

- {

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

- }

- else if ($this->debug_load_time)

- {

- $this->curtime = microtime(true);

- }

-

- $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 = @mysql_query($query, $this->db_connect_id)) === false)

- {

- $this->sql_error($query);

- }

-

- if ($this->debug_sql_explain)

- {

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

- }

- else if ($this->debug_load_time)

- {

- $this->sql_time += microtime(true) - $this->curtime;

- }

-

- if (!$this->query_result)

- {

- return false;

- }

-

- if ($cache && $cache_ttl)

- {

- $this->open_queries[(int) $this->query_result] = $this->query_result;

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

- }

- else if (strpos($query, 'SELECT') === 0)

- {

- $this->open_queries[(int) $this->query_result] = $this->query_result;

- }

- }

- else if ($this->debug_sql_explain)

- {

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

- }

- }

- else

- {

- return false;

- }

-

- return $this->query_result;

- }

-

- /**

- * {@inheritDoc}

- */

- function sql_affectedrows()

- {

- if ($this->db_connect_id)

- {

- // We always want the number of matched rows

- // instead of changed rows, when running an update.

- // So when mysql_info() returns the number of matched rows

- // we return that one instead of mysql_affected_rows()

- $mysql_info = @mysql_info($this->db_connect_id);

- if ($mysql_info !== false)

- {

- $match = array();

- preg_match('#^Rows matched: (\d)+ Changed: (\d)+ Warnings: (\d)+$#', $mysql_info, $match);

- if (isset($match[1]))

- {

- return $match[1];

- }

- }

-

- return @mysql_affected_rows($this->db_connect_id);

- }

- return false;

- }

-

- /**

- * {@inheritDoc}

- */

- function sql_fetchrow($query_id = false)

- {

- global $cache;

-

- if ($query_id === false)

- {

- $query_id = $this->query_result;

- }

-

- if ($cache && $cache->sql_exists($query_id))

- {

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

- }

-

- return ($query_id) ? mysql_fetch_assoc($query_id) : false;

- }

-

- /**

- * {@inheritDoc}

- */

- function sql_rowseek($rownum, &$query_id)

- {

- global $cache;

-

- if ($query_id === false)

- {

- $query_id = $this->query_result;

- }

-

- if ($cache && $cache->sql_exists($query_id))

- {

- return $cache->sql_rowseek($rownum, $query_id);

- }

-

- return ($query_id !== false) ? @mysql_data_seek($query_id, $rownum) : false;

- }

-

- /**

- * {@inheritDoc}

- */

- function sql_nextid()

- {

- return ($this->db_connect_id) ? @mysql_insert_id($this->db_connect_id) : false;

- }

-

- /**

- * {@inheritDoc}

- */

- 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 (isset($this->open_queries[(int) $query_id]))

- {

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

- return mysql_free_result($query_id);

- }

-

- return false;

- }

-

- /**

- * {@inheritDoc}

- */

- function sql_escape($msg)

- {

- if (!$this->db_connect_id)

- {

- return @mysql_real_escape_string($msg);

- }

-

- return @mysql_real_escape_string($msg, $this->db_connect_id);

- }

-

- /**

- * return sql error array

- * @access private

- */

- function _sql_error()

- {

- if ($this->db_connect_id)

- {

- $error = array(

- 'message' => @mysql_error($this->db_connect_id),

- 'code' => @mysql_errno($this->db_connect_id),

- );

- }

- else if (function_exists('mysql_error'))

- {

- $error = array(

- 'message' => @mysql_error(),

- 'code' => @mysql_errno(),

- );

- }

- else

- {

- $error = array(

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

- 'code' => '',

- );

- }

-

- return $error;

- }

-

- /**

- * Close sql connection

- * @access private

- */

- function _sql_close()

- {

- return @mysql_close($this->db_connect_id);

- }

-

- /**

- * Build db-specific report

- * @access private

- */

- function _sql_report($mode, $query = '')

- {

- static $test_prof;

-

- // current detection method, might just switch to see the existence of INFORMATION_SCHEMA.PROFILING

- if ($test_prof === null)

- {

- $test_prof = false;

- if (version_compare($this->sql_server_info(true), '5.0.37', '>=') && version_compare($this->sql_server_info(true), '5.1', '<'))

- {

- $test_prof = true;

- }

- }

-

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

-

- // begin profiling

- if ($test_prof)

- {

- @mysql_query('SET profiling = 1;', $this->db_connect_id);

- }

-

- if ($result = @mysql_query("EXPLAIN $explain_query", $this->db_connect_id))

- {

- while ($row = mysql_fetch_assoc($result))

- {

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

- }

- mysql_free_result($result);

- }

-

- if ($html_table)

- {

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

- }

-

- if ($test_prof)

- {

- $html_table = false;

-

- // get the last profile

- if ($result = @mysql_query('SHOW PROFILE ALL;', $this->db_connect_id))

- {

- $this->html_hold .= '<br />';

- while ($row = mysql_fetch_assoc($result))

- {

- // make <unknown> HTML safe

- if (!empty($row['Source_function']))

- {

- $row['Source_function'] = str_replace(array('<', '>'), array('&lt;', '&gt;'), $row['Source_function']);

- }

-

- // remove unsupported features

- foreach ($row as $key => $val)

- {

- if ($val === null)

- {

- unset($row[$key]);

- }

- }

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

- }

- mysql_free_result($result);

- }

-

- if ($html_table)

- {

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

- }

-

- @mysql_query('SET profiling = 0;', $this->db_connect_id);

- }

- }

-

- break;

-

- case 'fromcache':

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

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

-

- $result = @mysql_query($query, $this->db_connect_id);

- if ($result)

- {

- while ($void = mysql_fetch_assoc($result))

- {

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

- }

- mysql_free_result($result);

- }

-

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

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

-

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

-

- break;

- }

- }

-}

- if ($this->db->get_sql_layer() === 'mysqli')

- {

- $this->write_data_mysqli($table_name);

- }

- else

- {

- $this->write_data_mysql($table_name);

- }

- * Extracts data from database table (for MySQL driver)

- *

- * @param string $table_name name of the database table

- * @return null

- * @throws \phpbb\db\extractor\exception\extractor_not_initialized_exception when calling this function before init_extractor()

- */

- protected function write_data_mysql($table_name)

- {

- if (!$this->is_initialized)

- {

- throw new extractor_not_initialized_exception();

- }

-

- $sql = "SELECT *

- FROM $table_name";

- $result = mysql_unbuffered_query($sql, $this->db->get_db_connect_id());

-

- if ($result != false)

- {

- $fields_cnt = mysql_num_fields($result);

-

- // Get field information

- $field = array();

- for ($i = 0; $i < $fields_cnt; $i++)

- {

- $field[] = mysql_fetch_field($result, $i);

- }

- $field_set = array();

-

- for ($j = 0; $j < $fields_cnt; $j++)

- {

- $field_set[] = $field[$j]->name;

- }

-

- $search = array("\\", "'", "\x00", "\x0a", "\x0d", "\x1a", '"');

- $replace = array("\\\\", "\\'", '\0', '\n', '\r', '\Z', '\\"');

- $fields = implode(', ', $field_set);

- $sql_data = 'INSERT INTO ' . $table_name . ' (' . $fields . ') VALUES ';

- $first_set = true;

- $query_len = 0;

- $max_len = get_usable_memory();

-

- while ($row = mysql_fetch_row($result))

- {

- $values = array();

- if ($first_set)

- {

- $query = $sql_data . '(';

- }

- else

- {

- $query .= ',(';

- }

-

- for ($j = 0; $j < $fields_cnt; $j++)

- {

- if (!isset($row[$j]) || is_null($row[$j]))

- {

- $values[$j] = 'NULL';

- }

- else if ($field[$j]->numeric && ($field[$j]->type !== 'timestamp'))

- {

- $values[$j] = $row[$j];

- }

- else

- {

- $values[$j] = "'" . str_replace($search, $replace, $row[$j]) . "'";

- }

- }

- $query .= implode(', ', $values) . ')';

-

- $query_len += strlen($query);

- if ($query_len > $max_len)

- {

- $this->flush($query . ";\n\n");

- $query = '';

- $query_len = 0;

- $first_set = true;

- }

- else

- {

- $first_set = false;

- }

- }

- mysql_free_result($result);

-

- // check to make sure we have nothing left to flush

- if (!$first_set && $query)

- {

- $this->flush($query . ";\n\n");

- }

- }

- }

-

- /**

- 'mysql_40' => array(

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

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

- 'ULINT' => 'INT(10) UNSIGNED',

- 'UINT' => 'mediumint(8) UNSIGNED',

- 'UINT:' => 'int(%d) UNSIGNED',

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

- 'USINT' => 'smallint(4) UNSIGNED',

- 'BOOL' => 'tinyint(1) UNSIGNED',

- 'VCHAR' => 'varbinary(255)',

- 'VCHAR:' => 'varbinary(%d)',

- 'CHAR:' => 'binary(%d)',

- 'XSTEXT' => 'blob',

- 'XSTEXT_UNI'=> 'blob',

- 'STEXT' => 'blob',

- 'STEXT_UNI' => 'blob',

- 'TEXT' => 'blob',

- 'TEXT_UNI' => 'blob',

- 'MTEXT' => 'mediumblob',

- 'MTEXT_UNI' => 'mediumblob',

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

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

- 'DECIMAL:' => 'decimal(%d,2)',

- 'PDECIMAL' => 'decimal(6,3)',

- 'PDECIMAL:' => 'decimal(%d,3)',

- 'VCHAR_UNI' => 'blob',

- 'VCHAR_UNI:'=> array('varbinary(%d)', 'limit' => array('mult', 3, 255, 'blob')),

- 'VCHAR_CI' => 'blob',

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

- ),

-

- case 'mysql':

- $this->sql_layer = 'mysql_40';

- break;

-

- case 'mysql4':

- if (version_compare($this->db->sql_server_info(true), '4.1.3', '>='))

- {

- $this->sql_layer = 'mysql_41';

- }

- else

- {

- $this->sql_layer = 'mysql_40';

- }

- break;

-

- case 'mysql':

- case 'mysql4':

- case 'mysql_40':

- case 'mysql_40':

- case 'mysql_40':

- case 'mysql_40':

- if (($this->sql_layer == 'mysql_40' || $this->sql_layer == 'mysql_41') && !$row['Non_unique'])

- case 'mysql_40':

- if (($this->sql_layer == 'mysql_40' || $this->sql_layer == 'mysql_41') && ($row['Non_unique'] || $row[$col] == 'PRIMARY'))

- case 'mysql_40':

- case 'mysql_40':

- case 'mysql_40':

- case 'mysql_40':

- case 'mysql_40':

- case 'mysql_40':

- // remove index length unless MySQL4

- if ('mysql_40' != $this->sql_layer)

- {

- $column = preg_replace('#:.*$#', '', $column);

- }

- case 'mysql_40':

- // add index size to definition as required by MySQL4

- foreach ($column as $i => $col)

- {

- if (false !== strpos($col, ':'))

- {

- list($col, $index_size) = explode(':', $col);

- $column[$i] = "$col($index_size)";

- }

- }

- // no break

- case 'mysql_40':

- if (($this->sql_layer == 'mysql_40' || $this->sql_layer == 'mysql_41') && !$row['Non_unique'])

- case 'mysql_40':

- case 'mysql_40':

- 'mysql' => array(

- 'LABEL' => 'MySQL',

- 'SCHEMA' => 'mysql',

- 'MODULE' => 'mysql',

- 'DELIM' => ';',

- 'DRIVER' => 'phpbb\db\driver\mysql',

- 'AVAILABLE' => true,

- '2.0.x' => true,

- ),

- case 'mysql':

- case 'mysqli':

- if (version_compare($db->sql_server_info(true), '4.1.3', '<'))

- {

- $errors[] = array(

- 'title' => 'INST_ERR_DB_NO_MYSQLI',

- );

- }

- break;

- if (version_compare($this->db->sql_server_info(true), '4.1.3', '>='))

- {

- $schema_name .= '_41';

- }

- else

- {

- $schema_name .= '_40';

- }

- if (version_compare($this->db->sql_server_info(true), '4.1.3', '>='))

- {

- $schema_name .= '_41';

- }

- else

- {

- $schema_name .= '_40';

- }

- if ($this->db->get_sql_layer() != 'mysql4' && $this->db->get_sql_layer() != 'mysqli')

- if ($this->db->get_sql_layer() == 'mysqli' || version_compare($this->db->sql_server_info(true), '4.1.3', '>='))

- {

- $alter_entry[] = 'MODIFY post_subject varchar(255) COLLATE utf8_unicode_ci DEFAULT \'\' NOT NULL';

- }

- else

- {

- $alter_entry[] = 'MODIFY post_subject text NOT NULL';

- }

- if ($this->db->get_sql_layer() == 'mysqli' || version_compare($this->db->sql_server_info(true), '4.1.3', '>='))

- {

- $alter_entry[] = 'MODIFY post_text mediumtext COLLATE utf8_unicode_ci NOT NULL';

- }

- else

- {

- $alter_entry[] = 'MODIFY post_text mediumtext NOT NULL';

- }

-

- case 'mysql4':

- case 'mysql4':

- if ($this->db->get_sql_layer() != 'mysql' && $this->db->get_sql_layer() != 'mysql4' && $this->db->get_sql_layer() != 'mysqli' && $this->db->get_sql_layer() != 'postgres')

- if ($this->db->get_sql_layer() =='mysql' || $this->db->get_sql_layer() == 'mysql4' || $this->db->get_sql_layer() == 'mysqli')

-- mysql, pdo_mysql (MySQL database driver)

- array('mysql'),

- case 'phpbb\db\driver\mysql':

- case 'phpbb\db\driver\mysql':

- if (version_compare($row['version'], '4.1.3', '>='))

- {

- $schema .= '_41';

- }

- else

- {

- $schema .= '_40';

- }

- 'phpbb\db\driver\mysql' => array(

- 'SCHEMA' => 'mysql',

- 'DELIM' => ';',

- 'PDO' => 'mysql',

- ),

-if [ "$DB" == "mysql" -o "$DB" == "mysqli" -o "$DB" == "mariadb" ]