3d531b98
 王彪总
fix(config): 更新配置...
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
|
-- App version check table
DROP TABLE IF EXISTS `app_version`;
CREATE TABLE `app_version` (
`id` int NOT NULL AUTO_INCREMENT,
`av_id` varchar(30) NOT NULL COMMENT 'version ID',
`version_code` int NOT NULL COMMENT 'e.g. 100',
`version_name` varchar(20) NOT NULL COMMENT 'e.g. 1.0.0',
`download_url` varchar(500) NOT NULL COMMENT 'APK download URL',
`force_update` tinyint DEFAULT 0 COMMENT '0=optional 1=force',
`update_message` text COMMENT 'update description',
`platform` varchar(10) DEFAULT 'android' COMMENT 'android/ios',
`status_cd` varchar(2) DEFAULT '0',
`create_time` timestamp DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
KEY `idx_platform` (`platform`, `status_cd`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-- Seed data: current version
INSERT INTO `app_version` (`av_id`, `version_code`, `version_name`, `download_url`, `force_update`, `update_message`, `platform`, `status_cd`)
VALUES ('AV20260518001', 100, '1.0.0', 'https://spms.xrparking.cn/app/download', 0, '初始版本', 'android', '0');
INSERT INTO c_service (service_id, service_code, business_type_cd, name, seq, is_instance, url, method, timeout, retry_count, provide_app_id, status_cd)
VALUES ('SVCPROPVER', 'property.checkVersion', 'API', '版本检查', 1, 'CMD', 'http://user-service', 'POST', 60, 3, '8000418002', '0');
INSERT INTO c_route (app_id, service_id, order_type_cd, invoke_limit_times, invoke_model, status_cd)
VALUES ('992020022270580001', 'SVCPROPVER', 'Q', -1, 'S', '0');
|
