CREATE TABLE sequence(tablename VARCHAR(64) NOT NULL,id BIGINT UNSIGNED NOT NULL DEFAULT 1,PRIMARY KEY (tablename)) ENGINE=INNODB;
BEGIN
INSERT INTO sequence (tablename) VALUES (tname) ON DUPLICATE KEY UPDATE id=LAST_INSERT_ID(id+1);
SELECT LAST_INSERT_ID();
END