swad-core/sql/countries.sql

-- MySQL dump 10.13  Distrib 5.1.73, for redhat-linux-gnu (x86_64)
--
-- Host: localhost    Database: swad
-- ------------------------------------------------------
-- Server version	5.1.73-log

/*!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 utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `countries`
--

DROP TABLE IF EXISTS `countries`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `countries` (
  `CtyCod` int(11) NOT NULL,
  `Alpha2` char(2) NOT NULL,
  `MapAttribution` text NOT NULL,
  `Name_ca` varchar(767) NOT NULL,
  `Name_de` varchar(767) NOT NULL,
  `Name_en` varchar(767) NOT NULL,
  `Name_es` varchar(767) NOT NULL,
  `Name_fr` varchar(767) NOT NULL,
  `Name_gn` varchar(767) NOT NULL,
  `Name_it` varchar(767) NOT NULL,
  `Name_pl` varchar(767) NOT NULL,
  `Name_pt` varchar(767) NOT NULL,
  `WWW_ca` varchar(255) NOT NULL,
  `WWW_de` varchar(255) NOT NULL,
  `WWW_en` varchar(255) NOT NULL,
  `WWW_es` varchar(255) NOT NULL,
  `WWW_fr` varchar(255) NOT NULL,
  `WWW_gn` varchar(255) NOT NULL,
  `WWW_it` varchar(255) NOT NULL,
  `WWW_pl` varchar(255) NOT NULL,
  `WWW_pt` varchar(255) NOT NULL,
  UNIQUE KEY `CtyCod` (`CtyCod`),
  UNIQUE KEY `Alpha2` (`Alpha2`),
  KEY `Name_de` (`Name_de`),
  KEY `Name_en` (`Name_en`),
  KEY `Name_es` (`Name_es`),
  KEY `Name_fr` (`Name_fr`),
  KEY `Name_it` (`Name_it`),
  KEY `Name_pt` (`Name_pt`),
  KEY `Name_pl` (`Name_pl`),
  KEY `Name_ca` (`Name_ca`),
  KEY `Name_gn` (`Name_gn`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `countries`
--

LOCK TABLES `countries` WRITE;
/*!40000 ALTER TABLE `countries` DISABLE KEYS */;
INSERT INTO `countries` VALUES (724,'ES','By Spain_(orthographic_projection).png: Neoespaña (talk) derivative work: L'Américain (Spain_(orthographic_projection).png) [CC-BY-SA-3.0-2.5-2.0-1.0 (http://creativecommons.org/licenses/by-sa/3.0), GFDL (http://www.gnu.org/copyleft/fdl.html) or GFDL (http://www.gnu.org/copyleft/fdl.html)], via Wikimedia Commons. http://commons.wikimedia.org/wiki/File%3ASpain_(orthographic_projection).svg','Espanya','Spanien','Spain','España','Espagne','España','Spagna','Hiszpania','Espanha','http://ca.wikipedia.org/wiki/Espanya','http://de.wikipedia.org/wiki/Spanien','http://en.wikipedia.org/wiki/Spain','http://es.wikipedia.org/wiki/Espa%C3%B1a','http://fr.wikipedia.org/wiki/Espagne','http://gn.wikipedia.org/wiki/Espa%C3%B1a','http://it.wikipedia.org/wiki/Spagna','http://pl.wikipedia.org/wiki/Hiszpania','http://pt.wikipedia.org/wiki/Espanha'),(276,'DE','By The Emirr [CC-BY-3.0 (http://creativecommons.org/licenses/by/3.0)], via Wikimedia Commons. http://commons.wikimedia.org/wiki/File%3AGermany_(orthographic_projection).svg','Alemanya','Deutschland','Germany','Alemania','Allemagne','Alemaña','Germania','Niemcy','Alemanha','http://ca.wikipedia.org/wiki/Alemanya','http://de.wikipedia.org/wiki/Deutschland','http://en.wikipedia.org/wiki/Germany','http://es.wikipedia.org/wiki/Alemania','http://fr.wikipedia.org/wiki/Allemagne','http://gn.wikipedia.org/wiki/Alema%C3%B1a','http://it.wikipedia.org/wiki/Germania','http://pl.wikipedia.org/wiki/Niemcyhttp://pl.wikipedia.org/wiki/Niemcyhttp://pl.wikipedia.org/wiki/Niemcy','http://pt.wikipedia.org/wiki/Alemanha'),(218,'EC','By Addicted04 [GFDL (http://www.gnu.org/copyleft/fdl.html), CC-BY-SA-3.0 (http://creativecommons.org/licenses/by-sa/3.0) or GFDL (http://www.gnu.org/copyleft/fdl.html)], via Wikimedia Commons. http://commons.wikimedia.org/wiki/File%3AEcuador_(orthographic_projection).svg','Ecuador','Ecuador','Ecuador','Ecuador','Équateur','Ecuador','Ecuador','Ecuador','Equador','','','','','','','','',''),(826,'GB','By Antonio Cañas Vargas. Derivative from image by Spain_(orthographic_projection).png: Neoespaña (talk) derivative work: L'Américain (Spain_(orthographic_projection).png) [CC-BY-SA-3.0-2.5-2.0-1.0 (http://creativecommons.org/licenses/by-sa/3.0), GFDL (http://www.gnu.org/copyleft/fdl.html) or GFDL (http://www.gnu.org/copyleft/fdl.html)], via Wikimedia Commons. http://commons.wikimedia.org/wiki/File%3ASpain_(orthographic_projection).svg','Regne Unit','Vereinigtes Königreich','United Kingdom','Reino Unido','Royaume-Uni','Reino Unido','Regno Unito','United Kingdom','Reino Unido','','','','','','','','',''),(484,'MX','By Ssolbergj [GFDL (http://www.gnu.org/copyleft/fdl.html) or CC-BY-3.0 (http://creativecommons.org/licenses/by/3.0)], via Wikimedia Commons. http://commons.wikimedia.org/wiki/File%3AMexico_(orthographic_projection).svg','Mèxic','Mexiko','Mexico','México','Mexique','Méjiko','Messico','Meksyk','México','http://ca.wikipedia.org/wiki/M%C3%A8xic','http://de.wikipedia.org/wiki/Mexiko','http://en.wikipedia.org/wiki/Mexico','http://es.wikipedia.org/wiki/M%C3%A9xico','http://fr.wikipedia.org/wiki/Mexique','http://gn.wikipedia.org/wiki/M%C3%A9jiko','http://it.wikipedia.org/wiki/Messico','http://pl.wikipedia.org/wiki/Meksyk','http://pt.wikipedia.org/wiki/M%C3%A9xico'),(380,'IT','By Antonio Cañas Vargas. Derivative from image by Spain_(orthographic_projection).png: Neoespaña (talk) derivative work: L'Américain (Spain_(orthographic_projection).png) [CC-BY-SA-3.0-2.5-2.0-1.0 (http://creativecommons.org/licenses/by-sa/3.0), GFDL (http://www.gnu.org/copyleft/fdl.html) or GFDL (http://www.gnu.org/copyleft/fdl.html)], via Wikimedia Commons. http://commons.wikimedia.org/wiki/File%3ASpain_(orthographic_projection).svg','Itàlia','Italien','Italy','Italia','Italie','Italia','Italia','Italy','Itália','','','','','','','','',''),(300,'GR','By Antonio Cañas Vargas. Derivative from image by Spain_(orthographic_projection).png: Neoespaña (talk) derivative work: L'Américain (Spain_(orthographic_projection).png) [CC-BY-SA-3.0-
/*!40000 ALTER TABLE `countries` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!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 */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2020-03-08 19:02:52