From a77ddf4bf8ad8aeb91e2109a7c4a92149928b57b Mon Sep 17 00:00:00 2001
From: Jules Laplace <julescarbon@gmail.com>
Date: Tue, 29 May 2018 00:15:13 +0200
Subject: adding migrations!!

---
 knexfile.js | 55 +++++++++++++++++++++++++++++++++++++++++++++++++++++++
 1 file changed, 55 insertions(+)
 create mode 100644 knexfile.js

(limited to 'knexfile.js')

diff --git a/knexfile.js b/knexfile.js
new file mode 100644
index 0000000..712d440
--- /dev/null
+++ b/knexfile.js
@@ -0,0 +1,55 @@
+require('dotenv').load()
+
+module.exports = {
+
+  development: {
+    client: 'mysql2',
+    connection: {
+      database: process.env.DB_NAME,
+      user:     process.env.DB_USER,
+      password: process.env.DB_PASS
+    },
+    pool: {
+      min: 2,
+      max: 10
+    },
+    migrations: {
+      tableName: 'knex_migrations'
+    }
+  },
+
+  staging: {
+    client: 'mysql2',
+    connection: {
+      database: process.env.DB_NAME,
+      user:     process.env.DB_USER,
+      password: process.env.DB_PASS
+    },
+    pool: {
+      min: 2,
+      max: 10
+    },
+    migrations: {
+      tableName: 'knex_migrations'
+    }
+  },
+
+  production: {
+    client: 'mysql2',
+    connection: {
+      database: process.env.DB_NAME,
+      user:     process.env.DB_USER,
+      password: process.env.DB_PASS
+    },
+    pool: {
+      min: 2,
+      max: 10
+    },
+    migrations: {
+      tableName: 'knex_migrations'
+    }
+  }
+
+};
+
+
-- 
cgit v1.2.3-70-g09d2