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

diff --git a/sql/Pg-upgrade/Pg-upgrade-2.2.0.3-2.2.0.4.sql b/sql/Pg-upgrade/Pg-upgrade-2.2.0.3-2.2.0.4.sql
deleted file mode 100644
index 31b758c21..000000000
--- a/sql/Pg-upgrade/Pg-upgrade-2.2.0.3-2.2.0.4.sql
+++ /dev/null
@@ -1,52 +0,0 @@
-CREATE TABLE units (
-  name varchar(20) NOT NULL,
-  base_unit varchar(20),
-  factor bigint,
-
-  PRIMARY KEY (name),
-  FOREIGN KEY (base_unit) REFERENCES units (name)
-);
-
-INSERT INTO units (name, base_unit, factor) VALUES ('mg', NULL, NULL);
-INSERT INTO units (name, base_unit, factor) VALUES ('g', 'mg', 1000);
-INSERT INTO units (name, base_unit, factor) VALUES ('kg', 'g', 1000);
-INSERT INTO units (name, base_unit, factor) VALUES ('t', 'kg', 1000);
-INSERT INTO units (name, base_unit, factor) VALUES ('ml', NULL, NULL);
-INSERT INTO units (name, base_unit, factor) VALUES ('L', 'ml', 1000);
-INSERT INTO units (name, base_unit, factor) VALUES ('Stck', NULL, NULL);
-ALTER TABLE units ADD COLUMN active boolean;
-UPDATE units SET active = 't';
-ALTER TABLE units ALTER COLUMN active SET DEFAULT 't';
-ALTER TABLE units ALTER COLUMN active SET NOT NULL;
-
-ALTER TABLE units ADD COLUMN tmp numeric(20, 5);
-UPDATE units SET tmp = factor;
-ALTER TABLE units DROP COLUMN factor;
-ALTER TABLE units RENAME tmp TO factor;
-
-ALTER TABLE units ADD COLUMN type varchar(20);
-UPDATE units SET type = 'dimension';
-ALTER TABLE units ALTER COLUMN type SET NOT NULL;
-
--- Einheitennamen duerfen 20 Zeichen lang sein.
-
-ALTER TABLE parts ADD COLUMN tmp varchar(20);
-UPDATE parts SET tmp = unit;
-ALTER TABLE parts DROP COLUMN unit;
-ALTER TABLE parts RENAME tmp TO unit;
-
-ALTER TABLE invoice ADD COLUMN tmp varchar(20);
-UPDATE invoice SET tmp = unit;
-ALTER TABLE invoice DROP COLUMN unit;
-ALTER TABLE invoice RENAME tmp TO unit;
-
-ALTER TABLE orderitems ADD COLUMN tmp varchar(20);
-UPDATE orderitems SET tmp = unit;
-ALTER TABLE orderitems DROP COLUMN unit;
-ALTER TABLE orderitems RENAME tmp TO unit;
-
--- Spalte "active" wird nicht mehr benoetigt, weil Einheiten nicht mehr deaktiviert
--- werden koennen.
-
-ALTER TABLE units DROP COLUMN active;
-