1 files changed, 22 insertions, 0 deletions

diff --git a/database/migrations/1566554359294_workspace_schema.ts b/database/migrations/1566554359294_workspace_schema.ts
new file mode 100644
index 0000000..77e1189
--- /dev/null
+++ b/database/migrations/1566554359294_workspace_schema.ts
@@ -0,0 +1,22 @@
+import BaseSchema from '@ioc:Adonis/Lucid/Schema';
+
+export default class extends BaseSchema {
+  protected tableName = 'workspaces';
+
+  public async up(): Promise<void> {
+    this.schema.createTable(this.tableName, 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();
+    });
+  }
+
+  public async down(): Promise<void> {
+    this.schema.dropTable(this.tableName);
+  }
+}