From 017e8b42d953136140e0ff6d12559b86d1a330d5 Mon Sep 17 00:00:00 2001 From: Bobby Date: Sat, 30 Apr 2022 23:20:29 -0400 Subject: user login api --- interface/models/index.js | 2 ++ interface/models/users.model.js | 20 ++++++++++++++++++++ 2 files changed, 22 insertions(+) create mode 100644 interface/models/users.model.js (limited to 'interface/models') diff --git a/interface/models/index.js b/interface/models/index.js index 852fb65..e799e1e 100644 --- a/interface/models/index.js +++ b/interface/models/index.js @@ -18,7 +18,9 @@ const sequelize = new Sequelize(databaseConfig.database, databaseConfig.username const db = {}; db.Sequelize = Sequelize; db.sequelize = sequelize; +db.users = require('./users.model')(Sequelize, sequelize); db.citizens = require('./citizens.model.js')(Sequelize, sequelize); db.village_master = require('./village_master.model.js')(Sequelize, sequelize); +db.bank_master = require('./bank_master.model.js')(Sequelize, sequelize); module.exports = db; diff --git a/interface/models/users.model.js b/interface/models/users.model.js new file mode 100644 index 0000000..df8b276 --- /dev/null +++ b/interface/models/users.model.js @@ -0,0 +1,20 @@ +module.exports = (Sequelize, sequelize) => { + const Users = sequelize.define("users", { + user_id: { + type: Sequelize.INTEGER, + allowNull: false, + primaryKey: true, + autoIncrement: true, + }, + username: { + type: Sequelize.STRING(155), + allowNull: false, + unique: true, + }, + password: { + type: Sequelize.STRING(155), + allowNull: false, + } + }); + return Users; +} \ No newline at end of file -- cgit v1.2.3