Lines 1-9
Link Here
|
1 |
$DBversion = 'XXX'; # will be replaced by the RM |
1 |
$DBversion = 'XXX'; # will be replaced by the RM |
2 |
if( CheckVersion( $DBversion ) ) { |
2 |
if( CheckVersion( $DBversion ) ) { |
3 |
$dbh->do(q| |
3 |
unless ( column_exists('article_requests', 'format') ) { |
4 |
ALTER TABLE article_requests |
4 |
$dbh->do(q| |
5 |
ADD COLUMN `format` enum('PHOTOCOPY', 'SCAN') NOT NULL DEFAULT 'PHOTOCOPY' AFTER notes, |
5 |
ALTER TABLE article_requests |
6 |
ADD COLUMN `urls` MEDIUMTEXT AFTER format |
6 |
ADD COLUMN `format` enum('PHOTOCOPY', 'SCAN') NOT NULL DEFAULT 'PHOTOCOPY' AFTER notes |
7 |
|); |
7 |
|); |
|
|
8 |
} |
9 |
unless ( column_exists('article_requests', 'urls') ) { |
10 |
$dbh->do(q| |
11 |
ALTER TABLE article_requests |
12 |
ADD COLUMN `urls` MEDIUMTEXT AFTER format |
13 |
|); |
14 |
} |
8 |
NewVersion( $DBversion, 20472, "Add columns format and urls in article_requests table"); |
15 |
NewVersion( $DBversion, 20472, "Add columns format and urls in article_requests table"); |
9 |
} |
16 |
} |
10 |
- |
|
|