Added MidTank pressures + Hardware Blower HeatingVoltage. + Embedded Version Upload protos.

4 files changed, 289 insertions, 140 deletions

diff --git a/Software/DB/SQLExaminer Projects/Override Tables.sdeproj b/Software/DB/SQLExaminer Projects/Override Tables.sdeproj
index c97b84dda..4eea23b44 100644
--- a/Software/DB/SQLExaminer Projects/Override Tables.sdeproj
+++ b/Software/DB/SQLExaminer Projects/Override Tables.sdeproj
@@ -70,15 +70,6 @@
         <Column name="NAME" />
       </Columns>
     </Item>
-    <Item name="dbo.APPLICATION_VERSIONS" type="table" extracted="True">
-      <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" />
@@ -109,6 +100,14 @@
         <Column name="CORRECTED" />
         <Column name="COLOR_CATALOG_GUID" />
         <Column name="COLOR_CATALOG_CODE" />
+        <Column name="V0_DIV" />
+        <Column name="V1_DIV" />
+        <Column name="V2_DIV" />
+        <Column name="V3_DIV" />
+        <Column name="V4_DIV" />
+        <Column name="V5_DIV" />
+        <Column name="V6_DIV" />
+        <Column name="V7_DIV" />
       </Columns>
     </Item>
     <Item name="dbo.CARTRIDGE_TYPES" type="table" extracted="True">
@@ -193,12 +192,10 @@
         <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>
@@ -245,15 +242,6 @@
         <Column name="NAME" />
       </Columns>
     </Item>
-    <Item name="dbo.EMBEDDED_SOFTWARE_VERSIONS" type="table" extracted="True">
-      <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" extracted="True">
       <Columns>
         <Column name="GUID" key="true" />
@@ -316,6 +304,50 @@
         <Column name="CODE" />
       </Columns>
     </Item>
+    <Item name="dbo.HARDWARE_BLOWER_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_BLOWERS" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="HARDWARE_BLOWER_TYPE_GUID" />
+        <Column name="HARDWARE_VERSION_GUID" />
+        <Column name="ENABLED" />
+        <Column name="VOLTAGE" />
+        <Column name="ACTIVE" />
+      </Columns>
+    </Item>
+    <Item name="dbo.HARDWARE_BREAK_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_BREAK_SENSORS" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="HARDWARE_BREAK_SENSOR_TYPE_GUID" />
+        <Column name="HARDWARE_VERSION_GUID" />
+        <Column name="ENABLED" />
+        <Column name="DE_BOUNCE_TIME_MILLI" />
+        <Column name="ACTIVE" />
+      </Columns>
+    </Item>
     <Item name="dbo.HARDWARE_DANCER_TYPES" type="table" extracted="True">
       <Columns>
         <Column name="GUID" key="true" />
@@ -343,6 +375,7 @@
         <Column name="ARM_LENGTH" />
         <Column name="ASSEMBLY_DIRECTION_RIGHT" />
         <Column name="ACCELERATE_ON_TENSION_RAISE" />
+        <Column name="ACTIVE" />
       </Columns>
     </Item>
     <Item name="dbo.HARDWARE_MOTOR_TYPES" type="table" extracted="True">
@@ -387,6 +420,7 @@
         <Column name="FN_SLP_ACC" />
         <Column name="FN_SLP_DEC" />
         <Column name="FS_SPD" />
+        <Column name="ACTIVE" />
       </Columns>
     </Item>
     <Item name="dbo.HARDWARE_PID_CONTROL_TYPES" type="table" extracted="True">
@@ -423,6 +457,9 @@
         <Column name="OUTPUT_PROPORTIONAL_CYCLE_TIME" />
         <Column name="AC_HEATERS__HALF_CYCLE_TIME" />
         <Column name="PROPORTIONAL_GAIN" />
+        <Column name="PID_ACTIVE" />
+        <Column name="EPSILON" />
+        <Column name="ACTIVE" />
       </Columns>
     </Item>
     <Item name="dbo.HARDWARE_SPEED_SENSOR_TYPES" type="table" extracted="True">
@@ -444,6 +481,7 @@
         <Column name="HARDWARE_VERSION_GUID" />
         <Column name="RESOLUTION_BITS" />
         <Column name="PERIMETER" />
+        <Column name="ACTIVE" />
       </Columns>
     </Item>
     <Item name="dbo.HARDWARE_VERSIONS" type="table" extracted="True">
