江湖数字化平台
登录

常量

12114

常量总览

_constant结构

  1. CREATE TABLE `_constant` (
  2.   `id` int(11) NOT NULL AUTO_INCREMENT,
  3.   `constantKey` varchar(255)  DEFAULT NULL,
  4.   `constantType` varchar(255)  DEFAULT NULL COMMENT '常量类型; object, array',
  5.   `desc` varchar(255)  DEFAULT NULL COMMENT '描述',
  6.   `constantValue` text  COMMENT '常量内容; object, array',
  7.   `operation` varchar(255)  DEFAULT 'insert' COMMENT '操作; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  8.   `operationByUserId` varchar(255)  DEFAULT NULL COMMENT '操作者userId',
  9.   `operationByUser` varchar(255)  DEFAULT NULL COMMENT '操作者用户名',
  10.   `operationAt` varchar(255)  DEFAULT NULL COMMENT '操作时间; E.g: 2021-05-28T10:24:54+08:00 ',
  11.   PRIMARY KEY (`id`) USING BTREE
  12. ) ENGINE = InnoDB AUTO_INCREMENT = 66 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '常量表;'

_constant 表数据

  • constantKey：notice

  • constantType：object

  1. {
  2.   "title": "4.3.7 版本发布",
  3.   "content": "快来使用吧！\n测试12123123\n快来使用吧！\n测试12123123\n快来使用吧！\n测试12123123\n快来使用吧！\n测试12123123\n",
  4.   "imageSrc": "/noticeImage/1647076649263_719911_noticeImage.jpeg",
  5.   "isImageShown": false,
  6.   "isTextShown": true
  7. }

null

  • constantKey：userStatus

  • constantType：array

  1. [
  2.   {
  3.     "value": "active",
  4.     "text": "正常"
  5.   },
  6.   {
  7.     "value": "banned",
  8.     "text": "禁用"
  9.   }
  10. ]

null

  • constantKey：userType

  • constantType：array

  1. [
  2.   {
  3.     "value": "common",
  4.     "text": "普通用户"
  5.   },
  6.   {
  7.     "value": "xiaochengxu",
  8.     "text": "小程序机器人"
  9.   }
  10. ]

null

  • constantKey：gender

  • constantType：array

  1. [
  2.   {
  3.     "value": "male",
  4.     "text": "男"
  5.   },
  6.   {
  7.     "value": "female",
  8.     "text": "女"
  9.   }
  10. ]

null

  • constantKey：version

  • constantType：object

  1. {
  2.   "testUserIdList": "",
  3.   "version": "4.3.11",
  4.   "title": "4.3.7 版本发布",
  5.   "note": "新版本介绍\n 1. 聊天输入优化",
  6.   "apkVersion": "5.0.20",
  7.   "apkLink": "https://duoxing.openjianghu.org/duoxing/upload/10002/1647840662817_956853_D多星MD-4.7.10.apk",
  8.   "apkNote": "",
  9.   "desktopVersion": "4.3.2",
  10.   "desktopLink": "http://192.168.110.215:8082/duoxing/upload/duoxing-1.0.1.dmg.zip",
  11.   "desktopNote": "测试桌面客户端升级"
  12. }

null

  • constantKey：emotion

  • constantType：array

  1. [
  2.   {
  3.     "dir": "face01",
  4.     "cover": "face-lbl",
  5.     "ext": "png",
  6.     "cols": 5,
  7.     "total": 86
  8.   },
  9.   {
  10.     "dir": "face02",
  11.     "cover": "face-lbl",
  12.     "ext": "gif",
  13.     "cols": 2,
  14.     "total": 16
  15.   },
  16.   {
  17.     "dir": "face03",
  18.     "cover": "face-lbl",
  19.     "ext": "gif",
  20.     "cols": 2,
  21.     "total": 16
  22.   },
  23.   {
  24.     "dir": "face04",
  25.     "cover": "face-lbl",
  26.     "ext": "gif",
  27.     "cols": 2,
  28.     "total": 16
  29.   },
  30.   {
  31.     "dir": "face05",
  32.     "cover": "face-lbl",
  33.     "ext": "gif",
  34.     "cols": 1,
  35.     "total": 7
  36.   },
  37.   {
  38.     "dir": "face06",
  39.     "cover": "face-lbl",
  40.     "ext": "gif",
  41.     "cols": 3,
  42.     "total": 24
  43.   },
  44.   {
  45.     "dir": "face07",
  46.     "cover": "face-lbl",
  47.     "ext": "gif",
  48.     "cols": 2,
  49.     "total": 16
  50.   },
  51.   {
  52.     "dir": "face08",
  53.     "cover": "face-lbl",
  54.     "ext": "gif",
  55.     "cols": 3,
  56.     "total": 23
  57.   },
  58.   {
  59.     "dir": "face09",
  60.     "cover": "face-lbl",
  61.     "ext": "gif",
  62.     "cols": 2,
  63.     "total": 16
  64.   },
  65.   {
  66.     "dir": "face10",
  67.     "cover": "face-lbl",
  68.     "ext": "gif",
  69.     "cols": 3,
  70.     "total": 20
  71.   },
  72.   {
  73.     "dir": "face11",
  74.     "cover": "face-lbl",
  75.     "ext": "gif",
  76.     "cols": 2,
  77.     "total": 13
  78.   },
  79.   {
  80.     "dir": "face12",
  81.     "cover": "face-lbl",
  82.     "ext": "gif",
  83.     "cols": 2,
  84.     "total": 16
  85.   },
  86.   {
  87.     "dir": "face13",
  88.     "cover": "face-lbl",
  89.     "ext": "gif",
  90.     "cols": 2,
  91.     "total": 15
  92.   },
  93.   {
  94.     "dir": "face14",
  95.     "cover": "face-lbl",
  96.     "ext": "gif",
  97.     "cols": 2,
  98.     "total": 16
  99.   }
  100. ]

