
START TRANSACTION;

DROP TABLE IF EXISTS `super_services`;
CREATE TABLE IF NOT EXISTS `super_services` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `calendar_id` int(10) unsigned DEFAULT NULL,
  `price_from` decimal(9,2) unsigned DEFAULT NULL,
  `price_to` decimal(9,2) unsigned DEFAULT NULL,
  `is_active` tinyint(1) unsigned DEFAULT '1',
  PRIMARY KEY (`id`),
  KEY `calendar_id` (`calendar_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8;

ALTER TABLE `services` ADD COLUMN `super_service_id` int(10) unsigned DEFAULT NULL AFTER `calendar_id`;

COMMIT;