X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/87e190b46ddee16b2cf7a2e52e1bbc8555a41f8e..77bd52c1d2e325219aaf94432d0d81cfb7ace2b8:/sql/Pg-upgrade2/drop_sic_code.sql?ds=sidebyside

diff --git a/sql/Pg-upgrade2/drop_sic_code.sql b/sql/Pg-upgrade2/drop_sic_code.sql
new file mode 100644
index 000000000..a41c21877
--- /dev/null
+++ b/sql/Pg-upgrade2/drop_sic_code.sql
@@ -0,0 +1,6 @@
+-- @tag: sic_code 
+-- @description: Loescht alle Datenstrukturen die mit sic_code zu tun haben inkl. der Tabelle sic (Standard Industrial Classification) selber. Niemand kann in der aktuellen Version dieses Feld aendern.
+-- @depends: release_2_4_3
+DROP TABLE sic;
+ALTER TABLE customer DROP COLUMN sic_code;
+ALTER TABLE vendor DROP COLUMN  sic_code;