Tony CHEMIT pushed to branch develop-7.x at ultreiaio / ird-observe Commits: 32ce9aff by tchemit at 2018-11-14T13:28:31Z Après insertion de #1170 - Closes #1171 - - - - - 1 changed file: - persistence/src/main/resources/db/migration/6.1/09_fill_object_material-common.sql Changes: ===================================== persistence/src/main/resources/db/migration/6.1/09_fill_object_material-common.sql ===================================== @@ -104,14 +104,14 @@ INSERT INTO observe_seine.objectmaterial (topiaid, topiaversion, topiacreatedate INSERT INTO observe_seine.objectmaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, code, legacycode, standardcode, parent, status, needcomment, uri, objectmaterialtype, biodegradable, nonentangling, label1, label2, label3, label4, label5, label6, label7, label8, childrenmultiselectable, childselectionmandatory, validation) VALUES ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.66',0,'2018-11-12','2018-11-12 17:27:06.06232','2-2-4-3',null,null,'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.63',1,false,null,'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0',false,true,'Inert plastic buoy','Bouée plastique inerte','Boya de plástico inerte',null,null,null,null,null,false,false,null); INSERT INTO observe_seine.objectmaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, code, legacycode, standardcode, parent, status, needcomment, uri, objectmaterialtype, biodegradable, nonentangling, label1, label2, label3, label4, label5, label6, label7, label8, childrenmultiselectable, childselectionmandatory, validation) VALUES ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.67',0,'2018-11-12','2018-11-12 17:27:06.06232','2-2-5',null,'HALOG','fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.59',1,false,null,'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0',false,false,'HALOG (not fishing ALOG)','HALOG (ALOG non pêche)','HALOG (HALOG no pesca)',null,null,null,null,null,true,false,null); INSERT INTO observe_seine.objectmaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, code, legacycode, standardcode, parent, status, needcomment, uri, objectmaterialtype, biodegradable, nonentangling, label1, label2, label3, label4, label5, label6, label7, label8, childrenmultiselectable, childselectionmandatory, validation) VALUES ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.68',0,'2018-11-12','2018-11-12 17:27:06.06232','4',null,null,'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#1.3',1,false,null,null,false,false,'Other properties','Autres propriétés','Otras propiedades',null,null,null,null,null,true,false,null); -INSERT INTO observe_seine.objectmaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, code, legacycode, standardcode, parent, status, needcomment, uri, objectmaterialtype, biodegradable, nonentangling, label1, label2, label3, label4, label5, label6, label7, label8, childrenmultiselectable, childselectionmandatory, validation) VALUES ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.69',1,'2018-11-12','2018-11-12 17:27:06.06232','4-1',null,null,'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.68',0,false,null,'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0',true,false,'Biodegradable','Matériaux','Materiales',null,null,null,null,null,false,false,null); +INSERT INTO observe_seine.objectmaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, code, legacycode, standardcode, parent, status, needcomment, uri, objectmaterialtype, biodegradable, nonentangling, label1, label2, label3, label4, label5, label6, label7, label8, childrenmultiselectable, childselectionmandatory, validation) VALUES ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.69',1,'2018-11-12','2018-11-12 17:27:06.06232','4-1',null,null,'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.68',0,false,null,'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0',true,false,'Biodegradable materials','Matériaux biodégradables','Materiales biodegradables',null,null,null,null,null,false,false,null); INSERT INTO observe_seine.objectmaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, code, legacycode, standardcode, parent, status, needcomment, uri, objectmaterialtype, biodegradable, nonentangling, label1, label2, label3, label4, label5, label6, label7, label8, childrenmultiselectable, childselectionmandatory, validation) VALUES ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.70',1,'2018-11-12','2018-11-12 17:27:06.06232','4-2','22*',null,'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.68',0,false,null,'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0',false,true,'Non entangling','Non maillant',null,null,null,null,null,null,false,false,null); INSERT INTO observe_seine.objectmaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, code, legacycode, standardcode, parent, status, needcomment, uri, objectmaterialtype, biodegradable, nonentangling, label1, label2, label3, label4, label5, label6, label7, label8, childrenmultiselectable, childselectionmandatory, validation) VALUES ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.71',1,'2018-11-12','2018-11-12 17:27:06.06232','4-3','23*',null,'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.68',0,false,null,'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0',false,false,'Entangling','Maillant','Enmallante',null,null,null,null,null,false,false,null); INSERT INTO observe_seine.objectmaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, code, legacycode, standardcode, parent, status, needcomment, uri, objectmaterialtype, biodegradable, nonentangling, label1, label2, label3, label4, label5, label6, label7, label8, childrenmultiselectable, childselectionmandatory, validation) VALUES ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.72',1,'2018-11-12','2018-11-12 17:27:06.06232','4-4',null,null,'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.68',1,false,null,'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#2',false,false,'subsurface depth','profondeur (partie immergée)','profundidad del rabo',null,null,null,null,null,false,false,'x >= 0 && x <= 100'); INSERT INTO observe_seine.objectmaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, code, legacycode, standardcode, parent, status, needcomment, uri, objectmaterialtype, biodegradable, nonentangling, label1, label2, label3, label4, label5, label6, label7, label8, childrenmultiselectable, childselectionmandatory, validation) VALUES ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.73',0,'2018-11-12','2018-11-12 17:27:06.06232','4-5',null,null,'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.68',1,false,null,'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#1',false,false,'Area (in m2)','Surface (en m2)','Superficie (en m2)',null,null,null,null,null,false,false,'x >= 0.5 && x <= 50'); INSERT INTO observe_seine.objectmaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, code, legacycode, standardcode, parent, status, needcomment, uri, objectmaterialtype, biodegradable, nonentangling, label1, label2, label3, label4, label5, label6, label7, label8, childrenmultiselectable, childselectionmandatory, validation) VALUES ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.74',1,'2018-11-12','2018-11-12 17:27:06.06232','4-6',null,null,'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.68',1,false,null,'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#2',false,false,'Size of largest mesh','Taille de la maille la plus grande (en mm)','Talla de la malla más grandes (en mm)',null,null,null,null,null,false,false,'x >= 5 && x <= 1000'); INSERT INTO observe_seine.objectmaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, code, legacycode, standardcode, parent, status, needcomment, uri, objectmaterialtype, biodegradable, nonentangling, label1, label2, label3, label4, label5, label6, label7, label8, childrenmultiselectable, childselectionmandatory, validation) VALUES ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.75',1,'2018-11-12','2018-11-12 17:27:06.06232','4-7',null,null,'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.68',1,false,null,'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#3',false,false,'FOB identifier','Identifiant du FOB','Identificador del FOB',null,null,null,null,null,false,false,'x.length() >= 3 && x.length() <= 64'); -INSERT INTO observe_seine.objectmaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, code, legacycode, standardcode, parent, status, needcomment, uri, objectmaterialtype, biodegradable, nonentangling, label1, label2, label3, label4, label5, label6, label7, label8, childrenmultiselectable, childselectionmandatory, validation) VALUES ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.76',1,'2018-11-12','2018-11-12 17:27:06.06232','4-8',null,null,'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.68',1,false,null,'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#2',false,false,'Number of FOBs tangled','Nombre de FOBs emmêlés','Numero de FOBs enmallados',null,null,null,null,null,false,false,'x >= 2 && x <= 100'); +INSERT INTO observe_seine.objectmaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, code, legacycode, standardcode, parent, status, needcomment, uri, objectmaterialtype, biodegradable, nonentangling, label1, label2, label3, label4, label5, label6, label7, label8, childrenmultiselectable, childselectionmandatory, validation) VALUES ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.76',1,'2018-11-12','2018-11-12 17:27:06.06232','4-8',null,null,'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.68',1,false,null,'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#2',false,false,'Number of FOBs entangled', 'Nombre de FOBs emmêlés','Numero de FOBs enmallados',null,null,null,null,null,false,false,'x >= 2 && x <= 100'); INSERT INTO observe_seine.objectmaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, code, legacycode, standardcode, parent, status, needcomment, uri, objectmaterialtype, biodegradable, nonentangling, label1, label2, label3, label4, label5, label6, label7, label8, childrenmultiselectable, childselectionmandatory, validation) VALUES ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.77',0,'2018-11-12','2018-11-12 17:27:06.06232','6',null,null,'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#1.3',0,false,null,null,false,false,'Legacy codes','Anciens codes','Códigos antiguos',null,null,null,null,null,true,false,null); INSERT INTO observe_seine.objectmaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, code, legacycode, standardcode, parent, status, needcomment, uri, objectmaterialtype, biodegradable, nonentangling, label1, label2, label3, label4, label5, label6, label7, label8, childrenmultiselectable, childselectionmandatory, validation) VALUES ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.78',0,'2018-11-12','2018-11-12 17:27:06.06232','6-1','99',null,'fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.77',0,false,null,'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0',false,false,'Other, unknown','Autre, inconnu','Otro, desconocido',null,null,null,null,null,false,false,null); INSERT INTO observe_seine.objectmaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, code, legacycode, standardcode, parent, status, needcomment, uri, objectmaterialtype, biodegradable, nonentangling, label1, label2, label3, label4, label5, label6, label7, label8, childrenmultiselectable, childselectionmandatory, validation) VALUES ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.79',0,'2018-11-12','2018-11-12 17:27:06.06232','6-2','14','ALOG','fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0.77',0,false,null,'fr.ird.observe.entities.referentiel.seine.ObjectMaterialType#0#0',false,false,'One of the previous (10, 11, 12, 13) tagged','Un des antérieurs (10, 11, 12, 13) balisé','Una de los anterior (10, 11, 12, 13) con Baliza',null,null,null,null,null,false,false,null); View it on GitLab: https://gitlab.com/ultreiaio/ird-observe/commit/32ce9affe75a56f8586d7e31d92d... -- View it on GitLab: https://gitlab.com/ultreiaio/ird-observe/commit/32ce9affe75a56f8586d7e31d92d... You're receiving this email because of your account on gitlab.com.