You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
60 lines
2.9 KiB
60 lines
2.9 KiB
|
|
CREATE TABLE `app_version` (
|
|
`id` bigint(32) NOT NULL AUTO_INCREMENT COMMENT 'ID，唯一编号',
|
|
`appName` varchar(100) NOT NULL DEFAULT '汇融云链' COMMENT '应用名称',
|
|
`versionCode` int(11) NOT NULL DEFAULT '101' COMMENT '版本编码',
|
|
`versionName` varchar(100) NOT NULL DEFAULT '101' COMMENT '版本号',
|
|
`downloadUrl` varchar(1024) DEFAULT NULL COMMENT '下载地址',
|
|
`versionInfo` varchar(1024) DEFAULT NULL COMMENT '版本描述',
|
|
`isAlpha` int(11) NOT NULL DEFAULT '0' COMMENT '是否内测：0否，1是',
|
|
`fileName` varchar(1024) DEFAULT NULL COMMENT '文件名',
|
|
`forceUpdate` int(11) NOT NULL DEFAULT '1' COMMENT '是否强制升级',
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
|
|
|
insert into app_version(versionCode,versionName,downloadUrl,versionInfo)
|
|
values (101,'101','http://mall.yyundong.com/apks/mall-101.apk','初始版本')
|
|
|
|
insert into app_version(versionCode,versionName,downloadUrl,versionInfo,fileName)
|
|
values (1002,'1.0.0.2','http://mall.yyundong.com/apks/mall-1002.apk','BUG修复，功能完善','mall-1002.apk')
|
|
|
|
insert into app_version(versionCode,versionName,downloadUrl,versionInfo,fileName)
|
|
values (1003,'1.0.0.3','http://mall.yyundong.com/apks/mall-1003.apk','登录方式切换的Bug修复；登录及退出后本地缓存数据问题的修复。','mall-1003.apk')
|
|
|
|
insert into app_version(versionCode,versionName,downloadUrl,versionInfo,fileName)
|
|
values (1012,'1.0.1.2','http://mall.yyundong.com/apks/mall-1012.apk','增加消息推送；优惠券一键领取。','mall-1012.apk')
|
|
|
|
|
|
|
|
CREATE TABLE `push_cids` (
|
|
`id` bigint(32) NOT NULL AUTO_INCREMENT COMMENT 'ID，唯一编号',
|
|
`getuiCid` varchar(100) NOT NULL COMMENT '个推的ClientID',
|
|
`userPhone` varchar(100) DEFAULT NULL COMMENT '用户手机号',
|
|
`userId` bigint(32) DEFAULT NULL COMMENT '用户ID',
|
|
`store_id` int(11) DEFAULT 1 COMMENT '用户ID',
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
|
|
|
ALTER TABLE mallplus1.push_cids ADD store_id INT DEFAULT 1 NULL;
|
|
|
|
|
|
|
|
CREATE TABLE `sys_message_task` (
|
|
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
|
|
`user_id` int(11) NOT NULL DEFAULT '1' COMMENT '用户id',
|
|
`code` varchar(60) DEFAULT '系统消息' COMMENT '消息编码',
|
|
`params` varchar(5000) DEFAULT NULL COMMENT '参数',
|
|
`content` text COMMENT '内容',
|
|
`sendtime` datetime NOT NULL COMMENT '发送时间',
|
|
`status` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '0未发送，1已发送',
|
|
`store_id` int(11) DEFAULT 1 COMMENT '用户ID',
|
|
PRIMARY KEY (`id`) USING BTREE
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='定时消息';
|
|
|
|
|
|
|
|
INSERT INTO sys_permission (pid, name, value, icon, type, uri, status, create_time, sort)
|
|
VALUES (43, '定时消息', 'ums:UmsMember:read', 'product-list', 1, 'sysMessageTask', 1, now() , 1)
|
|
|
|
INSERT INTO sys_permission (pid, name, value, icon, type, uri, status, create_time, sort)
|
|
VALUES (23, '订单归集统计', 'oms:OmsOrder:read', 'product-list', 1, 'orderStatistic', 1, now() , 1)
|