Revision 3eb3d1b1
Von Moritz Bunkus vor mehr als 11 Jahren hinzugefügt
SL/DB/MetaSetup/DeliveryOrder.pm | ||
---|---|---|
9 | 9 |
__PACKAGE__->meta->table('delivery_orders'); |
10 | 10 |
|
11 | 11 |
__PACKAGE__->meta->columns( |
12 |
id => { type => 'integer', not_null => 1, sequence => 'id' }, |
|
13 |
donumber => { type => 'text', not_null => 1 }, |
|
14 |
ordnumber => { type => 'text' }, |
|
15 |
transdate => { type => 'date', default => 'now()' }, |
|
16 |
vendor_id => { type => 'integer' }, |
|
17 |
customer_id => { type => 'integer' }, |
|
18 |
reqdate => { type => 'date' }, |
|
19 |
shippingpoint => { type => 'text' }, |
|
20 |
notes => { type => 'text' }, |
|
21 |
intnotes => { type => 'text' }, |
|
22 |
employee_id => { type => 'integer' }, |
|
23 | 12 |
closed => { type => 'boolean', default => 'false' }, |
24 |
delivered => { type => 'boolean', default => 'false' }, |
|
13 |
cp_id => { type => 'integer' }, |
|
14 |
currency_id => { type => 'integer', not_null => 1 }, |
|
25 | 15 |
cusordnumber => { type => 'text' }, |
26 |
oreqnumber => { type => 'text' }, |
|
16 |
customer_id => { type => 'integer' }, |
|
17 |
delivered => { type => 'boolean', default => 'false' }, |
|
27 | 18 |
department_id => { type => 'integer' }, |
28 |
shipvia => { type => 'text' }, |
|
29 |
cp_id => { type => 'integer' }, |
|
30 |
language_id => { type => 'integer' }, |
|
31 |
shipto_id => { type => 'integer' }, |
|
19 |
donumber => { type => 'text', not_null => 1 }, |
|
20 |
employee_id => { type => 'integer' }, |
|
32 | 21 |
globalproject_id => { type => 'integer' }, |
33 |
salesman_id => { type => 'integer' },
|
|
34 |
transaction_description => { type => 'text' },
|
|
22 |
id => { type => 'integer', not_null => 1, sequence => 'id' },
|
|
23 |
intnotes => { type => 'text' },
|
|
35 | 24 |
is_sales => { type => 'boolean' }, |
36 | 25 |
itime => { type => 'timestamp', default => 'now()' }, |
26 |
language_id => { type => 'integer' }, |
|
37 | 27 |
mtime => { type => 'timestamp' }, |
38 |
taxzone_id => { type => 'integer' }, |
|
28 |
notes => { type => 'text' }, |
|
29 |
ordnumber => { type => 'text' }, |
|
30 |
oreqnumber => { type => 'text' }, |
|
31 |
reqdate => { type => 'date' }, |
|
32 |
salesman_id => { type => 'integer' }, |
|
33 |
shippingpoint => { type => 'text' }, |
|
34 |
shipto_id => { type => 'integer' }, |
|
35 |
shipvia => { type => 'text' }, |
|
39 | 36 |
taxincluded => { type => 'boolean' }, |
37 |
taxzone_id => { type => 'integer' }, |
|
40 | 38 |
terms => { type => 'integer' }, |
41 |
currency_id => { type => 'integer', not_null => 1 }, |
|
39 |
transaction_description => { type => 'text' }, |
|
40 |
transdate => { type => 'date', default => 'now()' }, |
|
41 |
vendor_id => { type => 'integer' }, |
|
42 | 42 |
); |
43 | 43 |
|
44 | 44 |
__PACKAGE__->meta->primary_key_columns([ 'id' ]); |
... | ... | |
97 | 97 |
}, |
98 | 98 |
); |
99 | 99 |
|
100 |
# __PACKAGE__->meta->initialize; |
|
101 |
|
|
102 | 100 |
1; |
103 | 101 |
; |
Auch abrufbar als: Unified diff
MetaSetup: Spalten- und Fremdschlüsselnamen alphabetisch sortieren