\set ON_ERROR_STOP on

\c nubarchiva
SET SCHEMA 'nuba00001';

/*
 *********************************************
 * source: nuba-commons.07.insert.sql
 *                                           *
 *      This is an auto generated file.      *
 *     !!!!! DO NOT EDIT DIRECTLY. !!!!!     *
 *                                           *
 *********************************************
 */

INSERT INTO SETTING(NAME, VALUE) VALUES ('opac.data.lastimport', NULL);
INSERT INTO SETTING(NAME, VALUE) VALUES ('opac.web.maintenanceMode','false');
INSERT INTO SETTING(NAME, VALUE) VALUES ('opac.web.maintenanceMessage','<p><b>Estamos incorporando más contenidos al catálogo.</b></p><p>Puede personalizar este mensaje de modificando el valor de <i>opac.web.maintenanceMessage</i> <br>en la tabla<i>SETTINGS</i>.</p>');
INSERT INTO SETTING(NAME, VALUE) VALUES ('nubarchiva.institution.code', current_schema());
INSERT INTO SETTING(NAME, VALUE) VALUES ('request.priorityDefaultUserListValue', 'Ordinario');

INSERT INTO USERS (FULLNAME,USERNAME,PASSWORD,ENABLED) VALUES('Administrador', 'admin', 'd033e22ae348aeb5660fc2140aec35850c4da997',true);
INSERT INTO USERS (FULLNAME,USERNAME,PASSWORD,ENABLED) VALUES('Archivo', 'archivo', '12695755fa047b234137b87558e063d20e864030',true);

INSERT INTO AUTHORITIES (USERNAME,AUTHORITY,ORGANIZATION) VALUES('admin'  , 'ROLE_ADMIN', NULL);
INSERT INTO AUTHORITIES (USERNAME,AUTHORITY,ORGANIZATION) VALUES('archivo', 'ARCHIVIST' , 1   );

/*
 *********************************************
 * source: nuba-opac.07.insert.sql
 *                                           *
 *      This is an auto generated file.      *
 *     !!!!! DO NOT EDIT DIRECTLY. !!!!!     *
 *                                           *
 *********************************************
 */

INSERT INTO ARCHIVE (IDARCHIVE , ARCHIVE) VALUES(1,'Archivo');

INSERT INTO DESCRIPTIONLEVEL(IDDESCRIPTIONLEVEL,DESCRIPTIONLEVEL,HIERARCHY,SHORTDESC) VALUES (1,'Grupo de Fondos', 1, 'GF');
INSERT INTO DESCRIPTIONLEVEL(IDDESCRIPTIONLEVEL,DESCRIPTIONLEVEL,HIERARCHY,SHORTDESC) VALUES (2,'Fondo'          , 2, 'FO');
INSERT INTO DESCRIPTIONLEVEL(IDDESCRIPTIONLEVEL,DESCRIPTIONLEVEL,HIERARCHY,SHORTDESC) VALUES (3,'Sección'        , 3, 'SC');
INSERT INTO DESCRIPTIONLEVEL(IDDESCRIPTIONLEVEL,DESCRIPTIONLEVEL,HIERARCHY,SHORTDESC) VALUES (4,'Serie'          , 4, 'SR');
INSERT INTO DESCRIPTIONLEVEL(IDDESCRIPTIONLEVEL,DESCRIPTIONLEVEL,HIERARCHY,SHORTDESC) VALUES (6,'Caja'           , 6, 'CA');
INSERT INTO DESCRIPTIONLEVEL(IDDESCRIPTIONLEVEL,DESCRIPTIONLEVEL,HIERARCHY,SHORTDESC) VALUES (7,'Expediente'     , 7, 'EX');
INSERT INTO DESCRIPTIONLEVEL(IDDESCRIPTIONLEVEL,DESCRIPTIONLEVEL,HIERARCHY,SHORTDESC) VALUES (8,'Documento'      , 8, 'DO');

INSERT INTO SETTING (NAME, VALUE) VALUES ('opac.service.schematable.visible.desclevel','GF,FO,SC,SR');

INSERT INTO FIXEDSEARCH(IDFIXEDSEARCH, TITLE, FSEARCHTYPE)
     VALUES (999998, 'Filtrar descripciones marcadas para borrado', 'SEARCH_ENGINE');

INSERT INTO FIXEDTERM(IDFIXEDSEARCH, SEARCHTERMTYPE, VALUE, CONDITION)
     VALUES (999998, 'STATE', 'R', 'NOT_CONTAINS');

INSERT INTO FIXEDSEARCHCONDITION(IDFIXEDSEARCH, CONDITIONTYPE, CONDITIONVALUE)
     VALUES (999998, 'ROLE', '!ROLE_ADMIN');

INSERT INTO FIXEDSEARCH(TITLE, FSEARCHTYPE)
     VALUES ('Portal General', 'SEARCH_ENGINE');

INSERT INTO MONOGRAPHPORTAL (TITLE,SHORTDESC,CONFIGURATION,IDFIXEDSEARCH)
VALUES ('Portal General',null,'{"root":"","searchConfiguration":null,"showClassificationTable": true}',
(Select IDFIXEDSEARCH from FIXEDSEARCH where TITLE = 'Portal General'));

/*
 *********************************************
 * source: nuba-desar.07.insert.sql
 *                                           *
 *      This is an auto generated file.      *
 *     !!!!! DO NOT EDIT DIRECTLY. !!!!!     *
 *                                           *
 *********************************************
 */

