WGCAT升级到v1.3.0替换文件说明
我们先停止wgcat程序服务，然后进行升级操作
1、首先 下载v1.3.0版本安装包
2、替换文件
将wgcat-release.jar，替换为新版本的文件
3、新加文件
将新版本安装包里的config/ip2region_v4.xdb文件，复制到原版本的config/目录下
4、替换守护进程文件
将wgcat-daemon-release或者wgcat-daemon-release.exe，替换为新版本的文件
5、升级数据库，补充v1.3.0版本新增的表或者字段
进入到wgcat数据库，然后执行以下的sql语句升级下数据库，这样可以在保留原有数据的基础上平滑升级
5.1 如果您原来的版本是v1.2.9，那么执行以下升级SQL语句
如果你之前使用MySQL数据库，执行如下sql升级数据库
CREATE INDEX WORK_INFO_CREATE_TIME ON WORK_INFO(CREATE_TIME);
ALTER TABLE WORK_INFO MODIFY COLUMN WORK_CODE varchar(50);
ALTER TABLE ACCOUNT_INFO ADD SKILLS_DESC varchar(300) DEFAULT NULL;

如果你之前使用PostpostSQL数据库，执行如下sql升级数据库
CREATE INDEX WORK_INFO_CREATE_TIME ON WORK_INFO(CREATE_TIME);
ALTER TABLE WORK_INFO ALTER COLUMN WORK_CODE TYPE varchar(50);
ALTER TABLE ACCOUNT_INFO ADD SKILLS_DESC varchar(300) DEFAULT NULL;

如果你之前使用Oracle数据库，执行如下sql升级数据库
CREATE INDEX WORK_INFO_CREATE_TIME ON WORK_INFO(CREATE_TIME);
ALTER TABLE WORK_INFO MODIFY  WORK_CODE VARCHAR2(50);
ALTER TABLE ACCOUNT_INFO ADD SKILLS_DESC VARCHAR2(300)  NULL;

如果你之前使用SqlServer数据库，执行如下sql升级数据库
CREATE INDEX WORK_INFO_CREATE_TIME ON WORK_INFO(CREATE_TIME);
ALTER TABLE WORK_INFO ALTER COLUMN WORK_CODE nvarchar(50);
ALTER TABLE ACCOUNT_INFO ADD SKILLS_DESC nvarchar(300)  NULL;
5.2 如果您原来的版本是v1.2.8，那么执行以下升级SQL语句
如果你之前使用MySQL数据库，执行如下sql升级数据库
ALTER TABLE WORK_INFO ADD WORK_SCORE varchar(10) DEFAULT NULL;
UPDATE WORK_INFO SET WORK_SCORE='5';
ALTER TABLE WORK_INFO MODIFY COLUMN WORK_CONTENT varchar(4000);
CREATE INDEX WORK_INFO_CREATE_TIME ON WORK_INFO(CREATE_TIME);
ALTER TABLE WORK_INFO MODIFY COLUMN WORK_CODE varchar(50);
ALTER TABLE ACCOUNT_INFO ADD SKILLS_DESC varchar(300) DEFAULT NULL;

如果你之前使用PostpostSQL数据库，执行如下sql升级数据库
ALTER TABLE WORK_INFO ADD WORK_SCORE varchar(10) DEFAULT NULL;
UPDATE WORK_INFO SET WORK_SCORE='5';
ALTER TABLE WORK_INFO ALTER COLUMN WORK_CONTENT TYPE varchar(4000);
CREATE INDEX WORK_INFO_CREATE_TIME ON WORK_INFO(CREATE_TIME);
ALTER TABLE WORK_INFO ALTER COLUMN WORK_CODE TYPE varchar(50);
ALTER TABLE ACCOUNT_INFO ADD SKILLS_DESC varchar(300) DEFAULT NULL;

如果你之前使用Oracle数据库，执行如下sql升级数据库
ALTER TABLE WORK_INFO ADD WORK_SCORE VARCHAR2(10)  NULL;
UPDATE WORK_INFO SET WORK_SCORE='5';
ALTER TABLE WORK_INFO MODIFY  WORK_CONTENT VARCHAR2(4000);
CREATE INDEX WORK_INFO_CREATE_TIME ON WORK_INFO(CREATE_TIME);
ALTER TABLE WORK_INFO MODIFY  WORK_CODE VARCHAR2(50);
ALTER TABLE ACCOUNT_INFO ADD SKILLS_DESC VARCHAR2(300)  NULL;

