Tony CHEMIT pushed to branch develop at ultreiaio / ird-observe Commits: 9841ce63 by Tony Chemit at 2020-10-01T14:40:51+02:00 Figer tous les lastUpdate et topiaCreateDate dans les scripts de migration - See #1593 On pose au 1er octobre 2020 pour la v8.0 (See also #1623) - - - - - 27 changed files: - persistence/src/main/java/fr/ird/observe/entities/migration/DataSourceMigrationForVersion_8_0.java - persistence/src/main/resources/db/migration/8.0/01_move_wind_referential-H2.sql - persistence/src/main/resources/db/migration/8.0/01_move_wind_referential-PG.sql - persistence/src/main/resources/db/migration/8.0/02_wind_i18n-common.sql - persistence/src/main/resources/db/migration/8.0/03_update_vesseltype-common.sql - persistence/src/main/resources/db/migration/8.0/04_update_person2-common.sql - persistence/src/main/resources/db/migration/8.0/05_rename_tripType-common.sql - persistence/src/main/resources/db/migration/8.0/06_fill_vessel_activity-common.sql - persistence/src/main/resources/db/migration/8.0/07_add_weight_determination_method-common.sql - persistence/src/main/resources/db/migration/8.0/08_add_weight_category-common.sql - persistence/src/main/resources/db/migration/8.0/09_add_compagnies-common.sql - persistence/src/main/resources/db/migration/8.0/10_add_length_measure_method-common.sql - persistence/src/main/resources/db/migration/8.0/11_add_weight_measure_method-common.sql - persistence/src/main/resources/db/migration/8.0/12_add_conservation-common.sql - persistence/src/main/resources/db/migration/8.0/13_add_on_board_processing-common.sql - persistence/src/main/resources/db/migration/8.0/14_add_data_source-common.sql - persistence/src/main/resources/db/migration/8.0/16_rename_seine_weight_category-common.sql - persistence/src/main/resources/db/migration/8.0/17_add_trip_type-common.sql - persistence/src/main/resources/db/migration/8.0/19_add_longline_trip_species_list-common.sql - persistence/src/main/resources/db/migration/8.0/20_update_referential_longline_line_type-common.sql - persistence/src/main/resources/db/migration/8.0/40_ps_common_fill-common.sql - persistence/src/main/resources/db/migration/8.0/80_ll_logbook_create-common.sql - persistence/src/main/resources/db/migration/8.0/90_ll_landing_fill-common.sql - persistence/src/main/resources/db/migration/8.0/90_ll_landing_finalize-common.sql - test/src/main/resources/db/8.0/dataForTestLongline.sql.gz - test/src/main/resources/db/8.0/dataForTestSeine.sql.gz - test/src/main/resources/db/8.0/referentiel.sql.gz Changes: ===================================== persistence/src/main/java/fr/ird/observe/entities/migration/DataSourceMigrationForVersion_8_0.java ===================================== @@ -44,7 +44,7 @@ public class DataSourceMigrationForVersion_8_0 extends MigrationVersionResource public DataSourceMigrationForVersion_8_0() { super(Versions.valueOf("8.0")); - ObserveTopiaMigrationServiceAskUserToMigrate.createResourceScriptVariables(this, "2020-08-01", "2020-08-01 10:57:53.455000"); + ObserveTopiaMigrationServiceAskUserToMigrate.createResourceScriptVariables(this, "2020-10-01", "2020-10-01 00:00:00.000000"); } @Override ===================================== persistence/src/main/resources/db/migration/8.0/01_move_wind_referential-H2.sql ===================================== @@ -32,7 +32,7 @@ ALTER TABLE OBSERVE_COMMON.Wind ALTER COLUMN NEEDCOMMENT SET NOT NULL; ALTER TABLE OBSERVE_COMMON.Wind ADD CONSTRAINT PK_WIND PRIMARY KEY(topiaid); UPDATE OBSERVE_COMMON.Wind SET TOPIAVERSION = TOPIAVERSION +1; -UPDATE OBSERVE_COMMON.LASTUPDATEDATE SET LASTUPDATEDATE = CURRENT_TIMESTAMP WHERE TYPE ='fr.ird.observe.entities.referentiel.Wind'; +UPDATE OBSERVE_COMMON.LASTUPDATEDATE SET LASTUPDATEDATE = ${CURRENT_TIMESTAMP} WHERE TYPE ='fr.ird.observe.entities.referentiel.Wind'; DROP INDEX IF EXISTS idx_observe_seine_activity_wind; UPDATE OBSERVE_SEINE.Activity SET Wind = replace(Wind, '.seine', ''); ===================================== persistence/src/main/resources/db/migration/8.0/01_move_wind_referential-PG.sql ===================================== @@ -24,7 +24,7 @@ ALTER TABLE OBSERVE_SEINE.Wind SET SCHEMA OBSERVE_COMMON; UPDATE OBSERVE_COMMON.LASTUPDATEDATE SET TYPE = replace(TYPE, '.seine.Wind', '.Wind'); UPDATE OBSERVE_COMMON.Wind SET TOPIAVERSION = TOPIAVERSION +1; -UPDATE OBSERVE_COMMON.LASTUPDATEDATE SET LASTUPDATEDATE = CURRENT_TIMESTAMP WHERE TYPE ='fr.ird.observe.entities.referentiel.Wind'; +UPDATE OBSERVE_COMMON.LASTUPDATEDATE SET LASTUPDATEDATE = ${CURRENT_TIMESTAMP} WHERE TYPE ='fr.ird.observe.entities.referentiel.Wind'; DROP INDEX IF EXISTS idx_observe_seine_activity_wind; UPDATE OBSERVE_SEINE.Activity SET Wind = replace(Wind, '.seine', ''); ===================================== persistence/src/main/resources/db/migration/8.0/02_wind_i18n-common.sql ===================================== @@ -33,4 +33,4 @@ UPDATE Observe_common.Wind SET LABEL2='Tempête (Très grosses lames, visibilit UPDATE Observe_common.Wind SET LABEL2='Violente tempête (Lames exceptionnellement hautes, visibilité très réduite)', LABEL1='Violent storm', LABEL3='Temporal muy duro (Olas excepcionalmente grandes, mar completamente blanca, visibilidad muy reducida)' WHERE CODE='11'; UPDATE Observe_common.Wind SET LABEL2='Ouragan (Mer blanche, air plein d''écume, visibilité nulle)', LABEL1='Hurricane force', LABEL3='Temporal huracanado (Olas excepcionalmente grandes, mar blanca, visibilidad nula)' WHERE CODE='12'; UPDATE Observe_common.Wind SET TOPIAVERSION = TOPIAVERSION +1; -UPDATE Observe_common.LASTUPDATEDATE SET LASTUPDATEDATE = CURRENT_TIMESTAMP WHERE TYPE ='fr.ird.observe.entities.referentiel.Wind'; +UPDATE Observe_common.LASTUPDATEDATE SET LASTUPDATEDATE = ${CURRENT_TIMESTAMP} WHERE TYPE ='fr.ird.observe.entities.referentiel.Wind'; ===================================== persistence/src/main/resources/db/migration/8.0/03_update_vesseltype-common.sql ===================================== @@ -19,5 +19,5 @@ -- <http://www.gnu.org/licenses/gpl-3.0.html>. -- #L% --- -INSERT INTO observe_common.VesselType(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, code, label1, label2, label3) values ('fr.ird.observe.entities.referentiel.VesselType#666#1' , 0, CURRENT_DATE, CURRENT_TIMESTAMP, 1, false, null,'Industrial longliner', 'Palangrier industriel','Palangrero industrial'); -INSERT INTO observe_common.VesselType(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, code, label1, label2, label3) values ('fr.ird.observe.entities.referentiel.VesselType#666#2' , 0, CURRENT_DATE, CURRENT_TIMESTAMP, 1, false, null,'Semi industrial longliner', 'Palangrier semi industriel','Palangreros semindustriales'); +INSERT INTO observe_common.VesselType(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, code, label1, label2, label3) values ('fr.ird.observe.entities.referentiel.VesselType#666#1' , 0, ${CURRENT_DATE}, ${CURRENT_TIMESTAMP}, 1, false, null,'Industrial longliner', 'Palangrier industriel','Palangrero industrial'); +INSERT INTO observe_common.VesselType(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, code, label1, label2, label3) values ('fr.ird.observe.entities.referentiel.VesselType#666#2' , 0, ${CURRENT_DATE}, ${CURRENT_TIMESTAMP}, 1, false, null,'Semi industrial longliner', 'Palangrier semi industriel','Palangreros semindustriales'); ===================================== persistence/src/main/resources/db/migration/8.0/04_update_person2-common.sql ===================================== @@ -19,29 +19,29 @@ -- <http://www.gnu.org/licenses/gpl-3.0.html>. -- #L% --- -INSERT INTO observe_common.Person(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, dataSource, lastname, firstname, country) values ('fr.ird.observe.entities.referentiel.Person#666#01' , 0, CURRENT_DATE, CURRENT_TIMESTAMP, 1, false, true, 'Stephen', 'Andy', 'fr.ird.observe.entities.referentiel.Country#1239832675593#0.3601938043845213'); -INSERT INTO observe_common.Person(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, dataSource, lastname, firstname, country) values ('fr.ird.observe.entities.referentiel.Person#666#02' , 0, CURRENT_DATE, CURRENT_TIMESTAMP, 1, false, true, 'Vidot', 'Agnes', 'fr.ird.observe.entities.referentiel.Country#1239832675593#0.3601938043845213'); -INSERT INTO observe_common.Person(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, dataSource, lastname, firstname, country) values ('fr.ird.observe.entities.referentiel.Person#666#03' , 0, CURRENT_DATE, CURRENT_TIMESTAMP, 1, false, true, 'Boniface', 'Breta', 'fr.ird.observe.entities.referentiel.Country#1239832675593#0.3601938043845213'); -INSERT INTO observe_common.Person(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, dataSource, lastname, firstname, country) values ('fr.ird.observe.entities.referentiel.Person#666#04' , 0, CURRENT_DATE, CURRENT_TIMESTAMP, 1, false, true, 'Theresine', 'Bernard', 'fr.ird.observe.entities.referentiel.Country#1239832675593#0.3601938043845213'); -INSERT INTO observe_common.Person(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, dataSource, lastname, firstname, country) values ('fr.ird.observe.entities.referentiel.Person#666#05' , 0, CURRENT_DATE, CURRENT_TIMESTAMP, 1, false, true, 'Valentin', 'Bahiri', 'fr.ird.observe.entities.referentiel.Country#1239832675593#0.3601938043845213'); -INSERT INTO observe_common.Person(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, dataSource, lastname, firstname, country) values ('fr.ird.observe.entities.referentiel.Person#666#06' , 0, CURRENT_DATE, CURRENT_TIMESTAMP, 1, false, true, 'Julienne', 'Cynthia', 'fr.ird.observe.entities.referentiel.Country#1239832675593#0.3601938043845213'); -INSERT INTO observe_common.Person(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, dataSource, lastname, firstname, country) values ('fr.ird.observe.entities.referentiel.Person#666#07' , 0, CURRENT_DATE, CURRENT_TIMESTAMP, 1, false, true, 'Melanie', 'Cindy', 'fr.ird.observe.entities.referentiel.Country#1239832675593#0.3601938043845213'); -INSERT INTO observe_common.Person(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, dataSource, lastname, firstname, country) values ('fr.ird.observe.entities.referentiel.Person#666#08' , 0, CURRENT_DATE, CURRENT_TIMESTAMP, 1, false, true, 'Sopha', 'Davis', 'fr.ird.observe.entities.referentiel.Country#1239832675593#0.3601938043845213'); -INSERT INTO observe_common.Person(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, dataSource, lastname, firstname, country) values ('fr.ird.observe.entities.referentiel.Person#666#09' , 0, CURRENT_DATE, CURRENT_TIMESTAMP, 1, false, true, 'Augustin', 'Emilie', 'fr.ird.observe.entities.referentiel.Country#1239832675593#0.3601938043845213'); -INSERT INTO observe_common.Person(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, dataSource, lastname, firstname, country) values ('fr.ird.observe.entities.referentiel.Person#666#10' , 0, CURRENT_DATE, CURRENT_TIMESTAMP, 1, false, true, 'Rose', 'Hendricka', 'fr.ird.observe.entities.referentiel.Country#1239832675593#0.3601938043845213'); -INSERT INTO observe_common.Person(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, dataSource, lastname, firstname, country) values ('fr.ird.observe.entities.referentiel.Person#666#11' , 0, CURRENT_DATE, CURRENT_TIMESTAMP, 1, false, true, 'Melanie', 'Julienne', 'fr.ird.observe.entities.referentiel.Country#1239832675593#0.3601938043845213'); -INSERT INTO observe_common.Person(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, dataSource, lastname, firstname, country) values ('fr.ird.observe.entities.referentiel.Person#666#12' , 0, CURRENT_DATE, CURRENT_TIMESTAMP, 1, false, true, 'Sinon', 'James', 'fr.ird.observe.entities.referentiel.Country#1239832675593#0.3601938043845213'); -INSERT INTO observe_common.Person(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, dataSource, lastname, firstname, country) values ('fr.ird.observe.entities.referentiel.Person#666#13' , 0, CURRENT_DATE, CURRENT_TIMESTAMP, 1, false, true, 'Sinon', 'Marie-Claire', 'fr.ird.observe.entities.referentiel.Country#1239832675593#0.3601938043845213'); -INSERT INTO observe_common.Person(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, dataSource, lastname, firstname, country) values ('fr.ird.observe.entities.referentiel.Person#666#14' , 0, CURRENT_DATE, CURRENT_TIMESTAMP, 1, false, true, 'Savy', 'Marie Stella', 'fr.ird.observe.entities.referentiel.Country#1239832675593#0.3601938043845213'); -INSERT INTO observe_common.Person(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, dataSource, lastname, firstname, country) values ('fr.ird.observe.entities.referentiel.Person#666#15' , 0, CURRENT_DATE, CURRENT_TIMESTAMP, 1, false, true, 'Bamboche', 'Nattyfa', 'fr.ird.observe.entities.referentiel.Country#1239832675593#0.3601938043845213'); -INSERT INTO observe_common.Person(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, dataSource, lastname, firstname, country) values ('fr.ird.observe.entities.referentiel.Person#666#16' , 0, CURRENT_DATE, CURRENT_TIMESTAMP, 1, false, true, 'Pothin', 'Nikita', 'fr.ird.observe.entities.referentiel.Country#1239832675593#0.3601938043845213'); -INSERT INTO observe_common.Person(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, dataSource, lastname, firstname, country) values ('fr.ird.observe.entities.referentiel.Person#666#17' , 0, CURRENT_DATE, CURRENT_TIMESTAMP, 1, false, true, 'Dogley', 'Ruby', 'fr.ird.observe.entities.referentiel.Country#1239832675593#0.3601938043845213'); -INSERT INTO observe_common.Person(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, dataSource, lastname, firstname, country) values ('fr.ird.observe.entities.referentiel.Person#666#18' , 0, CURRENT_DATE, CURRENT_TIMESTAMP, 1, false, true, 'Quatre', 'Ron', 'fr.ird.observe.entities.referentiel.Country#1239832675593#0.3601938043845213'); -INSERT INTO observe_common.Person(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, dataSource, lastname, firstname, country) values ('fr.ird.observe.entities.referentiel.Person#666#19' , 0, CURRENT_DATE, CURRENT_TIMESTAMP, 1, false, true, 'Ramkalawan', 'Relix', 'fr.ird.observe.entities.referentiel.Country#1239832675593#0.3601938043845213'); -INSERT INTO observe_common.Person(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, dataSource, lastname, firstname, country) values ('fr.ird.observe.entities.referentiel.Person#666#20' , 0, CURRENT_DATE, CURRENT_TIMESTAMP, 1, false, true, 'Claude', 'Samantha', 'fr.ird.observe.entities.referentiel.Country#1239832675593#0.3601938043845213'); -INSERT INTO observe_common.Person(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, dataSource, lastname, firstname, country) values ('fr.ird.observe.entities.referentiel.Person#666#21' , 0, CURRENT_DATE, CURRENT_TIMESTAMP, 1, false, true, 'Pillay', 'Sandra', 'fr.ird.observe.entities.referentiel.Country#1239832675593#0.3601938043845213'); -INSERT INTO observe_common.Person(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, dataSource, lastname, firstname, country) values ('fr.ird.observe.entities.referentiel.Person#666#22' , 0, CURRENT_DATE, CURRENT_TIMESTAMP, 1, false, true, 'Labrosse', 'Valentina', 'fr.ird.observe.entities.referentiel.Country#1239832675593#0.3601938043845213'); -INSERT INTO observe_common.Person(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, dataSource, lastname, firstname, country) values ('fr.ird.observe.entities.referentiel.Person#666#23' , 0, CURRENT_DATE, CURRENT_TIMESTAMP, 1, false, true, 'Lagrenade', 'Vanessa', 'fr.ird.observe.entities.referentiel.Country#1239832675593#0.3601938043845213'); -INSERT INTO observe_common.Person(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, dataSource, lastname, firstname, country) values ('fr.ird.observe.entities.referentiel.Person#666#24' , 0, CURRENT_DATE, CURRENT_TIMESTAMP, 1, false, true, 'Savy', 'Vincent', 'fr.ird.observe.entities.referentiel.Country#1239832675593#0.3601938043845213'); -INSERT INTO observe_common.Person(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, dataSource, lastname, firstname, country) values ('fr.ird.observe.entities.referentiel.Person#666#25' , 0, CURRENT_DATE, CURRENT_TIMESTAMP, 1, false, true, 'Perikanan', 'Pengawas', 'fr.ird.observe.entities.referentiel.Country#1239832675593#0.3601938043845213'); +INSERT INTO observe_common.Person(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, dataSource, lastname, firstname, country) values ('fr.ird.observe.entities.referentiel.Person#666#01' , 0, ${CURRENT_DATE}, ${CURRENT_TIMESTAMP}, 1, false, true, 'Stephen', 'Andy', 'fr.ird.observe.entities.referentiel.Country#1239832675593#0.3601938043845213'); +INSERT INTO observe_common.Person(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, dataSource, lastname, firstname, country) values ('fr.ird.observe.entities.referentiel.Person#666#02' , 0, ${CURRENT_DATE}, ${CURRENT_TIMESTAMP}, 1, false, true, 'Vidot', 'Agnes', 'fr.ird.observe.entities.referentiel.Country#1239832675593#0.3601938043845213'); +INSERT INTO observe_common.Person(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, dataSource, lastname, firstname, country) values ('fr.ird.observe.entities.referentiel.Person#666#03' , 0, ${CURRENT_DATE}, ${CURRENT_TIMESTAMP}, 1, false, true, 'Boniface', 'Breta', 'fr.ird.observe.entities.referentiel.Country#1239832675593#0.3601938043845213'); +INSERT INTO observe_common.Person(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, dataSource, lastname, firstname, country) values ('fr.ird.observe.entities.referentiel.Person#666#04' , 0, ${CURRENT_DATE}, ${CURRENT_TIMESTAMP}, 1, false, true, 'Theresine', 'Bernard', 'fr.ird.observe.entities.referentiel.Country#1239832675593#0.3601938043845213'); +INSERT INTO observe_common.Person(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, dataSource, lastname, firstname, country) values ('fr.ird.observe.entities.referentiel.Person#666#05' , 0, ${CURRENT_DATE}, ${CURRENT_TIMESTAMP}, 1, false, true, 'Valentin', 'Bahiri', 'fr.ird.observe.entities.referentiel.Country#1239832675593#0.3601938043845213'); +INSERT INTO observe_common.Person(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, dataSource, lastname, firstname, country) values ('fr.ird.observe.entities.referentiel.Person#666#06' , 0, ${CURRENT_DATE}, ${CURRENT_TIMESTAMP}, 1, false, true, 'Julienne', 'Cynthia', 'fr.ird.observe.entities.referentiel.Country#1239832675593#0.3601938043845213'); +INSERT INTO observe_common.Person(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, dataSource, lastname, firstname, country) values ('fr.ird.observe.entities.referentiel.Person#666#07' , 0, ${CURRENT_DATE}, ${CURRENT_TIMESTAMP}, 1, false, true, 'Melanie', 'Cindy', 'fr.ird.observe.entities.referentiel.Country#1239832675593#0.3601938043845213'); +INSERT INTO observe_common.Person(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, dataSource, lastname, firstname, country) values ('fr.ird.observe.entities.referentiel.Person#666#08' , 0, ${CURRENT_DATE}, ${CURRENT_TIMESTAMP}, 1, false, true, 'Sopha', 'Davis', 'fr.ird.observe.entities.referentiel.Country#1239832675593#0.3601938043845213'); +INSERT INTO observe_common.Person(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, dataSource, lastname, firstname, country) values ('fr.ird.observe.entities.referentiel.Person#666#09' , 0, ${CURRENT_DATE}, ${CURRENT_TIMESTAMP}, 1, false, true, 'Augustin', 'Emilie', 'fr.ird.observe.entities.referentiel.Country#1239832675593#0.3601938043845213'); +INSERT INTO observe_common.Person(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, dataSource, lastname, firstname, country) values ('fr.ird.observe.entities.referentiel.Person#666#10' , 0, ${CURRENT_DATE}, ${CURRENT_TIMESTAMP}, 1, false, true, 'Rose', 'Hendricka', 'fr.ird.observe.entities.referentiel.Country#1239832675593#0.3601938043845213'); +INSERT INTO observe_common.Person(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, dataSource, lastname, firstname, country) values ('fr.ird.observe.entities.referentiel.Person#666#11' , 0, ${CURRENT_DATE}, ${CURRENT_TIMESTAMP}, 1, false, true, 'Melanie', 'Julienne', 'fr.ird.observe.entities.referentiel.Country#1239832675593#0.3601938043845213'); +INSERT INTO observe_common.Person(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, dataSource, lastname, firstname, country) values ('fr.ird.observe.entities.referentiel.Person#666#12' , 0, ${CURRENT_DATE}, ${CURRENT_TIMESTAMP}, 1, false, true, 'Sinon', 'James', 'fr.ird.observe.entities.referentiel.Country#1239832675593#0.3601938043845213'); +INSERT INTO observe_common.Person(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, dataSource, lastname, firstname, country) values ('fr.ird.observe.entities.referentiel.Person#666#13' , 0, ${CURRENT_DATE}, ${CURRENT_TIMESTAMP}, 1, false, true, 'Sinon', 'Marie-Claire', 'fr.ird.observe.entities.referentiel.Country#1239832675593#0.3601938043845213'); +INSERT INTO observe_common.Person(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, dataSource, lastname, firstname, country) values ('fr.ird.observe.entities.referentiel.Person#666#14' , 0, ${CURRENT_DATE}, ${CURRENT_TIMESTAMP}, 1, false, true, 'Savy', 'Marie Stella', 'fr.ird.observe.entities.referentiel.Country#1239832675593#0.3601938043845213'); +INSERT INTO observe_common.Person(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, dataSource, lastname, firstname, country) values ('fr.ird.observe.entities.referentiel.Person#666#15' , 0, ${CURRENT_DATE}, ${CURRENT_TIMESTAMP}, 1, false, true, 'Bamboche', 'Nattyfa', 'fr.ird.observe.entities.referentiel.Country#1239832675593#0.3601938043845213'); +INSERT INTO observe_common.Person(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, dataSource, lastname, firstname, country) values ('fr.ird.observe.entities.referentiel.Person#666#16' , 0, ${CURRENT_DATE}, ${CURRENT_TIMESTAMP}, 1, false, true, 'Pothin', 'Nikita', 'fr.ird.observe.entities.referentiel.Country#1239832675593#0.3601938043845213'); +INSERT INTO observe_common.Person(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, dataSource, lastname, firstname, country) values ('fr.ird.observe.entities.referentiel.Person#666#17' , 0, ${CURRENT_DATE}, ${CURRENT_TIMESTAMP}, 1, false, true, 'Dogley', 'Ruby', 'fr.ird.observe.entities.referentiel.Country#1239832675593#0.3601938043845213'); +INSERT INTO observe_common.Person(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, dataSource, lastname, firstname, country) values ('fr.ird.observe.entities.referentiel.Person#666#18' , 0, ${CURRENT_DATE}, ${CURRENT_TIMESTAMP}, 1, false, true, 'Quatre', 'Ron', 'fr.ird.observe.entities.referentiel.Country#1239832675593#0.3601938043845213'); +INSERT INTO observe_common.Person(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, dataSource, lastname, firstname, country) values ('fr.ird.observe.entities.referentiel.Person#666#19' , 0, ${CURRENT_DATE}, ${CURRENT_TIMESTAMP}, 1, false, true, 'Ramkalawan', 'Relix', 'fr.ird.observe.entities.referentiel.Country#1239832675593#0.3601938043845213'); +INSERT INTO observe_common.Person(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, dataSource, lastname, firstname, country) values ('fr.ird.observe.entities.referentiel.Person#666#20' , 0, ${CURRENT_DATE}, ${CURRENT_TIMESTAMP}, 1, false, true, 'Claude', 'Samantha', 'fr.ird.observe.entities.referentiel.Country#1239832675593#0.3601938043845213'); +INSERT INTO observe_common.Person(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, dataSource, lastname, firstname, country) values ('fr.ird.observe.entities.referentiel.Person#666#21' , 0, ${CURRENT_DATE}, ${CURRENT_TIMESTAMP}, 1, false, true, 'Pillay', 'Sandra', 'fr.ird.observe.entities.referentiel.Country#1239832675593#0.3601938043845213'); +INSERT INTO observe_common.Person(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, dataSource, lastname, firstname, country) values ('fr.ird.observe.entities.referentiel.Person#666#22' , 0, ${CURRENT_DATE}, ${CURRENT_TIMESTAMP}, 1, false, true, 'Labrosse', 'Valentina', 'fr.ird.observe.entities.referentiel.Country#1239832675593#0.3601938043845213'); +INSERT INTO observe_common.Person(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, dataSource, lastname, firstname, country) values ('fr.ird.observe.entities.referentiel.Person#666#23' , 0, ${CURRENT_DATE}, ${CURRENT_TIMESTAMP}, 1, false, true, 'Lagrenade', 'Vanessa', 'fr.ird.observe.entities.referentiel.Country#1239832675593#0.3601938043845213'); +INSERT INTO observe_common.Person(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, dataSource, lastname, firstname, country) values ('fr.ird.observe.entities.referentiel.Person#666#24' , 0, ${CURRENT_DATE}, ${CURRENT_TIMESTAMP}, 1, false, true, 'Savy', 'Vincent', 'fr.ird.observe.entities.referentiel.Country#1239832675593#0.3601938043845213'); +INSERT INTO observe_common.Person(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, dataSource, lastname, firstname, country) values ('fr.ird.observe.entities.referentiel.Person#666#25' , 0, ${CURRENT_DATE}, ${CURRENT_TIMESTAMP}, 1, false, true, 'Perikanan', 'Pengawas', 'fr.ird.observe.entities.referentiel.Country#1239832675593#0.3601938043845213'); ===================================== persistence/src/main/resources/db/migration/8.0/05_rename_tripType-common.sql ===================================== @@ -24,7 +24,7 @@ UPDATE OBSERVE_COMMON.LASTUPDATEDATE SET TYPE = replace(TYPE, '.longline.TripTyp ALTER TABLE OBSERVE_LONGLINE.TripType RENAME TO ObservationMethod; ALTER TABLE observe_longline.ObservationMethod ADD CONSTRAINT PK_ObservationMethod PRIMARY KEY(topiaid); UPDATE OBSERVE_LONGLINE.ObservationMethod SET TOPIAVERSION = TOPIAVERSION + 1; -UPDATE OBSERVE_COMMON.LASTUPDATEDATE SET LASTUPDATEDATE = CURRENT_TIMESTAMP WHERE TYPE ='fr.ird.observe.entities.referentiel.longline.ObservationMethod'; +UPDATE OBSERVE_COMMON.LASTUPDATEDATE SET LASTUPDATEDATE = ${CURRENT_TIMESTAMP} WHERE TYPE ='fr.ird.observe.entities.referentiel.longline.ObservationMethod'; DROP INDEX IF EXISTS idx_observe_longline_trip_tripType; UPDATE OBSERVE_LONGLINE.Trip SET tripType = replace(tripType, '.TripType', '.ObservationMethod'); ===================================== persistence/src/main/resources/db/migration/8.0/06_fill_vessel_activity-common.sql ===================================== @@ -19,11 +19,11 @@ -- <http://www.gnu.org/licenses/gpl-3.0.html>. -- #L% --- -INSERT INTO observe_longline.vesselactivity(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, code, label1, label2, label3) values ('fr.ird.observe.entities.referentiel.longline.VesselActivityLongline#666#01' , 0, CURRENT_DATE, CURRENT_TIMESTAMP, 1, false, 'CRUISE', 'Cruising', 'Route','Route #TODO'); -INSERT INTO observe_longline.vesselactivity(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, code, label1, label2, label3) values ('fr.ird.observe.entities.referentiel.longline.VesselActivityLongline#666#02' , 0, CURRENT_DATE, CURRENT_TIMESTAMP, 1, false, 'DRIFT', 'Drifting', 'En dérive','En dérive #TODO'); -INSERT INTO observe_longline.vesselactivity(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, code, label1, label2, label3) values ('fr.ird.observe.entities.referentiel.longline.VesselActivityLongline#666#03' , 0, CURRENT_DATE, CURRENT_TIMESTAMP, 1, false, 'PORT', 'At port', 'Au port','Au port #TODO'); -INSERT INTO observe_longline.vesselactivity(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, code, label1, label2, label3) values ('fr.ird.observe.entities.referentiel.longline.VesselActivityLongline#666#04' , 0, CURRENT_DATE, CURRENT_TIMESTAMP, 1, false, 'OUTZEE', 'Out of national EEZ', 'Hors ZEE nationale','Hors ZEE nationale #TODO'); -INSERT INTO observe_longline.vesselactivity(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, code, label1, label2, label3) values ('fr.ird.observe.entities.referentiel.longline.VesselActivityLongline#666#05' , 0, CURRENT_DATE, CURRENT_TIMESTAMP, 1, false, 'REPAIR', 'Under repair', 'En réparation','En réparation #TODO'); -INSERT INTO observe_longline.vesselactivity(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, code, label1, label2, label3) values ('fr.ird.observe.entities.referentiel.longline.VesselActivityLongline#666#06' , 0, CURRENT_DATE, CURRENT_TIMESTAMP, 1, false, 'TRANSSHIP', 'Transshipment', 'Transbordement','Transbordement #TODO'); -INSERT INTO observe_longline.vesselactivity(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, code, label1, label2, label3) values ('fr.ird.observe.entities.referentiel.longline.VesselActivityLongline#666#07' , 0, CURRENT_DATE, CURRENT_TIMESTAMP, 1, false, 'UNK', 'Unknown', 'Inconnue','Inconnue #TODO'); -UPDATE OBSERVE_COMMON.LASTUPDATEDATE SET LASTUPDATEDATE = CURRENT_TIMESTAMP WHERE TYPE ='fr.ird.observe.entities.referentiel.longline.VesselActivityLongline'; +INSERT INTO observe_longline.vesselactivity(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, code, label1, label2, label3) values ('fr.ird.observe.entities.referentiel.longline.VesselActivityLongline#666#01' , 0, ${CURRENT_DATE}, ${CURRENT_TIMESTAMP}, 1, false, 'CRUISE', 'Cruising', 'Route','Route #TODO'); +INSERT INTO observe_longline.vesselactivity(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, code, label1, label2, label3) values ('fr.ird.observe.entities.referentiel.longline.VesselActivityLongline#666#02' , 0, ${CURRENT_DATE}, ${CURRENT_TIMESTAMP}, 1, false, 'DRIFT', 'Drifting', 'En dérive','En dérive #TODO'); +INSERT INTO observe_longline.vesselactivity(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, code, label1, label2, label3) values ('fr.ird.observe.entities.referentiel.longline.VesselActivityLongline#666#03' , 0, ${CURRENT_DATE}, ${CURRENT_TIMESTAMP}, 1, false, 'PORT', 'At port', 'Au port','Au port #TODO'); +INSERT INTO observe_longline.vesselactivity(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, code, label1, label2, label3) values ('fr.ird.observe.entities.referentiel.longline.VesselActivityLongline#666#04' , 0, ${CURRENT_DATE}, ${CURRENT_TIMESTAMP}, 1, false, 'OUTZEE', 'Out of national EEZ', 'Hors ZEE nationale','Hors ZEE nationale #TODO'); +INSERT INTO observe_longline.vesselactivity(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, code, label1, label2, label3) values ('fr.ird.observe.entities.referentiel.longline.VesselActivityLongline#666#05' , 0, ${CURRENT_DATE}, ${CURRENT_TIMESTAMP}, 1, false, 'REPAIR', 'Under repair', 'En réparation','En réparation #TODO'); +INSERT INTO observe_longline.vesselactivity(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, code, label1, label2, label3) values ('fr.ird.observe.entities.referentiel.longline.VesselActivityLongline#666#06' , 0, ${CURRENT_DATE}, ${CURRENT_TIMESTAMP}, 1, false, 'TRANSSHIP', 'Transshipment', 'Transbordement','Transbordement #TODO'); +INSERT INTO observe_longline.vesselactivity(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, code, label1, label2, label3) values ('fr.ird.observe.entities.referentiel.longline.VesselActivityLongline#666#07' , 0, ${CURRENT_DATE}, ${CURRENT_TIMESTAMP}, 1, false, 'UNK', 'Unknown', 'Inconnue','Inconnue #TODO'); +UPDATE OBSERVE_COMMON.LASTUPDATEDATE SET LASTUPDATEDATE = ${CURRENT_TIMESTAMP} WHERE TYPE ='fr.ird.observe.entities.referentiel.longline.VesselActivityLongline'; ===================================== persistence/src/main/resources/db/migration/8.0/07_add_weight_determination_method-common.sql ===================================== @@ -21,4 +21,4 @@ --- CREATE TABLE observe_longline.WeightDeterminationMethod(topiaid VARCHAR(255) NOT NULL,topiaversion BIGINT NOT NULL, topiacreatedate DATE, lastupdatedate TIMESTAMP NOT NULL, code VARCHAR(255), status INTEGER DEFAULT 1, needComment BOOLEAN DEFAULT false, uri VARCHAR(255), label1 VARCHAR(255), label2 VARCHAR(255), label3 VARCHAR(255),label4 VARCHAR(255),label5 VARCHAR(255),label6 VARCHAR(255),label7 VARCHAR(255),label8 VARCHAR(255)); ALTER TABLE observe_longline.WeightDeterminationMethod ADD CONSTRAINT PK_WeightDeterminationMethod PRIMARY KEY(topiaid); -INSERT INTO observe_common.LASTUPDATEDATE(topiaId, topiaversion, topiacreatedate, TYPE , LASTUPDATEDATE) values ('fr.ird.observe.entities.LastUpdateDate#666#1004', 0,CURRENT_DATE, 'fr.ird.observe.entities.referentiel.longline.WeightDeterminationMethod', CURRENT_TIMESTAMP); +INSERT INTO observe_common.LASTUPDATEDATE(topiaId, topiaversion, topiacreatedate, TYPE , LASTUPDATEDATE) values ('fr.ird.observe.entities.LastUpdateDate#666#1004', 0,${CURRENT_DATE}, 'fr.ird.observe.entities.referentiel.longline.WeightDeterminationMethod', ${CURRENT_TIMESTAMP}); ===================================== persistence/src/main/resources/db/migration/8.0/08_add_weight_category-common.sql ===================================== @@ -21,4 +21,4 @@ --- CREATE TABLE observe_longline.WeightCategory(topiaid VARCHAR(255) NOT NULL,topiaversion BIGINT NOT NULL, topiacreatedate DATE, lastupdatedate TIMESTAMP NOT NULL, code VARCHAR(255), status INTEGER DEFAULT 1, needComment BOOLEAN DEFAULT false, uri VARCHAR(255), label1 VARCHAR(255), label2 VARCHAR(255), label3 VARCHAR(255),label4 VARCHAR(255),label5 VARCHAR(255),label6 VARCHAR(255),label7 VARCHAR(255),label8 VARCHAR(255)); ALTER TABLE observe_longline.WeightCategory ADD CONSTRAINT PK_WeightCategory PRIMARY KEY(topiaid); -INSERT INTO observe_common.LASTUPDATEDATE(topiaId, topiaversion, topiacreatedate, TYPE , LASTUPDATEDATE) values ('fr.ird.observe.entities.LastUpdateDate#666#1005', 0,CURRENT_DATE, 'fr.ird.observe.entities.referentiel.longline.WeightCategoryLongline', CURRENT_TIMESTAMP); +INSERT INTO observe_common.LASTUPDATEDATE(topiaId, topiaversion, topiacreatedate, TYPE , LASTUPDATEDATE) values ('fr.ird.observe.entities.LastUpdateDate#666#1005', 0,${CURRENT_DATE}, 'fr.ird.observe.entities.referentiel.longline.WeightCategoryLongline', ${CURRENT_TIMESTAMP}); ===================================== persistence/src/main/resources/db/migration/8.0/09_add_compagnies-common.sql ===================================== @@ -21,4 +21,4 @@ --- CREATE TABLE observe_common.Compagnies(topiaid VARCHAR(255) NOT NULL,topiaversion BIGINT NOT NULL, topiacreatedate DATE, lastupdatedate TIMESTAMP NOT NULL, code VARCHAR(255), status INTEGER DEFAULT 1, needComment BOOLEAN DEFAULT false, uri VARCHAR(255), label1 VARCHAR(255), label2 VARCHAR(255), label3 VARCHAR(255),label4 VARCHAR(255),label5 VARCHAR(255),label6 VARCHAR(255),label7 VARCHAR(255),label8 VARCHAR(255)); ALTER TABLE observe_common.Compagnies ADD CONSTRAINT PK_Compagnies PRIMARY KEY(topiaid); -INSERT INTO observe_common.LASTUPDATEDATE(topiaId, topiaversion, topiacreatedate, TYPE , LASTUPDATEDATE) values ('fr.ird.observe.entities.LastUpdateDate#666#1006', 0,CURRENT_DATE, 'fr.ird.observe.entities.referentiel.Compagnies', CURRENT_TIMESTAMP); +INSERT INTO observe_common.LASTUPDATEDATE(topiaId, topiaversion, topiacreatedate, TYPE , LASTUPDATEDATE) values ('fr.ird.observe.entities.LastUpdateDate#666#1006', 0,${CURRENT_DATE}, 'fr.ird.observe.entities.referentiel.Compagnies', ${CURRENT_TIMESTAMP}); ===================================== persistence/src/main/resources/db/migration/8.0/10_add_length_measure_method-common.sql ===================================== @@ -21,12 +21,12 @@ --- CREATE TABLE observe_common.LengthMeasureMethod(topiaid VARCHAR(255) NOT NULL,topiaversion BIGINT NOT NULL, topiacreatedate DATE, lastupdatedate TIMESTAMP NOT NULL, code VARCHAR(255), status INTEGER DEFAULT 1, needComment BOOLEAN DEFAULT false, uri VARCHAR(255), label1 VARCHAR(255), label2 VARCHAR(255), label3 VARCHAR(255),label4 VARCHAR(255),label5 VARCHAR(255),label6 VARCHAR(255),label7 VARCHAR(255),label8 VARCHAR(255)); ALTER TABLE observe_common.LengthMeasureMethod ADD CONSTRAINT PK_LengthMeasureMethod PRIMARY KEY(topiaid); -INSERT INTO observe_common.LASTUPDATEDATE(topiaId, topiaversion, topiacreatedate, TYPE , LASTUPDATEDATE) values ('fr.ird.observe.entities.LastUpdateDate#666#1007', 0,CURRENT_DATE, 'fr.ird.observe.entities.referentiel.LengthMeasureMethod', CURRENT_TIMESTAMP); +INSERT INTO observe_common.LASTUPDATEDATE(topiaId, topiaversion, topiacreatedate, TYPE , LASTUPDATEDATE) values ('fr.ird.observe.entities.LastUpdateDate#666#1007', 0,${CURRENT_DATE}, 'fr.ird.observe.entities.referentiel.LengthMeasureMethod', ${CURRENT_TIMESTAMP}); -INSERT INTO observe_common.LengthMeasureMethod(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, label1, label2, label3) values ('fr.ird.observe.entities.referentiel.LengthMeasureMethod#666#01' , 0, CURRENT_DATE, CURRENT_TIMESTAMP, 1, false, 'Caliper', 'Pied à coulisse', 'Pied à coulisse #TODO'); -INSERT INTO observe_common.LengthMeasureMethod(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, label1, label2, label3) values ('fr.ird.observe.entities.referentiel.LengthMeasureMethod#666#02' , 0, CURRENT_DATE, CURRENT_TIMESTAMP, 1, false, 'Ruler', 'Règle', 'Règle #TODO'); -INSERT INTO observe_common.LengthMeasureMethod(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, label1, label2, label3) values ('fr.ird.observe.entities.referentiel.LengthMeasureMethod#666#03' , 0, CURRENT_DATE, CURRENT_TIMESTAMP, 1, false, 'Mesuring tape', 'Mètre ruban', 'Mètre ruban #TODO'); -INSERT INTO observe_common.LengthMeasureMethod(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, label1, label2, label3) values ('fr.ird.observe.entities.referentiel.LengthMeasureMethod#666#04' , 0, CURRENT_DATE, CURRENT_TIMESTAMP, 1, false, 'Visual estimation', 'Estimation visuelle', 'Estimation visuelle #TODO'); +INSERT INTO observe_common.LengthMeasureMethod(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, label1, label2, label3) values ('fr.ird.observe.entities.referentiel.LengthMeasureMethod#666#01' , 0, ${CURRENT_DATE}, ${CURRENT_TIMESTAMP}, 1, false, 'Caliper', 'Pied à coulisse', 'Pied à coulisse #TODO'); +INSERT INTO observe_common.LengthMeasureMethod(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, label1, label2, label3) values ('fr.ird.observe.entities.referentiel.LengthMeasureMethod#666#02' , 0, ${CURRENT_DATE}, ${CURRENT_TIMESTAMP}, 1, false, 'Ruler', 'Règle', 'Règle #TODO'); +INSERT INTO observe_common.LengthMeasureMethod(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, label1, label2, label3) values ('fr.ird.observe.entities.referentiel.LengthMeasureMethod#666#03' , 0, ${CURRENT_DATE}, ${CURRENT_TIMESTAMP}, 1, false, 'Mesuring tape', 'Mètre ruban', 'Mètre ruban #TODO'); +INSERT INTO observe_common.LengthMeasureMethod(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, label1, label2, label3) values ('fr.ird.observe.entities.referentiel.LengthMeasureMethod#666#04' , 0, ${CURRENT_DATE}, ${CURRENT_TIMESTAMP}, 1, false, 'Visual estimation', 'Estimation visuelle', 'Estimation visuelle #TODO'); ALTER TABLE observe_seine.nontargetcatch ADD COLUMN lengthMeasureMethod VARCHAR(255); ALTER TABLE observe_seine.nontargetcatchrelease ADD COLUMN lengthMeasureMethod VARCHAR(255); ===================================== persistence/src/main/resources/db/migration/8.0/11_add_weight_measure_method-common.sql ===================================== @@ -21,12 +21,12 @@ --- CREATE TABLE observe_common.WeightMeasureMethod(topiaid VARCHAR(255) NOT NULL,topiaversion BIGINT NOT NULL, topiacreatedate DATE, lastupdatedate TIMESTAMP NOT NULL, code VARCHAR(255), status INTEGER DEFAULT 1, needComment BOOLEAN DEFAULT false, uri VARCHAR(255), label1 VARCHAR(255), label2 VARCHAR(255), label3 VARCHAR(255),label4 VARCHAR(255),label5 VARCHAR(255),label6 VARCHAR(255),label7 VARCHAR(255),label8 VARCHAR(255)); ALTER TABLE observe_common.WeightMeasureMethod ADD CONSTRAINT PK_WeightMeasureMethod PRIMARY KEY(topiaid); -INSERT INTO observe_common.LASTUPDATEDATE(topiaId, topiaversion, topiacreatedate, TYPE , LASTUPDATEDATE) values ('fr.ird.observe.entities.LastUpdateDate#666#1008', 0,CURRENT_DATE, 'fr.ird.observe.entities.referentiel.WeightMeasureMethod', CURRENT_TIMESTAMP); +INSERT INTO observe_common.LASTUPDATEDATE(topiaId, topiaversion, topiacreatedate, TYPE , LASTUPDATEDATE) values ('fr.ird.observe.entities.LastUpdateDate#666#1008', 0,${CURRENT_DATE}, 'fr.ird.observe.entities.referentiel.WeightMeasureMethod', ${CURRENT_TIMESTAMP}); -INSERT INTO observe_common.WeightMeasureMethod(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, label1, label2, label3) values ('fr.ird.observe.entities.referentiel.WeightMeasureMethod#666#01' , 0, CURRENT_DATE, CURRENT_TIMESTAMP, 1, false, 'Hanging scale', 'Peson', 'Dinamómetro'); -INSERT INTO observe_common.WeightMeasureMethod(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, label1, label2, label3) values ('fr.ird.observe.entities.referentiel.WeightMeasureMethod#666#02' , 0, CURRENT_DATE, CURRENT_TIMESTAMP, 1, false, 'Weighting Scale', 'Balance', 'Balanza'); -INSERT INTO observe_common.WeightMeasureMethod(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, label1, label2, label3) values ('fr.ird.observe.entities.referentiel.WeightMeasureMethod#666#03' , 0, CURRENT_DATE, CURRENT_TIMESTAMP, 1, false, 'Visual estimate', 'Estimation visuelle', 'Estimación visual'); -INSERT INTO observe_common.WeightMeasureMethod(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, label1, label2, label3) values ('fr.ird.observe.entities.referentiel.WeightMeasureMethod#666#04' , 0, CURRENT_DATE, CURRENT_TIMESTAMP, 1, false, 'Estimate with sounder', 'Estimation au sondeur', 'Estimación con la ecosonda'); +INSERT INTO observe_common.WeightMeasureMethod(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, label1, label2, label3) values ('fr.ird.observe.entities.referentiel.WeightMeasureMethod#666#01' , 0, ${CURRENT_DATE}, ${CURRENT_TIMESTAMP}, 1, false, 'Hanging scale', 'Peson', 'Dinamómetro'); +INSERT INTO observe_common.WeightMeasureMethod(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, label1, label2, label3) values ('fr.ird.observe.entities.referentiel.WeightMeasureMethod#666#02' , 0, ${CURRENT_DATE}, ${CURRENT_TIMESTAMP}, 1, false, 'Weighting Scale', 'Balance', 'Balanza'); +INSERT INTO observe_common.WeightMeasureMethod(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, label1, label2, label3) values ('fr.ird.observe.entities.referentiel.WeightMeasureMethod#666#03' , 0, ${CURRENT_DATE}, ${CURRENT_TIMESTAMP}, 1, false, 'Visual estimate', 'Estimation visuelle', 'Estimación visual'); +INSERT INTO observe_common.WeightMeasureMethod(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, label1, label2, label3) values ('fr.ird.observe.entities.referentiel.WeightMeasureMethod#666#04' , 0, ${CURRENT_DATE}, ${CURRENT_TIMESTAMP}, 1, false, 'Estimate with sounder', 'Estimation au sondeur', 'Estimación con la ecosonda'); ALTER TABLE observe_seine.nontargetcatch ADD COLUMN weightMeasureMethod VARCHAR(255); ALTER TABLE observe_seine.nontargetlength ADD COLUMN weightMeasureMethod VARCHAR(255); ===================================== persistence/src/main/resources/db/migration/8.0/12_add_conservation-common.sql ===================================== @@ -22,8 +22,8 @@ CREATE TABLE observe_longline.Conservation(topiaid VARCHAR(255) NOT NULL,topiaversion BIGINT NOT NULL, topiacreatedate DATE, lastupdatedate TIMESTAMP NOT NULL, code VARCHAR(255), status INTEGER DEFAULT 1, needComment BOOLEAN DEFAULT false, uri VARCHAR(255), label1 VARCHAR(255), label2 VARCHAR(255), label3 VARCHAR(255),label4 VARCHAR(255),label5 VARCHAR(255),label6 VARCHAR(255),label7 VARCHAR(255),label8 VARCHAR(255)); ALTER TABLE observe_longline.Conservation ADD CONSTRAINT PK_Conservation PRIMARY KEY(topiaid); -INSERT INTO observe_longline.Conservation(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, code, label1, label2, label3) values ('fr.ird.observe.entities.referentiel.longline.Conservation#666#01' , 0, CURRENT_DATE, CURRENT_TIMESTAMP, 1, false, 'FRESH', 'Fresh', 'Frais', 'Frais #TODO'); -INSERT INTO observe_longline.Conservation(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, code, label1, label2, label3) values ('fr.ird.observe.entities.referentiel.longline.Conservation#666#02' , 0, CURRENT_DATE, CURRENT_TIMESTAMP, 1, false, 'FROZEN', 'Frozen', 'Congelé', 'Congelé #TODO'); -INSERT INTO observe_longline.Conservation(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, code, label1, label2, label3) values ('fr.ird.observe.entities.referentiel.longline.Conservation#666#03' , 0, CURRENT_DATE, CURRENT_TIMESTAMP, 1, false, 'DRIED', 'Dried', 'Séché', 'Secado'); +INSERT INTO observe_longline.Conservation(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, code, label1, label2, label3) values ('fr.ird.observe.entities.referentiel.longline.Conservation#666#01' , 0, ${CURRENT_DATE}, ${CURRENT_TIMESTAMP}, 1, false, 'FRESH', 'Fresh', 'Frais', 'Frais #TODO'); +INSERT INTO observe_longline.Conservation(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, code, label1, label2, label3) values ('fr.ird.observe.entities.referentiel.longline.Conservation#666#02' , 0, ${CURRENT_DATE}, ${CURRENT_TIMESTAMP}, 1, false, 'FROZEN', 'Frozen', 'Congelé', 'Congelé #TODO'); +INSERT INTO observe_longline.Conservation(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, code, label1, label2, label3) values ('fr.ird.observe.entities.referentiel.longline.Conservation#666#03' , 0, ${CURRENT_DATE}, ${CURRENT_TIMESTAMP}, 1, false, 'DRIED', 'Dried', 'Séché', 'Secado'); -INSERT INTO observe_common.LASTUPDATEDATE(topiaId, topiaversion, topiacreatedate, TYPE , LASTUPDATEDATE) values ('fr.ird.observe.entities.LastUpdateDate#666#1009', 0,CURRENT_DATE, 'fr.ird.observe.entities.referentiel.longline.Conservation', CURRENT_TIMESTAMP); +INSERT INTO observe_common.LASTUPDATEDATE(topiaId, topiaversion, topiacreatedate, TYPE , LASTUPDATEDATE) values ('fr.ird.observe.entities.LastUpdateDate#666#1009', 0,${CURRENT_DATE}, 'fr.ird.observe.entities.referentiel.longline.Conservation', ${CURRENT_TIMESTAMP}); ===================================== persistence/src/main/resources/db/migration/8.0/13_add_on_board_processing-common.sql ===================================== @@ -21,10 +21,10 @@ --- CREATE TABLE observe_longline.OnBoardProcessing(topiaid VARCHAR(255) NOT NULL,topiaversion BIGINT NOT NULL, topiacreatedate DATE, lastupdatedate TIMESTAMP NOT NULL, code VARCHAR(255), status INTEGER DEFAULT 1, needComment BOOLEAN DEFAULT false, uri VARCHAR(255), label1 VARCHAR(255), label2 VARCHAR(255), label3 VARCHAR(255),label4 VARCHAR(255),label5 VARCHAR(255),label6 VARCHAR(255),label7 VARCHAR(255),label8 VARCHAR(255)); ALTER TABLE observe_longline.OnBoardProcessing ADD CONSTRAINT PK_OnBoardProcessing PRIMARY KEY(topiaid); -INSERT INTO observe_common.LASTUPDATEDATE(topiaId, topiaversion, topiacreatedate, TYPE , LASTUPDATEDATE) values ('fr.ird.observe.entities.LastUpdateDate#666#1010', 0,CURRENT_DATE, 'fr.ird.observe.entities.referentiel.longline.OnBoardProcessing', CURRENT_TIMESTAMP); +INSERT INTO observe_common.LASTUPDATEDATE(topiaId, topiaversion, topiacreatedate, TYPE , LASTUPDATEDATE) values ('fr.ird.observe.entities.LastUpdateDate#666#1010', 0,${CURRENT_DATE}, 'fr.ird.observe.entities.referentiel.longline.OnBoardProcessing', ${CURRENT_TIMESTAMP}); -INSERT INTO observe_longline.OnBoardProcessing(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, code, label1, label2, label3) values ('fr.ird.observe.entities.referentiel.longline.OnBoardProcessing#666#01' , 0, CURRENT_DATE, CURRENT_TIMESTAMP, 1, false, 'WL', 'Whole fish', 'Poisson entier', 'Poisson entier #TODO'); -INSERT INTO observe_longline.OnBoardProcessing(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, code, label1, label2, label3) values ('fr.ird.observe.entities.referentiel.longline.OnBoardProcessing#666#02' , 0, CURRENT_DATE, CURRENT_TIMESTAMP, 1, false, 'H', 'Headed', 'Etêté', 'Etêté #TODO'); -INSERT INTO observe_longline.OnBoardProcessing(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, code, label1, label2, label3) values ('fr.ird.observe.entities.referentiel.longline.OnBoardProcessing#666#03' , 0, CURRENT_DATE, CURRENT_TIMESTAMP, 1, false, 'HG', 'Headed and gutted', 'Etêté et vidé', 'Etêté et vidé #TODO'); -INSERT INTO observe_longline.OnBoardProcessing(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, code, label1, label2, label3) values ('fr.ird.observe.entities.referentiel.longline.OnBoardProcessing#666#04' , 0, CURRENT_DATE, CURRENT_TIMESTAMP, 1, false, 'GG', 'Gilled and gutted', 'Vidé et sans branchies', 'Vidé et sans branchies #TODO'); -INSERT INTO observe_longline.OnBoardProcessing(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, code, label1, label2, label3) values ('fr.ird.observe.entities.referentiel.longline.OnBoardProcessing#666#05' , 0, CURRENT_DATE, CURRENT_TIMESTAMP, 1, false, 'L', 'Loins', 'Longes', 'Longes #TODO'); +INSERT INTO observe_longline.OnBoardProcessing(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, code, label1, label2, label3) values ('fr.ird.observe.entities.referentiel.longline.OnBoardProcessing#666#01' , 0, ${CURRENT_DATE}, ${CURRENT_TIMESTAMP}, 1, false, 'WL', 'Whole fish', 'Poisson entier', 'Poisson entier #TODO'); +INSERT INTO observe_longline.OnBoardProcessing(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, code, label1, label2, label3) values ('fr.ird.observe.entities.referentiel.longline.OnBoardProcessing#666#02' , 0, ${CURRENT_DATE}, ${CURRENT_TIMESTAMP}, 1, false, 'H', 'Headed', 'Etêté', 'Etêté #TODO'); +INSERT INTO observe_longline.OnBoardProcessing(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, code, label1, label2, label3) values ('fr.ird.observe.entities.referentiel.longline.OnBoardProcessing#666#03' , 0, ${CURRENT_DATE}, ${CURRENT_TIMESTAMP}, 1, false, 'HG', 'Headed and gutted', 'Etêté et vidé', 'Etêté et vidé #TODO'); +INSERT INTO observe_longline.OnBoardProcessing(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, code, label1, label2, label3) values ('fr.ird.observe.entities.referentiel.longline.OnBoardProcessing#666#04' , 0, ${CURRENT_DATE}, ${CURRENT_TIMESTAMP}, 1, false, 'GG', 'Gilled and gutted', 'Vidé et sans branchies', 'Vidé et sans branchies #TODO'); +INSERT INTO observe_longline.OnBoardProcessing(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, code, label1, label2, label3) values ('fr.ird.observe.entities.referentiel.longline.OnBoardProcessing#666#05' , 0, ${CURRENT_DATE}, ${CURRENT_TIMESTAMP}, 1, false, 'L', 'Loins', 'Longes', 'Longes #TODO'); ===================================== persistence/src/main/resources/db/migration/8.0/14_add_data_source-common.sql ===================================== @@ -21,25 +21,25 @@ --- CREATE TABLE observe_longline.DataSource(topiaid VARCHAR(255) NOT NULL,topiaversion BIGINT NOT NULL, topiacreatedate DATE, lastupdatedate TIMESTAMP NOT NULL, code VARCHAR(255), status INTEGER DEFAULT 1, needComment BOOLEAN DEFAULT false, uri VARCHAR(255), label1 VARCHAR(255), label2 VARCHAR(255), label3 VARCHAR(255),label4 VARCHAR(255),label5 VARCHAR(255),label6 VARCHAR(255),label7 VARCHAR(255),label8 VARCHAR(255)); ALTER TABLE observe_longline.DataSource ADD CONSTRAINT PK_DataSource PRIMARY KEY(topiaid); -INSERT INTO observe_common.LASTUPDATEDATE(topiaId, topiaversion, topiacreatedate, TYPE , LASTUPDATEDATE) values ('fr.ird.observe.entities.LastUpdateDate#666#1011', 0,CURRENT_DATE, 'fr.ird.observe.entities.referentiel.longline.DataSource', CURRENT_TIMESTAMP); +INSERT INTO observe_common.LASTUPDATEDATE(topiaId, topiaversion, topiacreatedate, TYPE , LASTUPDATEDATE) values ('fr.ird.observe.entities.LastUpdateDate#666#1011', 0,${CURRENT_DATE}, 'fr.ird.observe.entities.referentiel.longline.DataSource', ${CURRENT_TIMESTAMP}); -INSERT INTO observe_longline.DataSource(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, label1, label2, label3) values ('fr.ird.observe.entities.referentiel.longline.DataSource#666#01' , 0, CURRENT_DATE, CURRENT_TIMESTAMP, 1, false,'Customs' ,'Douanes', 'Douanes #TODO'); -INSERT INTO observe_longline.DataSource(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, label1, label2, label3) values ('fr.ird.observe.entities.referentiel.longline.DataSource#666#02' , 0, CURRENT_DATE, CURRENT_TIMESTAMP, 1, false,'Auto-Calculated from Database Logbooks' ,'Auto-calculé depuis la BDD logbooks', 'Auto-calculé depuis la BDD logbooks #TODO'); -INSERT INTO observe_longline.DataSource(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, label1, label2, label3) values ('fr.ird.observe.entities.referentiel.longline.DataSource#666#03' , 0, CURRENT_DATE, CURRENT_TIMESTAMP, 1, false,'Deep Sea Tuna Longline Association' ,'Deep Sea Tuna Longline Association', 'Deep Sea Tuna Longline Association #TODO'); -INSERT INTO observe_longline.DataSource(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, label1, label2, label3) values ('fr.ird.observe.entities.referentiel.longline.DataSource#666#04' , 0, CURRENT_DATE, CURRENT_TIMESTAMP, 1, false,'Directorate General Of Capture' ,'Directorate General Of Capture', 'Directorate General Of Capture #TODO'); -INSERT INTO observe_longline.DataSource(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, label1, label2, label3) values ('fr.ird.observe.entities.referentiel.longline.DataSource#666#05' , 0, CURRENT_DATE, CURRENT_TIMESTAMP, 1, false,'Fisheries Indonesia' ,'Fisheries Indonesia', 'Fisheries Indonesia #TODO'); -INSERT INTO observe_longline.DataSource(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, label1, label2, label3) values ('fr.ird.observe.entities.referentiel.longline.DataSource#666#06' , 0, CURRENT_DATE, CURRENT_TIMESTAMP, 1, false,'Fariska Savy' ,'Fariska Savy', 'Fariska Savy #TODO'); -INSERT INTO observe_longline.DataSource(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, label1, label2, label3) values ('fr.ird.observe.entities.referentiel.longline.DataSource#666#07' , 0, CURRENT_DATE, CURRENT_TIMESTAMP, 1, false,'Fishmongers (incl. Adam)' ,'Fishmongers (incl. Adam)', 'Fishmongers (incl. Adam) #TODO'); -INSERT INTO observe_longline.DataSource(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, label1, label2, label3) values ('fr.ird.observe.entities.referentiel.longline.DataSource#666#08' , 0, CURRENT_DATE, CURRENT_TIMESTAMP, 1, false,'Hotel' ,'Hôtel', 'Hôtel #TODO'); -INSERT INTO observe_longline.DataSource(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, label1, label2, label3) values ('fr.ird.observe.entities.referentiel.longline.DataSource#666#09' , 0, CURRENT_DATE, CURRENT_TIMESTAMP, 1, false,'IOTC Transhipment Form' ,'Formulaire de transbordement CTOI', 'Formulaire de transbordement CTOI #TODO'); -INSERT INTO observe_longline.DataSource(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, label1, label2, label3) values ('fr.ird.observe.entities.referentiel.longline.DataSource#666#10' , 0, CURRENT_DATE, CURRENT_TIMESTAMP, 1, false,'Industrial Longline Length Frequency Form' ,'Formulaire d''échantillonnage des palangriers industriels', 'Formulaire d''échantillonnage des palangriers industriels #TODO'); -INSERT INTO observe_longline.DataSource(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, label1, label2, label3) values ('fr.ird.observe.entities.referentiel.longline.DataSource#666#11' , 0, CURRENT_DATE, CURRENT_TIMESTAMP, 1, false,'Captain Logbook' ,'Logbook du capitaine', 'Logbook du capitaine #TODO'); -INSERT INTO observe_longline.DataSource(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, label1, label2, label3) values ('fr.ird.observe.entities.referentiel.longline.DataSource#666#12' , 0, CURRENT_DATE, CURRENT_TIMESTAMP, 1, false,'Email from MCS Section' ,'Email de la section MSC', 'Email de la section MSC #TODO'); -INSERT INTO observe_longline.DataSource(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, label1, label2, label3) values ('fr.ird.observe.entities.referentiel.longline.DataSource#666#13' , 0, CURRENT_DATE, CURRENT_TIMESTAMP, 1, false,'Port Authority' ,'Autorité du port', 'Autorité du port #TODO'); -INSERT INTO observe_longline.DataSource(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, label1, label2, label3) values ('fr.ird.observe.entities.referentiel.longline.DataSource#666#14' , 0, CURRENT_DATE, CURRENT_TIMESTAMP, 1, false,'Port Interview' ,'Enquête au port', 'Enquête au port #TODO'); -INSERT INTO observe_longline.DataSource(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, label1, label2, label3) values ('fr.ird.observe.entities.referentiel.longline.DataSource#666#15' , 0, CURRENT_DATE, CURRENT_TIMESTAMP, 1, false,'Processing Plant' ,'Usine de traitement', 'Usine de traitement #TODO'); -INSERT INTO observe_longline.DataSource(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, label1, label2, label3) values ('fr.ird.observe.entities.referentiel.longline.DataSource#666#16' , 0, CURRENT_DATE, CURRENT_TIMESTAMP, 1, false,'Restaurant' ,'Restaurant', 'Restaurant #TODO'); -INSERT INTO observe_longline.DataSource(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, label1, label2, label3) values ('fr.ird.observe.entities.referentiel.longline.DataSource#666#17' , 0, CURRENT_DATE, CURRENT_TIMESTAMP, 1, false,'SFA Application for Authorisation' ,'?', '? #TODO'); -INSERT INTO observe_longline.DataSource(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, label1, label2, label3) values ('fr.ird.observe.entities.referentiel.longline.DataSource#666#18' , 0, CURRENT_DATE, CURRENT_TIMESTAMP, 1, false,'Transfer of old database system' ,'Transfert d''une ancienne BDD', 'Transfert d''une ancienne BDD #TODO'); -INSERT INTO observe_longline.DataSource(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, label1, label2, label3) values ('fr.ird.observe.entities.referentiel.longline.DataSource#666#19' , 0, CURRENT_DATE, CURRENT_TIMESTAMP, 1, false,'Labrosse (?)' ,'Labrosse (?)', 'Labrosse (?) #TODO'); -INSERT INTO observe_longline.DataSource(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, label1, label2, label3) values ('fr.ird.observe.entities.referentiel.longline.DataSource#666#20' , 0, CURRENT_DATE, CURRENT_TIMESTAMP, 1, false,'Unknown' ,'Inconnue', 'Inconnue #TODO'); +INSERT INTO observe_longline.DataSource(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, label1, label2, label3) values ('fr.ird.observe.entities.referentiel.longline.DataSource#666#01' , 0, ${CURRENT_DATE}, ${CURRENT_TIMESTAMP}, 1, false,'Customs' ,'Douanes', 'Douanes #TODO'); +INSERT INTO observe_longline.DataSource(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, label1, label2, label3) values ('fr.ird.observe.entities.referentiel.longline.DataSource#666#02' , 0, ${CURRENT_DATE}, ${CURRENT_TIMESTAMP}, 1, false,'Auto-Calculated from Database Logbooks' ,'Auto-calculé depuis la BDD logbooks', 'Auto-calculé depuis la BDD logbooks #TODO'); +INSERT INTO observe_longline.DataSource(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, label1, label2, label3) values ('fr.ird.observe.entities.referentiel.longline.DataSource#666#03' , 0, ${CURRENT_DATE}, ${CURRENT_TIMESTAMP}, 1, false,'Deep Sea Tuna Longline Association' ,'Deep Sea Tuna Longline Association', 'Deep Sea Tuna Longline Association #TODO'); +INSERT INTO observe_longline.DataSource(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, label1, label2, label3) values ('fr.ird.observe.entities.referentiel.longline.DataSource#666#04' , 0, ${CURRENT_DATE}, ${CURRENT_TIMESTAMP}, 1, false,'Directorate General Of Capture' ,'Directorate General Of Capture', 'Directorate General Of Capture #TODO'); +INSERT INTO observe_longline.DataSource(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, label1, label2, label3) values ('fr.ird.observe.entities.referentiel.longline.DataSource#666#05' , 0, ${CURRENT_DATE}, ${CURRENT_TIMESTAMP}, 1, false,'Fisheries Indonesia' ,'Fisheries Indonesia', 'Fisheries Indonesia #TODO'); +INSERT INTO observe_longline.DataSource(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, label1, label2, label3) values ('fr.ird.observe.entities.referentiel.longline.DataSource#666#06' , 0, ${CURRENT_DATE}, ${CURRENT_TIMESTAMP}, 1, false,'Fariska Savy' ,'Fariska Savy', 'Fariska Savy #TODO'); +INSERT INTO observe_longline.DataSource(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, label1, label2, label3) values ('fr.ird.observe.entities.referentiel.longline.DataSource#666#07' , 0, ${CURRENT_DATE}, ${CURRENT_TIMESTAMP}, 1, false,'Fishmongers (incl. Adam)' ,'Fishmongers (incl. Adam)', 'Fishmongers (incl. Adam) #TODO'); +INSERT INTO observe_longline.DataSource(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, label1, label2, label3) values ('fr.ird.observe.entities.referentiel.longline.DataSource#666#08' , 0, ${CURRENT_DATE}, ${CURRENT_TIMESTAMP}, 1, false,'Hotel' ,'Hôtel', 'Hôtel #TODO'); +INSERT INTO observe_longline.DataSource(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, label1, label2, label3) values ('fr.ird.observe.entities.referentiel.longline.DataSource#666#09' , 0, ${CURRENT_DATE}, ${CURRENT_TIMESTAMP}, 1, false,'IOTC Transhipment Form' ,'Formulaire de transbordement CTOI', 'Formulaire de transbordement CTOI #TODO'); +INSERT INTO observe_longline.DataSource(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, label1, label2, label3) values ('fr.ird.observe.entities.referentiel.longline.DataSource#666#10' , 0, ${CURRENT_DATE}, ${CURRENT_TIMESTAMP}, 1, false,'Industrial Longline Length Frequency Form' ,'Formulaire d''échantillonnage des palangriers industriels', 'Formulaire d''échantillonnage des palangriers industriels #TODO'); +INSERT INTO observe_longline.DataSource(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, label1, label2, label3) values ('fr.ird.observe.entities.referentiel.longline.DataSource#666#11' , 0, ${CURRENT_DATE}, ${CURRENT_TIMESTAMP}, 1, false,'Captain Logbook' ,'Logbook du capitaine', 'Logbook du capitaine #TODO'); +INSERT INTO observe_longline.DataSource(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, label1, label2, label3) values ('fr.ird.observe.entities.referentiel.longline.DataSource#666#12' , 0, ${CURRENT_DATE}, ${CURRENT_TIMESTAMP}, 1, false,'Email from MCS Section' ,'Email de la section MSC', 'Email de la section MSC #TODO'); +INSERT INTO observe_longline.DataSource(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, label1, label2, label3) values ('fr.ird.observe.entities.referentiel.longline.DataSource#666#13' , 0, ${CURRENT_DATE}, ${CURRENT_TIMESTAMP}, 1, false,'Port Authority' ,'Autorité du port', 'Autorité du port #TODO'); +INSERT INTO observe_longline.DataSource(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, label1, label2, label3) values ('fr.ird.observe.entities.referentiel.longline.DataSource#666#14' , 0, ${CURRENT_DATE}, ${CURRENT_TIMESTAMP}, 1, false,'Port Interview' ,'Enquête au port', 'Enquête au port #TODO'); +INSERT INTO observe_longline.DataSource(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, label1, label2, label3) values ('fr.ird.observe.entities.referentiel.longline.DataSource#666#15' , 0, ${CURRENT_DATE}, ${CURRENT_TIMESTAMP}, 1, false,'Processing Plant' ,'Usine de traitement', 'Usine de traitement #TODO'); +INSERT INTO observe_longline.DataSource(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, label1, label2, label3) values ('fr.ird.observe.entities.referentiel.longline.DataSource#666#16' , 0, ${CURRENT_DATE}, ${CURRENT_TIMESTAMP}, 1, false,'Restaurant' ,'Restaurant', 'Restaurant #TODO'); +INSERT INTO observe_longline.DataSource(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, label1, label2, label3) values ('fr.ird.observe.entities.referentiel.longline.DataSource#666#17' , 0, ${CURRENT_DATE}, ${CURRENT_TIMESTAMP}, 1, false,'SFA Application for Authorisation' ,'?', '? #TODO'); +INSERT INTO observe_longline.DataSource(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, label1, label2, label3) values ('fr.ird.observe.entities.referentiel.longline.DataSource#666#18' , 0, ${CURRENT_DATE}, ${CURRENT_TIMESTAMP}, 1, false,'Transfer of old database system' ,'Transfert d''une ancienne BDD', 'Transfert d''une ancienne BDD #TODO'); +INSERT INTO observe_longline.DataSource(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, label1, label2, label3) values ('fr.ird.observe.entities.referentiel.longline.DataSource#666#19' , 0, ${CURRENT_DATE}, ${CURRENT_TIMESTAMP}, 1, false,'Labrosse (?)' ,'Labrosse (?)', 'Labrosse (?) #TODO'); +INSERT INTO observe_longline.DataSource(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, label1, label2, label3) values ('fr.ird.observe.entities.referentiel.longline.DataSource#666#20' , 0, ${CURRENT_DATE}, ${CURRENT_TIMESTAMP}, 1, false,'Unknown' ,'Inconnue', 'Inconnue #TODO'); ===================================== persistence/src/main/resources/db/migration/8.0/16_rename_seine_weight_category-common.sql ===================================== @@ -23,7 +23,7 @@ UPDATE OBSERVE_SEINE.WeightCategory SET TOPIAID = replace(TOPIAID, '.WeightCateg UPDATE OBSERVE_COMMON.LASTUPDATEDATE SET TYPE = replace(TYPE, '.seine.WeightCategory', '.seine.WeightCategorySeine'); UPDATE OBSERVE_SEINE.WeightCategory SET TOPIAVERSION = TOPIAVERSION + 1; -UPDATE OBSERVE_COMMON.LASTUPDATEDATE SET LASTUPDATEDATE = CURRENT_TIMESTAMP WHERE TYPE ='fr.ird.observe.entities.referentiel.seine.WeightCategorySeine'; +UPDATE OBSERVE_COMMON.LASTUPDATEDATE SET LASTUPDATEDATE = ${CURRENT_TIMESTAMP} WHERE TYPE ='fr.ird.observe.entities.referentiel.seine.WeightCategorySeine'; DROP INDEX IF EXISTS idx_OBSERVE_SEINE_targetCatch_WeightCategory; UPDATE OBSERVE_SEINE.TargetCatch SET WeightCategory = replace(WeightCategory, '.WeightCategory', '.WeightCategorySeine'); ===================================== persistence/src/main/resources/db/migration/8.0/17_add_trip_type-common.sql ===================================== @@ -21,6 +21,6 @@ --- CREATE TABLE observe_longline.TripType(topiaid VARCHAR(255) NOT NULL,topiaversion BIGINT NOT NULL, topiacreatedate DATE, lastupdatedate TIMESTAMP NOT NULL, code VARCHAR(255), status INTEGER DEFAULT 1, needComment BOOLEAN DEFAULT false, uri VARCHAR(255), label1 VARCHAR(255), label2 VARCHAR(255), label3 VARCHAR(255),label4 VARCHAR(255),label5 VARCHAR(255),label6 VARCHAR(255),label7 VARCHAR(255),label8 VARCHAR(255)); ALTER TABLE observe_longline.TripType ADD CONSTRAINT PK_TripType PRIMARY KEY(topiaid); -INSERT INTO observe_common.LASTUPDATEDATE(topiaId, topiaversion, topiacreatedate, TYPE , LASTUPDATEDATE) values ('fr.ird.observe.entities.LastUpdateDate#666#1013', 0,CURRENT_DATE, 'fr.ird.observe.entities.referentiel.longline.TripType', CURRENT_TIMESTAMP); -INSERT INTO observe_longline.TripType(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, code, label1, label2, label3) values ('fr.ird.observe.entities.referentiel.longline.TripType#666#01' , 0, CURRENT_DATE, CURRENT_TIMESTAMP, 1, false, 'SC', 'Scientific trip', 'Marée scientifique', 'Marea experimental'); -INSERT INTO observe_longline.TripType(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, code, label1, label2, label3) values ('fr.ird.observe.entities.referentiel.longline.TripType#666#02' , 0, CURRENT_DATE, CURRENT_TIMESTAMP, 1, false, 'CM', 'Commercial trip', 'Marée de pêche commerciale', 'Marea commercial'); +INSERT INTO observe_common.LASTUPDATEDATE(topiaId, topiaversion, topiacreatedate, TYPE , LASTUPDATEDATE) values ('fr.ird.observe.entities.LastUpdateDate#666#1013', 0,${CURRENT_DATE}, 'fr.ird.observe.entities.referentiel.longline.TripType', ${CURRENT_TIMESTAMP}); +INSERT INTO observe_longline.TripType(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, code, label1, label2, label3) values ('fr.ird.observe.entities.referentiel.longline.TripType#666#01' , 0, ${CURRENT_DATE}, ${CURRENT_TIMESTAMP}, 1, false, 'SC', 'Scientific trip', 'Marée scientifique', 'Marea experimental'); +INSERT INTO observe_longline.TripType(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, code, label1, label2, label3) values ('fr.ird.observe.entities.referentiel.longline.TripType#666#02' , 0, ${CURRENT_DATE}, ${CURRENT_TIMESTAMP}, 1, false, 'CM', 'Commercial trip', 'Marée de pêche commerciale', 'Marea commercial'); ===================================== persistence/src/main/resources/db/migration/8.0/19_add_longline_trip_species_list-common.sql ===================================== @@ -19,4 +19,4 @@ -- <http://www.gnu.org/licenses/gpl-3.0.html>. -- #L% --- -INSERT INTO observe_common.SpeciesList(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, label1, label2, label3) values ('fr.ird.observe.entities.referentiel.SpeciesList#1239832675370#0.7' , 0, CURRENT_DATE, CURRENT_TIMESTAMP, 1, false, 'LL - Trip', 'LL - Marée', 'LL - Marea'); +INSERT INTO observe_common.SpeciesList(topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, label1, label2, label3) values ('fr.ird.observe.entities.referentiel.SpeciesList#1239832675370#0.7' , 0, ${CURRENT_DATE}, ${CURRENT_TIMESTAMP}, 1, false, 'LL - Trip', 'LL - Marée', 'LL - Marea'); ===================================== persistence/src/main/resources/db/migration/8.0/20_update_referential_longline_line_type-common.sql ===================================== @@ -19,5 +19,5 @@ -- <http://www.gnu.org/licenses/gpl-3.0.html>. -- #L% --- -INSERT INTO observe_longline.linetype (topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, code, label1, label2, label3) values ('fr.ird.observe.entities.referentiel.longline.LineType#1239832686157#0.9', 0, CURRENT_DATE, CURRENT_TIMESTAMP, 1, false, 'UNK', 'Unknown', 'Inconnu', 'Desconocido'); -UPDATE observe_common.LASTUPDATEDATE SET lastupdatedate = CURRENT_TIMESTAMP WHERE topiaId = 'fr.ird.observe.entities.LastUpdateDate#1236861982132#0.48'; +INSERT INTO observe_longline.linetype (topiaid, topiaversion, topiacreatedate, lastupdatedate, status, needComment, code, label1, label2, label3) values ('fr.ird.observe.entities.referentiel.longline.LineType#1239832686157#0.9', 0, ${CURRENT_DATE}, ${CURRENT_TIMESTAMP}, 1, false, 'UNK', 'Unknown', 'Inconnu', 'Desconocido'); +UPDATE observe_common.LASTUPDATEDATE SET lastupdatedate = ${CURRENT_TIMESTAMP} WHERE topiaId = 'fr.ird.observe.entities.LastUpdateDate#1236861982132#0.48'; ===================================== persistence/src/main/resources/db/migration/8.0/40_ps_common_fill-common.sql ===================================== @@ -44,12 +44,12 @@ UPDATE ps_common.GearUseFeaturesMeasurement SET topiaid = REPLACE(REPLACE(topiai UPDATE ps_common.GearUseFeatures SET topiaid = REPLACE(REPLACE(topiaid, 'observe.entities.seine', 'data.ps.common'), 'Seine',''), topiaversion = topiaversion + 1, trip = REPLACE(REPLACE(trip, 'observe.entities.seine.', 'data.ps.common.'), 'Seine',''), gear = REPLACE(gear, 'observe.entities.referentiel.', 'referential.common.'); UPDATE ps_common.Trip SET topiaid = REPLACE(REPLACE(topiaid, 'observe.entities.seine', 'data.ps.common'), 'Seine',''), topiaversion = topiaversion + 1, ocean = REPLACE(ocean, 'observe.entities.referentiel', 'referential.common'), vessel = REPLACE(vessel, 'observe.entities.referentiel', 'referential.common'), program = REPLACE(program, 'observe.entities.referentiel', 'referential.common'), observer = REPLACE(observer, 'observe.entities.referentiel', 'referential.common'), captain = REPLACE(captain, 'observe.entities.referentiel', 'referential.common'), dataEntryOperator = REPLACE(dataEntryOperator, 'observe.entities.referentiel', 'referential.common'), departureHarbour = REPLACE(departureHarbour, 'observe.entities.referentiel', 'referential.common'), landingHarbour = REPLACE(landingHarbour, 'observe.entities.referentiel', 'referential.common'), dataQuality = REPLACE(dataQuality, 'observe.entities.referentiel', 'referential.common'); -INSERT INTO ps_common.SchoolType(topiaid, topiaversion, topiacreatedate, code, uri, status, label1, label2, label3, needcomment, lastupdatedate) values ('fr.ird.referential.ps.common.SchoolType#0#0' , 0, CURRENT_DATE, '0', null ,1, 'Undefined school type', 'Banc indéterminé', 'Banco indeterminado', false, CURRENT_TIMESTAMP); -INSERT INTO ps_common.SchoolType(topiaid, topiaversion, topiacreatedate, code, uri, status, label1, label2, label3, needcomment, lastupdatedate) values ('fr.ird.referential.ps.common.SchoolType#0#1' , 0, CURRENT_DATE, '1', null ,1, 'Object school type', 'Banc objet', 'Banco a objeto', false, CURRENT_TIMESTAMP); -INSERT INTO ps_common.SchoolType(topiaid, topiaversion, topiacreatedate, code, uri, status, label1, label2, label3, needcomment, lastupdatedate) values ('fr.ird.referential.ps.common.SchoolType#0#2' , 0, CURRENT_DATE, '2', null ,1, 'Free school type', 'Banc libre', 'Banco libre', false, CURRENT_TIMESTAMP); +INSERT INTO ps_common.SchoolType(topiaid, topiaversion, topiacreatedate, code, uri, status, label1, label2, label3, needcomment, lastupdatedate) values ('fr.ird.referential.ps.common.SchoolType#0#0' , 0, ${CURRENT_DATE}, '0', null ,1, 'Undefined school type', 'Banc indéterminé', 'Banco indeterminado', false, ${CURRENT_TIMESTAMP}); +INSERT INTO ps_common.SchoolType(topiaid, topiaversion, topiacreatedate, code, uri, status, label1, label2, label3, needcomment, lastupdatedate) values ('fr.ird.referential.ps.common.SchoolType#0#1' , 0, ${CURRENT_DATE}, '1', null ,1, 'Object school type', 'Banc objet', 'Banco a objeto', false, ${CURRENT_TIMESTAMP}); +INSERT INTO ps_common.SchoolType(topiaid, topiaversion, topiacreatedate, code, uri, status, label1, label2, label3, needcomment, lastupdatedate) values ('fr.ird.referential.ps.common.SchoolType#0#2' , 0, ${CURRENT_DATE}, '2', null ,1, 'Free school type', 'Banc libre', 'Banco libre', false, ${CURRENT_TIMESTAMP}); -INSERT INTO ps_common.TransmittingBuoyOwnership(topiaid, topiaversion, topiacreatedate, code, uri, status, label1, label2, label3, needcomment, lastupdatedate) values ('fr.ird.referential.ps.common.TransmittingBuoyOwnership#0#0' , 0, CURRENT_DATE, '0', null ,1, 'Unknown', 'À un bateau inconnu', 'Desconocido', false, CURRENT_TIMESTAMP); -INSERT INTO ps_common.TransmittingBuoyOwnership(topiaid, topiaversion, topiacreatedate, code, uri, status, label1, label2, label3, needcomment, lastupdatedate) values ('fr.ird.referential.ps.common.TransmittingBuoyOwnership#0#1' , 0, CURRENT_DATE, '1', null ,0, 'This vessel', 'À ce bateau ou à son armement', 'Este barco o un barco del mismo armador', false, CURRENT_TIMESTAMP); -INSERT INTO ps_common.TransmittingBuoyOwnership(topiaid, topiaversion, topiacreatedate, code, uri, status, label1, label2, label3, needcomment, lastupdatedate) values ('fr.ird.referential.ps.common.TransmittingBuoyOwnership#0#2' , 0, CURRENT_DATE, '2', null ,1, 'Other vessel', 'À un autre armement', 'Barco ajeno', false, CURRENT_TIMESTAMP); -INSERT INTO ps_common.TransmittingBuoyOwnership(topiaid, topiaversion, topiacreatedate, code, uri, status, label1, label2, label3, needcomment, lastupdatedate) values ('fr.ird.referential.ps.common.TransmittingBuoyOwnership#0#3' , 0, CURRENT_DATE, '3', null ,1, 'This vessel', 'À ce bateau', 'Este barco', false, CURRENT_TIMESTAMP); -INSERT INTO ps_common.TransmittingBuoyOwnership(topiaid, topiaversion, topiacreatedate, code, uri, status, label1, label2, label3, needcomment, lastupdatedate) values ('fr.ird.referential.ps.common.TransmittingBuoyOwnership#0#4' , 0, CURRENT_DATE, '4', null ,1, 'Another vessel', 'À un autre bateau du même armement', 'Barco ajeno del mismo armador', false, CURRENT_TIMESTAMP); +INSERT INTO ps_common.TransmittingBuoyOwnership(topiaid, topiaversion, topiacreatedate, code, uri, status, label1, label2, label3, needcomment, lastupdatedate) values ('fr.ird.referential.ps.common.TransmittingBuoyOwnership#0#0' , 0, ${CURRENT_DATE}, '0', null ,1, 'Unknown', 'À un bateau inconnu', 'Desconocido', false, ${CURRENT_TIMESTAMP}); +INSERT INTO ps_common.TransmittingBuoyOwnership(topiaid, topiaversion, topiacreatedate, code, uri, status, label1, label2, label3, needcomment, lastupdatedate) values ('fr.ird.referential.ps.common.TransmittingBuoyOwnership#0#1' , 0, ${CURRENT_DATE}, '1', null ,0, 'This vessel', 'À ce bateau ou à son armement', 'Este barco o un barco del mismo armador', false, ${CURRENT_TIMESTAMP}); +INSERT INTO ps_common.TransmittingBuoyOwnership(topiaid, topiaversion, topiacreatedate, code, uri, status, label1, label2, label3, needcomment, lastupdatedate) values ('fr.ird.referential.ps.common.TransmittingBuoyOwnership#0#2' , 0, ${CURRENT_DATE}, '2', null ,1, 'Other vessel', 'À un autre armement', 'Barco ajeno', false, ${CURRENT_TIMESTAMP}); +INSERT INTO ps_common.TransmittingBuoyOwnership(topiaid, topiaversion, topiacreatedate, code, uri, status, label1, label2, label3, needcomment, lastupdatedate) values ('fr.ird.referential.ps.common.TransmittingBuoyOwnership#0#3' , 0, ${CURRENT_DATE}, '3', null ,1, 'This vessel', 'À ce bateau', 'Este barco', false, ${CURRENT_TIMESTAMP}); +INSERT INTO ps_common.TransmittingBuoyOwnership(topiaid, topiaversion, topiacreatedate, code, uri, status, label1, label2, label3, needcomment, lastupdatedate) values ('fr.ird.referential.ps.common.TransmittingBuoyOwnership#0#4' , 0, ${CURRENT_DATE}, '4', null ,1, 'Another vessel', 'À un autre bateau du même armement', 'Barco ajeno del mismo armador', false, ${CURRENT_TIMESTAMP}); ===================================== persistence/src/main/resources/db/migration/8.0/80_ll_logbook_create-common.sql ===================================== @@ -130,13 +130,13 @@ CREATE INDEX idx_ll_logbook_sample_lastupdatedate ON ll_logbook.sample(lastupdat CREATE INDEX idx_ll_logbook_samplepart_lastupdatedate ON ll_logbook.samplepart(lastupdatedate); CREATE INDEX idx_ll_logbook_activity_lastupdatedate ON ll_logbook.activity(lastupdatedate); -INSERT INTO common.LASTUPDATEDATE(topiaId, topiaversion, topiacreatedate, TYPE , LASTUPDATEDATE) values ('fr.ird.common.LastUpdateDate#666#1014', 0,CURRENT_DATE, 'fr.ird.observe.entities.data.ll.logbook.Activity', CURRENT_TIMESTAMP); -INSERT INTO common.LASTUPDATEDATE(topiaId, topiaversion, topiacreatedate, TYPE , LASTUPDATEDATE) values ('fr.ird.common.LastUpdateDate#666#1015', 0,CURRENT_DATE, 'fr.ird.observe.entities.data.ll.logbook.BaitsComposition', CURRENT_TIMESTAMP); -INSERT INTO common.LASTUPDATEDATE(topiaId, topiaversion, topiacreatedate, TYPE , LASTUPDATEDATE) values ('fr.ird.common.LastUpdateDate#666#1016', 0,CURRENT_DATE, 'fr.ird.observe.entities.data.ll.logbook.BranchlinesComposition', CURRENT_TIMESTAMP); -INSERT INTO common.LASTUPDATEDATE(topiaId, topiaversion, topiacreatedate, TYPE , LASTUPDATEDATE) values ('fr.ird.common.LastUpdateDate#666#1017', 0,CURRENT_DATE, 'fr.ird.observe.entities.data.ll.logbook.Catch', CURRENT_TIMESTAMP); -INSERT INTO common.LASTUPDATEDATE(topiaId, topiaversion, topiacreatedate, TYPE , LASTUPDATEDATE) values ('fr.ird.common.LastUpdateDate#666#1018', 0,CURRENT_DATE, 'fr.ird.observe.entities.data.ll.logbook.FloatlinesComposition', CURRENT_TIMESTAMP); -INSERT INTO common.LASTUPDATEDATE(topiaId, topiaversion, topiacreatedate, TYPE , LASTUPDATEDATE) values ('fr.ird.common.LastUpdateDate#666#1019', 0,CURRENT_DATE, 'fr.ird.observe.entities.data.ll.logbook.HooksComposition', CURRENT_TIMESTAMP); -INSERT INTO common.LASTUPDATEDATE(topiaId, topiaversion, topiacreatedate, TYPE , LASTUPDATEDATE) values ('fr.ird.common.LastUpdateDate#666#1020', 0,CURRENT_DATE, 'fr.ird.observe.entities.data.ll.logbook.Set', CURRENT_TIMESTAMP); -INSERT INTO common.LASTUPDATEDATE(topiaId, topiaversion, topiacreatedate, TYPE , LASTUPDATEDATE) values ('fr.ird.common.LastUpdateDate#666#1023', 0,CURRENT_DATE, 'fr.ird.observe.entities.data.ll.logbook.Sample', CURRENT_TIMESTAMP); -INSERT INTO common.LASTUPDATEDATE(topiaId, topiaversion, topiacreatedate, TYPE , LASTUPDATEDATE) values ('fr.ird.common.LastUpdateDate#666#1024', 0,CURRENT_DATE, 'fr.ird.observe.entities.data.ll.logbook.SamplePart', CURRENT_TIMESTAMP); +INSERT INTO common.LASTUPDATEDATE(topiaId, topiaversion, topiacreatedate, TYPE , LASTUPDATEDATE) values ('fr.ird.common.LastUpdateDate#666#1014', 0,${CURRENT_DATE}, 'fr.ird.observe.entities.data.ll.logbook.Activity', ${CURRENT_TIMESTAMP}); +INSERT INTO common.LASTUPDATEDATE(topiaId, topiaversion, topiacreatedate, TYPE , LASTUPDATEDATE) values ('fr.ird.common.LastUpdateDate#666#1015', 0,${CURRENT_DATE}, 'fr.ird.observe.entities.data.ll.logbook.BaitsComposition', ${CURRENT_TIMESTAMP}); +INSERT INTO common.LASTUPDATEDATE(topiaId, topiaversion, topiacreatedate, TYPE , LASTUPDATEDATE) values ('fr.ird.common.LastUpdateDate#666#1016', 0,${CURRENT_DATE}, 'fr.ird.observe.entities.data.ll.logbook.BranchlinesComposition', ${CURRENT_TIMESTAMP}); +INSERT INTO common.LASTUPDATEDATE(topiaId, topiaversion, topiacreatedate, TYPE , LASTUPDATEDATE) values ('fr.ird.common.LastUpdateDate#666#1017', 0,${CURRENT_DATE}, 'fr.ird.observe.entities.data.ll.logbook.Catch', ${CURRENT_TIMESTAMP}); +INSERT INTO common.LASTUPDATEDATE(topiaId, topiaversion, topiacreatedate, TYPE , LASTUPDATEDATE) values ('fr.ird.common.LastUpdateDate#666#1018', 0,${CURRENT_DATE}, 'fr.ird.observe.entities.data.ll.logbook.FloatlinesComposition', ${CURRENT_TIMESTAMP}); +INSERT INTO common.LASTUPDATEDATE(topiaId, topiaversion, topiacreatedate, TYPE , LASTUPDATEDATE) values ('fr.ird.common.LastUpdateDate#666#1019', 0,${CURRENT_DATE}, 'fr.ird.observe.entities.data.ll.logbook.HooksComposition', ${CURRENT_TIMESTAMP}); +INSERT INTO common.LASTUPDATEDATE(topiaId, topiaversion, topiacreatedate, TYPE , LASTUPDATEDATE) values ('fr.ird.common.LastUpdateDate#666#1020', 0,${CURRENT_DATE}, 'fr.ird.observe.entities.data.ll.logbook.Set', ${CURRENT_TIMESTAMP}); +INSERT INTO common.LASTUPDATEDATE(topiaId, topiaversion, topiacreatedate, TYPE , LASTUPDATEDATE) values ('fr.ird.common.LastUpdateDate#666#1023', 0,${CURRENT_DATE}, 'fr.ird.observe.entities.data.ll.logbook.Sample', ${CURRENT_TIMESTAMP}); +INSERT INTO common.LASTUPDATEDATE(topiaId, topiaversion, topiacreatedate, TYPE , LASTUPDATEDATE) values ('fr.ird.common.LastUpdateDate#666#1024', 0,${CURRENT_DATE}, 'fr.ird.observe.entities.data.ll.logbook.SamplePart', ${CURRENT_TIMESTAMP}); ===================================== persistence/src/main/resources/db/migration/8.0/90_ll_landing_fill-common.sql ===================================== @@ -29,33 +29,33 @@ UPDATE ll_landing.conservation SET topiaid = REPLACE(topiaid, 'observe.entities. UPDATE ll_landing.datasource SET topiaid = REPLACE(topiaid, 'observe.entities.referentiel.longline', 'referential.ll.landing'), topiaversion = topiaversion + 1; -INSERT INTO ll_landing.compagnies(topiaid, topiaversion, topiacreatedate, status, needComment, lastUpdateDate, code, homeId, label1, label2, label3) VALUES ('fr.ird.referential.ll.landing.Compagnies#1464000000000#0.01', 0,'2019-01-15', 1, FALSE, CURRENT_TIMESTAMP ,'AFM', 'FINSS-00003638', '[type: Unknown] Amedee [id:n/a]', '[type: Unknown] Amedee [id:n/a]', '[type: Unknown] Amedee [id:n/a]'); -INSERT INTO ll_landing.compagnies(topiaid, topiaversion, topiacreatedate, status, needComment, lastUpdateDate, code, homeId, label1, label2, label3) VALUES ('fr.ird.referential.ll.landing.Compagnies#1464000000000#0.02', 0,'2019-01-15', 1, FALSE, CURRENT_TIMESTAMP ,'AMIRANTES', 'FINSS-00003643', '[type: Unknown] AMIRANTES FISHERIES [id:n/a]', '[type: Unknown] AMIRANTES FISHERIES [id:n/a]', '[type: Unknown] AMIRANTES FISHERIES [id:n/a]'); -INSERT INTO ll_landing.compagnies(topiaid, topiaversion, topiacreatedate, status, needComment, lastUpdateDate, code, homeId, label1, label2, label3) VALUES ('fr.ird.referential.ll.landing.Compagnies#1464000000000#0.03', 0,'2019-01-15', 1, FALSE, CURRENT_TIMESTAMP ,'AMO', 'FINSS-00003557', '[type: Person] Mondon Antoine [id:n/a]', '[type: Person] Mondon Antoine [id:n/a]', '[type: Person] Mondon Antoine [id:n/a]'); -INSERT INTO ll_landing.compagnies(topiaid, topiaversion, topiacreatedate, status, needComment, lastUpdateDate, code, homeId, label1, label2, label3) VALUES ('fr.ird.referential.ll.landing.Compagnies#1464000000000#0.04', 0,'2019-01-15', 1, FALSE, CURRENT_TIMESTAMP ,'ARC', 'FINSS-00003662', '[type: Organization] ARCHIPEL HOTEL [id:n/a]', '[type: Organization] ARCHIPEL HOTEL [id:n/a]', '[type: Organization] ARCHIPEL HOTEL [id:n/a]'); -INSERT INTO ll_landing.compagnies(topiaid, topiaversion, topiacreatedate, status, needComment, lastUpdateDate, code, homeId, label1, label2, label3) VALUES ('fr.ird.referential.ll.landing.Compagnies#1464000000000#0.05', 0,'2019-01-15', 1, FALSE, CURRENT_TIMESTAMP ,'B&E', 'FINSS-00000096', '[type: Organization] B&E ENTERPRISE (PTY) LTD [id:n/a]', '[type: Organization] B&E ENTERPRISE (PTY) LTD [id:n/a]', '[type: Organization] B&E ENTERPRISE (PTY) LTD [id:n/a]'); -INSERT INTO ll_landing.compagnies(topiaid, topiaversion, topiacreatedate, status, needComment, lastUpdateDate, code, homeId, label1, label2, label3) VALUES ('fr.ird.referential.ll.landing.Compagnies#1464000000000#0.06', 0,'2019-01-15', 1, FALSE, CURRENT_TIMESTAMP ,'BFR', 'FINSS-00003535', '[type: Person] Fred Benson,Frederick [id:n/a]', '[type: Person] Fred Benson,Frederick [id:n/a]', '[type: Person] Fred Benson,Frederick [id:n/a]'); -INSERT INTO ll_landing.compagnies(topiaid, topiaversion, topiacreatedate, status, needComment, lastUpdateDate, code, homeId, label1, label2, label3) VALUES ('fr.ird.referential.ll.landing.Compagnies#1464000000000#0.07', 0,'2019-01-15', 1, FALSE, CURRENT_TIMESTAMP ,'DCE', 'FINSS-00003473', '[type: Person] Cedras David,Welton [id:n/a]', '[type: Person] Cedras David,Welton [id:n/a]', '[type: Person] Cedras David,Welton [id:n/a]'); -INSERT INTO ll_landing.compagnies(topiaid, topiaversion, topiacreatedate, status, needComment, lastUpdateDate, code, homeId, label1, label2, label3) VALUES ('fr.ird.referential.ll.landing.Compagnies#1464000000000#0.08', 0,'2019-01-15', 1, FALSE, CURRENT_TIMESTAMP ,'Ephelia', 'FINSS-00003634', '[type: Unknown] Ephelia Constance Hotel [id:n/a]', '[type: Unknown] Ephelia Constance Hotel [id:n/a]', '[type: Unknown] Ephelia Constance Hotel [id:n/a]'); -INSERT INTO ll_landing.compagnies(topiaid, topiaversion, topiacreatedate, status, needComment, lastUpdateDate, code, homeId, label1, label2, label3) VALUES ('fr.ird.referential.ll.landing.Compagnies#1464000000000#0.09', 0,'2019-01-15', 1, FALSE, CURRENT_TIMESTAMP ,'FSS', 'FINSS-00003651', '[type: Unknown] Fresh Seafood Seychelles PTY (LTD) [id:n/a]', '[type: Unknown] Fresh Seafood Seychelles PTY (LTD) [id:n/a]', '[type: Unknown] Fresh Seafood Seychelles PTY (LTD) [id:n/a]'); -INSERT INTO ll_landing.compagnies(topiaid, topiaversion, topiacreatedate, status, needComment, lastUpdateDate, code, homeId, label1, label2, label3) VALUES ('fr.ird.referential.ll.landing.Compagnies#1464000000000#0.10', 0,'2019-01-15', 1, FALSE, CURRENT_TIMESTAMP ,'FTE', 'FINSS-00003663', '[type: Unknown] FISH TECH [id:n/a]', '[type: Unknown] FISH TECH [id:n/a]', '[type: Unknown] FISH TECH [id:n/a]'); -INSERT INTO ll_landing.compagnies(topiaid, topiaversion, topiacreatedate, status, needComment, lastUpdateDate, code, homeId, label1, label2, label3) VALUES ('fr.ird.referential.ll.landing.Compagnies#1464000000000#0.11', 0,'2019-01-15', 1, FALSE, CURRENT_TIMESTAMP ,'GFM', 'FINSS-00003640', '[type: Unknown] George Fishmonger [id:n/a]', '[type: Unknown] George Fishmonger [id:n/a]', '[type: Unknown] George Fishmonger [id:n/a]'); -INSERT INTO ll_landing.compagnies(topiaid, topiaversion, topiacreatedate, status, needComment, lastUpdateDate, code, homeId, label1, label2, label3) VALUES ('fr.ird.referential.ll.landing.Compagnies#1464000000000#0.12', 0,'2019-01-15', 1, FALSE, CURRENT_TIMESTAMP ,'GPO', 'FINSS-00000098', '[type: Person] PORT LOUIS GERARD [id:n/a]', '[type: Person] PORT LOUIS GERARD [id:n/a]', '[type: Person] PORT LOUIS GERARD [id:n/a]'); -INSERT INTO ll_landing.compagnies(topiaid, topiaversion, topiacreatedate, status, needComment, lastUpdateDate, code, homeId, label1, label2, label3) VALUES ('fr.ird.referential.ll.landing.Compagnies#1464000000000#0.13', 0,'2019-01-15', 1, FALSE, CURRENT_TIMESTAMP ,'GRA', 'FINSS-00003347', '[type: Person] Rassool Gilbert,Christophe [id:n/a]', '[type: Person] Rassool Gilbert,Christophe [id:n/a]', '[type: Person] Rassool Gilbert,Christophe [id:n/a]'); -INSERT INTO ll_landing.compagnies(topiaid, topiaversion, topiacreatedate, status, needComment, lastUpdateDate, code, homeId, label1, label2, label3) VALUES ('fr.ird.referential.ll.landing.Compagnies#1464000000000#0.14', 0,'2019-01-15', 1, FALSE, CURRENT_TIMESTAMP ,'HOTEL&REST', 'FINSS-00003624', '[type: Unknown] Hotels and Restaurants [id:n/a]', '[type: Unknown] Hotels and Restaurants [id:n/a]', '[type: Unknown] Hotels and Restaurants [id:n/a]'); -INSERT INTO ll_landing.compagnies(topiaid, topiaversion, topiacreatedate, status, needComment, lastUpdateDate, code, homeId, label1, label2, label3) VALUES ('fr.ird.referential.ll.landing.Compagnies#1464000000000#0.15', 0,'2019-01-15', 1, FALSE, CURRENT_TIMESTAMP ,'IFM', 'FINSS-00003639', '[type: Unknown] ISPC [id:n/a]', '[type: Unknown] ISPC [id:n/a]', '[type: Unknown] ISPC [id:n/a]'); -INSERT INTO ll_landing.compagnies(topiaid, topiaversion, topiacreatedate, status, needComment, lastUpdateDate, code, homeId, label1, label2, label3) VALUES ('fr.ird.referential.ll.landing.Compagnies#1464000000000#0.16', 0,'2019-01-15', 1, FALSE, CURRENT_TIMESTAMP ,'JAMES LESP', 'FINSS-00000129', '[type: Person] LESPERANCE JAMES [id:n/a]', '[type: Person] LESPERANCE JAMES [id:n/a]', '[type: Person] LESPERANCE JAMES [id:n/a]'); -INSERT INTO ll_landing.compagnies(topiaid, topiaversion, topiacreatedate, status, needComment, lastUpdateDate, code, homeId, label1, label2, label3) VALUES ('fr.ird.referential.ll.landing.Compagnies#1464000000000#0.17', 0,'2019-01-15', 1, FALSE, CURRENT_TIMESTAMP ,'JHL', 'FINSS-00003652', '[type: Unknown] JHL GROUP (PTY) Ltd [id:n/a]', '[type: Unknown] JHL GROUP (PTY) Ltd [id:n/a]', '[type: Unknown] JHL GROUP (PTY) Ltd [id:n/a]'); -INSERT INTO ll_landing.compagnies(topiaid, topiaversion, topiacreatedate, status, needComment, lastUpdateDate, code, homeId, label1, label2, label3) VALUES ('fr.ird.referential.ll.landing.Compagnies#1464000000000#0.18', 0,'2019-01-15', 1, FALSE, CURRENT_TIMESTAMP ,'kalanda', 'FINSS-00000177', '[type: Person] Kalandarishvili [id:n/a]', '[type: Person] Kalandarishvili [id:n/a]', '[type: Person] Kalandarishvili [id:n/a]'); -INSERT INTO ll_landing.compagnies(topiaid, topiaversion, topiacreatedate, status, needComment, lastUpdateDate, code, homeId, label1, label2, label3) VALUES ('fr.ird.referential.ll.landing.Compagnies#1464000000000#0.19', 0,'2019-01-15', 1, FALSE, CURRENT_TIMESTAMP ,'LE MURIA', 'FINSS-00003633', '[type: Unknown] LEMEURIA HOTEL [id:n/a]', '[type: Unknown] LEMEURIA HOTEL [id:n/a]', '[type: Unknown] LEMEURIA HOTEL [id:n/a]'); -INSERT INTO ll_landing.compagnies(topiaid, topiaversion, topiacreatedate, status, needComment, lastUpdateDate, code, homeId, label1, label2, label3) VALUES ('fr.ird.referential.ll.landing.Compagnies#1464000000000#0.20', 0,'2019-01-15', 1, FALSE, CURRENT_TIMESTAMP ,'MARINE INV', 'FINSS-00000099', '[type: Organization] MARINE INVESTMENT [id:n/a]', '[type: Organization] MARINE INVESTMENT [id:n/a]', '[type: Organization] MARINE INVESTMENT [id:n/a]'); -INSERT INTO ll_landing.compagnies(topiaid, topiaversion, topiacreatedate, status, needComment, lastUpdateDate, code, homeId, label1, label2, label3) VALUES ('fr.ird.referential.ll.landing.Compagnies#1464000000000#0.21', 0,'2019-01-15', 1, FALSE, CURRENT_TIMESTAMP ,'MGE', 'FINSS-00000128', '[type: Person] MICHEL GEORGE [id:963-0695-1-1-64]', '[type: Person] MICHEL GEORGE [id:963-0695-1-1-64]', '[type: Person] MICHEL GEORGE [id:963-0695-1-1-64]'); -INSERT INTO ll_landing.compagnies(topiaid, topiaversion, topiacreatedate, status, needComment, lastUpdateDate, code, homeId, label1, label2, label3) VALUES ('fr.ird.referential.ll.landing.Compagnies#1464000000000#0.22', 0,'2019-01-15', 1, FALSE, CURRENT_TIMESTAMP ,'OCEAN ', 'FINSS-00003629', '[type: Unknown] OCEAN LONG LINERS LTD [id:n/a]', '[type: Unknown] OCEAN LONG LINERS LTD [id:n/a]', '[type: Unknown] OCEAN LONG LINERS LTD [id:n/a]'); -INSERT INTO ll_landing.compagnies(topiaid, topiaversion, topiacreatedate, status, needComment, lastUpdateDate, code, homeId, label1, label2, label3) VALUES ('fr.ird.referential.ll.landing.Compagnies#1464000000000#0.23', 0,'2019-01-15', 1, FALSE, CURRENT_TIMESTAMP ,'OCEAN HARV', 'FINSS-00000065', '[type: Organization] OCEAN HARVEST FISHERY LTD. [id:n/a]', '[type: Organization] OCEAN HARVEST FISHERY LTD. [id:n/a]', '[type: Organization] OCEAN HARVEST FISHERY LTD. [id:n/a]'); -INSERT INTO ll_landing.compagnies(topiaid, topiaversion, topiacreatedate, status, needComment, lastUpdateDate, code, homeId, label1, label2, label3) VALUES ('fr.ird.referential.ll.landing.Compagnies#1464000000000#0.24', 0,'2019-01-15', 1, FALSE, CURRENT_TIMESTAMP ,'OCEANA', 'FINSS-00000094', '[type: Organization] OCEANA FISHERIES [id:n/a]', '[type: Organization] OCEANA FISHERIES [id:n/a]', '[type: Organization] OCEANA FISHERIES [id:n/a]'); -INSERT INTO ll_landing.compagnies(topiaid, topiaversion, topiacreatedate, status, needComment, lastUpdateDate, code, homeId, label1, label2, label3) VALUES ('fr.ird.referential.ll.landing.Compagnies#1464000000000#0.25', 0,'2019-01-15', 1, FALSE, CURRENT_TIMESTAMP ,'SANS SOUCI', 'FINSS-00000100', '[type: Organization] SANS SOUCI FISHERIES (PTY) LTD [id:n/a]', '[type: Organization] SANS SOUCI FISHERIES (PTY) LTD [id:n/a]', '[type: Organization] SANS SOUCI FISHERIES (PTY) LTD [id:n/a]'); -INSERT INTO ll_landing.compagnies(topiaid, topiaversion, topiacreatedate, status, needComment, lastUpdateDate, code, homeId, label1, label2, label3) VALUES ('fr.ird.referential.ll.landing.Compagnies#1464000000000#0.26', 0,'2019-01-15', 1, FALSE, CURRENT_TIMESTAMP ,'SEA HARVES', 'FINSS-00000132', '[type: Organization] SEA HARVEST [id:n/a]', '[type: Organization] SEA HARVEST [id:n/a]', '[type: Organization] SEA HARVEST [id:n/a]'); -INSERT INTO ll_landing.compagnies(topiaid, topiaversion, topiacreatedate, status, needComment, lastUpdateDate, code, homeId, label1, label2, label3) VALUES ('fr.ird.referential.ll.landing.Compagnies#1464000000000#0.27', 0,'2019-01-15', 1, FALSE, CURRENT_TIMESTAMP ,'SEASTAR', 'FINSS-00000511', '[type: Unknown] SEASTAR [id:n/a]', '[type: Unknown] SEASTAR [id:n/a]', '[type: Unknown] SEASTAR [id:n/a]'); -INSERT INTO ll_landing.compagnies(topiaid, topiaversion, topiacreatedate, status, needComment, lastUpdateDate, code, homeId, label1, label2, label3) VALUES ('fr.ird.referential.ll.landing.Compagnies#1464000000000#0.28', 0,'2019-01-15', 1, FALSE, CURRENT_TIMESTAMP ,'SFA', 'FINSS-00000101', '[type: Organization] SEYCHELLES FISHERIES AUTHORITY [id:n/a]', '[type: Organization] SEYCHELLES FISHERIES AUTHORITY [id:n/a]', '[type: Organization] SEYCHELLES FISHERIES AUTHORITY [id:n/a]'); -INSERT INTO ll_landing.compagnies(topiaid, topiaversion, topiacreatedate, status, needComment, lastUpdateDate, code, homeId, label1, label2, label3) VALUES ('fr.ird.referential.ll.landing.Compagnies#1464000000000#0.29', 0,'2019-01-15', 1, FALSE, CURRENT_TIMESTAMP ,'TROPICALTU', 'FINSS-00003654', '[type: Unknown] Tropical Tuna [id:n/a]', '[type: Unknown] Tropical Tuna [id:n/a]', '[type: Unknown] Tropical Tuna [id:n/a]'); -INSERT INTO ll_landing.compagnies(topiaid, topiaversion, topiacreatedate, status, needComment, lastUpdateDate, code, homeId, label1, label2, label3) VALUES ('fr.ird.referential.ll.landing.Compagnies#1464000000000#0.30', 0,'2019-01-15', 1, FALSE, CURRENT_TIMESTAMP ,'UNK', 'FINSS-00000000', '[type: Organization] Unknown [id:n/a]', '[type: Organization] Unknown [id:n/a]', '[type: Organization] Unknown [id:n/a]'); +INSERT INTO ll_landing.compagnies(topiaid, topiaversion, topiacreatedate, status, needComment, lastUpdateDate, code, homeId, label1, label2, label3) VALUES ('fr.ird.referential.ll.landing.Compagnies#1464000000000#0.01', 0,'2019-01-15', 1, FALSE, ${CURRENT_TIMESTAMP} ,'AFM', 'FINSS-00003638', '[type: Unknown] Amedee [id:n/a]', '[type: Unknown] Amedee [id:n/a]', '[type: Unknown] Amedee [id:n/a]'); +INSERT INTO ll_landing.compagnies(topiaid, topiaversion, topiacreatedate, status, needComment, lastUpdateDate, code, homeId, label1, label2, label3) VALUES ('fr.ird.referential.ll.landing.Compagnies#1464000000000#0.02', 0,'2019-01-15', 1, FALSE, ${CURRENT_TIMESTAMP} ,'AMIRANTES', 'FINSS-00003643', '[type: Unknown] AMIRANTES FISHERIES [id:n/a]', '[type: Unknown] AMIRANTES FISHERIES [id:n/a]', '[type: Unknown] AMIRANTES FISHERIES [id:n/a]'); +INSERT INTO ll_landing.compagnies(topiaid, topiaversion, topiacreatedate, status, needComment, lastUpdateDate, code, homeId, label1, label2, label3) VALUES ('fr.ird.referential.ll.landing.Compagnies#1464000000000#0.03', 0,'2019-01-15', 1, FALSE, ${CURRENT_TIMESTAMP} ,'AMO', 'FINSS-00003557', '[type: Person] Mondon Antoine [id:n/a]', '[type: Person] Mondon Antoine [id:n/a]', '[type: Person] Mondon Antoine [id:n/a]'); +INSERT INTO ll_landing.compagnies(topiaid, topiaversion, topiacreatedate, status, needComment, lastUpdateDate, code, homeId, label1, label2, label3) VALUES ('fr.ird.referential.ll.landing.Compagnies#1464000000000#0.04', 0,'2019-01-15', 1, FALSE, ${CURRENT_TIMESTAMP} ,'ARC', 'FINSS-00003662', '[type: Organization] ARCHIPEL HOTEL [id:n/a]', '[type: Organization] ARCHIPEL HOTEL [id:n/a]', '[type: Organization] ARCHIPEL HOTEL [id:n/a]'); +INSERT INTO ll_landing.compagnies(topiaid, topiaversion, topiacreatedate, status, needComment, lastUpdateDate, code, homeId, label1, label2, label3) VALUES ('fr.ird.referential.ll.landing.Compagnies#1464000000000#0.05', 0,'2019-01-15', 1, FALSE, ${CURRENT_TIMESTAMP} ,'B&E', 'FINSS-00000096', '[type: Organization] B&E ENTERPRISE (PTY) LTD [id:n/a]', '[type: Organization] B&E ENTERPRISE (PTY) LTD [id:n/a]', '[type: Organization] B&E ENTERPRISE (PTY) LTD [id:n/a]'); +INSERT INTO ll_landing.compagnies(topiaid, topiaversion, topiacreatedate, status, needComment, lastUpdateDate, code, homeId, label1, label2, label3) VALUES ('fr.ird.referential.ll.landing.Compagnies#1464000000000#0.06', 0,'2019-01-15', 1, FALSE, ${CURRENT_TIMESTAMP} ,'BFR', 'FINSS-00003535', '[type: Person] Fred Benson,Frederick [id:n/a]', '[type: Person] Fred Benson,Frederick [id:n/a]', '[type: Person] Fred Benson,Frederick [id:n/a]'); +INSERT INTO ll_landing.compagnies(topiaid, topiaversion, topiacreatedate, status, needComment, lastUpdateDate, code, homeId, label1, label2, label3) VALUES ('fr.ird.referential.ll.landing.Compagnies#1464000000000#0.07', 0,'2019-01-15', 1, FALSE, ${CURRENT_TIMESTAMP} ,'DCE', 'FINSS-00003473', '[type: Person] Cedras David,Welton [id:n/a]', '[type: Person] Cedras David,Welton [id:n/a]', '[type: Person] Cedras David,Welton [id:n/a]'); +INSERT INTO ll_landing.compagnies(topiaid, topiaversion, topiacreatedate, status, needComment, lastUpdateDate, code, homeId, label1, label2, label3) VALUES ('fr.ird.referential.ll.landing.Compagnies#1464000000000#0.08', 0,'2019-01-15', 1, FALSE, ${CURRENT_TIMESTAMP} ,'Ephelia', 'FINSS-00003634', '[type: Unknown] Ephelia Constance Hotel [id:n/a]', '[type: Unknown] Ephelia Constance Hotel [id:n/a]', '[type: Unknown] Ephelia Constance Hotel [id:n/a]'); +INSERT INTO ll_landing.compagnies(topiaid, topiaversion, topiacreatedate, status, needComment, lastUpdateDate, code, homeId, label1, label2, label3) VALUES ('fr.ird.referential.ll.landing.Compagnies#1464000000000#0.09', 0,'2019-01-15', 1, FALSE, ${CURRENT_TIMESTAMP} ,'FSS', 'FINSS-00003651', '[type: Unknown] Fresh Seafood Seychelles PTY (LTD) [id:n/a]', '[type: Unknown] Fresh Seafood Seychelles PTY (LTD) [id:n/a]', '[type: Unknown] Fresh Seafood Seychelles PTY (LTD) [id:n/a]'); +INSERT INTO ll_landing.compagnies(topiaid, topiaversion, topiacreatedate, status, needComment, lastUpdateDate, code, homeId, label1, label2, label3) VALUES ('fr.ird.referential.ll.landing.Compagnies#1464000000000#0.10', 0,'2019-01-15', 1, FALSE, ${CURRENT_TIMESTAMP} ,'FTE', 'FINSS-00003663', '[type: Unknown] FISH TECH [id:n/a]', '[type: Unknown] FISH TECH [id:n/a]', '[type: Unknown] FISH TECH [id:n/a]'); +INSERT INTO ll_landing.compagnies(topiaid, topiaversion, topiacreatedate, status, needComment, lastUpdateDate, code, homeId, label1, label2, label3) VALUES ('fr.ird.referential.ll.landing.Compagnies#1464000000000#0.11', 0,'2019-01-15', 1, FALSE, ${CURRENT_TIMESTAMP} ,'GFM', 'FINSS-00003640', '[type: Unknown] George Fishmonger [id:n/a]', '[type: Unknown] George Fishmonger [id:n/a]', '[type: Unknown] George Fishmonger [id:n/a]'); +INSERT INTO ll_landing.compagnies(topiaid, topiaversion, topiacreatedate, status, needComment, lastUpdateDate, code, homeId, label1, label2, label3) VALUES ('fr.ird.referential.ll.landing.Compagnies#1464000000000#0.12', 0,'2019-01-15', 1, FALSE, ${CURRENT_TIMESTAMP} ,'GPO', 'FINSS-00000098', '[type: Person] PORT LOUIS GERARD [id:n/a]', '[type: Person] PORT LOUIS GERARD [id:n/a]', '[type: Person] PORT LOUIS GERARD [id:n/a]'); +INSERT INTO ll_landing.compagnies(topiaid, topiaversion, topiacreatedate, status, needComment, lastUpdateDate, code, homeId, label1, label2, label3) VALUES ('fr.ird.referential.ll.landing.Compagnies#1464000000000#0.13', 0,'2019-01-15', 1, FALSE, ${CURRENT_TIMESTAMP} ,'GRA', 'FINSS-00003347', '[type: Person] Rassool Gilbert,Christophe [id:n/a]', '[type: Person] Rassool Gilbert,Christophe [id:n/a]', '[type: Person] Rassool Gilbert,Christophe [id:n/a]'); +INSERT INTO ll_landing.compagnies(topiaid, topiaversion, topiacreatedate, status, needComment, lastUpdateDate, code, homeId, label1, label2, label3) VALUES ('fr.ird.referential.ll.landing.Compagnies#1464000000000#0.14', 0,'2019-01-15', 1, FALSE, ${CURRENT_TIMESTAMP} ,'HOTEL&REST', 'FINSS-00003624', '[type: Unknown] Hotels and Restaurants [id:n/a]', '[type: Unknown] Hotels and Restaurants [id:n/a]', '[type: Unknown] Hotels and Restaurants [id:n/a]'); +INSERT INTO ll_landing.compagnies(topiaid, topiaversion, topiacreatedate, status, needComment, lastUpdateDate, code, homeId, label1, label2, label3) VALUES ('fr.ird.referential.ll.landing.Compagnies#1464000000000#0.15', 0,'2019-01-15', 1, FALSE, ${CURRENT_TIMESTAMP} ,'IFM', 'FINSS-00003639', '[type: Unknown] ISPC [id:n/a]', '[type: Unknown] ISPC [id:n/a]', '[type: Unknown] ISPC [id:n/a]'); +INSERT INTO ll_landing.compagnies(topiaid, topiaversion, topiacreatedate, status, needComment, lastUpdateDate, code, homeId, label1, label2, label3) VALUES ('fr.ird.referential.ll.landing.Compagnies#1464000000000#0.16', 0,'2019-01-15', 1, FALSE, ${CURRENT_TIMESTAMP} ,'JAMES LESP', 'FINSS-00000129', '[type: Person] LESPERANCE JAMES [id:n/a]', '[type: Person] LESPERANCE JAMES [id:n/a]', '[type: Person] LESPERANCE JAMES [id:n/a]'); +INSERT INTO ll_landing.compagnies(topiaid, topiaversion, topiacreatedate, status, needComment, lastUpdateDate, code, homeId, label1, label2, label3) VALUES ('fr.ird.referential.ll.landing.Compagnies#1464000000000#0.17', 0,'2019-01-15', 1, FALSE, ${CURRENT_TIMESTAMP} ,'JHL', 'FINSS-00003652', '[type: Unknown] JHL GROUP (PTY) Ltd [id:n/a]', '[type: Unknown] JHL GROUP (PTY) Ltd [id:n/a]', '[type: Unknown] JHL GROUP (PTY) Ltd [id:n/a]'); +INSERT INTO ll_landing.compagnies(topiaid, topiaversion, topiacreatedate, status, needComment, lastUpdateDate, code, homeId, label1, label2, label3) VALUES ('fr.ird.referential.ll.landing.Compagnies#1464000000000#0.18', 0,'2019-01-15', 1, FALSE, ${CURRENT_TIMESTAMP} ,'kalanda', 'FINSS-00000177', '[type: Person] Kalandarishvili [id:n/a]', '[type: Person] Kalandarishvili [id:n/a]', '[type: Person] Kalandarishvili [id:n/a]'); +INSERT INTO ll_landing.compagnies(topiaid, topiaversion, topiacreatedate, status, needComment, lastUpdateDate, code, homeId, label1, label2, label3) VALUES ('fr.ird.referential.ll.landing.Compagnies#1464000000000#0.19', 0,'2019-01-15', 1, FALSE, ${CURRENT_TIMESTAMP} ,'LE MURIA', 'FINSS-00003633', '[type: Unknown] LEMEURIA HOTEL [id:n/a]', '[type: Unknown] LEMEURIA HOTEL [id:n/a]', '[type: Unknown] LEMEURIA HOTEL [id:n/a]'); +INSERT INTO ll_landing.compagnies(topiaid, topiaversion, topiacreatedate, status, needComment, lastUpdateDate, code, homeId, label1, label2, label3) VALUES ('fr.ird.referential.ll.landing.Compagnies#1464000000000#0.20', 0,'2019-01-15', 1, FALSE, ${CURRENT_TIMESTAMP} ,'MARINE INV', 'FINSS-00000099', '[type: Organization] MARINE INVESTMENT [id:n/a]', '[type: Organization] MARINE INVESTMENT [id:n/a]', '[type: Organization] MARINE INVESTMENT [id:n/a]'); +INSERT INTO ll_landing.compagnies(topiaid, topiaversion, topiacreatedate, status, needComment, lastUpdateDate, code, homeId, label1, label2, label3) VALUES ('fr.ird.referential.ll.landing.Compagnies#1464000000000#0.21', 0,'2019-01-15', 1, FALSE, ${CURRENT_TIMESTAMP} ,'MGE', 'FINSS-00000128', '[type: Person] MICHEL GEORGE [id:963-0695-1-1-64]', '[type: Person] MICHEL GEORGE [id:963-0695-1-1-64]', '[type: Person] MICHEL GEORGE [id:963-0695-1-1-64]'); +INSERT INTO ll_landing.compagnies(topiaid, topiaversion, topiacreatedate, status, needComment, lastUpdateDate, code, homeId, label1, label2, label3) VALUES ('fr.ird.referential.ll.landing.Compagnies#1464000000000#0.22', 0,'2019-01-15', 1, FALSE, ${CURRENT_TIMESTAMP} ,'OCEAN ', 'FINSS-00003629', '[type: Unknown] OCEAN LONG LINERS LTD [id:n/a]', '[type: Unknown] OCEAN LONG LINERS LTD [id:n/a]', '[type: Unknown] OCEAN LONG LINERS LTD [id:n/a]'); +INSERT INTO ll_landing.compagnies(topiaid, topiaversion, topiacreatedate, status, needComment, lastUpdateDate, code, homeId, label1, label2, label3) VALUES ('fr.ird.referential.ll.landing.Compagnies#1464000000000#0.23', 0,'2019-01-15', 1, FALSE, ${CURRENT_TIMESTAMP} ,'OCEAN HARV', 'FINSS-00000065', '[type: Organization] OCEAN HARVEST FISHERY LTD. [id:n/a]', '[type: Organization] OCEAN HARVEST FISHERY LTD. [id:n/a]', '[type: Organization] OCEAN HARVEST FISHERY LTD. [id:n/a]'); +INSERT INTO ll_landing.compagnies(topiaid, topiaversion, topiacreatedate, status, needComment, lastUpdateDate, code, homeId, label1, label2, label3) VALUES ('fr.ird.referential.ll.landing.Compagnies#1464000000000#0.24', 0,'2019-01-15', 1, FALSE, ${CURRENT_TIMESTAMP} ,'OCEANA', 'FINSS-00000094', '[type: Organization] OCEANA FISHERIES [id:n/a]', '[type: Organization] OCEANA FISHERIES [id:n/a]', '[type: Organization] OCEANA FISHERIES [id:n/a]'); +INSERT INTO ll_landing.compagnies(topiaid, topiaversion, topiacreatedate, status, needComment, lastUpdateDate, code, homeId, label1, label2, label3) VALUES ('fr.ird.referential.ll.landing.Compagnies#1464000000000#0.25', 0,'2019-01-15', 1, FALSE, ${CURRENT_TIMESTAMP} ,'SANS SOUCI', 'FINSS-00000100', '[type: Organization] SANS SOUCI FISHERIES (PTY) LTD [id:n/a]', '[type: Organization] SANS SOUCI FISHERIES (PTY) LTD [id:n/a]', '[type: Organization] SANS SOUCI FISHERIES (PTY) LTD [id:n/a]'); +INSERT INTO ll_landing.compagnies(topiaid, topiaversion, topiacreatedate, status, needComment, lastUpdateDate, code, homeId, label1, label2, label3) VALUES ('fr.ird.referential.ll.landing.Compagnies#1464000000000#0.26', 0,'2019-01-15', 1, FALSE, ${CURRENT_TIMESTAMP} ,'SEA HARVES', 'FINSS-00000132', '[type: Organization] SEA HARVEST [id:n/a]', '[type: Organization] SEA HARVEST [id:n/a]', '[type: Organization] SEA HARVEST [id:n/a]'); +INSERT INTO ll_landing.compagnies(topiaid, topiaversion, topiacreatedate, status, needComment, lastUpdateDate, code, homeId, label1, label2, label3) VALUES ('fr.ird.referential.ll.landing.Compagnies#1464000000000#0.27', 0,'2019-01-15', 1, FALSE, ${CURRENT_TIMESTAMP} ,'SEASTAR', 'FINSS-00000511', '[type: Unknown] SEASTAR [id:n/a]', '[type: Unknown] SEASTAR [id:n/a]', '[type: Unknown] SEASTAR [id:n/a]'); +INSERT INTO ll_landing.compagnies(topiaid, topiaversion, topiacreatedate, status, needComment, lastUpdateDate, code, homeId, label1, label2, label3) VALUES ('fr.ird.referential.ll.landing.Compagnies#1464000000000#0.28', 0,'2019-01-15', 1, FALSE, ${CURRENT_TIMESTAMP} ,'SFA', 'FINSS-00000101', '[type: Organization] SEYCHELLES FISHERIES AUTHORITY [id:n/a]', '[type: Organization] SEYCHELLES FISHERIES AUTHORITY [id:n/a]', '[type: Organization] SEYCHELLES FISHERIES AUTHORITY [id:n/a]'); +INSERT INTO ll_landing.compagnies(topiaid, topiaversion, topiacreatedate, status, needComment, lastUpdateDate, code, homeId, label1, label2, label3) VALUES ('fr.ird.referential.ll.landing.Compagnies#1464000000000#0.29', 0,'2019-01-15', 1, FALSE, ${CURRENT_TIMESTAMP} ,'TROPICALTU', 'FINSS-00003654', '[type: Unknown] Tropical Tuna [id:n/a]', '[type: Unknown] Tropical Tuna [id:n/a]', '[type: Unknown] Tropical Tuna [id:n/a]'); +INSERT INTO ll_landing.compagnies(topiaid, topiaversion, topiacreatedate, status, needComment, lastUpdateDate, code, homeId, label1, label2, label3) VALUES ('fr.ird.referential.ll.landing.Compagnies#1464000000000#0.30', 0,'2019-01-15', 1, FALSE, ${CURRENT_TIMESTAMP} ,'UNK', 'FINSS-00000000', '[type: Organization] Unknown [id:n/a]', '[type: Organization] Unknown [id:n/a]', '[type: Organization] Unknown [id:n/a]'); ===================================== persistence/src/main/resources/db/migration/8.0/90_ll_landing_finalize-common.sql ===================================== @@ -51,8 +51,8 @@ CREATE INDEX idx_ll_landing_datasource_lastupdatedate ON ll_landing.datasource(l CREATE INDEX idx_ll_landing_landingpart_lastupdatedate ON ll_landing.landingpart(lastupdatedate); CREATE INDEX idx_ll_landing_landing_lastupdatedate ON ll_landing.landing(lastupdatedate); -INSERT INTO common.LASTUPDATEDATE(topiaId, topiaversion, topiacreatedate, TYPE , LASTUPDATEDATE) values ('fr.ird.common.LastUpdateDate#666#1021', 0,CURRENT_DATE, 'fr.ird.observe.entities.data.ll.landing.Landing', CURRENT_TIMESTAMP); -INSERT INTO common.LASTUPDATEDATE(topiaId, topiaversion, topiacreatedate, TYPE , LASTUPDATEDATE) values ('fr.ird.common.LastUpdateDate#666#1022', 0,CURRENT_DATE, 'fr.ird.observe.entities.data.ll.landing.LandingPart', CURRENT_TIMESTAMP); +INSERT INTO common.LASTUPDATEDATE(topiaId, topiaversion, topiacreatedate, TYPE , LASTUPDATEDATE) values ('fr.ird.common.LastUpdateDate#666#1021', 0,${CURRENT_DATE}, 'fr.ird.observe.entities.data.ll.landing.Landing', ${CURRENT_TIMESTAMP}); +INSERT INTO common.LASTUPDATEDATE(topiaId, topiaversion, topiacreatedate, TYPE , LASTUPDATEDATE) values ('fr.ird.common.LastUpdateDate#666#1022', 0,${CURRENT_DATE}, 'fr.ird.observe.entities.data.ll.landing.LandingPart', ${CURRENT_TIMESTAMP}); UPDATE common.LASTUPDATEDATE SET TYPE = REPLACE(TYPE, 'referentiel.Compagnies' , 'referential.ll.landing.Compagnies'); UPDATE common.LASTUPDATEDATE SET TYPE = replace(TYPE, 'referentiel.longline.Conservation', 'referential.ll.landing.Conservation'); ===================================== test/src/main/resources/db/8.0/dataForTestLongline.sql.gz ===================================== Binary files a/test/src/main/resources/db/8.0/dataForTestLongline.sql.gz and b/test/src/main/resources/db/8.0/dataForTestLongline.sql.gz differ ===================================== test/src/main/resources/db/8.0/dataForTestSeine.sql.gz ===================================== Binary files a/test/src/main/resources/db/8.0/dataForTestSeine.sql.gz and b/test/src/main/resources/db/8.0/dataForTestSeine.sql.gz differ ===================================== test/src/main/resources/db/8.0/referentiel.sql.gz ===================================== Binary files a/test/src/main/resources/db/8.0/referentiel.sql.gz and b/test/src/main/resources/db/8.0/referentiel.sql.gz differ View it on GitLab: https://gitlab.com/ultreiaio/ird-observe/-/commit/9841ce6310f020f1003c0df413... -- View it on GitLab: https://gitlab.com/ultreiaio/ird-observe/-/commit/9841ce6310f020f1003c0df413... You're receiving this email because of your account on gitlab.com.