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

(-)a/installer/data/mysql/atomicupdate/bug_7710.sql (+1 lines)
Line 0 Link Here
1
ALTER TABLE issuingrules ADD COLUMN holds_per_record SMALLINT(6) NOT NULL DEFAULT 1 AFTER reservesallowed;
(-)a/installer/data/mysql/kohastructure.sql (-1 / +1 lines)
Lines 1202-1207 CREATE TABLE `issuingrules` ( -- circulation and fine rules Link Here
1202
  `norenewalbefore` int(4) default NULL, -- no renewal allowed until X days or hours before due date. In the unit set in issuingrules.lengthunit
1202
  `norenewalbefore` int(4) default NULL, -- no renewal allowed until X days or hours before due date. In the unit set in issuingrules.lengthunit
1203
  `auto_renew` BOOLEAN default FALSE, -- automatic renewal
1203
  `auto_renew` BOOLEAN default FALSE, -- automatic renewal
1204
  `reservesallowed` smallint(6) NOT NULL default "0", -- how many holds are allowed
1204
  `reservesallowed` smallint(6) NOT NULL default "0", -- how many holds are allowed
1205
  `holds_per_record` SMALLINT(6) NOT NULL DEFAULT 1, -- How many holds a patron can have on a given bib
1205
  `branchcode` varchar(10) NOT NULL default '', -- the branch this rule is for (branches.branchcode)
1206
  `branchcode` varchar(10) NOT NULL default '', -- the branch this rule is for (branches.branchcode)
1206
  overduefinescap decimal(28,6) default NULL, -- the maximum amount of an overdue fine
1207
  overduefinescap decimal(28,6) default NULL, -- the maximum amount of an overdue fine
1207
  cap_fine_to_replacement_price BOOLEAN NOT NULL DEFAULT  '0', -- cap the fine based on item's replacement price
1208
  cap_fine_to_replacement_price BOOLEAN NOT NULL DEFAULT  '0', -- cap the fine based on item's replacement price
1208
- 

Return to bug 14695