Attachment 60773 Details for Bug 16735 – Bug 16735 - Remove tables no longer needed

[patch] Bug 16735 - Remove tables no longer needed

Bug-16735---Remove-tables-no-longer-needed.patch (text/plain), 2.71 KB, created by Kyle M Hall (khall) on 2017-03-01 14:08:34 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Kyle M Hall (khall)

Created: 2017-03-01 14:08:34 UTC

Size: 2.71 KB

patch

obsolete

>From a13971c8beddc7eef30eaec63dc806ed664d6921 Mon Sep 17 00:00:00 2001
>From: Kyle M Hall <kyle@bywatersolutions.com>
>Date: Thu, 23 Jun 2016 11:44:15 +0000
>Subject: [PATCH] Bug 16735 - Remove tables no longer needed
>
>Signed-off-by: Josef Moravec <josef.moravec@gmail.com>
>---
> 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 57bf2d5..3cb9c1d 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

Actions: View | Diff | Splinter Review

Attachments on bug 16735: 52732 | 52733 | 52734 | 52735 | 57098 | 57099 | 57100 | 57101 | 58087 | 58088 | 58089 | 58090 | 60497 | 60498 | 60499 | 60500 | 60501 | 60502 | 60503 | 60772 | 60773 | 60774 | 60775 | 60776 | 60777 | 60778 | 60779 | 65658 | 65659 | 65660 | 65661 | 65662 | 65663 | 65664 | 65665 | 69533 | 69534 | 69535 | 69536 | 69537 | 69538 | 69539 | 69540 | 69541 | 69684 | 69685 | 69686 | 69687 | 69688 | 69689 | 69690 | 69691 | 69692 | 69693 | 69694 | 71386 | 71393