projekt kivitendo

__PACKAGE__->meta->table('chart');

__PACKAGE__->meta->columns(

  id             => { type => 'integer', not_null => 1, sequence => 'id' },

  accno          => { type => 'text', not_null => 1 },

  description    => { type => 'text' },

  charttype      => { type => 'character', default => 'A', length => 1 },

  category       => { type => 'character', length => 1 },

  link           => { type => 'text', not_null => 1 },

  taxkey_id      => { type => 'integer' },

  pos_bwa        => { type => 'integer' },

  pos_bilanz     => { type => 'integer' },

  pos_eur        => { type => 'integer' },

  datevautomatik => { type => 'boolean', default => 'false' },

  itime          => { type => 'timestamp', default => 'now()' },

  mtime          => { type => 'timestamp' },

  new_chart_id   => { type => 'integer' },

  valid_from     => { type => 'date' },

__PACKAGE__->meta->primary_key_columns([ 'id' ]);

__PACKAGE__->meta->unique_keys([ 'accno' ]);

__PACKAGE__->meta->allow_inline_column_values(1);

# __PACKAGE__->meta->initialize;