1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
|
-- ----------------------------
-- Procedure definition for `InsertUserAndPhoneTransaction`
-- ----------------------------
DROP PROCEDURE IF EXISTS `InsertUserAndPhoneTransaction`;
DELIMITER ;;
CREATE DEFINER=`rudy`@`%` PROCEDURE `InsertUserAndPhoneTransaction`(IN `publicPhone` varchar(50),IN `privatePhone` varchar(50),IN `fax` varchar(50),IN `gsm` varchar(50),IN `id_service` int,IN `id_type_user` int,IN `last_name` varchar(50),IN `first_name` varchar(50),IN `fonction` varchar(50),IN `login` varchar(50),IN `pwd` varchar(50),IN `queryKey` varchar(50))
BEGIN
DECLARE id_telephone INT;
DECLARE EXIT HANDLER FOR SQLEXCEPTION ROLLBACK;
DECLARE EXIT HANDLER FOR SQLWARNING ROLLBACK;
START TRANSACTION;
INSERT INTO TELEPHONE (PUBLIC_NUMBER, PRIVATE_NUMBER, FAX_NUMBER, GSM_NUMBER)
VALUES (publicPhone,privatePhone,fax,gsm);
SET id_telephone := LAST_INSERT_ID();
INSERT INTO USERS (ID_SERVICE, ID_TYPE_USER, ID_TELEPHONE, LAST_NAME, FIRST_NAME, FONCTION, LOGIN, PASS)
VALUES (id_service,id_type_user,id_telephone,last_name,first_name,fonction,login,AES_ENCRYPT(pwd,queryKey));
COMMIT;
END
;; |
