From 6f7efca7e1e4070e402e53322fea823e564f5a00 Mon Sep 17 00:00:00 2001 From: Paul POULAIN Date: Tue, 2 Oct 2007 11:33:17 +0200 Subject: [PATCH] BUGFIX for browser and nozebra tables - adding browser and nozebra table definition to kohastructure & updatedatabase - bumping to 3.00.00.005 Signed-off-by: Chris Cormack --- installer/kohastructure.sql | 25 ++++++++++++++++++++++++ misc/cronjobs/build_browser_and_cloud.pl | 4 ---- misc/migration_tools/rebuild_nozebra.pl | 8 -------- updater/updatedatabase | 20 +++++++++++++++++++ 4 files changed, 45 insertions(+), 12 deletions(-) diff --git a/installer/kohastructure.sql b/installer/kohastructure.sql index cd83c0598c..82449f7686 100644 --- a/installer/kohastructure.sql +++ b/installer/kohastructure.sql @@ -547,6 +547,19 @@ CREATE TABLE `branchtransfers` ( CONSTRAINT `branchtransfers_ibfk_3` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- +-- Table structure for table `browser` +-- +DROP TABLE IF EXISTS `browser`; +CREATE TABLE `browser` ( + `level` int(11) NOT NULL, + `classification` varchar(20) NOT NULL, + `description` varchar(255) NOT NULL, + `number` bigint(20) NOT NULL, + `endnode` tinyint(4) NOT NULL +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + -- -- Table structure for table `categories` -- @@ -1077,6 +1090,18 @@ CREATE TABLE `notifys` ( `method` varchar(20) NOT NULL default '' ) ENGINE=InnoDB DEFAULT CHARSET=utf8; +-- +-- Table structure for table `nozebra` +-- +CREATE TABLE `nozebra` ( + `server` varchar(20) NOT NULL, + `indexname` varchar(40) NOT NULL, + `value` varchar(250) NOT NULL, + `biblionumbers` longtext NOT NULL, + KEY `indexname` (`server`,`indexname`), + KEY `value` (`server`,`value`)) + ENGINE=InnoDB DEFAULT CHARSET=utf8; + -- -- Table structure for table `opac_news` -- diff --git a/misc/cronjobs/build_browser_and_cloud.pl b/misc/cronjobs/build_browser_and_cloud.pl index dea5318f2e..ecce40e7e4 100755 --- a/misc/cronjobs/build_browser_and_cloud.pl +++ b/misc/cronjobs/build_browser_and_cloud.pl @@ -121,10 +121,6 @@ if ($browser_tag) { if (C4::Context->preference('opaclanguages') eq 'fr' && $browser_tag eq '676' & $browser_subfield eq 'a') { $classification = dewey_french(); } - $classification = dewey_french(); - # calculate end node... - #use Data::Dumper; - #warn "==>".Dumper(%browser_result); foreach (keys %browser_result) { my $father = substr($_,0,-1); $browser_result{$father}->{notendnode}=1; diff --git a/misc/migration_tools/rebuild_nozebra.pl b/misc/migration_tools/rebuild_nozebra.pl index 43a6e5a347..d88f9916d1 100755 --- a/misc/migration_tools/rebuild_nozebra.pl +++ b/misc/migration_tools/rebuild_nozebra.pl @@ -33,14 +33,6 @@ GetOptions( $directory = "export" unless $directory; my $dbh=C4::Context->dbh; $dbh->do("update systempreferences set value=1 where variable='NoZebra'"); -$dbh->do("CREATE TABLE `nozebra` ( - `server` varchar(20) NOT NULL, - `indexname` varchar(40) NOT NULL, - `value` varchar(250) NOT NULL, - `biblionumbers` longtext NOT NULL, - KEY `indexname` (`server`,`indexname`), - KEY `value` (`server`,`value`)) - ENGINE=InnoDB DEFAULT CHARSET=utf8"); $dbh->do("truncate nozebra"); diff --git a/updater/updatedatabase b/updater/updatedatabase index 6d3a75e774..aa7ecd8c90 100755 --- a/updater/updatedatabase +++ b/updater/updatedatabase @@ -2216,6 +2216,26 @@ if (C4::Context->preference("Version") < TransformToNum($DBversion)) { SetVersion ($DBversion); } +$DBversion = "3.00.00.005"; +if (C4::Context->preference("Version") < TransformToNum($DBversion)) { + $dbh->do("CREATE TABLE `tags` ( + `entry` varchar(255) NOT NULL default '', + `weight` bigint(20) NOT NULL default 0, + PRIMARY KEY (`entry`) + ) ENGINE=InnoDB DEFAULT CHARSET=utf8; + "); + $dbh->do("CREATE TABLE `nozebra` ( + `server` varchar(20) NOT NULL, + `indexname` varchar(40) NOT NULL, + `value` varchar(250) NOT NULL, + `biblionumbers` longtext NOT NULL, + KEY `indexname` (`server`,`indexname`), + KEY `value` (`server`,`value`)) + ENGINE=InnoDB DEFAULT CHARSET=utf8; + "); + print "Upgrade to $DBversion done (adding tags and nozebra tables )\n"; + SetVersion ($DBversion); +} =item DropAllForeignKeys($table) -- 2.20.1