gen_ticket64.sql

DELIMITER $$
CREATE FUNCTION `gen_ticket64`() RETURNS BIGINT(20)
BEGIN
	DECLARE epoch BIGINT(20);
    DECLARE current_ms BIGINT(20);
    DECLARE node INTEGER;
    DECLARE incr BIGINT(20);
    
    SET node = 1;
    SET schema_node = 1;
    SET current_ms = round(UNIX_TIMESTAMP(CURTIME(4)) * 1000);
    SET epoch = 1459440000000; #//change your epoch
    
    REPLACE INTO tb_tickets (stub) VALUES ('a');
	SELECT LAST_INSERT_ID() INTO incr;
    
    
RETURN (current_ms - epoch) << 22 | (node << 12) | (incr % 4096);
END$$
DELIMITER ;