Source

zf-form-builder / www / system / modules / blog / configs / doctrine / schema.yml

Full commit
Blog_Tag:
  actAs:
    Sluggable: { name: name_slug, fields: [ name ] }
  columns:
    name: { type: string(255), notnull: true, unique: true }

Blog_Comment:
  actAs:
    NestedSet: { hasManyRoots: true, rootColumnName: entry_id }
  columns:
    name: { type: string(255), notnull: true }
    email: { type: string(255), notnull: true }
    site: { type: string(255), notnull: true }
    comment: { type: string, notnull: true }
    user_id: { type: integer, notnull: true }

Blog_Entry:
  actAs:
    Timestampable: ~
    Sluggable: { name: title_slug, fields: [ title ] }
  columns:
    title: { type: string(255), notnull: true, unique: true }
    text: { type: string, notnull: true }
    text_html: { type: string, notnull: true }
    comment_number: { type: integer, notnull: true, default: 0 }
    is_published: { type: boolean, notnull: true, default: 0 }
    user_id: { type: integer, notnull: true }
  relations:
    EntryTags:
      class: Blog_EntryTag
      onDelete: CASCADE
      local: id
      foreign: entry_id
    Tags:
      class: Blog_Tag
      local: entry_id
      foreign: tag_id
      refClass: Blog_EntryTag
      foreignAlias: Entries
    Comments:
      class: Blog_Comment
      onDelete: CASCADE
      local: id
      foreign: entry_id
    Aliases:
      class: Blog_EntryAlias
      onDelete: CASCADE
      local: id
      foreign: entry_id
    User:
      class: Identity_User
      local: user_id
      foreign: id

Blog_EntryAlias:
  columns:
    title_slug: { type: string(255), primary: true }
    entry_id: { type: integer, notnull: true }

Blog_EntryTag:
  columns:
    entry_id: { type: integer, primary: true }
    tag_id: { type: integer, primary: true }
  relations:
    Blog_Entry: { onDelete: CASCADE, local: entry_id, foreign: id }
    Blog_Tag: { onDelete: CASCADE, local: tag_id, foreign: id }