数据库连接串配置和建库语句

db.provider.Development.json

  //业务个性化库
  "ConnBsCode": {
    "name": "ConnBs",
    "databaseType": "MySql",
    "providerName": "MySql.Data.MySqlClient",
    "remark": "",
    "read": [
      "Data Source=localhost;Initial Catalog={ownerId}_bs_code;User Id=root;Password=!;charset=utf8"
    ],
    "write": [
      "Data Source=localhost;Initial Catalog={ownerId}_bs_code;User Id=root;Password=!;charset=utf8"
    ]
  },
  //已集成的业务库
  "ConnBs": {
    "name": "ConnBs",
    "databaseType": "MySql",
    "providerName": "MySql.Data.MySqlClient",
    "remark": "",
    "read": [
      "Data Source=localhost;Initial Catalog={ownerId}_auth_bs;User Id=root;Password=!;charset=utf8"
    ],
    "write": [
      "Data Source=localhost;Initial Catalog={ownerId}_auth_bs;User Id=root;Password=!;charset=utf8"
    ]
  },

mysql建库语句

--权限库
CREATE DATABASE `{ownerId}_auth_bo` CHARACTER SET 'utf8';
--常规业务库
CREATE DATABASE `{ownerId}_auth_bs` CHARACTER SET 'utf8';
--操作日志库
CREATE DATABASE `{ownerId}_auth_log_op` CHARACTER SET 'utf8';
--异常日志库
CREATE DATABASE `{ownerId}_auth_log_track` CHARACTER SET 'utf8';
--行为日志库
CREATE DATABASE `{ownerId}_auth_log_ub` CHARACTER SET 'utf8';
--个性化业务库
CREATE DATABASE `{ownerId}_bs_code` CHARACTER SET 'utf8';
--商成库
CREATE DATABASE `{ownerId}_bs_mall` CHARACTER SET 'utf8';
--论坛库
CREATE DATABASE `{ownerId}_bs_bbs` CHARACTER SET 'utf8';