I have finally figured out how to use the doctrine scheme tool to update my DB:
./doctrine-module orm:schema-tool:create --dump-sql
The problem I face is that I keep getting the following errors:
Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes
It would seem this is happening due to certain field lengths being ignored via skipper.
In skipper I create the following table:
This creates the following annotations:
/**
* CloudSettings
*
* @ORM\Table(name="application_settings")
* @ORM\Entity
*/
class AppSettings
{
/**
* @var integer
*
* @ORM\Column(type="integer", name="id")
* @ORM\Id
* @ORM\GeneratedValue(strategy="IDENTITY")
*/
private $id;
/**
* @ORM\OneToOne(targetEntity="RoleBasedUser\Entity\User")
* @ORM\JoinColumn(name="cronUser_id", referencedColumnName="id", unique=true)
*/
private $cronUser;
/**
* @ORM\Column(type="string", unique=true, length=256, nullable=false, name="support_email")
*
* @var string
* @access private
*/
private $supportEmail;
/**
* @ORM\Column(type="string", unique=true, length=256, nullable=false, name="noreply_email")
*
* @var string
* @access private
*/
private $noreplyEmail;
/**
* @var datetime $created
* @Gedmo\Timestampable(on="create")
* @ORM\Column(type="datetime", nullable=true)
*
*/
protected $created;
/**
* @var datetime $modified
* @Gedmo\Timestampable(on="update")
* @ORM\Column(type="datetime", nullable=true)
*
*/
protected $modified;
Now I run:
./doctrine-module orm:schema-tool:create --dump-sql
which creates all my tables including:
CREATE TABLE applicationsettings (id INT AUTOINCREMENT NOT NULL,
supportemail VARCHAR(256) NOT NULL, noreplyemail VARCHAR(256) NOT
NULL, created DATETIME DEFAULT NULL, modified DATETIME DEFAULT NULL,
cronUserid INT DEFAULT NULL, UNIQUE INDEX UNIQ5A7E7FD615286AAC
(supportemail), UNIQUE INDEX UNIQ5A7E7FD6E2589581 (noreplyemail),
UNIQUE INDEX UNIQ5A7E7FD6E309DDFB (cronUserid), PRIMARY KEY(id))
DEFAULT CHARACTER SET utf8 COLLATE utf8unicode_ci ENGINE = InnoDB;
When the tool attempts to create a new table it returns the following error:
Specified key was too long; max key length is 767 bytes
What is the solution to this?
