-- MySQL dump 10.13 Distrib 5.7.26, for Win64 (x86_64)

-- Host: localhost Database: www.5tm.com
-- ------------------------------------------------------
-- Server version 5.7.26

/!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 /;
/!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE /;
/!40103 SET TIME_ZONE='+00:00' /;
/!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 /;
/!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 /;
/!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' /;
/!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 /;

--
-- Table structure for table codepay_order
--

DROP TABLE IF EXISTS codepay_order;
/!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE codepay_order (
id int(11) unsigned NOT NULL AUTO_INCREMENT,
pay_id varchar(50) NOT NULL COMMENT '用户ID或订单ID',
money decimal(6,2) unsigned NOT NULL COMMENT '实际金额',
price decimal(6,2) unsigned NOT NULL COMMENT '原价',
type int(1) NOT NULL DEFAULT '1' COMMENT '支付方式',
pay_no varchar(100) NOT NULL COMMENT '流水号',
param varchar(200) DEFAULT NULL COMMENT '自定义参数',
pay_time bigint(11) NOT NULL DEFAULT '0' COMMENT '付款时间',
pay_tag varchar(100) NOT NULL DEFAULT '0' COMMENT '金额的备注',
status int(1) NOT NULL DEFAULT '0' COMMENT '订单状态',
creat_time bigint(11) NOT NULL DEFAULT '0' COMMENT '创建时间',
up_time timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
PRIMARY KEY (id),
UNIQUE KEY main (pay_id,pay_time,money,type,pay_tag),
UNIQUE KEY pay_no (pay_no,type)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用于区分是否已经处理';
/!40101 SET character_set_client = @saved_cs_client /;

--
-- Dumping data for table codepay_order
--

LOCK TABLES codepay_order WRITE;
/!40000 ALTER TABLE codepay_order DISABLE KEYS /;
/!40000 ALTER TABLE codepay_order ENABLE KEYS /;
UNLOCK TABLES;

--
-- Table structure for table h_admin
--

DROP TABLE IF EXISTS h_admin;
/!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE h_admin (
id int(11) NOT NULL AUTO_INCREMENT,
h_userName varchar(50) DEFAULT NULL,
h_passWord varchar(50) DEFAULT NULL,
h_nickName varchar(50) DEFAULT NULL,
h_isPass int(11) DEFAULT '1',
h_addTime datetime DEFAULT NULL,
h_permissions text,
PRIMARY KEY (id)
) ENGINE=MyISAM AUTO_INCREMENT=20 DEFAULT CHARSET=utf8;
/!40101 SET character_set_client = @saved_cs_client /;

--
-- Dumping data for table h_admin
--

LOCK TABLES h_admin WRITE;
/!40000 ALTER TABLE h_admin DISABLE KEYS /;
INSERT INTO h_admin VALUES (1,'admin','64d9e8a64349350a27936a04bd6a6de5','管理员',1,'2009-11-16 12:48:03',',基本配置,图片替换,客服设置,收益设置,推荐会员提成配置,余额提现配置,抽奖配置,会员公告,会员列表,推荐结构,会员收益列表,余额提现记录,商城商品管理,商城订单列表,会员登录记录,加减余额,余额流水明细,会员消息列表,发送消息给会员,收到的会员消息,清空数据,调整时间,账号管理,');
/!40000 ALTER TABLE h_admin ENABLE KEYS /;
UNLOCK TABLES;

--
-- Table structure for table h_article
--

DROP TABLE IF EXISTS h_article;
/!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE h_article (
id int(11) NOT NULL AUTO_INCREMENT,
h_location varchar(20) DEFAULT NULL,
h_menuId int(11) DEFAULT NULL,
h_title varchar(250) DEFAULT NULL,
h_pageKey varchar(250) DEFAULT NULL,
h_categoryId int(11) DEFAULT '0',
h_picSmall varchar(250) DEFAULT NULL,
h_picBig varchar(250) DEFAULT NULL,
h_picBig2 varchar(250) DEFAULT NULL,
h_picBig3 varchar(250) DEFAULT NULL,
h_picBig4 varchar(250) DEFAULT NULL,
h_picBig5 varchar(250) DEFAULT NULL,
h_picBig6 varchar(250) DEFAULT NULL,
h_picBig7 varchar(250) DEFAULT NULL,
h_picBig8 varchar(250) DEFAULT NULL,
h_picBig9 varchar(250) DEFAULT NULL,
h_picBig10 varchar(250) DEFAULT NULL,
h_isLink int(11) DEFAULT NULL,
h_href varchar(250) DEFAULT NULL,
h_target varchar(20) DEFAULT NULL,
h_addTime datetime DEFAULT NULL,
h_order int(11) DEFAULT '0',
h_clicks int(11) DEFAULT '0',
h_keyword text,
h_description text,
h_info text,
h_jj text,
h_dataSheet varchar(250) DEFAULT NULL,
h_download varchar(250) DEFAULT NULL,
h_pm varchar(250) DEFAULT NULL,
h_pfwz varchar(250) DEFAULT NULL,
h_cz varchar(250) DEFAULT NULL,
h_gy varchar(250) DEFAULT NULL,
h_ys varchar(250) DEFAULT NULL,
h_mz varchar(250) DEFAULT NULL,
h_lsj decimal(9,2) DEFAULT '0.00',
h_hyj decimal(9,2) DEFAULT '0.00',
h_tc1 decimal(9,2) DEFAULT '0.00',
h_tc2 decimal(9,2) DEFAULT '0.00',
h_tc3 decimal(9,2) DEFAULT '0.00',
h_kc int(11) DEFAULT '0' COMMENT '库存',
h_isPass int(11) DEFAULT '1',
PRIMARY KEY (id)
) ENGINE=MyISAM AUTO_INCREMENT=417 DEFAULT CHARSET=utf8;
/!40101 SET character_set_client = @saved_cs_client /;

--
-- Dumping data for table h_article
--

LOCK TABLES h_article WRITE;
/!40000 ALTER TABLE h_article DISABLE KEYS /;
INSERT INTO h_article VALUES (415,'网站主栏目',108,'如何快速玩赚同本财富系统?',NULL,227,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2018-10-05 10:48:13',0,0,NULL,NULL,'<span style="color:#000000;"><strong>1，每天收益（这里算的是单个，可以一次购买多个）：<br />\r\n<br />\r\n1）投资20元，每天分红2元，15天出局，总收益：30元，每人最多购买5个，VIP1及以上会员才能购买。<br />\r\n<br />\r\n2）投资100元，每天分红8元，25天出局，总收益：200元，每人最多购买10个，VIP2及以上会员才能购买。<br />\r\n<br />\r\n3）投资300元，每天分红15元，50天出局，总收益：750元，每人最多购买15个，VIP3及以上会员才能购买。<br />\r\n<br />\r\n4）投资500元，每天分红20元，75天出局，总收益：1500元，每人最多购买20个，VIP4及以上会员才能购买。<br />\r\n<br />\r\n2，推广收益（下级会员每天产生收益时的提成比例，最多8级）：<br />\r\n<br />\r\n直推1代拿每天收益的10%，第2代拿每天收益的9%，第3代拿每天收益的8%，第4代拿每天收益的7%，第5代拿每天收益的6%，第6代拿每天收益的5%，第7代拿每天收益的4%，第8代拿每天收益的3%<br />\r\n<br />\r\n3，所得收益可以直接提现，或者转账卖给其他会员，或者直接在购物商城里消费<br />\r\n<br />\r\n1）VIP1可提现余额的70%，VIP2可提现余额的80%，VIP3可提现余额的90%，VIP4可提现余额的100%<br />\r\n<br />\r\n2）会员达VIP2才可以使用余额转账功能<br />\r\n<br />\r\n3）购物商城中的商品也是达相应VIP级别才能购买<br />\r\n<br />\r\n4，会员如何升级<br />\r\n<br />\r\n可到会员中心-会员升级中查看，当直推团队业绩达300升级为VIP2，5000升级为VIP3，达1万升级为VIP4</strong></span><strong style="color: rgb(0, 0, 0);">，</strong><span style="color:#000000;"><strong>VIP4为最高级。<br />\r\n<br />\r\n当直推团队业绩达2万时，一次性奖励888元，系统自动充值到会员余额中。</strong></span>',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0.00,0.00,0.00,0.00,0,1);
/!40000 ALTER TABLE h_article ENABLE KEYS /;
UNLOCK TABLES;

--
-- Table structure for table h_category
--

DROP TABLE IF EXISTS h_category;
/!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE h_category (
id int(11) NOT NULL AUTO_INCREMENT,
h_location varchar(20) DEFAULT NULL,
h_menuId int(11) DEFAULT NULL,
h_title varchar(250) DEFAULT NULL,
h_pageKey varchar(200) DEFAULT NULL,
h_order int(11) DEFAULT '0',
h_addTime datetime DEFAULT NULL,
h_picBig varchar(250) DEFAULT NULL,
h_picBigN varchar(250) DEFAULT NULL,
PRIMARY KEY (id)
) ENGINE=MyISAM AUTO_INCREMENT=228 DEFAULT CHARSET=utf8;
/!40101 SET character_set_client = @saved_cs_client /;

--
-- Dumping data for table h_category
--

LOCK TABLES h_category WRITE;
/!40000 ALTER TABLE h_category DISABLE KEYS /;
INSERT INTO h_category VALUES (227,'网站主栏目',108,'会员公告',NULL,1,'2016-01-31 21:25:00','',NULL);
/!40000 ALTER TABLE h_category ENABLE KEYS /;
UNLOCK TABLES;

--
-- Table structure for table h_chongzhi
--

DROP TABLE IF EXISTS h_chongzhi;
/!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE h_chongzhi (
id int(11) NOT NULL AUTO_INCREMENT,
h_userName varchar(50) DEFAULT NULL,
h_money int(11) DEFAULT '0',
h_fee int(11) DEFAULT '0',
h_bank varchar(32) DEFAULT NULL,
h_jiaoyineixing varchar(32) DEFAULT NULL,
h_jiaoyihao varchar(50) DEFAULT NULL,
h_bankFullname varchar(32) DEFAULT NULL,
h_bankCardId varchar(32) DEFAULT NULL,
h_mobile varchar(20) DEFAULT NULL,
h_addTime datetime DEFAULT NULL,
h_isRead int(20) DEFAULT '0',
h_state char(20) DEFAULT NULL COMMENT '待审核、已打款、审核失败',
h_isReturn int(20) DEFAULT '0' COMMENT '若审核失败，是否返款了，只返一次',
h_reply char(255) DEFAULT NULL,
h_actIP char(39) DEFAULT NULL,
PRIMARY KEY (id)
) ENGINE=MyISAM AUTO_INCREMENT=37 DEFAULT CHARSET=utf8;
/!40101 SET character_set_client = @saved_cs_client /;

--
-- Dumping data for table h_chongzhi
--

LOCK TABLES h_chongzhi WRITE;
/!40000 ALTER TABLE h_chongzhi DISABLE KEYS /;
/!40000 ALTER TABLE h_chongzhi ENABLE KEYS /;
UNLOCK TABLES;

--
-- Table structure for table h_config
--

DROP TABLE IF EXISTS h_config;
/!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE h_config (
id int(11) NOT NULL AUTO_INCREMENT,
h_webName varchar(50) DEFAULT NULL,
h_webLogo varchar(250) DEFAULT NULL,
h_webLogo1 varchar(250) DEFAULT NULL,
h_webLogoLogin varchar(250) DEFAULT NULL,
h_webLogo2 varchar(250) DEFAULT NULL,
h_webLogo3 varchar(250) DEFAULT NULL,
h_webKeyword varchar(250) DEFAULT NULL,
h_keyword text,
h_description text,
h_leftContact text,
h_counter text,
h_footer text,
h_rewriteOpen int(11) DEFAULT '0',
h_point1Member decimal(11,0) DEFAULT '0' COMMENT '激活会员需要多少金币',
h_point1MemberPoint2 int(11) DEFAULT '0' COMMENT '被激活的会员拥有多少金币',
h_point2Quit int(11) DEFAULT '0' COMMENT '放弃已经拍下来的金币，扣多少金币作为惩罚',
h_withdrawFee decimal(11,2) DEFAULT '0.00' COMMENT '提现手续费百分比',
h_withdrawMinCom int(11) DEFAULT '0' COMMENT '提现要求至少直荐多少人',
h_withdrawMinMoney int(11) DEFAULT '0' COMMENT '提现最低要求金额',
h_chongzhiMinMoney int(11) DEFAULT '0',
h_point2Lottery int(11) DEFAULT '0' COMMENT '抽奖一次扣多少金币',
h_lottery1 int(11) DEFAULT '0' COMMENT '1等奖中奖概率，万分之几',
h_lottery2 int(11) DEFAULT '0',
h_lottery3 int(11) DEFAULT '0',
h_lottery4 int(11) DEFAULT '0',
h_lottery5 int(11) DEFAULT '0',
h_lottery6 int(11) DEFAULT '0',
h_point2Com1 decimal(12,4) DEFAULT '0.0000' COMMENT '1代直推奖励',
h_point2Com2 decimal(12,4) DEFAULT '0.0000',
h_point2Com3 decimal(12,4) DEFAULT '0.0000',
h_point2Com4 decimal(12,4) DEFAULT '0.0000',
h_point2Com5 decimal(12,4) DEFAULT '0.0000',
h_point2Com6 decimal(11,2) DEFAULT '0.00' COMMENT '6-10保留，未用',
h_point2Com7 decimal(11,2) DEFAULT '0.00',
h_point2Com8 decimal(11,2) DEFAULT '0.00',
h_point2Com9 decimal(11,2) DEFAULT '0.00',
h_point2Com10 decimal(11,2) DEFAULT '0.00',
h_levelUpTo0 int(11) DEFAULT '0' COMMENT '升级至vip需要直荐多少人',
h_levelUpTo1 int(11) DEFAULT '0',
h_levelUpTo2 int(11) DEFAULT '0',
h_levelUpTo3 int(11) DEFAULT '0',
h_levelUpTo4 int(11) DEFAULT '0',
h_levelUpTo5 int(11) DEFAULT '0' COMMENT '5-10保留，未启用',
h_levelUpTo6 int(11) DEFAULT '0',
h_levelUpTo7 int(11) DEFAULT '0',
h_levelUpTo8 int(11) DEFAULT '0',
h_levelUpTo9 int(11) DEFAULT '0',
h_levelUpTo10 int(11) DEFAULT '0',
h_serviceQQ char(255) DEFAULT NULL,
h_point2ComReg int(11) DEFAULT '0' COMMENT '推荐1个注册会员获取种子',
h_point2ComRegAct int(11) DEFAULT '0' COMMENT '推荐的会员消耗的花',
h_point2ComRegAct2 int(11) DEFAULT '0' COMMENT '新用户获取的花',
h_to_flower int(11) DEFAULT NULL COMMENT '花转账',
h_auto_caimi int(11) DEFAULT '100',
h_open int(1) DEFAULT '1',
h_sell_max int(11) DEFAULT '0',
h_xihuan varchar(250) DEFAULT NULL,
h_land112 int(11) NOT NULL,
h_land113 int(11) NOT NULL,
PRIMARY KEY (id)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
/!40101 SET character_set_client = @saved_cs_client /;

--
-- Dumping data for table h_config
--

LOCK TABLES h_config WRITE;
/!40000 ALTER TABLE h_config DISABLE KEYS /;
INSERT INTO h_config VALUES (1,'源码测试来自bbs.5g-yun.com','/mobile/sc/1.jpg','/mobile/sc/3.jpg','/mobile/sc/logo.png','','','源码测试来自bbs.5g-yun.com','源码测试来自bbs.5g-yun.com','','','','',0,2,300,10,0.10,70,100,100,10,0,0,400,2000,3800,3800,0.1000,0.0900,0.0800,0.0700,0.0600,0.05,0.04,0.03,120000.00,2000.00,80,90,100,40,60,0,300,5000,10000,20000,888,'875595757',0,0,0,100,0,1,0,'https://bbs.5g-yun.com',1,10);
/!40000 ALTER TABLE h_config ENABLE KEYS /;
UNLOCK TABLES;

--
-- Table structure for table h_farm_shop
--

DROP TABLE IF EXISTS h_farm_shop;
/!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE h_farm_shop (
id int(11) NOT NULL AUTO_INCREMENT,
h_title char(50) DEFAULT NULL,
h_pic char(255) DEFAULT NULL,
h_point2Day float(11,2) NOT NULL DEFAULT '0.00' COMMENT '每天生产金币',
h_life int(11) DEFAULT '0' COMMENT '生存周期',
h_persent float(11,2) NOT NULL DEFAULT '0.00',
h_money int(11) DEFAULT '0' COMMENT '售价',
h_land int(11) DEFAULT NULL,
h_minMemberLevel int(11) DEFAULT '0' COMMENT '购买最低会员等级',
h_dayBuyMaxNum int(11) DEFAULT '0' COMMENT '每天限购数量',
h_allMaxNum int(11) DEFAULT '0' COMMENT '农场中最多存在多少只',
h_order int(11) DEFAULT '0',
h_addTime datetime DEFAULT NULL,
h_location varchar(20) DEFAULT NULL,
h_menuId int(11) DEFAULT NULL,
PRIMARY KEY (id),
KEY order_id (h_title)
) ENGINE=MyISAM AUTO_INCREMENT=118 DEFAULT CHARSET=utf8;
/!40101 SET character_set_client = @saved_cs_client /;

--
-- Dumping data for table h_farm_shop
--

LOCK TABLES h_farm_shop WRITE;
/!40000 ALTER TABLE h_farm_shop DISABLE KEYS /;
INSERT INTO h_farm_shop VALUES (113,'同本理财A产品','/mobile/sc/2.jpg',2.00,15,0.00,20,NULL,1,5,5,0,'2018-10-05 17:00:00',NULL,NULL),(114,'同本理财B产品','/mobile/sc/2.jpg',8.00,25,0.00,100,NULL,2,5,10,0,'2018-10-05 19:43:47',NULL,NULL),(115,'同本理财C产品','/mobile/sc/2.jpg',15.00,50,0.00,300,NULL,3,5,15,0,'2018-10-05 15:22:46',NULL,NULL),(116,'同本理财D产品','/mobile/sc/2.jpg',20.00,75,0.00,500,NULL,4,5,20,0,'2018-10-05 15:23:35',NULL,NULL),(117,'888888','/upload/2020/03/17/2020031714211664418.jpg',0.20,1,0.00,5000,NULL,1,3,150000,0,'2020-03-17 14:21:02',NULL,NULL);
/!40000 ALTER TABLE h_farm_shop ENABLE KEYS /;
UNLOCK TABLES;

--
-- Table structure for table h_growth_rate
--

DROP TABLE IF EXISTS h_growth_rate;
/!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE h_growth_rate (
id int(11) NOT NULL AUTO_INCREMENT,
rate float(11,2) NOT NULL DEFAULT '0.00' COMMENT '拆分率',
create_time int(11) NOT NULL,
update_time int(11) NOT NULL,
h_userName varchar(20) NOT NULL DEFAULT '',
PRIMARY KEY (id)
) ENGINE=MyISAM AUTO_INCREMENT=63 DEFAULT CHARSET=utf8;
/!40101 SET character_set_client = @saved_cs_client /;

--
-- Dumping data for table h_growth_rate
--

LOCK TABLES h_growth_rate WRITE;
/!40000 ALTER TABLE h_growth_rate DISABLE KEYS /;
/!40000 ALTER TABLE h_growth_rate ENABLE KEYS /;
UNLOCK TABLES;

--
-- Table structure for table h_guestbook
--

DROP TABLE IF EXISTS h_guestbook;
/!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE h_guestbook (
id int(11) NOT NULL AUTO_INCREMENT,
h_fullName varchar(50) DEFAULT NULL,
h_address varchar(250) DEFAULT NULL,
h_email varchar(50) DEFAULT NULL,
h_phone varchar(50) DEFAULT NULL,
h_isPass int(11) DEFAULT '0',
h_addTime datetime DEFAULT NULL,
h_message text,
PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/!40101 SET character_set_client = @saved_cs_client /;

--
-- Dumping data for table h_guestbook
--

LOCK TABLES h_guestbook WRITE;
/!40000 ALTER TABLE h_guestbook DISABLE KEYS /;
/!40000 ALTER TABLE h_guestbook ENABLE KEYS /;
UNLOCK TABLES;

--
-- Table structure for table h_huafei_stock
--

DROP TABLE IF EXISTS h_huafei_stock;
/!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE h_huafei_stock (
id int(11) NOT NULL AUTO_INCREMENT,
h_userName varchar(50) NOT NULL,
h_price float(11,4) NOT NULL,
status tinyint(3) NOT NULL COMMENT '状态',
create_time varchar(100) NOT NULL,
PRIMARY KEY (id)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
/!40101 SET character_set_client = @saved_cs_client /;

--
-- Dumping data for table h_huafei_stock
--

LOCK TABLES h_huafei_stock WRITE;
/!40000 ALTER TABLE h_huafei_stock DISABLE KEYS /;
/!40000 ALTER TABLE h_huafei_stock ENABLE KEYS /;
UNLOCK TABLES;

--
-- Table structure for table h_log_animal
--

DROP TABLE IF EXISTS h_log_animal;
/!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE h_log_animal (
id int(11) NOT NULL AUTO_INCREMENT,
h_userName varchar(20) DEFAULT NULL,
h_price int(10) DEFAULT '0',
h_about varchar(250) DEFAULT NULL,
h_addTime datetime DEFAULT NULL,
h_actIP char(50) DEFAULT NULL,
h_type char(50) DEFAULT NULL,
h_state varchar(10) DEFAULT NULL,
h_type_id int(11) DEFAULT '0' COMMENT '2:精灵 1：花仙子',
PRIMARY KEY (id),
KEY h_userName (h_userName) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;
/!40101 SET character_set_client = @saved_cs_client /;

--
-- Dumping data for table h_log_animal
--

LOCK TABLES h_log_animal WRITE;
/!40000 ALTER TABLE h_log_animal DISABLE KEYS /;
/!40000 ALTER TABLE h_log_animal ENABLE KEYS /;
UNLOCK TABLES;

--
-- Table structure for table h_log_bonus_day
--

DROP TABLE IF EXISTS h_log_bonus_day;
/!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE h_log_bonus_day (
id int(11) NOT NULL AUTO_INCREMENT,
h_userName varchar(20) DEFAULT NULL,
h_price decimal(14,2) DEFAULT '0.00',
h_addDate date DEFAULT NULL,
h_isSettled int(11) DEFAULT '0',
PRIMARY KEY (id),
KEY h_addDate (h_addDate) USING BTREE,
KEY h_userName (h_userName) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/!40101 SET character_set_client = @saved_cs_client /;

--
-- Dumping data for table h_log_bonus_day
--

LOCK TABLES h_log_bonus_day WRITE;
/!40000 ALTER TABLE h_log_bonus_day DISABLE KEYS /;
/!40000 ALTER TABLE h_log_bonus_day ENABLE KEYS /;
UNLOCK TABLES;

--
-- Table structure for table h_log_flowerfairy
--

DROP TABLE IF EXISTS h_log_flowerfairy;
/!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE h_log_flowerfairy (
id int(11) NOT NULL AUTO_INCREMENT,
h_userName varchar(20) DEFAULT NULL,
h_price decimal(14,2) DEFAULT '0.00',
h_about varchar(250) DEFAULT NULL,
h_addTime datetime DEFAULT NULL,
h_actIP char(50) DEFAULT NULL,
h_type char(50) DEFAULT NULL,
h_state varchar(10) DEFAULT NULL,
PRIMARY KEY (id),
KEY h_userName (h_userName) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/!40101 SET character_set_client = @saved_cs_client /;

--
-- Dumping data for table h_log_flowerfairy
--

LOCK TABLES h_log_flowerfairy WRITE;
/!40000 ALTER TABLE h_log_flowerfairy DISABLE KEYS /;
/!40000 ALTER TABLE h_log_flowerfairy ENABLE KEYS /;
UNLOCK TABLES;

--
-- Table structure for table h_log_login_member
--

DROP TABLE IF EXISTS h_log_login_member;
/!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE h_log_login_member (
id int(11) NOT NULL AUTO_INCREMENT,
h_userName char(50) DEFAULT NULL,
h_ip char(39) DEFAULT NULL,
h_addTime datetime DEFAULT NULL,
PRIMARY KEY (id)
) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT CHARSET=utf8;
/!40101 SET character_set_client = @saved_cs_client /;

--
-- Dumping data for table h_log_login_member
--

LOCK TABLES h_log_login_member WRITE;
/!40000 ALTER TABLE h_log_login_member DISABLE KEYS /;
INSERT INTO h_log_login_member VALUES (1,'admin','127.0.0.1','2019-05-20 02:33:27'),(2,'admin','127.0.0.1','2019-05-21 02:18:44'),(3,'admin','127.0.0.1','2019-05-21 02:20:27'),(4,'13333333333','127.0.0.1','2019-05-21 02:25:38'),(5,'admin','127.0.0.1','2020-03-17 14:13:23'),(6,'13333333333','127.0.0.1','2020-03-17 14:15:57'),(7,'13333333333','127.0.0.1','2020-03-17 14:19:59'),(8,'13333333333','127.0.0.1','2020-03-17 14:22:28'),(9,'admin','127.0.0.1','2020-03-18 00:58:07'),(10,'admin','127.0.0.1','2020-03-18 12:26:57'),(11,'admin','127.0.0.1','2020-03-18 12:27:27'),(12,'13333333333','127.0.0.1','2020-03-18 13:00:58'),(13,'admin','127.0.0.1','2020-03-20 04:49:19');
/!40000 ALTER TABLE h_log_login_member ENABLE KEYS /;
UNLOCK TABLES;

--
-- Table structure for table h_log_point1
--

DROP TABLE IF EXISTS h_log_point1;
/!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE h_log_point1 (
id int(11) NOT NULL AUTO_INCREMENT,
h_userName varchar(20) DEFAULT NULL,
h_price decimal(14,2) DEFAULT '0.00',
h_about varchar(250) DEFAULT NULL,
h_addTime datetime DEFAULT NULL,
h_actIP char(50) DEFAULT NULL,
h_type char(50) DEFAULT NULL,
h_state varchar(10) DEFAULT NULL,
h_type_id tinyint(3) DEFAULT '0' COMMENT '1:奖励 2：转换',
PRIMARY KEY (id),
KEY h_userName (h_userName) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
/!40101 SET character_set_client = @saved_cs_client /;

--
-- Dumping data for table h_log_point1
--

LOCK TABLES h_log_point1 WRITE;
/!40000 ALTER TABLE h_log_point1 DISABLE KEYS /;
/!40000 ALTER TABLE h_log_point1 ENABLE KEYS /;
UNLOCK TABLES;

--
-- Table structure for table h_log_point2
--

DROP TABLE IF EXISTS h_log_point2;
/!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE h_log_point2 (
id int(11) NOT NULL AUTO_INCREMENT,
h_userName varchar(20) DEFAULT NULL,
h_price decimal(14,2) DEFAULT '0.00',
h_about varchar(250) DEFAULT NULL,
h_addTime datetime DEFAULT NULL,
h_actIP char(50) DEFAULT NULL,
h_type char(50) DEFAULT NULL,
h_state varchar(10) DEFAULT NULL,
h_type_id tinyint(3) DEFAULT '0' COMMENT '1:种子转花 2：开垦 3：播种 4 :施肥 5：收获 6：开通新用户 7：新用户奖励花 8： 大转盘抽奖 9：花转账',
h_farmid tinyint(3) DEFAULT '0',
h_pname varchar(50) DEFAULT NULL,
h_remarks varchar(255) DEFAULT NULL,
h_account decimal(10,2) unsigned DEFAULT '0.00' COMMENT '账户余额',
PRIMARY KEY (id),
KEY h_userName (h_userName) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/!40101 SET character_set_client = @saved_cs_client /;

--
-- Dumping data for table h_log_point2
--

LOCK TABLES h_log_point2 WRITE;
/!40000 ALTER TABLE h_log_point2 DISABLE KEYS /;
/!40000 ALTER TABLE h_log_point2 ENABLE KEYS /;
UNLOCK TABLES;

--
-- Table structure for table h_member
--

DROP TABLE IF EXISTS h_member;
/!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE h_member (
id int(11) NOT NULL AUTO_INCREMENT,
h_userName varchar(20) DEFAULT NULL,
h_passWord varchar(32) DEFAULT NULL,
h_passWordII varchar(32) DEFAULT NULL,
h_fullName varchar(20) DEFAULT NULL,
h_sex varchar(2) DEFAULT NULL,
h_mobile varchar(11) DEFAULT NULL,
h_qq varchar(20) DEFAULT NULL,
h_email varchar(50) DEFAULT NULL,
h_regTime datetime DEFAULT NULL,
h_regIP char(50) DEFAULT NULL,
h_isPass int(11) DEFAULT '1' COMMENT '是否激活，激活才能登录',
h_moneyCurr decimal(9,2) DEFAULT '0.00' COMMENT '会员余额',
h_parentUserName varchar(20) DEFAULT NULL,
h_level int(11) DEFAULT '0',
h_point1 float(11,2) DEFAULT '0.00' COMMENT '推荐奖 种子',
h_point2 float(11,2) DEFAULT '0.00' COMMENT '花',
h_lastTime datetime DEFAULT NULL,
h_lastIP char(50) DEFAULT NULL,
h_alipayUserName char(100) DEFAULT NULL,
h_alipayFullName char(100) DEFAULT NULL,
h_addrAddress char(255) DEFAULT NULL,
h_addrPostcode char(20) DEFAULT NULL,
h_addrFullName char(20) DEFAULT NULL,
h_addrTel char(20) DEFAULT NULL,
h_weixin char(100) DEFAULT NULL,
h_logins int(11) DEFAULT '0',
h_a1 char(255) DEFAULT NULL,
h_q1 char(255) DEFAULT NULL,
h_a2 char(255) DEFAULT NULL,
h_q2 char(255) DEFAULT NULL,
h_a3 char(255) DEFAULT NULL,
h_q3 char(255) DEFAULT NULL,
h_isLock int(11) DEFAULT '0' COMMENT '锁定，不可登录',
h_passTime datetime DEFAULT NULL,
h_settleDate date DEFAULT NULL,
dog tinyint(3) DEFAULT '0' COMMENT '狗',
bogy float(11,2) DEFAULT '0.00' COMMENT '直推团队业绩',
invitnum tinyint(3) DEFAULT '0',
h_baidupay varchar(255) DEFAULT NULL COMMENT '百度钱包',
pwd1_check int(1) DEFAULT '0',
pwd2_check int(1) DEFAULT '0',
auto_caimi varchar(40) DEFAULT NULL,
h_sell_day varchar(40) DEFAULT '',
h_sell_num int(40) DEFAULT '0',
PRIMARY KEY (id),
KEY h_userName (h_userName) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
/!40101 SET character_set_client = @saved_cs_client /;

--
-- Dumping data for table h_member
--

LOCK TABLES h_member WRITE;
/!40000 ALTER TABLE h_member DISABLE KEYS /;
INSERT INTO h_member VALUES (2,'13333333333','51aa045f12f9400e5029154a38c187f4','51aa045f12f9400e5029154a38c187f4','码农网',NULL,NULL,'4058491',NULL,'2019-05-21 02:25:21','127.0.0.1',1,0.00,'',1,0.00,0.00,'2020-03-18 13:00:58','127.0.0.1','','','','','','',NULL,5,'123','456','789','123','7897','1231',0,NULL,NULL,0,0.00,0,NULL,0,0,NULL,'',0);
/!40000 ALTER TABLE h_member ENABLE KEYS /;
UNLOCK TABLES;

--
-- Table structure for table h_member_farm
--

DROP TABLE IF EXISTS h_member_farm;
/!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE h_member_farm (
id int(11) NOT NULL AUTO_INCREMENT,
h_userName varchar(20) DEFAULT NULL,
h_parentUserName varchar(20) DEFAULT NULL,
h_pid int(11) DEFAULT '0' COMMENT '动物id',
h_num int(11) DEFAULT '0' COMMENT '动物数量',
h_addTime datetime DEFAULT NULL COMMENT '购买时间',
h_endTime datetime DEFAULT NULL COMMENT '动物死亡时间',
h_lastSettleTime datetime DEFAULT NULL COMMENT '最后一次结算时间，直接在结算时记录当前时间；只用于显示或者备忘，结算算法中不用这个字段',
h_settleLen int(11) DEFAULT '0' COMMENT '结算次数',
h_isEnd int(11) DEFAULT '0' COMMENT '动物是否死亡',
h_title char(50) DEFAULT NULL,
h_pic char(255) DEFAULT NULL,
h_point2Day float(11,2) DEFAULT '0.00' COMMENT '每天生产金币',
h_life int(11) DEFAULT '0' COMMENT '生存周期',
h_money int(11) DEFAULT '0' COMMENT '售价',
h_benjin int(11) DEFAULT '0',
PRIMARY KEY (id),
KEY order_id (h_title)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/!40101 SET character_set_client = @saved_cs_client /;

--
-- Dumping data for table h_member_farm
--

LOCK TABLES h_member_farm WRITE;
/!40000 ALTER TABLE h_member_farm DISABLE KEYS /;
/!40000 ALTER TABLE h_member_farm ENABLE KEYS /;
UNLOCK TABLES;

--
-- Table structure for table h_member_msg
--

DROP TABLE IF EXISTS h_member_msg;
/!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE h_member_msg (
id int(11) NOT NULL AUTO_INCREMENT,
h_userName varchar(20) DEFAULT NULL,
h_toUserName varchar(20) DEFAULT NULL COMMENT '买家',
h_info text,
h_addTime datetime DEFAULT NULL,
h_actIP char(39) DEFAULT NULL,
h_isRead int(11) DEFAULT '0',
h_readTime datetime DEFAULT NULL,
h_isDelete int(11) DEFAULT '0' COMMENT '放弃或删除',
h_deleteTime datetime DEFAULT NULL,
PRIMARY KEY (id),
KEY h_userName (h_userName) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/!40101 SET character_set_client = @saved_cs_client /;

--
-- Dumping data for table h_member_msg
--

LOCK TABLES h_member_msg WRITE;
/!40000 ALTER TABLE h_member_msg DISABLE KEYS /;
/!40000 ALTER TABLE h_member_msg ENABLE KEYS /;
UNLOCK TABLES;

--
-- Table structure for table h_member_shop_cart
--

DROP TABLE IF EXISTS h_member_shop_cart;
/!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE h_member_shop_cart (
id int(11) NOT NULL AUTO_INCREMENT,
h_oid varchar(20) DEFAULT NULL,
h_userName varchar(20) DEFAULT NULL,
h_pid int(11) DEFAULT '0' COMMENT '动物id',
h_num int(11) DEFAULT '0' COMMENT '动物数量',
h_addTime datetime DEFAULT NULL COMMENT '购买时间',
h_title char(50) DEFAULT NULL,
h_pic char(255) DEFAULT NULL,
h_money int(11) DEFAULT '0' COMMENT '售价',
PRIMARY KEY (id),
KEY order_id (h_title)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
/!40101 SET character_set_client = @saved_cs_client /;

--
-- Dumping data for table h_member_shop_cart
--

LOCK TABLES h_member_shop_cart WRITE;
/!40000 ALTER TABLE h_member_shop_cart DISABLE KEYS /;
/!40000 ALTER TABLE h_member_shop_cart ENABLE KEYS /;
UNLOCK TABLES;

--
-- Table structure for table h_member_shop_order
--

DROP TABLE IF EXISTS h_member_shop_order;
/!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE h_member_shop_order (
id int(11) NOT NULL AUTO_INCREMENT,
h_oid varchar(20) DEFAULT NULL,
h_userName varchar(20) DEFAULT NULL,
h_addTime datetime DEFAULT NULL COMMENT '购买时间',
h_addrAddress char(255) DEFAULT NULL,
h_addrPostcode char(20) DEFAULT NULL,
h_addrFullName char(20) DEFAULT NULL,
h_addrTel char(20) DEFAULT NULL,
h_remark text,
h_state char(20) DEFAULT NULL COMMENT '待发货、已发货、拒绝发货',
h_money int(11) DEFAULT '0' COMMENT '订单总价',
h_isReturn int(20) DEFAULT '0' COMMENT '若审核失败，是否返款了，只返一次',
h_reply char(255) DEFAULT NULL,
PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/!40101 SET character_set_client = @saved_cs_client /;

--
-- Dumping data for table h_member_shop_order
--

LOCK TABLES h_member_shop_order WRITE;
/!40000 ALTER TABLE h_member_shop_order DISABLE KEYS /;
/!40000 ALTER TABLE h_member_shop_order ENABLE KEYS /;
UNLOCK TABLES;

--
-- Table structure for table h_menu
--

DROP TABLE IF EXISTS h_menu;
/!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE h_menu (
id int(11) NOT NULL AUTO_INCREMENT,
h_location varchar(20) DEFAULT NULL,
h_type varchar(20) DEFAULT NULL,
h_adminFile varchar(30) DEFAULT NULL,
h_title varchar(200) DEFAULT NULL,
h_pageKey varchar(200) DEFAULT NULL,
h_href varchar(250) DEFAULT NULL,
h_isPass int(11) DEFAULT '1',
h_target varchar(10) DEFAULT NULL,
h_order int(11) DEFAULT '0',
h_picBigWidth int(11) DEFAULT '0',
h_picBigHeight int(11) DEFAULT '0',
h_picSmallWidth int(11) DEFAULT '0',
h_picSmallHeight int(11) DEFAULT '0',
PRIMARY KEY (id)
) ENGINE=MyISAM AUTO_INCREMENT=112 DEFAULT CHARSET=utf8;
/!40101 SET character_set_client = @saved_cs_client /;

--
-- Dumping data for table h_menu
--

LOCK TABLES h_menu WRITE;
/!40000 ALTER TABLE h_menu DISABLE KEYS /;
INSERT INTO h_menu VALUES (83,'网站主栏目','link','link.php','首页','index','/',1,'_self',1,0,0,0,0),(108,'网站主栏目','news','news.php','会员公告','wan-jia-gong-gao','http://',1,'_self',2,600,450,200,150),(109,'网站主栏目','pics','pics1.php','农场商店','nong-chang-shang-dian','http://',1,'_self',3,600,450,200,150);
/!40000 ALTER TABLE h_menu ENABLE KEYS /;
UNLOCK TABLES;

--
-- Table structure for table h_pay_order
--

DROP TABLE IF EXISTS h_pay_order;
/!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE h_pay_order (
id int(11) NOT NULL AUTO_INCREMENT,
h_payId char(32) DEFAULT NULL,
h_orderId varchar(32) DEFAULT NULL,
h_payWay char(50) DEFAULT NULL,
h_payType char(50) DEFAULT NULL,
h_payPrice decimal(9,2) DEFAULT '0.00' COMMENT '打折后的金额',
h_addTime datetime DEFAULT NULL,
h_payTime datetime DEFAULT '0000-00-00 00:00:00' COMMENT '支付时间',
h_payState char(50) DEFAULT '待支付' COMMENT '待支付、已支付、支付失败',
h_wxNickName varchar(250) DEFAULT NULL,
h_wxOpenId varchar(250) DEFAULT NULL,
PRIMARY KEY (id),
KEY order_id (h_payId)
) ENGINE=MyISAM AUTO_INCREMENT=107 DEFAULT CHARSET=utf8;
/!40101 SET character_set_client = @saved_cs_client /;

--
-- Dumping data for table h_pay_order
--

LOCK TABLES h_pay_order WRITE;
/!40000 ALTER TABLE h_pay_order DISABLE KEYS /;
/!40000 ALTER TABLE h_pay_order ENABLE KEYS /;
UNLOCK TABLES;

--
-- Table structure for table h_point2_sell
--

DROP TABLE IF EXISTS h_point2_sell;
/!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE h_point2_sell (
id int(11) NOT NULL AUTO_INCREMENT,
h_userName varchar(20) DEFAULT NULL,
h_money int(11) DEFAULT '0',
h_alipayUserName char(100) DEFAULT NULL,
h_alipayFullName char(100) DEFAULT NULL,
h_weixin char(100) DEFAULT NULL,
h_tel char(20) DEFAULT NULL,
h_addTime datetime DEFAULT NULL,
h_state char(20) DEFAULT NULL COMMENT '挂单中、等待买家付款、买家放弃、卖家放弃、等待卖家确认收款、交易完成',
h_buyUserName varchar(20) DEFAULT NULL COMMENT '买家',
h_buyTime datetime DEFAULT NULL,
h_buyIsPay int(11) DEFAULT '0',
h_payTime datetime DEFAULT NULL,
h_isDelete int(11) DEFAULT '0' COMMENT '放弃或删除',
h_deleteTime datetime DEFAULT NULL,
h_confirmTime datetime DEFAULT NULL,
h_img varchar(255) DEFAULT NULL,
PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/!40101 SET character_set_client = @saved_cs_client /;

--
-- Dumping data for table h_point2_sell
--

LOCK TABLES h_point2_sell WRITE;
/!40000 ALTER TABLE h_point2_sell DISABLE KEYS /;
/!40000 ALTER TABLE h_point2_sell ENABLE KEYS /;
UNLOCK TABLES;

--
-- Table structure for table h_point2_shop
--

DROP TABLE IF EXISTS h_point2_shop;
/!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE h_point2_shop (
id int(11) NOT NULL AUTO_INCREMENT,
h_title char(255) DEFAULT NULL,
h_pic char(255) DEFAULT NULL,
h_minComMembers int(11) DEFAULT '0' COMMENT '至少要直荐多少人',
h_money int(11) DEFAULT '0' COMMENT '售价',
h_minMemberLevel int(11) DEFAULT '0',
buydj int(11) DEFAULT '0',
h_isPass int(11) DEFAULT '1',
h_info text,
h_addTime datetime DEFAULT NULL,
PRIMARY KEY (id),
KEY order_id (h_title)
) ENGINE=MyISAM AUTO_INCREMENT=181 DEFAULT CHARSET=utf8;
/!40101 SET character_set_client = @saved_cs_client /;

--
-- Dumping data for table h_point2_shop
--

LOCK TABLES h_point2_shop WRITE;
/!40000 ALTER TABLE h_point2_shop DISABLE KEYS /;
INSERT INTO h_point2_shop VALUES (177,'5罐铁观音礼盒装250g','/mobile/sc/5.jpg',565,200,359,1,1,'浓香型铁观音礼盒装 2017年新茶 安溪原产','2018-10-05 08:45:44'),(178,'100话费(移动/联通/电信)','/mobile/sc/cz.jpg',55,100,566,3,1,'全国话费充值 移动/联通/电信 快速到账','2018-10-05 10:19:20'),(180,'6666','/upload/2020/03/17/2020031714250097203.jpg',66,66,6666666,1,1,'天使投资天使投资天使投资天使投资天使投资天使投资天使投资天使投资天使投资天使投资天使投资天使投资天使投资天使投资天使投资天使投资天使投资天使投资天使投资天使投资天使投资天使投资天使投资','2020-03-17 14:13:43');
/!40000 ALTER TABLE h_point2_shop ENABLE KEYS /;
UNLOCK TABLES;

--
-- Table structure for table h_usebee
--

DROP TABLE IF EXISTS h_usebee;
/!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE h_usebee (
id int(11) NOT NULL AUTO_INCREMENT,
h_username varchar(50) NOT NULL COMMENT '用户名',
h_fusername varchar(50) NOT NULL COMMENT '父用户名',
h_price float(11,2) DEFAULT NULL COMMENT '采蜜奖励',
h_addTime datetime NOT NULL,
PRIMARY KEY (id)
) ENGINE=MyISAM AUTO_INCREMENT=260 DEFAULT CHARSET=utf8;
/!40101 SET character_set_client = @saved_cs_client /;

--
-- Dumping data for table h_usebee
--

LOCK TABLES h_usebee WRITE;
/!40000 ALTER TABLE h_usebee DISABLE KEYS /;
/!40000 ALTER TABLE h_usebee ENABLE KEYS /;
UNLOCK TABLES;

--
-- Table structure for table h_withdraw
--

DROP TABLE IF EXISTS h_withdraw;
/!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE h_withdraw (
id int(11) NOT NULL AUTO_INCREMENT,
h_userName varchar(50) DEFAULT NULL,
h_money int(11) DEFAULT '0',
h_fee int(11) DEFAULT '0',
h_bank varchar(32) DEFAULT NULL,
h_bankFullname varchar(32) DEFAULT NULL,
h_bankCardId varchar(32) DEFAULT NULL,
h_mobile varchar(20) DEFAULT NULL,
h_addTime datetime DEFAULT NULL,
h_isRead int(20) DEFAULT '0',
h_state char(20) DEFAULT NULL COMMENT '待审核、已打款、审核失败',
h_isReturn int(20) DEFAULT '0' COMMENT '若审核失败，是否返款了，只返一次',
h_reply char(255) DEFAULT NULL,
h_actIP char(39) DEFAULT NULL,
PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/!40101 SET character_set_client = @saved_cs_client /;

--
-- Dumping data for table h_withdraw
--

LOCK TABLES h_withdraw WRITE;
/!40000 ALTER TABLE h_withdraw DISABLE KEYS /;
/!40000 ALTER TABLE h_withdraw ENABLE KEYS /;
UNLOCK TABLES;
/!40103 SET TIME_ZONE=@OLD_TIME_ZONE /;

/!40101 SET SQL_MODE=@OLD_SQL_MODE /;
/!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS /;
/!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS /;
/!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT /;
/!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS /;
/!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION /;
/!40111 SET SQL_NOTES=@OLD_SQL_NOTES /;

-- Dump completed on 2020-03-20 5:36:47