Lines 642-647
CREATE TABLE `deletedborrowers` ( -- stores data related to the patrons/borrower
Link Here
|
642 |
`lang` varchar(25) NOT NULL default 'default', -- lang to use to send notices to this patron |
642 |
`lang` varchar(25) NOT NULL default 'default', -- lang to use to send notices to this patron |
643 |
`login_attempts` int(4) default 0, -- number of failed login attemps |
643 |
`login_attempts` int(4) default 0, -- number of failed login attemps |
644 |
`overdrive_auth_token` MEDIUMTEXT default NULL, -- persist OverDrive auth token |
644 |
`overdrive_auth_token` MEDIUMTEXT default NULL, -- persist OverDrive auth token |
|
|
645 |
`tags_whitelist` TINYINT(1) DEFAULT 0 NOT NULL, -- borrower can submit tags without requiring approval |
646 |
`comments_whitelist` TINYINT(1) DEFAULT 0 NOT NULL, -- borrower can submit comments without requiring approval |
647 |
`tags_blacklist` TINYINT(1) DEFAULT 0 NOT NULL, -- borrower is blocked from submitting tags |
648 |
`comments_blacklist` TINYINT(1) DEFAULT 0 NOT NULL, -- borrower is blocked from submitting comments |
645 |
KEY borrowernumber (borrowernumber), |
649 |
KEY borrowernumber (borrowernumber), |
646 |
KEY `cardnumber` (`cardnumber`), |
650 |
KEY `cardnumber` (`cardnumber`), |
647 |
KEY `sms_provider_id` (`sms_provider_id`) |
651 |
KEY `sms_provider_id` (`sms_provider_id`) |
Lines 1675-1680
CREATE TABLE `borrowers` ( -- this table includes information about your patrons
Link Here
|
1675 |
`lang` varchar(25) NOT NULL default 'default', -- lang to use to send notices to this patron |
1679 |
`lang` varchar(25) NOT NULL default 'default', -- lang to use to send notices to this patron |
1676 |
`login_attempts` int(4) default 0, -- number of failed login attemps |
1680 |
`login_attempts` int(4) default 0, -- number of failed login attemps |
1677 |
`overdrive_auth_token` MEDIUMTEXT default NULL, -- persist OverDrive auth token |
1681 |
`overdrive_auth_token` MEDIUMTEXT default NULL, -- persist OverDrive auth token |
|
|
1682 |
`tags_whitelist` TINYINT(1) DEFAULT 0 NOT NULL, -- borrower can submit tags without requiring approval |
1683 |
`comments_whitelist` TINYINT(1) DEFAULT 0 NOT NULL, -- borrower can submit comments without requiring approval |
1684 |
`tags_blacklist` TINYINT(1) DEFAULT 0 NOT NULL, -- borrower is blocked from submitting tags |
1685 |
`comments_blacklist` TINYINT(1) DEFAULT 0 NOT NULL, -- borrower is blocked from submitting comments |
1678 |
UNIQUE KEY `cardnumber` (`cardnumber`), |
1686 |
UNIQUE KEY `cardnumber` (`cardnumber`), |
1679 |
PRIMARY KEY `borrowernumber` (`borrowernumber`), |
1687 |
PRIMARY KEY `borrowernumber` (`borrowernumber`), |
1680 |
KEY `categorycode` (`categorycode`), |
1688 |
KEY `categorycode` (`categorycode`), |
1681 |
- |
|
|