Tony CHEMIT pushed to branch develop-7.x at ultreiaio / ird-observe Commits: 405b85cc by Tony CHEMIT at 2017-06-02T15:17:33+02:00 Fix migration scripts for pg (See #612) - - - - - 3 changed files: - 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 - + persistence/src/main/resources/db/migration/6.901/01_add_object_operation-PG.sql - persistence/src/main/resources/db/migration/6.901/02_add_object_material-common.sql 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 ===================================== --- a/persistence/src/main/resources/db/migration/6.901/01_add_object_operation-common.sql +++ b/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 UPDATE OBSERVE_COMMON.LASTUPDATEDATE SET LASTUPDATEDATE = CURRENT_TIMESTAMP WHERE type = 'fr.ird.observe.entities.referentiel.seine.ObjectOperation'; ALTER TABLE observe_seine.floatingObject ALTER COLUMN objectOperation2 RENAME TO objectOperation; + +ALTER TABLE observe_seine.floatingObject RENAME objectOperation2 TO objectOperation; + ALTER TABLE observe_seine.floatingObject ADD CONSTRAINT fk_floatingobject_objectOperation FOREIGN KEY (objectOperation) REFERENCES observe_seine.objectOperation(topiaid); ===================================== persistence/src/main/resources/db/migration/6.901/01_add_object_operation-PG.sql ===================================== --- /dev/null +++ b/persistence/src/main/resources/db/migration/6.901/01_add_object_operation-PG.sql @@ -0,0 +1,68 @@ +--- +-- #%L +-- ObServe :: Persistence +-- %% +-- Copyright (C) 2008 - 2017 IRD, Code Lutin, Ultreia.io +-- %% +-- This program is free software: you can redistribute it and/or modify +-- it under the terms of the GNU General Public License as +-- published by the Free Software Foundation, either version 3 of the +-- License, or (at your option) any later version. +-- +-- This program is distributed in the hope that it will be useful, +-- but WITHOUT ANY WARRANTY; without even the implied warranty of +-- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the +-- GNU General Public License for more details. +-- +-- You should have received a copy of the GNU General Public +-- License along with this program. If not, see +-- <http://www.gnu.org/licenses/gpl-3.0.html>. +-- #L% +--- +ALTER TABLE observe_seine.floatingObject ADD COLUMN objectOperation2 CHARACTER VARYING (256); + +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'; + +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'; +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'; +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'; +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'; +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'; +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'); + +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'; +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'; +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'; +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'; +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'; +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'); + +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'; +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'; +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'; +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'; +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'; +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'); + +alter table observe_seine.floatingObject drop COLUMN objectOperation; +alter table observe_seine.floatingObject drop COLUMN objectFate; +drop table observe_seine.objectFate; + +delete from observe_seine.objectOperation; + +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); +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); +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); +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); +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); +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); +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); +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); +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); +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); +UPDATE OBSERVE_COMMON.LASTUPDATEDATE SET LASTUPDATEDATE = CURRENT_TIMESTAMP WHERE type = 'fr.ird.observe.entities.referentiel.seine.ObjectOperation'; + +ALTER TABLE observe_seine.floatingObject RENAME objectOperation2 TO objectOperation; + +ALTER TABLE observe_seine.floatingObject ADD CONSTRAINT fk_floatingobject_objectOperation FOREIGN KEY (objectOperation) REFERENCES observe_seine.objectOperation(topiaid); + ===================================== persistence/src/main/resources/db/migration/6.901/02_add_object_material-common.sql ===================================== --- a/persistence/src/main/resources/db/migration/6.901/02_add_object_material-common.sql +++ b/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 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); delete from observe_seine.objectMaterial ; -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); -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); -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); -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); -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); -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); -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); -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); -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); -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); -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); -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); -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); -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); -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); -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); -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); -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); -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); -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); -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); -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); -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); -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); -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); -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); -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); -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); -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); -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); -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); -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); -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); -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); -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); -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); -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); -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); -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); -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); -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); -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); -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); +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); +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); +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); +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); +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); +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); +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); +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); +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); +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); +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); +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); +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); +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); +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); +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); +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); +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); +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); +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); +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); +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); +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); +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); +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); +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); +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); +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); +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); +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); +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); +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); +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); +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); +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); +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); +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); +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); +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); +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); +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); +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); +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); UPDATE observe_seine.objectMaterial set label3 = label2 || ' TODO'; View it on GitLab: https://gitlab.com/ultreiaio/ird-observe/commit/405b85cc79bb9d4632f9d8cee19e... --- View it on GitLab: https://gitlab.com/ultreiaio/ird-observe/commit/405b85cc79bb9d4632f9d8cee19e... You're receiving this email because of your account on gitlab.com.