+global\CreateGroupsEntityTable::change()

Complexity

Conditions	2
Paths	2

Size

Total Lines	46
Code Lines	29

Duplication

Lines	46
Ratio	100 %

Importance

Changes

0

<?php
	public function change() {

		if ($this->hasTable("groups_entity")) {
			return;
		}

		$table = $this->table("groups_entity", [
			'id' => false,
			'primary_key' => ["guid"],
			'engine' => "InnoDB",
			'encoding' => "utf8mb4",
			'collation' => "utf8mb4_general_ci",
		]);

		$table->addColumn('guid', 'integer', [
			'null' => false,
			'limit' => MysqlAdapter::INT_BIG,
			'precision' => 20,
			'signed' => false,
		]);

		$table->addColumn('name', 'text', [
			'null' => false,
			'limit' => 65535,
		]);

		$table->addColumn('description', 'text', [
			'null' => false,
			'limit' => MysqlAdapter::TEXT_LONG,
		]);

		$table->addIndex(['name'], [
			'name' => "name",
			'unique' => false,
			'limit' => 50,
		]);

		$table->addIndex(['description'], [
			'name' => "description",
			'unique' => false,
			'limit' => 50
		]);

		$table->save();

	}
}