View | Details | Raw Unified | Return to bug 10703
Collapse All | Expand All

(-)a/installer/data/mysql/kohastructure.sql (-6 / +5 lines)
Lines 3059-3069 CREATE TABLE ratings ( -- information related to the star ratings in the OPAC Link Here
3059
--
3059
--
3060
3060
3061
DROP TABLE IF EXISTS quotes;
3061
DROP TABLE IF EXISTS quotes;
3062
CREATE TABLE `quotes` (
3062
CREATE TABLE `quotes` ( -- data for the quote of the day feature
3063
  `id` int(11) NOT NULL AUTO_INCREMENT,
3063
  `id` int(11) NOT NULL AUTO_INCREMENT, -- unique id for the quote
3064
  `source` text DEFAULT NULL,
3064
  `source` text DEFAULT NULL, -- source/credit for the quote
3065
  `text` mediumtext NOT NULL,
3065
  `text` mediumtext NOT NULL, -- text of the quote
3066
  `timestamp` datetime NOT NULL,
3066
  `timestamp` datetime NOT NULL, -- date and time that the quote last appeared in the opac
3067
  PRIMARY KEY (`id`)
3067
  PRIMARY KEY (`id`)
3068
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
3068
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
3069
3069
3070
- 

Return to bug 10703