Add support for workspaces

2 files changed, 47 insertions, 0 deletions

diff --git a/database/migrations/1566554231482_recipe_schema.js b/database/migrations/1566554231482_recipe_schema.js
new file mode 100644
index 0000000..7d8f5a8
--- /dev/null
+++ b/database/migrations/1566554231482_recipe_schema.js
@@ -0,0 +1,22 @@
+'use strict'
+
+/** @type {import('@adonisjs/lucid/src/Schema')} */
+const Schema = use('Schema')
+
+class RecipeSchema extends Schema {
+  up () {
+    this.create('recipes', (table) => {
+      table.increments()
+      table.string('name', 80).notNullable()
+      table.string('recipeId', 254).notNullable().unique()
+      table.json('data')
+      table.timestamps()
+    })
+  }
+
+  down () {
+    this.drop('recipes')
+  }
+}
+
+module.exports = RecipeSchema
diff --git a/database/migrations/1566554359294_workspace_schema.js b/database/migrations/1566554359294_workspace_schema.js
new file mode 100644
index 0000000..84e0bb9
--- /dev/null
+++ b/database/migrations/1566554359294_workspace_schema.js
@@ -0,0 +1,25 @@
+'use strict'
+
+/** @type {import('@adonisjs/lucid/src/Schema')} */
+const Schema = use('Schema')
+
+class WorkspaceSchema extends Schema {
+  up () {
+    this.create('workspaces', (table) => {
+      table.increments()
+      table.string('workspaceId', 80).notNullable().unique()
+      table.string('userId', 80).notNullable()
+      table.string('name', 80).notNullable()
+      table.integer('order')
+      table.json('services')
+      table.json('data')
+      table.timestamps()
+    })
+  }
+
+  down () {
+    this.drop('workspaces')
+  }
+}
+
+module.exports = WorkspaceSchema