diff options
Diffstat (limited to 'db')
| -rw-r--r-- | db/index.js | 1 | ||||
| -rw-r--r-- | db/models/codes.js | 31 |
2 files changed, 32 insertions, 0 deletions
diff --git a/db/index.js b/db/index.js index 4142de33..1b4cc0e4 100644 --- a/db/index.js +++ b/db/index.js @@ -9,6 +9,7 @@ db = new Sequelize(conf.database, conf.username, conf.password, { }); require("./models/accounts.js"); +require("./models/codes.js"); require("./models/invoices.js"); require("./models/keys.js"); require("./models/payments.js"); diff --git a/db/models/codes.js b/db/models/codes.js new file mode 100644 index 00000000..9d967d11 --- /dev/null +++ b/db/models/codes.js @@ -0,0 +1,31 @@ +const { DataTypes } = require('sequelize'); + +const attributes = { + code: { + type: DataTypes.STRING(64), + allowNull: false, + defaultValue: null, + primaryKey: true, + autoIncrement: true, + comment: null, + field: "code" + }, + text: { + type: DataTypes.TEXT, + allowNull: true, + defaultValue: null, + primaryKey: false, + autoIncrement: false, + comment: null, + field: "text" + }, +}; + +const options = { + tableName: "codes", + comment: "", + indexes: [], + timestamps: false +}; + +db["Code"] = db.define("codes_model", attributes, options); |
