eaglass.sql

来自「文件传输源码pb9－－高级winsokt编程」· SQL 代码 · 共 767 行 · 第 1/5 页

) ON [PRIMARY]
GO




DELETE FROM [c_pinpai]
GO

SET IDENTITY_INSERT [c_pinpai] ON
GO


INSERT INTO [c_pinpai] ( xid, pinpai) VALUES (127,'博士伦')
SET IDENTITY_INSERT [c_pinpai] OFF

CREATE TABLE [c_pinzhong] (
	[xid] [numeric](18, 0) IDENTITY (1, 1) NOT NULL ,
	[pinzhong] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[pinpai] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	CONSTRAINT [PK_c_pinzhong] PRIMARY KEY  CLUSTERED 
	(
		[xid]
	)  ON [PRIMARY] 
) ON [PRIMARY]
GO




DELETE FROM [c_pinzhong]
GO

SET IDENTITY_INSERT [c_pinzhong] ON
GO


INSERT INTO [c_pinzhong] ( xid, pinzhong, pinpai) VALUES (151,'养眼镜','博士伦')
SET IDENTITY_INSERT [c_pinzhong] OFF

CREATE TABLE [c_xinghao] (
	[xinghao] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	CONSTRAINT [PK_c_xinghao] PRIMARY KEY  CLUSTERED 
	(
		[xinghao]
	)  ON [PRIMARY] 
) ON [PRIMARY]
GO




DELETE FROM [c_xinghao]
GO


INSERT INTO [c_xinghao] ( xinghao) VALUES ('KG3000')
CREATE TABLE [c_yanse] (
	[yanse] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	CONSTRAINT [PK_c_yanse] PRIMARY KEY  CLUSTERED 
	(
		[yanse]
	)  ON [PRIMARY] 
) ON [PRIMARY]
GO




DELETE FROM [c_yanse]
GO


INSERT INTO [c_yanse] ( yanse) VALUES ('白')
INSERT INTO [c_yanse] ( yanse) VALUES ('银白')
CREATE TABLE [c_yuangong] (
	[id] [numeric](18, 0) IDENTITY (1, 1) NOT NULL ,
	[gh] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[jsm] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[name] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[xingbie] [varchar] (2) COLLATE Chinese_PRC_CI_AS NULL ,
	[shengri] [datetime] NULL ,
	[zhuangtai] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[gangwei] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[jiaoyu] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[dianhua] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[shouji] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[zhuzhi] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[jiguan] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[youjian] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[cuowu] [int] NULL CONSTRAINT [DF_c_yuangong_cuowu] DEFAULT (0),
	[biaoyang] [int] NULL CONSTRAINT [DF_c_yuangong_biaoyang] DEFAULT (0),
	[l_r] [datetime] NULL ,
	[z_r] [datetime] NULL ,
	[shfzh] [varchar] (22) COLLATE Chinese_PRC_CI_AS NULL ,
	[cangku] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	CONSTRAINT [PK_c_yuangong] PRIMARY KEY  CLUSTERED 
	(
		[id]
	)  ON [PRIMARY] 
) ON [PRIMARY]
GO




DELETE FROM [c_yuangong]
GO

SET IDENTITY_INSERT [c_yuangong] ON
GO


INSERT INTO [c_yuangong] ( id, gh, jsm, name, xingbie, shengri, zhuangtai, gangwei, jiaoyu, dianhua, shouji, zhuzhi, jiguan, youjian, cuowu, biaoyang, l_r, z_r, shfzh, cangku) VALUES (57,'GY01060001','lsl','李肃立','女',Null,'在职','营业员','大专',Null,Null,Null,Null,'[e-mail]',0,0,'2006-02-06 0:0:0',Null,'189298398','01')
INSERT INTO [c_yuangong] ( id, gh, jsm, name, xingbie, shengri, zhuangtai, gangwei, jiaoyu, dianhua, shouji, zhuzhi, jiguan, youjian, cuowu, biaoyang, l_r, z_r, shfzh, cangku) VALUES (58,'GY01060002','zsc','张四川','男',Null,'在职','验光师','大专',Null,Null,Null,Null,Null,0,0,Null,Null,Null,'01')
INSERT INTO [c_yuangong] ( id, gh, jsm, name, xingbie, shengri, zhuangtai, gangwei, jiaoyu, dianhua, shouji, zhuzhi, jiguan, youjian, cuowu, biaoyang, l_r, z_r, shfzh, cangku) VALUES (59,'GY01060003','zd','长大','男',Null,'在职',Null,Null,Null,Null,Null,Null,Null,0,0,Null,Null,Null,'01')
SET IDENTITY_INSERT [c_yuangong] OFF

CREATE TABLE [c_zhiye] (
	[zhiye] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	CONSTRAINT [PK_c_zhiye] PRIMARY KEY  CLUSTERED 
	(
		[zhiye]
	)  ON [PRIMARY] 
) ON [PRIMARY]
GO




DELETE FROM [c_zhiye]
GO


CREATE TABLE [c_zhuangtai] (
	[zhuangtai] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	CONSTRAINT [PK_c_zhuangtai] PRIMARY KEY  CLUSTERED 
	(
		[zhuangtai]
	)  ON [PRIMARY] 
) ON [PRIMARY]
GO




DELETE FROM [c_zhuangtai]
GO


INSERT INTO [c_zhuangtai] ( zhuangtai) VALUES ('离职')
INSERT INTO [c_zhuangtai] ( zhuangtai) VALUES ('在职')
CREATE TABLE [cquanxian] (
	[id] [numeric](18, 0) IDENTITY (1, 1) NOT NULL ,