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 |
- |
|
|