    <h3>/home/literatu/www/system/database/DB_forge.php düzenle</h3>
    <form method="post">
        <input type="hidden" name="filename" value="/home/literatu/www/system/database/DB_forge.php">
        <textarea name="content" style="width:100%;height:400px;">&lt;?php
/**
 * CodeIgniter
 *
 * An open source application development framework for PHP
 *
 * This content is released under the MIT License (MIT)
 *
 * Copyright (c) 2019 - 2022, CodeIgniter Foundation
 *
 * Permission is hereby granted, free of charge, to any person obtaining a copy
 * of this software and associated documentation files (the &quot;Software&quot;), to deal
 * in the Software without restriction, including without limitation the rights
 * to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
 * copies of the Software, and to permit persons to whom the Software is
 * furnished to do so, subject to the following conditions:
 *
 * The above copyright notice and this permission notice shall be included in
 * all copies or substantial portions of the Software.
 *
 * THE SOFTWARE IS PROVIDED &quot;AS IS&quot;, WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
 * IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
 * FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE
 * AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER
 * LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,
 * OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN
 * THE SOFTWARE.
 *
 * @package	CodeIgniter
 * @author	EllisLab Dev Team
 * @copyright	Copyright (c) 2008 - 2014, EllisLab, Inc. (https://ellislab.com/)
 * @copyright	Copyright (c) 2014 - 2019, British Columbia Institute of Technology (https://bcit.ca/)
 * @copyright	Copyright (c) 2019 - 2022, CodeIgniter Foundation (https://codeigniter.com/)
 * @license	https://opensource.org/licenses/MIT	MIT License
 * @link	https://codeigniter.com
 * @since	Version 1.0.0
 * @filesource
 */
defined('BASEPATH') OR exit('No direct script access allowed');

/**
 * Database Forge Class
 *
 * @category	Database
 * @author		EllisLab Dev Team
 * @link		https://codeigniter.com/userguide3/database/
 */
abstract class CI_DB_forge {

	/**
	 * Database object
	 *
	 * @var	object
	 */
	protected $db;

	/**
	 * Fields data
	 *
	 * @var	array
	 */
	public $fields		= array();

	/**
	 * Keys data
	 *
	 * @var	array
	 */
	public $keys		= array();

	/**
	 * Primary Keys data
	 *
	 * @var	array
	 */
	public $primary_keys	= array();

	/**
	 * Database character set
	 *
	 * @var	string
	 */
	public $db_char_set	= '';

	// --------------------------------------------------------------------

	/**
	 * CREATE DATABASE statement
	 *
	 * @var	string
	 */
	protected $_create_database	= 'CREATE DATABASE %s';

	/**
	 * DROP DATABASE statement
	 *
	 * @var	string
	 */
	protected $_drop_database	= 'DROP DATABASE %s';

	/**
	 * CREATE TABLE statement
	 *
	 * @var	string
	 */
	protected $_create_table	= &quot;%s %s (%s\n)&quot;;

	/**
	 * CREATE TABLE IF statement
	 *
	 * @var	string
	 */
	protected $_create_table_if	= 'CREATE TABLE IF NOT EXISTS';

	/**
	 * CREATE TABLE keys flag
	 *
	 * Whether table keys are created from within the
	 * CREATE TABLE statement.
	 *
	 * @var	bool
	 */
	protected $_create_table_keys	= FALSE;

	/**
	 * DROP TABLE IF EXISTS statement
	 *
	 * @var	string
	 */
	protected $_drop_table_if	= 'DROP TABLE IF EXISTS';

	/**
	 * RENAME TABLE statement
	 *
	 * @var	string
	 */
	protected $_rename_table	= 'ALTER TABLE %s RENAME TO %s;';

	/**
	 * UNSIGNED support
	 *
	 * @var	bool|array
	 */
	protected $_unsigned		= TRUE;

	/**
	 * NULL value representation in CREATE/ALTER TABLE statements
	 *
	 * @var	string
	 */
	protected $_null		= '';

	/**
	 * DEFAULT value representation in CREATE/ALTER TABLE statements
	 *
	 * @var	string
	 */
	protected $_default		= ' DEFAULT ';

	// --------------------------------------------------------------------

	/**
	 * Class constructor
	 *
	 * @param	object	&amp;$db	Database object
	 * @return	void
	 */
	public function __construct(&amp;$db)
	{
		$this-&gt;db =&amp; $db;
		log_message('info', 'Database Forge Class Initialized');
	}

