X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=FS%2FFS%2FSchema.pm;h=04e5dd4c89d51fd00e62de225c18436dbbedf3f8;hb=edea94b6bd41a3fceac47267a3df3dc7fcf7c565;hp=c635ea0a00e8e3843773539df60f709fa42e0635;hpb=05056204cf2fb1b216480bf242e9fdc00a3148f6;p=freeside.git

diff --git a/FS/FS/Schema.pm b/FS/FS/Schema.pm
index c635ea0a0..04e5dd4c8 100644
--- a/FS/FS/Schema.pm
+++ b/FS/FS/Schema.pm
@@ -254,11 +254,11 @@ sub dbdef_dist {
  	# necessary because of the evil OR username for older data, be really nice if everything was just migrated to usernum and we could drop username
 	# This will not be helpful to mysql, but postgres smartly does a bitmap across both indexes, mysql will just use one
 
-      $h_indices{"h_${table}_username"} =
+      $h_indices{"h_${table}_user"} =
          DBIx::DBSchema::Index->new({
-           'name'    => "h_${table}_username",
+           'name'    => "h_${table}_user",
            'unique'  => 0,
-           'columns' => [ 'history_username'],
+           'columns' => [ 'history_user'],
          });
     }
 
@@ -1811,10 +1811,11 @@ sub tables_hashref {
         'add_date',   @date_type,                  '', '', 
         'disabled',       'char', 'NULL',       1, '', '', 
         'custnum',         'int', 'NULL',      '', '', '',
+        'refnum',          'int', 'NULL',      '', '', '', 
       ],
       'primary_key'  => 'prospectnum',
       'unique'       => [],
-      'index'        => [ [ 'company' ], [ 'agentnum' ], [ 'disabled' ] ],
+      'index'        => [ ['company'], ['agentnum'], ['disabled'], ['refnum'] ],
       'foreign_keys' => [
                           { columns    => [ 'agentnum' ],
                             table      => 'agent',
@@ -1822,6 +1823,9 @@ sub tables_hashref {
                           { columns    => [ 'custnum' ],
                             table      => 'cust_main',
                           },
+                          { columns    => [ 'refnum' ],
+                            table      => 'part_referral',
+                          },
                         ],
     },
 
@@ -3048,6 +3052,7 @@ sub tables_hashref {
         'successor',     'int',     'NULL', '', '', '',
         'family_pkgpart','int',     'NULL', '', '', '',
         'delay_start',   'int',     'NULL', '', '', '',
+        'start_on_hold', 'char',    'NULL',  1, '', '',
         'agent_pkgpartid', 'varchar', 'NULL', 20, '', '',
       ],
       'primary_key'  => 'pkgpart',