title: symfony fixtures: set ondelete: CASCADE on refclass table
body: <p>I'm using symfony 1.4.5, Doctrine 1.2 and Mysql 5. </p>
  
  <p>In my schema.yml I have a few Many-to-Many relations which work great. But I need the joining table to have onDelete: CASCADE.</p>
  
  <p>Now for doctrine it is needed to add onDelete: CASCADE on the side where the foreignkey exists but since the refclass does not have any relations in the schema.yml I can't.</p>
  
  <p>example schema:</p>
  
  <pre><code>Organisatie:
    connection: doctrine
    tableName: organisatie
     columns:
      org_id:
       type: integer(4)
       fixed: false
       unsigned: false
       primary: true
       autoincrement: true
     naam:
       type: string(30)
       fixed: false
       unsigned: false
       primary: false
       notnull: true
       autoincrement: false
     relations:
       Sc:
        class: Sc
        refClass: ScRegel
        local: org_id
        foreign: sc_id
  
  Sc:
    connection: doctrine
    tableName: sc
    columns:
      sc_id:
        type: integer(4)
        fixed: false
        unsigned: false
        primary: true
        autoincrement: true
        notnull: true
      sc_nummer:
        type: string(15)
        fixed: false
        unsigned: false
        primary: false
        autoincrement: false
        notnull: true
      type:
        type: string(20)
        fixed: false
        unsigned: false
        primary: false
        notnull: true
        autoincrement: false
    relations:
      Organisatie:
        class: Organisatie
        refClass: ScRegel
        local: sc_id
        foreign: org_id
  
   ScRegel:
    connection: doctrine
    tableName: sc_regel
    columns:
      sc_id:
        type: integer(4)
        primary: true
        autoincrement: true
        notnull: true
      sc_id:
        type: integer(4)
        fixed: false
        unsigned: false
        primary: false
        autoincrement: false
        notnull: true
      org_id:
        type: integer(4)
        fixed: false
        unsigned: false
        primary: false
        notnull: false
        autoincrement: false
  </code></pre>
  
  <p>Now i tried to add onDelete: CASCADE on both sides (Sc and Organisatie), but in both cases they are ignored, the relation is made, but the onDelete is ignored.</p>
  
  <p>Does anybody know how to get this working?</p>