Bugzilla – Attachment 33186 Details for
Bug 12648
Link patrons to an order
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 12648: Link patrons to an order - DB changes
Bug-12648-Link-patrons-to-an-order---DB-changes.patch (text/plain), 8.62 KB, created by
Jonathan Druart
on 2014-11-04 10:38:51 UTC
(
hide
)
Description:
Bug 12648: Link patrons to an order - DB changes
Filename:
MIME Type:
Creator:
Jonathan Druart
Created:
2014-11-04 10:38:51 UTC
Size:
8.62 KB
patch
obsolete
>From fb9796927535f9c5e6a87820c456d290ac712714 Mon Sep 17 00:00:00 2001 >From: Jonathan Druart <jonathan.druart@biblibre.com> >Date: Thu, 24 Jul 2014 13:26:29 +0200 >Subject: [PATCH] Bug 12648: Link patrons to an order - DB changes > >This patch inserts the new notification template into the letters table. >It also add the insert statements into the language specific files. >--- > .../data/mysql/de-DE/mandatory/sample_notices.sql | 3 +++ > .../data/mysql/en/mandatory/sample_notices.sql | 3 +++ > .../data/mysql/es-ES/mandatory/sample_notices.sql | 4 ++++ > .../mysql/fr-FR/1-Obligatoire/sample_notices.sql | 3 +++ > installer/data/mysql/it-IT/necessari/notices.sql | 3 +++ > .../mysql/nb-NO/1-Obligatorisk/sample_notices.sql | 3 +++ > .../data/mysql/pl-PL/mandatory/sample_notices.sql | 3 +++ > .../data/mysql/ru-RU/mandatory/sample_notices.sql | 3 +++ > .../data/mysql/uk-UA/mandatory/sample_notices.sql | 3 +++ > installer/data/mysql/updatedatabase.pl | 27 ++++++++++++++++++++++ > 10 files changed, 55 insertions(+) > >diff --git a/installer/data/mysql/de-DE/mandatory/sample_notices.sql b/installer/data/mysql/de-DE/mandatory/sample_notices.sql >index 01ae5d4..5afc419 100644 >--- a/installer/data/mysql/de-DE/mandatory/sample_notices.sql >+++ b/installer/data/mysql/de-DE/mandatory/sample_notices.sql >@@ -131,3 +131,6 @@ Wir möchten Sie darüber informieren, dass der Benutzer <<borrowers.firstname>> > Vielen Dank, > Ihr Biblioheksteam' > ); >+ >+INSERT INTO letter(module, code, branchcode, name, title, content, message_transport_type) >+VALUES ('acquisition', 'ACQ_NOTIF_ON_RECEIV', '', 'Notification on receiving', 'Order received', 'Dear <<borrowers.firstname>> <<borrowers.surname>>,\n\n The order <<aqorders.ordernumber>> (<<biblio.title>>) has been received.\n\nYour library.', 'email') >diff --git a/installer/data/mysql/en/mandatory/sample_notices.sql b/installer/data/mysql/en/mandatory/sample_notices.sql >index 2281739..378be05 100644 >--- a/installer/data/mysql/en/mandatory/sample_notices.sql >+++ b/installer/data/mysql/en/mandatory/sample_notices.sql >@@ -142,3 +142,6 @@ Thank you. > > Your library.' > ); >+ >+INSERT INTO letter(module, code, branchcode, name, title, content, message_transport_type) >+VALUES ('acquisition', 'ACQ_NOTIF_ON_RECEIV', '', 'Notification on receiving', 'Order received', 'Dear <<borrowers.firstname>> <<borrowers.surname>>,\n\n The order <<aqorders.ordernumber>> (<<biblio.title>>) has been received.\n\nYour library.', 'email') >diff --git a/installer/data/mysql/es-ES/mandatory/sample_notices.sql b/installer/data/mysql/es-ES/mandatory/sample_notices.sql >index 25f12a3..1af56bf 100644 >--- a/installer/data/mysql/es-ES/mandatory/sample_notices.sql >+++ b/installer/data/mysql/es-ES/mandatory/sample_notices.sql >@@ -42,3 +42,7 @@ Thank you. > > Your library.' > ); >+ >+ >+INSERT INTO letter(module, code, branchcode, name, title, content, message_transport_type) >+VALUES ('acquisition', 'ACQ_NOTIF_ON_RECEIV', '', 'Notification on receiving', 'Order received', 'Dear <<borrowers.firstname>> <<borrowers.surname>>,\n\n The order <<aqorders.ordernumber>> (<<biblio.title>>) has been received.\n\nYour library.', 'email') >diff --git a/installer/data/mysql/fr-FR/1-Obligatoire/sample_notices.sql b/installer/data/mysql/fr-FR/1-Obligatoire/sample_notices.sql >index 625dfd2..b438667 100644 >--- a/installer/data/mysql/fr-FR/1-Obligatoire/sample_notices.sql >+++ b/installer/data/mysql/fr-FR/1-Obligatoire/sample_notices.sql >@@ -44,3 +44,6 @@ Thank you. > > Your library.' > ); >+ >+INSERT INTO letter(module, code, branchcode, name, title, content, message_transport_type) >+VALUES ('acquisition', 'ACQ_NOTIF_ON_RECEIV', '', 'Notification on receiving', 'Order received', 'Dear <<borrowers.firstname>> <<borrowers.surname>>,\n\n The order <<aqorders.ordernumber>> (<<biblio.title>>) has been received.\n\nYour library.', 'email') >diff --git a/installer/data/mysql/it-IT/necessari/notices.sql b/installer/data/mysql/it-IT/necessari/notices.sql >index 0b34e89..80f6a93 100644 >--- a/installer/data/mysql/it-IT/necessari/notices.sql >+++ b/installer/data/mysql/it-IT/necessari/notices.sql >@@ -130,3 +130,6 @@ Grazie di tutto > > Lo staff della biblioteca.' > ); >+ >+INSERT INTO letter(module, code, branchcode, name, title, content, message_transport_type) >+VALUES ('acquisition', 'ACQ_NOTIF_ON_RECEIV', '', 'Notification on receiving', 'Order received', 'Dear <<borrowers.firstname>> <<borrowers.surname>>,\n\n The order <<aqorders.ordernumber>> (<<biblio.title>>) has been received.\n\nYour library.', 'email') >diff --git a/installer/data/mysql/nb-NO/1-Obligatorisk/sample_notices.sql b/installer/data/mysql/nb-NO/1-Obligatorisk/sample_notices.sql >index f1e8fb0..cb40756 100644 >--- a/installer/data/mysql/nb-NO/1-Obligatorisk/sample_notices.sql >+++ b/installer/data/mysql/nb-NO/1-Obligatorisk/sample_notices.sql >@@ -163,3 +163,6 @@ Thank you. > > Your library.' > ); >+ >+INSERT INTO letter(module, code, branchcode, name, title, content, message_transport_type) >+VALUES ('acquisition', 'ACQ_NOTIF_ON_RECEIV', '', 'Notification on receiving', 'Order received', 'Dear <<borrowers.firstname>> <<borrowers.surname>>,\n\n The order <<aqorders.ordernumber>> (<<biblio.title>>) has been received.\n\nYour library.', 'email') >diff --git a/installer/data/mysql/pl-PL/mandatory/sample_notices.sql b/installer/data/mysql/pl-PL/mandatory/sample_notices.sql >index d053e3d..c37917b 100644 >--- a/installer/data/mysql/pl-PL/mandatory/sample_notices.sql >+++ b/installer/data/mysql/pl-PL/mandatory/sample_notices.sql >@@ -44,3 +44,6 @@ Thank you. > > Your library.' > ); >+ >+INSERT INTO letter(module, code, branchcode, name, title, content, message_transport_type) >+VALUES ('acquisition', 'ACQ_NOTIF_ON_RECEIV', '', 'Notification on receiving', 'Order received', 'Dear <<borrowers.firstname>> <<borrowers.surname>>,\n\n The order <<aqorders.ordernumber>> (<<biblio.title>>) has been received.\n\nYour library.', 'email') >diff --git a/installer/data/mysql/ru-RU/mandatory/sample_notices.sql b/installer/data/mysql/ru-RU/mandatory/sample_notices.sql >index 4b9328e..f1b933b 100644 >--- a/installer/data/mysql/ru-RU/mandatory/sample_notices.sql >+++ b/installer/data/mysql/ru-RU/mandatory/sample_notices.sql >@@ -42,3 +42,6 @@ Thank you. > > Your library.' > ); >+ >+INSERT INTO letter(module, code, branchcode, name, title, content, message_transport_type) >+VALUES ('acquisition', 'ACQ_NOTIF_ON_RECEIV', '', 'Notification on receiving', 'Order received', 'Dear <<borrowers.firstname>> <<borrowers.surname>>,\n\n The order <<aqorders.ordernumber>> (<<biblio.title>>) has been received.\n\nYour library.', 'email') >diff --git a/installer/data/mysql/uk-UA/mandatory/sample_notices.sql b/installer/data/mysql/uk-UA/mandatory/sample_notices.sql >index 4d3ed4f..a779977 100644 >--- a/installer/data/mysql/uk-UA/mandatory/sample_notices.sql >+++ b/installer/data/mysql/uk-UA/mandatory/sample_notices.sql >@@ -41,3 +41,6 @@ Thank you. > > Your library.' > ); >+ >+INSERT INTO letter(module, code, branchcode, name, title, content, message_transport_type) >+VALUES ('acquisition', 'ACQ_NOTIF_ON_RECEIV', '', 'Notification on receiving', 'Order received', 'Dear <<borrowers.firstname>> <<borrowers.surname>>,\n\n The order <<aqorders.ordernumber>> (<<biblio.title>>) has been received.\n\nYour library.', 'email') >diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl >index 078a9f3..ed63aa8 100755 >--- a/installer/data/mysql/updatedatabase.pl >+++ b/installer/data/mysql/updatedatabase.pl >@@ -8974,6 +8974,33 @@ if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) { > SetVersion($DBversion); > } > >+ >+ >+ >+ >+ >+ >+$DBversion = "3.17.00.XXX"; >+if ( CheckVersion($DBversion) ) { >+ $dbh->do(q| >+ CREATE TABLE aqorderusers ( >+ ordernumber int(11) NOT NULL, >+ borrowernumber int(11) NOT NULL, >+ PRIMARY KEY (ordernumber, borrowernumber), >+ CONSTRAINT aqorderusers_ibfk_1 FOREIGN KEY (ordernumber) REFERENCES aqorders (ordernumber) ON DELETE CASCADE ON UPDATE CASCADE, >+ CONSTRAINT aqorderusers_ibfk_2 FOREIGN KEY (borrowernumber) REFERENCES borrowers (borrowernumber) ON DELETE CASCADE ON UPDATE CASCADE >+ ) ENGINE=InnoDB DEFAULT CHARSET=utf8; >+ |); >+ >+ $dbh->do(q| >+ INSERT INTO letter(module, code, branchcode, name, title, content, message_transport_type) >+ VALUES ('acquisition', 'ACQ_NOTIF_ON_RECEIV', '', 'Notification on receiving', 'Order received', 'Dear <<borrowers.firstname>> <<borrowers.surname>>,\n\n The order <<aqorders.ordernumber>> (<<biblio.title>>) has been received.\n\nYour library.', 'email') >+ |); >+ print "Upgrade to $DBversion done ( Bug 12648 - Add letter ACQ_NOTIF_ON_RECEIV )\n"; >+ SetVersion ($DBversion); >+} >+ >+ > =head1 FUNCTIONS > > =head2 TableExists($table) >-- >2.1.0
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 12648
:
30024
|
30025
|
30026
|
30027
|
30988
|
30989
|
30990
|
30991
|
31273
|
31960
|
31961
|
32230
|
33186
|
33187
|
33188
|
33189
|
33190
|
33191
|
33192
|
33193
|
34224
|
34225
|
34226
|
34227
|
34228
|
34229
|
34230
|
34231
|
34477
|
34487
|
34488
|
34489
|
34490
|
34491
|
34492
|
34493
|
34494
|
34495
|
35056
|
35058
|
35059
|
35060
|
35061
|
35062
|
35063
|
35064
|
35065
|
35066
|
36795
|
36796
|
36797
|
36798
|
36799
|
36800
|
36801
|
36802
|
36803
|
36804
|
36805
|
36807
|
36810
|
36817