rt# 74031 implementing svc_realestate

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

diff --git a/FS/FS/Schema.pm b/FS/FS/Schema.pm
index e1301b6..f2817f5 100644 (file)
--- a/FS/FS/Schema.pm
+++ b/FS/FS/Schema.pm
@@ -7652,7 +7652,7 @@ sub tables_hashref {
         ['custnum'],
         ['realestatelocnum'],
         ['disabled'],
-        ['title']
+        ['unit_title']
       ],
       'foreign_keys' => [
         {columns => ['agentnum'], table => 'agent'},
@@ -7681,6 +7681,16 @@ sub tables_hashref {
       ],
     },
 
+    svc_realestate => {
+      columns => [
+        'svcnum',      'serial', '',      '',      '', '',
+        'description', 'varchar', 'NULL', $char_d, '', '',
+        'property',    'varchar', 'NULL', $char_d, '', '',
+      ],
+      primary_key => 'svcnum',
+      index => [],
+    },
+
     # name type nullability length default local
 
     #'new_table' => {