Working on SQLExaminer lib

3 files changed, 55 insertions, 548 deletions

diff --git a/Software/DB/SQLExaminer Projects/Override Tables.sdeproj b/Software/DB/SQLExaminer Projects/Override Tables.sdeproj
index 1343686d3..6b27b8c9a 100644
--- a/Software/DB/SQLExaminer Projects/Override Tables.sdeproj
+++ b/Software/DB/SQLExaminer Projects/Override Tables.sdeproj
@@ -8,8 +8,6 @@
       <WinAuth>False</WinAuth>
       <AzurePwd>False</AzurePwd>
       <Login>Synchronizer</Login>
-      <Password>Aa123456</Password>
-      <SavePasswords>true</SavePasswords>
     </Source>
     <Source id="2">
       <EngineType>MsSqlServer</EngineType>
@@ -21,7 +19,7 @@
     </Source>
   </Sources>
   <Items>
-    <Item name="dbo.ACTION_TYPES" type="table">
+    <Item name="dbo.ACTION_TYPES" type="table" extracted="True">
       <Columns>
         <Column name="GUID" key="true" />
         <Column name="ID" />
@@ -46,7 +44,7 @@
         <Column name="POSTAL_CODE" />
       </Columns>
     </Item>
-    <Item name="dbo.APPLICATION_DISPLAY_PANEL_VERSIONS" type="table">
+    <Item name="dbo.APPLICATION_DISPLAY_PANEL_VERSIONS" type="table" extracted="True">
       <Columns>
         <Column name="GUID" key="true" />
         <Column name="ID" />
@@ -55,7 +53,7 @@
         <Column name="NAME" />
       </Columns>
     </Item>
-    <Item name="dbo.APPLICATION_FIRMWARE_VERSIONS" type="table">
+    <Item name="dbo.APPLICATION_FIRMWARE_VERSIONS" type="table" extracted="True">
       <Columns>
         <Column name="GUID" key="true" />
         <Column name="ID" />
@@ -64,7 +62,7 @@
         <Column name="NAME" />
       </Columns>
     </Item>
-    <Item name="dbo.APPLICATION_OS_VERSIONS" type="table">
+    <Item name="dbo.APPLICATION_OS_VERSIONS" type="table" extracted="True">
       <Columns>
         <Column name="GUID" key="true" />
         <Column name="ID" />
@@ -73,7 +71,7 @@
         <Column name="NAME" />
       </Columns>
     </Item>
-    <Item name="dbo.APPLICATION_VERSIONS" type="table">
+    <Item name="dbo.APPLICATION_VERSIONS" type="table" extracted="True">
       <Columns>
         <Column name="GUID" key="true" />
         <Column name="ID" />
@@ -114,7 +112,7 @@
         <Column name="COLOR_CATALOG_CODE" />
       </Columns>
     </Item>
-    <Item name="dbo.CARTRIDGE_TYPES" type="table">
+    <Item name="dbo.CARTRIDGE_TYPES" type="table" extracted="True">
       <Columns>
         <Column name="GUID" key="true" />
         <Column name="ID" />
@@ -123,7 +121,7 @@
         <Column name="NAME" />
       </Columns>
     </Item>
-    <Item name="dbo.CATS" type="table">
+    <Item name="dbo.CATS" type="table" extracted="True">
       <Columns>
         <Column name="GUID" key="true" />
         <Column name="ID" />
@@ -135,7 +133,7 @@
         <Column name="DATA" />
       </Columns>
     </Item>
-    <Item name="dbo.CCTS" type="table">
+    <Item name="dbo.CCTS" type="table" extracted="True">
       <Columns>
         <Column name="GUID" key="true" />
         <Column name="ID" />
@@ -150,7 +148,7 @@
         <Column name="RML_GUID" />
       </Columns>
     </Item>
-    <Item name="dbo.COLOR_CATALOGS" type="table">
+    <Item name="dbo.COLOR_CATALOGS" type="table" extracted="True">
       <Columns>
         <Column name="GUID" key="true" />
         <Column name="ID" />
@@ -179,7 +177,7 @@
         <Column name="V7" />
       </Columns>
     </Item>
-    <Item name="dbo.COLOR_SPACES" type="table">
+    <Item name="dbo.COLOR_SPACES" type="table" extracted="True">
       <Columns>
         <Column name="GUID" key="true" />
         <Column name="ID" />
