[Koha-patches] [PATCH] 6094 Fixing ModAuthority problems -- db rev
Marcel de Rooy
M.de.Rooy at rijksmuseum.nl
Mon Jul 25 13:18:32 CEST 2011
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
More information about the Koha-patches
mailing list