Revision 37ce1a9c
Von Waldemar Toews vor mehr als 11 Jahren hinzugefügt
| SL/DB/MetaSetup/Customer.pm | ||
|---|---|---|
|
delivery_term_id => { type => 'integer' },
|
||
|
department_1 => { type => 'varchar', length => 75 },
|
||
|
department_2 => { type => 'varchar', length => 75 },
|
||
|
depositor => { type => 'text' },
|
||
|
direct_debit => { type => 'boolean', default => 'false' },
|
||
|
discount => { type => 'float', precision => 4 },
|
||
|
email => { type => 'text' },
|
||
| SL/DB/MetaSetup/SepaExportItem.pm | ||
|---|---|---|
|
execution_date => { type => 'date' },
|
||
|
id => { type => 'integer', not_null => 1, sequence => 'id' },
|
||
|
our_bic => { type => 'varchar', length => 100 },
|
||
|
our_depositor => { type => 'text' },
|
||
|
our_iban => { type => 'varchar', length => 100 },
|
||
|
reference => { type => 'varchar', length => 35 },
|
||
|
requested_execution_date => { type => 'date' },
|
||
|
sepa_export_id => { type => 'integer', not_null => 1 },
|
||
|
vc_bic => { type => 'varchar', length => 100 },
|
||
|
vc_depositor => { type => 'text' },
|
||
|
vc_iban => { type => 'varchar', length => 100 },
|
||
|
);
|
||
|
|
||
| SL/DB/MetaSetup/Vendor.pm | ||
|---|---|---|
|
delivery_term_id => { type => 'integer' },
|
||
|
department_1 => { type => 'varchar', length => 75 },
|
||
|
department_2 => { type => 'varchar', length => 75 },
|
||
|
depositor => { type => 'text' },
|
||
|
direct_debit => { type => 'boolean', default => 'false' },
|
||
|
discount => { type => 'float', precision => 4 },
|
||
|
email => { type => 'text' },
|
||
| sql/Pg-upgrade2/add_depositor_for_customer_vendor.sql | ||
|---|---|---|
|
-- @tag: add_depositor_for_customer_vendor
|
||
|
-- @description: Einführen einer Depositor (Kontoinhaber) Spalte bei Customer bzw. Vendor
|
||
|
-- @depends: sepa
|
||
|
|
||
|
ALTER TABLE customer ADD depositor text;
|
||
|
ALTER TABLE vendor ADD depositor text;
|
||
|
ALTER TABLE sepa_export_items ADD our_depositor text;
|
||
|
ALTER TABLE sepa_export_items ADD vc_depositor text;
|
||
|
|
||
|
UPDATE customer SET depositor = name;
|
||
|
UPDATE vendor SET depositor = name;
|
||
Auch abrufbar als: Unified diff
Zusatzspalten fuer Kontoinhaber