phpbb\autogroups\migrations\v10x\m1_initial_schema

Complexity

Total Complexity

3

Size/Duplication

Total Lines	68
Duplicated Lines	0 %

Importance

Changes

0

3 Methods

Rating	Name	Duplication	Size	Complexity
A	depends_on()	0	3	1
A	revert_schema()	0	6	1
A	update_schema()	0	23	1

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

namespace phpbb\autogroups\migrations\v10x;

/**
 * Migration stage 1: Initial schema
 */
class m1_initial_schema extends \phpbb\db\migration\migration

The type phpbb\db\migration\migration was not found. Maybe you did not declare it correctly or list all dependencies?

{
	/**
	 * Assign migration file dependencies for this migration
	 *
	 * @return array Array of migration files
	 * @static
	 * @access public
	 */
	public static function depends_on()
	{
		return array('\phpbb\db\migration\data\v310\gold');
	}

	/**
	 * Add the auto groups table schema to the database:
	 *    auto groups:
	 *        autogroups_id
	 *        autogroups_type_id
	 *        autogroups_min_value
	 *        autogroups_max_value
	 *        autogroups_group_id
	 *        autogroups_default
	 *
	 * @return array Array of table schema
	 * @access public
	 */
	public function update_schema()
	{
		return array(
			'add_tables'	=> array(
				$this->table_prefix . 'autogroups_rules'	=> array(
					'COLUMNS'	=> array(
						'autogroups_id'			=> array('UINT', null, 'auto_increment'),
						'autogroups_type_id'	=> array('USINT', 0),
						'autogroups_min_value'	=> array('INT:11', 0),
						'autogroups_max_value'	=> array('INT:11', 0),
						'autogroups_group_id'	=> array('UINT', 0),
						'autogroups_default'	=> array('BOOL', 0),
					),
					'PRIMARY_KEY'	=> 'autogroups_id',
				),
				$this->table_prefix . 'autogroups_types'	=> array(
					'COLUMNS'	=> array(
						'autogroups_type_id'	=> array('USINT', null, 'auto_increment'),
						'autogroups_type_name'	=> array('VCHAR:255', ''),
					),
					'PRIMARY_KEY'	=> array('autogroups_type_id'),
					'KEYS'			=> array(
						'type'		=> array('UNIQUE', array('autogroups_type_name')),
					),
				),
			),
		);
	}

	/**
	 * Drop the auto groups table schema from the database
	 *
	 * @return array Array of table schema
	 * @access public
	 */
	public function revert_schema()
	{
		return array(
			'drop_tables'	=> array(
				$this->table_prefix . 'autogroups_rules',
				$this->table_prefix . 'autogroups_types',
			),
		);
	}
}