summaryrefslogtreecommitdiff
path: root/src/lib/create_table
blob: a783c50b58cd40e6432ac006aae5a75bca6e3738 (plain)
1
2
3
4
5
6
7
create_table() {
	DB_PATH="$1"

	sqlite3 "$DB_PATH" "CREATE TABLE IF NOT EXISTS searchIndex(id INTEGER PRIMARY KEY, name TEXT, type TEXT, path TEXT);"
	sqlite3 "$DB_PATH" "CREATE UNIQUE INDEX IF NOT EXISTS anchor ON searchIndex (name, type, path);"
}