This is an automated email from the git hooks/post-receive script. New commit to branch develop in repository faxtomail. See https://gitlab.nuiton.org/codelutin/faxtomail.git commit 32d8befabc925b8cfebfb5ed5928e10f0b37e6ad Author: jcouteau <couteau@codelutin.com> Date: Tue Jun 23 15:59:01 2020 +0200 Rename migrations to fix bad pattern (need SQL script in production, see wiki on the forge for more info) --- ...ges.sql => V2_4_180607_1__addGeneratedPDFPages.sql} | 0 ...Number.sql => V2_5_200319_1__add_faxFromNumber.sql} | 0 .../sqlserver/V2_4180607_1__addGeneratedPDFPages.sql | 18 ------------------ .../sqlserver/V2_4_180607_1__addGeneratedPDFPages.sql | 18 ++++++++++++++++++ .../sqlserver/V2_5200319_1__add_faxFromNumber.sql | 10 ---------- .../sqlserver/V2_5_200319_1__add_faxFromNumber.sql | 10 ++++++++++ 6 files changed, 28 insertions(+), 28 deletions(-) diff --git a/faxtomail-service/src/main/resources/db/migration/h2/V2_4180607_1__addGeneratedPDFPages.sql b/faxtomail-service/src/main/resources/db/migration/h2/V2_4_180607_1__addGeneratedPDFPages.sql similarity index 100% rename from faxtomail-service/src/main/resources/db/migration/h2/V2_4180607_1__addGeneratedPDFPages.sql rename to faxtomail-service/src/main/resources/db/migration/h2/V2_4_180607_1__addGeneratedPDFPages.sql diff --git a/faxtomail-service/src/main/resources/db/migration/h2/V2_5200319_1__add_faxFromNumber.sql b/faxtomail-service/src/main/resources/db/migration/h2/V2_5_200319_1__add_faxFromNumber.sql similarity index 100% rename from faxtomail-service/src/main/resources/db/migration/h2/V2_5200319_1__add_faxFromNumber.sql rename to faxtomail-service/src/main/resources/db/migration/h2/V2_5_200319_1__add_faxFromNumber.sql diff --git a/faxtomail-service/src/main/resources/db/migration/sqlserver/V2_4180607_1__addGeneratedPDFPages.sql b/faxtomail-service/src/main/resources/db/migration/sqlserver/V2_4180607_1__addGeneratedPDFPages.sql deleted file mode 100644 index 6978622f..00000000 --- a/faxtomail-service/src/main/resources/db/migration/sqlserver/V2_4180607_1__addGeneratedPDFPages.sql +++ /dev/null @@ -1,18 +0,0 @@ --- add generatedPDFPages - -create table GENERATEDPDFPAGE ( - page VARBINARY(MAX) not null, - topiaId VARCHAR(255) NOT NULL, - topiaVersion BIGINT NOT NULL, - topiaCreateDate datetime2, - attachment VARCHAR(255), - PRIMARY KEY (topiaId) -); - -GO - -ALTER TABLE GENERATEDPDFPAGE - ADD CONSTRAINT FK_9CRCVUPPG70VCFW7334VAH7PJ - FOREIGN KEY(ATTACHMENT) - REFERENCES ATTACHMENT -GO \ No newline at end of file diff --git a/faxtomail-service/src/main/resources/db/migration/sqlserver/V2_4_180607_1__addGeneratedPDFPages.sql b/faxtomail-service/src/main/resources/db/migration/sqlserver/V2_4_180607_1__addGeneratedPDFPages.sql new file mode 100644 index 00000000..0058bebc --- /dev/null +++ b/faxtomail-service/src/main/resources/db/migration/sqlserver/V2_4_180607_1__addGeneratedPDFPages.sql @@ -0,0 +1,18 @@ +-- add generatedPDFPages +IF (NOT EXISTS (SELECT * + FROM INFORMATION_SCHEMA.TABLES + WHERE TABLE_NAME = 'generatedPDFPage') ) +BEGIN + create table generatedPDFPage ( + page VARBINARY(MAX) not null, + topiaId VARCHAR(255) NOT NULL, + topiaVersion BIGINT NOT NULL, + topiaCreateDate datetime2, + attachment VARCHAR(255), + PRIMARY KEY (topiaId)) + ALTER TABLE GENERATEDPDFPAGE + ADD CONSTRAINT FK_9CRCVUPPG70VCFW7334VAH7PJ + FOREIGN KEY(ATTACHMENT) + REFERENCES ATTACHMENT +END +GO \ No newline at end of file diff --git a/faxtomail-service/src/main/resources/db/migration/sqlserver/V2_5200319_1__add_faxFromNumber.sql b/faxtomail-service/src/main/resources/db/migration/sqlserver/V2_5200319_1__add_faxFromNumber.sql deleted file mode 100644 index 93acd649..00000000 --- a/faxtomail-service/src/main/resources/db/migration/sqlserver/V2_5200319_1__add_faxFromNumber.sql +++ /dev/null @@ -1,10 +0,0 @@ --- add faxFromNumber - -alter table mailfolder add faxFromNumber varchar(255); -GO - -alter table mailfolder add useCurrentLevelFaxFromNumber bit; -GO - -update mailfolder set useCurrentLevelFaxFromNumber = 0; -GO \ No newline at end of file diff --git a/faxtomail-service/src/main/resources/db/migration/sqlserver/V2_5_200319_1__add_faxFromNumber.sql b/faxtomail-service/src/main/resources/db/migration/sqlserver/V2_5_200319_1__add_faxFromNumber.sql new file mode 100644 index 00000000..2f282662 --- /dev/null +++ b/faxtomail-service/src/main/resources/db/migration/sqlserver/V2_5_200319_1__add_faxFromNumber.sql @@ -0,0 +1,10 @@ +-- add faxFromNumber +IF (NOT EXISTS (SELECT * + FROM INFORMATION_SCHEMA.COLUMNS + WHERE COLUMN_NAME = 'faxFromNumber') ) +BEGIN + alter table mailfolder add faxFromNumber varchar(255) + alter table mailfolder add useCurrentLevelFaxFromNumber bit + update mailfolder set useCurrentLevelFaxFromNumber = 0 +END +GO \ No newline at end of file -- To stop receiving notification emails like this one, please contact codelutin.com SCM administrator <admin+scm@codelutin.com>.