X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=sql%2FPg-upgrade%2FPg-upgrade-2.2.0.17-2.2.0.18.sql;fp=sql%2FPg-upgrade%2FPg-upgrade-2.2.0.17-2.2.0.18.sql;h=0000000000000000000000000000000000000000;hb=0e43d3cfea2cfdb938490c8221048b235f754fd3;hp=135cd603e7b9e312d3c2bc6fe668d61ac098486e;hpb=3774d83b865ab246d13077d24699b987a7a7aa05;p=kivitendo-erp.git

diff --git a/sql/Pg-upgrade/Pg-upgrade-2.2.0.17-2.2.0.18.sql b/sql/Pg-upgrade/Pg-upgrade-2.2.0.17-2.2.0.18.sql
deleted file mode 100644
index 135cd603e..000000000
--- a/sql/Pg-upgrade/Pg-upgrade-2.2.0.17-2.2.0.18.sql
+++ /dev/null
@@ -1,40 +0,0 @@
-create table dunning_config (
-  "id"  integer DEFAULT nextval('id'::text) PRIMARY KEY,
-  "dunning_level" integer,
-  "dunning_description" text,
-  "active" boolean,
-  "auto" boolean,
-  "email" boolean,
-  "terms" integer,
-  "payment_terms" integer,
-  "fee" numeric(15,5),
-  "interest" numeric(15,5),
-  "email_body" text,
-  "email_subject" text,
-  "email_attachment" boolean,
-  "template" text
-);
-
-create table dunning (
-  id  integer DEFAULT nextval('id'::text) PRIMARY KEY,
-  trans_id integer,
-  dunning_id integer,
-  dunning_level integer,
-  transdate date,
-  duedate date,
-  fee  numeric(15,5),
-  interest numeric(15,5)
-);
-
-alter table ar add column dunning_id integer;
-  
-
-CREATE FUNCTION set_priceupdate_parts() RETURNS opaque AS '
-    BEGIN
-        NEW.priceupdate := ''now'';
-        RETURN NEW;
-    END;
-' LANGUAGE plpgsql;
-
-CREATE TRIGGER priceupdate_parts AFTER UPDATE ON parts
-    FOR EACH ROW EXECUTE PROCEDURE set_priceupdate_parts();
\ No newline at end of file