2023新版去水印微信小程序+流量主+PHP内核独立后台+内置解析接口+自定义接口+部署教程

-- MySQL dump 10.13 Distrib 5.7.40, for Linux (x86_64) -- -- Host: localhost Database: jumao -- ------------------------------------------------------ -- Server version 5.7.40-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 `yoshop_admin_user` -- DROP TABLE IF EXISTS `yoshop_admin_user`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `yoshop_admin_user` ( `admin_user_id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键id', `user_name` varchar(255) DEFAULT NULL COMMENT '用户名', `password` varchar(255) DEFAULT NULL COMMENT '登录密码', `create_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间', `update_time` int(11) NOT NULL DEFAULT '0' COMMENT '更新时间', PRIMARY KEY (`admin_user_id`), KEY `user_name` (`user_name`) ) ENGINE=InnoDB AUTO_INCREMENT=10002 DEFAULT CHARSET=utf8 COMMENT='超管用户记录表'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `yoshop_admin_user` -- LOCK TABLES `yoshop_admin_user` WRITE; /*!40000 ALTER TABLE `yoshop_admin_user` DISABLE KEYS */; INSERT INTO `yoshop_admin_user` VALUES (10001,'admin','e10adc3949ba59abbe56e057f20f883e',1670852595,1670852595); /*!40000 ALTER TABLE `yoshop_admin_user` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `yoshop_setting` -- DROP TABLE IF EXISTS `yoshop_setting`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `yoshop_setting` ( `key` varchar(30) NOT NULL COMMENT '设置项标示', `describe` varchar(255) DEFAULT NULL COMMENT '设置项描述', `values` mediumtext NOT NULL COMMENT '设置内容（json格式）', `wxapp_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '小程序id', `update_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间', UNIQUE KEY `unique_key` (`key`,`wxapp_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='商城设置记录表'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `yoshop_setting` -- LOCK TABLES `yoshop_setting` WRITE; /*!40000 ALTER TABLE `yoshop_setting` DISABLE KEYS */; /*!40000 ALTER TABLE `yoshop_setting` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `yoshop_store_access` -- DROP TABLE IF EXISTS `yoshop_store_access`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `yoshop_store_access` ( `access_id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键id', `name` varchar(255) DEFAULT NULL COMMENT '权限名称', `url` varchar(255) DEFAULT NULL COMMENT '权限url', `parent_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '父级id', `sort` tinyint(3) unsigned NOT NULL DEFAULT '100' COMMENT '排序(数字越小越靠前)', `create_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间', `update_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间', PRIMARY KEY (`access_id`) ) ENGINE=InnoDB AUTO_INCREMENT=10001 DEFAULT CHARSET=utf8 COMMENT='商家用户权限表'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `yoshop_store_access` -- LOCK TABLES `yoshop_store_access` WRITE; /*!40000 ALTER TABLE `yoshop_store_access` DISABLE KEYS */; /*!40000 ALTER TABLE `yoshop_store_access` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `yoshop_store_role` -- DROP TABLE IF EXISTS `yoshop_store_role`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `yoshop_store_role` ( `role_id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '角色id', `role_name` varchar(50) DEFAULT NULL COMMENT '角色名称', `parent_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '父级角色id', `sort` tinyint(3) unsigned NOT NULL DEFAULT '100' COMMENT '排序(数字越小越靠前)', `wxapp_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '小程序id', `create_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间', `update_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间', PRIMARY KEY (`role_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='商家用户角色表'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `yoshop_store_role` -- LOCK TABLES `yoshop_store_role` WRITE; /*!40000 ALTER TABLE `yoshop_store_role` DISABLE KEYS */; /*!40000 ALTER TABLE `yoshop_store_role` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `yoshop_store_role_access` -- DROP TABLE IF EXISTS `yoshop_store_role_access`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `yoshop_store_role_access` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键id', `role_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '角色id', `access_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '权限id', `wxapp_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '小程序id', `create_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间', PRIMARY KEY (`id`), KEY `role_id` (`role_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='商家用户角色权限关系表'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `yoshop_store_role_access` -- LOCK TABLES `yoshop_store_role_access` WRITE; /*!40000 ALTER TABLE `yoshop_store_role_access` DISABLE KEYS */; /*!40000 ALTER TABLE `yoshop_store_role_access` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `yoshop_store_user` -- DROP TABLE IF EXISTS `yoshop_store_user`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `yoshop_store_user` ( `store_user_id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键id', `user_name` varchar(255) DEFAULT NULL COMMENT '用户名', `password` varchar(255) DEFAULT NULL COMMENT '登录密码', `real_name` varchar(255) DEFAULT NULL COMMENT '姓名', `is_super` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '是否为超级管理员', `is_delete` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '是否删除', `wxapp_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '小程序id', `create_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间', `update_time` int(11) NOT NULL DEFAULT '0' COMMENT '更新时间', PRIMARY KEY (`store_user_id`), KEY `user_name` (`user_name`) ) ENGINE=InnoDB AUTO_INCREMENT=10001 DEFAULT CHARSET=utf8 COMMENT='商家用户记录表'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `yoshop_store_user` -- LOCK TABLES `yoshop_store_user` WRITE; /*!40000 ALTER TABLE `yoshop_store_user` DISABLE KEYS */; /*!40000 ALTER TABLE `yoshop_store_user` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `yoshop_store_user_role` -- DROP TABLE IF EXISTS `yoshop_store_user_role`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `yoshop_store_user_role` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键id', `store_user_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '超管用户i