Added new tables in General_Env_Upgrade. Inserted new flag for enable/disable Thread characteristic by Environment.

Related Work Items: #4219

1 files changed, 11 insertions, 120 deletions

diff --git a/Software/DB/SQLExaminer Projects/GENERAL_ENV_UPGRADE.sdeproj b/Software/DB/SQLExaminer Projects/GENERAL_ENV_UPGRADE.sdeproj
index 60bc2f960..892c1a8bd 100644
--- a/Software/DB/SQLExaminer Projects/GENERAL_ENV_UPGRADE.sdeproj
+++ b/Software/DB/SQLExaminer Projects/GENERAL_ENV_UPGRADE.sdeproj
@@ -1307,7 +1307,7 @@
         <Column name="RML_LEVEL" />
       </Columns>
     </Item>
-    <Item name="dbo.YARN_APPLICATIONS" type="table" extracted="True">
+    <Item name="dbo.YARN_APPLICATIONS" type="table" >
       <Columns>
         <Column name="GUID" key="true" />
         <Column name="ID" />
@@ -1315,7 +1315,7 @@
         <Column name="NAME" />
       </Columns>
     </Item>
-    <Item name="dbo.YARN_BRANDS" type="table" extracted="True">
+    <Item name="dbo.YARN_BRANDS" type="table" >
       <Columns>
         <Column name="GUID" key="true" />
         <Column name="ID" />
@@ -1323,7 +1323,7 @@
         <Column name="NAME" />
       </Columns>
     </Item>
-    <Item name="dbo.YARN_FAMILIES" type="table" extracted="True">
+    <Item name="dbo.YARN_FAMILIES" type="table" >
       <Columns>
         <Column name="GUID" key="true" />
         <Column name="ID" />
@@ -1331,7 +1331,7 @@
         <Column name="NAME" />
       </Columns>
     </Item>
-    <Item name="dbo.YARN_GLOSS_LEVELS" type="table" extracted="True">
+    <Item name="dbo.YARN_GLOSS_LEVELS" type="table" >
       <Columns>
         <Column name="GUID" key="true" />
         <Column name="ID" />
@@ -1339,7 +1339,7 @@
         <Column name="NAME" />
       </Columns>
     </Item>
-    <Item name="dbo.YARN_GROUPS" type="table" extracted="True">
+    <Item name="dbo.YARN_GROUPS" type="table" >
       <Columns>
         <Column name="GUID" key="true" />
         <Column name="ID" />
@@ -1347,7 +1347,7 @@
         <Column name="NAME" />
       </Columns>
     </Item>
-    <Item name="dbo.YARN_INDUSTRYSECTORS" type="table" extracted="True">
+    <Item name="dbo.YARN_INDUSTRYSECTORS" type="table" >
       <Columns>
         <Column name="GUID" key="true" />
         <Column name="ID" />
@@ -1355,7 +1355,7 @@
         <Column name="NAME" />
       </Columns>
     </Item>
-    <Item name="dbo.YARN_MANUFACTURERS" type="table" extracted="True">
+    <Item name="dbo.YARN_MANUFACTURERS" type="table" >
       <Columns>
         <Column name="GUID" key="true" />
         <Column name="ID" />
@@ -1363,7 +1363,7 @@
         <Column name="NAME" />
       </Columns>
     </Item>
-    <Item name="dbo.YARN_SUB_FAMILIES" type="table" extracted="True">
+    <Item name="dbo.YARN_SUB_FAMILIES" type="table" >
       <Columns>
         <Column name="GUID" key="true" />
         <Column name="ID" />
@@ -1371,7 +1371,7 @@
         <Column name="NAME" />
       </Columns>
     </Item>
-    <Item name="dbo.YARN_TEXTURINGS" type="table" extracted="True">
+    <Item name="dbo.YARN_TEXTURINGS" type="table" >
       <Columns>
         <Column name="GUID" key="true" />
         <Column name="ID" />
@@ -1379,7 +1379,7 @@
         <Column name="NAME" />
       </Columns>
     </Item>
-    <Item name="dbo.YARN_TYPES" type="table" extracted="True">
+    <Item name="dbo.YARN_TYPES" type="table">
       <Columns>
         <Column name="GUID" key="true" />
         <Column name="ID" />
@@ -1387,7 +1387,7 @@
         <Column name="NAME" />
       </Columns>
     </Item>
-    <Item name="dbo.YARN_WHITE_SHADES" type="table" extracted="True">
+    <Item name="dbo.YARN_WHITE_SHADES" type="table" >
       <Columns>
         <Column name="GUID" key="true" />
         <Column name="ID" />
@@ -1395,115 +1395,6 @@
         <Column name="NAME" />
       </Columns>
     </Item>
