?? 數(shù)據(jù)庫(kù)生成腳本.txt
字號(hào):
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 ,
[聯(lián)系電話] [char] (12) COLLATE Chinese_PRC_CI_AS NULL ,
[身份證號(hào)碼] [char] (18) COLLATE Chinese_PRC_CI_AS NULL ,
[現(xiàn)住] [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 ,
[帳號(hào)] [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
?? 快捷鍵說(shuō)明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -