X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=FS%2FFS%2FSchema.pm;h=2871c216b97d4a9e5d95d7ca448b00594974d5d7;hb=96d6a93b8cbc7fbe2eb7a0877c4108111c96d3e3;hp=5b4ba07b22fca12a1fffe943e5460fca9f32c256;hpb=01bdc344d07af3be10b7486d177c0a515da68b66;p=freeside.git

diff --git a/FS/FS/Schema.pm b/FS/FS/Schema.pm
index 5b4ba07b2..2871c216b 100644
--- a/FS/FS/Schema.pm
+++ b/FS/FS/Schema.pm
@@ -3996,6 +3996,25 @@ sub tables_hashref {
       'index'  => [ [ 'id' ] ],
     },
 
+    'pbx_extension' => {
+      'columns' => [
+        'extensionnum',  'serial',     '',      '', '', '',
+        'svcnum',           'int',     '',      '', '', '',
+        'extension',    'varchar',     '', $char_d, '', '',
+        'pin',          'varchar', 'NULL', $char_d, '', '',
+        'sip_password', 'varchar', 'NULL', $char_d, '', '',
+        'phone_name',   'varchar', 'NULL', $char_d, '', '',
+      ],
+      'primary_key'  => 'extensionnum',
+      'unique'       => [ [ 'svcnum', 'extension' ] ],
+      'index'        => [ [ 'svcnum' ] ],
+      'foreign_keys' => [
+                          { columns    => [ 'svcnum' ],
+                            table      => 'svc_pbx',
+                          },
+                        ],
+    },
+
     'svc_mailinglist' => { #svc_group?
       'columns' => [
         'svcnum',            'int',     '',            '', '', '',