Ferreteria/sql/event

About

• Purpose: base table for logging application events
  • Records only the basic information common to all (or nearly all) events.

History

• 2017-05-06 Adapting the good bits from VbzCart/tables/event log

SQL

<mysql>CREATE TABLE `event` (

   ID         INT              NOT NULL AUTO_INCREMENT COMMENT "log line identifier",
   When       DATETIME     DEFAULT NULL COMMENT "set just before starting the event",
   ID_Session INT              NOT NULL COMMENT "session.ID of active session",
   Stash      BLOB         DEFAULT NULL COMMENT "additional event-related data that doesn't need to be searchable",
   Condition  INT          DEFAULT NULL COMMENT "condition code defined by application (success, error, etc.)",
   PRIMARY KEY (`ID`)
) ENGINE = InnoDB;</mysql>