<?php

class m130523_160848_update_adr_codes extends MyDbMigration
{
  public function up()
  {
    $this->execute('
        DELETE FROM `adr_code`;


    INSERT INTO `adr_code` (`id`, `code`, `description`) VALUES
            (1,"20","Asphyxiant gas" ),
            (2,"22","Refrigerated liquefied gas, asphyxiant" ),
            (3,"223","Refrigerated liquefied gas, flammable" ),
            (4,"225","Refrigerated liquefied gas, oxidizing (fire-intensifying)" ),
            (5,"23","Flammable gas" ),
            (6,"236","Flammable gas, toxic" ),
            (7,"239","Flammable gas which can spontaneously lead to violent reaction" ),
            (8,"25","Oxidizing (fire-intensifying) gas" ),
            (9,"26","Toxic gas" ),
            (10,"263","Toxic gas, flammable" ),
            (11,"265","Toxic gas, oxidizing (fire-intensifying)" ),
            (12,"266","Highly toxic gas" ),
            (13,"268","Toxic gas, corrosive" ),
            (14,"286","Corrosive gas, toxic" ),
            (15,"30","Flammable liquid" ),
            (16,"323","Flammable liquid which reacts with water, emitting flammable gas" ),
            (17,"X323","Flammable liquid which reacts dangerously with water, emitting flammable gas" ),
            (18,"33","Highly flammable liquid" ),
            (19,"333","Pyrophoric liquid" ),
            (20,"X333","Pyrophoric liquid which reacts dangerously with water" ),
            (21,"336","Highly flammable liquid, toxic" ),
            (22,"338","Highly flammable liquid, corrosive" ),
            (23,"X338","Highly flammable liquid, corrosive, which reacts dangerously with water" ),
            (24,"339","Highly flammable liquid which can spontaneously lead to violent reaction" ),
            (25,"36","Flammable liquid, toxic, or self-heating liquid, toxic" ),
            (26,"362","Flammable liquid, toxic, which reacts with water, emitting flammable gas" ),
            (27,"X362","Flammable liquid, toxic, which reacts dangerously with water, emitting flammable gas" ),
            (28,"368","Flammable liquid, toxic, corrosive" ),
            (29,"38","Flammable liquid, corrosive or self-heating liquid, corrosive" ),
            (30,"382","Flammable liquid, corrosive, which reacts with water, emitting flammable gas" ),
            (31,"X382","Flammable liquid, corrosive, which reacts dangerously with water, emitting flammable gas" ),
            (32,"39","Flammable liquid which can spontaneously lead to violent reaction" ),
            (33,"40","Flammable solid, or self-reactive material, or self-heating material" ),
            (34,"423","Solid which reacts with water, emitting flammable gas" ),
            (35,"X423","Flammable solid which reacts dangerously with water, emitting flammable gas" ),
            (36,"43","Spontaneously flammable (pyrophoric) solid" ),
            (37,"432","Spontaneously flammable (pyrophoric) solid which reacts with water, emitting flammable gases" ),
            (38,"44","Flammable solid, in the molten state at an elevated temperature" ),
            (39,"446","Flammable solid, toxic, in the molten state at an elevated temperature" ),
            (40,"46","Flammable solid, toxic, or self-heating solid, toxic" ),
            (41,"462","Toxic solid which reacts with water, emitting flammable gas" ),
            (42,"X462","Solid which reacts dangerously with water, emitting toxic gas" ),
            (43,"48","Flammable or self-heating solid, corrosive" ),
            (44,"482","Corrosive solid which reacts with water, emitting flammable gas" ),
            (45,"X482","Solid which reacts dangerously with water, emitting corrosive gas" ),
            (46,"50","Oxidizing (fire-intensifying) substance" ),
            (47,"539","Flammable organic peroxide" ),
            (48,"55","Strongly oxidizing (fire-intensifying) substance" ),
            (49,"556","Strongly oxidizing (fire-intensifying) substance, toxic" ),
            (50,"558","Strongly oxidizing (fire-intensifying) substance, corrosive" ),
            (51,"559","Strongly oxidizing (fire-intensifying) substance which can spontaneously lead to violent reaction" ),
            (52,"56","Oxidizing (fire-intensifying) substance, toxic" ),
            (53,"568","Oxidizing (fire-intensifying) substance, toxic, corrosive" ),
            (54,"58","Oxidizing (fire-intensifying) substance, corrosive" ),
            (55,"59","Oxidizing (fire intensifying) substance which can spontaneously lead to violent reaction" ),
            (56,"60","Toxic material" ),
            (57,"606","Infectious substance" ),
            (58,"623","Toxic liquid which reacts with water, emitting flammable gas" ),
            (59,"63","Toxic liquid, flammable" ),
            (60,"638","Toxic liquid, flammable, corrosive" ),
            (61,"639","Toxic liquid, flammable, which can spontaneously lead to violent reaction" ),
            (62,"64","Toxic solid, flammable or self-heating" ),
            (63,"642","Toxic solid which reacts with water, emitting flammable gas" ),
            (64,"65","Toxic material, oxidizing (fire-intensifying)" ),
            (65,"66","Highly toxic material" ),
            (66,"663","Highly toxic liquid, flammable" ),
            (67,"664","Highly toxic solid, flammable or self-heating" ),
            (68,"665","Highly toxic material, oxidizing (fire-intensifying)" ),
            (69,"668","Highly toxic material, corrosive" ),
            (70,"68","toxic or harmful substance, corrosive" ),
            (71,"69","toxic or harmful substance, which can spontaneously lead to violent reaction" ),
            (72,"70","radioactive material" ),
            (73,"72","radioactive gas" ),
            (74,"723","radioactive gas, flammable" ),
            (75,"73","radioactive liquid, flammable (flash point not above 55ø C)" ),
            (76,"74","radioactive solid, flammable" ),
            (77,"75","radioactive material, oxidizing" ),
            (78,"76","radioactive material, toxic" ),
            (79,"78","radioactive material, corrosive" ),
            (80,"80","corrosive or slightly corrosive substance" ),
            (81,"X80","corrosive or slightly corrosive substance, which reacts dangerously with water" ),
            (82,"83","corrosive or slightly corrosive substance, flammable (flash point between 21øC and 55øC)" ),
            (83,"X83","corrosive or slightly corrosive substance, flammable (flash point between 21øC and 55øC) , which reacts dangerously with water" ),
            (84,"839","corrosive or slightly corrosive substance, flammable (flash point between 21øC and 55øC), which can spontaneously lead to violent reaction" ),
            (85,"X839","corrosive or slightly corrosive substance, flammable (flash point between 21øC and 55øC), which can spontaneously lead to violent reaction and which reacts dangerously with water" ),
            (86,"85","corrosive or slightly corrosive substance, oxidizing (fire-intensifying)" ),
            (87,"856","corrosive or slightly corrosive substance, oxidizing (fire-intensifying) and toxic" ),
            (88,"86","corrosive or slightly corrosive substance, toxic" ),
            (89,"88","highly corrosive substance" ),
            (90,"X88","highly corrosive substance, which reacts dangerously with water" ),
            (91,"883","highly corrosive substance, flammable (flash point between 21øC and 55øC)" ),
            (92,"885","highly corrosive substance, oxidizing (fire-intensifying)" ),
            (93,"886","highly corrosive substance, toxic" ),
            (94,"X886","highly corrosive substance, toxic, which reacts dangerously with water" ),
            (95,"823","Corrosive liquid which reacts with water, emitting flammable gases" ),
            (96,"842","Corrosive solid which reacts with water, emitting flammable gases" ),
            (97,"89","corrosive or slightly corrosive substance), which can spontaneously lead to violent reaction" ),
            (98,"90","Environmentally hazardous substance miscellaneous dangerous substance" ),
            (99,"99","Miscellaneous dangerous substance carried at an elevated temperature" );


    ');
  }

  public function down()
  {
    $this->execute('
      DELETE FROM `adr_code`;
    ');
  }

}
