-- ----------------------------
-- Records of account_types
-- ----------------------------
INSERT INTO "public"."account_types" VALUES ('1', 'Pre - Pago', '1');
INSERT INTO "public"."account_types" VALUES ('2', 'Post - Pago', '1');
INSERT INTO "public"."account_types" VALUES ('3', 'Otro', '1');
INSERT INTO "public"."account_types" VALUES ('4', 'Test', '1');


-- ----------------------------
-- Records of brands
-- ----------------------------
INSERT INTO "public"."brands" VALUES ('1', 'HUAWEI', 'f');
INSERT INTO "public"."brands" VALUES ('2', 'OPTICTIMES', 'f');

-- ----------------------------
-- Records of models
-- ----------------------------
INSERT INTO "public"."models" VALUES ('1', 'HG8245Q2', 'MAC+1', 'f', '1');
INSERT INTO "public"."models" VALUES ('2', 'Generico', 'MAC+5', 'f', '2');
INSERT INTO "public"."models" VALUES ('3', 'HG8245H', 'MAC+1', 'f', '1');


-- ----------------------------
-- Records of download_limits
-- ----------------------------
INSERT INTO "public"."download_limits" VALUES ('1', 'GB', '3', '1');
INSERT INTO "public"."download_limits" VALUES ('2', 'GB', '4', '1');
INSERT INTO "public"."download_limits" VALUES ('3', 'GB', '5', '1');
INSERT INTO "public"."download_limits" VALUES ('4', 'GB', '10', '1');
INSERT INTO "public"."download_limits" VALUES ('5', 'GB', '1', '1');
INSERT INTO "public"."download_limits" VALUES ('6', '0 ', '0', '1');


-- ----------------------------
-- Records of filter_types
-- ----------------------------
INSERT INTO "public"."filter_types" VALUES ('0', 'Sin Filtros', '0');
INSERT INTO "public"."filter_types" VALUES ('1', 'XXX', '1');
INSERT INTO "public"."filter_types" VALUES ('2', 'RS', '1');
INSERT INTO "public"."filter_types" VALUES ('3', 'GM', '1');
INSERT INTO "public"."filter_types" VALUES ('4', 'VIDEO', '1');


-- ----------------------------
-- Records of filters
-- ----------------------------
INSERT INTO "public"."filters" VALUES ('0', 'Sin Filtros', 't');
INSERT INTO "public"."filters" VALUES ('1', 'Streaming', 'f');
INSERT INTO "public"."filters" VALUES ('2', 'Gaming', 'f');
INSERT INTO "public"."filters" VALUES ('3', 'Redes Sociales', 'f');
INSERT INTO "public"."filters" VALUES ('4', 'XXX', 'f');
INSERT INTO "public"."filters" VALUES ('7', 'Pruebas de filtro 2', 't');
INSERT INTO "public"."filters" VALUES ('8', 'XXX RS', 'f');
INSERT INTO "public"."filters" VALUES ('9', 'XXX GM', 'f');
INSERT INTO "public"."filters" VALUES ('10', 'XXX VIDEO', 'f');
INSERT INTO "public"."filters" VALUES ('11', 'RS GM', 'f');
INSERT INTO "public"."filters" VALUES ('12', 'RS VIDEO', 'f');
INSERT INTO "public"."filters" VALUES ('13', 'GM VIDEO', 'f');
INSERT INTO "public"."filters" VALUES ('14', 'XXX RS GM', 'f');
INSERT INTO "public"."filters" VALUES ('15', 'XXX GM STREAMING', 'f');
INSERT INTO "public"."filters" VALUES ('16', 'RS GM STREAMING', 'f');
INSERT INTO "public"."filters" VALUES ('17', 'XXX RS GM STREAMING', 'f');


