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

The XML is layed out in a basic <xml> <database> <table>

<row>
	...
</row>

</table> <delete>

<ids>
	...
</ids>

</delete> </database> </xml>

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