Revision 7349649b
Von Kivitendo Admin vor mehr als 8 Jahren hinzugefügt
| SL/DB/MetaSetup/Customer.pm | ||
|---|---|---|
| 38 | 38 |
iban => { type => 'text' },
|
| 39 | 39 |
id => { type => 'integer', not_null => 1, sequence => 'id' },
|
| 40 | 40 |
itime => { type => 'timestamp', default => 'now()' },
|
| 41 |
klass => { type => 'integer', default => '0' },
|
|
| 42 | 41 |
language => { type => 'text' },
|
| 43 | 42 |
language_id => { type => 'integer' },
|
| 44 | 43 |
mandate_date_of_signature => { type => 'date' },
|
| ... | ... | |
| 49 | 48 |
obsolete => { type => 'boolean', default => 'false' },
|
| 50 | 49 |
payment_id => { type => 'integer' },
|
| 51 | 50 |
phone => { type => 'text' },
|
| 51 |
pricegroup_id => { type => 'integer' },
|
|
| 52 | 52 |
salesman_id => { type => 'integer' },
|
| 53 | 53 |
street => { type => 'text' },
|
| 54 | 54 |
taxincluded => { type => 'boolean' },
|
| ... | ... | |
| 91 | 91 |
key_columns => { payment_id => 'id' },
|
| 92 | 92 |
}, |
| 93 | 93 |
|
| 94 |
pricegroup => {
|
|
| 95 |
class => 'SL::DB::Pricegroup', |
|
| 96 |
key_columns => { pricegroup_id => 'id' },
|
|
| 97 |
}, |
|
| 98 |
|
|
| 94 | 99 |
taxzone => {
|
| 95 | 100 |
class => 'SL::DB::TaxZone', |
| 96 | 101 |
key_columns => { taxzone_id => 'id' },
|
Auch abrufbar als: Unified diff
Kunde: Datenbanktabelle "klass" nach "pricegroup_id" migriert
und einen Fremdschlüssel gesetzt.