Gitee
\
test

\CI_DB_mssql_forge

MS SQL Forge Class

Summary

Methods
Properties
Constants
__construct()
create_database()
drop_database()
add_key()
add_field()
create_table()
drop_table()
rename_table()
add_column()
drop_column()
modify_column()
_reset()
_create_database()
_drop_database()
_drop_table()
_create_table()
_alter_table()
_rename_table()
$fields
$keys
$primary_keys
$db_char_set
No constants found
No protected methods found
No protected properties found
N/A
No private methods found
No private properties found
N/A

Properties

$fields

$fields :

Type

$keys

$keys :

Type

$primary_keys

$primary_keys :

Type

$db_char_set

$db_char_set :

Type

Methods

__construct()

__construct()

Constructor

Grabs the CI super object instance so we can access it.

create_database()

create_database(  $db_name) : boolean

Create database

Parameters

$db_name

Returns

boolean

drop_database()

drop_database(  $db_name) : boolean

Drop database

Parameters

$db_name

Returns

boolean

add_key()

add_key(  $key = '',   $primary = FALSE) : void

Add Key

Parameters

$key
$primary

add_field()

add_field(  $field = '') : void

Add Field

Parameters

$field

create_table()

create_table(  $table = '',   $if_not_exists = FALSE) : boolean

Create Table

Parameters

$table
$if_not_exists

Returns

boolean

drop_table()

drop_table(  $table_name) : boolean

Drop Table

Parameters

$table_name

Returns

boolean

rename_table()

rename_table(  $table_name,   $new_table_name) : boolean

Rename Table

Parameters

$table_name
$new_table_name

Returns

boolean

add_column()

add_column(  $table = '',   $field = array(),   $after_field = '') : boolean

Column Add

Parameters

$table
$field
$after_field

Returns

boolean

drop_column()

drop_column(  $table = '',   $column_name = '') : boolean

Column Drop

Parameters

$table
$column_name

Returns

boolean

modify_column()

modify_column(  $table = '',   $field = array()) : boolean

Column Modify

Parameters

$table
$field

Returns

boolean

_reset()

_reset() : void

Reset

Resets table creation vars

_create_database()

_create_database(  $name) : boolean

Create database

Parameters

$name

Returns

boolean

_drop_database()

_drop_database(  $name) : boolean

Drop database

Parameters

$name

Returns

boolean

_drop_table()

_drop_table(  $table) : boolean

Drop Table

Parameters

$table

Returns

boolean

_create_table()

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

Create Table

Parameters

$table
$fields
$primary_keys
$keys
$if_not_exists

Returns

boolean

_alter_table()

_alter_table(  $alter_type,   $table,   $column_name,   $column_definition = '',   $default_value = '',   $null = '',   $after_field = '') : object

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
$table
$column_name
$column_definition
$default_value
$null
$after_field

Returns

object

_rename_table()

_rename_table(  $table_name,   $new_table_name) : string

Rename a table

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

Parameters

$table_name
$new_table_name

Returns

string