From 754ef842e3bd40305cacb6e50420acfc3a2b381e Mon Sep 17 00:00:00 2001 From: =?utf8?q?Bernd=20Ble=C3=9Fmann?= Date: Fri, 3 Dec 2021 17:34:55 +0100 Subject: [PATCH] =?utf8?q?Files:=20Druckvariante=20abspeichern=20k=C3=B6nn?= =?utf8?q?en:=20sql=20und=20rose?= MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit --- SL/DB/MetaSetup/File.pm | 27 ++++++++++++++------------- sql/Pg-upgrade2/files_add_variant.sql | 5 +++++ 2 files changed, 19 insertions(+), 13 deletions(-) create mode 100644 sql/Pg-upgrade2/files_add_variant.sql diff --git a/SL/DB/MetaSetup/File.pm b/SL/DB/MetaSetup/File.pm index 257e09faf..e5fd62246 100644 --- a/SL/DB/MetaSetup/File.pm +++ b/SL/DB/MetaSetup/File.pm @@ -9,19 +9,20 @@ use parent qw(SL::DB::Object); __PACKAGE__->meta->table('files'); __PACKAGE__->meta->columns( - backend => { type => 'text' }, - backend_data => { type => 'text' }, - description => { type => 'text' }, - file_name => { type => 'text', not_null => 1 }, - file_type => { type => 'text', not_null => 1 }, - id => { type => 'serial', not_null => 1 }, - itime => { type => 'timestamp', default => 'now()' }, - mime_type => { type => 'text', not_null => 1 }, - mtime => { type => 'timestamp' }, - object_id => { type => 'integer', not_null => 1 }, - object_type => { type => 'text', not_null => 1 }, - source => { type => 'text', not_null => 1 }, - title => { type => 'varchar', length => 45 }, + backend => { type => 'text' }, + backend_data => { type => 'text' }, + description => { type => 'text' }, + file_name => { type => 'text', not_null => 1 }, + file_type => { type => 'text', not_null => 1 }, + id => { type => 'serial', not_null => 1 }, + itime => { type => 'timestamp', default => 'now()' }, + mime_type => { type => 'text', not_null => 1 }, + mtime => { type => 'timestamp' }, + object_id => { type => 'integer', not_null => 1 }, + object_type => { type => 'text', not_null => 1 }, + print_variant => { type => 'text' }, + source => { type => 'text', not_null => 1 }, + title => { type => 'varchar', length => 45 }, ); __PACKAGE__->meta->primary_key_columns([ 'id' ]); diff --git a/sql/Pg-upgrade2/files_add_variant.sql b/sql/Pg-upgrade2/files_add_variant.sql new file mode 100644 index 000000000..a697e8a0d --- /dev/null +++ b/sql/Pg-upgrade2/files_add_variant.sql @@ -0,0 +1,5 @@ +-- @tag: files_add_variant +-- @description: Varianten für DMS System +-- @depends: release_3_5_8 + +ALTER TABLE files ADD COLUMN print_variant text; -- 2.20.1