<?php if (!defined('BASEPATH')) exit('No direct script access allowed'); /** * Code Igniter * * An open source application development framework for PHP 4.3.2 or newer * * @package CodeIgniter * @author Rick Ellis * @copyright Copyright (c) 2006, pMachine, Inc. * @license http://www.codeignitor.com/user_guide/license.html * @link http://www.codeigniter.com * @since Version 1.0 * @filesource */ // ------------------------------------------------------------------------ /** * MS SQL Utility Class * * @category Database * @author Rick Ellis * @link http://www.codeigniter.com/user_guide/database/ */ class CI_DB_mssql_utility extends CI_DB_utility { /** * Create database * * @access private * @param string the database name * @return bool */ function _create_database($name) { return "CREATE DATABASE ".$name; } // -------------------------------------------------------------------- /** * Drop database * * @access private * @param string the database name * @return bool */ function _drop_database($name) { return "DROP DATABASE ".$name; } // -------------------------------------------------------------------- /** * Drop Table * * @access private * @return bool */ function _drop_table($table) { return "DROP TABLE ".$this->db->_escape_table($name); } // -------------------------------------------------------------------- /** * List databases * * @access private * @return bool */ function _list_databases() { return "EXEC sp_helpdb"; // Can also be: EXEC sp_databases } // -------------------------------------------------------------------- /** * Optimize table query * * Generates a platform-specific query so that a table can be optimized * * @access private * @param string the table name * @return object */ function _optimize_table($table) { return FALSE; // Is this supported in MS SQL? } // -------------------------------------------------------------------- /** * Repair table query * * Generates a platform-specific query so that a table can be repaired * * @access private * @param string the table name * @return object */ function _repair_table($table) { return return FALSE; // Is this supported in MS SQL? } // -------------------------------------------------------------------- /** * MSSQL Export * * @access private * @param array Preferences * @return mixed */ function _backup($params = array()) { // Currently unsupported return $this->db->display_error('db_unsuported_feature'); } } ?>