{
  "source" : {
    "server" : "locally"
  },
  "position" : {
    "ts_sec" : 1488201481,
    "file" : "mysql-bin.000199",
    "pos" : 46970088,
    "server_id" : 13,
    "event" : 7
  },
  "databaseName" : "NextErpQa",
  "ddl" : "DROP PROCEDURE find_par"
}
{
  "source" : {
    "server" : "locally"
  },
  "position" : {
    "ts_sec" : 1488201482,
    "file" : "mysql-bin.000199",
    "pos" : 46970088,
    "server_id" : 13,
    "event" : 9
  },
  "databaseName" : "NextErpQa",
  "ddl" : "CREATE DEFINER=`parasshah`@`%` PROCEDURE `find_par`(seed INT)\nBEGIN\n\t\n\tDECLARE i int default 0;\n\t\n\t DROP TABLE IF EXISTS _result;\n\t\n\t CREATE TEMPORARY TABLE _result (node int primary key,id int,type varchar(20));\n\t\n\t INSERT INTO _result(node,id,type) VALUES(seed,i,'exam');\n\t\n\t DROP TABLE IF EXISTS _tmp;\n\t\n\tCREATE TEMPORARY TABLE _tmp (parent_node int,child_node int);\n\tREPEAT\n\tTRUNCATE TABLE _tmp;\n\tINSERT INTO _tmp SELECT EM.PARENT_EXAM_ID as parent_node, _result.node as child_node\n\tFROM _result JOIN EXAM_MAPPING EM ON EM.CHILD_EXAM_ID = _result.node;  \t \n\t\n\tINSERT IGNORE INTO _result(node,id,type) values ((SELECT parent_node FROM _tmp),i+1,'exam' );\t\n\t\n\t\n\t\n\tUNTIL ROW_COUNT() = 0\n\tEND REPEAT;\n\t\n\tselect max(id) from _result into i;\n\t\n\tREPEAT\n\tTRUNCATE TABLE _tmp;\n\t\n\tINSERT INTO _tmp SELECT EM.EXAM_STRUCTURE_ID as parent_node, _result.node as child_node\n\tFROM _result JOIN EXAM_STRUCTURE_EXAM_MAPPING EM ON EM.EXAM_ID = _result.node and _result.id = i;  \n\t\n\tINSERT IGNORE INTO _result(node,id,type) values ((SELECT parent_node FROM _tmp),i+1,'exam_structure');\n\t\n\tUNTIL ROW_COUNT() = 0\n\tEND REPEAT;\n\t\n\tselect max(id) from _result into i;\n\t\n\tREPEAT\n\tTRUNCATE TABLE _tmp;\n\t\n\tINSERT INTO _tmp SELECT EM.PARENT_EXAM_STRUCTURE_ID as parent_node, _result.node as child_node\n\tFROM _result JOIN EXAM_STRUCTURE_MAPPING EM ON EM.CHILD_EXAM_STRUCTURE_ID = _result.node and _result.id = i;  \n\n\tif ((SELECT EM.PARENT_EXAM_STRUCTURE_ID as parent_node, _result.node as child_node\n\tFROM _result JOIN EXAM_STRUCTURE_MAPPING EM ON EM.CHILD_EXAM_STRUCTURE_ID = _result.node and _result.id = i)!= NULL)\tthen\t\n\tINSERT IGNORE INTO _result(node,id,type) values ((SELECT parent_node FROM _tmp),i+1,'exam_structure');\n\tend if;\n\t\n\tUNTIL ROW_COUNT() = 0\n\tEND REPEAT;\n\t\n\n\t\n\tTRUNCATE TABLE _tmp;\n\t\n\tSELECT * FROM _result;\n\t\n\t\n\tDROP TABLE _tmp;\n\t\nEND"
}
{
  "source" : {
    "server" : "locally"
  },
  "position" : {
    "ts_sec" : 1488201484,
    "file" : "mysql-bin.000199",
    "pos" : 46972810,
    "server_id" : 13,
    "event" : 5
  },
  "databaseName" : "NextErpQa",
  "ddl" : "DROP TABLE IF EXISTS `_result` /* generated by server */"
}
{
  "source" : {
    "server" : "locally"
  },
  "position" : {
    "ts_sec" : 1488201484,
    "file" : "mysql-bin.000199",
    "pos" : 46972810,
    "server_id" : 13,
    "event" : 7
  },
  "databaseName" : "NextErpQa",
  "ddl" : "DROP TEMPORARY TABLE IF EXISTS `_tmp` /* generated by server */"
}
{
  "source" : {
    "server" : "locally"
  },
  "position" : {
    "ts_sec" : 1488201586,
    "file" : "mysql-bin.000199",
    "pos" : 46973915,
    "server_id" : 13,
    "event" : 5
  },
  "databaseName" : "NextErpQa",
  "ddl" : "DROP PROCEDURE find_par"
}
{
  "source" : {
    "server" : "locally"
  },
  "position" : {
    "ts_sec" : 1488201587,
    "file" : "mysql-bin.000199",
    "pos" : 46973915,
    "server_id" : 13,
    "event" : 7
  },
  "databaseName" : "NextErpQa",
  "ddl" : "CREATE DEFINER=`parasshah`@`%` PROCEDURE `find_par`(seed INT)\nBEGIN\n\t\n\tDECLARE i int default 0;\n\t\n\t DROP TABLE IF EXISTS _result;\n\t\n\t CREATE TEMPORARY TABLE _result (node int primary key,id int,type varchar(20));\n\t\n\t INSERT INTO _result(node,id,type) VALUES(seed,i,'exam');\n\t\n\t DROP TABLE IF EXISTS _tmp;\n\t\n\tCREATE TEMPORARY TABLE _tmp (parent_node int,child_node int);\n\tREPEAT\n\tTRUNCATE TABLE _tmp;\n\tINSERT INTO _tmp SELECT EM.PARENT_EXAM_ID as parent_node, _result.node as child_node\n\tFROM _result JOIN EXAM_MAPPING EM ON EM.CHILD_EXAM_ID = _result.node;  \t \n\t\n\tINSERT IGNORE INTO _result(node,id,type) values ((SELECT parent_node FROM _tmp),i+1,'exam' );\t\n\t\n\t\n\t\n\tUNTIL ROW_COUNT() = 0\n\tEND REPEAT;\n\t\n\tselect max(id) from _result into i;\n\t\n\tREPEAT\n\tTRUNCATE TABLE _tmp;\n\t\n\tINSERT INTO _tmp SELECT EM.EXAM_STRUCTURE_ID as parent_node, _result.node as child_node\n\tFROM _result JOIN EXAM_STRUCTURE_EXAM_MAPPING EM ON EM.EXAM_ID = _result.node and _result.id = i;  \n\t\n\tINSERT IGNORE INTO _result(node,id,type) values ((SELECT parent_node FROM _tmp),i+1,'exam_structure');\n\t\n\tUNTIL ROW_COUNT() = 0\n\tEND REPEAT;\n\t\n\tselect max(id) from _result into i;\n\t\n\tREPEAT\n\tTRUNCATE TABLE _tmp;\n\t\n\tINSERT INTO _tmp SELECT EM.PARENT_EXAM_STRUCTURE_ID as parent_node, _result.node as child_node\n\tFROM _result JOIN EXAM_STRUCTURE_MAPPING EM ON EM.CHILD_EXAM_STRUCTURE_ID = _result.node and _result.id = i;  \n\n\tif exists (select * from _tmp)\tthen\t\n\tINSERT IGNORE INTO _result(node,id,type) values ((SELECT parent_node FROM _tmp),i+1,'exam_structure');\n\tend if;\n\t\n\tUNTIL ROW_COUNT() = 0\n\tEND REPEAT;\n\t\n\n\t\n\tTRUNCATE TABLE _tmp;\n\t\n\tSELECT * FROM _result;\n\t\n\t\n\tDROP TABLE _tmp;\n\t\nEND"
}
{
  "source" : {
    "server" : "locally"
  },
  "position" : {
    "ts_sec" : 1488201589,
    "file" : "mysql-bin.000199",
    "pos" : 46973915,
    "server_id" : 13,
    "event" : 9
  },
  "databaseName" : "NextErpQa",
  "ddl" : "DROP TEMPORARY TABLE IF EXISTS `_result` /* generated by server */"
}
{
  "source" : {
    "server" : "locally"
  },
  "position" : {
    "ts_sec" : 1488201590,
    "file" : "mysql-bin.000199",
    "pos" : 46973915,
    "server_id" : 13,
    "event" : 11
  },
  "databaseName" : "NextErpQa",
  "ddl" : "DROP TEMPORARY TABLE IF EXISTS `_tmp` /* generated by server */"
}
{
  "source" : {
    "server" : "locally"
  },
  "position" : {
    "ts_sec" : 1488201590,
    "file" : "mysql-bin.000199",
    "pos" : 46973915,
    "server_id" : 13,
    "event" : 13
  },
  "databaseName" : "NextErpQa",
  "ddl" : "DROP TEMPORARY TABLE IF EXISTS `_tmp` /* generated by server */"
}