From c590d8f882ac63edd9e441e0e1e9017dd62395d8 Mon Sep 17 00:00:00 2001 From: "Nicole C. Engard" Date: Fri, 26 Aug 2011 23:23:09 -0400 Subject: [PATCH] Bug 6716 - Documentation for the messages table This documents the messages table which stores info about the circulation messages. Signed-off-by: Chris Cormack --- installer/data/mysql/kohastructure.sql | 14 +++++++------- 1 file changed, 7 insertions(+), 7 deletions(-) diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index 922a0b147b..4d54beda39 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -2312,13 +2312,13 @@ CREATE TABLE `item_circulation_alert_preferences` ( -- Table structure for table `messages` -- DROP TABLE IF EXISTS `messages`; -CREATE TABLE `messages` ( - `message_id` int(11) NOT NULL auto_increment, - `borrowernumber` int(11) NOT NULL, - `branchcode` varchar(10) default NULL, - `message_type` varchar(1) NOT NULL, - `message` text NOT NULL, - `message_date` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, +CREATE TABLE `messages` ( -- circulation messages left via the patron's check out screen + `message_id` int(11) NOT NULL auto_increment, -- unique identifier assigned by Koha + `borrowernumber` int(11) NOT NULL, -- foreign key linking this message to the borrowers table + `branchcode` varchar(10) default NULL, -- foreign key linking the message to the branches table + `message_type` varchar(1) NOT NULL, -- whether the message is for the librarians (L) or the patron (B) + `message` text NOT NULL, -- the text of the message + `message_date` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, -- the date and time the message was written PRIMARY KEY (`message_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- 2.20.1