Revision 2d193a2e
Von Jan Büren vor mehr als 12 Jahren hinzugefügt
| SL/DB/MetaSetup/Customer.pm | ||
|---|---|---|
| 37 | 37 |
bank_code => { type => 'text' },
|
| 38 | 38 |
bank => { type => 'text' },
|
| 39 | 39 |
language => { type => 'varchar', length => 5 },
|
| 40 |
datevexport => { type => 'integer' },
|
|
| 41 | 40 |
itime => { type => 'timestamp', default => 'now()' },
|
| 42 | 41 |
mtime => { type => 'timestamp' },
|
| 43 | 42 |
obsolete => { type => 'boolean', default => 'false' },
|
| ... | ... | |
| 51 | 50 |
taxzone_id => { type => 'integer', default => '0', not_null => 1 },
|
| 52 | 51 |
greeting => { type => 'text' },
|
| 53 | 52 |
ustid => { type => 'text' },
|
| 54 |
direct_debit => { type => 'boolean', default => 'false' },
|
|
| 55 | 53 |
iban => { type => 'varchar', length => 100 },
|
| 56 | 54 |
bic => { type => 'varchar', length => 100 },
|
| 55 |
direct_debit => { type => 'boolean', default => 'false' },
|
|
| 57 | 56 |
curr => { type => 'character', length => 3 },
|
| 58 | 57 |
], |
| 59 | 58 |
|
| SL/DB/MetaSetup/Vendor.pm | ||
|---|---|---|
| 38 | 38 |
bank_code => { type => 'varchar', length => 10 },
|
| 39 | 39 |
bank => { type => 'text' },
|
| 40 | 40 |
language => { type => 'varchar', length => 5 },
|
| 41 |
datevexport => { type => 'integer' },
|
|
| 42 | 41 |
itime => { type => 'timestamp', default => 'now()' },
|
| 43 | 42 |
mtime => { type => 'timestamp' },
|
| 44 | 43 |
obsolete => { type => 'boolean', default => 'false' },
|
| ... | ... | |
| 51 | 50 |
taxzone_id => { type => 'integer', default => '0', not_null => 1 },
|
| 52 | 51 |
greeting => { type => 'text' },
|
| 53 | 52 |
ustid => { type => 'varchar', length => 14 },
|
| 54 |
direct_debit => { type => 'boolean', default => 'false' },
|
|
| 55 | 53 |
iban => { type => 'varchar', length => 100 },
|
| 56 | 54 |
bic => { type => 'varchar', length => 100 },
|
| 55 |
direct_debit => { type => 'boolean', default => 'false' },
|
|
| 57 | 56 |
curr => { type => 'character', length => 3 },
|
| 58 | 57 |
], |
| 59 | 58 |
|
| 60 | 59 |
primary_key_columns => [ 'id' ], |
| 61 | 60 |
|
| 62 |
allow_inline_column_values => 1, |
|
| 63 |
|
|
| 64 | 61 |
foreign_keys => [ |
| 65 | 62 |
business => {
|
| 66 | 63 |
class => 'SL::DB::Business', |
| sql/Pg-upgrade2/drop_datevexport.sql | ||
|---|---|---|
| 1 |
-- @tag: drop_datevexport |
|
| 2 |
-- @description: Entfernen der Spalte datevexport in Tabelle chart, vendor und customer. Dieser Status wird beim Datevexport überhaupt nicht berücksichtigt. |
|
| 3 |
-- @charset: utf-8 |
|
| 4 |
-- @depends: release_2_6_3 |
|
| 5 |
ALTER TABLE vendor DROP COLUMN datevexport; |
|
| 6 |
ALTER TABLE customer DROP COLUMN datevexport; |
|
| 7 |
DROP TRIGGER vendor_datevexport on vendor; |
|
| 8 |
DROP TRIGGER customer_datevexport on customer; |
|
| 9 |
DROP FUNCTION set_datevexport(); |
|
Auch abrufbar als: Unified diff
Entfernen der Spalte datevexport in Tabelle vendor und customer.
Dieser Status wird beim Datevexport überhaupt nicht berücksichtigt.
Entsprechend auch die Funktion setdatevexport und die beiden Trigger
customer_datevexport und vendor_datevexport rausgenommen.