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

+ public function __construct(\phpbb\db\driver\driver_interface $db, \phpbb\config\config $config, \phpbb\passwords\manager $passwords_manager, \phpbb\request\request $request, \phpbb\user $user, $phpbb_root_path, $php_ext)

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

+ public function __construct(\phpbb\db\driver\driver_interface $db, \phpbb\config\config $config, \phpbb\passwords\manager $passwords_manager, \phpbb\request\request $request, \phpbb\user $user, $phpbb_root_path, $php_ext)

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

+ public function __construct(\phpbb\db\driver\driver_interface $db, \phpbb\config\config $config, \phpbb\passwords\manager $passwords_manager, \phpbb\user $user)

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

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

+ public function __construct(\phpbb\db\driver\driver_interface $db, \phpbb\config\config $config, \phpbb\passwords\manager $passwords_manager, \phpbb\request\request_interface $request, \phpbb\user $user, $auth_provider_oauth_token_storage_table, $auth_provider_oauth_token_account_assoc, \phpbb\di\service_collection $service_providers, $users_table, $phpbb_root_path, $php_ext)

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

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

+ public function __construct(\phpbb\db\driver\driver_interface $db, \phpbb\user $user, $auth_provider_oauth_table)

+ 'avatar_path' => array('lang' => 'AVATAR_STORAGE_PATH', 'validate' => 'rpath', 'type' => 'text:20:255', 'explain' => true),

+ * {@inheritDoc}

+ *

+ * @return mixed False if an error was encountered, otherwise the data type of the cached data

+ *

+ * @return null

+ *

+ * @return null

+ *

+ * @return null

+ *

+ * @param string $var_name Cache key

+ * @return mixed False if an error was encountered, otherwise the saved cached object

+ *

+ * @param string $var_name Cache key

+ * @param mixed $var Cached data to store

+ * @param int $ttl Time-to-live of cached data

+ * @return null

+ *

+ * @return null

+ *

+ * @param string $var_name Cache key

+ * @param string $table Table name

+ * @return null

+ *

+ * @param string $var_name Cache key

+ *

+ * @return bool True if cache file exists and has not expired.

+ * False otherwise.

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

+ public function sql_save(\phpbb\db\driver\driver_interface $db, $query, $query_result, $ttl);

+ * {@inheritDoc}

+ * {@inheritDoc}

+ */

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ function sql_save(\phpbb\db\driver\driver_interface $db, $query, $query_result, $ttl)

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ *

+ * @param string $filename Filename to remove

+ * @param bool $check Check file permissions

+ * @return bool True if the file was successfully removed, otherwise false

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ function sql_save(\phpbb\db\driver\driver_interface $db, $query, $query_result, $ttl)

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ *

+ * @param string $filename Filename to remove

+ * @param bool $check Check file permissions

+ * @return bool True if the file was successfully removed, otherwise false

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ function sql_save(\phpbb\db\driver\driver_interface $db, $query, $query_result, $ttl)

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

+ * {@inheritDoc}

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

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

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

+ // In general $class is not supposed to contain a leading backslash,

+ // but sometimes it does. See tickets PHP-50731 and HHVM-1840.

+ if ($class[0] !== '\\')

+ {

+ $class = '\\' . $class;

+ }

+

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

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

+ public function __construct(\phpbb\db\driver\driver_interface $db, \phpbb\cache\driver\driver_interface $cache, $table)

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

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

+ public function __construct(\phpbb\db\driver\driver_interface $db, $table)

+<?php

+/**

+*

+* @package phpBB3

+* @copyright (c) 2014 phpBB Group

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

+*

+*/

+namespace phpbb\console\command\cache;

+

+use Symfony\Component\Console\Input\InputInterface;

+use Symfony\Component\Console\Output\OutputInterface;

+

+class purge extends \phpbb\console\command\command

