
CREATE   PROCEDURE `increment_bill` (IN `sale_i` INT, IN `responseCod` INT, IN `invoiceTypeCod` INT, IN `serieNumer` VARCHAR(20), IN `issueDat` DATE, IN `issueTim` TIME, IN `documentCurrencyCod` VARCHAR(10), IN `customerDocumentI` INT, IN `supplierDocumentI` INT, IN `customerI` VARCHAR(255), IN `customerNam` VARCHAR(100), IN `taxAmoun` DECIMAL, IN `taxableAmoun` DECIMAL, IN `taxSubtota` DECIMAL, IN `payableAmoun` DECIMAL, IN `referenceI` VARCHAR(20), IN `DocumentTypeCod` INT, IN `descriptio` VARCHAR(100), IN `user_creat` INT, IN `date_creat` DATETIME, IN `estad` INT, IN `result02` INT ZEROFILL, OUT `resultado` INT, OUT `resultSERIEcorre` VARCHAR(12), IN `non_affecte` DECIMAL, IN `exonerate` DECIMAL)  NO SQL
BEGIN
    DECLARE countmin INT;
    DECLARE correlativo INT;
    DECLARE validarMonto double;
    DECLARE invoice Varchar(12);
    DECLARE tipoComProbante varchar(1);
    DECLARE montoComprobante double;
    DECLARE validarExistencia varchar(20);
    SET countmin = 0;
    
    SET tipoComProbante := SUBSTRING(referenceI, 1, 1);
    
    /*SET validarExistencia := (SELECT id FROM tec_credit_note WHERE sale_id = sale_i limit 1);
    
    IF(validarExistencia IS NULL) THEN*/
    SET validarMonto := (SELECT IF(sum(payableAmount)is null, 0,sum(payableAmount)) as result FROM tec_credit_note WHERE sale_id = sale_i and estado = 1);
    SET montoComprobante := (SELECT amount FROM tec_sales WHERE id = sale_i);
    
    IF(montoComprobante > validarMonto) THEN
    
    	IF STRCMP(tipoComProbante, 'F') = 0 THEN
    
        	WHILE countmin < 1 DO
            	UPDATE tec_settings SET note_credit_invoice_number = note_credit_invoice_number + 1;
            	SET countmin = countmin + 1;
       		END WHILE;

        	SET correlativo := (SELECT note_credit_invoice_number FROM tec_settings);
        	SET result02 := correlativo;
        	SET invoice := (SELECT concat((SELECT SUBSTRING(note_credit_invoice_format,1,5) FROM tec_settings), SUBSTRING(result02, 4)) );
    
    	ELSEIF STRCMP(tipoComProbante, 'B') = 0 THEN
    
    		WHILE countmin < 1 DO
            	UPDATE tec_settings SET note_credit_bill_number = note_credit_bill_number + 1;
            	SET countmin = countmin + 1;
        	END WHILE;

        	SET correlativo := (SELECT note_credit_bill_number FROM tec_settings);
        	SET result02 := correlativo;
        	SET invoice := (SELECT concat((SELECT SUBSTRING(note_credit_bill_format,1,5) FROM tec_settings), SUBSTRING(result02, 4)) );
    
    	END IF;
    
    	INSERT INTO `tec_credit_note` (`sale_id`, `responseCode`, `invoiceTypeCode`, `serieNumero`, `issueDate`, `issueTime`, `documentCurrencyCode`, `customerDocumentID`, `supplierDocumentID`, `customerID`, `customerName`, `taxAmount`, `taxableAmount`, `non_affected`, `exonerated`, `taxSubtotal`, `payableAmount`, `referenceID`, `DocumentTypeCode`, `description`,`user_create`, `date_create`,`estado`) VALUES
(sale_i, responseCod, invoiceTypeCod, invoice, issueDat, issueTim, documentCurrencyCod, customerDocumentI, supplierDocumentI, customerI, customerNam, taxAmoun, taxableAmoun, non_affecte, exonerate, taxSubtota, payableAmoun, referenceI, DocumentTypeCod, descriptio, user_creat, date_creat, estad);
    
    	-- SELECT validarExistencia;
    	SET resultado := (SELECT LAST_INSERT_ID());
    	SET resultSERIEcorre := (invoice);
    ELSE 
    
    	SET resultado := (0);
    	SET resultSERIEcorre := (0);
    
    END IF;
    
END;

CREATE   PROCEDURE `insert_consult_ticket` (IN `descrip` VARCHAR(100), IN `f_name` VARCHAR(100), IN `ticke` VARCHAR(100), IN `codigo` INT)  BEGIN
		UPDATE `tec_send_invoice` SET `status_ticket` = descrip,`status`=codigo WHERE file_name = f_name  AND ticket = ticke;
END;

CREATE   PROCEDURE `register_customer` (OUT `result_id` INT, IN `nameP` VARCHAR(55), IN `cf1P` VARCHAR(255), IN `cf2P` VARCHAR(255), IN `phoneP` VARCHAR(20), IN `emailP` VARCHAR(100), IN `direccionP` VARCHAR(300), IN `customers_type_idP` INT, IN `estadoP` INT, IN `person_typeP` VARCHAR(20), IN `document_type_idP` INT)  NO SQL
BEGIN



INSERT INTO `tec_customers`(`name`, `cf1`, `cf2`, 
                            `phone`, `email`, `direccion`, 
                            `customers_type_id`, `estado`, `person_type`, 
                            `document_type_id`) VALUES (
                                nameP, cf1P, cf2P,
                            	phoneP, emailP, direccionP,
                            	customers_type_idP, estadoP, person_typeP,
                            	document_type_idP);

SET result_id :=  (SELECT LAST_INSERT_ID());

END;

CREATE   PROCEDURE `register_sale` (IN `dateP` VARCHAR(20), IN `local_idP` INT, IN `warehouse_idP` INT, IN `customer_idP` INT, IN `customer_nameP` VARCHAR(55), IN `document_typeP` INT, IN `currencyP` VARCHAR(3), IN `exchangeP` VARCHAR(50), IN `affectedP` VARCHAR(50), IN `non_affectedP` VARCHAR(50), IN `exoneratedP` VARCHAR(50), IN `totalP` VARCHAR(50), IN `product_discountP` VARCHAR(50), IN `order_discount_idP` VARCHAR(20), IN `order_discountP` VARCHAR(50), IN `total_discountP` VARCHAR(50), IN `product_taxP` VARCHAR(50), IN `order_tax_idP` VARCHAR(20), IN `order_taxP` VARCHAR(50), IN `total_taxP` VARCHAR(50), IN `tax_ICBPERP` VARCHAR(50), IN `mult_ICBPERP` VARCHAR(50), IN `subtotalP` VARCHAR(50), IN `amountP` VARCHAR(50), IN `grand_totalP` VARCHAR(50), IN `total_itemsP` INT, IN `total_quantityP` VARCHAR(50), IN `paidP` VARCHAR(50), IN `created_byP` INT, IN `updated_byP` INT, IN `updated_atP` VARCHAR(20), IN `noteP` VARCHAR(1000), IN `statusP` VARCHAR(20), IN `roundingP` VARCHAR(50), IN `attachmentP` VARCHAR(255), IN `expiration_dateP` VARCHAR(20), IN `canal_idP` INT, IN `custom_field_1P` VARCHAR(250), IN `custom_field_2P` VARCHAR(250), IN `custom_field_3P` VARCHAR(250), IN `invoice_idP` VARCHAR(20), IN `flg_responseP` INT, IN `error_codeP` VARCHAR(15), IN `response_descripP` VARCHAR(2000), IN `digest_valueP` VARCHAR(250), IN `estadoP` INT, OUT `result_id` INT, OUT `result_invoice` VARCHAR(100), IN `itemsSale` LONGTEXT, IN `QuantityItemsSale` INT)  NO SQL
BEGIN
	DECLARE correlativo VARCHAR(100);
    DECLARE countmin INT;
    SET countmin = 1;
    
    IF(document_typeP = 2) THEN
    
        SET correlativo := (SELECT CONCAT("F001-", REPEAT( '0', 7 - LENGTH( invoice_number + 1) ) , invoice_number + 1)  FROM tec_settings);

    ELSE
    
        SET correlativo := (SELECT CONCAT("B001-", REPEAT( '0', 7 - LENGTH( bill_number + 1) ) , bill_number + 1)  FROM tec_settings);

    END IF;



	INSERT INTO `tec_sales`(`date`, `local_id`, `warehouse_id`, `customer_id`, 
                        `customer_name`, `document_type`, `currency`, `exchange`, 
                        `affected`, `non_affected`, `exonerated`, `total`, 
                        `product_discount`, `order_discount_id`, `order_discount`, `total_discount`, 
                        `product_tax`, `order_tax_id`, `order_tax`, `total_tax`, 
                        `tax_ICBPER`, `mult_ICBPER`, `subtotal`, `amount`, 
                        `grand_total`, `total_items`, `total_quantity`, `paid`, 
                        `created_by`, `updated_by`, `updated_at`, `note`, 
                        `status`, `rounding`, `attachment`, `expiration_date`, 
                        `canal_id`, `custom_field_1`, `custom_field_2`, `custom_field_3`, 
                        `invoice_id`, `flg_response`, `error_code`, `response_descrip`, 
                        `digest_value`, `estado`) 
                        VALUES ( dateP, local_idP, warehouse_idP, customer_idP, 
                                customer_nameP, document_typeP, currencyP, exchangeP, 
                                affectedP, non_affectedP, exoneratedP, totalP, 
                                product_discountP, order_discount_idP, order_discountP, total_discountP, 
                                product_taxP, order_tax_idP, order_taxP, total_taxP, 
                                tax_ICBPERP, mult_ICBPERP, subtotalP, amountP, 
                                grand_totalP, total_itemsP, total_quantityP, paidP, 
                                created_byP, updated_byP, updated_atP, noteP, 
                                statusP, roundingP, attachmentP, expiration_dateP, 
                                canal_idP, custom_field_1P, custom_field_2P, custom_field_3P, 
                                correlativo, flg_responseP, error_codeP, response_descripP, 
                                digest_valueP, estadoP);

    IF(document_typeP = 2) THEN

    	UPDATE tec_settings SET invoice_number = invoice_number + 1;

    ELSE
    
    	UPDATE tec_settings SET bill_number = bill_number + 1;

    END IF;
    
    
    SET result_id :=  (SELECT LAST_INSERT_ID());
    SET result_invoice := (correlativo);
    -- se comento este while ya que no se tenia version MySQL 5.7 o MariaDB 10.4
    /*
    WHILE countmin < QuantityItemsSale DO
    
   
     INSERT INTO `tec_sale_items`(`sale_id`, `product_id`, `code`, 
                                  `name`, `quantity`, `unit_price`, 
                                  `affect_price`, `non_affected_price`, `exonerated_price`, 
                                  `discount`, `item_discount`, `prr_discount`, 
                                  `tax`, `item_tax`, `igv`, `tax_ICBPER`, 
                                  `quantity_ICBPER`, `subtotal`, `real_unit_price`, 
                                  `currency_cost`, `cost`, `tax_method`) 
                                  VALUES (
          result_id,
          REPLACE((SELECT JSON_EXTRACT(JSON_EXTRACT(JSON_EXTRACT(itemsSale, '$.items'), CONCAT('$.',countmin)), '$.product_id') AS 'Result') ,'"','') ,
          REPLACE((SELECT JSON_EXTRACT(JSON_EXTRACT(JSON_EXTRACT(itemsSale, '$.items'), CONCAT('$.',countmin)), '$.code') AS 'Result') ,'"','') ,
          REPLACE((SELECT JSON_EXTRACT(JSON_EXTRACT(JSON_EXTRACT(itemsSale, '$.items'), CONCAT('$.',countmin)), '$.name') AS 'Result') ,'"','') ,
          REPLACE((SELECT JSON_EXTRACT(JSON_EXTRACT(JSON_EXTRACT(itemsSale, '$.items'), CONCAT('$.',countmin)), '$.Quantity') AS 'Result') ,'"','') ,
          REPLACE((SELECT JSON_EXTRACT(JSON_EXTRACT(JSON_EXTRACT(itemsSale, '$.items'), CONCAT('$.',countmin)), '$.Unit_price') AS 'Result') ,'"','') ,
          REPLACE((SELECT JSON_EXTRACT(JSON_EXTRACT(JSON_EXTRACT(itemsSale, '$.items'), CONCAT('$.',countmin)), '$.Affect_price') AS 'Result') ,'"','') ,
          REPLACE((SELECT JSON_EXTRACT(JSON_EXTRACT(JSON_EXTRACT(itemsSale, '$.items'), CONCAT('$.',countmin)), '$.Non_affected_price') AS 'Result') ,'"','') ,
          REPLACE((SELECT JSON_EXTRACT(JSON_EXTRACT(JSON_EXTRACT(itemsSale, '$.items'), CONCAT('$.',countmin)), '$.Exonerated_price') AS 'Result') ,'"','') ,
		  REPLACE((SELECT JSON_EXTRACT(JSON_EXTRACT(JSON_EXTRACT(itemsSale, '$.items'), CONCAT('$.',countmin)), '$.discount') AS 'Result') ,'"','') ,
          REPLACE((SELECT JSON_EXTRACT(JSON_EXTRACT(JSON_EXTRACT(itemsSale, '$.items'), CONCAT('$.',countmin)), '$.item_discount') AS 'Result') ,'"','') ,
          REPLACE((SELECT JSON_EXTRACT(JSON_EXTRACT(JSON_EXTRACT(itemsSale, '$.items'), CONCAT('$.',countmin)), '$.prr_discount') AS 'Result') ,'"','') ,
          REPLACE((SELECT JSON_EXTRACT(JSON_EXTRACT(JSON_EXTRACT(itemsSale, '$.items'), CONCAT('$.',countmin)), '$.Tax') AS 'Result') ,'"','') ,
          REPLACE((SELECT JSON_EXTRACT(JSON_EXTRACT(JSON_EXTRACT(itemsSale, '$.items'), CONCAT('$.',countmin)), '$.Item_tax') AS 'Result') ,'"','') ,
          REPLACE((SELECT JSON_EXTRACT(JSON_EXTRACT(JSON_EXTRACT(itemsSale, '$.items'), CONCAT('$.',countmin)), '$.Igv') AS 'Result') ,'"','') ,
          REPLACE((SELECT JSON_EXTRACT(JSON_EXTRACT(JSON_EXTRACT(itemsSale, '$.items'), CONCAT('$.',countmin)), '$.Tax_ICBPER') AS 'Result') ,'"','') ,
          REPLACE((SELECT JSON_EXTRACT(JSON_EXTRACT(JSON_EXTRACT(itemsSale, '$.items'), CONCAT('$.',countmin)), '$.Quantity_ICBPER') AS 'Result') ,'"','') ,
          REPLACE((SELECT JSON_EXTRACT(JSON_EXTRACT(JSON_EXTRACT(itemsSale, '$.items'), CONCAT('$.',countmin)), '$.Subtotal') AS 'Result') ,'"',''),
          REPLACE((SELECT JSON_EXTRACT(JSON_EXTRACT(JSON_EXTRACT(itemsSale, '$.items'), CONCAT('$.',countmin)), '$.real_unit_price') AS 'Result') ,'"','') ,
          REPLACE((SELECT JSON_EXTRACT(JSON_EXTRACT(JSON_EXTRACT(itemsSale, '$.items'), CONCAT('$.',countmin)), '$.currency_cost') AS 'Result') ,'"','') ,
          REPLACE((SELECT JSON_EXTRACT(JSON_EXTRACT(JSON_EXTRACT(itemsSale, '$.items'), CONCAT('$.',countmin)), '$.cost') AS 'Result') ,'"','') ,
          REPLACE((SELECT JSON_EXTRACT(JSON_EXTRACT(JSON_EXTRACT(itemsSale, '$.items'), CONCAT('$.',countmin)), '$.tax_method') AS 'Result') ,'"','')
         );
         
         SET countmin = countmin + 1;
        
    END WHILE;*/
END;

CREATE   PROCEDURE `register_Send_invoice` (IN `issue_dateP` VARCHAR(50), IN `file_nameP` VARCHAR(50), IN `reference_dateP` VARCHAR(50), IN `processed_dateP` VARCHAR(50), IN `typeP` VARCHAR(50), IN `flg_responseP` INT, IN `error_codeP` VARCHAR(15), IN `response_descripP` VARCHAR(1000), IN `statusP` INT, IN `uCreaP` INT, IN `fCreaP` VARCHAR(50), IN `estadoP` INT, IN `sale_idP` INT)  NO SQL
BEGIN

DECLARE resultadoID INT;

INSERT INTO `tec_send_invoice`(
    `issue_date`, `number`, `file_name`, 
    `ticket`, `reference_date`, `processed_date`, 
    `type`, `flg_response`, `error_code`, 
    `response_descrip`, `observations`, `status`, 
    `uCrea`, `fCrea`, `uActualiza`, 
    `fActualiza`, `estado`) VALUES (
        issue_dateP, null, file_nameP, 
        null, reference_dateP, processed_dateP,
        typeP, flg_responseP, error_codeP,
        response_descripP, null, statusP,
        uCreaP, fCreaP, null,
        null, estadoP
    );
    
    SET resultadoID := (SELECT LAST_INSERT_ID());
    
    INSERT INTO `tec_send_invoice_items`(`send_invoice_id`, `sale_id`, `uCrea`, 
                                         `fCrea`, `uActualiza`, `fActualiza`, 
                                         `estado`) VALUES (
                                             resultadoID, sale_idP, uCreaP, 
                                             fCreaP, null, null, 
                                             estadoP);

END;

CREATE   PROCEDURE `sp_alm_customer_list` (IN `id_sale` VARCHAR(50))  NO SQL
BEGIN

SELECT name, cf1, cf2, customers_type_id
FROM tec_sales s
LEFT JOIN tec_customers c ON c.id = s.customer_id
WHERE s.id = id_sale;

END;

CREATE   PROCEDURE `sp_alm_envioguiaremision_registrar` (IN `referral_guide_idP` INT, IN `issue_dateP` VARCHAR(50), IN `file_nameP` VARCHAR(50), IN `flg_responseP` INT, IN `error_codeP` VARCHAR(50), IN `response_descripP` VARCHAR(1000), IN `status_grP` INT, IN `user_CreateP` INT, IN `date_CreateP` VARCHAR(50), IN `estadoP` INT)  NO SQL
BEGIN

INSERT INTO tec_send_invoice_gr (referral_guide_id, issue_date, 
                                  file_name, flg_response, error_code, 
                                  response_descrip, status, 
                                  user_Create, date_Create, estado) VALUES (referral_guide_idP, issue_dateP, file_nameP, 
                                  flg_responseP, error_codeP, response_descripP, 
                                  status_grP, user_CreateP, date_CreateP, 
                                  estadoP
                                  );

END;

CREATE   PROCEDURE `sp_alm_GuiaRemisionFilePDF_consult` (IN `id_GR` INT)  NO SQL
BEGIN

SELECT file_name FROM `tec_referral_guide_files` WHERE referral_guide_id = id_GR;

END;

CREATE   PROCEDURE `sp_alm_GuiaRemisionFilePDF_register` (IN `id_GR` INT, IN `pdf` VARCHAR(300))  NO SQL
BEGIN

INSERT INTO `tec_referral_guide_files`(`referral_guide_id`, `file_name`) VALUES (id_GR, pdf);

END;

CREATE   PROCEDURE `sp_alm_GuiaRemisionHast_list` (IN `Rguia` INT)  NO SQL
BEGIN

SELECT digest_value FROM `tec_referral_guide` WHERE id = Rguia;

END;

CREATE   PROCEDURE `sp_alm_guiaremision_modificar` (IN `idP` INT, IN `flg_responseP` INT, IN `error_codeP` VARCHAR(15), IN `response_descripP` VARCHAR(2000), IN `digest_valueP` VARCHAR(250))  NO SQL
BEGIN

update `tec_referral_guide`
SET 
flg_response = flg_responseP,
error_code = error_codeP, 
response_descrip = response_descripP,
digest_value = digest_valueP
where id = idP;

END;

CREATE   PROCEDURE `sp_alm_guiaremision_registrar` (IN `IssueDate` VARCHAR(10), IN `Note` VARCHAR(200), IN `DescriptionReasonTransfer` VARCHAR(100), IN `TotalGrossWeightGRE` VARCHAR(20), IN `NumberPackages` INT, IN `unitCodeGrossWeightGRE` VARCHAR(10), IN `TypeDocumenttransmitter` INT, IN `transmitterName` VARCHAR(100), IN `addresseeID` VARCHAR(20), IN `TypeDocumentaddressee` INT, IN `addresseeName` VARCHAR(200), IN `motivemovedCode` VARCHAR(2), IN `transfermobility` INT, IN `LicensePlateID` VARCHAR(10), IN `DriverPersonID` VARCHAR(12), IN `DriverPersonDocumentType` INT, IN `movedstartdate` VARCHAR(11), IN `DeliveryUbi` VARCHAR(10), IN `Delivery` VARCHAR(200), IN `OriginAddressUbi` VARCHAR(200), IN `OriginAddress` VARCHAR(200), OUT `result_id` INT, OUT `result_invoice` VARCHAR(50), IN `usercreate` INT, OUT `fechaRegister` VARCHAR(50), IN `estado` INT, IN `nameTransportista` VARCHAR(200))  NO SQL
BEGIN
	DECLARE correlativo VARCHAR(100);
    DECLARE fecharegistro DATETIME;
    
    SET correlativo := (SELECT CONCAT(SUBSTRING(referral_guide_format,1,5), REPEAT( '0', 7 - LENGTH( referral_guide_number + 1) ) , referral_guide_number + 1)  FROM tec_settings);
    
    SET fecharegistro := (select now());

	INSERT INTO `tec_referral_guide`(`serieNumero`, `IssueDate`, 
                                     `Note`, `DescriptionReasonTransfer`, `TotalGrossWeightGRE`, 
                                     `NumberPackages`, `unitCodeGrossWeightGRE`, `TypeDocumenttransmitter`, 
                                     `transmitterName`, `addresseeID`, `TypeDocumentaddressee`, 
                                     `addresseeName`, `motivemovedCode`, `transfermobility`, 
                                     `LicensePlateID`, `DriverPersonID`, `DriverPersonDocumentType`, 
                                     `movedstartdate`, `DeliveryUbi`, 
                                     `Delivery`, `OriginAddressUbi`, `OriginAddress`, `user_create`, `date_create`, `estado`,
                                     `nameTransportista`) 
                                     VALUES (correlativo, IssueDate, 
                                     Note, DescriptionReasonTransfer, TotalGrossWeightGRE, 
                                     NumberPackages, unitCodeGrossWeightGRE, TypeDocumenttransmitter, 
                                     transmitterName, addresseeID, TypeDocumentaddressee, 
                                     addresseeName, motivemovedCode, transfermobility, 
                                     LicensePlateID, DriverPersonID, DriverPersonDocumentType, 
                                     movedstartdate, DeliveryUbi, 
                                     Delivery, OriginAddressUbi, OriginAddress,usercreate, fecharegistro, estado, 
                                     nameTransportista);

    
    
    UPDATE tec_settings SET referral_guide_number = referral_guide_number + 1;

    SET result_id :=  (SELECT LAST_INSERT_ID());
    SET result_invoice := (correlativo);
    SET fechaRegister := (fecharegistro);

END;

CREATE   PROCEDURE `sp_alm_headerGuiaRemision_list` (IN `Rguia` INT)  NO SQL
BEGIN

SELECT serieNumero, IssueDate, Note, DescriptionReasonTransfer, TotalGrossWeightGRE, unitCodeGrossWeightGRE, addresseeID, addresseeName, transfermobility, LicensePlateID, DriverPersonID, movedstartdate, Delivery, DeliveryUbi, OriginAddressUbi, OriginAddress, NumberPackages, TypeDocumenttransmitter, transmitterName, TypeDocumentaddressee, motivemovedCode, DriverPersonDocumentType, nameTransportista, date_create, user_create
FROM `tec_referral_guide` WHERE `id` = Rguia ;

END;

CREATE   PROCEDURE `sp_alm_ItemsGuiaRemision_list` (IN `Rguia` INT)  NO SQL
BEGIN

SELECT ProductID, ProductName, QuantityProduct, unitCode, ProductCode FROM `tec_referral_guide_items` WHERE id_referral_guide = Rguia;

END;

CREATE   PROCEDURE `sp_alm_itemsSale_list` (IN `venta` INT)  NO SQL
BEGIN

SELECT t.product_id as id, t.code as code, t.name as name, t.quantity as quantity
FROM tec_sale_items t
LEFT JOIN tec_sales s ON s.id = t.sale_id
WHERE s.id=venta ;


END;

CREATE   PROCEDURE `sp_alm_motivoguiaremision_list` ()  NO SQL
BEGIN

SELECT code, description FROM tec_motive_referral_guide;

END;

CREATE   PROCEDURE `sp_alm_producto_consul` (IN `id_code` VARCHAR(50))  NO SQL
BEGIN
-- select if(concat("a", code)=id_code, "si","no"), concat("a", code)
-- from tec_products;
SELECT id, code, name 
FROM tec_products 
WHERE code = concat(id_code, '') and estado = 1;

END;

CREATE   PROCEDURE `sp_alm_producto_list` (IN `produc` VARCHAR(100))  NO SQL
BEGIN

SELECT CONCAT(name, "(",code,")") as productos, id 
FROM tec_products 
WHERE ((name like concat('%',produc,'%')) or (code like concat('%',produc,'%'))) and estado = 1
limit 100;

END;

CREATE   PROCEDURE `sp_alm_reporteguiaremision_list` ()  NO SQL
BEGIN

SELECT id as pid, date_create, addresseeName, if(transfermobility=1, 'Transporte publico', 'Transporte privado') as tipo_transporte , DriverPersonID, serieNumero, LicensePlateID, DescriptionReasonTransfer, if(T2.estadoSend = 1, 'Error de envio', if(T2.estadoSend = 2, 'Enviado', if(T2.estadoSend = 3, 'Rechazado', if(T2.estadoSend = 4, 'Procesado', '')))) as estado_envio
FROM tec_referral_guide
LEFT JOIN (SELECT referral_guide_id, status as estadoSend FROM tec_send_invoice_gr WHERE estado=1) as T2 ON T2.referral_guide_id=tec_referral_guide.id;

END;

CREATE   PROCEDURE `sp_alm_sendGuiaRemision_consult` (IN `idP` INT)  NO SQL
BEGIN

-- SELECT status 
-- FROM tec_send_invoice_gr 
-- WHERE referral_guide_id = idP and estado= 1;
SELECT status 
FROM tec_send_invoice_gr 
WHERE referral_guide_id = idP and estado= 1
UNION
SELECT 0 as status
FROM DUAL
WHERE NOT EXISTS (
SELECT status 
FROM tec_send_invoice_gr 
WHERE referral_guide_id = idP and estado= 1
    );


END;

CREATE   PROCEDURE `sp_alm_sendGuiaRemision_modificar` (IN `idP` INT)  NO SQL
BEGIN

UPDATE tec_send_invoice_gr SET estado = 0 WHERE referral_guide_id = idP;

END;

CREATE   PROCEDURE `type_Exchange` ()  NO SQL
BEGIN

SELECT sell FROM `tec_exchange` ORDER BY `id` DESC limit 1;

END;

CREATE   PROCEDURE `update_Xml_sale` (IN `idP` INT, IN `flg_responseP` INT, IN `error_codeP` VARCHAR(15), IN `response_descripP` VARCHAR(2000), IN `digest_valueP` VARCHAR(250))  NO SQL
BEGIN

update `tec_sales`
SET 
flg_response = flg_responseP,
error_code = error_codeP, 
response_descrip = response_descripP,
digest_value = digest_valueP
where id = idP;

END;

CREATE   PROCEDURE `user_datos` ()  NO SQL
BEGIN

        SELECT email, password FROM tec_users;

END;

CREATE   PROCEDURE `validate_beta` ()  NO SQL
BEGIN

SELECT beta FROM `tec_settings` ORDER BY `setting_id` DESC limit 1;

END;

CREATE   PROCEDURE `validate_customer` (IN `numIdentif` VARCHAR(20))  NO SQL
BEGIN

        SELECT id, name, cf1, cf2, direccion, document_type_id FROM tec_customers WHERE (cf2 = numIdentif or cf1 = numIdentif) and estado = 1 limit 1;

END;



-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `tec_canals`
--

