/*
Navicat PGSQL Data Transfer

Source Server         : IWAY-Server:5432
Source Server Version : 90223
Source Host           : 10.50.1.28:5432
Source Database       : appv7
Source Schema         : public

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

Date: 2018-06-25 19:21:54
*/

ALTER TABLE menus ADD alias VARCHAR(100) NOT NULL;
ALTER TABLE menus ADD description TEXT DEFAULT NULL;
ALTER TABLE menus ADD is_leaf BOOLEAN NOT NULL;
ALTER TABLE menus ADD orden INT DEFAULT NULL;

ALTER TABLE profiles ADD description TEXT DEFAULT NULL;


-- ----------------------------
-- Records of menus
-- ----------------------------
INSERT INTO "public"."menus" VALUES ('1', 'Planes', 'fa fa-dashborard', null, 'app_plan', 'Planes', 'f', '2');
INSERT INTO "public"."menus" VALUES ('2', 'Suscriptores', 'fa fa-dashborard', null, 'app_subscriber', 'Suscriptores', 'f', '1');
INSERT INTO "public"."menus" VALUES ('3', 'Filtros', 'fa fa-dash-board', null, 'app_filter', 'Filtros', 'f', '3');
INSERT INTO "public"."menus" VALUES ('4', 'Listar Planes', '', '1', 'app_plan_list', 'Listar Planes', 't', '1');
INSERT INTO "public"."menus" VALUES ('5', 'Crear Nuevos Planes', '', '1', 'app_plan_add', 'Crear Nuevos Planes', 't', '1');
INSERT INTO "public"."menus" VALUES ('6', 'Editar Planes', '', '1', 'app_plan_update', 'Editar Planes', 't', '1');
INSERT INTO "public"."menus" VALUES ('7', 'Eliminar Planes', '', '1', 'app_plan_delete', 'Eliminar Planes', 't', '1');
INSERT INTO "public"."menus" VALUES ('8', 'Listar Suscriptores', '', '2', 'app_subscriber_list', 'Listar Suscriptores', 't', '1');
INSERT INTO "public"."menus" VALUES ('9', 'Editar Suscriptores', null, '2', 'app_subscriber_update', 'Editar Suscriptores', 't', '1');
INSERT INTO "public"."menus" VALUES ('10', 'Tipo de Cuenta', '', null, 'app_account_type', 'Tipos de Cuenta', 'f', '4');
INSERT INTO "public"."menus" VALUES ('11', 'Tipo de Filtro', '', null, 'app_filter_type', 'Tipos de Filtro', 'f', '5');
INSERT INTO "public"."menus" VALUES ('12', 'Límites de descarga', '', null, 'download_limit', 'Límites de descarga', 'f', '6');
INSERT INTO "public"."menus" VALUES ('13', 'Velocidades', '', null, 'app_speed', 'Velocidades', 'f', '7');
INSERT INTO "public"."menus" VALUES ('14', 'Marcas', '', null, 'app_brand', 'Marcas', 'f', '8');
INSERT INTO "public"."menus" VALUES ('15', 'Modelos', '', null, 'app_model', 'Modelos', 'f', '9');
INSERT INTO "public"."menus" VALUES ('16', 'Usuarios', '', null, 'app_user', 'Usuarios', 'f', '10');
INSERT INTO "public"."menus" VALUES ('17', 'Roles', '', null, 'app_profile', 'Roles', 'f', '11');
INSERT INTO "public"."menus" VALUES ('18', 'Crear Nuevos Suscriptores', '', '2', 'app_subscriber_add', 'Crear Nuevos Suscriptores', 't', '1');


-- ----------------------------
-- Records of profiles
-- ----------------------------
INSERT INTO "public"."profiles" VALUES ('1', 'ROLE_ADMIN', 'Usuario Administrador del Sistema');
INSERT INTO "public"."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 "public"."profiles" VALUES ('3', 'ROLE_VISOR', 'Visualiza la Información del sistema');
INSERT INTO "public"."profiles" VALUES ('4', 'ROLE_API', 'ACCESSO AL API');



