-- ----------------------------------------------------------------------
-- MySQL Migration Toolkit
-- SQL Create Script
-- ----------------------------------------------------------------------

SET FOREIGN_KEY_CHECKS = 0;

CREATE DATABASE IF NOT EXISTS `2`
  CHARACTER SET latin1 COLLATE latin1_swedish_ci;
USE `2`;
-- -------------------------------------
-- Tables

DROP TABLE IF EXISTS `2`.`BookingActivity`;
CREATE TABLE `2`.`BookingActivity` (
  `ClassId` INT(10) NOT NULL,
  `DaysLeft` INT(10) NOT NULL,
  `Bookings` INT(10) NULL,
  PRIMARY KEY (`ClassId`, `DaysLeft`),
  INDEX `ClassId` (`ClassId`)
)
ENGINE = INNODB;

DROP TABLE IF EXISTS `2`.`CabinClassAssignment`;
CREATE TABLE `2`.`CabinClassAssignment` (
  `SequenceNumber` INT(10) NOT NULL AUTO_INCREMENT,
  `ClassId` SMALLINT(5) NULL,
  `EffectiveFrom` DATETIME NULL,
  `CabinClassId` SMALLINT(5) NULL,
  PRIMARY KEY (`SequenceNumber`),
  UNIQUE INDEX `pkClassAssignment` (`SequenceNumber`),
  UNIQUE INDEX `ukClassAssignment` (`ClassId`, `EffectiveFrom`)
)
ENGINE = INNODB;

DROP TABLE IF EXISTS `2`.`DaysLeft`;
CREATE TABLE `2`.`DaysLeft` (
  `DaysLeft` INT(10) NOT NULL,
  `Include` TINYINT(1) NOT NULL,
  PRIMARY KEY (`DaysLeft`)
)
ENGINE = INNODB;



SET FOREIGN_KEY_CHECKS = 1;

-- ----------------------------------------------------------------------
-- EOF