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