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 cd7299173a9f43dcf79e4ab77006dd1e4d46ee1f Author: Kevin Morin <morin@codelutin.com> Date: Thu Apr 21 14:23:29 2016 +0200 fix migration --- ...0421__remove_user_signings_and_add_signings_for_domains.sql | 6 +++--- ...0421__remove_user_signings_and_add_signings_for_domains.sql | 10 +++++----- 2 files changed, 8 insertions(+), 8 deletions(-) diff --git a/faxtomail-service/src/main/resources/db/migration/h2/V2_1_2_160421__remove_user_signings_and_add_signings_for_domains.sql b/faxtomail-service/src/main/resources/db/migration/h2/V2_1_2_160421__remove_user_signings_and_add_signings_for_domains.sql index db4fb49..94a1350 100644 --- a/faxtomail-service/src/main/resources/db/migration/h2/V2_1_2_160421__remove_user_signings_and_add_signings_for_domains.sql +++ b/faxtomail-service/src/main/resources/db/migration/h2/V2_1_2_160421__remove_user_signings_and_add_signings_for_domains.sql @@ -1,11 +1,11 @@ +alter table faxtomailuser drop constraint FK_CDWL91T1FPNO1PW07532VPN21_INDEX_7; +alter table faxtomailuser drop defaultsigning; + delete from stamp where signing = true; alter table stamp drop signing; alter table stamp drop faxtomailuser; -alter table faxtomailuser drop constraint FK_CDWL91T1FPNO1PW07532VPN21_INDEX_7; -alter table faxtomailuser drop defaultsigning; - create table signingForDomain ( topiaId varchar(255) not null, topiaVersion bigint not null, diff --git a/faxtomail-service/src/main/resources/db/migration/sqlserver/V2_1_2_160421__remove_user_signings_and_add_signings_for_domains.sql b/faxtomail-service/src/main/resources/db/migration/sqlserver/V2_1_2_160421__remove_user_signings_and_add_signings_for_domains.sql index 7b0e09b..7f82c1b 100644 --- a/faxtomail-service/src/main/resources/db/migration/sqlserver/V2_1_2_160421__remove_user_signings_and_add_signings_for_domains.sql +++ b/faxtomail-service/src/main/resources/db/migration/sqlserver/V2_1_2_160421__remove_user_signings_and_add_signings_for_domains.sql @@ -1,3 +1,8 @@ +alter table faxtomailuser drop constraint FK_CDWL91T1FPNO1PW07532VPN21_INDEX_7; +GO +alter table faxtomailuser drop column defaultsigning; +GO + delete from stamp where signing = 1; GO @@ -5,11 +10,6 @@ alter table stamp drop column signing; alter table stamp drop column faxtomailuser; GO -alter table faxtomailuser drop constraint FK_CDWL91T1FPNO1PW07532VPN21_INDEX_7; -GO -alter table faxtomailuser drop column defaultsigning; -GO - create table signingForDomain ( topiaId varchar(255) not null, topiaVersion bigint not null, -- To stop receiving notification emails like this one, please contact codelutin.com SCM administrator <admin+scm@codelutin.com>.