Neues DB-Setup für Währungen

[kivitendo-erp.git] / SL / DB / MetaSetup / Project.pm

diff --git a/SL/DB/MetaSetup/Project.pm b/SL/DB/MetaSetup/Project.pm
index 6b3ab91..a492b46 100644 (file)
--- a/SL/DB/MetaSetup/Project.pm
+++ b/SL/DB/MetaSetup/Project.pm
@@ -16,6 +16,9 @@ __PACKAGE__->meta->setup(
     itime         => { type => 'timestamp', default => 'now()' },
     mtime         => { type => 'timestamp' },
     active        => { type => 'boolean', default => 'true' },
+    customer_id   => { type => 'integer' },
+    type          => { type => 'text' },
+    valid         => { type => 'boolean', default => 'true' },
   ],
 
   primary_key_columns => [ 'id' ],
@@ -23,6 +26,13 @@ __PACKAGE__->meta->setup(
   unique_key => [ 'projectnumber' ],
 
   allow_inline_column_values => 1,
+
+  foreign_keys => [
+    customer => {
+      class       => 'SL::DB::Customer',
+      key_columns => { customer_id => 'id' },
+    },
+  ],
 );
 
 1;