AudioFerret/v1/sql/Tracks Played

from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
< AudioFerret‎ | v1‎ | sql
Jump to: navigation, search

About

  • Purpose: This is the record of everything ever played on the jukebox.
    • There should probably be a mechanism for archiving this to a separate table so this one doesn't get unnecessarily huge.

SQL

<mysql>CREATE TABLE `Tracks_Played` (

 `id` int(11) NOT NULL auto_increment,
 `id_title` int(11) default NULL,
 `when_requested` datetime default NULL,
 `when_started` datetime default NULL,
 `when_finished` datetime default NULL,
 `user` varchar(50) default NULL,
 `station` varchar(50) default NULL,
 PRIMARY KEY  (`id`)

) ENGINE=MyISAM;</mysql>