1 files changed, 21 insertions, 0 deletions

diff --git a/database/migrations/1566385379883_service_schema.ts b/database/migrations/1566385379883_service_schema.ts
new file mode 100644
index 0000000..9c3e23d
--- /dev/null
+++ b/database/migrations/1566385379883_service_schema.ts
@@ -0,0 +1,21 @@
+import BaseSchema from '@ioc:Adonis/Lucid/Schema';
+
+export default class extends BaseSchema {
+  protected tableName = 'services';
+
+  public async up(): Promise<void> {
+    this.schema.createTable(this.tableName, table => {
+      table.increments();
+      table.string('userId', 80).notNullable();
+      table.string('serviceId', 80).notNullable();
+      table.string('name', 80).notNullable();
+      table.string('recipeId', 254).notNullable();
+      table.json('settings');
+      table.timestamps();
+    });
+  }
+
+  public async down(): Promise<void> {
+    this.schema.dropTable(this.tableName);
+  }
+}