Sequence Class Reference

Public Member Functions
	getCreateSequenceDdl ( $name, $startNumber=1, $columnType=Table::TYPE_INTEGER, $unsigned=true)
	dropSequence ($name)

Detailed Description

Class Sequence represents DDL for manage sequences

Definition at line 11 of file Sequence.php.

Member Function Documentation

dropSequence()

dropSequence

(

$name

)

Return SQL for drop sequence

Parameters

string

$name

Returns

string

Definition at line 42 of file Sequence.php.

    {
        $format = "DROP TABLE %s";
        return sprintf($format, $name);
    }

getCreateSequenceDdl()

getCreateSequenceDdl	(		$name,
			$startNumber = 1,
			$columnType = Table::TYPE_INTEGER,
			$unsigned = true
	)

Return SQL for create sequence

Parameters

string	$name	The name of table in create statement
int	$startNumber	The auto increment start number
string	$columnType	Type of sequence_value column
bool | true	$unsigned	Flag to set sequence_value as UNSIGNED field

Returns

string

Definition at line 22 of file Sequence.php.

      {
        $format = "CREATE TABLE %s (
                     sequence_value %s %s NOT NULL AUTO_INCREMENT,
                     PRIMARY KEY (sequence_value)
            ) AUTO_INCREMENT = %d ENGINE = INNODB";

        return sprintf($format, $name, $columnType, $unsigned ? 'UNSIGNED' : '', $startNumber);
    }

---

The documentation for this class was generated from the following file:

• vendor/magento/framework/DB/Ddl/Sequence.php