m240925_184940_Creacion_tablas_Partida_Unidad_Medida.php 1.6 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263
  1. <?php
  2. use yii\db\Migration;
  3. /**
  4. * Class m240925_184940_Creacion_tablas_Partida_Unidad_Medida
  5. */
  6. class m240925_184940_Creacion_tablas_Partida_Unidad_Medida extends Migration
  7. {
  8. /**
  9. * {@inheritdoc}
  10. */
  11. public function safeUp()
  12. {
  13. $this->createTable('Partida', [
  14. "id" => $this->string(36),
  15. "nombre" => $this->string(100),
  16. "descripcion" => $this->string(100),
  17. "creado" => $this->timestamp()->append(" with time zone"),
  18. "modificado" => $this->timestamp()->append(" with time zone"),
  19. "eliminado" => $this->timestamp()->append(" with time zone"),
  20. ]);
  21. $this->addPrimaryKey('PartidaPK', 'Partida', 'id');
  22. $this->createTable('UnidadMedida', [
  23. "id" => $this->string(36),
  24. "nombre" => $this->string(100),
  25. "descripcion" => $this->string(100),
  26. "creado" => $this->timestamp()->append(" with time zone"),
  27. "modificado" => $this->timestamp()->append(" with time zone"),
  28. "eliminado" => $this->timestamp()->append(" with time zone"),
  29. ]);
  30. $this->addPrimaryKey('UnidadMedidaPK', 'UnidadMedida', 'id');
  31. }
  32. /**
  33. * {@inheritdoc}
  34. */
  35. public function safeDown()
  36. {
  37. $this->dropTable("Partida");
  38. $this->dropTable("UnidadMedida");
  39. }
  40. /*
  41. // Use up()/down() to run migration code without a transaction.
  42. public function up()
  43. {
  44. }
  45. public function down()
  46. {
  47. echo "m240925_184940_Creacion_tablas_Partida_Unidad_Medida cannot be reverted.\n";
  48. return false;
  49. }
  50. */
  51. }