Revision 55d2c2d5
Von Bernd Bleßmann vor mehr als 4 Jahren hinzugefügt
| SL/DB/MetaSetup/Customer.pm | ||
|---|---|---|
| 49 | 49 |
mandator_id => { type => 'text' },
|
| 50 | 50 |
mtime => { type => 'timestamp' },
|
| 51 | 51 |
name => { type => 'text', not_null => 1 },
|
| 52 |
natural_person => { type => 'boolean', default => 'false' },
|
|
| 52 | 53 |
notes => { type => 'text' },
|
| 53 | 54 |
obsolete => { type => 'boolean', default => 'false' },
|
| 54 | 55 |
order_lock => { type => 'boolean', default => 'false' },
|
| SL/DB/MetaSetup/Vendor.pm | ||
|---|---|---|
| 39 | 39 |
language_id => { type => 'integer' },
|
| 40 | 40 |
mtime => { type => 'timestamp' },
|
| 41 | 41 |
name => { type => 'text', not_null => 1 },
|
| 42 |
natural_person => { type => 'boolean', default => 'false' },
|
|
| 42 | 43 |
notes => { type => 'text' },
|
| 43 | 44 |
obsolete => { type => 'boolean', default => 'false' },
|
| 44 | 45 |
payment_id => { type => 'integer' },
|
| sql/Pg-upgrade2/customer_vendor_add_natural_person.sql | ||
|---|---|---|
| 1 |
-- @tag: customer_vendor_add_natural_person |
|
| 2 |
-- @description: neue Spalte für "natürliche Person" bei Kunden/Lieferanten |
|
| 3 |
-- @depends: release_3_5_5 |
|
| 4 |
|
|
| 5 |
ALTER TABLE customer ADD COLUMN natural_person BOOLEAN DEFAULT FALSE; |
|
| 6 |
ALTER TABLE vendor ADD COLUMN natural_person BOOLEAN DEFAULT FALSE; |
|
Auch abrufbar als: Unified diff
Kunden/-Lieferantenstamm: Flag "natürliche Person": DB-Upgrade + Rose