CREATE TABLE IF NOT EXISTS %tpl_prefix%proc (
    id
        INTEGER UNSIGNED
        NOT NULL
        AUTO_INCREMENT,
	ident		VARCHAR(255) DEFAULT NULL,
	action		VARCHAR(255) DEFAULT NULL,
	owner		INTEGER UNSIGNED KEY,
	pid			INTEGER UNSIGNED KEY DEFAULT NULL,
	asyncid		VARCHAR(64) DEFAULT NULL,
	uident		VARCHAR(255) DEFAULT NULL,
	sessid		VARCHAR(64) DEFAULT NULL,
	creat		DATE NOT NULL DEFAULT (strftime('%Y-%m-%dT%H:%M:%S', 'now')),
	inici		DATE DEFAULT NULL,
	final		DATE DEFAULT NULL,
	status		INTEGER UNSIGNED DEFAULT NULL,
    PRIMARY KEY (id),
    KEY (uident),
	KEY (sessid)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;