以mysql为例:创建表的语句
DROP TABLE IF EXISTS `t_user`;
CREATE TABLE `t_user` (
`id` bigint(255) NOT NULL AUTO_INCREMENT,
`login_name` varchar(64) DEFAULT NULL,
`password` varchar(64) DEFAULT NULL,
`user_name` varchar(64) DEFAULT NULL,
`email` varchar(64) DEFAULT NULL,
`phone` varchar(64) DEFAULT NULL,
`type` varchar(64) DEFAULT NULL,
`sex` enum('男','女') DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1004 DEFAULT CHARSET=utf8;