Bugzilla – Attachment 36642 Details for
Bug 10703
add/update database documentation
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 10703: Update Patron DB Documentation
Bug-10703-Update-Patron-DB-Documentation.patch (text/plain), 3.08 KB, created by
Brendan Gallagher
on 2015-03-06 08:55:47 UTC
(
hide
)
Description:
Bug 10703: Update Patron DB Documentation
Filename:
MIME Type:
Creator:
Brendan Gallagher
Created:
2015-03-06 08:55:47 UTC
Size:
3.08 KB
patch
obsolete
>From 9c30e8f0578b09538d1222cddf7f7ca005a21aeb Mon Sep 17 00:00:00 2001 >From: Nicole <nicole@bywatersolutions.com> >Date: Thu, 5 Mar 2015 06:15:56 -0800 >Subject: [PATCH] Bug 10703: Update Patron DB Documentation > >Update patron categories and patron restrictions DB docs. > >To test: > >* Review database documentation for categories >* Review database documentation for patron_debarments > >Signed-off-by: Brendan Gallagher <brendan@bywatersolutions.com> >--- > installer/data/mysql/kohastructure.sql | 20 ++++++++++---------- > 1 file changed, 10 insertions(+), 10 deletions(-) > >diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql >index e30ae7b..daa7f20 100644 >--- a/installer/data/mysql/kohastructure.sql >+++ b/installer/data/mysql/kohastructure.sql >@@ -322,15 +322,15 @@ CREATE TABLE `borrower_attributes` ( -- values of custom patron fields known as > -- > > DROP TABLE IF EXISTS `borrower_debarments`; >-CREATE TABLE borrower_debarments ( >- borrower_debarment_id int(11) NOT NULL AUTO_INCREMENT, >- borrowernumber int(11) NOT NULL, >- expiration date DEFAULT NULL, >- `type` enum('SUSPENSION','OVERDUES','MANUAL') NOT NULL DEFAULT 'MANUAL', >- `comment` text, >- manager_id int(11) DEFAULT NULL, >- created timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, >- updated timestamp NULL DEFAULT NULL, >+CREATE TABLE borrower_debarments ( -- tracks restrictions on the patron's record >+ borrower_debarment_id int(11) NOT NULL AUTO_INCREMENT, -- unique key for the restriction >+ borrowernumber int(11) NOT NULL, -- foreign key for borrowers.borrowernumber for patron who is restricted >+ expiration date DEFAULT NULL, -- expiration date of the restriction >+ `type` enum('SUSPENSION','OVERDUES','MANUAL') NOT NULL DEFAULT 'MANUAL', -- type of restriction >+ `comment` text, -- comments about the restriction >+ manager_id int(11) DEFAULT NULL, -- foreign key for borrowers.borrowernumber for the librarian managing the restriction >+ created timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, -- date the restriction was added >+ updated timestamp NULL DEFAULT NULL, -- date the restriction was updated > PRIMARY KEY (borrower_debarment_id), > KEY borrowernumber (borrowernumber), > CONSTRAINT `borrower_debarments_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) >@@ -477,7 +477,7 @@ CREATE TABLE `categories` ( -- this table shows information related to Koha patr > `enrolmentperiod` smallint(6) default NULL, -- number of months the patron is enrolled for (will be NULL if enrolmentperioddate is set) > `enrolmentperioddate` DATE NULL DEFAULT NULL, -- date the patron is enrolled until (will be NULL if enrolmentperiod is set) > `upperagelimit` smallint(6) default NULL, -- age limit for the patron >- `dateofbirthrequired` tinyint(1) default NULL, >+ `dateofbirthrequired` tinyint(1) default NULL, -- the minimum age required for the patron category > `finetype` varchar(30) default NULL, -- unused in Koha > `bulk` tinyint(1) default NULL, > `enrolmentfee` decimal(28,6) default NULL, -- enrollment fee for the patron >-- >1.7.10.4
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 10703
:
20208
|
20209
|
20210
|
20248
|
20249
|
20250
|
20415
|
20416
|
20417
|
36582
|
36602
|
36603
|
36604
|
36605
|
36640
|
36641
|
36642
|
36648
|
36649
|
36650
|
36660
|
36669
|
36670
|
36910
|
36911
|
36912
|
36913