From d387ee8085e1304a4e205696891cac39a982472a Mon Sep 17 00:00:00 2001 From: Kyle M Hall Date: Thu, 23 Jun 2016 11:44:15 +0000 Subject: [PATCH] [SIGNED-OFF] Bug 16735 - Remove tables no longer needed Signed-off-by: Josef Moravec --- installer/data/mysql/kohastructure.sql | 30 ------------------------------ 1 file changed, 30 deletions(-) diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index b16f750..123927b 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -238,21 +238,6 @@ CREATE TABLE IF NOT EXISTS `borrower_password_recovery` ( -- holds information a ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- --- Table structure for table `branchcategories` --- - -DROP TABLE IF EXISTS `branchcategories`; -CREATE TABLE `branchcategories` ( -- information related to library/branch groups - `categorycode` varchar(10) NOT NULL default '', -- unique identifier for the library/branch group - `categoryname` varchar(32), -- name of the library/branch group - `codedescription` mediumtext, -- longer description of the library/branch group - `categorytype` varchar(16), -- says whether this is a search group or a properties group - `show_in_pulldown` tinyint(1) NOT NULL DEFAULT '0', -- says this group should be in the opac libararies pulldown if it is enabled - PRIMARY KEY (`categorycode`), - KEY `show_in_pulldown` (`show_in_pulldown`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; - --- -- Table structure for table `branches` -- @@ -282,21 +267,6 @@ CREATE TABLE `branches` ( -- information about your libraries or branches are st ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- --- Table structure for table `branchrelations` --- - -DROP TABLE IF EXISTS `branchrelations`; -CREATE TABLE `branchrelations` ( -- this table links libraries/branches to groups - `branchcode` varchar(10) NOT NULL default '', -- foreign key from the branches table to identify the branch - `categorycode` varchar(10) NOT NULL default '', -- foreign key from the branchcategories table to identify the group - PRIMARY KEY (`branchcode`,`categorycode`), - KEY `branchcode` (`branchcode`), - KEY `categorycode` (`categorycode`), - CONSTRAINT `branchrelations_ibfk_1` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE, - CONSTRAINT `branchrelations_ibfk_2` FOREIGN KEY (`categorycode`) REFERENCES `branchcategories` (`categorycode`) ON DELETE CASCADE ON UPDATE CASCADE -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; - --- -- Table structure for table `browser` -- DROP TABLE IF EXISTS `browser`; -- 2.1.4