Initial commit

5 files changed, 89 insertions, 0 deletions

diff --git a/database/adonis.sqlite b/database/adonis.sqlite
new file mode 100644
index 0000000..9042fc9
--- /dev/null
+++ b/database/adonis.sqlite
diff --git a/database/factory.js b/database/factory.js
new file mode 100644
index 0000000..16b5084
--- /dev/null
+++ b/database/factory.js
@@ -0,0 +1,21 @@
+'use strict'
+
+/*
+|--------------------------------------------------------------------------
+| Factory
+|--------------------------------------------------------------------------
+|
+| Factories are used to define blueprints for database tables or Lucid
+| models. Later you can use these blueprints to seed your database
+| with dummy data.
+|
+*/
+
+/** @type {import('@adonisjs/lucid/src/Factory')} */
+// const Factory = use('Factory')
+
+// Factory.blueprint('App/Models/User', (faker) => {
+//   return {
+//     username: faker.username()
+//   }
+// })
diff --git a/database/migrations/1503250034279_user.js b/database/migrations/1503250034279_user.js
new file mode 100644
index 0000000..9148593
--- /dev/null
+++ b/database/migrations/1503250034279_user.js
@@ -0,0 +1,22 @@
+'use strict'
+
+/** @type {import('@adonisjs/lucid/src/Schema')} */
+const Schema = use('Schema')
+
+class UserSchema extends Schema {
+  up () {
+    this.create('users', (table) => {
+      table.increments()
+      table.string('username', 80).notNullable()
+      table.string('email', 254).notNullable().unique()
+      table.string('password', 60).notNullable()
+      table.timestamps()
+    })
+  }
+
+  down () {
+    this.drop('users')
+  }
+}
+
+module.exports = UserSchema
diff --git a/database/migrations/1503250034280_token.js b/database/migrations/1503250034280_token.js
new file mode 100644
index 0000000..c8bb9fc
--- /dev/null
+++ b/database/migrations/1503250034280_token.js
@@ -0,0 +1,23 @@
+'use strict'
+
+/** @type {import('@adonisjs/lucid/src/Schema')} */
+const Schema = use('Schema')
+
+class TokensSchema extends Schema {
+  up () {
+    this.create('tokens', (table) => {
+      table.increments()
+      table.integer('user_id').unsigned().references('id').inTable('users')
+      table.string('token', 255).notNullable().unique().index()
+      table.string('type', 80).notNullable()
+      table.boolean('is_revoked').defaultTo(false)
+      table.timestamps()
+    })
+  }
+
+  down () {
+    this.drop('tokens')
+  }
+}
+
+module.exports = TokensSchema
diff --git a/database/migrations/1566385379883_service_schema.js b/database/migrations/1566385379883_service_schema.js
new file mode 100644
index 0000000..bdc066e
--- /dev/null
+++ b/database/migrations/1566385379883_service_schema.js
@@ -0,0 +1,23 @@
+'use strict'
+
+/** @type {import('@adonisjs/lucid/src/Schema')} */
+const Schema = use('Schema')
+
+class ServiceSchema extends Schema {
+  up () {
+    this.create('services', (table) => {
+      table.increments()
+      table.string('userId', 80).notNullable()
+      table.string('name', 80).notNullable()
+      table.string('recipeId', 254).notNullable()
+      table.json('settings')
+      table.timestamps()
+    })
+  }
+
+  down () {
+    this.drop('services')
+  }
+}
+
+module.exports = ServiceSchema