Unterstützung für andere Datenbankencodings als Unicode/UTF-8 entfernt – Teil 2

diff --git a/sql/Pg-upgrade2/project_bob_attributes.sql b/sql/Pg-upgrade2/project_bob_attributes.sql
index 07bcec0d1513a2a35c96759e921bafaab783d4a6..cf7a2f357788003e2b6daa1890fbe18d901e6678 100644 (file)
--- 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
 -- @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
 
 -- changes over bob:
 -- no scon/support_contract values here


@@ -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();
 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();

-

diff --git a/sql/Pg-upgrade2/project_types.sql b/sql/Pg-upgrade2/project_types.sql
index 7d2c319ada3ca04da52f3e0029ac3c72b2e6c438..a0ba07df0af29eb21b2867fc23eb42fcec7ac4be 100644 (file)
--- a/sql/Pg-upgrade2/project_types.sql
+++ b/sql/Pg-upgrade2/project_types.sql
@@ -1,7 +1,6 @@
 -- @tag: project_types
 -- @description: Tabelle für Projekttypen
 -- @depends: release_3_0_0
 -- @tag: project_types
 -- @description: Tabelle für Projekttypen
 -- @depends: release_3_0_0

--- @charset: utf-8

 CREATE TABLE project_types (
        id                       SERIAL,
        position                 INTEGER NOT NULL,
 CREATE TABLE project_types (
        id                       SERIAL,
        position                 INTEGER NOT NULL,

diff --git a/sql/Pg-upgrade2/requirement_specs.sql b/sql/Pg-upgrade2/requirement_specs.sql
index 2589e4ec5cf554d39575ccab047299cce8a2f05e..7647c2e91e510ee1cad412e4aa6f3b9543bf3778 100644 (file)
--- a/sql/Pg-upgrade2/requirement_specs.sql
+++ b/sql/Pg-upgrade2/requirement_specs.sql
@@ -1,7 +1,6 @@
 -- @tag: requirement_specs
 -- @description: Pflichtenhefte
 -- @depends: release_3_0_0
 -- @tag: requirement_specs
 -- @description: Pflichtenhefte
 -- @depends: release_3_0_0

--- @charset: utf-8

 
 -- Nur für Entwicklungszwecke:
 
 
 -- Nur für Entwicklungszwecke:
 

diff --git a/sql/Pg-upgrade2/requirement_specs_section_templates.sql b/sql/Pg-upgrade2/requirement_specs_section_templates.sql
index a3bc1e62b2d99027cccb7275890671ccab3e4acd..4b37434170513a8073b67bb091be81071967485b 100644 (file)
--- a/sql/Pg-upgrade2/requirement_specs_section_templates.sql
+++ b/sql/Pg-upgrade2/requirement_specs_section_templates.sql
@@ -1,7 +1,6 @@
 -- @tag: requirement_specs_section_templates
 -- @description: requirement_specs_section_templates
 -- @depends: release_3_0_0 requirement_specs
 -- @tag: requirement_specs_section_templates
 -- @description: requirement_specs_section_templates
 -- @depends: release_3_0_0 requirement_specs

--- @charset: utf-8

 
 ALTER TABLE requirement_specs ALTER COLUMN type_id     DROP NOT NULL;
 ALTER TABLE requirement_specs ALTER COLUMN status_id   DROP NOT NULL;
 
 ALTER TABLE requirement_specs ALTER COLUMN type_id     DROP NOT NULL;
 ALTER TABLE requirement_specs ALTER COLUMN status_id   DROP NOT NULL;