-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `restapi`
--

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

--
-- Table structure for table `aws_tatasteel_jsr`
--

CREATE TABLE `aws_tatasteel_jsr` (
  `id` bigint(16) NOT NULL,
  `TMPmax` float DEFAULT NULL,
  `TMPavg` float DEFAULT NULL,
  `TMPmin` float DEFAULT NULL,
  `RHmax` float DEFAULT NULL,
  `RHavg` float DEFAULT NULL,
  `RHmin` float DEFAULT NULL,
  `WSmax` float DEFAULT NULL,
  `WSmin` float DEFAULT NULL,
  `WSavg` float DEFAULT NULL,
  `BPavg` float DEFAULT NULL,
  `SOLARavg` float DEFAULT NULL,
  `RAINavg` float DEFAULT NULL,
  `Battery` float DEFAULT NULL,
  `WD` float DEFAULT NULL,
  `CreationDate` timestamp NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `aws_tatasteel_jsr`
--

INSERT INTO `aws_tatasteel_jsr` (`id`, `TMPmax`, `TMPavg`, `TMPmin`, `RHmax`, `RHavg`, `RHmin`, `WSmax`, `WSmin`, `WSavg`, `BPavg`, `SOLARavg`, `RAINavg`, `Battery`, `WD`, `CreationDate`) VALUES
(8092125060561716, 27.6, 27.4, 27.3, 63, 62.6, 62.5, 26.4, 0, 12.2, NULL, NULL, 0, 13.7, 208.7, '2022-02-09 20:25:00'),
(7589486613690775, 32.3, 32.1, 31.8, 32.3, 31.7, 31.2, 7.2, 0, 2.2, 0.4, 223.4, 0, 343.5, 981.2, '2022-12-08 14:10:00'),
(8844007044702029, 32.3, 32.2, 31.8, 32.4, 31.8, 31.2, 7.2, 0, 2.3, 0.2, 224.4, 0, 342.5, 980.2, '2022-12-09 15:10:00'),
(8380282861016422, 32.3, 32.1, 31.8, 32.3, 31.7, 31.2, 7.2, 0, 2.2, 0.4, 223.4, 14.1, 343.5, 981.2, '2022-12-10 14:10:00'),
(2298851856974895, 32.3, 32.2, 31.8, 32.4, 31.8, 31.2, 7.2, 0, 2.3, 0.2, 224.4, 0, 342.5, 980.2, '2022-12-10 15:10:00'),
(4796341704066250, 87.8, 87.8, 87.8, 0, -3.9, -4, 0, 0, 0, 741.2, 3.7, 0, 12, 0, '2022-12-17 10:36:38'),
(9151164010622869, 87.8, 87.8, 87.8, 0, -3.9, -4, 0, 0, 0, 741.3, 2.4, 0, 12, 0, '2022-12-17 10:37:38'),
(8502670713112628, 87.8, 87.8, 87.8, 0, -3.9, -4, 0, 0, 0, 738.9, 0, 0, 12.4, 0, '2022-12-17 13:45:20'),
(7915030672750597, 87.8, 87.8, 87.8, 0, -4, -4, 0, 0, 0, 738.5, 0, 0, 12.4, 0, '2022-12-17 13:49:20'),
(5076173376024917, 87.8, 87.8, 87.8, 0, -4, -4, 0, 0, 0, 738.4, 0, 0, 12.3, 0, '2022-12-17 13:53:20'),
(4385895487596029, 87.8, 87.8, 87.8, 0, -3.9, -4, 0, 0, 0, 738.6, 0, 0, 12.3, 0, '2022-12-17 13:57:20'),
(2283850495265559, 87.8, 87.8, 87.8, 0, -4, -4, 0, 0, 0, 738.2, 0, 0, 12.2, 0, '2022-12-17 14:05:20'),
(7976613908766665, 87.8, 87.8, 87.8, 0, -4, -4, 11.7, 1.8, 6.2, 738.4, 0, 0, 12.2, 353.7, '2022-12-17 14:15:53'),
(1024428257024293, 87.8, 87.8, 0, 0, -4, -4, 192.6, 0, 4.9, 738.1, 280.1, 0, 12.3, 344.5, '2022-12-17 14:19:57'),
(8692342571612061, 87.8, 87.8, 87.8, 0, -3.9, -4, 9.9, 1.8, 5.3, 737.9, 267.9, 0, 13.7, 343.8, '2022-12-17 14:24:37'),
(8644389458957314, 87.8, 87.8, 87.8, 0, -3.9, -4, 11.7, 1.8, 4.8, 737.6, 265.4, 0, 13.8, 347.6, '2022-12-17 14:28:37'),
(1263182379304341, 87.8, 87.8, 87.8, 0, -3.9, -4, 9, 2.7, 5.4, 737.9, 243, 0, 13.9, 339.8, '2022-12-17 14:36:37'),
(8311254680341740, 87.8, 87.8, 87.8, 0, -4, -4, 5.4, 0, 1.5, 737.6, 233.5, 0, 13.9, 350.2, '2022-12-17 14:40:37'),
(1470922411584201, 87.8, 87.8, 87.8, 0, -4, -4, 0, 0, 0, 737.6, 221.1, 0, 13.9, 0, '2022-12-17 14:44:37'),
(4230620729030724, 87.8, 87.8, 87.8, 0, -3.9, -4, 9, 2.7, 4.8, 737.4, 207.3, 0, 13.9, 339.7, '2022-12-17 14:48:37');
COMMIT;

