xodivorce/isdowndetectordown
1
1
Fork 0
mirror of https://github.com/xodivorce/isdowndetectordown.git synced 2025-12-19 21:43:02 +05:30
Code Issues Wiki Activity
Files
main
isdowndetectordown/schema/isdowndetectordown.sql

135 lines
7.6 KiB
SQL
Raw Permalink Blame History

-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: localhost
-- Generation Time: Nov 21, 2025 at 10:08 AM
-- Server version: 10.4.28-MariaDB
-- PHP Version: 8.2.4
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: `isdowndetectordown`
--
-- --------------------------------------------------------
--
-- Table structure for table `regions`
--
CREATE TABLE `regions` (
`id` int(10) UNSIGNED NOT NULL,
`region` varchar(100) NOT NULL,
`url` varchar(255) NOT NULL,
`rank_group` tinyint(3) UNSIGNED NOT NULL DEFAULT 1,
`sort_order` tinyint(3) UNSIGNED NOT NULL DEFAULT 0,
`rank_points` int(10) UNSIGNED NOT NULL DEFAULT 0,
`lat` decimal(8,4) DEFAULT NULL,
`lon` decimal(9,4) DEFAULT NULL,
`timezone` varchar(64) NOT NULL DEFAULT 'UTC'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `regions`
--
INSERT INTO `regions` (`id`, `region`, `url`, `rank_group`, `sort_order`, `rank_points`, `lat`, `lon`, `timezone`) VALUES
(1, 'United States', 'https://downdetector.com/', 1, 1, 0, 39.8283, -98.5795, 'America/New_York'),
(2, 'India', 'https://downdetector.in/', 1, 2, 0, 20.5937, 78.9629, 'Asia/Kolkata'),
(3, 'United Kingdom', 'https://downdetector.co.uk/', 1, 3, 0, 55.3781, -3.4360, 'Europe/London'),
(4, 'New Zealand', 'https://downdetector.co.nz/', 1, 4, 0, -40.9006, 174.8860, 'Pacific/Auckland'),
(5, '中華民國', 'https://downdetector.tw/', 1, 5, 0, 23.6978, 120.9605, 'Asia/Taipei'),
(6, 'Brazil', 'https://downdetector.com.br/', 1, 6, 0, -14.2350, -51.9253, 'America/Sao_Paulo'),
(7, 'France', 'https://downdetector.fr/', 1, 7, 0, 46.2276, 2.2137, 'Europe/Paris'),
(8, 'Canada', 'https://downdetector.ca/', 1, 8, 0, 56.1304, -106.3468, 'America/Toronto'),
(9, 'Australia', 'https://downdetector.com.au/', 1, 9, 0, -25.2744, 133.7751, 'Australia/Sydney'),
(10, '日本', 'https://downdetector.jp/', 1, 10, 0, 36.2048, 138.2529, 'Asia/Tokyo'),
(11, 'Deutschland', 'https://xn--allestrungen-9ib.de/', 2, 1, 0, 51.1657, 10.4515, 'Europe/Berlin'),
(12, 'Indonesia', 'https://downdetector.id/', 2, 2, 0, -0.7893, 113.9213, 'Asia/Jakarta'),
(13, 'Mexico', 'https://downdetector.mx/', 2, 3, 0, 23.6345, -102.5528, 'America/Mexico_City'),
(14, 'Turkey', 'https://downdetector.tr/', 2, 4, 0, 38.9637, 35.2433, 'Europe/Istanbul'),
(15, 'Pakistan', 'https://downdetector.pk/', 2, 5, 0, 30.3753, 69.3451, 'Asia/Karachi'),
(16, 'Bangladesh', 'https://bd.downdetector.com/', 2, 6, 0, 23.6850, 90.3563, 'Asia/Dhaka'),
(17, 'Nigeria', 'https://downdetector.com.ng/', 2, 7, 0, 9.0820, 8.6753, 'Africa/Lagos'),
(18, 'España', 'https://downdetector.es/', 2, 8, 0, 40.4637, -3.7492, 'Europe/Madrid'),
(19, 'Italia', 'https://downdetector.it/', 2, 9, 0, 41.8719, 12.5674, 'Europe/Rome'),
(20, 'Philippines', 'https://downdetector.ph/', 2, 10, 0, 12.8797, 121.7740, 'Asia/Manila'),
(21, 'Malaysia', 'https://downdetector.my/', 3, 1, 0, 4.2105, 101.9758, 'Asia/Kuala_Lumpur'),
(22, 'Netherlands', 'https://allestoringen.nl/', 3, 2, 0, 52.1326, 5.2913, 'Europe/Amsterdam'),
(23, 'UAE', 'https://downdetector.ae/', 3, 3, 0, 23.4241, 53.8478, 'Asia/Dubai'),
(24, 'المملكة العربية السعودية', 'https://sa.downdetector.com/', 3, 4, 0, 23.8859, 45.0792, 'Asia/Riyadh'),
(25, 'Viet Nam', 'https://vn.downdetector.com/', 3, 5, 0, 14.0583, 108.2772, 'Asia/Ho_Chi_Minh'),
(26, 'South Africa', 'https://downdetector.co.za/', 3, 6, 0, -30.5595, 22.9375, 'Africa/Johannesburg'),
(27, 'Singapore', 'https://downdetector.sg/', 3, 7, 0, 1.3521, 103.8198, 'Asia/Singapore'),
(28, 'Ukraine', 'https://downdetector.com.ua/', 3, 8, 0, 48.3794, 31.1656, 'Europe/Kyiv'),
(29, 'Polska', 'https://downdetector.pl/', 3, 9, 0, 51.9194, 19.1451, 'Europe/Warsaw'),
(30, 'Ireland', 'https://downdetector.ie/', 3, 10, 0, 53.4129, -8.2439, 'Europe/Dublin'),
(31, 'Österreich', 'https://xn--allestrungen-9ib.at/', 4, 1, 0, 47.5162, 14.5501, 'Europe/Vienna'),
(32, 'Schweiz', 'https://xn--allestrungen-9ib.ch/', 4, 2, 0, 46.8182, 8.2275, 'Europe/Zurich'),
(33, 'Česko', 'https://downdetector.cz/', 4, 3, 0, 49.8175, 15.4730, 'Europe/Prague'),
(34, 'Romania', 'https://downdetector.ro/', 4, 4, 0, 45.9432, 24.9668, 'Europe/Bucharest'),
(35, 'Magyarország', 'https://downdetector.hu/', 4, 5, 0, 47.1625, 19.5033, 'Europe/Budapest'),
(36, 'Danmark', 'https://downdetector.dk/', 4, 6, 0, 56.2639, 9.5018, 'Europe/Copenhagen'),
(37, 'Norge', 'https://downdetector.no/', 4, 7, 0, 60.4720, 8.4689, 'Europe/Oslo'),
(38, 'Sverige', 'https://downdetector.se/', 4, 8, 0, 60.1282, 18.6435, 'Europe/Stockholm'),
(39, 'Belgie', 'https://allestoringen.be/', 4, 9, 0, 50.5039, 4.4699, 'Europe/Brussels'),
(40, 'Hong Kong', 'https://downdetector.hk/', 4, 10, 0, 22.3193, 114.1694, 'Asia/Hong_Kong'),
(41, 'Algeria', 'https://dz.downdetector.com/', 5, 1, 0, 28.0339, 1.6596, 'Africa/Algiers'),
(42, 'Argentina', 'https://downdetector.com.ar/', 5, 2, 0, -38.4161, -63.6167, 'America/Argentina/Buenos_Aires'),
(43, 'Chile', 'https://downdetector.cl/', 5, 3, 0, -35.6751, -71.5430, 'America/Santiago'),
(44, 'Colombia', 'https://downdetector.com.co/', 5, 4, 0, 4.5709, -74.2973, 'America/Bogota'),
(45, 'Peru', 'https://downdetector.pe/', 5, 5, 0, -9.1899, -75.0152, 'America/Lima'),
(46, 'Ecuador', 'https://downdetector.ec/', 5, 6, 0, -1.8312, -78.1834, 'America/Guayaquil'),
(47, 'Costa Rica', 'https://cr.downdetector.com/', 5, 7, 0, 9.7489, -83.7534, 'America/Costa_Rica'),
(48, 'Guatemala', 'https://downdetector.com.gt/', 5, 8, 0, 15.7835, -90.2308, 'America/Guatemala'),
(49, 'Puerto Rico', 'https://downdetector.pr/', 5, 9, 0, 18.2208, -66.5901, 'America/Puerto_Rico'),
(50, 'República Dominicana', 'https://do.downdetector.com/', 5, 10, 0, 18.7357, -70.1627, 'America/Santo_Domingo'),
(51, 'Azerbaijan', 'https://az.downdetector.com/', 6, 1, 0, 40.1431, 47.5769, 'Asia/Baku'),
(52, 'Bahrain', 'https://downdetector.bh/', 6, 2, 0, 26.0667, 50.5577, 'Asia/Bahrain'),
(53, 'Kenya', 'https://downdetector.co.ke/', 6, 3, 0, -0.0236, 37.9062, 'Africa/Nairobi'),
(54, 'Maroc', 'https://downdetector.ma/', 6, 4, 0, 31.7917, -7.0926, 'Africa/Casablanca'),
(55, 'Hrvatska', 'https://downdetector.hr/', 6, 5, 0, 45.1000, 15.2000, 'Europe/Zagreb'),
(56, 'Serbia', 'https://downdetector.rs/', 6, 6, 0, 44.0165, 21.0059, 'Europe/Belgrade'),
(57, 'Slovensko', 'https://downdetector.sk/', 6, 7, 0, 48.6690, 19.6990, 'Europe/Bratislava'),
(58, 'Suomi', 'https://downdetector.fi/', 6, 8, 0, 61.9241, 25.7482, 'Europe/Helsinki'),
(59, 'Tunisie', 'https://tn.downdetector.com/', 6, 9, 0, 33.8869, 9.5375, 'Africa/Tunis'),
(60, 'Ελλάς', 'https://downdetector.gr/', 6, 10, 0, 39.0742, 21.8243, 'Europe/Athens'),
(61, 'מדינת ישראל', 'https://downdetector.co.il/', 6, 11, 0, 31.0461, 34.8516, 'Asia/Jerusalem'),
(62, 'الأردن', 'https://jo.downdetector.com/', 6, 12, 0, 30.5852, 36.2384, 'Asia/Amman'),
(63, 'ประเทศไทย', 'https://th.downdetector.com/', 6, 13, 0, 15.8700, 100.9925, 'Asia/Bangkok');
--
-- Indexes for dumped tables
--
--
-- Indexes for table `regions`
--
ALTER TABLE `regions`
ADD PRIMARY KEY (`id`);
--
-- AUTO_INCREMENT for dumped tables
--
--
-- AUTO_INCREMENT for table `regions`
--
ALTER TABLE `regions`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=68;
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 */;
Reference in New Issue View Git Blame Copy Permalink