Bugzilla – Attachment 5975 Details for
Bug 6094
Fixing ModAuthority problems
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Rebased db revision patch
patch.txt (text/plain), 2.14 KB, created by
Marcel de Rooy
on 2011-10-19 12:10:10 UTC
(
hide
)
Description:
Rebased db revision patch
Filename:
MIME Type:
Creator:
Marcel de Rooy
Created:
2011-10-19 12:10:10 UTC
Size:
2.14 KB
patch
obsolete
>From e902aeff4054871b2ed8c83f7e6f90a988987475 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] [REBASED] 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.) > >Oct 19, 2011: Rebased after functionality patch signoff. >--- > installer/data/mysql/kohastructure.sql | 11 +++++++++++ > installer/data/mysql/updatedatabase.pl | 6 ++++++ > 2 files changed, 17 insertions(+), 0 deletions(-) > >diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql >index c119ca1..e4388a4 100644 >--- a/installer/data/mysql/kohastructure.sql >+++ b/installer/data/mysql/kohastructure.sql >@@ -1311,6 +1311,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 e3309a2..1f37c18 100755 >--- a/installer/data/mysql/updatedatabase.pl >+++ b/installer/data/mysql/updatedatabase.pl >@@ -4523,6 +4523,12 @@ 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 > >-- >1.6.0.6 >
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 6094
:
3767
|
4733
|
4737
|
4738
|
4739
|
4833
|
5951
|
5975
|
5977
|
5979
|
6005