+----+----------+------------+-----------------+----------+------------+-----------+
| id | username | password   | customerID      | realName | realFamily | legalName |
+----+----------+------------+-----------------+----------+------------+-----------+
|  1 | admin    | adminadmin | 000000000000000 | NULL     | NULL       | admin     |
+----+----------+------------+-----------------+----------+------------+-----------+

var databaseName = 'mydb';

var knex = require('knex')({
    client: 'mysql',
    connection: {
        host     : '127.0.0.1',
        user     : 'root',
        password : 'root',
        database : databaseName,
        charset  : 'utf8'
  }
});
var Bookshelf = require('bookshelf')(knex);

var _ = require('lodash');
var express = require('express');
var app = express();
var bodyParser = require('body-parser');
// application routing
var router = express.Router();

// for forms

// body-parser middleware for handling request variables
app.use(bodyParser.urlencoded({extended: true}));
app.use(bodyParser.json());

/*
 *   Models
**/

// User model
var User = Bookshelf.Model.extend({
  tableName: 'user',

  device: function () {
    return this.belongsTo(device);
  },

  hasTimestamps: false,
});


var Users = Bookshelf.Collection.extend({
  model: User
});

/*
### Users
 - `GET    /users`    - fetch all users
 - `POST   /user`     - create a new user
 - `GET    /user/:id` - fetch a single user
 - `PUT    /user/:id` - update user
 - `DELETE /user/:id` - delete user


*/


router.route('/users')
  // fetch all users
  .get(function (req, res) {
    Users.forge()
    .fetch()
    .then(function (collection) {
      res.json({error: false, data: collection.toJSON()});
    })
    .catch(function (err) {
      res.status(500).json({error: true, data: {message: err.message}});
    });
  })


   //create a user
   .post(function (req, res) {
     User.forge({
       username: req.body.username,
       password: req.body.password,
       customerID: req.body.customerID,
       realName: req.body.realName,
       realFamily: req.body.realFamily,
       legalName: req.body.legalName,
     })
     .save()
     .then(function (user) {
       res.json({error: false, data: user.toJSON()});
     })
     .catch(function (err) {
       res.status(500).json({error: true, data: {message: err.message}});
     });
   });

  app.use('/api', router);

  app.listen(3002, function() {
    console.log("✔ Express server listening on port %d in %s mode", 3002, app.get('env'));
  });

+----+----------+----------+------------+----------+------------+-----------+
| id | username | password | customerID | realName | realFamily | legalName |
+----+----------+----------+------------+----------+------------+-----------+
|  2 |          |          | NULL       | NULL     | NULL       | NULL      |
+----+----------+----------+------------+----------+------------+-----------+

var username=req.body.user;
  var password=req.body.password;
  console.log("User name after = "+username+", password is "+password);