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 1981-1986
CREATE TABLE sessions (
Link Here
|
1981 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
1984 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
1982 |
|
1985 |
|
1983 |
-- |
1986 |
-- |
|
|
1987 |
-- Table structure for table `sms_providers` |
1988 |
-- |
1989 |
|
1990 |
DROP TABLE IF EXISTS sms_providers; |
1991 |
CREATE TABLE `sms_providers` ( |
1992 |
`id` int(11) NOT NULL AUTO_INCREMENT, |
1993 |
`name` varchar(255) NOT NULL, |
1994 |
`domain` varchar(255) NOT NULL, |
1995 |
PRIMARY KEY (`id`), |
1996 |
UNIQUE KEY `name` (`name`) |
1997 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
1998 |
|
1999 |
-- |
1984 |
-- Table structure for table `special_holidays` |
2000 |
-- Table structure for table `special_holidays` |
1985 |
-- |
2001 |
-- |
1986 |
|
2002 |
|