您当前的位置:首页 > Gogo人才网系统ASP版 > 产品资讯 > 正文

GOGO人才网系统ASP版(老版)升级NET版指南

发布时间:2012年06月01日23时01分  作者:佚名  来源:本站原创  点击次数:6066

升级前请保证您的GOGO人才网系统ASP版为正式版,且版本号在1.9以上,版本低于1.9的用户请先自行升级ASP版至1.9。本文档的升级说明只针对注册用户数据进行,所以网站文章、网站配置等信息并不在升级范围内,也就是说升级后NET版系统内只保留原ASP版的注册用户相关数据。

一、登录两个系统后台,用手工操作的方式将ASP版的职位列表、地区列表、专业列表、公司类别列表信息同步至NET版的对应字典中。

 

 

二、对ASP版的in_user表进行如下修改

id设置为主键

插入字段emailok(文本)

lock 改为 ulock

插入 viptime(时间)

ltime 改为 rtime

删除IP

插入 ukill  (是否\逻辑)

插入 codetype (文本)

修改bdate为时间日期格式

插入 hka2 (文本)

插入 hkb2 (文本)

zhuanyen1改为zhuanyen

zyes改为zye2

language改为language1

lanlevel改为lanlevel1

languages改为language2

lanlevels改为lanlevel2

插入 gzdd2 (文本)

gzcs改为gzdsm

删除gzcs1

oicq改为qq

删除paytime

删除paydates

添加reserve1(文本)

添加reserve2(文本)

添加reserve3(文本)

添加reserve4(文本)

添加reserve5(文本)

 

逐行执行以下SQL指令

update gogo_inuser set emailok='00000000000000000000'

update gogo_inuser set viptime='2000-01-01 00:00:00'  where viptime is null

update gogo_inuser set rtime=rdate  where rtime is null

update gogo_inuser set clicks=0  where clicks is null

update gogo_inuser set coin=0  where coin is null

update gogo_inuser set show=true  where show is null

update gogo_inuser set att=false  where att is null

update gogo_inuser set about=''  where about is null

update gogo_inuser set ukill=false

update gogo_inuser set name=''  where name is null

update gogo_inuser set codetype='身份证'

update gogo_inuser set code=''  where code is null

update gogo_inuser set bdate='1900-01-01 00:00:00'  where bdate is null

update gogo_inuser set sex=''  where sex is null

update gogo_inuser set guoji=''  where guoji is null

update gogo_inuser set guoji='中国大陆'  where guoji='中国'

update gogo_inuser set shenggao=''  where shenggao is null

update gogo_inuser set tizhong=''  where tizhong is null

update gogo_inuser set minzu=''  where minzu is null

update gogo_inuser set minzu=minzu+''  where minzu<>'' and right(minzu,1)<>''

update gogo_inuser set marry=''  where marry is null

update gogo_inuser set hka=''  where hka is null

update gogo_inuser set hka2=''  where hka2 is null

update gogo_inuser set hkb=''  where hkb is null

update gogo_inuser set hkb2=''  where hkb2 is null

update gogo_inuser set edu=''  where edu is null

update gogo_inuser set edu='博士及以上'  where edu='博士'

update gogo_inuser set zye=''  where zye is null

update gogo_inuser set zye='其他类别'  where zye=''

update gogo_inuser set zhuanyen=''  where zhuanyen is null

update gogo_inuser set zye2=''  where zye2 is null

update gogo_inuser set zhuanyen2=''  where zhuanyen2 is null

update gogo_inuser set school=''  where school is null

update gogo_inuser set bydate=''  where bydate is null

update gogo_inuser set zzmm=''  where zzmm is null

update gogo_inuser set zzmm='中共党员'  where zzmm='党员'

update gogo_inuser set zcheng=''  where zcheng is null

update gogo_inuser set zcheng=''  where zcheng='暂无'

update gogo_inuser set jyjl=''  where jyjl is null

update gogo_inuser set rctype=''  where rctype is null

update gogo_inuser set language1=''  where language1 is null

update gogo_inuser set lanlevel1=''  where lanlevel1 is null

update gogo_inuser set language2=''  where language2 is null

update gogo_inuser set lanlevel2=''  where lanlevel2 is null

update gogo_inuser set pthua=''  where pthua is null

update gogo_inuser set computer=''  where computer is null

update gogo_inuser set kgzjl=''  where kgzjl is null

update gogo_inuser set gznum=''  where gznum is null

update gogo_inuser set kothertc=''  where kothertc is null

