Please note that all date fields from Cruise Factory are date only and do not contain the time.

The XML is layed out exactly as below, although this example is missing the table column elements (rows) which are listed below for each table.

<database>
<table>
	<row>
		...
	</row>
</table>
<delete>
	<ids>
		...
	</ids>
</delete>
</database>

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 here.

<id> int </id>
<ship_id> int </ship_id>
<name> varchar (max 150) </name>

<id> int </id>
<ship_id> int </ship_id>
<name> varchar (max 100) </name>
<description> text </description>
<image> varchar (max 150) </image>
<photo> varchar (max 150) </photo>
<cabin_order> int </cabin_order>

<id> int </id>
<name> varchar (max 200) </name>
<location> varchar (max 200) </location>
<booking_email> varchar (max 100) </booking_email>
<brief_desc> varchar (max 200) </brief_desc>
<company_bio> text </company_bio>
<logodata> base64 encoded binary </logodata>
<logosize> varchar (max 50) </logosize>
<logotype> varchar (max 50) </logotype>
<url> varchar (max 255) </url>
<video_url> varchar (max 255) </video_url>
<star_rating> int </star_rating>

<id> int </id>
<cruiseline_id> int </cruiseline_id>
<destination_id> int </destination_id>
<ship_id> int </ship_id>
<cruisetype_id> int </cruisetype_id>
<length> int </length>
<name> varchar (max 80) </name>
<brief_description> varchar (max 250) </brief_description>
<description> text </description>
<photo> varchar (max 100) </photo>
<start_price> decimal </start_price>
<currency_id> int </currency_id>
<cruise_order> int </cruise_order>

<id> int </id>
<name> varchar (max 100) </name>

<id> int </id>
<name> varchar (max 50) </name>
<description> varchar (max 48) </description>
<sign> varchar (max 11) </sign>

<id> int </id>
<ship_id> int </ship_id>
<level> varchar (max 100) </level>
<name> varchar (max 100) </name>
<image> varchar (max 100) </image>
<colorcode> varchar (max 100) </colorcode>

<id> int </id>
<name> varchar (max 100) </name>
<description> text </description>
<image> varchar (max 100) </image>
<banner> varchar (max 100) </banner>
<map_thumb> varchar (max 100) </map_thumb>
<map_large> varchar (max 100) </map_large>
<featured> char </featured>
<featured_text> text </featured_text>

<id> int </id>
<cruiseline_id> int </cruiseline_id>
<name> varchar (max 100) </name>
<introduction> text </introduction>
<photo> varchar (max 50) </photo>

<id> int </id>
<cruiseline_id> int </cruiseline_id>
<meal> varchar (max 50) </meal>
<normal_sitting> varchar (max 50) </normal_sitting>
<late_sitting> varchar (max 50) </late_sitting>

<id> int </id>
<ship_id> int </ship_id>
<name> varchar (max 150) </name>

<id> int </id>
<factory_id> int </factory_id>
<special_id> int </special_id>
<sailingdate_id> int </sailingdate_id>

<id> int </id>
<cruise_id> int </cruise_id>
<factory_id> int </factory_id>
<priority_id> int </priority_id>
<special_header> varchar (max 100) </special_header>
<special_text> longtext </special_text>
<special_brief> longtext </special_brief>
<instructions> longtext </instructions>
<booking_email> varchar (max 100) </booking_email>
<start_price> decimal </start_price>
<currency_id> int </currency_id>
<cruise_order> int </cruise_order>
<main_special> char </main_special>
<dest_special> char </dest_special>
<special_order> int </special_order>
<validity_date_end> date </validity_date_end>
<validity_date_start> date </validity_date_start>
<checked> char </checked>
<internal_notes> text </internal_notes>
<advert_code> varchar (max 255) </advert_code>
<exchange_rate> double </exchange_rate>
<ex_rate_date> date </ex_rate_date>
<currency_id_ref> int </currency_id_ref>
<create_pdf> char </create_pdf>
<uploaded_pdf> varchar (max 255) </uploaded_pdf>
<withdrawn> char </withdrawn>
<quicksave> char </quicksave>
<status> tinyint </status>
<type> varchar (max 32) </type>
<escorted> char </escorted>
<wedding> char </wedding>
<agentonly> char </agentonly>
<special_conditions> text </special_conditions>
<specialpdf_filename> varchar (max 255) </specialpdf_filename>
<specialpdf_contents> text </specialpdf_contents>
<seniors> enum( 'Yes','No' ) </seniors>
<singles> enum( 'Yes','No' ) </singles>

