text: -- --------------------------------------------------------
  -- Host:                         127.0.0.1
  -- Server version:               5.7.31 - MySQL Community Server (GPL)
  -- Server OS:                    Win64
  -- HeidiSQL Version:             10.1.0.5464
  -- --------------------------------------------------------
  
  /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  /*!40101 SET NAMES utf8 */;
  /*!50503 SET NAMES utf8mb4 */;
  /*!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' */;
  
  
  -- Dumping database structure for bee_db
  CREATE DATABASE IF NOT EXISTS `bee_db` /*!40100 DEFAULT CHARACTER SET utf8 */;
  USE `bee_db`;
  
  -- Dumping structure for table bee_db.bee
  DROP TABLE IF EXISTS `bee`;
  CREATE TABLE IF NOT EXISTS `bee` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `gameId` int(11) NOT NULL,
    `beeType` tinyint(4) NOT NULL,
    `healthyPoints` smallint(6) NOT NULL,
    `damageRate` smallint(6) NOT NULL,
    `healthyRemain` smallint(6) NOT NULL,
    PRIMARY KEY (`id`),
    KEY `gameId` (`gameId`),
    KEY `beeType` (`beeType`),
    CONSTRAINT `FK_swarm_game` FOREIGN KEY (`gameId`) REFERENCES `game` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
  ) ENGINE=InnoDB AUTO_INCREMENT=141 DEFAULT CHARSET=utf8;
  
  -- Data exporting was unselected.
  -- Dumping structure for table bee_db.game
  DROP TABLE IF EXISTS `game`;
  CREATE TABLE IF NOT EXISTS `game` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `userId` int(11) NOT NULL,
    `ended` int(11) NOT NULL DEFAULT '0',
    `hits` int(11) NOT NULL DEFAULT '0',
    PRIMARY KEY (`id`),
    KEY `userId` (`userId`),
    KEY `ended` (`ended`),
    CONSTRAINT `FK_game_user` FOREIGN KEY (`userId`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
  ) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;
  
  -- Data exporting was unselected.
  -- Dumping structure for table bee_db.user
  DROP TABLE IF EXISTS `user`;
  CREATE TABLE IF NOT EXISTS `user` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `fullName` varchar(50) NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
  
  -- Data exporting was unselected.
  /*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
  /*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
  /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  