1 DROP PROCEDURE IF EXISTS `Ai_Promote`.`APWXUserAdd`
 2 DELIMITER ;;
 3 CREATE DEFINER=`root`@`%` PROCEDURE `Ai_Promote`.`APWXUserAdd`(_openid VARCHAR(50), _shopid VARCHAR(20), _shopname VARCHAR(100), _photo VARCHAR(200), _nickname VARCHAR(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, _phone VARCHAR(20), _city VARCHAR(50), _country VARCHAR(50), _province varchar(50), _session_Key VARCHAR(200))
 4 BEGIN
 5     DECLARE allCount INTEGER DEFAULT 0;
 6     DECLARE t_error INTEGER DEFAULT 0;
 7     DECLARE CONTINUE HANDLER FOR SQLEXCEPTION SET t_error=1;
 8     START TRANSACTION;
 9       SELECT COUNT(*) INTO allCount FROM `t_wx_user` WHERE shopid = _shopid and shopname = _shopname and openid = _openid;
10       IF allCount = 0 THEN
11             INSERT INTO `Ai_Promote`.`t_wx_user`(openid, shopid, shopname, photo, nickname, phone, phoneNumber, countryCode, role, city, country, province, session_key, add_date, unionid, gender, update_date) 
               VALUES(_openid, _shopid, _shopname, _photo, _nickname, _phone, _phone, ‘86‘, ‘‘, _city, _country, _province, _session_key, NOW(), ‘‘, ‘‘, NOW());
12       END IF;
13       IF t_error=1 THEN
14         SELECT 0;
15         ROLLBACK;
16       ELSE
17         SELECT 1;
18         COMMIT;
19       END IF;
20 END
21 ;;
22 DELIMITER ;