person.sql

本程序所有数据库文件都以.sql文件保存在Database文件夹里； 2、首先在SQL查询分析器中运行CreateDatabase.sql文件创建数据库； 3、运行其他所有的.sql文件即可创建好了本

USE Job
GO
CREATE TABLE Person (
UserName 	Varchar (20) PRIMARY KEY,
Pwd 	Varchar (20) NOT NULL ,
RealName 	Varchar (50) NOT NULL ,
Sex 	Bit NOT NULL ,
Birth 	Varchar (50),
IDCard 	Varchar (20),
Nature 	Varchar (20),
Married 	Varchar (10) ,
HuKou 	Varchar (20) ,
Location 	Varchar (20) ,
Education 	Varchar (20),
College 	Varchar (50),
Telephone 	Varchar (50),
Mobile 	Varchar (50),
Email 	Varchar (50),
Address 	Varchar (200),
AppTitle Varchar(200),
English varchar(100),
Computer varchar(100),
Main Text,
PostTime Datetime
)
GO