CI_DB_mysql_forge Class Reference

Inheritance diagram for CI_DB_mysql_forge:

Public Member Functions
	_create_database ($name)
	_drop_database ($name)
	_process_fields ($fields)
	_create_table ($table, $fields, $primary_keys, $keys, $if_not_exists)
	_drop_table ($table)
	_alter_table ($alter_type, $table, $fields, $after_field= '')
	_rename_table ($table_name, $new_table_name)
Public Member Functions inherited from CI_DB_forge
	__construct ()
	create_database ($db_name)
	drop_database ($db_name)
	add_key ($key= '', $primary=FALSE)
	add_field ($field= '')
	create_table ($table= '', $if_not_exists=FALSE)
	drop_table ($table_name)
	rename_table ($table_name, $new_table_name)
	add_column ($table= '', $field=array(), $after_field= '')
	drop_column ($table= '', $column_name= '')
	modify_column ($table= '', $field=array())
	_reset ()

Additional Inherited Members
Data Fields inherited from CI_DB_forge
	$fields = array()
	$keys = array()
	$primary_keys = array()
	$db_char_set = ''

Member Function Documentation

_alter_table	(		$alter_type,
			$table,
			$fields,
			$after_field = ''
	)

Alter table query

Generates a platform-specific query so that a table can be altered Called by add_column(), drop_column(), and column_alter(),

private

Parameters

string	the ALTER type (ADD, DROP, CHANGE)
string	the column name
array	fields
string	the field after which we should add the new field

Returns

object

_create_database

(

$name)

Create database

private

Parameters

string

the database name

Returns

bool

_create_table	(		$table,
			$fields,
			$primary_keys,
			$keys,
			$if_not_exists
	)

Create Table

private

Parameters

string	the table name
mixed	the fields
mixed	primary key(s)
mixed	key(s)
boolean	should 'IF NOT EXISTS' be added to the SQL

Returns

bool

_drop_database

(

$name)

Drop database

private

Parameters

string

the database name

Returns

bool

_drop_table

(

$table)

Drop Table

private

Returns

string

_process_fields

(

$fields)

Process Fields

private

Parameters

mixed

the fields

Returns

string

_rename_table	(		$table_name,
			$new_table_name
	)

Rename a table

Generates a platform-specific query so that a table can be renamed

private

Parameters

string	the old table name
string	the new table name

Returns

string

---

The documentation for this class was generated from the following file:

• system/database/drivers/mysql/mysql_forge.php