   CONSTRAINT `idPrivacyType` FOREIGN KEY (`idPrivacyType`) REFERENCES `privacyType` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
   CONSTRAINT `idSpecificTopic` FOREIGN KEY (`idSpecificTopic`) REFERENCES `specificTopic` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
   CONSTRAINT `idUser` FOREIGN KEY (`idUser`) REFERENCES `user` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
-) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8;
+) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --

    
	ELSE
    
		# Delete the file's key words relations
        DELETE FROM comunarr.keyWord_file WHERE idFile = p_id;
        
        # Delete the file register
        DELETE FROM comunarr.file WHERE id = p_id;
        
        SELECT p_id AS 'id';
        
    END IF;

CREATE PROCEDURE `specificTopic_generalTopic_select`()
BEGIN

	SELECT idSpecificTopic,idGeneralTopic
	FROM specificTopic_generalTopic AS SG
	INNER JOIN comunarr.generalTopic AS G ON SG.idGeneralTopic = G.id AND G.status = 1;
  
END ;;
DELIMITER ;
