Differences

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

--- structure [2012/12/31 12:53]
cruisefactory [XML Layout]
+++ structure [2018/05/24 09:51] (current)
cruisefactory
@@ Line 3: / Line 3: @@
 ===== XML Layout =====
-The XML is layed out exactly as below, although this example is missing the table column elements which are listed below for each table.
+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.
 <code xml>
 <database>
@@ Line 18: / Line 18: @@
 </database>
 </code>
+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 =====
@@ Line 192: / Line 192: @@
 <price_balcony> double </price_balcony>
 <price_suites> double </price_suites>
+</code>
+==== latlong ====
+<code xml>
+<id> int </id>
+<port_id> int </port_id>
+<lat> float </lat>
+<long> float </long>
 </code>
@@ Line 382: / Line 390: @@
 <name> varchar (max 100) </name>
 <description> text </description>
+</code>
+==== amended_conditions ====
+<code xml>
+<id> int </id>
+<sailingdate_id> int </sailingdate_id>
+<disclaimer> varchar (max 255) </disclaimer>
+<conditions> text </conditions>
 </code>

Cruise Factory XML