【SQL开源代码栏目提醒】:文章导读:在新的一年中,各位网友都进入紧张的学习或是工作阶段。网学会员整理了SQL开源代码-fy.sql的相关内容供大家参考,祝大家在新的一年里工作和学习顺利!
DROP TABLE IF EXISTS fy_articles;
CREATE TABLE fy_articles (
`articleid` mediumint(8) unsigned NOT NULL auto_increment,
`cid` smallint(6) unsigned NOT NULL default '0',
`uid` mediumint(8) unsigned NOT NULL default '0',
`title` varchar(255) NOT NULL default '',
`content` mediumtext NOT NULL,
`keywords` varchar(120) NOT NULL default '',
`dateline` int(10) unsigned NOT NULL default '0',
`views` int(10) unsigned NOT NULL default '0',
`comments` mediumint(8) unsigned NOT NULL default '0',
`attachments` text NOT NULL,
`closecomment` tinyint(1) NOT NULL default '0',
`visible` tinyint(1) NOT NULL default '1',
`stick` tinyint(1) unsigned NOT NULL default '0',
PRIMARY KEY (`articleid`),
KEY `cid` (`cid`),
KEY `uid` (`uid`),
KEY `keywords` (`key
words`),
KEY `dateline` (`dateline`),
KEY `visible` (`visible`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=26 ;
INSERT INTO `fy_articles` VALUES
(17, 4, 1, '鏈杩戠湅鐨勭數褰便婃灙鎵嬨?, '<p>銆銆缇庡浗鏈鏂板姩浣滃ぇ鐗囥婃灙鎵嬨嬶紝杩欎釜鏉鎵嬫绘槸閭d箞鍐烽潤锛佺湅锛岃繖涓紝杩欎釜鐓х墖寰堥叿鍚э紒<img alt="" border="0" src="/fy/images/smiles/28.gif" /><img alt="" border="0" src="/fy/images/smiles/6.gif" /><br />\r\n銆銆[attach=6]</p>', '鐢靛奖', 1187540183, 7, 0, 'a:1:{i:6;a:11:{s:12:"attachmentid";i:6;s:8:"dateline";i:1187540183;s:8:"filename";s:10:"鏋墜.jpg";s:8:"filetype";s:11:"image/pjpeg";s:8:"filepath";s:49:"/date_200708/f2632be6f773a712569610816486e2b2.jpg";s:8:"filesize";s:5:"81195";s:9:"downloads";i:1;s:14:"thumb_filepath";N;s:11:"thumb_width";N;s:12:"thumb_height";N;s:7:"isimage";s:1:"1";}}', 0, 1, 1),
(18, 4, 1, '鏈杩戠湅鐨勭數褰便婃亱鐖卞埡瀹€?, '<p>銆銆<img alt="" border="0" src="/fy/images/smiles/29.gif" />缇庡浗鎼炵瑧澶х墖锛岀編鍥芥悶绗戠墖鐪熺殑寰堜笉閿欙紝姣旇緝澶稿紶銆傛帹鑽愪竴涓嬨傘傘?br />\r\n銆銆[attach=7]<br />\r\n銆銆[attach=8]</p>', '鐢靛奖', 1187540728, 32, 1, 'a:2:{i:7;a:11:{s:12:"attachmentid";i:7;s:8:"dateline";i:1187540728;s:8:"filename";s:16:"鎭嬬埍鍒哄.jpg";s:8:"filetype";s:11:"image/pjpeg";s:8:"filepath";s:49:"/date_200708/9e8c216c12e5cf3fdbcb07ff6774829d.jpg";s:8:"filesize";s:6:"111328";s:9:"downloads";i:4;s:14:"thumb_filepath";N;s:11:"thumb_width";N;s:12:"thumb_height";N;s:7:"isimage";s:1:"1";}i:8;a:11:{s:12:"attachmentid";i:8;s:8:"dateline";i:1187540762;s:8:"filename";s:17:"鎭嬬埍鍒哄1.jpg";s:8:"filetype";s:11:"image/pjpeg";s:8:"filepath";s:49:"/date_200708/8f216c7c6623e31f7a1ce4f4a8f47fc1.jpg";s:8:"filesize";s:6:"154116";s:9:"downloads";i:2;s:14:"thumb_filepath";N;s:11:"thumb_width";N;s:12:"thumb_height";N;s:7:"isimage";s:1:"1";}}', 0, 1, 1),
(19, 4, 1, '鏈杩戠湅鐨勭數褰便婂洶鍏姐?, '<p> 杩欓儴鐗囧瓙鐨勬儏鑺傛病鏈変竴鐐规柊鎰忥紝閲屽ご鏈変釜濂冲濂藉竻锛屼笉鐭ラ亾璋佹紨鐨勶紝璋佺煡閬擄紵<img alt="" border="0" src="/fy/images/smiles/22.gif" />杈夋瘡澶╁幓閭d釜閰掑惂鍠濆悓鏍蜂竴绉嶉ギ鏂欙紝姣忔绂诲紑鐨勬椂鍊欓兘闂ス鍚屾牱涓涓棶棰橈細”浠婂ぉ鏈変汉鎺ヤ綘涓嬬彮鍚э紵“濂规瘡娆¢兘鍥炵瓟锛?rdquo;鎴戜笉鐢ㄥ埆浜烘帴鎴戜笅鐝?ldquo;锛岀粨鏋滄湁涓娆¤緣鏉ヤ簡锛屼粈涔堥兘娌℃湁璇达紝濂规兂濂逛互鍚庝及璁′笉浼氬啀鏉ヤ簡<img alt="" border="0" src="/fy/images/smiles/28.gif" />...<br />\r\n [attach=9]</p>', '鐢靛奖', 1187541167, 171, 6, '', 0, 1, 1);
INSERT INTO `fy_articles` VALUES
(20, 5, 1, 'bbsxp 0day鍐嶇幇姹熸箹,webshell杞绘澗鎷?, '<p><font style="background-color: #ffffff" color="#ff9900" size="1">娉細鏈枃鍙戣〃浜庛婇粦瀹㈤槻绾裤嬫潅蹇?7骞寸5鏈燂紝鐗堟潈褰掑叾鎵鏈夛紝璋㈢粷杞浇锛?/font><br />\r\n bbsxp 0d