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

(-)a/installer/data/mysql/kohastructure.sql (-31 lines)
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
- 

Return to bug 16735