-- ----------------------------
-- Records of speeds
-- ----------------------------
INSERT INTO "public"."speeds" VALUES ('1', 'Mbps', '10', '1');
INSERT INTO "public"."speeds" VALUES ('2', 'Mbps', '20', '1');
INSERT INTO "public"."speeds" VALUES ('3', 'Mbps', '30', '0');
INSERT INTO "public"."speeds" VALUES ('4', 'Mbps', '50', '1');
INSERT INTO "public"."speeds" VALUES ('5', 'Mbps', '100', '1');
INSERT INTO "public"."speeds" VALUES ('6', 'Mbps', '1000', '0');
INSERT INTO "public"."speeds" VALUES ('7', 'Mbps', '200', '1');
INSERT INTO "public"."speeds" VALUES ('8', 'Mbps', '300', '1');
INSERT INTO "public"."speeds" VALUES ('9', 'Mbps', '5', '1');
INSERT INTO "public"."speeds" VALUES ('10', 'Mbps', '25', '1');
INSERT INTO "public"."speeds" VALUES ('11', 'Mbps', '150', '1');


-- ----------------------------
-- Records of subscribers
-- ----------------------------
INSERT INTO "public"."subscribers" VALUES (null, null, null, null, 'RUC', '111222333', 't', '1');
INSERT INTO "public"."subscribers" VALUES (null, null, null, null, 'RUC', '123', 't', '1');
INSERT INTO "public"."subscribers" VALUES (null, null, null, null, 'RUC', '1234', 't', '1');
INSERT INTO "public"."subscribers" VALUES ('Angel', 'Perez', '891765234', 'aperez@pe.pe', 'DNI', '12345', 't', '1');
INSERT INTO "public"."subscribers" VALUES ('Juan', 'Meza', '123654987', 'jmeza@pe.pe', 'RUC', '123456', 't', '1');
INSERT INTO "public"."subscribers" VALUES (null, null, null, null, 'RUC', '1234567', 't', '1');
INSERT INTO "public"."subscribers" VALUES (null, null, null, null, 'RUC', '123456700', 't', '1');
INSERT INTO "public"."subscribers" VALUES ('Julio', 'Yanez', '112233', 'jya@pe.pe', 'RUC', '12345678', 't', '1');
INSERT INTO "public"."subscribers" VALUES (null, null, null, null, 'RUC', '123456780', 't', '1');
INSERT INTO "public"."subscribers" VALUES ('Carlos David', 'Moron Vegas', '111222333', 'cmoron@pe.pe', 'RUC', '123456789', 't', '1');
INSERT INTO "public"."subscribers" VALUES ('Raul', 'Sierra', '123456789', 'rsierra@pe.pe', 'CARNET', '1234567890', 'f', '1');
INSERT INTO "public"."subscribers" VALUES (null, null, null, null, 'DNI', '123546789', 't', '1');
INSERT INTO "public"."subscribers" VALUES ('Eduard', 'Colmenares', '584732159', 'rcolme@pe.pe', 'RUC', '135792468', 't', '1');
INSERT INTO "public"."subscribers" VALUES ('Juan', 'Avila', '12345', 'esd4556@gfsrt.co', 'DNI', '19660068', 'f', '1');
INSERT INTO "public"."subscribers" VALUES ('Ramon', 'Barboza', '951357741', 'rbarboza@pe.ve', 'RUC', '246813579', 't', '2');
INSERT INTO "public"."subscribers" VALUES (null, null, null, null, 'DNI', '43433845', 't', '1');
INSERT INTO "public"."subscribers" VALUES ('Ruben Carlos', 'Villegas', '321654987', 'rubven@pe.ve', 'DNI', '654987321', 't', '1');
INSERT INTO "public"."subscribers" VALUES ('Jorge', 'Peralta', '321654987', 'jperalta@pe.pe', 'CARNET', '987654321', 'f', '2');


