/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;

/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;

/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;

/*!40101 SET NAMES utf8 */;

/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;

/*!40103 SET TIME_ZONE='+00:00' */;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;

/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;

/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;

/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

CREATE DATABASE /*!32312 IF NOT EXISTS*/ `pql` /*!40100 DEFAULT CHARACTER SET utf8 */;

USE `pql`;

DROP TABLE IF EXISTS `jbpt_labels`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `jbpt_labels` (

`id` int(11) unsigned NOT NULL AUTO_INCREMENT,

`label` text NOT NULL,

PRIMARY KEY (`id`),

UNIQUE KEY `id` (`id`),

KEY `label` (`label`(5))

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*!40101 SET character_set_client = @saved_cs_client */;

/*!50003 SET @saved_cs_client = @@character_set_client */ ;

/*!50003 SET @saved_cs_results = @@character_set_results */ ;

/*!50003 SET @saved_col_connection = @@collation_connection */ ;

/*!50003 SET character_set_client = latin1 */ ;

/*!50003 SET character_set_results = latin1 */ ;

/*!50003 SET collation_connection = latin1_swedish_ci */ ;

/*!50003 SET @saved_sql_mode = @@sql_mode */ ;

/*!50003 SET sql_mode = 'STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION' */ ;

DELIMITER ;;

/*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 TRIGGER `jbpt_labels_before_del_tr` BEFORE DELETE ON `jbpt_labels`

END */;;

DELIMITER ;

/*!50003 SET sql_mode = @saved_sql_mode */ ;

/*!50003 SET character_set_client = @saved_cs_client */ ;

/*!50003 SET character_set_results = @saved_cs_results */ ;

/*!50003 SET collation_connection = @saved_col_connection */ ;

DROP TABLE IF EXISTS `jbpt_petri_flow`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `jbpt_petri_flow` (

`source` int(11) unsigned NOT NULL,

`target` int(11) unsigned NOT NULL,

`name` text,

`description` text,

PRIMARY KEY (`source`,`target`),

KEY `source` (`source`),

KEY `target` (`target`),

CONSTRAINT `jbpt_flow_fk_source` FOREIGN KEY (`source`) REFERENCES `jbpt_petri_nodes` (`id`),

CONSTRAINT `jbpt_flow_fk_target` FOREIGN KEY (`target`) REFERENCES `jbpt_petri_nodes` (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*!40101 SET character_set_client = @saved_cs_client */;

DROP TABLE IF EXISTS `jbpt_petri_markings`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `jbpt_petri_markings` (

`place_id` int(11) unsigned NOT NULL,

`tokens` int(11) unsigned NOT NULL,

PRIMARY KEY (`place_id`),

CONSTRAINT `jbpt_petri_markings_fk` FOREIGN KEY (`place_id`) REFERENCES `jbpt_petri_nodes` (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*!40101 SET character_set_client = @saved_cs_client */;

DROP TABLE IF EXISTS `jbpt_petri_nets`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `jbpt_petri_nets` (

`id` int(11) unsigned NOT NULL AUTO_INCREMENT,

`uuid` varchar(36) NOT NULL,

`name` text,

`description` text,

`external_id` text,

`pnml_content` longtext,

PRIMARY KEY (`id`),

UNIQUE KEY `uuid` (`uuid`(20)),

UNIQUE KEY `external_id` (`external_id`(20))

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*!40101 SET character_set_client = @saved_cs_client */;

/*!50003 SET @saved_cs_client = @@character_set_client */ ;

/*!50003 SET @saved_cs_results = @@character_set_results */ ;

/*!50003 SET @saved_col_connection = @@collation_connection */ ;

/*!50003 SET character_set_client = latin1 */ ;

/*!50003 SET character_set_results = latin1 */ ;

/*!50003 SET collation_connection = latin1_swedish_ci */ ;

/*!50003 SET @saved_sql_mode = @@sql_mode */ ;

/*!50003 SET sql_mode = 'STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION' */ ;

DELIMITER ;;

/*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 TRIGGER `jbpt_petri_nets_before_del_tr` BEFORE DELETE ON `jbpt_petri_nets`

END */;;

DELIMITER ;

/*!50003 SET sql_mode = @saved_sql_mode */ ;

/*!50003 SET character_set_client = @saved_cs_client */ ;

/*!50003 SET character_set_results = @saved_cs_results */ ;

/*!50003 SET collation_connection = @saved_col_connection */ ;

DROP TABLE IF EXISTS `jbpt_petri_nodes`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `jbpt_petri_nodes` (

`id` int(11) unsigned NOT NULL AUTO_INCREMENT,

`net_id` int(11) unsigned NOT NULL,

`uuid` varchar(50) NOT NULL,

`name` text,

`description` text,

`label_id` int(10) unsigned DEFAULT NULL,

`is_transition` tinyint(1) NOT NULL,

PRIMARY KEY (`id`),

KEY `label_id` (`label_id`),

KEY `net_id` (`net_id`),

KEY `is_transition` (`is_transition`),

KEY `triple_index` (`net_id`,`is_transition`,`label_id`),

CONSTRAINT `jbpt_nodes_fk` FOREIGN KEY (`net_id`) REFERENCES `jbpt_petri_nets` (`id`),

CONSTRAINT `jbpt_petri_nodes_fk` FOREIGN KEY (`label_id`) REFERENCES `jbpt_labels` (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*!40101 SET character_set_client = @saved_cs_client */;

/*!50003 SET @saved_cs_client = @@character_set_client */ ;

/*!50003 SET @saved_cs_results = @@character_set_results */ ;

/*!50003 SET @saved_col_connection = @@collation_connection */ ;

/*!50003 SET character_set_client = utf8 */ ;

/*!50003 SET character_set_results = utf8 */ ;

/*!50003 SET collation_connection = utf8_general_ci */ ;

/*!50003 SET @saved_sql_mode = @@sql_mode */ ;

/*!50003 SET sql_mode = 'STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION' */ ;

DELIMITER ;;

/*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 TRIGGER `jbpt_petri_nodes_before_del_tr` BEFORE DELETE ON `jbpt_petri_nodes`

END */;;

DELIMITER ;

/*!50003 SET sql_mode = @saved_sql_mode */ ;

/*!50003 SET character_set_client = @saved_cs_client */ ;

/*!50003 SET character_set_results = @saved_cs_results */ ;

/*!50003 SET collation_connection = @saved_col_connection */ ;

DROP TABLE IF EXISTS `placeholder`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `placeholder` (

`child_id` int(11) NOT NULL,

`folder_name` varchar(45) NOT NULL

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*!40101 SET character_set_client = @saved_cs_client */;

DROP TABLE IF EXISTS `pql_always_occurs`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `pql_always_occurs` (

`net_id` int(11) unsigned NOT NULL,

`task_id` int(10) unsigned NOT NULL,

PRIMARY KEY (`net_id`,`task_id`),

KEY `net_id` (`net_id`),

KEY `task_id` (`task_id`),

CONSTRAINT `pql_always_occurs_fk` FOREIGN KEY (`net_id`) REFERENCES `jbpt_petri_nets` (`id`),

CONSTRAINT `pql_always_occurs_fk1` FOREIGN KEY (`task_id`) REFERENCES `pql_tasks` (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*!40101 SET character_set_client = @saved_cs_client */;

DROP TABLE IF EXISTS `pql_can_conflict`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `pql_can_conflict` (

`net_id` int(11) unsigned NOT NULL,

`taskA_id` int(10) unsigned NOT NULL,

`taskB_id` int(10) unsigned NOT NULL,

PRIMARY KEY (`net_id`,`taskA_id`,`taskB_id`),

KEY `net_id` (`net_id`),

KEY `taskA_id` (`taskA_id`),

KEY `taskB_id` (`taskB_id`),

CONSTRAINT `pql_can_conflict_fk` FOREIGN KEY (`net_id`) REFERENCES `jbpt_petri_nets` (`id`),

CONSTRAINT `pql_can_conflict_fk1` FOREIGN KEY (`taskA_id`) REFERENCES `pql_tasks` (`id`),

CONSTRAINT `pql_can_conflict_fk2` FOREIGN KEY (`taskB_id`) REFERENCES `pql_tasks` (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*!40101 SET character_set_client = @saved_cs_client */;

DROP TABLE IF EXISTS `pql_can_cooccur`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `pql_can_cooccur` (

`net_id` int(11) unsigned NOT NULL,

`taskA_id` int(10) unsigned NOT NULL,

`taskB_id` int(10) unsigned NOT NULL,

PRIMARY KEY (`net_id`,`taskA_id`,`taskB_id`),

KEY `net_id` (`net_id`),

KEY `taskA_id` (`taskA_id`),

KEY `pql_can_cooccur_fk2` (`taskB_id`),

CONSTRAINT `pql_can_cooccur_fk` FOREIGN KEY (`net_id`) REFERENCES `jbpt_petri_nets` (`id`),

CONSTRAINT `pql_can_cooccur_fk1` FOREIGN KEY (`taskA_id`) REFERENCES `pql_tasks` (`id`),

CONSTRAINT `pql_can_cooccur_fk2` FOREIGN KEY (`taskB_id`) REFERENCES `pql_tasks` (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*!40101 SET character_set_client = @saved_cs_client */;

DROP TABLE IF EXISTS `pql_can_occur`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `pql_can_occur` (

`net_id` int(11) unsigned NOT NULL,

`task_id` int(10) unsigned NOT NULL,

PRIMARY KEY (`net_id`,`task_id`),

KEY `net_id` (`net_id`),

KEY `task_id` (`task_id`),

CONSTRAINT `pql_can_occur_fk` FOREIGN KEY (`task_id`) REFERENCES `pql_tasks` (`id`),

CONSTRAINT `pql_can_occurs_fk` FOREIGN KEY (`net_id`) REFERENCES `jbpt_petri_nets` (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*!40101 SET character_set_client = @saved_cs_client */;

DROP TABLE IF EXISTS `pql_folder_id`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `pql_folder_id` (

`file_name` varchar(36) NOT NULL,

`folder_id` int(10) NOT NULL

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*!40101 SET character_set_client = @saved_cs_client */;

DROP TABLE IF EXISTS `pql_folder_name`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `pql_folder_name` (

`folder_id` int(11) NOT NULL AUTO_INCREMENT,

`folder_name` varchar(26) NOT NULL,

PRIMARY KEY (`folder_id`),

UNIQUE KEY `folder_id_UNIQUE` (`folder_id`),

KEY `fk_name_idx` (`folder_id`)

) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

/*!40101 SET character_set_client = @saved_cs_client */;

DROP TABLE IF EXISTS `pql_folder_struct`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `pql_folder_struct` (

`parent_id` int(11) DEFAULT NULL,

`child_id` int(11) NOT NULL,

UNIQUE KEY `child_id_UNIQUE` (`child_id`),

KEY `parent-child_idx` (`parent_id`),

CONSTRAINT `child-id` FOREIGN KEY (`child_id`) REFERENCES `pql_folder_name` (`folder_id`) ON DELETE CASCADE ON UPDATE NO ACTION,

CONSTRAINT `parent-child` FOREIGN KEY (`parent_id`) REFERENCES `pql_folder_struct` (`child_id`) ON DELETE CASCADE ON UPDATE NO ACTION

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*!40101 SET character_set_client = @saved_cs_client */;

DROP TABLE IF EXISTS `pql_index_bots`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `pql_index_bots` (

`bot_name` varchar(36) NOT NULL,

`last_alive` bigint(20) NOT NULL,

PRIMARY KEY (`bot_name`,`last_alive`),

UNIQUE KEY `bot_name` (`bot_name`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*!40101 SET character_set_client = @saved_cs_client */;

DROP TABLE IF EXISTS `pql_index_queue`;

/*!50001 DROP VIEW IF EXISTS `pql_index_queue`*/;

SET @saved_cs_client = @@character_set_client;

SET character_set_client = utf8;

1 AS `id`*/;

SET character_set_client = @saved_cs_client;

DROP TABLE IF EXISTS `pql_index_status`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `pql_index_status` (

`net_id` int(11) unsigned NOT NULL,

`bot_name` varchar(36) NOT NULL,

`status` tinyint(4) unsigned zerofill NOT NULL DEFAULT '0000',

`type` tinyint(4) unsigned zerofill NOT NULL DEFAULT '0000' COMMENT 'index type:\r\n0 - store all behavioral relations',

`claim_time` bigint(20) DEFAULT NULL,

`start_time` bigint(20) DEFAULT NULL,

`end_time` bigint(20) DEFAULT NULL,

PRIMARY KEY (`net_id`),

UNIQUE KEY `net_id_2` (`net_id`),

KEY `net_id` (`net_id`),

CONSTRAINT `pql_index_status_fk` FOREIGN KEY (`net_id`) REFERENCES `jbpt_petri_nets` (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*!40101 SET character_set_client = @saved_cs_client */;

DROP TABLE IF EXISTS `pql_indexed_ids`;

/*!50001 DROP VIEW IF EXISTS `pql_indexed_ids`*/;

SET @saved_cs_client = @@character_set_client;

SET character_set_client = utf8;

1 AS `external_id`*/;

SET character_set_client = @saved_cs_client;

DROP TABLE IF EXISTS `pql_tasks`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `pql_tasks` (

`id` int(11) unsigned NOT NULL AUTO_INCREMENT,

`label_id` int(10) unsigned NOT NULL,

`similarity` double(15,3) unsigned zerofill NOT NULL,

PRIMARY KEY (`id`),

UNIQUE KEY `id` (`id`),

UNIQUE KEY `label_id_and_sim` (`label_id`,`similarity`),

KEY `label_id` (`label_id`),

CONSTRAINT `pql_tasks_fk` FOREIGN KEY (`label_id`) REFERENCES `jbpt_labels` (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*!40101 SET character_set_client = @saved_cs_client */;

/*!50003 SET @saved_cs_client = @@character_set_client */ ;

/*!50003 SET @saved_cs_results = @@character_set_results */ ;

/*!50003 SET @saved_col_connection = @@collation_connection */ ;

/*!50003 SET character_set_client = latin1 */ ;

/*!50003 SET character_set_results = latin1 */ ;

/*!50003 SET collation_connection = latin1_swedish_ci */ ;

/*!50003 SET @saved_sql_mode = @@sql_mode */ ;

/*!50003 SET sql_mode = 'STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION' */ ;

DELIMITER ;;

/*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 TRIGGER `pql_tasks_before_del_tr` BEFORE DELETE ON `pql_tasks`

END */;;

DELIMITER ;

/*!50003 SET sql_mode = @saved_sql_mode */ ;

/*!50003 SET character_set_client = @saved_cs_client */ ;

/*!50003 SET character_set_results = @saved_cs_results */ ;

/*!50003 SET collation_connection = @saved_col_connection */ ;

DROP TABLE IF EXISTS `pql_tasks_sim`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `pql_tasks_sim` (

`task_id` int(11) unsigned NOT NULL,

`label_id` int(11) unsigned NOT NULL,

UNIQUE KEY `task_and_label_ids` (`task_id`,`label_id`),

KEY `label_id` (`label_id`),

CONSTRAINT `pql_tasks_sim_fk_label_id` FOREIGN KEY (`label_id`) REFERENCES `jbpt_labels` (`id`),

CONSTRAINT `pql_tasks_sim_fk_task_id` FOREIGN KEY (`task_id`) REFERENCES `pql_tasks` (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*!40101 SET character_set_client = @saved_cs_client */;

DROP TABLE IF EXISTS `pql_total_causal`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `pql_total_causal` (

`net_id` int(11) unsigned NOT NULL,

`taskA_id` int(10) unsigned NOT NULL,

`taskB_id` int(10) unsigned NOT NULL,

PRIMARY KEY (`net_id`,`taskA_id`,`taskB_id`),

KEY `net_id` (`net_id`),

KEY `taskA_id` (`taskA_id`),

KEY `taskB_id` (`taskB_id`),

CONSTRAINT `pql_total_causal_fk` FOREIGN KEY (`net_id`) REFERENCES `jbpt_petri_nets` (`id`),

CONSTRAINT `pql_total_causal_fk1` FOREIGN KEY (`taskA_id`) REFERENCES `pql_tasks` (`id`),

CONSTRAINT `pql_total_causal_fk2` FOREIGN KEY (`taskB_id`) REFERENCES `pql_tasks` (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*!40101 SET character_set_client = @saved_cs_client */;

DROP TABLE IF EXISTS `pql_total_concur`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `pql_total_concur` (

`net_id` int(11) unsigned NOT NULL,

`taskA_id` int(10) unsigned NOT NULL,

`taskB_id` int(10) unsigned NOT NULL,

PRIMARY KEY (`net_id`,`taskA_id`,`taskB_id`),

KEY `net_id` (`net_id`),

KEY `taskA_id` (`taskA_id`),

KEY `taskB_id` (`taskB_id`),

CONSTRAINT `pql_total_concurrent_fk` FOREIGN KEY (`net_id`) REFERENCES `jbpt_petri_nets` (`id`),

CONSTRAINT `pql_total_concurrent_fk1` FOREIGN KEY (`taskA_id`) REFERENCES `pql_tasks` (`id`),

CONSTRAINT `pql_total_concurrent_fk2` FOREIGN KEY (`taskB_id`) REFERENCES `pql_tasks` (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*!40101 SET character_set_client = @saved_cs_client */;

/*!50003 DROP FUNCTION IF EXISTS `fldr_id_create` */;

/*!50003 SET @saved_cs_client = @@character_set_client */ ;

/*!50003 SET @saved_cs_results = @@character_set_results */ ;

/*!50003 SET @saved_col_connection = @@collation_connection */ ;

/*!50003 SET character_set_client = utf8 */ ;

/*!50003 SET character_set_results = utf8 */ ;

/*!50003 SET collation_connection = utf8_general_ci */ ;

/*!50003 SET @saved_sql_mode = @@sql_mode */ ;

/*!50003 SET sql_mode = 'STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION' */ ;

DELIMITER ;;

CREATE DEFINER=`root`@`localhost` FUNCTION `fldr_id_create`(file_name VARCHAR(36), folder_id INT(11)) RETURNS int(11)

INSERT INTO `pql_folder_id`

(`pql_folder_id`.`file_name`,`pql_folder_id`.`folder_id`)

VALUES

(file_name,folder_id);

RETURN 0;

END ;;

DELIMITER ;

/*!50003 SET sql_mode = @saved_sql_mode */ ;

/*!50003 SET character_set_client = @saved_cs_client */ ;

/*!50003 SET character_set_results = @saved_cs_results */ ;

/*!50003 SET collation_connection = @saved_col_connection */ ;

/*!50003 DROP FUNCTION IF EXISTS `fldr_struct_move` */;

/*!50003 SET @saved_cs_client = @@character_set_client */ ;

/*!50003 SET @saved_cs_results = @@character_set_results */ ;

/*!50003 SET @saved_col_connection = @@collation_connection */ ;

/*!50003 SET character_set_client = utf8 */ ;

/*!50003 SET character_set_results = utf8 */ ;

/*!50003 SET collation_connection = utf8_general_ci */ ;

/*!50003 SET @saved_sql_mode = @@sql_mode */ ;

/*!50003 SET sql_mode = 'STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION' */ ;

DELIMITER ;;

CREATE DEFINER=`root`@`localhost` FUNCTION `fldr_struct_move`(original VARCHAR(36), targetfolderlocation varchar(36)) RETURNS int(11)

UPDATE pql.`pql_folder_struct` SET `parent_id`= (Select folder_id from `pql`.`pql_folder_name` Where Folder_name = targetfolderlocation)

Where child_id = (Select folder_id from pql.`pql_folder_name` Where Folder_name = original);

RETURN 0;

END ;;

DELIMITER ;

/*!50003 SET sql_mode = @saved_sql_mode */ ;

/*!50003 SET character_set_client = @saved_cs_client */ ;

/*!50003 SET character_set_results = @saved_cs_results */ ;

/*!50003 SET collation_connection = @saved_col_connection */ ;

/*!50003 DROP FUNCTION IF EXISTS `jbpt_labels_create` */;

/*!50003 SET @saved_cs_client = @@character_set_client */ ;

/*!50003 SET @saved_cs_results = @@character_set_results */ ;

/*!50003 SET @saved_col_connection = @@collation_connection */ ;

/*!50003 SET character_set_client = utf8 */ ;

/*!50003 SET character_set_results = utf8 */ ;

/*!50003 SET collation_connection = utf8_general_ci */ ;

/*!50003 SET @saved_sql_mode = @@sql_mode */ ;

/*!50003 SET sql_mode = 'STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION' */ ;

DELIMITER ;;

CREATE DEFINER=`root`@`localhost` FUNCTION `jbpt_labels_create`(label TEXT) RETURNS int(11)

DETERMINISTIC

DECLARE result INTEGER;

SET label = TRIM(label);

SELECT `jbpt_labels`.`id` INTO result

FROM `jbpt_labels`

WHERE `jbpt_labels`.`label`=label;

IF result IS NOT NULL THEN

RETURN result;

END IF;

INSERT INTO `jbpt_labels` (`jbpt_labels`.`label`)

VALUES (label);

SET result = LAST_INSERT_ID();

RETURN result;

END ;;

DELIMITER ;

/*!50003 SET sql_mode = @saved_sql_mode */ ;

/*!50003 SET character_set_client = @saved_cs_client */ ;

/*!50003 SET character_set_results = @saved_cs_results */ ;

/*!50003 SET collation_connection = @saved_col_connection */ ;

/*!50003 DROP FUNCTION IF EXISTS `jbpt_petri_flow_create` */;

/*!50003 SET @saved_cs_client = @@character_set_client */ ;

/*!50003 SET @saved_cs_results = @@character_set_results */ ;

/*!50003 SET @saved_col_connection = @@collation_connection */ ;

/*!50003 SET character_set_client = utf8 */ ;

/*!50003 SET character_set_results = utf8 */ ;

/*!50003 SET collation_connection = utf8_general_ci */ ;

/*!50003 SET @saved_sql_mode = @@sql_mode */ ;

/*!50003 SET sql_mode = 'STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION' */ ;

DELIMITER ;;

CREATE DEFINER=`root`@`localhost` FUNCTION `jbpt_petri_flow_create`(source INTEGER(11), target INTEGER(11), name TEXT, description TEXT) RETURNS tinyint(1)

DETERMINISTIC

INSERT INTO `jbpt_petri_flow`

(`jbpt_petri_flow`.`source`,`jbpt_petri_flow`.`target`,`jbpt_petri_flow`.`name`,`jbpt_petri_flow`.`description`)

VALUES

(source,target,name,description);

RETURN TRUE;

END ;;

DELIMITER ;

/*!50003 SET sql_mode = @saved_sql_mode */ ;

/*!50003 SET character_set_client = @saved_cs_client */ ;

/*!50003 SET character_set_results = @saved_cs_results */ ;

/*!50003 SET collation_connection = @saved_col_connection */ ;

/*!50003 DROP FUNCTION IF EXISTS `jbpt_petri_markings_create` */;

/*!50003 SET @saved_cs_client = @@character_set_client */ ;

/*!50003 SET @saved_cs_results = @@character_set_results */ ;

/*!50003 SET @saved_col_connection = @@collation_connection */ ;

/*!50003 SET character_set_client = utf8 */ ;

/*!50003 SET character_set_results = utf8 */ ;

/*!50003 SET collation_connection = utf8_general_ci */ ;

/*!50003 SET @saved_sql_mode = @@sql_mode */ ;

/*!50003 SET sql_mode = 'STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION' */ ;

DELIMITER ;;

CREATE DEFINER=`root`@`localhost` FUNCTION `jbpt_petri_markings_create`(place_id INTEGER(11), tokens INTEGER(11)) RETURNS tinyint(1)

INSERT INTO `jbpt_petri_markings`

(`jbpt_petri_markings`.`place_id`,`jbpt_petri_markings`.`tokens`)

VALUES

(place_id,tokens);

RETURN TRUE;

END ;;

DELIMITER ;

/*!50003 SET sql_mode = @saved_sql_mode */ ;

/*!50003 SET character_set_client = @saved_cs_client */ ;

/*!50003 SET character_set_results = @saved_cs_results */ ;

/*!50003 SET collation_connection = @saved_col_connection */ ;

/*!50003 DROP FUNCTION IF EXISTS `jbpt_petri_nets_create` */;

/*!50003 SET @saved_cs_client = @@character_set_client */ ;

/*!50003 SET @saved_cs_results = @@character_set_results */ ;

/*!50003 SET @saved_col_connection = @@collation_connection */ ;

/*!50003 SET character_set_client = latin1 */ ;

/*!50003 SET character_set_results = latin1 */ ;

/*!50003 SET collation_connection = latin1_swedish_ci */ ;

/*!50003 SET @saved_sql_mode = @@sql_mode */ ;

/*!50003 SET sql_mode = 'STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION' */ ;

DELIMITER ;;

CREATE DEFINER=`root`@`localhost` FUNCTION `jbpt_petri_nets_create`(uuid VARCHAR(36), name TEXT, description TEXT, external_id TEXT, pnml_content LONGTEXT) RETURNS int(11)

IF jbpt_petri_nets_get_internal_id(external_id) IS NOT NULL THEN

RETURN 0;

END IF;

INSERT INTO `jbpt_petri_nets`

(`jbpt_petri_nets`.`uuid`,`jbpt_petri_nets`.name,`jbpt_petri_nets`.description,`jbpt_petri_nets`.`external_id`,`jbpt_petri_nets`.`pnml_content`)

VALUES

(uuid,name,description,external_id,pnml_content);

RETURN LAST_INSERT_ID();

END ;;

DELIMITER ;

/*!50003 SET sql_mode = @saved_sql_mode */ ;

/*!50003 SET character_set_client = @saved_cs_client */ ;

/*!50003 SET character_set_results = @saved_cs_results */ ;

/*!50003 SET collation_connection = @saved_col_connection */ ;

/*!50003 DROP FUNCTION IF EXISTS `jbpt_petri_nets_delete` */;

/*!50003 SET @saved_cs_client = @@character_set_client */ ;

/*!50003 SET @saved_cs_results = @@character_set_results */ ;

/*!50003 SET @saved_col_connection = @@collation_connection */ ;

/*!50003 SET character_set_client = latin1 */ ;

/*!50003 SET character_set_results = latin1 */ ;

/*!50003 SET collation_connection = latin1_swedish_ci */ ;

/*!50003 SET @saved_sql_mode = @@sql_mode */ ;

/*!50003 SET sql_mode = 'STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION' */ ;

DELIMITER ;;

CREATE DEFINER=`root`@`localhost` FUNCTION `jbpt_petri_nets_delete`(internal_id INTEGER(11)) RETURNS int(11)

DETERMINISTIC

DECLARE delID INTEGER;

SELECT id INTO delID FROM `jbpt_petri_nets` WHERE `jbpt_petri_nets`.`id` = internal_id;

IF delID IS NULL THEN

RETURN 0;

END IF;

DELETE FROM `jbpt_petri_nets` WHERE `jbpt_petri_nets`.`id` = delID;

RETURN delID;

END ;;

DELIMITER ;

/*!50003 SET sql_mode = @saved_sql_mode */ ;

/*!50003 SET character_set_client = @saved_cs_client */ ;

/*!50003 SET character_set_results = @saved_cs_results */ ;

/*!50003 SET collation_connection = @saved_col_connection */ ;

/*!50003 DROP FUNCTION IF EXISTS `jbpt_petri_nets_get_external_id` */;

/*!50003 SET @saved_cs_client = @@character_set_client */ ;

/*!50003 SET @saved_cs_results = @@character_set_results */ ;

/*!50003 SET @saved_col_connection = @@collation_connection */ ;

/*!50003 SET character_set_client = utf8 */ ;

/*!50003 SET character_set_results = utf8 */ ;

/*!50003 SET collation_connection = utf8_general_ci */ ;

/*!50003 SET @saved_sql_mode = @@sql_mode */ ;

/*!50003 SET sql_mode = 'STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION' */ ;

DELIMITER ;;

CREATE DEFINER=`root`@`localhost` FUNCTION `jbpt_petri_nets_get_external_id`(internal_id INTEGER(11)) RETURNS text CHARSET utf8

DECLARE result TEXT;

SELECT `jbpt_petri_nets`.`external_id` INTO result

FROM `jbpt_petri_nets`

WHERE `jbpt_petri_nets`.`id`=internal_id;

RETURN result;

END ;;

DELIMITER ;

/*!50003 SET sql_mode = @saved_sql_mode */ ;

/*!50003 SET character_set_client = @saved_cs_client */ ;

/*!50003 SET character_set_results = @saved_cs_results */ ;

/*!50003 SET collation_connection = @saved_col_connection */ ;

/*!50003 DROP FUNCTION IF EXISTS `jbpt_petri_nets_get_internal_id` */;

/*!50003 SET @saved_cs_client = @@character_set_client */ ;

/*!50003 SET @saved_cs_results = @@character_set_results */ ;

/*!50003 SET @saved_col_connection = @@collation_connection */ ;

/*!50003 SET character_set_client = utf8 */ ;

/*!50003 SET character_set_results = utf8 */ ;

/*!50003 SET collation_connection = utf8_general_ci */ ;

/*!50003 SET @saved_sql_mode = @@sql_mode */ ;

/*!50003 SET sql_mode = 'STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION' */ ;

DELIMITER ;;

CREATE DEFINER=`root`@`localhost` FUNCTION `jbpt_petri_nets_get_internal_id`(external_id TEXT) RETURNS int(11)

DETERMINISTIC

DECLARE result INTEGER;

SELECT `jbpt_petri_nets`.`id` INTO result

FROM `jbpt_petri_nets`

WHERE `jbpt_petri_nets`.`external_id`=external_id;

RETURN result;

END ;;

DELIMITER ;

/*!50003 SET sql_mode = @saved_sql_mode */ ;

/*!50003 SET character_set_client = @saved_cs_client */ ;

/*!50003 SET character_set_results = @saved_cs_results */ ;

/*!50003 SET collation_connection = @saved_col_connection */ ;

/*!50003 DROP FUNCTION IF EXISTS `jbpt_petri_nets_get_pnml_content` */;

/*!50003 SET @saved_cs_client = @@character_set_client */ ;

/*!50003 SET @saved_cs_results = @@character_set_results */ ;

/*!50003 SET @saved_col_connection = @@collation_connection */ ;

/*!50003 SET character_set_client = utf8 */ ;

/*!50003 SET character_set_results = utf8 */ ;

/*!50003 SET collation_connection = utf8_general_ci */ ;

/*!50003 SET @saved_sql_mode = @@sql_mode */ ;

/*!50003 SET sql_mode = 'STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION' */ ;

DELIMITER ;;

CREATE DEFINER=`root`@`localhost` FUNCTION `jbpt_petri_nets_get_pnml_content`(internal_id INTEGER(11)) RETURNS longtext CHARSET utf8

DECLARE result LONGTEXT;

SELECT `jbpt_petri_nets`.`pnml_content` INTO result

FROM `jbpt_petri_nets`

WHERE `jbpt_petri_nets`.`id`=internal_id;

RETURN result;

END ;;

DELIMITER ;

/*!50003 SET sql_mode = @saved_sql_mode */ ;

/*!50003 SET character_set_client = @saved_cs_client */ ;

/*!50003 SET character_set_results = @saved_cs_results */ ;

/*!50003 SET collation_connection = @saved_col_connection */ ;

/*!50003 DROP FUNCTION IF EXISTS `jbpt_petri_nodes_create` */;

/*!50003 SET @saved_cs_client = @@character_set_client */ ;

/*!50003 SET @saved_cs_results = @@character_set_results */ ;

/*!50003 SET @saved_col_connection = @@collation_connection */ ;

/*!50003 SET character_set_client = utf8 */ ;

/*!50003 SET character_set_results = utf8 */ ;

/*!50003 SET collation_connection = utf8_general_ci */ ;

/*!50003 SET @saved_sql_mode = @@sql_mode */ ;

/*!50003 SET sql_mode = 'STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION' */ ;

DELIMITER ;;

CREATE DEFINER=`root`@`localhost` FUNCTION `jbpt_petri_nodes_create`(net_id INTEGER(11), uuid VARCHAR(50), name TEXT, description TEXT, label TEXT, is_transition BOOLEAN) RETURNS int(11)

DECLARE labelID INTEGER;

IF label = "" THEN

SET labelID = NULL;

ELSE

SET labelID = jbpt_labels_create(label);

END IF;

INSERT INTO `jbpt_petri_nodes`

(`jbpt_petri_nodes`.`net_id`,`jbpt_petri_nodes`.`uuid`,`jbpt_petri_nodes`.name,`jbpt_petri_nodes`.description,`jbpt_petri_nodes`.label_id,`jbpt_petri_nodes`.is_transition)

VALUES

(net_id,uuid,name,description,labelID,is_transition);

RETURN LAST_INSERT_ID();

END ;;

DELIMITER ;

/*!50003 SET sql_mode = @saved_sql_mode */ ;

/*!50003 SET character_set_client = @saved_cs_client */ ;

/*!50003 SET character_set_results = @saved_cs_results */ ;

/*!50003 SET collation_connection = @saved_col_connection */ ;

/*!50003 DROP FUNCTION IF EXISTS `pql_always_occurs` */;

/*!50003 SET @saved_cs_client = @@character_set_client */ ;

/*!50003 SET @saved_cs_results = @@character_set_results */ ;

/*!50003 SET @saved_col_connection = @@collation_connection */ ;

/*!50003 SET character_set_client = latin1 */ ;

/*!50003 SET character_set_results = latin1 */ ;

/*!50003 SET collation_connection = latin1_swedish_ci */ ;

/*!50003 SET @saved_sql_mode = @@sql_mode */ ;

/*!50003 SET sql_mode = 'STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION' */ ;

DELIMITER ;;

CREATE DEFINER=`root`@`localhost` FUNCTION `pql_always_occurs`(net_id INTEGER(11), task_id INTEGER) RETURNS tinyint(1)

DETERMINISTIC

IF EXISTS(SELECT 1 FROM `pql_always_occurs` WHERE `pql_always_occurs`.`net_id`=net_id AND `pql_always_occurs`.`task_id`=task_id LIMIT 1) THEN

RETURN true;

END IF;

RETURN false;

END ;;

DELIMITER ;

/*!50003 SET sql_mode = @saved_sql_mode */ ;

/*!50003 SET character_set_client = @saved_cs_client */ ;

/*!50003 SET character_set_results = @saved_cs_results */ ;

/*!50003 SET collation_connection = @saved_col_connection */ ;

/*!50003 DROP FUNCTION IF EXISTS `pql_can_conflict` */;

/*!50003 SET @saved_cs_client = @@character_set_client */ ;

/*!50003 SET @saved_cs_results = @@character_set_results */ ;

/*!50003 SET @saved_col_connection = @@collation_connection */ ;

/*!50003 SET character_set_client = latin1 */ ;

/*!50003 SET character_set_results = latin1 */ ;

/*!50003 SET collation_connection = latin1_swedish_ci */ ;

/*!50003 SET @saved_sql_mode = @@sql_mode */ ;

/*!50003 SET sql_mode = 'STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION' */ ;

DELIMITER ;;

CREATE DEFINER=`root`@`localhost` FUNCTION `pql_can_conflict`(net_id INTEGER(11), taskA_id INTEGER, taskB_id INTEGER) RETURNS tinyint(1)

DETERMINISTIC

IF EXISTS(SELECT 1 FROM `pql_can_conflict` WHERE `pql_can_conflict`.`net_id`=net_id AND `pql_can_conflict`.`taskA_id`=taskA_id AND `pql_can_conflict`.`taskB_id`=taskB_id LIMIT 1) THEN

RETURN true;

END IF;

RETURN false;

END ;;

DELIMITER ;

/*!50003 SET sql_mode = @saved_sql_mode */ ;

/*!50003 SET character_set_client = @saved_cs_client */ ;

/*!50003 SET character_set_results = @saved_cs_results */ ;

/*!50003 SET collation_connection = @saved_col_connection */ ;

/*!50003 DROP FUNCTION IF EXISTS `pql_can_cooccur` */;

/*!50003 SET @saved_cs_client = @@character_set_client */ ;

/*!50003 SET @saved_cs_results = @@character_set_results */ ;

/*!50003 SET @saved_col_connection = @@collation_connection */ ;

/*!50003 SET character_set_client = latin1 */ ;

/*!50003 SET character_set_results = latin1 */ ;

/*!50003 SET collation_connection = latin1_swedish_ci */ ;

/*!50003 SET @saved_sql_mode = @@sql_mode */ ;

/*!50003 SET sql_mode = 'STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION' */ ;

DELIMITER ;;

CREATE DEFINER=`root`@`localhost` FUNCTION `pql_can_cooccur`(net_id INTEGER(11), taskA_id INTEGER, taskB_id INTEGER) RETURNS tinyint(1)

DETERMINISTIC

IF EXISTS(SELECT 1 FROM `pql_can_cooccur` WHERE `pql_can_cooccur`.`net_id`=net_id AND `pql_can_cooccur`.`taskA_id`=taskA_id AND `pql_can_cooccur`.`taskB_id`=taskB_id LIMIT 1) THEN

RETURN true;

END IF;

RETURN false;

END ;;

DELIMITER ;

/*!50003 SET sql_mode = @saved_sql_mode */ ;

/*!50003 SET character_set_client = @saved_cs_client */ ;

/*!50003 SET character_set_results = @saved_cs_results */ ;

/*!50003 SET collation_connection = @saved_col_connection */ ;

/*!50003 DROP FUNCTION IF EXISTS `pql_can_occur` */;

/*!50003 SET @saved_cs_client = @@character_set_client */ ;

/*!50003 SET @saved_cs_results = @@character_set_results */ ;

/*!50003 SET @saved_col_connection = @@collation_connection */ ;

/*!50003 SET character_set_client = latin1 */ ;

/*!50003 SET character_set_results = latin1 */ ;

/*!50003 SET collation_connection = latin1_swedish_ci */ ;

/*!50003 SET @saved_sql_mode = @@sql_mode */ ;

/*!50003 SET sql_mode = 'STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION' */ ;

DELIMITER ;;

CREATE DEFINER=`root`@`localhost` FUNCTION `pql_can_occur`(net_id INTEGER(11), task_id INTEGER) RETURNS tinyint(1)

DETERMINISTIC

IF EXISTS(SELECT 1 FROM `pql_can_occur` WHERE `pql_can_occur`.`net_id`=net_id AND `pql_can_occur`.`task_id`=task_id LIMIT 1) THEN

RETURN true;

END IF;

RETURN false;

END ;;

DELIMITER ;

/*!50003 SET sql_mode = @saved_sql_mode */ ;

/*!50003 SET character_set_client = @saved_cs_client */ ;

/*!50003 SET character_set_results = @saved_cs_results */ ;

/*!50003 SET collation_connection = @saved_col_connection */ ;

/*!50003 DROP FUNCTION IF EXISTS `pql_folder_create` */;

/*!50003 SET @saved_cs_client = @@character_set_client */ ;

/*!50003 SET @saved_cs_results = @@character_set_results */ ;

/*!50003 SET @saved_col_connection = @@collation_connection */ ;

/*!50003 SET character_set_client = utf8 */ ;

/*!50003 SET character_set_results = utf8 */ ;

/*!50003 SET collation_connection = utf8_general_ci */ ;

/*!50003 SET @saved_sql_mode = @@sql_mode */ ;

/*!50003 SET sql_mode = 'STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION' */ ;

DELIMITER ;;

CREATE DEFINER=`root`@`localhost` FUNCTION `pql_folder_create`(parent_id INT(11), new_name varchar(36)) RETURNS int(11)

Insert into pql_folder_name (folder_name) values(new_name);

Insert into pql_folder_struct values(parent_id, (SELECT MAX(folder_id) FROM pql_folder_name));

RETURN 1;

END ;;

DELIMITER ;

/*!50003 SET sql_mode = @saved_sql_mode */ ;

/*!50003 SET character_set_client = @saved_cs_client */ ;

/*!50003 SET character_set_results = @saved_cs_results */ ;

/*!50003 SET collation_connection = @saved_col_connection */ ;

/*!50003 DROP FUNCTION IF EXISTS `pql_folder_delete` */;

/*!50003 SET @saved_cs_client = @@character_set_client */ ;

/*!50003 SET @saved_cs_results = @@character_set_results */ ;

/*!50003 SET @saved_col_connection = @@collation_connection */ ;

/*!50003 SET character_set_client = utf8 */ ;

/*!50003 SET character_set_results = utf8 */ ;

/*!50003 SET collation_connection = utf8_general_ci */ ;

/*!50003 SET @saved_sql_mode = @@sql_mode */ ;

/*!50003 SET sql_mode = 'STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION' */ ;

DELIMITER ;;

CREATE DEFINER=`root`@`localhost` FUNCTION `pql_folder_delete`(given_folder INT(11)) RETURNS int(11)

DELETE FROM pql_folder_name WHERE folder_id = given_folder;

DELETE FROM pql_folder_struct WHERE child_id NOT IN (SELECT folder_id FROM pql_folder_name);

DELETE FROM pql_folder_name WHERE folder_id NOT IN (SELECT child_id FROM pql_folder_struct);

DELETE FROM pql_folder_id WHERE folder_id NOT IN (SELECT child_id FROM pql_folder_struct);

DELETE FROM jbpt_petri_nets WHERE external_id NOT IN (SELECT file_name FROM pql_folder_id);

RETURN 1;

END ;;

DELIMITER ;

/*!50003 SET sql_mode = @saved_sql_mode */ ;

/*!50003 SET character_set_client = @saved_cs_client */ ;

/*!50003 SET character_set_results = @saved_cs_results */ ;

/*!50003 SET collation_connection = @saved_col_connection */ ;

/*!50003 DROP FUNCTION IF EXISTS `pql_folder_move` */;

/*!50003 SET @saved_cs_client = @@character_set_client */ ;

/*!50003 SET @saved_cs_results = @@character_set_results */ ;

/*!50003 SET @saved_col_connection = @@collation_connection */ ;

/*!50003 SET character_set_client = utf8 */ ;

/*!50003 SET character_set_results = utf8 */ ;

/*!50003 SET collation_connection = utf8_general_ci */ ;

/*!50003 SET @saved_sql_mode = @@sql_mode */ ;

/*!50003 SET sql_mode = 'STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION' */ ;

DELIMITER ;;

CREATE DEFINER=`root`@`localhost` FUNCTION `pql_folder_move`(given_folder INT(11), new_parent INT(11)) RETURNS int(11)

UPDATE pql_folder_struct

SET parent_id = new_parent

WHERE child_id = given_folder;

RETURN 1;

END ;;

DELIMITER ;

/*!50003 SET sql_mode = @saved_sql_mode */ ;

/*!50003 SET character_set_client = @saved_cs_client */ ;

/*!50003 SET character_set_results = @saved_cs_results */ ;

/*!50003 SET collation_connection = @saved_col_connection */ ;

/*!50003 DROP FUNCTION IF EXISTS `pql_id_move` */;

/*!50003 SET @saved_cs_client = @@character_set_client */ ;

/*!50003 SET @saved_cs_results = @@character_set_results */ ;

/*!50003 SET @saved_col_connection = @@collation_connection */ ;

/*!50003 SET character_set_client = utf8 */ ;

/*!50003 SET character_set_results = utf8 */ ;

/*!50003 SET collation_connection = utf8_general_ci */ ;

/*!50003 SET @saved_sql_mode = @@sql_mode */ ;

/*!50003 SET sql_mode = 'STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION' */ ;

DELIMITER ;;

CREATE DEFINER=`root`@`localhost` FUNCTION `pql_id_move`(given_folder Varchar(60), new_parent INT(11)) RETURNS int(11)

UPDATE pql_folder_id

SET folder_id = new_parent

WHERE file_name = given_folder;

RETURN 1;

END ;;

DELIMITER ;

/*!50003 SET sql_mode = @saved_sql_mode */ ;

/*!50003 SET character_set_client = @saved_cs_client */ ;

/*!50003 SET character_set_results = @saved_cs_results */ ;

/*!50003 SET collation_connection = @saved_col_connection */ ;

/*!50003 DROP FUNCTION IF EXISTS `pql_index_bots_is_alive` */;

/*!50003 SET @saved_cs_client = @@character_set_client */ ;