/* Editores*/
INSERT INTO CLASSEDITOR (IDCLASSEDITOR, CLASSNAME) VALUES( 1,'es.aragon.dgpc.desar.web.descriptions.components.DescriptionLevel');
INSERT INTO CLASSEDITOR (IDCLASSEDITOR, CLASSNAME) VALUES( 2,'es.aragon.dgpc.desar.web.descriptions.components.DocumentTypes');
INSERT INTO CLASSEDITOR (IDCLASSEDITOR, CLASSNAME) VALUES( 3,'es.aragon.dgpc.desar.web.descriptions.components.SuperiorLevel');
INSERT INTO CLASSEDITOR (IDCLASSEDITOR, CLASSNAME) VALUES( 6,'es.aragon.dgpc.desar.web.descriptions.editors.SignatureFondoEditor');
INSERT INTO CLASSEDITOR (IDCLASSEDITOR, CLASSNAME) VALUES( 7,'es.aragon.dgpc.desar.web.descriptions.editors.SignatureExpedientEditor');
INSERT INTO CLASSEDITOR (IDCLASSEDITOR, CLASSNAME) VALUES( 9,'es.aragon.dgpc.desar.web.descriptions.editors.TitleEditorSingle');
INSERT INTO CLASSEDITOR (IDCLASSEDITOR, CLASSNAME) VALUES(10,'es.aragon.dgpc.desar.web.descriptions.components.TitleExpedient');
INSERT INTO CLASSEDITOR (IDCLASSEDITOR, CLASSNAME) VALUES(11,'es.aragon.dgpc.desar.web.descriptions.components.TitleDocument');
INSERT INTO CLASSEDITOR (IDCLASSEDITOR, CLASSNAME) VALUES(12,'es.aragon.dgpc.desar.web.descriptions.editors.ProducerDatesEditor');
INSERT INTO CLASSEDITOR (IDCLASSEDITOR, CLASSNAME) VALUES(13,'es.aragon.dgpc.desar.web.descriptions.components.lists.ProducerDatesDocument');
INSERT INTO CLASSEDITOR (IDCLASSEDITOR, CLASSNAME) VALUES(14,'es.aragon.dgpc.desar.web.descriptions.editors.DimensionExpedientEditor');
INSERT INTO CLASSEDITOR (IDCLASSEDITOR, CLASSNAME) VALUES(17,'es.aragon.dgpc.desar.web.descriptions.editors.ProductorEditor');
INSERT INTO CLASSEDITOR (IDCLASSEDITOR, CLASSNAME) VALUES(20,'es.aragon.dgpc.desar.web.descriptions.components.lists.Adquisitions');
INSERT INTO CLASSEDITOR (IDCLASSEDITOR, CLASSNAME) VALUES(23,'es.aragon.dgpc.desar.web.descriptions.editors.OrganizationEditor');
INSERT INTO CLASSEDITOR (IDCLASSEDITOR, CLASSNAME) VALUES(24,'es.aragon.dgpc.desar.web.descriptions.components.lists.Resources');
INSERT INTO CLASSEDITOR (IDCLASSEDITOR, CLASSNAME) VALUES(25,'es.aragon.dgpc.desar.web.descriptions.editors.SecurityEditor');
INSERT INTO CLASSEDITOR (IDCLASSEDITOR, CLASSNAME) VALUES(26,'es.aragon.dgpc.desar.web.descriptions.editors.LanguageEditor');
INSERT INTO CLASSEDITOR (IDCLASSEDITOR, CLASSNAME) VALUES(28,'es.aragon.dgpc.desar.web.descriptions.components.Localization');
INSERT INTO CLASSEDITOR (IDCLASSEDITOR, CLASSNAME) VALUES(29,'es.aragon.dgpc.desar.web.descriptions.editors.RelatedMaterialEditor');
INSERT INTO CLASSEDITOR (IDCLASSEDITOR, CLASSNAME) VALUES(30,'es.aragon.dgpc.desar.web.descriptions.editors.GeneralNoteEditor');
INSERT INTO CLASSEDITOR (IDCLASSEDITOR, CLASSNAME) VALUES(33,'es.aragon.dgpc.desar.web.descriptions.components.lists.Revisions');
INSERT INTO CLASSEDITOR (IDCLASSEDITOR, CLASSNAME) VALUES(34,'es.aragon.dgpc.desar.web.descriptions.editors.AuthorityFondoEditor');
INSERT INTO CLASSEDITOR (IDCLASSEDITOR, CLASSNAME) VALUES(35,'es.aragon.dgpc.desar.web.descriptions.editors.PublicationEditor');
INSERT INTO CLASSEDITOR (IDCLASSEDITOR, CLASSNAME) VALUES(36,'es.aragon.dgpc.desar.web.descriptions.editors.ExtensionEditor');
INSERT INTO CLASSEDITOR (IDCLASSEDITOR, CLASSNAME) VALUES(37,'es.aragon.dgpc.desar.web.descriptions.editors.ConservationStateEditor');
INSERT INTO CLASSEDITOR (IDCLASSEDITOR, CLASSNAME) VALUES(38,'es.aragon.dgpc.desar.web.descriptions.editors.ExternalFeaturesEditor');
INSERT INTO CLASSEDITOR (IDCLASSEDITOR, CLASSNAME) VALUES(39,'es.aragon.dgpc.desar.web.descriptions.editors.InstitutionalHistoryEditor');
INSERT INTO CLASSEDITOR (IDCLASSEDITOR, CLASSNAME) VALUES(40,'es.aragon.dgpc.desar.web.descriptions.editors.CustodialHistoryEditor');
INSERT INTO CLASSEDITOR (IDCLASSEDITOR, CLASSNAME) VALUES(41,'es.aragon.dgpc.desar.web.descriptions.editors.ScopeContentEditor');
INSERT INTO CLASSEDITOR (IDCLASSEDITOR, CLASSNAME) VALUES(42,'es.aragon.dgpc.desar.web.descriptions.editors.DescriptionTools');
INSERT INTO CLASSEDITOR (IDCLASSEDITOR, CLASSNAME) VALUES(43,'es.aragon.dgpc.desar.web.descriptions.editors.CenterEditor');
INSERT INTO CLASSEDITOR (IDCLASSEDITOR, CLASSNAME) VALUES(44,'es.aragon.dgpc.desar.web.descriptions.editors.DescriptionRulesEditor');
INSERT INTO CLASSEDITOR (IDCLASSEDITOR, CLASSNAME) VALUES(45,'es.aragon.dgpc.desar.web.descriptions.components.ValuationElimination');
INSERT INTO CLASSEDITOR (IDCLASSEDITOR, CLASSNAME) VALUES(46,'es.aragon.dgpc.desar.web.descriptions.components.NewEntries');
INSERT INTO CLASSEDITOR (IDCLASSEDITOR, CLASSNAME) VALUES(47,'es.aragon.dgpc.desar.web.descriptions.editors.OldSignatureEditor');
INSERT INTO CLASSEDITOR (IDCLASSEDITOR, CLASSNAME) VALUES(48,'es.aragon.dgpc.desar.web.descriptions.editors.DiplomaticDescriptionEditor');
INSERT INTO CLASSEDITOR (IDCLASSEDITOR, CLASSNAME) VALUES(49,'es.aragon.dgpc.desar.web.descriptions.editors.AuthorityEditor');
INSERT INTO CLASSEDITOR (IDCLASSEDITOR, CLASSNAME) VALUES(50,'es.aragon.dgpc.desar.web.descriptions.editors.AutorEditor');
INSERT INTO CLASSEDITOR (IDCLASSEDITOR, CLASSNAME) VALUES(51,'es.aragon.dgpc.desar.web.descriptions.editors.AutorRightsEditor');
INSERT INTO CLASSEDITOR (IDCLASSEDITOR, CLASSNAME) VALUES(52,'es.aragon.dgpc.desar.web.descriptions.editors.BibliographicalPublicactionEditor');
INSERT INTO CLASSEDITOR (IDCLASSEDITOR, CLASSNAME) VALUES(53,'es.aragon.dgpc.desar.web.descriptions.editors.ConservationEditor');
INSERT INTO CLASSEDITOR (IDCLASSEDITOR, CLASSNAME) VALUES(54,'es.aragon.dgpc.desar.web.descriptions.editors.ContentEditor');
INSERT INTO CLASSEDITOR (IDCLASSEDITOR, CLASSNAME) VALUES(55,'es.aragon.dgpc.desar.web.descriptions.editors.CopiesLocationEditor');
INSERT INTO CLASSEDITOR (IDCLASSEDITOR, CLASSNAME) VALUES(56,'es.aragon.dgpc.desar.web.descriptions.editors.DateEditor');
INSERT INTO CLASSEDITOR (IDCLASSEDITOR, CLASSNAME) VALUES(57,'es.aragon.dgpc.desar.web.descriptions.editors.DimensionEditor');
INSERT INTO CLASSEDITOR (IDCLASSEDITOR, CLASSNAME) VALUES(58,'es.aragon.dgpc.desar.web.descriptions.editors.ImageColorEditor');
INSERT INTO CLASSEDITOR (IDCLASSEDITOR, CLASSNAME) VALUES(59,'es.aragon.dgpc.desar.web.descriptions.editors.NotesEditor');
INSERT INTO CLASSEDITOR (IDCLASSEDITOR, CLASSNAME) VALUES(60,'es.aragon.dgpc.desar.web.descriptions.editors.OldMaterialEditor');
INSERT INTO CLASSEDITOR (IDCLASSEDITOR, CLASSNAME) VALUES(61,'es.aragon.dgpc.desar.web.descriptions.editors.OrientationEditor');
INSERT INTO CLASSEDITOR (IDCLASSEDITOR, CLASSNAME) VALUES(62,'es.aragon.dgpc.desar.web.descriptions.editors.OriginalsLocationEditor');
INSERT INTO CLASSEDITOR (IDCLASSEDITOR, CLASSNAME) VALUES(63,'es.aragon.dgpc.desar.web.descriptions.editors.OwnerEditor');
INSERT INTO CLASSEDITOR (IDCLASSEDITOR, CLASSNAME) VALUES(64,'es.aragon.dgpc.desar.web.descriptions.editors.components.Place');
INSERT INTO CLASSEDITOR (IDCLASSEDITOR, CLASSNAME) VALUES(65,'es.aragon.dgpc.desar.web.descriptions.editors.QuantityEditor');
INSERT INTO CLASSEDITOR (IDCLASSEDITOR, CLASSNAME) VALUES(66,'es.aragon.dgpc.desar.web.descriptions.editors.ReferenceCodeEditor');
INSERT INTO CLASSEDITOR (IDCLASSEDITOR, CLASSNAME) VALUES(67,'es.aragon.dgpc.desar.web.descriptions.editors.RelatedDocumentsEditor');
INSERT INTO CLASSEDITOR (IDCLASSEDITOR, CLASSNAME) VALUES(68,'es.aragon.dgpc.desar.web.descriptions.editors.components.Signature');
INSERT INTO CLASSEDITOR (IDCLASSEDITOR, CLASSNAME) VALUES(69,'es.aragon.dgpc.desar.web.descriptions.editors.SuperiorLevelEditor');
INSERT INTO CLASSEDITOR (IDCLASSEDITOR, CLASSNAME) VALUES(70,'es.aragon.dgpc.desar.web.descriptions.editors.SupportEditor');
INSERT INTO CLASSEDITOR (IDCLASSEDITOR, CLASSNAME) VALUES(71,'es.aragon.dgpc.desar.web.descriptions.editors.TitleEditor');
INSERT INTO CLASSEDITOR (IDCLASSEDITOR, CLASSNAME) VALUES(72,'es.aragon.dgpc.desar.web.descriptions.components.lists.InstitutionsAuthorities');
INSERT INTO CLASSEDITOR (IDCLASSEDITOR, CLASSNAME) VALUES(73,'es.aragon.dgpc.desar.web.descriptions.components.lists.MattersAuthorities');
INSERT INTO CLASSEDITOR (IDCLASSEDITOR, CLASSNAME) VALUES(74,'es.aragon.dgpc.desar.web.descriptions.components.lists.PersonsAutorities');
INSERT INTO CLASSEDITOR (IDCLASSEDITOR, CLASSNAME) VALUES(75,'es.aragon.dgpc.desar.web.descriptions.components.lists.PlacesAuthorities');
INSERT INTO CLASSEDITOR (IDCLASSEDITOR, CLASSNAME) VALUES(76,'es.aragon.dgpc.desar.web.descriptions.components.lists.ThemesAccessPoint');
INSERT INTO CLASSEDITOR (IDCLASSEDITOR, CLASSNAME) VALUES(77,'es.aragon.dgpc.desar.web.descriptions.editors.PublisherNotesEditor');
INSERT INTO CLASSEDITOR (IDCLASSEDITOR, CLASSNAME) VALUES(78,'es.aragon.dgpc.desar.web.descriptions.editors.ConservationDropDownChoiceEditor');
INSERT INTO CLASSEDITOR (IDCLASSEDITOR, CLASSNAME) VALUES(79,'es.aragon.dgpc.desar.web.descriptions.editors.HostItemEditor');
INSERT INTO CLASSEDITOR (IDCLASSEDITOR, CLASSNAME) VALUES(80,'es.aragon.dgpc.desar.web.descriptions.editors.DateDocumentEditor');
INSERT INTO CLASSEDITOR (IDCLASSEDITOR, CLASSNAME) VALUES(82,'es.aragon.dgpc.desar.web.descriptions.editors.RevisionsHiddenEditor');
INSERT INTO CLASSEDITOR (IDCLASSEDITOR, CLASSNAME) VALUES(83,'es.aragon.dgpc.desar.web.descriptions.editors.GenericLabelTextEditor');
INSERT INTO CLASSEDITOR (IDCLASSEDITOR, CLASSNAME) VALUES(84,'es.aragon.dgpc.desar.web.descriptions.editors.GenericLabelTextAreaEditor');
INSERT INTO CLASSEDITOR (IDCLASSEDITOR, CLASSNAME) VALUES(85,'es.aragon.dgpc.desar.web.descriptions.components.lists.MeetingsAuthorities');
INSERT INTO CLASSEDITOR (IDCLASSEDITOR, CLASSNAME) VALUES(86,'es.aragon.dgpc.desar.web.descriptions.editors.RestrictionsOnAccessNoteEditor');
INSERT INTO CLASSEDITOR (IDCLASSEDITOR, CLASSNAME) VALUES(87,'es.aragon.dgpc.desar.web.descriptions.editors.GenericDropDownChoiceEditor');
INSERT INTO CLASSEDITOR (IDCLASSEDITOR, CLASSNAME) VALUES(88,'es.aragon.dgpc.desar.web.descriptions.editors.GenericLabelCheckBoxEditor');
INSERT INTO CLASSEDITOR (IDCLASSEDITOR, CLASSNAME) VALUES(89,'es.aragon.dgpc.desar.web.descriptions.editors.DescriptionLevelEditor');
INSERT INTO CLASSEDITOR (IDCLASSEDITOR, CLASSNAME) VALUES(90, 'es.aragon.dgpc.desar.web.descriptions.editors.DisposalEditor');
INSERT INTO CLASSEDITOR (IDCLASSEDITOR, CLASSNAME) VALUES(998,'es.aragon.dgpc.desar.web.descriptions.editors.MarcRecordEditor');
INSERT INTO CLASSEDITOR (IDCLASSEDITOR, CLASSNAME) VALUES(999,'es.aragon.dgpc.desar.web.descriptions.editors.LabelSeparator');
INSERT INTO CLASSEDITOR (IDCLASSEDITOR, CLASSNAME) VALUES(1280,'es.aragon.dgpc.desar.web.descriptions.editors.GenericDatafieldRepeaterEditor');

