-<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');\r
-/**\r
- * CodeIgniter\r
- *\r
- * An open source application development framework for PHP 4.3.2 or newer\r
- *\r
- * @package CodeIgniter\r
- * @author ExpressionEngine Dev Team\r
- * @copyright Copyright (c) 2008, EllisLab, Inc.\r
- * @license http://codeigniter.com/user_guide/license.html\r
- * @link http://codeigniter.com\r
- * @since Version 1.0\r
- * @filesource\r
- */\r
-\r
-// ------------------------------------------------------------------------\r
-\r
-/**\r
- * MS SQL Forge Class\r
- *\r
- * @category Database\r
- * @author ExpressionEngine Dev Team\r
- * @link http://codeigniter.com/user_guide/database/\r
- */\r
-class CI_DB_mssql_forge extends CI_DB_forge {\r
-\r
- /**\r
- * Create database\r
- *\r
- * @access private\r
- * @param string the database name\r
- * @return bool\r
- */\r
- function _create_database($name)\r
- {\r
- return "CREATE DATABASE ".$name;\r
- }\r
-\r
- // --------------------------------------------------------------------\r
-\r
- /**\r
- * Drop database\r
- *\r
- * @access private\r
- * @param string the database name\r
- * @return bool\r
- */\r
- function _drop_database($name)\r
- {\r
- return "DROP DATABASE ".$name;\r
- }\r
-\r
- // --------------------------------------------------------------------\r
-\r
- /**\r
- * Drop Table\r
- *\r
- * @access private\r
- * @return bool\r
- */\r
- function _drop_table($table)\r
- {\r
- return "DROP TABLE ".$this->db->_escape_identifiers($table);\r
- }\r
-\r
- // --------------------------------------------------------------------\r
-\r
- /**\r
- * Create Table\r
- *\r
- * @access private\r
- * @param string the table name\r
- * @param array the fields\r
- * @param mixed primary key(s)\r
- * @param mixed key(s)\r
- * @param boolean should 'IF NOT EXISTS' be added to the SQL\r
- * @return bool\r
- */\r
- function _create_table($table, $fields, $primary_keys, $keys, $if_not_exists)\r
- {\r
- $sql = 'CREATE TABLE ';\r
- \r
- if ($if_not_exists === TRUE)\r
- {\r
- $sql .= 'IF NOT EXISTS ';\r
- }\r
- \r
- $sql .= $this->db->_escape_identifiers($table)." (";\r
- $current_field_count = 0;\r
-\r
- foreach ($fields as $field=>$attributes)\r
- {\r
- // Numeric field names aren't allowed in databases, so if the key is\r
- // numeric, we know it was assigned by PHP and the developer manually\r
- // entered the field information, so we'll simply add it to the list\r
- if (is_numeric($field))\r
- {\r
- $sql .= "\n\t$attributes";\r
- }\r
- else\r
- {\r
- $attributes = array_change_key_case($attributes, CASE_UPPER);\r
- \r
- $sql .= "\n\t".$this->db->_protect_identifiers($field);\r
- \r
- $sql .= ' '.$attributes['TYPE'];\r
- \r
- if (array_key_exists('CONSTRAINT', $attributes))\r
- {\r
- $sql .= '('.$attributes['CONSTRAINT'].')';\r
- }\r
- \r
- if (array_key_exists('UNSIGNED', $attributes) && $attributes['UNSIGNED'] === TRUE)\r
- {\r
- $sql .= ' UNSIGNED';\r
- }\r
- \r
- if (array_key_exists('DEFAULT', $attributes))\r
- {\r
- $sql .= ' DEFAULT \''.$attributes['DEFAULT'].'\'';\r
- }\r
- \r
- if (array_key_exists('NULL', $attributes) && $attributes['NULL'] === TRUE)\r
- {\r
- $sql .= ' NULL';\r
- }\r
- else\r
- {\r
- $sql .= ' NOT NULL'; \r
- }\r
- \r
- if (array_key_exists('AUTO_INCREMENT', $attributes) && $attributes['AUTO_INCREMENT'] === TRUE)\r
- {\r
- $sql .= ' AUTO_INCREMENT';\r
- }\r
- }\r
- \r
- // don't add a comma on the end of the last field\r
- if (++$current_field_count < count($fields))\r
- {\r
- $sql .= ',';\r
- }\r
- }\r
-\r
- if (count($primary_keys) > 0)\r
- {\r
- $primary_keys = $this->db->_protect_identifiers($primary_keys);\r
- $sql .= ",\n\tPRIMARY KEY (" . implode(', ', $primary_keys) . ")";\r
- }\r
- \r
- if (is_array($keys) && count($keys) > 0)\r
- {\r
- foreach ($keys as $key)\r
- {\r
- if (is_array($key))\r
- {\r
- $key = $this->db->_protect_identifiers($key); \r
- }\r
- else\r
- {\r
- $key = array($this->db->_protect_identifiers($key));\r
- }\r
- \r
- $sql .= ",\n\tFOREIGN KEY (" . implode(', ', $key) . ")";\r
- }\r
- }\r
- \r
- $sql .= "\n)";\r
-\r
- return $sql;\r
- }\r
-\r
- // --------------------------------------------------------------------\r
-\r
- /**\r
- * Alter table query\r
- *\r
- * Generates a platform-specific query so that a table can be altered\r
- * Called by add_column(), drop_column(), and column_alter(),\r
- *\r
- * @access private\r
- * @param string the ALTER type (ADD, DROP, CHANGE)\r
- * @param string the column name\r
- * @param string the table name\r
- * @param string the column definition\r
- * @param string the default value\r
- * @param boolean should 'NOT NULL' be added\r
- * @param string the field after which we should add the new field\r
- * @return object\r
- */\r
- function _alter_table($alter_type, $table, $column_name, $column_definition = '', $default_value = '', $null = '', $after_field = '')\r
- {\r
- $sql = 'ALTER TABLE '.$this->db->_protect_identifiers($table)." $alter_type ".$this->db->_protect_identifiers($column_name);\r
-\r
- // DROP has everything it needs now.\r
- if ($alter_type == 'DROP')\r
- {\r
- return $sql;\r
- }\r
-\r
- $sql .= " $column_definition";\r
-\r
- if ($default_value != '')\r
- {\r
- $sql .= " DEFAULT \"$default_value\"";\r
- }\r
-\r
- if ($null === NULL)\r
- {\r
- $sql .= ' NULL';\r
- }\r
- else\r
- {\r
- $sql .= ' NOT NULL';\r
- }\r
-\r
- if ($after_field != '')\r
- {\r
- $sql .= ' AFTER ' . $this->db->_protect_identifiers($after_field);\r
- }\r
- \r
- return $sql;\r
- \r
- }\r
-\r
- // --------------------------------------------------------------------\r
-\r
- /**\r
- * Rename a table\r
- *\r
- * Generates a platform-specific query so that a table can be renamed\r
- *\r
- * @access private\r
- * @param string the old table name\r
- * @param string the new table name\r
- * @return string\r
- */\r
- function _rename_table($table_name, $new_table_name)\r
- {\r
- // I think this syntax will work, but can find little documentation on renaming tables in MSSQL\r
- $sql = 'ALTER TABLE '.$this->db->_protect_identifiers($table_name)." RENAME TO ".$this->db->_protect_identifiers($new_table_name);\r
- return $sql;\r
- }\r
-\r
-}\r
-\r
-/* End of file mssql_forge.php */\r
+<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');
+/**
+ * CodeIgniter
+ *
+ * An open source application development framework for PHP 4.3.2 or newer
+ *
+ * @package CodeIgniter
+ * @author ExpressionEngine Dev Team
+ * @copyright Copyright (c) 2008 - 2009, EllisLab, Inc.
+ * @license http://codeigniter.com/user_guide/license.html
+ * @link http://codeigniter.com
+ * @since Version 1.0
+ * @filesource
+ */
+
+// ------------------------------------------------------------------------
+
+/**
+ * MS SQL Forge Class
+ *
+ * @category Database
+ * @author ExpressionEngine Dev Team
+ * @link http://codeigniter.com/user_guide/database/
+ */
+class CI_DB_mssql_forge extends CI_DB_forge {
+
+ /**
+ * 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_identifiers($table);
+ }
+
+ // --------------------------------------------------------------------
+
+ /**
+ * Create Table
+ *
+ * @access private
+ * @param string the table name
+ * @param array the fields
+ * @param mixed primary key(s)
+ * @param mixed key(s)
+ * @param boolean should 'IF NOT EXISTS' be added to the SQL
+ * @return bool
+ */
+ function _create_table($table, $fields, $primary_keys, $keys, $if_not_exists)
+ {
+ $sql = 'CREATE TABLE ';
+
+ if ($if_not_exists === TRUE)
+ {
+ $sql .= 'IF NOT EXISTS ';
+ }
+
+ $sql .= $this->db->_escape_identifiers($table)." (";
+ $current_field_count = 0;
+
+ foreach ($fields as $field=>$attributes)
+ {
+ // Numeric field names aren't allowed in databases, so if the key is
+ // numeric, we know it was assigned by PHP and the developer manually
+ // entered the field information, so we'll simply add it to the list
+ if (is_numeric($field))
+ {
+ $sql .= "\n\t$attributes";
+ }
+ else
+ {
+ $attributes = array_change_key_case($attributes, CASE_UPPER);
+
+ $sql .= "\n\t".$this->db->_protect_identifiers($field);
+
+ $sql .= ' '.$attributes['TYPE'];
+
+ if (array_key_exists('CONSTRAINT', $attributes))
+ {
+ $sql .= '('.$attributes['CONSTRAINT'].')';
+ }
+
+ if (array_key_exists('UNSIGNED', $attributes) && $attributes['UNSIGNED'] === TRUE)
+ {
+ $sql .= ' UNSIGNED';
+ }
+
+ if (array_key_exists('DEFAULT', $attributes))
+ {
+ $sql .= ' DEFAULT \''.$attributes['DEFAULT'].'\'';
+ }
+
+ if (array_key_exists('NULL', $attributes) && $attributes['NULL'] === TRUE)
+ {
+ $sql .= ' NULL';
+ }
+ else
+ {
+ $sql .= ' NOT NULL';
+ }
+
+ if (array_key_exists('AUTO_INCREMENT', $attributes) && $attributes['AUTO_INCREMENT'] === TRUE)
+ {
+ $sql .= ' AUTO_INCREMENT';
+ }
+ }
+
+ // don't add a comma on the end of the last field
+ if (++$current_field_count < count($fields))
+ {
+ $sql .= ',';
+ }
+ }
+
+ if (count($primary_keys) > 0)
+ {
+ $primary_keys = $this->db->_protect_identifiers($primary_keys);
+ $sql .= ",\n\tPRIMARY KEY (" . implode(', ', $primary_keys) . ")";
+ }
+
+ if (is_array($keys) && count($keys) > 0)
+ {
+ foreach ($keys as $key)
+ {
+ if (is_array($key))
+ {
+ $key = $this->db->_protect_identifiers($key);
+ }
+ else
+ {
+ $key = array($this->db->_protect_identifiers($key));
+ }
+
+ $sql .= ",\n\tFOREIGN KEY (" . implode(', ', $key) . ")";
+ }
+ }
+
+ $sql .= "\n)";
+
+ return $sql;
+ }
+
+ // --------------------------------------------------------------------
+
+ /**
+ * Alter table query
+ *
+ * Generates a platform-specific query so that a table can be altered
+ * Called by add_column(), drop_column(), and column_alter(),
+ *
+ * @access private
+ * @param string the ALTER type (ADD, DROP, CHANGE)
+ * @param string the column name
+ * @param string the table name
+ * @param string the column definition
+ * @param string the default value
+ * @param boolean should 'NOT NULL' be added
+ * @param string the field after which we should add the new field
+ * @return object
+ */
+ function _alter_table($alter_type, $table, $column_name, $column_definition = '', $default_value = '', $null = '', $after_field = '')
+ {
+ $sql = 'ALTER TABLE '.$this->db->_protect_identifiers($table)." $alter_type ".$this->db->_protect_identifiers($column_name);
+
+ // DROP has everything it needs now.
+ if ($alter_type == 'DROP')
+ {
+ return $sql;
+ }
+
+ $sql .= " $column_definition";
+
+ if ($default_value != '')
+ {
+ $sql .= " DEFAULT \"$default_value\"";
+ }
+
+ if ($null === NULL)
+ {
+ $sql .= ' NULL';
+ }
+ else
+ {
+ $sql .= ' NOT NULL';
+ }
+
+ if ($after_field != '')
+ {
+ $sql .= ' AFTER ' . $this->db->_protect_identifiers($after_field);
+ }
+
+ return $sql;
+
+ }
+
+ // --------------------------------------------------------------------
+
+ /**
+ * Rename a table
+ *
+ * Generates a platform-specific query so that a table can be renamed
+ *
+ * @access private
+ * @param string the old table name
+ * @param string the new table name
+ * @return string
+ */
+ function _rename_table($table_name, $new_table_name)
+ {
+ // I think this syntax will work, but can find little documentation on renaming tables in MSSQL
+ $sql = 'ALTER TABLE '.$this->db->_protect_identifiers($table_name)." RENAME TO ".$this->db->_protect_identifiers($new_table_name);
+ return $sql;
+ }
+
+}
+
+/* End of file mssql_forge.php */
/* Location: ./system/database/drivers/mssql/mssql_forge.php */
\ No newline at end of file