Lieferdatum in Dialogbuchung: DB-Upgrade + Rose

diff --git a/SL/DB/MetaSetup/GLTransaction.pm b/SL/DB/MetaSetup/GLTransaction.pm
index 3b829d5..f592513 100644 (file)
--- a/SL/DB/MetaSetup/GLTransaction.pm
+++ b/SL/DB/MetaSetup/GLTransaction.pm
@@ -10,6 +10,7 @@ __PACKAGE__->meta->table('gl');
 
 __PACKAGE__->meta->columns(
   cb_transaction => { type => 'boolean' },
+  deliverydate   => { type => 'date' },
   department_id  => { type => 'integer' },
   description    => { type => 'text' },
   employee_id    => { type => 'integer' },

diff --git a/sql/Pg-upgrade2/gl_add_deliverydate.sql b/sql/Pg-upgrade2/gl_add_deliverydate.sql
new file mode 100644 (file)
index 0000000..2e5500e
--- /dev/null
+++ b/sql/Pg-upgrade2/gl_add_deliverydate.sql
@@ -0,0 +1,5 @@
+-- @tag: gl_add_deliverydate
+-- @description: Liefer-/Leistungsdatum in Dialogbuchungen
+-- @depends: release_3_5_5
+
+ALTER TABLE gl ADD COLUMN deliverydate DATE;