====== XML Structure ====== //Please note that all date fields from Cruise Factory are date only and do not contain the time.// ===== XML Layout ===== The XML is layed out exactly as below, although this example is missing the table column elements (rows) which are [[structure#table_layouts|listed below]] for each table. ...
... The above code is for the //increment// data service, although everything apart from the extra //**delete**// element is the same as the regular //full// service. Read up on the differences between the regular and incremental services [[importing#types_of_data_services|here]]. ===== Table Layouts ===== ==== amenities ==== int int varchar (max 150) ==== cabins ==== int int varchar (max 100) text varchar (max 150) varchar (max 150) int ==== cruiselines ==== int varchar (max 200) varchar (max 200) varchar (max 100) varchar (max 200) text base64 encoded binary varchar (max 50) varchar (max 50) varchar (max 255) varchar (max 255) int ==== cruises ==== int int int int int int varchar (max 80) varchar (max 250) text varchar (max 100) decimal int int ==== cruisetypes ==== int varchar (max 100) ==== currencies ==== int varchar (max 50) varchar (max 48) varchar (max 11) ==== deckplans ==== int int varchar (max 100) varchar (max 100) varchar (max 100) varchar (max 100) ==== destinations ==== int varchar (max 100) text varchar (max 100) varchar (max 100) varchar (max 100) varchar (max 100) char text ==== dining ==== int int varchar (max 100) text varchar (max 50) ==== diningtimes ==== int int varchar (max 50) varchar (max 50) varchar (max 50) ==== facilities ==== int int varchar (max 150) ==== specialsailingdates ==== int int int int ==== specials ==== int int int int varchar (max 100) longtext longtext longtext varchar (max 100) decimal int int char char int date date char text varchar (max 255) double date int char varchar (max 255) char char tinyint varchar (max 32) char char char text varchar (max 255) text enum( 'Yes','No' ) enum( 'Yes','No' ) ==== companionpricing ==== int int double double double double ==== latlong ==== int int float float ==== leadpricing ==== int int double double double double ==== specialsmultipricing ==== int int date varchar (max 16) varchar (max 16) varchar (max 16) varchar (max 16) ==== specialitineraries ==== int int int varchar (max 60) varchar (max 20) varchar (max 20) enum('pre','post') int ==== specialspricing ==== int int int int int double char int ==== itineraries ==== int int int int varchar (max 50) varchar (max 50) int ==== kidsschedules ==== int int varchar (max 100) text ==== kidsprograms ==== int int varchar (max 100) text varchar (max 100) int ==== menus ==== int int varchar (max 100) text ==== months ==== int varchar (max 100) ==== ports ==== int int varchar (max 100) text varchar (max 100) ==== priceguide ==== int int float float float float float date varchar (max 20) varchar (max 12) int int ==== sailingdates ==== int int date int ==== seasons ==== int int int int varchar (max 50) ==== shipphotos ==== int int varchar (max 100) text varchar (max 100) int ==== ships ==== int int varchar (max 250) varchar (max 50) varchar (max 50) varchar (max 100) varchar (max 100) varchar (max 50) varchar (max 50) varchar (max 50) varchar (max 50) varchar (max 50) varchar (max 150) varchar (max 50) varchar (max 50) varchar (max 50) varchar (max 100) varchar (max 100) varchar (max 100) text int int int ==== starratings ==== int varchar (max 25) int ==== tipping ==== int int varchar (max 100) text ==== winelists ==== int int varchar (max 100) text ==== amended_conditions ==== int int varchar (max 255) text