View | Details | Raw Unified | Return to bug 10703
Collapse All | Expand All

(-)a/installer/data/mysql/kohastructure.sql (-11 / +10 lines)
Lines 322-336 CREATE TABLE `borrower_attributes` ( -- values of custom patron fields known as Link Here
322
--
322
--
323
323
324
DROP TABLE IF EXISTS `borrower_debarments`;
324
DROP TABLE IF EXISTS `borrower_debarments`;
325
CREATE TABLE borrower_debarments (
325
CREATE TABLE borrower_debarments ( -- tracks restrictions on the patron's record
326
  borrower_debarment_id int(11) NOT NULL AUTO_INCREMENT,
326
  borrower_debarment_id int(11) NOT NULL AUTO_INCREMENT, -- unique key for the restriction
327
  borrowernumber int(11) NOT NULL,
327
  borrowernumber int(11) NOT NULL, -- foreign key for borrowers.borrowernumber for patron who is restricted
328
  expiration date DEFAULT NULL,
328
  expiration date DEFAULT NULL, -- expiration date of the restriction
329
  `type` enum('SUSPENSION','OVERDUES','MANUAL') NOT NULL DEFAULT 'MANUAL',
329
  `type` enum('SUSPENSION','OVERDUES','MANUAL') NOT NULL DEFAULT 'MANUAL', -- type of restriction
330
  `comment` text,
330
  `comment` text, -- comments about the restriction
331
  manager_id int(11) DEFAULT NULL,
331
  manager_id int(11) DEFAULT NULL, -- foreign key for borrowers.borrowernumber for the librarian managing the restriction
332
  created timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
332
  created timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, -- date the restriction was added
333
  updated timestamp NULL DEFAULT NULL,
333
  updated timestamp NULL DEFAULT NULL, -- date the restriction was updated
334
  PRIMARY KEY (borrower_debarment_id),
334
  PRIMARY KEY (borrower_debarment_id),
335
  KEY borrowernumber (borrowernumber),
335
  KEY borrowernumber (borrowernumber),
336
  CONSTRAINT `borrower_debarments_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`)
336
  CONSTRAINT `borrower_debarments_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`)
Lines 477-483 CREATE TABLE `categories` ( -- this table shows information related to Koha patr Link Here
477
  `enrolmentperiod` smallint(6) default NULL, -- number of months the patron is enrolled for (will be NULL if enrolmentperioddate is set)
477
  `enrolmentperiod` smallint(6) default NULL, -- number of months the patron is enrolled for (will be NULL if enrolmentperioddate is set)
478
  `enrolmentperioddate` DATE NULL DEFAULT NULL, -- date the patron is enrolled until (will be NULL if enrolmentperiod is set)
478
  `enrolmentperioddate` DATE NULL DEFAULT NULL, -- date the patron is enrolled until (will be NULL if enrolmentperiod is set)
479
  `upperagelimit` smallint(6) default NULL, -- age limit for the patron
479
  `upperagelimit` smallint(6) default NULL, -- age limit for the patron
480
  `dateofbirthrequired` tinyint(1) default NULL,
480
  `dateofbirthrequired` tinyint(1) default NULL, -- the minimum age required for the patron category
481
  `finetype` varchar(30) default NULL, -- unused in Koha
481
  `finetype` varchar(30) default NULL, -- unused in Koha
482
  `bulk` tinyint(1) default NULL,
482
  `bulk` tinyint(1) default NULL,
483
  `enrolmentfee` decimal(28,6) default NULL, -- enrollment fee for the patron
483
  `enrolmentfee` decimal(28,6) default NULL, -- enrollment fee for the patron
484
- 

Return to bug 10703