/*Fondo*/
INSERT INTO FORM (IDFORM, TITLE, DESCRIPTION, TYPE, SORDER) VALUES(1, 'Descripción de un Fondo', 'Formulario creado para describir fondos', 'D', 3);
INSERT INTO FIELD (IDFORM, LABEL, IDCLASSEDITOR,REQUIERED,SORDER) VALUES (1,'Tipo de documento',2,false,5);
INSERT INTO FIELD (IDFORM, LABEL, IDCLASSEDITOR,REQUIERED,SORDER) VALUES (1,'Nivel de Descripción',1,false,7);
INSERT INTO FIELD (IDFORM, LABEL, IDCLASSEDITOR,REQUIERED,SORDER) VALUES (1,'Nivel Superior',3,false,9);
INSERT INTO FIELD (IDFORM, LABEL, IDCLASSEDITOR,REQUIERED,SORDER) VALUES (1,'Título',9,false,20);
INSERT INTO FIELD (IDFORM, LABEL, IDCLASSEDITOR,REQUIERED,SORDER) VALUES (1,'Publicación / Bibliografía',35,false,40);
INSERT INTO FIELD (IDFORM, LABEL, IDCLASSEDITOR,REQUIERED,SORDER) VALUES (1,'Extensión',36,false,45);
INSERT INTO FIELD (IDFORM, LABEL, IDCLASSEDITOR,REQUIERED,SORDER) VALUES (1,'Estado de conservación',37,false,50);
INSERT INTO FIELD (IDFORM, LABEL, IDCLASSEDITOR,REQUIERED,SORDER,INITEDITOR) VALUES (1,'Características externas',38,false,60, '{"userListId": 2}');
INSERT INTO FIELD (IDFORM, LABEL, IDCLASSEDITOR,REQUIERED,SORDER) VALUES (1,'Historia institucional / Biografía',39,false,80);
INSERT INTO FIELD (IDFORM, LABEL, IDCLASSEDITOR,REQUIERED,SORDER) VALUES (1,'Historia de la custodia',40,false,100);
INSERT INTO FIELD (IDFORM, LABEL, IDCLASSEDITOR,REQUIERED,SORDER) VALUES (1,'Alcance y contenido',41,false,110);
INSERT INTO FIELD (IDFORM, LABEL, IDCLASSEDITOR,REQUIERED,SORDER) VALUES (1,'Organización',23,false,120);
INSERT INTO FIELD (IDFORM, LABEL, IDCLASSEDITOR,REQUIERED,SORDER) VALUES (1,'Recursos',24,false,130);
INSERT INTO FIELD (IDFORM, LABEL, IDCLASSEDITOR,REQUIERED,SORDER) VALUES (1,'Seguridad',25,false,140);
INSERT INTO FIELD (IDFORM, LABEL, IDCLASSEDITOR,REQUIERED,SORDER) VALUES (1,'Idioma',26,false,150);
INSERT INTO FIELD (IDFORM, LABEL, IDCLASSEDITOR,REQUIERED,SORDER) VALUES (1,'Instrumentos de descripción',42,false,170);
INSERT INTO FIELD (IDFORM, LABEL, IDCLASSEDITOR,REQUIERED,SORDER) VALUES (1,'Nota general',30,false,190);
INSERT INTO FIELD (IDFORM, LABEL, IDCLASSEDITOR,REQUIERED,SORDER) VALUES (1,'Centro/Autor descriptor original',43,false,200);
INSERT INTO FIELD (IDFORM, LABEL, IDCLASSEDITOR,REQUIERED,SORDER) VALUES (1,'Fuente (reglas, normas...) de la descripción',44,false,210);
INSERT INTO FIELD (IDFORM, LABEL, IDCLASSEDITOR,REQUIERED,SORDER) VALUES (1,'Signatura',6,false,10);
INSERT INTO FIELD (IDFORM, LABEL, IDCLASSEDITOR,REQUIERED,SORDER) VALUES (1,'Valoración / eliminación',45,false,230);
INSERT INTO FIELD (IDFORM, LABEL, IDCLASSEDITOR,REQUIERED,SORDER) VALUES (1,'Entrada',46,false,240);
INSERT INTO FIELD (IDFORM, LABEL, IDCLASSEDITOR,REQUIERED,SORDER) VALUES (1,'Localización',28,false,160);
INSERT INTO FIELD (IDFORM, LABEL, IDCLASSEDITOR,REQUIERED,SORDER) VALUES (1,'Adquisiciones',20,false,90);
INSERT INTO FIELD (IDFORM, LABEL, IDCLASSEDITOR,REQUIERED,SORDER) VALUES (1,'Productor',17,false,70);
INSERT INTO FIELD (IDFORM, LABEL, IDCLASSEDITOR,REQUIERED,SORDER) VALUES (1,'Comprobado',33,false,220);
INSERT INTO FIELD (IDFORM, LABEL, IDCLASSEDITOR,REQUIERED,SORDER) VALUES (1,'Autoridades',34,false,250);
INSERT INTO FIELD (IDFORM, LABEL, IDCLASSEDITOR,REQUIERED,SORDER) VALUES (1,'Material relacionado',29,false,180);
INSERT INTO FIELD (IDFORM, LABEL, IDCLASSEDITOR,REQUIERED,SORDER) VALUES (1,'Fecha(s) de producción',12,false,30);
INSERT INTO FIELD (IDFORM, LABEL, IDCLASSEDITOR,REQUIERED,SORDER) VALUES (1,'Descripción',999,false,1);
INSERT INTO FIELD (IDFORM, LABEL, IDCLASSEDITOR,REQUIERED,SORDER) VALUES (1,'Identificación',999,false,5);
INSERT INTO FIELD (IDFORM, LABEL, IDCLASSEDITOR,REQUIERED,SORDER) VALUES (1,'Medio físico',999,false,43);
INSERT INTO FIELD (IDFORM, LABEL, IDCLASSEDITOR,REQUIERED,SORDER) VALUES (1,'Puntos de acceso',999,false,245);
INSERT INTO FIELD (IDFORM, LABEL, IDCLASSEDITOR,REQUIERED,SORDER) VALUES (1,'Notas y control',999,false,185);
INSERT INTO FIELD (IDFORM, LABEL, IDCLASSEDITOR,REQUIERED,SORDER) VALUES (1,'Contenido',999,false,105);
INSERT INTO FIELD (IDFORM, LABEL, IDCLASSEDITOR,REQUIERED,SORDER) VALUES (1,'Acceso y uso',999,false,135);
INSERT INTO FIELD (IDFORM, LABEL, IDCLASSEDITOR,REQUIERED,SORDER) VALUES (1,'Contexto',999,false,65);


