MenuItem:
  actAs: { Timestampable: ~ }
  columns:
    name:               { type: string(255), notnull: true, unique: true }
    label:              { type: string(255), notnull: true }
    displaymethod_id:   { type: integer, notnull: true }
    default_protocol:   { type: string(5), notnull: true }
    default_server:     { type: string(255), notnull: true }
    default_url:        { type: string(255), notnull: true }
    picture:            { type: string(255), notnull: false }
    auth_required:      { type: boolean, notnull: true }
  relations:
    DisplayMethod: { local: displaymethod_id, foreign: id, foreignAlias: MenuItem }
    Users: { refClass: MenuItemUser, local: item_id, foreign: user_id, class: sfGuardUser }

DisplayMethod:
  actAs: { Timestampable: ~ }
  columns:
    name: { type: string(255), notnull: true, unique: true }
    label: { type: string(255), notnull: true }

MenuItemUser:
  actAs: { Timestampable: ~ }
  columns:
    user_id:   { type: integer, notnull: true}
    item_id:    { type: integer, notnull: true }
    item_order: { type: integer, notnull: true }
    item_user:  { type: string(255), notnull: false }
    item_pass:  { type: string(255), notnull: false }
  relations:
    MenuItem:    { local: item_id, foreign: id, foreignAlias: MenuItemUsers }
    sfGuardUser: { local: user_id, foreign: id, foreignAlias: MenuItemUsers }