Updated SQLExaminer scripts.

3 files changed, 69 insertions, 211 deletions

diff --git a/Software/DB/SQLExaminer Projects/Override Tables.sdeproj b/Software/DB/SQLExaminer Projects/Override Tables.sdeproj
index c11504db4..26173fa4f 100644
--- a/Software/DB/SQLExaminer Projects/Override Tables.sdeproj
+++ b/Software/DB/SQLExaminer Projects/Override Tables.sdeproj
@@ -18,16 +18,6 @@
     </Source>
   </Sources>
   <Items>
-    <Item name="dbo.ACTION_TYPES" type="table" extracted="True">
-      <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" />
@@ -99,7 +89,6 @@
         <Column name="V7" />
         <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" />
@@ -166,6 +155,7 @@
         <Column name="A" />
         <Column name="B" />
         <Column name="PROCESS_PARAMETERS_TABLE_INDEX" />
+        <Column name="RML_GUID" />
       </Columns>
     </Item>
     <Item name="dbo.COLOR_SPACES" type="table" extracted="True">
@@ -233,7 +223,11 @@
         <Column name="SERIAL_NUMBER" />
         <Column name="DISPENSER_TYPE_GUID" />
         <Column name="NL_PER_PULSE" />
-        <Column name="DATA" />
+        <Column name="PART_NUMBER" />
+        <Column name="PCB_SERIAL" />
+        <Column name="PCB_VERSION" />
+        <Column name="PRODUCTION_DATE" />
+        <Column name="CALIBRATION_DATA" />
       </Columns>
     </Item>
     <Item name="dbo.EMBEDDED_FIRMWARE_VERSIONS" type="table" extracted="True">
@@ -253,40 +247,14 @@
         <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" extracted="True">
-      <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" extracted="True">
-      <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" extracted="True">
-      <Columns>
-        <Column name="GUID" key="true" />
-        <Column name="ID" />
-        <Column name="LAST_UPDATED" />
-        <Column name="CODE" />
-        <Column name="NAME" />
-        <Column name="DESCRIPTION" />
+        <Column name="TITLE" />
+        <Column name="TECHNICAL_DESCRIPTION" />
+        <Column name="COMPONENT_INDEX" />
+        <Column name="EVENT_CATEGORY" />
+        <Column name="EVENT_GROUP" />
+        <Column name="EVENT_NOTIFICATION_TIME" />
+        <Column name="EVENT_ACTIONS" />
       </Columns>
     </Item>
     <Item name="dbo.FIBER_SHAPES" type="table" extracted="True">
@@ -518,17 +486,6 @@
         <Column name="ACTIVE" />
       </Columns>
     </Item>
-    <Item name="dbo.HTML_PAGES" type="table" extracted="True">
-      <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" extracted="True">
       <Columns>
         <Column name="GUID" key="true" />
@@ -703,17 +660,6 @@
         <Column name="DESCRIPTION" />
       </Columns>
     </Item>
-    <Item name="dbo.MEDIA_COLORS" type="table" extracted="True">
-      <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" extracted="True">
       <Columns>
         <Column name="GUID" key="true" />
@@ -820,7 +766,6 @@
         <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" />
@@ -838,6 +783,9 @@
         <Column name="ESTIMATED_THREAD_DIAMETER" />
         <Column name="RANK" />
         <Column name="THUMBNAIL" />
+        <Column name="WHITE_POINT_L" />
+        <Column name="WHITE_POINT_A" />
+        <Column name="WHITE_POINT_B" />
       </Columns>
     </Item>
     <Item name="dbo.ROLES" type="table" extracted="True">
diff --git a/Software/DB/SQLExaminer Projects/Provision Machine.sdeproj b/Software/DB/SQLExaminer Projects/Provision Machine.sdeproj
index 5e93f2187..735f79ec2 100644
--- a/Software/DB/SQLExaminer Projects/Provision Machine.sdeproj
+++ b/Software/DB/SQLExaminer Projects/Provision Machine.sdeproj
@@ -18,16 +18,6 @@
     </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" />
@@ -107,7 +97,6 @@
         <Column name="V7_DIV" />
         <Column name="CORRECTED" />
         <Column name="COLOR_CATALOG_GUID" />
-        <Column name="COLOR_CATALOG_CODE" />
       </Columns>
     </Item>
     <Item name="dbo.CARTRIDGE_TYPES" type="table">
