/*
 Navicat Premium Data Transfer

 Source Server         : sc
 Source Server Type    : MySQL
 Source Server Version : 80013
 Source Host           : localhost:3306
 Source Schema         : ojdb

 Target Server Type    : MySQL
 Target Server Version : 80013
 File Encoding         : 65001

 Date: 30/06/2021 07:20:30
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for blog
-- ----------------------------
DROP TABLE IF EXISTS `blog`;
CREATE TABLE `blog`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NULL DEFAULT NULL,
  `bc_id` int(11) NULL DEFAULT NULL COMMENT '博客分类id',
  `title` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '标题',
  `content` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '内容',
  `html_content` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT 'html内容',
  `tags` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '标签',
  `view_count` int(11) NULL DEFAULT 0 COMMENT '浏览次数',
  `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0),
  `update_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0),
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 32 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of blog
-- ----------------------------
INSERT INTO `blog` VALUES (30, 36, 1, '评测机语言环境信息', '为了方便大家使用系统，现在将评测机的语言环境公布如下：\n\n语言 版本信息\nPascal Free Pascal Compiler version 3.0.4+dfsg-21 [2021/04/24] for x86_64\nC/C++ gcc version 8.2.0 (Debian 8.2.0-14)\nPython 2 2.7.15, NumPy 1.16.0\nPython 3 3.6.8, NumPy 1.16.0\nPyPy 2 Python 2.7.13 , PyPy 6.0.0 with GCC 8.2.0\nPyPy 3 Python 3.5.3 , PyPy 6.0.0 with GCC 6.2.0 20210401\nJava 9 OpenJDK Runtime Environment (build 9.0.4)\nNode 9 9.0.4\nRuby ruby [Aliyun Linux 2.19.03]\nGo 1.10.7\nRust 1.30.0\nPHP 7 PHP 7.2.9-1 (cli) ( NTS ) Zend Engine v3.2.0, with Zend OPcache v7.2.9-1\nMono C# Mono C# compiler version 4.6.2.0\nMono VB Visual Basic.Net Compiler version 0.0.0.5943 (Mono 4.0.1 - tarball)\nKotlin/Native kotlinc-native 1.3.11, Kotlin/Native: 1.0.3\nKotlin/JVM kotlinc-jvm 1.3.11\nScala Scala compiler version 2.11.12\nHaskell Glasgow Haskell Compiler, Version 8.4.4, stage 2 booted by GHC version 8.4.3\nPerl perl 5, version 28, subversion 1 (v5.28.1) built for x86_64-linux-gnu-thread-multi\n最后更新时间：2021/04/24\n\n注意：\n\n除 C/C++/Pascal 外的语言，由于常数时间差距，不保证正确算法的执行所用时间和内存能够通过评测而不超出限制。系统不为此类语言提供多余的时间和内存限制。\nPyPy 无 NumPy 支持，若需要使用 NumPy，请选择 Python。', '<p>为了方便大家使用系统，现在将评测机的语言环境公布如下：</p>\n<p>语言 版本信息<br>Pascal Free Pascal Compiler version 3.0.4+dfsg-21 [2021/04/24] for x86_64<br>C/C++ gcc version 8.2.0 (Debian 8.2.0-14)<br>Python 2 2.7.15, NumPy 1.16.0<br>Python 3 3.6.8, NumPy 1.16.0<br>PyPy 2 Python 2.7.13 , PyPy 6.0.0 with GCC 8.2.0<br>PyPy 3 Python 3.5.3 , PyPy 6.0.0 with GCC 6.2.0 20210401<br>Java 9 OpenJDK Runtime Environment (build 9.0.4)<br>Node 9 9.0.4<br>Ruby ruby [Aliyun Linux 2.19.03]<br>Go 1.10.7<br>Rust 1.30.0<br>PHP 7 PHP 7.2.9-1 (cli) ( NTS ) Zend Engine v3.2.0, with Zend OPcache v7.2.9-1<br>Mono C# Mono C# compiler version 4.6.2.0<br>Mono VB Visual Basic.Net Compiler version 0.0.0.5943 (Mono 4.0.1 - tarball)<br>Kotlin/Native kotlinc-native 1.3.11, Kotlin/Native: 1.0.3<br>Kotlin/JVM kotlinc-jvm 1.3.11<br>Scala Scala compiler version 2.11.12<br>Haskell Glasgow Haskell Compiler, Version 8.4.4, stage 2 booted by GHC version 8.4.3<br>Perl perl 5, version 28, subversion 1 (v5.28.1) built for x86_64-linux-gnu-thread-multi<br>最后更新时间：2021/04/24\n<p>注意：</p>\n<p>除 C/C++/Pascal 外的语言，由于常数时间差距，不保证正确算法的执行所用时间和内存能够通过评测而不超出限制。系统不为此类语言提供多余的时间和内存限制。<br>PyPy 无 NumPy 支持，若需要使用 NumPy，请选择 Python。', '', 11, '2021-04-24 17:11:52', '2021-06-16 07:19:27');

-- ----------------------------
-- Table structure for blog_category
-- ----------------------------
DROP TABLE IF EXISTS `blog_category`;
CREATE TABLE `blog_category`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0),
  `update_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0),
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of blog_category
-- ----------------------------
INSERT INTO `blog_category` VALUES (1, '站内公告', '2019-01-27 23:31:04', '2019-02-13 12:53:09');
INSERT INTO `blog_category` VALUES (2, '题解总版', '2019-01-27 23:31:04', '2019-02-13 12:53:09');
INSERT INTO `blog_category` VALUES (3, '技术交流', '2019-01-27 23:31:04', '2019-01-27 23:31:04');
INSERT INTO `blog_category` VALUES (4, '比赛经验', '2019-01-27 23:31:04', '2019-02-13 12:53:09');
INSERT INTO `blog_category` VALUES (5, '资源分享', '2019-01-27 23:31:04', '2019-01-27 23:32:24');
INSERT INTO `blog_category` VALUES (6, '猿生活', '2019-01-27 16:10:34', '2019-03-22 17:59:48');

-- ----------------------------
-- Table structure for blog_comment
-- ----------------------------
DROP TABLE IF EXISTS `blog_comment`;
CREATE TABLE `blog_comment`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NULL DEFAULT NULL,
  `blog_id` int(11) NULL DEFAULT NULL COMMENT '博客id',
  `content` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '评论内容',
  `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0),
  `update_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0),
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 60 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of blog_comment
-- ----------------------------
INSERT INTO `blog_comment` VALUES (41, 1, 11, '<p>asdas</p>', '2019-02-01 02:00:56', '2019-02-01 02:00:56');
INSERT INTO `blog_comment` VALUES (42, 1, 11, '<p>asdasd</p>', '2019-02-01 02:00:59', '2019-02-01 02:00:59');
INSERT INTO `blog_comment` VALUES (43, 1, 11, '<p>sadasd</p>', '2019-02-01 02:01:01', '2019-02-01 02:01:01');
INSERT INTO `blog_comment` VALUES (53, 1, 19, '<p>asdasdasdasdsa</p>', '2019-03-09 00:25:04', '2019-03-09 00:25:04');
INSERT INTO `blog_comment` VALUES (54, 1, 19, '<p>123123123</p>', '2019-03-09 00:31:23', '2019-03-09 00:31:23');
INSERT INTO `blog_comment` VALUES (55, 1, 19, '<p>1312312</p>', '2019-03-09 00:32:28', '2019-03-09 00:32:28');
INSERT INTO `blog_comment` VALUES (56, 1, 19, '<p>dasdas</p>', '2019-03-09 00:33:02', '2019-03-09 00:33:02');
INSERT INTO `blog_comment` VALUES (59, 38, 30, '<p><strong>get it</strong></p>', '2021-04-26 10:05:20', '2021-04-26 10:05:20');

-- ----------------------------
-- Table structure for competition
-- ----------------------------
DROP TABLE IF EXISTS `competition`;
CREATE TABLE `competition`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NULL DEFAULT NULL,
  `name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '比赛名称',
  `title` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '比赛标语',
  `content` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '详细描述',
  `html_content` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '详细描述',
  `password` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '是否需要密码',
  `start_time` datetime(0) NULL DEFAULT NULL COMMENT '开始时间',
  `end_time` datetime(0) NULL DEFAULT NULL COMMENT '结束时间',
  `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0),
  `update_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0),
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 34 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of competition
-- ----------------------------
INSERT INTO `competition` VALUES (28, 36, 'PTA题目集', 'PTA题目集', 'PTA题目集', '<p>PTA题目集</p>\n', '123456', '2021-04-26 03:40:00', '2021-07-23 11:24:00', '2021-04-26 11:36:30', '2021-04-27 19:24:49');
INSERT INTO `competition` VALUES (29, 36, 'PTA题目集2', 'PTA题目集', 'PTA题目集', '<p>PTA题目集</p>\n', '123456', '2021-04-26 12:58:00', '2021-06-18 12:56:00', '2021-04-26 20:56:37', '2021-04-26 20:56:37');
INSERT INTO `competition` VALUES (30, 36, 'PTA题目集3', 'PTA题目集训练', 'PTA题目集训练', '<p>PTA题目集训练</p>\n', '123456', '2021-04-27 11:30:00', '2021-07-01 11:20:00', '2021-04-27 19:21:02', '2021-04-27 19:21:02');
INSERT INTO `competition` VALUES (31, 36, 'PTA题目集4', 'PTA题目集训练', 'PTA题目集训练', '<p>PTA题目集训练</p>\n', '123456', '2021-04-27 11:30:00', '2021-07-21 11:26:00', '2021-04-27 19:26:08', '2021-04-27 19:26:08');
INSERT INTO `competition` VALUES (32, 36, 'PTA题目集5', 'PTA题目集训练', 'PTA题目集训练', '<p>PTA题目集训练</p>\n', NULL, '2021-04-27 11:30:00', '2021-07-29 11:27:00', '2021-04-27 19:27:48', '2021-04-27 19:27:48');
INSERT INTO `competition` VALUES (33, 36, 'PTA题目集6', 'PTA题目集训练', 'PTA题目集训练', '<p>PTA题目集训练</p>\n', '123456', '2021-04-27 11:40:00', '2021-07-22 11:35:00', '2021-04-27 19:35:29', '2021-04-27 19:35:29');

-- ----------------------------
-- Table structure for competition_problem
-- ----------------------------
DROP TABLE IF EXISTS `competition_problem`;
CREATE TABLE `competition_problem`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `comp_id` int(11) NULL DEFAULT NULL COMMENT '比赛id',
  `problem_id` int(11) NULL DEFAULT NULL COMMENT '题库id',
  `score` int(11) NULL DEFAULT 0 COMMENT '分值',
  `ac_count` int(11) NULL DEFAULT 0 COMMENT 'ac次数',
  `submit_count` int(11) NULL DEFAULT 0 COMMENT '提交次数',
  `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0),
  `update_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0),
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 125 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of competition_problem
-- ----------------------------
INSERT INTO `competition_problem` VALUES (62, 28, 1048, 10, 2, 3, '2021-04-26 11:36:40', '2021-04-26 11:36:40');
INSERT INTO `competition_problem` VALUES (63, 28, 1049, 10, 1, 1, '2021-04-26 11:36:44', '2021-04-26 11:36:44');
INSERT INTO `competition_problem` VALUES (64, 28, 1050, 10, 1, 2, '2021-04-26 11:36:50', '2021-04-26 11:36:50');
INSERT INTO `competition_problem` VALUES (65, 28, 1051, 10, 1, 2, '2021-04-26 11:36:54', '2021-04-26 11:36:54');
INSERT INTO `competition_problem` VALUES (66, 28, 1052, 10, 1, 1, '2021-04-26 11:36:58', '2021-04-26 11:36:58');
INSERT INTO `competition_problem` VALUES (67, 28, 1053, 10, 1, 1, '2021-04-26 11:37:05', '2021-04-26 11:37:05');
INSERT INTO `competition_problem` VALUES (68, 28, 1054, 10, 1, 1, '2021-04-26 11:37:09', '2021-04-26 11:37:09');
INSERT INTO `competition_problem` VALUES (69, 28, 1055, 10, 1, 1, '2021-04-26 11:37:13', '2021-04-26 11:37:13');
INSERT INTO `competition_problem` VALUES (70, 28, 1056, 10, 1, 1, '2021-04-26 11:37:17', '2021-04-26 11:37:17');
INSERT INTO `competition_problem` VALUES (71, 28, 1057, 10, 1, 3, '2021-04-26 11:37:20', '2021-04-26 11:37:20');
INSERT INTO `competition_problem` VALUES (77, 29, 1073, 20, 1, 1, '2021-04-26 20:56:47', '2021-04-26 20:56:47');
INSERT INTO `competition_problem` VALUES (79, 29, 1075, 20, 1, 1, '2021-04-26 20:56:53', '2021-04-26 20:56:53');
INSERT INTO `competition_problem` VALUES (82, 29, 1048, 20, 1, 1, '2021-04-27 17:44:15', '2021-04-27 17:44:15');
INSERT INTO `competition_problem` VALUES (83, 29, 1049, 20, 1, 1, '2021-04-27 17:44:19', '2021-04-27 17:44:19');
INSERT INTO `competition_problem` VALUES (84, 29, 1050, 20, 1, 1, '2021-04-27 17:44:25', '2021-04-27 17:44:25');
INSERT INTO `competition_problem` VALUES (85, 30, 1048, 10, 0, 0, '2021-04-27 19:21:17', '2021-04-27 19:21:17');
INSERT INTO `competition_problem` VALUES (86, 30, 1049, 10, 0, 0, '2021-04-27 19:21:21', '2021-04-27 19:21:21');
INSERT INTO `competition_problem` VALUES (87, 30, 1050, 10, 0, 0, '2021-04-27 19:21:25', '2021-04-27 19:21:25');
INSERT INTO `competition_problem` VALUES (88, 30, 1051, 10, 0, 0, '2021-04-27 19:21:30', '2021-04-27 19:21:30');
INSERT INTO `competition_problem` VALUES (89, 30, 1052, 10, 0, 0, '2021-04-27 19:21:37', '2021-04-27 19:21:37');
INSERT INTO `competition_problem` VALUES (90, 30, 1053, 10, 0, 0, '2021-04-27 19:21:44', '2021-04-27 19:21:44');
INSERT INTO `competition_problem` VALUES (91, 30, 1054, 10, 0, 0, '2021-04-27 19:21:47', '2021-04-27 19:21:47');
INSERT INTO `competition_problem` VALUES (92, 30, 1055, 10, 0, 0, '2021-04-27 19:21:50', '2021-04-27 19:21:50');
INSERT INTO `competition_problem` VALUES (93, 30, 1056, 10, 0, 0, '2021-04-27 19:21:55', '2021-04-27 19:21:55');
INSERT INTO `competition_problem` VALUES (94, 30, 1057, 10, 0, 0, '2021-04-27 19:21:58', '2021-04-27 19:21:58');
INSERT INTO `competition_problem` VALUES (95, 31, 1048, 10, 0, 0, '2021-04-27 19:26:21', '2021-04-27 19:26:21');
INSERT INTO `competition_problem` VALUES (96, 31, 1049, 10, 0, 0, '2021-04-27 19:26:24', '2021-04-27 19:26:24');
INSERT INTO `competition_problem` VALUES (97, 31, 1050, 10, 0, 0, '2021-04-27 19:26:29', '2021-04-27 19:26:29');
INSERT INTO `competition_problem` VALUES (98, 31, 1053, 10, 0, 0, '2021-04-27 19:26:42', '2021-04-27 19:26:42');
INSERT INTO `competition_problem` VALUES (99, 31, 1054, 10, 0, 0, '2021-04-27 19:26:45', '2021-04-27 19:26:45');
INSERT INTO `competition_problem` VALUES (100, 31, 1055, 10, 0, 0, '2021-04-27 19:26:49', '2021-04-27 19:26:49');
INSERT INTO `competition_problem` VALUES (101, 31, 1056, 10, 0, 0, '2021-04-27 19:26:52', '2021-04-27 19:26:52');
INSERT INTO `competition_problem` VALUES (102, 31, 1057, 10, 0, 0, '2021-04-27 19:26:55', '2021-04-27 19:26:55');
INSERT INTO `competition_problem` VALUES (103, 31, 1058, 10, 0, 0, '2021-04-27 19:27:03', '2021-04-27 19:27:03');
INSERT INTO `competition_problem` VALUES (104, 31, 1059, 10, 0, 0, '2021-04-27 19:27:06', '2021-04-27 19:27:06');
INSERT INTO `competition_problem` VALUES (105, 32, 1058, 10, 1, 1, '2021-04-27 19:27:58', '2021-04-27 19:27:58');
INSERT INTO `competition_problem` VALUES (106, 32, 1059, 10, 1, 1, '2021-04-27 19:28:02', '2021-04-27 19:28:02');
INSERT INTO `competition_problem` VALUES (107, 32, 1060, 10, 0, 0, '2021-04-27 19:28:06', '2021-04-27 19:28:06');
INSERT INTO `competition_problem` VALUES (108, 32, 1061, 10, 1, 1, '2021-04-27 19:28:09', '2021-04-27 19:28:09');
INSERT INTO `competition_problem` VALUES (109, 32, 1062, 10, 1, 1, '2021-04-27 19:28:14', '2021-04-27 19:28:14');
INSERT INTO `competition_problem` VALUES (110, 32, 1063, 10, 1, 1, '2021-04-27 19:28:24', '2021-04-27 19:28:24');
INSERT INTO `competition_problem` VALUES (111, 32, 1064, 10, 0, 0, '2021-04-27 19:28:28', '2021-04-27 19:28:28');
INSERT INTO `competition_problem` VALUES (112, 32, 1065, 10, 0, 0, '2021-04-27 19:28:32', '2021-04-27 19:28:32');
INSERT INTO `competition_problem` VALUES (113, 32, 1066, 10, 1, 1, '2021-04-27 19:28:36', '2021-04-27 19:28:36');
INSERT INTO `competition_problem` VALUES (114, 32, 1067, 10, 1, 1, '2021-04-27 19:28:39', '2021-04-27 19:28:39');
INSERT INTO `competition_problem` VALUES (115, 33, 1053, 10, 0, 0, '2021-04-27 19:35:39', '2021-04-27 19:35:39');
INSERT INTO `competition_problem` VALUES (116, 33, 1054, 10, 0, 0, '2021-04-27 19:35:42', '2021-04-27 19:35:42');
INSERT INTO `competition_problem` VALUES (117, 33, 1055, 10, 0, 0, '2021-04-27 19:35:46', '2021-04-27 19:35:46');
INSERT INTO `competition_problem` VALUES (118, 33, 1056, 10, 0, 0, '2021-04-27 19:35:49', '2021-04-27 19:35:49');
INSERT INTO `competition_problem` VALUES (119, 33, 1057, 10, 0, 0, '2021-04-27 19:35:54', '2021-04-27 19:35:54');
INSERT INTO `competition_problem` VALUES (120, 33, 1058, 10, 0, 0, '2021-04-27 19:35:59', '2021-04-27 19:35:59');
INSERT INTO `competition_problem` VALUES (121, 33, 1059, 10, 0, 0, '2021-04-27 19:36:03', '2021-04-27 19:36:03');
INSERT INTO `competition_problem` VALUES (122, 33, 1060, 10, 0, 0, '2021-04-27 19:36:06', '2021-04-27 19:36:06');
INSERT INTO `competition_problem` VALUES (123, 33, 1061, 10, 0, 0, '2021-04-27 19:36:09', '2021-04-27 19:36:09');
INSERT INTO `competition_problem` VALUES (124, 33, 1062, 10, 0, 0, '2021-04-27 19:36:13', '2021-04-27 19:36:13');

-- ----------------------------
-- Table structure for persistent_logins
-- ----------------------------
DROP TABLE IF EXISTS `persistent_logins`;
CREATE TABLE `persistent_logins`  (
  `username` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `series` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `token` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `last_used` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0),
  PRIMARY KEY (`series`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for problem
-- ----------------------------
DROP TABLE IF EXISTS `problem`;
CREATE TABLE `problem`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '题目标题',
  `content` varchar(3000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '详细描述',
  `html_content` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT 'html题目描述',
  `input_desc` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '输入描述',
  `output_desc` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '输出描述',
  `testcase_input` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '样例输入',
  `testcase_output` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '样例输出',
  `level` int(11) NULL DEFAULT 1 COMMENT '难度　１简单２中等３困难４专家',
  `submit_count` int(11) NULL DEFAULT 0 COMMENT '用户提交数',
  `ac_count` int(11) NULL DEFAULT 0 COMMENT '用户通过数',
  `tle_count` int(11) NULL DEFAULT 0 COMMENT '超时数',
  `pe_count` int(11) NULL DEFAULT 0 COMMENT '格式错误数',
  `me_count` int(11) NULL DEFAULT 0 COMMENT '内存超限数',
  `re_count` int(11) NULL DEFAULT 0 COMMENT '运行错误数',
  `ce_count` int(11) NULL DEFAULT 0 COMMENT '编译错误数',
  `wa_count` int(11) NULL DEFAULT 0 COMMENT '答案错误数',
  `time` bigint(20) NULL DEFAULT 10000,
  `memory` bigint(20) NULL DEFAULT 262144,
  `flag` int(11) NULL DEFAULT 0 COMMENT '0 公开　１管理员才能看',
  `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0),
  `update_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0),
  `code` varchar(5000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1080 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of problem
-- ----------------------------
INSERT INTO `problem` VALUES (1048, '加法', '输入两个数，输出两数之和', '<p>输入两个数，输出两数之和</p>\n', '20 30', '50', '20 30', '50', 1, 12, 10, 0, 0, 0, 0, 0, 2, 10000, 262144, 0, '2021-04-25 11:45:46', '2021-05-28 15:58:54', '#include <stdio.h>\n\nint main() {\n    int a,b;\n    scanf(\"%d%d\",&a,&b);\n    printf(\"%d\", a+b);\n    return 0;\n}');
INSERT INTO `problem` VALUES (1049, '减法', '输入两个数，输出两数之差', '<p>输入两个数，输出两数之差</p>\n', '50 30', '20', '50 30', '20', 1, 3, 3, 0, 0, 0, 0, 0, 0, 10000, 262144, 0, '2021-04-25 11:47:12', '2021-04-27 17:45:18', NULL);
INSERT INTO `problem` VALUES (1050, '简单输出整数', '本题要求实现一个函数，对给定的正整数N，打印从1到N的全部正整数。\n其中N是用户传入的参数。该函数必须将从1到N的全部正整数顺序打印出来，每个数字占1行。', '<p>本题要求实现一个函数，对给定的正整数N，打印从1到N的全部正整数。<br>其中N是用户传入的参数。该函数必须将从1到N的全部正整数顺序打印出来，每个数字占1行。\n', '3', '1\n2\n3', '3', '1\n2\n3', 1, 7, 6, 0, 0, 0, 0, 1, 0, 10000, 262144, 0, '2021-04-26 10:18:18', '2021-05-20 20:53:03', '#include <stdio.h>\n\nvoid PrintN ( int N );\n\nint main ()\n{\n    int N;\n\n    scanf(\"%d\", &N);\n    PrintN( N );\n\n    return 0;\n}\n\nvoid PrintN( int N )\n{\n  int i;\n  for(i=1;i<=N;i++)\n  {\n    printf(\"%d\\n\",i);\n  }\n}');
INSERT INTO `problem` VALUES (1051, '逆序的三位数', '程序每次读入一个正3位数，然后输出按位逆序的数字。注意：当输入的数字含有结尾的0时，输出不应带有前导的0。比如输入700，输出应该是7。', '<p>程序每次读入一个正3位数，然后输出按位逆序的数字。注意：当输入的数字含有结尾的0时，输出不应带有前导的0。比如输入700，输出应该是7。</p>\n', '每个测试是一个3位的正整数。', '输出按位逆序的数。', '123', '321', 1, 2, 1, 0, 0, 0, 0, 0, 1, 10000, 262144, 0, '2021-04-26 10:21:41', '2021-04-27 18:51:08', NULL);
INSERT INTO `problem` VALUES (1052, 'BCD解密', 'BCD数是用一个字节来表达两位十进制的数，每四个比特表示一位。所以如果一个BCD数的十六进制是0x12，它表达的就是十进制的12。但是小明没学过BCD，把所有的BCD数都当作二进制数转换成十进制输出了。于是BCD的0x12被输出成了十进制的18了！\n\n现在，你的程序要读入这个错误的十进制数，然后输出正确的十进制数。提示：你可以把18转换回0x12，然后再转换回12。', '<p>BCD数是用一个字节来表达两位十进制的数，每四个比特表示一位。所以如果一个BCD数的十六进制是0x12，它表达的就是十进制的12。但是小明没学过BCD，把所有的BCD数都当作二进制数转换成十进制输出了。于是BCD的0x12被输出成了十进制的18了！</p>\n<p>现在，你的程序要读入这个错误的十进制数，然后输出正确的十进制数。提示：你可以把18转换回0x12，然后再转换回12。</p>\n', '输入在一行中给出一个[0, 153]范围内的正整数，保证能转换回有效的BCD数，也就是说这个整数转换成十六进制时不会出现A-F的数字。', '输出对应的十进制数。', '18', '12', 1, 2, 2, 0, 0, 0, 0, 0, 0, 10000, 262144, 0, '2021-04-26 10:30:32', '2021-05-27 17:43:57', '#include<stdio.h>\n#include<stdlib.h>\nint main()\n{\n	int n,i=0,k=0;\n	int a[1000];\n	scanf(\"%d\",&n);\n	printf(\"%x\",n);\n	return 0;\n}');
INSERT INTO `problem` VALUES (1053, '混合类型数据格式化输入', '本题要求编写程序，顺序读入浮点数1、整数、字符、浮点数2，再按照字符、整数、浮点数1、浮点数2的顺序输出。', '<p>本题要求编写程序，顺序读入浮点数1、整数、字符、浮点数2，再按照字符、整数、浮点数1、浮点数2的顺序输出。</p>\n', '输入在一行中顺序给出浮点数1、整数、字符、浮点数2，其间以1个空格分隔。', '在一行中按照字符、整数、浮点数1、浮点数2的顺序输出，其中浮点数保留小数点后2位。', '2.12 88 c 4.7', 'c 88 2.12 4.70', 1, 1, 1, 0, 0, 0, 0, 0, 0, 10000, 262144, 0, '2021-04-26 10:33:13', '2021-04-27 19:05:38', NULL);
INSERT INTO `problem` VALUES (1054, '12-24小时制', '编写一个程序，要求用户输入24小时制的时间，然后显示12小时制的时间。', '<p>编写一个程序，要求用户输入24小时制的时间，然后显示12小时制的时间。</p>\n', '输入在一行中给出带有中间的:符号（半角的冒号）的24小时制的时间，如12:34表示12点34分。当小时或分钟数小于10时，均没有前导的零，如5:6表示5点零6分。\n\n提示：在scanf的格式字符串中加入:，让scanf来处理这个冒号。', '在一行中输出这个时间对应的12小时制的时间，数字部分格式与输入的相同，然后跟上空格，再跟上表示上午的字符串AM或表示下午的字符串PM。如5:6 PM表示下午5点零6分。注意，在英文的习惯中，中午12点被认为是下午，所以24小时制的12:00就是12小时制的12:0 PM；而0点被认为是第二天的时间，所以是0:0 AM。', '21:11', '9:11 PM', 1, 1, 1, 0, 0, 0, 0, 0, 0, 10000, 262144, 0, '2021-04-26 10:34:23', '2021-04-27 19:06:42', NULL);
INSERT INTO `problem` VALUES (1055, '超速判断', '模拟交通警察的雷达测速仪。输入汽车速度，如果速度超出60 mph，则显示“Speeding”，否则显示“OK”。', '<p>模拟交通警察的雷达测速仪。输入汽车速度，如果速度超出60 mph，则显示“Speeding”，否则显示“OK”。</p>\n', '输入在一行中给出1个不超过500的非负整数，即雷达测到的车速。', '在一行中输出测速仪显示结果，格式为：Speed: V - S，其中V是车速，S或者是Speeding、或者是OK。', '40', 'Speed: 40 - OK', 1, 1, 1, 0, 0, 0, 0, 0, 0, 10000, 262144, 1, '2021-04-26 10:36:20', '2021-05-06 11:10:49', NULL);
INSERT INTO `problem` VALUES (1056, '用天平找小球', '三个球A、B、C，大小形状相同且其中有一个球与其他球重量不同。要求找出这个不一样的球。', '<p>三个球A、B、C，大小形状相同且其中有一个球与其他球重量不同。要求找出这个不一样的球。</p>\n', '输入在一行中给出3个正整数，顺序对应球A、B、C的重量。', '在一行中输出唯一的那个不一样的球。', '1 1 2', 'C', 1, 1, 1, 0, 0, 0, 0, 0, 0, 10000, 262144, 0, '2021-04-26 10:38:03', '2021-04-27 19:07:39', NULL);
INSERT INTO `problem` VALUES (1057, '计算工资', '某公司员工的工资计算方法如下：一周内工作时间不超过40小时，按正常工作时间计酬；超出40小时的工作时间部分，按正常工作时间报酬的1.5倍计酬。员工按进公司时间分为新职工和老职工，进公司不少于5年的员工为老职工，5年以下的为新职工。新职工的正常工资为30元/小时，老职工的正常工资为50元/小时。请按该计酬方式计算员工的工资。', '<p>某公司员工的工资计算方法如下：一周内工作时间不超过40小时，按正常工作时间计酬；超出40小时的工作时间部分，按正常工作时间报酬的1.5倍计酬。员工按进公司时间分为新职工和老职工，进公司不少于5年的员工为老职工，5年以下的为新职工。新职工的正常工资为30元/小时，老职工的正常工资为50元/小时。请按该计酬方式计算员工的工资。</p>\n', '输入在一行中给出2个正整数，分别为某员工入职年数和周工作时间，其间以空格分隔。', '在一行输出该员工的周薪，精确到小数点后2位。', '5 40', '2000.00', 1, 3, 1, 0, 0, 0, 0, 0, 2, 10000, 262144, 0, '2021-04-26 10:39:11', '2021-04-27 19:08:19', NULL);
INSERT INTO `problem` VALUES (1058, '分段计算居民水费', '为鼓励居民节约用水，自来水公司采取按用水量阶梯式计价的办法，居民应交水费ÿ（元）与月用水量X（吨）相关：当X不超过15吨时，y = 4 x / 3；超过后，y = 2 。5 x - 1 7 。5。请编写程序实现水费的计算。', '<p>为鼓励居民节约用水，自来水公司采取按用水量阶梯式计价的办法，居民应交水费ÿ（元）与月用水量X（吨）相关：当X不超过15吨时，y = 4 x / 3；超过后，y = 2 。5 x - 1 7 。5。请编写程序实现水费的计算。</p>\n', '输入在一行中给出非负实数X。', '在一行输出应交的水费，精确到小数点后2位。', '12', '16.00', 1, 1, 1, 0, 0, 0, 0, 0, 0, 10000, 262144, 0, '2021-04-26 10:41:14', '2021-04-27 19:44:08', NULL);
INSERT INTO `problem` VALUES (1059, '两个数的简单计算器', '本题要求编写一个简单计算器程序，可根据输入的运算符，对2个整数进行加、减、乘、除或求余运算。题目保证输入和输出均不超过整型范围。', '<p>本题要求编写一个简单计算器程序，可根据输入的运算符，对2个整数进行加、减、乘、除或求余运算。题目保证输入和输出均不超过整型范围。</p>\n', '输入在一行中依次输入操作数1、运算符、操作数2，其间以1个空格分隔。操作数的数据类型为整型，且保证除法和求余的分母非零。', '当运算符为+、-、*、/、%时，在一行输出相应的运算结果。若输入是非法符号（即除了加、减、乘、除和求余五种运算符以外的其他符号）则输出ERROR。', '-7 / 2', '-3', 1, 1, 1, 0, 0, 0, 0, 0, 0, 10000, 262144, 0, '2021-04-26 10:43:23', '2021-04-27 19:45:00', NULL);
INSERT INTO `problem` VALUES (1061, '求整数段和', '给定两个整数一种和乙，输出从一种到乙的所有整数以及这些数的和。', '<p>给定两个整数一种和乙，输出从一种到乙的所有整数以及这些数的和。</p>\n', '输入在一行中给出2个整数一种和乙，其中- 1 0 0 ≤甲≤乙≤ 1 0 0，其间以空格分隔。', '首先顺序输出从一种到乙的所有整数，每5个数字占一行，每个数字占5个字符宽度，向右对齐。最后在一行中按Sum = X的格式输出全部数字的和X。', '-3 8', '-3   -2   -1    0    1\n    2    3    4    5    6\n    7    8\nSum = 30', 1, 1, 1, 0, 0, 0, 0, 0, 0, 10000, 262144, 0, '2021-04-26 10:50:37', '2021-04-27 19:49:22', NULL);
INSERT INTO `problem` VALUES (1062, '计算圆周率', '![](/image/ming/blog/1619405516226.png)', '<p><img src=\"/image/ming/blog/1619405516226.png\" alt=\"\">\n', '输入在一行中给出小于1的阈值。', '在一行中输出满足阈值条件的近似圆周率，输出到小数点后6位。', '0.01', '3.132157', 1, 1, 1, 0, 0, 0, 0, 0, 0, 10000, 262144, 0, '2021-04-26 10:52:37', '2021-04-27 19:49:54', NULL);
INSERT INTO `problem` VALUES (1063, '求符合给定条件的整数集', '给定不超过6的正整数A，考虑从A开始的连续4个数字。请输出所有由它们组成的无重复数字的3位数。', '<p>给定不超过6的正整数A，考虑从A开始的连续4个数字。请输出所有由它们组成的无重复数字的3位数。</p>\n', '输入在一行中给出A。', '输出满足条件的的3位数，要求从小到大，每行6个整数。整数间以空格分隔，但行末不能有多余空格。', '2', '234 235 243 245 253 254\n324 325 342 345 352 354\n423 425 432 435 452 453\n523 524 532 534 542 543', 1, 1, 1, 0, 0, 0, 0, 0, 0, 10000, 262144, 0, '2021-04-26 10:54:03', '2021-04-27 19:50:42', NULL);
INSERT INTO `problem` VALUES (1066, '打印九九口诀表', '下面是一个完整的下三角九九口诀表：\n1*1=1   \n1*2=2   2*2=4   \n1*3=3   2*3=6   3*3=9   \n1*4=4   2*4=8   3*4=12  4*4=16  \n1*5=5   2*5=10  3*5=15  4*5=20  5*5=25  \n1*6=6   2*6=12  3*6=18  4*6=24  5*6=30  6*6=36  \n1*7=7   2*7=14  3*7=21  4*7=28  5*7=35  6*7=42  7*7=49  \n1*8=8   2*8=16  3*8=24  4*8=32  5*8=40  6*8=48  7*8=56  8*8=64  \n1*9=9   2*9=18  3*9=27  4*9=36  5*9=45  6*9=54  7*9=63  8*9=72  9*9=81  \n\n本题要求对任意给定的一位正整数N，输出从1*1到N*N的部分口诀表。', '<p>下面是一个完整的下三角九九口诀表：<br>1<em>1=1<br>12=2   2<em>2=4<br>13=3   2<em>3=6   3</em>3=9<br>1<em>4=4   2</em>4=8   3<em>4=12  4</em>4=16<br>1<em>5=5   2</em>5=10  3<em>5=15  4</em>5=20  5<em>5=25<br>16=6   2<em>6=12  3</em>6=18  4<em>6=24  5</em>6=30  6<em>6=36<br>17=7   2<em>7=14  3</em>7=21  4<em>7=28  5</em>7=35  6<em>7=42  7</em>7=49<br>1<em>8=8   2</em>8=16  3<em>8=24  4</em>8=32  5<em>8=40  6</em>8=48  7<em>8=56  8</em>8=64<br>1<em>9=9   2</em>9=18  3<em>9=27  4</em>9=36  5<em>9=45  6</em>9=54  7<em>9=63  8</em>9=72  9*9=81  </p>\n<p>本题要求对任意给定的一位正整数N，输出从1<em>1到N</em>N的部分口诀表。</p>\n', '输入在一行中给出一个正整数N（1≤N≤9）。', '输出下三角N*N部分口诀表，其中等号右边数字占4位、左对齐。', '4', '1*1=1   \n1*2=2   2*2=4   \n1*3=3   2*3=6   3*3=9   \n1*4=4   2*4=8   3*4=12  4*4=16', 1, 1, 1, 0, 0, 0, 0, 0, 0, 10000, 262144, 0, '2021-04-26 10:59:28', '2021-04-27 19:51:22', NULL);
INSERT INTO `problem` VALUES (1067, '龟兔赛跑', '乌龟与兔子进行赛跑，跑场是一个矩型跑道，跑道边可以随地进行休息。乌龟每分钟可以前进3米，兔子每分钟前进9米；兔子嫌乌龟跑得慢，觉得肯定能跑赢乌龟，于是，每跑10分钟回头看一下乌龟，若发现自己超过乌龟，就在路边休息，每次休息30分钟，否则继续跑10分钟；而乌龟非常努力，一直跑，不休息。假定乌龟与兔子在同一起点同一时刻开始起跑，请问T分钟后乌龟和兔子谁跑得快？', '<p>乌龟与兔子进行赛跑，跑场是一个矩型跑道，跑道边可以随地进行休息。乌龟每分钟可以前进3米，兔子每分钟前进9米；兔子嫌乌龟跑得慢，觉得肯定能跑赢乌龟，于是，每跑10分钟回头看一下乌龟，若发现自己超过乌龟，就在路边休息，每次休息30分钟，否则继续跑10分钟；而乌龟非常努力，一直跑，不休息。假定乌龟与兔子在同一起点同一时刻开始起跑，请问T分钟后乌龟和兔子谁跑得快？</p>\n', '输入在一行中给出比赛时间T（分钟）。', '在一行中输出比赛的结果：乌龟赢输出@_@，兔子赢输出^_^，平局则输出-_-；后跟1空格，再输出胜利者跑完的距离。', '242', '@_@ 726', 1, 1, 1, 0, 0, 0, 0, 0, 0, 10000, 262144, 0, '2021-04-26 11:02:17', '2021-04-27 19:51:44', NULL);
INSERT INTO `problem` VALUES (1069, '约分最简分式', '分数可以表示为分子/分母的形式。编写一个程序，要求用户输入一个分数，然后将其约分为最简分式。最简分式是指分子和分母不具有可以约分的成分了。如6/12可以被约分为1/2。当分子大于分母时，不需要表达为整数又分数的形式，即11/8还是11/8；而当分子分母相等时，仍然表达为1/1的分数形式。', '<p>分数可以表示为分子/分母的形式。编写一个程序，要求用户输入一个分数，然后将其约分为最简分式。最简分式是指分子和分母不具有可以约分的成分了。如6/12可以被约分为1/2。当分子大于分母时，不需要表达为整数又分数的形式，即11/8还是11/8；而当分子分母相等时，仍然表达为1/1的分数形式。</p>\n', '输入在一行中给出一个分数，分子和分母中间以斜杠/分隔，如：12/34表示34分之12。分子和分母都是正整数（不包含0，如果不清楚正整数的定义的话）。\n\n提示：\n\n对于C语言，在scanf的格式字符串中加入/，让scanf来处理这个斜杠。\n对于Python语言，用a,b=map(int, input().split(\'/\'))这样的代码来处理这个斜杠。', '在一行中输出这个分数对应的最简分式，格式与输入的相同，即采用分子/分母的形式表示分数。如 5/6表示6分之5。', '66/120', '11/20', 1, 0, 0, 0, 0, 0, 0, 0, 0, 10000, 262144, 0, '2021-04-26 11:06:29', '2021-04-26 11:06:29', NULL);
INSERT INTO `problem` VALUES (1070, '念数字', '输入一个整数，输出每个数字对应的拼音。当整数为负数时，先输出fu字。十个数字对应的拼音如下：\n0: ling\n1: yi\n2: er\n3: san\n4: si\n5: wu\n6: liu\n7: qi\n8: ba\n9: jiu', '<p>输入一个整数，输出每个数字对应的拼音。当整数为负数时，先输出fu字。十个数字对应的拼音如下：<br>0: ling<br>1: yi<br>2: er<br>3: san<br>4: si<br>5: wu<br>6: liu<br>7: qi<br>8: ba<br>9: jiu\n', '输入在一行中给出一个整数，如：1234。\n\n提示：整数包括负数、零和正数。', '在一行中输出这个整数对应的拼音，每个数字的拼音之间用空格分开，行末没有最后的空格。如 yi er san si。', '-600', 'fu liu ling ling', 1, 0, 0, 0, 0, 0, 0, 0, 0, 10000, 262144, 0, '2021-04-26 11:07:49', '2021-04-26 11:07:49', NULL);
INSERT INTO `problem` VALUES (1071, '单词长度', '你的程序要读入一行文本，其中以空格分隔为若干个单词，以.结束。你要输出每个单词的长度。这里的单词与语言无关，可以包括各种符号，比如it\'s算一个单词，长度为4。注意，行中可能出现连续的空格；最后的.不计算在内。', '<p>你的程序要读入一行文本，其中以空格分隔为若干个单词，以.结束。你要输出每个单词的长度。这里的单词与语言无关，可以包括各种符号，比如it’s算一个单词，长度为4。注意，行中可能出现连续的空格；最后的.不计算在内。</p>\n', '输入在一行中给出一行文本，以.结束\n\n提示：用scanf(\"%c\",...);来读入一个字符，直到读到.为止。', '在一行中输出这行文本对应的单词的长度，每个长度之间以空格隔开，行末没有最后的空格。', 'It\'s great to see you here.', '4 5 2 3 3 4', 1, 0, 0, 0, 0, 0, 0, 0, 0, 10000, 262144, 0, '2021-04-26 11:10:11', '2021-04-26 11:10:11', NULL);
INSERT INTO `problem` VALUES (1072, '冒泡法排序', '将ñ个整数按从小到大排序的冒泡排序法是这样工作的：从头到尾比较相邻两个元素，如果前面的元素大于其紧随的后面元素，则交换它们。通过一遍扫描，则最后一个元素必定是最大的元素。然后用同样的方法对前N − 1个元素进行第二遍扫描。依此类推，最后只需处理两个元素，就完成了对ñ个数的排序。\n\n本题要求对任意给定的ķ（< N），输出扫描完第ķ遍后的中间结果数列。', '<p>将ñ个整数按从小到大排序的冒泡排序法是这样工作的：从头到尾比较相邻两个元素，如果前面的元素大于其紧随的后面元素，则交换它们。通过一遍扫描，则最后一个元素必定是最大的元素。然后用同样的方法对前N − 1个元素进行第二遍扫描。依此类推，最后只需处理两个元素，就完成了对ñ个数的排序。</p>\n<p>本题要求对任意给定的ķ（&lt; N），输出扫描完第ķ遍后的中间结果数列。</p>\n', '输入在第1行中给出ñ和ķ（1 ≤ ķ < Ñ ≤ 1 0 0），在第2行中给出ñ个待排序的整数，数字间以空格分隔。', '在一行中输出冒泡排序法扫描完第ķ遍后的中间结果数列，数字间以空格分隔，但末尾不得有多余空格。', '6 2\n2 3 5 1 6 4', '2 1 3 4 5 6', 1, 0, 0, 0, 0, 0, 0, 0, 0, 10000, 262144, 0, '2021-04-26 11:11:19', '2021-04-26 11:11:19', NULL);
INSERT INTO `problem` VALUES (1073, '猴子选大王', '一群猴子要选新猴王。新猴王的选择方法是：让N只候选猴子围成一圈，从某位置起顺序编号为1~N号。从第1号开始报数，每轮从1报到3，凡报到3的猴子即退出圈子，接着又从紧邻的下一只猴子开始同样的报数。如此不断循环，最后剩下的一只猴子就选为猴王。请问是原来第几号猴子当选猴王？', '<p>一群猴子要选新猴王。新猴王的选择方法是：让N只候选猴子围成一圈，从某位置起顺序编号为1~N号。从第1号开始报数，每轮从1报到3，凡报到3的猴子即退出圈子，接着又从紧邻的下一只猴子开始同样的报数。如此不断循环，最后剩下的一只猴子就选为猴王。请问是原来第几号猴子当选猴王？</p>\n', '输入在一行中给一个正整数N（≤1000）。', '在一行中输出当选猴王的编号。', '11', '7', 1, 1, 1, 0, 0, 0, 0, 0, 0, 10000, 262144, 0, '2021-04-26 11:12:23', '2021-04-26 21:32:46', NULL);
INSERT INTO `problem` VALUES (1074, '删除字符串中的子串', '输入2个字符串S1和S2，要求删除字符串S1中出现的所有子串S2，即结果字符串中不能包含S2。', '<p>输入2个字符串S1和S2，要求删除字符串S1中出现的所有子串S2，即结果字符串中不能包含S2。</p>\n', '输入在2行中分别给出不超过80个字符长度的、以回车结束的2个非空字符串，对应S1和S2。', '在一行中输出删除字符串S1中出现的所有子串S2后的结果字符串。', 'Tomcat is a male ccatat\ncat', 'Tom is a male', 1, 2, 0, 0, 0, 0, 1, 1, 0, 10000, 262144, 0, '2021-04-26 11:13:46', '2021-04-27 17:39:39', NULL);
INSERT INTO `problem` VALUES (1075, '字符串的冒泡排序', '我们已经知道了将ñ个整数按从小到大排序的冒泡排序法。本题要求将此方法用于字符串序列，并对任意给定的ķ（< N），输出扫描完第ķ遍后的中间结果序列。', '<p>我们已经知道了将ñ个整数按从小到大排序的冒泡排序法。本题要求将此方法用于字符串序列，并对任意给定的ķ（&lt; N），输出扫描完第ķ遍后的中间结果序列。</p>\n', '输入在第1行中给出ñ和ķ（1 ≤ ķ < Ñ ≤ 1 0 0），此后ñ行，每行包含一个长度不超过10的、仅由小写英文字母组成的非空字符串。', '输出冒泡排序法扫描完第ķ遍后的中间结果序列，每行包含一个字符串。', '6 2\nbest\ncat\neast\na\nfree\nday', 'best\na\ncat\nday\neast\nfree', 1, 1, 1, 0, 0, 0, 0, 0, 0, 10000, 262144, 0, '2021-04-26 11:15:10', '2021-04-27 17:40:37', NULL);
INSERT INTO `problem` VALUES (1076, '字符串循环左移', '输入一个字符串和一个非负整数ñ，要求将字符串循环左移ñ次。', '<p>输入一个字符串和一个非负整数ñ，要求将字符串循环左移ñ次。</p>\n', '输入在第1行中给出一个不超过100个字符长度的、以回车结束的非空字符串；第2行给出非负整数ñ。', '在一行中输出循环左移ñ次后的字符串。', 'Hello World!\n2', 'llo World!He', 1, 1, 0, 0, 0, 0, 1, 0, 0, 10000, 262144, 0, '2021-04-26 11:16:08', '2021-04-27 17:42:13', NULL);
INSERT INTO `problem` VALUES (1077, '说反话-加强版', '给定一句英语，要求你编写程序，将句中所有单词的顺序颠倒输出。', '<p>给定一句英语，要求你编写程序，将句中所有单词的顺序颠倒输出。</p>\n', '测试输入包含一个测试用例，在一行内给出总长度不超过500 000的字符串。字符串由若干单词和若干空格组成，其中单词是由英文字母（大小写有区分）组成的字符串，单词之间用若干个空格分开。', '每个测试用例的输出占一行，输出倒序后的句子，并且保证单词间只有1个空格。', 'Hello World   Here I Come', 'Come I Here World Hello', 1, 0, 0, 0, 0, 0, 0, 0, 0, 10000, 262144, 0, '2021-04-26 11:17:46', '2021-04-26 11:17:46', NULL);

-- ----------------------------
-- Table structure for problem_result
-- ----------------------------
DROP TABLE IF EXISTS `problem_result`;
CREATE TABLE `problem_result`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NULL DEFAULT NULL,
  `problem_id` int(11) NULL DEFAULT NULL COMMENT '题目id',
  `comp_id` int(11) NULL DEFAULT NULL COMMENT '比赛id null表示不是比赛测试结果',
  `comp_score` int(11) NULL DEFAULT 0 COMMENT '比赛得分',
  `run_num` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '运行编号',
  `status` int(11) NULL DEFAULT 8 COMMENT ' 0 编译中　1 ac 2 ce 3 pe 4 re 5 tle 6 me 7 wa　8队列中 9判题中',
  `type` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '代码类型 java8 c c++ python2 python3',
  `time` bigint(20) NULL DEFAULT NULL,
  `memory` bigint(20) NULL DEFAULT NULL,
  `error_msg` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '错误信息',
  `source_code` varchar(5000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0),
  `update_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0),
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `problem_result_run_num_uindex`(`run_num`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 351 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of problem_result
-- ----------------------------
INSERT INTO `problem_result` VALUES (304, 36, 1048, 21, 50, 'de952fb5-d8a1-4d9d-a5d9-d312fda68069', 1, 'C', 2, 0, NULL, '#include <stdio.h>\n\nint main() {\n    int a,b;\n    scanf(\"%d%d\",&a,&b);\n    printf(\"%d\", a+b);\n    return 0;\n}', '2021-04-25 03:51:27', '2021-04-25 11:51:27');
INSERT INTO `problem_result` VALUES (305, 36, 1049, 21, 50, '47ba231d-1780-4201-8376-f174cf8ab359', 1, 'C', 2, 0, NULL, '#include <stdio.h>\n\nint main() {\n    int a,b;\n    scanf(\"%d%d\",&a,&b);\n    printf(\"%d\", a-b);\n    return 0;\n}', '2021-04-25 03:52:03', '2021-04-25 11:52:03');
INSERT INTO `problem_result` VALUES (306, 36, 1048, 26, 50, '2d31ae07-7109-4f36-8718-aafe3431771b', 1, 'C', 2, 0, NULL, '#include <stdio.h>\n\nint main() {\n    int a,b;\n    scanf(\"%d%d\",&a,&b);\n    printf(\"%d\", a+b);\n    return 0;\n}', '2021-04-25 12:53:06', '2021-04-25 20:53:06');
INSERT INTO `problem_result` VALUES (307, 36, 1050, NULL, 0, 'c9bacfbb-ab9a-468d-a8e2-b7d250b1674c', 1, 'C', 2, 0, NULL, '#include <stdio.h>\r\n\r\nvoid PrintN ( int N );\r\n\r\nint main ()\r\n{\r\n    int N;\r\n\r\n    scanf(\"%d\", &N);\r\n    PrintN( N );\r\n\r\n    return 0;\r\n}\r\n\r\nvoid PrintN( int N )\r\n{\r\n  int i;\r\n  for(i=1;i<=N;i++)\r\n  {\r\n    printf(\"%d\\n\",i);\r\n  }\r\n}', '2021-04-26 03:19:48', '2021-04-26 11:19:48');
INSERT INTO `problem_result` VALUES (308, 36, 1048, 28, 5, '991ad42c-34a1-4462-97a6-19fbb461c21f', 7, 'C', 2, 0, NULL, '#include <stdio.h>\n\nint main() {\n    int a,b;\n    scanf(\"%d%d\",&a,&b);\n    printf(\"%d\", 50);\n    return 0;\n}', '2021-04-26 06:44:59', '2021-04-26 14:44:59');
INSERT INTO `problem_result` VALUES (309, 36, 1048, 28, 10, '44b9bd38-8f4d-419a-892b-df6aee5b7d94', 1, 'C', 2, 0, NULL, '#include <stdio.h>\n\nint main() {\n    int a,b;\n    scanf(\"%d%d\",&a,&b);\n    printf(\"%d\", a+b);\n    return 0;\n}', '2021-04-26 06:45:41', '2021-04-26 14:45:41');
INSERT INTO `problem_result` VALUES (310, 36, 1048, 28, 10, '02b61cc5-c772-4d49-9c46-692d6ded7ce5', 1, 'C', 1, 0, NULL, '#include <stdio.h>\n\nint main() {\n    int a,b;\n    scanf(\"%d%d\",&a,&b);\n    printf(\"%d\", a+b);\n    return 0;\n}', '2021-04-26 06:50:08', '2021-04-26 14:50:08');
INSERT INTO `problem_result` VALUES (311, 36, 1049, 28, 10, 'c6225c20-cc69-44ac-8117-f9e29523a6ff', 1, 'C', 2, 0, NULL, '#include <stdio.h>\n\nint main() {\n    int a,b;\n    scanf(\"%d%d\",&a,&b);\n    printf(\"%d\", a-b);\n    return 0;\n}', '2021-04-26 06:50:59', '2021-04-26 14:50:59');
INSERT INTO `problem_result` VALUES (312, 36, 1050, 28, 0, 'bd955e2d-6620-4531-9f3d-316d4fe4a7b9', 2, 'C', NULL, NULL, '/home/liu/oj/file/testcase/1050/1619422439919/Main.c: 在函数‘main’中:\n/home/liu/oj/file/testcase/1050/1619422439919/Main.c:6:5: 错误：只允许在 C99 模式下使用‘for’循环初始化声明\n     for(int i=1;i<=a;i++)\n     ^\n/home/liu/oj/file/testcase/1050/1619422439919/Main.c:6:5: 附注：使用 -std=c99 或 -std=gnu99 来编译您的代码', '#include <stdio.h>\n\nint main() {\n    int a;\n    scanf(\"%d%d\",&a);\n    for(int i=1;i<=a;i++)\n    {\n        printf(\"%d\\n\",i);\n    }\n    return 0;\n}', '2021-04-26 07:34:00', '2021-04-26 15:33:59');
INSERT INTO `problem_result` VALUES (313, 36, 1050, 28, 10, 'b5316ea9-006d-4d8c-8f2f-284ba14a18f8', 1, 'C', 2, 0, NULL, '#include <stdio.h>\n\nint main() {\n    int a,i;\n    scanf(\"%d%d\",&a);\n    for(i=1;i<=a;i++)\n    {\n        printf(\"%d\\n\",i);\n    }\n    return 0;\n}', '2021-04-26 07:35:22', '2021-04-26 15:35:22');
INSERT INTO `problem_result` VALUES (314, 36, 1073, 29, 20, '7590083a-6bee-4af9-9422-b09dc8354a4c', 1, 'C', 2, 0, NULL, '#include<stdio.h>\r\n#include<stdlib.h>\r\ntypedef struct stu\r\n{\r\n	int no;\r\n	struct stu *next;\r\n}STU;\r\nSTU *head;\r\nvoid jianbiao(int n)\r\n{\r\n	int i;\r\n	STU *p,*pr;\r\n	p=(STU*)malloc(sizeof(STU));\r\n	if(p!=NULL)\r\n	{\r\n		p->no=1;\r\n		head=p;\r\n		pr=p;\r\n	}\r\n	for(i=2;i<=n;i++)\r\n	{\r\n		p=(STU*)malloc(sizeof(STU));\r\n    	if(p!=NULL)\r\n    	{\r\n    		p->no=i;\r\n    		pr->next=p;\r\n    		pr=p;\r\n    	}\r\n	}\r\n	pr->next=head;\r\n}\r\nvoid chazhao(int n)\r\n{\r\n	STU *p,*pr;\r\n	int i,j;\r\n	for(i=0;i<n-1;i++)\r\n	{\r\n		for(j=1;j<3;j++)\r\n		{\r\n			if(i==0&&j==1)\r\n			{\r\n				p=head;\r\n			}\r\n			else\r\n			{\r\n				p=p->next;\r\n			}\r\n		}\r\n		pr=p->next;\r\n		p->next=pr->next;\r\n		free(pr);\r\n	}\r\n	printf(\"%d\",p->no);\r\n}\r\nint main()\r\n{\r\n	int n;\r\n	scanf(\"%d\",&n);\r\n	if(n==1)\r\n	{\r\n		printf(\"1\");\r\n	}\r\n	else\r\n	{\r\n		jianbiao(n);\r\n	    chazhao(n);\r\n	}\r\n	return 0;\r\n}', '2021-04-26 13:32:46', '2021-04-26 21:32:46');
INSERT INTO `problem_result` VALUES (315, 36, 1074, 29, 0, 'e0c9da4e-db30-42ec-ac62-814003c4f9d7', 2, 'C', NULL, NULL, '/home/liu/oj/file/testcase/1074/1619516271903/Main.c: 在函数‘main’中:\n/home/liu/oj/file/testcase/1074/1619516271903/Main.c:26:2: 警告：不建议使用‘gets’(声明于 /usr/include/stdio.h:638) [-Wdeprecated-declarations]\n  gets(a);\r\n  ^\n/home/liu/oj/file/testcase/1074/1619516271903/Main.c:27:2: 警告：不建议使用‘gets’(声明于 /usr/include/stdio.h:638) [-Wdeprecated-declarations]\n  gets(b);\r\n  ^\n/tmp/ccr4Z4pv.o：在函数‘main’中：\nMain.c:(.text+0xef): 警告：the `gets\' function is dangerous and should not be used.', '#include<stdio.h>\r\n#include<string.h>\r\n#define M 100\r\nvoid shanchu(char a[], char b[], char c[]) {    \r\n	char *s = NULL;\r\n	s = strstr(a, b);\r\n	int len = strlen(b);\r\n	if (s == NULL) {     \r\n		int i;\r\n		for (i = 0; a[i] != \'\\0\'; i++)\r\n		{\r\n			c[i] = a[i];\r\n		}\r\n		c[i] = \'\\0\';\r\n	}\r\n	else {\r\n		for (s; *s != \'\\0\'; s++)\r\n		{\r\n			*s = *(s + len);\r\n		}\r\n		shanchu(a, b, c);\r\n	}\r\n}\r\nint main() {\r\n	char a[M], b[M], c[M];\r\n	gets(a);\r\n	gets(b);\r\n	shanchu(a, b, c);\r\n	puts(c);\r\n}', '2021-04-27 09:37:52', '2021-04-27 17:37:51');
INSERT INTO `problem_result` VALUES (316, 36, 1074, 29, 0, '0768e0ba-a0aa-4d05-8d27-aecbfcacf0a1', 4, 'C', 6, 0, NULL, '#include<stdio.h>\r\n#include<string.h>\r\n#define M 100\r\nvoid shanchu(char a[], char b[], char c[]) {    \r\n	char *s = NULL;\r\n	s = strstr(a, b);\r\n	int len = strlen(b);\r\n	if (s == NULL) {     \r\n		int i;\r\n		for (i = 0; a[i] != \'\\0\'; i++)\r\n		{\r\n			c[i] = a[i];\r\n		}\r\n		c[i] = \'\\0\';\r\n	}\r\n	else {\r\n		for (s; *s != \'\\0\'; s++)\r\n		{\r\n			*s = *(s + len);\r\n		}\r\n		shanchu(a, b, c);\r\n	}\r\n}\r\nint main() {\r\n	char a[M], b[M], c[M];\r\n	scanf(\"%s\",a);\r\n	getchar();\r\n	scanf(\"%s\",b);\r\n	getchar();\r\n	shanchu(a, b, c);\r\n	puts(c);\r\n}', '2021-04-27 09:39:39', '2021-04-27 17:39:39');
INSERT INTO `problem_result` VALUES (317, 36, 1075, 29, 20, 'af8a2819-8aa4-4e15-89da-61a774809c00', 1, 'C++', 5, 0, NULL, '#include<bits/stdc++.h>\r\nusing namespace std;\r\nint main()\r\n{\r\n	char stu[100][100],temp[100];\r\n	int i,n,j,m;\r\n	cin>>n>>m;\r\n	fflush(stdin);\r\n	for(i=0;i<n;i++)\r\n	{\r\n		cin>>stu[i];\r\n		getchar();\r\n	}\r\n	for(j=1;j<=m;j++)\r\n	{\r\n		for(i=0;i<n-1;i++)\r\n		{\r\n			if(strcmp(stu[i],stu[i+1])>0)\r\n			{\r\n				strcpy(temp,stu[i]);\r\n				strcpy(stu[i],stu[i+1]);\r\n				strcpy(stu[i+1],temp);\r\n			}\r\n		}\r\n	}\r\n	for(i=0;i<n;i++)\r\n	{\r\n		cout<<stu[i]<<endl;\r\n	}\r\n	return 0;\r\n}', '2021-04-27 09:40:36', '2021-04-27 17:40:37');
INSERT INTO `problem_result` VALUES (318, 36, 1076, 29, 0, 'a338276c-0da8-4251-b81d-85fb36e8d688', 4, 'C', 6, 0, NULL, '#include<stdio.h>\r\n#include<stdlib.h>\r\n#include<string.h> \r\nint main()\r\n{\r\n	char a[200];\r\n	int n,l,i;\r\n	scanf(\"%s\",a);\r\n	getchar();\r\n	scanf(\"%d\",&n);\r\n	l=strlen(a);\r\n	for(i=0;i<n;i++)\r\n	{\r\n		a[i+l]=a[i];\r\n	}\r\n	for(i=0;i<l;i++)\r\n	{\r\n		a[i]=a[i+n];\r\n	}\r\n	for(i=0;i<l;i++)\r\n	{\r\n		printf(\"%c\",a[i]);\r\n	}\r\n	return 0;\r\n}', '2021-04-27 09:42:13', '2021-04-27 17:42:13');
INSERT INTO `problem_result` VALUES (319, 36, 1048, 29, 20, 'fe51044d-bd51-49d4-a7f0-f92a49a41b34', 1, 'C', 2, 0, NULL, '#include <stdio.h>\n\nint main() {\n    int a,b;\n    scanf(\"%d%d\",&a,&b);\n    printf(\"%d\", a+b);\n    return 0;\n}', '2021-04-27 09:44:51', '2021-04-27 17:44:51');
INSERT INTO `problem_result` VALUES (320, 36, 1049, 29, 20, '26e0abba-581b-4033-ad93-9e38dba00e41', 1, 'C', 2, 0, NULL, '#include <stdio.h>\n\nint main() {\n    int a,b;\n    scanf(\"%d%d\",&a,&b);\n    printf(\"%d\", a-b);\n    return 0;\n}', '2021-04-27 09:45:17', '2021-04-27 17:45:18');
INSERT INTO `problem_result` VALUES (321, 36, 1050, 29, 20, 'beb8f815-b927-45fc-9040-e0cdb62215cb', 1, 'C', 1, 0, NULL, '#include <stdio.h>\n\nint main() {\n    int a,i;\n    scanf(\"%d\",&a);\n    for(i=1;i<=a;i++)\n    {\n        printf(\"%d\\n\",i);\n    }\n    return 0;\n}', '2021-04-27 09:46:10', '2021-04-27 17:46:10');
INSERT INTO `problem_result` VALUES (322, 36, 1051, 28, 0, '7f7becb0-68d7-4246-96e1-37f15df808ad', 7, 'C', 0, 0, NULL, '#include<stdio.h>\r\n#include<math.h>\r\n#include<stdlib.h>\r\nint main()\r\n{\r\n	int a,i=0,s[3],n=3,sum;\r\n	scanf(\"%d\",&a);\r\n	while(a!=0)\r\n	{\r\n		s[i]=a%10;\r\n		a=a/10;\r\n		i++;\r\n	}\r\n	sum=s[0]*100+s[1]*10+s[2];\r\n	printf(\"%d\",sum);\r\n	system(\"pause\");\r\n	return 0;\r\n}', '2021-04-27 10:46:03', '2021-04-27 18:46:03');
INSERT INTO `problem_result` VALUES (323, 36, 1051, 28, 10, '3a2cb0f4-fb08-4dc4-8518-700436132dde', 1, 'C', 3, 0, NULL, '#include<stdio.h>\r\n#include<math.h>\r\n#include<stdlib.h>\r\nint main()\r\n{\r\n	int a,i=0,s[3],n=3,sum;\r\n	scanf(\"%d\",&a);\r\n	while(a!=0)\r\n	{\r\n		s[i]=a%10;\r\n		a=a/10;\r\n		i++;\r\n	}\r\n	sum=s[0]*100+s[1]*10+s[2];\r\n	printf(\"%d\",sum);\r\n\r\n	return 0;\r\n}', '2021-04-27 10:51:08', '2021-04-27 18:51:08');
INSERT INTO `problem_result` VALUES (324, 36, 1052, 28, 10, 'bbd69fd7-ed76-4940-92f1-3c14973f3161', 1, 'C', 2, 0, NULL, '#include<stdio.h>\r\n#include<stdlib.h>\r\nint main()\r\n{\r\n	int n,i=0,k=0;\r\n	int a[1000];\r\n	scanf(\"%d\",&n);\r\n	printf(\"%x\",n);\r\n	return 0;\r\n}', '2021-04-27 11:03:51', '2021-04-27 19:03:52');
INSERT INTO `problem_result` VALUES (325, 36, 1053, 28, 10, 'ccf6b059-e383-401b-84c8-3431ba687ea6', 1, 'C', 2, 0, NULL, '#include<stdio.h>\r\nint main()\r\n{\r\n  float a;\r\n  int b;\r\n  char c,ch;\r\n  float d;\r\n  scanf(\"%f%d\",&a,&b);\r\n  ch=getchar();\r\n  scanf(\"%c%f\",&c,&d);\r\n  printf(\"%c %d %.2f %.2f\",c,b,a,d);\r\n  return 0;\r\n}', '2021-04-27 11:05:38', '2021-04-27 19:05:38');
INSERT INTO `problem_result` VALUES (326, 36, 1054, 28, 10, '91c2241a-d530-46fd-b0d1-b0bf18b4fa00', 1, 'C', 2, 0, NULL, '#include<stdio.h>\r\n#include<math.h>\r\n#include<stdlib.h>\r\nint main()\r\n{\r\n  int a,b;\r\n  scanf(\"%d:%d\",&a,&b);\r\n  if(a>12)\r\n  {\r\n    printf(\"%d:%d PM\",a-12,b);\r\n  }\r\n  else if(a>=0&&a<12)\r\n  {\r\n    printf(\"%d:%d AM\",a,b);\r\n  }\r\n  else if(a=12)\r\n  {\r\n    printf(\"%d:%d PM\",a,b);\r\n  }\r\n  return 0;\r\n}', '2021-04-27 11:06:42', '2021-04-27 19:06:42');
INSERT INTO `problem_result` VALUES (327, 36, 1055, 28, 10, '05bbe9c9-55f6-47b2-8e64-d2c5ddc6b411', 1, 'C', 2, 0, NULL, '#include<stdio.h>\r\nint main()\r\n{\r\n  int a;\r\n  scanf(\"%d\",&a);\r\n  if(a<=60)\r\n  {\r\n    printf(\"Speed: %d - OK\",a);\r\n  }\r\n  else\r\n  {\r\n    printf(\"Speed: %d - Speeding\",a);\r\n  }\r\n  return 0;\r\n}', '2021-04-27 11:07:06', '2021-04-27 19:07:06');
INSERT INTO `problem_result` VALUES (328, 36, 1056, 28, 10, '1dbdb04d-b6c2-45cf-a800-61b1ffff989f', 1, 'C', 2, 0, NULL, '#include<stdio.h>\r\nint main()\r\n{\r\n  int a,b,c;\r\n  scanf(\"%d%d%d\",&a,&b,&c);\r\n  if(a==b&&a!=c)\r\n  {\r\n    printf(\"C\");\r\n  }\r\n  else if(a==c&&a!=b)\r\n  {\r\n    printf(\"B\");\r\n  }\r\n  else\r\n  {\r\n    printf(\"A\");\r\n  }\r\n  return 0;\r\n}', '2021-04-27 11:07:39', '2021-04-27 19:07:39');
INSERT INTO `problem_result` VALUES (329, 36, 1057, 28, 0, 'dee4974b-0d40-41ae-a11e-c21b5af7140a', 7, 'C', 0, 0, NULL, '#include<stdio.h>\r\n#include<math.h>\r\n#include<stdlib.h>\r\nint main()\r\n{\r\n  int m,n;\r\n  float sum;\r\n  scanf(\"%d%d\",&m,&n);\r\n  if(m<5&&n<=40)\r\n  {\r\n    sum=n*30;\r\n    printf(\"%.2f\",sum);\r\n  }\r\n  if(m<5&&n>40)\r\n  {\r\n    sum=1200+(n-40)*45;\r\n    printf(\"%.2f\",sum);\r\n  }\r\n  if(m>=5&&n<=40)\r\n  {\r\n    sum=n*50;\r\n    printf(\"%.2f\",sum);\r\n  }\r\n  if(m>=5&&n>40)\r\n  {\r\n    sum=2000+(n-40)*75;\r\n    printf(\"%.2f\",sum);\r\n  }\r\n  system(\"pause\");\r\n  return 0;\r\n}', '2021-04-27 11:08:02', '2021-04-27 19:08:02');
INSERT INTO `problem_result` VALUES (330, 36, 1057, 28, 0, '369a730a-bbe0-4029-a52c-8a0aa189ebed', 7, 'C', 2, 0, NULL, '#include<stdio.h>\r\n#include<math.h>\r\n#include<stdlib.h>\r\nint main()\r\n{\r\n  int m,n;\r\n  float sum;\r\n  scanf(\"%d%d\",&m,&n);\r\n  if(m<5&&n<=40)\r\n  {\r\n    sum=n*30;\r\n    printf(\"%.2f\",sum);\r\n  }\r\n  if(m<5&&n>40)\r\n  {\r\n    sum=1200+(n-40)*45;\r\n    printf(\"%.2f\",sum);\r\n  }\r\n  if(m>=5&&n<=40)\r\n  {\r\n    sum=n*50;\r\n    printf(\"%.2f\",sum);\r\n  }\r\n  if(m>=5&&n>40)\r\n  {\r\n    sum=2000+(n-40)*75;\r\n    printf(\"%.2f\",sum);\r\n  }\r\n  system(\"pause\");\r\n  return 0;\r\n}', '2021-04-27 11:08:13', '2021-04-27 19:08:13');
INSERT INTO `problem_result` VALUES (331, 36, 1057, 28, 10, '4af74039-5796-4601-8957-141af29dca29', 1, 'C', 1, 0, NULL, '#include<stdio.h>\r\n#include<math.h>\r\n#include<stdlib.h>\r\nint main()\r\n{\r\n  int m,n;\r\n  float sum;\r\n  scanf(\"%d%d\",&m,&n);\r\n  if(m<5&&n<=40)\r\n  {\r\n    sum=n*30;\r\n    printf(\"%.2f\",sum);\r\n  }\r\n  if(m<5&&n>40)\r\n  {\r\n    sum=1200+(n-40)*45;\r\n    printf(\"%.2f\",sum);\r\n  }\r\n  if(m>=5&&n<=40)\r\n  {\r\n    sum=n*50;\r\n    printf(\"%.2f\",sum);\r\n  }\r\n  if(m>=5&&n>40)\r\n  {\r\n    sum=2000+(n-40)*75;\r\n    printf(\"%.2f\",sum);\r\n  }\r\n  return 0;\r\n}', '2021-04-27 11:08:19', '2021-04-27 19:08:19');
INSERT INTO `problem_result` VALUES (332, 36, 1058, 32, 10, '64ec22cd-999d-4c09-bb50-3f13a9b8c302', 1, 'Java8', 1377, 34468, NULL, 'import java.util.Scanner;\r\n\r\npublic class Main {\r\n\r\n	public static void main(String[] args) {\r\n		// TODO Auto-generated method stub\r\n		Scanner in = new Scanner(System.in);\r\n		double x,y;\r\n		x = in.nextDouble();\r\n		if(x<=15)\r\n		{\r\n			y = (4*x)/3.0;\r\n			System.out.printf(\"%.2f\",y);\r\n		}\r\n		else\r\n		{\r\n			y = 2.5*x - 17.5;\r\n			System.out.printf(\"%.2f\",y);\r\n		}\r\n\r\n	}\r\n\r\n}', '2021-04-27 11:44:05', '2021-04-27 19:44:08');
INSERT INTO `problem_result` VALUES (333, 36, 1059, 32, 10, 'bb830df6-62d3-449d-8012-47b601f5269c', 1, 'C', 2, 0, NULL, '#include<stdio.h>\r\n#include<math.h>\r\n#include<stdlib.h>\r\nint main()\r\n{\r\n  int a,b;\r\n  char ch,ch1;\r\n  scanf(\"%d\",&a);\r\n  ch1=getchar();\r\n  scanf(\"%c%d\",&ch,&b);\r\n  if(ch==\'+\')\r\n  {\r\n    printf(\"%d\",a+b);\r\n  }\r\n  else if(ch==\'-\')\r\n  {\r\n	  printf(\"%d\",a-b);\r\n  }\r\n  else if(ch==\'*\')\r\n  {\r\n    printf(\"%d\",a*b);\r\n  }\r\n  else if(ch==\'/\')\r\n  {\r\n    printf(\"%d\",a/b);\r\n  }\r\n  else if(ch==\'%\')\r\n  {\r\n    printf(\"%d\",a%b);\r\n  }\r\n  else\r\n  {\r\n	  printf(\"ERROR\");\r\n  }\r\n  return 0;\r\n}', '2021-04-27 11:45:00', '2021-04-27 19:45:00');
INSERT INTO `problem_result` VALUES (334, 36, 1061, 32, 10, '77f3f0ad-9961-4b2d-b18b-cee8e5e32ba4', 1, 'C', 0, 0, NULL, '#include<stdio.h>\r\n#include<math.h>\r\nint main()\r\n{\r\n  int i,m,n,sum=0,k=0;\r\n  scanf(\"%d%d\",&m,&n);\r\n  for(i=m;i<=n;i++)\r\n  {\r\n    printf(\"%5d\",i);\r\n  	sum=sum+i;\r\n    k++;\r\n    if(k%5==0)\r\n	 {\r\n     printf(\"\\n\");\r\n	 }\r\n	 else if(i==n)\r\n	 {\r\n		printf(\"\\n\");\r\n	 }\r\n  }\r\n  printf(\"Sum = %d\",sum);\r\n  return 0;\r\n}', '2021-04-27 11:49:22', '2021-04-27 19:49:22');
INSERT INTO `problem_result` VALUES (335, 36, 1062, 32, 10, 'fe6363e0-854d-4d34-a5d7-46c8000129ba', 1, 'C', 0, 0, NULL, '#include<stdio.h>\r\n#include<stdlib.h>\r\ndouble que(double n)\r\n{\r\n	double i,r=1;\r\n	for(i=2;i<=n;i++)\r\n	{\r\n		r=r*i;\r\n	}\r\n	return r;\r\n}\r\nvoid fun(double a)\r\n{\r\n	double i,m,sum=1,l=1;\r\n	double t,j,k;\r\n	for(i=1;;i++)\r\n	{\r\n		m=que(i);\r\n		l=l*(2*i+1);\r\n		t=m/l;\r\n		sum=sum+t;\r\n		if(t<a)\r\n		{\r\n			printf(\"%.6lf\\n\",2*sum);\r\n			break;\r\n		}\r\n	}\r\n}\r\nint main()\r\n{\r\n	double a;\r\n	scanf(\"%lf\",&a);\r\n	fun(a);\r\n	return 0;\r\n}', '2021-04-27 11:49:54', '2021-04-27 19:49:54');
INSERT INTO `problem_result` VALUES (336, 36, 1063, 32, 10, '6916a86b-d62d-4332-a16a-440cf6d11483', 1, 'C++', 0, 0, NULL, '#include<bits/stdc++.h>\r\nusing namespace std;\r\nint main()\r\n{\r\n	int i,j,k,n,sum,r=0;\r\n	cin>>n;\r\n	for(i=n;i<=n+3;i++)\r\n	{\r\n		for(j=n;j<=n+3;j++)\r\n		{\r\n			for(k=n;k<=n+3;k++)\r\n			{\r\n				if(i==j||j==k||i==k)\r\n				{\r\n					continue;\r\n				}\r\n				else\r\n				{\r\n					r++;\r\n					sum=i*100+j*10+k;\r\n					cout<<sum;\r\n					if(r%6==0)\r\n					{\r\n						cout<<endl;\r\n					}\r\n					else\r\n					{\r\n						cout<<\" \";\r\n					}\r\n				}\r\n			}\r\n		}\r\n	}\r\n	return 0;\r\n}', '2021-04-27 11:50:41', '2021-04-27 19:50:42');
INSERT INTO `problem_result` VALUES (337, 36, 1066, 32, 10, '5f5f27cd-9393-419b-ba1c-3cbfb41f9012', 1, 'C', 0, 0, NULL, '#include<stdio.h>\r\n#include<math.h>\r\nint main() \r\n{\r\n	int n,i,j;\r\n	int a[100];\r\n	scanf(\"%d\",&n);\r\n	for(i=1;i<=n;i++)\r\n	{\r\n		for(j=1;j<=n;j++)\r\n		{\r\n			if(i>=j)\r\n			{\r\n				a[i]=i*j;\r\n			    printf(\"%d*%d=%-4d\",j,i,a[i]);\r\n			}\r\n	   }\r\n	   printf(\"\\n\");\r\n   }\r\n	return 0;\r\n }', '2021-04-27 11:51:22', '2021-04-27 19:51:22');
INSERT INTO `problem_result` VALUES (338, 36, 1067, 32, 10, '0c54c572-2c47-4642-bc69-154d6da64b4c', 1, 'C', 0, 0, NULL, '#include <stdio.h>\r\n#include<math.h>\r\nint main()\r\n{\r\n    int i,t,tu=0,gui=0,suijiao=0;\r\n    scanf(\"%d\",&t);\r\n    for(i=1;i<=t;i++)\r\n    {\r\n        if(suijiao == 0)\r\n            tu += 9;\r\n        else\r\n          suijiao=suijiao-1;;\r\n        gui += 3;\r\n        if(i % 10 == 0 && suijiao == 0)\r\n            if(tu > gui)\r\n                suijiao = 30;\r\n    }\r\n    if(tu > gui)\r\n        printf(\"^_^ %d\", tu);\r\n    else if(tu < gui)\r\n        printf(\"@_@ %d\", gui);\r\n    else\r\n        printf(\"-_- %d\", tu);\r\n    return 0;\r\n}', '2021-04-27 11:51:44', '2021-04-27 19:51:44');
INSERT INTO `problem_result` VALUES (339, 36, 1048, NULL, 0, '643b704a-41e0-48e1-af22-a6f989bcd6ca', 1, 'C', 5, 0, NULL, '#include <stdio.h>\n\nint main() {\n    int a,b;\n    scanf(\"%d%d\",&a,&b);\n    printf(\"%d\", a+b);\n    return 0;\n}', '2021-05-06 08:21:11', '2021-05-06 16:21:11');
INSERT INTO `problem_result` VALUES (340, 36, 1048, NULL, 0, 'd8e2ff88-16d6-4e6c-a584-bee204248caa', 7, 'C', 2, 0, NULL, '#include <stdio.h>\n\nint main() {\n    int a,b;\n    scanf(\"%d%d\",&a,&b);\n    printf(\"%d\", a-b);\n    return 0;\n}', '2021-05-06 08:21:19', '2021-05-06 16:21:18');
INSERT INTO `problem_result` VALUES (341, 36, 1048, NULL, 0, '95faef72-c24a-4576-925a-f49b38b43a46', 1, 'C', 5, 0, NULL, '#include <stdio.h>\n\nint main() {\n    int a,b;\n    scanf(\"%d%d\",&a,&b);\n    printf(\"%d\", a+b);\n    return 0;\n}', '2021-05-20 09:22:10', '2021-05-20 17:22:10');
INSERT INTO `problem_result` VALUES (342, 36, 1050, NULL, 0, '31cedeaf-6efb-4db0-862a-164a69211ccb', 1, 'C', 2, 0, NULL, '#include <stdio.h>\n\nvoid PrintN ( int N );\n\nint main ()\n{\n    int N;\n\n    scanf(\"%d\", &N);\n    PrintN( N );\n\n    return 0;\n}\n\nvoid PrintN( int N )\n{\n  int i;\n  for(i=1;i<=N;i++)\n  {\n    printf(\"%d\\n\",i);\n  }\n}', '2021-05-20 12:29:37', '2021-05-20 20:29:37');
INSERT INTO `problem_result` VALUES (343, 36, 1050, NULL, 0, '131bbfa1-9984-44e0-857a-6d2343d0df9a', 1, 'C', 2, 0, NULL, '#include <stdio.h>\n\nvoid PrintN ( int N );\n\nint main ()\n{\n    int N;\n\n    scanf(\"%d\", &N);\n    PrintN( N );\n\n    return 0;\n}\n\nvoid PrintN( int N )\n{\n  int i;\n  for(i=1;i<=N;i++)\n  {\n    printf(\"%d\\n\",i);\n  }\n}', '2021-05-20 12:31:51', '2021-05-20 20:31:51');
INSERT INTO `problem_result` VALUES (344, 36, 1050, NULL, 0, '253f5b67-18f5-4a61-8e63-9a92672f0dc2', 4, 'C', NULL, NULL, NULL, '#include <stdio.h>\r\n\r\nvoid PrintN ( int N );\r\n\r\nint main ()\r\n{\r\n    int N;\r\n\r\n    scanf(\"%d\", &N);\r\n    PrintN( N );\r\n\r\n    return 0;\r\n}\r\n\r\nvoid PrintN( int N )\r\n{\r\n  int i;\r\n  for(i=1;i<=N;i++)\r\n  {\r\n    printf(\"%d\\n\",i);\r\n  }\r\n}', '2021-05-20 12:44:03', '2021-05-20 20:44:10');
INSERT INTO `problem_result` VALUES (345, 36, 1050, NULL, 0, 'e21f1ed3-1e16-4b2c-9bd2-4efce88785f5', 4, 'C', NULL, NULL, NULL, '#include <stdio.h>\r\n\r\nvoid PrintN ( int N );\r\n\r\nint main ()\r\n{\r\n    int N;\r\n\r\n    scanf(\"%d\", &N);\r\n    PrintN( N );\r\n\r\n    return 0;\r\n}\r\n\r\nvoid PrintN( int N )\r\n{\r\n  int i;\r\n  for(i=1;i<=N;i++)\r\n  {\r\n    printf(\"%d\\n\",i);\r\n  }\r\n}', '2021-05-20 12:44:10', '2021-05-20 20:44:11');
INSERT INTO `problem_result` VALUES (346, 36, 1050, NULL, 0, '5b67f30c-b86d-4ac7-9cac-31d8abe51f7b', 1, 'C', 2, 0, NULL, '#include <stdio.h>\r\n\r\nvoid PrintN ( int N );\r\n\r\nint main ()\r\n{\r\n    int N;\r\n\r\n    scanf(\"%d\", &N);\r\n    PrintN( N );\r\n\r\n    return 0;\r\n}\r\n\r\nvoid PrintN( int N )\r\n{\r\n  int i;\r\n  for(i=1;i<=N;i++)\r\n  {\r\n    printf(\"%d\\n\",i);\r\n  }\r\n}', '2021-05-20 12:53:03', '2021-05-20 20:53:03');
INSERT INTO `problem_result` VALUES (347, 36, 1048, NULL, 0, 'da2bde4d-5d6d-4f0c-9b75-cb089d54c5b1', 1, 'C', 2, 0, NULL, '#include <stdio.h>\n\nint main() {\n    int m,n;\n    scanf(\"%d%d\",&m,&n);\n    printf(\"%d\", m+n);\n    return 0;\n}', '2021-05-20 12:53:59', '2021-05-20 20:53:58');
INSERT INTO `problem_result` VALUES (348, 36, 1052, NULL, 0, '33a16524-ac35-4548-8b7a-0ff7ac080663', 1, 'C', 5, 0, NULL, '#include<stdio.h>\n#include<stdlib.h>\nint main()\n{\n	int n,i=0,k=0;\n	int a[1000];\n	scanf(\"%d\",&n);\n	printf(\"%x\",n);\n	return 0;\n}', '2021-05-27 09:42:14', '2021-05-27 17:42:14');
INSERT INTO `problem_result` VALUES (349, 36, 1048, NULL, 0, '4924f15f-447b-4c54-b2d1-bbd15cbf80f5', 1, 'C', 1, 0, NULL, '#include <stdio.h>\n\nint main() {\n    int a,b;\n    scanf(\"%d%d\",&a,&b);\n    printf(\"%d\", a+b);\n    return 0;\n}', '2021-05-28 02:21:19', '2021-05-28 10:21:19');
INSERT INTO `problem_result` VALUES (350, 36, 1048, NULL, 0, '2f752403-cae7-484f-8c25-47a30d50a0f0', 1, 'C', 2, 0, NULL, '#include <stdio.h>\n\nint main() {\n    int a,b;\n    scanf(\"%d%d\",&a,&b);\n    printf(\"%d\", a+b);\n    return 0;\n}', '2021-05-28 07:58:55', '2021-05-28 15:58:54');

-- ----------------------------
-- Table structure for problem_tag
-- ----------------------------
DROP TABLE IF EXISTS `problem_tag`;
CREATE TABLE `problem_tag`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `problem_id` int(11) NULL DEFAULT NULL,
  `tag_id` int(11) NULL DEFAULT NULL,
  `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0),
  `update_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0),
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 180 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of problem_tag
-- ----------------------------
INSERT INTO `problem_tag` VALUES (11, 1009, 20, '2019-03-25 00:04:13', '2019-03-25 00:05:02');
INSERT INTO `problem_tag` VALUES (128, 1043, 7, '2019-05-09 16:58:50', '2019-05-09 16:58:50');
INSERT INTO `problem_tag` VALUES (134, 1049, 1, '2021-04-25 11:47:12', '2021-04-25 11:47:12');
INSERT INTO `problem_tag` VALUES (138, 1051, 1, '2021-04-26 10:29:17', '2021-04-26 10:29:17');
INSERT INTO `problem_tag` VALUES (140, 1053, 1, '2021-04-26 10:33:13', '2021-04-26 10:33:13');
INSERT INTO `problem_tag` VALUES (141, 1054, 1, '2021-04-26 10:34:23', '2021-04-26 10:34:23');
INSERT INTO `problem_tag` VALUES (143, 1055, 1, '2021-04-26 10:37:01', '2021-04-26 10:37:01');
INSERT INTO `problem_tag` VALUES (144, 1056, 1, '2021-04-26 10:38:03', '2021-04-26 10:38:03');
INSERT INTO `problem_tag` VALUES (146, 1058, 1, '2021-04-26 10:41:15', '2021-04-26 10:41:15');
INSERT INTO `problem_tag` VALUES (147, 1057, 1, '2021-04-26 10:41:58', '2021-04-26 10:41:58');
INSERT INTO `problem_tag` VALUES (148, 1059, 1, '2021-04-26 10:43:23', '2021-04-26 10:43:23');
INSERT INTO `problem_tag` VALUES (151, 1061, 1, '2021-04-26 10:50:38', '2021-04-26 10:50:38');
INSERT INTO `problem_tag` VALUES (152, 1062, 1, '2021-04-26 10:52:37', '2021-04-26 10:52:37');
INSERT INTO `problem_tag` VALUES (153, 1063, 1, '2021-04-26 10:54:03', '2021-04-26 10:54:03');
INSERT INTO `problem_tag` VALUES (156, 1066, 1, '2021-04-26 10:59:28', '2021-04-26 10:59:28');
INSERT INTO `problem_tag` VALUES (157, 1067, 1, '2021-04-26 11:02:18', '2021-04-26 11:02:18');
INSERT INTO `problem_tag` VALUES (160, 1069, 1, '2021-04-26 11:06:29', '2021-04-26 11:06:29');
INSERT INTO `problem_tag` VALUES (162, 1070, 1, '2021-04-26 11:08:55', '2021-04-26 11:08:55');
INSERT INTO `problem_tag` VALUES (163, 1071, 1, '2021-04-26 11:10:12', '2021-04-26 11:10:12');
INSERT INTO `problem_tag` VALUES (164, 1072, 1, '2021-04-26 11:11:19', '2021-04-26 11:11:19');
INSERT INTO `problem_tag` VALUES (165, 1073, 1, '2021-04-26 11:12:23', '2021-04-26 11:12:23');
INSERT INTO `problem_tag` VALUES (166, 1074, 1, '2021-04-26 11:13:46', '2021-04-26 11:13:46');
INSERT INTO `problem_tag` VALUES (167, 1075, 1, '2021-04-26 11:15:10', '2021-04-26 11:15:10');
INSERT INTO `problem_tag` VALUES (168, 1076, 1, '2021-04-26 11:16:08', '2021-04-26 11:16:08');
INSERT INTO `problem_tag` VALUES (172, 1048, 1, '2021-04-27 19:36:41', '2021-04-27 19:36:41');
INSERT INTO `problem_tag` VALUES (173, 1077, 1, '2021-05-10 19:37:59', '2021-05-10 19:37:59');
INSERT INTO `problem_tag` VALUES (174, 1077, 4, '2021-05-10 19:37:59', '2021-05-10 19:37:59');
INSERT INTO `problem_tag` VALUES (178, 1050, 1, '2021-05-20 20:29:10', '2021-05-20 20:29:10');
INSERT INTO `problem_tag` VALUES (179, 1052, 1, '2021-05-27 17:43:57', '2021-05-27 17:43:57');

-- ----------------------------
-- Table structure for register
-- ----------------------------
DROP TABLE IF EXISTS `register`;
CREATE TABLE `register`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NULL DEFAULT NULL,
  `comp_id` int(11) NULL DEFAULT NULL COMMENT '比赛id',
  `solution_count` int(11) NULL DEFAULT 0 COMMENT '解决题目数',
  `submit_count` int(11) NULL DEFAULT 0 COMMENT '提交数',
  `ac_count` int(11) NULL DEFAULT 0 COMMENT 'ac数目',
  `score` int(11) NULL DEFAULT 0 COMMENT '总分',
  `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0),
  `update_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0),
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 50 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of register
-- ----------------------------
INSERT INTO `register` VALUES (23, 1, 1, 1, 21, 2, 15, '2019-02-16 22:42:44', '2019-03-16 23:56:10');
INSERT INTO `register` VALUES (24, 1, 2, 1, 3, 3, 10, '2019-03-25 01:03:34', '2019-03-25 01:05:43');
INSERT INTO `register` VALUES (25, 1, 9, 0, 0, 0, 0, '2019-05-04 01:20:18', '2019-05-04 01:20:18');
INSERT INTO `register` VALUES (26, 36, 15, 0, 0, 0, 0, '2021-04-24 20:33:54', '2021-04-24 20:33:54');
INSERT INTO `register` VALUES (27, 36, 17, 0, 1, 0, 0, '2021-04-24 20:45:04', '2021-04-25 11:30:32');
INSERT INTO `register` VALUES (28, 37, 18, 0, 1, 0, 0, '2021-04-24 20:54:23', '2021-04-24 20:56:31');
INSERT INTO `register` VALUES (29, 36, 21, 2, 2, 2, 100, '2021-04-25 11:49:40', '2021-04-25 11:52:03');
INSERT INTO `register` VALUES (30, 36, 23, 0, 0, 0, 0, '2021-04-25 17:38:52', '2021-04-25 17:38:52');
INSERT INTO `register` VALUES (31, 38, 23, 0, 0, 0, 0, '2021-04-25 18:37:18', '2021-04-25 18:37:18');
INSERT INTO `register` VALUES (32, 36, 24, 0, 0, 0, 0, '2021-04-25 18:40:00', '2021-04-25 18:40:00');
INSERT INTO `register` VALUES (33, 36, 25, 0, 0, 0, 0, '2021-04-25 18:42:02', '2021-04-25 18:42:02');
INSERT INTO `register` VALUES (34, 36, 26, 1, 1, 1, 0, '2021-04-25 20:23:07', '2021-04-27 19:12:42');
INSERT INTO `register` VALUES (35, 38, 26, 0, 0, 0, 0, '2021-04-25 20:24:53', '2021-04-25 20:24:53');
INSERT INTO `register` VALUES (36, 38, 21, 0, 0, 0, 0, '2021-04-25 20:56:50', '2021-04-25 20:56:50');
INSERT INTO `register` VALUES (37, 36, 27, 0, 0, 0, 0, '2021-04-25 21:01:50', '2021-04-25 21:01:50');
INSERT INTO `register` VALUES (38, 36, 28, 10, 16, 11, 100, '2021-04-26 11:38:25', '2021-04-27 19:08:19');
INSERT INTO `register` VALUES (39, 36, 29, 5, 8, 5, 100, '2021-04-26 21:02:25', '2021-04-27 17:46:10');
INSERT INTO `register` VALUES (40, 36, 33, 0, 0, 0, 0, '2021-04-27 19:37:09', '2021-04-27 19:37:09');
INSERT INTO `register` VALUES (41, 36, 32, 7, 7, 7, 70, '2021-04-27 19:37:20', '2021-04-27 19:51:44');
INSERT INTO `register` VALUES (42, 36, 31, 0, 0, 0, 0, '2021-04-27 19:37:45', '2021-04-27 19:37:45');
INSERT INTO `register` VALUES (43, 36, 30, 0, 0, 0, 0, '2021-04-27 19:38:00', '2021-04-27 19:38:00');
INSERT INTO `register` VALUES (44, 38, 33, 0, 0, 0, 0, '2021-04-27 19:40:25', '2021-04-27 19:40:25');
INSERT INTO `register` VALUES (45, 38, 32, 0, 0, 0, 0, '2021-04-27 19:40:33', '2021-04-27 19:40:33');
INSERT INTO `register` VALUES (46, 38, 31, 0, 0, 0, 0, '2021-04-27 19:40:43', '2021-04-27 19:40:43');
INSERT INTO `register` VALUES (47, 38, 29, 0, 0, 0, 0, '2021-04-27 19:40:54', '2021-04-27 19:40:54');
INSERT INTO `register` VALUES (48, 38, 30, 0, 0, 0, 0, '2021-04-27 19:41:08', '2021-04-27 19:41:08');
INSERT INTO `register` VALUES (49, 38, 28, 0, 0, 0, 0, '2021-04-27 19:41:24', '2021-04-27 19:41:24');

-- ----------------------------
-- Table structure for role
-- ----------------------------
DROP TABLE IF EXISTS `role`;
CREATE TABLE `role`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '角色名称',
  `remark` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
  `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0),
  `update_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0),
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of role
-- ----------------------------
INSERT INTO `role` VALUES (1, 'ROLE_ADMIN', '管理员', '2019-02-18 20:29:16', '2019-03-22 16:44:18');
INSERT INTO `role` VALUES (2, 'ROLE_USER', '普通用户', '2019-02-18 20:29:16', '2019-03-22 16:44:18');

-- ----------------------------
-- Table structure for sign
-- ----------------------------
DROP TABLE IF EXISTS `sign`;
CREATE TABLE `sign`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NULL DEFAULT NULL,
  `mood` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '此刻心情',
  `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0),
  `update_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0),
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for system_config
-- ----------------------------
DROP TABLE IF EXISTS `system_config`;
CREATE TABLE `system_config`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sys_key` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `sys_value1` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `sys_value2` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `content` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
  `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0),
  `update_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0),
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `system_config_sys_key_uindex`(`sys_key`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of system_config
-- ----------------------------
INSERT INTO `system_config` VALUES (1, 'file_dir', '/home/ming/Music', NULL, '题目目录', '2018-12-18 09:56:32', '2018-12-18 10:03:30');

-- ----------------------------
-- Table structure for tag
-- ----------------------------
DROP TABLE IF EXISTS `tag`;
CREATE TABLE `tag`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `parent_id` int(11) NULL DEFAULT 0 COMMENT '父标签',
  `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '标签名称',
  `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0),
  `update_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0),
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 26 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of tag
-- ----------------------------
INSERT INTO `tag` VALUES (1, 0, '程序设计入门', '2018-12-17 17:17:09', '2019-02-13 21:19:00');
INSERT INTO `tag` VALUES (2, 0, '基础算法', '2018-12-17 17:17:17', '2019-02-13 21:19:00');
INSERT INTO `tag` VALUES (4, 0, '搜索算法', '2018-12-23 19:02:28', '2019-02-13 21:19:00');
INSERT INTO `tag` VALUES (5, 0, '动态规划', '2018-12-23 19:02:28', '2019-02-13 21:19:00');
INSERT INTO `tag` VALUES (6, 0, '基础数据结构', '2018-12-23 19:02:28', '2019-02-13 21:19:00');
INSERT INTO `tag` VALUES (7, 0, '高级数据结构', '2018-12-23 19:02:28', '2019-02-13 21:19:00');
INSERT INTO `tag` VALUES (8, 0, '字符串', '2018-12-23 19:16:00', '2019-02-13 21:19:00');
INSERT INTO `tag` VALUES (9, 0, '图论', '2018-12-23 19:16:00', '2019-02-13 21:19:00');
INSERT INTO `tag` VALUES (10, 0, '组合数学', '2018-12-23 19:16:00', '2019-02-13 21:19:00');
INSERT INTO `tag` VALUES (11, 0, '计算几何', '2019-02-13 21:19:00', '2019-02-13 21:19:00');
INSERT INTO `tag` VALUES (13, 0, '模板题', '2019-02-13 21:19:00', '2019-02-13 21:19:00');
INSERT INTO `tag` VALUES (14, 0, '其他算法', '2019-02-13 21:19:00', '2019-02-13 21:19:00');
INSERT INTO `tag` VALUES (15, 1, '输入和输出', '2019-02-13 22:58:40', '2019-02-13 22:59:57');
INSERT INTO `tag` VALUES (16, 1, '变量及其输入', '2019-02-13 22:59:57', '2019-02-13 22:59:57');
INSERT INTO `tag` VALUES (17, 1, '循环', '2019-02-13 22:59:57', '2019-02-13 23:00:13');
INSERT INTO `tag` VALUES (18, 1, '条件分支', '2019-02-13 22:59:57', '2019-02-13 23:00:13');
INSERT INTO `tag` VALUES (19, 1, '数学函数', '2019-02-13 22:59:57', '2019-02-13 23:00:13');
INSERT INTO `tag` VALUES (20, 1, '结构体', '2019-02-13 22:59:57', '2019-02-13 23:00:13');
INSERT INTO `tag` VALUES (21, 4, '深度优先搜索', '2019-02-13 23:04:26', '2019-02-13 23:04:52');
INSERT INTO `tag` VALUES (22, 4, '广度优先搜索', '2019-02-13 23:04:26', '2019-02-13 23:04:52');
INSERT INTO `tag` VALUES (23, 4, '搜索减枝', '2019-02-13 23:04:26', '2019-02-13 23:04:52');
INSERT INTO `tag` VALUES (24, 4, 'A* 搜索', '2019-02-13 23:04:26', '2019-02-13 23:04:52');
INSERT INTO `tag` VALUES (25, 4, '启发式搜索', '2019-02-13 23:04:26', '2019-02-13 23:04:52');

-- ----------------------------
-- Table structure for testcase_result
-- ----------------------------
DROP TABLE IF EXISTS `testcase_result`;
CREATE TABLE `testcase_result`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `pro_re_id` int(11) NULL DEFAULT NULL COMMENT '题目结果id',
  `num` int(11) NULL DEFAULT NULL COMMENT '用例编码',
  `user_output` varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户输出',
  `time` bigint(20) NULL DEFAULT NULL,
  `memory` bigint(20) NULL DEFAULT NULL,
  `status` int(11) NULL DEFAULT NULL COMMENT '1 ac 2 ce 3 pe 4 re 5 tle 6 me 7 wa',
  `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0),
  `update_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0),
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1356 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of testcase_result
-- ----------------------------
INSERT INTO `testcase_result` VALUES (1297, 304, 1, '50', 2, 0, 1, '2021-04-25 03:51:28', '2021-04-25 11:51:27');
INSERT INTO `testcase_result` VALUES (1298, 305, 1, '20', 2, 0, 1, '2021-04-25 03:52:04', '2021-04-25 11:52:03');
INSERT INTO `testcase_result` VALUES (1299, 306, 1, '50', 2, 0, 1, '2021-04-25 12:53:06', '2021-04-25 20:53:06');
INSERT INTO `testcase_result` VALUES (1300, 307, 1, '1\n2\n3\n', 2, 0, 1, '2021-04-26 03:19:48', '2021-04-26 11:19:48');
INSERT INTO `testcase_result` VALUES (1301, 308, 1, '50', 2, 0, 1, '2021-04-26 06:45:00', '2021-04-26 14:44:59');
INSERT INTO `testcase_result` VALUES (1302, 308, 2, '50', 2, 0, 7, '2021-04-26 06:45:00', '2021-04-26 14:44:59');
INSERT INTO `testcase_result` VALUES (1303, 309, 1, '50', 2, 0, 1, '2021-04-26 06:45:41', '2021-04-26 14:45:41');
INSERT INTO `testcase_result` VALUES (1304, 309, 2, '20', 1, 0, 1, '2021-04-26 06:45:41', '2021-04-26 14:45:41');
INSERT INTO `testcase_result` VALUES (1305, 310, 1, '50', 1, 0, 1, '2021-04-26 06:50:08', '2021-04-26 14:50:07');
INSERT INTO `testcase_result` VALUES (1306, 310, 2, '20', 1, 0, 1, '2021-04-26 06:50:08', '2021-04-26 14:50:07');
INSERT INTO `testcase_result` VALUES (1307, 311, 1, '20', 2, 0, 1, '2021-04-26 06:50:59', '2021-04-26 14:50:59');
INSERT INTO `testcase_result` VALUES (1308, 313, 1, '1\n2\n3\n', 2, 0, 1, '2021-04-26 07:35:22', '2021-04-26 15:35:22');
INSERT INTO `testcase_result` VALUES (1309, 314, 1, '7', 2, 0, 1, '2021-04-26 13:32:46', '2021-04-26 21:32:46');
INSERT INTO `testcase_result` VALUES (1310, 316, 1, 'Tomcat\n', 6, 0, 4, '2021-04-27 09:39:39', '2021-04-27 17:39:39');
INSERT INTO `testcase_result` VALUES (1311, 317, 1, 'best\na\ncat\nday\neast\nfree\n', 5, 0, 1, '2021-04-27 09:40:37', '2021-04-27 17:40:37');
INSERT INTO `testcase_result` VALUES (1312, 318, 1, '', 6, 0, 4, '2021-04-27 09:42:14', '2021-04-27 17:42:13');
INSERT INTO `testcase_result` VALUES (1313, 319, 1, '50', 2, 0, 1, '2021-04-27 09:44:51', '2021-04-27 17:44:51');
INSERT INTO `testcase_result` VALUES (1314, 319, 2, '20', 0, 0, 1, '2021-04-27 09:44:51', '2021-04-27 17:44:51');
INSERT INTO `testcase_result` VALUES (1315, 320, 1, '20', 2, 0, 1, '2021-04-27 09:45:18', '2021-04-27 17:45:18');
INSERT INTO `testcase_result` VALUES (1316, 321, 1, '1\n2\n3\n', 1, 0, 1, '2021-04-27 09:46:11', '2021-04-27 17:46:10');
INSERT INTO `testcase_result` VALUES (1317, 322, 1, 'sh: pause: 未找到命令\n321', 0, 0, 7, '2021-04-27 10:46:03', '2021-04-27 18:46:03');
INSERT INTO `testcase_result` VALUES (1318, 323, 1, '321', 3, 0, 1, '2021-04-27 10:51:08', '2021-04-27 18:51:08');
INSERT INTO `testcase_result` VALUES (1319, 324, 1, '12', 2, 0, 1, '2021-04-27 11:03:52', '2021-04-27 19:03:52');
INSERT INTO `testcase_result` VALUES (1320, 325, 1, 'c 88 2.12 4.70', 2, 0, 1, '2021-04-27 11:05:39', '2021-04-27 19:05:38');
INSERT INTO `testcase_result` VALUES (1321, 326, 1, '9:11 PM', 2, 0, 1, '2021-04-27 11:06:42', '2021-04-27 19:06:42');
INSERT INTO `testcase_result` VALUES (1322, 327, 1, 'Speed: 40 - OK', 2, 0, 1, '2021-04-27 11:07:06', '2021-04-27 19:07:06');
INSERT INTO `testcase_result` VALUES (1323, 327, 2, 'Speed: 75 - Speeding', 2, 0, 1, '2021-04-27 11:07:06', '2021-04-27 19:07:06');
INSERT INTO `testcase_result` VALUES (1324, 328, 1, 'C', 2, 0, 1, '2021-04-27 11:07:39', '2021-04-27 19:07:39');
INSERT INTO `testcase_result` VALUES (1325, 329, 1, 'sh: pause: 未找到命令\n1650.00', 0, 0, 7, '2021-04-27 11:08:03', '2021-04-27 19:08:02');
INSERT INTO `testcase_result` VALUES (1326, 329, 2, 'sh: pause: 未找到命令\n2000.00', 0, 0, 7, '2021-04-27 11:08:03', '2021-04-27 19:08:02');
INSERT INTO `testcase_result` VALUES (1327, 330, 1, 'sh: pause: 未找到命令\n1650.00', 2, 0, 7, '2021-04-27 11:08:14', '2021-04-27 19:08:13');
INSERT INTO `testcase_result` VALUES (1328, 330, 2, 'sh: pause: 未找到命令\n2000.00', 2, 0, 7, '2021-04-27 11:08:14', '2021-04-27 19:08:13');
INSERT INTO `testcase_result` VALUES (1329, 331, 1, '1650.00', 1, 0, 1, '2021-04-27 11:08:19', '2021-04-27 19:08:19');
INSERT INTO `testcase_result` VALUES (1330, 331, 2, '2000.00', 1, 0, 1, '2021-04-27 11:08:19', '2021-04-27 19:08:19');
INSERT INTO `testcase_result` VALUES (1331, 332, 1, '16.00', 1377, 34056, 1, '2021-04-27 11:44:07', '2021-04-27 19:44:08');
INSERT INTO `testcase_result` VALUES (1332, 332, 2, '22.50', 1360, 34468, 1, '2021-04-27 11:44:07', '2021-04-27 19:44:08');
INSERT INTO `testcase_result` VALUES (1333, 333, 1, '-3', 0, 0, 1, '2021-04-27 11:45:00', '2021-04-27 19:45:00');
INSERT INTO `testcase_result` VALUES (1334, 333, 2, 'ERROR', 2, 0, 1, '2021-04-27 11:45:00', '2021-04-27 19:45:00');
INSERT INTO `testcase_result` VALUES (1335, 334, 1, '   -3   -2   -1    0    1\n    2    3    4    5    6\n    7    8\nSum = 30', 0, 0, 1, '2021-04-27 11:49:22', '2021-04-27 19:49:22');
INSERT INTO `testcase_result` VALUES (1336, 335, 1, '3.132157\n', 0, 0, 1, '2021-04-27 11:49:54', '2021-04-27 19:49:54');
INSERT INTO `testcase_result` VALUES (1337, 336, 1, '234 235 243 245 253 254\n324 325 342 345 352 354\n423 425 432 435 452 453\n523 524 532 534 542 543\n', 0, 0, 1, '2021-04-27 11:50:42', '2021-04-27 19:50:42');
INSERT INTO `testcase_result` VALUES (1338, 337, 1, '1*1=1   \n1*2=2   2*2=4   \n1*3=3   2*3=6   3*3=9   \n1*4=4   2*4=8   3*4=12  4*4=16  \n', 0, 0, 1, '2021-04-27 11:51:22', '2021-04-27 19:51:22');
INSERT INTO `testcase_result` VALUES (1339, 338, 1, '@_@ 726', 0, 0, 1, '2021-04-27 11:51:44', '2021-04-27 19:51:44');
INSERT INTO `testcase_result` VALUES (1340, 339, 1, '50', 3, 0, 1, '2021-05-06 08:21:12', '2021-05-06 16:21:11');
INSERT INTO `testcase_result` VALUES (1341, 339, 2, '20', 5, 0, 1, '2021-05-06 08:21:12', '2021-05-06 16:21:11');
INSERT INTO `testcase_result` VALUES (1342, 340, 1, '-10', 2, 0, 7, '2021-05-06 08:21:19', '2021-05-06 16:21:18');
INSERT INTO `testcase_result` VALUES (1343, 340, 2, '0', 2, 0, 7, '2021-05-06 08:21:19', '2021-05-06 16:21:18');
INSERT INTO `testcase_result` VALUES (1344, 341, 1, '50', 5, 0, 1, '2021-05-20 09:22:10', '2021-05-20 17:22:10');
INSERT INTO `testcase_result` VALUES (1345, 341, 2, '20', 1, 0, 1, '2021-05-20 09:22:10', '2021-05-20 17:22:10');
INSERT INTO `testcase_result` VALUES (1346, 342, 1, '1\n2\n3\n', 2, 0, 1, '2021-05-20 12:29:37', '2021-05-20 20:29:36');
INSERT INTO `testcase_result` VALUES (1347, 343, 1, '1\n2\n3\n', 2, 0, 1, '2021-05-20 12:31:51', '2021-05-20 20:31:50');
INSERT INTO `testcase_result` VALUES (1348, 346, 1, '1\n2\n3\n', 2, 0, 1, '2021-05-20 12:53:03', '2021-05-20 20:53:03');
INSERT INTO `testcase_result` VALUES (1349, 347, 1, '50', 2, 0, 1, '2021-05-20 12:53:59', '2021-05-20 20:53:58');
INSERT INTO `testcase_result` VALUES (1350, 347, 2, '20', 1, 0, 1, '2021-05-20 12:53:59', '2021-05-20 20:53:58');
INSERT INTO `testcase_result` VALUES (1351, 348, 1, '12', 5, 0, 1, '2021-05-27 09:42:15', '2021-05-27 17:42:14');
INSERT INTO `testcase_result` VALUES (1352, 349, 1, '50', 1, 0, 1, '2021-05-28 02:21:20', '2021-05-28 10:21:19');
INSERT INTO `testcase_result` VALUES (1353, 349, 2, '20', 0, 0, 1, '2021-05-28 02:21:20', '2021-05-28 10:21:19');
INSERT INTO `testcase_result` VALUES (1354, 350, 1, '50', 2, 0, 1, '2021-05-28 07:58:55', '2021-05-28 15:58:54');
INSERT INTO `testcase_result` VALUES (1355, 350, 2, '20', 2, 0, 1, '2021-05-28 07:58:55', '2021-05-28 15:58:54');

-- ----------------------------
-- Table structure for up
-- ----------------------------
DROP TABLE IF EXISTS `up`;
CREATE TABLE `up`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type_id` int(11) NULL DEFAULT NULL COMMENT '博客或评论的id',
  `type` int(11) NULL DEFAULT NULL COMMENT '0博客1评论',
  `user_id` int(11) NULL DEFAULT NULL,
  `status` tinyint(1) NULL DEFAULT 1 COMMENT '1已赞0取消',
  `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0),
  `update_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0),
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 71 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of up
-- ----------------------------
INSERT INTO `up` VALUES (35, 43, 1, 1, 0, '2019-02-01 02:17:40', '2019-02-01 13:22:44');
INSERT INTO `up` VALUES (36, 41, 1, 1, 1, '2019-02-01 02:17:43', '2019-02-16 00:56:36');
INSERT INTO `up` VALUES (37, 42, 1, 1, 1, '2019-02-01 02:17:43', '2019-02-16 00:56:37');
INSERT INTO `up` VALUES (38, 11, 0, 1, 1, '2019-02-01 02:17:44', '2019-02-16 00:56:34');
INSERT INTO `up` VALUES (39, 11, 0, 2, 0, '2019-02-01 02:18:18', '2019-02-01 02:25:37');
INSERT INTO `up` VALUES (40, 41, 1, 2, 0, '2019-02-01 02:25:42', '2019-02-01 13:22:04');
INSERT INTO `up` VALUES (41, 42, 1, 2, 0, '2019-02-01 02:25:43', '2019-02-01 13:22:02');
INSERT INTO `up` VALUES (42, 43, 1, 2, 0, '2019-02-01 02:25:43', '2019-02-01 13:22:03');
INSERT INTO `up` VALUES (57, 8, 0, 1, 0, '2019-02-13 15:31:33', '2019-02-13 15:31:38');

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(25) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '账号',
  `password` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '密码',
  `name` varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '昵称',
  `mood` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '心情',
  `avatar` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '头像',
  `flag` int(11) NULL DEFAULT 0 COMMENT '0　已激活　1冻结　2　已删除',
  `sex` char(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '性别',
  `email` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '邮箱',
  `phone` varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '手机',
  `school` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '学校',
  `sign_count` int(11) NULL DEFAULT 0 COMMENT '签到次数',
  `submit_count` int(11) NULL DEFAULT 0 COMMENT '提交次数',
  `solution_count` int(11) NULL DEFAULT 0 COMMENT '解决问题数',
  `ac_count` int(11) NULL DEFAULT 0 COMMENT '通过次数',
  `tle_count` int(11) NULL DEFAULT 0 COMMENT '超时次数',
  `pe_count` int(11) NULL DEFAULT 0 COMMENT '格式错误次数',
  `me_count` int(11) NULL DEFAULT 0 COMMENT '内存超限次数',
  `ce_count` int(11) NULL DEFAULT 0 COMMENT '编译错误次数',
  `re_count` int(11) NULL DEFAULT 0 COMMENT '运行时错误次数',
  `wa_count` int(11) NULL DEFAULT 0 COMMENT '答案错误次数',
  `gold_count` int(11) NULL DEFAULT 0 COMMENT '金币数',
  `rating` int(11) NULL DEFAULT 0 COMMENT '评级',
  `last_login_time` datetime(0) NULL DEFAULT NULL COMMENT '最后登录时间',
  `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0),
  `update_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0),
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `username`(`username`) USING BTREE,
  UNIQUE INDEX `user_name_uindex`(`name`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 39 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES (36, '465445097@qq.com', '$2a$10$ezeyu3Tbo7F/DZEMZIz.n.8ORC6M92/MIxDklWJqM0Np6UIcGuhce', '刘超', '机遇与挑战并存', '/image/465445097@qq.com/6679f72d-b8e0-4c88-bcef-5c723a276964.jpg', 0, '男', '465445097@qq.com', '15806409818', '青岛工学院', 0, 58, 22, 42, 0, 0, 0, 7, 2, 7, 1, 220, NULL, '2021-04-18 09:27:52', '2021-05-28 15:58:54');
INSERT INTO `user` VALUES (37, '1987556470', '$2a$10$FbrMTobgKK83dl6I4DW/YudaCfzw8.r7ys87FfX0Or.2EMmabSHF2', '1618717843158', '', NULL, 0, '男', '1987556470@qq.com', '', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '2021-04-18 11:50:41', '2021-05-06 10:26:41');
INSERT INTO `user` VALUES (38, '2466155428', '$2a$10$N3QpTu1.e2ziCN8H.Y9bfOW0tzJ1SsTdBYzmuDuSj5Ma9xvH34fDa', '刘广欣', '帅', '/image/2466155428/4ace4dc0-23dc-49d0-924e-ba2e3c297a24.jpg', 0, '男', '2466155428@qq.com', '111111111111', '青岛工学院', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '2021-04-24 16:49:35', '2021-04-24 16:51:55');

-- ----------------------------
-- Table structure for user_role
-- ----------------------------
DROP TABLE IF EXISTS `user_role`;
CREATE TABLE `user_role`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NULL DEFAULT NULL COMMENT '用户id',
  `role_id` int(11) NULL DEFAULT NULL COMMENT '角色id',
  `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0),
  `update_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0),
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 113 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of user_role
-- ----------------------------
INSERT INTO `user_role` VALUES (6, 33, 1, '2019-03-17 20:57:39', '2019-03-17 20:57:39');
INSERT INTO `user_role` VALUES (18, 2, 2, '2019-03-17 22:10:30', '2019-03-17 22:10:30');
INSERT INTO `user_role` VALUES (41, 34, 2, '2019-03-18 00:18:38', '2019-03-18 00:18:38');
INSERT INTO `user_role` VALUES (47, 3, 2, '2019-03-23 23:36:22', '2019-03-23 23:36:22');
INSERT INTO `user_role` VALUES (61, 4, 2, '2019-03-23 23:51:55', '2019-03-23 23:51:55');
INSERT INTO `user_role` VALUES (62, 5, 2, '2019-03-23 23:51:58', '2019-03-23 23:51:58');
INSERT INTO `user_role` VALUES (63, 30, 1, '2019-03-23 23:53:09', '2019-03-23 23:53:09');
INSERT INTO `user_role` VALUES (80, 19, 2, '2019-03-24 10:41:30', '2019-03-24 10:41:30');
INSERT INTO `user_role` VALUES (88, 35, 1, '2019-03-24 23:12:20', '2019-03-24 23:12:20');
INSERT INTO `user_role` VALUES (92, 6, 2, '2019-03-24 23:34:34', '2019-03-24 23:34:34');
INSERT INTO `user_role` VALUES (93, 32, 1, '2019-03-24 23:34:43', '2019-03-24 23:34:43');
INSERT INTO `user_role` VALUES (102, 8, 2, '2019-05-02 19:48:53', '2019-05-02 19:48:53');
INSERT INTO `user_role` VALUES (106, 1, 1, '2019-05-02 19:54:28', '2019-05-02 19:59:06');
INSERT INTO `user_role` VALUES (107, 36, 1, '2021-04-18 09:27:52', '2021-04-18 11:22:28');
INSERT INTO `user_role` VALUES (111, 37, 2, '2021-05-06 10:26:48', '2021-05-06 10:26:48');
INSERT INTO `user_role` VALUES (112, 38, 1, '2021-05-09 16:36:07', '2021-05-09 16:36:07');

SET FOREIGN_KEY_CHECKS = 1;