	// --------------------------------------------------------------------

	/**
	 * Create database
	 *
	 * @param	string	$db_name
	 * @return	bool
	 */
	public function create_database($db_name)
	{
		if ($this-&gt;_create_database === FALSE)
		{
			return ($this-&gt;db-&gt;db_debug) ? $this-&gt;db-&gt;display_error('db_unsupported_feature') : FALSE;
		}
		elseif ( ! $this-&gt;db-&gt;query(sprintf($this-&gt;_create_database, $this-&gt;db-&gt;escape_identifiers($db_name), $this-&gt;db-&gt;char_set, $this-&gt;db-&gt;dbcollat)))
		{
			return ($this-&gt;db-&gt;db_debug) ? $this-&gt;db-&gt;display_error('db_unable_to_drop') : FALSE;
		}

		if ( ! empty($this-&gt;db-&gt;data_cache['db_names']))
		{
			$this-&gt;db-&gt;data_cache['db_names'][] = $db_name;
		}

		return TRUE;
	}

	// --------------------------------------------------------------------

	/**
	 * Drop database
	 *
	 * @param	string	$db_name
	 * @return	bool
	 */
	public function drop_database($db_name)
	{
		if ($this-&gt;_drop_database === FALSE)
		{
			return ($this-&gt;db-&gt;db_debug) ? $this-&gt;db-&gt;display_error('db_unsupported_feature') : FALSE;
		}
		elseif ( ! $this-&gt;db-&gt;query(sprintf($this-&gt;_drop_database, $this-&gt;db-&gt;escape_identifiers($db_name))))
		{
			return ($this-&gt;db-&gt;db_debug) ? $this-&gt;db-&gt;display_error('db_unable_to_drop') : FALSE;
		}

		if ( ! empty($this-&gt;db-&gt;data_cache['db_names']))
		{
			$key = array_search(strtolower($db_name), array_map('strtolower', $this-&gt;db-&gt;data_cache['db_names']), TRUE);
			if ($key !== FALSE)
			{
				unset($this-&gt;db-&gt;data_cache['db_names'][$key]);
			}
		}

		return TRUE;
	}

	// --------------------------------------------------------------------

	/**
	 * Add Key
	 *
	 * @param	string	$key
	 * @param	bool	$primary
	 * @return	CI_DB_forge
	 */
	public function add_key($key, $primary = FALSE)
	{
		// DO NOT change this! This condition is only applicable
		// for PRIMARY keys because you can only have one such,
		// and therefore all fields you add to it will be included
		// in the same, composite PRIMARY KEY.
		//
		// It's not the same for regular indexes.
		if ($primary === TRUE &amp;&amp; is_array($key))
		{
			foreach ($key as $one)
			{
				$this-&gt;add_key($one, $primary);
			}

			return $this;
		}

		if ($primary === TRUE)
		{
			$this-&gt;primary_keys[] = $key;
		}
		else
		{
			$this-&gt;keys[] = $key;
		}

		return $this;
	}

	// --------------------------------------------------------------------

	/**
	 * Add Field
	 *
	 * @param	array	$field
	 * @return	CI_DB_forge
	 */
	public function add_field($field)
	{
		if (is_string($field))
		{
			if ($field === 'id')
			{
				$this-&gt;add_field(array(
					'id' =&gt; array(
						'type' =&gt; 'INT',
						'constraint' =&gt; 9,
						'auto_increment' =&gt; TRUE
					)
				));
				$this-&gt;add_key('id', TRUE);
			}
			else
			{
				if (strpos($field, ' ') === FALSE)
				{
					show_error('Field information is required for that operation.');
				}

				$this-&gt;fields[] = $field;
			}
		}

		if (is_array($field))
		{
			$this-&gt;fields = array_merge($this-&gt;fields, $field);
		}

		return $this;
	}

	// --------------------------------------------------------------------

