CREATE TABLE IF NOT EXISTS asyncdata (
	procid		VARCHAR(64) NOT NULL,
	ident		VARCHAR(200) DEFAULT NULL,
	useruid		VARCHAR(200) DEFAULT NULL,
	created		DATE NOT NULL DEFAULT (datetime('now','localtime')),
	expires		DATE,
	procdata	TEXT DEFAULT NULL,
	procstatus	TEXT DEFAULT NULL,
	response	TEXT DEFAULT NULL
);

CREATE INDEX IF NOT EXISTS idx_asyncdata_procid ON asyncdata(procid);
CREATE INDEX IF NOT EXISTS idx_asyncdata_ident ON asyncdata(ident);
CREATE UNIQUE INDEX IF NOT EXISTS idx_asyncdata_procunique ON asyncdata(procid, ident);