mysql - Doctrine :构建模式忽略唯一键

Question

我正在使用 symfony 命令从我的 mysql 5.1 数据库生成我的 schema.yml 文件，方法是运行:

symfony doctrine:build-schema

我的 table :

CREATE TABLE `identity` (
  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `username` VARCHAR(64) DEFAULT NULL,
  `password` VARCHAR(128) DEFAULT NULL
  PRIMARY KEY (`id`),
  UNIQUE KEY `username` (`username`)
) ENGINE=INNODB DEFAULT CHARSET=latin1

转换为:

Identity:
  connection: doctrine
  tableName: identity
  columns:
    id:
      type: integer(4)
      fixed: false
      unsigned: true
      primary: true
      autoincrement: true
    username:
      type: string(64)
      fixed: false
      unsigned: false
      primary: false
      notnull: true
      autoincrement: false
    password:
      type: string(128)
      fixed: false
      unsigned: false
      primary: false
      notnull: false
      autoincrement: false

一切看起来都很好，除了我希望用户名列看起来像(例如使用 unique: true):

    username:
      type: string(64)
      fixed: false
      unsigned: false
      primary: false
      notnull: true
      autoincrement: false
      unique: true

有人知道我错过了什么吗？

Answer 1

试试这个:

CREATE TABLE `identity` (
  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `username` VARCHAR(64) DEFAULT NULL UNIQUE,
  `password` VARCHAR(128) DEFAULT NULL
  PRIMARY KEY (`id`),
  UNIQUE INDEX `identity_username_idx` (`username`)
) ENGINE=INNODB DEFAULT CHARSET=latin1