InstaGov/obsolete
Jump to navigation
Jump to search
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>