-- phpMyAdmin SQL Dump
-- version 4.9.0.1
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Dec 19, 2019 at 11:44 AM
-- Server version: 5.6.45
-- PHP Version: 7.3.6

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
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_db1`
--

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

--
-- Table structure for table `mars`
--

CREATE TABLE `mars` (
  `sno` int(11) NOT NULL,
  `date1` date DEFAULT NULL,
  `time1` varchar(8) DEFAULT NULL,
  `date2` date DEFAULT NULL,
  `time2` varchar(8) DEFAULT NULL,
  `sign` varchar(100) DEFAULT NULL,
  `station` varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `mars`
--

INSERT INTO `mars` (`sno`, `date1`, `time1`, `date2`, `time2`, `sign`, `station`) VALUES
(1258, '2001-05-11', '02:04PM', '2001-07-19', '09:22PM', 'Sagittarius', 'SR'),
(1259, '2001-07-19', '09:23PM', '2003-07-29', '08:32AM', 'Sagittarius', 'SD'),
(1260, '2003-07-29', '08:33AM', '2003-09-27', '07:05AM', 'Pisces', 'SR'),
(1261, '2003-09-27', '07:06AM', '2005-10-01', '10:42PM', 'Pisces', 'SD'),
(1262, '2005-10-01', '10:43PM', '2005-12-10', '05:32AM', 'Taurus', 'SR'),
(1263, '2005-12-10', '05:33AM', '2007-11-15', '09:19AM', 'Taurus', 'SD'),
(1264, '2007-11-15', '09:20AM', '2008-01-30', '10:03PM', 'Cancer', 'SR'),
(1265, '2008-01-30', '10:04PM', '2009-12-20', '02:04PM', 'Gemini', 'SD'),
(1266, '2009-12-20', '02:05PM', '2010-03-10', '04:17PM', 'Leo', 'SR'),
(1267, '2010-03-10', '04:18PM', '2012-01-24', '01:21AM', 'Leo', 'SD'),
(1268, '2012-01-24', '01:22AM', '2012-04-14', '03:02AM', 'Virgo', 'SR'),
(1269, '2012-04-14', '03:03AM', '2014-03-01', '05:09PM', 'Virgo', 'SD'),
(1270, '2014-03-01', '05:10PM', '2014-05-20', '00:59AM', 'Libra', 'SR'),
(1271, '2014-05-20', '01:00AM', '2016-04-17', '12:22PM', 'Libra', 'SD'),
(1272, '2016-04-17', '12:23PM', '2016-06-29', '10:18PM', 'Sagittarius', 'SR'),
(1273, '2016-06-29', '10:19PM', '2018-06-26', '08:07PM', 'Scorpio', 'SD'),
(1274, '2018-06-26', '08:08PM', '2018-08-27', '02:51PM', 'Aquarius', 'SR'),
(1275, '2018-08-27', '02:52PM', '2020-09-09', '09:32PM', 'Capricorn', 'SD'),
(1276, '2020-09-09', '09:33PM', '2020-11-13', '11:06PM', 'Aries', 'SR'),
(1277, '2020-11-13', '11:07PM', '2022-10-30', '02:22PM', 'Aries', 'SD'),
(1278, '2022-10-30', '02:23PM', '2023-01-12', '08:29PM', 'Gemini', 'SR'),
(1279, '2023-01-12', '08:30PM', '2024-12-07', '00:20AM', 'Gemini', 'SD'),
(1280, '2024-12-07', '00:21AM', '2025-02-24', '01:05AM', 'Leo', 'SR'),
(1281, '2025-02-24', '01:06AM', '2027-01-10', '01:38PM', 'Cancer', 'SD'),
(1282, '2027-01-10', '01:39PM', '2027-04-01', '01:14PM', 'Virgo', 'SR'),
(1283, '2027-04-01', '01:15PM', '2029-02-14', '08:44AM', 'Leo', 'SD'),
(1284, '2029-02-14', '08:45AM', '2029-05-05', '06:04PM', 'Libra', 'SR'),
(1285, '2029-05-05', '06:05PM', '2031-03-29', '01:15AM', 'Virgo', 'SD'),
(1286, '2031-03-29', '01:16AM', '2031-06-13', '10:46AM', 'Scorpio', 'SR'),
(1287, '2031-06-13', '10:47AM', '2033-05-27', '00:24AM', 'Scorpio', 'SD'),
(1288, '2033-05-27', '00:25AM', '2033-08-01', '02:49PM', 'Capricorn', 'SR'),
(1289, '2033-08-01', '02:50PM', '2035-08-15', '09:50AM', 'Sagittarius', 'SD'),
(1290, '2035-08-15', '09:51AM', '2035-10-15', '10:12AM', 'Pisces', 'SR'),
(1291, '2035-10-15', '10:13AM', '2037-10-13', '00:26AM', 'Pisces', 'SD'),
(1292, '2037-10-13', '00:27AM', '2037-12-23', '07:14AM', 'Gemini', 'SR'),
(1293, '2037-12-23', '07:15AM', '2039-11-23', '09:25PM', 'Taurus', 'SD'),
(1294, '2039-11-23', '09:26PM', '2040-02-09', '10:44AM', 'Cancer', 'SR'),
(1295, '2040-02-09', '10:45AM', '2041-12-28', '06:26AM', 'Cancer', 'SD'),
(1296, '2041-12-28', '06:27AM', '2042-03-18', '06:48PM', 'Leo', 'SR'),
(1297, '2042-03-18', '06:49PM', '2044-01-31', '11:54PM', 'Leo', 'SD'),
(1298, '2044-01-31', '11:55PM', '2044-04-21', '10:44PM', 'Libra', 'SR'),
(1299, '2044-04-21', '10:45PM', '2046-03-11', '02:56AM', 'Virgo', 'SD'),
(1300, '2046-03-11', '02:57AM', '2046-05-28', '02:34PM', 'Scorpio', 'SR'),
(1301, '2046-05-28', '02:35PM', '2048-04-30', '02:48PM', 'Libra', 'SD'),
(1302, '2048-04-30', '02:49PM', '2048-07-10', '09:33PM', 'Sagittarius', 'SR'),
(1303, '2048-07-10', '09:34PM', '2050-07-15', '05:50AM', 'Sagittarius', 'SD'),
(1304, '2050-07-15', '05:51AM', '2050-09-13', '09:41AM', 'Aquarius', 'SR'),
(1305, '2050-09-13', '09:42AM', '2052-09-22', '08:10PM', 'Aquarius', 'SD'),
(1306, '2052-09-22', '08:11PM', '2052-11-29', '07:36AM', 'Taurus', 'SR'),
(1307, '2052-11-29', '07:37AM', '2054-11-08', '07:12PM', 'Aries', 'SD'),
(1308, '2054-11-08', '07:13PM', '2055-01-23', '09:20AM', 'Cancer', 'SR'),
(1309, '2055-01-23', '09:21AM', '2056-12-14', '08:42PM', 'Gemini', 'SD'),
(1310, '2056-12-14', '08:43PM', '2057-03-04', '12:47PM', 'Leo', 'SR'),
(1311, '2057-03-04', '12:48PM', '2059-01-18', '06:44AM', 'Cancer', 'SD'),
(1312, '2059-01-18', '06:45AM', '2059-04-09', '08:44AM', 'Virgo', 'SR'),
(1313, '2059-04-09', '08:45AM', '2061-02-22', '11:38PM', 'Leo', 'SD'),
(1314, '2061-02-22', '11:39PM', '2061-05-13', '08:36PM', 'Libra', 'SR'),
(1315, '2061-05-13', '08:37PM', '2063-04-09', '06:23AM', 'Libra', 'SD'),
(1316, '2063-04-09', '06:24AM', '2063-06-23', '03:29AM', 'Sagittarius', 'SR'),
(1317, '2063-06-23', '03:30AM', '2065-06-12', '08:42PM', 'Scorpio', 'SD'),
(1318, '2065-06-12', '08:43PM', '2065-08-15', '03:59PM', 'Capricorn', 'SR'),
(1319, '2065-08-15', '04:00PM', '2067-08-30', '11:14PM', 'Capricorn', 'SD'),
(1320, '2067-08-30', '11:15PM', '2067-11-02', '01:30AM', 'Aries', 'SR'),
(1321, '2067-11-02', '01:31AM', '2069-10-23', '07:04AM', 'Aries', 'SD'),
(1322, '2069-10-23', '07:05AM', '2070-01-04', '07:33AM', 'Gemini', 'SR'),
(1323, '2070-01-04', '07:34AM', '2071-12-02', '01:51AM', 'Gemini', 'SD'),
(1324, '2071-12-02', '01:52AM', '2072-02-18', '12:04PM', 'Leo', 'SR'),
(1325, '2072-02-18', '12:05PM', '2074-01-04', '09:37PM', 'Cancer', 'SD'),
(1326, '2074-01-04', '09:38PM', '2074-03-26', '05:24PM', 'Virgo', 'SR'),
(1327, '2074-03-26', '05:25PM', '2076-02-09', '02:59AM', 'Leo', 'SD'),
(1328, '2076-02-09', '03:00AM', '2076-04-29', '07:51PM', 'Libra', 'SR'),
(1329, '2076-04-29', '07:52PM', '2078-03-21', '01:13AM', 'Virgo', 'SD'),
(1330, '2078-03-21', '01:14AM', '2078-06-06', '11:38AM', 'Scorpio', 'SR'),
(1331, '2078-06-06', '11:39AM', '2080-05-14', '10:07PM', 'Libra', 'SD'),
(1332, '2080-05-14', '10:08PM', '2080-07-22', '05:39PM', 'Capricorn', 'SR'),
(1333, '2080-07-22', '05:40PM', '2082-08-02', '05:21AM', 'Sagittarius', 'SD'),
(1334, '2082-08-02', '05:22AM', '2082-10-01', '05:57AM', 'Pisces', 'SR'),
(1335, '2082-10-01', '05:58AM', '2084-10-04', '04:00PM', 'Pisces', 'SD'),
(1336, '2084-10-04', '04:01PM', '2084-12-13', '08:25AM', 'Taurus', 'SR'),
(1337, '2084-12-13', '08:26AM', '2086-11-17', '02:10PM', 'Taurus', 'SD'),
(1338, '2086-11-17', '02:11PM', '2087-02-02', '08:00AM', 'Canser', 'SR'),
(1339, '2087-02-02', '08:01AM', '2088-12-22', '02:28PM', 'Gemini', 'SD'),
(1340, '2088-12-22', '02:29PM', '2089-03-12', '06:57PM', 'Leo', 'SR'),
(1341, '2089-03-12', '06:58PM', '2091-01-26', '02:20AM', 'Leo', 'SD'),
(1342, '2091-01-26', '02:21AM', '2091-04-17', '03:52AM', 'Virgo', 'SR'),
(1343, '2091-04-17', '03:53AM', '2093-03-04', '00:24AM', 'Virgo', 'SD'),
(1344, '2093-03-04', '00:25AM', '2093-05-22', '04:50AM', 'Scorpio', 'SR'),
(1345, '2093-05-22', '04:51AM', '2095-04-21', '11:27AM', 'Libra', 'SD'),
(1346, '2095-04-21', '11:28AM', '2095-07-03', '12:06PM', 'Sagittarius', 'SR'),
(1347, '2095-07-03', '12:07PM', '2097-06-30', '08:54PM', 'Scorpio', 'SD'),
(1348, '2097-06-30', '08:55PM', '2099-08-31', '05:52AM', 'Aquarius', 'SR'),
(1349, '2099-08-31', '05:53AM', '2099-09-13', '11:52PM', 'Aquarius', 'SD'),
(1350, '2099-09-13', '11:53PM', '2099-11-18', '12:41PM', 'Taurus', 'SR');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `mars`
--
ALTER TABLE `mars`
  ADD PRIMARY KEY (`sno`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `mars`
--
ALTER TABLE `mars`
  MODIFY `sno` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1351;
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 */;
