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

(-)a/installer/data/mysql/atomicupdate/bug_21682.perl (-2 / +5 lines)
Lines 1-6 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( "ALTER TABLE `stockrotationrotas` ALTER COLUMN `description` DROP DEFAULT" );
3
    # people upgrading their MySQL/MariaDB will have already had the DB forcibly fixed,
4
    # but for those who have not, and there is a sql strict mode issue, this will fix it.
5
    if ( default_exists( 'stockrotationrotas', 'description' ) ) {
6
        $dbh->do( "ALTER TABLE `stockrotationrotas` ALTER COLUMN `description` DROP DEFAULT" );
7
    }
4
8
5
    SetVersion( $DBversion );
9
    SetVersion( $DBversion );
6
    print "Upgrade to $DBversion done (Bug 21682 - Remove default on stockrotationrotas.description )\n";
10
    print "Upgrade to $DBversion done (Bug 21682 - Remove default on stockrotationrotas.description )\n";
7
- 

Return to bug 21682