---
detect_relations: true
options:
  type: InnoDB
  collate: utf8_unicode_ci
  charset: utf8

User:
  tableName: acl_users
  columns:
    full_name:
      type: string(255)
      notnull: true
    username:
      type: string(255)
      notnull: true
    password:
      type: string(255)
      notnull: true
    role_id: integer

Role:
  tableName: acl_roles
  columns:
    name:
      type: string(255)
      notnull: true
    description:
      type: string

Resource:
  tableName: acl_resources
  columns:
    name:
      type: string(255)
      notnull: true
    description:
      type: string

Permission:
  tableName: acl_permissions
  columns:
    role_id: integer
    resource_id: integer
    `read`:
      type: boolean
      default: false
    `write`:
      type: boolean
      default: false
    modify:
      type: boolean
      default: false
    `delete`:
      type: boolean
      default: false
    publish:
      type: boolean
      default: false
    description:
      type: string