InstaGov/schema/edit log field

About

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

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

<mysql>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;</mysql>