[Koha-patches] [PATCH] Bug 6716 - Define reports_dictionary table
Nicole C. Engard
nengard at bywatersolutions.com
Sat Aug 27 07:43:44 CEST 2011
This patch documents the reports_dictionary table.
---
installer/data/mysql/kohastructure.sql | 16 ++++++++--------
1 files changed, 8 insertions(+), 8 deletions(-)
diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql
index 13fa53d..7f83444 100644
--- a/installer/data/mysql/kohastructure.sql
+++ b/installer/data/mysql/kohastructure.sql
@@ -1509,14 +1509,14 @@ CREATE TABLE `repeatable_holidays` (
--
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;
--
1.7.2.3
More information about the Koha-patches
mailing list