+{

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

+ protected $cache;

+

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

+ protected $db;

+

+ /** @var \phpbb\auth\auth */

+ protected $auth;

+

+ /** @var \phpbb\log\log */

+ protected $log;

+

+ /** @var \phpbb\user */

+ protected $user;

+

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

+ protected $config;

+

+ public function __construct(\phpbb\cache\driver\driver_interface $cache, \phpbb\db\driver\driver_interface $db, \phpbb\auth\auth $auth, \phpbb\log\log $log, \phpbb\user $user, \phpbb\config\config $config)

+ {

+ $this->cache = $cache;

+ $this->db = $db;

+ $this->auth = $auth;

+ $this->log = $log;

+ $this->user = $user;

+ $this->config = $config;

+ $this->user->add_lang(array('acp/common'));

+ parent::__construct();

+ }

+

+ protected function configure()

+ {

+ $this

+ ->setName('cache:purge')

+ ->setDescription('Purge the cache.')

+ ;

+ }

+

+ protected function execute(InputInterface $input, OutputInterface $output)

+ {

+ $this->config->increment('assets_version', 1);

+ $this->cache->purge();

+

+ // Clear permissions

+ $this->auth->acl_clear_prefetch();

+ phpbb_cache_moderators($this->db, $this->cache, $this->auth);

+

+ $this->log->add('admin', ANONYMOUS, '', 'LOG_PURGE_CACHE', time(), array());

+

+ $output->writeln($this->user->lang('PURGE_CACHE_SUCCESS'));

+ }

+}

+<?php

+/**

+*

+* @package phpBB3

+* @copyright (c) 2014 phpBB Group

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

+*

+*/

+namespace phpbb\console\command\db;

+

+use Symfony\Component\Console\Input\InputInterface;

+use Symfony\Component\Console\Output\OutputInterface;

+

+class migrate extends \phpbb\console\command\command

+{

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

+ protected $migrator;

+

+ /** @var \phpbb\extension\manager */

+ protected $extension_manager;

+

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

+ protected $config;

+

+ /** @var \phpbb\cache\service */

+ protected $cache;

+

+ /** @var \phpbb\log\log */

+ protected $log;

+

+ /** @var \phpbb\user */

+ protected $user;

+

+ function __construct(\phpbb\db\migrator $migrator, \phpbb\extension\manager $extension_manager, \phpbb\config\config $config, \phpbb\cache\service $cache, \phpbb\log\log $log, \phpbb\user $user)

+ {

+ $this->migrator = $migrator;

+ $this->extension_manager = $extension_manager;

+ $this->config = $config;

+ $this->cache = $cache;

+ $this->log = $log;

+ $this->user = $user;

+ $this->user->add_lang(array('common', 'acp/common', 'install', 'migrator'));

+ parent::__construct();

+ }

+

+ protected function configure()

+ {

+ $this

+ ->setName('db:migrate')

+ ->setDescription('Updates the database by applying migrations.')

+ ;

+ }

+

+ protected function execute(InputInterface $input, OutputInterface $output)

+ {

+ $this->load_migrations();

+ $orig_version = $this->config['version'];

+ while (!$this->migrator->finished())

+ {

+ $migration_start_time = microtime(true);

+

+ try

+ {

+ $this->migrator->update();

+ }

+ catch (\phpbb\db\migration\exception $e)

+ {

+ $output->writeln('<error>' . $e->getLocalisedMessage($this->user) . '</error>');

+ $this->finalise_update();

+ return 1;

+ }

+

+ $migration_stop_time = microtime(true) - $migration_start_time;

+

+ $state = array_merge(

+ array(

+ 'migration_schema_done' => false,

+ 'migration_data_done' => false,

+ ),

+ $this->migrator->last_run_migration['state']

+ );

+

+ if (!empty($this->migrator->last_run_migration['effectively_installed']))

+ {

+ $msg = $this->user->lang('MIGRATION_EFFECTIVELY_INSTALLED', $this->migrator->last_run_migration['name']);

+ $output->writeln("<comment>$msg</comment>");

+ }

+ else if ($this->migrator->last_run_migration['task'] == 'process_data_step' && $state['migration_data_done'])

+ {

+ $msg = $this->user->lang('MIGRATION_DATA_DONE', $this->migrator->last_run_migration['name'], $migration_stop_time);

+ $output->writeln("<info>$msg</info>");

+ }

+ else if ($this->migrator->last_run_migration['task'] == 'process_data_step')

+ {

+ $output->writeln($this->user->lang('MIGRATION_DATA_IN_PROGRESS', $this->migrator->last_run_migration['name'], $migration_stop_time));

+ }

+ else if ($state['migration_schema_done'])

+ {

+ $msg = $this->user->lang('MIGRATION_SCHEMA_DONE', $this->migrator->last_run_migration['name'], $migration_stop_time);

+ $output->writeln("<info>$msg</info>");

+ }

+ }

+

+ if ($orig_version != $this->config['version'])

+ {

+ $this->log->add('admin', ANONYMOUS, '', 'LOG_UPDATE_DATABASE', time(), array($orig_version, $this->config['version']));

+ }

+

+ $this->finalise_update();

+ $output->writeln($this->user->lang['DATABASE_UPDATE_COMPLETE']);

+ }

+

+ protected function load_migrations()

+ {

+ $migrations = $this->extension_manager

+ ->get_finder()

+ ->core_path('phpbb/db/migration/data/')

+ ->extension_directory('/migrations')

+ ->get_classes();

+ $this->migrator->set_migrations($migrations);

+ }

+

+ protected function finalise_update()

+ {

+ $this->cache->purge();

+ $this->config->increment('assets_version', 1);

+ }

+}

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

