X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=FS%2FFS%2FSchema.pm;h=0b54282ef3b52464eec3398e4da3e6dc2772f8c5;hb=7b125e587a4d1ee0aca692e23ea7897f671855ae;hp=f113146ca5012e7df965740dbd03d4d820246a5c;hpb=de3bf373e97f6875e09fc17d99068a2716bf3b2d;p=freeside.git

diff --git a/FS/FS/Schema.pm b/FS/FS/Schema.pm
index f113146ca..0b54282ef 100644
--- a/FS/FS/Schema.pm
+++ b/FS/FS/Schema.pm
@@ -1803,7 +1803,7 @@ sub tables_hashref {
     'cgp_rule_condition' => {
       'columns' => [
         'ruleconditionnum',  'serial',     '',      '', '', '',
-        'conditionname',    'varchar',     '', $char_d, '', '',
+        'condition',        'varchar',     '', $char_d, '', '',
         'op',               'varchar', 'NULL', $char_d, '', '',
         'params',           'varchar', 'NULL',     255, '', '',
         'rulenum',              'int',     '',      '', '', '',
@@ -2229,7 +2229,6 @@ sub tables_hashref {
         'conn_sec',        'int',     '',     '', '0', '',
         'min_charge',      'decimal', '', '10,5', '', '', #@money_type, '', '', 
         'sec_granularity', 'int',     '',     '', '', '', 
-        'ratetimenum',     'int', 'NULL',     '', '', '',
         #time period (link to table of periods)?
         'classnum',        'int', 'NULL',     '', '', '', 
       ],
@@ -2261,28 +2260,6 @@ sub tables_hashref {
       'index'       => [ [ 'countrycode' ], [ 'npa' ], [ 'regionnum' ] ],
     },
 
-    'rate_time' => {
-      'columns' => [
-        'ratetimenum', 'serial',      '',      '', '', '',
-        'ratetimename',   'varchar',      '', $char_d, '', '',
-      ],
-      'primary_key' => 'ratetimenum',
-      'unique'      => [],
-      'index'       => [],
-    },
-
-    'rate_time_interval' => {
-      'columns' => [
-        'intervalnum', 'serial', '', '', '', '',
-        'stime',          'int', '', '', '', '',
-        'etime',          'int', '', '', '', '',
-        'ratetimenum',    'int', '', '', '', '',
-      ],
-      'primary_key' => 'intervalnum',
-      'unique'      => [],
-      'index'       => [],
-    },
-
     'usage_class' => {
       'columns' => [
         'classnum',    'serial',      '',      '', '', '', 
@@ -2822,11 +2799,10 @@ sub tables_hashref {
 
     'svc_pbx' => {
       'columns' => [
-        'svcnum',           'int',     '',      '', '', '', 
-        'id',               'int', 'NULL',      '', '', '', 
-        'title',        'varchar', 'NULL', $char_d, '', '', 
-        'max_extensions',   'int', 'NULL',      '', '', '',
-        'max_simultaneous', 'int', 'NULL',      '', '', '',
+        'svcnum',         'int',     '',      '', '', '', 
+        'id',             'int', 'NULL',      '', '', '', 
+        'title',      'varchar', 'NULL', $char_d, '', '', 
+        'max_extensions', 'int', 'NULL',      '', '', '',
       ],
       'primary_key' => 'svcnum',
       'unique' => [],
@@ -2872,41 +2848,6 @@ sub tables_hashref {
       'index'       => [['listnum'],['svcnum'],['contactemailnum'],['email']],
     },
 
-    'bill_batch' => {
-      'columns' => [
-        'batchnum',         'serial',     '', '', '', '',
-        'status',             'char', 'NULL','1', '', '',
-        'pdf',                'blob', 'NULL', '', '', '',
-      ],
-      'primary_key' => 'batchnum',
-      'unique'      => [],
-      'index'       => [],
-    },
-
-    'cust_bill_batch' => {
-      'columns' => [
-        'billbatchnum',     'serial',     '', '', '', '',
-        'batchnum',            'int',     '', '', '', '',
-        'invnum',              'int',     '', '', '', '',
-      ],
-      'primary_key' => 'billbatchnum',
-      'unique'      => [],
-      'index'       => [ [ 'batchnum' ], [ 'invnum' ] ],
-    },
-
-    'cust_bill_batch_option' => {
-      'columns' => [
-        'optionnum', 'serial', '', '', '', '', 
-        'billbatchnum', 'int', '', '', '', '', 
-        'optionname', 'varchar', '', $char_d, '', '', 
-        'optionvalue', 'text', 'NULL', '', '', '', 
-      ],
-      'primary_key' => 'optionnum',
-      'unique'      => [],
-      'index'       => [ [ 'billbatchnum' ], [ 'optionname' ] ],
-    },
-
-
 
     # name type nullability length default local