@@ -473,6 +511,7 @@
         <Column name="HARDWARE_WINDER_TYPE_GUID" />
         <Column name="HARDWARE_VERSION_GUID" />
         <Column name="MILLIMETER_PER_ROTATION" />
+        <Column name="ACTIVE" />
       </Columns>
     </Item>
     <Item name="dbo.HTML_PAGES" type="table" extracted="True">
@@ -521,7 +560,9 @@
         <Column name="JOB_GUID" />
         <Column name="START_DATE" />
         <Column name="END_DATE" />
-        <Column name="SUCCESSFUL" />
+        <Column name="STATUS" />
+        <Column name="END_POSITION" />
+        <Column name="FAILED_MESSAGE" />
       </Columns>
     </Item>
     <Item name="dbo.JOBS" type="table">
@@ -591,6 +632,7 @@
         <Column name="LIQUID_TYPE_GUID" />
         <Column name="RML_GUID" />
         <Column name="MAX_NL_PER_CM" />
+        <Column name="DEFAULT_CAT_DATA" />
       </Columns>
     </Item>
     <Item name="dbo.MACHINE_STUDIO_VERSIONS" type="table">
@@ -603,6 +645,7 @@
         <Column name="COMMENTS" />
         <Column name="USER_GUID" />
         <Column name="FORCE_UPDATE" />
+        <Column name="STABLE" />
       </Columns>
     </Item>
     <Item name="dbo.MACHINE_VERSIONS" type="table" extracted="True">
@@ -846,6 +889,18 @@
         <Column name="SYNC_TYPE" />
       </Columns>
     </Item>
+    <Item name="dbo.TANGO_VERSIONS" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="VERSION" />
+        <Column name="BLOB_NAME" />
+        <Column name="COMMENTS" />
+        <Column name="USER_GUID" />
+        <Column name="MACHINE_VERSION_GUID" />
+      </Columns>
+    </Item>
     <Item name="dbo.TECH_CONTROLLERS" type="table" extracted="True">
       <Columns>
         <Column name="GUID" key="true" />
@@ -869,12 +924,21 @@
         <Column name="DESCRIPTION" />
       </Columns>
     </Item>
+    <Item name="dbo.TECH_HEATERS" 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" extracted="True">
       <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" />
@@ -884,6 +948,8 @@
         <Column name="AVERAGING" />
         <Column name="MIN" />
         <Column name="MAX" />
+        <Column name="CODE" />
+        <Column name="NAME" />
       </Columns>
     </Item>
     <Item name="dbo.TECH_MONITORS" type="table" extracted="True">
@@ -910,6 +976,9 @@
         <Column name="CODE" />
         <Column name="NAME" />
         <Column name="DESCRIPTION" />
+        <Column name="TYPE" />
+        <Column name="STATE1" />
+        <Column name="STATE2" />
       </Columns>
     </Item>
     <Item name="dbo.USERS" type="table">
@@ -953,12 +1022,10 @@
         <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>
@@ -978,12 +1045,10 @@ INNER JOIN CONFIGURATIONS ON CONFIGURATIONS.GUID = MACHINE_VERSIONS.DEFAULT_CONF
                 <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>
@@ -1005,12 +1070,10 @@ INNER JOIN CONFIGURATIONS ON CONFIGURATIONS.GUID = MACHINE_VERSIONS.DEFAULT_CONF
                 <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>
diff --git a/Software/DB/SQLExaminer Projects/Provision Machine.sdeproj b/Software/DB/SQLExaminer Projects/Provision Machine.sdeproj
index ec457f2e3..60f93c308 100644
--- a/Software/DB/SQLExaminer Projects/Provision Machine.sdeproj
+++ b/Software/DB/SQLExaminer Projects/Provision Machine.sdeproj
@@ -70,15 +70,6 @@
         <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" />
@@ -109,6 +100,14 @@
         <Column name="CORRECTED" />
         <Column name="COLOR_CATALOG_GUID" />
         <Column name="COLOR_CATALOG_CODE" />
+        <Column name="V0_DIV" />
+        <Column name="V1_DIV" />
+        <Column name="V2_DIV" />
+        <Column name="V3_DIV" />
+        <Column name="V4_DIV" />
+        <Column name="V5_DIV" />
+        <Column name="V6_DIV" />
+        <Column name="V7_DIV" />
       </Columns>
     </Item>
     <Item name="dbo.CARTRIDGE_TYPES" type="table">