/*Serie*/
INSERT INTO FORM (IDFORM, TITLE, DESCRIPTION, TYPE, SORDER) VALUES(2, 'Descripción de una Serie', 'Formulario creado para describir Series', 'D', 2);
INSERT INTO FIELD (IDFORM, LABEL, IDCLASSEDITOR,REQUIERED,SORDER) VALUES (2,'Tipo de documento',2,false,5);
INSERT INTO FIELD (IDFORM, LABEL, IDCLASSEDITOR,REQUIERED,SORDER) VALUES (2,'Nivel de Descripción',1,false,7);
INSERT INTO FIELD (IDFORM, LABEL, IDCLASSEDITOR,REQUIERED,SORDER) VALUES (2,'Nivel Superior',3,false,9);
INSERT INTO FIELD (IDFORM, LABEL, IDCLASSEDITOR,REQUIERED,SORDER) VALUES (2,'Título',9,false,20);
INSERT INTO FIELD (IDFORM, LABEL, IDCLASSEDITOR,REQUIERED,SORDER) VALUES (2,'Publicación / Bibliografía',35,false,40);
INSERT INTO FIELD (IDFORM, LABEL, IDCLASSEDITOR,REQUIERED,SORDER) VALUES (2,'Volumen',36,false,45);
INSERT INTO FIELD (IDFORM, LABEL, IDCLASSEDITOR,REQUIERED,SORDER) VALUES (2,'Estado de conservación',37,false,50);
INSERT INTO FIELD (IDFORM, LABEL, IDCLASSEDITOR,REQUIERED,SORDER,INITEDITOR) VALUES (2,'Características externas',38,false,60,'{"userListId": 2}');
INSERT INTO FIELD (IDFORM, LABEL, IDCLASSEDITOR,REQUIERED,SORDER) VALUES (2,'Historia institucional / Biografía',39,false,80);
INSERT INTO FIELD (IDFORM, LABEL, IDCLASSEDITOR,REQUIERED,SORDER) VALUES (2,'Historia de la custodia',40,false,100);
INSERT INTO FIELD (IDFORM, LABEL, IDCLASSEDITOR,REQUIERED,SORDER) VALUES (2,'Alcance y contenido',41,false,110);
INSERT INTO FIELD (IDFORM, LABEL, IDCLASSEDITOR,REQUIERED,SORDER) VALUES (2,'Organización',23,false,120);
INSERT INTO FIELD (IDFORM, LABEL, IDCLASSEDITOR,REQUIERED,SORDER) VALUES (2,'Recursos',24,false,130);
INSERT INTO FIELD (IDFORM, LABEL, IDCLASSEDITOR,REQUIERED,SORDER) VALUES (2,'Seguridad',25,false,140);
INSERT INTO FIELD (IDFORM, LABEL, IDCLASSEDITOR,REQUIERED,SORDER) VALUES (2,'Idioma',26,false,150);
INSERT INTO FIELD (IDFORM, LABEL, IDCLASSEDITOR,REQUIERED,SORDER) VALUES (2,'Instrumentos de descripción',42,false,170);
INSERT INTO FIELD (IDFORM, LABEL, IDCLASSEDITOR,REQUIERED,SORDER) VALUES (2,'Nota general',30,false,190);
INSERT INTO FIELD (IDFORM, LABEL, IDCLASSEDITOR,REQUIERED,SORDER) VALUES (2,'Centro/Autor descriptor original',43,false,200);
INSERT INTO FIELD (IDFORM, LABEL, IDCLASSEDITOR,REQUIERED,SORDER) VALUES (2,'Fuente (reglas, normas...) de la descripción',44,false,210);
INSERT INTO FIELD (IDFORM, LABEL, IDCLASSEDITOR,REQUIERED,SORDER) VALUES (2,'Signatura',6,false,10);
INSERT INTO FIELD (IDFORM, LABEL, IDCLASSEDITOR,REQUIERED,SORDER) VALUES (2,'Valoración / eliminación',45,false,230);
INSERT INTO FIELD (IDFORM, LABEL, IDCLASSEDITOR,REQUIERED,SORDER) VALUES (2,'Entrada',46,false,240);
INSERT INTO FIELD (IDFORM, LABEL, IDCLASSEDITOR,REQUIERED,SORDER) VALUES (2,'Localización',28,false,160);
INSERT INTO FIELD (IDFORM, LABEL, IDCLASSEDITOR,REQUIERED,SORDER) VALUES (2,'Adquisiciones',20,false,90);
INSERT INTO FIELD (IDFORM, LABEL, IDCLASSEDITOR,REQUIERED,SORDER) VALUES (2,'Productor',17,false,70);
INSERT INTO FIELD (IDFORM, LABEL, IDCLASSEDITOR,REQUIERED,SORDER) VALUES (2,'Comprobado',33,false,220);
INSERT INTO FIELD (IDFORM, LABEL, IDCLASSEDITOR,REQUIERED,SORDER) VALUES (2,'Autoridades',34,false,250);
INSERT INTO FIELD (IDFORM, LABEL, IDCLASSEDITOR,REQUIERED,SORDER) VALUES (2,'Material relacionado',29,false,180);
INSERT INTO FIELD (IDFORM, LABEL, IDCLASSEDITOR,REQUIERED,SORDER) VALUES (2,'Fecha(s) de producción',12,false,30);

