InstaGov/obsolete

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.

<section begin=sql /><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>

<section end=sql />