卡信乐v2.0修复开源 SUP对接API卡盟程序+三内页模板+一键对接货源+对接易支付充值接口.zip

-- 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