home *** CD-ROM | disk | FTP | other *** search
| Unknown | 2010-08-06 | 22.1 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%
| detectItEasy
| Format: Python Compiled Module(2.6a1)
| default
|
|
hex view+--------+-------------------------+-------------------------+--------+--------+
|00000000| d1 f2 0d 0a 93 8d 40 4c | 63 00 00 00 00 00 00 00 |......@L|c.......|
|00000010| 00 0b 00 00 00 40 80 00 | 00 73 a8 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| 06 00 6b 06 00 6c 07 00 | 5a 07 00 01 64 00 00 64 |..k..l..|Z...d..d|
|00000060| 07 00 6b 08 00 6c 09 00 | 5a 09 00 01 64 00 00 64 |..k..l..|Z...d..d|
|00000070| 08 00 6b 0a 00 6c 0b 00 | 5a 0b 00 01 64 00 00 64 |..k..l..|Z...d..d|
|00000080| 09 00 6b 0c 00 6c 0d 00 | 5a 0d 00 01 64 00 00 64 |..k..l..|Z...d..d|
|00000090| 0a 00 6b 0e 00 6c 0f 00 | 5a 0f 00 01 64 00 00 64 |..k..l..|Z...d..d|
|000000a0| 0b 00 6b 10 00 6c 11 00 | 5a 11 00 01 64 0c 00 65 |..k..l..|Z...d..e|
|000000b0| 12 00 66 01 00 64 0d 00 | 84 00 00 83 00 00 59 5a |..f..d..|......YZ|
|000000c0| 13 00 64 05 00 53 28 0e | 00 00 00 69 ff ff ff ff |..d..S(.|...i....|
|000000d0| 28 01 00 00 00 74 0e 00 | 00 00 77 69 74 68 5f 73 |(....t..|..with_s|
|000000e0| 74 61 74 65 6d 65 6e 74 | 73 06 00 00 00 47 50 4c |tatement|s....GPL|
|000000f0| 20 76 33 73 28 00 00 00 | 32 30 31 30 2c 20 4b 6f | v3s(...|2010, Ko|
|00000100| 76 69 64 20 47 6f 79 61 | 6c 20 3c 6b 6f 76 69 64 |vid Goya|l <kovid|
|00000110| 40 6b 6f 76 69 64 67 6f | 79 61 6c 2e 6e 65 74 3e |@kovidgo|yal.net>|
|00000120| 73 13 00 00 00 72 65 73 | 74 72 75 63 74 75 72 65 |s....res|tructure|
|00000130| 64 74 65 78 74 20 65 6e | 4e 28 01 00 00 00 74 07 |dtext en|N(....t.|
|00000140| 00 00 00 70 61 72 74 69 | 61 6c 28 01 00 00 00 74 |...parti|al(....t|
|00000150| 05 00 00 00 66 6c 6f 6f | 72 28 01 00 00 00 74 06 |....floo|r(....t.|
|00000160| 00 00 00 70 72 69 6e 74 | 73 28 01 00 00 00 74 12 |...print|s(....t.|
|00000170| 00 00 00 70 72 65 66 65 | 72 72 65 64 5f 65 6e 63 |...prefe|rred_enc|
|00000180| 6f 64 69 6e 67 28 01 00 | 00 00 74 0d 00 00 00 46 |oding(..|..t....F|
|00000190| 69 65 6c 64 4d 65 74 61 | 64 61 74 61 28 01 00 00 |ieldMeta|data(...|
|000001a0| 00 74 0a 00 00 00 70 61 | 72 73 65 5f 64 61 74 65 |.t....pa|rse_date|
|000001b0| 74 0d 00 00 00 43 75 73 | 74 6f 6d 43 6f 6c 75 6d |t....Cus|tomColum|
|000001c0| 6e 73 63 00 00 00 00 00 | 00 00 00 09 00 00 00 42 |nsc.....|.......B|
|000001d0| 80 00 00 73 19 01 00 00 | 65 00 00 5a 01 00 65 02 |...s....|e..Z..e.|
|000001e0| 00 64 00 00 64 01 00 64 | 02 00 64 03 00 64 04 00 |.d..d..d|..d..d..|
|000001f0| 64 05 00 64 06 00 64 07 | 00 67 08 00 83 01 00 5a |d..d..d.|.g.....Z|
|00000200| 03 00 64 08 00 84 00 00 | 5a 04 00 65 05 00 64 09 |..d.....|Z..e..d.|
|00000210| 00 84 00 00 83 01 00 5a | 06 00 64 0a 00 84 00 00 |.......Z|..d.....|
|00000220| 5a 07 00 64 18 00 64 18 | 00 65 09 00 64 0b 00 84 |Z..d..d.|.e..d...|
|00000230| 03 00 5a 0a 00 64 18 00 | 64 18 00 65 09 00 64 0c |..Z..d..|d..e..d.|
|00000240| 00 84 03 00 5a 0b 00 64 | 18 00 64 18 00 64 0d 00 |....Z..d|..d..d..|
|00000250| 84 02 00 5a 0c 00 64 18 | 00 64 18 00 64 0e 00 84 |...Z..d.|.d..d...|
|00000260| 02 00 5a 0d 00 64 18 00 | 64 18 00 64 0f 00 84 02 |..Z..d..|d..d....|
|00000270| 00 5a 0e 00 64 18 00 64 | 18 00 64 10 00 84 02 00 |.Z..d..d|..d.....|
|00000280| 5a 0f 00 64 18 00 64 18 | 00 64 11 00 84 02 00 5a |Z..d..d.|.d.....Z|
|00000290| 10 00 64 18 00 64 18 00 | 64 12 00 84 02 00 5a 11 |..d..d..|d.....Z.|
|000002a0| 00 64 18 00 64 18 00 64 | 18 00 64 18 00 64 13 00 |.d..d..d|..d..d..|
|000002b0| 84 04 00 5a 12 00 64 18 | 00 64 18 00 65 09 00 65 |...Z..d.|.d..e..e|
|000002c0| 13 00 64 18 00 64 14 00 | 84 05 00 5a 14 00 64 15 |..d..d..|...Z..d.|
|000002d0| 00 84 00 00 5a 15 00 64 | 16 00 84 00 00 5a 16 00 |....Z..d|.....Z..|
|000002e0| 65 13 00 68 00 00 64 17 | 00 84 02 00 5a 17 00 52 |e..h..d.|....Z..R|
|000002f0| 53 28 19 00 00 00 74 06 | 00 00 00 72 61 74 69 6e |S(....t.|...ratin|
|00000300| 67 74 04 00 00 00 74 65 | 78 74 74 08 00 00 00 63 |gt....te|xtt....c|
|00000310| 6f 6d 6d 65 6e 74 73 74 | 08 00 00 00 64 61 74 65 |ommentst|....date|
|00000320| 74 69 6d 65 74 03 00 00 | 00 69 6e 74 74 05 00 00 |timet...|.intt...|
|00000330| 00 66 6c 6f 61 74 74 04 | 00 00 00 62 6f 6f 6c 74 |.floatt.|...boolt|
|00000340| 06 00 00 00 73 65 72 69 | 65 73 63 02 00 00 00 02 |....seri|esc.....|
|00000350| 00 00 00 03 00 00 00 43 | 80 00 00 73 12 00 00 00 |.......C|...s....|
|00000360| 64 01 00 7c 01 00 16 64 | 02 00 7c 01 00 16 66 02 |d..|...d|..|...f.|
|00000370| 00 53 28 03 00 00 00 4e | 73 10 00 00 00 63 75 73 |.S(....N|s....cus|
|00000380| 74 6f 6d 5f 63 6f 6c 75 | 6d 6e 5f 25 64 73 1b 00 |tom_colu|mn_%ds..|
|00000390| 00 00 62 6f 6f 6b 73 5f | 63 75 73 74 6f 6d 5f 63 |..books_|custom_c|
|000003a0| 6f 6c 75 6d 6e 5f 25 64 | 5f 6c 69 6e 6b 28 00 00 |olumn_%d|_link(..|
|000003b0| 00 00 28 02 00 00 00 74 | 04 00 00 00 73 65 6c 66 |..(....t|....self|
|000003c0| 74 03 00 00 00 6e 75 6d | 28 00 00 00 00 28 00 00 |t....num|(....(..|
|000003d0| 00 00 73 2f 00 00 00 73 | 69 74 65 2d 70 61 63 6b |..s/...s|ite-pack|
|000003e0| 61 67 65 73 5c 63 61 6c | 69 62 72 65 5c 6c 69 62 |ages\cal|ibre\lib|
|000003f0| 72 61 72 79 5c 63 75 73 | 74 6f 6d 5f 63 6f 6c 75 |rary\cus|tom_colu|
|00000400| 6d 6e 73 2e 70 79 74 12 | 00 00 00 63 75 73 74 6f |mns.pyt.|...custo|
|00000410| 6d 5f 74 61 62 6c 65 5f | 6e 61 6d 65 73 17 00 00 |m_table_|names...|
|00000420| 00 73 02 00 00 00 00 01 | 63 01 00 00 00 03 00 00 |.s......|c.......|
|00000430| 00 06 00 00 00 43 80 00 | 00 73 35 00 00 00 74 00 |.....C..|.s5...t.|
|00000440| 00 67 00 00 04 7d 01 00 | 7c 00 00 69 01 00 69 02 |.g...}..||..i..i.|
|00000450| 00 64 01 00 83 01 00 44 | 5d 11 00 7d 02 00 7c 01 |.d.....D|]..}..|.|
|00000460| 00 7c 02 00 64 02 00 19 | 12 71 1a 00 7e 01 00 83 |.|..d...|.q..~...|
|00000470| 01 00 53 28 03 00 00 00 | 4e 73 78 00 00 00 53 45 |..S(....|Nsx...SE|
|00000480| 4c 45 43 54 20 6e 61 6d | 65 20 46 52 4f 4d 20 73 |LECT nam|e FROM s|
|00000490| 71 6c 69 74 65 5f 6d 61 | 73 74 65 72 20 57 48 45 |qlite_ma|ster WHE|
|000004a0| 52 45 20 74 79 70 65 3d | 22 74 61 62 6c 65 22 20 |RE type=|"table" |
|000004b0| 41 4e 44 20 28 6e 61 6d | 65 20 47 4c 4f 42 20 22 |AND (nam|e GLOB "|
|000004c0| 63 75 73 74 6f 6d 5f 63 | 6f 6c 75 6d 6e 5f 2a 22 |custom_c|olumn_*"|
|000004d0| 20 4f 52 20 6e 61 6d 65 | 20 47 4c 4f 42 20 22 62 | OR name| GLOB "b|
|000004e0| 6f 6f 6b 73 5f 63 75 73 | 74 6f 6d 5f 63 6f 6c 75 |ooks_cus|tom_colu|
|000004f0| 6d 6e 5f 2a 22 29 69 00 | 00 00 00 28 03 00 00 00 |mn_*")i.|...(....|
|00000500| 74 03 00 00 00 73 65 74 | 74 04 00 00 00 63 6f 6e |t....set|t....con|
|00000510| 6e 74 03 00 00 00 67 65 | 74 28 03 00 00 00 52 10 |nt....ge|t(....R.|
|00000520| 00 00 00 74 04 00 00 00 | 5f 5b 31 5d 74 01 00 00 |...t....|_[1]t...|
|00000530| 00 78 28 00 00 00 00 28 | 00 00 00 00 73 2f 00 00 |.x(....(|....s/..|
|00000540| 00 73 69 74 65 2d 70 61 | 63 6b 61 67 65 73 5c 63 |.site-pa|ckages\c|
|00000550| 61 6c 69 62 72 65 5c 6c | 69 62 72 61 72 79 5c 63 |alibre\l|ibrary\c|
|00000560| 75 73 74 6f 6d 5f 63 6f | 6c 75 6d 6e 73 2e 70 79 |ustom_co|lumns.py|
|00000570| 74 0d 00 00 00 63 75 73 | 74 6f 6d 5f 74 61 62 6c |t....cus|tom_tabl|
|00000580| 65 73 1a 00 00 00 73 04 | 00 00 00 00 02 13 01 63 |es....s.|.......c|
|00000590| 01 00 00 00 11 00 00 00 | 1e 00 00 00 03 80 00 00 |........|........|
|000005a0| 73 de 03 00 00 74 00 00 | 7c 00 00 69 01 00 74 02 |s....t..||..i..t.|
|000005b0| 00 69 03 00 18 83 01 00 | 64 01 00 6a 04 00 6f 10 |.i......|d..j..o.|
|000005c0| 00 01 74 04 00 64 02 00 | 83 01 00 82 01 00 6e 01 |..t..d..|......n.|
|000005d0| 00 01 78 5b 00 7c 00 00 | 69 05 00 69 06 00 64 03 |..x[.|..|i..i..d.|
|000005e0| 00 83 01 00 44 5d 47 00 | 7d 01 00 7c 01 00 64 01 |....D]G.|}..|..d.|
|000005f0| 00 19 7d 02 00 7c 00 00 | 69 07 00 7c 02 00 83 01 |..}..|..|i..|....|
|00000600| 00 5c 02 00 7d 03 00 7d | 04 00 7c 00 00 69 05 00 |.\..}..}|..|..i..|
|00000610| 69 08 00 64 04 00 69 09 | 00 64 05 00 7c 03 00 64 |i..d..i.|.d..|..d|
|00000620| 06 00 7c 04 00 83 00 02 | 83 01 00 01 71 40 00 57 |..|.....|....q@.W|
|00000630| 7c 00 00 69 05 00 69 0a | 00 64 07 00 83 01 00 01 ||..i..i.|.d......|
|00000640| 7c 00 00 69 05 00 69 0b | 00 83 00 00 01 68 00 00 ||..i..i.|.....h..|
|00000650| 68 00 00 02 7c 00 00 5f | 0c 00 7c 00 00 5f 0d 00 |h...|.._|..|.._..|
|00000660| 67 00 00 7d 05 00 67 00 | 00 7d 06 00 7c 00 00 69 |g..}..g.|.}..|..i|
|00000670| 0e 00 7d 07 00 78 38 01 | 7c 00 00 69 05 00 69 06 |..}..x8.||..i..i.|
|00000680| 00 64 08 00 83 01 00 44 | 5d 24 01 7d 01 00 68 08 |.d.....D|]$.}..h.|
|00000690| 00 7c 01 00 64 01 00 19 | 64 09 00 36 7c 01 00 64 |.|..d...|d..6|..d|
|000006a0| 0a 00 19 64 0b 00 36 7c | 01 00 64 0c 00 19 64 0d |...d..6||..d...d.|
|000006b0| 00 36 7c 01 00 64 0e 00 | 19 64 0f 00 36 74 0f 00 |.6|..d..|.d..6t..|
|000006c0| 69 10 00 7c 01 00 64 10 | 00 19 83 01 00 64 11 00 |i..|..d.|.....d..|
|000006d0| 36 7c 01 00 64 12 00 19 | 64 13 00 36 7c 01 00 64 |6|..d...|d..6|..d|
|000006e0| 14 00 19 64 15 00 36 7c | 01 00 64 16 00 19 64 17 |...d..6||..d...d.|
|000006f0| 00 36 7d 08 00 7c 00 00 | 69 07 00 7c 08 00 64 15 |.6}..|..|i..|..d.|
|00000700| 00 19 83 01 00 5c 02 00 | 7d 03 00 7d 04 00 7c 03 |.....\..|}..}..|.|
|00000710| 00 7c 07 00 6a 07 00 70 | 18 00 01 7c 08 00 64 13 |.|..j..p|...|..d.|
|00000720| 00 19 6f 21 00 01 7c 04 | 00 7c 07 00 6a 07 00 6f |..o!..|.|.|..j..o|
|00000730| 14 00 01 7c 06 00 69 11 | 00 7c 08 00 83 01 00 01 |...|..i.|.|......|
|00000740| 71 e3 00 6e 01 00 01 7c | 08 00 64 15 00 19 7c 00 |q..n...||..d...|.|
|00000750| 00 69 0c 00 7c 08 00 64 | 09 00 19 3c 7c 08 00 04 |.i..|..d|...<|...|
|00000760| 7c 00 00 69 0d 00 7c 08 | 00 64 15 00 19 3c 7c 00 ||..i..|.|.d...<|.|
|00000770| 00 69 0c 00 7c 08 00 64 | 09 00 19 3c 7c 08 00 64 |.i..|..d|...<|..d|
|00000780| 13 00 19 6f 0e 00 01 64 | 18 00 7c 04 00 16 7d 09 |...o...d|..|...}.|
|00000790| 00 6e 0b 00 01 64 18 00 | 7c 03 00 16 7d 09 00 7c |.n...d..||...}..||
|000007a0| 05 00 69 11 00 7c 09 00 | 83 01 00 01 71 e3 00 57 |..i..|..|....q..W|
|000007b0| 7c 06 00 6f 4e 00 01 78 | 3a 00 7c 06 00 44 5d 32 ||..oN..x|:.|..D]2|
|000007c0| 00 7d 08 00 74 12 00 64 | 19 00 7c 08 00 64 09 00 |.}..t..d|..|..d..|
|000007d0| 19 16 83 01 00 01 7c 00 | 00 69 05 00 69 0a 00 64 |......|.|.i..i..d|
|000007e0| 1a 00 7c 08 00 64 15 00 | 19 66 01 00 83 02 00 01 |..|..d..|.f......|
|000007f0| 71 19 02 57 7c 00 00 69 | 05 00 69 0b 00 83 00 00 |q..W|..i|..i.....|
|00000800| 01 6e 01 00 01 7c 05 00 | 6f 2e 00 01 7c 00 00 69 |.n...|..|o...|..i|
|00000810| 05 00 69 0a 00 64 1b 00 | 64 1c 00 69 13 00 7c 05 |..i..d..|d..i..|.|
|00000820| 00 83 01 00 16 83 01 00 | 01 7c 00 00 69 05 00 69 |........|.|..i..i|
|00000830| 0b 00 83 00 00 01 6e 01 | 00 01 64 1d 00 84 00 00 |......n.|..d.....|
|00000840| 89 00 00 64 1e 00 84 00 | 00 7d 0a 00 64 1f 00 84 |...d....|.}..d...|
|00000850| 00 00 7d 0b 00 68 08 00 | 64 20 00 84 00 00 64 21 |..}..h..|d ....d!|
|00000860| 00 36 64 22 00 84 00 00 | 64 23 00 36 64 24 00 84 |.6d"....|d#.6d$..|
|00000870| 00 00 64 25 00 36 7c 0b | 00 64 26 00 36 87 00 00 |..d%.6|.|.d&.6...|
|00000880| 66 01 00 64 27 00 86 00 | 00 64 28 00 36 7c 0a 00 |f..d'...|.d(.6|..|
|00000890| 64 29 00 36 88 00 00 64 | 2a 00 36 88 00 00 64 2b |d).6...d|*.6...d+|
|000008a0| 00 36 7c 00 00 5f 14 00 | 78 d4 00 74 15 00 7c 00 |.6|.._..|x..t..|.|
|000008b0| 00 69 0c 00 69 16 00 83 | 00 00 83 01 00 44 5d bd |.i..i...|.....D].|
|000008c0| 00 7d 0c 00 7c 00 00 69 | 0c 00 7c 0c 00 19 7d 0d |.}..|..i|..|...}.|
|000008d0| 00 7c 0d 00 64 13 00 19 | 6f 0a 00 01 74 17 00 7d |.|..d...|o...t..}|
|000008e0| 0e 00 6e 07 00 01 74 18 | 00 7d 0e 00 7c 0d 00 64 |..n...t.|.}..|..d|
|000008f0| 17 00 19 6f 0a 00 01 64 | 2c 00 7d 0f 00 6e 07 00 |...o...d|,.}..n..|
|00000900| 01 64 00 00 7d 0f 00 64 | 2d 00 69 09 00 7c 0d 00 |.d..}..d|-.i..|..|
|00000910| 64 15 00 19 83 01 00 7d | 10 00 7c 00 00 69 1a 00 |d......}|..|..i..|
|00000920| 69 1b 00 64 09 00 7c 0d | 00 64 09 00 19 64 05 00 |i..d..|.|.d...d..|
|00000930| 7c 10 00 64 2e 00 64 2f | 00 64 0d 00 7c 0d 00 64 ||..d..d/|.d..|..d|
|00000940| 0d 00 19 64 30 00 7c 0d | 00 64 15 00 19 64 0b 00 |...d0.|.|.d...d..|
|00000950| 7c 0d 00 64 0b 00 19 64 | 11 00 7c 0d 00 64 11 00 ||..d...d|..|..d..|
|00000960| 19 64 17 00 7c 0f 00 64 | 31 00 7c 0e 00 64 32 00 |.d..|..d|1.|..d2.|
|00000970| 7c 0d 00 64 0f 00 19 83 | 00 0a 01 71 19 03 57 64 ||..d....|...q..Wd|
|00000980| 00 00 53 28 33 00 00 00 | 4e 69 00 00 00 00 73 21 |..S(3...|Ni....s!|
|00000990| 00 00 00 55 6e 6b 6e 6f | 77 6e 20 63 75 73 74 6f |...Unkno|wn custo|
|000009a0| 6d 20 63 6f 6c 75 6d 6e | 20 74 79 70 65 20 69 6e |m column| type in|
|000009b0| 20 73 65 74 73 35 00 00 | 00 53 45 4c 45 43 54 20 | sets5..|.SELECT |
|000009c0| 69 64 20 46 52 4f 4d 20 | 63 75 73 74 6f 6d 5f 63 |id FROM |custom_c|
|000009d0| 6f 6c 75 6d 6e 73 20 57 | 48 45 52 45 20 6d 61 72 |olumns W|HERE mar|
|000009e0| 6b 5f 66 6f 72 5f 64 65 | 6c 65 74 65 3d 31 73 18 |k_for_de|lete=1s.|
|000009f0| 03 00 00 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |... | |
|00000a00| 20 20 20 20 20 20 20 44 | 52 4f 50 20 49 4e 44 45 | D|ROP INDE|
|00000a10| 58 20 20 20 49 46 20 45 | 58 49 53 54 53 20 7b 74 |X IF E|XISTS {t|
|00000a20| 61 62 6c 65 7d 5f 69 64 | 78 3b 0a 20 20 20 20 20 |able}_id|x;. |
|00000a30| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 44 | | D|
|00000a40| 52 4f 50 20 49 4e 44 45 | 58 20 20 20 49 46 20 45 |ROP INDE|X IF E|
|00000a50| 58 49 53 54 53 20 7b 6c | 74 7d 5f 61 69 64 78 3b |XISTS {l|t}_aidx;|
|00000a60| 0a 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |. | |
|00000a70| 20 20 20 20 20 44 52 4f | 50 20 49 4e 44 45 58 20 | DRO|P INDEX |
|00000a80| 20 20 49 46 20 45 58 49 | 53 54 53 20 7b 6c 74 7d | IF EXI|STS {lt}|
|00000a90| 5f 62 69 64 78 3b 0a 20 | 20 20 20 20 20 20 20 20 |_bidx;. | |
|00000aa0| 20 20 20 20 20 20 20 20 | 20 20 20 44 52 4f 50 20 | | DROP |
|00000ab0| 54 52 49 47 47 45 52 20 | 49 46 20 45 58 49 53 54 |TRIGGER |IF EXIST|
|00000ac0| 53 20 66 6b 63 5f 75 70 | 64 61 74 65 5f 7b 6c 74 |S fkc_up|date_{lt|
|00000ad0| 7d 5f 61 3b 0a 20 20 20 | 20 20 20 20 20 20 20 20 |}_a;. | |
|00000ae0| 20 20 20 20 20 20 20 20 | 20 44 52 4f 50 20 54 52 | | DROP TR|
|00000af0| 49 47 47 45 52 20 49 46 | 20 45 58 49 53 54 53 20 |IGGER IF| EXISTS |
|00000b00| 66 6b 63 5f 75 70 64 61 | 74 65 5f 7b 6c 74 7d 5f |fkc_upda|te_{lt}_|
|00000b10| 62 3b 0a 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |b;. | |
|00000b20| 20 20 20 20 20 20 20 44 | 52 4f 50 20 54 52 49 47 | D|ROP TRIG|
|00000b30| 47 45 52 20 49 46 20 45 | 58 49 53 54 53 20 66 6b |GER IF E|XISTS fk|
|00000b40| 63 5f 69 6e 73 65 72 74 | 5f 7b 6c 74 7d 3b 0a 20 |c_insert|_{lt};. |
|00000b50| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00000b60| 20 20 20 44 52 4f 50 20 | 54 52 49 47 47 45 52 20 | DROP |TRIGGER |
|00000b70| 49 46 20 45 58 49 53 54 | 53 20 66 6b 63 5f 64 65 |IF EXIST|S fkc_de|
|00000b80| 6c 65 74 65 5f 7b 6c 74 | 7d 3b 0a 20 20 20 20 20 |lete_{lt|};. |
|00000b90| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 44 | | D|
|00000ba0| 52 4f 50 20 54 52 49 47 | 47 45 52 20 49 46 20 45 |ROP TRIG|GER IF E|
|00000bb0| 58 49 53 54 53 20 66 6b | 63 5f 69 6e 73 65 72 74 |XISTS fk|c_insert|
|00000bc0| 5f 7b 74 61 62 6c 65 7d | 3b 0a 20 20 20 20 20 20 |_{table}|;. |
|00000bd0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 44 52 | | DR|
|00000be0| 4f 50 20 54 52 49 47 47 | 45 52 20 49 46 20 45 58 |OP TRIGG|ER IF EX|
|00000bf0| 49 53 54 53 20 66 6b 63 | 5f 64 65 6c 65 74 65 5f |ISTS fkc|_delete_|
|00000c00| 7b 74 61 62 6c 65 7d 3b | 0a 20 20 20 20 20 20 20 |{table};|. |
|00000c10| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 44 52 4f | | DRO|
|00000c20| 50 20 56 49 45 57 20 20 | 20 20 49 46 20 45 58 49 |P VIEW | IF EXI|
|00000c30| 53 54 53 20 74 61 67 5f | 62 72 6f 77 73 65 72 5f |STS tag_|browser_|
|00000c40| 7b 74 61 62 6c 65 7d 3b | 0a 20 20 20 20 20 20 20 |{table};|. |
|00000c50| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 44 52 4f | | DRO|
|00000c60| 50 20 56 49 45 57 20 20 | 20 20 49 46 20 45 58 49 |P VIEW | IF EXI|
|00000c70| 53 54 53 20 74 61 67 5f | 62 72 6f 77 73 65 72 5f |STS tag_|browser_|
|00000c80| 66 69 6c 74 65 72 65 64 | 5f 7b 74 61 62 6c 65 7d |filtered|_{table}|
|00000c90| 3b 0a 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |;. | |
|00000ca0| 20 20 20 20 20 20 44 52 | 4f 50 20 54 41 42 4c 45 | DR|OP TABLE|
|00000cb0| 20 20 20 49 46 20 45 58 | 49 53 54 53 20 7b 74 61 | IF EX|ISTS {ta|
|00000cc0| 62 6c 65 7d 3b 0a 20 20 | 20 20 20 20 20 20 20 20 |ble};. | |
|00000cd0| 20 20 20 20 20 20 20 20 | 20 20 44 52 4f 50 20 54 | | DROP T|
|00000ce0| 41 42 4c 45 20 20 20 49 | 46 20 45 58 49 53 54 53 |ABLE I|F EXISTS|
|00000cf0| 20 7b 6c 74 7d 3b 0a 20 | 20 20 20 20 20 20 20 20 | {lt};. | |
|00000d00| 20 20 20 20 20 20 20 20 | 20 20 20 74 05 00 00 00 | | t....|
|00000d10| 74 61 62 6c 65 74 02 00 | 00 00 6c 74 73 32 00 00 |tablet..|..lts2..|
|00000d20| 00 44 45 4c 45 54 45 20 | 46 52 4f 4d 20 63 75 73 |.DELETE |FROM cus|
|00000d30| 74 6f 6d 5f 63 6f 6c 75 | 6d 6e 73 20 57 48 45 52 |tom_colu|mns WHER|
|00000d40| 45 20 6d 61 72 6b 5f 66 | 6f 72 5f 64 65 6c 65 74 |E mark_f|or_delet|
|00000d50| 65 3d 31 73 59 00 00 00 | 53 45 4c 45 43 54 20 6c |e=1sY...|SELECT l|
|00000d60| 61 62 65 6c 2c 6e 61 6d | 65 2c 64 61 74 61 74 79 |abel,nam|e,dataty|
|00000d70| 70 65 2c 65 64 69 74 61 | 62 6c 65 2c 64 69 73 70 |pe,edita|ble,disp|
|00000d80| 6c 61 79 2c 6e 6f 72 6d | 61 6c 69 7a 65 64 2c 69 |lay,norm|alized,i|
|00000d90| 64 2c 69 73 5f 6d 75 6c | 74 69 70 6c 65 20 46 52 |d,is_mul|tiple FR|
|00000da0| 4f 4d 20 63 75 73 74 6f | 6d 5f 63 6f 6c 75 6d 6e |OM custo|m_column|
|00000db0| 73 74 05 00 00 00 6c 61 | 62 65 6c 69 01 00 00 00 |st....la|beli....|
|00000dc0| 74 04 00 00 00 6e 61 6d | 65 69 02 00 00 00 74 08 |t....nam|ei....t.|
|00000dd0| 00 00 00 64 61 74 61 74 | 79 70 65 69 03 00 00 00 |...datat|ypei....|
|00000de0| 74 08 00 00 00 65 64 69 | 74 61 62 6c 65 69 04 00 |t....edi|tablei..|
|00000df0| 00 00 74 07 00 00 00 64 | 69 73 70 6c 61 79 69 05 |..t....d|isplayi.|
|00000e00| 00 00 00 74 0a 00 00 00 | 6e 6f 72 6d 61 6c 69 7a |...t....|normaliz|
|00000e10| 65 64 69 06 00 00 00 52 | 11 00 00 00 69 07 00 00 |edi....R|....i...|
|00000e20| 00 74 0b 00 00 00 69 73 | 5f 6d 75 6c 74 69 70 6c |.t....is|_multipl|
|00000e30| 65 73 21 00 00 00 44 45 | 4c 45 54 45 20 46 52 4f |es!...DE|LETE FRO|
|00000e40| 4d 20 25 73 20 57 48 45 | 52 45 20 62 6f 6f 6b 3d |M %s WHE|RE book=|
|00000e50| 4f 4c 44 2e 69 64 3b 73 | 2e 00 00 00 57 41 52 4e |OLD.id;s|....WARN|
|00000e60| 49 4e 47 3a 20 43 75 73 | 74 6f 6d 20 63 6f 6c 75 |ING: Cus|tom colu|
|00000e70| 6d 6e 20 25 72 20 6e 6f | 74 20 66 6f 75 6e 64 2c |mn %r no|t found,|
|00000e80| 20 72 65 6d 6f 76 69 6e | 67 2e 73 25 00 00 00 44 | removin|g.s%...D|
|00000e90| 45 4c 45 54 45 20 46 52 | 4f 4d 20 63 75 73 74 6f |ELETE FR|OM custo|
|00000ea0| 6d 5f 63 6f 6c 75 6d 6e | 73 20 57 48 45 52 45 20 |m_column|s WHERE |
|00000eb0| 69 64 3d 3f 73 c0 00 00 | 00 20 20 20 20 20 20 20 |id=?s...|. |
|00000ec0| 20 20 20 20 20 20 20 20 | 20 43 52 45 41 54 45 20 | | CREATE |
|00000ed0| 54 45 4d 50 20 54 52 49 | 47 47 45 52 20 63 75 73 |TEMP TRI|GGER cus|
|00000ee0| 74 6f 6d 5f 62 6f 6f 6b | 73 5f 64 65 6c 65 74 65 |tom_book|s_delete|
|00000ef0| 5f 74 72 67 0a 20 20 20 | 20 20 20 20 20 20 20 20 |_trg. | |
|00000f00| 20 20 20 20 20 20 20 20 | 20 41 46 54 45 52 20 44 | | AFTER D|
|00000f10| 45 4c 45 54 45 20 4f 4e | 20 62 6f 6f 6b 73 0a 20 |ELETE ON| books. |
|00000f20| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00000f30| 20 20 20 42 45 47 49 4e | 0a 20 20 20 20 20 20 20 | BEGIN|. |
|00000f40| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 25 73 0a | | %s.|
|00000f50| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00000f60| 20 20 20 20 45 4e 44 3b | 0a 20 20 20 20 20 20 20 | END;|. |
|00000f70| 20 20 20 20 20 20 20 20 | 20 73 02 00 00 00 20 0a | | s.... .|
|00000f80| 63 02 00 00 00 06 00 00 | 00 09 00 00 00 53 80 00 |c.......|.....S..|
|00000f90| 00 73 2a 01 00 00 7c 01 | 00 64 01 00 19 6f e9 00 |.s*...|.|.d...o..|
|00000fa0| 01 7c 00 00 64 00 00 6a | 08 00 6f 05 00 01 67 00 |.|..d..j|..o...g.|
|00000fb0| 00 53 01 74 01 00 7c 00 | 00 74 02 00 74 03 00 74 |.S.t..|.|.t..t..t|
|00000fc0| 04 00 66 03 00 83 02 00 | 6f 13 00 01 7c 00 00 69 |..f.....|o...|..i|
|00000fd0| 05 00 64 02 00 83 01 00 | 7d 00 00 6e 01 00 01 67 |..d.....|}..n...g|
|00000fe0| 00 00 04 7d 02 00 7c 00 | 00 44 5d 24 00 7d 03 00 |...}..|.|.D]$.}..|
|00000ff0| 7c 03 00 69 06 00 83 00 | 00 6f 11 00 01 7c 02 00 ||..i....|.o...|..|
|00001000| 7c 03 00 69 06 00 83 00 | 00 12 71 54 00 01 71 54 ||..i....|..qT..qT|
|00001010| 00 7e 02 00 7d 00 00 67 | 00 00 04 7d 04 00 7c 00 |.~..}..g|...}..|.|
|00001020| 00 44 5d 30 00 7d 03 00 | 7c 04 00 74 01 00 7c 03 |.D]0.}..||..t..|.|
|00001030| 00 74 03 00 83 02 00 70 | 13 00 01 7c 03 00 69 07 |.t.....p|...|..i.|
|00001040| 00 74 08 00 64 03 00 83 | 02 00 6e 04 00 01 7c 03 |.t..d...|..n...|.|
|00001050| 00 12 71 8c 00 7e 04 00 | 7d 00 00 67 00 00 04 7d |..q..~..|}..g...}|
|00001060| 05 00 7c 00 00 44 5d 1c | 00 7d 03 00 7c 05 00 64 |..|..D].|.}..|..d|
|00001070| 04 00 69 09 00 7c 03 00 | 69 05 00 83 00 00 83 01 |..i..|..|i.......|
|00001080| 00 12 71 d0 00 7e 05 00 | 53 01 7c 00 00 64 00 00 |..q..~..|S.|..d..|
|00001090| 6a 08 00 70 10 00 01 74 | 01 00 7c 00 00 74 03 00 |j..p...t|..|..t..|
|000010a0| 83 02 00 6f 05 00 01 7c | 00 00 53 01 7c 00 00 69 |...o...||..S.|..i|
|000010b0| 07 00 74 08 00 64 03 00 | 83 02 00 53 64 00 00 53 |..t..d..|...Sd..S|
|000010c0| 28 05 00 00 00 4e 52 21 | 00 00 00 74 01 00 00 00 |(....NR!|...t....|
|000010d0| 2c 74 07 00 00 00 72 65 | 70 6c 61 63 65 75 01 00 |,t....re|placeu..|
|000010e0| 00 00 20 28 0a 00 00 00 | 74 04 00 00 00 4e 6f 6e |.. (....|t....Non|
|000010f0| 65 74 0a 00 00 00 69 73 | 69 6e 73 74 61 6e 63 65 |et....is|instance|
|00001100| 74 03 00 00 00 73 74 72 | 74 07 00 00 00 75 6e 69 |t....str|t....uni|
|00001110| 63 6f 64 65 74 05 00 00 | 00 62 79 74 65 73 74 05 |codet...|.bytest.|
|00001120| 00 00 00 73 70 6c 69 74 | 74 05 00 00 00 73 74 72 |...split|t....str|
|00001130| 69 70 74 06 00 00 00 64 | 65 63 6f 64 65 52 04 00 |ipt....d|ecodeR..|
|00001140| 00 00 74 04 00 00 00 6a | 6f 69 6e 28 06 00 00 00 |..t....j|oin(....|
|00001150| 52 17 00 00 00 74 01 00 | 00 00 64 52 16 00 00 00 |R....t..|..dR....|
|00001160| 74 01 00 00 00 79 74 04 | 00 00 00 5f 5b 32 5d 74 |t....yt.|..._[2]t|
|00001170| 04 00 00 00 5f 5b 33 5d | 28 00 00 00 00 28 00 00 |...._[3]|(....(..|
|00001180| 00 00 73 2f 00 00 00 73 | 69 74 65 2d 70 61 63 6b |..s/...s|ite-pack|
|00001190| 61 67 65 73 5c 63 61 6c | 69 62 72 65 5c 6c 69 62 |ages\cal|ibre\lib|
|000011a0| 72 61 72 79 5c 63 75 73 | 74 6f 6d 5f 63 6f 6c 75 |rary\cus|tom_colu|
|000011b0| 6d 6e 73 2e 70 79 74 0a | 00 00 00 61 64 61 70 74 |mns.pyt.|...adapt|
|000011c0| 5f 74 65 78 74 73 00 00 | 00 73 16 00 00 00 00 01 |_texts..|.s......|
|000011d0| 0b 01 0d 01 05 01 19 01 | 13 01 38 01 07 01 3d 01 |........|..8...=.|
|000011e0| 2f 02 22 01 63 02 00 00 | 00 02 00 00 00 06 00 00 |/.".c...|........|
|000011f0| 00 53 80 00 00 73 39 00 | 00 00 74 00 00 7c 00 00 |.S...s9.|..t..|..|
|00001200| 74 01 00 74 02 00 74 03 | 00 66 03 00 83 02 00 6f |t..t..t.|.f.....o|
|00001210| 1c 00 01 74 04 00 7c 00 | 00 64 01 00 74 05 00 64 |...t..|.|.d..t..d|
|00001220| 02 00 74 05 00 83 01 02 | 7d 00 00 6e 01 00 01 7c |..t.....|}..n...||
|00001230| 00 00 53 28 03 00 00 00 | 4e 74 0a 00 00 00 61 73 |..S(....|Nt....as|
|00001240| 73 75 6d 65 5f 75 74 63 | 74 06 00 00 00 61 73 5f |sume_utc|t....as_|
|00001250| 75 74 63 28 06 00 00 00 | 52 25 00 00 00 52 26 00 |utc(....|R%...R&.|
|00001260| 00 00 52 27 00 00 00 52 | 28 00 00 00 52 06 00 00 |..R'...R|(...R...|
|00001270| 00 74 05 00 00 00 46 61 | 6c 73 65 28 02 00 00 00 |.t....Fa|lse(....|
|00001280| 52 17 00 00 00 52 2d 00 | 00 00 28 00 00 00 00 28 |R....R-.|..(....(|
|00001290| 00 00 00 00 73 2f 00 00 | 00 73 69 74 65 2d 70 61 |....s/..|.site-pa|
|000012a0| 63 6b 61 67 65 73 5c 63 | 61 6c 69 62 72 65 5c 6c |ckages\c|alibre\l|
|000012b0| 69 62 72 61 72 79 5c 63 | 75 73 74 6f 6d 5f 63 6f |ibrary\c|ustom_co|
|000012c0| 6c 75 6d 6e 73 2e 70 79 | 74 0e 00 00 00 61 64 61 |lumns.py|t....ada|
|000012d0| 70 74 5f 64 61 74 65 74 | 69 6d 65 81 00 00 00 73 |pt_datet|ime....s|
|000012e0| 06 00 00 00 00 01 19 01 | 1c 01 63 02 00 00 00 02 |........|..c.....|
|000012f0| 00 00 00 05 00 00 00 53 | 80 00 00 73 33 00 00 00 |.......S|...s3...|
|00001300| 74 00 00 7c 00 00 74 01 | 00 74 02 00 74 03 00 66 |t..|..t.|.t..t..f|
|00001310| 03 00 83 02 00 6f 16 00 | 01 74 04 00 74 05 00 7c |.....o..|.t..t..||
|00001320| 00 00 83 01 00 83 01 00 | 7d 00 00 6e 01 00 01 7c |........|}..n...||
|00001330| 00 00 53 28 01 00 00 00 | 4e 28 06 00 00 00 52 25 |..S(....|N(....R%|
|00001340| 00 00 00 52 26 00 00 00 | 52 27 00 00 00 52 28 00 |...R&...|R'...R(.|
|00001350| 00 00 52 0e 00 00 00 52 | 0c 00 00 00 28 02 00 00 |..R....R|....(...|
|00001360| 00 52 17 00 00 00 52 2d | 00 00 00 28 00 00 00 00 |.R....R-|...(....|
|00001370| 28 00 00 00 00 73 2f 00 | 00 00 73 69 74 65 2d 70 |(....s/.|..site-p|
|00001380| 61 63 6b 61 67 65 73 5c | 63 61 6c 69 62 72 65 5c |ackages\|calibre\|
|00001390| 6c 69 62 72 61 72 79 5c | 63 75 73 74 6f 6d 5f 63 |library\|custom_c|
|000013a0| 6f 6c 75 6d 6e 73 2e 70 | 79 74 0a 00 00 00 61 64 |olumns.p|yt....ad|
|000013b0| 61 70 74 5f 62 6f 6f 6c | 86 00 00 00 73 06 00 00 |apt_bool|....s...|
|000013c0| 00 00 01 19 01 16 01 63 | 02 00 00 00 02 00 00 00 |.......c|........|
|000013d0| 02 00 00 00 53 80 00 00 | 73 1c 00 00 00 7c 00 00 |....S...|s....|..|
|000013e0| 64 00 00 6a 08 00 6f 05 | 00 01 7c 00 00 53 01 74 |d..j..o.|..|..S.t|
|000013f0| 01 00 7c 00 00 83 01 00 | 53 28 01 00 00 00 4e 28 |..|.....|S(....N(|
|00001400| 02 00 00 00 52 24 00 00 | 00 52 0d 00 00 00 28 02 |....R$..|.R....(.|
|00001410| 00 00 00 52 17 00 00 00 | 52 2d 00 00 00 28 00 00 |...R....|R-...(..|
|00001420| 00 00 28 00 00 00 00 73 | 2f 00 00 00 73 69 74 65 |..(....s|/...site|
|00001430| 2d 70 61 63 6b 61 67 65 | 73 5c 63 61 6c 69 62 72 |-package|s\calibr|
|00001440| 65 5c 6c 69 62 72 61 72 | 79 5c 63 75 73 74 6f 6d |e\librar|y\custom|
|00001450| 5f 63 6f 6c 75 6d 6e 73 | 2e 70 79 74 08 00 00 00 |_columns|.pyt....|
|00001460| 3c 6c 61 6d 62 64 61 3e | 8c 00 00 00 73 00 00 00 |<lambda>|....s...|
|00001470| 00 52 0d 00 00 00 63 02 | 00 00 00 02 00 00 00 02 |.R....c.|........|
|00001480| 00 00 00 53 80 00 00 73 | 1c 00 00 00 7c 00 00 64 |...S...s|....|..d|
|00001490| 00 00 6a 08 00 6f 05 00 | 01 7c 00 00 53 01 74 01 |..j..o..|.|..S.t.|
|000014a0| 00 7c 00 00 83 01 00 53 | 28 01 00 00 00 4e 28 02 |.|.....S|(....N(.|
|000014b0| 00 00 00 52 24 00 00 00 | 52 0c 00 00 00 28 02 00 |...R$...|R....(..|
|000014c0| 00 00 52 17 00 00 00 52 | 2d 00 00 00 28 00 00 00 |..R....R|-...(...|
|000014d0| 00 28 00 00 00 00 73 2f | 00 00 00 73 69 74 65 2d |.(....s/|...site-|
|000014e0| 70 61 63 6b 61 67 65 73 | 5c 63 61 6c 69 62 72 65 |packages|\calibre|
|000014f0| 5c 6c 69 62 72 61 72 79 | 5c 63 75 73 74 6f 6d 5f |\library|\custom_|
|00001500| 63 6f 6c 75 6d 6e 73 2e | 70 79 52 37 00 00 00 8d |columns.|pyR7....|
|00001510| 00 00 00 73 00 00 00 00 | 52 0c 00 00 00 63 02 00 |...s....|R....c..|
|00001520| 00 00 02 00 00 00 06 00 | 00 00 53 80 00 00 73 2e |........|..S...s.|
|00001530| 00 00 00 7c 00 00 64 02 | 00 6a 08 00 6f 05 00 01 |...|..d.|.j..o...|
|00001540| 7c 00 00 53 01 74 01 00 | 64 00 00 74 02 00 64 01 ||..S.t..|d..t..d.|
|00001550| 00 74 03 00 7c 00 00 83 | 01 00 83 02 00 83 02 00 |.t..|...|........|
|00001560| 53 28 03 00 00 00 67 00 | 00 00 00 00 00 24 40 67 |S(....g.|.....$@g|
|00001570| 00 00 00 00 00 00 00 00 | 4e 28 04 00 00 00 52 24 |........|N(....R$|
|00001580| 00 00 00 74 03 00 00 00 | 6d 69 6e 74 03 00 00 00 |...t....|mint....|
|00001590| 6d 61 78 52 0d 00 00 00 | 28 02 00 00 00 52 17 00 |maxR....|(....R..|
|000015a0| 00 00 52 2d 00 00 00 28 | 00 00 00 00 28 00 00 00 |..R-...(|....(...|
|000015b0| 00 73 2f 00 00 00 73 69 | 74 65 2d 70 61 63 6b 61 |.s/...si|te-packa|
|000015c0| 67 65 73 5c 63 61 6c 69 | 62 72 65 5c 6c 69 62 72 |ges\cali|bre\libr|
|000015d0| 61 72 79 5c 63 75 73 74 | 6f 6d 5f 63 6f 6c 75 6d |ary\cust|om_colum|
|000015e0| 6e 73 2e 70 79 52 37 00 | 00 00 8e 00 00 00 73 00 |ns.pyR7.|......s.|
|000015f0| 00 00 00 52 08 00 00 00 | 52 0e 00 00 00 63 02 00 |...R....|R....c..|
|00001600| 00 00 02 00 00 00 05 00 | 00 00 13 80 00 00 73 14 |........|......s.|
|00001610| 00 00 00 88 00 00 7c 00 | 00 68 01 00 74 00 00 64 |......|.|.h..t..d|
|00001620| 00 00 36 83 02 00 53 28 | 01 00 00 00 52 21 00 00 |..6...S(|....R!..|
|00001630| 00 28 01 00 00 00 52 34 | 00 00 00 28 02 00 00 00 |.(....R4|...(....|
|00001640| 52 17 00 00 00 52 2d 00 | 00 00 28 01 00 00 00 52 |R....R-.|..(....R|
|00001650| 31 00 00 00 28 00 00 00 | 00 73 2f 00 00 00 73 69 |1...(...|.s/...si|
|00001660| 74 65 2d 70 61 63 6b 61 | 67 65 73 5c 63 61 6c 69 |te-packa|ges\cali|
|00001670| 62 72 65 5c 6c 69 62 72 | 61 72 79 5c 63 75 73 74 |bre\libr|ary\cust|
|00001680| 6f 6d 5f 63 6f 6c 75 6d | 6e 73 2e 70 79 52 37 00 |om_colum|ns.pyR7.|
|00001690| 00 00 90 00 00 00 73 00 | 00 00 00 52 0a 00 00 00 |......s.|...R....|
|000016a0| 52 0b 00 00 00 52 09 00 | 00 00 52 0f 00 00 00 74 |R....R..|..R....t|
|000016b0| 01 00 00 00 7c 73 11 00 | 00 00 63 75 73 74 6f 6d |....|s..|..custom|
|000016c0| 5f 63 6f 6c 75 6d 6e 5f | 7b 30 7d 74 06 00 00 00 |_column_|{0}t....|
|000016d0| 63 6f 6c 75 6d 6e 74 05 | 00 00 00 76 61 6c 75 65 |columnt.|...value|
|000016e0| 74 06 00 00 00 63 6f 6c | 6e 75 6d 74 0b 00 00 00 |t....col|numt....|
|000016f0| 69 73 5f 63 61 74 65 67 | 6f 72 79 74 0b 00 00 00 |is_categ|oryt....|
|00001700| 69 73 5f 65 64 69 74 61 | 62 6c 65 28 1c 00 00 00 |is_edita|ble(....|
|00001710| 74 03 00 00 00 6c 65 6e | 74 11 00 00 00 43 55 53 |t....len|t....CUS|
|00001720| 54 4f 4d 5f 44 41 54 41 | 5f 54 59 50 45 53 52 05 |TOM_DATA|_TYPESR.|
|00001730| 00 00 00 74 10 00 00 00 | 56 41 4c 49 44 5f 44 41 |...t....|VALID_DA|
|00001740| 54 41 5f 54 59 50 45 53 | 74 0a 00 00 00 56 61 6c |TA_TYPES|t....Val|
|00001750| 75 65 45 72 72 6f 72 52 | 14 00 00 00 52 15 00 00 |ueErrorR|....R...|
|00001760| 00 52 12 00 00 00 74 0d | 00 00 00 65 78 65 63 75 |.R....t.|...execu|
|00001770| 74 65 73 63 72 69 70 74 | 74 06 00 00 00 66 6f 72 |tescript|t....for|
|00001780| 6d 61 74 74 07 00 00 00 | 65 78 65 63 75 74 65 74 |matt....|executet|
|00001790| 06 00 00 00 63 6f 6d 6d | 69 74 74 17 00 00 00 63 |....comm|itt....c|
|000017a0| 75 73 74 6f 6d 5f 63 6f | 6c 75 6d 6e 5f 6c 61 62 |ustom_co|lumn_lab|
|000017b0| 65 6c 5f 6d 61 70 74 15 | 00 00 00 63 75 73 74 6f |el_mapt.|...custo|
|000017c0| 6d 5f 63 6f 6c 75 6d 6e | 5f 6e 75 6d 5f 6d 61 70 |m_column|_num_map|
|000017d0| 52 18 00 00 00 74 04 00 | 00 00 6a 73 6f 6e 74 05 |R....t..|..jsont.|
|000017e0| 00 00 00 6c 6f 61 64 73 | 74 06 00 00 00 61 70 70 |...loads|t....app|
|000017f0| 65 6e 64 52 03 00 00 00 | 52 2c 00 00 00 74 14 00 |endR....|R,...t..|
|00001800| 00 00 63 75 73 74 6f 6d | 5f 64 61 74 61 5f 61 64 |..custom|_data_ad|
|00001810| 61 70 74 65 72 73 74 06 | 00 00 00 73 6f 72 74 65 |apterst.|...sorte|
|00001820| 64 74 04 00 00 00 6b 65 | 79 73 74 04 00 00 00 54 |dt....ke|yst....T|
|00001830| 72 75 65 52 34 00 00 00 | 52 24 00 00 00 74 0e 00 |rueR4...|R$...t..|
|00001840| 00 00 66 69 65 6c 64 5f | 6d 65 74 61 64 61 74 61 |..field_|metadata|
|00001850| 74 10 00 00 00 61 64 64 | 5f 63 75 73 74 6f 6d 5f |t....add|_custom_|
|00001860| 66 69 65 6c 64 28 11 00 | 00 00 52 10 00 00 00 74 |field(..|..R....t|
|00001870| 06 00 00 00 72 65 63 6f | 72 64 52 11 00 00 00 52 |....reco|rdR....R|
|00001880| 19 00 00 00 52 1a 00 00 | 00 74 08 00 00 00 74 72 |....R...|.t....tr|
|00001890| 69 67 67 65 72 73 74 06 | 00 00 00 72 65 6d 6f 76 |iggerst.|...remov|
|000018a0| 65 52 18 00 00 00 74 04 | 00 00 00 64 61 74 61 74 |eR....t.|...datat|
|000018b0| 07 00 00 00 74 72 69 67 | 67 65 72 52 35 00 00 00 |....trig|gerR5...|
|000018c0| 52 36 00 00 00 74 01 00 | 00 00 6b 74 01 00 00 00 |R6...t..|..kt....|
|000018d0| 76 52 3e 00 00 00 74 04 | 00 00 00 69 73 5f 6d 74 |vR>...t.|...is_mt|
|000018e0| 02 00 00 00 74 6e 28 00 | 00 00 00 28 01 00 00 00 |....tn(.|...(....|
|000018f0| 52 31 00 00 00 73 2f 00 | 00 00 73 69 74 65 2d 70 |R1...s/.|..site-p|
|00001900| 61 63 6b 61 67 65 73 5c | 63 61 6c 69 62 72 65 5c |ackages\|calibre\|
|00001910| 6c 69 62 72 61 72 79 5c | 63 75 73 74 6f 6d 5f 63 |library\|custom_c|
|00001920| 6f 6c 75 6d 6e 73 2e 70 | 79 74 08 00 00 00 5f 5f |olumns.p|yt....__|
|00001930| 69 6e 69 74 5f 5f 21 00 | 00 00 73 9a 00 00 00 00 |init__!.|..s.....|
|00001940| 03 1d 01 10 02 0c 01 07 | 00 06 01 0a 01 15 01 09 |........|........|
|00001950| 0e 1d 02 10 01 0d 03 13 | 01 06 01 06 01 09 01 0c |........|........|
|00001960| 01 07 00 06 01 03 01 0b | 01 0b 01 0b 01 0b 01 14 |........|........|
|00001970| 01 0b 01 0b 01 0e 02 19 | 01 1b 01 0a 01 0d 01 07 |........|........|
|00001980| 02 15 02 20 03 0b 01 0e | 02 0a 01 11 02 07 01 07 |... ....|........|
|00001990| 00 06 01 06 01 0c 01 0c | 01 12 01 11 02 07 01 09 |........|........|
|000019a0| 06 14 01 11 03 09 0e 09 | 05 09 05 03 01 0a 01 0a |........|........|
|000019b0| 01 0a 01 07 01 10 01 07 | 01 07 01 0d 04 16 00 06 |........|........|
|000019c0| 01 0d 01 0b 01 0a 02 06 | 01 0b 01 0a 02 06 01 13 |........|........|
|000019d0| 01 16 01 16 01 1e 01 0c | 01 63 05 00 00 00 08 00 |........|.c......|
|000019e0| 00 00 04 00 00 00 43 80 | 00 00 73 e5 00 00 00 7c |......C.|..s....||
|000019f0| 02 00 64 00 00 6a 09 00 | 6f 11 00 01 7c 00 00 69 |..d..j..|o...|..i|
|00001a00| 01 00 7c 02 00 19 7d 05 | 00 6e 01 00 01 7c 03 00 |..|...}.|.n...|..|
|00001a10| 64 00 00 6a 09 00 6f 11 | 00 01 7c 00 00 69 02 00 |d..j..o.|..|..i..|
|00001a20| 7c 03 00 19 7d 05 00 6e | 01 00 01 7c 04 00 6f 11 ||...}..n|...|..o.|
|00001a30| 00 01 7c 00 00 69 03 00 | 69 04 00 7c 01 00 19 6e |..|..i..|i..|...n|
|00001a40| 0b 00 01 7c 00 00 69 03 | 00 7c 01 00 19 7d 06 00 |...|..i.|.|...}..|
|00001a50| 7c 06 00 7c 00 00 69 05 | 00 7c 05 00 64 01 00 19 ||..|..i.|.|..d...|
|00001a60| 19 19 7d 07 00 7c 05 00 | 64 02 00 19 6f 60 00 01 |..}..|..|d...o`..|
|00001a70| 7c 05 00 64 03 00 19 64 | 04 00 6a 02 00 6f 4f 00 ||..d...d|..j..oO.|
|00001a80| 01 7c 07 00 6f 10 00 01 | 7c 07 00 69 06 00 64 05 |.|..o...||..i..d.|
|00001a90| 00 83 01 00 6e 04 00 01 | 67 00 00 7d 07 00 7c 05 |....n...|g..}..|.|
|00001aa0| 00 64 06 00 19 69 07 00 | 64 07 00 74 08 00 83 02 |.d...i..|d..t....|
|00001ab0| 00 6f 17 00 01 7c 07 00 | 69 09 00 64 08 00 64 09 |.o...|..|i..d..d.|
|00001ac0| 00 84 00 00 83 00 01 01 | 71 e1 00 01 6e 01 00 01 |........|q...n...|
|00001ad0| 7c 07 00 53 28 0a 00 00 | 00 4e 52 11 00 00 00 52 ||..S(...|.NR....R|
|00001ae0| 21 00 00 00 52 1d 00 00 | 00 52 09 00 00 00 52 3a |!...R...|.R....R:|
|00001af0| 00 00 00 52 1f 00 00 00 | 74 0a 00 00 00 73 6f 72 |...R....|t....sor|
|00001b00| 74 5f 61 6c 70 68 61 74 | 03 00 00 00 63 6d 70 63 |t_alphat|....cmpc|
|00001b10| 02 00 00 00 02 00 00 00 | 03 00 00 00 53 80 00 00 |........|....S...|
|00001b20| 73 19 00 00 00 74 00 00 | 7c 00 00 69 01 00 83 00 |s....t..||..i....|
|00001b30| 00 7c 01 00 69 01 00 83 | 00 00 83 02 00 53 28 00 |.|..i...|.....S(.|
|00001b40| 00 00 00 28 02 00 00 00 | 52 5e 00 00 00 74 05 00 |...(....|R^...t..|
|00001b50| 00 00 6c 6f 77 65 72 28 | 02 00 00 00 52 17 00 00 |..lower(|....R...|
|00001b60| 00 52 2e 00 00 00 28 00 | 00 00 00 28 00 00 00 00 |.R....(.|...(....|
|00001b70| 73 2f 00 00 00 73 69 74 | 65 2d 70 61 63 6b 61 67 |s/...sit|e-packag|
|00001b80| 65 73 5c 63 61 6c 69 62 | 72 65 5c 6c 69 62 72 61 |es\calib|re\libra|
|00001b90| 72 79 5c 63 75 73 74 6f | 6d 5f 63 6f 6c 75 6d 6e |ry\custo|m_column|
|00001ba0| 73 2e 70 79 52 37 00 00 | 00 b2 00 00 00 73 00 00 |s.pyR7..|.....s..|
|00001bb0| 00 00 28 0a 00 00 00 52 | 24 00 00 00 52 48 00 00 |..(....R|$...RH..|
|00001bc0| 00 52 49 00 00 00 52 56 | 00 00 00 74 05 00 00 00 |.RI...RV|...t....|
|00001bd0| 5f 64 61 74 61 74 09 00 | 00 00 46 49 45 4c 44 5f |_datat..|..FIELD_|
|00001be0| 4d 41 50 52 29 00 00 00 | 52 15 00 00 00 52 34 00 |MAPR)...|R....R4.|
|00001bf0| 00 00 74 04 00 00 00 73 | 6f 72 74 28 08 00 00 00 |..t....s|ort(....|
|00001c00| 52 10 00 00 00 74 03 00 | 00 00 69 64 78 52 1b 00 |R....t..|..idxR..|
|00001c10| 00 00 52 11 00 00 00 74 | 0b 00 00 00 69 6e 64 65 |..R....t|....inde|
|00001c20| 78 5f 69 73 5f 69 64 52 | 56 00 00 00 74 03 00 00 |x_is_idR|V...t...|
|00001c30| 00 72 6f 77 74 03 00 00 | 00 61 6e 73 28 00 00 00 |.rowt...|.ans(...|
|00001c40| 00 28 00 00 00 00 73 2f | 00 00 00 73 69 74 65 2d |.(....s/|...site-|
|00001c50| 70 61 63 6b 61 67 65 73 | 5c 63 61 6c 69 62 72 65 |packages|\calibre|
|00001c60| 5c 6c 69 62 72 61 72 79 | 5c 63 75 73 74 6f 6d 5f |\library|\custom_|
|00001c70| 63 6f 6c 75 6d 6e 73 2e | 70 79 74 0a 00 00 00 67 |columns.|pyt....g|
|00001c80| 65 74 5f 63 75 73 74 6f | 6d a8 00 00 00 73 16 00 |et_custo|m....s..|
|00001c90| 00 00 00 01 0d 01 11 01 | 0d 01 11 01 25 01 15 01 |........|....%...|
|00001ca0| 1c 01 1d 01 17 01 1b 01 | 63 05 00 00 00 08 00 00 |........|c.......|
|00001cb0| 00 05 00 00 00 43 80 00 | 00 73 a8 00 00 00 7c 02 |.....C..|.s....|.|
|00001cc0| 00 64 00 00 6a 09 00 6f | 11 00 01 7c 00 00 69 01 |.d..j..o|...|..i.|
|00001cd0| 00 7c 02 00 19 7d 05 00 | 6e 01 00 01 7c 03 00 64 |.|...}..|n...|..d|
|00001ce0| 00 00 6a 09 00 6f 11 00 | 01 7c 00 00 69 02 00 7c |..j..o..|.|..i..||
|00001cf0| 03 00 19 7d 05 00 6e 01 | 00 01 7c 05 00 64 01 00 |...}..n.|..|..d..|
|00001d00| 19 64 06 00 6a 07 00 6f | 05 00 01 64 00 00 53 01 |.d..j..o|...d..S.|
|00001d10| 7c 00 00 69 03 00 7c 05 | 00 64 03 00 19 83 01 00 ||..i..|.|.d......|
|00001d20| 5c 02 00 7d 06 00 7d 07 | 00 7c 04 00 6f 07 00 01 |\..}..}.|.|..o...|
|00001d30| 7c 01 00 6e 0d 00 01 7c | 00 00 69 04 00 7c 01 00 ||..n...||..i..|..|
|00001d40| 83 01 00 7d 01 00 7c 00 | 00 69 05 00 69 06 00 64 |...}..|.|.i..i..d|
|00001d50| 04 00 7c 07 00 16 7c 01 | 00 66 01 00 64 05 00 74 |..|...|.|.f..d..t|
|00001d60| 07 00 83 02 01 53 28 07 | 00 00 00 4e 52 1d 00 00 |.....S(.|...NR...|
|00001d70| 00 52 0f 00 00 00 52 11 | 00 00 00 73 41 00 00 00 |.R....R.|...sA...|
|00001d80| 53 45 4c 45 43 54 20 65 | 78 74 72 61 20 46 52 4f |SELECT e|xtra FRO|
|00001d90| 4d 20 25 73 0a 20 20 20 | 20 20 20 20 20 20 20 20 |M %s. | |
|00001da0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00001db0| 20 20 20 20 20 57 48 45 | 52 45 20 62 6f 6f 6b 3d | WHE|RE book=|
|00001dc0| 3f 74 03 00 00 00 61 6c | 6c 28 01 00 00 00 73 06 |?t....al|l(....s.|
|00001dd0| 00 00 00 73 65 72 69 65 | 73 28 08 00 00 00 52 24 |...serie|s(....R$|
|00001de0| 00 00 00 52 48 00 00 00 | 52 49 00 00 00 52 12 00 |...RH...|RI...R..|
|00001df0| 00 00 74 02 00 00 00 69 | 64 52 14 00 00 00 52 15 |..t....i|dR....R.|
|00001e00| 00 00 00 52 34 00 00 00 | 28 08 00 00 00 52 10 00 |...R4...|(....R..|
|00001e10| 00 00 52 63 00 00 00 52 | 1b 00 00 00 52 11 00 00 |..Rc...R|....R...|
|00001e20| 00 52 64 00 00 00 52 56 | 00 00 00 74 03 00 00 00 |.Rd...RV|...t....|
|00001e30| 69 67 6e 52 1a 00 00 00 | 28 00 00 00 00 28 00 00 |ignR....|(....(..|
|00001e40| 00 00 73 2f 00 00 00 73 | 69 74 65 2d 70 61 63 6b |..s/...s|ite-pack|
|00001e50| 61 67 65 73 5c 63 61 6c | 69 62 72 65 5c 6c 69 62 |ages\cal|ibre\lib|
|00001e60| 72 61 72 79 5c 63 75 73 | 74 6f 6d 5f 63 6f 6c 75 |rary\cus|tom_colu|
|00001e70| 6d 6e 73 2e 70 79 74 10 | 00 00 00 67 65 74 5f 63 |mns.pyt.|...get_c|
|00001e80| 75 73 74 6f 6d 5f 65 78 | 74 72 61 b5 00 00 00 73 |ustom_ex|tra....s|
|00001e90| 14 00 00 00 00 01 0d 01 | 11 01 0d 01 11 02 11 01 |........|........|
|00001ea0| 05 01 19 01 1d 01 09 01 | 63 03 00 00 00 07 00 00 |........|c.......|
|00001eb0| 00 03 00 00 00 43 80 00 | 00 73 7f 00 00 00 7c 01 |.....C..|.s....|.|
|00001ec0| 00 64 00 00 6a 09 00 6f | 11 00 01 7c 00 00 69 01 |.d..j..o|...|..i.|
|00001ed0| 00 7c 01 00 19 7d 03 00 | 6e 01 00 01 7c 02 00 64 |.|...}..|n...|..d|
|00001ee0| 00 00 6a 09 00 6f 11 00 | 01 7c 00 00 69 02 00 7c |..j..o..|.|..i..||
|00001ef0| 02 00 19 7d 03 00 6e 01 | 00 01 7c 00 00 69 03 00 |...}..n.|..|..i..|
|00001f00| 7c 03 00 64 01 00 19 83 | 01 00 5c 02 00 7d 04 00 ||..d....|..\..}..|
|00001f10| 7d 05 00 7c 03 00 64 02 | 00 19 70 05 00 01 67 00 |}..|..d.|..p...g.|
|00001f20| 00 53 01 7c 00 00 69 04 | 00 69 05 00 64 03 00 7c |.S.|..i.|.i..d..||
|00001f30| 04 00 16 83 01 00 7d 06 | 00 7c 06 00 53 28 04 00 |......}.|.|..S(..|
|00001f40| 00 00 4e 52 11 00 00 00 | 52 20 00 00 00 73 18 00 |..NR....|R ...s..|
|00001f50| 00 00 53 45 4c 45 43 54 | 20 69 64 2c 20 76 61 6c |..SELECT| id, val|
|00001f60| 75 65 20 46 52 4f 4d 20 | 25 73 28 06 00 00 00 52 |ue FROM |%s(....R|
|00001f70| 24 00 00 00 52 48 00 00 | 00 52 49 00 00 00 52 12 |$...RH..|.RI...R.|
|00001f80| 00 00 00 52 14 00 00 00 | 52 15 00 00 00 28 07 00 |...R....|R....(..|
|00001f90| 00 00 52 10 00 00 00 52 | 1b 00 00 00 52 11 00 00 |..R....R|....R...|
|00001fa0| 00 52 56 00 00 00 52 19 | 00 00 00 52 1a 00 00 00 |.RV...R.|...R....|
|00001fb0| 52 66 00 00 00 28 00 00 | 00 00 28 00 00 00 00 73 |Rf...(..|..(....s|
|00001fc0| 2f 00 00 00 73 69 74 65 | 2d 70 61 63 6b 61 67 65 |/...site|-package|
|00001fd0| 73 5c 63 61 6c 69 62 72 | 65 5c 6c 69 62 72 61 72 |s\calibr|e\librar|
|00001fe0| 79 5c 63 75 73 74 6f 6d | 5f 63 6f 6c 75 6d 6e 73 |y\custom|_columns|
|00001ff0| 2e 70 79 74 19 00 00 00 | 67 65 74 5f 63 75 73 74 |.pyt....|get_cust|
|00002000| 6f 6d 5f 69 74 65 6d 73 | 5f 77 69 74 68 5f 69 64 |om_items|_with_id|
|00002010| 73 c3 00 00 00 73 12 00 | 00 00 00 01 0d 01 11 01 |s....s..|........|
|00002020| 0d 01 11 01 19 01 0b 01 | 05 01 16 01 63 05 00 00 |........|....c...|
|00002030| 00 0b 00 00 00 06 00 00 | 00 43 80 00 00 73 56 01 |........|.C...sV.|
|00002040| 00 00 7c 03 00 64 00 00 | 6a 09 00 6f 11 00 01 7c |..|..d..|j..o...||
|00002050| 00 00 69 01 00 7c 03 00 | 19 7d 05 00 6e 01 00 01 |..i..|..|.}..n...|
|00002060| 7c 04 00 64 00 00 6a 09 | 00 6f 11 00 01 7c 00 00 ||..d..j.|.o...|..|
|00002070| 69 02 00 7c 04 00 19 7d | 05 00 6e 01 00 01 7c 00 |i..|...}|..n...|.|
|00002080| 00 69 03 00 7c 05 00 64 | 01 00 19 83 01 00 5c 02 |.i..|..d|......\.|
|00002090| 00 7d 06 00 7d 07 00 7c | 00 00 69 04 00 69 05 00 |.}..}..||..i..i..|
|000020a0| 64 02 00 7c 06 00 16 7c | 02 00 66 01 00 64 03 00 |d..|...||..f..d..|
|000020b0| 74 06 00 83 02 01 7d 08 | 00 7c 08 00 64 00 00 6a |t.....}.|.|..d..j|
|000020c0| 08 00 70 0d 00 01 7c 01 | 00 7c 08 00 6a 02 00 6f |..p...|.|.|..j..o|
|000020d0| 21 00 01 7c 00 00 69 04 | 00 69 07 00 64 04 00 7c |!..|..i.|.i..d..||
|000020e0| 06 00 16 7c 02 00 7c 01 | 00 66 02 00 83 02 00 01 |...|..|.|.f......|
|000020f0| 6e 94 00 01 7c 05 00 64 | 05 00 19 6f 51 00 01 7c |n...|..d|...oQ..||
|00002100| 00 00 69 04 00 69 05 00 | 64 06 00 7c 07 00 16 7c |..i..i..|d..|...||
|00002110| 01 00 66 01 00 83 02 00 | 7d 09 00 78 32 00 7c 09 |..f.....|}..x2.|.|
|00002120| 00 44 5d 26 00 5c 01 00 | 7d 0a 00 7c 00 00 69 04 |.D]&.\..|}..|..i.|
|00002130| 00 69 07 00 64 07 00 7c | 07 00 16 7c 0a 00 7c 08 |.i..d..||...|..|.|
|00002140| 00 66 02 00 83 02 00 01 | 71 e0 00 57 6e 01 00 01 |.f......|q..Wn...|
|00002150| 7c 00 00 69 04 00 69 07 | 00 64 08 00 7c 07 00 16 ||..i..i.|.d..|...|
|00002160| 7c 08 00 7c 01 00 66 02 | 00 83 02 00 01 7c 00 00 ||..|..f.|.....|..|
|00002170| 69 04 00 69 07 00 64 09 | 00 7c 06 00 16 7c 01 00 |i..i..d.|.|...|..|
|00002180| 66 01 00 83 02 00 01 7c | 00 00 69 04 00 69 08 00 |f......||..i..i..|
|00002190| 83 00 00 01 64 00 00 53 | 28 0a 00 00 00 4e 52 11 |....d..S|(....NR.|
|000021a0| 00 00 00 73 1f 00 00 00 | 53 45 4c 45 43 54 20 69 |...s....|SELECT i|
|000021b0| 64 20 46 52 4f 4d 20 25 | 73 20 57 48 45 52 45 20 |d FROM %|s WHERE |
|000021c0| 76 61 6c 75 65 3d 3f 52 | 68 00 00 00 73 20 00 00 |value=?R|h...s ..|
|000021d0| 00 55 50 44 41 54 45 20 | 25 73 20 53 45 54 20 76 |.UPDATE |%s SET v|
|000021e0| 61 6c 75 65 3d 3f 20 57 | 48 45 52 45 20 69 64 3d |alue=? W|HERE id=|
|000021f0| 3f 52 21 00 00 00 73 4a | 00 00 00 53 45 4c 45 43 |?R!...sJ|...SELEC|
|00002200| 54 20 62 6f 6f 6b 20 66 | 72 6f 6d 20 25 73 0a 20 |T book f|rom %s. |
|00002210| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00002220| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00002230| 20 20 20 20 20 20 20 20 | 57 48 45 52 45 20 76 61 | |WHERE va|
|00002240| 6c 75 65 3d 3f 73 43 00 | 00 00 44 45 4c 45 54 45 |lue=?sC.|..DELETE|
|00002250| 20 46 52 4f 4d 20 25 73 | 0a 20 20 20 20 20 20 20 | FROM %s|. |
|00002260| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00002270| 20 20 20 20 20 57 48 45 | 52 45 20 62 6f 6f 6b 3d | WHE|RE book=|
|00002280| 3f 20 61 6e 64 20 76 61 | 6c 75 65 3d 3f 73 44 00 |? and va|lue=?sD.|
|00002290| 00 00 55 50 44 41 54 45 | 20 25 73 20 53 45 54 20 |..UPDATE| %s SET |
|000022a0| 76 61 6c 75 65 3d 3f 0a | 20 20 20 20 20 20 20 20 |value=?.| |
|000022b0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|000022c0| 20 20 20 20 20 20 20 20 | 20 57 48 45 52 45 20 76 | | WHERE v|
|000022d0| 61 6c 75 65 3d 3f 73 19 | 00 00 00 44 45 4c 45 54 |alue=?s.|...DELET|
|000022e0| 45 20 46 52 4f 4d 20 25 | 73 20 57 48 45 52 45 20 |E FROM %|s WHERE |
|000022f0| 69 64 3d 3f 28 09 00 00 | 00 52 24 00 00 00 52 48 |id=?(...|.R$...RH|
|00002300| 00 00 00 52 49 00 00 00 | 52 12 00 00 00 52 14 00 |...RI...|R....R..|
|00002310| 00 00 52 15 00 00 00 52 | 34 00 00 00 52 46 00 00 |..R....R|4...RF..|
|00002320| 00 52 47 00 00 00 28 0b | 00 00 00 52 10 00 00 00 |.RG...(.|...R....|
|00002330| 74 06 00 00 00 6f 6c 64 | 5f 69 64 74 08 00 00 00 |t....old|_idt....|
|00002340| 6e 65 77 5f 6e 61 6d 65 | 52 1b 00 00 00 52 11 00 |new_name|R....R..|
|00002350| 00 00 52 56 00 00 00 52 | 19 00 00 00 52 1a 00 00 |..RV...R|....R...|
|00002360| 00 74 06 00 00 00 6e 65 | 77 5f 69 64 74 05 00 00 |.t....ne|w_idt...|
|00002370| 00 62 6f 6f 6b 73 74 07 | 00 00 00 62 6f 6f 6b 5f |.bookst.|...book_|
|00002380| 69 64 28 00 00 00 00 28 | 00 00 00 00 73 2f 00 00 |id(....(|....s/..|
|00002390| 00 73 69 74 65 2d 70 61 | 63 6b 61 67 65 73 5c 63 |.site-pa|ckages\c|
|000023a0| 61 6c 69 62 72 65 5c 6c | 69 62 72 61 72 79 5c 63 |alibre\l|ibrary\c|
|000023b0| 75 73 74 6f 6d 5f 63 6f | 6c 75 6d 6e 73 2e 70 79 |ustom_co|lumns.py|
|000023c0| 74 12 00 00 00 72 65 6e | 61 6d 65 5f 63 75 73 74 |t....ren|ame_cust|
|000023d0| 6f 6d 5f 69 74 65 6d ce | 00 00 00 73 28 00 00 00 |om_item.|...s(...|
|000023e0| 00 01 0d 01 11 01 0d 01 | 11 01 19 02 09 01 19 01 |........|........|
|000023f0| 1a 01 21 04 0b 01 09 01 | 13 01 07 00 09 01 09 01 |..!.....|........|
|00002400| 1c 01 09 01 14 01 1a 01 | 63 04 00 00 00 07 00 00 |........|c.......|
|00002410| 00 03 00 00 00 43 80 00 | 00 73 a5 00 00 00 7c 01 |.....C..|.s....|.|
|00002420| 00 6f 9a 00 01 7c 02 00 | 64 00 00 6a 09 00 6f 11 |.o...|..|d..j..o.|
|00002430| 00 01 7c 00 00 69 01 00 | 7c 02 00 19 7d 04 00 6e |..|..i..||...}..n|
|00002440| 01 00 01 7c 03 00 64 00 | 00 6a 09 00 6f 11 00 01 |...|..d.|.j..o...|
|00002450| 7c 00 00 69 02 00 7c 03 | 00 19 7d 04 00 6e 01 00 ||..i..|.|..}..n..|
|00002460| 01 7c 00 00 69 03 00 7c | 04 00 64 01 00 19 83 01 |.|..i..||..d.....|
|00002470| 00 5c 02 00 7d 05 00 7d | 06 00 7c 00 00 69 04 00 |.\..}..}|..|..i..|
|00002480| 69 05 00 64 02 00 7c 06 | 00 16 7c 01 00 66 01 00 |i..d..|.|..|..f..|
|00002490| 83 02 00 01 7c 00 00 69 | 04 00 69 05 00 64 03 00 |....|..i|..i..d..|
|000024a0| 7c 05 00 16 7c 01 00 66 | 01 00 83 02 00 01 7c 00 ||...|..f|......|.|
|000024b0| 00 69 04 00 69 06 00 83 | 00 00 01 6e 01 00 01 64 |.i..i...|...n...d|
|000024c0| 00 00 53 28 04 00 00 00 | 4e 52 11 00 00 00 73 1c |..S(....|NR....s.|
|000024d0| 00 00 00 44 45 4c 45 54 | 45 20 46 52 4f 4d 20 25 |...DELET|E FROM %|
|000024e0| 73 20 57 48 45 52 45 20 | 76 61 6c 75 65 3d 3f 73 |s WHERE |value=?s|
|000024f0| 19 00 00 00 44 45 4c 45 | 54 45 20 46 52 4f 4d 20 |....DELE|TE FROM |
|00002500| 25 73 20 57 48 45 52 45 | 20 69 64 3d 3f 28 07 00 |%s WHERE| id=?(..|
|00002510| 00 00 52 24 00 00 00 52 | 48 00 00 00 52 49 00 00 |..R$...R|H...RI..|
|00002520| 00 52 12 00 00 00 52 14 | 00 00 00 52 46 00 00 00 |.R....R.|...RF...|
|00002530| 52 47 00 00 00 28 07 00 | 00 00 52 10 00 00 00 52 |RG...(..|..R....R|
|00002540| 69 00 00 00 52 1b 00 00 | 00 52 11 00 00 00 52 56 |i...R...|.R....RV|
|00002550| 00 00 00 52 19 00 00 00 | 52 1a 00 00 00 28 00 00 |...R....|R....(..|
|00002560| 00 00 28 00 00 00 00 73 | 2f 00 00 00 73 69 74 65 |..(....s|/...site|
|00002570| 2d 70 61 63 6b 61 67 65 | 73 5c 63 61 6c 69 62 72 |-package|s\calibr|
|00002580| 65 5c 6c 69 62 72 61 72 | 79 5c 63 75 73 74 6f 6d |e\librar|y\custom|
|00002590| 5f 63 6f 6c 75 6d 6e 73 | 2e 70 79 74 1b 00 00 00 |_columns|.pyt....|
|000025a0| 64 65 6c 65 74 65 5f 63 | 75 73 74 6f 6d 5f 69 74 |delete_c|ustom_it|
|000025b0| 65 6d 5f 75 73 69 6e 67 | 5f 69 64 e7 00 00 00 73 |em_using|_id....s|
|000025c0| 12 00 00 00 00 01 07 01 | 0d 01 11 01 0d 01 11 01 |........|........|
|000025d0| 19 01 1a 01 1a 01 63 04 | 00 00 00 09 00 00 00 05 |......c.|........|
|000025e0| 00 00 00 43 80 00 00 73 | e9 00 00 00 7c 02 00 64 |...C...s|....|..d|
|000025f0| 00 00 6a 09 00 6f 11 00 | 01 7c 00 00 69 01 00 7c |..j..o..|.|..i..||
|00002600| 02 00 19 7d 04 00 6e 01 | 00 01 7c 03 00 64 00 00 |...}..n.|..|..d..|
|00002610| 6a 09 00 6f 11 00 01 7c | 00 00 69 02 00 7c 03 00 |j..o...||..i..|..|
|00002620| 19 7d 04 00 6e 01 00 01 | 7c 04 00 64 01 00 19 64 |.}..n...||..d...d|
|00002630| 02 00 6a 03 00 6f 05 00 | 01 64 00 00 53 01 7c 00 |..j..o..|.d..S.|.|
|00002640| 00 69 03 00 7c 04 00 64 | 03 00 19 83 01 00 5c 02 |.i..|..d|......\.|
|00002650| 00 7d 05 00 7d 06 00 7c | 00 00 69 04 00 69 05 00 |.}..}..||..i..i..|
|00002660| 64 04 00 7c 05 00 16 7c | 01 00 66 01 00 64 05 00 |d..|...||..f..d..|
|00002670| 74 06 00 83 02 01 7d 07 | 00 7c 07 00 64 00 00 6a |t.....}.|.|..d..j|
|00002680| 08 00 6f 05 00 01 64 06 | 00 53 01 7c 00 00 69 04 |..o...d.|.S.|..i.|
|00002690| 00 69 05 00 64 07 00 69 | 07 00 64 08 00 7c 06 00 |.i..d..i|..d..|..|
|000026a0| 83 00 01 7c 07 00 66 01 | 00 64 05 00 74 06 00 83 |...|..f.|.d..t...|
|000026b0| 02 01 7d 08 00 7c 08 00 | 64 00 00 6a 08 00 6f 05 |..}..|..|d..j..o.|
|000026c0| 00 01 64 06 00 53 01 74 | 08 00 7c 08 00 64 09 00 |..d..S.t|..|..d..|
|000026d0| 17 83 01 00 53 28 0a 00 | 00 00 4e 52 1d 00 00 00 |....S(..|..NR....|
|000026e0| 52 0f 00 00 00 52 11 00 | 00 00 73 1f 00 00 00 53 |R....R..|..s....S|
|000026f0| 45 4c 45 43 54 20 69 64 | 20 66 72 6f 6d 20 25 73 |ELECT id| from %s|
|00002700| 20 57 48 45 52 45 20 76 | 61 6c 75 65 3d 3f 52 68 | WHERE v|alue=?Rh|
|00002710| 00 00 00 67 00 00 00 00 | 00 00 f0 3f 73 8b 00 00 |...g....|...?s...|
|00002720| 00 0a 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |.. | |
|00002730| 20 20 53 45 4c 45 43 54 | 20 4d 41 58 28 7b 6c 74 | SELECT| MAX({lt|
|00002740| 7d 2e 65 78 74 72 61 29 | 20 46 52 4f 4d 20 7b 6c |}.extra)| FROM {l|
|00002750| 74 7d 0a 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |t}. | |
|00002760| 20 20 20 57 48 45 52 45 | 20 7b 6c 74 7d 2e 62 6f | WHERE| {lt}.bo|
|00002770| 6f 6b 20 49 4e 20 28 53 | 45 4c 45 43 54 20 62 6f |ok IN (S|ELECT bo|
|00002780| 6f 6b 20 46 52 4f 4d 20 | 7b 6c 74 7d 20 77 68 65 |ok FROM |{lt} whe|
|00002790| 72 65 20 76 61 6c 75 65 | 3d 3f 29 0a 20 20 20 20 |re value|=?). |
|000027a0| 20 20 20 20 20 20 20 20 | 20 20 20 20 52 1a 00 00 | | R...|
|000027b0| 00 69 01 00 00 00 28 09 | 00 00 00 52 24 00 00 00 |.i....(.|...R$...|
|000027c0| 52 48 00 00 00 52 49 00 | 00 00 52 12 00 00 00 52 |RH...RI.|..R....R|
|000027d0| 14 00 00 00 52 15 00 00 | 00 52 34 00 00 00 52 45 |....R...|.R4...RE|
|000027e0| 00 00 00 52 02 00 00 00 | 28 09 00 00 00 52 10 00 |...R....|(....R..|
|000027f0| 00 00 52 0f 00 00 00 52 | 1b 00 00 00 52 11 00 00 |..R....R|....R...|
|00002800| 00 52 56 00 00 00 52 19 | 00 00 00 52 1a 00 00 00 |.RV...R.|...R....|
|00002810| 74 09 00 00 00 73 65 72 | 69 65 73 5f 69 64 74 0a |t....ser|ies_idt.|
|00002820| 00 00 00 73 65 72 69 65 | 73 5f 6e 75 6d 28 00 00 |...serie|s_num(..|
|00002830| 00 00 28 00 00 00 00 73 | 2f 00 00 00 73 69 74 65 |..(....s|/...site|
|00002840| 2d 70 61 63 6b 61 67 65 | 73 5c 63 61 6c 69 62 72 |-package|s\calibr|
|00002850| 65 5c 6c 69 62 72 61 72 | 79 5c 63 75 73 74 6f 6d |e\librar|y\custom|
|00002860| 5f 63 6f 6c 75 6d 6e 73 | 2e 70 79 74 1a 00 00 00 |_columns|.pyt....|
|00002870| 67 65 74 5f 6e 65 78 74 | 5f 63 63 5f 73 65 72 69 |get_next|_cc_seri|
|00002880| 65 73 5f 6e 75 6d 5f 66 | 6f 72 f3 00 00 00 73 20 |es_num_f|or....s |
|00002890| 00 00 00 00 01 0d 01 11 | 01 0d 01 11 01 11 01 05 |........|........|
|000028a0| 01 19 02 10 01 12 01 0d | 01 05 02 09 03 21 01 0d |........|.....!..|
|000028b0| 01 05 01 63 03 00 00 00 | 09 00 00 00 06 00 00 00 |...c....|........|
|000028c0| 43 80 00 00 73 bf 00 00 | 00 7c 01 00 64 00 00 6a |C...s...|.|..d..j|
|000028d0| 09 00 6f 11 00 01 7c 00 | 00 69 01 00 7c 01 00 19 |..o...|.|.i..|...|
|000028e0| 7d 03 00 6e 01 00 01 7c | 02 00 64 00 00 6a 09 00 |}..n...||..d..j..|
|000028f0| 6f 11 00 01 7c 00 00 69 | 02 00 7c 02 00 19 7d 03 |o...|..i|..|...}.|
|00002900| 00 6e 01 00 01 7c 00 00 | 69 03 00 7c 03 00 64 01 |.n...|..|i..|..d.|
|00002910| 00 19 83 01 00 5c 02 00 | 7d 04 00 7d 05 00 7c 03 |.....\..|}..}..|.|
|00002920| 00 64 02 00 19 6f 1a 00 | 01 7c 00 00 69 04 00 69 |.d...o..|.|..i..i|
|00002930| 05 00 64 03 00 7c 04 00 | 16 83 01 00 7d 06 00 6e |..d..|..|....}..n|
|00002940| 17 00 01 7c 00 00 69 04 | 00 69 05 00 64 04 00 7c |...|..i.|.i..d..||
|00002950| 04 00 16 83 01 00 7d 06 | 00 74 06 00 67 00 00 04 |......}.|.t..g...|
|00002960| 7d 07 00 7c 06 00 44 5d | 11 00 7d 08 00 7c 07 00 |}..|..D]|..}..|..|
|00002970| 7c 08 00 64 05 00 19 12 | 71 9e 00 7e 07 00 83 01 ||..d....|q..~....|
|00002980| 00 7d 06 00 7c 06 00 53 | 28 06 00 00 00 4e 52 11 |.}..|..S|(....NR.|
|00002990| 00 00 00 52 20 00 00 00 | 73 14 00 00 00 53 45 4c |...R ...|s....SEL|
|000029a0| 45 43 54 20 76 61 6c 75 | 65 20 46 52 4f 4d 20 25 |ECT valu|e FROM %|
|000029b0| 73 73 1d 00 00 00 53 45 | 4c 45 43 54 20 44 49 53 |ss....SE|LECT DIS|
|000029c0| 54 49 4e 43 54 20 76 61 | 6c 75 65 20 46 52 4f 4d |TINCT va|lue FROM|
|000029d0| 20 25 73 69 00 00 00 00 | 28 07 00 00 00 52 24 00 | %si....|(....R$.|
|000029e0| 00 00 52 48 00 00 00 52 | 49 00 00 00 52 12 00 00 |..RH...R|I...R...|
|000029f0| 00 52 14 00 00 00 52 15 | 00 00 00 52 13 00 00 00 |.R....R.|...R....|
|00002a00| 28 09 00 00 00 52 10 00 | 00 00 52 1b 00 00 00 52 |(....R..|..R....R|
|00002a10| 11 00 00 00 52 56 00 00 | 00 52 19 00 00 00 52 1a |....RV..|.R....R.|
|00002a20| 00 00 00 52 66 00 00 00 | 52 16 00 00 00 52 17 00 |...Rf...|R....R..|
|00002a30| 00 00 28 00 00 00 00 28 | 00 00 00 00 73 2f 00 00 |..(....(|....s/..|
|00002a40| 00 73 69 74 65 2d 70 61 | 63 6b 61 67 65 73 5c 63 |.site-pa|ckages\c|
|00002a50| 61 6c 69 62 72 65 5c 6c | 69 62 72 61 72 79 5c 63 |alibre\l|ibrary\c|
|00002a60| 75 73 74 6f 6d 5f 63 6f | 6c 75 6d 6e 73 2e 70 79 |ustom_co|lumns.py|
|00002a70| 74 0a 00 00 00 61 6c 6c | 5f 63 75 73 74 6f 6d 09 |t....all|_custom.|
|00002a80| 01 00 00 73 14 00 00 00 | 00 01 0d 01 11 01 0d 01 |...s....|........|
|00002a90| 11 01 19 01 0b 01 1a 02 | 16 01 2b 01 63 03 00 00 |........|..+.c...|
|00002aa0| 00 04 00 00 00 04 00 00 | 00 43 80 00 00 73 8a 00 |........|.C...s..|
|00002ab0| 00 00 64 00 00 7d 03 00 | 7c 01 00 64 00 00 6a 09 |..d..}..||..d..j.|
|00002ac0| 00 6f 11 00 01 7c 00 00 | 69 01 00 7c 01 00 19 7d |.o...|..|i..|...}|
|00002ad0| 03 00 6e 01 00 01 7c 02 | 00 64 00 00 6a 09 00 6f |..n...|.|.d..j..o|
|00002ae0| 11 00 01 7c 00 00 69 02 | 00 7c 02 00 19 7d 03 00 |...|..i.|.|...}..|
|00002af0| 6e 01 00 01 7c 03 00 64 | 00 00 6a 08 00 6f 10 00 |n...|..d|..j..o..|
|00002b00| 01 74 03 00 64 01 00 83 | 01 00 82 01 00 6e 01 00 |.t..d...|.....n..|
|00002b10| 01 7c 00 00 69 04 00 69 | 05 00 64 02 00 7c 03 00 |.|..i..i|..d..|..|
|00002b20| 64 03 00 19 66 01 00 83 | 02 00 01 7c 00 00 69 04 |d...f...|...|..i.|
|00002b30| 00 69 06 00 83 00 00 01 | 64 00 00 53 28 04 00 00 |.i......|d..S(...|
|00002b40| 00 4e 73 0e 00 00 00 4e | 6f 20 73 75 63 68 20 63 |.Ns....N|o such c|
|00002b50| 6f 6c 75 6d 6e 73 36 00 | 00 00 55 50 44 41 54 45 |olumns6.|..UPDATE|
|00002b60| 20 63 75 73 74 6f 6d 5f | 63 6f 6c 75 6d 6e 73 20 | custom_|columns |
|00002b70| 53 45 54 20 6d 61 72 6b | 5f 66 6f 72 5f 64 65 6c |SET mark|_for_del|
|00002b80| 65 74 65 3d 31 20 57 48 | 45 52 45 20 69 64 3d 3f |ete=1 WH|ERE id=?|
|00002b90| 52 11 00 00 00 28 07 00 | 00 00 52 24 00 00 00 52 |R....(..|..R$...R|
|00002ba0| 48 00 00 00 52 49 00 00 | 00 52 43 00 00 00 52 14 |H...RI..|.RC...R.|
|00002bb0| 00 00 00 52 46 00 00 00 | 52 47 00 00 00 28 04 00 |...RF...|RG...(..|
|00002bc0| 00 00 52 10 00 00 00 52 | 1b 00 00 00 52 11 00 00 |..R....R|....R...|
|00002bd0| 00 52 56 00 00 00 28 00 | 00 00 00 28 00 00 00 00 |.RV...(.|...(....|
|00002be0| 73 2f 00 00 00 73 69 74 | 65 2d 70 61 63 6b 61 67 |s/...sit|e-packag|
|00002bf0| 65 73 5c 63 61 6c 69 62 | 72 65 5c 6c 69 62 72 61 |es\calib|re\libra|
|00002c00| 72 79 5c 63 75 73 74 6f | 6d 5f 63 6f 6c 75 6d 6e |ry\custo|m_column|
|00002c10| 73 2e 70 79 74 14 00 00 | 00 64 65 6c 65 74 65 5f |s.pyt...|.delete_|
|00002c20| 63 75 73 74 6f 6d 5f 63 | 6f 6c 75 6d 6e 16 01 00 |custom_c|olumn...|
|00002c30| 00 73 16 00 00 00 00 01 | 06 01 0d 01 11 01 0d 01 |.s......|........|
|00002c40| 11 01 0d 01 10 01 09 01 | 03 01 0e 01 63 06 00 00 |........|....c...|
|00002c50| 00 07 00 00 00 04 00 00 | 00 43 80 00 00 73 08 01 |........|.C...s..|
|00002c60| 00 00 74 00 00 7d 06 00 | 7c 02 00 64 00 00 6a 09 |..t..}..||..d..j.|
|00002c70| 00 6f 23 00 01 7c 00 00 | 69 02 00 69 03 00 64 01 |.o#..|..|i..i..d.|
|00002c80| 00 7c 02 00 7c 01 00 66 | 02 00 83 02 00 01 74 04 |.|..|..f|......t.|
|00002c90| 00 7d 06 00 6e 01 00 01 | 7c 03 00 64 00 00 6a 09 |.}..n...||..d..j.|
|00002ca0| 00 6f 23 00 01 7c 00 00 | 69 02 00 69 03 00 64 02 |.o#..|..|i..i..d.|
|00002cb0| 00 7c 03 00 7c 01 00 66 | 02 00 83 02 00 01 74 04 |.|..|..f|......t.|
|00002cc0| 00 7d 06 00 6e 01 00 01 | 7c 04 00 64 00 00 6a 09 |.}..n...||..d..j.|
|00002cd0| 00 6f 40 00 01 7c 00 00 | 69 02 00 69 03 00 64 03 |.o@..|..|i..i..d.|
|00002ce0| 00 74 05 00 7c 04 00 83 | 01 00 7c 01 00 66 02 00 |.t..|...|..|..f..|
|00002cf0| 83 02 00 01 74 05 00 7c | 04 00 83 01 00 7c 00 00 |....t..||.....|..|
|00002d00| 69 06 00 7c 01 00 19 64 | 04 00 3c 74 04 00 7d 06 |i..|...d|..<t..}.|
|00002d10| 00 6e 01 00 01 7c 05 00 | 64 00 00 6a 09 00 6f 2c |.n...|..|d..j..o,|
|00002d20| 00 01 7c 00 00 69 02 00 | 69 03 00 64 05 00 74 07 |..|..i..|i..d..t.|
|00002d30| 00 69 08 00 7c 05 00 83 | 01 00 7c 01 00 66 02 00 |.i..|...|..|..f..|
|00002d40| 83 02 00 01 74 04 00 7d | 06 00 6e 01 00 01 7c 06 |....t..}|..n...|.|
|00002d50| 00 6f 11 00 01 7c 00 00 | 69 02 00 69 09 00 83 00 |.o...|..|i..i....|
|00002d60| 00 01 6e 01 00 01 7c 06 | 00 53 28 06 00 00 00 4e |..n...|.|.S(....N|
|00002d70| 73 2b 00 00 00 55 50 44 | 41 54 45 20 63 75 73 74 |s+...UPD|ATE cust|
|00002d80| 6f 6d 5f 63 6f 6c 75 6d | 6e 73 20 53 45 54 20 6e |om_colum|ns SET n|
|00002d90| 61 6d 65 3d 3f 20 57 48 | 45 52 45 20 69 64 3d 3f |ame=? WH|ERE id=?|
|00002da0| 73 2c 00 00 00 55 50 44 | 41 54 45 20 63 75 73 74 |s,...UPD|ATE cust|
|00002db0| 6f 6d 5f 63 6f 6c 75 6d | 6e 73 20 53 45 54 20 6c |om_colum|ns SET l|
|00002dc0| 61 62 65 6c 3d 3f 20 57 | 48 45 52 45 20 69 64 3d |abel=? W|HERE id=|
|00002dd0| 3f 73 2f 00 00 00 55 50 | 44 41 54 45 20 63 75 73 |?s/...UP|DATE cus|
|00002de0| 74 6f 6d 5f 63 6f 6c 75 | 6d 6e 73 20 53 45 54 20 |tom_colu|mns SET |
|00002df0| 65 64 69 74 61 62 6c 65 | 3d 3f 20 57 48 45 52 45 |editable|=? WHERE|
|00002e00| 20 69 64 3d 3f 52 3f 00 | 00 00 73 2e 00 00 00 55 | id=?R?.|..s....U|
|00002e10| 50 44 41 54 45 20 63 75 | 73 74 6f 6d 5f 63 6f 6c |PDATE cu|stom_col|
|00002e20| 75 6d 6e 73 20 53 45 54 | 20 64 69 73 70 6c 61 79 |umns SET| display|
|00002e30| 3d 3f 20 57 48 45 52 45 | 20 69 64 3d 3f 28 0a 00 |=? WHERE| id=?(..|
|00002e40| 00 00 52 34 00 00 00 52 | 24 00 00 00 52 14 00 00 |..R4...R|$...R...|
|00002e50| 00 52 46 00 00 00 52 50 | 00 00 00 52 0e 00 00 00 |.RF...RP|...R....|
|00002e60| 52 49 00 00 00 52 4a 00 | 00 00 74 05 00 00 00 64 |RI...RJ.|..t....d|
|00002e70| 75 6d 70 73 52 47 00 00 | 00 28 07 00 00 00 52 10 |umpsRG..|.(....R.|
|00002e80| 00 00 00 52 11 00 00 00 | 52 1c 00 00 00 52 1b 00 |...R....|R....R..|
|00002e90| 00 00 52 3f 00 00 00 52 | 1f 00 00 00 74 07 00 00 |..R?...R|....t...|
|00002ea0| 00 63 68 61 6e 67 65 64 | 28 00 00 00 00 28 00 00 |.changed|(....(..|
|00002eb0| 00 00 73 2f 00 00 00 73 | 69 74 65 2d 70 61 63 6b |..s/...s|ite-pack|
|00002ec0| 61 67 65 73 5c 63 61 6c | 69 62 72 65 5c 6c 69 62 |ages\cal|ibre\lib|
|00002ed0| 72 61 72 79 5c 63 75 73 | 74 6f 6d 5f 63 6f 6c 75 |rary\cus|tom_colu|
|00002ee0| 6d 6e 73 2e 70 79 74 1a | 00 00 00 73 65 74 5f 63 |mns.pyt.|...set_c|
|00002ef0| 75 73 74 6f 6d 5f 63 6f | 6c 75 6d 6e 5f 6d 65 74 |ustom_co|lumn_met|
|00002f00| 61 64 61 74 61 23 01 00 | 00 73 2a 00 00 00 00 02 |adata#..|.s*.....|
|00002f10| 06 01 0d 01 0c 01 0d 01 | 0a 01 0d 01 0c 01 0d 01 |........|........|
|00002f20| 0a 01 0d 01 0c 01 13 01 | 17 01 0a 01 0d 01 0c 01 |........|........|
|00002f30| 16 01 0a 02 07 01 11 01 | 63 08 00 00 00 16 00 00 |........|c.......|
|00002f40| 00 0c 00 00 00 43 80 00 | 00 73 90 04 00 00 7c 03 |.....C..|.s....|.|
|00002f50| 00 64 00 00 6a 09 00 6f | 11 00 01 7c 00 00 69 01 |.d..j..o|...|..i.|
|00002f60| 00 7c 03 00 19 7d 08 00 | 6e 01 00 01 7c 04 00 64 |.|...}..|n...|..d|
|00002f70| 00 00 6a 09 00 6f 11 00 | 01 7c 00 00 69 02 00 7c |..j..o..|.|..i..||
|00002f80| 04 00 19 7d 08 00 6e 01 | 00 01 7c 08 00 64 01 00 |...}..n.|..|..d..|
|00002f90| 19 70 18 00 01 74 03 00 | 64 02 00 7c 08 00 64 03 |.p...t..|d..|..d.|
|00002fa0| 00 19 16 83 01 00 82 01 | 00 6e 01 00 01 7c 00 00 |........|.n...|..|
|00002fb0| 69 04 00 7c 08 00 64 04 | 00 19 83 01 00 5c 02 00 |i..|..d.|.....\..|
|00002fc0| 7d 09 00 7d 0a 00 74 05 | 00 7c 00 00 69 06 00 7c |}..}..t.|.|..i..||
|00002fd0| 01 00 64 04 00 7c 08 00 | 64 04 00 19 64 05 00 74 |..d..|..|d...d..t|
|00002fe0| 07 00 83 02 02 7d 0b 00 | 7c 00 00 69 08 00 7c 08 |.....}..||..i..|.|
|00002ff0| 00 64 06 00 19 19 7c 02 | 00 7c 08 00 83 02 00 7d |.d....|.|.|.....}|
|00003000| 02 00 7c 08 00 64 07 00 | 19 6f 0d 03 01 7c 05 00 |..|..d..|.o...|..|
|00003010| 0c 70 0c 00 01 7c 08 00 | 64 08 00 19 0c 6f 5a 00 |.p...|..|d....oZ.|
|00003020| 01 7c 00 00 69 09 00 69 | 0a 00 64 09 00 7c 0a 00 |.|..i..i|..d..|..|
|00003030| 16 7c 01 00 66 01 00 83 | 02 00 01 7c 00 00 69 09 |.|..f...|...|..i.|
|00003040| 00 69 0a 00 64 0a 00 7c | 09 00 7c 0a 00 7c 09 00 |.i..d..||..|..|..|
|00003050| 66 03 00 16 83 01 00 01 | 64 00 00 7c 00 00 69 0b |f.......|d..|..i.|
|00003060| 00 69 0c 00 7c 01 00 19 | 7c 00 00 69 0d 00 7c 08 |.i..|...||..i..|.|
|00003070| 00 64 04 00 19 19 3c 6e | 01 00 01 7c 08 00 64 08 |.d....<n|...|..d.|
|00003080| 00 19 6f 07 00 01 7c 02 | 00 6e 07 00 01 7c 02 00 |..o...|.|.n...|..|
|00003090| 67 01 00 7d 0c 00 7c 0b | 00 83 00 00 7d 0d 00 7c |g..}..|.|....}..||
|000030a0| 0d 00 70 0a 00 01 67 00 | 00 7d 0d 00 6e 01 00 01 |..p...g.|.}..n...|
|000030b0| 78 09 02 74 0e 00 7c 0c | 00 83 01 00 74 0e 00 7c |x..t..|.|....t..||
|000030c0| 0d 00 83 01 00 18 44 5d | f1 01 7d 0e 00 7c 0e 00 |......D]|..}..|..|
|000030d0| 64 00 00 6a 08 00 6f 07 | 00 01 71 79 01 6e 01 00 |d..j..o.|..qy.n..|
|000030e0| 01 74 0f 00 7c 00 00 69 | 10 00 64 04 00 7c 08 00 |.t..|..i|..d..|..|
|000030f0| 64 04 00 19 83 00 01 83 | 01 00 7d 0d 00 67 00 00 |d.......|..}..g..|
|00003100| 04 7d 0f 00 7c 0d 00 44 | 5d 2a 00 7d 10 00 7c 0f |.}..|..D|]*.}..|.|
|00003110| 00 74 11 00 7c 10 00 64 | 0b 00 83 02 00 6f 0d 00 |.t..|..d|.....o..|
|00003120| 01 7c 10 00 69 12 00 83 | 00 00 6e 04 00 01 7c 10 |.|..i...|..n...|.|
|00003130| 00 12 71 ba 01 7e 0f 00 | 7d 11 00 79 30 00 7c 11 |..q..~..|}..y0.|.|
|00003140| 00 69 13 00 74 11 00 7c | 0e 00 64 0b 00 83 02 00 |.i..t..||..d.....|
|00003150| 6f 0d 00 01 7c 0e 00 69 | 12 00 83 00 00 6e 04 00 |o...|..i|.....n..|
|00003160| 01 7c 0e 00 83 01 00 7d | 12 00 57 6e 19 00 04 74 |.|.....}|..Wn...t|
|00003170| 03 00 6a 0a 00 6f 0d 00 | 01 01 01 01 64 0c 00 7d |..j..o..|....d..}|
|00003180| 12 00 6e 02 00 01 58 7c | 12 00 64 0c 00 6a 04 00 |..n...X||..d..j..|
|00003190| 6f 5e 00 01 7c 0d 00 7c | 12 00 19 7d 13 00 7c 00 |o^..|..||...}..|.|
|000031a0| 00 69 09 00 69 14 00 64 | 0d 00 7c 09 00 16 7c 13 |.i..i..d|..|...|.|
|000031b0| 00 66 01 00 64 0e 00 74 | 15 00 83 02 01 7d 14 00 |.f..d..t|.....}..|
|000031c0| 7c 13 00 7c 0e 00 6a 03 | 00 6f 21 00 01 7c 00 00 ||..|..j.|.o!..|..|
|000031d0| 69 09 00 69 0a 00 64 0f | 00 7c 09 00 16 7c 0e 00 |i..i..d.|.|...|..|
|000031e0| 7c 14 00 66 02 00 83 02 | 00 01 71 c3 02 01 6e 20 ||..f....|..q...n |
|000031f0| 00 01 7c 00 00 69 09 00 | 69 0a 00 64 10 00 7c 09 |..|..i..|i..d..|.|
|00003200| 00 16 7c 0e 00 66 01 00 | 83 02 00 69 16 00 7d 14 |..|..f..|...i..}.|
|00003210| 00 7c 00 00 69 09 00 69 | 14 00 64 11 00 7c 0a 00 |.|..i..i|..d..|..|
|00003220| 16 7c 01 00 7c 14 00 66 | 02 00 64 0e 00 74 15 00 |.|..|..f|..d..t..|
|00003230| 83 02 01 70 81 00 01 7c | 08 00 64 06 00 19 64 12 |...p...||..d...d.|
|00003240| 00 6a 02 00 6f 4f 00 01 | 7c 00 00 69 09 00 69 0a |.j..oO..||..i..i.|
|00003250| 00 64 13 00 7c 0a 00 16 | 7c 01 00 7c 14 00 7c 07 |.d..|...||..|..|.|
|00003260| 00 66 03 00 83 02 00 01 | 7c 00 00 69 0b 00 69 0e |.f......||..i..i.|
|00003270| 00 7c 01 00 7c 00 00 69 | 0d 00 7c 08 00 64 04 00 |.|..|..i|..|..d..|
|00003280| 19 19 64 14 00 17 7c 07 | 00 64 15 00 74 07 00 83 |..d...|.|.d..t...|
|00003290| 03 01 01 71 6a 03 01 7c | 00 00 69 09 00 69 0a 00 |...qj..||..i..i..|
|000032a0| 64 16 00 7c 0a 00 16 7c | 01 00 7c 14 00 66 02 00 |d..|...||..|..f..|
|000032b0| 83 02 00 01 71 79 01 01 | 71 79 01 57 7c 00 00 69 |....qy..|qy.W|..i|
|000032c0| 09 00 69 17 00 83 00 00 | 01 7c 00 00 69 09 00 69 |..i.....|.|..i..i|
|000032d0| 14 00 64 17 00 7c 08 00 | 64 04 00 19 16 7c 01 00 |..d..|..|d....|..|
|000032e0| 66 01 00 64 0e 00 74 15 | 00 83 02 01 7d 15 00 7c |f..d..t.|....}..||
|000032f0| 00 00 69 0b 00 69 0e 00 | 7c 01 00 7c 00 00 69 0d |..i..i..||..|..i.|
|00003300| 00 7c 08 00 64 04 00 19 | 19 7c 15 00 64 15 00 74 |.|..d...|.|..d..t|
|00003310| 07 00 83 03 01 01 6e a3 | 00 01 7c 00 00 69 09 00 |......n.|..|..i..|
|00003320| 69 0a 00 64 09 00 7c 09 | 00 16 7c 01 00 66 01 00 |i..d..|.|..|..f..|
|00003330| 83 02 00 01 7c 02 00 64 | 00 00 6a 09 00 6f 21 00 |....|..d|..j..o!.|
|00003340| 01 7c 00 00 69 09 00 69 | 0a 00 64 18 00 7c 09 00 |.|..i..i|..d..|..|
|00003350| 16 7c 01 00 7c 02 00 66 | 02 00 83 02 00 01 6e 01 |.|..|..f|......n.|
|00003360| 00 01 7c 00 00 69 09 00 | 69 17 00 83 00 00 01 7c |..|..i..|i......||
|00003370| 00 00 69 09 00 69 14 00 | 64 17 00 7c 08 00 64 04 |..i..i..|d..|..d.|
|00003380| 00 19 16 7c 01 00 66 01 | 00 64 0e 00 74 15 00 83 |...|..f.|.d..t...|
|00003390| 02 01 7d 15 00 7c 00 00 | 69 0b 00 69 0e 00 7c 01 |..}..|..|i..i..|.|
|000033a0| 00 7c 00 00 69 0d 00 7c | 08 00 64 04 00 19 19 7c |.|..i..||..d....||
|000033b0| 15 00 64 15 00 74 07 00 | 83 03 01 01 7c 06 00 6f |..d..t..|....|..o|
|000033c0| 17 00 01 7c 00 00 69 18 | 00 64 19 00 7c 01 00 67 |...|..i.|.d..|..g|
|000033d0| 01 00 83 02 00 01 6e 01 | 00 01 7c 15 00 53 28 1a |......n.|..|..S(.|
|000033e0| 00 00 00 4e 52 1e 00 00 | 00 73 19 00 00 00 43 6f |...NR...|.s....Co|
|000033f0| 6c 75 6d 6e 20 25 72 20 | 69 73 20 6e 6f 74 20 65 |lumn %r |is not e|
|00003400| 64 69 74 61 62 6c 65 52 | 1b 00 00 00 52 11 00 00 |ditableR|....R...|
|00003410| 00 52 64 00 00 00 52 1d | 00 00 00 52 20 00 00 00 |.Rd...R.|...R ...|
|00003420| 52 21 00 00 00 73 1b 00 | 00 00 44 45 4c 45 54 45 |R!...s..|..DELETE|
|00003430| 20 46 52 4f 4d 20 25 73 | 20 57 48 45 52 45 20 62 | FROM %s| WHERE b|
|00003440| 6f 6f 6b 3d 3f 73 59 00 | 00 00 44 45 4c 45 54 45 |ook=?sY.|..DELETE|
|00003450| 20 46 52 4f 4d 20 25 73 | 20 57 48 45 52 45 20 28 | FROM %s| WHERE (|
|00003460| 53 45 4c 45 43 54 20 43 | 4f 55 4e 54 28 69 64 29 |SELECT C|OUNT(id)|
|00003470| 20 46 52 4f 4d 20 25 73 | 20 57 48 45 52 45 0a 20 | FROM %s| WHERE. |
|00003480| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00003490| 20 20 20 76 61 6c 75 65 | 3d 25 73 2e 69 64 29 20 | value|=%s.id) |
|000034a0| 3c 20 31 52 5f 00 00 00 | 69 ff ff ff ff 73 1f 00 |< 1R_...|i....s..|
|000034b0| 00 00 53 45 4c 45 43 54 | 20 69 64 20 46 52 4f 4d |..SELECT| id FROM|
|000034c0| 20 25 73 20 57 48 45 52 | 45 20 76 61 6c 75 65 3d | %s WHER|E value=|
|000034d0| 3f 52 68 00 00 00 73 20 | 00 00 00 55 50 44 41 54 |?Rh...s |...UPDAT|
|000034e0| 45 20 25 73 20 53 45 54 | 20 76 61 6c 75 65 3d 3f |E %s SET| value=?|
|000034f0| 20 57 48 45 52 45 20 69 | 64 3d 3f 73 1f 00 00 00 | WHERE i|d=?s....|
|00003500| 49 4e 53 45 52 54 20 49 | 4e 54 4f 20 25 73 28 76 |INSERT I|NTO %s(v|
|00003510| 61 6c 75 65 29 20 56 41 | 4c 55 45 53 28 3f 29 73 |alue) VA|LUES(?)s|
|00003520| 2c 00 00 00 53 45 4c 45 | 43 54 20 62 6f 6f 6b 20 |,...SELE|CT book |
|00003530| 46 52 4f 4d 20 25 73 20 | 57 48 45 52 45 20 62 6f |FROM %s |WHERE bo|
|00003540| 6f 6b 3d 3f 20 41 4e 44 | 20 76 61 6c 75 65 3d 3f |ok=? AND| value=?|
|00003550| 52 0f 00 00 00 73 50 00 | 00 00 49 4e 53 45 52 54 |R....sP.|..INSERT|
|00003560| 20 49 4e 54 4f 20 25 73 | 28 62 6f 6f 6b 2c 20 76 | INTO %s|(book, v|
|00003570| 61 6c 75 65 2c 20 65 78 | 74 72 61 29 0a 20 20 20 |alue, ex|tra). |
|00003580| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00003590| 20 20 20 20 20 20 20 20 | 20 20 20 20 56 41 4c 55 | | VALU|
|000035a0| 45 53 20 28 3f 2c 3f 2c | 3f 29 69 01 00 00 00 74 |ES (?,?,|?)i....t|
|000035b0| 09 00 00 00 72 6f 77 5f | 69 73 5f 69 64 73 48 00 |....row_|is_idsH.|
|000035c0| 00 00 49 4e 53 45 52 54 | 20 49 4e 54 4f 20 25 73 |..INSERT| INTO %s|
|000035d0| 28 62 6f 6f 6b 2c 20 76 | 61 6c 75 65 29 0a 20 20 |(book, v|alue). |
|000035e0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|000035f0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 56 41 | | VA|
|00003600| 4c 55 45 53 20 28 3f 2c | 3f 29 73 26 00 00 00 53 |LUES (?,|?)s&...S|
|00003610| 45 4c 45 43 54 20 63 75 | 73 74 6f 6d 5f 25 73 20 |ELECT cu|stom_%s |
|00003620| 46 52 4f 4d 20 6d 65 74 | 61 32 20 57 48 45 52 45 |FROM met|a2 WHERE|
|00003630| 20 69 64 3d 3f 73 27 00 | 00 00 49 4e 53 45 52 54 | id=?s'.|..INSERT|
|00003640| 20 49 4e 54 4f 20 25 73 | 28 62 6f 6f 6b 2c 76 61 | INTO %s|(book,va|
|00003650| 6c 75 65 29 20 56 41 4c | 55 45 53 20 28 3f 2c 3f |lue) VAL|UES (?,?|
|00003660| 29 74 08 00 00 00 6d 65 | 74 61 64 61 74 61 28 19 |)t....me|tadata(.|
|00003670| 00 00 00 52 24 00 00 00 | 52 48 00 00 00 52 49 00 |...R$...|RH...RI.|
|00003680| 00 00 52 43 00 00 00 52 | 12 00 00 00 52 01 00 00 |..RC...R|....R...|
|00003690| 00 52 67 00 00 00 52 50 | 00 00 00 52 4d 00 00 00 |.Rg...RP|...RM...|
|000036a0| 52 14 00 00 00 52 46 00 | 00 00 52 56 00 00 00 52 |R....RF.|..RV...R|
|000036b0| 60 00 00 00 52 61 00 00 | 00 52 13 00 00 00 74 04 |`...Ra..|.R....t.|
|000036c0| 00 00 00 6c 69 73 74 52 | 77 00 00 00 74 07 00 00 |...listR|w...t...|
|000036d0| 00 68 61 73 61 74 74 72 | 52 5f 00 00 00 74 05 00 |.hasattr|R_...t..|
|000036e0| 00 00 69 6e 64 65 78 52 | 15 00 00 00 52 34 00 00 |..indexR|....R4..|
|000036f0| 00 74 09 00 00 00 6c 61 | 73 74 72 6f 77 69 64 52 |.t....la|strowidR|
|00003700| 47 00 00 00 74 06 00 00 | 00 6e 6f 74 69 66 79 28 |G...t...|.notify(|
|00003710| 16 00 00 00 52 10 00 00 | 00 74 03 00 00 00 69 64 |....R...|.t....id|
|00003720| 5f 74 03 00 00 00 76 61 | 6c 52 1b 00 00 00 52 11 |_t....va|lR....R.|
|00003730| 00 00 00 52 4c 00 00 00 | 52 82 00 00 00 74 05 00 |...RL...|R....t..|
|00003740| 00 00 65 78 74 72 61 52 | 56 00 00 00 52 19 00 00 |..extraR|V...R...|
|00003750| 00 52 1a 00 00 00 74 06 | 00 00 00 67 65 74 74 65 |.R....t.|...gette|
|00003760| 72 74 07 00 00 00 73 65 | 74 5f 76 61 6c 74 08 00 |rt....se|t_valt..|
|00003770| 00 00 65 78 69 73 74 69 | 6e 67 52 17 00 00 00 52 |..existi|ngR....R|
|00003780| 16 00 00 00 74 01 00 00 | 00 74 74 02 00 00 00 6c |....t...|.tt....l|
|00003790| 78 52 63 00 00 00 74 02 | 00 00 00 65 78 74 03 00 |xRc...t.|...ext..|
|000037a0| 00 00 78 69 64 74 04 00 | 00 00 6e 76 61 6c 28 00 |..xidt..|..nval(.|
|000037b0| 00 00 00 28 00 00 00 00 | 73 2f 00 00 00 73 69 74 |...(....|s/...sit|
|000037c0| 65 2d 70 61 63 6b 61 67 | 65 73 5c 63 61 6c 69 62 |e-packag|es\calib|
|000037d0| 72 65 5c 6c 69 62 72 61 | 72 79 5c 63 75 73 74 6f |re\libra|ry\custo|
|000037e0| 6d 5f 63 6f 6c 75 6d 6e | 73 2e 70 79 74 0a 00 00 |m_column|s.pyt...|
|000037f0| 00 73 65 74 5f 63 75 73 | 74 6f 6d 3c 01 00 00 73 |.set_cus|tom<...s|
|00003800| 8a 00 00 00 00 02 0d 01 | 11 01 0d 01 11 01 0b 01 |........|........|
|00003810| 18 01 19 01 19 01 09 01 | 1a 02 0b 01 14 01 1a 01 |........|........|
|00003820| 09 02 14 01 23 01 1b 01 | 09 01 07 01 0a 01 17 00 |....#...|........|
|00003830| 06 01 0d 01 07 01 1c 01 | 3e 01 03 01 30 01 0e 01 |........|>...0...|
|00003840| 0b 01 0d 01 0a 01 09 01 | 19 01 0d 01 09 01 1c 02 |........|........|
|00003850| 09 01 16 01 09 01 07 01 | 16 01 11 01 09 02 17 01 |........|........|
|00003860| 1e 01 11 02 09 02 1c 01 | 0d 01 09 01 0b 01 12 01 |........|........|
|00003870| 20 01 0b 02 1a 01 0d 01 | 09 01 07 01 11 01 0d 01 | .......|........|
|00003880| 09 01 0b 01 12 01 20 01 | 07 01 07 01 17 01 63 01 |...... .|......c.|
|00003890| 00 00 00 06 00 00 00 07 | 00 00 00 43 80 00 00 73 |........|...C...s|
|000038a0| a2 00 00 00 64 01 00 7d | 01 00 67 00 00 7d 02 00 |....d..}|..g..}..|
|000038b0| 78 5e 00 7c 00 00 69 00 | 00 69 01 00 83 00 00 44 |x^.|..i.|.i.....D|
|000038c0| 5d 4d 00 7d 03 00 7c 03 | 00 64 02 00 19 6f 3c 00 |]M.}..|.|.d...o<.|
|000038d0| 01 7c 00 00 69 02 00 7c | 03 00 64 03 00 19 83 01 |.|..i..||..d.....|
|000038e0| 00 5c 02 00 7d 04 00 7d | 05 00 7c 02 00 69 03 00 |.\..}..}|..|..i..|
|000038f0| 7c 01 00 69 04 00 64 04 | 00 7c 05 00 64 05 00 7c ||..i..d.|.|..d..||
|00003900| 04 00 83 00 02 83 01 00 | 01 71 1c 00 01 71 1c 00 |........|.q...q..|
|00003910| 57 7c 02 00 6f 2a 00 01 | 7c 00 00 69 05 00 69 06 |W|..o*..||..i..i.|
|00003920| 00 64 06 00 69 07 00 7c | 02 00 83 01 00 83 01 00 |.d..i..||........|
|00003930| 01 7c 00 00 69 05 00 69 | 08 00 83 00 00 01 6e 01 |.|..i..i|......n.|
|00003940| 00 01 64 00 00 53 28 07 | 00 00 00 4e 73 57 00 00 |..d..S(.|...NsW..|
|00003950| 00 44 45 4c 45 54 45 20 | 46 52 4f 4d 20 7b 74 61 |.DELETE |FROM {ta|
|00003960| 62 6c 65 7d 20 57 48 45 | 52 45 20 28 53 45 4c 45 |ble} WHE|RE (SELE|
|00003970| 43 54 20 43 4f 55 4e 54 | 28 69 64 29 20 46 52 4f |CT COUNT|(id) FRO|
|00003980| 4d 20 7b 6c 74 7d 20 57 | 48 45 52 45 20 7b 6c 74 |M {lt} W|HERE {lt|
|00003990| 7d 2e 76 61 6c 75 65 3d | 7b 74 61 62 6c 65 7d 2e |}.value=|{table}.|
|000039a0| 69 64 29 20 3c 20 31 3b | 52 20 00 00 00 52 11 00 |id) < 1;|R ...R..|
|000039b0| 00 00 52 1a 00 00 00 52 | 19 00 00 00 73 02 00 00 |..R....R|....s...|
|000039c0| 00 20 0a 28 09 00 00 00 | 52 49 00 00 00 74 06 00 |. .(....|RI...t..|
|000039d0| 00 00 76 61 6c 75 65 73 | 52 12 00 00 00 52 4c 00 |..values|R....RL.|
|000039e0| 00 00 52 45 00 00 00 52 | 14 00 00 00 52 44 00 00 |..RE...R|....RD..|
|000039f0| 00 52 2c 00 00 00 52 47 | 00 00 00 28 06 00 00 00 |.R,...RG|...(....|
|00003a00| 52 10 00 00 00 74 02 00 | 00 00 73 74 74 0a 00 00 |R....t..|..stt...|
|00003a10| 00 73 74 61 74 65 6d 65 | 6e 74 73 52 56 00 00 00 |.stateme|ntsRV...|
|00003a20| 52 19 00 00 00 52 1a 00 | 00 00 28 00 00 00 00 28 |R....R..|..(....(|
|00003a30| 00 00 00 00 73 2f 00 00 | 00 73 69 74 65 2d 70 61 |....s/..|.site-pa|
|00003a40| 63 6b 61 67 65 73 5c 63 | 61 6c 69 62 72 65 5c 6c |ckages\c|alibre\l|
|00003a50| 69 62 72 61 72 79 5c 63 | 75 73 74 6f 6d 5f 63 6f |ibrary\c|ustom_co|
|00003a60| 6c 75 6d 6e 73 2e 70 79 | 74 0c 00 00 00 63 6c 65 |lumns.py|t....cle|
|00003a70| 61 6e 5f 63 75 73 74 6f | 6d 8a 01 00 00 73 14 00 |an_custo|m....s..|
|00003a80| 00 00 00 01 06 02 06 01 | 10 00 06 01 0b 01 19 01 |........|........|
|00003a90| 27 01 07 01 19 01 63 01 | 00 00 00 08 00 00 00 0b |'.....c.|........|
|00003aa0| 00 00 00 43 80 00 00 73 | 19 01 00 00 68 00 00 7d |...C...s|....h..}|
|00003ab0| 01 00 78 0c 01 7c 00 00 | 69 00 00 69 01 00 83 00 |..x..|..|i..i....|
|00003ac0| 00 44 5d fb 00 7d 02 00 | 7c 02 00 64 01 00 19 7d |.D]..}..||..d...}|
|00003ad0| 03 00 7c 00 00 69 02 00 | 7c 02 00 64 02 00 19 83 |..|..i..||..d....|
|00003ae0| 01 00 5c 02 00 7d 04 00 | 7d 05 00 7c 02 00 64 03 |..\..}..|}..|..d.|
|00003af0| 00 19 6f 9d 00 01 64 04 | 00 7d 06 00 7c 02 00 64 |..o...d.|.}..|..d|
|00003b00| 05 00 19 6f 27 00 01 64 | 06 00 7d 06 00 7c 03 00 |...o'..d|..}..|..|
|00003b10| 69 03 00 64 07 00 74 04 | 00 83 02 00 70 0a 00 01 |i..d..t.|....p...|
|00003b20| 64 08 00 7d 06 00 71 82 | 00 01 6e 01 00 01 64 09 |d..}..q.|..n...d.|
|00003b30| 00 69 05 00 64 0a 00 7c | 06 00 7c 04 00 16 64 0b |.i..d..||..|...d.|
|00003b40| 00 7c 05 00 64 0c 00 7c | 04 00 64 02 00 7c 02 00 |.|..d..||..d..|..|
|00003b50| 64 02 00 19 83 00 04 7d | 07 00 7c 02 00 64 0d 00 |d......}|..|..d..|
|00003b60| 19 64 0e 00 6a 02 00 6f | 24 00 01 7c 07 00 64 0f |.d..j..o|$..|..d.|
|00003b70| 00 69 05 00 64 0b 00 7c | 05 00 64 02 00 7c 02 00 |.i..d..||..d..|..|
|00003b80| 64 02 00 19 83 00 02 37 | 7d 07 00 71 03 01 01 6e |d......7|}..q...n|
|00003b90| 1d 00 01 64 10 00 69 05 | 00 64 0c 00 7c 04 00 64 |...d..i.|.d..|..d|
|00003ba0| 02 00 7c 02 00 64 02 00 | 19 83 00 02 7d 07 00 7c |..|..d..|....}..||
|00003bb0| 07 00 7c 01 00 7c 02 00 | 64 02 00 19 3c 71 16 00 |..|..|..|d...<q..|
|00003bc0| 57 7c 01 00 53 28 11 00 | 00 00 4e 52 1f 00 00 00 |W|..S(..|..NR....|
|00003bd0| 52 11 00 00 00 52 20 00 | 00 00 73 08 00 00 00 25 |R....R .|..s....%|
|00003be0| 73 2e 76 61 6c 75 65 52 | 21 00 00 00 73 1b 00 00 |s.valueR|!...s...|
|00003bf0| 00 67 72 6f 75 70 5f 63 | 6f 6e 63 61 74 28 25 73 |.group_c|oncat(%s|
|00003c00| 2e 76 61 6c 75 65 2c 20 | 22 7c 22 29 52 5d 00 00 |.value, |"|")R]..|
|00003c10| 00 73 1e 00 00 00 73 6f | 72 74 5f 63 6f 6e 63 61 |.s....so|rt_conca|
|00003c20| 74 28 6c 69 6e 6b 2e 69 | 64 2c 20 25 73 2e 76 61 |t(link.i|d, %s.va|
|00003c30| 6c 75 65 29 73 ae 00 00 | 00 28 53 45 4c 45 43 54 |lue)s...|.(SELECT|
|00003c40| 20 7b 71 75 65 72 79 7d | 20 46 52 4f 4d 20 7b 6c | {query}| FROM {l|
|00003c50| 74 7d 20 41 53 20 6c 69 | 6e 6b 20 49 4e 4e 45 52 |t} AS li|nk INNER|
|00003c60| 20 4a 4f 49 4e 0a 20 20 | 20 20 20 20 20 20 20 20 | JOIN. | |
|00003c70| 20 20 20 20 20 20 20 20 | 20 20 7b 74 61 62 6c 65 | | {table|
|00003c80| 7d 20 4f 4e 28 6c 69 6e | 6b 2e 76 61 6c 75 65 3d |} ON(lin|k.value=|
|00003c90| 7b 74 61 62 6c 65 7d 2e | 69 64 29 20 57 48 45 52 |{table}.|id) WHER|
|00003ca0| 45 20 6c 69 6e 6b 2e 62 | 6f 6f 6b 3d 62 6f 6f 6b |E link.b|ook=book|
|00003cb0| 73 2e 69 64 29 0a 20 20 | 20 20 20 20 20 20 20 20 |s.id). | |
|00003cc0| 20 20 20 20 20 20 20 20 | 20 20 63 75 73 74 6f 6d | | custom|
|00003cd0| 5f 7b 6e 75 6d 7d 0a 20 | 20 20 20 20 20 20 20 20 |_{num}. | |
|00003ce0| 20 20 20 20 20 20 20 74 | 05 00 00 00 71 75 65 72 | t|....quer|
|00003cf0| 79 52 1a 00 00 00 52 19 | 00 00 00 52 1d 00 00 00 |yR....R.|...R....|
|00003d00| 52 0f 00 00 00 73 5d 00 | 00 00 2c 28 53 45 4c 45 |R....s].|..,(SELE|
|00003d10| 43 54 20 65 78 74 72 61 | 20 46 52 4f 4d 20 7b 6c |CT extra| FROM {l|
|00003d20| 74 7d 20 57 48 45 52 45 | 20 7b 6c 74 7d 2e 62 6f |t} WHERE| {lt}.bo|
|00003d30| 6f 6b 3d 62 6f 6f 6b 73 | 2e 69 64 29 0a 20 20 20 |ok=books|.id). |
|00003d40| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00003d50| 20 20 20 20 20 63 75 73 | 74 6f 6d 5f 69 6e 64 65 | cus|tom_inde|
|00003d60| 78 5f 7b 6e 75 6d 7d 73 | 5e 00 00 00 0a 20 20 20 |x_{num}s|^.... |
|00003d70| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 28 53 45 | | (SE|
|00003d80| 4c 45 43 54 20 76 61 6c | 75 65 20 46 52 4f 4d 20 |LECT val|ue FROM |
|00003d90| 7b 74 61 62 6c 65 7d 20 | 57 48 45 52 45 20 62 6f |{table} |WHERE bo|
|00003da0| 6f 6b 3d 62 6f 6f 6b 73 | 2e 69 64 29 20 63 75 73 |ok=books|.id) cus|
|00003db0| 74 6f 6d 5f 7b 6e 75 6d | 7d 0a 20 20 20 20 20 20 |tom_{num|}. |
|00003dc0| 20 20 20 20 20 20 20 20 | 20 20 28 06 00 00 00 52 | | (....R|
|00003dd0| 48 00 00 00 52 8f 00 00 | 00 52 12 00 00 00 52 15 |H...R...|.R....R.|
|00003de0| 00 00 00 52 34 00 00 00 | 52 45 00 00 00 28 08 00 |...R4...|RE...(..|
|00003df0| 00 00 52 10 00 00 00 74 | 05 00 00 00 6c 69 6e 65 |..R....t|....line|
|00003e00| 73 52 56 00 00 00 52 1f | 00 00 00 52 19 00 00 00 |sRV...R.|...R....|
|00003e10| 52 1a 00 00 00 52 93 00 | 00 00 74 04 00 00 00 6c |R....R..|..t....l|
|00003e20| 69 6e 65 28 00 00 00 00 | 28 00 00 00 00 73 2f 00 |ine(....|(....s/.|
|00003e30| 00 00 73 69 74 65 2d 70 | 61 63 6b 61 67 65 73 5c |..site-p|ackages\|
|00003e40| 63 61 6c 69 62 72 65 5c | 6c 69 62 72 61 72 79 5c |calibre\|library\|
|00003e50| 63 75 73 74 6f 6d 5f 63 | 6f 6c 75 6d 6e 73 2e 70 |custom_c|olumns.p|
|00003e60| 79 74 16 00 00 00 63 75 | 73 74 6f 6d 5f 63 6f 6c |yt....cu|stom_col|
|00003e70| 75 6d 6e 73 5f 69 6e 5f | 6d 65 74 61 96 01 00 00 |umns_in_|meta....|
|00003e80| 73 24 00 00 00 00 01 06 | 01 10 00 06 01 0a 01 19 |s$......|........|
|00003e90| 01 0b 01 06 01 0b 01 06 | 01 13 01 0e 04 2c 01 11 |........|.....,..|
|00003ea0| 01 03 01 25 04 1c 01 12 | 01 63 07 00 00 00 10 00 |...%....|.c......|
|00003eb0| 00 00 0a 00 00 00 43 80 | 00 00 73 07 02 00 00 7c |......C.|..s....||
|00003ec0| 03 00 7c 00 00 69 00 00 | 6a 07 00 6f 14 00 01 74 |..|..i..|j..o...t|
|00003ed0| 01 00 64 01 00 7c 03 00 | 16 83 01 00 82 01 00 6e |..d..|..|.......n|
|00003ee0| 01 00 01 7c 03 00 64 1f | 00 6a 07 00 7d 07 00 7c |...|..d.|.j..}..||
|00003ef0| 04 00 6f 0a 00 01 7c 03 | 00 64 20 00 6a 06 00 7d |..o...|.|.d .j..}|
|00003f00| 04 00 7c 00 00 69 02 00 | 69 03 00 64 08 00 7c 01 |..|..i..|i..d..|.|
|00003f10| 00 7c 02 00 7c 03 00 7c | 04 00 7c 05 00 74 04 00 |.|..|..||..|..t..|
|00003f20| 69 05 00 7c 06 00 83 01 | 00 7c 07 00 66 07 00 83 |i..|....|.|..f...|
|00003f30| 02 00 69 06 00 7d 08 00 | 7c 03 00 64 21 00 6a 06 |..i..}..||..d!.j.|
|00003f40| 00 6f 0a 00 01 64 0a 00 | 7d 09 00 6e 5d 00 01 7c |.o...d..|}..n]..||
|00003f50| 03 00 64 22 00 6a 06 00 | 6f 0a 00 01 64 0c 00 7d |..d".j..|o...d..}|
|00003f60| 09 00 6e 46 00 01 7c 03 | 00 64 23 00 6a 06 00 6f |..nF..|.|.d#.j..o|
|00003f70| 0a 00 01 64 0d 00 7d 09 | 00 6e 2f 00 01 7c 03 00 |...d..}.|.n/..|..|
|00003f80| 64 02 00 6a 02 00 6f 0a | 00 01 64 0e 00 7d 09 00 |d..j..o.|..d..}..|
|00003f90| 6e 18 00 01 7c 03 00 64 | 05 00 6a 02 00 6f 0a 00 |n...|..d|..j..o..|
|00003fa0| 01 64 0f 00 7d 09 00 6e | 01 00 01 7c 09 00 64 0c |.d..}..n|...|..d.|
|00003fb0| 00 6a 02 00 6f 07 00 01 | 64 10 00 6e 04 00 01 64 |.j..o...|d..n...d|
|00003fc0| 11 00 7d 0a 00 7c 00 00 | 69 07 00 7c 08 00 83 01 |..}..|..|i..|....|
|00003fd0| 00 5c 02 00 7d 0b 00 7d | 0c 00 7c 07 00 6f 83 00 |.\..}..}|..|..o..|
|00003fe0| 01 7c 03 00 64 0b 00 6a | 02 00 6f 0a 00 01 64 12 |.|..d..j|..o...d.|
|00003ff0| 00 7d 0d 00 6e 07 00 01 | 64 11 00 7d 0d 00 64 13 |.}..n...|d..}..d.|
|00004000| 00 7c 0b 00 7c 09 00 7c | 0a 00 66 03 00 16 64 14 |.|..|..||..f...d.|
|00004010| 00 7c 0b 00 7c 0b 00 7c | 0a 00 66 03 00 16 64 15 |.|..|..||..f...d.|
|00004020| 00 7c 0c 00 7c 0d 00 66 | 02 00 16 64 16 00 7c 0c |.|..|..f|...d..|.|
|00004030| 00 7c 0c 00 66 02 00 16 | 64 17 00 7c 0c 00 7c 0c |.|..f...|d..|..|.|
|00004040| 00 66 02 00 16 64 18 00 | 69 08 00 64 19 00 7c 0c |.f...d..|i..d..|.|
|00004050| 00 64 1a 00 7c 0b 00 83 | 00 02 67 06 00 7d 0e 00 |.d..|...|..g..}..|
|00004060| 6e 33 00 01 64 1b 00 7c | 0b 00 7c 09 00 7c 0a 00 |n3..d..||..|..|..|
|00004070| 66 03 00 16 64 1c 00 7c | 0b 00 7c 0b 00 66 02 00 |f...d..||..|..f..|
|00004080| 16 64 1d 00 69 08 00 64 | 1a 00 7c 0b 00 83 00 01 |.d..i..d|..|.....|
|00004090| 67 03 00 7d 0e 00 64 1e | 00 69 09 00 7c 0e 00 83 |g..}..d.|.i..|...|
|000040a0| 01 00 7d 0f 00 7c 00 00 | 69 02 00 69 0a 00 7c 0f |..}..|..|i..i..|.|
|000040b0| 00 83 01 00 01 7c 00 00 | 69 02 00 69 0b 00 83 00 |.....|..|i..i....|
|000040c0| 00 01 7c 08 00 53 28 24 | 00 00 00 4e 73 1f 00 00 |..|..S($|...Ns...|
|000040d0| 00 25 72 20 69 73 20 6e | 6f 74 20 61 20 73 75 70 |.%r is n|ot a sup|
|000040e0| 70 6f 72 74 65 64 20 64 | 61 74 61 20 74 79 70 65 |ported d|ata type|
|000040f0| 52 0b 00 00 00 52 0a 00 | 00 00 52 0c 00 00 00 52 |R....R..|..R....R|
|00004100| 0e 00 00 00 52 0d 00 00 | 00 52 09 00 00 00 73 6d |....R...|.R....sm|
|00004110| 00 00 00 49 4e 53 45 52 | 54 20 49 4e 54 4f 20 63 |...INSER|T INTO c|
|00004120| 75 73 74 6f 6d 5f 63 6f | 6c 75 6d 6e 73 28 6c 61 |ustom_co|lumns(la|
|00004130| 62 65 6c 2c 6e 61 6d 65 | 2c 64 61 74 61 74 79 70 |bel,name|,datatyp|
|00004140| 65 2c 69 73 5f 6d 75 6c | 74 69 70 6c 65 2c 65 64 |e,is_mul|tiple,ed|
|00004150| 69 74 61 62 6c 65 2c 64 | 69 73 70 6c 61 79 2c 6e |itable,d|isplay,n|
|00004160| 6f 72 6d 61 6c 69 7a 65 | 64 29 56 41 4c 55 45 53 |ormalize|d)VALUES|
|00004170| 20 28 3f 2c 3f 2c 3f 2c | 3f 2c 3f 2c 3f 2c 3f 29 | (?,?,?,|?,?,?,?)|
|00004180| 52 08 00 00 00 74 03 00 | 00 00 49 4e 54 52 0f 00 |R....t..|..INTR..|
|00004190| 00 00 74 04 00 00 00 54 | 45 58 54 74 04 00 00 00 |..t....T|EXTt....|
|000041a0| 52 45 41 4c 74 09 00 00 | 00 74 69 6d 65 73 74 61 |REALt...|.timesta|
|000041b0| 6d 70 74 04 00 00 00 42 | 4f 4f 4c 73 0e 00 00 00 |mpt....B|OOLs....|
|000041c0| 43 4f 4c 4c 41 54 45 20 | 4e 4f 43 41 53 45 74 00 |COLLATE |NOCASEt.|
|000041d0| 00 00 00 73 0b 00 00 00 | 65 78 74 72 61 20 52 45 |...s....|extra RE|
|000041e0| 41 4c 2c 73 bc 00 00 00 | 20 20 20 20 20 20 20 20 |AL,s....| |
|000041f0| 20 20 20 20 20 20 20 20 | 43 52 45 41 54 45 20 54 | |CREATE T|
|00004200| 41 42 4c 45 20 25 73 28 | 0a 20 20 20 20 20 20 20 |ABLE %s(|. |
|00004210| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 69 64 20 | | id |
|00004220| 20 20 20 49 4e 54 45 47 | 45 52 20 50 52 49 4d 41 | INTEG|ER PRIMA|
|00004230| 52 59 20 4b 45 59 20 41 | 55 54 4f 49 4e 43 52 45 |RY KEY A|UTOINCRE|
|00004240| 4d 45 4e 54 2c 0a 20 20 | 20 20 20 20 20 20 20 20 |MENT,. | |
|00004250| 20 20 20 20 20 20 20 20 | 20 20 76 61 6c 75 65 20 | | value |
|00004260| 25 73 20 4e 4f 54 20 4e | 55 4c 4c 20 25 73 2c 0a |%s NOT N|ULL %s,.|
|00004270| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00004280| 20 20 20 20 55 4e 49 51 | 55 45 28 76 61 6c 75 65 | UNIQ|UE(value|
|00004290| 29 29 3b 0a 20 20 20 20 | 20 20 20 20 20 20 20 20 |));. | |
|000042a0| 20 20 20 20 73 25 00 00 | 00 43 52 45 41 54 45 20 | s%..|.CREATE |
|000042b0| 49 4e 44 45 58 20 25 73 | 5f 69 64 78 20 4f 4e 20 |INDEX %s|_idx ON |
|000042c0| 25 73 20 28 76 61 6c 75 | 65 20 25 73 29 3b 73 07 |%s (valu|e %s);s.|
|000042d0| 01 00 00 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |... | |
|000042e0| 20 20 20 43 52 45 41 54 | 45 20 54 41 42 4c 45 20 | CREAT|E TABLE |
|000042f0| 25 73 28 0a 20 20 20 20 | 20 20 20 20 20 20 20 20 |%s(. | |
|00004300| 20 20 20 20 20 20 20 20 | 69 64 20 49 4e 54 45 47 | |id INTEG|
|00004310| 45 52 20 50 52 49 4d 41 | 52 59 20 4b 45 59 20 41 |ER PRIMA|RY KEY A|
|00004320| 55 54 4f 49 4e 43 52 45 | 4d 45 4e 54 2c 0a 20 20 |UTOINCRE|MENT,. |
|00004330| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00004340| 20 20 62 6f 6f 6b 20 49 | 4e 54 45 47 45 52 20 4e | book I|NTEGER N|
|00004350| 4f 54 20 4e 55 4c 4c 2c | 0a 20 20 20 20 20 20 20 |OT NULL,|. |
|00004360| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 76 61 6c | | val|
|00004370| 75 65 20 49 4e 54 45 47 | 45 52 20 4e 4f 54 20 4e |ue INTEG|ER NOT N|
|00004380| 55 4c 4c 2c 0a 20 20 20 | 20 20 20 20 20 20 20 20 |ULL,. | |
|00004390| 20 20 20 20 20 20 20 20 | 20 25 73 0a 20 20 20 20 | | %s. |
|000043a0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|000043b0| 55 4e 49 51 55 45 28 62 | 6f 6f 6b 2c 20 76 61 6c |UNIQUE(b|ook, val|
|000043c0| 75 65 29 0a 20 20 20 20 | 20 20 20 20 20 20 20 20 |ue). | |
|000043d0| 20 20 20 20 20 20 20 20 | 29 3b 73 23 00 00 00 43 | |);s#...C|
|000043e0| 52 45 41 54 45 20 49 4e | 44 45 58 20 25 73 5f 61 |REATE IN|DEX %s_a|
|000043f0| 69 64 78 20 4f 4e 20 25 | 73 20 28 76 61 6c 75 65 |idx ON %|s (value|
|00004400| 29 3b 73 22 00 00 00 43 | 52 45 41 54 45 20 49 4e |);s"...C|REATE IN|
|00004410| 44 45 58 20 25 73 5f 62 | 69 64 78 20 4f 4e 20 25 |DEX %s_b|idx ON %|
|00004420| 73 20 28 62 6f 6f 6b 29 | 3b 73 69 0b 00 00 20 20 |s (book)|;si... |
|00004430| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 43 52 | | CR|
|00004440| 45 41 54 45 20 54 52 49 | 47 47 45 52 20 66 6b 63 |EATE TRI|GGER fkc|
|00004450| 5f 75 70 64 61 74 65 5f | 7b 6c 74 7d 5f 61 0a 20 |_update_|{lt}_a. |
|00004460| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00004470| 20 20 20 20 20 20 20 42 | 45 46 4f 52 45 20 55 50 | B|EFORE UP|
|00004480| 44 41 54 45 20 4f 46 20 | 62 6f 6f 6b 20 4f 4e 20 |DATE OF |book ON |
|00004490| 7b 6c 74 7d 0a 20 20 20 | 20 20 20 20 20 20 20 20 |{lt}. | |
|000044a0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 42 45 47 | | BEG|
|000044b0| 49 4e 0a 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |IN. | |
|000044c0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 53 | | S|
|000044d0| 45 4c 45 43 54 20 43 41 | 53 45 0a 20 20 20 20 20 |ELECT CA|SE. |
|000044e0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|000044f0| 20 20 20 20 20 20 20 20 | 20 20 20 57 48 45 4e 20 | | WHEN |
|00004500| 28 53 45 4c 45 43 54 20 | 69 64 20 66 72 6f 6d 20 |(SELECT |id from |
|00004510| 62 6f 6f 6b 73 20 57 48 | 45 52 45 20 69 64 3d 4e |books WH|ERE id=N|
|00004520| 45 57 2e 62 6f 6f 6b 29 | 20 49 53 20 4e 55 4c 4c |EW.book)| IS NULL|
|00004530| 0a 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |. | |
|00004540| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00004550| 20 54 48 45 4e 20 52 41 | 49 53 45 28 41 42 4f 52 | THEN RA|ISE(ABOR|
|00004560| 54 2c 20 27 46 6f 72 65 | 69 67 6e 20 6b 65 79 20 |T, 'Fore|ign key |
|00004570| 76 69 6f 6c 61 74 69 6f | 6e 3a 20 62 6f 6f 6b 20 |violatio|n: book |
|00004580| 6e 6f 74 20 69 6e 20 62 | 6f 6f 6b 73 27 29 0a 20 |not in b|ooks'). |
|00004590| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|000045a0| 20 20 20 20 20 20 20 20 | 20 20 20 45 4e 44 3b 0a | | END;.|
|000045b0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|000045c0| 20 20 20 20 20 20 20 20 | 45 4e 44 3b 0a 20 20 20 | |END;. |
|000045d0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 43 52 45 | | CRE|
|000045e0| 41 54 45 20 54 52 49 47 | 47 45 52 20 66 6b 63 5f |ATE TRIG|GER fkc_|
|000045f0| 75 70 64 61 74 65 5f 7b | 6c 74 7d 5f 62 0a 20 20 |update_{|lt}_b. |
|00004600| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00004610| 20 20 20 20 20 20 42 45 | 46 4f 52 45 20 55 50 44 | BE|FORE UPD|
|00004620| 41 54 45 20 4f 46 20 61 | 75 74 68 6f 72 20 4f 4e |ATE OF a|uthor ON|
|00004630| 20 7b 6c 74 7d 0a 20 20 | 20 20 20 20 20 20 20 20 | {lt}. | |
|00004640| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 42 45 | | BE|
|00004650| 47 49 4e 0a 20 20 20 20 | 20 20 20 20 20 20 20 20 |GIN. | |
|00004660| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00004670| 53 45 4c 45 43 54 20 43 | 41 53 45 0a 20 20 20 20 |SELECT C|ASE. |
|00004680| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00004690| 20 20 20 20 20 20 20 20 | 20 20 20 20 57 48 45 4e | | WHEN|
|000046a0| 20 28 53 45 4c 45 43 54 | 20 69 64 20 66 72 6f 6d | (SELECT| id from|
|000046b0| 20 7b 74 61 62 6c 65 7d | 20 57 48 45 52 45 20 69 | {table}| WHERE i|
|000046c0| 64 3d 4e 45 57 2e 76 61 | 6c 75 65 29 20 49 53 20 |d=NEW.va|lue) IS |
|000046d0| 4e 55 4c 4c 0a 20 20 20 | 20 20 20 20 20 20 20 20 |NULL. | |
|000046e0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|000046f0| 20 20 20 20 20 54 48 45 | 4e 20 52 41 49 53 45 28 | THE|N RAISE(|
|00004700| 41 42 4f 52 54 2c 20 27 | 46 6f 72 65 69 67 6e 20 |ABORT, '|Foreign |
|00004710| 6b 65 79 20 76 69 6f 6c | 61 74 69 6f 6e 3a 20 76 |key viol|ation: v|
|00004720| 61 6c 75 65 20 6e 6f 74 | 20 69 6e 20 7b 74 61 62 |alue not| in {tab|
|00004730| 6c 65 7d 27 29 0a 20 20 | 20 20 20 20 20 20 20 20 |le}'). | |
|00004740| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00004750| 20 20 45 4e 44 3b 0a 20 | 20 20 20 20 20 20 20 20 | END;. | |
|00004760| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 45 | | E|
|00004770| 4e 44 3b 0a 20 20 20 20 | 20 20 20 20 20 20 20 20 |ND;. | |
|00004780| 20 20 20 20 43 52 45 41 | 54 45 20 54 52 49 47 47 | CREA|TE TRIGG|
|00004790| 45 52 20 66 6b 63 5f 69 | 6e 73 65 72 74 5f 7b 6c |ER fkc_i|nsert_{l|
|000047a0| 74 7d 0a 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |t}. | |
|000047b0| 20 20 20 20 20 20 20 20 | 20 20 20 42 45 46 4f 52 | | BEFOR|
|000047c0| 45 20 49 4e 53 45 52 54 | 20 4f 4e 20 7b 6c 74 7d |E INSERT| ON {lt}|
|000047d0| 0a 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |. | |
|000047e0| 20 20 20 20 20 20 20 20 | 20 42 45 47 49 4e 0a 20 | | BEGIN. |
|000047f0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00004800| 20 20 20 20 20 20 20 20 | 20 20 20 53 45 4c 45 43 | | SELEC|
|00004810| 54 20 43 41 53 45 0a 20 | 20 20 20 20 20 20 20 20 |T CASE. | |
|00004820| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00004830| 20 20 20 20 20 20 20 57 | 48 45 4e 20 28 53 45 4c | W|HEN (SEL|
|00004840| 45 43 54 20 69 64 20 66 | 72 6f 6d 20 62 6f 6f 6b |ECT id f|rom book|
|00004850| 73 20 57 48 45 52 45 20 | 69 64 3d 4e 45 57 2e 62 |s WHERE |id=NEW.b|
|00004860| 6f 6f 6b 29 20 49 53 20 | 4e 55 4c 4c 0a 20 20 20 |ook) IS |NULL. |
|00004870| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00004880| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 54 48 45 | | THE|
|00004890| 4e 20 52 41 49 53 45 28 | 41 42 4f 52 54 2c 20 27 |N RAISE(|ABORT, '|
|000048a0| 46 6f 72 65 69 67 6e 20 | 6b 65 79 20 76 69 6f 6c |Foreign |key viol|
|000048b0| 61 74 69 6f 6e 3a 20 62 | 6f 6f 6b 20 6e 6f 74 20 |ation: b|ook not |
|000048c0| 69 6e 20 62 6f 6f 6b 73 | 27 29 0a 20 20 20 20 20 |in books|'). |
|000048d0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|000048e0| 20 20 20 20 20 20 20 20 | 20 20 20 57 48 45 4e 20 | | WHEN |
|000048f0| 28 53 45 4c 45 43 54 20 | 69 64 20 66 72 6f 6d 20 |(SELECT |id from |
|00004900| 7b 74 61 62 6c 65 7d 20 | 57 48 45 52 45 20 69 64 |{table} |WHERE id|
|00004910| 3d 4e 45 57 2e 76 61 6c | 75 65 29 20 49 53 20 4e |=NEW.val|ue) IS N|
|00004920| 55 4c 4c 0a 20 20 20 20 | 20 20 20 20 20 20 20 20 |ULL. | |
|00004930| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00004940| 20 20 20 20 54 48 45 4e | 20 52 41 49 53 45 28 41 | THEN| RAISE(A|
|00004950| 42 4f 52 54 2c 20 27 46 | 6f 72 65 69 67 6e 20 6b |BORT, 'F|oreign k|
|00004960| 65 79 20 76 69 6f 6c 61 | 74 69 6f 6e 3a 20 76 61 |ey viola|tion: va|
|00004970| 6c 75 65 20 6e 6f 74 20 | 69 6e 20 7b 74 61 62 6c |lue not |in {tabl|
|00004980| 65 7d 27 29 0a 20 20 20 | 20 20 20 20 20 20 20 20 |e}'). | |
|00004990| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|000049a0| 20 45 4e 44 3b 0a 20 20 | 20 20 20 20 20 20 20 20 | END;. | |
|000049b0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 45 4e | | EN|
|000049c0| 44 3b 0a 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |D;. | |
|000049d0| 20 20 20 43 52 45 41 54 | 45 20 54 52 49 47 47 45 | CREAT|E TRIGGE|
|000049e0| 52 20 66 6b 63 5f 64 65 | 6c 65 74 65 5f 7b 6c 74 |R fkc_de|lete_{lt|
|000049f0| 7d 0a 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |}. | |
|00004a00| 20 20 20 20 20 20 20 20 | 20 20 41 46 54 45 52 20 | | AFTER |
|00004a10| 44 45 4c 45 54 45 20 4f | 4e 20 7b 74 61 62 6c 65 |DELETE O|N {table|
|00004a20| 7d 0a 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |}. | |
|00004a30| 20 20 20 20 20 20 20 20 | 20 20 42 45 47 49 4e 0a | | BEGIN.|
|00004a40| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00004a50| 20 20 20 20 20 20 20 20 | 20 20 20 20 44 45 4c 45 | | DELE|
|00004a60| 54 45 20 46 52 4f 4d 20 | 7b 6c 74 7d 20 57 48 45 |TE FROM |{lt} WHE|
|00004a70| 52 45 20 76 61 6c 75 65 | 3d 4f 4c 44 2e 69 64 3b |RE value|=OLD.id;|
|00004a80| 0a 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |. | |
|00004a90| 20 20 20 20 20 20 20 20 | 20 45 4e 44 3b 0a 0a 20 | | END;.. |
|00004aa0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 43 | | C|
|00004ab0| 52 45 41 54 45 20 56 49 | 45 57 20 74 61 67 5f 62 |REATE VI|EW tag_b|
|00004ac0| 72 6f 77 73 65 72 5f 7b | 74 61 62 6c 65 7d 20 41 |rowser_{|table} A|
|00004ad0| 53 20 53 45 4c 45 43 54 | 0a 20 20 20 20 20 20 20 |S SELECT|. |
|00004ae0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 69 64 2c | | id,|
|00004af0| 0a 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |. | |
|00004b00| 20 20 20 20 20 76 61 6c | 75 65 2c 0a 20 20 20 20 | val|ue,. |
|00004b10| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00004b20| 28 53 45 4c 45 43 54 20 | 43 4f 55 4e 54 28 69 64 |(SELECT |COUNT(id|
|00004b30| 29 20 46 52 4f 4d 20 7b | 6c 74 7d 20 57 48 45 52 |) FROM {|lt} WHER|
|00004b40| 45 20 76 61 6c 75 65 3d | 7b 74 61 62 6c 65 7d 2e |E value=|{table}.|
|00004b50| 69 64 29 20 63 6f 75 6e | 74 2c 0a 20 20 20 20 20 |id) coun|t,. |
|00004b60| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 28 | | (|
|00004b70| 53 45 4c 45 43 54 20 41 | 56 47 28 72 2e 72 61 74 |SELECT A|VG(r.rat|
|00004b80| 69 6e 67 29 0a 20 20 20 | 20 20 20 20 20 20 20 20 |ing). | |
|00004b90| 20 20 20 20 20 20 20 20 | 20 20 46 52 4f 4d 20 7b | | FROM {|
|00004ba0| 6c 74 7d 2c 0a 20 20 20 | 20 20 20 20 20 20 20 20 |lt},. | |
|00004bb0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 62 | | b|
|00004bc0| 6f 6f 6b 73 5f 72 61 74 | 69 6e 67 73 5f 6c 69 6e |ooks_rat|ings_lin|
|00004bd0| 6b 20 61 73 20 62 6c 2c | 0a 20 20 20 20 20 20 20 |k as bl,|. |
|00004be0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00004bf0| 20 20 20 72 61 74 69 6e | 67 73 20 61 73 20 72 0a | ratin|gs as r.|
|00004c00| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00004c10| 20 20 20 20 20 57 48 45 | 52 45 20 7b 6c 74 7d 2e | WHE|RE {lt}.|
|00004c20| 76 61 6c 75 65 3d 7b 74 | 61 62 6c 65 7d 2e 69 64 |value={t|able}.id|
|00004c30| 20 61 6e 64 20 62 6c 2e | 62 6f 6f 6b 3d 7b 6c 74 | and bl.|book={lt|
|00004c40| 7d 2e 62 6f 6f 6b 20 61 | 6e 64 0a 20 20 20 20 20 |}.book a|nd. |
|00004c50| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00004c60| 20 20 20 20 20 20 72 2e | 69 64 20 3d 20 62 6c 2e | r.|id = bl.|
|00004c70| 72 61 74 69 6e 67 20 61 | 6e 64 20 72 2e 72 61 74 |rating a|nd r.rat|
|00004c80| 69 6e 67 20 3c 3e 20 30 | 29 20 61 76 67 5f 72 61 |ing <> 0|) avg_ra|
|00004c90| 74 69 6e 67 2c 0a 20 20 | 20 20 20 20 20 20 20 20 |ting,. | |
|00004ca0| 20 20 20 20 20 20 20 20 | 20 20 76 61 6c 75 65 20 | | value |
|00004cb0| 41 53 20 73 6f 72 74 0a | 20 20 20 20 20 20 20 20 |AS sort.| |
|00004cc0| 20 20 20 20 20 20 20 20 | 46 52 4f 4d 20 7b 74 61 | |FROM {ta|
|00004cd0| 62 6c 65 7d 3b 0a 0a 20 | 20 20 20 20 20 20 20 20 |ble};.. | |
|00004ce0| 20 20 20 20 20 20 20 43 | 52 45 41 54 45 20 56 49 | C|REATE VI|
|00004cf0| 45 57 20 74 61 67 5f 62 | 72 6f 77 73 65 72 5f 66 |EW tag_b|rowser_f|
|00004d00| 69 6c 74 65 72 65 64 5f | 7b 74 61 62 6c 65 7d 20 |iltered_|{table} |
|00004d10| 41 53 20 53 45 4c 45 43 | 54 0a 20 20 20 20 20 20 |AS SELEC|T. |
|00004d20| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 69 64 | | id|
|00004d30| 2c 0a 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |,. | |
|00004d40| 20 20 20 20 20 20 76 61 | 6c 75 65 2c 0a 20 20 20 | va|lue,. |
|00004d50| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00004d60| 20 28 53 45 4c 45 43 54 | 20 43 4f 55 4e 54 28 7b | (SELECT| COUNT({|
|00004d70| 6c 74 7d 2e 69 64 29 20 | 46 52 4f 4d 20 7b 6c 74 |lt}.id) |FROM {lt|
|00004d80| 7d 20 57 48 45 52 45 20 | 76 61 6c 75 65 3d 7b 74 |} WHERE |value={t|
|00004d90| 61 62 6c 65 7d 2e 69 64 | 20 41 4e 44 0a 20 20 20 |able}.id| AND. |
|00004da0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00004db0| 20 62 6f 6f 6b 73 5f 6c | 69 73 74 5f 66 69 6c 74 | books_l|ist_filt|
|00004dc0| 65 72 28 62 6f 6f 6b 29 | 29 20 63 6f 75 6e 74 2c |er(book)|) count,|
|00004dd0| 0a 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |. | |
|00004de0| 20 20 20 20 20 28 53 45 | 4c 45 43 54 20 41 56 47 | (SE|LECT AVG|
|00004df0| 28 72 2e 72 61 74 69 6e | 67 29 0a 20 20 20 20 20 |(r.ratin|g). |
|00004e00| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00004e10| 46 52 4f 4d 20 7b 6c 74 | 7d 2c 0a 20 20 20 20 20 |FROM {lt|},. |
|00004e20| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00004e30| 20 20 20 20 20 62 6f 6f | 6b 73 5f 72 61 74 69 6e | boo|ks_ratin|
|00004e40| 67 73 5f 6c 69 6e 6b 20 | 61 73 20 62 6c 2c 0a 20 |gs_link |as bl,. |
|00004e50| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00004e60| 20 20 20 20 20 20 20 20 | 20 72 61 74 69 6e 67 73 | | ratings|
|00004e70| 20 61 73 20 72 0a 20 20 | 20 20 20 20 20 20 20 20 | as r. | |
|00004e80| 20 20 20 20 20 20 20 20 | 20 20 20 57 48 45 52 45 | | WHERE|
|00004e90| 20 7b 6c 74 7d 2e 76 61 | 6c 75 65 3d 7b 74 61 62 | {lt}.va|lue={tab|
|00004ea0| 6c 65 7d 2e 69 64 20 41 | 4e 44 20 62 6c 2e 62 6f |le}.id A|ND bl.bo|
|00004eb0| 6f 6b 3d 7b 6c 74 7d 2e | 62 6f 6f 6b 20 41 4e 44 |ok={lt}.|book AND|
|00004ec0| 0a 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |. | |
|00004ed0| 20 20 20 20 20 20 20 20 | 20 20 20 20 72 2e 69 64 | | r.id|
|00004ee0| 20 3d 20 62 6c 2e 72 61 | 74 69 6e 67 20 41 4e 44 | = bl.ra|ting AND|
|00004ef0| 20 72 2e 72 61 74 69 6e | 67 20 3c 3e 20 30 20 41 | r.ratin|g <> 0 A|
|00004f00| 4e 44 0a 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |ND. | |
|00004f10| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 62 6f | | bo|
|00004f20| 6f 6b 73 5f 6c 69 73 74 | 5f 66 69 6c 74 65 72 28 |oks_list|_filter(|
|00004f30| 62 6c 2e 62 6f 6f 6b 29 | 29 20 61 76 67 5f 72 61 |bl.book)|) avg_ra|
|00004f40| 74 69 6e 67 2c 0a 20 20 | 20 20 20 20 20 20 20 20 |ting,. | |
|00004f50| 20 20 20 20 20 20 20 20 | 20 20 76 61 6c 75 65 20 | | value |
|00004f60| 41 53 20 73 6f 72 74 0a | 20 20 20 20 20 20 20 20 |AS sort.| |
|00004f70| 20 20 20 20 20 20 20 20 | 46 52 4f 4d 20 7b 74 61 | |FROM {ta|
|00004f80| 62 6c 65 7d 3b 0a 0a 20 | 20 20 20 20 20 20 20 20 |ble};.. | |
|00004f90| 20 20 20 20 20 20 20 52 | 1a 00 00 00 52 19 00 00 | R|....R...|
|00004fa0| 00 73 de 00 00 00 20 20 | 20 20 20 20 20 20 20 20 |.s.... | |
|00004fb0| 20 20 20 20 20 20 43 52 | 45 41 54 45 20 54 41 42 | CR|EATE TAB|
|00004fc0| 4c 45 20 25 73 28 0a 20 | 20 20 20 20 20 20 20 20 |LE %s(. | |
|00004fd0| 20 20 20 20 20 20 20 20 | 20 20 20 69 64 20 20 20 | | id |
|00004fe0| 20 49 4e 54 45 47 45 52 | 20 50 52 49 4d 41 52 59 | INTEGER| PRIMARY|
|00004ff0| 20 4b 45 59 20 41 55 54 | 4f 49 4e 43 52 45 4d 45 | KEY AUT|OINCREME|
|00005000| 4e 54 2c 0a 20 20 20 20 | 20 20 20 20 20 20 20 20 |NT,. | |
|00005010| 20 20 20 20 20 20 20 20 | 62 6f 6f 6b 20 20 49 4e | |book IN|
|00005020| 54 45 47 45 52 2c 0a 20 | 20 20 20 20 20 20 20 20 |TEGER,. | |
|00005030| 20 20 20 20 20 20 20 20 | 20 20 20 76 61 6c 75 65 | | value|
|00005040| 20 25 73 20 4e 4f 54 20 | 4e 55 4c 4c 20 25 73 2c | %s NOT |NULL %s,|
|00005050| 0a 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |. | |
|00005060| 20 20 20 20 20 55 4e 49 | 51 55 45 28 62 6f 6f 6b | UNI|QUE(book|
|00005070| 29 29 3b 0a 20 20 20 20 | 20 20 20 20 20 20 20 20 |));. | |
|00005080| 20 20 20 20 73 21 00 00 | 00 43 52 45 41 54 45 20 | s!..|.CREATE |
|00005090| 49 4e 44 45 58 20 25 73 | 5f 69 64 78 20 4f 4e 20 |INDEX %s|_idx ON |
|000050a0| 25 73 20 28 62 6f 6f 6b | 29 3b 73 4e 03 00 00 20 |%s (book|);sN... |
|000050b0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 43 | | C|
|000050c0| 52 45 41 54 45 20 54 52 | 49 47 47 45 52 20 66 6b |REATE TR|IGGER fk|
|000050d0| 63 5f 69 6e 73 65 72 74 | 5f 7b 74 61 62 6c 65 7d |c_insert|_{table}|
|000050e0| 0a 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |. | |
|000050f0| 20 20 20 20 20 20 20 20 | 20 42 45 46 4f 52 45 20 | | BEFORE |
|00005100| 49 4e 53 45 52 54 20 4f | 4e 20 7b 74 61 62 6c 65 |INSERT O|N {table|
|00005110| 7d 0a 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |}. | |
|00005120| 20 20 20 20 20 20 20 20 | 20 20 42 45 47 49 4e 0a | | BEGIN.|
|00005130| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00005140| 20 20 20 20 20 20 20 20 | 20 20 20 20 53 45 4c 45 | | SELE|
|00005150| 43 54 20 43 41 53 45 0a | 20 20 20 20 20 20 20 20 |CT CASE.| |
|00005160| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00005170| 20 20 20 20 20 20 20 20 | 57 48 45 4e 20 28 53 45 | |WHEN (SE|
|00005180| 4c 45 43 54 20 69 64 20 | 66 72 6f 6d 20 62 6f 6f |LECT id |from boo|
|00005190| 6b 73 20 57 48 45 52 45 | 20 69 64 3d 4e 45 57 2e |ks WHERE| id=NEW.|
|000051a0| 62 6f 6f 6b 29 20 49 53 | 20 4e 55 4c 4c 0a 20 20 |book) IS| NULL. |
|000051b0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|000051c0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 54 48 | | TH|
|000051d0| 45 4e 20 52 41 49 53 45 | 28 41 42 4f 52 54 2c 20 |EN RAISE|(ABORT, |
|000051e0| 27 46 6f 72 65 69 67 6e | 20 6b 65 79 20 76 69 6f |'Foreign| key vio|
|000051f0| 6c 61 74 69 6f 6e 3a 20 | 62 6f 6f 6b 20 6e 6f 74 |lation: |book not|
|00005200| 20 69 6e 20 62 6f 6f 6b | 73 27 29 0a 20 20 20 20 | in book|s'). |
|00005210| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00005220| 20 20 20 20 20 20 20 20 | 45 4e 44 3b 0a 20 20 20 | |END;. |
|00005230| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00005240| 20 20 20 20 20 45 4e 44 | 3b 0a 20 20 20 20 20 20 | END|;. |
|00005250| 20 20 20 20 20 20 20 20 | 20 20 43 52 45 41 54 45 | | CREATE|
|00005260| 20 54 52 49 47 47 45 52 | 20 66 6b 63 5f 75 70 64 | TRIGGER| fkc_upd|
|00005270| 61 74 65 5f 7b 74 61 62 | 6c 65 7d 0a 20 20 20 20 |ate_{tab|le}. |
|00005280| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00005290| 20 20 20 20 42 45 46 4f | 52 45 20 55 50 44 41 54 | BEFO|RE UPDAT|
|000052a0| 45 20 4f 46 20 62 6f 6f | 6b 20 4f 4e 20 7b 74 61 |E OF boo|k ON {ta|
|000052b0| 62 6c 65 7d 0a 20 20 20 | 20 20 20 20 20 20 20 20 |ble}. | |
|000052c0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 42 45 47 | | BEG|
|000052d0| 49 4e 0a 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |IN. | |
|000052e0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 53 | | S|
|000052f0| 45 4c 45 43 54 20 43 41 | 53 45 0a 20 20 20 20 20 |ELECT CA|SE. |
|00005300| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00005310| 20 20 20 20 20 20 20 20 | 20 20 20 57 48 45 4e 20 | | WHEN |
|00005320| 28 53 45 4c 45 43 54 20 | 69 64 20 66 72 6f 6d 20 |(SELECT |id from |
|00005330| 62 6f 6f 6b 73 20 57 48 | 45 52 45 20 69 64 3d 4e |books WH|ERE id=N|
|00005340| 45 57 2e 62 6f 6f 6b 29 | 20 49 53 20 4e 55 4c 4c |EW.book)| IS NULL|
|00005350| 0a 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 20 20 20 20 | | |
|00005370| 20 54 48 45 4e 20 52 41 | 49 53 45 28 41 42 4f 52 | THEN RA|ISE(ABOR|
|00005380| 54 2c 20 27 46 6f 72 65 | 69 67 6e 20 6b 65 79 20 |T, 'Fore|ign key |
|00005390| 76 69 6f 6c 61 74 69 6f | 6e 3a 20 62 6f 6f 6b 20 |violatio|n: book |
|000053a0| 6e 6f 74 20 69 6e 20 62 | 6f 6f 6b 73 27 29 0a 20 |not in b|ooks'). |
|000053b0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|000053c0| 20 20 20 20 20 20 20 20 | 20 20 20 45 4e 44 3b 0a | | END;.|
|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 | 45 4e 44 3b 0a 20 20 20 | |END;. |
|000053f0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 73 02 00 | | s..|
|00005400| 00 00 20 0a 28 05 00 00 | 00 73 08 00 00 00 64 61 |.. .(...|.s....da|
|00005410| 74 65 74 69 6d 65 73 08 | 00 00 00 63 6f 6d 6d 65 |tetimes.|...comme|
|00005420| 6e 74 73 73 03 00 00 00 | 69 6e 74 73 04 00 00 00 |ntss....|ints....|
|00005430| 62 6f 6f 6c 73 05 00 00 | 00 66 6c 6f 61 74 28 01 |bools...|.float(.|
|00005440| 00 00 00 73 04 00 00 00 | 74 65 78 74 28 02 00 00 |...s....|text(...|
|00005450| 00 73 06 00 00 00 72 61 | 74 69 6e 67 73 03 00 00 |.s....ra|tings...|
|00005460| 00 69 6e 74 28 03 00 00 | 00 73 04 00 00 00 74 65 |.int(...|.s....te|
|00005470| 78 74 73 08 00 00 00 63 | 6f 6d 6d 65 6e 74 73 73 |xts....c|ommentss|
|00005480| 06 00 00 00 73 65 72 69 | 65 73 28 01 00 00 00 73 |....seri|es(....s|
|00005490| 05 00 00 00 66 6c 6f 61 | 74 28 0c 00 00 00 52 41 |....floa|t(....RA|
|000054a0| 00 00 00 52 43 00 00 00 | 52 14 00 00 00 52 46 00 |...RC...|R....RF.|
|000054b0| 00 00 52 4a 00 00 00 52 | 79 00 00 00 52 81 00 00 |..RJ...R|y...R...|
|000054c0| 00 52 12 00 00 00 52 45 | 00 00 00 52 2c 00 00 00 |.R....RE|...R,...|
|000054d0| 52 44 00 00 00 52 47 00 | 00 00 28 10 00 00 00 52 |RD...RG.|..(....R|
|000054e0| 10 00 00 00 52 1b 00 00 | 00 52 1c 00 00 00 52 1d |....R...|.R....R.|
|000054f0| 00 00 00 52 21 00 00 00 | 52 1e 00 00 00 52 1f 00 |...R!...|R....R..|
|00005500| 00 00 52 20 00 00 00 52 | 11 00 00 00 74 02 00 00 |..R ...R|....t...|
|00005510| 00 64 74 74 07 00 00 00 | 63 6f 6c 6c 61 74 65 52 |.dtt....|collateR|
|00005520| 19 00 00 00 52 1a 00 00 | 00 74 07 00 00 00 73 5f |....R...|.t....s_|
|00005530| 69 6e 64 65 78 52 94 00 | 00 00 74 06 00 00 00 73 |indexR..|..t....s|
|00005540| 63 72 69 70 74 28 00 00 | 00 00 28 00 00 00 00 73 |cript(..|..(....s|
|00005550| 2f 00 00 00 73 69 74 65 | 2d 70 61 63 6b 61 67 65 |/...site|-package|
|00005560| 73 5c 63 61 6c 69 62 72 | 65 5c 6c 69 62 72 61 72 |s\calibr|e\librar|
|00005570| 79 5c 63 75 73 74 6f 6d | 5f 63 6f 6c 75 6d 6e 73 |y\custom|_columns|
|00005580| 2e 70 79 74 14 00 00 00 | 63 72 65 61 74 65 5f 63 |.pyt....|create_c|
|00005590| 75 73 74 6f 6d 5f 63 6f | 6c 75 6d 6e af 01 00 00 |ustom_co|lumn....|
|000055a0| 73 4c 00 00 00 00 02 10 | 01 14 01 03 01 09 01 13 |sL......|........|
|000055b0| 01 09 01 03 03 0f 01 1b | 02 0d 01 0a 01 0d 01 0a |........|........|
|000055c0| 01 0d 01 0a 01 0d 01 0a | 01 0d 01 0a 01 1a 01 15 |........|........|
|000055d0| 01 07 01 0d 01 0a 02 06 | 07 10 02 10 09 0d 02 0d |........|........|
|000055e0| 01 0d 3f 1f 0b 10 02 0d | 13 15 02 0f 01 10 01 0d |..?.....|........|
|000055f0| 01 4e 28 18 00 00 00 74 | 08 00 00 00 5f 5f 6e 61 |.N(....t|....__na|
|00005600| 6d 65 5f 5f 74 0a 00 00 | 00 5f 5f 6d 6f 64 75 6c |me__t...|.__modul|
|00005610| 65 5f 5f 74 09 00 00 00 | 66 72 6f 7a 65 6e 73 65 |e__t....|frozense|
|00005620| 74 52 41 00 00 00 52 12 | 00 00 00 74 08 00 00 00 |tRA...R.|...t....|
|00005630| 70 72 6f 70 65 72 74 79 | 52 18 00 00 00 52 5c 00 |property|R....R\.|
|00005640| 00 00 52 24 00 00 00 52 | 34 00 00 00 52 67 00 00 |..R$...R|4...Rg..|
|00005650| 00 52 6b 00 00 00 52 6c | 00 00 00 52 72 00 00 00 |.Rk...Rl|...Rr...|
|00005660| 52 73 00 00 00 52 76 00 | 00 00 52 77 00 00 00 52 |Rs...Rv.|..Rw...R|
|00005670| 78 00 00 00 52 7b 00 00 | 00 52 50 00 00 00 52 8e |x...R{..|.RP...R.|
|00005680| 00 00 00 52 92 00 00 00 | 52 96 00 00 00 52 a1 00 |...R....|R....R..|
|00005690| 00 00 28 00 00 00 00 28 | 00 00 00 00 28 00 00 00 |..(....(|....(...|
|000056a0| 00 73 2f 00 00 00 73 69 | 74 65 2d 70 61 63 6b 61 |.s/...si|te-packa|
|000056b0| 67 65 73 5c 63 61 6c 69 | 62 72 65 5c 6c 69 62 72 |ges\cali|bre\libr|
|000056c0| 61 72 79 5c 63 75 73 74 | 6f 6d 5f 63 6f 6c 75 6d |ary\cust|om_colum|
|000056d0| 6e 73 2e 70 79 52 07 00 | 00 00 12 00 00 00 73 28 |ns.pyR..|......s(|
|000056e0| 00 00 00 06 02 0f 01 15 | 02 09 03 0f 07 09 87 12 |........|........|
|000056f0| 0d 12 0e 0f 0b 0f 19 0f | 0c 0f 16 0f 0d 0f 0d 06 |........|........|
|00005700| 01 0f 18 06 01 12 4d 09 | 0c 09 1a 28 14 00 00 00 |......M.|...(....|
|00005710| 74 0a 00 00 00 5f 5f 66 | 75 74 75 72 65 5f 5f 52 |t....__f|uture__R|
|00005720| 00 00 00 00 74 0b 00 00 | 00 5f 5f 6c 69 63 65 6e |....t...|.__licen|
|00005730| 73 65 5f 5f 74 0d 00 00 | 00 5f 5f 63 6f 70 79 72 |se__t...|.__copyr|
|00005740| 69 67 68 74 5f 5f 74 0d | 00 00 00 5f 5f 64 6f 63 |ight__t.|...__doc|
|00005750| 66 6f 72 6d 61 74 5f 5f | 52 4a 00 00 00 74 09 00 |format__|RJ...t..|
|00005760| 00 00 66 75 6e 63 74 6f | 6f 6c 73 52 01 00 00 00 |..functo|olsR....|
|00005770| 74 04 00 00 00 6d 61 74 | 68 52 02 00 00 00 74 07 |t....mat|hR....t.|
|00005780| 00 00 00 63 61 6c 69 62 | 72 65 52 03 00 00 00 74 |...calib|reR....t|
|00005790| 11 00 00 00 63 61 6c 69 | 62 72 65 2e 63 6f 6e 73 |....cali|bre.cons|
|000057a0| 74 61 6e 74 73 52 04 00 | 00 00 74 1e 00 00 00 63 |tantsR..|..t....c|
|000057b0| 61 6c 69 62 72 65 2e 6c | 69 62 72 61 72 79 2e 66 |alibre.l|ibrary.f|
|000057c0| 69 65 6c 64 5f 6d 65 74 | 61 64 61 74 61 52 05 00 |ield_met|adataR..|
|000057d0| 00 00 74 12 00 00 00 63 | 61 6c 69 62 72 65 2e 75 |..t....c|alibre.u|
|000057e0| 74 69 6c 73 2e 64 61 74 | 65 52 06 00 00 00 74 06 |tils.dat|eR....t.|
|000057f0| 00 00 00 6f 62 6a 65 63 | 74 52 07 00 00 00 28 00 |...objec|tR....(.|
|00005800| 00 00 00 28 00 00 00 00 | 28 00 00 00 00 73 2f 00 |...(....|(....s/.|
|00005810| 00 00 73 69 74 65 2d 70 | 61 63 6b 61 67 65 73 5c |..site-p|ackages\|
|00005820| 63 61 6c 69 62 72 65 5c | 6c 69 62 72 61 72 79 5c |calibre\|library\|
|00005830| 63 75 73 74 6f 6d 5f 63 | 6f 6c 75 6d 6e 73 2e 70 |custom_c|olumns.p|
|00005840| 79 74 08 00 00 00 3c 6d | 6f 64 75 6c 65 3e 03 00 |yt....<m|odule>..|
|00005850| 00 00 73 16 00 00 00 10 | 02 06 01 06 01 06 02 0c |..s.....|........|
|00005860| 01 10 01 10 02 10 01 10 | 01 10 01 10 02 |........|..... |
+--------+-------------------------+-------------------------+--------+--------+