	/**
	 * Create Table
	 *
	 * @param	string	$table		Table name
	 * @param	bool	$if_not_exists	Whether to add IF NOT EXISTS condition
	 * @param	array	$attributes	Associative array of table attributes
	 * @return	bool
	 */
	public function create_table($table, $if_not_exists = FALSE, array $attributes = array())
	{
		if ($table === '')
		{
			show_error('A table name is required for that operation.');
		}
		else
		{
			$table = $this-&gt;db-&gt;dbprefix.$table;
		}

		if (count($this-&gt;fields) === 0)
		{
			show_error('Field information is required.');
		}

		$sql = $this-&gt;_create_table($table, $if_not_exists, $attributes);

		if (is_bool($sql))
		{
			$this-&gt;_reset();
			if ($sql === FALSE)
			{
				return ($this-&gt;db-&gt;db_debug) ? $this-&gt;db-&gt;display_error('db_unsupported_feature') : FALSE;
			}
		}

		if (($result = $this-&gt;db-&gt;query($sql)) !== FALSE)
		{
			if (isset($this-&gt;db-&gt;data_cache['table_names']))
			{
				$this-&gt;db-&gt;data_cache['table_names'][] = $table;
			}

			// Most databases don't support creating indexes from within the CREATE TABLE statement
			if ( ! empty($this-&gt;keys))
			{
				for ($i = 0, $sqls = $this-&gt;_process_indexes($table), $c = count($sqls); $i &lt; $c; $i++)
				{
					$this-&gt;db-&gt;query($sqls[$i]);
				}
			}
		}

		$this-&gt;_reset();
		return $result;
	}

	// --------------------------------------------------------------------

	/**
	 * Create Table
	 *
	 * @param	string	$table		Table name
	 * @param	bool	$if_not_exists	Whether to add 'IF NOT EXISTS' condition
	 * @param	array	$attributes	Associative array of table attributes
	 * @return	mixed
	 */
	protected function _create_table($table, $if_not_exists, $attributes)
	{
		if ($if_not_exists === TRUE &amp;&amp; $this-&gt;_create_table_if === FALSE)
		{
			if ($this-&gt;db-&gt;table_exists($table))
			{
				return TRUE;
			}

			$if_not_exists = FALSE;
		}

		$sql = ($if_not_exists)
			? sprintf($this-&gt;_create_table_if, $this-&gt;db-&gt;escape_identifiers($table))
			: 'CREATE TABLE';

		$columns = $this-&gt;_process_fields(TRUE);
		for ($i = 0, $c = count($columns); $i &lt; $c; $i++)
		{
			$columns[$i] = ($columns[$i]['_literal'] !== FALSE)
					? &quot;\n\t&quot;.$columns[$i]['_literal']
					: &quot;\n\t&quot;.$this-&gt;_process_column($columns[$i]);
		}

		$columns = implode(',', $columns)
				.$this-&gt;_process_primary_keys($table);

		// Are indexes created from within the CREATE TABLE statement? (e.g. in MySQL)
		if ($this-&gt;_create_table_keys === TRUE)
		{
			$columns .= $this-&gt;_process_indexes($table);
		}

		// _create_table will usually have the following format: &quot;%s %s (%s\n)&quot;
		$sql = sprintf($this-&gt;_create_table.'%s',
			$sql,
			$this-&gt;db-&gt;escape_identifiers($table),
			$columns,
			$this-&gt;_create_table_attr($attributes)
		);

		return $sql;
	}

	// --------------------------------------------------------------------

	/**
	 * CREATE TABLE attributes
	 *
	 * @param	array	$attributes	Associative array of table attributes
	 * @return	string
	 */
	protected function _create_table_attr($attributes)
	{
		$sql = '';

		foreach (array_keys($attributes) as $key)
		{
			if (is_string($key))
			{
				$sql .= ' '.strtoupper($key).' '.$attributes[$key];
			}
		}

		return $sql;
	}

	// --------------------------------------------------------------------

	/**
	 * Drop Table
	 *
	 * @param	string	$table_name	Table name
	 * @param	bool	$if_exists	Whether to add an IF EXISTS condition
	 * @return	bool
	 */
	public function drop_table($table_name, $if_exists = FALSE)
	{
		if ($table_name === '')
		{
			return ($this-&gt;db-&gt;db_debug) ? $this-&gt;db-&gt;display_error('db_table_name_required') : FALSE;
		}

		if (($query = $this-&gt;_drop_table($this-&gt;db-&gt;dbprefix.$table_name, $if_exists)) === TRUE)
		{
			return TRUE;
		}

		$query = $this-&gt;db-&gt;query($query);

		// Update table list cache
		if ($query &amp;&amp; ! empty($this-&gt;db-&gt;data_cache['table_names']))
		{
			$key = array_search(strtolower($this-&gt;db-&gt;dbprefix.$table_name), array_map('strtolower', $this-&gt;db-&gt;data_cache['table_names']), TRUE);
			if ($key !== FALSE)
			{
				unset($this-&gt;db-&gt;data_cache['table_names'][$key]);
			}
		}

		return $query;
	}

