   foreign key (show_id) references nk2_shows (id),
   foreign key (seat_id) references nk2_seats (id),
   foreign key (discount_group_id) references nk2_discount_groups (id)
-) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
+) ENGINE=InnoDB  DEFAULT CHARSET=utf8;
 
 -- --------------------------------------------------------
 

  `ticket_type` ENUM('numbered-seats', 'generic-tickets') not null,
  `description` varchar(255) not null,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

commit;

  `bad_seat` boolean not null default '0',
  PRIMARY KEY  (`id`),
  foreign key (section_id) references nk2_sections (id)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

