   `idUserType` tinyint(1) DEFAULT NULL,
   PRIMARY KEY (`id`),
   KEY `user_userType_idx` (`idUserType`)
-) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
+) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --

CREATE PROCEDURE `specificTopic_generalTopic_select`()
BEGIN

  SELECT idSpecificTopic, idGeneralTopic
  FROM specificTopic_generalTopic;
  
END ;;
DELIMITER ;

CREATE PROCEDURE `collective_comunarrProject_select`()
BEGIN

	SELECT idCollective, idComunarrProject
	FROM collective_comunarrProject AS CC
	INNER JOIN comunarr.comunarrProject AS C ON CC.idComunarrProject = C.id AND C.status = 1;

END ;;
DELIMITER ;
