Attachment 4737 Details for Bug 6094 – Db revision patch

[patch] Db revision patch

patch.txt (text/plain), 2.11 KB, created by Marcel de Rooy on 2011-07-25 11:14:40 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Marcel de Rooy

Created: 2011-07-25 11:14:40 UTC

Size: 2.11 KB

patch

obsolete

>From 134a7b5014c0e7235d28d8a131fe1a1da5a3b25b Mon Sep 17 00:00:00 2001
>From: Marcel de Rooy <m.de.rooy@rijksmuseum.nl>
>Date: Mon, 25 Jul 2011 11:33:23 +0200
>Subject: [PATCH] 6094 Fixing ModAuthority problems
>Content-Type: text/plain; charset="utf-8"
>
>Only contains db revision to insert new table need_merge_authorities.
>You can apply the revision by running cgi-bin/koha/installer/install.pl?step=3&op=updatestructure. (Will not change your version while testing.)
>---
> installer/data/mysql/kohastructure.sql |   11 +++++++++++
> installer/data/mysql/updatedatabase.pl |    7 +++++++
> 2 files changed, 18 insertions(+), 0 deletions(-)
>
>diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql
>index e3c6f42..ad3cdd4 100644
>--- a/installer/data/mysql/kohastructure.sql
>+++ b/installer/data/mysql/kohastructure.sql
>@@ -1303,6 +1303,17 @@ CREATE TABLE `matchchecks` (
> ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
> 
> --
>+-- Table structure for table `need_merge_authorities`
>+--
>+
>+DROP TABLE IF EXISTS `need_merge_authorities`;
>+CREATE TABLE `need_merge_authorities` (
>+  `id` int NOT NULL auto_increment PRIMARY KEY,
>+  `authid` bigint NOT NULL,
>+  `done` tinyint DEFAULT 0
>+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
>+
>+--
> -- Table structure for table `notifys`
> --
> 
>diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl
>index 9cbc8db..44cd21e 100755
>--- a/installer/data/mysql/updatedatabase.pl
>+++ b/installer/data/mysql/updatedatabase.pl
>@@ -4370,6 +4370,13 @@ if (C4::Context->preference("Version") < TransformToNum($DBversion)) {
>     SetVersion($DBversion);
> }
> 
>+$DBversion = "3.05.00.XXX"; #RM: Please remove 1 from if and uncomment SetVersion too!!
>+if (1||C4::Context->preference("Version") < TransformToNum($DBversion)) {
>+    $dbh->do("CREATE TABLE need_merge_authorities (id int NOT NULL auto_increment PRIMARY KEY, authid bigint NOT NULL, done tinyint DEFAULT 0) ENGINE=InnoDB DEFAULT CHARSET=utf8");
>+    print "Upgrade to $DBversion done (6094: Fixing ModAuthority problems)\n";
>+    #SetVersion($DBversion);
>+}
>+
> =head1 FUNCTIONS
> 
> =head2 DropAllForeignKeys($table)
>-- 
>1.6.0.6
>

Actions: View | Diff | Splinter Review

Attachments on bug 6094: 3767 | 4733 | 4737 | 4738 | 4739 | 4833 | 5951 | 5975 | 5977 | 5979 | 6005