mysql/mysql_change_charset.sql

diff --git a/mysql/companies_owner_create.sql b/mysql/companies_owner_create.sql
deleted file mode 100644 (file)
index 6ba25a4..0000000
--- a/mysql/companies_owner_create.sql
+++ /dev/null
@@ -1,23 +0,0 @@
-
-DROP FUNCTION  IF EXISTS companies_owner_create;
-    
-DELIMITER $$
-CREATE FUNCTION companies_owner_create(in_code  VARCHAR(32) , in_name VARCHAR(64)) RETURNS VARCHAR(64) DETERMINISTIC
-BEGIN
-    DECLARE v_id INT(11);
-    SET v_id = 0;
-    #// check if person exists..
-    SELECT id INTO v_id FROM Companies
-        WHERE comptype='OWNER' LIMIT 1;
-
-    IF v_id  != 0 THEN
-        RETURN CONCAT('DUPE - Company', in_name);
-    END IF;
-    
-    INSERT INTO Companies (code, name, comptype, comptype_id) VALUES (
-        in_code,in_name,'OWNER', core_enum_id_by_name('COMPTYPE', 'OWNER' )
-    );
-        
-    RETURN 'ADDED';
-END $$
-DELIMITER ;
\ No newline at end of file

diff --git a/mysql/company_get_by_name.sql b/mysql/company_get_by_name.sql
deleted file mode 100644 (file)
index dae31df..0000000
--- a/mysql/company_get_by_name.sql
+++ /dev/null
@@ -1,12 +0,0 @@
-
- 
-DROP FUNCTION IF EXISTS company_get_by_name;
-DELIMITER $$
-CREATE FUNCTION company_get_by_name(in_name VARCHAR(128))  RETURNS INT(11) DETERMINISTIC
-    BEGIN
-        DECLARE v_ret INT(11);
-        SET v_ret= 0;
-        SELECT id    INTO v_ret  FROM Companies WHERE name = in_name LIMIT 1;
-        RETURN v_ret;
-    END $$
-DELIMITER ; 
\ No newline at end of file

diff --git a/mysql/company_get_name.sql b/mysql/company_get_name.sql
deleted file mode 100644 (file)
index de0eb14..0000000
--- a/mysql/company_get_name.sql
+++ /dev/null
@@ -1,12 +0,0 @@
-
- 
-DROP FUNCTION IF EXISTS company_get_name;
-DELIMITER $$
-CREATE FUNCTION company_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 Companies WHERE id = in_id LIMIT 1;
-        RETURN v_ret;
-    END $$
-DELIMITER ;
\ No newline at end of file

diff --git a/mysql/company_get_owner.sql b/mysql/company_get_owner.sql
deleted file mode 100644 (file)
index 29004bb..0000000
--- a/mysql/company_get_owner.sql
+++ /dev/null
@@ -1,12 +0,0 @@
-DROP FUNCTION IF EXISTS company_get_owner;
-
-DELIMITER $$
-CREATE FUNCTION company_get_owner()  RETURNS INT(11) DETERMINISTIC
-    BEGIN
-        DECLARE v_id INT(11);
-        SET v_id = 0;
-        SELECT id INTO v_id  FROM Companies WHERE isOwner = 1 LIMIT 1;
-        RETURN v_id;
-    END $$
-DELIMITER ;
-

diff --git a/mysql/company_get_owner_name.sql b/mysql/company_get_owner_name.sql
deleted file mode 100644 (file)
index 07a2149..0000000
--- a/mysql/company_get_owner_name.sql
+++ /dev/null
@@ -1,12 +0,0 @@
-
-DROP FUNCTION IF EXISTS company_get_owner_name;
-DELIMITER $$
-CREATE FUNCTION company_get_owner_name()  RETURNS VARCHAR(254) DETERMINISTIC
-    BEGIN
-        DECLARE v_ret VARCHAR(254);
-        SET v_ret= '';
-        SELECT name INTO v_ret  FROM Companies WHERE isOwner = 1 LIMIT 1;
-        RETURN v_ret;
-    END $$
-DELIMITER ;
- 
\ No newline at end of file

diff --git a/mysql/mysql_change_charset.sql b/mysql/mysql_change_charset.sql
deleted file mode 100644 (file)
index c2c2768..0000000
--- a/mysql/mysql_change_charset.sql
+++ /dev/null
@@ -1,5 +0,0 @@
-
-
-DROP PROCEDURE IF EXISTS mysql_change_charset;
- 
- -- this code has been moved to PHP as we force it on all tables now..
\ No newline at end of file