Ferreteria/sql/event: Difference between revisions
< Ferreteria | sql
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| Line 3: | Line 3: | ||
** Records only the basic information common to all (or nearly all) events. | ** Records only the basic information common to all (or nearly all) events. | ||
==History== | ==History== | ||
* '''2017- | * '''2017-02-06''' Adapting the good bits from [[VbzCart/tables/event log]] | ||
==SQL== | ==SQL== | ||
<mysql>CREATE TABLE `event` ( | <mysql>CREATE TABLE `event` ( | ||
ID INT NOT NULL AUTO_INCREMENT COMMENT "log line identifier", | ID INT NOT NULL AUTO_INCREMENT COMMENT "log line identifier", | ||
WhenStart DATETIME NOT NULL COMMENT "set just before starting the event", | WhenStart DATETIME NOT NULL COMMENT "set just before starting the event", | ||
ID_Session INT | ID_Session INT DEFAULT NULL COMMENT "session.ID of active session", | ||
TypeCode VARCHAR(7) DEFAULT NULL COMMENT "mnemonic event code", | TypeCode VARCHAR(7) DEFAULT NULL COMMENT "mnemonic event code", | ||
Descrip TEXT DEFAULT NULL COMMENT "code-generated description of event", | Descrip TEXT DEFAULT NULL COMMENT "code-generated description of event", | ||
Revision as of 22:48, 6 February 2017
About
- Purpose: base table for logging application events
- Records only the basic information common to all (or nearly all) events.
History
- 2017-02-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", WhenStart DATETIME NOT NULL COMMENT "set just before starting the event", ID_Session INT DEFAULT NULL COMMENT "session.ID of active session", TypeCode VARCHAR(7) DEFAULT NULL COMMENT "mnemonic event code", Descrip TEXT DEFAULT NULL COMMENT "code-generated description of event", Stash TEXT DEFAULT NULL COMMENT "additional event-related data that doesn't need to be searchable", PRIMARY KEY (`ID`) ) ENGINE = InnoDB;</mysql>