projects
/
kivitendo-erp.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
Beistell-Lieferschein: nur diesen Typ dort anbieten
[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
index
8c6293a
..
931e8f0
100644
(file)
--- a/
sql/Pg-upgrade2/letter_date_type.sql
+++ b/
sql/Pg-upgrade2/letter_date_type.sql
@@
-1,7
+1,6
@@
-- @tag: letter_date_type
-- @description: Briefe: Datumsfeld als Datum speichern
-- @depends: release_3_2_0 letter
-- @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 ADD column date_date DATE;
UPDATE letter SET date_date = date::DATE;
ALTER TABLE letter DROP COLUMN date;