projects
/
freeside.git
/ commitdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
| commitdiff |
tree
raw
|
patch
|
inline
| side by side (parent:
7bbecbd
)
fix phone_avail.availnum to be a proper primary key, fix agent.agent_custnum unique...
author
ivan
<ivan>
Wed, 19 Nov 2008 01:24:24 +0000
(
01:24
+0000)
committer
ivan
<ivan>
Wed, 19 Nov 2008 01:24:24 +0000
(
01:24
+0000)
FS/FS/Schema.pm
patch
|
blob
|
history
diff --git
a/FS/FS/Schema.pm
b/FS/FS/Schema.pm
index
941eafc
..
8961f33
100644
(file)
--- 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',
'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' => {
},
'agent_type' => {
@@
-2116,7
+2119,7
@@
sub tables_hashref {
'phone_avail' => {
'columns' => [
'phone_avail' => {
'columns' => [
- 'availnum', '
int',
'', '', '', '',
+ 'availnum', '
serial',
'', '', '', '',
'exportnum', 'int', '', '', '', '',
'countrycode', 'varchar', '', 3, '', '',
'state', 'char', 'NULL', 2, '', '',
'exportnum', 'int', '', '', '', '',
'countrycode', 'varchar', '', 3, '', '',
'state', 'char', 'NULL', 2, '', '',