summaryrefslogtreecommitdiffstats
path: root/server/migrations
diff options
context:
space:
mode:
authorJannik Schönartz2018-08-06 03:04:54 +0200
committerJannik Schönartz2018-08-06 03:04:54 +0200
commit311a686f3672a00c8def9190c874d6f83a006e35 (patch)
tree29d05513d8c1e96dca50aae4445845177bbf5d3f /server/migrations
parent[webapp/searchtable] bugfix (diff)
downloadbas-311a686f3672a00c8def9190c874d6f83a006e35.tar.gz
bas-311a686f3672a00c8def9190c874d6f83a006e35.tar.xz
bas-311a686f3672a00c8def9190c874d6f83a006e35.zip
[server/external-backends] Implemented import Objects from iDoIT
renamed external-backends.js in index.js so its return when requireing the folder Added new tables for the external id mapping for clients / groups iDoIT method for importing Objects and adding them in the db with all neccessary constraints
Diffstat (limited to 'server/migrations')
-rw-r--r--server/migrations/20180715193710-create-backend.js4
-rw-r--r--server/migrations/20180805054700-create-backend_x_client.js38
-rw-r--r--server/migrations/20180805054700-create-backend_x_group.js38
3 files changed, 78 insertions, 2 deletions
diff --git a/server/migrations/20180715193710-create-backend.js b/server/migrations/20180715193710-create-backend.js
index 98f5476..18b324b 100644
--- a/server/migrations/20180715193710-create-backend.js
+++ b/server/migrations/20180715193710-create-backend.js
@@ -19,12 +19,12 @@ module.exports = {
type: Sequelize.STRING(2048),
defaultValue: '[]'
},
- groups: {
+ groupTypes: {
allowNull: false,
type: Sequelize.STRING(4096),
defaultValue: '[]'
},
- clients: {
+ clientTypes: {
allowNull: false,
type: Sequelize.STRING(4096),
defaultValue: '[]'
diff --git a/server/migrations/20180805054700-create-backend_x_client.js b/server/migrations/20180805054700-create-backend_x_client.js
new file mode 100644
index 0000000..ce2c3fe
--- /dev/null
+++ b/server/migrations/20180805054700-create-backend_x_client.js
@@ -0,0 +1,38 @@
+'use strict'
+module.exports = {
+ up: (queryInterface, Sequelize) => {
+ return queryInterface.createTable('backend_x_client', {
+ backendId: {
+ primaryKey: true,
+ allowNull: false,
+ type: Sequelize.INTEGER,
+ onDelete: 'cascade',
+ references: {
+ model: 'backends',
+ key: 'id'
+ }
+ },
+ clientId: {
+ allowNull: true,
+ type: Sequelize.INTEGER,
+ onDelete: 'SET NULL',
+ references: {
+ model: 'clients',
+ key: 'id'
+ }
+ },
+ externalId: {
+ primaryKey: true,
+ allowNull: true,
+ type: Sequelize.INTEGER
+ },
+ externalType: {
+ allowNull: true,
+ type: Sequelize.STRING
+ }
+ })
+ },
+ down: (queryInterface, Sequelize) => {
+ return queryInterface.dropTable('backend_x_client')
+ }
+}
diff --git a/server/migrations/20180805054700-create-backend_x_group.js b/server/migrations/20180805054700-create-backend_x_group.js
new file mode 100644
index 0000000..d187e24
--- /dev/null
+++ b/server/migrations/20180805054700-create-backend_x_group.js
@@ -0,0 +1,38 @@
+'use strict'
+module.exports = {
+ up: (queryInterface, Sequelize) => {
+ return queryInterface.createTable('backend_x_group', {
+ backendId: {
+ primaryKey: true,
+ allowNull: false,
+ type: Sequelize.INTEGER,
+ onDelete: 'cascade',
+ references: {
+ model: 'backends',
+ key: 'id'
+ }
+ },
+ groupId: {
+ allowNull: true,
+ type: Sequelize.INTEGER,
+ onDelete: 'SET NULL',
+ references: {
+ model: 'groups',
+ key: 'id'
+ }
+ },
+ externalId: {
+ primaryKey: true,
+ allowNull: true,
+ type: Sequelize.INTEGER
+ },
+ externalType: {
+ allowNull: true,
+ type: Sequelize.STRING
+ }
+ })
+ },
+ down: (queryInterface, Sequelize) => {
+ return queryInterface.dropTable('backend_x_group')
+ }
+}