数据库
use master
goif exists(select * from sysdatabases where name = 'db_user')
drop database db_user
go
create database db_user
go
use db_user
go
---用户表
if exists(select * from sysobjects where name = 'UserInfo')
drop table UserInfo
go
create table UserInfo
(
ID int identity(1,1) not null primary key, --id
Username varchar(20) not null, --姓名
Password varchar(20) not null, --密码
Email varchar(50) not null --邮箱
)
go
--角色表
if exists(select * from sysobjects where name = 'Role')
drop table [Role]
go
create table [Role]
(
ID int identity(1,1) not null primary key, --id
RoleName varchar(10) not null --