Cruise Factory XML

User Tools

Site Tools

Trace:
download_example_schema

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Next revision 		Previous revision
download_example_schema [2012/12/31 12:11]
cruisefactory created 		download_example_schema [2014/09/02 14:07] (current)
cruisefactory
Line 1: Line 1:
-====== Download example schema ======+====== Download Example Schema ======
 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. 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.
  
-[[http://feeds.cruisefactory.net/downloads/mysql-database-example.sql|Click here]] to download the example schema (MySQL).+Click the link at the top of the example below to download the file. 
 + 
 +<file sql 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 */; 
 +</file>
download_example_schema.1356916260.txt.gz · Last modified: 2012/12/31 12:11 by cruisefactory

Page Tools

Except where otherwise noted, content on this wiki is licensed under the following license: GNU Free Documentation License 1.3
GNU Free Documentation License 1.3 Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki