InstaGov/obsolete

escalation
This looks like it has been superseded by the system.


 * Purpose: for escalating s; s are escalated solely by their s rather than via a separate mechanism.

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;