CREATE TABLE `Seat` (
  `seat_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `seat_created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `seat_event_id` int(11) NOT NULL DEFAULT '0',
  `seat_category_id` int(11) NOT NULL DEFAULT '0',
  `seat_user_id` int(11) DEFAULT NULL,
  `seat_order_id` int(11) DEFAULT NULL,
  `seat_row_nr` varchar(5) DEFAULT NULL,
  `seat_zone_id` int(11) DEFAULT NULL,
  `seat_pmp_id` int(11) DEFAULT NULL,
  `seat_nr` int(11) NOT NULL DEFAULT '0',
  `seat_ts` int(11) DEFAULT NULL,
  `seat_sid` varchar(32) DEFAULT NULL,
  `seat_price` decimal(10,2) DEFAULT NULL,
  `seat_discount_id` int(11) DEFAULT NULL,
  `seat_code` varchar(16) DEFAULT NULL,
  `seat_status` varchar(5) NOT NULL DEFAULT 'free',
  `seat_sales_id` int(11) DEFAULT NULL,
  `seat_old_order_id` int(11) DEFAULT NULL,
  `seat_old_status` varchar(5) DEFAULT NULL,
  `seat_pos_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`seat_id`),
  KEY `seat_event_id` (`seat_event_id`),
  KEY `seat_category_id` (`seat_category_id`),
  KEY `seat_order_id` (`seat_order_id`),
  KEY `seat_ts` (`seat_ts`),
  KEY `seat_status` (`seat_status`)
) ENGINE=InnoDB AUTO_INCREMENT=224815 DEFAULT CHARSET=utf8;