Function: nornix_site.create_user

Information
DTD identifierDeterministicData accessMode
int(11)NOMODIFIES SQL DATA

Code

Create a new user, returns the primary key/id

CREATE DEFINER=`root`@`localhost` FUNCTION `create_user`(vLogin VARCHAR(64), vHash VARCHAR(128),
 vName VARCHAR(128), vEmail VARCHAR(64), vLanguage VARCHAR(3)) RETURNS int(11)
    MODIFIES SQL DATA
    COMMENT 'Create a new user, returns the primary key/id'
BEGIN
 DECLARE num INTEGER;
 SELECT COUNT(*) INTO num FROM `user` WHERE `Login` = vLogin;
 IF num != 0 THEN
  RETURN NULL;
 ELSE
  INSERT INTO `user` (`Login`, `Hash`, `Name`, `Email`, `Language`)
  VALUES (vLogin, vHash, vName, vEmail, vLanguage);
  RETURN LAST_INSERT_ID();
 END IF;
END