@@ -193,12 +192,10 @@
         <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>
@@ -245,15 +242,6 @@
         <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" />
@@ -316,6 +304,50 @@
         <Column name="CODE" />
       </Columns>
     </Item>
+    <Item name="dbo.HARDWARE_BLOWER_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_BLOWERS" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="HARDWARE_BLOWER_TYPE_GUID" />
+        <Column name="HARDWARE_VERSION_GUID" />
+        <Column name="ENABLED" />
+        <Column name="VOLTAGE" />
+        <Column name="ACTIVE" />
+      </Columns>
+    </Item>
+    <Item name="dbo.HARDWARE_BREAK_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_BREAK_SENSORS" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="HARDWARE_BREAK_SENSOR_TYPE_GUID" />
+        <Column name="HARDWARE_VERSION_GUID" />
+        <Column name="ENABLED" />
+        <Column name="DE_BOUNCE_TIME_MILLI" />
+        <Column name="ACTIVE" />
+      </Columns>
+    </Item>
     <Item name="dbo.HARDWARE_DANCER_TYPES" type="table">
       <Columns>
         <Column name="GUID" key="true" />
@@ -343,6 +375,7 @@
         <Column name="ARM_LENGTH" />
         <Column name="ASSEMBLY_DIRECTION_RIGHT" />
         <Column name="ACCELERATE_ON_TENSION_RAISE" />
+        <Column name="ACTIVE" />
       </Columns>
     </Item>
     <Item name="dbo.HARDWARE_MOTOR_TYPES" type="table">
@@ -387,6 +420,7 @@
         <Column name="FN_SLP_ACC" />
         <Column name="FN_SLP_DEC" />
         <Column name="FS_SPD" />
+        <Column name="ACTIVE" />
       </Columns>
     </Item>
     <Item name="dbo.HARDWARE_PID_CONTROL_TYPES" type="table">
@@ -423,6 +457,9 @@
         <Column name="OUTPUT_PROPORTIONAL_CYCLE_TIME" />
         <Column name="AC_HEATERS__HALF_CYCLE_TIME" />
         <Column name="PROPORTIONAL_GAIN" />
+        <Column name="PID_ACTIVE" />
+        <Column name="EPSILON" />
+        <Column name="ACTIVE" />
       </Columns>
     </Item>
     <Item name="dbo.HARDWARE_SPEED_SENSOR_TYPES" type="table">
@@ -444,6 +481,7 @@
         <Column name="HARDWARE_VERSION_GUID" />
         <Column name="RESOLUTION_BITS" />
         <Column name="PERIMETER" />
+        <Column name="ACTIVE" />
       </Columns>
     </Item>
     <Item name="dbo.HARDWARE_VERSIONS" type="table">
@@ -473,6 +511,7 @@
         <Column name="HARDWARE_WINDER_TYPE_GUID" />
         <Column name="HARDWARE_VERSION_GUID" />
         <Column name="MILLIMETER_PER_ROTATION" />
+        <Column name="ACTIVE" />
       </Columns>
     </Item>
     <Item name="dbo.HTML_PAGES" type="table">
@@ -521,7 +560,9 @@
         <Column name="JOB_GUID" />
         <Column name="START_DATE" />
         <Column name="END_DATE" />
-        <Column name="SUCCESSFUL" />
+        <Column name="STATUS" />
+        <Column name="END_POSITION" />
+        <Column name="FAILED_MESSAGE" />
       </Columns>
     </Item>
     <Item name="dbo.JOBS" type="table">
@@ -591,6 +632,7 @@
         <Column name="LIQUID_TYPE_GUID" />
         <Column name="RML_GUID" />
         <Column name="MAX_NL_PER_CM" />
+        <Column name="DEFAULT_CAT_DATA" />
       </Columns>
     </Item>
     <Item name="dbo.MACHINE_STUDIO_VERSIONS" type="table">
@@ -603,6 +645,7 @@
         <Column name="COMMENTS" />
         <Column name="USER_GUID" />
         <Column name="FORCE_UPDATE" />
+        <Column name="STABLE" />
       </Columns>
     </Item>
     <Item name="dbo.MACHINE_VERSIONS" type="table">
@@ -846,6 +889,18 @@
         <Column name="SYNC_TYPE" />
       </Columns>
     </Item>
