Database example

[ahmedcharef]

Aslema Anouar,

Good job for this amazing work ! :D

Could you share an example of database columns.

Thank you 👍

[anouarbensaad]

Aslemaa,
Thank you ahmed, 🙏

---

• Create an empty database;

CREATE DATABASE database_name;

• dump instalogDB.sql file into your database.

mysql -u username -p database_name < instalogDB.sql

• common/common_db.js configuration.

function IGAPIDB(){
	const self = {}
	var pool  = mysql.createPool({
	  connectionLimit : 10,
	  host:     "<YOUR DB HOSTNAME | LOCALHOST>",
	  user:     "<DB USERNAME>",
	  password: "<DB PASSWORD>",
	  database: "<DATABASE_NAME>",
	  charset:  "utf8mb4_unicode_ci"
	});