From 9fe362dc5ca363480bca5a58ed6d0a5db0ae2c4c Mon Sep 17 00:00:00 2001 From: Aron Roberts Date: Mon, 28 Feb 2011 23:04:43 +0000 Subject: [PATCH] CSPACE-3586: Add config for autogenerating Media Resource Identification numbers. --- .../resources/db/mysql/load_id_generators.sql | 43 +++++++++++++++++++ 1 file changed, 43 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 31e517f21..1de199f1e 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 @@ -363,6 +363,49 @@ loaned out of the institution.', '); +-- MEDIA_RESOURCE_IDENTIFICATION_NUMBER + +INSERT INTO `id_generators` + (csid, displayname, description, priority, last_generated_id, id_generator_state) + VALUES + ('cd91d8b8-f346-4925-a425-93e02bd1c5c9', + 'Media Resource Identification Number', + 'Unambiguously identifies a media resource within a given context. +Recommended best practice is to identify the resource by means of a string +conforming to a formal identification system.', + '9', + '', +' + + + MR + MR + + + + + + . + . + + + 6 + 1 + -1 + + + . + . + + + 6 + 1 + -1 + + +'); + + -- MOVEMENT_REFERENCE_NUMBER INSERT INTO `id_generators` -- 2.47.3