数据库基础

DROP TABLE IF EXISTS `user`;

CREATE TABLE `user` (

  `id` int(11) NOT NULL,

  `username` varchar(255) DEFAULT NULL,

  `password` char(120) DEFAULT NULL,

  `last_login_time` int(11) DEFAULT NULL,

  `email` varchar(255) DEFAULT NULL,

  `mobile` varchar(255) DEFAULT NULL,

  `status` tinyint(1) DEFAULT NULL,

  `create_time` varchar(255) DEFAULT NULL,

  `update_time` varchar(255) DEFAULT NULL,

  `last_login_id` int(11) NOT NULL,

  PRIMARY KEY (`id`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- ----------------------------

-- Records of user

-- ----------------------------

INSERT INTO `user` VALUES ('1', '`ximen`', '``999', null, null, null, null, null, null, '0');

INSERT INTO `user` VALUES ('2', '很帅', '888', null, null, null, null, null, null, '0');

INSERT INTO `user` VALUES ('3', '很库', '388', null, null, null, null, null, null, '0');

INSERT INTO `user` VALUES ('4', '灭菌', '123', null, null, null, null, null, null, '0');

INSERT INTO `user` VALUES ('5', '很库', '388', null, null, null, null, null, null, '0');

INSERT INTO `user` VALUES ('6', '灭菌', '123', null, null, null, null, null, null, '0');

INSERT INTO `user` VALUES ('7', '灭菌', '123', null, null, null, null, null, null, '0');

INSERT INTO `user` VALUES ('8', '灭菌', '123', null, null, null, null, null, null, '0');

INSERT INTO `user` VALUES ('9', '灭菌', '123', null, null, null, null, null, null, '0');

INSERT INTO `user` VALUES ('10', '灭菌', '123', null, null, null, null, null, null, '0');