-- ----------------------------
-- Records of devices
-- ----------------------------
INSERT INTO "public"."devices"(mac,is_deleted,subscribers_id,pon,models_id,serie,mac_wan,created_at,updated_at,deleted_at) VALUES ('AAAEEE111333', 't', '1234567890', 'QWERTYPOIUY', '1', '11111AAAAA55555', 'AAAEEE111344', null, null, '2018-06-27 15:54:44');
INSERT INTO "public"."devices"(mac,is_deleted,subscribers_id,pon,models_id,serie,mac_wan,created_at,updated_at,deleted_at) VALUES ('AABBCCDDFF22', 't', '123456789', 'ASDFGHÑLKJHG', '1', '11223344', 'AABBCCDDFF33', null, null, '2018-06-27 15:54:44');
INSERT INTO "public"."devices"(mac,is_deleted,subscribers_id,pon,models_id,serie,mac_wan,created_at,updated_at,deleted_at) VALUES ('11AAEEFFCCBB', 't', '123456789', 'CDEXSWZAQ', '1', 'qazwsxedc', '11AAEEFFCCCC', null, null, '2018-06-27 15:54:44');
INSERT INTO "public"."devices"(mac,is_deleted,subscribers_id,pon,models_id,serie,mac_wan,created_at,updated_at,deleted_at) VALUES ('ABCDEF123456', 'f', '43433845', '2323', '1', '23213132', 'ABCDEF123467', null, null, null);
INSERT INTO "public"."devices"(mac,is_deleted,subscribers_id,pon,models_id,serie,mac_wan,created_at,updated_at,deleted_at) VALUES ('FFCCEEBB0000', 'f', '123456', 'QAZWSXEDCVFR', '1', 'QWERTYPOIUY', 'FFCCEEBB0001', null, null, null);
INSERT INTO "public"."devices"(mac,is_deleted,subscribers_id,pon,models_id,serie,mac_wan,created_at,updated_at,deleted_at) VALUES ('AAEE1122BB10', 't', '654987321', 'MNBV1234ÑLJ567823456', '1', 'MNBV1234ÑLJ5678', 'AAEE1122BB11', '2018-06-26 10:08:42', null, '2018-06-27 15:54:48');
INSERT INTO "public"."devices"(mac,is_deleted,subscribers_id,pon,models_id,serie,mac_wan,created_at,updated_at,deleted_at) VALUES ('345345345345', 't', '12345678', '345345345', '2', '32534534', '34534534534A', '2018-06-26 13:19:43', null, '2018-06-27 15:54:39');
INSERT INTO "public"."devices"(mac,is_deleted,subscribers_id,pon,models_id,serie,mac_wan,created_at,updated_at,deleted_at) VALUES ('234234234234', 't', '12345678', '32434234', '1', '23423423', '234234234235', '2018-06-26 13:23:02', null, '2018-06-27 15:54:39');
INSERT INTO "public"."devices"(mac,is_deleted,subscribers_id,pon,models_id,serie,mac_wan,created_at,updated_at,deleted_at) VALUES ('CCBBAA112233', 't', '135792468', 'OKMIJNUHB', '1', 'qazwsxvfrcde', 'CCBBAA112234', '2018-06-27 10:38:45', null, '2018-06-27 15:54:52');
INSERT INTO "public"."devices"(mac,is_deleted,subscribers_id,pon,models_id,serie,mac_wan,created_at,updated_at,deleted_at) VALUES ('00DDB3AAEEFF', 't', '246813579', 'OKMNBVGFRDAS465', '2', 'EDCUHBRFVYGV', 'DDB3AAEF04', '2018-06-27 11:26:02', null, '2018-06-27 12:23:26');
INSERT INTO "public"."devices"(mac,is_deleted,subscribers_id,pon,models_id,serie,mac_wan,created_at,updated_at,deleted_at) VALUES ('11223344EEFF', 't', '246813579', 'DFHSRTHSRFTHST', '1', 'ASXASDAEGFVA', '11223344EF00', '2018-06-27 12:00:10', null, '2018-06-27 12:23:26');
INSERT INTO "public"."devices"(mac,is_deleted,subscribers_id,pon,models_id,serie,mac_wan,created_at,updated_at,deleted_at) VALUES ('22223344EEFF', 't', '246813579', 'DTHSFTHJSRTJ', '2', 'DRSHASDRHNINL', '22223344EF04', '2018-06-27 12:01:34', null, '2018-06-27 12:23:26');
INSERT INTO "public"."devices"(mac,is_deleted,subscribers_id,pon,models_id,serie,mac_wan,created_at,updated_at,deleted_at) VALUES ('00DD4455EEFF', 't', '246813579', 'DSRHASWERYH', '1', 'OJUBGSIYVBFLUS', 'DD4455EF00', '2018-06-27 12:02:23', null, '2018-06-27 12:23:26');
INSERT INTO "public"."devices"(mac,is_deleted,subscribers_id,pon,models_id,serie,mac_wan,created_at,updated_at,deleted_at) VALUES ('00113355EEFF', 't', '246813579', 'XSRGADRH', '2', 'ADRGHFTHJSGDH', '113355EF04', '2018-06-27 12:06:39', null, '2018-06-27 12:23:26');
INSERT INTO "public"."devices"(mac,is_deleted,subscribers_id,pon,models_id,serie,mac_wan,created_at,updated_at,deleted_at) VALUES ('00224466EEFF', 't', '246813579', 'DTYJUIRTYKI', '1', 'SERGSRTH', '224466EF00', '2018-06-27 12:06:56', null, '2018-06-27 12:23:26');
INSERT INTO "public"."devices"(mac,is_deleted,subscribers_id,pon,models_id,serie,mac_wan,created_at,updated_at,deleted_at) VALUES ('CCBBAA112233', 't', '135792468', 'SEDGFLIHSA', '2', 'QEÑOHJASEGÑNº', 'CCBBAA112238', '2018-06-27 15:46:55', null, '2018-06-27 15:54:52');
INSERT INTO "public"."devices"(mac,is_deleted,subscribers_id,pon,models_id,serie,mac_wan,created_at,updated_at,deleted_at) VALUES ('00112233EEFF', 't', '12345678', 'DRHRB5YRG', '2', 'RFVTGBYHNUJM', '00112233EF04', '2018-06-27 15:49:29', null, '2018-06-27 15:54:39');
INSERT INTO "public"."devices"(mac,is_deleted,subscribers_id,pon,models_id,serie,mac_wan,created_at,updated_at,deleted_at) VALUES ('00112233EEFF', 'f', '1234567890', 'EDCRFVTGB', '2', 'QWERTYPOIUYT', '00112233EF04', '2018-06-27 15:56:53', null, null);
INSERT INTO "public"."devices"(mac,is_deleted,subscribers_id,pon,models_id,serie,mac_wan,created_at,updated_at,deleted_at) VALUES ('01020303AABB', 'f', '987654321', 'QWER1234', '1', 'Q1W2E3R4T5Y6', '01020303AABC', '2018-06-28 12:57:47', null, null);
INSERT INTO "public"."devices"(mac,is_deleted,subscribers_id,pon,models_id,serie,mac_wan,created_at,updated_at,deleted_at) VALUES ('C4FF1F55773A', 'f', '19660068', '48575443FC0E469A', '3', '2150083099EGHA005737', 'C4FF1F55773B', '2018-06-28 15:54:55', null, null);
INSERT INTO "public"."devices"(mac,is_deleted,subscribers_id,pon,models_id,serie,mac_wan,created_at,updated_at,deleted_at) VALUES ('0011AABBEEFF', 't', '12345', 'QAZOKMWSXIJN', '1', 'QAZCDETGB', '0011AABBEF00', '2018-07-03 12:16:05', null, '2018-07-03 12:28:27');

-- ----------------------------
-- Records of plans
-- ----------------------------
INSERT INTO "public"."plans" VALUES (1, 'PLAN01', 'Plan 01', 'Plan descripción', 1527489814574, 1527489818574, 3600, '1','f', NULL, 1, 2, 1);