-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Sep 09, 2025 at 02:43 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_db1`
--

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

--
-- Table structure for table `time_zone`
--

CREATE TABLE `time_zone` (
  `zone_name` varchar(35) NOT NULL,
  `country_code` char(2) NOT NULL,
  `abbreviation` varchar(6) NOT NULL,
  `time_start` decimal(11,0) NOT NULL,
  `gmt_offset` int(11) NOT NULL,
  `dst` char(1) NOT NULL,
  `lat` decimal(10,6) DEFAULT NULL,
  `lng` decimal(11,6) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `time_zone`
--

INSERT INTO `time_zone` (`zone_name`, `country_code`, `abbreviation`, `time_start`, `gmt_offset`, `dst`, `lat`, `lng`) VALUES
('Africa/Abidjan', 'CI', 'LMT', -1830383033, -968, '0', 5.309657, -4.012656),
('Africa/Abidjan', 'CI', 'GMT', -1830383032, 0, '0', 5.309657, -4.012656),
('Africa/Accra', 'GH', 'LMT', -1830383033, -968, '0', NULL, NULL),
('Africa/Accra', 'GH', 'GMT', -1830383032, 0, '0', NULL, NULL),
('Africa/Addis_Ababa', 'ET', 'LMT', -1946168837, 8836, '0', 32.905943, 101.706251),
('Africa/Addis_Ababa', 'ET', 'EAT', -1946168836, 9000, '0', 32.905943, 101.706251),
('Africa/Addis_Ababa', 'ET', 'EAT', -1309746600, 10800, '0', 32.905943, 101.706251),
('Africa/Addis_Ababa', 'ET', 'EAT', -1261969200, 9000, '0', 32.905943, 101.706251),
('Africa/Addis_Ababa', 'ET', 'EAT', -1041388200, 9900, '0', 32.905943, 101.706251),
('Africa/Addis_Ababa', 'ET', 'EAT', -865305900, 10800, '0', 32.905943, 101.706251),
('Africa/Algiers', 'DZ', 'LMT', -2486592733, 732, '0', 36.763056, 3.050556),
('Africa/Algiers', 'DZ', 'PMT', -2486592732, 561, '0', 36.763056, 3.050556),
('Africa/Algiers', 'DZ', 'WET', -1855958961, 0, '0', 36.763056, 3.050556),
('Africa/Algiers', 'DZ', 'WEST', -1689814800, 3600, '1', 36.763056, 3.050556),
('Africa/Algiers', 'DZ', 'WET', -1680397200, 0, '0', 36.763056, 3.050556),
('Africa/Algiers', 'DZ', 'WEST', -1665363600, 3600, '1', 36.763056, 3.050556),
('Africa/Algiers', 'DZ', 'WET', -1648342800, 0, '0', 36.763056, 3.050556),
('Africa/Algiers', 'DZ', 'WEST', -1635123600, 3600, '1', 36.763056, 3.050556),
('Africa/Algiers', 'DZ', 'WET', -1616893200, 0, '0', 36.763056, 3.050556),
('Africa/Algiers', 'DZ', 'WEST', -1604278800, 3600, '1', 36.763056, 3.050556),
('Africa/Algiers', 'DZ', 'WET', -1585443600, 0, '0', 36.763056, 3.050556),
('Africa/Algiers', 'DZ', 'WEST', -1574038800, 3600, '1', 36.763056, 3.050556),
('Africa/Algiers', 'DZ', 'WET', -1552266000, 0, '0', 36.763056, 3.050556),
('Africa/Algiers', 'DZ', 'WEST', -1539997200, 3600, '1', 36.763056, 3.050556),
('Africa/Algiers', 'DZ', 'WET', -1531443600, 0, '0', 36.763056, 3.050556);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `time_zone`
--
ALTER TABLE `time_zone`
  ADD KEY `idx_zone_name` (`zone_name`),
  ADD KEY `idx_country_code` (`country_code`),
  ADD KEY `idx_time_start` (`time_start`);
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 */;
