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

START TRANSACTION;



--
-- Database: `uum_net_project`
--

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

--
-- Table structure for table `test_results`
--

CREATE TABLE `test_results` (
  `id` int(11) NOT NULL,
  `matric_no` varchar(6) DEFAULT NULL,
  `latitude` varchar(50) DEFAULT NULL,
  `longitude` varchar(50) DEFAULT NULL,
  `network_type` varchar(20) DEFAULT NULL,
  `telco_provider` varchar(50) NOT NULL,
  `ping_ms` int(11) DEFAULT NULL,
  `download_speed` float DEFAULT NULL,
  `upload_speed` float DEFAULT NULL,
  `test_date` date DEFAULT NULL,
  `test_time` time DEFAULT NULL,
  `signal_dbm` int(11) DEFAULT 0,
  `location_name` varchar(255) DEFAULT 'Unknown Area'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `test_results`
--

INSERT INTO `test_results` (`id`, `matric_no`, `latitude`, `longitude`, `network_type`, `telco_provider`, `ping_ms`, `download_speed`, `upload_speed`, `test_date`, `test_time`, `signal_dbm`, `location_name`) VALUES
(1, '300994', '6.441343098799784', '100.52761802302578', 'Unknown (iOS/Privacy', 'Maxis', 971, 0.43, 3.64, '2026-01-05', '15:56:54', 0, 'Unknown Area'),
(2, '299449', '6.4414737', '100.5280294', '4g', 'U Mobile', 235, 6.78, 3.09, '2026-01-05', '16:01:08', 0, 'Unknown Area'),
(3, '300994', '6.4412288', '100.5275506', '4g', 'Maxis', 310, 7.17, 1.34, '2026-01-05', '16:57:18', 0, 'Unknown Area'),
(4, '300994', '6.4412288', '100.5275506', '4g', 'Maxis', 407, 8.32, 3.49, '2026-01-05', '17:15:15', -999, 'Unknown Area'),
(5, '300994', '6.4412288', '100.5275506', '4g', 'Maxis', 100, 14.91, 2.76, '2026-01-05', '17:15:57', -999, 'Unknown Area'),
(6, '300994', '6.4412288', '100.5275506', '4g', 'Maxis', 84, 6.68, 3.4, '2026-01-05', '17:17:25', -999, 'Unknown Area'),
(7, '300994', '6.4412288', '100.5275506', '4g', 'Maxis', 318, 6.93, 3.23, '2026-01-05', '17:22:56', -44, 'Unknown Area'),
(8, '300994', '6.4412288', '100.5275506', '4g', 'Maxis', 354, 4.96, 2.36, '2026-01-05', '17:36:01', -25, 'Unknown Area'),
(9, '300994', '6.4412134', '100.5275452', 'Mobile/WiFi', 'UUM WiFi', 450, 3.81, 3.2, '2026-01-06', '00:16:08', -85, 'Unknown Area'),
(10, '300994', '6.4412009', '100.5275496', 'Mobile/WiFi', 'Maxis', 361, 4.39, 30.84, '2026-01-06', '01:11:15', -43, 'Unknown Area'),
(11, '300994', '6.4412334', '100.5275323', 'Mobile/WiFi', 'Maxis', 203, 2.9, 45.22, '2026-01-06', '01:25:37', -43, 'Unknown Area'),
(13, '300994', '6.4411961', '100.5275589', 'WiFi', 'Maxis', 373, 3.44, 72.32, '2026-01-06', '03:04:24', -45, 'Unknown Area'),
(14, '300994', '6.4674825', '100.5071474', 'WiFi', 'UUM WiFi', 370, 4.55, 4.16, '2026-01-06', '13:05:20', -65, 'Unknown Area'),
(15, '300994', '6.481158', '100.5098185', 'WiFi', 'Maxis', 232, 4.65, 84.31, '2026-01-06', '15:31:54', -40, 'Unknown Area'),
(16, '300994', '6.4811631', '100.5098214', 'WiFi', 'Maxis', 259, 4.83, 58.87, '2026-01-06', '15:52:15', -40, 'Unknown Area'),
(17, '300994', '6.481166', '100.5098196', 'WiFi', 'Maxis', 435, 2.5, 58.05, '2026-01-06', '15:56:47', -40, 'Unknown Area'),
(18, '300994', '6.481166', '100.5098252', 'WiFi', 'Maxis', 383, 1.78, 36.16, '2026-01-06', '16:19:19', -57, 'Unknown Area'),
(19, '300994', '6.4811448', '100.5098059', 'WiFi', 'UUM WiFi', 366, 1.57, 76.61, '2026-01-06', '16:20:33', -57, 'Unknown Area'),
(20, '300994', '6.4811657', '100.5098286', 'WiFi', 'UUM WiFi', 397, 2.03, 72.94, '2026-01-06', '16:24:35', -57, 'Unknown Area'),
(21, '300994', '6.4811667', '100.5098231', 'WiFi', 'Maxis', 281, 2.87, 43.13, '2026-01-06', '16:25:45', -57, 'Unknown Area'),
(22, '300994', '6.4811678', '100.5098222', 'WiFi', 'Maxis', 351, 1.38, 35.32, '2026-01-06', '16:27:52', -57, 'Unknown Area'),
(23, '300994', '6.4811537', '100.5098105', 'WiFi', 'Maxis', 352, 1.71, 42.91, '2026-01-06', '16:35:52', -48, 'Unknown Area'),
(24, '300994', '6.4811686', '100.5098203', 'WiFi', 'UUM WiFi', 251, 3.27, 45.96, '2026-01-06', '16:38:29', -48, 'Unknown Area'),
(25, '300994', '6.4811693', '100.5098235', 'WiFi', 'Maxis', 437, 1.3, 65.28, '2026-01-06', '16:41:50', -48, 'Changlun');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `test_results`
--
ALTER TABLE `test_results`
  ADD PRIMARY KEY (`id`),
  ADD KEY `matric_no` (`matric_no`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `test_results`
--
ALTER TABLE `test_results`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=26;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `test_results`
--
ALTER TABLE `test_results`
  ADD CONSTRAINT `test_results_ibfk_1` FOREIGN KEY (`matric_no`) REFERENCES `users` (`matric_no`);
COMMIT;

