Lines 621-626
CREATE TABLE `deletedborrowers` ( -- stores data related to the patrons/borrower
Link Here
|
621 |
`privacy_guarantor_checkouts` tinyint(1) NOT NULL DEFAULT '0', -- controls if relatives can see this patron's checkouts |
621 |
`privacy_guarantor_checkouts` tinyint(1) NOT NULL DEFAULT '0', -- controls if relatives can see this patron's checkouts |
622 |
`checkprevcheckout` varchar(7) NOT NULL default 'inherit', -- produce a warning for this patron if this item has previously been checked out to this patron if 'yes', not if 'no', defer to category setting if 'inherit'. |
622 |
`checkprevcheckout` varchar(7) NOT NULL default 'inherit', -- produce a warning for this patron if this item has previously been checked out to this patron if 'yes', not if 'no', defer to category setting if 'inherit'. |
623 |
`updated_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, -- time of last change could be useful for synchronization with external systems (among others) |
623 |
`updated_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, -- time of last change could be useful for synchronization with external systems (among others) |
|
|
624 |
`primary_contact_method` varchar(45) DEFAULT NULL, -- useful for reporting purposes |
624 |
KEY borrowernumber (borrowernumber), |
625 |
KEY borrowernumber (borrowernumber), |
625 |
KEY `cardnumber` (`cardnumber`), |
626 |
KEY `cardnumber` (`cardnumber`), |
626 |
KEY `sms_provider_id` (`sms_provider_id`) |
627 |
KEY `sms_provider_id` (`sms_provider_id`) |
Lines 3390-3395
CREATE TABLE IF NOT EXISTS `borrower_modifications` (
Link Here
|
3390 |
`altcontactphone` varchar(50) DEFAULT NULL, |
3391 |
`altcontactphone` varchar(50) DEFAULT NULL, |
3391 |
`smsalertnumber` varchar(50) DEFAULT NULL, |
3392 |
`smsalertnumber` varchar(50) DEFAULT NULL, |
3392 |
`privacy` int(11) DEFAULT NULL, |
3393 |
`privacy` int(11) DEFAULT NULL, |
|
|
3394 |
`primary_contact_method` varchar(45) DEFAULT NULL, -- useful for reporting purposes |
3393 |
PRIMARY KEY (`verification_token`,`borrowernumber`), |
3395 |
PRIMARY KEY (`verification_token`,`borrowernumber`), |
3394 |
KEY `verification_token` (`verification_token`), |
3396 |
KEY `verification_token` (`verification_token`), |
3395 |
KEY `borrowernumber` (`borrowernumber`) |
3397 |
KEY `borrowernumber` (`borrowernumber`) |