projects
/
freeside.git
/ commitdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
| commitdiff |
tree
raw
|
patch
|
inline
| side by side (parent:
b400f5e
)
indices on cust_main ship_last and ship_country
author
ivan
<ivan>
Sun, 19 Aug 2001 13:50:47 +0000
(13:50 +0000)
committer
ivan
<ivan>
Sun, 19 Aug 2001 13:50:47 +0000
(13:50 +0000)
bin/fs-setup
patch
|
blob
|
history
httemplate/docs/upgrade8.html
patch
|
blob
|
history
diff --git
a/bin/fs-setup
b/bin/fs-setup
index
ec8b750
..
7056347
100755
(executable)
--- a/
bin/fs-setup
+++ b/
bin/fs-setup
@@
-1,6
+1,6
@@
#!/usr/bin/perl -Tw
#
#!/usr/bin/perl -Tw
#
-# $Id: fs-setup,v 1.4
2 2001-08-13 00:19:02
ivan Exp $
+# $Id: fs-setup,v 1.4
3 2001-08-19 13:50:47
ivan Exp $
#to delay loading dbdef until we're ready
BEGIN { $FS::Record::setup_hack = 1; }
#to delay loading dbdef until we're ready
BEGIN { $FS::Record::setup_hack = 1; }
@@
-92,10
+92,11
@@
my($dbdef) = new DBIx::DBSchema ( map {
);
} (keys %tables) );
);
} (keys %tables) );
-#remove ship_ from cust_main
-unless ($ship) {
- my $cust_main = $dbdef->table('cust_main');
+my $cust_main = $dbdef->table('cust_main');
+unless ($ship) { #remove ship_ from cust_main
$cust_main->delcolumn($_) foreach ( grep /^ship_/, $cust_main->columns );
$cust_main->delcolumn($_) foreach ( grep /^ship_/, $cust_main->columns );
+} else { #add indices on ship_last and ship_company
+ push @{$cust_main->index->lol_ref}, ( ['ship_last'], ['ship_company'] )
}
#add radius attributes to svc_acct
}
#add radius attributes to svc_acct
@@
-363,7
+364,7
@@
sub tables_hash_hack {
'primary_key' => 'custnum',
'unique' => [ [] ],
#'index' => [ ['last'], ['company'] ],
'primary_key' => 'custnum',
'unique' => [ [] ],
#'index' => [ ['last'], ['company'] ],
- 'index' => [ ['last'], ],
+ 'index' => [ ['last'],
[ 'company' ]
],
},
'cust_main_invoice' => {
},
'cust_main_invoice' => {
diff --git
a/httemplate/docs/upgrade8.html
b/httemplate/docs/upgrade8.html
index
1a5c998
..
60f8f15
100644
(file)
--- a/
httemplate/docs/upgrade8.html
+++ b/
httemplate/docs/upgrade8.html
@@
-129,6
+129,8
@@
ALTER TABLE cust_main ADD COLUMN ship_country char(2) NULL;
ALTER TABLE cust_main ADD COLUMN ship_daytime varchar(20) NULL;
ALTER TABLE cust_main ADD COLUMN ship_night varchar(20) NULL;
ALTER TABLE cust_main ADD COLUMN ship_fax varchar(12) NULL;
ALTER TABLE cust_main ADD COLUMN ship_daytime varchar(20) NULL;
ALTER TABLE cust_main ADD COLUMN ship_night varchar(20) NULL;
ALTER TABLE cust_main ADD COLUMN ship_fax varchar(12) NULL;
+CREATE INDEX cust_main1 ON cust_main ( ship_last );
+CREATE INDEX cust_main2 ON cust_main ( ship_company );
</pre>
<li>If you wish to enable customer comments, apply the following change to
your database:
</pre>
<li>If you wish to enable customer comments, apply the following change to
your database: