-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Sep 09, 2025 at 02:42 PM
-- Server version: 10.6.19-MariaDB
-- PHP Version: 8.1.33

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!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 */;

--
-- Database: `findyour_db2`
--

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

--
-- Table structure for table `asteroids`
--

CREATE TABLE `asteroids` (
  `full_name` varchar(50) NOT NULL,
  `e` double NOT NULL,
  `q` double NOT NULL,
  `i` double NOT NULL,
  `om` double NOT NULL,
  `w` double NOT NULL,
  `ad` double DEFAULT NULL,
  `tp_cal` varchar(20) DEFAULT NULL,
  `per_y` double DEFAULT NULL,
  `class` varchar(20) DEFAULT NULL,
  `data_arc` int(11) DEFAULT NULL,
  `condition_code` varchar(10) DEFAULT NULL,
  `n_obs_used` int(11) DEFAULT NULL,
  `two_body` varchar(50) DEFAULT NULL,
  `A1` double DEFAULT NULL,
  `A2` double DEFAULT NULL,
  `A3` double DEFAULT NULL,
  `DT` varchar(50) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `asteroids`
--

INSERT INTO `asteroids` (`full_name`, `e`, `q`, `i`, `om`, `w`, `ad`, `tp_cal`, `per_y`, `class`, `data_arc`, `condition_code`, `n_obs_used`, `two_body`, `A1`, `A2`, `A3`, `DT`) VALUES
('full_name', 0, 0, 0, 0, 0, 0, 'tp_cal', 0, 'class', 0, 'condition_', 0, 'two_body', 0, 0, 0, 'DT'),
('Pallas (A802 FA)', 0.2305, 2.132, 34.92, 172.9, 310.91, 3.41, '2023-03-07.3', 4.61, 'MBA', 80605, '0.0', 9744, '', 0, 0, 0, ''),
('Juno (A804 RA)', 0.2559, 1.987, 12.99, 169.83, 247.86, 3.35, '2023-04-02.3', 4.36, 'MBA', 80636, '0.0', 8325, '', 0, 0, 0, ''),
('Vesta (A807 FA)', 0.0901, 2.149, 7.14, 103.7, 151.58, 2.57, '2025-08-14.4', 3.63, 'MBA', 25743, '0.0', 9451, '', 0, 0, 0, ''),
('Astraea (A845 XA)', 0.1874, 2.094, 5.36, 141.45, 359.32, 3.06, '2024-05-08.0', 4.14, 'MBA', 65587, '0.0', 4268, '', 0, 0, 0, ''),
('Hebe (A847 NA)', 0.2023, 1.935, 14.74, 138.61, 239.67, 2.92, '2025-12-19.4', 3.78, 'MBA', 64264, '0.0', 6734, '', 0, 0, 0, ''),
('Iris (A847 PA)', 0.23, 1.838, 5.52, 259.5, 145.53, 2.94, '2025-04-04.1', 3.69, 'MBA', 64432, '0.0', 5895, '', 0, 0, 0, ''),
('Flora (A847 UA)', 0.1565, 1.857, 5.89, 110.85, 285.42, 2.55, '2024-01-31.9', 3.27, 'MBA', 64917, '0.0', 3560, '', 0, 0, 0, ''),
('Metis (A848 HA)', 0.1226, 2.094, 5.58, 68.87, 5.86, 2.68, '2023-11-06.7', 3.69, 'MBA', 64278, '0.0', 3662, '', 0, 0, 0, ''),
('Hygiea (A849 GA)', 0.1096, 2.799, 3.83, 283.13, 312.71, 3.49, '2028-02-09.6', 5.57, 'MBA', 64155, '0.0', 5126, '', 0, 0, 0, ''),
('Parthenope (A850 JA)', 0.0998, 2.209, 4.63, 125.47, 196.37, 2.7, '2024-01-13.2', 3.85, 'MBA', 63753, '0.0', 10498, '', 0, 0, 0, ''),
('Victoria (A850 RA)', 0.22, 1.82, 8.37, 235.35, 69.54, 2.85, '2025-02-15.6', 3.57, 'MBA', 63848, '0.0', 4291, '', 0, 0, 0, ''),
('Egeria (A850 VA)', 0.085, 2.358, 16.53, 43.19, 79.09, 2.8, '2025-06-02.1', 4.14, 'MBA', 63731, '0.0', 3794, '', 0, 0, 0, ''),
('Irene (A851 KA)', 0.1627, 2.167, 9.13, 86.01, 98.22, 3.01, '2025-09-27.2', 4.16, 'MBA', 63559, '0.0', 3687, '', 0, 0, 0, ''),
('Eunomia (A851 OA)', 0.1877, 2.147, 11.76, 292.88, 98.63, 3.14, '2024-07-13.7', 4.3, 'MBA', 63416, '0.0', 5291, '', 0, 0, 0, ''),
('Psyche (A852 FA)', 0.1341, 2.53, 3.1, 150.02, 229.64, 3.31, '2025-04-28.5', 5, 'MBA', 14782, '0.0', 7401, '', 0, 0, 0, ''),
('Thetis (A852 HA)', 0.132, 2.145, 5.59, 125.52, 135.78, 2.8, '2023-10-22.8', 3.88, 'MBA', 63125, '0.0', 11354, '', 0, 0, 0, ''),
('Melpomene (A852 MA)', 0.2181, 1.795, 10.13, 150.33, 228.06, 2.8, '2023-09-11.2', 3.48, 'MBA', 63195, '0.0', 6724, '', 0, 0, 0, ''),
('Fortuna (A852 QA)', 0.1579, 2.057, 1.57, 211.03, 182.65, 2.83, '2024-11-12.7', 3.82, 'MBA', 63026, '0.0', 9500, '', 0, 0, 0, ''),
('Massalia (A852 SA)', 0.1439, 2.062, 0.71, 205.98, 257.34, 2.76, '2025-07-30.5', 3.74, 'MBA', 61484, '0.0', 10255, '', 0, 0, 0, '');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `asteroids`
--
ALTER TABLE `asteroids`
  ADD PRIMARY KEY (`full_name`);
COMMIT;

/*!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 */;
