相关的数据表
/*
SQLyog Ultimate v13.1.1 (64 bit)
MySQL - 5.7.26 : Database - test_mysql
*********************************************************************
*/
/*!40101 SET NAMES utf8 */;
/*!40101 SET SQL_MODE=''*/;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
CREATE DATABASE /*!32312 IF NOT EXISTS*/`test_mysql` /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci */;
USE `test_mysql`;
/*Table structure for table `user_kills` */
DROP TABLE IF EXISTS `user_kills`;
CREATE TABLE `user_kills` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL,
`kills` int(2) NOT NULL,
`timestr` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*Data for the table `user_kills` */
insert into `user_kills`(`id`,`user_id`,`kills`,`timestr`) values
(1,2,15,'2013-01-10 00:00:00'),
(2,2,2,'2013-01-02 00:00:00'),
(3,2,12,'2013-02-05 00:00:00'),
(4,4,3,'2013-01-10 00:00:00'),
(5,4,5,'2020-11-12 02:54:05'),
(6,2,1,'2020-11-05 02:54:24'),
(7,3,20,'2020-11-11 02:54:37'),
(8,2,10,'2020-11-11 02:54:54'),
(9,3,17,'2020-11-10 02:55:06'),
(10,3,22,'2020-11-13 04:32:30');
/*Table structure for table `user1` */
DROP TABLE IF EXISTS `user1`;
CREATE TABLE `user1` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_name` char(10) COLLATE utf8_unicode_ci NOT NULL,
`over` char(10) COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*Data for the table `user1` */
insert into `user1`(`id`,`user_name`,`over`) values
(1,'唐曾','功德佛'),
(2,'猪八戒','净坛使者'),
(3,'孙悟空','齐天大圣'),
(4,'沙增','金身罗汉');
/*Table structure for table `user2` */
DROP TABLE IF EXISTS `user2`;
CREATE TABLE `user2` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_name` char(10) COLLATE utf8_unicode_ci NOT NULL,
`over` char(10) COLLATE utf8_unicode_ci DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*Data for the table `user2` */
insert into `user2`(`id`,`user_name`,`over`) values
(1,'孙悟空','成佛'),
(2,'牛魔王',NULL),
(3,'蛟魔王',NULL),
(4,'鹏魔王',NULL),
(5,'狮魔王',NULL);
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;