X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=SL%2FDB%2FMetaSetup%2FExchangerate.pm;h=f6dc3ff9f0904d4df5ece582d096ed6504161ca6;hb=d0c938cfb5fbb8c1c03b94d395d6c7839a1c597e;hp=95ea23c172b53ab207388c8262e63182c4ce84c2;hpb=f97b07787db5cacc0f90338fdb3c1237262917cb;p=kivitendo-erp.git diff --git a/SL/DB/MetaSetup/Exchangerate.pm b/SL/DB/MetaSetup/Exchangerate.pm index 95ea23c17..f6dc3ff9f 100644 --- a/SL/DB/MetaSetup/Exchangerate.pm +++ b/SL/DB/MetaSetup/Exchangerate.pm @@ -10,18 +10,16 @@ __PACKAGE__->meta->setup( table => 'exchangerate', columns => [ - curr => { type => 'character', length => 3 }, - transdate => { type => 'date' }, - buy => { type => 'numeric', precision => 5, scale => 15 }, - sell => { type => 'numeric', precision => 5, scale => 15 }, - itime => { type => 'timestamp', default => 'now()' }, - mtime => { type => 'timestamp' }, - id => { type => 'serial', not_null => 1 }, + transdate => { type => 'date' }, + buy => { type => 'numeric', precision => 5, scale => 15 }, + sell => { type => 'numeric', precision => 5, scale => 15 }, + itime => { type => 'timestamp', default => 'now()' }, + mtime => { type => 'timestamp' }, + id => { type => 'serial', not_null => 1 }, + currency_id => { type => 'integer', not_null => 1 }, ], primary_key_columns => [ 'id' ], - - allow_inline_column_values => 1, ); 1;