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

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

Return to bug 6716