07/09/2008

telephony.db

Something interesting I found a few days ago.
$ ./emulator &
$ ./adb shell
# cd /data/data/com.google.android.providers.telephony/databases
# sqlite3 telephony.db
sqlite> .schema
CREATE TABLE android_metadata (locale TEXT);
CREATE TABLE carriers(_id INTEGER PRIMARY KEY,name TEXT,numeric TEXT,
mcc TEXT,mnc TEXT,apn TEXT,user TEXT,server TEXT,password TEXT,
proxy TEXT,port TEXT,mmsproxy TEXT,mmsport TEXT,
mmsc TEXT,current INTEGER);

sqlite> .dump carriers
BEGIN TRANSACTION;
CREATE TABLE carriers(_id INTEGER PRIMARY KEY,name TEXT,numeric TEXT,
mcc TEXT,mnc TEXT,apn TEXT,user TEXT,server TEXT,password TEXT,
proxy TEXT,port TEXT,mmsproxy TEXT,mmsport TEXT,
mmsc TEXT,current INTEGER);

INSERT INTO "carriers" VALUES(1,'T-Mobile US','310260',
'310','260','wap.voicestream.com','none','*','none',
'216.155.165.50','8080',NULL,NULL,
'http://216.155.174.84/servlets/mms’,NULL);
:
:
:
INSERT INTO "carriers" VALUES(26,'Android','31099',
'310','99','internet','*','*','*',
NULL,NULL,NULL,NULL,
'null',NULL);

It seems to me that this telephony.db file contains APN information which will be required to connect Internet through PPP.

Following is a complete list of carriers contained in telephony.db.
  • T-Mobile US
  • T-Mobile UK
  • T-Mobile D
  • T-Mobile A
  • T-Mobile CZ
  • T-Mobile NL
  • Cingular 410
  • Cingular 170 Pacific Bell
  • Cingular 380 ATT
  • Chunghwa
  • TWN GSM
  • Far EasTone
  • KGT-Online
  • India Hutch
  • SFR
  • Vodafone UK
  • IL Orange
  • IL Cellcom
  • IL Pelephone
  • Jawwal Palestine
  • Swisscom GPRS
  • ERA
  • CMCC
  • Android
  • UBIQUISYS
  • Android


Cheers,
posted by 安藤恐竜 at 15:09 | Comment(0) | TrackBack(0) | 日記
Comments for this entry
Leave your comment
Name: [Must]

EMail: [Must]

URL: [Must]

Comment: [Must]

Confirmation Code: [Must]


Type in alphabets what you see in this image.

Trackbacks to this entry
×

この広告は90日以上新しい記事の投稿がないブログに表示されております。