Provided here is an example structure for a MySQL database to help with easily importing the XML data from our system to yours. By using this example schema you will quickly have a database up and running that can facilitate all neccessary tables & fields from the Cruise Factory XML service.

Click the link at the top of the example below to download the file.

mysql-database-example.sql

# ************************************************************
# DATABASE: cruisefactory
# ************************************************************
 
 
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
 
 
# Dump OF TABLE amenities
# ------------------------------------------------------------
 
DROP TABLE IF EXISTS `amenities`;
 
CREATE TABLE `amenities` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `ship_id` INT(11) NOT NULL DEFAULT '0',
  `name` VARCHAR(150) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `AmenitiesIndex` (`id`,`ship_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
 
 
# Dump OF TABLE cabins
# ------------------------------------------------------------
 
DROP TABLE IF EXISTS `cabins`;
 
CREATE TABLE `cabins` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `ship_id` INT(11) NOT NULL DEFAULT '0',
  `name` VARCHAR(100) NOT NULL DEFAULT '',
  `description` text,
  `image` VARCHAR(150) DEFAULT NULL,
  `photo` VARCHAR(150) DEFAULT NULL,
  `cabin_order` INT(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `CabinsIndex` (`id`,`ship_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
 
 
# Dump OF TABLE cruiselines
# ------------------------------------------------------------
 
DROP TABLE IF EXISTS `cruiselines`;
 
CREATE TABLE `cruiselines` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(200) NOT NULL DEFAULT '',
  `location` VARCHAR(200) NOT NULL DEFAULT '',
  `booking_email` VARCHAR(100) DEFAULT NULL,
  `brief_desc` VARCHAR(200) NOT NULL DEFAULT '',
  `company_bio` text NOT NULL,
  `logodata` longblob,
  `logosize` VARCHAR(50) DEFAULT NULL,
  `logotype` VARCHAR(50) DEFAULT NULL,
  `url` VARCHAR(255) DEFAULT NULL,
  `video_url` VARCHAR(255) DEFAULT NULL,
  `starrating` INT(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
 
 
# Dump OF TABLE cruises
# ------------------------------------------------------------
 
DROP TABLE IF EXISTS `cruises`;
 
CREATE TABLE `cruises` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `cruiseline_id` INT(11) NOT NULL DEFAULT '0',
  `destination_id` INT(11) NOT NULL DEFAULT '0',
  `ship_id` INT(11) NOT NULL DEFAULT '0',
  `cruisetype_id` SMALLINT(6) NOT NULL DEFAULT '0',
  `length` SMALLINT(6) DEFAULT NULL,
  `name` VARCHAR(80) NOT NULL DEFAULT '',
  `brief_description` VARCHAR(250) DEFAULT NULL,
  `description` text,
  `photo` VARCHAR(100) DEFAULT NULL,
  `start_price` DECIMAL(9,2) DEFAULT NULL,
  `currency_id` INT(11) NOT NULL DEFAULT '1',
  `cruise_order` INT(11) NOT NULL DEFAULT '100',
  PRIMARY KEY (`id`),
  KEY `cruiseline_id` (`cruiseline_id`),
  KEY `destination_id` (`destination_id`),
  KEY `ship_id` (`ship_id`),
  KEY `cruisetype_id` (`cruisetype_id`),
  KEY `CruisesIndex` (`cruiseline_id`,`destination_id`,`id`,`ship_id`),
  KEY `destination_id_id` (`destination_id`,`id`),
  KEY `id_cruiselineid` (`id`,`cruiseline_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
 
 
# Dump OF TABLE cruisetypes
# ------------------------------------------------------------
 
DROP TABLE IF EXISTS `cruisetypes`;
 
CREATE TABLE `cruisetypes` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(100) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
 
 
# Dump OF TABLE currencies
# ------------------------------------------------------------
 
DROP TABLE IF EXISTS `currencies`;
 
CREATE TABLE `currencies` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(50) NOT NULL DEFAULT '',
  `description` VARCHAR(48) DEFAULT NULL,
  `sign` VARCHAR(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
 
 
# Dump OF TABLE deckplans
# ------------------------------------------------------------
 
DROP TABLE IF EXISTS `deckplans`;
 
CREATE TABLE `deckplans` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `ship_id` INT(11) NOT NULL DEFAULT '0',
  `level` VARCHAR(100) NOT NULL DEFAULT '',
  `name` VARCHAR(100) NOT NULL DEFAULT '',
  `image` VARCHAR(100) NOT NULL DEFAULT '',
  `colorcode` VARCHAR(100) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ship_id` (`ship_id`),
  KEY `DeckPlansIndex` (`id`,`ship_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
 
 
# Dump OF TABLE destinations
# ------------------------------------------------------------
 
DROP TABLE IF EXISTS `destinations`;
 
CREATE TABLE `destinations` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(100) NOT NULL DEFAULT '',
  `description` text NOT NULL,
  `image` VARCHAR(100) DEFAULT NULL,
  `banner` VARCHAR(100) DEFAULT NULL,
  `map_thumb` VARCHAR(100) DEFAULT NULL,
  `map_large` VARCHAR(100) DEFAULT NULL,
  `featured` CHAR(1) NOT NULL DEFAULT 'n',
  `featured_text` text,
  PRIMARY KEY (`id`),
  KEY `featured` (`featured`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
 
 
# Dump OF TABLE dining
# ------------------------------------------------------------
 
DROP TABLE IF EXISTS `dining`;
 
CREATE TABLE `dining` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `cruiseline_id` INT(11) NOT NULL DEFAULT '0',
  `name` VARCHAR(100) DEFAULT NULL,
  `introduction` text NOT NULL,
  `photo` VARCHAR(50) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `cruiseline_id` (`cruiseline_id`),
  KEY `DiningIndex` (`cruiseline_id`,`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
 
 
# Dump OF TABLE diningtimes
# ------------------------------------------------------------
 
DROP TABLE IF EXISTS `diningtimes`;
 
CREATE TABLE `diningtimes` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `cruiseline_id` INT(11) NOT NULL DEFAULT '0',
  `meal` VARCHAR(50) NOT NULL DEFAULT '',
  `normal_sitting` VARCHAR(50) DEFAULT NULL,
  `late_sitting` VARCHAR(50) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `cruiseline_id` (`cruiseline_id`),
  KEY `DiningTimesIndex` (`cruiseline_id`,`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
 
 
# Dump OF TABLE facilities
# ------------------------------------------------------------
 
DROP TABLE IF EXISTS `facilities`;
 
CREATE TABLE `facilities` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `ship_id` INT(11) NOT NULL DEFAULT '0',
  `name` VARCHAR(150) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `ship_id` (`ship_id`),
  KEY `FacilitiesIndex` (`id`,`ship_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
 
 
# Dump OF TABLE specialsailingdates
# ------------------------------------------------------------
 
DROP TABLE IF EXISTS `specialsailingdates`;
 
CREATE TABLE `specialsailingdates` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `factory_id` INT(11) NOT NULL DEFAULT '0',
  `special_id` INT(11) DEFAULT NULL,
  `sailingdate_id` INT(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `sailingdate_id` (`sailingdate_id`),
  KEY `factory_id` (`factory_id`),
  KEY `special_id` (`special_id`),
  KEY `SDIndex` (`factory_id`,`special_id`,`sailingdate_id`),
  KEY `sailingdateid_specialid_factoryid` (`factory_id`,`special_id`,`sailingdate_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
 
 
# Dump OF TABLE specials
# ------------------------------------------------------------
 
DROP TABLE IF EXISTS `specials`;
 
CREATE TABLE `specials` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `cruise_id` INT(11) NOT NULL DEFAULT '0',
  `factory_id` INT(11) NOT NULL DEFAULT '0',
  `priority_id` INT(11) NOT NULL DEFAULT '1',
  `special_header` VARCHAR(100) DEFAULT NULL,
  `special_text` longtext,
  `special_brief` longtext,
  `instructions` longtext,
  `booking_email` VARCHAR(100) DEFAULT NULL,
  `start_price` DECIMAL(9,2) DEFAULT NULL,
  `currency_id` INT(11) NOT NULL DEFAULT '1',
  `cruise_order` INT(11) NOT NULL DEFAULT '0',
  `main_special` CHAR(1) DEFAULT 'n',
  `dest_special` CHAR(1) DEFAULT 'n',
  `special_order` INT(11) DEFAULT NULL,
  `validity_date_end` DATE DEFAULT NULL,
  `validity_date_start` DATE DEFAULT NULL,
  `checked` CHAR(1) DEFAULT 'n',
  `internal_notes` text,
  `advert_code` VARCHAR(255) DEFAULT NULL,
  `exchange_rate` DOUBLE(11,4) DEFAULT NULL,
  `ex_rate_date` DATE DEFAULT NULL,
  `currency_id_ref` INT(11) UNSIGNED NOT NULL DEFAULT '0',
  `create_pdf` CHAR(1) DEFAULT 'n',
  `uploaded_pdf` VARCHAR(255) DEFAULT NULL,
  `withdrawn` CHAR(1) NOT NULL DEFAULT 'n',
  `quicksave` CHAR(1) DEFAULT NULL,
  `status` tinyint(1) UNSIGNED NOT NULL DEFAULT '1',
  `type` VARCHAR(32) DEFAULT NULL,
  `escorted` CHAR(1) DEFAULT 'n',
  `wedding` CHAR(1) DEFAULT 'n',
  `agentonly` CHAR(1) DEFAULT 'n',
  `special_conditions` text,
  `specialpdf_filename` VARCHAR(255) DEFAULT NULL,
  `specialpdf_contents` text,
  `seniors` enum('Yes','No') DEFAULT 'No',
  `singles` enum('Yes','No') DEFAULT 'No',
  `ship_id` INT(11) DEFAULT '0',
  `cruiseline_id` INT(11) DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `FSIndex` (`cruise_id`,`factory_id`,`id`,`validity_date_end`,`validity_date_start`,`checked`,`withdrawn`),
  KEY `FSDate` (`id`,`validity_date_start`,`validity_date_end`,`factory_id`),
  KEY `factory_id` (`factory_id`),
  KEY `priority_id` (`priority_id`),
  KEY `cruise_id` (`cruise_id`),
  KEY `currency_id` (`currency_id`),
  KEY `factoryid_cruiseid` (`cruise_id`,`factory_id`),
  KEY `factoryid_mainspecial_withdrawn_validitydates` (`factory_id`,`main_special`,`validity_date_end`,`validity_date_start`,`withdrawn`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
 
 
# Dump OF TABLE companionpricing
# ------------------------------------------------------------
 
DROP TABLE IF EXISTS `companionpricing`;
 
CREATE TABLE `companionpricing` (
  `id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `special_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
  `price_inside` DOUBLE(9,2) DEFAULT '0.00',
  `price_outside` DOUBLE(9,2) DEFAULT '0.00',
  `price_balcony` DOUBLE(9,2) DEFAULT '0.00',
  `price_suites` DOUBLE(9,2) DEFAULT '0.00',
  PRIMARY KEY (`id`),
  KEY `FSLPIndex` (`id`,`special_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
 
 
# Dump OF TABLE leadpricing
# ------------------------------------------------------------
 
DROP TABLE IF EXISTS `leadpricing`;
 
CREATE TABLE `leadpricing` (
  `id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `special_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
  `price_inside` DOUBLE(9,2) DEFAULT '0.00',
  `price_outside` DOUBLE(9,2) DEFAULT '0.00',
  `price_balcony` DOUBLE(9,2) DEFAULT '0.00',
  `price_suites` DOUBLE(9,2) DEFAULT '0.00',
  PRIMARY KEY (`id`),
  KEY `FSLPIndex` (`id`,`special_id`),
  KEY `specialid` (`special_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
 
 
# Dump OF TABLE specialsmultipricing
# ------------------------------------------------------------
 
DROP TABLE IF EXISTS `specialsmultipricing`;
 
CREATE TABLE `specialsmultipricing` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `special_id` INT(11) DEFAULT NULL,
  `sailingdate` DATE DEFAULT '0000-00-00',
  `inside` VARCHAR(16) DEFAULT NULL,
  `outside` VARCHAR(16) DEFAULT NULL,
  `balcony` VARCHAR(16) DEFAULT NULL,
  `suite` VARCHAR(16) DEFAULT NULL,
  UNIQUE KEY `id` (`id`),
  UNIQUE KEY `specialid_sailingdate` (`special_id`,`sailingdate`),
  KEY `special_id` (`special_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
 
 
# Dump OF TABLE specialitineraries
# ------------------------------------------------------------
 
DROP TABLE IF EXISTS `specialitineraries`;
 
CREATE TABLE `specialitineraries` (
  `id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `special_id` INT(11) UNSIGNED NOT NULL DEFAULT '1',
  `day` tinyint(3) NOT NULL DEFAULT '1',
  `activity` VARCHAR(60) NOT NULL DEFAULT '',
  `starttime` VARCHAR(20) NOT NULL DEFAULT '',
  `endtime` VARCHAR(20) NOT NULL DEFAULT '',
  `type` enum('pre','post') NOT NULL DEFAULT 'pre',
  `order` tinyint(3) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  KEY `special_id` (`special_id`,`id`),
  KEY `special_id_type` (`special_id`,`type`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
 
 
# Dump OF TABLE specialspricing
# ------------------------------------------------------------
 
DROP TABLE IF EXISTS `specialspricing`;
 
CREATE TABLE `specialspricing` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `factory_id` INT(11) NOT NULL DEFAULT '0',
  `special_id` INT(11) NOT NULL DEFAULT '0',
  `cruise_id` INT(11) NOT NULL DEFAULT '0',
  `cabin_id` INT(11) NOT NULL DEFAULT '0',
  `price` DOUBLE(9,2) DEFAULT NULL,
  `portcharges` CHAR(1) NOT NULL DEFAULT 'e',
  `currency_id` INT(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  KEY `FSPricingIndex` (`cabin_id`,`cruise_id`,`factory_id`,`special_id`,`id`),
  KEY `specialid` (`special_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
 
 
# Dump OF TABLE itineraries
# ------------------------------------------------------------
 
DROP TABLE IF EXISTS `itineraries`;
 
CREATE TABLE `itineraries` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `cruise_id` INT(11) NOT NULL DEFAULT '0',
  `day` INT(11) DEFAULT NULL,
  `port_id` INT(11) NOT NULL DEFAULT '0',
  `arrive` VARCHAR(50) DEFAULT NULL,
  `depart` VARCHAR(50) DEFAULT NULL,
  `portorder` SMALLINT(6) NOT NULL DEFAULT '100',
  PRIMARY KEY (`id`),
  KEY `ItineriesIndex` (`cruise_id`,`id`,`port_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
 
 
# Dump OF TABLE kidsschedules
# ------------------------------------------------------------
 
DROP TABLE IF EXISTS `kidsschedules`;
 
CREATE TABLE `kidsschedules` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `cruiseline_id` INT(11) NOT NULL DEFAULT '0',
  `name` VARCHAR(100) NOT NULL DEFAULT '',
  `description` text,
  PRIMARY KEY (`id`),
  KEY `cruiseline_id` (`cruiseline_id`,`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
 
 
# Dump OF TABLE kidsprograms
# ------------------------------------------------------------
 
DROP TABLE IF EXISTS `kidsprograms`;
 
CREATE TABLE `kidsprograms` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `cruiseline_id` INT(11) NOT NULL DEFAULT '0',
  `name` VARCHAR(100) NOT NULL DEFAULT '',
  `description` text NOT NULL,
  `photo` VARCHAR(100) DEFAULT NULL,
  `photo_order` INT(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `cruiseline_id` (`cruiseline_id`,`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
 
 
# Dump OF TABLE menus
# ------------------------------------------------------------
 
DROP TABLE IF EXISTS `menus`;
 
CREATE TABLE `menus` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `cruiseline_id` INT(11) NOT NULL DEFAULT '0',
  `name` VARCHAR(100) NOT NULL DEFAULT '',
  `description` text NOT NULL,
  PRIMARY KEY (`id`),
  KEY `cruiseline_id` (`cruiseline_id`,`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
 
 
# Dump OF TABLE months
# ------------------------------------------------------------
 
DROP TABLE IF EXISTS `months`;
 
CREATE TABLE `months` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(100) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
 
 
# Dump OF TABLE latlong
# ------------------------------------------------------------
 
DROP TABLE IF EXISTS `latlong`;
 
CREATE TABLE `latlong` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `port_id` INT(11) DEFAULT NULL,
  `lat` FLOAT(10,6) DEFAULT NULL,
  `long` FLOAT(10,6) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uniqueport` (`port_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
 
 
# Dump OF TABLE ports
# ------------------------------------------------------------
 
DROP TABLE IF EXISTS `ports`;
 
CREATE TABLE `ports` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `destination_id` INT(11) NOT NULL DEFAULT '0',
  `name` VARCHAR(100) NOT NULL DEFAULT '',
  `description` text NOT NULL,
  `photo` VARCHAR(100) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `PortsIndex` (`destination_id`,`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
 
 
# Dump OF TABLE priceguide
# ------------------------------------------------------------
 
DROP TABLE IF EXISTS `priceguide`;
 
CREATE TABLE `priceguide` (
  `id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `sailing_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
  `inside_cabin` FLOAT DEFAULT NULL,
  `outside_cabin` FLOAT DEFAULT NULL,
  `balcony` FLOAT DEFAULT NULL,
  `suite` FLOAT DEFAULT NULL,
  `exchange_rate` FLOAT DEFAULT NULL,
  `last_update` DATE DEFAULT NULL,
  `update_name` VARCHAR(20) DEFAULT NULL,
  `currency` VARCHAR(12) DEFAULT NULL,
  `factory_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
  `cruiseline_id` INT(11) DEFAULT NULL,
  `use_cl_currency` enum('0','1') NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `PGIndex` (`factory_id`,`id`,`sailing_id`),
  KEY `sailingid_factoryid_cruiselineid` (`sailing_id`,`factory_id`,`cruiseline_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
 
 
# Dump OF TABLE sailingdates
# ------------------------------------------------------------
 
DROP TABLE IF EXISTS `sailingdates`;
 
CREATE TABLE `sailingdates` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `cruise_id` INT(11) NOT NULL DEFAULT '0',
  `sailingdate` DATE NOT NULL DEFAULT '0000-00-00',
  `embarkport_id` INT(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `SDIndex` (`cruise_id`,`id`,`sailingdate`,`embarkport_id`),
  KEY `cruise_id` (`cruise_id`),
  KEY `sailingdate` (`embarkport_id`),
  KEY `cruise_id_sailingdate` (`cruise_id`,`sailingdate`),
  KEY `sailingdate_only` (`sailingdate`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
 
 
# Dump OF TABLE seasons
# ------------------------------------------------------------
 
DROP TABLE IF EXISTS `seasons`;
 
CREATE TABLE `seasons` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `destination_id` INT(11) NOT NULL DEFAULT '0',
  `start_month` INT(11) NOT NULL DEFAULT '0',
  `end_month` INT(11) NOT NULL DEFAULT '0',
  `name` VARCHAR(50) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `SeasonsIndex` (`destination_id`,`id`,`end_month`,`start_month`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
 
 
# Dump OF TABLE shipphotos
# ------------------------------------------------------------
 
DROP TABLE IF EXISTS `shipphotos`;
 
CREATE TABLE `shipphotos` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `ship_id` INT(11) NOT NULL DEFAULT '0',
  `name` VARCHAR(100) NOT NULL DEFAULT '',
  `description` text,
  `photo` VARCHAR(100) NOT NULL DEFAULT '',
  `photo_order` INT(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ship_id` (`ship_id`,`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
 
 
# Dump OF TABLE ships
# ------------------------------------------------------------
 
DROP TABLE IF EXISTS `ships`;
 
CREATE TABLE `ships` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `cruiseline_id` INT(11) NOT NULL DEFAULT '0',
  `name` VARCHAR(250) NOT NULL DEFAULT '',
  `thumbnail` VARCHAR(50) DEFAULT NULL,
  `mainimage` VARCHAR(50) DEFAULT NULL,
  `maidenvoyage` VARCHAR(100) DEFAULT NULL,
  `refurbished` VARCHAR(100) DEFAULT NULL,
  `tonnage` VARCHAR(50) DEFAULT NULL,
  `length` VARCHAR(50) DEFAULT NULL,
  `beam` VARCHAR(50) DEFAULT NULL,
  `draft` VARCHAR(50) DEFAULT NULL,
  `speed` VARCHAR(50) DEFAULT NULL,
  `ship_rego` VARCHAR(150) DEFAULT NULL,
  `pass_capacity` VARCHAR(50) DEFAULT NULL,
  `pass_space` VARCHAR(50) DEFAULT NULL,
  `crew_size` VARCHAR(50) DEFAULT NULL,
  `nat_crew` VARCHAR(100) DEFAULT NULL,
  `nat_officers` VARCHAR(100) DEFAULT NULL,
  `nat_dining` VARCHAR(100) DEFAULT NULL,
  `description` text,
  `starrating` INT(11) DEFAULT NULL,
  `cruisetype_id` tinyint(2) UNSIGNED NOT NULL DEFAULT '0',
  `currency_id` INT(11) UNSIGNED DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ShipsIndex` (`cruiseline_id`,`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
 
 
# Dump OF TABLE starrating
# ------------------------------------------------------------
 
DROP TABLE IF EXISTS `starrating`;
 
CREATE TABLE `starrating` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `rating` VARCHAR(25) DEFAULT NULL,
  `order` tinyint(4) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
 
 
# Dump OF TABLE tipping
# ------------------------------------------------------------
 
DROP TABLE IF EXISTS `tipping`;
 
CREATE TABLE `tipping` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `cruiseline_id` INT(11) NOT NULL DEFAULT '0',
  `name` VARCHAR(100) NOT NULL DEFAULT '',
  `description` text NOT NULL,
  PRIMARY KEY (`id`),
  KEY `cruiseline_id` (`cruiseline_id`,`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
 
 
# Dump OF TABLE winelists
# ------------------------------------------------------------
 
DROP TABLE IF EXISTS `winelists`;
 
CREATE TABLE `winelists` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `cruiseline_id` INT(11) NOT NULL DEFAULT '0',
  `name` VARCHAR(100) NOT NULL DEFAULT '',
  `description` text,
  PRIMARY KEY (`id`),
  KEY `cruiseline_id` (`cruiseline_id`,`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
 
 
 
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;