@@ -, +, @@ --- installer/data/mysql/kohastructure.sql | 11 +++++++++++ installer/data/mysql/updatedatabase.pl | 7 +++++++ 2 files changed, 18 insertions(+), 0 deletions(-) --- a/installer/data/mysql/kohastructure.sql +++ a/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` -- --- a/installer/data/mysql/updatedatabase.pl +++ a/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) --