|
Lines 632-637
CREATE TABLE `deletedborrowers` ( -- stores data related to the patrons/borrower
Link Here
|
| 632 |
`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'. |
632 |
`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'. |
| 633 |
`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) |
633 |
`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) |
| 634 |
`lastseen` datetime default NULL, -- last time a patron has been seed (connected at the OPAC or staff interface) |
634 |
`lastseen` datetime default NULL, -- last time a patron has been seed (connected at the OPAC or staff interface) |
|
|
635 |
`primary_contact_method` varchar(45) DEFAULT NULL, -- useful for reporting purposes |
| 635 |
KEY borrowernumber (borrowernumber), |
636 |
KEY borrowernumber (borrowernumber), |
| 636 |
KEY `cardnumber` (`cardnumber`), |
637 |
KEY `cardnumber` (`cardnumber`), |
| 637 |
KEY `sms_provider_id` (`sms_provider_id`) |
638 |
KEY `sms_provider_id` (`sms_provider_id`) |
|
Lines 1655-1660
CREATE TABLE `borrowers` ( -- this table includes information about your patrons
Link Here
|
| 1655 |
`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'. |
1656 |
`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'. |
| 1656 |
`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) |
1657 |
`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) |
| 1657 |
`lastseen` datetime default NULL, -- last time a patron has been seed (connected at the OPAC or staff interface) |
1658 |
`lastseen` datetime default NULL, -- last time a patron has been seed (connected at the OPAC or staff interface) |
|
|
1659 |
`primary_contact_method` varchar(45) DEFAULT NULL, -- useful for reporting purposes |
| 1658 |
UNIQUE KEY `cardnumber` (`cardnumber`), |
1660 |
UNIQUE KEY `cardnumber` (`cardnumber`), |
| 1659 |
PRIMARY KEY `borrowernumber` (`borrowernumber`), |
1661 |
PRIMARY KEY `borrowernumber` (`borrowernumber`), |
| 1660 |
KEY `categorycode` (`categorycode`), |
1662 |
KEY `categorycode` (`categorycode`), |
|
Lines 3425-3430
CREATE TABLE IF NOT EXISTS `borrower_modifications` (
Link Here
|
| 3425 |
`smsalertnumber` varchar(50) DEFAULT NULL, |
3427 |
`smsalertnumber` varchar(50) DEFAULT NULL, |
| 3426 |
`privacy` int(11) DEFAULT NULL, |
3428 |
`privacy` int(11) DEFAULT NULL, |
| 3427 |
`extended_attributes` text DEFAULT NULL, |
3429 |
`extended_attributes` text DEFAULT NULL, |
|
|
3430 |
`primary_contact_method` varchar(45) DEFAULT NULL, -- useful for reporting purposes |
| 3428 |
PRIMARY KEY (`verification_token`,`borrowernumber`), |
3431 |
PRIMARY KEY (`verification_token`,`borrowernumber`), |
| 3429 |
KEY `verification_token` (`verification_token`), |
3432 |
KEY `verification_token` (`verification_token`), |
| 3430 |
KEY `borrowernumber` (`borrowernumber`) |
3433 |
KEY `borrowernumber` (`borrowernumber`) |