incubator_game_proc.sql 1.7 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344
  1. /*
  2. Navicat Premium Data Transfer
  3. Source Server : aws-预发布
  4. Source Server Type : MySQL
  5. Source Server Version : 80026
  6. Source Host : fhq-game-mysql001.cuas8fqr6b4u.ap-northeast-1.rds.amazonaws.com:3306
  7. Source Schema : incubator_game_dev
  8. Target Server Type : MySQL
  9. Target Server Version : 80026
  10. File Encoding : 65001
  11. Date: 26/08/2022 12:49:21
  12. */
  13. SET NAMES utf8mb4;
  14. SET FOREIGN_KEY_CHECKS = 0;
  15. -- ----------------------------
  16. -- Procedure structure for user_register
  17. -- ----------------------------
  18. DROP PROCEDURE IF EXISTS `user_register`;
  19. delimiter ;;
  20. CREATE PROCEDURE `user_register`(IN inUid BIGINT, IN inPlayerId VARCHAR(50), IN inPlatformId INT, IN inChannelId INT, IN inSubChannelId INT, IN inGameId INT, IN inPhoneNumber VARCHAR(50), IN inEmailAddress VARCHAR(50), IN inWalletAddress VARCHAR(50), IN inWalletChain VARCHAR(50), IN inShareCode VARCHAR(50), IN inLastGameId INT, IN inLastLoginIp VARCHAR(50), IN inLastLoginTime VARCHAR(50), IN inToken VARCHAR(50))
  21. BEGIN
  22. IF NOT EXISTS (SELECT * FROM account_info WHERE uid = inUid) THEN
  23. INSERT INTO account_info(player_id, platform_id, channel_id, subchannel_id, game_id, phone_number, email_address, wallet_address, wallet_chain, share_code, last_game_id,last_login_ip, last_login_time, token)
  24. VALUES(inPlayerId, inPlatformId, inChannelId, inSubChannelId, inGameId, inPhoneNumber, inEmailAddress, inWalletAddress, inWalletChain, inShareCode, inLastGameId, inLastLoginIp, inLastLoginTime, inToken);
  25. IF ROW_COUNT() > 0 THEN
  26. SELECT uid AS resValue FROM account_info WHERE player_id = inPlayerId;
  27. ELSE
  28. SELECT -1 AS resValue;
  29. END IF;
  30. ELSE
  31. SELECT -2 AS resValue;
  32. END IF;
  33. END
  34. ;;
  35. delimiter ;
  36. SET FOREIGN_KEY_CHECKS = 1;