From aa4e552a03657a63922f5cd085431257c183f458 Mon Sep 17 00:00:00 2001 From: Jannik Schönartz Date: Mon, 2 Jul 2018 19:52:25 +0000 Subject: [server] Initial commit to add the node server stuff. --- server/models/role.js | 19 +++++++++++++++++++ server/models/user.js | 21 +++++++++++++++++++++ server/models/user_x_role.js | 20 ++++++++++++++++++++ 3 files changed, 60 insertions(+) create mode 100644 server/models/role.js create mode 100644 server/models/user.js create mode 100644 server/models/user_x_role.js (limited to 'server/models') diff --git a/server/models/role.js b/server/models/role.js new file mode 100644 index 0000000..35ca139 --- /dev/null +++ b/server/models/role.js @@ -0,0 +1,19 @@ +'use strict'; +module.exports = (sequelize, DataTypes) => { + var role = sequelize.define('role', { + id: { + allowNull: false, + autoIncrement: true, + primaryKey: true, + type: DataTypes.INTEGER + }, + name: DataTypes.STRING, + descr: DataTypes.STRING + }, { + timestamps: false + }); + role.associate = function(models) { + // associations can be defined here + }; + return role; +}; \ No newline at end of file diff --git a/server/models/user.js b/server/models/user.js new file mode 100644 index 0000000..167b5a5 --- /dev/null +++ b/server/models/user.js @@ -0,0 +1,21 @@ +'use strict'; +module.exports = (sequelize, DataTypes) => { + var user = sequelize.define('user', { + id: { + allowNull: false, + autoIncrement: true, + primaryKey: true, + type: DataTypes.INTEGER + }, + username: DataTypes.STRING, + password: DataTypes.STRING, + email: DataTypes.STRING, + name: DataTypes.STRING + }, { + timestamps: false + }); + user.associate = function(models) { + // associations can be defined here + }; + return user; +}; \ No newline at end of file diff --git a/server/models/user_x_role.js b/server/models/user_x_role.js new file mode 100644 index 0000000..86068f0 --- /dev/null +++ b/server/models/user_x_role.js @@ -0,0 +1,20 @@ +'use strict'; +module.exports = (sequelize, DataTypes) => { + var user_x_role = sequelize.define('user_x_role', {}, + { + timestamps: false + }); + + user_x_role.associate = function(models) { + // associations can be defined here + + //sequelize.role.belongsToMany(sequelize.user, {through: 'user_x_role', foreignKey: 'userid'}); + //sequelize.user.hasMany(sequelize.role, { + // through: 'user_x_role', + // foreignKey: 'roleid' + //}); + + + }; + return user_x_role; +}; \ No newline at end of file -- cgit v1.2.3-55-g7522