数据库/resc.sql

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

/*
Navicat MySQL Data Transfer

Source Server         : serv
Source Server Version : 50710
Source Host           : localhost:3306
Source Database       : resc

Target Server Type    : MYSQL
Target Server Version : 50710
File Encoding         : 65001

Date: 2016-11-29 21:09:13
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for competitionawards
-- ----------------------------
DROP TABLE IF EXISTS `competitionawards`;
CREATE TABLE `competitionawards` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `awardName` varchar(255) DEFAULT NULL,
  `createTime` datetime DEFAULT NULL,
  `isDelete` int(11) NOT NULL,
  `mechanism` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `type` varchar(255) DEFAULT NULL,
  `winFileName` varchar(255) DEFAULT NULL,
  `winFileUrl` varchar(255) DEFAULT NULL,
  `winningTime` datetime DEFAULT NULL,
  `zhengshu` varchar(255) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FK_aidkgb2ju7nvmjq1wfb1jje1` (`user_id`),
  CONSTRAINT `FK_aidkgb2ju7nvmjq1wfb1jje1` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of competitionawards
-- ----------------------------
INSERT INTO `competitionawards` VALUES ('3', '33', '2016-11-27 23:55:48', '2', '33', '33', '33', null, 'D:/my/upload/0af78320ab0811e648e5023b1d002ca42.jpg', '2016-11-18 00:00:00', '33', '2');
INSERT INTO `competitionawards` VALUES ('4', '223', '2016-11-28 23:29:20', '2', '223', '223', '223', null, 'D:/my/upload/0af78320ab0811e648e5023b1d002ca42.jpg', '2016-11-08 00:00:00', '223', '2');
INSERT INTO `competitionawards` VALUES ('5', '汉字', '2016-11-29 00:56:56', '2', '汉字', '汉字', '汉字', null, 'rootab56c190b58b11e663ab0b4b151c10d8templates_all.zip', '2016-11-16 00:00:00', '汉字', '2');
INSERT INTO `competitionawards` VALUES ('6', '最后一次', '2016-11-29 00:59:00', '2', '最后一次', '最后一次', '最后一次', null, 'D:/my/upload/f5463740b58b11e6ed620b4f9ea7a5f0date9.rar', '2016-11-07 00:00:00', '最后一次', '2');
INSERT INTO `competitionawards` VALUES ('7', '33', '2016-11-29 01:08:11', '2', '33', '33', '33', null, 'D:/my/upload/3e181280b58d11e6abef200c31b4a4bd微信公众平台深度开发Java版v2.0（第一季）完整版视频教程.txt', '2016-11-01 00:00:00', '33', '2');
INSERT INTO `competitionawards` VALUES ('8', '44', '2016-11-29 01:12:17', '2', '44', '44', '44', null, 'D:/my/upload/d0bfb660b58d11e682b416b2f7e11c4edate9.rar', '2016-10-31 00:00:00', '44', '2');
INSERT INTO `competitionawards` VALUES ('9', '55', '2016-11-29 01:30:36', '2', '55', '55', '55', null, 'D:/my/upload/5fd63250b59011e682b416b2f7e11c4ecpts_434_st.zip', '2016-11-22 00:00:00', '55', '2');
INSERT INTO `competitionawards` VALUES ('10', 'vvvvvvvvv', '2016-11-29 01:32:14', '2', 'vvvvv', 'vvvvvv', 'vvvv', null, '\\upload\\b44aae10b59011e682b416b2f7e11c4edate9.rar', '2016-11-07 00:00:00', 'vv', '2');
INSERT INTO `competitionawards` VALUES ('11', 'vvvvvvvvv', '2016-11-29 01:32:14', '2', 'vvvvv', 'vvvvvv', 'vvvv', '', '\\upload\\b44aae10b59011e682b416b2f7e11c4edate9.rar', null, null, '2');
INSERT INTO `competitionawards` VALUES ('12', 'vvvvvvvvv', '2016-11-29 01:32:14', '2', 'vvvvv', 'vvvvvv', 'vvvv', '', '\\upload\\b44aae10b59011e682b416b2f7e11c4edate9.rar', null, null, '2');
INSERT INTO `competitionawards` VALUES ('13', 'vvvvvvvvv', '2016-11-29 01:32:14', '2', 'vvvvv', 'vvvvvv', 'vvvv', '', '\\upload\\b44aae10b59011e682b416b2f7e11c4edate9.rar', null, null, '2');
INSERT INTO `competitionawards` VALUES ('14', 'vvvvvvvvv', '2016-11-29 01:32:14', '2', 'vvvvv', 'vvvvvv', 'vvvv', '', '\\upload\\b44aae10b59011e682b416b2f7e11c4edate9.rar', null, null, '2');
INSERT INTO `competitionawards` VALUES ('15', 'vvvvvvvvv', '2016-11-29 01:32:14', '2', 'vvvvv', 'vvvvvv', 'vvvv', '', '\\upload\\b44aae10b59011e682b416b2f7e11c4edate9.rar', null, null, '2');
INSERT INTO `competitionawards` VALUES ('16', 'vvvvvvvvv', '2016-11-29 01:32:14', '2', 'vvvvv', 'vvvvvv', 'vvvv', '', '\\upload\\b44aae10b59011e682b416b2f7e11c4edate9.rar', null, null, '2');
INSERT INTO `competitionawards` VALUES ('17', 'vvvvvvvvv', '2016-11-29 01:32:14', '2', 'vvvvv', 'vvvvvv', 'vvvv', '', '\\upload\\b44aae10b59011e682b416b2f7e11c4edate9.rar', null, null, '2');
INSERT INTO `competitionawards` VALUES ('18', 'vvvvvvvvv', '2016-11-29 01:32:14', '2', 'vvvvv', 'vvvvvv', 'vvvv', '', '\\upload\\b44aae10b59011e682b416b2f7e11c4edate9.rar', null, null, '2');
INSERT INTO `competitionawards` VALUES ('19', 'vvvvvvvvv', '2016-11-29 01:32:14', '2', 'vvvvv', 'vvvvvv', 'vvvv', '', '\\upload\\b44aae10b59011e682b416b2f7e11c4edate9.rar', null, null, '2');
INSERT INTO `competitionawards` VALUES ('20', 'vvvvvvvvv', '2016-11-29 01:32:14', '2', 'vvvvv', 'vvvvvv', 'vvvv', '', '\\upload\\b44aae10b59011e682b416b2f7e11c4edate9.rar', null, null, '2');