migrations/20150119171459_init_database.php

   1 <?php
   2
   3 use Phinx\Migration\AbstractMigration;
   4
   5 class InitDatabase extends AbstractMigration
   6 {
   7     /**
   8      * Migrate Up.
   9      */
  10     public function up()
  11     {
  12         $this->execute("CREATE TABLE IF NOT EXISTS `montest` (
  13   `id` int(11) NOT NULL AUTO_INCREMENT,
  14   `name` varchar(255) NOT NULL,
  15   `value` varchar(255) NOT NULL,
  16   PRIMARY KEY (`id`)
  17 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;");
  18     }
  19
  20     /**
  21      * Migrate Down.
  22      */
  23     public function down()
  24     {
  25         $this->execute("DROP DATABASE montest;");
  26     }
  27 }