-- phpMyAdmin SQL Dump
-- version 4.0.10.20
-- https://www.phpmyadmin.net
--
-- 主机: localhost
-- 生成日期: 2017-05-14 11:59:42
-- 服务器版本: 5.5.55-log
-- PHP 版本: 5.3.29
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
/*!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 */;
--
-- 数据库: `wangka.961ka.cn`
--
-- --------------------------------------------------------
DROP TABLE IF EXISTS `cloudrecord`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cloudrecord` (
`id` int(30) unsigned NOT NULL AUTO_INCREMENT,
`lucky` varchar(50) NOT NULL,
`userid` varchar(100) NOT NULL,
`cloudid` varchar(150) DEFAULT NULL,
`time` varchar(50) DEFAULT NULL,
UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `buytpcontent`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `buytpcontent` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(100) NOT NULL,
`nameval` text NOT NULL,
`buyid` int(10) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- 表的结构 `adminback`
--
CREATE TABLE IF NOT EXISTS `cloudgoods` (
`id` int(20) unsigned NOT NULL AUTO_INCREMENT,
`numbereriods` int(20) NOT NULL,
`cloudtitle` text NOT NULL,
`cloudcover` varchar(250) NOT NULL,
`cloudmoney` decimal(10,3) NOT NULL,
`cloudtype` int(2) NOT NULL,
`totalnumber` varchar(200) NOT NULL,
`winneruserid` varchar(250) DEFAULT NULL,
`winnerlucky` varchar(250) DEFAULT NULL,
`onlylabel` varchar(300) NOT NULL,
`state` int(2) DEFAULT '1',
`consigneename` varchar(50) DEFAULT NULL,
`consigneephone` varchar(50) DEFAULT NULL,
`consigneeaddress` varchar(300) DEFAULT NULL,
`consigneeareacode` varchar(50) DEFAULT NULL,
`consigneetype` int(2) DEFAULT '0',
`deliverystate` int(2) DEFAULT '0',
`delivernumber` varchar(50) DEFAULT NULL,
`delivername` varchar(50) DEFAULT NULL,
`time` varchar(50) DEFAULT NULL,
`delivertime` varchar(50) DEFAULT NULL,
`content` text,
`strnumber` int(20) DEFAULT '1',
UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `adminback` (
`id` int(7) unsigned NOT NULL AUTO_INCREMENT,
`adminuser` varchar(50) NOT NULL,
`adminpass` varchar(50) NOT NULL,
`type` int(2) NOT NULL,
`ban` int(2) NOT NULL,
`sessionid` varchar(250) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
DROP TABLE IF EXISTS `feedbackrecord`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `feedbackrecord` (
`id` int(30) unsigned NOT NULL AUTO_INCREMENT,
`buyid` int(30) NOT NULL,
`type` int(2) NOT NULL,
`center` text NOT NULL,
`feetime` varchar(50) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=6275 DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `cami`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cami` (
`id` int(12) unsigned NOT NULL AUTO_INCREMENT,
`Cardmember` varchar(150) CHARACTER SET utf8 NOT NULL,
`Cami` varchar(150) CHARACTER SET utf8 NOT NULL,
`commid` int(12) NOT NULL,
`type` int(2) NOT NULL,
`userid` int(12) DEFAULT NULL,
`time` varchar(50) CHARACTER SET utf8 NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=28004 DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `commtpcontent`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `commtpcontent` (
`id` int(7) unsigned NOT NULL AUTO_INCREMENT,
`tid` int(7) NOT NULL,
`name` varchar(100) NOT NULL,
`contenttype` int(2) DEFAULT '1',
`contentselect` text NOT NULL,
`sort` int(10) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=760 DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- 表的结构 `article`
--
CREATE TABLE IF NOT EXISTS `article` (
`id` int(7) unsigned NOT NULL AUTO_INCREMENT,
`uid` varchar(50) NOT NULL,
`Type` int(2) NOT NULL,
`Title` varchar(100) NOT NULL,
`titlecolor` varchar(50) NOT NULL,
`content` text NOT NULL,
`Time` varchar(50) CHARACTER SET latin1 NOT NULL,
`vip` int(20) DEFAULT '0',
PRIMARY KEY (`id`),
UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- 表的结构 `backflag`
--
CREATE TABLE IF NOT EXISTS `backflag` (
`id` int(12) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(50) NOT NULL,
`flag` varchar(500) NOT NULL,
`sid` varchar(50) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- 表的结构 `bank`
--
CREATE TABLE IF NOT EXISTS `bank` (
`id` int(7) unsigned NOT NULL AUTO_INCREMENT,
`BankType` int(2) NOT NULL,
`address` varchar(50) NOT NULL,
`account` varchar(50) NOT NULL,
`accountname` varchar(50) NOT NULL,
`vip` int(20) DEFAULT '0',
PRIMARY KEY (`id`),
UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- 表的结构 `buyrecord`
--
CREATE TABLE IF NOT EXISTS `buyrecord` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`commname` varchar(300) NOT NULL,
`CommType` int(2) NOT NULL,
`CommPar` decimal(10,3) NOT NULL,
`supplier` decimal(10,3) NOT NULL,
`janeOS` decimal(10,3) NOT NULL,
`difference` decimal(10,3) NOT NULL,
`Integral` decimal(10,0) NOT NULL,
`user` int(10) NOT NULL,
`commuser` int(10) NOT NULL,
`type` int(2) NOT NULL,
`textcomm` text NOT NULL,
`Time` varchar(50) NOT NULL,
`Endtime` varchar(50) DEFAULT NULL,
`number` varchar(50) NOT NULL,
`Complaint` text NOT NULL,
`amount` decimal(10,3) NOT NULL,
`Theme` varchar(50) DEFAULT NULL,
`Supplaint` text,
`Cami` int(12) DEFAULT '0',
`Paylocat` varchar(100) DEFAULT NULL,
`commnumber` varchar(100) DEFAULT '1',
`dockingtype` int(3) DEFAULT '0',
`dockingtypes` int(3) DEFAULT '0',
`dockingid` int(20) DEFAULT '0',
`dockigdorealm` varchar(100) DEFAULT NULL,
`dockingserverkey` varchar(50) DEFAULT NULL,
`commid` int(20) DEFAULT NULL,
`recordtype` int(2) DEFAULT '0',
`seconds` int(2) DEFAULT '0',
`commqq` varchar(250) DEFAULT NULL,
`commpass` varchar(250) DEFAULT NULL,
`commfee` decimal(10,3) DEFAULT '0.000',
`dockingnumber` varchar(150) DEFAULT '0',
`refund` int(2) DEFAULT '0',
`chargeback` int(2) DEFAULT '0',
PRIMARY KEY (`id`),
KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- 表的结构 `cardfl`
--
CREATE TABLE IF NOT EXISTS `cardfl` (
`id` int(20) unsigned NOT NULL AUTO_INCREMENT,
`tid` int(20) NOT NULL,
`Cardzhef` varchar(50) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- 表的结构 `cardorder`
--
CREATE TABLE IF NOT EXISTS `cardorder` (
`id` int(20) unsigned NOT NULL AUTO_INCREMENT,
`Order` varchar(100) NOT NULL,
`userid` int(20) NOT NULL,
`moneys` varchar(50) NOT NULL,
`realmoney` varchar(50) DEFAULT NULL,
`janemoneys` varchar(50) NOT NULL,
`Recharge` varchar(50) NOT NULL,
`time` varchar(50) NOT NULL,
`type` int(3) NOT NULL,
`CardNo` varchar(100) NOT NULL,
`CardPassword` varchar(100) NOT NULL,
`FaiReason` varchar(15