chat聊天小项目的数据库结构

1
2
3
4
5
6
7
8
9
CREATE TABLE `user` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(20) NOT NULL,
  `passwd` varchar(20) NOT NULL,
  `eamil` varchar(20) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=670400311 DEFAULT CHARSET=latin1

1
2
3
4
5
6
CREATE TABLE `friend` (
  `user` varchar(10) DEFAULT NULL,
  `linker` varchar(20) NOT NULL,
  `uid` int(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1

1
2
3
4
5
6
7
8
9
10
CREATE TABLE `information` (
  `Iid` int(4) NOT NULL AUTO_INCREMENT,
  `nickname` varchar(20) DEFAULT NULL,
  `signature` varchar(100) DEFAULT NULL,
  `uid` int(10) DEFAULT NULL,
  PRIMARY KEY (`Iid`),
  KEY `uid` (`uid`),
  CONSTRAINT `information_ibfk_1` FOREIGN KEY (`uid`) REFERENCES `user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1