From 86d64812f2def990d01e1ff58883a530f064da95 Mon Sep 17 00:00:00 2001 From: Chris Cormack Date: Mon, 29 Oct 2007 13:22:59 -0500 Subject: [PATCH] Updating kohastructure.sql with tables needed for reports, updatedatabase still to come, but there are outstanding patches that need to be applied before I can do that. Signed-off-by: Chris Cormack Signed-off-by: Joshua Ferraro --- installer/kohastructure.sql | 34 ++++++++++++++++++++++++++++++++++ 1 file changed, 34 insertions(+) diff --git a/installer/kohastructure.sql b/installer/kohastructure.sql index 7bf96feb5a..7390e0164b 100644 --- a/installer/kohastructure.sql +++ b/installer/kohastructure.sql @@ -1372,6 +1372,40 @@ CREATE TABLE `roadtype` ( PRIMARY KEY (`roadtypeid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; +-- +-- Table structure for table `saved_sql` +-- + +DROP TABLE IF EXISTS `saved_sql`; +CREATE TABLE saved_sql ( + `id` int(11) NOT NULL auto_increment, + `borrowernumber` int(11) default NULL, + `date_created` datetime default NULL, + `last_modified` datetime default NULL, + `savedsql` text, + `last_run` datetime default NULL, + `report_name` varchar(255) default NULL, + `type` varchar(255) default NULL, + `notes` text, + PRIMARY KEY (`id`), + KEY boridx (`borrowernumber`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + + +-- +-- Table structure for `saved_reports` +-- + +DROP TABLE IF EXISTS `saved_reports`; +CREATE TABLE saved_reports ( + `id` int(11) NOT NULL auto_increment, + `report_id` int(11) default NULL, + `report` longtext, + `date_run` datetime default NULL, + PRIMARY KEY (`id`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + + -- -- Table structure for table `serial` -- -- 2.39.5