schema.yml - lyra-cms - An open source CMS developed with symfony framework

Source path: svn/ trunk/ config/ doctrine/ schema.yml

‹r91

r96

LyraContent:
  columns:
    ctype_id:
      type: integer(4)
      notnull: true
    path:
      type: string(255)
    params:
      type: clob
    meta_title:
      type: string(255)
    meta_descr:
      type: string(500)
    meta_keys:
      type: string(500)
    meta_robots:
      type: string(255)
  relations:
    ContentType:
      class: LyraContentType
      local: ctype_id
      foreign: id
      foreignAlias: Contents
      onDelete: CASCADE

LyraRoute:
  tableName: routes
  options:
    collate: utf8_unicode_ci
    charset: utf8
  columns:
    id:
      type: integer(4)
      primary: true
      autoincrement: true
    ctype_id:
      type: integer(4)
      notnull: true
    name:
      type: string(80)
    action:
      type: string(20)
    params:
      type: clob
  relations:
    RouteContentType:
      class: LyraContentType
      local: ctype_id
      foreign: id
      foreignAlias: ContentTypeRoutes
      onDelete: CASCADE

LyraArticle:
  tableName: articles
  inheritance:
    extends: LyraContent
    type: concrete
  actAs:
    Timestampable: ~
    lySluggable:
      fields: [title]
      canUpdate: true
      unique: true
      uniqueBy: [path]
      indexName: article_slug
  options:
    collate: utf8_unicode_ci
    charset: utf8
  columns:
    id:
      type: integer(4)
      primary: true
      autoincrement: true
    title:
      type: string(255)
      notnull: true
    subtitle:
      type: string(255)
    summary:
      type: clob
    content:
      type: clob
    is_active:
      type: boolean
      notnull: true
      default: false
    is_featured:
      type: boolean
      notnull: true
      default: false
    is_sticky:
      type: boolean
      notnull: true
      default: false
    is_archived:
      type: boolean
      notnull: true
      default: false
    is_feeded:
      type: boolean
      notnull: true
      default: false
    publish_start:
      type: timestamp
    publish_end:
      type: timestamp
    status:
      type: integer(1)
      notnull: true
      default: 0
    created_by:
      type: integer(4)
    updated_by:
      type: integer(4)
    locked_by:
      type: integer(4)
    num_comments:
      type: integer(4)
      notnull: true
      default: 0
    num_active_comments:
      type: integer(4)
      notnull: true
      default: 0
  relations:
    ArticleLabels:
      class: LyraLabel
      refClass: LyraArticleLabel
      local: article_id
      foreign: label_id
      foreignAlias: LabelArticles
    ArticleCreatedBy:
      class: sfGuardUser
      local: created_by
      foreign: id
      foreignAlias: CreatedArticles
    ArticleUpdatedBy:
      class: sfGuardUser
      local: updated_by
      foreign: id
      foreignAlias: UpdatedArticles
      
LyraComment:
  tableName: comments
  actAs:
    Timestampable: ~
  options:
    collate: utf8_unicode_ci
    charset: utf8
  columns:
    id:
      type: integer(4)
      primary: true
      autoincrement: true
    article_id:
      type: integer(4)
    author_name:
      type: string(255)
      notnull: true
    author_email:
      type: string(255)
    author_url:
      type: string(255)
    content:
      type: clob(65532)
      notnull: true
    is_active:
      type: boolean
      notnull: true
      default: false
    created_by:
      type: integer(4)
  relations:
    CommentArticle:
      class: LyraArticle
      local: article_id
      foreign: id
      foreignAlias: ArticleComments
      onDelete: CASCADE
    CommentCreatedBy:
      class: sfGuardUser
      local: created_by
      foreign: id
      foreignAlias: CreatedComments

LyraContentType:
   tableName: content_types
   actAs:
     Timestampable: ~
   options:
     collate: utf8_unicode_ci
     charset: utf8
   columns:
     id:
       type: integer(4)
       primary: true
       autoincrement: true
     type:
       type: string(80)
       notnull: true
       unique: true
     name:
        type: string(255)
        notnull: true
     description:
        type: string(4000)
     model:
        type: string(255)
     module:
        type: string(255)
     plugin:
        type: string(255)
     item_slug:
      type: string(80)
     format:
      type: string(4)
     is_active:
        type: boolean
        notnull: true
        default: false
     params:
        type: clob
   relations:
      ContentTypeCatalogs:
         class: LyraCatalog
         refClass: LyraContentTypeCatalog
         local: ctype_id
         foreign: catalog_id
         foreignAlias: CatalogContentTypes