INSERT INTO FIELD (IDFORM, LABEL, IDCLASSEDITOR,REQUIERED,SORDER) VALUES (2,'Descripción',999,false,1);
INSERT INTO FIELD (IDFORM, LABEL, IDCLASSEDITOR,REQUIERED,SORDER) VALUES (2,'Identificación',999,false,5);
INSERT INTO FIELD (IDFORM, LABEL, IDCLASSEDITOR,REQUIERED,SORDER) VALUES (2,'Medio físico',999,false,43);
INSERT INTO FIELD (IDFORM, LABEL, IDCLASSEDITOR,REQUIERED,SORDER) VALUES (2,'Puntos de acceso',999,false,245);
INSERT INTO FIELD (IDFORM, LABEL, IDCLASSEDITOR,REQUIERED,SORDER) VALUES (2,'Notas y control',999,false,185);
INSERT INTO FIELD (IDFORM, LABEL, IDCLASSEDITOR,REQUIERED,SORDER) VALUES (2,'Contenido',999,false,105);
INSERT INTO FIELD (IDFORM, LABEL, IDCLASSEDITOR,REQUIERED,SORDER) VALUES (2,'Acceso y uso',999,false,135);
INSERT INTO FIELD (IDFORM, LABEL, IDCLASSEDITOR,REQUIERED,SORDER) VALUES (2,'Contexto',999,false,65);


/*Expediente*/
INSERT INTO FORM (IDFORM, TITLE, DESCRIPTION, TYPE, SORDER) VALUES(3, 'Descripción de un Expediente', 'Formulario creado para describir expedientes', 'D', 1);
INSERT INTO FIELD (IDFORM, LABEL, IDCLASSEDITOR,REQUIERED,SORDER) VALUES (3,'Tipo de documento',2,false,5);
INSERT INTO FIELD (IDFORM, LABEL, IDCLASSEDITOR,REQUIERED,SORDER) VALUES (3,'Nivel de Descripción',1,false,7);
INSERT INTO FIELD (IDFORM, LABEL, IDCLASSEDITOR,REQUIERED,SORDER) VALUES (3,'Nivel Superior',3,false,9);
INSERT INTO FIELD (IDFORM, LABEL, IDCLASSEDITOR,REQUIERED,SORDER) VALUES (3,'Estado de conservación',37,false,60);
INSERT INTO FIELD (IDFORM, LABEL, IDCLASSEDITOR,REQUIERED,SORDER,INITEDITOR) VALUES (3,'Características externas',38,false,70,'{"userListId": 2}');
INSERT INTO FIELD (IDFORM, LABEL, IDCLASSEDITOR,REQUIERED,SORDER) VALUES (3,'Alcance y contenido',41,false,100);
INSERT INTO FIELD (IDFORM, LABEL, IDCLASSEDITOR,REQUIERED,SORDER) VALUES (3,'Idioma',26,false,120);
INSERT INTO FIELD (IDFORM, LABEL, IDCLASSEDITOR,REQUIERED,SORDER) VALUES (3,'Nota general',30,false,150);
INSERT INTO FIELD (IDFORM, LABEL, IDCLASSEDITOR,REQUIERED,SORDER) VALUES (3,'Centro/Autor descriptor original',43,false,160);
INSERT INTO FIELD (IDFORM, LABEL, IDCLASSEDITOR,REQUIERED,SORDER) VALUES (3,'Signatura antigua',47,false,20);
INSERT INTO FIELD (IDFORM, LABEL, IDCLASSEDITOR,REQUIERED,SORDER) VALUES (3,'Signatura',7,false,10);
INSERT INTO FIELD (IDFORM, LABEL, IDCLASSEDITOR,REQUIERED,SORDER) VALUES (3,'Dimensiones',14,false,50);
INSERT INTO FIELD (IDFORM, LABEL, IDCLASSEDITOR,REQUIERED,SORDER) VALUES (3,'Descripción diplomática',48,false,110);
INSERT INTO FIELD (IDFORM, LABEL, IDCLASSEDITOR,REQUIERED,SORDER) VALUES (3,'Recursos',24,false,112);
INSERT INTO FIELD (IDFORM, LABEL, IDCLASSEDITOR,REQUIERED,SORDER) VALUES (3,'Título',10,false,30);
INSERT INTO FIELD (IDFORM, LABEL, IDCLASSEDITOR,REQUIERED,SORDER) VALUES (3,'Productor',17,false,80);
INSERT INTO FIELD (IDFORM, LABEL, IDCLASSEDITOR,REQUIERED,SORDER) VALUES (3,'Localización',28,false,130);
INSERT INTO FIELD (IDFORM, LABEL, IDCLASSEDITOR,REQUIERED,SORDER) VALUES (3,'Comprobado',33,false,170);
INSERT INTO FIELD (IDFORM, LABEL, IDCLASSEDITOR,REQUIERED,SORDER) VALUES (3,'Autoridades',34,false,180);
INSERT INTO FIELD (IDFORM, LABEL, IDCLASSEDITOR,REQUIERED,SORDER) VALUES (3,'Fecha(s) de producción',12,false,40);
INSERT INTO FIELD (IDFORM, LABEL, IDCLASSEDITOR,REQUIERED,SORDER) VALUES (3,'Material relacionado',29,false,140);

INSERT INTO FIELD (IDFORM, LABEL, IDCLASSEDITOR,REQUIERED,SORDER) VALUES (3,'Descripción',999,false,1);
INSERT INTO FIELD (IDFORM, LABEL, IDCLASSEDITOR,REQUIERED,SORDER) VALUES (3,'Identificación',999,false,5);
INSERT INTO FIELD (IDFORM, LABEL, IDCLASSEDITOR,REQUIERED,SORDER) VALUES (3,'Medio físico',999,false,45);
INSERT INTO FIELD (IDFORM, LABEL, IDCLASSEDITOR,REQUIERED,SORDER) VALUES (3,'Contexto',999,false,75);
INSERT INTO FIELD (IDFORM, LABEL, IDCLASSEDITOR,REQUIERED,SORDER) VALUES (3,'Contenido',999,false,95);
INSERT INTO FIELD (IDFORM, LABEL, IDCLASSEDITOR,REQUIERED,SORDER) VALUES (3,'Acceso y uso',999,false,115);
INSERT INTO FIELD (IDFORM, LABEL, IDCLASSEDITOR,REQUIERED,SORDER) VALUES (3,'Notas y control',999,false,145);
INSERT INTO FIELD (IDFORM, LABEL, IDCLASSEDITOR,REQUIERED,SORDER) VALUES (3,'Puntos de acceso',999,false,175);