@@ -228,7 +226,7 @@
         <Column name="NAME" />
       </Columns>
     </Item>
-    <Item name="dbo.DISPENSER_TYPES" type="table">
+    <Item name="dbo.DISPENSER_TYPES" type="table" extracted="True">
       <Columns>
         <Column name="GUID" key="true" />
         <Column name="ID" />
@@ -239,7 +237,7 @@
         <Column name="CAPACITY" />
       </Columns>
     </Item>
-    <Item name="dbo.EMBEDDED_FIRMWARE_VERSIONS" type="table">
+    <Item name="dbo.EMBEDDED_FIRMWARE_VERSIONS" type="table" extracted="True">
       <Columns>
         <Column name="GUID" key="true" />
         <Column name="ID" />
@@ -248,7 +246,7 @@
         <Column name="NAME" />
       </Columns>
     </Item>
-    <Item name="dbo.EMBEDDED_SOFTWARE_VERSIONS" type="table">
+    <Item name="dbo.EMBEDDED_SOFTWARE_VERSIONS" type="table" extracted="True">
       <Columns>
         <Column name="GUID" key="true" />
         <Column name="ID" />
@@ -257,7 +255,7 @@
         <Column name="NAME" />
       </Columns>
     </Item>
-    <Item name="dbo.EVENT_TYPES" type="table">
+    <Item name="dbo.EVENT_TYPES" type="table" extracted="True">
       <Columns>
         <Column name="GUID" key="true" />
         <Column name="ID" />
@@ -272,7 +270,7 @@
         <Column name="RESOLVABLE" />
       </Columns>
     </Item>
-    <Item name="dbo.EVENT_TYPES_ACTIONS" type="table">
+    <Item name="dbo.EVENT_TYPES_ACTIONS" type="table" extracted="True">
       <Columns>
         <Column name="GUID" key="true" />
         <Column name="ID" />
@@ -281,7 +279,7 @@
         <Column name="ACTION_TYPE_GUID" />
       </Columns>
     </Item>
-    <Item name="dbo.EVENT_TYPES_CATEGORIES" type="table">
+    <Item name="dbo.EVENT_TYPES_CATEGORIES" type="table" extracted="True">
       <Columns>
         <Column name="GUID" key="true" />
         <Column name="ID" />
@@ -291,7 +289,7 @@
         <Column name="DESCRIPTION" />
       </Columns>
     </Item>
-    <Item name="dbo.EVENT_TYPES_GROUPS" type="table">
+    <Item name="dbo.EVENT_TYPES_GROUPS" type="table" extracted="True">
       <Columns>
         <Column name="GUID" key="true" />
         <Column name="ID" />
@@ -301,7 +299,7 @@
         <Column name="DESCRIPTION" />
       </Columns>
     </Item>
-    <Item name="dbo.FIBER_SHAPES" type="table">
+    <Item name="dbo.FIBER_SHAPES" type="table" extracted="True">
       <Columns>
         <Column name="GUID" key="true" />
         <Column name="ID" />
@@ -310,7 +308,7 @@
         <Column name="CODE" />
       </Columns>
     </Item>
-    <Item name="dbo.FIBER_SYNTHS" type="table">
+    <Item name="dbo.FIBER_SYNTHS" type="table" extracted="True">
       <Columns>
         <Column name="GUID" key="true" />
         <Column name="ID" />
@@ -319,7 +317,7 @@
         <Column name="CODE" />
       </Columns>
     </Item>
-    <Item name="dbo.HARDWARE_DANCER_TYPES" type="table">
+    <Item name="dbo.HARDWARE_DANCER_TYPES" type="table" extracted="True">
       <Columns>
         <Column name="GUID" key="true" />
         <Column name="ID" />
@@ -329,7 +327,7 @@
         <Column name="DESCRIPTION" />
       </Columns>
     </Item>
-    <Item name="dbo.HARDWARE_DANCERS" type="table">
+    <Item name="dbo.HARDWARE_DANCERS" type="table" extracted="True">
       <Columns>
         <Column name="GUID" key="true" />
         <Column name="ID" />
@@ -348,7 +346,7 @@
         <Column name="ACCELERATE_ON_TENSION_RAISE" />
       </Columns>
     </Item>
