常量

12132

常量总览

_constant结构

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

_constant 表数据

安装包版本

constantKey	constantType
packageVersion	object

{
  "latestVersion": "1.2.3",
  "downloadPath": {
    "win": "/upload/appPackage/JiangHu审计软件-科研版.exe",
    "mac": "/upload/appPackage/JiangHu审计软件-科研版.dmg"
  },
  "updateTitle": "【科研】安装包",
  "updateLog": "1.分录计算汇总跳过错误格式\n2. excel计算逻辑放前端，调整计算不用发包了"
}

_constant语句

INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (6, 'packageVersion', 'object', '安装包版本', '{"latestVersion":"1.2.3","downloadPath": {"win": "/upload/appPackage/JiangHu审计软件-科研版.exe", "mac": "/upload/appPackage/JiangHu审计软件-科研版.dmg"}, "updateTitle": "【科研】安装包", "updateLog": "1.分录计算汇总跳过错误格式\n2. excel计算逻辑放前端，调整计算不用发包了"}', 'update', 'admin01', 'admin01', '2022-03-12T17:19:50+08:00');

# 常量总览

## _constant结构

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

## _constant 表数据

### 安装包版本

| constantKey | constantType |
| --- | --- |
| packageVersion | object |

```js
{
  "latestVersion": "1.2.3",
  "downloadPath": {
    "win": "/upload/appPackage/JiangHu审计软件-科研版.exe",
    "mac": "/upload/appPackage/JiangHu审计软件-科研版.dmg"
  },
  "updateTitle": "【科研】安装包",
  "updateLog": "1.分录计算汇总跳过错误格式\n2. excel计算逻辑放前端，调整计算不用发包了"
}
```

## _constant语句

```sql
INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (6, 'packageVersion', 'object', '安装包版本', '{"latestVersion":"1.2.3","downloadPath": {"win": "/upload/appPackage/JiangHu审计软件-科研版.exe", "mac": "/upload/appPackage/JiangHu审计软件-科研版.dmg"}, "updateTitle": "【科研】安装包", "updateLog": "1.分录计算汇总跳过错误格式\n2. excel计算逻辑放前端，调整计算不用发包了"}', 'update', 'admin01', 'admin01', '2022-03-12T17:19:50+08:00');
```