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

(-)a/installer/data/mysql/atomicupdate/bug-8643-add_important_constraint.sql (+10 lines)
Line 0 Link Here
1
ALTER TABLE marc_subfield_structure ADD COLUMN important TINYINT(4) NOT NULL DEFAULT 0  AFTER mandatory;
2
ALTER TABLE marc_tag_structure ADD COLUMN important TINYINT(4) NOT NULL DEFAULT 0  AFTER frameworkcode;
3
4
-- $DBversion = "3.23.00.XXX";
5
-- if ( CheckVersion($DBversion) ) {
6
--     $dbh->do("ALTER TABLE marc_subfield_structure ADD COLUMN important TINYINT(4) NOT NULL DEFAULT 0  AFTER mandatory");
7
--     $dbh->do("ALTER TABLE marc_tag_structure ADD COLUMN important TINYINT(4) NOT NULL DEFAULT 0  AFTER frameworkcode");
8
--     print "Upgrade to $DBversion done (Bug 8643 - Add important constraint to marc subfields)\n";
9
--     SetVersion($DBversion);
10
-- }
(-)a/installer/data/mysql/updatedatabase.pl (-9 lines)
Lines 11391-11404 if ( CheckVersion($DBversion) ) { Link Here
11391
    SetVersion ($DBversion);
11391
    SetVersion ($DBversion);
11392
}
11392
}
11393
11393
11394
$DBversion = "XXX";
11395
if ( CheckVersion($DBversion) ) {
11396
    $dbh->do("ALTER TABLE `marc_subfield_structure` ADD COLUMN `important` TINYINT(4) NOT NULL DEFAULT 0  AFTER `mandatory`");
11397
    $dbh->do("ALTER TABLE `marc_tag_structure` ADD COLUMN `important` TINYINT(4) NOT NULL DEFAULT 0  AFTER `frameworkcode`");
11398
    print "Upgrade to $DBversion done (Bug 8643 - Add important constraint to marc subfields)\n";
11399
    SetVersion($DBversion);
11400
}
11401
11402
# DEVELOPER PROCESS, search for anything to execute in the db_update directory
11394
# DEVELOPER PROCESS, search for anything to execute in the db_update directory
11403
# SEE bug 13068
11395
# SEE bug 13068
11404
# if there is anything in the atomicupdate, read and execute it.
11396
# if there is anything in the atomicupdate, read and execute it.
11405
- 

Return to bug 8643