@@ -166,6 +155,7 @@
         <Column name="A" />
         <Column name="B" />
         <Column name="PROCESS_PARAMETERS_TABLE_INDEX" />
+        <Column name="RML_GUID" />
       </Columns>
     </Item>
     <Item name="dbo.COLOR_SPACES" type="table">
@@ -233,7 +223,11 @@
         <Column name="SERIAL_NUMBER" />
         <Column name="DISPENSER_TYPE_GUID" />
         <Column name="NL_PER_PULSE" />
-        <Column name="DATA" />
+        <Column name="PART_NUMBER" />
+        <Column name="PCB_SERIAL" />
+        <Column name="PCB_VERSION" />
+        <Column name="PRODUCTION_DATE" />
+        <Column name="CALIBRATION_DATA" />
       </Columns>
     </Item>
     <Item name="dbo.EMBEDDED_FIRMWARE_VERSIONS" type="table">
@@ -253,40 +247,14 @@
         <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" />
+        <Column name="TITLE" />
+        <Column name="TECHNICAL_DESCRIPTION" />
+        <Column name="COMPONENT_INDEX" />
+        <Column name="EVENT_CATEGORY" />
+        <Column name="EVENT_GROUP" />
+        <Column name="EVENT_NOTIFICATION_TIME" />
+        <Column name="EVENT_ACTIONS" />
       </Columns>
     </Item>
     <Item name="dbo.FIBER_SHAPES" type="table">
@@ -518,17 +486,6 @@
         <Column name="ACTIVE" />
       </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" />
@@ -703,17 +660,6 @@
         <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" />
@@ -820,7 +766,6 @@
         <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" />
@@ -838,6 +783,9 @@
         <Column name="ESTIMATED_THREAD_DIAMETER" />
         <Column name="RANK" />
         <Column name="THUMBNAIL" />
+        <Column name="WHITE_POINT_L" />
+        <Column name="WHITE_POINT_A" />
+        <Column name="WHITE_POINT_B" />
       </Columns>
     </Item>
     <Item name="dbo.ROLES" type="table">
@@ -1326,7 +1274,11 @@ WHERE MACHINES.SERIAL_NUMBER = '@'
         <Column name="SERIAL_NUMBER" />
         <Column name="DISPENSER_TYPE_GUID" />
         <Column name="NL_PER_PULSE" />
-        <Column name="DATA" />
+        <Column name="PART_NUMBER" />
+        <Column name="PCB_SERIAL" />
+        <Column name="PCB_VERSION" />
+        <Column name="PRODUCTION_DATE" />
+        <Column name="CALIBRATION_DATA" />
       </Columns>
       <Queries>
         <Query id="1">
@@ -1350,7 +1302,6 @@ WHERE MACHINES.SERIAL_NUMBER = '@']]></Text>
                 <UpdateColumn name="SERIAL_NUMBER" />
                 <UpdateColumn name="DISPENSER_TYPE_GUID" />
                 <UpdateColumn name="NL_PER_PULSE" />
-                <UpdateColumn name="DATA" />
               </UpdateColumns>
             </Table>
           </UpdateTables>
@@ -1376,7 +1327,11 @@ WHERE MACHINES.SERIAL_NUMBER = '@']]></Text>
                 <UpdateColumn name="SERIAL_NUMBER" />
                 <UpdateColumn name="DISPENSER_TYPE_GUID" />
                 <UpdateColumn name="NL_PER_PULSE" />
-                <UpdateColumn name="DATA" />
+                <UpdateColumn name="PART_NUMBER" />
+                <UpdateColumn name="PCB_SERIAL" />
+                <UpdateColumn name="PCB_VERSION" />
+                <UpdateColumn name="PRODUCTION_DATE" />
+                <UpdateColumn name="CALIBRATION_DATA" />
               </UpdateColumns>
             </Table>
           </UpdateTables>
diff --git a/Software/DB/SQLExaminer Projects/UpdateMachine.sdeproj b/Software/DB/SQLExaminer Projects/UpdateMachine.sdeproj
index 6597c800f..ba3752fff 100644
--- a/Software/DB/SQLExaminer Projects/UpdateMachine.sdeproj
+++ b/Software/DB/SQLExaminer Projects/UpdateMachine.sdeproj
@@ -18,16 +18,6 @@
     </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" />
@@ -99,7 +89,6 @@
         <Column name="V7" />
         <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" />
@@ -166,6 +155,7 @@
         <Column name="A" />
         <Column name="B" />
         <Column name="PROCESS_PARAMETERS_TABLE_INDEX" />