-    <Item name="dbo.HARDWARE_MOTOR_TYPES" type="table">
+    <Item name="dbo.HARDWARE_MOTOR_TYPES" type="table" extracted="True">
       <Columns>
         <Column name="GUID" key="true" />
         <Column name="ID" />
@@ -359,7 +357,7 @@
         <Column name="SUPPORTS_HOMING" />
       </Columns>
     </Item>
-    <Item name="dbo.HARDWARE_MOTORS" type="table">
+    <Item name="dbo.HARDWARE_MOTORS" type="table" extracted="True">
       <Columns>
         <Column name="GUID" key="true" />
         <Column name="ID" />
@@ -392,7 +390,7 @@
         <Column name="FS_SPD" />
       </Columns>
     </Item>
-    <Item name="dbo.HARDWARE_PID_CONTROL_TYPES" type="table">
+    <Item name="dbo.HARDWARE_PID_CONTROL_TYPES" type="table" extracted="True">
       <Columns>
         <Column name="GUID" key="true" />
         <Column name="ID" />
@@ -402,7 +400,7 @@
         <Column name="DESCRIPTION" />
       </Columns>
     </Item>
-    <Item name="dbo.HARDWARE_PID_CONTROLS" type="table">
+    <Item name="dbo.HARDWARE_PID_CONTROLS" type="table" extracted="True">
       <Columns>
         <Column name="GUID" key="true" />
         <Column name="ID" />
@@ -428,7 +426,7 @@
         <Column name="PROPORTIONAL_GAIN" />
       </Columns>
     </Item>
-    <Item name="dbo.HARDWARE_SPEED_SENSOR_TYPES" type="table">
+    <Item name="dbo.HARDWARE_SPEED_SENSOR_TYPES" type="table" extracted="True">
       <Columns>
         <Column name="GUID" key="true" />
         <Column name="ID" />
@@ -438,7 +436,7 @@
         <Column name="DESCRIPTION" />
       </Columns>
     </Item>
-    <Item name="dbo.HARDWARE_SPEED_SENSORS" type="table">
+    <Item name="dbo.HARDWARE_SPEED_SENSORS" type="table" extracted="True">
       <Columns>
         <Column name="GUID" key="true" />
         <Column name="ID" />
@@ -449,7 +447,7 @@
         <Column name="PERIMETER" />
       </Columns>
     </Item>
-    <Item name="dbo.HARDWARE_VERSIONS" type="table">
+    <Item name="dbo.HARDWARE_VERSIONS" type="table" extracted="True">
       <Columns>
         <Column name="GUID" key="true" />
         <Column name="ID" />
@@ -458,7 +456,7 @@
         <Column name="NAME" />
       </Columns>
     </Item>
-    <Item name="dbo.HARDWARE_WINDER_TYPES" type="table">
+    <Item name="dbo.HARDWARE_WINDER_TYPES" type="table" extracted="True">
       <Columns>
         <Column name="GUID" key="true" />
         <Column name="ID" />
@@ -468,7 +466,7 @@
         <Column name="DESCRIPTION" />
       </Columns>
     </Item>
-    <Item name="dbo.HARDWARE_WINDERS" type="table">
+    <Item name="dbo.HARDWARE_WINDERS" type="table" extracted="True">
       <Columns>
         <Column name="GUID" key="true" />
         <Column name="ID" />
@@ -478,7 +476,7 @@
         <Column name="MILLIMETER_PER_ROTATION" />
       </Columns>
     </Item>
-    <Item name="dbo.HTML_PAGES" type="table">
+    <Item name="dbo.HTML_PAGES" type="table" extracted="True">
       <Columns>
         <Column name="GUID" key="true" />
         <Column name="ID" />
@@ -489,7 +487,7 @@
         <Column name="HTML" />
       </Columns>
     </Item>
-    <Item name="dbo.IDS_PACK_FORMULAS" type="table">
+    <Item name="dbo.IDS_PACK_FORMULAS" type="table" extracted="True">
       <Columns>
         <Column name="GUID" key="true" />
         <Column name="ID" />
@@ -566,7 +564,7 @@
         <Column name="LENGTH_PERCENTAGE_FACTOR" />
       </Columns>
     </Item>
