#!/bin/sh
sqlite3 /etc/celltowers.db "CREATE TABLE IF NOT EXISTS cell_towers (mcc INTEGER, mnc INTEGER, lac INTEGER, cellid INTEGER, lon REAL, lat REAL, source TEXT, pci INTEGER, updated TEXT, PRIMARY KEY(mcc,mnc,lac,cellid));"
# source/pci/updated added later: upgrade existing databases (duplicate column errors are expected)
for col in "source TEXT" "pci INTEGER" "updated TEXT"; do
	sqlite3 /etc/celltowers.db "ALTER TABLE cell_towers ADD COLUMN $col;" 2>/dev/null
done
exit 0
