epic-s6ts

[kivitendo-erp.git] / 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 cf7a2f3..ef2224c 100644 (file)
--- a/sql/Pg-upgrade2/project_bob_attributes.sql
+++ b/sql/Pg-upgrade2/project_bob_attributes.sql
@@ -5,12 +5,11 @@
 -- changes over bob:
 -- no scon/support_contract values here
 -- no include or expclude flags for workload
--- statuses renamed to status (we dont use rails weird plurals)
 -- created_at/updated_at renamed to itime/mtime,
 -- varchars retyped to text
 -- hours (numeric) changed to minutes (integer) since the code already calculates in minutes
 --  note: flags changing the behaviour of hours are still called so and not minutes
--- no refcounts. we use adhoc counts to decide wether delete is possible or not
+-- no refcounts. we use adhoc counts to decide whether delete is possible or not
 -- no hour_approval
 -- nothing relevant to notifications
 
@@ -22,7 +21,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
 );
 
@@ -48,7 +47,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
 );
 
@@ -57,7 +56,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
 );
 
@@ -68,7 +67,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
 );
 
@@ -79,7 +78,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
 );