3 use Phinx\Migration\AbstractMigration;
4 use Phinx\Db\Adapter\MysqlAdapter;
19 if ($this->hasTable(
"groups_entity")) {
23 $table = $this->table(
"groups_entity", [
25 'primary_key' => [
"guid"],
27 'encoding' =>
"utf8mb4",
28 'collation' =>
"utf8mb4_general_ci",
31 $table->addColumn(
'guid',
'integer', [
33 'limit' => MysqlAdapter::INT_BIG,
38 $table->addColumn(
'name',
'text', [
42 $table->addColumn(
'description',
'text', [
44 'limit' => MysqlAdapter::TEXT_LONG,
47 $table->addIndex([
'name'], [
53 $table->addIndex([
'description'], [
54 'name' =>
"description",
change()
CREATE TABLE prefix_groups_entity ( guid bigint(20) unsigned NOT NULL, name text NOT NULL,...