[Echobase-commits] 09/24: Rename constraint name Rename id to code Put all request on one line

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 636a72eaa258cc5d48c03b38664109583c0f1c3c Author: Julien Ruchaud <julien.ruchaud@debux.org> Date: Fri Apr 29 11:47:00 2016 +0200 Rename constraint name Rename id to code Put all request on one line --- .../workingDb/3.910-1-add-new-attributes.sql | 77 ++++++---------------- 1 file changed, 20 insertions(+), 57 deletions(-) diff --git a/echobase-domain/src/main/resources/migration/workingDb/3.910-1-add-new-attributes.sql b/echobase-domain/src/main/resources/migration/workingDb/3.910-1-add-new-attributes.sql index bbe1aae..5c896e4 100644 --- a/echobase-domain/src/main/resources/migration/workingDb/3.910-1-add-new-attributes.sql +++ b/echobase-domain/src/main/resources/migration/workingDb/3.910-1-add-new-attributes.sql @@ -1,5 +1,5 @@ -- VOYAGE -alter table voyage add column id varchar(255); +alter table voyage add column code varchar(255); alter table voyage add column northLimit double; alter table voyage add column eastLimit double; alter table voyage add column southLimit double; @@ -17,8 +17,8 @@ alter table voyage alter column endPort rename to endPortName; alter table voyage add column startPort varchar(255); alter table voyage add column endPort varchar(255); -alter table voyage add constraint FK_8nthgerjt9a0cpjch4p1wpyk3 foreign key (startPort) references port; -alter table voyage add constraint FK_7ob93mebw1vypuis77py37imy foreign key (endPort) references port; +alter table voyage add constraint FK_VOYAGE_STARTPORT foreign key (startPort) references port; +alter table voyage add constraint FK_VOYAGE_ENDPORT foreign key (endPort) references port; -- /!\ /!\ /!\ /!\ /!\ /!\ Need to import port data /!\ /!\ /!\ /!\ /!\ /!\ update voyage v SET (startPort) = (select p.topiaId from port p where upper(p.name) = upper(v.startPortName)); @@ -28,18 +28,10 @@ alter table voyage drop column startPortName; alter table voyage drop column endPortName; -- PORT -create table port ( - topiaId varchar(255) not null, - topiaVersion bigint not null, - id varchar(255) not null, - topiaCreateDate date, - name varchar(255) not null, - shortName varchar(255), - lastModification date, - primary key (topiaId) -); - -alter table port add constraint UK_dvgc32pm231nt5p6hnjjpbo9s unique (id); +create table port (topiaId varchar(255) not null, topiaVersion bigint not null, code varchar(255) not null, topiaCreateDate date, name varchar(255) not null, shortName varchar(255), lastModification date, primary key (topiaId)); + +alter table port add constraint PK_PORT primary key (topiaId); +alter table port add constraint UK_PORT_CODE unique (code); -- TRANSECT alter table transect alter column comment rename to comments; @@ -48,8 +40,8 @@ alter table transect add column units varchar(255); alter table transect add column zUnits varchar(255); create table ancillaryinstrumentation_transect (transect varchar(255) not null, ancillaryInstrumentation varchar(255) not null); -alter table ancillaryinstrumentation_transect add constraint FK_in7bfe4lrs9g9leur9e571efw foreign key (ancillaryInstrumentation) references ancillaryInstrumentation; -alter table ancillaryinstrumentation_transect add constraint FK_18is89y0wl1dw9yve9ou7hyoc foreign key (transect) references transect; +alter table ancillaryinstrumentation_transect add constraint FK_ANCILLARYINSTTRANSECT_ANCILLARYINST foreign key (ancillaryInstrumentation) references ancillaryInstrumentation; +alter table ancillaryinstrumentation_transect add constraint FK_ANCILLARYINSTTRANSECT_TRANSECT foreign key (transect) references transect; -- VESSEL alter table vessel add column breadth double; @@ -61,7 +53,7 @@ alter table dataAcquisition add column storedDataFormat varchar(255); alter table dataAcquisition add column comments varchar(255); alter table dataAcquisition add column mooring varchar(255); -alter table dataAcquisition add constraint FK_c7xf355ysbxdkx2gce119wpug foreign key (mooring) references mooring; +alter table dataAcquisition add constraint FK_DATAACQUISITION_MOORING foreign key (mooring) references mooring; -- ACOUSTIC INSTRUMENT alter table acousticInstrument add column transducerFrequency double; @@ -85,47 +77,18 @@ alter table dataProcessing add column comments varchar(255); alter table calibration add column comments varchar(255); -- ANCILLARY INSTRUMENTATION -create table ancillaryInstrumentation ( - topiaId varchar(255) not null, - topiaVersion bigint not null, - serialNumber varchar(255) not null, - topiaCreateDate date, - name varchar(255) not null, - primary key (topiaId) -); +create table ancillaryInstrumentation (topiaId varchar(255) not null, topiaVersion bigint not null, serialNumber varchar(255) not null, topiaCreateDate date, name varchar(255) not null, primary key (topiaId)); -alter table ancillaryInstrumentation add constraint UK_9740vy6d0qkxwp9f68fckt6hh unique (serialNumber); +alter table ancillaryInstrumentation add constraint PK_ANCILLARYINST primary key (topiaId); +alter table ancillaryInstrumentation add constraint UK_ANCILLARYINST_SERIALNUMBER unique (serialNumber); -- MOORING -create table mooring ( - topiaId varchar(255) not null, - topiaVersion bigint not null, - code varchar(255) not null, - topiaCreateDate date, - description varchar(255) not null, - depth double, - northLimit double, - eastLimit double, - southLimit double, - westLimit double, - upLimit double, - downLimit double, - units varchar(255), - zUnits varchar(255), - projection varchar(255), - deploymentDate date, - retrievalDate date, - siteName varchar(255), - operator varchar(255), - comments varchar(255), - mission varchar(255) not null, - primary key (topiaId) -); - -alter table mooring add constraint FK_2wg40f1ueb7vqi573i78fjc8v foreign key (mission) references mission; +create table mooring (topiaId varchar(255) not null, topiaVersion bigint not null, code varchar(255) not null, topiaCreateDate date, description varchar(255) not null, depth double, northLimit double, eastLimit double, southLimit double, westLimit double, upLimit double, downLimit double, units varchar(255), zUnits varchar(255), projection varchar(255), deploymentDate date, retrievalDate date, siteName varchar(255), operator varchar(255), comments varchar(255), mission varchar(255) not n [...] -create table ancillaryinstrumentation_mooring (mooring varchar(255) not null, ancillaryInstrumentation varchar(255) not null); -alter table ancillaryinstrumentation_mooring add constraint FK_qjtr5y6ape0bessp8qabd9tv0 foreign key (ancillaryInstrumentation) references ancillaryInstrumentation; -alter table ancillaryinstrumentation_mooring add constraint FK_si61fa8ai4fm7tm9tlbga9dtb foreign key (mooring) references mooring; +alter table mooring add constraint PK_MOORING primary key (topiaId); +alter table mooring add constraint UK_MOORING_CODE unique (code); +alter table mooring add constraint FK_MOORING_MISSION foreign key (mission) references mission; -alter table mooring add constraint UK_3ibgwx773wxpe9i5as9w5elqn unique (code); +create table ancillaryinstrumentation_mooring (mooring varchar(255) not null, ancillaryInstrumentation varchar(255) not null); +alter table ancillaryinstrumentation_mooring add constraint FK_ANCILLARYINSTMOORING_ANCILLARYINST foreign key (ancillaryInstrumentation) references ancillaryInstrumentation; +alter table ancillaryinstrumentation_mooring add constraint FK_ANCILLARYINSTMOORING_MOORING foreign key (mooring) references mooring; -- To stop receiving notification emails like this one, please contact codelutin.com SCM administrator <admin+scm@codelutin.com>.