From: ivan <ivan>
Date: Wed, 19 Nov 2008 01:24:24 +0000 (+0000)
Subject: fix phone_avail.availnum to be a proper primary key, fix agent.agent_custnum unique... 
X-Git-Tag: root_of_webpay_support~252
X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=commitdiff_plain;h=7c9c69a6e85094310f437d01877b79b3d5c845db

fix phone_avail.availnum to be a proper primary key, fix agent.agent_custnum unique index causing it to get a value filled in by Record.pm
---

diff --git a/FS/FS/Schema.pm b/FS/FS/Schema.pm
index 941eafc7f..8961f33ec 100644
--- a/FS/FS/Schema.pm
+++ b/FS/FS/Schema.pm
@@ -342,8 +342,11 @@ sub tables_hashref {
         'prog',                     @perl_type, '', '', #deprecated (never used)
       ],
       'primary_key' => 'agentnum',
-      'unique' => [ [ 'agent_custnum' ] ], #one agent per customer?
-      'index' => [ ['typenum'], ['disabled'] ],
+      #'unique' => [ [ 'agent_custnum' ] ], #one agent per customer?
+                                            #insert is giving it a value, tho..
+      #'index' => [ ['typenum'], ['disabled'] ],
+      'unique' => [],
+      'index' => [ ['typenum'], ['disabled'], ['agent_custnum'] ],
     },
 
     'agent_type' => {
@@ -2116,7 +2119,7 @@ sub tables_hashref {
 
     'phone_avail' => {
       'columns' => [
-        'availnum',    'int',      '', '', '', '', 
+        'availnum',    'serial',   '', '', '', '', 
         'exportnum',   'int',      '', '', '', '', 
         'countrycode', 'varchar',  '',  3, '', '', 
         'state',       'char', 'NULL',  2, '', '',