users.txt

来自「二次开发模块 一、条形码的批量生成」· 文本 代码 · 共 20 行

CREATE TABLE [Users] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[cName] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[cGroup] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[cPassword] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[cType] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[bAdmin] [bit] NULL CONSTRAINT [DF_Users_bAdmin] DEFAULT (0),
	[bVouch01] [bit] NULL CONSTRAINT [DF_Users_bPur] DEFAULT (0),
	[bVouch08] [bit] NULL CONSTRAINT [DF_Users_bVouch08] DEFAULT (0),
	[bVouch09] [bit] NULL CONSTRAINT [DF_Users_bVouch081] DEFAULT (0),
	[bVouch10] [bit] NULL CONSTRAINT [DF_Users_bVouch321] DEFAULT (0),
	[bVouch11] [bit] NULL CONSTRAINT [DF_Users_bVouch101] DEFAULT (0),
	[bVouch12] [bit] NULL CONSTRAINT [DF_Users_bVouch111] DEFAULT (0),
	[bVouch18] [bit] NULL CONSTRAINT [DF_Users_bVouch121] DEFAULT (0),
	[bVouch32] [bit] NULL CONSTRAINT [DF_Users_bVouch011] DEFAULT (0),
	CONSTRAINT [PK_Users] PRIMARY KEY  NONCLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
) ON [PRIMARY]