CI_DB_pdo_ibm_forge
===============

PDO IBM DB2 Forge Class




* Class name: CI_DB_pdo_ibm_forge
* Namespace: 
* Parent class: [CI_DB_pdo_forge](CI_DB_pdo_forge.md)





Properties
----------


### $_rename_table

    protected string $_rename_table = 'ALTER TABLE %s RENAME TO %s;'

RENAME TABLE statement



* Visibility: **protected**


### $_unsigned

    protected boolean $_unsigned = TRUE

UNSIGNED support



* Visibility: **protected**


### $_default

    protected string $_default = ' DEFAULT '

DEFAULT value representation in CREATE/ALTER TABLE statements



* Visibility: **protected**


### $_create_table_if

    protected string $_create_table_if = 'CREATE TABLE IF NOT EXISTS'

CREATE TABLE IF statement



* Visibility: **protected**


### $_drop_table_if

    protected string $_drop_table_if = 'DROP TABLE IF EXISTS'

DROP TABLE IF EXISTS statement



* Visibility: **protected**


### $db

    protected object $db

Database object



* Visibility: **protected**


### $fields

    public array $fields = array()

Fields data



* Visibility: **public**


### $keys

    public array $keys = array()

Keys data



* Visibility: **public**


### $primary_keys

    public array $primary_keys = array()

Primary Keys data



* Visibility: **public**


### $db_char_set

    public string $db_char_set = ''

Database character set



* Visibility: **public**


### $_create_database

    protected string $_create_database = 'CREATE DATABASE %s'

CREATE DATABASE statement



* Visibility: **protected**


### $_drop_database

    protected string $_drop_database = 'DROP DATABASE %s'

DROP DATABASE statement



* Visibility: **protected**


### $_create_table

    protected string $_create_table = "%s %s (%s\n)"

CREATE TABLE statement



* Visibility: **protected**


### $_create_table_keys

    protected boolean $_create_table_keys = FALSE

CREATE TABLE keys flag

Whether table keys are created from within the
CREATE TABLE statement.

* Visibility: **protected**


### $_null

    protected string $_null = ''

NULL value representation in CREATE/ALTER TABLE statements



* Visibility: **protected**


Methods
-------


### _alter_table

    string|array<mixed,string> CI_DB_forge::_alter_table(string $alter_type, string $table, mixed $field)

ALTER TABLE



* Visibility: **protected**
* This method is defined by [CI_DB_forge](CI_DB_forge.md)


#### Arguments
* $alter_type **string** - &lt;p&gt;ALTER type&lt;/p&gt;
* $table **string** - &lt;p&gt;Table name&lt;/p&gt;
* $field **mixed** - &lt;p&gt;Column definition&lt;/p&gt;



### _attr_type

    void CI_DB_forge::_attr_type($attributes)

Field attribute TYPE

Performs a data type mapping between different databases.

* Visibility: **protected**
* This method is defined by [CI_DB_forge](CI_DB_forge.md)


#### Arguments
* $attributes **mixed**



### _attr_unique

    void CI_DB_forge::_attr_unique($attributes, $field)

Field attribute UNIQUE



* Visibility: **protected**
* This method is defined by [CI_DB_forge](CI_DB_forge.md)


#### Arguments
* $attributes **mixed**
* $field **mixed**



### _attr_auto_increment

    void CI_DB_forge::_attr_auto_increment($attributes, $field)

Field attribute AUTO_INCREMENT



* Visibility: **protected**
* This method is defined by [CI_DB_forge](CI_DB_forge.md)


#### Arguments
* $attributes **mixed**
* $field **mixed**



### __construct

    void CI_DB_forge::__construct($db)

Class constructor



* Visibility: **public**
* This method is defined by [CI_DB_forge](CI_DB_forge.md)


#### Arguments
* $db **mixed**



### create_database

    boolean CI_DB_forge::create_database(string $db_name)

Create database



* Visibility: **public**
* This method is defined by [CI_DB_forge](CI_DB_forge.md)


#### Arguments
* $db_name **string**



### drop_database

    boolean CI_DB_forge::drop_database(string $db_name)

Drop database



* Visibility: **public**
* This method is defined by [CI_DB_forge](CI_DB_forge.md)


#### Arguments
* $db_name **string**



### add_key

    \CI_DB_forge CI_DB_forge::add_key(string $key, boolean $primary)

Add Key



* Visibility: **public**
* This method is defined by [CI_DB_forge](CI_DB_forge.md)


#### Arguments
* $key **string**
* $primary **boolean**



### add_field

    \CI_DB_forge CI_DB_forge::add_field(array $field)

Add Field



* Visibility: **public**
* This method is defined by [CI_DB_forge](CI_DB_forge.md)


#### Arguments
* $field **array**



### create_table

    boolean CI_DB_forge::create_table(string $table, boolean $if_not_exists, array $attributes)

Create Table



* Visibility: **public**
* This method is defined by [CI_DB_forge](CI_DB_forge.md)


#### Arguments
* $table **string** - &lt;p&gt;Table name&lt;/p&gt;
* $if_not_exists **boolean** - &lt;p&gt;Whether to add IF NOT EXISTS condition&lt;/p&gt;
* $attributes **array** - &lt;p&gt;Associative array of table attributes&lt;/p&gt;



