+++ /dev/null
--
--DROP FUNCTION IF EXISTS person_get_action_type;
--
--DELIMITER $$
--CREATE FUNCTION person_get_action_type(in_id INT(11)) RETURNS VARCHAR(32) DETERMINISTIC
-- BEGIN
--
-- DECLARE v_ret VARCHAR(32);
-- SET v_ret= '';
-- SELECT action_type INTO v_ret FROM Person WHERE id = in_id LIMIT 1;
-- RETURN v_ret;
-- END $$
--DELIMITER ;
+++ /dev/null
--
--DROP FUNCTION IF EXISTS person_get_by_email;
--
--DELIMITER $$
--CREATE FUNCTION person_get_by_email(
-- in_addr VARCHAR(254)
--
--
-- ) RETURNS INT(11) DETERMINISTIC
-- BEGIN
--
-- DECLARE v_id INT(11);
-- SET v_id = 0;
-- SELECT id INTO v_id FROM Person WHERE email = in_addr LIMIT 1;
-- RETURN v_id;
--
-- END $$
--DELIMITER ;
+++ /dev/null
--
--DROP FUNCTION IF EXISTS person_get_company;
--
--DELIMITER $$
--CREATE FUNCTION person_get_company(
-- in_id INT(11)
-- ) RETURNS INT(11) DETERMINISTIC
-- BEGIN
--
-- DECLARE v_id INT(11);
-- SET v_id = 0;
-- SELECT company_id INTO v_id FROM Person WHERE id = in_id LIMIT 1;
-- RETURN v_id;
-- END $$
--DELIMITER ;
+++ /dev/null
--
--DROP FUNCTION IF EXISTS person_get_internal_id;
--
--DELIMITER $$
--CREATE FUNCTION person_get_internal_id(
-- in_addr VARCHAR(254)
--
--
-- ) RETURNS INT(11) DETERMINISTIC
-- BEGIN
--
-- DECLARE v_id INT(11);
-- DECLARE v_company_id INT(11);
-- SET v_id = 0;
-- SET v_company_id = 0;
--
-- SELECT company_get_owner() INTO v_company_id;
-- IF v_company_id < 1 THEN
-- RETURN 0;
-- END IF;
--
-- SELECT id INTO v_id FROM Person WHERE
-- company_id = v_company_id
-- AND email = in_addr LIMIT 1;
--
-- RETURN v_id;
--
--
--
--
-- END $$
--DELIMITER ;
+++ /dev/null
--
--
--DROP FUNCTION IF EXISTS person_get_name;
--
--DELIMITER $$
--CREATE FUNCTION person_get_name(in_id INT(11)) RETURNS VARCHAR(254) DETERMINISTIC
-- BEGIN
--
-- DECLARE v_ret VARCHAR(254);
-- SET v_ret= '';
-- SELECT name INTO v_ret FROM Person WHERE id = in_id LIMIT 1;
-- RETURN v_ret;
-- END $$
--DELIMITER ;
+++ /dev/null
--
--
--DROP FUNCTION IF EXISTS person_get_project_id;
--
--DELIMITER $$
--CREATE FUNCTION person_get_project_id(
-- in_id INT(11)
-- ) RETURNS INT(11) DETERMINISTIC
-- BEGIN
--
-- DECLARE v_id INT(11);
-- SET v_id = 0;
-- SELECT project_id INTO v_id FROM Person WHERE id = in_id LIMIT 1;
-- RETURN v_id;
-- END $$
--
--
--DELIMITER ;
+++ /dev/null
--
--
--
--DROP FUNCTION IF EXISTS person_has_perm;
--
--DELIMITER $$
--CREATE FUNCTION person_has_perm(
-- in_person_id INT(11),
-- in_perm_name VARCHAR(64),
-- in_perm_level VARCHAR(1)
-- ) RETURNS INT(11) DETERMINISTIC
-- BEGIN
--
-- DECLARE v_id INT(11);
-- SET v_id = 0;
-- SELECT
-- group_members.id INTO v_id
-- FROM
-- group_rights
-- LEFT JOIN
-- group_members
-- ON
-- group_rights.group_id = group_members.group_id
-- WHERE
-- group_rights.rightname= in_perm_name AND
-- accessmask LIKE CONCAT('%', in_perm_level, '%') AND user_id = in_person_id LIMIT 1;
--
-- RETURN v_id;
-- END $$
--DELIMITER ;
+++ /dev/null
--
--DROP FUNCTION IF EXISTS project_get_type;
--DELIMITER $$
--CREATE FUNCTION project_get_type(in_id INT(11)) RETURNS VARCHAR(2) DETERMINISTIC
-- BEGIN
-- DECLARE v_ret VARCHAR(2);
-- SET v_ret= '';
-- SELECT type INTO v_ret FROM Projects WHERE id = in_id LIMIT 1;
-- RETURN v_ret;
-- END $$
--DELIMITER ;