CREATE TABLE IF NOT EXISTS %tpl_prefix%userdata (
	id
        INTEGER PRIMARY KEY
        AUTOINCREMENT
        NOT NULL
        UNIQUE,
	sessid  VARCHAR(64) NOT NULL,
	token   VARCHAR(40) NOT NULL,
	created INTEGER UNSIGNED NOT NULL,
	expires INTEGER UNSIGNED NOT NULL,
    flash   TINYINT(1) DEFAULT 0,
    clau    VARCHAR(90) NOT NULL,
	valor   TEXT DEFAULT NULL
);
CREATE INDEX IF NOT EXISTS idx_%tpl_prefix%userdata_token ON %tpl_prefix%userdata(sessid, token);
CREATE UNIQUE INDEX IF NOT EXISTS idx_%tpl_prefix%userdata_clau ON %tpl_prefix%userdata(sessid,token,clau);
