Lines 9675-9694
if(CheckVersion($DBversion)) {
Link Here
|
9675 |
$dbh->do(q{ |
9675 |
$dbh->do(q{ |
9676 |
ALTER TABLE borrowers ADD privacy_guarantor_checkouts BOOLEAN NOT NULL DEFAULT '0' AFTER privacy |
9676 |
ALTER TABLE borrowers ADD privacy_guarantor_checkouts BOOLEAN NOT NULL DEFAULT '0' AFTER privacy |
9677 |
}); |
9677 |
}); |
|
|
9678 |
|
9678 |
$dbh->do(q{ |
9679 |
$dbh->do(q{ |
9679 |
ALTER TABLE deletedborrowers ADD privacy_guarantor_checkouts BOOLEAN NOT NULL DEFAULT '0' AFTER privacy |
9680 |
ALTER TABLE deletedborrowers ADD privacy_guarantor_checkouts BOOLEAN NOT NULL DEFAULT '0' AFTER privacy |
9680 |
}); |
9681 |
}); |
|
|
9682 |
|
9681 |
$dbh->do(q{ |
9683 |
$dbh->do(q{ |
9682 |
ALTER TABLE old_issues ADD issue_id INT( 11 ) NOT NULL PRIMARY KEY FIRST |
9684 |
ALTER TABLE old_issues ADD issue_id INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST |
9683 |
}); |
9685 |
}); |
|
|
9686 |
|
9684 |
$dbh->do(q{ |
9687 |
$dbh->do(q{ |
9685 |
ALTER TABLE issues ADD issue_id INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST |
9688 |
ALTER TABLE old_issues CHANGE issue_id issue_id INT( 11 ) NOT NULL |
9686 |
}); |
9689 |
}); |
|
|
9690 |
|
9687 |
$dbh->do(q{ |
9691 |
$dbh->do(q{ |
9688 |
ALTER TABLE issues |
9692 |
ALTER TABLE issues ADD issue_id INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST |
9689 |
DROP INDEX itemnumber_idx, |
|
|
9690 |
ADD UNIQUE itemnumber_idx ( itemnumber ) |
9691 |
}); |
9693 |
}); |
|
|
9694 |
|
9692 |
$dbh->do(qq{ |
9695 |
$dbh->do(qq{ |
9693 |
UPDATE issues SET issue_id = issue_id + ( SELECT COUNT(*) FROM old_issues ) ORDER BY issue_id DESC |
9696 |
UPDATE issues SET issue_id = issue_id + ( SELECT COUNT(*) FROM old_issues ) ORDER BY issue_id DESC |
9694 |
}); |
9697 |
}); |
Lines 9703-9709
if(CheckVersion($DBversion)) {
Link Here
|
9703 |
}); |
9706 |
}); |
9704 |
|
9707 |
|
9705 |
$dbh->do(q{ |
9708 |
$dbh->do(q{ |
9706 |
INSERT INTO systempreferences (variable, value, options, explanation, type ) |
9709 |
INSERT IGNORE INTO systempreferences (variable, value, options, explanation, type ) |
9707 |
VALUES ( |
9710 |
VALUES ( |
9708 |
'AllowStaffToSetCheckoutsVisibilityForGuarantor', '0', NULL, |
9711 |
'AllowStaffToSetCheckoutsVisibilityForGuarantor', '0', NULL, |
9709 |
'If enabled, library staff can set a patron''s checkouts to be visible to linked patrons from the opac.', 'YesNo' |
9712 |
'If enabled, library staff can set a patron''s checkouts to be visible to linked patrons from the opac.', 'YesNo' |
Lines 9711-9717
if(CheckVersion($DBversion)) {
Link Here
|
9711 |
}); |
9714 |
}); |
9712 |
|
9715 |
|
9713 |
$dbh->do(q{ |
9716 |
$dbh->do(q{ |
9714 |
INSERT INTO systempreferences (variable, value, options, explanation, type ) |
9717 |
INSERT IGNORE INTO systempreferences (variable, value, options, explanation, type ) |
9715 |
VALUES ( |
9718 |
VALUES ( |
9716 |
'AllowPatronToSetCheckoutsVisibilityForGuarantor', '0', NULL, |
9719 |
'AllowPatronToSetCheckoutsVisibilityForGuarantor', '0', NULL, |
9717 |
'If enabled, the patron can set checkouts to be visible to his or her guarantor', 'YesNo' |
9720 |
'If enabled, the patron can set checkouts to be visible to his or her guarantor', 'YesNo' |
9718 |
- |
|
|