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

(-)a/installer/data/mysql/atomicupdate/bug_14610.sql (-1 / +1 lines)
Lines 1-4 Link Here
1
ALTER TABLE  `issuingrules` ADD  `article_requests` ENUM(  'no',  'yes',  'bib_only',  'item_only' ) NOT NULL DEFAULT  'no';
1
ALTER TABLE `issuingrules` ADD `article_requests` ENUM( 'no', 'yes', 'bib_only', 'item_only' ) NOT NULL DEFAULT 'no' AFTER `opacitemholds`;
2
2
3
INSERT INTO `systempreferences` (`variable`, `value`, `options`, `explanation`, `type`) VALUES
3
INSERT INTO `systempreferences` (`variable`, `value`, `options`, `explanation`, `type`) VALUES
4
    ('ArticleRequests', '1', NULL, 'Enables the article request feature', 'YesNo'),
4
    ('ArticleRequests', '1', NULL, 'Enables the article request feature', 'YesNo'),
(-)a/installer/data/mysql/kohastructure.sql (-2 / +2 lines)
Lines 1207-1212 CREATE TABLE `issuingrules` ( -- circulation and fine rules Link Here
1207
  cap_fine_to_replacement_price BOOLEAN NOT NULL DEFAULT  '0', -- cap the fine based on item's replacement price
1207
  cap_fine_to_replacement_price BOOLEAN NOT NULL DEFAULT  '0', -- cap the fine based on item's replacement price
1208
  onshelfholds tinyint(1) NOT NULL default 0, -- allow holds for items that are on shelf
1208
  onshelfholds tinyint(1) NOT NULL default 0, -- allow holds for items that are on shelf
1209
  opacitemholds char(1) NOT NULL default 'N', -- allow opac users to place specific items on hold
1209
  opacitemholds char(1) NOT NULL default 'N', -- allow opac users to place specific items on hold
1210
  article_requests enum('no','yes','bib_only','item_only') NOT NULL DEFAULT 'no', -- allow article requests to be placed,
1210
  PRIMARY KEY  (`branchcode`,`categorycode`,`itemtype`),
1211
  PRIMARY KEY  (`branchcode`,`categorycode`,`itemtype`),
1211
  KEY `categorycode` (`categorycode`),
1212
  KEY `categorycode` (`categorycode`),
1212
  KEY `itemtype` (`itemtype`)
1213
  KEY `itemtype` (`itemtype`)
Lines 3639-3645 CREATE TABLE `article_requests` ( Link Here
3639
  `date` text,
3640
  `date` text,
3640
  `pages` text,
3641
  `pages` text,
3641
  `chapters` text,
3642
  `chapters` text,
3642
  `status` enum('OPEN','PROCESSING','COMPLETED','CANCELED') NOT NULL DEFAULT 'OPEN',
3643
  `status` enum('PENDING','PROCESSING','COMPLETED','CANCELED') NOT NULL DEFAULT 'PENDING',
3643
  `notes` text,
3644
  `notes` text,
3644
  `created_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
3645
  `created_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
3645
  `updated_on` timestamp NULL DEFAULT NULL,
3646
  `updated_on` timestamp NULL DEFAULT NULL,
3646
- 

Return to bug 14610