1 files changed, 20 insertions, 0 deletions

diff --git a/database/migrations/1503250034279_user.ts b/database/migrations/1503250034279_user.ts
new file mode 100644
index 0000000..262a472
--- /dev/null
+++ b/database/migrations/1503250034279_user.ts
@@ -0,0 +1,20 @@
+import BaseSchema from '@ioc:Adonis/Lucid/Schema';
+
+export default class extends BaseSchema {
+  protected tableName = 'users';
+
+  public async up(): Promise<void> {
+    this.schema.createTable(this.tableName, table => {
+      table.increments();
+      table.string('username', 80).notNullable();
+      table.string('email', 254).notNullable().unique();
+      table.string('password', 60).notNullable();
+      table.json('settings');
+      table.timestamps();
+    });
+  }
+
+  public async down(): Promise<void> {
+    this.schema.dropTable(this.tableName);
+  }
+}