Brieffunktion erste Version

[kivitendo-erp.git] / sql / Pg-upgrade2 / letter_date_type.sql

diff --git a/sql/Pg-upgrade2/letter_date_type.sql b/sql/Pg-upgrade2/letter_date_type.sql
new file mode 100644 (file)
index 0000000..8c6293a
--- /dev/null
+++ b/sql/Pg-upgrade2/letter_date_type.sql
@@ -0,0 +1,9 @@
+-- @tag: letter_date_type
+-- @description: Briefe: Datumsfeld als Datum speichern
+-- @depends: release_3_2_0 letter
+-- @encoding: utf-8
+ALTER TABLE letter ADD column date_date DATE;
+UPDATE letter SET date_date = date::DATE;
+ALTER TABLE letter DROP COLUMN date;
+ALTER TABLE letter RENAME COLUMN date_date TO date;
+