-- Gerrit 2 : MySQL | |
-- | |
delimiter // | |
CREATE FUNCTION nextval_project_id () | |
RETURNS BIGINT | |
LANGUAGE SQL | |
NOT DETERMINISTIC | |
MODIFIES SQL DATA | |
BEGIN | |
INSERT INTO project_id (s) VALUES (NULL); | |
DELETE FROM project_id WHERE s = LAST_INSERT_ID(); | |
RETURN LAST_INSERT_ID(); | |
END; | |
// | |
CREATE FUNCTION nextval_account_id () | |
RETURNS BIGINT | |
LANGUAGE SQL | |
NOT DETERMINISTIC | |
MODIFIES SQL DATA | |
BEGIN | |
INSERT INTO account_id (s) VALUES (NULL); | |
DELETE FROM account_id WHERE s = LAST_INSERT_ID(); | |
RETURN LAST_INSERT_ID(); | |
END; | |
// |