如果你之前使用SqlServer数据库，执行如下sql升级数据库
ALTER TABLE WORK_INFO ADD WORK_SCORE nvarchar(10)  NULL;
ALTER TABLE WORK_INFO ALTER COLUMN WORK_CONTENT nvarchar(4000);
UPDATE WORK_INFO SET WORK_LEVEL='5';
CREATE INDEX WORK_INFO_CREATE_TIME ON WORK_INFO(CREATE_TIME);
ALTER TABLE WORK_INFO ALTER COLUMN WORK_CODE nvarchar(50);
ALTER TABLE ACCOUNT_INFO ADD SKILLS_DESC nvarchar(300)  NULL;
5.3 如果您原来的版本是v1.2.4、v1.2.5、v1.2.6、v1.2.7，那么执行以下升级SQL语句
如果你之前使用MySQL数据库，执行如下sql升级数据库
ALTER TABLE WORK_INFO ADD WORK_LEVEL varchar(10) DEFAULT NULL;
ALTER TABLE WORK_INFO ADD WORK_PRIVATE varchar(10) DEFAULT NULL;
UPDATE WORK_INFO SET WORK_LEVEL='中';
UPDATE WORK_INFO SET WORK_PRIVATE='2';
ALTER TABLE WORK_INFO ADD WORK_SCORE varchar(10) DEFAULT NULL;
UPDATE WORK_INFO SET WORK_SCORE='5';
ALTER TABLE WORK_INFO MODIFY COLUMN WORK_CONTENT varchar(4000);
CREATE INDEX WORK_INFO_CREATE_TIME ON WORK_INFO(CREATE_TIME);
ALTER TABLE WORK_INFO MODIFY COLUMN WORK_CODE varchar(50);
ALTER TABLE ACCOUNT_INFO ADD SKILLS_DESC varchar(300) DEFAULT NULL;

如果你之前使用PostpostSQL数据库，执行如下sql升级数据库
ALTER TABLE WORK_INFO ADD WORK_LEVEL varchar(10) DEFAULT NULL;
ALTER TABLE WORK_INFO ADD WORK_PRIVATE varchar(10) DEFAULT NULL;
UPDATE WORK_INFO SET WORK_LEVEL='中';
UPDATE WORK_INFO SET WORK_PRIVATE='2';
ALTER TABLE WORK_INFO ADD WORK_SCORE varchar(10) DEFAULT NULL;
UPDATE WORK_INFO SET WORK_SCORE='5';
ALTER TABLE WORK_INFO ALTER COLUMN WORK_CONTENT TYPE varchar(4000);
CREATE INDEX WORK_INFO_CREATE_TIME ON WORK_INFO(CREATE_TIME);
ALTER TABLE WORK_INFO ALTER COLUMN WORK_CODE TYPE varchar(50);
ALTER TABLE ACCOUNT_INFO ADD SKILLS_DESC varchar(300) DEFAULT NULL;

如果你之前使用Oracle数据库，执行如下sql升级数据库
ALTER TABLE WORK_INFO ADD WORK_LEVEL VARCHAR2(10)  NULL;
ALTER TABLE WORK_INFO ADD WORK_PRIVATE VARCHAR2(10)  NULL;
UPDATE WORK_INFO SET WORK_LEVEL='中';
UPDATE WORK_INFO SET WORK_PRIVATE='2';
ALTER TABLE WORK_INFO ADD WORK_SCORE VARCHAR2(10)  NULL;
UPDATE WORK_INFO SET WORK_SCORE='5';
ALTER TABLE WORK_INFO MODIFY  WORK_CONTENT VARCHAR2(4000);
CREATE INDEX WORK_INFO_CREATE_TIME ON WORK_INFO(CREATE_TIME);
ALTER TABLE WORK_INFO MODIFY  WORK_CODE VARCHAR2(50);
ALTER TABLE ACCOUNT_INFO ADD SKILLS_DESC VARCHAR2(300)  NULL;

