Sammy Ukavi sammyukavi
sammyukavi
/ countries.sql
Last active
March 12, 2021 08:00
The list of countries with names, ISO, ISO3 and currency name format in SQL.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; | |
| SET time_zone = "+00:00"; | |
| CREATE TABLE IF NOT EXISTS countries ( | |
| id int(10) UNSIGNED NOT NULL AUTO_INCREMENT, | |
| name varchar(80) COLLATE utf8mb4_unicode_ci NOT NULL, | |
| nice_name varchar(80) COLLATE utf8mb4_unicode_ci DEFAULT NULL, | |
| iso char(2) COLLATE utf8mb4_unicode_ci DEFAULT NULL, | |
| iso3 char(3) COLLATE utf8mb4_unicode_ci DEFAULT NULL, | |
| currency_name varchar(80) COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
sammyukavi
/ hosts
Created
October 1, 2018 05:16
— forked from consti/hosts
/etc/hosts to block shock sites etc.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| # This hosts file is brought to you by Dan Pollock and can be found at | |
| # http://someonewhocares.org/hosts/ | |
| # You are free to copy and distribute this file for non-commercial uses, | |
| # as long the original URL and attribution is included. | |
| #<localhost> | |
| 127.0.0.1 localhost | |
| 127.0.0.1 localhost.localdomain | |
| 255.255.255.255 broadcasthost | |
| ::1 localhost |