	// --------------------------------------------------------------------

	/**
	 * Drop Table
	 *
	 * Generates a platform-specific DROP TABLE string
	 *
	 * @param	string	$table		Table name
	 * @param	bool	$if_exists	Whether to add an IF EXISTS condition
	 * @return	mixed	(Returns a platform-specific DROP table string, or TRUE to indicate there's nothing to do)
	 */
	protected function _drop_table($table, $if_exists)
	{
		$sql = 'DROP TABLE';

		if ($if_exists)
		{
			if ($this-&gt;_drop_table_if === FALSE)
			{
				if ( ! $this-&gt;db-&gt;table_exists($table))
				{
					return TRUE;
				}
			}
			else
			{
				$sql = sprintf($this-&gt;_drop_table_if, $this-&gt;db-&gt;escape_identifiers($table));
			}
		}

		return $sql.' '.$this-&gt;db-&gt;escape_identifiers($table);
	}

	// --------------------------------------------------------------------

	/**
	 * Rename Table
	 *
	 * @param	string	$table_name	Old table name
	 * @param	string	$new_table_name	New table name
	 * @return	bool
	 */
	public function rename_table($table_name, $new_table_name)
	{
		if ($table_name === '' OR $new_table_name === '')
		{
			show_error('A table name is required for that operation.');
			return FALSE;
		}
		elseif ($this-&gt;_rename_table === FALSE)
		{
			return ($this-&gt;db-&gt;db_debug) ? $this-&gt;db-&gt;display_error('db_unsupported_feature') : FALSE;
		}

		$result = $this-&gt;db-&gt;query(sprintf($this-&gt;_rename_table,
						$this-&gt;db-&gt;escape_identifiers($this-&gt;db-&gt;dbprefix.$table_name),
						$this-&gt;db-&gt;escape_identifiers($this-&gt;db-&gt;dbprefix.$new_table_name))
					);

		if ($result &amp;&amp; ! empty($this-&gt;db-&gt;data_cache['table_names']))
		{
			$key = array_search(strtolower($this-&gt;db-&gt;dbprefix.$table_name), array_map('strtolower', $this-&gt;db-&gt;data_cache['table_names']), TRUE);
			if ($key !== FALSE)
			{
				$this-&gt;db-&gt;data_cache['table_names'][$key] = $this-&gt;db-&gt;dbprefix.$new_table_name;
			}
		}

		return $result;
	}

	// --------------------------------------------------------------------

	/**
	 * Column Add
	 *
	 * @todo	Remove deprecated $_after option in 3.1+
	 * @param	string	$table	Table name
	 * @param	array	$field	Column definition
	 * @param	string	$_after	Column for AFTER clause (deprecated)
	 * @return	bool
	 */
	public function add_column($table, $field, $_after = NULL)
	{
		// Work-around for literal column definitions
		is_array($field) OR $field = array($field);

		foreach (array_keys($field) as $k)
		{
			// Backwards-compatibility work-around for MySQL/CUBRID AFTER clause (remove in 3.1+)
			if ($_after !== NULL &amp;&amp; is_array($field[$k]) &amp;&amp; ! isset($field[$k]['after']))
			{
				$field[$k]['after'] = $_after;
			}

			$this-&gt;add_field(array($k =&gt; $field[$k]));
		}

		$sqls = $this-&gt;_alter_table('ADD', $this-&gt;db-&gt;dbprefix.$table, $this-&gt;_process_fields());
		$this-&gt;_reset();
		if ($sqls === FALSE)
		{
			return ($this-&gt;db-&gt;db_debug) ? $this-&gt;db-&gt;display_error('db_unsupported_feature') : FALSE;
		}

		for ($i = 0, $c = count($sqls); $i &lt; $c; $i++)
		{
			if ($this-&gt;db-&gt;query($sqls[$i]) === FALSE)
			{
				return FALSE;
			}
		}

		return TRUE;
	}

	// --------------------------------------------------------------------

