Lines 918-923
CREATE TABLE `deletedborrowers` ( -- stores data related to the patrons/borrower
Link Here
|
918 |
`sms_provider_id` int(11) DEFAULT NULL, -- the provider of the mobile phone number defined in smsalertnumber |
918 |
`sms_provider_id` int(11) DEFAULT NULL, -- the provider of the mobile phone number defined in smsalertnumber |
919 |
`privacy` integer(11) DEFAULT '1' NOT NULL, -- patron/borrower's privacy settings related to their reading history KEY `borrowernumber` (`borrowernumber`), |
919 |
`privacy` integer(11) DEFAULT '1' NOT NULL, -- patron/borrower's privacy settings related to their reading history KEY `borrowernumber` (`borrowernumber`), |
920 |
`privacy_guarantor_checkouts` tinyint(1) NOT NULL DEFAULT '0', -- controls if relatives can see this patron's checkouts |
920 |
`privacy_guarantor_checkouts` tinyint(1) NOT NULL DEFAULT '0', -- controls if relatives can see this patron's checkouts |
|
|
921 |
`primary_contact_method` varchar(45) DEFAULT NULL, -- useful for reporting purposes |
921 |
KEY borrowernumber (borrowernumber), |
922 |
KEY borrowernumber (borrowernumber), |
922 |
KEY `cardnumber` (`cardnumber`), |
923 |
KEY `cardnumber` (`cardnumber`), |
923 |
KEY `sms_provider_id` (`sms_provider_id`) |
924 |
KEY `sms_provider_id` (`sms_provider_id`) |
Lines 3383-3388
CREATE TABLE IF NOT EXISTS `borrower_modifications` (
Link Here
|
3383 |
`altcontactphone` varchar(50) DEFAULT NULL, |
3384 |
`altcontactphone` varchar(50) DEFAULT NULL, |
3384 |
`smsalertnumber` varchar(50) DEFAULT NULL, |
3385 |
`smsalertnumber` varchar(50) DEFAULT NULL, |
3385 |
`privacy` int(11) DEFAULT NULL, |
3386 |
`privacy` int(11) DEFAULT NULL, |
|
|
3387 |
`primary_contact_method` varchar(45) DEFAULT NULL, -- useful for reporting purposes |
3386 |
PRIMARY KEY (`verification_token`,`borrowernumber`), |
3388 |
PRIMARY KEY (`verification_token`,`borrowernumber`), |
3387 |
KEY `verification_token` (`verification_token`), |
3389 |
KEY `verification_token` (`verification_token`), |
3388 |
KEY `borrowernumber` (`borrowernumber`) |
3390 |
KEY `borrowernumber` (`borrowernumber`) |