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 type_size_idx on type_size (type);
15*1f5207b7SJohn LevonCREATE INDEX type_val_idx on type_value (type);
16*1f5207b7SJohn Levon
17*1f5207b7SJohn LevonEOF
18*1f5207b7SJohn Levon
19*1f5207b7SJohn Levon
20