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 |
- |
|
|