
--
-- Table structure for table `tbg_userscopes`
--

CREATE TABLE `tbg_userscopes` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `scope` int(10) unsigned DEFAULT '0',
  `confirmed` tinyint(1) DEFAULT '0',
  `user_id` int(10) unsigned DEFAULT '0',
  `group_id` int(10) unsigned DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `tbg_userscopes_uid_scope` (`user_id`,`scope`),
  KEY `tbg_userscopes_groupid_scope` (`group_id`,`scope`)
) ENGINE=InnoDB AUTO_INCREMENT=2170 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tbg_userscopes`
--

INSERT INTO `tbg_userscopes` VALUES (1,1,1,1,1),(2,1,1,2,3),(3,1,1,2,3),(4,1,1,1,1),(5,1,1,3,1),(7,1,1,5,2),(8,1,1,6,2),(9,1,1,7,2),(10,1,1,8,2),(12,1,1,10,2),(13,1,1,11,2),(14,1,1,12,2),(15,1,1,13,4),(16,1,1,14,2),(17,1,1,15,4),(24,1,1,22,2),(25,1,1,23,4),(26,1,1,24,2),(27,1,1,25,4),(28,1,1,26,2),(29,1,1,27,4),(30,1,1,28,4),(31,1,1,29,2),(32,1,1,30,2),(33,1,1,31,2),(34,1,1,32,4),(35,1,1,33,4),(36,1,1,34,2),(37,1,1,35,2),(38,1,1,36,2),(39,1,1,37,4),(40,1,1,38,4),(41,1,1,39,4),(42,1,1,40,4),(43,1,1,41,4),(44,1,1,42,4),(45,1,1,43,4),(46,1,1,44,4),(47,1,1,45,4),(48,1,1,46,4),(49,1,1,47,4),(50,1,1,48,4),(51,1,1,49,4),(52,1,1,50,4),(53,1,1,51,4),(54,1,1,52,4),(55,1,1,53,4),(56,1,1,54,4),(57,1,1,55,4),(58,1,1,56,4),(59,1,1,57,4),(60,1,1,58,4),(61,1,1,59,4),(62,1,1,60,4),(63,1,1,61,4),(64,1,1,62,4),(65,1,1,63,4),(66,1,1,64,4),(67,1,1,65,4),(68,1,1,66,4),(69,1,1,67,4),(70,1,1,68,4),(71,1,1,69,2),(72,1,1,70,4),(73,1,1,71,4),(74,1,1,72,4),(75,1,1,73,4),(76,1,1,74,4),(77,1,1,75,4),(78,1,1,76,4),(79,1,1,77,2),(80,1,1,78,1),(81,2,1,2,6),(82,2,1,1,5),(83,3,1,2,9),(84,3,1,1,8),(85,1,1,79,2),(86,1,1,80,4),(87,1,1,81,4),(88,1,1,82,4),(89,1,1,83,4),(90,1,1,84,4),(91,1,1,85,4),(92,1,1,86,4),(93,1,1,87,4),(94,1,1,88,4),(95,1,1,89,4),(96,1,1,90,4),(97,1,1,91,4),(98,1,1,92,4),(99,1,1,93,4),(100,1,1,94,4),(101,3,1,94,8),(102,1,1,95,4),(103,3,1,95,8),(104,1,1,96,4),(105,1,1,97,12),(107,1,1,98,12),(108,1,1,99,12),(109,1,1,100,12),(110,1,1,101,12),(111,1,1,102,12),(112,1,1,103,12),(113,1,1,104,12),(114,1,1,105,12),(115,1,1,106,12),(116,1,1,107,12),(117,1,1,108,12),(118,1,1,109,12),(119,1,1,110,12),(120,1,1,111,12),(121,1,1,112,12),(122,1,1,113,12),(123,1,1,114,12),(124,1,1,115,12),(125,1,1,116,12),(126,1,1,117,12),(127,1,1,118,12),(128,1,1,119,12),(129,1,1,120,4),(130,3,1,120,11),(131,1,1,121,4),(132,1,1,122,12),(133,3,0,NULL,9),(134,1,1,123,4),(135,3,1,123,9),(136,2,0,NULL,6),(137,1,1,124,4),(138,2,1,124,6),(139,1,1,125,4),(140,3,1,125,9),(141,1,1,126,4),(142,3,1,126,9),(143,1,0,NULL,4),(144,1,1,127,4),(145,1,1,128,4),(146,1,1,129,4),(147,1,1,130,4),(148,1,1,131,4),(149,1,1,132,4),(150,1,1,133,4),(151,1,1,134,1),(152,1,1,135,4),(153,1,1,136,4),(154,1,1,137,4),(155,1,1,138,4),(156,1,1,139,4),(157,1,1,140,4),(158,1,1,141,4),(159,1,1,142,4),(160,1,1,143,4),(161,1,1,144,4),(162,1,1,145,4),(163,1,1,146,4),(164,1,1,147,4),(165,1,1,148,4),(166,1,1,149,4),(167,1,1,150,4),(168,1,1,151,4),(169,1,1,152,4),(170,1,1,153,4),(171,1,1,154,4),(172,1,1,155,4),(173,1,1,156,4),(174,1,1,157,4),(175,1,1,158,4),(176,1,1,159,4),(177,1,1,160,4),(178,1,1,161,4),(179,1,1,162,4),(180,1,1,163,4),(181,1,1,164,4),(182,1,1,165,4),(183,1,1,166,4),(184,1,1,167,4),(185,1,1,168,4),(186,1,1,169,4),(187,1,1,170,4),(188,1,1,171,4),(189,1,1,172,4),(190,1,1,173,4),(191,1,1,174,4),(192,1,1,175,4),(193,1,1,176,4),(194,1,1,177,4),(195,1,1,178,4),(196,1,1,179,4),(197,1,1,180,4),(198,1,1,181,4),(199,1,1,182,4),(200,1,1,183,4),(201,1,1,184,4),(202,1,1,185,4),(203,1,1,186,4),(204,1,1,187,4),(205,1,1,188,4),(206,1,1,189,4),(207,1,1,190,4),(208,1,1,191,4),(209,1,1,192,4),(210,1,1,193,4),(211,1,1,194,4),(212,1,1,195,4),(213,1,1,196,4),(214,1,1,197,4),(215,1,1,198,4),(216,1,1,199,4),(217,1,1,200,4),(218,1,1,201,4),(219,1,1,202,4),(220,1,1,203,4),(221,1,1,204,4),(222,1,1,205,4),(223,1,1,206,4),(224,1,1,207,4),(225,1,1,208,4),(226,1,1,209,4),(227,1,1,210,4),(228,1,1,211,4),(229,1,1,212,4),(230,1,1,213,4),(231,1,1,214,4),(232,1,1,215,4),(233,1,1,216,4),(234,1,1,217,4),(235,1,1,218,4),(236,1,1,219,4),(237,1,1,220,4),(238,1,1,221,4),(239,1,1,222,4),(240,1,1,223,4),(241,1,1,224,4),(242,1,1,225,4),(243,1,1,226,4),(244,1,1,227,4),(245,1,1,228,4),(246,1,1,229,4),(247,1,1,230,4),(248,1,1,231,4),(249,1,1,232,4),(250,1,1,233,4),(251,1,1,234,4),(252,1,1,235,4),(253,1,1,236,4),(254,1,1,237,4),(255,1,1,238,4),(256,1,1,239,4),(257,1,1,240,4),(258,1,1,241,4),(259,1,1,242,4),(260,1,1,243,4),(261,1,1,244,4),(262,1,1,245,4),(263,1,1,246,4),(264,1,1,247,4),(265,1,1,248,4),(266,1,1,249,4),(267,1,1,250,4),(268,1,1,251,4),(269,1,1,252,4),(270,1,1,253,4),(271,1,1,254,4),(272,1,1,255,4),(273,1,1,256,4),(274,1,1,257,4),(275,1,1,258,4),(276,1,1,259,4),(277,1,1,260,4),(278,1,1,261,4),(279,1,1,262,4),(280,1,1,263,4),(281,1,1,264,4),(282,1,1,265,4),(283,1,1,266,4),(284,1,1,267,4),(285,1,1,268,4),(286,1,1,269,4),(287,1,1,270,4),(288,1,1,271,4),(289,1,1,272,4),(290,1,1,273,4),(291,1,1,274,4),(292,1,1,275,4),(293,1,1,276,4),(294,1,1,277,4),(295,1,1,278,4),(296,1,1,279,4),(297,1,1,280,4),(298,1,1,281,4),(299,1,1,282,4),(300,1,1,283,4),(301,1,1,284,4),(302,1,1,285,4),(303,1,1,286,4),(304,1,1,287,4),(305,1,1,288,4),(306,1,1,289,4),(307,1,1,290,4),(308,1,1,291,4),(309,1,1,292,4),(310,1,1,293,4),(311,1,1,294,4),(312,1,1,295,4),(313,1,1,296,4),(314,1,1,297,4),(315,1,1,298,4),(316,1,1,299,4),(317,1,1,300,4),(318,1,1,301,4),(319,1,1,302,4),(320,1,1,303,4),(321,1,1,304,4),(322,1,1,305,4),(323,1,1,306,4),(324,1,1,307,4),(325,1,1,308,4),(326,1,1,309,4),(327,1,1,310,4),(328,1,1,311,4),(329,1,1,312,4),(330,1,1,313,4),(331,1,1,314,4),(332,1,1,315,4),(333,1,1,316,4),(334,1,1,317,4),(335,1,1,318,4),(336,1,1,319,4),(337,1,1,320,4),(338,1,1,321,4),(339,1,1,322,4),(340,1,1,323,4),(341,1,1,324,4),(342,1,1,325,4),(343,1,1,326,4),(344,1,1,327,4),(345,1,1,328,4),(346,1,1,329,4),(347,1,1,330,4),(348,1,1,331,4),(349,1,1,332,4),(350,1,1,333,4),(351,1,1,334,4),(352,1,1,335,4),(353,1,1,336,4),(354,1,1,337,4),(355,1,1,338,4),(356,1,1,339,4),(357,1,1,340,4),(358,1,1,341,4),(359,1,1,342,4),(360,1,1,343,4),(361,1,1,344,4),(362,1,1,345,4),(363,1,1,346,4),(364,1,1,347,4),(365,1,1,348,4),(366,1,1,349,4),(367,1,1,350,4),(368,1,1,351,4),(369,1,1,352,4),(370,1,1,353,4),(371,1,1,354,4),(372,1,1,355,4),(373,1,1,356,4),(374,1,1,357,4),(375,1,1,358,4),(376,1,1,359,4),(377,1,1,360,4),(378,1,1,361,4),(379,1,1,362,4),(380,1,1,363,4),(381,1,1,364,4),(382,1,1,365,4),(383,1,1,366,4),(384,1,1,367,4),(385,1,1,368,4),(386,1,1,369,4),(387,1,1,370,4),(388,1,1,371,4),(389,1,1,372,4),(390,1,1,373,4),(391,1,1,374,4),(392,1,1,375,4),(393,1,1,376,4),(394,1,1,377,4),(395,1,1,378,4),(396,1,1,379,4),(397,1,1,380,4),(398,1,1,381,4),(399,1,1,382,4),(400,1,1,383,4),(401,1,1,384,4),(402,1,1,385,4),(403,1,1,386,4),(404,1,1,387,4),(405,1,1,388,4),(406,1,1,389,4),(407,1,1,390,4),(408,1,1,391,4),(409,1,1,392,4),(410,1,1,393,4),(411,1,1,394,4),(412,1,1,395,4),(413,1,1,396,4),(414,1,1,397,4),(415,1,1,398,4),(416,1,1,399,4),(417,1,1,400,4),(418,1,1,401,4),(419,1,1,402,4),(420,1,1,403,4),(421,1,1,404,4),(422,1,1,405,4),(423,1,1,406,4),(424,1,1,407,4),(425,1,1,408,4),(426,1,1,409,4),(427,1,1,410,4),(428,1,1,411,4),(429,1,1,412,4),(430,1,1,413,4),(431,1,1,414,4),(432,1,1,415,4),(433,1,1,416,4),(434,1,1,417,4),(435,1,1,418,4),(436,1,1,419,4),(437,1,1,420,4),(438,1,1,421,4),(439,1,1,422,4),(440,1,1,423,4),(441,1,1,424,4),(442,1,1,425,4),(443,1,1,426,4),(444,1,1,427,4),(445,1,1,428,4),(446,1,1,429,4),(447,1,1,430,4),(448,1,1,431,4),(449,1,1,432,4),(450,1,1,433,4),(451,1,1,434,4),(452,1,1,435,4),(453,1,1,436,4),(454,1,1,437,4),(455,1,1,438,4),(456,1,1,439,4),(457,1,1,440,4),(458,1,1,441,4),(459,1,1,442,4),(460,1,1,443,4),(461,1,1,444,4),(462,1,1,445,4),(463,1,1,446,4),(464,1,1,447,4),(465,1,1,448,4),(466,1,1,449,4),(467,1,1,450,4),(468,1,1,451,4),(469,1,1,452,4),(470,1,1,453,4),(471,1,1,454,4),(472,1,1,455,4),(473,1,1,456,4),(474,1,1,457,4),(475,1,1,458,4),(476,1,1,459,4),(477,1,1,460,4),(478,1,1,461,4),(479,1,1,462,4),(480,1,1,463,4),(481,1,1,464,4),(482,1,1,465,4),(483,1,1,466,4),(484,1,1,467,4),(485,1,1,468,4),(486,1,1,469,4),(487,1,1,470,4),(488,1,1,471,4),(489,1,1,472,4),(490,1,1,473,4),(491,1,1,474,4),(492,1,1,475,4),(493,1,1,476,4),(494,1,1,477,4),(495,1,1,478,4),(496,1,1,479,4),(497,1,1,480,4),(498,1,1,481,4),(499,1,1,482,4),(500,1,1,483,4),(501,1,1,484,4),(502,1,1,485,4),(503,1,1,486,4),(504,1,1,487,4),(505,1,1,488,4),(506,1,1,489,4),(507,1,1,490,4),(508,1,1,491,4),(509,1,1,492,4),(510,1,1,493,4),(511,1,1,494,4),(512,1,1,495,4),(513,1,1,496,4),(514,1,1,497,4),(515,1,1,498,4),(516,1,1,499,4),(517,1,1,500,4),(518,1,1,501,4),(519,1,1,502,4),(520,1,1,503,4),(521,1,1,504,4),(522,1,1,505,4),(523,1,1,506,4),(524,1,1,507,4),(525,1,1,508,4),(526,1,1,509,4),(527,1,1,510,4),(528,1,1,511,4),(529,1,1,512,4),(530,1,1,513,4),(531,1,1,514,4),(532,1,1,515,4),(533,1,1,516,4),(534,1,1,517,4),(535,1,1,518,4),(536,1,1,519,4),(537,1,1,520,4),(538,1,1,521,4),(539,1,1,522,4),(540,1,1,523,4),(541,1,1,524,4),(542,1,1,525,4),(543,1,1,526,4),(544,1,1,527,4),(545,1,1,528,4),(546,1,1,529,4),(547,1,1,530,4),(548,1,1,531,4),(549,1,1,532,4),(550,1,1,533,4),(551,1,1,534,4),(552,1,1,535,4),(553,1,1,536,4),(554,1,1,537,4),(555,1,1,538,4),(556,1,1,539,4),(557,1,1,540,4),(558,1,1,541,4),(559,1,1,542,4),(560,1,1,543,4),(561,1,1,544,4),(562,1,1,545,4),(563,1,1,546,4),(564,1,1,547,4),(565,1,1,548,4),(566,1,1,549,4),(567,1,1,550,4),(568,1,1,551,4),(569,1,1,552,4),(570,1,1,553,4),(571,1,1,554,4),(572,1,1,555,4),(573,1,1,556,4),(574,1,1,557,4),(575,1,1,558,4),(576,1,1,559,4),(577,1,1,560,4),(578,1,1,561,4),(579,1,1,562,4),(580,1,1,563,4),(581,1,1,564,4),(582,1,1,565,4),(583,1,1,566,4),(584,1,1,567,4),(585,1,1,568,4),(586,1,1,569,4),(587,1,1,570,4),(588,1,1,571,4),(589,1,1,572,4),(590,1,1,573,4),(591,1,1,574,4),(592,1,1,575,4),(593,1,1,576,4),(594,1,1,577,4),(595,1,1,578,4),(596,1,1,579,4),(597,1,1,580,4),(598,1,1,581,4),(599,1,1,582,4),(600,1,1,583,4),(601,1,1,584,4),(602,1,1,585,4),(603,1,1,586,4),(604,1,1,587,4),(605,1,1,588,4),(606,1,1,589,4),(607,1,1,590,4),(608,1,1,591,4),(609,1,1,592,4),(610,1,1,593,4),(611,1,1,594,4),(612,1,1,595,4),(613,1,1,596,4),(614,1,1,597,4),(615,1,1,598,4),(616,1,1,599,4),(617,1,1,600,4),(618,1,1,601,4),(619,1,1,602,4),(620,1,1,603,4),(621,1,1,604,4),(622,1,1,605,4),(623,1,1,606,4),(624,1,1,607,4),(625,1,1,608,4),(626,1,1,609,4),(627,1,1,610,4),(628,1,1,611,4),(629,1,1,612,4),(630,1,1,613,4),(631,1,1,614,4),(632,1,1,615,4),(633,1,1,616,4),(634,1,1,617,4),(635,1,1,618,4),(636,1,1,619,4),(637,1,1,620,4),(638,1,1,621,4),(639,1,1,622,4),(640,1,1,623,4),(641,1,1,624,4),(642,1,1,625,4),(643,1,1,626,4),(644,1,1,627,4),(645,1,1,628,4),(646,1,1,629,4),(647,1,1,630,4),(648,1,1,631,4),(649,1,1,632,4),(650,1,1,633,4),(651,1,1,634,4),(652,1,1,635,4),(653,1,1,636,4),(654,1,1,637,4),(655,1,1,638,4),(656,1,1,639,4),(657,1,1,640,4),(658,1,1,641,4),(659,1,1,642,4),(660,1,1,643,4),(661,1,1,644,4),(662,1,1,645,4),(663,1,1,646,4),(664,1,1,647,4),(665,1,1,648,4),(666,1,1,649,4),(667,1,1,650,4),(668,1,1,651,4),(669,1,1,652,4),(670,1,1,653,4),(671,1,1,654,4),(672,1,1,655,4),(673,1,1,656,4),(674,1,1,657,4),(675,1,1,658,4),(676,1,1,659,4),(677,1,1,660,4),(678,1,1,661,4),(679,1,1,662,4),(680,1,1,663,4),(681,1,1,664,4),(682,1,1,665,4),(683,1,1,666,4),(684,1,1,667,4),(685,1,1,668,4),(686,1,1,669,4),(687,1,1,670,4),(688,1,1,671,4),(689,1,1,672,4),(690,1,1,673,4),(691,1,1,674,4),(692,1,1,675,4),(693,1,1,676,4),(694,1,1,677,4),(695,1,1,678,4),(696,1,1,679,4),(697,1,1,680,4),(698,1,1,681,4),(699,1,1,682,4),(700,1,1,683,4),(701,1,1,684,4),(702,1,1,685,4),(703,1,1,686,4),(704,1,1,687,4),(705,1,1,688,4),(706,1,1,689,4),(707,1,1,690,4),(708,1,1,691,4),(709,1,1,692,4),(710,1,1,693,4),(711,1,1,694,4),(712,1,1,695,4),(713,1,1,696,4),(714,1,1,697,4),(715,1,1,698,4),(716,1,1,699,4),(717,1,1,700,4),(718,1,1,701,4),(719,1,1,702,4),(720,1,1,703,4),(721,1,1,704,4),(722,1,1,705,4),(723,1,1,706,4),(724,1,1,707,4),(725,1,1,708,4),(726,1,1,709,4),(727,1,1,710,4),(728,1,1,711,4),(729,1,1,712,4),(730,1,1,713,4),(731,1,1,714,4),(732,1,1,715,4),(733,1,1,716,4),(734,1,1,717,4),(735,1,1,718,4),(736,1,1,719,4),(737,1,1,720,4),(738,1,1,721,4),(739,1,1,722,4),(740,1,1,723,4),(741,1,1,724,4),(742,1,1,725,4),(743,1,1,726,4),(744,1,1,727,4),(745,1,1,728,4),(746,1,1,729,4),(747,1,1,730,4),(748,1,1,731,4),(749,1,1,732,4),(750,1,1,733,4),(751,1,1,734,4),(752,1,1,735,4),(753,1,1,736,4),(754,1,1,737,4),(755,1,1,738,4),(756,1,1,739,4),(757,1,1,740,4),(758,1,1,741,4),(759,1,1,742,4),(760,1,1,743,4),(761,1,1,744,4),(762,1,1,745,4),(763,1,1,746,4),(764,1,1,747,4),(765,1,1,748,4),(766,1,1,749,4),(767,1,1,750,4),(768,1,1,751,4),(769,1,1,752,4),(770,1,1,753,4),(771,1,1,754,4),(772,1,1,755,4),(773,1,1,756,4),(774,1,1,757,4),(775,1,1,758,4),(776,1,1,759,4),(777,1,1,760,4),(778,1,1,761,4),(779,1,1,762,4),(780,1,1,763,4),(781,1,1,764,4),(782,1,1,765,4),(783,1,1,766,4),(784,1,1,767,4),(785,1,1,768,4),(786,1,1,769,4),(787,1,1,770,4),(788,1,1,771,4),(789,1,1,772,4),(790,1,1,773,4),(791,1,1,774,4),(792,1,1,775,4),(793,1,1,776,4),(794,1,1,777,4),(795,1,1,778,4),(796,1,1,779,4),(797,1,1,780,4),(798,1,1,781,4),(799,1,1,782,4),(800,1,1,783,4),(801,1,1,784,4),(802,1,1,785,4),(803,1,1,786,4),(804,1,1,787,4),(805,1,1,788,4),(806,1,1,789,4),(807,1,1,790,4),(808,1,1,791,4),(809,1,1,792,4),(810,1,1,793,4),(811,1,1,794,4),(812,1,1,795,4),(813,1,1,796,4),(814,1,1,797,4),(815,1,1,798,4),(816,1,1,799,4),(817,1,1,800,4),(818,1,1,801,4),(819,1,1,802,4),(820,1,1,803,4),(821,1,1,804,4),(822,1,1,805,4),(823,1,1,806,4),(824,1,1,807,4),(825,1,1,808,4),(826,1,1,809,4),(827,1,1,810,4),(828,1,1,811,4),(829,1,1,812,4),(830,1,1,813,4),(831,1,1,814,4),(832,1,1,815,4),(833,1,1,816,4),(834,1,1,817,4),(835,1,1,818,4),(836,1,1,819,4),(837,1,1,820,4),(838,1,1,821,4),(839,1,1,822,4),(840,1,1,823,4),(841,1,1,824,4),(842,1,1,825,4),(843,1,1,826,4),(844,1,1,827,4),(845,1,1,828,4),(846,1,1,829,4),(847,1,1,830,4),(848,1,1,831,4),(849,1,1,832,4),(850,1,1,833,4),(851,1,1,834,4),(852,1,1,835,4),(853,1,1,836,4),(854,1,1,837,4),(855,1,1,838,4),(856,1,1,839,4),(857,1,1,840,4),(858,1,1,841,4),(859,1,1,842,4),(860,1,1,843,4),(861,1,1,844,4),(862,1,1,845,4),(863,1,1,846,4),(864,1,1,847,4),(865,1,1,848,4),(866,1,1,849,4),(867,1,1,850,4),(868,1,1,851,4),(869,1,1,852,4),(870,1,1,853,4),(871,1,1,854,4),(872,1,1,855,4),(873,1,1,856,4),(874,1,1,857,4),(875,1,1,858,4),(876,1,1,859,4),(877,1,1,860,4),(878,1,1,861,4),(879,1,1,862,4),(880,1,1,863,4),(881,1,1,864,4),(882,1,1,865,4),(883,1,1,866,4),(884,1,1,867,4),(885,1,1,868,4),(886,1,1,869,4),(887,1,1,870,4),(888,1,1,871,4),(889,1,1,872,4),(890,1,1,873,4),(891,1,1,874,4),(892,1,1,875,4),(893,1,1,876,4),(894,1,1,877,4),(895,1,1,878,4),(896,1,1,879,4),(897,1,1,880,4),(898,1,1,881,4),(899,1,1,882,4),(900,1,1,883,4),(901,1,1,884,4),(902,1,1,885,4),(903,1,1,886,4),(904,1,1,887,4),(905,1,1,888,4),(906,1,1,889,4),(907,1,1,890,4),(908,1,1,891,4),(909,1,1,892,4),(910,1,1,893,4),(911,1,1,894,4),(912,1,1,895,4),(913,1,1,896,4),(914,1,1,897,4),(915,1,1,898,4),(916,1,1,899,4),(917,1,1,900,4),(918,1,1,901,4),(919,1,1,902,4),(920,1,1,903,4),(921,1,1,904,4),(922,1,1,905,4),(923,1,1,906,4),(924,1,1,907,4),(925,1,1,908,4),(926,1,1,909,4),(927,1,1,910,4),(928,1,1,911,4),(929,1,1,912,4),(930,1,1,913,4),(931,1,1,914,4),(932,1,1,915,4),(933,1,1,916,4),(934,1,1,917,4),(935,1,1,918,4),(936,1,1,919,4),(937,1,1,920,4),(938,1,1,921,4),(939,1,1,922,4),(940,1,1,923,4),(941,1,1,924,4),(942,1,1,925,4),(943,1,1,926,4),(944,1,1,927,4),(945,1,1,928,4),(946,1,1,929,4),(947,1,1,930,4),(948,1,1,931,4),(949,1,1,932,4),(950,1,1,933,4),(951,1,1,934,4),(952,1,1,935,4),(953,1,1,936,4),(954,1,1,937,4),(955,1,1,938,4),(956,1,1,939,4),(957,1,1,940,4),(958,1,1,941,4),(959,1,1,942,4),(960,1,1,943,4),(961,1,1,944,4),(962,1,1,945,4),(963,1,1,946,4),(964,1,1,947,4),(965,1,1,948,4),(966,1,1,949,4),(967,1,1,950,4),(968,1,1,951,4),(969,1,1,952,4),(970,1,1,953,4),(971,1,1,954,4),(972,1,1,955,4),(973,1,1,956,4),(974,1,1,957,4),(975,1,1,958,4),(976,1,1,959,4),(977,1,1,960,4),(978,1,1,961,4),(979,1,1,962,4),(980,1,1,963,4),(981,1,1,964,4),(982,1,1,965,4),(983,1,1,966,4),(984,1,1,967,4),(985,1,1,968,4),(986,1,1,969,4),(987,1,1,970,4),(988,1,1,971,4),(989,1,1,972,4),(990,1,1,973,4),(991,1,1,974,4),(992,1,1,975,4),(993,1,1,976,4),(994,1,1,977,4),(995,1,1,978,4),(996,1,1,979,4),(997,1,1,980,4),(998,1,1,981,4),(999,1,1,982,4),(1000,1,1,983,4),(1001,1,1,984,4),(1002,1,1,985,4),(1003,1,1,986,4),(1004,1,1,987,4),(1005,1,1,988,4),(1006,1,1,989,4),(1007,1,1,990,4),(1008,1,1,991,4),(1009,1,1,992,4),(1010,1,1,993,4),(1011,1,1,994,4),(1012,1,1,995,4),(1013,1,1,996,4),(1014,1,1,997,4),(1015,1,1,998,4),(1016,1,1,999,4),(1017,1,1,1000,4),(1018,1,1,1001,4),(1019,1,1,1002,4),(1020,1,1,1003,4),(1021,1,1,1004,4),(1022,1,1,1005,4),(1023,1,1,1006,4),(1024,1,1,1007,4),(1025,1,1,1008,4),(1026,1,1,1009,4),(1027,1,1,1010,4),(1028,1,1,1011,4),(1029,1,1,1012,4),(1030,1,1,1013,4),(1031,1,1,1014,4),(1032,1,1,1015,4),(1033,1,1,1016,4),(1034,1,1,1017,4),(1035,1,1,1018,4),(1036,1,1,1019,4),(1037,1,1,1020,4),(1038,1,1,1021,4),(1039,1,1,1022,4),(1040,1,1,1023,4),(1041,1,1,1024,4),(1042,1,1,1025,4),(1043,1,1,1026,4),(1044,1,1,1027,4),(1045,1,1,1028,4),(1046,1,1,1029,4),(1047,1,1,1030,4),(1048,1,1,1031,4),(1049,1,1,1032,4),(1050,1,1,1033,4),(1051,1,1,1034,4),(1052,1,1,1035,4),(1053,1,1,1036,4),(1054,1,1,1037,4),(1055,1,1,1038,4),(1056,1,1,1039,4),(1057,1,1,1040,4),(1058,1,1,1041,4),(1059,1,1,1042,4),(1060,1,1,1043,4),(1061,1,1,1044,4),(1062,1,1,1045,4),(1063,1,1,1046,4),(1064,1,1,1047,4),(1065,1,1,1048,4),(1066,1,1,1049,4),(1067,1,1,1050,4),(1068,1,1,1051,4),(1069,1,1,1052,4),(1070,1,1,1053,4),(1071,1,1,1054,4),(1072,1,1,1055,4),(1073,1,1,1056,4),(1074,1,1,1057,4),(1075,1,1,1058,4),(1076,1,1,1059,4),(1077,1,1,1060,4),(1078,1,1,1061,4),(1079,1,1,1062,4),(1080,1,1,1063,4),(1081,1,1,1064,4),(1082,1,1,1065,4),(1083,1,1,1066,4),(1084,1,1,1067,4),(1085,1,1,1068,4),(1086,1,1,1069,4),(1087,1,1,1070,4),(1088,1,1,1071,4),(1089,1,1,1072,4),(1090,1,1,1073,4),(1091,1,1,1074,4),(1092,1,1,1075,4),(1093,1,1,1076,4),(1094,1,1,1077,4),(1095,1,1,1078,4),(1096,1,1,1079,4),(1097,1,1,1080,4),(1098,1,1,1081,4),(1099,1,1,1082,4),(1100,1,1,1083,4),(1101,1,1,1084,4),(1102,1,1,1085,4),(1103,1,1,1086,4),(1104,1,1,1087,4),(1105,1,1,1088,4),(1106,1,1,1089,4),(1107,1,1,1090,4),(1108,1,1,1091,4),(1109,1,1,1092,4),(1110,1,1,1093,4),(1111,1,1,1094,4),(1112,1,1,1095,4),(1113,1,1,1096,4),(1114,1,1,1097,4),(1115,1,1,1098,4),(1116,1,1,1099,4),(1117,1,1,1100,4),(1118,1,1,1101,4),(1119,1,1,1102,4),(1120,1,1,1103,4),(1121,1,1,1104,4),(1122,1,1,1105,4),(1123,1,1,1106,4),(1124,1,1,1107,4),(1125,1,1,1108,4),(1126,1,1,1109,4),(1127,1,1,1110,4),(1128,1,1,1111,4),(1129,1,1,1112,4),(1130,1,1,1113,4),(1131,1,1,1114,4),(1132,1,1,1115,4),(1133,1,1,1116,4),(1134,1,1,1117,4),(1135,1,1,1118,4),(1136,1,1,1119,4),(1137,1,1,1120,4),(1138,1,1,1121,4),(1139,1,1,1122,4),(1140,1,1,1123,4),(1141,1,1,1124,4),(1142,1,1,1125,4),(1143,1,1,1126,4),(1144,1,1,1127,4),(1145,1,1,1128,4),(1146,1,1,1129,4),(1147,1,1,1130,4),(1148,1,1,1131,4),(1149,1,1,1132,4),(1150,1,1,1133,4),(1151,1,1,1134,4),(1152,1,1,1135,4),(1153,1,1,1136,4),(1154,1,1,1137,4),(1155,1,1,1138,4),(1156,1,1,1139,4),(1157,1,1,1140,4),(1158,1,1,1141,4),(1159,1,1,1142,4),(1160,1,1,1143,4),(1161,1,1,1144,4),(1162,1,1,1145,4),(1163,1,1,1146,4),(1164,1,1,1147,4),(1165,1,1,1148,4),(1166,1,1,1149,4),(1167,1,1,1150,4),(1168,1,1,1151,4),(1169,1,1,1152,4),(1170,1,1,1153,4),(1171,1,1,1154,4),(1172,1,1,1155,4),(1173,1,1,1156,4),(1174,1,1,1157,4),(1175,1,1,1158,4),(1176,1,1,1159,4),(1177,1,1,1160,4),(1178,1,1,1161,4),(1179,1,1,1162,4),(1180,1,1,1163,4),(1181,1,1,1164,4),(1182,1,1,1165,4),(1183,1,1,1166,4),(1184,1,1,1167,4),(1185,1,1,1168,4),(1186,1,1,1169,4),(1187,1,1,1170,4),(1188,1,1,1171,4),(1189,1,1,1172,4),(1190,1,1,1173,4),(1191,1,1,1174,4),(1192,1,1,1175,4),(1193,1,1,1176,4),(1194,1,1,1177,4),(1195,1,1,1178,4),(1196,1,1,1179,4),(1197,1,1,1180,4),(1198,1,1,1181,4),(1199,1,1,1182,4),(1200,1,1,1183,4),(1201,1,1,1184,4),(1202,1,1,1185,4),(1203,1,1,1186,4),(1204,1,1,1187,4),(1205,1,1,1188,4),(1206,1,1,1189,4),(1207,1,1,1190,4),(1208,1,1,1191,4),(1209,1,1,1192,4),(1210,1,1,1193,4),(1211,1,1,1194,4),(1212,1,1,1195,4),(1213,1,1,1196,4),(1214,1,1,1197,4),(1215,1,1,1198,4),(1216,1,1,1199,4),(1217,1,1,1200,4),(1218,1,1,1201,4),(1219,1,1,1202,4),(1220,1,1,1203,4),(1221,1,1,1204,4),(1222,1,1,1205,4),(1223,1,1,1206,4),(1224,1,1,1207,4),(1225,1,1,1208,4),(1226,1,1,1209,4),(1227,1,1,1210,4),(1228,1,1,1211,4),(1229,1,1,1212,4),(1230,1,1,1213,4),(1231,1,1,1214,4),(1232,1,1,1215,4),(1233,1,1,1216,4),(1234,1,1,1217,4),(1235,1,1,1218,4),(1236,1,1,1219,4),(1237,1,1,1220,4),(1238,1,1,1221,4),(1239,1,1,1222,4),(1240,1,1,1223,4),(1241,1,1,1224,4),(1242,1,1,1225,4),(1243,1,1,1226,4),(1244,1,1,1227,4),(1245,1,1,1228,4),(1246,1,1,1229,4),(1247,1,1,1230,4),(1248,1,1,1231,4),(1249,1,1,1232,4),(1250,1,1,1233,4),(1251,1,1,1234,4),(1252,1,1,1235,4),(1253,1,1,1236,4),(1254,1,1,1237,4),(1255,1,1,1238,4),(1256,1,1,1239,4),(1257,1,1,1240,4),(1258,1,1,1241,4),(1259,1,1,1242,4),(1260,1,1,1243,4),(1261,1,1,1244,4),(1262,1,1,1245,4),(1263,1,1,1246,4),(1264,1,1,1247,4),(1265,1,1,1248,4),(1266,1,1,1249,4),(1267,1,1,1250,4),(1268,1,1,1251,4),(1269,1,1,1252,4),(1270,1,1,1253,4),(1271,1,1,1254,4),(1272,1,1,1255,4),(1273,1,1,1256,4),(1274,1,1,1257,4),(1275,1,1,1258,4),(1276,1,1,1259,4),(1277,1,1,1260,4),(1278,1,1,1261,4),(1279,1,1,1262,4),(1280,1,1,1263,4),(1281,1,1,1264,4),(1282,1,1,1265,4),(1283,1,1,1266,4),(1284,1,1,1267,4),(1285,1,1,1268,4),(1286,1,1,1269,4),(1287,1,1,1270,4),(1288,1,1,1271,4),(1289,1,1,1272,4),(1290,1,1,1273,4),(1291,1,1,1274,4),(1292,1,1,1275,4),(1293,1,1,1276,4),(1294,1,1,1277,4),(1295,1,1,1278,4),(1296,1,1,1279,4),(1297,1,1,1280,4),(1298,1,1,1281,4),(1299,1,1,1282,4),(1300,1,1,1283,4),(1301,1,1,1284,4),(1302,1,1,1285,4),(1303,1,1,1286,4),(1304,1,1,1287,4),(1305,1,1,1288,4),(1306,1,1,1289,4),(1307,1,1,1290,4),(1308,1,1,1291,4),(1309,1,1,1292,4),(1310,1,1,1293,4),(1311,1,1,1294,4),(1312,1,1,1295,4),(1313,1,1,1296,4),(1314,1,1,1297,4),(1315,1,1,1298,4),(1316,1,1,1299,4),(1317,1,1,1300,4),(1318,1,1,1301,4),(1319,1,1,1302,4),(1320,1,1,1303,4),(1321,1,1,1304,4),(1322,1,1,1305,4),(1323,1,1,1306,4),(1324,1,1,1307,4),(1325,1,1,1308,4),(1326,1,1,1309,4),(1327,1,1,1310,4),(1328,1,1,1311,4),(1329,1,1,1312,4),(1330,1,1,1313,4),(1331,1,1,1314,4),(1332,1,1,1315,4),(1333,1,1,1316,4),(1334,1,1,1317,4),(1335,1,1,1318,4),(1336,1,1,1319,4),(1337,1,1,1320,4),(1338,1,1,1321,4),(1339,1,1,1322,4),(1340,1,1,1323,4),(1341,1,1,1324,4),(1342,1,1,1325,4),(1343,1,1,1326,4),(1344,1,1,1327,4),(1345,1,1,1328,4),(1346,1,1,1329,4),(1347,1,1,1330,4),(1348,1,1,1331,4),(1349,1,1,1332,4),(1350,1,1,1333,4),(1351,1,1,1334,4),(1352,1,1,1335,4),(1353,1,1,1336,4),(1354,1,1,1337,4),(1355,1,1,1338,4),(1356,1,1,1339,4),(1357,1,1,1340,4),(1358,1,1,1341,4),(1359,1,1,1342,4),(1360,1,1,1343,4),(1361,1,1,1344,4),(1362,1,1,1345,4),(1363,1,1,1346,4),(1364,1,1,1347,4),(1365,1,1,1348,4),(1366,1,1,1349,4),(1367,1,1,1350,4),(1368,1,1,1351,4),(1369,1,1,1352,4),(1370,1,1,1353,4),(1371,1,1,1354,4),(1372,1,1,1355,4),(1373,1,1,1356,4),(1374,1,1,1357,4),(1375,1,1,1358,4),(1376,1,1,1359,4),(1377,1,1,1360,4),(1378,1,1,1361,4),(1379,1,1,1362,4),(1380,1,1,1363,4),(1381,1,1,1364,4),(1382,1,1,1365,4),(1383,1,1,1366,4),(1384,1,1,1367,4),(1385,1,1,1368,4),(1386,1,1,1369,4),(1387,1,1,1370,4),(1388,1,1,1371,4),(1389,1,1,1372,4),(1390,1,1,1373,4),(1391,1,1,1374,4),(1392,1,1,1375,4),(1393,1,1,1376,4),(1394,1,1,1377,4),(1395,1,1,1378,4),(1396,1,1,1379,4),(1397,1,1,1380,4),(1398,1,1,1381,4),(1399,1,1,1382,4),(1400,1,1,1383,4),(1401,1,1,1384,4),(1402,1,1,1385,4),(1403,1,1,1386,4),(1404,1,1,1387,4),(1405,1,1,1388,4),(1406,1,1,1389,4),(1407,1,1,1390,4),(1408,1,1,1391,4),(1409,1,1,1392,4),(1410,1,1,1393,4),(1411,1,1,1394,4),(1412,1,1,1395,4),(1413,1,1,1396,4),(1414,1,1,1397,4),(1415,1,1,1398,4),(1416,1,1,1399,4),(1417,1,1,1400,4),(1418,1,1,1401,4),(1419,1,1,1402,4),(1420,1,1,1403,4),(1421,1,1,1404,4),(1422,1,1,1405,4),(1423,1,1,1406,4),(1424,1,1,1407,4),(1425,1,1,1408,4),(1426,1,1,1409,4),(1427,1,1,1410,4),(1428,1,1,1411,4),(1429,1,1,1412,4),(1430,1,1,1413,4),(1431,1,1,1414,4),(1432,1,1,1415,4),(1433,1,1,1416,4),(1434,1,1,1417,4),(1435,1,1,1418,4),(1436,1,1,1419,4),(1437,1,1,1420,4),(1438,1,1,1421,4),(1439,1,1,1422,4),(1440,1,1,1423,4),(1441,1,1,1424,4),(1442,1,1,1425,4),(1443,1,1,1426,4),(1444,1,1,1427,4),(1445,1,1,1428,4),(1446,1,1,1429,4),(1447,1,1,1430,4),(1448,1,1,1431,4),(1449,1,1,1432,4),(1450,1,1,1433,4),(1451,1,1,1434,4),(1452,1,1,1435,4),(1453,1,1,1436,4),(1454,1,1,1437,4),(1455,1,1,1438,4),(1456,1,1,1439,4),(1457,1,1,1440,4),(1458,1,1,1441,4),(1459,1,1,1442,4),(1460,1,1,1443,4),(1461,1,1,1444,4),(1462,1,1,1445,4),(1463,1,1,1446,4),(1464,1,1,1447,4),(1465,1,1,1448,4),(1466,1,1,1449,4),(1467,1,1,1450,4),(1468,1,1,1451,4),(1469,1,1,1452,4),(1470,1,1,1453,4),(1471,1,1,1454,4),(1472,1,1,1455,4),(1473,1,1,1456,4),(1474,1,1,1457,4),(1475,1,1,1458,4),(1476,1,1,1459,4),(1477,1,1,1460,4),(1478,1,1,1461,4),(1479,1,1,1462,4),(1480,1,1,1463,4),(1481,1,1,1464,4),(1482,1,1,1465,4),(1483,1,1,1466,4),(1484,1,1,1467,4),(1485,1,1,1468,4),(1486,1,1,1469,4),(1487,1,1,1470,4),(1488,1,1,1471,4),(1489,1,1,1472,4),(1490,1,1,1473,4),(1491,1,1,1474,4),(1492,1,1,1475,4),(1493,1,1,1476,4),(1494,1,1,1477,4),(1495,1,1,1478,4),(1496,1,1,1479,4),(1497,1,1,1480,4),(1498,1,1,1481,4),(1499,1,1,1482,4),(1500,1,1,1483,4),(1501,1,1,1484,4),(1502,1,1,1485,4),(1503,1,1,1486,4),(1504,1,1,1487,4),(1505,1,1,1488,4),(1506,1,1,1489,4),(1507,1,1,1490,4),(1508,1,1,1491,4),(1509,1,1,1492,4),(1510,1,1,1493,4),(1511,1,1,1494,4),(1512,1,1,1495,4),(1513,1,1,1496,4),(1514,1,1,1497,4),(1515,1,1,1498,4),(1516,1,1,1499,4),(1517,1,1,1500,4),(1518,1,1,1501,4),(1519,1,1,1502,4),(1520,1,1,1503,4),(1521,1,1,1504,4),(1522,1,1,1505,4),(1523,1,1,1506,4),(1524,1,1,1507,4),(1525,1,1,1508,4),(1526,1,1,1509,4),(1527,1,1,1510,4),(1528,1,1,1511,4),(1529,1,1,1512,4),(1530,1,1,1513,4),(1531,1,1,1514,4),(1532,1,1,1515,4),(1533,1,1,1516,4),(1534,1,1,1517,4),(1535,1,1,1518,4),(1536,1,1,1519,4),(1537,1,1,1520,4),(1538,1,1,1521,4),(1539,1,1,1522,4),(1540,1,1,1523,4),(1541,1,1,1524,4),(1542,1,1,1525,4),(1543,1,1,1526,4),(1544,1,1,1527,4),(1545,1,1,1528,4),(1546,1,1,1529,4),(1547,1,1,1530,4),(1548,1,1,1531,4),(1549,1,1,1532,4),(1550,1,1,1533,4),(1551,1,1,1534,4),(1552,1,1,1535,4),(1553,1,1,1536,4),(1554,1,1,1537,4),(1555,1,1,1538,4),(1556,1,1,1539,4),(1557,1,1,1540,4),(1558,1,1,1541,4),(1559,1,1,1542,4),(1560,1,1,1543,4),(1561,1,1,1544,4),(1562,1,1,1545,4),(1563,1,1,1546,4),(1564,1,1,1547,4),(1565,1,1,1548,4),(1566,1,1,1549,4),(1567,1,1,1550,4),(1568,1,1,1551,4),(1569,1,1,1552,4),(1570,1,1,1553,4),(1571,1,1,1554,4),(1572,1,1,1555,4),(1573,1,1,1556,4),(1574,1,1,1557,4),(1575,1,1,1558,4),(1576,1,1,1559,4),(1577,1,1,1560,4),(1578,1,1,1561,4),(1579,1,1,1562,4),(1580,1,1,1563,4),(1581,1,1,1564,4),(1582,1,1,1565,4),(1583,1,1,1566,4),(1584,1,1,1567,4),(1585,1,1,1568,4),(1586,1,1,1569,4),(1587,1,1,1570,4),(1588,1,1,1571,4),(1589,1,1,1572,4),(1590,1,1,1573,4),(1591,1,1,1574,4),(1592,1,1,1575,4),(1593,1,1,1576,4),(1594,1,1,1577,4),(1595,1,1,1578,4),(1596,1,1,1579,4),(1597,1,1,1580,4),(1598,1,1,1581,4),(1599,1,1,1582,4),(1600,1,1,1583,4),(1601,1,1,1584,4),(1602,1,1,1585,4),(1603,1,1,1586,4),(1604,1,1,1587,4),(1605,1,1,1588,4),(1606,1,1,1589,4),(1607,1,1,1590,4),(1608,1,1,1591,4),(1609,1,1,1592,4),(1610,1,1,1593,4),(1611,1,1,1594,4),(1612,1,1,1595,4),(1613,1,1,1596,4),(1614,1,1,1597,4),(1615,1,1,1598,4),(1616,1,1,1599,4),(1617,1,1,1600,4),(1618,1,1,1601,4),(1619,1,1,1602,4),(1620,1,1,1603,4),(1621,1,1,1604,4),(1622,1,1,1605,4),(1623,1,1,1606,4),(1624,1,1,1607,4),(1625,1,1,1608,4),(1626,1,1,1609,4),(1627,1,1,1610,4),(1628,1,1,1611,4),(1629,1,1,1612,4),(1630,1,1,1613,4),(1631,1,1,1614,4),(1632,1,1,1615,4),(1633,1,1,1616,4),(1634,1,1,1617,4),(1635,1,1,1618,4),(1636,1,1,1619,4),(1637,1,1,1620,4),(1638,1,1,1621,4),(1639,1,1,1622,4),(1640,1,1,1623,4),(1641,1,1,1624,4),(1642,1,1,1625,4),(1643,1,1,1626,4),(1644,1,1,1627,4),(1645,1,1,1628,4),(1646,1,1,1629,4),(1647,1,1,1630,4),(1648,1,1,1631,4),(1649,1,1,1632,4),(1650,1,1,1633,4),(1651,1,1,1634,4),(1652,1,1,1635,4),(1653,1,1,1636,4),(1654,1,1,1637,4),(1655,1,1,1638,4),(1656,1,1,1639,4),(1657,1,1,1640,4),(1658,1,1,1641,4),(1659,1,1,1642,4),(1660,1,1,1643,4),(1661,1,1,1644,4),(1662,1,1,1645,4),(1663,1,1,1646,4),(1664,1,1,1647,4),(1665,1,1,1648,4),(1666,1,1,1649,4),(1667,1,1,1650,4),(1668,1,1,1651,4),(1669,1,1,1652,4),(1670,1,1,1653,4),(1671,1,1,1654,4),(1672,1,1,1655,4),(1673,1,1,1656,4),(1674,1,1,1657,4),(1675,1,1,1658,4),(1676,1,1,1659,4),(1677,1,1,1660,4),(1678,1,1,1661,4),(1679,1,1,1662,4),(1680,1,1,1663,4),(1681,1,1,1664,4),(1682,1,1,1665,4),(1683,1,1,1666,4),(1684,1,1,1667,4),(1685,1,1,1668,4),(1686,1,1,1669,4),(1687,1,1,1670,4),(1688,1,1,1671,4),(1689,1,1,1672,4),(1690,1,1,1673,4),(1691,1,1,1674,4),(1692,1,1,1675,4),(1693,1,1,1676,4),(1694,1,1,1677,4),(1695,1,1,1678,4),(1696,1,1,1679,4),(1697,1,1,1680,4),(1698,1,1,1681,4),(1699,1,1,1682,4),(1700,1,1,1683,4),(1701,1,1,1684,4),(1702,1,1,1685,4),(1703,1,1,1686,4),(1704,1,1,1687,4),(1705,1,1,1688,4),(1706,1,1,1689,4),(1707,1,1,1690,4),(1708,1,1,1691,4),(1709,1,1,1692,4),(1710,1,1,1693,4),(1711,1,1,1694,4),(1712,1,1,1695,4),(1713,1,1,1696,4),(1714,1,1,1697,4),(1715,1,1,1698,4),(1716,1,1,1699,4),(1717,1,1,1700,4),(1718,1,1,1701,4),(1719,1,1,1702,4),(1720,1,1,1703,4),(1721,1,1,1704,4),(1722,1,1,1705,4),(1723,1,1,1706,4),(1724,1,1,1707,4),(1725,1,1,1708,4),(1726,1,1,1709,4),(1727,1,1,1710,4),(1728,1,1,1711,4),(1729,1,1,1712,4),(1730,1,1,1713,4),(1731,1,1,1714,4),(1732,1,1,1715,4),(1733,1,1,1716,4),(1734,1,1,1717,4),(1735,1,1,1718,4),(1736,1,1,1719,4),(1737,1,1,1720,4),(1738,1,1,1721,4),(1739,1,1,1722,4),(1740,1,1,1723,4),(1741,1,1,1724,4),(1742,1,1,1725,4),(1743,1,1,1726,4),(1744,1,1,1727,4),(1745,1,1,1728,4),(1746,1,1,1729,4),(1747,1,1,1730,4),(1748,1,1,1731,4),(1749,1,1,1732,4),(1750,1,1,1733,4),(1751,1,1,1734,4),(1752,1,1,1735,4),(1753,1,1,1736,4),(1754,1,1,1737,4),(1755,1,1,1738,4),(1756,1,1,1739,4),(1757,1,1,1740,4),(1758,1,1,1741,4),(1759,1,1,1742,4),(1760,1,1,1743,4),(1761,1,1,1744,4),(1762,1,1,1745,4),(1763,1,1,1746,4),(1764,1,1,1747,4),(1765,1,1,1748,4),(1766,1,1,1749,4),(1767,1,1,1750,4),(1768,1,1,1751,4),(1769,1,1,1752,4),(1770,1,1,1753,4),(1771,1,1,1754,4),(1772,1,1,1755,4),(1773,1,1,1756,4),(1774,1,1,1757,4),(1775,1,1,1758,4),(1776,1,1,1759,4),(1777,1,1,1760,4),(1778,1,1,1761,4),(1779,1,1,1762,4),(1780,1,1,1763,4),(1781,1,1,1764,4),(1782,1,1,1765,4),(1783,1,1,1766,4),(1784,1,1,1767,4),(1785,1,1,1768,4),(1786,1,1,1769,4),(1787,1,1,1770,4),(1788,1,1,1771,4),(1789,1,1,1772,4),(1790,1,1,1773,4),(1791,1,1,1774,4),(1792,1,1,1775,4),(1793,1,1,1776,4),(1794,1,1,1777,4),(1795,1,1,1778,4),(1796,1,1,1779,4),(1797,1,1,1780,4),(1798,1,1,1781,4),(1799,1,1,1782,4),(1800,1,1,1783,4),(1801,1,1,1784,4),(1802,1,1,1785,4),(1803,1,1,1786,4),(1804,1,1,1787,4),(1805,1,1,1788,4),(1806,1,1,1789,4),(1807,1,1,1790,4),(1808,1,1,1791,4),(1809,1,1,1792,4),(1810,1,1,1793,4),(1811,1,1,1794,4),(1812,1,1,1795,4),(1813,1,1,1796,4),(1814,1,1,1797,4),(1815,1,1,1798,4),(1816,1,1,1799,4),(1817,1,1,1800,4),(1818,1,1,1801,4),(1819,1,1,1802,4),(1820,1,1,1803,4),(1821,1,1,1804,4),(1822,1,1,1805,4),(1823,1,1,1806,4),(1824,1,1,1807,4),(1825,1,1,1808,4),(1826,1,1,1809,4),(1827,1,1,1810,4),(1828,1,1,1811,4),(1829,1,1,1812,4),(1830,1,1,1813,4),(1831,1,1,1814,4),(1832,1,1,1815,4),(1833,1,1,1816,4),(1834,1,1,1817,4),(1835,1,1,1818,4),(1836,1,1,1819,4),(1837,1,1,1820,4),(1838,1,1,1821,4),(1839,1,1,1822,4),(1840,1,1,1823,4),(1841,1,1,1824,4),(1842,1,1,1825,4),(1843,1,1,1826,4),(1844,1,1,1827,4),(1845,1,1,1828,4),(1846,1,1,1829,4),(1847,1,1,1830,4),(1848,1,1,1831,4),(1849,1,1,1832,4),(1850,1,1,1833,4),(1851,1,1,1834,4),(1852,1,1,1835,4),(1853,1,1,1836,4),(1854,1,1,1837,4),(1855,1,1,1838,4),(1856,1,1,1839,4),(1857,1,1,1840,4),(1858,1,1,1841,4),(1859,1,1,1842,4),(1860,1,1,1843,4),(1861,1,1,1844,4),(1862,1,1,1845,4),(1863,1,1,1846,4),(1864,1,1,1847,4),(1865,1,1,1848,4),(1866,1,1,1849,4),(1867,1,1,1850,4),(1868,1,1,1851,4),(1869,1,1,1852,4),(1870,1,1,1853,4),(1871,1,1,1854,4),(1872,1,1,1855,4),(1873,1,1,1856,4),(1874,1,1,1857,4),(1875,1,1,1858,4),(1876,1,1,1859,4),(1877,1,1,1860,4),(1878,1,1,1861,4),(1879,1,1,1862,4),(1880,1,1,1863,4),(1881,1,1,1864,4),(1882,1,1,1865,4),(1883,1,1,1866,4),(1884,1,1,1867,4),(1885,1,1,1868,4),(1886,1,1,1869,4),(1887,1,1,1870,4),(1888,1,1,1871,4),(1889,1,1,1872,4),(1890,1,1,1873,4),(1891,1,1,1874,4),(1892,1,1,1875,4),(1893,1,1,1876,4),(1894,1,1,1877,4),(1895,1,1,1878,4),(1896,1,1,1879,4),(1897,1,1,1880,4),(1898,1,1,1881,4),(1899,1,1,1882,4),(1900,1,1,1883,4),(1901,1,1,1884,4),(1902,1,1,1885,4),(1903,1,1,1886,4),(1904,1,1,1887,4),(1905,1,1,1888,4),(1906,1,1,1889,4),(1907,1,1,1890,4),(1908,1,1,1891,4),(1909,1,1,1892,4),(1910,1,1,1893,4),(1911,1,1,1894,4),(1912,1,1,1895,4),(1913,1,1,1896,4),(1914,1,1,1897,4),(1915,1,1,1898,4),(1916,1,1,1899,4),(1917,1,1,1900,4),(1918,1,1,1901,4),(1919,1,1,1902,4),(1920,1,1,1903,4),(1921,1,1,1904,4),(1922,1,1,1905,4),(1923,1,1,1906,4),(1924,1,1,1907,4),(1925,1,1,1908,4),(1926,1,1,1909,4),(1927,1,1,1910,4),(1928,1,1,1911,4),(1929,1,1,1912,4),(1930,1,1,1913,4),(1931,1,1,1914,4),(1932,1,1,1915,4),(1933,1,1,1916,4),(1934,1,1,1917,4),(1935,1,1,1918,4),(1936,1,1,1919,4),(1937,1,1,1920,4),(1938,1,1,1921,4),(1939,1,1,1922,4),(1940,1,1,1923,4),(1941,1,1,1924,4),(1942,1,1,1925,4),(1943,1,1,1926,4),(1944,1,1,1927,4),(1945,1,1,1928,4),(1946,1,1,1929,4),(1947,1,1,1930,4),(1948,1,1,1931,4),(1949,1,1,1932,4),(1950,1,1,1933,4),(1951,1,1,1934,4),(1952,1,1,1935,4),(1953,1,1,1936,4),(1954,1,1,1937,4),(1955,1,1,1938,4),(1956,1,1,1939,4),(1957,1,1,1940,4),(1958,1,1,1941,4),(1959,1,1,1942,4),(1960,1,1,1943,4),(1961,1,1,1944,4),(1962,1,1,1945,4),(1963,1,1,1946,4),(1964,1,1,1947,4),(1965,1,1,1948,4),(1966,1,1,1949,4),(1967,1,1,1950,4),(1968,1,1,1951,4),(1969,1,1,1952,4),(1970,1,1,1953,4),(1971,1,1,1954,4),(1972,1,1,1955,4),(1973,1,1,1956,4),(1974,1,1,1957,4),(1975,1,1,1958,4),(1976,1,1,1959,4),(1977,1,1,1960,4),(1978,1,1,1961,4),(1979,1,1,1962,4),(1980,1,1,1963,4),(1981,1,1,1964,4),(1982,1,1,1965,4),(1983,1,1,1966,4),(1984,1,1,1967,4),(1985,1,1,1968,4),(1986,1,1,1969,4),(1987,1,1,1970,4),(1988,1,1,1971,4),(1989,1,1,1972,4),(1990,1,1,1973,4),(1991,1,1,1974,4),(1992,1,1,1975,4),(1993,1,1,1976,4),(1994,1,1,1977,4),(1995,1,1,1978,4),(1996,1,1,1979,4),(1997,1,1,1980,4),(1998,1,1,1981,4),(1999,1,1,1982,4),(2000,1,1,1983,4),(2001,1,1,1984,4),(2002,1,1,1985,4),(2003,1,1,1986,4),(2004,1,1,1987,4),(2005,1,1,1988,4),(2006,1,1,1989,4),(2007,1,1,1990,4),(2008,1,1,1991,4),(2009,1,1,1992,4),(2010,1,1,1993,4),(2011,1,1,1994,4),(2012,1,1,1995,4),(2013,1,1,1996,4),(2014,1,1,1997,4),(2015,1,1,1998,4),(2016,1,1,1999,4),(2017,1,1,2000,4),(2018,1,1,2001,4),(2019,1,1,2002,4),(2020,1,1,2003,4),(2021,1,1,2004,4),(2022,1,1,2005,4),(2023,1,1,2006,4),(2024,1,1,2007,4),(2025,1,1,2008,4),(2026,1,1,2009,4),(2027,1,1,2010,4),(2028,1,1,2011,4),(2029,1,1,2012,4),(2030,1,1,2013,4),(2031,1,1,2014,4),(2032,1,1,2015,4),(2033,1,1,2016,4),(2034,1,1,2017,4),(2035,1,1,2018,4),(2036,1,1,2019,4),(2037,1,1,2020,4),(2038,1,1,2021,4),(2039,1,1,2022,4),(2040,1,1,2023,4),(2041,1,1,2024,4),(2042,1,1,2025,4),(2043,1,1,2026,4),(2044,1,1,2027,4),(2045,1,1,2028,4),(2046,1,1,2029,4),(2047,1,1,2030,4),(2048,1,1,2031,4),(2049,1,1,2032,4),(2050,1,1,2033,4),(2051,1,1,2034,4),(2052,1,1,2035,4),(2053,1,1,2036,4),(2054,1,1,2037,4),(2055,1,1,2038,4),(2056,1,1,2039,4),(2057,1,1,2040,4),(2058,1,1,2041,4),(2059,1,1,2042,4),(2060,1,1,2043,4),(2061,1,1,2044,4),(2062,1,1,2045,4),(2063,1,1,2046,4),(2064,1,1,2047,4),(2065,1,1,2048,4),(2066,1,1,2049,4),(2067,1,1,2050,4),(2068,1,1,2051,4),(2069,1,1,2052,4),(2070,1,1,2053,4),(2071,1,1,2054,4),(2072,1,1,2055,4),(2073,1,1,2056,4),(2074,1,1,2057,4),(2075,1,1,2058,4),(2076,1,1,2059,4),(2077,1,1,2060,4),(2078,1,1,2061,4),(2079,1,1,2062,4),(2080,1,1,2063,4),(2081,1,1,2064,4),(2082,1,1,2065,4),(2083,1,1,2066,4),(2084,1,1,2067,4),(2085,1,1,2068,4),(2086,1,1,2069,4),(2087,1,1,2070,4),(2088,1,1,2071,4),(2089,1,1,2072,4),(2090,1,1,2073,4),(2091,1,1,2074,4),(2092,1,1,2075,4),(2093,1,1,2076,4),(2094,1,1,2077,4),(2095,1,1,2078,4),(2096,1,1,2079,4),(2097,1,1,2080,4),(2098,1,1,2081,4),(2099,1,1,2082,4),(2100,1,1,2083,4),(2101,1,1,2084,4),(2102,1,1,2085,4),(2103,1,1,2086,4),(2104,1,1,2087,4),(2105,1,1,2088,4),(2106,1,1,2089,4),(2107,1,1,2090,4),(2108,1,1,2091,4),(2109,1,1,2092,4),(2110,1,1,2093,4),(2111,1,1,2094,4),(2112,1,1,2095,4),(2113,1,1,2096,4),(2114,1,1,2097,4),(2115,1,1,2098,4),(2116,1,1,2099,4),(2117,1,1,2100,4),(2118,1,1,2101,4),(2119,1,1,2102,4),(2120,1,1,2103,4),(2121,1,1,2104,4),(2122,1,1,2105,4),(2123,1,1,2106,4),(2124,1,1,2107,4),(2125,1,1,2108,4),(2126,1,1,2109,4),(2127,1,1,2110,4),(2128,1,1,2111,4),(2129,1,1,2112,4),(2130,1,1,2113,4),(2131,1,1,2114,4),(2132,1,1,2115,4),(2133,1,1,2116,4),(2134,1,1,2117,4),(2135,1,1,2118,4),(2136,1,1,2119,4),(2137,1,1,2120,4),(2138,1,1,2121,4),(2139,1,1,2122,4),(2140,1,1,2123,4),(2141,1,1,2124,4),(2142,1,1,2125,4),(2143,1,1,2126,4),(2144,1,1,2127,4),(2145,1,1,2128,4),(2146,1,1,2129,4),(2147,1,1,2130,4),(2148,1,1,2131,4),(2149,1,1,2132,4),(2150,1,1,2133,4),(2151,1,1,2134,4),(2152,1,1,2135,4),(2153,1,1,2136,4),(2154,1,1,2137,4),(2155,1,1,2138,4),(2156,1,1,2139,4),(2157,1,1,2140,4),(2158,1,1,2141,4),(2159,1,1,2142,4),(2160,1,1,2143,4),(2161,1,1,2144,4),(2162,1,1,2145,4),(2163,1,1,2146,4),(2164,1,1,2147,4),(2165,1,1,2148,4),(2166,1,1,2149,4),(2167,1,1,2150,4),(2168,1,1,2151,4),(2169,1,1,2152,4);

--
-- Table structure for table `tbg_userstate`
--

CREATE TABLE `tbg_userstate` (
  `name` varchar(200) DEFAULT NULL,
  `is_online` tinyint(1) DEFAULT NULL,
  `is_unavailable` tinyint(1) DEFAULT NULL,
  `is_busy` tinyint(1) DEFAULT NULL,
  `is_in_meeting` tinyint(1) DEFAULT NULL,
  `is_absent` tinyint(1) DEFAULT NULL,
  `scope` int(10) DEFAULT '0',
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tbg_userstate`
--

