Ferreteria/sql/event in table

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

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    INT(4)       DEFAULT NULL COMMENT "ID of row (if any) being modified by this event",
   PRIMARY KEY (`ID_Event`)
) ENGINE = InnoDB;</mysql>