InstaGov/schema/edit log field

About

 * Purpose: logs changes to individual fields (one field per record)
 * Depends on:

History

 * 2013-01-06 Corrected primary key

Fields

 * ModField: name of field whose modification is being recorded; same note applies as for Table
 * ValOld: the value before the edit
 * ValNew: the value after the edit

SQL
CREATE TABLE `edit_log_field` (  `ID_Event` INT              NOT NULL COMMENT "ID from edit_log",   `ModField` VARCHAR(15)      NOT NULL COMMENT "name of field being modified",   `ValOld`   VARCHAR(255)     NOT NULL COMMENT "value before edit",   `ValNew`   VARCHAR(255)     NOT NULL COMMENT "value after edit",  PRIMARY KEY(`ID_Event`,`ModField`) ) ENGINE = MYISAM;