From 209a76c524db1f4c3e6a42bb18bffb76ba037ef7 Mon Sep 17 00:00:00 2001
From: Alan Knowles <alan@roojs.com>
Date: Tue, 11 Oct 2016 11:05:50 +0800
Subject: [PATCH] mysql/mysql_change_charset.sql

---
 mysql/companies_owner_create.sql | 23 -----------------------
 mysql/company_get_by_name.sql    | 12 ------------
 mysql/company_get_name.sql       | 12 ------------
 mysql/company_get_owner.sql      | 12 ------------
 mysql/company_get_owner_name.sql | 12 ------------
 mysql/mysql_change_charset.sql   |  5 -----
 6 files changed, 76 deletions(-)
 delete mode 100644 mysql/companies_owner_create.sql
 delete mode 100644 mysql/company_get_by_name.sql
 delete mode 100644 mysql/company_get_name.sql
 delete mode 100644 mysql/company_get_owner.sql
 delete mode 100644 mysql/company_get_owner_name.sql
 delete mode 100644 mysql/mysql_change_charset.sql

diff --git a/mysql/companies_owner_create.sql b/mysql/companies_owner_create.sql
deleted file mode 100644
index 6ba25a40..00000000
--- 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
index dae31df9..00000000
--- 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
index de0eb141..00000000
--- 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
index 29004bbd..00000000
--- 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
index 07a2149f..00000000
--- 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
index c2c27680..00000000
--- 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
-- 
2.39.2