florinp\messenger\migrations\m1_initial_scheme

Complexity

Total Complexity

2

Size/Duplication

Total Lines	37
Duplicated Lines	0 %

Coupling/Cohesion

Components	0
Dependencies	0

Importance

Changes

0

2 Methods

Rating	Name	Duplication	Size	Complexity
A	update_schema()	0	23	1
A	revert_schema()	0	9	1

<?php

namespace florinp\messenger\migrations;

class m1_initial_scheme extends \phpbb\db\migration\migration
{

	public function update_schema()
	{
		return array(
			'add_tables' => array(
				$this->table_prefix.'messenger_friends_request' => array(
					'COLUMNS' => array(
						'request_id' => array('UINT', null, 'auto_increment', 0),
						'user_id' => array('UINT', 0),
						'sender_id' => array('UINT', 0),
						'status' => array('UINT:1', 0),
						'time' => array('TIMESTAMP', 0)
					),
					'PRIMARY_KEY' => 'request_id'
				),
				$this->table_prefix.'messenger_user_friends' => array(
					'COLUMNS' => array(
						'user_id' => array('UINT', 0),
						'friend_id' => array('UINT', 0)
					)
				)
			)
		);
	}

	public function revert_schema()
	{
		return array(
			'drop_tables' => array(
				$this->table_prefix.'messenger_friends_request',
				$this->table_prefix.'messenger_user_friends'
			)
		);
	}
}