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 1194-1199 CREATE TABLE `issuingrules` ( -- circulation and fine rules Link Here
1194
  cap_fine_to_replacement_price BOOLEAN NOT NULL DEFAULT  '0', -- cap the fine based on item's replacement price
1194
  cap_fine_to_replacement_price BOOLEAN NOT NULL DEFAULT  '0', -- cap the fine based on item's replacement price
1195
  onshelfholds tinyint(1) NOT NULL default 0, -- allow holds for items that are on shelf
1195
  onshelfholds tinyint(1) NOT NULL default 0, -- allow holds for items that are on shelf
1196
  opacitemholds char(1) NOT NULL default 'N', -- allow opac users to place specific items on hold
1196
  opacitemholds char(1) NOT NULL default 'N', -- allow opac users to place specific items on hold
1197
  article_requests enum('no','yes','bib_only','item_only') NOT NULL DEFAULT 'no', -- allow article requests to be placed,
1197
  PRIMARY KEY  (`branchcode`,`categorycode`,`itemtype`),
1198
  PRIMARY KEY  (`branchcode`,`categorycode`,`itemtype`),
1198
  KEY `categorycode` (`categorycode`),
1199
  KEY `categorycode` (`categorycode`),
1199
  KEY `itemtype` (`itemtype`)
1200
  KEY `itemtype` (`itemtype`)
Lines 3626-3632 CREATE TABLE `article_requests` ( Link Here
3626
  `date` text,
3627
  `date` text,
3627
  `pages` text,
3628
  `pages` text,
3628
  `chapters` text,
3629
  `chapters` text,
3629
  `status` enum('OPEN','PROCESSING','COMPLETED','CANCELED') NOT NULL DEFAULT 'OPEN',
3630
  `status` enum('PENDING','PROCESSING','COMPLETED','CANCELED') NOT NULL DEFAULT 'PENDING',
3630
  `notes` text,
3631
  `notes` text,
3631
  `created_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
3632
  `created_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
3632
  `updated_on` timestamp NULL DEFAULT NULL,
3633
  `updated_on` timestamp NULL DEFAULT NULL,
3633
- 

Return to bug 14610