Untitled

CREATE TABLE PlaylistEntries (
                    EntryID INTEGER PRIMARY KEY,
                    PlaylistID INTEGER NOT NULL,
                    TrackID INTEGER NOT NULL
                , ViewOrder INTEGER NOT NULL DEFAULT 0);
CREATE TABLE Playlists (
                    PlaylistID INTEGER PRIMARY KEY,
                    Name TEXT NOT NULL
                );
CREATE TABLE Tracks (
                        TrackID INTEGER PRIMARY KEY,
                        Uri TEXT NOT NULL,
                        MimeType TEXT,
                   
                        Artist TEXT,
                        Performer TEXT,
                        AlbumTitle TEXT,
                        ReleaseDate Date,
                        ASIN TEXT,
                        Label TEXT,
                        Title TEXT,
                        Genre TEXT,
                        Year INTEGER,
                   
                        TrackNumber INTEGER,
                        TrackCount INTEGER,
                        Duration INTEGER,
                   
                        TrackGain FLOAT,
                        TrackPeak FLOAT,
                        AlbumGain FLOAT,
                        AlbumPeak FLOAT,
                   
                        Rating INTEGER,
                        NumberOfPlays INTEGER,
                        LastPlayedStamp INTEGER,
                        DateAddedStamp INTEGER,
                   
                        RemoteLookupStatus INTEGER
                );