init_data.sql 1.1 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657
  1. -- Transfer模块初始化数据脚本
  2. -- 创建时间: 2025-06-15
  3. -- 模块: Transfer
  4. -- 插入示例应用配置数据
  5. INSERT INTO `kku_transfer_apps` (
  6. `keyname`, `title`, `description`, `out_id`, `out_id2`, `out_id3`, `currency_id`, `fund_id`,
  7. `exchange_rate`, `order_callback_url`, `order_out_create_url`, `is_enabled`, `created_at`, `updated_at`
  8. ) VALUES
  9. (
  10. 'game_app_demo',
  11. '演示游戏应用',
  12. '用于测试的演示应用',
  13. 1001,
  14. 2001,
  15. 3001,
  16. 2,
  17. 2,
  18. 1.0000,
  19. 'https://demo.game.com/callback',
  20. 'https://demo.game.com/order/create',
  21. 1,
  22. NOW(),
  23. NOW()
  24. ),
  25. (
  26. 'game_app_a',
  27. '游戏应用A',
  28. '热门游戏应用A',
  29. 1002,
  30. 2002,
  31. NULL,
  32. 2,
  33. 2,
  34. 1.0450,
  35. 'https://api.game-a.com/callback',
  36. 'https://api.game-a.com/order/create',
  37. 1,
  38. NOW(),
  39. NOW()
  40. ),
  41. (
  42. 'farm_internal',
  43. '农场内部应用',
  44. '仅在农场内部运转,不调用外部API',
  45. 1003,
  46. NULL,
  47. NULL,
  48. 1,
  49. 1,
  50. 1.0000,
  51. NULL,
  52. NULL,
  53. 1,
  54. NOW(),
  55. NOW()
  56. );