search

SwooshyCueb / strimmer

Collaborative playlisting for an internet radio station
Other
2 stars 0 forks source link

Play history #79

Closed TheBlackParrot closed 9 years ago

TheBlackParrot commented 9 years ago

for reference
CREATE TABLE play_history ( TRACKID VARCHAR(128) DEFAULT NULL, SERVICE VARCHAR(4) DEFAULT "LINK", PLAYED_ON INT(255) DEFAULT 0, ADDED_BY VARCHAR(256) DEFAULT NULL );

TheBlackParrot commented 9 years ago

we probably don't need to have a primary key here, since there can be duplicates. I'm going to limit it to 100 for now, but it should be a config value.
if we NEED one, use PLAYED_ON, that should never be the same