### _create_table

    mixed CI_DB_forge::_create_table(string $table, boolean $if_not_exists, array $attributes)

Create Table



* Visibility: **protected**
* This method is defined by [CI_DB_forge](CI_DB_forge.md)


#### Arguments
* $table **string** - &lt;p&gt;Table name&lt;/p&gt;
* $if_not_exists **boolean** - &lt;p&gt;Whether to add &#039;IF NOT EXISTS&#039; condition&lt;/p&gt;
* $attributes **array** - &lt;p&gt;Associative array of table attributes&lt;/p&gt;



### _create_table_attr

    string CI_DB_forge::_create_table_attr(array $attributes)

CREATE TABLE attributes



* Visibility: **protected**
* This method is defined by [CI_DB_forge](CI_DB_forge.md)


#### Arguments
* $attributes **array** - &lt;p&gt;Associative array of table attributes&lt;/p&gt;



### drop_table

    boolean CI_DB_forge::drop_table(string $table_name, boolean $if_exists)

Drop Table



* Visibility: **public**
* This method is defined by [CI_DB_forge](CI_DB_forge.md)


#### Arguments
* $table_name **string** - &lt;p&gt;Table name&lt;/p&gt;
* $if_exists **boolean** - &lt;p&gt;Whether to add an IF EXISTS condition&lt;/p&gt;



### _drop_table

    string CI_DB_forge::_drop_table(string $table, boolean $if_exists)

Drop Table

Generates a platform-specific DROP TABLE string

* Visibility: **protected**
* This method is defined by [CI_DB_forge](CI_DB_forge.md)


#### Arguments
* $table **string** - &lt;p&gt;Table name&lt;/p&gt;
* $if_exists **boolean** - &lt;p&gt;Whether to add an IF EXISTS condition&lt;/p&gt;



### rename_table

    boolean CI_DB_forge::rename_table(string $table_name, string $new_table_name)

Rename Table



* Visibility: **public**
* This method is defined by [CI_DB_forge](CI_DB_forge.md)


#### Arguments
* $table_name **string** - &lt;p&gt;Old table name&lt;/p&gt;
* $new_table_name **string** - &lt;p&gt;New table name&lt;/p&gt;



### add_column

    boolean CI_DB_forge::add_column(string $table, array $field, string $_after)

Column Add



* Visibility: **public**
* This method is defined by [CI_DB_forge](CI_DB_forge.md)


#### Arguments
* $table **string** - &lt;p&gt;Table name&lt;/p&gt;
* $field **array** - &lt;p&gt;Column definition&lt;/p&gt;
* $_after **string** - &lt;p&gt;Column for AFTER clause (deprecated)&lt;/p&gt;



### drop_column

    boolean CI_DB_forge::drop_column(string $table, string $column_name)

Column Drop



* Visibility: **public**
* This method is defined by [CI_DB_forge](CI_DB_forge.md)


#### Arguments
* $table **string** - &lt;p&gt;Table name&lt;/p&gt;
* $column_name **string** - &lt;p&gt;Column name&lt;/p&gt;



### modify_column

    boolean CI_DB_forge::modify_column(string $table, string $field)

Column Modify



* Visibility: **public**
* This method is defined by [CI_DB_forge](CI_DB_forge.md)


#### Arguments
* $table **string** - &lt;p&gt;Table name&lt;/p&gt;
* $field **string** - &lt;p&gt;Column definition&lt;/p&gt;



### _process_fields

    array CI_DB_forge::_process_fields(boolean $create_table)

Process fields



* Visibility: **protected**
* This method is defined by [CI_DB_forge](CI_DB_forge.md)


#### Arguments
* $create_table **boolean**



### _process_column

    string CI_DB_forge::_process_column(array $field)

Process column



* Visibility: **protected**
* This method is defined by [CI_DB_forge](CI_DB_forge.md)


#### Arguments
* $field **array**



### _attr_unsigned

    void CI_DB_forge::_attr_unsigned($attributes, $field)

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 => UTYPE) will change $field['type'],
	from TYPE to UTYPE in case of a match

* Visibility: **protected**
* This method is defined by [CI_DB_forge](CI_DB_forge.md)


#### Arguments
* $attributes **mixed**
* $field **mixed**



### _attr_default

    void CI_DB_forge::_attr_default($attributes, $field)

Field attribute DEFAULT



* Visibility: **protected**
* This method is defined by [CI_DB_forge](CI_DB_forge.md)


#### Arguments
* $attributes **mixed**
* $field **mixed**



### _process_primary_keys

    string CI_DB_forge::_process_primary_keys(string $table)

Process primary keys



* Visibility: **protected**
* This method is defined by [CI_DB_forge](CI_DB_forge.md)


#### Arguments
* $table **string** - &lt;p&gt;Table name&lt;/p&gt;



### _process_indexes

    string CI_DB_forge::_process_indexes(string $table)

Process indexes



* Visibility: **protected**
* This method is defined by [CI_DB_forge](CI_DB_forge.md)


#### Arguments
* $table **string**



### _reset

    void CI_DB_forge::_reset()

Reset

Resets table creation vars

* Visibility: **protected**
* This method is defined by [CI_DB_forge](CI_DB_forge.md)