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

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

Return to bug 16735