简单的blog，适合初学者

-- phpMyAdmin SQL Dump -- version 3.2.1-rc1 -- http://www.phpmyadmin.net -- -- 主机: localhost -- 生成日期: 2009 年 08 月 02 日 06:04 -- 服务器版本: 5.1.34 -- PHP 版本: 5.2.10 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; -- -- 数据库: `myblog` -- -- -------------------------------------------------------- -- -- 表的结构 `categories` -- CREATE TABLE IF NOT EXISTS `categories` ( `id` tinyint(4) NOT NULL AUTO_INCREMENT, `cat` varchar(20) NOT NULL, PRIMARY KEY (`id`), KEY `id` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=gbk AUTO_INCREMENT=5 ; -- -- 转存表中的数据 `categories` -- INSERT INTO `categories` (`id`, `cat`) VALUES (1, 'Life'), (2, 'Work'), (3, 'Music'), (4, 'Food'); -- -------------------------------------------------------- -- -- 表的结构 `comments` -- CREATE TABLE IF NOT EXISTS `comments` ( `id` int(11) NOT NULL AUTO_INCREMENT, `blog_id` int(11) NOT NULL, `dateposted` datetime NOT NULL, `name` varchar(50) NOT NULL, `comment` text NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=gbk AUTO_INCREMENT=9 ; -- -- 转存表中的数据 `comments` -- INSERT INTO `comments` (`id`, `blog_id`, `dateposted`, `name`, `comment`) VALUES (1, 1, '2009-07-30 19:30:52', 'Bob', 'Hello,nice to meet you!'), (2, 1, '2009-07-30 19:30:52', 'Jack', 'Hope you have lots of fun!'), (3, 32, '2009-08-02 02:00:50', '路飞', '膜拜。。'), (4, 36, '2009-08-02 02:26:30', '11', '111'), (5, 36, '2009-08-02 02:26:37', '11', '1111'), (6, 34, '2009-08-02 02:28:39', '111', '111'), (7, 40, '2009-08-02 14:01:34', '影之叶', '美女~~'), (8, 40, '2009-08-02 14:02:19', '测试', '测试测试~~'); -- -------------------------------------------------------- -- -- 表的结构 `entries` -- CREATE TABLE IF NOT EXISTS `entries` ( `id` int(11) NOT NULL AUTO_INCREMENT, `cat_id` tinyint(4) unsigned NOT NULL, `dateposted` datetime NOT NULL, `subject` varchar(100) NOT NULL, `body` text NOT NULL, `heart` tinyint(4) unsigned zerofill NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=gbk AUTO_INCREMENT=42 ; -- -- 转存表中的数据 `entries` -- INSERT INTO `entries` (`id`, `cat_id`, `dateposted`, `subject`, `body`, `heart`) VALUES (1, 1, '2009-08-01 02:31:01', '测试2', '哈哈哈哈哈<br /><br />\r\n哈哈哈哈哈<br /><br />\r\n哈哈哈哈哈<br /><br />\r\n哈哈哈哈哈', 0001), (2, 1, '2009-08-01 02:31:01', '测试2', '哈哈哈哈哈<br /><br />\r\n哈哈哈哈哈<br /><br />\r\n哈哈哈哈哈<br /><br />\r\n哈哈哈哈哈', 0001), (7, 1, '2009-08-01 02:54:15', '测试测试！！', 'dho o <br />\r\nsj哦等等dd <br />\r\n打交道跑打交道<br />\r\n的大跨度大跨度<br />\r\n 大跨度大跨度<br />\r\nddk的kd的d的ld 顿了顿kd<br />\r\n<br />\r\n代理dld的dl的<br />\r\n的d d的d的<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n<br />\r\n大跨度<br />\r\nd 等等<br />\r\ndd的d等等dk的ddkd <br />\r\n<br />\r\n的dkd dk的d ddk的大跨度<br />\r\ndkd djddj d的等等dd djd 计算机的啤酒肚<br />\r\n 打交道‘的', 0005), (8, 2, '2009-08-01 02:54:24', '111', '111111111', 0002), (9, 3, '2009-08-01 02:54:33', '223222', '2232232', 0001), (10, 4, '2009-08-01 02:54:43', '2334423', '334423333', 0003), (11, 4, '2009-08-01 02:54:53', '3343344', '3333333333333', 0002), (12, 1, '2009-08-01 02:55:26', '3333333333323', '33322333', 0004), (13, 3, '2009-08-01 02:55:35', '却轻轻轻轻', '问问请问', 0001), (14, 1, '2009-08-01 02:55:44', '无气味', '我完成', 0002), (15, 2, '2009-08-01 02:55:56', '大坏蛋跌破的觉得对的都等活动等候等活动等活动活动等活动活动的话哦', '恰恰舞', 0002), (16, 3, '2009-08-01 02:56:18', '时候idhodi活动等活动等红灯等红灯都得换都达到等活动殴打后的 时候idhdo等红灯等红灯都很都等候等活动活动等红灯等候等活动活动等候等候的后代都活动活动等红灯活动活动活动殴打后都的', '去试试青蛙', 0003), (17, 2, '2009-08-01 02:57:14', '我去玩', '娃娃亲问问', 0002), (18, 2, '2009-08-01 02:57:21', '问问去', '问问去', 0002), (19, 1, '2009-08-01 02:57:31', '问问是懂得', '我是 上传', 0002), (20, 3, '2009-08-01 02:57:41', '是市场', '牵牵手', 0001), (21, 2, '2009-08-01 02:57:58', '强说愁额度', '是点对点无数次', 0002), (22, 2, '2009-08-01 02:58:08', '所示所示所示所示是', '是受到问问出错', 0001), (23, 1, '2009-08-01 20:14:34', '路过围观', '围观围观围观围观围观围观', 0002), (24, 1, '2009-08-01 20:14:45', '围观围观', '围观围观围观围观围观围观围观围观围观围观围观围观围观围观围观围观围观围观围观围观围观围观围观围观围观围观围观围观围观围观围观围观围观围观围观围观围观围观围观围观围观围观围观围观围观围观围观围观围观围观围观围观围观围观围观围观围观围观围观围观围观围观围观围观围观围观围观围观围观围观围观围观围观围观围观', 0003), (25, 1, '2009-08-01 20:14:52', '围观围观围观围观围观', '围观围观围观围观', 0003), (26, 2, '2009-08-01 20:14:58', '围观围观围观', '围观围观围观围观围观', 0003), (27, 3, '2009-08-01 20:15:23', '围观围观围观', '围观围观围观', 0002), (28, 2, '2009-08-01 20:15:31', '围观围观围观', '围观围观围观围观围观', 0005), (29, 2, '2009-08-01 20:15:37', '围观围观围观围观围观', '围观围观围观围观围观围观围观围观围观', 0005), (30, 3, '2009-08-01 20:15:43', '围观围观围观围观', '围观围观围观围观围观', 0002), (31, 2, '2009-08-01 20:15:49', '围观围观围观', '围观围观围观围观围观围观围观', 0004), (32, 2, '2009-08-01 20:15:55', '围观围观围观围观', '围观围观围观围观围观围观围观', 0004), (33, 2, '2009-08-01 20:18:22', '围观围观', '围观', 0003), (34, 3, '2009-08-01 20:16:17', '围观', '围观', 0003), (35, 1, '2009-08-01 20:20:37', '围观', '围观', 0002), (36, 4, '2009-08-01 20:16:28', '围观', '围观', 0003), (37, 1, '2009-08-02 13:39:58', '测试文章1', '<img src="../images/2.jpg" alt="点击图片在新窗口浏览" width="680" height="486" border="0" /></a><br />', 0005), (38, 2, '2009-08-02 13:48:20', '测试文章2', '<img src="../images/tx3.jpg" alt="点击图片在新窗口浏览" width="680" height="486" border="0" /></a><br /><br /><br />\r\n<br /><br />\r\n', 0004), (39, 4, '2009-08-02 13:47:27', '测试文章3', '<img src="../images/luffy1.jpg" alt="点击图片在新窗口浏览" width="680" height="486" border="0" /></a><br /><br /><br />\r\n<img src="../images/luffy2.jpg" alt="点击图片在新窗口浏览" width="680" height="486" border="0" /></a><br /><br /><br />\r\n<br /><br />\r\nEverything<br />\r\n<br />\r\nMichaele Buble<br />\r\n<br />\r\nYou’re a falling star<br />\r\nYou’re the get away car<br />\r\nYou’re the line in the sand <br />\r\nWhen I go too far<br />\r\nYou’re the swimming pool<br />\r\nOn an August day<br />\r\nAnd you’re the perfect thing to see<br />\r\n<br />\r\nAnd you play it coy<br />\r\nBut it’s kind of a cute<br />\r\nOh, when you smile at me you know exactly what you do<br />\r\nBaby, don’t pretend that you don’t know it’s true<br />\r\nCause you can see it when I look at you<br />\r\n<br />\r\nAnd in this crazy life<br />\r\nAnd through these crazy times<br />\r\nIt’s you, it’s you<br />\r\nYou make me sing<br />\r\nYou’re every line<br />\r\nYou’re every word<br />\r\nYou’re everything<br />\r\n<br />\r\nYou’re a carousel <br />\r\nYou’re a wishing well<br />\r\nAnd you light me up<br />\r\nWhen you ring my bell<br />\r\nYou’re a mystery<br />\r\nYou’re from outer space<br />\r\nYou’re every minute of my everyday<br />\r\n<br />\r\nAnd I can’t believe<br />\r\nOh that I’m your man<br />\r\nAnd I get to kiss you baby just because I can<br />\r\nWhatever comes our way<br />\r\nOh we’ll see it through<br />\r\n<br />\r\nAnd you know that’s what our love can do<br />\r\nAnd in this crazy life<br />\r\nAnd through these crazy times<br />\r\nIt’s you, it’s you<br />\r\nAnd you make me sing<br />\r\nYou’re every line<br />\r\nYou’re every word<br />\r\nYou’re everything<br />\r\n<br />\r\nSo, La, La, La, La, La, La, La<br />\r\nSo, La, La, La, La, La, La, La<br />\r\n<br />\r\nAnd in this crazy life<br />\r\nAnd through these crazy times<br />\r\nIt’s you, it’s you<br />\r\nYou make me sing<br />\