CREATE DATABASE  IF NOT EXISTS `iot_irrigation_controller_dev` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci */ /*!80016 DEFAULT ENCRYPTION='N' */;
USE `iot_irrigation_controller_dev`;
--
-- Host: localhost    Database: iot_irrigation_controller_dev
-- ------------------------------------------------------


--
-- Dumping data for table `controllers`
--

INSERT INTO `controllers` VALUES (1,'9002449','v1.0.1','2024-12-23 11:32:26'),(2,'922573','v1.1.0','2024-12-23 11:32:26'),(3,'6746570','v2.0.0','2024-12-23 11:32:26');

--
-- Dumping data for table `firmware`
--

INSERT INTO `firmware` VALUES (1,'v1.0.0','2023-01-01','https://example.com/firmware/v1.0.0','2024-12-23 11:33:46'),(2,'v1.1.0','2023-06-01','https://example.com/firmware/v1.1.0','2024-12-23 11:33:46'),(3,'v2.0.0','2023-12-01','https://example.com/firmware/v2.0.0','2024-12-23 11:33:46'),(5,'v2.0.1','2023-12-01','https://example.com/firmware/v1.0.0','2024-12-23 12:32:43');

--
-- Dumping data for table `logs`
--

INSERT INTO `logs` VALUES (1,1,1,'ON','2023-12-01 08:00:00'),(2,1,2,'OFF','2023-12-01 10:00:00'),(3,2,1,'ON','2023-12-01 12:00:00'),(4,1,1,'ON','2023-12-01 08:00:00');

--
-- Dumping data for table `orders`
--

INSERT INTO `orders` VALUES (1,1,1,'2024-12-23 11:34:12'),(2,1,2,'2024-12-23 11:34:12'),(3,2,3,'2024-12-23 11:34:12');

--
-- Dumping data for table `products`
--

INSERT INTO `products` VALUES (1,'Smart Controller','A high-tech controller with advanced features',199.99,'2024-12-23 11:34:05'),(2,'Relay Module','A reliable relay module for automation',49.99,'2024-12-23 11:34:05'),(3,'Sensor Kit','A complete sensor kit for all environments',99.99,'2024-12-23 11:34:05'),(4,'Smart Controller','High-tech controller',199.99,'2024-12-23 12:34:11'),(5,'Smart Controller','High-tech controller',199.99,'2024-12-23 12:34:26');

--
-- Dumping data for table `relays`
--

INSERT INTO `relays` VALUES (1,1,1,'{\"mode\": \"auto\"}'),(2,1,2,'{\"mode\": \"manual\"}'),(3,2,1,'{\"mode\": \"auto\"}');

--
-- Dumping data for table `schedules`
--

INSERT INTO `schedules` VALUES (1,1,'08:00:00','10:00:00','Daily'),(2,2,'12:00:00','14:00:00','Weekdays'),(3,3,'18:00:00','20:00:00','Weekends');

--
-- Dumping data for table `sensordatalogs`
--

INSERT INTO `sensordatalogs` VALUES (1,1,'2023-12-01 08:00:00','{\"temperature\": \"22.5\"}'),(2,2,'2023-12-01 08:10:00','{\"humidity\": \"55\"}'),(3,3,'2023-12-01 08:20:00','{\"pressure\": \"101.3\"}');

--
-- Dumping data for table `sensors`
--

INSERT INTO `sensors` VALUES (1,1,'Temperature','SN123TEMP','Temp Sensor 1','2024-12-23 11:33:20'),(2,2,'Humidity','SN456HUMID','Humidity Sensor 1','2024-12-23 11:33:20'),(3,3,'Pressure','SN789PRESS','Pressure Sensor 1','2024-12-23 11:33:20');

--
-- Dumping data for table `usercontrollers`
--

INSERT INTO `usercontrollers` VALUES (29,1,'BOX Irrigation Controller'),(29,2,'PCB Irrigation Controller Sagar'),(30,3,'New PCB');

--
-- Dumping data for table `users`
--

INSERT INTO `users` VALUES (1,'testuser1@example.com','password123','2024-12-23 11:31:54'),(2,'testuser2@example.com','securepass456','2024-12-23 11:31:54'),(3,'testuser3@example.com','mypassword789','2024-12-23 11:31:54'),(7,'testuser@example.com','securepassword123','2024-12-23 11:59:36'),(29,'web712@gmail.com','1234','2024-12-26 13:36:01'),(30,'ghansham712@gmail.com','1234','2024-12-27 09:19:39'),(31,'gagnani.ghansham@gmail.com','1234','2024-12-27 19:07:38'),(32,'ggg@gg.gg','1234','2024-12-28 02:39:33');

--
-- Dumping data for table `usersensors`
--

INSERT INTO `usersensors` VALUES (1,1,1),(2,2,2);

--
-- Dumping events for database 'iot_irrigation_controller_dev'
--

--
-- Dumping routines for database 'iot_irrigation_controller_dev'
--