+    <Item name="dbo.TANGO_VERSIONS" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="VERSION" />
+        <Column name="BLOB_NAME" />
+        <Column name="COMMENTS" />
+        <Column name="USER_GUID" />
+        <Column name="MACHINE_VERSION_GUID" />
+      </Columns>
+    </Item>
     <Item name="dbo.TECH_CONTROLLERS" type="table">
       <Columns>
         <Column name="GUID" key="true" />
@@ -869,12 +924,21 @@
         <Column name="DESCRIPTION" />
       </Columns>
     </Item>
+    <Item name="dbo.TECH_HEATERS" 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" />
@@ -884,6 +948,8 @@
         <Column name="AVERAGING" />
         <Column name="MIN" />
         <Column name="MAX" />
+        <Column name="CODE" />
+        <Column name="NAME" />
       </Columns>
     </Item>
     <Item name="dbo.TECH_MONITORS" type="table">
@@ -910,6 +976,9 @@
         <Column name="CODE" />
         <Column name="NAME" />
         <Column name="DESCRIPTION" />
+        <Column name="TYPE" />
+        <Column name="STATE1" />
+        <Column name="STATE2" />
       </Columns>
     </Item>
     <Item name="dbo.USERS" type="table">
@@ -1044,15 +1113,15 @@ FROM CATS
 
 INNER JOIN MACHINES ON MACHINES.GUID = CATS.MACHINE_GUID
 
-WHERE MACHINES.SERIAL_NUMBER = '1111']]></Text>
+WHERE MACHINES.SERIAL_NUMBER = '@']]></Text>
           <UpdateTables>
             <Table schema="dbo" name="CATS" allowDelete="True" allowInsert="True" allowUpdate="True">
               <KeyColumns>
                 <KeyColumn name="GUID" />
               </KeyColumns>
               <UpdateColumns>
-                <UpdateColumn name="ID" />
                 <UpdateColumn name="GUID" />
+                <UpdateColumn name="ID" />
                 <UpdateColumn name="LAST_UPDATED" />
                 <UpdateColumn name="NAME" />
                 <UpdateColumn name="MACHINE_GUID" />
@@ -1070,15 +1139,15 @@ FROM CATS
 
 INNER JOIN MACHINES ON MACHINES.GUID = CATS.MACHINE_GUID
 
-WHERE MACHINES.SERIAL_NUMBER = '1111']]></Text>
+WHERE MACHINES.SERIAL_NUMBER = '@']]></Text>
           <UpdateTables>
             <Table schema="dbo" name="CATS" allowDelete="True" allowInsert="True" allowUpdate="True">
               <KeyColumns>
                 <KeyColumn name="GUID" />
               </KeyColumns>
               <UpdateColumns>
-                <UpdateColumn name="ID" />
                 <UpdateColumn name="GUID" />
+                <UpdateColumn name="ID" />
                 <UpdateColumn name="LAST_UPDATED" />
                 <UpdateColumn name="NAME" />
                 <UpdateColumn name="MACHINE_GUID" />
@@ -1098,12 +1167,10 @@ WHERE MACHINES.SERIAL_NUMBER = '1111']]></Text>
         <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>
@@ -1123,12 +1190,10 @@ WHERE MACHINES.SERIAL_NUMBER = '@']]></Text>
                 <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>
@@ -1150,12 +1215,10 @@ WHERE MACHINES.SERIAL_NUMBER = '@']]></Text>
                 <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>
diff --git a/Software/DB/SQLExaminer Projects/Update Twine DB.sdeproj b/Software/DB/SQLExaminer Projects/Update Twine DB.sdeproj
index 4ca56f369..045e8e1c1 100644
--- a/Software/DB/SQLExaminer Projects/Update Twine DB.sdeproj
+++ b/Software/DB/SQLExaminer Projects/Update Twine DB.sdeproj
@@ -5,17 +5,14 @@
       <StorageType>LiveDb</StorageType>
       <ServerName>localhost\sqlexpress</ServerName>
       <Database>Tango</Database>
-      <WinAuth>False</WinAuth>
+      <WinAuth>True</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>
+      <ServerName>localhost\sqlexpress</ServerName>
+      <Database>Test</Database>
       <WinAuth>True</WinAuth>
       <AzurePwd>False</AzurePwd>
     </Source>
@@ -73,15 +70,6 @@
         <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" extracted="True">
       <Columns>
         <Column name="GUID" key="true" />
