Revision 3dc3b1bc
Von Bernd Bleßmann vor mehr als 2 Jahren hinzugefügt
| SL/DB/MetaSetup/Order.pm | ||
|---|---|---|
| 35 | 35 |
netamount => { type => 'numeric', precision => 15, scale => 5 },
|
| 36 | 36 |
notes => { type => 'text' },
|
| 37 | 37 |
order_probability => { type => 'integer', default => '0', not_null => 1 },
|
| 38 |
order_status_id => { type => 'integer' },
|
|
| 38 | 39 |
ordnumber => { type => 'text', not_null => 1 },
|
| 39 | 40 |
payment_id => { type => 'integer' },
|
| 40 | 41 |
proforma => { type => 'boolean', default => 'false' },
|
| ... | ... | |
| 113 | 114 |
key_columns => { language_id => 'id' },
|
| 114 | 115 |
}, |
| 115 | 116 |
|
| 117 |
order_status => {
|
|
| 118 |
class => 'SL::DB::OrderStatus', |
|
| 119 |
key_columns => { order_status_id => 'id' },
|
|
| 120 |
}, |
|
| 121 |
|
|
| 116 | 122 |
payment_terms => {
|
| 117 | 123 |
class => 'SL::DB::PaymentTerm', |
| 118 | 124 |
key_columns => { payment_id => 'id' },
|
| sql/Pg-upgrade2/oe_add_order_status.sql | ||
|---|---|---|
| 1 |
-- @tag: oe_add_order_status |
|
| 2 |
-- @description: Status für Angebote und Aufträge: Feld in Angebot/Auftrags-Tabelle |
|
| 3 |
-- @depends: order_statuses |
|
| 4 |
|
|
| 5 |
ALTER TABLE oe ADD COLUMN order_status_id INTEGER REFERENCES order_statuses(id); |
|
Auch abrufbar als: Unified diff
Angebot/Auftrag Status: Feld in Tabelle für Angebote/Aufträge: DB und Rose