# HG changeset patch # User Sascha L. Teichmann # Date 1543072948 -3600 # Node ID 50dd4ff7907eb3c5c35215c58798b3ab192fcafe # Parent 5443f5c9154cc4b9ab2ef22ccdc54fd14da13c31 Added missing copyright headers and authors in schema related files. diff -r 5443f5c9154c -r 50dd4ff7907e schema/auth.sql --- a/schema/auth.sql Sat Nov 24 10:32:06 2018 +0100 +++ b/schema/auth.sql Sat Nov 24 16:22:28 2018 +0100 @@ -10,6 +10,8 @@ -- Author(s): -- * Tom Gottried +-- * Sascha Wilde +-- * Sascha L. Teichmann BEGIN; diff -r 5443f5c9154c -r 50dd4ff7907e schema/demo-data/published_services.sql --- a/schema/demo-data/published_services.sql Sat Nov 24 10:32:06 2018 +0100 +++ b/schema/demo-data/published_services.sql Sat Nov 24 16:22:28 2018 +0100 @@ -1,3 +1,16 @@ +-- This is Free Software under GNU Affero General Public License v >= 3.0 +-- without warranty, see README.md and license for details. + +-- SPDX-License-Identifier: AGPL-3.0-or-later +-- License-Filename: LICENSES/AGPL-3.0.txt + +-- Copyright (C) 2018 by via donau +-- – Österreichische Wasserstraßen-Gesellschaft mbH +-- Software engineering by Intevation GmbH + +-- Author(s): +-- * Tom Gottfried + INSERT INTO sys_admin.published_services (name) VALUES ('waterway.fairway_dimensions'), ('waterway.distance_marks_geoserver'), diff -r 5443f5c9154c -r 50dd4ff7907e schema/demo-data/responsibility_areas.sql --- a/schema/demo-data/responsibility_areas.sql Sat Nov 24 10:32:06 2018 +0100 +++ b/schema/demo-data/responsibility_areas.sql Sat Nov 24 16:22:28 2018 +0100 @@ -1,3 +1,18 @@ +-- This is Free Software under GNU Affero General Public License v >= 3.0 +-- without warranty, see README.md and license for details. + +-- SPDX-License-Identifier: AGPL-3.0-or-later +-- License-Filename: LICENSES/AGPL-3.0.txt + +-- Copyright (C) 2018 by via donau +-- – Österreichische Wasserstraßen-Gesellschaft mbH +-- Software engineering by Intevation GmbH + +-- Author(s): +-- * Sascha Wilde +-- * Tom Gottfried + + -- Setup Country Codes COPY countries (country_code) FROM stdin; RO diff -r 5443f5c9154c -r 50dd4ff7907e schema/demo-data/roles.sql --- a/schema/demo-data/roles.sql Sat Nov 24 10:32:06 2018 +0100 +++ b/schema/demo-data/roles.sql Sat Nov 24 16:22:28 2018 +0100 @@ -1,3 +1,17 @@ +-- This is Free Software under GNU Affero General Public License v >= 3.0 +-- without warranty, see README.md and license for details. + +-- SPDX-License-Identifier: AGPL-3.0-or-later +-- License-Filename: LICENSES/AGPL-3.0.txt + +-- Copyright (C) 2018 by via donau +-- – Österreichische Wasserstraßen-Gesellschaft mbH +-- Software engineering by Intevation GmbH + +-- Author(s): +-- * Christine Tschuprine +-- * Tom Gottfried + -- System Administrator CREATE ROLE sophie IN ROLE sys_admin ROLE metamorph LOGIN PASSWORD 'so2Phie4'; diff -r 5443f5c9154c -r 50dd4ff7907e schema/demo-data/users.sql --- a/schema/demo-data/users.sql Sat Nov 24 10:32:06 2018 +0100 +++ b/schema/demo-data/users.sql Sat Nov 24 16:22:28 2018 +0100 @@ -1,3 +1,19 @@ +-- This is Free Software under GNU Affero General Public License v >= 3.0 +-- without warranty, see README.md and license for details. + +-- SPDX-License-Identifier: AGPL-3.0-or-later +-- License-Filename: LICENSES/AGPL-3.0.txt + +-- Copyright (C) 2018 by via donau +-- – Österreichische Wasserstraßen-Gesellschaft mbH +-- Software engineering by Intevation GmbH + +-- Author(s): +-- * Sascha Wilde +-- * Christine Tschuprine +-- * Thomas Junk +-- * Tom Gottfried + BEGIN; -- PREREQUISITES: diff -r 5443f5c9154c -r 50dd4ff7907e schema/gemma.sql --- a/schema/gemma.sql Sat Nov 24 10:32:06 2018 +0100 +++ b/schema/gemma.sql Sat Nov 24 16:22:28 2018 +0100 @@ -10,6 +10,9 @@ -- Author(s): -- * Tom Gottfried +-- * Sascha Wilde +-- * Sascha L. Teichmann +-- * Bernhard E. Reiter BEGIN; diff -r 5443f5c9154c -r 50dd4ff7907e schema/install-db.sh --- a/schema/install-db.sh Sat Nov 24 10:32:06 2018 +0100 +++ b/schema/install-db.sh Sat Nov 24 16:22:28 2018 +0100 @@ -11,6 +11,8 @@ # # Author(s): # * Sascha Wilde +# * Tom Gottfried +# * Sascha L. Teichmann ME=`basename "$0"` BASEDIR=`dirname "$0"` diff -r 5443f5c9154c -r 50dd4ff7907e schema/manage_users.sql --- a/schema/manage_users.sql Sat Nov 24 10:32:06 2018 +0100 +++ b/schema/manage_users.sql Sat Nov 24 16:22:28 2018 +0100 @@ -10,6 +10,7 @@ -- Author(s): -- * Tom Gottfried +-- * Sascha L. Teichmann -- -- Functions encapsulating user management functionality and diff -r 5443f5c9154c -r 50dd4ff7907e schema/std_login_roles.sql --- a/schema/std_login_roles.sql Sat Nov 24 10:32:06 2018 +0100 +++ b/schema/std_login_roles.sql Sat Nov 24 16:22:28 2018 +0100 @@ -10,6 +10,7 @@ -- Author(s): -- * Sascha Wilde +-- * Tom Gottfried BEGIN;