Notes

if(window.cordova){
var db = $rootScope.db = $cordovaSQLite.openDB({ name: "my.db", location: "default" });
}else{
var db = $rootScope.db = window.openDatabase('my.db','','my.db',1000*1000*10);
}


db.transaction(function(tx){
$cordovaSQLite.execute(db,"DROP TABLE IF EXISTS boxes");
$cordovaSQLite.execute(db,"DROP TABLE IF EXISTS storages");
$cordovaSQLite.execute(db,"CREATE TABLE IF NOT EXISTS storages (id_storage integer primary key, name_storage text, picture text)");
$cordovaSQLite.execute(db,"CREATE TABLE IF NOT EXISTS boxes (id_box integer primary key, box_tags text, id_storage integer, box_name text)");
$cordovaSQLite.execute(db,"CREATE TABLE IF NOT EXISTS pictures (id_picture integer primary key, id_box integer, picture text, ispined integer)");
$cordovaSQLite.execute(db,"CREATE TABLE IF NOT EXISTS box_cg (left integer, max_box integer, lang text)");
$cordovaSQLite.execute(db,"CREATE TABLE IF NOT EXISTS social (id_social integer primary key, user text, social_code text, token text)");
$cordovaSQLite.execute(db,"INSERT OR REPLACE INTO storages (id_storage,name_storage,picture) VALUES (1,'STORAGE 1','Storage 1 Picture')");
$cordovaSQLite.execute(db,"INSERT OR REPLACE INTO storages (id_storage,name_storage,picture) VALUES (2,'STORAGE 2','Storage 1 Picture')");
$cordovaSQLite.execute(db,"INSERT OR REPLACE INTO storages (id_storage,name_storage,picture) VALUES (3,'STORAGE 3','Storage 1 Picture')");
$cordovaSQLite.execute(db,"INSERT OR REPLACE INTO boxes (id_box,box_tags,id_storage,box_name) VALUES (1,'Item 11, Item 12, Item 13',1,'Mi primera caja')");
$cordovaSQLite.execute(db,"INSERT OR REPLACE INTO boxes (id_box,box_tags,id_storage,box_name) VALUES (2,'Item 21, Item 22, Item 23',1,'Mi segunda caja')");
$cordovaSQLite.execute(db,"INSERT OR REPLACE INTO boxes (id_box,box_tags,id_storage,box_name) VALUES (3,'Item 31, Item 32, Item 33',2,'Mi tercera caja')");
$cordovaSQLite.execute(db,"INSERT OR REPLACE INTO pictures(id_picture, id_box, picture, ispined) VALUES (1,1,'Picture 11',0)");
$cordovaSQLite.execute(db,"INSERT OR REPLACE INTO pictures(id_picture, id_box, picture, ispined) VALUES (2,1,'Picture 12',0)");
$cordovaSQLite.execute(db,"INSERT OR REPLACE INTO pictures(id_picture, id_box, picture, ispined) VALUES (3,2,'Picture 21',0)");
$cordovaSQLite.execute(db,"INSERT OR REPLACE INTO pictures(id_picture, id_box, picture, ispined) VALUES (4,2,'Picture 22',0)");
$cordovaSQLite.execute(db,"INSERT OR REPLACE INTO pictures(id_picture, id_box, picture, ispined) VALUES (5,3,'Picture 31',0)");
},function(error){
alert("Ocurrio un error en la base de datos");
},function(){
alert("Populated database OK");
});