Account:
  columns:
    id:
      type: integer
      primary: true
      autoincrement: true
      unsigned: true
    domain:
      type: string(255)
      fixed: false
      primary: false
      notnull: true
      autoincrement: false
    username:
      type: string(100)
      fixed: false
      primary: false
      notnull: true
      autoincrement: false
    password:
      type: string(100)
      fixed: false
      primary: false
      notnull: true
      autoincrement: false
    parent:
      type: integer
      unsigned: true
      default: '0'
      notnull: true
    ssl_cert:
      type: string(3000)
    ssl_key:
      type: string(3000)
    plan_id:
      type: integer
      unsigned: true
    ipaddress_id:
      type: integer
      unsigned: true
    accounttype_id:
      type: integer
      unsigned: true
    user_id:
      type: integer
      unsigned: true
    server_id:
      type: integer
      unsigned: true
  relations:
    Subaccounts:
      class: Account
      local: parent
      foreign: child
      refClass: SubaccountReference
      equal: true
    Server:
      local: server_id
      foreign: id

SubaccountReference:
  columns:
    parent:
      type: integer
      unsigned: true
      primary: true
    child:
      type: integer
      unsigned: true
      primary: true

Configuration:
  columns:
    id:
      type: integer
      primary: true
      autoincrement: true
      unsigned: true
    field:
      type: string(100)
    value:
      type: string(255)

Ipaddress:
  columns:
    id:
      type: integer
      primary: true
      autoincrement: true
      unsigned: true
    ipblock_id:
      type: integer
      unsigned: true
    server_id:
      type: integer
      unsigned: true
    account_id:
      type: integer
      unsigned: true
    ip:
      type: string(128)
    rdns:
      type: string(255)
    reserved:
      type: integer(1)
      unsigned: 1
      default: '0'
      notnull: true

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:
    Ipaddresses:
      type: many
      class: Ipaddress
      local: id
      foreign: ipblock_id

Plan:
  columns:
    id:
      type: integer
      primary: true
      autoincrement: true
      unsigned: true
    name:
      type: string(255)
    ram:
      type: string(100)
    disk:
      type: string(100)
    bandwidth:
      type: string(100)
    type:
      type: string(30)
      primary: false
      default: openvz
      notnull: true
  relations:
    Accounts:
      type: many
      class: Account
      local: id
      foreign: plan_id

Server:
  columns:
    id:
      type: integer
      primary: true
      autoincrement: true
      unsigned: true
    name:
      type: string(100)
    ip:
      type: string(128)
    int_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
      local: server_id
      foreign: ipblock_id
    Accounts:
      type: many
      class: Account
      local: id
      foreign: server_id

ServerBlock:
  columns:
    id:
      type: integer
      primary: true
      autoincrement: true
      unsigned: true
    server_id:
      type: integer
      primary: true
      unsigned: true
    ipblock_id:
      type: integer
      primary: true
      unsigned: true
  relations:
    Server:
      foreignAlias: ServerBlocks
    Ipblock:
      foreignAlias: ServerBlocks
    onDelete: CASCADE

Servertype:
  columns:
    id:
      type: integer
      primary: true
      autoincrement: true
      unsigned: true
    name:
      type: string(100)
    code:
      type: string(25)
  relations:
    Servers:
      type: many
      class: Server
      local: id
      foreign: servertype_id
    Accounts:
      type: many
      class: Account
      local: id
      foreign: accounttype_id

User:
  actAs: [Timestampable]
  columns:
    id:
      type: integer
      primary: true
      autoincrement: true
      unsigned: true
    is_active:
      type: integer(1)
      unsigned: 1
      default: '1'
      notnull: false
    is_admin:
      type: integer(1)
      unsigned: 1
      default: '0'
      notnull: false
    username:
      type: string(50)
    password:
      type: string(50)
    email:
      type: string(255)
    is_api:
      type: integer(1)
      unsigned: 1
      default: '0'
      notnull: true
  relations:
    Accounts:
      type: many
      class: Account
      local: id
      foreign: user_id