phpbb\topicprefixes\migrations\install_schema

Complexity

Total Complexity

4

Size/Duplication

Total Lines	79
Duplicated Lines	0 %

Coupling/Cohesion

Components	0
Dependencies	0

Importance

Changes	7
Bugs	1	Features	1

4 Methods

Rating	Name	Duplication	Size	Complexity
A	effectively_installed()	0	4	1
A	depends_on()	0	4	1
B	update_schema()	0	25	1
A	revert_schema()	0	13	1

<?php
/**
 *
 * Topic Prefixes extension for the phpBB Forum Software package.
 *
 * @copyright (c) 2016 phpBB Limited <https://www.phpbb.com>
 * @license GNU General Public License, version 2 (GPL-2.0)
 *
 */

namespace phpbb\topicprefixes\migrations;

/**
 * Class install_schema
 */
class install_schema extends \phpbb\db\migration\migration
{
	/**
	 * @inheritdoc
	 */
	public function effectively_installed()
	{
		return $this->db_tools->sql_table_exists($this->table_prefix . 'topic_prefixes');
	}

	/**
	 * @inheritdoc
	 */
	public static function depends_on()
	{
		return ['\phpbb\db\migration\data\v31x\v314'];
	}

	/**
	 * Add the topic prefixes schema to the database:
	 *    topic_prefixes:
	 *        prefix_id        Prefix identifier
	 *        prefix_tag       Prefix tag
	 *        prefix_enabled   Prefix enabled/disabled state
	 *        prefix_parent_id Prefix parent identifier
	 *        prefix_left_id   Prefix left tree id
	 *        prefix_right_id  Prefix right tree id
	 *        prefix_parents   Prefix parents data
	 *        forum_id         The forum identifier associated with the prefix
	 *    topics:
	 *        topic_prefix_id The prefix identifier associated with the topic
	 *
	 * @return array Array of table schema
	 */
	public function update_schema()
	{
		return [
			'add_columns'	=> [
				$this->table_prefix . 'topics'			=> [
					'topic_prefix_id' => ['UINT', 0],
				],
			],
			'add_tables'	=> [
				$this->table_prefix . 'topic_prefixes'	=> [
					'COLUMNS'     => [
						'prefix_id'			=> ['UINT', null, 'auto_increment'],
						'prefix_tag'		=> ['VCHAR_UNI', ''],
						'prefix_enabled'	=> ['BOOL', 1],
						'prefix_parent_id'	=> ['UINT', 0],
						'prefix_left_id'	=> ['UINT', 0],
						'prefix_right_id'	=> ['UINT', 0],
						'prefix_parents'	=> ['MTEXT_UNI', ''],
						'forum_id'			=> ['UINT', 0],
					],
					'PRIMARY_KEY'			=> 'prefix_id',
				],
			],
		];
	}

	/**
	 * Drop the topic prefixes schema from the database
	 *
	 * @return array Array of table schema
	 */
	public function revert_schema()
	{
		return [
			'drop_columns'	=> [
				$this->table_prefix . 'topics' => [
					'topic_prefix_id',
				],
			],
			'drop_tables'	=> [
				$this->table_prefix . 'topic_prefixes',
			],
		];
	}
}