router.post('/:id/add', function(req, res, next) {
    db.getConnection(function(err, conn) {
        var theid = req.params.id;
        var tableName = 'b_ledger_'+id;
        var tableDef = 'CREATE TABLE '+tableName+'
                    (
                    b_ledger_id INT(99) NOT NULL AUTO_INCREMENT,
                    b_ledger_item VARCHAR(9) COLLATE utf8_bin NOT NULL,
                    b_ledger_amount INT(9) NOT NULL,
                    b_ledger_price DECIMAL(15,4) NOT NULL,
                    b_ledger_activity_date DATETIME NOT NULL COMMENT 'Timestamp of activity',
                    b_ledger_users_id INT(9) NOT NULL,
                    PRIMARY KEY (b_ledger_id),
                    KEY b_ledger_blah_fk_users_id (b_ledger_users_id),
                    CONSTRAINT b_ledger_blah_fk_users_id
                    FOREIGN KEY (b_ledger_users_id)
                    REFERENCES b_users (b_users_id) ON DELETE CASCADE
                    ) ENGINE=INNODB DEFAULT CHARSET=utf8 COLLATE=utf8_bin';
        conn.query(tableDef, function(err, rows) {
            if(err) {
                console.log('Error when creating table for id: ' +err);
                res.end();
                conn.release();
            }
            else {
                res.end(rows);
                conn.release();
            }
        })
    })
});