This is an automated email from the git hooks/post-receive script. New commit to branch feature/#8171 in repository echobase. See https://gitlab.nuiton.org/codelutin/echobase.git commit 5f7e91b6a79f5c960a7119b950dbc31b16c7ea21 Author: Julien Ruchaud <julien.ruchaud@debux.org> Date: Fri Apr 29 17:02:52 2016 +0200 Set a value for the real column --- .../resources/migration/workingDb/h2/3.902-0-update-model.sql | 8 ++++++++ .../resources/migration/workingDb/pg/3.902-0-update-model.sql | 8 ++++++++ 2 files changed, 16 insertions(+) diff --git a/echobase-domain/src/main/resources/migration/workingDb/h2/3.902-0-update-model.sql b/echobase-domain/src/main/resources/migration/workingDb/h2/3.902-0-update-model.sql index 57f8654..6ffe315 100644 --- a/echobase-domain/src/main/resources/migration/workingDb/h2/3.902-0-update-model.sql +++ b/echobase-domain/src/main/resources/migration/workingDb/h2/3.902-0-update-model.sql @@ -16,6 +16,8 @@ alter table voyage add column units varchar(255); alter table voyage add column zUnits varchar(255); alter table voyage add column comments varchar(255); +update voyage set northLimit = 0, eastLimit = 0, southLimit = 0, westLimit = 0, upLimit = 0, downLimit = 0; + -- Change ports name alter table voyage alter column startPort rename to startPortName; alter table voyage alter column endPort rename to endPortName; @@ -46,6 +48,8 @@ alter table ancillaryinstrumentation_transect add constraint FK_ANCILLARYINSTTRA alter table vessel add column breadth real; alter table vessel add column comments varchar(255); +update vessel set breadth = 0; + -- MOORING create table mooring (topiaId varchar(255) not null, topiaVersion bigint not null, code varchar(255) not null, topiaCreateDate timestamp, description varchar(255) not null, depth real, northLimit real, eastLimit real, southLimit real, westLimit real, upLimit real, downLimit real, units varchar(255), zUnits varchar(255), projection varchar(255), deploymentDate timestamp, retrievalDate timestamp, siteName varchar(255), operator varchar(255), comments varchar(255), mission varchar(255) not null); @@ -73,6 +77,8 @@ alter table acousticInstrument add column transducerBeamAngleMinor real; alter table acousticInstrument add column transducerBeamManufactuer varchar(255); alter table acousticInstrument add column comments varchar(255); +update acousticInstrument set transducerFrequency = 0, transducerPsi = 0, transducerBeamAngleMajor = 0, transducerBeamAngleMinor = 0; + -- DATA PROCESSING alter table dataProcessing add column softwareName varchar(255); alter table dataProcessing add column channelId varchar(255); @@ -83,5 +89,7 @@ alter table dataProcessing add column transmitPulseLength real; alter table dataProcessing add column transceiverGainUnits varchar(255); alter table dataProcessing add column comments varchar(255); +update dataProcessing set bandWith = 0, frequency = 0, transceiverPower = 0, transmitPulseLength = 0; + -- CALIBRATION alter table calibration add column comments varchar(255); diff --git a/echobase-domain/src/main/resources/migration/workingDb/pg/3.902-0-update-model.sql b/echobase-domain/src/main/resources/migration/workingDb/pg/3.902-0-update-model.sql index b4f86a3..4bd5e3f 100644 --- a/echobase-domain/src/main/resources/migration/workingDb/pg/3.902-0-update-model.sql +++ b/echobase-domain/src/main/resources/migration/workingDb/pg/3.902-0-update-model.sql @@ -16,6 +16,8 @@ alter table voyage add column units character varying(255); alter table voyage add column zUnits character varying(255); alter table voyage add column comments character varying(255); +update voyage set northLimit = 0, eastLimit = 0, southLimit = 0, westLimit = 0, upLimit = 0, downLimit = 0; + -- Change ports name alter table voyage alter column startPort rename to startPortName; alter table voyage alter column endPort rename to endPortName; @@ -46,6 +48,8 @@ alter table ancillaryinstrumentation_transect add constraint FK_ANCILLARYINSTTRA alter table vessel add column breadth real; alter table vessel add column comments character varying(255); +update vessel set breadth = 0; + -- MOORING create table mooring (topiaId character varying(255) not null, topiaVersion bigint not null, code character varying(255) not null, topiaCreateDate timestamp, description character varying(255) not null, depth real, northLimit real, eastLimit real, southLimit real, westLimit real, upLimit real, downLimit real, units character varying(255), zUnits character varying(255), projection character varying(255), deploymentDate timestamp, retrievalDate timestamp, siteName character varying(255), o [...] @@ -73,6 +77,8 @@ alter table acousticInstrument add column transducerBeamAngleMinor real; alter table acousticInstrument add column transducerBeamManufactuer character varying(255); alter table acousticInstrument add column comments character varying(255); +update acousticInstrument set transducerFrequency = 0, transducerPsi = 0, transducerBeamAngleMajor = 0, transducerBeamAngleMinor = 0; + -- DATA PROCESSING alter table dataProcessing add column softwareName character varying(255); alter table dataProcessing add column channelId character varying(255); @@ -83,5 +89,7 @@ alter table dataProcessing add column transmitPulseLength real; alter table dataProcessing add column transceiverGainUnits character varying(255); alter table dataProcessing add column comments character varying(255); +update dataProcessing set bandWith = 0, frequency = 0, transceiverPower = 0, transmitPulseLength = 0; + -- CALIBRATION alter table calibration add column comments character varying(255); -- To stop receiving notification emails like this one, please contact codelutin.com SCM administrator <admin+scm@codelutin.com>.