update gogo_inuser set kmubiao=''  where kmubiao is null

update gogo_inuser set jobtype=''  where jobtype is null

update gogo_inuser set job=''  where job is null

update gogo_inuser set job1=''  where job1 is null

update gogo_inuser set job2=''  where job2 is null

update gogo_inuser set job3=''  where job3 is null

update gogo_inuser set job4=''  where job4 is null

update gogo_inuser set job5=''  where job5 is null

update gogo_inuser set gzdd=''  where gzdd is null

update gogo_inuser set gzdd2=''  where gzdd2 is null

update gogo_inuser set gzdsm=''  where gzdsm is null

update gogo_inuser set yuex=''  where yuex is null

update gogo_inuser set grzz=''  where grzz is null

update gogo_inuser set address=''  where address is null

update gogo_inuser set posts=''  where posts is null

update gogo_inuser set phone=''  where phone is null

update gogo_inuser set shouji=''  where shouji is null

update gogo_inuser set qq=''  where qq is null

update gogo_inuser set web=''  where web is null

update gogo_inuser set pic=''  where pic is null

update gogo_inuser set pic='\in_pic\'+right(pic,len(pic)-7) where pic<>''

update gogo_inuser set reserve1=''  where reserve1 is null

update gogo_inuser set reserve2=''  where reserve2 is null

update gogo_inuser set reserve3=''  where reserve3 is null

update gogo_inuser set reserve4=''  where reserve4 is null

update gogo_inuser set reserve5=''  where reserve5 is null

 

 

三、对ASP版的en_user表进行如下修改

新增emailok (文本)

插入 viptime (时间)

lock 改为 ulock

ltime改为 rtime

删除ip

插入 show  (是否\逻辑)

插入 ukill (是否\逻辑)

插入 area2 (文本)

插入 qq   (文本)

删除paytime

删除paydates

添加reserve1(文本)

添加reserve2(文本)

添加reserve3(文本)

添加reserve4(文本)

添加reserve5(文本)

 

逐行执行以下SQL指令

update gogo_enuser set emailok='00000000000000000000'

update gogo_enuser set viptime='2000-01-01 00:00:00'  where viptime is null

update gogo_enuser set rtime=rdate  where rtime is null

update gogo_enuser set clicks=0  where clicks is null

update gogo_enuser set coin=0  where coin is null

update gogo_enuser set show=true

update gogo_enuser set att=false  where att is null

update gogo_enuser set about=''  where about is null

update gogo_enuser set ukill=false

update gogo_enuser set name=''  where name is null

update gogo_enuser set trade=''  where trade is null

update gogo_enuser set cxz=''  where cxz is null

update gogo_enuser set fund=''  where fund is null

update gogo_enuser set yuangong=''  where yuangong is null

update gogo_enuser set area=''  where area is null

update gogo_enuser set area2=''  where area2 is null

update gogo_enuser set faren=''  where faren is null

update gogo_enuser set fdate=''  where fdate is null

update gogo_enuser set jianj=''  where jianj is null

update gogo_enuser set address=''  where address is null

update gogo_enuser set zip=''  where zip is null

update gogo_enuser set pname=''  where pname is null

update gogo_enuser set pnames=''  where pnames is null

update gogo_enuser set phone=''  where phone is null

update gogo_enuser set fax=''  where fax is null

update gogo_enuser set renshi=''  where renshi is null

update gogo_enuser set sex=''  where sex is null

update gogo_enuser set rstel=''  where rstel is null

update gogo_enuser set qq=''  where qq is null

update gogo_enuser set web=''  where web is null

update gogo_enuser set pic=''  where pic is null

update gogo_enuser set pic='\en_pic\'+right(pic,len(pic)-7) where pic<>''

update gogo_enuser set reserve1=''  where reserve1 is null

update gogo_enuser set reserve2=''  where reserve2 is null

update gogo_enuser set reserve3=''  where reserve3 is null

update gogo_enuser set reserve4=''  where reserve4 is null

update gogo_enuser set reserve5=''  where reserve5 is null

 

 

四、对ASP版的message表进行如下修改

content改为mcontent

 

逐行执行以下SQL指令

update gogo_message set ttype=‘in’ where ttype=‘1’

update gogo_message set ttype=‘en’ where ttype=‘2’

update gogo_message set ttype=‘sy’ where ttype=‘0’

update gogo_message set ftype=‘in’ where ftype=‘1’

update gogo_message set ftype=‘en’ where ftype=‘2’

