--
-- Host: localhost    Database: emergency
-- ------------------------------------------------------


--
-- Table structure for table `business_partners`
--

CREATE TABLE `business_partners` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `bp_id` int(11) NOT NULL,
  `building_name` varchar(255) NOT NULL DEFAULT '',
  `street` varchar(255) NOT NULL DEFAULT '',
  `number` int(11) NOT NULL,
  `zip` int(11) NOT NULL,
  `city` varchar(255) NOT NULL DEFAULT '',
  `country` int(11) NOT NULL,
  `color` varchar(10) NOT NULL DEFAULT '',
  `call_action` tinyint(1) NOT NULL DEFAULT '1',
  `enable_phones` tinyint(1) NOT NULL DEFAULT '1',
  `lang` varchar(10) NOT NULL DEFAULT 'en',
  PRIMARY KEY (`id`),
  UNIQUE KEY `BP_unique` (`bp_id`)
) ENGINE=InnoDB AUTO_INCREMENT=66 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `business_partners`
--

INSERT INTO `business_partners` VALUES (1,19810206,'','',0,0,'',0,'',1,1,'en'),(2,29762910,'','',0,0,'',0,'',1,1,'en'),(3,41374398,'','',0,0,'',0,'',1,1,'en'),(4,12345678,'Auditorium Dietikon','Lerzenstrasse',12,8953,'Dietikon',206,'A40614',1,0,'en'),(5,17322030,'','',0,0,'',0,'',1,1,'en'),(6,42203790,'','',0,0,'',0,'',1,1,'en'),(7,28933518,'','',0,0,'',0,'',1,1,'en'),(8,13175070,'','',0,0,'',0,'',1,1,'en'),(9,14004462,'','',0,0,'',0,'',1,1,'en'),(10,16492638,'','',0,0,'',0,'',1,1,'en'),(11,24786558,'','',0,0,'',0,'',1,1,'en'),(12,36398046,'','',0,0,'',0,'',1,1,'en'),(13,15663246,'','',0,0,'',0,'',1,1,'en'),(14,21468990,'','',0,0,'',0,'',1,1,'en'),(15,37227438,'','',0,0,'',0,'',1,1,'en'),(16,26445342,'','',0,0,'',0,'',1,1,'en'),(17,32251086,'','',0,0,'',0,'',1,1,'en'),(18,22298382,'','',0,0,'',0,'',1,1,'en'),(19,23127774,'','',0,0,'',0,'',1,1,'en'),(20,38056830,'','',0,0,'',0,'',1,1,'en'),(21,23957166,'','',0,0,'',0,'',1,1,'en'),(22,33909870,'','',0,0,'',0,'',1,1,'en'),(23,35568654,'','',0,0,'',0,'',1,1,'en'),(24,39715614,'','',0,0,'',0,'',1,1,'en'),(25,43862574,'','',0,0,'',0,'',1,1,'en'),(26,34739262,'','',0,0,'',0,'',1,1,'en'),(27,20639598,'','',0,0,'',0,'',1,1,'en'),(28,31421694,'','',0,0,'',0,'',1,1,'en'),(29,33080478,'','',0,0,'',0,'',1,1,'en'),(30,40545006,'','',0,0,'',0,'',1,1,'en'),(31,44691966,'','',0,0,'',0,'',1,1,'en'),(32,38886222,'','',0,0,'',0,'',1,1,'en'),(33,25615950,'','',0,0,'',0,'',1,1,'en'),(34,43033182,'','',0,0,'',0,'',1,1,'en'),(35,14833854,'','',0,0,'',0,'',1,1,'en'),(36,18980814,'','',0,0,'',0,'',1,1,'en'),(37,18151422,'','',0,0,'',0,'',1,1,'en'),(38,3232121,'','',0,0,'',0,'',1,1,'en'),(39,1222245,'','',0,0,'',0,'',1,1,'en'),(40,2147483647,'','',0,0,'',0,'',1,1,'en'),(41,234234234,'','',0,0,'',0,'',1,1,'en'),(42,1111111,'','',0,0,'',0,'',1,1,'en'),(43,1222222,'','',0,0,'',0,'',1,1,'en'),(44,12345679,'Limmat Hills','Binzstrasse',9,8953,'Dietikon',206,'FF952B',1,1,'en'),(45,2,'','',0,0,'',0,'',1,1,'en'),(47,1,'','',0,0,'',0,'',1,1,'en'),(48,564575,'','',0,0,'',0,'',1,1,'en'),(50,1234,'','',0,0,'',0,'',1,1,'en'),(51,123456789,'Hello Oscar','Zeughausstrasse',55,8004,'Zürich',206,'119DA4',1,1,'en'),(52,1165,'','',0,0,'',0,'',1,1,'en'),(53,4,'','',0,0,'',0,'',1,1,'en'),(64,2000,'Schürbungertweg H7','Schürbungertweg',7,8302,'Kloten',206,'000000',0,0,'de'),(65,2001,'Schürbungertweg H9','Schürbungertweg',9,8302,'Kloten',206,'000000',0,0,'de');

