summaryrefslogtreecommitdiff
path: root/demos/blog-tutorial/samples/day4/blog/protected/data/blog.db
blob: fa48526ac200fa4dcfd7e5b5e1802f877044506f (plain)
ofshex dumpascii
0000 53 51 4c 69 74 65 20 66 6f 72 6d 61 74 20 33 00 04 00 01 01 00 40 20 20 00 00 00 0d 00 00 00 00 SQLite.format.3......@..........
0020 00 00 00 00 00 00 00 00 00 00 00 08 00 00 00 01 00 00 00 00 00 00 00 00 00 00 00 01 00 00 00 00 ................................
0040 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
0060 00 00 00 00 0d 03 fc 00 03 00 a4 00 02 81 03 d1 00 a4 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
0080 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
00a0 00 00 00 00 83 5a 03 07 17 17 17 01 87 13 74 61 62 6c 65 70 6f 73 74 73 70 6f 73 74 73 04 43 52 .....Z........tablepostsposts.CR
00c0 45 41 54 45 20 54 41 42 4c 45 20 70 6f 73 74 73 20 28 0d 20 20 70 6f 73 74 5f 69 64 20 20 20 20 EATE.TABLE.posts.(...post_id....
00e0 20 20 20 49 4e 54 45 47 45 52 20 4e 4f 54 20 4e 55 4c 4c 20 50 52 49 4d 41 52 59 20 4b 45 59 2c ...INTEGER.NOT.NULL.PRIMARY.KEY,
0100 0d 20 20 61 75 74 68 6f 72 5f 69 64 20 20 20 20 20 56 41 52 43 48 41 52 28 31 32 38 29 20 4e 4f ...author_id.....VARCHAR(128).NO
0120 54 20 4e 55 4c 4c 20 20 20 0d 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 43 4f T.NULL........................CO
0140 4e 53 54 52 41 49 4e 54 20 66 6b 5f 61 75 74 68 6f 72 20 52 45 46 45 52 45 4e 43 45 53 20 75 73 NSTRAINT.fk_author.REFERENCES.us
0160 65 72 73 28 75 73 65 72 6e 61 6d 65 29 2c 0d 20 20 63 72 65 61 74 65 5f 74 69 6d 65 20 20 20 49 ers(username),...create_time...I
0180 4e 54 45 47 45 52 20 4e 4f 54 20 4e 55 4c 4c 2c 20 20 20 20 20 20 20 2f 2a 20 55 4e 49 58 20 74 NTEGER.NOT.NULL,......./*.UNIX.t
01a0 69 6d 65 73 74 61 6d 70 20 2a 2f 0d 20 20 74 69 74 6c 65 20 20 20 20 20 20 20 20 20 56 41 52 43 imestamp.*/...title.........VARC
01c0 48 41 52 28 32 35 36 29 20 4e 4f 54 20 4e 55 4c 4c 2c 20 20 2f 2a 20 74 69 74 6c 65 20 6f 66 20 HAR(256).NOT.NULL,../*.title.of.
01e0 74 68 65 20 70 6f 73 74 20 2a 2f 0d 20 20 63 6f 6e 74 65 6e 74 20 20 20 20 20 20 20 54 45 58 54 the.post.*/...content.......TEXT
0200 2c 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 2f 2a 20 70 6f 73 74 20 62 6f 64 79 ,.................../*.post.body
0220 20 2a 2f 0d 20 20 73 74 61 74 75 73 20 20 20 20 20 20 20 20 49 4e 54 45 47 45 52 20 4e 4f 54 20 .*/...status........INTEGER.NOT.
0240 4e 55 4c 4c 20 20 20 20 20 20 20 20 2f 2a 20 30 3a 20 70 75 62 6c 69 73 68 65 64 3b 20 31 3a 20 NULL......../*.0:.published;.1:.
0260 64 72 61 66 74 3b 20 32 3a 20 70 65 6e 64 69 6e 67 3b 20 32 3a 20 64 65 6e 69 65 64 20 2a 2f 0d draft;.2:.pending;.2:.denied.*/.
0280 29 82 4d 01 07 17 17 17 01 84 79 74 61 62 6c 65 75 73 65 72 73 75 73 65 72 73 02 43 52 45 41 54 ).M.......ytableusersusers.CREAT
02a0 45 20 54 41 42 4c 45 20 75 73 65 72 73 20 28 0a 20 20 75 73 65 72 6e 61 6d 65 20 20 20 20 20 20 E.TABLE.users.(...username......
02c0 56 41 52 43 48 41 52 28 31 32 38 29 20 4e 4f 54 20 4e 55 4c 4c 20 50 52 49 4d 41 52 59 20 4b 45 VARCHAR(128).NOT.NULL.PRIMARY.KE
02e0 59 2c 0a 20 20 65 6d 61 69 6c 20 20 20 20 20 20 20 20 20 56 41 52 43 48 41 52 28 31 32 38 29 20 Y,...email.........VARCHAR(128).
0300 4e 4f 54 20 4e 55 4c 4c 2c 0a 20 20 70 61 73 73 77 6f 72 64 20 20 20 20 20 20 56 41 52 43 48 41 NOT.NULL,...password......VARCHA
0320 52 28 31 32 38 29 20 4e 4f 54 20 4e 55 4c 4c 2c 20 20 2f 2a 20 69 6e 20 70 6c 61 69 6e 20 74 65 R(128).NOT.NULL,../*.in.plain.te
0340 78 74 20 2a 2f 0a 20 20 72 6f 6c 65 20 20 20 20 20 20 20 20 20 20 49 4e 54 45 47 45 52 20 4e 4f xt.*/...role..........INTEGER.NO
0360 54 20 4e 55 4c 4c 2c 20 20 20 20 20 20 20 2f 2a 20 30 3a 20 6e 6f 72 6d 61 6c 20 75 73 65 72 2c T.NULL,......./*.0:.normal.user,
0380 20 31 3a 20 61 64 6d 69 6e 69 73 74 72 61 74 6f 72 20 2a 2f 0a 20 20 66 69 72 73 74 5f 6e 61 6d .1:.administrator.*/...first_nam
03a0 65 20 20 20 20 56 41 52 43 48 41 52 28 31 32 38 29 2c 0a 20 20 6c 61 73 74 5f 6e 61 6d 65 20 20 e....VARCHAR(128),...last_name..
03c0 20 20 20 56 41 52 43 48 41 52 28 31 32 38 29 0a 29 29 02 06 17 3d 17 01 00 69 6e 64 65 78 73 71 ...VARCHAR(128).))...=...indexsq
03e0 6c 69 74 65 5f 61 75 74 6f 69 6e 64 65 78 5f 75 73 65 72 73 5f 31 75 73 65 72 73 03 00 00 00 04 lite_autoindex_users_1users.....
0400 0d 00 00 00 02 03 ab 00 03 d4 03 ab 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
0420 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
0440 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
0460 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
0480 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
04a0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
04c0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
04e0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
0500 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
0520 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
0540 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
0560 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
0580 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
05a0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
05c0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
05e0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
0600 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
0620 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
0640 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
0660 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
0680 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
06a0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
06c0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
06e0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
0700 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
0720 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
0740 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
0760 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
0780 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
07a0 00 00 00 00 00 00 00 00 00 00 00 27 02 07 15 2d 15 01 13 15 64 65 6d 6f 64 65 6d 6f 40 65 78 61 ...........'...-....demodemo@exa
07c0 6d 70 6c 65 2e 63 6f 6d 64 65 6d 6f 00 57 65 69 5a 68 75 6f 2a 01 07 17 2f 15 01 17 13 61 64 6d mple.comdemo.WeiZhuo*.../....adm
07e0 69 6e 61 64 6d 69 6e 40 65 78 61 6d 70 6c 65 2e 63 6f 6d 64 65 6d 6f 01 51 69 61 6e 67 58 75 65 inadmin@example.comdemo.QiangXue
0800 0a 00 00 00 02 03 ed 00 03 f6 03 ed 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
0820 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
0840 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
0860 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
0880 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
08a0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
08c0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
08e0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
0900 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
0920 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
0940 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
0960 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
0980 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
09a0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
09c0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
09e0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
0a00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
0a20 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
0a40 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
0a60 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
0a80 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
0aa0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
0ac0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
0ae0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
0b00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
0b20 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
0b40 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
0b60 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
0b80 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
0ba0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
0bc0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
0be0 00 00 00 00 00 00 00 00 00 00 00 00 00 08 03 15 01 64 65 6d 6f 02 09 03 17 01 61 64 6d 69 6e 01 .................demo.....admin.
0c00 0d 00 00 00 01 03 ce 00 03 ce 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
0c20 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
0c40 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
0c60 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
0c80 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
0ca0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
0cc0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
0ce0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
0d00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
0d20 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
0d40 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
0d60 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
0d80 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
0da0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
0dc0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
0de0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
0e00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
0e20 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
0e40 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
0e60 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
0e80 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
0ea0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
0ec0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
0ee0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
0f00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
0f20 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
0f40 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
0f60 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
0f80 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
0fa0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
0fc0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 30 01 07 00 17 04 21 37 01 61 64 6d 69 6e 46 13 e3 42 ..............0.....!7.adminF..B
0fe0 66 69 72 73 74 20 70 6f 73 74 74 68 69 73 20 69 73 20 6d 79 20 66 69 72 73 74 20 70 6f 73 74 00 first.postthis.is.my.first.post.