aboutsummaryrefslogtreecommitdiffstats
path: root/Software/DB/SQLExaminer Projects
diff options
context:
space:
mode:
authorRoy Ben-Shabat <Roy@Twine-s.com>2018-12-04 14:11:29 +0200
committerRoy Ben-Shabat <Roy@Twine-s.com>2018-12-04 14:11:29 +0200
commit5513ba4c2db05de40d9adfac645d7e77c35c71f7 (patch)
tree0088cfa3a3a76692a37f65a4724a5429ca51ed2d /Software/DB/SQLExaminer Projects
parent13f168081666328ac648c230ae0cdd4adf4fd133 (diff)
downloadTango-5513ba4c2db05de40d9adfac645d7e77c35c71f7.tar.gz
Tango-5513ba4c2db05de40d9adfac645d7e77c35c71f7.zip
Worked on PPC setup & update.
Diffstat (limited to 'Software/DB/SQLExaminer Projects')
-rw-r--r--Software/DB/SQLExaminer Projects/Override Tables.sdeproj15
-rw-r--r--Software/DB/SQLExaminer Projects/Provision Machine.sdeproj11
-rw-r--r--Software/DB/SQLExaminer Projects/Update Twine DB.sdeproj9
-rw-r--r--Software/DB/SQLExaminer Projects/UpdateMachine.sdeproj7
4 files changed, 33 insertions, 9 deletions
diff --git a/Software/DB/SQLExaminer Projects/Override Tables.sdeproj b/Software/DB/SQLExaminer Projects/Override Tables.sdeproj
index 4eea23b44..ae9528a15 100644
--- a/Software/DB/SQLExaminer Projects/Override Tables.sdeproj
+++ b/Software/DB/SQLExaminer Projects/Override Tables.sdeproj
@@ -173,6 +173,7 @@
<Column name="V5" />
<Column name="V6" />
<Column name="V7" />
+ <Column name="PROCESS_PARAMETERS_TABLE_INDEX" />
</Columns>
</Item>
<Item name="dbo.COLOR_SPACES" type="table" extracted="True">
@@ -304,7 +305,7 @@
<Column name="CODE" />
</Columns>
</Item>
- <Item name="dbo.HARDWARE_BLOWER_TYPES" type="table">
+ <Item name="dbo.HARDWARE_BLOWER_TYPES" type="table" extracted="True">
<Columns>
<Column name="GUID" key="true" />
<Column name="ID" />
@@ -314,7 +315,7 @@
<Column name="DESCRIPTION" />
</Columns>
</Item>
- <Item name="dbo.HARDWARE_BLOWERS" type="table">
+ <Item name="dbo.HARDWARE_BLOWERS" type="table" extracted="True">
<Columns>
<Column name="GUID" key="true" />
<Column name="ID" />
@@ -324,9 +325,10 @@
<Column name="ENABLED" />
<Column name="VOLTAGE" />
<Column name="ACTIVE" />
+ <Column name="HEATING_VOLTAGE" />
</Columns>
</Item>
- <Item name="dbo.HARDWARE_BREAK_SENSOR_TYPES" type="table">
+ <Item name="dbo.HARDWARE_BREAK_SENSOR_TYPES" type="table" extracted="True">
<Columns>
<Column name="GUID" key="true" />
<Column name="ID" />
@@ -336,7 +338,7 @@
<Column name="DESCRIPTION" />
</Columns>
</Item>
- <Item name="dbo.HARDWARE_BREAK_SENSORS" type="table">
+ <Item name="dbo.HARDWARE_BREAK_SENSORS" type="table" extracted="True">
<Columns>
<Column name="GUID" key="true" />
<Column name="ID" />
@@ -677,6 +679,8 @@
<Column name="DEFAULT_SEGMENT_LENGTH" />
<Column name="DEFAULT_SPOOL_TYPE_GUID" />
<Column name="SYNCHED" />
+ <Column name="AUTO_LOGIN" />
+ <Column name="AUTO_CHECK_FOR_UPDATES" />
</Columns>
</Item>
<Item name="dbo.MACHINES_CONFIGURATIONS" type="table">
@@ -795,6 +799,7 @@
<Column name="HEAD_AIR_FLOW" />
<Column name="PROCESS_PARAMETERS_TABLES_GROUP_GUID" />
<Column name="TABLE_INDEX" />
+ <Column name="MAX_INK_UPTAKE" />
</Columns>
</Item>
<Item name="dbo.PROCESS_PARAMETERS_TABLES_GROUPS" type="table" extracted="True">
@@ -924,7 +929,7 @@
<Column name="DESCRIPTION" />
</Columns>
</Item>
- <Item name="dbo.TECH_HEATERS" type="table">
+ <Item name="dbo.TECH_HEATERS" type="table" extracted="True">
<Columns>
<Column name="GUID" key="true" />
<Column name="ID" />
diff --git a/Software/DB/SQLExaminer Projects/Provision Machine.sdeproj b/Software/DB/SQLExaminer Projects/Provision Machine.sdeproj
index 60f93c308..2fb056697 100644
--- a/Software/DB/SQLExaminer Projects/Provision Machine.sdeproj
+++ b/Software/DB/SQLExaminer Projects/Provision Machine.sdeproj
@@ -173,6 +173,7 @@
<Column name="V5" />
<Column name="V6" />
<Column name="V7" />
+ <Column name="PROCESS_PARAMETERS_TABLE_INDEX" />
</Columns>
</Item>
<Item name="dbo.COLOR_SPACES" type="table">
@@ -324,6 +325,7 @@
<Column name="ENABLED" />
<Column name="VOLTAGE" />
<Column name="ACTIVE" />
+ <Column name="HEATING_VOLTAGE" />
</Columns>
</Item>
<Item name="dbo.HARDWARE_BREAK_SENSOR_TYPES" type="table">
@@ -677,6 +679,8 @@
<Column name="DEFAULT_SEGMENT_LENGTH" />
<Column name="DEFAULT_SPOOL_TYPE_GUID" />
<Column name="SYNCHED" />
+ <Column name="AUTO_LOGIN" />
+ <Column name="AUTO_CHECK_FOR_UPDATES" />
</Columns>
</Item>
<Item name="dbo.MACHINES_CONFIGURATIONS" type="table">
@@ -795,6 +799,7 @@
<Column name="HEAD_AIR_FLOW" />
<Column name="PROCESS_PARAMETERS_TABLES_GROUP_GUID" />
<Column name="TABLE_INDEX" />
+ <Column name="MAX_INK_UPTAKE" />
</Columns>
</Item>
<Item name="dbo.PROCESS_PARAMETERS_TABLES_GROUPS" type="table">
@@ -1120,8 +1125,8 @@ WHERE MACHINES.SERIAL_NUMBER = '@']]></Text>
<KeyColumn name="GUID" />
</KeyColumns>
<UpdateColumns>
- <UpdateColumn name="GUID" />
<UpdateColumn name="ID" />
+ <UpdateColumn name="GUID" />
<UpdateColumn name="LAST_UPDATED" />
<UpdateColumn name="NAME" />
<UpdateColumn name="MACHINE_GUID" />
@@ -1146,8 +1151,8 @@ WHERE MACHINES.SERIAL_NUMBER = '@']]></Text>
<KeyColumn name="GUID" />
</KeyColumns>
<UpdateColumns>
- <UpdateColumn name="GUID" />
<UpdateColumn name="ID" />
+ <UpdateColumn name="GUID" />
<UpdateColumn name="LAST_UPDATED" />
<UpdateColumn name="NAME" />
<UpdateColumn name="MACHINE_GUID" />
@@ -1380,6 +1385,8 @@ WHERE MACHINES.SERIAL_NUMBER = '@'
<Column name="DEFAULT_SEGMENT_LENGTH" />
<Column name="DEFAULT_SPOOL_TYPE_GUID" />
<Column name="SYNCHED" />
+ <Column name="AUTO_LOGIN" />
+ <Column name="AUTO_CHECK_FOR_UPDATES" />
</Columns>
<Queries>
<Query id="1">
diff --git a/Software/DB/SQLExaminer Projects/Update Twine DB.sdeproj b/Software/DB/SQLExaminer Projects/Update Twine DB.sdeproj
index 045e8e1c1..531c81dc2 100644
--- a/Software/DB/SQLExaminer Projects/Update Twine DB.sdeproj
+++ b/Software/DB/SQLExaminer Projects/Update Twine DB.sdeproj
@@ -173,6 +173,7 @@
<Column name="V5" />
<Column name="V6" />
<Column name="V7" />
+ <Column name="PROCESS_PARAMETERS_TABLE_INDEX" />
</Columns>
</Item>
<Item name="dbo.COLOR_SPACES" type="table">
@@ -185,7 +186,7 @@
<Column name="DESCRIPTION" />
</Columns>
</Item>
- <Item name="dbo.CONFIGURATIONS" type="table" extracted="True">
+ <Item name="dbo.CONFIGURATIONS" type="table">
<Columns>
<Column name="GUID" key="true" />
<Column name="ID" />
@@ -324,6 +325,7 @@
<Column name="ENABLED" />
<Column name="VOLTAGE" />
<Column name="ACTIVE" />
+ <Column name="HEATING_VOLTAGE" />
</Columns>
</Item>
<Item name="dbo.HARDWARE_BREAK_SENSOR_TYPES" type="table">
@@ -677,6 +679,8 @@
<Column name="DEFAULT_SEGMENT_LENGTH" />
<Column name="DEFAULT_SPOOL_TYPE_GUID" />
<Column name="SYNCHED" />
+ <Column name="AUTO_LOGIN" />
+ <Column name="AUTO_CHECK_FOR_UPDATES" />
</Columns>
</Item>
<Item name="dbo.MACHINES_CONFIGURATIONS" type="table" extracted="True">
@@ -749,7 +753,7 @@
<Column name="LITER_CAPACITY" />
</Columns>
</Item>
- <Item name="dbo.ORGANIZATIONS" type="table" extracted="True">
+ <Item name="dbo.ORGANIZATIONS" type="table">
<Columns>
<Column name="GUID" key="true" />
<Column name="ID" />
@@ -795,6 +799,7 @@
<Column name="HEAD_AIR_FLOW" />
<Column name="PROCESS_PARAMETERS_TABLES_GROUP_GUID" />
<Column name="TABLE_INDEX" />
+ <Column name="MAX_INK_UPTAKE" />
</Columns>
</Item>
<Item name="dbo.PROCESS_PARAMETERS_TABLES_GROUPS" type="table">
diff --git a/Software/DB/SQLExaminer Projects/UpdateMachine.sdeproj b/Software/DB/SQLExaminer Projects/UpdateMachine.sdeproj
index c2dd5cefa..ae2bb1bed 100644
--- a/Software/DB/SQLExaminer Projects/UpdateMachine.sdeproj
+++ b/Software/DB/SQLExaminer Projects/UpdateMachine.sdeproj
@@ -173,6 +173,7 @@
<Column name="V5" />
<Column name="V6" />
<Column name="V7" />
+ <Column name="PROCESS_PARAMETERS_TABLE_INDEX" />
</Columns>
</Item>
<Item name="dbo.COLOR_SPACES" type="table">
@@ -324,6 +325,7 @@
<Column name="ENABLED" />
<Column name="VOLTAGE" />
<Column name="ACTIVE" />
+ <Column name="HEATING_VOLTAGE" />
</Columns>
</Item>
<Item name="dbo.HARDWARE_BREAK_SENSOR_TYPES" type="table">
@@ -677,6 +679,8 @@
<Column name="DEFAULT_SEGMENT_LENGTH" />
<Column name="DEFAULT_SPOOL_TYPE_GUID" />
<Column name="SYNCHED" />
+ <Column name="AUTO_LOGIN" />
+ <Column name="AUTO_CHECK_FOR_UPDATES" />
</Columns>
</Item>
<Item name="dbo.MACHINES_CONFIGURATIONS" type="table">
@@ -795,6 +799,7 @@
<Column name="HEAD_AIR_FLOW" />
<Column name="PROCESS_PARAMETERS_TABLES_GROUP_GUID" />
<Column name="TABLE_INDEX" />
+ <Column name="MAX_INK_UPTAKE" />
</Columns>
</Item>
<Item name="dbo.PROCESS_PARAMETERS_TABLES_GROUPS" type="table">
@@ -1178,6 +1183,8 @@ WHERE MACHINES.SERIAL_NUMBER = '@']]></Text>
<Column name="DEFAULT_SEGMENT_LENGTH" />
<Column name="DEFAULT_SPOOL_TYPE_GUID" />
<Column name="SYNCHED" />
+ <Column name="AUTO_LOGIN" />
+ <Column name="AUTO_CHECK_FOR_UPDATES" />
</Columns>
<Queries>
<Query id="1">