--
-- Table structure for table `clients`
--

CREATE TABLE `clients` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `external_id` varchar(255) NOT NULL,
  `name` varchar(256) NOT NULL,
  `surname` varchar(512) NOT NULL,
  `alternative_name` varchar(255) DEFAULT NULL,
  `alternative_surname` varchar(255) DEFAULT NULL,
  `alternative_schedule_start` varchar(256) DEFAULT NULL,
  `alternative_schedule_end` varchar(256) DEFAULT NULL,
  `businesspartnerid` varchar(50) DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `phone_number` varchar(25) DEFAULT NULL,
  `apartment` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `external_id` (`external_id`)
) ENGINE=InnoDB AUTO_INCREMENT=352 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `clients`
--

INSERT INTO `clients` VALUES (6,'453','Henry','Meier','','','7:00','7:15','12345678','/p>','901','901'),(19,'1005','Maria','Fröhlich','','','12:30','12:30','12345678','','03','903'),(113,'989','Carmen','Glücklich','','','12:45','12:45','12345678','','904','904'),(117,'1021','HLK','Panel','','','13:00','13:15','12345678','','906','906'),(224,'899','Infrastruktur','Panel','Praxis Dr Meier','Hans','17:30','18:00','12345678','/e223fa104681b8a1ecc2e544b288ee91.png','905','905'),(314,'767','Sensorik','Panel','','','7:00','7:15','12345678','','907','907'),(315,'88','John','Müller','','','16:00','16:15','12345678','','02','902');
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 TRIGGER `InsertBpOnUpdate` AFTER UPDATE ON `clients` FOR EACH ROW BEGIN
IF NEW.businesspartnerid not in (select BP.bp_id as partner_id from business_partners BP where NEW.businesspartnerid = BP.bp_id) THEN
  INSERT INTO business_partners (bp_id) VALUES (NEW.businesspartnerid);
END IF;
END */;;
DELIMITER ;

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

CREATE TABLE `countries` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `country` varchar(255) NOT NULL DEFAULT '',
  `code_2` varchar(2) NOT NULL DEFAULT '',
  `code_3` varchar(3) NOT NULL DEFAULT '',
  `number` int(3) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=241 DEFAULT CHARSET=utf8mb4;

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

