| -- Gerrit 2 : MySQL |
| -- |
| delimiter // |
| |
| CREATE FUNCTION nextval_branch_id () |
| RETURNS BIGINT |
| LANGUAGE SQL |
| NOT DETERMINISTIC |
| MODIFIES SQL DATA |
| BEGIN |
| INSERT INTO branch_id (s) VALUES (NULL); |
| DELETE FROM branch_id WHERE s = LAST_INSERT_ID(); |
| RETURN LAST_INSERT_ID(); |
| END; |
| // |
| |
| 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; |
| // |