---
detect_relations: true
options:
  collate: latin1_swedish_ci
  charset: latin1
  type: InnoDB

announcement:
  actAs:
    I18n:
      fields: [title, body, summary, link]
  columns:
    id:
      type: integer(8)
      primary: true
      notnull: true
      autoincrement: true
    startdate:
      type: date
      default: null
    enddate:
      type: date
      default: null
    live:
      type: integer(1)
      default: '1'
    announcement_level_id:
      type: integer(8)
      default: null
    created_at:
      type: timestamp
      notnull: true
      default: '0000-00-00 00:00:00'
    updated_at:
      type: timestamp
      notnull: true
      default: '0000-00-00 00:00:00'
    title:
      type: string(255)
      default: null
    body:
      type: clob
      default: null
    summary:
      type: clob
      default: null
    link:
      type: string(255)
      default: null
  relations:
    announcementLevel:
      class: announcementLevel
      local: announcement_level_id
      foreign: id
      foreignAlias: announcements
      onDelete: cascade
  indexes:
    announcement_level_id_idx:
      fields: [announcement_level_id]
  options:
    charset: latin1

announcementLevel:
  tableName: announcement_level
  columns:
    id:
      type: integer(8)
      primary: true
      notnull: true
      autoincrement: true
    title:
      type: string(255)
      default: null
  options:
    charset: latin1

calendar:
  actAs:
    I18n:
      fields: [title, body]
  columns:
    id:
      type: integer(8)
      primary: true
      notnull: true
      autoincrement: true
    live:
      type: integer(1)
      default: '1'
    startdate:
      type: date
      default: null
    enddate:
      type: date
      default: null
    calendar_category_id:
      type: integer(8)
      default: null
    created_at:
      type: timestamp
      notnull: true
      default: '0000-00-00 00:00:00'
    updated_at:
      type: timestamp
      notnull: true
      default: '0000-00-00 00:00:00'
    title:
      type: string(255)
      default: null
    body:
      type: clob
      default: null
  relations:
    calendarCategory:
      class: calendarCategory
      local: calendar_category_id
      foreign: id
      foreignAlias: calendars
      onDelete: cascade
  indexes:
    calendar_category_id_idx:
      fields: [calendar_category_id]
  options:
    charset: latin1

calendarCategory:
  tableName: calendar_category
  actAs:
    I18n:
      fields: [title, slug]
  columns:
    id:
      type: integer(8)
      primary: true
      notnull: true
      autoincrement: true
    title:
      type: string(255)
      default: null
    slug:
      type: string(255)
      default: null
  options:
    charset: latin1

file:
  columns:
    id:
      type: integer(8)
      primary: true
      notnull: true
      autoincrement: true
    title:
      type: string(255)
      default: null
    filename:
      type: string(255)
      default: null
    created_at:
      type: timestamp
      notnull: true
      default: '0000-00-00 00:00:00'
    updated_at:
      type: timestamp
      notnull: true
      default: '0000-00-00 00:00:00'
  options:
    charset: latin1

migrationVersion:
  tableName: migration_version
  columns:
    version:
      type: integer(4)
      default: null
  options:
    charset: latin1

newsletter:
  columns:
    id:
      type: integer(8)
      primary: true
      notnull: true
      autoincrement: true
    title:
      type: string(255)
      default: null
    file:
      type: string(255)
      default: null
    publish:
      type: date
      default: null
    live:
      type: integer(1)
      default: '1'
    created_at:
      type: timestamp
      notnull: true
      default: '0000-00-00 00:00:00'
    updated_at:
      type: timestamp
      notnull: true
      default: '0000-00-00 00:00:00'
  options:
    charset: latin1

