Database Restore from SQL files

Creating Schema (if not yet done)...

CREATE SCHEMA IF NOT EXISTS `eversons_cge` DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
0 rows affected.
USE `eversons_cge` ;
0 rows affected.
SET NAMES 'utf8';
0 rows affected.

Creating Tables...

Ok!

Inserting Data into Tables...

{"idcategory":"1","name":"- no categorizado -","description":"Mientras no est\u00e9n categorizados, est\u00e1n aqui :)"}
{"idcategory":"2","name":"Calefacci\u00f3n","description":"Todo que es para calientar el ambiente"}
{"idcategory":"3","name":"Iluminaci\u00f3n","description":"Bombillas, Lamparas, todo que hace luz"}
{"idcategory":"4","name":"Aire Acondicionado (refrigeraci\u00f3n)","description":"Todo que tiene que ver con enfriar"}
{"idcategory":"5","name":"Electr\u00f3nicos","description":"Teles, Sonido, Videojuegos, Fun stuff..."}
{"idcategory":"6","name":"Inform\u00e1tica","description":"Ordenadores, Port\u00e1tiles, Roteadores, Wifi..."}

{"idelement":"1","name":"Bombilla Incandescente Estandar Clara 25w","description":"Base:E27-edison-27mm, lumenes:220, vida media: 1000 horas, bombilla clasica de filamento.","watts":"25","idcategory":"3"}
{"idelement":"2","name":"Bombilla Incandescente Estandar Clara 40w","description":"Base:E27-edison-27mm, lumenes:415, vida media: 1000 horas, bombilla clasica de filamento.","watts":"40","idcategory":"3"}
{"idelement":"3","name":"Bombilla Incandescente Estandar Clara 60w","description":"Base:E27-edison-27mm, lumenes:710, vida media: 1000 horas, bombilla clasica de filamento.","watts":"60","idcategory":"3"}
{"idelement":"4","name":"Bombilla Incandescente Estandar Mate 40w","description":"Base:E27-edison-27mm, lumenes:350, vida media: 1000 horas, bombilla clasica de filamento, difusa.","watts":"40","idcategory":"3"}
{"idelement":"5","name":"Bombilla Incandescente Estandar Mate 60w","description":"Base:E27-edison-27mm, lumenes:600, vida media: 1000 horas, bombilla clasica de filamento, difusa.","watts":"60","idcategory":"3"}
{"idelement":"6","name":"Bombilla Eco-Hal\u00f3gena Estandar 18w","description":"Base:E27-edison-27mm, Sustituye a la bombilla de 25w de toda la vida, ahorrando un 30%","watts":"18","idcategory":"3"}
{"idelement":"7","name":"Bombilla Eco-Hal\u00f3gena Estandar 28w","description":"Base:E27-edison-27mm, Sustituye a la bombilla de 40w de toda la vida, ahorrando un 30%","watts":"28","idcategory":"3"}
{"idelement":"8","name":"Bombilla Eco-Hal\u00f3gena Estandar 42w","description":"Base:E27-edison-27mm, Sustituye a la bombilla de 60w de toda la vida, ahorrando un 30%","watts":"42","idcategory":"3"}
{"idelement":"9","name":"Bombilla Hal\u00f3gena Dicr\u00f3ica 35w 10D","description":"angulo de luz: 10\u00ba, intensidad luminosa: 8000 candelas, vida media: 4000 horas","watts":"35","idcategory":"3"}
{"idelement":"10","name":"Bombilla Hal\u00f3gena Dicr\u00f3ica 35w 36D","description":"angulo de luz: 36\u00ba, intensidad luminosa: 8000 candelas, vida media: 4000 horas","watts":"35","idcategory":"3"}
{"idelement":"11","name":"Bombilla Hal\u00f3gena Dicr\u00f3ica 50w 10D","description":"angulo de luz: 10\u00ba, intensidad luminosa: 13000 candelas, vida media: 4000 horas","watts":"50","idcategory":"3"}
{"idelement":"12","name":"Bombilla Hal\u00f3gena Dicr\u00f3ica 50w 36D","description":"angulo de luz: 36\u00ba, intensidad luminosa: 13000 candelas, vida media: 4000 horas","watts":"50","idcategory":"3"}
{"idelement":"13","name":"Bombilla LED Estandar Esferica 5w","description":"Base:E27-edison-27mm, Ilumina como 15W de incandescencia","watts":"5","idcategory":"3"}
{"idelement":"14","name":"Bombilla LED Estandar Esferica 7w","description":"Base:E27-edison-27mm, Ilumina como 25W de incandescencia","watts":"7","idcategory":"3"}
{"idelement":"15","name":"Tubo Fluorescente 13w 52cm","description":"MASTER TL-MINI 13w\/830 52 cm, 1a marca","watts":"13","idcategory":"3"}
{"idelement":"16","name":"Tubo Fluorescente 21w 85cm","description":"T5 HE 21w\/830 85 cm, 1a marca","watts":"21","idcategory":"3"}
{"idelement":"17","name":"Tubo Fluorescente Circular 22w","description":"Fluorescente 22w-circular serie 80","watts":"22","idcategory":"3"}
{"idelement":"18","name":"Tubo Fluorescente Circular 32w","description":"Fluorescente 32w-circular serie 80","watts":"32","idcategory":"3"}
{"idelement":"19","name":"Tubo Fluorescente Circular 40w","description":"Fluorescente 40w-circular serie 80","watts":"40","idcategory":"3"}
{"idelement":"20","name":"Aire Acondicionado Ventana 1500w","description":"Para montaje en ventanas","watts":"1500","idcategory":"4"}
{"idelement":"21","name":"Aire Acondicionado Central 3000w","description":"Central para multi-split","watts":"3000","idcategory":"4"}
{"idelement":"22","name":"Climatizador \u00c1gua 70w","description":"Climatiza y refresca el aire con reservat\u00f3rio de \u00e1gua","watts":"70","idcategory":"4"}

{"idgroup":"1","name":"Casa Pobre","description":"Una casa con muy poca cosa..."}
{"idgroup":"2","name":"Casa Rica","description":"Deber\u00edan tener los propios generadores!"}
{"idgroup":"3","name":"Oficina 1","description":"Hay muchas bombillas y ordenadores"}

{"idgroup":"1","idelement":"1","quantity":"2","hours":"3","peakpercentual":"30"}
{"idgroup":"1","idelement":"15","quantity":"2","hours":"2","peakpercentual":"20"}
{"idgroup":"1","idelement":"22","quantity":"1","hours":"4","peakpercentual":"0"}
{"idgroup":"2","idelement":"9","quantity":"10","hours":"4","peakpercentual":"20"}
{"idgroup":"2","idelement":"19","quantity":"4","hours":"9","peakpercentual":"70"}
{"idgroup":"2","idelement":"21","quantity":"1","hours":"8","peakpercentual":"57.5"}
{"idgroup":"3","idelement":"1","quantity":"1","hours":"24","peakpercentual":"60"}

Ok!

100% Done! (no errors)