|
Lines 266-271
CREATE TABLE `borrowers` ( -- this table includes information about your patrons
Link Here
|
| 266 |
`sms_provider_id` int(11) DEFAULT NULL, -- the provider of the mobile phone number defined in smsalertnumber |
266 |
`sms_provider_id` int(11) DEFAULT NULL, -- the provider of the mobile phone number defined in smsalertnumber |
| 267 |
`privacy` integer(11) DEFAULT '1' NOT NULL, -- patron/borrower's privacy settings related to their reading history |
267 |
`privacy` integer(11) DEFAULT '1' NOT NULL, -- patron/borrower's privacy settings related to their reading history |
| 268 |
`privacy_guarantor_checkouts` tinyint(1) NOT NULL DEFAULT '0', -- controls if relatives can see this patron's checkouts |
268 |
`privacy_guarantor_checkouts` tinyint(1) NOT NULL DEFAULT '0', -- controls if relatives can see this patron's checkouts |
|
|
269 |
`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) |
| 269 |
UNIQUE KEY `cardnumber` (`cardnumber`), |
270 |
UNIQUE KEY `cardnumber` (`cardnumber`), |
| 270 |
PRIMARY KEY `borrowernumber` (`borrowernumber`), |
271 |
PRIMARY KEY `borrowernumber` (`borrowernumber`), |
| 271 |
KEY `categorycode` (`categorycode`), |
272 |
KEY `categorycode` (`categorycode`), |
|
Lines 918-923
CREATE TABLE `deletedborrowers` ( -- stores data related to the patrons/borrower
Link Here
|
| 918 |
`sms_provider_id` int(11) DEFAULT NULL, -- the provider of the mobile phone number defined in smsalertnumber |
919 |
`sms_provider_id` int(11) DEFAULT NULL, -- the provider of the mobile phone number defined in smsalertnumber |
| 919 |
`privacy` integer(11) DEFAULT '1' NOT NULL, -- patron/borrower's privacy settings related to their reading history KEY `borrowernumber` (`borrowernumber`), |
920 |
`privacy` integer(11) DEFAULT '1' NOT NULL, -- patron/borrower's privacy settings related to their reading history KEY `borrowernumber` (`borrowernumber`), |
| 920 |
`privacy_guarantor_checkouts` tinyint(1) NOT NULL DEFAULT '0', -- controls if relatives can see this patron's checkouts |
921 |
`privacy_guarantor_checkouts` tinyint(1) NOT NULL DEFAULT '0', -- controls if relatives can see this patron's checkouts |
|
|
922 |
`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) |
| 921 |
KEY borrowernumber (borrowernumber), |
923 |
KEY borrowernumber (borrowernumber), |
| 922 |
KEY `cardnumber` (`cardnumber`), |
924 |
KEY `cardnumber` (`cardnumber`), |
| 923 |
KEY `sms_provider_id` (`sms_provider_id`) |
925 |
KEY `sms_provider_id` (`sms_provider_id`) |