Working on SQL Examiner Library...

2 files changed, 2940 insertions, 0 deletions

diff --git a/Software/DB/SQLExaminer Projects/Override Tables.sdeproj b/Software/DB/SQLExaminer Projects/Override Tables.sdeproj
new file mode 100644
index 000000000..1343686d3
--- /dev/null
+++ b/Software/DB/SQLExaminer Projects/Override Tables.sdeproj
@@ -0,0 +1,1470 @@
+<SqlDataExaminer version="21">
+  <Sources>
+    <Source id="1">
+      <EngineType>MsSqlServer</EngineType>
+      <StorageType>LiveDb</StorageType>
+      <ServerName>localhost\sqlexpress</ServerName>
+      <Database>Tango</Database>
+      <WinAuth>False</WinAuth>
+      <AzurePwd>False</AzurePwd>
+      <Login>Synchronizer</Login>
+      <Password>Aa123456</Password>
+      <SavePasswords>true</SavePasswords>
+    </Source>
+    <Source id="2">
+      <EngineType>MsSqlServer</EngineType>
+      <StorageType>LiveDb</StorageType>
+      <ServerName>twine.local\sqltwine</ServerName>
+      <Database>Tango</Database>
+      <WinAuth>True</WinAuth>
+      <AzurePwd>False</AzurePwd>
+    </Source>
+  </Sources>
+  <Items>
+    <Item name="dbo.ACTION_TYPES" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="CODE" />
+        <Column name="NAME" />
+        <Column name="DESCRIPTION" />
+      </Columns>
+    </Item>
+    <Item name="dbo.ADDRESSES" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="DELETED" />
+        <Column name="ADDRESS_STRING" />
+        <Column name="LOCALITY" />
+        <Column name="COUNTRY" />
+        <Column name="CITY" />
+        <Column name="STATE" />
+        <Column name="COUNTRY_CODE" />
+        <Column name="POSTAL_CODE" />
+      </Columns>
+    </Item>
+    <Item name="dbo.APPLICATION_DISPLAY_PANEL_VERSIONS" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="VERSION" />
+        <Column name="NAME" />
+      </Columns>
+    </Item>
+    <Item name="dbo.APPLICATION_FIRMWARE_VERSIONS" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="VERSION" />
+        <Column name="NAME" />
+      </Columns>
+    </Item>
+    <Item name="dbo.APPLICATION_OS_VERSIONS" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="VERSION" />
+        <Column name="NAME" />
+      </Columns>
+    </Item>
+    <Item name="dbo.APPLICATION_VERSIONS" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="VERSION" />
+        <Column name="NAME" />
+      </Columns>
+    </Item>
+    <Item name="dbo.BRUSH_STOPS" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="SEGMENT_GUID" />
+        <Column name="COLOR_SPACE_GUID" />
+        <Column name="OFFSET_PERCENT" />
+        <Column name="STOP_INDEX" />
+        <Column name="CYAN" />
+        <Column name="MAGENTA" />
+        <Column name="YELLOW" />
+        <Column name="BLACK" />
+        <Column name="RED" />
+        <Column name="GREEN" />
+        <Column name="BLUE" />
+        <Column name="L" />
+        <Column name="A" />
+        <Column name="B" />
+        <Column name="V0" />
+        <Column name="V1" />
+        <Column name="V2" />
+        <Column name="V3" />
+        <Column name="V4" />
+        <Column name="V5" />
+        <Column name="V6" />
+        <Column name="V7" />
+        <Column name="CORRECTED" />
+        <Column name="COLOR_CATALOG_GUID" />
+        <Column name="COLOR_CATALOG_CODE" />
+      </Columns>
+    </Item>
+    <Item name="dbo.CARTRIDGE_TYPES" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="CODE" />
+        <Column name="NAME" />
+      </Columns>
+    </Item>
+    <Item name="dbo.CATS" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="NAME" />
+        <Column name="MACHINE_GUID" />
+        <Column name="RML_GUID" />
+        <Column name="LIQUID_TYPE_GUID" />
+        <Column name="DATA" />
+      </Columns>
+    </Item>
+    <Item name="dbo.CCTS" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="NAME" />
+        <Column name="DESCRIPTION" />
+        <Column name="FORWARD_FILE_NAME" />
+        <Column name="INVERSE_FILE_NAME" />
+        <Column name="FORWARD_DATA" />
+        <Column name="INVERSE_DATA" />
+        <Column name="VERSION" />
+        <Column name="RML_GUID" />
+      </Columns>
+    </Item>
+    <Item name="dbo.COLOR_CATALOGS" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="COLOR_SPACE_GUID" />
+        <Column name="COLOR_CODE" />
+        <Column name="NAME" />
+        <Column name="COLOR_GROUP" />
+        <Column name="CYAN" />
+        <Column name="MAGENTA" />
+        <Column name="YELLOW" />
+        <Column name="BLACK" />
+        <Column name="RED" />
+        <Column name="GREEN" />
+        <Column name="BLUE" />
+        <Column name="L" />
+        <Column name="A" />
+        <Column name="B" />
+        <Column name="V0" />
+        <Column name="V1" />
+        <Column name="V2" />
+        <Column name="V3" />
+        <Column name="V4" />
+        <Column name="V5" />
+        <Column name="V6" />
+        <Column name="V7" />
+      </Columns>
+    </Item>
+    <Item name="dbo.COLOR_SPACES" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="CODE" />
+        <Column name="NAME" />
+        <Column name="DESCRIPTION" />
+      </Columns>
+    </Item>
+    <Item name="dbo.CONFIGURATIONS" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="NAME" />
+        <Column name="CREATION_DATE" />
+        <Column name="APPLICATION_VERSION_GUID" />
+        <Column name="APPLICATION_OS_VERSION_GUID" />
+        <Column name="APPLICATION_FIRMWARE_VERSION_GUID" />
+        <Column name="APPLICATION_DISPLAY_PANEL_VERSION_GUID" />
+        <Column name="EMBEDDED_FIRMWARE_VERSION_GUID" />
+        <Column name="EMBEDDED_SOFTWARE_VERSION_GUID" />
+        <Column name="HARDWARE_VERSION_GUID" />
+      </Columns>
+    </Item>
+    <Item name="dbo.CONTACTS" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="DELETED" />
+        <Column name="FIRST_NAME" />
+        <Column name="LAST_NAME" />
+        <Column name="FULL_NAME" />
+        <Column name="EMAIL" />
+        <Column name="PHONE_NUMBER" />
+        <Column name="FAX" />
+      </Columns>
+    </Item>
+    <Item name="dbo.CUSTOMERS" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="ORGANIZATION_GUID" />
+        <Column name="NAME" />
+      </Columns>
+    </Item>
+    <Item name="dbo.DISPENSER_TYPES" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="CODE" />
+        <Column name="NAME" />
+        <Column name="NL_PER_PULSE" />
+        <Column name="CAPACITY" />
+      </Columns>
+    </Item>
+    <Item name="dbo.EMBEDDED_FIRMWARE_VERSIONS" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="VERSION" />
+        <Column name="NAME" />
+      </Columns>
+    </Item>
+    <Item name="dbo.EMBEDDED_SOFTWARE_VERSIONS" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="VERSION" />
+        <Column name="NAME" />
+      </Columns>
+    </Item>
+    <Item name="dbo.EVENT_TYPES" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="CODE" />
+        <Column name="NAME" />
+        <Column name="DESCRIPTION" />
+        <Column name="EVENT_TYPES_CATEGORY_GUID" />
+        <Column name="EVENT_TYPES_GROUP_GUID" />
+        <Column name="REQUIRES_USER_INTERVENTION" />
+        <Column name="HTML_PAGE_GUID" />
+        <Column name="RESOLVABLE" />
+      </Columns>
+    </Item>
+    <Item name="dbo.EVENT_TYPES_ACTIONS" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="EVENT_TYPE_GUID" />
+        <Column name="ACTION_TYPE_GUID" />
+      </Columns>
+    </Item>
+    <Item name="dbo.EVENT_TYPES_CATEGORIES" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="CODE" />
+        <Column name="NAME" />
+        <Column name="DESCRIPTION" />
+      </Columns>
+    </Item>
+    <Item name="dbo.EVENT_TYPES_GROUPS" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="CODE" />
+        <Column name="NAME" />
+        <Column name="DESCRIPTION" />
+      </Columns>
+    </Item>
+    <Item name="dbo.FIBER_SHAPES" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="NAME" />
+        <Column name="CODE" />
+      </Columns>
+    </Item>
+    <Item name="dbo.FIBER_SYNTHS" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="NAME" />
+        <Column name="CODE" />
+      </Columns>
+    </Item>
+    <Item name="dbo.HARDWARE_DANCER_TYPES" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="CODE" />
+        <Column name="NAME" />
+        <Column name="DESCRIPTION" />
+      </Columns>
+    </Item>
+    <Item name="dbo.HARDWARE_DANCERS" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="HARDWARE_DANCER_TYPE_GUID" />
+        <Column name="HARDWARE_VERSION_GUID" />
+        <Column name="GRADUAL" />
+        <Column name="K" />
+        <Column name="X" />
+        <Column name="PULSE_PER_MM_SPRING" />
+        <Column name="MAXIMAL_MOVEMENT_MM" />
+        <Column name="ZERO_POINT" />
+        <Column name="RESOLUTION_BITS" />
+        <Column name="ARM_LENGTH" />
+        <Column name="ASSEMBLY_DIRECTION_RIGHT" />
+        <Column name="ACCELERATE_ON_TENSION_RAISE" />
+      </Columns>
+    </Item>
+    <Item name="dbo.HARDWARE_MOTOR_TYPES" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="CODE" />
+        <Column name="NAME" />
+        <Column name="DESCRIPTION" />
+        <Column name="SUPPORTS_HOMING" />
+      </Columns>
+    </Item>
+    <Item name="dbo.HARDWARE_MOTORS" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="HARDWARE_MOTOR_TYPE_GUID" />
+        <Column name="HARDWARE_VERSION_GUID" />
+        <Column name="MIN_FREQUENCY" />
+        <Column name="MAX_FREQUENCY" />
+        <Column name="SET_MICRO_STEP" />
+        <Column name="MICRO_STEP" />
+        <Column name="MAX_CHANGE_SLOPE" />
+        <Column name="HIGH_LENGTH_MICRO_SECOND" />
+        <Column name="SPEED_MASTER" />
+        <Column name="PULSE_PER_ROUND" />
+        <Column name="PULLEY_RADIUS" />
+        <Column name="CONFIG_WORD" />
+        <Column name="DIRECTION_THREAD_WIZE" />
+        <Column name="KVAL_HOLD" />
+        <Column name="KVAL_RUN" />
+        <Column name="KVAL_ACC" />
+        <Column name="KVAL_DEC" />
+        <Column name="OVER_CURRENT_THRESHOLD" />
+        <Column name="STALL_THRESHOLD" />
+        <Column name="THERMAL_COMPENSATION_FACTOR" />
+        <Column name="LOW_SPEED_OPTIMIZATION" />
+        <Column name="ST_SLP" />
+        <Column name="INT_SPD" />
+        <Column name="FN_SLP_ACC" />
+        <Column name="FN_SLP_DEC" />
+        <Column name="FS_SPD" />
+      </Columns>
+    </Item>
+    <Item name="dbo.HARDWARE_PID_CONTROL_TYPES" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="CODE" />
+        <Column name="NAME" />
+        <Column name="DESCRIPTION" />
+      </Columns>
+    </Item>
+    <Item name="dbo.HARDWARE_PID_CONTROLS" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="HARDWARE_PID_CONTROL_TYPE_GUID" />
+        <Column name="HARDWARE_VERSION_GUID" />
+        <Column name="OUTPUT_PROPORTIONAL_POWER_LIMIT" />
+        <Column name="OUTPUT_PROPORTIONAL_BAND" />
+        <Column name="INTEGRAL_TIME" />
+        <Column name="DERIVATIVE_TIME" />
+        <Column name="SENSOR_CORRECTION_ADJUSTMENT" />
+        <Column name="SENSOR_MIN_VALUE" />
+        <Column name="SENSOR_MAX_VALUE" />
+        <Column name="SET_POINT_RAMP_RATEOR_SOFT_START_RAMP" />
+        <Column name="SET_POINT_CONTROL_OUTPUT_RATE" />
+        <Column name="CONTROL_OUTPUT_TYPE" />
+        <Column name="SSR_CONTROL_OUTPUT_TYPE" />
+        <Column name="OUTPUT_ON_OFF_HYSTERESIS_VALUE" />
+        <Column name="PROCESS_VARIABLE_SAMPLING_RATE" />
+        <Column name="PV_INPUT_FILTER_FACTOR_MODE" />
+        <Column name="OUTPUT_PROPORTIONAL_CYCLE_TIME" />
+        <Column name="AC_HEATERS__HALF_CYCLE_TIME" />
+        <Column name="PROPORTIONAL_GAIN" />
+      </Columns>
+    </Item>
+    <Item name="dbo.HARDWARE_SPEED_SENSOR_TYPES" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="CODE" />
+        <Column name="NAME" />
+        <Column name="DESCRIPTION" />
+      </Columns>
+    </Item>
+    <Item name="dbo.HARDWARE_SPEED_SENSORS" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="HARDWARE_SPEED_SENSOR_TYPE_GUID" />
+        <Column name="HARDWARE_VERSION_GUID" />
+        <Column name="RESOLUTION_BITS" />
+        <Column name="PERIMETER" />
+      </Columns>
+    </Item>
+    <Item name="dbo.HARDWARE_VERSIONS" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="VERSION" />
+        <Column name="NAME" />
+      </Columns>
+    </Item>
+    <Item name="dbo.HARDWARE_WINDER_TYPES" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="CODE" />
+        <Column name="NAME" />
+        <Column name="DESCRIPTION" />
+      </Columns>
+    </Item>
+    <Item name="dbo.HARDWARE_WINDERS" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="HARDWARE_WINDER_TYPE_GUID" />
+        <Column name="HARDWARE_VERSION_GUID" />
+        <Column name="MILLIMETER_PER_ROTATION" />
+      </Columns>
+    </Item>
+    <Item name="dbo.HTML_PAGES" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="CODE" />
+        <Column name="NAME" />
+        <Column name="DESCRIPTION" />
+        <Column name="HTML" />
+      </Columns>
+    </Item>
+    <Item name="dbo.IDS_PACK_FORMULAS" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="CODE" />
+        <Column name="NAME" />
+        <Column name="DESCRIPTION" />
+        <Column name="AUTO_CALCULATED" />
+      </Columns>
+    </Item>
+    <Item name="dbo.IDS_PACKS" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="CONFIGURATION_GUID" />
+        <Column name="DISPENSER_TYPE_GUID" />
+        <Column name="LIQUID_TYPE_GUID" />
+        <Column name="CARTRIDGE_TYPE_GUID" />
+        <Column name="MID_TANK_TYPE_GUID" />
+        <Column name="IDS_PACK_FORMULA_GUID" />
+        <Column name="NAME" />
+        <Column name="PACK_INDEX" />
+        <Column name="IS_EMPTY" />
+      </Columns>
+    </Item>
+    <Item name="dbo.JOB_RUNS" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="JOB_GUID" />
+        <Column name="START_DATE" />
+        <Column name="END_DATE" />
+        <Column name="SUCCESSFUL" />
+      </Columns>
+    </Item>
+    <Item name="dbo.JOBS" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="CREATION_DATE" />
+        <Column name="LAST_RUN" />
+        <Column name="MACHINE_GUID" />
+        <Column name="USER_GUID" />
+        <Column name="RML_GUID" />
+        <Column name="WINDING_METHOD_GUID" />
+        <Column name="SPOOL_TYPE_GUID" />
+        <Column name="NAME" />
+        <Column name="DESCRIPTION" />
+        <Column name="INTER_SEGMENT_LENGTH" />
+        <Column name="ENABLE_INTER_SEGMENT" />
+        <Column name="ENABLE_LUBRICATION" />
+        <Column name="JOB_INDEX" />
+        <Column name="ESTIMATED_DURATION_MILI" />
+        <Column name="HAS_EMBROIDERY_FILE" />
+        <Column name="EMBROIDERY_FILE_DATA" />
+        <Column name="EMBROIDERY_FILE_NAME" />
+        <Column name="EMBROIDERY_JPEG" />
+        <Column name="STATUS" />
+        <Column name="COLOR_SPACE_GUID" />
+        <Column name="NUMBER_OF_UNITS" />
+        <Column name="TYPE" />
+        <Column name="CUSTOMER_GUID" />
+        <Column name="SPOOLS_DISTRIBUTION" />
+        <Column name="NUMBER_OF_HEADS" />
+        <Column name="SAMPLE_UNITS_OR_METERS" />
+        <Column name="FINE_TUNING_STATUS" />
+        <Column name="FINE_TUNING_APPROVE_DATE" />
+        <Column name="SAMPLE_DYE_STATUS" />
+        <Column name="SAMPLE_DYE_APPROVE_DATE" />
+        <Column name="EDITING_STATE" />
+        <Column name="LENGTH_PERCENTAGE_FACTOR" />
+      </Columns>
+    </Item>
+    <Item name="dbo.LINEAR_MASS_DENSITY_UNITS" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="NAME" />
+        <Column name="CODE" />
+      </Columns>
+    </Item>
+    <Item name="dbo.LIQUID_TYPES" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="CODE" />
+        <Column name="NAME" />
+        <Column name="VERSION" />
+        <Column name="COLOR" />
+      </Columns>
+    </Item>
+    <Item name="dbo.LIQUID_TYPES_RMLS" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="LIQUID_TYPE_GUID" />
+        <Column name="RML_GUID" />
+        <Column name="MAX_NL_PER_CM" />
+      </Columns>
+    </Item>
+    <Item name="dbo.MACHINE_STUDIO_VERSIONS" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="VERSION" />
+        <Column name="FTP_FILE_PATH" />
+        <Column name="COMMENTS" />
+        <Column name="USER_GUID" />
+        <Column name="FORCE_UPDATE" />
+      </Columns>
+    </Item>
+    <Item name="dbo.MACHINE_VERSIONS" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="VERSION" />
+        <Column name="NAME" />
+        <Column name="DEFAULT_CONFIGURATION_GUID" />
+      </Columns>
+    </Item>
+    <Item name="dbo.MACHINES" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="SERIAL_NUMBER" />
+        <Column name="NAME" />
+        <Column name="PRODUCTION_DATE" />
+        <Column name="ORGANIZATION_GUID" />
+        <Column name="MACHINE_VERSION_GUID" />
+        <Column name="CONFIGURATION_GUID" />
+        <Column name="ENABLE_EXTERNAL_BRIDGE" />
+        <Column name="EXTERNAL_BRIDGE_PASSWORD" />
+        <Column name="DEFAULT_RML_GUID" />
+        <Column name="TARGET_JOB_TYPES" />
+        <Column name="DEFAULT_COLOR_SPACE_GUID" />
+        <Column name="DEFAULT_SEGMENT_LENGTH" />
+        <Column name="DEFAULT_SPOOL_TYPE_GUID" />
+        <Column name="SYNCHED" />
+      </Columns>
+    </Item>
+    <Item name="dbo.MACHINES_CONFIGURATIONS" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="MACHINE_GUID" />
+        <Column name="CONFIGURATION_GUID" />
+      </Columns>
+    </Item>
+    <Item name="dbo.MACHINES_EVENTS" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="HOST_NAME" />
+        <Column name="MACHINE_GUID" />
+        <Column name="EVENT_TYPE_GUID" />
+        <Column name="USER_GUID" />
+        <Column name="DATE_TIME" />
+        <Column name="DESCRIPTION" />
+      </Columns>
+    </Item>
+    <Item name="dbo.MACHINES_EVENTS_VIEW" type="view">
+      <Columns>
+        <Column name="DATE" />
+        <Column name="MACHINE" />
+        <Column name="USER_NAME" />
+        <Column name="GROUP" />
+        <Column name="CATEGORY" />
+        <Column name="TYPE" />
+        <Column name="DESCRIPTION" />
+      </Columns>
+    </Item>
+    <Item name="dbo.MEDIA_COLORS" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="NAME" />
+        <Column name="L" />
+        <Column name="A" />
+        <Column name="B" />
+      </Columns>
+    </Item>
+    <Item name="dbo.MEDIA_CONDITIONS" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="NAME" />
+        <Column name="CODE" />
+      </Columns>
+    </Item>
+    <Item name="dbo.MEDIA_MATERIALS" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="NAME" />
+        <Column name="CODE" />
+      </Columns>
+    </Item>
+    <Item name="dbo.MEDIA_PURPOSES" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="NAME" />
+        <Column name="CODE" />
+      </Columns>
+    </Item>
+    <Item name="dbo.MID_TANK_TYPES" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="CODE" />
+        <Column name="NAME" />
+        <Column name="LITER_CAPACITY" />
+      </Columns>
+    </Item>
+    <Item name="dbo.ORGANIZATIONS" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="NAME" />
+        <Column name="CONTACT_GUID" />
+        <Column name="ADDRESS_GUID" />
+      </Columns>
+    </Item>
+    <Item name="dbo.PERMISSIONS" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="CODE" />
+        <Column name="NAME" />
+        <Column name="DESCRIPTION" />
+      </Columns>
+    </Item>
+    <Item name="dbo.PROCESS_PARAMETERS_TABLES" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="NAME" />
+        <Column name="DYEING_SPEED" />
+        <Column name="MIN_INK_UPTAKE" />
+        <Column name="FEEDER_TENSION" />
+        <Column name="PULLER_TENSION" />
+        <Column name="WINDER_TENSION" />
+        <Column name="MIXER_TEMP" />
+        <Column name="HEAD_ZONE1_TEMP" />
+        <Column name="HEAD_ZONE2_TEMP" />
+        <Column name="HEAD_ZONE3_TEMP" />
+        <Column name="HEAD_ZONE4_TEMP" />
+        <Column name="HEAD_ZONE5_TEMP" />
+        <Column name="HEAD_ZONE6_TEMP" />
+        <Column name="DRYER_AIR_FLOW" />
+        <Column name="DRYER_ZONE1_TEMP" />
+        <Column name="DRYER_ZONE2_TEMP" />
+        <Column name="DRYER_ZONE3_TEMP" />
+        <Column name="DRYER_BUFFER_LENGTH" />
+        <Column name="HEAD_AIR_FLOW" />
+        <Column name="PROCESS_PARAMETERS_TABLES_GROUP_GUID" />
+        <Column name="TABLE_INDEX" />
+      </Columns>
+    </Item>
+    <Item name="dbo.PROCESS_PARAMETERS_TABLES_GROUPS" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="RML_GUID" />
+        <Column name="NAME" />
+        <Column name="ACTIVE" />
+        <Column name="SAVE_DATE" />
+      </Columns>
+    </Item>
+    <Item name="dbo.RMLS" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="NAME" />
+        <Column name="MANUFACTURER" />
+        <Column name="CODE" />
+        <Column name="MEDIA_MATERIAL_GUID" />
+        <Column name="MEDIA_COLOR_GUID" />
+        <Column name="MEDIA_PURPOSE_GUID" />
+        <Column name="MEDIA_CONDITION_GUID" />
+        <Column name="LINEAR_MASS_DENSITY_UNIT_GUID" />
+        <Column name="FIBER_SHAPE_GUID" />
+        <Column name="FIBER_SYNTH_GUID" />
+        <Column name="FIBER_SIZE" />
+        <Column name="NUMBER_OF_FIBERS" />
+        <Column name="PLIES_PER_FIBER" />
+        <Column name="PLIES_PER_THREAD" />
+        <Column name="TWISTED" />
+        <Column name="AIR_ENTANGLEMENT" />
+        <Column name="LUBRICANT" />
+        <Column name="TENSILE_STRENGTH" />
+        <Column name="ELONGATION_AT_BREAK_PERCENTAGE" />
+        <Column name="ESTIMATED_THREAD_DIAMETER" />
+      </Columns>
+    </Item>
+    <Item name="dbo.ROLES" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="CODE" />
+        <Column name="NAME" />
+        <Column name="DESCRIPTION" />
+      </Columns>
+    </Item>
+    <Item name="dbo.ROLES_PERMISSIONS" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="ROLE_GUID" />
+        <Column name="PERMISSION_GUID" />
+      </Columns>
+    </Item>
+    <Item name="dbo.SEGMENTS" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="NAME" />
+        <Column name="JOB_GUID" />
+        <Column name="LENGTH" />
+        <Column name="SEGMENT_INDEX" />
+      </Columns>
+    </Item>
+    <Item name="dbo.SPOOL_TYPES" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="CODE" />
+        <Column name="NAME" />
+        <Column name="LENGTH" />
+        <Column name="WEIGHT" />
+        <Column name="DIAMETER" />
+        <Column name="START_OFFSET_PULSES" />
+        <Column name="BACKING_RATE" />
+        <Column name="SEGMENT_OFFSET_PULSES" />
+        <Column name="BOTTOM_BACKING_RATE" />
+        <Column name="ROTATIONS_PER_PASSAGE" />
+      </Columns>
+    </Item>
+    <Item name="dbo.SYNC_CONFIGURATIONS" type="table">
+      <Columns>
+        <Column name="ID" key="true" />
+        <Column name="TABLE_NAME" />
+        <Column name="SYNC_TYPE" />
+      </Columns>
+    </Item>
+    <Item name="dbo.TECH_CONTROLLERS" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="CODE" />
+        <Column name="NAME" />
+        <Column name="DESCRIPTION" />
+        <Column name="MIN" />
+        <Column name="MAX" />
+        <Column name="UNITS" />
+      </Columns>
+    </Item>
+    <Item name="dbo.TECH_DISPENSERS" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="CODE" />
+        <Column name="NAME" />
+        <Column name="DESCRIPTION" />
+      </Columns>
+    </Item>
+    <Item name="dbo.TECH_IOS" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="PORT" />
+        <Column name="TYPE" />
+        <Column name="DESIGNATOR" />
+        <Column name="ASM" />
+        <Column name="INTERFACE_NAME" />
+        <Column name="SENSOR" />
+        <Column name="INIT_VALUE" />
+        <Column name="AVERAGING" />
+        <Column name="MIN" />
+        <Column name="MAX" />
+      </Columns>
+    </Item>
+    <Item name="dbo.TECH_MONITORS" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="CODE" />
+        <Column name="NAME" />
+        <Column name="DESCRIPTION" />
+        <Column name="MIN" />
+        <Column name="MAX" />
+        <Column name="UNITS" />
+        <Column name="POINTS_PER_FRAME" />
+        <Column name="MULTI_CHANNEL" />
+        <Column name="CHANNEL_COUNT" />
+      </Columns>
+    </Item>
+    <Item name="dbo.TECH_VALVES" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="CODE" />
+        <Column name="NAME" />
+        <Column name="DESCRIPTION" />
+      </Columns>
+    </Item>
+    <Item name="dbo.USERS" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="DELETED" />
+        <Column name="EMAIL" />
+        <Column name="PASSWORD" />
+        <Column name="ORGANIZATION_GUID" />
+        <Column name="CONTACT_GUID" />
+        <Column name="ADDRESS_GUID" />
+        <Column name="LAST_LOGIN" />
+      </Columns>
+    </Item>
+    <Item name="dbo.USERS_ROLES" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="DELETED" />
+        <Column name="USER_GUID" />
+        <Column name="ROLE_GUID" />
+      </Columns>
+    </Item>
+    <Item name="dbo.WINDING_METHODS" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="CODE" />
+        <Column name="NAME" />
+        <Column name="DESCRIPTION" />
+      </Columns>
+    </Item>
+    <Item name="Sync_Addresses" type="query" extracted="True">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="DELETED" />
+        <Column name="ADDRESS_STRING" />
+        <Column name="LOCALITY" />
+        <Column name="COUNTRY" />
+        <Column name="CITY" />
+        <Column name="STATE" />
+        <Column name="COUNTRY_CODE" />
+        <Column name="POSTAL_CODE" />
+      </Columns>
+      <Queries>
+        <Query id="1">
+          <Text><![CDATA[SELECT DISTINCT ADDRESSES.*
+
+FROM ORGANIZATIONS
+
+LEFT JOIN USERS ON USERS.ORGANIZATION_GUID = ORGANIZATION_GUID
+LEFT JOIN MACHINES ON MACHINES.ORGANIZATION_GUID = ORGANIZATIONS.GUID
+LEFT JOIN ADDRESSES ON ADDRESSES.GUID = USERS.ADDRESS_GUID OR ADDRESSES.GUID = ORGANIZATIONS.ADDRESS_GUID
+
+WHERE MACHINES.SERIAL_NUMBER = '@']]></Text>
+          <UpdateTables>
+            <Table schema="dbo" name="ADDRESSES" allowDelete="True" allowInsert="True" allowUpdate="True">
+              <KeyColumns>
+                <KeyColumn name="GUID" />
+              </KeyColumns>
+              <UpdateColumns>
+                <UpdateColumn name="ID" />
+                <UpdateColumn name="GUID" />
+                <UpdateColumn name="LAST_UPDATED" />
+                <UpdateColumn name="DELETED" />
+                <UpdateColumn name="ADDRESS_STRING" />
+                <UpdateColumn name="LOCALITY" />
+                <UpdateColumn name="COUNTRY" />
+                <UpdateColumn name="CITY" />
+                <UpdateColumn name="STATE" />
+                <UpdateColumn name="COUNTRY_CODE" />
+                <UpdateColumn name="POSTAL_CODE" />
+              </UpdateColumns>
+            </Table>
+          </UpdateTables>
+        </Query>
+        <Query id="2">
+          <Text><![CDATA[SELECT DISTINCT ADDRESSES.*
+
+FROM ORGANIZATIONS
+
+LEFT JOIN USERS ON USERS.ORGANIZATION_GUID = ORGANIZATION_GUID
+LEFT JOIN MACHINES ON MACHINES.ORGANIZATION_GUID = ORGANIZATIONS.GUID
+LEFT JOIN ADDRESSES ON ADDRESSES.GUID = USERS.ADDRESS_GUID OR ADDRESSES.GUID = ORGANIZATIONS.ADDRESS_GUID
+
+WHERE MACHINES.SERIAL_NUMBER = '@']]></Text>
+          <UpdateTables>
+            <Table schema="dbo" name="ADDRESSES" allowDelete="True" allowInsert="True" allowUpdate="True">
+              <KeyColumns>
+                <KeyColumn name="GUID" />
+              </KeyColumns>
+              <UpdateColumns>
+                <UpdateColumn name="ID" />
+                <UpdateColumn name="GUID" />
+                <UpdateColumn name="LAST_UPDATED" />
+                <UpdateColumn name="DELETED" />
+                <UpdateColumn name="ADDRESS_STRING" />
+                <UpdateColumn name="LOCALITY" />
+                <UpdateColumn name="COUNTRY" />
+                <UpdateColumn name="CITY" />
+                <UpdateColumn name="STATE" />
+                <UpdateColumn name="COUNTRY_CODE" />
+                <UpdateColumn name="POSTAL_CODE" />
+              </UpdateColumns>
+            </Table>
+          </UpdateTables>
+        </Query>
+      </Queries>
+    </Item>
+    <Item name="Sync_Configuration" type="query" extracted="True">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="NAME" />
+        <Column name="CREATION_DATE" />
+        <Column name="APPLICATION_VERSION_GUID" />
+        <Column name="APPLICATION_OS_VERSION_GUID" />
+        <Column name="APPLICATION_FIRMWARE_VERSION_GUID" />
+        <Column name="APPLICATION_DISPLAY_PANEL_VERSION_GUID" />
+        <Column name="EMBEDDED_FIRMWARE_VERSION_GUID" />
+        <Column name="EMBEDDED_SOFTWARE_VERSION_GUID" />
+        <Column name="HARDWARE_VERSION_GUID" />
+      </Columns>
+      <Queries>
+        <Query id="1">
+          <Text><![CDATA[SELECT CONFIGURATIONS.*
+FROM CONFIGURATIONS
+INNER JOIN MACHINES ON MACHINES.CONFIGURATION_GUID = CONFIGURATIONS.GUID
+WHERE MACHINES.SERIAL_NUMBER = '@']]></Text>
+          <UpdateTables>
+            <Table schema="dbo" name="CONFIGURATIONS" allowDelete="True" allowInsert="True" allowUpdate="True">
+              <KeyColumns>
+                <KeyColumn name="GUID" />
+              </KeyColumns>
+              <UpdateColumns>
+                <UpdateColumn name="ID" />
+                <UpdateColumn name="GUID" />
+                <UpdateColumn name="LAST_UPDATED" />
+                <UpdateColumn name="NAME" />
+                <UpdateColumn name="CREATION_DATE" />
+                <UpdateColumn name="APPLICATION_VERSION_GUID" />
+                <UpdateColumn name="APPLICATION_OS_VERSION_GUID" />
+                <UpdateColumn name="APPLICATION_FIRMWARE_VERSION_GUID" />
+                <UpdateColumn name="APPLICATION_DISPLAY_PANEL_VERSION_GUID" />
+                <UpdateColumn name="EMBEDDED_FIRMWARE_VERSION_GUID" />
+                <UpdateColumn name="EMBEDDED_SOFTWARE_VERSION_GUID" />
+                <UpdateColumn name="HARDWARE_VERSION_GUID" />
+              </UpdateColumns>
+            </Table>
+          </UpdateTables>
+        </Query>
+        <Query id="2">
+          <Text><![CDATA[SELECT CONFIGURATIONS.*
+FROM CONFIGURATIONS
+INNER JOIN MACHINES ON MACHINES.CONFIGURATION_GUID = CONFIGURATIONS.GUID
+WHERE MACHINES.SERIAL_NUMBER = '@']]></Text>
+          <UpdateTables>
+            <Table schema="dbo" name="CONFIGURATIONS" allowDelete="True" allowInsert="True" allowUpdate="True">
+              <KeyColumns>
+                <KeyColumn name="GUID" />
+              </KeyColumns>
+              <UpdateColumns>
+                <UpdateColumn name="ID" />
+                <UpdateColumn name="GUID" />
+                <UpdateColumn name="LAST_UPDATED" />
+                <UpdateColumn name="NAME" />
+                <UpdateColumn name="CREATION_DATE" />
+                <UpdateColumn name="APPLICATION_VERSION_GUID" />
+                <UpdateColumn name="APPLICATION_OS_VERSION_GUID" />
+                <UpdateColumn name="APPLICATION_FIRMWARE_VERSION_GUID" />
+                <UpdateColumn name="APPLICATION_DISPLAY_PANEL_VERSION_GUID" />
+                <UpdateColumn name="EMBEDDED_FIRMWARE_VERSION_GUID" />
+                <UpdateColumn name="EMBEDDED_SOFTWARE_VERSION_GUID" />
+                <UpdateColumn name="HARDWARE_VERSION_GUID" />
+              </UpdateColumns>
+            </Table>
+          </UpdateTables>
+        </Query>
+      </Queries>
+    </Item>
+    <Item name="Sync_Contacts" type="query" extracted="True">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="DELETED" />
+        <Column name="FIRST_NAME" />
+        <Column name="LAST_NAME" />
+        <Column name="FULL_NAME" />
+        <Column name="EMAIL" />
+        <Column name="PHONE_NUMBER" />
+        <Column name="FAX" />
+      </Columns>
+      <Queries>
+        <Query id="1">
+          <Text><![CDATA[SELECT DISTINCT CONTACTS.*
+
+FROM ORGANIZATIONS
+
+LEFT JOIN USERS ON USERS.ORGANIZATION_GUID = ORGANIZATION_GUID
+LEFT JOIN MACHINES ON MACHINES.ORGANIZATION_GUID = ORGANIZATIONS.GUID
+LEFT JOIN CONTACTS ON CONTACTS.GUID = USERS.CONTACT_GUID OR CONTACTS.GUID = ORGANIZATIONS.CONTACT_GUID
+
+WHERE MACHINES.SERIAL_NUMBER = '@']]></Text>
+          <UpdateTables>
+            <Table schema="dbo" name="CONTACTS" allowDelete="True" allowInsert="True" allowUpdate="True">
+              <KeyColumns>
+                <KeyColumn name="GUID" />
+              </KeyColumns>
+              <UpdateColumns>
+                <UpdateColumn name="ID" />
+                <UpdateColumn name="GUID" />
+                <UpdateColumn name="LAST_UPDATED" />
+                <UpdateColumn name="DELETED" />
+                <UpdateColumn name="FIRST_NAME" />
+                <UpdateColumn name="LAST_NAME" />
+                <UpdateColumn name="FULL_NAME" />
+                <UpdateColumn name="EMAIL" />
+                <UpdateColumn name="PHONE_NUMBER" />
+                <UpdateColumn name="FAX" />
+              </UpdateColumns>
+            </Table>
+          </UpdateTables>
+        </Query>
+        <Query id="2">
+          <Text><![CDATA[SELECT DISTINCT CONTACTS.*
+
+FROM ORGANIZATIONS
+
+LEFT JOIN USERS ON USERS.ORGANIZATION_GUID = ORGANIZATION_GUID
+LEFT JOIN MACHINES ON MACHINES.ORGANIZATION_GUID = ORGANIZATIONS.GUID
+LEFT JOIN CONTACTS ON CONTACTS.GUID = USERS.CONTACT_GUID OR CONTACTS.GUID = ORGANIZATIONS.CONTACT_GUID
+
+WHERE MACHINES.SERIAL_NUMBER = '@']]></Text>
+          <UpdateTables>
+            <Table schema="dbo" name="CONTACTS" allowDelete="True" allowInsert="True" allowUpdate="True">
+              <KeyColumns>
+                <KeyColumn name="GUID" />
+              </KeyColumns>
+              <UpdateColumns>
+                <UpdateColumn name="ID" />
+                <UpdateColumn name="GUID" />
+                <UpdateColumn name="LAST_UPDATED" />
+                <UpdateColumn name="DELETED" />
+                <UpdateColumn name="FIRST_NAME" />
+                <UpdateColumn name="LAST_NAME" />
+                <UpdateColumn name="FULL_NAME" />
+                <UpdateColumn name="EMAIL" />
+                <UpdateColumn name="PHONE_NUMBER" />
+                <UpdateColumn name="FAX" />
+              </UpdateColumns>
+            </Table>
+          </UpdateTables>
+        </Query>
+      </Queries>
+    </Item>
+    <Item name="Sync_IdsPacks" type="query" extracted="True">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="CONFIGURATION_GUID" />
+        <Column name="DISPENSER_TYPE_GUID" />
+        <Column name="LIQUID_TYPE_GUID" />
+        <Column name="CARTRIDGE_TYPE_GUID" />
+        <Column name="MID_TANK_TYPE_GUID" />
+        <Column name="IDS_PACK_FORMULA_GUID" />
+        <Column name="NAME" />
+        <Column name="PACK_INDEX" />
+        <Column name="IS_EMPTY" />
+      </Columns>
+      <Queries>
+        <Query id="1">
+          <Text><![CDATA[SELECT IDS_PACKS.*
+
+FROM MACHINES 
+	INNER JOIN CONFIGURATIONS ON MACHINES.CONFIGURATION_GUID = CONFIGURATIONS.GUID 
+	INNER JOIN IDS_PACKS ON CONFIGURATIONS.GUID = IDS_PACKS.CONFIGURATION_GUID
+
+WHERE MACHINES.SERIAL_NUMBER = '@'
+]]></Text>
+        </Query>
+        <Query id="2">
+          <Text><![CDATA[SELECT IDS_PACKS.*
+
+FROM MACHINES 
+	INNER JOIN CONFIGURATIONS ON MACHINES.CONFIGURATION_GUID = CONFIGURATIONS.GUID 
+	INNER JOIN IDS_PACKS ON CONFIGURATIONS.GUID = IDS_PACKS.CONFIGURATION_GUID
+
+WHERE MACHINES.SERIAL_NUMBER = '@'
+]]></Text>
+          <UpdateTables>
+            <Table schema="dbo" name="IDS_PACKS" allowDelete="True" allowInsert="True" allowUpdate="True">
+              <KeyColumns>
+                <KeyColumn name="GUID" />
+              </KeyColumns>
+              <UpdateColumns>
+                <UpdateColumn name="ID" />
+                <UpdateColumn name="GUID" />
+                <UpdateColumn name="LAST_UPDATED" />
+                <UpdateColumn name="CONFIGURATION_GUID" />
+                <UpdateColumn name="DISPENSER_TYPE_GUID" />
+                <UpdateColumn name="LIQUID_TYPE_GUID" />
+                <UpdateColumn name="CARTRIDGE_TYPE_GUID" />
+                <UpdateColumn name="MID_TANK_TYPE_GUID" />
+                <UpdateColumn name="IDS_PACK_FORMULA_GUID" />
+                <UpdateColumn name="NAME" />
+                <UpdateColumn name="PACK_INDEX" />
+                <UpdateColumn name="IS_EMPTY" />
+              </UpdateColumns>
+            </Table>
+          </UpdateTables>
+        </Query>
+      </Queries>
+    </Item>
+    <Item name="Sync_Machine" type="query" extracted="True">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="SERIAL_NUMBER" />
+        <Column name="NAME" />
+        <Column name="PRODUCTION_DATE" />
+        <Column name="ORGANIZATION_GUID" />
+        <Column name="MACHINE_VERSION_GUID" />
+        <Column name="CONFIGURATION_GUID" />
+        <Column name="ENABLE_EXTERNAL_BRIDGE" />
+        <Column name="EXTERNAL_BRIDGE_PASSWORD" />
+        <Column name="DEFAULT_RML_GUID" />
+        <Column name="TARGET_JOB_TYPES" />
+        <Column name="DEFAULT_COLOR_SPACE_GUID" />
+        <Column name="DEFAULT_SEGMENT_LENGTH" />
+        <Column name="DEFAULT_SPOOL_TYPE_GUID" />
+        <Column name="SYNCHED" />
+      </Columns>
+      <Queries>
+        <Query id="1">
+          <Text><![CDATA[SELECT * FROM MACHINES WHERE MACHINES.SERIAL_NUMBER = '@']]></Text>
+          <UpdateTables>
+            <Table schema="dbo" name="MACHINES" allowDelete="True" allowInsert="True" allowUpdate="True">
+              <KeyColumns>
+                <KeyColumn name="GUID" />
+              </KeyColumns>
+              <UpdateColumns>
+                <UpdateColumn name="ID" />
+                <UpdateColumn name="GUID" />
+                <UpdateColumn name="LAST_UPDATED" />
+                <UpdateColumn name="SERIAL_NUMBER" />
+                <UpdateColumn name="NAME" />
+                <UpdateColumn name="PRODUCTION_DATE" />
+                <UpdateColumn name="ORGANIZATION_GUID" />
+                <UpdateColumn name="MACHINE_VERSION_GUID" />
+                <UpdateColumn name="CONFIGURATION_GUID" />
+                <UpdateColumn name="ENABLE_EXTERNAL_BRIDGE" />
+                <UpdateColumn name="EXTERNAL_BRIDGE_PASSWORD" />
+                <UpdateColumn name="DEFAULT_RML_GUID" />
+                <UpdateColumn name="TARGET_JOB_TYPES" />
+                <UpdateColumn name="DEFAULT_COLOR_SPACE_GUID" />
+                <UpdateColumn name="DEFAULT_SEGMENT_LENGTH" />
+                <UpdateColumn name="DEFAULT_SPOOL_TYPE_GUID" />
+                <UpdateColumn name="SYNCHED" />
+              </UpdateColumns>
+            </Table>
+          </UpdateTables>
+        </Query>
+        <Query id="2">
+          <Text><![CDATA[SELECT * FROM MACHINES WHERE MACHINES.SERIAL_NUMBER = '@']]></Text>
+          <UpdateTables>
+            <Table schema="dbo" name="MACHINES" allowDelete="True" allowInsert="True" allowUpdate="True">
+              <KeyColumns>
+                <KeyColumn name="GUID" />
+              </KeyColumns>
+              <UpdateColumns>
+                <UpdateColumn name="ID" />
+                <UpdateColumn name="GUID" />
+                <UpdateColumn name="LAST_UPDATED" />
+                <UpdateColumn name="SERIAL_NUMBER" />
+                <UpdateColumn name="NAME" />
+                <UpdateColumn name="PRODUCTION_DATE" />
+                <UpdateColumn name="ORGANIZATION_GUID" />
+                <UpdateColumn name="MACHINE_VERSION_GUID" />
+                <UpdateColumn name="CONFIGURATION_GUID" />
+                <UpdateColumn name="ENABLE_EXTERNAL_BRIDGE" />
+                <UpdateColumn name="EXTERNAL_BRIDGE_PASSWORD" />
+                <UpdateColumn name="DEFAULT_RML_GUID" />
+                <UpdateColumn name="TARGET_JOB_TYPES" />
+                <UpdateColumn name="DEFAULT_COLOR_SPACE_GUID" />
+                <UpdateColumn name="DEFAULT_SEGMENT_LENGTH" />
+                <UpdateColumn name="DEFAULT_SPOOL_TYPE_GUID" />
+                <UpdateColumn name="SYNCHED" />
+              </UpdateColumns>
+            </Table>
+          </UpdateTables>
+        </Query>
+      </Queries>
+    </Item>
+    <Item name="Sync_Organization" type="query" extracted="True">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="NAME" />
+        <Column name="CONTACT_GUID" />
+        <Column name="ADDRESS_GUID" />
+      </Columns>
+      <Queries>
+        <Query id="1">
+          <Text><![CDATA[SELECT ORGANIZATIONS.*
+
+FROM ORGANIZATIONS
+
+INNER JOIN MACHINES ON MACHINES.ORGANIZATION_GUID = ORGANIZATIONS.GUID
+
+WHERE MACHINES.SERIAL_NUMBER = '@']]></Text>
+          <UpdateTables>
+            <Table schema="dbo" name="ORGANIZATIONS" allowDelete="True" allowInsert="True" allowUpdate="True">
+              <KeyColumns>
+                <KeyColumn name="GUID" />
+              </KeyColumns>
+              <UpdateColumns>
+                <UpdateColumn name="ID" />
+                <UpdateColumn name="GUID" />
+                <UpdateColumn name="LAST_UPDATED" />
+                <UpdateColumn name="NAME" />
+                <UpdateColumn name="CONTACT_GUID" />
+                <UpdateColumn name="ADDRESS_GUID" />
+              </UpdateColumns>
+            </Table>
+          </UpdateTables>
+        </Query>
+        <Query id="2">
+          <Text><![CDATA[SELECT ORGANIZATIONS.*
+
+FROM ORGANIZATIONS
+
+INNER JOIN MACHINES ON MACHINES.ORGANIZATION_GUID = ORGANIZATIONS.GUID
+
+WHERE MACHINES.SERIAL_NUMBER = '@']]></Text>
+          <UpdateTables>
+            <Table schema="dbo" name="ORGANIZATIONS" allowDelete="True" allowInsert="True" allowUpdate="True">
+              <KeyColumns>
+                <KeyColumn name="GUID" />
+              </KeyColumns>
+              <UpdateColumns>
+                <UpdateColumn name="ID" />
+                <UpdateColumn name="GUID" />
+                <UpdateColumn name="LAST_UPDATED" />
+                <UpdateColumn name="NAME" />
+                <UpdateColumn name="CONTACT_GUID" />
+                <UpdateColumn name="ADDRESS_GUID" />
+              </UpdateColumns>
+            </Table>
+          </UpdateTables>
+        </Query>
+      </Queries>
+    </Item>
+    <Item name="Sync_UsersRoles" type="query" extracted="True">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="DELETED" />
+        <Column name="USER_GUID" />
+        <Column name="ROLE_GUID" />
+      </Columns>
+      <Queries>
+        <Query id="1">
+          <Text><![CDATA[SELECT DISTINCT USERS_ROLES.*
+
+FROM ORGANIZATIONS
+
+LEFT JOIN USERS ON USERS.ORGANIZATION_GUID = ORGANIZATION_GUID
+LEFT JOIN MACHINES ON MACHINES.ORGANIZATION_GUID = ORGANIZATIONS.GUID
+LEFT JOIN USERS_ROLES ON USERS_ROLES.USER_GUID = USERS.GUID
+
+WHERE MACHINES.SERIAL_NUMBER = '@']]></Text>
+          <UpdateTables>
+            <Table schema="dbo" name="USERS_ROLES" allowDelete="True" allowInsert="True" allowUpdate="True">
+              <KeyColumns>
+                <KeyColumn name="GUID" />
+              </KeyColumns>
+              <UpdateColumns>
+                <UpdateColumn name="ID" />
+                <UpdateColumn name="GUID" />
+                <UpdateColumn name="LAST_UPDATED" />
+                <UpdateColumn name="DELETED" />
+                <UpdateColumn name="USER_GUID" />
+                <UpdateColumn name="ROLE_GUID" />
+              </UpdateColumns>
+            </Table>
+          </UpdateTables>
+        </Query>
+        <Query id="2">
+          <Text><![CDATA[SELECT DISTINCT USERS_ROLES.*
+
+FROM ORGANIZATIONS
+
+LEFT JOIN USERS ON USERS.ORGANIZATION_GUID = ORGANIZATION_GUID
+LEFT JOIN MACHINES ON MACHINES.ORGANIZATION_GUID = ORGANIZATIONS.GUID
+LEFT JOIN USERS_ROLES ON USERS_ROLES.USER_GUID = USERS.GUID
+
+WHERE MACHINES.SERIAL_NUMBER = '@']]></Text>
+          <UpdateTables>
+            <Table schema="dbo" name="USERS_ROLES" allowDelete="True" allowInsert="True" allowUpdate="True">
+              <KeyColumns>
+                <KeyColumn name="GUID" />
+              </KeyColumns>
+              <UpdateColumns>
+                <UpdateColumn name="ID" />
+                <UpdateColumn name="GUID" />
+                <UpdateColumn name="LAST_UPDATED" />
+                <UpdateColumn name="DELETED" />
+                <UpdateColumn name="USER_GUID" />
+                <UpdateColumn name="ROLE_GUID" />
+              </UpdateColumns>
+            </Table>
+          </UpdateTables>
+        </Query>
+      </Queries>
+    </Item>
+  </Items>
+  <SchemaMapping>
+    <SMItem schema1="dbo" schema2="dbo" />
+  </SchemaMapping>
+  <ProjectSettings>
+    <AllSettings>
+      <ComparisonCaseSensitive>1</ComparisonCaseSensitive>
+      <CompareTrimmedStrings>False</CompareTrimmedStrings>
+      <EmptyEqualsNull>False</EmptyEqualsNull>
+      <PrecedeStringConstWithNPrefix>0</PrecedeStringConstWithNPrefix>
+      <AutoSelectKeyColumns>0</AutoSelectKeyColumns>
+      <PerformanceOptions>
+        <PerformanceOption name="Auto" value="True" />
+      </PerformanceOptions>
+    </AllSettings>
+  </ProjectSettings>
+</SqlDataExaminer>
\ No newline at end of file
diff --git a/Software/DB/SQLExaminer Projects/Provision Machine.sdeproj b/Software/DB/SQLExaminer Projects/Provision Machine.sdeproj
new file mode 100644
index 000000000..1343686d3
--- /dev/null
+++ b/Software/DB/SQLExaminer Projects/Provision Machine.sdeproj
@@ -0,0 +1,1470 @@
+<SqlDataExaminer version="21">
+  <Sources>
+    <Source id="1">
+      <EngineType>MsSqlServer</EngineType>
+      <StorageType>LiveDb</StorageType>
+      <ServerName>localhost\sqlexpress</ServerName>
+      <Database>Tango</Database>
+      <WinAuth>False</WinAuth>
+      <AzurePwd>False</AzurePwd>
+      <Login>Synchronizer</Login>
+      <Password>Aa123456</Password>
+      <SavePasswords>true</SavePasswords>
+    </Source>
+    <Source id="2">
+      <EngineType>MsSqlServer</EngineType>
+      <StorageType>LiveDb</StorageType>
+      <ServerName>twine.local\sqltwine</ServerName>
+      <Database>Tango</Database>
+      <WinAuth>True</WinAuth>
+      <AzurePwd>False</AzurePwd>
+    </Source>
+  </Sources>
+  <Items>
+    <Item name="dbo.ACTION_TYPES" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="CODE" />
+        <Column name="NAME" />
+        <Column name="DESCRIPTION" />
+      </Columns>
+    </Item>
+    <Item name="dbo.ADDRESSES" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="DELETED" />
+        <Column name="ADDRESS_STRING" />
+        <Column name="LOCALITY" />
+        <Column name="COUNTRY" />
+        <Column name="CITY" />
+        <Column name="STATE" />
+        <Column name="COUNTRY_CODE" />
+        <Column name="POSTAL_CODE" />
+      </Columns>
+    </Item>
+    <Item name="dbo.APPLICATION_DISPLAY_PANEL_VERSIONS" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="VERSION" />
+        <Column name="NAME" />
+      </Columns>
+    </Item>
+    <Item name="dbo.APPLICATION_FIRMWARE_VERSIONS" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="VERSION" />
+        <Column name="NAME" />
+      </Columns>
+    </Item>
+    <Item name="dbo.APPLICATION_OS_VERSIONS" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="VERSION" />
+        <Column name="NAME" />
+      </Columns>
+    </Item>
+    <Item name="dbo.APPLICATION_VERSIONS" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="VERSION" />
+        <Column name="NAME" />
+      </Columns>
+    </Item>
+    <Item name="dbo.BRUSH_STOPS" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="SEGMENT_GUID" />
+        <Column name="COLOR_SPACE_GUID" />
+        <Column name="OFFSET_PERCENT" />
+        <Column name="STOP_INDEX" />
+        <Column name="CYAN" />
+        <Column name="MAGENTA" />
+        <Column name="YELLOW" />
+        <Column name="BLACK" />
+        <Column name="RED" />
+        <Column name="GREEN" />
+        <Column name="BLUE" />
+        <Column name="L" />
+        <Column name="A" />
+        <Column name="B" />
+        <Column name="V0" />
+        <Column name="V1" />
+        <Column name="V2" />
+        <Column name="V3" />
+        <Column name="V4" />
+        <Column name="V5" />
+        <Column name="V6" />
+        <Column name="V7" />
+        <Column name="CORRECTED" />
+        <Column name="COLOR_CATALOG_GUID" />
+        <Column name="COLOR_CATALOG_CODE" />
+      </Columns>
+    </Item>
+    <Item name="dbo.CARTRIDGE_TYPES" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="CODE" />
+        <Column name="NAME" />
+      </Columns>
+    </Item>
+    <Item name="dbo.CATS" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="NAME" />
+        <Column name="MACHINE_GUID" />
+        <Column name="RML_GUID" />
+        <Column name="LIQUID_TYPE_GUID" />
+        <Column name="DATA" />
+      </Columns>
+    </Item>
+    <Item name="dbo.CCTS" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="NAME" />
+        <Column name="DESCRIPTION" />
+        <Column name="FORWARD_FILE_NAME" />
+        <Column name="INVERSE_FILE_NAME" />
+        <Column name="FORWARD_DATA" />
+        <Column name="INVERSE_DATA" />
+        <Column name="VERSION" />
+        <Column name="RML_GUID" />
+      </Columns>
+    </Item>
+    <Item name="dbo.COLOR_CATALOGS" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="COLOR_SPACE_GUID" />
+        <Column name="COLOR_CODE" />
+        <Column name="NAME" />
+        <Column name="COLOR_GROUP" />
+        <Column name="CYAN" />
+        <Column name="MAGENTA" />
+        <Column name="YELLOW" />
+        <Column name="BLACK" />
+        <Column name="RED" />
+        <Column name="GREEN" />
+        <Column name="BLUE" />
+        <Column name="L" />
+        <Column name="A" />
+        <Column name="B" />
+        <Column name="V0" />
+        <Column name="V1" />
+        <Column name="V2" />
+        <Column name="V3" />
+        <Column name="V4" />
+        <Column name="V5" />
+        <Column name="V6" />
+        <Column name="V7" />
+      </Columns>
+    </Item>
+    <Item name="dbo.COLOR_SPACES" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="CODE" />
+        <Column name="NAME" />
+        <Column name="DESCRIPTION" />
+      </Columns>
+    </Item>
+    <Item name="dbo.CONFIGURATIONS" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="NAME" />
+        <Column name="CREATION_DATE" />
+        <Column name="APPLICATION_VERSION_GUID" />
+        <Column name="APPLICATION_OS_VERSION_GUID" />
+        <Column name="APPLICATION_FIRMWARE_VERSION_GUID" />
+        <Column name="APPLICATION_DISPLAY_PANEL_VERSION_GUID" />
+        <Column name="EMBEDDED_FIRMWARE_VERSION_GUID" />
+        <Column name="EMBEDDED_SOFTWARE_VERSION_GUID" />
+        <Column name="HARDWARE_VERSION_GUID" />
+      </Columns>
+    </Item>
+    <Item name="dbo.CONTACTS" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="DELETED" />
+        <Column name="FIRST_NAME" />
+        <Column name="LAST_NAME" />
+        <Column name="FULL_NAME" />
+        <Column name="EMAIL" />
+        <Column name="PHONE_NUMBER" />
+        <Column name="FAX" />
+      </Columns>
+    </Item>
+    <Item name="dbo.CUSTOMERS" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="ORGANIZATION_GUID" />
+        <Column name="NAME" />
+      </Columns>
+    </Item>
+    <Item name="dbo.DISPENSER_TYPES" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="CODE" />
+        <Column name="NAME" />
+        <Column name="NL_PER_PULSE" />
+        <Column name="CAPACITY" />
+      </Columns>
+    </Item>
+    <Item name="dbo.EMBEDDED_FIRMWARE_VERSIONS" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="VERSION" />
+        <Column name="NAME" />
+      </Columns>
+    </Item>
+    <Item name="dbo.EMBEDDED_SOFTWARE_VERSIONS" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="VERSION" />
+        <Column name="NAME" />
+      </Columns>
+    </Item>
+    <Item name="dbo.EVENT_TYPES" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="CODE" />
+        <Column name="NAME" />
+        <Column name="DESCRIPTION" />
+        <Column name="EVENT_TYPES_CATEGORY_GUID" />
+        <Column name="EVENT_TYPES_GROUP_GUID" />
+        <Column name="REQUIRES_USER_INTERVENTION" />
+        <Column name="HTML_PAGE_GUID" />
+        <Column name="RESOLVABLE" />
+      </Columns>
+    </Item>
+    <Item name="dbo.EVENT_TYPES_ACTIONS" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="EVENT_TYPE_GUID" />
+        <Column name="ACTION_TYPE_GUID" />
+      </Columns>
+    </Item>
+    <Item name="dbo.EVENT_TYPES_CATEGORIES" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="CODE" />
+        <Column name="NAME" />
+        <Column name="DESCRIPTION" />
+      </Columns>
+    </Item>
+    <Item name="dbo.EVENT_TYPES_GROUPS" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="CODE" />
+        <Column name="NAME" />
+        <Column name="DESCRIPTION" />
+      </Columns>
+    </Item>
+    <Item name="dbo.FIBER_SHAPES" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="NAME" />
+        <Column name="CODE" />
+      </Columns>
+    </Item>
+    <Item name="dbo.FIBER_SYNTHS" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="NAME" />
+        <Column name="CODE" />
+      </Columns>
+    </Item>
+    <Item name="dbo.HARDWARE_DANCER_TYPES" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="CODE" />
+        <Column name="NAME" />
+        <Column name="DESCRIPTION" />
+      </Columns>
+    </Item>
+    <Item name="dbo.HARDWARE_DANCERS" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="HARDWARE_DANCER_TYPE_GUID" />
+        <Column name="HARDWARE_VERSION_GUID" />
+        <Column name="GRADUAL" />
+        <Column name="K" />
+        <Column name="X" />
+        <Column name="PULSE_PER_MM_SPRING" />
+        <Column name="MAXIMAL_MOVEMENT_MM" />
+        <Column name="ZERO_POINT" />
+        <Column name="RESOLUTION_BITS" />
+        <Column name="ARM_LENGTH" />
+        <Column name="ASSEMBLY_DIRECTION_RIGHT" />
+        <Column name="ACCELERATE_ON_TENSION_RAISE" />
+      </Columns>
+    </Item>
+    <Item name="dbo.HARDWARE_MOTOR_TYPES" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="CODE" />
+        <Column name="NAME" />
+        <Column name="DESCRIPTION" />
+        <Column name="SUPPORTS_HOMING" />
+      </Columns>
+    </Item>
+    <Item name="dbo.HARDWARE_MOTORS" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="HARDWARE_MOTOR_TYPE_GUID" />
+        <Column name="HARDWARE_VERSION_GUID" />
+        <Column name="MIN_FREQUENCY" />
+        <Column name="MAX_FREQUENCY" />
+        <Column name="SET_MICRO_STEP" />
+        <Column name="MICRO_STEP" />
+        <Column name="MAX_CHANGE_SLOPE" />
+        <Column name="HIGH_LENGTH_MICRO_SECOND" />
+        <Column name="SPEED_MASTER" />
+        <Column name="PULSE_PER_ROUND" />
+        <Column name="PULLEY_RADIUS" />
+        <Column name="CONFIG_WORD" />
+        <Column name="DIRECTION_THREAD_WIZE" />
+        <Column name="KVAL_HOLD" />
+        <Column name="KVAL_RUN" />
+        <Column name="KVAL_ACC" />
+        <Column name="KVAL_DEC" />
+        <Column name="OVER_CURRENT_THRESHOLD" />
+        <Column name="STALL_THRESHOLD" />
+        <Column name="THERMAL_COMPENSATION_FACTOR" />
+        <Column name="LOW_SPEED_OPTIMIZATION" />
+        <Column name="ST_SLP" />
+        <Column name="INT_SPD" />
+        <Column name="FN_SLP_ACC" />
+        <Column name="FN_SLP_DEC" />
+        <Column name="FS_SPD" />
+      </Columns>
+    </Item>
+    <Item name="dbo.HARDWARE_PID_CONTROL_TYPES" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="CODE" />
+        <Column name="NAME" />
+        <Column name="DESCRIPTION" />
+      </Columns>
+    </Item>
+    <Item name="dbo.HARDWARE_PID_CONTROLS" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="HARDWARE_PID_CONTROL_TYPE_GUID" />
+        <Column name="HARDWARE_VERSION_GUID" />
+        <Column name="OUTPUT_PROPORTIONAL_POWER_LIMIT" />
+        <Column name="OUTPUT_PROPORTIONAL_BAND" />
+        <Column name="INTEGRAL_TIME" />
+        <Column name="DERIVATIVE_TIME" />
+        <Column name="SENSOR_CORRECTION_ADJUSTMENT" />
+        <Column name="SENSOR_MIN_VALUE" />
+        <Column name="SENSOR_MAX_VALUE" />
+        <Column name="SET_POINT_RAMP_RATEOR_SOFT_START_RAMP" />
+        <Column name="SET_POINT_CONTROL_OUTPUT_RATE" />
+        <Column name="CONTROL_OUTPUT_TYPE" />
+        <Column name="SSR_CONTROL_OUTPUT_TYPE" />
+        <Column name="OUTPUT_ON_OFF_HYSTERESIS_VALUE" />
+        <Column name="PROCESS_VARIABLE_SAMPLING_RATE" />
+        <Column name="PV_INPUT_FILTER_FACTOR_MODE" />
+        <Column name="OUTPUT_PROPORTIONAL_CYCLE_TIME" />
+        <Column name="AC_HEATERS__HALF_CYCLE_TIME" />
+        <Column name="PROPORTIONAL_GAIN" />
+      </Columns>
+    </Item>
+    <Item name="dbo.HARDWARE_SPEED_SENSOR_TYPES" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="CODE" />
+        <Column name="NAME" />
+        <Column name="DESCRIPTION" />
+      </Columns>
+    </Item>
+    <Item name="dbo.HARDWARE_SPEED_SENSORS" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="HARDWARE_SPEED_SENSOR_TYPE_GUID" />
+        <Column name="HARDWARE_VERSION_GUID" />
+        <Column name="RESOLUTION_BITS" />
+        <Column name="PERIMETER" />
+      </Columns>
+    </Item>
+    <Item name="dbo.HARDWARE_VERSIONS" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="VERSION" />
+        <Column name="NAME" />
+      </Columns>
+    </Item>
+    <Item name="dbo.HARDWARE_WINDER_TYPES" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="CODE" />
+        <Column name="NAME" />
+        <Column name="DESCRIPTION" />
+      </Columns>
+    </Item>
+    <Item name="dbo.HARDWARE_WINDERS" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="HARDWARE_WINDER_TYPE_GUID" />
+        <Column name="HARDWARE_VERSION_GUID" />
+        <Column name="MILLIMETER_PER_ROTATION" />
+      </Columns>
+    </Item>
+    <Item name="dbo.HTML_PAGES" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="CODE" />
+        <Column name="NAME" />
+        <Column name="DESCRIPTION" />
+        <Column name="HTML" />
+      </Columns>
+    </Item>
+    <Item name="dbo.IDS_PACK_FORMULAS" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="CODE" />
+        <Column name="NAME" />
+        <Column name="DESCRIPTION" />
+        <Column name="AUTO_CALCULATED" />
+      </Columns>
+    </Item>
+    <Item name="dbo.IDS_PACKS" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="CONFIGURATION_GUID" />
+        <Column name="DISPENSER_TYPE_GUID" />
+        <Column name="LIQUID_TYPE_GUID" />
+        <Column name="CARTRIDGE_TYPE_GUID" />
+        <Column name="MID_TANK_TYPE_GUID" />
+        <Column name="IDS_PACK_FORMULA_GUID" />
+        <Column name="NAME" />
+        <Column name="PACK_INDEX" />
+        <Column name="IS_EMPTY" />
+      </Columns>
+    </Item>
+    <Item name="dbo.JOB_RUNS" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="JOB_GUID" />
+        <Column name="START_DATE" />
+        <Column name="END_DATE" />
+        <Column name="SUCCESSFUL" />
+      </Columns>
+    </Item>
+    <Item name="dbo.JOBS" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="CREATION_DATE" />
+        <Column name="LAST_RUN" />
+        <Column name="MACHINE_GUID" />
+        <Column name="USER_GUID" />
+        <Column name="RML_GUID" />
+        <Column name="WINDING_METHOD_GUID" />
+        <Column name="SPOOL_TYPE_GUID" />
+        <Column name="NAME" />
+        <Column name="DESCRIPTION" />
+        <Column name="INTER_SEGMENT_LENGTH" />
+        <Column name="ENABLE_INTER_SEGMENT" />
+        <Column name="ENABLE_LUBRICATION" />
+        <Column name="JOB_INDEX" />
+        <Column name="ESTIMATED_DURATION_MILI" />
+        <Column name="HAS_EMBROIDERY_FILE" />
+        <Column name="EMBROIDERY_FILE_DATA" />
+        <Column name="EMBROIDERY_FILE_NAME" />
+        <Column name="EMBROIDERY_JPEG" />
+        <Column name="STATUS" />
+        <Column name="COLOR_SPACE_GUID" />
+        <Column name="NUMBER_OF_UNITS" />
+        <Column name="TYPE" />
+        <Column name="CUSTOMER_GUID" />
+        <Column name="SPOOLS_DISTRIBUTION" />
+        <Column name="NUMBER_OF_HEADS" />
+        <Column name="SAMPLE_UNITS_OR_METERS" />
+        <Column name="FINE_TUNING_STATUS" />
+        <Column name="FINE_TUNING_APPROVE_DATE" />
+        <Column name="SAMPLE_DYE_STATUS" />
+        <Column name="SAMPLE_DYE_APPROVE_DATE" />
+        <Column name="EDITING_STATE" />
+        <Column name="LENGTH_PERCENTAGE_FACTOR" />
+      </Columns>
+    </Item>
+    <Item name="dbo.LINEAR_MASS_DENSITY_UNITS" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="NAME" />
+        <Column name="CODE" />
+      </Columns>
+    </Item>
+    <Item name="dbo.LIQUID_TYPES" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="CODE" />
+        <Column name="NAME" />
+        <Column name="VERSION" />
+        <Column name="COLOR" />
+      </Columns>
+    </Item>
+    <Item name="dbo.LIQUID_TYPES_RMLS" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="LIQUID_TYPE_GUID" />
+        <Column name="RML_GUID" />
+        <Column name="MAX_NL_PER_CM" />
+      </Columns>
+    </Item>
+    <Item name="dbo.MACHINE_STUDIO_VERSIONS" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="VERSION" />
+        <Column name="FTP_FILE_PATH" />
+        <Column name="COMMENTS" />
+        <Column name="USER_GUID" />
+        <Column name="FORCE_UPDATE" />
+      </Columns>
+    </Item>
+    <Item name="dbo.MACHINE_VERSIONS" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="VERSION" />
+        <Column name="NAME" />
+        <Column name="DEFAULT_CONFIGURATION_GUID" />
+      </Columns>
+    </Item>
+    <Item name="dbo.MACHINES" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="SERIAL_NUMBER" />
+        <Column name="NAME" />
+        <Column name="PRODUCTION_DATE" />
+        <Column name="ORGANIZATION_GUID" />
+        <Column name="MACHINE_VERSION_GUID" />
+        <Column name="CONFIGURATION_GUID" />
+        <Column name="ENABLE_EXTERNAL_BRIDGE" />
+        <Column name="EXTERNAL_BRIDGE_PASSWORD" />
+        <Column name="DEFAULT_RML_GUID" />
+        <Column name="TARGET_JOB_TYPES" />
+        <Column name="DEFAULT_COLOR_SPACE_GUID" />
+        <Column name="DEFAULT_SEGMENT_LENGTH" />
+        <Column name="DEFAULT_SPOOL_TYPE_GUID" />
+        <Column name="SYNCHED" />
+      </Columns>
+    </Item>
+    <Item name="dbo.MACHINES_CONFIGURATIONS" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="MACHINE_GUID" />
+        <Column name="CONFIGURATION_GUID" />
+      </Columns>
+    </Item>
+    <Item name="dbo.MACHINES_EVENTS" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="HOST_NAME" />
+        <Column name="MACHINE_GUID" />
+        <Column name="EVENT_TYPE_GUID" />
+        <Column name="USER_GUID" />
+        <Column name="DATE_TIME" />
+        <Column name="DESCRIPTION" />
+      </Columns>
+    </Item>
+    <Item name="dbo.MACHINES_EVENTS_VIEW" type="view">
+      <Columns>
+        <Column name="DATE" />
+        <Column name="MACHINE" />
+        <Column name="USER_NAME" />
+        <Column name="GROUP" />
+        <Column name="CATEGORY" />
+        <Column name="TYPE" />
+        <Column name="DESCRIPTION" />
+      </Columns>
+    </Item>
+    <Item name="dbo.MEDIA_COLORS" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="NAME" />
+        <Column name="L" />
+        <Column name="A" />
+        <Column name="B" />
+      </Columns>
+    </Item>
+    <Item name="dbo.MEDIA_CONDITIONS" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="NAME" />
+        <Column name="CODE" />
+      </Columns>
+    </Item>
+    <Item name="dbo.MEDIA_MATERIALS" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="NAME" />
+        <Column name="CODE" />
+      </Columns>
+    </Item>
+    <Item name="dbo.MEDIA_PURPOSES" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="NAME" />
+        <Column name="CODE" />
+      </Columns>
+    </Item>
+    <Item name="dbo.MID_TANK_TYPES" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="CODE" />
+        <Column name="NAME" />
+        <Column name="LITER_CAPACITY" />
+      </Columns>
+    </Item>
+    <Item name="dbo.ORGANIZATIONS" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="NAME" />
+        <Column name="CONTACT_GUID" />
+        <Column name="ADDRESS_GUID" />
+      </Columns>
+    </Item>
+    <Item name="dbo.PERMISSIONS" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="CODE" />
+        <Column name="NAME" />
+        <Column name="DESCRIPTION" />
+      </Columns>
+    </Item>
+    <Item name="dbo.PROCESS_PARAMETERS_TABLES" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="NAME" />
+        <Column name="DYEING_SPEED" />
+        <Column name="MIN_INK_UPTAKE" />
+        <Column name="FEEDER_TENSION" />
+        <Column name="PULLER_TENSION" />
+        <Column name="WINDER_TENSION" />
+        <Column name="MIXER_TEMP" />
+        <Column name="HEAD_ZONE1_TEMP" />
+        <Column name="HEAD_ZONE2_TEMP" />
+        <Column name="HEAD_ZONE3_TEMP" />
+        <Column name="HEAD_ZONE4_TEMP" />
+        <Column name="HEAD_ZONE5_TEMP" />
+        <Column name="HEAD_ZONE6_TEMP" />
+        <Column name="DRYER_AIR_FLOW" />
+        <Column name="DRYER_ZONE1_TEMP" />
+        <Column name="DRYER_ZONE2_TEMP" />
+        <Column name="DRYER_ZONE3_TEMP" />
+        <Column name="DRYER_BUFFER_LENGTH" />
+        <Column name="HEAD_AIR_FLOW" />
+        <Column name="PROCESS_PARAMETERS_TABLES_GROUP_GUID" />
+        <Column name="TABLE_INDEX" />
+      </Columns>
+    </Item>
+    <Item name="dbo.PROCESS_PARAMETERS_TABLES_GROUPS" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="RML_GUID" />
+        <Column name="NAME" />
+        <Column name="ACTIVE" />
+        <Column name="SAVE_DATE" />
+      </Columns>
+    </Item>
+    <Item name="dbo.RMLS" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="NAME" />
+        <Column name="MANUFACTURER" />
+        <Column name="CODE" />
+        <Column name="MEDIA_MATERIAL_GUID" />
+        <Column name="MEDIA_COLOR_GUID" />
+        <Column name="MEDIA_PURPOSE_GUID" />
+        <Column name="MEDIA_CONDITION_GUID" />
+        <Column name="LINEAR_MASS_DENSITY_UNIT_GUID" />
+        <Column name="FIBER_SHAPE_GUID" />
+        <Column name="FIBER_SYNTH_GUID" />
+        <Column name="FIBER_SIZE" />
+        <Column name="NUMBER_OF_FIBERS" />
+        <Column name="PLIES_PER_FIBER" />
+        <Column name="PLIES_PER_THREAD" />
+        <Column name="TWISTED" />
+        <Column name="AIR_ENTANGLEMENT" />
+        <Column name="LUBRICANT" />
+        <Column name="TENSILE_STRENGTH" />
+        <Column name="ELONGATION_AT_BREAK_PERCENTAGE" />
+        <Column name="ESTIMATED_THREAD_DIAMETER" />
+      </Columns>
+    </Item>
+    <Item name="dbo.ROLES" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="CODE" />
+        <Column name="NAME" />
+        <Column name="DESCRIPTION" />
+      </Columns>
+    </Item>
+    <Item name="dbo.ROLES_PERMISSIONS" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="ROLE_GUID" />
+        <Column name="PERMISSION_GUID" />
+      </Columns>
+    </Item>
+    <Item name="dbo.SEGMENTS" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="NAME" />
+        <Column name="JOB_GUID" />
+        <Column name="LENGTH" />
+        <Column name="SEGMENT_INDEX" />
+      </Columns>
+    </Item>
+    <Item name="dbo.SPOOL_TYPES" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="CODE" />
+        <Column name="NAME" />
+        <Column name="LENGTH" />
+        <Column name="WEIGHT" />
+        <Column name="DIAMETER" />
+        <Column name="START_OFFSET_PULSES" />
+        <Column name="BACKING_RATE" />
+        <Column name="SEGMENT_OFFSET_PULSES" />
+        <Column name="BOTTOM_BACKING_RATE" />
+        <Column name="ROTATIONS_PER_PASSAGE" />
+      </Columns>
+    </Item>
+    <Item name="dbo.SYNC_CONFIGURATIONS" type="table">
+      <Columns>
+        <Column name="ID" key="true" />
+        <Column name="TABLE_NAME" />
+        <Column name="SYNC_TYPE" />
+      </Columns>
+    </Item>
+    <Item name="dbo.TECH_CONTROLLERS" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="CODE" />
+        <Column name="NAME" />
+        <Column name="DESCRIPTION" />
+        <Column name="MIN" />
+        <Column name="MAX" />
+        <Column name="UNITS" />
+      </Columns>
+    </Item>
+    <Item name="dbo.TECH_DISPENSERS" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="CODE" />
+        <Column name="NAME" />
+        <Column name="DESCRIPTION" />
+      </Columns>
+    </Item>
+    <Item name="dbo.TECH_IOS" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="PORT" />
+        <Column name="TYPE" />
+        <Column name="DESIGNATOR" />
+        <Column name="ASM" />
+        <Column name="INTERFACE_NAME" />
+        <Column name="SENSOR" />
+        <Column name="INIT_VALUE" />
+        <Column name="AVERAGING" />
+        <Column name="MIN" />
+        <Column name="MAX" />
+      </Columns>
+    </Item>
+    <Item name="dbo.TECH_MONITORS" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="CODE" />
+        <Column name="NAME" />
+        <Column name="DESCRIPTION" />
+        <Column name="MIN" />
+        <Column name="MAX" />
+        <Column name="UNITS" />
+        <Column name="POINTS_PER_FRAME" />
+        <Column name="MULTI_CHANNEL" />
+        <Column name="CHANNEL_COUNT" />
+      </Columns>
+    </Item>
+    <Item name="dbo.TECH_VALVES" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="CODE" />
+        <Column name="NAME" />
+        <Column name="DESCRIPTION" />
+      </Columns>
+    </Item>
+    <Item name="dbo.USERS" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="DELETED" />
+        <Column name="EMAIL" />
+        <Column name="PASSWORD" />
+        <Column name="ORGANIZATION_GUID" />
+        <Column name="CONTACT_GUID" />
+        <Column name="ADDRESS_GUID" />
+        <Column name="LAST_LOGIN" />
+      </Columns>
+    </Item>
+    <Item name="dbo.USERS_ROLES" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="DELETED" />
+        <Column name="USER_GUID" />
+        <Column name="ROLE_GUID" />
+      </Columns>
+    </Item>
+    <Item name="dbo.WINDING_METHODS" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="CODE" />
+        <Column name="NAME" />
+        <Column name="DESCRIPTION" />
+      </Columns>
+    </Item>
+    <Item name="Sync_Addresses" type="query" extracted="True">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="DELETED" />
+        <Column name="ADDRESS_STRING" />
+        <Column name="LOCALITY" />
+        <Column name="COUNTRY" />
+        <Column name="CITY" />
+        <Column name="STATE" />
+        <Column name="COUNTRY_CODE" />
+        <Column name="POSTAL_CODE" />
+      </Columns>
+      <Queries>
+        <Query id="1">
+          <Text><![CDATA[SELECT DISTINCT ADDRESSES.*
+
+FROM ORGANIZATIONS
+
+LEFT JOIN USERS ON USERS.ORGANIZATION_GUID = ORGANIZATION_GUID
+LEFT JOIN MACHINES ON MACHINES.ORGANIZATION_GUID = ORGANIZATIONS.GUID
+LEFT JOIN ADDRESSES ON ADDRESSES.GUID = USERS.ADDRESS_GUID OR ADDRESSES.GUID = ORGANIZATIONS.ADDRESS_GUID
+
+WHERE MACHINES.SERIAL_NUMBER = '@']]></Text>
+          <UpdateTables>
+            <Table schema="dbo" name="ADDRESSES" allowDelete="True" allowInsert="True" allowUpdate="True">
+              <KeyColumns>
+                <KeyColumn name="GUID" />
+              </KeyColumns>
+              <UpdateColumns>
+                <UpdateColumn name="ID" />
+                <UpdateColumn name="GUID" />
+                <UpdateColumn name="LAST_UPDATED" />
+                <UpdateColumn name="DELETED" />
+                <UpdateColumn name="ADDRESS_STRING" />
+                <UpdateColumn name="LOCALITY" />
+                <UpdateColumn name="COUNTRY" />
+                <UpdateColumn name="CITY" />
+                <UpdateColumn name="STATE" />
+                <UpdateColumn name="COUNTRY_CODE" />
+                <UpdateColumn name="POSTAL_CODE" />
+              </UpdateColumns>
+            </Table>
+          </UpdateTables>
+        </Query>
+        <Query id="2">
+          <Text><![CDATA[SELECT DISTINCT ADDRESSES.*
+
+FROM ORGANIZATIONS
+
+LEFT JOIN USERS ON USERS.ORGANIZATION_GUID = ORGANIZATION_GUID
+LEFT JOIN MACHINES ON MACHINES.ORGANIZATION_GUID = ORGANIZATIONS.GUID
+LEFT JOIN ADDRESSES ON ADDRESSES.GUID = USERS.ADDRESS_GUID OR ADDRESSES.GUID = ORGANIZATIONS.ADDRESS_GUID
+
+WHERE MACHINES.SERIAL_NUMBER = '@']]></Text>
+          <UpdateTables>
+            <Table schema="dbo" name="ADDRESSES" allowDelete="True" allowInsert="True" allowUpdate="True">
+              <KeyColumns>
+                <KeyColumn name="GUID" />
+              </KeyColumns>
+              <UpdateColumns>
+                <UpdateColumn name="ID" />
+                <UpdateColumn name="GUID" />
+                <UpdateColumn name="LAST_UPDATED" />
+                <UpdateColumn name="DELETED" />
+                <UpdateColumn name="ADDRESS_STRING" />
+                <UpdateColumn name="LOCALITY" />
+                <UpdateColumn name="COUNTRY" />
+                <UpdateColumn name="CITY" />
+                <UpdateColumn name="STATE" />
+                <UpdateColumn name="COUNTRY_CODE" />
+                <UpdateColumn name="POSTAL_CODE" />
+              </UpdateColumns>
+            </Table>
+          </UpdateTables>
+        </Query>
+      </Queries>
+    </Item>
+    <Item name="Sync_Configuration" type="query" extracted="True">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="NAME" />
+        <Column name="CREATION_DATE" />
+        <Column name="APPLICATION_VERSION_GUID" />
+        <Column name="APPLICATION_OS_VERSION_GUID" />
+        <Column name="APPLICATION_FIRMWARE_VERSION_GUID" />
+        <Column name="APPLICATION_DISPLAY_PANEL_VERSION_GUID" />
+        <Column name="EMBEDDED_FIRMWARE_VERSION_GUID" />
+        <Column name="EMBEDDED_SOFTWARE_VERSION_GUID" />
+        <Column name="HARDWARE_VERSION_GUID" />
+      </Columns>
+      <Queries>
+        <Query id="1">
+          <Text><![CDATA[SELECT CONFIGURATIONS.*
+FROM CONFIGURATIONS
+INNER JOIN MACHINES ON MACHINES.CONFIGURATION_GUID = CONFIGURATIONS.GUID
+WHERE MACHINES.SERIAL_NUMBER = '@']]></Text>
+          <UpdateTables>
+            <Table schema="dbo" name="CONFIGURATIONS" allowDelete="True" allowInsert="True" allowUpdate="True">
+              <KeyColumns>
+                <KeyColumn name="GUID" />
+              </KeyColumns>
+              <UpdateColumns>
+                <UpdateColumn name="ID" />
+                <UpdateColumn name="GUID" />
+                <UpdateColumn name="LAST_UPDATED" />
+                <UpdateColumn name="NAME" />
+                <UpdateColumn name="CREATION_DATE" />
+                <UpdateColumn name="APPLICATION_VERSION_GUID" />
+                <UpdateColumn name="APPLICATION_OS_VERSION_GUID" />
+                <UpdateColumn name="APPLICATION_FIRMWARE_VERSION_GUID" />
+                <UpdateColumn name="APPLICATION_DISPLAY_PANEL_VERSION_GUID" />
+                <UpdateColumn name="EMBEDDED_FIRMWARE_VERSION_GUID" />
+                <UpdateColumn name="EMBEDDED_SOFTWARE_VERSION_GUID" />
+                <UpdateColumn name="HARDWARE_VERSION_GUID" />
+              </UpdateColumns>
+            </Table>
+          </UpdateTables>
+        </Query>
+        <Query id="2">
+          <Text><![CDATA[SELECT CONFIGURATIONS.*
+FROM CONFIGURATIONS
+INNER JOIN MACHINES ON MACHINES.CONFIGURATION_GUID = CONFIGURATIONS.GUID
+WHERE MACHINES.SERIAL_NUMBER = '@']]></Text>
+          <UpdateTables>
+            <Table schema="dbo" name="CONFIGURATIONS" allowDelete="True" allowInsert="True" allowUpdate="True">
+              <KeyColumns>
+                <KeyColumn name="GUID" />
+              </KeyColumns>
+              <UpdateColumns>
+                <UpdateColumn name="ID" />
+                <UpdateColumn name="GUID" />
+                <UpdateColumn name="LAST_UPDATED" />
+                <UpdateColumn name="NAME" />
+                <UpdateColumn name="CREATION_DATE" />
+                <UpdateColumn name="APPLICATION_VERSION_GUID" />
+                <UpdateColumn name="APPLICATION_OS_VERSION_GUID" />
+                <UpdateColumn name="APPLICATION_FIRMWARE_VERSION_GUID" />
+                <UpdateColumn name="APPLICATION_DISPLAY_PANEL_VERSION_GUID" />
+                <UpdateColumn name="EMBEDDED_FIRMWARE_VERSION_GUID" />
+                <UpdateColumn name="EMBEDDED_SOFTWARE_VERSION_GUID" />
+                <UpdateColumn name="HARDWARE_VERSION_GUID" />
+              </UpdateColumns>
+            </Table>
+          </UpdateTables>
+        </Query>
+      </Queries>
+    </Item>
+    <Item name="Sync_Contacts" type="query" extracted="True">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="DELETED" />
+        <Column name="FIRST_NAME" />
+        <Column name="LAST_NAME" />
+        <Column name="FULL_NAME" />
+        <Column name="EMAIL" />
+        <Column name="PHONE_NUMBER" />
+        <Column name="FAX" />
+      </Columns>
+      <Queries>
+        <Query id="1">
+          <Text><![CDATA[SELECT DISTINCT CONTACTS.*
+
+FROM ORGANIZATIONS
+
+LEFT JOIN USERS ON USERS.ORGANIZATION_GUID = ORGANIZATION_GUID
+LEFT JOIN MACHINES ON MACHINES.ORGANIZATION_GUID = ORGANIZATIONS.GUID
+LEFT JOIN CONTACTS ON CONTACTS.GUID = USERS.CONTACT_GUID OR CONTACTS.GUID = ORGANIZATIONS.CONTACT_GUID
+
+WHERE MACHINES.SERIAL_NUMBER = '@']]></Text>
+          <UpdateTables>
+            <Table schema="dbo" name="CONTACTS" allowDelete="True" allowInsert="True" allowUpdate="True">
+              <KeyColumns>
+                <KeyColumn name="GUID" />
+              </KeyColumns>
+              <UpdateColumns>
+                <UpdateColumn name="ID" />
+                <UpdateColumn name="GUID" />
+                <UpdateColumn name="LAST_UPDATED" />
+                <UpdateColumn name="DELETED" />
+                <UpdateColumn name="FIRST_NAME" />
+                <UpdateColumn name="LAST_NAME" />
+                <UpdateColumn name="FULL_NAME" />
+                <UpdateColumn name="EMAIL" />
+                <UpdateColumn name="PHONE_NUMBER" />
+                <UpdateColumn name="FAX" />
+              </UpdateColumns>
+            </Table>
+          </UpdateTables>
+        </Query>
+        <Query id="2">
+          <Text><![CDATA[SELECT DISTINCT CONTACTS.*
+
+FROM ORGANIZATIONS
+
+LEFT JOIN USERS ON USERS.ORGANIZATION_GUID = ORGANIZATION_GUID
+LEFT JOIN MACHINES ON MACHINES.ORGANIZATION_GUID = ORGANIZATIONS.GUID
+LEFT JOIN CONTACTS ON CONTACTS.GUID = USERS.CONTACT_GUID OR CONTACTS.GUID = ORGANIZATIONS.CONTACT_GUID
+
+WHERE MACHINES.SERIAL_NUMBER = '@']]></Text>
+          <UpdateTables>
+            <Table schema="dbo" name="CONTACTS" allowDelete="True" allowInsert="True" allowUpdate="True">
+              <KeyColumns>
+                <KeyColumn name="GUID" />
+              </KeyColumns>
+              <UpdateColumns>
+                <UpdateColumn name="ID" />
+                <UpdateColumn name="GUID" />
+                <UpdateColumn name="LAST_UPDATED" />
+                <UpdateColumn name="DELETED" />
+                <UpdateColumn name="FIRST_NAME" />
+                <UpdateColumn name="LAST_NAME" />
+                <UpdateColumn name="FULL_NAME" />
+                <UpdateColumn name="EMAIL" />
+                <UpdateColumn name="PHONE_NUMBER" />
+                <UpdateColumn name="FAX" />
+              </UpdateColumns>
+            </Table>
+          </UpdateTables>
+        </Query>
+      </Queries>
+    </Item>
+    <Item name="Sync_IdsPacks" type="query" extracted="True">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="CONFIGURATION_GUID" />
+        <Column name="DISPENSER_TYPE_GUID" />
+        <Column name="LIQUID_TYPE_GUID" />
+        <Column name="CARTRIDGE_TYPE_GUID" />
+        <Column name="MID_TANK_TYPE_GUID" />
+        <Column name="IDS_PACK_FORMULA_GUID" />
+        <Column name="NAME" />
+        <Column name="PACK_INDEX" />
+        <Column name="IS_EMPTY" />
+      </Columns>
+      <Queries>
+        <Query id="1">
+          <Text><![CDATA[SELECT IDS_PACKS.*
+
+FROM MACHINES 
+	INNER JOIN CONFIGURATIONS ON MACHINES.CONFIGURATION_GUID = CONFIGURATIONS.GUID 
+	INNER JOIN IDS_PACKS ON CONFIGURATIONS.GUID = IDS_PACKS.CONFIGURATION_GUID
+
+WHERE MACHINES.SERIAL_NUMBER = '@'
+]]></Text>
+        </Query>
+        <Query id="2">
+          <Text><![CDATA[SELECT IDS_PACKS.*
+
+FROM MACHINES 
+	INNER JOIN CONFIGURATIONS ON MACHINES.CONFIGURATION_GUID = CONFIGURATIONS.GUID 
+	INNER JOIN IDS_PACKS ON CONFIGURATIONS.GUID = IDS_PACKS.CONFIGURATION_GUID
+
+WHERE MACHINES.SERIAL_NUMBER = '@'
+]]></Text>
+          <UpdateTables>
+            <Table schema="dbo" name="IDS_PACKS" allowDelete="True" allowInsert="True" allowUpdate="True">
+              <KeyColumns>
+                <KeyColumn name="GUID" />
+              </KeyColumns>
+              <UpdateColumns>
+                <UpdateColumn name="ID" />
+                <UpdateColumn name="GUID" />
+                <UpdateColumn name="LAST_UPDATED" />
+                <UpdateColumn name="CONFIGURATION_GUID" />
+                <UpdateColumn name="DISPENSER_TYPE_GUID" />
+                <UpdateColumn name="LIQUID_TYPE_GUID" />
+                <UpdateColumn name="CARTRIDGE_TYPE_GUID" />
+                <UpdateColumn name="MID_TANK_TYPE_GUID" />
+                <UpdateColumn name="IDS_PACK_FORMULA_GUID" />
+                <UpdateColumn name="NAME" />
+                <UpdateColumn name="PACK_INDEX" />
+                <UpdateColumn name="IS_EMPTY" />
+              </UpdateColumns>
+            </Table>
+          </UpdateTables>
+        </Query>
+      </Queries>
+    </Item>
+    <Item name="Sync_Machine" type="query" extracted="True">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="SERIAL_NUMBER" />
+        <Column name="NAME" />
+        <Column name="PRODUCTION_DATE" />
+        <Column name="ORGANIZATION_GUID" />
+        <Column name="MACHINE_VERSION_GUID" />
+        <Column name="CONFIGURATION_GUID" />
+        <Column name="ENABLE_EXTERNAL_BRIDGE" />
+        <Column name="EXTERNAL_BRIDGE_PASSWORD" />
+        <Column name="DEFAULT_RML_GUID" />
+        <Column name="TARGET_JOB_TYPES" />
+        <Column name="DEFAULT_COLOR_SPACE_GUID" />
+        <Column name="DEFAULT_SEGMENT_LENGTH" />
+        <Column name="DEFAULT_SPOOL_TYPE_GUID" />
+        <Column name="SYNCHED" />
+      </Columns>
+      <Queries>
+        <Query id="1">
+          <Text><![CDATA[SELECT * FROM MACHINES WHERE MACHINES.SERIAL_NUMBER = '@']]></Text>
+          <UpdateTables>
+            <Table schema="dbo" name="MACHINES" allowDelete="True" allowInsert="True" allowUpdate="True">
+              <KeyColumns>
+                <KeyColumn name="GUID" />
+              </KeyColumns>
+              <UpdateColumns>
+                <UpdateColumn name="ID" />
+                <UpdateColumn name="GUID" />
+                <UpdateColumn name="LAST_UPDATED" />
+                <UpdateColumn name="SERIAL_NUMBER" />
+                <UpdateColumn name="NAME" />
+                <UpdateColumn name="PRODUCTION_DATE" />
+                <UpdateColumn name="ORGANIZATION_GUID" />
+                <UpdateColumn name="MACHINE_VERSION_GUID" />
+                <UpdateColumn name="CONFIGURATION_GUID" />
+                <UpdateColumn name="ENABLE_EXTERNAL_BRIDGE" />
+                <UpdateColumn name="EXTERNAL_BRIDGE_PASSWORD" />
+                <UpdateColumn name="DEFAULT_RML_GUID" />
+                <UpdateColumn name="TARGET_JOB_TYPES" />
+                <UpdateColumn name="DEFAULT_COLOR_SPACE_GUID" />
+                <UpdateColumn name="DEFAULT_SEGMENT_LENGTH" />
+                <UpdateColumn name="DEFAULT_SPOOL_TYPE_GUID" />
+                <UpdateColumn name="SYNCHED" />
+              </UpdateColumns>
+            </Table>
+          </UpdateTables>
+        </Query>
+        <Query id="2">
+          <Text><![CDATA[SELECT * FROM MACHINES WHERE MACHINES.SERIAL_NUMBER = '@']]></Text>
+          <UpdateTables>
+            <Table schema="dbo" name="MACHINES" allowDelete="True" allowInsert="True" allowUpdate="True">
+              <KeyColumns>
+                <KeyColumn name="GUID" />
+              </KeyColumns>
+              <UpdateColumns>
+                <UpdateColumn name="ID" />
+                <UpdateColumn name="GUID" />
+                <UpdateColumn name="LAST_UPDATED" />
+                <UpdateColumn name="SERIAL_NUMBER" />
+                <UpdateColumn name="NAME" />
+                <UpdateColumn name="PRODUCTION_DATE" />
+                <UpdateColumn name="ORGANIZATION_GUID" />
+                <UpdateColumn name="MACHINE_VERSION_GUID" />
+                <UpdateColumn name="CONFIGURATION_GUID" />
+                <UpdateColumn name="ENABLE_EXTERNAL_BRIDGE" />
+                <UpdateColumn name="EXTERNAL_BRIDGE_PASSWORD" />
+                <UpdateColumn name="DEFAULT_RML_GUID" />
+                <UpdateColumn name="TARGET_JOB_TYPES" />
+                <UpdateColumn name="DEFAULT_COLOR_SPACE_GUID" />
+                <UpdateColumn name="DEFAULT_SEGMENT_LENGTH" />
+                <UpdateColumn name="DEFAULT_SPOOL_TYPE_GUID" />
+                <UpdateColumn name="SYNCHED" />
+              </UpdateColumns>
+            </Table>
+          </UpdateTables>
+        </Query>
+      </Queries>
+    </Item>
+    <Item name="Sync_Organization" type="query" extracted="True">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="NAME" />
+        <Column name="CONTACT_GUID" />
+        <Column name="ADDRESS_GUID" />
+      </Columns>
+      <Queries>
+        <Query id="1">
+          <Text><![CDATA[SELECT ORGANIZATIONS.*
+
+FROM ORGANIZATIONS
+
+INNER JOIN MACHINES ON MACHINES.ORGANIZATION_GUID = ORGANIZATIONS.GUID
+
+WHERE MACHINES.SERIAL_NUMBER = '@']]></Text>
+          <UpdateTables>
+            <Table schema="dbo" name="ORGANIZATIONS" allowDelete="True" allowInsert="True" allowUpdate="True">
+              <KeyColumns>
+                <KeyColumn name="GUID" />
+              </KeyColumns>
+              <UpdateColumns>
+                <UpdateColumn name="ID" />
+                <UpdateColumn name="GUID" />
+                <UpdateColumn name="LAST_UPDATED" />
+                <UpdateColumn name="NAME" />
+                <UpdateColumn name="CONTACT_GUID" />
+                <UpdateColumn name="ADDRESS_GUID" />
+              </UpdateColumns>
+            </Table>
+          </UpdateTables>
+        </Query>
+        <Query id="2">
+          <Text><![CDATA[SELECT ORGANIZATIONS.*
+
+FROM ORGANIZATIONS
+
+INNER JOIN MACHINES ON MACHINES.ORGANIZATION_GUID = ORGANIZATIONS.GUID
+
+WHERE MACHINES.SERIAL_NUMBER = '@']]></Text>
+          <UpdateTables>
+            <Table schema="dbo" name="ORGANIZATIONS" allowDelete="True" allowInsert="True" allowUpdate="True">
+              <KeyColumns>
+                <KeyColumn name="GUID" />
+              </KeyColumns>
+              <UpdateColumns>
+                <UpdateColumn name="ID" />
+                <UpdateColumn name="GUID" />
+                <UpdateColumn name="LAST_UPDATED" />
+                <UpdateColumn name="NAME" />
+                <UpdateColumn name="CONTACT_GUID" />
+                <UpdateColumn name="ADDRESS_GUID" />
+              </UpdateColumns>
+            </Table>
+          </UpdateTables>
+        </Query>
+      </Queries>
+    </Item>
+    <Item name="Sync_UsersRoles" type="query" extracted="True">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="DELETED" />
+        <Column name="USER_GUID" />
+        <Column name="ROLE_GUID" />
+      </Columns>
+      <Queries>
+        <Query id="1">
+          <Text><![CDATA[SELECT DISTINCT USERS_ROLES.*
+
+FROM ORGANIZATIONS
+
+LEFT JOIN USERS ON USERS.ORGANIZATION_GUID = ORGANIZATION_GUID
+LEFT JOIN MACHINES ON MACHINES.ORGANIZATION_GUID = ORGANIZATIONS.GUID
+LEFT JOIN USERS_ROLES ON USERS_ROLES.USER_GUID = USERS.GUID
+
+WHERE MACHINES.SERIAL_NUMBER = '@']]></Text>
+          <UpdateTables>
+            <Table schema="dbo" name="USERS_ROLES" allowDelete="True" allowInsert="True" allowUpdate="True">
+              <KeyColumns>
+                <KeyColumn name="GUID" />
+              </KeyColumns>
+              <UpdateColumns>
+                <UpdateColumn name="ID" />
+                <UpdateColumn name="GUID" />
+                <UpdateColumn name="LAST_UPDATED" />
+                <UpdateColumn name="DELETED" />
+                <UpdateColumn name="USER_GUID" />
+                <UpdateColumn name="ROLE_GUID" />
+              </UpdateColumns>
+            </Table>
+          </UpdateTables>
+        </Query>
+        <Query id="2">
+          <Text><![CDATA[SELECT DISTINCT USERS_ROLES.*
+
+FROM ORGANIZATIONS
+
+LEFT JOIN USERS ON USERS.ORGANIZATION_GUID = ORGANIZATION_GUID
+LEFT JOIN MACHINES ON MACHINES.ORGANIZATION_GUID = ORGANIZATIONS.GUID
+LEFT JOIN USERS_ROLES ON USERS_ROLES.USER_GUID = USERS.GUID
+
+WHERE MACHINES.SERIAL_NUMBER = '@']]></Text>
+          <UpdateTables>
+            <Table schema="dbo" name="USERS_ROLES" allowDelete="True" allowInsert="True" allowUpdate="True">
+              <KeyColumns>
+                <KeyColumn name="GUID" />
+              </KeyColumns>
+              <UpdateColumns>
+                <UpdateColumn name="ID" />
+                <UpdateColumn name="GUID" />
+                <UpdateColumn name="LAST_UPDATED" />
+                <UpdateColumn name="DELETED" />
+                <UpdateColumn name="USER_GUID" />
+                <UpdateColumn name="ROLE_GUID" />
+              </UpdateColumns>
+            </Table>
+          </UpdateTables>
+        </Query>
+      </Queries>
+    </Item>
+  </Items>
+  <SchemaMapping>
+    <SMItem schema1="dbo" schema2="dbo" />
+  </SchemaMapping>
+  <ProjectSettings>
+    <AllSettings>
+      <ComparisonCaseSensitive>1</ComparisonCaseSensitive>
+      <CompareTrimmedStrings>False</CompareTrimmedStrings>
+      <EmptyEqualsNull>False</EmptyEqualsNull>
+      <PrecedeStringConstWithNPrefix>0</PrecedeStringConstWithNPrefix>
+      <AutoSelectKeyColumns>0</AutoSelectKeyColumns>
+      <PerformanceOptions>
+        <PerformanceOption name="Auto" value="True" />
+      </PerformanceOptions>
+    </AllSettings>
+  </ProjectSettings>
+</SqlDataExaminer>
\ No newline at end of file