DATABASE.md

This is Work in Progress! Thus this is not yet accurate and quite possibly wrong info.

<p style='color:red'>This is some red text.</p>

Introduction

AIMSICD utillize several tables in a single SQLite3 database in aimsicd.db to keep track of all the network changes and the downloaded Open Cell ID (OCID) data. When you're making a file backup of the AOMSICD database, you're actually saving the various tables into individual .CSV files. This make it easy to manually or externally update some tables.

All mentioned sqlite commands are properly documented on the SQLite website

Accessing the databases:

From a PC:

adb shell

su

sqlite3 /data/data/com.SecUpwN.AIMSICD/databases/aimsicd.db

From a Terminal Emulator within Android:

su

sqlite3 /data/data/com.SecUpwN.AIMSICD/databases/aimsicd.db

*Note: You may need to install sqlite3 binaries

aimsicd.db consists of four relevant tables

TABLE:LOCATION_TABLE

TABLE:CELL_TABLE

TABLE:OPENCELLID_TABLE

TABLE:DEFAULT_MCC_TABLE

TABLE:SILENT_SMS_TABLE