Revision 3eb3d1b1
Von Moritz Bunkus vor mehr als 11 Jahren hinzugefügt
SL/DB/MetaSetup/Exchangerate.pm | ||
---|---|---|
9 | 9 |
__PACKAGE__->meta->table('exchangerate'); |
10 | 10 |
|
11 | 11 |
__PACKAGE__->meta->columns( |
12 |
transdate => { type => 'date' }, |
|
13 | 12 |
buy => { type => 'numeric', precision => 5, scale => 15 }, |
14 |
sell => { type => 'numeric', precision => 5, scale => 15 }, |
|
13 |
currency_id => { type => 'integer', not_null => 1 }, |
|
14 |
id => { type => 'serial', not_null => 1 }, |
|
15 | 15 |
itime => { type => 'timestamp', default => 'now()' }, |
16 | 16 |
mtime => { type => 'timestamp' }, |
17 |
id => { type => 'serial', not_null => 1 },
|
|
18 |
currency_id => { type => 'integer', not_null => 1 },
|
|
17 |
sell => { type => 'numeric', precision => 5, scale => 15 },
|
|
18 |
transdate => { type => 'date' },
|
|
19 | 19 |
); |
20 | 20 |
|
21 | 21 |
__PACKAGE__->meta->primary_key_columns([ 'id' ]); |
... | ... | |
29 | 29 |
}, |
30 | 30 |
); |
31 | 31 |
|
32 |
# __PACKAGE__->meta->initialize; |
|
33 |
|
|
34 | 32 |
1; |
35 | 33 |
; |
Auch abrufbar als: Unified diff
MetaSetup: Spalten- und Fremdschlüsselnamen alphabetisch sortieren