From 006d23586d2feeff0643a07f7f2bac8702b5be8a Mon Sep 17 00:00:00 2001 From: Kyle M Hall Date: Thu, 23 Jun 2016 11:44:15 +0000 Subject: [PATCH] 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 4d8a4f0..72e5a2e 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -237,21 +237,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` -- @@ -281,21 +266,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