Methods

__construct()

__construct(string $table, bool $isTemporary) 
Inherited

inherited_from \Zend\Db\Sql\Ddl\CreateTable::__construct()

Parameters

$table

string

$isTemporary

bool

addColumn()

addColumn(\Zend\Db\Sql\Ddl\Column\ColumnInterface $column) : \Zend\Db\Sql\Ddl\self
Inherited

inherited_from \Zend\Db\Sql\Ddl\CreateTable::addColumn()

Parameters

Returns

\Zend\Db\Sql\Ddl\self

addConstraint()

addConstraint(\Zend\Db\Sql\Ddl\Constraint\ConstraintInterface $constraint) : \Zend\Db\Sql\Ddl\self
Inherited

inherited_from \Zend\Db\Sql\Ddl\CreateTable::addConstraint()

Parameters

Returns

\Zend\Db\Sql\Ddl\self

getRawState()

getRawState(string | null $key) : array
Inherited

inherited_from \Zend\Db\Sql\Ddl\CreateTable::getRawState()

Parameters

$key

stringnull

Returns

array

Get SQL string for statement

getSqlString(\Zend\Db\Adapter\Platform\PlatformInterface $adapterPlatform) : string
Inherited

inherited_from \Zend\Db\Sql\AbstractSql::getSqlString()
inherited_from \Zend\Db\Sql\Ddl\CreateTable::getSqlString()

Parameters

Returns

string

isTemporary()

isTemporary() : bool
Inherited

inherited_from \Zend\Db\Sql\Ddl\CreateTable::isTemporary()

Returns

bool

setSubject()

setSubject(\Zend\Db\Sql\Ddl\CreateTable $subject) : \Zend\Db\Sql\Platform\Mysql\Ddl\self

Parameters

Returns

\Zend\Db\Sql\Platform\Mysql\Ddl\self

setTable()

setTable(string $name) : \Zend\Db\Sql\Ddl\self
Inherited

inherited_from \Zend\Db\Sql\Ddl\CreateTable::setTable()

Parameters

$name

string

Returns

\Zend\Db\Sql\Ddl\self

setTemporary()

setTemporary(bool $temporary) : \Zend\Db\Sql\Ddl\self
Inherited

inherited_from \Zend\Db\Sql\Ddl\CreateTable::setTemporary()

Parameters

$temporary

bool

Returns

\Zend\Db\Sql\Ddl\self

buildSqlString()

buildSqlString(\Zend\Db\Adapter\Platform\PlatformInterface $platform, \Zend\Db\Adapter\Driver\DriverInterface $driver, \Zend\Db\Adapter\ParameterContainer $parameterContainer) : string
Inherited

inherited_from \Zend\Db\Sql\AbstractSql::buildSqlString()
inherited_from \Zend\Db\Sql\Ddl\CreateTable::buildSqlString()

Parameters

$parameterContainer

null\Zend\Db\Adapter\ParameterContainer

Returns

string

createSqlFromSpecificationAndParameters()

createSqlFromSpecificationAndParameters(string | array $specifications, string | array $parameters) : string
Inherited

inherited_from \Zend\Db\Sql\AbstractSql::createSqlFromSpecificationAndParameters()
inherited_from \Zend\Db\Sql\Ddl\CreateTable::createSqlFromSpecificationAndParameters()

Parameters

$specifications

stringarray

$parameters

stringarray

Exceptions

\Zend\Db\Sql\Exception\RuntimeException

Returns

string

getSqlInsertOffsets()

getSqlInsertOffsets(string $sql) : array

Parameters

$sql

string

Returns

array

Copy variables from the subject into the local properties

localizeVariables() 
Inherited

inherited_from \Zend\Db\Sql\AbstractSql::localizeVariables()
inherited_from \Zend\Db\Sql\Ddl\CreateTable::localizeVariables()

processColumns()

processColumns(\Zend\Db\Adapter\Platform\PlatformInterface $platform) : \Zend\Db\Sql\Ddl\string[][] | null

Parameters

$platform

Returns

\Zend\Db\Sql\Ddl\string[][]null

processCombinedby()

processCombinedby(\Zend\Db\Adapter\Platform\PlatformInterface $adapterPlatform) : array | string
Inherited

inherited_from \Zend\Db\Sql\Ddl\CreateTable::processCombinedby()

Parameters

Returns

arraystring

processConstraints()

processConstraints(\Zend\Db\Adapter\Platform\PlatformInterface $adapterPlatform) : \Zend\Db\Sql\Ddl\string[][] | null
Inherited

inherited_from \Zend\Db\Sql\Ddl\CreateTable::processConstraints()

Parameters

Returns

\Zend\Db\Sql\Ddl\string[][]null

processExpression()

processExpression(\Zend\Db\Sql\ExpressionInterface $expression, \Zend\Db\Adapter\Platform\PlatformInterface $platform, \Zend\Db\Adapter\Driver\DriverInterface $driver, \Zend\Db\Adapter\ParameterContainer $parameterContainer, null | string $namedParameterPrefix) : string
Inherited

