Lines 5185-5190
CREATE TABLE `suggestions` (
Link Here
|
5185 |
`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)', |
5185 |
`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)', |
5186 |
`archived` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'is the suggestion archived?', |
5186 |
`archived` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'is the suggestion archived?', |
5187 |
`note` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'note entered on the suggestion', |
5187 |
`note` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'note entered on the suggestion', |
|
|
5188 |
`privatenote` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'non-public note entered on the suggestion', |
5188 |
`author` varchar(80) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'author of the suggested item', |
5189 |
`author` varchar(80) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'author of the suggested item', |
5189 |
`title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'title of the suggested item', |
5190 |
`title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'title of the suggested item', |
5190 |
`copyrightdate` smallint(6) DEFAULT NULL COMMENT 'copyright date of the suggested item', |
5191 |
`copyrightdate` smallint(6) DEFAULT NULL COMMENT 'copyright date of the suggested item', |
5191 |
- |
|
|