projekt kivitendo

# @depends:

# @charset: UTF-8

use strict;

die("This script cannot be run from the command line.") unless ($main::form);

# @depends: release_2_6_0 fix_acc_trans_ap_taxkey_bug

# @charset: utf-8

use strict;

use Data::Dumper;

die("This script cannot be run from the command line.") unless ($main::form);

# @depends: release_2_6_0

# @charset: utf-8

use strict;

use Data::Dumper;

die("This script cannot be run from the command line.") unless ($main::form);

-- @tag: buchungsgruppen_sortkey

-- @depends: release_2_4_1

ALTER TABLE buchungsgruppen ADD COLUMN sortkey integer;

CREATE SEQUENCE tmp_counter;

UPDATE buchungsgruppen SET sortkey = nextval('tmp_counter');

-- @tag: customer_long_entries

-- @description: Lange Spalten für Kundentabelle

-- @depends: release_2_6_1

ALTER TABLE customer ALTER COLUMN account_number TYPE text;

ALTER TABLE customer ALTER COLUMN bank_code TYPE text;

# @depends: release_2_6_0

# @charset: utf-8

use strict;

use Data::Dumper;

die("This script cannot be run from the command line.") unless ($main::form);

-- @tag: warehouse_add_bestbefore

-- @description: Spalten für Mindesthaltbarkeitsdatum

-- @depends: release_2_6_0

ALTER TABLE inventory ADD COLUMN bestbefore date;

ALTER TABLE delivery_order_items_stock ADD COLUMN bestbefore date;