Lines 262-267
CREATE TABLE `borrowers` ( -- this table includes information about your patrons
Link Here
|
262 |
`altcontactcountry` text default NULL, -- the country for the alternate contact for the patron/borrower |
262 |
`altcontactcountry` text default NULL, -- the country for the alternate contact for the patron/borrower |
263 |
`altcontactphone` varchar(50) default NULL, -- the phone number for the alternate contact for the patron/borrower |
263 |
`altcontactphone` varchar(50) default NULL, -- the phone number for the alternate contact for the patron/borrower |
264 |
`smsalertnumber` varchar(50) default NULL, -- the mobile phone number where the patron/borrower would like to receive notices (if SNS turned on) |
264 |
`smsalertnumber` varchar(50) default NULL, -- the mobile phone number where the patron/borrower would like to receive notices (if SNS turned on) |
|
|
265 |
`sms_provider_id` int(11) DEFAULT NULL, -- the provider of the mobile phone number defined in smsalertnumber |
265 |
`privacy` integer(11) DEFAULT '1' NOT NULL, -- patron/borrower's privacy settings related to their reading history |
266 |
`privacy` integer(11) DEFAULT '1' NOT NULL, -- patron/borrower's privacy settings related to their reading history |
266 |
UNIQUE KEY `cardnumber` (`cardnumber`), |
267 |
UNIQUE KEY `cardnumber` (`cardnumber`), |
267 |
PRIMARY KEY `borrowernumber` (`borrowernumber`), |
268 |
PRIMARY KEY `borrowernumber` (`borrowernumber`), |
Lines 269-276
CREATE TABLE `borrowers` ( -- this table includes information about your patrons
Link Here
|
269 |
KEY `branchcode` (`branchcode`), |
270 |
KEY `branchcode` (`branchcode`), |
270 |
KEY `userid` (`userid`), |
271 |
KEY `userid` (`userid`), |
271 |
KEY `guarantorid` (`guarantorid`), |
272 |
KEY `guarantorid` (`guarantorid`), |
|
|
273 |
KEY `sms_provider_id` (`sms_provider_id`) |
272 |
CONSTRAINT `borrowers_ibfk_1` FOREIGN KEY (`categorycode`) REFERENCES `categories` (`categorycode`), |
274 |
CONSTRAINT `borrowers_ibfk_1` FOREIGN KEY (`categorycode`) REFERENCES `categories` (`categorycode`), |
273 |
CONSTRAINT `borrowers_ibfk_2` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) |
275 |
CONSTRAINT `borrowers_ibfk_2` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`), |
|
|
276 |
CONSTRAINT `borrowers_ibfk_3` FOREIGN KEY (`sms_provider_id`) REFERENCES `sms_providers` (`id`) |
274 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
277 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
275 |
|
278 |
|
276 |
-- |
279 |
-- |
Lines 1817-1822
CREATE TABLE sessions (
Link Here
|
1817 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
1820 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
1818 |
|
1821 |
|
1819 |
-- |
1822 |
-- |
|
|
1823 |
-- Table structure for table `sms_providers` |
1824 |
-- |
1825 |
|
1826 |
DROP TABLE IF EXISTS sms_providers; |
1827 |
CREATE TABLE `sms_providers` ( |
1828 |
`id` int(11) NOT NULL AUTO_INCREMENT, |
1829 |
`name` varchar(255) NOT NULL, |
1830 |
`domain` varchar(255) NOT NULL, |
1831 |
PRIMARY KEY (`id`), |
1832 |
UNIQUE KEY `name` (`name`) |
1833 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
1834 |
|
1835 |
-- |
1820 |
-- Table structure for table `special_holidays` |
1836 |
-- Table structure for table `special_holidays` |
1821 |
-- |
1837 |
-- |
1822 |
|
1838 |
|