This is an automated email from the git hooks/post-receive script. New commit to branch feature/7424 in repository faxtomail. See http://git.codelutin.com/faxtomail.git commit a7a1c9eb1bdb40a769dfe38a2fc956a8d45c20d5 Author: Kevin Morin <morin@codelutin.com> Date: Tue Aug 11 18:39:25 2015 +0200 ajout de la migration pour sqlserver (refs #7424) --- .../V1_4_0_150811__add_pdf_editor_stamps.sql | 39 ++++++++++++++++++++++ 1 file changed, 39 insertions(+) diff --git a/faxtomail-service/src/main/resources/db/migration/sqlserver/V1_4_0_150811__add_pdf_editor_stamps.sql b/faxtomail-service/src/main/resources/db/migration/sqlserver/V1_4_0_150811__add_pdf_editor_stamps.sql new file mode 100644 index 0000000..0ab48bd --- /dev/null +++ b/faxtomail-service/src/main/resources/db/migration/sqlserver/V1_4_0_150811__add_pdf_editor_stamps.sql @@ -0,0 +1,39 @@ +-- add pdf editor stamps + +create table STAMP ( + topiaId varchar(255) not null, + topiaVersion bigint not null, + topiaCreateDate datetime2, + name varchar(MAX), + description varchar(MAX), + image varbinary(MAX) not null, + text varchar(MAX) not null, + primary key (topiaId) +); + +-- add association between mail folder and stamp + +create table MAILFOLDER_PDFEDITORSTAMPS ( + MAILFOLDER varchar(255) not null, + PDFEDITORSTAMPS varchar(255) not null +); + +alter table MAILFOLDER_PDFEDITORSTAMPS + add constraint FK_47041IYC9CUBBX7OB6E1B32QD + foreign key (MAILFOLDER) + references MAILFOLDER; + +alter table MAILFOLDER_PDFEDITORSTAMPS + add constraint FK_IL3874S78O4MA6YG1EONJ213D + foreign key (PDFEDITORSTAMPS) + references STAMP; + +CREATE INDEX idx_MAILFOLDER_PDFEDITORSTAMPS ON MAILFOLDER_PDFEDITORSTAMPS(MAILFOLDER); + +GO + +-- add useCurrentLevelPdfEditorStamps in mail folder + +alter table mailfolder add useCurrentLevelPdfEditorStamps bit; +GO +update mailfolder set useCurrentLevelPdfEditorStamps = 0; \ No newline at end of file -- To stop receiving notification emails like this one, please contact codelutin.com SCM administrator <admin+scm@codelutin.com>.