INSERT INTO `countries` VALUES (1,'AALAND ISLANDS','AX','ALA',248),(2,'AFGHANISTAN','AF','AFG',4),(3,'ALBANIA','AL','ALB',8),(4,'ALGERIA','DZ','DZA',12),(5,'AMERICAN SAMOA','AS','ASM',16),(6,'ANDORRA','AD','AND',20),(7,'ANGOLA','AO','AGO',24),(8,'ANGUILLA','AI','AIA',660),(9,'ANTARCTICA','AQ','ATA',10),(10,'ANTIGUA AND BARBUDA','AG','ATG',28),(11,'ARGENTINA','AR','ARG',32),(12,'ARMENIA','AM','ARM',51),(13,'ARUBA','AW','ABW',533),(14,'AUSTRALIA','AU','AUS',36),(15,'AUSTRIA','AT','AUT',40),(16,'AZERBAIJAN','AZ','AZE',31),(17,'BAHAMAS','BS','BHS',44),(18,'BAHRAIN','BH','BHR',48),(19,'BANGLADESH','BD','BGD',50),(20,'BARBADOS','BB','BRB',52),(21,'BELARUS','BY','BLR',112),(22,'BELGIUM','BE','BEL',56),(23,'BELIZE','BZ','BLZ',84),(24,'BENIN','BJ','BEN',204),(25,'BERMUDA','BM','BMU',60),(26,'BHUTAN','BT','BTN',64),(27,'BOLIVIA','BO','BOL',68),(28,'BOSNIA AND HERZEGOWINA','BA','BIH',70),(29,'BOTSWANA','BW','BWA',72),(30,'BOUVET ISLAND','BV','BVT',74),(31,'BRAZIL','BR','BRA',76),(32,'BRITISH INDIAN OCEAN TERRITORY','IO','IOT',86),(33,'BRUNEI DARUSSALAM','BN','BRN',96),(34,'BULGARIA','BG','BGR',100),(35,'BURKINA FASO','BF','BFA',854),(36,'BURUNDI','BI','BDI',108),(37,'CAMBODIA','KH','KHM',116),(38,'CAMEROON','CM','CMR',120),(39,'CANADA','CA','CAN',124),(40,'CAPE VERDE','CV','CPV',132),(41,'CAYMAN ISLANDS','KY','CYM',136),(42,'CENTRAL AFRICAN REPUBLIC','CF','CAF',140),(43,'CHAD','TD','TCD',148),(44,'CHILE','CL','CHL',152),(45,'CHINA','CN','CHN',156),(46,'CHRISTMAS ISLAND','CX','CXR',162),(47,'COCOS (KEELING) ISLANDS','CC','CCK',166),(48,'COLOMBIA','CO','COL',170),(49,'COMOROS','KM','COM',174),(50,'CONGO Democratic Republic of (was Zaire)','CD','COD',180),(51,'CONGO Republic of','CG','COG',178),(52,'COOK ISLANDS','CK','COK',184),(53,'COSTA RICA','CR','CRI',188),(54,'COTE D\'IVOIRE','CI','CIV',384),(55,'CROATIA','HR','HRV',191),(56,'CUBA','CU','CUB',192),(57,'CYPRUS','CY','CYP',196),(58,'CZECH REPUBLIC','CZ','CZE',203),(59,'DENMARK','DK','DNK',208),(60,'DJIBOUTI','DJ','DJI',262),(61,'DOMINICA','DM','DMA',212),(62,'DOMINICAN REPUBLIC','DO','DOM',214),(63,'ECUADOR','EC','ECU',218),(64,'EGYPT','EG','EGY',818),(65,'EL SALVADOR','SV','SLV',222),(66,'EQUATORIAL GUINEA','GQ','GNQ',226),(67,'ERITREA','ER','ERI',232),(68,'ESTONIA','EE','EST',233),(69,'ETHIOPIA','ET','ETH',231),(70,'FALKLAND ISLANDS (MALVINAS)','FK','FLK',238),(71,'FAROE ISLANDS','FO','FRO',234),(72,'FIJI','FJ','FJI',242),(73,'FINLAND','FI','FIN',246),(74,'FRANCE','FR','FRA',250),(75,'FRENCH GUIANA','GF','GUF',254),(76,'FRENCH POLYNESIA','PF','PYF',258),(77,'FRENCH SOUTHERN TERRITORIES','TF','ATF',260),(78,'GABON','GA','GAB',266),(79,'GAMBIA','GM','GMB',270),(80,'GEORGIA','GE','GEO',268),(81,'GERMANY','DE','DEU',276),(82,'GHANA','GH','GHA',288),(83,'GIBRALTAR','GI','GIB',292),(84,'GREECE','GR','GRC',300),(85,'GREENLAND','GL','GRL',304),(86,'GRENADA','GD','GRD',308),(87,'GUADELOUPE','GP','GLP',312),(88,'GUAM','GU','GUM',316),(89,'GUATEMALA','GT','GTM',320),(90,'GUINEA','GN','GIN',324),(91,'GUINEA-BISSAU','GW','GNB',624),(92,'GUYANA','GY','GUY',328),(93,'HAITI','HT','HTI',332),(94,'HEARD AND MC DONALD ISLANDS','HM','HMD',334),(95,'HONDURAS','HN','HND',340),(96,'HONG KONG','HK','HKG',344),(97,'HUNGARY','HU','HUN',348),(98,'ICELAND','IS','ISL',352),(99,'INDIA','IN','IND',356),(100,'INDONESIA','ID','IDN',360),(101,'IRAN (ISLAMIC REPUBLIC OF)','IR','IRN',364),(102,'IRAQ','IQ','IRQ',368),(103,'IRELAND','IE','IRL',372),(104,'ISRAEL','IL','ISR',376),(105,'ITALY','IT','ITA',380),(106,'JAMAICA','JM','JAM',388),(107,'JAPAN','JP','JPN',392),(108,'JORDAN','JO','JOR',400),(109,'KAZAKHSTAN','KZ','KAZ',398),(110,'KENYA','KE','KEN',404),(111,'KIRIBATI','KI','KIR',296),(112,'KOREA DEMOCRATIC PEOPLE\'S REPUBLIC OF','KP','PRK',408),(113,'KOREA REPUBLIC OF','KR','KOR',410),(114,'KUWAIT','KW','KWT',414),(115,'KYRGYZSTAN','KG','KGZ',417),(116,'LAO PEOPLE\'S DEMOCRATIC REPUBLIC','LA','LAO',418),(117,'LATVIA','LV','LVA',428),(118,'LEBANON','LB','LBN',422),(119,'LESOTHO','LS','LSO',426),(120,'LIBERIA','LR','LBR',430),(121,'LIBYAN ARAB JAMAHIRIYA','LY','LBY',434),(122,'LIECHTENSTEIN','LI','LIE',438),(123,'LITHUANIA','LT','LTU',440),(124,'LUXEMBOURG','LU','LUX',442),(125,'MACAU','MO','MAC',446),(126,'MACEDONIA THE FORMER YUGOSLAV REPUBLIC OF','MK','MKD',807),(127,'MADAGASCAR','MG','MDG',450),(128,'MALAWI','MW','MWI',454),(129,'MALAYSIA','MY','MYS',458),(130,'MALDIVES','MV','MDV',462),(131,'MALI','ML','MLI',466),(132,'MALTA','MT','MLT',470),(133,'MARSHALL ISLANDS','MH','MHL',584),(134,'MARTINIQUE','MQ','MTQ',474),(135,'MAURITANIA','MR','MRT',478),(136,'MAURITIUS','MU','MUS',480),(137,'MAYOTTE','YT','MYT',175),(138,'MEXICO','MX','MEX',484),(139,'MICRONESIA FEDERATED STATES OF','FM','FSM',583),(140,'MOLDOVA','RE','MD',0),(141,'MONACO','MC','MCO',492),(142,'MONGOLIA','MN','MNG',496),(143,'MONTSERRAT','MS','MSR',500),(144,'MOROCCO','MA','MAR',504),(145,'MOZAMBIQUE','MZ','MOZ',508),(146,'MYANMAR','MM','MMR',104),(147,'NAMIBIA','NA','NAM',516),(148,'NAURU','NR','NRU',520),(149,'NEPAL','NP','NPL',524),(150,'NETHERLANDS','NL','NLD',528),(151,'NETHERLANDS ANTILLES','AN','ANT',530),(152,'NEW CALEDONIA','NC','NCL',540),(153,'NEW ZEALAND','NZ','NZL',554),(154,'NICARAGUA','NI','NIC',558),(155,'NIGER','NE','NER',562),(156,'NIGERIA','NG','NGA',566),(157,'NIUE','NU','NIU',570),(158,'NORFOLK ISLAND','NF','NFK',574),(159,'NORTHERN MARIANA ISLANDS','MP','MNP',580),(160,'NORWAY','NO','NOR',578),(161,'OMAN','OM','OMN',512),(162,'PAKISTAN','PK','PAK',586),(163,'PALAU','PW','PLW',585),(164,'PALESTINIAN TERRITORY Occupied','PS','PSE',275),(165,'PANAMA','PA','PAN',591),(166,'PAPUA NEW GUINEA','PG','PNG',598),(167,'PARAGUAY','PY','PRY',600),(168,'PERU','PE','PER',604),(169,'PHILIPPINES','PH','PHL',608),(170,'PITCAIRN','PN','PCN',612),(171,'POLAND','PL','POL',616),(172,'PORTUGAL','PT','PRT',620),(173,'PUERTO RICO','PR','PRI',630),(174,'QATAR','QA','QAT',634),(175,'REUNION','RE','REU',638),(176,'ROMANIA','RO','ROU',642),(177,'RUSSIAN FEDERATION','RU','RUS',643),(178,'RWANDA','RW','RWA',646),(179,'SAINT HELENA','SH','SHN',654),(180,'SAINT KITTS AND NEVIS','KN','KNA',659),(181,'SAINT LUCIA','LC','LCA',662),(182,'SAINT PIERRE AND MIQUELON','PM','SPM',666),(183,'SAINT VINCENT AND THE GRENADINES','VC','VCT',670),(184,'SAMOA','WS','WSM',882),(185,'SAN MARINO','SM','SMR',674),(186,'SAO TOME AND PRINCIPE','ST','STP',678),(187,'SAUDI ARABIA','SA','SAU',682),(188,'SENEGAL','SN','SEN',686),(189,'SERBIA AND MONTENEGRO','CS','SCG',891),(190,'SEYCHELLES','SC','SYC',690),(191,'SIERRA LEONE','SL','SLE',694),(192,'SINGAPORE','SG','SGP',702),(193,'SLOVAKIA','SK','SVK',703),(194,'SLOVENIA','SI','SVN',705),(195,'SOLOMON ISLANDS','SB','SLB',90),(196,'SOMALIA','SO','SOM',706),(197,'SOUTH AFRICA','ZA','ZAF',710),(198,'SOUTH GEORGIA AND THE SOUTH SANDWICH ISLANDSGS','SG','239',0),(199,'SPAIN','ES','ESP',724),(200,'SRI LANKA','LK','LKA',144),(201,'SUDAN','SD','SDN',736),(202,'SURINAME','SR','SUR',740),(203,'SVALBARD AND JAN MAYEN ISLANDS','SJ','SJM',744),(204,'SWAZILAND','SZ','SWZ',748),(205,'SWEDEN','SE','SWE',752),(206,'SWITZERLAND','CH','CHE',756),(207,'SYRIAN ARAB REPUBLIC','SY','SYR',760),(208,'TAIWAN','TW','TWN',158),(209,'TAJIKISTAN','TJ','TJK',762),(210,'TANZANIA','UN','TZ',0),(211,'THAILAND','TH','THA',764),(212,'TIMOR-LESTE','TL','TLS',626),(213,'TOGO','TG','TGO',768),(214,'TOKELAU','TK','TKL',772),(215,'TONGA','TO','TON',776),(216,'TRINIDAD AND TOBAGO','TT','TTO',780),(217,'TUNISIA','TN','TUN',788),(218,'TURKEY','TR','TUR',792),(219,'TURKMENISTAN','TM','TKM',795),(220,'TURKS AND CAICOS ISLANDS','TC','TCA',796),(221,'TUVALU','TV','TUV',798),(222,'UGANDA','UG','UGA',800),(223,'UKRAINE','UA','UKR',804),(224,'UNITED ARAB EMIRATES','AE','ARE',784),(225,'UNITED KINGDOM','GB','GBR',826),(226,'UNITED STATES','US','USA',840),(227,'UNITED STATES MINOR OUTLYING ISLANDS','UM','UMI',581),(228,'URUGUAY','UY','URY',858),(229,'UZBEKISTAN','UZ','UZB',860),(230,'VANUATU','VU','VUT',548),(231,'VATICAN CITY STATE (HOLY SEE)','VA','VAT',336),(232,'VENEZUELA','VE','VEN',862),(233,'VIET NAM','VN','VNM',704),(234,'VIRGIN ISLANDS (BRITISH)','VG','VGB',92),(235,'VIRGIN ISLANDS (U.S.)','VI','VIR',850),(236,'WALLIS AND FUTUNA ISLANDS','WF','WLF',876),(237,'WESTERN SAHARA','EH','ESH',732),(238,'YEMEN','YE','YEM',887),(239,'ZAMBIA','ZM','ZMB',894),(240,'ZIMBABWE','ZW','ZWE',716);

