From 4ceac2d4efa5a16486b6e97911bb32e261b9d648 Mon Sep 17 00:00:00 2001
From: admin <devnull@localhost>
Date: Mon, 25 Sep 2006 06:40:16 +0000
Subject:

---
 system/database/drivers/mssql/mssql_utility.php     | 17 +++++++++++++++--
 system/database/drivers/mysql/mysql_utility.php     | 17 +++++++++++++++--
 system/database/drivers/mysqli/mysqli_utility.php   | 17 +++++++++++++++--
 system/database/drivers/oci8/oci8_utility.php       | 12 ++++++++++++
 system/database/drivers/odbc/odbc_utility.php       | 18 ++++++++++++++++++
 system/database/drivers/postgre/postgre_utility.php | 17 +++++++++++++++--
 system/database/drivers/sqlite/sqlite_utility.php   | 17 +++++++++++++++++
 7 files changed, 107 insertions(+), 8 deletions(-)

(limited to 'system/database/drivers')

diff --git a/system/database/drivers/mssql/mssql_utility.php b/system/database/drivers/mssql/mssql_utility.php
index bc398e7f7..61fe5fcbc 100644
--- a/system/database/drivers/mssql/mssql_utility.php
+++ b/system/database/drivers/mssql/mssql_utility.php
@@ -34,7 +34,7 @@ class CI_DB_mssql_utility extends CI_DB_utility {
 	 */
 	function create_database($name)
 	{
-		return $this->db->query("CREATE DATABASE ".$this->db->_escape_table($name));
+		return $this->db->query("CREATE DATABASE ".$name);
 	}
 
 	// --------------------------------------------------------------------
@@ -48,7 +48,7 @@ class CI_DB_mssql_utility extends CI_DB_utility {
 	 */
 	function drop_database($name)
 	{
-		return $this->db->query("DROP DATABASE ".$this->db->_escape_table($name));
+		return $this->db->query("DROP DATABASE ".$name);
 	}
 
 	// --------------------------------------------------------------------
@@ -74,6 +74,19 @@ class CI_DB_mssql_utility extends CI_DB_utility {
 		return $dbs;
 	}
 
+	// --------------------------------------------------------------------
+
+	/**
+	 * Drop Table
+	 *
+	 * @access	public
+	 * @return	bool
+	 */
+	function drop_table($table)
+	{
+		"DROP TABLE ".$this->db->_escape_table($name);
+	}
+
 	// --------------------------------------------------------------------
 	
 	/**
diff --git a/system/database/drivers/mysql/mysql_utility.php b/system/database/drivers/mysql/mysql_utility.php
index 5bbf46810..23c4e094d 100644
--- a/system/database/drivers/mysql/mysql_utility.php
+++ b/system/database/drivers/mysql/mysql_utility.php
@@ -33,7 +33,7 @@ class CI_DB_mysql_utility extends CI_DB_utility {
 	 */
 	function create_database($name)
 	{
-		return $this->db->query("CREATE DATABASE ".$this->db->_escape_table($name));
+		return $this->db->query("CREATE DATABASE ".$name);
 	}
 
 	// --------------------------------------------------------------------
@@ -47,7 +47,7 @@ class CI_DB_mysql_utility extends CI_DB_utility {
 	 */
 	function drop_database($name)
 	{
-		return $this->db->query("DROP DATABASE ".$this->db->_escape_table($name));
+		return $this->db->query("DROP DATABASE ".$name);
 	}
 
 	// --------------------------------------------------------------------
@@ -75,6 +75,19 @@ class CI_DB_mysql_utility extends CI_DB_utility {
 
 	// --------------------------------------------------------------------
 
+	/**
+	 * Drop Table
+	 *
+	 * @access	public
+	 * @return	bool
+	 */
+	function drop_table($table)
+	{
+		"DROP TABLE IF EXISTS ".$this->db->_escape_table($name);
+	}
+
+	// --------------------------------------------------------------------
+
 	/**
 	 * Version number query string
 	 *
diff --git a/system/database/drivers/mysqli/mysqli_utility.php b/system/database/drivers/mysqli/mysqli_utility.php
index 14a6ef8cf..ca8f3fe34 100644
--- a/system/database/drivers/mysqli/mysqli_utility.php
+++ b/system/database/drivers/mysqli/mysqli_utility.php
@@ -33,7 +33,7 @@ class CI_DB_mysqli_utility extends CI_DB_utility {
 	 */
 	function create_database($name)
 	{
-		return $this->db->query("CREATE DATABASE ".$this->db->_escape_table($name));
+		return $this->db->query("CREATE DATABASE ".$name);
 	}
 
 	// --------------------------------------------------------------------
@@ -47,7 +47,7 @@ class CI_DB_mysqli_utility extends CI_DB_utility {
 	 */
 	function drop_database($name)
 	{
-		return $this->db->query("DROP DATABASE ".$this->db->_escape_table($name));
+		return $this->db->query("DROP DATABASE ".$name);
 	}
 
 	// --------------------------------------------------------------------
@@ -72,6 +72,19 @@ class CI_DB_mysqli_utility extends CI_DB_utility {
 			
 		return $dbs;
 	}
+	
+	// --------------------------------------------------------------------
+
+	/**
+	 * Drop Table
+	 *
+	 * @access	public
+	 * @return	bool
+	 */
+	function drop_table($table)
+	{
+		"DROP TABLE IF EXISTS ".$this->db->_escape_table($name);
+	}
 
 	// --------------------------------------------------------------------
 
diff --git a/system/database/drivers/oci8/oci8_utility.php b/system/database/drivers/oci8/oci8_utility.php
index 03edcb2c8..7e3ee7285 100644
--- a/system/database/drivers/oci8/oci8_utility.php
+++ b/system/database/drivers/oci8/oci8_utility.php
@@ -63,6 +63,18 @@ class CI_DB_oci8_utility extends CI_DB_utility {
 
 	// --------------------------------------------------------------------
 
+	/**
+	 * Drop Table
+	 *
+	 * @access	public
+	 * @return	bool
+	 */
+	function drop_table($table)
+	{
+	}
+
+	// --------------------------------------------------------------------
+
     /**
      * Version number query string
      *
diff --git a/system/database/drivers/odbc/odbc_utility.php b/system/database/drivers/odbc/odbc_utility.php
index 42537de70..cfd829cb6 100644
--- a/system/database/drivers/odbc/odbc_utility.php
+++ b/system/database/drivers/odbc/odbc_utility.php
@@ -83,6 +83,24 @@ class CI_DB_odbc_utility extends CI_DB_utility {
 
 	// --------------------------------------------------------------------
 
+	/**
+	 * Drop Table
+	 *
+	 * @access	public
+	 * @return	bool
+	 */
+	function drop_table($table)
+	{
+		// Not a supported ODBC feature	
+		if ($this->db_debug)
+		{
+			return $this->display_error('db_unsuported_feature');
+		}
+		return FALSE;
+	}
+
+	// --------------------------------------------------------------------
+
 	/**
 	 * Version number query string
 	 *
diff --git a/system/database/drivers/postgre/postgre_utility.php b/system/database/drivers/postgre/postgre_utility.php
index 103f8d553..7bb210ab7 100644
--- a/system/database/drivers/postgre/postgre_utility.php
+++ b/system/database/drivers/postgre/postgre_utility.php
@@ -34,7 +34,7 @@ class CI_DB_postgre_utility extends CI_DB_utility {
 	 */
 	function create_database($name)
 	{
-		return $this->db->query("CREATE DATABASE ".$this->db->_escape_table($name));
+		return $this->db->query("CREATE DATABASE ".$name);
 	}
 
 	// --------------------------------------------------------------------
@@ -48,7 +48,7 @@ class CI_DB_postgre_utility extends CI_DB_utility {
 	 */
 	function drop_database($name)
 	{
-		return $this->db->query("DROP DATABASE ".$this->db->_escape_table($name));
+		return $this->db->query("DROP DATABASE ".$name);
 	}
 
 	// --------------------------------------------------------------------
@@ -73,6 +73,19 @@ class CI_DB_postgre_utility extends CI_DB_utility {
 			
 		return $dbs;
 	}
+	
+	// --------------------------------------------------------------------
+
+	/**
+	 * Drop Table
+	 *
+	 * @access	public
+	 * @return	bool
+	 */
+	function drop_table($table)
+	{
+		"DROP TABLE ".$this->db->_escape_table($name)." CASCADE";
+	}
 
 	// --------------------------------------------------------------------
 
diff --git a/system/database/drivers/sqlite/sqlite_utility.php b/system/database/drivers/sqlite/sqlite_utility.php
index 5f1f02eab..744ca3f37 100644
--- a/system/database/drivers/sqlite/sqlite_utility.php
+++ b/system/database/drivers/sqlite/sqlite_utility.php
@@ -79,6 +79,23 @@ class CI_DB_sqlite_utility extends CI_DB_utility {
 
 	// --------------------------------------------------------------------
 
+	/**
+	 * Drop Table
+	 *
+	 * @access	public
+	 * @return	bool
+	 */
+	function drop_table($table)
+	{
+		if ($this->db_debug)
+		{
+			return $this->display_error('db_unsuported_feature');
+		}
+		return array();
+	}
+
+	// --------------------------------------------------------------------
+
 	/**
 	 * Version number query string
 	 *
-- 
cgit v1.2.3-24-g4f1b