Versionen im Vergleich

Schlüssel

  • Diese Zeile wurde hinzugefügt.
  • Diese Zeile wurde entfernt.
  • Formatierung wurde geändert.

...

Codeblock
languagesql
themeMidnight
# Update
update "public"."account_analytic_account" set "name"='Werbekosten Allgemein' where "id"='574';
update "public"."account_analytic_plan" set "name"='411000 Werbekosten Allgemein' where "id"='575';
update "public"."account_analytic_plan_instance" set "name"='411000 Werbekosten Allgemein' where "id"='576';
update "public"."account_analytic_plan_line" set "name"='411000 Werbekosten Allgemein' where "id"='36';


# Löschen
delete from "public"."account_analytic_plan_instance" where "id"='613';

delete from "public"."account_analytic_plan" where "id"='612';
delete from "public"."account_analytic_plan_line" where "id"='73';

# "account_analytic_plan_instance_line" ist mittels analytic_account_id mit "account_analytic_account" vebunden
delete from "public"."account_analytic_plan_instance_line" where "id"='613'; 
delete from "public"."account_analytic_account" where "id"='611';


...