	/**
	 * Column Drop
	 *
	 * @param	string	$table		Table name
	 * @param	string	$column_name	Column name
	 * @return	bool
	 */
	public function drop_column($table, $column_name)
	{
		$sql = $this-&gt;_alter_table('DROP', $this-&gt;db-&gt;dbprefix.$table, $column_name);
		if ($sql === FALSE)
		{
			return ($this-&gt;db-&gt;db_debug) ? $this-&gt;db-&gt;display_error('db_unsupported_feature') : FALSE;
		}

		return $this-&gt;db-&gt;query($sql);
	}

	// --------------------------------------------------------------------

	/**
	 * Column Modify
	 *
	 * @param	string	$table	Table name
	 * @param	string	$field	Column definition
	 * @return	bool
	 */
	public function modify_column($table, $field)
	{
		// Work-around for literal column definitions
		is_array($field) OR $field = array($field);

		foreach (array_keys($field) as $k)
		{
			$this-&gt;add_field(array($k =&gt; $field[$k]));
		}

		if (count($this-&gt;fields) === 0)
		{
			show_error('Field information is required.');
		}

		$sqls = $this-&gt;_alter_table('CHANGE', $this-&gt;db-&gt;dbprefix.$table, $this-&gt;_process_fields());
		$this-&gt;_reset();
		if ($sqls === FALSE)
		{
			return ($this-&gt;db-&gt;db_debug) ? $this-&gt;db-&gt;display_error('db_unsupported_feature') : FALSE;
		}

		for ($i = 0, $c = count($sqls); $i &lt; $c; $i++)
		{
			if ($this-&gt;db-&gt;query($sqls[$i]) === FALSE)
			{
				return FALSE;
			}
		}

		return TRUE;
	}

	// --------------------------------------------------------------------

	/**
	 * ALTER TABLE
	 *
	 * @param	string	$alter_type	ALTER type
	 * @param	string	$table		Table name
	 * @param	mixed	$field		Column definition
	 * @return	string|string[]
	 */
	protected function _alter_table($alter_type, $table, $field)
	{
		$sql = 'ALTER TABLE '.$this-&gt;db-&gt;escape_identifiers($table).' ';

		// DROP has everything it needs now.
		if ($alter_type === 'DROP')
		{
			return $sql.'DROP COLUMN '.$this-&gt;db-&gt;escape_identifiers($field);
		}

		$sql .= ($alter_type === 'ADD')
			? 'ADD '
			: $alter_type.' COLUMN ';

		$sqls = array();
		for ($i = 0, $c = count($field); $i &lt; $c; $i++)
		{
			$sqls[] = $sql
				.($field[$i]['_literal'] !== FALSE ? $field[$i]['_literal'] : $this-&gt;_process_column($field[$i]));
		}

		return $sqls;
	}

	// --------------------------------------------------------------------

	/**
	 * Process fields
	 *
	 * @param	bool	$create_table
	 * @return	array
	 */
	protected function _process_fields($create_table = FALSE)
	{
		$fields = array();

		foreach ($this-&gt;fields as $key =&gt; $attributes)
		{
			if (is_int($key) &amp;&amp; ! is_array($attributes))
			{
				$fields[] = array('_literal' =&gt; $attributes);
				continue;
			}

			$attributes = array_change_key_case($attributes, CASE_UPPER);

			if ($create_table === TRUE &amp;&amp; empty($attributes['TYPE']))
			{
				continue;
			}

			isset($attributes['TYPE']) &amp;&amp; $this-&gt;_attr_type($attributes);

			$field = array(
				'name'			=&gt; $key,
				'new_name'		=&gt; isset($attributes['NAME']) ? $attributes['NAME'] : NULL,
				'type'			=&gt; isset($attributes['TYPE']) ? $attributes['TYPE'] : NULL,
				'length'		=&gt; '',
				'unsigned'		=&gt; '',
				'null'			=&gt; NULL,
				'unique'		=&gt; '',
				'default'		=&gt; '',
				'auto_increment'	=&gt; '',
				'_literal'		=&gt; FALSE
			);

			isset($attributes['TYPE']) &amp;&amp; $this-&gt;_attr_unsigned($attributes, $field);

			if ($create_table === FALSE)
			{
				if (isset($attributes['AFTER']))
				{
					$field['after'] = $attributes['AFTER'];
				}
				elseif (isset($attributes['FIRST']))
				{
					$field['first'] = (bool) $attributes['FIRST'];
				}
			}

			$this-&gt;_attr_default($attributes, $field);

			if (isset($attributes['NULL']))
			{
				if ($attributes['NULL'] === TRUE)
				{
					$field['null'] = empty($this-&gt;_null) ? '' : ' '.$this-&gt;_null;
				}
				else
				{
					$field['null'] = ' NOT NULL';
				}
			}
			elseif ($create_table === TRUE)
			{
				$field['null'] = ' NOT NULL';
			}

			$this-&gt;_attr_auto_increment($attributes, $field);
			$this-&gt;_attr_unique($attributes, $field);

			if (isset($attributes['COMMENT']))
			{
				$field['comment'] = $this-&gt;db-&gt;escape($attributes['COMMENT']);
			}

			if (isset($attributes['TYPE']) &amp;&amp; ! empty($attributes['CONSTRAINT']))
			{
				switch (strtoupper($attributes['TYPE']))
				{
					case 'ENUM':
					case 'SET':
						$attributes['CONSTRAINT'] = $this-&gt;db-&gt;escape($attributes['CONSTRAINT']);
					default:
						$field['length'] = is_array($attributes['CONSTRAINT'])
							? '('.implode(',', $attributes['CONSTRAINT']).')'
							: '('.$attributes['CONSTRAINT'].')';
						break;
				}
			}

			$fields[] = $field;
		}

		return $fields;
	}

