users.sql

一个ERP系统可以用来学习之用

CREATE TABLE [Users] (
	[Name] [char] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Password] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[EngineerUse] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[PurchaseUse] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[SalesUse] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[StocksUse] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[ManpowerUse] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[ClientUse] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[ManageUse] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[ManageDindan] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[Chenbenheshuan] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[Jinxiaochun] [nchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	 PRIMARY KEY  CLUSTERED 
	(
		[Name]
	)  ON [PRIMARY] 
) ON [PRIMARY]
GO