/*
Navicat PGSQL Data Transfer

Source Server         : IWAY-SERVER-ROD-4
Source Server Version : 90223
Source Host           : 10.50.1.4:5432
Source Database       : appv7
Source Schema         : public

Target Server Type    : PGSQL
Target Server Version : 90223
File Encoding         : 65001

Date: 2018-08-20 00:43:10
*/


-- ----------------------------
-- Records of menus
-- ----------------------------
BEGIN;
INSERT INTO "menus" VALUES ('1', 'Planes', 'fa fa-dashborard', null, 'app_plan', 'Planes', 'f', '2');
INSERT INTO "menus" VALUES ('2', 'Suscriptores', 'fa fa-dashborard', null, 'app_subscriber', 'Suscriptores', 'f', '1');
INSERT INTO "menus" VALUES ('3', 'Filtros', 'fa fa-dash-board', null, 'app_filter', 'Filtros', 'f', '3');
INSERT INTO "menus" VALUES ('4', 'Listar Planes', '', '1', 'app_plan_list', 'Listar Planes', 't', '1');
INSERT INTO "menus" VALUES ('5', 'Crear Nuevos Planes', '', '1', 'app_plan_add', 'Crear Nuevos Planes', 't', '1');
INSERT INTO "menus" VALUES ('6', 'Editar Planes', '', '1', 'app_plan_update', 'Editar Planes', 't', '1');
INSERT INTO "menus" VALUES ('7', 'Eliminar Planes', '', '1', 'app_plan_delete', 'Eliminar Planes', 't', '1');
INSERT INTO "menus" VALUES ('8', 'Listar Suscriptores', '', '2', 'app_subscriber_list', 'Listar Suscriptores', 't', '1');
INSERT INTO "menus" VALUES ('9', 'Editar Suscriptores', null, '2', 'app_subscriber_update', 'Editar Suscriptores', 't', '1');
INSERT INTO "menus" VALUES ('10', 'Tipo de Cuenta', '', null, 'app_account_type', 'Tipos de Cuenta', 'f', '4');
INSERT INTO "menus" VALUES ('11', 'Tipo de Filtro', '', null, 'app_filter_type', 'Tipos de Filtro', 'f', '5');
INSERT INTO "menus" VALUES ('12', 'Límites de descarga', '', null, 'download_limit', 'Límites de descarga', 'f', '6');
INSERT INTO "menus" VALUES ('13', 'Velocidades', '', null, 'app_speed', 'Velocidades', 'f', '7');
INSERT INTO "menus" VALUES ('14', 'Marcas', '', null, 'app_brand', 'Marcas', 'f', '8');
INSERT INTO "menus" VALUES ('15', 'Modelos', '', null, 'app_model', 'Modelos', 'f', '9');
INSERT INTO "menus" VALUES ('16', 'Usuarios', '', null, 'app_user', 'Usuarios', 'f', '10');
INSERT INTO "menus" VALUES ('17', 'Roles', '', null, 'app_profile', 'Roles', 'f', '11');
INSERT INTO "menus" VALUES ('18', 'Crear Nuevos Suscriptores', '', '2', 'app_subscriber_add', 'Crear Nuevos Suscriptores', 't', '1');
INSERT INTO "menus" VALUES ('19', 'Eliminar Suscriptores', '', '2', 'app_subscriber_delete', 'Eliminar Suscriptores', 't', '1');
INSERT INTO "menus" VALUES ('20', 'Agregar Nuevos Dispositivos', '', '2', 'app_subscriber_adddevices', 'Agregar Nuevos Dispositivos', 't', '1');
INSERT INTO "menus" VALUES ('21', 'Dar de baja a los Dispositivos', '', '2', 'app_subscriber_deletedevices', 'Dar de baja a los Dispositivos', 't', '1');
INSERT INTO "menus" VALUES ('22', 'Listar Recargas', '', '2', 'app_recharge_list', 'Listar recargas', 't', '1');
INSERT INTO "menus" VALUES ('23', 'Agregar Recargas', '', '2', 'app_recharge_add', 'Agregar Recargas', 't', '1');
INSERT INTO "menus" VALUES ('24', 'Listar Filtros de Planes', '', '1', 'app_plan_getplanfilters', 'Listar Filtros de Planes', 't', '1');
INSERT INTO "menus" VALUES ('25', 'Actualizar Filtros de Planes', '', '1', 'app_plan_updateplanfilters', 'Actualizar Filtros de Planes', 't', '1');
INSERT INTO "menus" VALUES ('26', 'Listar Filtros', '', '3', 'app_filter_list', 'Listar Filtros', 't', '1');
INSERT INTO "menus" VALUES ('27', 'Crear Nuevos Filtros', '', '3', 'app_filter_add', 'Crear Nuevos Filtros', 't', '1');
INSERT INTO "menus" VALUES ('28', 'Editar Filtros', '', '3', 'app_filter_update', 'Editar Filtros', 't', '1');
INSERT INTO "menus" VALUES ('29', 'Eliminar Filtros', '', '3', 'app_filter_delete', 'Eliminar Filtros', 't', '1');
INSERT INTO "menus" VALUES ('30', 'Listar Combinaciones', '', '3', 'app_filter_listcombinations', 'Listar Combinaciones de Filtro', 't', '1');
INSERT INTO "menus" VALUES ('31', 'Actualizar Combinaciones', '', '3', 'app_filter_updatecombinations', 'Actualizar Combinaciones', 't', '1');
INSERT INTO "menus" VALUES ('32', 'Crear Nuevos Tipos de Cuentas', '', '10', 'app_accounttype_add', 'Crear Nuevos Tipos de Cuentas', 't', '1');
INSERT INTO "menus" VALUES ('33', 'Actualizar Tipos de Cuentas', '', '10', 'app_accounttype_update', 'Actualizar Tipos de Cuentas', 't', '1');
INSERT INTO "menus" VALUES ('34', 'Crear Nuevos Tipos de Filtro', '', '11', 'app_filtertype_add', 'Crear Nuevos Tipos de Filtro', 't', '1');
INSERT INTO "menus" VALUES ('35', 'Editar Tipos de Filtros', '', '11', 'app_filtertype_update', 'Editar Tipos de Filtros', 't', '1');
INSERT INTO "menus" VALUES ('36', 'Crear Nuevos Limites de Descargas', '', '12', 'app_downloadlimit_add', 'Crear Nuevos Limites de Descargas', 't', '1');
INSERT INTO "menus" VALUES ('37', 'Editar Limites de Descargas', '', '12', 'app_downloadlimit_update', 'Editar Limites de Descargas', 't', '1');
INSERT INTO "menus" VALUES ('38', 'Crear Nuevas Velocidades', '', '13', 'app_speed_add', 'Crear Nuevas Velocidades', 't', '1');
INSERT INTO "menus" VALUES ('39', 'Editar Velocidades', '', '13', 'app_speed_update', 'Editar Velocidades', 't', '1');
INSERT INTO "menus" VALUES ('40', 'Listar Marcas', '', '14', 'app_brand_listAll', 'Listar Marcas', 't', '1');
INSERT INTO "menus" VALUES ('41', 'Crear Nuevos Marcas', '', '14', 'app_brand_add', 'Crear Nuevos Marcas', 't', '1');
INSERT INTO "menus" VALUES ('42', 'Editar Marca', '', '14', 'app_brand_update', 'Editar Marca', 't', '1');
INSERT INTO "menus" VALUES ('43', 'Eliminar Marca', '', '14', 'app_brand_delete', 'Eliminar Marca', 't', '1');
INSERT INTO "menus" VALUES ('44', 'Listar Modelos', '', '15', 'app_model_listAll', 'Listar Modelos', 't', '1');
INSERT INTO "menus" VALUES ('45', 'Crear Nuevos Modelos', '', '15', 'app_model_add', 'Crear Nuevos Modelos', 't', '1');
INSERT INTO "menus" VALUES ('46', 'Editar Modelos', '', '15', 'app_model_update', 'Editar Modelos', 't', '1');
INSERT INTO "menus" VALUES ('47', 'Eliminar Modelos', '', '15', 'app_model_delete', 'Eliminar Modelos', 't', '1');
INSERT INTO "menus" VALUES ('48', 'Listar Usuarios', '', '16', 'app_user_list', 'Listar Usuarios', 't', '1');
INSERT INTO "menus" VALUES ('49', 'Crear Nuevos Usuarios', '', '16', 'app_user_add', 'Crear Nuevos Usuarios', 't', '1');
INSERT INTO "menus" VALUES ('50', 'Editar Usuarios', '', '16', 'app_user_update', 'Editar Usuarios', 't', '1');
INSERT INTO "menus" VALUES ('51', 'Eliminar Usuarios', '', '16', 'app_user_delete', 'Eliminar Usuarios', 't', '1');
INSERT INTO "menus" VALUES ('52', 'Listar Roles', '', '17', 'app_profile_list', 'Listar Roles', 't', '1');
INSERT INTO "menus" VALUES ('53', 'Crear Nuevos Roles', '', '17', 'app_profile_add', 'Crear Nuevos Roles', 't', '1');
INSERT INTO "menus" VALUES ('54', 'Editar Roles', '', '17', 'app_profile_update', 'Editar Roles', 't', '1');
INSERT INTO "menus" VALUES ('55', 'Eliminar Roles', '', '17', 'app_profile_delete', 'Eliminar Roles', 't', '1');
INSERT INTO "menus" VALUES ('56', 'Listar Dispositivos de Suscriptores', '', '2', 'app_subscriber_listdevices', 'Listar Dispositivos de Suscriptores', 't', '1');
INSERT INTO "menus" VALUES ('57', 'Trazas del Sistema', 'fa fa-dashborard', null, 'app_log', 'Trazas del Sistema', 'f', '12');
INSERT INTO "menus" VALUES ('58', 'Listar Trazas del Sistema', '', '57', 'app_log_index', 'Listar Trazas del Sistema', 't', '1');
INSERT INTO "menus" VALUES ('59', 'Eliminar Recargas', '', '2', 'app_recharge_deleteRecharges', 'Eliminar Recargas', 't', '1');
INSERT INTO "menus" VALUES ('60', 'Sesiones', 'fa fa-dashboard', null, 'app_session', 'Sesiones', 'f', '4');
INSERT INTO "menus" VALUES ('61', 'Listar Sessiones', null, '60', 'app_session_activenow', 'Listar Sessiones', 't', '1');
INSERT INTO "menus" VALUES ('62', 'Cerrar Conexion', '', '60', 'app_session_offconnection', 'Cerrar Conexion', 't', '1');
INSERT INTO "menus" VALUES ('63', 'Consumo por Suscriptor', '', '2', 'app_subscriber_consumo', 'Consumo por Suscriptor', 't', '1');
INSERT INTO "menus" VALUES ('64', 'Pausar Servicios', '', '2', 'app_subscriber_pauseService', 'Pausar Servicios', 't', '1');
COMMIT;

