Ferreteria/sql/event: Difference between revisions
< Ferreteria | sql
Jump to navigation
Jump to search
No edit summary |
(note about eventual archiving) |
||
| Line 2: | Line 2: | ||
* '''Purpose''': base table for logging application events | * '''Purpose''': base table for logging application events | ||
** Records only the basic information common to all (or nearly all) events. | ** Records only the basic information common to all (or nearly all) events. | ||
* '''Future''': Eventually we will probably want to archive session records, so there should be an archive version of this table which directly stores at least the User ID and maybe IP address and browser. Events whose sessions are being archived would be migrated to that table as part of the same process. | |||
==History== | ==History== | ||
* '''2017-02-06''' Adapting the good bits from [[VbzCart/tables/event log]] | * '''2017-02-06''' Adapting the good bits from [[VbzCart/tables/event log]] | ||
Revision as of 11:46, 7 February 2017
About
- Purpose: base table for logging application events
- Records only the basic information common to all (or nearly all) events.
- Future: Eventually we will probably want to archive session records, so there should be an archive version of this table which directly stores at least the User ID and maybe IP address and browser. Events whose sessions are being archived would be migrated to that table as part of the same process.
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>