Add lastname column to User DB table and update API logic to save,return and update this data.

1 files changed, 20 insertions, 0 deletions

diff --git a/database/migrations/1612629845398_users_update_schema.js b/database/migrations/1612629845398_users_update_schema.js
new file mode 100644
index 0000000..d07f66d
--- /dev/null
+++ b/database/migrations/1612629845398_users_update_schema.js
@@ -0,0 +1,20 @@
+'use strict'
+
+/** @type {import('@adonisjs/lucid/src/Schema')} */
+const Schema = use('Schema')
+
+class UsersUpdateSchema extends Schema {
+    up() {
+        this.table('users', (table) => {
+            table.string('lastname', 80).notNullable().default('');
+        })
+    }
+
+    down() {
+        this.table('users', (table) => {
+            table.dropColumn('lastname')
+        })
+    }
+}
+
+module.exports = UsersUpdateSchema
\ No newline at end of file