 ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ecommerces`
--

LOCK TABLES `ecommerces` WRITE;
/*!40000 ALTER TABLE `ecommerces` DISABLE KEYS */;
/*!40000 ALTER TABLE `ecommerces` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `groups`
--

DROP TABLE IF EXISTS `groups`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `groups` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `created_by` int(10) unsigned NOT NULL,
  `privacy_id` int(10) unsigned NOT NULL,
  `name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `code` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `state` enum('ACTIVO','INACTIVO') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'ACTIVO',
  `description` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `groups_privacy_id_foreign` (`privacy_id`),
  KEY `groups_created_by_foreign` (`created_by`),
  CONSTRAINT `groups_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  CONSTRAINT `groups_privacy_id_foreign` FOREIGN KEY (`privacy_id`) REFERENCES `privacies` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `groups`
--

LOCK TABLES `groups` WRITE;
/*!40000 ALTER TABLE `groups` DISABLE KEYS */;
INSERT INTO `groups` VALUES (2,1,1,'kaka','00000001','ACTIVO','wdwd','2018-08-03 10:55:40','2018-08-03 10:55:40'),(3,1,2,'Aawdwd','00000002','ACTIVO','wdwdwd','2018-08-03 11:13:47','2018-08-03 11:13:47');
/*!40000 ALTER TABLE `groups` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `industries`
--

DROP TABLE IF EXISTS `industries`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `industries` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `code` varchar(2) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `industries`
--

LOCK TABLES `industries` WRITE;
/*!40000 ALTER TABLE `industries` DISABLE KEYS */;
INSERT INTO `industries` VALUES (1,'Agro','01','2018-08-03 10:44:58','2018-08-03 10:44:58'),(2,'Automotriz','02','2018-08-03 10:44:58','2018-08-03 10:44:58'),(3,'Banco','03','2018-08-03 10:44:58','2018-08-03 10:44:58'),(4,'<NAME>','04','2018-08-03 10:44:58','2018-08-03 10:44:58'),(5,'Comercio','05','2018-08-03 10:44:58','2018-08-03 10:44:58'),(6,'Comunicacion','06','2018-08-03 10:44:58','2018-08-03 10:44:58'),(7,'Construccion','07','2018-08-03 10:44:58','2018-08-03 10:44:58'),(8,'Consultoria','08','2018-08-03 10:44:58','2018-08-03 10:44:58'),(9,'Consumo Masivo','09','2018-08-03 10:44:58','2018-08-03 10:44:58'),(10,'Diseño','10','2018-08-03 10:44:58','2018-08-03 10:44:58'),(11,'Economia','11','2018-08-03 10:44:58','2018-08-03 10:44:58'),(12,'Educación','12','2018-08-03 10:44:58','2018-08-03 10:44:58'),(13,'Energía','13','2018-08-03 10:44:58','2018-08-03 10:44:58'),(14,'Estado','14','2018-08-03 10:44:58','2018-08-03 10:44:58'),(15,'Finanzas','15','2018-08-03 10:44:58','2018-08-03 10:44:58'),(16,'Fundación','16','2018-08-03 10:44:58','2018-08-03 10:44:58'),(17,'Gastronomía','17','2018-08-03 10:44:58','2018-08-03 10:44:58'),(18,'Hotelería','18','2018-08-03 10:44:58','2018-08-03 10:44:58'),(19,'IT','19','2018-08-03 10:44:58','2018-08-03 10:44:58'),(20,'Laboratorio','20','2018-08-03 10:44:58','2018-08-03 10:44:58'),(21,'Limpieza','21','2018-08-03 10:44:59','2018-08-03 10:44:59'),(22,'Marketing','22','2018-08-03 10:44:59','2018-08-03 10:44:59'),(23,'Medicina','23','2018-08-03 10:44:59','2018-08-03 10:44:59'),(24,'Minería','24','2018-08-03 10:44:59','2018-08-03 10:44:59'),(25,'ONG','25','2018-08-03 10:44:59','2018-08-03 10:44:59'),(26,'Publicidad','26','2018-08-03 10:44:59','2018-08-03 10:44:59'),(27,'Retail','27','2018-08-03 10:44:59','2018-08-03 10:44:59'),(28,'Servicios','28','2018-08-03 10:44:59','2018-08-03 10:44:59'),(29,'Telecomunicaciones','29','2018-08-03 10:44:59','2018-08-03 10:44:59'),(30,'Textil','30','2018-08-03 10:44:59','2018-08-03 10:44:59'),(31,'Transporte','31','2018-08-03 10:44:59','2018-08-03 10:44:59'),(32,'Turismo','32','2018-08-03 10:44:59','2018-08-03 10:44:59'),(33,'Ventas','33','2018-08-03 10:44:59','2018-08-03 10:44:59');
/*!40000 ALTER TABLE `industries` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `interests`
--

DROP TABLE IF