mybMPXjN

1'use strict';
2/*
3Database name 'webrtcsurveillanceDB'
4
5CREATE TABLE IF NOT EXISTS `controls4` (
6  `id` int(11) NOT NULL AUTO_INCREMENT,
7  `control_name` text NOT NULL,
8  `control_id` varchar(50) NOT NULL,
9  `user_name` varchar(20) NOT NULL,
10  `password` varchar(20) NOT NULL,
11  `email` varchar(50) NOT NULL,
12  `control_url` varchar(50) NOT NULL,
13  `date_created` DATE,
14  CONSTRAINT unique_id PRIMARY KEY (`id`)
15);
16
17*/
18
19var mysql      = require('mysql');
20var connection = mysql.createConnection({
21  host     : 'localhost',
22  user     : 'obinna',
23  password : 'gcamon',
24  database : 'webrtcsurveillanceDB',
25  multipleStatements: true
26});
27
28
29
30connection.connect(function(err){
31	if(!err) {
32	    console.log("Database is connected ... nn");    
33	} else {
34		console.log(err)
35	    console.log("Error connecting database ... nn"); 
36	}
37});
38
39
40module.exports = connection;