Revision 3eb3d1b1
Von Moritz Bunkus vor mehr als 11 Jahren hinzugefügt
SL/DB/MetaSetup/Datev.pm | ||
---|---|---|
9 | 9 |
__PACKAGE__->meta->table('datev'); |
10 | 10 |
|
11 | 11 |
__PACKAGE__->meta->columns( |
12 |
beraternr => { type => 'varchar', length => 7 },
|
|
12 |
abrechnungsnr => { type => 'varchar', length => 6 },
|
|
13 | 13 |
beratername => { type => 'varchar', length => 9 }, |
14 |
mandantennr => { type => 'varchar', length => 5 }, |
|
15 |
dfvkz => { type => 'varchar', length => 2 }, |
|
14 |
beraternr => { type => 'varchar', length => 7 }, |
|
16 | 15 |
datentraegernr => { type => 'varchar', length => 3 }, |
17 |
abrechnungsnr => { type => 'varchar', length => 6 }, |
|
16 |
dfvkz => { type => 'varchar', length => 2 }, |
|
17 |
id => { type => 'serial', not_null => 1 }, |
|
18 | 18 |
itime => { type => 'timestamp', default => 'now()' }, |
19 |
mandantennr => { type => 'varchar', length => 5 }, |
|
19 | 20 |
mtime => { type => 'timestamp' }, |
20 |
id => { type => 'serial', not_null => 1 }, |
|
21 | 21 |
); |
22 | 22 |
|
23 | 23 |
__PACKAGE__->meta->primary_key_columns([ 'id' ]); |
24 | 24 |
|
25 | 25 |
__PACKAGE__->meta->allow_inline_column_values(1); |
26 | 26 |
|
27 |
# __PACKAGE__->meta->initialize; |
|
28 |
|
|
29 | 27 |
1; |
30 | 28 |
; |
Auch abrufbar als: Unified diff
MetaSetup: Spalten- und Fremdschlüsselnamen alphabetisch sortieren