create database TestDB1--创建数据库

on primary(
 --主数据文件参数设置
 name='TestDB1',
 filename='C:\Program Files\Microsoft SQL Server\MSSQL12.SQLEXPRESS\MSSQL\DATA\TestDB1.mdf',
 size=5MB,
 filegrowth=1MB,
 maxsize=unlimited
),

 (
 --次数据文件参数设置
 name='TestDB2',
 filename='C:\Program Files\Microsoft SQL Server\MSSQL12.SQLEXPRESS\MSSQL\DATA\TestDB2.ndf',
 size=5MB,
 filegrowth=1MB,
 maxsize=unlimited
 ),
  filegroup group1
  (
 --日志文件参数设置
  name='TestDB_log',
 filename='C:\Program Files\Microsoft SQL Server\MSSQL12.SQLEXPRESS\MSSQL\DATA\TestDB2.ldf',
 size=2MB,
 filegrowth=10%,
 maxsize=unlimited
  )

---------------------------------
--创建会员数据表
create table typeinfo
(
typeld int identity(1,1),
typeName varchar(5),
)

create table logininfo
(
loginid int identity(1,1),
loginname nvarchar(5),
loginpwd nvarchar(5),
loginsex bit check(loginsex='男' or loginsex='女'),
loginbirth datetime ,
logincate int
)

--------------------------------

--修改会员类别设置
alter table typeinfo
alter column typeinfo nvarchar(10)

--约束会员类别表进行设置
alter table typeinfo
add constraint PK_typeinfo_typeid primary key(typeid)

alter table typeinfo
add constraint typename check(typename is not null)

----------
--修改登录用户设置
alter table logininfo
alter column loginname nvarchar(10)

alter table logininfo
alter column loginpwd nvarchar(20)

--约束登录用户进行设置
alter table logininfo
add constraint PK_logininfo_loginid primary key(loginid)

alter table logininfo
add constraint loginname check(loginname is not null)

alter table logininfo 
add constraint loginname unique(loginname)

alter table logininfo
add constraint loginpwd check(loginpwd is not null)

alter table logininfo
add constraint loginpwd default(123456) for loginpwd