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

(-)a/installer/data/mysql/kohastructure.sql (-14 / +13 lines)
Lines 417-437 CREATE TABLE `browser` ( Link Here
417
--
417
--
418
418
419
DROP TABLE IF EXISTS `categories`;
419
DROP TABLE IF EXISTS `categories`;
420
CREATE TABLE `categories` (
420
CREATE TABLE `categories` ( -- this table shows information related to Koha patron categories
421
  `categorycode` varchar(10) NOT NULL default '',
421
  `categorycode` varchar(10) NOT NULL default '', -- unique primary key used to idenfity the patron category
422
  `description` mediumtext,
422
  `description` mediumtext, -- description of the patron category
423
  `enrolmentperiod` smallint(6) default NULL,
423
  `enrolmentperiod` smallint(6) default NULL, -- number of months the patron is enrolled for (will be NULL if enrolmentperioddate is set)
424
  `enrolmentperioddate` DATE NULL DEFAULT NULL,
424
  `enrolmentperioddate` DATE NULL DEFAULT NULL, -- date the patron is enrolled until (will be NULL if enrolmentperiod is set)
425
  `upperagelimit` smallint(6) default NULL,
425
  `upperagelimit` smallint(6) default NULL, -- age limit for the patron
426
  `dateofbirthrequired` tinyint(1) default NULL,
426
  `dateofbirthrequired` tinyint(1) default NULL,
427
  `finetype` varchar(30) default NULL,
427
  `finetype` varchar(30) default NULL, -- unused in Koha
428
  `bulk` tinyint(1) default NULL,
428
  `bulk` tinyint(1) default NULL,
429
  `enrolmentfee` decimal(28,6) default NULL,
429
  `enrolmentfee` decimal(28,6) default NULL, -- enrollment fee for the patron
430
  `overduenoticerequired` tinyint(1) default NULL,
430
  `overduenoticerequired` tinyint(1) default NULL, -- are overdue notices sent to this patron category (1 for yes, 0 for no)
431
  `issuelimit` smallint(6) default NULL,
431
  `issuelimit` smallint(6) default NULL, -- unused in Koha
432
  `reservefee` decimal(28,6) default NULL,
432
  `reservefee` decimal(28,6) default NULL, -- cost to place holds
433
  `hidelostitems` tinyint(1) NOT NULL default '0',
433
  `hidelostitems` tinyint(1) NOT NULL default '0', -- are lost items shown to this category (1 for yes, 0 for no)
434
  `category_type` varchar(1) NOT NULL default 'A',
434
  `category_type` varchar(1) NOT NULL default 'A', -- type of Koha patron (Adult, Child, Professional, Organizational, Statistical, Staff)
435
  PRIMARY KEY  (`categorycode`),
435
  PRIMARY KEY  (`categorycode`),
436
  UNIQUE KEY `categorycode` (`categorycode`)
436
  UNIQUE KEY `categorycode` (`categorycode`)
437
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
437
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
438
- 

Return to bug 6716