Ferreteria/sql/event in table: Difference between revisions

From Woozle Writes Code
Jump to navigation Jump to search
(sql can go there too, dangit)
No edit summary
Line 3: Line 3:
* '''Depends on''': {{l/same|event}}
* '''Depends on''': {{l/same|event}}
==History==
==History==
* '''2017-05-06''' Adapting the good bits from [[VbzCart/tables/event log]]
* '''2017-02-06''' Adapting the good bits from [[VbzCart/tables/event log]]
==SQL==
==SQL==
<mysql>CREATE TABLE `event_in_table` (
<mysql>CREATE TABLE `event_in_table` (

Revision as of 22:48, 6 February 2017

About

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

History

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>
Retrieved from "https://wooz.dev/mw/index.php?title=Ferreteria/sql/event_in_table&oldid=1714"