https://htyp.org/mw/index.php?action=history&feed=atom&title=InstaGov%2FobsoleteInstaGov/obsolete - Revision history2026-08-13T08:11:38ZRevision history for this page on the wikiMediaWiki 1.45.3https://htyp.org/mw/index.php?title=InstaGov/obsolete&diff=13878&oldid=prevWoozle: extracted from main page2010-07-20T13:45:12Z<p>extracted from main page</p>
<p><b>New page</b></p><div>===escalation===<br />
This looks like it has been superseded by the {{instagov|concepts|category}} system.<br />
<br />
* '''Purpose''': for escalating {{instagov|concepts|question|problem}}s; {{instagov|concepts|answer|solution}}s are escalated solely by their {{instagov|concepts|rating|approval rating}}s rather than via a separate mechanism.<br />
<br />
<section begin=sql /><mysql>CREATE TABLE `escalation` (<br />
`ID` INT NOT NULL AUTO_INCREMENT,<br />
`ID_User` INT NOT NULL,<br />
`ID_Problem INT NOT NULL,<br />
`ID_Topic INT DEFAULT NULL COMMENT "optional: this rating applies only within the given topic",<br />
`Rating` INT NOT NULL COMMENT "-10 to +10, or whatever range we end up using",<br />
`Remark` VARCHAR(255) COMMENT "comments on this rating (can include link or redirect)",<br />
PRIMARY KEY(`ID`)<br />
)<br />
ENGINE = MYISAM;</mysql><br />
<section end=sql /></div>Woozle