diff options
-rw-r--r-- | FS/FS/Schema.pm | 9 |
1 files changed, 6 insertions, 3 deletions
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, '', '', |