-- ----------------------------
-- Records of profiles
-- ----------------------------
BEGIN;
INSERT INTO "profiles" VALUES ('1', 'ROLE_ADMIN', 'Usuario Administrador del Sistema');
INSERT INTO "profiles" VALUES ('2', 'ROLE_OPERARIO', 'El Operario del Sistema es el usuario que gestionara toda la información referente al almacen de dispositivos.');
INSERT INTO "profiles" VALUES ('3', 'ROLE_VISOR', 'Visualiza la Información del sistema');
INSERT INTO "profiles" VALUES ('4', 'ROLE_API', 'ACCESSO AL API');
INSERT INTO "profiles" VALUES ('5', 'ROLE_SUSCRIPTOR', 'Usuario suscriptor del Sistema el cual puede observar sus datos de Navegación');
COMMIT;

-- ----------------------------
-- Records of profiles_to_menus
-- ----------------------------
BEGIN;
INSERT INTO "profiles_to_menus"(profiles_id,menus_id,id) VALUES ('3', '1', '307');
INSERT INTO "profiles_to_menus"(profiles_id,menus_id,id) VALUES ('3', '4', '308');
INSERT INTO "profiles_to_menus"(profiles_id,menus_id,id) VALUES ('3', '2', '309');
INSERT INTO "profiles_to_menus"(profiles_id,menus_id,id) VALUES ('3', '8', '310');
INSERT INTO "profiles_to_menus"(profiles_id,menus_id,id) VALUES ('3', '22', '311');
INSERT INTO "profiles_to_menus"(profiles_id,menus_id,id) VALUES ('3', '56', '312');
INSERT INTO "profiles_to_menus"(profiles_id,menus_id,id) VALUES ('3', '3', '313');
INSERT INTO "profiles_to_menus"(profiles_id,menus_id,id) VALUES ('3', '26', '314');
INSERT INTO "profiles_to_menus"(profiles_id,menus_id,id) VALUES ('3', '30', '315');
INSERT INTO "profiles_to_menus"(profiles_id,menus_id,id) VALUES ('3', '10', '316');
INSERT INTO "profiles_to_menus"(profiles_id,menus_id,id) VALUES ('3', '40', '317');
INSERT INTO "profiles_to_menus"(profiles_id,menus_id,id) VALUES ('3', '44', '318');
INSERT INTO "profiles_to_menus"(profiles_id,menus_id,id) VALUES ('3', '48', '319');
INSERT INTO "profiles_to_menus"(profiles_id,menus_id,id) VALUES ('2', '1', '337');
INSERT INTO "profiles_to_menus"(profiles_id,menus_id,id) VALUES ('2', '4', '338');
INSERT INTO "profiles_to_menus"(profiles_id,menus_id,id) VALUES ('2', '2', '339');
INSERT INTO "profiles_to_menus"(profiles_id,menus_id,id) VALUES ('2', '8', '340');
INSERT INTO "profiles_to_menus"(profiles_id,menus_id,id) VALUES ('2', '9', '341');
INSERT INTO "profiles_to_menus"(profiles_id,menus_id,id) VALUES ('2', '18', '342');
INSERT INTO "profiles_to_menus"(profiles_id,menus_id,id) VALUES ('2', '22', '343');
INSERT INTO "profiles_to_menus"(profiles_id,menus_id,id) VALUES ('2', '23', '344');
INSERT INTO "profiles_to_menus"(profiles_id,menus_id,id) VALUES ('2', '20', '345');
INSERT INTO "profiles_to_menus"(profiles_id,menus_id,id) VALUES ('2', '21', '346');
INSERT INTO "profiles_to_menus"(profiles_id,menus_id,id) VALUES ('2', '56', '347');
INSERT INTO "profiles_to_menus"(profiles_id,menus_id,id) VALUES ('1', '1', '523');
INSERT INTO "profiles_to_menus"(profiles_id,menus_id,id) VALUES ('1', '5', '524');
INSERT INTO "profiles_to_menus"(profiles_id,menus_id,id) VALUES ('1', '6', '525');
INSERT INTO "profiles_to_menus"(profiles_id,menus_id,id) VALUES ('1', '7', '526');
INSERT INTO "profiles_to_menus"(profiles_id,menus_id,id) VALUES ('1', '4', '527');
INSERT INTO "profiles_to_menus"(profiles_id,menus_id,id) VALUES ('1', '24', '528');
INSERT INTO "profiles_to_menus"(profiles_id,menus_id,id) VALUES ('1', '25', '529');
INSERT INTO "profiles_to_menus"(profiles_id,menus_id,id) VALUES ('1', '2', '530');
INSERT INTO "profiles_to_menus"(profiles_id,menus_id,id) VALUES ('1', '8', '531');
INSERT INTO "profiles_to_menus"(profiles_id,menus_id,id) VALUES ('1', '9', '532');
INSERT INTO "profiles_to_menus"(profiles_id,menus_id,id) VALUES ('1', '18', '533');
INSERT INTO "profiles_to_menus"(profiles_id,menus_id,id) VALUES ('1', '19', '534');
INSERT INTO "profiles_to_menus"(profiles_id,menus_id,id) VALUES ('1', '22', '535');
INSERT INTO "profiles_to_menus"(profiles_id,menus_id,id) VALUES ('1', '23', '536');
INSERT INTO "profiles_to_menus"(profiles_id,menus_id,id) VALUES ('1', '20', '537');
INSERT INTO "profiles_to_menus"(profiles_id,menus_id,id) VALUES ('1', '21', '538');
INSERT INTO "profiles_to_menus"(profiles_id,menus_id,id) VALUES ('1', '56', '539');
INSERT INTO "profiles_to_menus"(profiles_id,menus_id,id) VALUES ('1', '59', '540');
INSERT INTO "profiles_to_menus"(profiles_id,menus_id,id) VALUES ('1', '3', '541');
INSERT INTO "profiles_to_menus"(profiles_id,menus_id,id) VALUES ('1', '26', '542');
INSERT INTO "profiles_to_menus"(profiles_id,menus_id,id) VALUES ('1', '27', '543');
INSERT INTO "profiles_to_menus"(profiles_id,menus_id,id) VALUES ('1', '28', '544');
INSERT INTO "profiles_to_menus"(profiles_id,menus_id,id) VALUES ('1', '29', '545');
INSERT INTO "profiles_to_menus"(profiles_id,menus_id,id) VALUES ('1', '30', '546');
INSERT INTO "profiles_to_menus"(profiles_id,menus_id,id) VALUES ('1', '31', '547');
INSERT INTO "profiles_to_menus"(profiles_id,menus_id,id) VALUES ('1', '10', '548');
INSERT INTO "profiles_to_menus"(profiles_id,menus_id,id) VALUES ('1', '32', '549');
INSERT INTO "profiles_to_menus"(profiles_id,menus_id,id) VALUES ('1', '33', '550');
INSERT INTO "profiles_to_menus"(profiles_id,menus_id,id) VALUES ('1', '13', '551');
INSERT INTO "profiles_to_menus"(profiles_id,menus_id,id) VALUES ('1', '38', '552');
INSERT INTO "profiles_to_menus"(profiles_id,menus_id,id) VALUES ('1', '39', '553');
INSERT INTO "profiles_to_menus"(profiles_id,menus_id,id) VALUES ('1', '11', '554');
INSERT INTO "profiles_to_menus"(profiles_id,menus_id,id) VALUES ('1', '34', '555');
INSERT INTO "profiles_to_menus"(profiles_id,menus_id,id) VALUES ('1', '35', '556');
INSERT INTO "profiles_to_menus"(profiles_id,menus_id,id) VALUES ('1', '12', '557');
INSERT INTO "profiles_to_menus"(profiles_id,menus_id,id) VALUES ('1', '36', '558');
INSERT INTO "profiles_to_menus"(profiles_id,menus_id,id) VALUES ('1', '37', '559');
INSERT INTO "profiles_to_menus"(profiles_id,menus_id,id) VALUES ('1', '14', '560');
INSERT INTO "profiles_to_menus"(profiles_id,menus_id,id) VALUES ('1', '40', '561');
INSERT INTO "profiles_to_menus"(profiles_id,menus_id,id) VALUES ('1', '41', '562');
INSERT INTO "profiles_to_menus"(profiles_id,menus_id,id) VALUES ('1', '42', '563');
INSERT INTO "profiles_to_menus"(profiles_id,menus_id,id) VALUES ('1', '43', '564');
INSERT INTO "profiles_to_menus"(profiles_id,menus_id,id) VALUES ('1', '15', '565');
INSERT INTO "profiles_to_menus"(profiles_id,menus_id,id) VALUES ('1', '44', '566');
INSERT INTO "profiles_to_menus"(profiles_id,menus_id,id) VALUES ('1', '45', '567');
INSERT INTO "profiles_to_menus"(profiles_id,menus_id,id) VALUES ('1', '46', '568');
INSERT INTO "profiles_to_menus"(profiles_id,menus_id,id) VALUES ('1', '47', '569');
INSERT INTO "profiles_to_menus"(profiles_id,menus_id,id) VALUES ('1', '16', '570');
INSERT INTO "profiles_to_menus"(profiles_id,menus_id,id) VALUES ('1', '48', '571');
INSERT INTO "profiles_to_menus"(profiles_id,menus_id,id) VALUES ('1', '49', '572');
INSERT INTO "profiles_to_menus"(profiles_id,menus_id,id) VALUES ('1', '50', '573');
INSERT INTO "profiles_to_menus"(profiles_id,menus_id,id) VALUES ('1', '51', '574');
INSERT INTO "profiles_to_menus"(profiles_id,menus_id,id) VALUES ('1', '17', '575');
INSERT INTO "profiles_to_menus"(profiles_id,menus_id,id) VALUES ('1', '52', '576');
INSERT INTO "profiles_to_menus"(profiles_id,menus_id,id) VALUES ('1', '53', '577');
INSERT INTO "profiles_to_menus"(profiles_id,menus_id,id) VALUES ('1', '54', '578');
INSERT INTO "profiles_to_menus"(profiles_id,menus_id,id) VALUES ('1', '55', '579');
INSERT INTO "profiles_to_menus"(profiles_id,menus_id,id) VALUES ('1', '60', '580');
INSERT INTO "profiles_to_menus"(profiles_id,menus_id,id) VALUES ('1', '61', '581');
INSERT INTO "profiles_to_menus"(profiles_id,menus_id,id) VALUES ('1', '62', '582');
INSERT INTO "profiles_to_menus"(profiles_id,menus_id,id) VALUES ('1', '57', '583');
INSERT INTO "profiles_to_menus"(profiles_id,menus_id,id) VALUES ('1', '58', '584');
COMMIT;

