From 97a6f6d623a9810e1d324f44a5f8bcd12294f5d3 Mon Sep 17 00:00:00 2001 From: =?utf8?q?Jan=20B=C3=BCren?= Date: Thu, 31 Mar 2022 11:45:54 +0200 Subject: [PATCH] =?utf8?q?Sprache=20um=20Attribut=20ung=C3=BCltig=20erweit?= =?utf8?q?ert?= MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit --- SL/DB/MetaSetup/Language.pm | 1 + sql/Pg-upgrade2/language_obsolete.sql | 6 ++++++ 2 files changed, 7 insertions(+) create mode 100644 sql/Pg-upgrade2/language_obsolete.sql diff --git a/SL/DB/MetaSetup/Language.pm b/SL/DB/MetaSetup/Language.pm index 9aa80396a..96d0a0a30 100644 --- a/SL/DB/MetaSetup/Language.pm +++ b/SL/DB/MetaSetup/Language.pm @@ -14,6 +14,7 @@ __PACKAGE__->meta->columns( id => { type => 'integer', not_null => 1, sequence => 'id' }, itime => { type => 'timestamp', default => 'now()' }, mtime => { type => 'timestamp' }, + obsolete => { type => 'boolean', default => 'false' }, output_dateformat => { type => 'text' }, output_longdates => { type => 'boolean' }, output_numberformat => { type => 'text' }, diff --git a/sql/Pg-upgrade2/language_obsolete.sql b/sql/Pg-upgrade2/language_obsolete.sql new file mode 100644 index 000000000..53d28b515 --- /dev/null +++ b/sql/Pg-upgrade2/language_obsolete.sql @@ -0,0 +1,6 @@ +-- @tag: language_obsolete +-- @description: Sprachen ungültig setzen +-- @depends: release_3_6_0 +-- @ignore: 0 + +ALTER TABLE language ADD COLUMN obsolete BOOLEAN DEFAULT FALSE; -- 2.20.1