
-- --------------------------------------------------------

--
-- 資料表結構 `bcyc_msg`
--

CREATE TABLE `bcyc_msg` (
  `IndexId` int(10) UNSIGNED NOT NULL,
  `BcycId` varchar(9) COLLATE utf8_unicode_ci NOT NULL,
  `OkFlag` varchar(2) COLLATE utf8_unicode_ci NOT NULL,
  `MsgId` varchar(18) COLLATE utf8_unicode_ci DEFAULT NULL,
  `MsgTmk` datetime NOT NULL,
  `xMsgUrl` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `MsgTitle` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `xMsgPic` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `MsgLead` text COLLATE utf8_unicode_ci NOT NULL,
  `AuthIcon` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `AuthName` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `DispFormat` varchar(4) COLLATE utf8_unicode_ci NOT NULL,
  `xViewCnt` mediumint(8) UNSIGNED DEFAULT NULL,
  `xLikeCnt` mediumint(8) UNSIGNED DEFAULT NULL,
  `xBookCnt` mediumint(8) UNSIGNED DEFAULT NULL,
  `xCommentCnt` mediumint(8) UNSIGNED DEFAULT NULL,
  `DispPos` decimal(7,3) UNSIGNED DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- 傾印資料表的資料 `bcyc_msg`
--

INSERT INTO `bcyc_msg` (`IndexId`, `BcycId`, `OkFlag`, `MsgId`, `MsgTmk`, `xMsgUrl`, `MsgTitle`, `xMsgPic`, `MsgLead`, `AuthIcon`, `AuthName`, `DispFormat`, `xViewCnt`, `xLikeCnt`, `xBookCnt`, `xCommentCnt`, `DispPos`) VALUES
(1, '430821110', '0', '4308211000001', '2015-11-27 01:01:01', 'http://health.people.com.cn/n/2015/0506/c14739-26957220.html', 'ç”·æ€•ä¼¤è‚å¥³æ€•ä¼¤è‚¾ 4ç§é£Ÿç‰©è¡¥è‚¾å…»å‡ºç¾Žå¥³', 'http://www.people.com.cn/mediafile/pic/20150506/18/4146054766862733522.jpg', 'ä¿—è¯è¯´ï¼šç”·æ€•ä¼¤è‚ï¼Œå¥³æ€•ä¼¤è‚¾ã€‚è‚¾å¯¹å¥³äººæ¥è¯´ååˆ†é‡è¦ã€‚è€Œæ¯ä¸ªæœˆçš„æœˆç»ã€ä»Žåæœˆæ€€èƒŽåˆ°åˆ†å¨©ï¼Œéƒ½ä¼šä½¿å¥³æ€§çš„è‚¾æ°”äºæŸã€‚é‚£ä½ åˆæ˜¯å¦çŸ¥é“è‡ªå·±æœ‰è‚¾ç—…å‘¢ï¼Ÿåˆåº”è¯¥åƒä»€ä¹ˆè¡¥è‚¾å‘¢ï¼Ÿ', '/pic-icon/4212221020301-20150504123020066286.jpg', 'å°å°æŽ', '310', 1233, 45, 110, 15, '101.000'),
(2, '430821101', '0', '4308211000002', '2015-11-27 02:00:00', 'http://www.360doc.com/content/13/1027/20/13525497_324621477.shtml', 'å¤§å¤šæ•°è½¦ä¸»ä¸çŸ¥é“çš„è½¦å†…åŠŸèƒ½ï¼Œ æœ‰è½¦æ—æ”¶è—ï¼', 'http://y0.ifengimg.com/cmpp/2015/05/07/09/4db16333-2d32-48ae-9f98-7e9d860be49d_size36_w600_h450.jpg', 'ä¹Ÿè®¸å¾ˆå¤šæœ‹å‹ä¸çŸ¥é“ï¼Œé®é˜³æ¿æ˜¯å¯ä»¥å‘ä¾§é¢è½¬åŠ¨çš„ï¼Œå½“æˆ‘ä»¬ä¾§é¢é¢å¯¹é˜³å…‰çš„æ—¶å€™ï¼Œå¯ä»¥å°†é®é˜³æ¿çš„ä¸€ç«¯æ—‹è½¬è‡³ä¾§é¢æ¥é®æŒ¡ä¸¤ä¾§çš„é˜³å…‰ã€‚', '/pic-icon/4212221020303-20150506145036467011.jpg', 'è½¦æ¨¡å°é™ˆ', '110', 1356, 223, 14, 5, '201.000'),
(3, '430821101', '0', '4308211000003', '2015-11-27 05:00:00', 'http://www.360doc.com/content/13/0924/20/11698101_316817875.shtml', 'é©¾æ ¡ä¸æ•™çš„çŸ¥è¯† ä¾§æ–¹åœè½¦çš„å®žç”¨æŠ€å·§', 'http://www.people.com.cn/mediafile/pic/20150506/95/18180737182640776335.jpg', 'æ‰¾åˆ°äº†åˆé€‚çš„èµ·å§‹ä½ç½®ï¼Œæˆ‘ä»¬å°±å¯ä»¥å¼€å§‹å€’è½¦äº†ï¼Œæ­¤æ—¶å°†æ–¹å‘å‘å³ä¾§æ‰“æ»¡ï¼Œï¼ˆä¸ºäº†æ›´å¥½åœ°ä¿æŠ¤è½¬å‘ç³»ç»Ÿï¼Œå»ºè®®åœ¨æ‰“æ»¡åŽå‘ç›¸åæ–¹å‘å›žä¸€ç‚¹ã€‚ï¼‰å¹¶ä¸”å¼€å§‹ç¼“æ…¢å€’è½¦ï¼Œå½“è½¦å¤´ä¸Žæ—è½¦æˆ45åº¦è§’æ—¶å°†æ–¹å‘å›žæ­£ã€‚å¾€å¾€ä½œä¸ºé©¾é©¶å‘˜å¾ˆéš¾ä»Žè½¦å†…è§†è§’ä¸­åˆ¤æ–­å‡ºæ˜¯å¦è¾¾åˆ°45åº¦ï¼Œè¿™é‡Œä»‹ç»ä¸€ä¸ªå°æŠ€å·§ï¼Œå½“ä½ è§‚å¯Ÿå³ä¾§åŽè§†é•œçš„å¤–ä¾§ä¸Žæ—è½¦BæŸ±å³å°†é‡å ï¼Œä»Žå·¦ä¾§åŽè§†é•œå¯ä»¥çœ‹è§å®Œæ•´çš„åŽè½¦ï¼Œæ­¤æ—¶åŸºæœ¬å¤„äºŽ45åº¦çš„è½¦è¾†çŠ¶æ€ï¼Œæ–¹å‘å¯ä»¥å›žæ­£äº†ã€‚', '/pic-icon/4212221020302-20150506144338070641.jpg', 'è½¦å¥³çŽ‹', '220', 345, 219, 145, 49, '202.000'),
(4, '430821110', '0', '4308211000004', '2015-11-27 05:50:00', 'http://fashion.ifeng.com/a/20150507/40105413_0.shtml', 'é£Ÿç–—ï¼šé¥­åŽä¸€ç§æ°´æžœæŽ’ç©ºä½“å†…è‡´ç™Œç‰©', 'http://y3.ifengimg.com/a/2014_39/305fbd236fad6d8.jpg', 'æ¢¨å«æœ‰ä¸°å¯Œçš„ç»´ç”Ÿç´ ã€è†³é£Ÿçº¤ç»´å’Œé’™ã€ç£·ã€é“ã€ç¢˜ç­‰å¾®é‡å…ƒç´ ã€‚ç»å¸¸åƒæ¢¨ï¼Œä¸ä»…èƒ½é¢„é˜²ä¾¿ç§˜ï¼Œè¿˜èƒ½ä¿ƒè¿›äººä½“å†…è‡´ç™Œç‰©è´¨çš„æŽ’å‡ºã€€æ¢¨è™½ç„¶å¾ˆç”œï¼Œä½†å…¶çƒ­é‡å’Œè„‚è‚ªå«é‡å¾ˆä½Žï¼Œä¸­è€å¹´äººå¤šåƒäº›æ¢¨ï¼Œå¯ä»¥å¸®åŠ©äººä½“å‡€åŒ–å™¨å®˜ï¼Œè½¯åŒ–è¡€ç®¡ã€‚åƒæ¢¨è¿˜å¯¹åŽŒé£Ÿã€æ¶ˆåŒ–ä¸è‰¯ã€è‚ ç‚Žã€æ…¢æ€§å’½ç‚Žç­‰ç–¾ç—…æœ‰ä¸€å®šçš„è¾…åŠ©ç–—æ•ˆã€‚ä¸è¿‡ï¼Œä¸“å®¶æé†’ï¼Œæ¢¨è™½ç„¶æ˜¯ä½³æžœï¼Œä¹Ÿä¸å®œå¤šé£Ÿï¼Œé£Žå¯’å’³å—½ã€è„˜è…¹å†·ç—›ã€è„¾è™šä¾¿æºè€…ä»¥åŠäº§å¦‡éƒ½è¦æ…Žé£Ÿã€‚æ¢¨è¿˜æœ‰åˆ©å°¿ä½œç”¨ï¼Œå¤œå°¿é¢‘è€…ç¡å‰è¦å°‘åƒæ¢¨ã€‚æ¢¨å«æžœé…¸å¤šï¼Œèƒƒé…¸è¾ƒå¤šçš„äººä¹Ÿä¸å¯å¤šé£Ÿã€‚\r\n', '/pic-icon/4212221020302-20150505171340526100.jpg', 'ä¸»äººå‘µå‘µäº†', '220', 318, 290, 43, 13, '203.000'),
(5, '430821101', '0', '4308211000005', '2015-11-27 06:20:00', 'http://www.360doc.com/content/13/0821/18/277419_308819470.shtm', 'æ€Žæ ·ä¿®å¤ç”µåŠ¨è½¦ç”µç“¶', 'http://img5.cache.netease.com/baby/2015/5/6/2015050617264800dc9.jpg', 'ç”µç“¶åœ¨ä½¿ç”¨ä¸€æ®µæ—¶é—´åŽï¼Œéƒ½ä¼šå‡ºçŽ°ç”µæ± å®¹é‡ä¸‹é™ï¼Œä¸‹é¢æˆ‘æ•™å¤§å®¶è‡ªå·±ç®€å•ä¿®å¤ç”µåŠ¨è½¦ç”µç“¶ï¼Œå»¶é•¿ç”µç“¶çš„ä½¿ç”¨å¯¿å‘½ã€‚', '/pic-icon/4212221020301-20150504122836911369.jpg', 'ä¸Šçš„äº†å¤©å ‚', '210', 318, 146, 44, 98, '204.000');
