mssql70_sunmis30.sql

做的比较好的人力资源管理。数据库：MS SQL 7。可以很方便的移植到MS sql SERVER 2000上

/*********************************************************/
/* 旭日企业管理系统 V2.0建立数据库 Script Program          */
/* For MS Sql Server 7.0                                 */
/*********************************************************/


/*****************************/
/* 先删除自定义存贮过程      */
/*****************************/
if exists (select * from sysobjects where id = object_id(N'[dbo].[User_adduser]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
   drop procedure [dbo].[User_adduser]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[User_dropuser]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
     drop procedure [dbo].[User_dropuser]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[User_password]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
     drop procedure [dbo].[User_password]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[User_SuperPass]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
     drop procedure [dbo].[User_SuperPass]
GO











/*****************************/
/* 删除表                    */
/*****************************/
if exists (select * from sysobjects where id = object_id(N'[dbo].[bbdm]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
   drop table [dbo].[bbdm]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[bmdm]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
   drop table [dbo].[bmdm]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[cbxm]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
   drop table [dbo].[cbxm]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[ckdm]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
   drop table [dbo].[ckdm]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[cpdm]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
   drop table [dbo].[cpdm]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[cplb]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
   drop table [dbo].[cplb]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[cplbmbcb]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
   drop table [dbo].[cplbmbcb]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[cplbsjcb]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
   drop table [dbo].[cplbsjcb]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[cppc]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
   drop table [dbo].[cppc]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[cppc_ld]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
   drop table [dbo].[cppc_ld]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[cprk]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
   drop table [dbo].[cprk]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[cprk_ld]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
   drop table [dbo].[cprk_ld]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[cprkxlh]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
   drop table [dbo].[cprkxlh]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[cprkxlh_ld]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
   drop table [dbo].[cprkxlh_ld]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[cptz]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
   drop table [dbo].[cptz]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[cptz_ld]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
   drop table [dbo].[cptz_ld]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[cpxlh]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
   drop table [dbo].[cpxlh]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[cxtjlm]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
   drop table [dbo].[cxtjlm]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[cxtjmc]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
   drop table [dbo].[cxtjmc]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[cxtjnr]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
   drop table [dbo].[cxtjnr]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[cxtjsort]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
   drop table [dbo].[cxtjsort]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[dqdm]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
   drop table [dbo].[dqdm]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[fhd]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
   drop table [dbo].[fhd]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[fhd_ld]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
   drop table [dbo].[fhd_ld]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[fhmx]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
   drop table [dbo].[fhmx]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[fhmx_ld]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
   drop table [dbo].[fhmx_ld]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[fkfs]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
   drop table [dbo].[fkfs]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[gcjd]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
   drop table [dbo].[gcjd]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[gcjd_ld]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
   drop table [dbo].[gcjd_ld]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[gcjdlj]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
   drop table [dbo].[gcjdlj]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[gcjdxlh]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
   drop table [dbo].[gcjdxlh]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[gcjdxlh_ld]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
   drop table [dbo].[gcjdxlh_ld]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[htlb]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
   drop table [dbo].[htlb]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[htmx]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
   drop table [dbo].[htmx]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[htmx_ld]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
   drop table [dbo].[htmx_ld]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[htqybm]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
   drop table [dbo].[htqybm]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[hydm]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
   drop table [dbo].[hydm]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[khda]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
   drop table [dbo].[khda]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[khda]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
   drop table [dbo].[khlb]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[khxyjb]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
   drop table [dbo].[khxyjb]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[mbcb]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
   drop table [dbo].[mbcb]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[PassWord]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
   drop table [dbo].[PassWord]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[qxqd]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
   drop table [dbo].[qxqd]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[scjdms]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
   drop table [dbo].[scjdms]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[sgdwj]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
   drop table [dbo].[sgdwj]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[sgdwj_ld]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
   drop table [dbo].[sgdwj_ld]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[sjcb]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
   drop table [dbo].[sjcb]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[skjl]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
   drop table [dbo].[skjl]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[skjl_ld]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
   drop table [dbo].[skjl_ld]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[xsd]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
   drop table [dbo].[xsd]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[xsd_ld]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
   drop table [dbo].[xsd_ld]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[xsdmx]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
   drop table [dbo].[xsdmx]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[xsdmx_ld]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
   drop table [dbo].[xsdmx_ld]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[xsht]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
   drop table [dbo].[xsht]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[xsht_ld]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
   drop table [dbo].[xsht_ld]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[xsqydm]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
   drop table [dbo].[xsqydm]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[yhk]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
   drop table [dbo].[yhk]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[yhqx]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
   drop table [dbo].[yhqx]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[yskjl]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
   drop table [dbo].[yskjl]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[yskjl_ld]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
   drop table [dbo].[yskjl_ld]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[DataVerision]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
   drop table [dbo].[DataVerision]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[Account]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
   drop table [dbo].[Account]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[SysArg]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
   drop table [dbo].[SysArg]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[wldm]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
   drop table [dbo].[wldm]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[wltz]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
   drop table [dbo].[wltz]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[wltz_ld]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
   drop table [dbo].[wltz_ld]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[wlpc]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
   drop table [dbo].[wlpc]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[wlpc_ld]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
   drop table [dbo].[wlpc_ld]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[rkdlb]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
   drop table [dbo].[rkdlb]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[fldlb]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
   drop table [dbo].[fldlb]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[wlxg]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
   drop table [dbo].[wlxg]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[wllb]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
   drop table [dbo].[wllb]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[tjxm]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
   drop table [dbo].[tjxm]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[rkd]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
   drop table [dbo].[rkd]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[rkd_ld]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
   drop table [dbo].[rkd_ld]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[rkmx]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
   drop table [dbo].[rkmx]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[rkmx_ld]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
   drop table [dbo].[rkmx_ld]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[fld]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
   drop table [dbo].[fld]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[fld_ld]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
   drop table [dbo].[fld_ld]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[flmx]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
   drop table [dbo].[flmx]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[flmx_ld]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
   drop table [dbo].[flmx_ld]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[bltz]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
   drop table [dbo].[bltz]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[slxm]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
   drop table [dbo].[slxm]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[wlhzbmc]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
   drop table [dbo].[wlhzbmc]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[wlhzwlmx]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
   drop table [dbo].[wlhzwlmx]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[cgdmain]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
   drop table [dbo].[cgdmain]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[cgdwlmx]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
   drop table [dbo].[cgdwlmx]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[cgdwlpt]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
   drop table [dbo].[cgdwlpt]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[cghtmain]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
   drop table [dbo].[cghtmain]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[cghtmx]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
   drop table [dbo].[cghtmx]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[yfk]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
   drop table [dbo].[yfk]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[yfk_ld]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
   drop table [dbo].[yfk_ld]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[sfk]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
   drop table [dbo].[sfk]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[sfk_ld]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
   drop table [dbo].[sfk_ld]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[yfktz]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
   drop table [dbo].[yfktz]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[yfktz_ld]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
   drop table [dbo].[yfktz_ld]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[gsdm]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)