Hello!

I have a problem with my schema.yml. When i start the command line :
symfony doctrine:build-all, I have an error :

sqlstate 42000 Syntax error or access violation: 1072 Key column
'envdomaine_id doesn't exist in table. Failing query.

My schema.yml :

Envdomaine:
  tableName:            envdomaine
  columns:
    id:
      type:             integer(8)
      notnull:          true
      autoincrement:    true
      primary:          true
    DesignationDomaine:
      type:             string(40)
    Remarque:
      type:             string(2147483647)
    created_at:
      type:             timestamp
    updated_at:
      type:             timestamp
    EnrARCHIVE:
      type:             boolean
      notnull:          true
  relations:
    Envpersonnel:
      local:            id
      foreign:          Domaine_id
    Envservice:
      local:            id
      foreign:          Domaine_id
    Envsite:
      local:            id
      foreign:          Domaine_id
  options:
    type: INNODB

Envpersonnel:
  tableName:            envpersonnel
  columns:
    id:
      type:             integer(8)
      notnull:          true
      autoincrement:    true
      primary:          true
    NumeroPersonnel:
      type:             string(25)
    InitialesPersonnel:
      type:             string(6)
    NomPersonnel:
      type:             string(40)
    PrenomPersonnel:
      type:             string(30)
    Domaine_id:
      type:             integer(8)
    Service_id:
      type:             integer(8)
    Site_id:
      type:             integer(8)
  relations:
    Envdomaine:
    Envservice:
    Envsite:
  options:
    type: INNODB

Envservice:
  tableName:            envservice
  columns:
    id:
      type:             integer(8)
      notnull:          true
      autoincrement:    true
      primary:          true
    CodeService:
      type:             string(40)
    DesignationService:
      type:             string(80)
    Domaine_id:
      type:             integer(8)
  relations:
    Envdomaine:
    Envpersonnel:
      local:            id
      foreign:          Service_id
  options:
    type: INNODB

Envsite:
  tableName:            envsite
  columns:
    id:
      type:             integer(8)
      notnull:          true
      autoincrement:    true
      primary:          true
    DesignationSite:
      type:             string(80)
    Domaine_id:
      type:             integer(8)
  relations:
    Envdomaine:
    Envpersonnel:
      local:            id
      foreign:          Site_id
  options:
    type: INNODB

Help me please !
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"symfony users" group.
To post to this group, send email to symfony-users@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/symfony-users?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to