Lines 3314-3320
CREATE TABLE `quotes` ( -- data for the quote of the day feature
Link Here
|
3314 |
`id` int(11) NOT NULL AUTO_INCREMENT, -- unique id for the quote |
3314 |
`id` int(11) NOT NULL AUTO_INCREMENT, -- unique id for the quote |
3315 |
`source` MEDIUMTEXT DEFAULT NULL, -- source/credit for the quote |
3315 |
`source` MEDIUMTEXT DEFAULT NULL, -- source/credit for the quote |
3316 |
`text` LONGTEXT NOT NULL, -- text of the quote |
3316 |
`text` LONGTEXT NOT NULL, -- text of the quote |
3317 |
`timestamp` datetime NOT NULL, -- date and time that the quote last appeared in the opac |
3317 |
`timestamp` datetime NULL, -- date and time that the quote last appeared in the opac |
3318 |
PRIMARY KEY (`id`) |
3318 |
PRIMARY KEY (`id`) |
3319 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
3319 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
3320 |
|
3320 |
|
3321 |
- |
|
|