@@ -112,6 +100,14 @@
         <Column name="CORRECTED" />
         <Column name="COLOR_CATALOG_GUID" />
         <Column name="COLOR_CATALOG_CODE" />
+        <Column name="V0_DIV" />
+        <Column name="V1_DIV" />
+        <Column name="V2_DIV" />
+        <Column name="V3_DIV" />
+        <Column name="V4_DIV" />
+        <Column name="V5_DIV" />
+        <Column name="V6_DIV" />
+        <Column name="V7_DIV" />
       </Columns>
     </Item>
     <Item name="dbo.CARTRIDGE_TYPES" type="table">
@@ -196,12 +192,10 @@
         <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>
@@ -248,15 +242,6 @@
         <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" />
@@ -338,6 +323,7 @@
         <Column name="HARDWARE_VERSION_GUID" />
         <Column name="ENABLED" />
         <Column name="VOLTAGE" />
+        <Column name="ACTIVE" />
       </Columns>
     </Item>
     <Item name="dbo.HARDWARE_BREAK_SENSOR_TYPES" type="table">
@@ -359,6 +345,7 @@
         <Column name="HARDWARE_VERSION_GUID" />
         <Column name="ENABLED" />
         <Column name="DE_BOUNCE_TIME_MILLI" />
+        <Column name="ACTIVE" />
       </Columns>
     </Item>
     <Item name="dbo.HARDWARE_DANCER_TYPES" type="table">
@@ -388,6 +375,7 @@
         <Column name="ARM_LENGTH" />
         <Column name="ASSEMBLY_DIRECTION_RIGHT" />
         <Column name="ACCELERATE_ON_TENSION_RAISE" />
+        <Column name="ACTIVE" />
       </Columns>
     </Item>
     <Item name="dbo.HARDWARE_MOTOR_TYPES" type="table">
@@ -432,6 +420,7 @@
         <Column name="FN_SLP_ACC" />
         <Column name="FN_SLP_DEC" />
         <Column name="FS_SPD" />
+        <Column name="ACTIVE" />
       </Columns>
     </Item>
     <Item name="dbo.HARDWARE_PID_CONTROL_TYPES" type="table">
@@ -468,6 +457,9 @@
         <Column name="OUTPUT_PROPORTIONAL_CYCLE_TIME" />
         <Column name="AC_HEATERS__HALF_CYCLE_TIME" />
         <Column name="PROPORTIONAL_GAIN" />
+        <Column name="PID_ACTIVE" />
+        <Column name="EPSILON" />
+        <Column name="ACTIVE" />
       </Columns>
     </Item>
     <Item name="dbo.HARDWARE_SPEED_SENSOR_TYPES" type="table">
@@ -489,6 +481,7 @@
         <Column name="HARDWARE_VERSION_GUID" />
         <Column name="RESOLUTION_BITS" />
         <Column name="PERIMETER" />
+        <Column name="ACTIVE" />
       </Columns>
     </Item>
     <Item name="dbo.HARDWARE_VERSIONS" type="table">
@@ -518,6 +511,7 @@
         <Column name="HARDWARE_WINDER_TYPE_GUID" />
         <Column name="HARDWARE_VERSION_GUID" />
         <Column name="MILLIMETER_PER_ROTATION" />
+        <Column name="ACTIVE" />
       </Columns>
     </Item>
     <Item name="dbo.HTML_PAGES" type="table">
@@ -566,7 +560,9 @@
         <Column name="JOB_GUID" />
         <Column name="START_DATE" />
         <Column name="END_DATE" />
-        <Column name="SUCCESSFUL" />
+        <Column name="STATUS" />
+        <Column name="END_POSITION" />
+        <Column name="FAILED_MESSAGE" />
       </Columns>
     </Item>
     <Item name="dbo.JOBS" type="table" extracted="True">
@@ -636,6 +632,7 @@
         <Column name="LIQUID_TYPE_GUID" />
         <Column name="RML_GUID" />
         <Column name="MAX_NL_PER_CM" />
+        <Column name="DEFAULT_CAT_DATA" />
       </Columns>
     </Item>
     <Item name="dbo.MACHINE_STUDIO_VERSIONS" type="table">
@@ -648,6 +645,7 @@
         <Column name="COMMENTS" />
         <Column name="USER_GUID" />
         <Column name="FORCE_UPDATE" />
