test_fangchanfc.sql

-- phpMyAdmin SQL Dump
-- version 3.3.7
-- http://www.phpmyadmin.net
--
-- 主机: localhost
-- 生成日期: 2013 年 09 月 21 日 04:31
-- 服务器版本: 5.1.50
-- PHP 版本: 5.2.14

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- 数据库: `test_fangchan`
--

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

--
-- 表的结构 `tb_expert_review`
--

CREATE TABLE IF NOT EXISTS `tb_expert_review` (
  `r_expert_id` int(11) NOT NULL AUTO_INCREMENT,
  `r_expert_photo` varchar(256) NOT NULL,
  `r_expert_name` varchar(64) NOT NULL,
  `r_expert_title` varchar(256) NOT NULL,
  `r_expert_intro` text NOT NULL,
  `r_expert_reviewTitle` varchar(256) NOT NULL,
  `r_expert_reviewDesc` text NOT NULL,
  `r_loupanid` varchar(256) NOT NULL,
  `r_date` varchar(64) NOT NULL,
  PRIMARY KEY (`r_expert_id`)
) ENGINE=MyISAM  DEFAULT  CHARSET=utf8 AUTO_INCREMENT=10 ;

--
-- 转存表中的数据 `tb_expert_review`
--

INSERT INTO `tb_expert_review` (`r_expert_id`, `r_expert_photo`, `r_expert_name`, `r_expert_title`, `r_expert_intro`, `r_expert_reviewTitle`, `r_expert_reviewDesc`, `r_loupanid`, `r_date`) VALUES
(2, '', '', '', ' 100????', '', '100????', '?????', ''),
(6, '雷洪', '雷洪', '雷洪', ' 100个字以内', '雷洪', '100个字以内', '李时珍乐园', '1379698458'),
(7, '雷洪', '雷洪xxxx', '雷洪', ' 100个字以内', '', '100个字以内', '李时珍乐园', '1379736204');

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

--
-- 表的结构 `tb_group_apply`
--

