branch feature/7424 updated (62c4ef1 -> a7a1c9e)
This is an automated email from the git hooks/post-receive script. New change to branch feature/7424 in repository faxtomail. See http://git.codelutin.com/faxtomail.git from 62c4ef1 modification du modèle (ajout des tampons) (refs #7424) new a7a1c9e ajout de la migration pour sqlserver (refs #7424) The 1 revisions listed above as "new" are entirely new to this repository and will be described in separate emails. The revisions listed as "adds" were already present in the repository and have only been added to this reference. Detailed log of new commits: 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) Summary of changes: .../V1_4_0_150811__add_pdf_editor_stamps.sql | 17 ++++++++++------- 1 file changed, 10 insertions(+), 7 deletions(-) copy faxtomail-service/src/main/resources/db/migration/{h2 => sqlserver}/V1_4_0_150811__add_pdf_editor_stamps.sql (73%) -- To stop receiving notification emails like this one, please contact codelutin.com SCM administrator <admin+scm@codelutin.com>.
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>.
participants (1)
-
codelutin.com scm