-- phpMyAdmin SQL Dump
-- version 4.0.10.2
-- http://www.phpmyadmin.net
--
-- 主机: localhost
-- 生成日期: 2019-09-05 06:54:27
-- 服务器版本: 5.6.43
-- PHP 版本: 5.4.16

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 */;

--
-- 数据库: `gksite`
--

-- --------------------------------------------------------

--
-- 表的结构 `gk_cmptsetting`
--

CREATE TABLE IF NOT EXISTS `gk_cmptsetting` (
  `id` varchar(64) COLLATE utf8_bin NOT NULL COMMENT '主键',
  `cmptid` varchar(64) COLLATE utf8_bin NOT NULL COMMENT '赛事ID',
  `name` varchar(30) COLLATE utf8_bin NOT NULL COMMENT '功能设置的名称',
  `type` int(9) NOT NULL COMMENT '活动类型  1:成绩 2:照片  3:签到  4:参赛手册',
  `visibility` varchar(64) COLLATE utf8_bin NOT NULL COMMENT '是否启用,0:不启用  1:启用           是否发布:0:否  1:是',
  `seq` varchar(2) COLLATE utf8_bin NOT NULL COMMENT '顺序号',
  `create_by` varchar(64) COLLATE utf8_bin DEFAULT NULL COMMENT '创建者',
  `create_date` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_by` varchar(64) COLLATE utf8_bin DEFAULT NULL COMMENT '创建者',
  `update_date` timestamp NULL DEFAULT '0000-00-00 00:00:00' COMMENT '创建时间',
  `del_flag` char(1) COLLATE utf8_bin DEFAULT '0' COMMENT '删除标准',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='赛事表';

--
-- 转存表中的数据 `gk_cmptsetting`
--

INSERT INTO `gk_cmptsetting` (`id`, `cmptid`, `name`, `type`, `visibility`, `seq`, `create_by`, `create_date`, `update_by`, `update_date`, `del_flag`) VALUES
('0a7abfdf0dab414596bde8ba33f13eb9', '7932', '人脸签到', 3, '0,1', '3', NULL, NULL, NULL, NULL, '0'),
('0e843f4b39fb4d70ad706a182518772e', '7932', '赛事照片', 2, '0,1', '2', NULL, NULL, NULL, NULL, '0'),
('23bebcbdf1a441b9bfb0be41bd0a8065', '7932', '赛事成绩', 1, '0,1', '1', NULL, NULL, NULL, NULL, '0'),
('abdb9406df6045d89b4c28bab6e0ba0c', '7932', '参赛手册', 4, '0,1', '4', NULL, NULL, NULL, NULL, '0');

/*!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 */;