CREATE TABLE UserInfo
(
id NUMBER(10) NOT NULL,
username VARCHAR(32),
password VARCHAR(32),
emial VARCHAR(15),
sex VARCHAR(10),
brithday NUMBER(32),
province VARCHAR(32),
city VARCHAR(32),
state VARCHAR(32),
realname VARCHAR(32),
college VARCHAR(255),
highschool VARCHAR(255),
gradeschool VARCHAR(32),
regtime NUMBER(32),
logintime NUMBER(32),
PRIMARY KEY (id)
);
insert into UserInfo values(1,'zhangsan','123456','zhang@163.com','男',null,'湖南','长沙','健康','张三','北京大学',null,null,null,null);
insert into UserInfo values(2,'zhangsan02','123456','zhang@163.com','女',null,'北京','北京','健康','张三','北京大学',null,null,null,null);
insert into UserInfo values(3,'zhangsan03','123456','zhang@163.com','男',null,'湖南','长沙','健康','张三','北京大学',null,null,null,null);
insert into UserInfo values(4,'zhangsan04','123456','zhang@163.com','女',null,'深圳','深圳','健康','张三','北京大学',null,null,null,null);
insert into UserInfo values(5,'zhangsan05','123456','zhang@163.com','男',null,'湖南','长沙','健康','张三','北京大学',null,null,null,null);
insert into UserInfo values(6,'zhangsan06','123456','zhang@163.com','女',null,'广东','广州','健康','张三','北京大学',null,null,null,null);
insert into UserInfo values(7,'zhangsan07','123456','zhang@163.com','男',null,'湖南','长沙','健康','张三','北京大学',null,null,null,null);
insert into UserInfo values(8,'zhangsan08','123456','zhang@163.com','女',null,'湖北','武汉','健康','张三','北京大学',null,null,null,null);