|
Lines 263-268
CREATE TABLE `borrowers` ( -- this table includes information about your patrons
Link Here
|
| 263 |
`altcontactcountry` text default NULL, -- the country for the alternate contact for the patron/borrower |
263 |
`altcontactcountry` text default NULL, -- the country for the alternate contact for the patron/borrower |
| 264 |
`altcontactphone` varchar(50) default NULL, -- the phone number for the alternate contact for the patron/borrower |
264 |
`altcontactphone` varchar(50) default NULL, -- the phone number for the alternate contact for the patron/borrower |
| 265 |
`smsalertnumber` varchar(50) default NULL, -- the mobile phone number where the patron/borrower would like to receive notices (if SNS turned on) |
265 |
`smsalertnumber` varchar(50) default NULL, -- the mobile phone number where the patron/borrower would like to receive notices (if SNS turned on) |
|
|
266 |
`sms_provider_id` int(11) DEFAULT NULL, -- the provider of the mobile phone number defined in smsalertnumber |
| 266 |
`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 |
| 267 |
`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 |
| 268 |
UNIQUE KEY `cardnumber` (`cardnumber`), |
269 |
UNIQUE KEY `cardnumber` (`cardnumber`), |
|
Lines 274-281
CREATE TABLE `borrowers` ( -- this table includes information about your patrons
Link Here
|
| 274 |
KEY `surname_idx` (`surname`(255)), |
275 |
KEY `surname_idx` (`surname`(255)), |
| 275 |
KEY `firstname_idx` (`firstname`(255)), |
276 |
KEY `firstname_idx` (`firstname`(255)), |
| 276 |
KEY `othernames_idx` (`othernames`(255)), |
277 |
KEY `othernames_idx` (`othernames`(255)), |
|
|
278 |
KEY `sms_provider_id` (`sms_provider_id`), |
| 277 |
CONSTRAINT `borrowers_ibfk_1` FOREIGN KEY (`categorycode`) REFERENCES `categories` (`categorycode`), |
279 |
CONSTRAINT `borrowers_ibfk_1` FOREIGN KEY (`categorycode`) REFERENCES `categories` (`categorycode`), |
| 278 |
CONSTRAINT `borrowers_ibfk_2` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) |
280 |
CONSTRAINT `borrowers_ibfk_2` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) |
|
|
281 |
CONSTRAINT `borrowers_ibfk_3` FOREIGN KEY (`sms_provider_id`) REFERENCES `sms_providers` (`id`) |
| 279 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
282 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 280 |
|
283 |
|
| 281 |
-- |
284 |
-- |
|
Lines 1984-1989
CREATE TABLE sessions (
Link Here
|
| 1984 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
1987 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 1985 |
|
1988 |
|
| 1986 |
-- |
1989 |
-- |
|
|
1990 |
-- Table structure for table `sms_providers` |
| 1991 |
-- |
| 1992 |
|
| 1993 |
DROP TABLE IF EXISTS sms_providers; |
| 1994 |
CREATE TABLE `sms_providers` ( |
| 1995 |
`id` int(11) NOT NULL AUTO_INCREMENT, |
| 1996 |
`name` varchar(255) NOT NULL, |
| 1997 |
`domain` varchar(255) NOT NULL, |
| 1998 |
PRIMARY KEY (`id`), |
| 1999 |
UNIQUE KEY `name` (`name`) |
| 2000 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
| 2001 |
|
| 2002 |
-- |
| 1987 |
-- Table structure for table `special_holidays` |
2003 |
-- Table structure for table `special_holidays` |
| 1988 |
-- |
2004 |
-- |
| 1989 |
|
2005 |
|