gistfile1.yml

RoomForumThread:
  tableName: room_forum_threads
  actAs:
    Timestampable:
    Sluggable:
      unique: true
      fields: [title]
      canUpdate: true
  columns:
    id:
      type: integer(4)
      primary: true
      autoincrement: true
    title: 
      type: string(255)
      notnull: true
    content: 
      type: string(2147483647)
      notnull: true
    room_id:
      type: integer(4)
      primary: true
    user_id:
      type: integer(4)
  relations:
    Room:
      local: room_id
      foreign:  id
      class: Room
      onDelete: CASCADE
    User:
      local: user_id
      foreign:  id
      class: sfGuardUser
      onDelete: CASCADE

RoomForumMessage:
  tableName: room_forum_messages
  actAs:
    Timestampable:
    Sluggable:
      unique: true
      fields: [name]
      canUpdate: true
  columns:
    id:
      type: integer(4)
      primary: true
      autoincrement: true
    content: 
      type: string(2147483647)
      notnull: true
    thread_id:
      type: integer(4)
  relations:
    Thread:
      local: thread_id
      foreign: id
      class:   RoomForumThread
      onDelete: CASCADE