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 1190-1195 CREATE TABLE `issuingrules` ( -- circulation and fine rules Link Here
1190
  overduefinescap decimal(28,6) default NULL, -- the maximum amount of an overdue fine
1190
  overduefinescap decimal(28,6) default NULL, -- the maximum amount of an overdue fine
1191
  onshelfholds tinyint(1) NOT NULL default 0, -- allow holds for items that are on shelf
1191
  onshelfholds tinyint(1) NOT NULL default 0, -- allow holds for items that are on shelf
1192
  opacitemholds char(1) NOT NULL default 'N', -- allow opac users to place specific items on hold
1192
  opacitemholds char(1) NOT NULL default 'N', -- allow opac users to place specific items on hold
1193
  article_requests enum('no','yes','bib_only','item_only') NOT NULL DEFAULT 'no', -- allow article requests to be placed,
1193
  PRIMARY KEY  (`branchcode`,`categorycode`,`itemtype`),
1194
  PRIMARY KEY  (`branchcode`,`categorycode`,`itemtype`),
1194
  KEY `categorycode` (`categorycode`),
1195
  KEY `categorycode` (`categorycode`),
1195
  KEY `itemtype` (`itemtype`)
1196
  KEY `itemtype` (`itemtype`)
Lines 3597-3603 CREATE TABLE `article_requests` ( Link Here
3597
  `date` text,
3598
  `date` text,
3598
  `pages` text,
3599
  `pages` text,
3599
  `chapters` text,
3600
  `chapters` text,
3600
  `status` enum('OPEN','PROCESSING','COMPLETED','CANCELED') NOT NULL DEFAULT 'OPEN',
3601
  `status` enum('PENDING','PROCESSING','COMPLETED','CANCELED') NOT NULL DEFAULT 'PENDING',
3601
  `notes` text,
3602
  `notes` text,
3602
  `created_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
3603
  `created_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
3603
  `updated_on` timestamp NULL DEFAULT NULL,
3604
  `updated_on` timestamp NULL DEFAULT NULL,
3604
- 

Return to bug 14610