Revision ea08b7df
Von Jan Büren vor etwa 1 Jahr hinzugefügt
| SL/DB/MetaSetup/Default.pm | ||
|---|---|---|
|
always_record_links_from_order => { type => 'boolean', default => 'false' },
|
||
|
ap_add_doc => { type => 'boolean', default => 'false', not_null => 1 },
|
||
|
ap_changeable => { type => 'integer', default => 2, not_null => 1 },
|
||
|
ap_chart_id => { type => 'integer' },
|
||
|
ap_chart_id => { type => 'integer', not_null => 1 },
|
||
|
ap_show_mark_as_paid => { type => 'boolean', default => 'true' },
|
||
|
ar_add_doc => { type => 'boolean', default => 'false', not_null => 1 },
|
||
|
ar_changeable => { type => 'integer', default => 2, not_null => 1 },
|
||
|
ar_chart_id => { type => 'integer' },
|
||
|
ar_chart_id => { type => 'integer', not_null => 1 },
|
||
|
ar_paid_accno_id => { type => 'integer' },
|
||
|
ar_show_mark_as_paid => { type => 'boolean', default => 'true' },
|
||
|
articlenumber => { type => 'text' },
|
||
| sql/Pg-upgrade2/defaults_set_ARAP.sql | ||
|---|---|---|
|
-- @tag: defaults_set_ARAP
|
||
|
-- @description: Standardkonten für Forderungen und Verbindlichkeiten sind jetzt Pflichtfelder
|
||
|
-- @depends: release_3_9_0
|
||
|
DO $$
|
||
|
BEGIN
|
||
|
|
||
|
IF (select 1 from defaults where ap_chart_id is null) THEN
|
||
|
BEGIN
|
||
|
UPDATE defaults set ap_chart_id = (select id from chart where link ='AP' order by id LIMIT 1);
|
||
|
END;
|
||
|
END IF;
|
||
|
IF (select 1 from defaults where ar_chart_id is null) THEN
|
||
|
BEGIN
|
||
|
UPDATE defaults set ar_chart_id = (select id from chart where link ='AR' order by id LIMIT 1);
|
||
|
END;
|
||
|
END IF;
|
||
|
END $$;
|
||
|
|
||
|
ALTER TABLE defaults ALTER COLUMN ap_chart_id set not null;
|
||
|
ALTER TABLE defaults ALTER COLUMN ar_chart_id set not null;
|
||
Auch abrufbar als: Unified diff
vorkonfigurierte Sammelkonten sind jetzt ein Pflichtfeld