vzSiteMenu:
  tableName: vz_site_menus
  actAs:
    Userstampable:
    Timestampable:
    Sluggable:
      fields: [label]
      unique: true
      name: name
      builder: [vzMenuInflector, underscoreize] 
    NestedSet:
      hasManyRoots: true
      rootColumnName: root_id
    #I18n:
    #  fields: [label]
  columns:
    link: string(255)
    label: string(255)
    is_published:
      type: boolean
      default: true
    can_be_deleted:
      type: boolean
      default: true
  indexes:
    link_index:
      fields: [link]
    label_index:
      fields: [label]
    is_published_index:
      fields: [is_published]
  relations:
    Permissions:
      class: sfGuardPermission
      local: menu_id
      foreign: permission_id
      refClass: vzSiteMenuPermission
      foreignAlias: Menus
      
vzSiteMenuPermission:
  tableName: vz_menu_permissions
  columns:
    menu_id:
      type: integer
      primary: true
    permission_id:
      type: integer
      primary: true
  relations:
    Menu:
      class: vzSiteMenu
      local: id
      foreign: menu_id
      type: one
      onDelete: CASCADE
    Permission:
      class: sfGuardPermission
      local: permission_id
      foreign: id
      type: one
      onDelete: CASCADE