GW2 TS3 Authentication - Table

GW2_TS3_Auth.sql

CREATE TABLE IF NOT EXISTS `ts3auth` (
  `ts3_uniqueid` varchar(250) NOT NULL,
  `gw2_name` varchar(250) NOT NULL,
  `gw2_refresh` varchar(250) NOT NULL,
  `gw2_apikey` varchar(250) NOT NULL,
  `gw2_world` int(11) NOT NULL,
  `last_check` datetime NOT NULL,
  `dbsessionhash` varchar(250) NOT NULL,
  `type` varchar(20) NOT NULL DEFAULT 'oauth',
  `keyname` varchar(250) NOT NULL DEFAULT '',
  PRIMARY KEY (`ts3_uniqueid`),
  UNIQUE KEY `ts3_uniqueid` (`ts3_uniqueid`)
);

-- Updates the table if you used the older OAuth version. These will fail if it was created above but that can be ignored.
ALTER TABLE `ts3auth` ADD `gw2_apikey` varchar(250) NOT NULL;
ALTER TABLE `ts3auth` ADD `type` varchar(20) NOT NULL DEFAULT 'oauth';
ALTER TABLE `ts3auth` ADD `keyname` varchar(250) NOT NULL DEFAULT '';