blob: f8e3660f6729c78912823b8df7322b43a0b157ae (plain)

ofs	hex dump	ascii
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 b9 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 2e 00 03 01 8c 00 02 64 02 f9 01 8c 00 00 00 00 00 00 00 00 00 00 00 00 00 00	.............d..................
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 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00	................................
00c0	00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00	................................
00e0	00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00	................................
0100	00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00	................................
0120	00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00	................................
0140	00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00	................................
0160	00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00	................................
0180	00 00 00 00 00 00 00 00 00 00 00 00 81 55 04 07 17 23 23 01 82 71 74 61 62 6c 65 63 68 61 74 5f	.............U...##..qtablechat_
01a0	62 75 66 66 65 72 63 68 61 74 5f 62 75 66 66 65 72 02 43 52 45 41 54 45 20 54 41 42 4c 45 20 63	bufferchat_buffer.CREATE.TABLE.c
01c0	68 61 74 5f 62 75 66 66 65 72 20 28 0a 69 64 20 49 4e 54 45 47 45 52 20 50 52 49 4d 41 52 59 20	hat_buffer.(.id.INTEGER.PRIMARY.
01e0	4b 45 59 2c 0a 66 6f 72 5f 75 73 65 72 20 56 41 52 43 48 41 52 28 32 30 29 20 4e 4f 54 20 4e 55	KEY,.for_user.VARCHAR(20).NOT.NU
0200	4c 4c 2c 0a 66 72 6f 6d 5f 75 73 65 72 20 56 41 52 43 48 41 52 28 32 30 29 20 4e 4f 54 20 4e 55	LL,.from_user.VARCHAR(20).NOT.NU
0220	4c 4c 2c 0a 6d 65 73 73 61 67 65 20 54 45 58 54 20 4e 4f 54 20 4e 55 4c 4c 2c 0a 63 72 65 61 74	LL,.message.TEXT.NOT.NULL,.creat
0240	65 64 5f 6f 6e 20 49 4e 54 45 47 45 52 20 4e 4f 54 20 4e 55 4c 4c 20 44 45 46 41 55 4c 54 20 22	ed_on.INTEGER.NOT.NULL.DEFAULT."
0260	30 22 0a 29 81 12 02 07 17 21 21 01 81 6f 74 61 62 6c 65 63 68 61 74 5f 75 73 65 72 73 63 68 61	0".).....!!..otablechat_userscha
0280	74 5f 75 73 65 72 73 03 43 52 45 41 54 45 20 54 41 42 4c 45 20 63 68 61 74 5f 75 73 65 72 73 20	t_users.CREATE.TABLE.chat_users.
02a0	28 0a 75 73 65 72 6e 61 6d 65 20 56 41 52 43 48 41 52 28 32 30 29 20 4e 4f 54 20 4e 55 4c 4c 20	(.username.VARCHAR(20).NOT.NULL.
02c0	50 52 49 4d 41 52 59 20 4b 45 59 2c 0a 6c 61 73 74 5f 61 63 74 69 76 69 74 79 20 49 4e 54 45 47	PRIMARY.KEY,.last_activity.INTEG
02e0	45 52 20 4e 4f 54 20 4e 55 4c 4c 20 44 45 46 41 55 4c 54 20 22 30 22 0a 29 33 03 06 17 47 21 01	ER.NOT.NULL.DEFAULT."0".)3...G!.
0300	00 69 6e 64 65 78 73 71 6c 69 74 65 5f 61 75 74 6f 69 6e 64 65 78 5f 63 68 61 74 5f 75 73 65 72	.indexsqlite_autoindex_chat_user
0320	73 5f 31 63 68 61 74 5f 75 73 65 72 73 04 00 00 00 d2 00 00 00 ce 17 23 23 01 82 5d 74 61 62 6c	s_1chat_users..........##..]tabl
0340	65 63 68 61 74 5f 62 75 66 66 65 72 63 68 61 74 5f 62 75 66 66 65 72 02 43 52 45 41 54 45 20 54	echat_bufferchat_buffer.CREATE.T
0360	41 42 4c 45 20 63 68 61 74 5f 62 75 66 66 65 72 20 28 0a 69 64 20 49 4e 54 45 47 45 52 20 20 50	ABLE.chat_buffer.(.id.INTEGER..P
0380	52 49 4d 41 52 59 20 4b 45 59 2c 0a 66 6f 72 5f 75 73 65 72 20 56 41 52 43 48 41 52 28 32 30 29	RIMARY.KEY,.for_user.VARCHAR(20)
03a0	20 4e 4f 54 20 4e 55 4c 4c 2c 0a 66 72 6f 6d 5f 75 73 65 72 20 56 41 52 43 48 41 52 28 32 30 29	.NOT.NULL,.from_user.VARCHAR(20)
03c0	20 4e 4f 54 20 4e 55 4c 4c 2c 0a 6d 65 73 73 61 67 65 20 54 45 58 54 20 4e 4f 54 20 4e 55 4c 4c	.NOT.NULL,.message.TEXT.NOT.NULL
03e0	2c 0a 63 72 65 61 74 65 64 5f 6f 6e 20 44 41 54 45 54 49 4d 45 20 4e 4f 54 20 4e 55 00 00 00 04	,.created_on.DATETIME.NOT.NU....
0400	0d 03 bc 00 00 03 b6 08 03 e1 03 92 01 68 01 68 03 a2 01 68 01 68 01 68 01 68 01 68 01 68 01 68	.............h.h...h.h.h.h.h.h.h
0420	01 68 01 68 01 68 01 68 01 68 01 68 01 68 01 68 01 68 01 68 01 68 01 68 01 68 00 00 00 00 00 00	.h.h.h.h.h.h.h.h.h.h.h.h.h......
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 03 bc 02 4e 17 13 11 04 71 65 6e 64 79 77 65 69 73 64 45 9c 97 24 03 bc	...........N....qendyweisdE..$..
0580	02 38 17 13 13 04 71 65 6e 64 79 77 65 69 61 73 64 45 9c 97 13 03 bc 02 21 17 13 15 04 71 65 6e	.8....qendyweiasdE......!....qen
05a0	64 79 77 65 69 68 6d 6d 6d 45 9c 97 11 03 bc 02 09 17 13 11 04 71 65 6e 64 79 77 65 69 73 64 45	dyweihmmmE...........qendyweisdE
05c0	9c 97 0e 03 bc 01 f3 17 13 0f 04 71 65 6e 64 79 77 65 69 6a 45 9c 96 6a 03 bc 01 de 17 13 15 04	...........qendyweijE..j........
05e0	71 65 6e 64 79 77 65 69 6d 6d 6d 6d 45 9c 95 d1 03 bc 01 c6 17 13 19 04 71 65 6e 64 79 77 65 69	qendyweimmmmE...........qendywei
0600	68 64 68 64 68 64 45 9c 95 ce 03 bc 01 ac 17 13 11 04 71 65 6e 64 79 77 65 69 73 64 45 9c 95 b2	hdhdhdE...........qendyweisdE...
0620	03 bc 01 96 17 13 19 04 71 65 6e 64 79 77 65 69 6c 6b 6a 6c 6b 6a 45 9c 95 56 03 bc 01 7c 17 13	........qendyweilkjlkjE..V...|..
0640	19 04 71 65 6e 64 79 77 65 69 64 6a 64 6a 64 6a 45 9c 95 1a 03 bc 01 62 17 13 23 04 71 65 6e 64	..qendyweidjdjdjE......b..#.qend
0660	79 77 65 69 6b 6a 64 6b 73 6a 20 64 6c 6b 6a 45 9c 94 93 02 c6 00 39 13 03 a2 03 03 03 a2 00 14	yweikjdksj.dlkjE......9.........
0680	13 13 11 04 77 65 69 77 65 69 73 64 45 9c 97 24 02 c6 00 1c 17 13 1d 04 71 65 6e 64 79 77 65 69	....weiweisdE..$........qendywei
06a0	6b 6a 61 6c 73 6b 6a 64 45 9c 94 8f 02 c6 00 18 17 13 15 04 71 65 6e 64 79 77 65 69 68 6d 6d 6d	kjalskjdE...........qendyweihmmm
06c0	45 9c 94 96 94 8f 03 bc 00 f0 17 13 11 04 71 65 6e 64 79 77 65 69 73 64 45 9c 94 8d 03 bc 00 da	E.............qendyweisdE.......
06e0	17 13 17 04 71 65 6e 64 79 77 65 69 79 65 61 68 21 45 9c 94 88 03 bc 00 c1 17 13 17 04 71 65 6e	....qendyweiyeah!E...........qen
0700	64 79 77 65 69 63 6f 6f 6c 3f 45 9c 94 85 03 bc 00 a8 17 13 17 04 71 65 6e 64 79 77 65 69 6b 73	dyweicool?E...........qendyweiks
0720	6a 64 6b 45 9c 94 82 03 bc 00 8f 17 13 19 04 71 65 6e 64 79 77 65 69 68 61 68 61 68 61 45 9c 94	jdkE...........qendyweihahahaE..
0740	30 03 bc 00 75 17 13 15 04 71 65 6e 64 79 77 65 69 73 64 61 64 45 9c 94 2b 03 bc 00 5d 17 13 11	0...u....qendyweisdadE..+...]...
0760	04 71 65 6e 64 79 77 65 69 6b 6a 45 9c 94 29 03 bc 00 47 17 13 13 04 71 65 6e 64 79 77 65 69 68	.qendyweikjE..)...G....qendyweih
0780	6d 6d 45 9c 94 20 03 bc 00 30 17 13 1d 04 71 65 6e 64 03 bc 00 24 17 13 2d 04 51 69 61 6e 67 77	mmE......0....qend...$..-.Qiangw
07a0	65 69 54 65 73 74 69 6e 67 20 31 20 32 20 33 2e 2e 2e 45 9c 9b 85 9c 94 87 30 94 2b 00 00 00 42	eiTesting.1.2.3...E......0.+...B
07c0	17 13 11 04 71 65 6e 64 79 77 00 00 00 1b 17 17 17 04 51 69 61 6e 67 51 69 61 6e 67 00 00 00 22	....qendyw........QiangQiang..."
07e0	13 00 00 00 1d 15 15 1f 04 74 65 73 74 74 65 73 74 6d 61 75 61 68 61 68 61 68 45 9c df 0a 94 00	.........testtestmauahahahE.....
0800	0d 00 00 00 01 03 f3 00 03 f3 03 d9 03 d9 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 27 04 74 65	............................'.te
0be0	73 74 45 9c df 06 00 00 00 1a 04 51 69 61 6e 67 45 9c 9b 0b 03 03 15 04 74 65 73 74 45 9c df 0a	stE........QiangE.......testE...
0c00	0a 03 ee 00 01 03 e5 00 03 e5 03 e5 03 f8 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 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00	................................
0fe0	00 00 00 00 00 08 03 15 01 74 65 73 74 03 00 00 00 12 51 69 61 6e 67 02 00 00 00 08 77 65 69 01	.........test.....Qiang.....wei.