| Server IP : 65.108.66.160 / Your IP : 216.73.217.50 Web Server : Apache System : Linux srv16.asso.com.ar 4.18.0-553.123.1.el8_10.x86_64 #1 SMP Tue May 5 04:00:43 EDT 2026 x86_64 User : alasaweborg ( 1047) PHP Version : 7.4.33 Disable Function : exec,passthru,shell_exec,system MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /proc/thread-self/root/opt/burp_mysql_backups/ |
Upload File : |
/*M!999999\- enable the sandbox mode */ -- MariaDB dump 10.19 Distrib 10.6.27-MariaDB, for Linux (x86_64) -- -- Host: localhost Database: hacendadosrafael_web -- ------------------------------------------------------ -- Server version 10.6.27-MariaDB /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `contacto` -- DROP TABLE IF EXISTS `contacto`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `contacto` ( `id` int(11) NOT NULL AUTO_INCREMENT, `tipo` int(11) NOT NULL, `nombre` varchar(200) NOT NULL, `telefono` varchar(200) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `contacto` -- LOCK TABLES `contacto` WRITE; /*!40000 ALTER TABLE `contacto` DISABLE KEYS */; INSERT INTO `contacto` (`id`, `tipo`, `nombre`, `telefono`) VALUES (2,4,'Sr. Alejandro Alessiato','(03492) 15597472'),(3,4,'Sr. Juan Ignacio Perassi','(03492) 15603571'),(4,5,'Sr. Andrés Yennerich','(03496) 15510232'),(5,6,'Sr. Timoteo Jokanovich','(03492) 15636887 / (03408) 15672241'),(6,1,'...','(03492) 580082 / 581065 / 566614'),(10,2,'...','(03492) 578030'),(11,0,'Administración','Av. Brasil 1951 · (S2300BHG) Rafaela, Santa Fe'),(12,0,'Instalaciones Ferias','Av. Brasil 1951 · (S2300BHG) Rafaela, Santa Fe'),(13,0,'Sucursal Humboldt','Moreno 2045 · (3081) Humboldt, Santa Fe'),(14,0,'Sucursal Huanqueros','Zona Urbana · (3076) Huanqueros, Santa Fe'),(15,1,'...','clientes@hacendadosrafaela.com.ar'),(16,1,'...','contadorasahr@gmail.com'); /*!40000 ALTER TABLE `contacto` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `cuentasbancarias` -- DROP TABLE IF EXISTS `cuentasbancarias`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `cuentasbancarias` ( `id` int(11) NOT NULL AUTO_INCREMENT, `banco` varchar(200) NOT NULL, `sucursal` varchar(200) NOT NULL, `cuenta` varchar(200) NOT NULL, `cbu` varchar(200) NOT NULL, `moneda` varchar(100) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `cuentasbancarias` -- LOCK TABLES `cuentasbancarias` WRITE; /*!40000 ALTER TABLE `cuentasbancarias` DISABLE KEYS */; INSERT INTO `cuentasbancarias` (`id`, `banco`, `sucursal`, `cuenta`, `cbu`, `moneda`) VALUES (1,'Nuevo Banco de Santa Fe','Rafaela','071-520-6605/07','3300520915200006605078','Pesos'),(2,'Banco Credicoop Coop.','Rafaela','369-010972-5','1910369755036901097250','Pesos'),(3,'Banco Macro','Rafaela','3-891-0000998780-9','2850891530000099878099','Pesos'),(4,'Banco BBVA','Rafaela','207-20-000224-9-00','0170207320000000022491','Pesos'),(5,'Banco de la Nación Argentina','Rafaela','4230018642','0110423720042300186420','Pesos'),(6,'Banco Santander','Rafaela','174003724802','0720174120000037248022','Pesos'),(7,'ICBC Argentina','Rafaela','0823/02105135/44','0150823702000105135447','Pesos'); /*!40000 ALTER TABLE `cuentasbancarias` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `log` -- DROP TABLE IF EXISTS `log`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `log` ( `id` int(11) NOT NULL AUTO_INCREMENT, `fecha` datetime NOT NULL DEFAULT current_timestamp(), `usuario` int(11) NOT NULL, `cambio` varchar(500) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=66 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `log` -- LOCK TABLES `log` WRITE; /*!40000 ALTER TABLE `log` DISABLE KEYS */; INSERT INTO `log` (`id`, `fecha`, `usuario`, `cambio`) VALUES (1,'2025-09-27 08:34:43',1,'Alta <b>Remate</b> · <i>08/10/2025 · Rafaela · Último antes de la vacunación</i>'),(2,'2025-09-27 08:37:29',1,'Alta <b>Remate</b> · <i>10/10/2025 · Huanqueros </i>'),(3,'2025-10-01 08:15:45',1,'Alta <b>Precios</b> · <i>Septiembre 2025</i>'),(4,'2025-10-06 10:59:44',1,'Alta <b>Remate</b> · <i>14/10/2025 · Humboldt · Faena </i>'),(5,'2025-10-07 09:00:26',1,'Modificacion <b>Remate</b> · <i>10/10/2025 > 03/10/2025 · Huanqueros > Huanqueros </i>'),(6,'2025-10-11 10:05:54',1,'Alta <b>Remate</b> · <i>22/10/2025 · Rafaela · Faena</i>'),(7,'2025-10-23 08:56:46',1,'Alta <b>Remate</b> · <i>28/10/2025 · Humboldt · Abasto e Invernada</i>'),(8,'2025-10-23 08:57:12',1,'Alta <b>Remate</b> · <i>05/11/2025 · Rafaela · Abasto e Invernada</i>'),(9,'2025-10-23 08:57:31',1,'Alta <b>Remate</b> · <i>07/11/2025 · Huanqueros · Abasto e Invernada</i>'),(10,'2025-10-29 10:55:45',1,'Alta <b>Precios</b> · <i>Octubre 2025</i>'),(11,'2025-11-06 11:33:08',1,'Alta <b>Remate</b> · <i>11/11/2025 · Humboldt · Abasto e Invernada</i>'),(12,'2025-11-06 11:33:49',1,'Alta <b>Remate</b> · <i>19/11/2025 · Rafaela · Abasto e Invernada</i>'),(13,'2025-11-17 09:39:10',1,'Alta <b>Remate</b> · <i>26/11/2025 · Humboldt · Abasto e Invernada</i>'),(14,'2025-11-17 09:39:49',1,'Alta <b>Remate</b> · <i>05/12/2025 · Huanqueros · Abasto e Invernada</i>'),(15,'2025-11-21 08:11:48',1,'Alta <b>Remate</b> · <i>03/12/2025 · Rafaela · Especial Fin de Año</i>'),(16,'2025-11-29 10:00:24',1,'Alta <b>Remate</b> · <i>10/12/2025 · Humboldt · Especial Fin de Año</i>'),(17,'2025-11-29 10:05:30',1,'Alta <b>Precios</b> · <i>Noviembre 2025</i>'),(18,'2025-12-02 09:46:08',1,'Modificacion <b>Remate</b> · <i>03/12/2025 > 04/12/2025 · Rafaela > Rafaela · Especial Fin de Año > Especial Fin de Año</i>'),(19,'2025-12-16 07:59:52',1,'Alta <b>Remate</b> · <i>17/12/2025 · Rafaela · Abasto e Invernada</i>'),(20,'2025-12-16 08:00:39',1,'Alta <b>Remate</b> · <i>06/01/2026 · Humboldt · Abasto e Invernada</i>'),(21,'2025-12-16 08:01:06',1,'Alta <b>Remate</b> · <i>09/01/2026 · Huanqueros · Abasto e Invernada</i>'),(22,'2025-12-22 08:09:12',1,'Alta <b>Promedio Ponderado</b> · <i>2025 · Octubre-Noviembre-Diciembre · $ 1,065,698.93</i>'),(23,'2025-12-22 08:10:21',1,'Alta <b>Remate</b> · <i>14/01/2026 · Rafaela · Abasto e Invernada</i>'),(24,'2025-12-26 11:40:02',1,'Alta <b>Precios</b> · <i>Diciembre 2025</i>'),(25,'2026-01-10 08:30:08',1,'Alta <b>Remate</b> · <i>15/01/2026 · Huanqueros · Abasto e Invernada</i>'),(26,'2026-01-10 08:30:43',1,'Alta <b>Remate</b> · <i>20/01/2026 · Humboldt </i>'),(27,'2026-01-10 08:31:21',1,'Modificacion <b>Recursos Humanos</b> · <i>Representantes Zonales > Representantes Zonales · Huanqueros > Huanqueros · Timoteo Jokanovich > Timoteo Jokanovich - Jokan Jokanovich</i>'),(28,'2026-01-12 08:38:51',1,'Modificacion <b>Remate</b> · <i>20/01/2026 > 20/01/2026 · Humboldt > Humboldt · (vacio) > Abasto e Invernada</i>'),(29,'2026-01-19 07:57:59',1,'Alta <b>Remate</b> · <i>28/01/2026 · Rafaela · Abasto e Invernada</i>'),(30,'2026-01-19 07:59:18',1,'Alta <b>Remate</b> · <i>06/02/2026 · Huanqueros · Abasto e Invernada</i>'),(31,'2026-01-22 08:02:03',1,'Alta <b>Remate</b> · <i>03/02/2026 · Humboldt · Abasto e Invernada</i>'),(32,'2026-02-02 10:08:32',1,'Alta <b>Precios</b> · <i>Enero 2026</i>'),(33,'2026-02-02 10:44:02',1,'Alta <b>Remate</b> · <i>11/02/2026 · Rafaela · Abasto e Invernada</i>'),(34,'2026-02-12 05:28:47',1,'Alta <b>Remate</b> · <i>19/02/2026 · Humboldt · Abasto e Invernada</i>'),(35,'2026-02-12 05:29:12',1,'Alta <b>Remate</b> · <i>25/02/2026 · Rafaela · Abasto e Invernada </i>'),(36,'2026-02-12 05:29:32',1,'Alta <b>Remate</b> · <i>27/02/2026 · Huanqueros · Abasto e Invernada</i>'),(37,'2026-02-23 08:06:22',1,'Alta <b>Remate</b> · <i>23/02/2026 · Humboldt · Remate de Abasto e Invernada</i>'),(38,'2026-03-02 09:43:11',1,'Alta <b>Remate</b> · <i>03/03/2026 · Humboldt · SOLO FAENA</i>'),(39,'2026-03-02 09:45:27',1,'Alta <b>Precios</b> · <i>Febrero 2026</i>'),(40,'2026-03-02 09:45:45',1,'Alta <b>Remate</b> · <i>11/03/2026 · Rafaela · SOLO FAENA</i>'),(41,'2026-03-02 09:46:14',1,'Alta <b>Remate</b> · <i>03/04/2026 · Huanqueros · Abasto e Invernada</i>'),(42,'2026-03-06 08:27:32',1,'Alta <b>Remate</b> · <i>17/03/2026 · Humboldt · Abasto e Invernada</i>'),(43,'2026-04-01 09:07:54',1,'Modificacion <b>Remate</b> · <i>03/04/2026 > 10/04/2026 · Huanqueros > Huanqueros · Abasto e Invernada > Abasto e Invernada</i>'),(44,'2026-04-01 09:08:09',1,'Alta <b>Remate</b> · <i>08/04/2026 · Rafaela · Abasto e Invernada</i>'),(45,'2026-04-01 09:08:22',1,'Alta <b>Remate</b> · <i>14/04/2026 · Humboldt · Abasto e Invernada</i>'),(46,'2026-04-01 09:10:30',1,'Alta <b>Precios</b> · <i>Marzo 2026</i>'),(47,'2026-04-09 10:03:57',1,'Alta <b>Remate</b> · <i>11/04/2026 · Rafaela · Abasto e Invernada</i>'),(48,'2026-04-13 08:40:59',1,'Alta <b>Remate</b> · <i>22/04/2026 · Rafaela · Abasto e Invernada</i>'),(49,'2026-04-13 08:41:36',1,'Alta <b>Remate</b> · <i>08/05/2026 · Huanqueros · Abasto e Invernada</i>'),(50,'2026-04-16 10:10:51',1,'Alta <b>Remate</b> · <i>28/04/2026 · Humboldt · Abasto e Invernada</i>'),(51,'2026-05-04 09:50:24',1,'Alta <b>Precios</b> · <i>Abril 2026</i>'),(52,'2026-05-04 09:51:02',1,'Alta <b>Remate</b> · <i>06/05/2026 · Rafaela · Especial de Otoño Invernada y Abasto</i>'),(53,'2026-05-04 09:51:16',1,'Alta <b>Remate</b> · <i>12/05/2026 · Humboldt · Abasto e Invernada</i>'),(54,'2026-05-08 08:55:38',1,'Modificacion <b>Remate</b> · <i>08/05/2026 > 13/05/2026 · Huanqueros > Huanqueros · Abasto e Invernada > Abasto e Invernada</i>'),(55,'2026-05-08 08:56:04',1,'Alta <b>Remate</b> · <i>20/05/2026 · Rafaela · Abasto e Invernada</i>'),(56,'2026-05-18 11:39:29',1,'Alta <b>Remate</b> · <i>26/05/2026 · Humboldt · Abasto e Invernada</i>'),(57,'2026-05-18 11:40:18',1,'Alta <b>Remate</b> · <i>05/06/2026 · Huanqueros · Abasto e Invernada</i>'),(58,'2026-05-26 08:19:59',1,'Modificacion <b>Remate</b> · <i>26/05/2026 > 27/05/2026 · Humboldt > Humboldt · Abasto e Invernada > Abasto e Invernada</i>'),(59,'2026-05-26 08:20:23',1,'Alta <b>Remate</b> · <i>03/06/2026 · Rafaela · Abasto e Invernada</i>'),(60,'2026-06-01 09:17:12',1,'Alta <b>Remate</b> · <i>09/06/2026 · Humboldt · Abasto e Invernada</i>'),(61,'2026-06-01 09:41:03',1,'Alta <b>Precios</b> · <i>Mayo 2026</i>'),(62,'2026-06-08 09:39:02',1,'Modificacion <b>Remate</b> · <i>09/06/2026 > 11/06/2026 · Humboldt > Humboldt · Abasto e Invernada > Abasto e Invernada</i>'),(63,'2026-06-08 09:39:25',1,'Alta <b>Remate</b> · <i>17/06/2026 · Rafaela · Abasto e Invernada</i>'),(64,'2026-06-08 09:39:50',1,'Alta <b>Remate</b> · <i>03/07/2026 · Huanqueros · Abasto e Invernada</i>'),(65,'2026-06-11 08:48:19',1,'Modificacion <b>Remate</b> · <i>11/06/2026 > 16/06/2026 · Humboldt > Humboldt · Abasto e Invernada > Abasto e Invernada</i>'); /*!40000 ALTER TABLE `log` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `ponderados` -- DROP TABLE IF EXISTS `ponderados`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `ponderados` ( `id` int(11) NOT NULL AUTO_INCREMENT, `anio` int(11) NOT NULL, `trimestre` varchar(200) NOT NULL, `promedio` decimal(10,2) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `ponderados` -- LOCK TABLES `ponderados` WRITE; /*!40000 ALTER TABLE `ponderados` DISABLE KEYS */; INSERT INTO `ponderados` (`id`, `anio`, `trimestre`, `promedio`) VALUES (1,2024,'Marzo-Abril-Mayo',397402.16),(2,2024,'Octubre-Noviembre-Diciembre',573941.18),(3,2023,'Agosto-septiembre-octubre',239085.98),(4,2023,'Octubre-noviembre-diciembre',177202.06),(5,2022,'marzo-abril-mayo',70679.93),(6,2022,'Agosto-septiembre-octubre',84901.08),(7,2022,'Octubre-noviembre-diciembre',75481.14),(8,2021,'octubre-noviembre-diciembre',60496.67),(9,2021,'mayo-junio-julio',41119.42),(10,2021,'abril-mayo-junio',40717.86),(12,2020,'octubre-noviembre-diciembre',33783.21),(13,2020,'julio-agosto-septiembre',28456.27),(14,2020,'abril-mayo-junio',22726.21),(16,2025,'Abril-Mayo-Junio',686251.87),(17,2025,'Octubre-Noviembre-Diciembre',1065698.93); /*!40000 ALTER TABLE `ponderados` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `precios` -- DROP TABLE IF EXISTS `precios`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `precios` ( `id` int(11) NOT NULL AUTO_INCREMENT, `periodo` date NOT NULL, `holando` float NOT NULL, `cruza` float NOT NULL, `invernada` float NOT NULL, `hacienda1_1` float NOT NULL, `hacienda1_2` float NOT NULL, `hacienda2_1` float NOT NULL, `hacienda2_2` float NOT NULL, `hacienda3_1` float NOT NULL, `hacienda3_2` float NOT NULL, `hacienda4_1` float NOT NULL, `hacienda4_2` float NOT NULL, `hacienda5_1` float NOT NULL, `hacienda5_2` float NOT NULL, `hacienda6_1` float NOT NULL, `hacienda6_2` float NOT NULL, `hacienda7_1` float NOT NULL, `hacienda7_2` float NOT NULL, `hacienda8_1` float NOT NULL, `hacienda8_2` float NOT NULL, `hacienda9_1` float NOT NULL, `hacienda9_2` float NOT NULL, `hacienda10_1` float NOT NULL, `hacienda10_2` float NOT NULL, `hacienda11_1` float NOT NULL, `hacienda11_2` float NOT NULL, `hacienda12_1` float NOT NULL, `hacienda12_2` float NOT NULL, `hacienda13_1` float NOT NULL, `hacienda13_2` float NOT NULL, `hacienda14_1` float NOT NULL, `hacienda14_2` float NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `precios` -- LOCK TABLES `precios` WRITE; /*!40000 ALTER TABLE `precios` DISABLE KEYS */; INSERT INTO `precios` (`id`, `periodo`, `holando`, `cruza`, `invernada`, `hacienda1_1`, `hacienda1_2`, `hacienda2_1`, `hacienda2_2`, `hacienda3_1`, `hacienda3_2`, `hacienda4_1`, `hacienda4_2`, `hacienda5_1`, `hacienda5_2`, `hacienda6_1`, `hacienda6_2`, `hacienda7_1`, `hacienda7_2`, `hacienda8_1`, `hacienda8_2`, `hacienda9_1`, `hacienda9_2`, `hacienda10_1`, `hacienda10_2`, `hacienda11_1`, `hacienda11_2`, `hacienda12_1`, `hacienda12_2`, `hacienda13_1`, `hacienda13_2`, `hacienda14_1`, `hacienda14_2`) VALUES (5,'2025-08-01',2490,3025,3600,2000,2500,2200,2700,2600,3000,2100,2600,1400,1900,2200,2800,1900,2470,2800,3250,2300,2600,2500,3000,3300,4070,1600,2200,2500,4200,3100,3600),(7,'2025-07-01',2830,2330,3450,1950,2300,2000,2650,2600,3000,2000,2400,1400,1800,2100,2700,1800,2350,2700,3200,2200,2500,2400,2780,3200,3650,1600,2000,2300,3800,3000,3400),(8,'2025-06-01',2270,2750,3450,1800,2250,1900,2550,2000,2700,1800,2100,1100,1400,1850,2200,1450,2020,2600,3200,1800,2250,2300,2700,3000,3650,1450,1650,2300,3800,2700,3300),(9,'2025-05-01',2160,2630,3450,1700,2100,1900,2500,2000,2600,1750,2100,1050,1370,1850,2200,1450,2020,2600,3200,1750,2200,2100,2650,2900,3550,1450,1650,2300,3800,2500,3200),(10,'2025-04-01',2100,2580,3450,1700,2100,1900,2500,2000,2600,1750,2100,1050,1370,1850,2200,1450,2020,2600,3200,1750,2200,2000,2650,2900,3750,1450,1650,2300,3700,2500,3320),(11,'2025-03-01',2080,2550,3400,1700,2100,1900,2500,2000,2600,1750,2100,1000,1300,1850,2200,1300,1800,2600,3100,1700,2150,1900,2400,2700,3500,1500,1700,2300,3500,2500,3250),(12,'2025-02-01',2060,2490,3400,1700,2070,1800,2300,2000,2450,1750,2000,1100,1300,1850,2100,1300,1800,2600,3100,170,2250,1900,2480,2700,3500,1500,1700,2300,3500,2500,3250),(13,'2025-01-01',2000,2400,2950,1700,2070,1800,2300,2000,2450,1650,1900,1100,1350,1850,2030,1300,1800,2050,2600,1700,2200,1850,2250,2500,3200,1500,1650,2300,3500,2300,2900),(14,'2024-12-01',1900,2290,3250,1600,1980,1650,2200,1850,2250,1650,1900,1100,1300,1700,1900,1300,1900,1950,2350,1700,2150,1850,2300,2500,3450,1500,1650,2300,3500,2300,3000),(15,'2024-11-01',1840,2120,2550,1500,1950,1650,2150,1850,2200,1650,1850,1100,1400,1700,1900,1300,1900,1950,2350,1500,2070,1600,2100,2300,3200,1500,1650,2300,3500,2100,2600),(16,'2024-10-01',1700,1980,2350,1300,1700,1500,1910,1600,1950,1500,1750,1100,1380,1500,1800,1200,1750,1800,2020,1450,1650,1500,1870,2150,2670,1300,1550,1800,2600,1950,2350),(17,'2024-08-01',1720,1980,2150,1300,1700,1500,1900,1600,1950,1500,1750,1000,1350,1400,1800,1200,1650,1800,2100,1450,1650,1500,1950,1800,2370,1200,1500,1800,2350,1800,2200),(18,'2024-07-01',1700,1980,2200,1300,1700,1500,1910,1600,1950,1500,1750,1100,1300,1500,1800,1200,1750,1800,2150,1450,1650,1500,1870,1820,2670,1300,1550,1800,2600,1800,2350),(19,'2024-06-01',1570,1790,2000,1300,1660,1450,1720,1600,1900,1300,1500,850,1100,1400,1700,1200,1600,1800,2050,1450,1600,1400,1650,1820,2200,950,1150,1700,2100,1800,2000),(20,'2024-05-01',1440,1650,1900,1100,1370,1250,1400,1350,1550,1250,1450,650,850,1400,1650,1000,1450,1550,1980,1050,1250,1050,1380,1700,2100,900,1030,1600,2000,1600,1950),(21,'2024-04-01',1400,1630,1870,1100,1330,1250,1400,1350,1550,1250,1480,700,950,1400,1650,1000,1450,1550,1980,1050,1250,1050,1300,1700,1950,800,1070,1600,2000,1600,1900),(22,'2024-03-01',1400,1630,1870,1200,1430,1300,1500,1350,1550,1250,1480,700,900,1400,1670,1100,1400,1550,1980,1050,1280,1000,1250,1700,2030,800,1070,1600,2000,1600,1950),(23,'2024-02-01',1450,1680,1850,1200,1450,1300,1500,1350,1550,1300,1480,900,1180,1400,1670,1250,1500,1500,1800,1050,1280,1000,1250,1700,2030,900,1180,1600,2000,1550,1850),(24,'2024-01-01',1350,1570,1650,1200,1350,1300,1400,1350,1450,1300,1480,900,1180,1400,1670,1300,1500,1450,1800,1000,1050,900,1080,1600,1900,900,1180,1600,2000,1500,1700),(25,'2023-12-01',1240,1430,1580,950,1100,1100,1300,1150,1400,1100,1250,850,950,1200,1400,1000,1400,1200,1450,750,900,800,950,1300,1750,850,980,1300,1600,1200,1600),(26,'2024-09-01',1700,1980,2200,1300,1700,1500,1910,1600,1950,1500,1750,1100,1300,1500,1800,1200,1750,1800,2150,1450,1650,1500,1870,1820,2670,1300,1550,1800,2600,1800,2350),(27,'2025-09-01',2650,3240,4250,2000,2650,2300,2900,2600,3000,2300,2760,1700,2050,2400,2850,2000,2700,2800,3300,2300,2650,2600,3300,3500,4400,1800,2200,2500,4200,3400,3950),(28,'2025-10-01',2850,3350,4380,2600,2950,2700,3200,2800,3350,2600,3000,1800,2420,2800,3100,2500,2900,2800,3500,2900,3550,2950,3600,4000,4500,2300,2500,2500,4500,3600,4300),(29,'2025-11-01',3130,3710,5450,2600,3200,2900,3450,3000,3650,2800,3200,1800,2400,3000,3500,2500,3150,3500,4500,2900,3600,3400,4000,4400,5500,2400,2800,3000,4700,4000,5200),(30,'2025-12-01',3350,3960,5350,2600,3150,2900,3300,3000,3450,2700,3150,1800,2250,3000,3400,2600,3100,3600,4400,3000,3500,3600,4100,4400,5400,2500,2700,3000,4500,4000,5000),(31,'2026-01-01',3450,4120,5450,2600,3180,2900,3430,3000,3480,2700,3250,1800,2400,3000,3600,2500,3200,3700,4600,3000,3450,3600,4180,4400,6000,2500,3000,3000,4700,4300,5450),(32,'2026-02-01',3560,4350,6400,2800,3450,2900,3600,3000,3900,2900,3850,1800,2600,3000,4200,2500,3350,4200,5500,3300,4000,4100,4800,5000,6700,2500,3000,3000,4700,4500,6200),(33,'2026-03-01',3510,4290,6400,2800,3450,2900,3600,3000,3900,2900,3600,1800,2500,3000,4200,2500,3550,4000,5000,3300,4000,4100,5000,5000,6700,2500,3100,3000,4500,4500,6100),(34,'2026-04-01',3510,4290,6400,2800,3350,2800,3600,3000,3900,2900,3600,1800,2400,3000,4200,2500,3550,4000,5000,3300,4000,3800,4500,4800,6200,2500,3150,3000,4500,4500,6000),(35,'2026-05-01',3450,4230,6300,2800,3350,2800,3600,3000,3900,2800,3300,1800,2300,3000,4200,2500,3300,3800,4800,3300,4000,3800,4400,4800,6200,2400,2850,3000,4500,4500,6000); /*!40000 ALTER TABLE `precios` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `recursoshumanos` -- DROP TABLE IF EXISTS `recursoshumanos`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `recursoshumanos` ( `id` int(11) NOT NULL AUTO_INCREMENT, `tipo` int(11) NOT NULL, `descripcion` varchar(100) NOT NULL, `nombre` varchar(200) NOT NULL, `telefono` varchar(200) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `recursoshumanos` -- LOCK TABLES `recursoshumanos` WRITE; /*!40000 ALTER TABLE `recursoshumanos` DISABLE KEYS */; INSERT INTO `recursoshumanos` (`id`, `tipo`, `descripcion`, `nombre`, `telefono`) VALUES (1,1,'Presidente','Ricardo Ángel Trossero',''),(2,1,'Vicepresidente','Dr. Emilio Antonio Chatelet',''),(5,2,'Impuestos y Contabilidad','C.P. Agustina Alessiato',''),(6,2,'Impuestos y Contabilidad','Milagros Villarreal',''),(7,2,'Facturación','Susana Schreter',''),(8,2,'Facturación','Selene Racca',''),(9,2,'Cuentas Corrientes','Silvina Morandín',''),(10,2,'Cuentas Corrientes','Gustavo Poggi',''),(11,2,'Cuentas Corrientes','Javier Kuriger',''),(12,3,'Martillero','Roberto Apel',''),(13,3,'Comercialización','Alejandro Alessiato',''),(14,3,'Comercialización','Juan I. Perassi',''),(15,3,'Comercialización','Luis M. Miassi',''),(16,4,'Humboldt','Andrés Yennerich',''),(17,4,'Huanqueros','Timoteo Jokanovich - Jokan Jokanovich',''),(18,5,'Encargado','Alejandro Alessandrini',''),(19,5,'Personal de planta','Jose Ramón Niz',''); /*!40000 ALTER TABLE `recursoshumanos` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `remates` -- DROP TABLE IF EXISTS `remates`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `remates` ( `id` int(11) NOT NULL AUTO_INCREMENT, `fecha` date NOT NULL, `localidad` int(11) NOT NULL, `detalles` varchar(200) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=67 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `remates` -- LOCK TABLES `remates` WRITE; /*!40000 ALTER TABLE `remates` DISABLE KEYS */; INSERT INTO `remates` (`id`, `fecha`, `localidad`, `detalles`) VALUES (1,'2025-09-04',2,''),(2,'2025-09-05',3,''),(3,'2025-09-10',1,''),(4,'2025-09-16',3,''),(5,'2025-09-24',1,''),(9,'2025-09-30',2,'Gran Remate Aniversario 83 años Humboldt'),(11,'2025-08-05',2,''),(12,'2025-08-06',3,''),(13,'2025-08-13',1,''),(14,'2025-08-19',2,''),(15,'2025-08-27',1,''),(16,'2025-07-30',1,'Gran Remate Aniversario 105 años'),(17,'2025-07-22',2,''),(21,'2025-10-08',1,'Último antes de la vacunación'),(22,'2025-10-03',3,''),(23,'2025-10-14',2,' Faena '),(24,'2025-10-22',1,'Faena'),(25,'2025-10-28',2,'Abasto e Invernada'),(26,'2025-11-05',1,'Abasto e Invernada'),(27,'2025-11-07',3,'Abasto e Invernada'),(28,'2025-11-11',2,'Abasto e Invernada'),(29,'2025-11-19',1,'Abasto e Invernada'),(30,'2025-11-26',2,'Abasto e Invernada'),(31,'2025-12-05',3,'Abasto e Invernada'),(32,'2025-12-04',1,'Especial Fin de Año'),(33,'2025-12-10',2,'Especial Fin de Año'),(34,'2025-12-17',1,'Abasto e Invernada'),(35,'2026-01-06',2,'Abasto e Invernada'),(36,'2026-01-09',3,'Abasto e Invernada'),(37,'2026-01-14',1,'Abasto e Invernada'),(38,'2026-01-15',3,'Abasto e Invernada'),(39,'2026-01-20',2,'Abasto e Invernada'),(40,'2026-01-28',1,'Abasto e Invernada'),(41,'2026-02-06',3,'Abasto e Invernada'),(42,'2026-02-03',2,'Abasto e Invernada'),(43,'2026-02-11',1,'Abasto e Invernada'),(44,'2026-02-19',2,'Abasto e Invernada'),(45,'2026-02-25',1,'Abasto e Invernada '),(46,'2026-02-27',3,'Abasto e Invernada'),(47,'2026-02-23',2,'Remate de Abasto e Invernada'),(48,'2026-03-03',2,'SOLO FAENA'),(49,'2026-03-11',1,'SOLO FAENA'),(50,'2026-04-10',3,'Abasto e Invernada'),(51,'2026-03-17',2,'Abasto e Invernada'),(52,'2026-04-08',1,'Abasto e Invernada'),(53,'2026-04-14',2,'Abasto e Invernada'),(54,'2026-04-11',1,'Abasto e Invernada'),(55,'2026-04-22',1,'Abasto e Invernada'),(56,'2026-05-13',3,'Abasto e Invernada'),(57,'2026-04-28',2,'Abasto e Invernada'),(58,'2026-05-06',1,'Especial de Otoño Invernada y Abasto'),(59,'2026-05-12',2,'Abasto e Invernada'),(60,'2026-05-20',1,'Abasto e Invernada'),(61,'2026-05-27',2,'Abasto e Invernada'),(62,'2026-06-05',3,'Abasto e Invernada'),(63,'2026-06-03',1,'Abasto e Invernada'),(64,'2026-06-16',2,'Abasto e Invernada'),(65,'2026-06-17',1,'Abasto e Invernada'),(66,'2026-07-03',3,'Abasto e Invernada'); /*!40000 ALTER TABLE `remates` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `usuarios` -- DROP TABLE IF EXISTS `usuarios`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `usuarios` ( `id` int(11) NOT NULL AUTO_INCREMENT, `usuario` varchar(200) NOT NULL, `clave` varchar(200) NOT NULL, `nombre` varchar(200) NOT NULL, `estado` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `usuarios` -- LOCK TABLES `usuarios` WRITE; /*!40000 ALTER TABLE `usuarios` DISABLE KEYS */; INSERT INTO `usuarios` (`id`, `usuario`, `clave`, `nombre`, `estado`) VALUES (1,'hacendados','01081920','Administrador',0); /*!40000 ALTER TABLE `usuarios` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping routines for database 'hacendadosrafael_web' -- /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2026-06-19 21:24:32