Tony CHEMIT pushed to branch develop-7.x at ultreiaio / ird-observe

Commits:

1 changed file:

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
    104 104 
     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);
    105 105 
     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);
    106 106 
     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);
    107 
    -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);
    107 
    +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);
    108 108 
     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);
    109 109 
     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);
    110 110 
     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');
    111 111 
     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');
    112 112 
     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');
    113 113 
     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');
    114 
    -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');
    114 
    +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');
    115 115 
     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);
    116 116 
     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);
    117 117 
     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.
    You're receiving this email because of your account on gitlab.com. If you'd like to receive fewer emails, you can adjust your notification settings.