Attachment 98449 Details for Bug 24156 – Bug 24156: DB changes

[patch] Bug 24156: DB changes

Bug-24156-DB-changes.patch (text/plain), 2.38 KB, created by Jonathan Druart on 2020-02-05 12:01:51 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Jonathan Druart

Created: 2020-02-05 12:01:51 UTC

Size: 2.38 KB

patch

obsolete

>From 34bb25965640fc878107b97885d9c00c699b173b Mon Sep 17 00:00:00 2001
>From: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
>Date: Thu, 5 Dec 2019 17:13:30 +0100
>Subject: [PATCH] Bug 24156: DB changes
>
>Add a new table tables_settings to store default_display_length and
>default_sort_order.
>---
> installer/data/mysql/atomicupdate/bug_24156.perl | 18 ++++++++++++++++++
> installer/data/mysql/kohastructure.sql           | 13 +++++++++++++
> 2 files changed, 31 insertions(+)
> create mode 100644 installer/data/mysql/atomicupdate/bug_24156.perl
>
>diff --git a/installer/data/mysql/atomicupdate/bug_24156.perl b/installer/data/mysql/atomicupdate/bug_24156.perl
>new file mode 100644
>index 0000000000..5bc0433397
>--- /dev/null
>+++ b/installer/data/mysql/atomicupdate/bug_24156.perl
>@@ -0,0 +1,18 @@
>+$DBversion = 'XXX'; # will be replaced by the RM
>+if( CheckVersion( $DBversion ) ) {
>+    unless ( TableExists( 'tables_settings' ) ) {
>+        $dbh->do(q|
>+            CREATE TABLE tables_settings (
>+                module varchar(255) NOT NULL,
>+                page varchar(255) NOT NULL,
>+                tablename varchar(255) NOT NULL,
>+                default_display_length smallint(6) NOT NULL DEFAULT 20,
>+                default_sort_order varchar(255),
>+                PRIMARY KEY(module (191), page (191), tablename (191) )
>+            ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
>+        |);
>+    }
>+
>+    SetVersion( $DBversion );
>+    print "Upgrade to $DBversion done (Bug 24156 - Add new table tables_settings)\n";
>+}
>diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql
>index f29a3c3b86..84876b55d5 100644
>--- a/installer/data/mysql/kohastructure.sql
>+++ b/installer/data/mysql/kohastructure.sql
>@@ -3621,6 +3621,19 @@ CREATE TABLE IF NOT EXISTS columns_settings (
> ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
> 
> --
>+-- Table structure for table `tables_settings`
>+--
>+
>+CREATE TABLE IF NOT EXISTS tables_settings (
>+    module varchar(255) NOT NULL,
>+    page varchar(255) NOT NULL,
>+    tablename varchar(255) NOT NULL,
>+    default_display_length smallint(6) NOT NULL DEFAULT 20 ,
>+    default_sort_order varchar(255),
>+    PRIMARY KEY(module (191), page (191), tablename (191) )
>+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
>+
>+--
> -- Table structure for table 'items_search_fields'
> --
> 
>-- 
>2.11.0

Actions: View | Diff | Splinter Review

Attachments on bug 24156: 96223 | 96224 | 96225 | 96226 | 96227 | 96228 | 96229 | 96230 | 98449 | 98450 | 98451 | 98452 | 98453 | 98454 | 98455 | 98456 | 98843 | 98844 | 98845 | 98846 | 98847 | 98848 | 99007 | 99008 | 99009 | 99010 | 99011 | 99012 | 99013 | 99014 | 105823 | 105824 | 105825 | 105826 | 105827 | 105828 | 105829 | 106183 | 106184 | 106185 | 106186 | 106187 | 106188 | 106189 | 106190 | 106191 | 106219 | 106220 | 106221 | 106222 | 106223 | 106224 | 106225 | 106226 | 106227 | 106228 | 106245