+        <Column name="RML_GUID" />
       </Columns>
     </Item>
     <Item name="dbo.COLOR_SPACES" type="table">
@@ -233,7 +223,11 @@
         <Column name="SERIAL_NUMBER" />
         <Column name="DISPENSER_TYPE_GUID" />
         <Column name="NL_PER_PULSE" />
-        <Column name="DATA" />
+        <Column name="PART_NUMBER" />
+        <Column name="PCB_SERIAL" />
+        <Column name="PCB_VERSION" />
+        <Column name="PRODUCTION_DATE" />
+        <Column name="CALIBRATION_DATA" />
       </Columns>
     </Item>
     <Item name="dbo.EMBEDDED_FIRMWARE_VERSIONS" type="table">
@@ -253,40 +247,14 @@
         <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" />
+        <Column name="TITLE" />
+        <Column name="TECHNICAL_DESCRIPTION" />
+        <Column name="COMPONENT_INDEX" />
+        <Column name="EVENT_CATEGORY" />
+        <Column name="EVENT_GROUP" />
+        <Column name="EVENT_NOTIFICATION_TIME" />
+        <Column name="EVENT_ACTIONS" />
       </Columns>
     </Item>
     <Item name="dbo.FIBER_SHAPES" type="table">
@@ -518,17 +486,6 @@
         <Column name="ACTIVE" />
       </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" />
@@ -703,17 +660,6 @@
         <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" />
@@ -820,7 +766,6 @@
         <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" />
@@ -838,6 +783,9 @@
         <Column name="ESTIMATED_THREAD_DIAMETER" />
         <Column name="RANK" />
         <Column name="THUMBNAIL" />
+        <Column name="WHITE_POINT_L" />
+        <Column name="WHITE_POINT_A" />
+        <Column name="WHITE_POINT_B" />
       </Columns>
     </Item>
     <Item name="dbo.ROLES" type="table">
@@ -1079,7 +1027,7 @@ INNER JOIN CONFIGURATIONS ON MACHINES.CONFIGURATION_GUID = CONFIGURATIONS.GUID
 INNER JOIN IDS_PACKS ON IDS_PACKS.CONFIGURATION_GUID = CONFIGURATIONS.GUID
 WHERE MACHINES.SERIAL_NUMBER = '@']]></Text>
           <UpdateTables>
-            <Table schema="dbo" name="IDS_PACKS" allowDelete="False" allowInsert="True" allowUpdate="True">
+            <Table schema="dbo" name="IDS_PACKS" allowDelete="True" allowInsert="True" allowUpdate="True">
               <KeyColumns>
                 <KeyColumn name="GUID" />
               </KeyColumns>
@@ -1109,7 +1057,11 @@ WHERE MACHINES.SERIAL_NUMBER = '@']]></Text>
         <Column name="SERIAL_NUMBER" />
         <Column name="DISPENSER_TYPE_GUID" />
         <Column name="NL_PER_PULSE" />
-        <Column name="DATA" />
+        <Column name="PART_NUMBER" />
+        <Column name="PCB_SERIAL" />
+        <Column name="PCB_VERSION" />
+        <Column name="PRODUCTION_DATE" />
+        <Column name="CALIBRATION_DATA" />
       </Columns>
       <Queries>
         <Query id="1">
@@ -1133,7 +1085,6 @@ WHERE MACHINES.SERIAL_NUMBER = '@']]></Text>
                 <UpdateColumn name="SERIAL_NUMBER" />
                 <UpdateColumn name="DISPENSER_TYPE_GUID" />
                 <UpdateColumn name="NL_PER_PULSE" />
-                <UpdateColumn name="DATA" />
               </UpdateColumns>
             </Table>
           </UpdateTables>
@@ -1159,7 +1110,11 @@ WHERE MACHINES.SERIAL_NUMBER = '@']]></Text>
                 <UpdateColumn name="SERIAL_NUMBER" />
                 <UpdateColumn name="DISPENSER_TYPE_GUID" />
                 <UpdateColumn name="NL_PER_PULSE" />
-                <UpdateColumn name="DATA" />
+                <UpdateColumn name="PART_NUMBER" />
+                <UpdateColumn name="PCB_SERIAL" />
+                <UpdateColumn name="PCB_VERSION" />
+                <UpdateColumn name="PRODUCTION_DATE" />
+                <UpdateColumn name="CALIBRATION_DATA" />
               </UpdateColumns>
             </Table>
           </UpdateTables>