/*Documento*/
INSERT INTO FORM (IDFORM, TITLE, DESCRIPTION, TYPE, SORDER) VALUES(4, 'Descripción de un Documento', 'Formulario creado para describir documentos', 'D', 4);
INSERT INTO FIELD (IDFORM, LABEL, IDCLASSEDITOR,REQUIERED,SORDER) VALUES (4,'Tipo de documento',2,false,5);
INSERT INTO FIELD (IDFORM, LABEL, IDCLASSEDITOR,REQUIERED,SORDER) VALUES (4,'Nivel de Descripción',1,false,7);
INSERT INTO FIELD (IDFORM, LABEL, IDCLASSEDITOR,REQUIERED,SORDER) VALUES (4,'Nivel Superior',3,false,9);
INSERT INTO FIELD (IDFORM, LABEL, IDCLASSEDITOR,REQUIERED,SORDER) VALUES (4,'Signatura',7,false,10);
INSERT INTO FIELD (IDFORM, LABEL, IDCLASSEDITOR,REQUIERED,SORDER) VALUES (4,'Signatura antigua',47,false,20);
INSERT INTO FIELD (IDFORM, LABEL, IDCLASSEDITOR,REQUIERED,SORDER) VALUES (4,'Dimensiones',14,false,50);
INSERT INTO FIELD (IDFORM, LABEL, IDCLASSEDITOR,REQUIERED,SORDER) VALUES (4,'Estado de conservación',37,false,60);
INSERT INTO FIELD (IDFORM, LABEL, IDCLASSEDITOR,REQUIERED,SORDER,INITEDITOR) VALUES (4,'Características externas',38,false,70,'{"userListId": 2}');
INSERT INTO FIELD (IDFORM, LABEL, IDCLASSEDITOR,REQUIERED,SORDER) VALUES (4,'Productor',17,false,80);
INSERT INTO FIELD (IDFORM, LABEL, IDCLASSEDITOR,REQUIERED,SORDER) VALUES (4,'Alcance y contenido',41,false,90);
INSERT INTO FIELD (IDFORM, LABEL, IDCLASSEDITOR,REQUIERED,SORDER) VALUES (4,'Descripción diplomática',48,false,100);
INSERT INTO FIELD (IDFORM, LABEL, IDCLASSEDITOR,REQUIERED,SORDER) VALUES (4,'Recursos',24,false,110);
INSERT INTO FIELD (IDFORM, LABEL, IDCLASSEDITOR,REQUIERED,SORDER) VALUES (4,'Idioma',26,false,120);
INSERT INTO FIELD (IDFORM, LABEL, IDCLASSEDITOR,REQUIERED,SORDER) VALUES (4,'Nota general',30,false,150);
INSERT INTO FIELD (IDFORM, LABEL, IDCLASSEDITOR,REQUIERED,SORDER) VALUES (4,'Centro/Autor descriptor original',43,false,160);
INSERT INTO FIELD (IDFORM, LABEL, IDCLASSEDITOR,REQUIERED,SORDER) VALUES (4,'Comprobado',33,false,170);
INSERT INTO FIELD (IDFORM, LABEL, IDCLASSEDITOR,REQUIERED,SORDER) VALUES (4,'Autoridades',34,false,180);
INSERT INTO FIELD (IDFORM, LABEL, IDCLASSEDITOR,REQUIERED,SORDER) VALUES (4,'Localización',28,false,130);
INSERT INTO FIELD (IDFORM, LABEL, IDCLASSEDITOR,REQUIERED,SORDER) VALUES (4,'Título',11,false,30);
INSERT INTO FIELD (IDFORM, LABEL, IDCLASSEDITOR,REQUIERED,SORDER) VALUES (4,'Fecha(s) de producción',13,false,40);
INSERT INTO FIELD (IDFORM, LABEL, IDCLASSEDITOR,REQUIERED,SORDER) VALUES (4,'Material relacionado',29,false,140);

INSERT INTO FIELD (IDFORM, LABEL, IDCLASSEDITOR,REQUIERED,SORDER) VALUES (4,'Descripción',999,false,1);
INSERT INTO FIELD (IDFORM, LABEL, IDCLASSEDITOR,REQUIERED,SORDER) VALUES (4,'Identificación',999,false,5);
INSERT INTO FIELD (IDFORM, LABEL, IDCLASSEDITOR,REQUIERED,SORDER) VALUES (4,'Medio físico',999,false,45);
INSERT INTO FIELD (IDFORM, LABEL, IDCLASSEDITOR,REQUIERED,SORDER) VALUES (4,'Contexto',999,false,75);
INSERT INTO FIELD (IDFORM, LABEL, IDCLASSEDITOR,REQUIERED,SORDER) VALUES (4,'Contenido',999,false,85);
INSERT INTO FIELD (IDFORM, LABEL, IDCLASSEDITOR,REQUIERED,SORDER) VALUES (4,'Acceso y uso',999,false,115);
INSERT INTO FIELD (IDFORM, LABEL, IDCLASSEDITOR,REQUIERED,SORDER) VALUES (4,'Notas y control',999,false,145);
INSERT INTO FIELD (IDFORM, LABEL, IDCLASSEDITOR,REQUIERED,SORDER) VALUES (4,'Puntos de acceso',999,false,175);


INSERT INTO USERLIST      (IDUSERLIST, KEY, DESCRIPTION)   VALUES (1000, 'borrows.priority', 'Prioridad de los prestamos');
INSERT INTO USERLISTVALUE (IDUSERLIST, USERKEY, USERVALUE) VALUES (1000,'Ordinario', 'Préstamo con prioridad ordinaria');
INSERT INTO USERLISTVALUE (IDUSERLIST, USERKEY, USERVALUE) VALUES (1000,'Urgente', 'Préstamo con prioridad urgente');

INSERT INTO USERLIST (KEY, DESCRIPTION) VALUES ('opac.licenseTermsExplanation', 'Explicación didáctica de la licencia de uso');

INSERT INTO USERLIST (KEY, DESCRIPTION) VALUES ('thumbnails.externalRepositories', 'Miniaturas repositorios externos');

/*
 *********************************************
 * source: nuba-authorities.07.insert.sql
 *                                           *
 *      This is an auto generated file.      *
 *     !!!!! DO NOT EDIT DIRECTLY. !!!!!     *
 *                                           *
 *********************************************
 */

-- Editores --
INSERT INTO CLASSEDITOR (IDCLASSEDITOR, CLASSNAME) VALUES(801,'org.nubarchiva.authorities.web.descriptions.editors.ParallelFormsOfNameEditor');

