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 fa12f5018d917e61bebab9e62bae98bddd293e67 Author: Kevin Morin <morin@codelutin.com> Date: Tue Mar 14 10:44:43 2017 +0100 refs #9097 ajout de la migration sqlserver --- .../V2_2_3_170313_1__add_last_printing_user.sql | 19 +++++++++++++++++++ 1 file changed, 19 insertions(+) diff --git a/faxtomail-service/src/main/resources/db/migration/sqlserver/V2_2_3_170313_1__add_last_printing_user.sql b/faxtomail-service/src/main/resources/db/migration/sqlserver/V2_2_3_170313_1__add_last_printing_user.sql new file mode 100644 index 0000000..b268e72 --- /dev/null +++ b/faxtomail-service/src/main/resources/db/migration/sqlserver/V2_2_3_170313_1__add_last_printing_user.sql @@ -0,0 +1,19 @@ +-- add last printing user + +alter table email add lastPrintingUser varchar(255); + +alter table email + add constraint FK_I8WXUJ77ETK21ME0JC939HBEO_INDEX_3 + foreign key (lastPrintingUser) + references faxtomailuser; +GO + +update email set email.lastPrintingUser = (select h.faxtomailuser + from history h + where h.email = email.topiaId + and h.type = 'PRINTING' + and h.email not in ( + select h2.email from history h2 + where (h2.type='TRANSMISSION' OR h2.type='PRINTING') and h2.modificationDate > h.modificationDate + ) +) where archiveDate is null; \ No newline at end of file -- To stop receiving notification emails like this one, please contact codelutin.com SCM administrator <admin+scm@codelutin.com>.