+ function __construct(\phpbb\db\driver\driver_interface $db)

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

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

+ public function __construct(\phpbb\auth\auth $auth, \phpbb\db\driver\driver_interface $db, \phpbb\user $user, $phpbb_root_path, $php_ext, $forums_table, $posts_table, $topics_table, $users_table)

+ * @param $visibility int Element of {ITEM_APPROVED, ITEM_DELETED, ITEM_REAPPROVE}

+ * @param $reason string Reason why the visibility was changed.

+ * @return array Changed post data, empty array if an error occurred.

+ if (!in_array($visibility, array(ITEM_APPROVED, ITEM_DELETED, ITEM_REAPPROVE)))

+ if (in_array($visibility, array(ITEM_REAPPROVE, ITEM_DELETED)))

+ $field_alias = array(

+ ITEM_APPROVED => 'posts_approved',

+ ITEM_UNAPPROVED => 'posts_unapproved',

+ ITEM_DELETED => 'posts_softdeleted',

+ ITEM_REAPPROVE => 'posts_unapproved',

+ );

+ $cur_posts = array_fill_keys($field_alias, 0);

+

+ $cur_posts[$field_alias[(int) $post_visibility]] += $visibility_posts;

+ $recipient_field = $field_alias[$visibility];

+

+ foreach ($cur_posts as $field => $count)

+ // Decrease the count for the old statuses.

+ if ($count && $field != $recipient_field)

+ $sql_ary[$field] = " - $count";

+ // Add up the count from all statuses excluding the recipient status.

+ $count_increase = array_sum(array_diff($cur_posts, array($recipient_field)));

+

+ if ($count_increase)

+ $sql_ary[$recipient_field] = " + $count_increase";

+ * @param $visibility int Element of {ITEM_APPROVED, ITEM_DELETED, ITEM_REAPPROVE}

+ if (!in_array($visibility, array(ITEM_APPROVED, ITEM_DELETED, ITEM_REAPPROVE)))

+ $this->set_post_visibility($visibility, false, $topic_id, $forum_id, $user_id, $time, '', true, true, $original_topic_data['topic_visibility'], $original_topic_data['topic_delete_time']);

+ // If we're soft deleting a topic we only mark approved posts as soft deleted.

+ $this->set_post_visibility($visibility, false, $topic_id, $forum_id, $user_id, $time, '', true, true, $original_topic_data['topic_visibility']);

+ $this->set_post_visibility($visibility, false, $topic_id, $forum_id, $user_id, $time, '', true, true);

+use Symfony\Component\Routing\Generator\UrlGenerator;

+use Symfony\Component\Routing\RequestContext;

+ * @param \phpbb\user $user User object

+ * @param \phpbb\config\config $config Config object

+ * @param \phpbb\controller\provider $provider Path provider

+ * @param \phpbb\extension\manager $manager Extension manager object

+ public function __construct(\phpbb\template\template $template, \phpbb\user $user, \phpbb\config\config $config, \phpbb\controller\provider $provider, \phpbb\extension\manager $manager, $phpbb_root_path, $php_ext)

+ $provider->find_routing_files($manager->get_finder());

+ $this->route_collection = $provider->find($phpbb_root_path)->get_routes();

+ public function render($template_file, $page_title = '', $status_code = 200, $display_online_list = false)

