projects
/
kivitendo-erp.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
Revert "Briefe: Rechteprüfung gefixed"
[kivitendo-erp.git]
/
sql
/
Pg-upgrade2
/
project_bob_attributes_itime_default_fix.sql
diff --git
a/sql/Pg-upgrade2/project_bob_attributes_itime_default_fix.sql
b/sql/Pg-upgrade2/project_bob_attributes_itime_default_fix.sql
index
190254b
..
f048999
100644
(file)
--- a/
sql/Pg-upgrade2/project_bob_attributes_itime_default_fix.sql
+++ b/
sql/Pg-upgrade2/project_bob_attributes_itime_default_fix.sql
@@
-1,6
+1,6
@@
-- @tag: project_bob_attributes_itime_default_fix
-- @description: Standardwert für 'itime'-Spalten in Bob-Tabellen fixen
-- @tag: project_bob_attributes_itime_default_fix
-- @description: Standardwert für 'itime'-Spalten in Bob-Tabellen fixen
--- @depends:
release_3_0_0
+-- @depends:
project_bob_attributes
ALTER TABLE project ALTER COLUMN itime SET DEFAULT now();
ALTER TABLE project_status ALTER COLUMN itime SET DEFAULT now();
ALTER TABLE project ALTER COLUMN itime SET DEFAULT now();
ALTER TABLE project_status ALTER COLUMN itime SET DEFAULT now();