src/main/webapp/WEB-INF/sql/mysql_nextval.sql

-- 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;
//