Lines 870-875
CREATE TABLE `issuingrules` ( -- circulation and fine rules
Link Here
|
870 |
`no_auto_renewal_after_hard_limit` date default NULL, -- no auto renewal allowed after a given date |
870 |
`no_auto_renewal_after_hard_limit` date default NULL, -- no auto renewal allowed after a given date |
871 |
`reservesallowed` smallint(6) NOT NULL default "0", -- how many holds are allowed |
871 |
`reservesallowed` smallint(6) NOT NULL default "0", -- how many holds are allowed |
872 |
`holds_per_record` SMALLINT(6) NOT NULL DEFAULT 1, -- How many holds a patron can have on a given bib |
872 |
`holds_per_record` SMALLINT(6) NOT NULL DEFAULT 1, -- How many holds a patron can have on a given bib |
|
|
873 |
`holds_per_day` SMALLINT(6) DEFAULT NULL, -- How many holds a patron can have on a day |
873 |
`branchcode` varchar(10) NOT NULL default '', -- the branch this rule is for (branches.branchcode) |
874 |
`branchcode` varchar(10) NOT NULL default '', -- the branch this rule is for (branches.branchcode) |
874 |
overduefinescap decimal(28,6) default NULL, -- the maximum amount of an overdue fine |
875 |
overduefinescap decimal(28,6) default NULL, -- the maximum amount of an overdue fine |
875 |
cap_fine_to_replacement_price BOOLEAN NOT NULL DEFAULT '0', -- cap the fine based on item's replacement price |
876 |
cap_fine_to_replacement_price BOOLEAN NOT NULL DEFAULT '0', -- cap the fine based on item's replacement price |
Lines 1875-1881
DROP TABLE IF EXISTS `reserves`;
Link Here
|
1875 |
CREATE TABLE `reserves` ( -- information related to holds/reserves in Koha |
1876 |
CREATE TABLE `reserves` ( -- information related to holds/reserves in Koha |
1876 |
`reserve_id` int(11) NOT NULL auto_increment, -- primary key |
1877 |
`reserve_id` int(11) NOT NULL auto_increment, -- primary key |
1877 |
`borrowernumber` int(11) NOT NULL default 0, -- foreign key from the borrowers table defining which patron this hold is for |
1878 |
`borrowernumber` int(11) NOT NULL default 0, -- foreign key from the borrowers table defining which patron this hold is for |
1878 |
`reservedate` date default NULL, -- the date the hold was places |
1879 |
`reservedate` date default NULL, -- the date the hold was placed |
1879 |
`biblionumber` int(11) NOT NULL default 0, -- foreign key from the biblio table defining which bib record this hold is on |
1880 |
`biblionumber` int(11) NOT NULL default 0, -- foreign key from the biblio table defining which bib record this hold is on |
1880 |
`branchcode` varchar(10) default NULL, -- foreign key from the branches table defining which branch the patron wishes to pick this hold up at |
1881 |
`branchcode` varchar(10) default NULL, -- foreign key from the branches table defining which branch the patron wishes to pick this hold up at |
1881 |
`notificationdate` date default NULL, -- currently unused |
1882 |
`notificationdate` date default NULL, -- currently unused |
1882 |
- |
|
|