Lines 237-257
CREATE TABLE IF NOT EXISTS `borrower_password_recovery` ( -- holds information a
Link Here
|
237 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
237 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
238 |
|
238 |
|
239 |
-- |
239 |
-- |
240 |
-- Table structure for table `branchcategories` |
|
|
241 |
-- |
242 |
|
243 |
DROP TABLE IF EXISTS `branchcategories`; |
244 |
CREATE TABLE `branchcategories` ( -- information related to library/branch groups |
245 |
`categorycode` varchar(10) NOT NULL default '', -- unique identifier for the library/branch group |
246 |
`categoryname` varchar(32), -- name of the library/branch group |
247 |
`codedescription` mediumtext, -- longer description of the library/branch group |
248 |
`categorytype` varchar(16), -- says whether this is a search group or a properties group |
249 |
`show_in_pulldown` tinyint(1) NOT NULL DEFAULT '0', -- says this group should be in the opac libararies pulldown if it is enabled |
250 |
PRIMARY KEY (`categorycode`), |
251 |
KEY `show_in_pulldown` (`show_in_pulldown`) |
252 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
253 |
|
254 |
-- |
255 |
-- Table structure for table `branches` |
240 |
-- Table structure for table `branches` |
256 |
-- |
241 |
-- |
257 |
|
242 |
|
Lines 281-301
CREATE TABLE `branches` ( -- information about your libraries or branches are st
Link Here
|
281 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
266 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
282 |
|
267 |
|
283 |
-- |
268 |
-- |
284 |
-- Table structure for table `branchrelations` |
|
|
285 |
-- |
286 |
|
287 |
DROP TABLE IF EXISTS `branchrelations`; |
288 |
CREATE TABLE `branchrelations` ( -- this table links libraries/branches to groups |
289 |
`branchcode` varchar(10) NOT NULL default '', -- foreign key from the branches table to identify the branch |
290 |
`categorycode` varchar(10) NOT NULL default '', -- foreign key from the branchcategories table to identify the group |
291 |
PRIMARY KEY (`branchcode`,`categorycode`), |
292 |
KEY `branchcode` (`branchcode`), |
293 |
KEY `categorycode` (`categorycode`), |
294 |
CONSTRAINT `branchrelations_ibfk_1` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE, |
295 |
CONSTRAINT `branchrelations_ibfk_2` FOREIGN KEY (`categorycode`) REFERENCES `branchcategories` (`categorycode`) ON DELETE CASCADE ON UPDATE CASCADE |
296 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
297 |
|
298 |
-- |
299 |
-- Table structure for table `browser` |
269 |
-- Table structure for table `browser` |
300 |
-- |
270 |
-- |
301 |
DROP TABLE IF EXISTS `browser`; |
271 |
DROP TABLE IF EXISTS `browser`; |
302 |
- |
|
|