-- Personas --
INSERT INTO FORM (IDFORM, TITLE, DESCRIPTION, TYPE, SUBTYPE, SORDER) VALUES(5, 'Autoridad de tipo Persona', 'Formulario creado para describir autoridades de tipo persona', 'A', 'PN', 1);
INSERT INTO FIELD (IDFORM,LABEL,IDCLASSEDITOR,REQUIERED,EDITABLE,VISIBLE,DEFAULTVALUE,SORDER,INITEDITOR) values (5, '1. Área de identificación'  , 999, false, true, true, null,  10, null);
INSERT INTO FIELD (IDFORM,LABEL,IDCLASSEDITOR,REQUIERED,EDITABLE,VISIBLE,DEFAULTVALUE,SORDER,INITEDITOR) values (5, 'Forma autorizada'           ,  83, true , true, true, null,  20, '{"initFields": {"modelMarcfield" : "100","modelMarcSubfield": "a"}}');
INSERT INTO FIELD (IDFORM,LABEL,IDCLASSEDITOR,REQUIERED,EDITABLE,VISIBLE,DEFAULTVALUE,SORDER,INITEDITOR) values (5, 'Otras formas del nombre'    , 801, false, true, true, null,  30, null);
INSERT INTO FIELD (IDFORM,LABEL,IDCLASSEDITOR,REQUIERED,EDITABLE,VISIBLE,DEFAULTVALUE,SORDER,INITEDITOR) values (5, '2. Área de descripción'     , 999, false, true, true, null, 100, null);
INSERT INTO FIELD (IDFORM,LABEL,IDCLASSEDITOR,REQUIERED,EDITABLE,VISIBLE,DEFAULTVALUE,SORDER,INITEDITOR) values (5, 'Fecha de nacimiento'        ,  83, false, true, true, null, 110, '{"initFields": {"modelMarcfield" : "046","modelMarcSubfield": "f"},"sizeTextField":{"size":10, "maxLength":10}}');
INSERT INTO FIELD (IDFORM,LABEL,IDCLASSEDITOR,REQUIERED,EDITABLE,VISIBLE,DEFAULTVALUE,SORDER,INITEDITOR) values (5, 'Fecha de fallecimiento'     ,  83, false, true, true, null, 120, '{"initFields": {"modelMarcfield" : "046","modelMarcSubfield": "g"},"sizeTextField":{"size":10, "maxLength":10}}');
INSERT INTO FIELD (IDFORM,LABEL,IDCLASSEDITOR,REQUIERED,EDITABLE,VISIBLE,DEFAULTVALUE,SORDER,INITEDITOR) values (5, 'Actividad'                  ,  83, false, true, true, null, 130, '{"initFields": {"modelMarcfield" : "374","modelMarcSubfield": "a"}}');
INSERT INTO FIELD (IDFORM,LABEL,IDCLASSEDITOR,REQUIERED,EDITABLE,VISIBLE,DEFAULTVALUE,SORDER,INITEDITOR) values (5, 'Fecha de comienzo actividad',  83, false, true, true, null, 150, '{"initFields": {"modelMarcfield" : "374","modelMarcSubfield": "s"},"sizeTextField":{"size":10, "maxLength":10}}');
INSERT INTO FIELD (IDFORM,LABEL,IDCLASSEDITOR,REQUIERED,EDITABLE,VISIBLE,DEFAULTVALUE,SORDER,INITEDITOR) values (5, 'Fecha de fin actividad'     ,  83, false, true, true, null, 150, '{"initFields": {"modelMarcfield" : "374","modelMarcSubfield": "t"},"sizeTextField":{"size":10, "maxLength":10}}');
INSERT INTO FIELD (IDFORM,LABEL,IDCLASSEDITOR,REQUIERED,EDITABLE,VISIBLE,DEFAULTVALUE,SORDER,INITEDITOR) values (5, 'Datos históricos'           ,  84, false, true, true, null, 160, '{"initFields": {"modelMarcfield" : "678","modelMarcSubfield": "a"}}');
INSERT INTO FIELD (IDFORM,LABEL,IDCLASSEDITOR,REQUIERED,EDITABLE,VISIBLE,DEFAULTVALUE,SORDER,INITEDITOR) values (5, '3. Área de control'         , 999, false, true, true, null, 200, null);
INSERT INTO FIELD (IDFORM,LABEL,IDCLASSEDITOR,REQUIERED,EDITABLE,VISIBLE,DEFAULTVALUE,SORDER,INITEDITOR) values (5, 'Identificador del registro' ,  83, false, true, true, null, 210, '{"initFields": {"modelMarcfield" : "090","modelMarcSubfield": "a"},"sizeTextField":{"size":20, "maxLength":20}}');
INSERT INTO FIELD (IDFORM,LABEL,IDCLASSEDITOR,REQUIERED,EDITABLE,VISIBLE,DEFAULTVALUE,SORDER,INITEDITOR) values (5, 'Notas de mantenimiento'     ,  84, false, true, true, null, 220, '{"initFields": {"modelMarcfield" : "667","modelMarcSubfield": "a"}}');

-- Institución --
INSERT INTO FORM (IDFORM, TITLE, DESCRIPTION, TYPE, SUBTYPE, SORDER) VALUES(6, 'Autoridad de tipo Institución', 'Formulario creado para describir autoridades de tipo institución', 'A', 'I', 2);
INSERT INTO FIELD (IDFORM,LABEL,IDCLASSEDITOR,REQUIERED,EDITABLE,VISIBLE,DEFAULTVALUE,SORDER,INITEDITOR) values (6, '1. Área de identificación'  , 999, false, true, true, null,  10, null);
INSERT INTO FIELD (IDFORM,LABEL,IDCLASSEDITOR,REQUIERED,EDITABLE,VISIBLE,DEFAULTVALUE,SORDER,INITEDITOR) values (6, 'Forma autorizada'           ,  83, true , true, true, null,  20, '{"initFields": {"modelMarcfield" : "110","modelMarcSubfield": "a"}}');
INSERT INTO FIELD (IDFORM,LABEL,IDCLASSEDITOR,REQUIERED,EDITABLE,VISIBLE,DEFAULTVALUE,SORDER,INITEDITOR) values (6, 'Otras formas del nombre'    , 801, false, true, true, null,  30, null);
INSERT INTO FIELD (IDFORM,LABEL,IDCLASSEDITOR,REQUIERED,EDITABLE,VISIBLE,DEFAULTVALUE,SORDER,INITEDITOR) values (6, '2. Área de descripción'     , 999, false, true, true, null, 100, null);
INSERT INTO FIELD (IDFORM,LABEL,IDCLASSEDITOR,REQUIERED,EDITABLE,VISIBLE,DEFAULTVALUE,SORDER,INITEDITOR) values (6, 'Fecha inicial periodo'      ,  83, false, true, true, null, 110, '{"initFields": {"modelMarcfield" : "046","modelMarcSubfield": "s"},"sizeTextField":{"size":10, "maxLength":10}}');
INSERT INTO FIELD (IDFORM,LABEL,IDCLASSEDITOR,REQUIERED,EDITABLE,VISIBLE,DEFAULTVALUE,SORDER,INITEDITOR) values (6, 'Fecha final periodo'        ,  83, false, true, true, null, 120, '{"initFields": {"modelMarcfield" : "046","modelMarcSubfield": "t"},"sizeTextField":{"size":10, "maxLength":10}}');
INSERT INTO FIELD (IDFORM,LABEL,IDCLASSEDITOR,REQUIERED,EDITABLE,VISIBLE,DEFAULTVALUE,SORDER,INITEDITOR) values (6, 'Datos históricos'           ,  84, false, true, true, null, 140, '{"initFields": {"modelMarcfield" : "678","modelMarcSubfield": "a"}}');
INSERT INTO FIELD (IDFORM,LABEL,IDCLASSEDITOR,REQUIERED,EDITABLE,VISIBLE,DEFAULTVALUE,SORDER,INITEDITOR) values (6, '3. Área de control'         , 999, false, true, true, null, 200, null);
INSERT INTO FIELD (IDFORM,LABEL,IDCLASSEDITOR,REQUIERED,EDITABLE,VISIBLE,DEFAULTVALUE,SORDER,INITEDITOR) values (6, 'Identificador del registro' ,  83, false, true, true, null, 210, '{"initFields": {"modelMarcfield" : "090","modelMarcSubfield": "a"},"sizeTextField":{"size":20, "maxLength":20}}');
INSERT INTO FIELD (IDFORM,LABEL,IDCLASSEDITOR,REQUIERED,EDITABLE,VISIBLE,DEFAULTVALUE,SORDER,INITEDITOR) values (6, 'Notas de mantenimiento'     ,  84, false, true, true, null, 220, '{"initFields": {"modelMarcfield" : "667","modelMarcSubfield": "a"}}');

