mysql表例子(斗地主): 1.account 2.player 思考mongo是account是在GlobalServer上,游戏Role是在GameServer上创建

sql

/*
Navicat MySQL Data Transfer

Source Server         : localhost
Source Server Version : 50723
Source Host           : localhost:3306
Source Database       : doudizhu

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

Date: 2020-10-17 14:35:24
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for account
-- ----------------------------
DROP TABLE IF EXISTS `account`;
CREATE TABLE `account` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `username` varchar(15) DEFAULT NULL,
  `password` varchar(15) DEFAULT NULL,
  `regTime` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `username` (`username`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for player
-- ----------------------------
DROP TABLE IF EXISTS `player`;
CREATE TABLE `player` (
  `uid` int(10) unsigned NOT NULL,
  `nickname` varchar(15) DEFAULT NULL,
  `gold` int(10) unsigned DEFAULT NULL,
  `loginTime` datetime DEFAULT NULL,
  `regTime` datetime DEFAULT NULL,
  `gameInfo` text,
  PRIMARY KEY (`uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

数据库连接池配置

/**
 * mysql配置
 */
export let mysqlConfig = {
    "host": "127.0.0.1",
    "port": 3306,
    "user": "root",
    "password": "123456",
    "database": "doudizhu",
    "connectionLimit": 5
}

上一篇:ew运算符工作原理(new运算符的伪码实现)


下一篇:读mysql8 CookBook的零碎整理5——mysql 比较好的书籍