+ page_header($page_title, $display_online_list);

+ * Generate a URL to a route

+ * @param string $route Name of the route to travel

+ * @param array $params String or array of additional url parameters

+ public function route($route, array $params = array(), $is_amp = true, $session_id = false)

+ $anchor = '';

+ if (isset($params['#']))

+ $anchor = '#' . $params['#'];

+ unset($params['#']);

+ }

+ $url_generator = new UrlGenerator($this->route_collection, new RequestContext());

+ $route_url = $url_generator->generate($route, $params);

+

+ if (strpos($route_url, '/') === 0)

+ {

+ $route_url = substr($route_url, 1);

+ }

+

+ if ($is_amp)

+ {

+ $route_url = str_replace(array('&amp;', '&'), array('&', '&amp;'), $route_url);

+ return append_sid($route_prefix . $route_url . $anchor, false, $is_amp, $session_id);

+ * Collection of the routes in phpBB and all found extensions

+ * @var RouteCollection

+ */

+ protected $routes;

+

+ /**

+ * @param \phpbb\extension\finder $finder

+ * @return null

+ public function find_routing_files(\phpbb\extension\finder $finder)

+ $this->routing_files = array_merge($this->routing_files, array('config/routing.yml'), array_keys($finder

+ ->directory('/config')

+ ->suffix('routing.yml')

+ ->find()

+ * Find a list of controllers and return it

+ * @return null

+ $this->routes = new RouteCollection;

+ $this->routes->addCollection($loader->load($file_path));

+ return $this;

+ }

+

+ /**

+ * Get the list of routes

+ *

+ * @return RouteCollection Get the route collection

+ */

+ public function get_routes()

+ {

+ return $this->routes;

+ * @var \phpbb\template\template

+ * phpBB root path

+ * @var string

+ */

+ protected $phpbb_root_path;

+

+ /**

+ * @param string $phpbb_root_path Relative path to phpBB root

+ public function __construct(\phpbb\user $user, ContainerInterface $container, $phpbb_root_path, \phpbb\template\template $template = null)

+ $this->phpbb_root_path = $phpbb_root_path;

+ * @param \Symfony\Component\HttpFoundation\Request $request Symfony Request object

+ if (is_dir($this->phpbb_root_path . $controller_style_dir))

+ * @param \Symfony\Component\HttpFoundation\Request $request Symfony Request object

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

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

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

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

+<?php

+/**

+*

+* @package phpBB3

+* @copyright (c) 2014 phpBB Group

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

+*

+*/

+

+namespace phpbb\cron\task\core;

+

+/**

+* Prune one forum of its shadow topics cron task.

+*

+* It is intended to be used when cron is invoked via web.

+* This task can decide whether it should be run using data obtained by viewforum

+* code, without making additional database queries.

+*

+* @package phpBB3

+*/

+class prune_shadow_topics extends \phpbb\cron\task\base implements \phpbb\cron\task\parametrized

+{

+ protected $phpbb_root_path;

+ protected $php_ext;

+ protected $config;

+ protected $db;

+ protected $log;

+ protected $user;

+

+ /**

+ * If $forum_data is given, it is assumed to contain necessary information

+ * about a single forum that is to be pruned.

+ *

+ * If $forum_data is not given, forum id will be retrieved via request_var

+ * and a database query will be performed to load the necessary information

+ * about the forum.

+ */

+ protected $forum_data;

+

+ /**

+ * Constructor.

+ *

+ * @param string $phpbb_root_path The root path

+ * @param string $php_ext The PHP extension

+ * @param \phpbb\config\config $config The config

+ * @param \phpbb\db\driver\driver $db The db connection

+ * @param \phpbb\log\log $log The phpBB log system

+ * @param \phpbb\user $user The phpBB user object

+ */

+ public function __construct($phpbb_root_path, $php_ext, \phpbb\config\config $config, \phpbb\db\driver\driver $db, \phpbb\log\log $log, \phpbb\user $user)

+ {

+ $this->phpbb_root_path = $phpbb_root_path;

+ $this->php_ext = $php_ext;

+ $this->config = $config;

+ $this->db = $db;

+ $this->log = $log;

+ $this->user = $user;

+ }

+

+ /**

+ * Manually set forum data.

+ *

+ * @param array $forum_data Information about a forum to be pruned.

+ */

+ public function set_forum_data($forum_data)

+ {

+ $this->forum_data = $forum_data;

+ }

+

+ /**

+ * Runs this cron task.

+ *

+ * @return null

+ */

+ public function run()

+ {

+ if (!function_exists('auto_prune'))

+ {

+ include($this->phpbb_root_path . 'includes/functions_admin.' . $this->php_ext);

+ }

+

+ if ($this->forum_data['prune_shadow_days'])

+ {

+ $this->auto_prune_shadow_topics($this->forum_data['forum_id'], 'shadow', $this->forum_data['forum_flags'], $this->forum_data['prune_shadow_days'], $this->forum_data['prune_shadow_freq']);

+ }

+ }

+

+ /**

+ * Returns whether this cron task can run, given current board configuration.

+ *

+ * This cron task will not run when system cron is utilised, as in

+ * such cases prune_all_forums task would run instead.

+ *

+ * Additionally, this task must be given the forum data, either via

+ * the constructor or parse_parameters method.

+ *

+ * @return bool

+ */

+ public function is_runnable()

+ {

+ return !$this->config['use_system_cron'] && $this->forum_data;

+ }

+

+ /**

+ * Returns whether this cron task should run now, because enough time

+ * has passed since it was last run.

+ *

+ * Forum pruning interval is specified in the forum data.

+ *

+ * @return bool

+ */

+ public function should_run()

+ {

+ return $this->forum_data['enable_shadow_prune'] && $this->forum_data['prune_shadow_next'] < time();

+ }

+

+ /**

+ * Returns parameters of this cron task as an array.

+ * The array has one key, f, whose value is id of the forum to be pruned.

+ *

+ * @return array

+ */

+ public function get_parameters()

+ {

+ return array('f' => $this->forum_data['forum_id']);

+ }

+

+ /**

+ * Parses parameters found in $request, which is an instance of

+ * \phpbb\request\request_interface.

+ *

+ * It is expected to have a key f whose value is id of the forum to be pruned.

+ *

+ * @param \phpbb\request\request_interface $request Request object.

+ *

+ * @return null

+ */

+ public function parse_parameters(\phpbb\request\request_interface $request)

+ {

+ $this->forum_data = null;

+ if ($request->is_set('f'))

+ {

+ $forum_id = $request->variable('f', 0);

+

+ $sql = 'SELECT forum_id, prune_shadow_next, enable_shadow_prune, prune_shadow_days, forum_flags, prune_shadow_freq

+ FROM ' . FORUMS_TABLE . "

+ WHERE forum_id = $forum_id";

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

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

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

+

+ if ($row)

+ {

+ $this->forum_data = $row;

+ }

+ }

+ }

+

+ /**

+ * Automatically prune shadow topics

+ * Based on fuunction auto_prune()

+ * @param int $forum_id Forum ID of forum that should be pruned

+ * @param string $prune_mode Prune mode

+ * @param int $prune_flags Prune flags

+ * @param int $prune_freq Prune frequency

+ * @return null

+ */

+ protected function auto_prune_shadow_topics($forum_id, $prune_mode, $prune_flags, $prune_days, $prune_freq)

+ {

+ $sql = 'SELECT forum_name

+ FROM ' . FORUMS_TABLE . "

+ WHERE forum_id = $forum_id";

+ $result = $this->db->sql_query($sql, 3600);

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

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

+

+ if ($row)

+ {

+ $prune_date = time() - ($prune_days * 86400);

+ $next_prune = time() + ($prune_freq * 86400);

+

+ prune($forum_id, $prune_mode, $prune_date, $prune_flags, true);

+

+ $sql = 'UPDATE ' . FORUMS_TABLE . "

+ SET prune_shadow_next = $next_prune

+ WHERE forum_id = $forum_id";

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

+

+ $user_id = (empty($this->user->data)) ? ANONYMOUS : $this->user->data['user_id'];

+ $user_ip = (empty($this->user->ip)) ? '' : $this->user->ip;

+

+ $this->log->add('admin', $user_id, $user_ip, 'LOG_PRUNE_SHADOW', false, array($row['forum_name']));

+ }

+

+ return;

+ }

+}

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

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

+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