Advertisement
Guest User

Untitled

a guest
Jul 28th, 2017
50
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.45 KB | None | 0 0
  1. CREATE TABLE IF NOT EXISTS usernames (uid INTEGER PRIMARY KEY, username TEXT, valid INTEGER);
  2. CREATE TABLE IF NOT EXISTS nicknames (nickname TEXT, uid INTEGER NOT NULL,
  3.     FOREIGN KEY (uid) REFERENCES usernames(uid));
  4. CREATE TABLE IF NOT EXISTS artists (artid INTEGER PRIMARY KEY, artist TEXT UNIQUE, TIMESTAMP INTEGER);
  5. CREATE TABLE IF NOT EXISTS artist_tag_cache (artid INTEGER, tag TEXT,
  6.     votes INTEGER, FOREIGN KEY (artid) REFERENCES artists(artid));
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement