Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE IF NOT EXISTS usernames (uid INTEGER PRIMARY KEY, username TEXT, valid INTEGER);
- CREATE TABLE IF NOT EXISTS nicknames (nickname TEXT, uid INTEGER NOT NULL,
- FOREIGN KEY (uid) REFERENCES usernames(uid));
- CREATE TABLE IF NOT EXISTS artists (artid INTEGER PRIMARY KEY, artist TEXT UNIQUE, TIMESTAMP INTEGER);
- CREATE TABLE IF NOT EXISTS artist_tag_cache (artid INTEGER, tag TEXT,
- votes INTEGER, FOREIGN KEY (artid) REFERENCES artists(artid));
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement