--创建数据库
create database company

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

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

  --创建部门信息表
  create table sectionInfo
  (
  sectionID int identity(1,1) primary key,
  sectionName varchar(10) not null
  )

  --创建员工信息表
  create table userInfo
  (
  userNO int identity(1,1) primary key not null,
  userName varchar(10) unique not null,
  userSex varchar(2) not null,--(只能填写男女)
  userAge int check(userAge>=1 and userAge<=100),--(范围在1-100之间)
  uesrAddress varchar(50) default('湖北'),
  userSection int references sectioninfo(sectionid)
  )

  --创建员工考勤表
  create table workInfo
  (
  workId int identity(1,1) primary key,
  userId int references userinfo(userNo) not null ,
  workTime datetime not null,
  workDescription varchar(40) not null check(workDescription='迟到' or workDescription='早退' or workDescription='旷工' or workDescription='病假' or workDescription='事假')
  )