Lines 5174-5179
CREATE TABLE `suggestions` (
Link Here
|
5174 |
`STATUS` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'suggestion status (ASKED, CHECKED, ACCEPTED, REJECTED, ORDERED, AVAILABLE or a value from the SUGGEST_STATUS authorised value category)', |
5174 |
`STATUS` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'suggestion status (ASKED, CHECKED, ACCEPTED, REJECTED, ORDERED, AVAILABLE or a value from the SUGGEST_STATUS authorised value category)', |
5175 |
`archived` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'is the suggestion archived?', |
5175 |
`archived` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'is the suggestion archived?', |
5176 |
`note` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'note entered on the suggestion', |
5176 |
`note` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'note entered on the suggestion', |
|
|
5177 |
`privatenote` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'non-public note entered on the suggestion', |
5177 |
`author` varchar(80) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'author of the suggested item', |
5178 |
`author` varchar(80) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'author of the suggested item', |
5178 |
`title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'title of the suggested item', |
5179 |
`title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'title of the suggested item', |
5179 |
`copyrightdate` smallint(6) DEFAULT NULL COMMENT 'copyright date of the suggested item', |
5180 |
`copyrightdate` smallint(6) DEFAULT NULL COMMENT 'copyright date of the suggested item', |
5180 |
- |
|
|