+        <Column name="STABLE" />
       </Columns>
     </Item>
     <Item name="dbo.MACHINE_VERSIONS" type="table">
@@ -703,17 +701,6 @@
         <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" />
@@ -902,6 +889,18 @@
         <Column name="SYNC_TYPE" />
       </Columns>
     </Item>
+    <Item name="dbo.TANGO_VERSIONS" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="VERSION" />
+        <Column name="BLOB_NAME" />
+        <Column name="COMMENTS" />
+        <Column name="USER_GUID" />
+        <Column name="MACHINE_VERSION_GUID" />
+      </Columns>
+    </Item>
     <Item name="dbo.TECH_CONTROLLERS" type="table">
       <Columns>
         <Column name="GUID" key="true" />
@@ -925,12 +924,21 @@
         <Column name="DESCRIPTION" />
       </Columns>
     </Item>
+    <Item name="dbo.TECH_HEATERS" 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" />
@@ -940,6 +948,8 @@
         <Column name="AVERAGING" />
         <Column name="MIN" />
         <Column name="MAX" />
+        <Column name="CODE" />
+        <Column name="NAME" />
       </Columns>
     </Item>
     <Item name="dbo.TECH_MONITORS" type="table">
@@ -966,6 +976,9 @@
         <Column name="CODE" />
         <Column name="NAME" />
         <Column name="DESCRIPTION" />
+        <Column name="TYPE" />
+        <Column name="STATE1" />
+        <Column name="STATE2" />
       </Columns>
     </Item>
     <Item name="dbo.USERS" type="table" extracted="True">
diff --git a/Software/DB/SQLExaminer Projects/UpdateMachine.sdeproj b/Software/DB/SQLExaminer Projects/UpdateMachine.sdeproj
index 28c99d852..c2dd5cefa 100644
--- a/Software/DB/SQLExaminer Projects/UpdateMachine.sdeproj
+++ b/Software/DB/SQLExaminer Projects/UpdateMachine.sdeproj
@@ -11,8 +11,8 @@
     <Source id="2">
       <EngineType>MsSqlServer</EngineType>
       <StorageType>LiveDb</StorageType>
-      <ServerName>twine.local\sqltwine</ServerName>
-      <Database>Tango</Database>
+      <ServerName>localhost\sqlexpress</ServerName>
+      <Database>Test</Database>
       <WinAuth>True</WinAuth>
       <AzurePwd>False</AzurePwd>
     </Source>
@@ -70,15 +70,6 @@
         <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" />
@@ -109,6 +100,14 @@
         <Column name="CORRECTED" />
         <Column name="COLOR_CATALOG_GUID" />
         <Column name="COLOR_CATALOG_CODE" />
+        <Column name="V0_DIV" />
+        <Column name="V1_DIV" />
+        <Column name="V2_DIV" />
+        <Column name="V3_DIV" />
+        <Column name="V4_DIV" />
+        <Column name="V5_DIV" />
+        <Column name="V6_DIV" />
+        <Column name="V7_DIV" />
       </Columns>
     </Item>
     <Item name="dbo.CARTRIDGE_TYPES" type="table">
@@ -193,12 +192,10 @@
         <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>
@@ -245,15 +242,6 @@
         <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" />
@@ -335,6 +323,7 @@
         <Column name="HARDWARE_VERSION_GUID" />
         <Column name="ENABLED" />
         <Column name="VOLTAGE" />
+        <Column name="ACTIVE" />
       </Columns>
     </Item>
     <Item name="dbo.HARDWARE_BREAK_SENSOR_TYPES" type="table">
@@ -356,6 +345,7 @@
         <Column name="HARDWARE_VERSION_GUID" />
         <Column name="ENABLED" />
         <Column name="DE_BOUNCE_TIME_MILLI" />
+        <Column name="ACTIVE" />
       </Columns>
     </Item>
     <Item name="dbo.HARDWARE_DANCER_TYPES" type="table">
@@ -385,6 +375,7 @@
         <Column name="ARM_LENGTH" />
         <Column name="ASSEMBLY_DIRECTION_RIGHT" />
         <Column name="ACCELERATE_ON_TENSION_RAISE" />
+        <Column name="ACTIVE" />
       </Columns>
     </Item>
     <Item name="dbo.HARDWARE_MOTOR_TYPES" type="table">
@@ -429,6 +420,7 @@
         <Column name="FN_SLP_ACC" />
         <Column name="FN_SLP_DEC" />
         <Column name="FS_SPD" />
