类型错误:mssql.架构不是构造函数

Question

由于我是reactJS的新手，请有人帮助我解决以下问题。下面的代码是学习教程中的参考。我试了很多办法想把它修好，但没有成功。

以下是User.js文件中的代码：

const mssql = require("mssql");
const UserSchema = new mssql.Schema({
username:{
type:String,
require:true,
min:3,
max:50,
unique:true,
},
email: {
type: String,
required: true,
max: 50,
unique: true,
},
password: {
type: String,
required: true,
min: 6,
},   
},
{timestamps:true}
);
module.exports=mssql.model("User",Schema);

以下是Auth.js文件中的代码：

const router = require("express").Router();
const User = require("../models/User");
//REGISTER
router.get("/register", async (req, res)=>{
const User = await new User({
username:"****",
email:"***",
password:"***"
})
User.save();
});
module.exports=router

我收到的错误：

const UserSchema = new mssql.Schema({
^
TypeError: mssql.Schema is not a constructor
at Object.<anonymous> (C:UsersvadivDesktopLearnReactJSmodelsUser.js:3:20)
at Module._compile (node:internal/modules/cjs/loader:1103:14)
at Object.Module._extensions..js (node:internal/modules/cjs/loader:1157:10)
at Module.load (node:internal/modules/cjs/loader:981:32)
at Function.Module._load (node:internal/modules/cjs/loader:822:12)
at Module.require (node:internal/modules/cjs/loader:1005:19)
at require (node:internal/modules/cjs/helpers:102:18)
at Object.<anonymous> (C:UsersvadivDesktopLearnReactJSroutesauth.js:2:14)
at Module._compile (node:internal/modules/cjs/loader:1103:14)
at Object.Module._extensions..js (node:internal/modules/cjs/loader:1157:10)
[nodemon] app crashed - waiting for file changes before starting...

Answer 1

const mssql = require("mssql");
const UserSchema = new mssql.Schema({
username:{
type:String,
require:true,
min:3,
max:50,
unique:true,
},
email: {
type: String,
required: true,
max: 50,
unique: true,
},
password: {
type: String,
required: true,
min: 6,
},   
},
{timestamps:true}
);
module.exports=mssql.model("User",UserSchema );

简单错误使用此代码