-- ----------------------------
-- Records of users
-- ----------------------------
BEGIN;
INSERT INTO "users" VALUES ('b6bc0013-36c3-437a-8db5-6bbf8625b0f2', 'orange', '$2y$10$yOg0U49r45KDEqceQNW.heE0frKpPOzGslc/klt/8Ad3LnWg.0RYm', '9c23547720c7b3f5b8fe39c4cf9ed9c6');
-- INSERT INTO "users" VALUES ('2', 'test', '$2y$13$USd0LImVYOOeFiYcrE7e0emIaZDFTW8DQMh/QmMkLnoz6dEPWoBAC', null);
-- INSERT INTO "users" VALUES ('4', 'usuario', '$2y$13$vAz/z22JvUOolzDopCzagO3P.wkUaDiIxWkFX3rg7wN57Yaw4QGRu', null);
-- INSERT INTO "users" VALUES ('6', 'rvillegas', '$2y$13$6ABSoxGfHj40g6iP0z18uu.HJdJqHxpKADXrt/8PuGx6sQ8WelZ6G', null);
-- INSERT INTO "users" VALUES ('8', 'operador', '$2y$13$d0N76OR9c6sMvGGd2jfzBOILv2ofNe8XgmXP4aRDlsUpYGX.ceiAe', null);
COMMIT;

-- ----------------------------
-- Records of users_to_profiles
-- ----------------------------
BEGIN;
INSERT INTO "users_to_profiles"(users_id,profiles_id,id) VALUES ('b6bc0013-36c3-437a-8db5-6bbf8625b0f2', '1', '6');
INSERT INTO "users_to_profiles"(users_id,profiles_id,id) VALUES ('b6bc0013-36c3-437a-8db5-6bbf8625b0f2', '4', '23');
-- INSERT INTO "users_to_profiles"(users_id,profiles_id,id) VALUES ('8', '2', '34');
-- INSERT INTO "users_to_profiles"(users_id,profiles_id,id) VALUES ('8', '4', '35');
-- INSERT INTO "users_to_profiles"(users_id,profiles_id,id) VALUES ('4', '3', '36');
-- INSERT INTO "users_to_profiles"(users_id,profiles_id,id) VALUES ('4', '4', '37');
-- INSERT INTO "users_to_profiles"(users_id,profiles_id,id) VALUES ('6', '3', '45');
-- INSERT INTO "users_to_profiles"(users_id,profiles_id,id) VALUES ('6', '4', '46');
-- INSERT INTO "users_to_profiles"(users_id,profiles_id,id) VALUES ('2', '4', '49');
COMMIT;

-- ----------------------------
-- Alter Sequences Owned By 
-- ----------------------------