page:
  actAs:
    I18n:
      fields: [title, body, slug]
  columns:
    id:
      type: integer(8)
      primary: true
      notnull: true
      autoincrement: true
    keywords:
      type: string(255)
      default: null
    description:
      type: string(255)
      default: null
    live:
      type: integer(1)
      default: '1'
    template:
      type: string(255)
      default: null
    created_at:
      type: timestamp
      notnull: true
      default: '0000-00-00 00:00:00'
    updated_at:
      type: timestamp
      notnull: true
      default: '0000-00-00 00:00:00'
    page_category_id:
      type: integer(4)
      default: null
    title:
      type: string(255)
      notnull: true
      default: ''
    body:
      type: clob
      default: null
    slug:
      type: string(255)
      default: null
  indexes:
    page_category_id_idx:
      fields: [page_category_id]
  options:
    charset: latin1

pageCategory:
  tableName: page_category
  columns:
    id:
      type: integer(8)
      primary: true
      notnull: true
      autoincrement: true
    title:
      type: string(255)
      default: null
    slug:
      type: string(255)
      default: null
  indexes:
    sluggable_idx:
      fields:
        slug:
          sorting: ASC
        title:
          sorting: ASC
      type: unique
  options:
    charset: latin1

photo:
  actAs:
    I18n:
      fields: [title, caption]
  columns:
    id:
      type: integer(8)
      primary: true
      notnull: true
      autoincrement: true
    file:
      type: string(150)
      default: null
    frontpage:
      type: integer(1)
      default: null
    live:
      type: integer(1)
      default: '1'
    photo_album_id:
      type: integer(8)
      default: null
    created_at:
      type: timestamp
      notnull: true
      default: '0000-00-00 00:00:00'
    updated_at:
      type: timestamp
      notnull: true
      default: '0000-00-00 00:00:00'
    title:
      type: string(255)
      default: null
    caption:
      type: string(255)
      default: null
  relations:
    photoAlbum:
      class: photoAlbum
      local: photo_album_id
      foreign: id
      foreignAlias: photoes
      onDelete: cascade
  indexes:
    photo_album_id_idx:
      fields: [photo_album_id]
  options:
    charset: latin1

photoAlbum:
  tableName: photo_album
  actAs:
    I18n:
      fields: [title, slug]
  columns:
    id:
      type: integer(8)
      primary: true
      notnull: true
      autoincrement: true
    created_at:
      type: timestamp
      notnull: true
      default: '0000-00-00 00:00:00'
    updated_at:
      type: timestamp
      notnull: true
      default: '0000-00-00 00:00:00'
    live:
      type: integer(1)
      default: '1'
    title:
      type: string(255)
      default: null
    slug:
      type: string(255)
      default: null
  options:
    charset: latin1

sfGuardGroup:
  tableName: sf_guard_group
  columns:
    id:
      type: integer(4)
      primary: true
      notnull: true
      autoincrement: true
    name:
      type: string(255)
      unique: true
      default: null
    description:
      type: clob(65535)
      default: null
    created_at:
      type: timestamp
      notnull: true
      default: '0000-00-00 00:00:00'
    updated_at:
      type: timestamp
      notnull: true
      default: '0000-00-00 00:00:00'
  options:
    charset: latin1

sfGuardGroupPermission:
  tableName: sf_guard_group_permission
  columns:
    group_id:
      type: integer(4)
      primary: true
      notnull: true
      default: '0'
    permission_id:
      type: integer(4)
      primary: true
      notnull: true
      default: '0'
    created_at:
      type: timestamp
      notnull: true
      default: '0000-00-00 00:00:00'
    updated_at:
      type: timestamp
      notnull: true
      default: '0000-00-00 00:00:00'
  relations:
    group:
      class: sfGuardGroup
      local: group_id
      foreign: id
      foreignAlias: sf_guard_group_permissions
      onDelete: cascade
    permission:
      class: sfGuardPermission
      local: permission_id
      foreign: id
      foreignAlias: sf_guard_group_permissions
      onDelete: cascade
  indexes:
    sf_guard_group_permission_permission_id_sf_guard_permission_id:
      fields: [permission_id]
  options:
    charset: latin1

