WordPress程序某源码资源下载网站源码ripro主题整站数据源码资源打包下载

-- MySQL dump 10.13 Distrib 5.6.49, for Linux (x86_64) -- -- Host: localhost Database: qqqqqq -- ------------------------------------------------------ -- Server version 5.6.49-log /*!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 `wp_cao_balance_log` -- DROP TABLE IF EXISTS `wp_cao_balance_log`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `wp_cao_balance_log` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) DEFAULT NULL COMMENT '用户id', `old` double(10,2) DEFAULT NULL COMMENT '原始余额', `apply` double(10,2) DEFAULT NULL COMMENT '操作金额', `new` double(10,2) DEFAULT NULL COMMENT '新余额', `type` enum('charge','post','cdk','other') NOT NULL DEFAULT 'charge' COMMENT '类型：充值 资源 卡密 其他', `time` int(11) DEFAULT '0' COMMENT '操作时间', `note` varchar(255) DEFAULT NULL COMMENT '说明备注', PRIMARY KEY (`id`) USING BTREE ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COMMENT='消费记录表'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `wp_cao_balance_log` -- LOCK TABLES `wp_cao_balance_log` WRITE; /*!40000 ALTER TABLE `wp_cao_balance_log` DISABLE KEYS */; /*!40000 ALTER TABLE `wp_cao_balance_log` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `wp_cao_coupon` -- DROP TABLE IF EXISTS `wp_cao_coupon`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `wp_cao_coupon` ( `id` int(11) NOT NULL AUTO_INCREMENT, `code` varchar(32) DEFAULT NULL COMMENT '优惠码', `code_type` tinyint(3) NOT NULL DEFAULT '0' COMMENT '0 无 1 直减 2折扣', `create_time` int(11) NOT NULL DEFAULT '0' COMMENT '创建时间', `end_time` int(11) DEFAULT '0' COMMENT '到期时间', `apply_time` int(11) DEFAULT '0' COMMENT '使用时间', `status` tinyint(3) NOT NULL DEFAULT '0' COMMENT '状态：0未使用 1已使用', `sale_money` double(10,2) DEFAULT '0.00' COMMENT '优惠金额', `sale_float` float(2,1) DEFAULT '0.0' COMMENT '折扣', PRIMARY KEY (`id`) USING BTREE, KEY `code_index` (`code`) USING BTREE COMMENT '优惠码索引' ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COMMENT='优惠券'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `wp_cao_coupon` -- LOCK TABLES `wp_cao_coupon` WRITE; /*!40000 ALTER TABLE `wp_cao_coupon` DISABLE KEYS */; /*!40000 ALTER TABLE `wp_cao_coupon` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `wp_cao_down_log` -- DROP TABLE IF EXISTS `wp_cao_down_log`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `wp_cao_down_log` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) DEFAULT NULL COMMENT '用户id', `down_id` int(11) DEFAULT NULL COMMENT '下载文章ID', `ip` varchar(255) DEFAULT NULL COMMENT 'IP地址', `note` varchar(255) DEFAULT NULL COMMENT '说明备注', `create_time` int(11) DEFAULT '0' COMMENT '下载时间', PRIMARY KEY (`id`) USING BTREE, KEY `user_id_index` (`user_id`) USING BTREE ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COMMENT='下载记录日志'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `wp_cao_down_log` -- LOCK TABLES `wp_cao_down_log` WRITE; /*!40000 ALTER TABLE `wp_cao_down_log` DISABLE KEYS */; INSERT INTO `wp_cao_down_log` VALUES (1,1,729238,'120.227.23.137',NULL,1601814781); /*!40000 ALTER TABLE `wp_cao_down_log` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `wp_cao_order` -- DROP TABLE IF EXISTS `wp_cao_order`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `wp_cao_order` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) DEFAULT NULL COMMENT '用户id', `order_trade_no` varchar(50) DEFAULT NULL COMMENT '本地订单号', `order_price` double(10,2) DEFAULT NULL COMMENT '订单价格', `order_type` enum('charge','other') NOT NULL DEFAULT 'charge' COMMENT '充值 其他', `create_time` int(11) DEFAULT '0' COMMENT '创建时间', `pay_type` tinyint(3) DEFAULT '0' COMMENT '支付类型；0无；1支付宝；2微信', `pay_time` int(11) DEFAULT '0' COMMENT '支付时间', `pay_trade_no` varchar(50) DEFAULT NULL COMMENT '商户订单号', `status` tinyint(3) DEFAULT '0' COMMENT '状态；0 未支付；1已支付；-1失效', PRIMARY KEY (`id`) USING BTREE, KEY `order_trade_no_index` (`order_trade_no`) USING BTREE ) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COMMENT='在线充值订单表'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `wp_cao_order` -- LOCK TABLES `wp_cao_order` WRITE; /*!40000 ALTER TABLE `wp_cao_order` DISABLE KEYS */; INSERT INTO `wp_cao_order` VALUES (1,1,'201003010110289130939',0.50,'other',1601701270,1,0,NULL,0),(2,1,'201004034649735961914',1.00,'charge',1601797609,1,0,NULL,0),(3,1,'201004034702241735448',1.00,'charge',1601797622,7,0,NULL,0),(4,0,'201004092031825733213',0.50,'other',1601817631,7,0,NULL,0),(5,1,'210101053639355623380',0.10,'other',1609493799,7,0,NULL,0),(6,1,'210101053713708427961',0.10,'other',1609493833,7,0,NULL,0),(7,4,'210101065023465624358',88.80,'other',1609498223,7,0,NULL,0),(8,4,'210101065154190271128',88.80,'other',1609498314,7,0,NULL,0),(9,4,'210101065804373561873',0.50,'other',1609498684,7,0,NULL,0); /*!40000 ALTER TABLE `wp_cao_order` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `wp_cao_paylog` -- DROP TABLE IF EXISTS `wp_cao_paylog`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `wp_cao_paylog` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) DEFAULT NULL COMMENT '用户id', `post_id` int(11) DEFAULT NULL COMMENT '关联文章ID', `order_trade_no` varchar(50) DEFAULT NULL COMMENT '本地订单号', `order_price` double(10,2) DEFAULT NULL COMMENT '文章价格', `order_amount` double(10,2) DEFAULT NULL COMMENT '实际扣除金额', `order_type` enum('post','other') NOT NULL DEFAULT 'post' COMMENT '文章资源 其他', `order_sale` float(2,1) DEFAULT '0.0' COMMENT 'VIP折扣', `create_time` int(11) DEFAULT '0' COMMENT '创建时间', `pay_type` tinyint(3) DEFAULT '0' COMMENT '支付类型；0无；1余额；2其他', `pay_time` int(11) DEFAULT '0' COMMENT '支付时间', `status` tinyint(3) DEFAULT '0' COMMENT '状态；0 无；1已购买；-1失效', PRIMARY KEY (`id`) USING BTREE, KEY `post_id_index` (`post_id`) USING BTREE, KEY `user_id_index` (`user_id`) USING BTREE ) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COMMENT='文章资源购买表'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `wp_cao_paylog` -- LOCK TABLES `wp_cao_paylog` WRITE; /*!40000 ALTER TABLE `wp_cao_paylog` DISABLE KEYS */; INSERT INTO `wp_cao_paylog` VALUES (1,1,729151,'201003010110289130939',5.00,5.00,'post',1.0,1601701270,1,0,0),(2,1,729148,'201003055544924277771',5.00,5.00,'post',1.0,1601704544,127,0,0),(3,0,729134,'201004092031825733213',5.00,5.00,'post',1.0,1601817631,7,0,0),(4,1,5,'210101053639355623380',1.00,0.00,'post',0.0,1609493799,7,0,0),(5,1,5,'210101053713708427961