Maximum CD 2011 January

home *** CD-ROM | disk | FTP | other *** search
/ Maximum CD 2011 January / maximum-cd-2011-01.iso / DiscContents / calibre-0.7.26.msi / file_1409 < prev next >
Unknown | 2010-10-31 | 25.9 KB
open in:
MacOS 8.1 |
Win98 |
DOS
view JSON data |
view as text

This file was not able to be converted.
This format is not currently supported by dexvert.
Confidence	Program	Detection	Match Type	Support
`100%`	dexvert	Python Compiled Bytecode `(document/pythonCompiled)`	magic	Supported
`100%`	file	python 2.6 byte-compiled	default
`99%`	file	data	default
`57%`	TrID	CPython 2.6 bytecode	default
`42%`	TrID	Python optimized code	default
`100%`	siegfried	fmt/1112 Python Compiled File (2.6)	default
`100%`	detectItEasy	Format: Python Compiled Module(2.6a1)	default
hex view
+--------+-------------------------+-------------------------+--------+--------+
|00000000| d1 f2 0d 0a ec b8 a4 4c | 63 00 00 00 00 00 00 00 |.......L|c.......|
|00000010| 00 0c 00 00 00 40 80 00 | 00 73 b4 00 00 00 64 00 |.....@..|.s....d.|
|00000020| 00 64 01 00 6b 00 00 6c | 01 00 5a 01 00 01 64 02 |.d..k..l|..Z...d.|
|00000030| 00 5a 02 00 64 03 00 5a | 03 00 64 04 00 5a 04 00 |.Z..d..Z|..d..Z..|
|00000040| 64 00 00 64 05 00 6b 05 | 00 5a 05 00 64 00 00 64 |d..d..k.|.Z..d..d|
|00000050| 05 00 6b 06 00 5a 06 00 | 64 00 00 64 06 00 6b 07 |..k..Z..|d..d..k.|
|00000060| 00 6c 08 00 5a 08 00 01 | 64 00 00 64 07 00 6b 09 |.l..Z...|d..d..k.|
|00000070| 00 6c 0a 00 5a 0a 00 01 | 64 00 00 64 08 00 6b 0b |.l..Z...|d..d..k.|
|00000080| 00 6c 0c 00 5a 0c 00 01 | 64 00 00 64 09 00 6b 0d |.l..Z...|d..d..k.|
|00000090| 00 6c 0e 00 5a 0e 00 01 | 64 00 00 64 0a 00 6b 0f |.l..Z...|d..d..k.|
|000000a0| 00 6c 10 00 5a 10 00 01 | 64 00 00 64 0b 00 6b 11 |.l..Z...|d..d..k.|
|000000b0| 00 6c 12 00 5a 12 00 01 | 64 0c 00 65 13 00 66 01 |.l..Z...|d..e..f.|
|000000c0| 00 64 0d 00 84 00 00 83 | 00 00 59 5a 14 00 64 05 |.d......|..YZ..d.|
|000000d0| 00 53 28 0e 00 00 00 69 | ff ff ff ff 28 01 00 00 |.S(....i|....(...|
|000000e0| 00 74 0e 00 00 00 77 69 | 74 68 5f 73 74 61 74 65 |.t....wi|th_state|
|000000f0| 6d 65 6e 74 73 06 00 00 | 00 47 50 4c 20 76 33 73 |ments...|.GPL v3s|
|00000100| 28 00 00 00 32 30 31 30 | 2c 20 4b 6f 76 69 64 20 |(...2010|, Kovid |
|00000110| 47 6f 79 61 6c 20 3c 6b | 6f 76 69 64 40 6b 6f 76 |Goyal <k|ovid@kov|
|00000120| 69 64 67 6f 79 61 6c 2e | 6e 65 74 3e 73 13 00 00 |idgoyal.|net>s...|
|00000130| 00 72 65 73 74 72 75 63 | 74 75 72 65 64 74 65 78 |.restruc|turedtex|
|00000140| 74 20 65 6e 4e 28 01 00 | 00 00 74 07 00 00 00 70 |t enN(..|..t....p|
|00000150| 61 72 74 69 61 6c 28 01 | 00 00 00 74 05 00 00 00 |artial(.|...t....|
|00000160| 66 6c 6f 6f 72 28 01 00 | 00 00 74 06 00 00 00 70 |floor(..|..t....p|
|00000170| 72 69 6e 74 73 28 01 00 | 00 00 74 12 00 00 00 70 |rints(..|..t....p|
|00000180| 72 65 66 65 72 72 65 64 | 5f 65 6e 63 6f 64 69 6e |referred|_encodin|
|00000190| 67 28 01 00 00 00 74 0d | 00 00 00 46 69 65 6c 64 |g(....t.|...Field|
|000001a0| 4d 65 74 61 64 61 74 61 | 28 01 00 00 00 74 0a 00 |Metadata|(....t..|
|000001b0| 00 00 70 61 72 73 65 5f | 64 61 74 65 74 0d 00 00 |..parse_|datet...|
|000001c0| 00 43 75 73 74 6f 6d 43 | 6f 6c 75 6d 6e 73 63 00 |.CustomC|olumnsc.|
|000001d0| 00 00 00 00 00 00 00 0a | 00 00 00 42 80 00 00 73 |........|...B...s|
|000001e0| 67 01 00 00 65 00 00 5a | 01 00 65 02 00 64 00 00 |g...e..Z|..e..d..|
|000001f0| 64 01 00 64 02 00 64 03 | 00 64 04 00 64 05 00 64 |d..d..d.|.d..d..d|
|00000200| 06 00 64 07 00 64 08 00 | 67 09 00 83 01 00 5a 03 |..d..d..|g.....Z.|
|00000210| 00 64 09 00 84 00 00 5a | 04 00 65 05 00 64 0a 00 |.d.....Z|..e..d..|
|00000220| 84 00 00 83 01 00 5a 06 | 00 64 0b 00 84 00 00 5a |......Z.|.d.....Z|
|00000230| 07 00 64 1c 00 64 1c 00 | 65 09 00 64 0c 00 84 03 |..d..d..|e..d....|
|00000240| 00 5a 0a 00 64 1c 00 64 | 1c 00 65 09 00 64 0d 00 |.Z..d..d|..e..d..|
|00000250| 84 03 00 5a 0b 00 64 1c | 00 64 1c 00 64 0e 00 84 |...Z..d.|.d..d...|
|00000260| 02 00 5a 0c 00 64 1c 00 | 64 1c 00 64 0f 00 84 02 |..Z..d..|d..d....|
|00000270| 00 5a 0d 00 64 1c 00 64 | 1c 00 64 10 00 84 02 00 |.Z..d..d|..d.....|
|00000280| 5a 0e 00 64 1c 00 64 1c | 00 64 11 00 84 02 00 5a |Z..d..d.|.d.....Z|
|00000290| 0f 00 64 1c 00 64 1c 00 | 64 12 00 84 02 00 5a 10 |..d..d..|d.....Z.|
|000002a0| 00 64 1c 00 64 1c 00 64 | 13 00 84 02 00 5a 11 00 |.d..d..d|.....Z..|
|000002b0| 64 1c 00 64 1c 00 64 1c | 00 64 1c 00 64 14 00 84 |d..d..d.|.d..d...|
|000002c0| 04 00 5a 12 00 67 00 00 | 67 00 00 64 1c 00 64 1c |..Z..g..|g..d..d.|
|000002d0| 00 65 09 00 64 15 00 84 | 05 00 5a 13 00 64 1c 00 |.e..d...|..Z..d..|
|000002e0| 64 1c 00 65 09 00 65 14 | 00 64 1c 00 64 16 00 84 |d..e..e.|.d..d...|
|000002f0| 05 00 5a 15 00 64 1c 00 | 64 1c 00 65 09 00 65 14 |..Z..d..|d..e..e.|
|00000300| 00 64 1c 00 65 14 00 64 | 17 00 84 06 00 5a 16 00 |.d..e..d|.....Z..|
|00000310| 64 1c 00 64 1c 00 65 09 | 00 65 14 00 64 1c 00 64 |d..d..e.|.e..d..d|
|00000320| 18 00 84 05 00 5a 17 00 | 64 19 00 84 00 00 5a 18 |.....Z..|d.....Z.|
|00000330| 00 64 1a 00 84 00 00 5a | 19 00 65 14 00 68 00 00 |.d.....Z|..e..h..|
|00000340| 64 1b 00 84 02 00 5a 1a | 00 52 53 28 1d 00 00 00 |d.....Z.|.RS(....|
|00000350| 74 06 00 00 00 72 61 74 | 69 6e 67 74 04 00 00 00 |t....rat|ingt....|
|00000360| 74 65 78 74 74 08 00 00 | 00 63 6f 6d 6d 65 6e 74 |textt...|.comment|
|00000370| 73 74 08 00 00 00 64 61 | 74 65 74 69 6d 65 74 03 |st....da|tetimet.|
|00000380| 00 00 00 69 6e 74 74 05 | 00 00 00 66 6c 6f 61 74 |...intt.|...float|
|00000390| 74 04 00 00 00 62 6f 6f | 6c 74 06 00 00 00 73 65 |t....boo|lt....se|
|000003a0| 72 69 65 73 74 09 00 00 | 00 63 6f 6d 70 6f 73 69 |riest...|.composi|
|000003b0| 74 65 63 02 00 00 00 02 | 00 00 00 03 00 00 00 43 |tec.....|.......C|
|000003c0| 80 00 00 73 12 00 00 00 | 64 01 00 7c 01 00 16 64 |...s....|d..|...d|
|000003d0| 02 00 7c 01 00 16 66 02 | 00 53 28 03 00 00 00 4e |..|...f.|.S(....N|
|000003e0| 73 10 00 00 00 63 75 73 | 74 6f 6d 5f 63 6f 6c 75 |s....cus|tom_colu|
|000003f0| 6d 6e 5f 25 64 73 1b 00 | 00 00 62 6f 6f 6b 73 5f |mn_%ds..|..books_|
|00000400| 63 75 73 74 6f 6d 5f 63 | 6f 6c 75 6d 6e 5f 25 64 |custom_c|olumn_%d|
|00000410| 5f 6c 69 6e 6b 28 00 00 | 00 00 28 02 00 00 00 74 |_link(..|..(....t|
|00000420| 04 00 00 00 73 65 6c 66 | 74 03 00 00 00 6e 75 6d |....self|t....num|
|00000430| 28 00 00 00 00 28 00 00 | 00 00 73 2f 00 00 00 73 |(....(..|..s/...s|
|00000440| 69 74 65 2d 70 61 63 6b | 61 67 65 73 5c 63 61 6c |ite-pack|ages\cal|
|00000450| 69 62 72 65 5c 6c 69 62 | 72 61 72 79 5c 63 75 73 |ibre\lib|rary\cus|
|00000460| 74 6f 6d 5f 63 6f 6c 75 | 6d 6e 73 2e 70 79 74 12 |tom_colu|mns.pyt.|
|00000470| 00 00 00 63 75 73 74 6f | 6d 5f 74 61 62 6c 65 5f |...custo|m_table_|
|00000480| 6e 61 6d 65 73 17 00 00 | 00 73 02 00 00 00 00 01 |names...|.s......|
|00000490| 63 01 00 00 00 03 00 00 | 00 06 00 00 00 43 80 00 |c.......|.....C..|
|000004a0| 00 73 35 00 00 00 74 00 | 00 67 00 00 04 7d 01 00 |.s5...t.|.g...}..|
|000004b0| 7c 00 00 69 01 00 69 02 | 00 64 01 00 83 01 00 44 ||..i..i.|.d.....D|
|000004c0| 5d 11 00 7d 02 00 7c 01 | 00 7c 02 00 64 02 00 19 |]..}..|.|.|..d...|
|000004d0| 12 71 1a 00 7e 01 00 83 | 01 00 53 28 03 00 00 00 |.q..~...|..S(....|
|000004e0| 4e 73 78 00 00 00 53 45 | 4c 45 43 54 20 6e 61 6d |Nsx...SE|LECT nam|
|000004f0| 65 20 46 52 4f 4d 20 73 | 71 6c 69 74 65 5f 6d 61 |e FROM s|qlite_ma|
|00000500| 73 74 65 72 20 57 48 45 | 52 45 20 74 79 70 65 3d |ster WHE|RE type=|
|00000510| 22 74 61 62 6c 65 22 20 | 41 4e 44 20 28 6e 61 6d |"table" |AND (nam|
|00000520| 65 20 47 4c 4f 42 20 22 | 63 75 73 74 6f 6d 5f 63 |e GLOB "|custom_c|
|00000530| 6f 6c 75 6d 6e 5f 2a 22 | 20 4f 52 20 6e 61 6d 65 |olumn_*"| OR name|
|00000540| 20 47 4c 4f 42 20 22 62 | 6f 6f 6b 73 5f 63 75 73 | GLOB "b|ooks_cus|
|00000550| 74 6f 6d 5f 63 6f 6c 75 | 6d 6e 5f 2a 22 29 69 00 |tom_colu|mn_*")i.|
|00000560| 00 00 00 28 03 00 00 00 | 74 03 00 00 00 73 65 74 |...(....|t....set|
|00000570| 74 04 00 00 00 63 6f 6e | 6e 74 03 00 00 00 67 65 |t....con|nt....ge|
|00000580| 74 28 03 00 00 00 52 11 | 00 00 00 74 04 00 00 00 |t(....R.|...t....|
|00000590| 5f 5b 31 5d 74 01 00 00 | 00 78 28 00 00 00 00 28 |_[1]t...|.x(....(|
|000005a0| 00 00 00 00 73 2f 00 00 | 00 73 69 74 65 2d 70 61 |....s/..|.site-pa|
|000005b0| 63 6b 61 67 65 73 5c 63 | 61 6c 69 62 72 65 5c 6c |ckages\c|alibre\l|
|000005c0| 69 62 72 61 72 79 5c 63 | 75 73 74 6f 6d 5f 63 6f |ibrary\c|ustom_co|
|000005d0| 6c 75 6d 6e 73 2e 70 79 | 74 0d 00 00 00 63 75 73 |lumns.py|t....cus|
|000005e0| 74 6f 6d 5f 74 61 62 6c | 65 73 1a 00 00 00 73 04 |tom_tabl|es....s.|
|000005f0| 00 00 00 00 02 13 01 63 | 01 00 00 00 11 00 00 00 |.......c|........|
|00000600| 1e 00 00 00 03 80 00 00 | 73 de 03 00 00 74 00 00 |........|s....t..|
|00000610| 7c 00 00 69 01 00 74 02 | 00 69 03 00 18 83 01 00 ||..i..t.|.i......|
|00000620| 64 01 00 6a 04 00 6f 10 | 00 01 74 04 00 64 02 00 |d..j..o.|..t..d..|
|00000630| 83 01 00 82 01 00 6e 01 | 00 01 78 5b 00 7c 00 00 |......n.|..x[.|..|
|00000640| 69 05 00 69 06 00 64 03 | 00 83 01 00 44 5d 47 00 |i..i..d.|....D]G.|
|00000650| 7d 01 00 7c 01 00 64 01 | 00 19 7d 02 00 7c 00 00 |}..|..d.|..}..|..|
|00000660| 69 07 00 7c 02 00 83 01 | 00 5c 02 00 7d 03 00 7d |i..|....|.\..}..}|
|00000670| 04 00 7c 00 00 69 05 00 | 69 08 00 64 04 00 69 09 |..|..i..|i..d..i.|
|00000680| 00 64 05 00 7c 03 00 64 | 06 00 7c 04 00 83 00 02 |.d..|..d|..|.....|
|00000690| 83 01 00 01 71 40 00 57 | 7c 00 00 69 05 00 69 0a |....q@.W||..i..i.|
|000006a0| 00 64 07 00 83 01 00 01 | 7c 00 00 69 05 00 69 0b |.d......||..i..i.|
|000006b0| 00 83 00 00 01 68 00 00 | 68 00 00 02 7c 00 00 5f |.....h..|h...|.._|
|000006c0| 0c 00 7c 00 00 5f 0d 00 | 67 00 00 7d 05 00 67 00 |..|.._..|g..}..g.|
|000006d0| 00 7d 06 00 7c 00 00 69 | 0e 00 7d 07 00 78 38 01 |.}..|..i|..}..x8.|
|000006e0| 7c 00 00 69 05 00 69 06 | 00 64 08 00 83 01 00 44 ||..i..i.|.d.....D|
|000006f0| 5d 24 01 7d 01 00 68 08 | 00 7c 01 00 64 01 00 19 |]$.}..h.|.|..d...|
|00000700| 64 09 00 36 7c 01 00 64 | 0a 00 19 64 0b 00 36 7c |d..6|..d|...d..6||
|00000710| 01 00 64 0c 00 19 64 0d | 00 36 7c 01 00 64 0e 00 |..d...d.|.6|..d..|
|00000720| 19 64 0f 00 36 74 0f 00 | 69 10 00 7c 01 00 64 10 |.d..6t..|i..|..d.|
|00000730| 00 19 83 01 00 64 11 00 | 36 7c 01 00 64 12 00 19 |.....d..|6|..d...|
|00000740| 64 13 00 36 7c 01 00 64 | 14 00 19 64 15 00 36 7c |d..6|..d|...d..6||
|00000750| 01 00 64 16 00 19 64 17 | 00 36 7d 08 00 7c 00 00 |..d...d.|.6}..|..|
|00000760| 69 07 00 7c 08 00 64 15 | 00 19 83 01 00 5c 02 00 |i..|..d.|.....\..|
|00000770| 7d 03 00 7d 04 00 7c 03 | 00 7c 07 00 6a 07 00 70 |}..}..|.|.|..j..p|
|00000780| 18 00 01 7c 08 00 64 13 | 00 19 6f 21 00 01 7c 04 |...|..d.|..o!..|.|
|00000790| 00 7c 07 00 6a 07 00 6f | 14 00 01 7c 06 00 69 11 |.|..j..o|...|..i.|
|000007a0| 00 7c 08 00 83 01 00 01 | 71 e3 00 6e 01 00 01 7c |.|......|q..n...||
|000007b0| 08 00 64 15 00 19 7c 00 | 00 69 0c 00 7c 08 00 64 |..d...|.|.i..|..d|
|000007c0| 09 00 19 3c 7c 08 00 04 | 7c 00 00 69 0d 00 7c 08 |...<|...||..i..|.|
|000007d0| 00 64 15 00 19 3c 7c 00 | 00 69 0c 00 7c 08 00 64 |.d...<|.|.i..|..d|
|000007e0| 09 00 19 3c 7c 08 00 64 | 13 00 19 6f 0e 00 01 64 |...<|..d|...o...d|
|000007f0| 18 00 7c 04 00 16 7d 09 | 00 6e 0b 00 01 64 18 00 |..|...}.|.n...d..|
|00000800| 7c 03 00 16 7d 09 00 7c | 05 00 69 11 00 7c 09 00 ||...}..||..i..|..|
|00000810| 83 01 00 01 71 e3 00 57 | 7c 06 00 6f 4e 00 01 78 |....q..W||..oN..x|
|00000820| 3a 00 7c 06 00 44 5d 32 | 00 7d 08 00 74 12 00 64 |:.|..D]2|.}..t..d|
|00000830| 19 00 7c 08 00 64 09 00 | 19 16 83 01 00 01 7c 00 |..|..d..|......|.|
|00000840| 00 69 05 00 69 0a 00 64 | 1a 00 7c 08 00 64 15 00 |.i..i..d|..|..d..|
|00000850| 19 66 01 00 83 02 00 01 | 71 19 02 57 7c 00 00 69 |.f......|q..W|..i|
|00000860| 05 00 69 0b 00 83 00 00 | 01 6e 01 00 01 7c 05 00 |..i.....|.n...|..|
|00000870| 6f 2e 00 01 7c 00 00 69 | 05 00 69 0a 00 64 1b 00 |o...|..i|..i..d..|
|00000880| 64 1c 00 69 13 00 7c 05 | 00 83 01 00 16 83 01 00 |d..i..|.|........|
|00000890| 01 7c 00 00 69 05 00 69 | 0b 00 83 00 00 01 6e 01 |.|..i..i|......n.|
|000008a0| 00 01 64 1d 00 84 00 00 | 89 00 00 64 1e 00 84 00 |..d.....|...d....|
|000008b0| 00 7d 0a 00 64 1f 00 84 | 00 00 7d 0b 00 68 08 00 |.}..d...|..}..h..|
|000008c0| 64 20 00 84 00 00 64 21 | 00 36 64 22 00 84 00 00 |d ....d!|.6d"....|
|000008d0| 64 23 00 36 64 24 00 84 | 00 00 64 25 00 36 7c 0b |d#.6d$..|..d%.6|.|
|000008e0| 00 64 26 00 36 87 00 00 | 66 01 00 64 27 00 86 00 |.d&.6...|f..d'...|
|000008f0| 00 64 28 00 36 7c 0a 00 | 64 29 00 36 88 00 00 64 |.d(.6|..|d).6...d|
|00000900| 2a 00 36 88 00 00 64 2b | 00 36 7c 00 00 5f 14 00 |*.6...d+|.6|.._..|
|00000910| 78 d4 00 74 15 00 7c 00 | 00 69 0c 00 69 16 00 83 |x..t..|.|.i..i...|
|00000920| 00 00 83 01 00 44 5d bd | 00 7d 0c 00 7c 00 00 69 |.....D].|.}..|..i|
|00000930| 0c 00 7c 0c 00 19 7d 0d | 00 7c 0d 00 64 13 00 19 |..|...}.|.|..d...|
|00000940| 6f 0a 00 01 74 17 00 7d | 0e 00 6e 07 00 01 74 18 |o...t..}|..n...t.|
|00000950| 00 7d 0e 00 7c 0d 00 64 | 17 00 19 6f 0a 00 01 64 |.}..|..d|...o...d|
|00000960| 2c 00 7d 0f 00 6e 07 00 | 01 64 00 00 7d 0f 00 64 |,.}..n..|.d..}..d|
|00000970| 2d 00 69 09 00 7c 0d 00 | 64 15 00 19 83 01 00 7d |-.i..|..|d......}|
|00000980| 10 00 7c 00 00 69 1a 00 | 69 1b 00 64 09 00 7c 0d |..|..i..|i..d..|.|
|00000990| 00 64 09 00 19 64 05 00 | 7c 10 00 64 2e 00 64 2f |.d...d..||..d..d/|
|000009a0| 00 64 0d 00 7c 0d 00 64 | 0d 00 19 64 30 00 7c 0d |.d..|..d|...d0.|.|
|000009b0| 00 64 15 00 19 64 0b 00 | 7c 0d 00 64 0b 00 19 64 |.d...d..||..d...d|
|000009c0| 11 00 7c 0d 00 64 11 00 | 19 64 17 00 7c 0f 00 64 |..|..d..|.d..|..d|
|000009d0| 31 00 7c 0e 00 64 32 00 | 7c 0d 00 64 0f 00 19 83 |1.|..d2.||..d....|
|000009e0| 00 0a 01 71 19 03 57 64 | 00 00 53 28 33 00 00 00 |...q..Wd|..S(3...|
|000009f0| 4e 69 00 00 00 00 73 21 | 00 00 00 55 6e 6b 6e 6f |Ni....s!|...Unkno|
|00000a00| 77 6e 20 63 75 73 74 6f | 6d 20 63 6f 6c 75 6d 6e |wn custo|m column|
|00000a10| 20 74 79 70 65 20 69 6e | 20 73 65 74 73 35 00 00 | type in| sets5..|
|00000a20| 00 53 45 4c 45 43 54 20 | 69 64 20 46 52 4f 4d 20 |.SELECT |id FROM |
|00000a30| 63 75 73 74 6f 6d 5f 63 | 6f 6c 75 6d 6e 73 20 57 |custom_c|olumns W|
|00000a40| 48 45 52 45 20 6d 61 72 | 6b 5f 66 6f 72 5f 64 65 |HERE mar|k_for_de|
|00000a50| 6c 65 74 65 3d 31 73 18 | 03 00 00 20 20 20 20 20 |lete=1s.|...     |
|00000a60| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 44 |        |       D|
|00000a70| 52 4f 50 20 49 4e 44 45 | 58 20 20 20 49 46 20 45 |ROP INDE|X   IF E|
|00000a80| 58 49 53 54 53 20 7b 74 | 61 62 6c 65 7d 5f 69 64 |XISTS {t|able}_id|
|00000a90| 78 3b 0a 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |x;.     |        |
|00000aa0| 20 20 20 20 20 20 20 44 | 52 4f 50 20 49 4e 44 45 |       D|ROP INDE|
|00000ab0| 58 20 20 20 49 46 20 45 | 58 49 53 54 53 20 7b 6c |X   IF E|XISTS {l|
|00000ac0| 74 7d 5f 61 69 64 78 3b | 0a 20 20 20 20 20 20 20 |t}_aidx;|.       |
|00000ad0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 44 52 4f |        |     DRO|
|00000ae0| 50 20 49 4e 44 45 58 20 | 20 20 49 46 20 45 58 49 |P INDEX |  IF EXI|
|00000af0| 53 54 53 20 7b 6c 74 7d | 5f 62 69 64 78 3b 0a 20 |STS {lt}|_bidx;. |
|00000b00| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |        |        |
|00000b10| 20 20 20 44 52 4f 50 20 | 54 52 49 47 47 45 52 20 |   DROP |TRIGGER |
|00000b20| 49 46 20 45 58 49 53 54 | 53 20 66 6b 63 5f 75 70 |IF EXIST|S fkc_up|
|00000b30| 64 61 74 65 5f 7b 6c 74 | 7d 5f 61 3b 0a 20 20 20 |date_{lt|}_a;.   |
|00000b40| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |        |        |
|00000b50| 20 44 52 4f 50 20 54 52 | 49 47 47 45 52 20 49 46 | DROP TR|IGGER IF|
|00000b60| 20 45 58 49 53 54 53 20 | 66 6b 63 5f 75 70 64 61 | EXISTS |fkc_upda|
|00000b70| 74 65 5f 7b 6c 74 7d 5f | 62 3b 0a 20 20 20 20 20 |te_{lt}_|b;.     |
|00000b80| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 44 |        |       D|
|00000b90| 52 4f 50 20 54 52 49 47 | 47 45 52 20 49 46 20 45 |ROP TRIG|GER IF E|
|00000ba0| 58 49 53 54 53 20 66 6b | 63 5f 69 6e 73 65 72 74 |XISTS fk|c_insert|
|00000bb0| 5f 7b 6c 74 7d 3b 0a 20 | 20 20 20 20 20 20 20 20 |_{lt};. |        |
|00000bc0| 20 20 20 20 20 20 20 20 | 20 20 20 44 52 4f 50 20 |        |   DROP |
|00000bd0| 54 52 49 47 47 45 52 20 | 49 46 20 45 58 49 53 54 |TRIGGER |IF EXIST|
|00000be0| 53 20 66 6b 63 5f 64 65 | 6c 65 74 65 5f 7b 6c 74 |S fkc_de|lete_{lt|
|00000bf0| 7d 3b 0a 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |};.     |        |
|00000c00| 20 20 20 20 20 20 20 44 | 52 4f 50 20 54 52 49 47 |       D|ROP TRIG|
|00000c10| 47 45 52 20 49 46 20 45 | 58 49 53 54 53 20 66 6b |GER IF E|XISTS fk|
|00000c20| 63 5f 69 6e 73 65 72 74 | 5f 7b 74 61 62 6c 65 7d |c_insert|_{table}|
|00000c30| 3b 0a 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |;.      |        |
|00000c40| 20 20 20 20 20 20 44 52 | 4f 50 20 54 52 49 47 47 |      DR|OP TRIGG|
|00000c50| 45 52 20 49 46 20 45 58 | 49 53 54 53 20 66 6b 63 |ER IF EX|ISTS fkc|
|00000c60| 5f 64 65 6c 65 74 65 5f | 7b 74 61 62 6c 65 7d 3b |_delete_|{table};|
|00000c70| 0a 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |.       |        |
|00000c80| 20 20 20 20 20 44 52 4f | 50 20 56 49 45 57 20 20 |     DRO|P VIEW  |
|00000c90| 20 20 49 46 20 45 58 49 | 53 54 53 20 74 61 67 5f |  IF EXI|STS tag_|
|00000ca0| 62 72 6f 77 73 65 72 5f | 7b 74 61 62 6c 65 7d 3b |browser_|{table};|
|00000cb0| 0a 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |.       |        |
|00000cc0| 20 20 20 20 20 44 52 4f | 50 20 56 49 45 57 20 20 |     DRO|P VIEW  |
|00000cd0| 20 20 49 46 20 45 58 49 | 53 54 53 20 74 61 67 5f |  IF EXI|STS tag_|
|00000ce0| 62 72 6f 77 73 65 72 5f | 66 69 6c 74 65 72 65 64 |browser_|filtered|
|00000cf0| 5f 7b 74 61 62 6c 65 7d | 3b 0a 20 20 20 20 20 20 |_{table}|;.      |
|00000d00| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 44 52 |        |      DR|
|00000d10| 4f 50 20 54 41 42 4c 45 | 20 20 20 49 46 20 45 58 |OP TABLE|   IF EX|
|00000d20| 49 53 54 53 20 7b 74 61 | 62 6c 65 7d 3b 0a 20 20 |ISTS {ta|ble};.  |
|00000d30| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |        |        |
|00000d40| 20 20 44 52 4f 50 20 54 | 41 42 4c 45 20 20 20 49 |  DROP T|ABLE   I|
|00000d50| 46 20 45 58 49 53 54 53 | 20 7b 6c 74 7d 3b 0a 20 |F EXISTS| {lt};. |
|00000d60| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |        |        |
|00000d70| 20 20 20 74 05 00 00 00 | 74 61 62 6c 65 74 02 00 |   t....|tablet..|
|00000d80| 00 00 6c 74 73 32 00 00 | 00 44 45 4c 45 54 45 20 |..lts2..|.DELETE |
|00000d90| 46 52 4f 4d 20 63 75 73 | 74 6f 6d 5f 63 6f 6c 75 |FROM cus|tom_colu|
|00000da0| 6d 6e 73 20 57 48 45 52 | 45 20 6d 61 72 6b 5f 66 |mns WHER|E mark_f|
|00000db0| 6f 72 5f 64 65 6c 65 74 | 65 3d 31 73 59 00 00 00 |or_delet|e=1sY...|
|00000dc0| 53 45 4c 45 43 54 20 6c | 61 62 65 6c 2c 6e 61 6d |SELECT l|abel,nam|
|00000dd0| 65 2c 64 61 74 61 74 79 | 70 65 2c 65 64 69 74 61 |e,dataty|pe,edita|
|00000de0| 62 6c 65 2c 64 69 73 70 | 6c 61 79 2c 6e 6f 72 6d |ble,disp|lay,norm|
|00000df0| 61 6c 69 7a 65 64 2c 69 | 64 2c 69 73 5f 6d 75 6c |alized,i|d,is_mul|
|00000e00| 74 69 70 6c 65 20 46 52 | 4f 4d 20 63 75 73 74 6f |tiple FR|OM custo|
|00000e10| 6d 5f 63 6f 6c 75 6d 6e | 73 74 05 00 00 00 6c 61 |m_column|st....la|
|00000e20| 62 65 6c 69 01 00 00 00 | 74 04 00 00 00 6e 61 6d |beli....|t....nam|
|00000e30| 65 69 02 00 00 00 74 08 | 00 00 00 64 61 74 61 74 |ei....t.|...datat|
|00000e40| 79 70 65 69 03 00 00 00 | 74 08 00 00 00 65 64 69 |ypei....|t....edi|
|00000e50| 74 61 62 6c 65 69 04 00 | 00 00 74 07 00 00 00 64 |tablei..|..t....d|
|00000e60| 69 73 70 6c 61 79 69 05 | 00 00 00 74 0a 00 00 00 |isplayi.|...t....|
|00000e70| 6e 6f 72 6d 61 6c 69 7a | 65 64 69 06 00 00 00 52 |normaliz|edi....R|
|00000e80| 12 00 00 00 69 07 00 00 | 00 74 0b 00 00 00 69 73 |....i...|.t....is|
|00000e90| 5f 6d 75 6c 74 69 70 6c | 65 73 21 00 00 00 44 45 |_multipl|es!...DE|
|00000ea0| 4c 45 54 45 20 46 52 4f | 4d 20 25 73 20 57 48 45 |LETE FRO|M %s WHE|
|00000eb0| 52 45 20 62 6f 6f 6b 3d | 4f 4c 44 2e 69 64 3b 73 |RE book=|OLD.id;s|
|00000ec0| 2e 00 00 00 57 41 52 4e | 49 4e 47 3a 20 43 75 73 |....WARN|ING: Cus|
|00000ed0| 74 6f 6d 20 63 6f 6c 75 | 6d 6e 20 25 72 20 6e 6f |tom colu|mn %r no|
|00000ee0| 74 20 66 6f 75 6e 64 2c | 20 72 65 6d 6f 76 69 6e |t found,| removin|
|00000ef0| 67 2e 73 25 00 00 00 44 | 45 4c 45 54 45 20 46 52 |g.s%...D|ELETE FR|
|00000f00| 4f 4d 20 63 75 73 74 6f | 6d 5f 63 6f 6c 75 6d 6e |OM custo|m_column|
|00000f10| 73 20 57 48 45 52 45 20 | 69 64 3d 3f 73 c0 00 00 |s WHERE |id=?s...|
|00000f20| 00 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |.       |        |
|00000f30| 20 43 52 45 41 54 45 20 | 54 45 4d 50 20 54 52 49 | CREATE |TEMP TRI|
|00000f40| 47 47 45 52 20 63 75 73 | 74 6f 6d 5f 62 6f 6f 6b |GGER cus|tom_book|
|00000f50| 73 5f 64 65 6c 65 74 65 | 5f 74 72 67 0a 20 20 20 |s_delete|_trg.   |
|00000f60| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |        |        |
|00000f70| 20 41 46 54 45 52 20 44 | 45 4c 45 54 45 20 4f 4e | AFTER D|ELETE ON|
|00000f80| 20 62 6f 6f 6b 73 0a 20 | 20 20 20 20 20 20 20 20 | books. |        |
|00000f90| 20 20 20 20 20 20 20 20 | 20 20 20 42 45 47 49 4e |        |   BEGIN|
|00000fa0| 0a 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |.       |        |
|00000fb0| 20 20 20 20 20 25 73 0a | 20 20 20 20 20 20 20 20 |     %s.|        |
|00000fc0| 20 20 20 20 20 20 20 20 | 20 20 20 20 45 4e 44 3b |        |    END;|
|00000fd0| 0a 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |.       |        |
|00000fe0| 20 73 02 00 00 00 20 0a | 63 02 00 00 00 06 00 00 | s.... .|c.......|
|00000ff0| 00 09 00 00 00 53 80 00 | 00 73 2a 01 00 00 7c 01 |.....S..|.s*...|.|
|00001000| 00 64 01 00 19 6f e9 00 | 01 7c 00 00 64 00 00 6a |.d...o..|.|..d..j|
|00001010| 08 00 6f 05 00 01 67 00 | 00 53 01 74 01 00 7c 00 |..o...g.|.S.t..|.|
|00001020| 00 74 02 00 74 03 00 74 | 04 00 66 03 00 83 02 00 |.t..t..t|..f.....|
|00001030| 6f 13 00 01 7c 00 00 69 | 05 00 64 02 00 83 01 00 |o...|..i|..d.....|
|00001040| 7d 00 00 6e 01 00 01 67 | 00 00 04 7d 02 00 7c 00 |}..n...g|...}..|.|
|00001050| 00 44 5d 24 00 7d 03 00 | 7c 03 00 69 06 00 83 00 |.D]$.}..||..i....|
|00001060| 00 6f 11 00 01 7c 02 00 | 7c 03 00 69 06 00 83 00 |.o...|..||..i....|
|00001070| 00 12 71 54 00 01 71 54 | 00 7e 02 00 7d 00 00 67 |..qT..qT|.~..}..g|
|00001080| 00 00 04 7d 04 00 7c 00 | 00 44 5d 30 00 7d 03 00 |...}..|.|.D]0.}..|
|00001090| 7c 04 00 74 01 00 7c 03 | 00 74 03 00 83 02 00 70 ||..t..|.|.t.....p|
|000010a0| 13 00 01 7c 03 00 69 07 | 00 74 08 00 64 03 00 83 |...|..i.|.t..d...|
|000010b0| 02 00 6e 04 00 01 7c 03 | 00 12 71 8c 00 7e 04 00 |..n...|.|..q..~..|
|000010c0| 7d 00 00 67 00 00 04 7d | 05 00 7c 00 00 44 5d 1c |}..g...}|..|..D].|
|000010d0| 00 7d 03 00 7c 05 00 64 | 04 00 69 09 00 7c 03 00 |.}..|..d|..i..|..|
|000010e0| 69 05 00 83 00 00 83 01 | 00 12 71 d0 00 7e 05 00 |i.......|..q..~..|
|000010f0| 53 01 7c 00 00 64 00 00 | 6a 08 00 70 10 00 01 74 |S.|..d..|j..p...t|
|00001100| 01 00 7c 00 00 74 03 00 | 83 02 00 6f 05 00 01 7c |..|..t..|...o...||
|00001110| 00 00 53 01 7c 00 00 69 | 07 00 74 08 00 64 03 00 |..S.|..i|..t..d..|
|00001120| 83 02 00 53 64 00 00 53 | 28 05 00 00 00 4e 52 22 |...Sd..S|(....NR"|
|00001130| 00 00 00 74 01 00 00 00 | 2c 74 07 00 00 00 72 65 |...t....|,t....re|
|00001140| 70 6c 61 63 65 75 01 00 | 00 00 20 28 0a 00 00 00 |placeu..|.. (....|
|00001150| 74 04 00 00 00 4e 6f 6e | 65 74 0a 00 00 00 69 73 |t....Non|et....is|
|00001160| 69 6e 73 74 61 6e 63 65 | 74 03 00 00 00 73 74 72 |instance|t....str|
|00001170| 74 07 00 00 00 75 6e 69 | 63 6f 64 65 74 05 00 00 |t....uni|codet...|
|00001180| 00 62 79 74 65 73 74 05 | 00 00 00 73 70 6c 69 74 |.bytest.|...split|
|00001190| 74 05 00 00 00 73 74 72 | 69 70 74 06 00 00 00 64 |t....str|ipt....d|
|000011a0| 65 63 6f 64 65 52 04 00 | 00 00 74 04 00 00 00 6a |ecodeR..|..t....j|
|000011b0| 6f 69 6e 28 06 00 00 00 | 52 18 00 00 00 74 01 00 |oin(....|R....t..|
|000011c0| 00 00 64 52 17 00 00 00 | 74 01 00 00 00 79 74 04 |..dR....|t....yt.|
|000011d0| 00 00 00 5f 5b 32 5d 74 | 04 00 00 00 5f 5b 33 5d |..._[2]t|...._[3]|
|000011e0| 28 00 00 00 00 28 00 00 | 00 00 73 2f 00 00 00 73 |(....(..|..s/...s|
|000011f0| 69 74 65 2d 70 61 63 6b | 61 67 65 73 5c 63 61 6c |ite-pack|ages\cal|
|00001200| 69 62 72 65 5c 6c 69 62 | 72 61 72 79 5c 63 75 73 |ibre\lib|rary\cus|
|00001210| 74 6f 6d 5f 63 6f 6c 75 | 6d 6e 73 2e 70 79 74 0a |tom_colu|mns.pyt.|
|00001220| 00 00 00 61 64 61 70 74 | 5f 74 65 78 74 73 00 00 |...adapt|_texts..|
|00001230| 00 73 16 00 00 00 00 01 | 0b 01 0d 01 05 01 19 01 |.s......|........|
|00001240| 13 01 38 01 07 01 3d 01 | 2f 02 22 01 63 02 00 00 |..8...=.|/.".c...|
|00001250| 00 02 00 00 00 06 00 00 | 00 53 80 00 00 73 39 00 |........|.S...s9.|
|00001260| 00 00 74 00 00 7c 00 00 | 74 01 00 74 02 00 74 03 |..t..|..|t..t..t.|
|00001270| 00 66 03 00 83 02 00 6f | 1c 00 01 74 04 00 7c 00 |.f.....o|...t..|.|
|00001280| 00 64 01 00 74 05 00 64 | 02 00 74 05 00 83 01 02 |.d..t..d|..t.....|
|00001290| 7d 00 00 6e 01 00 01 7c | 00 00 53 28 03 00 00 00 |}..n...||..S(....|
|000012a0| 4e 74 0a 00 00 00 61 73 | 73 75 6d 65 5f 75 74 63 |Nt....as|sume_utc|
|000012b0| 74 06 00 00 00 61 73 5f | 75 74 63 28 06 00 00 00 |t....as_|utc(....|
|000012c0| 52 26 00 00 00 52 27 00 | 00 00 52 28 00 00 00 52 |R&...R'.|..R(...R|
|000012d0| 29 00 00 00 52 06 00 00 | 00 74 05 00 00 00 46 61 |)...R...|.t....Fa|
|000012e0| 6c 73 65 28 02 00 00 00 | 52 18 00 00 00 52 2e 00 |lse(....|R....R..|
|000012f0| 00 00 28 00 00 00 00 28 | 00 00 00 00 73 2f 00 00 |..(....(|....s/..|
|00001300| 00 73 69 74 65 2d 70 61 | 63 6b 61 67 65 73 5c 63 |.site-pa|ckages\c|
|00001310| 61 6c 69 62 72 65 5c 6c | 69 62 72 61 72 79 5c 63 |alibre\l|ibrary\c|
|00001320| 75 73 74 6f 6d 5f 63 6f | 6c 75 6d 6e 73 2e 70 79 |ustom_co|lumns.py|
|00001330| 74 0e 00 00 00 61 64 61 | 70 74 5f 64 61 74 65 74 |t....ada|pt_datet|
|00001340| 69 6d 65 81 00 00 00 73 | 06 00 00 00 00 01 19 01 |ime....s|........|
|00001350| 1c 01 63 02 00 00 00 02 | 00 00 00 05 00 00 00 53 |..c.....|.......S|
|00001360| 80 00 00 73 33 00 00 00 | 74 00 00 7c 00 00 74 01 |...s3...|t..|..t.|
|00001370| 00 74 02 00 74 03 00 66 | 03 00 83 02 00 6f 16 00 |.t..t..f|.....o..|
|00001380| 01 74 04 00 74 05 00 7c | 00 00 83 01 00 83 01 00 |.t..t..||........|
|00001390| 7d 00 00 6e 01 00 01 7c | 00 00 53 28 01 00 00 00 |}..n...||..S(....|
|000013a0| 4e 28 06 00 00 00 52 26 | 00 00 00 52 27 00 00 00 |N(....R&|...R'...|
|000013b0| 52 28 00 00 00 52 29 00 | 00 00 52 0e 00 00 00 52 |R(...R).|..R....R|
|000013c0| 0c 00 00 00 28 02 00 00 | 00 52 18 00 00 00 52 2e |....(...|.R....R.|
|000013d0| 00 00 00 28 00 00 00 00 | 28 00 00 00 00 73 2f 00 |...(....|(....s/.|
|000013e0| 00 00 73 69 74 65 2d 70 | 61 63 6b 61 67 65 73 5c |..site-p|ackages\|
|000013f0| 63 61 6c 69 62 72 65 5c | 6c 69 62 72 61 72 79 5c |calibre\|library\|
|00001400| 63 75 73 74 6f 6d 5f 63 | 6f 6c 75 6d 6e 73 2e 70 |custom_c|olumns.p|
|00001410| 79 74 0a 00 00 00 61 64 | 61 70 74 5f 62 6f 6f 6c |yt....ad|apt_bool|
|00001420| 86 00 00 00 73 06 00 00 | 00 00 01 19 01 16 01 63 |....s...|.......c|
|00001430| 02 00 00 00 02 00 00 00 | 02 00 00 00 53 80 00 00 |........|....S...|
|00001440| 73 1c 00 00 00 7c 00 00 | 64 00 00 6a 08 00 6f 05 |s....|..|d..j..o.|
|00001450| 00 01 7c 00 00 53 01 74 | 01 00 7c 00 00 83 01 00 |..|..S.t|..|.....|
|00001460| 53 28 01 00 00 00 4e 28 | 02 00 00 00 52 25 00 00 |S(....N(|....R%..|
|00001470| 00 52 0d 00 00 00 28 02 | 00 00 00 52 18 00 00 00 |.R....(.|...R....|
|00001480| 52 2e 00 00 00 28 00 00 | 00 00 28 00 00 00 00 73 |R....(..|..(....s|
|00001490| 2f 00 00 00 73 69 74 65 | 2d 70 61 63 6b 61 67 65 |/...site|-package|
|000014a0| 73 5c 63 61 6c 69 62 72 | 65 5c 6c 69 62 72 61 72 |s\calibr|e\librar|
|000014b0| 79 5c 63 75 73 74 6f 6d | 5f 63 6f 6c 75 6d 6e 73 |y\custom|_columns|
|000014c0| 2e 70 79 74 08 00 00 00 | 3c 6c 61 6d 62 64 61 3e |.pyt....|<lambda>|
|000014d0| 8c 00 00 00 73 00 00 00 | 00 52 0d 00 00 00 63 02 |....s...|.R....c.|
|000014e0| 00 00 00 02 00 00 00 02 | 00 00 00 53 80 00 00 73 |........|...S...s|
|000014f0| 1c 00 00 00 7c 00 00 64 | 00 00 6a 08 00 6f 05 00 |....|..d|..j..o..|
|00001500| 01 7c 00 00 53 01 74 01 | 00 7c 00 00 83 01 00 53 |.|..S.t.|.|.....S|
|00001510| 28 01 00 00 00 4e 28 02 | 00 00 00 52 25 00 00 00 |(....N(.|...R%...|
|00001520| 52 0c 00 00 00 28 02 00 | 00 00 52 18 00 00 00 52 |R....(..|..R....R|
|00001530| 2e 00 00 00 28 00 00 00 | 00 28 00 00 00 00 73 2f |....(...|.(....s/|
|00001540| 00 00 00 73 69 74 65 2d | 70 61 63 6b 61 67 65 73 |...site-|packages|
|00001550| 5c 63 61 6c 69 62 72 65 | 5c 6c 69 62 72 61 72 79 |\calibre|\library|
|00001560| 5c 63 75 73 74 6f 6d 5f | 63 6f 6c 75 6d 6e 73 2e |\custom_|columns.|
|00001570| 70 79 52 38 00 00 00 8d | 00 00 00 73 00 00 00 00 |pyR8....|...s....|
|00001580| 52 0c 00 00 00 63 02 00 | 00 00 02 00 00 00 06 00 |R....c..|........|
|00001590| 00 00 53 80 00 00 73 2e | 00 00 00 7c 00 00 64 02 |..S...s.|...|..d.|
|000015a0| 00 6a 08 00 6f 05 00 01 | 7c 00 00 53 01 74 01 00 |.j..o...||..S.t..|
|000015b0| 64 00 00 74 02 00 64 01 | 00 74 03 00 7c 00 00 83 |d..t..d.|.t..|...|
|000015c0| 01 00 83 02 00 83 02 00 | 53 28 03 00 00 00 67 00 |........|S(....g.|
|000015d0| 00 00 00 00 00 24 40 67 | 00 00 00 00 00 00 00 00 |.....$@g|........|
|000015e0| 4e 28 04 00 00 00 52 25 | 00 00 00 74 03 00 00 00 |N(....R%|...t....|
|000015f0| 6d 69 6e 74 03 00 00 00 | 6d 61 78 52 0d 00 00 00 |mint....|maxR....|
|00001600| 28 02 00 00 00 52 18 00 | 00 00 52 2e 00 00 00 28 |(....R..|..R....(|
|00001610| 00 00 00 00 28 00 00 00 | 00 73 2f 00 00 00 73 69 |....(...|.s/...si|
|00001620| 74 65 2d 70 61 63 6b 61 | 67 65 73 5c 63 61 6c 69 |te-packa|ges\cali|
|00001630| 62 72 65 5c 6c 69 62 72 | 61 72 79 5c 63 75 73 74 |bre\libr|ary\cust|
|00001640| 6f 6d 5f 63 6f 6c 75 6d | 6e 73 2e 70 79 52 38 00 |om_colum|ns.pyR8.|
|00001650| 00 00 8e 00 00 00 73 00 | 00 00 00 52 08 00 00 00 |......s.|...R....|
|00001660| 52 0e 00 00 00 63 02 00 | 00 00 02 00 00 00 05 00 |R....c..|........|
|00001670| 00 00 13 80 00 00 73 14 | 00 00 00 88 00 00 7c 00 |......s.|......|.|
|00001680| 00 68 01 00 74 00 00 64 | 00 00 36 83 02 00 53 28 |.h..t..d|..6...S(|
|00001690| 01 00 00 00 52 22 00 00 | 00 28 01 00 00 00 52 35 |....R"..|.(....R5|
|000016a0| 00 00 00 28 02 00 00 00 | 52 18 00 00 00 52 2e 00 |...(....|R....R..|
|000016b0| 00 00 28 01 00 00 00 52 | 32 00 00 00 28 00 00 00 |..(....R|2...(...|
|000016c0| 00 73 2f 00 00 00 73 69 | 74 65 2d 70 61 63 6b 61 |.s/...si|te-packa|
|000016d0| 67 65 73 5c 63 61 6c 69 | 62 72 65 5c 6c 69 62 72 |ges\cali|bre\libr|
|000016e0| 61 72 79 5c 63 75 73 74 | 6f 6d 5f 63 6f 6c 75 6d |ary\cust|om_colum|
|000016f0| 6e 73 2e 70 79 52 38 00 | 00 00 90 00 00 00 73 00 |ns.pyR8.|......s.|
|00001700| 00 00 00 52 0a 00 00 00 | 52 0b 00 00 00 52 09 00 |...R....|R....R..|
|00001710| 00 00 52 0f 00 00 00 74 | 01 00 00 00 7c 73 11 00 |..R....t|....|s..|
|00001720| 00 00 63 75 73 74 6f 6d | 5f 63 6f 6c 75 6d 6e 5f |..custom|_column_|
|00001730| 7b 30 7d 74 06 00 00 00 | 63 6f 6c 75 6d 6e 74 05 |{0}t....|columnt.|
|00001740| 00 00 00 76 61 6c 75 65 | 74 06 00 00 00 63 6f 6c |...value|t....col|
|00001750| 6e 75 6d 74 0b 00 00 00 | 69 73 5f 63 61 74 65 67 |numt....|is_categ|
|00001760| 6f 72 79 74 0b 00 00 00 | 69 73 5f 65 64 69 74 61 |oryt....|is_edita|
|00001770| 62 6c 65 28 1c 00 00 00 | 74 03 00 00 00 6c 65 6e |ble(....|t....len|
|00001780| 74 11 00 00 00 43 55 53 | 54 4f 4d 5f 44 41 54 41 |t....CUS|TOM_DATA|
|00001790| 5f 54 59 50 45 53 52 05 | 00 00 00 74 10 00 00 00 |_TYPESR.|...t....|
|000017a0| 56 41 4c 49 44 5f 44 41 | 54 41 5f 54 59 50 45 53 |VALID_DA|TA_TYPES|
|000017b0| 74 0a 00 00 00 56 61 6c | 75 65 45 72 72 6f 72 52 |t....Val|ueErrorR|
|000017c0| 15 00 00 00 52 16 00 00 | 00 52 13 00 00 00 74 0d |....R...|.R....t.|
|000017d0| 00 00 00 65 78 65 63 75 | 74 65 73 63 72 69 70 74 |...execu|tescript|
|000017e0| 74 06 00 00 00 66 6f 72 | 6d 61 74 74 07 00 00 00 |t....for|matt....|
|000017f0| 65 78 65 63 75 74 65 74 | 06 00 00 00 63 6f 6d 6d |executet|....comm|
|00001800| 69 74 74 17 00 00 00 63 | 75 73 74 6f 6d 5f 63 6f |itt....c|ustom_co|
|00001810| 6c 75 6d 6e 5f 6c 61 62 | 65 6c 5f 6d 61 70 74 15 |lumn_lab|el_mapt.|
|00001820| 00 00 00 63 75 73 74 6f | 6d 5f 63 6f 6c 75 6d 6e |...custo|m_column|
|00001830| 5f 6e 75 6d 5f 6d 61 70 | 52 19 00 00 00 74 04 00 |_num_map|R....t..|
|00001840| 00 00 6a 73 6f 6e 74 05 | 00 00 00 6c 6f 61 64 73 |..jsont.|...loads|
|00001850| 74 06 00 00 00 61 70 70 | 65 6e 64 52 03 00 00 00 |t....app|endR....|
|00001860| 52 2d 00 00 00 74 14 00 | 00 00 63 75 73 74 6f 6d |R-...t..|..custom|
|00001870| 5f 64 61 74 61 5f 61 64 | 61 70 74 65 72 73 74 06 |_data_ad|apterst.|
|00001880| 00 00 00 73 6f 72 74 65 | 64 74 04 00 00 00 6b 65 |...sorte|dt....ke|
|00001890| 79 73 74 04 00 00 00 54 | 72 75 65 52 35 00 00 00 |yst....T|rueR5...|
|000018a0| 52 25 00 00 00 74 0e 00 | 00 00 66 69 65 6c 64 5f |R%...t..|..field_|
|000018b0| 6d 65 74 61 64 61 74 61 | 74 10 00 00 00 61 64 64 |metadata|t....add|
|000018c0| 5f 63 75 73 74 6f 6d 5f | 66 69 65 6c 64 28 11 00 |_custom_|field(..|
|000018d0| 00 00 52 11 00 00 00 74 | 06 00 00 00 72 65 63 6f |..R....t|....reco|
|000018e0| 72 64 52 12 00 00 00 52 | 1a 00 00 00 52 1b 00 00 |rdR....R|....R...|
|000018f0| 00 74 08 00 00 00 74 72 | 69 67 67 65 72 73 74 06 |.t....tr|iggerst.|
|00001900| 00 00 00 72 65 6d 6f 76 | 65 52 19 00 00 00 74 04 |...remov|eR....t.|
|00001910| 00 00 00 64 61 74 61 74 | 07 00 00 00 74 72 69 67 |...datat|....trig|
|00001920| 67 65 72 52 36 00 00 00 | 52 37 00 00 00 74 01 00 |gerR6...|R7...t..|
|00001930| 00 00 6b 74 01 00 00 00 | 76 52 3f 00 00 00 74 04 |..kt....|vR?...t.|
|00001940| 00 00 00 69 73 5f 6d 74 | 02 00 00 00 74 6e 28 00 |...is_mt|....tn(.|
|00001950| 00 00 00 28 01 00 00 00 | 52 32 00 00 00 73 2f 00 |...(....|R2...s/.|
|00001960| 00 00 73 69 74 65 2d 70 | 61 63 6b 61 67 65 73 5c |..site-p|ackages\|
|00001970| 63 61 6c 69 62 72 65 5c | 6c 69 62 72 61 72 79 5c |calibre\|library\|
|00001980| 63 75 73 74 6f 6d 5f 63 | 6f 6c 75 6d 6e 73 2e 70 |custom_c|olumns.p|
|00001990| 79 74 08 00 00 00 5f 5f | 69 6e 69 74 5f 5f 21 00 |yt....__|init__!.|
|000019a0| 00 00 73 9a 00 00 00 00 | 03 1d 01 10 02 0c 01 07 |..s.....|........|
|000019b0| 00 06 01 0a 01 15 01 09 | 0e 1d 02 10 01 0d 03 13 |........|........|
|000019c0| 01 06 01 06 01 09 01 0c | 01 07 00 06 01 03 01 0b |........|........|
|000019d0| 01 0b 01 0b 01 0b 01 14 | 01 0b 01 0b 01 0e 02 19 |........|........|
|000019e0| 01 1b 01 0a 01 0d 01 07 | 02 15 02 20 03 0b 01 0e |........|... ....|
|000019f0| 02 0a 01 11 02 07 01 07 | 00 06 01 06 01 0c 01 0c |........|........|
|00001a00| 01 12 01 11 02 07 01 09 | 06 14 01 11 03 09 0e 09 |........|........|
|00001a10| 05 09 05 03 01 0a 01 0a | 01 0a 01 07 01 10 01 07 |........|........|
|00001a20| 01 07 01 0d 04 16 00 06 | 01 0d 01 0b 01 0a 02 06 |........|........|
|00001a30| 01 0b 01 0a 02 06 01 13 | 01 16 01 16 01 1e 01 0c |........|........|
|00001a40| 01 63 05 00 00 00 08 00 | 00 00 04 00 00 00 43 80 |.c......|......C.|
|00001a50| 00 00 73 e5 00 00 00 7c | 02 00 64 00 00 6a 09 00 |..s....||..d..j..|
|00001a60| 6f 11 00 01 7c 00 00 69 | 01 00 7c 02 00 19 7d 05 |o...|..i|..|...}.|
|00001a70| 00 6e 01 00 01 7c 03 00 | 64 00 00 6a 09 00 6f 11 |.n...|..|d..j..o.|
|00001a80| 00 01 7c 00 00 69 02 00 | 7c 03 00 19 7d 05 00 6e |..|..i..||...}..n|
|00001a90| 01 00 01 7c 04 00 6f 11 | 00 01 7c 00 00 69 03 00 |...|..o.|..|..i..|
|00001aa0| 69 04 00 7c 01 00 19 6e | 0b 00 01 7c 00 00 69 03 |i..|...n|...|..i.|
|00001ab0| 00 7c 01 00 19 7d 06 00 | 7c 06 00 7c 00 00 69 05 |.|...}..||..|..i.|
|00001ac0| 00 7c 05 00 64 01 00 19 | 19 19 7d 07 00 7c 05 00 |.|..d...|..}..|..|
|00001ad0| 64 02 00 19 6f 60 00 01 | 7c 05 00 64 03 00 19 64 |d...o`..||..d...d|
|00001ae0| 04 00 6a 02 00 6f 4f 00 | 01 7c 07 00 6f 10 00 01 |..j..oO.|.|..o...|
|00001af0| 7c 07 00 69 06 00 64 05 | 00 83 01 00 6e 04 00 01 ||..i..d.|....n...|
|00001b00| 67 00 00 7d 07 00 7c 05 | 00 64 06 00 19 69 07 00 |g..}..|.|.d...i..|
|00001b10| 64 07 00 74 08 00 83 02 | 00 6f 17 00 01 7c 07 00 |d..t....|.o...|..|
|00001b20| 69 09 00 64 08 00 64 09 | 00 84 00 00 83 00 01 01 |i..d..d.|........|
|00001b30| 71 e1 00 01 6e 01 00 01 | 7c 07 00 53 28 0a 00 00 |q...n...||..S(...|
|00001b40| 00 4e 52 12 00 00 00 52 | 22 00 00 00 52 1e 00 00 |.NR....R|"...R...|
|00001b50| 00 52 09 00 00 00 52 3b | 00 00 00 52 20 00 00 00 |.R....R;|...R ...|
|00001b60| 74 0a 00 00 00 73 6f 72 | 74 5f 61 6c 70 68 61 74 |t....sor|t_alphat|
|00001b70| 03 00 00 00 63 6d 70 63 | 02 00 00 00 02 00 00 00 |....cmpc|........|
|00001b80| 03 00 00 00 53 80 00 00 | 73 19 00 00 00 74 00 00 |....S...|s....t..|
|00001b90| 7c 00 00 69 01 00 83 00 | 00 7c 01 00 69 01 00 83 ||..i....|.|..i...|
|00001ba0| 00 00 83 02 00 53 28 00 | 00 00 00 28 02 00 00 00 |.....S(.|...(....|
|00001bb0| 52 5f 00 00 00 74 05 00 | 00 00 6c 6f 77 65 72 28 |R_...t..|..lower(|
|00001bc0| 02 00 00 00 52 18 00 00 | 00 52 2f 00 00 00 28 00 |....R...|.R/...(.|
|00001bd0| 00 00 00 28 00 00 00 00 | 73 2f 00 00 00 73 69 74 |...(....|s/...sit|
|00001be0| 65 2d 70 61 63 6b 61 67 | 65 73 5c 63 61 6c 69 62 |e-packag|es\calib|
|00001bf0| 72 65 5c 6c 69 62 72 61 | 72 79 5c 63 75 73 74 6f |re\libra|ry\custo|
|00001c00| 6d 5f 63 6f 6c 75 6d 6e | 73 2e 70 79 52 38 00 00 |m_column|s.pyR8..|
|00001c10| 00 b2 00 00 00 73 00 00 | 00 00 28 0a 00 00 00 52 |.....s..|..(....R|
|00001c20| 25 00 00 00 52 49 00 00 | 00 52 4a 00 00 00 52 57 |%...RI..|.RJ...RW|
|00001c30| 00 00 00 74 05 00 00 00 | 5f 64 61 74 61 74 09 00 |...t....|_datat..|
|00001c40| 00 00 46 49 45 4c 44 5f | 4d 41 50 52 2a 00 00 00 |..FIELD_|MAPR*...|
|00001c50| 52 16 00 00 00 52 35 00 | 00 00 74 04 00 00 00 73 |R....R5.|..t....s|
|00001c60| 6f 72 74 28 08 00 00 00 | 52 11 00 00 00 74 03 00 |ort(....|R....t..|
|00001c70| 00 00 69 64 78 52 1c 00 | 00 00 52 12 00 00 00 74 |..idxR..|..R....t|
|00001c80| 0b 00 00 00 69 6e 64 65 | 78 5f 69 73 5f 69 64 52 |....inde|x_is_idR|
|00001c90| 57 00 00 00 74 03 00 00 | 00 72 6f 77 74 03 00 00 |W...t...|.rowt...|
|00001ca0| 00 61 6e 73 28 00 00 00 | 00 28 00 00 00 00 73 2f |.ans(...|.(....s/|
|00001cb0| 00 00 00 73 69 74 65 2d | 70 61 63 6b 61 67 65 73 |...site-|packages|
|00001cc0| 5c 63 61 6c 69 62 72 65 | 5c 6c 69 62 72 61 72 79 |\calibre|\library|
|00001cd0| 5c 63 75 73 74 6f 6d 5f | 63 6f 6c 75 6d 6e 73 2e |\custom_|columns.|
|00001ce0| 70 79 74 0a 00 00 00 67 | 65 74 5f 63 75 73 74 6f |pyt....g|et_custo|
|00001cf0| 6d a8 00 00 00 73 16 00 | 00 00 00 01 0d 01 11 01 |m....s..|........|
|00001d00| 0d 01 11 01 25 01 15 01 | 1c 01 1d 01 17 01 1b 01 |....%...|........|
|00001d10| 63 05 00 00 00 08 00 00 | 00 05 00 00 00 43 80 00 |c.......|.....C..|
|00001d20| 00 73 a8 00 00 00 7c 02 | 00 64 00 00 6a 09 00 6f |.s....|.|.d..j..o|
|00001d30| 11 00 01 7c 00 00 69 01 | 00 7c 02 00 19 7d 05 00 |...|..i.|.|...}..|
|00001d40| 6e 01 00 01 7c 03 00 64 | 00 00 6a 09 00 6f 11 00 |n...|..d|..j..o..|
|00001d50| 01 7c 00 00 69 02 00 7c | 03 00 19 7d 05 00 6e 01 |.|..i..||...}..n.|
|00001d60| 00 01 7c 05 00 64 01 00 | 19 64 06 00 6a 07 00 6f |..|..d..|.d..j..o|
|00001d70| 05 00 01 64 00 00 53 01 | 7c 00 00 69 03 00 7c 05 |...d..S.||..i..|.|
|00001d80| 00 64 03 00 19 83 01 00 | 5c 02 00 7d 06 00 7d 07 |.d......|\..}..}.|
|00001d90| 00 7c 04 00 6f 07 00 01 | 7c 01 00 6e 0d 00 01 7c |.|..o...||..n...||
|00001da0| 00 00 69 04 00 7c 01 00 | 83 01 00 7d 01 00 7c 00 |..i..|..|...}..|.|
|00001db0| 00 69 05 00 69 06 00 64 | 04 00 7c 07 00 16 7c 01 |.i..i..d|..|...|.|
|00001dc0| 00 66 01 00 64 05 00 74 | 07 00 83 02 01 53 28 07 |.f..d..t|.....S(.|
|00001dd0| 00 00 00 4e 52 1e 00 00 | 00 52 0f 00 00 00 52 12 |...NR...|.R....R.|
|00001de0| 00 00 00 73 41 00 00 00 | 53 45 4c 45 43 54 20 65 |...sA...|SELECT e|
|00001df0| 78 74 72 61 20 46 52 4f | 4d 20 25 73 0a 20 20 20 |xtra FRO|M %s.   |
|00001e00| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |        |        |
|00001e10| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 57 48 45 |        |     WHE|
|00001e20| 52 45 20 62 6f 6f 6b 3d | 3f 74 03 00 00 00 61 6c |RE book=|?t....al|
|00001e30| 6c 28 01 00 00 00 73 06 | 00 00 00 73 65 72 69 65 |l(....s.|...serie|
|00001e40| 73 28 08 00 00 00 52 25 | 00 00 00 52 49 00 00 00 |s(....R%|...RI...|
|00001e50| 52 4a 00 00 00 52 13 00 | 00 00 74 02 00 00 00 69 |RJ...R..|..t....i|
|00001e60| 64 52 15 00 00 00 52 16 | 00 00 00 52 35 00 00 00 |dR....R.|...R5...|
|00001e70| 28 08 00 00 00 52 11 00 | 00 00 52 64 00 00 00 52 |(....R..|..Rd...R|
|00001e80| 1c 00 00 00 52 12 00 00 | 00 52 65 00 00 00 52 57 |....R...|.Re...RW|
|00001e90| 00 00 00 74 03 00 00 00 | 69 67 6e 52 1b 00 00 00 |...t....|ignR....|
|00001ea0| 28 00 00 00 00 28 00 00 | 00 00 73 2f 00 00 00 73 |(....(..|..s/...s|
|00001eb0| 69 74 65 2d 70 61 63 6b | 61 67 65 73 5c 63 61 6c |ite-pack|ages\cal|
|00001ec0| 69 62 72 65 5c 6c 69 62 | 72 61 72 79 5c 63 75 73 |ibre\lib|rary\cus|
|00001ed0| 74 6f 6d 5f 63 6f 6c 75 | 6d 6e 73 2e 70 79 74 10 |tom_colu|mns.pyt.|
|00001ee0| 00 00 00 67 65 74 5f 63 | 75 73 74 6f 6d 5f 65 78 |...get_c|ustom_ex|
|00001ef0| 74 72 61 b5 00 00 00 73 | 14 00 00 00 00 01 0d 01 |tra....s|........|
|00001f00| 11 01 0d 01 11 02 11 01 | 05 01 19 01 1d 01 09 01 |........|........|
|00001f10| 63 03 00 00 00 07 00 00 | 00 03 00 00 00 43 80 00 |c.......|.....C..|
|00001f20| 00 73 7f 00 00 00 7c 01 | 00 64 00 00 6a 09 00 6f |.s....|.|.d..j..o|
|00001f30| 11 00 01 7c 00 00 69 01 | 00 7c 01 00 19 7d 03 00 |...|..i.|.|...}..|
|00001f40| 6e 01 00 01 7c 02 00 64 | 00 00 6a 09 00 6f 11 00 |n...|..d|..j..o..|
|00001f50| 01 7c 00 00 69 02 00 7c | 02 00 19 7d 03 00 6e 01 |.|..i..||...}..n.|
|00001f60| 00 01 7c 00 00 69 03 00 | 7c 03 00 64 01 00 19 83 |..|..i..||..d....|
|00001f70| 01 00 5c 02 00 7d 04 00 | 7d 05 00 7c 03 00 64 02 |..\..}..|}..|..d.|
|00001f80| 00 19 70 05 00 01 67 00 | 00 53 01 7c 00 00 69 04 |..p...g.|.S.|..i.|
|00001f90| 00 69 05 00 64 03 00 7c | 04 00 16 83 01 00 7d 06 |.i..d..||......}.|
|00001fa0| 00 7c 06 00 53 28 04 00 | 00 00 4e 52 12 00 00 00 |.|..S(..|..NR....|
|00001fb0| 52 21 00 00 00 73 18 00 | 00 00 53 45 4c 45 43 54 |R!...s..|..SELECT|
|00001fc0| 20 69 64 2c 20 76 61 6c | 75 65 20 46 52 4f 4d 20 | id, val|ue FROM |
|00001fd0| 25 73 28 06 00 00 00 52 | 25 00 00 00 52 49 00 00 |%s(....R|%...RI..|
|00001fe0| 00 52 4a 00 00 00 52 13 | 00 00 00 52 15 00 00 00 |.RJ...R.|...R....|
|00001ff0| 52 16 00 00 00 28 07 00 | 00 00 52 11 00 00 00 52 |R....(..|..R....R|
|00002000| 1c 00 00 00 52 12 00 00 | 00 52 57 00 00 00 52 1a |....R...|.RW...R.|
|00002010| 00 00 00 52 1b 00 00 00 | 52 67 00 00 00 28 00 00 |...R....|Rg...(..|
|00002020| 00 00 28 00 00 00 00 73 | 2f 00 00 00 73 69 74 65 |..(....s|/...site|
|00002030| 2d 70 61 63 6b 61 67 65 | 73 5c 63 61 6c 69 62 72 |-package|s\calibr|
|00002040| 65 5c 6c 69 62 72 61 72 | 79 5c 63 75 73 74 6f 6d |e\librar|y\custom|
|00002050| 5f 63 6f 6c 75 6d 6e 73 | 2e 70 79 74 19 00 00 00 |_columns|.pyt....|
|00002060| 67 65 74 5f 63 75 73 74 | 6f 6d 5f 69 74 65 6d 73 |get_cust|om_items|
|00002070| 5f 77 69 74 68 5f 69 64 | 73 c3 00 00 00 73 12 00 |_with_id|s....s..|
|00002080| 00 00 00 01 0d 01 11 01 | 0d 01 11 01 19 01 0b 01 |........|........|
|00002090| 05 01 16 01 63 05 00 00 | 00 0b 00 00 00 07 00 00 |....c...|........|
|000020a0| 00 43 80 00 00 73 7a 01 | 00 00 7c 03 00 64 00 00 |.C...sz.|..|..d..|
|000020b0| 6a 09 00 6f 11 00 01 7c | 00 00 69 01 00 7c 03 00 |j..o...||..i..|..|
|000020c0| 19 7d 05 00 6e 01 00 01 | 7c 04 00 64 00 00 6a 09 |.}..n...||..d..j.|
|000020d0| 00 6f 11 00 01 7c 00 00 | 69 02 00 7c 04 00 19 7d |.o...|..|i..|...}|
|000020e0| 05 00 6e 01 00 01 7c 00 | 00 69 03 00 7c 05 00 64 |..n...|.|.i..|..d|
|000020f0| 01 00 19 83 01 00 5c 02 | 00 7d 06 00 7d 07 00 7c |......\.|.}..}..||
|00002100| 00 00 69 04 00 69 05 00 | 64 02 00 7c 06 00 16 7c |..i..i..|d..|...||
|00002110| 02 00 66 01 00 64 03 00 | 74 06 00 83 02 01 7d 08 |..f..d..|t.....}.|
|00002120| 00 7c 08 00 64 00 00 6a | 08 00 70 0d 00 01 7c 01 |.|..d..j|..p...|.|
|00002130| 00 7c 08 00 6a 02 00 6f | 27 00 01 7c 00 00 69 04 |.|..j..o|'..|..i.|
|00002140| 00 69 07 00 64 04 00 7c | 06 00 16 7c 02 00 7c 01 |.i..d..||...|..|.|
|00002150| 00 66 02 00 83 02 00 01 | 7c 01 00 7d 08 00 6e 94 |.f......||..}..n.|
|00002160| 00 01 7c 05 00 64 05 00 | 19 6f 51 00 01 7c 00 00 |..|..d..|.oQ..|..|
|00002170| 69 04 00 69 05 00 64 06 | 00 7c 07 00 16 7c 01 00 |i..i..d.|.|...|..|
|00002180| 66 01 00 83 02 00 7d 09 | 00 78 32 00 7c 09 00 44 |f.....}.|.x2.|..D|
|00002190| 5d 26 00 5c 01 00 7d 0a | 00 7c 00 00 69 04 00 69 |]&.\..}.|.|..i..i|
|000021a0| 07 00 64 07 00 7c 07 00 | 16 7c 0a 00 7c 08 00 66 |..d..|..|.|..|..f|
|000021b0| 02 00 83 02 00 01 71 e6 | 00 57 6e 01 00 01 7c 00 |......q.|.Wn...|.|
|000021c0| 00 69 04 00 69 07 00 64 | 08 00 7c 07 00 16 7c 08 |.i..i..d|..|...|.|
|000021d0| 00 7c 01 00 66 02 00 83 | 02 00 01 7c 00 00 69 04 |.|..f...|...|..i.|
|000021e0| 00 69 07 00 64 09 00 7c | 06 00 16 7c 01 00 66 01 |.i..d..||...|..f.|
|000021f0| 00 83 02 00 01 7c 00 00 | 69 08 00 64 0a 00 7c 05 |.....|..|i..d..|.|
|00002200| 00 64 0b 00 19 17 7c 08 | 00 64 0c 00 74 06 00 83 |.d....|.|.d..t...|
|00002210| 02 01 01 7c 00 00 69 04 | 00 69 09 00 83 00 00 01 |...|..i.|.i......|
|00002220| 64 00 00 53 28 0d 00 00 | 00 4e 52 12 00 00 00 73 |d..S(...|.NR....s|
|00002230| 1f 00 00 00 53 45 4c 45 | 43 54 20 69 64 20 46 52 |....SELE|CT id FR|
|00002240| 4f 4d 20 25 73 20 57 48 | 45 52 45 20 76 61 6c 75 |OM %s WH|ERE valu|
|00002250| 65 3d 3f 52 69 00 00 00 | 73 20 00 00 00 55 50 44 |e=?Ri...|s ...UPD|
|00002260| 41 54 45 20 25 73 20 53 | 45 54 20 76 61 6c 75 65 |ATE %s S|ET value|
|00002270| 3d 3f 20 57 48 45 52 45 | 20 69 64 3d 3f 52 22 00 |=? WHERE| id=?R".|
|00002280| 00 00 73 4a 00 00 00 53 | 45 4c 45 43 54 20 62 6f |..sJ...S|ELECT bo|
|00002290| 6f 6b 20 66 72 6f 6d 20 | 25 73 0a 20 20 20 20 20 |ok from |%s.     |
|000022a0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |        |        |
|000022b0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |        |        |
|000022c0| 20 20 20 20 57 48 45 52 | 45 20 76 61 6c 75 65 3d |    WHER|E value=|
|000022d0| 3f 73 43 00 00 00 44 45 | 4c 45 54 45 20 46 52 4f |?sC...DE|LETE FRO|
|000022e0| 4d 20 25 73 0a 20 20 20 | 20 20 20 20 20 20 20 20 |M %s.   |        |
|000022f0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |        |        |
|00002300| 20 57 48 45 52 45 20 62 | 6f 6f 6b 3d 3f 20 61 6e | WHERE b|ook=? an|
|00002310| 64 20 76 61 6c 75 65 3d | 3f 73 44 00 00 00 55 50 |d value=|?sD...UP|
|00002320| 44 41 54 45 20 25 73 20 | 53 45 54 20 76 61 6c 75 |DATE %s |SET valu|
|00002330| 65 3d 3f 0a 20 20 20 20 | 20 20 20 20 20 20 20 20 |e=?.    |        |
|00002340| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |        |        |
|00002350| 20 20 20 20 20 57 48 45 | 52 45 20 76 61 6c 75 65 |     WHE|RE value|
|00002360| 3d 3f 73 19 00 00 00 44 | 45 4c 45 54 45 20 46 52 |=?s....D|ELETE FR|
|00002370| 4f 4d 20 25 73 20 57 48 | 45 52 45 20 69 64 3d 3f |OM %s WH|ERE id=?|
|00002380| 74 01 00 00 00 23 52 1c | 00 00 00 52 48 00 00 00 |t....#R.|...RH...|
|00002390| 28 0a 00 00 00 52 25 00 | 00 00 52 49 00 00 00 52 |(....R%.|..RI...R|
|000023a0| 4a 00 00 00 52 13 00 00 | 00 52 15 00 00 00 52 16 |J...R...|.R....R.|
|000023b0| 00 00 00 52 35 00 00 00 | 52 47 00 00 00 74 17 00 |...R5...|RG...t..|
|000023c0| 00 00 64 69 72 74 79 5f | 62 6f 6f 6b 73 5f 72 65 |..dirty_|books_re|
|000023d0| 66 65 72 65 6e 63 69 6e | 67 52 48 00 00 00 28 0b |ferencin|gRH...(.|
|000023e0| 00 00 00 52 11 00 00 00 | 74 06 00 00 00 6f 6c 64 |...R....|t....old|
|000023f0| 5f 69 64 74 08 00 00 00 | 6e 65 77 5f 6e 61 6d 65 |_idt....|new_name|
|00002400| 52 1c 00 00 00 52 12 00 | 00 00 52 57 00 00 00 52 |R....R..|..RW...R|
|00002410| 1a 00 00 00 52 1b 00 00 | 00 74 06 00 00 00 6e 65 |....R...|.t....ne|
|00002420| 77 5f 69 64 74 05 00 00 | 00 62 6f 6f 6b 73 74 07 |w_idt...|.bookst.|
|00002430| 00 00 00 62 6f 6f 6b 5f | 69 64 28 00 00 00 00 28 |...book_|id(....(|
|00002440| 00 00 00 00 73 2f 00 00 | 00 73 69 74 65 2d 70 61 |....s/..|.site-pa|
|00002450| 63 6b 61 67 65 73 5c 63 | 61 6c 69 62 72 65 5c 6c |ckages\c|alibre\l|
|00002460| 69 62 72 61 72 79 5c 63 | 75 73 74 6f 6d 5f 63 6f |ibrary\c|ustom_co|
|00002470| 6c 75 6d 6e 73 2e 70 79 | 74 12 00 00 00 72 65 6e |lumns.py|t....ren|
|00002480| 61 6d 65 5f 63 75 73 74 | 6f 6d 5f 69 74 65 6d ce |ame_cust|om_item.|
|00002490| 00 00 00 73 2c 00 00 00 | 00 01 0d 01 11 01 0d 01 |...s,...|........|
|000024a0| 11 01 19 02 09 01 19 01 | 1a 01 1d 01 0a 04 0b 01 |........|........|
|000024b0| 09 01 13 01 07 00 09 01 | 09 01 1c 01 09 01 14 01 |........|........|
|000024c0| 1a 01 1e 01 63 04 00 00 | 00 07 00 00 00 03 00 00 |....c...|........|
|000024d0| 00 43 80 00 00 73 a5 00 | 00 00 7c 01 00 6f 9a 00 |.C...s..|..|..o..|
|000024e0| 01 7c 02 00 64 00 00 6a | 09 00 6f 11 00 01 7c 00 |.|..d..j|..o...|.|
|000024f0| 00 69 01 00 7c 02 00 19 | 7d 04 00 6e 01 00 01 7c |.i..|...|}..n...||
|00002500| 03 00 64 00 00 6a 09 00 | 6f 11 00 01 7c 00 00 69 |..d..j..|o...|..i|
|00002510| 02 00 7c 03 00 19 7d 04 | 00 6e 01 00 01 7c 00 00 |..|...}.|.n...|..|
|00002520| 69 03 00 7c 04 00 64 01 | 00 19 83 01 00 5c 02 00 |i..|..d.|.....\..|
|00002530| 7d 05 00 7d 06 00 7c 00 | 00 69 04 00 69 05 00 64 |}..}..|.|.i..i..d|
|00002540| 02 00 7c 06 00 16 7c 01 | 00 66 01 00 83 02 00 01 |..|...|.|.f......|
|00002550| 7c 00 00 69 04 00 69 05 | 00 64 03 00 7c 05 00 16 ||..i..i.|.d..|...|
|00002560| 7c 01 00 66 01 00 83 02 | 00 01 7c 00 00 69 04 00 ||..f....|..|..i..|
|00002570| 69 06 00 83 00 00 01 6e | 01 00 01 64 00 00 53 28 |i......n|...d..S(|
|00002580| 04 00 00 00 4e 52 12 00 | 00 00 73 1c 00 00 00 44 |....NR..|..s....D|
|00002590| 45 4c 45 54 45 20 46 52 | 4f 4d 20 25 73 20 57 48 |ELETE FR|OM %s WH|
|000025a0| 45 52 45 20 76 61 6c 75 | 65 3d 3f 73 19 00 00 00 |ERE valu|e=?s....|
|000025b0| 44 45 4c 45 54 45 20 46 | 52 4f 4d 20 25 73 20 57 |DELETE F|ROM %s W|
|000025c0| 48 45 52 45 20 69 64 3d | 3f 28 07 00 00 00 52 25 |HERE id=|?(....R%|
|000025d0| 00 00 00 52 49 00 00 00 | 52 4a 00 00 00 52 13 00 |...RI...|RJ...R..|
|000025e0| 00 00 52 15 00 00 00 52 | 47 00 00 00 52 48 00 00 |..R....R|G...RH..|
|000025f0| 00 28 07 00 00 00 52 11 | 00 00 00 52 6a 00 00 00 |.(....R.|...Rj...|
|00002600| 52 1c 00 00 00 52 12 00 | 00 00 52 57 00 00 00 52 |R....R..|..RW...R|
|00002610| 1a 00 00 00 52 1b 00 00 | 00 28 00 00 00 00 28 00 |....R...|.(....(.|
|00002620| 00 00 00 73 2f 00 00 00 | 73 69 74 65 2d 70 61 63 |...s/...|site-pac|
|00002630| 6b 61 67 65 73 5c 63 61 | 6c 69 62 72 65 5c 6c 69 |kages\ca|libre\li|
|00002640| 62 72 61 72 79 5c 63 75 | 73 74 6f 6d 5f 63 6f 6c |brary\cu|stom_col|
|00002650| 75 6d 6e 73 2e 70 79 74 | 1b 00 00 00 64 65 6c 65 |umns.pyt|....dele|
|00002660| 74 65 5f 63 75 73 74 6f | 6d 5f 69 74 65 6d 5f 75 |te_custo|m_item_u|
|00002670| 73 69 6e 67 5f 69 64 e9 | 00 00 00 73 12 00 00 00 |sing_id.|...s....|
|00002680| 00 01 07 01 0d 01 11 01 | 0d 01 11 01 19 01 1a 01 |........|........|
|00002690| 1a 01 63 04 00 00 00 09 | 00 00 00 05 00 00 00 43 |..c.....|.......C|
|000026a0| 80 00 00 73 e9 00 00 00 | 7c 02 00 64 00 00 6a 09 |...s....||..d..j.|
|000026b0| 00 6f 11 00 01 7c 00 00 | 69 01 00 7c 02 00 19 7d |.o...|..|i..|...}|
|000026c0| 04 00 6e 01 00 01 7c 03 | 00 64 00 00 6a 09 00 6f |..n...|.|.d..j..o|
|000026d0| 11 00 01 7c 00 00 69 02 | 00 7c 03 00 19 7d 04 00 |...|..i.|.|...}..|
|000026e0| 6e 01 00 01 7c 04 00 64 | 01 00 19 64 02 00 6a 03 |n...|..d|...d..j.|
|000026f0| 00 6f 05 00 01 64 00 00 | 53 01 7c 00 00 69 03 00 |.o...d..|S.|..i..|
|00002700| 7c 04 00 64 03 00 19 83 | 01 00 5c 02 00 7d 05 00 ||..d....|..\..}..|
|00002710| 7d 06 00 7c 00 00 69 04 | 00 69 05 00 64 04 00 7c |}..|..i.|.i..d..||
|00002720| 05 00 16 7c 01 00 66 01 | 00 64 05 00 74 06 00 83 |...|..f.|.d..t...|
|00002730| 02 01 7d 07 00 7c 07 00 | 64 00 00 6a 08 00 6f 05 |..}..|..|d..j..o.|
|00002740| 00 01 64 06 00 53 01 7c | 00 00 69 04 00 69 05 00 |..d..S.||..i..i..|
|00002750| 64 07 00 69 07 00 64 08 | 00 7c 06 00 83 00 01 7c |d..i..d.|.|.....||
|00002760| 07 00 66 01 00 64 05 00 | 74 06 00 83 02 01 7d 08 |..f..d..|t.....}.|
|00002770| 00 7c 08 00 64 00 00 6a | 08 00 6f 05 00 01 64 06 |.|..d..j|..o...d.|
|00002780| 00 53 01 74 08 00 7c 08 | 00 64 09 00 17 83 01 00 |.S.t..|.|.d......|
|00002790| 53 28 0a 00 00 00 4e 52 | 1e 00 00 00 52 0f 00 00 |S(....NR|....R...|
|000027a0| 00 52 12 00 00 00 73 1f | 00 00 00 53 45 4c 45 43 |.R....s.|...SELEC|
|000027b0| 54 20 69 64 20 66 72 6f | 6d 20 25 73 20 57 48 45 |T id fro|m %s WHE|
|000027c0| 52 45 20 76 61 6c 75 65 | 3d 3f 52 69 00 00 00 67 |RE value|=?Ri...g|
|000027d0| 00 00 00 00 00 00 f0 3f | 73 8b 00 00 00 0a 20 20 |.......?|s.....  |
|000027e0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 53 45 |        |      SE|
|000027f0| 4c 45 43 54 20 4d 41 58 | 28 7b 6c 74 7d 2e 65 78 |LECT MAX|({lt}.ex|
|00002800| 74 72 61 29 20 46 52 4f | 4d 20 7b 6c 74 7d 0a 20 |tra) FRO|M {lt}. |
|00002810| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 57 |        |       W|
|00002820| 48 45 52 45 20 7b 6c 74 | 7d 2e 62 6f 6f 6b 20 49 |HERE {lt|}.book I|
|00002830| 4e 20 28 53 45 4c 45 43 | 54 20 62 6f 6f 6b 20 46 |N (SELEC|T book F|
|00002840| 52 4f 4d 20 7b 6c 74 7d | 20 77 68 65 72 65 20 76 |ROM {lt}| where v|
|00002850| 61 6c 75 65 3d 3f 29 0a | 20 20 20 20 20 20 20 20 |alue=?).|        |
|00002860| 20 20 20 20 20 20 20 20 | 52 1b 00 00 00 69 01 00 |        |R....i..|
|00002870| 00 00 28 09 00 00 00 52 | 25 00 00 00 52 49 00 00 |..(....R|%...RI..|
|00002880| 00 52 4a 00 00 00 52 13 | 00 00 00 52 15 00 00 00 |.RJ...R.|...R....|
|00002890| 52 16 00 00 00 52 35 00 | 00 00 52 46 00 00 00 52 |R....R5.|..RF...R|
|000028a0| 02 00 00 00 28 09 00 00 | 00 52 11 00 00 00 52 0f |....(...|.R....R.|
|000028b0| 00 00 00 52 1c 00 00 00 | 52 12 00 00 00 52 57 00 |...R....|R....RW.|
|000028c0| 00 00 52 1a 00 00 00 52 | 1b 00 00 00 74 09 00 00 |..R....R|....t...|
|000028d0| 00 73 65 72 69 65 73 5f | 69 64 74 0a 00 00 00 73 |.series_|idt....s|
|000028e0| 65 72 69 65 73 5f 6e 75 | 6d 28 00 00 00 00 28 00 |eries_nu|m(....(.|
|000028f0| 00 00 00 73 2f 00 00 00 | 73 69 74 65 2d 70 61 63 |...s/...|site-pac|
|00002900| 6b 61 67 65 73 5c 63 61 | 6c 69 62 72 65 5c 6c 69 |kages\ca|libre\li|
|00002910| 62 72 61 72 79 5c 63 75 | 73 74 6f 6d 5f 63 6f 6c |brary\cu|stom_col|
|00002920| 75 6d 6e 73 2e 70 79 74 | 1a 00 00 00 67 65 74 5f |umns.pyt|....get_|
|00002930| 6e 65 78 74 5f 63 63 5f | 73 65 72 69 65 73 5f 6e |next_cc_|series_n|
|00002940| 75 6d 5f 66 6f 72 f5 00 | 00 00 73 20 00 00 00 00 |um_for..|..s ....|
|00002950| 01 0d 01 11 01 0d 01 11 | 01 11 01 05 01 19 02 10 |........|........|
|00002960| 01 12 01 0d 01 05 02 09 | 03 21 01 0d 01 05 01 63 |........|.!.....c|
|00002970| 03 00 00 00 09 00 00 00 | 06 00 00 00 43 80 00 00 |........|....C...|
|00002980| 73 bf 00 00 00 7c 01 00 | 64 00 00 6a 09 00 6f 11 |s....|..|d..j..o.|
|00002990| 00 01 7c 00 00 69 01 00 | 7c 01 00 19 7d 03 00 6e |..|..i..||...}..n|
|000029a0| 01 00 01 7c 02 00 64 00 | 00 6a 09 00 6f 11 00 01 |...|..d.|.j..o...|
|000029b0| 7c 00 00 69 02 00 7c 02 | 00 19 7d 03 00 6e 01 00 ||..i..|.|..}..n..|
|000029c0| 01 7c 00 00 69 03 00 7c | 03 00 64 01 00 19 83 01 |.|..i..||..d.....|
|000029d0| 00 5c 02 00 7d 04 00 7d | 05 00 7c 03 00 64 02 00 |.\..}..}|..|..d..|
|000029e0| 19 6f 1a 00 01 7c 00 00 | 69 04 00 69 05 00 64 03 |.o...|..|i..i..d.|
|000029f0| 00 7c 04 00 16 83 01 00 | 7d 06 00 6e 17 00 01 7c |.|......|}..n...||
|00002a00| 00 00 69 04 00 69 05 00 | 64 04 00 7c 04 00 16 83 |..i..i..|d..|....|
|00002a10| 01 00 7d 06 00 74 06 00 | 67 00 00 04 7d 07 00 7c |..}..t..|g...}..||
|00002a20| 06 00 44 5d 11 00 7d 08 | 00 7c 07 00 7c 08 00 64 |..D]..}.|.|..|..d|
|00002a30| 05 00 19 12 71 9e 00 7e | 07 00 83 01 00 7d 06 00 |....q..~|.....}..|
|00002a40| 7c 06 00 53 28 06 00 00 | 00 4e 52 12 00 00 00 52 ||..S(...|.NR....R|
|00002a50| 21 00 00 00 73 14 00 00 | 00 53 45 4c 45 43 54 20 |!...s...|.SELECT |
|00002a60| 76 61 6c 75 65 20 46 52 | 4f 4d 20 25 73 73 1d 00 |value FR|OM %ss..|
|00002a70| 00 00 53 45 4c 45 43 54 | 20 44 49 53 54 49 4e 43 |..SELECT| DISTINC|
|00002a80| 54 20 76 61 6c 75 65 20 | 46 52 4f 4d 20 25 73 69 |T value |FROM %si|
|00002a90| 00 00 00 00 28 07 00 00 | 00 52 25 00 00 00 52 49 |....(...|.R%...RI|
|00002aa0| 00 00 00 52 4a 00 00 00 | 52 13 00 00 00 52 15 00 |...RJ...|R....R..|
|00002ab0| 00 00 52 16 00 00 00 52 | 14 00 00 00 28 09 00 00 |..R....R|....(...|
|00002ac0| 00 52 11 00 00 00 52 1c | 00 00 00 52 12 00 00 00 |.R....R.|...R....|
|00002ad0| 52 57 00 00 00 52 1a 00 | 00 00 52 1b 00 00 00 52 |RW...R..|..R....R|
|00002ae0| 67 00 00 00 52 17 00 00 | 00 52 18 00 00 00 28 00 |g...R...|.R....(.|
|00002af0| 00 00 00 28 00 00 00 00 | 73 2f 00 00 00 73 69 74 |...(....|s/...sit|
|00002b00| 65 2d 70 61 63 6b 61 67 | 65 73 5c 63 61 6c 69 62 |e-packag|es\calib|
|00002b10| 72 65 5c 6c 69 62 72 61 | 72 79 5c 63 75 73 74 6f |re\libra|ry\custo|
|00002b20| 6d 5f 63 6f 6c 75 6d 6e | 73 2e 70 79 74 0a 00 00 |m_column|s.pyt...|
|00002b30| 00 61 6c 6c 5f 63 75 73 | 74 6f 6d 0b 01 00 00 73 |.all_cus|tom....s|
|00002b40| 14 00 00 00 00 01 0d 01 | 11 01 0d 01 11 01 19 01 |........|........|
|00002b50| 0b 01 1a 02 16 01 2b 01 | 63 03 00 00 00 04 00 00 |......+.|c.......|
|00002b60| 00 04 00 00 00 43 80 00 | 00 73 8a 00 00 00 64 00 |.....C..|.s....d.|
|00002b70| 00 7d 03 00 7c 01 00 64 | 00 00 6a 09 00 6f 11 00 |.}..|..d|..j..o..|
|00002b80| 01 7c 00 00 69 01 00 7c | 01 00 19 7d 03 00 6e 01 |.|..i..||...}..n.|
|00002b90| 00 01 7c 02 00 64 00 00 | 6a 09 00 6f 11 00 01 7c |..|..d..|j..o...||
|00002ba0| 00 00 69 02 00 7c 02 00 | 19 7d 03 00 6e 01 00 01 |..i..|..|.}..n...|
|00002bb0| 7c 03 00 64 00 00 6a 08 | 00 6f 10 00 01 74 03 00 ||..d..j.|.o...t..|
|00002bc0| 64 01 00 83 01 00 82 01 | 00 6e 01 00 01 7c 00 00 |d.......|.n...|..|
|00002bd0| 69 04 00 69 05 00 64 02 | 00 7c 03 00 64 03 00 19 |i..i..d.|.|..d...|
|00002be0| 66 01 00 83 02 00 01 7c | 00 00 69 04 00 69 06 00 |f......||..i..i..|
|00002bf0| 83 00 00 01 64 00 00 53 | 28 04 00 00 00 4e 73 0e |....d..S|(....Ns.|
|00002c00| 00 00 00 4e 6f 20 73 75 | 63 68 20 63 6f 6c 75 6d |...No su|ch colum|
|00002c10| 6e 73 36 00 00 00 55 50 | 44 41 54 45 20 63 75 73 |ns6...UP|DATE cus|
|00002c20| 74 6f 6d 5f 63 6f 6c 75 | 6d 6e 73 20 53 45 54 20 |tom_colu|mns SET |
|00002c30| 6d 61 72 6b 5f 66 6f 72 | 5f 64 65 6c 65 74 65 3d |mark_for|_delete=|
|00002c40| 31 20 57 48 45 52 45 20 | 69 64 3d 3f 52 12 00 00 |1 WHERE |id=?R...|
|00002c50| 00 28 07 00 00 00 52 25 | 00 00 00 52 49 00 00 00 |.(....R%|...RI...|
|00002c60| 52 4a 00 00 00 52 44 00 | 00 00 52 15 00 00 00 52 |RJ...RD.|..R....R|
|00002c70| 47 00 00 00 52 48 00 00 | 00 28 04 00 00 00 52 11 |G...RH..|.(....R.|
|00002c80| 00 00 00 52 1c 00 00 00 | 52 12 00 00 00 52 57 00 |...R....|R....RW.|
|00002c90| 00 00 28 00 00 00 00 28 | 00 00 00 00 73 2f 00 00 |..(....(|....s/..|
|00002ca0| 00 73 69 74 65 2d 70 61 | 63 6b 61 67 65 73 5c 63 |.site-pa|ckages\c|
|00002cb0| 61 6c 69 62 72 65 5c 6c | 69 62 72 61 72 79 5c 63 |alibre\l|ibrary\c|
|00002cc0| 75 73 74 6f 6d 5f 63 6f | 6c 75 6d 6e 73 2e 70 79 |ustom_co|lumns.py|
|00002cd0| 74 14 00 00 00 64 65 6c | 65 74 65 5f 63 75 73 74 |t....del|ete_cust|
|00002ce0| 6f 6d 5f 63 6f 6c 75 6d | 6e 18 01 00 00 73 16 00 |om_colum|n....s..|
|00002cf0| 00 00 00 01 06 01 0d 01 | 11 01 0d 01 11 01 0d 01 |........|........|
|00002d00| 10 01 09 01 03 01 0e 01 | 63 06 00 00 00 07 00 00 |........|c.......|
|00002d10| 00 04 00 00 00 43 80 00 | 00 73 08 01 00 00 74 00 |.....C..|.s....t.|
|00002d20| 00 7d 06 00 7c 02 00 64 | 00 00 6a 09 00 6f 23 00 |.}..|..d|..j..o#.|
|00002d30| 01 7c 00 00 69 02 00 69 | 03 00 64 01 00 7c 02 00 |.|..i..i|..d..|..|
|00002d40| 7c 01 00 66 02 00 83 02 | 00 01 74 04 00 7d 06 00 ||..f....|..t..}..|
|00002d50| 6e 01 00 01 7c 03 00 64 | 00 00 6a 09 00 6f 23 00 |n...|..d|..j..o#.|
|00002d60| 01 7c 00 00 69 02 00 69 | 03 00 64 02 00 7c 03 00 |.|..i..i|..d..|..|
|00002d70| 7c 01 00 66 02 00 83 02 | 00 01 74 04 00 7d 06 00 ||..f....|..t..}..|
|00002d80| 6e 01 00 01 7c 04 00 64 | 00 00 6a 09 00 6f 40 00 |n...|..d|..j..o@.|
|00002d90| 01 7c 00 00 69 02 00 69 | 03 00 64 03 00 74 05 00 |.|..i..i|..d..t..|
|00002da0| 7c 04 00 83 01 00 7c 01 | 00 66 02 00 83 02 00 01 ||.....|.|.f......|
|00002db0| 74 05 00 7c 04 00 83 01 | 00 7c 00 00 69 06 00 7c |t..|....|.|..i..||
|00002dc0| 01 00 19 64 04 00 3c 74 | 04 00 7d 06 00 6e 01 00 |...d..<t|..}..n..|
|00002dd0| 01 7c 05 00 64 00 00 6a | 09 00 6f 2c 00 01 7c 00 |.|..d..j|..o,..|.|
|00002de0| 00 69 02 00 69 03 00 64 | 05 00 74 07 00 69 08 00 |.i..i..d|..t..i..|
|00002df0| 7c 05 00 83 01 00 7c 01 | 00 66 02 00 83 02 00 01 ||.....|.|.f......|
|00002e00| 74 04 00 7d 06 00 6e 01 | 00 01 7c 06 00 6f 11 00 |t..}..n.|..|..o..|
|00002e10| 01 7c 00 00 69 02 00 69 | 09 00 83 00 00 01 6e 01 |.|..i..i|......n.|
|00002e20| 00 01 7c 06 00 53 28 06 | 00 00 00 4e 73 2b 00 00 |..|..S(.|...Ns+..|
|00002e30| 00 55 50 44 41 54 45 20 | 63 75 73 74 6f 6d 5f 63 |.UPDATE |custom_c|
|00002e40| 6f 6c 75 6d 6e 73 20 53 | 45 54 20 6e 61 6d 65 3d |olumns S|ET name=|
|00002e50| 3f 20 57 48 45 52 45 20 | 69 64 3d 3f 73 2c 00 00 |? WHERE |id=?s,..|
|00002e60| 00 55 50 44 41 54 45 20 | 63 75 73 74 6f 6d 5f 63 |.UPDATE |custom_c|
|00002e70| 6f 6c 75 6d 6e 73 20 53 | 45 54 20 6c 61 62 65 6c |olumns S|ET label|
|00002e80| 3d 3f 20 57 48 45 52 45 | 20 69 64 3d 3f 73 2f 00 |=? WHERE| id=?s/.|
|00002e90| 00 00 55 50 44 41 54 45 | 20 63 75 73 74 6f 6d 5f |..UPDATE| custom_|
|00002ea0| 63 6f 6c 75 6d 6e 73 20 | 53 45 54 20 65 64 69 74 |columns |SET edit|
|00002eb0| 61 62 6c 65 3d 3f 20 57 | 48 45 52 45 20 69 64 3d |able=? W|HERE id=|
|00002ec0| 3f 52 40 00 00 00 73 2e | 00 00 00 55 50 44 41 54 |?R@...s.|...UPDAT|
|00002ed0| 45 20 63 75 73 74 6f 6d | 5f 63 6f 6c 75 6d 6e 73 |E custom|_columns|
|00002ee0| 20 53 45 54 20 64 69 73 | 70 6c 61 79 3d 3f 20 57 | SET dis|play=? W|
|00002ef0| 48 45 52 45 20 69 64 3d | 3f 28 0a 00 00 00 52 35 |HERE id=|?(....R5|
|00002f00| 00 00 00 52 25 00 00 00 | 52 15 00 00 00 52 47 00 |...R%...|R....RG.|
|00002f10| 00 00 52 51 00 00 00 52 | 0e 00 00 00 52 4a 00 00 |..RQ...R|....RJ..|
|00002f20| 00 52 4b 00 00 00 74 05 | 00 00 00 64 75 6d 70 73 |.RK...t.|...dumps|
|00002f30| 52 48 00 00 00 28 07 00 | 00 00 52 11 00 00 00 52 |RH...(..|..R....R|
|00002f40| 12 00 00 00 52 1d 00 00 | 00 52 1c 00 00 00 52 40 |....R...|.R....R@|
|00002f50| 00 00 00 52 20 00 00 00 | 74 07 00 00 00 63 68 61 |...R ...|t....cha|
|00002f60| 6e 67 65 64 28 00 00 00 | 00 28 00 00 00 00 73 2f |nged(...|.(....s/|
|00002f70| 00 00 00 73 69 74 65 2d | 70 61 63 6b 61 67 65 73 |...site-|packages|
|00002f80| 5c 63 61 6c 69 62 72 65 | 5c 6c 69 62 72 61 72 79 |\calibre|\library|
|00002f90| 5c 63 75 73 74 6f 6d 5f | 63 6f 6c 75 6d 6e 73 2e |\custom_|columns.|
|00002fa0| 70 79 74 1a 00 00 00 73 | 65 74 5f 63 75 73 74 6f |pyt....s|et_custo|
|00002fb0| 6d 5f 63 6f 6c 75 6d 6e | 5f 6d 65 74 61 64 61 74 |m_column|_metadat|
|00002fc0| 61 25 01 00 00 73 2a 00 | 00 00 00 02 06 01 0d 01 |a%...s*.|........|
|00002fd0| 0c 01 0d 01 0a 01 0d 01 | 0c 01 0d 01 0a 01 0d 01 |........|........|
|00002fe0| 0c 01 13 01 17 01 0a 01 | 0d 01 0c 01 16 01 0a 02 |........|........|
|00002ff0| 07 01 11 01 63 07 00 00 | 00 1c 00 00 00 15 00 00 |....c...|........|
|00003000| 00 43 80 00 00 73 f1 03 | 00 00 7c 04 00 64 00 00 |.C...s..|..|..d..|
|00003010| 6a 09 00 6f 11 00 01 7c | 00 00 69 01 00 7c 04 00 |j..o...||..i..|..|
|00003020| 19 7d 07 00 6e 01 00 01 | 7c 05 00 64 00 00 6a 09 |.}..n...||..d..j.|
|00003030| 00 6f 11 00 01 7c 00 00 | 69 02 00 7c 05 00 19 7d |.o...|..|i..|...}|
|00003040| 07 00 6e 01 00 01 7c 07 | 00 64 01 00 19 70 18 00 |..n...|.|.d...p..|
|00003050| 01 74 03 00 64 02 00 7c | 07 00 64 03 00 19 16 83 |.t..d..||..d.....|
|00003060| 01 00 82 01 00 6e 01 00 | 01 7c 07 00 64 04 00 19 |.....n..|.|..d...|
|00003070| 64 05 00 6a 03 00 70 0c | 00 01 7c 07 00 64 06 00 |d..j..p.|..|..d..|
|00003080| 19 0c 6f 18 00 01 74 03 | 00 64 07 00 7c 07 00 64 |..o...t.|.d..|..d|
|00003090| 03 00 19 16 83 01 00 82 | 01 00 6e 01 00 01 7c 00 |........|..n...|.|
|000030a0| 00 69 04 00 7c 02 00 83 | 01 00 7d 02 00 7c 00 00 |.i..|...|..}..|..|
|000030b0| 69 04 00 7c 03 00 83 01 | 00 7d 03 00 74 05 00 7c |i..|....|.}..t..||
|000030c0| 03 00 83 01 00 74 05 00 | 7c 02 00 83 01 00 18 7d |.....t..||......}|
|000030d0| 03 00 7c 01 00 0c 70 10 | 00 01 7c 02 00 0c 6f 0d |..|...p.|..|...o.|
|000030e0| 00 01 7c 03 00 0c 6f 05 | 00 01 64 00 00 53 01 7c |..|...o.|..d..S.||
|000030f0| 00 00 69 06 00 7c 07 00 | 64 08 00 19 83 01 00 5c |..i..|..|d......\|
|00003100| 02 00 7d 08 00 7d 09 00 | 7c 00 00 69 07 00 64 08 |..}..}..||..i..d.|
|00003110| 00 7c 07 00 64 08 00 19 | 83 00 01 7d 0a 00 67 00 |.|..d...|...}..g.|
|00003120| 00 04 7d 0b 00 7c 0a 00 | 44 5d 13 00 7d 0c 00 7c |..}..|..|D]..}..||
|00003130| 0b 00 7c 0c 00 69 08 00 | 83 00 00 12 71 1f 01 7e |..|..i..|....q..~|
|00003140| 0b 00 7d 0d 00 67 00 00 | 04 7d 0e 00 7c 02 00 44 |..}..g..|.}..|..D|
|00003150| 5d 24 00 7d 0c 00 7c 0c | 00 69 08 00 83 00 00 7c |]$.}..|.|.i.....||
|00003160| 0d 00 6a 07 00 6f 0b 00 | 01 7c 0e 00 7c 0c 00 12 |..j..o..|.|..|...|
|00003170| 71 46 01 01 71 46 01 7e | 0e 00 7d 0f 00 7c 0f 00 |qF..qF.~|..}..|..|
|00003180| 6f 39 00 01 7c 00 00 69 | 09 00 69 0a 00 64 09 00 |o9..|..i|..i..d..|
|00003190| 7c 08 00 16 67 00 00 04 | 7d 10 00 7c 0f 00 44 5d ||...g...|}..|..D]|
|000031a0| 10 00 7d 11 00 7c 10 00 | 7c 11 00 66 01 00 12 71 |..}..|..||..f...q|
|000031b0| 95 01 7e 10 00 83 02 00 | 01 6e 01 00 01 64 1e 00 |..~.....|.n...d..|
|000031c0| 7d 12 00 64 0d 00 69 0b | 00 67 00 00 04 7d 13 00 |}..d..i.|.g...}..|
|000031d0| 7c 12 00 44 5d 11 00 7d | 0c 00 7c 13 00 64 0e 00 ||..D]..}|..|..d..|
|000031e0| 7c 0c 00 16 12 71 ca 01 | 7e 13 00 83 01 00 7d 14 ||....q..|~.....}.|
|000031f0| 00 64 0d 00 69 0b 00 67 | 00 00 04 7d 15 00 7c 12 |.d..i..g|...}..|.|
|00003200| 00 44 5d 11 00 7d 0c 00 | 7c 15 00 64 0f 00 7c 0c |.D]..}..||..d..|.|
|00003210| 00 16 12 71 f8 01 7e 15 | 00 83 01 00 7d 16 00 7c |...q..~.|....}..||
|00003220| 00 00 69 09 00 69 0c 00 | 7c 14 00 7c 16 00 17 83 |..i..i..||..|....|
|00003230| 01 00 01 7c 00 00 69 09 | 00 69 0a 00 64 10 00 67 |...|..i.|.i..d..g|
|00003240| 00 00 04 7d 17 00 7c 01 | 00 44 5d 10 00 7d 11 00 |...}..|.|.D]..}..|
|00003250| 7c 17 00 7c 11 00 66 01 | 00 12 71 40 02 7e 17 00 ||..|..f.|..q@.~..|
|00003260| 83 02 00 01 78 85 00 74 | 0d 00 7c 02 00 7c 03 00 |....x..t|..|..|..|
|00003270| 67 02 00 83 01 00 44 5d | 71 00 5c 02 00 7d 18 00 |g.....D]|q.\..}..|
|00003280| 7d 19 00 7c 19 00 70 07 | 00 01 71 6d 02 6e 01 00 |}..|..p.|..qm.n..|
|00003290| 01 7c 12 00 7c 18 00 64 | 11 00 17 19 7d 18 00 64 |.|..|..d|....}..d|
|000032a0| 12 00 69 0e 00 64 13 00 | 7c 18 00 64 14 00 7c 08 |..i..d..||..d..|.|
|000032b0| 00 83 00 02 7d 1a 00 7c | 00 00 69 09 00 69 0a 00 |....}..||..i..i..|
|000032c0| 7c 1a 00 67 00 00 04 7d | 1b 00 7c 19 00 44 5d 10 ||..g...}|..|..D].|
|000032d0| 00 7d 11 00 7c 1b 00 7c | 11 00 66 01 00 12 71 c4 |.}..|..||..f...q.|
|000032e0| 02 7e 1b 00 83 02 00 01 | 71 6d 02 57 7c 03 00 6f |.~......|qm.W|..o|
|000032f0| 29 00 01 7c 00 00 69 09 | 00 69 0f 00 64 15 00 7c |)..|..i.|.i..d..||
|00003300| 09 00 7c 12 00 64 16 00 | 19 7c 12 00 64 17 00 19 |..|..d..|.|..d...|
|00003310| 66 03 00 16 83 01 00 01 | 6e 01 00 01 7c 02 00 6f |f.......|n...|..o|
|00003320| 2b 00 01 7c 00 00 69 09 | 00 69 0f 00 64 18 00 69 |+..|..i.|.i..d..i|
|00003330| 0e 00 7c 09 00 7c 12 00 | 64 16 00 19 7c 12 00 64 |..|..|..|d...|..d|
|00003340| 11 00 19 83 03 00 83 01 | 00 01 6e 01 00 01 7c 00 |........|..n...|.|
|00003350| 00 69 09 00 69 0c 00 7c | 14 00 83 01 00 01 7c 00 |.i..i..||......|.|
|00003360| 00 69 10 00 7c 01 00 64 | 19 00 74 11 00 83 01 01 |.i..|..d|..t.....|
|00003370| 01 7c 00 00 69 09 00 69 | 12 00 83 00 00 01 78 5b |.|..i..i|......x[|
|00003380| 00 7c 01 00 44 5d 53 00 | 7d 11 00 7c 00 00 69 09 |.|..D]S.|}..|..i.|
|00003390| 00 69 13 00 64 1a 00 7c | 07 00 64 08 00 19 16 7c |.i..d..||..d....||
|000033a0| 11 00 66 01 00 64 1b 00 | 74 11 00 83 02 01 7d 19 |..f..d..|t.....}.|
|000033b0| 00 7c 00 00 69 14 00 69 | 05 00 7c 11 00 7c 00 00 |.|..i..i|..|..|..|
|000033c0| 69 15 00 7c 07 00 64 08 | 00 19 19 7c 19 00 64 1c |i..|..d.|...|..d.|
|000033d0| 00 74 16 00 83 03 01 01 | 71 7b 03 57 7c 06 00 6f |.t......|q{.W|..o|
|000033e0| 14 00 01 7c 00 00 69 17 | 00 64 1d 00 7c 01 00 83 |...|..i.|.d..|...|
|000033f0| 02 00 01 6e 01 00 01 64 | 00 00 53 28 1f 00 00 00 |...n...d|..S(....|
|00003400| 4e 52 1f 00 00 00 73 19 | 00 00 00 43 6f 6c 75 6d |NR....s.|...Colum|
|00003410| 6e 20 25 72 20 69 73 20 | 6e 6f 74 20 65 64 69 74 |n %r is |not edit|
|00003420| 61 62 6c 65 52 1c 00 00 | 00 52 1e 00 00 00 52 09 |ableR...|.R....R.|
|00003430| 00 00 00 52 22 00 00 00 | 73 1e 00 00 00 43 6f 6c |...R"...|s....Col|
|00003440| 75 6d 6e 20 25 72 20 69 | 73 20 6e 6f 74 20 74 65 |umn %r i|s not te|
|00003450| 78 74 2f 6d 75 6c 74 69 | 70 6c 65 52 12 00 00 00 |xt/multi|pleR....|
|00003460| 73 20 00 00 00 49 4e 53 | 45 52 54 20 49 4e 54 4f |s ...INS|ERT INTO|
|00003470| 20 25 73 28 76 61 6c 75 | 65 29 20 56 41 4c 55 45 | %s(valu|e) VALUE|
|00003480| 53 20 28 3f 29 74 18 00 | 00 00 74 65 6d 70 5f 62 |S (?)t..|..temp_b|
|00003490| 75 6c 6b 5f 74 61 67 5f | 65 64 69 74 5f 62 6f 6f |ulk_tag_|edit_boo|
|000034a0| 6b 73 74 16 00 00 00 74 | 65 6d 70 5f 62 75 6c 6b |kst....t|emp_bulk|
|000034b0| 5f 74 61 67 5f 65 64 69 | 74 5f 61 64 64 74 19 00 |_tag_edi|t_addt..|
|000034c0| 00 00 74 65 6d 70 5f 62 | 75 6c 6b 5f 74 61 67 5f |..temp_b|ulk_tag_|
|000034d0| 65 64 69 74 5f 72 65 6d | 6f 76 65 73 01 00 00 00 |edit_rem|oves....|
|000034e0| 0a 73 18 00 00 00 44 52 | 4f 50 20 54 41 42 4c 45 |.s....DR|OP TABLE|
|000034f0| 20 49 46 20 45 58 49 53 | 54 53 20 25 73 3b 73 2d | IF EXIS|TS %s;s-|
|00003500| 00 00 00 43 52 45 41 54 | 45 20 54 45 4d 50 20 54 |...CREAT|E TEMP T|
|00003510| 41 42 4c 45 20 25 73 28 | 69 64 20 49 4e 54 45 47 |ABLE %s(|id INTEG|
|00003520| 45 52 20 50 52 49 4d 41 | 52 59 20 4b 45 59 29 3b |ER PRIMA|RY KEY);|
|00003530| 73 2f 00 00 00 49 4e 53 | 45 52 54 20 49 4e 54 4f |s/...INS|ERT INTO|
|00003540| 20 74 65 6d 70 5f 62 75 | 6c 6b 5f 74 61 67 5f 65 | temp_bu|lk_tag_e|
|00003550| 64 69 74 5f 62 6f 6f 6b | 73 20 56 41 4c 55 45 53 |dit_book|s VALUES|
|00003560| 20 28 3f 29 69 01 00 00 | 00 73 54 00 00 00 49 4e | (?)i...|.sT...IN|
|00003570| 53 45 52 54 20 49 4e 54 | 4f 20 7b 74 74 7d 28 69 |SERT INT|O {tt}(i|
|00003580| 64 29 20 53 45 4c 45 43 | 54 20 7b 63 74 7d 2e 69 |d) SELEC|T {ct}.i|
|00003590| 64 20 46 52 4f 4d 20 7b | 63 74 7d 20 57 48 45 52 |d FROM {|ct} WHER|
|000035a0| 45 20 76 61 6c 75 65 3d | 3f 20 43 4f 4c 4c 41 54 |E value=|? COLLAT|
|000035b0| 45 20 50 59 4e 4f 43 41 | 53 45 20 4c 49 4d 49 54 |E PYNOCA|SE LIMIT|
|000035c0| 20 31 74 02 00 00 00 74 | 74 74 02 00 00 00 63 74 | 1t....t|tt....ct|
|000035d0| 73 79 00 00 00 44 45 4c | 45 54 45 20 46 52 4f 4d |sy...DEL|ETE FROM|
|000035e0| 20 25 73 20 57 48 45 52 | 45 0a 20 20 20 20 20 20 | %s WHER|E.      |
|000035f0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 62 6f |        |      bo|
|00003600| 6f 6b 20 49 4e 20 28 53 | 45 4c 45 43 54 20 69 64 |ok IN (S|ELECT id|
|00003610| 20 46 52 4f 4d 20 25 73 | 29 20 41 4e 44 0a 20 20 | FROM %s|) AND.  |
|00003620| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |        |        |
|00003630| 20 20 76 61 6c 75 65 20 | 49 4e 20 28 53 45 4c 45 |  value |IN (SELE|
|00003640| 43 54 20 69 64 20 46 52 | 4f 4d 20 25 73 29 69 00 |CT id FR|OM %s)i.|
|00003650| 00 00 00 69 02 00 00 00 | 73 65 00 00 00 0a 20 20 |...i....|se....  |
|00003660| 20 20 20 20 20 20 20 20 | 20 20 49 4e 53 45 52 54 |        |  INSERT|
|00003670| 20 4f 52 20 52 45 50 4c | 41 43 45 20 49 4e 54 4f | OR REPL|ACE INTO|
|00003680| 20 7b 30 7d 28 62 6f 6f | 6b 2c 20 76 61 6c 75 65 | {0}(boo|k, value|
|00003690| 29 20 53 45 4c 45 43 54 | 20 7b 31 7d 2e 69 64 2c |) SELECT| {1}.id,|
|000036a0| 20 7b 32 7d 2e 69 64 20 | 46 52 4f 4d 20 7b 31 7d | {2}.id |FROM {1}|
|000036b0| 2c 20 7b 32 7d 0a 20 20 | 20 20 20 20 20 20 20 20 |, {2}.  |        |
|000036c0| 20 20 52 48 00 00 00 73 | 26 00 00 00 53 45 4c 45 |  RH...s|&...SELE|
|000036d0| 43 54 20 63 75 73 74 6f | 6d 5f 25 73 20 46 52 4f |CT custo|m_%s FRO|
|000036e0| 4d 20 6d 65 74 61 32 20 | 57 48 45 52 45 20 69 64 |M meta2 |WHERE id|
|000036f0| 3d 3f 52 69 00 00 00 74 | 09 00 00 00 72 6f 77 5f |=?Ri...t|....row_|
|00003700| 69 73 5f 69 64 74 08 00 | 00 00 6d 65 74 61 64 61 |is_idt..|..metada|
|00003710| 74 61 28 03 00 00 00 52 | 7f 00 00 00 52 80 00 00 |ta(....R|....R...|
|00003720| 00 52 81 00 00 00 28 18 | 00 00 00 52 25 00 00 00 |.R....(.|...R%...|
|00003730| 52 49 00 00 00 52 4a 00 | 00 00 52 44 00 00 00 74 |RI...RJ.|..RD...t|
|00003740| 0c 00 00 00 63 6c 65 61 | 6e 75 70 5f 74 61 67 73 |....clea|nup_tags|
|00003750| 52 14 00 00 00 52 13 00 | 00 00 52 7a 00 00 00 52 |R....R..|..Rz...R|
|00003760| 60 00 00 00 52 15 00 00 | 00 74 0b 00 00 00 65 78 |`...R...|.t....ex|
|00003770| 65 63 75 74 65 6d 61 6e | 79 52 2d 00 00 00 52 45 |ecuteman|yR-...RE|
|00003780| 00 00 00 74 09 00 00 00 | 65 6e 75 6d 65 72 61 74 |...t....|enumerat|
|00003790| 65 52 46 00 00 00 52 47 | 00 00 00 74 07 00 00 00 |eRF...RG|...t....|
|000037a0| 64 69 72 74 69 65 64 52 | 35 00 00 00 52 48 00 00 |dirtiedR|5...RH..|
|000037b0| 00 52 16 00 00 00 52 57 | 00 00 00 52 62 00 00 00 |.R....RW|...Rb...|
|000037c0| 52 51 00 00 00 74 06 00 | 00 00 6e 6f 74 69 66 79 |RQ...t..|..notify|
|000037d0| 28 1c 00 00 00 52 11 00 | 00 00 74 03 00 00 00 69 |(....R..|..t....i|
|000037e0| 64 73 74 03 00 00 00 61 | 64 64 52 56 00 00 00 52 |dst....a|ddRV...R|
|000037f0| 1c 00 00 00 52 12 00 00 | 00 52 8a 00 00 00 52 57 |....R...|.R....RW|
|00003800| 00 00 00 74 0a 00 00 00 | 63 75 73 74 5f 74 61 62 |...t....|cust_tab|
|00003810| 6c 65 74 0a 00 00 00 6c | 69 6e 6b 5f 74 61 62 6c |let....l|ink_tabl|
|00003820| 65 74 08 00 00 00 61 6c | 6c 5f 74 61 67 73 52 17 |et....al|l_tagsR.|
|00003830| 00 00 00 74 01 00 00 00 | 74 52 1b 00 00 00 52 30 |...t....|tR....R0|
|00003840| 00 00 00 74 08 00 00 00 | 6e 65 77 5f 74 61 67 73 |...t....|new_tags|
|00003850| 52 31 00 00 00 52 18 00 | 00 00 74 0b 00 00 00 74 |R1...R..|..t....t|
|00003860| 65 6d 70 5f 74 61 62 6c | 65 73 74 04 00 00 00 5f |emp_tabl|est...._|
|00003870| 5b 34 5d 74 05 00 00 00 | 64 72 6f 70 73 74 04 00 |[4]t....|dropst..|
|00003880| 00 00 5f 5b 35 5d 74 07 | 00 00 00 63 72 65 61 74 |.._[5]t.|...creat|
|00003890| 65 73 74 04 00 00 00 5f | 5b 36 5d 52 1a 00 00 00 |est...._|[6]R....|
|000038a0| 74 04 00 00 00 74 61 67 | 73 74 06 00 00 00 69 6e |t....tag|st....in|
|000038b0| 73 65 72 74 74 04 00 00 | 00 5f 5b 37 5d 28 00 00 |sertt...|._[7](..|
|000038c0| 00 00 28 00 00 00 00 73 | 2f 00 00 00 73 69 74 65 |..(....s|/...site|
|000038d0| 2d 70 61 63 6b 61 67 65 | 73 5c 63 61 6c 69 62 72 |-package|s\calibr|
|000038e0| 65 5c 6c 69 62 72 61 72 | 79 5c 63 75 73 74 6f 6d |e\librar|y\custom|
|000038f0| 5f 63 6f 6c 75 6d 6e 73 | 2e 70 79 74 18 00 00 00 |_columns|.pyt....|
|00003900| 73 65 74 5f 63 75 73 74 | 6f 6d 5f 62 75 6c 6b 5f |set_cust|om_bulk_|
|00003910| 6d 75 6c 74 69 70 6c 65 | 3e 01 00 00 73 6e 00 00 |multiple|>...sn..|
|00003920| 00 00 06 0d 01 11 01 0d | 01 11 01 0b 01 18 01 1d |........|........|
|00003930| 01 18 02 0f 01 0f 01 16 | 01 18 01 05 02 19 03 16 |........|........|
|00003940| 01 27 01 38 01 07 01 10 | 01 29 04 00 01 06 01 2e |.'.8....|.)......|
|00003950| 01 0d 01 21 01 14 03 09 | 01 03 01 25 03 13 00 0c |...!....|...%....|
|00003960| 01 07 01 07 01 0e 01 09 | 01 0f 01 35 03 07 01 09 |........|...5....|
|00003970| 03 03 01 1d 01 07 01 09 | 03 22 03 10 01 13 01 0d |........|."......|
|00003980| 03 07 00 06 01 09 01 0b | 01 12 01 2b 02 07 01 63 |........|...+...c|
|00003990| 08 00 00 00 0b 00 00 00 | 0e 00 00 00 43 80 00 00 |........|....C...|
|000039a0| 73 c6 00 00 00 7c 07 00 | 64 00 00 6a 09 00 6f 29 |s....|..|d..j..o)|
|000039b0| 00 01 74 01 00 7c 07 00 | 83 01 00 74 01 00 7c 01 |..t..|..|...t..|.|
|000039c0| 00 83 01 00 6a 03 00 6f | 10 00 01 74 02 00 64 01 |....j..o|...t..d.|
|000039d0| 00 83 01 00 82 01 00 6e | 01 00 01 64 00 00 7d 08 |.......n|...d..}.|
|000039e0| 00 78 63 00 74 03 00 7c | 01 00 83 01 00 44 5d 55 |.xc.t..||.....D]U|
|000039f0| 00 5c 02 00 7d 09 00 7d | 0a 00 7c 07 00 64 00 00 |.\..}..}|..|..d..|
|00003a00| 6a 09 00 6f 0e 00 01 7c | 07 00 7c 09 00 19 7d 08 |j..o...||..|...}.|
|00003a10| 00 6e 01 00 01 7c 00 00 | 69 04 00 7c 0a 00 7c 02 |.n...|..|i..|..|.|
|00003a20| 00 64 02 00 7c 03 00 64 | 03 00 7c 04 00 64 04 00 |.d..|..d|..|..d..|
|00003a30| 7c 05 00 64 05 00 7c 06 | 00 64 06 00 7c 08 00 83 ||..d..|.|.d..|...|
|00003a40| 02 05 01 71 49 00 57 7c | 00 00 69 05 00 7c 01 00 |...qI.W||..i..|..|
|00003a50| 64 07 00 74 06 00 83 01 | 01 01 7c 00 00 69 07 00 |d..t....|..|..i..|
|00003a60| 69 08 00 83 00 00 01 64 | 00 00 53 28 08 00 00 00 |i......d|..S(....|
|00003a70| 4e 73 28 00 00 00 4c 65 | 6e 67 74 68 20 6f 66 20 |Ns(...Le|ngth of |
|00003a80| 69 64 73 20 61 6e 64 20 | 65 78 74 72 61 73 20 69 |ids and |extras i|
|00003a90| 73 20 6e 6f 74 20 74 68 | 65 20 73 61 6d 65 52 1c |s not th|e sameR.|
|00003aa0| 00 00 00 52 12 00 00 00 | 52 4d 00 00 00 52 8a 00 |...R....|RM...R..|
|00003ab0| 00 00 74 05 00 00 00 65 | 78 74 72 61 52 48 00 00 |..t....e|xtraRH..|
|00003ac0| 00 28 09 00 00 00 52 25 | 00 00 00 52 41 00 00 00 |.(....R%|...RA...|
|00003ad0| 52 44 00 00 00 52 88 00 | 00 00 74 0b 00 00 00 5f |RD...R..|..t...._|
|00003ae0| 73 65 74 5f 63 75 73 74 | 6f 6d 52 89 00 00 00 52 |set_cust|omR....R|
|00003af0| 35 00 00 00 52 15 00 00 | 00 52 48 00 00 00 28 0b |5...R...|.RH...(.|
|00003b00| 00 00 00 52 11 00 00 00 | 52 8b 00 00 00 74 03 00 |...R....|R....t..|
|00003b10| 00 00 76 61 6c 52 1c 00 | 00 00 52 12 00 00 00 52 |..valR..|..R....R|
|00003b20| 4d 00 00 00 52 8a 00 00 | 00 74 06 00 00 00 65 78 |M...R...|.t....ex|
|00003b30| 74 72 61 73 74 02 00 00 | 00 65 76 52 64 00 00 00 |trast...|.evRd...|
|00003b40| 52 6a 00 00 00 28 00 00 | 00 00 28 00 00 00 00 73 |Rj...(..|..(....s|
|00003b50| 2f 00 00 00 73 69 74 65 | 2d 70 61 63 6b 61 67 65 |/...site|-package|
|00003b60| 73 5c 63 61 6c 69 62 72 | 65 5c 6c 69 62 72 61 72 |s\calibr|e\librar|
|00003b70| 79 5c 63 75 73 74 6f 6d | 5f 63 6f 6c 75 6d 6e 73 |y\custom|_columns|
|00003b80| 2e 70 79 74 0f 00 00 00 | 73 65 74 5f 63 75 73 74 |.pyt....|set_cust|
|00003b90| 6f 6d 5f 62 75 6c 6b 90 | 01 00 00 73 16 00 00 00 |om_bulk.|...s....|
|00003ba0| 00 07 26 01 10 01 06 01 | 0d 00 0c 01 0d 01 0e 01 |..&.....|........|
|00003bb0| 21 01 11 01 13 01 63 09 | 00 00 00 09 00 00 00 0d |!.....c.|........|
|00003bc0| 00 00 00 43 80 00 00 73 | 60 00 00 00 7c 00 00 69 |...C...s|`...|..i|
|00003bd0| 00 00 7c 01 00 7c 02 00 | 64 01 00 7c 03 00 64 02 |..|..|..|d..|..d.|
|00003be0| 00 7c 04 00 64 03 00 7c | 05 00 64 04 00 7c 06 00 |.|..d..||..d..|..|
|00003bf0| 64 05 00 7c 07 00 83 02 | 05 01 7c 00 00 69 01 00 |d..|....|..|..i..|
|00003c00| 7c 01 00 67 01 00 64 06 | 00 74 02 00 83 01 01 01 ||..g..d.|.t......|
|00003c10| 7c 08 00 6f 11 00 01 7c | 00 00 69 03 00 69 04 00 ||..o...||..i..i..|
|00003c20| 83 00 00 01 6e 01 00 01 | 64 00 00 53 28 07 00 00 |....n...|d..S(...|
|00003c30| 00 4e 52 1c 00 00 00 52 | 12 00 00 00 52 4d 00 00 |.NR....R|....RM..|
|00003c40| 00 52 8a 00 00 00 52 9c | 00 00 00 52 48 00 00 00 |.R....R.|...RH...|
|00003c50| 28 05 00 00 00 52 9d 00 | 00 00 52 89 00 00 00 52 |(....R..|..R....R|
|00003c60| 35 00 00 00 52 15 00 00 | 00 52 48 00 00 00 28 09 |5...R...|.RH...(.|
|00003c70| 00 00 00 52 11 00 00 00 | 52 6a 00 00 00 52 9e 00 |...R....|Rj...R..|
|00003c80| 00 00 52 1c 00 00 00 52 | 12 00 00 00 52 4d 00 00 |..R....R|....RM..|
|00003c90| 00 52 8a 00 00 00 52 9c | 00 00 00 52 48 00 00 00 |.R....R.|...RH...|
|00003ca0| 28 00 00 00 00 28 00 00 | 00 00 73 2f 00 00 00 73 |(....(..|..s/...s|
|00003cb0| 69 74 65 2d 70 61 63 6b | 61 67 65 73 5c 63 61 6c |ite-pack|ages\cal|
|00003cc0| 69 62 72 65 5c 6c 69 62 | 72 61 72 79 5c 63 75 73 |ibre\lib|rary\cus|
|00003cd0| 74 6f 6d 5f 63 6f 6c 75 | 6d 6e 73 2e 70 79 74 0a |tom_colu|mns.pyt.|
|00003ce0| 00 00 00 73 65 74 5f 63 | 75 73 74 6f 6d a2 01 00 |...set_c|ustom...|
|00003cf0| 00 73 0a 00 00 00 00 02 | 21 01 0d 01 16 01 07 01 |.s......|!.......|
|00003d00| 63 08 00 00 00 16 00 00 | 00 0c 00 00 00 43 80 00 |c.......|.....C..|
|00003d10| 00 73 8c 04 00 00 7c 03 | 00 64 00 00 6a 09 00 6f |.s....|.|.d..j..o|
|00003d20| 11 00 01 7c 00 00 69 01 | 00 7c 03 00 19 7d 08 00 |...|..i.|.|...}..|
|00003d30| 6e 01 00 01 7c 04 00 64 | 00 00 6a 09 00 6f 11 00 |n...|..d|..j..o..|
|00003d40| 01 7c 00 00 69 02 00 7c | 04 00 19 7d 08 00 6e 01 |.|..i..||...}..n.|
|00003d50| 00 01 7c 08 00 64 01 00 | 19 64 02 00 6a 02 00 6f |..|..d..|.d..j..o|
|00003d60| 05 00 01 64 00 00 53 01 | 7c 08 00 64 03 00 19 70 |...d..S.||..d...p|
|00003d70| 18 00 01 74 03 00 64 04 | 00 7c 08 00 64 05 00 19 |...t..d.|.|..d...|
|00003d80| 16 83 01 00 82 01 00 6e | 01 00 01 7c 00 00 69 04 |.......n|...|..i.|
|00003d90| 00 7c 08 00 64 06 00 19 | 83 01 00 5c 02 00 7d 09 |.|..d...|...\..}.|
|00003da0| 00 7d 0a 00 74 05 00 7c | 00 00 69 06 00 7c 01 00 |.}..t..||..i..|..|
|00003db0| 64 06 00 7c 08 00 64 06 | 00 19 64 07 00 74 07 00 |d..|..d.|..d..t..|
|00003dc0| 83 02 02 7d 0b 00 7c 00 | 00 69 08 00 7c 08 00 64 |...}..|.|.i..|..d|
|00003dd0| 01 00 19 19 7c 02 00 7c | 08 00 83 02 00 7d 02 00 |....|..||.....}..|
|00003de0| 7c 08 00 64 08 00 19 6f | 00 03 01 7c 05 00 0c 70 ||..d...o|...|...p|
|00003df0| 0c 00 01 7c 08 00 64 09 | 00 19 0c 6f 5a 00 01 7c |...|..d.|...oZ..||
|00003e00| 00 00 69 09 00 69 0a 00 | 64 0a 00 7c 0a 00 16 7c |..i..i..|d..|...||
|00003e10| 01 00 66 01 00 83 02 00 | 01 7c 00 00 69 09 00 69 |..f.....|.|..i..i|
|00003e20| 0a 00 64 0b 00 7c 09 00 | 7c 0a 00 7c 09 00 66 03 |..d..|..||..|..f.|
|00003e30| 00 16 83 01 00 01 64 00 | 00 7c 00 00 69 0b 00 69 |......d.|.|..i..i|
|00003e40| 0c 00 7c 01 00 19 7c 00 | 00 69 0d 00 7c 08 00 64 |..|...|.|.i..|..d|
|00003e50| 06 00 19 19 3c 6e 01 00 | 01 7c 08 00 64 09 00 19 |....<n..|.|..d...|
|00003e60| 6f 07 00 01 7c 02 00 6e | 07 00 01 7c 02 00 67 01 |o...|..n|...|..g.|
|00003e70| 00 7d 0c 00 7c 0b 00 83 | 00 00 7d 0d 00 7c 0d 00 |.}..|...|..}..|..|
|00003e80| 70 0a 00 01 67 00 00 7d | 0d 00 6e 01 00 01 78 09 |p...g..}|..n...x.|
|00003e90| 02 74 0e 00 7c 0c 00 83 | 01 00 74 0e 00 7c 0d 00 |.t..|...|..t..|..|
|00003ea0| 83 01 00 18 44 5d f1 01 | 7d 0e 00 7c 0e 00 64 00 |....D]..|}..|..d.|
|00003eb0| 00 6a 08 00 6f 07 00 01 | 71 8f 01 6e 01 00 01 74 |.j..o...|q..n...t|
|00003ec0| 0f 00 7c 00 00 69 10 00 | 64 06 00 7c 08 00 64 06 |..|..i..|d..|..d.|
|00003ed0| 00 19 83 00 01 83 01 00 | 7d 0d 00 67 00 00 04 7d |........|}..g...}|
|00003ee0| 0f 00 7c 0d 00 44 5d 2a | 00 7d 10 00 7c 0f 00 74 |..|..D]*|.}..|..t|
|00003ef0| 11 00 7c 10 00 64 0c 00 | 83 02 00 6f 0d 00 01 7c |..|..d..|...o...||
|00003f00| 10 00 69 12 00 83 00 00 | 6e 04 00 01 7c 10 00 12 |..i.....|n...|...|
|00003f10| 71 d0 01 7e 0f 00 7d 11 | 00 79 30 00 7c 11 00 69 |q..~..}.|.y0.|..i|
|00003f20| 13 00 74 11 00 7c 0e 00 | 64 0c 00 83 02 00 6f 0d |..t..|..|d.....o.|
|00003f30| 00 01 7c 0e 00 69 12 00 | 83 00 00 6e 04 00 01 7c |..|..i..|...n...||
|00003f40| 0e 00 83 01 00 7d 12 00 | 57 6e 19 00 04 74 03 00 |.....}..|Wn...t..|
|00003f50| 6a 0a 00 6f 0d 00 01 01 | 01 01 64 0d 00 7d 12 00 |j..o....|..d..}..|
|00003f60| 6e 02 00 01 58 7c 12 00 | 64 0d 00 6a 04 00 6f 5e |n...X|..|d..j..o^|
|00003f70| 00 01 7c 0d 00 7c 12 00 | 19 7d 13 00 7c 00 00 69 |..|..|..|.}..|..i|
|00003f80| 09 00 69 14 00 64 0e 00 | 7c 09 00 16 7c 13 00 66 |..i..d..||...|..f|
|00003f90| 01 00 64 0f 00 74 15 00 | 83 02 01 7d 14 00 7c 13 |..d..t..|...}..|.|
|00003fa0| 00 7c 0e 00 6a 03 00 6f | 21 00 01 7c 00 00 69 09 |.|..j..o|!..|..i.|
|00003fb0| 00 69 0a 00 64 10 00 7c | 09 00 16 7c 0e 00 7c 14 |.i..d..||...|..|.|
|00003fc0| 00 66 02 00 83 02 00 01 | 71 d9 02 01 6e 20 00 01 |.f......|q...n ..|
|00003fd0| 7c 00 00 69 09 00 69 0a | 00 64 11 00 7c 09 00 16 ||..i..i.|.d..|...|
|00003fe0| 7c 0e 00 66 01 00 83 02 | 00 69 16 00 7d 14 00 7c ||..f....|.i..}..||
|00003ff0| 00 00 69 09 00 69 14 00 | 64 12 00 7c 0a 00 16 7c |..i..i..|d..|...||
|00004000| 01 00 7c 14 00 66 02 00 | 64 0f 00 74 15 00 83 02 |..|..f..|d..t....|
|00004010| 01 70 81 00 01 7c 08 00 | 64 01 00 19 64 13 00 6a |.p...|..|d...d..j|
|00004020| 02 00 6f 4f 00 01 7c 00 | 00 69 09 00 69 0a 00 64 |..oO..|.|.i..i..d|
|00004030| 14 00 7c 0a 00 16 7c 01 | 00 7c 14 00 7c 07 00 66 |..|...|.|.|..|..f|
|00004040| 03 00 83 02 00 01 7c 00 | 00 69 0b 00 69 0e 00 7c |......|.|.i..i..||
|00004050| 01 00 7c 00 00 69 0d 00 | 7c 08 00 64 06 00 19 19 |..|..i..||..d....|
|00004060| 64 15 00 17 7c 07 00 64 | 16 00 74 07 00 83 03 01 |d...|..d|..t.....|
|00004070| 01 71 80 03 01 7c 00 00 | 69 09 00 69 0a 00 64 17 |.q...|..|i..i..d.|
|00004080| 00 7c 0a 00 16 7c 01 00 | 7c 14 00 66 02 00 83 02 |.|...|..||..f....|
|00004090| 00 01 71 8f 01 01 71 8f | 01 57 7c 00 00 69 09 00 |..q...q.|.W|..i..|
|000040a0| 69 14 00 64 18 00 7c 08 | 00 64 06 00 19 16 7c 01 |i..d..|.|.d....|.|
|000040b0| 00 66 01 00 64 0f 00 74 | 15 00 83 02 01 7d 15 00 |.f..d..t|.....}..|
|000040c0| 7c 00 00 69 0b 00 69 0e | 00 7c 01 00 7c 00 00 69 ||..i..i.|.|..|..i|
|000040d0| 0d 00 7c 08 00 64 06 00 | 19 19 7c 15 00 64 16 00 |..|..d..|..|..d..|
|000040e0| 74 07 00 83 03 01 01 6e | 96 00 01 7c 00 00 69 09 |t......n|...|..i.|
|000040f0| 00 69 0a 00 64 0a 00 7c | 09 00 16 7c 01 00 66 01 |.i..d..||...|..f.|
|00004100| 00 83 02 00 01 7c 02 00 | 64 00 00 6a 09 00 6f 21 |.....|..|d..j..o!|
|00004110| 00 01 7c 00 00 69 09 00 | 69 0a 00 64 19 00 7c 09 |..|..i..|i..d..|.|
|00004120| 00 16 7c 01 00 7c 02 00 | 66 02 00 83 02 00 01 6e |..|..|..|f......n|
|00004130| 01 00 01 7c 00 00 69 09 | 00 69 14 00 64 18 00 7c |...|..i.|.i..d..||
|00004140| 08 00 64 06 00 19 16 7c | 01 00 66 01 00 64 0f 00 |..d....||..f..d..|
|00004150| 74 15 00 83 02 01 7d 15 | 00 7c 00 00 69 0b 00 69 |t.....}.|.|..i..i|
|00004160| 0e 00 7c 01 00 7c 00 00 | 69 0d 00 7c 08 00 64 06 |..|..|..|i..|..d.|
|00004170| 00 19 19 7c 15 00 64 16 | 00 74 07 00 83 03 01 01 |...|..d.|.t......|
|00004180| 7c 06 00 6f 17 00 01 7c | 00 00 69 17 00 64 1a 00 ||..o...||..i..d..|
|00004190| 7c 01 00 67 01 00 83 02 | 00 01 6e 01 00 01 7c 15 ||..g....|..n...|.|
|000041a0| 00 53 28 1b 00 00 00 4e | 52 1e 00 00 00 52 10 00 |.S(....N|R....R..|
|000041b0| 00 00 52 1f 00 00 00 73 | 19 00 00 00 43 6f 6c 75 |..R....s|....Colu|
|000041c0| 6d 6e 20 25 72 20 69 73 | 20 6e 6f 74 20 65 64 69 |mn %r is| not edi|
|000041d0| 74 61 62 6c 65 52 1c 00 | 00 00 52 12 00 00 00 52 |tableR..|..R....R|
|000041e0| 65 00 00 00 52 21 00 00 | 00 52 22 00 00 00 73 1b |e...R!..|.R"...s.|
|000041f0| 00 00 00 44 45 4c 45 54 | 45 20 46 52 4f 4d 20 25 |...DELET|E FROM %|
|00004200| 73 20 57 48 45 52 45 20 | 62 6f 6f 6b 3d 3f 73 59 |s WHERE |book=?sY|
|00004210| 00 00 00 44 45 4c 45 54 | 45 20 46 52 4f 4d 20 25 |...DELET|E FROM %|
|00004220| 73 20 57 48 45 52 45 20 | 28 53 45 4c 45 43 54 20 |s WHERE |(SELECT |
|00004230| 43 4f 55 4e 54 28 69 64 | 29 20 46 52 4f 4d 20 25 |COUNT(id|) FROM %|
|00004240| 73 20 57 48 45 52 45 0a | 20 20 20 20 20 20 20 20 |s WHERE.|        |
|00004250| 20 20 20 20 20 20 20 20 | 20 20 20 20 76 61 6c 75 |        |    valu|
|00004260| 65 3d 25 73 2e 69 64 29 | 20 3c 20 31 52 60 00 00 |e=%s.id)| < 1R`..|
|00004270| 00 69 ff ff ff ff 73 1f | 00 00 00 53 45 4c 45 43 |.i....s.|...SELEC|
|00004280| 54 20 69 64 20 46 52 4f | 4d 20 25 73 20 57 48 45 |T id FRO|M %s WHE|
|00004290| 52 45 20 76 61 6c 75 65 | 3d 3f 52 69 00 00 00 73 |RE value|=?Ri...s|
|000042a0| 20 00 00 00 55 50 44 41 | 54 45 20 25 73 20 53 45 | ...UPDA|TE %s SE|
|000042b0| 54 20 76 61 6c 75 65 3d | 3f 20 57 48 45 52 45 20 |T value=|? WHERE |
|000042c0| 69 64 3d 3f 73 1f 00 00 | 00 49 4e 53 45 52 54 20 |id=?s...|.INSERT |
|000042d0| 49 4e 54 4f 20 25 73 28 | 76 61 6c 75 65 29 20 56 |INTO %s(|value) V|
|000042e0| 41 4c 55 45 53 28 3f 29 | 73 2c 00 00 00 53 45 4c |ALUES(?)|s,...SEL|
|000042f0| 45 43 54 20 62 6f 6f 6b | 20 46 52 4f 4d 20 25 73 |ECT book| FROM %s|
|00004300| 20 57 48 45 52 45 20 62 | 6f 6f 6b 3d 3f 20 41 4e | WHERE b|ook=? AN|
|00004310| 44 20 76 61 6c 75 65 3d | 3f 52 0f 00 00 00 73 50 |D value=|?R....sP|
|00004320| 00 00 00 49 4e 53 45 52 | 54 20 49 4e 54 4f 20 25 |...INSER|T INTO %|
|00004330| 73 28 62 6f 6f 6b 2c 20 | 76 61 6c 75 65 2c 20 65 |s(book, |value, e|
|00004340| 78 74 72 61 29 0a 20 20 | 20 20 20 20 20 20 20 20 |xtra).  |        |
|00004350| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |        |        |
|00004360| 20 20 20 20 20 56 41 4c | 55 45 53 20 28 3f 2c 3f |     VAL|UES (?,?|
|00004370| 2c 3f 29 69 01 00 00 00 | 52 84 00 00 00 73 48 00 |,?)i....|R....sH.|
|00004380| 00 00 49 4e 53 45 52 54 | 20 49 4e 54 4f 20 25 73 |..INSERT| INTO %s|
|00004390| 28 62 6f 6f 6b 2c 20 76 | 61 6c 75 65 29 0a 20 20 |(book, v|alue).  |
|000043a0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |        |        |
|000043b0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 56 41 |        |      VA|
|000043c0| 4c 55 45 53 20 28 3f 2c | 3f 29 73 26 00 00 00 53 |LUES (?,|?)s&...S|
|000043d0| 45 4c 45 43 54 20 63 75 | 73 74 6f 6d 5f 25 73 20 |ELECT cu|stom_%s |
|000043e0| 46 52 4f 4d 20 6d 65 74 | 61 32 20 57 48 45 52 45 |FROM met|a2 WHERE|
|000043f0| 20 69 64 3d 3f 73 27 00 | 00 00 49 4e 53 45 52 54 | id=?s'.|..INSERT|
|00004400| 20 49 4e 54 4f 20 25 73 | 28 62 6f 6f 6b 2c 76 61 | INTO %s|(book,va|
|00004410| 6c 75 65 29 20 56 41 4c | 55 45 53 20 28 3f 2c 3f |lue) VAL|UES (?,?|
|00004420| 29 52 85 00 00 00 28 18 | 00 00 00 52 25 00 00 00 |)R....(.|...R%...|
|00004430| 52 49 00 00 00 52 4a 00 | 00 00 52 44 00 00 00 52 |RI...RJ.|..RD...R|
|00004440| 13 00 00 00 52 01 00 00 | 00 52 68 00 00 00 52 51 |....R...|.Rh...RQ|
|00004450| 00 00 00 52 4e 00 00 00 | 52 15 00 00 00 52 47 00 |...RN...|R....RG.|
|00004460| 00 00 52 57 00 00 00 52 | 61 00 00 00 52 62 00 00 |..RW...R|a...Rb..|
|00004470| 00 52 14 00 00 00 74 04 | 00 00 00 6c 69 73 74 52 |.R....t.|...listR|
|00004480| 7a 00 00 00 74 07 00 00 | 00 68 61 73 61 74 74 72 |z...t...|.hasattr|
|00004490| 52 60 00 00 00 74 05 00 | 00 00 69 6e 64 65 78 52 |R`...t..|..indexR|
|000044a0| 16 00 00 00 52 35 00 00 | 00 74 09 00 00 00 6c 61 |....R5..|.t....la|
|000044b0| 73 74 72 6f 77 69 64 52 | 8a 00 00 00 28 16 00 00 |strowidR|....(...|
|000044c0| 00 52 11 00 00 00 74 03 | 00 00 00 69 64 5f 52 9e |.R....t.|...id_R.|
|000044d0| 00 00 00 52 1c 00 00 00 | 52 12 00 00 00 52 4d 00 |...R....|R....RM.|
|000044e0| 00 00 52 8a 00 00 00 52 | 9c 00 00 00 52 57 00 00 |..R....R|....RW..|
|000044f0| 00 52 1a 00 00 00 52 1b | 00 00 00 74 06 00 00 00 |.R....R.|...t....|
|00004500| 67 65 74 74 65 72 74 07 | 00 00 00 73 65 74 5f 76 |gettert.|...set_v|
|00004510| 61 6c 74 08 00 00 00 65 | 78 69 73 74 69 6e 67 52 |alt....e|xistingR|
|00004520| 18 00 00 00 52 17 00 00 | 00 52 90 00 00 00 74 02 |....R...|.R....t.|
|00004530| 00 00 00 6c 78 52 64 00 | 00 00 74 02 00 00 00 65 |...lxRd.|..t....e|
|00004540| 78 74 03 00 00 00 78 69 | 64 74 04 00 00 00 6e 76 |xt....xi|dt....nv|
|00004550| 61 6c 28 00 00 00 00 28 | 00 00 00 00 73 2f 00 00 |al(....(|....s/..|
|00004560| 00 73 69 74 65 2d 70 61 | 63 6b 61 67 65 73 5c 63 |.site-pa|ckages\c|
|00004570| 61 6c 69 62 72 65 5c 6c | 69 62 72 61 72 79 5c 63 |alibre\l|ibrary\c|
|00004580| 75 73 74 6f 6d 5f 63 6f | 6c 75 6d 6e 73 2e 70 79 |ustom_co|lumns.py|
|00004590| 52 9d 00 00 00 aa 01 00 | 00 73 8a 00 00 00 00 02 |R.......|.s......|
|000045a0| 0d 01 11 01 0d 01 11 01 | 11 01 05 01 0b 01 18 01 |........|........|
|000045b0| 19 01 19 01 09 01 1a 02 | 0b 01 14 01 1a 01 09 02 |........|........|
|000045c0| 14 01 23 01 1b 01 09 01 | 07 01 0a 01 17 00 06 01 |..#.....|........|
|000045d0| 0d 01 07 01 1c 01 3e 01 | 03 01 30 01 0e 01 0b 01 |......>.|..0.....|
|000045e0| 0d 01 0a 01 09 01 19 01 | 0d 01 09 01 1c 02 09 01 |........|........|
|000045f0| 16 01 09 01 07 01 16 01 | 11 01 09 02 17 01 1e 01 |........|........|
|00004600| 11 02 09 02 1c 01 09 01 | 0b 01 12 01 20 01 0b 02 |........|.... ...|
|00004610| 1a 01 0d 01 09 01 07 01 | 11 01 09 01 0b 01 12 01 |........|........|
|00004620| 20 01 07 01 07 01 17 01 | 63 01 00 00 00 06 00 00 | .......|c.......|
|00004630| 00 07 00 00 00 43 80 00 | 00 73 a2 00 00 00 64 01 |.....C..|.s....d.|
|00004640| 00 7d 01 00 67 00 00 7d | 02 00 78 5e 00 7c 00 00 |.}..g..}|..x^.|..|
|00004650| 69 00 00 69 01 00 83 00 | 00 44 5d 4d 00 7d 03 00 |i..i....|.D]M.}..|
|00004660| 7c 03 00 64 02 00 19 6f | 3c 00 01 7c 00 00 69 02 ||..d...o|<..|..i.|
|00004670| 00 7c 03 00 64 03 00 19 | 83 01 00 5c 02 00 7d 04 |.|..d...|...\..}.|
|00004680| 00 7d 05 00 7c 02 00 69 | 03 00 7c 01 00 69 04 00 |.}..|..i|..|..i..|
|00004690| 64 04 00 7c 05 00 64 05 | 00 7c 04 00 83 00 02 83 |d..|..d.|.|......|
|000046a0| 01 00 01 71 1c 00 01 71 | 1c 00 57 7c 02 00 6f 2a |...q...q|..W|..o*|
|000046b0| 00 01 7c 00 00 69 05 00 | 69 06 00 64 06 00 69 07 |..|..i..|i..d..i.|
|000046c0| 00 7c 02 00 83 01 00 83 | 01 00 01 7c 00 00 69 05 |.|......|...|..i.|
|000046d0| 00 69 08 00 83 00 00 01 | 6e 01 00 01 64 00 00 53 |.i......|n...d..S|
|000046e0| 28 07 00 00 00 4e 73 57 | 00 00 00 44 45 4c 45 54 |(....NsW|...DELET|
|000046f0| 45 20 46 52 4f 4d 20 7b | 74 61 62 6c 65 7d 20 57 |E FROM {|table} W|
|00004700| 48 45 52 45 20 28 53 45 | 4c 45 43 54 20 43 4f 55 |HERE (SE|LECT COU|
|00004710| 4e 54 28 69 64 29 20 46 | 52 4f 4d 20 7b 6c 74 7d |NT(id) F|ROM {lt}|
|00004720| 20 57 48 45 52 45 20 7b | 6c 74 7d 2e 76 61 6c 75 | WHERE {|lt}.valu|
|00004730| 65 3d 7b 74 61 62 6c 65 | 7d 2e 69 64 29 20 3c 20 |e={table|}.id) < |
|00004740| 31 3b 52 21 00 00 00 52 | 12 00 00 00 52 1b 00 00 |1;R!...R|....R...|
|00004750| 00 52 1a 00 00 00 73 02 | 00 00 00 20 0a 28 09 00 |.R....s.|... .(..|
|00004760| 00 00 52 4a 00 00 00 74 | 06 00 00 00 76 61 6c 75 |..RJ...t|....valu|
|00004770| 65 73 52 13 00 00 00 52 | 4d 00 00 00 52 46 00 00 |esR....R|M...RF..|
|00004780| 00 52 15 00 00 00 52 45 | 00 00 00 52 2d 00 00 00 |.R....RE|...R-...|
|00004790| 52 48 00 00 00 28 06 00 | 00 00 52 11 00 00 00 74 |RH...(..|..R....t|
|000047a0| 02 00 00 00 73 74 74 0a | 00 00 00 73 74 61 74 65 |....stt.|...state|
|000047b0| 6d 65 6e 74 73 52 57 00 | 00 00 52 1a 00 00 00 52 |mentsRW.|..R....R|
|000047c0| 1b 00 00 00 28 00 00 00 | 00 28 00 00 00 00 73 2f |....(...|.(....s/|
|000047d0| 00 00 00 73 69 74 65 2d | 70 61 63 6b 61 67 65 73 |...site-|packages|
|000047e0| 5c 63 61 6c 69 62 72 65 | 5c 6c 69 62 72 61 72 79 |\calibre|\library|
|000047f0| 5c 63 75 73 74 6f 6d 5f | 63 6f 6c 75 6d 6e 73 2e |\custom_|columns.|
|00004800| 70 79 74 0c 00 00 00 63 | 6c 65 61 6e 5f 63 75 73 |pyt....c|lean_cus|
|00004810| 74 6f 6d f8 01 00 00 73 | 14 00 00 00 00 01 06 02 |tom....s|........|
|00004820| 06 01 10 00 06 01 0b 01 | 19 01 27 01 07 01 19 01 |........|..'.....|
|00004830| 63 01 00 00 00 08 00 00 | 00 0b 00 00 00 43 80 00 |c.......|.....C..|
|00004840| 00 73 19 01 00 00 68 00 | 00 7d 01 00 78 0c 01 7c |.s....h.|.}..x..||
|00004850| 00 00 69 00 00 69 01 00 | 83 00 00 44 5d fb 00 7d |..i..i..|...D]..}|
|00004860| 02 00 7c 02 00 64 01 00 | 19 7d 03 00 7c 00 00 69 |..|..d..|.}..|..i|
|00004870| 02 00 7c 02 00 64 02 00 | 19 83 01 00 5c 02 00 7d |..|..d..|....\..}|
|00004880| 04 00 7d 05 00 7c 02 00 | 64 03 00 19 6f 9d 00 01 |..}..|..|d...o...|
|00004890| 64 04 00 7d 06 00 7c 02 | 00 64 05 00 19 6f 27 00 |d..}..|.|.d...o'.|
|000048a0| 01 64 06 00 7d 06 00 7c | 03 00 69 03 00 64 07 00 |.d..}..||..i..d..|
|000048b0| 74 04 00 83 02 00 70 0a | 00 01 64 08 00 7d 06 00 |t.....p.|..d..}..|
|000048c0| 71 82 00 01 6e 01 00 01 | 64 09 00 69 05 00 64 0a |q...n...|d..i..d.|
|000048d0| 00 7c 06 00 7c 04 00 16 | 64 0b 00 7c 05 00 64 0c |.|..|...|d..|..d.|
|000048e0| 00 7c 04 00 64 02 00 7c | 02 00 64 02 00 19 83 00 |.|..d..||..d.....|
|000048f0| 04 7d 07 00 7c 02 00 64 | 0d 00 19 64 0e 00 6a 02 |.}..|..d|...d..j.|
|00004900| 00 6f 24 00 01 7c 07 00 | 64 0f 00 69 05 00 64 0b |.o$..|..|d..i..d.|
|00004910| 00 7c 05 00 64 02 00 7c | 02 00 64 02 00 19 83 00 |.|..d..||..d.....|
|00004920| 02 37 7d 07 00 71 03 01 | 01 6e 1d 00 01 64 10 00 |.7}..q..|.n...d..|
|00004930| 69 05 00 64 0c 00 7c 04 | 00 64 02 00 7c 02 00 64 |i..d..|.|.d..|..d|
|00004940| 02 00 19 83 00 02 7d 07 | 00 7c 07 00 7c 01 00 7c |......}.|.|..|..||
|00004950| 02 00 64 02 00 19 3c 71 | 16 00 57 7c 01 00 53 28 |..d...<q|..W|..S(|
|00004960| 11 00 00 00 4e 52 20 00 | 00 00 52 12 00 00 00 52 |....NR .|..R....R|
|00004970| 21 00 00 00 73 08 00 00 | 00 25 73 2e 76 61 6c 75 |!...s...|.%s.valu|
|00004980| 65 52 22 00 00 00 73 1b | 00 00 00 67 72 6f 75 70 |eR"...s.|...group|
|00004990| 5f 63 6f 6e 63 61 74 28 | 25 73 2e 76 61 6c 75 65 |_concat(|%s.value|
|000049a0| 2c 20 22 7c 22 29 52 5e | 00 00 00 73 1e 00 00 00 |, "|")R^|...s....|
|000049b0| 73 6f 72 74 5f 63 6f 6e | 63 61 74 28 6c 69 6e 6b |sort_con|cat(link|
|000049c0| 2e 69 64 2c 20 25 73 2e | 76 61 6c 75 65 29 73 ae |.id, %s.|value)s.|
|000049d0| 00 00 00 28 53 45 4c 45 | 43 54 20 7b 71 75 65 72 |...(SELE|CT {quer|
|000049e0| 79 7d 20 46 52 4f 4d 20 | 7b 6c 74 7d 20 41 53 20 |y} FROM |{lt} AS |
|000049f0| 6c 69 6e 6b 20 49 4e 4e | 45 52 20 4a 4f 49 4e 0a |link INN|ER JOIN.|
|00004a00| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |        |        |
|00004a10| 20 20 20 20 7b 74 61 62 | 6c 65 7d 20 4f 4e 28 6c |    {tab|le} ON(l|
|00004a20| 69 6e 6b 2e 76 61 6c 75 | 65 3d 7b 74 61 62 6c 65 |ink.valu|e={table|
|00004a30| 7d 2e 69 64 29 20 57 48 | 45 52 45 20 6c 69 6e 6b |}.id) WH|ERE link|
|00004a40| 2e 62 6f 6f 6b 3d 62 6f | 6f 6b 73 2e 69 64 29 0a |.book=bo|oks.id).|
|00004a50| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |        |        |
|00004a60| 20 20 20 20 63 75 73 74 | 6f 6d 5f 7b 6e 75 6d 7d |    cust|om_{num}|
|00004a70| 0a 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |.       |        |
|00004a80| 20 74 05 00 00 00 71 75 | 65 72 79 52 1b 00 00 00 | t....qu|eryR....|
|00004a90| 52 1a 00 00 00 52 1e 00 | 00 00 52 0f 00 00 00 73 |R....R..|..R....s|
|00004aa0| 5d 00 00 00 2c 28 53 45 | 4c 45 43 54 20 65 78 74 |]...,(SE|LECT ext|
|00004ab0| 72 61 20 46 52 4f 4d 20 | 7b 6c 74 7d 20 57 48 45 |ra FROM |{lt} WHE|
|00004ac0| 52 45 20 7b 6c 74 7d 2e | 62 6f 6f 6b 3d 62 6f 6f |RE {lt}.|book=boo|
|00004ad0| 6b 73 2e 69 64 29 0a 20 | 20 20 20 20 20 20 20 20 |ks.id). |        |
|00004ae0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 63 |        |       c|
|00004af0| 75 73 74 6f 6d 5f 69 6e | 64 65 78 5f 7b 6e 75 6d |ustom_in|dex_{num|
|00004b00| 7d 73 5e 00 00 00 0a 20 | 20 20 20 20 20 20 20 20 |}s^.... |        |
|00004b10| 20 20 20 20 20 20 20 28 | 53 45 4c 45 43 54 20 76 |       (|SELECT v|
|00004b20| 61 6c 75 65 20 46 52 4f | 4d 20 7b 74 61 62 6c 65 |alue FRO|M {table|
|00004b30| 7d 20 57 48 45 52 45 20 | 62 6f 6f 6b 3d 62 6f 6f |} WHERE |book=boo|
|00004b40| 6b 73 2e 69 64 29 20 63 | 75 73 74 6f 6d 5f 7b 6e |ks.id) c|ustom_{n|
|00004b50| 75 6d 7d 0a 20 20 20 20 | 20 20 20 20 20 20 20 20 |um}.    |        |
|00004b60| 20 20 20 20 28 06 00 00 | 00 52 49 00 00 00 52 af |    (...|.RI...R.|
|00004b70| 00 00 00 52 13 00 00 00 | 52 16 00 00 00 52 35 00 |...R....|R....R5.|
|00004b80| 00 00 52 46 00 00 00 28 | 08 00 00 00 52 11 00 00 |..RF...(|....R...|
|00004b90| 00 74 05 00 00 00 6c 69 | 6e 65 73 52 57 00 00 00 |.t....li|nesRW...|
|00004ba0| 52 20 00 00 00 52 1a 00 | 00 00 52 1b 00 00 00 52 |R ...R..|..R....R|
|00004bb0| b3 00 00 00 74 04 00 00 | 00 6c 69 6e 65 28 00 00 |....t...|.line(..|
|00004bc0| 00 00 28 00 00 00 00 73 | 2f 00 00 00 73 69 74 65 |..(....s|/...site|
|00004bd0| 2d 70 61 63 6b 61 67 65 | 73 5c 63 61 6c 69 62 72 |-package|s\calibr|
|00004be0| 65 5c 6c 69 62 72 61 72 | 79 5c 63 75 73 74 6f 6d |e\librar|y\custom|
|00004bf0| 5f 63 6f 6c 75 6d 6e 73 | 2e 70 79 74 16 00 00 00 |_columns|.pyt....|
|00004c00| 63 75 73 74 6f 6d 5f 63 | 6f 6c 75 6d 6e 73 5f 69 |custom_c|olumns_i|
|00004c10| 6e 5f 6d 65 74 61 04 02 | 00 00 73 24 00 00 00 00 |n_meta..|..s$....|
|00004c20| 01 06 01 10 00 06 01 0a | 01 19 01 0b 01 06 01 0b |........|........|
|00004c30| 01 06 01 13 01 0e 04 2c | 01 11 01 03 01 25 04 1c |.......,|.....%..|
|00004c40| 01 12 01 63 07 00 00 00 | 10 00 00 00 0a 00 00 00 |...c....|........|
|00004c50| 43 80 00 00 73 78 02 00 | 00 7c 01 00 70 16 00 01 |C...sx..|.|..p...|
|00004c60| 74 00 00 74 01 00 64 01 | 00 83 01 00 83 01 00 82 |t..t..d.|........|
|00004c70| 01 00 6e 01 00 01 74 02 | 00 69 03 00 64 02 00 7c |..n...t.|.i..d..||
|00004c80| 01 00 83 02 00 64 00 00 | 6a 08 00 70 25 00 01 7c |.....d..|j..p%..||
|00004c90| 01 00 64 03 00 19 69 05 | 00 83 00 00 0c 70 13 00 |..d...i.|.....p..|
|00004ca0| 01 7c 01 00 69 06 00 83 | 00 00 7c 01 00 6a 03 00 |.|..i...|..|..j..|
|00004cb0| 6f 16 00 01 74 00 00 74 | 01 00 64 04 00 83 01 00 |o...t..t|..d.....|
|00004cc0| 83 01 00 82 01 00 6e 01 | 00 01 7c 03 00 7c 00 00 |......n.|..|..|..|
|00004cd0| 69 07 00 6a 07 00 6f 14 | 00 01 74 00 00 64 05 00 |i..j..o.|..t..d..|
|00004ce0| 7c 03 00 16 83 01 00 82 | 01 00 6e 01 00 01 7c 03 ||.......|..n...|.|
|00004cf0| 00 64 24 00 6a 07 00 7d | 07 00 7c 04 00 6f 0a 00 |.d$.j..}|..|..o..|
|00004d00| 01 7c 03 00 64 25 00 6a | 06 00 7d 04 00 7c 00 00 |.|..d%.j|..}..|..|
|00004d10| 69 08 00 69 09 00 64 0d | 00 7c 01 00 7c 02 00 7c |i..i..d.|.|..|..||
|00004d20| 03 00 7c 04 00 7c 05 00 | 74 0a 00 69 0b 00 7c 06 |..|..|..|t..i..|.|
|00004d30| 00 83 01 00 7c 07 00 66 | 07 00 83 02 00 69 0c 00 |....|..f|.....i..|
|00004d40| 7d 08 00 7c 03 00 64 26 | 00 6a 06 00 6f 0a 00 01 |}..|..d&|.j..o...|
|00004d50| 64 0f 00 7d 09 00 6e 5d | 00 01 7c 03 00 64 27 00 |d..}..n]|..|..d'.|
|00004d60| 6a 06 00 6f 0a 00 01 64 | 11 00 7d 09 00 6e 46 00 |j..o...d|..}..nF.|
|00004d70| 01 7c 03 00 64 28 00 6a | 06 00 6f 0a 00 01 64 12 |.|..d(.j|..o...d.|
|00004d80| 00 7d 09 00 6e 2f 00 01 | 7c 03 00 64 06 00 6a 02 |.}..n/..||..d..j.|
|00004d90| 00 6f 0a 00 01 64 13 00 | 7d 09 00 6e 18 00 01 7c |.o...d..|}..n...||
|00004da0| 03 00 64 09 00 6a 02 00 | 6f 0a 00 01 64 14 00 7d |..d..j..|o...d..}|
|00004db0| 09 00 6e 01 00 01 7c 09 | 00 64 11 00 6a 02 00 6f |..n...|.|.d..j..o|
|00004dc0| 07 00 01 64 15 00 6e 04 | 00 01 64 16 00 7d 0a 00 |...d..n.|..d..}..|
|00004dd0| 7c 00 00 69 0d 00 7c 08 | 00 83 01 00 5c 02 00 7d ||..i..|.|....\..}|
|00004de0| 0b 00 7d 0c 00 7c 07 00 | 6f 83 00 01 7c 03 00 64 |..}..|..|o...|..d|
|00004df0| 10 00 6a 02 00 6f 0a 00 | 01 64 17 00 7d 0d 00 6e |..j..o..|.d..}..n|
|00004e00| 07 00 01 64 16 00 7d 0d | 00 64 18 00 7c 0b 00 7c |...d..}.|.d..|..||
|00004e10| 09 00 7c 0a 00 66 03 00 | 16 64 19 00 7c 0b 00 7c |..|..f..|.d..|..||
|00004e20| 0b 00 7c 0a 00 66 03 00 | 16 64 1a 00 7c 0c 00 7c |..|..f..|.d..|..||
|00004e30| 0d 00 66 02 00 16 64 1b | 00 7c 0c 00 7c 0c 00 66 |..f...d.|.|..|..f|
|00004e40| 02 00 16 64 1c 00 7c 0c | 00 7c 0c 00 66 02 00 16 |...d..|.|.|..f...|
|00004e50| 64 1d 00 69 0e 00 64 1e | 00 7c 0c 00 64 1f 00 7c |d..i..d.|.|..d..||
|00004e60| 0b 00 83 00 02 67 06 00 | 7d 0e 00 6e 33 00 01 64 |.....g..|}..n3..d|
|00004e70| 20 00 7c 0b 00 7c 09 00 | 7c 0a 00 66 03 00 16 64 | .|..|..||..f...d|
|00004e80| 21 00 7c 0b 00 7c 0b 00 | 66 02 00 16 64 22 00 69 |!.|..|..|f...d".i|
|00004e90| 0e 00 64 1f 00 7c 0b 00 | 83 00 01 67 03 00 7d 0e |..d..|..|...g..}.|
|00004ea0| 00 64 23 00 69 0f 00 7c | 0e 00 83 01 00 7d 0f 00 |.d#.i..||.....}..|
|00004eb0| 7c 00 00 69 08 00 69 10 | 00 7c 0f 00 83 01 00 01 ||..i..i.|.|......|
|00004ec0| 7c 00 00 69 08 00 69 11 | 00 83 00 00 01 7c 08 00 ||..i..i.|.....|..|
|00004ed0| 53 28 29 00 00 00 4e 73 | 15 00 00 00 4e 6f 20 6c |S()...Ns|....No l|
|00004ee0| 61 62 65 6c 20 77 61 73 | 20 70 72 6f 76 69 64 65 |abel was| provide|
|00004ef0| 64 73 05 00 00 00 5e 5c | 77 2a 24 69 00 00 00 00 |ds....^\|w*$i....|
|00004f00| 73 5f 00 00 00 54 68 65 | 20 6c 61 62 65 6c 20 6d |s_...The| label m|
|00004f10| 75 73 74 20 63 6f 6e 74 | 61 69 6e 20 6f 6e 6c 79 |ust cont|ain only|
|00004f20| 20 6c 6f 77 65 72 20 63 | 61 73 65 20 6c 65 74 74 | lower c|ase lett|
|00004f30| 65 72 73 2c 20 64 69 67 | 69 74 73 20 61 6e 64 20 |ers, dig|its and |
|00004f40| 75 6e 64 65 72 73 63 6f | 72 65 73 2c 20 61 6e 64 |undersco|res, and|
|00004f50| 20 73 74 61 72 74 20 77 | 69 74 68 20 61 20 6c 65 | start w|ith a le|
|00004f60| 74 74 65 72 73 1f 00 00 | 00 25 72 20 69 73 20 6e |tters...|.%r is n|
|00004f70| 6f 74 20 61 20 73 75 70 | 70 6f 72 74 65 64 20 64 |ot a sup|ported d|
|00004f80| 61 74 61 20 74 79 70 65 | 52 0b 00 00 00 52 0a 00 |ata type|R....R..|
|00004f90| 00 00 52 0c 00 00 00 52 | 0e 00 00 00 52 0d 00 00 |..R....R|....R...|
|00004fa0| 00 52 10 00 00 00 52 09 | 00 00 00 73 6d 00 00 00 |.R....R.|...sm...|
|00004fb0| 49 4e 53 45 52 54 20 49 | 4e 54 4f 20 63 75 73 74 |INSERT I|NTO cust|
|00004fc0| 6f 6d 5f 63 6f 6c 75 6d | 6e 73 28 6c 61 62 65 6c |om_colum|ns(label|
|00004fd0| 2c 6e 61 6d 65 2c 64 61 | 74 61 74 79 70 65 2c 69 |,name,da|tatype,i|
|00004fe0| 73 5f 6d 75 6c 74 69 70 | 6c 65 2c 65 64 69 74 61 |s_multip|le,edita|
|00004ff0| 62 6c 65 2c 64 69 73 70 | 6c 61 79 2c 6e 6f 72 6d |ble,disp|lay,norm|
|00005000| 61 6c 69 7a 65 64 29 56 | 41 4c 55 45 53 20 28 3f |alized)V|ALUES (?|
|00005010| 2c 3f 2c 3f 2c 3f 2c 3f | 2c 3f 2c 3f 29 52 08 00 |,?,?,?,?|,?,?)R..|
|00005020| 00 00 74 03 00 00 00 49 | 4e 54 52 0f 00 00 00 74 |..t....I|NTR....t|
|00005030| 04 00 00 00 54 45 58 54 | 74 04 00 00 00 52 45 41 |....TEXT|t....REA|
|00005040| 4c 74 09 00 00 00 74 69 | 6d 65 73 74 61 6d 70 74 |Lt....ti|mestampt|
|00005050| 04 00 00 00 42 4f 4f 4c | 73 0e 00 00 00 43 4f 4c |....BOOL|s....COL|
|00005060| 4c 41 54 45 20 4e 4f 43 | 41 53 45 74 00 00 00 00 |LATE NOC|ASEt....|
|00005070| 73 0b 00 00 00 65 78 74 | 72 61 20 52 45 41 4c 2c |s....ext|ra REAL,|
|00005080| 73 bc 00 00 00 20 20 20 | 20 20 20 20 20 20 20 20 |s....   |        |
|00005090| 20 20 20 20 20 43 52 45 | 41 54 45 20 54 41 42 4c |     CRE|ATE TABL|
|000050a0| 45 20 25 73 28 0a 20 20 | 20 20 20 20 20 20 20 20 |E %s(.  |        |
|000050b0| 20 20 20 20 20 20 20 20 | 20 20 69 64 20 20 20 20 |        |  id    |
|000050c0| 49 4e 54 45 47 45 52 20 | 50 52 49 4d 41 52 59 20 |INTEGER |PRIMARY |
|000050d0| 4b 45 59 20 41 55 54 4f | 49 4e 43 52 45 4d 45 4e |KEY AUTO|INCREMEN|
|000050e0| 54 2c 0a 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |T,.     |        |
|000050f0| 20 20 20 20 20 20 20 76 | 61 6c 75 65 20 25 73 20 |       v|alue %s |
|00005100| 4e 4f 54 20 4e 55 4c 4c | 20 25 73 2c 0a 20 20 20 |NOT NULL| %s,.   |
|00005110| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |        |        |
|00005120| 20 55 4e 49 51 55 45 28 | 76 61 6c 75 65 29 29 3b | UNIQUE(|value));|
|00005130| 0a 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |.       |        |
|00005140| 20 73 25 00 00 00 43 52 | 45 41 54 45 20 49 4e 44 | s%...CR|EATE IND|
|00005150| 45 58 20 25 73 5f 69 64 | 78 20 4f 4e 20 25 73 20 |EX %s_id|x ON %s |
|00005160| 28 76 61 6c 75 65 20 25 | 73 29 3b 73 07 01 00 00 |(value %|s);s....|
|00005170| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |        |        |
|00005180| 43 52 45 41 54 45 20 54 | 41 42 4c 45 20 25 73 28 |CREATE T|ABLE %s(|
|00005190| 0a 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |.       |        |
|000051a0| 20 20 20 20 20 69 64 20 | 49 4e 54 45 47 45 52 20 |     id |INTEGER |
|000051b0| 50 52 49 4d 41 52 59 20 | 4b 45 59 20 41 55 54 4f |PRIMARY |KEY AUTO|
|000051c0| 49 4e 43 52 45 4d 45 4e | 54 2c 0a 20 20 20 20 20 |INCREMEN|T,.     |
|000051d0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 62 |        |       b|
|000051e0| 6f 6f 6b 20 49 4e 54 45 | 47 45 52 20 4e 4f 54 20 |ook INTE|GER NOT |
|000051f0| 4e 55 4c 4c 2c 0a 20 20 | 20 20 20 20 20 20 20 20 |NULL,.  |        |
|00005200| 20 20 20 20 20 20 20 20 | 20 20 76 61 6c 75 65 20 |        |  value |
|00005210| 49 4e 54 45 47 45 52 20 | 4e 4f 54 20 4e 55 4c 4c |INTEGER |NOT NULL|
|00005220| 2c 0a 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |,.      |        |
|00005230| 20 20 20 20 20 20 25 73 | 0a 20 20 20 20 20 20 20 |      %s|.       |
|00005240| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 55 4e 49 |        |     UNI|
|00005250| 51 55 45 28 62 6f 6f 6b | 2c 20 76 61 6c 75 65 29 |QUE(book|, value)|
|00005260| 0a 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |.       |        |
|00005270| 20 20 20 20 20 29 3b 73 | 23 00 00 00 43 52 45 41 |     );s|#...CREA|
|00005280| 54 45 20 49 4e 44 45 58 | 20 25 73 5f 61 69 64 78 |TE INDEX| %s_aidx|
|00005290| 20 4f 4e 20 25 73 20 28 | 76 61 6c 75 65 29 3b 73 | ON %s (|value);s|
|000052a0| 22 00 00 00 43 52 45 41 | 54 45 20 49 4e 44 45 58 |"...CREA|TE INDEX|
|000052b0| 20 25 73 5f 62 69 64 78 | 20 4f 4e 20 25 73 20 28 | %s_bidx| ON %s (|
|000052c0| 62 6f 6f 6b 29 3b 73 69 | 0b 00 00 20 20 20 20 20 |book);si|...     |
|000052d0| 20 20 20 20 20 20 20 20 | 20 20 20 43 52 45 41 54 |        |   CREAT|
|000052e0| 45 20 54 52 49 47 47 45 | 52 20 66 6b 63 5f 75 70 |E TRIGGE|R fkc_up|
|000052f0| 64 61 74 65 5f 7b 6c 74 | 7d 5f 61 0a 20 20 20 20 |date_{lt|}_a.    |
|00005300| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |        |        |
|00005310| 20 20 20 20 42 45 46 4f | 52 45 20 55 50 44 41 54 |    BEFO|RE UPDAT|
|00005320| 45 20 4f 46 20 62 6f 6f | 6b 20 4f 4e 20 7b 6c 74 |E OF boo|k ON {lt|
|00005330| 7d 0a 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |}.      |        |
|00005340| 20 20 20 20 20 20 20 20 | 20 20 42 45 47 49 4e 0a |        |  BEGIN.|
|00005350| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |        |        |
|00005360| 20 20 20 20 20 20 20 20 | 20 20 20 20 53 45 4c 45 |        |    SELE|
|00005370| 43 54 20 43 41 53 45 0a | 20 20 20 20 20 20 20 20 |CT CASE.|        |
|00005380| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |        |        |
|00005390| 20 20 20 20 20 20 20 20 | 57 48 45 4e 20 28 53 45 |        |WHEN (SE|
|000053a0| 4c 45 43 54 20 69 64 20 | 66 72 6f 6d 20 62 6f 6f |LECT id |from boo|
|000053b0| 6b 73 20 57 48 45 52 45 | 20 69 64 3d 4e 45 57 2e |ks WHERE| id=NEW.|
|000053c0| 62 6f 6f 6b 29 20 49 53 | 20 4e 55 4c 4c 0a 20 20 |book) IS| NULL.  |
|000053d0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |        |        |
|000053e0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 54 48 |        |      TH|
|000053f0| 45 4e 20 52 41 49 53 45 | 28 41 42 4f 52 54 2c 20 |EN RAISE|(ABORT, |
|00005400| 27 46 6f 72 65 69 67 6e | 20 6b 65 79 20 76 69 6f |'Foreign| key vio|
|00005410| 6c 61 74 69 6f 6e 3a 20 | 62 6f 6f 6b 20 6e 6f 74 |lation: |book not|
|00005420| 20 69 6e 20 62 6f 6f 6b | 73 27 29 0a 20 20 20 20 | in book|s').    |
|00005430| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |        |        |
|00005440| 20 20 20 20 20 20 20 20 | 45 4e 44 3b 0a 20 20 20 |        |END;.   |
|00005450| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |        |        |
|00005460| 20 20 20 20 20 45 4e 44 | 3b 0a 20 20 20 20 20 20 |     END|;.      |
|00005470| 20 20 20 20 20 20 20 20 | 20 20 43 52 45 41 54 45 |        |  CREATE|
|00005480| 20 54 52 49 47 47 45 52 | 20 66 6b 63 5f 75 70 64 | TRIGGER| fkc_upd|
|00005490| 61 74 65 5f 7b 6c 74 7d | 5f 62 0a 20 20 20 20 20 |ate_{lt}|_b.     |
|000054a0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |        |        |
|000054b0| 20 20 20 42 45 46 4f 52 | 45 20 55 50 44 41 54 45 |   BEFOR|E UPDATE|
|000054c0| 20 4f 46 20 61 75 74 68 | 6f 72 20 4f 4e 20 7b 6c | OF auth|or ON {l|
|000054d0| 74 7d 0a 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |t}.     |        |
|000054e0| 20 20 20 20 20 20 20 20 | 20 20 20 42 45 47 49 4e |        |   BEGIN|
|000054f0| 0a 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |.       |        |
|00005500| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 53 45 4c |        |     SEL|
|00005510| 45 43 54 20 43 41 53 45 | 0a 20 20 20 20 20 20 20 |ECT CASE|.       |
|00005520| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |        |        |
|00005530| 20 20 20 20 20 20 20 20 | 20 57 48 45 4e 20 28 53 |        | WHEN (S|
|00005540| 45 4c 45 43 54 20 69 64 | 20 66 72 6f 6d 20 7b 74 |ELECT id| from {t|
|00005550| 61 62 6c 65 7d 20 57 48 | 45 52 45 20 69 64 3d 4e |able} WH|ERE id=N|
|00005560| 45 57 2e 76 61 6c 75 65 | 29 20 49 53 20 4e 55 4c |EW.value|) IS NUL|
|00005570| 4c 0a 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |L.      |        |
|00005580| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |        |        |
|00005590| 20 20 54 48 45 4e 20 52 | 41 49 53 45 28 41 42 4f |  THEN R|AISE(ABO|
|000055a0| 52 54 2c 20 27 46 6f 72 | 65 69 67 6e 20 6b 65 79 |RT, 'For|eign key|
|000055b0| 20 76 69 6f 6c 61 74 69 | 6f 6e 3a 20 76 61 6c 75 | violati|on: valu|
|000055c0| 65 20 6e 6f 74 20 69 6e | 20 7b 74 61 62 6c 65 7d |e not in| {table}|
|000055d0| 27 29 0a 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |').     |        |
|000055e0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 45 |        |       E|
|000055f0| 4e 44 3b 0a 20 20 20 20 | 20 20 20 20 20 20 20 20 |ND;.    |        |
|00005600| 20 20 20 20 20 20 20 20 | 20 20 20 20 45 4e 44 3b |        |    END;|
|00005610| 0a 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |.       |        |
|00005620| 20 43 52 45 41 54 45 20 | 54 52 49 47 47 45 52 20 | CREATE |TRIGGER |
|00005630| 66 6b 63 5f 69 6e 73 65 | 72 74 5f 7b 6c 74 7d 0a |fkc_inse|rt_{lt}.|
|00005640| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |        |        |
|00005650| 20 20 20 20 20 20 20 20 | 42 45 46 4f 52 45 20 49 |        |BEFORE I|
|00005660| 4e 53 45 52 54 20 4f 4e | 20 7b 6c 74 7d 0a 20 20 |NSERT ON| {lt}.  |
|00005670| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |        |        |
|00005680| 20 20 20 20 20 20 42 45 | 47 49 4e 0a 20 20 20 20 |      BE|GIN.    |
|00005690| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |        |        |
|000056a0| 20 20 20 20 20 20 20 20 | 53 45 4c 45 43 54 20 43 |        |SELECT C|
|000056b0| 41 53 45 0a 20 20 20 20 | 20 20 20 20 20 20 20 20 |ASE.    |        |
|000056c0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |        |        |
|000056d0| 20 20 20 20 57 48 45 4e | 20 28 53 45 4c 45 43 54 |    WHEN| (SELECT|
|000056e0| 20 69 64 20 66 72 6f 6d | 20 62 6f 6f 6b 73 20 57 | id from| books W|
|000056f0| 48 45 52 45 20 69 64 3d | 4e 45 57 2e 62 6f 6f 6b |HERE id=|NEW.book|
|00005700| 29 20 49 53 20 4e 55 4c | 4c 0a 20 20 20 20 20 20 |) IS NUL|L.      |
|00005710| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |        |        |
|00005720| 20 20 20 20 20 20 20 20 | 20 20 54 48 45 4e 20 52 |        |  THEN R|
|00005730| 41 49 53 45 28 41 42 4f | 52 54 2c 20 27 46 6f 72 |AISE(ABO|RT, 'For|
|00005740| 65 69 67 6e 20 6b 65 79 | 20 76 69 6f 6c 61 74 69 |eign key| violati|
|00005750| 6f 6e 3a 20 62 6f 6f 6b | 20 6e 6f 74 20 69 6e 20 |on: book| not in |
|00005760| 62 6f 6f 6b 73 27 29 0a | 20 20 20 20 20 20 20 20 |books').|        |
|00005770| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |        |        |
|00005780| 20 20 20 20 20 20 20 20 | 57 48 45 4e 20 28 53 45 |        |WHEN (SE|
|00005790| 4c 45 43 54 20 69 64 20 | 66 72 6f 6d 20 7b 74 61 |LECT id |from {ta|
|000057a0| 62 6c 65 7d 20 57 48 45 | 52 45 20 69 64 3d 4e 45 |ble} WHE|RE id=NE|
|000057b0| 57 2e 76 61 6c 75 65 29 | 20 49 53 20 4e 55 4c 4c |W.value)| IS NULL|
|000057c0| 0a 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |.       |        |
|000057d0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |        |        |
|000057e0| 20 54 48 45 4e 20 52 41 | 49 53 45 28 41 42 4f 52 | THEN RA|ISE(ABOR|
|000057f0| 54 2c 20 27 46 6f 72 65 | 69 67 6e 20 6b 65 79 20 |T, 'Fore|ign key |
|00005800| 76 69 6f 6c 61 74 69 6f | 6e 3a 20 76 61 6c 75 65 |violatio|n: value|
|00005810| 20 6e 6f 74 20 69 6e 20 | 7b 74 61 62 6c 65 7d 27 | not in |{table}'|
|00005820| 29 0a 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |).      |        |
|00005830| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 45 4e |        |      EN|
|00005840| 44 3b 0a 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |D;.     |        |
|00005850| 20 20 20 20 20 20 20 20 | 20 20 20 45 4e 44 3b 0a |        |   END;.|
|00005860| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |        |        |
|00005870| 43 52 45 41 54 45 20 54 | 52 49 47 47 45 52 20 66 |CREATE T|RIGGER f|
|00005880| 6b 63 5f 64 65 6c 65 74 | 65 5f 7b 6c 74 7d 0a 20 |kc_delet|e_{lt}. |
|00005890| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |        |        |
|000058a0| 20 20 20 20 20 20 20 41 | 46 54 45 52 20 44 45 4c |       A|FTER DEL|
|000058b0| 45 54 45 20 4f 4e 20 7b | 74 61 62 6c 65 7d 0a 20 |ETE ON {|table}. |
|000058c0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |        |        |
|000058d0| 20 20 20 20 20 20 20 42 | 45 47 49 4e 0a 20 20 20 |       B|EGIN.   |
|000058e0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |        |        |
|000058f0| 20 20 20 20 20 20 20 20 | 20 44 45 4c 45 54 45 20 |        | DELETE |
|00005900| 46 52 4f 4d 20 7b 6c 74 | 7d 20 57 48 45 52 45 20 |FROM {lt|} WHERE |
|00005910| 76 61 6c 75 65 3d 4f 4c | 44 2e 69 64 3b 0a 20 20 |value=OL|D.id;.  |
|00005920| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |        |        |
|00005930| 20 20 20 20 20 20 45 4e | 44 3b 0a 0a 20 20 20 20 |      EN|D;..    |
|00005940| 20 20 20 20 20 20 20 20 | 20 20 20 20 43 52 45 41 |        |    CREA|
|00005950| 54 45 20 56 49 45 57 20 | 74 61 67 5f 62 72 6f 77 |TE VIEW |tag_brow|
|00005960| 73 65 72 5f 7b 74 61 62 | 6c 65 7d 20 41 53 20 53 |ser_{tab|le} AS S|
|00005970| 45 4c 45 43 54 0a 20 20 | 20 20 20 20 20 20 20 20 |ELECT.  |        |
|00005980| 20 20 20 20 20 20 20 20 | 20 20 69 64 2c 0a 20 20 |        |  id,.  |
|00005990| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |        |        |
|000059a0| 20 20 76 61 6c 75 65 2c | 0a 20 20 20 20 20 20 20 |  value,|.       |
|000059b0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 28 53 45 |        |     (SE|
|000059c0| 4c 45 43 54 20 43 4f 55 | 4e 54 28 69 64 29 20 46 |LECT COU|NT(id) F|
|000059d0| 52 4f 4d 20 7b 6c 74 7d | 20 57 48 45 52 45 20 76 |ROM {lt}| WHERE v|
|000059e0| 61 6c 75 65 3d 7b 74 61 | 62 6c 65 7d 2e 69 64 29 |alue={ta|ble}.id)|
|000059f0| 20 63 6f 75 6e 74 2c 0a | 20 20 20 20 20 20 20 20 | count,.|        |
|00005a00| 20 20 20 20 20 20 20 20 | 20 20 20 20 28 53 45 4c |        |    (SEL|
|00005a10| 45 43 54 20 41 56 47 28 | 72 2e 72 61 74 69 6e 67 |ECT AVG(|r.rating|
|00005a20| 29 0a 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |).      |        |
|00005a30| 20 20 20 20 20 20 20 46 | 52 4f 4d 20 7b 6c 74 7d |       F|ROM {lt}|
|00005a40| 2c 0a 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |,.      |        |
|00005a50| 20 20 20 20 20 20 20 20 | 20 20 20 20 62 6f 6f 6b |        |    book|
|00005a60| 73 5f 72 61 74 69 6e 67 | 73 5f 6c 69 6e 6b 20 61 |s_rating|s_link a|
|00005a70| 73 20 62 6c 2c 0a 20 20 | 20 20 20 20 20 20 20 20 |s bl,.  |        |
|00005a80| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |        |        |
|00005a90| 72 61 74 69 6e 67 73 20 | 61 73 20 72 0a 20 20 20 |ratings |as r.   |
|00005aa0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |        |        |
|00005ab0| 20 20 57 48 45 52 45 20 | 7b 6c 74 7d 2e 76 61 6c |  WHERE |{lt}.val|
|00005ac0| 75 65 3d 7b 74 61 62 6c | 65 7d 2e 69 64 20 61 6e |ue={tabl|e}.id an|
|00005ad0| 64 20 62 6c 2e 62 6f 6f | 6b 3d 7b 6c 74 7d 2e 62 |d bl.boo|k={lt}.b|
|00005ae0| 6f 6f 6b 20 61 6e 64 0a | 20 20 20 20 20 20 20 20 |ook and.|        |
|00005af0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |        |        |
|00005b00| 20 20 20 72 2e 69 64 20 | 3d 20 62 6c 2e 72 61 74 |   r.id |= bl.rat|
|00005b10| 69 6e 67 20 61 6e 64 20 | 72 2e 72 61 74 69 6e 67 |ing and |r.rating|
|00005b20| 20 3c 3e 20 30 29 20 61 | 76 67 5f 72 61 74 69 6e | <> 0) a|vg_ratin|
|00005b30| 67 2c 0a 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |g,.     |        |
|00005b40| 20 20 20 20 20 20 20 76 | 61 6c 75 65 20 41 53 20 |       v|alue AS |
|00005b50| 73 6f 72 74 0a 20 20 20 | 20 20 20 20 20 20 20 20 |sort.   |        |
|00005b60| 20 20 20 20 20 46 52 4f | 4d 20 7b 74 61 62 6c 65 |     FRO|M {table|
|00005b70| 7d 3b 0a 0a 20 20 20 20 | 20 20 20 20 20 20 20 20 |};..    |        |
|00005b80| 20 20 20 20 43 52 45 41 | 54 45 20 56 49 45 57 20 |    CREA|TE VIEW |
|00005b90| 74 61 67 5f 62 72 6f 77 | 73 65 72 5f 66 69 6c 74 |tag_brow|ser_filt|
|00005ba0| 65 72 65 64 5f 7b 74 61 | 62 6c 65 7d 20 41 53 20 |ered_{ta|ble} AS |
|00005bb0| 53 45 4c 45 43 54 0a 20 | 20 20 20 20 20 20 20 20 |SELECT. |        |
|00005bc0| 20 20 20 20 20 20 20 20 | 20 20 20 69 64 2c 0a 20 |        |   id,. |
|00005bd0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |        |        |
|00005be0| 20 20 20 76 61 6c 75 65 | 2c 0a 20 20 20 20 20 20 |   value|,.      |
|00005bf0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 28 53 |        |      (S|
|00005c00| 45 4c 45 43 54 20 43 4f | 55 4e 54 28 7b 6c 74 7d |ELECT CO|UNT({lt}|
|00005c10| 2e 69 64 29 20 46 52 4f | 4d 20 7b 6c 74 7d 20 57 |.id) FRO|M {lt} W|
|00005c20| 48 45 52 45 20 76 61 6c | 75 65 3d 7b 74 61 62 6c |HERE val|ue={tabl|
|00005c30| 65 7d 2e 69 64 20 41 4e | 44 0a 20 20 20 20 20 20 |e}.id AN|D.      |
|00005c40| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 62 6f |        |      bo|
|00005c50| 6f 6b 73 5f 6c 69 73 74 | 5f 66 69 6c 74 65 72 28 |oks_list|_filter(|
|00005c60| 62 6f 6f 6b 29 29 20 63 | 6f 75 6e 74 2c 0a 20 20 |book)) c|ount,.  |
|00005c70| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |        |        |
|00005c80| 20 20 28 53 45 4c 45 43 | 54 20 41 56 47 28 72 2e |  (SELEC|T AVG(r.|
|00005c90| 72 61 74 69 6e 67 29 0a | 20 20 20 20 20 20 20 20 |rating).|        |
|00005ca0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 46 52 4f |        |     FRO|
|00005cb0| 4d 20 7b 6c 74 7d 2c 0a | 20 20 20 20 20 20 20 20 |M {lt},.|        |
|00005cc0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |        |        |
|00005cd0| 20 20 62 6f 6f 6b 73 5f | 72 61 74 69 6e 67 73 5f |  books_|ratings_|
|00005ce0| 6c 69 6e 6b 20 61 73 20 | 62 6c 2c 0a 20 20 20 20 |link as |bl,.    |
|00005cf0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |        |        |
|00005d00| 20 20 20 20 20 20 72 61 | 74 69 6e 67 73 20 61 73 |      ra|tings as|
|00005d10| 20 72 0a 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | r.     |        |
|00005d20| 20 20 20 20 20 20 20 20 | 57 48 45 52 45 20 7b 6c |        |WHERE {l|
|00005d30| 74 7d 2e 76 61 6c 75 65 | 3d 7b 74 61 62 6c 65 7d |t}.value|={table}|
|00005d40| 2e 69 64 20 41 4e 44 20 | 62 6c 2e 62 6f 6f 6b 3d |.id AND |bl.book=|
|00005d50| 7b 6c 74 7d 2e 62 6f 6f | 6b 20 41 4e 44 0a 20 20 |{lt}.boo|k AND.  |
|00005d60| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |        |        |
|00005d70| 20 20 20 20 20 20 20 20 | 20 72 2e 69 64 20 3d 20 |        | r.id = |
|00005d80| 62 6c 2e 72 61 74 69 6e | 67 20 41 4e 44 20 72 2e |bl.ratin|g AND r.|
|00005d90| 72 61 74 69 6e 67 20 3c | 3e 20 30 20 41 4e 44 0a |rating <|> 0 AND.|
|00005da0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |        |        |
|00005db0| 20 20 20 20 20 20 20 20 | 20 20 20 62 6f 6f 6b 73 |        |   books|
|00005dc0| 5f 6c 69 73 74 5f 66 69 | 6c 74 65 72 28 62 6c 2e |_list_fi|lter(bl.|
|00005dd0| 62 6f 6f 6b 29 29 20 61 | 76 67 5f 72 61 74 69 6e |book)) a|vg_ratin|
|00005de0| 67 2c 0a 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |g,.     |        |
|00005df0| 20 20 20 20 20 20 20 76 | 61 6c 75 65 20 41 53 20 |       v|alue AS |
|00005e00| 73 6f 72 74 0a 20 20 20 | 20 20 20 20 20 20 20 20 |sort.   |        |
|00005e10| 20 20 20 20 20 46 52 4f | 4d 20 7b 74 61 62 6c 65 |     FRO|M {table|
|00005e20| 7d 3b 0a 0a 20 20 20 20 | 20 20 20 20 20 20 20 20 |};..    |        |
|00005e30| 20 20 20 20 52 1b 00 00 | 00 52 1a 00 00 00 73 de |    R...|.R....s.|
|00005e40| 00 00 00 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |...     |        |
|00005e50| 20 20 20 43 52 45 41 54 | 45 20 54 41 42 4c 45 20 |   CREAT|E TABLE |
|00005e60| 25 73 28 0a 20 20 20 20 | 20 20 20 20 20 20 20 20 |%s(.    |        |
|00005e70| 20 20 20 20 20 20 20 20 | 69 64 20 20 20 20 49 4e |        |id    IN|
|00005e80| 54 45 47 45 52 20 50 52 | 49 4d 41 52 59 20 4b 45 |TEGER PR|IMARY KE|
|00005e90| 59 20 41 55 54 4f 49 4e | 43 52 45 4d 45 4e 54 2c |Y AUTOIN|CREMENT,|
|00005ea0| 0a 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |.       |        |
|00005eb0| 20 20 20 20 20 62 6f 6f | 6b 20 20 49 4e 54 45 47 |     boo|k  INTEG|
|00005ec0| 45 52 2c 0a 20 20 20 20 | 20 20 20 20 20 20 20 20 |ER,.    |        |
|00005ed0| 20 20 20 20 20 20 20 20 | 76 61 6c 75 65 20 25 73 |        |value %s|
|00005ee0| 20 4e 4f 54 20 4e 55 4c | 4c 20 25 73 2c 0a 20 20 | NOT NUL|L %s,.  |
|00005ef0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |        |        |
|00005f00| 20 20 55 4e 49 51 55 45 | 28 62 6f 6f 6b 29 29 3b |  UNIQUE|(book));|
|00005f10| 0a 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |.       |        |
|00005f20| 20 73 21 00 00 00 43 52 | 45 41 54 45 20 49 4e 44 | s!...CR|EATE IND|
|00005f30| 45 58 20 25 73 5f 69 64 | 78 20 4f 4e 20 25 73 20 |EX %s_id|x ON %s |
|00005f40| 28 62 6f 6f 6b 29 3b 73 | 4e 03 00 00 20 20 20 20 |(book);s|N...    |
|00005f50| 20 20 20 20 20 20 20 20 | 20 20 20 20 43 52 45 41 |        |    CREA|
|00005f60| 54 45 20 54 52 49 47 47 | 45 52 20 66 6b 63 5f 69 |TE TRIGG|ER fkc_i|
|00005f70| 6e 73 65 72 74 5f 7b 74 | 61 62 6c 65 7d 0a 20 20 |nsert_{t|able}.  |
|00005f80| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |        |        |
|00005f90| 20 20 20 20 20 20 42 45 | 46 4f 52 45 20 49 4e 53 |      BE|FORE INS|
|00005fa0| 45 52 54 20 4f 4e 20 7b | 74 61 62 6c 65 7d 0a 20 |ERT ON {|table}. |
|00005fb0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |        |        |
|00005fc0| 20 20 20 20 20 20 20 42 | 45 47 49 4e 0a 20 20 20 |       B|EGIN.   |
|00005fd0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |        |        |
|00005fe0| 20 20 20 20 20 20 20 20 | 20 53 45 4c 45 43 54 20 |        | SELECT |
|00005ff0| 43 41 53 45 0a 20 20 20 | 20 20 20 20 20 20 20 20 |CASE.   |        |
|00006000| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |        |        |
|00006010| 20 20 20 20 20 57 48 45 | 4e 20 28 53 45 4c 45 43 |     WHE|N (SELEC|
|00006020| 54 20 69 64 20 66 72 6f | 6d 20 62 6f 6f 6b 73 20 |T id fro|m books |
|00006030| 57 48 45 52 45 20 69 64 | 3d 4e 45 57 2e 62 6f 6f |WHERE id|=NEW.boo|
|00006040| 6b 29 20 49 53 20 4e 55 | 4c 4c 0a 20 20 20 20 20 |k) IS NU|LL.     |
|00006050| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |        |        |
|00006060| 20 20 20 20 20 20 20 20 | 20 20 20 54 48 45 4e 20 |        |   THEN |
|00006070| 52 41 49 53 45 28 41 42 | 4f 52 54 2c 20 27 46 6f |RAISE(AB|ORT, 'Fo|
|00006080| 72 65 69 67 6e 20 6b 65 | 79 20 76 69 6f 6c 61 74 |reign ke|y violat|
|00006090| 69 6f 6e 3a 20 62 6f 6f | 6b 20 6e 6f 74 20 69 6e |ion: boo|k not in|
|000060a0| 20 62 6f 6f 6b 73 27 29 | 0a 20 20 20 20 20 20 20 | books')|.       |
|000060b0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |        |        |
|000060c0| 20 20 20 20 20 45 4e 44 | 3b 0a 20 20 20 20 20 20 |     END|;.      |
|000060d0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |        |        |
|000060e0| 20 20 45 4e 44 3b 0a 20 | 20 20 20 20 20 20 20 20 |  END;. |        |
|000060f0| 20 20 20 20 20 20 20 43 | 52 45 41 54 45 20 54 52 |       C|REATE TR|
|00006100| 49 47 47 45 52 20 66 6b | 63 5f 75 70 64 61 74 65 |IGGER fk|c_update|
|00006110| 5f 7b 74 61 62 6c 65 7d | 0a 20 20 20 20 20 20 20 |_{table}|.       |
|00006120| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |        |        |
|00006130| 20 42 45 46 4f 52 45 20 | 55 50 44 41 54 45 20 4f | BEFORE |UPDATE O|
|00006140| 46 20 62 6f 6f 6b 20 4f | 4e 20 7b 74 61 62 6c 65 |F book O|N {table|
|00006150| 7d 0a 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |}.      |        |
|00006160| 20 20 20 20 20 20 20 20 | 20 20 42 45 47 49 4e 0a |        |  BEGIN.|
|00006170| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |        |        |
|00006180| 20 20 20 20 20 20 20 20 | 20 20 20 20 53 45 4c 45 |        |    SELE|
|00006190| 43 54 20 43 41 53 45 0a | 20 20 20 20 20 20 20 20 |CT CASE.|        |
|000061a0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |        |        |
|000061b0| 20 20 20 20 20 20 20 20 | 57 48 45 4e 20 28 53 45 |        |WHEN (SE|
|000061c0| 4c 45 43 54 20 69 64 20 | 66 72 6f 6d 20 62 6f 6f |LECT id |from boo|
|000061d0| 6b 73 20 57 48 45 52 45 | 20 69 64 3d 4e 45 57 2e |ks WHERE| id=NEW.|
|000061e0| 62 6f 6f 6b 29 20 49 53 | 20 4e 55 4c 4c 0a 20 20 |book) IS| NULL.  |
|000061f0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |        |        |
|00006200| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 54 48 |        |      TH|
|00006210| 45 4e 20 52 41 49 53 45 | 28 41 42 4f 52 54 2c 20 |EN RAISE|(ABORT, |
|00006220| 27 46 6f 72 65 69 67 6e | 20 6b 65 79 20 76 69 6f |'Foreign| key vio|
|00006230| 6c 61 74 69 6f 6e 3a 20 | 62 6f 6f 6b 20 6e 6f 74 |lation: |book not|
|00006240| 20 69 6e 20 62 6f 6f 6b | 73 27 29 0a 20 20 20 20 | in book|s').    |
|00006250| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |        |        |
|00006260| 20 20 20 20 20 20 20 20 | 45 4e 44 3b 0a 20 20 20 |        |END;.   |
|00006270| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |        |        |
|00006280| 20 20 20 20 20 45 4e 44 | 3b 0a 20 20 20 20 20 20 |     END|;.      |
|00006290| 20 20 20 20 20 20 20 20 | 20 20 73 02 00 00 00 20 |        |  s.... |
|000062a0| 0a 28 06 00 00 00 73 08 | 00 00 00 64 61 74 65 74 |.(....s.|...datet|
|000062b0| 69 6d 65 73 08 00 00 00 | 63 6f 6d 6d 65 6e 74 73 |imes....|comments|
|000062c0| 73 03 00 00 00 69 6e 74 | 73 04 00 00 00 62 6f 6f |s....int|s....boo|
|000062d0| 6c 73 05 00 00 00 66 6c | 6f 61 74 73 09 00 00 00 |ls....fl|oats....|
|000062e0| 63 6f 6d 70 6f 73 69 74 | 65 28 01 00 00 00 73 04 |composit|e(....s.|
|000062f0| 00 00 00 74 65 78 74 28 | 02 00 00 00 73 06 00 00 |...text(|....s...|
|00006300| 00 72 61 74 69 6e 67 73 | 03 00 00 00 69 6e 74 28 |.ratings|....int(|
|00006310| 04 00 00 00 73 04 00 00 | 00 74 65 78 74 73 08 00 |....s...|.texts..|
|00006320| 00 00 63 6f 6d 6d 65 6e | 74 73 73 06 00 00 00 73 |..commen|tss....s|
|00006330| 65 72 69 65 73 73 09 00 | 00 00 63 6f 6d 70 6f 73 |eriess..|..compos|
|00006340| 69 74 65 28 01 00 00 00 | 73 05 00 00 00 66 6c 6f |ite(....|s....flo|
|00006350| 61 74 28 12 00 00 00 52 | 44 00 00 00 74 01 00 00 |at(....R|D...t...|
|00006360| 00 5f 74 02 00 00 00 72 | 65 74 05 00 00 00 6d 61 |._t....r|et....ma|
|00006370| 74 63 68 52 25 00 00 00 | 74 07 00 00 00 69 73 61 |tchR%...|t....isa|
|00006380| 6c 70 68 61 52 60 00 00 | 00 52 42 00 00 00 52 15 |lphaR`..|.RB...R.|
|00006390| 00 00 00 52 47 00 00 00 | 52 4b 00 00 00 52 7c 00 |...RG...|RK...R|.|
|000063a0| 00 00 52 a6 00 00 00 52 | 13 00 00 00 52 46 00 00 |..R....R|....RF..|
|000063b0| 00 52 2d 00 00 00 52 45 | 00 00 00 52 48 00 00 00 |.R-...RE|...RH...|
|000063c0| 28 10 00 00 00 52 11 00 | 00 00 52 1c 00 00 00 52 |(....R..|..R....R|
|000063d0| 1d 00 00 00 52 1e 00 00 | 00 52 22 00 00 00 52 1f |....R...|.R"...R.|
|000063e0| 00 00 00 52 20 00 00 00 | 52 21 00 00 00 52 12 00 |...R ...|R!...R..|
|000063f0| 00 00 74 02 00 00 00 64 | 74 74 07 00 00 00 63 6f |..t....d|tt....co|
+--------+-------------------------+-------------------------+--------+--------+
Only 25.0 KB of data is shown above.