-- phpMyAdmin SQL Dump
-- version 4.9.7
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Feb 14, 2023 at 06:38 PM
-- Server version: 5.7.23-23
-- PHP Version: 7.4.33

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: `kukuntal_technology`
--

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

--
-- Table structure for table `regions`
--

CREATE TABLE `regions` (
  `region_id` int(11) NOT NULL,
  `region_name_e` varchar(60) NOT NULL,
  `region_name_a` varchar(40) NOT NULL,
  `population` int(20) NOT NULL,
  `area` int(20) NOT NULL,
  `density` decimal(10,0) NOT NULL,
  `capital` varchar(15) NOT NULL,
  `map` varchar(255) NOT NULL,
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `regions`
--

INSERT INTO `regions` (`region_id`, `region_name_e`, `region_name_a`, `population`, `area`, `density`, `capital`, `map`, `timestamp`) VALUES
(1, 'Addis Ababa', '??? ???', 2, 527, '5', 'N/A', 'AddisAbaba.png', '2023-01-06 05:34:05'),
(2, 'Afar', '???', 1, 72, '20', 'Semera', 'Afar.png', '2023-01-06 06:45:54'),
(3, 'Amhara', '???', 17, 154, '111', 'Bahir Dar', 'Amhara.png', '2023-01-06 11:42:02'),
(4, 'Benishangul-Gumuz', '?????? ???', 670, 50, '13', 'Asosa', '', '2023-01-06 03:41:08'),
(5, 'Dire Dawa', '????', 341, 1, '219', 'N/A', '', '0000-00-00 00:00:00'),
(6, 'Gambela', '????', 306, 29, '10', 'Gambela', '', '2023-01-06 03:41:12'),
(7, 'Harari', '???', 183, 334, '549', 'Harar', '', '2023-01-06 03:41:16'),
(8, 'Oromia', '????', 27, 284, '95', 'Addis Ababa', '', '2023-01-06 03:41:19'),
(9, 'Sidama', '???', 0, 0, '0', 'Hawassa', '', '2023-01-06 03:41:23'),
(10, 'Somali', '???', 4, 279, '16', 'Jijiga', '', '2023-01-06 03:41:26'),
(11, 'South West', '??? ????', 0, 0, '0', 'Bonga', '', '2023-01-06 03:41:30'),
(12, 'Southern Nations, Nationalities, and People', '???', 15, 105, '142', 'Hawassa', '', '2023-01-06 03:42:38'),
(13, 'Tigray', '????', 4, 41, '104', 'Mek\'ele', '', '2023-01-06 03:41:48'),
(14, 'Ethiopia', '', 0, 0, '0', '', '', '2023-01-06 04:11:06');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `regions`
--
ALTER TABLE `regions`
  ADD PRIMARY KEY (`region_id`);

--
-- AUTO_INCREMENT for dumped tables
--

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