DELIMITER //DROP PROCEDURE IF EXISTS create_account;CREATE PROCEDURE create_account (usrName VARCHAR(12), pssWd VARCHAR(32))BEGIN SET @shaPass := SHA1(CONCAT(UPPER(usrName),':',UPPER(pssWd))); INSERT INTO account(`username`, `sha_pass_hash`, `expansion`) VALUES(usrName, @shaPass, 2); SELECT @accID := `id` FROM account WHERE username = `usrName`; INSERT INTO rbac_account_permissions(`accountId`, `permissionId`, `granted`, `realmId`) VALUES(@accId, 195, 1, -1);END//DELIMITER :
DELIMITER //DROP PROCEDURE IF EXISTS create_account;CREATE PROCEDURE create_account (usrName VARCHAR(12), pssWd VARCHAR(32), expacType INTEGER)BEGIN SET @shaPass := SHA1(CONCAT(UPPER(usrName),':',UPPER(pssWd))); INSERT INTO account(`username`, `sha_pass_hash`, `expansion`) VALUES(usrName, @shaPass, expacType); SELECT @accID := `id` FROM account WHERE username = `usrName`; INSERT INTO rbac_account_permissions(`accountId`, `permissionId`, `granted`, `realmId`) VALUES(@accId, 195, 1, -1);END//DELIMITER :
DELIMITER //DROP PROCEDURE IF EXISTS create_account;CREATE PROCEDURE create_account (usrName VARCHAR(12), pssWd VARCHAR(32), rbacGMLevel INTEGER)BEGIN SET @shaPass := SHA1(CONCAT(UPPER(usrName),':',UPPER(pssWd))); INSERT INTO account(`username`, `sha_pass_hash`, `expansion`) VALUES(usrName, @shaPass, 2); SELECT @accID := `id` FROM account WHERE username = `usrName`; INSERT INTO rbac_account_permissions(`accountId`, `permissionId`, `granted`, `realmId`) VALUES(@accId, rbacGMLevel, 1, -1);END//DELIMITER :
DELIMITER //DROP PROCEDURE IF EXISTS create_account;CREATE PROCEDURE create_account (usrName VARCHAR(12), pssWd VARCHAR(32), expacType INTEGER, rbacGMLevel INTEGER)BEGIN SET @shaPass := SHA1(CONCAT(UPPER(usrName),':',UPPER(pssWd))); INSERT INTO account(`username`, `sha_pass_hash`, `expansion`) VALUES(usrName, @shaPass, expacType); SELECT @accID := `id` FROM account WHERE username = `usrName`; INSERT INTO rbac_account_permissions(`accountId`, `permissionId`, `granted`, `realmId`) VALUES(@accId, rbacGMLevel, 1, -1);END//DELIMITER :