数据库生成脚本.txt

pb工资管理程序,有各种图标

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

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

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

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

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

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

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

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

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

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

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

CREATE TABLE [dbo].[ca_emp] (
	[id] [char] (6) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[china_name] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[english_name] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[age] [char] (2) COLLATE Chinese_PRC_CI_AS NULL ,
	[sex] [char] (4) COLLATE Chinese_PRC_CI_AS NULL ,
	[marry] [char] (4) COLLATE Chinese_PRC_CI_AS NULL ,
	[address] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[telephone] [char] (15) COLLATE Chinese_PRC_CI_AS NULL ,
	[zipcode] [char] (6) COLLATE Chinese_PRC_CI_AS NULL ,
	[reson] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[title] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[plevel] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[department] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[status] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[salary] [money] NULL ,
	[rz_date] [datetime] NULL ,
	[degreeno] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[bankno] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[password1] [char] (6) COLLATE Chinese_PRC_CI_AS NULL ,
	[shop_id] [char] (6) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[pay] (
	[mdate] [datetime] NULL ,
	[id] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[cqts] [char] (2) COLLATE Chinese_PRC_CI_AS NULL ,
	[tc] [decimal](8, 2) NULL ,
	[qqj] [decimal](8, 0) NULL ,
	[bt] [decimal](19, 4) NULL ,
	[yxygj] [decimal](19, 4) NULL ,
	[mrzbj] [decimal](19, 4) NULL ,
	[syjy] [decimal](19, 4) NULL ,
	[gytk] [decimal](19, 4) NULL ,
	[jkyk] [decimal](19, 4) NULL ,
	[pdyk] [decimal](19, 4) NULL ,
	[gykk] [decimal](19, 4) NULL ,
	[qtkk] [decimal](19, 4) NULL ,
	[yfdx] [decimal](19, 4) NULL ,
	[yfs] [decimal](19, 4) NULL ,
	[zkk] [decimal](19, 4) NULL ,
	[sfs] [decimal](19, 4) NULL ,
	[zjtk] [decimal](19, 4) NULL ,
	[cbf] [decimal](19, 4) NULL ,
	[shop_id] [char] (6) COLLATE Chinese_PRC_CI_AS NULL ,
	[cbj] [decimal](18, 0) NULL ,
	[zjkk] [decimal](18, 0) NULL ,
	[sb] [decimal](18, 0) NULL ,
	[fk] [decimal](18, 0) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[pbcatcol] (
	[pbc_tnam] [char] (129) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[pbc_tid] [int] NULL ,
	[pbc_ownr] [char] (129) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[pbc_cnam] [char] (129) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[pbc_cid] [smallint] NULL ,
	[pbc_labl] [varchar] (254) COLLATE Chinese_PRC_CI_AS NULL ,
	[pbc_lpos] [smallint] NULL ,
	[pbc_hdr] [varchar] (254) COLLATE Chinese_PRC_CI_AS NULL ,
	[pbc_hpos] [smallint] NULL ,
	[pbc_jtfy] [smallint] NULL ,
	[pbc_mask] [varchar] (31) COLLATE Chinese_PRC_CI_AS NULL ,
	[pbc_case] [smallint] NULL ,
	[pbc_hght] [smallint] NULL ,
	[pbc_wdth] [smallint] NULL ,
	[pbc_ptrn] [varchar] (31) COLLATE Chinese_PRC_CI_AS NULL ,
	[pbc_bmap] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[pbc_init] [varchar] (254) COLLATE Chinese_PRC_CI_AS NULL ,
	[pbc_cmnt] [varchar] (254) COLLATE Chinese_PRC_CI_AS NULL ,
	[pbc_edit] [varchar] (31) COLLATE Chinese_PRC_CI_AS NULL ,
	[pbc_tag] [varchar] (254) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[pbcatedt] (
	[pbe_name] [varchar] (30) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[pbe_edit] [varchar] (254) COLLATE Chinese_PRC_CI_AS NULL ,
	[pbe_type] [smallint] NULL ,
	[pbe_cntr] [int] NULL ,
	[pbe_seqn] [smallint] NOT NULL ,
	[pbe_flag] [int] NULL ,
	[pbe_work] [char] (32) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[pbcatfmt] (
	[pbf_name] [varchar] (30) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[pbf_frmt] [varchar] (254) COLLATE Chinese_PRC_CI_AS NULL ,
	[pbf_type] [smallint] NULL ,
	[pbf_cntr] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[pbcattbl] (
	[pbt_tnam] [char] (129) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[pbt_tid] [int] NULL ,
	[pbt_ownr] [char] (129) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[pbd_fhgt] [smallint] NULL ,
	[pbd_fwgt] [smallint] NULL ,
	[pbd_fitl] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[pbd_funl] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[pbd_fchr] [smallint] NULL ,
	[pbd_fptc] [smallint] NULL ,
	[pbd_ffce] [char] (18) COLLATE Chinese_PRC_CI_AS NULL ,
	[pbh_fhgt] [smallint] NULL ,
	[pbh_fwgt] [smallint] NULL ,
	[pbh_fitl] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[pbh_funl] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[pbh_fchr] [smallint] NULL ,
	[pbh_fptc] [smallint] NULL ,
	[pbh_ffce] [char] (18) COLLATE Chinese_PRC_CI_AS NULL ,
	[pbl_fhgt] [smallint] NULL ,
	[pbl_fwgt] [smallint] NULL ,
	[pbl_fitl] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[pbl_funl] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[pbl_fchr] [smallint] NULL ,
	[pbl_fptc] [smallint] NULL ,
	[pbl_ffce] [char] (18) COLLATE Chinese_PRC_CI_AS NULL ,
	[pbt_cmnt] [varchar] (254) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[pbcatvld] (
	[pbv_name] [varchar] (30) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[pbv_vald] [varchar] (254) COLLATE Chinese_PRC_CI_AS NULL ,
	[pbv_type] [smallint] NULL ,
	[pbv_cntr] [int] NULL ,
	[pbv_msg] [varchar] (254) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[popedom] (
	[id] [char] (6) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[emp] [char] (1) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[pay2] [char] (1) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[title] [char] (1) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[gzb] [char] (1) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[password] [char] (1) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[passwordset] [char] (1) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[setpopedom] [char] (1) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[setbackup] [char] (1) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[comeback] [char] (1) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[clear] [char] (1) COLLATE Chinese_PRC_CI_AS NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[temp] (
	[no] [char] (5) COLLATE Chinese_PRC_CI_AS NULL ,
	[姓名] [char] (8) COLLATE Chinese_PRC_CI_AS NULL ,
	[性别] [char] (2) COLLATE Chinese_PRC_CI_AS NULL ,
	[年龄] [char] (2) COLLATE Chinese_PRC_CI_AS NULL ,
	[籍贯] [char] (12) COLLATE Chinese_PRC_CI_AS NULL ,
	[文化程度] [char] (4) COLLATE Chinese_PRC_CI_AS NULL ,
	[职位] [char] (8) COLLATE Chinese_PRC_CI_AS NULL ,
	[底薪] [decimal](18, 0) NULL ,
	[联系电话] [char] (12) COLLATE Chinese_PRC_CI_AS NULL ,
	[身份证号码] [char] (18) COLLATE Chinese_PRC_CI_AS NULL ,
	[现住] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[家庭住址] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[婚否] [char] (2) COLLATE Chinese_PRC_CI_AS NULL ,
	[部门] [char] (8) COLLATE Chinese_PRC_CI_AS NULL ,
	[帐号] [char] (18) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[title] (
	[title_id] [char] (2) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[title_name] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[userid] (
	[id] [char] (6) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[user_name] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[password] [char] (6) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[plevel] [char] (1) COLLATE Chinese_PRC_CI_AS NOT NULL 
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[pay] WITH NOCHECK ADD 
	CONSTRAINT [IX_pay] UNIQUE  CLUSTERED 
	(
		[id],
		[mdate]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[title] WITH NOCHECK ADD 
	CONSTRAINT [IX_title] UNIQUE  CLUSTERED 
	(
		[title_id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[userid] WITH NOCHECK ADD 
	CONSTRAINT [IX_user] UNIQUE  CLUSTERED 
	(
		[id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[ca_emp] WITH NOCHECK ADD 
	CONSTRAINT [IX_ca_emp] UNIQUE  NONCLUSTERED 
	(
		[id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[popedom] WITH NOCHECK ADD 
	CONSTRAINT [IX_popedom] UNIQUE  NONCLUSTERED 
	(
		[id]
	)  ON [PRIMARY] 
GO

 CREATE  UNIQUE  INDEX [pbcatc_x] ON [dbo].[pbcatcol]([pbc_tnam], [pbc_ownr], [pbc_cnam]) ON [PRIMARY]
GO

 CREATE  UNIQUE  INDEX [pbcate_x] ON [dbo].[pbcatedt]([pbe_name], [pbe_seqn]) ON [PRIMARY]
GO

 CREATE  UNIQUE  INDEX [pbcatf_x] ON [dbo].[pbcatfmt]([pbf_name]) ON [PRIMARY]
GO

 CREATE  UNIQUE  INDEX [pbcatt_x] ON [dbo].[pbcattbl]([pbt_tnam], [pbt_ownr]) ON [PRIMARY]
GO

 CREATE  UNIQUE  INDEX [pbcatv_x] ON [dbo].[pbcatvld]([pbv_name]) ON [PRIMARY]
GO