<?php

use yii\db\Migration;

/**
 * Class m230127_213733_tablas_eventos
 */
class m230127_213733_tablas_eventos extends Migration {
	/**
	 * {@inheritdoc}
	 */
	public function safeUp() {

		$this->createTable('Evento', [
      "id" => $this->primaryKey(),
      "idGrupo" => $this->integer(),
      "nombre" => $this->string(100)->notNull(),
      "descripcion" => $this->string(255),
      "fotoEvento" => $this->text(255),
      "tag" => $this->string(50)->unique(),
      "url" => $this->string(155)->notNull(),
      "fechaInicio" => $this->timestamp() . " with time zone",
      "fechaFinal" => $this->timestamp() . " with time zone",
      "creado" => $this->timestamp() . " with time zone",
      "modificado" => $this->timestamp() . " with time zone",
      "eliminado" => $this->timestamp() . " with time zone",
    ]);

		$this->createTable('Resultado', [
      "id" => $this->primaryKey(),
      "idUsuario" => $this->integer(),
      "idEvento" => $this->integer(),
      "accion" => $this->string(20)->comment("ver,likes,compartir"),
			"creado" => $this->timestamp() . " with time zone",
      "modificado" => $this->timestamp() . " with time zone",
      "eliminado" => $this->timestamp() . " with time zone",
    ]);

		$this->addForeignKey('EventoIdGrupoFK', 'Evento', 'idGrupo', 'Grupo', 'id');
		$this->addForeignKey('ResultadoIdUsuarioFK', 'Resultado', 'idUsuario', 'Usuario', 'id');
		$this->addForeignKey('ResultadoIdEventoFK', 'Resultado', 'idEvento', 'Evento', 'id');


	}

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

		$this->dropForeignKey("ResultadoIdEventoFK", "Resultado");
		$this->dropForeignKey("ResultadoIdUsuarioFK", "Resultado");
		$this->dropForeignKey("EventoIdGrupoFK", "Evento");

    $this->dropTable('Resultado');
    $this->dropTable('Evento');

	}
}