projects
/
freeside.git
/ commitdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
| commitdiff |
tree
raw
|
patch
| inline |
side by side
(parent:
978fea1
)
add a key on ( history_action, $primary_key ) to the h_ tables. this should speed...
author
ivan
<ivan>
Mon, 19 May 2008 04:29:01 +0000
(
04:29
+0000)
committer
ivan
<ivan>
Mon, 19 May 2008 04:29:01 +0000
(
04:29
+0000)
FS/FS/Schema.pm
patch
|
blob
|
history
diff --git
a/FS/FS/Schema.pm
b/FS/FS/Schema.pm
index
457e5c8
..
9e7b07f
100644
(file)
--- a/
FS/FS/Schema.pm
+++ b/
FS/FS/Schema.pm
@@
-192,6
+192,14
@@
sub dbdef_dist {
}
keys %indices;
+ $h_indices{"h_${table}_srckey"} = DBIx::DBSchema::Index->new({
+ 'name' => "h_${table}_srckey",
+ 'unique' => 0,
+ 'columns' => [ 'history_action', #right?
+ $tableobj->primary_key,
+ ],
+ });
+
my $h_tableobj = DBIx::DBSchema::Table->new( {
'name' => "h_$table",
'primary_key' => 'historynum',