[Home]|[Architecture Docs]|[Server Schema]

Server Database Schema

Songs Table

Field Type Null Default Links to Comments MIME
ID int(11) No         
ID3_Title text No         
ID3_Artist text No         
ID3_Album text No         
ID3_Length int(11) No         
ID3_Playcount int(11) No         
ID3_Genre text No         
ID3_Year int(11) No         
ID3_Rating int(11) No         
ID3_Bitrate int(11) No         
ID3_TrackNumber int(11) No         
ID3_TotalTrackNumber int(11) No         
ID3_Encoding text No         
ID3_Composer text No         
ID3_Language text No         
ID3_Publisher text No         
ID3_ParentalRating int(11) No         
ID3_DateRecorded int(11) No         
ID3_Binary blob No         
DateAdded text No      Date the song was added to the database   
FilesystemDateModified int(11) No         
DbDateModified int(11) No         
LastInformationSync int(11) No      Last time database information was synced with the physical file   
SongMD5 text No         

Users table

Field Type Null Default Links to Comments MIME
ID int(11) No         
UserName text No         

songRequests Table

Field Type Null Default Links to Comments MIME
ID int(11) No         
SongID int(11) No    songs -> ID     
Requester text No         
Time int(11) No