InstaGov/obsolete
< InstaGov
Jump to navigation
Jump to search
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.
escalation
This looks like it has been superseded by the category system.
- Purpose: for escalating problems; solutions are escalated solely by their approval ratings rather than via a separate mechanism.
<mysql>CREATE TABLE `escalation` (
`ID` INT NOT NULL AUTO_INCREMENT, `ID_User` INT NOT NULL, `ID_Problem INT NOT NULL, `ID_Topic INT DEFAULT NULL COMMENT "optional: this rating applies only within the given topic", `Rating` INT NOT NULL COMMENT "-10 to +10, or whatever range we end up using", `Remark` VARCHAR(255) COMMENT "comments on this rating (can include link or redirect)", PRIMARY KEY(`ID`) ) ENGINE = MYISAM;</mysql>