-- Lugares --
INSERT INTO FORM (IDFORM, TITLE, DESCRIPTION, TYPE, SUBTYPE, SORDER) VALUES(7, 'Autoridad de tipo Lugar Geográfico', 'Formulario creado para describir autoridades de tipo lugar geográfico', 'A', 'P', 3);
INSERT INTO FIELD (IDFORM,LABEL,IDCLASSEDITOR,REQUIERED,EDITABLE,VISIBLE,DEFAULTVALUE,SORDER,INITEDITOR) values (7, '1. Área de identificación'  , 999, false, true, true, null,  10, null);
INSERT INTO FIELD (IDFORM,LABEL,IDCLASSEDITOR,REQUIERED,EDITABLE,VISIBLE,DEFAULTVALUE,SORDER,INITEDITOR) values (7, 'Forma autorizada'           ,  83, true , true, true, null,  20, '{"initFields": {"modelMarcfield" : "151","modelMarcSubfield": "a"}}');
INSERT INTO FIELD (IDFORM,LABEL,IDCLASSEDITOR,REQUIERED,EDITABLE,VISIBLE,DEFAULTVALUE,SORDER,INITEDITOR) values (7, 'Otras formas del nombre'    , 801, false, true, true, null,  30, null);
INSERT INTO FIELD (IDFORM,LABEL,IDCLASSEDITOR,REQUIERED,EDITABLE,VISIBLE,DEFAULTVALUE,SORDER,INITEDITOR) values (7, '3. Área de control'         , 999, false, true, true, null, 200, null);
INSERT INTO FIELD (IDFORM,LABEL,IDCLASSEDITOR,REQUIERED,EDITABLE,VISIBLE,DEFAULTVALUE,SORDER,INITEDITOR) values (7, 'Identificador del registro' ,  83, false, true, true, null, 210, '{"initFields": {"modelMarcfield" : "090","modelMarcSubfield": "t"},"sizeTextField":{"size":20, "maxLength":20}}');
INSERT INTO FIELD (IDFORM,LABEL,IDCLASSEDITOR,REQUIERED,EDITABLE,VISIBLE,DEFAULTVALUE,SORDER,INITEDITOR) values (7, 'Notas de mantenimiento'     ,  84, false, true, true, null, 220, '{"initFields": {"modelMarcfield" : "667","modelMarcSubfield": "a"}}');

-- Descriptor --
INSERT INTO FORM (IDFORM, TITLE, DESCRIPTION, TYPE, SUBTYPE, SORDER) VALUES(8, 'Autoridad de tipo Descriptor', 'Formulario creado para describir autoridades de tipo descriptor', 'A', 'D', 4);
INSERT INTO FIELD (IDFORM,LABEL,IDCLASSEDITOR,REQUIERED,EDITABLE,VISIBLE,DEFAULTVALUE,SORDER,INITEDITOR) values (8, '1. Área de identificación'  , 999, false, true, true, null,  10, null);
INSERT INTO FIELD (IDFORM,LABEL,IDCLASSEDITOR,REQUIERED,EDITABLE,VISIBLE,DEFAULTVALUE,SORDER,INITEDITOR) values (8, 'Forma autorizada'           ,  83, true , true, true, null,  20, '{"initFields": {"modelMarcfield" : "150","modelMarcSubfield": "a"}}');
INSERT INTO FIELD (IDFORM,LABEL,IDCLASSEDITOR,REQUIERED,EDITABLE,VISIBLE,DEFAULTVALUE,SORDER,INITEDITOR) values (8, 'Otras formas del nombre'    , 801, false, true, true, null,  30, null);
INSERT INTO FIELD (IDFORM,LABEL,IDCLASSEDITOR,REQUIERED,EDITABLE,VISIBLE,DEFAULTVALUE,SORDER,INITEDITOR) values (8, '3. Área de control'         , 999, false, true, true, null, 200, null);
INSERT INTO FIELD (IDFORM,LABEL,IDCLASSEDITOR,REQUIERED,EDITABLE,VISIBLE,DEFAULTVALUE,SORDER,INITEDITOR) values (8, 'Identificador del registro' ,  83, false, true, true, null, 210, '{"initFields": {"modelMarcfield" : "090","modelMarcSubfield": "t"},"sizeTextField":{"size":20, "maxLength":20}}');
INSERT INTO FIELD (IDFORM,LABEL,IDCLASSEDITOR,REQUIERED,EDITABLE,VISIBLE,DEFAULTVALUE,SORDER,INITEDITOR) values (8, 'Notas de mantenimiento'     ,  84, false, true, true, null, 220, '{"initFields": {"modelMarcfield" : "667","modelMarcSubfield": "a"}}');

-- Congresos --
INSERT INTO FORM (IDFORM, TITLE, DESCRIPTION, TYPE, SUBTYPE, SORDER) VALUES(9, 'Autoridad de tipo Congreso', 'Formulario creado para describir autoridades de tipo congreso', 'A', 'M', 5);
INSERT INTO FIELD (IDFORM,LABEL,IDCLASSEDITOR,REQUIERED,EDITABLE,VISIBLE,DEFAULTVALUE,SORDER,INITEDITOR) values (9,'1. Área de identificación'   , 999, false, true, true, null,  10, null);
INSERT INTO FIELD (IDFORM,LABEL,IDCLASSEDITOR,REQUIERED,EDITABLE,VISIBLE,DEFAULTVALUE,SORDER,INITEDITOR) values (9,'Forma autorizada'            ,  83, true , true, true, null,  20, '{"initFields": {"modelMarcfield" : "111","modelMarcSubfield": "a"}}');
INSERT INTO FIELD (IDFORM,LABEL,IDCLASSEDITOR,REQUIERED,EDITABLE,VISIBLE,DEFAULTVALUE,SORDER,INITEDITOR) values (9, 'Otras formas del nombre'    , 801, false, true, true, null,  30, null);
INSERT INTO FIELD (IDFORM,LABEL,IDCLASSEDITOR,REQUIERED,EDITABLE,VISIBLE,DEFAULTVALUE,SORDER,INITEDITOR) values (9,'2. Área de descripción'      , 999, false, true, true, null, 100, null);
INSERT INTO FIELD (IDFORM,LABEL,IDCLASSEDITOR,REQUIERED,EDITABLE,VISIBLE,DEFAULTVALUE,SORDER,INITEDITOR) values (9,'Fecha inicial periodo'       ,  83, false, true, true, null, 110, '{"initFields": {"modelMarcfield" : "046","modelMarcSubfield": "s"},"sizeTextField":{"size":10, "maxLength":10}}');
INSERT INTO FIELD (IDFORM,LABEL,IDCLASSEDITOR,REQUIERED,EDITABLE,VISIBLE,DEFAULTVALUE,SORDER,INITEDITOR) values (9,'Fecha final periodo'         ,  83, false, true, true, null, 120, '{"initFields": {"modelMarcfield" : "046","modelMarcSubfield": "t"},"sizeTextField":{"size":10, "maxLength":10}}');
INSERT INTO FIELD (IDFORM,LABEL,IDCLASSEDITOR,REQUIERED,EDITABLE,VISIBLE,DEFAULTVALUE,SORDER,INITEDITOR) values (9,'Datos históricos'            ,  84, false, true, true, null, 140, '{"initFields": {"modelMarcfield" : "678","modelMarcSubfield": "a"}}');
INSERT INTO FIELD (IDFORM,LABEL,IDCLASSEDITOR,REQUIERED,EDITABLE,VISIBLE,DEFAULTVALUE,SORDER,INITEDITOR) values (9,'3. Área de control'          , 999, false, true, true, null, 200, null);
INSERT INTO FIELD (IDFORM,LABEL,IDCLASSEDITOR,REQUIERED,EDITABLE,VISIBLE,DEFAULTVALUE,SORDER,INITEDITOR) values (9,'Identificador del registro'  ,  83, false, true, true, null, 210, '{"initFields": {"modelMarcfield" : "090","modelMarcSubfield": "a"},"sizeTextField":{"size":20, "maxLength":20}}');
INSERT INTO FIELD (IDFORM,LABEL,IDCLASSEDITOR,REQUIERED,EDITABLE,VISIBLE,DEFAULTVALUE,SORDER,INITEDITOR) values (9,'Notas de mantenimiento'      ,  84, false, true, true, null, 220, '{"initFields": {"modelMarcfield" : "667","modelMarcSubfield": "a"}}');
