/*
Navicat MySQL Data Transfer

Source Server : mypc
Source Server Version : 50717
Source Host : localhost:3306
Source Database : o2o

Target Server Type : MYSQL
Target Server Version : 50717
File Encoding : 65001

Date: 2018年01月23日 20:06:08
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for tb_local_auth
-- ----------------------------
DROP TABLE IF EXISTS `tb_local_auth`;
CREATE TABLE `tb_local_auth` (
 `local_auth_id` int(10) NOT NULL AUTO_INCREMENT,
 `user_id` int(10) NOT NULL,
 `username` varchar(128) NOT NULL,
 `password` varchar(128) NOT NULL,
 `create_time` datetime DEFAULT NULL,
 `last_edit_time` datetime DEFAULT NULL,
 PRIMARY KEY (`local_auth_id`),
 UNIQUE KEY `uk_local_profile` (`username`),
 KEY `fk_localauth_profile` (`user_id`),
 CONSTRAINT `fk_localauth_profile` FOREIGN KEY (`user_id`) REFERENCES `tb_person_info` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;