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

(-)a/installer/data/mysql/atomicupdate/update_user_permissions_table.pl (-1 / +6 lines)
Lines 15-20 return { Link Here
15
                ALTER TABLE user_permissions DROP INDEX IF EXISTS `PRIMARY`
15
                ALTER TABLE user_permissions DROP INDEX IF EXISTS `PRIMARY`
16
            });
16
            });
17
            say $out "Dropped any previously created primary key";
17
            say $out "Dropped any previously created primary key";
18
19
            $dbh->do(q{ALTER TABLE user_permissions ADD COLUMN temp SERIAL PRIMARY KEY});
20
            $dbh->do(q{DELETE t1 FROM user_permissions t1 INNER JOIN user_permissions t2 WHERE t1.temp < t2.temp AND t1.borrowernumber = t2.borrowernumber AND t1.module_bit = t2.module_bit AND t1.code = t2.code});
21
            $dbh->do(q{ALTER TABLE user_permissions DROP COLUMN temp});
22
            say $out "Removed any duplicate rows";
23
18
            $dbh->do(q{
24
            $dbh->do(q{
19
                ALTER TABLE user_permissions ADD CONSTRAINT PK_borrowernumber_module_code PRIMARY KEY (borrowernumber,module_bit,code)
25
                ALTER TABLE user_permissions ADD CONSTRAINT PK_borrowernumber_module_code PRIMARY KEY (borrowernumber,module_bit,code)
20
            });
26
            });
21
- 

Return to bug 30060