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 Jump to 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>

Retrieved from "https://htyp.org/mw/index.php?title=AudioFerret/v1/sql/Tracks_Played&oldid=16640"