|
马上注册,结交更多好友,享用更多功能,让你轻松玩转社区。
您需要 登录 才可以下载或查看,没有账号?注册账号
×
860[Main]升级
关闭了系统数据库连接
重新打开了系统数据库连接
开始读取升级列表
结束读取升级列表
开始事务
数据库名: UFDATA_056_2010
C:\U8SOFT\Admin\SQLFILE8600\Main\Ufdata\DSTR860_HR_HM.sql
错误信息:
-2147217900
对象'PK_hr_hi_person' 依赖于 列'cPsn_Num'。
执行如下语句时出错:
/*=============================================================*/
/* 脚本名称: U8人事信息管理8.60建库脚本 */
/* DBMS name: Microsoft SQL Server 2000 */
/* Created on: 2004-6-28 */
/* Created by: 王皓,赵勐 */
/*=============================================================*/
-----------------从851A升级到数据库860----------------------------
if not exists(select id from sysobjects where name='hr_hi_person' and type='U')
begin
-----------------从851A升级到数据库852----------------------------
--删除hr_hi_assist表 此表已去掉不再使用
if exists (select 1
from sysobjects
where id = object_id('hr_hi_assist')
and type = 'U')
drop table hr_hi_assist
---删除试图
if exists (select 1
from sysobjects
where id = object_id('hr_v_HR21')
and type = 'V')
drop view hr_v_HR21
if exists (select 1
from sysobjects
where id = object_id('hr_v_HR21_show')
and type = 'V')
drop view hr_v_HR21_show
if exists (select 1
from sysobjects
where id = object_id('hr_v_HR22')
and type = 'V')
drop view hr_v_HR22
if exists (select 1
from sysobjects
where id = object_id('hr_v_HR22_show')
and type = 'V')
drop view hr_v_HR22_show
if exists (select 1
from sysobjects
where id = object_id('hr_v_HR23')
and type = 'V')
drop view hr_v_HR23
if exists (select 1
from sysobjects
where id = object_id('hr_v_HR23_show')
and type = 'V')
drop view hr_v_HR23_show
if exists (select 1
from sysobjects
where id = object_id('hr_v_HR24')
and type = 'V')
drop view hr_v_HR24
if exists (select 1
from sysobjects
where id = object_id('hr_v_HR24_show')
and type = 'V')
drop view hr_v_HR24_show
if exists (select 1
from sysobjects
where id = object_id('hr_v_HR25')
and type = 'V')
drop view hr_v_HR25
if exists (select 1
from sysobjects
where id = object_id('hr_v_HR25_show')
and type = 'V')
drop view hr_v_HR25_show
if exists (select 1
from sysobjects
where id = object_id('hr_v_HR26')
and type = 'V')
drop view hr_v_HR26
if exists (select 1
from sysobjects
where id = object_id('hr_v_HR26_show')
and type = 'V')
drop view hr_v_HR26_show
if exists (select 1
from sysobjects
where id = object_id('hr_v_HR27')
and type = 'V')
drop view hr_v_HR27
if exists (select 1
from sysobjects
where id = object_id('hr_v_HR28')
and type = 'V')
drop view hr_v_HR28
if exists (select 1
from sysobjects
where id = object_id('hr_v_HR31')
and type = 'V')
drop view hr_v_HR31
if exists (select 1
from sysobjects
where id = object_id('hr_v_HR31_show')
and type = 'V')
drop view hr_v_HR31_show
if exists (select 1
from sysobjects
where id = object_id('hr_v_HR32')
and type = 'V')
drop view hr_v_HR32
if exists (select 1
from sysobjects
where id = object_id('hr_v_HR32_show')
and type = 'V')
drop view hr_v_HR32_show
if exists (select 1
from sysobjects
where id = object_id('hr_v_HR33')
and type = 'V')
drop view hr_v_HR33
if exists (select 1
from sysobjects
where id = object_id('hr_v_HR33_show')
and type = 'V')
drop view hr_v_HR33_show
if exists (select 1
from sysobjects
where id = object_id('hr_v_HR41')
and type = 'V')
drop view hr_v_HR41
if exists (select 1
from sysobjects
where id = object_id('hr_v_HR41_show')
and type = 'V')
drop view hr_v_HR41_show
if exists (select 1
from sysobjects
where id = object_id('hr_v_HR42')
and type = 'V')
drop view hr_v_HR42
if exists (select 1
from sysobjects
where id = object_id('hr_v_HR42_show')
and type = 'V')
drop view hr_v_HR42_show
if exists (select 1
from sysobjects
where id = object_id('hr_v_HR43')
and type = 'V')
drop view hr_v_HR43
if exists (select 1
from sysobjects
where id = object_id('hr_v_HR33_show')
and type = 'V')
drop view hr_v_HR43_show
if exists (select 1
from sysobjects
where id = object_id('hr_v_HR41')
and type = 'V')
drop view hr_v_HR41
if exists (select 1
from sysobjects
where id = object_id('hr_v_HR41_show')
and type = 'V')
drop view hr_v_HR41_show
if exists (select 1
from sysobjects
where id = object_id('hr_v_HR42')
and type = 'V')
drop view hr_v_HR42
if exists (select 1
from sysobjects
where id = object_id('hr_v_HR42_show')
and type = 'V')
drop view hr_v_HR42_show
if exists (select 1
from sysobjects
where id = object_id('hr_v_HR43')
and type = 'V')
drop view hr_v_HR33
if exists (select 1
from sysobjects
where id = object_id('hr_v_HR43_show')
and type = 'V')
drop view hr_v_HR43_show
if exists (select 1
from sysobjects
where id = object_id('hr_v_HR51')
and type = 'V')
drop view hr_v_HR51
if exists (select 1
from sysobjects
where id = object_id('hr_v_HR51_show')
and type = 'V')
drop view hr_v_HR51_show
if exists (select 1
from sysobjects
where id = object_id('hr_v_HR52')
and type = 'V')
drop view hr_v_HR52
if exists (select 1
from sysobjects
where id = object_id('hr_v_HR52_show')
and type = 'V')
drop view hr_v_HR52_show
if exists (select 1
from sysobjects
where id = object_id('hr_v_HR53')
and type = 'V')
drop view hr_v_HR53
if exists (select 1
from sysobjects
where id = object_id('hr_v_HR53_show')
and type = 'V')
drop view hr_v_HR53_show
--------------------------------职务职能---------------------------------
/*==============================================================*/
/* Database name: U8_HR_OM */
/* DBMS name: Microsoft SQL Server 2000 */
/* Created on: 2004-02-17 12:29:29 */
/*==============================================================*/
if exists (select 1
from sysobjects
where id = object_id('hr_om_calCtrl')
and type = 'U')
drop table hr_om_calCtrl
if exists (select 1
from sysobjects
where id = object_id('hr_om_changeInfo')
and type = 'U')
drop table hr_om_changeInfo
if exists (select 1
from sysobjects
where id = object_id('hr_om_corpctrl')
and type = 'U')
drop table hr_om_corpctrl
if exists (select 1
from sysobjects
where id = object_id('hr_om_deptctrl')
and type = 'U')
drop table hr_om_deptctrl
if exists (select 1
from sysobjects
where id = object_id('hr_om_duty')
and type = 'U')
drop table hr_om_duty
if exists (select 1
from sysobjects
where id = object_id('hr_om_dutydesc')
and type = 'U')
drop table hr_om_dutydesc
if exists (select 1
from sysobjects
where id = object_id('hr_om_dutygoal')
and type = 'U')
drop table hr_om_dutygoal
if exists (select 1
from sysobjects
where id = object_id('hr_om_dutypower')
and type = 'U')
drop table hr_om_dutypower
if exists (select 1
from sysobjects
where id = object_id('hr_om_dutyresp')
and type = 'U')
drop table hr_om_dutyresp
if exists (select 1
from sysobjects
where id = object_id('hr_om_equipment')
and type = 'U')
drop table hr_om_equipment
if exists (select 1
from sysobjects
where id = object_id('hr_om_job')
and type = 'U')
drop table hr_om_job
if exists (select 1
from sysobjects
where id = object_id('hr_om_jobCtrl')
and type = 'U')
drop table hr_om_jobCtrl
if exists (select 1
from sysobjects
where id = object_id('hr_om_jobcont')
and type = 'U')
drop table hr_om_jobcont
if exists (select 1
from sysobjects
where id = object_id('hr_om_jobdesc')
and type = 'U')
drop table hr_om_jobdesc
if exists (select 1
from sysobjects
where id = object_id('hr_om_jobdevpro')
and type = 'U')
drop table hr_om_jobdevpro
if exists (select 1
from sysobjects
where id = object_id('hr_om_jobgoal')
and type = 'U')
drop table hr_om_jobgoal
if exists (select 1
from sysobjects
where id = object_id('hr_om_jobpower')
and type = 'U')
drop table hr_om_jobpower
if exists (select 1
from sysobjects
where id = object_id('hr_om_jobresp')
and type = 'U')
drop table hr_om_jobresp
if exists (select 1
from sysobjects
where id = object_id('hr_om_jobsuperv')
and type = 'U')
drop table hr_om_jobsuperv
if exists (select 1
from sysobjects
where id = object_id('hr_om_jobtraining')
and type = 'U')
drop table hr_om_jobtraining
if exists (select 1
from sysobjects
where id = object_id('hr_om_succession')
and type = 'U')
drop table hr_om_succession
/*==============================================================*/
/* Table: hr_om_calCtrl */
/*==============================================================*/
create table hr_om_calCtrl (
pk_hr_om_calCtrl UFUID not null,
dyear char(4) null,
cDepCode varchar(12) null,
cJobCode varchar(20) null,
ictrlNumber int null,
iRealNumber int null,
iDiffNumber int null,
constraint PK_HR_OM_CALCTRL primary key (pk_hr_om_calCtrl)
)
|
|