Ferreteria/sql/event in table
- Purpose: dependent table for logging table-related events
- Depends on: event
- 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.
<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>