blitze\sitemaker\migrations\v20x\m5_add_cblocks_schema

Complexity

Total Complexity

4

Size/Duplication

Total Lines	53
Duplicated Lines	0 %

Importance

Changes

0

<?php
class m5_add_cblocks_schema extends \phpbb\db\migration\migration
{
	/**
	 * Skip this migration if the sm_cblocks table already exists
	 *
	 * @return bool True to skip this migration, false to run it
	 * @access public
	 */
	public function effectively_installed()
	{
		return $this->db_tools->sql_table_exists($this->table_prefix . 'sm_cblocks');
	}

	/**
	 * @inheritdoc
	 */
	public static function depends_on()
	{
		return array(
			'\blitze\sitemaker\migrations\v20x\m1_initial_schema',
		);
	}

	/**
	 * @inheritdoc
	 */
	public function update_schema()
	{
		return array(
			'add_tables'	=> array(
				$this->table_prefix . 'sm_cblocks' => array(
					'COLUMNS'		=> array(
						'block_id'			=> array('UINT', null, 'auto_increment'),
						'block_content'		=> array('TEXT_UNI', ''),
						'bbcode_bitfield'	=> array('VCHAR:255', ''),
						'bbcode_options'	=> array('UINT:11', 7),
						'bbcode_uid'		=> array('VCHAR:8', ''),
					),

					'PRIMARY_KEY'	=> 'block_id'
				),
			),
		);
	}

	/**
	 * @inheritdoc
	 */
	public function revert_schema()
	{
		return array(
			'drop_tables'	=> array(
				$this->table_prefix . 'sm_cblocks',
			),