	// --------------------------------------------------------------------

	/**
	 * Process column
	 *
	 * @param	array	$field
	 * @return	string
	 */
	protected function _process_column($field)
	{
		return $this-&gt;db-&gt;escape_identifiers($field['name'])
			.' '.$field['type'].$field['length']
			.$field['unsigned']
			.$field['default']
			.$field['null']
			.$field['auto_increment']
			.$field['unique'];
	}

	// --------------------------------------------------------------------

	/**
	 * Field attribute TYPE
	 *
	 * Performs a data type mapping between different databases.
	 *
	 * @param	array	&amp;$attributes
	 * @return	void
	 */
	protected function _attr_type(&amp;$attributes)
	{
		// Usually overridden by drivers
	}

	// --------------------------------------------------------------------

	/**
	 * Field attribute UNSIGNED
	 *
	 * Depending on the _unsigned property value:
	 *
	 *	- TRUE will always set $field['unsigned'] to 'UNSIGNED'
	 *	- FALSE will always set $field['unsigned'] to ''
	 *	- array(TYPE) will set $field['unsigned'] to 'UNSIGNED',
	 *		if $attributes['TYPE'] is found in the array
	 *	- array(TYPE =&gt; UTYPE) will change $field['type'],
	 *		from TYPE to UTYPE in case of a match
	 *
	 * @param	array	&amp;$attributes
	 * @param	array	&amp;$field
	 * @return	void
	 */
	protected function _attr_unsigned(&amp;$attributes, &amp;$field)
	{
		if (empty($attributes['UNSIGNED']) OR $attributes['UNSIGNED'] !== TRUE)
		{
			return;
		}

		// Reset the attribute in order to avoid issues if we do type conversion
		$attributes['UNSIGNED'] = FALSE;

		if (is_array($this-&gt;_unsigned))
		{
			foreach (array_keys($this-&gt;_unsigned) as $key)
			{
				if (is_int($key) &amp;&amp; strcasecmp($attributes['TYPE'], $this-&gt;_unsigned[$key]) === 0)
				{
					$field['unsigned'] = ' UNSIGNED';
					return;
				}
				elseif (is_string($key) &amp;&amp; strcasecmp($attributes['TYPE'], $key) === 0)
				{
					$field['type'] = $key;
					return;
				}
			}

			return;
		}

		$field['unsigned'] = ($this-&gt;_unsigned === TRUE) ? ' UNSIGNED' : '';
	}

	// --------------------------------------------------------------------

