Bugzilla – Attachment 36817 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: Add some documentation on the kohastructure.sql file
Bug-12648-Add-some-documentation-on-the-kohastruct.patch (text/plain), 1.49 KB, created by
Tomás Cohen Arazi (tcohen)
on 2015-03-11 17:04:41 UTC
(
hide
)
Description:
Bug 12648: Add some documentation on the kohastructure.sql file
Filename:
MIME Type:
Creator:
Tomás Cohen Arazi (tcohen)
Created:
2015-03-11 17:04:41 UTC
Size:
1.49 KB
patch
obsolete
>From 018ae50a77f574f988796d0579e3d5b79051b62c Mon Sep 17 00:00:00 2001 >From: Tomas Cohen Arazi <tomascohen@gmail.com> >Date: Wed, 11 Mar 2015 11:59:03 -0300 >Subject: [PATCH] Bug 12648: Add some documentation on the kohastructure.sql > file > >Signed-off-by: Tomas Cohen Arazi <tomascohen@gmail.com> >--- > installer/data/mysql/kohastructure.sql | 6 +++--- > 1 file changed, 3 insertions(+), 3 deletions(-) > >diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql >index ff6dee2..1408216 100644 >--- a/installer/data/mysql/kohastructure.sql >+++ b/installer/data/mysql/kohastructure.sql >@@ -3093,9 +3093,9 @@ CREATE TABLE `aqorders` ( -- information related to the basket line items > -- > > DROP TABLE IF EXISTS `aqorder_users`; >-CREATE TABLE aqorder_users ( >- ordernumber int(11) NOT NULL, >- borrowernumber int(11) NOT NULL, >+CREATE TABLE aqorder_users ( -- Mapping orders to patrons for notification sending >+ ordernumber int(11) NOT NULL, -- the order this patrons receive notifications from (aqorders.ordernumber) >+ borrowernumber int(11) NOT NULL, -- the borrowernumber for the patron receiving notifications for this order (borrowers.borrowernumber) > PRIMARY KEY (ordernumber, borrowernumber), > CONSTRAINT aqorder_users_ibfk_1 FOREIGN KEY (ordernumber) REFERENCES aqorders (ordernumber) ON DELETE CASCADE ON UPDATE CASCADE, > CONSTRAINT aqorder_users_ibfk_2 FOREIGN KEY (borrowernumber) REFERENCES borrowers (borrowernumber) ON DELETE CASCADE ON UPDATE CASCADE >-- >2.3.2
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