如果你之前使用SqlServer数据库，执行如下sql升级数据库
ALTER TABLE WORK_INFO ADD WORK_LEVEL nvarchar(10)  NULL;
ALTER TABLE WORK_INFO ADD WORK_PRIVATE nvarchar(10)  NULL;
UPDATE WORK_INFO SET WORK_LEVEL='中';
UPDATE WORK_INFO SET WORK_PRIVATE='2';
ALTER TABLE WORK_INFO ADD WORK_SCORE nvarchar(10)  NULL;
ALTER TABLE WORK_INFO ALTER COLUMN WORK_CONTENT nvarchar(4000);
UPDATE WORK_INFO SET WORK_LEVEL='5';
CREATE INDEX WORK_INFO_CREATE_TIME ON WORK_INFO(CREATE_TIME);
ALTER TABLE WORK_INFO ALTER COLUMN WORK_CODE nvarchar(50);
ALTER TABLE ACCOUNT_INFO ADD SKILLS_DESC nvarchar(300)  NULL;
5.4 如果您的原来版本是v1.2.3，那么执行以下升级SQL语句
如果你之前使用MySQL数据库，执行如下sql升级数据库
ALTER TABLE WORK_INFO ADD WORK_CODE int(11) DEFAULT NULL;
ALTER TABLE WORK_INFO ADD WORK_LEVEL varchar(10) DEFAULT NULL;
ALTER TABLE WORK_INFO ADD WORK_PRIVATE varchar(10) DEFAULT NULL;
UPDATE WORK_INFO SET WORK_LEVEL='中';
UPDATE WORK_INFO SET WORK_PRIVATE='2';
ALTER TABLE WORK_INFO ADD WORK_SCORE varchar(10) DEFAULT NULL;
UPDATE WORK_INFO SET WORK_SCORE='5';
ALTER TABLE WORK_INFO MODIFY COLUMN WORK_CONTENT varchar(4000);
CREATE INDEX WORK_INFO_CREATE_TIME ON WORK_INFO(CREATE_TIME);
ALTER TABLE WORK_INFO MODIFY COLUMN WORK_CODE varchar(50);
ALTER TABLE ACCOUNT_INFO ADD SKILLS_DESC varchar(300) DEFAULT NULL;
如果你之前使用PostpostSQL数据库，执行如下sql升级数据库
ALTER TABLE WORK_INFO ADD WORK_CODE int8;
ALTER TABLE WORK_INFO ADD WORK_LEVEL varchar(10) DEFAULT NULL;
ALTER TABLE WORK_INFO ADD WORK_PRIVATE varchar(10) DEFAULT NULL;
UPDATE WORK_INFO SET WORK_LEVEL='中';
UPDATE WORK_INFO SET WORK_PRIVATE='2';
ALTER TABLE WORK_INFO ADD WORK_SCORE varchar(10) DEFAULT NULL;
UPDATE WORK_INFO SET WORK_SCORE='5';
ALTER TABLE WORK_INFO ALTER COLUMN WORK_CONTENT TYPE varchar(4000);
CREATE INDEX WORK_INFO_CREATE_TIME ON WORK_INFO(CREATE_TIME);
ALTER TABLE WORK_INFO ALTER COLUMN WORK_CODE TYPE varchar(50);
ALTER TABLE ACCOUNT_INFO ADD SKILLS_DESC varchar(300) DEFAULT NULL;
如果你之前使用Oracle数据库，执行如下sql升级数据库
ALTER TABLE WORK_INFO ADD WORK_CODE NUMBER(11) NULL;
ALTER TABLE WORK_INFO ADD WORK_LEVEL VARCHAR2(10)  NULL;
ALTER TABLE WORK_INFO ADD WORK_PRIVATE VARCHAR2(10)  NULL;
UPDATE WORK_INFO SET WORK_LEVEL='中';
UPDATE WORK_INFO SET WORK_PRIVATE='2';
ALTER TABLE WORK_INFO ADD WORK_SCORE VARCHAR2(10)  NULL;
UPDATE WORK_INFO SET WORK_SCORE='5';
ALTER TABLE WORK_INFO MODIFY  WORK_CONTENT VARCHAR2(4000);
CREATE INDEX WORK_INFO_CREATE_TIME ON WORK_INFO(CREATE_TIME);
ALTER TABLE WORK_INFO MODIFY  WORK_CODE VARCHAR2(50);
ALTER TABLE ACCOUNT_INFO ADD SKILLS_DESC VARCHAR2(300)  NULL;
如果你之前使用SqlServer数据库，执行如下sql升级数据库
ALTER TABLE WORK_INFO ADD WORK_CODE int  NULL;
ALTER TABLE WORK_INFO ADD WORK_LEVEL nvarchar(10)  NULL;
ALTER TABLE WORK_INFO ADD WORK_PRIVATE nvarchar(10)  NULL;
UPDATE WORK_INFO SET WORK_LEVEL='中';
UPDATE WORK_INFO SET WORK_PRIVATE='2';
ALTER TABLE WORK_INFO ADD WORK_SCORE nvarchar(10)  NULL;
ALTER TABLE WORK_INFO ALTER COLUMN WORK_CONTENT nvarchar(4000);
UPDATE WORK_INFO SET WORK_LEVEL='5';
CREATE INDEX WORK_INFO_CREATE_TIME ON WORK_INFO(CREATE_TIME);
ALTER TABLE WORK_INFO ALTER COLUMN WORK_CODE nvarchar(50);
ALTER TABLE ACCOUNT_INFO ADD SKILLS_DESC nvarchar(300)  NULL;
5.5 如果您的原来版本是v1.2.2或者之前的版本，那么执行以下升级SQL语句
如果你之前使用MySQL数据库，执行如下sql升级数据库
ALTER TABLE WORK_INFO ADD WORK_CODE int(11) DEFAULT NULL;
ALTER TABLE WORK_INFO ADD GROUP_ID varchar(500) DEFAULT NULL;
ALTER TABLE WORK_INFO ADD WORK_LEVEL varchar(10) DEFAULT NULL;
ALTER TABLE WORK_INFO ADD WORK_PRIVATE varchar(10) DEFAULT NULL;
UPDATE WORK_INFO SET WORK_LEVEL='中';
UPDATE WORK_INFO SET WORK_PRIVATE='2';
ALTER TABLE WORK_INFO ADD WORK_SCORE varchar(10) DEFAULT NULL;
UPDATE WORK_INFO SET WORK_SCORE='5';
ALTER TABLE WORK_INFO MODIFY COLUMN WORK_CONTENT varchar(4000);
CREATE INDEX WORK_INFO_CREATE_TIME ON WORK_INFO(CREATE_TIME);
ALTER TABLE WORK_INFO MODIFY COLUMN WORK_CODE varchar(50);
ALTER TABLE ACCOUNT_INFO ADD SKILLS_DESC varchar(300) DEFAULT NULL;
如果你之前使用PostpostSQL数据库，执行如下sql升级数据库
ALTER TABLE WORK_INFO ADD WORK_CODE int8;
ALTER TABLE WORK_INFO ADD GROUP_ID varchar(500) DEFAULT NULL;
ALTER TABLE WORK_INFO ADD WORK_LEVEL varchar(10) DEFAULT NULL;
ALTER TABLE WORK_INFO ADD WORK_PRIVATE varchar(10) DEFAULT NULL;
UPDATE WORK_INFO SET WORK_LEVEL='中';
UPDATE WORK_INFO SET WORK_PRIVATE='2';
ALTER TABLE WORK_INFO ADD WORK_SCORE varchar(10) DEFAULT NULL;
UPDATE WORK_INFO SET WORK_SCORE='5';
ALTER TABLE WORK_INFO ALTER COLUMN WORK_CONTENT TYPE varchar(4000);
CREATE INDEX WORK_INFO_CREATE_TIME ON WORK_INFO(CREATE_TIME);
ALTER TABLE WORK_INFO ALTER COLUMN WORK_CODE TYPE varchar(50);
ALTER TABLE ACCOUNT_INFO ADD SKILLS_DESC varchar(300) DEFAULT NULL;
如果你之前使用Oracle数据库，执行如下sql升级数据库
ALTER TABLE WORK_INFO ADD WORK_CODE NUMBER(11) NULL;
ALTER TABLE WORK_INFO ADD GROUP_ID VARCHAR2(500)  NULL;
ALTER TABLE WORK_INFO ADD WORK_LEVEL VARCHAR2(10)  NULL;
ALTER TABLE WORK_INFO ADD WORK_PRIVATE VARCHAR2(10)  NULL;
UPDATE WORK_INFO SET WORK_LEVEL='中';
UPDATE WORK_INFO SET WORK_PRIVATE='2';
ALTER TABLE WORK_INFO ADD WORK_SCORE VARCHAR2(10)  NULL;
UPDATE WORK_INFO SET WORK_SCORE='5';
ALTER TABLE WORK_INFO MODIFY  WORK_CONTENT VARCHAR2(4000);
CREATE INDEX WORK_INFO_CREATE_TIME ON WORK_INFO(CREATE_TIME);
ALTER TABLE WORK_INFO MODIFY  WORK_CODE VARCHAR2(50);
ALTER TABLE ACCOUNT_INFO ADD SKILLS_DESC VARCHAR2(300)  NULL;
如果你之前使用SqlServer数据库，执行如下sql升级数据库
ALTER TABLE WORK_INFO ADD WORK_CODE int  NULL;
ALTER TABLE WORK_INFO ADD GROUP_ID nvarchar(500)  NULL;
ALTER TABLE WORK_INFO ADD WORK_LEVEL nvarchar(10)  NULL;
ALTER TABLE WORK_INFO ADD WORK_PRIVATE nvarchar(10)  NULL;
UPDATE WORK_INFO SET WORK_LEVEL='中';
UPDATE WORK_INFO SET WORK_PRIVATE='2';
ALTER TABLE WORK_INFO ADD WORK_SCORE nvarchar(10)  NULL;
ALTER TABLE WORK_INFO ALTER COLUMN WORK_CONTENT nvarchar(4000);
UPDATE WORK_INFO SET WORK_LEVEL='5';
CREATE INDEX WORK_INFO_CREATE_TIME ON WORK_INFO(CREATE_TIME);
ALTER TABLE WORK_INFO ALTER COLUMN WORK_CODE nvarchar(50);
ALTER TABLE ACCOUNT_INFO ADD SKILLS_DESC nvarchar(300)  NULL;
MySQL导入、导出sql文件的命令参考
或者也可以复制sql语句到 数据库客户端工具中执行，可在保留原有数据基础上平滑升级
WGCAT工单系统导入升级sql文件
除以上外，其他文件都不用替换，然后重启wgcat程序就好了
升级完成