zendframework/zend-db

DDL improves

Opened this issue · 2 comments

vitaliimelnychuk commented

Hello, guys
I want to add column with options such as AUTO INCREMENT and unsigned. How it do?
Finally I've created follow class and add Constraint

`class AutoIncrement extends AbstractConstraint

{
/**
* @var string
*/
protected $specification = 'AUTO_INCREMENT';
}`

Which is better way for creating table with DDL abstraction?

alextech commented

MySQL DDL already supports auto_increment keyword.

$column->setOption('AUTO_INCREMENT', true);

In general, current API adds column options not by extending constraints, but adding it to a list of keywords for syntax generator in appropriate engine decorator, eg

zend-db/src/Sql/Platform/Mysql/Ddl/AlterTableDecorator.php

Line 105 in 405e301

switch ($this->normalizeColumnOption($coName)) {

michalbundyra commented

This repository has been closed and moved to laminas/laminas-db; a new issue has been opened at laminas/laminas-db#73.