staticvar int $runtimeExpressionPrefix
inherited_from \Zend\Db\Sql\AbstractSql::processExpression()
inherited_from \Zend\Db\Sql\Ddl\CreateTable::processExpression()

Parameters

$parameterContainer

null\Zend\Db\Adapter\ParameterContainer

$namedParameterPrefix

nullstring

Exceptions

\Zend\Db\Sql\Exception\RuntimeException

Returns

string

processStatementEnd()

processStatementEnd(\Zend\Db\Adapter\Platform\PlatformInterface $adapterPlatform) : string[]
Inherited

inherited_from \Zend\Db\Sql\Ddl\CreateTable::processStatementEnd()

Parameters

Returns

string[]

processSubSelect()

processSubSelect(\Zend\Db\Sql\Select $subselect, \Zend\Db\Adapter\Platform\PlatformInterface $platform, \Zend\Db\Adapter\Driver\DriverInterface $driver, \Zend\Db\Adapter\ParameterContainer $parameterContainer) : string
Inherited

inherited_from \Zend\Db\Sql\AbstractSql::processSubSelect()
inherited_from \Zend\Db\Sql\Ddl\CreateTable::processSubSelect()

Parameters

$subselect

\Zend\Db\Sql\Select

$parameterContainer

null\Zend\Db\Adapter\ParameterContainer

Returns

string

processTable()

processTable(\Zend\Db\Adapter\Platform\PlatformInterface $adapterPlatform) : string[]
Inherited

inherited_from \Zend\Db\Sql\Ddl\CreateTable::processTable()

Parameters

Returns

string[]

resolveColumnValue()

resolveColumnValue(null | array | \Zend\Db\Sql\ExpressionInterface | \Zend\Db\Sql\Select $column, \Zend\Db\Adapter\Platform\PlatformInterface $platform, \Zend\Db\Adapter\Driver\DriverInterface $driver, \Zend\Db\Adapter\ParameterContainer $parameterContainer, null | string $namedParameterPrefix) : string
Inherited

inherited_from \Zend\Db\Sql\AbstractSql::resolveColumnValue()
inherited_from \Zend\Db\Sql\Ddl\CreateTable::resolveColumnValue()

Parameters

$parameterContainer

null\Zend\Db\Adapter\ParameterContainer

$namedParameterPrefix

nullstring

Returns

string

resolveTable()

resolveTable(string | \Zend\Db\Sql\TableIdentifier | \Zend\Db\Sql\Select $table, \Zend\Db\Adapter\Platform\PlatformInterface $platform, \Zend\Db\Adapter\Driver\DriverInterface $driver, \Zend\Db\Adapter\ParameterContainer $parameterContainer) : string
Inherited

inherited_from \Zend\Db\Sql\AbstractSql::resolveTable()
inherited_from \Zend\Db\Sql\Ddl\CreateTable::resolveTable()

Parameters

Returns

string

normalizeColumnOption()

normalizeColumnOption(string $name) : string

Parameters

$name

string

Returns

string

 Properties

 

$columnOptionSortOrder

$columnOptionSortOrder : int[]

 

$columns

$columns : \Zend\Db\Sql\Ddl\Column\ColumnInterface[]
Inherited

inherited_from \Zend\Db\Sql\Ddl\CreateTable::$$columns
 

$constraints

$constraints : string[]
Inherited

inherited_from \Zend\Db\Sql\Ddl\CreateTable::$$constraints
 

$instanceParameterIndex

$instanceParameterIndex : array
Inherited

inherited_from \Zend\Db\Sql\AbstractSql::$$instanceParameterIndex
inherited_from \Zend\Db\Sql\Ddl\CreateTable::$$instanceParameterIndex
 

$isTemporary

$isTemporary : bool
Inherited

inherited_from \Zend\Db\Sql\Ddl\CreateTable::$$isTemporary
 

$processInfo

$processInfo : string
Inherited

inherited_from \Zend\Db\Sql\AbstractSql::$$processInfo
inherited_from \Zend\Db\Sql\Ddl\CreateTable::$$processInfo
 

Specifications for Sql String generation

$specifications : string[] | array[]
Inherited

inherited_from \Zend\Db\Sql\Ddl\CreateTable::$$specifications
 

$subject

$subject : \Zend\Db\Sql\Ddl\CreateTable

 

$table

$table : string
Inherited

inherited_from \Zend\Db\Sql\Ddl\CreateTable::$$table

 Constants

 

COLUMNS

COLUMNS 
Inherited

inherited_from \Zend\Db\Sql\Ddl\CreateTable::COLUMNS
 

CONSTRAINTS

CONSTRAINTS 
Inherited

inherited_from \Zend\Db\Sql\Ddl\CreateTable::CONSTRAINTS
 

TABLE

TABLE 
Inherited

inherited_from \Zend\Db\Sql\Ddl\CreateTable::TABLE