From 5fb875127cfa97c33068d5794187eebdf2123d3b Mon Sep 17 00:00:00 2001 From: "Nicole C. Engard" Date: Sun, 21 Aug 2011 09:01:01 -0400 Subject: [PATCH] Bug 6716: Documentation for the letter table This patch documents the letter/notices table in Koha. Signed-off-by: Chris Cormack --- installer/data/mysql/kohastructure.sql | 12 ++++++------ 1 file changed, 6 insertions(+), 6 deletions(-) diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index d0ebda9520..ed985e7408 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -1161,12 +1161,12 @@ CREATE TABLE `creator_templates` ( -- DROP TABLE IF EXISTS `letter`; -CREATE TABLE `letter` ( - `module` varchar(20) NOT NULL default '', - `code` varchar(20) NOT NULL default '', - `name` varchar(100) NOT NULL default '', - `title` varchar(200) NOT NULL default '', - `content` text, +CREATE TABLE `letter` ( -- table for all notice templates in Koha + `module` varchar(20) NOT NULL default '', -- Koha module that triggers this notice + `code` varchar(20) NOT NULL default '', -- unique identifier for this notice + `name` varchar(100) NOT NULL default '', -- plain text name for this notice + `title` varchar(200) NOT NULL default '', -- subject line of the notice + `content` text, -- body text for the notice PRIMARY KEY (`module`,`code`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- 2.39.2