View | Details | Raw Unified | Return to bug 16735
Collapse All | Expand All

(-)a/installer/data/mysql/kohastructure.sql (-31 lines)
Lines 227-247 CREATE TABLE IF NOT EXISTS `borrower_password_recovery` ( -- holds information a Link Here
227
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
227
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
228
228
229
--
229
--
230
-- Table structure for table `branchcategories`
231
--
232
233
DROP TABLE IF EXISTS `branchcategories`;
234
CREATE TABLE `branchcategories` ( -- information related to library/branch groups
235
  `categorycode` varchar(10) NOT NULL default '', -- unique identifier for the library/branch group
236
  `categoryname` varchar(32), -- name of the library/branch group
237
  `codedescription` mediumtext, -- longer description of the library/branch group
238
  `categorytype` varchar(16), -- says whether this is a search group or a properties group
239
  `show_in_pulldown` tinyint(1) NOT NULL DEFAULT '0', -- says this group should be in the opac libararies pulldown if it is enabled
240
  PRIMARY KEY  (`categorycode`),
241
  KEY `show_in_pulldown` (`show_in_pulldown`)
242
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
243
244
--
245
-- Table structure for table `branches`
230
-- Table structure for table `branches`
246
--
231
--
247
232
Lines 271-291 CREATE TABLE `branches` ( -- information about your libraries or branches are st Link Here
271
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
256
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
272
257
273
--
258
--
274
-- Table structure for table `branchrelations`
275
--
276
277
DROP TABLE IF EXISTS `branchrelations`;
278
CREATE TABLE `branchrelations` ( -- this table links libraries/branches to groups
279
  `branchcode` varchar(10) NOT NULL default '', -- foreign key from the branches table to identify the branch
280
  `categorycode` varchar(10) NOT NULL default '', -- foreign key from the branchcategories table to identify the group
281
  PRIMARY KEY  (`branchcode`,`categorycode`),
282
  KEY `branchcode` (`branchcode`),
283
  KEY `categorycode` (`categorycode`),
284
  CONSTRAINT `branchrelations_ibfk_1` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE,
285
  CONSTRAINT `branchrelations_ibfk_2` FOREIGN KEY (`categorycode`) REFERENCES `branchcategories` (`categorycode`) ON DELETE CASCADE ON UPDATE CASCADE
286
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
287
288
--
289
-- Table structure for table `browser`
259
-- Table structure for table `browser`
290
--
260
--
291
DROP TABLE IF EXISTS `browser`;
261
DROP TABLE IF EXISTS `browser`;
292
- 

Return to bug 16735