User:
  User_1:
    username: tboerger
    password: p1550r
    email: t.boerger@mosez.net
  User_2:
    username: foo
    password: qayqay
    email: t.boerger@mosez.net
  User_3:
    username: bar
    password: qayqay
    email: t.boerger@mosez.net
  User_4:
    username: baz
    password: qayqay
    email: t.boerger@mosez.net

UserProfile:
  UserProfile_1:
    User: User_1
    first_name: Thomas
    last_name: Boerger
  UserProfile_2:
    User: User_2
    first_name: Foo
    last_name: Haha
  UserProfile_3:
    User: User_3
    first_name: Bar
    last_name: Haha
  UserProfile_4:
    User: User_4
    first_name: Baz
    last_name: Haha

Right:
  Right_1:
    title: admin
    internal: admin

Group:
  Group_1:
    title: admin
    internal: admin

GroupRight:
  GroupRight_1:
    Group: Group_1
    Right: Right_1

UserGroup:
  UserGroup_1:
    Group: Group_1
    User: User_1
  UserGroup_2:
    Group: Group_1
    User: User_2









options:
  type: INNODB
  collate: utf8_unicode_ci
  charset: utf8

User:
  columns:
    id:
      type: integer(10)
      primary: true
      autoincrement: true
    slug:
      type: string(64)
    username:
      type: string(64)
    password:
      type: string(64)
    email:
      type: string(64)
  indexes:
    username:
      fields: [username]
      type: unique
  actAs:
    Activation:
    Authorable:
    Timestampable:
    Sluggable:
      fields: [username]
      type: string
      length: 64
      unique: true
      canUpdate: true
  relations:
    Profile:
      class: UserProfile
      local: id
      foreign: user_id
      type: one
      foreignType: one
      foreignAlias: User
    Created:
      class: User
      local: created_by
      foreign: id
      type: one
      foreignType: many
      foreignAlias: CreatedUsers
    Updated:
      class: User
      local: updated_by
      foreign: id
      type: one
      foreignType: many
      foreignAlias: UpdatedUsers
    Groups:
      class: Group
      local: user_id
      foreign: group_id
      refClass: UserGroup
      foreignAlias: Users
    Rights:
      class: Right
      local: user_id
      foreign: right_id
      refClass: UserRight
      foreignAlias: Users


UserProfile:
  columns:
    user_id:
      type: integer(10)
      primary: true
    first_name:
      type: string(255)
    last_name:
      type: string(255)
  relations:
    User:
      class: User
      local: user_id
      foreign: id
      type: one
      foreignType: one
      foreignAlias: Profile

Group:
  columns:
    id:
      type: integer(10)
      primary: true
      autoincrement: true
    internal:
      type: string(64)
    title:
      type: string(64)
    description:
      type: string(2000)
  indexes:
    internal:
      fields: [internal]
      type: unique
  actAs:
    Activation:
    Authorable:
    Timestampable:
  relations:
    Users:
      class: User
      refClass: UserGroup
      local: group_id
      foreign: user_id
      foreignAlias: Groups
    Rights:
      class: Right
      local: group_id
      foreign: right_id
      refClass: GroupRight
      foreignAlias: Groups

Right:
  columns:
    id:
      type: integer(10)
      primary: true
      autoincrement: true
    internal:
      type: string(64)
    title:
      type: string(64)
    description:
      type: string(2000)
  actAs:
    Activation:
    Authorable:
    Timestampable:

GroupRight:
  columns:
    group_id:
      type: integer(10)
      primary: true
    right_id:
      type: integer(10)
      primary: true
  relations:
    Group:
      local: group_id
      onDelete: CASCADE
    Right:
      local: right_id
      onDelete: CASCADE
  actAs:
    Timestampable:

UserRight:
  columns:
    user_id:
      type: integer(10)
      primary: true
    right_id:
      type: integer(10)
      primary: true
  relations:
    User:
      local: user_id
      onDelete: CASCADE
    Right:
      local: right_id
      onDelete: CASCADE
  actAs:
    Timestampable:

UserGroup:
  columns:
    user_id:
      type: integer(10)
      primary: true
    group_id:
      type: integer(10)
      primary: true
  relations:
    User:
      local: user_id
      onDelete: CASCADE
    Group:
      local: group_id
      onDelete: CASCADE
  actAs:
    Timestampable: