summaryrefslogtreecommitdiffstats
path: root/server/migrations/20180717132333-create-client.js
diff options
context:
space:
mode:
Diffstat (limited to 'server/migrations/20180717132333-create-client.js')
-rw-r--r--server/migrations/20180717132333-create-client.js28
1 files changed, 28 insertions, 0 deletions
diff --git a/server/migrations/20180717132333-create-client.js b/server/migrations/20180717132333-create-client.js
new file mode 100644
index 0000000..79552c4
--- /dev/null
+++ b/server/migrations/20180717132333-create-client.js
@@ -0,0 +1,28 @@
+'use strict'
+module.exports = {
+ up: (queryInterface, Sequelize) => {
+ return queryInterface.createTable('clients', {
+ id: {
+ allowNull: false,
+ autoIncrement: true,
+ primaryKey: true,
+ type: Sequelize.INTEGER
+ },
+ name: {
+ type: Sequelize.STRING
+ },
+ ip: {
+ type: Sequelize.STRING
+ },
+ mac: {
+ type: Sequelize.STRING
+ },
+ uuid: {
+ type: Sequelize.STRING
+ }
+ })
+ },
+ down: (queryInterface, Sequelize) => {
+ return queryInterface.dropTable('clients')
+ }
+}