<?php

class m160111_174228_create_section_limits_table extends MyDbMigration
{

  public function up()
  {
    $this->execute ( "
        CREATE TABLE IF NOT EXISTS `eventserverdb`.`section_limits` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `section` int(10) unsigned NOT NULL,
  `class` varchar(256) NOT NULL,
  `road_speed_limit` double NOT NULL,
  `road_speed_threshold` double NOT NULL,
  `epoch` datetime NOT NULL,
  PRIMARY KEY  (`id`)
);
        " );
  }

  public function down()
  {
    $this->execute ( "DROP TABLE IF EXISTS `eventserverdb`.`section_limits`" );
    return true;
  }
}
    