如何在node.js sequelize中使用varchar？

npm install sequelize sequelize-cli mysql2

// models/User.js

const { Sequelize, DataTypes } = require('sequelize');
const sequelize = new Sequelize('database', 'username', 'password', {
  host: 'localhost',
  dialect: 'mysql'
});

const User = sequelize.define('User', {
  name: {
    type: DataTypes.STRING, // 使用varchar类型
    allowNull: false
  },
  email: {
    type: DataTypes.STRING,
    allowNull: false
  }
});

module.exports = User;

// app.js

const User = require('./models/User');

async function main() {
  try {
    await User.sync({ force: true }); // 创建User表

    // 创建用户
    const user = await User.create({ name: 'John Doe', email: 'john@example.com' });
    console.log(user.toJSON());

    // 查询用户
    const users = await User.findAll();
    console.log(users.map(user => user.toJSON()));

    // 更新用户
    await user.update({ name: 'Jane Doe' });
    console.log(user.toJSON());

    // 删除用户
    await user.destroy();
    console.log('User deleted');
  } catch (error) {
    console.error('Error:', error);
  } finally {
    await sequelize.close(); // 关闭数据库连接
  }
}

main();