diff options
| author | ivan <ivan> | 2008-11-19 01:24:24 +0000 |
|---|---|---|
| committer | ivan <ivan> | 2008-11-19 01:24:24 +0000 |
| commit | 7c9c69a6e85094310f437d01877b79b3d5c845db (patch) | |
| tree | b3bdbfa58bf21da9e2b4820a153929e99f68ac5a | |
| parent | 7bbecbdec002454c66afbc56003c0456c33f81be (diff) | |
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
| -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, '', '', |