最新大猿人中控充值系统

-- MariaDB dump 10.19 Distrib 10.8.2-MariaDB, for Linux (x86_64) -- -- Host: localhost Database: ceshi -- ------------------------------------------------------ -- Server version 10.8.2-MariaDB-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 utf8mb4 */; /*!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 `admin` -- DROP TABLE IF EXISTS `admin`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `admin` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `account` varchar(255) DEFAULT 'admin', `password` varchar(255) DEFAULT 'e10adc3949ba59abbe56e057f20f883e', `login_token` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb3; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `admin` -- LOCK TABLES `admin` WRITE; /*!40000 ALTER TABLE `admin` DISABLE KEYS */; INSERT INTO `admin` VALUES (1,'admin','e10adc3949ba59abbe56e057f20f883e\n','a43vSABJa2hy1Eoh5qUEYVsaYe8OVn21'); /*!40000 ALTER TABLE `admin` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `cart` -- DROP TABLE IF EXISTS `cart`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `cart` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `name` text DEFAULT NULL, `money` decimal(16,2) DEFAULT NULL, `quota` varchar(255) NOT NULL DEFAULT '0', `weight` decimal(16,0) NOT NULL DEFAULT 0, `status` char(1) DEFAULT '1', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `cart` -- LOCK TABLES `cart` WRITE; /*!40000 ALTER TABLE `cart` DISABLE KEYS */; /*!40000 ALTER TABLE `cart` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `dyr_ad` -- DROP TABLE IF EXISTS `dyr_ad`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `dyr_ad` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(50) NOT NULL COMMENT '名字', `key` varchar(100) NOT NULL COMMENT '关键字', `desc` varchar(100) DEFAULT NULL COMMENT '描述', `weixin_appid` varchar(255) NOT NULL DEFAULT '', PRIMARY KEY (`id`), KEY `key` (`key`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COMMENT='广告位'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `dyr_ad` -- LOCK TABLES `dyr_ad` WRITE; /*!40000 ALTER TABLE `dyr_ad` DISABLE KEYS */; INSERT INTO `dyr_ad` VALUES (6,'首页广告','indexkey','尺寸750x250',''), (8,'申请代理','agapply','尺寸750x340',''); /*!40000 ALTER TABLE `dyr_ad` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `dyr_adc` -- DROP TABLE IF EXISTS `dyr_adc`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `dyr_adc` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `ad_id` int(11) NOT NULL, `path` varchar(255) NOT NULL, `create_time` int(11) NOT NULL, `url` varchar(500) DEFAULT NULL, `words` varchar(500) DEFAULT NULL, `sort` int(11) NOT NULL DEFAULT 0 COMMENT '排序', `title` varchar(255) DEFAULT NULL COMMENT '标题', `bft1` varchar(255) DEFAULT NULL COMMENT '备选字段1', `bft2` varchar(255) DEFAULT NULL COMMENT '备选字段2', PRIMARY KEY (`id`), KEY `ad_id` (`ad_id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=48 DEFAULT CHARSET=utf8mb4 COMMENT='广告图'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `dyr_adc` -- LOCK TABLES `dyr_adc` WRITE; /*!40000 ALTER TABLE `dyr_adc` DISABLE KEYS */; INSERT INTO `dyr_adc` VALUES (25,6,'https://recharge2.dayuanren.cn/uploads/20211026/5f75305a29dce05e51e0a5d8e1c9f9d5.jpg',0,'','首页',1,'','',''), (46,8,'https://recharge2.dayuanren.cn/uploads/20210723/d21e4c3a1dd29750ac5d2e127c0fe90c.jpg',1624934446,'','',0,'','',''), (47,6,'https://recharge2.dayuanren.cn/uploads/20211026/0358261680266177f6e5e7b4bf59a17e.jpg',1627012606,'','',0,'','',''); /*!40000 ALTER TABLE `dyr_adc` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `dyr_addonarticle` -- DROP TABLE IF EXISTS `dyr_addonarticle`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `dyr_addonarticle` ( `aid` mediumint(8) unsigned NOT NULL DEFAULT 0, `typeid` smallint(5) unsigned NOT NULL DEFAULT 0, `body` mediumtext DEFAULT NULL COMMENT '内容', PRIMARY KEY (`aid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `dyr_addonarticle` -- LOCK TABLES `dyr_addonarticle` WRITE; /*!40000 ALTER TABLE `dyr_addonarticle` DISABLE KEYS */; INSERT INTO `dyr_addonarticle` VALUES (1,1,'<p><br/></p><h1 style=\"border-bottom-color:#cccccc;border-bottom-width:2px;border-bottom-style:solid;padding:0px 4px 0px 0px;text-align:center;margin:0px 0px 20px;\">怎么开店</h1><p><img src=\"http://img.baidu.com/hi/youa/y_0034.gif\" width=\"300\" height=\"200\"/>图文混排方法</p><p>1. 图片居左，文字围绕图片排版</p><p>方法：在文字前面插入图片，设置居左对齐，然后即可在右边输入多行文本</p><p><br/></p><p>2. 图片居右，文字围绕图片排版</p><p>方法：在文字前面插入图片，设置居右对齐，然后即可在左边输入多行文本</p><p><br/></p><p>3. 图片居中环绕排版</p><p>方法：亲，这个真心没有办法。。。</p><p><br/></p><p><br/></p><p><img src=\"http://img.baidu.com/hi/youa/y_0040.gif\" width=\"300\" height=\"300\"/></p><p>还有没有什么其他的环绕方式呢？这里是居右环绕</p><p><br/></p><p>欢迎大家多多尝试，为UEditor提供更多高质量模板！</p><p><br/></p><p><br/></p><p><br/></p>'), (2,1,'<p style=\"box-sizing: border-box; margin-top: 0px; margin-bottom: 10px; color: rgb(103, 106, 108); font-family: &quot;open sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; font-size: 13px; white-space: normal;\"><span style=\"box-sizing: border-box; font-weight: 700; font-size: 24px; color: rgb(255, 0, 0);\">请认真看完公告，多关注后台，资源变动有时候提醒不到位，后台资源为准。</span></p><p style=\"box-sizing: border-box; margin-top: 0px; margin-bottom: 10px; color: rgb(103, 106, 108); font-family: &quot;open sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; font-size: 13px; white-space: normal;\"><strong><span style=\"font-size: 18px;\">南网5省-上架 广东/广西/海南/云南/贵州-需填写身份证后六位（欠费200内可充，单户当日最多充2000元））&nbsp;</span></strong></p><p style=\"box-sizing: border-box; margin-top: 0px; margin-bottom: 10px; color: rgb(103, 106, 108); font-family: &quot;open sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; font-size: 13px; white-space: normal;\"><strong><span style=\"font-size: 18px;\">国网电费正常接单中，禁止拆单（就是一个户不要同时下单多次，可以等充值成功后，在下单）不按指示来出返销不赔。</span></strong></p><p style=\"box-sizing: border-box; margin-top: 0px; margin-bottom: 10px; color: rgb(103, 106, 108); font-family: &quot;open sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Aria