LyraLabel:
   tableName: labels
   actAs:
     Timestampable: ~
     Sluggable:
        fields: [name]
        canUpdate: true
        unique: true
     NestedSet:
        hasManyRoots: true
        rootColumnName: root_id
   options:
     collate: utf8_unicode_ci
     charset: utf8
   columns:
     id:
       type: integer(4)
       primary: true
       autoincrement: true
     catalog_id:
       type: integer(4)
     name:
       type: string(255)
       notnull: true
     title:
       type: string(255)
     description:
       type: string(4000)
     meta_title:
       type: string(255)
     meta_robots:
       type: string(255)
     meta_descr:
       type: string(4000)
     meta_keys:
       type: string(4000)
     is_active:
       type: boolean
       notnull: true
       default: false
     created_by:
       type: integer(4)
     updated_by:
       type: integer(4)
   relations:
      LabelCatalog:
        class: LyraCatalog
        local: catalog_id
        foreign: id
        foreignAlias: CatalogLabels
        onDelete: CASCADE
      LabelCreatedBy:
        class: sfGuardUser
        local: created_by
        foreign: id
        foreignAlias: CreatedLabels
      LabelUpdatedBy:
        class: sfGuardUser
        local: updated_by
        foreign: id
        foreignAlias: UpdatedLabels

LyraCatalog:
   tableName: catalogs
   actAs:
      Timestampable: ~
   options:
     collate: utf8_unicode_ci
     charset: utf8
   columns:
     id:
       type: integer(4)
       primary: true
       autoincrement: true
     name:
       type: string(255)
       notnull: true
     description:
       type: string(4000)
     is_active:
       type: boolean
       notnull: true
       default: false
     locked_by:
       type: integer(4)

LyraContentTypeCatalog:
   tableName: content_type_catalog
   options:
    symfony:
      form: false
      filter: false
   columns:
      ctype_id:
         type: integer(4)
         primary: true
      catalog_id:
         type: integer(4)
         primary: true
   relations:
      ContentType:
        class: LyraContentType
        local: ctype_id
        foreign: id
        onDelete: CASCADE
      Catalog:
        class: LyraCatalog
        local: catalog_id
        foreign: id
        onDelete: CASCADE

LyraArticleLabel:
   tableName: article_label
   options:
     symfony:
       form: false
       filter: false
   columns:
      article_id:
         type: integer(4)
         primary: true
      label_id:
         type: integer(4)
         primary: true
   relations:
      Article:
         class: LyraArticle
         local: article_id
         foreign: id
         onDelete: CASCADE
      Label:
         class: LyraLabel
         local: label_id
         foreign: id
         onDelete: CASCADE

LyraSettings:
  tableName: settings
  options:
    collate: utf8_unicode_ci
    charset: utf8
  columns:
    id:
      type: integer(4)
      primary: true
      autoincrement: true
    params:
      type: clob

LyraUserProfile:
  tableName: users
  options:
    collate: utf8_unicode_ci
    charset: utf8
  columns:
    id:
      type: integer(4)
      primary: true
      autoincrement: true
    user_id:
      type: integer(4)
    first_name:
      type: string(80)
    last_name:
      type: string(80)
    email:
      type: string(150)
    is_verified:
      type: boolean
      notnull: true
      default: false
    vtoken:
      type: string(255)
  relations:
    User:
      class: sfGuardUser
      local: user_id
      foreign: id
      type: one
      foreignType: one
      foreignAlias: Profile
      onDelete: CASCADE

LyraMenu:
  tableName: menus
  actAs:
    NestedSet:
      hasManyRoots: true
      rootColumnName: root_id
  options:
    collate: utf8_unicode_ci
    charset: utf8
  columns:
    id:
      type: integer(4)
      primary: true
      autoincrement: true
    parent_id:
      type: integer(4)
    type:
      type: string(20)
      notnull: true
    ctype_id:
      type: integer(4)
    object_id:
      type: integer(4)
    list_id:
      type: integer(4)
    name:
      type: string(255)
      notnull: true
    params:
      type: clob
  relations:
    MenuParent:
      class: LyraMenu
      local: parent_id
      foreign: id
      type: one
      onDelete: SET NULL
    MenuContentType:
      class: LyraContentType
      local: ctype_id
      foreign: id
      onDelete: CASCADE
    MenuItemObject:
      #TODO: class will be LyraContent
      class: LyraArticle
      local: object_id
      foreign: id
      onDelete: CASCADE
    MenuItemList:
      class: LyraRoute
      local: list_id
      foreign: id
      onDelete: CASCADE

LyraPath:
  tableName: paths
  options:
    collate: utf8_unicode_ci
    charset: utf8
    symfony:
      form: false
      filter: false
  columns:
    id:
      type: integer(4)
      primary: true
      autoincrement: true
    content_id:
      type: integer(4)
    ctype_id:
      type: integer(4)
    path:
      type: string(255)
    pattern:
      type: string(255)
    is_active:
      type: boolean
      notnull: true
      default: false
  indexes:
    path_index:
      fields: [path]
  relations:
    PathContentType:
      class: LyraContentType
      local: ctype_id
      foreign: id
      onDelete: CASCADE

Show details Hide details

Change log

r94 by gimassimo on Nov 30, 2010 Diff

Added relation to LyraRoute in LyraMenu
and made needed changes to LyraMenuForm.

Go to:

Project members, sign in to write a code review

Older revisions

r91 by gimassimo on Nov 29, 2010 Diff

Removed some useless form and filter
classes, cleaned models.

r82 by gimassimo on Nov 12, 2010 Diff

Moved ContentType relation to
LyraContent class.

r81 by gimassimo on Nov 12, 2010 Diff

Moved metatags management functions to
LyraContent class.

All revisions of this file

File info

Size: 9808 bytes, 501 lines

View raw file