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

Both sides previous revision Previous revision
Next revision 		Previous revision
download_example_schema [2012/12/31 12:58]
cruisefactory 		download_example_schema [2014/09/02 14:07] (current)
cruisefactory
Line 30: Line 30:
   PRIMARY KEY (`id`),   PRIMARY KEY (`id`),
   KEY `AmenitiesIndex` (`id`,`ship_id`)   KEY `AmenitiesIndex` (`id`,`ship_id`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  
  
Line 49: Line 49:
   PRIMARY KEY (`id`),   PRIMARY KEY (`id`),
   KEY `CabinsIndex` (`id`,`ship_id`)   KEY `CabinsIndex` (`id`,`ship_id`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  
  
Line 72: Line 72:
   `starrating` int(11) DEFAULT NULL,   `starrating` int(11) DEFAULT NULL,
   PRIMARY KEY (`id`)   PRIMARY KEY (`id`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  
  
Line 103: Line 103:
   KEY `destination_id_id` (`destination_id`,`id`),   KEY `destination_id_id` (`destination_id`,`id`),
   KEY `id_cruiselineid` (`id`,`cruiseline_id`)   KEY `id_cruiselineid` (`id`,`cruiseline_id`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  
  
Line 116: Line 116:
   `name` varchar(100) NOT NULL DEFAULT '',   `name` varchar(100) NOT NULL DEFAULT '',
   PRIMARY KEY (`id`)   PRIMARY KEY (`id`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  
  
Line 131: Line 131:
   `sign` varchar(11) DEFAULT NULL,   `sign` varchar(11) DEFAULT NULL,
   PRIMARY KEY (`id`)   PRIMARY KEY (`id`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  
  
Line 150: Line 150:
   KEY `ship_id` (`ship_id`),   KEY `ship_id` (`ship_id`),
   KEY `DeckPlansIndex` (`id`,`ship_id`)   KEY `DeckPlansIndex` (`id`,`ship_id`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  
  
Line 171: Line 171:
   PRIMARY KEY (`id`),   PRIMARY KEY (`id`),
   KEY `featured` (`featured`)   KEY `featured` (`featured`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  
  
Line 189: Line 189:
   KEY `cruiseline_id` (`cruiseline_id`),   KEY `cruiseline_id` (`cruiseline_id`),
   KEY `DiningIndex` (`cruiseline_id`,`id`)   KEY `DiningIndex` (`cruiseline_id`,`id`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  
  
Line 207: Line 207:
   KEY `cruiseline_id` (`cruiseline_id`),   KEY `cruiseline_id` (`cruiseline_id`),
   KEY `DiningTimesIndex` (`cruiseline_id`,`id`)   KEY `DiningTimesIndex` (`cruiseline_id`,`id`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  
  
Line 223: Line 223:
   KEY `ship_id` (`ship_id`),   KEY `ship_id` (`ship_id`),
   KEY `FacilitiesIndex` (`id`,`ship_id`)   KEY `FacilitiesIndex` (`id`,`ship_id`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  
  
Line 243: Line 243:
   KEY `SDIndex` (`factory_id`,`special_id`,`sailingdate_id`),   KEY `SDIndex` (`factory_id`,`special_id`,`sailingdate_id`),
   KEY `sailingdateid_specialid_factoryid` (`factory_id`,`special_id`,`sailingdate_id`)   KEY `sailingdateid_specialid_factoryid` (`factory_id`,`special_id`,`sailingdate_id`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  
  
Line 301: Line 301:
   KEY `factoryid_cruiseid` (`cruise_id`,`factory_id`),   KEY `factoryid_cruiseid` (`cruise_id`,`factory_id`),
   KEY `factoryid_mainspecial_withdrawn_validitydates` (`factory_id`,`main_special`,`validity_date_end`,`validity_date_start`,`withdrawn`)   KEY `factoryid_mainspecial_withdrawn_validitydates` (`factory_id`,`main_special`,`validity_date_end`,`validity_date_start`,`withdrawn`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  
  
Line 319: Line 319:
   PRIMARY KEY (`id`),   PRIMARY KEY (`id`),
   KEY `FSLPIndex` (`id`,`special_id`)   KEY `FSLPIndex` (`id`,`special_id`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  
  
Line 338: Line 338:
   KEY `FSLPIndex` (`id`,`special_id`),   KEY `FSLPIndex` (`id`,`special_id`),
   KEY `specialid` (`special_id`)   KEY `specialid` (`special_id`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  
  
Line 358: Line 358:
   UNIQUE KEY `specialid_sailingdate` (`special_id`,`sailingdate`),   UNIQUE KEY `specialid_sailingdate` (`special_id`,`sailingdate`),
   KEY `special_id` (`special_id`)   KEY `special_id` (`special_id`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  
  
Line 379: Line 379:
   KEY `special_id` (`special_id`,`id`),   KEY `special_id` (`special_id`,`id`),
   KEY `special_id_type` (`special_id`,`type`)   KEY `special_id_type` (`special_id`,`type`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  
  
Line 400: Line 400:
   KEY `FSPricingIndex` (`cabin_id`,`cruise_id`,`factory_id`,`special_id`,`id`),   KEY `FSPricingIndex` (`cabin_id`,`cruise_id`,`factory_id`,`special_id`,`id`),
   KEY `specialid` (`special_id`)   KEY `specialid` (`special_id`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  
  
Line 419: Line 419:
   PRIMARY KEY (`id`),   PRIMARY KEY (`id`),
   KEY `ItineriesIndex` (`cruise_id`,`id`,`port_id`)   KEY `ItineriesIndex` (`cruise_id`,`id`,`port_id`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  
  
Line 435: Line 435:
   PRIMARY KEY (`id`),   PRIMARY KEY (`id`),
   KEY `cruiseline_id` (`cruiseline_id`,`id`)   KEY `cruiseline_id` (`cruiseline_id`,`id`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  
  
Line 453: Line 453:
   PRIMARY KEY (`id`),   PRIMARY KEY (`id`),
   KEY `cruiseline_id` (`cruiseline_id`,`id`)   KEY `cruiseline_id` (`cruiseline_id`,`id`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  
  
Line 469: Line 469:
   PRIMARY KEY (`id`),   PRIMARY KEY (`id`),
   KEY `cruiseline_id` (`cruiseline_id`,`id`)   KEY `cruiseline_id` (`cruiseline_id`,`id`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  
  
Line 482: Line 482:
   `name` varchar(100) NOT NULL DEFAULT '',   `name` varchar(100) NOT NULL DEFAULT '',
   PRIMARY KEY (`id`)   PRIMARY KEY (`id`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;+) 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;
  
  
Line 499: Line 515:
   PRIMARY KEY (`id`),   PRIMARY KEY (`id`),
   KEY `PortsIndex` (`destination_id`,`id`)   KEY `PortsIndex` (`destination_id`,`id`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  
  
Line 525: Line 541:
   KEY `PGIndex` (`factory_id`,`id`,`sailing_id`),   KEY `PGIndex` (`factory_id`,`id`,`sailing_id`),
   KEY `sailingid_factoryid_cruiselineid` (`sailing_id`,`factory_id`,`cruiseline_id`)   KEY `sailingid_factoryid_cruiselineid` (`sailing_id`,`factory_id`,`cruiseline_id`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  
  
Line 545: Line 561:
   KEY `cruise_id_sailingdate` (`cruise_id`,`sailingdate`),   KEY `cruise_id_sailingdate` (`cruise_id`,`sailingdate`),
   KEY `sailingdate_only` (`sailingdate`)   KEY `sailingdate_only` (`sailingdate`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  
  
Line 562: Line 578:
   PRIMARY KEY (`id`),   PRIMARY KEY (`id`),
   KEY `SeasonsIndex` (`destination_id`,`id`,`end_month`,`start_month`)   KEY `SeasonsIndex` (`destination_id`,`id`,`end_month`,`start_month`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  
  
Line 580: Line 596:
   PRIMARY KEY (`id`),   PRIMARY KEY (`id`),
   KEY `ship_id` (`ship_id`,`id`)   KEY `ship_id` (`ship_id`,`id`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  
  
Line 615: Line 631:
   PRIMARY KEY (`id`),   PRIMARY KEY (`id`),
   KEY `ShipsIndex` (`cruiseline_id`,`id`)   KEY `ShipsIndex` (`cruiseline_id`,`id`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  
  
Line 629: Line 645:
   `order` tinyint(4) DEFAULT NULL,   `order` tinyint(4) DEFAULT NULL,
   PRIMARY KEY (`id`)   PRIMARY KEY (`id`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  
  
Line 645: Line 661:
   PRIMARY KEY (`id`),   PRIMARY KEY (`id`),
   KEY `cruiseline_id` (`cruiseline_id`,`id`)   KEY `cruiseline_id` (`cruiseline_id`,`id`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  
  
Line 661: Line 677:
   PRIMARY KEY (`id`),   PRIMARY KEY (`id`),
   KEY `cruiseline_id` (`cruiseline_id`,`id`)   KEY `cruiseline_id` (`cruiseline_id`,`id`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  
  
download_example_schema.1356919093.txt.gz · Last modified: 2012/12/31 12:58 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