sfGuardPermission:
  tableName: sf_guard_permission
  columns:
    id:
      type: integer(4)
      primary: true
      notnull: true
      autoincrement: true
    name:
      type: string(255)
      unique: true
      default: null
    description:
      type: clob(65535)
      default: null
    created_at:
      type: timestamp
      notnull: true
      default: '0000-00-00 00:00:00'
    updated_at:
      type: timestamp
      notnull: true
      default: '0000-00-00 00:00:00'
  options:
    charset: latin1

sfGuardRememberKey:
  tableName: sf_guard_remember_key
  columns:
    id:
      type: integer(4)
      primary: true
      notnull: true
      autoincrement: true
    user_id:
      type: integer(4)
      default: null
    remember_key:
      type: string(32)
      default: null
    ip_address:
      type: string(50)
      primary: true
      notnull: true
      default: ''
    created_at:
      type: timestamp
      notnull: true
      default: '0000-00-00 00:00:00'
    updated_at:
      type: timestamp
      notnull: true
      default: '0000-00-00 00:00:00'
  relations:
    user:
      class: sfGuardUser
      local: user_id
      foreign: id
      foreignAlias: sf_guard_remember_keies
      onDelete: cascade
  indexes:
    user_id_idx:
      fields: [user_id]
  options:
    charset: latin1

sfGuardUser:
  tableName: sf_guard_user
  columns:
    id:
      type: integer(4)
      primary: true
      notnull: true
      autoincrement: true
    username:
      type: string(128)
      unique: true
      notnull: true
      default: ''
    algorithm:
      type: string(128)
      notnull: true
      default: 'sha1'
    salt:
      type: string(128)
      default: null
    password:
      type: string(128)
      default: null
    is_active:
      type: integer(1)
      default: '1'
    is_super_admin:
      type: integer(1)
      default: '0'
    last_login:
      type: timestamp
      default: null
    created_at:
      type: timestamp
      notnull: true
      default: '0000-00-00 00:00:00'
    updated_at:
      type: timestamp
      notnull: true
      default: '0000-00-00 00:00:00'
  indexes:
    is_active_idx_idx:
      fields: [is_active]
  options:
    charset: latin1

sfGuardUserGroup:
  tableName: sf_guard_user_group
  columns:
    user_id:
      type: integer(4)
      primary: true
      notnull: true
      default: '0'
    group_id:
      type: integer(4)
      primary: true
      notnull: true
      default: '0'
    created_at:
      type: timestamp
      notnull: true
      default: '0000-00-00 00:00:00'
    updated_at:
      type: timestamp
      notnull: true
      default: '0000-00-00 00:00:00'
  relations:
    group:
      class: sfGuardGroup
      local: group_id
      foreign: id
      foreignAlias: sf_guard_user_groups
      onDelete: cascade
    user:
      class: sfGuardUser
      local: user_id
      foreign: id
      foreignAlias: sf_guard_user_groups
      onDelete: cascade
  indexes:
    sf_guard_user_group_group_id_sf_guard_group_id:
      fields: [group_id]
  options:
    charset: latin1

sfGuardUserPermission:
  tableName: sf_guard_user_permission
  columns:
    user_id:
      type: integer(4)
      primary: true
      notnull: true
      default: '0'
    permission_id:
      type: integer(4)
      primary: true
      notnull: true
      default: '0'
    created_at:
      type: timestamp
      notnull: true
      default: '0000-00-00 00:00:00'
    updated_at:
      type: timestamp
      notnull: true
      default: '0000-00-00 00:00:00'
  relations:
    permission:
      class: sfGuardPermission
      local: permission_id
      foreign: id
      foreignAlias: sf_guard_user_permissions
      onDelete: cascade
    user:
      class: sfGuardUser
      local: user_id
      foreign: id
      foreignAlias: sf_guard_user_permissions
      onDelete: cascade
  indexes:
    sf_guard_user_permission_permission_id_sf_guard_permission_id:
      fields: [permission_id]
  options:
    charset: latin1