X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=FS%2FFS%2FSchema.pm;h=e38ebff5460e6b0f3af195e85d0eaf139616b884;hb=9fcc988cd0532f0ea6d84f348caed24b8c797c78;hp=b261c5064323c98dd8e0908102f2fc2ba7690512;hpb=650682d61cb09233b106c83d50259e8bd7acee20;p=freeside.git

diff --git a/FS/FS/Schema.pm b/FS/FS/Schema.pm
index b261c5064..e38ebff54 100644
--- a/FS/FS/Schema.pm
+++ b/FS/FS/Schema.pm
@@ -7338,6 +7338,29 @@ sub tables_hashref {
                         ],
     },
 
+    'webservice_log' => {
+      'columns' => [
+        'webservicelognum',    'serial',      '',      '', '', '', #big? hubrus
+        'svcnum',                 'int',  'NULL',      '', '', '', #just in case
+        'custnum',                'int',      '',      '', '', '',
+        'method',             'varchar',      '', $char_d, '', '',
+        'quantity',               'int',      '',      '', '', '', #i.e. pages
+        '_date',             @date_type,                   '', '',
+        'status',             'varchar',  'NULL', $char_d, '', '', 
+        'rated_price',        'decimal',  'NULL',  '10,2', '', '',
+      ],
+      'primary_key'  => 'webservicelognum',
+      'unique'       => [],
+      'index'        => [ ['custnum'], ['status'] ],
+      'foreign_keys' => [
+                          { columns => [ 'custnum' ],
+                            table   => 'cust_main',
+                          },
+                          #no FK on svcnum... we don't want to purge these on
+                          # service deletion
+                        ],
+    },
+
     # name type nullability length default local
 
     #'new_table' => {