summaryrefslogtreecommitdiffstats
path: root/server/models
diff options
context:
space:
mode:
authorJannik Schönartz2018-07-02 21:52:25 +0200
committerJannik Schönartz2018-07-02 21:52:25 +0200
commitaa4e552a03657a63922f5cd085431257c183f458 (patch)
treefc8cd63129bb54b06326c11847a9731fe70f1b33 /server/models
downloadbas-aa4e552a03657a63922f5cd085431257c183f458.tar.gz
bas-aa4e552a03657a63922f5cd085431257c183f458.tar.xz
bas-aa4e552a03657a63922f5cd085431257c183f458.zip
[server] Initial commit to add the node server stuff.
Diffstat (limited to 'server/models')
-rw-r--r--server/models/role.js19
-rw-r--r--server/models/user.js21
-rw-r--r--server/models/user_x_role.js20
3 files changed, 60 insertions, 0 deletions
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