-    <Item name="dbo.COLOR_PROCESS_PARAMETERS" type="table">
-      <Columns>
-        <Column name="GUID" key="true" />
-        <Column name="ID" />
-        <Column name="LAST_UPDATED" />
-        <Column name="RMLS_EXTENSIONS_GUID" />
-        <Column name="MACHINE_GUID" />
-        <Column name="WHITE_POINT_L" />
-        <Column name="WHITE_POINT_A" />
-        <Column name="WHITE_POINT_B" />
-      </Columns>
-    </Item>
-    <Item name="dbo.COLOR_PROCESS_FACTORS" type="table">
-      <Columns>
-        <Column name="GUID" key="true" />
-        <Column name="ID" />
-        <Column name="LAST_UPDATED" />
-        <Column name="COLOR_PROCESS_PARAMETERS_GUID" />
-        <Column name="COLOR" />
-        <Column name="INK_NL_CM" />
-        <Column name="L" />
-        <Column name="A" />
-        <Column name="B" />
-        <Column name="FACTOR_PERCENT" />
-      </Columns>
-    </Item>
-    <Item name="dbo.COLOR_PROCESS_DATA" type="table">
-      <Columns>
-        <Column name="GUID" key="true" />
-        <Column name="ID" />
-        <Column name="LAST_UPDATED" />
-        <Column name="COLOR_PROCESS_PARAMETERS_GUID" />
-        <Column name="COLOR" />
-        <Column name="INK_NL_CM" />
-        <Column name="L" />
-        <Column name="A" />
-        <Column name="B" />
-      </Columns>
-    </Item>
-    <Item name="dbo.RML_EXTENSION_TEST_RESULTS" type="table">
-      <Columns>
-        <Column name="GUID" key="true" />
-        <Column name="ID" />
-        <Column name="LAST_UPDATED" />
-        <Column name="RMLS_EXTENSIONS_GUID" />
-        <Column name="MACHINE_GUID" />
-        <Column name="RESULT_INDEX" />
-        <Column name="NAME" />
-        <Column name="DRYER_TEMPERATURE" />
-        <Column name="TUNNEL_TEMPERATURE" />
-        <Column name="TUNNEL_FLOW" />
-        <Column name="TUNNEL_AVG_TEMPERATURE" />
-        <Column name="TENSION_HEAD_MIN" />
-        <Column name="TENSION_HEAD_MAX" />
-        <Column name="TENSION_AFTER_DRYER_MIN" />
-        <Column name="TENSIOIN_AFTER_DRYER_MAX" />
-        <Column name="TENSION_WINDER_MIN" />
-        <Column name="TENSION_WINDER_MAX" />
-        <Column name="BTSR_MIN" />
-        <Column name="BTSR_MAX" />
-        <Column name="PULLER_TENSION_MIN" />
-        <Column name="PULLER_TENSION_MAX" />
-        <Column name="EXIT_TENSION_MIN" />
-        <Column name="EXIT_TENSION_MAX" />
-        <Column name="SEVERITY_ZONE1_MIN" />
-        <Column name="SEVERITY_ZONE1_MAX" />
-        <Column name="SEVERITY_ZONE2_MIN" />
-        <Column name="SEVERITY_ZONE2_MAX" />
-        <Column name="COMMENT" />
-        <Column name="CONCLUSIONS" />
-        <Column name="REF_LUB_VERSION" />
-        <Column name="REF_COF" />
-        <Column name="REF_LUB" />
-        <Column name="THREAD_LUB_VERSION" />
-        <Column name="THREAD_COF" />
-        <Column name="THREAD_LUB" />
-      </Columns>
-    </Item>
-    <Item name="dbo.RUBBING_RESULTS" type="table">
-      <Columns>
-        <Column name="GUID" key="true" />
-        <Column name="ID" />
-        <Column name="LAST_UPDATED" />
-        <Column name="RML_EXTENSION_TEST_RESULTS_GUID" />
-        <Column name="COLOR" />
-        <Column name="DELTAE_CIE_100" />
-        <Column name="GS_100_MIN" />
-        <Column name="GS_100_MAX" />
-        <Column name="DELTAE_CIE_200" />
-        <Column name="GS_200_MIN" />
-        <Column name="GS_200_MAX" />
-      </Columns>
-    </Item>
-    <Item name="dbo.TENSILE_RESULTS" type="table">
-      <Columns>
-        <Column name="GUID" key="true" />
-        <Column name="ID" />
-        <Column name="LAST_UPDATED" />
-        <Column name="RML_EXTENSION_TEST_RESULTS_GUID" />
-        <Column name="COLOR_PERCENT" />
-        <Column name="COLOR" />
-        <Column name="MAX_LOAD" />
-        <Column name="STDEV_MAX_LOAD" />
-        <Column name="STRAIN_MAX_LOAD" />
-        <Column name="STDEV_STRAIN_MAX_LOAD" />
-        <Column name="PERCENT_CHANGE_LOAD" />
-        <Column name="PERCENT_CHANGE_STRAIN" />
-      </Columns>
-    </Item>
   </Items>
   <SchemaMapping>
     <SMItem schema1="dbo" schema2="dbo" />