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

(-)a/installer/data/mysql/atomicupdate/bug_14237-add_course_items.biblionumber_column.perl (-2 / +11 lines)
Lines 1-7 Link Here
1
$DBversion = 'XXX';
1
$DBversion = 'XXX';
2
if( CheckVersion( $DBversion ) ){
2
if( CheckVersion( $DBversion ) ){
3
    unless( column_exists( 'course_items', 'biblionumber') ) {
3
    unless( column_exists( 'course_items', 'biblionumber') ) {
4
        $dbh->do(q{ ALTER TABLE course_items ADD `biblionumber` int(11) NOT NULL AFTER `itemnumber` });
4
        $dbh->do(q{ ALTER TABLE course_items ADD `biblionumber` int(11) AFTER `itemnumber` });
5
6
        $dbh->do(q{
7
            UPDATE course_items
8
            LEFT JOIN items ON items.itemnumber=course_items.itemnumber
9
            SET course_items.biblionumber=items.biblionumber
10
            WHERE items.itemnumber IS NOT NULL
11
        });
12
13
        $dbh->do(q{ ALTER TABLE course_items MODIFY COLUMN `biblionumber` INT(11) NOT NULL });
14
5
        $dbh->do(q{ ALTER TABLE course_items ADD CONSTRAINT `fk_course_items_biblionumber` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE });
15
        $dbh->do(q{ ALTER TABLE course_items ADD CONSTRAINT `fk_course_items_biblionumber` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE });
6
        $dbh->do(q{ ALTER TABLE course_items CHANGE `itemnumber` `itemnumber` int(11) DEFAULT NULL });
16
        $dbh->do(q{ ALTER TABLE course_items CHANGE `itemnumber` `itemnumber` int(11) DEFAULT NULL });
7
    }
17
    }
8
- 

Return to bug 14237