INSERT INTO `tbg_userstate` VALUES ('Available',1,0,0,0,0,1,1),('Offline',0,1,0,0,0,1,2),('Busy',1,1,0,0,0,1,3),('Unavailable',1,1,0,0,0,1,4),('In a meeting',0,1,0,1,0,1,5),('Coding',1,1,1,0,0,1,6),('Away',1,1,1,0,1,1,7),('On vacation',0,1,1,0,1,1,8),('Available',1,0,0,0,0,2,9),('Offline',0,1,0,0,0,2,10),('Busy',1,1,0,0,0,2,11),('Unavailable',1,1,0,0,0,2,12),('In a meeting',0,1,0,1,0,2,13),('Coding',1,1,1,0,0,2,14),('Away',1,1,1,0,1,2,15),('On vacation',0,1,1,0,1,2,16),('Available',1,0,0,0,0,3,17),('Offline',0,1,0,0,0,3,18),('Busy',1,1,0,0,0,3,19),('Unavailable',1,1,0,0,0,3,20),('In a meeting',0,1,0,1,0,3,21),('Coding',1,1,1,0,0,3,22),('Away',1,1,1,0,1,3,23),('On vacation',0,1,1,0,1,3,24);

--
-- Table structure for table `tbg_vcsintegration_commits`
--

