@@ -, +, @@ --- installer/data/mysql/atomicupdate/bug_20472a.perl | 9 +++++++++ 1 file changed, 9 insertions(+) create mode 100644 installer/data/mysql/atomicupdate/bug_20472a.perl --- a/installer/data/mysql/atomicupdate/bug_20472a.perl +++ a/installer/data/mysql/atomicupdate/bug_20472a.perl @@ -0,0 +1,9 @@ +$DBversion = 'XXX'; # will be replaced by the RM +if( CheckVersion( $DBversion ) ) { + $dbh->do(q| + ALTER TABLE article_requests + ADD COLUMN `format` enum('PHOTOCOPY', 'SCAN') NOT NULL DEFAULT 'PHOTOCOPY' AFTER notes, + ADD COLUMN `urls` MEDIUMTEXT AFTER format + |); + NewVersion( $DBversion, 20472, "Add columns format and urls in article_requests table"); +} --