"UPDATE localalbum SET albumname=?, artistname=? WHERE ( albumdirectory = ?) " "SELECT albumid FROM localalbum WHERE (albumdirectory = ?) " "DELETE FROM localtrack WHERE (trackalbum = ?) " "DELETE FROM localalbum WHERE (albumdirectory=? ) " "SELECT albumartist FROM localalbum WHERE albumdirectory=? " "SELECT artistid FROM localartist WHERE artistdirectory=? " "SELECT lasttouchedtime FROM localtrack WHERE albumid FROM localalbum WHERE albumdirectory=? " "CREATE TABLE genre( genreid INTEGER PRIMARY KEY, genretext TEXT) " "CREATE TABLE localartist (artistid INTEGER PRIMARY KEY,artistdirectory TEXT,artistname TEXT) " "CREATE TABLE localalbum (albumid INTEGER PRIMARY KEY,albumdirectory TEXT,albumname TEXT,artistname TEXT,trackcount INTEGER,albumartist INTEGER REFERENCES localartist( artistid ) ON UPDATE CASCADE ) " "CREATE TABLE localtrack (trackid INTEGER PRIMARY KEY,trackfile TEXT,trackposition INTEGER,lasttouchedtime INTEGER,trackname TEXT,albumname TEXT,artistname TEXT,trackyear INTEGER,tracktrack INTEGER,lengthinmilliseconds INTEGER,bitrate INTEGER,samplerate INTEGER,channels INTEGER,trackgenre INTEGER REFERENCES localgenre( genreid ) ON UPDATE CASCADE,trackalbum INTEGER REFERENCES localalbum( albumid ) ON UPDATE CASCADE) " Contains indicators of bot communication commands
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |