7、权限管理数据库

一、创建数据库

--用户表
CREATE TABLE [dbo].[SysUser](
    [Id] [varchar](50) NOT NULL, --用户id
    [UserName] [varchar](50) NOT NULL, --用户姓名
    [Password] [varchar](20) NOT NULL, --用户密码
    [State] [bit] NULL,  --启用状态
 CONSTRAINT [PK_SysUser] PRIMARY KEY CLUSTERED 
(
    [Id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO

INSERT INTO [dbo].[SysUser]([Id],[UserName],[Password],[State])VALUES('admin','系统管理员','0',1)
INSERT INTO [dbo].[SysUser]([Id],[UserName],[Password],[State])VALUES('zhou','周','1',1)
INSERT INTO [dbo].[SysUser]([Id],[UserName],[Password],[State])VALUES('yu','余','2',1)
INSERT INTO [dbo].[SysUser]([Id],[UserName],[Password],[State])VALUES('anan','安安','3',1)
GO