From 0f429f0b316191c55e427ea699cd9f25f00ebdb3 Mon Sep 17 00:00:00 2001 From: Chris Cormack Date: Tue, 30 Oct 2007 13:20:20 -0500 Subject: [PATCH] Adding reports_dictionary table Signed-off-by: Chris Cormack Signed-off-by: Joshua Ferraro --- installer/kohastructure.sql | 16 ++++++++++++++++ kohaversion.pl | 2 +- updater/updatedatabase | 17 +++++++++++++++++ 3 files changed, 34 insertions(+), 1 deletion(-) diff --git a/installer/kohastructure.sql b/installer/kohastructure.sql index c20495de1c..5bbf29a33f 100644 --- a/installer/kohastructure.sql +++ b/installer/kohastructure.sql @@ -1283,6 +1283,22 @@ CREATE TABLE `repeatable_holidays` ( PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; +-- +-- Table structure for table `reports_dictionary` +-- + +DROP TABLE IF EXISTS `reports_dictionary` +CREATE TABLE reports_dictionary ( + `id` int(11) NOT NULL auto_increment, + `name` varchar(255) default NULL, + `description` text, + `date_created` datetime default NULL, + `date_modified` datetime default NULL, + `saved_sql` text, + `area` int(11) default NULL, + PRIMARY KEY (`id`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + -- -- Table structure for table `reserveconstraints` -- diff --git a/kohaversion.pl b/kohaversion.pl index 316732275a..b4abdda92d 100644 --- a/kohaversion.pl +++ b/kohaversion.pl @@ -8,7 +8,7 @@ # and is automatically called by Auth.pm when needed. sub kohaversion { - return "3.00.00.015"; + return "3.00.00.016"; } 1; diff --git a/updater/updatedatabase b/updater/updatedatabase index 74d4553b66..d9c22346e2 100755 --- a/updater/updatedatabase +++ b/updater/updatedatabase @@ -487,6 +487,23 @@ if (C4::Context->preference("Version") < TransformToNum($DBversion)) { SetVersion ($DBversion); } +$DBversion = "3.00.00.016"; +if (C4::Context->preference("Version") < TransformToNum($DBversion)) { + $dbh->do(" CREATE TABLE reports_dictionary ( + id int(11) NOT NULL auto_increment, + name varchar(255) default NULL, + description text, + date_created datetime default NULL, + date_modified datetime default NULL, + saved_sql text, + area int(11) default NULL, + PRIMARY KEY (id) + ) ENGINE=InnoDB DEFAULT CHARSET=utf8 "); + print "Upgrade to $DBversion done (reports_dictionary) added)\n"; + SetVersion ($DBversion); +} + + =item DropAllForeignKeys($table) Drop all foreign keys of the table $table -- 2.39.2