Skip to content

Instantly share code, notes, and snippets.

@kiramishima

kiramishima/agricultor_io.sql

Created October 11, 2022 00:13
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save kiramishima/951c58de79b760e621b38068a8d96762 to your computer and use it in GitHub Desktop.
Save kiramishima/951c58de79b760e621b38068a8d96762 to your computer and use it in GitHub Desktop.
Download ZIP
Base de datos Agricultor
Raw
agricultor_io.sql
-- MariaDB dump 10.19 Distrib 10.9.2-MariaDB, for Win64 (AMD64)
--
-- Host: localhost Database: agricultor.io
-- ------------------------------------------------------
-- Server version 10.9.2-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 `fertilizer_compositions`
--
DROP TABLE IF EXISTS `fertilizer_compositions`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `fertilizer_compositions` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`composition_name` varchar(60) NOT NULL,
`composition_description` varchar(250) DEFAULT NULL,
`created_at` timestamp NOT NULL DEFAULT current_timestamp(),
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `fertilizer_compositions`
--
LOCK TABLES `fertilizer_compositions` WRITE;
/*!40000 ALTER TABLE `fertilizer_compositions` DISABLE KEYS */;
INSERT INTO `fertilizer_compositions` VALUES
(1,'Urea',NULL,'2022-10-09 23:17:56',NULL,NULL),
(2,'Nitrato de amonio',NULL,'2022-10-09 23:17:56',NULL,NULL),
(3,'Sulfato de amonio',NULL,'2022-10-09 23:17:56',NULL,NULL),
(4,'Nitrato de calcio',NULL,'2022-10-09 23:17:56',NULL,NULL),
(5,'Nitrato de sodio',NULL,'2022-10-09 23:17:56',NULL,NULL),
(6,'Superfosfato',NULL,'2022-10-09 23:17:56',NULL,NULL),
(7,'Superfosfato triple',NULL,'2022-10-09 23:17:56',NULL,NULL),
(8,'Cloruro de potasio',NULL,'2022-10-09 23:17:56',NULL,NULL),
(9,'Nitrato de potasio',NULL,'2022-10-09 23:17:56',NULL,NULL),
(10,'Fosfato diamónico',NULL,'2022-10-09 23:17:56',NULL,NULL);
/*!40000 ALTER TABLE `fertilizer_compositions` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `fertilizer_types`
--
DROP TABLE IF EXISTS `fertilizer_types`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `fertilizer_types` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`fertilizer_type_name` varchar(60) NOT NULL,
`fertilizer_type_description` varchar(250) DEFAULT NULL,
`created_at` timestamp NOT NULL DEFAULT current_timestamp(),
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `fertilizer_types`
--
LOCK TABLES `fertilizer_types` WRITE;
/*!40000 ALTER TABLE `fertilizer_types` DISABLE KEYS */;
INSERT INTO `fertilizer_types` VALUES
(1,'Orgánico',NULL,'2022-10-09 23:08:47',NULL,NULL),
(2,'Quimico',NULL,'2022-10-09 23:08:47',NULL,NULL),
(3,'Radicular',NULL,'2022-10-09 23:08:47',NULL,NULL),
(4,'Foliar',NULL,'2022-10-09 23:08:47',NULL,NULL),
(5,'Fertirrigación',NULL,'2022-10-09 23:08:47',NULL,NULL),
(6,'Inorgánico',NULL,'2022-10-09 23:08:47',NULL,NULL),
(7,'Absorción lenta',NULL,'2022-10-09 23:08:47',NULL,NULL),
(8,'Absorción rápida',NULL,'2022-10-09 23:08:47',NULL,NULL),
(9,'Sólidos',NULL,'2022-10-09 23:08:47',NULL,NULL),
(10,'Líquidos',NULL,'2022-10-09 23:08:47',NULL,NULL);
/*!40000 ALTER TABLE `fertilizer_types` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `fertilizers`
--
DROP TABLE IF EXISTS `fertilizers`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `fertilizers` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`fertilizer_type_id` int(11) NOT NULL,
`fertilizer_composition_id` int(11) NOT NULL,
`fertilizer_name` varchar(60) NOT NULL,
`fertilizer_description` varchar(250) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `fk_fertilizers_fertilizer_types1_idx` (`fertilizer_type_id`),
KEY `fk_fertilizers_fertilizer_compositions1_idx` (`fertilizer_composition_id`),
CONSTRAINT `fk_fertilizers_fertilizer_compositions1` FOREIGN KEY (`fertilizer_composition_id`) REFERENCES `fertilizer_compositions` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
CONSTRAINT `fk_fertilizers_fertilizer_types1` FOREIGN KEY (`fertilizer_type_id`) REFERENCES `fertilizer_types` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `fertilizers`
--
LOCK TABLES `fertilizers` WRITE;
/*!40000 ALTER TABLE `fertilizers` DISABLE KEYS */;
INSERT INTO `fertilizers` VALUES
(1,1,1,'Abono natural de Borrego',NULL),
(2,10,6,'Fertilizante liquido',NULL),
(3,10,7,'Multiagro',NULL),
(4,1,6,'Humus de lombriz',NULL),
(5,1,7,'Super Abono natural de Borrego',NULL),
(6,10,7,'Fertilizante de Nutrientes',NULL),
(7,9,9,'Fertilizante Biozometicos',NULL),
(8,2,7,'Humid Acid',NULL),
(9,2,1,'Green Boost',NULL),
(10,2,10,'Humic NK+',NULL);
/*!40000 ALTER TABLE `fertilizers` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `harvests`
--
DROP TABLE IF EXISTS `harvests`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `harvests` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`provider_seed_id` int(11) NOT NULL,
`provider_fertilizer_id` int(11) DEFAULT NULL,
`season_id` int(11) NOT NULL,
`terrain_id` int(11) NOT NULL,
`seed_quantity` int(11) NOT NULL DEFAULT 0,
`water_type_id` int(11) NOT NULL,
`lts_water_used` decimal(12,2) NOT NULL,
`dt_start` date NOT NULL,
`dt_end` date DEFAULT NULL,
`created_at` timestamp NOT NULL DEFAULT current_timestamp(),
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `fk_harvests_providers_seeds1_idx` (`provider_seed_id`),
KEY `fk_harvests_providers_fertilizers1_idx` (`provider_fertilizer_id`),
KEY `fk_harvests_water_types1_idx` (`water_type_id`),
KEY `fk_harvests_terrains1_idx` (`terrain_id`),
KEY `fk_harvests_seasons1_idx` (`season_id`),
CONSTRAINT `fk_harvests_providers_fertilizers1` FOREIGN KEY (`provider_fertilizer_id`) REFERENCES `providers_fertilizers` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
CONSTRAINT `fk_harvests_providers_seeds1` FOREIGN KEY (`provider_seed_id`) REFERENCES `providers_seeds` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
CONSTRAINT `fk_harvests_seasons1` FOREIGN KEY (`season_id`) REFERENCES `seasons` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
CONSTRAINT `fk_harvests_terrains1` FOREIGN KEY (`terrain_id`) REFERENCES `terrains` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
CONSTRAINT `fk_harvests_water_types1` FOREIGN KEY (`water_type_id`) REFERENCES `water_types` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `harvests`
--
LOCK TABLES `harvests` WRITE;
/*!40000 ALTER TABLE `harvests` DISABLE KEYS */;
INSERT INTO `harvests` VALUES
(1,1,NULL,1,1,3,9,100.00,'2022-10-09','2022-11-18','2022-10-10 02:55:07',NULL,NULL),
(2,1,1,2,2,3,9,200.00,'2022-10-09','2022-12-08','2022-10-10 02:55:07',NULL,NULL),
(3,2,NULL,3,3,3,9,100.00,'2022-10-09','2023-04-07','2022-10-10 02:55:07',NULL,NULL),
(4,2,2,4,4,3,9,100.00,'2022-10-09','2022-12-28','2022-10-10 02:55:07',NULL,NULL),
(5,3,3,5,5,3,9,100.00,'2022-10-09','2023-01-07','2022-10-10 02:55:07',NULL,NULL),
(6,3,NULL,6,6,3,9,100.00,'2022-10-09','2022-12-08','2022-10-10 02:55:07',NULL,NULL),
(7,4,4,7,7,3,9,100.00,'2022-10-09','2022-12-08','2022-10-10 02:55:07',NULL,NULL),
(8,4,NULL,8,8,3,9,100.00,'2022-10-09','2022-11-28','2022-10-10 02:55:07',NULL,NULL),
(9,5,NULL,9,9,3,9,100.00,'2022-10-09','2023-02-06','2022-10-10 02:55:07',NULL,NULL),
(10,5,5,10,10,3,9,100.00,'2022-10-09','2023-01-17','2022-10-10 02:55:07',NULL,NULL),
(11,1,NULL,1,1,3,9,100.00,'2021-10-09','2021-11-18','2022-10-10 03:48:00',NULL,NULL),
(12,1,1,2,2,3,9,200.00,'2021-10-09','2021-12-08','2022-10-10 03:48:00',NULL,NULL),
(13,2,NULL,3,3,3,9,100.00,'2021-10-09','2022-04-07','2022-10-10 03:48:00',NULL,NULL),
(14,2,2,4,4,3,9,100.00,'2021-10-09','2021-12-28','2022-10-10 03:48:00',NULL,NULL),
(15,3,3,5,5,3,9,100.00,'2021-10-09','2022-01-07','2022-10-10 03:48:00',NULL,NULL),
(16,3,NULL,6,6,3,9,100.00,'2021-10-09','2021-12-08','2022-10-10 03:48:00',NULL,NULL),
(17,4,4,7,7,3,9,100.00,'2021-10-09','2021-12-08','2022-10-10 03:48:00',NULL,NULL),
(18,4,NULL,8,8,3,9,100.00,'2021-10-09','2021-11-28','2022-10-10 03:48:00',NULL,NULL),
(19,5,NULL,9,9,3,9,100.00,'2021-10-09','2022-02-06','2022-10-10 03:48:00',NULL,NULL),
(20,5,5,10,10,3,9,100.00,'2021-10-09','2022-01-17','2022-10-10 03:48:00',NULL,NULL),
(21,1,NULL,1,1,3,9,100.00,'2020-10-09','2020-11-18','2022-10-10 03:49:50',NULL,NULL),
(22,1,1,2,2,3,9,200.00,'2020-10-09','2020-12-08','2022-10-10 03:49:50',NULL,NULL),
(23,2,NULL,3,3,3,9,100.00,'2020-10-09','2021-04-07','2022-10-10 03:49:50',NULL,NULL),
(24,2,2,4,4,3,9,100.00,'2020-10-09','2020-12-28','2022-10-10 03:49:50',NULL,NULL),
(25,3,3,5,5,3,9,100.00,'2020-10-09','2021-01-07','2022-10-10 03:49:50',NULL,NULL),
(26,3,NULL,6,6,3,9,100.00,'2020-10-09','2020-12-08','2022-10-10 03:49:50',NULL,NULL),
(27,4,4,7,7,3,9,100.00,'2020-10-09','2020-12-08','2022-10-10 03:49:50',NULL,NULL),
(28,4,NULL,8,8,3,9,100.00,'2020-10-09','2020-11-28','2022-10-10 03:49:50',NULL,NULL),
(29,5,NULL,9,9,3,9,100.00,'2020-10-09','2021-02-06','2022-10-10 03:49:50',NULL,NULL),
(30,5,5,10,10,3,9,100.00,'2020-10-09','2021-01-17','2022-10-10 03:49:50',NULL,NULL);
/*!40000 ALTER TABLE `harvests` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `providers`
--
DROP TABLE IF EXISTS `providers`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `providers` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`provider_name` varchar(60) NOT NULL,
`provider_phone` char(15) DEFAULT NULL,
`provider_address` varchar(250) DEFAULT NULL,
`created_at` timestamp NOT NULL DEFAULT current_timestamp(),
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `providers`
--
LOCK TABLES `providers` WRITE;
/*!40000 ALTER TABLE `providers` DISABLE KEYS */;
INSERT INTO `providers` VALUES
(1,'SAKATA','(33) 3897-0776','Av. Vallarta #6503 Local B-10, Ciudad Granja, 45010, Zapopan, Jalisco México','2022-10-09 22:48:27',NULL,NULL),
(2,'AL NATURAL','(55) 5863-8078','Torres Adalid Nº 1957 Col. Narvarte Poniente Alcaldia Benito Juarez Ciudad de México','2022-10-09 22:48:27',NULL,NULL),
(3,'BALL AKIKO','(55) 5532-5660,','Calzada de la Viga 1354. Col. El Sifón, Del. Iztapalapa. C.P. 09400. México, D.F.','2022-10-09 22:48:27',NULL,NULL),
(4,'LA MOLINERA','(55) 5600-7070','Central de Abastos Pasillo 2, Loc. 132, 134 y 136 Col. Ejidos del Moral Deleg. Iztapalapa C.P. 09040','2022-10-09 22:48:27',NULL,NULL),
(5,'SEMILLAS CASA COBO','(55) 5694-0949','Central de Abastos, Sección de Abarrotes Bodega A91, Iztapalapa, 09040 Ciudad de México, CDMX','2022-10-09 22:48:27',NULL,NULL),
(6,'AGROGEN','(44) 2238-0000','Carr. a Tlacote El Bajo km. 5.5, 76000 Santiago de Querétaro, Qro.','2022-10-09 22:48:27',NULL,NULL),
(7,'SGS','(55) 5387-2100','Volcán 150, Piso 5, Col. Lomas de Chapultepec Tercera Sección, Alcaldía Miguel Hidalgo, Ciudad de México, 11000 México','2022-10-09 22:48:27',NULL,NULL),
(8,'FERTIMAX','(23) 1312-2130','Privada Flores Magón S/N, Centro, 73800, Teziutlán, Pue.','2022-10-09 22:48:27',NULL,NULL),
(9,'AGRICHEM','(66) 9180-3371',NULL,'2022-10-09 22:48:27',NULL,NULL),
(10,'COSMOCEL','(81) 8625-3100','Vía Matamoros No.1501 Fracc. Industrial Nogalar San Nicolás de los Garza, Nuevo León, México','2022-10-09 22:48:27',NULL,NULL),
(31,'SAKILA','(55) 7949-0619','Av. Vallarta #6503 Local B-10, Ciudad Granja, 45010, Zapopan, Jalisco México','2022-10-10 20:35:15','2022-10-10 20:52:36',NULL);
/*!40000 ALTER TABLE `providers` ENABLE KEYS */;
UNLOCK TABLES;
/*!50003 SET @saved_cs_client = @@character_set_client */ ;
/*!50003 SET @saved_cs_results = @@character_set_results */ ;
/*!50003 SET @saved_col_connection = @@collation_connection */ ;
/*!50003 SET character_set_client = utf8mb4 */ ;
/*!50003 SET character_set_results = utf8mb4 */ ;
/*!50003 SET collation_connection = utf8mb4_general_ci */ ;
/*!50003 SET @saved_sql_mode = @@sql_mode */ ;
/*!50003 SET sql_mode = 'STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ ;
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 TRIGGER `providers_before_create`
BEFORE INSERT
ON `providers` FOR EACH ROW
BEGIN
IF new.provider_phone = '' || new.provider_phone IS NULL THEN
SET new.provider_phone = '(00) 0000-0000';
END IF;
END */;;
DELIMITER ;
/*!50003 SET sql_mode = @saved_sql_mode */ ;
/*!50003 SET character_set_client = @saved_cs_client */ ;
/*!50003 SET character_set_results = @saved_cs_results */ ;
/*!50003 SET collation_connection = @saved_col_connection */ ;
/*!50003 SET @saved_cs_client = @@character_set_client */ ;
/*!50003 SET @saved_cs_results = @@character_set_results */ ;
/*!50003 SET @saved_col_connection = @@collation_connection */ ;
/*!50003 SET character_set_client = utf8mb4 */ ;
/*!50003 SET character_set_results = utf8mb4 */ ;
/*!50003 SET collation_connection = utf8mb4_general_ci */ ;
/*!50003 SET @saved_sql_mode = @@sql_mode */ ;
/*!50003 SET sql_mode = 'STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ ;
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 TRIGGER `providers_before_update_record`
BEFORE UPDATE
ON `providers` FOR EACH ROW
BEGIN
SET new.updated_at = NOW();
END */;;
DELIMITER ;
/*!50003 SET sql_mode = @saved_sql_mode */ ;
/*!50003 SET character_set_client = @saved_cs_client */ ;
/*!50003 SET character_set_results = @saved_cs_results */ ;
/*!50003 SET collation_connection = @saved_col_connection */ ;
/*!50003 SET @saved_cs_client = @@character_set_client */ ;
/*!50003 SET @saved_cs_results = @@character_set_results */ ;
/*!50003 SET @saved_col_connection = @@collation_connection */ ;
/*!50003 SET character_set_client = utf8mb4 */ ;
/*!50003 SET character_set_results = utf8mb4 */ ;
/*!50003 SET collation_connection = utf8mb4_general_ci */ ;
/*!50003 SET @saved_sql_mode = @@sql_mode */ ;
/*!50003 SET sql_mode = 'STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ ;
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 TRIGGER `providers_before_delete_record`
BEFORE DELETE
ON `providers` FOR EACH ROW
BEGIN
SIGNAL SQLSTATE '45000'
SET MESSAGE_TEXT = 'No se puede eliminar el registro, solo un delete logico';
END */;;
DELIMITER ;
/*!50003 SET sql_mode = @saved_sql_mode */ ;
/*!50003 SET character_set_client = @saved_cs_client */ ;
/*!50003 SET character_set_results = @saved_cs_results */ ;
/*!50003 SET collation_connection = @saved_col_connection */ ;
--
-- Table structure for table `providers_fertilizers`
--
DROP TABLE IF EXISTS `providers_fertilizers`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `providers_fertilizers` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`provider_id` int(11) NOT NULL,
`fertilizer_id` int(11) NOT NULL,
`price` decimal(10,2) NOT NULL DEFAULT 0.00,
`status` tinyint(4) NOT NULL DEFAULT 0,
`created_at` timestamp NOT NULL DEFAULT current_timestamp(),
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `fk_providers_fertilizers_providers1_idx` (`provider_id`),
KEY `fk_providers_fertilizers_fertilizers1_idx` (`fertilizer_id`),
CONSTRAINT `fk_providers_fertilizers_fertilizers1` FOREIGN KEY (`fertilizer_id`) REFERENCES `fertilizers` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
CONSTRAINT `fk_providers_fertilizers_providers1` FOREIGN KEY (`provider_id`) REFERENCES `providers` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `providers_fertilizers`
--
LOCK TABLES `providers_fertilizers` WRITE;
/*!40000 ALTER TABLE `providers_fertilizers` DISABLE KEYS */;
INSERT INTO `providers_fertilizers` VALUES
(1,6,1,1749.00,1,'2022-10-10 00:00:04',NULL,NULL),
(2,6,2,1249.00,1,'2022-10-10 00:00:04',NULL,NULL),
(3,7,3,725.00,1,'2022-10-10 00:00:04',NULL,NULL),
(4,7,4,399.00,1,'2022-10-10 00:00:04',NULL,NULL),
(5,8,5,1899.00,1,'2022-10-10 00:00:04',NULL,NULL),
(6,8,6,1599.00,1,'2022-10-10 00:00:04',NULL,NULL),
(7,9,7,3099.00,1,'2022-10-10 00:00:04',NULL,NULL),
(8,9,8,3799.00,1,'2022-10-10 00:00:04',NULL,NULL),
(9,10,9,1199.00,1,'2022-10-10 00:00:04',NULL,NULL),
(10,10,10,1299.00,1,'2022-10-10 00:00:04',NULL,NULL);
/*!40000 ALTER TABLE `providers_fertilizers` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `providers_seeds`
--
DROP TABLE IF EXISTS `providers_seeds`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `providers_seeds` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`provider_id` int(11) NOT NULL,
`seed_id` int(11) NOT NULL,
`price` decimal(10,2) NOT NULL DEFAULT 0.00,
`status` tinyint(4) NOT NULL DEFAULT 0,
`created_at` timestamp NOT NULL DEFAULT current_timestamp(),
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `fk_providers_seeds_seeds1_idx` (`seed_id`),
KEY `fk_providers_seeds_providers1_idx` (`provider_id`),
CONSTRAINT `fk_providers_seeds_providers1` FOREIGN KEY (`provider_id`) REFERENCES `providers` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
CONSTRAINT `fk_providers_seeds_seeds1` FOREIGN KEY (`seed_id`) REFERENCES `seeds` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `providers_seeds`
--
LOCK TABLES `providers_seeds` WRITE;
/*!40000 ALTER TABLE `providers_seeds` DISABLE KEYS */;
INSERT INTO `providers_seeds` VALUES
(1,1,1,15.50,1,'2022-10-09 23:37:32',NULL,NULL),
(2,1,2,12.50,1,'2022-10-09 23:37:32',NULL,NULL),
(3,2,3,25.78,1,'2022-10-09 23:37:32',NULL,NULL),
(4,2,4,30.00,1,'2022-10-09 23:37:32',NULL,NULL),
(5,3,5,18.00,1,'2022-10-09 23:37:32',NULL,NULL),
(6,3,6,15.00,1,'2022-10-09 23:37:32',NULL,NULL),
(7,4,7,30.50,1,'2022-10-09 23:37:32',NULL,NULL),
(8,4,8,37.00,1,'2022-10-09 23:37:32',NULL,NULL),
(9,5,9,11.50,1,'2022-10-09 23:37:32',NULL,NULL),
(10,5,10,12.50,1,'2022-10-09 23:37:32',NULL,NULL);
/*!40000 ALTER TABLE `providers_seeds` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `seasons`
--
DROP TABLE IF EXISTS `seasons`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `seasons` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`season_name` varchar(60) NOT NULL,
`season_description` varchar(200) DEFAULT NULL,
`created_at` timestamp NOT NULL DEFAULT current_timestamp(),
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `seasons`
--
LOCK TABLES `seasons` WRITE;
/*!40000 ALTER TABLE `seasons` DISABLE KEYS */;
INSERT INTO `seasons` VALUES
(1,'Todo el año',NULL,'2022-10-10 01:44:24',NULL,NULL),
(2,'Primavera',NULL,'2022-10-10 01:44:24',NULL,NULL),
(3,'Verano',NULL,'2022-10-10 01:44:24',NULL,NULL),
(4,'Otoño',NULL,'2022-10-10 01:44:24',NULL,NULL),
(5,'Invierno',NULL,'2022-10-10 01:44:24',NULL,NULL),
(6,'Primavera-Verano',NULL,'2022-10-10 01:44:24',NULL,NULL),
(7,'Verano-Otoño',NULL,'2022-10-10 01:44:24',NULL,NULL),
(8,'Otoño-Invierno',NULL,'2022-10-10 01:44:24',NULL,NULL),
(9,'Primavera-Verano-Otoño',NULL,'2022-10-10 01:44:24',NULL,NULL),
(10,'Verano-Otoño-Invierno',NULL,'2022-10-10 01:44:24',NULL,NULL);
/*!40000 ALTER TABLE `seasons` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `seed_types`
--
DROP TABLE IF EXISTS `seed_types`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `seed_types` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`seed_type_name` varchar(60) NOT NULL,
`seed_type_description` varchar(250) DEFAULT NULL,
`created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `seed_types`
--
LOCK TABLES `seed_types` WRITE;
/*!40000 ALTER TABLE `seed_types` DISABLE KEYS */;
INSERT INTO `seed_types` VALUES
(1,'Baby','Han sido tratadas para detener su desarrollo.','2022-10-09 22:08:18',NULL,NULL),
(2,'Híbridas','Estas semillas tienen muchas ventajas, como es el hecho de que puedan fructificar de forma óptima en condiciones climáticas de todo tipo, sean ambientes cálidos, fríos, secos, etc.','2022-10-09 22:08:18',NULL,NULL),
(3,'Hortalizas',NULL,'2022-10-09 22:08:18',NULL,NULL),
(4,'Flores','Semillas de flores.','2022-10-09 22:08:18',NULL,NULL),
(5,'Frutas','Semillas que generan plantas o arboles frutales.','2022-10-09 22:08:18',NULL,NULL),
(6,'Comestibles','Semillas para su consumo humano directamente.','2022-10-09 22:08:18',NULL,NULL),
(7,'Criollas','Semillas adaptadas a nuestro entorno por un proceso de selección natural o manual de parte de los productores.','2022-10-09 22:08:18',NULL,NULL),
(8,'Mejoradas','Semillas cuya característica es haber sido seleccionadas con la ayuda del hombre, mediante métodos más específicos (polinización controlada).','2022-10-09 22:08:18',NULL,NULL),
(9,'Cereal','Contienen una cantidad sustancial de almidón, un carbohidrato que proporciona energía dietética.','2022-10-09 22:08:18',NULL,NULL),
(10,'Pseudocereales','Semillas con almidón de familias de plantas de hoja ancha','2022-10-09 22:08:18',NULL,NULL);
/*!40000 ALTER TABLE `seed_types` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `seeds`
--
DROP TABLE IF EXISTS `seeds`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `seeds` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`seed_type_id` int(11) NOT NULL,
`seed_name` varchar(60) NOT NULL,
`seed_description` varchar(250) DEFAULT NULL,
`created_at` timestamp NOT NULL DEFAULT current_timestamp(),
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `fk_seeds_seed_types_idx` (`seed_type_id`),
CONSTRAINT `fk_seeds_seed_types` FOREIGN KEY (`seed_type_id`) REFERENCES `seed_types` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `seeds`
--
LOCK TABLES `seeds` WRITE;
/*!40000 ALTER TABLE `seeds` DISABLE KEYS */;
INSERT INTO `seeds` VALUES
(1,3,'Acelga',NULL,'2022-10-09 22:21:44',NULL,NULL),
(2,3,'Brócoli',NULL,'2022-10-09 22:21:44',NULL,NULL),
(3,3,'Cebolla blanca',NULL,'2022-10-09 22:21:44',NULL,NULL),
(4,3,'Cebolla morada',NULL,'2022-10-09 22:21:44',NULL,NULL),
(5,5,'Manzana',NULL,'2022-10-09 22:21:44',NULL,NULL),
(6,5,'Pera',NULL,'2022-10-09 22:21:44',NULL,NULL),
(7,5,'Mango',NULL,'2022-10-09 22:21:44',NULL,NULL),
(8,4,'Girasol',NULL,'2022-10-09 22:21:44',NULL,NULL),
(9,4,'Celosía',NULL,'2022-10-09 22:21:44',NULL,NULL),
(10,4,'Geranios hardy',NULL,'2022-10-09 22:21:44',NULL,NULL);
/*!40000 ALTER TABLE `seeds` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `terrain_types`
--
DROP TABLE IF EXISTS `terrain_types`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `terrain_types` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`terrain_type_name` varchar(60) NOT NULL,
`terrain_type_description` varchar(200) DEFAULT NULL,
`created_at` timestamp NOT NULL DEFAULT current_timestamp(),
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `terrain_types`
--
LOCK TABLES `terrain_types` WRITE;
/*!40000 ALTER TABLE `terrain_types` DISABLE KEYS */;
INSERT INTO `terrain_types` VALUES
(1,'Alfisoles','Arcilloso','2022-10-10 00:24:17',NULL,NULL),
(2,'Andisoles','Situado en la cordillera de los Andes','2022-10-10 00:24:17',NULL,NULL),
(3,'Aridisoles','Arido','2022-10-10 00:24:17',NULL,NULL),
(4,'Entisoles','Ubicado en valles fluviales','2022-10-10 00:24:17',NULL,NULL),
(5,'Gelisoles','Ubicados en zonas de hielo','2022-10-10 00:24:17',NULL,NULL),
(6,'Histosoles','Suelos pantanosos','2022-10-10 00:24:17',NULL,NULL),
(7,'Inceptisoles','Ubicado cerca de zonas boscosas','2022-10-10 00:24:17',NULL,NULL),
(8,'Molisoles','Super fertil','2022-10-10 00:24:17',NULL,NULL),
(9,'Oxisoles','De color rojo debido al oxido de hierro','2022-10-10 00:24:17',NULL,NULL),
(10,'Spodosoles','Es demasiado ácido','2022-10-10 00:24:17',NULL,NULL);
/*!40000 ALTER TABLE `terrain_types` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `terrains`
--
DROP TABLE IF EXISTS `terrains`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `terrains` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`terrain_label` varchar(60) DEFAULT NULL,
`terrain_type_id` int(11) NOT NULL,
`terrain_size` decimal(12,2) NOT NULL DEFAULT 0.00,
`terrain_location` point DEFAULT NULL,
`terrain_geometry` geometry DEFAULT NULL,
`created_at` timestamp NOT NULL DEFAULT current_timestamp(),
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `fk_terrains_terrain_types1_idx` (`terrain_type_id`),
CONSTRAINT `fk_terrains_terrain_types1` FOREIGN KEY (`terrain_type_id`) REFERENCES `terrain_types` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `terrains`
--
LOCK TABLES `terrains` WRITE;
/*!40000 ALTER TABLE `terrains` DISABLE KEYS */;
INSERT INTO `terrains` VALUES
(1,'Terreno A',8,2.50,NULL,NULL,'2022-10-10 01:31:01',NULL,NULL),
(2,'Terreno B',8,1.50,NULL,NULL,'2022-10-10 01:31:01',NULL,NULL),
(3,'Terreno C',8,0.50,NULL,NULL,'2022-10-10 01:31:01',NULL,NULL),
(4,'Terreno D',8,1.00,NULL,NULL,'2022-10-10 01:31:01',NULL,NULL),
(5,'Terreno E',8,2.75,NULL,NULL,'2022-10-10 01:31:01',NULL,NULL),
(6,'Terreno F',7,2.00,NULL,NULL,'2022-10-10 01:31:01',NULL,NULL),
(7,'Terreno G',7,3.00,NULL,NULL,'2022-10-10 01:31:01',NULL,NULL),
(8,'Terreno H',7,4.00,NULL,NULL,'2022-10-10 01:31:01',NULL,NULL),
(9,'Terreno I',7,10.00,NULL,NULL,'2022-10-10 01:31:01',NULL,NULL),
(10,'Terreno J',7,15.00,NULL,NULL,'2022-10-10 01:31:01',NULL,NULL);
/*!40000 ALTER TABLE `terrains` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `water_types`
--
DROP TABLE IF EXISTS `water_types`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `water_types` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`water_type_name` varchar(60) NOT NULL,
`created_at` timestamp NOT NULL DEFAULT current_timestamp(),
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `water_types`
--
LOCK TABLES `water_types` WRITE;
/*!40000 ALTER TABLE `water_types` DISABLE KEYS */;
INSERT INTO `water_types` VALUES
(1,'Sólida','2022-10-10 00:10:53',NULL,NULL),
(2,'Dulce','2022-10-10 00:10:53',NULL,NULL),
(3,'Potable','2022-10-10 00:10:53',NULL,NULL),
(4,'Alcalina','2022-10-10 00:10:53',NULL,NULL),
(5,'Destilada','2022-10-10 00:10:53',NULL,NULL),
(6,'Residual','2022-10-10 00:10:53',NULL,NULL),
(7,'Salada','2022-10-10 00:10:53',NULL,NULL),
(8,'Mineral','2022-10-10 00:10:53',NULL,NULL),
(9,'Subterranea','2022-10-10 00:10:53',NULL,NULL),
(10,'Lluvia','2022-10-10 00:10:53',NULL,NULL);
/*!40000 ALTER TABLE `water_types` ENABLE KEYS */;
UNLOCK TABLES;
/*!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 2022-10-10 19:11:20
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment