summaryrefslogtreecommitdiff
path: root/src/lib/create_table
blob: cdeb4770c1a63e4630841c929cda901f1562ae71 (plain)
1
2
3
4
5
6
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);"
}