update gogo_message set ftype=‘sy’ where ftype=‘0’

 

 

 

五、对ASP版的job表进行如下修改

插入att (是否\逻辑)

插入show (是否\逻辑)

插入clicks (整数)

插入hka2 (文本)

插入 hkas2 (文本)

插入 hkbs2 (文本)

添加reserve1(文本)

添加reserve2(文本)

添加reserve3(文本)

添加reserve4(文本)

添加reserve5(文本)

 

逐行执行以下SQL指令

update gogo_job set att=false

update gogo_job set show=true

update gogo_job set clicks=0

update gogo_job set job=''  where job is null

update gogo_job set jtzw=''  where jtzw is null

update gogo_job set hka=''  where hka is null

update gogo_job set hka2=''  where hka2 is null

update gogo_job set city=''  where city is null

update gogo_job set zpnum=''  where zpnum is null

update gogo_job set nianlings=''  where nianlings is null

update gogo_job set zyes=''  where zyes is null

update gogo_job set hkas=''  where hkas is null

update gogo_job set hkas2=''  where hkas2 is null

update gogo_job set edus=''  where edus is null

update gogo_job set hkbs=''  where hkbs is null

update gogo_job set hkbs2=''  where hkbs2 is null

update gogo_job set languages=''  where languages is null

update gogo_job set pthuas=''  where pthuas is null

update gogo_job set sexs=''  where sexs is null

update gogo_job set jobtypes=''  where jobtypes is null

update gogo_job set marrys=''  where marrys is null

update gogo_job set computers=''  where computers is null

update gogo_job set shisus=''  where shisus is null

update gogo_job set moneys=''  where moneys is null

update gogo_job set youxiaos=''  where youxiaos is null

update gogo_job set zptext=''  where zptext is null

update gogo_job set reserve1=''  where reserve1 is null

update gogo_job set reserve2=''  where reserve2 is null

update gogo_job set reserve3=''  where reserve3 is null

update gogo_job set reserve4=''  where reserve4 is null

update gogo_job set reserve5=''  where reserve5 is null

 

 

六、对ASP版的indepot表进行如下修改

插入bz (文本)

 

执行以下SQL指令

update gogo_indepot set bz=''

 

 

七、对ASP版的endepot表进行如下修改

插入bz (文本)

 

执行以下SQL指令

update gogo_endepot set bz=''

 

 

八、将ASP版上面修改过的表进行重命名,表名前统一加“gogo_

inuser 改为gogo_inuser(个人会员信息表)

enuser改为gogo_enuser(企业会员信息表)

message改为gogo_message(会员站内信息表)

job改为gogo_job(企业岗位信息表)

indepot改为gogo_indepot(个人的岗位库表)

endepot改为gogo_endepot(企业的人才库表)

 

 

九、删除NET版数据库内的以下表:

gogo_inuser(个人会员信息表)

gogo_enuser(企业会员信息表)

gogo_message(会员站内信息表)

gogo_job(企业岗位信息表)

gogo_indepot(个人的岗位库表)

gogo_endepot(企业的人才库表)

 

 

十、将ASP版数据库修改过的表复制(导入、拖拽)至NET版数据库中

gogo_inuser(个人会员信息表)

gogo_enuser(企业会员信息表)

gogo_message(会员站内信息表)

gogo_job(企业岗位信息表)

gogo_indepot(个人的岗位库表)

gogo_endepot(企业的人才库表)

SQLSERVER数据库还需手工将上述表的ID字段标识属性设置为“是”,增量1(默认)

 

十一、将ASP版主目录下的in_picen_pic两个文件夹复制进NET版主目录下进行替换

 

十二、登录NET版后台,进行网站信息配置、管理员添加等操作,并对整站功能进行测试,特别是涉及会员的功能。

 

至此,升级完成。

 

 

 

相关阅读:
效能管理系统web应用程序1.0.2升级说明 05-14
效能管理系统1.0.1整合升级说明 04-09
GOGO人才网系统NET版1.0.1.2版本升级说明 02-17
GOGO人才网系统NET版1.0.1.1版本升级说明 12-12
GOGO人才网系统NET版1.0.1.0版本升级说明 07-29
■ 最新推荐 > >
探索者互联网舆情系统介绍
效能管理系统介绍
跳转至Gogo人才网系统NET版
Gogo工作室介绍
■ 近期热点 > >

GOGO工作室 Copyright 2005-2018 All Rights Reserved

备案序号:滇ICP备05008799号