+        <Column name="ACTIVE" />
       </Columns>
     </Item>
     <Item name="dbo.HARDWARE_PID_CONTROL_TYPES" type="table">
@@ -465,6 +457,9 @@
         <Column name="OUTPUT_PROPORTIONAL_CYCLE_TIME" />
         <Column name="AC_HEATERS__HALF_CYCLE_TIME" />
         <Column name="PROPORTIONAL_GAIN" />
+        <Column name="PID_ACTIVE" />
+        <Column name="EPSILON" />
+        <Column name="ACTIVE" />
       </Columns>
     </Item>
     <Item name="dbo.HARDWARE_SPEED_SENSOR_TYPES" type="table">
@@ -486,6 +481,7 @@
         <Column name="HARDWARE_VERSION_GUID" />
         <Column name="RESOLUTION_BITS" />
         <Column name="PERIMETER" />
+        <Column name="ACTIVE" />
       </Columns>
     </Item>
     <Item name="dbo.HARDWARE_VERSIONS" type="table">
@@ -515,6 +511,7 @@
         <Column name="HARDWARE_WINDER_TYPE_GUID" />
         <Column name="HARDWARE_VERSION_GUID" />
         <Column name="MILLIMETER_PER_ROTATION" />
+        <Column name="ACTIVE" />
       </Columns>
     </Item>
     <Item name="dbo.HTML_PAGES" type="table">
@@ -563,7 +560,9 @@
         <Column name="JOB_GUID" />
         <Column name="START_DATE" />
         <Column name="END_DATE" />
-        <Column name="SUCCESSFUL" />
+        <Column name="STATUS" />
+        <Column name="END_POSITION" />
+        <Column name="FAILED_MESSAGE" />
       </Columns>
     </Item>
     <Item name="dbo.JOBS" type="table">
@@ -633,6 +632,7 @@
         <Column name="LIQUID_TYPE_GUID" />
         <Column name="RML_GUID" />
         <Column name="MAX_NL_PER_CM" />
+        <Column name="DEFAULT_CAT_DATA" />
       </Columns>
     </Item>
     <Item name="dbo.MACHINE_STUDIO_VERSIONS" type="table">
@@ -645,6 +645,7 @@
         <Column name="COMMENTS" />
         <Column name="USER_GUID" />
         <Column name="FORCE_UPDATE" />
+        <Column name="STABLE" />
       </Columns>
     </Item>
     <Item name="dbo.MACHINE_VERSIONS" type="table">
@@ -700,17 +701,6 @@
         <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" />
@@ -899,6 +889,18 @@
         <Column name="SYNC_TYPE" />
       </Columns>
     </Item>
+    <Item name="dbo.TANGO_VERSIONS" type="table">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="VERSION" />
+        <Column name="BLOB_NAME" />
+        <Column name="COMMENTS" />
+        <Column name="USER_GUID" />
+        <Column name="MACHINE_VERSION_GUID" />
+      </Columns>
+    </Item>
     <Item name="dbo.TECH_CONTROLLERS" type="table">
       <Columns>
         <Column name="GUID" key="true" />
@@ -922,12 +924,21 @@
         <Column name="DESCRIPTION" />
       </Columns>
     </Item>
+    <Item name="dbo.TECH_HEATERS" 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" />
@@ -937,6 +948,8 @@
         <Column name="AVERAGING" />
         <Column name="MIN" />
         <Column name="MAX" />
+        <Column name="CODE" />
+        <Column name="NAME" />
       </Columns>
     </Item>
     <Item name="dbo.TECH_MONITORS" type="table">
@@ -963,6 +976,9 @@
         <Column name="CODE" />
         <Column name="NAME" />
         <Column name="DESCRIPTION" />
+        <Column name="TYPE" />
+        <Column name="STATE1" />
+        <Column name="STATE2" />
       </Columns>
     </Item>
     <Item name="dbo.USERS" type="table">
@@ -1082,12 +1098,10 @@ WHERE MACHINES.SERIAL_NUMBER = '@']]></Text>
         <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>
@@ -1108,12 +1122,10 @@ WHERE MACHINES.SERIAL_NUMBER = '@']]></Text>
                 <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>
@@ -1136,12 +1148,10 @@ WHERE MACHINES.SERIAL_NUMBER = '@']]></Text>
                 <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>