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 2b9cf5a41ef6f2041a5a7d8e49b566ed0b1af622 Author: jcouteau <couteau@codelutin.com> Date: Wed Jun 17 08:54:07 2020 +0200 Fix SQL migration on SQL Server --- .../db/migration/sqlserver/V2_5200319_1__add_faxFromNumber.sql | 10 +++++++--- 1 file changed, 7 insertions(+), 3 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 index eff2d0e8..93acd649 100644 --- 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 @@ -1,6 +1,10 @@ -- add faxFromNumber -alter table mailfolder add column if not exists faxFromNumber varchar(255); +alter table mailfolder add faxFromNumber varchar(255); +GO -alter table mailfolder add column if not exists useCurrentLevelFaxFromNumber boolean; -update mailfolder set useCurrentLevelFaxFromNumber = 'f'; +alter table mailfolder add useCurrentLevelFaxFromNumber bit; +GO + +update mailfolder set useCurrentLevelFaxFromNumber = 0; +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>.