CREATE TABLE `tec_canals` (
  `id` int(11) NOT NULL,
  `canal` varchar(250) CHARACTER SET latin1 DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Volcado de datos para la tabla `tec_canals`
--

INSERT INTO `tec_canals` (`id`, `canal`) VALUES
(1, 'TPV'),
(2, 'FZA'),
(3, 'Externo');

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `tec_categories`
--

CREATE TABLE `tec_categories` (
  `id` int(11) NOT NULL,
  `code` varchar(20) NOT NULL,
  `parent_category_id` int(11) NOT NULL,
  `name` varchar(55) NOT NULL,
  `image` varchar(100) DEFAULT 'no_image.png'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Volcado de datos para la tabla `tec_categories`
--

INSERT INTO `tec_categories` (`id`, `code`, `parent_category_id`, `name`, `image`) VALUES
(1, '', 0, 'sin categoria', 'no_image.png');

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `tec_combo_items`
--

CREATE TABLE `tec_combo_items` (
  `id` int(11) NOT NULL,
  `product_id` int(11) NOT NULL,
  `item_code` varchar(20) NOT NULL,
  `quantity` decimal(12,4) NOT NULL,
  `price` decimal(25,2) DEFAULT NULL,
  `cost` decimal(25,2) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `tec_credit_note`
--

CREATE TABLE `tec_credit_note` (
  `id` int(11) NOT NULL,
  `sale_id` int(11) NOT NULL,
  `responseCode` int(11) NOT NULL,
  `invoiceTypeCode` int(11) NOT NULL,
  `serieNumero` varchar(20) NOT NULL,
  `issueDate` date NOT NULL,
  `issueTime` time NOT NULL,
  `documentCurrencyCode` varchar(10) NOT NULL,
  `customerDocumentID` int(11) NOT NULL,
  `supplierDocumentID` int(11) NOT NULL,
  `customerID` varchar(255) NOT NULL,
  `customerName` varchar(100) NOT NULL,
  `taxAmount` decimal(25,2) NOT NULL,
  `taxableAmount` decimal(25,2) NOT NULL,
  `non_affected` decimal(25,2) NOT NULL,
  `exonerated` decimal(25,2) NOT NULL,
  `taxSubtotal` decimal(25,2) NOT NULL,
  `payableAmount` decimal(25,2) NOT NULL,
  `referenceID` varchar(20) NOT NULL,
  `DocumentTypeCode` int(11) NOT NULL,
  `description` varchar(100) NOT NULL,
  `user_upgrade` int(11) DEFAULT NULL,
  `date_upgrade` datetime DEFAULT NULL,
  `user_create` int(11) NOT NULL,
  `date_create` datetime NOT NULL,
  `flg_response` int(11) DEFAULT NULL,
  `error_code` varchar(15) DEFAULT NULL,
  `response_descrip` varchar(2000) DEFAULT NULL,
  `digest_value` varchar(250) DEFAULT NULL,
  `estado` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `tec_credit_note_files`
--

CREATE TABLE `tec_credit_note_files` (
  `id` int(11) NOT NULL,
  `credit_note_id` int(11) NOT NULL,
  `file_name` varchar(300) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `tec_credit_note_items`
--

CREATE TABLE `tec_credit_note_items` (
  `id` int(11) NOT NULL,
  `credit_note_id` int(11) NOT NULL,
  `Quantity` int(11) NOT NULL,
  `LineExtensionAmount` int(11) NOT NULL,
  `PricingReference` int(11) NOT NULL,
  `PriceTypeCode` int(11) NOT NULL,
  `TaxTotalTaxAmount` decimal(25,2) NOT NULL,
  `TaxSubtotalTaxableAmount` int(11) NOT NULL,
  `PriceAmount` int(11) NOT NULL,
  `TaxSubtotalTaxAmount` decimal(25,2) NOT NULL,
  `TaxPercent` int(11) NOT NULL,
  `tax_method` int(11) NOT NULL,
  `Description` varchar(255) NOT NULL,
  `itemSellersID` varchar(50) NOT NULL,
  `user_upgrade` int(11) DEFAULT NULL,
  `date_upgrade` datetime DEFAULT NULL,
  `user_create` int(11) NOT NULL,
  `date_create` datetime NOT NULL,
  `estado` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `tec_credit_note_motive`
--

CREATE TABLE `tec_credit_note_motive` (
  `id` int(11) NOT NULL,
  `description_NC` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Volcado de datos para la tabla `tec_credit_note_motive`
--

INSERT INTO `tec_credit_note_motive` (`id`, `description_NC`) VALUES
(1, 'Anulación de la operación'),
(2, 'Anulación por error en el RUC'),
(3, 'Corrección por error en la descripción'),
(4, 'Descuento global'),
(5, 'Descuento por Item'),
(6, 'Devolución total'),
(7, 'Devolución parcial');

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `tec_customers`
--

CREATE TABLE `tec_customers` (
  `id` int(11) NOT NULL,
  `name` varchar(55) NOT NULL,
  `cf1` varchar(255) NOT NULL,
  `cf2` varchar(255) NOT NULL,
  `phone` varchar(20) NOT NULL,
  `email` varchar(100) NOT NULL,
  `direccion` varchar(300) DEFAULT NULL,
  `customers_type_id` int(11) DEFAULT NULL,
  `custom_field_1` varchar(250) DEFAULT NULL,
  `custom_field_2` varchar(250) DEFAULT NULL,
  `custom_field_3` varchar(250) DEFAULT NULL,
  `estado` int(11) NOT NULL,
  `person_type` varchar(20) NOT NULL,
  `document_type_id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Volcado de datos para la tabla `tec_customers`
--

INSERT INTO `tec_customers` (`id`, `name`, `cf1`, `cf2`, `phone`, `email`, `direccion`, `customers_type_id`, `custom_field_1`, `custom_field_2`, `custom_field_3`, `estado`, `person_type`, `document_type_id`) VALUES
(0, 'CLIENTES VARIOS', '00000000', '', '', '', '', NULL, '', '', '', 1, '1', 1);

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `tec_customers_type`
--

CREATE TABLE `tec_customers_type` (
  `id` int(11) NOT NULL,
  `customers_type` varchar(250) CHARACTER SET latin1 DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Volcado de datos para la tabla `tec_customers_type`
--

INSERT INTO `tec_customers_type` (`id`, `customers_type`) VALUES
(1, 'Cliente externo'),
(2, 'Cliente interno');

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `tec_doctors`
--

CREATE TABLE `tec_doctors` (
  `id` int(11) NOT NULL,
  `name` varchar(300) NOT NULL,
  `cmp` varchar(50) NOT NULL,
  `speciality` varchar(300) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `tec_document_type`
--

CREATE TABLE `tec_document_type` (
  `id` int(11) NOT NULL,
  `document_type` varchar(50) NOT NULL,
  `abreviatura` varchar(15) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Volcado de datos para la tabla `tec_document_type`
--

INSERT INTO `tec_document_type` (`id`, `document_type`, `abreviatura`) VALUES
(0, 'DOC.TRIB.NO.DOM.SIN.RUC', NULL),
(1, 'DOCUMENTO NACIONAL DE IDENTIDAD', 'DNI'),
(4, 'CARNET DE EXTRANJERIA', 'CARNET EXT.'),
(6, 'REGISTRO  UNICO DE CONTRIBUYENTES', 'RUC'),
(7, 'PASAPORTE', 'PASAPORTE'),
(8, 'por definir', NULL);

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `tec_exchange`
--

CREATE TABLE `tec_exchange` (
  `id` int(11) NOT NULL,
  `date` date NOT NULL,
  `currency` varchar(3) DEFAULT NULL,
  `buy` decimal(25,3) NOT NULL,
  `sell` decimal(25,3) NOT NULL,
  `uCrea` int(11) DEFAULT NULL,
  `fCrea` datetime DEFAULT NULL,
  `uActualiza` int(11) DEFAULT NULL,
  `fActualiza` datetime DEFAULT NULL,
  `estado` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Volcado de datos para la tabla `tec_exchange`
--

INSERT INTO `tec_exchange` (`id`, `date`, `currency`, `buy`, `sell`, `uCrea`, `fCrea`, `uActualiza`, `fActualiza`, `estado`) VALUES
(1, '2020-08-24', 'USD', '3.579', '3.584', 1, '2020-08-24 19:59:20', NULL, NULL, 1),
(2, '2020-08-25', 'USD', '3.579', '3.584', 1, '2020-08-25 02:09:33', NULL, NULL, 1),
(3, '2020-08-27', 'USD', '3.582', '3.586', 1, '2020-08-27 14:33:28', NULL, NULL, 1),
(4, '2020-08-28', 'USD', '3.582', '3.586', 1, '2020-08-28 02:53:28', NULL, NULL, 1),
(5, '2020-08-29', 'USD', '3.568', '3.573', 1, '2020-08-29 12:56:02', NULL, NULL, 1),
(6, '2020-08-30', 'USD', '3.568', '3.573', 1, '2020-08-30 00:33:30', NULL, NULL, 1);

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `tec_expenses`
--

CREATE TABLE `tec_expenses` (
  `id` int(11) NOT NULL,
  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `reference` varchar(50) NOT NULL,
  `amount` decimal(25,2) NOT NULL,
  `currency` varchar(3) DEFAULT NULL,
  `exchange` decimal(25,3) DEFAULT NULL,
  `note` varchar(1000) DEFAULT NULL,
  `created_by` varchar(55) NOT NULL,
  `attachment` varchar(55) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `tec_gift_cards`
--

CREATE TABLE `tec_gift_cards` (
  `id` int(11) NOT NULL,
  `date` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `card_no` varchar(20) NOT NULL,
  `value` decimal(25,2) NOT NULL,
  `customer_id` int(11) DEFAULT NULL,
  `balance` decimal(25,2) NOT NULL,
  `expiry` date DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `tec_groups`
--

CREATE TABLE `tec_groups` (
  `id` mediumint(8) UNSIGNED NOT NULL,
  `name` varchar(20) NOT NULL,
  `description` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Volcado de datos para la tabla `tec_groups`
--

INSERT INTO `tec_groups` (`id`, `name`, `description`) VALUES
(1, 'Admin', 'Administrator'),
(2, 'Staff', 'Staff'),
(3, 'Caja', 'Caja');

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `tec_locals`
--

CREATE TABLE `tec_locals` (
  `id` int(11) NOT NULL,
  `code` varchar(50) NOT NULL,
  `name` varchar(250) NOT NULL,
  `address` varchar(250) DEFAULT NULL,
  `cod_sunat` char(4) NOT NULL,
  `default_warehouse` int(11) DEFAULT NULL,
  `invoice_format` varchar(50) DEFAULT NULL,
  `bill_format` varchar(50) DEFAULT NULL,
  `invoice_number` int(11) DEFAULT NULL,
  `bill_number` int(11) DEFAULT NULL,
  `uCrea` int(11) DEFAULT NULL,
  `fCrea` datetime DEFAULT NULL,
  `uActualiza` int(11) DEFAULT NULL,
  `fActualiza` datetime DEFAULT NULL,
  `estado` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Volcado de datos para la tabla `tec_locals`
--

INSERT INTO `tec_locals` (`id`, `code`, `name`, `address`, `cod_sunat`, `default_warehouse`, `invoice_format`, `bill_format`, `invoice_number`, `bill_number`, `uCrea`, `fCrea`, `uActualiza`, `fActualiza`, `estado`) VALUES
(1, 'Principal', 'Local Principal', '', '0001', NULL, NULL, NULL, NULL, NULL, 1, '2019-03-22 21:01:56', NULL, NULL, 1);

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `tec_login_attempts`
--

CREATE TABLE `tec_login_attempts` (
  `id` mediumint(8) UNSIGNED NOT NULL,
  `ip_address` varbinary(16) NOT NULL,
  `login` varchar(100) NOT NULL,
  `time` int(11) UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `tec_makers`
--

CREATE TABLE `tec_makers` (
  `id` int(11) NOT NULL,
  `maker` varchar(250) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `tec_mesas`
--

CREATE TABLE `tec_mesas` (
  `id` int(11) NOT NULL,
  `mesa` varchar(45) NOT NULL,
  `estado` varchar(45) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `tec_motive_referral_guide`
--

CREATE TABLE `tec_motive_referral_guide` (
  `id` int(11) NOT NULL,
  `code` varchar(20) NOT NULL,
  `description` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Volcado de datos para la tabla `tec_motive_referral_guide`
--

INSERT INTO `tec_motive_referral_guide` (`id`, `code`, `description`) VALUES
(1, '01', 'VENTA'),
(2, '14', 'VENTA SUJETA A CONFIRMACION DEL COMPRADOR'),
(3, '02', 'COMPRA'),
(4, '04', 'TRASLADO ENTRE ESTABLECIMIENTOS DE LA MISMA EMPRESA'),
(5, '18', 'TRASLADO EMISOR ITINERANTE CP'),
(6, '08', 'IMPORTACION'),
(7, '09', 'EXPORTACION'),
(8, '19', 'TRASLADO A ZONA PRIMARIA'),
(9, '13', 'OTROS');

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `tec_mov_motive`
--

CREATE TABLE `tec_mov_motive` (
  `id` int(11) NOT NULL,
  `motive` varchar(250) NOT NULL,
  `alias` char(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Volcado de datos para la tabla `tec_mov_motive`
--

INSERT INTO `tec_mov_motive` (`id`, `motive`, `alias`) VALUES
(1, ' Ingreso por compra de productos', 'ICP'),
(2, 'Ingreso por devolución de productos', 'IDP'),
(3, 'Ingreso por anulación de venta', 'IAV'),
(4, 'Ingreso por traslado', 'IT'),
(5, 'Salida por venta', 'SV'),
(6, 'Salida por traslado', 'ST'),
(8, 'Salida por anulación de compra', 'SAC');

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `tec_payments`
--

CREATE TABLE `tec_payments` (
  `id` int(11) NOT NULL,
  `date` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `sale_id` int(11) DEFAULT NULL,
  `customer_id` int(11) DEFAULT NULL,
  `transaction_id` varchar(50) DEFAULT NULL,
  `paid_by` varchar(20) NOT NULL,
  `cheque_no` varchar(20) DEFAULT NULL,
  `cc_no` varchar(20) DEFAULT NULL,
  `cc_holder` varchar(25) DEFAULT NULL,
  `cc_month` varchar(2) DEFAULT NULL,
  `cc_year` varchar(4) DEFAULT NULL,
  `cc_type` varchar(20) DEFAULT NULL,
  `amount` decimal(25,2) NOT NULL,
  `currency` varchar(3) DEFAULT NULL,
  `created_by` int(11) NOT NULL,
  `attachment` varchar(55) DEFAULT NULL,
  `note` varchar(1000) DEFAULT NULL,
  `pos_paid` decimal(25,2) DEFAULT '0.00',
  `pos_balance` decimal(25,2) DEFAULT '0.00',
  `gc_no` varchar(20) DEFAULT NULL,
  `reference` varchar(50) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `tec_products`
--

CREATE TABLE `tec_products` (
  `id` int(11) NOT NULL,
  `code` varchar(50) NOT NULL,
  `name` char(255) NOT NULL,
  `category_id` int(11) NOT NULL DEFAULT '1',
  `currency` varchar(3) DEFAULT NULL,
  `price` decimal(25,2) NOT NULL,
  `image` varchar(255) DEFAULT 'no_image.png',
  `tax` varchar(20) DEFAULT '0',
  `cost` decimal(25,2) DEFAULT NULL,
  `tax_method` tinyint(1) DEFAULT '1',
  `quantity` decimal(15,2) DEFAULT '0.00',
  `barcode_symbology` varchar(20) NOT NULL DEFAULT 'code39',
  `type` varchar(20) NOT NULL DEFAULT 'standard',
  `details` text,
  `alert_quantity` decimal(10,2) DEFAULT '0.00',
  `maker_id` int(11) DEFAULT NULL,
  `custom_field_1` varchar(250) DEFAULT NULL,
  `custom_field_2` varchar(250) DEFAULT NULL,
  `custom_field_3` varchar(250) DEFAULT NULL,
  `presentation` varchar(250) DEFAULT NULL,
  `estado` int(11) DEFAULT '1',
  `uCrea` int(11) DEFAULT NULL,
  `fCrea` timestamp NULL DEFAULT NULL,
  `uActualiza` int(11) DEFAULT NULL,
  `fActualiza` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `tec_product_mov`
--

CREATE TABLE `tec_product_mov` (
  `id` int(11) NOT NULL,
  `origin_id` int(11) NOT NULL,
  `local_id` int(11) NOT NULL,
  `warehouse_id` int(11) DEFAULT NULL,
  `product_id` int(11) DEFAULT NULL,
  `cant` int(11) DEFAULT NULL,
  `tipo` char(1) DEFAULT NULL,
  `idMotivo` int(11) DEFAULT NULL,
  `ref` char(50) DEFAULT NULL,
  `uCrea` int(11) DEFAULT NULL,
  `fCrea` timestamp NULL DEFAULT NULL,
  `uActualiza` int(11) DEFAULT NULL,
  `fActualiza` timestamp NULL DEFAULT NULL,
  `estado` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `tec_purchases`
--

CREATE TABLE `tec_purchases` (
  `id` int(11) NOT NULL,
  `reference` varchar(55) NOT NULL,
  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `local_id` int(11) NOT NULL,
  `note` varchar(1000) NOT NULL,
  `currency` varchar(3) DEFAULT NULL,
  `exchange` decimal(25,3) DEFAULT NULL,
  `affected` decimal(25,2) NOT NULL,
  `exonerated` decimal(25,2) NOT NULL,
  `tax` decimal(25,2) NOT NULL,
  `total` decimal(25,2) NOT NULL,
  `grand_total` decimal(25,2) NOT NULL,
  `paid` decimal(25,2) NOT NULL,
  `status` varchar(250) DEFAULT NULL,
  `description` varchar(250) DEFAULT NULL,
  `attachment` varchar(255) DEFAULT NULL,
  `supplier_id` int(11) DEFAULT NULL,
  `received` tinyint(1) DEFAULT NULL,
  `expiration_date` date DEFAULT NULL,
  `warehouse_id` int(11) NOT NULL,
  `estado` int(11) DEFAULT '1',
  `uCrea` int(11) DEFAULT NULL,
  `fCrea` timestamp NULL DEFAULT NULL,
  `uActualiza` int(11) DEFAULT NULL,
  `fActualiza` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `tec_purchase_items`
--

CREATE TABLE `tec_purchase_items` (
  `id` int(11) NOT NULL,
  `purchase_id` int(11) NOT NULL,
  `product_id` int(11) NOT NULL,
  `quantity` decimal(15,2) NOT NULL,
  `cost` decimal(25,2) NOT NULL,
  `subtotal` decimal(25,2) NOT NULL,
  `estado` int(11) DEFAULT '1',
  `uCrea` int(11) DEFAULT NULL,
  `fCrea` timestamp NULL DEFAULT NULL,
  `uActualiza` int(11) DEFAULT NULL,
  `fActualiza` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `tec_purchase_pay`
--

CREATE TABLE `tec_purchase_pay` (
  `id` int(11) NOT NULL,
  `date` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `purchase_id` int(11) DEFAULT NULL,
  `supplier_id` int(11) DEFAULT NULL,
  `paid_by` varchar(20) NOT NULL,
  `cheque_no` varchar(20) DEFAULT NULL,
  `amount` decimal(25,2) NOT NULL,
  `currency` varchar(3) DEFAULT NULL,
  `created_by` int(11) NOT NULL,
  `attachment` varchar(255) DEFAULT NULL,
  `note` varchar(1000) DEFAULT NULL,
  `reference` varchar(50) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `estado` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `tec_referral_guide`
--

CREATE TABLE `tec_referral_guide` (
  `id` int(11) NOT NULL,
  `serieNumero` varchar(15) NOT NULL,
  `IssueDate` varchar(10) NOT NULL,
  `Note` varchar(200) NOT NULL,
  `DescriptionReasonTransfer` varchar(100) NOT NULL,
  `TotalGrossWeightGRE` varchar(20) NOT NULL,
  `NumberPackages` int(11) NOT NULL,
  `unitCodeGrossWeightGRE` varchar(10) NOT NULL,
  `TypeDocumenttransmitter` int(11) NOT NULL,
  `transmitterName` varchar(100) NOT NULL,
  `addresseeID` varchar(20) NOT NULL,
  `TypeDocumentaddressee` int(11) NOT NULL,
  `addresseeName` varchar(200) NOT NULL,
  `motivemovedCode` varchar(2) NOT NULL,
  `transfermobility` int(11) NOT NULL,
  `LicensePlateID` varchar(10) NOT NULL,
  `DriverPersonID` varchar(12) NOT NULL,
  `DriverPersonDocumentType` int(11) NOT NULL,
  `nameTransportista` varchar(200) NOT NULL,
  `movedstartdate` varchar(11) NOT NULL,
  `DeliveryUbi` varchar(10) NOT NULL,
  `Delivery` varchar(200) NOT NULL,
  `OriginAddressUbi` varchar(200) NOT NULL,
  `OriginAddress` varchar(200) NOT NULL,
  `flg_response` int(11) DEFAULT NULL,
  `error_code` varchar(15) DEFAULT NULL,
  `response_descrip` varchar(2000) DEFAULT NULL,
  `digest_value` varchar(250) DEFAULT NULL,
  `user_create` int(11) NOT NULL,
  `date_create` datetime NOT NULL,
  `user_upgrade` int(11) DEFAULT NULL,
  `date_upgrade` datetime DEFAULT NULL,
  `estado` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `tec_referral_guide_files`
--

CREATE TABLE `tec_referral_guide_files` (
  `id` int(11) NOT NULL,
  `referral_guide_id` int(11) NOT NULL,
  `file_name` varchar(300) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `tec_referral_guide_items`
--

CREATE TABLE `tec_referral_guide_items` (
  `id` int(11) NOT NULL,
  `id_referral_guide` int(11) NOT NULL,
  `ProductID` varchar(20) NOT NULL,
  `ProductCode` varchar(50) NOT NULL,
  `ProductName` varchar(100) NOT NULL,
  `QuantityProduct` int(11) NOT NULL,
  `unitCode` varchar(10) NOT NULL,
  `user_create` int(11) NOT NULL,
  `date_create` datetime NOT NULL,
  `user_upgrade` int(11) DEFAULT NULL,
  `date_upgrade` datetime DEFAULT NULL,
  `estado` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `tec_registers`
--

CREATE TABLE `tec_registers` (
  `id` int(11) NOT NULL,
  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `user_id` int(11) NOT NULL,
  `cash_in_hand` decimal(25,2) NOT NULL,
  `status` varchar(10) NOT NULL,
  `total_cash` decimal(25,2) DEFAULT NULL,
  `total_cheques` decimal(25,2) DEFAULT NULL,
  `total_cc_slips` decimal(25,2) DEFAULT NULL,
  `total_stripe` decimal(25,2) DEFAULT NULL,
  `total_cash_submitted` decimal(25,2) DEFAULT NULL,
  `total_cheques_submitted` decimal(25,2) DEFAULT NULL,
  `total_cc_slips_submitted` decimal(25,2) DEFAULT NULL,
  `total_stripe_submitted` decimal(25,2) DEFAULT NULL,
  `note` text,
  `closed_at` timestamp NULL DEFAULT NULL,
  `transfer_opened_bills` varchar(50) DEFAULT NULL,
  `closed_by` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `tec_sales`
--

CREATE TABLE `tec_sales` (
  `id` int(11) NOT NULL,
  `date` datetime NOT NULL,
  `local_id` int(11) NOT NULL,
  `warehouse_id` int(11) NOT NULL,
  `customer_id` int(11) NOT NULL,
  `customer_name` varchar(55) NOT NULL,
  `document_type` int(11) DEFAULT NULL,
  `currency` varchar(3) DEFAULT NULL,
  `exchange` decimal(25,3) DEFAULT NULL,
  `affected` decimal(25,2) NOT NULL,
  `non_affected` decimal(25,2) NOT NULL,
  `exonerated` decimal(25,2) NOT NULL,
  `total` decimal(25,2) NOT NULL,
  `product_discount` decimal(25,2) DEFAULT NULL,
  `order_discount_id` varchar(20) DEFAULT NULL,
  `order_discount` decimal(25,2) DEFAULT NULL,
  `total_discount` decimal(25,2) DEFAULT NULL,
  `product_tax` decimal(25,2) DEFAULT NULL,
  `order_tax_id` varchar(20) DEFAULT NULL,
  `order_tax` decimal(25,2) DEFAULT NULL,
  `total_tax` decimal(25,2) DEFAULT NULL,
  `tax_ICBPER` decimal(25,2) NOT NULL,
  `mult_ICBPER` decimal(25,2) NOT NULL,
  `subtotal` decimal(25,2) NOT NULL,
  `amount` decimal(25,2) NOT NULL,
  `grand_total` decimal(25,2) NOT NULL,
  `total_items` int(11) DEFAULT NULL,
  `total_quantity` decimal(15,2) DEFAULT NULL,
  `paid` decimal(25,2) DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `note` varchar(1000) DEFAULT NULL,
  `status` varchar(20) DEFAULT NULL,
  `rounding` decimal(8,2) DEFAULT NULL,
  `attachment` varchar(255) DEFAULT NULL,
  `expiration_date` date DEFAULT NULL,
  `canal_id` int(11) DEFAULT NULL,
  `custom_field_1` varchar(250) DEFAULT NULL,
  `custom_field_2` varchar(250) DEFAULT NULL,
  `custom_field_3` varchar(250) DEFAULT NULL,
  `invoice_id` varchar(12) DEFAULT NULL,
  `flg_response` int(1) DEFAULT NULL,
  `error_code` varchar(15) DEFAULT NULL,
  `response_descrip` varchar(2000) DEFAULT NULL,
  `digest_value` varchar(250) DEFAULT NULL,
  `estado` int(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `tec_sales_files`
--

CREATE TABLE `tec_sales_files` (
  `id` int(11) NOT NULL,
  `sale_id` int(11) NOT NULL,
  `file_name` varchar(300) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `tec_sale_items`
--

CREATE TABLE `tec_sale_items` (
  `id` int(11) NOT NULL,
  `sale_id` int(11) NOT NULL,
  `product_id` int(11) DEFAULT NULL,
  `code` varchar(50) DEFAULT NULL,
  `name` char(255) DEFAULT NULL,
  `quantity` decimal(15,2) NOT NULL,
  `unit_price` decimal(25,2) NOT NULL,
  `affect_price` decimal(25,2) NOT NULL,
  `non_affected_price` decimal(25,2) NOT NULL,
  `exonerated_price` decimal(25,2) NOT NULL,
  `discount` varchar(20) DEFAULT NULL,
  `item_discount` decimal(25,2) DEFAULT NULL,
  `prr_discount` decimal(25,2) NOT NULL,
  `tax` decimal(25,2) NOT NULL,
  `item_tax` decimal(25,2) DEFAULT NULL,
  `igv` varchar(20) NOT NULL,
  `tax_ICBPER` decimal(25,2) NOT NULL,
  `quantity_ICBPER` int(11) NOT NULL,
  `subtotal` decimal(25,2) NOT NULL,
  `real_unit_price` decimal(25,2) DEFAULT NULL,
  `currency_cost` varchar(3) DEFAULT NULL,
  `cost` decimal(25,2) DEFAULT '0.00',
  `tax_method` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `tec_send_invoice`
--

CREATE TABLE `tec_send_invoice` (
  `id` int(11) NOT NULL,
  `issue_date` date DEFAULT NULL,
  `number` int(11) DEFAULT NULL,
  `file_name` char(50) DEFAULT NULL,
  `ticket` varchar(1000) DEFAULT NULL,
  `reference_date` date DEFAULT NULL,
  `processed_date` date DEFAULT NULL,
  `type` char(50) DEFAULT NULL,
  `flg_response` int(1) DEFAULT NULL,
  `error_code` varchar(15) DEFAULT NULL,
  `response_descrip` varchar(1000) DEFAULT NULL,
  `observations` text,
  `status_ticket` varchar(140) DEFAULT NULL,
  `status` int(1) DEFAULT NULL,
  `uCrea` int(11) DEFAULT NULL,
  `fCrea` datetime DEFAULT NULL,
  `uActualiza` int(11) DEFAULT NULL,
  `fActualiza` datetime DEFAULT NULL,
  `estado` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `tec_send_invoice_gr`
--

CREATE TABLE `tec_send_invoice_gr` (
  `id` int(11) NOT NULL,
  `referral_guide_id` int(11) NOT NULL,
  `issue_date` date NOT NULL,
  `file_name` varchar(50) NOT NULL,
  `flg_response` int(11) NOT NULL,
  `error_code` varchar(15) NOT NULL,
  `response_descrip` varchar(1000) NOT NULL,
  `observations` text,
  `status` int(11) NOT NULL,
  `user_Create` int(11) NOT NULL,
  `date_Create` datetime NOT NULL,
  `user_upgrade` int(11) DEFAULT NULL,
  `date_upgrade` datetime DEFAULT NULL,
  `estado` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `tec_send_invoice_items`
--

CREATE TABLE `tec_send_invoice_items` (
  `id` int(11) NOT NULL,
  `send_invoice_id` int(11) NOT NULL,
  `sale_id` int(11) NOT NULL,
  `uCrea` int(11) DEFAULT NULL,
  `fCrea` datetime DEFAULT NULL,
  `uActualiza` int(11) DEFAULT NULL,
  `fActualiza` datetime DEFAULT NULL,
  `estado` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `tec_send_invoice_nc`
--

CREATE TABLE `tec_send_invoice_nc` (
  `id` int(11) NOT NULL,
  `note_credit_id` int(11) NOT NULL,
  `issue_date` date NOT NULL,
  `file_name` varchar(50) NOT NULL,
  `type` varchar(50) NOT NULL,
  `flg_response` int(11) NOT NULL,
  `error_code` varchar(15) NOT NULL,
  `response_descrip` varchar(1000) NOT NULL,
  `observations` text,
  `status` int(11) NOT NULL,
  `user_Create` int(11) NOT NULL,
  `date_Create` datetime NOT NULL,
  `user_upgrade` int(11) DEFAULT NULL,
  `date_upgrade` datetime DEFAULT NULL,
  `estado` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `tec_sessions`
--

CREATE TABLE `tec_sessions` (
  `id` varchar(40) NOT NULL,
  `ip_address` varchar(45) NOT NULL,
  `timestamp` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `data` blob NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Volcado de datos para la tabla `tec_sessions`
--

INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES
('028669004c87ee559a127a4207adb2b877db0df0', '::1', 1598834108, 0x5f5f63695f6c6173745f726567656e65726174657c693a313539383833343130333b6c6f63616c7c733a313a2231223b6c6973746156656e74617c693a303b6964656e746974797c733a32303a2261646d696e4073697374656d617470762e636f6d223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a32303a2261646d696e4073697374656d617470762e636f6d223b757365725f69647c733a313a2231223b66697273745f6e616d657c733a353a2241646d696e223b6c6173745f6e616d657c733a333a22545056223b637265617465645f6f6e7c733a32323a2232322f30382f323031382031323a32393a313120504d223b6f6c645f6c6173745f6c6f67696e7c733a31303a2231353938383334303133223b6c6173745f69707c733a333a223a3a31223b6176617461727c4e3b67656e6465727c733a343a226d616c65223b67726f75705f69647c733a313a2231223b72617a6f6e5f736f6369616c7c733a32343a22456d70726573612064652050727565626120262064656d6f223b7275637c733a31313a223132333435363738393132223b646972656363696f6e7c733a31393a2261762e20646573636f6e6f6369646120313233223b726567696f6e7c733a343a226c696d61223b706169737c733a343a2270657275223b6e65676f63696f7c733a313a2230223b626574617c733a313a2230223b686162696c6974615f62746e5f7061676f7c733a313a2231223b686162696c6974615f62746e5f63616a617c733a313a2230223b6c6f676f7c733a31363a226c6f676f2d656d70726573612e6a7067223b706f735f6c6f676f7c733a313a2232223b6c6f676f5f7064667c733a31323a226c6f676f2d7064662e706e67223b747970655f696d6167656e5f7064667c733a313a2231223b70726f746f636f6c7c733a343a22736d7470223b736d74705f686f73747c733a31393a226d61696c2e73697374656d617470762e636f6d223b736d74705f757365727c733a32333a226e6f2d7265706c794073697374656d617470762e636f6d223b736d74705f706173737c733a38383a2246795764306743646e7343317a326f54377137684b48655a757873612b706a5948684542527656415a3041616751693749453776536a75756c4142434530506b4576733356447872355756783131434c35387a4377413d3d223b736d74705f706f72747c733a333a22353837223b6d61696c706174687c4e3b756269636163696f6e5f584d4c7c733a303a22223b706173735f6669726d617c733a333a22343434223b757365725f736f6c7c733a333a22313233223b706173735f736f6c7c733a303a22223b),
('03f1dcd6047ebc20630b0d0a67097b0bf310864c', '::1', 1598365143, 0x5f5f63695f6c6173745f726567656e65726174657c693a313539383336353134333b6c6f63616c7c733a313a2231223b6c6973746156656e74617c693a303b6964656e746974797c733a32303a2261646d696e4073697374656d617470762e636f6d223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a32303a2261646d696e4073697374656d617470762e636f6d223b757365725f69647c733a313a2231223b66697273745f6e616d657c733a353a2241646d696e223b6c6173745f6e616d657c733a333a22545056223b637265617465645f6f6e7c733a32323a2232322f30382f323031382031323a32393a313120504d223b6f6c645f6c6173745f6c6f67696e7c733a31303a2231353938333339333733223b6c6173745f69707c733a333a223a3a31223b6176617461727c4e3b67656e6465727c733a343a226d616c65223b67726f75705f69647c733a313a2231223b72617a6f6e5f736f6369616c7c733a32343a22456d70726573612064652050727565626120262064656d6f223b7275637c733a31313a223132333435363738393132223b646972656363696f6e7c733a31393a2261762e20646573636f6e6f6369646120313233223b726567696f6e7c733a343a226c696d61223b706169737c733a343a2270657275223b6e65676f63696f7c733a313a2230223b626574617c733a313a2231223b686162696c6974615f62746e5f7061676f7c733a313a2231223b686162696c6974615f62746e5f63616a617c733a313a2230223b6c6f676f7c733a31363a226c6f676f2d656d70726573612e6a7067223b706f735f6c6f676f7c733a313a2232223b6c6f676f5f7064667c733a31323a226c6f676f2d7064662e706e67223b747970655f696d6167656e5f7064667c733a313a2231223b70726f746f636f6c7c733a343a22736d7470223b736d74705f686f73747c733a31393a226d61696c2e73697374656d617470762e636f6d223b736d74705f757365727c733a32333a226e6f2d7265706c794073697374656d617470762e636f6d223b736d74705f706173737c733a38383a226e727879507977326f635a4f70424d314d4f6b4a416568377648505a773172674f725566494b32526834304e344a44383236507142647977312b317570735030467157452f576271736a6769323868473236326c72513d3d223b736d74705f706f72747c733a333a22353837223b6d61696c706174687c4e3b756269636163696f6e5f584d4c7c733a303a22223b706173735f6669726d617c733a363a22313233343536223b757365725f736f6c7c733a373a22314441544f5331223b706173735f736f6c7c733a363a22314461746f73223b),
('11ac099d3e4d3b57f453bb2c39f8dc30a501c517', '::1', 1598317163, 0x5f5f63695f6c6173745f726567656e65726174657c693a313539383331373135353b6c6f63616c7c733a313a2231223b6c6973746156656e74617c693a303b6964656e746974797c733a32303a2261646d696e4073697374656d617470762e636f6d223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a32303a2261646d696e4073697374656d617470762e636f6d223b757365725f69647c733a313a2231223b66697273745f6e616d657c733a353a2241646d696e223b6c6173745f6e616d657c733a333a22545056223b637265617465645f6f6e7c733a32323a2232322f30382f323031382031323a32393a313120504d223b6f6c645f6c6173745f6c6f67696e7c733a31303a2231353836343637333536223b6c6173745f69707c733a31353a223138312e3137362e3132312e313037223b6176617461727c4e3b67656e6465727c733a343a226d616c65223b67726f75705f69647c733a313a2231223b72617a6f6e5f736f6369616c7c733a32343a22456d70726573612064652050727565626120262064656d6f223b7275637c733a31313a223132333435363738393132223b646972656363696f6e7c733a31393a2261762e20646573636f6e6f6369646120313233223b726567696f6e7c733a343a226c696d61223b706169737c733a343a2270657275223b6e65676f63696f7c693a303b626574617c733a313a2231223b686162696c6974615f62746e5f7061676f7c733a313a2231223b686162696c6974615f62746e5f63616a617c733a313a2230223b6c6f676f7c733a31363a226c6f676f2d656d70726573612e6a7067223b706f735f6c6f676f7c733a313a2232223b6c6f676f5f7064667c733a31323a226c6f676f2d7064662e706e67223b747970655f696d6167656e5f7064667c733a313a2231223b70726f746f636f6c7c733a343a22736d7470223b736d74705f686f73747c733a31393a226d61696c2e73697374656d617470762e636f6d223b736d74705f757365727c733a32333a226e6f2d7265706c794073697374656d617470762e636f6d223b736d74705f706173737c733a38383a226e727879507977326f635a4f70424d314d4f6b4a416568377648505a773172674f725566494b32526834304e344a44383236507142647977312b317570735030467157452f576271736a6769323868473236326c72513d3d223b736d74705f706f72747c733a333a22353837223b6d61696c706174687c4e3b756269636163696f6e5f584d4c7c733a303a22223b706173735f6669726d617c733a363a22313233343536223b757365725f736f6c7c733a373a22314441544f5331223b706173735f736f6c7c733a363a22314461746f73223b),
('12ca6b922bd01212fc75e5d3b3c981192ef5f501', '::1', 1598608152, 0x5f5f63695f6c6173745f726567656e65726174657c693a313539383630383135323b6c6f63616c7c733a313a2231223b6c6973746156656e74617c693a303b6964656e746974797c733a32303a2261646d696e4073697374656d617470762e636f6d223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a32303a2261646d696e4073697374656d617470762e636f6d223b757365725f69647c733a313a2231223b66697273745f6e616d657c733a353a2241646d696e223b6c6173745f6e616d657c733a333a22545056223b637265617465645f6f6e7c733a32323a2232322f30382f323031382031323a32393a313120504d223b6f6c645f6c6173745f6c6f67696e7c733a31303a2231353938353735363639223b6c6173745f69707c733a333a223a3a31223b6176617461727c4e3b67656e6465727c733a343a226d616c65223b67726f75705f69647c733a313a2231223b72617a6f6e5f736f6369616c7c733a32343a22456d70726573612064652050727565626120262064656d6f223b7275637c733a31313a223132333435363738393132223b646972656363696f6e7c733a31393a2261762e20646573636f6e6f6369646120313233223b726567696f6e7c733a343a226c696d61223b706169737c733a343a2270657275223b6e65676f63696f7c733a313a2230223b626574617c733a313a2231223b686162696c6974615f62746e5f7061676f7c733a313a2231223b686162696c6974615f62746e5f63616a617c733a313a2230223b6c6f676f7c733a31363a226c6f676f2d656d70726573612e6a7067223b706f735f6c6f676f7c733a313a2232223b6c6f676f5f7064667c733a31323a226c6f676f2d7064662e706e67223b747970655f696d6167656e5f7064667c733a313a2231223b70726f746f636f6c7c733a343a22736d7470223b736d74705f686f73747c733a31393a226d61696c2e73697374656d617470762e636f6d223b736d74705f757365727c733a32333a226e6f2d7265706c794073697374656d617470762e636f6d223b736d74705f706173737c733a38383a226e727879507977326f635a4f70424d314d4f6b4a416568377648505a773172674f725566494b32526834304e344a44383236507142647977312b317570735030467157452f576271736a6769323868473236326c72513d3d223b736d74705f706f72747c733a333a22353837223b6d61696c706174687c4e3b756269636163696f6e5f584d4c7c733a303a22223b706173735f6669726d617c733a363a22313233343536223b757365725f736f6c7c733a373a22314441544f5331223b706173735f736f6c7c733a363a22314461746f73223b),
('1aaed1d19784ffc01efaa52c12436700cb60bc57', '::1', 1598321191, 0x5f5f63695f6c6173745f726567656e65726174657c693a313539383332313132353b6c6f63616c7c733a313a2231223b6c6973746156656e74617c693a303b6964656e746974797c733a32303a2261646d696e4073697374656d617470762e636f6d223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a32303a2261646d696e4073697374656d617470762e636f6d223b757365725f69647c733a313a2231223b66697273745f6e616d657c733a353a2241646d696e223b6c6173745f6e616d657c733a333a22545056223b637265617465645f6f6e7c733a32323a2232322f30382f323031382031323a32393a313120504d223b6f6c645f6c6173745f6c6f67696e7c733a31303a2231353938333137313539223b6c6173745f69707c733a333a223a3a31223b6176617461727c4e3b67656e6465727c733a343a226d616c65223b67726f75705f69647c733a313a2231223b72617a6f6e5f736f6369616c7c733a32343a22456d70726573612064652050727565626120262064656d6f223b7275637c733a31313a223132333435363738393132223b646972656363696f6e7c733a31393a2261762e20646573636f6e6f6369646120313233223b726567696f6e7c733a343a226c696d61223b706169737c733a343a2270657275223b6e65676f63696f7c733a313a2230223b626574617c733a313a2231223b686162696c6974615f62746e5f7061676f7c733a313a2231223b686162696c6974615f62746e5f63616a617c733a313a2230223b6c6f676f7c733a31363a226c6f676f2d656d70726573612e6a7067223b706f735f6c6f676f7c733a313a2232223b6c6f676f5f7064667c733a31323a226c6f676f2d7064662e706e67223b747970655f696d6167656e5f7064667c733a313a2231223b70726f746f636f6c7c733a343a22736d7470223b736d74705f686f73747c733a31393a226d61696c2e73697374656d617470762e636f6d223b736d74705f757365727c733a32333a226e6f2d7265706c794073697374656d617470762e636f6d223b736d74705f706173737c733a38383a226e727879507977326f635a4f70424d314d4f6b4a416568377648505a773172674f725566494b32526834304e344a44383236507142647977312b317570735030467157452f576271736a6769323868473236326c72513d3d223b736d74705f706f72747c733a333a22353837223b6d61696c706174687c4e3b756269636163696f6e5f584d4c7c733a303a22223b706173735f6669726d617c733a363a22313233343536223b757365725f736f6c7c733a373a22314441544f5331223b706173735f736f6c7c733a363a22314461746f73223b),
('1b5fda5213e82c164c299b04b4179906b3fbffaf', '::1', 1598618113, 0x5f5f63695f6c6173745f726567656e65726174657c693a313539383631383131333b),
('21f5409461e0ee09f03e4b61c967fd49f02f7c25', '::1', 1598560588, 0x5f5f63695f6c6173745f726567656e65726174657c693a313539383536303332383b6c6f63616c7c733a313a2231223b6c6973746156656e74617c693a303b6964656e746974797c733a32303a2261646d696e4073697374656d617470762e636f6d223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a32303a2261646d696e4073697374656d617470762e636f6d223b757365725f69647c733a313a2231223b66697273745f6e616d657c733a353a2241646d696e223b6c6173745f6e616d657c733a333a22545056223b637265617465645f6f6e7c733a32323a2232322f30382f323031382031323a32393a313120504d223b6f6c645f6c6173745f6c6f67696e7c733a31303a2231353938333632383536223b6c6173745f69707c733a333a223a3a31223b6176617461727c4e3b67656e6465727c733a343a226d616c65223b67726f75705f69647c733a313a2231223b72617a6f6e5f736f6369616c7c733a32343a22456d70726573612064652050727565626120262064656d6f223b7275637c733a31313a223132333435363738393132223b646972656363696f6e7c733a31393a2261762e20646573636f6e6f6369646120313233223b726567696f6e7c733a343a226c696d61223b706169737c733a343a2270657275223b6e65676f63696f7c733a313a2230223b626574617c733a313a2231223b686162696c6974615f62746e5f7061676f7c733a313a2231223b686162696c6974615f62746e5f63616a617c733a313a2230223b6c6f676f7c733a31363a226c6f676f2d656d70726573612e6a7067223b706f735f6c6f676f7c733a313a2232223b6c6f676f5f7064667c733a31323a226c6f676f2d7064662e706e67223b747970655f696d6167656e5f7064667c733a313a2231223b70726f746f636f6c7c733a343a22736d7470223b736d74705f686f73747c733a31393a226d61696c2e73697374656d617470762e636f6d223b736d74705f757365727c733a32333a226e6f2d7265706c794073697374656d617470762e636f6d223b736d74705f706173737c733a38383a226e727879507977326f635a4f70424d314d4f6b4a416568377648505a773172674f725566494b32526834304e344a44383236507142647977312b317570735030467157452f576271736a6769323868473236326c72513d3d223b736d74705f706f72747c733a333a22353837223b6d61696c706174687c4e3b756269636163696f6e5f584d4c7c733a303a22223b706173735f6669726d617c733a363a22313233343536223b757365725f736f6c7c733a373a22314441544f5331223b706173735f736f6c7c733a363a22314461746f73223b),
('2635e31d3a57a2679b8433e798622272bd77e342', '::1', 1598617578, 0x5f5f63695f6c6173745f726567656e65726174657c693a313539383631373537373b6c6f63616c7c733a313a2231223b6c6973746156656e74617c693a303b6964656e746974797c733a32303a2261646d696e4073697374656d617470762e636f6d223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a32303a2261646d696e4073697374656d617470762e636f6d223b757365725f69647c733a313a2231223b66697273745f6e616d657c733a353a2241646d696e223b6c6173745f6e616d657c733a333a22545056223b637265617465645f6f6e7c733a32323a2232322f30382f323031382031323a32393a313120504d223b6f6c645f6c6173745f6c6f67696e7c733a31303a2231353938353735363639223b6c6173745f69707c733a333a223a3a31223b6176617461727c4e3b67656e6465727c733a343a226d616c65223b67726f75705f69647c733a313a2231223b72617a6f6e5f736f6369616c7c733a32343a22456d70726573612064652050727565626120262064656d6f223b7275637c733a31313a223132333435363738393132223b646972656363696f6e7c733a31393a2261762e20646573636f6e6f6369646120313233223b726567696f6e7c733a343a226c696d61223b706169737c733a343a2270657275223b6e65676f63696f7c733a313a2230223b626574617c733a313a2231223b686162696c6974615f62746e5f7061676f7c733a313a2231223b686162696c6974615f62746e5f63616a617c733a313a2230223b6c6f676f7c733a31363a226c6f676f2d656d70726573612e6a7067223b706f735f6c6f676f7c733a313a2232223b6c6f676f5f7064667c733a31323a226c6f676f2d7064662e706e67223b747970655f696d6167656e5f7064667c733a313a2231223b70726f746f636f6c7c733a343a22736d7470223b736d74705f686f73747c733a31393a226d61696c2e73697374656d617470762e636f6d223b736d74705f757365727c733a32333a226e6f2d7265706c794073697374656d617470762e636f6d223b736d74705f706173737c733a38383a226e727879507977326f635a4f70424d314d4f6b4a416568377648505a773172674f725566494b32526834304e344a44383236507142647977312b317570735030467157452f576271736a6769323868473236326c72513d3d223b736d74705f706f72747c733a333a22353837223b6d61696c706174687c4e3b756269636163696f6e5f584d4c7c733a303a22223b706173735f6669726d617c733a363a22313233343536223b757365725f736f6c7c733a373a22314441544f5331223b706173735f736f6c7c733a363a22314461746f73223b),
('2b52a02e9f938813ad8f837fa4b0169fa4a719bf', '::1', 1598835005, 0x5f5f63695f6c6173745f726567656e65726174657c693a313539383833343734323b6c6f63616c7c733a313a2231223b6c6973746156656e74617c693a303b6964656e746974797c733a32303a2261646d696e4073697374656d617470762e636f6d223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a32303a2261646d696e4073697374656d617470762e636f6d223b757365725f69647c733a313a2231223b66697273745f6e616d657c733a353a2241646d696e223b6c6173745f6e616d657c733a333a22545056223b637265617465645f6f6e7c733a32323a2232322f30382f323031382031323a32393a313120504d223b6f6c645f6c6173745f6c6f67696e7c733a31303a2231353938383334303133223b6c6173745f69707c733a333a223a3a31223b6176617461727c4e3b67656e6465727c733a343a226d616c65223b67726f75705f69647c733a313a2231223b72617a6f6e5f736f6369616c7c733a32343a22456d70726573612064652050727565626120262064656d6f223b7275637c733a31313a223132333435363738393132223b646972656363696f6e7c733a31393a2261762e20646573636f6e6f6369646120313233223b726567696f6e7c733a343a226c696d61223b706169737c733a343a2270657275223b6e65676f63696f7c733a313a2230223b626574617c733a313a2230223b686162696c6974615f62746e5f7061676f7c733a313a2231223b686162696c6974615f62746e5f63616a617c733a313a2230223b6c6f676f7c733a31363a226c6f676f2d656d70726573612e6a7067223b706f735f6c6f676f7c733a313a2232223b6c6f676f5f7064667c733a31323a226c6f676f2d7064662e706e67223b747970655f696d6167656e5f7064667c733a313a2231223b70726f746f636f6c7c733a343a22736d7470223b736d74705f686f73747c733a31393a226d61696c2e73697374656d617470762e636f6d223b736d74705f757365727c733a32333a226e6f2d7265706c794073697374656d617470762e636f6d223b736d74705f706173737c733a38383a2246795764306743646e7343317a326f54377137684b48655a757873612b706a5948684542527656415a3041616751693749453776536a75756c4142434530506b4576733356447872355756783131434c35387a4377413d3d223b736d74705f706f72747c733a333a22353837223b6d61696c706174687c4e3b756269636163696f6e5f584d4c7c733a303a22223b706173735f6669726d617c733a333a22343434223b757365725f736f6c7c733a333a22313233223b706173735f736f6c7c733a303a22223b6d6573736167657c733a33373a22436f6e6669677572616369c3b36e2061637475616c697a61646120636f6e20c3a97869746f223b5f5f63695f766172737c613a313a7b733a373a226d657373616765223b733a333a226f6c64223b7d),
('2ttfeq55fkk3mlvb5g9gcioo7k', '::1', 1598834013, 0x5f5f63695f6c6173745f726567656e65726174657c693a313539383833343031333b),
('36954820fa9694642bbe6ec3047a0717576f1161', '::1', 1598580564, 0x5f5f63695f6c6173745f726567656e65726174657c693a313539383538303438343b6c6f63616c7c733a313a2231223b6c6973746156656e74617c693a303b6964656e746974797c733a32303a2261646d696e4073697374656d617470762e636f6d223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a32303a2261646d696e4073697374656d617470762e636f6d223b757365725f69647c733a313a2231223b66697273745f6e616d657c733a353a2241646d696e223b6c6173745f6e616d657c733a333a22545056223b637265617465645f6f6e7c733a32323a2232322f30382f323031382031323a32393a313120504d223b6f6c645f6c6173745f6c6f67696e7c733a31303a2231353938353735363332223b6c6173745f69707c733a333a223a3a31223b6176617461727c4e3b67656e6465727c733a343a226d616c65223b67726f75705f69647c733a313a2231223b72617a6f6e5f736f6369616c7c733a32343a22456d70726573612064652050727565626120262064656d6f223b7275637c733a31313a223132333435363738393132223b646972656363696f6e7c733a31393a2261762e20646573636f6e6f6369646120313233223b726567696f6e7c733a343a226c696d61223b706169737c733a343a2270657275223b6e65676f63696f7c733a313a2230223b626574617c733a313a2231223b686162696c6974615f62746e5f7061676f7c733a313a2231223b686162696c6974615f62746e5f63616a617c733a313a2230223b6c6f676f7c733a31363a226c6f676f2d656d70726573612e6a7067223b706f735f6c6f676f7c733a313a2232223b6c6f676f5f7064667c733a31323a226c6f676f2d7064662e706e67223b747970655f696d6167656e5f7064667c733a313a2231223b70726f746f636f6c7c733a343a22736d7470223b736d74705f686f73747c733a31393a226d61696c2e73697374656d617470762e636f6d223b736d74705f757365727c733a32333a226e6f2d7265706c794073697374656d617470762e636f6d223b736d74705f706173737c733a38383a226e727879507977326f635a4f70424d314d4f6b4a416568377648505a773172674f725566494b32526834304e344a44383236507142647977312b317570735030467157452f576271736a6769323868473236326c72513d3d223b736d74705f706f72747c733a333a22353837223b6d61696c706174687c4e3b756269636163696f6e5f584d4c7c733a303a22223b706173735f6669726d617c733a363a22313233343536223b757365725f736f6c7c733a373a22314441544f5331223b706173735f736f6c7c733a363a22314461746f73223b),
('38e3ffaddece8d8da81288b3da4286d9ee49076b', '::1', 1598818162, 0x5f5f63695f6c6173745f726567656e65726174657c693a313539383831383136323b6c6f63616c7c733a313a2231223b6c6973746156656e74617c693a303b6964656e746974797c733a32303a2261646d696e4073697374656d617470762e636f6d223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a32303a2261646d696e4073697374656d617470762e636f6d223b757365725f69647c733a313a2231223b66697273745f6e616d657c733a353a2241646d696e223b6c6173745f6e616d657c733a333a22545056223b637265617465645f6f6e7c733a32323a2232322f30382f323031382031323a32393a313120504d223b6f6c645f6c6173745f6c6f67696e7c733a31303a2231353938383136313334223b6c6173745f69707c733a333a223a3a31223b6176617461727c4e3b67656e6465727c733a343a226d616c65223b67726f75705f69647c733a313a2231223b72617a6f6e5f736f6369616c7c733a32343a22456d70726573612064652050727565626120262064656d6f223b7275637c733a31313a223132333435363738393132223b646972656363696f6e7c733a31393a2261762e20646573636f6e6f6369646120313233223b726567696f6e7c733a343a226c696d61223b706169737c733a343a2270657275223b6e65676f63696f7c733a313a2230223b626574617c733a313a2230223b686162696c6974615f62746e5f7061676f7c733a313a2231223b686162696c6974615f62746e5f63616a617c733a313a2230223b6c6f676f7c733a31363a226c6f676f2d656d70726573612e6a7067223b706f735f6c6f676f7c733a313a2232223b6c6f676f5f7064667c733a31323a226c6f676f2d7064662e706e67223b747970655f696d6167656e5f7064667c733a313a2231223b70726f746f636f6c7c733a343a22736d7470223b736d74705f686f73747c733a31393a226d61696c2e73697374656d617470762e636f6d223b736d74705f757365727c733a32333a226e6f2d7265706c794073697374656d617470762e636f6d223b736d74705f706173737c733a38383a2246795764306743646e7343317a326f54377137684b48655a757873612b706a5948684542527656415a3041616751693749453776536a75756c4142434530506b4576733356447872355756783131434c35387a4377413d3d223b736d74705f706f72747c733a333a22353837223b6d61696c706174687c4e3b756269636163696f6e5f584d4c7c733a303a22223b706173735f6669726d617c733a333a22343434223b757365725f736f6c7c733a333a22313233223b706173735f736f6c7c733a303a22223b),
('3a52867bc5333183728683ed30240e3f00488b5d', '::1', 1598556809, 0x5f5f63695f6c6173745f726567656e65726174657c693a313539383535363830373b6c6f63616c7c733a313a2231223b6c6973746156656e74617c693a303b6964656e746974797c733a32303a2261646d696e4073697374656d617470762e636f6d223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a32303a2261646d696e4073697374656d617470762e636f6d223b757365725f69647c733a313a2231223b66697273745f6e616d657c733a353a2241646d696e223b6c6173745f6e616d657c733a333a22545056223b637265617465645f6f6e7c733a32323a2232322f30382f323031382031323a32393a313120504d223b6f6c645f6c6173745f6c6f67696e7c733a31303a2231353938333632383536223b6c6173745f69707c733a333a223a3a31223b6176617461727c4e3b67656e6465727c733a343a226d616c65223b67726f75705f69647c733a313a2231223b72617a6f6e5f736f6369616c7c733a32343a22456d70726573612064652050727565626120262064656d6f223b7275637c733a31313a223132333435363738393132223b646972656363696f6e7c733a31393a2261762e20646573636f6e6f6369646120313233223b726567696f6e7c733a343a226c696d61223b706169737c733a343a2270657275223b6e65676f63696f7c733a313a2230223b626574617c733a313a2231223b686162696c6974615f62746e5f7061676f7c733a313a2231223b686162696c6974615f62746e5f63616a617c733a313a2230223b6c6f676f7c733a31363a226c6f676f2d656d70726573612e6a7067223b706f735f6c6f676f7c733a313a2232223b6c6f676f5f7064667c733a31323a226c6f676f2d7064662e706e67223b747970655f696d6167656e5f7064667c733a313a2231223b70726f746f636f6c7c733a343a22736d7470223b736d74705f686f73747c733a31393a226d61696c2e73697374656d617470762e636f6d223b736d74705f757365727c733a32333a226e6f2d7265706c794073697374656d617470762e636f6d223b736d74705f706173737c733a38383a226e727879507977326f635a4f70424d314d4f6b4a416568377648505a773172674f725566494b32526834304e344a44383236507142647977312b317570735030467157452f576271736a6769323868473236326c72513d3d223b736d74705f706f72747c733a333a22353837223b6d61696c706174687c4e3b756269636163696f6e5f584d4c7c733a303a22223b706173735f6669726d617c733a363a22313233343536223b757365725f736f6c7c733a373a22314441544f5331223b706173735f736f6c7c733a363a22314461746f73223b6d6573736167657c733a34353a223c703ec2a14c6f67756561646f20636f6e20c3a97869746f2120536561206269656e76656e69646f213c2f703e223b5f5f63695f766172737c613a313a7b733a373a226d657373616765223b733a333a226f6c64223b7d),
('3b3af4b62138418fce8cc55758f02e686e9f14f9', '::1', 1598601756, 0x5f5f63695f6c6173745f726567656e65726174657c693a313539383630313733333b6c6f63616c7c733a313a2231223b6c6973746156656e74617c693a303b6964656e746974797c733a32303a2261646d696e4073697374656d617470762e636f6d223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a32303a2261646d696e4073697374656d617470762e636f6d223b757365725f69647c733a313a2231223b66697273745f6e616d657c733a353a2241646d696e223b6c6173745f6e616d657c733a333a22545056223b637265617465645f6f6e7c733a32323a2232322f30382f323031382031323a32393a313120504d223b6f6c645f6c6173745f6c6f67696e7c733a31303a2231353938353735363639223b6c6173745f69707c733a333a223a3a31223b6176617461727c4e3b67656e6465727c733a343a226d616c65223b67726f75705f69647c733a313a2231223b72617a6f6e5f736f6369616c7c733a32343a22456d70726573612064652050727565626120262064656d6f223b7275637c733a31313a223132333435363738393132223b646972656363696f6e7c733a31393a2261762e20646573636f6e6f6369646120313233223b726567696f6e7c733a343a226c696d61223b706169737c733a343a2270657275223b6e65676f63696f7c733a313a2230223b626574617c733a313a2231223b686162696c6974615f62746e5f7061676f7c733a313a2231223b686162696c6974615f62746e5f63616a617c733a313a2230223b6c6f676f7c733a31363a226c6f676f2d656d70726573612e6a7067223b706f735f6c6f676f7c733a313a2232223b6c6f676f5f7064667c733a31323a226c6f676f2d7064662e706e67223b747970655f696d6167656e5f7064667c733a313a2231223b70726f746f636f6c7c733a343a22736d7470223b736d74705f686f73747c733a31393a226d61696c2e73697374656d617470762e636f6d223b736d74705f757365727c733a32333a226e6f2d7265706c794073697374656d617470762e636f6d223b736d74705f706173737c733a38383a226e727879507977326f635a4f70424d314d4f6b4a416568377648505a773172674f725566494b32526834304e344a44383236507142647977312b317570735030467157452f576271736a6769323868473236326c72513d3d223b736d74705f706f72747c733a333a22353837223b6d61696c706174687c4e3b756269636163696f6e5f584d4c7c733a303a22223b706173735f6669726d617c733a363a22313233343536223b757365725f736f6c7c733a373a22314441544f5331223b706173735f736f6c7c733a363a22314461746f73223b),
('3d6f66690716ec97c099c75352603d4cc249df79', '::1', 1598324404, 0x5f5f63695f6c6173745f726567656e65726174657c693a313539383332343334383b6c6f63616c7c733a313a2231223b6c6973746156656e74617c693a303b6964656e746974797c733a32303a2261646d696e4073697374656d617470762e636f6d223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a32303a2261646d696e4073697374656d617470762e636f6d223b757365725f69647c733a313a2231223b66697273745f6e616d657c733a353a2241646d696e223b6c6173745f6e616d657c733a333a22545056223b637265617465645f6f6e7c733a32323a2232322f30382f323031382031323a32393a313120504d223b6f6c645f6c6173745f6c6f67696e7c733a31303a2231353938333137313539223b6c6173745f69707c733a333a223a3a31223b6176617461727c4e3b67656e6465727c733a343a226d616c65223b67726f75705f69647c733a313a2231223b72617a6f6e5f736f6369616c7c733a32343a22456d70726573612064652050727565626120262064656d6f223b7275637c733a31313a223132333435363738393132223b646972656363696f6e7c733a31393a2261762e20646573636f6e6f6369646120313233223b726567696f6e7c733a343a226c696d61223b706169737c733a343a2270657275223b6e65676f63696f7c733a313a2230223b626574617c733a313a2231223b686162696c6974615f62746e5f7061676f7c733a313a2231223b686162696c6974615f62746e5f63616a617c733a313a2230223b6c6f676f7c733a31363a226c6f676f2d656d70726573612e6a7067223b706f735f6c6f676f7c733a313a2232223b6c6f676f5f7064667c733a31323a226c6f676f2d7064662e706e67223b747970655f696d6167656e5f7064667c733a313a2231223b70726f746f636f6c7c733a343a22736d7470223b736d74705f686f73747c733a31393a226d61696c2e73697374656d617470762e636f6d223b736d74705f757365727c733a32333a226e6f2d7265706c794073697374656d617470762e636f6d223b736d74705f706173737c733a38383a226e727879507977326f635a4f70424d314d4f6b4a416568377648505a773172674f725566494b32526834304e344a44383236507142647977312b317570735030467157452f576271736a6769323868473236326c72513d3d223b736d74705f706f72747c733a333a22353837223b6d61696c706174687c4e3b756269636163696f6e5f584d4c7c733a303a22223b706173735f6669726d617c733a363a22313233343536223b757365725f736f6c7c733a373a22314441544f5331223b706173735f736f6c7c733a363a22314461746f73223b),
('3f8146e765d26bd6ec148b32e7bf9269af45a82e', '::1', 1598610557, 0x5f5f63695f6c6173745f726567656e65726174657c693a313539383631303534363b6c6f63616c7c733a313a2231223b6c6973746156656e74617c693a303b6964656e746974797c733a32303a2261646d696e4073697374656d617470762e636f6d223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a32303a2261646d696e4073697374656d617470762e636f6d223b757365725f69647c733a313a2231223b66697273745f6e616d657c733a353a2241646d696e223b6c6173745f6e616d657c733a333a22545056223b637265617465645f6f6e7c733a32323a2232322f30382f323031382031323a32393a313120504d223b6f6c645f6c6173745f6c6f67696e7c733a31303a2231353938353735363639223b6c6173745f69707c733a333a223a3a31223b6176617461727c4e3b67656e6465727c733a343a226d616c65223b67726f75705f69647c733a313a2231223b72617a6f6e5f736f6369616c7c733a32343a22456d70726573612064652050727565626120262064656d6f223b7275637c733a31313a223132333435363738393132223b646972656363696f6e7c733a31393a2261762e20646573636f6e6f6369646120313233223b726567696f6e7c733a343a226c696d61223b706169737c733a343a2270657275223b6e65676f63696f7c733a313a2230223b626574617c733a313a2231223b686162696c6974615f62746e5f7061676f7c733a313a2231223b686162696c6974615f62746e5f63616a617c733a313a2230223b6c6f676f7c733a31363a226c6f676f2d656d70726573612e6a7067223b706f735f6c6f676f7c733a313a2232223b6c6f676f5f7064667c733a31323a226c6f676f2d7064662e706e67223b747970655f696d6167656e5f7064667c733a313a2231223b70726f746f636f6c7c733a343a22736d7470223b736d74705f686f73747c733a31393a226d61696c2e73697374656d617470762e636f6d223b736d74705f757365727c733a32333a226e6f2d7265706c794073697374656d617470762e636f6d223b736d74705f706173737c733a38383a226e727879507977326f635a4f70424d314d4f6b4a416568377648505a773172674f725566494b32526834304e344a44383236507142647977312b317570735030467157452f576271736a6769323868473236326c72513d3d223b736d74705f706f72747c733a333a22353837223b6d61696c706174687c4e3b756269636163696f6e5f584d4c7c733a303a22223b706173735f6669726d617c733a363a22313233343536223b757365725f736f6c7c733a373a22314441544f5331223b706173735f736f6c7c733a363a22314461746f73223b6d6573736167657c733a33373a22436f6e6669677572616369c3b36e2061637475616c697a61646120636f6e20c3a97869746f223b5f5f63695f766172737c613a313a7b733a373a226d657373616765223b733a333a226f6c64223b7d),
('46cdb54bb71d22484558b80622e9093057c2260a', '::1', 1598648461, 0x5f5f63695f6c6173745f726567656e65726174657c693a313539383634383434333b6c6f63616c7c733a313a2231223b6c6973746156656e74617c693a303b6964656e746974797c733a32303a2261646d696e4073697374656d617470762e636f6d223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a32303a2261646d696e4073697374656d617470762e636f6d223b757365725f69647c733a313a2231223b66697273745f6e616d657c733a353a2241646d696e223b6c6173745f6e616d657c733a333a22545056223b637265617465645f6f6e7c733a32323a2232322f30382f323031382031323a32393a313120504d223b6f6c645f6c6173745f6c6f67696e7c733a31303a2231353938363438323135223b6c6173745f69707c733a333a223a3a31223b6176617461727c4e3b67656e6465727c733a343a226d616c65223b67726f75705f69647c733a313a2231223b72617a6f6e5f736f6369616c7c733a303a22223b7275637c733a31313a223132333435363738393132223b646972656363696f6e7c733a31393a2261762e20646573636f6e6f6369646120313233223b726567696f6e7c733a343a226c696d61223b706169737c733a343a2270657275223b6e65676f63696f7c733a313a2230223b626574617c733a313a2230223b686162696c6974615f62746e5f7061676f7c733a313a2231223b686162696c6974615f62746e5f63616a617c733a313a2230223b6c6f676f7c733a31363a226c6f676f2d656d70726573612e6a7067223b706f735f6c6f676f7c733a313a2232223b6c6f676f5f7064667c733a31323a226c6f676f2d7064662e706e67223b747970655f696d6167656e5f7064667c733a313a2231223b70726f746f636f6c7c733a343a22736d7470223b736d74705f686f73747c733a31393a226d61696c2e73697374656d617470762e636f6d223b736d74705f757365727c733a32333a226e6f2d7265706c794073697374656d617470762e636f6d223b736d74705f706173737c733a38383a222b5534766263496d454c7058756278756366675334746c437a545a634249705351487654482f634b4748726733636779504d2b784d5249684a622f4e6a324f37637475386d43586b71547a696b686633766b715453773d3d223b736d74705f706f72747c733a333a22353837223b6d61696c706174687c4e3b756269636163696f6e5f584d4c7c733a303a22223b706173735f6669726d617c733a333a22343434223b757365725f736f6c7c733a333a22313233223b706173735f736f6c7c733a303a22223b6d6573736167657c733a33373a22436f6e6669677572616369c3b36e2061637475616c697a61646120636f6e20c3a97869746f223b5f5f63695f766172737c613a313a7b733a373a226d657373616765223b733a333a226f6c64223b7d),
('47d935d4886c08f481d61f2b3e2137dcf0f0c066', '::1', 1598324216, 0x5f5f63695f6c6173745f726567656e65726174657c693a313539383332343031373b6c6f63616c7c733a313a2231223b6c6973746156656e74617c693a303b6964656e746974797c733a32303a2261646d696e4073697374656d617470762e636f6d223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a32303a2261646d696e4073697374656d617470762e636f6d223b757365725f69647c733a313a2231223b66697273745f6e616d657c733a353a2241646d696e223b6c6173745f6e616d657c733a333a22545056223b637265617465645f6f6e7c733a32323a2232322f30382f323031382031323a32393a313120504d223b6f6c645f6c6173745f6c6f67696e7c733a31303a2231353938333137313539223b6c6173745f69707c733a333a223a3a31223b6176617461727c4e3b67656e6465727c733a343a226d616c65223b67726f75705f69647c733a313a2231223b72617a6f6e5f736f6369616c7c733a32343a22456d70726573612064652050727565626120262064656d6f223b7275637c733a31313a223132333435363738393132223b646972656363696f6e7c733a31393a2261762e20646573636f6e6f6369646120313233223b726567696f6e7c733a343a226c696d61223b706169737c733a343a2270657275223b6e65676f63696f7c733a313a2230223b626574617c733a313a2231223b686162696c6974615f62746e5f7061676f7c733a313a2231223b686162696c6974615f62746e5f63616a617c733a313a2230223b6c6f676f7c733a31363a226c6f676f2d656d70726573612e6a7067223b706f735f6c6f676f7c733a313a2232223b6c6f676f5f7064667c733a31323a226c6f676f2d7064662e706e67223b747970655f696d6167656e5f7064667c733a313a2231223b70726f746f636f6c7c733a343a22736d7470223b736d74705f686f73747c733a31393a226d61696c2e73697374656d617470762e636f6d223b736d74705f757365727c733a32333a226e6f2d7265706c794073697374656d617470762e636f6d223b736d74705f706173737c733a38383a226e727879507977326f635a4f70424d314d4f6b4a416568377648505a773172674f725566494b32526834304e344a44383236507142647977312b317570735030467157452f576271736a6769323868473236326c72513d3d223b736d74705f706f72747c733a333a22353837223b6d61696c706174687c4e3b756269636163696f6e5f584d4c7c733a303a22223b706173735f6669726d617c733a363a22313233343536223b757365725f736f6c7c733a373a22314441544f5331223b706173735f736f6c7c733a363a22314461746f73223b),
('481220b7fe2c160ad6d9cd19c842b31a6ffa741f', '::1', 1598363106, 0x5f5f63695f6c6173745f726567656e65726174657c693a313539383336323835343b6c6f63616c7c733a313a2231223b6c6973746156656e74617c693a303b6964656e746974797c733a32303a2261646d696e4073697374656d617470762e636f6d223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a32303a2261646d696e4073697374656d617470762e636f6d223b757365725f69647c733a313a2231223b66697273745f6e616d657c733a353a2241646d696e223b6c6173745f6e616d657c733a333a22545056223b637265617465645f6f6e7c733a32323a2232322f30382f323031382031323a32393a313120504d223b6f6c645f6c6173745f6c6f67696e7c733a31303a2231353938333339333733223b6c6173745f69707c733a333a223a3a31223b6176617461727c4e3b67656e6465727c733a343a226d616c65223b67726f75705f69647c733a313a2231223b72617a6f6e5f736f6369616c7c733a32343a22456d70726573612064652050727565626120262064656d6f223b7275637c733a31313a223132333435363738393132223b646972656363696f6e7c733a31393a2261762e20646573636f6e6f6369646120313233223b726567696f6e7c733a343a226c696d61223b706169737c733a343a2270657275223b6e65676f63696f7c733a313a2230223b626574617c733a313a2231223b686162696c6974615f62746e5f7061676f7c733a313a2231223b686162696c6974615f62746e5f63616a617c733a313a2230223b6c6f676f7c733a31363a226c6f676f2d656d70726573612e6a7067223b706f735f6c6f676f7c733a313a2232223b6c6f676f5f7064667c733a31323a226c6f676f2d7064662e706e67223b747970655f696d6167656e5f7064667c733a313a2231223b70726f746f636f6c7c733a343a22736d7470223b736d74705f686f73747c733a31393a226d61696c2e73697374656d617470762e636f6d223b736d74705f757365727c733a32333a226e6f2d7265706c794073697374656d617470762e636f6d223b736d74705f706173737c733a38383a226e727879507977326f635a4f70424d314d4f6b4a416568377648505a773172674f725566494b32526834304e344a44383236507142647977312b317570735030467157452f576271736a6769323868473236326c72513d3d223b736d74705f706f72747c733a333a22353837223b6d61696c706174687c4e3b756269636163696f6e5f584d4c7c733a303a22223b706173735f6669726d617c733a363a22313233343536223b757365725f736f6c7c733a373a22314441544f5331223b706173735f736f6c7c733a363a22314461746f73223b),
('4cf815fb3e0c315ba41714a73034e2f6c9516673', '::1', 1598816791, 0x5f5f63695f6c6173745f726567656e65726174657c693a313539383831363539383b6c6f63616c7c733a313a2231223b6c6973746156656e74617c693a303b6964656e746974797c733a32303a2261646d696e4073697374656d617470762e636f6d223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a32303a2261646d696e4073697374656d617470762e636f6d223b757365725f69647c733a313a2231223b66697273745f6e616d657c733a353a2241646d696e223b6c6173745f6e616d657c733a333a22545056223b637265617465645f6f6e7c733a32323a2232322f30382f323031382031323a32393a313120504d223b6f6c645f6c6173745f6c6f67696e7c733a31303a2231353938383136313334223b6c6173745f69707c733a333a223a3a31223b6176617461727c4e3b67656e6465727c733a343a226d616c65223b67726f75705f69647c733a313a2231223b72617a6f6e5f736f6369616c7c733a32343a22456d70726573612064652050727565626120262064656d6f223b7275637c733a31313a223132333435363738393132223b646972656363696f6e7c733a31393a2261762e20646573636f6e6f6369646120313233223b726567696f6e7c733a343a226c696d61223b706169737c733a343a2270657275223b6e65676f63696f7c733a313a2230223b626574617c733a313a2230223b686162696c6974615f62746e5f7061676f7c733a313a2231223b686162696c6974615f62746e5f63616a617c733a313a2230223b6c6f676f7c733a31363a226c6f676f2d656d70726573612e6a7067223b706f735f6c6f676f7c733a313a2232223b6c6f676f5f7064667c733a31323a226c6f676f2d7064662e706e67223b747970655f696d6167656e5f7064667c733a313a2231223b70726f746f636f6c7c733a343a22736d7470223b736d74705f686f73747c733a31393a226d61696c2e73697374656d617470762e636f6d223b736d74705f757365727c733a32333a226e6f2d7265706c794073697374656d617470762e636f6d223b736d74705f706173737c733a38383a2246795764306743646e7343317a326f54377137684b48655a757873612b706a5948684542527656415a3041616751693749453776536a75756c4142434530506b4576733356447872355756783131434c35387a4377413d3d223b736d74705f706f72747c733a333a22353837223b6d61696c706174687c4e3b756269636163696f6e5f584d4c7c733a303a22223b706173735f6669726d617c733a333a22343434223b757365725f736f6c7c733a333a22313233223b706173735f736f6c7c733a303a22223b),
('527057c91023f1faceed6e34bbc509ec51cf7c4c', '::1', 1598558733, 0x5f5f63695f6c6173745f726567656e65726174657c693a313539383535383538373b6c6f63616c7c733a313a2231223b6c6973746156656e74617c693a303b6964656e746974797c733a32303a2261646d696e4073697374656d617470762e636f6d223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a32303a2261646d696e4073697374656d617470762e636f6d223b757365725f69647c733a313a2231223b66697273745f6e616d657c733a353a2241646d696e223b6c6173745f6e616d657c733a333a22545056223b637265617465645f6f6e7c733a32323a2232322f30382f323031382031323a32393a313120504d223b6f6c645f6c6173745f6c6f67696e7c733a31303a2231353938333632383536223b6c6173745f69707c733a333a223a3a31223b6176617461727c4e3b67656e6465727c733a343a226d616c65223b67726f75705f69647c733a313a2231223b72617a6f6e5f736f6369616c7c733a32343a22456d70726573612064652050727565626120262064656d6f223b7275637c733a31313a223132333435363738393132223b646972656363696f6e7c733a31393a2261762e20646573636f6e6f6369646120313233223b726567696f6e7c733a343a226c696d61223b706169737c733a343a2270657275223b6e65676f63696f7c733a313a2230223b626574617c733a313a2231223b686162696c6974615f62746e5f7061676f7c733a313a2231223b686162696c6974615f62746e5f63616a617c733a313a2230223b6c6f676f7c733a31363a226c6f676f2d656d70726573612e6a7067223b706f735f6c6f676f7c733a313a2232223b6c6f676f5f7064667c733a31323a226c6f676f2d7064662e706e67223b747970655f696d6167656e5f7064667c733a313a2231223b70726f746f636f6c7c733a343a22736d7470223b736d74705f686f73747c733a31393a226d61696c2e73697374656d617470762e636f6d223b736d74705f757365727c733a32333a226e6f2d7265706c794073697374656d617470762e636f6d223b736d74705f706173737c733a38383a226e727879507977326f635a4f70424d314d4f6b4a416568377648505a773172674f725566494b32526834304e344a44383236507142647977312b317570735030467157452f576271736a6769323868473236326c72513d3d223b736d74705f706f72747c733a333a22353837223b6d61696c706174687c4e3b756269636163696f6e5f584d4c7c733a303a22223b706173735f6669726d617c733a363a22313233343536223b757365725f736f6c7c733a373a22314441544f5331223b706173735f736f6c7c733a363a22314461746f73223b),
('532fbec94ce33bcfcceda0e413cecc520074770d', '::1', 1598578390, 0x5f5f63695f6c6173745f726567656e65726174657c693a313539383537383331393b6c6f63616c7c733a313a2231223b6c6973746156656e74617c693a303b6964656e746974797c733a32303a2261646d696e4073697374656d617470762e636f6d223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a32303a2261646d696e4073697374656d617470762e636f6d223b757365725f69647c733a313a2231223b66697273745f6e616d657c733a353a2241646d696e223b6c6173745f6e616d657c733a333a22545056223b637265617465645f6f6e7c733a32323a2232322f30382f323031382031323a32393a313120504d223b6f6c645f6c6173745f6c6f67696e7c733a31303a2231353938353735363332223b6c6173745f69707c733a333a223a3a31223b6176617461727c4e3b67656e6465727c733a343a226d616c65223b67726f75705f69647c733a313a2231223b72617a6f6e5f736f6369616c7c733a32343a22456d70726573612064652050727565626120262064656d6f223b7275637c733a31313a223132333435363738393132223b646972656363696f6e7c733a31393a2261762e20646573636f6e6f6369646120313233223b726567696f6e7c733a343a226c696d61223b706169737c733a343a2270657275223b6e65676f63696f7c733a313a2230223b626574617c733a313a2231223b686162696c6974615f62746e5f7061676f7c733a313a2231223b686162696c6974615f62746e5f63616a617c733a313a2230223b6c6f676f7c733a31363a226c6f676f2d656d70726573612e6a7067223b706f735f6c6f676f7c733a313a2232223b6c6f676f5f7064667c733a31323a226c6f676f2d7064662e706e67223b747970655f696d6167656e5f7064667c733a313a2231223b70726f746f636f6c7c733a343a22736d7470223b736d74705f686f73747c733a31393a226d61696c2e73697374656d617470762e636f6d223b736d74705f757365727c733a32333a226e6f2d7265706c794073697374656d617470762e636f6d223b736d74705f706173737c733a38383a226e727879507977326f635a4f70424d314d4f6b4a416568377648505a773172674f725566494b32526834304e344a44383236507142647977312b317570735030467157452f576271736a6769323868473236326c72513d3d223b736d74705f706f72747c733a333a22353837223b6d61696c706174687c4e3b756269636163696f6e5f584d4c7c733a303a22223b706173735f6669726d617c733a363a22313233343536223b757365725f736f6c7c733a373a22314441544f5331223b706173735f736f6c7c733a363a22314461746f73223b),
('537e3935f4aca873e01c58af896df5237d7b2dc5', '::1', 1598581642, 0x5f5f63695f6c6173745f726567656e65726174657c693a313539383538313539383b6c6f63616c7c733a313a2231223b6c6973746156656e74617c693a303b6964656e746974797c733a32303a2261646d696e4073697374656d617470762e636f6d223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a32303a2261646d696e4073697374656d617470762e636f6d223b757365725f69647c733a313a2231223b66697273745f6e616d657c733a353a2241646d696e223b6c6173745f6e616d657c733a333a22545056223b637265617465645f6f6e7c733a32323a2232322f30382f323031382031323a32393a313120504d223b6f6c645f6c6173745f6c6f67696e7c733a31303a2231353938353735363332223b6c6173745f69707c733a333a223a3a31223b6176617461727c4e3b67656e6465727c733a343a226d616c65223b67726f75705f69647c733a313a2231223b72617a6f6e5f736f6369616c7c733a32343a22456d70726573612064652050727565626120262064656d6f223b7275637c733a31313a223132333435363738393132223b646972656363696f6e7c733a31393a2261762e20646573636f6e6f6369646120313233223b726567696f6e7c733a343a226c696d61223b706169737c733a343a2270657275223b6e65676f63696f7c733a313a2230223b626574617c733a313a2231223b686162696c6974615f62746e5f7061676f7c733a313a2231223b686162696c6974615f62746e5f63616a617c733a313a2230223b6c6f676f7c733a31363a226c6f676f2d656d70726573612e6a7067223b706f735f6c6f676f7c733a313a2232223b6c6f676f5f7064667c733a31323a226c6f676f2d7064662e706e67223b747970655f696d6167656e5f7064667c733a313a2231223b70726f746f636f6c7c733a343a22736d7470223b736d74705f686f73747c733a31393a226d61696c2e73697374656d617470762e636f6d223b736d74705f757365727c733a32333a226e6f2d7265706c794073697374656d617470762e636f6d223b736d74705f706173737c733a38383a226e727879507977326f635a4f70424d314d4f6b4a416568377648505a773172674f725566494b32526834304e344a44383236507142647977312b317570735030467157452f576271736a6769323868473236326c72513d3d223b736d74705f706f72747c733a333a22353837223b6d61696c706174687c4e3b756269636163696f6e5f584d4c7c733a303a22223b706173735f6669726d617c733a363a22313233343536223b757365725f736f6c7c733a373a22314441544f5331223b706173735f736f6c7c733a363a22314461746f73223b),
('55727672175707a128f33b619e89efa82ffbb4fb', '::1', 1598365013, 0x5f5f63695f6c6173745f726567656e65726174657c693a313539383336343733323b6c6f63616c7c733a313a2231223b6c6973746156656e74617c693a303b6964656e746974797c733a32303a2261646d696e4073697374656d617470762e636f6d223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a32303a2261646d696e4073697374656d617470762e636f6d223b757365725f69647c733a313a2231223b66697273745f6e616d657c733a353a2241646d696e223b6c6173745f6e616d657c733a333a22545056223b637265617465645f6f6e7c733a32323a2232322f30382f323031382031323a32393a313120504d223b6f6c645f6c6173745f6c6f67696e7c733a31303a2231353938333339333733223b6c6173745f69707c733a333a223a3a31223b6176617461727c4e3b67656e6465727c733a343a226d616c65223b67726f75705f69647c733a313a2231223b72617a6f6e5f736f6369616c7c733a32343a22456d70726573612064652050727565626120262064656d6f223b7275637c733a31313a223132333435363738393132223b646972656363696f6e7c733a31393a2261762e20646573636f6e6f6369646120313233223b726567696f6e7c733a343a226c696d61223b706169737c733a343a2270657275223b6e65676f63696f7c733a313a2230223b626574617c733a313a2231223b686162696c6974615f62746e5f7061676f7c733a313a2231223b686162696c6974615f62746e5f63616a617c733a313a2230223b6c6f676f7c733a31363a226c6f676f2d656d70726573612e6a7067223b706f735f6c6f676f7c733a313a2232223b6c6f676f5f7064667c733a31323a226c6f676f2d7064662e706e67223b747970655f696d6167656e5f7064667c733a313a2231223b70726f746f636f6c7c733a343a22736d7470223b736d74705f686f73747c733a31393a226d61696c2e73697374656d617470762e636f6d223b736d74705f757365727c733a32333a226e6f2d7265706c794073697374656d617470762e636f6d223b736d74705f706173737c733a38383a226e727879507977326f635a4f70424d314d4f6b4a416568377648505a773172674f725566494b32526834304e344a44383236507142647977312b317570735030467157452f576271736a6769323868473236326c72513d3d223b736d74705f706f72747c733a333a22353837223b6d61696c706174687c4e3b756269636163696f6e5f584d4c7c733a303a22223b706173735f6669726d617c733a363a22313233343536223b757365725f736f6c7c733a373a22314441544f5331223b706173735f736f6c7c733a363a22314461746f73223b),
('559771ca3fc13298b7dbd79e94800d1e8fdd247f', '::1', 1598644881, 0x5f5f63695f6c6173745f726567656e65726174657c693a313539383634343833343b6c6f63616c7c733a313a2231223b6c6973746156656e74617c693a303b6964656e746974797c733a32303a2261646d696e4073697374656d617470762e636f6d223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a32303a2261646d696e4073697374656d617470762e636f6d223b757365725f69647c733a313a2231223b66697273745f6e616d657c733a353a2241646d696e223b6c6173745f6e616d657c733a333a22545056223b637265617465645f6f6e7c733a32323a2232322f30382f323031382031323a32393a313120504d223b6f6c645f6c6173745f6c6f67696e7c733a31303a2231353938363138363735223b6c6173745f69707c733a333a223a3a31223b6176617461727c4e3b67656e6465727c733a343a226d616c65223b67726f75705f69647c733a313a2231223b72617a6f6e5f736f6369616c7c733a32343a22456d70726573612064652050727565626120262064656d6f223b7275637c733a31313a223132333435363738393132223b646972656363696f6e7c733a31393a2261762e20646573636f6e6f6369646120313233223b726567696f6e7c733a343a226c696d61223b706169737c733a343a2270657275223b6e65676f63696f7c733a313a2230223b626574617c733a313a2230223b686162696c6974615f62746e5f7061676f7c733a313a2231223b686162696c6974615f62746e5f63616a617c733a313a2230223b6c6f676f7c733a31363a226c6f676f2d656d70726573612e6a7067223b706f735f6c6f676f7c733a313a2232223b6c6f676f5f7064667c733a31323a226c6f676f2d7064662e706e67223b747970655f696d6167656e5f7064667c733a313a2231223b70726f746f636f6c7c733a343a22736d7470223b736d74705f686f73747c733a31393a226d61696c2e73697374656d617470762e636f6d223b736d74705f757365727c733a32333a226e6f2d7265706c794073697374656d617470762e636f6d223b736d74705f706173737c733a38383a2245384c74427945665839657a305a506c4145587144565a666e7572394238727176767838636f6f696f7437584272694d432b6d3538413049646b346f454e7343396c7a7a66726d3357314937396431784338364c4c513d3d223b736d74705f706f72747c733a333a22353837223b6d61696c706174687c4e3b756269636163696f6e5f584d4c7c733a303a22223b706173735f6669726d617c733a333a22343434223b757365725f736f6c7c733a333a22313233223b706173735f736f6c7c733a333a22333231223b6d6573736167657c733a33373a22436f6e6669677572616369c3b36e2061637475616c697a61646120636f6e20c3a97869746f223b5f5f63695f766172737c613a313a7b733a373a226d657373616765223b733a333a226f6c64223b7d);
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES
('55ee46418daef14a557ce1dc639bb15ef3d9b13d', '::1', 1598366626, 0x5f5f63695f6c6173745f726567656e65726174657c693a313539383336363631393b6c6f63616c7c733a313a2231223b6c6973746156656e74617c693a303b6964656e746974797c733a32303a2261646d696e4073697374656d617470762e636f6d223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a32303a2261646d696e4073697374656d617470762e636f6d223b757365725f69647c733a313a2231223b66697273745f6e616d657c733a353a2241646d696e223b6c6173745f6e616d657c733a333a22545056223b637265617465645f6f6e7c733a32323a2232322f30382f323031382031323a32393a313120504d223b6f6c645f6c6173745f6c6f67696e7c733a31303a2231353938333339333733223b6c6173745f69707c733a333a223a3a31223b6176617461727c4e3b67656e6465727c733a343a226d616c65223b67726f75705f69647c733a313a2231223b72617a6f6e5f736f6369616c7c733a32343a22456d70726573612064652050727565626120262064656d6f223b7275637c733a31313a223132333435363738393132223b646972656363696f6e7c733a31393a2261762e20646573636f6e6f6369646120313233223b726567696f6e7c733a343a226c696d61223b706169737c733a343a2270657275223b6e65676f63696f7c733a313a2230223b626574617c733a313a2231223b686162696c6974615f62746e5f7061676f7c733a313a2231223b686162696c6974615f62746e5f63616a617c733a313a2230223b6c6f676f7c733a31363a226c6f676f2d656d70726573612e6a7067223b706f735f6c6f676f7c733a313a2232223b6c6f676f5f7064667c733a31323a226c6f676f2d7064662e706e67223b747970655f696d6167656e5f7064667c733a313a2231223b70726f746f636f6c7c733a343a22736d7470223b736d74705f686f73747c733a31393a226d61696c2e73697374656d617470762e636f6d223b736d74705f757365727c733a32333a226e6f2d7265706c794073697374656d617470762e636f6d223b736d74705f706173737c733a38383a226e727879507977326f635a4f70424d314d4f6b4a416568377648505a773172674f725566494b32526834304e344a44383236507142647977312b317570735030467157452f576271736a6769323868473236326c72513d3d223b736d74705f706f72747c733a333a22353837223b6d61696c706174687c4e3b756269636163696f6e5f584d4c7c733a303a22223b706173735f6669726d617c733a363a22313233343536223b757365725f736f6c7c733a373a22314441544f5331223b706173735f736f6c7c733a363a22314461746f73223b),
('5c23a14e1637142f50996bb59b4f2f9cc8486fb1', '::1', 1598618702, 0x5f5f63695f6c6173745f726567656e65726174657c693a313539383631383730323b),
('5d59c322bf43494051d2e9eb9a2bb40757cd1162', '::1', 1598605043, 0x5f5f63695f6c6173745f726567656e65726174657c693a313539383630353034333b6c6f63616c7c733a313a2231223b6c6973746156656e74617c693a303b6964656e746974797c733a32303a2261646d696e4073697374656d617470762e636f6d223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a32303a2261646d696e4073697374656d617470762e636f6d223b757365725f69647c733a313a2231223b66697273745f6e616d657c733a353a2241646d696e223b6c6173745f6e616d657c733a333a22545056223b637265617465645f6f6e7c733a32323a2232322f30382f323031382031323a32393a313120504d223b6f6c645f6c6173745f6c6f67696e7c733a31303a2231353938353735363639223b6c6173745f69707c733a333a223a3a31223b6176617461727c4e3b67656e6465727c733a343a226d616c65223b67726f75705f69647c733a313a2231223b72617a6f6e5f736f6369616c7c733a32343a22456d70726573612064652050727565626120262064656d6f223b7275637c733a31313a223132333435363738393132223b646972656363696f6e7c733a31393a2261762e20646573636f6e6f6369646120313233223b726567696f6e7c733a343a226c696d61223b706169737c733a343a2270657275223b6e65676f63696f7c733a313a2230223b626574617c733a313a2231223b686162696c6974615f62746e5f7061676f7c733a313a2231223b686162696c6974615f62746e5f63616a617c733a313a2230223b6c6f676f7c733a31363a226c6f676f2d656d70726573612e6a7067223b706f735f6c6f676f7c733a313a2232223b6c6f676f5f7064667c733a31323a226c6f676f2d7064662e706e67223b747970655f696d6167656e5f7064667c733a313a2231223b70726f746f636f6c7c733a343a22736d7470223b736d74705f686f73747c733a31393a226d61696c2e73697374656d617470762e636f6d223b736d74705f757365727c733a32333a226e6f2d7265706c794073697374656d617470762e636f6d223b736d74705f706173737c733a38383a226e727879507977326f635a4f70424d314d4f6b4a416568377648505a773172674f725566494b32526834304e344a44383236507142647977312b317570735030467157452f576271736a6769323868473236326c72513d3d223b736d74705f706f72747c733a333a22353837223b6d61696c706174687c4e3b756269636163696f6e5f584d4c7c733a303a22223b706173735f6669726d617c733a363a22313233343536223b757365725f736f6c7c733a373a22314441544f5331223b706173735f736f6c7c733a363a22314461746f73223b),
('5f3ba2f1d4e53116008e6255e7f4092115be813b', '::1', 1598601374, 0x5f5f63695f6c6173745f726567656e65726174657c693a313539383630313230333b6c6f63616c7c733a313a2231223b6c6973746156656e74617c693a303b6964656e746974797c733a32303a2261646d696e4073697374656d617470762e636f6d223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a32303a2261646d696e4073697374656d617470762e636f6d223b757365725f69647c733a313a2231223b66697273745f6e616d657c733a353a2241646d696e223b6c6173745f6e616d657c733a333a22545056223b637265617465645f6f6e7c733a32323a2232322f30382f323031382031323a32393a313120504d223b6f6c645f6c6173745f6c6f67696e7c733a31303a2231353938353735363639223b6c6173745f69707c733a333a223a3a31223b6176617461727c4e3b67656e6465727c733a343a226d616c65223b67726f75705f69647c733a313a2231223b72617a6f6e5f736f6369616c7c733a32343a22456d70726573612064652050727565626120262064656d6f223b7275637c733a31313a223132333435363738393132223b646972656363696f6e7c733a31393a2261762e20646573636f6e6f6369646120313233223b726567696f6e7c733a343a226c696d61223b706169737c733a343a2270657275223b6e65676f63696f7c733a313a2230223b626574617c733a313a2231223b686162696c6974615f62746e5f7061676f7c733a313a2231223b686162696c6974615f62746e5f63616a617c733a313a2230223b6c6f676f7c733a31363a226c6f676f2d656d70726573612e6a7067223b706f735f6c6f676f7c733a313a2232223b6c6f676f5f7064667c733a31323a226c6f676f2d7064662e706e67223b747970655f696d6167656e5f7064667c733a313a2231223b70726f746f636f6c7c733a343a22736d7470223b736d74705f686f73747c733a31393a226d61696c2e73697374656d617470762e636f6d223b736d74705f757365727c733a32333a226e6f2d7265706c794073697374656d617470762e636f6d223b736d74705f706173737c733a38383a226e727879507977326f635a4f70424d314d4f6b4a416568377648505a773172674f725566494b32526834304e344a44383236507142647977312b317570735030467157452f576271736a6769323868473236326c72513d3d223b736d74705f706f72747c733a333a22353837223b6d61696c706174687c4e3b756269636163696f6e5f584d4c7c733a303a22223b706173735f6669726d617c733a363a22313233343536223b757365725f736f6c7c733a373a22314441544f5331223b706173735f736f6c7c733a363a22314461746f73223b6d6573736167657c733a33373a22436f6e6669677572616369c3b36e2061637475616c697a61646120636f6e20c3a97869746f223b5f5f63695f766172737c613a313a7b733a373a226d657373616765223b733a333a226f6c64223b7d),
('5ooilmqtk7fqq789juhpij3c7b', '::1', 1598834004, 0x5f5f63695f6c6173745f726567656e65726174657c693a313539383833343030343b),
('60mua148b216e00vliq470skj9', '::1', 1598834013, 0x5f5f63695f6c6173745f726567656e65726174657c693a313539383833343031323b6c6f63616c7c733a313a2231223b6c6973746156656e74617c693a303b6964656e746974797c733a32303a2261646d696e4073697374656d617470762e636f6d223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a32303a2261646d696e4073697374656d617470762e636f6d223b757365725f69647c733a313a2231223b66697273745f6e616d657c733a353a2241646d696e223b6c6173745f6e616d657c733a333a22545056223b637265617465645f6f6e7c733a32323a2232322f30382f323031382031323a32393a313120504d223b6f6c645f6c6173745f6c6f67696e7c733a31303a2231353938383136363031223b6c6173745f69707c733a333a223a3a31223b6176617461727c4e3b67656e6465727c733a343a226d616c65223b67726f75705f69647c733a313a2231223b72617a6f6e5f736f6369616c7c733a32343a22456d70726573612064652050727565626120262064656d6f223b7275637c733a31313a223132333435363738393132223b646972656363696f6e7c733a31393a2261762e20646573636f6e6f6369646120313233223b726567696f6e7c733a343a226c696d61223b706169737c733a343a2270657275223b6e65676f63696f7c733a313a2230223b626574617c733a313a2230223b686162696c6974615f62746e5f7061676f7c733a313a2231223b686162696c6974615f62746e5f63616a617c733a313a2230223b6c6f676f7c733a31363a226c6f676f2d656d70726573612e6a7067223b706f735f6c6f676f7c733a313a2232223b6c6f676f5f7064667c733a31323a226c6f676f2d7064662e706e67223b747970655f696d6167656e5f7064667c733a313a2231223b70726f746f636f6c7c733a343a22736d7470223b736d74705f686f73747c733a31393a226d61696c2e73697374656d617470762e636f6d223b736d74705f757365727c733a32333a226e6f2d7265706c794073697374656d617470762e636f6d223b736d74705f706173737c733a38383a2246795764306743646e7343317a326f54377137684b48655a757873612b706a5948684542527656415a3041616751693749453776536a75756c4142434530506b4576733356447872355756783131434c35387a4377413d3d223b736d74705f706f72747c733a333a22353837223b6d61696c706174687c4e3b756269636163696f6e5f584d4c7c733a303a22223b706173735f6669726d617c733a333a22343434223b757365725f736f6c7c733a333a22313233223b706173735f736f6c7c733a303a22223b6d6573736167657c733a34353a223c703ec2a14c6f67756561646f20636f6e20c3a97869746f2120536561206269656e76656e69646f213c2f703e223b5f5f63695f766172737c613a313a7b733a373a226d657373616765223b733a333a226e6577223b7d),
('6ca8b551b9c8ed1bf7d59b9fac399baf37c1446d', '::1', 1598609449, 0x5f5f63695f6c6173745f726567656e65726174657c693a313539383630393337383b6c6f63616c7c733a313a2231223b6c6973746156656e74617c693a303b6964656e746974797c733a32303a2261646d696e4073697374656d617470762e636f6d223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a32303a2261646d696e4073697374656d617470762e636f6d223b757365725f69647c733a313a2231223b66697273745f6e616d657c733a353a2241646d696e223b6c6173745f6e616d657c733a333a22545056223b637265617465645f6f6e7c733a32323a2232322f30382f323031382031323a32393a313120504d223b6f6c645f6c6173745f6c6f67696e7c733a31303a2231353938353735363639223b6c6173745f69707c733a333a223a3a31223b6176617461727c4e3b67656e6465727c733a343a226d616c65223b67726f75705f69647c733a313a2231223b72617a6f6e5f736f6369616c7c733a32343a22456d70726573612064652050727565626120262064656d6f223b7275637c733a31313a223132333435363738393132223b646972656363696f6e7c733a31393a2261762e20646573636f6e6f6369646120313233223b726567696f6e7c733a343a226c696d61223b706169737c733a343a2270657275223b6e65676f63696f7c733a313a2230223b626574617c733a313a2231223b686162696c6974615f62746e5f7061676f7c733a313a2231223b686162696c6974615f62746e5f63616a617c733a313a2230223b6c6f676f7c733a31363a226c6f676f2d656d70726573612e6a7067223b706f735f6c6f676f7c733a313a2232223b6c6f676f5f7064667c733a31323a226c6f676f2d7064662e706e67223b747970655f696d6167656e5f7064667c733a313a2231223b70726f746f636f6c7c733a343a22736d7470223b736d74705f686f73747c733a31393a226d61696c2e73697374656d617470762e636f6d223b736d74705f757365727c733a32333a226e6f2d7265706c794073697374656d617470762e636f6d223b736d74705f706173737c733a38383a226e727879507977326f635a4f70424d314d4f6b4a416568377648505a773172674f725566494b32526834304e344a44383236507142647977312b317570735030467157452f576271736a6769323868473236326c72513d3d223b736d74705f706f72747c733a333a22353837223b6d61696c706174687c4e3b756269636163696f6e5f584d4c7c733a303a22223b706173735f6669726d617c733a363a22313233343536223b757365725f736f6c7c733a373a22314441544f5331223b706173735f736f6c7c733a363a22314461746f73223b6d6573736167657c733a33373a22436f6e6669677572616369c3b36e2061637475616c697a61646120636f6e20c3a97869746f223b5f5f63695f766172737c613a313a7b733a373a226d657373616765223b733a333a226f6c64223b7d),
('6ce049658129728ac0a7dbe0f15a7231af94c254', '::1', 1598575847, 0x5f5f63695f6c6173745f726567656e65726174657c693a313539383537353636393b6c6f63616c7c733a313a2231223b6c6973746156656e74617c693a303b6964656e746974797c733a32303a2261646d696e4073697374656d617470762e636f6d223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a32303a2261646d696e4073697374656d617470762e636f6d223b757365725f69647c733a313a2231223b66697273745f6e616d657c733a353a2241646d696e223b6c6173745f6e616d657c733a333a22545056223b637265617465645f6f6e7c733a32323a2232322f30382f323031382031323a32393a313120504d223b6f6c645f6c6173745f6c6f67696e7c733a31303a2231353938353735363332223b6c6173745f69707c733a333a223a3a31223b6176617461727c4e3b67656e6465727c733a343a226d616c65223b67726f75705f69647c733a313a2231223b72617a6f6e5f736f6369616c7c733a32343a22456d70726573612064652050727565626120262064656d6f223b7275637c733a31313a223132333435363738393132223b646972656363696f6e7c733a31393a2261762e20646573636f6e6f6369646120313233223b726567696f6e7c733a343a226c696d61223b706169737c733a343a2270657275223b6e65676f63696f7c733a313a2230223b626574617c733a313a2231223b686162696c6974615f62746e5f7061676f7c733a313a2231223b686162696c6974615f62746e5f63616a617c733a313a2230223b6c6f676f7c733a31363a226c6f676f2d656d70726573612e6a7067223b706f735f6c6f676f7c733a313a2232223b6c6f676f5f7064667c733a31323a226c6f676f2d7064662e706e67223b747970655f696d6167656e5f7064667c733a313a2231223b70726f746f636f6c7c733a343a22736d7470223b736d74705f686f73747c733a31393a226d61696c2e73697374656d617470762e636f6d223b736d74705f757365727c733a32333a226e6f2d7265706c794073697374656d617470762e636f6d223b736d74705f706173737c733a38383a226e727879507977326f635a4f70424d314d4f6b4a416568377648505a773172674f725566494b32526834304e344a44383236507142647977312b317570735030467157452f576271736a6769323868473236326c72513d3d223b736d74705f706f72747c733a333a22353837223b6d61696c706174687c4e3b756269636163696f6e5f584d4c7c733a303a22223b706173735f6669726d617c733a363a22313233343536223b757365725f736f6c7c733a373a22314441544f5331223b706173735f736f6c7c733a363a22314461746f73223b),
('6e07f08b1f10281fcf1963afd2d06946e0a7daef', '::1', 1598582914, 0x5f5f63695f6c6173745f726567656e65726174657c693a313539383538323838333b6c6f63616c7c733a313a2231223b6c6973746156656e74617c693a303b6964656e746974797c733a32303a2261646d696e4073697374656d617470762e636f6d223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a32303a2261646d696e4073697374656d617470762e636f6d223b757365725f69647c733a313a2231223b66697273745f6e616d657c733a353a2241646d696e223b6c6173745f6e616d657c733a333a22545056223b637265617465645f6f6e7c733a32323a2232322f30382f323031382031323a32393a313120504d223b6f6c645f6c6173745f6c6f67696e7c733a31303a2231353938353735363332223b6c6173745f69707c733a333a223a3a31223b6176617461727c4e3b67656e6465727c733a343a226d616c65223b67726f75705f69647c733a313a2231223b72617a6f6e5f736f6369616c7c733a32343a22456d70726573612064652050727565626120262064656d6f223b7275637c733a31313a223132333435363738393132223b646972656363696f6e7c733a31393a2261762e20646573636f6e6f6369646120313233223b726567696f6e7c733a343a226c696d61223b706169737c733a343a2270657275223b6e65676f63696f7c733a313a2230223b626574617c733a313a2231223b686162696c6974615f62746e5f7061676f7c733a313a2231223b686162696c6974615f62746e5f63616a617c733a313a2230223b6c6f676f7c733a31363a226c6f676f2d656d70726573612e6a7067223b706f735f6c6f676f7c733a313a2232223b6c6f676f5f7064667c733a31323a226c6f676f2d7064662e706e67223b747970655f696d6167656e5f7064667c733a313a2231223b70726f746f636f6c7c733a343a22736d7470223b736d74705f686f73747c733a31393a226d61696c2e73697374656d617470762e636f6d223b736d74705f757365727c733a32333a226e6f2d7265706c794073697374656d617470762e636f6d223b736d74705f706173737c733a38383a226e727879507977326f635a4f70424d314d4f6b4a416568377648505a773172674f725566494b32526834304e344a44383236507142647977312b317570735030467157452f576271736a6769323868473236326c72513d3d223b736d74705f706f72747c733a333a22353837223b6d61696c706174687c4e3b756269636163696f6e5f584d4c7c733a303a22223b706173735f6669726d617c733a363a22313233343536223b757365725f736f6c7c733a373a22314441544f5331223b706173735f736f6c7c733a363a22314461746f73223b),
('71df2cf59bd587fc335304eed84fd7055774b2c9', '::1', 1598723899, 0x5f5f63695f6c6173745f726567656e65726174657c693a313539383732333731303b6c6f63616c7c733a313a2231223b6c6973746156656e74617c693a303b6964656e746974797c733a32303a2261646d696e4073697374656d617470762e636f6d223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a32303a2261646d696e4073697374656d617470762e636f6d223b757365725f69647c733a313a2231223b66697273745f6e616d657c733a353a2241646d696e223b6c6173745f6e616d657c733a333a22545056223b637265617465645f6f6e7c733a32323a2232322f30382f323031382031323a32393a313120504d223b6f6c645f6c6173745f6c6f67696e7c733a31303a2231353938363438343436223b6c6173745f69707c733a333a223a3a31223b6176617461727c4e3b67656e6465727c733a343a226d616c65223b67726f75705f69647c733a313a2231223b72617a6f6e5f736f6369616c7c733a32343a22456d70726573612064652050727565626120262064656d6f223b7275637c733a31313a223132333435363738393132223b646972656363696f6e7c733a31393a2261762e20646573636f6e6f6369646120313233223b726567696f6e7c733a343a226c696d61223b706169737c733a343a2270657275223b6e65676f63696f7c733a313a2230223b626574617c733a313a2230223b686162696c6974615f62746e5f7061676f7c733a313a2231223b686162696c6974615f62746e5f63616a617c733a313a2230223b6c6f676f7c733a31363a226c6f676f2d656d70726573612e6a7067223b706f735f6c6f676f7c733a313a2232223b6c6f676f5f7064667c733a31323a226c6f676f2d7064662e706e67223b747970655f696d6167656e5f7064667c733a313a2231223b70726f746f636f6c7c733a343a22736d7470223b736d74705f686f73747c733a31393a226d61696c2e73697374656d617470762e636f6d223b736d74705f757365727c733a32333a226e6f2d7265706c794073697374656d617470762e636f6d223b736d74705f706173737c733a38383a2246795764306743646e7343317a326f54377137684b48655a757873612b706a5948684542527656415a3041616751693749453776536a75756c4142434530506b4576733356447872355756783131434c35387a4377413d3d223b736d74705f706f72747c733a333a22353837223b6d61696c706174687c4e3b756269636163696f6e5f584d4c7c733a303a22223b706173735f6669726d617c733a333a22343434223b757365725f736f6c7c733a333a22313233223b706173735f736f6c7c733a303a22223b),
('7abf09a29f9f57cb0c9782a4a33b200f9209f100', '::1', 1598345217, 0x5f5f63695f6c6173745f726567656e65726174657c693a313539383334353231373b6c6f63616c7c733a313a2231223b6c6973746156656e74617c693a303b6964656e746974797c733a32303a2261646d696e4073697374656d617470762e636f6d223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a32303a2261646d696e4073697374656d617470762e636f6d223b757365725f69647c733a313a2231223b66697273745f6e616d657c733a353a2241646d696e223b6c6173745f6e616d657c733a333a22545056223b637265617465645f6f6e7c733a32323a2232322f30382f323031382031323a32393a313120504d223b6f6c645f6c6173745f6c6f67696e7c733a31303a2231353938333231313834223b6c6173745f69707c733a333a223a3a31223b6176617461727c4e3b67656e6465727c733a343a226d616c65223b67726f75705f69647c733a313a2231223b72617a6f6e5f736f6369616c7c733a32343a22456d70726573612064652050727565626120262064656d6f223b7275637c733a31313a223132333435363738393132223b646972656363696f6e7c733a31393a2261762e20646573636f6e6f6369646120313233223b726567696f6e7c733a343a226c696d61223b706169737c733a343a2270657275223b6e65676f63696f7c733a313a2230223b626574617c733a313a2231223b686162696c6974615f62746e5f7061676f7c733a313a2231223b686162696c6974615f62746e5f63616a617c733a313a2230223b6c6f676f7c733a31363a226c6f676f2d656d70726573612e6a7067223b706f735f6c6f676f7c733a313a2232223b6c6f676f5f7064667c733a31323a226c6f676f2d7064662e706e67223b747970655f696d6167656e5f7064667c733a313a2231223b70726f746f636f6c7c733a343a22736d7470223b736d74705f686f73747c733a31393a226d61696c2e73697374656d617470762e636f6d223b736d74705f757365727c733a32333a226e6f2d7265706c794073697374656d617470762e636f6d223b736d74705f706173737c733a38383a226e727879507977326f635a4f70424d314d4f6b4a416568377648505a773172674f725566494b32526834304e344a44383236507142647977312b317570735030467157452f576271736a6769323868473236326c72513d3d223b736d74705f706f72747c733a333a22353837223b6d61696c706174687c4e3b756269636163696f6e5f584d4c7c733a303a22223b706173735f6669726d617c733a363a22313233343536223b757365725f736f6c7c733a373a22314441544f5331223b706173735f736f6c7c733a363a22314461746f73223b),
('7c0ec6df50857a31106519d44dd03aeb45f894e0', '::1', 1598606892, 0x5f5f63695f6c6173745f726567656e65726174657c693a313539383630363736313b6c6f63616c7c733a313a2231223b6c6973746156656e74617c693a303b6964656e746974797c733a32303a2261646d696e4073697374656d617470762e636f6d223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a32303a2261646d696e4073697374656d617470762e636f6d223b757365725f69647c733a313a2231223b66697273745f6e616d657c733a353a2241646d696e223b6c6173745f6e616d657c733a333a22545056223b637265617465645f6f6e7c733a32323a2232322f30382f323031382031323a32393a313120504d223b6f6c645f6c6173745f6c6f67696e7c733a31303a2231353938353735363639223b6c6173745f69707c733a333a223a3a31223b6176617461727c4e3b67656e6465727c733a343a226d616c65223b67726f75705f69647c733a313a2231223b72617a6f6e5f736f6369616c7c733a32343a22456d70726573612064652050727565626120262064656d6f223b7275637c733a31313a223132333435363738393132223b646972656363696f6e7c733a31393a2261762e20646573636f6e6f6369646120313233223b726567696f6e7c733a343a226c696d61223b706169737c733a343a2270657275223b6e65676f63696f7c733a313a2230223b626574617c733a313a2231223b686162696c6974615f62746e5f7061676f7c733a313a2231223b686162696c6974615f62746e5f63616a617c733a313a2230223b6c6f676f7c733a31363a226c6f676f2d656d70726573612e6a7067223b706f735f6c6f676f7c733a313a2232223b6c6f676f5f7064667c733a31323a226c6f676f2d7064662e706e67223b747970655f696d6167656e5f7064667c733a313a2231223b70726f746f636f6c7c733a343a22736d7470223b736d74705f686f73747c733a31393a226d61696c2e73697374656d617470762e636f6d223b736d74705f757365727c733a32333a226e6f2d7265706c794073697374656d617470762e636f6d223b736d74705f706173737c733a38383a226e727879507977326f635a4f70424d314d4f6b4a416568377648505a773172674f725566494b32526834304e344a44383236507142647977312b317570735030467157452f576271736a6769323868473236326c72513d3d223b736d74705f706f72747c733a333a22353837223b6d61696c706174687c4e3b756269636163696f6e5f584d4c7c733a303a22223b706173735f6669726d617c733a363a22313233343536223b757365725f736f6c7c733a373a22314441544f5331223b706173735f736f6c7c733a363a22314461746f73223b),
('7cbe205ec25a713903b0fcdda24a32008d82305e', '::1', 1598584507, 0x5f5f63695f6c6173745f726567656e65726174657c693a313539383538343333333b6c6f63616c7c733a313a2231223b6c6973746156656e74617c693a303b6964656e746974797c733a32303a2261646d696e4073697374656d617470762e636f6d223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a32303a2261646d696e4073697374656d617470762e636f6d223b757365725f69647c733a313a2231223b66697273745f6e616d657c733a353a2241646d696e223b6c6173745f6e616d657c733a333a22545056223b637265617465645f6f6e7c733a32323a2232322f30382f323031382031323a32393a313120504d223b6f6c645f6c6173745f6c6f67696e7c733a31303a2231353938353735363332223b6c6173745f69707c733a333a223a3a31223b6176617461727c4e3b67656e6465727c733a343a226d616c65223b67726f75705f69647c733a313a2231223b72617a6f6e5f736f6369616c7c733a32343a22456d70726573612064652050727565626120262064656d6f223b7275637c733a31313a223132333435363738393132223b646972656363696f6e7c733a31393a2261762e20646573636f6e6f6369646120313233223b726567696f6e7c733a343a226c696d61223b706169737c733a343a2270657275223b6e65676f63696f7c733a313a2230223b626574617c733a313a2231223b686162696c6974615f62746e5f7061676f7c733a313a2231223b686162696c6974615f62746e5f63616a617c733a313a2230223b6c6f676f7c733a31363a226c6f676f2d656d70726573612e6a7067223b706f735f6c6f676f7c733a313a2232223b6c6f676f5f7064667c733a31323a226c6f676f2d7064662e706e67223b747970655f696d6167656e5f7064667c733a313a2231223b70726f746f636f6c7c733a343a22736d7470223b736d74705f686f73747c733a31393a226d61696c2e73697374656d617470762e636f6d223b736d74705f757365727c733a32333a226e6f2d7265706c794073697374656d617470762e636f6d223b736d74705f706173737c733a38383a226e727879507977326f635a4f70424d314d4f6b4a416568377648505a773172674f725566494b32526834304e344a44383236507142647977312b317570735030467157452f576271736a6769323868473236326c72513d3d223b736d74705f706f72747c733a333a22353837223b6d61696c706174687c4e3b756269636163696f6e5f584d4c7c733a303a22223b706173735f6669726d617c733a363a22313233343536223b757365725f736f6c7c733a373a22314441544f5331223b706173735f736f6c7c733a363a22314461746f73223b),
('7eec0566e1f7029fb33b818340957eaecfb0ad3a', '::1', 1598560818, 0x5f5f63695f6c6173745f726567656e65726174657c693a313539383536303739383b6c6f63616c7c733a313a2231223b6c6973746156656e74617c693a303b6964656e746974797c733a32303a2261646d696e4073697374656d617470762e636f6d223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a32303a2261646d696e4073697374656d617470762e636f6d223b757365725f69647c733a313a2231223b66697273745f6e616d657c733a353a2241646d696e223b6c6173745f6e616d657c733a333a22545056223b637265617465645f6f6e7c733a32323a2232322f30382f323031382031323a32393a313120504d223b6f6c645f6c6173745f6c6f67696e7c733a31303a2231353938333632383536223b6c6173745f69707c733a333a223a3a31223b6176617461727c4e3b67656e6465727c733a343a226d616c65223b67726f75705f69647c733a313a2231223b72617a6f6e5f736f6369616c7c733a32343a22456d70726573612064652050727565626120262064656d6f223b7275637c733a31313a223132333435363738393132223b646972656363696f6e7c733a31393a2261762e20646573636f6e6f6369646120313233223b726567696f6e7c733a343a226c696d61223b706169737c733a343a2270657275223b6e65676f63696f7c733a313a2230223b626574617c733a313a2231223b686162696c6974615f62746e5f7061676f7c733a313a2231223b686162696c6974615f62746e5f63616a617c733a313a2230223b6c6f676f7c733a31363a226c6f676f2d656d70726573612e6a7067223b706f735f6c6f676f7c733a313a2232223b6c6f676f5f7064667c733a31323a226c6f676f2d7064662e706e67223b747970655f696d6167656e5f7064667c733a313a2231223b70726f746f636f6c7c733a343a22736d7470223b736d74705f686f73747c733a31393a226d61696c2e73697374656d617470762e636f6d223b736d74705f757365727c733a32333a226e6f2d7265706c794073697374656d617470762e636f6d223b736d74705f706173737c733a38383a226e727879507977326f635a4f70424d314d4f6b4a416568377648505a773172674f725566494b32526834304e344a44383236507142647977312b317570735030467157452f576271736a6769323868473236326c72513d3d223b736d74705f706f72747c733a333a22353837223b6d61696c706174687c4e3b756269636163696f6e5f584d4c7c733a303a22223b706173735f6669726d617c733a363a22313233343536223b757365725f736f6c7c733a373a22314441544f5331223b706173735f736f6c7c733a363a22314461746f73223b),
('8748046399fcee358fd02d786c58700902e2bcef', '::1', 1598816387, 0x5f5f63695f6c6173745f726567656e65726174657c693a313539383831363132353b6c6f63616c7c733a313a2231223b6c6973746156656e74617c693a303b6964656e746974797c733a32303a2261646d696e4073697374656d617470762e636f6d223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a32303a2261646d696e4073697374656d617470762e636f6d223b757365725f69647c733a313a2231223b66697273745f6e616d657c733a353a2241646d696e223b6c6173745f6e616d657c733a333a22545056223b637265617465645f6f6e7c733a32323a2232322f30382f323031382031323a32393a313120504d223b6f6c645f6c6173745f6c6f67696e7c733a31303a2231353938373635363130223b6c6173745f69707c733a333a223a3a31223b6176617461727c4e3b67656e6465727c733a343a226d616c65223b67726f75705f69647c733a313a2231223b72617a6f6e5f736f6369616c7c733a32343a22456d70726573612064652050727565626120262064656d6f223b7275637c733a31313a223132333435363738393132223b646972656363696f6e7c733a31393a2261762e20646573636f6e6f6369646120313233223b726567696f6e7c733a343a226c696d61223b706169737c733a343a2270657275223b6e65676f63696f7c733a313a2230223b626574617c733a313a2230223b686162696c6974615f62746e5f7061676f7c733a313a2231223b686162696c6974615f62746e5f63616a617c733a313a2230223b6c6f676f7c733a31363a226c6f676f2d656d70726573612e6a7067223b706f735f6c6f676f7c733a313a2232223b6c6f676f5f7064667c733a31323a226c6f676f2d7064662e706e67223b747970655f696d6167656e5f7064667c733a313a2231223b70726f746f636f6c7c733a343a22736d7470223b736d74705f686f73747c733a31393a226d61696c2e73697374656d617470762e636f6d223b736d74705f757365727c733a32333a226e6f2d7265706c794073697374656d617470762e636f6d223b736d74705f706173737c733a38383a2246795764306743646e7343317a326f54377137684b48655a757873612b706a5948684542527656415a3041616751693749453776536a75756c4142434530506b4576733356447872355756783131434c35387a4377413d3d223b736d74705f706f72747c733a333a22353837223b6d61696c706174687c4e3b756269636163696f6e5f584d4c7c733a303a22223b706173735f6669726d617c733a333a22343434223b757365725f736f6c7c733a333a22313233223b706173735f736f6c7c733a303a22223b),
('87732178bf23ced9270b00f49a4b0369f3682d6c', '::1', 1598607815, 0x5f5f63695f6c6173745f726567656e65726174657c693a313539383630373831353b6c6f63616c7c733a313a2231223b6c6973746156656e74617c693a303b6964656e746974797c733a32303a2261646d696e4073697374656d617470762e636f6d223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a32303a2261646d696e4073697374656d617470762e636f6d223b757365725f69647c733a313a2231223b66697273745f6e616d657c733a353a2241646d696e223b6c6173745f6e616d657c733a333a22545056223b637265617465645f6f6e7c733a32323a2232322f30382f323031382031323a32393a313120504d223b6f6c645f6c6173745f6c6f67696e7c733a31303a2231353938353735363639223b6c6173745f69707c733a333a223a3a31223b6176617461727c4e3b67656e6465727c733a343a226d616c65223b67726f75705f69647c733a313a2231223b72617a6f6e5f736f6369616c7c733a32343a22456d70726573612064652050727565626120262064656d6f223b7275637c733a31313a223132333435363738393132223b646972656363696f6e7c733a31393a2261762e20646573636f6e6f6369646120313233223b726567696f6e7c733a343a226c696d61223b706169737c733a343a2270657275223b6e65676f63696f7c733a313a2230223b626574617c733a313a2231223b686162696c6974615f62746e5f7061676f7c733a313a2231223b686162696c6974615f62746e5f63616a617c733a313a2230223b6c6f676f7c733a31363a226c6f676f2d656d70726573612e6a7067223b706f735f6c6f676f7c733a313a2232223b6c6f676f5f7064667c733a31323a226c6f676f2d7064662e706e67223b747970655f696d6167656e5f7064667c733a313a2231223b70726f746f636f6c7c733a343a22736d7470223b736d74705f686f73747c733a31393a226d61696c2e73697374656d617470762e636f6d223b736d74705f757365727c733a32333a226e6f2d7265706c794073697374656d617470762e636f6d223b736d74705f706173737c733a38383a226e727879507977326f635a4f70424d314d4f6b4a416568377648505a773172674f725566494b32526834304e344a44383236507142647977312b317570735030467157452f576271736a6769323868473236326c72513d3d223b736d74705f706f72747c733a333a22353837223b6d61696c706174687c4e3b756269636163696f6e5f584d4c7c733a303a22223b706173735f6669726d617c733a363a22313233343536223b757365725f736f6c7c733a373a22314441544f5331223b706173735f736f6c7c733a363a22314461746f73223b),
('88b463e3bd03f93fbe2b1ba368c7caf1faf42b30', '::1', 1598576697, 0x5f5f63695f6c6173745f726567656e65726174657c693a313539383537363639373b6c6f63616c7c733a313a2231223b6c6973746156656e74617c693a303b6964656e746974797c733a32303a2261646d696e4073697374656d617470762e636f6d223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a32303a2261646d696e4073697374656d617470762e636f6d223b757365725f69647c733a313a2231223b66697273745f6e616d657c733a353a2241646d696e223b6c6173745f6e616d657c733a333a22545056223b637265617465645f6f6e7c733a32323a2232322f30382f323031382031323a32393a313120504d223b6f6c645f6c6173745f6c6f67696e7c733a31303a2231353938353735363332223b6c6173745f69707c733a333a223a3a31223b6176617461727c4e3b67656e6465727c733a343a226d616c65223b67726f75705f69647c733a313a2231223b72617a6f6e5f736f6369616c7c733a32343a22456d70726573612064652050727565626120262064656d6f223b7275637c733a31313a223132333435363738393132223b646972656363696f6e7c733a31393a2261762e20646573636f6e6f6369646120313233223b726567696f6e7c733a343a226c696d61223b706169737c733a343a2270657275223b6e65676f63696f7c733a313a2230223b626574617c733a313a2231223b686162696c6974615f62746e5f7061676f7c733a313a2231223b686162696c6974615f62746e5f63616a617c733a313a2230223b6c6f676f7c733a31363a226c6f676f2d656d70726573612e6a7067223b706f735f6c6f676f7c733a313a2232223b6c6f676f5f7064667c733a31323a226c6f676f2d7064662e706e67223b747970655f696d6167656e5f7064667c733a313a2231223b70726f746f636f6c7c733a343a22736d7470223b736d74705f686f73747c733a31393a226d61696c2e73697374656d617470762e636f6d223b736d74705f757365727c733a32333a226e6f2d7265706c794073697374656d617470762e636f6d223b736d74705f706173737c733a38383a226e727879507977326f635a4f70424d314d4f6b4a416568377648505a773172674f725566494b32526834304e344a44383236507142647977312b317570735030467157452f576271736a6769323868473236326c72513d3d223b736d74705f706f72747c733a333a22353837223b6d61696c706174687c4e3b756269636163696f6e5f584d4c7c733a303a22223b706173735f6669726d617c733a363a22313233343536223b757365725f736f6c7c733a373a22314441544f5331223b706173735f736f6c7c733a363a22314461746f73223b),
('8929c843b5996b7449011c1ae736bfef54d304c3', '::1', 1598576621, 0x5f5f63695f6c6173745f726567656e65726174657c693a313539383537363337303b6c6f63616c7c733a313a2231223b6c6973746156656e74617c693a303b6964656e746974797c733a32303a2261646d696e4073697374656d617470762e636f6d223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a32303a2261646d696e4073697374656d617470762e636f6d223b757365725f69647c733a313a2231223b66697273745f6e616d657c733a353a2241646d696e223b6c6173745f6e616d657c733a333a22545056223b637265617465645f6f6e7c733a32323a2232322f30382f323031382031323a32393a313120504d223b6f6c645f6c6173745f6c6f67696e7c733a31303a2231353938353735363332223b6c6173745f69707c733a333a223a3a31223b6176617461727c4e3b67656e6465727c733a343a226d616c65223b67726f75705f69647c733a313a2231223b72617a6f6e5f736f6369616c7c733a32343a22456d70726573612064652050727565626120262064656d6f223b7275637c733a31313a223132333435363738393132223b646972656363696f6e7c733a31393a2261762e20646573636f6e6f6369646120313233223b726567696f6e7c733a343a226c696d61223b706169737c733a343a2270657275223b6e65676f63696f7c733a313a2230223b626574617c733a313a2231223b686162696c6974615f62746e5f7061676f7c733a313a2231223b686162696c6974615f62746e5f63616a617c733a313a2230223b6c6f676f7c733a31363a226c6f676f2d656d70726573612e6a7067223b706f735f6c6f676f7c733a313a2232223b6c6f676f5f7064667c733a31323a226c6f676f2d7064662e706e67223b747970655f696d6167656e5f7064667c733a313a2231223b70726f746f636f6c7c733a343a22736d7470223b736d74705f686f73747c733a31393a226d61696c2e73697374656d617470762e636f6d223b736d74705f757365727c733a32333a226e6f2d7265706c794073697374656d617470762e636f6d223b736d74705f706173737c733a38383a226e727879507977326f635a4f70424d314d4f6b4a416568377648505a773172674f725566494b32526834304e344a44383236507142647977312b317570735030467157452f576271736a6769323868473236326c72513d3d223b736d74705f706f72747c733a333a22353837223b6d61696c706174687c4e3b756269636163696f6e5f584d4c7c733a303a22223b706173735f6669726d617c733a363a22313233343536223b757365725f736f6c7c733a373a22314441544f5331223b706173735f736f6c7c733a363a22314461746f73223b),
('8e1da7f427fd46a8cbf4a986a3d89dcff0c65763', '::1', 1598557570, 0x5f5f63695f6c6173745f726567656e65726174657c693a313539383535373536393b6c6f63616c7c733a313a2231223b6c6973746156656e74617c693a303b6964656e746974797c733a32303a2261646d696e4073697374656d617470762e636f6d223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a32303a2261646d696e4073697374656d617470762e636f6d223b757365725f69647c733a313a2231223b66697273745f6e616d657c733a353a2241646d696e223b6c6173745f6e616d657c733a333a22545056223b637265617465645f6f6e7c733a32323a2232322f30382f323031382031323a32393a313120504d223b6f6c645f6c6173745f6c6f67696e7c733a31303a2231353938333632383536223b6c6173745f69707c733a333a223a3a31223b6176617461727c4e3b67656e6465727c733a343a226d616c65223b67726f75705f69647c733a313a2231223b72617a6f6e5f736f6369616c7c733a32343a22456d70726573612064652050727565626120262064656d6f223b7275637c733a31313a223132333435363738393132223b646972656363696f6e7c733a31393a2261762e20646573636f6e6f6369646120313233223b726567696f6e7c733a343a226c696d61223b706169737c733a343a2270657275223b6e65676f63696f7c733a313a2230223b626574617c733a313a2231223b686162696c6974615f62746e5f7061676f7c733a313a2231223b686162696c6974615f62746e5f63616a617c733a313a2230223b6c6f676f7c733a31363a226c6f676f2d656d70726573612e6a7067223b706f735f6c6f676f7c733a313a2232223b6c6f676f5f7064667c733a31323a226c6f676f2d7064662e706e67223b747970655f696d6167656e5f7064667c733a313a2231223b70726f746f636f6c7c733a343a22736d7470223b736d74705f686f73747c733a31393a226d61696c2e73697374656d617470762e636f6d223b736d74705f757365727c733a32333a226e6f2d7265706c794073697374656d617470762e636f6d223b736d74705f706173737c733a38383a226e727879507977326f635a4f70424d314d4f6b4a416568377648505a773172674f725566494b32526834304e344a44383236507142647977312b317570735030467157452f576271736a6769323868473236326c72513d3d223b736d74705f706f72747c733a333a22353837223b6d61696c706174687c4e3b756269636163696f6e5f584d4c7c733a303a22223b706173735f6669726d617c733a363a22313233343536223b757365725f736f6c7c733a373a22314441544f5331223b706173735f736f6c7c733a363a22314461746f73223b),
('8edb88a19b221d1bf4942007abfcf9c76e910c1e', '::1', 1598582608, 0x5f5f63695f6c6173745f726567656e65726174657c693a313539383538323338323b6c6f63616c7c733a313a2231223b6c6973746156656e74617c693a303b6964656e746974797c733a32303a2261646d696e4073697374656d617470762e636f6d223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a32303a2261646d696e4073697374656d617470762e636f6d223b757365725f69647c733a313a2231223b66697273745f6e616d657c733a353a2241646d696e223b6c6173745f6e616d657c733a333a22545056223b637265617465645f6f6e7c733a32323a2232322f30382f323031382031323a32393a313120504d223b6f6c645f6c6173745f6c6f67696e7c733a31303a2231353938353735363332223b6c6173745f69707c733a333a223a3a31223b6176617461727c4e3b67656e6465727c733a343a226d616c65223b67726f75705f69647c733a313a2231223b72617a6f6e5f736f6369616c7c733a32343a22456d70726573612064652050727565626120262064656d6f223b7275637c733a31313a223132333435363738393132223b646972656363696f6e7c733a31393a2261762e20646573636f6e6f6369646120313233223b726567696f6e7c733a343a226c696d61223b706169737c733a343a2270657275223b6e65676f63696f7c733a313a2230223b626574617c733a313a2231223b686162696c6974615f62746e5f7061676f7c733a313a2231223b686162696c6974615f62746e5f63616a617c733a313a2230223b6c6f676f7c733a31363a226c6f676f2d656d70726573612e6a7067223b706f735f6c6f676f7c733a313a2232223b6c6f676f5f7064667c733a31323a226c6f676f2d7064662e706e67223b747970655f696d6167656e5f7064667c733a313a2231223b70726f746f636f6c7c733a343a22736d7470223b736d74705f686f73747c733a31393a226d61696c2e73697374656d617470762e636f6d223b736d74705f757365727c733a32333a226e6f2d7265706c794073697374656d617470762e636f6d223b736d74705f706173737c733a38383a226e727879507977326f635a4f70424d314d4f6b4a416568377648505a773172674f725566494b32526834304e344a44383236507142647977312b317570735030467157452f576271736a6769323868473236326c72513d3d223b736d74705f706f72747c733a333a22353837223b6d61696c706174687c4e3b756269636163696f6e5f584d4c7c733a303a22223b706173735f6669726d617c733a363a22313233343536223b757365725f736f6c7c733a373a22314441544f5331223b706173735f736f6c7c733a363a22314461746f73223b),
('8fd5866f166a81c2d24510a07f9e2a850ee5e7be', '::1', 1598825017, 0x5f5f63695f6c6173745f726567656e65726174657c693a313539383832353030393b6c6f63616c7c733a313a2231223b6c6973746156656e74617c693a303b6964656e746974797c733a32303a2261646d696e4073697374656d617470762e636f6d223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a32303a2261646d696e4073697374656d617470762e636f6d223b757365725f69647c733a313a2231223b66697273745f6e616d657c733a353a2241646d696e223b6c6173745f6e616d657c733a333a22545056223b637265617465645f6f6e7c733a32323a2232322f30382f323031382031323a32393a313120504d223b6f6c645f6c6173745f6c6f67696e7c733a31303a2231353938383136313334223b6c6173745f69707c733a333a223a3a31223b6176617461727c4e3b67656e6465727c733a343a226d616c65223b67726f75705f69647c733a313a2231223b72617a6f6e5f736f6369616c7c733a32343a22456d70726573612064652050727565626120262064656d6f223b7275637c733a31313a223132333435363738393132223b646972656363696f6e7c733a31393a2261762e20646573636f6e6f6369646120313233223b726567696f6e7c733a343a226c696d61223b706169737c733a343a2270657275223b6e65676f63696f7c733a313a2230223b626574617c733a313a2230223b686162696c6974615f62746e5f7061676f7c733a313a2231223b686162696c6974615f62746e5f63616a617c733a313a2230223b6c6f676f7c733a31363a226c6f676f2d656d70726573612e6a7067223b706f735f6c6f676f7c733a313a2232223b6c6f676f5f7064667c733a31323a226c6f676f2d7064662e706e67223b747970655f696d6167656e5f7064667c733a313a2231223b70726f746f636f6c7c733a343a22736d7470223b736d74705f686f73747c733a31393a226d61696c2e73697374656d617470762e636f6d223b736d74705f757365727c733a32333a226e6f2d7265706c794073697374656d617470762e636f6d223b736d74705f706173737c733a38383a2246795764306743646e7343317a326f54377137684b48655a757873612b706a5948684542527656415a3041616751693749453776536a75756c4142434530506b4576733356447872355756783131434c35387a4377413d3d223b736d74705f706f72747c733a333a22353837223b6d61696c706174687c4e3b756269636163696f6e5f584d4c7c733a303a22223b706173735f6669726d617c733a333a22343434223b757365725f736f6c7c733a333a22313233223b706173735f736f6c7c733a303a22223b),
('93e98ba9498bbb87a034fa4ef30d466db6e5808a', '::1', 1598564124, 0x5f5f63695f6c6173745f726567656e65726174657c693a313539383536343039343b6c6f63616c7c733a313a2231223b6c6973746156656e74617c693a303b6964656e746974797c733a32303a2261646d696e4073697374656d617470762e636f6d223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a32303a2261646d696e4073697374656d617470762e636f6d223b757365725f69647c733a313a2231223b66697273745f6e616d657c733a353a2241646d696e223b6c6173745f6e616d657c733a333a22545056223b637265617465645f6f6e7c733a32323a2232322f30382f323031382031323a32393a313120504d223b6f6c645f6c6173745f6c6f67696e7c733a31303a2231353938333632383536223b6c6173745f69707c733a333a223a3a31223b6176617461727c4e3b67656e6465727c733a343a226d616c65223b67726f75705f69647c733a313a2231223b72617a6f6e5f736f6369616c7c733a32343a22456d70726573612064652050727565626120262064656d6f223b7275637c733a31313a223132333435363738393132223b646972656363696f6e7c733a31393a2261762e20646573636f6e6f6369646120313233223b726567696f6e7c733a343a226c696d61223b706169737c733a343a2270657275223b6e65676f63696f7c733a313a2230223b626574617c733a313a2231223b686162696c6974615f62746e5f7061676f7c733a313a2231223b686162696c6974615f62746e5f63616a617c733a313a2230223b6c6f676f7c733a31363a226c6f676f2d656d70726573612e6a7067223b706f735f6c6f676f7c733a313a2232223b6c6f676f5f7064667c733a31323a226c6f676f2d7064662e706e67223b747970655f696d6167656e5f7064667c733a313a2231223b70726f746f636f6c7c733a343a22736d7470223b736d74705f686f73747c733a31393a226d61696c2e73697374656d617470762e636f6d223b736d74705f757365727c733a32333a226e6f2d7265706c794073697374656d617470762e636f6d223b736d74705f706173737c733a38383a226e727879507977326f635a4f70424d314d4f6b4a416568377648505a773172674f725566494b32526834304e344a44383236507142647977312b317570735030467157452f576271736a6769323868473236326c72513d3d223b736d74705f706f72747c733a333a22353837223b6d61696c706174687c4e3b756269636163696f6e5f584d4c7c733a303a22223b706173735f6669726d617c733a363a22313233343536223b757365725f736f6c7c733a373a22314441544f5331223b706173735f736f6c7c733a363a22314461746f73223b),
('9a5148f35a84730b3cbf48f8bf414bc13d4a0bc5', '::1', 1598579326, 0x5f5f63695f6c6173745f726567656e65726174657c693a313539383537393332363b6c6f63616c7c733a313a2231223b6c6973746156656e74617c693a303b6964656e746974797c733a32303a2261646d696e4073697374656d617470762e636f6d223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a32303a2261646d696e4073697374656d617470762e636f6d223b757365725f69647c733a313a2231223b66697273745f6e616d657c733a353a2241646d696e223b6c6173745f6e616d657c733a333a22545056223b637265617465645f6f6e7c733a32323a2232322f30382f323031382031323a32393a313120504d223b6f6c645f6c6173745f6c6f67696e7c733a31303a2231353938353735363332223b6c6173745f69707c733a333a223a3a31223b6176617461727c4e3b67656e6465727c733a343a226d616c65223b67726f75705f69647c733a313a2231223b72617a6f6e5f736f6369616c7c733a32343a22456d70726573612064652050727565626120262064656d6f223b7275637c733a31313a223132333435363738393132223b646972656363696f6e7c733a31393a2261762e20646573636f6e6f6369646120313233223b726567696f6e7c733a343a226c696d61223b706169737c733a343a2270657275223b6e65676f63696f7c733a313a2230223b626574617c733a313a2231223b686162696c6974615f62746e5f7061676f7c733a313a2231223b686162696c6974615f62746e5f63616a617c733a313a2230223b6c6f676f7c733a31363a226c6f676f2d656d70726573612e6a7067223b706f735f6c6f676f7c733a313a2232223b6c6f676f5f7064667c733a31323a226c6f676f2d7064662e706e67223b747970655f696d6167656e5f7064667c733a313a2231223b70726f746f636f6c7c733a343a22736d7470223b736d74705f686f73747c733a31393a226d61696c2e73697374656d617470762e636f6d223b736d74705f757365727c733a32333a226e6f2d7265706c794073697374656d617470762e636f6d223b736d74705f706173737c733a38383a226e727879507977326f635a4f70424d314d4f6b4a416568377648505a773172674f725566494b32526834304e344a44383236507142647977312b317570735030467157452f576271736a6769323868473236326c72513d3d223b736d74705f706f72747c733a333a22353837223b6d61696c706174687c4e3b756269636163696f6e5f584d4c7c733a303a22223b706173735f6669726d617c733a363a22313233343536223b757365725f736f6c7c733a373a22314441544f5331223b706173735f736f6c7c733a363a22314461746f73223b),
('a609fa51e2ab2defeb209999f890db924950fe6e', '::1', 1598364637, 0x5f5f63695f6c6173745f726567656e65726174657c693a313539383336343430383b6c6f63616c7c733a313a2231223b6c6973746156656e74617c693a303b6964656e746974797c733a32303a2261646d696e4073697374656d617470762e636f6d223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a32303a2261646d696e4073697374656d617470762e636f6d223b757365725f69647c733a313a2231223b66697273745f6e616d657c733a353a2241646d696e223b6c6173745f6e616d657c733a333a22545056223b637265617465645f6f6e7c733a32323a2232322f30382f323031382031323a32393a313120504d223b6f6c645f6c6173745f6c6f67696e7c733a31303a2231353938333339333733223b6c6173745f69707c733a333a223a3a31223b6176617461727c4e3b67656e6465727c733a343a226d616c65223b67726f75705f69647c733a313a2231223b72617a6f6e5f736f6369616c7c733a32343a22456d70726573612064652050727565626120262064656d6f223b7275637c733a31313a223132333435363738393132223b646972656363696f6e7c733a31393a2261762e20646573636f6e6f6369646120313233223b726567696f6e7c733a343a226c696d61223b706169737c733a343a2270657275223b6e65676f63696f7c733a313a2230223b626574617c733a313a2231223b686162696c6974615f62746e5f7061676f7c733a313a2231223b686162696c6974615f62746e5f63616a617c733a313a2230223b6c6f676f7c733a31363a226c6f676f2d656d70726573612e6a7067223b706f735f6c6f676f7c733a313a2232223b6c6f676f5f7064667c733a31323a226c6f676f2d7064662e706e67223b747970655f696d6167656e5f7064667c733a313a2231223b70726f746f636f6c7c733a343a22736d7470223b736d74705f686f73747c733a31393a226d61696c2e73697374656d617470762e636f6d223b736d74705f757365727c733a32333a226e6f2d7265706c794073697374656d617470762e636f6d223b736d74705f706173737c733a38383a226e727879507977326f635a4f70424d314d4f6b4a416568377648505a773172674f725566494b32526834304e344a44383236507142647977312b317570735030467157452f576271736a6769323868473236326c72513d3d223b736d74705f706f72747c733a333a22353837223b6d61696c706174687c4e3b756269636163696f6e5f584d4c7c733a303a22223b706173735f6669726d617c733a363a22313233343536223b757365725f736f6c7c733a373a22314441544f5331223b706173735f736f6c7c733a363a22314461746f73223b),
('aa24fbff6e9dceeafe9a27a940c9ab53fa349cd5', '::1', 1598582171, 0x5f5f63695f6c6173745f726567656e65726174657c693a313539383538323034303b6c6f63616c7c733a313a2231223b6c6973746156656e74617c693a303b6964656e746974797c733a32303a2261646d696e4073697374656d617470762e636f6d223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a32303a2261646d696e4073697374656d617470762e636f6d223b757365725f69647c733a313a2231223b66697273745f6e616d657c733a353a2241646d696e223b6c6173745f6e616d657c733a333a22545056223b637265617465645f6f6e7c733a32323a2232322f30382f323031382031323a32393a313120504d223b6f6c645f6c6173745f6c6f67696e7c733a31303a2231353938353735363332223b6c6173745f69707c733a333a223a3a31223b6176617461727c4e3b67656e6465727c733a343a226d616c65223b67726f75705f69647c733a313a2231223b72617a6f6e5f736f6369616c7c733a32343a22456d70726573612064652050727565626120262064656d6f223b7275637c733a31313a223132333435363738393132223b646972656363696f6e7c733a31393a2261762e20646573636f6e6f6369646120313233223b726567696f6e7c733a343a226c696d61223b706169737c733a343a2270657275223b6e65676f63696f7c733a313a2230223b626574617c733a313a2231223b686162696c6974615f62746e5f7061676f7c733a313a2231223b686162696c6974615f62746e5f63616a617c733a313a2230223b6c6f676f7c733a31363a226c6f676f2d656d70726573612e6a7067223b706f735f6c6f676f7c733a313a2232223b6c6f676f5f7064667c733a31323a226c6f676f2d7064662e706e67223b747970655f696d6167656e5f7064667c733a313a2231223b70726f746f636f6c7c733a343a22736d7470223b736d74705f686f73747c733a31393a226d61696c2e73697374656d617470762e636f6d223b736d74705f757365727c733a32333a226e6f2d7265706c794073697374656d617470762e636f6d223b736d74705f706173737c733a38383a226e727879507977326f635a4f70424d314d4f6b4a416568377648505a773172674f725566494b32526834304e344a44383236507142647977312b317570735030467157452f576271736a6769323868473236326c72513d3d223b736d74705f706f72747c733a333a22353837223b6d61696c706174687c4e3b756269636163696f6e5f584d4c7c733a303a22223b706173735f6669726d617c733a363a22313233343536223b757365725f736f6c7c733a373a22314441544f5331223b706173735f736f6c7c733a363a22314461746f73223b);
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES
('afe6f3841fa2ca40ffcbdb3fb26ba71d34cc8022', '::1', 1598581195, 0x5f5f63695f6c6173745f726567656e65726174657c693a313539383538313139343b6c6f63616c7c733a313a2231223b6c6973746156656e74617c693a303b6964656e746974797c733a32303a2261646d696e4073697374656d617470762e636f6d223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a32303a2261646d696e4073697374656d617470762e636f6d223b757365725f69647c733a313a2231223b66697273745f6e616d657c733a353a2241646d696e223b6c6173745f6e616d657c733a333a22545056223b637265617465645f6f6e7c733a32323a2232322f30382f323031382031323a32393a313120504d223b6f6c645f6c6173745f6c6f67696e7c733a31303a2231353938353735363332223b6c6173745f69707c733a333a223a3a31223b6176617461727c4e3b67656e6465727c733a343a226d616c65223b67726f75705f69647c733a313a2231223b72617a6f6e5f736f6369616c7c733a32343a22456d70726573612064652050727565626120262064656d6f223b7275637c733a31313a223132333435363738393132223b646972656363696f6e7c733a31393a2261762e20646573636f6e6f6369646120313233223b726567696f6e7c733a343a226c696d61223b706169737c733a343a2270657275223b6e65676f63696f7c733a313a2230223b626574617c733a313a2231223b686162696c6974615f62746e5f7061676f7c733a313a2231223b686162696c6974615f62746e5f63616a617c733a313a2230223b6c6f676f7c733a31363a226c6f676f2d656d70726573612e6a7067223b706f735f6c6f676f7c733a313a2232223b6c6f676f5f7064667c733a31323a226c6f676f2d7064662e706e67223b747970655f696d6167656e5f7064667c733a313a2231223b70726f746f636f6c7c733a343a22736d7470223b736d74705f686f73747c733a31393a226d61696c2e73697374656d617470762e636f6d223b736d74705f757365727c733a32333a226e6f2d7265706c794073697374656d617470762e636f6d223b736d74705f706173737c733a38383a226e727879507977326f635a4f70424d314d4f6b4a416568377648505a773172674f725566494b32526834304e344a44383236507142647977312b317570735030467157452f576271736a6769323868473236326c72513d3d223b736d74705f706f72747c733a333a22353837223b6d61696c706174687c4e3b756269636163696f6e5f584d4c7c733a303a22223b706173735f6669726d617c733a363a22313233343536223b757365725f736f6c7c733a373a22314441544f5331223b706173735f736f6c7c733a363a22314461746f73223b),
('b323fan0ggtk5og2m80dl78bgg', '::1', 1598575632, 0x5f5f63695f6c6173745f726567656e65726174657c693a313539383537353633323b),
('b54783e10358902d95d4791734cbdce7b24bbca5', '::1', 1598330787, 0x5f5f63695f6c6173745f726567656e65726174657c693a313539383333303738373b6c6f63616c7c733a313a2231223b6c6973746156656e74617c693a303b6964656e746974797c733a32303a2261646d696e4073697374656d617470762e636f6d223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a32303a2261646d696e4073697374656d617470762e636f6d223b757365725f69647c733a313a2231223b66697273745f6e616d657c733a353a2241646d696e223b6c6173745f6e616d657c733a333a22545056223b637265617465645f6f6e7c733a32323a2232322f30382f323031382031323a32393a313120504d223b6f6c645f6c6173745f6c6f67696e7c733a31303a2231353938333137313539223b6c6173745f69707c733a333a223a3a31223b6176617461727c4e3b67656e6465727c733a343a226d616c65223b67726f75705f69647c733a313a2231223b72617a6f6e5f736f6369616c7c733a32343a22456d70726573612064652050727565626120262064656d6f223b7275637c733a31313a223132333435363738393132223b646972656363696f6e7c733a31393a2261762e20646573636f6e6f6369646120313233223b726567696f6e7c733a343a226c696d61223b706169737c733a343a2270657275223b6e65676f63696f7c733a313a2230223b626574617c733a313a2231223b686162696c6974615f62746e5f7061676f7c733a313a2231223b686162696c6974615f62746e5f63616a617c733a313a2230223b6c6f676f7c733a31363a226c6f676f2d656d70726573612e6a7067223b706f735f6c6f676f7c733a313a2232223b6c6f676f5f7064667c733a31323a226c6f676f2d7064662e706e67223b747970655f696d6167656e5f7064667c733a313a2231223b70726f746f636f6c7c733a343a22736d7470223b736d74705f686f73747c733a31393a226d61696c2e73697374656d617470762e636f6d223b736d74705f757365727c733a32333a226e6f2d7265706c794073697374656d617470762e636f6d223b736d74705f706173737c733a38383a226e727879507977326f635a4f70424d314d4f6b4a416568377648505a773172674f725566494b32526834304e344a44383236507142647977312b317570735030467157452f576271736a6769323868473236326c72513d3d223b736d74705f706f72747c733a333a22353837223b6d61696c706174687c4e3b756269636163696f6e5f584d4c7c733a303a22223b706173735f6669726d617c733a363a22313233343536223b757365725f736f6c7c733a373a22314441544f5331223b706173735f736f6c7c733a363a22314461746f73223b),
('bf64fb32456536e54a48ff2dd4b092091ecebaf2', '::1', 1598817091, 0x5f5f63695f6c6173745f726567656e65726174657c693a313539383831373039313b6c6f63616c7c733a313a2231223b6c6973746156656e74617c693a303b6964656e746974797c733a32303a2261646d696e4073697374656d617470762e636f6d223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a32303a2261646d696e4073697374656d617470762e636f6d223b757365725f69647c733a313a2231223b66697273745f6e616d657c733a353a2241646d696e223b6c6173745f6e616d657c733a333a22545056223b637265617465645f6f6e7c733a32323a2232322f30382f323031382031323a32393a313120504d223b6f6c645f6c6173745f6c6f67696e7c733a31303a2231353938383136313334223b6c6173745f69707c733a333a223a3a31223b6176617461727c4e3b67656e6465727c733a343a226d616c65223b67726f75705f69647c733a313a2231223b72617a6f6e5f736f6369616c7c733a32343a22456d70726573612064652050727565626120262064656d6f223b7275637c733a31313a223132333435363738393132223b646972656363696f6e7c733a31393a2261762e20646573636f6e6f6369646120313233223b726567696f6e7c733a343a226c696d61223b706169737c733a343a2270657275223b6e65676f63696f7c733a313a2230223b626574617c733a313a2230223b686162696c6974615f62746e5f7061676f7c733a313a2231223b686162696c6974615f62746e5f63616a617c733a313a2230223b6c6f676f7c733a31363a226c6f676f2d656d70726573612e6a7067223b706f735f6c6f676f7c733a313a2232223b6c6f676f5f7064667c733a31323a226c6f676f2d7064662e706e67223b747970655f696d6167656e5f7064667c733a313a2231223b70726f746f636f6c7c733a343a22736d7470223b736d74705f686f73747c733a31393a226d61696c2e73697374656d617470762e636f6d223b736d74705f757365727c733a32333a226e6f2d7265706c794073697374656d617470762e636f6d223b736d74705f706173737c733a38383a2246795764306743646e7343317a326f54377137684b48655a757873612b706a5948684542527656415a3041616751693749453776536a75756c4142434530506b4576733356447872355756783131434c35387a4377413d3d223b736d74705f706f72747c733a333a22353837223b6d61696c706174687c4e3b756269636163696f6e5f584d4c7c733a303a22223b706173735f6669726d617c733a333a22343434223b757365725f736f6c7c733a333a22313233223b706173735f736f6c7c733a303a22223b),
('c013b8f52c1a83d1644317da2b439e77f8238751', '::1', 1598364185, 0x5f5f63695f6c6173745f726567656e65726174657c693a313539383336333934303b6c6f63616c7c733a313a2231223b6c6973746156656e74617c693a303b6964656e746974797c733a32303a2261646d696e4073697374656d617470762e636f6d223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a32303a2261646d696e4073697374656d617470762e636f6d223b757365725f69647c733a313a2231223b66697273745f6e616d657c733a353a2241646d696e223b6c6173745f6e616d657c733a333a22545056223b637265617465645f6f6e7c733a32323a2232322f30382f323031382031323a32393a313120504d223b6f6c645f6c6173745f6c6f67696e7c733a31303a2231353938333339333733223b6c6173745f69707c733a333a223a3a31223b6176617461727c4e3b67656e6465727c733a343a226d616c65223b67726f75705f69647c733a313a2231223b72617a6f6e5f736f6369616c7c733a32343a22456d70726573612064652050727565626120262064656d6f223b7275637c733a31313a223132333435363738393132223b646972656363696f6e7c733a31393a2261762e20646573636f6e6f6369646120313233223b726567696f6e7c733a343a226c696d61223b706169737c733a343a2270657275223b6e65676f63696f7c733a313a2230223b626574617c733a313a2231223b686162696c6974615f62746e5f7061676f7c733a313a2231223b686162696c6974615f62746e5f63616a617c733a313a2230223b6c6f676f7c733a31363a226c6f676f2d656d70726573612e6a7067223b706f735f6c6f676f7c733a313a2232223b6c6f676f5f7064667c733a31323a226c6f676f2d7064662e706e67223b747970655f696d6167656e5f7064667c733a313a2231223b70726f746f636f6c7c733a343a22736d7470223b736d74705f686f73747c733a31393a226d61696c2e73697374656d617470762e636f6d223b736d74705f757365727c733a32333a226e6f2d7265706c794073697374656d617470762e636f6d223b736d74705f706173737c733a38383a226e727879507977326f635a4f70424d314d4f6b4a416568377648505a773172674f725566494b32526834304e344a44383236507142647977312b317570735030467157452f576271736a6769323868473236326c72513d3d223b736d74705f706f72747c733a333a22353837223b6d61696c706174687c4e3b756269636163696f6e5f584d4c7c733a303a22223b706173735f6669726d617c733a363a22313233343536223b757365725f736f6c7c733a373a22314441544f5331223b706173735f736f6c7c733a363a22314461746f73223b),
('c46fd47e01a25792fd7b7fd20d813c3017ef1330', '::1', 1598583476, 0x5f5f63695f6c6173745f726567656e65726174657c693a313539383538333233353b6c6f63616c7c733a313a2231223b6c6973746156656e74617c693a303b6964656e746974797c733a32303a2261646d696e4073697374656d617470762e636f6d223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a32303a2261646d696e4073697374656d617470762e636f6d223b757365725f69647c733a313a2231223b66697273745f6e616d657c733a353a2241646d696e223b6c6173745f6e616d657c733a333a22545056223b637265617465645f6f6e7c733a32323a2232322f30382f323031382031323a32393a313120504d223b6f6c645f6c6173745f6c6f67696e7c733a31303a2231353938353735363332223b6c6173745f69707c733a333a223a3a31223b6176617461727c4e3b67656e6465727c733a343a226d616c65223b67726f75705f69647c733a313a2231223b72617a6f6e5f736f6369616c7c733a32343a22456d70726573612064652050727565626120262064656d6f223b7275637c733a31313a223132333435363738393132223b646972656363696f6e7c733a31393a2261762e20646573636f6e6f6369646120313233223b726567696f6e7c733a343a226c696d61223b706169737c733a343a2270657275223b6e65676f63696f7c733a313a2230223b626574617c733a313a2231223b686162696c6974615f62746e5f7061676f7c733a313a2231223b686162696c6974615f62746e5f63616a617c733a313a2230223b6c6f676f7c733a31363a226c6f676f2d656d70726573612e6a7067223b706f735f6c6f676f7c733a313a2232223b6c6f676f5f7064667c733a31323a226c6f676f2d7064662e706e67223b747970655f696d6167656e5f7064667c733a313a2231223b70726f746f636f6c7c733a343a22736d7470223b736d74705f686f73747c733a31393a226d61696c2e73697374656d617470762e636f6d223b736d74705f757365727c733a32333a226e6f2d7265706c794073697374656d617470762e636f6d223b736d74705f706173737c733a38383a226e727879507977326f635a4f70424d314d4f6b4a416568377648505a773172674f725566494b32526834304e344a44383236507142647977312b317570735030467157452f576271736a6769323868473236326c72513d3d223b736d74705f706f72747c733a333a22353837223b6d61696c706174687c4e3b756269636163696f6e5f584d4c7c733a303a22223b706173735f6669726d617c733a363a22313233343536223b757365725f736f6c7c733a373a22314441544f5331223b706173735f736f6c7c733a363a22314461746f73223b),
('c741f1258fc4713134968e0075814886c2fc970e', '::1', 1598363281, 0x5f5f63695f6c6173745f726567656e65726174657c693a313539383336333137393b6c6f63616c7c733a313a2231223b6c6973746156656e74617c693a303b6964656e746974797c733a32303a2261646d696e4073697374656d617470762e636f6d223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a32303a2261646d696e4073697374656d617470762e636f6d223b757365725f69647c733a313a2231223b66697273745f6e616d657c733a353a2241646d696e223b6c6173745f6e616d657c733a333a22545056223b637265617465645f6f6e7c733a32323a2232322f30382f323031382031323a32393a313120504d223b6f6c645f6c6173745f6c6f67696e7c733a31303a2231353938333339333733223b6c6173745f69707c733a333a223a3a31223b6176617461727c4e3b67656e6465727c733a343a226d616c65223b67726f75705f69647c733a313a2231223b72617a6f6e5f736f6369616c7c733a32343a22456d70726573612064652050727565626120262064656d6f223b7275637c733a31313a223132333435363738393132223b646972656363696f6e7c733a31393a2261762e20646573636f6e6f6369646120313233223b726567696f6e7c733a343a226c696d61223b706169737c733a343a2270657275223b6e65676f63696f7c733a313a2230223b626574617c733a313a2231223b686162696c6974615f62746e5f7061676f7c733a313a2231223b686162696c6974615f62746e5f63616a617c733a313a2230223b6c6f676f7c733a31363a226c6f676f2d656d70726573612e6a7067223b706f735f6c6f676f7c733a313a2232223b6c6f676f5f7064667c733a31323a226c6f676f2d7064662e706e67223b747970655f696d6167656e5f7064667c733a313a2231223b70726f746f636f6c7c733a343a22736d7470223b736d74705f686f73747c733a31393a226d61696c2e73697374656d617470762e636f6d223b736d74705f757365727c733a32333a226e6f2d7265706c794073697374656d617470762e636f6d223b736d74705f706173737c733a38383a226e727879507977326f635a4f70424d314d4f6b4a416568377648505a773172674f725566494b32526834304e344a44383236507142647977312b317570735030467157452f576271736a6769323868473236326c72513d3d223b736d74705f706f72747c733a333a22353837223b6d61696c706174687c4e3b756269636163696f6e5f584d4c7c733a303a22223b706173735f6669726d617c733a363a22313233343536223b757365725f736f6c7c733a373a22314441544f5331223b706173735f736f6c7c733a363a22314461746f73223b),
('d34acb0ba12da691d6bc20a8989be18a38805dc3', '::1', 1598608979, 0x5f5f63695f6c6173745f726567656e65726174657c693a313539383630383937393b6c6f63616c7c733a313a2231223b6c6973746156656e74617c693a303b6964656e746974797c733a32303a2261646d696e4073697374656d617470762e636f6d223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a32303a2261646d696e4073697374656d617470762e636f6d223b757365725f69647c733a313a2231223b66697273745f6e616d657c733a353a2241646d696e223b6c6173745f6e616d657c733a333a22545056223b637265617465645f6f6e7c733a32323a2232322f30382f323031382031323a32393a313120504d223b6f6c645f6c6173745f6c6f67696e7c733a31303a2231353938353735363639223b6c6173745f69707c733a333a223a3a31223b6176617461727c4e3b67656e6465727c733a343a226d616c65223b67726f75705f69647c733a313a2231223b72617a6f6e5f736f6369616c7c733a32343a22456d70726573612064652050727565626120262064656d6f223b7275637c733a31313a223132333435363738393132223b646972656363696f6e7c733a31393a2261762e20646573636f6e6f6369646120313233223b726567696f6e7c733a343a226c696d61223b706169737c733a343a2270657275223b6e65676f63696f7c733a313a2230223b626574617c733a313a2231223b686162696c6974615f62746e5f7061676f7c733a313a2231223b686162696c6974615f62746e5f63616a617c733a313a2230223b6c6f676f7c733a31363a226c6f676f2d656d70726573612e6a7067223b706f735f6c6f676f7c733a313a2232223b6c6f676f5f7064667c733a31323a226c6f676f2d7064662e706e67223b747970655f696d6167656e5f7064667c733a313a2231223b70726f746f636f6c7c733a343a22736d7470223b736d74705f686f73747c733a31393a226d61696c2e73697374656d617470762e636f6d223b736d74705f757365727c733a32333a226e6f2d7265706c794073697374656d617470762e636f6d223b736d74705f706173737c733a38383a226e727879507977326f635a4f70424d314d4f6b4a416568377648505a773172674f725566494b32526834304e344a44383236507142647977312b317570735030467157452f576271736a6769323868473236326c72513d3d223b736d74705f706f72747c733a333a22353837223b6d61696c706174687c4e3b756269636163696f6e5f584d4c7c733a303a22223b706173735f6669726d617c733a363a22313233343536223b757365725f736f6c7c733a373a22314441544f5331223b706173735f736f6c7c733a363a22314461746f73223b),
('d565c5c2851fa4dd6842d6dbec6dbd61532a3dc2', '::1', 1598339377, 0x5f5f63695f6c6173745f726567656e65726174657c693a313539383333393337313b6c6f63616c7c733a313a2231223b6c6973746156656e74617c693a303b6964656e746974797c733a32303a2261646d696e4073697374656d617470762e636f6d223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a32303a2261646d696e4073697374656d617470762e636f6d223b757365725f69647c733a313a2231223b66697273745f6e616d657c733a353a2241646d696e223b6c6173745f6e616d657c733a333a22545056223b637265617465645f6f6e7c733a32323a2232322f30382f323031382031323a32393a313120504d223b6f6c645f6c6173745f6c6f67696e7c733a31303a2231353938333231313834223b6c6173745f69707c733a333a223a3a31223b6176617461727c4e3b67656e6465727c733a343a226d616c65223b67726f75705f69647c733a313a2231223b72617a6f6e5f736f6369616c7c733a32343a22456d70726573612064652050727565626120262064656d6f223b7275637c733a31313a223132333435363738393132223b646972656363696f6e7c733a31393a2261762e20646573636f6e6f6369646120313233223b726567696f6e7c733a343a226c696d61223b706169737c733a343a2270657275223b6e65676f63696f7c733a313a2230223b626574617c733a313a2231223b686162696c6974615f62746e5f7061676f7c733a313a2231223b686162696c6974615f62746e5f63616a617c733a313a2230223b6c6f676f7c733a31363a226c6f676f2d656d70726573612e6a7067223b706f735f6c6f676f7c733a313a2232223b6c6f676f5f7064667c733a31323a226c6f676f2d7064662e706e67223b747970655f696d6167656e5f7064667c733a313a2231223b70726f746f636f6c7c733a343a22736d7470223b736d74705f686f73747c733a31393a226d61696c2e73697374656d617470762e636f6d223b736d74705f757365727c733a32333a226e6f2d7265706c794073697374656d617470762e636f6d223b736d74705f706173737c733a38383a226e727879507977326f635a4f70424d314d4f6b4a416568377648505a773172674f725566494b32526834304e344a44383236507142647977312b317570735030467157452f576271736a6769323868473236326c72513d3d223b736d74705f706f72747c733a333a22353837223b6d61696c706174687c4e3b756269636163696f6e5f584d4c7c733a303a22223b706173735f6669726d617c733a363a22313233343536223b757365725f736f6c7c733a373a22314441544f5331223b706173735f736f6c7c733a363a22314461746f73223b),
('dce2a48222dac1c98dce22effc391f15ba6abe74', '::1', 1598584130, 0x5f5f63695f6c6173745f726567656e65726174657c693a313539383538333837313b6c6f63616c7c733a313a2231223b6c6973746156656e74617c693a303b6964656e746974797c733a32303a2261646d696e4073697374656d617470762e636f6d223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a32303a2261646d696e4073697374656d617470762e636f6d223b757365725f69647c733a313a2231223b66697273745f6e616d657c733a353a2241646d696e223b6c6173745f6e616d657c733a333a22545056223b637265617465645f6f6e7c733a32323a2232322f30382f323031382031323a32393a313120504d223b6f6c645f6c6173745f6c6f67696e7c733a31303a2231353938353735363332223b6c6173745f69707c733a333a223a3a31223b6176617461727c4e3b67656e6465727c733a343a226d616c65223b67726f75705f69647c733a313a2231223b72617a6f6e5f736f6369616c7c733a32343a22456d70726573612064652050727565626120262064656d6f223b7275637c733a31313a223132333435363738393132223b646972656363696f6e7c733a31393a2261762e20646573636f6e6f6369646120313233223b726567696f6e7c733a343a226c696d61223b706169737c733a343a2270657275223b6e65676f63696f7c733a313a2230223b626574617c733a313a2231223b686162696c6974615f62746e5f7061676f7c733a313a2231223b686162696c6974615f62746e5f63616a617c733a313a2230223b6c6f676f7c733a31363a226c6f676f2d656d70726573612e6a7067223b706f735f6c6f676f7c733a313a2232223b6c6f676f5f7064667c733a31323a226c6f676f2d7064662e706e67223b747970655f696d6167656e5f7064667c733a313a2231223b70726f746f636f6c7c733a343a22736d7470223b736d74705f686f73747c733a31393a226d61696c2e73697374656d617470762e636f6d223b736d74705f757365727c733a32333a226e6f2d7265706c794073697374656d617470762e636f6d223b736d74705f706173737c733a38383a226e727879507977326f635a4f70424d314d4f6b4a416568377648505a773172674f725566494b32526834304e344a44383236507142647977312b317570735030467157452f576271736a6769323868473236326c72513d3d223b736d74705f706f72747c733a333a22353837223b6d61696c706174687c4e3b756269636163696f6e5f584d4c7c733a303a22223b706173735f6669726d617c733a363a22313233343536223b757365725f736f6c7c733a373a22314441544f5331223b706173735f736f6c7c733a363a22314461746f73223b),
('dm9tqca2d0ivesfi4thk03p61b', '::1', 1598834008, 0x5f5f63695f6c6173745f726567656e65726174657c693a313539383833343030383b6c6f63616c7c733a313a2231223b6c6973746156656e74617c693a303b6572726f727c733a36343a223c703e4572726f7220646520696e6963696f2064652073657369c3b36e2c20706f72206661766f7220696e74c3a96e74656c6f206465206e7565766f3c2f703e223b5f5f63695f766172737c613a313a7b733a353a226572726f72223b733a333a226e6577223b7d),
('ebaef6f45c16caf65143c7c99d0ab7c41d170443', '::1', 1598575620, 0x5f5f63695f6c6173745f726567656e65726174657c693a313539383537353632303b6c6f63616c7c733a313a2231223b6c6973746156656e74617c693a303b6964656e746974797c733a32303a2261646d696e4073697374656d617470762e636f6d223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a32303a2261646d696e4073697374656d617470762e636f6d223b757365725f69647c733a313a2231223b66697273745f6e616d657c733a353a2241646d696e223b6c6173745f6e616d657c733a333a22545056223b637265617465645f6f6e7c733a32323a2232322f30382f323031382031323a32393a313120504d223b6f6c645f6c6173745f6c6f67696e7c733a31303a2231353938333632383536223b6c6173745f69707c733a333a223a3a31223b6176617461727c4e3b67656e6465727c733a343a226d616c65223b67726f75705f69647c733a313a2231223b72617a6f6e5f736f6369616c7c733a32343a22456d70726573612064652050727565626120262064656d6f223b7275637c733a31313a223132333435363738393132223b646972656363696f6e7c733a31393a2261762e20646573636f6e6f6369646120313233223b726567696f6e7c733a343a226c696d61223b706169737c733a343a2270657275223b6e65676f63696f7c733a313a2230223b626574617c733a313a2231223b686162696c6974615f62746e5f7061676f7c733a313a2231223b686162696c6974615f62746e5f63616a617c733a313a2230223b6c6f676f7c733a31363a226c6f676f2d656d70726573612e6a7067223b706f735f6c6f676f7c733a313a2232223b6c6f676f5f7064667c733a31323a226c6f676f2d7064662e706e67223b747970655f696d6167656e5f7064667c733a313a2231223b70726f746f636f6c7c733a343a22736d7470223b736d74705f686f73747c733a31393a226d61696c2e73697374656d617470762e636f6d223b736d74705f757365727c733a32333a226e6f2d7265706c794073697374656d617470762e636f6d223b736d74705f706173737c733a38383a226e727879507977326f635a4f70424d314d4f6b4a416568377648505a773172674f725566494b32526834304e344a44383236507142647977312b317570735030467157452f576271736a6769323868473236326c72513d3d223b736d74705f706f72747c733a333a22353837223b6d61696c706174687c4e3b756269636163696f6e5f584d4c7c733a303a22223b706173735f6669726d617c733a363a22313233343536223b757365725f736f6c7c733a373a22314441544f5331223b706173735f736f6c7c733a363a22314461746f73223b),
('ee48b2cbd4df84bcb9f881df8ab2b5ae13030951', '::1', 1598583845, 0x5f5f63695f6c6173745f726567656e65726174657c693a313539383538333537303b6c6f63616c7c733a313a2231223b6c6973746156656e74617c693a303b6964656e746974797c733a32303a2261646d696e4073697374656d617470762e636f6d223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a32303a2261646d696e4073697374656d617470762e636f6d223b757365725f69647c733a313a2231223b66697273745f6e616d657c733a353a2241646d696e223b6c6173745f6e616d657c733a333a22545056223b637265617465645f6f6e7c733a32323a2232322f30382f323031382031323a32393a313120504d223b6f6c645f6c6173745f6c6f67696e7c733a31303a2231353938353735363332223b6c6173745f69707c733a333a223a3a31223b6176617461727c4e3b67656e6465727c733a343a226d616c65223b67726f75705f69647c733a313a2231223b72617a6f6e5f736f6369616c7c733a32343a22456d70726573612064652050727565626120262064656d6f223b7275637c733a31313a223132333435363738393132223b646972656363696f6e7c733a31393a2261762e20646573636f6e6f6369646120313233223b726567696f6e7c733a343a226c696d61223b706169737c733a343a2270657275223b6e65676f63696f7c733a313a2230223b626574617c733a313a2231223b686162696c6974615f62746e5f7061676f7c733a313a2231223b686162696c6974615f62746e5f63616a617c733a313a2230223b6c6f676f7c733a31363a226c6f676f2d656d70726573612e6a7067223b706f735f6c6f676f7c733a313a2232223b6c6f676f5f7064667c733a31323a226c6f676f2d7064662e706e67223b747970655f696d6167656e5f7064667c733a313a2231223b70726f746f636f6c7c733a343a22736d7470223b736d74705f686f73747c733a31393a226d61696c2e73697374656d617470762e636f6d223b736d74705f757365727c733a32333a226e6f2d7265706c794073697374656d617470762e636f6d223b736d74705f706173737c733a38383a226e727879507977326f635a4f70424d314d4f6b4a416568377648505a773172674f725566494b32526834304e344a44383236507142647977312b317570735030467157452f576271736a6769323868473236326c72513d3d223b736d74705f706f72747c733a333a22353837223b6d61696c706174687c4e3b756269636163696f6e5f584d4c7c733a303a22223b706173735f6669726d617c733a363a22313233343536223b757365725f736f6c7c733a373a22314441544f5331223b706173735f736f6c7c733a363a22314461746f73223b),
('f29ef48d6d02f359a46cb560eae88578f5a0f506', '::1', 1598569785, 0x5f5f63695f6c6173745f726567656e65726174657c693a313539383536393534353b6c6f63616c7c733a313a2231223b6c6973746156656e74617c693a303b6964656e746974797c733a32303a2261646d696e4073697374656d617470762e636f6d223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a32303a2261646d696e4073697374656d617470762e636f6d223b757365725f69647c733a313a2231223b66697273745f6e616d657c733a353a2241646d696e223b6c6173745f6e616d657c733a333a22545056223b637265617465645f6f6e7c733a32323a2232322f30382f323031382031323a32393a313120504d223b6f6c645f6c6173745f6c6f67696e7c733a31303a2231353938333632383536223b6c6173745f69707c733a333a223a3a31223b6176617461727c4e3b67656e6465727c733a343a226d616c65223b67726f75705f69647c733a313a2231223b72617a6f6e5f736f6369616c7c733a32343a22456d70726573612064652050727565626120262064656d6f223b7275637c733a31313a223132333435363738393132223b646972656363696f6e7c733a31393a2261762e20646573636f6e6f6369646120313233223b726567696f6e7c733a343a226c696d61223b706169737c733a343a2270657275223b6e65676f63696f7c733a313a2230223b626574617c733a313a2231223b686162696c6974615f62746e5f7061676f7c733a313a2231223b686162696c6974615f62746e5f63616a617c733a313a2230223b6c6f676f7c733a31363a226c6f676f2d656d70726573612e6a7067223b706f735f6c6f676f7c733a313a2232223b6c6f676f5f7064667c733a31323a226c6f676f2d7064662e706e67223b747970655f696d6167656e5f7064667c733a313a2231223b70726f746f636f6c7c733a343a22736d7470223b736d74705f686f73747c733a31393a226d61696c2e73697374656d617470762e636f6d223b736d74705f757365727c733a32333a226e6f2d7265706c794073697374656d617470762e636f6d223b736d74705f706173737c733a38383a226e727879507977326f635a4f70424d314d4f6b4a416568377648505a773172674f725566494b32526834304e344a44383236507142647977312b317570735030467157452f576271736a6769323868473236326c72513d3d223b736d74705f706f72747c733a333a22353837223b6d61696c706174687c4e3b756269636163696f6e5f584d4c7c733a303a22223b706173735f6669726d617c733a363a22313233343536223b757365725f736f6c7c733a373a22314441544f5331223b706173735f736f6c7c733a363a22314461746f73223b),
('f4c8ffe4f7040bb2082443864b0cbcb9cc6e5d63', '::1', 1598578182, 0x5f5f63695f6c6173745f726567656e65726174657c693a313539383537373933363b6c6f63616c7c733a313a2231223b6c6973746156656e74617c693a303b6964656e746974797c733a32303a2261646d696e4073697374656d617470762e636f6d223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a32303a2261646d696e4073697374656d617470762e636f6d223b757365725f69647c733a313a2231223b66697273745f6e616d657c733a353a2241646d696e223b6c6173745f6e616d657c733a333a22545056223b637265617465645f6f6e7c733a32323a2232322f30382f323031382031323a32393a313120504d223b6f6c645f6c6173745f6c6f67696e7c733a31303a2231353938353735363332223b6c6173745f69707c733a333a223a3a31223b6176617461727c4e3b67656e6465727c733a343a226d616c65223b67726f75705f69647c733a313a2231223b72617a6f6e5f736f6369616c7c733a32343a22456d70726573612064652050727565626120262064656d6f223b7275637c733a31313a223132333435363738393132223b646972656363696f6e7c733a31393a2261762e20646573636f6e6f6369646120313233223b726567696f6e7c733a343a226c696d61223b706169737c733a343a2270657275223b6e65676f63696f7c733a313a2230223b626574617c733a313a2231223b686162696c6974615f62746e5f7061676f7c733a313a2231223b686162696c6974615f62746e5f63616a617c733a313a2230223b6c6f676f7c733a31363a226c6f676f2d656d70726573612e6a7067223b706f735f6c6f676f7c733a313a2232223b6c6f676f5f7064667c733a31323a226c6f676f2d7064662e706e67223b747970655f696d6167656e5f7064667c733a313a2231223b70726f746f636f6c7c733a343a22736d7470223b736d74705f686f73747c733a31393a226d61696c2e73697374656d617470762e636f6d223b736d74705f757365727c733a32333a226e6f2d7265706c794073697374656d617470762e636f6d223b736d74705f706173737c733a38383a226e727879507977326f635a4f70424d314d4f6b4a416568377648505a773172674f725566494b32526834304e344a44383236507142647977312b317570735030467157452f576271736a6769323868473236326c72513d3d223b736d74705f706f72747c733a333a22353837223b6d61696c706174687c4e3b756269636163696f6e5f584d4c7c733a303a22223b706173735f6669726d617c733a363a22313233343536223b757365725f736f6c7c733a373a22314441544f5331223b706173735f736f6c7c733a363a22314461746f73223b),
('f7s9j9kt2s68d1rsqbu9nd64pv', '::1', 1598575632, 0x5f5f63695f6c6173745f726567656e65726174657c693a313539383537353633323b),
('f8ab8f905733585547e56dfee223bd4b85ced87c', '::1', 1598611000, 0x5f5f63695f6c6173745f726567656e65726174657c693a313539383631303934303b6c6f63616c7c733a313a2231223b6c6973746156656e74617c693a303b6964656e746974797c733a32303a2261646d696e4073697374656d617470762e636f6d223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a32303a2261646d696e4073697374656d617470762e636f6d223b757365725f69647c733a313a2231223b66697273745f6e616d657c733a353a2241646d696e223b6c6173745f6e616d657c733a333a22545056223b637265617465645f6f6e7c733a32323a2232322f30382f323031382031323a32393a313120504d223b6f6c645f6c6173745f6c6f67696e7c733a31303a2231353938353735363639223b6c6173745f69707c733a333a223a3a31223b6176617461727c4e3b67656e6465727c733a343a226d616c65223b67726f75705f69647c733a313a2231223b72617a6f6e5f736f6369616c7c733a32343a22456d70726573612064652050727565626120262064656d6f223b7275637c733a31313a223132333435363738393132223b646972656363696f6e7c733a31393a2261762e20646573636f6e6f6369646120313233223b726567696f6e7c733a343a226c696d61223b706169737c733a343a2270657275223b6e65676f63696f7c733a313a2230223b626574617c733a313a2231223b686162696c6974615f62746e5f7061676f7c733a313a2231223b686162696c6974615f62746e5f63616a617c733a313a2230223b6c6f676f7c733a31363a226c6f676f2d656d70726573612e6a7067223b706f735f6c6f676f7c733a313a2232223b6c6f676f5f7064667c733a31323a226c6f676f2d7064662e706e67223b747970655f696d6167656e5f7064667c733a313a2231223b70726f746f636f6c7c733a343a22736d7470223b736d74705f686f73747c733a31393a226d61696c2e73697374656d617470762e636f6d223b736d74705f757365727c733a32333a226e6f2d7265706c794073697374656d617470762e636f6d223b736d74705f706173737c733a38383a226e727879507977326f635a4f70424d314d4f6b4a416568377648505a773172674f725566494b32526834304e344a44383236507142647977312b317570735030467157452f576271736a6769323868473236326c72513d3d223b736d74705f706f72747c733a333a22353837223b6d61696c706174687c4e3b756269636163696f6e5f584d4c7c733a303a22223b706173735f6669726d617c733a363a22313233343536223b757365725f736f6c7c733a373a22314441544f5331223b706173735f736f6c7c733a363a22314461746f73223b),
('f8ec78a918a753108c9193eefb87198f7882b34e', '::1', 1598363724, 0x5f5f63695f6c6173745f726567656e65726174657c693a313539383336333531353b6c6f63616c7c733a313a2231223b6c6973746156656e74617c693a303b6964656e746974797c733a32303a2261646d696e4073697374656d617470762e636f6d223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a32303a2261646d696e4073697374656d617470762e636f6d223b757365725f69647c733a313a2231223b66697273745f6e616d657c733a353a2241646d696e223b6c6173745f6e616d657c733a333a22545056223b637265617465645f6f6e7c733a32323a2232322f30382f323031382031323a32393a313120504d223b6f6c645f6c6173745f6c6f67696e7c733a31303a2231353938333339333733223b6c6173745f69707c733a333a223a3a31223b6176617461727c4e3b67656e6465727c733a343a226d616c65223b67726f75705f69647c733a313a2231223b72617a6f6e5f736f6369616c7c733a32343a22456d70726573612064652050727565626120262064656d6f223b7275637c733a31313a223132333435363738393132223b646972656363696f6e7c733a31393a2261762e20646573636f6e6f6369646120313233223b726567696f6e7c733a343a226c696d61223b706169737c733a343a2270657275223b6e65676f63696f7c733a313a2230223b626574617c733a313a2231223b686162696c6974615f62746e5f7061676f7c733a313a2231223b686162696c6974615f62746e5f63616a617c733a313a2230223b6c6f676f7c733a31363a226c6f676f2d656d70726573612e6a7067223b706f735f6c6f676f7c733a313a2232223b6c6f676f5f7064667c733a31323a226c6f676f2d7064662e706e67223b747970655f696d6167656e5f7064667c733a313a2231223b70726f746f636f6c7c733a343a22736d7470223b736d74705f686f73747c733a31393a226d61696c2e73697374656d617470762e636f6d223b736d74705f757365727c733a32333a226e6f2d7265706c794073697374656d617470762e636f6d223b736d74705f706173737c733a38383a226e727879507977326f635a4f70424d314d4f6b4a416568377648505a773172674f725566494b32526834304e344a44383236507142647977312b317570735030467157452f576271736a6769323868473236326c72513d3d223b736d74705f706f72747c733a333a22353837223b6d61696c706174687c4e3b756269636163696f6e5f584d4c7c733a303a22223b706173735f6669726d617c733a363a22313233343536223b757365725f736f6c7c733a373a22314441544f5331223b706173735f736f6c7c733a363a22314461746f73223b),
('fb8e41ee9653407dd4f70e55fc15e5dae4b72d68', '::1', 1598765854, 0x5f5f63695f6c6173745f726567656e65726174657c693a313539383736353630323b6c6f63616c7c733a313a2231223b6c6973746156656e74617c693a303b6964656e746974797c733a32303a2261646d696e4073697374656d617470762e636f6d223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a32303a2261646d696e4073697374656d617470762e636f6d223b757365725f69647c733a313a2231223b66697273745f6e616d657c733a353a2241646d696e223b6c6173745f6e616d657c733a333a22545056223b637265617465645f6f6e7c733a32323a2232322f30382f323031382031323a32393a313120504d223b6f6c645f6c6173745f6c6f67696e7c733a31303a2231353938373233373632223b6c6173745f69707c733a333a223a3a31223b6176617461727c4e3b67656e6465727c733a343a226d616c65223b67726f75705f69647c733a313a2231223b72617a6f6e5f736f6369616c7c733a32343a22456d70726573612064652050727565626120262064656d6f223b7275637c733a31313a223132333435363738393132223b646972656363696f6e7c733a31393a2261762e20646573636f6e6f6369646120313233223b726567696f6e7c733a343a226c696d61223b706169737c733a343a2270657275223b6e65676f63696f7c733a313a2230223b626574617c733a313a2230223b686162696c6974615f62746e5f7061676f7c733a313a2231223b686162696c6974615f62746e5f63616a617c733a313a2230223b6c6f676f7c733a31363a226c6f676f2d656d70726573612e6a7067223b706f735f6c6f676f7c733a313a2232223b6c6f676f5f7064667c733a31323a226c6f676f2d7064662e706e67223b747970655f696d6167656e5f7064667c733a313a2231223b70726f746f636f6c7c733a343a22736d7470223b736d74705f686f73747c733a31393a226d61696c2e73697374656d617470762e636f6d223b736d74705f757365727c733a32333a226e6f2d7265706c794073697374656d617470762e636f6d223b736d74705f706173737c733a38383a2246795764306743646e7343317a326f54377137684b48655a757873612b706a5948684542527656415a3041616751693749453776536a75756c4142434530506b4576733356447872355756783131434c35387a4377413d3d223b736d74705f706f72747c733a333a22353837223b6d61696c706174687c4e3b756269636163696f6e5f584d4c7c733a303a22223b706173735f6669726d617c733a333a22343434223b757365725f736f6c7c733a333a22313233223b706173735f736f6c7c733a303a22223b),
('fd00c21c88006d3f3cbfdfac9c2ff93436fd4588', '::1', 1598604859, 0x5f5f63695f6c6173745f726567656e65726174657c693a313539383630343536393b6c6f63616c7c733a313a2231223b6c6973746156656e74617c693a303b6964656e746974797c733a32303a2261646d696e4073697374656d617470762e636f6d223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a32303a2261646d696e4073697374656d617470762e636f6d223b757365725f69647c733a313a2231223b66697273745f6e616d657c733a353a2241646d696e223b6c6173745f6e616d657c733a333a22545056223b637265617465645f6f6e7c733a32323a2232322f30382f323031382031323a32393a313120504d223b6f6c645f6c6173745f6c6f67696e7c733a31303a2231353938353735363639223b6c6173745f69707c733a333a223a3a31223b6176617461727c4e3b67656e6465727c733a343a226d616c65223b67726f75705f69647c733a313a2231223b72617a6f6e5f736f6369616c7c733a32343a22456d70726573612064652050727565626120262064656d6f223b7275637c733a31313a223132333435363738393132223b646972656363696f6e7c733a31393a2261762e20646573636f6e6f6369646120313233223b726567696f6e7c733a343a226c696d61223b706169737c733a343a2270657275223b6e65676f63696f7c733a313a2230223b626574617c733a313a2231223b686162696c6974615f62746e5f7061676f7c733a313a2231223b686162696c6974615f62746e5f63616a617c733a313a2230223b6c6f676f7c733a31363a226c6f676f2d656d70726573612e6a7067223b706f735f6c6f676f7c733a313a2232223b6c6f676f5f7064667c733a31323a226c6f676f2d7064662e706e67223b747970655f696d6167656e5f7064667c733a313a2231223b70726f746f636f6c7c733a343a22736d7470223b736d74705f686f73747c733a31393a226d61696c2e73697374656d617470762e636f6d223b736d74705f757365727c733a32333a226e6f2d7265706c794073697374656d617470762e636f6d223b736d74705f706173737c733a38383a226e727879507977326f635a4f70424d314d4f6b4a416568377648505a773172674f725566494b32526834304e344a44383236507142647977312b317570735030467157452f576271736a6769323868473236326c72513d3d223b736d74705f706f72747c733a333a22353837223b6d61696c706174687c4e3b756269636163696f6e5f584d4c7c733a303a22223b706173735f6669726d617c733a363a22313233343536223b757365725f736f6c7c733a373a22314441544f5331223b706173735f736f6c7c733a363a22314461746f73223b),
('j1v2qdsab9eufdpjeuut6g5utn', '::1', 1598834004, 0x5f5f63695f6c6173745f726567656e65726174657c693a313539383833343030343b),
('nh7fj8r4msi0sqlqeh3ia6ecd1', '::1', 1598575624, 0x5f5f63695f6c6173745f726567656e65726174657c693a313539383537353632343b),
('pbdtjuj4amslon4fmc753iigg5', '::1', 1598834013, 0x5f5f63695f6c6173745f726567656e65726174657c693a313539383833343031333b),
('sjo9nc30uee1mil5f515m9972v', '::1', 1598834008, 0x5f5f63695f6c6173745f726567656e65726174657c693a313539383833343030383b),
('sjrgtnh9q7o1kogtuaoinpo496', '::1', 1598575632, 0x5f5f63695f6c6173745f726567656e65726174657c693a313539383537353633323b6c6f63616c7c733a313a2231223b6c6973746156656e74617c693a303b6964656e746974797c733a32303a2261646d696e4073697374656d617470762e636f6d223b757365726e616d657c733a353a2261646d696e223b656d61696c7c733a32303a2261646d696e4073697374656d617470762e636f6d223b757365725f69647c733a313a2231223b66697273745f6e616d657c733a353a2241646d696e223b6c6173745f6e616d657c733a333a22545056223b637265617465645f6f6e7c733a32323a2232322f30382f323031382031323a32393a313120504d223b6f6c645f6c6173745f6c6f67696e7c733a31303a2231353938353536383037223b6c6173745f69707c733a333a223a3a31223b6176617461727c4e3b67656e6465727c733a343a226d616c65223b67726f75705f69647c733a313a2231223b72617a6f6e5f736f6369616c7c733a32343a22456d70726573612064652050727565626120262064656d6f223b7275637c733a31313a223132333435363738393132223b646972656363696f6e7c733a31393a2261762e20646573636f6e6f6369646120313233223b726567696f6e7c733a343a226c696d61223b706169737c733a343a2270657275223b6e65676f63696f7c733a313a2230223b626574617c733a313a2231223b686162696c6974615f62746e5f7061676f7c733a313a2231223b686162696c6974615f62746e5f63616a617c733a313a2230223b6c6f676f7c733a31363a226c6f676f2d656d70726573612e6a7067223b706f735f6c6f676f7c733a313a2232223b6c6f676f5f7064667c733a31323a226c6f676f2d7064662e706e67223b747970655f696d6167656e5f7064667c733a313a2231223b70726f746f636f6c7c733a343a22736d7470223b736d74705f686f73747c733a31393a226d61696c2e73697374656d617470762e636f6d223b736d74705f757365727c733a32333a226e6f2d7265706c794073697374656d617470762e636f6d223b736d74705f706173737c733a38383a226e727879507977326f635a4f70424d314d4f6b4a416568377648505a773172674f725566494b32526834304e344a44383236507142647977312b317570735030467157452f576271736a6769323868473236326c72513d3d223b736d74705f706f72747c733a333a22353837223b6d61696c706174687c4e3b756269636163696f6e5f584d4c7c733a303a22223b706173735f6669726d617c733a363a22313233343536223b757365725f736f6c7c733a373a22314441544f5331223b706173735f736f6c7c733a363a22314461746f73223b6d6573736167657c733a34353a223c703ec2a14c6f67756561646f20636f6e20c3a97869746f2120536561206269656e76656e69646f213c2f703e223b5f5f63695f766172737c613a313a7b733a373a226d657373616765223b733a333a226e6577223b7d),
('v56tt3r7c6c5fuoirdvjonjfgv', '::1', 1598575624, 0x5f5f63695f6c6173745f726567656e65726174657c693a313539383537353632343b);

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `tec_settings`
--

CREATE TABLE `tec_settings` (
  `setting_id` int(1) NOT NULL,
  `logo` varchar(255) NOT NULL,
  `site_name` varchar(55) NOT NULL,
  `tel` varchar(20) NOT NULL,
  `dateformat` varchar(20) DEFAULT NULL,
  `timeformat` varchar(20) DEFAULT NULL,
  `default_email` varchar(100) NOT NULL,
  `language` varchar(20) NOT NULL,
  `version` varchar(5) NOT NULL DEFAULT '1.0',
  `theme` varchar(20) NOT NULL,
  `timezone` varchar(255) NOT NULL DEFAULT '0',
  `protocol` varchar(20) NOT NULL DEFAULT 'mail',
  `smtp_host` varchar(255) DEFAULT NULL,
  `smtp_user` varchar(100) DEFAULT NULL,
  `smtp_pass` varchar(255) DEFAULT NULL,
  `smtp_port` varchar(10) DEFAULT '25',
  `smtp_crypto` varchar(5) DEFAULT NULL,
  `mmode` tinyint(1) NOT NULL,
  `captcha` tinyint(1) NOT NULL DEFAULT '1',
  `mailpath` varchar(55) DEFAULT NULL,
  `currency_prefix` varchar(3) NOT NULL,
  `default_customer` int(11) NOT NULL,
  `default_tax_rate` varchar(20) NOT NULL,
  `rows_per_page` int(2) NOT NULL,
  `total_rows` int(2) NOT NULL,
  `header` varchar(1000) NOT NULL,
  `footer` varchar(1000) NOT NULL,
  `bsty` tinyint(4) NOT NULL,
  `display_kb` tinyint(4) NOT NULL,
  `default_category` int(11) NOT NULL,
  `default_discount` varchar(20) NOT NULL,
  `item_addition` tinyint(1) NOT NULL,
  `barcode_symbology` varchar(55) NOT NULL,
  `pro_limit` tinyint(4) NOT NULL,
  `decimals` tinyint(1) NOT NULL DEFAULT '2',
  `thousands_sep` varchar(2) NOT NULL DEFAULT ',',
  `decimals_sep` varchar(2) NOT NULL DEFAULT '.',
  `focus_add_item` varchar(55) DEFAULT NULL,
  `add_customer` varchar(55) DEFAULT NULL,
  `toggle_category_slider` varchar(55) DEFAULT NULL,
  `cancel_sale` varchar(55) DEFAULT NULL,
  `suspend_sale` varchar(55) DEFAULT NULL,
  `print_order` varchar(55) DEFAULT NULL,
  `print_bill` varchar(55) DEFAULT NULL,
  `finalize_sale` varchar(55) DEFAULT NULL,
  `today_sale` varchar(55) DEFAULT NULL,
  `open_hold_bills` varchar(55) DEFAULT NULL,
  `close_register` varchar(55) DEFAULT NULL,
  `java_applet` tinyint(1) NOT NULL,
  `receipt_printer` varchar(55) DEFAULT NULL,
  `pos_printers` varchar(255) DEFAULT NULL,
  `cash_drawer_codes` varchar(55) DEFAULT NULL,
  `char_per_line` tinyint(4) DEFAULT '42',
  `rounding` tinyint(1) DEFAULT '0',
  `pin_code` varchar(20) DEFAULT NULL,
  `stripe` tinyint(1) DEFAULT NULL,
  `stripe_secret_key` varchar(100) DEFAULT NULL,
  `stripe_publishable_key` varchar(100) DEFAULT NULL,
  `purchase_code` varchar(100) DEFAULT NULL,
  `envato_username` varchar(50) DEFAULT NULL,
  `default_warehouse` int(11) NOT NULL,
  `invoice_format` varchar(50) NOT NULL,
  `bill_format` varchar(50) NOT NULL,
  `invoice_number` int(11) NOT NULL,
  `bill_number` int(11) NOT NULL,
  `nventa_format` varchar(50) NOT NULL,
  `nventa_number` int(11) NOT NULL,
  `note_credit_invoice_format` varchar(50) NOT NULL,
  `note_credit_invoice_number` int(11) NOT NULL,
  `note_credit_bill_format` varchar(50) NOT NULL,
  `note_credit_bill_number` int(11) NOT NULL,
  `referral_guide_format` varchar(50) NOT NULL,
  `referral_guide_number` int(11) NOT NULL,
  `beta` int(11) DEFAULT NULL,
  `habilita_btn_pago` int(11) DEFAULT NULL,
  `habilita_btn_caja` int(11) DEFAULT NULL,
  `logo_auth` varchar(50) DEFAULT NULL,
  `pos_logo` int(11) DEFAULT NULL,
  `logo_pdf` varchar(50) DEFAULT NULL,
  `type_imagen_pdf` int(11) DEFAULT NULL,
  `advanced_sale` int(11) NOT NULL,
  `tax_icbper` int(11) NOT NULL,
  `mail_incidents` varchar(100) NOT NULL,
  `pdf_format` int(11) DEFAULT NULL,
  `type_Print` int(11) NOT NULL,
  `summaries_limit` int(11) NOT NULL,
  `ubicacion_XML` longtext NOT NULL,
  `direccion` longtext NOT NULL,
  `region` varchar(100) NOT NULL,
  `pais` varchar(100) NOT NULL,
  `razon_social` longtext NOT NULL,
  `ruc` varchar(20) NOT NULL,
  `pass_firma` varchar(50) NOT NULL,
  `user_sol` varchar(50) NOT NULL,
  `pass_sol` varchar(50) NOT NULL,
  `beta_pass_firma` varchar(50) NOT NULL,
  `beta_user_sol` varchar(50) NOT NULL,
  `beta_pass_sol` varchar(50) NOT NULL,
  `negocio` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Volcado de datos para la tabla `tec_settings`
--

INSERT INTO `tec_settings` (`setting_id`, `logo`, `site_name`, `tel`, `dateformat`, `timeformat`, `default_email`, `language`, `version`, `theme`, `timezone`, `protocol`, `smtp_host`, `smtp_user`, `smtp_pass`, `smtp_port`, `smtp_crypto`, `mmode`, `captcha`, `mailpath`, `currency_prefix`, `default_customer`, `default_tax_rate`, `rows_per_page`, `total_rows`, `header`, `footer`, `bsty`, `display_kb`, `default_category`, `default_discount`, `item_addition`, `barcode_symbology`, `pro_limit`, `decimals`, `thousands_sep`, `decimals_sep`, `focus_add_item`, `add_customer`, `toggle_category_slider`, `cancel_sale`, `suspend_sale`, `print_order`, `print_bill`, `finalize_sale`, `today_sale`, `open_hold_bills`, `close_register`, `java_applet`, `receipt_printer`, `pos_printers`, `cash_drawer_codes`, `char_per_line`, `rounding`, `pin_code`, `stripe`, `stripe_secret_key`, `stripe_publishable_key`, `purchase_code`, `envato_username`, `default_warehouse`, `invoice_format`, `bill_format`, `invoice_number`, `bill_number`, `nventa_format`, `nventa_number`, `note_credit_invoice_format`, `note_credit_invoice_number`, `note_credit_bill_format`, `note_credit_bill_number`, `referral_guide_format`, `referral_guide_number`, `beta`, `habilita_btn_pago`, `habilita_btn_caja`, `logo_auth`, `pos_logo`, `logo_pdf`, `type_imagen_pdf`, `advanced_sale`, `tax_icbper`, `mail_incidents`, `pdf_format`, `type_Print`, `summaries_limit`, `ubicacion_XML`, `direccion`, `region`, `pais`, `razon_social`, `ruc`, `pass_firma`, `user_sol`, `pass_sol`, `beta_pass_firma`, `beta_user_sol`, `beta_pass_sol`, `negocio`) VALUES
(1, 'logoTPV_B.png', 'Demo', '941547452', 'd/m/Y', 'h:i:s A', 'no-reply@sistematpv.com', 'spanish', '2.5.0', 'default', 'America/Lima', 'smtp', 'mail.sistematpv.com', 'no-reply@sistematpv.com', 'PTTfx3Uk61mQSBkJyA7Ks2daN/K5FH8zhPuq3bnzq0xo2zs/NoGGsmdD+EFk2QiClSDcGEnUCvuM+YJwgZmqDQ==', '587', 'ssl', 0, 0, NULL, 'PEN', 0, '18', 25, 30, '<img src=\"http://www.staffcreativa.pe/blog/wp-content/uploads/diseno-de-logotipos.png\" alt=\"diseno-de-logotipos\"><br>CLIENTE DE PRUEBAS<br>AV. SAN LUIS 3082 SAN BORJA<br>LIMA - PERU<br>RUC. 20603248661', 'PUEDE SER CONSULTADA MEDIANTE <a id=\"selection-marker-1\" class=\"redactor-selection-marker\">http://mederma.sistematpv.com/Search_invoice</a><br>Autorizado mediante resolución <br>No. 155-2017/Sunat<br><br>Gracias por elegirnos!<br>', 3, 0, 1, '0', 1, '', 100, 2, ',', '.', 'F7', 'ALT+F2', 'ALT+F10', 'F3', 'F2', 'F6', 'F4', 'F1', 'Ctrl+F1', 'F5', 'ALT+F7', 0, NULL, NULL, NULL, 42, 5, '1234', NULL, NULL, NULL, 'ff2400d9-f3aa-4db5-9dc5-4eee236c6254', 'patriciomelo', 1, 'F001-{0000000}', 'B001-{0000000}', 0, 0, 'NV001-{0000}', 0, 'FC01-{0000000}', 0, 'BC01-{0000000}', 0, 'T001-{0000000}', 0, 1, 1, 0, 'logo-empresa.jpg', 2, 'logo-pdf.png', 1, 0, 1, 'informes@actecperu.com', 1, 1, 500, '/home/sistematpv/public_html/api/wsfe/archivos_xml_sunat/FE/', 'av. desconocida 123', 'lima', 'peru', '', '', '', '', '', '123456', '1DATOS1', '1Datos', 0);

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `tec_suppliers`
--

CREATE TABLE `tec_suppliers` (
  `id` int(11) NOT NULL,
  `name` varchar(55) NOT NULL,
  `cf1` varchar(255) NOT NULL,
  `cf2` varchar(255) NOT NULL,
  `phone` varchar(20) NOT NULL,
  `email` varchar(100) NOT NULL,
  `custom_field_1` varchar(250) DEFAULT NULL,
  `custom_field_2` varchar(250) DEFAULT NULL,
  `custom_field_3` varchar(250) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `tec_suspended_items`
--

CREATE TABLE `tec_suspended_items` (
  `id` int(11) NOT NULL,
  `suspend_id` int(11) NOT NULL,
  `product_id` int(11) NOT NULL,
  `quantity` decimal(15,2) NOT NULL,
  `unit_price` decimal(25,2) NOT NULL,
  `net_unit_price` decimal(25,2) NOT NULL,
  `discount` varchar(20) DEFAULT NULL,
  `item_discount` decimal(25,2) DEFAULT NULL,
  `tax` int(20) DEFAULT NULL,
  `item_tax` decimal(25,2) DEFAULT NULL,
  `subtotal` decimal(25,2) NOT NULL,
  `real_unit_price` decimal(25,2) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `tec_suspended_sales`
--

CREATE TABLE `tec_suspended_sales` (
  `id` int(11) NOT NULL,
  `date` datetime NOT NULL,
  `customer_id` int(11) NOT NULL,
  `customer_name` varchar(55) NOT NULL,
  `total` decimal(25,2) NOT NULL,
  `product_discount` decimal(25,2) DEFAULT NULL,
  `order_discount_id` varchar(20) DEFAULT NULL,
  `order_discount` decimal(25,2) DEFAULT NULL,
  `total_discount` decimal(25,2) DEFAULT NULL,
  `product_tax` decimal(25,2) DEFAULT NULL,
  `order_tax_id` varchar(20) DEFAULT NULL,
  `order_tax` decimal(25,2) DEFAULT NULL,
  `total_tax` decimal(25,2) DEFAULT NULL,
  `grand_total` decimal(25,2) NOT NULL,
  `total_items` int(11) DEFAULT NULL,
  `total_quantity` decimal(15,2) DEFAULT NULL,
  `paid` decimal(25,2) DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `note` varchar(1000) DEFAULT NULL,
  `hold_ref` varchar(255) DEFAULT NULL,
  `canal_id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `tec_tax_icbper`
--

CREATE TABLE `tec_tax_icbper` (
  `id` int(11) NOT NULL,
  `year` int(11) NOT NULL,
  `amount` decimal(25,2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Volcado de datos para la tabla `tec_tax_icbper`
--

INSERT INTO `tec_tax_icbper` (`id`, `year`, `amount`) VALUES
(1, 2019, '0.10'),
(2, 2020, '0.20'),
(3, 2021, '0.30'),
(4, 2022, '0.40'),
(5, 2023, '0.50');

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `tec_transfers`
--

CREATE TABLE `tec_transfers` (
  `id` int(11) NOT NULL,
  `num` varchar(100) DEFAULT NULL,
  `ref` varchar(250) DEFAULT NULL,
  `warehouse_origin_id` int(11) DEFAULT NULL,
  `warehouse_destiny_id` int(11) DEFAULT NULL,
  `estado` int(11) DEFAULT NULL,
  `uCrea` int(11) DEFAULT NULL,
  `fCrea` timestamp NULL DEFAULT NULL,
  `uActualiza` int(11) DEFAULT NULL,
  `fActualiza` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `tec_transfer_items`
--

CREATE TABLE `tec_transfer_items` (
  `id` int(11) NOT NULL,
  `transfer_id` int(11) DEFAULT NULL,
  `product_id` int(11) DEFAULT NULL,
  `stock_prev` int(11) DEFAULT NULL,
  `stock_new` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `tec_users`
--

CREATE TABLE `tec_users` (
  `id` int(11) UNSIGNED NOT NULL,
  `last_ip_address` varbinary(45) DEFAULT NULL,
  `ip_address` varbinary(45) DEFAULT NULL,
  `username` varchar(100) NOT NULL,
  `password` varchar(40) NOT NULL,
  `salt` varchar(40) DEFAULT NULL,
  `email` varchar(100) NOT NULL,
  `activation_code` varchar(40) DEFAULT NULL,
  `forgotten_password_code` varchar(40) DEFAULT NULL,
  `forgotten_password_time` int(11) UNSIGNED DEFAULT NULL,
  `remember_code` varchar(40) DEFAULT NULL,
  `created_on` int(11) UNSIGNED NOT NULL,
  `last_login` int(11) UNSIGNED DEFAULT NULL,
  `active` tinyint(1) UNSIGNED DEFAULT NULL,
  `first_name` varchar(50) DEFAULT NULL,
  `last_name` varchar(50) DEFAULT NULL,
  `company` varchar(100) DEFAULT NULL,
  `phone` varchar(20) DEFAULT NULL,
  `avatar` varchar(55) DEFAULT NULL,
  `gender` varchar(20) DEFAULT NULL,
  `group_id` int(11) UNSIGNED NOT NULL DEFAULT '2'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Volcado de datos para la tabla `tec_users`
--

INSERT INTO `tec_users` (`id`, `last_ip_address`, `ip_address`, `username`, `password`, `salt`, `email`, `activation_code`, `forgotten_password_code`, `forgotten_password_time`, `remember_code`, `created_on`, `last_login`, `active`, `first_name`, `last_name`, `company`, `phone`, `avatar`, `gender`, `group_id`) VALUES
(1, 0x3a3a31, 0x3139302e3233352e37382e3535, 'admin', '4c547a4ab4036b371474bd00c813bdf590d627ca', NULL, 'admin@sistematpv.com', NULL, NULL, NULL, NULL, 1534958951, 1598834103, 1, 'Admin', 'TPV', NULL, '123456789', NULL, 'male', 1);

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `tec_user_logins`
--

CREATE TABLE `tec_user_logins` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `company_id` int(11) DEFAULT NULL,
  `ip_address` varbinary(16) NOT NULL,
  `login` varchar(100) NOT NULL,
  `time` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Volcado de datos para la tabla `tec_user_logins`
--

INSERT INTO `tec_user_logins` (`id`, `user_id`, `company_id`, `ip_address`, `login`, `time`) VALUES
(1, 1, NULL, 0x3a3a31, 'admin@sistematpv.com', '2020-08-25 00:59:20'),
(2, 1, NULL, 0x3a3a31, 'admin@sistematpv.com', '2020-08-25 02:06:24'),
(3, 1, NULL, 0x3a3a31, 'admin@sistematpv.com', '2020-08-25 07:09:33'),
(4, 1, NULL, 0x3a3a31, 'admin@sistematpv.com', '2020-08-25 13:40:56'),
(5, 1, NULL, 0x3a3a31, 'admin@sistematpv.com', '2020-08-27 19:33:28'),
(6, 1, NULL, 0x3a3a31, 'admin@sistematpv.com', '2020-08-28 00:47:12'),
(7, 1, NULL, 0x3a3a31, 'admin@sistematpv.com', '2020-08-28 00:47:49'),
(8, 1, NULL, 0x3a3a31, 'admin@sistematpv.com', '2020-08-28 07:53:28'),
(9, 1, NULL, 0x3a3a31, 'admin@sistematpv.com', '2020-08-28 12:44:36'),
(10, 1, NULL, 0x3a3a31, 'admin@sistematpv.com', '2020-08-28 20:00:40'),
(11, 1, NULL, 0x3a3a31, 'admin@sistematpv.com', '2020-08-28 20:54:55'),
(12, 1, NULL, 0x3a3a31, 'admin@sistematpv.com', '2020-08-28 20:55:01'),
(13, 1, NULL, 0x3a3a31, 'admin@sistematpv.com', '2020-08-28 20:55:42'),
(14, 1, NULL, 0x3a3a31, 'admin@sistematpv.com', '2020-08-28 20:56:47'),
(15, 1, NULL, 0x3a3a31, 'admin@sistematpv.com', '2020-08-28 20:56:56'),
(16, 1, NULL, 0x3a3a31, 'admin@sistematpv.com', '2020-08-28 21:00:46'),
(17, 1, NULL, 0x3a3a31, 'admin@sistematpv.com', '2020-08-29 17:56:02'),
(18, 1, NULL, 0x3a3a31, 'admin@sistematpv.com', '2020-08-30 05:33:30'),
(19, 1, NULL, 0x3a3a31, 'admin@sistematpv.com', '2020-08-30 19:35:34'),
(20, 1, NULL, 0x3a3a31, 'admin@sistematpv.com', '2020-08-30 19:43:21'),
(21, 1, NULL, 0x3a3a31, 'admin@sistematpv.com', '2020-08-31 00:33:33'),
(22, 1, NULL, 0x3a3a31, 'admin@sistematpv.com', '2020-08-31 00:35:03');

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `tec_warehouses`
--

CREATE TABLE `tec_warehouses` (
  `id` int(11) NOT NULL,
  `warehouse` varchar(250) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Volcado de datos para la tabla `tec_warehouses`
--

INSERT INTO `tec_warehouses` (`id`, `warehouse`) VALUES
(1, 'principal');

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `tec_warehouse_stock`
--

CREATE TABLE `tec_warehouse_stock` (
  `id` int(11) NOT NULL,
  `warehouse_id` int(11) NOT NULL,
  `product_id` int(11) NOT NULL,
  `stock` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Índices para tablas volcadas
--

--
-- Indices de la tabla `tec_canals`
--
ALTER TABLE `tec_canals`
  ADD PRIMARY KEY (`id`);

--
-- Indices de la tabla `tec_categories`
--
ALTER TABLE `tec_categories`
  ADD PRIMARY KEY (`id`);

--
-- Indices de la tabla `tec_combo_items`
--
ALTER TABLE `tec_combo_items`
  ADD PRIMARY KEY (`id`);

--
-- Indices de la tabla `tec_credit_note`
--
ALTER TABLE `tec_credit_note`
  ADD PRIMARY KEY (`id`);

--
-- Indices de la tabla `tec_credit_note_files`
--
ALTER TABLE `tec_credit_note_files`
  ADD PRIMARY KEY (`id`);

--
-- Indices de la tabla `tec_credit_note_items`
--
ALTER TABLE `tec_credit_note_items`
  ADD PRIMARY KEY (`id`);

--
-- Indices de la tabla `tec_credit_note_motive`
--
ALTER TABLE `tec_credit_note_motive`
  ADD PRIMARY KEY (`id`);

--
-- Indices de la tabla `tec_customers`
--
ALTER TABLE `tec_customers`
  ADD PRIMARY KEY (`id`);

--
-- Indices de la tabla `tec_customers_type`
--
ALTER TABLE `tec_customers_type`
  ADD PRIMARY KEY (`id`);

--
-- Indices de la tabla `tec_doctors`
--
ALTER TABLE `tec_doctors`
  ADD PRIMARY KEY (`id`);

--
-- Indices de la tabla `tec_document_type`
--
ALTER TABLE `tec_document_type`
  ADD PRIMARY KEY (`id`);

--
-- Indices de la tabla `tec_exchange`
--
ALTER TABLE `tec_exchange`
  ADD PRIMARY KEY (`id`);

--
-- Indices de la tabla `tec_expenses`
--
ALTER TABLE `tec_expenses`
  ADD PRIMARY KEY (`id`);

--
-- Indices de la tabla `tec_gift_cards`
--
ALTER TABLE `tec_gift_cards`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `card_no` (`card_no`);

--
-- Indices de la tabla `tec_groups`
--
ALTER TABLE `tec_groups`
  ADD PRIMARY KEY (`id`);

--
-- Indices de la tabla `tec_locals`
--
ALTER TABLE `tec_locals`
  ADD PRIMARY KEY (`id`);

--
-- Indices de la tabla `tec_login_attempts`
--
ALTER TABLE `tec_login_attempts`
  ADD PRIMARY KEY (`id`);

--
-- Indices de la tabla `tec_makers`
--
ALTER TABLE `tec_makers`
  ADD PRIMARY KEY (`id`);

--
-- Indices de la tabla `tec_mesas`
--
ALTER TABLE `tec_mesas`
  ADD PRIMARY KEY (`id`);

--
-- Indices de la tabla `tec_motive_referral_guide`
--
ALTER TABLE `tec_motive_referral_guide`
  ADD PRIMARY KEY (`id`);

--
-- Indices de la tabla `tec_mov_motive`
--
ALTER TABLE `tec_mov_motive`
  ADD PRIMARY KEY (`id`);

--
-- Indices de la tabla `tec_payments`
--
ALTER TABLE `tec_payments`
  ADD PRIMARY KEY (`id`);

--
-- Indices de la tabla `tec_products`
--
ALTER TABLE `tec_products`
  ADD PRIMARY KEY (`id`);

--
-- Indices de la tabla `tec_product_mov`
--
ALTER TABLE `tec_product_mov`
  ADD PRIMARY KEY (`id`);

--
-- Indices de la tabla `tec_purchases`
--
ALTER TABLE `tec_purchases`
  ADD PRIMARY KEY (`id`);

--
-- Indices de la tabla `tec_purchase_items`
--
ALTER TABLE `tec_purchase_items`
  ADD PRIMARY KEY (`id`);

--
-- Indices de la tabla `tec_purchase_pay`
--
ALTER TABLE `tec_purchase_pay`
  ADD PRIMARY KEY (`id`);

--
-- Indices de la tabla `tec_referral_guide`
--
ALTER TABLE `tec_referral_guide`
  ADD PRIMARY KEY (`id`);

--
-- Indices de la tabla `tec_referral_guide_files`
--
ALTER TABLE `tec_referral_guide_files`
  ADD PRIMARY KEY (`id`);

--
-- Indices de la tabla `tec_referral_guide_items`
--
ALTER TABLE `tec_referral_guide_items`
  ADD PRIMARY KEY (`id`);

--
-- Indices de la tabla `tec_registers`
--
ALTER TABLE `tec_registers`
  ADD PRIMARY KEY (`id`);

--
-- Indices de la tabla `tec_sales`
--
ALTER TABLE `tec_sales`
  ADD PRIMARY KEY (`id`);

--
-- Indices de la tabla `tec_sales_files`
--
ALTER TABLE `tec_sales_files`
  ADD PRIMARY KEY (`id`);

--
-- Indices de la tabla `tec_sale_items`
--
ALTER TABLE `tec_sale_items`
  ADD PRIMARY KEY (`id`);

--
-- Indices de la tabla `tec_send_invoice`
--
ALTER TABLE `tec_send_invoice`
  ADD PRIMARY KEY (`id`);

--
-- Indices de la tabla `tec_send_invoice_gr`
--
ALTER TABLE `tec_send_invoice_gr`
  ADD PRIMARY KEY (`id`);

--
-- Indices de la tabla `tec_send_invoice_items`
--
ALTER TABLE `tec_send_invoice_items`
  ADD PRIMARY KEY (`id`);

--
-- Indices de la tabla `tec_send_invoice_nc`
--
ALTER TABLE `tec_send_invoice_nc`
  ADD PRIMARY KEY (`id`);

--
-- Indices de la tabla `tec_sessions`
--
ALTER TABLE `tec_sessions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `ci_sessions_timestamp` (`timestamp`);

--
-- Indices de la tabla `tec_settings`
--
ALTER TABLE `tec_settings`
  ADD PRIMARY KEY (`setting_id`);

--
-- Indices de la tabla `tec_suppliers`
--
ALTER TABLE `tec_suppliers`
  ADD PRIMARY KEY (`id`);

--
-- Indices de la tabla `tec_suspended_items`
--
ALTER TABLE `tec_suspended_items`
  ADD PRIMARY KEY (`id`);

--
-- Indices de la tabla `tec_suspended_sales`
--
ALTER TABLE `tec_suspended_sales`
  ADD PRIMARY KEY (`id`);

--
-- Indices de la tabla `tec_tax_icbper`
--
ALTER TABLE `tec_tax_icbper`
  ADD PRIMARY KEY (`id`);

--
-- Indices de la tabla `tec_transfers`
--
ALTER TABLE `tec_transfers`
  ADD PRIMARY KEY (`id`);

--
-- Indices de la tabla `tec_transfer_items`
--
ALTER TABLE `tec_transfer_items`
  ADD PRIMARY KEY (`id`);

--
-- Indices de la tabla `tec_users`
--
ALTER TABLE `tec_users`
  ADD PRIMARY KEY (`id`),
  ADD KEY `group_id` (`group_id`);

--
-- Indices de la tabla `tec_user_logins`
--
ALTER TABLE `tec_user_logins`
  ADD PRIMARY KEY (`id`);

--
-- Indices de la tabla `tec_warehouses`
--
ALTER TABLE `tec_warehouses`
  ADD PRIMARY KEY (`id`);

--
-- Indices de la tabla `tec_warehouse_stock`
--
ALTER TABLE `tec_warehouse_stock`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT de las tablas volcadas
--

--
-- AUTO_INCREMENT de la tabla `tec_canals`
--
ALTER TABLE `tec_canals`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT de la tabla `tec_categories`
--
ALTER TABLE `tec_categories`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT de la tabla `tec_combo_items`
--
ALTER TABLE `tec_combo_items`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `tec_credit_note`
--
ALTER TABLE `tec_credit_note`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `tec_credit_note_files`
--
ALTER TABLE `tec_credit_note_files`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `tec_credit_note_items`
--
ALTER TABLE `tec_credit_note_items`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `tec_credit_note_motive`
--
ALTER TABLE `tec_credit_note_motive`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT de la tabla `tec_customers`
--
ALTER TABLE `tec_customers`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `tec_customers_type`
--
ALTER TABLE `tec_customers_type`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT de la tabla `tec_doctors`
--
ALTER TABLE `tec_doctors`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `tec_exchange`
--
ALTER TABLE `tec_exchange`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT de la tabla `tec_expenses`
--
ALTER TABLE `tec_expenses`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `tec_gift_cards`
--
ALTER TABLE `tec_gift_cards`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `tec_groups`
--
ALTER TABLE `tec_groups`
  MODIFY `id` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT de la tabla `tec_locals`
--
ALTER TABLE `tec_locals`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT de la tabla `tec_login_attempts`
--
ALTER TABLE `tec_login_attempts`
  MODIFY `id` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `tec_makers`
--
ALTER TABLE `tec_makers`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `tec_mesas`
--
ALTER TABLE `tec_mesas`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `tec_motive_referral_guide`
--
ALTER TABLE `tec_motive_referral_guide`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT de la tabla `tec_mov_motive`
--
ALTER TABLE `tec_mov_motive`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT de la tabla `tec_payments`
--
ALTER TABLE `tec_payments`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `tec_products`
--
ALTER TABLE `tec_products`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `tec_product_mov`
--
ALTER TABLE `tec_product_mov`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `tec_purchases`
--
ALTER TABLE `tec_purchases`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `tec_purchase_items`
--
ALTER TABLE `tec_purchase_items`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `tec_purchase_pay`
--
ALTER TABLE `tec_purchase_pay`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `tec_referral_guide`
--
ALTER TABLE `tec_referral_guide`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `tec_referral_guide_files`
--
ALTER TABLE `tec_referral_guide_files`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `tec_referral_guide_items`
--
ALTER TABLE `tec_referral_guide_items`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `tec_registers`
--
ALTER TABLE `tec_registers`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `tec_sales`
--
ALTER TABLE `tec_sales`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `tec_sales_files`
--
ALTER TABLE `tec_sales_files`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `tec_sale_items`
--
ALTER TABLE `tec_sale_items`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `tec_send_invoice`
--
ALTER TABLE `tec_send_invoice`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `tec_send_invoice_gr`
--
ALTER TABLE `tec_send_invoice_gr`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `tec_send_invoice_items`
--
ALTER TABLE `tec_send_invoice_items`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `tec_send_invoice_nc`
--
ALTER TABLE `tec_send_invoice_nc`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `tec_suppliers`
--
ALTER TABLE `tec_suppliers`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `tec_suspended_items`
--
ALTER TABLE `tec_suspended_items`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `tec_suspended_sales`
--
ALTER TABLE `tec_suspended_sales`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `tec_tax_icbper`
--
ALTER TABLE `tec_tax_icbper`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT de la tabla `tec_transfers`
--
ALTER TABLE `tec_transfers`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `tec_transfer_items`
--
ALTER TABLE `tec_transfer_items`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `tec_users`
--
ALTER TABLE `tec_users`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT de la tabla `tec_user_logins`
--
ALTER TABLE `tec_user_logins`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=23;

--
-- AUTO_INCREMENT de la tabla `tec_warehouses`
--
ALTER TABLE `tec_warehouses`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT de la tabla `tec_warehouse_stock`
--
ALTER TABLE `tec_warehouse_stock`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
COMMIT;


UPDATE tec_settings set version= '2.5.0';