-    <Item name="dbo.LINEAR_MASS_DENSITY_UNITS" type="table">
+    <Item name="dbo.LINEAR_MASS_DENSITY_UNITS" type="table" extracted="True">
       <Columns>
         <Column name="GUID" key="true" />
         <Column name="ID" />
@@ -575,7 +573,7 @@
         <Column name="CODE" />
       </Columns>
     </Item>
-    <Item name="dbo.LIQUID_TYPES" type="table">
+    <Item name="dbo.LIQUID_TYPES" type="table" extracted="True">
       <Columns>
         <Column name="GUID" key="true" />
         <Column name="ID" />
@@ -586,7 +584,7 @@
         <Column name="COLOR" />
       </Columns>
     </Item>
-    <Item name="dbo.LIQUID_TYPES_RMLS" type="table">
+    <Item name="dbo.LIQUID_TYPES_RMLS" type="table" extracted="True">
       <Columns>
         <Column name="GUID" key="true" />
         <Column name="ID" />
@@ -608,7 +606,7 @@
         <Column name="FORCE_UPDATE" />
       </Columns>
     </Item>
-    <Item name="dbo.MACHINE_VERSIONS" type="table">
+    <Item name="dbo.MACHINE_VERSIONS" type="table" extracted="True">
       <Columns>
         <Column name="GUID" key="true" />
         <Column name="ID" />
@@ -672,7 +670,7 @@
         <Column name="DESCRIPTION" />
       </Columns>
     </Item>
-    <Item name="dbo.MEDIA_COLORS" type="table">
+    <Item name="dbo.MEDIA_COLORS" type="table" extracted="True">
       <Columns>
         <Column name="GUID" key="true" />
         <Column name="ID" />
@@ -683,7 +681,7 @@
         <Column name="B" />
       </Columns>
     </Item>
-    <Item name="dbo.MEDIA_CONDITIONS" type="table">
+    <Item name="dbo.MEDIA_CONDITIONS" type="table" extracted="True">
       <Columns>
         <Column name="GUID" key="true" />
         <Column name="ID" />
@@ -692,7 +690,7 @@
         <Column name="CODE" />
       </Columns>
     </Item>
-    <Item name="dbo.MEDIA_MATERIALS" type="table">
+    <Item name="dbo.MEDIA_MATERIALS" type="table" extracted="True">
       <Columns>
         <Column name="GUID" key="true" />
         <Column name="ID" />
@@ -701,7 +699,7 @@
         <Column name="CODE" />
       </Columns>
     </Item>
-    <Item name="dbo.MEDIA_PURPOSES" type="table">
+    <Item name="dbo.MEDIA_PURPOSES" type="table" extracted="True">
       <Columns>
         <Column name="GUID" key="true" />
         <Column name="ID" />
@@ -710,7 +708,7 @@
         <Column name="CODE" />
       </Columns>
     </Item>
-    <Item name="dbo.MID_TANK_TYPES" type="table">
+    <Item name="dbo.MID_TANK_TYPES" type="table" extracted="True">
       <Columns>
         <Column name="GUID" key="true" />
         <Column name="ID" />
@@ -730,7 +728,7 @@
         <Column name="ADDRESS_GUID" />
       </Columns>
     </Item>
-    <Item name="dbo.PERMISSIONS" type="table">
+    <Item name="dbo.PERMISSIONS" type="table" extracted="True">
       <Columns>
         <Column name="GUID" key="true" />
         <Column name="ID" />
@@ -740,7 +738,7 @@
         <Column name="DESCRIPTION" />
       </Columns>
     </Item>
-    <Item name="dbo.PROCESS_PARAMETERS_TABLES" type="table">
+    <Item name="dbo.PROCESS_PARAMETERS_TABLES" type="table" extracted="True">
       <Columns>
         <Column name="GUID" key="true" />
         <Column name="ID" />
@@ -768,7 +766,7 @@
         <Column name="TABLE_INDEX" />
       </Columns>
     </Item>
-    <Item name="dbo.PROCESS_PARAMETERS_TABLES_GROUPS" type="table">
+    <Item name="dbo.PROCESS_PARAMETERS_TABLES_GROUPS" type="table" extracted="True">
       <Columns>
         <Column name="GUID" key="true" />
         <Column name="ID" />
@@ -779,7 +777,7 @@
         <Column name="SAVE_DATE" />
       </Columns>
     </Item>
