File indexing completed on 2024-05-19 04:48:25
0001 CREATE TABLE ARTISTS 0002 ( 0003 artist TEXT , 0004 wiki TEXT, 0005 PRIMARY KEY(artist) 0006 ); 0007 0008 CREATE TABLE ALBUMS 0009 ( 0010 album TEXT , 0011 artist TEXT, 0012 wiki TEXT, 0013 PRIMARY KEY(album, artist), 0014 FOREIGN KEY(artist) REFERENCES artists(artist) 0015 ); 0016 0017 CREATE TABLE SOURCES_TYPES 0018 ( 0019 id INTEGER PRIMARY KEY, 0020 name TEXT NOT NULL 0021 ); 0022 0023 CREATE TABLE SOURCES 0024 ( 0025 url TEXT PRIMARY KEY , 0026 sourcetype INTEGER NOT NULL, 0027 FOREIGN KEY(sourcetype) REFERENCES SOURCES_TYPES(id) 0028 ); 0029 0030 CREATE TABLE TRACKS 0031 ( 0032 url TEXT , 0033 source TEXT , 0034 track INTEGER , 0035 title TEXT NOT NULL, 0036 artist TEXT NOT NULL, 0037 album TEXT NOT NULL, 0038 duration INTEGER , 0039 comment TEXT, 0040 count INTEGER , 0041 rate INTEGER NOT NULL, 0042 releasedate DATE , 0043 adddate DATE NOT NULL, 0044 lastsync DATE, 0045 lyrics TEXT NOT NULL, 0046 genre TEXT, 0047 wiki TEXT NOT NULL, 0048 PRIMARY KEY (url), 0049 FOREIGN KEY(source) REFERENCES SOURCES(url), 0050 FOREIGN KEY(album, artist) REFERENCES albums(album, artist) 0051 ); 0052 0053 --First insertions 0054 0055 INSERT INTO SOURCES_TYPES VALUES (1,"LOCAL"); 0056 INSERT INTO SOURCES_TYPES VALUES (2,"ONLINE"); 0057 INSERT INTO SOURCES_TYPES VALUES (3,"DEVICE");