From 4f3dd86d7321018e42dcb6606c3905fab188b6db Mon Sep 17 00:00:00 2001 From: Aron Roberts Date: Mon, 12 Mar 2012 16:10:39 -0700 Subject: [PATCH] CSPACE-4911: Added inventory and location ID number patterns for Location, Movement and Inventory records. --- .../resources/db/mysql/load_id_generators.sql | 82 ++++++++++++++++++- .../db/postgresql/load_id_generators.sql | 82 ++++++++++++++++++- 2 files changed, 162 insertions(+), 2 deletions(-) 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 6b114a881..2cadf18f4 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 @@ -246,6 +246,46 @@ either returned to their owner or formally acquired.', '); +-- INVENTORY_NUMBER + +INSERT INTO id_generators + (csid, displayname, description, priority, last_generated_id, id_generator_state) + VALUES + ('6d472be6-2534-47f3-a3f1-3f160e7a9303', + 'Inventory Number', + 'Unambiguously identifies a location associated with an inventory event.', + '9', + '', +' + + + INV + INV + + + + + + . + . + + + 6 + 1 + -1 + + + . + . + + + 6 + 1 + -1 + + +'); + -- LIBRARY_NUMBER INSERT INTO `id_generators` @@ -361,6 +401,47 @@ loaned out of the institution.', '); +-- LOCATION_NUMBER + +INSERT INTO id_generators + (csid, displayname, description, priority, last_generated_id, id_generator_state) + VALUES + ('1fc5e383-0786-4126-9a3c-ec7df4517ee3', + 'Location Number', + 'Unambiguously identifies a general location, not associated with an +inventory or movement event.', + '9', + '', +' + + + LOC + LOC + + + + + + . + . + + + 6 + 1 + -1 + + + . + . + + + 6 + 1 + -1 + + +'); + -- MEDIA_RESOURCE_IDENTIFICATION_NUMBER INSERT INTO `id_generators` @@ -403,7 +484,6 @@ conforming to a formal identification system.', '); - -- MOVEMENT_REFERENCE_NUMBER INSERT INTO `id_generators` diff --git a/services/id/service/src/main/resources/db/postgresql/load_id_generators.sql b/services/id/service/src/main/resources/db/postgresql/load_id_generators.sql index 217609ff4..47b69b9bc 100644 --- a/services/id/service/src/main/resources/db/postgresql/load_id_generators.sql +++ b/services/id/service/src/main/resources/db/postgresql/load_id_generators.sql @@ -246,6 +246,46 @@ either returned to their owner or formally acquired.', '); +-- INVENTORY_NUMBER + +INSERT INTO id_generators + (csid, displayname, description, priority, last_generated_id, id_generator_state) + VALUES + ('6d472be6-2534-47f3-a3f1-3f160e7a9303', + 'Inventory Number', + 'Unambiguously identifies a location associated with an inventory event.', + '9', + '', +' + + + INV + INV + + + + + + . + . + + + 6 + 1 + -1 + + + . + . + + + 6 + 1 + -1 + + +'); + -- LIBRARY_NUMBER INSERT INTO id_generators @@ -361,6 +401,47 @@ loaned out of the institution.', '); +-- LOCATION_NUMBER + +INSERT INTO id_generators + (csid, displayname, description, priority, last_generated_id, id_generator_state) + VALUES + ('1fc5e383-0786-4126-9a3c-ec7df4517ee3', + 'Location Number', + 'Unambiguously identifies a general location, not associated with an +inventory or movement event.', + '9', + '', +' + + + LOC + LOC + + + + + + . + . + + + 6 + 1 + -1 + + + . + . + + + 6 + 1 + -1 + + +'); + -- MEDIA_RESOURCE_IDENTIFICATION_NUMBER INSERT INTO id_generators @@ -403,7 +484,6 @@ conforming to a formal identification system.', '); - -- MOVEMENT_REFERENCE_NUMBER INSERT INTO id_generators -- 2.47.3