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

(-)a/installer/data/mysql/atomicupdate/bug_20472a.perl (+9 lines)
Line 0 Link Here
1
$DBversion = 'XXX'; # will be replaced by the RM
2
if( CheckVersion( $DBversion ) ) {
3
    $dbh->do(q|
4
        ALTER TABLE article_requests
5
        ADD COLUMN `format` enum('PHOTOCOPY', 'SCAN') NOT NULL DEFAULT 'PHOTOCOPY' AFTER notes,
6
        ADD COLUMN `urls` MEDIUMTEXT AFTER format
7
    |);
8
    NewVersion( $DBversion, 20472, "Add columns format and urls in article_requests table");
9
}
(-)a/installer/data/mysql/kohastructure.sql (-1 / +2 lines)
Lines 4063-4068 CREATE TABLE `article_requests` ( Link Here
4063
  `patron_notes` MEDIUMTEXT,
4063
  `patron_notes` MEDIUMTEXT,
4064
  `status` enum('PENDING','PROCESSING','COMPLETED','CANCELED') NOT NULL DEFAULT 'PENDING',
4064
  `status` enum('PENDING','PROCESSING','COMPLETED','CANCELED') NOT NULL DEFAULT 'PENDING',
4065
  `notes` MEDIUMTEXT,
4065
  `notes` MEDIUMTEXT,
4066
  `format` enum('PHOTOCOPY', 'SCAN') NOT NULL DEFAULT 'PHOTOCOPY',
4067
  `urls` MEDIUMTEXT, -- One or more URLs for downloading scanned articles, separated by semicolons
4066
  `created_on` timestamp NULL DEFAULT NULL, -- Be careful with two timestamps in one table not allowing NULL
4068
  `created_on` timestamp NULL DEFAULT NULL, -- Be careful with two timestamps in one table not allowing NULL
4067
  `updated_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
4069
  `updated_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
4068
  PRIMARY KEY (`id`),
4070
  PRIMARY KEY (`id`),
4069
- 

Return to bug 20472