Alten DB-Upgrademechnismus sql/Pg-upgrade entfernt

[kivitendo-erp.git] / sql / Pg-upgrade / Pg-upgrade-2.2.0.17-2.2.0.18.sql

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 (file)
index 135cd60..0000000
--- 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