Hi, Is there any investigation or guess ? Any answer would be appreciated.
Thanks. 2016. 7. 29. 오후 12:39에 "Youngjoon Lee" <[email protected]>님이 작성: > ./showdb my-db dbheader > > Pagesize: 4096 > Available pages: 1..745888 > 000: 53 51 4c 69 74 65 20 66 6f 72 6d 61 74 20 33 00 SQLite format 3. > 010: 10 00 01 01 00 40 20 20 00 00 0b 7a 00 0b 61 a0 .....@ ...z..a. > 020: 00 00 00 00 00 00 00 00 00 00 00 02 00 00 00 04 ................ > 030: 00 00 00 00 00 00 00 05 00 00 00 01 00 00 00 04 ................ > 040: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................ > 050: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 0b 7a ...............z > 060: 00 2d f9 88 00 .-... > Decoded: > 010: 10 00 4096 Database page size > 012: 01 1 File format write version > 013: 01 1 File format read version > 014: 00 0 Reserved space at end of page > 018: 00 00 0b 7a 2938 File change counter > 01c: 00 0b 61 a0 745888 Size of database in pages > 020: 00 00 00 00 0 Page number of first freelist page > 024: 00 00 00 00 0 Number of freelist pages > 028: 00 00 00 02 2 Schema cookie > 02c: 00 00 00 04 4 Schema format version > 030: 00 00 00 00 0 Default page cache size > 034: 00 00 00 05 5 Largest auto-vac root page > 038: 00 00 00 01 1 Text encoding > 03c: 00 00 00 04 4 User version > 040: 00 00 00 00 0 Incremental-vacuum mode > 044: 00 00 00 00 0 Application ID > 048: 00 00 00 00 0 meta[8] > 04c: 00 00 00 00 0 meta[9] > 050: 00 00 00 00 0 meta[10] > 054: 00 00 00 00 0 meta[11] > 058: 00 00 00 00 0 meta[12] > 05c: 00 00 0b 7a 2938 Change counter for version number > 060: 00 2d f9 88 3013000 SQLite version number > > sqlite3 my-db schema > > CREATE TABLE android_metadata (locale TEXT); > CREATE TABLE log (_id INTEGER PRIMARY KEY AUTOINCREMENT,event_user_id > INT,event_type INT,event_time_ms INT,key TEXT,pkg TEXT,nid INT,tag > TEXT,when_ms INT,defaults INT,flags INT,priority INT,category > TEXT,action_count INT,posttime_ms INT,airtime_ms > INT,first_expansion_time_ms INT,expansion_airtime_ms INT,expansion_count > INT); > _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
