sql练习-杀手建表

/*
 Navicat Premium Data Transfer

 Source Server         : phpmysql
 Source Server Type    : MySQL
 Source Server Version : 50726
 Source Host           : localhost:3306
 Source Schema         : demo

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

 Date: 22/08/2020 10:14:34
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;


DROP TABLE IF EXISTS `user1`;
CREATE TABLE `user1`  (
  `id` smallint(5) UNSIGNED NOT NULL AUTO_INCREMENT,
  `user_name` varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `over` varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `mobile` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 5 CHARACTER SET = utf8 COLLATE = utf8_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of user1
-- ----------------------------
INSERT INTO `user1` VALUES (1, '杀手001', '王牌狙击', '18725666565,18725666568,18725666569');
INSERT INTO `user1` VALUES (2, '杀手002', '驾驶高手', '13725666565,13725666568');
INSERT INTO `user1` VALUES (3, '杀手003', '化学天才', '17725666565,17725666568,17725666569,17725666567');
INSERT INTO `user1` VALUES (4, '杀手004', '格斗沙皇', '15725666565,15725666568,15725666569');

-- ----------------------------
-- Table structure for user2
-- ----------------------------
DROP TABLE IF EXISTS `user2`;
CREATE TABLE `user2`  (
  `id` smallint(5) UNSIGNED NOT NULL AUTO_INCREMENT,
  `user_name` varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `over` varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 6 CHARACTER SET = utf8 COLLATE = utf8_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of user2
-- ----------------------------
INSERT INTO `user2` VALUES (1, '杀手001', '王牌狙击');
INSERT INTO `user2` VALUES (2, '目标A', '被降服');
INSERT INTO `user2` VALUES (3, '目标B', '被降服');
INSERT INTO `user2` VALUES (4, '目标C', '被降服');
INSERT INTO `user2` VALUES (5, '目标D', '被降服');

-- ----------------------------
-- Table structure for user_kills
-- ----------------------------
DROP TABLE IF EXISTS `user_kills`;
CREATE TABLE `user_kills`  (
  `id` smallint(5) UNSIGNED NOT NULL AUTO_INCREMENT,
  `user_id` smallint(5) UNSIGNED NULL DEFAULT NULL,
  `timestr` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0),
  `kills` smallint(5) UNSIGNED NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 10 CHARACTER SET = utf8 COLLATE = utf8_unicode_ci ROW_FORMAT = Fixed;

-- ----------------------------
-- Records of user_kills
-- ----------------------------
INSERT INTO `user_kills` VALUES (1, 2, '2013-01-10 00:00:00', 10);
INSERT INTO `user_kills` VALUES (2, 2, '2013-02-01 00:00:00', 2);
INSERT INTO `user_kills` VALUES (3, 2, '2013-02-05 00:00:00', 12);
INSERT INTO `user_kills` VALUES (4, 4, '2013-01-10 00:00:00', 3);
INSERT INTO `user_kills` VALUES (5, 4, '2013-02-11 00:00:00', 5);
INSERT INTO `user_kills` VALUES (6, 2, '2013-02-06 00:00:00', 1);
INSERT INTO `user_kills` VALUES (7, 3, '2013-01-11 00:00:00', 20);
INSERT INTO `user_kills` VALUES (8, 2, '2013-02-12 00:00:00', 10);
INSERT INTO `user_kills` VALUES (9, 3, '2013-02-07 00:00:00', 17);

SET FOREIGN_KEY_CHECKS = 1;