-- phpMyAdmin SQL Dump
-- version 2.8.0.3
-- http://www.phpmyadmin.net
-- 
-- : localhost
-- : 2008  08  28  07:50
-- 汾: 5.0.45
-- PHP 汾: 5.2.1
-- 
-- ݿ: `163y`
-- 

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

-- 
-- Ľṹ `love_blog`
-- 

CREATE TABLE `love_blog` (
  `id` int(11) NOT NULL auto_increment,
  `blog_title` varchar(40) NOT NULL,
  `blog_name` varchar(20) NOT NULL,
  `blog_content` varchar(2000) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8 AUTO_INCREMENT=12 ;

-- 
-- е `love_blog`
-- 

INSERT INTO `love_blog` (`id`, `blog_title`, `blog_name`, `blog_content`) VALUES (2, 'I Love You', 'boy', 'An empty street \r\nan empty house \r\na hole inside my heart \r\nI''m all alone and the room is getting smaller \r\nI wonder how, I wonder why, I wonder where they are \r\nthe days we had, the songs we sang together'),
(3, 'sfgsg', 'girl', 'ggsgsgsg'),
(4, 'houhuiyang', 'boy', 'Dear Paul,\r\n\r\nHow was I to know that you were watching me sleep? I awoke to see you laying there and just then, you smiled and said hi and that just melted me. I wish with all of my heart that I could wake to your beautiful eyes for the rest of my life.\r\n\r\nI hated to leave but as I have told you, I left a big part of me with you. It is yours now so, take care and tread lightly. I wish that I could be with you now as you face so many struggles, but know that I am there in spirit and am praying for everything to work out for you. No matter where this life takes us, together or not, know that you and your girls will always be in my heart and "my favorite." \r\n\r\nLove always,\r\n\r\nAmanda \r\n'),
(5, '˫', 'boy', '\r\nԼ\r\nҪ޺޻\r\nǰԵ˭\r\nֻܽ񳾺\r\n\r\nԸѩ\r\n쳾Ѫ\r\nů汯ͬ\r\nĺĺ\r\n\r\nƼˮ\r\nమ\r\nؾÿ쳤\r\nΪȾҵѪ\r\n\r\nԸ˫˫\r\nԸ˫˫\r\nһ\r\n㽫\r\n\r\nԸ˫˫\r\n쳾\r\n˼·\r\nϱ\r\n\r\n˼·\r\n\r\n'),
(6, 'zhaopengfei', 'boy', 'There is no reason for you and me to give up,so far as i choose php i will never stop until the end of life.so,my dear friend,come and fight with me.'),
(7, 'dddd', 'boy', 'ⲻܳ1000'),
(8, 'ⲻܳ20', 'boy', 'ⲻܳ20'),
(9, 'Ұ㰡', 'boy', 'Ұ㰡\r\nҰ㰡\r\nҰ㰡\r\nGBKֱ˫ֽʾģСӢַʹ˫ֽʾֻΪģλ1\r\n\r\n \r\n\r\n     UTF8Խַһֶֽڱ룬Ӣʹ8λһֽڣʹ24λֽڣ롣Ӣַ϶̳UTF8ʡռ䡣\r\n\r\n\r\n      GBKȫַUTF-8ȫйҪõַ\r\n\r\n \r\n\r\n      GBKڹұ׼GB2312ݺGB2312ı׼񻹲ǹұ׼\r\n\r\nUTF-8ֿڸ֧UTF8ַʾ\r\n\r\n\r\n      磬UTF8룬˵ӢIEҲʾģIEְ֧\r\n\r\n \r\n\r\n      ԣӢıȽ϶̳ ʹGBKÿַռ2ֽڣʹUTF8Ӣȴֻռһֽڡ'),
(10, 'ⲻܳ20', 'boy', 'ⲻܳ20ֱⲻܳ20ֱⲻܳ20'),
(11, '', 'boy', 'Ұ㰡\r\nҰ㰡\r\nҰ㰡\r\nGBKֱ˫ֽʾģСӢҰ㰡\r\nҰ㰡\r\nҰ㰡\r\nGBKֱ˫ֽʾģСӢ');

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

-- 
-- Ľṹ `love_book`
-- 

CREATE TABLE `love_book` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(20) NOT NULL,
  `time` datetime NOT NULL,
  `content` varchar(500) NOT NULL,
  `ip` varchar(255) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ;

-- 
-- е `love_book`
-- 

INSERT INTO `love_book` (`id`, `name`, `time`, `content`, `ip`) VALUES (1, 'houhuiyang', '2008-08-17 00:43:42', 'test', '123.117.76.162'),
(2, 'hhh', '2008-08-17 14:39:32', 'hhh', '123.117.76.162'),
(3, 'hhh', '2008-08-17 14:39:43', 'hhh', '123.117.76.162'),
(4, '2007seģΪ70.', '2008-08-20 17:55:59', 'SEгʾ2000seģΪ8.6200321.4200210.6101.6%2007seģΪ70.2200656.723.9%', '218.241.188.34'),
(5, 'Ǻ', '2008-08-22 17:53:16', 'ð', '60.1.244.222'),
(6, 'Ǻ', '2008-08-22 17:53:31', 'ð', '60.1.244.222');