null

  • constantKey：appLinkActionConfig

  • constantType：array

  1. [
  2.   {
  3.     "regex": ".openjianghu.org/*",
  4.     "action": "internal"
  5.   },
  6.   {
  7.     "regex": "http://192.168./*",
  8.     "action": "internal"
  9.   }
  10. ]

_constant语句

  1. INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (6, 'notice', 'object', '', '{"title":"4.3.7 版本发布","content":"快来使用吧！\n测试12123123\n快来使用吧！\n测试12123123\n快来使用吧！\n测试12123123\n快来使用吧！\n测试12123123\n","imageSrc":"/noticeImage/1647076649263_719911_noticeImage.jpeg","isImageShown":false,"isTextShown":true}', 'update', 'admin01', 'admin01', '2022-03-12T17:19:50+08:00');
  2. INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (59, 'userStatus', 'array', NULL, '[{"value": "active", "text": "正常"}, {"value": "banned", "text": "禁用"}]', 'insert', NULL, NULL, NULL);
  3. INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (60, 'userType', 'array', NULL, '[{"value": "common", "text": "普通用户"},{"value": "xiaochengxu", "text": "小程序机器人"}]', 'insert', NULL, NULL, NULL);
  4. INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (61, 'gender', 'array', NULL, '[{"value": "male", "text": "男"}, {"value": "female", "text": "女"}]', 'insert', NULL, NULL, NULL);
  5. INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (62, 'version', 'object', NULL, '{"testUserIdList": "","version": "4.3.11", "title": "4.3.7 版本发布", "note": "新版本介绍\n 1. 聊天输入优化", "apkVersion": "5.0.20", "apkLink": "https://duoxing.openjianghu.org/duoxing/upload/10002/1647840662817_956853_D多星MD-4.7.10.apk", "apkNote": "", "desktopVersion": "4.3.2", "desktopLink": "http://192.168.110.215:8082/duoxing/upload/duoxing-1.0.1.dmg.zip", "desktopNote": "测试桌面客户端升级" }', 'insert', NULL, NULL, NULL);
  6. INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (64, 'emotion', 'array', NULL, '[
  7.   {
  8.     "dir":"face01",
  9.     "cover":"face-lbl",
  10.     "ext":"png",
  11.     "cols":5,
  12.     "total":86
  13.   },
  14.   {
  15.     "dir":"face02",
  16.     "cover":"face-lbl",
  17.     "ext":"gif",
  18.     "cols":2,
  19.     "total":16
  20.   },
  21.   {
  22.     "dir":"face03",
  23.     "cover":"face-lbl",
  24.     "ext":"gif",
  25.     "cols":2,
  26.     "total":16
  27.   },
  28.   {
  29.     "dir":"face04",
  30.     "cover":"face-lbl",
  31.     "ext":"gif",
  32.     "cols":2,
  33.     "total":16
  34.   },
  35.   {
  36.     "dir":"face05",
  37.     "cover":"face-lbl",
  38.     "ext":"gif",
  39.     "cols":1,
  40.     "total":7
  41.   },
  42.   {
  43.     "dir":"face06",
  44.     "cover":"face-lbl",
  45.     "ext":"gif",
  46.     "cols":3,
  47.     "total":24
  48.   },
  49.   {
  50.     "dir":"face07",
  51.     "cover":"face-lbl",
  52.     "ext":"gif",
  53.     "cols":2,
  54.     "total":16
  55.   },
  56.   {
  57.     "dir":"face08",
  58.     "cover":"face-lbl",
  59.     "ext":"gif",
  60.     "cols":3,
  61.     "total":23
  62.   },
  63.   {
  64.     "dir":"face09",
  65.     "cover":"face-lbl",
  66.     "ext":"gif",
  67.     "cols":2,
  68.     "total":16
  69.   },
  70.   {
  71.     "dir":"face10",
  72.     "cover":"face-lbl",
  73.     "ext":"gif",
  74.     "cols":3,
  75.     "total":20
  76.   },
  77.   {
  78.     "dir":"face11",
  79.     "cover":"face-lbl",
  80.     "ext":"gif",
  81.     "cols":2,
  82.     "total":13
  83.   },
  84.   {
  85.     "dir":"face12",
  86.     "cover":"face-lbl",
  87.     "ext":"gif",
  88.     "cols":2,
  89.     "total":16
  90.   },
  91.   {
  92.     "dir":"face13",
  93.     "cover":"face-lbl",
  94.     "ext":"gif",
  95.     "cols":2,
  96.     "total":15
  97.   },
  98.   {
  99.     "dir":"face14",
  100.     "cover":"face-lbl",
  101.     "ext":"gif",
  102.     "cols":2,
  103.     "total":16
  104.   }
  105. ]
  106. ', 'insert', NULL, NULL, NULL);
  107. INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (65, 'appLinkActionConfig', 'array', NULL, '[{"regex":".openjianghu.org\/*", "action": "internal"}, {"regex":"http:\/\/192.168.\/*", "action": "internal"}]', 'insert', NULL, NULL, NULL);