1 Star 0 Fork 0

Dave/h5sy.nf305.com

加入 Gitee
与超过 1200万 开发者一起发现、参与优秀开源项目,私有仓库也完全免费 :)
免费加入
文件
该仓库未声明开源许可证文件(LICENSE),使用请关注具体项目描述及其代码上游依赖。
克隆/下载
h5sy_yukusoft.sql 10.34 KB
一键复制 编辑 原始数据 按行查看 历史
Dave 提交于 2021-06-30 20:20 . inter
-- MySQL dump 10.13 Distrib 5.6.33, for Linux (x86_64)
--
-- Host: localhost Database: h5sy_yukusoft
-- ------------------------------------------------------
-- Server version 5.6.33
/*!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 `sw_pic_data`
--
DROP TABLE IF EXISTS `sw_pic_data`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sw_pic_data` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`org` varchar(200) DEFAULT '' COMMENT '原图',
`thum` varchar(200) DEFAULT '' COMMENT '缩略图',
`from_type` int(11) DEFAULT '0',
`cdate` bigint(20) DEFAULT '0' COMMENT '创建时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `sw_pic_data`
--
LOCK TABLES `sw_pic_data` WRITE;
/*!40000 ALTER TABLE `sw_pic_data` DISABLE KEYS */;
INSERT INTO `sw_pic_data` VALUES (1,'/20190410/org/b/97/819/f784/03b11f2cbccaa1d7b0a7c3.png','',0,1554874033);
/*!40000 ALTER TABLE `sw_pic_data` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `yh_adve`
--
DROP TABLE IF EXISTS `yh_adve`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `yh_adve` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`title` varchar(50) DEFAULT '' COMMENT '标题名称',
`url` varchar(100) DEFAULT '' COMMENT 'url',
`create_time` bigint(50) DEFAULT '0',
`update_time` bigint(50) DEFAULT '0',
`status` tinyint(2) DEFAULT '1' COMMENT '状态:0禁用,1启用',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='广告位';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `yh_adve`
--
LOCK TABLES `yh_adve` WRITE;
/*!40000 ALTER TABLE `yh_adve` DISABLE KEYS */;
/*!40000 ALTER TABLE `yh_adve` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `yh_adver`
--
DROP TABLE IF EXISTS `yh_adver`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `yh_adver` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`name` varchar(50) DEFAULT '' COMMENT '名称',
`game_category` int(11) DEFAULT '0' COMMENT '游戏分类ID',
`url` varchar(255) DEFAULT '',
`pic` int(11) DEFAULT '0' COMMENT '图片ID',
`sort` int(11) DEFAULT '0' COMMENT '排序',
`create_time` bigint(50) DEFAULT '0',
`update_time` bigint(50) DEFAULT '0',
`status` tinyint(2) DEFAULT '1' COMMENT '状态:0禁用,1启用',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `yh_adver`
--
LOCK TABLES `yh_adver` WRITE;
/*!40000 ALTER TABLE `yh_adver` DISABLE KEYS */;
/*!40000 ALTER TABLE `yh_adver` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `yh_banner`
--
DROP TABLE IF EXISTS `yh_banner`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `yh_banner` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`title` varchar(100) DEFAULT '',
`pic` int(11) DEFAULT NULL,
`sort` int(11) DEFAULT '0',
`url` varchar(255) DEFAULT '' COMMENT '跳转地址',
`is_status` tinyint(2) DEFAULT '1' COMMENT '0下架1上架',
`create_time` bigint(20) DEFAULT '0',
`update_time` bigint(20) DEFAULT '0',
`status` tinyint(2) DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='幻灯图';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `yh_banner`
--
LOCK TABLES `yh_banner` WRITE;
/*!40000 ALTER TABLE `yh_banner` DISABLE KEYS */;
INSERT INTO `yh_banner` VALUES (1,'asd',1,50,'asd',1,1554874034,0,1);
/*!40000 ALTER TABLE `yh_banner` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `yh_category`
--
DROP TABLE IF EXISTS `yh_category`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `yh_category` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`category` int(11) DEFAULT '1' COMMENT '1->近日推荐2->游戏榜单->3->游戏管理',
`name` varchar(50) DEFAULT '',
`title` varchar(50) DEFAULT NULL,
`createTime` bigint(20) DEFAULT '0',
`upTime` bigint(20) DEFAULT '0',
`status` tinyint(2) DEFAULT '1',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='云海频道页管理后台';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `yh_category`
--
LOCK TABLES `yh_category` WRITE;
/*!40000 ALTER TABLE `yh_category` DISABLE KEYS */;
/*!40000 ALTER TABLE `yh_category` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `yh_game`
--
DROP TABLE IF EXISTS `yh_game`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `yh_game` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`category_id` int(11) DEFAULT '0' COMMENT '分类id',
`ww_number` varchar(50) DEFAULT '' COMMENT '网维编号',
`pic_id` int(11) DEFAULT '0' COMMENT '图片id',
`pic2_id` int(11) DEFAULT '0' COMMENT '二维码',
`adver_url` varchar(200) DEFAULT '' COMMENT '地址',
`title` varchar(200) DEFAULT '',
`number` int(11) DEFAULT '0' COMMENT '人数',
`sort` int(11) DEFAULT '0' COMMENT '排序',
`is_status` tinyint(2) DEFAULT '1' COMMENT '1上架 0下架',
`create_time` bigint(20) DEFAULT '0',
`update_time` bigint(20) DEFAULT '0',
`status` tinyint(2) DEFAULT '1',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='游戏记录表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `yh_game`
--
LOCK TABLES `yh_game` WRITE;
/*!40000 ALTER TABLE `yh_game` DISABLE KEYS */;
/*!40000 ALTER TABLE `yh_game` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `yh_game_category`
--
DROP TABLE IF EXISTS `yh_game_category`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `yh_game_category` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`title` varchar(50) DEFAULT '',
`sort` int(50) DEFAULT '0',
`create_time` bigint(50) DEFAULT '0',
`update_time` bigint(50) DEFAULT '0',
`status` tinyint(2) DEFAULT '1' COMMENT '状态:0禁用,1启用',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `yh_game_category`
--
LOCK TABLES `yh_game_category` WRITE;
/*!40000 ALTER TABLE `yh_game_category` DISABLE KEYS */;
/*!40000 ALTER TABLE `yh_game_category` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `yh_ranking`
--
DROP TABLE IF EXISTS `yh_ranking`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `yh_ranking` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`game_id` int(11) DEFAULT '0' COMMENT '游戏ID',
`category_id` int(11) DEFAULT '0' COMMENT '分类ID',
`logo` int(11) DEFAULT '0' COMMENT 'Logo图标',
`sort` int(50) DEFAULT '0' COMMENT '排序',
`type_status` varchar(255) DEFAULT '' COMMENT '类型',
`create_time` bigint(50) DEFAULT '0',
`update_time` bigint(50) DEFAULT '0',
`status` tinyint(2) DEFAULT '1' COMMENT '状态:0禁用,1启用',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `yh_ranking`
--
LOCK TABLES `yh_ranking` WRITE;
/*!40000 ALTER TABLE `yh_ranking` DISABLE KEYS */;
/*!40000 ALTER TABLE `yh_ranking` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `yh_ranking_category`
--
DROP TABLE IF EXISTS `yh_ranking_category`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `yh_ranking_category` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`title` varchar(50) DEFAULT '',
`sort` int(50) DEFAULT '0',
`create_time` bigint(50) DEFAULT '0',
`update_time` bigint(50) DEFAULT '0',
`status` tinyint(2) DEFAULT '1' COMMENT '状态:0禁用,1启用',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `yh_ranking_category`
--
LOCK TABLES `yh_ranking_category` WRITE;
/*!40000 ALTER TABLE `yh_ranking_category` DISABLE KEYS */;
/*!40000 ALTER TABLE `yh_ranking_category` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `yh_recom`
--
DROP TABLE IF EXISTS `yh_recom`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `yh_recom` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`game_id` int(11) DEFAULT '0',
`sort` int(11) DEFAULT '0' COMMENT '排序',
`pic_id` int(11) DEFAULT '0' COMMENT '图片ID',
`is_status` tinyint(4) DEFAULT '1' COMMENT '0下架 1上架',
`create_time` bigint(50) DEFAULT '0',
`update_time` bigint(50) DEFAULT '0',
`status` tinyint(2) DEFAULT '1' COMMENT '状态:0禁用,1启用',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `yh_recom`
--
LOCK TABLES `yh_recom` WRITE;
/*!40000 ALTER TABLE `yh_recom` DISABLE KEYS */;
/*!40000 ALTER TABLE `yh_recom` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-- Dump completed on 2019-10-09 15:46:04
Loading...
马建仓 AI 助手
尝试更多
代码解读
代码找茬
代码优化
1
https://gitee.com/shuai_nie/h5sy.nf305.com.git
git@gitee.com:shuai_nie/h5sy.nf305.com.git
shuai_nie
h5sy.nf305.com
h5sy.nf305.com
master

搜索帮助