Peyote
Back to top  

The Create table class

package Peyote
author Dave Widmer

 Methods

__construct() 

__construct(string $table, $if_exists) 
Inherited

inherited_from \Peyote\Drop::__construct()

Parameters

$table

string

The table name

$if_exists

addPrimaryKey() 

addPrimaryKey(string $key) : \Peyote\Create

Parameters

$key

string

The name of the primary key to add

Returns

\Peyote\Create$this

{@inheritDoc}

compile() 

getCharset() 

getCharset() : string

Returns

stringThe character set

getColumns() 

getColumns() : string

Returns

stringThe column list

getEngine() 

getEngine() : string

Returns

stringThe database engine (MyISAM, InnoDB)

getIfExists() 

getIfExists() : boolean
Inherited

inherited_from \Peyote\Drop::getIfExists()

Returns

boolean

getPrimaryKey() 

getPrimaryKey() : array

Returns

arrayA list of primary keys

getTable() 

getTable() : string
Inherited

inherited_from \Peyote\Drop::getTable()

Returns

string

getType() 

getType() : string
Inherited

inherited_from \Peyote\Drop::getType()

Returns

stringThe type of object to change (DATABASE, TABLE, etc...)

setCharset() 

setCharset(string $charset) : \Peyote\Create

Parameters

$charset

string

The character set.

Returns

\Peyote\Create$this

setColumns() 

setColumns(array $columns) : \Peyote\Create

Parameters

$columns

array

The columns to set.

Returns

\Peyote\Create$this

setEngine() 

setEngine(string $engine) : \Peyote\Create

Parameters

$engine

string

The database engine

Returns

\Peyote\Create$this

setIfExists() 

setIfExists(boolean $exists) : \Peyote\Drop
Inherited

inherited_from \Peyote\Drop::setIfExists()

Parameters

$exists

boolean

Add the IF EXISTS clause?

Returns

\Peyote\Drop

setPrimaryKey() 

setPrimaryKey(array | string $keys) : \Peyote\Create

Parameters

$keys

arraystring

The key(s) to set

Returns

\Peyote\Create$this

setTable() 

setTable(string $table) : \Peyote\Drop
Inherited

inherited_from \Peyote\Drop::setTable()

Parameters

$table

string

The table name to drop.

Returns

\Peyote\Drop

 Properties

 

$charset

$charset : string

 

$columns

$columns : array

 

$engine

$engine : string

 

$if_exists

$if_exists : boolean
Inherited

inherited_from \Peyote\Drop::$$if_exists
 

$primary_key

$primary_key : array

 

$table

$table : string
Inherited

inherited_from \Peyote\Drop::$$table
 

$type

$type : string
Inherited

inherited_from \Peyote\Drop::$$type