Skip to content
GitLab

Technical Overview · Changes

Page history
reoved old DB table references authored by E:V:A's avatar E:V:A
Show whitespace changes
Inline Side-by-side
Technical-Overview.md
View page @ c88938d7
...@@ -20,16 +20,17 @@ This documentation is especially for developers who want to join our project and ...@@ -20,16 +20,17 @@ This documentation is especially for developers who want to join our project and
--- ---
###Database Tables: (Current Behavior) ###Database Tables:
AIMSICD utilizes several tables in a single SQLite3 database in `aimsicd.db` to keep track AIMSICD utilizes 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 of all the network changes and the downloaded Open Cell ID (OCID) data. When you're making a file
backup of the AIMSICD database, you're actually saving the various tables into individual backup of the AIMSICD database, you're actually saving the various tables into individual
`<tablename>.CSV` files, which can be updated manually or externally. `aimsicd-<tablename>.CSV` files, which can be updated manually or externally.
All mentioned sqlite commands are properly documented on the [SQLite website](http://www.sqlite.org). All mentioned sqlite commands are properly documented on the [SQLite website](http://www.sqlite.org).
![Database Tables](https://spideroak.com/share/IFEU2U2JINCA/GitHub/home/SecUpwN/SpiderOak/DOCUMENTATION/Database_myCellInfo_ER_2.png) ![New Database Tables](https://spideroak.com/share/IFEU2U2JINCA/GitHub/home/SecUpwN/SpiderOak/DOCUMENTATION/Database_myCellInfo_ER_3.png)
#### DEFAULT_MCC_TABLE (Mobile Country Code) #### DEFAULT_MCC_TABLE (Mobile Country Code)
This table holds data to identify your service provider (carrier) and country. This table holds data to identify your service provider (carrier) and country.
#### CELL_TABLE #### CELL_TABLE
...@@ -43,10 +44,6 @@ Protocol of incoming messages. ...@@ -43,10 +44,6 @@ Protocol of incoming messages.
--- ---
#### Database Tables: (New Proposal)
![New Database Tables](https://spideroak.com/share/IFEU2U2JINCA/GitHub/home/SecUpwN/SpiderOak/DOCUMENTATION/Database_myCellInfo_ER_3.png)
#### Accessing the Databases #### Accessing the Databases
* From a PC * From a PC
......