USE [master]
GO
DROP DATABASE [mydata]
GO
CREATE DATABASE [mydata]
GO
USE [mydata]
GO
CREATE TABLE [dbo].[t_user]
(
    [id] [int] IDENTITY(1,1) NOT NULL,
    [username] [nvarchar](max) NOT NULL DEFAULT (N'无'),
    [gender] [nvarchar](max) NOT NULL DEFAULT (N'无'),
    [birthday] [smalldatetime] NOT NULL DEFAULT (N'1900-01-01'),
    [address] [nvarchar](max) NOT NULL DEFAULT (N'无'),
    [idnumber] [nvarchar](max) NOT NULL DEFAULT (N'无'),
    PRIMARY KEY ([id]),
    CHECK ([gender]=N'男' OR [gender]=N'女' OR [gender]=N'无')
)
insert into t_user ([username]) values ('张三');
insert into t_user ([username], [gender]) values ('李四','男');
insert into t_user ([username], [gender], [birthday]) values ('王五', '女', '1980-1-1');
insert into t_user ([username], [gender], [birthday], [address]) values ('刘六', '男', '1980-1-1', '北京市东城区234号');
insert into t_user ([username], [gender], [birthday], [address], [idnumber]) values ('七七', '女', '1980-1-1', '北京市东城区234号', '110101198001010010');
insert into t_user ([username], [gender], [birthday], [address], [idnumber]) values ('七七', '女', '1980-1-1', '北京市东城区234号', '110101198001010010');
insert into t_user ([username], [gender], [birthday], [address], [idnumber]) values ('七七', '女', '1980-1-1', '北京市东城区234号', '110101198001010010');
insert into t_user ([username], [gender], [birthday], [address], [idnumber]) values ('七七', '女', '1980-1-1', '北京市东城区234号', '110101198001010010');
insert into t_user ([username], [gender], [birthday], [address], [idnumber]) values ('七七', '女', '1980-1-1', '北京市东城区234号', '110101198001010010');
insert into t_user ([username], [gender], [birthday], [address], [idnumber]) values ('七七', '女', '1980-1-1', '北京市东城区234号', '110101198001010010');
insert into t_user ([username], [gender], [birthday], [address], [idnumber]) values ('七七', '女', '1980-1-1', '北京市东城区234号', '110101198001010010');
insert into t_user ([username], [gender], [birthday], [address], [idnumber]) values ('七七', '女', '1980-1-1', '北京市东城区234号', '110101198001010010');
insert into t_user ([username], [gender], [birthday], [address], [idnumber]) values ('七七', '女', '1980-1-1', '北京市东城区234号', '110101198001010010');
insert into t_user ([username], [gender], [birthday], [address], [idnumber]) values ('七七', '女', '1980-1-1', '北京市东城区234号', '110101198001010010');
insert into t_user ([username], [gender], [birthday], [address], [idnumber]) values ('七七', '女', '1980-1-1', '北京市东城区234号', '110101198001010010');
insert into t_user ([username], [gender], [birthday], [address], [idnumber]) values ('七七', '女', '1980-1-1', '北京市东城区234号', '110101198001010010');
insert into t_user ([username], [gender], [birthday], [address], [idnumber]) values ('七七', '女', '1980-1-1', '北京市东城区234号', '110101198001010010');
insert into t_user ([username], [gender], [birthday], [address], [idnumber]) values ('七七', '女', '1980-1-1', '北京市东城区234号', '110101198001010010');
insert into t_user ([username], [gender], [birthday], [address], [idnumber]) values ('七七', '女', '1980-1-1', '北京市东城区234号', '110101198001010010');
insert into t_user ([username], [gender], [birthday], [address], [idnumber]) values ('七七', '女', '1980-1-1', '北京市东城区234号', '110101198001010010');
insert into t_user ([username], [gender], [birthday], [address], [idnumber]) values ('七七', '女', '