-    <Item name="dbo.RMLS" type="table">
+    <Item name="dbo.RMLS" type="table" extracted="True">
       <Columns>
         <Column name="GUID" key="true" />
         <Column name="ID" />
@@ -806,7 +804,7 @@
         <Column name="ESTIMATED_THREAD_DIAMETER" />
       </Columns>
     </Item>
-    <Item name="dbo.ROLES" type="table">
+    <Item name="dbo.ROLES" type="table" extracted="True">
       <Columns>
         <Column name="GUID" key="true" />
         <Column name="ID" />
@@ -816,7 +814,7 @@
         <Column name="DESCRIPTION" />
       </Columns>
     </Item>
-    <Item name="dbo.ROLES_PERMISSIONS" type="table">
+    <Item name="dbo.ROLES_PERMISSIONS" type="table" extracted="True">
       <Columns>
         <Column name="GUID" key="true" />
         <Column name="ID" />
@@ -836,7 +834,7 @@
         <Column name="SEGMENT_INDEX" />
       </Columns>
     </Item>
-    <Item name="dbo.SPOOL_TYPES" type="table">
+    <Item name="dbo.SPOOL_TYPES" type="table" extracted="True">
       <Columns>
         <Column name="GUID" key="true" />
         <Column name="ID" />
@@ -853,14 +851,14 @@
         <Column name="ROTATIONS_PER_PASSAGE" />
       </Columns>
     </Item>
-    <Item name="dbo.SYNC_CONFIGURATIONS" type="table">
+    <Item name="dbo.SYNC_CONFIGURATIONS" type="table" extracted="True">
       <Columns>
         <Column name="ID" key="true" />
         <Column name="TABLE_NAME" />
         <Column name="SYNC_TYPE" />
       </Columns>
     </Item>
-    <Item name="dbo.TECH_CONTROLLERS" type="table">
+    <Item name="dbo.TECH_CONTROLLERS" type="table" extracted="True">
       <Columns>
         <Column name="GUID" key="true" />
         <Column name="ID" />
@@ -873,7 +871,7 @@
         <Column name="UNITS" />
       </Columns>
     </Item>
-    <Item name="dbo.TECH_DISPENSERS" type="table">
+    <Item name="dbo.TECH_DISPENSERS" type="table" extracted="True">
       <Columns>
         <Column name="GUID" key="true" />
         <Column name="ID" />
@@ -883,7 +881,7 @@
         <Column name="DESCRIPTION" />
       </Columns>
     </Item>
-    <Item name="dbo.TECH_IOS" type="table">
+    <Item name="dbo.TECH_IOS" type="table" extracted="True">
       <Columns>
         <Column name="GUID" key="true" />
         <Column name="ID" />
@@ -900,7 +898,7 @@
         <Column name="MAX" />
       </Columns>
     </Item>
-    <Item name="dbo.TECH_MONITORS" type="table">
+    <Item name="dbo.TECH_MONITORS" type="table" extracted="True">
       <Columns>
         <Column name="GUID" key="true" />
         <Column name="ID" />
@@ -916,7 +914,7 @@
         <Column name="CHANNEL_COUNT" />
       </Columns>
     </Item>
-    <Item name="dbo.TECH_VALVES" type="table">
+    <Item name="dbo.TECH_VALVES" type="table" extracted="True">
       <Columns>
         <Column name="GUID" key="true" />
         <Column name="ID" />
@@ -950,7 +948,7 @@
         <Column name="ROLE_GUID" />
       </Columns>
     </Item>
-    <Item name="dbo.WINDING_METHODS" type="table">
+    <Item name="dbo.WINDING_METHODS" type="table" extracted="True">
       <Columns>
         <Column name="GUID" key="true" />
         <Column name="ID" />
@@ -960,497 +958,6 @@
         <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" />
diff --git a/Software/DB/Tango.mdf b/Software/DB/Tango.mdf
index e73085417..f580b0942 100644
--- a/Software/DB/Tango.mdf
+++ b/Software/DB/Tango.mdf
diff --git a/Software/DB/Tango_log.ldf b/Software/DB/Tango_log.ldf
index 4635dbde3..507554baf 100644
--- a/Software/DB/Tango_log.ldf
+++ b/Software/DB/Tango_log.ldf