1#!/bin/bash 2 3db_file=$1 4 5 6cat << EOF | sqlite3 $db_file 7PRAGMA synchronous = OFF; 8PRAGMA cache_size = 800000; 9PRAGMA journal_mode = OFF; 10PRAGMA count_changes = OFF; 11PRAGMA temp_store = MEMORY; 12PRAGMA locking = EXCLUSIVE; 13 14CREATE INDEX type_size_idx on type_size (type); 15CREATE INDEX type_val_idx on type_value (type); 16 17EOF 18 19 20