X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/03f5aaa3c601956206f0c2a142c1e19f6981b326..9bbb6912f72c14e23a25ec0a26e8d68b45b224b8:/sql/Pg-upgrade2/project_bob_attributes.sql

diff --git a/sql/Pg-upgrade2/project_bob_attributes.sql b/sql/Pg-upgrade2/project_bob_attributes.sql
index 07bcec0d1..d651f1038 100644
--- a/sql/Pg-upgrade2/project_bob_attributes.sql
+++ b/sql/Pg-upgrade2/project_bob_attributes.sql
@@ -1,7 +1,6 @@
 -- @tag: project_bob_attributes
 -- @description: Projekte: Zusätzliche Tabellen und Spalten
 -- @depends:  project_customer_type_valid
--- @charset: utf-8
 
 -- changes over bob:
 -- no scon/support_contract values here
@@ -23,7 +22,7 @@ CREATE TABLE project_status (
   name        TEXT      NOT NULL,
   description TEXT      NOT NULL,
   position    INTEGER   NOT NULL,
-  itime       TIMESTAMP DEFAULT 'now()',
+  itime       TIMESTAMP DEFAULT now(),
   mtime       TIMESTAMP
 );
 
@@ -49,7 +48,7 @@ CREATE TABLE project_phases (
   budget_cost     NUMERIC (15,5)       NOT NULL DEFAULT 0,
   general_minutes INTEGER              NOT NULL DEFAULT 0,
   general_cost_per_hour NUMERIC (15,5) NOT NULL DEFAULT 0,
-  itime           TIMESTAMP DEFAULT 'now()',
+  itime           TIMESTAMP DEFAULT now(),
   mtime           TIMESTAMP
 );
 
@@ -58,7 +57,7 @@ CREATE TABLE project_roles (
   name         TEXT    NOT NULL,
   description  TEXT    NOT NULL,
   position     INTEGER NOT NULL,
-  itime        TIMESTAMP DEFAULT 'now()',
+  itime        TIMESTAMP DEFAULT now(),
   mtime        TIMESTAMP
 );
 
@@ -69,7 +68,7 @@ CREATE TABLE project_participants (
   project_role_id INTEGER NOT NULL REFERENCES project_roles(id),
   minutes         INTEGER NOT NULL DEFAULT 0,
   cost_per_hour   NUMERIC (15,5),
-  itime           TIMESTAMP DEFAULT 'now()',
+  itime           TIMESTAMP DEFAULT now(),
   mtime           TIMESTAMP
 );
 
@@ -80,7 +79,7 @@ CREATE TABLE project_phase_participants (
   project_role_id  INTEGER NOT NULL REFERENCES project_roles(id),
   minutes          INTEGER NOT NULL DEFAULT 0,
   cost_per_hour    NUMERIC (15,5),
-  itime            TIMESTAMP DEFAULT 'now()',
+  itime            TIMESTAMP DEFAULT now(),
   mtime            TIMESTAMP
 );
 
@@ -89,4 +88,3 @@ CREATE TRIGGER mtime_project_phases            BEFORE UPDATE ON project_phases
 CREATE TRIGGER mtime_project_roles             BEFORE UPDATE ON project_roles              FOR EACH ROW EXECUTE PROCEDURE set_mtime();
 CREATE TRIGGER mtime_project_participants      BEFORE UPDATE ON project_participants       FOR EACH ROW EXECUTE PROCEDURE set_mtime();
 CREATE TRIGGER mtime_project_phase_paticipants BEFORE UPDATE ON project_phase_participants FOR EACH ROW EXECUTE PROCEDURE set_mtime();
-