1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
|
const { DataTypes } = require("sequelize"); // from npm registry
module.exports = {
fields: {
charId: {
type: DataTypes.INTEGER.UNSIGNED,
primaryKey: true,
allowNull: false,
},
name: {
type: DataTypes.STRING,
primaryKey: true,
allowNull: false,
},
value: {
type: DataTypes.INTEGER,
allowNull: false,
defaultValue: 0,
},
},
options: {
engine: "InnoDB",
indexes: [
{ fields: ["char_id"] },
],
}
};
|