Class CI_DB_mysqli_forge - echiong/testRepo GitHub Wiki

##Class CI_DB_mysqli_forge

MySQLi Forge Class

Category: Database
Author: ExpressionEngine Dev Team
Link: http://codeigniter.com/user_guide/database/
Located at system/database/drivers/mysqli/mysqli_forge.php

##Methods summary

public boolean _create_database ( string $name )

Create database

Parameters

$name string
the database name

Returns boolean

public boolean _drop_database ( string $name )

Drop database

Parameters

$name string
the database name

Returns boolean

public string _process_fields ( mixed $fields )

Process Fields

Parameters

$fields mixed
the fields

Returns string

public boolean _create_table ( string $table, mixed $fields, mixed $primary_keys, mixed $keys, boolean $if_not_exists )

Create Table

Parameters

$table string
the table name

$fields mixed
the fields

$primary_keys mixed
primary key(s)

$keys mixed
key(s)

$if_not_exists boolean
should 'IF NOT EXISTS' be added to the SQL

Returns boolean

public string _drop_table ( mixed $table )

Drop Table

Returns string

public object _alter_table ( string $alter_type, string $table, array $fields, string $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(),

Parameters

$alter_type string
the ALTER type (ADD, DROP, CHANGE)

$table string
the column name

$fields array
fields

$after_field string
the field after which we should add the new field

Returns object

public string _rename_table ( string $table_name, string $new_table_name )

Rename a table

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

Parameters

$table_name string
the old table name

$new_table_name string
the new table name

Returns string

Methods inherited from CI_DB_forge

__construct()

_reset()

add_column()

add_field()

add_key()

create_database()

create_table()

drop_column()

drop_database()

drop_table()

modify_column()

rename_table()

<table class="summary inherited">
<caption>Properties inherited from <a href="Class CI_DB_forge.md#properties">CI_DB_forge</a></caption>
<tr>
	<td><code>
		<a href="Class CI_DB_forge.md#$db_char_set"><var>$db_char_set</var></a>, 
		<a href="Class CI_DB_forge.md#$fields"><var>$fields</var></a>, 
		<a href="Class CI_DB_forge.md#$keys"><var>$keys</var></a>, 
		<a href="Class CI_DB_forge.md#$primary_keys"><var>$primary_keys</var></a>
	</code></td>
</tr>
</table>