mirror of
https://github.com/pokerfaceSad/SinaNetSpider.git
synced 2026-10-16 20:51:23 +08:00
pokerfaceSad
22 lines
656 B
SQL
22 lines
656 B
SQL
CREATE DATABASE `sinaweibo_net` /*!40100 DEFAULT CHARACTER SET utf8 */;
|
|
|
|
USE sinaweibo_net;
|
|
|
|
CREATE TABLE `attention_relation` (
|
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
|
`fan_uid` char(20) DEFAULT NULL,
|
|
`followeder_uid` char(20) DEFAULT NULL,
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=13374 DEFAULT CHARSET=utf8;
|
|
|
|
CREATE TABLE `user` (
|
|
`uid` char(20) NOT NULL,
|
|
`username` char(40) DEFAULT NULL,
|
|
`url` char(50) DEFAULT NULL,
|
|
`sex` varchar(10) DEFAULT NULL,
|
|
`location` varchar(40) DEFAULT NULL,
|
|
`birthday` varchar(30) DEFAULT NULL,
|
|
`isexplored` varchar(10) DEFAULT NULL,
|
|
PRIMARY KEY (`uid`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|