From 87f60acf9afdecc28603b0a53005230c35afeb89 Mon Sep 17 00:00:00 2001 From: "Nicole C. Engard" Date: Sat, 27 Aug 2011 01:43:10 -0400 Subject: [PATCH] Bug 6716 - Define reports_dictionary table This patch documents the reports_dictionary table. Signed-off-by: Chris Cormack --- installer/data/mysql/kohastructure.sql | 16 ++++++++-------- 1 file changed, 8 insertions(+), 8 deletions(-) diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index 00f872f890..b31cd3ff7b 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -1513,14 +1513,14 @@ CREATE TABLE `repeatable_holidays` ( -- information for the days the library is -- 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, +CREATE TABLE reports_dictionary ( -- definitions (or snippets of SQL) stored for use in reports + `id` int(11) NOT NULL auto_increment, -- unique identifier assigned by Koha + `name` varchar(255) default NULL, -- name for this definition + `description` text, -- description for this definition + `date_created` datetime default NULL, -- date and time this definition was created + `date_modified` datetime default NULL, -- date and time this definition was last modified + `saved_sql` text, -- SQL snippet for us in reports + `area` int(11) default NULL, -- Koha module this definition is for (1 = Circulation, 2 = Catalog, 3 = Patrons, 4 = Acquistions, 5 = Accounts) PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- 2.39.2