branch develop updated (764c5cce -> 32d8befa)
This is an automated email from the git hooks/post-receive script. New change to branch develop in repository faxtomail. See https://gitlab.nuiton.org/codelutin/faxtomail.git from 764c5cce fixes #10751 - améliorer la mise en forme du corps de mail des réponses ou transferts effectués à partir de FTM new 32d8befa Rename migrations to fix bad pattern (need SQL script in production, see wiki on the forge for more info) The 1 revisions listed above as "new" are entirely new to this repository and will be described in separate emails. The revisions listed as "adds" were already present in the repository and have only been added to this reference. Detailed log of new commits: 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) Summary of changes: ...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(-) rename faxtomail-service/src/main/resources/db/migration/h2/{V2_4180607_1__addGeneratedPDFPages.sql => V2_4_180607_1__addGeneratedPDFPages.sql} (100%) rename faxtomail-service/src/main/resources/db/migration/h2/{V2_5200319_1__add_faxFromNumber.sql => V2_5_200319_1__add_faxFromNumber.sql} (100%) delete mode 100644 faxtomail-service/src/main/resources/db/migration/sqlserver/V2_4180607_1__addGeneratedPDFPages.sql create mode 100644 faxtomail-service/src/main/resources/db/migration/sqlserver/V2_4_180607_1__addGeneratedPDFPages.sql delete mode 100644 faxtomail-service/src/main/resources/db/migration/sqlserver/V2_5200319_1__add_faxFromNumber.sql create mode 100644 faxtomail-service/src/main/resources/db/migration/sqlserver/V2_5_200319_1__add_faxFromNumber.sql -- To stop receiving notification emails like this one, please contact codelutin.com SCM administrator <admin+scm@codelutin.com>.
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>.
participants (1)
-
codelutin.com scm