xophoto/mainline - mainline

blob: 9da66f5d16a5a8cdf1dcc7e4ab21b2d01986dcfd (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 33 00 00 00 00	SQLite.format.3......@.....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 02	................................
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 00 00 00 04 00 8d 00 02 da 01 6f 00 df 00 8d 00 00 00 00 00 00 00 00 00 00 00 00	...............o................
0080	00 00 00 00 00 00 00 00 00 00 00 00 00 50 04 06 17 2b 2b 01 59 74 61 62 6c 65 73 71 6c 69 74 65	.............P...++.Ytablesqlite
00a0	5f 73 65 71 75 65 6e 63 65 73 71 6c 69 74 65 5f 73 65 71 75 65 6e 63 65 05 43 52 45 41 54 45 20	_sequencesqlite_sequence.CREATE.
00c0	54 41 42 4c 45 20 73 71 6c 69 74 65 5f 73 65 71 75 65 6e 63 65 28 6e 61 6d 65 2c 73 65 71 29 81	TABLE.sqlite_sequence(name,seq).
00e0	0d 03 07 17 19 19 01 81 75 74 61 62 6c 65 6c 6f 6f 6b 75 70 6c 6f 6f 6b 75 70 04 43 52 45 41 54	........utablelookuplookup.CREAT
0100	45 20 54 41 42 4c 45 20 22 6c 6f 6f 6b 75 70 22 20 28 22 69 64 22 20 49 4e 54 45 47 45 52 20 50	E.TABLE."lookup".("id".INTEGER.P
0120	52 49 4d 41 52 59 20 4b 45 59 20 20 41 55 54 4f 49 4e 43 52 45 4d 45 4e 54 20 20 4e 4f 54 20 4e	RIMARY.KEY..AUTOINCREMENT..NOT.N
0140	55 4c 4c 20 2c 20 22 6e 61 6d 65 22 20 54 45 58 54 2c 20 22 76 61 6c 75 65 22 20 54 45 58 54 2c	ULL.,."name".TEXT,."value".TEXT,
0160	20 22 73 74 61 74 75 73 22 20 54 45 58 54 29 82 68 02 07 17 1b 1b 01 85 27 74 61 62 6c 65 70 69	."status".TEXT).h.......'tablepi
0180	63 74 75 72 65 70 69 63 74 75 72 65 03 43 52 45 41 54 45 20 54 41 42 4c 45 20 22 70 69 63 74 75	cturepicture.CREATE.TABLE."pictu
01a0	72 65 22 20 28 22 6a 6f 62 6a 65 63 74 5f 69 64 22 20 54 45 58 54 20 4e 4f 54 20 4e 55 4c 4c 20	re".("jobject_id".TEXT.NOT.NULL.
01c0	2c 22 6d 6f 75 6e 74 5f 70 6f 69 6e 74 22 20 54 45 58 54 2c 22 6f 72 69 67 5f 77 69 64 74 68 22	,"mount_point".TEXT,"orig_width"
01e0	20 49 4e 54 45 47 45 52 2c 22 6f 72 69 67 5f 68 65 69 67 68 74 22 20 49 4e 54 45 47 45 52 2c 22	.INTEGER,"orig_height".INTEGER,"
0200	6d 69 6d 65 5f 74 79 70 65 22 20 54 45 58 54 2c 22 63 72 65 61 74 65 5f 64 61 74 65 22 20 44 41	mime_type".TEXT,"create_date".DA
0220	54 45 54 49 4d 45 2c 22 74 69 74 6c 65 22 20 54 45 58 54 2c 22 63 6f 6d 6d 65 6e 74 22 20 54 45	TETIME,"title".TEXT,"comment".TE
0240	58 54 2c 22 69 64 22 20 49 4e 54 45 47 45 52 20 50 52 49 4d 41 52 59 20 4b 45 59 20 20 4e 4f 54	XT,"id".INTEGER.PRIMARY.KEY..NOT
0260	20 4e 55 4c 4c 20 2c 22 73 65 71 22 20 49 4e 54 45 47 45 52 2c 22 6f 72 69 67 5f 73 69 7a 65 22	.NULL.,"seq".INTEGER,"orig_size"
0280	20 44 4f 55 42 4c 45 2c 22 61 6c 62 75 6d 22 20 54 45 58 54 2c 22 69 6e 5f 64 73 22 20 49 4e 54	.DOUBLE,"album".TEXT,"in_ds".INT
02a0	45 47 45 52 2c 20 22 6d 64 35 5f 73 75 6d 22 20 54 45 58 54 2c 20 22 6c 61 74 69 74 75 64 65 22	EGER,."md5_sum".TEXT,."latitude"
02c0	20 66 6c 6f 61 74 2c 20 22 6c 6f 6e 67 69 74 75 64 65 22 20 66 6c 6f 61 74 29 82 23 01 07 17 21	.float,."longitude".float).#...!
02e0	21 01 84 11 74 61 62 6c 65 74 72 61 6e 73 66 6f 72 6d 73 74 72 61 6e 73 66 6f 72 6d 73 02 43 52	!...tabletransformstransforms.CR
0300	45 41 54 45 20 54 41 42 4c 45 20 22 74 72 61 6e 73 66 6f 72 6d 73 22 20 28 22 69 64 22 20 49 4e	EATE.TABLE."transforms".("id".IN
0320	54 45 47 45 52 20 50 52 49 4d 41 52 59 20 4b 45 59 20 20 4e 4f 54 20 4e 55 4c 4c 20 2c 22 6a 6f	TEGER.PRIMARY.KEY..NOT.NULL.,"jo
0340	62 6a 65 63 74 5f 69 64 22 20 54 45 58 54 2c 22 6f 72 69 67 69 6e 61 6c 5f 78 22 20 49 4e 54 45	bject_id".TEXT,"original_x".INTE
0360	47 45 52 2c 22 6f 72 69 67 69 6e 61 6c 5f 79 22 20 49 4e 54 45 47 45 52 2c 22 73 63 61 6c 65 64	GER,"original_y".INTEGER,"scaled
0380	5f 78 22 20 49 4e 54 45 47 45 52 2c 22 73 63 61 6c 65 64 5f 79 22 20 49 4e 54 45 47 45 52 2c 22	_x".INTEGER,"scaled_y".INTEGER,"
03a0	74 68 75 6d 62 22 20 62 6c 6f 62 2c 20 22 74 72 61 6e 73 66 6f 72 6d 5f 74 79 70 65 22 20 54 45	thumb".blob,."transform_type".TE
03c0	58 54 2c 20 22 72 6f 74 61 74 65 5f 6c 65 66 74 22 20 49 4e 54 45 47 45 52 2c 20 22 74 72 61 6e	XT,."rotate_left".INTEGER,."tran
03e0	73 66 6f 72 6d 5f 73 70 65 63 22 20 54 45 58 54 2c 20 22 73 65 71 22 20 49 4e 54 45 47 45 52 29	sform_spec".TEXT,."seq".INTEGER)
0400	0d 00 00 00 00 04 00 00 00 00 00 00 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	................................