rt# 74031 work in progress

[freeside.git] / FS / FS / Schema.pm

diff --git a/FS/FS/Schema.pm b/FS/FS/Schema.pm
index 6d88204..b94407b 100644 (file)
--- a/FS/FS/Schema.pm
+++ b/FS/FS/Schema.pm
@@ -7658,14 +7658,14 @@ sub tables_hashref {
 
     'realestate_subproperty' => {
       'columns' => [
-        'spropnum', 'serial',  '', '',      '',  '',
-        'propnum',  'int',     '', '',      '',  '',
-        'subtitle', 'varchar', '', $char_d, '',  '',
-        'disabled', 'char',    '', 1,       '0', '',
+        'subpropnum', 'serial',  '', '',      '',  '',
+        'propnum',    'int',     '', '',      '',  '',
+        'subtitle',   'varchar', '', $char_d, '',  '',
+        'disabled',   'char',    '', 1,       '0', '',
       ],
-      'primary_key'  => 'spropnum',
+      'primary_key'  => 'subpropnum',
       'unique'       => [],
-      'index'        => [ ['propnum'] ],
+      'index'        => [ ['propnum'],['subtitle'] ],
       'foreign_keys' => [
         {columns => ['propnum'], table => 'realestate_property'}
       ],