LmJf5TQw

1-- MySQL dump 10.13  Distrib 5.5.58, for Linux (x86_64)
2--
3-- Host: localhost    Database: naturadr_website
4-- ------------------------------------------------------
5-- Server version	5.5.58-cll
6
7/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
8/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
9/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
10/*!40101 SET NAMES utf8 */;
11/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
12/*!40103 SET TIME_ZONE='+00:00' */;
13/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
14/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
15/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
16/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
17
18--
19-- Table structure for table `t_lang`
20--
21
22DROP TABLE IF EXISTS `t_lang`;
23/*!40101 SET @saved_cs_client     = @@character_set_client */;
24/*!40101 SET character_set_client = utf8 */;
25CREATE TABLE `t_lang` (
26  `id` char(2) CHARACTER SET ascii NOT NULL,
27  `name` varchar(30) NOT NULL,
28  PRIMARY KEY (`id`)
29) ENGINE=InnoDB DEFAULT CHARSET=utf8;
30/*!40101 SET character_set_client = @saved_cs_client */;
31
32--
33-- Dumping data for table `t_lang`
34--
35
36LOCK TABLES `t_lang` WRITE;
37/*!40000 ALTER TABLE `t_lang` DISABLE KEYS */;
38INSERT INTO `t_lang` VALUES ('de','Deutsch'),('en','English'),('es','Español'),('fr','Français'),('it','Italiano'),('pt','Português');
39/*!40000 ALTER TABLE `t_lang` ENABLE KEYS */;
40UNLOCK TABLES;
41
42--
43-- Table structure for table `t_project`
44--
45
46DROP TABLE IF EXISTS `t_project`;
47/*!40101 SET @saved_cs_client     = @@character_set_client */;
48/*!40101 SET character_set_client = utf8 */;
49CREATE TABLE `t_project` (
50  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
51  `name` varchar(60) NOT NULL,
52  `title` varchar(160) NOT NULL,
53  `y` int(4) unsigned NOT NULL,
54  `prize` varchar(60) NOT NULL,
55  `file` varchar(60) DEFAULT NULL,
56  `position` int(10) unsigned NOT NULL DEFAULT '0',
57  `file_type` varchar(40) DEFAULT NULL,
58  `file_size` int(10) unsigned DEFAULT NULL,
59  `country_id` char(2) CHARACTER SET ascii NOT NULL,
60  `latitud` float NOT NULL,
61  `longitud` float NOT NULL,
62  `categorias` int(11) NOT NULL,
63  `img` varchar(254) CHARACTER SET utf8 COLLATE utf8_spanish_ci NOT NULL,
64  `destacado` tinyint(1) NOT NULL,
65  PRIMARY KEY (`id`)
66) ENGINE=InnoDB AUTO_INCREMENT=71 DEFAULT CHARSET=utf8;
67/*!40101 SET character_set_client = @saved_cs_client */;
68
69--
70-- Dumping data for table `t_project`
71--
72
73LOCK TABLES `t_project` WRITE;
74/*!40000 ALTER TABLE `t_project` DISABLE KEYS */;
75INSERT INTO `t_project` VALUES (1,'Fundación Recover','Reducción de la mortalidad materno-infantil en Sangmelima (Región Sur, Camerún).',2011,'40.000 €','2011-Fundacion_Recover.pdf',1,'application/pdf',0,'CM',2.93408,11.9834,11,'salud-materno-infantil.jpg',1),(2,'Fundación 3GT','Construcción y equipamiento de un colegio secundario en zona rural (República de Burundi).',2011,'23.620,70 €','2011-Fundacion_3GT.pdf',2,'application/x-download',0,'BI',-3.39013,29.9253,1,'14_5414-2.jpg',0),(3,'Acción para el desarrollo y la igualdad','Incremento de la seguridad alimentaria de la población e inclusión laboral de las mujeres andinas del Centro Poblado de Monchacap, provincia de Otuzco (La Liber',2011,'21.292 €','2011-desarrollo_igualdad.pdf',3,'application/x-download',0,'PE',-7.86024,-78.5841,7,'peru-2.jpg',0),(4,'Fallou ONGD','Proyecto agrícola para la mejora de la alimentación del poblado de Balacounda (Senegal).',2011,'14.465,80 €','2011-Fallou.pdf',4,'application/x-download',0,'SN',13.5034,-13.5375,14,'f01_01-2.jpg',0),(5,'Active Africa','\'Clases a la sombra de la Tijuana\' (construcción de 3 nuevas clases para la escuela de Chankhungu, Malawi).',2010,'50.404 €','2010-Active_Africa.pdf',2,'application/x-download',0,'ZM',-13.2794,34.2955,1,'active-africa-2.jpg',0),(6,'África Viva','Plataforma de atención en salud materno-infantil (Mekelle, Etiopía)',2010,'34.800 €','2010-AVF.pdf',3,'application/x-download',0,'ET',13.4972,39.4937,11,'etiopia_africaviva.jpg',0),(7,'Infancia del Mundo','Construcción del sistema de saneamiento y agua potable para la comunidad de leprosos de Karunanbika Lean Life Center (Andhra Pradesh, India)',2010,'24.638 €','2010-Infancia.pdf',4,'application/x-download',0,'IN',15.9034,80.7709,13,'foto2.jpg',0),(8,'ABAY','Proyecto de suministro de agua potable mediante la construcción de un pozo manual como elemento esencial del desarrollo local en el municipio de Walmara (Etiopí',2010,'6.185 €','2010-ABAY.pdf',1,'application/x-download',0,'ET',8.9632,38.7781,13,'abay.jpg',1),(9,'Cáritas España','Cáritas ante la crisis',2010,'41.280,82 €','2010-Caritas_ante_la_crisis.pdf',5,'application/x-download',0,'ES',40.5635,-1.95519,7,'caritas-espanola.jpg',0),(10,'Cáritas Portugal','Cáritas Portugal',2010,'17.691,78 €','2010-caritas_pt.pdf',6,'application/x-download',0,'PT',39.2489,-8.63488,7,'karingana_cartaz2.jpg',0),(11,'África nos mira','Construcción de una escuela de educación primaria y servicios asociados de acceso a agua potable en Bidera, Etiopía.',2009,'39.386 €','Premio_Natura_Ganador_2009_1.pdf',3,'application/x-download',0,'ET',9.0656,36.7201,1,'56-africanosmira_thumb.jpg',0),(12,'Fundación Esteban G. Vigil','Adquisición de un vehículo para la Comunidad de Ndonyowasin, Kenia. ',2009,'33.731 €','Premio_Natura_Ganador_2009_2.pdf',2,'application/x-download',0,'KE',1.27605,38.8752,7,'foto.jpg',0),(13,'Ajut i Solidaritat Makary-Blangoua','Proyectos de pozos y agricultura sostenible en Camerún.',2009,'32.000 €','Premio_Natura_Ganador_2009_3.pdf',4,'application/x-download',0,'CM',12.769,14.5491,13,'pou_ecole_mada_01-2.jpg',0),(14,'Fundación Dasyc','Antibióticos infantiles para Etiopía.',2009,'20.261,65 €','Premio_Natura_Ganador_2009_4.pdf',5,'application/x-download',0,'ET',7.10405,35.5317,2,'page-1-image-3.jpg',0),(15,'Associació catalana d\'ajuda al Sahel','Construcción de un pozo con bomba manual y abrevadero para el ganado, País Dogón (Mali).',2009,'15.549,79 €','Premio_Natura_Ganador_2009_5.pdf',1,'application/x-download',0,'ML',14.4278,-3.32533,13,'imgp0540.jpg',1),(16,'VOLS (Voluntariat Solidari)','Casa de acogida de niñas y adolescentes en riesgo de prostitución y pobreza extrema en Abidjan, Costa de Marfil.',2009,'12.607,50 €','Premio_Natura_Ganador_2009_6.pdf',6,'application/x-download',0,'CI',5.34865,-3.97986,8,'foto.jpg',0),(17,'Asociación Cielo 133','Proyecto clínica pediátrica Addis Abeba (Etiopía) para dar cobertura sanitaria a más de 400 niños.',2009,'5.900 €','Premio_Natura_Ganador_2009_7.pdf',7,'application/x-download',0,'ET',8.93403,38.8207,2,'euerus-entre-flores-250x150.jpg',0),(18,'Fundación Ami (Asistencia Médica Internacional)','Proyecto Mesa de Sao Lazaro: proyecto global dirigido a reformar un centro de acogida de niños en Mozambique, a proporcionarles ayuda sanitaria, asistencia médi',2008,'14.350 €','Premio_Natura_Ganador_2008_1.pdf',1,'application/x-download',0,'MZ',-18.8702,35.5273,2,'mocambique-ami.png',1),(19,'Fundación Arsis','Proyecto de captación y conducción de agua potable a unos poblados africanos de la región oeste de Camerún.',2008,'30.000 €','Premio_Natura_Ganador_2008_2.pdf',2,'application/x-download',0,'CM',5.26662,10.367,13,'foto.jpg',0),(20,'Intercanvi','Construcción de cuatro escuelas jardín para 280 niños y niñas de 3 a 6 años en la región de Bafat, Guinea Bissau.',2008,'28.400 €','Premio_Natura_Ganador_2008_3.pdf',3,'application/x-download',0,'GW',12.1887,-14.7314,1,'foto.jpg',0),(21,'Hospital Sant Joan de Déu','Proyecto para el tratamiento del linfoma de Burkitt en Sierra Leona.',2008,'60.000 €','Premio_Natura_Ganador_2008_4.pdf',4,'application/x-download',0,'SL',8.10487,-11.9409,2,'page_1.jpg',0),(22,'Fundación Vicente Ferrer','Proyecto de vacunación infantil en el Hospital de Bathalapalli. Anantapur (India).',2008,'17.048,71 €','Premio_Natura_Ganador_2008_5.pdf',5,'application/x-download',0,'IN',14.5122,77.7717,2,'lorenzo-vicente-ferrer-2.jpg',0),(23,'Care highway International','Hogar de infancia para nińos huérfanos de Kenia (África)',2007,'54.162,89 €','Premio_Natura_Ganador_2007_CH.pdf',1,'application/x-download',0,'KE',-0.921074,39.6882,8,'k.jpg',0),(24,'Sonrisas de Bombay','Garantizar a 2.500 nińos del Estado de Maharasthra (India) el acceso a la educación.',2007,'53.129,18 €','Premio_Natura_Ganador_2007_SB.pdf',2,'application/x-download',0,'IN',18.8459,76.7751,1,'sonrisasdebombay.jpg',0),(25,'Medicus Mundi Cantabria','Construcción de una maternidad en Nafadji (Bamako-Mali).',2007,'20.656 €','Premio_Natura_Ganador_2007_MMC.pdf',3,'application/x-download',0,'ML',10.5791,-9.23315,11,'1468502107-1000x475_5787905b2a13a.jpg',0),(26,'Asociación Amigos de Orfanato Estrella del Mañana en India','Escuela de nińos ciegos de Mungod en Karnnataka (India).',2007,'17.560 €','Premio_Natura_Ganador_2007_OEM.pdf',4,'application/x-download',0,'IN',14.9721,75.0389,1,'2007.jpg',0),(27,'Fundación infancia de hoy','Hogar de infancia para nińos huérfanos de Kenia (África).',2007,'10.350 €','Premio_Natura_Ganador_2007_DHE.pdf',5,'application/x-download',0,'KE',-1.99737,37.2272,8,'pm-ken-dadaab-2123-600x399.jpg',0),(28,'Alpicat Solidari','Baja Kunda - Alpicat Solidari.',2006,'90.390,67 €','Premio_Natura_Ganador_2006.pdf',1,'application/x-download',0,'GM',13.4264,-14.0645,1,'cartell-natura2.jpg',0),(29,'Kumara-Infancia del mundo','Proyecto para la construcción de un dormitorio infantil en el hogar de santa Teresa de Avila.',2006,'11.820 €','Premio_Natura_Ganador_2006-2.pdf',2,'application/x-download',0,'IN',15.9034,80.7709,8,'002003_1.jpg',0),(30,'Kumara-Infancia del mundo','Proyecto poder vivir, calidad de vida para nińas afectadas por el sida.',2006,'7.000 €','Premio_Natura_Ganador_2006-3.pdf',3,'application/x-download',0,'IN',19.5404,72.9808,2,'page_1_thumb_large.jpg',0),(31,'África Directo','Programa de recuperación de nińos de la calle en Goma.',2005,'56.768 €','Premio_Natura_2005_Africa_Directo.pdf',1,'application/x-download',0,'CD',-1.66303,29.2081,8,'foto.jpg',0),(32,'Orphanage Africa','Construcción de orphanage africa children\'s home, Dodowa (Ghana).',2005,'63.232 €','Premio_Natura_2005_Orphanate_Africa.pdf',2,'application/x-download',0,'GH',6.18095,-1.20004,8,'oa_ayenyahweb.jpg',0),(33,'Misioneras de Maria Mediadora','Solicitud de financiación para construir un hogar para ancianos.',2004,'95.120 €','PremioNatura_Ganador2004.pdf',1,'application/x-download',0,'ES',13.6291,75.9714,10,'dsc00971-300x225.jpg',0),(34,'Fundación Vicente Ferrer','Proyecto de la fundación Vicente Ferrer para el distrito de Anantapur - India.',2003,'72.121 €','PREMIO_NATURA_2003.pdf',1,'application/x-download',0,'IN',14.665,77.5942,12,'vicente-ferrer-647x320.jpg',0),(35,'Amigos de los Adivasis','Ayuda a los nińos de la calle. - Ganeshpuri, India.',2002,'30.051 €',NULL,1,NULL,NULL,'IN',19.5017,73.0131,8,'larm-rmah-216854.jpg',0),(36,'ADALI','Calienta Tokmok. Ayuda directa a la infancia. - República de Kirguizistan.',2002,'30.051 €',NULL,2,NULL,NULL,'KG',41.2547,74.7388,8,'kids-group-s_1.jpg',0),(37,'Asociación Kusi Warma','Recuperación nutricional y rehabilitación familiar de nińos con desnutrición grave en Perú.',2001,'42.071 €','kusiwarma2001.pdf',1,'application/x-download',0,'PE',-11.9761,-76.993,9,'foto1.jpg',0),(38,'Casal dels Infants del Raval','Marhaba.',2000,'4.000.000 ptas.','Premi_NATURA-Marhaba2000.pdf',1,'application/x-download',0,'ES',41.3617,2.16947,8,'page_1_thumb_large_1.jpg',0),(39,'Fundación Blas Méndez Ponce','Ayuda al nińo oncológico.',1999,'4.000.000 ptas.','BlasMendezPonce-1999.pdf',1,'application/x-download',0,'ES',40.7153,-4.22458,2,'ninos-fundacion-blas-mendez-ponce_tinima20130929_0274_5.jpg',0),(40,'Fundación Natura','Conservación de los bosques maduros para las personas y los osos al pirineo - Espańa.',1999,'3.000.000 ptas.',NULL,2,NULL,NULL,'ES',42.6999,0.33475,6,'oso.jpg',0),(41,'Tierra de Hombres','Atenciones médicas especializadas - Viaje hacia la Vida - Madrid, Sevilla y Málaga.',1998,'6.000.000 ptas.',NULL,1,NULL,NULL,'ES',37.3716,-4.89474,2,'fotonoticia_20161110143802_800.jpg',0),(42,'Nous Camins','Infraestructura y atención especial para el tratamiento de enfermedades contagiosas de los nińos del centro \'Habari Njema\'. - Kibagare, Nairobi.',1997,'4.000.000 ptas.',NULL,1,NULL,NULL,'KE',-1.13799,37.1039,2,'1era-etiopia-cuna-de-la-humanidad.jpg',0),(43,'Medicus Mundi','Infraestructura y atención especial para el tratamiento de enfermedades de los del centro Habari Njema. - Kibagare, Nairobi',1996,'5.000.000 ptas.',NULL,1,NULL,NULL,'KE',-0.577753,36.6095,2,'1468502099-600x375_57879053a03cf.jpg',0),(44,'Manos Unidas','Construcción de una escuela donde se impartirá la educación en Telugu, lengua vernácula.',1995,'296.875 ptas.','manosunidas1995.pdf',1,'application/x-download',0,'IN',15.8118,78.0398,1,'ghana_web.jpg',0),(45,'Médicos sin Fronteras','Proyecto Médicos sin Fronteras',1995,'296.875 ptas.',NULL,2,NULL,NULL,'ES',40.1617,-1.55968,2,'voluntarios-medicos-sin-fronteras.jpg',0),(46,'Survival Internacional','Proyecto Survival Internacional',1995,'296.875 ptas.',NULL,3,NULL,NULL,'CG',-4.24721,15.2272,3,'foto-1.jpg',0),(47,'Greenpeace','Proyecto Greenpeace',1995,'296.875 ptas.',NULL,4,NULL,NULL,'ES',38.942,-2.48253,6,'mljeuaffdpfrkvq-800x450-nopad-1.jpg',0),(48,'ADDA','Proyecto ADDA',1995,'296.875 ptas.',NULL,5,NULL,NULL,'ES',42.277,-2.08702,6,'adda12.jpg',0),(49,'Ayuda en Acción','Proyecto Ayuda en Acción',1995,'296.875 ptas.',NULL,6,NULL,NULL,'ES',41.1948,0.0223516,7,'mg_1679-6172016-1.jpg',0),(50,'Intermón','Proyecto Intermón',1995,'296.875 ptas.',NULL,7,NULL,NULL,'NI',12.6213,-84.6798,7,'oes_16999_-es_color-en_colour-lpr1.jpg',0),(51,'Dian Fossey Gorilla Foundation','Proyecto Dian Fossey Gorilla Foundation',1995,'296.875 ptas.',NULL,8,NULL,NULL,'CG',-3.36339,15.7165,6,'dian-fossey-gorilla-3.jpg',0),(52,'Ayuda en Acción (Nepal)','Educación inclusiva para niños y niñas con discapacidades  auditivas en Nepal.',2012,'30.591 €','educacion-inclusiva-en-nepal-aea-2012.pdf',1,'application/pdf',613490,'NP',28.4173,84.13,1,'ayuda-en-accion.jpg',0),(53,'ACOES (Honduras)','Auto-contrucción de las viviendas de la  comunidad del Goviado,  mediante la formación en técnicas de  construcción tradicional y autóctona',2012,'30.119 €','proyecto-viviendas-gobiado-natura-a-desarrollar.pdf',2,'application/pdf',6542695,'HN',15.1716,-86.3409,12,'20160416_161837.jpg',0),(54,'Fundación Guné (Senegal) ','Contribuir al desarrollo socioeconómico de la región de Kolda  mediante la dinamización de la agricultura y el fortalecimiento  de cooperativas agrícolas.',2012,'23.200 €','fundacion-gune.-premios-natura.pdf',3,'application/pdf',1671420,'SN',13.0382,-15.0224,14,'foto.jpg',0),(55,'Sol Solidari (Burkina Faso)','Promoción de la energía solar en escuelas de Ouagadougou.',2012,'10.260 €','projecte-escoles-burkina-2-part-2013_natura.pdf',4,'application/pdf',1019609,'BF',12.3585,-1.53684,6,'sol-solidari_energia-solar-burkina_2.jpg',0),(56,'África nos mira (Etiopía)','Ampliación y equipamiento de una escuela de educación y de sus servicios asociados de acceso a agua potable',2013,'26.000 €','2013-africa_nos_mira.pdf',3,'application/pdf',927783,'ET',10.2353,37.8627,13,'africanosmira.jpg',0),(57,'Naya Nagar (India)','Fortalecer el centro de formación para mujeres, el centro educativo Mera Parivar y el programa “Derecho a la identidad”',2013,'23.450,84 €','2013-naya_nagar.pdf',2,'application/pdf',1401506,'IN',25.7458,86.1015,15,'el-elefante_img.jpg',0),(58,'Vicente Ferrer (India)','Mejorar la situación de las mujeres en las áreas rurales facilitando ganado vacuno para la producción de leche',2013,'20.611 €','2013-vicente_ferrer.pdf',1,'application/pdf',1912053,'IN',21.009,82.8627,14,'vicentef.jpg',0),(59,'REDI (Guatemala)','COMBATIENDO LA DESNUTRICIÓN INFANTIL-  El proyecto trata de combatir la desnutrición crónica que padecen las familias, y en particular la población infantil.',2014,'22.243 €','2014-redi_desnutricin_infantil.pdf',1,'application/pdf',370780,'GT',15.6745,-90.2208,9,'redi_263x268.jpg',0),(60,'Ciudad Esperanza (India)','SOBERANÍA ALIMENTÁRIA EN CENTRO VHI. Soberanía alimentária en un centro para enfermos de VIH/SIDA en Manmad, India.',2014,'13.248 €','2014-proyecto_sida_esperanza_alegra.def.pdf',2,'application/pdf',2260864,'IN',20.2526,74.4149,9,'ciudad-esperanza-alegria-644x362.jpg',0),(61,'Codespa (Angola)','BIDONES CONTRA EL HAMBRE. Proyecto de Reducción del hambre en las familias de la provincia de Huambo.',2014,'21.350 €','2014-fundaci_codespa_bidones.pdf',3,'application/pdf',1119749,'AO',-12.4928,15.6546,9,'sin-titulo-1.jpg',0),(62,'Movimiento por la Paz (Níger)','MADRES MODELO - El proyecto trata de luchar contra la desnutrición infantil formando a un grupo de madres que actuarán como modelos en su comunidad.',2015,'25.306 €','madres_modelo-niger_20151116095932.pdf',1,'application/pdf',5495788,'NE',17.0505,7.96549,9,'el-elefante_img.jpg',0),(63,'Fundación de Solidaridad Amaranta (Togo)','OASIS FRENTE A LA TRATA - Formación e inserción laboral de mujeres en situación de prostitución o víctimas de la trata.',2015,'24.603 €','oasis_frente_a_la_trata_20151113145516.pdf',2,'application/pdf',3614302,'TG',9.09214,0.834948,15,'sin-titulo-1.jpg',0),(64,'Colabora Birmania (Birmania)','PUENTE PARA LA EDUCACIÓN - Sustitución del puente de bambú para facilitar el acceso a la educación.',2015,'19.138 €','puente_para_la_educacion_20151113151950.pdf',3,'application/pdf',5502146,'MM',21.8257,96.3506,1,'eric2.jpg',0),(65,'Médicos del Mundo (Burkina Faso)','Proyecto destinado a prevenir los embarazos no deseados y las infecciones de transmisión sexual de las y los jóvenes de Bobo-Dioulasso ',2016,'26.000 €','medicos-del-mundo.pdf',2,'application/pdf',1392606,'BF',12.331,-1.55772,2,'burkina-mdm.jpg',0),(66,'Fundación EDUCO (Benín)','Proyecto destinado a educar y proteger a los niños y adolescentes en situación de calle del mercado de Dantokpa ',2016,'23.030 €','educo.pdf',1,'application/pdf',3121460,'TG',9.39034,2.2357,1,'educo.jpg',0),(67,'Fundación Acción GEODA (Marruecos)','Proyecto dedicado a la creación de acceso a agua potable y a la evacuación de aguas negras para los habitantes de Ait- Alla en el Valle del Tessaout .',2016,'12.736 €','geoda.pdf',3,'application/pdf',1933593,'MA',32.2286,-6.83043,13,'nilaagua263px.jpg',0),(68,'ACNUR','Promover la autosuficiencia de la población refugiada en el campo de Kakuma (Kenia), apoyando la puesta en marcha de negocios pr',2017,'25.000 €','preseleccionado-2-premios-natura.pdf',3,'application/pdf',24740,'KE',1.06625,38.5208,3,'rf2115329_2017_08_02_kakuma_camp-20.jpg',0),(69,'Fundación Asha-Kiran','Proporcionar una alternativa y un futuro a las niñas en situación de calle en la India. Apoyar al personal que hace posible el buen funcionamiento del hogar de ',2017,'35.503 €','preseleccionado-7-premios-natura.pdf',2,'application/pdf',25235,'IN',18.5253,73.8726,8,'e.jpg',0),(70,'IT WILL BE','Este proyecto quiere combatir la explotación laboral infantil en las fábricas de ladrillos de Passor, India, a través de la educación.',2017,'33.219 €','preseleccionado-3-premios-natura.pdf',1,'application/pdf',24489,'IN',17.2819,78.3325,7,'itwillbe1.jpg',0);
76/*!40000 ALTER TABLE `t_project` ENABLE KEYS */;
77UNLOCK TABLES;
78
79--
80-- Table structure for table `t_project_lang`
81--
82
83DROP TABLE IF EXISTS `t_project_lang`;
84/*!40101 SET @saved_cs_client     = @@character_set_client */;
85/*!40101 SET character_set_client = utf8 */;
86CREATE TABLE `t_project_lang` (
87  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
88  `project_id` int(10) unsigned NOT NULL,
89  `lang_id` char(2) CHARACTER SET ascii NOT NULL,
90  `name` varchar(60) DEFAULT NULL,
91  `title` varchar(160) DEFAULT NULL,
92  PRIMARY KEY (`id`),
93  KEY `project_id` (`project_id`),
94  KEY `lang_id` (`lang_id`),
95  CONSTRAINT `t_project_lang_ibfk_1` FOREIGN KEY (`project_id`) REFERENCES `t_project` (`id`) ON DELETE CASCADE,
96  CONSTRAINT `t_project_lang_ibfk_2` FOREIGN KEY (`lang_id`) REFERENCES `t_lang` (`id`) ON DELETE CASCADE
97) ENGINE=InnoDB AUTO_INCREMENT=366 DEFAULT CHARSET=utf8;
98/*!40101 SET character_set_client = @saved_cs_client */;
99
100--
101-- Dumping data for table `t_project_lang`
102--
103
104LOCK TABLES `t_project_lang` WRITE;
105/*!40000 ALTER TABLE `t_project_lang` DISABLE KEYS */;
106INSERT INTO `t_project_lang` VALUES (1,1,'en','Recover Foundation','Reduction of child and maternal mortality in Sangmelima (South of Cameroon).'),(2,1,'pt','Fundação Recover','Redução da mortalidade maternoinfantil (Cameroon).'),(3,1,'it','Fondazione Recover','Riduzione della mortalità materno-infantile (camerun).'),(4,1,'fr','Fondation Recover','Réduction de la mortalité maternelle et infantile (cameroun).'),(5,1,'de','Stiftung Recover','Verringerung der Mutter-Kind-Sterblichkeit (Kamerun).'),(6,2,'en','Foundation 3GT','Construction and equipping of a secondary school in a rural area (Republic of Burundi).'),(7,2,'pt','Fundação 3GT','Construção e equipamento de uma escola secundária em zona rural (República do Burúndi).'),(8,2,'it','Fondazione 3gt','Costruzione ed equipaggiamento di una scuola superiore in una zona rurale (Repubblica del Burundi).'),(9,2,'fr','Fondation 3gt','Construction et équipement d\'un lycée en zone rurale (République du Burundi).'),(10,2,'de','Stiftung 3gt','Bau und Einrichtung einer weiterführenden Schule in ländlichem Gebiet (Republik Burundi).'),(16,3,'en','Initiative for development and equality','Increasing food safety and workplace inclusion for andine women in Centro Poblado de Monchacap, province of Otuzco (Peru)'),(17,3,'pt','Ação para o desenvolvimento e para a igualdade','Segurança alimentar e inclusão laboral das mulheres. (Peru).'),(18,3,'it','Azione per lo sviluppo e l\'uguaglianza','Sicurezza alimentare e integrazione delle donne nel mercato del lavoro. (Peru).'),(19,3,'fr','Action pour le développement et l\'égalité','Sécurité alimentaire et insertion professionnelle des femmes. (Pérou).'),(20,3,'de','Aktion für entwicklung und gleichheit','Ernährungssicherung und berufliche Integration für Frauen (Peru).'),(21,4,'en','Fallou ONGD','Farming project to improve the nutrition of the people of Balacounda (Senegal)'),(22,4,'pt','Fallou ong','Projeto agrícola para a melhoria da alimentação da povoação de Balacounda. (Senegal).'),(23,4,'it','Fallou ong','Progetto agricolo per il miglioramento dell\'alimentazione nel villaggio di Balacounda (Senegal).'),(24,4,'fr','Fallou ong','Projet agricole pour l\'amélioration de l\'alimentation du village de Balacounda. (Sénégal).'),(25,4,'de','Fallou ong','Landwirtschaftliches Projekt zur Verbesserung der Lebensmittelversorgung der Bevölkerung von Balacounda (Senegal).'),(26,5,'en','Active Africa','Classes in the shade of Tijuana (construction of 3 new classrooms for the school of Chankhungu, Malawi).'),(27,5,'pt','','Aulas à sombra de Tijuana\' (construção de 3 novas salas para a escola de Chankhungu, Malaui).'),(28,5,'it','','Lezioni all\'ombra della Tijuana\' (costruzione di 3 nuove aule per la scuola di Chankhungu, Malawi).'),(29,5,'fr','Active Africa','« Classes à l\'ombre de la Tijuana » (construction de 3 nouvelles classes pour l\'école de Chankhungu, Malawi).'),(30,5,'de','','‚Unterricht im Schatten des Tijuana’ (Bau von 3 neuen Klassenräumen für die Schule von Chankhungu, Malawi).'),(31,6,'en','Africa Viva','Maternal and child healthcare platform (Mekelle, Ethiopia)'),(32,6,'pt','','Plataforma de apoio à saúde materno-infantil (Mekelle, Etiópia)'),(33,6,'it','','Piattaforma di assistenza sanitaria materno-infantile (Macallè, Etiopia)'),(34,6,'fr','África Viva','Plate-forme d\'assistance sanitaire maternelle et infantile (Mékélé, Éthiopie)'),(35,6,'de','','Plattform für die medizinische Behandlung von Mutter und Kind (Mekelle, Äthiopien)'),(46,7,'en','Infancia del mundo','Construction of a sanitation and drinking water supply system for the leper community of Karunanbika Lean Life Centre (Andhra Pradesh, India)'),(47,7,'pt','','Construção do sistema de saneamento e de água potável para a comunidade de leprosos do Karunanbika Lean Life Center (Andhra Pradesh, Índia)'),(48,7,'it','','Costruzione del sistema di risanamento e di acqua potabile per la comunità di lebbrosi di Karunanbika Lean Life Center (Andhra Pradesh, India)'),(49,7,'fr','Infancia del Mundo','Construction du système d\'assainissement et de distribution d\'eau potable pour la communauté de lépreux du Karunambika Lean Life Center (Andhra Pradesh, Inde)'),(50,7,'de','','Bau eines Abwasser- und Trinkwassersystems für die Lepragemeinde des Karunanbika Lean Life Centers (Andhra Pradesh, Indien)'),(51,8,'en','ABAY','Drinking water supply project through the construction of a manual well as an essential element of local development in Andhra Pradesh, India'),(52,8,'pt','','Projeto de fornecimento de água potável através da construção de um poço manual como elemento essencial de desenvolvimento local no município de Walmara (Etiópi'),(53,8,'it','','Progetto di fornitura di acqua potabile mediante la costruzione di un pozzo manuale come elemento essenziale per lo sviluppo locale nel comune di Walmara (Etiop'),(54,8,'fr','ABAY','Projet d\'approvisionnement en eau potable par le forage d\'un puits avec pompe manuelle en tant qu\'élément essentiel pour le développement local dans le district'),(55,8,'de','','Projekt zur Trinkwasserversorgung durch den Bau eines Brunnens mit Handantrieb als grundlegendes Element der regionalen Entwicklung im Gemeindebezirk Walmara (Ä'),(56,9,'en','Caritas Spain','Caritas in the face of the crisis'),(57,9,'pt','','A Cáritas perante a crise'),(58,9,'it','','La Caritas di fronte alla crisi'),(59,9,'fr','Cáritas España','Caritas face à la crise'),(60,9,'de','','Cáritas angesichts der Krise'),(61,10,'en','Caritas Portugal','Caritas Portugal'),(62,10,'pt','','Cáritas Portugal'),(63,10,'it','','Caritas Portogallo'),(64,10,'fr','','Caritas Portugal'),(65,10,'de','','Cáritas angesichts der Krise'),(66,11,'en','Africa nos mira (Africa watches us)','Construction of a primary school and associated drinking water supply services in Bidera, Ethiopia.'),(67,11,'pt','África nos mira','Construção de uma escola de educação primária e serviços associados de acesso a água potável em Bidera e na Etiópia.'),(68,11,'it','África nos mira','Costruzione di una scuola elementare e dei servizi associati d\'accesso allçacqua potabile a Bidera, Etiopia'),(69,11,'fr','','Construction d\'une école primaire et de services d\'approvisionnement en eau potable à Adi Bidera, Éthiopie'),(70,11,'de','','Bau einer Grundschule und dazu gehöriger Zugangswege und Trinkwasserversorgung in Bidera (Äthiopien)'),(71,12,'en','Esteban G. Vigil Foundation','Purchase of a vehicle for the Community of Ndonyowasin, Kenya'),(72,12,'pt','Fundación Esteban G. Vigil','Aquisição de um veículo para a Comunidade de Ndonyowasin, Quénia.'),(73,12,'it','Fundación Esteban G. Vigil','Acquisto di un veicolo per la Comunità di Ndonyowasin, Kenya.'),(74,12,'fr','Fondation Esteban G. Vigil','Acquisition d\'un véhicule pour la communauté de Ndonyo Wasin, Kenya '),(75,12,'de','','Kauf eines Fahrzeugs für die Gemeinde N\'Donyo Wasin (Kenia) '),(76,13,'en','Ajut i Solidaritat Makary-Blangoua (Help and solidarity Maka','Well and sustainable farming projects in Cameroon.'),(77,13,'pt','Ajut i Solidaritat Makary-Blangoua','Projectos de poços e agricultura sustentável na República dos Camarões.'),(78,13,'it','Ajut i Solidaritat Makary-Blangoua','Progetti di pozzi e agricoltura sostenibile in Camerun.'),(79,13,'fr','','Projets de forage de puits et d\'agriculture durable au Cameroun.'),(80,13,'de','','Projekte für Brunnen und nachhaltige Landwirtschaft in Kamerun'),(81,14,'en','Dasyc Foundation','Antibiotics for children of Ethiopia.'),(82,14,'pt','Fundación Dasyc','Antibióticos infantis para a Etiópia.'),(83,14,'it','Fundación Dasyc','Antibiotici per bambini per l\'Etiopia.'),(84,14,'fr','Fondation Dasyc','Antibiotiques pour enfants à destination de l\'Éthiopie.'),(85,14,'de','','Antibiotika für Kinder in Äthiopien'),(86,15,'en','Associació catalana d\'ajuda al Sahel','Construction of a well equipped with a hand pump and watering place for cattle, Dogon Country (Mali)'),(87,15,'pt','Associació catalana d\'ajuda al Sahel','Construção de um poço natural com bomba e bebedouro para o gado, País Dogon (Mali).'),(88,15,'it','Associació catalana d\'ajuda al Sahel','Costruzione di un pozzo naturale con pompa e abbeveratoio per il bestiame, Paese Dogon (Mali).'),(89,15,'fr','Associació catalana d\'ajuda al Sahel','Forage d\'un puits avec pompe manuelle et abreuvoir pour le bétail, Pays Dogon (Mali).'),(90,15,'de','','Bau eines Brunnens mit Pumpe mit Handbetrieb und Viehtränke für das Volk der Dogon (Mali)'),(91,16,'en','VOLS (Joint Voluntary Work)','Shelter for little and teenage girls at risk of prostitution and extreme poverty in Abidjan, Ivory Coast'),(92,16,'pt','VOLS (Voluntariat Solidari)','Casa de acolhimento para raparigas e adolescentes em risco de se prostituírem e de pobreza extrema em Abidjan, Costa de Marfim.'),(93,16,'it','VOLS (Voluntariat Solidari)','Casa d\'accoglienza di bambine ed adolescenti a rischio di prostituzione e povertà estrema ad Abidjan, Costa d\'Avorio.'),(94,16,'fr','','Foyer d\'accueil de fillettes et d\'adolescentes en situation de risque de protitution et d\'extrême pauvreté à Abidjan, Côte d\'Ivoire.'),(95,16,'de','','Heim für Kinder und Jugendliche, die Prostitution oder extreme Armut erleiden, in Abidjan (Elfenbeinküste)'),(96,17,'en','Asociación Cielo 133','Paediatric hospital project in Addis Abeba (Ethiopia) to give health coverage to more than 400 children.'),(97,17,'pt','Asociación Cielo 133','Projecto clínica pediátrica Addis Abeba (Etiópia) para dar cobertura sanitária a mais de 400 crianças.'),(98,17,'it','Asociación Cielo 133','Progetto clinica pediatrica Addis Abeba (Etiopia) per dare copertura sanitaria a pi&ù di 400 bambini.'),(99,17,'fr','','Projet de clinique pédiatrique à Addis Abeba (Éthiopie) en vue d\'offrir une assistance sanitaire à plus de 400 enfants. '),(100,17,'de','','Projekt für ein Kinderkrankenhaus in Addis Abeba (Äthiopien), das die medizinische Versorgung von mehr als 400 Kindern gewährleistet.'),(101,18,'en','Fundación Ami (International Medical Assistancy)','Mesa de Sao Lazaro project: a global project aimed at refurbishing a children\'s shelter in Mozambique, providing them with healthcare and medical aid.'),(102,18,'pt','','Projeto Mesa de São Lázaro: projeto global dirigido à recuperação de um centro de acolhimento de crianças em Moçambique, para lhes proporcionar ajuda sanitária '),(103,18,'it','','Progetto \"Mesa de São Lazaro\": progetto globale volto a ristrutturare un centro di accoglienza per bambini in Mozambico, al fine di fornire loro assistenza sani'),(104,18,'fr','','Projet Mesa de Sao Lazaro : projet intégral visant à rénover un centre d\'accueil pour enfants au Mozambique, à leur offrir une assistance sanitaire et médicale,'),(105,18,'de','','Projekt Mesa von Sao Lazaro: Umfassendes Projekt zur Renovierung eines Kinderheims in Mozambique zur Gewährleistung medizinischer Versorgung.'),(106,19,'en','Arsis Foundation','Drinking water capture and conduction to African villages in the western region of Cameroon.'),(107,19,'pt','','Projeto de captação e condução de água potável para algumas aldeias africanas da região oeste dos Camarões.'),(108,19,'it','','Progetto di captazione e fornitura di acqua potabile ad alcuni villaggi africani della regione occidentale del Camerun.'),(109,19,'fr','Fondation Arsis','Projet de captage et de distribution d\'eau potable à plusieurs villages de l\'ouest du Cameroun.'),(110,19,'de','','Projekt zum Auffangen und zur Leitung von Trinkwasser zu einigen afrikanischen Völkern im Westen von Kamerun.'),(111,20,'en','Intercanvi','Construction of four garden schools for 280 children aged 3 to 6 in the region of Bafat, Guinea Bissau.'),(112,20,'pt','','Construção de quatro jardins de infância para 280 rapazes e raparigas dos 3 aos 6 anos na região de Bafatá, Guiné-Bissau.'),(113,20,'it','','Costruzione di quattro scuole materne per 280 bambini e bambine dai 3 ai 6 anni nella regione di Bafatà, Guinea Bissau'),(114,20,'fr','','Construction de quatre écoles jardins pour 280 enfants âgés de 3 à 6 ans, dans la région de Bafatá, Guinée-Bissao.'),(115,20,'de','','Bau von von 4 Schulen unter freiem Himmel für 280 Kinder von 3 bis 6 Jahren in der Region Bafat, Guinea Bissau.'),(116,21,'en','Hospital Sant Joan de Déu','Project for the treatment of Burkitt lymphoma in Sierra Leone '),(117,21,'pt','','Projeto para o tratamento do linfoma de Burkitt, na Serra Leoa.'),(118,21,'it','','Progetto per il trattamento del linfoma di Burkitt in Sierra Leone.'),(119,21,'fr','Hôpital Sant Joan de Déu','Projet pour le traitement du lymphome de Burkitt en Sierra Leone.'),(120,21,'de','','Projekt zur Behandlung des Burkitt-Lymphoms in Sierra Leone.'),(121,22,'en','Vicente Ferrer Foundation','Child vaccination project at the Bathalapalliu Hospital, Anantapur (India)'),(122,22,'pt','','Projeto de vacinação infantil no Hospital de Bathalapalli. Anantapur (Índia).'),(123,22,'it','','Progetto di vaccinazione dei bambini presso l\'Ospedale di Bathalapalli. Anantapur (India).'),(124,22,'fr','Fondation Vicente Ferrer','Projet de vaccination des enfants à l\'hôpital de Bathalapalli, district d\'Anantapur (Inde).'),(125,22,'de','','Projekt zur Kinderimpfung im Krankenhaus von Bathalapalli, Anantapur (Indien).'),(126,23,'en','Care highway International','Home for orphan children in Kenya (Africa)'),(127,23,'pt','Care highway International','Lar da infância para as crianças orfăs do Quênia (África)'),(128,23,'it','Care highway International','Casa d\'infanzia per bambini orfani in Kenia (Africa)'),(129,23,'fr','Care highway International','Orphelinat pour enfants du Kenya (Afrique).'),(130,23,'de','','Waisenhaus für Kinder in Kenia (Afrika)'),(131,24,'en','Sonrisas de Bombay (Bombay Smiles)','Guaranteed access to education to 2.500 children in the state of Maharasthra (India).'),(132,24,'pt','Sorrisos de Bombay','Garante à 2.500 crianças do Estado de Maharasthra (Índia) o acesso à educaçăo.'),(133,24,'it','Sorrisi di Bombay','Garantire a 2.500 bambini dello stato del Maharasthra (India) l\'insegnamento scolastico.'),(134,24,'fr','Sonrisas de Bombay','Projet visant à offrir un accès à l\'éducation à 2 500 enfants de l\'État de Maharasthra (Inde).'),(135,24,'de','','Gewährleistung eines Bildungszugangs für 2.500 Kinder im Staat Maharashtra (Indien).'),(136,25,'en','Medicus Mundi Cantabria','Building of a maternity hospital in Nafadji (Bamako-Mali).'),(137,25,'pt','Medicus Mundi Cantabria','Construçăo de uma maternidade em Nafadji (Bamako-Mali).'),(138,25,'it','Medicus Mundi Cantabria','Costruzione di un ospedale con reparto maternità a Nafadji (Bamako-Mali).'),(139,25,'fr','Medicus Mundi Cantabrie','Construction d\'une maternité à Nafadji (Bamako, Mali).'),(140,25,'de','','Bau eines Geburtshauses in Nafadji (Bamako-Mali).'),(141,26,'en','Asociación Amigos de Orfanato Estrella del Mañana en India','School for blind children in Mungod, Karnnataka (India).'),(142,26,'pt','Asociación Amigos de Orfanato Estrella del Mañana en India','Escola de crianças cegas de Mungod em Karnnataka (Índia).'),(143,26,'it','Asociación Amigos de Orfanato Estrella del Mañana en India','Scuola per bambini non vedenti di Mungod a Karnnataka (India).'),(144,26,'fr','Association Amigos de Orfanato Estrella de la Mañana en Indi','École pour enfants aveugles à Mundgod, dans l\'État du Karnnataka (Inde).'),(145,26,'de','','Schule für blinde Kinder in Mungod, Karnnataka (Indien).'),(146,27,'en','Fundación Infancia de Hoy (Childhood of today Foundation)','Home for orphan children in Kenya (Africa).'),(147,27,'pt','Fundaçăo infância de hoje','Lar da infância para as crianças orfăs do Quênia (África).'),(148,27,'it','Fondazione per l\'infanzia di oggi','Casa d\'infanzia per bambini orfani in Kenia (Africa).'),(149,27,'fr','Fondation infancia de hoy','Orphelinat pour enfants du Kenya (Afrique). '),(150,27,'de','','Waisenhaus für Kinder in Kenia (Afrika)'),(151,28,'en','Alpicat Solidari','Baja Kunda -Aplicat Solidari (Gambia) '),(152,28,'pt','','Baja Kunda - Alpicat Solidari.'),(153,28,'it','','Progetto Baja Kunda - Alpicat Solidari.'),(154,28,'fr','Alpicat Solidari','Baja Kunda - Alpicat Solidari.'),(155,28,'de','','Baja Kunda - Alpicat Solidari.'),(156,29,'en','Kumara-Children of the world','Project for building a children dorm in the home of Santa Teresa de Avila.'),(157,29,'pt','Kumara-Infância do mundo','Projeto para a para a construçăo de um dormitório infantil no lar santa Teresa de Avila.'),(158,29,'it','Kumara-Infanzia del mondo','Progetto per la costruzione di un dormitorio per bambini nella casa d\'infanzia di Santa Teresa di Avila.'),(159,29,'fr','Kumara-Infancia del mundo','Projet de construction d\'un dortoir pour enfants dans le foyer Santa Teresa de Ávila, à Sarapaka, État d\'Andhra Pradesh  (Inde)'),(160,29,'de','','Projekt zum Bau eines Schlafraums im Kinderheim Santa Teresa in Avila.'),(161,30,'en','Kumara-Children of the World','Project \"Being able to live\", guaranteeing quality of life for girls affected with AIDS.'),(162,30,'pt','Kumara-Infância do mundo','Projeto poder viver, qualidade de vida para meninas afetadas pela AIDS.'),(163,30,'it','Kumara-Infanzia del mondo','Progetto diritto alla vita e qualità di vita per bambini malati di AIDS.'),(164,30,'fr','Kumara-Infancia del mundo','Projet « pouvoir vivre et qualité de vie » pour fillettes affectées par le SIDA, Bombay (Inde).'),(165,30,'de','','Projekt ‚Leben können’, Lebensqualität für Kinder mit AIDS.'),(166,31,'en','África Directo (Direct Africa)','Program to get children out of the streets in Goma.'),(167,31,'pt','África Directo','Programa de recuperaçao da rua em Goma.'),(168,31,'it','África Directo','Programma di accoglienza di bambini della strada a Goma.'),(169,31,'fr','','Programme de réhabilitation d\'enfants des rues à Goma (République démocratique du Congo).'),(170,31,'de','','Auffangprogramm für Straßenkinder in Goma'),(171,32,'en','Orphanage Africa','Construction of Orphanage Africa Children\'s Home, Dodowa (Ghana).'),(172,32,'pt','','Construção do orfanato Africa children\'s home, Dodowa (Gana).'),(173,32,'it','','Costruzione dell\'orfanotrofio orphanage africa children\'s home, Dodowa (Ghana).'),(174,32,'fr','','Construction d\'un orphelinat à Dodowa (Ghana).'),(175,32,'de','','Bau eines Waisenhauses, Dodowa (Ghana).'),(176,33,'en','Missionaries of Mary Mediator','Request of financing to build an elderly home.'),(177,33,'pt','Missionárias de Maria Mediadora','Pedido de financiamento para construir un lar para idosos.'),(178,33,'it','Missionarie di Maria Mediadora','Richiesta di fondi per costruire una residenza per anziani.'),(179,33,'fr','Missionnaires de Marie Médiatrice ','Demande de financement pour la construction d\'un foyer pour personnes âgées.'),(180,33,'de','','Antrag auf Finanzierung eines Altenheims'),(181,34,'en','Vicente Ferrer Foundation','Project from the Vicente Ferrer Foundation for the Anantapur district - India.'),(182,34,'pt','Fundaçao Vicente Ferrer','Projeto da Fundaçao Vicente Ferrer para o distrito de Anantapur - India.'),(183,34,'it','Fondazione Vicente Ferrer','Progetto della fondazione Vicente Ferrer ad Anantapur - India.'),(184,34,'fr','Fondation Vicente Ferrer','Projet de la fondation Vicente Ferrer pour le district d\'Anantapur (Inde).'),(185,34,'de','','Projekt der Stiftung Vicente Ferrer für den Bezirk Anantapur - Indien.'),(186,35,'en','Friends of the Adivasis','Help to the street children in Ganeshpuri, India'),(187,35,'pt','','Ajuda aos meninos de rua. - Ganeshpuri, Índia.'),(188,35,'it','','Aiuto ai bambini di strada. - Ganeshpuri, India.'),(189,35,'fr','','Aide aux enfants des rues, Ganeshpuri, Inde.'),(190,35,'de','','Hilfe für Straßenkinder. - Ganeshpuri, Indien.'),(191,36,'en','ADALI','Warm Tokmok. Direct aid to children.- Republic of Kyrgyzstan'),(192,36,'pt','','Aquecer Tokmok. Ajuda direta à infância. - República do Quirquistão.'),(193,36,'it','','Scalda Tokmok. Aiuto diretto all\'infanzia. - Repubblica di Kirghizistan.'),(194,36,'fr','','Calienta Tokmok. Aide directe à l\'enfance, République du Kirghizistan. '),(195,36,'de','','Calienta Tokmok. Hilfe für Kinder. - Republik Kirgisistan.'),(196,37,'en','Kusi Warma Association','Nutritional recovery and family rehabilition for badly undernourished children in Perú.'),(197,37,'pt','Associaçao Kusi Warma','Recuperaçao nutricional e reabilitaçao familiar de crianças com desnutriçao grave em Perú.'),(198,37,'it','Associazione Kusi Warma','Aiuti alimentari e famigliari per i bambini con gravi problemi di denutrizione in Perù.'),(199,37,'fr','Association Kusi Warma','Stabilisation nutritionnelle et réhabilitation familiale d\'enfants souffrant d\'une grave dénutrition au Pérou. '),(200,37,'de','','Hilfe für unterernährte Kinder und Unterstützung von Familien mit stark unterernährten Kindern in Peru.'),(201,38,'en','Children\'s house of the Raval','Marhaba'),(202,38,'pt','','Marhaba (Bem-vindo).'),(203,38,'it','','Marhaba.'),(204,38,'fr','','Marhaba.'),(205,38,'de','','Marhaba.'),(206,39,'en','Blas Mendez Ponce Foundation','Help Children with Oncological Diseases.'),(207,39,'pt','Fundaçao Blas Méndez Ponce','Ajuda às crianças (uda al niÅ„o oncológico).'),(208,39,'it','Fondazione Blas Mndez Ponce','Aiuti a bambini malati di cancro.'),(209,39,'fr','Fondation Blas Méndez Ponce','Aide aux enfants souffrant de cancer.'),(210,39,'de','','Hilfe für onkologische Kinder'),(211,40,'en','Natura Foundation','Conservation of mature forests for the people and bears of the Pyrenees. - Spain.'),(212,40,'pt','','Preservação das florestas primitivas para as pessoas e dos ursos dos Pirenéus - Espanha.'),(213,40,'it','','Conservazione dei vecchi boschi per le persone e gli orsi dei Pirenei - Spagna.'),(214,40,'fr','Fondation Natura','Conservation des forêts matures pour les personnes et les ours dans les Pyrénées, Espagne.'),(215,40,'de','','Bewahrung der Wälder für Menschen und Bären in den Pyrenäen - Spanien.'),(216,41,'en','Tierra del Hombre','Specialised medical care- A journey towards Life- Madrid, Seville and Malaga.'),(217,41,'pt','','Assistência médica especializada - Viagem para a Vida - Madrid, Sevilha e Málaga.'),(218,41,'it','','Prestazioni mediche specializzate - Viaggio verso la Vita - Madrid, Siviglia e Malaga.'),(219,41,'fr','Terre des Hommes','Assitance médicale spécialisée - Voyage vers la vie - Madrid, Séville et Malaga (Espagne). '),(220,41,'de','','Spezielle medizinische Behandlungen - Reise zum Leben - Madrid, Sevilla und Málaga.'),(221,42,'en','Nous Camins','Infrastructure and special aid for the treatment of contagious diseases in children of the \'Habari Njema\' centre. Kibagare, Nairobi.'),(222,42,'pt','','Infraestrutura e assistência especial para o tratamento de doenças contagiosas das crianças do centro \'Habari Njema\'. - Kibagare, Nairobi.'),(223,42,'it','','Infrastrutture ed assistenza speciale per il trattamento delle malattie contagiose dei bambini del centro \'Habari Njema\'. - Kibagare, Nairobi.'),(224,42,'fr','','Infrastructures et assistance médicale spécialisée pour le traitement de maladies contagieuses des enfants du centre Habari Njema, Kibagare, Nairobi (Kenya).'),(225,42,'de','','Infrastruktur und Sonderbetreuung für die Behandlung von ansteckenden Krankheiten bei Kindern im ‚Habari Njema-Zentrum’. - Kibagare, Nairobi.'),(226,43,'en','Medicus Mundi','Infrastructure and special aid for the treatment of diseases in children of the Habari Njema Centre. - Kibagare, Nairobi.'),(227,43,'pt','','Infraestrutura e assistência especial para o tratamento de doenças das crianças do centro Habari Njema. - Kibagare, Nairobi.'),(228,43,'it','','Infrastrutture ed assistenza speciale per il trattamento delle malattie dei bambini del centro Habari Njema. - Kibagare, Nairobi'),(229,43,'fr','','Infrastructures et assistance médicale spécialisée pour le traitement des maladies des enfants du centre Habari Njema, Kibagare, Nairobi (Kenya).'),(230,43,'de','','Infrastruktur und Sonderbetreuung für die Behandlung von Kranken im Habari Njema-Zentrum. - Kibagare, Nairobi'),(231,44,'en','Manos Unidas','Building of a school where classes will be given in Telugu, the autochthonous language.'),(232,44,'pt','Manos Unidas','Construçao de uma escola onde se impartirao a educaçao em Telugu. Língua vernácula.'),(233,44,'it','Manos Unidas','di una scuola dove l\'insegnamento sarà in Telugu, lingua vernacola.'),(234,44,'fr','','Construction d\'une école à Banaganapalle,où l\'enseignement sera dispensé en Télougou, langue de l\'État d\'Andhra Pradesh (Inde).'),(235,44,'de','','Bau einer Schule, in der der Unterricht in Telugu erfolgt, der einheimischen Sprache.'),(236,45,'en','Medicos sin fronteras','Doctors Without Borders Project'),(237,45,'pt','','Projeto Médicos sem Fronteiras'),(238,45,'it','','Progetto Medici senza Frontiere'),(239,45,'fr','','Projet de Médecins sans frontière'),(240,45,'de','','Projekt ‚Ärzte ohne Grenzen’'),(241,46,'en','Survival Internacional','International Survival Project'),(242,46,'pt','','Projeto Survival Internacional'),(243,46,'it','','Progetto Survival Internacional'),(244,46,'fr','','Projet de Survival Internacional'),(245,46,'de','','Projekt ‚Survival International’'),(246,47,'en','Greenpeace','Greenpeace Project'),(247,47,'pt','','Projeto Greenpeace'),(248,47,'it','','Progetto Greenpeace'),(249,47,'fr','','Projet de Greenpeace'),(250,47,'de','','Projekt ‚Greenpeace'),(251,48,'en','ADDA','ADDA Project'),(252,48,'pt','','Projeto ADDA'),(253,48,'it','','Progetto ADDA'),(254,48,'fr','','Projet d\'ADDA'),(255,48,'de','','Projekt ‚ADDA’'),(256,49,'en','Ayuda en Acción','Aid in Action Project'),(257,49,'pt','','Projeto Ajuda em Ação'),(258,49,'it','','Progetto Ayuda en Acción'),(259,49,'fr','','Projet d\'Ayuda en acción'),(260,49,'de','','Projekt‚ Help in Action’'),(261,50,'en','Intermón','Intermón Project'),(262,50,'pt','','Projeto Intermón'),(263,50,'it','','Progetto Intermón'),(264,50,'fr','','Projet d\'Intermón'),(265,50,'de','','Projekt ‚Intermón’'),(266,51,'en','Dian Fossey Gorilla Foundation','The Dian Fossey Gorilla Fund International'),(267,51,'pt','','Projeto Dian Fossey Gorilla Foundation'),(268,51,'it','','Progetto Dian Fossey Gorilla Foundation'),(269,51,'fr','Dian Fossey Gorilla Foundation','Projet de la fondation Dian Fossey Gorilla Foundation'),(270,51,'de','','Projekt ‚Dian Fossey Gorilla Foundation’'),(271,52,'en','Ayuda en Acción (Nepal) Amount: 30.591€','Inclusive education for children with auditive disabilities in Nepal'),(272,52,'pt','',''),(273,52,'it','',''),(274,52,'fr','',''),(275,52,'de','',''),(276,53,'en','ACOES (Honduras) Amount: 30.119€','Self-building of houses in the community of Goviado through training of traditional and autochthonous techniques'),(277,53,'pt','',''),(278,53,'it','',''),(279,53,'fr','',''),(280,53,'de','',''),(281,54,'en','Fundación Guné (Senegal) Amount: 23.200€','Contribution to the socioeconomic development of the Kolda region through agricultural revitalizing and strengthening of agricultural cooperatives '),(282,54,'pt','',''),(283,54,'it','',''),(284,54,'fr','',''),(285,54,'de','',''),(286,55,'en','Sol Solidari (Burkina Faso) Amount: 10.260€','Promotion of the use of solar energy in the schools of Ouagadougou'),(287,55,'pt','',''),(288,55,'it','',''),(289,55,'fr','',''),(290,55,'de','',''),(291,56,'en','África nos mira (Etiopía) Amount 26.000€','Expansion and equipping of a school of education and its associated services for access to potable water'),(292,56,'pt','',''),(293,56,'it','',''),(294,56,'fr','',''),(295,56,'de','',''),(296,57,'en','Naya Nagar (India) Amount 23.450,84€','Strengthen the training center for women, the school Mera Parivar and the \"Right to Identity\" program'),(297,57,'pt','',''),(298,57,'it','',''),(299,57,'fr','',''),(300,57,'de','',''),(301,58,'en','Vicente Ferrer (India) Dotación 20.611€','Improving the situation of women in rural areas by providing cattle for milk production'),(302,58,'pt','',''),(303,58,'it','',''),(304,58,'fr','',''),(305,58,'de','',''),(306,59,'en','REDI (Guatemala) Donation € 22,243','FIGHTING CHILDREN MALNUTRITION '),(307,59,'pt','',''),(308,59,'it','',''),(309,59,'fr','',''),(310,59,'de','',''),(311,60,'en','',''),(312,60,'pt','',''),(313,60,'it','',''),(314,60,'fr','',''),(315,60,'de','',''),(316,61,'en','',''),(317,61,'pt','',''),(318,61,'it','',''),(319,61,'fr','',''),(320,61,'de','',''),(321,62,'en','Movimiento por la Paz (Níger) Dotation € 25.306','MODEL MOTHERS'),(322,62,'pt','',''),(323,62,'it','',''),(324,62,'fr','',''),(325,62,'de','',''),(326,63,'en','Fundación de Solidaridad Amaranta (Togo) Dotation € 24.603','HUMAN TRAFFICKING'),(327,63,'pt','',''),(328,63,'it','',''),(329,63,'fr','',''),(330,63,'de','',''),(331,64,'en','Colabora Birmania (Birmania) Dotation € 19.138','CONSTRUCTION OF BRIDGE FOR EDUCATION '),(332,64,'pt','',''),(333,64,'it','',''),(334,64,'fr','',''),(335,64,'de','',''),(336,65,'en','',''),(337,65,'pt','',''),(338,65,'it','',''),(339,65,'fr','',''),(340,65,'de','',''),(341,66,'en','',''),(342,66,'pt','',''),(343,66,'it','',''),(344,66,'fr','',''),(345,66,'de','',''),(346,67,'en','',''),(347,67,'pt','',''),(348,67,'it','',''),(349,67,'fr','',''),(350,67,'de','',''),(351,68,'en','Livelihoods for refugees',''),(352,68,'pt','',''),(353,68,'it','',''),(354,68,'fr','',''),(355,68,'de','',''),(356,69,'en','Rights for girls living in the street',''),(357,69,'pt','',''),(358,69,'it','',''),(359,69,'fr','',''),(360,69,'de','',''),(361,70,'en','Basic literacy project to prevent child labour',''),(362,70,'pt','',''),(363,70,'it','',''),(364,70,'fr','',''),(365,70,'de','','');
107/*!40000 ALTER TABLE `t_project_lang` ENABLE KEYS */;
108UNLOCK TABLES;
109
110--
111-- Table structure for table `t_categoriesproject`
112--
113
114DROP TABLE IF EXISTS `t_categoriesproject`;
115/*!40101 SET @saved_cs_client     = @@character_set_client */;
116/*!40101 SET character_set_client = utf8 */;
117CREATE TABLE `t_categoriesproject` (
118  `id` int(11) NOT NULL AUTO_INCREMENT,
119  `nombre` varchar(255) CHARACTER SET utf8 NOT NULL,
120  `color` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
121  PRIMARY KEY (`id`)
122) ENGINE=MyISAM AUTO_INCREMENT=16 DEFAULT CHARSET=latin1;
123/*!40101 SET character_set_client = @saved_cs_client */;
124
125--
126-- Dumping data for table `t_categoriesproject`
127--
128
129LOCK TABLES `t_categoriesproject` WRITE;
130/*!40000 ALTER TABLE `t_categoriesproject` DISABLE KEYS */;
131INSERT INTO `t_categoriesproject` VALUES (1,'Creación de escuelas y apoyo a la educación','c5d9f1'),(2,'Cura de enfermedades y ayuda sanitaria','e6b8b7'),(3,'Defensa de los derechos humanos','fabf8f'),(6,'Protección de la naturaleza y los animales','c4d79b'),(7,'Lucha contra la pobreza y la desigualdad','bfbfbf'),(8,'Centros de ayuda y acogida infantil','ccc0da'),(9,'Programas para paliar la desnutrición','ffc000'),(10,'Hogar de ancianos','92cddc'),(11,'Centros de maternidad','92d050'),(12,'Construccion de viviendas','c4bd97'),(13,'Pozos de agua potable','e26b0a'),(14,'Mejora de áreas rurales','00b050'),(15,'Centros de formación para mujeres','4f81bd');
132/*!40000 ALTER TABLE `t_categoriesproject` ENABLE KEYS */;
133UNLOCK TABLES;
134
135--
136-- Table structure for table `t_categoriesproject_lang`
137--
138
139DROP TABLE IF EXISTS `t_categoriesproject_lang`;
140/*!40101 SET @saved_cs_client     = @@character_set_client */;
141/*!40101 SET character_set_client = utf8 */;
142CREATE TABLE `t_categoriesproject_lang` (
143  `id` int(11) NOT NULL AUTO_INCREMENT,
144  `categoriesproject_id` varchar(255) CHARACTER SET utf8 NOT NULL,
145  `lang_id` char(2) CHARACTER SET utf8 NOT NULL DEFAULT 'en',
146  `nombre` varchar(255) CHARACTER SET utf8 NOT NULL,
147  PRIMARY KEY (`id`),
148  KEY `categoriesproject_id` (`categoriesproject_id`)
149) ENGINE=MyISAM AUTO_INCREMENT=76 DEFAULT CHARSET=latin1;
150/*!40101 SET character_set_client = @saved_cs_client */;
151
152--
153-- Dumping data for table `t_categoriesproject_lang`
154--
155
156LOCK TABLES `t_categoriesproject_lang` WRITE;
157/*!40000 ALTER TABLE `t_categoriesproject_lang` DISABLE KEYS */;
158INSERT INTO `t_categoriesproject_lang` VALUES (10,'1','de',''),(9,'1','fr',''),(8,'1','it',''),(7,'1','pt',''),(6,'1','en','Schools and support for education'),(17,'2','pt',''),(26,'6','en','Nature and animals protection'),(16,'2','en','Disease and Health Care'),(18,'2','it',''),(19,'2','fr',''),(20,'2','de',''),(21,'3','en','Defense of human rights'),(22,'3','pt',''),(23,'3','it',''),(24,'3','fr',''),(25,'3','de',''),(27,'6','pt',''),(28,'6','it',''),(29,'6','fr',''),(30,'6','de',''),(31,'7','en',' Fight against poverty and inequality'),(32,'7','pt',''),(33,'7','it',''),(34,'7','fr',''),(35,'7','de',''),(36,'8','en','Child support and assistance centers'),(37,'8','pt',''),(38,'8','it',''),(39,'8','fr',''),(40,'8','de',''),(41,'9','en','Programs to alleviate malnutrition'),(42,'9','pt',''),(43,'9','it',''),(44,'9','fr',''),(45,'9','de',''),(46,'10','en','home for the elderly'),(47,'10','pt',''),(48,'10','it',''),(49,'10','fr',''),(50,'10','de',''),(51,'11','en','Maternity centers'),(52,'11','pt',''),(53,'11','it',''),(54,'11','fr',''),(55,'11','de',''),(56,'12','en','Home building'),(57,'12','pt',''),(58,'12','it',''),(59,'12','fr',''),(60,'12','de',''),(61,'13','en','Potable water wells'),(62,'13','pt',''),(63,'13','it',''),(64,'13','fr',''),(65,'13','de',''),(66,'14','en',' Improvement on rural areas'),(67,'14','pt',''),(68,'14','it',''),(69,'14','fr',''),(70,'14','de',''),(71,'15','en','Education Centers for Women'),(72,'15','pt',''),(73,'15','it',''),(74,'15','fr',''),(75,'15','de','');
159/*!40000 ALTER TABLE `t_categoriesproject_lang` ENABLE KEYS */;
160UNLOCK TABLES;
161
162--
163-- Table structure for table `t_country`
164--
165
166DROP TABLE IF EXISTS `t_country`;
167/*!40101 SET @saved_cs_client     = @@character_set_client */;
168/*!40101 SET character_set_client = utf8 */;
169CREATE TABLE `t_country` (
170  `id` char(2) CHARACTER SET ascii NOT NULL,
171  `name` varchar(80) NOT NULL,
172  `active` tinyint(1) unsigned NOT NULL DEFAULT '0',
173  `shipzone_id` int(10) unsigned DEFAULT NULL,
174  `vat` tinyint(1) unsigned NOT NULL DEFAULT '0',
175  `active_fr` tinyint(1) unsigned NOT NULL DEFAULT '1',
176  `countrytypes_id` int(10) unsigned DEFAULT NULL,
177  PRIMARY KEY (`id`),
178  KEY `shipzone_id` (`shipzone_id`),
179  CONSTRAINT `t_country_ibfk_1` FOREIGN KEY (`shipzone_id`) REFERENCES `t_shipzone` (`id`) ON DELETE SET NULL
180) ENGINE=InnoDB DEFAULT CHARSET=utf8;
181/*!40101 SET character_set_client = @saved_cs_client */;
182
183--
184-- Dumping data for table `t_country`
185--
186
187LOCK TABLES `t_country` WRITE;
188/*!40000 ALTER TABLE `t_country` DISABLE KEYS */;
189INSERT INTO `t_country` VALUES ('AD','Andorra',1,1,0,1,2),('AE','Emiratos Árabes Unidos',1,20,0,1,3),('AF','Afganistán',1,20,0,1,3),('AL','Albania',1,18,0,1,3),('AM','Armenia',1,18,0,1,3),('AO','Angola',1,22,0,1,3),('AR','Argentina',1,22,0,1,3),('AT','Austria',1,7,1,1,2),('AU','Australia',1,21,0,1,3),('AZ','Azerbaiyán',1,18,0,1,3),('BA','Bosnia-Herzegovina',1,18,0,1,3),('BD','Bangladesh',1,19,0,1,3),('BE','Bélgica',1,7,1,1,2),('BF','Burkina Faso',1,22,0,1,3),('BG','Bulgaria',1,10,1,1,2),('BH','Bahréin',1,20,0,1,3),('BI','Burundi',1,22,0,1,3),('BJ','Benín',1,19,0,1,3),('BN','Brunéi',1,19,0,1,3),('BO','Bolivia',1,22,0,1,3),('BR','Brasil',1,22,0,1,3),('BT','Bután',1,22,0,1,3),('BW','Botsuana',1,22,0,1,3),('BY','Bielorrusia',1,18,0,1,3),('CA','Canadá',1,16,0,1,3),('CD','República Democrática del Congo',1,22,0,1,3),('CF','República Centroafricana',1,22,0,1,3),('CG','Congo - Brazzaville',1,22,0,1,3),('CH','Suiza',1,10,0,1,3),('CI','Costa de Marfil',1,22,0,1,3),('CL','Chile',1,22,0,1,3),('CM','Camerún',1,22,0,1,3),('CN','China',1,19,0,1,3),('CO','Colombia',1,22,0,1,3),('CR','Costa Rica',1,22,0,1,3),('CS','Serbia y Montenegro',1,19,0,1,3),('CU','Cuba',1,22,0,1,3),('CY','Chipre',1,15,1,1,2),('CZ','República Checa',1,7,1,1,2),('DE','Alemania',1,7,1,1,2),('DJ','Yibuti',1,22,0,1,3),('DK','Dinamarca',1,7,1,1,2),('DO','República Dominicana',1,22,0,1,3),('DZ','Argelia',1,22,0,1,3),('E2','España (Baleares)',1,4,1,1,1),('E3','España (Canarias, Ceuta o Melilla)',1,13,0,1,3),('EC','Ecuador',1,22,0,1,3),('EE','Estonia',1,18,0,1,3),('EG','Egipto',1,20,0,1,3),('EH','Sáhara Occidental',1,22,0,1,3),('ER','Eritrea',1,22,0,1,3),('ES','España (Península)',1,1,1,1,1),('ET','Etiopía',1,22,0,1,3),('FI','Finlandia',1,10,1,1,2),('FR','Francia',1,7,1,1,2),('GA','Gabón',1,22,0,1,3),('GB','Reino Unido',1,7,1,1,2),('GD','Granada',1,21,0,1,3),('GE','Georgia',1,18,0,1,3),('GF','Guayana Francesa',1,22,0,1,3),('GH','Ghana',1,22,0,1,3),('GI','Gibraltar',1,13,0,1,3),('GM','Gambia',1,22,0,1,3),('GN','Guinea',1,22,0,1,3),('GQ','Guinea Ecuatorial',1,22,0,1,3),('GR','Grecia',1,10,1,1,2),('GT','Guatemala',1,22,0,1,3),('GU','Guam',1,22,0,1,3),('GW','Guinea-Bissau',1,22,0,1,3),('GY','Guyana',1,22,0,1,3),('HK','Hong Kong [República Popular China]',1,19,0,1,3),('HN','Honduras',1,22,0,1,3),('HR','Croacia',1,18,0,1,3),('HT','Haití',1,21,0,1,3),('HU','Hungría',1,7,1,1,2),('ID','Indonesia',1,19,0,1,3),('IE','Irlanda',1,7,1,1,2),('IL','Israel',1,20,0,0,3),('IN','India',1,19,0,1,3),('IQ','Iraq',1,20,0,1,3),('IR','Irán',1,20,0,1,3),('IS','Islandia',1,17,1,1,2),('IT','Italia',1,7,1,1,2),('JM','Jamaica',1,22,0,1,3),('JO','Jordania',1,20,0,1,3),('JP','Japón',1,21,0,1,3),('KE','Kenia',1,22,0,1,3),('KG','Kirguistán',1,22,0,1,3),('KH','Camboya',1,19,0,1,3),('KP','Corea del Norte',1,21,0,1,3),('KR','Corea del Sur',1,21,0,1,3),('KW','Kuwait',1,20,0,1,3),('KZ','Kazajistán',1,18,0,1,3),('LA','Laos',1,19,0,1,3),('LB','Líbano',1,20,0,1,3),('LI','Liechtenstein',1,18,0,1,3),('LK','Sri Lanka',1,22,0,1,3),('LR','Liberia',1,22,0,1,3),('LS','Lesoto',1,22,0,1,3),('LT','Lituania',1,7,0,1,3),('LU','Luxemburgo',1,7,1,1,2),('LV','Letonia',1,7,0,1,3),('LY','Libia',1,20,0,1,3),('MA','Marruecos',1,20,0,1,3),('MC','Mónaco',1,15,0,1,3),('MD','Moldavia',1,18,0,1,3),('ME','Montenegro',1,18,0,1,3),('MG','Madagascar',1,NULL,0,1,3),('MK','Macedonia',1,22,0,1,3),('ML','Mali',1,22,0,1,3),('MM','Myanmar [Birmania]',1,21,0,1,3),('MN','Mongolia',1,18,0,1,3),('MO','Macao [República Popular China]',1,22,0,1,3),('MR','Mauritania',1,20,0,1,3),('MT','Malta',1,15,1,1,2),('MX','México',1,22,0,1,3),('MY','Malasia',1,20,0,1,3),('MZ','Mozambique',1,22,0,1,3),('NA','Namibia',1,22,0,1,3),('NC','Nueva Caledonia',1,22,0,1,3),('NE','Níger',1,22,0,1,3),('NG','Nigeria',1,22,0,1,3),('NI','Nicaragua',1,22,0,1,3),('NL','Países Bajos',1,7,1,1,2),('NO','Noruega',1,17,1,1,2),('NP','Nepal',1,19,0,1,3),('NZ','Nueva Zelanda',1,21,0,1,3),('OM','Omán',1,22,0,1,3),('PA','Panamá',1,22,0,1,3),('PE','Perú',1,22,0,1,3),('PG','Papúa Nueva Guinea',1,22,0,1,3),('PH','Filipinas',1,22,0,1,3),('PK','Pakistán',1,19,0,1,3),('PL','Polonia',1,7,0,1,3),('PR','Puerto Rico',1,22,0,1,3),('PT','Portugal',1,1,1,1,2),('PY','Paraguay',1,22,0,1,3),('QA','Qatar',1,16,0,1,3),('RO','Rumanía',1,10,0,1,3),('RS','Serbia',1,19,0,1,3),('RU','Rusia',1,NULL,0,1,3),('RW','Ruanda',1,22,0,1,3),('SA','Arabia Saudí',1,20,0,1,3),('SD','Sudán',1,22,0,1,3),('SE','Suecia',1,10,1,1,2),('SG','Singapur',1,19,0,1,3),('SI','Eslovenia',1,7,0,1,3),('SK','Eslovaquia',1,7,0,1,3),('SL','Sierra Leona',1,22,0,1,3),('SN','Senegal',1,22,0,1,3),('SO','Somalia',1,22,0,1,3),('SR','Surinam',1,22,0,1,3),('SV','El Salvador',1,22,0,1,3),('SY','Siria',1,20,0,1,3),('TD','Chad',1,22,0,1,3),('TG','Togo',1,22,0,1,3),('TH','Tailandia',1,19,0,1,3),('TJ','Tayikistán',1,22,0,1,3),('TM','Turkmenistán',1,22,0,1,3),('TN','Túnez',1,22,0,1,3),('TR','Turquía',1,13,0,1,3),('TW','Taiwán',1,22,0,1,3),('TZ','Tanzania',1,22,0,1,3),('UA','Ucrania',1,22,0,1,3),('UG','Uganda',1,22,0,1,3),('US','Estados Unidos',1,16,0,1,3),('UY','Uruguay',1,22,0,1,3),('UZ','Uzbekistán',1,22,0,1,3),('VE','Venezuela',1,22,0,1,3),('VN','Vietnam',1,19,0,1,3),('YE','Yemen',1,19,0,1,3),('ZA','Sudáfrica',1,22,0,1,3),('ZM','Zambia',1,22,0,1,3),('ZW','Zimbabue',1,22,0,1,3);
190/*!40000 ALTER TABLE `t_country` ENABLE KEYS */;
191UNLOCK TABLES;
192
193--
194-- Table structure for table `t_country_lang`
195--
196
197DROP TABLE IF EXISTS `t_country_lang`;
198/*!40101 SET @saved_cs_client     = @@character_set_client */;
199/*!40101 SET character_set_client = utf8 */;
200CREATE TABLE `t_country_lang` (
201  `country_id` char(2) CHARACTER SET ascii NOT NULL,
202  `lang_id` char(2) CHARACTER SET ascii NOT NULL,
203  `name` varchar(80) DEFAULT NULL,
204  PRIMARY KEY (`country_id`,`lang_id`),
205  KEY `lang_id` (`lang_id`),
206  CONSTRAINT `t_country_lang_ibfk_1` FOREIGN KEY (`country_id`) REFERENCES `t_country` (`id`) ON DELETE CASCADE,
207  CONSTRAINT `t_country_lang_ibfk_2` FOREIGN KEY (`lang_id`) REFERENCES `t_lang` (`id`) ON DELETE CASCADE
208) ENGINE=InnoDB DEFAULT CHARSET=utf8;
209/*!40101 SET character_set_client = @saved_cs_client */;
210
211--
212-- Dumping data for table `t_country_lang`
213--
214
215LOCK TABLES `t_country_lang` WRITE;
216/*!40000 ALTER TABLE `t_country_lang` DISABLE KEYS */;
217INSERT INTO `t_country_lang` VALUES ('AD','de','Andorra'),('AD','en','Andorra'),('AD','fr','Andorre'),('AD','it',''),('AD','pt',''),('AE','de','United Arab Emirates'),('AE','en','United Arab Emirates'),('AE','fr','Émirats arabes unis'),('AE','it',''),('AE','pt',''),('AF','de','Afghanistan'),('AF','en','Afghanistan'),('AF','fr','Afghanistan'),('AF','it',''),('AF','pt',''),('AL','de','Albania'),('AL','en','Albania'),('AL','fr','Albanie'),('AL','it',''),('AL','pt',''),('AM','de','Armenia'),('AM','en','Armenia'),('AM','fr','Arménie'),('AM','it',''),('AM','pt',''),('AO','de','Angola'),('AO','en','Angola'),('AO','fr','Angola'),('AO','it',''),('AO','pt',''),('AR','de','Argentina'),('AR','en','Argentina'),('AR','fr','Argentine'),('AR','it',''),('AR','pt',''),('AT','de',''),('AT','en','Austria'),('AT','fr','Autriche'),('AT','it',''),('AT','pt',''),('AU','de','Australia'),('AU','en','Australia'),('AU','fr','Australie'),('AU','it',''),('AU','pt',''),('AZ','de','Azerbaijan'),('AZ','en','Azerbaijan'),('AZ','fr','Azerbaïdjan'),('AZ','it',''),('AZ','pt',''),('BA','de','Bosnia and Herzegovina'),('BA','en','Bosnia and Herzegovina'),('BA','fr','Bosnie-Herzégovine'),('BA','it',''),('BA','pt',''),('BD','de','Bangladesh'),('BD','en','Bangladesh'),('BD','fr','Bangladesh'),('BD','it',''),('BD','pt',''),('BE','de','Belgium'),('BE','en','Belgium'),('BE','fr','Belgique'),('BE','it',''),('BE','pt',''),('BF','de','Burkina Faso'),('BF','en','Burkina Faso'),('BF','fr','Burkina Faso'),('BF','it',''),('BF','pt',''),('BG','de','Bulgaria'),('BG','en','Bulgaria'),('BG','fr','Bulgarie'),('BG','it',''),('BG','pt',''),('BH','de','Bahrain'),('BH','en','Bahrain'),('BH','fr','Bahreïn'),('BH','it',''),('BH','pt',''),('BI','de','Burundi'),('BI','en','Burundi'),('BI','fr','Burundi'),('BI','it',''),('BI','pt',''),('BJ','de','Benin'),('BJ','en','Benin'),('BJ','fr','Bénin'),('BJ','it',''),('BJ','pt',''),('BN','de','Brunei'),('BN','en','Brunei'),('BN','fr','Brunéi Darussalam'),('BN','it',''),('BN','pt',''),('BO','de','Bolivia'),('BO','en','Bolivia'),('BO','fr','Bolivie'),('BO','it',''),('BO','pt',''),('BR','de','Brazil'),('BR','en','Brazil'),('BR','fr','Brésil'),('BR','it',''),('BR','pt',''),('BT','de','Bhutan'),('BT','en','Bhutan'),('BT','fr','Bhoutan'),('BT','it',''),('BT','pt',''),('BW','de','Botswana'),('BW','en','Botswana'),('BW','fr','Botswana'),('BW','it',''),('BW','pt',''),('BY','de','Belarus'),('BY','en','Belarus'),('BY','fr','Bélarus'),('BY','it',''),('BY','pt',''),('CA','de','Canada'),('CA','en','Canada'),('CA','fr','Canada'),('CA','it',''),('CA','pt',''),('CD','de','Congo - Kinshasa'),('CD','en','Congo - Kinshasa'),('CD','fr','République démocratique du Congo'),('CD','it',''),('CD','pt',''),('CF','de','Central African Republic'),('CF','en','Central African Republic'),('CF','fr','République centrafricaine'),('CF','it',''),('CF','pt',''),('CG','de','Congo - Brazzaville'),('CG','en','Congo - Brazzaville'),('CG','fr','Congo-Brazzaville'),('CG','it',''),('CG','pt',''),('CH','de',''),('CH','en','Switzerland'),('CH','fr','Suisse'),('CH','it',''),('CH','pt',''),('CI','de','Côte d’Ivoire'),('CI','en','Côte d’Ivoire'),('CI','fr','Côte d’Ivoire'),('CI','it',''),('CI','pt',''),('CL','de','Chile'),('CL','en','Chile'),('CL','fr','Chili'),('CL','it',''),('CL','pt',''),('CM','de','Cameroon'),('CM','en','Cameroon'),('CM','fr','Cameroun'),('CM','it',''),('CM','pt',''),('CN','de','China'),('CN','en','China'),('CN','fr','Chine'),('CN','it',''),('CN','pt',''),('CO','de','Colombia'),('CO','en','Colombia'),('CO','fr','Colombie'),('CO','it',''),('CO','pt',''),('CR','de','Costa Rica'),('CR','en','Costa Rica'),('CR','fr','Costa Rica'),('CR','it',''),('CR','pt',''),('CS','de','Serbia and Montenegro'),('CS','en','Serbia and Montenegro'),('CS','fr','Serbie-et-Monténégro'),('CS','it',''),('CS','pt',''),('CU','de','Cuba'),('CU','en','Cuba'),('CU','fr','Cuba'),('CU','it',''),('CU','pt',''),('CY','de','Cyprus'),('CY','en','Cyprus'),('CY','fr','Chypre'),('CY','it',''),('CY','pt',''),('CZ','de','Czech Republic'),('CZ','en','Czech Republic'),('CZ','fr','République tchèque'),('CZ','it',''),('CZ','pt',''),('DE','de','Germany'),('DE','en','Germany'),('DE','fr','Allemagne'),('DE','it',''),('DE','pt',''),('DJ','de','Djibouti'),('DJ','en','Djibouti'),('DJ','fr','Djibouti'),('DJ','it',''),('DJ','pt',''),('DK','de','Denmark'),('DK','en','Denmark'),('DK','fr','Danemark'),('DK','it',''),('DK','pt',''),('DO','de','Dominican Republic'),('DO','en','Dominican Republic'),('DO','fr','République dominicaine'),('DO','it',''),('DO','pt',''),('DZ','de','Algeria'),('DZ','en','Algeria'),('DZ','fr','Algérie'),('DZ','it',''),('DZ','pt',''),('E2','de','Spain (Balearics)'),('E2','en','Spain (Balearics)'),('E2','fr',''),('E2','it',''),('E2','pt',''),('E3','de','Spain (Canarian)'),('E3','en','Spain (Canarian)'),('E3','fr',''),('E3','it',''),('E3','pt',''),('EC','de','Ecuador'),('EC','en','Ecuador'),('EC','fr','Équateur'),('EC','it',''),('EC','pt',''),('EE','de','Estonia'),('EE','en','Estonia'),('EE','fr','Estonie'),('EE','it',''),('EE','pt',''),('EG','de','Egypt'),('EG','en','Egypt'),('EG','fr','Égypte'),('EG','it',''),('EG','pt',''),('EH','de','Western Sahara'),('EH','en','Western Sahara'),('EH','fr','Sahara occidental'),('EH','it',''),('EH','pt',''),('ER','de','Eritrea'),('ER','en','Eritrea'),('ER','fr','Érythrée'),('ER','it',''),('ER','pt',''),('ES','de','Spain (Iberian Peninsula)'),('ES','en','Spain (Iberian Peninsula)'),('ES','fr','Espagne'),('ES','it',''),('ES','pt',''),('ET','de','Ethiopia'),('ET','en','Ethiopia'),('ET','fr','Éthiopie'),('ET','it',''),('ET','pt',''),('FI','de','Finland'),('FI','en','Finland'),('FI','fr','Finlande'),('FI','it',''),('FI','pt',''),('FR','de','France'),('FR','en','France'),('FR','fr','France'),('FR','it',''),('FR','pt',''),('GA','de','Gabon'),('GA','en','Gabon'),('GA','fr','Gabon'),('GA','it',''),('GA','pt',''),('GB','de','United Kingdom'),('GB','en','United Kingdom'),('GB','fr','Royaume-Uni'),('GB','it',''),('GB','pt',''),('GD','de','Grenada'),('GD','en','Grenada'),('GD','fr','Grenade'),('GD','it',''),('GD','pt',''),('GE','de','Georgia'),('GE','en','Georgia'),('GE','fr','Géorgie'),('GE','it',''),('GE','pt',''),('GF','de','French Guiana'),('GF','en','French Guiana'),('GF','fr','Guyane française'),('GF','it',''),('GF','pt',''),('GH','de','Ghana'),('GH','en','Ghana'),('GH','fr','Ghana'),('GH','it',''),('GH','pt',''),('GI','de','Gibraltar'),('GI','en','Gibraltar'),('GI','fr','Gibraltar'),('GI','it',''),('GI','pt',''),('GM','de','Gambia'),('GM','en','Gambia'),('GM','fr','Gambie'),('GM','it',''),('GM','pt',''),('GN','de','Guinea'),('GN','en','Guinea'),('GN','fr','Guinée'),('GN','it',''),('GN','pt',''),('GQ','de','Equatorial Guinea'),('GQ','en','Equatorial Guinea'),('GQ','fr','Guinée équatoriale'),('GQ','it',''),('GQ','pt',''),('GR','de','Greece'),('GR','en','Greece'),('GR','fr','Grèce'),('GR','it',''),('GR','pt',''),('GT','de','Guatemala'),('GT','en','Guatemala'),('GT','fr','Guatemala'),('GT','it',''),('GT','pt',''),('GU','de','Guam'),('GU','en','Guam'),('GU','fr','Guam'),('GU','it',''),('GU','pt',''),('GW','de','Guinea-Bissau'),('GW','en','Guinea-Bissau'),('GW','fr','Guinée-Bissau'),('GW','it',''),('GW','pt',''),('GY','de','Guyana'),('GY','en','Guyana'),('GY','fr','Guyana'),('GY','it',''),('GY','pt',''),('HK','de','Hong Kong SAR China'),('HK','en','Hong Kong SAR China'),('HK','fr','R.A.S. chinoise de Hong Kong'),('HK','it',''),('HK','pt',''),('HN','de','Honduras'),('HN','en','Honduras'),('HN','fr','Honduras'),('HN','it',''),('HN','pt',''),('HR','de','Croatia'),('HR','en','Croatia'),('HR','fr','Croatie'),('HR','it',''),('HR','pt',''),('HT','de','Haiti'),('HT','en','Haiti'),('HT','fr','Haïti'),('HT','it',''),('HT','pt',''),('HU','de','Hungary'),('HU','en','Hungary'),('HU','fr','Hongrie'),('HU','it',''),('HU','pt',''),('ID','de','Indonesia'),('ID','en','Indonesia'),('ID','fr','Indonésie'),('ID','it',''),('ID','pt',''),('IE','de','Ireland'),('IE','en','Ireland'),('IE','fr','Irlande'),('IE','it',''),('IE','pt',''),('IL','de','Israel'),('IL','en','Israel'),('IL','fr','Israël'),('IL','it',''),('IL','pt',''),('IN','de','India'),('IN','en','India'),('IN','fr','Inde'),('IN','it',''),('IN','pt',''),('IQ','de','Iraq'),('IQ','en','Iraq'),('IQ','fr','Irak'),('IQ','it',''),('IQ','pt',''),('IR','de','Iran'),('IR','en','Iran'),('IR','fr','Iran'),('IR','it',''),('IR','pt',''),('IS','de','Iceland'),('IS','en','Iceland'),('IS','fr','Islande'),('IS','it',''),('IS','pt',''),('IT','de','Italy'),('IT','en','Italy'),('IT','fr','Italie'),('IT','it',''),('IT','pt',''),('JM','de','Jamaica'),('JM','en','Jamaica'),('JM','fr','Jamaïque'),('JM','it',''),('JM','pt',''),('JO','de','Jordan'),('JO','en','Jordan'),('JO','fr','Jordanie'),('JO','it',''),('JO','pt',''),('JP','de','Japan'),('JP','en','Japan'),('JP','fr','Japon'),('JP','it',''),('JP','pt',''),('KE','de','Kenya'),('KE','en','Kenya'),('KE','fr','Kenya'),('KE','it',''),('KE','pt',''),('KG','de','Kyrgyzstan'),('KG','en','Kyrgyzstan'),('KG','fr','Kirghizistan'),('KG','it',''),('KG','pt',''),('KH','de','Cambodia'),('KH','en','Cambodia'),('KH','fr','Cambodge'),('KH','it',''),('KH','pt',''),('KP','de','North Korea'),('KP','en','North Korea'),('KP','fr','Corée du Nord'),('KP','it',''),('KP','pt',''),('KR','de','South Korea'),('KR','en','South Korea'),('KR','fr','Corée du Sud'),('KR','it',''),('KR','pt',''),('KW','de','Kuwait'),('KW','en','Kuwait'),('KW','fr','Koweït'),('KW','it',''),('KW','pt',''),('KZ','de','Kazakhstan'),('KZ','en','Kazakhstan'),('KZ','fr','Kazakhstan'),('KZ','it',''),('KZ','pt',''),('LA','de','Laos'),('LA','en','Laos'),('LA','fr','Laos'),('LA','it',''),('LA','pt',''),('LB','de','Lebanon'),('LB','en','Lebanon'),('LB','fr','Liban'),('LB','it',''),('LB','pt',''),('LI','de','Liechtenstein'),('LI','en','Liechtenstein'),('LI','fr','Liechtenstein'),('LI','it',''),('LI','pt',''),('LK','de','Sri Lanka'),('LK','en','Sri Lanka'),('LK','fr','Sri Lanka'),('LK','it',''),('LK','pt',''),('LR','de','Liberia'),('LR','en','Liberia'),('LR','fr','Libéria'),('LR','it',''),('LR','pt',''),('LS','de','Lesotho'),('LS','en','Lesotho'),('LS','fr','Lesotho'),('LS','it',''),('LS','pt',''),('LT','de','Lithuania'),('LT','en','Lithuania'),('LT','fr','Lituanie'),('LT','it',''),('LT','pt',''),('LU','de','Luxembourg'),('LU','en','Luxembourg'),('LU','fr','Luxembourg'),('LU','it',''),('LU','pt',''),('LV','de','Latvia'),('LV','en','Latvia'),('LV','fr','Lettonie'),('LV','it',''),('LV','pt',''),('LY','de','Libya'),('LY','en','Libya'),('LY','fr','Libye'),('LY','it',''),('LY','pt',''),('MA','de','Morocco'),('MA','en','Morocco'),('MA','fr','Maroc'),('MA','it',''),('MA','pt',''),('MC','de','Monaco'),('MC','en','Monaco'),('MC','fr','Monaco'),('MC','it',''),('MC','pt',''),('MD','de','Moldova'),('MD','en','Moldova'),('MD','fr','Moldavie'),('MD','it',''),('MD','pt',''),('ME','de','Montenegro'),('ME','en','Montenegro'),('ME','fr','Monténégro'),('ME','it',''),('ME','pt',''),('MG','de','Madagascar'),('MG','en','Madagascar'),('MG','fr','Madagascar'),('MG','it',''),('MG','pt',''),('MK','de','Macedonia'),('MK','en','Macedonia'),('MK','fr','Macédoine'),('MK','it',''),('MK','pt',''),('ML','de','Mali'),('ML','en','Mali'),('ML','fr','Mali'),('ML','it',''),('ML','pt',''),('MM','de','Myanmar [Burma]'),('MM','en','Myanmar [Burma]'),('MM','fr','Myanmar'),('MM','it',''),('MM','pt',''),('MN','de','Mongolia'),('MN','en','Mongolia'),('MN','fr','Mongolie'),('MN','it',''),('MN','pt',''),('MO','de','Macau SAR China'),('MO','en','Macau SAR China'),('MO','fr','R.A.S. chinoise de Macao'),('MO','it',''),('MO','pt',''),('MR','de','Mauritania'),('MR','en','Mauritania'),('MR','fr','Mauritanie'),('MR','it',''),('MR','pt',''),('MT','de','Malta'),('MT','en','Malta'),('MT','fr','Malte'),('MT','it',''),('MT','pt',''),('MX','de','Mexico'),('MX','en','Mexico'),('MX','fr','Mexique'),('MX','it',''),('MX','pt',''),('MY','de','Malaysia'),('MY','en','Malaysia'),('MY','fr','Malaisie'),('MY','it',''),('MY','pt',''),('MZ','de','Mozambique'),('MZ','en','Mozambique'),('MZ','fr','Mozambique'),('MZ','it',''),('MZ','pt',''),('NA','de','Namibia'),('NA','en','Namibia'),('NA','fr','Namibie'),('NA','it',''),('NA','pt',''),('NC','de','New Caledonia'),('NC','en','New Caledonia'),('NC','fr','Nouvelle-Calédonie'),('NC','it',''),('NC','pt',''),('NE','de','Niger'),('NE','en','Niger'),('NE','fr','Niger'),('NE','it',''),('NE','pt',''),('NG','de','Nigeria'),('NG','en','Nigeria'),('NG','fr','Nigéria'),('NG','it',''),('NG','pt',''),('NI','de','Nicaragua'),('NI','en','Nicaragua'),('NI','fr','Nicaragua'),('NI','it',''),('NI','pt',''),('NL','de','Netherlands'),('NL','en','Netherlands'),('NL','fr','Pays-Bas'),('NL','it',''),('NL','pt',''),('NO','de','Norway'),('NO','en','Norway'),('NO','fr','Norvège'),('NO','it',''),('NO','pt',''),('NP','de','Nepal'),('NP','en','Nepal'),('NP','fr','Népal'),('NP','it',''),('NP','pt',''),('NZ','de','New Zealand'),('NZ','en','New Zealand'),('NZ','fr','Nouvelle-Zélande'),('NZ','it',''),('NZ','pt',''),('OM','de','Oman'),('OM','en','Oman'),('OM','fr','Oman'),('OM','it',''),('OM','pt',''),('PA','de','Panama'),('PA','en','Panama'),('PA','fr','Panama'),('PA','it',''),('PA','pt',''),('PE','de','Peru'),('PE','en','Peru'),('PE','fr','Pérou'),('PE','it',''),('PE','pt',''),('PG','de','Papua New Guinea'),('PG','en','Papua New Guinea'),('PG','fr','Papouasie-Nouvelle-Guinée'),('PG','it',''),('PG','pt',''),('PH','de','Philippines'),('PH','en','Philippines'),('PH','fr','Philippines'),('PH','it',''),('PH','pt',''),('PK','de','Pakistan'),('PK','en','Pakistan'),('PK','fr','Pakistan'),('PK','it',''),('PK','pt',''),('PL','de','Poland'),('PL','en','Poland'),('PL','fr','Pologne'),('PL','it',''),('PL','pt',''),('PR','de','Puerto Rico'),('PR','en','Puerto Rico'),('PR','fr','Porto Rico'),('PR','it',''),('PR','pt',''),('PT','de','Portugal'),('PT','en','Portugal'),('PT','fr','Portugal'),('PT','it',''),('PT','pt',''),('PY','de','Paraguay'),('PY','en','Paraguay'),('PY','fr','Paraguay'),('PY','it',''),('PY','pt',''),('QA','de','Qatar'),('QA','en','Qatar'),('QA','fr','Qatar'),('QA','it',''),('QA','pt',''),('RO','de','Romania'),('RO','en','Romania'),('RO','fr','Roumanie'),('RO','it',''),('RO','pt',''),('RS','de','Serbia'),('RS','en','Serbia'),('RS','fr','Serbie'),('RS','it',''),('RS','pt',''),('RU','de','Russia'),('RU','en','Russia'),('RU','fr','Russie'),('RU','it',''),('RU','pt',''),('RW','de','Rwanda'),('RW','en','Rwanda'),('RW','fr','Rwanda'),('RW','it',''),('RW','pt',''),('SA','de','Saudi Arabia'),('SA','en','Saudi Arabia'),('SA','fr','Arabie saoudite'),('SA','it',''),('SA','pt',''),('SD','de','Sudan'),('SD','en','Sudan'),('SD','fr','Soudan'),('SD','it',''),('SD','pt',''),('SE','de','Sweden'),('SE','en','Sweden'),('SE','fr','Suède'),('SE','it',''),('SE','pt',''),('SG','de','Singapore'),('SG','en','Singapore'),('SG','fr','Singapour'),('SG','it',''),('SG','pt',''),('SI','de','Slovenia'),('SI','en','Slovenia'),('SI','fr','Slovénie'),('SI','it',''),('SI','pt',''),('SK','de','Slovakia'),('SK','en','Slovakia'),('SK','fr','Slovaquie'),('SK','it',''),('SK','pt',''),('SL','de','Sierra Leone'),('SL','en','Sierra Leone'),('SL','fr','Sierra Leone'),('SL','it',''),('SL','pt',''),('SN','de','Senegal'),('SN','en','Senegal'),('SN','fr','Sénégal'),('SN','it',''),('SN','pt',''),('SO','de','Somalia'),('SO','en','Somalia'),('SO','fr','Somalie'),('SO','it',''),('SO','pt',''),('SR','de','Suriname'),('SR','en','Suriname'),('SR','fr','Suriname'),('SR','it',''),('SR','pt',''),('SV','de','El Salvador'),('SV','en','El Salvador'),('SV','fr','El Salvador'),('SV','it',''),('SV','pt',''),('SY','de','Syria'),('SY','en','Syria'),('SY','fr','Syrie'),('SY','it',''),('SY','pt',''),('TD','de','Chad'),('TD','en','Chad'),('TD','fr','Tchad'),('TD','it',''),('TD','pt',''),('TG','de','Togo'),('TG','en','Togo'),('TG','fr','Togo'),('TG','it',''),('TG','pt',''),('TH','de','Thailand'),('TH','en','Thailand'),('TH','fr','Thaïlande'),('TH','it',''),('TH','pt',''),('TJ','de','Tajikistan'),('TJ','en','Tajikistan'),('TJ','fr','Tadjikistan'),('TJ','it',''),('TJ','pt',''),('TM','de','Turkmenistan'),('TM','en','Turkmenistan'),('TM','fr','Turkménistan'),('TM','it',''),('TM','pt',''),('TN','de','Tunisia'),('TN','en','Tunisia'),('TN','fr','Tunisie'),('TN','it',''),('TN','pt',''),('TR','de','Turkey'),('TR','en','Turkey'),('TR','fr','Turquie'),('TR','it',''),('TR','pt',''),('TW','de','Taiwan'),('TW','en','Taiwan'),('TW','fr','Taïwan'),('TW','it',''),('TW','pt',''),('TZ','de','Tanzania'),('TZ','en','Tanzania'),('TZ','fr','Tanzanie'),('TZ','it',''),('TZ','pt',''),('UA','de','Ukraine'),('UA','en','Ukraine'),('UA','fr','Ukraine'),('UA','it',''),('UA','pt',''),('UG','de','Uganda'),('UG','en','Uganda'),('UG','fr','Ouganda'),('UG','it',''),('UG','pt',''),('US','de','United States'),('US','en','United States'),('US','fr','États-Unis'),('US','it',''),('US','pt',''),('UY','de','Uruguay'),('UY','en','Uruguay'),('UY','fr','Uruguay'),('UY','it',''),('UY','pt',''),('UZ','de','Uzbekistan'),('UZ','en','Uzbekistan'),('UZ','fr','Ouzbékistan'),('UZ','it',''),('UZ','pt',''),('VE','de','Venezuela'),('VE','en','Venezuela'),('VE','fr','Venezuela'),('VE','it',''),('VE','pt',''),('VN','de','Vietnam'),('VN','en','Vietnam'),('VN','fr','Viêt Nam'),('VN','it',''),('VN','pt',''),('YE','de','Yemen'),('YE','en','Yemen'),('YE','fr','Yémen'),('YE','it',''),('YE','pt',''),('ZA','de','South Africa'),('ZA','en','South Africa'),('ZA','fr','Afrique du Sud'),('ZA','it',''),('ZA','pt',''),('ZM','de','Zambia'),('ZM','en','Zambia'),('ZM','fr','Zambie'),('ZM','it',''),('ZM','pt',''),('ZW','de','Zimbabwe'),('ZW','en','Zimbabwe'),('ZW','fr','Zimbabwe'),('ZW','it',''),('ZW','pt','');
218/*!40000 ALTER TABLE `t_country_lang` ENABLE KEYS */;
219UNLOCK TABLES;
220
221--
222-- Table structure for table `t_shipzone`
223--
224
225DROP TABLE IF EXISTS `t_shipzone`;
226/*!40101 SET @saved_cs_client     = @@character_set_client */;
227/*!40101 SET character_set_client = utf8 */;
228CREATE TABLE `t_shipzone` (
229  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
230  `name` varchar(40) NOT NULL,
231  `price` decimal(6,2) unsigned NOT NULL,
232  `free_shipping` decimal(6,2) unsigned DEFAULT NULL,
233  `position` int(10) unsigned NOT NULL DEFAULT '0',
234  PRIMARY KEY (`id`)
235) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8;
236/*!40101 SET character_set_client = @saved_cs_client */;
237
238--
239-- Dumping data for table `t_shipzone`
240--
241
242LOCK TABLES `t_shipzone` WRITE;
243/*!40000 ALTER TABLE `t_shipzone` DISABLE KEYS */;
244INSERT INTO `t_shipzone` VALUES (1,'Grupo 4,5€',0.00,40.00,1),(4,'Grupo 6€',0.00,40.00,4),(7,'Grupo 20€',0.00,125.00,7),(10,'Grupo 25€',0.00,145.00,10),(13,'Grupo 26€',0.00,150.00,13),(15,'Grupo 36€',0.00,200.00,15),(16,'Grupo 45€',0.00,NULL,16),(17,'Grupo 50€',0.00,NULL,17),(18,'Grupo 55€',0.00,NULL,18),(19,'Grupo 60€',0.00,NULL,19),(20,'Grupo 65€',0.00,NULL,20),(21,'Grupo 70€',0.00,NULL,21),(22,'Grupo 80€',0.00,NULL,22);
245/*!40000 ALTER TABLE `t_shipzone` ENABLE KEYS */;
246UNLOCK TABLES;
247/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
248
249/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
250/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
251/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
252/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
253/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
254/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
255/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
256
257-- Dump completed on 2018-04-23 17:02:15