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 |
- |
|
|