|
Lines 618-623
CREATE TABLE `deletedborrowers` ( -- stores data related to the patrons/borrower
Link Here
|
| 618 |
`sms_provider_id` int(11) DEFAULT NULL, -- the provider of the mobile phone number defined in smsalertnumber |
618 |
`sms_provider_id` int(11) DEFAULT NULL, -- the provider of the mobile phone number defined in smsalertnumber |
| 619 |
`privacy` integer(11) DEFAULT '1' NOT NULL, -- patron/borrower's privacy settings related to their reading history KEY `borrowernumber` (`borrowernumber`), |
619 |
`privacy` integer(11) DEFAULT '1' NOT NULL, -- patron/borrower's privacy settings related to their reading history KEY `borrowernumber` (`borrowernumber`), |
| 620 |
`privacy_guarantor_checkouts` tinyint(1) NOT NULL DEFAULT '0', -- controls if relatives can see this patron's checkouts |
620 |
`privacy_guarantor_checkouts` tinyint(1) NOT NULL DEFAULT '0', -- controls if relatives can see this patron's checkouts |
|
|
621 |
`timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, -- time of last change could be useful for synchronization with external systems (among others) |
| 621 |
KEY borrowernumber (borrowernumber), |
622 |
KEY borrowernumber (borrowernumber), |
| 622 |
KEY `cardnumber` (`cardnumber`), |
623 |
KEY `cardnumber` (`cardnumber`), |
| 623 |
KEY `sms_provider_id` (`sms_provider_id`) |
624 |
KEY `sms_provider_id` (`sms_provider_id`) |
|
Lines 1623-1628
CREATE TABLE `borrowers` ( -- this table includes information about your patrons
Link Here
|
| 1623 |
`sms_provider_id` int(11) DEFAULT NULL, -- the provider of the mobile phone number defined in smsalertnumber |
1624 |
`sms_provider_id` int(11) DEFAULT NULL, -- the provider of the mobile phone number defined in smsalertnumber |
| 1624 |
`privacy` integer(11) DEFAULT '1' NOT NULL, -- patron/borrower's privacy settings related to their reading history |
1625 |
`privacy` integer(11) DEFAULT '1' NOT NULL, -- patron/borrower's privacy settings related to their reading history |
| 1625 |
`privacy_guarantor_checkouts` tinyint(1) NOT NULL DEFAULT '0', -- controls if relatives can see this patron's checkouts |
1626 |
`privacy_guarantor_checkouts` tinyint(1) NOT NULL DEFAULT '0', -- controls if relatives can see this patron's checkouts |
|
|
1627 |
`timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, -- time of last change could be useful for synchronization with external systems (among others) |
| 1626 |
UNIQUE KEY `cardnumber` (`cardnumber`), |
1628 |
UNIQUE KEY `cardnumber` (`cardnumber`), |
| 1627 |
PRIMARY KEY `borrowernumber` (`borrowernumber`), |
1629 |
PRIMARY KEY `borrowernumber` (`borrowernumber`), |
| 1628 |
KEY `categorycode` (`categorycode`), |
1630 |
KEY `categorycode` (`categorycode`), |