Added machine spools to provision and update scripts.

4 files changed, 124 insertions, 0 deletions

diff --git a/Software/DB/SQLExaminer Projects/Provision Machine.sdeproj b/Software/DB/SQLExaminer Projects/Provision Machine.sdeproj
index 5c08958b2..5e93f2187 100644
--- a/Software/DB/SQLExaminer Projects/Provision Machine.sdeproj
+++ b/Software/DB/SQLExaminer Projects/Provision Machine.sdeproj
@@ -1625,6 +1625,67 @@ WHERE MACHINES.SERIAL_NUMBER = '@'
         </Query>
       </Queries>
     </Item>
+    <Item name="Sync_Spools" type="query" extracted="True">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="SPOOL_TYPE_GUID" />
+        <Column name="MACHINE_GUID" />
+        <Column name="START_OFFSET_PULSES" />
+        <Column name="BACKING_RATE" />
+        <Column name="SEGMENT_OFFSET_PULSES" />
+        <Column name="BOTTOM_BACKING_RATE" />
+      </Columns>
+      <Queries>
+        <Query id="1">
+          <Text><![CDATA[SELECT SPOOLS.* FROM SPOOLS 
+INNER JOIN MACHINES ON MACHINES.GUID = SPOOLS.MACHINE_GUID 
+WHERE MACHINES.SERIAL_NUMBER = '@']]></Text>
+          <UpdateTables>
+            <Table schema="dbo" name="SPOOLS" allowDelete="True" allowInsert="True" allowUpdate="True">
+              <KeyColumns>
+                <KeyColumn name="GUID" />
+              </KeyColumns>
+              <UpdateColumns>
+                <UpdateColumn name="ID" />
+                <UpdateColumn name="GUID" />
+                <UpdateColumn name="LAST_UPDATED" />
+                <UpdateColumn name="SPOOL_TYPE_GUID" />
+                <UpdateColumn name="MACHINE_GUID" />
+                <UpdateColumn name="START_OFFSET_PULSES" />
+                <UpdateColumn name="BACKING_RATE" />
+                <UpdateColumn name="SEGMENT_OFFSET_PULSES" />
+                <UpdateColumn name="BOTTOM_BACKING_RATE" />
+              </UpdateColumns>
+            </Table>
+          </UpdateTables>
+        </Query>
+        <Query id="2">
+          <Text><![CDATA[SELECT SPOOLS.* FROM SPOOLS 
+INNER JOIN MACHINES ON MACHINES.GUID = SPOOLS.MACHINE_GUID 
+WHERE MACHINES.SERIAL_NUMBER = '@']]></Text>
+          <UpdateTables>
+            <Table schema="dbo" name="SPOOLS" allowDelete="True" allowInsert="True" allowUpdate="True">
+              <KeyColumns>
+                <KeyColumn name="GUID" />
+              </KeyColumns>
+              <UpdateColumns>
+                <UpdateColumn name="ID" />
+                <UpdateColumn name="GUID" />
+                <UpdateColumn name="LAST_UPDATED" />
+                <UpdateColumn name="SPOOL_TYPE_GUID" />
+                <UpdateColumn name="MACHINE_GUID" />
+                <UpdateColumn name="START_OFFSET_PULSES" />
+                <UpdateColumn name="BACKING_RATE" />
+                <UpdateColumn name="SEGMENT_OFFSET_PULSES" />
+                <UpdateColumn name="BOTTOM_BACKING_RATE" />
+              </UpdateColumns>
+            </Table>
+          </UpdateTables>
+        </Query>
+      </Queries>
+    </Item>
     <Item name="Sync_Users" type="query" extracted="True">
       <Columns>
         <Column name="GUID" key="true" />
diff --git a/Software/DB/SQLExaminer Projects/UpdateMachine.sdeproj b/Software/DB/SQLExaminer Projects/UpdateMachine.sdeproj
index 59a5a2905..6597c800f 100644
--- a/Software/DB/SQLExaminer Projects/UpdateMachine.sdeproj
+++ b/Software/DB/SQLExaminer Projects/UpdateMachine.sdeproj
@@ -1322,6 +1322,69 @@ WHERE MACHINES.SERIAL_NUMBER = '@']]></Text>
         </Query>
       </Queries>
     </Item>
+    <Item name="Sync_Spools" type="query" extracted="True">
+      <Columns>
+        <Column name="GUID" key="true" />
+        <Column name="ID" />
+        <Column name="LAST_UPDATED" />
+        <Column name="SPOOL_TYPE_GUID" />
+        <Column name="MACHINE_GUID" />
+        <Column name="START_OFFSET_PULSES" />
+        <Column name="BACKING_RATE" />
+        <Column name="SEGMENT_OFFSET_PULSES" />
+        <Column name="BOTTOM_BACKING_RATE" />
+      </Columns>
+      <Queries>
+        <Query id="1">
+          <Text><![CDATA[SELECT SPOOLS.* FROM SPOOLS 
+INNER JOIN MACHINES ON MACHINES.GUID = SPOOLS.MACHINE_GUID 
+WHERE MACHINES.SERIAL_NUMBER = '@'
+]]></Text>
+          <UpdateTables>
+            <Table schema="dbo" name="SPOOLS" allowDelete="True" allowInsert="True" allowUpdate="True">
+              <KeyColumns>
+                <KeyColumn name="GUID" />
+              </KeyColumns>
+              <UpdateColumns>
+                <UpdateColumn name="ID" />
+                <UpdateColumn name="GUID" />
+                <UpdateColumn name="LAST_UPDATED" />
+                <UpdateColumn name="SPOOL_TYPE_GUID" />
+                <UpdateColumn name="MACHINE_GUID" />
+                <UpdateColumn name="START_OFFSET_PULSES" />
+                <UpdateColumn name="BACKING_RATE" />
+                <UpdateColumn name="SEGMENT_OFFSET_PULSES" />
+                <UpdateColumn name="BOTTOM_BACKING_RATE" />
+              </UpdateColumns>
+            </Table>
+          </UpdateTables>
+        </Query>
+        <Query id="2">
+          <Text><![CDATA[SELECT SPOOLS.* FROM SPOOLS 
+INNER JOIN MACHINES ON MACHINES.GUID = SPOOLS.MACHINE_GUID 
+WHERE MACHINES.SERIAL_NUMBER = '@'
+]]></Text>
+          <UpdateTables>
+            <Table schema="dbo" name="SPOOLS" allowDelete="True" allowInsert="True" allowUpdate="True">
+              <KeyColumns>
+                <KeyColumn name="GUID" />
+              </KeyColumns>
+              <UpdateColumns>
+                <UpdateColumn name="ID" />
+                <UpdateColumn name="GUID" />
+                <UpdateColumn name="LAST_UPDATED" />
+                <UpdateColumn name="SPOOL_TYPE_GUID" />
+                <UpdateColumn name="MACHINE_GUID" />
+                <UpdateColumn name="START_OFFSET_PULSES" />
+                <UpdateColumn name="BACKING_RATE" />
+                <UpdateColumn name="SEGMENT_OFFSET_PULSES" />
+                <UpdateColumn name="BOTTOM_BACKING_RATE" />
+              </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 00b8513d8..b2f4d1e58 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 317b8ce45..4d9dc0cd5 100644
--- a/Software/DB/Tango_log.ldf
+++ b/Software/DB/Tango_log.ldf