diff options
| -rwxr-xr-x | FS/bin/freeside-setup | 9 | ||||
| -rw-r--r-- | httemplate/docs/upgrade10.html | 5 |
2 files changed, 10 insertions, 4 deletions
diff --git a/FS/bin/freeside-setup b/FS/bin/freeside-setup index 80b74c1f1..4e3a09aad 100755 --- a/FS/bin/freeside-setup +++ b/FS/bin/freeside-setup @@ -342,7 +342,7 @@ sub tables_hash_hack { ], 'primary_key' => 'agentnum', 'unique' => [], - 'index' => [ ['typenum'] ], + 'index' => [ ['typenum'], ['diabled'] ], }, 'agent_type' => { @@ -408,7 +408,7 @@ sub tables_hash_hack { ], 'primary_key' => 'eventpart', 'unique' => [], - 'index' => [ ['payby'] ], + 'index' => [ ['payby'], ['disabled'], ], }, 'cust_bill_pkg' => { @@ -567,7 +567,7 @@ sub tables_hash_hack { ], 'primary_key' => 'paynum', 'unique' => [], - 'index' => [ [ 'custnum' ], [ 'paybatch' ] ], + 'index' => [ [ 'custnum' ], [ 'paybatch' ], [ 'payby' ], [ '_date' ] ], }, 'cust_bill_pay' => { @@ -718,10 +718,11 @@ sub tables_hash_hack { 'columns' => [ 'refnum', 'serial', '', '', 'referral', 'varchar', '', $char_d, + 'disabled', 'char', 'NULL', 1, ], 'primary_key' => 'refnum', 'unique' => [], - 'index' => [], + 'index' => [ ['disabled'] ], }, 'part_svc' => { diff --git a/httemplate/docs/upgrade10.html b/httemplate/docs/upgrade10.html index 080528bac..3c6519a61 100644 --- a/httemplate/docs/upgrade10.html +++ b/httemplate/docs/upgrade10.html @@ -144,6 +144,9 @@ ALTER TABLE agent ADD _password varchar(80) NULL; ALTER TABLE h_agent ADD _password varchar(80) NULL; ALTER TABLE cust_main ADD paycvv varchar(4) NULL; ALTER TABLE h_cust_main ADD paycvv varchar(4) NULL; +ALTER TABLE part_referral ADD disabled char(1) NULL; +ALTER TABLE h_part_referral ADD disabled char(1) NULL; +CREATE INDEX part_referral1 ON part_referral ( disabled ); dump database, edit: - cust_main: increase otaker from 8 to 32 @@ -164,6 +167,8 @@ optionally: CREATE INDEX cust_main9 ON cust_main ( ship_daytime ); CREATE INDEX cust_main10 ON cust_main ( ship_night ); CREATE INDEX cust_main11 ON cust_main ( ship_fax ); + CREATE INDEX agent2 ON agent ( disabled ); + CREATE INDEX part_bill_event2 ON part_bill_event ( disabled ); serial columns |