The code works completely
Code:
DROP TABLE session; CREATE TABLE session ( sessionhash CHAR(32) NOT NULL DEFAULT '', userid INT UNSIGNED NOT NULL DEFAULT '0', host VARCHAR(45) NOT NULL DEFAULT '', idhash CHAR(32) NOT NULL DEFAULT '', lastactivity INT UNSIGNED NOT NULL DEFAULT '0', ******************************** CHAR(255) NOT NULL DEFAULT '', useragent CHAR(255) NOT NULL DEFAULT '', styleid SMALLINT UNSIGNED NOT NULL DEFAULT '0', ********************************id SMALLINT UNSIGNED NOT NULL DEFAULT '0', loggedin SMALLINT UNSIGNED NOT NULL DEFAULT '0', bad******************************** SMALLINT UNSIGNED NOT NULL DEFAULT '0', apiclientid INT UNSIGNED NOT NULL DEFAULT '0', apiaccesstoken VARCHAR(32) NOT NULL DEFAULT '', wol CHAR(255) NOT NULL DEFAULT '', pagekey VARCHAR(255) NOT NULL DEFAULT '', emailstamp INT UNSIGNED NOT NULL DEFAULT '0', PRIMARY KEY (sessionhash), KEY last_activity USING BTREE (lastactivity), KEY user_activity USING BTREE (userid, lastactivity), KEY guest_lookup (idhash, host, userid), KEY apiaccesstoken (apiaccesstoken), KEY pagekey (pagekey) );
Comment