--
-- Table structure for table `languages`
--

CREATE TABLE `languages` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `iso` varchar(5) NOT NULL,
  `locale` varchar(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `languages`
--

INSERT INTO `languages` VALUES (1,'english','en','en_EN'),(2,'spanish','es','es_ES'),(3,'german','de','de_DE'),(4,'italian','it','it_IT'),(5,'french','fr','fr_FR');

--
-- Table structure for table `numbers`
--

CREATE TABLE `numbers` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `icon` text COLLATE utf8_unicode_ci NOT NULL,
  `number` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `document` text COLLATE utf8_unicode_ci NOT NULL,
  `sort` int(11) NOT NULL,
  `author_id` int(11) NOT NULL,
  `users` longtext COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `numbers`
--

INSERT INTO `numbers` VALUES (2,'Verwaltung','GZ-icon-key','144','/51f66be8a015f4bb18b99335cc10d2e2.pdf',0,1,'12345678,12345679'),(3,'Polizei','GZ-icon-key','117','',2,1,'12345678'),(4,'REGA','GZ-icon-key','1414','',6,214,'6,151'),(6,'Feuerwehr','GZ-icon-fire','118','',3,1,'12345678'),(7,'Strassenzustand','GZ-icon-key','163','',8,214,'6,151'),(8,'Hauswart','GZ-icon-tools','88','',5,1,'12345678,12345679'),(9,'Pannenhilfe','GZ-icon-key','140','',7,214,'6,151,314,315'),(10,'Internationale Notrufnummer','GZ-icon-key','112','',1,214,'151,314,315'),(17,'test','GZ-icon-key','43546','',0,1,'0');

--
-- Table structure for table `numbers_users`
--

CREATE TABLE `numbers_users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `number_id` int(11) NOT NULL,
  `client_id` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=449 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `numbers_users`
--

INSERT INTO `numbers_users` VALUES (41,11,6),(42,11,314),(43,11,315),(44,5,6),(45,5,314),(46,5,315),(54,12,6),(202,13,6),(205,16,6),(230,4,6),(231,4,151),(232,9,6),(233,9,151),(234,9,314),(235,9,315),(236,7,6),(237,7,151),(242,15,101),(243,15,151),(287,10,151),(288,10,314),(289,10,315),(298,14,6),(299,14,101),(438,3,12345678),(444,2,12345678),(445,2,12345679),(446,6,12345678),(447,8,12345678),(448,8,12345679);

--
-- Table structure for table `parameters`
--

CREATE TABLE `parameters` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `value` varchar(255) NOT NULL,
  `description` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `parameters`
--

INSERT INTO `parameters` VALUES (5,'voip_apk','https://www.gzvoip.es/call/','');


