Revert "Briefe: Rechteprüfung gefixed"

[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 07bcec0..ef2224c 100644 (file)
--- a/sql/Pg-upgrade2/project_bob_attributes.sql
+++ b/sql/Pg-upgrade2/project_bob_attributes.sql
@@ -1,17 +1,15 @@
 -- @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
 -- 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
 
@@ -23,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
 );
 
@@ -49,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
 );
 
@@ -58,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
 );
 
@@ -69,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
 );
 
@@ -80,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
 );
 
@@ -89,4 +87,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();
-