1*1f5207b7SJohn Levon#!/bin/bash
2*1f5207b7SJohn Levon
3*1f5207b7SJohn Levondb_file=$1
4*1f5207b7SJohn Levon
5*1f5207b7SJohn Levon
6*1f5207b7SJohn Levoncat << EOF | sqlite3 $db_file
7*1f5207b7SJohn LevonPRAGMA synchronous = OFF;
8*1f5207b7SJohn LevonPRAGMA cache_size = 800000;
9*1f5207b7SJohn LevonPRAGMA journal_mode = OFF;
10*1f5207b7SJohn LevonPRAGMA count_changes = OFF;
11*1f5207b7SJohn LevonPRAGMA temp_store = MEMORY;
12*1f5207b7SJohn LevonPRAGMA locking = EXCLUSIVE;
13*1f5207b7SJohn Levon
14*1f5207b7SJohn LevonCREATE INDEX caller_fn_idx on caller_info (function, call_id);
15*1f5207b7SJohn LevonCREATE INDEX caller_ff_idx on caller_info (file, function, call_id);
16*1f5207b7SJohn LevonCREATE INDEX common_fn_idx on common_caller_info (function, call_id);
17*1f5207b7SJohn LevonCREATE INDEX common_ff_idx on common_caller_info (file, function, call_id);
18*1f5207b7SJohn LevonCREATE INDEX call_implies_fn_idx on call_implies (function);
19*1f5207b7SJohn LevonCREATE INDEX call_implies_ff_idx on call_implies (file, function);
20*1f5207b7SJohn LevonCREATE INDEX return_implies_fn_idx on return_implies (function);
21*1f5207b7SJohn LevonCREATE INDEX return_implies_ff_idx on return_implies (file, function);
22*1f5207b7SJohn LevonCREATE INDEX data_file_info_idx on data_info (file, data);
23*1f5207b7SJohn LevonCREATE INDEX data_info_idx on data_info (data);
24*1f5207b7SJohn LevonCREATE INDEX fn_ptr_idx_file on function_ptr (file, function);
25*1f5207b7SJohn LevonCREATE INDEX fn_ptr_idx_nofile on function_ptr (function);
26*1f5207b7SJohn LevonCREATE INDEX fn_ptr_idx_ptr on function_ptr (ptr);
27*1f5207b7SJohn LevonCREATE INDEX file_function_type_idx on function_type (file, function);
28*1f5207b7SJohn LevonCREATE INDEX function_type_idx on function_type (function);
29*1f5207b7SJohn LevonCREATE INDEX function_type_size_idx ON function_type_size (type);
30*1f5207b7SJohn LevonCREATE INDEX function_type_value_idx ON function_type_value (type);
31*1f5207b7SJohn LevonCREATE INDEX local_value_idx on local_values (file, variable);
32*1f5207b7SJohn LevonCREATE INDEX return_states_fn_idx on return_states (function);
33*1f5207b7SJohn LevonCREATE INDEX return_states_ff_idx on return_states (file, function);
34*1f5207b7SJohn LevonCREATE INDEX parameter_name_file_idx on parameter_name (file, function);
35*1f5207b7SJohn LevonCREATE INDEX parameter_name_idx on parameter_name (function);
36*1f5207b7SJohn LevonCREATE INDEX str_idx on constraints (str);
37*1f5207b7SJohn LevonCREATE INDEX required_idx on constraints_required (data);
38*1f5207b7SJohn LevonCREATE INDEX mtag_about_idx on mtag_about (tag);
39*1f5207b7SJohn LevonCREATE INDEX mtag_data_idx on mtag_data (tag);
40*1f5207b7SJohn LevonCREATE INDEX mtag_map_idx1 on mtag_map (tag);
41*1f5207b7SJohn LevonCREATE INDEX mtag_map_idx2 on mtag_map (container);
42*1f5207b7SJohn LevonCREATE INDEX sink_index on sink_info (file, sink_name);
43*1f5207b7SJohn Levon
44*1f5207b7SJohn LevonEOF
45*1f5207b7SJohn Levon
46*1f5207b7SJohn Levon#CREATE INDEX type_size_idx on type_size (type);
47*1f5207b7SJohn Levon#CREATE INDEX type_val_idx on type_value (type);
48*1f5207b7SJohn Levon
49