Ipblock:
  columns:
    id:
      type: integer
      primary: true
      autoincrement: true
      unsigned: true
    name:
      type: string(100)
    gateway:
      type: string(100)
    ns1:
      type: string(100)
    ns2:
      type: string(100)
    cidr:
      type: integer(4)
      unsigned: 1
      notnull: true
    iptype:
      type: integer(1)
      unsigned: 1
      default: '4'
      notnull: true
    internal:
      type: integer(1)
      unsigned: 1
      default: '0'
  relations:
    Servers:
      foreignAlias: Ipblocks
      class: Server
      refClass: ServerBlock

Server:
  columns:
    id:
      type: integer
      primary: true
      autoincrement: true
      unsigned: true
    name:
      type: string(100)
    ip:
      type: string(128)
    hostname:
      type: string(100)
    username:
      type: string(100)
    password:
      type: string(100)
    port:
      type: integer(4)
      unsigned: 1
      default: '8888'
      notnull: true
    location:
      type: string(100)
    status:
      type: integer(1)
      unsigned: 1
      default: '1'
      notnull: true
    arch:
      type: string(10)
      default: i386
      notnull: true
    servertype_id:
      type: integer
      unsigned: true
  relations:
    Ipblocks:
      foreignAlias: Servers
      class: Ipblock
      refClass: ServerBlock

ServerBlock:
  columns:
    server_id:
      type: integer
      primary: true
      unsigned: true
    ipblock_id:
      type: integer
      primary: true
      unsigned: true
  relations:
    Server:
      foreignAlias: ServerBlocks
    Ipblock:
      foreignAlias: ServerBlocks