-- MySQL dump 10.13  Distrib 5.1.50, for Win32 (ia32)

--
-- Table structure for table `xwb_ad`
--

DROP TABLE IF EXISTS `xwb_ad`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xwb_ad` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `content` text COMMENT '广告内容',
  `using` varchar(1) DEFAULT '1' COMMENT '是否应用',
  `add_time` int(10) unsigned DEFAULT NULL COMMENT '添加时间',
  `name` varchar(45) DEFAULT NULL COMMENT '广告位名称',
  `description` text COMMENT '广告位描述',
  `page` varchar(45) DEFAULT NULL COMMENT '页面Action',
  `flag` varchar(45) DEFAULT NULL,
  `config` text COMMENT '广告配置',
  `width` int(11) DEFAULT '0' COMMENT '广告容器宽度',
  `height` int(11) DEFAULT '0' COMMENT '广告容器高度',
  PRIMARY KEY (`id`),
  KEY `index_using` (`using`,`page`,`flag`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COMMENT='广告';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `xwb_ad`
--

LOCK TABLES `xwb_ad` WRITE;
/*!40000 ALTER TABLE `xwb_ad` DISABLE KEYS */;
INSERT INTO `xwb_ad` VALUES (1,'<script>\r\nPFP_CONF = {\r\n			\'partnerid\': 40602, // 联盟ID\r\n			\'siteid\': 3333, // 站点ID\r\n			\'blockid\': 2 // 广告位ID\r\n		};\r\n</script>\r\n<script type=\"text/javascript\" src=\"http://p4p.sina.com.cn/test/sina/pfp.js\"></script>','1',1294307785,'底部通栏广告','全站','global','global_bottom',NULL,0,0),(2,'<script>\r\nPFP_CONF = {\r\n			\'partnerid\': 40602, // 联盟ID\r\n			\'siteid\': 3333, // 站点ID\r\n			\'blockid\': 1 // 广告位ID\r\n		};\r\n</script>\r\n<script type=\"text/javascript\" src=\"http://p4p.sina.com.cn/test/sina/pfp.js\"></script>','1',1294307785,'对联广告(左)','全站','global','global_left','{\"topic_get\":\"2\"}',0,0),(3,'<script>\r\nPFP_CONF = {\r\n			\'partnerid\': 40602, // 联盟ID\r\n			\'siteid\': 3333, // 站点ID\r\n			\'blockid\': 6 // 广告位ID\r\n		};\r\n</script>\r\n<script type=\"text/javascript\" src=\"http://p4p.sina.com.cn/test/sina/pfp.js\"></script>','1',1294307785,'对联广告(右)','全站','global','global_right','{\"topic_get\":\"2\"}',0,0),(4,'<script>\r\nPFP_CONF = {\r\n			\'partnerid\': 40602, // 联盟ID\r\n			\'siteid\': 3333, // 站点ID\r\n			\'blockid\': 5 // 广告位ID\r\n		};\r\n</script>\r\n<script type=\"text/javascript\" src=\"http://p4p.sina.com.cn/test/sina/pfp.js\"></script>','1',1294307785,'侧栏广告','微博广场','pub','sidebar',NULL,0,0),(5,'<script>\r\nPFP_CONF = {\r\n			\'partnerid\': 40602, // 联盟ID\r\n			\'siteid\': 3333, // 站点ID\r\n			\'blockid\': 3 // 广告位ID\r\n		};\r\n</script>\r\n<script type=\"text/javascript\" src=\"http://p4p.sina.com.cn/test/sina/pfp.js\"></script>','0',1294307785,'今日话题广告','微博广场','pub','today_topic',NULL,0,0),(6,'<script>\r\nPFP_CONF = {\r\n			\'partnerid\': 40602, // 联盟ID\r\n			\'siteid\': 3333, // 站点ID\r\n			\'blockid\': 4 // 广告位ID\r\n		};\r\n</script>\r\n<script type=\"text/javascript\" src=\"http://p4p.sina.com.cn/test/sina/pfp.js\"></script>','1',1294307785,'发布框下广告','我的首页','index','publish',NULL,0,0),(7,'<script>\r\nPFP_CONF = {\r\n			\'partnerid\': 40602, // 联盟ID\r\n			\'siteid\': 3333, // 站点ID\r\n			\'blockid\': 5 // 广告位ID\r\n		};\r\n</script>\r\n<script type=\"text/javascript\" src=\"http://p4p.sina.com.cn/test/sina/pfp.js\"></script>','1',1294307785,'侧栏广告','我的首页','index','sidebar',NULL,0,0),(8,'<script>\r\nPFP_CONF = {\r\n			\'partnerid\': 40602, // 联盟ID\r\n			\'siteid\': 3333, // 站点ID\r\n			\'blockid\': 5 // 广告位ID\r\n		};\r\n</script>\r\n<script type=\"text/javascript\" src=\"http://p4p.sina.com.cn/test/sina/pfp.js\"></script>','1',1294307785,'侧栏广告','他的首页','ta','sidebar',NULL,0,0);
/*!40000 ALTER TABLE `xwb_ad` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `xwb_admin`
--

DROP TABLE IF EXISTS `xwb_admin`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xwb_admin` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sina_uid` bigint(20) unsigned NOT NULL COMMENT '新浪用户ID',
  `pwd` varchar(32) DEFAULT NULL,
  `add_time` int(10) unsigned DEFAULT NULL COMMENT '加入的时间',
  `is_root` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否拥有帐号管理权限 1.拥有 0.不拥有',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='管理员列表及密码';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `xwb_admin`
--

LOCK TABLES `xwb_admin` WRITE;
/*!40000 ALTER TABLE `xwb_admin` DISABLE KEYS */;
/*!40000 ALTER TABLE `xwb_admin` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `xwb_api_log`
--

DROP TABLE IF EXISTS `xwb_api_log`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xwb_api_log` (
  `id` int(4) unsigned NOT NULL AUTO_INCREMENT,
  `url` varchar(500) DEFAULT NULL COMMENT '请求url',
  `base_string` varchar(500) NOT NULL DEFAULT '' COMMENT '加密的base_string',
  `key_string` varchar(500) NOT NULL DEFAULT '' COMMENT '加密的key_string',
  `http_code` int(4) DEFAULT NULL COMMENT 'http code',
  `ret` varchar(200) NOT NULL DEFAULT '' COMMENT '返回结果',
  `post_data` text COMMENT 'post数据',
  `request_time` float DEFAULT NULL COMMENT '请求时间',
  `total_time` float DEFAULT NULL COMMENT '总执行时间',
  `s_ip` char(15) DEFAULT NULL COMMENT '服务器ip',
  `log_time` char(20) DEFAULT NULL COMMENT '记录时间',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC COMMENT='请求接口日志';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `xwb_api_log`
--

LOCK TABLES `xwb_api_log` WRITE;
/*!40000 ALTER TABLE `xwb_api_log` DISABLE KEYS */;
/*!40000 ALTER TABLE `xwb_api_log` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `xwb_celeb`
--

DROP TABLE IF EXISTS `xwb_celeb`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xwb_celeb` (
  `c_id1` int(11) DEFAULT NULL COMMENT '一级分类ID',
  `c_id2` int(11) DEFAULT NULL COMMENT '二级分类ID',
  `char_index` tinyint(2) DEFAULT NULL COMMENT '字母索引 1-26对应A-Z, 0为其它',
  `sina_uid` bigint(20) DEFAULT NULL COMMENT 'sina用户ID',
  `nick` varchar(100) DEFAULT NULL COMMENT 'sina用户昵称',
  `face` varchar(200) NOT NULL COMMENT '头像地址',
  `verified` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否为官方认证用户 0.不是 1.是',
  `sort` int(11) DEFAULT NULL COMMENT '排序值，小的在前',
  `add_time` int(11) DEFAULT NULL COMMENT '添加时间',
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=37 DEFAULT CHARSET=utf8 COMMENT='名人堂推荐用户表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `xwb_celeb`
--

LOCK TABLES `xwb_celeb` WRITE;
/*!40000 ALTER TABLE `xwb_celeb` DISABLE KEYS */;
INSERT INTO `xwb_celeb` VALUES (1,6,0,1735082993,'朱军','http://tp2.sinaimg.cn/1735082993/50/1286167645/1',1,0,1306133600,1),(1,6,0,1015713681,'张斌','http://tp2.sinaimg.cn/1015713681/50/1300204776/1',0,0,1306215086,2),(1,6,0,1723141197,'毕福剑','http://tp2.sinaimg.cn/1723141197/50/1270094498/1',1,0,1306215105,3),(1,6,0,1580033992,'cctv崔志刚','http://tp1.sinaimg.cn/1580033992/50/1285061617/1',1,0,1306215124,4),(1,6,0,1638762053,'段暄','http://tp2.sinaimg.cn/1638762053/50/0/1',0,0,1306215208,5),(1,6,0,1732461794,'郭志坚','http://tp3.sinaimg.cn/1732461794/50/1279896017/1',1,0,1306215219,6),(1,6,0,1751088662,'李思思','http://tp3.sinaimg.cn/1751088662/50/1286165425/0',0,0,1306215491,7),(1,6,0,1483820045,'尼格买提','http://tp2.sinaimg.cn/1483820045/50/5601102028/1',1,0,1306215593,8),(1,6,0,1686532492,'撒贝宁','http://tp1.sinaimg.cn/1686532492/50/5598952907/1',1,0,1306215615,9),(1,6,0,1744193410,'涂经纬','http://tp3.sinaimg.cn/1744193410/50/1299745403/0',0,0,1306215629,10),(1,6,0,1963954842,'王莉鑫','http://tp3.sinaimg.cn/1963954842/50/0/1',0,0,1306215640,11),(1,6,0,1562617113,'周英杰','http://tp2.sinaimg.cn/1562617113/50/0/1',0,0,1306215716,12),(1,6,0,1064675161,'周洲','http://tp2.sinaimg.cn/1064675161/50/1295504463/0',1,0,1306215731,13),(1,6,0,1297290277,'一天','http://tp2.sinaimg.cn/1297290277/50/1252064486/1',0,0,1306215748,14),(1,6,0,1714568963,'翁晓萌','http://tp4.sinaimg.cn/1714568963/50/0/1',0,0,1306215833,15),(1,6,0,1666284723,'沙桐','http://tp4.sinaimg.cn/1666284723/50/0/0',0,0,1306215843,16),(1,6,0,1499102183,'马洪涛','http://tp4.sinaimg.cn/1499102183/50/1283204013/1',1,0,1306215883,17),(1,6,0,1709515473,'李东宁','http://tp2.sinaimg.cn/1709515473/50/0/1',0,0,1306215892,18),(3,4,0,1995721783,'CCTV财智论语','http://tp4.sinaimg.cn/1995721783/50/5597718713/1',1,0,1306216122,19),(3,4,0,1920172813,'春晚倒计时','http://tp2.sinaimg.cn/1920172813/50/1295840186/1',1,0,1306216136,20),(3,4,0,2024623547,'CCTV-1好戏在这里','http://tp4.sinaimg.cn/2024623547/50/1300169039/0',1,0,1306216144,21),(3,4,0,1890168855,'动物狂欢节','http://tp4.sinaimg.cn/1890168855/50/1293623418/0',1,0,1306216154,22),(3,4,0,1930779903,'非常6十1','http://tp4.sinaimg.cn/1930779903/50/0/1',0,0,1306216167,23),(3,4,0,1651782775,'感动中国','http://tp4.sinaimg.cn/1651782775/50/0/0',0,0,1306216179,24),(3,4,0,1765041881,'欢乐一家亲','http://tp2.sinaimg.cn/1765041881/50/0/0',0,0,1306216188,25),(3,4,0,1701830693,'CCTV今日说法','http://tp2.sinaimg.cn/1701830693/50/5601110730/1',1,0,1306216200,26),(3,4,0,1993801063,'开心歌迷汇','http://tp4.sinaimg.cn/1993801063/50/1299237085/1',1,0,1306216209,27),(3,4,0,1936491952,'CCTV民歌中国','http://tp1.sinaimg.cn/1936491952/50/1297443780/0',1,0,1306216219,28),(3,4,0,1656065587,'七巧板','http://tp4.sinaimg.cn/1656065587/50/1256402674/1',0,0,1306216231,29),(3,4,0,1751249623,'天下足球','http://tp4.sinaimg.cn/1751249623/50/1283220623/1',0,0,1306216245,30),(3,4,0,1841520073,'CCTV我爱发明','http://tp2.sinaimg.cn/1841520073/50/1288321713/1',1,0,1306216256,31),(3,4,0,1946923790,'CCTV小小智慧树','http://tp3.sinaimg.cn/1946923790/50/5600761454/1',0,0,1306216266,32),(3,4,0,1351857812,'CCTV朝闻天下','http://tp1.sinaimg.cn/1351857812/50/1278478834/1',1,0,1306216279,33),(3,4,0,1842657221,'CCTV4中国新闻','http://tp2.sinaimg.cn/1842657221/50/1288444092/0',1,0,1306216289,34),(3,4,0,1794847677,'影视同期声','http://tp2.sinaimg.cn/1794847677/50/0/0',0,0,1306216297,35),(3,4,0,1964691780,'CCTV7乡村大世界','http://tp1.sinaimg.cn/1964691780/50/0/1',0,0,1306216312,36);
/*!40000 ALTER TABLE `xwb_celeb` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `xwb_celeb_category`
--

DROP TABLE IF EXISTS `xwb_celeb_category`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xwb_celeb_category` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `parent_id` int(11) DEFAULT NULL COMMENT '父ID,如果是0，则为一级分类',
  `name` varchar(50) DEFAULT NULL COMMENT '分类名称',
  `sort` int(11) DEFAULT NULL COMMENT '排序，数字小的在前',
  `add_time` int(11) DEFAULT NULL COMMENT '增加时间',
  `status` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '1:启用',
  `recommended` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '1:推荐',
  `color` varchar(45) DEFAULT NULL COMMENT '二级导航的显示颜色',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COMMENT='名人堂用户分类';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `xwb_celeb_category`
--

LOCK TABLES `xwb_celeb_category` WRITE;
/*!40000 ALTER TABLE `xwb_celeb_category` DISABLE KEYS */;
INSERT INTO `xwb_celeb_category` VALUES (1,0,'主持人',0,1306133480,1,1,NULL),(2,0,'名记者',0,1306133493,1,1,NULL),(3,0,'热点栏目',0,1306133513,1,1,NULL),(4,3,'栏目热点',0,1306133542,1,1,''),(5,2,'知名记者',0,1306133560,1,1,''),(6,1,'名持人',0,1306133570,1,1,'');
/*!40000 ALTER TABLE `xwb_celeb_category` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `xwb_comment_copy`
--

DROP TABLE IF EXISTS `xwb_comment_copy`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xwb_comment_copy` (
  `cid` bigint(20) unsigned NOT NULL COMMENT '评论ID',
  `sina_uid` bigint(20) unsigned NOT NULL COMMENT '发评论者的新浪UID',
  `uid` bigint(20) DEFAULT NULL COMMENT '发评论的ID',
  `mid` bigint(20) unsigned NOT NULL COMMENT '微博ID',
  `m_uid` bigint(20) unsigned NOT NULL COMMENT '发微博的UID',
  `reply_cid` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '被回复的评论ID',
  `reply_uid` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '被回复者的ID',
  `content` varchar(140) CHARACTER SET utf8 NOT NULL COMMENT '评论内容',
  `source` varchar(80) COLLATE utf8_bin DEFAULT NULL COMMENT '内容来源',
  `post_ip` varchar(50) COLLATE utf8_bin DEFAULT NULL COMMENT '发布者IP',
  `dateline` int(10) unsigned NOT NULL COMMENT '评论时间',
  `sina_nick` varchar(45) COLLATE utf8_bin DEFAULT NULL COMMENT '发布者新浪的昵称',
  PRIMARY KEY (`cid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin ROW_FORMAT=DYNAMIC COMMENT='评论表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `xwb_comment_copy`
--

LOCK TABLES `xwb_comment_copy` WRITE;
/*!40000 ALTER TABLE `xwb_comment_copy` DISABLE KEYS */;
INSERT INTO `xwb_comment_copy` VALUES (11982355815,1769262321,NULL,11063403154,1769262321,0,0,'很快就结束了，8000张','<a href=\"http://x.weibo.com/xweibo.php\" rel=\"nofollow\">Xweibo Discuz!插件</a>','121.8.156.66',1306132712,'xtest');
/*!40000 ALTER TABLE `xwb_comment_copy` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `xwb_component_cfg`
--

DROP TABLE IF EXISTS `xwb_component_cfg`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xwb_component_cfg` (
  `component_id` int(10) unsigned NOT NULL,
  `cfgName` varchar(30) NOT NULL COMMENT '参数名称',
  `cfgValue` varchar(255) DEFAULT NULL COMMENT '参数值',
  `desc` varchar(50) DEFAULT NULL COMMENT '配置项说明',
  PRIMARY KEY (`component_id`,`cfgName`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='组件对应的配置';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `xwb_component_cfg`
--

LOCK TABLES `xwb_component_cfg` WRITE;
/*!40000 ALTER TABLE `xwb_component_cfg` DISABLE KEYS */;
INSERT INTO `xwb_component_cfg` VALUES (1,'show_num','5','组件显示的微博数'),(2,'group_id','1','名人推荐用户组对应的用户列表ID'),(2,'show_num','3','显示的名人数'),(3,'show_num','9',NULL),(3,'group_id','2','推荐用户组使用的用户列表ID'),(4,'group_id','3','人气关注榜的数据来源，0 使用新浪API >0　对应的用户组'),(10,'show_num','10','今日话题显示的微博数'),(10,'group_id','1','今日话题使用的话题组'),(11,'groups','{\"1\":\"\\u660e\\u661f\",\"2\":\"\\u8349\\u6839\"}',NULL),(9,'show_num','4','随便看看'),(5,'list_id','54355137','list id'),(5,'show_num','4',NULL),(4,'show_num','5','人气关注榜挂件人数'),(6,'show_num','10',NULL),(6,'topic_id','0','0 使用新浪API取数据　> 0 对应的话题组ID'),(7,'show_num','9',NULL),(8,'show_num','3',NULL),(2,'topic_id','0','0 使用新浪API取数据　> 0 对应的话题组ID'),(10,'source','1','0 使用全局数据 >0 使用本站数据'),(9,'source','1','0 使用全局数据 >0 使用本站数据'),(1,'source','1','0 使用全局数据 >0 使用本站数据'),(8,'source','1','0 使用全局数据 >0 使用本站数据'),(12,'topic','微小说','话题微薄的默认话题'),(12,'show_num','6','显示微博数'),(12,'source','1','微博来源'),(17,'show_num','5','组件显示的微博数'),(17,'source','0','0 使用全局数据 >0 使用本站数据'),(18,'show_num','3',NULL);
/*!40000 ALTER TABLE `xwb_component_cfg` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `xwb_component_topic`
--

DROP TABLE IF EXISTS `xwb_component_topic`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xwb_component_topic` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `topic_id` int(10) unsigned NOT NULL,
  `topic` varchar(50) NOT NULL COMMENT '话题',
  `date_time` int(10) unsigned NOT NULL COMMENT '生效时间或添加时间',
  `sort_num` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '排序',
  `ext1` varchar(45) DEFAULT NULL COMMENT '扩展字段',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=34 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='热门话题列表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `xwb_component_topic`
--

LOCK TABLES `xwb_component_topic` WRITE;
/*!40000 ALTER TABLE `xwb_component_topic` DISABLE KEYS */;
INSERT INTO `xwb_component_topic` VALUES (26,2,'Xweibo',1303107194,0,'1303107120');
/*!40000 ALTER TABLE `xwb_component_topic` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `xwb_component_topiclist`
--

DROP TABLE IF EXISTS `xwb_component_topiclist`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xwb_component_topiclist` (
  `topic_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '话题ID',
  `topic_name` varchar(25) NOT NULL COMMENT '话题列表的名称',
  `native` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否为内置话题，内置不能删除',
  `sort` varchar(1) NOT NULL DEFAULT '1' COMMENT '类别下的话题是否允许排序',
  `app_with` text,
  `type` tinyint(4) NOT NULL DEFAULT '0' COMMENT '话题分组类型',
  PRIMARY KEY (`topic_id`)
) ENGINE=MyISAM AUTO_INCREMENT=42 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `xwb_component_topiclist`
--

LOCK TABLES `xwb_component_topiclist` WRITE;
/*!40000 ALTER TABLE `xwb_component_topiclist` DISABLE KEYS */;
INSERT INTO `xwb_component_topiclist` VALUES (2,'今日话题',1,'0','2,5',2);
/*!40000 ALTER TABLE `xwb_component_topiclist` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `xwb_component_usergroups`
--

DROP TABLE IF EXISTS `xwb_component_usergroups`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xwb_component_usergroups` (
  `group_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '分组ID',
  `group_name` varchar(15) NOT NULL COMMENT '组名称',
  `native` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否为内置列表 1:是 0:否',
  `related_id` varchar(50) DEFAULT NULL COMMENT '组件应用情况，即哪位ID的组件使用了，可为多个，逗号分隔',
  `type` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '分组类型，0:普通分组, 4:官方微博分组',
  PRIMARY KEY (`group_id`)
) ENGINE=MyISAM AUTO_INCREMENT=86 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='推荐用户　的各个分组';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `xwb_component_usergroups`
--

LOCK TABLES `xwb_component_usergroups` WRITE;
/*!40000 ALTER TABLE `xwb_component_usergroups` DISABLE KEYS */;
INSERT INTO `xwb_component_usergroups` VALUES (3,'自动关注用户列表',1,'11:1,11:1',0),(83,'首次登陆引导关注',0,NULL,0),(85,'用户推荐',0,NULL,0);
/*!40000 ALTER TABLE `xwb_component_usergroups` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `xwb_component_users`
--

DROP TABLE IF EXISTS `xwb_component_users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xwb_component_users` (
  `group_id` int(10) unsigned DEFAULT NULL COMMENT '唯一、自增的用户分组ID',
  `uid` bigint(20) unsigned NOT NULL COMMENT '用户ID',
  `sort_num` int(11) NOT NULL DEFAULT '0' COMMENT '排序',
  `nickname` varchar(20) DEFAULT NULL COMMENT '用户昵称',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=170 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='用户列表成员表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `xwb_component_users`
--

LOCK TABLES `xwb_component_users` WRITE;
/*!40000 ALTER TABLE `xwb_component_users` DISABLE KEYS */;
INSERT INTO `xwb_component_users` VALUES (1,1904178193,3,'微博开放平台','新浪微博API官方帐号',160),(2,1662047260,3,'SinaAppEngine','新浪SAE服务官方帐号',163),(83,1076590735,1,'Xweibo官方','xweibo官方微博',164),(2,1904178193,2,'微博开放平台','新浪微博API官方帐号',162),(2,1076590735,1,'Xweibo官方','新浪Xweibo官方帐号',161),(1,1076590735,1,'Xweibo官方','新浪Xweibo官方帐号',158),(1,1662047260,2,'SinaAppEngine','新浪SAE云服务平台官方帐号',159),(85,1226321165,1,'李咏','央视主持人',166),(85,1195230310,2,'何炅','湖南卫视主持人',167),(85,1198920804,3,'杨澜','',169);
/*!40000 ALTER TABLE `xwb_component_users` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `xwb_components`
--

DROP TABLE IF EXISTS `xwb_components`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xwb_components` (
  `component_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '唯一、自增ID',
  `name` varchar(20) NOT NULL COMMENT '组件名称',
  `title` varchar(45) DEFAULT NULL COMMENT '用于显示的名称',
  `type` tinyint(4) DEFAULT NULL COMMENT '组件类型　0表示一个页面只有一个，>0表示一个页面可以有多个',
  `native` tinyint(1) NOT NULL DEFAULT '1' COMMENT '是否为内置类型',
  `component_type` tinyint(4) NOT NULL COMMENT '组件类型 1: 页面主体 2: 侧边栏',
  `symbol` varchar(20) NOT NULL COMMENT '模块标识，程序中使用',
  `desc` varchar(255) DEFAULT NULL COMMENT '模块说明',
  `preview_img` varchar(255) DEFAULT NULL COMMENT '预览图片',
  `component_cty` varchar(16) DEFAULT NULL COMMENT '组件分类:array(''user'' => ''用户'', ''wb'' => ''微博'', ''topic'' => ''话题'', ''others'' => ''其它'')',
  PRIMARY KEY (`component_id`)
) ENGINE=MyISAM AUTO_INCREMENT=20 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='组件表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `xwb_components`
--

LOCK TABLES `xwb_components` WRITE;
/*!40000 ALTER TABLE `xwb_components` DISABLE KEYS */;
INSERT INTO `xwb_components` VALUES (1,'热门转发与评论','热门转发与评论',0,1,1,'hotWb','当天转发最多的微博列表（倒序排列）',NULL,'wb'),(2,'用户组','用户组',2,1,1,'starRcm','一组用户的列表',NULL,'user'),(3,'推荐用户','推荐用户',3,1,2,'userRcm','指定某些用户的列表（右边栏）',NULL,'user'),(5,'自定义微博列表','自定义微博列表',5,1,1,'official','某些指定用户发布的微博列表',NULL,'wb'),(6,'话题推荐列表','话题推荐列表',6,1,2,'hotTopic','一组话题列表',NULL,'others'),(7,'可能感兴趣的人','可能感兴趣的人',0,1,2,'guessYouLike','根据当前用户的IP、个人资料推荐相关联的用户列表',NULL,'user'),(8,'同城微博','同城微博',0,1,1,'cityWb','根据当前用户的IP地址判断地区，并展示该地区用户的微博列表',NULL,'wb'),(9,'随便看看','随便看看',0,1,1,'looklook','一段特点时间内发布的（一般为最新）的微博列表，随机展现',NULL,'wb'),(10,'今日话题','今日话题',0,1,1,'todayTopic','自动获取与今日话题相关的微博消息。话题可以在“运营管理-话题推荐管理”中设置',NULL,'others'),(12,'话题微博','话题微博',12,1,1,'topicWb','当前设定话题的相关微博列表',NULL,'wb'),(15,'最新用户','最新用户',0,1,2,'newestWbUser','本站最新开通微博的用户列表',NULL,'user'),(14,'最新微博','最新微博',15,1,1,'newestWb','当前站点最新发布的微博列表',NULL,'wb'),(13,'专题banner图','专题banner图',13,1,1,'pageImg','在页面中添加一个宽度为560px的banner图片',NULL,'others'),(16,'微博发布框','微博发布框',0,1,1,'sendWb','微博发布框',NULL,'others'),(18,'活动列表','活动列表',0,1,2,'eventList','活动列表',NULL,'others'),(19,'本地关注榜','本地关注榜',0,1,2,'localFollowTop','本地关注榜',NULL,'user');
/*!40000 ALTER TABLE `xwb_components` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `xwb_content_unit`
--

DROP TABLE IF EXISTS `xwb_content_unit`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xwb_content_unit` (
  `id` int(4) NOT NULL AUTO_INCREMENT,
  `unit_name` varchar(40) DEFAULT NULL COMMENT '输出单元的名称',
  `title` varchar(40) DEFAULT NULL COMMENT '输出单元的标题，暂时只用于群组微博',
  `width` int(4) DEFAULT NULL COMMENT '输出单元的宽度',
  `height` int(4) DEFAULT NULL COMMENT '输出单元的高度',
  `target` varchar(40) DEFAULT NULL COMMENT '输出单元内容的来源对象',
  `type` int(4) DEFAULT '1' COMMENT '输出单元的类型，默认是1.1是微博秀, 2是推荐用户列表, 3是互动话题，4是一键关注，5是群组微博',
  `skin` int(4) DEFAULT '1' COMMENT '输出单元的样式皮肤,默认是1',
  `colors` int(4) DEFAULT NULL COMMENT '输出单元的自定义样式',
  `show_title` tinyint(3) DEFAULT '1' COMMENT '是否显示标题,默认是1, 1是显示, 0是不显示',
  `show_border` tinyint(3) DEFAULT '1' COMMENT '是否显示边框,默认是1, 1是显示, 0是不显示',
  `show_logo` tinyint(3) DEFAULT '1' COMMENT '是否显示logo,默认是1, 1是显示, 0是不显示',
  `show_publish` tinyint(3) DEFAULT '0' COMMENT '是否显示发布框，默认是0, 1是显示，0是不显示',
  `auto_scroll` tinyint(3) DEFAULT '0' COMMENT '是否自动滚动，默认是0, 1是自动滚动，0不是自动滚动',
  `add_time` int(10) DEFAULT NULL COMMENT '添加时间',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=36 DEFAULT CHARSET=utf8 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC COMMENT='内容输出单元';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `xwb_content_unit`
--

LOCK TABLES `xwb_content_unit` WRITE;
/*!40000 ALTER TABLE `xwb_content_unit` DISABLE KEYS */;
/*!40000 ALTER TABLE `xwb_content_unit` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `xwb_disable_items`
--

DROP TABLE IF EXISTS `xwb_disable_items`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xwb_disable_items` (
  `kw_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '唯一、自增ID',
  `type` tinyint(4) NOT NULL COMMENT '内容类型：１微博ID　２评论ID　３昵称　４内容',
  `item` varchar(45) NOT NULL COMMENT '屏蔽或禁止的ID或内容',
  `comment` varchar(60) NOT NULL COMMENT '相关显示内容',
  `admin_name` varchar(24) NOT NULL COMMENT '管理员操作时的昵称',
  `admin_id` int(10) unsigned NOT NULL COMMENT '管理员ID',
  `user` varchar(45) NOT NULL COMMENT '微博或评论的作者',
  `publish_time` varchar(20) NOT NULL COMMENT '微博或评论的发布时间yyyy-mm-dd hh:ii:ss格式字串',
  `add_time` int(10) unsigned NOT NULL COMMENT '加入时间',
  PRIMARY KEY (`kw_id`),
  UNIQUE KEY `Index_type_item` (`type`,`item`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='屏蔽或禁止的内容列表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `xwb_disable_items`
--

LOCK TABLES `xwb_disable_items` WRITE;
/*!40000 ALTER TABLE `xwb_disable_items` DISABLE KEYS */;
/*!40000 ALTER TABLE `xwb_disable_items` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `xwb_event_comment`
--

DROP TABLE IF EXISTS `xwb_event_comment`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xwb_event_comment` (
  `event_id` int(4) unsigned NOT NULL COMMENT '活动id',
  `wb_id` bigint(20) NOT NULL COMMENT '微博id',
  `comment_time` int(10) DEFAULT NULL COMMENT '评论时间',
  PRIMARY KEY (`event_id`,`wb_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 CHECKSUM=1 DELAY_KEY_WRITE=1 COMMENT='活动评论表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `xwb_event_comment`
--

LOCK TABLES `xwb_event_comment` WRITE;
/*!40000 ALTER TABLE `xwb_event_comment` DISABLE KEYS */;
/*!40000 ALTER TABLE `xwb_event_comment` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `xwb_event_join`
--

DROP TABLE IF EXISTS `xwb_event_join`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xwb_event_join` (
  `sina_uid` bigint(20) NOT NULL COMMENT 'SINA　UID',
  `event_id` int(11) NOT NULL COMMENT '活动ID',
  `contact` varchar(200) DEFAULT NULL COMMENT '联系方式',
  `notes` text COMMENT '备注',
  `join_time` int(11) DEFAULT NULL COMMENT '参与时间',
  PRIMARY KEY (`sina_uid`,`event_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='活动参与表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `xwb_event_join`
--

LOCK TABLES `xwb_event_join` WRITE;
/*!40000 ALTER TABLE `xwb_event_join` DISABLE KEYS */;
INSERT INTO `xwb_event_join` VALUES (1808484354,1,NULL,NULL,1306292484);
/*!40000 ALTER TABLE `xwb_event_join` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `xwb_events`
--

DROP TABLE IF EXISTS `xwb_events`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xwb_events` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增ID',
  `title` varchar(200) DEFAULT NULL COMMENT '标题',
  `addr` varchar(200) DEFAULT NULL COMMENT '地址',
  `desc` text COMMENT '简介',
  `cost` float DEFAULT NULL COMMENT '费用',
  `sina_uid` bigint(20) DEFAULT NULL COMMENT '发起人ID',
  `nickname` varchar(25) NOT NULL COMMENT '发起人昵称',
  `realname` varchar(25) DEFAULT NULL COMMENT '真实姓名',
  `phone` varchar(20) DEFAULT NULL COMMENT '联系电话',
  `start_time` int(11) DEFAULT NULL COMMENT '开始时间',
  `end_time` int(11) DEFAULT NULL COMMENT '结束时间',
  `pic` varchar(200) DEFAULT NULL COMMENT '图片',
  `wb_id` bigint(20) DEFAULT NULL COMMENT '微博ID',
  `join_num` int(11) DEFAULT NULL COMMENT '参与人数',
  `view_num` int(11) DEFAULT NULL COMMENT '查看次数',
  `comment_num` int(11) DEFAULT NULL COMMENT '评论数',
  `state` tinyint(2) DEFAULT '1' COMMENT '活动状态：1正常，2用户关闭，3，管理员封禁，4是推荐',
  `other` tinyint(2) DEFAULT '1' COMMENT '是否要求参加填写联系方式和备注：1是不用，2是要求',
  `modify_time` int(11) DEFAULT NULL COMMENT '修改时间',
  `add_time` int(11) DEFAULT NULL COMMENT '发起时间',
  `add_ip` varchar(30) DEFAULT NULL COMMENT '发起人所在地IP',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC COMMENT='活动主表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `xwb_events`
--

LOCK TABLES `xwb_events` WRITE;
/*!40000 ALTER TABLE `xwb_events` DISABLE KEYS */;
INSERT INTO `xwb_events` VALUES (1,'《凉宫春日的惊愕》全球同步首发（广州站）','广东广州广州樱漫书店（ 动漫星城广场西区 负三层BW362号）','为庆贺《凉宫春日的惊愕》上市，天闻角川将在北京、上海、广州、哈尔滨的4家实体店和3家网络书店（天闻角川官网、卓越亚马逊网站和1家淘宝网店），于5月25日上午9：00起，联合举办新书正式版的首发活动。于首发当日购买《凉宫春日的惊愕》（前、后集）正式版的读者将有机会获赠凉宫纪念款T恤一件，全国限量600件，先买先得。我们还将从这600位购书者中，抽取其中一位最幸运的读者，赠送出由谷川流老师为您准备的精美签名礼物哟。\n \n【广州站】\n时间：5月25日 8：30起开始派号\n地点：广州漫樱书店（天闻角川特约店）\n地址：广州市地铁1号线公园前站 动漫星城广场负三层BW362\n \n活动流程：\n \n1.活动派号：8:30-10:00 书店工作人员（身着凉宫春日T恤）在公园前地铁站K站厅派发“首发活动号码牌”和“T恤领取办法注意事项宣传单张”。\n（说明：“首发活动号码劵”上印有活动的唯一编号1-100、T恤领取有效时间段和樱漫书店详细地址，拿到“首发活动号码牌”的读者在指定有效时间段内前往樱漫书店，购买《凉宫春日的惊愕》（前、后集），即可获赠限量版纪念T恤1件，每位读者限领1张。）\n \n2.获得“首发活动号码牌”的读者于10：00动漫星城开门后，前往樱漫书店（排队），购买《凉宫春日的惊愕》前后集，即可在书店门口工作人员处获赠1件限量版T恤，读者领取赠品时，要交回“首发活动号码劵”和销售小票，同时登记姓名和电话。\n \n3.活动结束：12:30，收拾整理现场，撤场。\n \n温馨提示：\n1.由于动漫星城负三层位置空间不大，为了避免人流聚集，建议获得了号码牌的读者尽量分时段前往书店领取哟！\n \n建议时段：\n10:00~10:30 “首发活动号码劵”0-30号读者前往樱漫书店；\n10:30~11:00 “首发活动号码劵”31-60号读者前往樱漫书店；\n11:00~12:30 “首发活动号码劵”61-100号读者前往樱漫书店。\n \n3.为了防止因人流聚集而造成现场拥堵，请读者们务必排队购书，保持现场秩序哟！大家可以从右侧的电梯下楼，左侧的楼梯上楼。此外，为了保证读者的人身安全，也请大家切勿通宵排队哟~（地铁6点运行，麦当劳也是早上6点营业）\n \n4.请读者在领取“号码劵”和获得T恤赠品后，不要在现场太长时间逗留聚集，以方便其他读者继续购书。 最后，为了让大家更熟悉现场环境，',0,1808484354,'熊-斌','','',1337994000,1338004800,'http://demo.x.weibo.com/media/var/event_pic/2011_05/25/1306292473.gif',NULL,1,0,0,1,1,1306292484,1306292484,'121.8.156.66');
/*!40000 ALTER TABLE `xwb_events` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `xwb_feedback`
--

DROP TABLE IF EXISTS `xwb_feedback`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xwb_feedback` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `content` text,
  `uid` bigint(20) DEFAULT NULL,
  `nickname` varchar(45) DEFAULT NULL,
  `mail` varchar(45) DEFAULT NULL,
  `qq` varchar(45) DEFAULT NULL,
  `tel` varchar(45) DEFAULT NULL,
  `addtime` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `xwb_feedback`
--

LOCK TABLES `xwb_feedback` WRITE;
/*!40000 ALTER TABLE `xwb_feedback` DISABLE KEYS */;
/*!40000 ALTER TABLE `xwb_feedback` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `xwb_interview_wb`
--

DROP TABLE IF EXISTS `xwb_interview_wb`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xwb_interview_wb` (
  `ask_id` bigint(20) unsigned NOT NULL COMMENT '提问微博ID',
  `answer_wb` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '第一条回答的微博ID;如果是点评的,ask_id=answer_wb',
  `interview_id` int(10) unsigned NOT NULL COMMENT '在线访谈节目标识',
  `state` char(1) NOT NULL COMMENT 'P:待审;A:审核通过;删除为物理删除;主持人和嘉宾的微博不需要审核',
  `ask_uid` bigint(20) unsigned NOT NULL COMMENT '提问者uid',
  `answer_uid` bigint(20) unsigned DEFAULT NULL COMMENT '第一个回答者uid',
  PRIMARY KEY (`ask_id`),
  KEY `interview_index` (`interview_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='在线访谈内容';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `xwb_interview_wb`
--

LOCK TABLES `xwb_interview_wb` WRITE;
/*!40000 ALTER TABLE `xwb_interview_wb` DISABLE KEYS */;
INSERT INTO `xwb_interview_wb` VALUES (11139810230,11140807085,1,'A',1819991891,1916644671),(11139794666,11140800737,1,'A',1819991891,1916644671),(11139715094,11140779515,1,'A',1819991891,1916644671),(11139753806,11140790141,1,'A',1819991891,1916644671),(11139763947,11140794525,1,'A',1819991891,1916644671),(11139816181,11140813683,1,'A',1819991891,1916644671);
/*!40000 ALTER TABLE `xwb_interview_wb` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `xwb_interview_wb_atme`
--

DROP TABLE IF EXISTS `xwb_interview_wb_atme`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xwb_interview_wb_atme` (
  `interview_id` int(10) NOT NULL COMMENT '在线访谈节目ID',
  `ask_id` bigint(20) NOT NULL COMMENT '用户提问微博ID',
  `at_uid` bigint(20) NOT NULL COMMENT '提问嘉宾UID',
  `answer_wb` bigint(20) NOT NULL DEFAULT '0' COMMENT '回答的微博ID',
  PRIMARY KEY (`interview_id`,`ask_id`,`at_uid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='保存在线访谈嘉宾被提问的问题';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `xwb_interview_wb_atme`
--

LOCK TABLES `xwb_interview_wb_atme` WRITE;
/*!40000 ALTER TABLE `xwb_interview_wb_atme` DISABLE KEYS */;
INSERT INTO `xwb_interview_wb_atme` VALUES (1,11137908093,1808484354,11138114661),(1,11137942056,1808484354,11138098358),(1,11137990474,1808484354,11138026329),(1,11138018024,1808484354,11138067758),(1,11138055261,1808484354,11138088006),(1,11138091932,1808484354,11138126955),(1,11139715094,1916644671,11140779515),(1,11139753806,1916644671,11140790141),(1,11139763947,1916644671,11140794525),(1,11139794666,1916644671,11140800737),(1,11139810230,1916644671,11140807085),(1,11139816181,1916644671,11140813683);
/*!40000 ALTER TABLE `xwb_interview_wb_atme` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `xwb_item_groups`
--

DROP TABLE IF EXISTS `xwb_item_groups`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xwb_item_groups` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `group_id` int(10) unsigned NOT NULL COMMENT '分组ID 已定义的，1：分类用户推荐 2：引导关注类别',
  `item_id` int(11) NOT NULL COMMENT '分组对象的ID',
  `item_name` varchar(25) DEFAULT NULL COMMENT '分组名称',
  `sort_num` int(11) DEFAULT '0' COMMENT '排序ID，通常用于组内',
  PRIMARY KEY (`id`),
  KEY `group_idx` (`group_id`,`sort_num`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='用于存储ID分组列表，如用户分类';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `xwb_item_groups`
--

LOCK TABLES `xwb_item_groups` WRITE;
/*!40000 ALTER TABLE `xwb_item_groups` DISABLE KEYS */;
INSERT INTO `xwb_item_groups` VALUES (1,2,83,'首次登陆引导关注',0);
/*!40000 ALTER TABLE `xwb_item_groups` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `xwb_keep_userdomain`
--

DROP TABLE IF EXISTS `xwb_keep_userdomain`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xwb_keep_userdomain` (
  `keep_domain` varchar(45) NOT NULL,
  PRIMARY KEY (`keep_domain`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='保留一些个性域名';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `xwb_keep_userdomain`
--

LOCK TABLES `xwb_keep_userdomain` WRITE;
/*!40000 ALTER TABLE `xwb_keep_userdomain` DISABLE KEYS */;
INSERT INTO `xwb_keep_userdomain` VALUES ('application'),('flash'),('html_demo'),('install'),('readme'),('sae_install'),('templates');
/*!40000 ALTER TABLE `xwb_keep_userdomain` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `xwb_micro_interview`
--

DROP TABLE IF EXISTS `xwb_micro_interview`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xwb_micro_interview` (
  `id` int(10) NOT NULL AUTO_INCREMENT COMMENT '标识',
  `title` varchar(200) NOT NULL COMMENT '标题',
  `desc` text NOT NULL COMMENT '说明',
  `banner_img` varchar(200) NOT NULL COMMENT 'Banner图片',
  `cover_img` varchar(200) NOT NULL COMMENT '封面图片',
  `state` char(1) NOT NULL DEFAULT 'N' COMMENT '默认N;X:已删;',
  `wb_state` char(1) NOT NULL DEFAULT 'A' COMMENT 'P:先审后发;A:直接发布',
  `master` varchar(200) DEFAULT NULL COMMENT '主持人新浪uid列表，json结构保存',
  `guest` text COMMENT '嘉宾新浪uid列表，json结构保存',
  `backgroup_img` varchar(200) DEFAULT NULL COMMENT '背景图片',
  `backgroup_color` varchar(20) DEFAULT NULL COMMENT '外观颜色',
  `start_time` int(11) NOT NULL COMMENT '开始时间',
  `end_time` int(11) NOT NULL COMMENT '结束时间',
  `add_time` int(11) NOT NULL COMMENT '添加时间',
  `backgroup_style` tinyint(2) unsigned DEFAULT NULL COMMENT '背景图方式,默认是1,1是平铺，2是居中',
  `custom_color` varchar(20) DEFAULT NULL COMMENT '自定义颜色',
  `notice_time` int(10) unsigned DEFAULT NULL COMMENT '提醒时间，以秒为单位',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='Xweibo在线访谈';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `xwb_micro_interview`
--

LOCK TABLES `xwb_micro_interview` WRITE;
/*!40000 ALTER TABLE `xwb_micro_interview` DISABLE KEYS */;
INSERT INTO `xwb_micro_interview` VALUES (1,'揭秘《非常靠谱》新变化','《非常靠谱》是湖南卫视在2011年推出的中国第一档趣味解读姓氏文化节目，汪涵华丽转身高端文化类节目，解读姓名，追溯家谱，前几期得到观众们的大力支持。 \r\n　　作为一档想炒热冷僻的“姓氏文化”的节目，它再度回归，著名设计师张发财将做客新浪《微访谈•微触名家》，欢迎大家积极提问！','http://demo.x.weibo.com/media/var/live_pic/2011_05/24/1306224173.jpg','http://demo.x.weibo.com/media/var/live_pic/2011_05/24/1306224292.jpg','N','A','[\"1797392503\"]','[\"1667274237\",\"1711704715\",\"1808484354\",\"1727417503\",\"1916644671\"]','img/live_bg_main.jpg','',1306224000,1306229400,1306224455,0,'',300);
/*!40000 ALTER TABLE `xwb_micro_interview` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `xwb_micro_live`
--

DROP TABLE IF EXISTS `xwb_micro_live`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xwb_micro_live` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增ID',
  `title` varchar(200) NOT NULL COMMENT '标题',
  `trends` varchar(200) NOT NULL COMMENT '微直播的话题',
  `desc` text NOT NULL COMMENT '简介',
  `code` text COMMENT '直播视频代码',
  `start_time` int(11) NOT NULL COMMENT '开始时间',
  `end_time` int(11) NOT NULL COMMENT '结束时间',
  `master` varchar(200) NOT NULL COMMENT '主持人，json格式保存',
  `guest` text NOT NULL COMMENT '嘉宾，json格式保存',
  `banner_img` varchar(200) DEFAULT NULL COMMENT '微直播的banner',
  `cover_img` varchar(200) DEFAULT NULL COMMENT '封面图',
  `backgroup_img` varchar(200) DEFAULT NULL COMMENT '背景图',
  `backgroup_style` tinyint(2) DEFAULT NULL COMMENT '背景图方式，默认是1，1是平铺，2是居中',
  `backgroup_color` varchar(20) DEFAULT NULL COMMENT '外观样式',
  `custom_color` varchar(20) DEFAULT NULL COMMENT '自定义颜色',
  `state` char(1) NOT NULL DEFAULT 'N' COMMENT '默认N，X:已删',
  `wb_state` char(1) NOT NULL DEFAULT 'A' COMMENT 'P:先审后发;A:直接发布',
  `notice_time` int(11) DEFAULT NULL COMMENT '提醒时间',
  `add_time` int(11) DEFAULT NULL COMMENT '发起时间',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC COMMENT='微主播';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `xwb_micro_live`
--

LOCK TABLES `xwb_micro_live` WRITE;
/*!40000 ALTER TABLE `xwb_micro_live` DISABLE KEYS */;
INSERT INTO `xwb_micro_live` VALUES (1,'香港电影金像奖颁奖典礼','金像奖','第30届香港电影金像奖颁奖典礼于4月17日举行，《狄仁杰之通天帝国》获最佳影片等13项提名，《剑雨》11项提名紧随其后，《叶问2》和《线人》分别斩获10项和8项提名。多位明星助阵新浪微博直播现场盛况！','<div><object id=\"ssss\" width=\"480\" height=\"370\" ><param name=\"allowScriptAccess\" value=\"always\" /><embed pluginspage=\"http://www.macromedia.com/go/getflashplayer\" src=\"http://you.video.sina.com.cn/api/sinawebApi/outplayrefer.php/vid=20034483_1290055681_PUq1RyNsCWfK+l1lHz2stqkP7KQNt6nki2O0u1ehIwZYQ0/XM5GbYt0E5C3eA9kEqDhARpg/dvoi3x4/s.swf\" type=\"application/x-shockwave-flash\" name=\"ssss\" allowFullScreen=\"true\" allowScriptAccess=\"always\" width=\"480\" height=\"370\"></embed></object></div>',1306222800,1306310280,'1797392503','1885770020,1747514562,1646239802,1189170482,1808484354','http://demo.x.weibo.com/media/var/live_pic/2011_05/24/1306223496.jpg','http://demo.x.weibo.com/media/var/live_pic/2011_05/24/1306223574.jpg','img/live_bg_main.jpg',0,'01','','N','A',1306222500,1306222299);
/*!40000 ALTER TABLE `xwb_micro_live` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `xwb_micro_live_wb`
--

DROP TABLE IF EXISTS `xwb_micro_live_wb`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xwb_micro_live_wb` (
  `live_id` int(4) NOT NULL COMMENT '微直播的id',
  `wb_id` bigint(20) NOT NULL COMMENT '微博id',
  `type` tinyint(2) NOT NULL DEFAULT '1' COMMENT '发微博人的类型，默认是1，1是网友，2是主持人，3是嘉宾',
  `state` tinyint(2) NOT NULL DEFAULT '1' COMMENT '微博状态，默认是1，1是正常，2是未审核，3是通过审核',
  `add_time` int(11) DEFAULT NULL COMMENT '发布微博时间',
  PRIMARY KEY (`live_id`,`wb_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `xwb_micro_live_wb`
--

LOCK TABLES `xwb_micro_live_wb` WRITE;
/*!40000 ALTER TABLE `xwb_micro_live_wb` DISABLE KEYS */;
INSERT INTO `xwb_micro_live_wb` VALUES (1,11189725873,3,1,1306308960),(1,11189736620,3,1,1306308972),(1,11189741079,3,1,1306308986),(1,11189744473,3,1,1306308993),(1,11189750363,3,1,1306309003),(1,11189758053,3,1,1306309014),(1,11189764973,3,1,1306309028);
/*!40000 ALTER TABLE `xwb_micro_live_wb` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `xwb_nav`
--

DROP TABLE IF EXISTS `xwb_nav`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xwb_nav` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(45) DEFAULT NULL,
  `parent_id` int(10) DEFAULT NULL,
  `in_use` tinyint(1) unsigned DEFAULT '1',
  `sort_num` tinyint(4) unsigned DEFAULT NULL,
  `page_id` int(10) DEFAULT '0',
  `is_blank` tinyint(1) unsigned DEFAULT '0',
  `url` varchar(255) DEFAULT NULL,
  `type` tinyint(1) NOT NULL,
  `isNative` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '0:自定义;1:系统预设',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=145 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='页面导航栏';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `xwb_nav`
--

LOCK TABLES `xwb_nav` WRITE;
/*!40000 ALTER TABLE `xwb_nav` DISABLE KEYS */;
INSERT INTO `xwb_nav` VALUES (132,'活动',0,1,100,35,0,'',2,0),(130,'媒体广场',0,1,0,1,0,'',2,0),(131,'媒体汇',0,1,0,3,0,'',2,0),(21,'我的首页',0,1,200,2,1,'',2,1),(140,'在线访谈',0,1,0,8,0,'',2,0),(141,'在线直播',0,1,0,7,0,'',2,0),(142,'热议“死刑”',130,1,0,48,0,NULL,2,0),(144,'你好夏天',130,1,0,50,0,NULL,2,0);
/*!40000 ALTER TABLE `xwb_nav` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `xwb_notice`
--

DROP TABLE IF EXISTS `xwb_notice`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xwb_notice` (
  `notice_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '通知ID',
  `sender_id` bigint(20) DEFAULT '0' COMMENT '发送者的sina_uid，默认为0，表示系统发送',
  `title` varchar(100) DEFAULT NULL COMMENT '通知标题',
  `content` text COMMENT '通知内容',
  `add_time` int(11) DEFAULT NULL COMMENT '发布时间',
  `available_time` int(11) DEFAULT NULL COMMENT '生效时间',
  PRIMARY KEY (`notice_id`)
) ENGINE=MyISAM AUTO_INCREMENT=30 DEFAULT CHARSET=utf8 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC COMMENT='通知内容表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `xwb_notice`
--

LOCK TABLES `xwb_notice` WRITE;
/*!40000 ALTER TABLE `xwb_notice` DISABLE KEYS */;
/*!40000 ALTER TABLE `xwb_notice` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `xwb_notice_recipients`
--

DROP TABLE IF EXISTS `xwb_notice_recipients`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xwb_notice_recipients` (
  `kid` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增ID',
  `notice_id` bigint(20) unsigned NOT NULL COMMENT '消息ID',
  `recipient_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '接收者的sina_uid，为0表示全站用户',
  PRIMARY KEY (`kid`)
) ENGINE=MyISAM AUTO_INCREMENT=35 DEFAULT CHARSET=utf8 COLLATE=utf8_bin CHECKSUM=1 DELAY_KEY_WRITE=1 COMMENT='消息接收者记录表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `xwb_notice_recipients`
--

LOCK TABLES `xwb_notice_recipients` WRITE;
/*!40000 ALTER TABLE `xwb_notice_recipients` DISABLE KEYS */;
/*!40000 ALTER TABLE `xwb_notice_recipients` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `xwb_page_manager`
--

DROP TABLE IF EXISTS `xwb_page_manager`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xwb_page_manager` (
  `page_id` int(11) NOT NULL COMMENT '预定义的页面ID：如１：广场。。',
  `component_id` int(11) DEFAULT NULL COMMENT '使用到的组件ID',
  `title` varchar(45) DEFAULT NULL,
  `position` int(11) NOT NULL DEFAULT '0' COMMENT '摆放的位置 1:左边　２：右侧栏',
  `sort_num` int(11) DEFAULT '0' COMMENT '摆放的顺序',
  `in_use` tinyint(1) DEFAULT '1' COMMENT '是否使用',
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `isNative` int(1) unsigned NOT NULL DEFAULT '1' COMMENT '1:系统自带，不能删除  0:用户添加，可以删除',
  `param` text,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=386 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='页面设置';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `xwb_page_manager`
--

LOCK TABLES `xwb_page_manager` WRITE;
/*!40000 ALTER TABLE `xwb_page_manager` DISABLE KEYS */;
INSERT INTO `xwb_page_manager` VALUES (1,10,'今日报道',1,1,1,1,0,'{\"show_num\":\"10\",\"source\":\"0\",\"topic\":\"\\u9189\\u9a7e\"}'),(1,14,'本站最新微博',1,4,1,363,0,'{\"show_num\":\"10\"}'),(1,7,'可能感兴趣的人',2,2,1,364,0,'{\"show_num\":\"3\"}'),(2,7,'可能感兴趣的人',2,2,1,11,0,'{\"show_num\":\"10\"}'),(45,13,'随便看看banner图',1,1,1,357,0,'{\"link\":\"\",\"src\":\"\\/var\\/upload\\/pic\\/component_img_1303108721.png\",\"width\":\"560\",\"height\":\"\"}'),(45,14,'本站最新微博',1,2,1,356,0,'{\"show_num\":\"20\"}'),(44,13,'banner图',1,1,1,355,0,'{\"link\":\"http:\\/\\/\",\"src\":\"\\/var\\/upload\\/pic\\/component_img_1303108508.png\",\"width\":\"560\",\"height\":\"\"}'),(44,8,'同城微博',1,2,1,353,0,'{\"source\":\"0\",\"page_type\":\"1\",\"show_num\":\"15\"}'),(44,19,'本地关注榜',2,2,1,354,0,'{\"show_num\":\"6\"}'),(47,5,'自定义集体微博',1,2,1,361,0,'{\"list_id\":\"0\",\"page_type\":\"1\",\"show_num\":\"15\"}'),(46,13,'自定义话题Banner',1,1,1,359,0,'{\"link\":\"\",\"src\":\"\\/var\\/upload\\/pic\\/component_img_1303109588.png\",\"width\":\"560\",\"height\":\"\"}'),(47,13,'自定义集体微博',1,1,1,360,0,'{\"link\":\"\",\"src\":\"\\/var\\/upload\\/pic\\/component_img_1303110458.png\",\"width\":\"560\",\"height\":\"\"}'),(46,12,'自定义话题微博列表',1,2,1,358,0,'{\"topic\":\"xweibo\",\"source\":\"0\",\"page_type\":\"1\",\"show_num\":\"15\"}'),(1,12,'百姓新闻',1,3,1,366,0,'{\"topic\":\"\\u6c11\\u751f\",\"source\":\"0\",\"page_type\":\"0\",\"show_num\":\"10\"}'),(1,3,'用户推荐',2,3,1,367,0,'{\"group_id\":\"85\"}'),(48,12,'死刑-大家看',1,2,1,372,0,'{\"topic\":\"\\u6b7b\\u5211\",\"source\":\"0\",\"page_type\":\"0\",\"show_num\":\"15\"}'),(1,19,'热门报道',2,4,1,369,0,'{\"show_num\":\"9\"}'),(1,6,'推荐新闻',2,5,1,370,0,'{\"topic_get\":\"1\",\"topics\":[]}'),(1,18,'媒体活动',2,6,1,371,0,'{\"event_list_type\":\"1\",\"show_num\":\"3\"}'),(48,6,'其他热门话题',2,2,1,373,0,'{\"topic_get\":\"1\",\"topics\":[]}'),(50,12,'大家都在聊',1,1,1,384,0,'{\"topic\":\"\\u4f60\\u597d\\u590f\\u5929\",\"source\":\"0\",\"page_type\":\"0\",\"show_num\":\"10\"}'),(50,14,'最新微博',1,2,1,383,0,'{\"show_num\":\"10\"}'),(48,16,'微博发布框',1,1,1,377,0,'[]'),(48,7,'你可能感兴趣的人',2,9,1,379,0,'{\"show_num\":\"9\"}'),(1,13,'香港电影金像奖颁奖典礼',1,2,1,382,0,'{\"link\":\"http:\\/\\/\",\"src\":\"\\/var\\/upload\\/pic\\/component_img_1306309969.jpg\",\"width\":\"560\",\"height\":\"\"}'),(50,7,'可能感兴趣的人',2,2,1,385,0,'{\"show_num\":\"5\"}');
/*!40000 ALTER TABLE `xwb_page_manager` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `xwb_page_prototype`
--

DROP TABLE IF EXISTS `xwb_page_prototype`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xwb_page_prototype` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(45) NOT NULL,
  `desc` varchar(255) DEFAULT NULL,
  `type` int(10) unsigned NOT NULL DEFAULT '2',
  `components` text,
  `url` varchar(45) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='页面原型';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `xwb_page_prototype`
--

LOCK TABLES `xwb_page_prototype` WRITE;
/*!40000 ALTER TABLE `xwb_page_prototype` DISABLE KEYS */;
INSERT INTO `xwb_page_prototype` VALUES (2,'自定义页面','自定义页面原型',2,'','custom'),(1,'自定义页面','自定义页面原型',1,'','custom');
/*!40000 ALTER TABLE `xwb_page_prototype` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `xwb_pages`
--

DROP TABLE IF EXISTS `xwb_pages`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xwb_pages` (
  `page_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '页面id',
  `page_name` varchar(20) DEFAULT NULL COMMENT '页面名称',
  `desc` varchar(255) DEFAULT NULL COMMENT '页面描述',
  `native` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否为内置页',
  `url` varchar(45) DEFAULT NULL,
  `prototype_id` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`page_id`)
) ENGINE=MyISAM AUTO_INCREMENT=51 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `xwb_pages`
--

LOCK TABLES `xwb_pages` WRITE;
/*!40000 ALTER TABLE `xwb_pages` DISABLE KEYS */;
INSERT INTO `xwb_pages` VALUES (1,'微博广场','“微博广场”是用户免登录即可查看的页面，包含了今日话题、随便看看等组件。',1,'pub',NULL),(2,'我的首页','“我的首页”是登录用户操作微博的页面，包含了猜你喜欢、推荐话题等组件。',1,'index',NULL),(3,'名人堂','名人堂',1,'celeb',NULL),(4,'我的微博','我的微博',1,'index.profile',NULL),(35,'活动首页','活动列表页，包括最新活动和推荐活动',1,'event',NULL),(6,'话题排行榜','话题排行榜',1,'pub.topics',NULL),(37,'我的收藏','我的收藏',1,'index.favorites',2),(7,'在线直播','在线直播扩展工具',1,'live',NULL),(8,'在线访谈','在线访谈扩展工具',1,'interview',NULL),(48,'热门话题','',0,'custom',2),(50,'你好夏天','你好夏天',0,'custom',2);
/*!40000 ALTER TABLE `xwb_pages` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `xwb_plugins`
--

DROP TABLE IF EXISTS `xwb_plugins`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xwb_plugins` (
  `plugin_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(20) DEFAULT NULL COMMENT '名称',
  `desc` varchar(255) DEFAULT NULL COMMENT '简介',
  `in_use` tinyint(1) DEFAULT '1' COMMENT '是否开启',
  PRIMARY KEY (`plugin_id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `xwb_plugins`
--

LOCK TABLES `xwb_plugins` WRITE;
/*!40000 ALTER TABLE `xwb_plugins` DISABLE KEYS */;
INSERT INTO `xwb_plugins` VALUES (2,'用户首页聚焦位','开启该插件会将站长设定的内容以图文的形式显示于用户首页中。',1),(3,'个人资料推广位','开启该插件会将站长设定的内容以文字链接的形式显示于用户的个人信息的下方。',1),(4,'登录后引导关注','开启该插件后，用户首次登陆会强制关注指定的用户并且引导用户其它推荐用户。',1),(5,'用户反馈意见','左导航会出现一个意见反馈通道',1),(6,'数据本地备份','本站备份一份微博数据',1);
/*!40000 ALTER TABLE `xwb_plugins` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `xwb_profile_ad`
--

DROP TABLE IF EXISTS `xwb_profile_ad`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xwb_profile_ad` (
  `link_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(50) NOT NULL COMMENT '标题',
  `link` varchar(255) NOT NULL COMMENT '链接',
  `add_time` int(11) DEFAULT NULL COMMENT '添加的时间',
  PRIMARY KEY (`link_id`)
) ENGINE=MyISAM AUTO_INCREMENT=95 DEFAULT CHARSET=utf8 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC COMMENT='个人信息推广位的广告';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `xwb_profile_ad`
--

LOCK TABLES `xwb_profile_ad` WRITE;
/*!40000 ALTER TABLE `xwb_profile_ad` DISABLE KEYS */;
/*!40000 ALTER TABLE `xwb_profile_ad` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `xwb_sessions`
--

DROP TABLE IF EXISTS `xwb_sessions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xwb_sessions` (
  `sesskey` char(32) NOT NULL,
  `expiry` int(11) unsigned NOT NULL,
  `value` text NOT NULL,
  PRIMARY KEY (`sesskey`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `xwb_sessions`
--

LOCK TABLES `xwb_sessions` WRITE;
/*!40000 ALTER TABLE `xwb_sessions` DISABLE KEYS */;
/*!40000 ALTER TABLE `xwb_sessions` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `xwb_skin_groups`
--

DROP TABLE IF EXISTS `xwb_skin_groups`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xwb_skin_groups` (
  `style_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '模板分类ID',
  `style_name` varchar(15) NOT NULL COMMENT '分类名称',
  `sort_num` int(11) NOT NULL DEFAULT '0' COMMENT '显示排序',
  PRIMARY KEY (`style_id`)
) ENGINE=MyISAM AUTO_INCREMENT=20 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='皮肤类别表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `xwb_skin_groups`
--

LOCK TABLES `xwb_skin_groups` WRITE;
/*!40000 ALTER TABLE `xwb_skin_groups` DISABLE KEYS */;
/*!40000 ALTER TABLE `xwb_skin_groups` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `xwb_skins`
--

DROP TABLE IF EXISTS `xwb_skins`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xwb_skins` (
  `skin_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '模板ID',
  `name` varchar(45) DEFAULT NULL COMMENT '文件名名称',
  `directory` varchar(45) NOT NULL COMMENT '所在的目录',
  `desc` varchar(255) DEFAULT NULL COMMENT '模板说明',
  `state` tinyint(4) NOT NULL DEFAULT '1' COMMENT '模板状态　０正常（启用）　１禁用　２文件不存在（不可用）',
  `style_id` int(11) NOT NULL DEFAULT '0' COMMENT '模板分类ID',
  `sort_num` int(11) NOT NULL DEFAULT '0' COMMENT '显示排序',
  PRIMARY KEY (`skin_id`)
) ENGINE=MyISAM AUTO_INCREMENT=29 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='模板列表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `xwb_skins`
--

LOCK TABLES `xwb_skins` WRITE;
/*!40000 ALTER TABLE `xwb_skins` DISABLE KEYS */;
INSERT INTO `xwb_skins` VALUES (1,'经典','skin_default','',0,0,1),(2,'沙滩','skin_beach','',0,0,4),(3,'墨绿','skin_blackgreen','',0,0,1),(4,'蓝色','skin_blue','',0,0,2),(5,'魅紫','skin_charmpurple','',0,0,3),(6,'风景','skin_landscape','',0,0,5),(7,'荷花','skin_lotus','',0,0,6),(8,'节日','skin_newyear','',0,0,7),(9,'冬雪','skin_snow','',0,0,8),(10,'科技','skin_tech','',0,0,9),(11,'旅行','skin_tour','',0,0,10);
/*!40000 ALTER TABLE `xwb_skins` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `xwb_subject`
--

DROP TABLE IF EXISTS `xwb_subject`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xwb_subject` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sina_uid` bigint(20) NOT NULL COMMENT 'sina id',
  `subject` varchar(100) NOT NULL DEFAULT '' COMMENT '话题名称',
  `is_use` tinyint(1) NOT NULL DEFAULT '1' COMMENT '是否启用，默认启用，如果用户删除该话题订阅，只进行软删除',
  PRIMARY KEY (`id`),
  KEY `sina_uid` (`sina_uid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='用户话题收藏记录表，如果用户取消收藏，使用is_use来标记，不删除。';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `xwb_subject`
--

LOCK TABLES `xwb_subject` WRITE;
/*!40000 ALTER TABLE `xwb_subject` DISABLE KEYS */;
/*!40000 ALTER TABLE `xwb_subject` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `xwb_sys_config`
--

DROP TABLE IF EXISTS `xwb_sys_config`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xwb_sys_config` (
  `key` varchar(40) NOT NULL,
  `value` text,
  `group_id` int(10) unsigned NOT NULL DEFAULT '1' COMMENT '配置的分组ID',
  PRIMARY KEY (`key`,`group_id`),
  KEY `idx_groupid` (`group_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='系统配置信息';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `xwb_sys_config`
--

LOCK TABLES `xwb_sys_config` WRITE;
/*!40000 ALTER TABLE `xwb_sys_config` DISABLE KEYS */;
INSERT INTO `xwb_sys_config` VALUES ('rewrite_enable','0',1),('logo','var/data/logo/logo_upload.png',1),('login_way','1',1),('third_code','',1),('site_record','',1),('address_icon','',1),('head_link','{\"1\":{\"link_name\":\"\\u65b0\\u6d6a\\u5fae\\u535a\",\"link_address\":\"http:\\/\\/t.sina.com.cn\\/\"},\"3\":{\"link_name\":\"\\u65b0\\u6d6a\\u7f51\",\"link_address\":\"http:\\/\\/www.sina.com.cn\"}}',1),('foot_link','{\"4\":{\"link_name\":\"\\u7533\\u8bf7\\u52a0V\",\"link_address\":\"http:\\/\\/\"},\"5\":{\"link_name\":\"\\u8054\\u7cfb\\u6211\\u4eec\",\"link_address\":\"http:\\/\\/\"}}',1),('authen_type','3',1),('authen_big_icon','var/data/logo/big_auth_icon.png',1),('authen_small_icon','var/data/logo/small_auth_icon.png',1),('skin_default','4',1),('ad_header','',1),('guide_auto_follow','',1),('ad_footer','',1),('title','你好夏天',2),('text','某一天，从街边亮丽的衬衫和短裙中，才发现夏天已悄然来临。快跟TA打个招呼吧！对这个夏天，你有什么想说的呢？\r\n#你好夏天#+图片/文字，一起来聊聊吧。',2),('bg_pic','var/data/index/indexfc.png',2),('oper','1',2),('topic','你好夏天',2),('link','http://',2),('btnTitle','发布微博',2),('guide_auto_follow_id','3',1),('authen_small_icon_title','我的站点认证',1),('ad_setting','',1),('microInterview_setting','{\"desc\":\"\\u300a\\u5728\\u7ebf\\u8bbf\\u8c08\\u300b\\u662f\\u5efa\\u7acb\\u5728\\u5fae\\u535a\\u57fa\\u7840\\u4e0a\\u7684\\u8bbf\\u8c08\\u7c7b\\u4ea7\\u54c1\\u3002\\u4e0e\\u4f20\\u7edf\\u8bbf\\u8c08\\u4e0d\\u540c\\u7684\\u662f\\uff0c\\u300a\\u5fae\\u8bbf\\u8c08\\u300b\\u7684\\u6240\\u6709\\u95ee\\u9898\\u90fd\\u6765\\u81ea\\u4e8e\\u666e\\u901a\\u7f51\\u53cb\\uff0c\\u5e76\\u4e14\\u7531\\u8bbf\\u8c08\\u5609\\u5bbe\\u76f4\\u63a5\\u8fdb\\u884c\\u56de\\u7b54\\uff0c\\u771f\\u6b63\\u505a\\u5230\\u4e86\\u5609\\u5bbe\\u4e0e\\u7f51\\u53cb\\u4e4b\\u95f4\\u7684\\u96f6\\u8ddd\\u79bb\\u4ea4\\u6d41\\u3002\",\"master\":[\"1797392503\"],\"banner_img\":\"http:\\/\\/debug.xweibo.cn\\/img\\/talk_pic_800.png\",\"contact\":\"\\u5728\\u7ebf\\u8bbf\\u8c08\\u63a5\\u53d7\\u5927\\u578b\\u6d3b\\u52a8\\u3001\\u7535\\u89c6\\u8282\\u76ee\\u4e92\\u52a8\\u7b49\\u76f8\\u5173\\u76f4\\u64ad\\u9700\\u6c42\\u7533\\u8bf7\\u3002 \\u3000\\u3000\\u5982\\u6709\\u76f4\\u64ad\\u9700\\u6c42\\u8bf7\\u79c1\\u4fe1@\\u5fae\\u535a\\u4e3b\\u6301\\u4eba\\uff0c\\u5e76\\u7559\\u4e0b\\u60a8\\u7684\\u59d3\\u540d\\u3001\\u8eab\\u4efd\\u548c\\u8054\\u7cfb\\u65b9\\u5f0f\\u3002 \\u3000\\u7d27\\u6025\\u4e8b\\u52a1\\u8bf7\\u8054\\u7cfb\\uff1a010-82244066\"}',1),('wb_page_type','2',1),('wb_header_model','1',1),('wb_header_htmlcode','',1),('api_checking','',1),('xwb_discuz_url','',1),('xwb_discuz_enable','',1),('use_person_domain','0',1),('site_short_link','',1),('microLive_setting','{\"desc\":\"\\u5728\\u7ebf\\u76f4\\u64ad\\u662f\\u4f9d\\u6258\\u4e8e\\u5fae\\u535a\\u57fa\\u7840\\uff0c\\u901a\\u8fc7\\u6c47\\u96c6\\u5fae\\u535a\\u4e0a\\u6765\\u81ea\\u5404\\u65b9\\u9762\\u7684\\u5b9e\\u65f6\\u4fe1\\u606f\\uff0c\\u5168\\u65b9\\u4f4d\\u5c55\\u73b0\\u5927\\u578b\\u6d3b\\u52a8\\u8fdb\\u7a0b\\u7684\\u76f4\\u64ad\\u5e73\\u53f0\\u3002\\u3000\\u5728\\u5728\\u7ebf\\u76f4\\u64ad\\u4e2d\\uff0c\\u666e\\u901a\\u7f51\\u53cb\\u4e5f\\u80fd\\u901a\\u8fc7\\u53c2\\u4e0e\\u73b0\\u573a\\u64ad\\u62a5\\uff0c\\u4e0e\\u660e\\u661f\\u5609\\u5bbe\\u4e00\\u540c\\u6210\\u4e3a\\u6d3b\\u52a8\\u7684\\u4e3b\\u89d2\\u3002\\u540c\\u65f6\\u4f9d\\u6258\\u5fae\\u535a\\u5feb\\u6377\\u7684\\u4f20\\u64ad\\u673a\\u5236\\u548c\\u5e9e\\u5927\\u7684\\u7528\\u6237\\u57fa\\u7840\\uff0c\\u5728\\u7ebf\\u76f4\\u64ad\\u5df2\\u6210\\u4e3a\\u6d3b\\u52a8\\u4fe1\\u606f\\u6700\\u5feb\\u901f\\u7684\\u4f20\\u64ad\\u5e73\\u53f0\\u3002\",\"master\":\"1797392503\",\"banner_img\":\"http:\\/\\/debug.xweibo.cn\\/img\\/live_bg.jpg\",\"contact\":\"\\u5728\\u7ebf\\u76f4\\u64ad\\u63a5\\u53d7\\u5927\\u578b\\u6d3b\\u52a8\\u3001\\u7535\\u89c6\\u8282\\u76ee\\u4e92\\u52a8\\u7b49\\u76f8\\u5173\\u76f4\\u64ad\\u9700\\u6c42\\u7533\\u8bf7\\u3002\\r\\n\\u3000\\u3000\\u5982\\u6709\\u76f4\\u64ad\\u9700\\u6c42\\u8bf7\\u79c1\\u4fe1@\\u5fae\\u535a\\u4e3b\\u6301\\u4eba\\uff0c\\u5e76\\u7559\\u4e0b\\u60a8\\u7684\\u59d3\\u540d\\u3001\\u8eab\\u4efd\\u548c\\u8054\\u7cfb\\u65b9\\u5f0f\\u3002 \\r\\n\\u3000\\u3000\\u7d27\\u6025\\u4e8b\\u52a1\\u8bf7\\u8054\\u7cfb\\uff1a010-82244066\"}',1),('default_use_custom','1',1),('open_user_local_relationship','0',1),('logo_wap','var/data/logo/logo_upload_wap.png',1),('logo_output','var/data/logo/logo_upload_output.png',1),('skin_custom','{\"colors\":\"0082cb,44b1da,8dd7f5,444,000\",\"bg\":\"http:\\/\\/debug.xweibo.cn\\/var\\/data\\/skinbg\\/42abef0cf2f0a67f98182b3cd8176c68.png?_rand=1306314896\",\"align\":\"2\",\"fixed\":\"0\"}',1);
/*!40000 ALTER TABLE `xwb_sys_config` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `xwb_today_topics`
--

DROP TABLE IF EXISTS `xwb_today_topics`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xwb_today_topics` (
  `group_id` int(10) unsigned NOT NULL COMMENT '话题分组ID',
  `topic` varchar(45) NOT NULL COMMENT '话题内容',
  `effect_time` int(10) unsigned NOT NULL COMMENT '生效时间'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='今日话题的内容';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `xwb_today_topics`
--

LOCK TABLES `xwb_today_topics` WRITE;
/*!40000 ALTER TABLE `xwb_today_topics` DISABLE KEYS */;
/*!40000 ALTER TABLE `xwb_today_topics` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `xwb_user_action`
--

DROP TABLE IF EXISTS `xwb_user_action`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xwb_user_action` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sina_uid` bigint(20) NOT NULL,
  `action_type` smallint(6) NOT NULL COMMENT '1、禁言 2、禁止用户登录、3、清除用户信息（不删除、仅是在任何情况不显示） 4、恢复正常',
  PRIMARY KEY (`id`),
  UNIQUE KEY `sina_uid` (`sina_uid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `xwb_user_action`
--

LOCK TABLES `xwb_user_action` WRITE;
/*!40000 ALTER TABLE `xwb_user_action` DISABLE KEYS */;
/*!40000 ALTER TABLE `xwb_user_action` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `xwb_user_ban`
--

DROP TABLE IF EXISTS `xwb_user_ban`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xwb_user_ban` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sina_uid` bigint(20) unsigned NOT NULL COMMENT '新浪用户ID',
  `ban_time` int(11) DEFAULT NULL COMMENT '封禁时间',
  `nick` varchar(20) DEFAULT NULL COMMENT '封禁用户的昵称',
  PRIMARY KEY (`id`),
  KEY `nick` (`nick`),
  KEY `sina_uid` (`sina_uid`)
) ENGINE=MyISAM AUTO_INCREMENT=56 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='封禁用户列表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `xwb_user_ban`
--

LOCK TABLES `xwb_user_ban` WRITE;
/*!40000 ALTER TABLE `xwb_user_ban` DISABLE KEYS */;
/*!40000 ALTER TABLE `xwb_user_ban` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `xwb_user_config`
--

DROP TABLE IF EXISTS `xwb_user_config`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xwb_user_config` (
  `id` int(4) unsigned NOT NULL AUTO_INCREMENT,
  `sina_uid` bigint(20) unsigned NOT NULL,
  `values` varchar(510) NOT NULL DEFAULT '0' COMMENT '用户自定义的配置',
  PRIMARY KEY (`id`),
  UNIQUE KEY `sina_uid` (`sina_uid`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='用户自定义配置的信息';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `xwb_user_config`
--

LOCK TABLES `xwb_user_config` WRITE;
/*!40000 ALTER TABLE `xwb_user_config` DISABLE KEYS */;
INSERT INTO `xwb_user_config` VALUES (1,1808484354,'{\"user_newfeed\":\"\",\"user_newmsg\":\"\",\"user_newnotice\":\"1\",\"user_page_wb\":50,\"user_page_comment\":20,\"user_skin\":\"2\",\"wap_font_size\":\"1\",\"wap_show_pic\":\"1\",\"wap_page_wb\":\"10\",\"new_followers\":0,\"index_listId\":\"\"}'),(2,11055,'{\"user_newfeed\":\"\",\"user_newmsg\":\"\",\"user_newnotice\":\"1\",\"user_page_wb\":50,\"user_page_comment\":20,\"user_skin\":\"11\",\"wap_font_size\":\"1\",\"wap_show_pic\":\"1\",\"wap_page_wb\":\"10\",\"new_followers\":0,\"index_listId\":\"\"}');
/*!40000 ALTER TABLE `xwb_user_config` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `xwb_user_focus`
--

DROP TABLE IF EXISTS `xwb_user_focus`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xwb_user_focus` (
  `id` int(10) NOT NULL,
  `sina_uid` bigint(20) NOT NULL,
  `topic` varchar(45) NOT NULL,
  `source` tinyint(1) DEFAULT NULL,
  `add_time` date NOT NULL,
  PRIMARY KEY (`id`),
  KEY `user_focus_uid_index` (`sina_uid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='保存用户关注的话题';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `xwb_user_focus`
--

LOCK TABLES `xwb_user_focus` WRITE;
/*!40000 ALTER TABLE `xwb_user_focus` DISABLE KEYS */;
/*!40000 ALTER TABLE `xwb_user_focus` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `xwb_user_follow`
--

DROP TABLE IF EXISTS `xwb_user_follow`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xwb_user_follow` (
  `friend_uid` bigint(20) NOT NULL COMMENT '被关注用户ID',
  `fans_uid` bigint(20) NOT NULL COMMENT '粉丝用户ID',
  `datetime` int(10) DEFAULT NULL COMMENT '时间',
  PRIMARY KEY (`friend_uid`,`fans_uid`),
  KEY `datetime_idx` (`datetime`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='关注表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `xwb_user_follow`
--

LOCK TABLES `xwb_user_follow` WRITE;
/*!40000 ALTER TABLE `xwb_user_follow` DISABLE KEYS */;
/*!40000 ALTER TABLE `xwb_user_follow` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `xwb_user_follow_copy`
--

DROP TABLE IF EXISTS `xwb_user_follow_copy`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xwb_user_follow_copy` (
  `friend_uid` bigint(20) NOT NULL COMMENT '被关注用户ID',
  `fans_uid` bigint(20) NOT NULL COMMENT '粉丝用户ID',
  `datetime` int(10) DEFAULT NULL COMMENT '时间',
  PRIMARY KEY (`friend_uid`,`fans_uid`),
  KEY `datetime_idx` (`datetime`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='关注表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `xwb_user_follow_copy`
--

LOCK TABLES `xwb_user_follow_copy` WRITE;
/*!40000 ALTER TABLE `xwb_user_follow_copy` DISABLE KEYS */;
INSERT INTO `xwb_user_follow_copy` VALUES (11001,1769262321,1306132662);
/*!40000 ALTER TABLE `xwb_user_follow_copy` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `xwb_user_verify`
--

DROP TABLE IF EXISTS `xwb_user_verify`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xwb_user_verify` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sina_uid` bigint(20) unsigned NOT NULL COMMENT '新浪用户ID',
  `nick` varchar(45) NOT NULL COMMENT '要加V的用户',
  `reason` varchar(50) DEFAULT NULL COMMENT '认证理由',
  `add_time` int(10) unsigned DEFAULT NULL COMMENT '添加认证时间',
  `operator` bigint(20) NOT NULL COMMENT '操作者的ID',
  PRIMARY KEY (`id`),
  UNIQUE KEY `index_nick` (`nick`),
  KEY `index_add_time` (`add_time`)
) ENGINE=MyISAM AUTO_INCREMENT=79 DEFAULT CHARSET=utf8 COMMENT='要加V的用户';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `xwb_user_verify`
--

LOCK TABLES `xwb_user_verify` WRITE;
/*!40000 ALTER TABLE `xwb_user_verify` DISABLE KEYS */;
/*!40000 ALTER TABLE `xwb_user_verify` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `xwb_users`
--

DROP TABLE IF EXISTS `xwb_users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xwb_users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sina_uid` bigint(20) unsigned NOT NULL COMMENT '新浪用户ID',
  `nickname` varchar(25) NOT NULL COMMENT '昵称',
  `first_login` int(10) unsigned DEFAULT NULL COMMENT '首次登陆时间',
  `access_token` varchar(50) DEFAULT NULL COMMENT '授权后得到访问API的token',
  `token_secret` varchar(50) DEFAULT NULL COMMENT 'API服务器生成的加密串',
  `uid` bigint(20) DEFAULT NULL COMMENT '所捆绑的合作方的用户ID',
  `domain_name` varchar(45) DEFAULT NULL COMMENT '用户设置的个性化域名',
  `max_notice_time` int(11) DEFAULT '0' COMMENT '用户最后一次阅读的起效的最新通知的时间戳',
  PRIMARY KEY (`id`),
  UNIQUE KEY `sina_uid` (`sina_uid`),
  KEY `nickname` (`nickname`),
  KEY `site_uid` (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='用户表---所有登录过的用户';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `xwb_users`
--

LOCK TABLES `xwb_users` WRITE;
/*!40000 ALTER TABLE `xwb_users` DISABLE KEYS */;
/*!40000 ALTER TABLE `xwb_users` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `xwb_weibo_copy`
--

DROP TABLE IF EXISTS `xwb_weibo_copy`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xwb_weibo_copy` (
  `id` bigint(20) unsigned NOT NULL COMMENT '微博id',
  `weibo` tinytext COMMENT '微博内容',
  `uid` bigint(20) unsigned DEFAULT NULL,
  `nickname` varchar(45) DEFAULT NULL COMMENT '作者',
  `addtime` int(11) DEFAULT NULL COMMENT '发布时间',
  `disabled` varchar(1) DEFAULT NULL COMMENT '是否被屏蔽',
  PRIMARY KEY (`id`),
  KEY `addtime` (`addtime`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `xwb_weibo_copy`
--

LOCK TABLES `xwb_weibo_copy` WRITE;
/*!40000 ALTER TABLE `xwb_weibo_copy` DISABLE KEYS */;
INSERT INTO `xwb_weibo_copy` VALUES (11135840920,'#金像奖# 第30届香港电影#金像奖#颁奖典礼」精彩瞬间，最佳男主角谢霆锋拥抱张家辉。',1808484354,'熊-斌',1306223286,'0'),(11135851318,'#金像奖#：第30届香港电影#金像奖#颁奖典礼」精彩瞬间，最佳男主角谢霆锋亲吻柏芝。',1808484354,'熊-斌',1306223299,'0'),(11135872292,'#金像奖# 第30届香港电影金像奖圆满结束，恭喜所有台前幕后的得奖者！并感谢各位提名电影人！一同鉴证香港电影辉煌的历程，并为这一长卷增添更加精彩的一笔！我们明年再见！',1808484354,'熊-斌',1306223327,'0'),(11135886361,'#金像奖#：《打擂台》出人意料的获得最佳影片，剧组主创兴奋的上到台前。这也是老板刘德华继96年投资《香港制造》之后，再次投资获得金像奖最佳影片。【补：刚才漏泄一行字——郑思杰',1808484354,'熊-斌',1306223356,'0'),(11135908309,'#金像奖# //國際官方影迷會:她今年是頒獎嘉賓[做鬼脸][good]',1808484354,'熊-斌',1306223383,'0'),(11135945672,'#金像奖# 林家栋：多谢刘德华。多谢宣传和支持这部电影的人',1808484354,'熊-斌',1306223420,'0'),(11137908093,'@熊-斌 如果姓氏人群比较少 会不会不做呢 如果是新姓 比如汪涵和杨乐乐的孩子 他取名为汪杨#* 会不会也算一个姓',1819991891,'test_weibo',1306225877,'0'),(11137942056,'@熊-斌 我看资料说“姚”分出来的姓氏可能比王氏的人还多 请问这是客套话还是真的？',1819991891,'test_weibo',1306225906,'0'),(11137990474,'@熊-斌 全国现在大概有多少个姓氏？有没有那种历史上没有，自己编的姓？[嘻嘻]',1819991891,'test_weibo',1306225962,'0'),(11138018024,'@熊-斌 请问山东毕姓的起源，谢谢',1819991891,'test_weibo',1306225996,'0'),(11138018056,'呃，那可以去广东做书记了……：）',1808484354,'熊-斌',1306225996,'0'),(11138026329,'被围观更累啊……',1808484354,'熊-斌',1306226016,'0'),(11138047966,'貌似答过了……：）',1808484354,'熊-斌',1306226032,'0'),(11138055261,'@熊-斌 想了解“宫”姓的来历，历史上有木有什么耀眼滴祖先，除了听过“唇亡齿寒”典故中有个叫宫之奇的谋士，至今还木有发现，请先生不吝赐教',1819991891,'test_weibo',1306226052,'0'),(11138067758,'貌似答过了……：）。',1808484354,'熊-斌',1306226057,'0'),(11138088006,'呃，找不到问题在哪里，也可以过后在我的微博里交流，抱歉了……：）',1808484354,'熊-斌',1306226079,'0'),(11138091932,'@熊-斌 我想问一下，山东临沂境内复姓诸葛的和诸葛亮有关系没？',1819991891,'test_weibo',1306226083,'0'),(11138098358,'陈友谅不姓陈，姓谢。他战败后，儿子去了韩国。你所说的长者是归国华侨？',1808484354,'熊-斌',1306226091,'0'),(11138104117,'理了……：）',1808484354,'熊-斌',1306226110,'0'),(11138114661,'找问题，是个体力活……',1808484354,'熊-斌',1306226122,'0'),(11138126955,'当然有……：）',1808484354,'熊-斌',1306226137,'0'),(11139715094,'@my_todo 姓氏文化与我们当下的每一个人有关，而有一些传统的复姓像：夏侯、司空、令狐、独孤等等，这些复姓已经渐渐的淡出了人们的视野，对于这些淡化的复姓我们是该寻找其根，还是任由',1819991891,'test_weibo',1306228023,'0'),(11139753806,'@my_todo 中国什么姓氏是最古老的姓氏？',1819991891,'test_weibo',1306228069,'0'),(11139763947,'@my_todo 请问研究过“彭”姓吗？是什么时候开始有这个姓的',1819991891,'test_weibo',1306228092,'0'),(11139794666,'@my_todo 请问姓氏文化和家谱文化之间，除了同为寻根之外，有没有什么联系与区别？',1819991891,'test_weibo',1306228118,'0'),(11139810230,'@my_todo 我想问姓氏文化是怎么一步步传承并延续至今的。中国有上千个姓,可这都是人们怎么想出来得....没有姓氏的时候用名不也一样好么。',1819991891,'test_weibo',1306228137,'0'),(11139816181,'@my_todo 为什么中国姓氏的来历要把姓和氏分别等同看待，它们有什么不同的起源吗?',1819991891,'test_weibo',1306228156,'0'),(11140779515,'不错~',1916644671,'my_todo',1306229292,'0'),(11140790141,'不错~~',1916644671,'my_todo',1306229304,'0'),(11140794525,'不错~~不错~~',1916644671,'my_todo',1306229311,'0'),(11140800737,'不错~~不错~~不错~~不错~~',1916644671,'my_todo',1306229317,'0'),(11140807085,'不错~~不错~~不错~~不错~~不错~~',1916644671,'my_todo',1306229324,'0'),(11140813683,'不错~~不错~~不错~~不错~~不错~~不错~~',1916644671,'my_todo',1306229332,'0'),(11189725873,'#金像奖#花絮：《打擂台》出人意料的获得最佳影片，剧组主创兴奋的上到台前。这也是老板刘德华继96年投资《香港制造》之后，再次投资获得金像奖最佳影片。【补：刚才漏泄一行字——郑',1808484354,'熊-斌',1306308960,'0'),(11189736620,'#金像奖##香港金像奖# 刚刚获得最佳女主角的劉嘉玲火速换装再上台与成龙共同颁发最佳电影——《打擂台》！黑马跑出，全体演员激动上台领奖，林家栋大呼“香港精神”！恭喜华仔！！',1808484354,'熊-斌',1306308972,'0'),(11189741079,'#金像奖#《打擂台》能获最佳影片，最根本是反映香港影人和金像奖的现状心态。当年打遍天下风华正茂，却一下就陷入低谷记忆迷失。现如今CEPA都已签了很多年，香港电影已经度过何去何从的',1808484354,'熊-斌',1306308986,'0'),(11189744473,'#金像奖#林家栋：华仔。首先感谢感谢福克斯。感谢博纳。感谢银都机构。多谢导演给这个剧本我。这么多前辈出来帮我们，才造就了这部电影诞生。票房不重要，重要的是背后的精神、背后的',1808484354,'熊-斌',1306308993,'0'),(11189750363,'#金像奖#喜欢这个画面！心洁今晚好美！',1808484354,'熊-斌',1306309003,'0'),(11189758053,'#金像奖#微博直播「第30届香港电影#金像奖#颁奖典礼」本届金像奖颁奖典礼正式结束，@HK娛樂圈 感谢各位朋友的关注，咱们下次见！！！',1808484354,'熊-斌',1306309014,'0'),(11189764973,'#金像奖#最佳电影：打擂台。全场掌声雷动。导演郑思杰激动得振臂高呼，冲上台跑步转圈。监制和导演都纷纷强调，电影赢在香港精神。他们最后都多谢刘德华：“多谢华仔信这部戏，多谢！',1808484354,'熊-斌',1306309028,'0');
/*!40000 ALTER TABLE `xwb_weibo_copy` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2011-05-26 10:30:47
