Added users table
Added users table

This update removes username information from the song and chat tables,
and creates a new users table containing userid, username, and the last
time that user was seen. The table's primary key is on (userid,
username), so a new entry is created only if the user hasn't been seen
before or if the user changed their name.

The following set of MySQL commands will update your table schema
without any loss of data:

INSERT INTO USERS (id, name, last seen) SELECT djid, djname, started
FROM SONGLIST ORDER BY started asc ON DUPLICATE KEY UPDATElast seen =
SONGLIST.started

INSERT INTO USERS (id, name lastseenen) SELECT djid, djname, started
FROM CHATLOG ORDER BY started asc ON DUPLICATE KEY UPDAlast seeneen =
SONGLIST.started

ALTER TABLE SONGLIST DROP COLUMN djname
ALTER TABLE CHATLOG DROP COLUMN user

(where SONGLIST is your song table and CHATLOG is your chat table)

sharedferret/Sparkle-Turntable-Bot