 
 LOCK TABLES `like` WRITE;
 /*!40000 ALTER TABLE `like` DISABLE KEYS */;
-INSERT INTO `like` VALUES (1,'12345',1,1,'2016-03-31 13:18:11');
-/*!40000 ALTER TABLE `like` ENABLE KEYS */;
-UNLOCK TABLES;
-
---
--- Table structure for table `share`
---
-
-DROP TABLE IF EXISTS `share`;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `share` (
-  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
-  `sid` varchar(255) NOT NULL,
-  `message` text,
-  `user` int(10) unsigned NOT NULL,
-  `article` int(10) unsigned NOT NULL,
-  `createdAt` datetime DEFAULT NULL,
-  PRIMARY KEY (`id`,`user`,`article`),
-  UNIQUE KEY `sid_UNIQUE` (`sid`),
-  KEY `fk_share_user1_idx` (`user`),
-  KEY `fk_share_article1_idx` (`article`),
-  CONSTRAINT `fk_share_article1` FOREIGN KEY (`article`) REFERENCES `article` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
-  CONSTRAINT `fk_share_user1` FOREIGN KEY (`user`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Dumping data for table `share`
---
-
-LOCK TABLES `share` WRITE;
-/*!40000 ALTER TABLE `share` DISABLE KEYS */;
-/*!40000 ALTER TABLE `share` ENABLE KEYS */;
-UNLOCK TABLES;
-
---
--- Table structure for table `user`
---
-
-DROP TABLE IF EXISTS `user`;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `user` (
-  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
-  `provider` varchar(255) DEFAULT NULL,
-  `uid` varchar(255) NOT NULL,
-  `name` varchar(255) DEFAULT NULL,
-  `gender` varchar(255) DEFAULT NULL,
-  `email` varchar(255) DEFAULT NULL,
-  `firstname` varchar(255) DEFAULT NULL,
-  `lastname` varchar(255) DEFAULT NULL,
-  `profileUrl` varchar(45) DEFAULT NULL,
-  `password` varchar(255) DEFAULT NULL,
-  `createdAt` datetime DEFAULT NULL,
-  `updatedAt` datetime DEFAULT NULL,
-  PRIMARY KEY (`id`),
-  UNIQUE KEY `uid_UNIQUE` (`uid`)
-) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Dumping data for table `user`
---
-
-LOCK TABLES `user` WRITE;
-/*!40000 ALTER TABLE `user` DISABLE KEYS */;
-INSERT INTO `user` VALUES (1,'facebook','1023910934336922','Diego F. Leon','male','dln.finis@gmail.com','Diego','Leon','https://www.facebook.com/app_scoped_user_id/1',NULL,'2016-03-31 01:20:03','2016-03-31 01:20:03'),(2,NULL,'c0ad5893-9f08-4ee3-9c60-e9fafc425b16',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2016-04-01 00:17:26','2016-04-01 00:17:26'),(7,'facebook','111836912539414','Will Alaacicaffccg Moiduescu',NULL,NULL,NULL,NULL,NULL,NULL,'2016-02-17 13:12:47','2016-02-17 13:12:47'),(8,'facebook','162453457467136','Open Graph Test User',NULL,NULL,NULL,NULL,NULL,NULL,'2016-02-17 15:09:02','2016-02-17 15:09:02'),(9,'facebook','115894715466160','Mark Alaacfhiehhag Huiberg',NULL,NULL,NULL,NULL,NULL,NULL,'2016-02-19 12:10:50','2016-02-19 12:10:50');
-/*!40000 ALTER TABLE `user` ENABLE KEYS */;
-UNLOCK TABLES;
-
---
--- Table structure for table `visit`
---
-
-DROP TABLE IF EXISTS `visit`;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `visit` (
-  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
-  `user` int(10) unsigned NOT NULL,
-  `article` int(10) unsigned NOT NULL,
-  `time` float NOT NULL,
-  `createdAt` datetime DEFAULT NULL,
-  PRIMARY KEY (`id`,`user`,`article`),
-  KEY `fk_visita_article_idx` (`article`),
-  KEY `fk_visita_user_idx` (`user`),
-  CONSTRAINT `fk_visita_article` FOREIGN KEY (`article`) REFERENCES `article` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
-  CONSTRAINT `fk_visita_user` FOREIGN KEY (`user`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Dumping data for table `visit`
---
-
-LOCK TABLES `visit` WRITE;
-/*!40000 ALTER TABLE `visit` DISABLE KEYS */;
-/*!40000 ALTER TABLE `visit` ENABLE KEYS */;
-UNLOCK TABLES;
-/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
-
-/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
-/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
-/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
-/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
-/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
-/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
-/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-
--- Dump completed on 2016-05-04  9:30:15
+INSERT INTO `like` VALUES (1,'12345',1,1,'2016-03-31 13:18:11'),(2,'1084917731569575',9,1,'2016-05-09 14:05:26'),(3,'1084918538236161',14,1,'2016-05-09 14:06:24'),(4,'1084918571569491',13,1,'2016-05-09 14:06:28'),(6,'257356581319972',15,4,'2016-05-10 07:54:43'),(8,'257359037986393',8,4,'2016-05-10 07:57:33'),(11,'257364931319137',13,1,'2016-05-10 08:04:48'),(13,'257364991319131',14,1,'2016-05-10 08:04:57'),(14,'1010047119063842',15,11,'2016-05-10 09:05:54'),(17,'835553273240408',15,19,'2016-05-10 09:09:31'),(18,'835553313240404',7,19,'2016-05-10 09:09:40'),(19,'1085454064849275',15,14,'2016-05-10 09:15:54'),(24,'1085455391515809',8,1,'2016-05-10 09:19:04'),(27,'10153722340262620',15,14,'2016-05-10 09:33:27'),(28,'10201518870489230',15,16,'2016-05-10 09:43:46'),(30,'279272135795890',15,2,'2016-06-13 00:54:46'),(31,'279272202462550',7,2,'2016-06-13 00:54:57'),(33,'279272462462524',7,1,'2016-06-13 00:55:58'),(34,'279275165795587',6,1,'2016-06-13 00:57:29'),(36,'1072350862830174',7,34,'2016-06-14 11:56:16'),(37,'294079187600774',15,29,'2016-06-14 19:23:43'),(40,'1101760226560660',15,38,'2016-06-14 20:01:29'),(42,'1101770616559621',3,38,'2016-06-14 20:28:25'),(43,'10207924390880118',14,33,'2016-06-14 21:03:23'),(44,'10207924425000971',3,33,'2016-06-14 21:10:10'),(45,'1080587685347376',7,39,'2016-06-14 21:51:08'),(46,'1080602598679218',2,39,'2016-06-14 22:23:42'),(47,'1220649707969822',3,30,'2016-06-14 23:05:41'),(48,'1220651067969686',7,30,'2016-06-14 23:08:29'),(49,'1220653357969457',12,30,'2016-06-14 23:17:26'),(50,'1220662191301907',14,30,'2016-06-14 23:47:37'),(55,'1101899439880072',8,38,'2016-06-15 01:02:54'),(56,'1101903473213002',14,36,'2016-06-15 01:16:19'),(58,'1072737392791521',7,28,'2016-06-15 03:21:18'),(59,'1154527394597420',2,40,'2016-06-17 09:57:53'),(60,'1124735324234747',3,27,'2016-06-17 11:26:20'),(61,'1124735587568054',2,27,'2016-06-17 11:27:10'),(62,'1118017858259562',2,2,'2016-06-30 13:40:35'),(63,'1118018404926174',14,2,'2016-06-30 13:41:56'),(64,'301111900277773',1,4,'2016-06-30 13:44:45'),(65,'1118020624925952',2,1,'2016-06-30 13:47:03'),(67,'1118065584921456',3,10,'2016-06-30 15:26:36'),(68,'1097834436943522',16,1,'2016-06-30 15:28:02'),(69,'1097834896943476',2,10,'2016-06-30 15:29:32'),(72,'1122885254439489',11,1,'2016-07-08 15:41:02'),(73,'1122887394439275',3,1,'2016-07-08 15:47:36'),(74,'1122891911105490',17,1,'2016-07-08 16:01:43'),(75,'1122893001105381',12,1,'2016-07-08 16:04:55'),(76,'1103180896408876',18,10,'2016-07-08 16:37:58'),(78,'1122908981103783',18,1,'2016-07-08 16:45:12');

  KEY `fk_article_categories__category_articles_category1_idx` (`category_articles`),
  CONSTRAINT `fk_article_categories` FOREIGN KEY (`category_articles`) REFERENCES `category` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `fk_category_articles` FOREIGN KEY (`article_categories`) REFERENCES `article` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--

/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `article_related` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `main` int(10) unsigned NOT NULL,
  `related` int(10) unsigned NOT NULL,
  `createdAt` datetime DEFAULT NULL,
  PRIMARY KEY (`id`,`related`,`main`),
  UNIQUE KEY `article_UNIQUE` (`main`,`related`),
  KEY `fk_main_article_idx` (`main`),
  KEY `fk_related_article_idx` (`related`),
  CONSTRAINT `fk_main_article` FOREIGN KEY (`main`) REFERENCES `article` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `fk_related_article` FOREIGN KEY (`related`) REFERENCES `article` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