CREATE TABLE `tbg_vcsintegration_commits` (
  `log` text,
  `old_rev` varchar(40) DEFAULT NULL,
  `new_rev` varchar(40) DEFAULT NULL,
  `author` int(10) DEFAULT '0',
  `date` int(10) DEFAULT '0',
  `data` text,
  `project_id` int(10) DEFAULT '0',
  `scope` int(10) DEFAULT '0',
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`),
  KEY `tbg_vcsintegration_commits_project` (`project_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tbg_vcsintegration_commits`
--


--
-- Table structure for table `tbg_vcsintegration_files`
--

CREATE TABLE `tbg_vcsintegration_files` (
  `file_name` text,
  `action` varchar(1) DEFAULT NULL,
  `commit_id` int(10) DEFAULT '0',
  `scope` int(10) DEFAULT '0',
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`),
  KEY `tbg_vcsintegration_files_commit` (`commit_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tbg_vcsintegration_files`
--


--
-- Table structure for table `tbg_vcsintegration_issuelinks`
--

CREATE TABLE `tbg_vcsintegration_issuelinks` (
  `issue_no` int(10) DEFAULT '0',
  `commit_id` int(10) DEFAULT '0',
  `scope` int(10) DEFAULT '0',
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`),
  KEY `tbg_vcsintegration_issuelinks_commit` (`commit_id`),
  KEY `tbg_vcsintegration_issuelinks_issue` (`issue_no`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tbg_vcsintegration_issuelinks`
--


--
-- Table structure for table `tbg_visible_issue_types`
--

CREATE TABLE `tbg_visible_issue_types` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `scope` int(10) unsigned DEFAULT '0',
  `issuetype_id` int(10) unsigned DEFAULT '0',
  `project_id` int(10) unsigned DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tbg_visible_issue_types`
--


--
-- Table structure for table `tbg_visible_milestones`
--

CREATE TABLE `tbg_visible_milestones` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `scope` int(10) unsigned DEFAULT '0',
  `milestone_id` int(10) unsigned DEFAULT '0',
  `project_id` int(10) unsigned DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tbg_visible_milestones`
--


--
-- Table structure for table `tbg_votes`
--

CREATE TABLE `tbg_votes` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `scope` int(10) unsigned DEFAULT '0',
  `target` int(10) DEFAULT '0',
  `vote` int(2) DEFAULT '0',
  `uid` int(10) unsigned DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tbg_votes`
--


--
-- Table structure for table `tbg_workflow_issuetype`
--

CREATE TABLE `tbg_workflow_issuetype` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `scope` int(10) unsigned DEFAULT '0',
  `workflow_id` int(10) unsigned DEFAULT '0',
  `workflow_scheme_id` int(10) unsigned DEFAULT '0',
  `issutype_id` int(10) unsigned DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tbg_workflow_issuetype`
--

INSERT INTO `tbg_workflow_issuetype` VALUES (1,2,2,1,1),(2,2,2,1,2),(3,2,2,1,3),(4,2,2,1,4),(5,2,2,1,5),(6,2,2,1,6),(7,2,2,1,7),(8,3,3,2,8),(9,3,3,2,9),(10,3,3,2,10),(11,3,3,2,11),(12,3,3,2,12),(13,3,3,2,13),(14,3,3,2,14),(20,3,9,7,20),(21,2,11,9,21),(22,1,12,10,22),(25,1,13,10,23);

--
-- Table structure for table `tbg_workflow_schemes`
--

CREATE TABLE `tbg_workflow_schemes` (
  `name` varchar(200) DEFAULT NULL,
  `description` varchar(200) DEFAULT NULL,
  `scope` int(10) DEFAULT '0',
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tbg_workflow_schemes`
--

INSERT INTO `tbg_workflow_schemes` VALUES ('Default workflow scheme','This is the default workflow scheme. It is used by all projects with no specific workflow scheme selected. This scheme cannot be edited or removed.',1,1),('Default workflow scheme','This is the default workflow scheme. It is used by all projects with no specific workflow scheme selected. This scheme cannot be edited or removed.',2,5),('Default workflow scheme','This is the default workflow scheme. It is used by all projects with no specific workflow scheme selected. This scheme cannot be edited or removed.',3,6),('Biotecnologia WS','',3,7),('Forestal WS','',2,9),('WFE - Trazabilidad Miel','',1,10);

--
-- Table structure for table `tbg_workflow_step_transitions`
--

CREATE TABLE `tbg_workflow_step_transitions` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `scope` int(10) unsigned DEFAULT '0',
  `workflow_id` int(10) unsigned DEFAULT '0',
  `from_step_id` int(10) unsigned DEFAULT '0',
  `transition_id` int(10) unsigned DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=255 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tbg_workflow_step_transitions`
--

INSERT INTO `tbg_workflow_step_transitions` VALUES (1,2,2,1,1),(2,2,2,1,3),(3,2,2,1,4),(4,2,2,1,5),(5,2,2,1,9),(6,2,2,2,2),(7,2,2,2,3),(8,2,2,2,4),(9,2,2,2,5),(10,2,2,3,5),(11,2,2,3,7),(12,2,2,3,9),(13,2,2,4,4),(14,2,2,4,8),(15,2,2,4,9),(16,2,2,5,9),(17,2,2,5,10),(18,2,2,6,11),(19,2,2,6,12),(20,2,2,7,6),(21,2,2,8,6),(22,3,3,9,14),(23,3,3,9,16),(24,3,3,9,17),(25,3,3,9,18),(26,3,3,9,22),(27,3,3,10,15),(28,3,3,10,16),(29,3,3,10,17),(30,3,3,10,18),(31,3,3,11,18),(32,3,3,11,20),(33,3,3,11,22),(34,3,3,12,17),(35,3,3,12,21),(36,3,3,12,22),(37,3,3,13,22),(38,3,3,13,23),(39,3,3,14,24),(40,3,3,14,25),(41,3,3,15,19),(42,3,3,16,19),(44,1,4,18,29),(45,1,4,17,30),(46,1,4,19,31),(47,1,4,20,32),(48,1,4,21,33),(50,1,4,23,35),(51,1,4,24,36),(52,1,4,25,37),(53,1,5,27,39),(57,1,5,31,43),(58,1,5,32,44),(59,1,5,33,45),(60,1,5,39,46),(61,1,5,34,47),(62,1,5,35,48),(63,1,5,37,49),(66,1,5,30,52),(69,1,5,28,55),(81,1,5,31,67),(88,1,4,22,74),(91,1,5,32,77),(98,1,5,29,84),(105,1,8,47,94),(108,1,8,51,97),(109,1,4,21,98),(110,1,8,48,99),(111,1,8,55,100),(112,1,8,56,101),(116,1,8,51,106),(117,1,8,48,107),(118,1,8,49,108),(119,1,8,63,109),(120,1,8,57,110),(121,1,8,64,111),(122,1,8,56,112),(123,1,8,65,113),(124,1,8,66,114),(125,1,8,67,115),(126,1,8,68,116),(127,1,8,66,117),(128,1,8,69,118),(129,1,8,60,119),(130,1,8,70,120),(131,1,8,71,121),(132,1,8,60,122),(133,1,8,72,123),(134,1,8,58,124),(135,1,8,59,125),(136,1,8,56,126),(137,1,8,60,127),(138,1,8,60,128),(139,1,8,62,129),(140,3,9,61,130),(141,3,9,76,131),(142,3,9,78,132),(143,3,9,79,133),(144,3,9,81,134),(145,3,9,81,135),(146,3,9,80,136),(147,3,9,82,137),(148,3,9,83,138),(149,3,9,84,139),(150,3,9,85,140),(152,3,9,86,142),(154,3,9,89,144),(155,3,9,87,145),(156,3,9,91,146),(157,3,9,92,147),(158,3,9,90,148),(159,3,9,88,149),(160,3,9,94,150),(161,3,9,92,151),(162,3,9,93,152),(163,3,9,95,153),(164,3,9,96,154),(165,3,9,97,155),(166,3,9,98,156),(167,3,9,98,157),(168,3,9,99,158),(169,3,9,100,159),(170,3,9,101,160),(171,3,9,102,161),(172,3,9,103,162),(173,3,9,104,163),(174,3,9,105,164),(175,3,9,101,165),(176,3,9,106,166),(177,2,11,110,169),(178,2,11,111,170),(180,2,11,112,172),(181,2,11,111,173),(182,2,11,113,174),(183,2,11,114,175),(184,2,11,115,176),(185,2,11,113,177),(186,2,11,116,178),(187,2,11,123,179),(188,2,11,119,180),(189,2,11,121,181),(190,2,11,120,182),(191,2,11,124,183),(192,2,11,122,184),(194,2,11,121,186),(195,2,11,119,187),(196,2,11,119,188),(197,2,11,123,189),(198,2,11,117,190),(199,2,11,125,191),(200,2,11,127,192),(201,2,11,128,193),(202,2,11,129,194),(203,2,11,126,195),(204,2,11,118,196),(205,2,11,125,197),(206,2,11,128,198),(207,2,11,133,199),(208,2,11,131,200),(209,2,11,132,201),(210,2,11,133,202),(211,2,11,130,203),(212,2,11,134,204),(213,2,11,133,205),(214,2,11,133,206),(215,2,11,136,207),(216,2,11,137,208),(217,2,11,135,209),(218,2,11,137,210),(219,2,11,138,211),(221,2,11,138,213),(222,2,11,138,214),(223,2,11,140,215),(224,2,11,141,216),(235,1,13,153,228),(244,1,14,162,238),(245,1,14,163,239),(246,1,14,163,240),(247,1,14,165,241),(250,1,12,144,245),(251,1,12,167,246),(252,1,15,168,247),(253,1,15,169,248),(254,1,15,169,249);

--
-- Table structure for table `tbg_workflow_steps`
--

CREATE TABLE `tbg_workflow_steps` (
  `name` varchar(200) DEFAULT NULL,
  `description` varchar(200) DEFAULT NULL,
  `editable` tinyint(1) DEFAULT NULL,
  `closed` tinyint(1) DEFAULT NULL,
  `status_id` int(10) DEFAULT '0',
  `workflow_id` int(10) DEFAULT '0',
  `scope` int(10) DEFAULT '0',
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=172 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tbg_workflow_steps`
--

INSERT INTO `tbg_workflow_steps` VALUES ('New','A new issue, not yet handled',1,0,87,2,2,1),('Investigating','An issue that is being investigated, looked into or is by other means between new and unconfirmed state',1,0,88,2,2,2),('Confirmed','An issue that has been confirmed',0,0,89,2,2,3),('In progress','An issue that is being adressed',0,0,91,2,2,4),('Ready for testing','An issue that has been marked fixed and is ready for testing',0,0,93,2,2,5),('Testing','An issue where the proposed or implemented solution is currently being tested or approved',0,0,94,2,2,6),('Rejected','A closed issue that has been rejected',0,1,90,2,2,7),('Closed','A closed issue',0,1,0,2,2,8),('New','A new issue, not yet handled',1,0,130,3,3,9),('Investigating','An issue that is being investigated, looked into or is by other means between new and unconfirmed state',1,0,131,3,3,10),('Confirmed','An issue that has been confirmed',0,0,132,3,3,11),('In progress','An issue that is being adressed',0,0,134,3,3,12),('Ready for testing','An issue that has been marked fixed and is ready for testing',0,0,136,3,3,13),('Testing','An issue where the proposed or implemented solution is currently being tested or approved',0,0,137,3,3,14),('Rejected','A closed issue that has been rejected',0,1,133,3,3,15),('Closed','A closed issue',0,1,0,3,3,16),('Verificando Datos','',0,0,0,4,1,17),('Verificando Responsables','',1,0,0,4,1,18),('Completando Anexo III','',1,0,0,4,1,19),('Enviando a Provincia','',1,0,0,4,1,20),('Completando ANEXO III ','',1,0,0,4,1,21),('Cumpliendo con OTBN','',1,0,0,4,1,22),('Revisar area Legal/Ambiental/ Técnico','',1,0,0,4,1,23),('Enviando a Nación','',1,0,0,4,1,24),('Evaluando','',1,0,0,4,1,25),('Tomando Decisión','',1,1,0,4,1,26),('Verificando datos','',0,0,0,5,1,27),('Asignando Expediente','',1,0,0,5,1,28),('Solicitando Información','',1,0,0,5,1,29),('Generando Nota','',1,0,0,5,1,30),('Complentando Información','',1,0,0,5,1,31),('Validando Proyecto de Resolución','',1,0,0,5,1,32),('Aprobar','',1,0,0,5,1,33),('Completando Informe Siembra','',1,0,0,5,1,34),('Generar Informes Parciales','',1,0,0,5,1,35),('Enviando Evaluación de Cierre','',1,0,0,5,1,37),('Generando Cierre','',1,1,0,5,1,38),('Generando Nota','',1,0,0,5,1,39),('Nueva','',0,0,0,6,1,45),('Nueva','',0,0,0,7,1,46),('Ingresando proceso','',0,0,153,8,1,47),('Realizando Evauación Preliminar','',1,0,162,8,1,48),('Haciendo Correcciones','',1,0,163,8,1,49),('Analizando Solicitud','',1,0,154,8,1,51),('LEGALES','',1,0,0,8,1,55),('Analizando ANEXO III','',1,0,0,8,1,56),('Generando Feedback','',1,0,0,8,1,57),('Recibiendo Correcciones','',1,0,0,8,1,58),('Analizando Respuestas','',1,0,0,8,1,59),('Analizando Plan','',1,0,162,8,1,60),('Asignando Expediente','',0,0,164,9,3,61),('Re ingresando información','',1,0,176,8,1,62),('Recibiendo Correcciones','',1,0,0,8,1,63),('Recibiendo Respuestas','',1,0,0,8,1,64),('Generando Certificado de Obra','',1,0,155,8,1,65),('Analizando Certificado de Obra','',1,0,154,8,1,66),('Haciendo Correcciones','',1,0,0,8,1,67),('Recibiendo Correcciones','',1,0,0,8,1,68),('Realizando Inspección','',1,0,0,8,1,69),('LEGALES','',1,0,0,8,1,70),('Recibiendo Preguntas','',1,0,0,8,1,71),('Haciendo Correcciones','',1,0,0,8,1,72),('CONTABLE','',1,0,0,8,1,73),('Reinspeccionando','',1,0,158,8,1,74),('Registrando Pagos','',1,0,159,8,1,75),('Generando Nota con preguntas','',0,0,165,9,3,76),('Solicitando información complementaria','',1,0,165,9,3,78),('Completando información','',1,0,165,9,3,79),('Recibiendo información complementaria','',1,0,165,9,3,80),('Evaluando preguntas de solicitante','',1,0,165,9,3,81),('Generando proyecto de resolución','',1,0,167,9,3,82),('Validando proyecto de resolución','',1,0,166,9,3,83),('Aprobando proyecto de resolución','',1,0,0,9,3,84),('Completando informe de siembra','',1,0,173,9,3,85),('Evaluando informe de siembra','',1,0,165,9,3,86),('Completando información','',1,0,165,9,3,87),('Evaluando informe de siembra','',1,0,165,9,3,88),('Generando informes parciales ','',1,0,0,9,3,89),('Evaluando informes parciales','',1,0,0,9,3,90),('Recibiendo iformación complementaria','',1,0,165,9,3,91),('Recibiendo respuestas de informe de siembra','',1,0,165,9,3,92),('Evaluando informe parcial','',1,0,0,9,3,93),('Solicitando datos de informe de siembra','',1,0,165,9,3,94),('Solicitando datos de informes parciales','',1,0,0,9,3,95),('Completando información','',1,0,0,9,3,96),('Recibiendo información complementaria','',1,0,0,9,3,97),('Recibiendo respuesta de informes parciales','',1,0,0,9,3,98),('Generando informe de cierre','',1,0,0,9,3,99),('Evaluando informe de cierre','',1,0,0,9,3,100),('Evaluando informe de cierre','',1,0,0,9,3,101),('Solicitando datos informe de cierre','',1,0,0,9,3,102),('Completando información','',1,0,0,9,3,103),('Recibiendo información complementaria','',1,0,0,9,3,104),('Analizando respuestas de informe de cierre','',1,0,0,9,3,105),('Enviando a evaluar cierre','',1,0,0,9,3,106),('Generando Cierre','',1,0,0,9,3,107),('Nueva','',0,0,0,10,2,109),('Ingresando Proceso','',0,0,0,11,2,110),('Analizando Solicitud','',1,0,0,11,2,111),('Re Ingresando Información','',1,0,0,11,2,112),('Realizando Evaluación Preliminar','',1,0,0,11,2,113),('Haciendo Correcciones','',1,0,0,11,2,114),('Recibiendo Correcciones','',1,0,0,11,2,115),('Generando Feedback','',1,0,0,11,2,116),('Generando Certificado de Obra','',1,0,0,11,2,117),('Haciendo Correcciones','',1,0,0,11,2,118),('Analizando ANEXO iii','',1,0,0,11,2,119),('Recibiendo Respuestas','',1,0,0,11,2,120),('Analizando LEgal','',1,0,0,11,2,121),('Recibiendo Observaciones Legales','',1,0,0,11,2,122),('Realizando Adelanto','',1,0,0,11,2,123),('Recibiendo Observación Liquidación','',1,0,0,11,2,124),('Analizando Certificado de Obra','',1,0,0,11,2,125),('Recibiendo Correcciones','',1,0,0,11,2,126),('Realizando Inspección','',1,0,0,11,2,127),('Analizando Legal','',1,0,0,11,2,128),('Analizando Observaciones','',1,0,0,11,2,129),('Haciendo Correcciones','',1,0,0,11,2,130),('Recibiendo Preguntas','',1,0,0,11,2,131),('Analizando Respuestas','',1,0,0,11,2,132),('Analizando Plan','',1,0,0,11,2,133),('Recibiendo Correcciones','',1,0,0,11,2,134),('Reinspeccionando','',1,0,0,11,2,135),('Análisis Técnico','',1,0,0,11,2,136),('Análisis Técnico','',1,0,0,11,2,137),('Liquidaciones','',1,0,0,11,2,138),('Evaluando Pagos','',1,0,0,11,2,139),('Analizando Técnicos','',1,0,0,11,2,140),('Analizando Legales','',1,0,0,11,2,141),('Solicitando Etiquetas','',1,0,182,12,1,144),('Generar Baja Etiquetas','',1,0,186,13,1,153),('Baja Realizada','',0,1,189,13,1,154),('Solicitud Finalizada','',0,1,189,12,1,160),('Nuevo','',0,0,0,8,1,161),('Solicitando Etiquetas','',1,0,178,14,1,162),('Analizando Solicitud','',1,0,178,14,1,163),('Rechazando Solicitud','',1,1,179,14,1,164),('Imprimiendo por Gráfica','',1,0,182,14,1,165),('Solicitud Finalizada','',1,1,189,14,1,166),('Esperando Etiquetas','',1,0,182,12,1,167),('Solicitando Baja Etiquetas','',1,0,185,15,1,168),('Analizando Solicitud','',1,0,185,15,1,169),('Rechazando Solicitud','',1,1,188,15,1,170),('Aprobando Solicitud','',1,1,186,15,1,171);

--
-- Table structure for table `tbg_workflow_transition_actions`
--

CREATE TABLE `tbg_workflow_transition_actions` (
  `action_type` varchar(200) DEFAULT NULL,
  `target_value` varchar(200) DEFAULT NULL,
  `transition_id` int(10) DEFAULT '0',
  `workflow_id` int(10) DEFAULT '0',
  `scope` int(10) DEFAULT '0',
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `requerido` tinyint(1) NOT NULL DEFAULT '0',
  `orden` int(3) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=380 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tbg_workflow_transition_actions`
--

INSERT INTO `tbg_workflow_transition_actions` VALUES ('assign_self','0',1,2,2,1,0,0),('clear_assignee','0',2,2,2,2,0,0),('set_percent','10',3,2,2,3,0,0),('0','set_priority',3,2,2,4,0,0),('set_resolution','0',4,2,2,5,0,0),('set_duplicate','0',4,2,2,6,0,0),('set_percent','100',4,2,2,7,0,0),('user_stop_working','0',4,2,2,8,0,0),('assign_self','0',5,2,2,9,0,0),('user_start_working','0',5,2,2,10,0,0),('clear_resolution','0',6,2,2,11,0,0),('clear_duplicate','0',6,2,2,12,0,0),('clear_percent','0',6,2,2,13,0,0),('assign_user','0',7,2,2,14,0,0),('user_start_working','0',7,2,2,15,0,0),('clear_assignee','0',8,2,2,16,0,0),('user_stop_working','0',8,2,2,17,0,0),('set_status','0',9,2,2,18,0,0),('set_percent','100',9,2,2,19,0,0),('set_resolution','0',9,2,2,20,0,0),('user_stop_working','0',9,2,2,21,0,0),('assign_self','0',10,2,2,22,0,0),('user_start_working','0',10,2,2,23,0,0),('set_resolution','0',11,2,2,24,0,0),('clear_assignee','0',11,2,2,25,0,0),('user_stop_working','0',11,2,2,26,0,0),('set_resolution','0',12,2,2,27,0,0),('clear_assignee','0',12,2,2,28,0,0),('user_stop_working','0',12,2,2,29,0,0),('assign_self','0',14,3,3,30,0,0),('clear_assignee','0',15,3,3,31,0,0),('set_percent','10',16,3,3,32,0,0),('0','set_priority',16,3,3,33,0,0),('set_resolution','0',17,3,3,34,0,0),('set_duplicate','0',17,3,3,35,0,0),('set_percent','100',17,3,3,36,0,0),('user_stop_working','0',17,3,3,37,0,0),('assign_self','0',18,3,3,38,0,0),('user_start_working','0',18,3,3,39,0,0),('clear_resolution','0',19,3,3,40,0,0),('clear_duplicate','0',19,3,3,41,0,0),('clear_percent','0',19,3,3,42,0,0),('assign_user','0',20,3,3,43,0,0),('user_start_working','0',20,3,3,44,0,0),('clear_assignee','0',21,3,3,45,0,0),('user_stop_working','0',21,3,3,46,0,0),('set_status','0',22,3,3,47,0,0),('set_percent','100',22,3,3,48,0,0),('set_resolution','0',22,3,3,49,0,0),('user_stop_working','0',22,3,3,50,0,0),('assign_self','0',23,3,3,51,0,0),('user_start_working','0',23,3,3,52,0,0),('set_resolution','0',24,3,3,53,0,0),('clear_assignee','0',24,3,3,54,0,0),('user_stop_working','0',24,3,3,55,0,0),('set_resolution','0',25,3,3,56,0,0),('clear_assignee','0',25,3,3,57,0,0),('user_stop_working','0',25,3,3,58,0,0),('customfield_set_documentacionadjunta','',32,4,1,89,0,3),('customfield_set_otbn','',33,4,1,93,0,0),('customfield_set_documentacionadjunta','',35,4,1,98,0,6),('customfield_set_documentacionadjunta','',36,4,1,105,0,1),('customfield_set_expediente','',39,5,1,116,0,0),('customfield_set_documentacionadjunta','',40,5,1,131,0,2),('customfield_set_preguntasyoconsultas','',50,5,1,133,0,0),('customfield_set_documentacionadjunta','',50,5,1,134,0,0),('assign_applicant','',50,5,1,135,0,0),('assign_applicant','',52,5,1,138,0,1),('assign_applicant','',41,5,1,139,0,1),('customfield_set_observaciones','',41,5,1,141,0,0),('customfield_set_respuestasalasconsultas','',53,5,1,142,0,0),('customfield_set_documentacionadjunta','',53,5,1,143,0,0),('assign_applicant','',53,5,1,144,0,0),('assign_applicant','',43,5,1,145,0,1),('customfield_set_confirmarproyectoderesolucion','',44,5,1,146,0,0),('assign_applicant','',44,5,1,147,0,0),('customfield_set_observaciones','',45,5,1,149,0,1),('customfield_set_documentacionadjunta','',45,5,1,150,0,2),('assign_applicant','',45,5,1,151,0,3),('customfield_set_observaciones','',47,5,1,152,0,0),('assign_applicant','',47,5,1,153,0,2),('customfield_set_respuestasalasconsultas','',46,5,1,154,0,2),('customfield_set_documentacionadjunta','',46,5,1,155,0,3),('assign_applicant','',46,5,1,156,0,4),('customfield_set_preguntasyoconsultas','',47,5,1,157,0,1),('customfield_set_completarinformesiembra','',45,5,1,158,0,0),('customfield_set_observaciones','',48,5,1,160,0,0),('assign_applicant','',48,5,1,161,0,0),('customfield_set_informedecierre','',49,5,1,162,0,0),('assign_applicant','',49,5,1,163,0,0),('customfield_set_generarinformesparciales','',46,5,1,164,0,1),('customfield_set_confirmarproyectoderesolucion','',43,5,1,165,0,0),('customfield_set_observaciones','',40,5,1,166,0,1),('assign_applicant','',55,5,1,168,0,2),('customfield_set_respuestasalasconsultas','',62,5,1,169,0,0),('assign_applicant','',62,5,1,170,0,0),('assign_applicant','',67,5,1,171,0,0),('customfield_set_observaciones','',68,5,1,172,0,0),('assign_applicant','',68,5,1,173,0,0),('customfield_set_preguntasyoconsultas','',52,5,1,175,0,0),('customfield_set_documentacionadjunta','',30,4,1,177,0,5),('assign_applicant','',30,4,1,178,0,7),('customfield_set_estadoproceso','',30,4,1,180,0,6),('assign_applicant','',31,4,1,184,0,10),('customfield_set_actividad','',31,4,1,186,0,0),('customfield_set_etapa','',31,4,1,187,0,1),('customfield_set_densidadinicialplha','',31,4,1,190,0,5),('customfield_set_departamentoopartido','',31,4,1,191,0,7),('customfield_set_turnodecorta','',31,4,1,192,0,6),('customfield_set_observaciones','',33,4,1,195,0,0),('customfield_set_estadoproceso','',33,4,1,196,0,0),('customfield_set_estadoproceso','',31,4,1,197,0,9),('customfield_set_plantacion','',32,4,1,198,0,2),('customfield_set_actividadescertificadas','',32,4,1,200,0,0),('customfield_set_estadoproceso','',32,4,1,201,0,4),('customfield_set_estadoproceso','',32,4,1,202,0,1),('customfield_set_observaciones','',35,4,1,203,0,5),('customfield_set_estadoproceso','',35,4,1,205,0,8),('customfield_set_analisistecnico','',35,4,1,206,0,4),('assign_applicant','',35,4,1,207,0,0),('customfield_set_estadoproceso','',36,4,1,208,0,2),('assign_applicant','',36,4,1,209,0,3),('customfield_set_estadoproceso','',37,4,1,210,0,1),('customfield_set_decision','',37,4,1,211,0,0),('customfield_set_documentacionadjunta','',37,4,1,212,0,2),('customfield_set_estadoproceso','',34,4,1,213,0,0),('customfield_set_observaciones','',34,4,1,214,0,0),('customfield_set_beneficiosfiscales','',31,4,1,216,0,8),('customfield_set_materialdeplantacion','',32,4,1,217,0,1),('customfield_set_generoyespecie','',31,4,1,218,0,4),('customfield_set_superficieha','',31,4,1,220,0,2),('customfield_set_numeroidentificadorinternodelemprendimiento','',30,4,1,222,0,0),('customfield_set_profesionalcuitn','',30,4,1,223,0,2),('customfield_set_profesionalregistron','',30,4,1,224,0,3),('customfield_set_profesionalapellidosynombres','',30,4,1,225,0,4),('customfield_set_plandemanejodelfuego','',35,4,1,230,0,0),('customfield_set_puntosgps','',35,4,1,231,0,0),('customfield_set_preguntasyoconsultas','',84,5,1,233,0,0),('assign_applicant','',84,5,1,234,0,0),('customfield_set_leyn25080evaluacionpreliminarporautoridadprovincial','',89,8,1,252,0,0),('customfield_set_titular','',89,8,1,253,0,1),('customfield_set_impactoambiental','',89,8,1,254,0,2),('customfield_set_enfunciondelanalisisefectuadoalpresenteproyectoyteniendoencuentaelestudiodeimpactoambientalrealizado','',89,8,1,255,0,3),('customfield_set_fecha','',89,8,1,256,0,9),('customfield_set_profesionalinterviniente','',89,8,1,257,0,10),('customfield_set_ordenamientoterritorialdebosquesnativos','',89,8,1,258,0,4),('customfield_set_acompletarporlaautoridaddeaplicacionprovincialdelaleyn2633108seguncorresponda','',89,8,1,259,0,5),('customfield_set_pcusplandecambiodeusodelsueloopermisodesimilarescaracteristicasotorgadoporlaautoridadprovincialcompe','',89,8,1,260,0,6),('customfield_set_proyectoviable','',89,8,1,261,0,7),('customfield_set_observaciones','',89,8,1,262,0,8),('customfield_set_serecomiendadarcursofavorabledesfavorablealpresenteproyectoatentolasevaluacionesefectuadas','',89,8,1,263,0,11),('customfield_set_autoridadprovincialresponsable','',89,8,1,264,0,12),('assign_applicant','',89,8,1,265,0,0),('assign_applicant','',91,8,1,266,0,0),('assign_applicant','',95,8,1,267,0,0),('customfield_set_anexoiiiformulariob','',29,4,1,300,0,0),('customfield_set_anexoiiiformulariob','',90,8,1,301,0,0),('customfield_set_anexovformularioa','',103,8,1,304,0,0),('customfield_set_anexovformulariob','',104,8,1,305,0,0),('assign_user','',94,8,1,306,0,0),('customfield_set_anexovformularioa','',118,8,1,309,0,0),('customfield_set_anexoiiiformularioc','',97,8,1,310,0,0),('customfield_set_silascaracteristicasdelemprendimientohacennecesariasmasfilasadjunteunaplanillaadicionaldondesecomple','',118,8,1,311,0,0),('customfield_set_tipoautorizacion','',118,8,1,312,0,0),('customfield_set_presentaplanmanejodelfuegoparasuperficiesmayoresa700hadeplantacion','',118,8,1,313,0,0),('customfield_set_caracteristicas','',118,8,1,314,0,0),('customfield_set_numeroexpediente','',130,9,3,316,1,0),('assign_user','team_59',130,9,3,317,0,0),('customfield_set_informacioncomplementaria','',94,8,1,319,0,0),('customfield_set_pedidodeinformacioncomplementaria','',106,8,1,320,0,0),('assign_applicant','',106,8,1,321,0,0),('customfield_set_respuestapedidoinformacioncomplementaria','',129,8,1,322,0,0),('assign_user','',129,8,1,324,0,0),('customfield_set_motivosdeobservacion','',107,8,1,325,0,0),('assign_applicant','',107,8,1,326,0,0),('assign_user','',108,8,1,327,0,0),('customfield_set_correciones','',108,8,1,328,0,0),('customfield_set_observacionesdecorrecciones','',108,8,1,329,0,0),('customfield_set_anexoivformularioacertificadodeobra','',113,8,1,331,0,0),('assign_applicant','',97,8,1,332,0,0),('customfield_set_preguntasdeevaluadores','',131,9,3,333,0,0),('customfield_set_pefile','',131,9,3,334,0,0),('customfield_set_preguntasdeevaluadores','',132,9,3,335,0,0),('customfield_set_pefile','',132,9,3,336,0,0),('assign_applicant','',219,12,1,339,0,0),('assign_owner','',218,12,1,344,0,0),('assign_applicant','',222,12,1,345,0,0),('assign_applicant','',220,12,1,346,0,0),('assign_applicant','',221,12,1,347,0,0),('assign_applicant','',224,12,1,349,0,0),('assign_applicant','',227,12,1,352,0,0),('customfield_set_grafica','',223,12,1,353,0,0),('assign_owner','',228,13,1,356,0,0),('assign_applicant','',229,13,1,357,0,0),('assign_applicant','',230,13,1,358,0,0),('assign_applicant','',231,13,1,359,0,0),('customfield_set_grafica','',232,13,1,360,0,0),('assign_applicant','',233,13,1,361,0,0),('assign_applicant','',235,12,1,362,0,0),('assign_applicant','',236,12,1,363,0,0),('assign_applicant','',237,12,1,364,0,0),('customfield_set_observaciones','',231,13,1,365,1,0),('customfield_set_observaciones','',222,12,1,366,0,0),('assign_owner','',238,14,1,367,0,0),('assign_applicant','',239,14,1,368,0,0),('customfield_set_observaciones','',239,14,1,369,0,0),('assign_applicant','',240,14,1,370,0,0),('assign_applicant','',241,14,1,371,0,0),('assign_applicant','',244,12,1,372,0,0),('assign_applicant','',245,12,1,373,0,0),('assign_applicant','',246,12,1,374,0,0),('assign_owner','',247,15,1,375,0,0),('assign_applicant','',248,15,1,376,0,0),('assign_applicant','',249,15,1,377,0,0),('customfield_set_observaciones','',249,15,1,378,1,0),('assign_applicant','',250,15,1,379,0,0);

--
-- Table structure for table `tbg_workflow_transition_validation_rules`
--

CREATE TABLE `tbg_workflow_transition_validation_rules` (
  `rule` varchar(100) DEFAULT NULL,
  `rule_value` varchar(200) DEFAULT NULL,
  `pre_or_post` varchar(200) DEFAULT NULL,
  `transition_id` int(10) DEFAULT '0',
  `workflow_id` int(10) DEFAULT '0',
  `scope` int(10) DEFAULT '0',
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=58 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tbg_workflow_transition_validation_rules`
--

INSERT INTO `tbg_workflow_transition_validation_rules` VALUES ('max_assigned_issues','5','pre',1,2,2,1),('valid_resolution','79,78,82,77,83','post',4,2,2,2),('max_assigned_issues','5','pre',5,2,2,3),('valid_status','95,96,97,98','post',9,2,2,4),('valid_resolution','81,78,80,83','post',9,2,2,5),('max_assigned_issues','5','pre',14,3,3,6),('valid_resolution','122,121,125,120,126','post',17,3,3,7),('max_assigned_issues','5','pre',18,3,3,8),('valid_status','138,139,140,141','post',22,3,3,9),('valid_resolution','124,121,123,126','post',22,3,3,10),('valid_team','','pre',91,8,1,12),('valid_team','','pre',95,8,1,13),('only_assigned_issues','','pre',218,12,1,27),('only_assigned_issues','','pre',222,12,1,28),('only_assigned_issues','','pre',220,12,1,29),('only_assigned_issues','','pre',219,12,1,30),('only_assigned_issues','','pre',221,12,1,32),('only_assigned_issues','','pre',223,12,1,33),('only_assigned_issues','','pre',224,12,1,34),('only_assigned_issues','','pre',227,12,1,35),('only_assigned_issues','','pre',229,13,1,37),('only_assigned_issues','','pre',230,13,1,38),('only_assigned_issues','','pre',231,13,1,39),('only_assigned_issues','','pre',232,13,1,40),('only_assigned_issues','','pre',233,13,1,41),('only_assigned_issues','','pre',235,12,1,42),('only_assigned_issues','','pre',236,12,1,43),('only_assigned_issues','','pre',228,13,1,45),('only_assigned_issues','','pre',237,12,1,46),('only_assigned_issues','','pre',238,14,1,47),('only_assigned_issues','','pre',239,14,1,48),('only_assigned_issues','','pre',240,14,1,49),('only_assigned_issues','','pre',241,14,1,50),('only_assigned_issues','','pre',244,12,1,51),('only_assigned_issues','','pre',245,12,1,52),('only_assigned_issues','','pre',246,12,1,53),('only_assigned_issues','','pre',247,15,1,54),('only_assigned_issues','','pre',248,15,1,55),('only_assigned_issues','','pre',249,15,1,56),('only_assigned_issues','','pre',250,15,1,57);

--
-- Table structure for table `tbg_workflow_transitions`
--

CREATE TABLE `tbg_workflow_transitions` (
  `name` varchar(200) DEFAULT NULL,
  `description` varchar(200) DEFAULT NULL,
  `outgoing_step_id` int(10) DEFAULT '0',
  `template` varchar(200) DEFAULT NULL,
  `workflow_id` int(10) DEFAULT '0',
  `scope` int(10) DEFAULT '0',
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=252 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tbg_workflow_transitions`
--

INSERT INTO `tbg_workflow_transitions` VALUES ('Investigate issue','Assign the issue to yourself and start investigating it',2,'',2,2,1),('Request more information','Move issue back to new state for more details',1,'main/updateissueproperties',2,2,2),('Confirm issue','Confirm that the issue is valid',3,'',2,2,3),('Reject issue','Reject the issue as invalid',7,'main/updateissueproperties',2,2,4),('Accept issue','Accept the issue and assign it to yourself',4,'',2,2,5),('Reopen issue','Reopen the issue',1,'',2,2,6),('Assign issue','Accept the issue and assign it to someone',4,'main/updateissueproperties',2,2,7),('Mark ready for testing','Mark the issue as ready to be tested',5,'',2,2,8),('Resolve issue','Resolve the issue',8,'main/updateissueproperties',2,2,9),('Test issue solution','Check whether the solution is valid',6,'',2,2,10),('Accept issue solution','Mark the issue as resolved',8,'main/updateissueproperties',2,2,11),('Reject issue solution','Reject the proposed solution and mark the issue as in progress',4,'',2,2,12),('Issue created','This is the initial transition for issues using this workflow',1,'',2,2,13),('Investigate issue','Assign the issue to yourself and start investigating it',10,'',3,3,14),('Request more information','Move issue back to new state for more details',9,'main/updateissueproperties',3,3,15),('Confirm issue','Confirm that the issue is valid',11,'',3,3,16),('Reject issue','Reject the issue as invalid',15,'main/updateissueproperties',3,3,17),('Accept issue','Accept the issue and assign it to yourself',12,'',3,3,18),('Reopen issue','Reopen the issue',9,'',3,3,19),('Assign issue','Accept the issue and assign it to someone',12,'main/updateissueproperties',3,3,20),('Mark ready for testing','Mark the issue as ready to be tested',13,'',3,3,21),('Resolve issue','Resolve the issue',16,'main/updateissueproperties',3,3,22),('Test issue solution','Check whether the solution is valid',14,'',3,3,23),('Accept issue solution','Mark the issue as resolved',16,'main/updateissueproperties',3,3,24),('Reject issue solution','Reject the proposed solution and mark the issue as in progress',12,'',3,3,25),('Issue created','This is the initial transition for issues using this workflow',9,'',3,3,26),('Issue created','This is the initial transition for issues using this workflow',17,'',4,1,27),('Profesional ANEXO III Form B','',19,'main/updateissueproperties',4,1,29),('Verificar Tipo Productor','',18,'main/updateissueproperties',4,1,30),('Completar ANEXO III Form. A1','',20,'main/updateissueproperties',4,1,31),('Completar ANEXO III y IV','',21,'main/updateissueproperties',4,1,32),('Verificar OTBN','',22,'main/updateissueproperties',4,1,33),('Completar ANEXO V','',24,'main/updateissueproperties',4,1,35),('Analizar Plan Nación','',25,'main/updateissueproperties',4,1,36),('Evaluar y Decidir','',26,'main/updateissueproperties',4,1,37),('Issue created','This is the initial transition for issues using this workflow',27,'',5,1,38),('Asignar Expediente','',28,'main/updateissueproperties',5,1,39),('Enviar a Validar','',32,'main/updateissueproperties',5,1,43),('Evaluar Aprobación / prueba','',33,'main/updateissueproperties',5,1,44),('Completar Informe Siembra','',34,'main/updateissueproperties',5,1,45),('Solicitar Informe Parcial','',35,'main/updateissueproperties',5,1,46),('Evaluar','',39,'main/updateissueproperties',5,1,47),('Enviar a Evaluación','',37,'main/updateissueproperties',5,1,48),('Solicitar Cierre','',38,'main/updateissueproperties',5,1,49),('Enviar Consultas al Solicitante','',29,'main/updateissueproperties',5,1,52),('Revisar Información CONABIA Técnicos','',30,'main/updateissueproperties',5,1,55),('Responder las consultas y/o preguntas','',31,'main/updateissueproperties',5,1,56),('Responder las consultas y/o preguntas','',31,'main/updateissueproperties',5,1,57),('Responder las consultas y/o preguntas','',31,'main/updateissueproperties',5,1,58),('Responder las consultas y/o preguntas','',31,'main/updateissueproperties',5,1,59),('Responder las consultas','',31,'main/updateissueproperties',5,1,62),('Enviar Respuestas','',29,'main/updateissueproperties',5,1,67),('Respuestas brindadas por el Solicitante','',30,'main/updateissueproperties',5,1,68),('Analizar Plan Provincia','',23,'main/updateissueproperties',4,1,74),('Responder las consultas y/o preguntas','',31,'main/updateissueproperties',5,1,75),('Evaluar Aprobación . prueba','',33,'main/updateissueproperties',5,1,77),('Enviar Consultas','',31,'main/updateissueproperties',5,1,84),('Issue created','This is the initial transition for issues using this workflow',45,'',6,1,85),('Issue created','This is the initial transition for issues using this workflow',46,'',7,1,86),('Issue created','This is the initial transition for issues using this workflow',47,'',8,1,87),('Enviar a Provincia','',51,'main/updateissueproperties',8,1,94),('Formulario III ANEXO C','',48,'main/updateissueproperties',8,1,97),('Prueba de T','',22,'main/updateissueproperties',4,1,98),('Enviar a Nación','',55,'main/updateissueproperties',8,1,99),('Enviar a técnicos','',56,'',8,1,100),('Realizar preguntas','',57,'main/updateissueproperties',8,1,101),('Issue created','This is the initial transition for issues using this workflow',61,'',9,3,105),('Modificar Información','',62,'main/updateissueproperties',8,1,106),('Enviar Motivo de Observación','',49,'main/updateissueproperties',8,1,107),('Enviar correcciones','',63,'main/updateissueproperties',8,1,108),('Realizar Evaluación','',48,'',8,1,109),('Enviar respuestas','',64,'',8,1,110),('Realizar Análisis','',56,'',8,1,111),('Solicitar Certificado de Obra','',65,'',8,1,112),('Cargar Anexo IV A','',66,'main/updateissueproperties',8,1,113),('Enviar Observaciones','',67,'',8,1,114),('Enviar Correcciones','',68,'',8,1,115),('Realizar Evaluación','',66,'',8,1,116),('Realizar Inspección','',69,'',8,1,117),('Cargar Evaluación preliminar','',70,'main/updateissueproperties',8,1,118),('Enviar preguntas','',71,'main/updateissueproperties',8,1,119),('Enviar a SIG','',60,'',8,1,120),('Enviar Respuestas','',59,'',8,1,121),('Enviar Observaciones','',72,'main/updateissueproperties',8,1,122),('Enviar Correcciones','',58,'',8,1,123),('Analizar Plan','',60,'',8,1,124),('Analizar Plan','',60,'',8,1,125),('Enviar a Liquidación','',73,'',8,1,126),('Enviar a reinspeccionar','',74,'',8,1,127),('Aprobar Plan','',75,'',8,1,128),('Re enviar información','',51,'main/updateissueproperties',8,1,129),('Enviar a técnicos','',76,'main/updateissueproperties',9,3,130),('Enviar preguntas','',78,'main/updateissueproperties',9,3,131),('Enviar preguntas a solicitante','',79,'main/updateissueproperties',9,3,132),('Enviar información complementaria','',80,'main/updateissueproperties',9,3,133),('Realizar nuevas preguntas','',76,'',9,3,134),('No hay mas preguntas','',82,'',9,3,135),('Enviar respuesta a técnicos','',81,'main/updateissueproperties',9,3,136),('Validar proyecto de resolución','',83,'main/updateissueproperties',9,3,137),('Enviar respuesta','',84,'main/updateissueproperties',9,3,138),('Enviar aprobación de proyecto de resolución','',85,'',9,3,139),('Enviar informe de siembra','',86,'main/updateissueproperties',9,3,140),('Enviar informe de siembra a técnicos','',88,'',9,3,142),('Enviar informes parciales','',90,'main/updateissueproperties',9,3,144),('Enviar información complementaria','',91,'main/updateissueproperties',9,3,145),('Enviar información a técnicos','',92,'',9,3,146),('Generar nuevas preguntas','',88,'',9,3,147),('Enviar informe parcial a técnicos','',93,'',9,3,148),('Enviar preguntas de informe de siembra','',94,'main/updateissueproperties',9,3,149),('Enviar preguntas a solicitante','',87,'main/updateissueproperties',9,3,150),('Información completa','',89,'',9,3,151),('Enviar preguntas de informe parcial','',95,'main/updateissueproperties',9,3,152),('Enviar preguntas a solicitante','',96,'',9,3,153),('Enviar información complementaria','',97,'main/updateissueproperties',9,3,154),('Enviar información a técnicos','',98,'',9,3,155),('Generar nuevas preguntas','',93,'',9,3,156),('Información completa','',99,'',9,3,157),('Enviar informe de cierre','',100,'',9,3,158),('Enviar informe de cierre a técnicos','',101,'',9,3,159),('Enviar preguntas de informe de cierre','',102,'main/updateissueproperties',9,3,160),('Enviar preguntas al solicitante','',103,'',9,3,161),('Enviar información complementaria','',104,'main/updateissueproperties',9,3,162),('Enviar respuesta a técnicos','',105,'',9,3,163),('Generar nuevas preguntas','',101,'',9,3,164),('Enviar a evaluar','',106,'main/updateissueproperties',9,3,165),('Generar Cierre','',107,'',9,3,166),('Issue created','This is the initial transition for issues using this workflow',109,'',10,2,167),('Issue created','This is the initial transition for issues using this workflow',110,'',11,2,168),('Enviar a Provincia','',111,'main/updateissueproperties',11,2,169),('Modificar Información','',112,'main/updateissueproperties',11,2,170),('Re enviar Información','',111,'main/updateissueproperties',11,2,172),('Hacer Evaluación Preliminar','',113,'main/updateissueproperties',11,2,173),('Enviar Motivo de Observación','',114,'main/updateissueproperties',11,2,174),('Enviar Correcciones','',115,'main/updateissueproperties',11,2,175),('Realizar Evaluación','',113,'main/updateissueproperties',11,2,176),('Enviar a Nación','',119,'main/updateissueproperties',11,2,177),('Enviar Respuestas','',120,'main/updateissueproperties',11,2,178),('Enviar Observaciones','',124,'main/updateissueproperties',11,2,179),('Realizar Preguntas','',116,'main/updateissueproperties',11,2,180),('Realizar Observaciones','',122,'main/updateissueproperties',11,2,181),('Enviar Respuestas','',119,'main/updateissueproperties',11,2,182),('Realizar Análisis','',119,'main/updateissueproperties',11,2,183),('Realizar Análisis','',119,'main/updateissueproperties',11,2,184),('Aprobar Primera Cuota','',119,'main/updateissueproperties',11,2,186),('Generar Informe de Pago','',123,'main/updateissueproperties',11,2,187),('Enviar Tránsito','',117,'main/updateissueproperties',11,2,188),('Enviar Tránsito','',117,'main/updateissueproperties',11,2,189),('Cargar Certificado de Obra','',125,'main/updateissueproperties',11,2,190),('Realizar Inspección','',127,'main/updateissueproperties',11,2,191),('Cargar Informe de Inspección','',128,'main/updateissueproperties',11,2,192),('Enviar Observaciones','',129,'main/updateissueproperties',11,2,193),('Enviar Correcciones','',128,'main/updateissueproperties',11,2,194),('Realizar Evaluación','',125,'main/updateissueproperties',11,2,195),('Enviar Correcciones','',126,'main/updateissueproperties',11,2,196),('Enviar Observaciones','',118,'main/updateissueproperties',11,2,197),('Aprobar Plan','',133,'main/updateissueproperties',11,2,198),('Enviar Preguntas a Provincia','',131,'main/updateissueproperties',11,2,199),('Enviar Respuesta','',132,'main/updateissueproperties',11,2,200),('Enviar a Analizar','',133,'main/updateissueproperties',11,2,201),('Enviar Preguntas a Solicitante','',130,'main/updateissueproperties',11,2,202),('Enviar Correcciones','',134,'main/updateissueproperties',11,2,203),('Enviar a Analizar','',133,'main/updateissueproperties',11,2,204),('Cargar Informe de Auditoría','',136,'main/updateissueproperties',11,2,205),('Enviar a Reinspeccionar','',135,'main/updateissueproperties',11,2,206),('Enviar a Liquidaciones','',138,'main/updateissueproperties',11,2,207),('Enviar a Liquidaciones','',138,'main/updateissueproperties',11,2,208),('Cargar Informe Auditoria','',137,'main/updateissueproperties',11,2,209),('Reinspeccionar','',135,'main/updateissueproperties',11,2,210),('Iniciar Trámite de Pago','',139,'main/updateissueproperties',11,2,211),('Hacer Observaciones Técnicas','',140,'main/updateissueproperties',11,2,213),('Hacer Observaciones Legales','',141,'main/updateissueproperties',11,2,214),('Responder Observaciones','',138,'main/updateissueproperties',11,2,215),('Responder Observaciones','',138,'main/updateissueproperties',11,2,216),('Issue created','This is the initial transition for issues using this workflow',144,'',12,1,217),('Generar Baja','',154,'',13,1,228),('Finalizar Impresión','',159,'',13,1,233),('Issue created','This is the initial transition for issues using this workflow',153,'',13,1,234),('Solicitar Aprobación','',163,'',14,1,238),('Rechazar','',164,'main/updateissueproperties',14,1,239),('Aprobar','',165,'',14,1,240),('Finalizar Solicitud','',166,'',14,1,241),('Issue created','This is the initial transition for issues using this workflow',162,'',14,1,242),('Pendiente de Entrega','',167,'',12,1,245),('Solicitud Finalizada','',160,'',12,1,246),('Solicitar Baja','',169,'',15,1,247),('Aprobar','',171,'',15,1,248),('Rechazar','',170,'main/updateissueproperties',15,1,249),('Finalizar Impresión','',159,'',15,1,250),('Issue created','This is the initial transition for issues using this workflow',168,'',15,1,251);

--
-- Table structure for table `tbg_workflows`
--

CREATE TABLE `tbg_workflows` (
  `name` varchar(200) DEFAULT NULL,
  `description` varchar(200) DEFAULT NULL,
  `is_active` tinyint(1) DEFAULT NULL,
  `initial_transition_id` int(10) DEFAULT '0',
  `scope` int(10) DEFAULT '0',
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `json_grafico` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tbg_workflows`
--

INSERT INTO `tbg_workflows` VALUES ('Default workflow','This is the default workflow. It is used by all projects with no specific workflow selected, and for issue types with no specific workflow specified. This workflow cannot be edited or removed.',1,13,1,1,NULL),('Workflow por defecto','Este es el workflow por default. Es utilizado por todos los proyectos que no tienen un workflow seleccionado, y para tipos de procesos que no tienen un workflow especifico. Este workflow no puede ser ',1,13,2,2,''),('Workflow por defecto','Este es el workflow por default. Es utilizado por todos los proyectos que no tienen un workflow seleccionado, y para tipos de procesos que no tienen un workflow especifico. Este workflow no puede ser ',1,26,3,3,''),('Resolución 701','',1,105,3,9,'{&quot;nodes&quot;:[{&quot;blockId&quot;:&quot;startpoint&quot;,&quot;nodetype&quot;:&quot;startpoint&quot;,&quot;positionX&quot;:0,&quot;positionY&quot;:0,&quot;inputValue&quot;:&quot;&quot;,&quot;inputStepId&quot;:&quot;&quot;,&quot;_input_state&quot;:&quot;&quot;,&quot;_input_is_editable&quot;:&quot;&quot;,&quot;_input_status_id&quot;:&quot;&quot;},{&quot;blockId&quot;:&quot;endpoint&quot;,&quot;nodetype&quot;:&quot;endpoint&quot;,&quot;positionX&quot;:0,&quot;positionY&quot;:0,&quot;inputValue&quot;:&quot;&quot;,&quot;inputStepId&quot;:&quot;&quot;,&quot;_input_state&quot;:&quot;&quot;,&quot;_input_is_editable&quot;:&quot;&quot;,&quot;_input_status_id&quot;:&quot;&quot;},{&quot;blockId&quot;:&quot;step_61&quot;,&quot;nodetype&quot;:&quot;task&quot;,&quot;positionX&quot;:-683,&quot;positionY&quot;:85,&quot;inputValue&quot;:&quot;Asignando Expediente&quot;,&quot;inputStepId&quot;:&quot;61&quot;,&quot;_input_state&quot;:&quot;0&quot;,&quot;_input_is_editable&quot;:&quot;0&quot;,&quot;_input_status_id&quot;:&quot;164&quot;},{&quot;blockId&quot;:&quot;step_76&quot;,&quot;nodetype&quot;:&quot;task&quot;,&quot;positionX&quot;:-750,&quot;positionY&quot;:599,&quot;inputValue&quot;:&quot;Generando Nota con preguntas&quot;,&quot;inputStepId&quot;:&quot;76&quot;,&quot;_input_state&quot;:&quot;0&quot;,&quot;_input_is_editable&quot;:&quot;0&quot;,&quot;_input_status_id&quot;:&quot;165&quot;},{&quot;blockId&quot;:&quot;step_78&quot;,&quot;nodetype&quot;:&quot;task&quot;,&quot;positionX&quot;:-471,&quot;positionY&quot;:357,&quot;inputValue&quot;:&quot;Solicitando información complementaria&quot;,&quot;inputStepId&quot;:&quot;78&quot;,&quot;_input_state&quot;:&quot;0&quot;,&quot;_input_is_editable&quot;:&quot;1&quot;,&quot;_input_status_id&quot;:&quot;165&quot;},{&quot;blockId&quot;:&quot;step_79&quot;,&quot;nodetype&quot;:&quot;task&quot;,&quot;positionX&quot;:-269,&quot;positionY&quot;:72,&quot;inputValue&quot;:&quot;Completando información&quot;,&quot;inputStepId&quot;:&quot;79&quot;,&quot;_input_state&quot;:&quot;0&quot;,&quot;_input_is_editable&quot;:&quot;1&quot;,&quot;_input_status_id&quot;:&quot;165&quot;},{&quot;blockId&quot;:&quot;step_80&quot;,&quot;nodetype&quot;:&quot;task&quot;,&quot;positionX&quot;:-171,&quot;positionY&quot;:361,&quot;inputValue&quot;:&quot;Recibiendo información complementaria&quot;,&quot;inputStepId&quot;:&quot;80&quot;,&quot;_input_state&quot;:&quot;0&quot;,&quot;_input_is_editable&quot;:&quot;1&quot;,&quot;_input_status_id&quot;:&quot;165&quot;},{&quot;blockId&quot;:&quot;step_81&quot;,&quot;nodetype&quot;:&quot;task&quot;,&quot;positionX&quot;:-277,&quot;positionY&quot;:637,&quot;inputValue&quot;:&quot;Evaluando preguntas de solicitante&quot;,&quot;inputStepId&quot;:&quot;81&quot;,&quot;_input_state&quot;:&quot;0&quot;,&quot;_input_is_editable&quot;:&quot;1&quot;,&quot;_input_status_id&quot;:&quot;165&quot;},{&quot;blockId&quot;:&quot;step_82&quot;,&quot;nodetype&quot;:&quot;task&quot;,&quot;positionX&quot;:135,&quot;positionY&quot;:381,&quot;inputValue&quot;:&quot;Generando proyecto de resolución&quot;,&quot;inputStepId&quot;:&quot;82&quot;,&quot;_input_state&quot;:&quot;0&quot;,&quot;_input_is_editable&quot;:&quot;1&quot;,&quot;_input_status_id&quot;:&quot;167&quot;},{&quot;blockId&quot;:&quot;step_83&quot;,&quot;nodetype&quot;:&quot;task&quot;,&quot;positionX&quot;:146,&quot;positionY&quot;:71,&quot;inputValue&quot;:&quot;Validando proyecto de resolución&quot;,&quot;inputStepId&quot;:&quot;83&quot;,&quot;_input_state&quot;:&quot;0&quot;,&quot;_input_is_editable&quot;:&quot;1&quot;,&quot;_input_status_id&quot;:&quot;166&quot;},{&quot;blockId&quot;:&quot;step_84&quot;,&quot;nodetype&quot;:&quot;task&quot;,&quot;positionX&quot;:444,&quot;positionY&quot;:385,&quot;inputValue&quot;:&quot;Aprobando proyecto de resolución&quot;,&quot;inputStepId&quot;:&quot;84&quot;,&quot;_input_state&quot;:&quot;0&quot;,&quot;_input_is_editable&quot;:&quot;1&quot;,&quot;_input_status_id&quot;:&quot;0&quot;},{&quot;blockId&quot;:&quot;step_85&quot;,&quot;nodetype&quot;:&quot;task&quot;,&quot;positionX&quot;:519,&quot;positionY&quot;:64,&quot;inputValue&quot;:&quot;Completando informe de siembra&quot;,&quot;inputStepId&quot;:&quot;85&quot;,&quot;_input_state&quot;:&quot;0&quot;,&quot;_input_is_editable&quot;:&quot;1&quot;,&quot;_input_status_id&quot;:&quot;173&quot;},{&quot;blockId&quot;:&quot;step_86&quot;,&quot;nodetype&quot;:&quot;task&quot;,&quot;positionX&quot;:720,&quot;positionY&quot;:385,&quot;inputValue&quot;:&quot;Evaluando informe de siembra&quot;,&quot;inputStepId&quot;:&quot;86&quot;,&quot;_input_state&quot;:&quot;0&quot;,&quot;_input_is_editable&quot;:&quot;1&quot;,&quot;_input_status_id&quot;:&quot;165&quot;},{&quot;blockId&quot;:&quot;step_87&quot;,&quot;nodetype&quot;:&quot;task&quot;,&quot;positionX&quot;:939,&quot;positionY&quot;:61,&quot;inputValue&quot;:&quot;Completando información&quot;,&quot;inputStepId&quot;:&quot;87&quot;,&quot;_input_state&quot;:&quot;0&quot;,&quot;_input_is_editable&quot;:&quot;1&quot;,&quot;_input_status_id&quot;:&quot;165&quot;},{&quot;blockId&quot;:&quot;step_88&quot;,&quot;nodetype&quot;:&quot;task&quot;,&quot;positionX&quot;:674,&quot;positionY&quot;:765,&quot;inputValue&quot;:&quot;Evaluando informe de siembra&quot;,&quot;inputStepId&quot;:&quot;88&quot;,&quot;_input_state&quot;:&quot;0&quot;,&quot;_input_is_editable&quot;:&quot;1&quot;,&quot;_input_status_id&quot;:&quot;165&quot;},{&quot;blockId&quot;:&quot;step_89&quot;,&quot;nodetype&quot;:&quot;task&quot;,&quot;positionX&quot;:1361,&quot;positionY&quot;:51,&quot;inputValue&quot;:&quot;Generando informes parciales &quot;,&quot;inputStepId&quot;:&quot;89&quot;,&quot;_input_state&quot;:&quot;0&quot;,&quot;_input_is_editable&quot;:&quot;1&quot;,&quot;_input_status_id&quot;:&quot;0&quot;},{&quot;blockId&quot;:&quot;step_90&quot;,&quot;nodetype&quot;:&quot;task&quot;,&quot;positionX&quot;:1586,&quot;positionY&quot;:421,&quot;inputValue&quot;:&quot;Evaluando informes parciales&quot;,&quot;inputStepId&quot;:&quot;90&quot;,&quot;_input_state&quot;:&quot;0&quot;,&quot;_input_is_editable&quot;:&quot;1&quot;,&quot;_input_status_id&quot;:&quot;0&quot;},{&quot;blockId&quot;:&quot;step_91&quot;,&quot;nodetype&quot;:&quot;task&quot;,&quot;positionX&quot;:1257,&quot;positionY&quot;:657,&quot;inputValue&quot;:&quot;Recibiendo iformación complementaria&quot;,&quot;inputStepId&quot;:&quot;91&quot;,&quot;_input_state&quot;:&quot;0&quot;,&quot;_input_is_editable&quot;:&quot;1&quot;,&quot;_input_status_id&quot;:&quot;165&quot;},{&quot;blockId&quot;:&quot;step_92&quot;,&quot;nodetype&quot;:&quot;task&quot;,&quot;positionX&quot;:843,&quot;positionY&quot;:1067,&quot;inputValue&quot;:&quot;Recibiendo respuestas de informe de siembra&quot;,&quot;inputStepId&quot;:&quot;92&quot;,&quot;_input_state&quot;:&quot;0&quot;,&quot;_input_is_editable&quot;:&quot;1&quot;,&quot;_input_status_id&quot;:&quot;165&quot;},{&quot;blockId&quot;:&quot;step_93&quot;,&quot;nodetype&quot;:&quot;task&quot;,&quot;positionX&quot;:1452,&quot;positionY&quot;:866,&quot;inputValue&quot;:&quot;Evaluando informe parcial&quot;,&quot;inputStepId&quot;:&quot;93&quot;,&quot;_input_state&quot;:&quot;0&quot;,&quot;_input_is_editable&quot;:&quot;1&quot;,&quot;_input_status_id&quot;:&quot;0&quot;},{&quot;blockId&quot;:&quot;step_94&quot;,&quot;nodetype&quot;:&quot;task&quot;,&quot;positionX&quot;:1022,&quot;positionY&quot;:428,&quot;inputValue&quot;:&quot;Solicitando datos de informe de siembra&quot;,&quot;inputStepId&quot;:&quot;94&quot;,&quot;_input_state&quot;:&quot;0&quot;,&quot;_input_is_editable&quot;:&quot;1&quot;,&quot;_input_status_id&quot;:&quot;165&quot;},{&quot;blockId&quot;:&quot;step_95&quot;,&quot;nodetype&quot;:&quot;task&quot;,&quot;positionX&quot;:1854,&quot;positionY&quot;:565,&quot;inputValue&quot;:&quot;Solicitando datos de informes parciales&quot;,&quot;inputStepId&quot;:&quot;95&quot;,&quot;_input_state&quot;:&quot;0&quot;,&quot;_input_is_editable&quot;:&quot;1&quot;,&quot;_input_status_id&quot;:&quot;0&quot;},{&quot;blockId&quot;:&quot;step_96&quot;,&quot;nodetype&quot;:&quot;task&quot;,&quot;positionX&quot;:1849,&quot;positionY&quot;:54,&quot;inputValue&quot;:&quot;Completando información&quot;,&quot;inputStepId&quot;:&quot;96&quot;,&quot;_input_state&quot;:&quot;0&quot;,&quot;_input_is_editable&quot;:&quot;1&quot;,&quot;_input_status_id&quot;:&quot;0&quot;},{&quot;blockId&quot;:&quot;step_97&quot;,&quot;nodetype&quot;:&quot;task&quot;,&quot;positionX&quot;:2045,&quot;positionY&quot;:773,&quot;inputValue&quot;:&quot;Recibiendo información complementaria&quot;,&quot;inputStepId&quot;:&quot;97&quot;,&quot;_input_state&quot;:&quot;0&quot;,&quot;_input_is_editable&quot;:&quot;1&quot;,&quot;_input_status_id&quot;:&quot;0&quot;},{&quot;blockId&quot;:&quot;step_98&quot;,&quot;nodetype&quot;:&quot;task&quot;,&quot;positionX&quot;:1607,&quot;positionY&quot;:1108,&quot;inputValue&quot;:&quot;Recibiendo respuesta de informes parciales&quot;,&quot;inputStepId&quot;:&quot;98&quot;,&quot;_input_state&quot;:&quot;0&quot;,&quot;_input_is_editable&quot;:&quot;1&quot;,&quot;_input_status_id&quot;:&quot;0&quot;},{&quot;blockId&quot;:&quot;step_99&quot;,&quot;nodetype&quot;:&quot;task&quot;,&quot;positionX&quot;:2155,&quot;positionY&quot;:129,&quot;inputValue&quot;:&quot;Generando informe de cierre&quot;,&quot;inputStepId&quot;:&quot;99&quot;,&quot;_input_state&quot;:&quot;0&quot;,&quot;_input_is_editable&quot;:&quot;1&quot;,&quot;_input_status_id&quot;:&quot;0&quot;},{&quot;blockId&quot;:&quot;step_100&quot;,&quot;nodetype&quot;:&quot;task&quot;,&quot;positionX&quot;:2285,&quot;positionY&quot;:442,&quot;inputValue&quot;:&quot;Evaluando informe de cierre&quot;,&quot;inputStepId&quot;:&quot;100&quot;,&quot;_input_state&quot;:&quot;0&quot;,&quot;_input_is_editable&quot;:&quot;1&quot;,&quot;_input_status_id&quot;:&quot;0&quot;},{&quot;blockId&quot;:&quot;step_101&quot;,&quot;nodetype&quot;:&quot;task&quot;,&quot;positionX&quot;:2364,&quot;positionY&quot;:840,&quot;inputValue&quot;:&quot;Evaluando informe de cierre&quot;,&quot;inputStepId&quot;:&quot;101&quot;,&quot;_input_state&quot;:&quot;0&quot;,&quot;_input_is_editable&quot;:&quot;1&quot;,&quot;_input_status_id&quot;:&quot;0&quot;},{&quot;blockId&quot;:&quot;step_102&quot;,&quot;nodetype&quot;:&quot;task&quot;,&quot;positionX&quot;:2663,&quot;positionY&quot;:424,&quot;inputValue&quot;:&quot;Solicitando datos informe de cierre&quot;,&quot;inputStepId&quot;:&quot;102&quot;,&quot;_input_state&quot;:&quot;0&quot;,&quot;_input_is_editable&quot;:&quot;1&quot;,&quot;_input_status_id&quot;:&quot;0&quot;},{&quot;blockId&quot;:&quot;step_103&quot;,&quot;nodetype&quot;:&quot;task&quot;,&quot;positionX&quot;:2830,&quot;positionY&quot;:47,&quot;inputValue&quot;:&quot;Completando información&quot;,&quot;inputStepId&quot;:&quot;103&quot;,&quot;_input_state&quot;:&quot;0&quot;,&quot;_input_is_editable&quot;:&quot;1&quot;,&quot;_input_status_id&quot;:&quot;0&quot;},{&quot;blockId&quot;:&quot;step_104&quot;,&quot;nodetype&quot;:&quot;task&quot;,&quot;positionX&quot;:2799,&quot;positionY&quot;:786,&quot;inputValue&quot;:&quot;Recibiendo información complementaria&quot;,&quot;inputStepId&quot;:&quot;104&quot;,&quot;_input_state&quot;:&quot;0&quot;,&quot;_input_is_editable&quot;:&quot;1&quot;,&quot;_input_status_id&quot;:&quot;0&quot;},{&quot;blockId&quot;:&quot;step_105&quot;,&quot;nodetype&quot;:&quot;task&quot;,&quot;positionX&quot;:2321,&quot;positionY&quot;:1136,&quot;inputValue&quot;:&quot;Analizando respuestas de informe de cierre&quot;,&quot;inputStepId&quot;:&quot;105&quot;,&quot;_input_state&quot;:&quot;0&quot;,&quot;_input_is_editable&quot;:&quot;1&quot;,&quot;_input_status_id&quot;:&quot;0&quot;},{&quot;blockId&quot;:&quot;step_106&quot;,&quot;nodetype&quot;:&quot;task&quot;,&quot;positionX&quot;:3075,&quot;positionY&quot;:416,&quot;inputValue&quot;:&quot;Enviando a evaluar cierre&quot;,&quot;inputStepId&quot;:&quot;106&quot;,&quot;_input_state&quot;:&quot;0&quot;,&quot;_input_is_editable&quot;:&quot;1&quot;,&quot;_input_status_id&quot;:&quot;0&quot;},{&quot;blockId&quot;:&quot;step_107&quot;,&quot;nodetype&quot;:&quot;task&quot;,&quot;positionX&quot;:3376,&quot;positionY&quot;:408,&quot;inputValue&quot;:&quot;Generando Cierre&quot;,&quot;inputStepId&quot;:&quot;107&quot;,&quot;_input_state&quot;:&quot;0&quot;,&quot;_input_is_editable&quot;:&quot;1&quot;,&quot;_input_status_id&quot;:&quot;0&quot;}],&quot;connections&quot;:[{&quot;connectionId&quot;:&quot;con_133&quot;,&quot;pageSourceId&quot;:&quot;step_61&quot;,&quot;pageTargetId&quot;:&quot;step_76&quot;,&quot;nameTransition&quot;:&quot;Enviar a técnicos&quot;,&quot;templateTransition&quot;:&quot;main/updateissueproperties&quot;,&quot;idTransition&quot;:&quot;130&quot;},{&quot;connectionId&quot;:&quot;con_139&quot;,&quot;pageSourceId&quot;:&quot;step_76&quot;,&quot;pageTargetId&quot;:&quot;step_78&quot;,&quot;nameTransition&quot;:&quot;Enviar preguntas&quot;,&quot;templateTransition&quot;:&quot;main/updateissueproperties&quot;,&quot;idTransition&quot;:&quot;131&quot;},{&quot;connectionId&quot;:&quot;con_145&quot;,&quot;pageSourceId&quot;:&quot;step_78&quot;,&quot;pageTargetId&quot;:&quot;step_79&quot;,&quot;nameTransition&quot;:&quot;Enviar preguntas a solicitante&quot;,&quot;templateTransition&quot;:&quot;main/updateissueproperties&quot;,&quot;idTransition&quot;:&quot;132&quot;},{&quot;connectionId&quot;:&quot;con_151&quot;,&quot;pageSourceId&quot;:&quot;step_79&quot;,&quot;pageTargetId&quot;:&quot;step_80&quot;,&quot;nameTransition&quot;:&quot;Enviar información complementaria&quot;,&quot;templateTransition&quot;:&quot;main/updateissueproperties&quot;,&quot;idTransition&quot;:&quot;133&quot;},{&quot;connectionId&quot;:&quot;con_157&quot;,&quot;pageSourceId&quot;:&quot;step_81&quot;,&quot;pageTargetId&quot;:&quot;step_76&quot;,&quot;nameTransition&quot;:&quot;Realizar nuevas preguntas&quot;,&quot;templateTransition&quot;:&quot;&quot;,&quot;idTransition&quot;:&quot;134&quot;},{&quot;connectionId&quot;:&quot;con_163&quot;,&quot;pageSourceId&quot;:&quot;step_81&quot;,&quot;pageTargetId&quot;:&quot;step_82&quot;,&quot;nameTransition&quot;:&quot;No hay mas preguntas&quot;,&quot;templateTransition&quot;:&quot;&quot;,&quot;idTransition&quot;:&quot;135&quot;},{&quot;connectionId&quot;:&quot;con_169&quot;,&quot;pageSourceId&quot;:&quot;step_80&quot;,&quot;pageTargetId&quot;:&quot;step_81&quot;,&quot;nameTransition&quot;:&quot;Enviar respuesta a técnicos&quot;,&quot;templateTransition&quot;:&quot;main/updateissueproperties&quot;,&quot;idTransition&quot;:&quot;136&quot;},{&quot;connectionId&quot;:&quot;con_175&quot;,&quot;pageSourceId&quot;:&quot;step_82&quot;,&quot;pageTargetId&quot;:&quot;step_83&quot;,&quot;nameTransition&quot;:&quot;Validar proyecto de resolución&quot;,&quot;templateTransition&quot;:&quot;main/updateissueproperties&quot;,&quot;idTransition&quot;:&quot;137&quot;},{&quot;connectionId&quot;:&quot;con_181&quot;,&quot;pageSourceId&quot;:&quot;step_83&quot;,&quot;pageTargetId&quot;:&quot;step_84&quot;,&quot;nameTransition&quot;:&quot;Enviar respuesta&quot;,&quot;templateTransition&quot;:&quot;main/updateissueproperties&quot;,&quot;idTransition&quot;:&quot;138&quot;},{&quot;connectionId&quot;:&quot;con_187&quot;,&quot;pageSourceId&quot;:&quot;step_84&quot;,&quot;pageTargetId&quot;:&quot;step_85&quot;,&quot;nameTransition&quot;:&quot;Enviar aprobación de proyecto de resolución&quot;,&quot;templateTransition&quot;:&quot;&quot;,&quot;idTransition&quot;:&quot;139&quot;},{&quot;connectionId&quot;:&quot;con_193&quot;,&quot;pageSourceId&quot;:&quot;step_85&quot;,&quot;pageTargetId&quot;:&quot;step_86&quot;,&quot;nameTransition&quot;:&quot;Enviar informe de siembra&quot;,&quot;templateTransition&quot;:&quot;main/updateissueproperties&quot;,&quot;idTransition&quot;:&quot;140&quot;},{&quot;connectionId&quot;:&quot;con_199&quot;,&quot;pageSourceId&quot;:&quot;step_86&quot;,&quot;pageTargetId&quot;:&quot;step_88&quot;,&quot;nameTransition&quot;:&quot;Enviar informe de siembra a técnicos&quot;,&quot;templateTransition&quot;:&quot;&quot;,&quot;idTransition&quot;:&quot;142&quot;},{&quot;connectionId&quot;:&quot;con_205&quot;,&quot;pageSourceId&quot;:&quot;step_89&quot;,&quot;pageTargetId&quot;:&quot;step_90&quot;,&quot;nameTransition&quot;:&quot;Enviar informes parciales&quot;,&quot;templateTransition&quot;:&quot;main/updateissueproperties&quot;,&quot;idTransition&quot;:&quot;144&quot;},{&quot;connectionId&quot;:&quot;con_211&quot;,&quot;pageSourceId&quot;:&quot;step_87&quot;,&quot;pageTargetId&quot;:&quot;step_91&quot;,&quot;nameTransition&quot;:&quot;Enviar información complementaria&quot;,&quot;templateTransition&quot;:&quot;main/updateissueproperties&quot;,&quot;idTransition&quot;:&quot;145&quot;},{&quot;connectionId&quot;:&quot;con_217&quot;,&quot;pageSourceId&quot;:&quot;step_91&quot;,&quot;pageTargetId&quot;:&quot;step_92&quot;,&quot;nameTransition&quot;:&quot;Enviar información a técnicos&quot;,&quot;templateTransition&quot;:&quot;&quot;,&quot;idTransition&quot;:&quot;146&quot;},{&quot;connectionId&quot;:&quot;con_223&quot;,&quot;pageSourceId&quot;:&quot;step_92&quot;,&quot;pageTargetId&quot;:&quot;step_88&quot;,&quot;nameTransition&quot;:&quot;Generar nuevas preguntas&quot;,&quot;templateTransition&quot;:&quot;&quot;,&quot;idTransition&quot;:&quot;147&quot;},{&quot;connectionId&quot;:&quot;con_229&quot;,&quot;pageSourceId&quot;:&quot;step_90&quot;,&quot;pageTargetId&quot;:&quot;step_93&quot;,&quot;nameTransition&quot;:&quot;Enviar informe parcial a técnicos&quot;,&quot;templateTransition&quot;:&quot;&quot;,&quot;idTransition&quot;:&quot;148&quot;},{&quot;connectionId&quot;:&quot;con_235&quot;,&quot;pageSourceId&quot;:&quot;step_88&quot;,&quot;pageTargetId&quot;:&quot;step_94&quot;,&quot;nameTransition&quot;:&quot;Enviar preguntas de informe de siembra&quot;,&quot;templateTransition&quot;:&quot;main/updateissueproperties&quot;,&quot;idTransition&quot;:&quot;149&quot;},{&quot;connectionId&quot;:&quot;con_241&quot;,&quot;pageSourceId&quot;:&quot;step_94&quot;,&quot;pageTargetId&quot;:&quot;step_87&quot;,&quot;nameTransition&quot;:&quot;Enviar preguntas a solicitante&quot;,&quot;templateTransition&quot;:&quot;main/updateissueproperties&quot;,&quot;idTransition&quot;:&quot;150&quot;},{&quot;connectionId&quot;:&quot;con_247&quot;,&quot;pageSourceId&quot;:&quot;step_92&quot;,&quot;pageTargetId&quot;:&quot;step_89&quot;,&quot;nameTransition&quot;:&quot;Información completa&quot;,&quot;templateTransition&quot;:&quot;&quot;,&quot;idTransition&quot;:&quot;151&quot;},{&quot;connectionId&quot;:&quot;con_253&quot;,&quot;pageSourceId&quot;:&quot;step_93&quot;,&quot;pageTargetId&quot;:&quot;step_95&quot;,&quot;nameTransition&quot;:&quot;Enviar preguntas de informe parcial&quot;,&quot;templateTransition&quot;:&quot;main/updateissueproperties&quot;,&quot;idTransition&quot;:&quot;152&quot;},{&quot;connectionId&quot;:&quot;con_259&quot;,&quot;pageSourceId&quot;:&quot;step_95&quot;,&quot;pageTargetId&quot;:&quot;step_96&quot;,&quot;nameTransition&quot;:&quot;Enviar preguntas a solicitante&quot;,&quot;templateTransition&quot;:&quot;&quot;,&quot;idTransition&quot;:&quot;153&quot;},{&quot;connectionId&quot;:&quot;con_265&quot;,&quot;pageSourceId&quot;:&quot;step_96&quot;,&quot;pageTargetId&quot;:&quot;step_97&quot;,&quot;nameTransition&quot;:&quot;Enviar información complementaria&quot;,&quot;templateTransition&quot;:&quot;main/updateissueproperties&quot;,&quot;idTransition&quot;:&quot;154&quot;},{&quot;connectionId&quot;:&quot;con_271&quot;,&quot;pageSourceId&quot;:&quot;step_97&quot;,&quot;pageTargetId&quot;:&quot;step_98&quot;,&quot;nameTransition&quot;:&quot;Enviar información a técnicos&quot;,&quot;templateTransition&quot;:&quot;&quot;,&quot;idTransition&quot;:&quot;155&quot;},{&quot;connectionId&quot;:&quot;con_277&quot;,&quot;pageSourceId&quot;:&quot;step_98&quot;,&quot;pageTargetId&quot;:&quot;step_93&quot;,&quot;nameTransition&quot;:&quot;Generar nuevas preguntas&quot;,&quot;templateTransition&quot;:&quot;&quot;,&quot;idTransition&quot;:&quot;156&quot;},{&quot;connectionId&quot;:&quot;con_283&quot;,&quot;pageSourceId&quot;:&quot;step_98&quot;,&quot;pageTargetId&quot;:&quot;step_99&quot;,&quot;nameTransition&quot;:&quot;Información completa&quot;,&quot;templateTransition&quot;:&quot;&quot;,&quot;idTransition&quot;:&quot;157&quot;},{&quot;connectionId&quot;:&quot;con_289&quot;,&quot;pageSourceId&quot;:&quot;step_99&quot;,&quot;pageTargetId&quot;:&quot;step_100&quot;,&quot;nameTransition&quot;:&quot;Enviar informe de cierre&quot;,&quot;templateTransition&quot;:&quot;&quot;,&quot;idTransition&quot;:&quot;158&quot;},{&quot;connectionId&quot;:&quot;con_295&quot;,&quot;pageSourceId&quot;:&quot;step_100&quot;,&quot;pageTargetId&quot;:&quot;step_101&quot;,&quot;nameTransition&quot;:&quot;Enviar informe de cierre a técnicos&quot;,&quot;templateTransition&quot;:&quot;&quot;,&quot;idTransition&quot;:&quot;159&quot;},{&quot;connectionId&quot;:&quot;con_301&quot;,&quot;pageSourceId&quot;:&quot;step_101&quot;,&quot;pageTargetId&quot;:&quot;step_102&quot;,&quot;nameTransition&quot;:&quot;Enviar preguntas de informe de cierre&quot;,&quot;templateTransition&quot;:&quot;main/updateissueproperties&quot;,&quot;idTransition&quot;:&quot;160&quot;},{&quot;connectionId&quot;:&quot;con_307&quot;,&quot;pageSourceId&quot;:&quot;step_102&quot;,&quot;pageTargetId&quot;:&quot;step_103&quot;,&quot;nameTransition&quot;:&quot;Enviar preguntas al solicitante&quot;,&quot;templateTransition&quot;:&quot;&quot;,&quot;idTransition&quot;:&quot;161&quot;},{&quot;connectionId&quot;:&quot;con_313&quot;,&quot;pageSourceId&quot;:&quot;step_103&quot;,&quot;pageTargetId&quot;:&quot;step_104&quot;,&quot;nameTransition&quot;:&quot;Enviar información complementaria&quot;,&quot;templateTransition&quot;:&quot;main/updateissueproperties&quot;,&quot;idTransition&quot;:&quot;162&quot;},{&quot;connectionId&quot;:&quot;con_319&quot;,&quot;pageSourceId&quot;:&quot;step_104&quot;,&quot;pageTargetId&quot;:&quot;step_105&quot;,&quot;nameTransition&quot;:&quot;Enviar respuesta a técnicos&quot;,&quot;templateTransition&quot;:&quot;&quot;,&quot;idTransition&quot;:&quot;163&quot;},{&quot;connectionId&quot;:&quot;con_325&quot;,&quot;pageSourceId&quot;:&quot;step_105&quot;,&quot;pageTargetId&quot;:&quot;step_101&quot;,&quot;nameTransition&quot;:&quot;Generar nuevas preguntas&quot;,&quot;templateTransition&quot;:&quot;&quot;,&quot;idTransition&quot;:&quot;164&quot;},{&quot;connectionId&quot;:&quot;con_331&quot;,&quot;pageSourceId&quot;:&quot;step_101&quot;,&quot;pageTargetId&quot;:&quot;step_106&quot;,&quot;nameTransition&quot;:&quot;Enviar a evaluar&quot;,&quot;templateTransition&quot;:&quot;main/updateissueproperties&quot;,&quot;idTransition&quot;:&quot;165&quot;},{&quot;connectionId&quot;:&quot;con_337&quot;,&quot;pageSourceId&quot;:&quot;step_106&quot;,&quot;pageTargetId&quot;:&quot;step_107&quot;,&quot;nameTransition&quot;:&quot;Generar Cierre&quot;,&quot;templateTransition&quot;:&quot;&quot;,&quot;idTransition&quot;:&quot;166&quot;}],&quot;numberOfElements&quot;:33}'),('Forestal','',1,168,2,11,'{&quot;nodes&quot;:[{&quot;blockId&quot;:&quot;startpoint&quot;,&quot;nodetype&quot;:&quot;startpoint&quot;,&quot;positionX&quot;:0,&quot;positionY&quot;:0,&quot;inputValue&quot;:&quot;&quot;,&quot;inputStepId&quot;:&quot;&quot;,&quot;_input_state&quot;:&quot;&quot;,&quot;_input_is_editable&quot;:&quot;&quot;,&quot;_input_status_id&quot;:&quot;&quot;},{&quot;blockId&quot;:&quot;endpoint&quot;,&quot;nodetype&quot;:&quot;endpoint&quot;,&quot;positionX&quot;:0,&quot;positionY&quot;:0,&quot;inputValue&quot;:&quot;&quot;,&quot;inputStepId&quot;:&quot;&quot;,&quot;_input_state&quot;:&quot;&quot;,&quot;_input_is_editable&quot;:&quot;&quot;,&quot;_input_status_id&quot;:&quot;&quot;},{&quot;blockId&quot;:&quot;step_110&quot;,&quot;nodetype&quot;:&quot;task&quot;,&quot;positionX&quot;:-1313,&quot;positionY&quot;:-336,&quot;inputValue&quot;:&quot;Ingresando Proceso&quot;,&quot;inputStepId&quot;:&quot;110&quot;,&quot;_input_state&quot;:&quot;0&quot;,&quot;_input_is_editable&quot;:&quot;0&quot;,&quot;_input_status_id&quot;:&quot;0&quot;},{&quot;blockId&quot;:&quot;step_111&quot;,&quot;nodetype&quot;:&quot;task&quot;,&quot;positionX&quot;:-1356,&quot;positionY&quot;:42,&quot;inputValue&quot;:&quot;Analizando Solicitud&quot;,&quot;inputStepId&quot;:&quot;111&quot;,&quot;_input_state&quot;:&quot;0&quot;,&quot;_input_is_editable&quot;:&quot;1&quot;,&quot;_input_status_id&quot;:&quot;0&quot;},{&quot;blockId&quot;:&quot;step_112&quot;,&quot;nodetype&quot;:&quot;task&quot;,&quot;positionX&quot;:-984,&quot;positionY&quot;:-337,&quot;inputValue&quot;:&quot;Re Ingresando Información&quot;,&quot;inputStepId&quot;:&quot;112&quot;,&quot;_input_state&quot;:&quot;0&quot;,&quot;_input_is_editable&quot;:&quot;1&quot;,&quot;_input_status_id&quot;:&quot;0&quot;},{&quot;blockId&quot;:&quot;step_113&quot;,&quot;nodetype&quot;:&quot;task&quot;,&quot;positionX&quot;:-1054,&quot;positionY&quot;:41,&quot;inputValue&quot;:&quot;Realizando Evaluación Preliminar&quot;,&quot;inputStepId&quot;:&quot;113&quot;,&quot;_input_state&quot;:&quot;0&quot;,&quot;_input_is_editable&quot;:&quot;1&quot;,&quot;_input_status_id&quot;:&quot;0&quot;},{&quot;blockId&quot;:&quot;step_114&quot;,&quot;nodetype&quot;:&quot;task&quot;,&quot;positionX&quot;:-660,&quot;positionY&quot;:-335,&quot;inputValue&quot;:&quot;Haciendo Correcciones&quot;,&quot;inputStepId&quot;:&quot;114&quot;,&quot;_input_state&quot;:&quot;0&quot;,&quot;_input_is_editable&quot;:&quot;1&quot;,&quot;_input_status_id&quot;:&quot;0&quot;},{&quot;blockId&quot;:&quot;step_115&quot;,&quot;nodetype&quot;:&quot;task&quot;,&quot;positionX&quot;:-730,&quot;positionY&quot;:36,&quot;inputValue&quot;:&quot;Recibiendo Correcciones&quot;,&quot;inputStepId&quot;:&quot;115&quot;,&quot;_input_state&quot;:&quot;0&quot;,&quot;_input_is_editable&quot;:&quot;1&quot;,&quot;_input_status_id&quot;:&quot;0&quot;},{&quot;blockId&quot;:&quot;step_116&quot;,&quot;nodetype&quot;:&quot;task&quot;,&quot;positionX&quot;:-416,&quot;positionY&quot;:33,&quot;inputValue&quot;:&quot;Generando Feedback&quot;,&quot;inputStepId&quot;:&quot;116&quot;,&quot;_input_state&quot;:&quot;0&quot;,&quot;_input_is_editable&quot;:&quot;1&quot;,&quot;_input_status_id&quot;:&quot;0&quot;},{&quot;blockId&quot;:&quot;step_117&quot;,&quot;nodetype&quot;:&quot;task&quot;,&quot;positionX&quot;:-68,&quot;positionY&quot;:-265,&quot;inputValue&quot;:&quot;Generando Certificado de Obra&quot;,&quot;inputStepId&quot;:&quot;117&quot;,&quot;_input_state&quot;:&quot;0&quot;,&quot;_input_is_editable&quot;:&quot;1&quot;,&quot;_input_status_id&quot;:&quot;0&quot;},{&quot;blockId&quot;:&quot;step_118&quot;,&quot;nodetype&quot;:&quot;task&quot;,&quot;positionX&quot;:340,&quot;positionY&quot;:-266,&quot;inputValue&quot;:&quot;Haciendo Correcciones&quot;,&quot;inputStepId&quot;:&quot;118&quot;,&quot;_input_state&quot;:&quot;0&quot;,&quot;_input_is_editable&quot;:&quot;1&quot;,&quot;_input_status_id&quot;:&quot;0&quot;},{&quot;blockId&quot;:&quot;step_119&quot;,&quot;nodetype&quot;:&quot;task&quot;,&quot;positionX&quot;:-977,&quot;positionY&quot;:457,&quot;inputValue&quot;:&quot;Analizando ANEXO iii&quot;,&quot;inputStepId&quot;:&quot;119&quot;,&quot;_input_state&quot;:&quot;0&quot;,&quot;_input_is_editable&quot;:&quot;1&quot;,&quot;_input_status_id&quot;:&quot;0&quot;},{&quot;blockId&quot;:&quot;step_120&quot;,&quot;nodetype&quot;:&quot;task&quot;,&quot;positionX&quot;:-500,&quot;positionY&quot;:478,&quot;inputValue&quot;:&quot;Recibiendo Respuestas&quot;,&quot;inputStepId&quot;:&quot;120&quot;,&quot;_input_state&quot;:&quot;0&quot;,&quot;_input_is_editable&quot;:&quot;1&quot;,&quot;_input_status_id&quot;:&quot;0&quot;},{&quot;blockId&quot;:&quot;step_121&quot;,&quot;nodetype&quot;:&quot;task&quot;,&quot;positionX&quot;:-1295,&quot;positionY&quot;:482,&quot;inputValue&quot;:&quot;Analizando LEgal&quot;,&quot;inputStepId&quot;:&quot;121&quot;,&quot;_input_state&quot;:&quot;0&quot;,&quot;_input_is_editable&quot;:&quot;1&quot;,&quot;_input_status_id&quot;:&quot;0&quot;},{&quot;blockId&quot;:&quot;step_122&quot;,&quot;nodetype&quot;:&quot;task&quot;,&quot;positionX&quot;:-1260,&quot;positionY&quot;:794,&quot;inputValue&quot;:&quot;Recibiendo Observaciones Legales&quot;,&quot;inputStepId&quot;:&quot;122&quot;,&quot;_input_state&quot;:&quot;0&quot;,&quot;_input_is_editable&quot;:&quot;1&quot;,&quot;_input_status_id&quot;:&quot;0&quot;},{&quot;blockId&quot;:&quot;step_123&quot;,&quot;nodetype&quot;:&quot;task&quot;,&quot;positionX&quot;:-877,&quot;positionY&quot;:784,&quot;inputValue&quot;:&quot;Realizando Adelanto&quot;,&quot;inputStepId&quot;:&quot;123&quot;,&quot;_input_state&quot;:&quot;0&quot;,&quot;_input_is_editable&quot;:&quot;1&quot;,&quot;_input_status_id&quot;:&quot;0&quot;},{&quot;blockId&quot;:&quot;step_124&quot;,&quot;nodetype&quot;:&quot;task&quot;,&quot;positionX&quot;:-545,&quot;positionY&quot;:786,&quot;inputValue&quot;:&quot;Recibiendo Observación Liquidación&quot;,&quot;inputStepId&quot;:&quot;124&quot;,&quot;_input_state&quot;:&quot;0&quot;,&quot;_input_is_editable&quot;:&quot;1&quot;,&quot;_input_status_id&quot;:&quot;0&quot;},{&quot;blockId&quot;:&quot;step_125&quot;,&quot;nodetype&quot;:&quot;task&quot;,&quot;positionX&quot;:84,&quot;positionY&quot;:73,&quot;inputValue&quot;:&quot;Analizando Certificado de Obra&quot;,&quot;inputStepId&quot;:&quot;125&quot;,&quot;_input_state&quot;:&quot;0&quot;,&quot;_input_is_editable&quot;:&quot;1&quot;,&quot;_input_status_id&quot;:&quot;0&quot;},{&quot;blockId&quot;:&quot;step_126&quot;,&quot;nodetype&quot;:&quot;task&quot;,&quot;positionX&quot;:401,&quot;positionY&quot;:71,&quot;inputValue&quot;:&quot;Recibiendo Correcciones&quot;,&quot;inputStepId&quot;:&quot;126&quot;,&quot;_input_state&quot;:&quot;0&quot;,&quot;_input_is_editable&quot;:&quot;1&quot;,&quot;_input_status_id&quot;:&quot;0&quot;},{&quot;blockId&quot;:&quot;step_127&quot;,&quot;nodetype&quot;:&quot;task&quot;,&quot;positionX&quot;:-55,&quot;positionY&quot;:353,&quot;inputValue&quot;:&quot;Realizando Inspección&quot;,&quot;inputStepId&quot;:&quot;127&quot;,&quot;_input_state&quot;:&quot;0&quot;,&quot;_input_is_editable&quot;:&quot;1&quot;,&quot;_input_status_id&quot;:&quot;0&quot;},{&quot;blockId&quot;:&quot;step_128&quot;,&quot;nodetype&quot;:&quot;task&quot;,&quot;positionX&quot;:143,&quot;positionY&quot;:776,&quot;inputValue&quot;:&quot;Analizando Legal&quot;,&quot;inputStepId&quot;:&quot;128&quot;,&quot;_input_state&quot;:&quot;0&quot;,&quot;_input_is_editable&quot;:&quot;1&quot;,&quot;_input_status_id&quot;:&quot;0&quot;},{&quot;blockId&quot;:&quot;step_129&quot;,&quot;nodetype&quot;:&quot;task&quot;,&quot;positionX&quot;:-234,&quot;positionY&quot;:780,&quot;inputValue&quot;:&quot;Analizando Observaciones&quot;,&quot;inputStepId&quot;:&quot;129&quot;,&quot;_input_state&quot;:&quot;0&quot;,&quot;_input_is_editable&quot;:&quot;1&quot;,&quot;_input_status_id&quot;:&quot;0&quot;},{&quot;blockId&quot;:&quot;step_130&quot;,&quot;nodetype&quot;:&quot;task&quot;,&quot;positionX&quot;:932,&quot;positionY&quot;:-257,&quot;inputValue&quot;:&quot;Haciendo Correcciones&quot;,&quot;inputStepId&quot;:&quot;130&quot;,&quot;_input_state&quot;:&quot;0&quot;,&quot;_input_is_editable&quot;:&quot;1&quot;,&quot;_input_status_id&quot;:&quot;0&quot;},{&quot;blockId&quot;:&quot;step_131&quot;,&quot;nodetype&quot;:&quot;task&quot;,&quot;positionX&quot;:719,&quot;positionY&quot;:75,&quot;inputValue&quot;:&quot;Recibiendo Preguntas&quot;,&quot;inputStepId&quot;:&quot;131&quot;,&quot;_input_state&quot;:&quot;0&quot;,&quot;_input_is_editable&quot;:&quot;1&quot;,&quot;_input_status_id&quot;:&quot;0&quot;},{&quot;blockId&quot;:&quot;step_132&quot;,&quot;nodetype&quot;:&quot;task&quot;,&quot;positionX&quot;:357,&quot;positionY&quot;:406,&quot;inputValue&quot;:&quot;Analizando Respuestas&quot;,&quot;inputStepId&quot;:&quot;132&quot;,&quot;_input_state&quot;:&quot;0&quot;,&quot;_input_is_editable&quot;:&quot;1&quot;,&quot;_input_status_id&quot;:&quot;0&quot;},{&quot;blockId&quot;:&quot;step_133&quot;,&quot;nodetype&quot;:&quot;task&quot;,&quot;positionX&quot;:542,&quot;positionY&quot;:803,&quot;inputValue&quot;:&quot;Analizando Plan&quot;,&quot;inputStepId&quot;:&quot;133&quot;,&quot;_input_state&quot;:&quot;0&quot;,&quot;_input_is_editable&quot;:&quot;1&quot;,&quot;_input_status_id&quot;:&quot;0&quot;},{&quot;blockId&quot;:&quot;step_134&quot;,&quot;nodetype&quot;:&quot;task&quot;,&quot;positionX&quot;:909,&quot;positionY&quot;:390,&quot;inputValue&quot;:&quot;Recibiendo Correcciones&quot;,&quot;inputStepId&quot;:&quot;134&quot;,&quot;_input_state&quot;:&quot;0&quot;,&quot;_input_is_editable&quot;:&quot;1&quot;,&quot;_input_status_id&quot;:&quot;0&quot;},{&quot;blockId&quot;:&quot;step_135&quot;,&quot;nodetype&quot;:&quot;task&quot;,&quot;positionX&quot;:1150,&quot;positionY&quot;:528,&quot;inputValue&quot;:&quot;Reinspeccionando&quot;,&quot;inputStepId&quot;:&quot;135&quot;,&quot;_input_state&quot;:&quot;0&quot;,&quot;_input_is_editable&quot;:&quot;1&quot;,&quot;_input_status_id&quot;:&quot;0&quot;},{&quot;blockId&quot;:&quot;step_136&quot;,&quot;nodetype&quot;:&quot;task&quot;,&quot;positionX&quot;:1100,&quot;positionY&quot;:877,&quot;inputValue&quot;:&quot;Análisis Técnico&quot;,&quot;inputStepId&quot;:&quot;136&quot;,&quot;_input_state&quot;:&quot;0&quot;,&quot;_input_is_editable&quot;:&quot;1&quot;,&quot;_input_status_id&quot;:&quot;0&quot;},{&quot;blockId&quot;:&quot;step_137&quot;,&quot;nodetype&quot;:&quot;task&quot;,&quot;positionX&quot;:1462,&quot;positionY&quot;:266,&quot;inputValue&quot;:&quot;Análisis Técnico&quot;,&quot;inputStepId&quot;:&quot;137&quot;,&quot;_input_state&quot;:&quot;0&quot;,&quot;_input_is_editable&quot;:&quot;1&quot;,&quot;_input_status_id&quot;:&quot;0&quot;},{&quot;blockId&quot;:&quot;step_138&quot;,&quot;nodetype&quot;:&quot;task&quot;,&quot;positionX&quot;:1848,&quot;positionY&quot;:475,&quot;inputValue&quot;:&quot;Liquidaciones&quot;,&quot;inputStepId&quot;:&quot;138&quot;,&quot;_input_state&quot;:&quot;0&quot;,&quot;_input_is_editable&quot;:&quot;1&quot;,&quot;_input_status_id&quot;:&quot;0&quot;},{&quot;blockId&quot;:&quot;step_139&quot;,&quot;nodetype&quot;:&quot;task&quot;,&quot;positionX&quot;:2251,&quot;positionY&quot;:465,&quot;inputValue&quot;:&quot;Evaluando Pagos&quot;,&quot;inputStepId&quot;:&quot;139&quot;,&quot;_input_state&quot;:&quot;0&quot;,&quot;_input_is_editable&quot;:&quot;1&quot;,&quot;_input_status_id&quot;:&quot;0&quot;},{&quot;blockId&quot;:&quot;step_140&quot;,&quot;nodetype&quot;:&quot;task&quot;,&quot;positionX&quot;:1779,&quot;positionY&quot;:914,&quot;inputValue&quot;:&quot;Analizando Técnicos&quot;,&quot;inputStepId&quot;:&quot;140&quot;,&quot;_input_state&quot;:&quot;0&quot;,&quot;_input_is_editable&quot;:&quot;1&quot;,&quot;_input_status_id&quot;:&quot;0&quot;},{&quot;blockId&quot;:&quot;step_141&quot;,&quot;nodetype&quot;:&quot;task&quot;,&quot;positionX&quot;:2267,&quot;positionY&quot;:816,&quot;inputValue&quot;:&quot;Analizando Legales&quot;,&quot;inputStepId&quot;:&quot;141&quot;,&quot;_input_state&quot;:&quot;0&quot;,&quot;_input_is_editable&quot;:&quot;1&quot;,&quot;_input_status_id&quot;:&quot;0&quot;}],&quot;connections&quot;:[{&quot;connectionId&quot;:&quot;con_133&quot;,&quot;pageSourceId&quot;:&quot;step_110&quot;,&quot;pageTargetId&quot;:&quot;step_111&quot;,&quot;nameTransition&quot;:&quot;Enviar a Provincia&quot;,&quot;templateTransition&quot;:&quot;main/updateissueproperties&quot;,&quot;idTransition&quot;:&quot;169&quot;},{&quot;connectionId&quot;:&quot;con_139&quot;,&quot;pageSourceId&quot;:&quot;step_111&quot;,&quot;pageTargetId&quot;:&quot;step_112&quot;,&quot;nameTransition&quot;:&quot;Modificar Información&quot;,&quot;templateTransition&quot;:&quot;main/updateissueproperties&quot;,&quot;idTransition&quot;:&quot;170&quot;},{&quot;connectionId&quot;:&quot;con_145&quot;,&quot;pageSourceId&quot;:&quot;step_112&quot;,&quot;pageTargetId&quot;:&quot;step_111&quot;,&quot;nameTransition&quot;:&quot;Re enviar Información&quot;,&quot;templateTransition&quot;:&quot;main/updateissueproperties&quot;,&quot;idTransition&quot;:&quot;172&quot;},{&quot;connectionId&quot;:&quot;con_151&quot;,&quot;pageSourceId&quot;:&quot;step_111&quot;,&quot;pageTargetId&quot;:&quot;step_113&quot;,&quot;nameTransition&quot;:&quot;Hacer Evaluación Preliminar&quot;,&quot;templateTransition&quot;:&quot;main/updateissueproperties&quot;,&quot;idTransition&quot;:&quot;173&quot;},{&quot;connectionId&quot;:&quot;con_157&quot;,&quot;pageSourceId&quot;:&quot;step_113&quot;,&quot;pageTargetId&quot;:&quot;step_114&quot;,&quot;nameTransition&quot;:&quot;Enviar Motivo de Observación&quot;,&quot;templateTransition&quot;:&quot;main/updateissueproperties&quot;,&quot;idTransition&quot;:&quot;174&quot;},{&quot;connectionId&quot;:&quot;con_163&quot;,&quot;pageSourceId&quot;:&quot;step_114&quot;,&quot;pageTargetId&quot;:&quot;step_115&quot;,&quot;nameTransition&quot;:&quot;Enviar Correcciones&quot;,&quot;templateTransition&quot;:&quot;main/updateissueproperties&quot;,&quot;idTransition&quot;:&quot;175&quot;},{&quot;connectionId&quot;:&quot;con_169&quot;,&quot;pageSourceId&quot;:&quot;step_115&quot;,&quot;pageTargetId&quot;:&quot;step_113&quot;,&quot;nameTransition&quot;:&quot;Realizar Evaluación&quot;,&quot;templateTransition&quot;:&quot;main/updateissueproperties&quot;,&quot;idTransition&quot;:&quot;176&quot;},{&quot;connectionId&quot;:&quot;con_175&quot;,&quot;pageSourceId&quot;:&quot;step_113&quot;,&quot;pageTargetId&quot;:&quot;step_119&quot;,&quot;nameTransition&quot;:&quot;Enviar a Nación&quot;,&quot;templateTransition&quot;:&quot;main/updateissueproperties&quot;,&quot;idTransition&quot;:&quot;177&quot;},{&quot;connectionId&quot;:&quot;con_181&quot;,&quot;pageSourceId&quot;:&quot;step_116&quot;,&quot;pageTargetId&quot;:&quot;step_120&quot;,&quot;nameTransition&quot;:&quot;Enviar Respuestas&quot;,&quot;templateTransition&quot;:&quot;main/updateissueproperties&quot;,&quot;idTransition&quot;:&quot;178&quot;},{&quot;connectionId&quot;:&quot;con_187&quot;,&quot;pageSourceId&quot;:&quot;step_123&quot;,&quot;pageTargetId&quot;:&quot;step_124&quot;,&quot;nameTransition&quot;:&quot;Enviar Observaciones&quot;,&quot;templateTransition&quot;:&quot;main/updateissueproperties&quot;,&quot;idTransition&quot;:&quot;179&quot;},{&quot;connectionId&quot;:&quot;con_193&quot;,&quot;pageSourceId&quot;:&quot;step_119&quot;,&quot;pageTargetId&quot;:&quot;step_116&quot;,&quot;nameTransition&quot;:&quot;Realizar Preguntas&quot;,&quot;templateTransition&quot;:&quot;main/updateissueproperties&quot;,&quot;idTransition&quot;:&quot;180&quot;},{&quot;connectionId&quot;:&quot;con_199&quot;,&quot;pageSourceId&quot;:&quot;step_121&quot;,&quot;pageTargetId&quot;:&quot;step_122&quot;,&quot;nameTransition&quot;:&quot;Realizar Observaciones&quot;,&quot;templateTransition&quot;:&quot;main/updateissueproperties&quot;,&quot;idTransition&quot;:&quot;181&quot;},{&quot;connectionId&quot;:&quot;con_205&quot;,&quot;pageSourceId&quot;:&quot;step_120&quot;,&quot;pageTargetId&quot;:&quot;step_119&quot;,&quot;nameTransition&quot;:&quot;Enviar Respuestas&quot;,&quot;templateTransition&quot;:&quot;main/updateissueproperties&quot;,&quot;idTransition&quot;:&quot;182&quot;},{&quot;connectionId&quot;:&quot;con_211&quot;,&quot;pageSourceId&quot;:&quot;step_124&quot;,&quot;pageTargetId&quot;:&quot;step_119&quot;,&quot;nameTransition&quot;:&quot;Realizar Análisis&quot;,&quot;templateTransition&quot;:&quot;main/updateissueproperties&quot;,&quot;idTransition&quot;:&quot;183&quot;},{&quot;connectionId&quot;:&quot;con_217&quot;,&quot;pageSourceId&quot;:&quot;step_122&quot;,&quot;pageTargetId&quot;:&quot;step_119&quot;,&quot;nameTransition&quot;:&quot;Realizar Análisis&quot;,&quot;templateTransition&quot;:&quot;main/updateissueproperties&quot;,&quot;idTransition&quot;:&quot;184&quot;},{&quot;connectionId&quot;:&quot;con_223&quot;,&quot;pageSourceId&quot;:&quot;step_121&quot;,&quot;pageTargetId&quot;:&quot;step_119&quot;,&quot;nameTransition&quot;:&quot;Aprobar Primera Cuota&quot;,&quot;templateTransition&quot;:&quot;main/updateissueproperties&quot;,&quot;idTransition&quot;:&quot;186&quot;},{&quot;connectionId&quot;:&quot;con_229&quot;,&quot;pageSourceId&quot;:&quot;step_119&quot;,&quot;pageTargetId&quot;:&quot;step_123&quot;,&quot;nameTransition&quot;:&quot;Generar Informe de Pago&quot;,&quot;templateTransition&quot;:&quot;main/updateissueproperties&quot;,&quot;idTransition&quot;:&quot;187&quot;},{&quot;connectionId&quot;:&quot;con_235&quot;,&quot;pageSourceId&quot;:&quot;step_119&quot;,&quot;pageTargetId&quot;:&quot;step_117&quot;,&quot;nameTransition&quot;:&quot;Enviar Tránsito&quot;,&quot;templateTransition&quot;:&quot;main/updateissueproperties&quot;,&quot;idTransition&quot;:&quot;188&quot;},{&quot;connectionId&quot;:&quot;con_241&quot;,&quot;pageSourceId&quot;:&quot;step_123&quot;,&quot;pageTargetId&quot;:&quot;step_117&quot;,&quot;nameTransition&quot;:&quot;Enviar Tránsito&quot;,&quot;templateTransition&quot;:&quot;main/updateissueproperties&quot;,&quot;idTransition&quot;:&quot;189&quot;},{&quot;connectionId&quot;:&quot;con_247&quot;,&quot;pageSourceId&quot;:&quot;step_117&quot;,&quot;pageTargetId&quot;:&quot;step_125&quot;,&quot;nameTransition&quot;:&quot;Cargar Certificado de Obra&quot;,&quot;templateTransition&quot;:&quot;main/updateissueproperties&quot;,&quot;idTransition&quot;:&quot;190&quot;},{&quot;connectionId&quot;:&quot;con_253&quot;,&quot;pageSourceId&quot;:&quot;step_125&quot;,&quot;pageTargetId&quot;:&quot;step_127&quot;,&quot;nameTransition&quot;:&quot;Realizar Inspección&quot;,&quot;templateTransition&quot;:&quot;main/updateissueproperties&quot;,&quot;idTransition&quot;:&quot;191&quot;},{&quot;connectionId&quot;:&quot;con_259&quot;,&quot;pageSourceId&quot;:&quot;step_127&quot;,&quot;pageTargetId&quot;:&quot;step_128&quot;,&quot;nameTransition&quot;:&quot;Cargar Informe de Inspección&quot;,&quot;templateTransition&quot;:&quot;main/updateissueproperties&quot;,&quot;idTransition&quot;:&quot;192&quot;},{&quot;connectionId&quot;:&quot;con_265&quot;,&quot;pageSourceId&quot;:&quot;step_128&quot;,&quot;pageTargetId&quot;:&quot;step_129&quot;,&quot;nameTransition&quot;:&quot;Enviar Observaciones&quot;,&quot;templateTransition&quot;:&quot;main/updateissueproperties&quot;,&quot;idTransition&quot;:&quot;193&quot;},{&quot;connectionId&quot;:&quot;con_271&quot;,&quot;pageSourceId&quot;:&quot;step_129&quot;,&quot;pageTargetId&quot;:&quot;step_128&quot;,&quot;nameTransition&quot;:&quot;Enviar Correcciones&quot;,&quot;templateTransition&quot;:&quot;main/updateissueproperties&quot;,&quot;idTransition&quot;:&quot;194&quot;},{&quot;connectionId&quot;:&quot;con_277&quot;,&quot;pageSourceId&quot;:&quot;step_126&quot;,&quot;pageTargetId&quot;:&quot;step_125&quot;,&quot;nameTransition&quot;:&quot;Realizar Evaluación&quot;,&quot;templateTransition&quot;:&quot;main/updateissueproperties&quot;,&quot;idTransition&quot;:&quot;195&quot;},{&quot;connectionId&quot;:&quot;con_283&quot;,&quot;pageSourceId&quot;:&quot;step_118&quot;,&quot;pageTargetId&quot;:&quot;step_126&quot;,&quot;nameTransition&quot;:&quot;Enviar Correcciones&quot;,&quot;templateTransition&quot;:&quot;main/updateissueproperties&quot;,&quot;idTransition&quot;:&quot;196&quot;},{&quot;connectionId&quot;:&quot;con_289&quot;,&quot;pageSourceId&quot;:&quot;step_125&quot;,&quot;pageTargetId&quot;:&quot;step_118&quot;,&quot;nameTransition&quot;:&quot;Enviar Observaciones&quot;,&quot;templateTransition&quot;:&quot;main/updateissueproperties&quot;,&quot;idTransition&quot;:&quot;197&quot;},{&quot;connectionId&quot;:&quot;con_295&quot;,&quot;pageSourceId&quot;:&quot;step_128&quot;,&quot;pageTargetId&quot;:&quot;step_133&quot;,&quot;nameTransition&quot;:&quot;Aprobar Plan&quot;,&quot;templateTransition&quot;:&quot;main/updateissueproperties&quot;,&quot;idTransition&quot;:&quot;198&quot;},{&quot;connectionId&quot;:&quot;con_301&quot;,&quot;pageSourceId&quot;:&quot;step_133&quot;,&quot;pageTargetId&quot;:&quot;step_131&quot;,&quot;nameTransition&quot;:&quot;Enviar Preguntas a Provincia&quot;,&quot;templateTransition&quot;:&quot;main/updateissueproperties&quot;,&quot;idTransition&quot;:&quot;199&quot;},{&quot;connectionId&quot;:&quot;con_307&quot;,&quot;pageSourceId&quot;:&quot;step_131&quot;,&quot;pageTargetId&quot;:&quot;step_132&quot;,&quot;nameTransition&quot;:&quot;Enviar Respuesta&quot;,&quot;templateTransition&quot;:&quot;main/updateissueproperties&quot;,&quot;idTransition&quot;:&quot;200&quot;},{&quot;connectionId&quot;:&quot;con_313&quot;,&quot;pageSourceId&quot;:&quot;step_132&quot;,&quot;pageTargetId&quot;:&quot;step_133&quot;,&quot;nameTransition&quot;:&quot;Enviar a Analizar&quot;,&quot;templateTransition&quot;:&quot;main/updateissueproperties&quot;,&quot;idTransition&quot;:&quot;201&quot;},{&quot;connectionId&quot;:&quot;con_319&quot;,&quot;pageSourceId&quot;:&quot;step_133&quot;,&quot;pageTargetId&quot;:&quot;step_130&quot;,&quot;nameTransition&quot;:&quot;Enviar Preguntas a Solicitante&quot;,&quot;templateTransition&quot;:&quot;main/updateissueproperties&quot;,&quot;idTransition&quot;:&quot;202&quot;},{&quot;connectionId&quot;:&quot;con_325&quot;,&quot;pageSourceId&quot;:&quot;step_130&quot;,&quot;pageTargetId&quot;:&quot;step_134&quot;,&quot;nameTransition&quot;:&quot;Enviar Correcciones&quot;,&quot;templateTransition&quot;:&quot;main/updateissueproperties&quot;,&quot;idTransition&quot;:&quot;203&quot;},{&quot;connectionId&quot;:&quot;con_331&quot;,&quot;pageSourceId&quot;:&quot;step_134&quot;,&quot;pageTargetId&quot;:&quot;step_133&quot;,&quot;nameTransition&quot;:&quot;Enviar a Analizar&quot;,&quot;templateTransition&quot;:&quot;main/updateissueproperties&quot;,&quot;idTransition&quot;:&quot;204&quot;},{&quot;connectionId&quot;:&quot;con_337&quot;,&quot;pageSourceId&quot;:&quot;step_133&quot;,&quot;pageTargetId&quot;:&quot;step_136&quot;,&quot;nameTransition&quot;:&quot;Cargar Informe de Auditoría&quot;,&quot;templateTransition&quot;:&quot;main/updateissueproperties&quot;,&quot;idTransition&quot;:&quot;205&quot;},{&quot;connectionId&quot;:&quot;con_343&quot;,&quot;pageSourceId&quot;:&quot;step_133&quot;,&quot;pageTargetId&quot;:&quot;step_135&quot;,&quot;nameTransition&quot;:&quot;Enviar a Reinspeccionar&quot;,&quot;templateTransition&quot;:&quot;main/updateissueproperties&quot;,&quot;idTransition&quot;:&quot;206&quot;},{&quot;connectionId&quot;:&quot;con_349&quot;,&quot;pageSourceId&quot;:&quot;step_136&quot;,&quot;pageTargetId&quot;:&quot;step_138&quot;,&quot;nameTransition&quot;:&quot;Enviar a Liquidaciones&quot;,&quot;templateTransition&quot;:&quot;main/updateissueproperties&quot;,&quot;idTransition&quot;:&quot;207&quot;},{&quot;connectionId&quot;:&quot;con_355&quot;,&quot;pageSourceId&quot;:&quot;step_137&quot;,&quot;pageTargetId&quot;:&quot;step_138&quot;,&quot;nameTransition&quot;:&quot;Enviar a Liquidaciones&quot;,&quot;templateTransition&quot;:&quot;main/updateissueproperties&quot;,&quot;idTransition&quot;:&quot;208&quot;},{&quot;connectionId&quot;:&quot;con_361&quot;,&quot;pageSourceId&quot;:&quot;step_135&quot;,&quot;pageTargetId&quot;:&quot;step_137&quot;,&quot;nameTransition&quot;:&quot;Cargar Informe Auditoria&quot;,&quot;templateTransition&quot;:&quot;main/updateissueproperties&quot;,&quot;idTransition&quot;:&quot;209&quot;},{&quot;connectionId&quot;:&quot;con_367&quot;,&quot;pageSourceId&quot;:&quot;step_137&quot;,&quot;pageTargetId&quot;:&quot;step_135&quot;,&quot;nameTransition&quot;:&quot;Reinspeccionar&quot;,&quot;templateTransition&quot;:&quot;main/updateissueproperties&quot;,&quot;idTransition&quot;:&quot;210&quot;},{&quot;connectionId&quot;:&quot;con_373&quot;,&quot;pageSourceId&quot;:&quot;step_138&quot;,&quot;pageTargetId&quot;:&quot;step_139&quot;,&quot;nameTransition&quot;:&quot;Iniciar Trámite de Pago&quot;,&quot;templateTransition&quot;:&quot;main/updateissueproperties&quot;,&quot;idTransition&quot;:&quot;211&quot;},{&quot;connectionId&quot;:&quot;con_379&quot;,&quot;pageSourceId&quot;:&quot;step_138&quot;,&quot;pageTargetId&quot;:&quot;step_140&quot;,&quot;nameTransition&quot;:&quot;Hacer Observaciones Técnicas&quot;,&quot;templateTransition&quot;:&quot;main/updateissueproperties&quot;,&quot;idTransition&quot;:&quot;213&quot;},{&quot;connectionId&quot;:&quot;con_385&quot;,&quot;pageSourceId&quot;:&quot;step_138&quot;,&quot;pageTargetId&quot;:&quot;step_141&quot;,&quot;nameTransition&quot;:&quot;Hacer Observaciones Legales&quot;,&quot;templateTransition&quot;:&quot;main/updateissueproperties&quot;,&quot;idTransition&quot;:&quot;214&quot;},{&quot;connectionId&quot;:&quot;con_391&quot;,&quot;pageSourceId&quot;:&quot;step_140&quot;,&quot;pageTargetId&quot;:&quot;step_138&quot;,&quot;nameTransition&quot;:&quot;Responder Observaciones&quot;,&quot;templateTransition&quot;:&quot;main/updateissueproperties&quot;,&quot;idTransition&quot;:&quot;215&quot;},{&quot;connectionId&quot;:&quot;con_397&quot;,&quot;pageSourceId&quot;:&quot;step_141&quot;,&quot;pageTargetId&quot;:&quot;step_138&quot;,&quot;nameTransition&quot;:&quot;Responder Observaciones&quot;,&quot;templateTransition&quot;:&quot;main/updateissueproperties&quot;,&quot;idTransition&quot;:&quot;216&quot;}],&quot;numberOfElements&quot;:33}'),('WF - Trazabilidad ','',1,217,1,12,'{&quot;nodes&quot;:[{&quot;blockId&quot;:&quot;startpoint&quot;,&quot;nodetype&quot;:&quot;startpoint&quot;,&quot;positionX&quot;:0,&quot;positionY&quot;:0,&quot;inputValue&quot;:&quot;&quot;,&quot;inputStepId&quot;:&quot;&quot;,&quot;_input_state&quot;:&quot;&quot;,&quot;_input_is_editable&quot;:&quot;&quot;,&quot;_input_status_id&quot;:&quot;&quot;},{&quot;blockId&quot;:&quot;endpoint&quot;,&quot;nodetype&quot;:&quot;endpoint&quot;,&quot;positionX&quot;:0,&quot;positionY&quot;:0,&quot;inputValue&quot;:&quot;&quot;,&quot;inputStepId&quot;:&quot;&quot;,&quot;_input_state&quot;:&quot;&quot;,&quot;_input_is_editable&quot;:&quot;&quot;,&quot;_input_status_id&quot;:&quot;&quot;},{&quot;blockId&quot;:&quot;step_144&quot;,&quot;nodetype&quot;:&quot;task&quot;,&quot;positionX&quot;:124,&quot;positionY&quot;:50,&quot;inputValue&quot;:&quot;Solicitando Etiquetas&quot;,&quot;inputStepId&quot;:&quot;144&quot;,&quot;_input_state&quot;:&quot;0&quot;,&quot;_input_is_editable&quot;:&quot;1&quot;,&quot;_input_status_id&quot;:&quot;182&quot;},{&quot;blockId&quot;:&quot;step_160&quot;,&quot;nodetype&quot;:&quot;task&quot;,&quot;positionX&quot;:632,&quot;positionY&quot;:306,&quot;inputValue&quot;:&quot;Solicitud Finalizada&quot;,&quot;inputStepId&quot;:&quot;160&quot;,&quot;_input_state&quot;:&quot;1&quot;,&quot;_input_is_editable&quot;:&quot;0&quot;,&quot;_input_status_id&quot;:&quot;189&quot;},{&quot;blockId&quot;:&quot;step_167&quot;,&quot;nodetype&quot;:&quot;task&quot;,&quot;positionX&quot;:131,&quot;positionY&quot;:330,&quot;inputValue&quot;:&quot;Esperando Etiquetas&quot;,&quot;inputStepId&quot;:&quot;167&quot;,&quot;_input_state&quot;:&quot;0&quot;,&quot;_input_is_editable&quot;:&quot;1&quot;,&quot;_input_status_id&quot;:&quot;182&quot;}],&quot;connections&quot;:[{&quot;connectionId&quot;:&quot;con_17&quot;,&quot;pageSourceId&quot;:&quot;step_144&quot;,&quot;pageTargetId&quot;:&quot;step_167&quot;,&quot;nameTransition&quot;:&quot;Pendiente de Entrega&quot;,&quot;templateTransition&quot;:&quot;&quot;,&quot;idTransition&quot;:&quot;245&quot;},{&quot;connectionId&quot;:&quot;con_23&quot;,&quot;pageSourceId&quot;:&quot;step_167&quot;,&quot;pageTargetId&quot;:&quot;step_160&quot;,&quot;nameTransition&quot;:&quot;Solicitud Finalizada&quot;,&quot;templateTransition&quot;:&quot;&quot;,&quot;idTransition&quot;:&quot;246&quot;}],&quot;numberOfElements&quot;:12}'),('Trazabilidad Baja Etiquetas','',1,234,1,13,'{&quot;nodes&quot;:[{&quot;blockId&quot;:&quot;startpoint&quot;,&quot;nodetype&quot;:&quot;startpoint&quot;,&quot;positionX&quot;:0,&quot;positionY&quot;:0,&quot;inputValue&quot;:&quot;&quot;,&quot;inputStepId&quot;:&quot;&quot;,&quot;_input_state&quot;:&quot;&quot;,&quot;_input_is_editable&quot;:&quot;&quot;,&quot;_input_status_id&quot;:&quot;&quot;},{&quot;blockId&quot;:&quot;endpoint&quot;,&quot;nodetype&quot;:&quot;endpoint&quot;,&quot;positionX&quot;:0,&quot;positionY&quot;:0,&quot;inputValue&quot;:&quot;&quot;,&quot;inputStepId&quot;:&quot;&quot;,&quot;_input_state&quot;:&quot;&quot;,&quot;_input_is_editable&quot;:&quot;&quot;,&quot;_input_status_id&quot;:&quot;&quot;},{&quot;blockId&quot;:&quot;step_153&quot;,&quot;nodetype&quot;:&quot;task&quot;,&quot;positionX&quot;:37,&quot;positionY&quot;:-20,&quot;inputValue&quot;:&quot;Generar Baja Etiquetas&quot;,&quot;inputStepId&quot;:&quot;153&quot;,&quot;_input_state&quot;:&quot;0&quot;,&quot;_input_is_editable&quot;:&quot;1&quot;,&quot;_input_status_id&quot;:&quot;186&quot;},{&quot;blockId&quot;:&quot;step_154&quot;,&quot;nodetype&quot;:&quot;task&quot;,&quot;positionX&quot;:38,&quot;positionY&quot;:282,&quot;inputValue&quot;:&quot;Baja Realizada&quot;,&quot;inputStepId&quot;:&quot;154&quot;,&quot;_input_state&quot;:&quot;1&quot;,&quot;_input_is_editable&quot;:&quot;0&quot;,&quot;_input_status_id&quot;:&quot;189&quot;}],&quot;connections&quot;:[{&quot;connectionId&quot;:&quot;con_13&quot;,&quot;pageSourceId&quot;:&quot;step_153&quot;,&quot;pageTargetId&quot;:&quot;step_154&quot;,&quot;nameTransition&quot;:&quot;Generar Baja&quot;,&quot;templateTransition&quot;:&quot;&quot;,&quot;idTransition&quot;:&quot;228&quot;}],&quot;numberOfElements&quot;:2}'),('Copiar de WF - Trazabilidad (con aprobación y rechazo)','',1,242,1,14,''),('Copiar de Trazabilidad Baja Etiquetas','',1,251,1,15,'');

--
-- Temporary table structure for view `v_reporte`
--

/*!50001 DROP VIEW IF EXISTS `v_reporte`*/;
/*!50001 CREATE VIEW `v_reporte` AS SELECT 
 1 AS `Nombre_Adquisicion`,
 1 AS `provincia`,
 1 AS `categoriaGasto`,
 1 AS `categoria_estado`,
 1 AS `estado`,
 1 AS `fechaFirma`,
 1 AS `fecha_fin_obra`,
 1 AS `codigoHabilitado`,
 1 AS `codigoSolicitud`,
 1 AS `programa`,
 1 AS `MetodoContratación`*/;

--
-- Final view structure for view `v_reporte`
--

/*!50001 DROP VIEW IF EXISTS `v_reporte`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`%` SQL SECURITY DEFINER */
/*!50001 VIEW `v_reporte` AS select `i`.`name` AS `Nombre_Adquisicion`,(select `cfo_prov`.`name` from (((`tbg_issues` `i_prov` join `tbg_issuecustomfields` `icf_prov` on((`icf_prov`.`issue_id` = `i_prov`.`id`))) join `tbg_customfields` `cf_prov` on((`cf_prov`.`id` = `icf_prov`.`customfields_id`))) join `tbg_customfieldoptions` `cfo_prov` on((`cfo_prov`.`id` = `icf_prov`.`customfieldoption_id`))) where ((`icf_prov`.`customfields_id` = '22') and (`i_prov`.`deleted` = 0) and (`i_prov`.`id` = `i`.`id`))) AS `provincia`,(select `cfo_catgas`.`name` from (((`tbg_issues` `i_catgas` join `tbg_issuecustomfields` `icf_catgas` on((`icf_catgas`.`issue_id` = `i_catgas`.`id`))) join `tbg_customfields` `cf_catgas` on((`cf_catgas`.`id` = `icf_catgas`.`customfields_id`))) join `tbg_customfieldoptions` `cfo_catgas` on((`cfo_catgas`.`id` = `icf_catgas`.`customfieldoption_id`))) where ((`icf_catgas`.`customfields_id` = '19') and (`i_catgas`.`deleted` = 0) and (`i_catgas`.`id` = `i`.`id`))) AS `categoriaGasto`,(select `cfo_catest`.`name` from (((`tbg_issues` `i_catest` join `tbg_issuecustomfields` `icf_catest` on((`icf_catest`.`issue_id` = `i_catest`.`id`))) join `tbg_customfields` `cf_catest` on((`cf_catest`.`id` = `icf_catest`.`customfields_id`))) join `tbg_customfieldoptions` `cfo_catest` on((`cfo_catest`.`id` = `icf_catest`.`customfieldoption_id`))) where ((`icf_catest`.`customfields_id` = '19') and (`i_catest`.`deleted` = 0) and (`i_catest`.`id` = `i`.`id`))) AS `categoria_estado`,(select `lt_estado`.`name` from (`tbg_issues` `i_estado` join `tbg_listtypes` `lt_estado` on((`lt_estado`.`id` = `i_estado`.`status`))) where ((`i_estado`.`deleted` = 0) and (`i_estado`.`id` = `i`.`id`))) AS `estado`,(select `icf_ff`.`option_value` from ((`tbg_issues` `i_ff` join `tbg_issuecustomfields` `icf_ff` on((`icf_ff`.`issue_id` = `i_ff`.`id`))) join `tbg_customfields` `cf_ff` on((`cf_ff`.`id` = `icf_ff`.`customfields_id`))) where ((`icf_ff`.`customfields_id` = '57') and (`i_ff`.`deleted` = 0) and (`i_ff`.`id` = `i`.`id`))) AS `fechaFirma`,(select `icf_ffo`.`option_value` from ((`tbg_issues` `i_ffo` join `tbg_issuecustomfields` `icf_ffo` on((`icf_ffo`.`issue_id` = `i_ffo`.`id`))) join `tbg_customfields` `cf_ffo` on((`cf_ffo`.`id` = `icf_ffo`.`customfields_id`))) where ((`icf_ffo`.`customfields_id` = '87') and (`i_ffo`.`deleted` = 0) and (`i_ffo`.`id` = `i`.`id`))) AS `fecha_fin_obra`,(select `icf_ch`.`option_value` from ((`tbg_issues` `i_ch` join `tbg_issuecustomfields` `icf_ch` on((`icf_ch`.`issue_id` = `i_ch`.`id`))) join `tbg_customfields` `cf_ch` on((`cf_ch`.`id` = `icf_ch`.`customfields_id`))) where ((`icf_ch`.`customfields_id` = '102') and (`i_ch`.`deleted` = 0) and (`i_ch`.`id` = `i`.`id`))) AS `codigoHabilitado`,(select `icf_cs`.`option_value` from ((`tbg_issues` `i_cs` join `tbg_issuecustomfields` `icf_cs` on((`icf_cs`.`issue_id` = `i_cs`.`id`))) join `tbg_customfields` `cf_cs` on((`cf_cs`.`id` = `icf_cs`.`customfields_id`))) where ((`icf_cs`.`customfields_id` = '96') and (`i_cs`.`deleted` = 0) and (`i_cs`.`id` = `i`.`id`))) AS `codigoSolicitud`,(select `cfo_programa`.`name` from (((`tbg_issues` `i_programa` join `tbg_issuecustomfields` `icf_programa` on((`icf_programa`.`issue_id` = `i_programa`.`id`))) join `tbg_customfields` `cf_programa` on((`cf_programa`.`id` = `icf_programa`.`customfields_id`))) join `tbg_customfieldoptions` `cfo_programa` on((`cfo_programa`.`id` = `icf_programa`.`customfieldoption_id`))) where ((`icf_programa`.`customfields_id` = '99') and (`i_programa`.`deleted` = 0) and (`i_programa`.`id` = `i`.`id`))) AS `programa`,(select `it_mc`.`name` from (`tbg_issues` `i_mc` join `tbg_issuetypes` `it_mc` on((`it_mc`.`id` = `i_mc`.`issuetype`))) where ((`i_mc`.`deleted` = 0) and (`i_mc`.`id` = `i`.`id`))) AS `MetodoContratación` from `tbg_issues` `i` */;


