Sprache um Attribut ungültig erweitert

diff --git a/SL/DB/MetaSetup/Language.pm b/SL/DB/MetaSetup/Language.pm
index 9aa80396a1a5203ee29f72a1ab2d268f806006cf..96d0a0a306df760511129e68d9fb2d4ba29b2297 100644 (file)
--- 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 (file)
index 0000000..53d28b5
--- /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;