· 7 years ago · Jan 12, 2019, 02:26 PM
1CREATE TABLE IF NOT EXISTS wcs (lvl INT NOT NULL, race, INT NOT NULL, gold INT NOT NULL, nameidx INT UNSIGNED NOT NULL, steamidx INT UNSIGNED NOT NULL, INDEX(nameidx), INDEX(steamidx));
2
3CREATE TABLE IF NOT EXISTS nameidx (nameidx INT UNSIGNED NOT NULL PRIMARY KEY, name CHAR(32));
4
5CREATE TABLE IF NOT EXISTS steamidx (steamidx INT UNSIGNED NOT NULL PRIMARY KEY, steamid CHAR(32));