./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
