Ferreteria/sql/event in table

From Woozle Writes Code
< Ferreteria‎ | sql
Revision as of 23:53, 10 April 2017 by htyp>Woozle (changed TableRow to a string)
Jump to navigation Jump to search

About

  • Purpose: dependent table for logging table-related events
  • Depends on: event

History

  • 2017-02-06 Adapting the good bits from VbzCart/tables/event log
  • 2017-04-10 Realized that the row index (TableRow) could be a string. It will be a string in multikey tables even if the keys are integers.

SQL

<mysql>CREATE TABLE `event_in_table` (

   ID_Event    INT              NOT NULL COMMENT "event.ID of parent event",
   TableKey    VARCHAR(15)      NOT NULL COMMENT "action key of table affected",
   TableRow    VARCHAR(255) DEFAULT NULL COMMENT "ID of row (if any) being modified by this event",
   PRIMARY KEY (`ID_Event`)
) ENGINE = InnoDB;</mysql>