X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/b8b112a39bd601b0bc717646d78de470631da22a..eebe8e90991eacadb6fbd20a648c152017a620c7:/SL/DB/MetaSetup/Exchangerate.pm diff --git a/SL/DB/MetaSetup/Exchangerate.pm b/SL/DB/MetaSetup/Exchangerate.pm index 43df5dfd6..7b90ab217 100644 --- a/SL/DB/MetaSetup/Exchangerate.pm +++ b/SL/DB/MetaSetup/Exchangerate.pm @@ -9,13 +9,13 @@ use base qw(SL::DB::Object); __PACKAGE__->meta->table('exchangerate'); __PACKAGE__->meta->columns( - transdate => { type => 'date' }, - buy => { type => 'numeric', precision => 5, scale => 15 }, - sell => { type => 'numeric', precision => 5, scale => 15 }, + buy => { type => 'numeric', precision => 15, scale => 5 }, + currency_id => { type => 'integer', not_null => 1 }, + id => { type => 'serial', not_null => 1 }, itime => { type => 'timestamp', default => 'now()' }, mtime => { type => 'timestamp' }, - id => { type => 'serial', not_null => 1 }, - currency_id => { type => 'integer', not_null => 1 }, + sell => { type => 'numeric', precision => 15, scale => 5 }, + transdate => { type => 'date' }, ); __PACKAGE__->meta->primary_key_columns([ 'id' ]); @@ -29,7 +29,5 @@ __PACKAGE__->meta->foreign_keys( }, ); -# __PACKAGE__->meta->initialize; - 1; ;