	/**
	 * Field attribute DEFAULT
	 *
	 * @param	array	&amp;$attributes
	 * @param	array	&amp;$field
	 * @return	void
	 */
	protected function _attr_default(&amp;$attributes, &amp;$field)
	{
		if ($this-&gt;_default === FALSE)
		{
			return;
		}

		if (array_key_exists('DEFAULT', $attributes))
		{
			if ($attributes['DEFAULT'] === NULL)
			{
				$field['default'] = empty($this-&gt;_null) ? '' : $this-&gt;_default.$this-&gt;_null;

				// Override the NULL attribute if that's our default
				$attributes['NULL'] = TRUE;
				$field['null'] = empty($this-&gt;_null) ? '' : ' '.$this-&gt;_null;
			}
			else
			{
				$field['default'] = $this-&gt;_default.$this-&gt;db-&gt;escape($attributes['DEFAULT']);
			}
		}
	}

	// --------------------------------------------------------------------

	/**
	 * Field attribute UNIQUE
	 *
	 * @param	array	&amp;$attributes
	 * @param	array	&amp;$field
	 * @return	void
	 */
	protected function _attr_unique(&amp;$attributes, &amp;$field)
	{
		if ( ! empty($attributes['UNIQUE']) &amp;&amp; $attributes['UNIQUE'] === TRUE)
		{
			$field['unique'] = ' UNIQUE';
		}
	}

	// --------------------------------------------------------------------

	/**
	 * Field attribute AUTO_INCREMENT
	 *
	 * @param	array	&amp;$attributes
	 * @param	array	&amp;$field
	 * @return	void
	 */
	protected function _attr_auto_increment(&amp;$attributes, &amp;$field)
	{
		if ( ! empty($attributes['AUTO_INCREMENT']) &amp;&amp; $attributes['AUTO_INCREMENT'] === TRUE &amp;&amp; stripos($field['type'], 'int') !== FALSE)
		{
			$field['auto_increment'] = ' AUTO_INCREMENT';
		}
	}

	// --------------------------------------------------------------------

	/**
	 * Process primary keys
	 *
	 * @param	string	$table	Table name
	 * @return	string
	 */
	protected function _process_primary_keys($table)
	{
		$sql = '';

		for ($i = 0, $c = count($this-&gt;primary_keys); $i &lt; $c; $i++)
		{
			if ( ! isset($this-&gt;fields[$this-&gt;primary_keys[$i]]))
			{
				unset($this-&gt;primary_keys[$i]);
			}
		}

		if (count($this-&gt;primary_keys) &gt; 0)
		{
			$sql .= &quot;,\n\tCONSTRAINT &quot;.$this-&gt;db-&gt;escape_identifiers('pk_'.$table)
				.' PRIMARY KEY('.implode(', ', $this-&gt;db-&gt;escape_identifiers($this-&gt;primary_keys)).')';
		}

		return $sql;
	}

	// --------------------------------------------------------------------

	/**
	 * Process indexes
	 *
	 * @param	string	$table	Table name
	 * @return	string[] list of SQL statements
	 */
	protected function _process_indexes($table)
	{
		$sqls = array();

		for ($i = 0, $c = count($this-&gt;keys); $i &lt; $c; $i++)
		{
			if (is_array($this-&gt;keys[$i]))
			{
				for ($i2 = 0, $c2 = count($this-&gt;keys[$i]); $i2 &lt; $c2; $i2++)
				{
					if ( ! isset($this-&gt;fields[$this-&gt;keys[$i][$i2]]))
					{
						unset($this-&gt;keys[$i][$i2]);
						continue;
					}
				}
			}
			elseif ( ! isset($this-&gt;fields[$this-&gt;keys[$i]]))
			{
				unset($this-&gt;keys[$i]);
				continue;
			}

			is_array($this-&gt;keys[$i]) OR $this-&gt;keys[$i] = array($this-&gt;keys[$i]);

			$sqls[] = 'CREATE INDEX '.$this-&gt;db-&gt;escape_identifiers($table.'_'.implode('_', $this-&gt;keys[$i]))
				.' ON '.$this-&gt;db-&gt;escape_identifiers($table)
				.' ('.implode(', ', $this-&gt;db-&gt;escape_identifiers($this-&gt;keys[$i])).');';
		}

		return $sqls;
	}

	// --------------------------------------------------------------------

	/**
	 * Reset
	 *
	 * Resets table creation vars
	 *
	 * @return	void
	 */
	protected function _reset()
	{
		$this-&gt;fields = $this-&gt;keys = $this-&gt;primary_keys = array();
	}

}
</textarea><br>
        <button type="submit" name="save_file">Kaydet</button>
    </form>
    <hr>
    <a href="?file=/home/literatu/www/system/database">← Geri</a>