Home Explore Help
Register Sign In
xuchaoqing
/
fastadmin_tailored
1
0
Fork 0
Files Issues 0 Pull Requests 0 Wiki
Tree: e015a8a371
Branches Tags
fastadmin_ta...
/
install_platform_config.sql

install_platform_config.sql 6.0 KB
History Raw

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657 
  1. -- 微信小程序和抖音小程序配置数据插入语句
    2. 

  2. 

  3. -- 先检查是否存在平台配置根节点，不存在则插入
    4. 

  4. INSERT IGNORE INTO `fa_config` (`name`, `group`, `title`, `tip`, `type`, `visible`, `value`, `content`, `rule`, `extend`, `setting`) VALUES
    5. 

  5. ('shop.platform', 'shop', '平台配置', '平台配置管理', 'group', '', '', '', '', '', '');
    6. 

  6. 

  7. -- 微信小程序配置组
    8. 

  8. INSERT IGNORE INTO `fa_config` (`name`, `group`, `title`, `tip`, `type`, `visible`, `value`, `content`, `rule`, `extend`, `setting`) VALUES
    9. 

  9. ('shop.platform.WechatMiniProgram', 'shop.platform', '微信小程序', '微信小程序平台配置', 'group', '', '', '', '', '', '');
    10. 

  10. 

  11. -- 微信小程序基本信息
    12. 

  12. INSERT IGNORE INTO `fa_config` (`name`, `group`, `title`, `tip`, `type`, `visible`, `value`, `content`, `rule`, `extend`, `setting`) VALUES
    13. 

  13. ('shop.platform.WechatMiniProgram.app_id', 'shop.platform.WechatMiniProgram', '小程序AppId', 'AppID是小程序开发标识码，配合AppSecret可调用小程序的接口能力', 'string', '', '', '', 'required', '', ''),
    14. 

  14. ('shop.platform.WechatMiniProgram.secret', 'shop.platform.WechatMiniProgram', '小程序密钥', 'AppSecret是校验小程序开发者身份的密钥，具有极高的安全性', 'string', '', '', '', 'required', '', ''),
    15. 

  15. ('shop.platform.WechatMiniProgram.status', 'shop.platform.WechatMiniProgram', '小程序开启状态', '是否开启微信小程序功能', 'boolean', '', '0', '', '', '', '');
    16. 

  16. 

  17. -- 微信小程序登录配置
    18. 

  18. INSERT IGNORE INTO `fa_config` (`name`, `group`, `title`, `tip`, `type`, `visible`, `value`, `content`, `rule`, `extend`, `setting`) VALUES
    19. 

  19. ('shop.platform.WechatMiniProgram.auto_login', 'shop.platform.WechatMiniProgram', '微信自动登录', '进入应用后，用户将会自动授权登录，未注册用户将会自动注册', 'boolean', '', '1', '', '', '', ''),
    20. 

  20. ('shop.platform.WechatMiniProgram.bind_mobile', 'shop.platform.WechatMiniProgram', '绑定手机号', '授权登录后，未绑定手机号的用户，将会立即提醒绑定手机号', 'boolean', '', '1', '', '', '', '');
    21. 

  21. 

  22. -- 微信小程序支付配置组
    23. 

  23. INSERT IGNORE INTO `fa_config` (`name`, `group`, `title`, `tip`, `type`, `visible`, `value`, `content`, `rule`, `extend`, `setting`) VALUES
    24. 

  24. ('shop.platform.WechatMiniProgram.payment', 'shop.platform.WechatMiniProgram', '支付配置', '小程序支付方式配置', 'group', '', '', '', '', '', ''),
    25. 

  25. ('shop.platform.WechatMiniProgram.payment.wechat', 'shop.platform.WechatMiniProgram.payment', '微信支付配置', '微信支付相关配置', 'int', '', '1', '', '', '', ''),
    26. 

  26. ('shop.platform.WechatMiniProgram.payment.alipay', 'shop.platform.WechatMiniProgram.payment', '支付宝支付配置', '支付宝支付相关配置', 'int', '', '0', '', '', '', ''),
    27. 

  27. ('shop.platform.WechatMiniProgram.payment.methods', 'shop.platform.WechatMiniProgram.payment', '支付方式', '可用的支付方式列表', 'array', '', '[\"wechat\",\"balance\"]', '', '', '', '');
    28. 

  28. 

  29. -- 微信小程序分享配置
    30. 

  30. INSERT IGNORE INTO `fa_config` (`name`, `group`, `title`, `tip`, `type`, `visible`, `value`, `content`, `rule`, `extend`, `setting`) VALUES
    31. 

  31. ('shop.platform.WechatMiniProgram.share', 'shop.platform.WechatMiniProgram', '分享信息', '小程序分享配置信息', 'array', '', '[]', '', '', '', '');
    32. 

  32. 

  33. -- 抖音小程序配置组  
    34. 

  34. INSERT IGNORE INTO `fa_config` (`name`, `group`, `title`, `tip`, `type`, `visible`, `value`, `content`, `rule`, `extend`, `setting`) VALUES
    35. 

  35. ('shop.platform.DouyinMiniProgram', 'shop.platform', '抖音小程序', '抖音小程序平台配置', 'group', '', '', '', '', '', '');
    36. 

  36. 

  37. -- 抖音小程序基本信息
    38. 

  38. INSERT IGNORE INTO `fa_config` (`name`, `group`, `title`, `tip`, `type`, `visible`, `value`, `content`, `rule`, `extend`, `setting`) VALUES
    39. 

  39. ('shop.platform.DouyinMiniProgram.app_id', 'shop.platform.DouyinMiniProgram', '抖音小程序AppId', '抖音小程序应用ID', 'string', '', '', '', 'required', '', ''),
    40. 

  40. ('shop.platform.DouyinMiniProgram.secret', 'shop.platform.DouyinMiniProgram', '抖音小程序密钥', '抖音小程序应用密钥', 'string', '', '', '', 'required', '', ''),
    41. 

  41. ('shop.platform.DouyinMiniProgram.status', 'shop.platform.DouyinMiniProgram', '抖音小程序开启状态', '是否开启抖音小程序功能', 'boolean', '', '0', '', '', '', '');
    42. 

  42. 

  43. -- 抖音小程序登录配置
    44. 

  44. INSERT IGNORE INTO `fa_config` (`name`, `group`, `title`, `tip`, `type`, `visible`, `value`, `content`, `rule`, `extend`, `setting`) VALUES
    45. 

  45. ('shop.platform.DouyinMiniProgram.auto_login', 'shop.platform.DouyinMiniProgram', '自动登录', '进入应用后，用户将会自动授权登录，未注册用户将会自动注册', 'boolean', '', '1', '', '', '', ''),
    46. 

  46. ('shop.platform.DouyinMiniProgram.bind_mobile', 'shop.platform.DouyinMiniProgram', '绑定手机号', '授权登录后，未绑定手机号的用户，将会立即提醒绑定手机号', 'boolean', '', '1', '', '', '', '');
    47. 

  47. 

  48. -- 抖音小程序支付配置组
    49. 

  49. INSERT IGNORE INTO `fa_config` (`name`, `group`, `title`, `tip`, `type`, `visible`, `value`, `content`, `rule`, `extend`, `setting`) VALUES
    50. 

  50. ('shop.platform.DouyinMiniProgram.payment', 'shop.platform.DouyinMiniProgram', '支付配置', '抖音小程序支付方式配置', 'group', '', '', '', '', '', ''),
    51. 

  51. ('shop.platform.DouyinMiniProgram.payment.wechat', 'shop.platform.DouyinMiniProgram.payment', '微信支付配置', '微信支付相关配置', 'int', '', '0', '', '', '', ''),
    52. 

  52. ('shop.platform.DouyinMiniProgram.payment.alipay', 'shop.platform.DouyinMiniProgram.payment', '支付宝支付配置', '支付宝支付相关配置', 'int', '', '1', '', '', '', ''),
    53. 

  53. ('shop.platform.DouyinMiniProgram.payment.methods', 'shop.platform.DouyinMiniProgram.payment', '支付方式', '可用的支付方式列表', 'array', '', '[\"alipay\",\"balance\"]', '', '', '', '');
    54. 

  54. 

  55. -- 抖音小程序分享配置
    56. 

  56. INSERT IGNORE INTO `fa_config` (`name`, `group`, `title`, `tip`, `type`, `visible`, `value`, `content`, `rule`, `extend`, `setting`) VALUES
    57. 

  57. ('shop.platform.DouyinMiniProgram.share', 'shop.platform.DouyinMiniProgram', '分享信息', '抖音小程序分享配置信息', 'array', '', '[]', '', '', '', ''); 
    58.