Attachment 40489 Details for Bug 14435 – Bug 14435: Drop table saved_reports - DB Changes

[patch] Bug 14435: Drop table saved_reports - DB Changes

Bug-14435-Drop-table-savedreports---DB-Changes.patch (text/plain), 1.54 KB, created by Jonathan Druart on 2015-06-22 16:05:33 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Jonathan Druart

Created: 2015-06-22 16:05:33 UTC

Size: 1.54 KB

patch

obsolete

>From 899f986184b8ce67503c8d744f06be1f5033a34d Mon Sep 17 00:00:00 2001
>From: Jonathan Druart <jonathan.druart@koha-community.org>
>Date: Mon, 22 Jun 2015 18:00:03 +0200
>Subject: [PATCH] Bug 14435: Drop table saved_reports - DB Changes
>
>---
> .../atomicupdate/bug_14435_drop_table_saved_reports.sql    |  1 +
> installer/data/mysql/kohastructure.sql                     | 14 --------------
> 2 files changed, 1 insertion(+), 14 deletions(-)
> create mode 100644 installer/data/mysql/atomicupdate/bug_14435_drop_table_saved_reports.sql
>
>diff --git a/installer/data/mysql/atomicupdate/bug_14435_drop_table_saved_reports.sql b/installer/data/mysql/atomicupdate/bug_14435_drop_table_saved_reports.sql
>new file mode 100644
>index 0000000..5aea7d6
>--- /dev/null
>+++ b/installer/data/mysql/atomicupdate/bug_14435_drop_table_saved_reports.sql
>@@ -0,0 +1 @@
>+DROP TABLE IF EXISTS saved_reports;
>diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql
>index 9d6e2ce..d3486b3 100644
>--- a/installer/data/mysql/kohastructure.sql
>+++ b/installer/data/mysql/kohastructure.sql
>@@ -1911,20 +1911,6 @@ CREATE TABLE saved_sql ( -- saved sql reports
> 
> 
> --
>--- Table structure for `saved_reports`
>---
>-
>-DROP TABLE IF EXISTS `saved_reports`;
>-CREATE TABLE saved_reports (
>-   `id` int(11) NOT NULL auto_increment,
>-   `report_id` int(11) default NULL,
>-   `report` longtext,
>-   `date_run` datetime default NULL,
>-   PRIMARY KEY  (`id`)
>-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
>-
>-
>---
> -- Table structure for table `search_history`
> --
> 
>-- 
>2.1.0

Actions: View | Diff | Splinter Review

Attachments on bug 14435: 40488 | 40489 | 40753 | 40796 | 40797 | 40929 | 40930 | 42196 | 44767 | 44795 | 51987 | 55814