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

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

Return to bug 16735