CREATE TABLE IF NOT EXISTS `tb_group_apply` (
  `r_apply_User_Name` varchar(64) NOT NULL DEFAULT '',
  `r_apply_User_phone` varchar(20) NOT NULL DEFAULT '',
  `r_apply_User_Num` int(11) DEFAULT NULL,
  `r_apply_group_id` varchar(64) NOT NULL DEFAULT '',
  PRIMARY KEY (`r_apply_User_Name`,`r_apply_User_phone`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- 转存表中的数据 `tb_group_apply`
--

INSERT INTO `tb_group_apply` (`r_apply_User_Name`, `r_apply_User_phone`, `r_apply_User_Num`, `r_apply_group_id`) VALUES
('liuhgong', '18688945227', 1, '10003.10001'),
('é›·æ´ª', '18688945227', 1, '10003.10001'),
('leonlei', '18876437291', 1, '10003.10001');

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

--
-- 表的结构 `tb_group_info`
--

CREATE TABLE IF NOT EXISTS `tb_group_info` (
  `r_group_id` int(11) NOT NULL AUTO_INCREMENT,
  `r_group_Line` varchar(256) NOT NULL DEFAULT '',
  `r_title_pic` varchar(256) DEFAULT NULL,
  `r_group_title` varchar(256) DEFAULT NULL,
  `r_qishu` varchar(64) DEFAULT NULL,
  `r_loupan` varchar(64) NOT NULL,
  `r_apply_beg_datetime` varchar(64) NOT NULL,
  `r_apply_end_datetime` varchar(64) NOT NULL,
  `r_view_end_datetime` varchar(64) NOT NULL,
  `r_info_1` text NOT NULL,
  `r_info_2` text NOT NULL,
  `r_info_3` text NOT NULL,
  `r_info_4` text NOT NULL,
  `r_apply_datetime` varchar(64) NOT NULL,
  UNIQUE KEY `r_group_id` (`r_group_id`)
) ENGINE=MyISAM   DEFAULT CHARSET=utf8 AUTO_INCREMENT=14 ;

--
-- 转存表中的数据 `tb_group_info`
--

INSERT INTO `tb_group_info` (`r_group_id`, `r_group_Line`, `r_title_pic`, `r_group_title`, `r_qishu`, `r_loupan`, `r_apply_beg_datetime`, `r_apply_end_datetime`, `r_view_end_datetime`, `r_info_1`, `r_info_2`, `r_info_3`, `r_info_4`, `r_apply_datetime`) VALUES
(13, '九龙山', 'undefined', '九龙山', '2', '李时珍乐园', '2013-09-09 0:00', '2013-09-09 0:00', '2013-09-09 0:00', '报名享惊喜\n1、免费大巴车接送,中午免费提供午餐(水，面包);\n2、购房享受折上折;\n3、微信抽取幸运大礼包;\n4、浪漫大礼包;', '上海莘庄地铁站-九龙山\n9月14上午9点集合，下午17点返程\n报名截至至9月13号下午12点，我们的工作人员将通过短信及电话与您确认报名信息', '免责声明\n看房团活动是大申房产组织的非盈利公益活动，凡报名参加的均视为有完全民事行为能力的人,如在活动中发生人身损害结果,发起人在法律规定的范围内不承担赔偿责任，由受害人依据法律规定依法解决，同时活动照片可能用与项目推广，凡报名者均视为接受本申明.', '500个字以内', '2013-09-21 04:15:56');

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

--
-- 表的结构 `tb_house_impression`
--

CREATE TABLE IF NOT EXISTS `tb_house_impression` (
  `r_House_impression_ID` int(11) NOT NULL DEFAULT '0',
  `r_House_impression_Desc` varchar(64) NOT NULL DEFAULT '',
  `r_House_impression_Votes` int(11) NOT NULL DEFAULT '0',
  `r_loupan_ID` varchar(64) NOT NULL,
  PRIMARY KEY (`r_loupan_ID`,`r_House_impression_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- 转存表中的数据 `tb_house_impression`
--

INSERT INTO `tb_house_impression` (`r_House_impression_ID`, `r_House_impression_Desc`, `r_House_impression_Votes`, `r_loupan_ID`) VALUES
(1, '印象描1', 100, '李时珍乐园'),
(2, '印象描2', 100, '李时珍乐园'),
(3, '印象描3', 100, '李时珍乐园'),
(4, '印象描4', 100, '李时珍乐园'),
(5, '印象描5', 100, '李时珍乐园'),
(6, '印象描6', 100, '李时珍乐园'),
(1, '', 0, ''),
(2, '', 0, ''),
(3, '', 0, ''),
(4, '', 0, ''),
(5, '', 0, ''),
(6, '', 0, '');

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

--
-- 表的结构 `tb_house_impression_users`
--

CREATE TABLE IF NOT EXISTS `tb_house_impression_users` (
  `r_House_impression_Desc` varchar(64) NOT NULL DEFAULT '',
  `r_House_impression_Votes` int(11) NOT NULL DEFAULT '0',
  `r_UserID` int(11) NOT NULL AUTO_INCREMENT,
  `r_User_Nick` varchar(256) DEFAULT NULL,
  `r_loupan_ID` int(11) NOT NULL,
  PRIMARY KEY (`r_UserID`)
) ENGINE=MyISAM  DEFAULT  CHARSET=utf8 AUTO_INCREMENT=13 ;

--
-- 转存表中的数据 `tb_house_impression_users`
--

INSERT INTO `tb_house_impression_users` (`r_House_impression_Desc`, `r_House_impression_Votes`, `r_UserID`, `r_User_Nick`, `r_loupan_ID`) VALUES
('老子看哈', 1, 12, NULL, 0),
('老子来了', 1, 11, NULL, 2);