Ferret File System/v0.1/SQL/event

About

• purpose: root events table -- all task-specific events tables refer to this one

fields

• When: When the event occurred.
  • If an event-type has a beginning and end, the auxiliary table for that type may treat When as "when started" and add a WhenComplete field to indicate when the event was complete.
• Type: short string indicating which type of event, i.e. which class to use (and which auxiliary event table to look at).
  • Types include: vol, fldr, file
• Descr: automatically-generated human-friendly description of what happened

history

• 2016-02-27 started

SQL

<mysql>CREATE TABLE `events` (

 `ID`                 INT NOT NULL AUTO_INCREMENT,
 `When`          DATETIME NOT NULL,
 `Type`   VARCHAR(15) DEFAULT NULL,
 `Descr`  VARCHAR(255) DEFAULT NULL,
 PRIMARY KEY(`ID`)

) ENGINE = MYISAM;</mysql>