Ferreteria/sql/event done

About

• Purpose: dependent table for logging event completion
• Depends on: event

History

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

SQL

<mysql>CREATE TABLE `event_log` (

   ID_Event        INT NOT NULL COMMENT "event.ID of parent event",
   WhenFinish DATETIME NOT NULL COMMENT "when the event completed",
   Condition  INT  DEFAULT NULL COMMENT "condition code defined by application (success, error, etc.)",
   Descrip    TEXT DEFAULT NULL COMMENT "description of completion",
 PRIMARY KEY (`ID_Event`)

) ENGINE = InnoDB;</mysql>