text: -- MySQL dump 10.16  Distrib 10.1.32-MariaDB, for Win32 (AMD64)
  --
  -- Host: localhost    Database: dbpictures
  -- ------------------------------------------------------
  -- Server version	10.1.32-MariaDB
  
  /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  /*!40101 SET NAMES utf8 */;
  /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
  /*!40103 SET TIME_ZONE='+00:00' */;
  /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
  /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
  /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
  /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
  
  --
  -- Table structure for table `category`
  --
  
  DROP TABLE IF EXISTS `category`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `category` (
    `idcategory` int(11) NOT NULL AUTO_INCREMENT,
    `idproject` int(11) NOT NULL,
    `name` varchar(128) NOT NULL,
    `trash` int(1) NOT NULL DEFAULT '0',
    PRIMARY KEY (`idcategory`)
  ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `category`
  --
  
  LOCK TABLES `category` WRITE;
  /*!40000 ALTER TABLE `category` DISABLE KEYS */;
  /*!40000 ALTER TABLE `category` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `comment`
  --
  
  DROP TABLE IF EXISTS `comment`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `comment` (
    `idcomment` int(11) NOT NULL AUTO_INCREMENT,
    `idconversation` int(11) DEFAULT NULL,
    `iduser` int(11) DEFAULT NULL,
    `name` varchar(128) NOT NULL,
    `text` text CHARACTER SET latin1 NOT NULL,
    `created` datetime NOT NULL,
    PRIMARY KEY (`idcomment`),
    KEY `iduser` (`idconversation`),
    KEY `idimage` (`iduser`)
  ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `comment`
  --
  
  LOCK TABLES `comment` WRITE;
  /*!40000 ALTER TABLE `comment` DISABLE KEYS */;
  /*!40000 ALTER TABLE `comment` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `conversation`
  --
  
  DROP TABLE IF EXISTS `conversation`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `conversation` (
    `idconversation` int(11) NOT NULL AUTO_INCREMENT,
    `idowner` int(11) NOT NULL,
    `owner` varchar(128) NOT NULL,
    `affair` varchar(128) NOT NULL,
    `posx` double NOT NULL,
    `posy` double NOT NULL,
    PRIMARY KEY (`idconversation`)
  ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `conversation`
  --
  
  LOCK TABLES `conversation` WRITE;
  /*!40000 ALTER TABLE `conversation` DISABLE KEYS */;
  /*!40000 ALTER TABLE `conversation` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `file`
  --
  
  DROP TABLE IF EXISTS `file`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `file` (
    `idfile` int(11) NOT NULL AUTO_INCREMENT,
    `iduser` int(11) DEFAULT '0',
    `idowner` int(11) DEFAULT '0',
    `idparent` int(11) DEFAULT '0',
    `owner` varchar(50) DEFAULT NULL,
    `name` varchar(128) DEFAULT NULL,
    `size` int(11) DEFAULT '0',
    `bucket` varchar(30) DEFAULT NULL,
    `path` varchar(128) DEFAULT NULL,
    `uploaded` datetime DEFAULT NULL,
    `description` varchar(200) DEFAULT NULL,
    `width` int(11) DEFAULT '0',
    `height` int(11) DEFAULT '0',
    PRIMARY KEY (`idfile`)
  ) ENGINE=InnoDB AUTO_INCREMENT=45 DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `file`
  --
  
  LOCK TABLES `file` WRITE;
  /*!40000 ALTER TABLE `file` DISABLE KEYS */;
  /*!40000 ALTER TABLE `file` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `history`
  --
  
  DROP TABLE IF EXISTS `history`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `history` (
    `idhistory` int(11) NOT NULL AUTO_INCREMENT,
    `idimage` int(11) NOT NULL,
    `guid` varchar(128) NOT NULL,
    `trash` int(1) NOT NULL DEFAULT '0',
    `created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
    PRIMARY KEY (`idhistory`)
  ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `history`
  --
  
  LOCK TABLES `history` WRITE;
  /*!40000 ALTER TABLE `history` DISABLE KEYS */;
  /*!40000 ALTER TABLE `history` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `image`
  --
  
  DROP TABLE IF EXISTS `image`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `image` (
    `idimage` int(11) NOT NULL AUTO_INCREMENT,
    `idcategory` int(11) NOT NULL,
    `idassociate` int(11) NOT NULL DEFAULT '0',
    `type` int(11) NOT NULL DEFAULT '1',
    `name` varchar(128) CHARACTER SET latin1 NOT NULL,
    `description` text CHARACTER SET latin1,
    `created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `archived` int(1) NOT NULL,
    `trash` int(1) NOT NULL DEFAULT '0',
    `guid` varchar(255) NOT NULL,
    PRIMARY KEY (`idimage`),
    KEY `idcategory` (`idcategory`)
  ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `image`
  --
  
  LOCK TABLES `image` WRITE;
  /*!40000 ALTER TABLE `image` DISABLE KEYS */;
  INSERT INTO `image` VALUES (1,1,0,1,'Nueva Imagen','AquÃ­ va la descripciÃ³n','2018-05-23 09:13:23',0,1,'5D007AF7A77A850B5265936474FF6628'),(2,1,3,1,'aibge','AquÃ­ va la descripciÃ³n','2018-05-23 09:13:48',0,0,'46A2E140F8905F15A9195A977A096390'),(3,1,2,2,'aibge','AquÃ­ va la descripciÃ³n','2018-05-23 09:16:11',0,0,'E8BE46A9D68E859F24E1933FBCD13479'),(4,1,0,1,'Nueva Imagen','AquÃ­ va la descripciÃ³n','2018-05-23 09:16:59',0,0,'80137E05ED034CC28AEC6985259BF676'),(5,3,0,1,'Nueva Imagen','a','2018-05-23 09:31:57',0,0,'BB901EA843AAB7F972BFBE6D2B4B7805');
  /*!40000 ALTER TABLE `image` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `notification`
  --
  
  DROP TABLE IF EXISTS `notification`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `notification` (
    `idnotification` int(11) NOT NULL AUTO_INCREMENT,
    `idconversation` int(11) NOT NULL,
    `user` int(11) NOT NULL,
    `viewed` int(1) NOT NULL,
    `created` datetime NOT NULL,
    PRIMARY KEY (`idnotification`)
  ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `notification`
  --
  
  LOCK TABLES `notification` WRITE;
  /*!40000 ALTER TABLE `notification` DISABLE KEYS */;
  INSERT INTO `notification` VALUES (1,1,1,1,'2018-05-23 09:14:21'),(2,2,1,1,'2018-05-23 09:14:40');
  /*!40000 ALTER TABLE `notification` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `project`
  --
  
  DROP TABLE IF EXISTS `project`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `project` (
    `idproject` int(11) NOT NULL AUTO_INCREMENT,
    `name` varchar(128) CHARACTER SET latin1 NOT NULL,
    `created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `archived` int(1) NOT NULL DEFAULT '0',
    `trash` int(1) NOT NULL DEFAULT '0',
    PRIMARY KEY (`idproject`)
  ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `project`
  --
  
  LOCK TABLES `project` WRITE;
  /*!40000 ALTER TABLE `project` DISABLE KEYS */;
  INSERT INTO `project` VALUES (1,'a','2018-05-23 09:13:08',1,0),(2,'Nuevo Proyecto','2018-05-23 09:31:53',0,0);
  /*!40000 ALTER TABLE `project` 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` (
    `iduser` int(11) NOT NULL AUTO_INCREMENT,
    `name` varchar(128) CHARACTER SET latin1 NOT NULL,
    `password` varchar(128) CHARACTER SET latin1 NOT NULL,
    PRIMARY KEY (`iduser`)
  ) ENGINE=InnoDB AUTO_INCREMENT=3 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,'goplek','1234abcd'),(2,'ivan','1234');
  /*!40000 ALTER TABLE `user` 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 2018-05-23 14:13:41
  