<id> int </id>
<special_id> int </special_id>
<price_inside> double </price_inside>
<price_outside> double </price_outside>
<price_balcony> double </price_balcony>
<price_suites> double </price_suites>

<id> int </id>
<port_id> int </port_id>
<lat> float </lat>
<long> float </long>

<id> int </id>
<special_id> int </special_id>
<price_inside> double </price_inside>
<price_outside> double </price_outside>
<price_balcony> double </price_balcony>
<price_suites> double </price_suites>

<id> int </id>
<special_id> int </special_id>
<sailingdate> date </sailingdate>
<inside> varchar (max 16) </inside>
<outside> varchar (max 16) </outside>
<balcony> varchar (max 16) </balcony>
<suite> varchar (max 16) </suite>

<id> int </id>
<special_id> int </special_id>
<day> int </day>
<activity> varchar (max 60) </activity>
<starttime> varchar (max 20) </starttime>
<endtime> varchar (max 20) </endtime>
<type> enum('pre','post') </type>
<order> int </order>

<id> int </id>
<factory_id> int </factory_id>
<special_id> int </special_id>
<cruise_id> int </cruise_id>
<cabin_id> int </cabin_id>
<price> double </price>
<portcharges> char </portcharges>
<currency_id> int </currency_id>

<id> int </id>
<cruise_id> int </cruise_id>
<day> int </day>
<port_id> int </port_id>
<arrive> varchar (max 50) </arrive>
<depart> varchar (max 50) </depart>
<portorder> int </portorder>

<id> int </id>
<cruiseline_id> int </cruiseline_id>
<name> varchar (max 100) </name>
<description> text </description>

<id> int </id>
<cruiseline_id> int </cruiseline_id>
<name> varchar (max 100) </name>
<description> text </description>
<photo> varchar (max 100) </photo>
<photo_order> int </photo_order>

<id> int </id>
<cruiseline_id> int </cruiseline_id>
<name> varchar (max 100) </name>
<description> text </description>

<id> int </id>
<name> varchar (max 100) </name>

<id> int </id>
<destination_id> int </destination_id>
<name> varchar (max 100) </name>
<description> text </description>
<photo> varchar (max 100) </photo>

<id> int </id>
<sailing_id> int </sailing_id>
<inside_cabin> float </inside_cabin>
<outside_cabin> float </outside_cabin>
<balcony> float </balcony>
<suite> float </suite>
<exchange_rate> float </exchange_rate>
<last_update> date </last_update>
<update_name> varchar (max 20) </update_name>
<currency> varchar (max 12) </currency>
<factory_id> int </factory_id>
<cruiseline_id> int </cruiseline_id>

<id> int </id>
<cruise_id> int </cruise_id>
<sailingdate> date </sailingdate>
<embarkport_id> int </embarkport_id>

<id> int </id>
<destination_id> int </destination_id>
<start_month> int </start_month>
<end_month> int </end_month>
<name> varchar (max 50) </name>

<id> int </id>
<ship_id> int </ship_id>
<name> varchar (max 100) </name>
<description> text </description>
<photo> varchar (max 100) </photo>
<photo_order> int </photo_order>

<id> int </id>
<cruiseline_id> int </cruiseline_id>
<name> varchar (max 250) </name>
<thumbnail> varchar (max 50) </thumbnail>
<mainimage> varchar (max 50) </mainimage>
<maidenvoyage> varchar (max 100) </maidenvoyage>
<refurbished> varchar (max 100) </refurbished>
<tonnage> varchar (max 50) </tonnage>
<length> varchar (max 50) </length>
<beam> varchar (max 50) </beam>
<draft> varchar (max 50) </draft>
<speed> varchar (max 50) </speed>
<ship_rego> varchar (max 150) </ship_rego>
<pass_capacity> varchar (max 50) </pass_capacity>
<pass_space> varchar (max 50) </pass_space>
<crew_size> varchar (max 50) </crew_size>
<nat_crew> varchar (max 100) </nat_crew>
<nat_officers> varchar (max 100) </nat_officers>
<nat_dining> varchar (max 100) </nat_dining>
<description> text </description>
<star_rating> int </star_rating>
<cruisetype_id> int </cruisetype_id>
<currency_id> int </currency_id>

<id> int </id>
<rating> varchar (max 25) </rating>
<order> int </order>

<id> int </id>
<cruiseline_id> int </cruiseline_id>
<name> varchar (max 100) </name>
<description> text </description>

<id> int </id>
<cruiseline_id> int </cruiseline_id>
<name> varchar (max 100) </name>
<description> text </description>

<id> int </id>
<sailingdate_id> int </sailingdate_id>
<disclaimer> varchar (max 255) </disclaimer>
<conditions> text </conditions>