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

Commits:

3 changed files:

Changes:

  • persistence/src/main/resources/db/migration/6.901/01_add_object_operation-common.sql → persistence/src/main/resources/db/migration/6.901/01_add_object_operation-H2.sql
    ... ... @@ -63,5 +63,8 @@ INSERT INTO observe_seine.objectOperation (topiaid, topiaversion, topiacreatedat
    63 63 
     UPDATE OBSERVE_COMMON.LASTUPDATEDATE SET  LASTUPDATEDATE = CURRENT_TIMESTAMP WHERE type = 'fr.ird.observe.entities.referentiel.seine.ObjectOperation';
    64 64
    65 65 
     ALTER TABLE observe_seine.floatingObject ALTER COLUMN objectOperation2 RENAME TO objectOperation;
    66 
    +
    67 
    +ALTER TABLE observe_seine.floatingObject RENAME objectOperation2 TO objectOperation;
    68 
    +
    66 69 
     ALTER TABLE observe_seine.floatingObject ADD CONSTRAINT fk_floatingobject_objectOperation FOREIGN KEY (objectOperation) REFERENCES observe_seine.objectOperation(topiaid);
    67 70

  • persistence/src/main/resources/db/migration/6.901/01_add_object_operation-PG.sql
    1 
    +---
    2 
    +-- #%L
    3 
    +-- ObServe :: Persistence
    4 
    +-- %%
    5 
    +-- Copyright (C) 2008 - 2017 IRD, Code Lutin, Ultreia.io
    6 
    +-- %%
    7 
    +-- This program is free software: you can redistribute it and/or modify
    8 
    +-- it under the terms of the GNU General Public License as
    9 
    +-- published by the Free Software Foundation, either version 3 of the
    10 
    +-- License, or (at your option) any later version.
    11 
    +--
    12 
    +-- This program is distributed in the hope that it will be useful,
    13 
    +-- but WITHOUT ANY WARRANTY; without even the implied warranty of
    14 
    +-- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
    15 
    +-- GNU General Public License for more details.
    16 
    +--
    17 
    +-- You should have received a copy of the GNU General Public
    18 
    +-- License along with this program.  If not, see
    19 
    +-- <http://www.gnu.org/licenses/gpl-3.0.html>.
    20 
    +-- #L%
    21 
    +---
    22 
    +ALTER TABLE observe_seine.floatingObject ADD COLUMN objectOperation2 CHARACTER VARYING (256);
    23 
    +
    24 
    +UPDATE observe_seine.floatingObject set objectOperation2 = 'fr.ird.observe.entities.referentiel.seine.ObjectOperation#0#1'  WHERE objectOperation = 'fr.ird.observe.entities.referentiel.seine.ObjectOperation#1239832686248#0.8669327599318251';
    25 
    +
    26 
    +UPDATE observe_seine.floatingObject set objectOperation2 = 'fr.ird.observe.entities.referentiel.seine.ObjectOperation#0#5'  WHERE objectOperation = 'fr.ird.observe.entities.referentiel.seine.ObjectOperation#1239832686249#0.7838704130950722' AND objectFate = 'fr.ird.observe.entities.referentiel.seine.ObjectFate#1239832683674#0.32469201752917276';
    27 
    +UPDATE observe_seine.floatingObject set objectOperation2 = 'fr.ird.observe.entities.referentiel.seine.ObjectOperation#0#4'  WHERE objectOperation = 'fr.ird.observe.entities.referentiel.seine.ObjectOperation#1239832686249#0.7838704130950722' AND objectFate = 'fr.ird.observe.entities.referentiel.seine.ObjectFate#1239832683675#0.7559688295127481';
    28 
    +UPDATE observe_seine.floatingObject set objectOperation2 = 'fr.ird.observe.entities.referentiel.seine.ObjectOperation#0#6'  WHERE objectOperation = 'fr.ird.observe.entities.referentiel.seine.ObjectOperation#1239832686249#0.7838704130950722' AND objectFate = 'fr.ird.observe.entities.referentiel.seine.ObjectFate#1239832683675#0.88526017739943';
    29 
    +UPDATE observe_seine.floatingObject set objectOperation2 = 'fr.ird.observe.entities.referentiel.seine.ObjectOperation#0#7'  WHERE objectOperation = 'fr.ird.observe.entities.referentiel.seine.ObjectOperation#1239832686249#0.7838704130950722' AND objectFate = 'fr.ird.observe.entities.referentiel.seine.ObjectFate#1239832683675#0.190123844350496';
    30 
    +UPDATE observe_seine.floatingObject set objectOperation2 = 'fr.ird.observe.entities.referentiel.seine.ObjectOperation#0#8'  WHERE objectOperation = 'fr.ird.observe.entities.referentiel.seine.ObjectOperation#1239832686249#0.7838704130950722' AND objectFate = 'fr.ird.observe.entities.referentiel.seine.ObjectFate#1396860761530#0.8869464242156488';
    31 
    +UPDATE observe_seine.floatingObject set objectOperation2 = 'fr.ird.observe.entities.referentiel.seine.ObjectOperation#0#4'  WHERE objectOperation = 'fr.ird.observe.entities.referentiel.seine.ObjectOperation#1239832686249#0.7838704130950722' AND objectFate not in ('fr.ird.observe.entities.referentiel.seine.ObjectFate#1239832683674#0.32469201752917276','fr.ird.observe.entities.referentiel.seine.ObjectFate#1239832683675#0.7559688295127481','fr.ird.observe.entities.referentiel.seine.ObjectFate#1239832683675#0.88526017739943','fr.ird.observe.entities.referentiel.seine.ObjectFate#1239832683675#0.190123844350496', 'fr.ird.observe.entities.referentiel.seine.ObjectFate#1396860761530#0.8869464242156488');
    32 
    +
    33 
    +UPDATE observe_seine.floatingObject set objectOperation2 = 'fr.ird.observe.entities.referentiel.seine.ObjectOperation#0#5'  WHERE objectOperation = 'fr.ird.observe.entities.referentiel.seine.ObjectOperation#1239832686249#0.8268884472438458' AND objectFate = 'fr.ird.observe.entities.referentiel.seine.ObjectFate#1239832683674#0.32469201752917276';
    34 
    +UPDATE observe_seine.floatingObject set objectOperation2 = 'fr.ird.observe.entities.referentiel.seine.ObjectOperation#0#4'  WHERE objectOperation = 'fr.ird.observe.entities.referentiel.seine.ObjectOperation#1239832686249#0.8268884472438458' AND objectFate = 'fr.ird.observe.entities.referentiel.seine.ObjectFate#1239832683675#0.7559688295127481';
    35 
    +UPDATE observe_seine.floatingObject set objectOperation2 = 'fr.ird.observe.entities.referentiel.seine.ObjectOperation#0#6'  WHERE objectOperation = 'fr.ird.observe.entities.referentiel.seine.ObjectOperation#1239832686249#0.8268884472438458' AND objectFate = 'fr.ird.observe.entities.referentiel.seine.ObjectFate#1239832683675#0.88526017739943';
    36 
    +UPDATE observe_seine.floatingObject set objectOperation2 = 'fr.ird.observe.entities.referentiel.seine.ObjectOperation#0#7'  WHERE objectOperation = 'fr.ird.observe.entities.referentiel.seine.ObjectOperation#1239832686249#0.8268884472438458' AND objectFate = 'fr.ird.observe.entities.referentiel.seine.ObjectFate#1239832683675#0.190123844350496';
    37 
    +UPDATE observe_seine.floatingObject set objectOperation2 = 'fr.ird.observe.entities.referentiel.seine.ObjectOperation#0#8'  WHERE objectOperation = 'fr.ird.observe.entities.referentiel.seine.ObjectOperation#1239832686249#0.8268884472438458' AND objectFate = 'fr.ird.observe.entities.referentiel.seine.ObjectFate#1396860761530#0.8869464242156488';
    38 
    +UPDATE observe_seine.floatingObject set objectOperation2 = 'fr.ird.observe.entities.referentiel.seine.ObjectOperation#0#2'  WHERE objectOperation = 'fr.ird.observe.entities.referentiel.seine.ObjectOperation#1239832686249#0.8268884472438458' AND objectFate not in ('fr.ird.observe.entities.referentiel.seine.ObjectFate#1239832683674#0.32469201752917276','fr.ird.observe.entities.referentiel.seine.ObjectFate#1239832683675#0.7559688295127481','fr.ird.observe.entities.referentiel.seine.ObjectFate#1239832683675#0.88526017739943','fr.ird.observe.entities.referentiel.seine.ObjectFate#1239832683675#0.190123844350496', 'fr.ird.observe.entities.referentiel.seine.ObjectFate#1396860761530#0.8869464242156488');
    39 
    +
    40 
    +UPDATE observe_seine.floatingObject set objectOperation2 = 'fr.ird.observe.entities.referentiel.seine.ObjectOperation#0#5'  WHERE objectOperation = 'fr.ird.observe.entities.referentiel.seine.ObjectOperation#1239832686249#0.8431519556575698' AND objectFate = 'fr.ird.observe.entities.referentiel.seine.ObjectFate#1239832683674#0.32469201752917276';
    41 
    +UPDATE observe_seine.floatingObject set objectOperation2 = 'fr.ird.observe.entities.referentiel.seine.ObjectOperation#0#4'  WHERE objectOperation = 'fr.ird.observe.entities.referentiel.seine.ObjectOperation#1239832686249#0.8431519556575698' AND objectFate = 'fr.ird.observe.entities.referentiel.seine.ObjectFate#1239832683675#0.7559688295127481';
    42 
    +UPDATE observe_seine.floatingObject set objectOperation2 = 'fr.ird.observe.entities.referentiel.seine.ObjectOperation#0#6'  WHERE objectOperation = 'fr.ird.observe.entities.referentiel.seine.ObjectOperation#1239832686249#0.8431519556575698' AND objectFate = 'fr.ird.observe.entities.referentiel.seine.ObjectFate#1239832683675#0.88526017739943';
    43 
    +UPDATE observe_seine.floatingObject set objectOperation2 = 'fr.ird.observe.entities.referentiel.seine.ObjectOperation#0#7'  WHERE objectOperation = 'fr.ird.observe.entities.referentiel.seine.ObjectOperation#1239832686249#0.8431519556575698' AND objectFate = 'fr.ird.observe.entities.referentiel.seine.ObjectFate#1239832683675#0.190123844350496';
    44 
    +UPDATE observe_seine.floatingObject set objectOperation2 = 'fr.ird.observe.entities.referentiel.seine.ObjectOperation#0#8'  WHERE objectOperation = 'fr.ird.observe.entities.referentiel.seine.ObjectOperation#1239832686249#0.8431519556575698' AND objectFate = 'fr.ird.observe.entities.referentiel.seine.ObjectFate#1396860761530#0.8869464242156488';
    45 
    +UPDATE observe_seine.floatingObject set objectOperation2 = 'fr.ird.observe.entities.referentiel.seine.ObjectOperation#0#2'  WHERE objectOperation = 'fr.ird.observe.entities.referentiel.seine.ObjectOperation#1239832686249#0.8431519556575698' AND objectFate not in ('fr.ird.observe.entities.referentiel.seine.ObjectFate#1239832683674#0.32469201752917276','fr.ird.observe.entities.referentiel.seine.ObjectFate#1239832683675#0.7559688295127481','fr.ird.observe.entities.referentiel.seine.ObjectFate#1239832683675#0.88526017739943','fr.ird.observe.entities.referentiel.seine.ObjectFate#1239832683675#0.190123844350496', 'fr.ird.observe.entities.referentiel.seine.ObjectFate#1396860761530#0.8869464242156488');
    46 
    +
    47 
    +alter table observe_seine.floatingObject drop COLUMN objectOperation;
    48 
    +alter table observe_seine.floatingObject drop COLUMN objectFate;
    49 
    +drop table observe_seine.objectFate;
    50 
    +
    51 
    +delete from observe_seine.objectOperation;
    52 
    +
    53 
    +INSERT INTO observe_seine.objectOperation (topiaid, topiaversion, topiacreatedate, lastupdatedate, status, code, label1, label2, label3, needComment) values ('fr.ird.observe.entities.referentiel.seine.ObjectOperation#0#1' , 0, CURRENT_DATE, CURRENT_TIMESTAMP,  1, '1' ,'Deployment', 'Mise à l''eau', 'Mise à l''eau TODO', false);
    54 
    +INSERT INTO observe_seine.objectOperation (topiaid, topiaversion, topiacreatedate, lastupdatedate, status, code, label1, label2, label3, needComment) values ('fr.ird.observe.entities.referentiel.seine.ObjectOperation#0#2' , 0, CURRENT_DATE, CURRENT_TIMESTAMP,  1, '2' ,'Visit', 'Visite', 'Visite TODO', false);
    55 
    +INSERT INTO observe_seine.objectOperation (topiaid, topiaversion, topiacreatedate, lastupdatedate, status, code, label1, label2, label3, needComment) values ('fr.ird.observe.entities.referentiel.seine.ObjectOperation#0#3' , 0, CURRENT_DATE, CURRENT_TIMESTAMP,  0, '3' ,'Fishing', 'Pêche', 'Pêche TODO', true);
    56 
    +INSERT INTO observe_seine.objectOperation (topiaid, topiaversion, topiacreatedate, lastupdatedate, status, code, label1, label2, label3, needComment) values ('fr.ird.observe.entities.referentiel.seine.ObjectOperation#0#4' , 0, CURRENT_DATE, CURRENT_TIMESTAMP,  1, '4' ,'Removal', 'Retrait', 'Retrait TODO', false);
    57 
    +INSERT INTO observe_seine.objectOperation (topiaid, topiaversion, topiacreatedate, lastupdatedate, status, code, label1, label2, label3, needComment) values ('fr.ird.observe.entities.referentiel.seine.ObjectOperation#0#5' , 0, CURRENT_DATE, CURRENT_TIMESTAMP,  1, '5' ,'Abandonned (without tag, not destroyed, not sunk)', 'Abandonné (sans balise, non détruit, non coulé)', 'Abandonné (sans balise, non détruit, non coulé) TODO', false);
    58 
    +INSERT INTO observe_seine.objectOperation (topiaid, topiaversion, topiacreatedate, lastupdatedate, status, code, label1, label2, label3, needComment) values ('fr.ird.observe.entities.referentiel.seine.ObjectOperation#0#6' , 0, CURRENT_DATE, CURRENT_TIMESTAMP,  1, '6' ,'Destroyed', 'Détruit', 'Détruit TODO', false);
    59 
    +INSERT INTO observe_seine.objectOperation (topiaid, topiaversion, topiacreatedate, lastupdatedate, status, code, label1, label2, label3, needComment) values ('fr.ird.observe.entities.referentiel.seine.ObjectOperation#0#7' , 0, CURRENT_DATE, CURRENT_TIMESTAMP,  1, '7' ,'Sunk', 'Coulé', 'Coulé TODO', false);
    60 
    +INSERT INTO observe_seine.objectOperation (topiaid, topiaversion, topiacreatedate, lastupdatedate, status, code, label1, label2, label3, needComment) values ('fr.ird.observe.entities.referentiel.seine.ObjectOperation#0#8' , 0, CURRENT_DATE, CURRENT_TIMESTAMP,  1, '8' ,'Modified or reinforced', 'Modification ou renforcement', 'Modification ou renforcement TODO', false);
    61 
    +INSERT INTO observe_seine.objectOperation (topiaid, topiaversion, topiacreatedate, lastupdatedate, status, code, label1, label2, label3, needComment) values ('fr.ird.observe.entities.referentiel.seine.ObjectOperation#0#9' , 0, CURRENT_DATE, CURRENT_TIMESTAMP,  1, '9' ,'Replacement', 'Remplacement', 'Remplacement TODO', false);
    62 
    +INSERT INTO observe_seine.objectOperation (topiaid, topiaversion, topiacreatedate, lastupdatedate, status, code, label1, label2, label3, needComment) values ('fr.ird.observe.entities.referentiel.seine.ObjectOperation#0#10', 0, CURRENT_DATE, CURRENT_TIMESTAMP,  1, '10','Other (to be precised)', 'Autre (préciser dans les notes)', 'Autre (préciser dans les notes) TODO', true);
    63 
    +UPDATE OBSERVE_COMMON.LASTUPDATEDATE SET  LASTUPDATEDATE = CURRENT_TIMESTAMP WHERE type = 'fr.ird.observe.entities.referentiel.seine.ObjectOperation';
    64 
    +
    65 
    +ALTER TABLE observe_seine.floatingObject RENAME objectOperation2 TO objectOperation;
    66 
    +
    67 
    +ALTER TABLE observe_seine.floatingObject ADD CONSTRAINT fk_floatingobject_objectOperation FOREIGN KEY (objectOperation) REFERENCES observe_seine.objectOperation(topiaid);
    68 
    +

  • persistence/src/main/resources/db/migration/6.901/02_add_object_material-common.sql
    ... ... @@ -24,47 +24,47 @@ ALTER TABLE observe_seine.objectMaterial ADD CONSTRAINT PK_OBJECT_MATERIAL PRIMA
    24 24 
     INSERT INTO observe_common.LASTUPDATEDATE (topiaId, topiaversion, topiacreatedate, TYPE , LASTUPDATEDATE) values ('fr.ird.observe.entities.LastUpdateDate#666#900', 0,CURRENT_DATE, 'fr.ird.observe.entities.referentiel.seine.ObjectMaterial', CURRENT_TIMESTAMP);
    25 25
    26 26 
     delete from observe_seine.objectMaterial ;
    27 
    -INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, code, parentCode, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, usedInSimpleForm, usedInDetailledForm) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '1', NULL, 'Raft', 'Radeau', true, true, true, true, true);
    28 
    -INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, code, parentCode, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, usedInSimpleForm, usedInDetailledForm) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#1', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '1-1', '1', 'Frame', ' Chassis', FALSE, FALSE, TRUE, false, true);
    29 
    -INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, code, parentCode, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, usedInSimpleForm, usedInDetailledForm) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#2', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '1-1-1', '1-1', 'Vegetal (including bamboo)', 'Végétal (dont bambou)', true, false, false, false, true);
    30 
    -INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, code, parentCode, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, usedInSimpleForm, usedInDetailledForm) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#3', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '1-1-2', '1-1', 'Metal', 'Métal', true, false, false, false, true);
    31 
    -INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, code, parentCode, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, usedInSimpleForm, usedInDetailledForm) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#4', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '1-1-3', '1-1','PVC', 'PVC', true, false, false, false, true);
    32 
    -INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, code, parentCode, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, usedInSimpleForm, usedInDetailledForm) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#5', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '1-2', '1', 'Coverage type', 'Type de couverture', false, true, true, false, true);
    33 
    -INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, code, parentCode, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, usedInSimpleForm, usedInDetailledForm) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#6', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '1-2-1', '1-2', 'Net', 'Filet', FALSE, TRUE, FALSE, false, true);
    34 
    -INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, code, parentCode, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, usedInSimpleForm, usedInDetailledForm) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#7', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '1-2-1-1', '1-2-1', 'Net with mesh <=3cm', 'Filet avec maille <=3cm', FALSE, TRUE, FALSE, false, true);
    35 
    -INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, code, parentCode, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, usedInSimpleForm, usedInDetailledForm) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#8', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '1-2-1-1-1', '1-2-1-1', 'Net with mesh <=3cm above', 'Filet avec maille <=3cm dessus', true, false, false, false, true);
    36 
    -INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, code, parentCode, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, usedInSimpleForm, usedInDetailledForm) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#9', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '1-2-1-1-2', '1-2-1-1', 'Net with mesh <=3cm behind', 'Filet avec maille <=3cm dessous', true, false, false, false, true);
    37 
    -INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, code, parentCode, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, usedInSimpleForm, usedInDetailledForm) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#10', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '1-2-1-2', '1-2-1', 'Net with mesh >3cm', 'Filet avec maille >3cm', FALSE, FALSE, false, false, true);
    38 
    -INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, code, parentCode, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, usedInSimpleForm, usedInDetailledForm) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#11', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '1-2-1-2-1', '1-2-1-2', 'Net with mesh >3cm above', 'Filet avec maille >3cm dessus', true, false, false, false, true);
    39 
    -INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, code, parentCode, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, usedInSimpleForm, usedInDetailledForm) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#12', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '1-2-1-2-2', '1-2-1-2', 'Net with mesh >3cm behind', 'Filet avec maille >3cm dessous', true, false, false, false, true);
    40 
    -INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, code, parentCode, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, usedInSimpleForm, usedInDetailledForm) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#13', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '1-2-2', '1-2', 'Coverage without mesh', 'Couverture sans maille', FALSE, FALSE, false, false, true);
    41 
    -INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, code, parentCode, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, usedInSimpleForm, usedInDetailledForm) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#14', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '1-2-2-1', '1-2-2', 'Coverage without mesh above', 'Couverture sans maille dessus', true, false, false, false, true);
    42 
    -INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, code, parentCode, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, usedInSimpleForm, usedInDetailledForm) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#15', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '1-2-2-2', '1-2-2', 'Coverage without mesh behind', 'Couverture sans maille dessous', true, false, false, false, true);
    43 
    -INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, code, parentCode, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, usedInSimpleForm, usedInDetailledForm) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#16', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '1-2-3', '1-2', 'Not covered', 'Non couvert', FALSE, FALSE, false, false, true);
    44 
    -INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, code, parentCode, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, usedInSimpleForm, usedInDetailledForm) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#17', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '1-2-3-1', '1-2-3', 'Not covered above', 'Non couvert dessus', true, false, false, false, true);
    45 
    -INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, code, parentCode, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, usedInSimpleForm, usedInDetailledForm) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#18', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '1-2-3-2', '1-2-3', 'Not covered behind', 'Non couvert dessous', true, false, false, false, true);
    46 
    -INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, code, parentCode, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, usedInSimpleForm, usedInDetailledForm) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#19', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '1-2-4', '1-2', 'Not visible', 'Non visible', false, false, false, false, true);
    47 
    -INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, code, parentCode, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, usedInSimpleForm, usedInDetailledForm) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#20', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '1-2-4-1', '1-2-4', 'Not visible above', 'Non visible dessus', true, false, false, false, true);
    48 
    -INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, code, parentCode, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, usedInSimpleForm, usedInDetailledForm) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#21', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '1-2-4-2', '1-2-4', 'Not visible behind', 'Non visible dessous', true, false, false, false, true);
    49 
    -INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, code, parentCode, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, usedInSimpleForm, usedInDetailledForm) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#22', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '2', NULL, 'Underwater part', 'Partie immergée', false, true, true, false, true);
    50 
    -INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, code, parentCode, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, usedInSimpleForm, usedInDetailledForm) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#23', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '2-1', '2', 'Net in sausage', 'Filet saucisse', FALSE, TRUE, FALSE, false, true);
    51 
    -INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, code, parentCode, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, usedInSimpleForm, usedInDetailledForm) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#24', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '2-1-1', '2-1', 'Net in sausage <=3cm', 'Filet saucisse <=3cm', true, false, false, false, true);
    52 
    -INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, code, parentCode, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, usedInSimpleForm, usedInDetailledForm) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#25', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '2-1-2', '2-1', 'Net in sausage >3cm', 'Filet saucisse >3cm', true, false, false, false, true);
    53 
    -INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, code, parentCode, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, usedInSimpleForm, usedInDetailledForm) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#26', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '2-2', '2', 'Open net', 'Filet ouvert', FALSE, TRUE, FALSE, false, true);
    54 
    -INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, code, parentCode, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, usedInSimpleForm, usedInDetailledForm) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#27', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '2-2-1', '2-2', 'Open net <= 3cm', 'Filet ouvert <=3cm', true, false, false, false, true);
    55 
    -INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, code, parentCode, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, usedInSimpleForm, usedInDetailledForm) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#28', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '2-2-2', '2-2', 'Open net >3cm', 'Filet ouvert >3cm', true, false, false, false, true);
    56 
    -INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, code, parentCode, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, usedInSimpleForm, usedInDetailledForm) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#29', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '2-3', '2', 'Single net pieces', 'Pièces de filets accolées', FALSE, TRUE, FALSE, false, true);
    57 
    -INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, code, parentCode, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, usedInSimpleForm, usedInDetailledForm) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#30', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '2-3-1', '2-3', 'Single net pieces <=3cm', 'Pièces de filets accolées <=3cm', true, false, false, false, true);
    58 
    -INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, code, parentCode, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, usedInSimpleForm, usedInDetailledForm) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#31', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '2-3-2', '2-3', 'Single net pieces >3cm', 'Pièces de filets accolées >3cm', true, false, false, false, true);
    59 
    -INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, code, parentCode, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, usedInSimpleForm, usedInDetailledForm) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#32', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '2-4', '2', 'Rope/no mesh', 'Bout/sans maille', true, false, false, false, true);
    60 
    -INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, code, parentCode, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, usedInSimpleForm, usedInDetailledForm) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#33', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '2-5', '2', 'Not visible', 'Pas visible', true, false, false, false, true);
    61 
    -INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, code, parentCode, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, usedInSimpleForm, usedInDetailledForm) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#34', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '2-6', '2', 'No sub structure', 'Pas de mouillage', true, false, false, false, true);
    62 
    -INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, code, parentCode, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, usedInSimpleForm, usedInDetailledForm) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#35', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '3', NULL, 'Other elements', 'Autres éléments', FALSE, TRUE, FALSE, true, true);
    63 
    -INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, code, parentCode, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, usedInSimpleForm, usedInDetailledForm) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#36', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '3-1', '3', 'Platic containers', 'Bidons plastique', true, false, false, true, true);
    64 
    -INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, code, parentCode, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, usedInSimpleForm, usedInDetailledForm) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#37', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '3-2', '3', 'Corks', 'Flotteurs', true, false, false, true, true);
    65 
    -INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, code, parentCode, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, usedInSimpleForm, usedInDetailledForm) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#38', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '3-3', '3', 'Bags', 'Sacs', true, false, false, true, true);
    66 
    -INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, code, parentCode, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, usedInSimpleForm, usedInDetailledForm) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#39', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '3-4', '3', 'Palms, canes', 'Palmes, tiges', true, false, false, true, true);
    67 
    -INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, code, parentCode, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, usedInSimpleForm, usedInDetailledForm) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#40', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '3-5', '3', 'Color belts', 'Rubans colorés', true, false, false, true, true);
    68 
    -INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, code, parentCode, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, usedInSimpleForm, usedInDetailledForm) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#41', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '3-6', '3', 'Weights', 'Poids', true, false, false, true, true);
    69 
    -INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, code, parentCode, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, usedInSimpleForm, usedInDetailledForm) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#42', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '3-7', '3', 'Entangled animal', 'Animal maillé', true, false, false, true, true);
    27 
    +INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, code, parentCode, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, usedInSimpleForm, usedInDetailledForm) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#0', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '1', NULL, 'Raft', 'Radeau', true, true, true, true, true);
    28 
    +INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, code, parentCode, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, usedInSimpleForm, usedInDetailledForm) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#1', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '1-1', '1', 'Frame', ' Chassis', FALSE, FALSE, TRUE, false, true);
    29 
    +INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, code, parentCode, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, usedInSimpleForm, usedInDetailledForm) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#2', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '1-1-1', '1-1', 'Vegetal (including bamboo)', 'Végétal (dont bambou)', true, false, false, false, true);
    30 
    +INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, code, parentCode, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, usedInSimpleForm, usedInDetailledForm) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#3', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '1-1-2', '1-1', 'Metal', 'Métal', true, false, false, false, true);
    31 
    +INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, code, parentCode, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, usedInSimpleForm, usedInDetailledForm) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#4', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '1-1-3', '1-1','PVC', 'PVC', true, false, false, false, true);
    32 
    +INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, code, parentCode, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, usedInSimpleForm, usedInDetailledForm) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#5', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '1-2', '1', 'Coverage type', 'Type de couverture', false, true, true, false, true);
    33 
    +INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, code, parentCode, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, usedInSimpleForm, usedInDetailledForm) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#6', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '1-2-1', '1-2', 'Net', 'Filet', FALSE, TRUE, FALSE, false, true);
    34 
    +INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, code, parentCode, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, usedInSimpleForm, usedInDetailledForm) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#7', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '1-2-1-1', '1-2-1', 'Net with mesh <=3cm', 'Filet avec maille <=3cm', FALSE, TRUE, FALSE, false, true);
    35 
    +INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, code, parentCode, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, usedInSimpleForm, usedInDetailledForm) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#8', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '1-2-1-1-1', '1-2-1-1', 'Net with mesh <=3cm above', 'Filet avec maille <=3cm dessus', true, false, false, false, true);
    36 
    +INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, code, parentCode, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, usedInSimpleForm, usedInDetailledForm) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#9', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '1-2-1-1-2', '1-2-1-1', 'Net with mesh <=3cm behind', 'Filet avec maille <=3cm dessous', true, false, false, false, true);
    37 
    +INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, code, parentCode, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, usedInSimpleForm, usedInDetailledForm) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#10', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '1-2-1-2', '1-2-1', 'Net with mesh >3cm', 'Filet avec maille >3cm', FALSE, FALSE, false, false, true);
    38 
    +INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, code, parentCode, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, usedInSimpleForm, usedInDetailledForm) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#11', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '1-2-1-2-1', '1-2-1-2', 'Net with mesh >3cm above', 'Filet avec maille >3cm dessus', true, false, false, false, true);
    39 
    +INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, code, parentCode, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, usedInSimpleForm, usedInDetailledForm) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#12', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '1-2-1-2-2', '1-2-1-2', 'Net with mesh >3cm behind', 'Filet avec maille >3cm dessous', true, false, false, false, true);
    40 
    +INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, code, parentCode, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, usedInSimpleForm, usedInDetailledForm) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#13', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '1-2-2', '1-2', 'Coverage without mesh', 'Couverture sans maille', FALSE, FALSE, false, false, true);
    41 
    +INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, code, parentCode, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, usedInSimpleForm, usedInDetailledForm) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#14', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '1-2-2-1', '1-2-2', 'Coverage without mesh above', 'Couverture sans maille dessus', true, false, false, false, true);
    42 
    +INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, code, parentCode, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, usedInSimpleForm, usedInDetailledForm) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#15', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '1-2-2-2', '1-2-2', 'Coverage without mesh behind', 'Couverture sans maille dessous', true, false, false, false, true);
    43 
    +INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, code, parentCode, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, usedInSimpleForm, usedInDetailledForm) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#16', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '1-2-3', '1-2', 'Not covered', 'Non couvert', FALSE, FALSE, false, false, true);
    44 
    +INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, code, parentCode, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, usedInSimpleForm, usedInDetailledForm) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#17', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '1-2-3-1', '1-2-3', 'Not covered above', 'Non couvert dessus', true, false, false, false, true);
    45 
    +INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, code, parentCode, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, usedInSimpleForm, usedInDetailledForm) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#18', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '1-2-3-2', '1-2-3', 'Not covered behind', 'Non couvert dessous', true, false, false, false, true);
    46 
    +INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, code, parentCode, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, usedInSimpleForm, usedInDetailledForm) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#19', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '1-2-4', '1-2', 'Not visible', 'Non visible', false, false, false, false, true);
    47 
    +INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, code, parentCode, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, usedInSimpleForm, usedInDetailledForm) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#20', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '1-2-4-1', '1-2-4', 'Not visible above', 'Non visible dessus', true, false, false, false, true);
    48 
    +INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, code, parentCode, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, usedInSimpleForm, usedInDetailledForm) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#21', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '1-2-4-2', '1-2-4', 'Not visible behind', 'Non visible dessous', true, false, false, false, true);
    49 
    +INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, code, parentCode, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, usedInSimpleForm, usedInDetailledForm) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#22', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '2', NULL, 'Underwater part', 'Partie immergée', false, true, true, false, true);
    50 
    +INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, code, parentCode, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, usedInSimpleForm, usedInDetailledForm) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#23', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '2-1', '2', 'Net in sausage', 'Filet saucisse', FALSE, TRUE, FALSE, false, true);
    51 
    +INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, code, parentCode, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, usedInSimpleForm, usedInDetailledForm) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#24', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '2-1-1', '2-1', 'Net in sausage <=3cm', 'Filet saucisse <=3cm', true, false, false, false, true);
    52 
    +INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, code, parentCode, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, usedInSimpleForm, usedInDetailledForm) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#25', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '2-1-2', '2-1', 'Net in sausage >3cm', 'Filet saucisse >3cm', true, false, false, false, true);
    53 
    +INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, code, parentCode, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, usedInSimpleForm, usedInDetailledForm) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#26', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '2-2', '2', 'Open net', 'Filet ouvert', FALSE, TRUE, FALSE, false, true);
    54 
    +INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, code, parentCode, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, usedInSimpleForm, usedInDetailledForm) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#27', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '2-2-1', '2-2', 'Open net <= 3cm', 'Filet ouvert <=3cm', true, false, false, false, true);
    55 
    +INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, code, parentCode, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, usedInSimpleForm, usedInDetailledForm) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#28', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '2-2-2', '2-2', 'Open net >3cm', 'Filet ouvert >3cm', true, false, false, false, true);
    56 
    +INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, code, parentCode, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, usedInSimpleForm, usedInDetailledForm) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#29', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '2-3', '2', 'Single net pieces', 'Pièces de filets accolées', FALSE, TRUE, FALSE, false, true);
    57 
    +INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, code, parentCode, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, usedInSimpleForm, usedInDetailledForm) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#30', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '2-3-1', '2-3', 'Single net pieces <=3cm', 'Pièces de filets accolées <=3cm', true, false, false, false, true);
    58 
    +INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, code, parentCode, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, usedInSimpleForm, usedInDetailledForm) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#31', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '2-3-2', '2-3', 'Single net pieces >3cm', 'Pièces de filets accolées >3cm', true, false, false, false, true);
    59 
    +INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, code, parentCode, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, usedInSimpleForm, usedInDetailledForm) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#32', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '2-4', '2', 'Rope/no mesh', 'Bout/sans maille', true, false, false, false, true);
    60 
    +INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, code, parentCode, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, usedInSimpleForm, usedInDetailledForm) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#33', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '2-5', '2', 'Not visible', 'Pas visible', true, false, false, false, true);
    61 
    +INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, code, parentCode, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, usedInSimpleForm, usedInDetailledForm) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#34', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '2-6', '2', 'No sub structure', 'Pas de mouillage', true, false, false, false, true);
    62 
    +INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, code, parentCode, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, usedInSimpleForm, usedInDetailledForm) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#35', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '3', NULL, 'Other elements', 'Autres éléments', FALSE, TRUE, FALSE, true, true);
    63 
    +INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, code, parentCode, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, usedInSimpleForm, usedInDetailledForm) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#36', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '3-1', '3', 'Platic containers', 'Bidons plastique', true, false, false, true, true);
    64 
    +INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, code, parentCode, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, usedInSimpleForm, usedInDetailledForm) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#37', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '3-2', '3', 'Corks', 'Flotteurs', true, false, false, true, true);
    65 
    +INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, code, parentCode, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, usedInSimpleForm, usedInDetailledForm) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#38', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '3-3', '3', 'Bags', 'Sacs', true, false, false, true, true);
    66 
    +INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, code, parentCode, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, usedInSimpleForm, usedInDetailledForm) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#39', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '3-4', '3', 'Palms, canes', 'Palmes, tiges', true, false, false, true, true);
    67 
    +INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, code, parentCode, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, usedInSimpleForm, usedInDetailledForm) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#40', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '3-5', '3', 'Color belts', 'Rubans colorés', true, false, false, true, true);
    68 
    +INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, code, parentCode, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, usedInSimpleForm, usedInDetailledForm) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#41', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '3-6', '3', 'Weights', 'Poids', true, false, false, true, true);
    69 
    +INSERT INTO observe_seine.objectMaterial (topiaid, topiaversion, topiacreatedate, lastupdatedate, needComment, status, code, parentCode, label1, label2, selectable, childrenMultiSelectable, childSelectionMandatory, usedInSimpleForm, usedInDetailledForm) values ('fr.ird.observe.entities.referentiel.seine.ObjectMaterial#0#42', 0, CURRENT_DATE, CURRENT_TIMESTAMP, false,  1, '3-7', '3', 'Entangled animal', 'Animal maillé', true, false, false, true, true);
    70 70 
     UPDATE observe_seine.objectMaterial set label3 = label2 || ' TODO';

    • —
    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.