Lines 265-270
CREATE TABLE `borrowers` ( -- this table includes information about your patrons
Link Here
|
265 |
`altcontactphone` varchar(50) default NULL, -- the phone number for the alternate contact for the patron/borrower |
265 |
`altcontactphone` varchar(50) default NULL, -- the phone number for the alternate contact for the patron/borrower |
266 |
`smsalertnumber` varchar(50) default NULL, -- the mobile phone number where the patron/borrower would like to receive notices (if SNS turned on) |
266 |
`smsalertnumber` varchar(50) default NULL, -- the mobile phone number where the patron/borrower would like to receive notices (if SNS turned on) |
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 |
`contactprincipal` varchar(45) DEFAULT NULL, -- useful for reporting purposes |
268 |
UNIQUE KEY `cardnumber` (`cardnumber`), |
269 |
UNIQUE KEY `cardnumber` (`cardnumber`), |
269 |
PRIMARY KEY `borrowernumber` (`borrowernumber`), |
270 |
PRIMARY KEY `borrowernumber` (`borrowernumber`), |
270 |
KEY `categorycode` (`categorycode`), |
271 |
KEY `categorycode` (`categorycode`), |
Lines 2174-2183
CREATE TABLE `suggestions` ( -- purchase suggestions
Link Here
|
2174 |
branchcode VARCHAR(10) default NULL, -- foreign key linking the suggested branch to the branches table |
2175 |
branchcode VARCHAR(10) default NULL, -- foreign key linking the suggested branch to the branches table |
2175 |
collectiontitle text default NULL, -- collection name for the suggested item |
2176 |
collectiontitle text default NULL, -- collection name for the suggested item |
2176 |
itemtype VARCHAR(30) default NULL, -- suggested item type |
2177 |
itemtype VARCHAR(30) default NULL, -- suggested item type |
2177 |
quantity SMALLINT(6) default NULL, -- suggested quantity to be purchased |
2178 |
quantity SMALLINT(6) default NULL, -- suggested quantity to be purchased |
2178 |
currency VARCHAR(3) default NULL, -- suggested currency for the suggested price |
2179 |
currency VARCHAR(3) default NULL, -- suggested currency for the suggested price |
2179 |
price DECIMAL(28,6) default NULL, -- suggested price |
2180 |
price DECIMAL(28,6) default NULL, -- suggested price |
2180 |
total DECIMAL(28,6) default NULL, -- suggested total cost (price*quantity updated for currency) |
2181 |
total DECIMAL(28,6) default NULL, -- suggested total cost (price*quantity updated for currency) |
2181 |
PRIMARY KEY (`suggestionid`), |
2182 |
PRIMARY KEY (`suggestionid`), |
2182 |
KEY `suggestedby` (`suggestedby`), |
2183 |
KEY `suggestedby` (`suggestedby`), |
2183 |
KEY `managedby` (`managedby`) |
2184 |
KEY `managedby` (`managedby`) |
Lines 2475-2486
CREATE TABLE `permissions` (
Link Here
|
2475 |
|
2476 |
|
2476 |
DROP TABLE IF EXISTS `serialitems`; |
2477 |
DROP TABLE IF EXISTS `serialitems`; |
2477 |
CREATE TABLE `serialitems` ( |
2478 |
CREATE TABLE `serialitems` ( |
2478 |
`itemnumber` int(11) NOT NULL, |
2479 |
`itemnumber` int(11) NOT NULL, |
2479 |
`serialid` int(11) NOT NULL, |
2480 |
`serialid` int(11) NOT NULL, |
2480 |
UNIQUE KEY `serialitemsidx` (`itemnumber`), |
2481 |
UNIQUE KEY `serialitemsidx` (`itemnumber`), |
2481 |
KEY `serialitems_sfk_1` (`serialid`), |
2482 |
KEY `serialitems_sfk_1` (`serialid`), |
2482 |
CONSTRAINT `serialitems_sfk_1` FOREIGN KEY (`serialid`) REFERENCES `serial` (`serialid`) ON DELETE CASCADE ON UPDATE CASCADE, |
2483 |
CONSTRAINT `serialitems_sfk_1` FOREIGN KEY (`serialid`) REFERENCES `serial` (`serialid`) ON DELETE CASCADE ON UPDATE CASCADE, |
2483 |
CONSTRAINT `serialitems_sfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE |
2484 |
CONSTRAINT `serialitems_sfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE |
2484 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
2485 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
2485 |
|
2486 |
|
2486 |
-- |
2487 |
-- |
Lines 3461-3464
CREATE TABLE IF NOT EXISTS columns_settings (
Link Here
|
3461 |
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; |
3462 |
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; |
3462 |
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; |
3463 |
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; |
3463 |
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; |
3464 |
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; |
3464 |
|
|
|