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