-- 以前弄来玩的时候建的数据库 只有表结构没有数据
CREATE TABLE `follower` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `account` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  `nick_name` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  `gender` enum('男','女') COLLATE utf8_unicode_ci NOT NULL DEFAULT '男',
  `address` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
  `follower` int(11) unsigned NOT NULL,
  `following` int(11) unsigned NOT NULL,
  `last_weibo` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
  `level` int(11) unsigned NOT NULL,
  `weibo_from` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  `weibo_client` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  `weibo_time` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  `certification` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  `following_account` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  `is_gather` int(11) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `account` (`account`),
  KEY `follower` (`follower`)
) ENGINE=InnoDB AUTO_INCREMENT=361432 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci

CREATE TABLE `joke` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `catname` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
  `title` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  `body` text COLLATE utf8_unicode_ci NOT NULL,
  `gather_time` int(11) unsigned NOT NULL DEFAULT '0',
  `origin_url` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=17409 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC


CREATE TABLE `microfriends` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `account` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  `nick_name` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  `age` int(11) unsigned NOT NULL,
  `address` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
  `height` int(11) unsigned NOT NULL,
  `education` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  `gender` char(2) COLLATE utf8_unicode_ci NOT NULL,
  `certification` varchar(16) COLLATE utf8_unicode_ci NOT NULL,
  `job` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `account` (`account`)
) ENGINE=InnoDB AUTO_INCREMENT=54947 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci

CREATE TABLE `tu_duowan_com` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `category` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
  `gid` int(11) unsigned NOT NULL,
  `url` varchar(512) COLLATE utf8_unicode_ci NOT NULL,
  `add_intro` varchar(512) COLLATE utf8_unicode_ci NOT NULL,
  `file_height` int(11) unsigned NOT NULL,
  `file_width` int(11) unsigned NOT NULL,
  `source` varchar(512) COLLATE utf8_unicode_ci NOT NULL,
  `title` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
  `qpic_url` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
  `q_weibo_id` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=97083 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci

CREATE TABLE `tu_duowan_com_gallery` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `gid` int(11) unsigned NOT NULL,
  `category` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  `url` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
  `gather` int(11) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1154 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci


CREATE TABLE `weibo_content` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `weibo_id` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  `content` text COLLATE utf8_unicode_ci NOT NULL,
  `name` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  `nick` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  `timestamp` int(11) NOT NULL,
  `pic` text COLLATE utf8_unicode_ci NOT NULL,
  `gather_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=28660 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci

CREATE TABLE `weibo_user` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `account` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  `nick_name` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  `address` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
  `follower` int(11) unsigned NOT NULL COMMENT '听众',
  `following` int(11) unsigned NOT NULL COMMENT '收听',
  `explanation` varchar(128) COLLATE utf8_unicode_ci NOT NULL COMMENT '说明',
  `gender` enum('男','女') COLLATE utf8_unicode_ci NOT NULL DEFAULT '男' COMMENT '性别',
  `certification` varchar(32) COLLATE utf8_unicode_ci NOT NULL COMMENT '认证',
  PRIMARY KEY (`id`),
  UNIQUE KEY `account` (`account`)
) ENGINE=InnoDB AUTO_INCREMENT=3502 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci