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 4078-4083 CREATE TABLE `article_requests` ( Link Here
4078
  `patron_notes` MEDIUMTEXT,
4078
  `patron_notes` MEDIUMTEXT,
4079
  `status` enum('PENDING','PROCESSING','COMPLETED','CANCELED') NOT NULL DEFAULT 'PENDING',
4079
  `status` enum('PENDING','PROCESSING','COMPLETED','CANCELED') NOT NULL DEFAULT 'PENDING',
4080
  `notes` MEDIUMTEXT,
4080
  `notes` MEDIUMTEXT,
4081
  `format` enum('PHOTOCOPY', 'SCAN') NOT NULL DEFAULT 'PHOTOCOPY',
4082
  `urls` MEDIUMTEXT, -- One or more URLs for downloading scanned articles, separated by semicolons
4081
  `created_on` timestamp NULL DEFAULT NULL, -- Be careful with two timestamps in one table not allowing NULL
4083
  `created_on` timestamp NULL DEFAULT NULL, -- Be careful with two timestamps in one table not allowing NULL
4082
  `updated_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
4084
  `updated_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
4083
  PRIMARY KEY (`id`),
4085
  PRIMARY KEY (`id`),
4084
- 

Return to bug 20472