From be3f4ae1878bbd32c969f83a893b3bf33bf051a3 Mon Sep 17 00:00:00 2001 From: "Nicole C. Engard" Date: Thu, 8 Aug 2013 08:53:58 -0400 Subject: [PATCH] [SIGNED-OFF] Bug 10703: Document quotes table Add db documentation for the quotes table To test: apply patch review kohastructure.sql to be sure documentation is there Signed-off-by: Bernardo Gonzalez Kriegel --- installer/data/mysql/kohastructure.sql | 10 +++++----- 1 file changed, 5 insertions(+), 5 deletions(-) diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index eb565d0..a13a4b2 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -3059,11 +3059,11 @@ CREATE TABLE ratings ( -- information related to the star ratings in the OPAC -- DROP TABLE IF EXISTS quotes; -CREATE TABLE `quotes` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `source` text DEFAULT NULL, - `text` mediumtext NOT NULL, - `timestamp` datetime NOT NULL, +CREATE TABLE `quotes` ( -- data for the quote of the day feature + `id` int(11) NOT NULL AUTO_INCREMENT, -- unique id for the quote + `source` text DEFAULT NULL, -- source/credit for the quote + `text` mediumtext NOT NULL, -- text of the quote + `timestamp` datetime NOT NULL, -- date and time that the quote last appeared in the opac PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- 1.7.9.5