[Observe-commits] 01/06: Ajout du référentiel ShipOwner (persistence)

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 faa1bc31c62c3d1c053242d82218f28cece8657d Author: Tony CHEMIT <chemit@codelutin.com> Date: Wed Nov 2 19:33:13 2016 +0100 Ajout du référentiel ShipOwner (persistence) --- .../DataSourceMigrationForVersion_5_1.java | 1 + .../V5_1_13_evol_7901_add_armateur_table-H2.sql | 37 +++++++++++++++++++++ .../V5_1_13_evol_7901_add_armateur_table-PG.sql | 37 +++++++++++++++++++++ entities/src/main/xmi/observe-common.zargo | Bin 38794 -> 42038 bytes 4 files changed, 75 insertions(+) diff --git a/entities-migration/src/main/java/fr/ird/observe/entities/migration/versions/DataSourceMigrationForVersion_5_1.java b/entities-migration/src/main/java/fr/ird/observe/entities/migration/versions/DataSourceMigrationForVersion_5_1.java index 910bd53..d09ed01 100644 --- a/entities-migration/src/main/java/fr/ird/observe/entities/migration/versions/DataSourceMigrationForVersion_5_1.java +++ b/entities-migration/src/main/java/fr/ird/observe/entities/migration/versions/DataSourceMigrationForVersion_5_1.java @@ -56,6 +56,7 @@ public class DataSourceMigrationForVersion_5_1 extends AbstractObserveMigrationC evol8391(topiaSqlSupport, queries); addScript("11", "evol_8571_length_add_tagNumber", queries); addScript("12", "evol_8475_vessel_add_fields", queries); + addScript("13", "evol_7901_add_armateur_table", queries); } private void evol8391(TopiaSqlSupport topiaSqlSupport, List<String> queries) { diff --git a/entities-migration/src/main/resources/db/migration/V5_1_13_evol_7901_add_armateur_table-H2.sql b/entities-migration/src/main/resources/db/migration/V5_1_13_evol_7901_add_armateur_table-H2.sql new file mode 100644 index 0000000..42f8516 --- /dev/null +++ b/entities-migration/src/main/resources/db/migration/V5_1_13_evol_7901_add_armateur_table-H2.sql @@ -0,0 +1,37 @@ +CREATE TABLE observe_common.shipOwner( topiaid VARCHAR(255) NOT NULL,topiaversion BIGINT NOT NULL, topiacreatedate DATE, lastupdatedate TIMESTAMP NOT NULL, code VARCHAR(255), status INTEGER DEFAULT 1, needComment BOOLEAN, uri VARCHAR(255), label VARCHAR(255), country VARCHAR(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); + +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.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); + +ALTER TABLE observe_common.vessel ADD COLUMN shipOwner VARCHAR(255); +ALTER TABLE observe_common.vessel ADD CONSTRAINT FK_VESSEL_SHIP_OWNER FOREIGN KEY(shipOwner) REFERENCES observe_common.shipOwner(topiaid); diff --git a/entities-migration/src/main/resources/db/migration/V5_1_13_evol_7901_add_armateur_table-PG.sql b/entities-migration/src/main/resources/db/migration/V5_1_13_evol_7901_add_armateur_table-PG.sql new file mode 100644 index 0000000..cdded22 --- /dev/null +++ b/entities-migration/src/main/resources/db/migration/V5_1_13_evol_7901_add_armateur_table-PG.sql @@ -0,0 +1,37 @@ +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); +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); + +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.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); + +ALTER TABLE observe_common.vessel ADD COLUMN shipOwner character varying(255); +ALTER TABLE observe_common.vessel ADD CONSTRAINT FK_VESSEL_SHIP_OWNER FOREIGN KEY(shipOwner) REFERENCES observe_common.shipOwner(topiaid); diff --git a/entities/src/main/xmi/observe-common.zargo b/entities/src/main/xmi/observe-common.zargo index 545ea18..2f41eb2 100644 Binary files a/entities/src/main/xmi/observe-common.zargo and b/entities/src/main/xmi/observe-common.zargo differ -- To stop receiving notification emails like this one, please contact codelutin.com SCM administrator <admin+scm@codelutin.com>.