From 702dc1b15a4a9b1870719a7a227941eee8dfd271 Mon Sep 17 00:00:00 2001
From: Aron Roberts <aron@socrates.berkeley.edu>
Date: Thu, 2 Sep 2010 04:28:44 +0000
Subject: [PATCH] CSPACE-2334,CSPACE-2761,CSPACE-2762: Corrected error in
 Movement ID pattern; added Object Exit and Transfer of Title ID pattern, to
 the set of default ID generators.

---
 .../resources/db/mysql/load_id_generators.sql | 56 +++++++++++++++++++
 1 file changed, 56 insertions(+)

diff --git a/services/id/service/src/main/resources/db/mysql/load_id_generators.sql b/services/id/service/src/main/resources/db/mysql/load_id_generators.sql
index 3a2bbc18e..31e517f21 100644
--- a/services/id/service/src/main/resources/db/mysql/load_id_generators.sql
+++ b/services/id/service/src/main/resources/db/mysql/load_id_generators.sql
@@ -391,6 +391,30 @@ INSERT INTO `id_generators`
       <initialValue>1</initialValue>
       <currentValue>-1</currentValue>
     </org.collectionspace.services.id.NumericIDGeneratorPart>
+  </parts>
+</org.collectionspace.services.id.SettableIDGenerator>');
+
+-- OBJECT_EXIT_NUMBER
+
+INSERT INTO `id_generators`
+    (csid, displayname, description, priority, last_generated_id, id_generator_state)
+  VALUES
+    ('d4eea707-d473-4367-853a-728fbcd9be17',
+     'Object Exit Number',
+     'Identifies an exit from the museum of collection objects, via
+transfer or destruction, and the deaccessioning of those objects
+from the museum\'s collections.',
+     '9',
+     '',
+'<org.collectionspace.services.id.SettableIDGenerator>
+  <parts>
+    <org.collectionspace.services.id.StringIDGeneratorPart>
+      <initialValue>EX</initialValue>
+      <currentValue>EX</currentValue>
+    </org.collectionspace.services.id.StringIDGeneratorPart>
+    <org.collectionspace.services.id.YearIDGeneratorPart>
+      <currentValue></currentValue>
+    </org.collectionspace.services.id.YearIDGeneratorPart>
     <org.collectionspace.services.id.StringIDGeneratorPart>
       <initialValue>.</initialValue>
       <currentValue>.</currentValue>
@@ -436,6 +460,38 @@ formally acquired for study.',
   </parts>
 </org.collectionspace.services.id.SettableIDGenerator>');
 
+-- TRANSFER_OF_TITLE_NUMBER
+
+INSERT INTO `id_generators`
+    (csid, displayname, description, priority, last_generated_id, id_generator_state)
+  VALUES
+    ('c597a209-5954-4fa6-bf3f-f83c1a0ad586',
+     'Transfer of Title Number',
+     'Identifies the transfer of title for one or more collection objects
+to a receiving institution.',
+     '9',
+     '',
+'<org.collectionspace.services.id.SettableIDGenerator>
+  <parts>
+    <org.collectionspace.services.id.StringIDGeneratorPart>
+      <initialValue>TT</initialValue>
+      <currentValue>TT</currentValue>
+    </org.collectionspace.services.id.StringIDGeneratorPart>
+    <org.collectionspace.services.id.YearIDGeneratorPart>
+      <currentValue></currentValue>
+    </org.collectionspace.services.id.YearIDGeneratorPart>
+    <org.collectionspace.services.id.StringIDGeneratorPart>
+      <initialValue>.</initialValue>
+      <currentValue>.</currentValue>
+    </org.collectionspace.services.id.StringIDGeneratorPart>
+    <org.collectionspace.services.id.NumericIDGeneratorPart>
+      <maxLength>6</maxLength>
+      <initialValue>1</initialValue>
+      <currentValue>-1</currentValue>
+    </org.collectionspace.services.id.NumericIDGeneratorPart>
+  </parts>
+</org.collectionspace.services.id.SettableIDGenerator>');
+
 -- UUID
 
 /*
-- 
2.47.3