[Observe-commits] 03/04: Correction des migrations pg

This is an automated email from the git hooks/post-receive script. New commit to branch develop in repository observe. See https://gitlab.nuiton.org/codelutin/observe.git commit c1d84b09350ce90eac59501d0fad86b37cf20e2e Author: Tony CHEMIT <chemit@codelutin.com> Date: Fri Nov 4 16:52:51 2016 +0100 Correction des migrations pg --- ..._1_03_evol_6997_delete_supportVesselName-PG.sql | 2 +- .../V5_1_07_evol_8389_rename_source_columns-PG.sql | 8 +-- .../5.1/V5_1_08_1_evol_8390_measure_type-PG.sql | 11 ++++ .../5.1/V5_1_08_evol_8390_measure_type-PG.sql | 10 ++-- .../V5_1_13_evol_7901_add_armateur_table-PG.sql | 58 +++++++++++----------- 5 files changed, 50 insertions(+), 39 deletions(-) diff --git a/entities-migration/src/main/resources/db/migration/5.1/V5_1_03_evol_6997_delete_supportVesselName-PG.sql b/entities-migration/src/main/resources/db/migration/5.1/V5_1_03_evol_6997_delete_supportVesselName-PG.sql index fc7374f..e344734 100644 --- a/entities-migration/src/main/resources/db/migration/5.1/V5_1_03_evol_6997_delete_supportVesselName-PG.sql +++ b/entities-migration/src/main/resources/db/migration/5.1/V5_1_03_evol_6997_delete_supportVesselName-PG.sql @@ -1 +1 @@ -ALTER TABLE observe_seine.floatingobject DROP COLUMN supportVesselName; \ No newline at end of file +ALTER TABLE observe_seine.floatingobject DROP COLUMN supportVesselName CASCADE; \ No newline at end of file diff --git a/entities-migration/src/main/resources/db/migration/5.1/V5_1_07_evol_8389_rename_source_columns-PG.sql b/entities-migration/src/main/resources/db/migration/5.1/V5_1_07_evol_8389_rename_source_columns-PG.sql index dfb007e..d315ff7 100644 --- a/entities-migration/src/main/resources/db/migration/5.1/V5_1_07_evol_8389_rename_source_columns-PG.sql +++ b/entities-migration/src/main/resources/db/migration/5.1/V5_1_07_evol_8389_rename_source_columns-PG.sql @@ -1,4 +1,4 @@ -ALTER TABLE observe_seine.nontargetlength ALTER COLUMN lengthSource RENAME TO isLengthComputed; -ALTER TABLE observe_seine.nontargetlength ALTER COLUMN weightSource RENAME TO isWeightComputed; -ALTER TABLE observe_seine.targetlength ALTER COLUMN lengthSource RENAME TO isLengthComputed; -ALTER TABLE observe_seine.targetlength ALTER COLUMN weightSource RENAME TO isWeightComputed; \ No newline at end of file +ALTER TABLE observe_seine.nontargetlength RENAME COLUMN lengthSource TO isLengthComputed; +ALTER TABLE observe_seine.nontargetlength RENAME COLUMN weightSource TO isWeightComputed; +ALTER TABLE observe_seine.targetlength RENAME COLUMN lengthSource TO isLengthComputed; +ALTER TABLE observe_seine.targetlength RENAME COLUMN weightSource TO isWeightComputed; \ No newline at end of file diff --git a/entities-migration/src/main/resources/db/migration/5.1/V5_1_08_1_evol_8390_measure_type-PG.sql b/entities-migration/src/main/resources/db/migration/5.1/V5_1_08_1_evol_8390_measure_type-PG.sql new file mode 100644 index 0000000..6497b96 --- /dev/null +++ b/entities-migration/src/main/resources/db/migration/5.1/V5_1_08_1_evol_8390_measure_type-PG.sql @@ -0,0 +1,11 @@ +ALTER TABLE observe_seine.targetLength DROP COLUMN sizeMeasureType CASCADE; +ALTER TABLE observe_seine.targetLength RENAME COLUMN sizeMeasureType2 TO sizeMeasureType; +ALTER TABLE observe_seine.targetlength ADD CONSTRAINT fk_targetLength_sizeMeasureType FOREIGN KEY(sizeMeasureType) REFERENCES observe_common.sizeMeasureType(topiaId); + +ALTER TABLE observe_longline.sizeMeasure DROP COLUMN sizeMeasureType CASCADE; +ALTER TABLE observe_longline.sizeMeasure RENAME COLUMN sizeMeasureType2 TO sizeMeasureType; +ALTER TABLE observe_longline.sizeMeasure ADD CONSTRAINT fk_sizeMeasure_sizeMeasureType FOREIGN KEY(sizeMeasureType) REFERENCES observe_common.sizeMeasureType(topiaId); + +ALTER TABLE observe_longline.weightMeasure DROP COLUMN weightMeasureType CASCADE; +ALTER TABLE observe_longline.weightMeasure RENAME COLUMN weightMeasureType2 TO weightMeasureType; +ALTER TABLE observe_longline.weightMeasure ADD CONSTRAINT fk_weightMeasure_weightMeasureType FOREIGN KEY(weightMeasureType) REFERENCES observe_common.weightMeasureType(topiaId); \ No newline at end of file diff --git a/entities-migration/src/main/resources/db/migration/5.1/V5_1_08_evol_8390_measure_type-PG.sql b/entities-migration/src/main/resources/db/migration/5.1/V5_1_08_evol_8390_measure_type-PG.sql index fa33d6f..d92f195 100644 --- a/entities-migration/src/main/resources/db/migration/5.1/V5_1_08_evol_8390_measure_type-PG.sql +++ b/entities-migration/src/main/resources/db/migration/5.1/V5_1_08_evol_8390_measure_type-PG.sql @@ -1,10 +1,10 @@ -CREATE TABLE observe_common.SIZEMEASURETYPE( topiaid character varying(255) NOT NULL,topiaversion BIGINT NOT NULL, topiacreatedate DATE, lastupdatedate TIMESTAMP NOT NULL, code character varying(255), status INTEGER DEFAULT 1, uri character varying(255), label1 character varying(255), label2 character varying(255), label3 character varying(255), label4 character varying(255), label5 character varying(255), label6 character varying(255), label7 character varying(255), label8 character var [...] +CREATE TABLE observe_common.SIZEMEASURETYPE( topiaid character varying(255) NOT NULL,topiaversion BIGINT NOT NULL, topiacreatedate DATE, lastupdatedate TIMESTAMP NOT NULL, code character varying(255), status INTEGER DEFAULT 1, needComment BOOLEAN DEFAULT false, uri character varying(255), label1 character varying(255), label2 character varying(255), label3 character varying(255), label4 character varying(255), label5 character varying(255), label6 character varying(255), label7 character [...] ALTER TABLE observe_common.SIZEMEASURETYPE ADD CONSTRAINT PK_SIZEMEASURETYPE PRIMARY KEY(TOPIAID); -INSERT INTO observe_common.SIZEMEASURETYPE(topiaId, topiaversion, topiacreatedate, lastupdatedate, code, status, uri, label1, label2, label3, label4, label5, label6, label7, label8) (SELECT topiaId, topiaversion, topiacreatedate, lastupdatedate, code, status, uri, label1, label2, label3, label4, label5, label6, label7, label8 FROM OBSERVE_LONGLINE.SIZEMEASURETYPE); +INSERT INTO observe_common.SIZEMEASURETYPE(topiaId, topiaversion, topiacreatedate, lastupdatedate, code, status, needcomment, uri, label1, label2, label3, label4, label5, label6, label7, label8) (SELECT topiaId, topiaversion, topiacreatedate, lastupdatedate, code, status, needcomment, uri, label1, label2, label3, label4, label5, label6, label7, label8 FROM OBSERVE_LONGLINE.SIZEMEASURETYPE); -CREATE TABLE observe_common.WEIGHTMEASURETYPE( topiaid character varying(255) NOT NULL,topiaversion BIGINT NOT NULL, topiacreatedate DATE, lastupdatedate TIMESTAMP NOT NULL, code character varying(255), status INTEGER DEFAULT 1, uri character varying(255), label1 character varying(255), label2 character varying(255), label3 character varying(255), label4 character varying(255), label5 character varying(255), label6 character varying(255), label7 character varying(255), label8 character v [...] +CREATE TABLE observe_common.WEIGHTMEASURETYPE( topiaid character varying(255) NOT NULL,topiaversion BIGINT NOT NULL, topiacreatedate DATE, lastupdatedate TIMESTAMP NOT NULL, code character varying(255), status INTEGER DEFAULT 1, needComment BOOLEAN DEFAULT false, uri character varying(255), label1 character varying(255), label2 character varying(255), label3 character varying(255), label4 character varying(255), label5 character varying(255), label6 character varying(255), label7 charact [...] ALTER TABLE observe_common.WEIGHTMEASURETYPE ADD CONSTRAINT PK_WEIGHTMEASURETYPE PRIMARY KEY(TOPIAID); -INSERT INTO observe_common.WEIGHTMEASURETYPE( topiaid, topiaversion, topiacreatedate, lastupdatedate, code, status, uri, label1, label2, label3, label4, label5, label6, label7, label8) (SELECT topiaId, topiaversion, topiacreatedate, lastupdatedate, code, status, uri, label1, label2, label3, label4, label5, label6, label7, label8 FROM OBSERVE_LONGLINE.WEIGHTMEASURETYPE); +INSERT INTO observe_common.WEIGHTMEASURETYPE( topiaid, topiaversion, topiacreatedate, lastupdatedate, code, status, needcomment, uri, label1, label2, label3, label4, label5, label6, label7, label8) (SELECT topiaId, topiaversion, topiacreatedate, lastupdatedate, code, status, needcomment, uri, label1, label2, label3, label4, label5, label6, label7, label8 FROM OBSERVE_LONGLINE.WEIGHTMEASURETYPE); UPDATE observe_common.LASTUPDATEDATE SET TYPE = 'fr.ird.observe.entities.referentiel.SizeMeasureType' WHERE TYPE = 'fr.ird.observe.entities.referentiel.longline.SizeMeasureType'; UPDATE observe_common.LASTUPDATEDATE SET TYPE = 'fr.ird.observe.entities.referentiel.WeightMeasureType' WHERE TYPE = 'fr.ird.observe.entities.referentiel.longline.WeightMeasureType'; @@ -13,7 +13,7 @@ ALTER TABLE observe_seine.targetlength ADD COLUMN sizeMeasureType character vary UPDATE observe_seine.targetlength SET sizeMeasureType = NULL WHERE measureType = 0; UPDATE observe_seine.targetlength SET sizeMeasureType = (select topiaid from observe_longline.sizemeasuretype where label1 ='PDL') WHERE measureType = 1; UPDATE observe_seine.targetlength SET sizeMeasureType =(select topiaid from observe_longline.sizemeasuretype where label1='FL') WHERE measureType = 2; -ALTER TABLE observe_seine.targetlength DROP COLUMN measureType; +ALTER TABLE observe_seine.targetlength DROP COLUMN measureType CASCADE; ALTER TABLE observe_seine.targetlength ADD COLUMN sizeMeasureType2 character varying(255); ALTER TABLE observe_longline.sizeMeasure ADD COLUMN sizeMeasureType2 character varying(255); diff --git a/entities-migration/src/main/resources/db/migration/5.1/V5_1_13_evol_7901_add_armateur_table-PG.sql b/entities-migration/src/main/resources/db/migration/5.1/V5_1_13_evol_7901_add_armateur_table-PG.sql index cdded22..101a7c8 100644 --- a/entities-migration/src/main/resources/db/migration/5.1/V5_1_13_evol_7901_add_armateur_table-PG.sql +++ b/entities-migration/src/main/resources/db/migration/5.1/V5_1_13_evol_7901_add_armateur_table-PG.sql @@ -1,35 +1,35 @@ -CREATE TABLE observe_common.shipOwner( topiaid character varying(255) NOT NULL,topiaversion BIGINT NOT NULL, topiacreatedate DATE, lastupdatedate TIMESTAMP NOT NULL, code character varying(255), status INTEGER DEFAULT 1, needComment BOOLEAN, uri character varying(255), label character varying(255), country character varying(255), startDate DATE, endDate DATE); +CREATE TABLE observe_common.shipOwner( topiaid character varying(255) NOT NULL,topiaversion BIGINT NOT NULL, topiacreatedate DATE, lastupdatedate TIMESTAMP NOT NULL, code character varying(255), status INTEGER DEFAULT 1, needComment BOOLEAN DEFAULT false, uri character varying(255), label character varying(255), country character varying(255), startDate DATE, endDate DATE); ALTER TABLE observe_common.shipOwner ADD CONSTRAINT PK_SHIP_OWNER PRIMARY KEY(topiaid); ALTER TABLE observe_common.shipOwner ADD CONSTRAINT FK_SHIP_OWNER_COUNTRY FOREIGN KEY(country) REFERENCES observe_common.country(topiaid); -CREATE INDEX observe_common.INDEX_OBSERVE_COMMON_SHIP_OWNER_COUNTRY ON observe_common.shipOwner(country); +CREATE INDEX INDEX_OBSERVE_COMMON_SHIP_OWNER_COUNTRY ON observe_common.shipOwner(country); -INSERT INTO observe_common.shipOwner (topiaid, topiaversion, topiacreatedate, lastupdatedate, status, code, label, country) values ('fr.ird.observe.entities.referentiel.ShipOwner#0#0', 0, CURRENT_DATE, CURRENT_TIMESTAMP, 0, '1','SAUPIQUET', 'fr.ird.observe.entities.referentiel.Country#1239832675583#0.9493110781716075'); -INSERT INTO observe_common.shipOwner (topiaid, topiaversion, topiacreatedate, lastupdatedate, status, code, label, country) values ('fr.ird.observe.entities.referentiel.ShipOwner#0#1', 0, CURRENT_DATE, CURRENT_TIMESTAMP, 0, '2','SAPMER', 'fr.ird.observe.entities.referentiel.Country#1239832675583#0.9493110781716075'); -INSERT INTO observe_common.shipOwner (topiaid, topiaversion, topiacreatedate, lastupdatedate, status, code, label, country) values ('fr.ird.observe.entities.referentiel.ShipOwner#0#2', 0, CURRENT_DATE, CURRENT_TIMESTAMP, 0, '3','CFTO', 'fr.ird.observe.entities.referentiel.Country#1239832675583#0.9493110781716075'); -INSERT INTO observe_common.shipOwner (topiaid, topiaversion, topiacreatedate, lastupdatedate, status, code, label, country) values ('fr.ird.observe.entities.referentiel.ShipOwner#0#3', 0, CURRENT_DATE, CURRENT_TIMESTAMP, 0, '4','IOSMS', 'fr.ird.observe.entities.referentiel.Country#1239832675583#0.9493110781716075'); -INSERT INTO observe_common.shipOwner (topiaid, topiaversion, topiacreatedate, lastupdatedate, status, code, label, country) values ('fr.ird.observe.entities.referentiel.ShipOwner#0#4', 0, CURRENT_DATE, CURRENT_TIMESTAMP, 0, '5','TFC', 'fr.ird.observe.entities.referentiel.Country#1239832675583#0.9493110781716075'); -INSERT INTO observe_common.shipOwner (topiaid, topiaversion, topiacreatedate, lastupdatedate, status, code, label, country) values ('fr.ird.observe.entities.referentiel.ShipOwner#0#5', 0, CURRENT_DATE, CURRENT_TIMESTAMP, 0, '6','ACF', 'fr.ird.observe.entities.referentiel.Country#1239832675583#0.9493110781716075'); -INSERT INTO observe_common.shipOwner (topiaid, topiaversion, topiacreatedate, lastupdatedate, status, code, label, country) values ('fr.ird.observe.entities.referentiel.ShipOwner#0#6', 0, CURRENT_DATE, CURRENT_TIMESTAMP, 0, '7','CMB', 'fr.ird.observe.entities.referentiel.Country#1239832675583#0.9493110781716075'); -INSERT INTO observe_common.shipOwner (topiaid, topiaversion, topiacreatedate, lastupdatedate, status, code, label, country) values ('fr.ird.observe.entities.referentiel.ShipOwner#0#7', 0, CURRENT_DATE, CURRENT_TIMESTAMP, 0, '8','PECHE ET FROID', 'fr.ird.observe.entities.referentiel.Country#1239832675583#0.9493110781716075'); -INSERT INTO observe_common.shipOwner (topiaid, topiaversion, topiacreatedate, lastupdatedate, status, code, label, country) values ('fr.ird.observe.entities.referentiel.ShipOwner#0#8', 0, CURRENT_DATE, CURRENT_TIMESTAMP, 0, '9','IAT', 'fr.ird.observe.entities.referentiel.Country#1239832675583#0.9493110781716075'); -INSERT INTO observe_common.shipOwner (topiaid, topiaversion, topiacreatedate, lastupdatedate, status, code, label, country) values ('fr.ird.observe.entities.referentiel.ShipOwner#0#9', 0, CURRENT_DATE, CURRENT_TIMESTAMP, 0, '10','LE BOUTER', 'fr.ird.observe.entities.referentiel.Country#1239832675583#0.9493110781716075'); -INSERT INTO observe_common.shipOwner (topiaid, topiaversion, topiacreatedate, lastupdatedate, status, code, label, country) values ('fr.ird.observe.entities.referentiel.ShipOwner#0#10', 0, CURRENT_DATE, CURRENT_TIMESTAMP, 0, '11','ACF/CMB', 'fr.ird.observe.entities.referentiel.Country#1239832675583#0.9493110781716075'); -INSERT INTO observe_common.shipOwner (topiaid, topiaversion, topiacreatedate, lastupdatedate, status, code, label, country) values ('fr.ird.observe.entities.referentiel.ShipOwner#0#11', 0, CURRENT_DATE, CURRENT_TIMESTAMP, 0, '12','COBRECAF', 'fr.ird.observe.entities.referentiel.Country#1239832675583#0.9493110781716075'); -INSERT INTO observe_common.shipOwner (topiaid, topiaversion, topiacreatedate, lastupdatedate, status, code, label, country) values ('fr.ird.observe.entities.referentiel.ShipOwner#0#12', 0, CURRENT_DATE, CURRENT_TIMESTAMP, 0, '13','CHARLOT', 'fr.ird.observe.entities.referentiel.Country#1239832675583#0.9493110781716075'); -INSERT INTO observe_common.shipOwner (topiaid, topiaversion, topiacreatedate, lastupdatedate, status, code, label, country) values ('fr.ird.observe.entities.referentiel.ShipOwner#0#13', 0, CURRENT_DATE, CURRENT_TIMESTAMP, 0, '14','HARTSWATER', 'fr.ird.observe.entities.referentiel.Country#1239832675583#0.9493110781716075'); -INSERT INTO observe_common.shipOwner (topiaid, topiaversion, topiacreatedate, lastupdatedate, status, code, label, country) values ('fr.ird.observe.entities.referentiel.ShipOwner#0#14', 0, CURRENT_DATE, CURRENT_TIMESTAMP, 0, '15','PEVASA', 'fr.ird.observe.entities.referentiel.Country#1239832675584#0.0783072255559325'); -INSERT INTO observe_common.shipOwner (topiaid, topiaversion, topiacreatedate, lastupdatedate, status, code, label, country) values ('fr.ird.observe.entities.referentiel.ShipOwner#0#15', 0, CURRENT_DATE, CURRENT_TIMESTAMP, 0, '16','ECHEBASTAR', 'fr.ird.observe.entities.referentiel.Country#1239832675584#0.0783072255559325'); -INSERT INTO observe_common.shipOwner (topiaid, topiaversion, topiacreatedate, lastupdatedate, status, code, label, country) values ('fr.ird.observe.entities.referentiel.ShipOwner#0#16', 0, CURRENT_DATE, CURRENT_TIMESTAMP, 0, '17','ISABELLA FISHING', 'fr.ird.observe.entities.referentiel.Country#1239832675584#0.0783072255559325'); -INSERT INTO observe_common.shipOwner (topiaid, topiaversion, topiacreatedate, lastupdatedate, status, code, label, country) values ('fr.ird.observe.entities.referentiel.ShipOwner#0#17', 0, CURRENT_DATE, CURRENT_TIMESTAMP, 0, '18','ATUNSA', 'fr.ird.observe.entities.referentiel.Country#1239832675584#0.0783072255559325'); -INSERT INTO observe_common.shipOwner (topiaid, topiaversion, topiacreatedate, lastupdatedate, status, code, label, country) values ('fr.ird.observe.entities.referentiel.ShipOwner#0#18', 0, CURRENT_DATE, CURRENT_TIMESTAMP, 0, '19','ALBACORA', 'fr.ird.observe.entities.referentiel.Country#1239832675584#0.0783072255559325'); -INSERT INTO observe_common.shipOwner (topiaid, topiaversion, topiacreatedate, lastupdatedate, status, code, label, country) values ('fr.ird.observe.entities.referentiel.ShipOwner#0#19', 0, CURRENT_DATE, CURRENT_TIMESTAMP, 0, '20','DONWONG', 'fr.ird.observe.entities.referentiel.Country#1239832675585#0.7535948739996284'); -INSERT INTO observe_common.shipOwner (topiaid, topiaversion, topiacreatedate, lastupdatedate, status, code, label, country) values ('fr.ird.observe.entities.referentiel.ShipOwner#0#20', 0, CURRENT_DATE, CURRENT_TIMESTAMP, 0, '21','ENEZ DU', 'fr.ird.observe.entities.referentiel.Country#1239832675583#0.9493110781716075'); -INSERT INTO observe_common.shipOwner (topiaid, topiaversion, topiacreatedate, lastupdatedate, status, code, label, country) values ('fr.ird.observe.entities.referentiel.ShipOwner#0#21', 0, CURRENT_DATE, CURRENT_TIMESTAMP, 0, '22','MINATCHY', 'fr.ird.observe.entities.referentiel.Country#1239832675583#0.9493110781716075'); -INSERT INTO observe_common.shipOwner (topiaid, topiaversion, topiacreatedate, lastupdatedate, status, code, label, country) values ('fr.ird.observe.entities.referentiel.ShipOwner#0#22', 0, CURRENT_DATE, CURRENT_TIMESTAMP, 0, '23','PECHE AVENIR', 'fr.ird.observe.entities.referentiel.Country#1239832675583#0.9493110781716075'); -INSERT INTO observe_common.shipOwner (topiaid, topiaversion, topiacreatedate, lastupdatedate, status, code, label, country) values ('fr.ird.observe.entities.referentiel.ShipOwner#0#23', 0, CURRENT_DATE, CURRENT_TIMESTAMP, 0, '24','INPESCA', 'fr.ird.observe.entities.referentiel.Country#1239832675584#0.0783072255559325'); -INSERT INTO observe_common.shipOwner (topiaid, topiaversion, topiacreatedate, lastupdatedate, status, code, label, country) values ('fr.ird.observe.entities.referentiel.ShipOwner#0#24', 0, CURRENT_DATE, CURRENT_TIMESTAMP, 0, '25','CALVO', 'fr.ird.observe.entities.referentiel.Country#1239832675584#0.0783072255559325'); -INSERT INTO observe_common.shipOwner (topiaid, topiaversion, topiacreatedate, lastupdatedate, status, code, label, country) values ('fr.ird.observe.entities.referentiel.ShipOwner#0#25', 0, CURRENT_DATE, CURRENT_TIMESTAMP, 0, '26','NICRA', 'fr.ird.observe.entities.referentiel.Country#1239832675584#0.0783072255559325'); -INSERT INTO observe_common.shipOwner (topiaid, topiaversion, topiacreatedate, lastupdatedate, status, code, label, needComment) values ('fr.ird.observe.entities.referentiel.ShipOwner#0#26', 0, CURRENT_DATE, CURRENT_TIMESTAMP, 0, '999','UND', true); +INSERT INTO observe_common.shipOwner (topiaid, topiaversion, topiacreatedate, lastupdatedate, status, code, label, country) values ('fr.ird.observe.entities.referentiel.ShipOwner#0#0', 0, CURRENT_DATE, CURRENT_TIMESTAMP, 1, '1','SAUPIQUET', 'fr.ird.observe.entities.referentiel.Country#1239832675583#0.9493110781716075'); +INSERT INTO observe_common.shipOwner (topiaid, topiaversion, topiacreatedate, lastupdatedate, status, code, label, country) values ('fr.ird.observe.entities.referentiel.ShipOwner#0#1', 0, CURRENT_DATE, CURRENT_TIMESTAMP, 1, '2','SAPMER', 'fr.ird.observe.entities.referentiel.Country#1239832675583#0.9493110781716075'); +INSERT INTO observe_common.shipOwner (topiaid, topiaversion, topiacreatedate, lastupdatedate, status, code, label, country) values ('fr.ird.observe.entities.referentiel.ShipOwner#0#2', 0, CURRENT_DATE, CURRENT_TIMESTAMP, 1, '3','CFTO', 'fr.ird.observe.entities.referentiel.Country#1239832675583#0.9493110781716075'); +INSERT INTO observe_common.shipOwner (topiaid, topiaversion, topiacreatedate, lastupdatedate, status, code, label, country) values ('fr.ird.observe.entities.referentiel.ShipOwner#0#3', 0, CURRENT_DATE, CURRENT_TIMESTAMP, 1, '4','IOSMS', 'fr.ird.observe.entities.referentiel.Country#1239832675583#0.9493110781716075'); +INSERT INTO observe_common.shipOwner (topiaid, topiaversion, topiacreatedate, lastupdatedate, status, code, label, country) values ('fr.ird.observe.entities.referentiel.ShipOwner#0#4', 0, CURRENT_DATE, CURRENT_TIMESTAMP, 1, '5','TFC', 'fr.ird.observe.entities.referentiel.Country#1239832675583#0.9493110781716075'); +INSERT INTO observe_common.shipOwner (topiaid, topiaversion, topiacreatedate, lastupdatedate, status, code, label, country) values ('fr.ird.observe.entities.referentiel.ShipOwner#0#5', 0, CURRENT_DATE, CURRENT_TIMESTAMP, 1, '6','ACF', 'fr.ird.observe.entities.referentiel.Country#1239832675583#0.9493110781716075'); +INSERT INTO observe_common.shipOwner (topiaid, topiaversion, topiacreatedate, lastupdatedate, status, code, label, country) values ('fr.ird.observe.entities.referentiel.ShipOwner#0#6', 0, CURRENT_DATE, CURRENT_TIMESTAMP, 1, '7','CMB', 'fr.ird.observe.entities.referentiel.Country#1239832675583#0.9493110781716075'); +INSERT INTO observe_common.shipOwner (topiaid, topiaversion, topiacreatedate, lastupdatedate, status, code, label, country) values ('fr.ird.observe.entities.referentiel.ShipOwner#0#7', 0, CURRENT_DATE, CURRENT_TIMESTAMP, 1, '8','PECHE ET FROID', 'fr.ird.observe.entities.referentiel.Country#1239832675583#0.9493110781716075'); +INSERT INTO observe_common.shipOwner (topiaid, topiaversion, topiacreatedate, lastupdatedate, status, code, label, country) values ('fr.ird.observe.entities.referentiel.ShipOwner#0#8', 0, CURRENT_DATE, CURRENT_TIMESTAMP, 1, '9','IAT', 'fr.ird.observe.entities.referentiel.Country#1239832675583#0.9493110781716075'); +INSERT INTO observe_common.shipOwner (topiaid, topiaversion, topiacreatedate, lastupdatedate, status, code, label, country) values ('fr.ird.observe.entities.referentiel.ShipOwner#0#9', 0, CURRENT_DATE, CURRENT_TIMESTAMP, 1, '10','LE BOUTER', 'fr.ird.observe.entities.referentiel.Country#1239832675583#0.9493110781716075'); +INSERT INTO observe_common.shipOwner (topiaid, topiaversion, topiacreatedate, lastupdatedate, status, code, label, country) values ('fr.ird.observe.entities.referentiel.ShipOwner#0#10', 0, CURRENT_DATE, CURRENT_TIMESTAMP, 1, '11','ACF/CMB', 'fr.ird.observe.entities.referentiel.Country#1239832675583#0.9493110781716075'); +INSERT INTO observe_common.shipOwner (topiaid, topiaversion, topiacreatedate, lastupdatedate, status, code, label, country) values ('fr.ird.observe.entities.referentiel.ShipOwner#0#11', 0, CURRENT_DATE, CURRENT_TIMESTAMP, 1, '12','COBRECAF', 'fr.ird.observe.entities.referentiel.Country#1239832675583#0.9493110781716075'); +INSERT INTO observe_common.shipOwner (topiaid, topiaversion, topiacreatedate, lastupdatedate, status, code, label, country) values ('fr.ird.observe.entities.referentiel.ShipOwner#0#12', 0, CURRENT_DATE, CURRENT_TIMESTAMP, 1, '13','CHARLOT', 'fr.ird.observe.entities.referentiel.Country#1239832675583#0.9493110781716075'); +INSERT INTO observe_common.shipOwner (topiaid, topiaversion, topiacreatedate, lastupdatedate, status, code, label, country) values ('fr.ird.observe.entities.referentiel.ShipOwner#0#13', 0, CURRENT_DATE, CURRENT_TIMESTAMP, 1, '14','HARTSWATER', 'fr.ird.observe.entities.referentiel.Country#1239832675583#0.9493110781716075'); +INSERT INTO observe_common.shipOwner (topiaid, topiaversion, topiacreatedate, lastupdatedate, status, code, label, country) values ('fr.ird.observe.entities.referentiel.ShipOwner#0#14', 0, CURRENT_DATE, CURRENT_TIMESTAMP, 1, '15','PEVASA', 'fr.ird.observe.entities.referentiel.Country#1239832675584#0.0783072255559325'); +INSERT INTO observe_common.shipOwner (topiaid, topiaversion, topiacreatedate, lastupdatedate, status, code, label, country) values ('fr.ird.observe.entities.referentiel.ShipOwner#0#15', 0, CURRENT_DATE, CURRENT_TIMESTAMP, 1, '16','ECHEBASTAR', 'fr.ird.observe.entities.referentiel.Country#1239832675584#0.0783072255559325'); +INSERT INTO observe_common.shipOwner (topiaid, topiaversion, topiacreatedate, lastupdatedate, status, code, label, country) values ('fr.ird.observe.entities.referentiel.ShipOwner#0#16', 0, CURRENT_DATE, CURRENT_TIMESTAMP, 1, '17','ISABELLA FISHING', 'fr.ird.observe.entities.referentiel.Country#1239832675584#0.0783072255559325'); +INSERT INTO observe_common.shipOwner (topiaid, topiaversion, topiacreatedate, lastupdatedate, status, code, label, country) values ('fr.ird.observe.entities.referentiel.ShipOwner#0#17', 0, CURRENT_DATE, CURRENT_TIMESTAMP, 1, '18','ATUNSA', 'fr.ird.observe.entities.referentiel.Country#1239832675584#0.0783072255559325'); +INSERT INTO observe_common.shipOwner (topiaid, topiaversion, topiacreatedate, lastupdatedate, status, code, label, country) values ('fr.ird.observe.entities.referentiel.ShipOwner#0#18', 0, CURRENT_DATE, CURRENT_TIMESTAMP, 1, '19','ALBACORA', 'fr.ird.observe.entities.referentiel.Country#1239832675584#0.0783072255559325'); +INSERT INTO observe_common.shipOwner (topiaid, topiaversion, topiacreatedate, lastupdatedate, status, code, label, country) values ('fr.ird.observe.entities.referentiel.ShipOwner#0#19', 0, CURRENT_DATE, CURRENT_TIMESTAMP, 1, '20','DONWONG', 'fr.ird.observe.entities.referentiel.Country#1239832675585#0.7535948739996284'); +INSERT INTO observe_common.shipOwner (topiaid, topiaversion, topiacreatedate, lastupdatedate, status, code, label, country) values ('fr.ird.observe.entities.referentiel.ShipOwner#0#20', 0, CURRENT_DATE, CURRENT_TIMESTAMP, 1, '21','ENEZ DU', 'fr.ird.observe.entities.referentiel.Country#1239832675583#0.9493110781716075'); +INSERT INTO observe_common.shipOwner (topiaid, topiaversion, topiacreatedate, lastupdatedate, status, code, label, country) values ('fr.ird.observe.entities.referentiel.ShipOwner#0#21', 0, CURRENT_DATE, CURRENT_TIMESTAMP, 1, '22','MINATCHY', 'fr.ird.observe.entities.referentiel.Country#1239832675583#0.9493110781716075'); +INSERT INTO observe_common.shipOwner (topiaid, topiaversion, topiacreatedate, lastupdatedate, status, code, label, country) values ('fr.ird.observe.entities.referentiel.ShipOwner#0#22', 0, CURRENT_DATE, CURRENT_TIMESTAMP, 1, '23','PECHE AVENIR', 'fr.ird.observe.entities.referentiel.Country#1239832675583#0.9493110781716075'); +INSERT INTO observe_common.shipOwner (topiaid, topiaversion, topiacreatedate, lastupdatedate, status, code, label, country) values ('fr.ird.observe.entities.referentiel.ShipOwner#0#23', 0, CURRENT_DATE, CURRENT_TIMESTAMP, 1, '24','INPESCA', 'fr.ird.observe.entities.referentiel.Country#1239832675584#0.0783072255559325'); +INSERT INTO observe_common.shipOwner (topiaid, topiaversion, topiacreatedate, lastupdatedate, status, code, label, country) values ('fr.ird.observe.entities.referentiel.ShipOwner#0#24', 0, CURRENT_DATE, CURRENT_TIMESTAMP, 1, '25','CALVO', 'fr.ird.observe.entities.referentiel.Country#1239832675584#0.0783072255559325'); +INSERT INTO observe_common.shipOwner (topiaid, topiaversion, topiacreatedate, lastupdatedate, status, code, label, country) values ('fr.ird.observe.entities.referentiel.ShipOwner#0#25', 0, CURRENT_DATE, CURRENT_TIMESTAMP, 1, '26','NICRA', 'fr.ird.observe.entities.referentiel.Country#1239832675584#0.0783072255559325'); +INSERT INTO observe_common.shipOwner (topiaid, topiaversion, topiacreatedate, lastupdatedate, status, code, label, needComment) values ('fr.ird.observe.entities.referentiel.ShipOwner#0#26', 0, CURRENT_DATE, CURRENT_TIMESTAMP, 1, '999','UND', true); INSERT INTO observe_common.LASTUPDATEDATE (topiaId, topiaversion, topiacreatedate, TYPE , LASTUPDATEDATE) values ('fr.ird.observe.entities.referentiel.LastUpdateDate#666#1', 0,CURRENT_DATE, 'fr.ird.observe.entities.referentiel.ShipOwner', CURRENT_TIMESTAMP); -- To stop receiving notification emails like this one, please contact codelutin.com SCM administrator <admin+scm@codelutin.com>.