insert a record in sqliteDB using ionic framework

i tried inserting an record in Sqllite Db and trying to view that in

DB Browser for SQLlite. Error : DB opened: soora.db no such table UserSignIn

I created an DB and a table named 'UserSignIn' and dropped that file into www folder. Iam running this in android platform.

js file:

   .controller('LoginCtrl', function($scope, $state, $cordovaSQLite) {
     $scope.insert = function(username,password,email,mobile) {
            var db =  window.sqlitePlugin.openDatabase({name: "soora.db",createFromLocation: 0});
            db.transaction(function(tx) {                                                                                                                                              
            var query = "INSERT INTO UserSignIn(username, password,email,mobile) VALUES (?,?,?,?)";
                  tx.executeSql(query, [],function(tx,res) {
                    console.log("INSERT ID -> " + res.insertId);
                    $scope.statusMessage = "Data saved successful, cheers!";
                },
                function (err) {
                    $scope.statusMessage = "Error on saving: " + error.message;
                    console.error(err);
                });
            });
        }