Lines 611-616
CREATE TABLE `deletedborrowers` ( -- stores data related to the patrons/borrower
Link Here
|
611 |
`lang` varchar(25) NOT NULL default 'default', -- lang to use to send notices to this patron |
611 |
`lang` varchar(25) NOT NULL default 'default', -- lang to use to send notices to this patron |
612 |
`login_attempts` int(4) default 0, -- number of failed login attemps |
612 |
`login_attempts` int(4) default 0, -- number of failed login attemps |
613 |
`overdrive_auth_token` MEDIUMTEXT default NULL, -- persist OverDrive auth token |
613 |
`overdrive_auth_token` MEDIUMTEXT default NULL, -- persist OverDrive auth token |
|
|
614 |
`primary_contact_method` varchar(45) DEFAULT NULL, -- useful for reporting purposes |
614 |
KEY borrowernumber (borrowernumber), |
615 |
KEY borrowernumber (borrowernumber), |
615 |
KEY `cardnumber` (`cardnumber`), |
616 |
KEY `cardnumber` (`cardnumber`), |
616 |
KEY `sms_provider_id` (`sms_provider_id`) |
617 |
KEY `sms_provider_id` (`sms_provider_id`) |
Lines 1638-1643
CREATE TABLE `borrowers` ( -- this table includes information about your patrons
Link Here
|
1638 |
`lang` varchar(25) NOT NULL default 'default', -- lang to use to send notices to this patron |
1639 |
`lang` varchar(25) NOT NULL default 'default', -- lang to use to send notices to this patron |
1639 |
`login_attempts` int(4) default 0, -- number of failed login attemps |
1640 |
`login_attempts` int(4) default 0, -- number of failed login attemps |
1640 |
`overdrive_auth_token` MEDIUMTEXT default NULL, -- persist OverDrive auth token |
1641 |
`overdrive_auth_token` MEDIUMTEXT default NULL, -- persist OverDrive auth token |
|
|
1642 |
`primary_contact_method` varchar(45) DEFAULT NULL, -- useful for reporting purposes |
1641 |
UNIQUE KEY `cardnumber` (`cardnumber`), |
1643 |
UNIQUE KEY `cardnumber` (`cardnumber`), |
1642 |
PRIMARY KEY `borrowernumber` (`borrowernumber`), |
1644 |
PRIMARY KEY `borrowernumber` (`borrowernumber`), |
1643 |
KEY `categorycode` (`categorycode`), |
1645 |
KEY `categorycode` (`categorycode`), |
Lines 3427-3432
CREATE TABLE IF NOT EXISTS `borrower_modifications` (
Link Here
|
3427 |
`smsalertnumber` varchar(50) DEFAULT NULL, |
3429 |
`smsalertnumber` varchar(50) DEFAULT NULL, |
3428 |
`privacy` int(11) DEFAULT NULL, |
3430 |
`privacy` int(11) DEFAULT NULL, |
3429 |
`extended_attributes` MEDIUMTEXT DEFAULT NULL, |
3431 |
`extended_attributes` MEDIUMTEXT DEFAULT NULL, |
|
|
3432 |
`primary_contact_method` varchar(45) DEFAULT NULL, -- useful for reporting purposes |
3430 |
PRIMARY KEY (`verification_token` (191),`borrowernumber`), |
3433 |
PRIMARY KEY (`verification_token` (191),`borrowernumber`), |
3431 |
KEY `verification_token` (`verification_token` (191)), |
3434 |
KEY `verification_token` (`verification_token` (191)), |
3432 |
KEY `borrowernumber` (`borrowernumber`) |
3435 |
KEY `borrowernumber` (`borrowernumber`) |