Ferreteria/sql/event done: Difference between revisions
< Ferreteria | sql
Jump to navigation
Jump to search
(Created page with "==About== * '''Purpose''': dependent table for logging event completion * '''Depends on''': {{l/same|event}} ==History== * '''2017-05-06''' Adapting the good bits from VbzCa...") |
mNo edit summary |
||
| Line 3: | Line 3: | ||
* '''Depends on''': {{l/same|event}} | * '''Depends on''': {{l/same|event}} | ||
==History== | ==History== | ||
* '''2017- | * '''2017-02-06''' Adapting the good bits from [[VbzCart/tables/event log]] | ||
==SQL== | ==SQL== | ||
<mysql>CREATE TABLE `event_log` ( | <mysql>CREATE TABLE `event_log` ( | ||
Revision as of 22:48, 6 February 2017
About
- Purpose: dependent table for logging event completion
- Depends on: event
History
- 2017-02-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>