diff options
| author | jeff <jeff> | 2008-09-18 23:18:20 +0000 |
|---|---|---|
| committer | jeff <jeff> | 2008-09-18 23:18:20 +0000 |
| commit | ade0ddb52eaab4999864035f83e5d2393ef89c26 (patch) | |
| tree | 81b22714f06b622eae121ccade901a833fb5cc53 | |
| parent | ef13effa3f9d92f5ae0858d9f116fefc07c96982 (diff) | |
trade space for time
| -rw-r--r-- | FS/FS/Schema.pm | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/FS/FS/Schema.pm b/FS/FS/Schema.pm index bfbdfb96f..da75899aa 100644 --- a/FS/FS/Schema.pm +++ b/FS/FS/Schema.pm @@ -200,6 +200,14 @@ sub dbdef_dist { ], }); + $h_indices{"h_${table}_srckey2"} = DBIx::DBSchema::Index->new({ + 'name' => "h_${table}_srckey2", + 'unique' => 0, + 'columns' => [ 'history_date', + $tableobj->primary_key, + ], + }); + my $h_tableobj = DBIx::DBSchema::Table->new( { 'name' => "h_$table", 'primary_key' => 'historynum', @@ -496,6 +504,7 @@ sub tables_hashref { 'stateid_state', 'varchar', 'NULL', $char_d, '', '', 'birthdate' ,@date_type, '', '', 'signupdate',@date_type, '', '', + 'dundate', @date_type, '', '', 'company', 'varchar', 'NULL', $char_d, '', '', 'address1', 'varchar', '', $char_d, '', '', 'address2', 'varchar', 'NULL', $char_d, '', '', |