User:
  tableName: users
  columns:
    id:
      type: integer
      primary: true
      unsigned: true
      notnull: true
      autoincrement: true
    old_id:
      type: integer
    lastname:
      type: string(32)
    firstname:
      type: string(32)
    email:
      type: string(64)
    login:
      type: string(32)
    pass:
      type: blob
    level:
      type: string(24)
    store_id:
       type: integer(1)
       unsigned: true
       notnull: true
  relations:
    Store:
      local: store_id
      foreign: id
    Rights:
      class: Right
      refClass: UserRight
      local: user_id
      foreign: right_id
  indexes:
    oldindex:
      fields: old_id
  options:
    type: InnoDB
    collate: utf8_general_ci
    charset: utf8

Right:
  tableName: rights
  columns:
    id:
      type: integer
      primary: true
      autoincrement: true
    name:
      type: string
      notnull: true
  options:
    type: InnoDB
    collate: utf8_general_ci
    charset: utf8
  relations:
    Users:
      class: User
      refClass: UserRight
      local: right_id
      foreign: user_id

UserRight:
  tableName: user_rights
  columns:
    user_id:
      type: integer
      unsigned: true
    right_id:
      type: integer
      unsigned: true
  relations:
    User:
      local: user_id
      foreign: id
      onDelete: CASCADE
    Right:
      local: right_id
      foreign: id