-- ----------------------------
-- Records of profiles_to_menus
-- ----------------------------
INSERT INTO "public"."profiles_to_menus" VALUES ('3', '3', '9');
INSERT INTO "public"."profiles_to_menus" VALUES ('3', '2', '10');
INSERT INTO "public"."profiles_to_menus" VALUES ('3', '8', '11');
INSERT INTO "public"."profiles_to_menus" VALUES ('3', '1', '12');
INSERT INTO "public"."profiles_to_menus" VALUES ('3', '4', '13');
INSERT INTO "public"."profiles_to_menus" VALUES ('1', '1', '39');
INSERT INTO "public"."profiles_to_menus" VALUES ('1', '5', '40');
INSERT INTO "public"."profiles_to_menus" VALUES ('1', '6', '41');
INSERT INTO "public"."profiles_to_menus" VALUES ('1', '7', '42');
INSERT INTO "public"."profiles_to_menus" VALUES ('1', '4', '43');
INSERT INTO "public"."profiles_to_menus" VALUES ('1', '2', '44');
INSERT INTO "public"."profiles_to_menus" VALUES ('1', '8', '45');
INSERT INTO "public"."profiles_to_menus" VALUES ('1', '9', '46');
INSERT INTO "public"."profiles_to_menus" VALUES ('1', '3', '47');
INSERT INTO "public"."profiles_to_menus" VALUES ('1', '10', '48');
INSERT INTO "public"."profiles_to_menus" VALUES ('1', '13', '49');
INSERT INTO "public"."profiles_to_menus" VALUES ('1', '11', '50');
INSERT INTO "public"."profiles_to_menus" VALUES ('1', '12', '51');
INSERT INTO "public"."profiles_to_menus" VALUES ('1', '14', '52');
INSERT INTO "public"."profiles_to_menus" VALUES ('1', '15', '53');
INSERT INTO "public"."profiles_to_menus" VALUES ('1', '16', '54');
INSERT INTO "public"."profiles_to_menus" VALUES ('1', '17', '55');
INSERT INTO "public"."profiles_to_menus" VALUES ('2', '1', '56');
INSERT INTO "public"."profiles_to_menus" VALUES ('2', '4', '57');
INSERT INTO "public"."profiles_to_menus" VALUES ('2', '2', '58');
INSERT INTO "public"."profiles_to_menus" VALUES ('2', '8', '59');
INSERT INTO "public"."profiles_to_menus" VALUES ('2', '9', '60');




-- ----------------------------
-- Records of users
-- ----------------------------
INSERT INTO "public"."users" VALUES ('1', 'orange', '$2y$10$yOg0U49r45KDEqceQNW.heE0frKpPOzGslc/klt/8Ad3LnWg.0RYm', 'eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9');
INSERT INTO "public"."users" VALUES ('2', 'test', '$2y$13$USd0LImVYOOeFiYcrE7e0emIaZDFTW8DQMh/QmMkLnoz6dEPWoBAC', null);
INSERT INTO "public"."users" VALUES ('4', 'usuario', '$2y$13$hztO2qq/6CYCkt0RhIR8OuWZ6Sr0uhJLamqZLzE4fXhEqUihfXbK.', null);
INSERT INTO "public"."users" VALUES ('8', 'operador', '$2y$13$d0N76OR9c6sMvGGd2jfzBOILv2ofNe8XgmXP4aRDlsUpYGX.ceiAe', null);


-- ----------------------------
-- Records of users_to_profiles
-- ----------------------------
INSERT INTO "public"."users_to_profiles" VALUES ('1', '1', '6');
INSERT INTO "public"."users_to_profiles" VALUES ('1', '4', '23');
INSERT INTO "public"."users_to_profiles" VALUES ('4', '3', '31');
INSERT INTO "public"."users_to_profiles" VALUES ('4', '4', '32');
INSERT INTO "public"."users_to_profiles" VALUES ('2', '4', '33');
INSERT INTO "public"."users_to_profiles" VALUES ('8', '2', '34');
INSERT INTO "public"."users_to_profiles" VALUES ('8', '4', '35');

