yager-api/migrations/m220310_234138_inicio.php

<?php

use yii\db\Migration;

/**
 * Class m220310_234138_inicio
 */
class m220310_234138_inicio extends Migration {

  /**
   * {@inheritdoc}
   */
  public function safeUp() {

    $this->createTable('Usuario', [
      "id" => $this->primaryKey(),
      "uid" => $this->string(50)->unique(),
      "correo" => $this->string(100)->notNull(),
      "nombre" => $this->string(100)->notNull(),
      "idRol" => $this->integer(),
      "genero" => $this->string(100),
      "facebook" => $this->string(100),
      "facebookVerificado" => $this->boolean(),
      "twitter" => $this->string(100),
      "twitterVerificado" => $this->boolean(),
      "instagram" => $this->string(100),
      "instagramVerificado" => $this->boolean(),
      "creado" => $this->timestamp(),
      "modificado" => $this->timestamp(),
      "eliminado" => $this->timestamp(),
    ]);

    $this->createTable('Grupo', [
      "id" => $this->primaryKey(),
      "nombre" => $this->string(),
      "estatus" => $this->boolean(),
      "descripcion" => $this->string(500),
      "ciudad" => $this->string(500),
      "creado" => $this->timestamp(),
      "modificado" => $this->timestamp(),
      "eliminado" => $this->timestamp(),
    ]);

    $this->createTable('GruposUsuario', [
      "id" => $this->primaryKey(),
      "idUsuario" => $this->integer(),
      "idGrupo" => $this->integer(),
      "creado" => $this->timestamp(),
      "modificado" => $this->timestamp(),
      "eliminado" => $this->timestamp(),
    ]);

    $this->createTable('Rol', [
      "id" => $this->primaryKey(),
      "nombre" => $this->string(),
      "creado" => $this->timestamp(),
      "modificado" => $this->timestamp(),
      "eliminado" => $this->timestamp(),
    ]);

    $this->addForeignKey("UsuarioRolFK", "Usuario", "idRol", "Rol", "id");

  }

  /**
   * {@inheritdoc}
   */
  public function safeDown() {

    $this->dropForeignKey("UsuarioRolFK", "Usuario");

    $this->dropTable('Usuario');
    $this->dropTable('Grupo');
    $this->dropTable('GruposUsuario');
    $this->dropTable('Rol');
  }

}