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 8abe98a9ce40d6b4601c2dd1dc866c112b792f78 Author: jcouteau <couteau@codelutin.com> Date: Wed Jun 17 08:53:38 2020 +0200 Fix SQL migration --- .../db/migration/sqlserver/V2_5200319_1__add_faxFromNumber.sql | 6 ++++++ .../migration/sqlserver/V2_5_1_200319_1__add_faxFromNumber.sql | 9 --------- 2 files changed, 6 insertions(+), 9 deletions(-) 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 new file mode 100644 index 00000000..eff2d0e8 --- /dev/null +++ b/faxtomail-service/src/main/resources/db/migration/sqlserver/V2_5200319_1__add_faxFromNumber.sql @@ -0,0 +1,6 @@ +-- add faxFromNumber + +alter table mailfolder add column if not exists faxFromNumber varchar(255); + +alter table mailfolder add column if not exists useCurrentLevelFaxFromNumber boolean; +update mailfolder set useCurrentLevelFaxFromNumber = 'f'; diff --git a/faxtomail-service/src/main/resources/db/migration/sqlserver/V2_5_1_200319_1__add_faxFromNumber.sql b/faxtomail-service/src/main/resources/db/migration/sqlserver/V2_5_1_200319_1__add_faxFromNumber.sql deleted file mode 100644 index 7648accb..00000000 --- a/faxtomail-service/src/main/resources/db/migration/sqlserver/V2_5_1_200319_1__add_faxFromNumber.sql +++ /dev/null @@ -1,9 +0,0 @@ --- add faxFromNumber - -alter table mailfolder add faxFromNumber varchar(MAX); -GO - -alter table mailfolder add useCurrentLevelFaxFromNumber bit; -GO -update mailfolder set useCurrentLevelFaxFromNumber = 0 where parent is null; -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>.