home *** CD-ROM | disk | FTP | other *** search
| Unknown | 2010-10-31 | 64.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.
hex view+--------+-------------------------+-------------------------+--------+--------+
|00000000| d1 f2 0d 0a 27 f5 a4 4c | 63 00 00 00 00 00 00 00 |....'..L|c.......|
|00000010| 00 0b 00 00 00 40 00 00 | 00 73 19 01 00 00 64 00 |.....@..|.s....d.|
|00000020| 00 5a 00 00 64 01 00 5a | 01 00 64 02 00 64 03 00 |.Z..d..Z|..d..d..|
|00000030| 6b 02 00 5a 03 00 64 02 | 00 64 03 00 6b 04 00 5a |k..Z..d.|.d..k..Z|
|00000040| 04 00 64 02 00 64 03 00 | 6b 05 00 5a 05 00 64 02 |..d..d..|k..Z..d.|
|00000050| 00 64 03 00 6b 06 00 5a | 06 00 64 02 00 64 03 00 |.d..k..Z|..d..d..|
|00000060| 6b 07 00 5a 07 00 64 02 | 00 64 04 00 6b 08 00 6c |k..Z..d.|.d..k..l|
|00000070| 09 00 5a 09 00 6c 0a 00 | 5a 0a 00 01 64 02 00 64 |..Z..l..|Z...d..d|
|00000080| 05 00 6b 0b 00 6c 0c 00 | 5a 0c 00 01 64 02 00 64 |..k..l..|Z...d..d|
|00000090| 06 00 6b 0b 00 6c 0d 00 | 5a 0d 00 01 64 07 00 65 |..k..l..|Z...d..e|
|000000a0| 0e 00 66 01 00 64 08 00 | 84 00 00 83 00 00 59 5a |..f..d..|......YZ|
|000000b0| 0f 00 64 09 00 65 03 00 | 69 10 00 66 01 00 64 0a |..d..e..|i..f..d.|
|000000c0| 00 84 00 00 83 00 00 59 | 5a 10 00 64 0b 00 84 00 |.......Y|Z..d....|
|000000d0| 00 5a 11 00 64 0c 00 65 | 0e 00 66 01 00 64 0d 00 |.Z..d..e|..f..d..|
|000000e0| 84 00 00 83 00 00 59 5a | 12 00 64 0e 00 65 0e 00 |......YZ|..d..e..|
|000000f0| 66 01 00 64 0f 00 84 00 | 00 83 00 00 59 5a 13 00 |f..d....|....YZ..|
|00000100| 64 10 00 84 00 00 5a 14 | 00 65 15 00 64 11 00 6a |d.....Z.|.e..d..j|
|00000110| 02 00 6f 1d 00 01 65 03 | 00 69 16 00 65 17 00 83 |..o...e.|.i..e...|
|00000120| 01 00 01 65 12 00 64 12 | 00 83 01 00 5a 18 00 6e |...e..d.|....Z..n|
|00000130| 01 00 01 64 03 00 53 28 | 13 00 00 00 73 06 00 00 |...d..S(|....s...|
|00000140| 00 47 50 4c 20 76 33 73 | 2b 00 00 00 32 30 30 38 |.GPL v3s|+...2008|
|00000150| 2c 20 4b 6f 76 69 64 20 | 47 6f 79 61 6c 20 3c 6b |, Kovid |Goyal <k|
|00000160| 6f 76 69 64 20 61 74 20 | 6b 6f 76 69 64 67 6f 79 |ovid at |kovidgoy|
|00000170| 61 6c 2e 6e 65 74 3e 69 | ff ff ff ff 4e 28 02 00 |al.net>i|....N(..|
|00000180| 00 00 74 08 00 00 00 63 | 6f 6d 70 72 65 73 73 74 |..t....c|ompresst|
|00000190| 0a 00 00 00 64 65 63 6f | 6d 70 72 65 73 73 28 01 |....deco|mpress(.|
|000001a0| 00 00 00 74 0f 00 00 00 | 4d 65 74 61 49 6e 66 6f |...t....|MetaInfo|
|000001b0| 72 6d 61 74 69 6f 6e 28 | 01 00 00 00 74 11 00 00 |rmation(|....t...|
|000001c0| 00 73 74 72 69 6e 67 5f | 74 6f 5f 61 75 74 68 6f |.string_|to_autho|
|000001d0| 72 73 74 0b 00 00 00 43 | 6f 6e 63 61 74 65 6e 61 |rst....C|oncatena|
|000001e0| 74 65 63 00 00 00 00 00 | 00 00 00 02 00 00 00 42 |tec.....|.......B|
|000001f0| 00 00 00 73 26 00 00 00 | 65 00 00 5a 01 00 64 00 |...s&...|e..Z..d.|
|00000200| 00 64 01 00 84 01 00 5a | 02 00 64 02 00 84 00 00 |.d.....Z|..d.....|
|00000210| 5a 03 00 64 03 00 84 00 | 00 5a 04 00 52 53 28 04 |Z..d....|.Z..RS(.|
|00000220| 00 00 00 74 01 00 00 00 | 2c 63 02 00 00 00 02 00 |...t....|,c......|
|00000230| 00 00 02 00 00 00 43 00 | 00 00 73 16 00 00 00 7c |......C.|..s....||
|00000240| 01 00 7c 00 00 5f 00 00 | 64 01 00 7c 00 00 5f 01 |..|.._..|d..|.._.|
|00000250| 00 64 00 00 53 28 02 00 | 00 00 4e 74 00 00 00 00 |.d..S(..|..Nt....|
|00000260| 28 02 00 00 00 74 03 00 | 00 00 73 65 70 74 03 00 |(....t..|..sept..|
|00000270| 00 00 61 6e 73 28 02 00 | 00 00 74 04 00 00 00 73 |..ans(..|..t....s|
|00000280| 65 6c 66 52 07 00 00 00 | 28 00 00 00 00 28 00 00 |elfR....|(....(..|
|00000290| 00 00 73 29 00 00 00 73 | 69 74 65 2d 70 61 63 6b |..s)...s|ite-pack|
|000002a0| 61 67 65 73 5c 63 61 6c | 69 62 72 65 5c 6c 69 62 |ages\cal|ibre\lib|
|000002b0| 72 61 72 79 5c 64 61 74 | 61 62 61 73 65 2e 70 79 |rary\dat|abase.py|
|000002c0| 74 08 00 00 00 5f 5f 69 | 6e 69 74 5f 5f 0f 00 00 |t....__i|nit__...|
|000002d0| 00 73 04 00 00 00 00 01 | 09 01 63 02 00 00 00 02 |.s......|..c.....|
|000002e0| 00 00 00 04 00 00 00 43 | 00 00 00 73 2b 00 00 00 |.......C|...s+...|
|000002f0| 7c 01 00 64 00 00 6a 09 | 00 6f 1a 00 01 7c 00 00 ||..d..j.|.o...|..|
|00000300| 04 69 01 00 7c 01 00 7c | 00 00 69 02 00 17 37 02 |.i..|..||..i...7.|
|00000310| 5f 01 00 6e 01 00 01 64 | 00 00 53 28 01 00 00 00 |_..n...d|..S(....|
|00000320| 4e 28 03 00 00 00 74 04 | 00 00 00 4e 6f 6e 65 52 |N(....t.|...NoneR|
|00000330| 08 00 00 00 52 07 00 00 | 00 28 02 00 00 00 52 09 |....R...|.(....R.|
|00000340| 00 00 00 74 05 00 00 00 | 76 61 6c 75 65 28 00 00 |...t....|value(..|
|00000350| 00 00 28 00 00 00 00 73 | 29 00 00 00 73 69 74 65 |..(....s|)...site|
|00000360| 2d 70 61 63 6b 61 67 65 | 73 5c 63 61 6c 69 62 72 |-package|s\calibr|
|00000370| 65 5c 6c 69 62 72 61 72 | 79 5c 64 61 74 61 62 61 |e\librar|y\databa|
|00000380| 73 65 2e 70 79 74 04 00 | 00 00 73 74 65 70 13 00 |se.pyt..|..step..|
|00000390| 00 00 73 04 00 00 00 00 | 01 0d 01 63 01 00 00 00 |..s.....|...c....|
|000003a0| 01 00 00 00 03 00 00 00 | 43 00 00 00 73 36 00 00 |........|C...s6..|
|000003b0| 00 7c 00 00 69 00 00 70 | 05 00 01 64 00 00 53 01 |.|..i..p|...d..S.|
|000003c0| 7c 00 00 69 02 00 6f 16 | 00 01 7c 00 00 69 00 00 ||..i..o.|..|..i..|
|000003d0| 74 03 00 7c 00 00 69 02 | 00 83 01 00 0b 20 53 01 |t..|..i.|..... S.|
|000003e0| 7c 00 00 69 00 00 53 28 | 01 00 00 00 4e 28 04 00 ||..i..S(|....N(..|
|000003f0| 00 00 52 08 00 00 00 52 | 0b 00 00 00 52 07 00 00 |..R....R|....R...|
|00000400| 00 74 03 00 00 00 6c 65 | 6e 28 01 00 00 00 52 09 |.t....le|n(....R.|
|00000410| 00 00 00 28 00 00 00 00 | 28 00 00 00 00 73 29 00 |...(....|(....s).|
|00000420| 00 00 73 69 74 65 2d 70 | 61 63 6b 61 67 65 73 5c |..site-p|ackages\|
|00000430| 63 61 6c 69 62 72 65 5c | 6c 69 62 72 61 72 79 5c |calibre\|library\|
|00000440| 64 61 74 61 62 61 73 65 | 2e 70 79 74 08 00 00 00 |database|.pyt....|
|00000450| 66 69 6e 61 6c 69 7a 65 | 17 00 00 00 73 0a 00 00 |finalize|....s...|
|00000460| 00 00 01 0a 01 05 01 0a | 01 16 01 28 05 00 00 00 |........|...(....|
|00000470| 74 08 00 00 00 5f 5f 6e | 61 6d 65 5f 5f 74 0a 00 |t....__n|ame__t..|
|00000480| 00 00 5f 5f 6d 6f 64 75 | 6c 65 5f 5f 52 0a 00 00 |..__modu|le__R...|
|00000490| 00 52 0d 00 00 00 52 0f | 00 00 00 28 00 00 00 00 |.R....R.|...(....|
|000004a0| 28 00 00 00 00 28 00 00 | 00 00 73 29 00 00 00 73 |(....(..|..s)...s|
|000004b0| 69 74 65 2d 70 61 63 6b | 61 67 65 73 5c 63 61 6c |ite-pack|ages\cal|
|000004c0| 69 62 72 65 5c 6c 69 62 | 72 61 72 79 5c 64 61 74 |ibre\lib|rary\dat|
|000004d0| 61 62 61 73 65 2e 70 79 | 52 04 00 00 00 0d 00 00 |abase.py|R.......|
|000004e0| 00 73 06 00 00 00 06 02 | 0c 04 09 04 74 0a 00 00 |.s......|....t...|
|000004f0| 00 43 6f 6e 6e 65 63 74 | 69 6f 6e 63 00 00 00 00 |.Connect|ionc....|
|00000500| 00 00 00 00 01 00 00 00 | 42 00 00 00 73 11 00 00 |........|B...s...|
|00000510| 00 65 00 00 5a 01 00 64 | 00 00 84 00 00 5a 02 00 |.e..Z..d|.....Z..|
|00000520| 52 53 28 01 00 00 00 63 | 01 00 00 00 04 00 00 00 |RS(....c|........|
|00000530| 03 00 00 00 4f 00 00 00 | 73 55 00 00 00 7c 00 00 |....O...|sU...|..|
|00000540| 69 00 00 7c 01 00 8c 00 | 00 7d 03 00 7c 02 00 69 |i..|....|.}..|..i|
|00000550| 01 00 64 01 00 74 02 00 | 83 02 00 70 29 00 01 7c |..d..t..|...p)..||
|00000560| 03 00 69 03 00 83 00 00 | 7d 03 00 7c 03 00 70 0d |..i.....|}..|..p.|
|00000570| 00 01 64 00 00 67 01 00 | 7d 03 00 6e 01 00 01 7c |..d..g..|}..n...||
|00000580| 03 00 64 02 00 19 53 01 | 7c 03 00 69 05 00 83 00 |..d...S.||..i....|
|00000590| 00 53 28 03 00 00 00 4e | 74 03 00 00 00 61 6c 6c |.S(....N|t....all|
|000005a0| 69 00 00 00 00 28 06 00 | 00 00 74 07 00 00 00 65 |i....(..|..t....e|
|000005b0| 78 65 63 75 74 65 74 03 | 00 00 00 67 65 74 74 04 |xecutet.|...gett.|
|000005c0| 00 00 00 54 72 75 65 74 | 08 00 00 00 66 65 74 63 |...Truet|....fetc|
|000005d0| 68 6f 6e 65 52 0b 00 00 | 00 74 08 00 00 00 66 65 |honeR...|.t....fe|
|000005e0| 74 63 68 61 6c 6c 28 04 | 00 00 00 52 09 00 00 00 |tchall(.|...R....|
|000005f0| 74 04 00 00 00 61 72 67 | 73 74 02 00 00 00 6b 77 |t....arg|st....kw|
|00000600| 52 08 00 00 00 28 00 00 | 00 00 28 00 00 00 00 73 |R....(..|..(....s|
|00000610| 29 00 00 00 73 69 74 65 | 2d 70 61 63 6b 61 67 65 |)...site|-package|
|00000620| 73 5c 63 61 6c 69 62 72 | 65 5c 6c 69 62 72 61 72 |s\calibr|e\librar|
|00000630| 79 5c 64 61 74 61 62 61 | 73 65 2e 70 79 52 15 00 |y\databa|se.pyR..|
|00000640| 00 00 1f 00 00 00 73 0e | 00 00 00 00 01 0f 01 13 |......s.|........|
|00000650| 01 0c 01 07 01 0d 01 09 | 01 28 03 00 00 00 52 10 |........|.(....R.|
|00000660| 00 00 00 52 11 00 00 00 | 52 15 00 00 00 28 00 00 |...R....|R....(..|
|00000670| 00 00 28 00 00 00 00 28 | 00 00 00 00 73 29 00 00 |..(....(|....s)..|
|00000680| 00 73 69 74 65 2d 70 61 | 63 6b 61 67 65 73 5c 63 |.site-pa|ckages\c|
|00000690| 61 6c 69 62 72 65 5c 6c | 69 62 72 61 72 79 5c 64 |alibre\l|ibrary\d|
|000006a0| 61 74 61 62 61 73 65 2e | 70 79 52 12 00 00 00 1d |atabase.|pyR.....|
|000006b0| 00 00 00 73 02 00 00 00 | 06 02 63 01 00 00 00 03 |...s....|..c.....|
|000006c0| 00 00 00 07 00 00 00 03 | 00 00 00 73 a2 00 00 00 |........|...s....|
|000006d0| 74 00 00 7c 00 00 74 01 | 00 83 02 00 6f 13 00 01 |t..|..t.|....o...|
|000006e0| 7c 00 00 69 02 00 64 01 | 00 83 01 00 7d 00 00 6e ||..i..d.|....}..n|
|000006f0| 01 00 01 74 03 00 69 04 | 00 7c 00 00 64 02 00 74 |...t..i.|.|..d..t|
|00000700| 05 00 64 03 00 74 03 00 | 69 06 00 74 03 00 69 07 |..d..t..|i..t..i.|
|00000710| 00 42 83 01 02 7d 01 00 | 64 04 00 84 00 00 7c 01 |.B...}..|d.....|.|
|00000720| 00 5f 08 00 7c 01 00 69 | 09 00 64 05 00 64 06 00 |._..|..i|..d..d..|
|00000730| 74 0a 00 83 03 00 01 74 | 0b 00 69 0c 00 64 07 00 |t......t|..i..d..|
|00000740| 74 0b 00 69 0d 00 83 02 | 00 89 00 00 87 00 00 66 |t..i....|.......f|
|00000750| 01 00 64 08 00 86 00 00 | 7d 02 00 7c 01 00 69 0e |..d.....|}..|..i.|
|00000760| 00 64 09 00 64 06 00 7c | 02 00 83 03 00 01 7c 01 |.d..d..||......|.|
|00000770| 00 53 28 0a 00 00 00 4e | 73 05 00 00 00 75 74 66 |.S(....N|s....utf|
|00000780| 2d 38 74 07 00 00 00 66 | 61 63 74 6f 72 79 74 0c |-8t....f|actoryt.|
|00000790| 00 00 00 64 65 74 65 63 | 74 5f 74 79 70 65 73 63 |...detec|t_typesc|
|000007a0| 02 00 00 00 02 00 00 00 | 02 00 00 00 53 00 00 00 |........|....S...|
|000007b0| 73 0a 00 00 00 74 00 00 | 7c 01 00 83 01 00 53 28 |s....t..||.....S(|
|000007c0| 00 00 00 00 28 01 00 00 | 00 74 04 00 00 00 6c 69 |....(...|.t....li|
|000007d0| 73 74 28 02 00 00 00 74 | 06 00 00 00 63 75 72 73 |st(....t|....curs|
|000007e0| 6f 72 74 03 00 00 00 72 | 6f 77 28 00 00 00 00 28 |ort....r|ow(....(|
|000007f0| 00 00 00 00 73 29 00 00 | 00 73 69 74 65 2d 70 61 |....s)..|.site-pa|
|00000800| 63 6b 61 67 65 73 5c 63 | 61 6c 69 62 72 65 5c 6c |ckages\c|alibre\l|
|00000810| 69 62 72 61 72 79 5c 64 | 61 74 61 62 61 73 65 2e |ibrary\d|atabase.|
|00000820| 70 79 74 08 00 00 00 3c | 6c 61 6d 62 64 61 3e 2c |pyt....<|lambda>,|
|00000830| 00 00 00 73 00 00 00 00 | 74 06 00 00 00 63 6f 6e |...s....|t....con|
|00000840| 63 61 74 69 01 00 00 00 | 73 0e 00 00 00 5e 28 41 |cati....|s....^(A|
|00000850| 7c 54 68 65 7c 41 6e 29 | 5c 73 2b 63 01 00 00 00 ||The|An)|\s+c....|
|00000860| 03 00 00 00 03 00 00 00 | 13 00 00 00 73 4d 00 00 |........|....sM..|
|00000870| 00 88 00 00 69 00 00 7c | 00 00 83 01 00 7d 01 00 |....i..||.....}..|
|00000880| 7c 01 00 6f 2d 00 01 7c | 01 00 69 01 00 64 01 00 ||..o-..||..i..d..|
|00000890| 83 01 00 7d 02 00 7c 00 | 00 69 02 00 7c 02 00 64 |...}..|.|.i..|..d|
|000008a0| 02 00 83 02 00 64 03 00 | 17 7c 02 00 17 7d 00 00 |.....d..|.|...}..|
|000008b0| 6e 01 00 01 7c 00 00 69 | 03 00 83 00 00 53 28 04 |n...|..i|.....S(.|
|000008c0| 00 00 00 4e 69 01 00 00 | 00 52 06 00 00 00 73 02 |...Ni...|.R....s.|
|000008d0| 00 00 00 2c 20 28 04 00 | 00 00 74 06 00 00 00 73 |..., (..|..t....s|
|000008e0| 65 61 72 63 68 74 05 00 | 00 00 67 72 6f 75 70 74 |earcht..|..groupt|
|000008f0| 07 00 00 00 72 65 70 6c | 61 63 65 74 05 00 00 00 |....repl|acet....|
|00000900| 73 74 72 69 70 28 03 00 | 00 00 74 05 00 00 00 74 |strip(..|..t....t|
|00000910| 69 74 6c 65 74 05 00 00 | 00 6d 61 74 63 68 74 04 |itlet...|.matcht.|
|00000920| 00 00 00 70 72 65 70 28 | 01 00 00 00 74 09 00 00 |...prep(|....t...|
|00000930| 00 74 69 74 6c 65 5f 70 | 61 74 28 00 00 00 00 73 |.title_p|at(....s|
|00000940| 29 00 00 00 73 69 74 65 | 2d 70 61 63 6b 61 67 65 |)...site|-package|
|00000950| 73 5c 63 61 6c 69 62 72 | 65 5c 6c 69 62 72 61 72 |s\calibr|e\librar|
|00000960| 79 5c 64 61 74 61 62 61 | 73 65 2e 70 79 74 0a 00 |y\databa|se.pyt..|
|00000970| 00 00 74 69 74 6c 65 5f | 73 6f 72 74 2f 00 00 00 |..title_|sort/...|
|00000980| 73 0a 00 00 00 00 01 0f | 01 07 01 0f 01 1e 01 52 |s.......|.......R|
|00000990| 2a 00 00 00 28 0f 00 00 | 00 74 0a 00 00 00 69 73 |*...(...|.t....is|
|000009a0| 69 6e 73 74 61 6e 63 65 | 74 07 00 00 00 75 6e 69 |instance|t....uni|
|000009b0| 63 6f 64 65 74 06 00 00 | 00 65 6e 63 6f 64 65 74 |codet...|.encodet|
|000009c0| 06 00 00 00 73 71 6c 69 | 74 65 74 07 00 00 00 63 |....sqli|tet....c|
|000009d0| 6f 6e 6e 65 63 74 52 12 | 00 00 00 74 0f 00 00 00 |onnectR.|...t....|
|000009e0| 50 41 52 53 45 5f 44 45 | 43 4c 54 59 50 45 53 74 |PARSE_DE|CLTYPESt|
|000009f0| 0e 00 00 00 50 41 52 53 | 45 5f 43 4f 4c 4e 41 4d |....PARS|E_COLNAM|
|00000a00| 45 53 74 0b 00 00 00 72 | 6f 77 5f 66 61 63 74 6f |ESt....r|ow_facto|
|00000a10| 72 79 74 10 00 00 00 63 | 72 65 61 74 65 5f 61 67 |ryt....c|reate_ag|
|00000a20| 67 72 65 67 61 74 65 52 | 04 00 00 00 74 02 00 00 |gregateR|....t...|
|00000a30| 00 72 65 74 07 00 00 00 | 63 6f 6d 70 69 6c 65 74 |.ret....|compilet|
|00000a40| 0a 00 00 00 49 47 4e 4f | 52 45 43 41 53 45 74 0f |....IGNO|RECASEt.|
|00000a50| 00 00 00 63 72 65 61 74 | 65 5f 66 75 6e 63 74 69 |...creat|e_functi|
|00000a60| 6f 6e 28 03 00 00 00 74 | 04 00 00 00 70 61 74 68 |on(....t|....path|
|00000a70| 74 04 00 00 00 63 6f 6e | 6e 52 2a 00 00 00 28 00 |t....con|nR*...(.|
|00000a80| 00 00 00 28 01 00 00 00 | 52 29 00 00 00 73 29 00 |...(....|R)...s).|
|00000a90| 00 00 73 69 74 65 2d 70 | 61 63 6b 61 67 65 73 5c |..site-p|ackages\|
|00000aa0| 63 61 6c 69 62 72 65 5c | 6c 69 62 72 61 72 79 5c |calibre\|library\|
|00000ab0| 64 61 74 61 62 61 73 65 | 2e 70 79 74 08 00 00 00 |database|.pyt....|
|00000ac0| 5f 63 6f 6e 6e 65 63 74 | 28 00 00 00 73 12 00 00 |_connect|(...s...|
|00000ad0| 00 00 01 10 01 13 01 25 | 01 0c 01 13 01 15 01 0f |.......%|........|
|00000ae0| 06 13 01 74 0f 00 00 00 | 4c 69 62 72 61 72 79 44 |...t....|LibraryD|
|00000af0| 61 74 61 62 61 73 65 63 | 00 00 00 00 00 00 00 00 |atabasec|........|
|00000b00| 03 00 00 00 42 00 00 00 | 73 e9 03 00 00 65 00 00 |....B...|s....e..|
|00000b10| 5a 01 00 65 02 00 64 00 | 00 84 00 00 83 01 00 5a |Z..e..d.|.......Z|
|00000b20| 03 00 65 02 00 64 01 00 | 84 00 00 83 01 00 5a 04 |..e..d..|......Z.|
|00000b30| 00 65 02 00 65 05 00 64 | 02 00 84 01 00 83 01 00 |.e..e..d|........|
|00000b40| 5a 06 00 65 02 00 64 03 | 00 84 00 00 83 01 00 5a |Z..e..d.|.......Z|
|00000b50| 07 00 65 02 00 64 04 00 | 84 00 00 83 01 00 5a 08 |..e..d..|......Z.|
|00000b60| 00 65 02 00 64 05 00 84 | 00 00 83 01 00 5a 09 00 |.e..d...|.....Z..|
|00000b70| 65 02 00 64 06 00 84 00 | 00 83 01 00 5a 0a 00 65 |e..d....|....Z..e|
|00000b80| 02 00 64 07 00 84 00 00 | 83 01 00 5a 0b 00 65 02 |..d.....|...Z..e.|
|00000b90| 00 64 08 00 84 00 00 83 | 01 00 5a 0c 00 65 02 00 |.d......|..Z..e..|
|00000ba0| 64 09 00 84 00 00 83 01 | 00 5a 0d 00 65 02 00 64 |d.......|.Z..e..d|
|00000bb0| 0a 00 84 00 00 83 01 00 | 5a 0e 00 65 02 00 64 0b |........|Z..e..d.|
|00000bc0| 00 84 00 00 83 01 00 5a | 0f 00 65 02 00 64 0c 00 |.......Z|..e..d..|
|00000bd0| 84 00 00 83 01 00 5a 10 | 00 65 02 00 64 0d 00 84 |......Z.|.e..d...|
|00000be0| 00 00 83 01 00 5a 11 00 | 65 02 00 64 0e 00 84 00 |.....Z..|e..d....|
|00000bf0| 00 83 01 00 5a 12 00 65 | 13 00 64 0f 00 84 01 00 |....Z..e|..d.....|
|00000c00| 5a 14 00 64 10 00 84 00 | 00 5a 15 00 65 16 00 64 |Z..d....|.Z..e..d|
|00000c10| 11 00 84 00 00 83 01 00 | 5a 17 00 64 12 00 84 00 |........|Z..d....|
|00000c20| 00 5a 18 00 64 13 00 84 | 00 00 5a 19 00 64 14 00 |.Z..d...|..Z..d..|
|00000c30| 84 00 00 5a 1a 00 65 13 | 00 65 13 00 64 15 00 84 |...Z..e.|.e..d...|
|00000c40| 02 00 5a 1b 00 64 16 00 | 84 00 00 5a 1c 00 64 17 |..Z..d..|...Z..d.|
|00000c50| 00 84 00 00 5a 1d 00 64 | 18 00 84 00 00 5a 1e 00 |....Z..d|.....Z..|
|00000c60| 65 13 00 64 19 00 84 01 | 00 5a 1f 00 65 13 00 64 |e..d....|.Z..e..d|
|00000c70| 1a 00 84 01 00 5a 20 00 | 65 13 00 64 1b 00 84 01 |.....Z .|e..d....|
|00000c80| 00 5a 21 00 65 13 00 64 | 1c 00 84 01 00 5a 22 00 |.Z!.e..d|.....Z".|
|00000c90| 65 13 00 64 1d 00 84 01 | 00 5a 23 00 65 13 00 64 |e..d....|.Z#.e..d|
|00000ca0| 1e 00 84 01 00 5a 24 00 | 65 13 00 64 1f 00 84 01 |.....Z$.|e..d....|
|00000cb0| 00 5a 25 00 65 13 00 64 | 20 00 84 01 00 5a 26 00 |.Z%.e..d| ....Z&.|
|00000cc0| 65 13 00 64 21 00 84 01 | 00 5a 27 00 65 13 00 64 |e..d!...|.Z'.e..d|
|00000cd0| 22 00 84 01 00 5a 28 00 | 65 13 00 64 23 00 84 01 |"....Z(.|e..d#...|
|00000ce0| 00 5a 29 00 65 13 00 64 | 24 00 84 01 00 5a 2a 00 |.Z).e..d|$....Z*.|
|00000cf0| 65 13 00 64 25 00 84 01 | 00 5a 2b 00 65 13 00 64 |e..d%...|.Z+.e..d|
|00000d00| 26 00 84 01 00 5a 2c 00 | 65 13 00 64 27 00 84 01 |&....Z,.|e..d'...|
|00000d10| 00 5a 2d 00 64 28 00 84 | 00 00 5a 2e 00 65 13 00 |.Z-.d(..|..Z..e..|
|00000d20| 64 29 00 84 01 00 5a 2f | 00 65 13 00 64 2a 00 84 |d)....Z/|.e..d*..|
|00000d30| 01 00 5a 30 00 65 13 00 | 64 2b 00 84 01 00 5a 31 |..Z0.e..|d+....Z1|
|00000d40| 00 65 13 00 64 2c 00 84 | 01 00 5a 32 00 65 13 00 |.e..d,..|..Z2.e..|
|00000d50| 64 2d 00 84 01 00 5a 33 | 00 64 2e 00 84 00 00 5a |d-....Z3|.d.....Z|
|00000d60| 34 00 64 2f 00 84 00 00 | 5a 35 00 64 30 00 84 00 |4.d/....|Z5.d0...|
|00000d70| 00 5a 36 00 64 31 00 84 | 00 00 5a 37 00 64 32 00 |.Z6.d1..|..Z7.d2.|
|00000d80| 84 00 00 5a 38 00 64 33 | 00 84 00 00 5a 39 00 64 |...Z8.d3|....Z9.d|
|00000d90| 34 00 84 00 00 5a 3a 00 | 64 35 00 84 00 00 5a 3b |4....Z:.|d5....Z;|
|00000da0| 00 64 36 00 84 00 00 5a | 3c 00 64 37 00 84 00 00 |.d6....Z|<.d7....|
|00000db0| 5a 3d 00 65 3e 00 64 38 | 00 84 01 00 5a 3f 00 65 |Z=.e>.d8|....Z?.e|
|00000dc0| 13 00 64 39 00 84 01 00 | 5a 40 00 65 13 00 64 3a |..d9....|Z@.e..d:|
|00000dd0| 00 84 01 00 5a 41 00 64 | 3b 00 84 00 00 5a 42 00 |....ZA.d|;....ZB.|
|00000de0| 64 3c 00 84 00 00 5a 43 | 00 64 3d 00 84 00 00 5a |d<....ZC|.d=....Z|
|00000df0| 44 00 64 3e 00 84 00 00 | 5a 45 00 64 3f 00 84 00 |D.d>....|ZE.d?...|
|00000e00| 00 5a 46 00 64 40 00 84 | 00 00 5a 47 00 64 41 00 |.ZF.d@..|..ZG.dA.|
|00000e10| 84 00 00 5a 48 00 64 42 | 00 84 00 00 5a 49 00 64 |...ZH.dB|....ZI.d|
|00000e20| 43 00 84 00 00 5a 4a 00 | 64 44 00 84 00 00 5a 4b |C....ZJ.|dD....ZK|
|00000e30| 00 65 13 00 64 45 00 84 | 01 00 5a 4c 00 64 46 00 |.e..dE..|..ZL.dF.|
|00000e40| 84 00 00 5a 4d 00 64 47 | 00 84 00 00 5a 4e 00 64 |...ZM.dG|....ZN.d|
|00000e50| 48 00 84 00 00 5a 4f 00 | 64 49 00 84 00 00 5a 50 |H....ZO.|dI....ZP|
|00000e60| 00 64 4a 00 84 00 00 5a | 51 00 64 4b 00 84 00 00 |.dJ....Z|Q.dK....|
|00000e70| 5a 52 00 67 00 00 65 3e | 00 64 4c 00 84 02 00 5a |ZR.g..e>|.dL....Z|
|00000e80| 53 00 65 13 00 64 4d 00 | 84 01 00 5a 54 00 64 4e |S.e..dM.|...ZT.dN|
|00000e90| 00 84 00 00 5a 55 00 64 | 4f 00 84 00 00 5a 56 00 |....ZU.d|O....ZV.|
|00000ea0| 64 50 00 84 00 00 5a 57 | 00 64 51 00 84 00 00 5a |dP....ZW|.dQ....Z|
|00000eb0| 58 00 64 52 00 84 00 00 | 5a 59 00 64 53 00 84 00 |X.dR....|ZY.dS...|
|00000ec0| 00 5a 5a 00 64 54 00 84 | 00 00 5a 5b 00 65 13 00 |.ZZ.dT..|..Z[.e..|
|00000ed0| 64 55 00 84 01 00 5a 5c | 00 64 56 00 84 00 00 5a |dU....Z\|.dV....Z|
|00000ee0| 5d 00 64 57 00 84 00 00 | 5a 5e 00 64 58 00 84 00 |].dW....|Z^.dX...|
|00000ef0| 00 5a 5f 00 52 53 28 59 | 00 00 00 63 01 00 00 00 |.Z_.RS(Y|...c....|
|00000f00| 0a 00 00 00 05 00 00 00 | 63 00 00 00 73 61 01 00 |........|c...sa..|
|00000f10| 00 74 00 00 69 01 00 7c | 00 00 83 01 00 7d 01 00 |.t..i..||.....}..|
|00000f20| 7c 01 00 69 02 00 64 01 | 00 83 01 00 7d 02 00 7c ||..i..d.|....}..||
|00000f30| 02 00 69 03 00 83 00 00 | 7d 03 00 78 30 01 7c 03 |..i.....|}..x0.|.|
|00000f40| 00 6f 28 01 01 7c 03 00 | 64 02 00 19 7d 04 00 68 |.o(..|..|d...}..h|
|00000f50| 07 00 7c 03 00 64 03 00 | 19 64 04 00 36 7c 03 00 |..|..d..|.d..6|..|
|00000f60| 64 05 00 19 64 06 00 36 | 7c 03 00 64 07 00 19 64 |d...d..6||..d...d|
|00000f70| 08 00 36 7c 03 00 64 09 | 00 19 64 0a 00 36 7c 03 |..6|..d.|..d..6|.|
|00000f80| 00 64 0b 00 19 64 0c 00 | 36 7c 03 00 64 0d 00 19 |.d...d..|6|..d...|
|00000f90| 64 0e 00 36 74 04 00 69 | 04 00 69 05 00 7c 03 00 |d..6t..i|..i..|..|
|00000fa0| 64 0f 00 19 64 10 00 83 | 02 00 64 11 00 36 7d 05 |d...d...|..d..6}.|
|00000fb0| 00 68 00 00 7d 06 00 7c | 01 00 69 02 00 64 12 00 |.h..}..||..i..d..|
|00000fc0| 7c 04 00 66 01 00 83 02 | 00 69 03 00 83 00 00 7d ||..f....|.i.....}|
|00000fd0| 07 00 7c 07 00 6f 20 00 | 01 68 02 00 7c 07 00 64 |..|..o .|.h..|..d|
|00000fe0| 02 00 19 64 13 00 36 7c | 07 00 64 03 00 19 64 14 |...d..6||..d...d.|
|00000ff0| 00 36 7d 06 00 6e 01 00 | 01 7c 01 00 69 02 00 64 |.6}..n..|.|..i..d|
|00001000| 15 00 7c 04 00 66 01 00 | 83 02 00 69 06 00 83 00 |..|..f..|...i....|
|00001010| 00 7d 07 00 68 00 00 7d | 08 00 78 32 00 7c 07 00 |.}..h..}|..x2.|..|
|00001020| 44 5d 2a 00 7d 09 00 68 | 02 00 7c 09 00 64 03 00 |D]*.}..h|..|..d..|
|00001030| 19 64 13 00 36 7c 09 00 | 64 05 00 19 64 14 00 36 |.d..6|..|d...d..6|
|00001040| 7c 08 00 7c 09 00 64 02 | 00 19 3c 71 10 01 57 7c ||..|..d.|..<q..W||
|00001050| 05 00 7c 06 00 7c 08 00 | 66 03 00 56 01 7c 02 00 |..|..|..|f..V.|..|
|00001060| 69 03 00 83 00 00 7d 03 | 00 71 2d 00 01 57 64 00 |i.....}.|.q-..Wd.|
|00001070| 00 53 28 16 00 00 00 4e | 73 25 00 00 00 73 65 6c |.S(....N|s%...sel|
|00001080| 65 63 74 20 2a 20 66 72 | 6f 6d 20 62 6f 6f 6b 73 |ect * fr|om books|
|00001090| 5f 6d 65 74 61 20 6f 72 | 64 65 72 20 62 79 20 69 |_meta or|der by i|
|000010a0| 64 3b 69 00 00 00 00 69 | 01 00 00 00 52 26 00 00 |d;i....i|....R&..|
|000010b0| 00 69 02 00 00 00 74 07 | 00 00 00 61 75 74 68 6f |.i....t.|...autho|
|000010c0| 72 73 69 03 00 00 00 74 | 09 00 00 00 70 75 62 6c |rsi....t|....publ|
|000010d0| 69 73 68 65 72 69 05 00 | 00 00 74 04 00 00 00 74 |isheri..|..t....t|
|000010e0| 61 67 73 69 07 00 00 00 | 74 08 00 00 00 63 6f 6d |agsi....|t....com|
|000010f0| 6d 65 6e 74 73 69 08 00 | 00 00 74 06 00 00 00 72 |mentsi..|..t....r|
|00001100| 61 74 69 6e 67 69 06 00 | 00 00 73 11 00 00 00 25 |atingi..|..s....%|
|00001110| 59 2d 25 6d 2d 25 64 20 | 25 48 3a 25 4d 3a 25 53 |Y-%m-%d |%H:%M:%S|
|00001120| 74 09 00 00 00 74 69 6d | 65 73 74 61 6d 70 73 3a |t....tim|estamps:|
|00001130| 00 00 00 73 65 6c 65 63 | 74 20 75 6e 63 6f 6d 70 |...selec|t uncomp|
|00001140| 72 65 73 73 65 64 5f 73 | 69 7a 65 2c 20 64 61 74 |ressed_s|ize, dat|
|00001150| 61 20 66 72 6f 6d 20 62 | 6f 6f 6b 73 5f 63 6f 76 |a from b|ooks_cov|
|00001160| 65 72 20 77 68 65 72 65 | 20 69 64 3d 3f 74 11 00 |er where| id=?t..|
|00001170| 00 00 75 6e 63 6f 6d 70 | 72 65 73 73 65 64 5f 73 |..uncomp|ressed_s|
|00001180| 69 7a 65 74 04 00 00 00 | 64 61 74 61 73 44 00 00 |izet....|datasD..|
|00001190| 00 73 65 6c 65 63 74 20 | 65 78 74 65 6e 73 69 6f |.select |extensio|
|000011a0| 6e 2c 20 75 6e 63 6f 6d | 70 72 65 73 73 65 64 5f |n, uncom|pressed_|
|000011b0| 73 69 7a 65 2c 20 64 61 | 74 61 20 66 72 6f 6d 20 |size, da|ta from |
|000011c0| 62 6f 6f 6b 73 5f 64 61 | 74 61 20 77 68 65 72 65 |books_da|ta where|
|000011d0| 20 69 64 3d 3f 28 07 00 | 00 00 52 2e 00 00 00 52 | id=?(..|..R....R|
|000011e0| 2f 00 00 00 52 14 00 00 | 00 52 17 00 00 00 74 08 |/...R...|.R....t.|
|000011f0| 00 00 00 64 61 74 65 74 | 69 6d 65 74 08 00 00 00 |...datet|imet....|
|00001200| 73 74 72 70 74 69 6d 65 | 52 18 00 00 00 28 0a 00 |strptime|R....(..|
|00001210| 00 00 52 38 00 00 00 52 | 39 00 00 00 74 03 00 00 |..R8...R|9...t...|
|00001220| 00 63 75 72 74 04 00 00 | 00 62 6f 6f 6b 74 02 00 |.curt...|.bookt..|
|00001230| 00 00 69 64 74 04 00 00 | 00 6d 65 74 61 74 05 00 |..idt...|.metat..|
|00001240| 00 00 63 6f 76 65 72 74 | 05 00 00 00 71 75 65 72 |..covert|....quer|
|00001250| 79 74 07 00 00 00 66 6f | 72 6d 61 74 73 52 1f 00 |yt....fo|rmatsR..|
|00001260| 00 00 28 00 00 00 00 28 | 00 00 00 00 73 29 00 00 |..(....(|....s)..|
|00001270| 00 73 69 74 65 2d 70 61 | 63 6b 61 67 65 73 5c 63 |.site-pa|ckages\c|
|00001280| 61 6c 69 62 72 65 5c 6c | 69 62 72 61 72 79 5c 64 |alibre\l|ibrary\d|
|00001290| 61 74 61 62 61 73 65 2e | 70 79 74 15 00 00 00 62 |atabase.|pyt....b|
|000012a0| 6f 6f 6b 73 5f 69 6e 5f | 6f 6c 64 5f 64 61 74 61 |ooks_in_|old_data|
|000012b0| 62 61 73 65 3a 00 00 00 | 73 28 00 00 00 00 05 0f |base:...|s(......|
|000012c0| 01 0f 01 0c 01 03 00 07 | 01 0a 01 24 01 21 01 1d |........|...$.!..|
|000012d0| 02 06 01 1b 01 07 01 20 | 01 1b 01 06 01 07 00 06 |....... |........|
|000012e0| 01 28 01 0e 01 63 01 00 | 00 00 03 00 00 00 02 00 |.(...c..|........|
|000012f0| 00 00 43 00 00 00 73 36 | 00 00 00 74 00 00 69 01 |..C...s6|...t..i.|
|00001300| 00 7c 00 00 83 01 00 7d | 01 00 7c 01 00 69 02 00 |.|.....}|..|..i..|
|00001310| 64 01 00 83 01 00 69 03 | 00 83 00 00 64 02 00 19 |d.....i.|....d...|
|00001320| 7d 02 00 7c 01 00 69 04 | 00 83 00 00 01 7c 02 00 |}..|..i.|.....|..|
|00001330| 53 28 03 00 00 00 4e 73 | 20 00 00 00 53 45 4c 45 |S(....Ns| ...SELE|
|00001340| 43 54 20 43 4f 55 4e 54 | 28 69 64 29 20 66 72 6f |CT COUNT|(id) fro|
|00001350| 6d 20 62 6f 6f 6b 73 5f | 6d 65 74 61 69 00 00 00 |m books_|metai...|
|00001360| 00 28 05 00 00 00 52 2e | 00 00 00 52 2f 00 00 00 |.(....R.|...R/...|
|00001370| 52 14 00 00 00 52 17 00 | 00 00 74 05 00 00 00 63 |R....R..|..t....c|
|00001380| 6c 6f 73 65 28 03 00 00 | 00 52 38 00 00 00 52 39 |lose(...|.R8...R9|
|00001390| 00 00 00 52 08 00 00 00 | 28 00 00 00 00 28 00 00 |...R....|(....(..|
|000013a0| 00 00 73 29 00 00 00 73 | 69 74 65 2d 70 61 63 6b |..s)...s|ite-pack|
|000013b0| 61 67 65 73 5c 63 61 6c | 69 62 72 65 5c 6c 69 62 |ages\cal|ibre\lib|
|000013c0| 72 61 72 79 5c 64 61 74 | 61 62 61 73 65 2e 70 79 |rary\dat|abase.py|
|000013d0| 74 13 00 00 00 73 69 7a | 65 6f 66 5f 6f 6c 64 5f |t....siz|eof_old_|
|000013e0| 64 61 74 61 62 61 73 65 | 53 00 00 00 73 08 00 00 |database|S...s...|
|000013f0| 00 00 02 0f 01 19 01 0a | 01 63 03 00 00 00 15 00 |........|.c......|
|00001400| 00 00 0d 00 00 00 43 00 | 00 00 73 51 03 00 00 64 |......C.|..sQ...d|
|00001410| 01 00 7d 03 00 78 44 03 | 74 00 00 69 01 00 7c 00 |..}..xD.|t..i..|.|
|00001420| 00 83 01 00 44 5d 33 03 | 5c 03 00 7d 04 00 7d 05 |....D]3.|\..}..}.|
|00001430| 00 7d 06 00 7c 04 00 64 | 02 00 19 7d 07 00 7c 07 |.}..|..d|...}..|.|
|00001440| 00 70 0a 00 01 64 03 00 | 7d 07 00 6e 01 00 01 7c |.p...d..|}..n...||
|00001450| 01 00 69 02 00 64 04 00 | 7c 04 00 64 05 00 19 7c |..i..d..||..d...||
|00001460| 04 00 64 06 00 19 7c 07 | 00 66 03 00 83 02 00 7d |..d...|.|.f.....}|
|00001470| 08 00 7c 08 00 69 03 00 | 7d 09 00 74 04 00 7c 07 |..|..i..|}..t..|.|
|00001480| 00 83 01 00 7d 07 00 78 | 6c 00 7c 07 00 44 5d 64 |....}..x|l.|..D]d|
|00001490| 00 7d 0a 00 7c 01 00 69 | 02 00 64 07 00 7c 0a 00 |.}..|..i|..d..|..|
|000014a0| 66 01 00 83 02 00 69 05 | 00 83 00 00 7d 0b 00 7c |f.....i.|....}..||
|000014b0| 0b 00 6f 0e 00 01 7c 0b | 00 64 01 00 19 7d 0c 00 |..o...|.|.d...}..|
|000014c0| 6e 19 00 01 7c 01 00 69 | 02 00 64 08 00 7c 0a 00 |n...|..i|..d..|..|
|000014d0| 66 01 00 83 02 00 69 03 | 00 7d 0c 00 7c 01 00 69 |f.....i.|.}..|..i|
|000014e0| 02 00 64 09 00 7c 09 00 | 7c 0c 00 66 02 00 83 02 |..d..|..||..f....|
|000014f0| 00 01 71 7f 00 57 7c 04 | 00 64 0a 00 19 6f 67 00 |..q..W|.|.d...og.|
|00001500| 01 7c 01 00 69 02 00 64 | 0b 00 7c 04 00 64 0a 00 |.|..i..d|..|..d..|
|00001510| 19 66 01 00 83 02 00 69 | 05 00 83 00 00 7d 0d 00 |.f.....i|.....}..|
|00001520| 7c 0d 00 6f 0b 00 01 7c | 0d 00 64 01 00 19 6e 1a ||..o...||..d...n.|
|00001530| 00 01 7c 01 00 69 02 00 | 64 0c 00 7c 04 00 64 0a |..|..i..|d..|..d.|
|00001540| 00 19 66 01 00 83 02 00 | 69 03 00 7d 0e 00 7c 01 |..f.....|i..}..|.|
|00001550| 00 69 02 00 64 0d 00 7c | 09 00 7c 0e 00 66 02 00 |.i..d..||..|..f..|
|00001560| 83 02 00 01 6e 01 00 01 | 7c 04 00 64 0e 00 19 6f |....n...||..d...o|
|00001570| 6f 00 01 7c 01 00 69 02 | 00 64 0f 00 64 10 00 7c |o..|..i.|.d..d..||
|00001580| 04 00 64 0e 00 19 14 66 | 01 00 83 02 00 69 05 00 |..d....f|.....i..|
|00001590| 83 00 00 7d 0d 00 7c 0d | 00 6f 0b 00 01 7c 0d 00 |...}..|.|.o...|..|
|000015a0| 64 01 00 19 6e 1e 00 01 | 7c 01 00 69 02 00 64 11 |d...n...||..i..d.|
|000015b0| 00 64 10 00 7c 04 00 64 | 0e 00 19 14 66 01 00 83 |.d..|..d|....f...|
|000015c0| 02 00 69 03 00 7d 0f 00 | 7c 01 00 69 02 00 64 12 |..i..}..||..i..d.|
|000015d0| 00 7c 09 00 7c 0f 00 66 | 02 00 83 02 00 01 6e 01 |.|..|..f|......n.|
|000015e0| 00 01 7c 04 00 64 13 00 | 19 7d 10 00 7c 10 00 6f |..|..d..|.}..|..o|
|000015f0| 13 00 01 7c 10 00 69 06 | 00 64 14 00 83 01 00 7d |...|..i.|.d.....}|
|00001600| 10 00 6e 07 00 01 67 00 | 00 7d 10 00 78 86 00 7c |..n...g.|.}..x..||
|00001610| 10 00 44 5d 7e 00 7d 0a | 00 7c 0a 00 69 07 00 83 |..D]~.}.|.|..i...|
|00001620| 00 00 7d 0a 00 7c 0a 00 | 70 07 00 01 71 04 02 6e |..}..|..|p...q..n|
|00001630| 01 00 01 7c 01 00 69 02 | 00 64 15 00 7c 0a 00 66 |...|..i.|.d..|..f|
|00001640| 01 00 83 02 00 69 05 00 | 83 00 00 7d 11 00 7c 11 |.....i..|...}..|.|
|00001650| 00 6f 0e 00 01 7c 11 00 | 64 01 00 19 7d 12 00 6e |.o...|..|d...}..n|
|00001660| 19 00 01 7c 01 00 69 02 | 00 64 16 00 7c 0a 00 66 |...|..i.|.d..|..f|
|00001670| 01 00 83 02 00 69 03 00 | 7d 12 00 7c 01 00 69 02 |.....i..|}..|..i.|
|00001680| 00 64 17 00 7c 09 00 7c | 12 00 66 02 00 83 02 00 |.d..|..||..f.....|
|00001690| 01 71 04 02 57 7c 04 00 | 64 18 00 19 7d 13 00 7c |.q..W|..|d...}..||
|000016a0| 13 00 6f 1a 00 01 7c 01 | 00 69 02 00 64 19 00 7c |..o...|.|.i..d..||
|000016b0| 09 00 7c 13 00 66 02 00 | 83 02 00 01 6e 01 00 01 |..|..f..|....n...|
|000016c0| 7c 05 00 6f 25 00 01 7c | 01 00 69 02 00 64 1a 00 ||..o%..||..i..d..|
|000016d0| 7c 09 00 7c 05 00 64 1b | 00 19 7c 05 00 64 1c 00 ||..|..d.|..|..d..|
|000016e0| 19 66 03 00 83 02 00 01 | 6e 01 00 01 78 40 00 7c |.f......|n...x@.||
|000016f0| 06 00 69 08 00 83 00 00 | 44 5d 32 00 7d 14 00 7c |..i.....|D]2.}..||
|00001700| 01 00 69 02 00 64 1d 00 | 7c 09 00 7c 14 00 7c 06 |..i..d..||..|..|.|
|00001710| 00 7c 14 00 19 64 1b 00 | 19 7c 06 00 7c 14 00 19 |.|...d..|.|..|...|
|00001720| 64 1c 00 19 66 04 00 83 | 02 00 01 71 ea 02 57 7c |d...f...|...q..W||
|00001730| 01 00 69 09 00 83 00 00 | 01 7c 03 00 64 1e 00 37 |..i.....|.|..d..7|
|00001740| 7d 03 00 7c 02 00 6f 0e | 00 01 7c 02 00 7c 03 00 |}..|..o.|..|..|..|
|00001750| 83 01 00 01 71 16 00 01 | 71 16 00 57 64 00 00 53 |....q...|q..Wd..S|
|00001760| 28 1f 00 00 00 4e 69 00 | 00 00 00 52 3c 00 00 00 |(....Ni.|...R<...|
|00001770| 74 07 00 00 00 55 6e 6b | 6e 6f 77 6e 73 3f 00 00 |t....Unk|nowns?..|
|00001780| 00 49 4e 53 45 52 54 20 | 49 4e 54 4f 20 62 6f 6f |.INSERT |INTO boo|
|00001790| 6b 73 28 74 69 74 6c 65 | 2c 20 74 69 6d 65 73 74 |ks(title|, timest|
|000017a0| 61 6d 70 2c 20 61 75 74 | 68 6f 72 5f 73 6f 72 74 |amp, aut|hor_sort|
|000017b0| 29 20 56 41 4c 55 45 53 | 20 28 3f 2c 3f 2c 3f 29 |) VALUES| (?,?,?)|
|000017c0| 52 26 00 00 00 52 41 00 | 00 00 73 23 00 00 00 53 |R&...RA.|..s#...S|
|000017d0| 45 4c 45 43 54 20 69 64 | 20 66 72 6f 6d 20 61 75 |ELECT id| from au|
|000017e0| 74 68 6f 72 73 20 57 48 | 45 52 45 20 6e 61 6d 65 |thors WH|ERE name|
|000017f0| 3d 3f 73 24 00 00 00 49 | 4e 53 45 52 54 20 49 4e |=?s$...I|NSERT IN|
|00001800| 54 4f 20 61 75 74 68 6f | 72 73 28 6e 61 6d 65 29 |TO autho|rs(name)|
|00001810| 20 56 41 4c 55 45 53 20 | 28 3f 29 73 39 00 00 00 | VALUES |(?)s9...|
|00001820| 49 4e 53 45 52 54 20 49 | 4e 54 4f 20 62 6f 6f 6b |INSERT I|NTO book|
|00001830| 73 5f 61 75 74 68 6f 72 | 73 5f 6c 69 6e 6b 28 62 |s_author|s_link(b|
|00001840| 6f 6f 6b 2c 20 61 75 74 | 68 6f 72 29 20 56 41 4c |ook, aut|hor) VAL|
|00001850| 55 45 53 20 28 3f 2c 3f | 29 52 3d 00 00 00 73 26 |UES (?,?|)R=...s&|
|00001860| 00 00 00 53 45 4c 45 43 | 54 20 69 64 20 66 72 6f |...SELEC|T id fro|
|00001870| 6d 20 70 75 62 6c 69 73 | 68 65 72 73 20 57 48 45 |m publis|hers WHE|
|00001880| 52 45 20 6e 61 6d 65 3d | 3f 73 27 00 00 00 49 4e |RE name=|?s'...IN|
|00001890| 53 45 52 54 20 49 4e 54 | 4f 20 70 75 62 6c 69 73 |SERT INT|O publis|
|000018a0| 68 65 72 73 28 6e 61 6d | 65 29 20 56 41 4c 55 45 |hers(nam|e) VALUE|
|000018b0| 53 20 28 3f 29 73 3f 00 | 00 00 49 4e 53 45 52 54 |S (?)s?.|..INSERT|
|000018c0| 20 49 4e 54 4f 20 62 6f | 6f 6b 73 5f 70 75 62 6c | INTO bo|oks_publ|
|000018d0| 69 73 68 65 72 73 5f 6c | 69 6e 6b 28 62 6f 6f 6b |ishers_l|ink(book|
|000018e0| 2c 20 70 75 62 6c 69 73 | 68 65 72 29 20 56 41 4c |, publis|her) VAL|
|000018f0| 55 45 53 20 28 3f 2c 3f | 29 52 40 00 00 00 73 25 |UES (?,?|)R@...s%|
|00001900| 00 00 00 53 45 4c 45 43 | 54 20 69 64 20 66 72 6f |...SELEC|T id fro|
|00001910| 6d 20 72 61 74 69 6e 67 | 73 20 57 48 45 52 45 20 |m rating|s WHERE |
|00001920| 72 61 74 69 6e 67 3d 3f | 69 02 00 00 00 73 26 00 |rating=?|i....s&.|
|00001930| 00 00 49 4e 53 45 52 54 | 20 49 4e 54 4f 20 72 61 |..INSERT| INTO ra|
|00001940| 74 69 6e 67 73 28 72 61 | 74 69 6e 67 29 20 56 41 |tings(ra|ting) VA|
|00001950| 4c 55 45 53 20 28 3f 29 | 73 39 00 00 00 49 4e 53 |LUES (?)|s9...INS|
|00001960| 45 52 54 20 49 4e 54 4f | 20 62 6f 6f 6b 73 5f 72 |ERT INTO| books_r|
|00001970| 61 74 69 6e 67 73 5f 6c | 69 6e 6b 28 62 6f 6f 6b |atings_l|ink(book|
|00001980| 2c 20 72 61 74 69 6e 67 | 29 20 56 41 4c 55 45 53 |, rating|) VALUES|
|00001990| 20 28 3f 2c 3f 29 52 3e | 00 00 00 52 05 00 00 00 | (?,?)R>|...R....|
|000019a0| 73 20 00 00 00 53 45 4c | 45 43 54 20 69 64 20 66 |s ...SEL|ECT id f|
|000019b0| 72 6f 6d 20 74 61 67 73 | 20 57 48 45 52 45 20 6e |rom tags| WHERE n|
|000019c0| 61 6d 65 3d 3f 73 21 00 | 00 00 49 4e 53 45 52 54 |ame=?s!.|..INSERT|
|000019d0| 20 49 4e 54 4f 20 74 61 | 67 73 28 6e 61 6d 65 29 | INTO ta|gs(name)|
|000019e0| 20 56 41 4c 55 45 53 20 | 28 3f 29 73 33 00 00 00 | VALUES |(?)s3...|
|000019f0| 49 4e 53 45 52 54 20 49 | 4e 54 4f 20 62 6f 6f 6b |INSERT I|NTO book|
|00001a00| 73 5f 74 61 67 73 5f 6c | 69 6e 6b 28 62 6f 6f 6b |s_tags_l|ink(book|
|00001a10| 2c 20 74 61 67 29 20 56 | 41 4c 55 45 53 20 28 3f |, tag) V|ALUES (?|
|00001a20| 2c 3f 29 52 3f 00 00 00 | 73 2e 00 00 00 49 4e 53 |,?)R?...|s....INS|
|00001a30| 45 52 54 20 49 4e 54 4f | 20 63 6f 6d 6d 65 6e 74 |ERT INTO| comment|
|00001a40| 73 28 62 6f 6f 6b 2c 20 | 74 65 78 74 29 20 56 41 |s(book, |text) VA|
|00001a50| 4c 55 45 53 20 28 3f 2c | 20 3f 29 73 42 00 00 00 |LUES (?,| ?)sB...|
|00001a60| 49 4e 53 45 52 54 20 49 | 4e 54 4f 20 63 6f 76 65 |INSERT I|NTO cove|
|00001a70| 72 73 28 62 6f 6f 6b 2c | 20 75 6e 63 6f 6d 70 72 |rs(book,| uncompr|
|00001a80| 65 73 73 65 64 5f 73 69 | 7a 65 2c 20 64 61 74 61 |essed_si|ze, data|
|00001a90| 29 20 56 41 4c 55 45 53 | 20 28 3f 2c 20 3f 2c 20 |) VALUES| (?, ?, |
|00001aa0| 3f 29 52 42 00 00 00 52 | 43 00 00 00 73 4b 00 00 |?)RB...R|C...sK..|
|00001ab0| 00 49 4e 53 45 52 54 20 | 49 4e 54 4f 20 64 61 74 |.INSERT |INTO dat|
|00001ac0| 61 28 62 6f 6f 6b 2c 20 | 66 6f 72 6d 61 74 2c 20 |a(book, |format, |
|00001ad0| 75 6e 63 6f 6d 70 72 65 | 73 73 65 64 5f 73 69 7a |uncompre|ssed_siz|
|00001ae0| 65 2c 20 64 61 74 61 29 | 20 56 41 4c 55 45 53 20 |e, data)| VALUES |
|00001af0| 28 3f 2c 20 3f 2c 20 3f | 2c 20 3f 29 69 01 00 00 |(?, ?, ?|, ?)i...|
|00001b00| 00 28 0a 00 00 00 52 3b | 00 00 00 52 4d 00 00 00 |.(....R;|...RM...|
|00001b10| 52 14 00 00 00 74 09 00 | 00 00 6c 61 73 74 72 6f |R....t..|..lastro|
|00001b20| 77 69 64 52 03 00 00 00 | 52 17 00 00 00 74 05 00 |widR....|R....t..|
|00001b30| 00 00 73 70 6c 69 74 52 | 25 00 00 00 74 04 00 00 |..splitR|%...t...|
|00001b40| 00 6b 65 79 73 74 06 00 | 00 00 63 6f 6d 6d 69 74 |.keyst..|..commit|
|00001b50| 28 15 00 00 00 52 38 00 | 00 00 52 39 00 00 00 74 |(....R8.|..R9...t|
|00001b60| 08 00 00 00 70 72 6f 67 | 72 65 73 73 74 05 00 00 |....prog|resst...|
|00001b70| 00 63 6f 75 6e 74 52 47 | 00 00 00 52 4a 00 00 00 |.countRG|...RJ...|
|00001b80| 52 4c 00 00 00 52 3c 00 | 00 00 74 03 00 00 00 6f |RL...R<.|..t....o|
|00001b90| 62 6a 52 48 00 00 00 74 | 01 00 00 00 61 74 06 00 |bjRH...t|....at..|
|00001ba0| 00 00 61 75 74 68 6f 72 | 74 03 00 00 00 61 69 64 |..author|t....aid|
|00001bb0| 74 09 00 00 00 63 61 6e | 64 69 64 61 74 65 74 03 |t....can|didatet.|
|00001bc0| 00 00 00 70 69 64 74 03 | 00 00 00 72 69 64 52 3e |...pidt.|...ridR>|
|00001bd0| 00 00 00 74 03 00 00 00 | 74 61 67 74 03 00 00 00 |...t....|tagt....|
|00001be0| 74 69 64 52 3f 00 00 00 | 74 06 00 00 00 66 6f 72 |tidR?...|t....for|
|00001bf0| 6d 61 74 28 00 00 00 00 | 28 00 00 00 00 73 29 00 |mat(....|(....s).|
|00001c00| 00 00 73 69 74 65 2d 70 | 61 63 6b 61 67 65 73 5c |..site-p|ackages\|
|00001c10| 63 61 6c 69 62 72 65 5c | 6c 69 62 72 61 72 79 5c |calibre\|library\|
|00001c20| 64 61 74 61 62 61 73 65 | 2e 70 79 74 13 00 00 00 |database|.pyt....|
|00001c30| 69 6d 70 6f 72 74 5f 6f | 6c 64 5f 64 61 74 61 62 |import_o|ld_datab|
|00001c40| 61 73 65 5a 00 00 00 73 | 72 00 00 00 00 02 06 01 |aseZ...s|r.......|
|00001c50| 10 00 0f 01 0a 01 07 01 | 0a 01 09 01 1a 01 09 01 |........|........|
|00001c60| 0c 01 07 00 06 01 1b 01 | 07 01 0e 02 18 01 1a 01 |........|........|
|00001c70| 0b 01 1f 01 1b 01 13 01 | 1a 01 0b 01 23 01 1b 01 |........|....#...|
|00001c80| 17 01 1a 01 0a 01 07 01 | 13 02 06 01 07 00 06 01 |........|........|
|00001c90| 0c 01 07 00 07 01 1b 01 | 07 01 0e 02 18 01 1a 01 |........|........|
|00001ca0| 0a 01 07 01 09 01 11 01 | 07 01 09 01 1c 01 0d 00 |........|........|
|00001cb0| 06 01 09 01 11 01 16 01 | 0a 01 0a 01 07 01 63 01 |........|......c.|
|00001cc0| 00 00 00 01 00 00 00 02 | 00 00 00 43 00 00 00 73 |........|...C...s|
|00001cd0| 28 00 00 00 7c 00 00 69 | 00 00 64 01 00 83 01 00 |(...|..i|..d.....|
|00001ce0| 01 7c 00 00 69 01 00 64 | 02 00 83 01 00 01 7c 00 |.|..i..d|......|.|
|00001cf0| 00 69 02 00 83 00 00 01 | 64 00 00 53 28 03 00 00 |.i......|d..S(...|
|00001d00| 00 4e 73 14 46 00 00 0a | 20 20 20 20 20 20 20 20 |.Ns.F...| |
|00001d10| 2f 2a 2a 2a 2a 20 62 6f | 6f 6b 73 20 74 61 62 6c |/**** bo|oks tabl|
|00001d20| 65 20 2a 2a 2a 2a 2a 2f | 0a 20 20 20 20 20 20 20 |e *****/|. |
|00001d30| 20 43 52 45 41 54 45 20 | 54 41 42 4c 45 20 62 6f | CREATE |TABLE bo|
|00001d40| 6f 6b 73 20 28 20 69 64 | 20 20 20 20 20 20 20 20 |oks ( id| |
|00001d50| 49 4e 54 45 47 45 52 20 | 50 52 49 4d 41 52 59 20 |INTEGER |PRIMARY |
|00001d60| 4b 45 59 20 41 55 54 4f | 49 4e 43 52 45 4d 45 4e |KEY AUTO|INCREMEN|
|00001d70| 54 2c 0a 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |T,. | |
|00001d80| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00001d90| 74 69 74 6c 65 20 20 20 | 20 20 54 45 58 54 20 4e |title | TEXT N|
|00001da0| 4f 54 20 4e 55 4c 4c 20 | 44 45 46 41 55 4c 54 20 |OT NULL |DEFAULT |
|00001db0| 27 55 6e 6b 6e 6f 77 6e | 27 20 43 4f 4c 4c 41 54 |'Unknown|' COLLAT|
|00001dc0| 45 20 4e 4f 43 41 53 45 | 2c 0a 20 20 20 20 20 20 |E NOCASE|,. |
|00001dd0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00001de0| 20 20 20 20 20 20 20 73 | 6f 72 74 20 20 20 20 20 | s|ort |
|00001df0| 20 54 45 58 54 20 43 4f | 4c 4c 41 54 45 20 4e 4f | TEXT CO|LLATE NO|
|00001e00| 43 41 53 45 2c 0a 20 20 | 20 20 20 20 20 20 20 20 |CASE,. | |
|00001e10| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00001e20| 20 20 20 74 69 6d 65 73 | 74 61 6d 70 20 54 49 4d | times|tamp TIM|
|00001e30| 45 53 54 41 4d 50 20 44 | 45 46 41 55 4c 54 20 43 |ESTAMP D|EFAULT C|
|00001e40| 55 52 52 45 4e 54 5f 54 | 49 4d 45 53 54 41 4d 50 |URRENT_T|IMESTAMP|
|00001e50| 2c 0a 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |,. | |
|00001e60| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 75 | | u|
|00001e70| 72 69 20 20 20 20 20 20 | 20 54 45 58 54 2c 0a 20 |ri | TEXT,. |
|00001e80| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00001e90| 20 20 20 20 20 20 20 20 | 20 20 20 20 73 65 72 69 | | seri|
|00001ea0| 65 73 5f 69 6e 64 65 78 | 20 49 4e 54 45 47 45 52 |es_index| INTEGER|
|00001eb0| 20 4e 4f 54 20 4e 55 4c | 4c 20 44 45 46 41 55 4c | NOT NUL|L DEFAUL|
|00001ec0| 54 20 31 0a 20 20 20 20 | 20 20 20 20 20 20 20 20 |T 1. | |
|00001ed0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 29 | | )|
|00001ee0| 3b 0a 20 20 20 20 20 20 | 20 20 43 52 45 41 54 45 |;. | CREATE|
|00001ef0| 20 49 4e 44 45 58 20 62 | 6f 6f 6b 73 5f 69 64 78 | INDEX b|ooks_idx|
|00001f00| 20 4f 4e 20 62 6f 6f 6b | 73 20 28 73 6f 72 74 20 | ON book|s (sort |
|00001f10| 43 4f 4c 4c 41 54 45 20 | 4e 4f 43 41 53 45 29 3b |COLLATE |NOCASE);|
|00001f20| 0a 20 20 20 20 20 20 20 | 20 43 52 45 41 54 45 20 |. | CREATE |
|00001f30| 54 52 49 47 47 45 52 20 | 62 6f 6f 6b 73 5f 69 6e |TRIGGER |books_in|
|00001f40| 73 65 72 74 5f 74 72 67 | 0a 20 20 20 20 20 20 20 |sert_trg|. |
|00001f50| 20 41 46 54 45 52 20 49 | 4e 53 45 52 54 20 4f 4e | AFTER I|NSERT ON|
|00001f60| 20 62 6f 6f 6b 73 0a 20 | 20 20 20 20 20 20 20 42 | books. | B|
|00001f70| 45 47 49 4e 0a 20 20 20 | 20 20 20 20 20 20 20 55 |EGIN. | U|
|00001f80| 50 44 41 54 45 20 62 6f | 6f 6b 73 20 53 45 54 20 |PDATE bo|oks SET |
|00001f90| 73 6f 72 74 3d 74 69 74 | 6c 65 5f 73 6f 72 74 28 |sort=tit|le_sort(|
|00001fa0| 4e 45 57 2e 74 69 74 6c | 65 29 20 57 48 45 52 45 |NEW.titl|e) WHERE|
|00001fb0| 20 69 64 3d 4e 45 57 2e | 69 64 3b 0a 20 20 20 20 | id=NEW.|id;. |
|00001fc0| 20 20 20 20 45 4e 44 3b | 0a 20 20 20 20 20 20 20 | END;|. |
|00001fd0| 20 43 52 45 41 54 45 20 | 54 52 49 47 47 45 52 20 | CREATE |TRIGGER |
|00001fe0| 62 6f 6f 6b 73 5f 75 70 | 64 61 74 65 5f 74 72 67 |books_up|date_trg|
|00001ff0| 0a 20 20 20 20 20 20 20 | 20 41 46 54 45 52 20 55 |. | AFTER U|
|00002000| 50 44 41 54 45 20 4f 4e | 20 62 6f 6f 6b 73 0a 20 |PDATE ON| books. |
|00002010| 20 20 20 20 20 20 20 42 | 45 47 49 4e 0a 20 20 20 | B|EGIN. |
|00002020| 20 20 20 20 20 20 20 55 | 50 44 41 54 45 20 62 6f | U|PDATE bo|
|00002030| 6f 6b 73 20 53 45 54 20 | 73 6f 72 74 3d 74 69 74 |oks SET |sort=tit|
|00002040| 6c 65 5f 73 6f 72 74 28 | 4e 45 57 2e 74 69 74 6c |le_sort(|NEW.titl|
|00002050| 65 29 20 57 48 45 52 45 | 20 69 64 3d 4e 45 57 2e |e) WHERE| id=NEW.|
|00002060| 69 64 3b 0a 20 20 20 20 | 20 20 20 20 45 4e 44 3b |id;. | END;|
|00002070| 0a 0a 0a 20 20 20 20 20 | 20 20 20 2f 2a 2a 2a 2a |... | /****|
|00002080| 2a 20 61 75 74 68 6f 72 | 73 20 74 61 62 6c 65 20 |* author|s table |
|00002090| 2a 2a 2a 2a 2a 2f 0a 20 | 20 20 20 20 20 20 20 43 |*****/. | C|
|000020a0| 52 45 41 54 45 20 54 41 | 42 4c 45 20 61 75 74 68 |REATE TA|BLE auth|
|000020b0| 6f 72 73 20 28 20 69 64 | 20 20 20 49 4e 54 45 47 |ors ( id| INTEG|
|000020c0| 45 52 20 50 52 49 4d 41 | 52 59 20 4b 45 59 2c 0a |ER PRIMA|RY KEY,.|
|000020d0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|000020e0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 6e 61 | | na|
|000020f0| 6d 65 20 54 45 58 54 20 | 4e 4f 54 20 4e 55 4c 4c |me TEXT |NOT NULL|
|00002100| 20 43 4f 4c 4c 41 54 45 | 20 4e 4f 43 41 53 45 2c | COLLATE| NOCASE,|
|00002110| 0a 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |. | |
|00002120| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 73 | | s|
|00002130| 6f 72 74 20 54 45 58 54 | 20 43 4f 4c 4c 41 54 45 |ort TEXT| COLLATE|
|00002140| 20 4e 4f 43 41 53 45 2c | 0a 20 20 20 20 20 20 20 | NOCASE,|. |
|00002150| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00002160| 20 20 20 20 20 20 20 55 | 4e 49 51 55 45 28 6e 61 | U|NIQUE(na|
|00002170| 6d 65 29 0a 20 20 20 20 | 20 20 20 20 20 20 20 20 |me). | |
|00002180| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00002190| 20 29 3b 0a 20 20 20 20 | 20 20 20 20 43 52 45 41 | );. | CREA|
|000021a0| 54 45 20 49 4e 44 45 58 | 20 61 75 74 68 6f 72 73 |TE INDEX| authors|
|000021b0| 5f 69 64 78 20 4f 4e 20 | 61 75 74 68 6f 72 73 20 |_idx ON |authors |
|000021c0| 28 73 6f 72 74 20 43 4f | 4c 4c 41 54 45 20 4e 4f |(sort CO|LLATE NO|
|000021d0| 43 41 53 45 29 3b 0a 20 | 20 20 20 20 20 20 20 43 |CASE);. | C|
|000021e0| 52 45 41 54 45 20 54 52 | 49 47 47 45 52 20 61 75 |REATE TR|IGGER au|
|000021f0| 74 68 6f 72 73 5f 69 6e | 73 65 72 74 5f 74 72 67 |thors_in|sert_trg|
|00002200| 0a 20 20 20 20 20 20 20 | 20 41 46 54 45 52 20 49 |. | AFTER I|
|00002210| 4e 53 45 52 54 20 4f 4e | 20 61 75 74 68 6f 72 73 |NSERT ON| authors|
|00002220| 0a 20 20 20 20 20 20 20 | 20 42 45 47 49 4e 0a 20 |. | BEGIN. |
|00002230| 20 20 20 20 20 20 20 20 | 20 55 50 44 41 54 45 20 | | UPDATE |
|00002240| 61 75 74 68 6f 72 73 20 | 53 45 54 20 73 6f 72 74 |authors |SET sort|
|00002250| 3d 4e 45 57 2e 6e 61 6d | 65 20 57 48 45 52 45 20 |=NEW.nam|e WHERE |
|00002260| 69 64 3d 4e 45 57 2e 69 | 64 3b 0a 20 20 20 20 20 |id=NEW.i|d;. |
|00002270| 20 20 20 45 4e 44 3b 0a | 20 20 20 20 20 20 20 20 | END;.| |
|00002280| 43 52 45 41 54 45 20 54 | 52 49 47 47 45 52 20 61 |CREATE T|RIGGER a|
|00002290| 75 74 68 6f 72 73 5f 75 | 70 64 61 74 65 5f 74 72 |uthors_u|pdate_tr|
|000022a0| 67 0a 20 20 20 20 20 20 | 20 20 41 46 54 45 52 20 |g. | AFTER |
|000022b0| 55 50 44 41 54 45 20 4f | 4e 20 61 75 74 68 6f 72 |UPDATE O|N author|
|000022c0| 73 0a 20 20 20 20 20 20 | 20 20 42 45 47 49 4e 0a |s. | BEGIN.|
|000022d0| 20 20 20 20 20 20 20 20 | 20 20 55 50 44 41 54 45 | | UPDATE|
|000022e0| 20 61 75 74 68 6f 72 73 | 20 53 45 54 20 73 6f 72 | authors| SET sor|
|000022f0| 74 3d 4e 45 57 2e 6e 61 | 6d 65 20 57 48 45 52 45 |t=NEW.na|me WHERE|
|00002300| 20 69 64 3d 4e 45 57 2e | 69 64 3b 0a 20 20 20 20 | id=NEW.|id;. |
|00002310| 20 20 20 20 45 4e 44 3b | 0a 20 20 20 20 20 20 20 | END;|. |
|00002320| 20 43 52 45 41 54 45 20 | 54 41 42 4c 45 20 62 6f | CREATE |TABLE bo|
|00002330| 6f 6b 73 5f 61 75 74 68 | 6f 72 73 5f 6c 69 6e 6b |oks_auth|ors_link|
|00002340| 20 28 20 69 64 20 49 4e | 54 45 47 45 52 20 50 52 | ( id IN|TEGER PR|
|00002350| 49 4d 41 52 59 20 4b 45 | 59 2c 0a 20 20 20 20 20 |IMARY KE|Y,. |
|00002360| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00002370| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00002380| 20 20 20 20 20 62 6f 6f | 6b 20 49 4e 54 45 47 45 | boo|k INTEGE|
|00002390| 52 20 4e 4f 54 20 4e 55 | 4c 4c 2c 0a 20 20 20 20 |R NOT NU|LL,. |
|000023a0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|000023b0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|000023c0| 20 20 20 20 20 20 61 75 | 74 68 6f 72 20 49 4e 54 | au|thor INT|
|000023d0| 45 47 45 52 20 4e 4f 54 | 20 4e 55 4c 4c 2c 0a 20 |EGER NOT| NULL,. |
|000023e0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|000023f0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00002400| 20 20 20 20 20 20 20 20 | 20 55 4e 49 51 55 45 28 | | UNIQUE(|
|00002410| 62 6f 6f 6b 2c 20 61 75 | 74 68 6f 72 29 0a 20 20 |book, au|thor). |
|00002420| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00002430| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00002440| 20 20 20 20 20 20 29 3b | 0a 20 20 20 20 20 20 20 | );|. |
|00002450| 20 43 52 45 41 54 45 20 | 49 4e 44 45 58 20 62 6f | CREATE |INDEX bo|
|00002460| 6f 6b 73 5f 61 75 74 68 | 6f 72 73 5f 6c 69 6e 6b |oks_auth|ors_link|
|00002470| 5f 62 69 64 78 20 4f 4e | 20 62 6f 6f 6b 73 5f 61 |_bidx ON| books_a|
|00002480| 75 74 68 6f 72 73 5f 6c | 69 6e 6b 20 28 62 6f 6f |uthors_l|ink (boo|
|00002490| 6b 29 3b 0a 20 20 20 20 | 20 20 20 20 43 52 45 41 |k);. | CREA|
|000024a0| 54 45 20 49 4e 44 45 58 | 20 62 6f 6f 6b 73 5f 61 |TE INDEX| books_a|
|000024b0| 75 74 68 6f 72 73 5f 6c | 69 6e 6b 5f 61 69 64 78 |uthors_l|ink_aidx|
|000024c0| 20 4f 4e 20 62 6f 6f 6b | 73 5f 61 75 74 68 6f 72 | ON book|s_author|
|000024d0| 73 5f 6c 69 6e 6b 20 28 | 61 75 74 68 6f 72 29 3b |s_link (|author);|
|000024e0| 0a 0a 20 20 20 20 20 20 | 20 20 43 52 45 41 54 45 |.. | CREATE|
|000024f0| 20 54 52 49 47 47 45 52 | 20 66 6b 63 5f 69 6e 73 | TRIGGER| fkc_ins|
|00002500| 65 72 74 5f 62 6f 6f 6b | 73 5f 61 75 74 68 6f 72 |ert_book|s_author|
|00002510| 73 5f 6c 69 6e 6b 0a 20 | 20 20 20 20 20 20 20 42 |s_link. | B|
|00002520| 45 46 4f 52 45 20 49 4e | 53 45 52 54 20 4f 4e 20 |EFORE IN|SERT ON |
|00002530| 62 6f 6f 6b 73 5f 61 75 | 74 68 6f 72 73 5f 6c 69 |books_au|thors_li|
|00002540| 6e 6b 0a 20 20 20 20 20 | 20 20 20 42 45 47 49 4e |nk. | BEGIN|
|00002550| 0a 20 20 20 20 20 20 20 | 20 20 20 53 45 4c 45 43 |. | SELEC|
|00002560| 54 20 43 41 53 45 0a 20 | 20 20 20 20 20 20 20 20 |T CASE. | |
|00002570| 20 20 20 20 20 57 48 45 | 4e 20 28 53 45 4c 45 43 | WHE|N (SELEC|
|00002580| 54 20 69 64 20 66 72 6f | 6d 20 62 6f 6f 6b 73 20 |T id fro|m books |
|00002590| 57 48 45 52 45 20 69 64 | 3d 4e 45 57 2e 62 6f 6f |WHERE id|=NEW.boo|
|000025a0| 6b 29 20 49 53 20 4e 55 | 4c 4c 0a 20 20 20 20 20 |k) IS NU|LL. |
|000025b0| 20 20 20 20 20 20 20 20 | 20 54 48 45 4e 20 52 41 | | THEN RA|
|000025c0| 49 53 45 28 41 42 4f 52 | 54 2c 20 27 46 6f 72 65 |ISE(ABOR|T, 'Fore|
|000025d0| 69 67 6e 20 6b 65 79 20 | 76 69 6f 6c 61 74 69 6f |ign key |violatio|
|000025e0| 6e 3a 20 62 6f 6f 6b 20 | 6e 6f 74 20 69 6e 20 62 |n: book |not in b|
|000025f0| 6f 6f 6b 73 27 29 0a 20 | 20 20 20 20 20 20 20 20 |ooks'). | |
|00002600| 20 20 20 20 20 57 48 45 | 4e 20 28 53 45 4c 45 43 | WHE|N (SELEC|
|00002610| 54 20 69 64 20 66 72 6f | 6d 20 61 75 74 68 6f 72 |T id fro|m author|
|00002620| 73 20 57 48 45 52 45 20 | 69 64 3d 4e 45 57 2e 61 |s WHERE |id=NEW.a|
|00002630| 75 74 68 6f 72 29 20 49 | 53 20 4e 55 4c 4c 0a 20 |uthor) I|S NULL. |
|00002640| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 54 48 45 | | THE|
|00002650| 4e 20 52 41 49 53 45 28 | 41 42 4f 52 54 2c 20 27 |N RAISE(|ABORT, '|
|00002660| 46 6f 72 65 69 67 6e 20 | 6b 65 79 20 76 69 6f 6c |Foreign |key viol|
|00002670| 61 74 69 6f 6e 3a 20 61 | 75 74 68 6f 72 20 6e 6f |ation: a|uthor no|
|00002680| 74 20 69 6e 20 61 75 74 | 68 6f 72 73 27 29 0a 20 |t in aut|hors'). |
|00002690| 20 20 20 20 20 20 20 20 | 20 45 4e 44 3b 0a 20 20 | | END;. |
|000026a0| 20 20 20 20 20 20 45 4e | 44 3b 0a 20 20 20 20 20 | EN|D;. |
|000026b0| 20 20 20 43 52 45 41 54 | 45 20 54 52 49 47 47 45 | CREAT|E TRIGGE|
|000026c0| 52 20 66 6b 63 5f 75 70 | 64 61 74 65 5f 62 6f 6f |R fkc_up|date_boo|
|000026d0| 6b 73 5f 61 75 74 68 6f | 72 73 5f 6c 69 6e 6b 5f |ks_autho|rs_link_|
|000026e0| 61 0a 20 20 20 20 20 20 | 20 20 42 45 46 4f 52 45 |a. | BEFORE|
|000026f0| 20 55 50 44 41 54 45 20 | 4f 46 20 62 6f 6f 6b 20 | UPDATE |OF book |
|00002700| 4f 4e 20 62 6f 6f 6b 73 | 5f 61 75 74 68 6f 72 73 |ON books|_authors|
|00002710| 5f 6c 69 6e 6b 0a 20 20 | 20 20 20 20 20 20 42 45 |_link. | BE|
|00002720| 47 49 4e 0a 20 20 20 20 | 20 20 20 20 20 20 20 20 |GIN. | |
|00002730| 53 45 4c 45 43 54 20 43 | 41 53 45 0a 20 20 20 20 |SELECT C|ASE. |
|00002740| 20 20 20 20 20 20 20 20 | 20 20 20 20 57 48 45 4e | | WHEN|
|00002750| 20 28 53 45 4c 45 43 54 | 20 69 64 20 66 72 6f 6d | (SELECT| id from|
|00002760| 20 62 6f 6f 6b 73 20 57 | 48 45 52 45 20 69 64 3d | books W|HERE id=|
|00002770| 4e 45 57 2e 62 6f 6f 6b | 29 20 49 53 20 4e 55 4c |NEW.book|) IS NUL|
|00002780| 4c 0a 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |L. | |
|00002790| 20 20 54 48 45 4e 20 52 | 41 49 53 45 28 41 42 4f | THEN R|AISE(ABO|
|000027a0| 52 54 2c 20 27 46 6f 72 | 65 69 67 6e 20 6b 65 79 |RT, 'For|eign key|
|000027b0| 20 76 69 6f 6c 61 74 69 | 6f 6e 3a 20 62 6f 6f 6b | violati|on: book|
|000027c0| 20 6e 6f 74 20 69 6e 20 | 62 6f 6f 6b 73 27 29 0a | not in |books').|
|000027d0| 20 20 20 20 20 20 20 20 | 20 20 20 20 45 4e 44 3b | | END;|
|000027e0| 0a 20 20 20 20 20 20 20 | 20 45 4e 44 3b 0a 20 20 |. | END;. |
|000027f0| 20 20 20 20 20 20 43 52 | 45 41 54 45 20 54 52 49 | CR|EATE TRI|
|00002800| 47 47 45 52 20 66 6b 63 | 5f 75 70 64 61 74 65 5f |GGER fkc|_update_|
|00002810| 62 6f 6f 6b 73 5f 61 75 | 74 68 6f 72 73 5f 6c 69 |books_au|thors_li|
|00002820| 6e 6b 5f 62 0a 20 20 20 | 20 20 20 20 20 42 45 46 |nk_b. | BEF|
|00002830| 4f 52 45 20 55 50 44 41 | 54 45 20 4f 46 20 61 75 |ORE UPDA|TE OF au|
|00002840| 74 68 6f 72 20 4f 4e 20 | 62 6f 6f 6b 73 5f 61 75 |thor ON |books_au|
|00002850| 74 68 6f 72 73 5f 6c 69 | 6e 6b 0a 20 20 20 20 20 |thors_li|nk. |
|00002860| 20 20 20 42 45 47 49 4e | 0a 20 20 20 20 20 20 20 | BEGIN|. |
|00002870| 20 20 20 20 20 53 45 4c | 45 43 54 20 43 41 53 45 | SEL|ECT CASE|
|00002880| 0a 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |. | |
|00002890| 20 57 48 45 4e 20 28 53 | 45 4c 45 43 54 20 69 64 | WHEN (S|ELECT id|
|000028a0| 20 66 72 6f 6d 20 61 75 | 74 68 6f 72 73 20 57 48 | from au|thors WH|
|000028b0| 45 52 45 20 69 64 3d 4e | 45 57 2e 61 75 74 68 6f |ERE id=N|EW.autho|
|000028c0| 72 29 20 49 53 20 4e 55 | 4c 4c 0a 20 20 20 20 20 |r) IS NU|LL. |
|000028d0| 20 20 20 20 20 20 20 20 | 20 20 20 54 48 45 4e 20 | | THEN |
|000028e0| 52 41 49 53 45 28 41 42 | 4f 52 54 2c 20 27 46 6f |RAISE(AB|ORT, 'Fo|
|000028f0| 72 65 69 67 6e 20 6b 65 | 79 20 76 69 6f 6c 61 74 |reign ke|y violat|
|00002900| 69 6f 6e 3a 20 61 75 74 | 68 6f 72 20 6e 6f 74 20 |ion: aut|hor not |
|00002910| 69 6e 20 61 75 74 68 6f | 72 73 27 29 0a 20 20 20 |in autho|rs'). |
|00002920| 20 20 20 20 20 20 20 20 | 20 45 4e 44 3b 0a 20 20 | | END;. |
|00002930| 20 20 20 20 20 20 45 4e | 44 3b 0a 20 20 20 20 20 | EN|D;. |
|00002940| 20 20 20 43 52 45 41 54 | 45 20 54 52 49 47 47 45 | CREAT|E TRIGGE|
|00002950| 52 20 66 6b 63 5f 64 65 | 6c 65 74 65 5f 62 6f 6f |R fkc_de|lete_boo|
|00002960| 6b 73 5f 61 75 74 68 6f | 72 73 5f 6c 69 6e 6b 0a |ks_autho|rs_link.|
|00002970| 20 20 20 20 20 20 20 20 | 42 45 46 4f 52 45 20 44 | |BEFORE D|
|00002980| 45 4c 45 54 45 20 4f 4e | 20 61 75 74 68 6f 72 73 |ELETE ON| authors|
|00002990| 0a 20 20 20 20 20 20 20 | 20 42 45 47 49 4e 0a 20 |. | BEGIN. |
|000029a0| 20 20 20 20 20 20 20 20 | 20 20 20 53 45 4c 45 43 | | SELEC|
|000029b0| 54 20 43 41 53 45 0a 20 | 20 20 20 20 20 20 20 20 |T CASE. | |
|000029c0| 20 20 20 20 20 20 20 57 | 48 45 4e 20 28 53 45 4c | W|HEN (SEL|
|000029d0| 45 43 54 20 43 4f 55 4e | 54 28 69 64 29 20 46 52 |ECT COUN|T(id) FR|
|000029e0| 4f 4d 20 62 6f 6f 6b 73 | 5f 61 75 74 68 6f 72 73 |OM books|_authors|
|000029f0| 5f 6c 69 6e 6b 20 57 48 | 45 52 45 20 62 6f 6f 6b |_link WH|ERE book|
|00002a00| 3d 4f 4c 44 2e 62 6f 6f | 6b 29 20 3e 20 30 0a 20 |=OLD.boo|k) > 0. |
|00002a10| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 54 | | T|
|00002a20| 48 45 4e 20 52 41 49 53 | 45 28 41 42 4f 52 54 2c |HEN RAIS|E(ABORT,|
|00002a30| 20 27 46 6f 72 65 69 67 | 6e 20 6b 65 79 20 76 69 | 'Foreig|n key vi|
|00002a40| 6f 6c 61 74 69 6f 6e 3a | 20 61 75 74 68 6f 72 20 |olation:| author |
|00002a50| 69 73 20 73 74 69 6c 6c | 20 72 65 66 65 72 65 6e |is still| referen|
|00002a60| 63 65 64 27 29 0a 20 20 | 20 20 20 20 20 20 20 20 |ced'). | |
|00002a70| 20 20 45 4e 44 3b 0a 20 | 20 20 20 20 20 20 20 45 | END;. | E|
|00002a80| 4e 44 3b 0a 0a 20 20 20 | 20 20 20 20 20 2f 2a 2a |ND;.. | /**|
|00002a90| 2a 2a 2a 20 70 75 62 6c | 69 73 68 65 72 73 20 74 |*** publ|ishers t|
|00002aa0| 61 62 6c 65 20 2a 2a 2a | 2a 2a 2f 0a 20 20 20 20 |able ***|**/. |
|00002ab0| 20 20 20 20 43 52 45 41 | 54 45 20 54 41 42 4c 45 | CREA|TE TABLE|
|00002ac0| 20 70 75 62 6c 69 73 68 | 65 72 73 20 28 20 69 64 | publish|ers ( id|
|00002ad0| 20 20 20 49 4e 54 45 47 | 45 52 20 50 52 49 4d 41 | INTEG|ER PRIMA|
|00002ae0| 52 59 20 4b 45 59 2c 0a | 20 20 20 20 20 20 20 20 |RY KEY,.| |
|00002af0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00002b00| 20 20 20 20 20 20 20 20 | 20 20 6e 61 6d 65 20 54 | | name T|
|00002b10| 45 58 54 20 4e 4f 54 20 | 4e 55 4c 4c 20 43 4f 4c |EXT NOT |NULL COL|
|00002b20| 4c 41 54 45 20 4e 4f 43 | 41 53 45 2c 0a 20 20 20 |LATE NOC|ASE,. |
|00002b30| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00002b40| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 73 | | s|
|00002b50| 6f 72 74 20 54 45 58 54 | 20 43 4f 4c 4c 41 54 45 |ort TEXT| COLLATE|
|00002b60| 20 4e 4f 43 41 53 45 2c | 0a 20 20 20 20 20 20 20 | NOCASE,|. |
|00002b70| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00002b80| 20 20 20 20 20 20 20 20 | 20 20 20 55 4e 49 51 55 | | UNIQU|
|00002b90| 45 28 6e 61 6d 65 29 0a | 20 20 20 20 20 20 20 20 |E(name).| |
|00002ba0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00002bb0| 20 20 20 20 20 29 3b 0a | 20 20 20 20 20 20 20 20 | );.| |
|00002bc0| 43 52 45 41 54 45 20 49 | 4e 44 45 58 20 70 75 62 |CREATE I|NDEX pub|
|00002bd0| 6c 69 73 68 65 72 73 5f | 69 64 78 20 4f 4e 20 70 |lishers_|idx ON p|
|00002be0| 75 62 6c 69 73 68 65 72 | 73 20 28 73 6f 72 74 20 |ublisher|s (sort |
|00002bf0| 43 4f 4c 4c 41 54 45 20 | 4e 4f 43 41 53 45 29 3b |COLLATE |NOCASE);|
|00002c00| 0a 20 20 20 20 20 20 20 | 20 43 52 45 41 54 45 20 |. | CREATE |
|00002c10| 54 52 49 47 47 45 52 20 | 70 75 62 6c 69 73 68 65 |TRIGGER |publishe|
|00002c20| 72 73 5f 69 6e 73 65 72 | 74 5f 74 72 67 0a 20 20 |rs_inser|t_trg. |
|00002c30| 20 20 20 20 20 20 41 46 | 54 45 52 20 49 4e 53 45 | AF|TER INSE|
|00002c40| 52 54 20 4f 4e 20 70 75 | 62 6c 69 73 68 65 72 73 |RT ON pu|blishers|
|00002c50| 0a 20 20 20 20 20 20 20 | 20 42 45 47 49 4e 0a 20 |. | BEGIN. |
|00002c60| 20 20 20 20 20 20 20 20 | 20 55 50 44 41 54 45 20 | | UPDATE |
|00002c70| 70 75 62 6c 69 73 68 65 | 72 73 20 53 45 54 20 73 |publishe|rs SET s|
|00002c80| 6f 72 74 3d 4e 45 57 2e | 6e 61 6d 65 20 57 48 45 |ort=NEW.|name WHE|
|00002c90| 52 45 20 69 64 3d 4e 45 | 57 2e 69 64 3b 0a 20 20 |RE id=NE|W.id;. |
|00002ca0| 20 20 20 20 20 20 45 4e | 44 3b 0a 20 20 20 20 20 | EN|D;. |
|00002cb0| 20 20 20 43 52 45 41 54 | 45 20 54 52 49 47 47 45 | CREAT|E TRIGGE|
|00002cc0| 52 20 70 75 62 6c 69 73 | 68 65 72 73 5f 75 70 64 |R publis|hers_upd|
|00002cd0| 61 74 65 5f 74 72 67 0a | 20 20 20 20 20 20 20 20 |ate_trg.| |
|00002ce0| 41 46 54 45 52 20 55 50 | 44 41 54 45 20 4f 4e 20 |AFTER UP|DATE ON |
|00002cf0| 70 75 62 6c 69 73 68 65 | 72 73 0a 20 20 20 20 20 |publishe|rs. |
|00002d00| 20 20 20 42 45 47 49 4e | 0a 20 20 20 20 20 20 20 | BEGIN|. |
|00002d10| 20 20 20 55 50 44 41 54 | 45 20 70 75 62 6c 69 73 | UPDAT|E publis|
|00002d20| 68 65 72 73 20 53 45 54 | 20 73 6f 72 74 3d 4e 45 |hers SET| sort=NE|
|00002d30| 57 2e 6e 61 6d 65 20 57 | 48 45 52 45 20 69 64 3d |W.name W|HERE id=|
|00002d40| 4e 45 57 2e 69 64 3b 0a | 20 20 20 20 20 20 20 20 |NEW.id;.| |
|00002d50| 45 4e 44 3b 0a 20 20 20 | 20 20 20 20 20 43 52 45 |END;. | CRE|
|00002d60| 41 54 45 20 54 41 42 4c | 45 20 62 6f 6f 6b 73 5f |ATE TABL|E books_|
|00002d70| 70 75 62 6c 69 73 68 65 | 72 73 5f 6c 69 6e 6b 20 |publishe|rs_link |
|00002d80| 28 20 69 64 20 49 4e 54 | 45 47 45 52 20 50 52 49 |( id INT|EGER PRI|
|00002d90| 4d 41 52 59 20 4b 45 59 | 2c 0a 20 20 20 20 20 20 |MARY KEY|,. |
|00002da0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00002db0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00002dc0| 20 20 20 20 62 6f 6f 6b | 20 49 4e 54 45 47 45 52 | book| INTEGER|
|00002dd0| 20 4e 4f 54 20 4e 55 4c | 4c 2c 0a 20 20 20 20 20 | NOT NUL|L,. |
|00002de0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00002df0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00002e00| 20 20 20 20 20 70 75 62 | 6c 69 73 68 65 72 20 49 | pub|lisher I|
|00002e10| 4e 54 45 47 45 52 20 4e | 4f 54 20 4e 55 4c 4c 2c |NTEGER N|OT NULL,|
|00002e20| 0a 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |. | |
|00002e30| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00002e40| 20 20 20 20 20 20 20 20 | 20 20 20 55 4e 49 51 55 | | UNIQU|
|00002e50| 45 28 62 6f 6f 6b 29 0a | 20 20 20 20 20 20 20 20 |E(book).| |
|00002e60| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00002e70| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00002e80| 29 3b 0a 20 20 20 20 20 | 20 20 20 43 52 45 41 54 |);. | CREAT|
|00002e90| 45 20 49 4e 44 45 58 20 | 62 6f 6f 6b 73 5f 70 75 |E INDEX |books_pu|
|00002ea0| 62 6c 69 73 68 65 72 73 | 5f 6c 69 6e 6b 5f 62 69 |blishers|_link_bi|
|00002eb0| 64 78 20 4f 4e 20 62 6f | 6f 6b 73 5f 70 75 62 6c |dx ON bo|oks_publ|
|00002ec0| 69 73 68 65 72 73 5f 6c | 69 6e 6b 20 28 62 6f 6f |ishers_l|ink (boo|
|00002ed0| 6b 29 3b 0a 20 20 20 20 | 20 20 20 20 43 52 45 41 |k);. | CREA|
|00002ee0| 54 45 20 49 4e 44 45 58 | 20 62 6f 6f 6b 73 5f 70 |TE INDEX| books_p|
|00002ef0| 75 62 6c 69 73 68 65 72 | 73 5f 6c 69 6e 6b 5f 61 |ublisher|s_link_a|
|00002f00| 69 64 78 20 4f 4e 20 62 | 6f 6f 6b 73 5f 70 75 62 |idx ON b|ooks_pub|
|00002f10| 6c 69 73 68 65 72 73 5f | 6c 69 6e 6b 20 28 70 75 |lishers_|link (pu|
|00002f20| 62 6c 69 73 68 65 72 29 | 3b 0a 0a 20 20 20 20 20 |blisher)|;.. |
|00002f30| 20 20 20 43 52 45 41 54 | 45 20 54 52 49 47 47 45 | CREAT|E TRIGGE|
|00002f40| 52 20 66 6b 63 5f 69 6e | 73 65 72 74 5f 62 6f 6f |R fkc_in|sert_boo|
|00002f50| 6b 73 5f 70 75 62 6c 69 | 73 68 65 72 73 5f 6c 69 |ks_publi|shers_li|
|00002f60| 6e 6b 0a 20 20 20 20 20 | 20 20 20 42 45 46 4f 52 |nk. | BEFOR|
|00002f70| 45 20 49 4e 53 45 52 54 | 20 4f 4e 20 62 6f 6f 6b |E INSERT| ON book|
|00002f80| 73 5f 70 75 62 6c 69 73 | 68 65 72 73 5f 6c 69 6e |s_publis|hers_lin|
|00002f90| 6b 0a 20 20 20 20 20 20 | 20 20 42 45 47 49 4e 0a |k. | BEGIN.|
|00002fa0| 20 20 20 20 20 20 20 20 | 20 20 53 45 4c 45 43 54 | | SELECT|
|00002fb0| 20 43 41 53 45 0a 20 20 | 20 20 20 20 20 20 20 20 | CASE. | |
|00002fc0| 20 20 20 20 57 48 45 4e | 20 28 53 45 4c 45 43 54 | WHEN| (SELECT|
|00002fd0| 20 69 64 20 66 72 6f 6d | 20 62 6f 6f 6b 73 20 57 | id from| books W|
|00002fe0| 48 45 52 45 20 69 64 3d | 4e 45 57 2e 62 6f 6f 6b |HERE id=|NEW.book|
|00002ff0| 29 20 49 53 20 4e 55 4c | 4c 0a 20 20 20 20 20 20 |) IS NUL|L. |
|00003000| 20 20 20 20 20 20 20 20 | 54 48 45 4e 20 52 41 49 | |THEN RAI|
|00003010| 53 45 28 41 42 4f 52 54 | 2c 20 27 46 6f 72 65 69 |SE(ABORT|, 'Forei|
|00003020| 67 6e 20 6b 65 79 20 76 | 69 6f 6c 61 74 69 6f 6e |gn key v|iolation|
|00003030| 3a 20 62 6f 6f 6b 20 6e | 6f 74 20 69 6e 20 62 6f |: book n|ot in bo|
|00003040| 6f 6b 73 27 29 0a 20 20 | 20 20 20 20 20 20 20 20 |oks'). | |
|00003050| 20 20 20 20 57 48 45 4e | 20 28 53 45 4c 45 43 54 | WHEN| (SELECT|
|00003060| 20 69 64 20 66 72 6f 6d | 20 70 75 62 6c 69 73 68 | id from| publish|
|00003070| 65 72 73 20 57 48 45 52 | 45 20 69 64 3d 4e 45 57 |ers WHER|E id=NEW|
|00003080| 2e 70 75 62 6c 69 73 68 | 65 72 29 20 49 53 20 4e |.publish|er) IS N|
|00003090| 55 4c 4c 0a 20 20 20 20 | 20 20 20 20 20 20 20 20 |ULL. | |
|000030a0| 20 20 54 48 45 4e 20 52 | 41 49 53 45 28 41 42 4f | THEN R|AISE(ABO|
|000030b0| 52 54 2c 20 27 46 6f 72 | 65 69 67 6e 20 6b 65 79 |RT, 'For|eign key|
|000030c0| 20 76 69 6f 6c 61 74 69 | 6f 6e 3a 20 70 75 62 6c | violati|on: publ|
|000030d0| 69 73 68 65 72 20 6e 6f | 74 20 69 6e 20 70 75 62 |isher no|t in pub|
|000030e0| 6c 69 73 68 65 72 73 27 | 29 0a 20 20 20 20 20 20 |lishers'|). |
|000030f0| 20 20 20 20 45 4e 44 3b | 0a 20 20 20 20 20 20 20 | END;|. |
|00003100| 20 45 4e 44 3b 0a 20 20 | 20 20 20 20 20 20 43 52 | END;. | CR|
|00003110| 45 41 54 45 20 54 52 49 | 47 47 45 52 20 66 6b 63 |EATE TRI|GGER fkc|
|00003120| 5f 75 70 64 61 74 65 5f | 62 6f 6f 6b 73 5f 70 75 |_update_|books_pu|
|00003130| 62 6c 69 73 68 65 72 73 | 5f 6c 69 6e 6b 5f 61 0a |blishers|_link_a.|
|00003140| 20 20 20 20 20 20 20 20 | 42 45 46 4f 52 45 20 55 | |BEFORE U|
|00003150| 50 44 41 54 45 20 4f 46 | 20 62 6f 6f 6b 20 4f 4e |PDATE OF| book ON|
|00003160| 20 62 6f 6f 6b 73 5f 70 | 75 62 6c 69 73 68 65 72 | books_p|ublisher|
|00003170| 73 5f 6c 69 6e 6b 0a 20 | 20 20 20 20 20 20 20 42 |s_link. | B|
|00003180| 45 47 49 4e 0a 20 20 20 | 20 20 20 20 20 20 20 20 |EGIN. | |
|00003190| 20 53 45 4c 45 43 54 20 | 43 41 53 45 0a 20 20 20 | SELECT |CASE. |
|000031a0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 57 48 45 | | WHE|
|000031b0| 4e 20 28 53 45 4c 45 43 | 54 20 69 64 20 66 72 6f |N (SELEC|T id fro|
|000031c0| 6d 20 62 6f 6f 6b 73 20 | 57 48 45 52 45 20 69 64 |m books |WHERE id|
|000031d0| 3d 4e 45 57 2e 62 6f 6f | 6b 29 20 49 53 20 4e 55 |=NEW.boo|k) IS NU|
|000031e0| 4c 4c 0a 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |LL. | |
|000031f0| 20 20 20 54 48 45 4e 20 | 52 41 49 53 45 28 41 42 | THEN |RAISE(AB|
|00003200| 4f 52 54 2c 20 27 46 6f | 72 65 69 67 6e 20 6b 65 |ORT, 'Fo|reign ke|
|00003210| 79 20 76 69 6f 6c 61 74 | 69 6f 6e 3a 20 62 6f 6f |y violat|ion: boo|
|00003220| 6b 20 6e 6f 74 20 69 6e | 20 62 6f 6f 6b 73 27 29 |k not in| books')|
|00003230| 0a 20 20 20 20 20 20 20 | 20 20 20 20 20 45 4e 44 |. | END|
|00003240| 3b 0a 20 20 20 20 20 20 | 20 20 45 4e 44 3b 0a 20 |;. | END;. |
|00003250| 20 20 20 20 20 20 20 43 | 52 45 41 54 45 20 54 52 | C|REATE TR|
|00003260| 49 47 47 45 52 20 66 6b | 63 5f 75 70 64 61 74 65 |IGGER fk|c_update|
|00003270| 5f 62 6f 6f 6b 73 5f 70 | 75 62 6c 69 73 68 65 72 |_books_p|ublisher|
|00003280| 73 5f 6c 69 6e 6b 5f 62 | 0a 20 20 20 20 20 20 20 |s_link_b|. |
|00003290| 20 42 45 46 4f 52 45 20 | 55 50 44 41 54 45 20 4f | BEFORE |UPDATE O|
|000032a0| 46 20 70 75 62 6c 69 73 | 68 65 72 20 4f 4e 20 62 |F publis|her ON b|
|000032b0| 6f 6f 6b 73 5f 70 75 62 | 6c 69 73 68 65 72 73 5f |ooks_pub|lishers_|
|000032c0| 6c 69 6e 6b 0a 20 20 20 | 20 20 20 20 20 42 45 47 |link. | BEG|
|000032d0| 49 4e 0a 20 20 20 20 20 | 20 20 20 20 20 20 20 53 |IN. | S|
|000032e0| 45 4c 45 43 54 20 43 41 | 53 45 0a 20 20 20 20 20 |ELECT CA|SE. |
|000032f0| 20 20 20 20 20 20 20 20 | 20 20 20 57 48 45 4e 20 | | WHEN |
|00003300| 28 53 45 4c 45 43 54 20 | 69 64 20 66 72 6f 6d 20 |(SELECT |id from |
|00003310| 70 75 62 6c 69 73 68 65 | 72 73 20 57 48 45 52 45 |publishe|rs WHERE|
|00003320| 20 69 64 3d 4e 45 57 2e | 70 75 62 6c 69 73 68 65 | id=NEW.|publishe|
|00003330| 72 29 20 49 53 20 4e 55 | 4c 4c 0a 20 20 20 20 20 |r) IS NU|LL. |
|00003340| 20 20 20 20 20 20 20 20 | 20 20 20 54 48 45 4e 20 | | THEN |
|00003350| 52 41 49 53 45 28 41 42 | 4f 52 54 2c 20 27 46 6f |RAISE(AB|ORT, 'Fo|
|00003360| 72 65 69 67 6e 20 6b 65 | 79 20 76 69 6f 6c 61 74 |reign ke|y violat|
|00003370| 69 6f 6e 3a 20 70 75 62 | 6c 69 73 68 65 72 20 6e |ion: pub|lisher n|
|00003380| 6f 74 20 69 6e 20 70 75 | 62 6c 69 73 68 65 72 73 |ot in pu|blishers|
|00003390| 27 29 0a 20 20 20 20 20 | 20 20 20 20 20 20 20 45 |'). | E|
|000033a0| 4e 44 3b 0a 20 20 20 20 | 20 20 20 20 45 4e 44 3b |ND;. | END;|
|000033b0| 0a 20 20 20 20 20 20 20 | 20 43 52 45 41 54 45 20 |. | CREATE |
|000033c0| 54 52 49 47 47 45 52 20 | 66 6b 63 5f 64 65 6c 65 |TRIGGER |fkc_dele|
|000033d0| 74 65 5f 62 6f 6f 6b 73 | 5f 70 75 62 6c 69 73 68 |te_books|_publish|
|000033e0| 65 72 73 5f 6c 69 6e 6b | 0a 20 20 20 20 20 20 20 |ers_link|. |
|000033f0| 20 42 45 46 4f 52 45 20 | 44 45 4c 45 54 45 20 4f | BEFORE |DELETE O|
|00003400| 4e 20 70 75 62 6c 69 73 | 68 65 72 73 0a 20 20 20 |N publis|hers. |
|00003410| 20 20 20 20 20 42 45 47 | 49 4e 0a 20 20 20 20 20 | BEG|IN. |
|00003420| 20 20 20 20 20 20 20 53 | 45 4c 45 43 54 20 43 41 | S|ELECT CA|
|00003430| 53 45 0a 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |SE. | |
|00003440| 20 20 20 57 48 45 4e 20 | 28 53 45 4c 45 43 54 20 | WHEN |(SELECT |
|00003450| 43 4f 55 4e 54 28 69 64 | 29 20 46 52 4f 4d 20 62 |COUNT(id|) FROM b|
|00003460| 6f 6f 6b 73 5f 70 75 62 | 6c 69 73 68 65 72 73 5f |ooks_pub|lishers_|
|00003470| 6c 69 6e 6b 20 57 48 45 | 52 45 20 62 6f 6f 6b 3d |link WHE|RE book=|
|00003480| 4f 4c 44 2e 62 6f 6f 6b | 29 20 3e 20 30 0a 20 20 |OLD.book|) > 0. |
|00003490| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 54 48 | | TH|
|000034a0| 45 4e 20 52 41 49 53 45 | 28 41 42 4f 52 54 2c 20 |EN RAISE|(ABORT, |
|000034b0| 27 46 6f 72 65 69 67 6e | 20 6b 65 79 20 76 69 6f |'Foreign| key vio|
|000034c0| 6c 61 74 69 6f 6e 3a 20 | 70 75 62 6c 69 73 68 65 |lation: |publishe|
|000034d0| 72 20 69 73 20 73 74 69 | 6c 6c 20 72 65 66 65 72 |r is sti|ll refer|
|000034e0| 65 6e 63 65 64 27 29 0a | 20 20 20 20 20 20 20 20 |enced').| |
|000034f0| 20 20 20 20 45 4e 44 3b | 0a 20 20 20 20 20 20 20 | END;|. |
|00003500| 20 45 4e 44 3b 0a 0a 20 | 20 20 20 20 20 20 20 2f | END;.. | /|
|00003510| 2a 2a 2a 2a 2a 20 74 61 | 67 73 20 74 61 62 6c 65 |***** ta|gs table|
|00003520| 20 2a 2a 2a 2a 2a 2f 0a | 20 20 20 20 20 20 20 20 | *****/.| |
|00003530| 43 52 45 41 54 45 20 54 | 41 42 4c 45 20 74 61 67 |CREATE T|ABLE tag|
|00003540| 73 20 28 20 69 64 20 20 | 20 49 4e 54 45 47 45 52 |s ( id | INTEGER|
|00003550| 20 50 52 49 4d 41 52 59 | 20 4b 45 59 2c 0a 20 20 | PRIMARY| KEY,. |
|00003560| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00003570| 20 20 20 20 20 20 20 20 | 20 20 6e 61 6d 65 20 54 | | name T|
|00003580| 45 58 54 20 4e 4f 54 20 | 4e 55 4c 4c 20 43 4f 4c |EXT NOT |NULL COL|
|00003590| 4c 41 54 45 20 4e 4f 43 | 41 53 45 2c 0a 20 20 20 |LATE NOC|ASE,. |
|000035a0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|000035b0| 20 20 20 20 20 20 20 20 | 20 55 4e 49 51 55 45 20 | | UNIQUE |
|000035c0| 28 6e 61 6d 65 29 0a 20 | 20 20 20 20 20 20 20 20 |(name). | |
|000035d0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|000035e0| 20 20 20 20 29 3b 0a 20 | 20 20 20 20 20 20 20 43 | );. | C|
|000035f0| 52 45 41 54 45 20 49 4e | 44 45 58 20 74 61 67 73 |REATE IN|DEX tags|
|00003600| 5f 69 64 78 20 4f 4e 20 | 74 61 67 73 20 28 6e 61 |_idx ON |tags (na|
|00003610| 6d 65 20 43 4f 4c 4c 41 | 54 45 20 4e 4f 43 41 53 |me COLLA|TE NOCAS|
|00003620| 45 29 3b 0a 0a 20 20 20 | 20 20 20 20 20 43 52 45 |E);.. | CRE|
|00003630| 41 54 45 20 54 41 42 4c | 45 20 62 6f 6f 6b 73 5f |ATE TABL|E books_|
|00003640| 74 61 67 73 5f 6c 69 6e | 6b 20 28 20 69 64 20 49 |tags_lin|k ( id I|
|00003650| 4e 54 45 47 45 52 20 50 | 52 49 4d 41 52 59 20 4b |NTEGER P|RIMARY K|
|00003660| 45 59 2c 0a 20 20 20 20 | 20 20 20 20 20 20 20 20 |EY,. | |
|00003670| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00003680| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 62 6f | | bo|
|00003690| 6f 6b 20 49 4e 54 45 47 | 45 52 20 4e 4f 54 20 4e |ok INTEG|ER NOT N|
|000036a0| 55 4c 4c 2c 0a 20 20 20 | 20 20 20 20 20 20 20 20 |ULL,. | |
|000036b0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|000036c0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 74 | | t|
|000036d0| 61 67 20 49 4e 54 45 47 | 45 52 20 4e 4f 54 20 4e |ag INTEG|ER NOT N|
|000036e0| 55 4c 4c 2c 0a 20 20 20 | 20 20 20 20 20 20 20 20 |ULL,. | |
|000036f0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00003700| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 55 | | U|
|00003710| 4e 49 51 55 45 28 62 6f | 6f 6b 2c 20 74 61 67 29 |NIQUE(bo|ok, tag)|
|00003720| 0a 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |. | |
|00003730| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00003740| 20 20 20 20 20 20 20 20 | 20 29 3b 0a 20 20 20 20 | | );. |
|00003750| 20 20 20 20 43 52 45 41 | 54 45 20 49 4e 44 45 58 | CREA|TE INDEX|
|00003760| 20 62 6f 6f 6b 73 5f 74 | 61 67 73 5f 6c 69 6e 6b | books_t|ags_link|
|00003770| 5f 62 69 64 78 20 4f 4e | 20 62 6f 6f 6b 73 5f 74 |_bidx ON| books_t|
|00003780| 61 67 73 5f 6c 69 6e 6b | 20 28 62 6f 6f 6b 29 3b |ags_link| (book);|
|00003790| 0a 20 20 20 20 20 20 20 | 20 43 52 45 41 54 45 20 |. | CREATE |
|000037a0| 49 4e 44 45 58 20 62 6f | 6f 6b 73 5f 74 61 67 73 |INDEX bo|oks_tags|
|000037b0| 5f 6c 69 6e 6b 5f 61 69 | 64 78 20 4f 4e 20 62 6f |_link_ai|dx ON bo|
|000037c0| 6f 6b 73 5f 74 61 67 73 | 5f 6c 69 6e 6b 20 28 74 |oks_tags|_link (t|
|000037d0| 61 67 29 3b 0a 0a 20 20 | 20 20 20 20 20 20 43 52 |ag);.. | CR|
|000037e0| 45 41 54 45 20 54 52 49 | 47 47 45 52 20 66 6b 63 |EATE TRI|GGER fkc|
|000037f0| 5f 69 6e 73 65 72 74 5f | 62 6f 6f 6b 73 5f 74 61 |_insert_|books_ta|
|00003800| 67 73 5f 6c 69 6e 6b 0a | 20 20 20 20 20 20 20 20 |gs_link.| |
|00003810| 42 45 46 4f 52 45 20 49 | 4e 53 45 52 54 20 4f 4e |BEFORE I|NSERT ON|
|00003820| 20 62 6f 6f 6b 73 5f 74 | 61 67 73 5f 6c 69 6e 6b | books_t|ags_link|
|00003830| 0a 20 20 20 20 20 20 20 | 20 42 45 47 49 4e 0a 20 |. | BEGIN. |
|00003840| 20 20 20 20 20 20 20 20 | 20 53 45 4c 45 43 54 20 | | SELECT |
|00003850| 43 41 53 45 0a 20 20 20 | 20 20 20 20 20 20 20 20 |CASE. | |
|00003860| 20 20 20 57 48 45 4e 20 | 28 53 45 4c 45 43 54 20 | WHEN |(SELECT |
|00003870| 69 64 20 66 72 6f 6d 20 | 62 6f 6f 6b 73 20 57 48 |id from |books WH|
|00003880| 45 52 45 20 69 64 3d 4e | 45 57 2e 62 6f 6f 6b 29 |ERE id=N|EW.book)|
|00003890| 20 49 53 20 4e 55 4c 4c | 0a 20 20 20 20 20 20 20 | IS NULL|. |
|000038a0| 20 20 20 20 20 20 20 54 | 48 45 4e 20 52 41 49 53 | T|HEN RAIS|
|000038b0| 45 28 41 42 4f 52 54 2c | 20 27 46 6f 72 65 69 67 |E(ABORT,| 'Foreig|
|000038c0| 6e 20 6b 65 79 20 76 69 | 6f 6c 61 74 69 6f 6e 3a |n key vi|olation:|
|000038d0| 20 62 6f 6f 6b 20 6e 6f | 74 20 69 6e 20 62 6f 6f | book no|t in boo|
|000038e0| 6b 73 27 29 0a 20 20 20 | 20 20 20 20 20 20 20 20 |ks'). | |
|000038f0| 20 20 20 57 48 45 4e 20 | 28 53 45 4c 45 43 54 20 | WHEN |(SELECT |
|00003900| 69 64 20 66 72 6f 6d 20 | 74 61 67 73 20 57 48 45 |id from |tags WHE|
|00003910| 52 45 20 69 64 3d 4e 45 | 57 2e 74 61 67 29 20 49 |RE id=NE|W.tag) I|
|00003920| 53 20 4e 55 4c 4c 0a 20 | 20 20 20 20 20 20 20 20 |S NULL. | |
|00003930| 20 20 20 20 20 54 48 45 | 4e 20 52 41 49 53 45 28 | THE|N RAISE(|
|00003940| 41 42 4f 52 54 2c 20 27 | 46 6f 72 65 69 67 6e 20 |ABORT, '|Foreign |
|00003950| 6b 65 79 20 76 69 6f 6c | 61 74 69 6f 6e 3a 20 74 |key viol|ation: t|
|00003960| 61 67 20 6e 6f 74 20 69 | 6e 20 74 61 67 73 27 29 |ag not i|n tags')|
|00003970| 0a 20 20 20 20 20 20 20 | 20 20 20 45 4e 44 3b 0a |. | END;.|
|00003980| 20 20 20 20 20 20 20 20 | 45 4e 44 3b 0a 20 20 20 | |END;. |
|00003990| 20 20 20 20 20 43 52 45 | 41 54 45 20 54 52 49 47 | CRE|ATE TRIG|
|000039a0| 47 45 52 20 66 6b 63 5f | 75 70 64 61 74 65 5f 62 |GER fkc_|update_b|
|000039b0| 6f 6f 6b 73 5f 74 61 67 | 73 5f 6c 69 6e 6b 5f 61 |ooks_tag|s_link_a|
|000039c0| 0a 20 20 20 20 20 20 20 | 20 42 45 46 4f 52 45 20 |. | BEFORE |
|000039d0| 55 50 44 41 54 45 20 4f | 46 20 62 6f 6f 6b 20 4f |UPDATE O|F book O|
|000039e0| 4e 20 62 6f 6f 6b 73 5f | 74 61 67 73 5f 6c 69 6e |N books_|tags_lin|
|000039f0| 6b 0a 20 20 20 20 20 20 | 20 20 42 45 47 49 4e 0a |k. | BEGIN.|
|00003a00| 20 20 20 20 20 20 20 20 | 20 20 20 20 53 45 4c 45 | | SELE|
|00003a10| 43 54 20 43 41 53 45 0a | 20 20 20 20 20 20 20 20 |CT CASE.| |
|00003a20| 20 20 20 20 20 20 20 20 | 57 48 45 4e 20 28 53 45 | |WHEN (SE|
|00003a30| 4c 45 43 54 20 69 64 20 | 66 72 6f 6d 20 62 6f 6f |LECT id |from boo|
|00003a40| 6b 73 20 57 48 45 52 45 | 20 69 64 3d 4e 45 57 2e |ks WHERE| id=NEW.|
|00003a50| 62 6f 6f 6b 29 20 49 53 | 20 4e 55 4c 4c 0a 20 20 |book) IS| NULL. |
|00003a60| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 54 48 | | TH|
|00003a70| 45 4e 20 52 41 49 53 45 | 28 41 42 4f 52 54 2c 20 |EN RAISE|(ABORT, |
|00003a80| 27 46 6f 72 65 69 67 6e | 20 6b 65 79 20 76 69 6f |'Foreign| key vio|
|00003a90| 6c 61 74 69 6f 6e 3a 20 | 62 6f 6f 6b 20 6e 6f 74 |lation: |book not|
|00003aa0| 20 69 6e 20 62 6f 6f 6b | 73 27 29 0a 20 20 20 20 | in book|s'). |
|00003ab0| 20 20 20 20 20 20 20 20 | 45 4e 44 3b 0a 20 20 20 | |END;. |
|00003ac0| 20 20 20 20 20 45 4e 44 | 3b 0a 20 20 20 20 20 20 | END|;. |
|00003ad0| 20 20 43 52 45 41 54 45 | 20 54 52 49 47 47 45 52 | CREATE| TRIGGER|
|00003ae0| 20 66 6b 63 5f 75 70 64 | 61 74 65 5f 62 6f 6f 6b | fkc_upd|ate_book|
|00003af0| 73 5f 74 61 67 73 5f 6c | 69 6e 6b 5f 62 0a 20 20 |s_tags_l|ink_b. |
|00003b00| 20 20 20 20 20 20 42 45 | 46 4f 52 45 20 55 50 44 | BE|FORE UPD|
|00003b10| 41 54 45 20 4f 46 20 74 | 61 67 20 4f 4e 20 62 6f |ATE OF t|ag ON bo|
|00003b20| 6f 6b 73 5f 74 61 67 73 | 5f 6c 69 6e 6b 0a 20 20 |oks_tags|_link. |
|00003b30| 20 20 20 20 20 20 42 45 | 47 49 4e 0a 20 20 20 20 | BE|GIN. |
|00003b40| 20 20 20 20 20 20 20 20 | 53 45 4c 45 43 54 20 43 | |SELECT C|
|00003b50| 41 53 45 0a 20 20 20 20 | 20 20 20 20 20 20 20 20 |ASE. | |
|00003b60| 20 20 20 20 57 48 45 4e | 20 28 53 45 4c 45 43 54 | WHEN| (SELECT|
|00003b70| 20 69 64 20 66 72 6f 6d | 20 74 61 67 73 20 57 48 | id from| tags WH|
|00003b80| 45 52 45 20 69 64 3d 4e | 45 57 2e 74 61 67 29 20 |ERE id=N|EW.tag) |
|00003b90| 49 53 20 4e 55 4c 4c 0a | 20 20 20 20 20 20 20 20 |IS NULL.| |
|00003ba0| 20 20 20 20 20 20 20 20 | 54 48 45 4e 20 52 41 49 | |THEN RAI|
|00003bb0| 53 45 28 41 42 4f 52 54 | 2c 20 27 46 6f 72 65 69 |SE(ABORT|, 'Forei|
|00003bc0| 67 6e 20 6b 65 79 20 76 | 69 6f 6c 61 74 69 6f 6e |gn key v|iolation|
|00003bd0| 3a 20 74 61 67 20 6e 6f | 74 20 69 6e 20 74 61 67 |: tag no|t in tag|
|00003be0| 73 27 29 0a 20 20 20 20 | 20 20 20 20 20 20 20 20 |s'). | |
|00003bf0| 45 4e 44 3b 0a 20 20 20 | 20 20 20 20 20 45 4e 44 |END;. | END|
|00003c00| 3b 0a 20 20 20 20 20 20 | 20 20 43 52 45 41 54 45 |;. | CREATE|
|00003c10| 20 54 52 49 47 47 45 52 | 20 66 6b 63 5f 64 65 6c | TRIGGER| fkc_del|
|00003c20| 65 74 65 5f 62 6f 6f 6b | 73 5f 74 61 67 73 5f 6c |ete_book|s_tags_l|
|00003c30| 69 6e 6b 0a 20 20 20 20 | 20 20 20 20 42 45 46 4f |ink. | BEFO|
|00003c40| 52 45 20 44 45 4c 45 54 | 45 20 4f 4e 20 74 61 67 |RE DELET|E ON tag|
|00003c50| 73 0a 20 20 20 20 20 20 | 20 20 42 45 47 49 4e 0a |s. | BEGIN.|
|00003c60| 20 20 20 20 20 20 20 20 | 20 20 20 20 53 45 4c 45 | | SELE|
|00003c70| 43 54 20 43 41 53 45 0a | 20 20 20 20 20 20 20 20 |CT CASE.| |
|00003c80| 20 20 20 20 20 20 20 20 | 57 48 45 4e 20 28 53 45 | |WHEN (SE|
|00003c90| 4c 45 43 54 20 43 4f 55 | 4e 54 28 69 64 29 20 46 |LECT COU|NT(id) F|
|00003ca0| 52 4f 4d 20 62 6f 6f 6b | 73 5f 74 61 67 73 5f 6c |ROM book|s_tags_l|
|00003cb0| 69 6e 6b 20 57 48 45 52 | 45 20 74 61 67 3d 4f 4c |ink WHER|E tag=OL|
|00003cc0| 44 2e 62 6f 6f 6b 29 20 | 3e 20 30 0a 20 20 20 20 |D.book) |> 0. |
|00003cd0| 20 20 20 20 20 20 20 20 | 20 20 20 20 54 48 45 4e | | THEN|
|00003ce0| 20 52 41 49 53 45 28 41 | 42 4f 52 54 2c 20 27 46 | RAISE(A|BORT, 'F|
|00003cf0| 6f 72 65 69 67 6e 20 6b | 65 79 20 76 69 6f 6c 61 |oreign k|ey viola|
|00003d00| 74 69 6f 6e 3a 20 74 61 | 67 20 69 73 20 73 74 69 |tion: ta|g is sti|
|00003d10| 6c 6c 20 72 65 66 65 72 | 65 6e 63 65 64 27 29 0a |ll refer|enced').|
|00003d20| 20 20 20 20 20 20 20 20 | 20 20 20 20 45 4e 44 3b | | END;|
|00003d30| 0a 20 20 20 20 20 20 20 | 20 45 4e 44 3b 0a 0a 20 |. | END;.. |
|00003d40| 20 20 20 20 20 20 20 2f | 2a 2a 2a 2a 2a 20 73 65 | /|***** se|
|00003d50| 72 69 65 73 20 74 61 62 | 6c 65 20 2a 2a 2a 2a 2a |ries tab|le *****|
|00003d60| 2f 0a 20 20 20 20 20 20 | 20 20 43 52 45 41 54 45 |/. | CREATE|
|00003d70| 20 54 41 42 4c 45 20 73 | 65 72 69 65 73 20 28 20 | TABLE s|eries ( |
|00003d80| 69 64 20 20 20 49 4e 54 | 45 47 45 52 20 50 52 49 |id INT|EGER PRI|
|00003d90| 4d 41 52 59 20 4b 45 59 | 2c 0a 20 20 20 20 20 20 |MARY KEY|,. |
|00003da0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00003db0| 20 20 20 20 20 20 20 20 | 6e 61 6d 65 20 54 45 58 | |name TEX|
|00003dc0| 54 20 4e 4f 54 20 4e 55 | 4c 4c 20 43 4f 4c 4c 41 |T NOT NU|LL COLLA|
|00003dd0| 54 45 20 4e 4f 43 41 53 | 45 2c 0a 20 20 20 20 20 |TE NOCAS|E,. |
|00003de0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00003df0| 20 20 20 20 20 20 20 20 | 20 73 6f 72 74 20 54 45 | | sort TE|
|00003e00| 58 54 20 43 4f 4c 4c 41 | 54 45 20 4e 4f 43 41 53 |XT COLLA|TE NOCAS|
|00003e10| 45 2c 0a 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |E,. | |
|00003e20| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00003e30| 20 55 4e 49 51 55 45 20 | 28 6e 61 6d 65 29 0a 20 | UNIQUE |(name). |
|00003e40| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00003e50| 20 20 20 20 20 20 20 20 | 20 20 20 20 29 3b 0a 20 | | );. |
|00003e60| 20 20 20 20 20 20 20 43 | 52 45 41 54 45 20 49 4e | C|REATE IN|
|00003e70| 44 45 58 20 73 65 72 69 | 65 73 5f 69 64 78 20 4f |DEX seri|es_idx O|
|00003e80| 4e 20 73 65 72 69 65 73 | 20 28 73 6f 72 74 20 43 |N series| (sort C|
|00003e90| 4f 4c 4c 41 54 45 20 4e | 4f 43 41 53 45 29 3b 0a |OLLATE N|OCASE);.|
|00003ea0| 20 20 20 20 20 20 20 20 | 43 52 45 41 54 45 20 54 | |CREATE T|
|00003eb0| 52 49 47 47 45 52 20 73 | 65 72 69 65 73 5f 69 6e |RIGGER s|eries_in|
|00003ec0| 73 65 72 74 5f 74 72 67 | 0a 20 20 20 20 20 20 20 |sert_trg|. |
|00003ed0| 20 41 46 54 45 52 20 49 | 4e 53 45 52 54 20 4f 4e | AFTER I|NSERT ON|
|00003ee0| 20 73 65 72 69 65 73 0a | 20 20 20 20 20 20 20 20 | series.| |
|00003ef0| 42 45 47 49 4e 0a 20 20 | 20 20 20 20 20 20 20 20 |BEGIN. | |
|00003f00| 55 50 44 41 54 45 20 73 | 65 72 69 65 73 20 53 45 |UPDATE s|eries SE|
|00003f10| 54 20 73 6f 72 74 3d 4e | 45 57 2e 6e 61 6d 65 20 |T sort=N|EW.name |
|00003f20| 57 48 45 52 45 20 69 64 | 3d 4e 45 57 2e 69 64 3b |WHERE id|=NEW.id;|
|00003f30| 0a 20 20 20 20 20 20 20 | 20 45 4e 44 3b 0a 20 20 |. | END;. |
|00003f40| 20 20 20 20 20 20 43 52 | 45 41 54 45 20 54 52 49 | CR|EATE TRI|
|00003f50| 47 47 45 52 20 73 65 72 | 69 65 73 5f 75 70 64 61 |GGER ser|ies_upda|
|00003f60| 74 65 5f 74 72 67 0a 20 | 20 20 20 20 20 20 20 41 |te_trg. | A|
|00003f70| 46 54 45 52 20 55 50 44 | 41 54 45 20 4f 4e 20 73 |FTER UPD|ATE ON s|
|00003f80| 65 72 69 65 73 0a 20 20 | 20 20 20 20 20 20 42 45 |eries. | BE|
|00003f90| 47 49 4e 0a 20 20 20 20 | 20 20 20 20 20 20 55 50 |GIN. | UP|
|00003fa0| 44 41 54 45 20 73 65 72 | 69 65 73 20 53 45 54 20 |DATE ser|ies SET |
|00003fb0| 73 6f 72 74 3d 4e 45 57 | 2e 6e 61 6d 65 20 57 48 |sort=NEW|.name WH|
|00003fc0| 45 52 45 20 69 64 3d 4e | 45 57 2e 69 64 3b 0a 20 |ERE id=N|EW.id;. |
|00003fd0| 20 20 20 20 20 20 20 45 | 4e 44 3b 0a 20 20 20 20 | E|ND;. |
|00003fe0| 20 20 20 20 43 52 45 41 | 54 45 20 54 41 42 4c 45 | CREA|TE TABLE|
|00003ff0| 20 62 6f 6f 6b 73 5f 73 | 65 72 69 65 73 5f 6c 69 | books_s|eries_li|
|00004000| 6e 6b 20 28 20 69 64 20 | 49 4e 54 45 47 45 52 20 |nk ( id |INTEGER |
|00004010| 50 52 49 4d 41 52 59 20 | 4b 45 59 2c 0a 20 20 20 |PRIMARY |KEY,. |
|00004020| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00004030| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00004040| 20 20 20 20 20 20 20 62 | 6f 6f 6b 20 49 4e 54 45 | b|ook INTE|
|00004050| 47 45 52 20 4e 4f 54 20 | 4e 55 4c 4c 2c 0a 20 20 |GER NOT |NULL,. |
|00004060| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00004070| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00004080| 20 20 20 20 20 20 20 20 | 73 65 72 69 65 73 20 49 | |series I|
|00004090| 4e 54 45 47 45 52 20 4e | 4f 54 20 4e 55 4c 4c 2c |NTEGER N|OT NULL,|
|000040a0| 0a 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |. | |
|000040b0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|000040c0| 20 20 20 20 20 20 20 20 | 20 20 20 55 4e 49 51 55 | | UNIQU|
|000040d0| 45 28 62 6f 6f 6b 29 0a | 20 20 20 20 20 20 20 20 |E(book).| |
|000040e0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|000040f0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00004100| 29 3b 0a 20 20 20 20 20 | 20 20 20 43 52 45 41 54 |);. | CREAT|
|00004110| 45 20 49 4e 44 45 58 20 | 62 6f 6f 6b 73 5f 73 65 |E INDEX |books_se|
|00004120| 72 69 65 73 5f 6c 69 6e | 6b 5f 62 69 64 78 20 4f |ries_lin|k_bidx O|
|00004130| 4e 20 62 6f 6f 6b 73 5f | 73 65 72 69 65 73 5f 6c |N books_|series_l|
|00004140| 69 6e 6b 20 28 62 6f 6f | 6b 29 3b 0a 20 20 20 20 |ink (boo|k);. |
|00004150| 20 20 20 20 43 52 45 41 | 54 45 20 49 4e 44 45 58 | CREA|TE INDEX|
|00004160| 20 62 6f 6f 6b 73 5f 73 | 65 72 69 65 73 5f 6c 69 | books_s|eries_li|
|00004170| 6e 6b 5f 61 69 64 78 20 | 4f 4e 20 62 6f 6f 6b 73 |nk_aidx |ON books|
|00004180| 5f 73 65 72 69 65 73 5f | 6c 69 6e 6b 20 28 73 65 |_series_|link (se|
|00004190| 72 69 65 73 29 3b 0a 0a | 20 20 20 20 20 20 20 20 |ries);..| |
|000041a0| 43 52 45 41 54 45 20 54 | 52 49 47 47 45 52 20 66 |CREATE T|RIGGER f|
|000041b0| 6b 63 5f 69 6e 73 65 72 | 74 5f 62 6f 6f 6b 73 5f |kc_inser|t_books_|
|000041c0| 73 65 72 69 65 73 5f 6c | 69 6e 6b 0a 20 20 20 20 |series_l|ink. |
|000041d0| 20 20 20 20 42 45 46 4f | 52 45 20 49 4e 53 45 52 | BEFO|RE INSER|
|000041e0| 54 20 4f 4e 20 62 6f 6f | 6b 73 5f 73 65 72 69 65 |T ON boo|ks_serie|
|000041f0| 73 5f 6c 69 6e 6b 0a 20 | 20 20 20 20 20 20 20 42 |s_link. | B|
|00004200| 45 47 49 4e 0a 20 20 20 | 20 20 20 20 20 20 20 53 |EGIN. | S|
|00004210| 45 4c 45 43 54 20 43 41 | 53 45 0a 20 20 20 20 20 |ELECT CA|SE. |
|00004220| 20 20 20 20 20 20 20 20 | 20 57 48 45 4e 20 28 53 | | WHEN (S|
|00004230| 45 4c 45 43 54 20 69 64 | 20 66 72 6f 6d 20 62 6f |ELECT id| from bo|
|00004240| 6f 6b 73 20 57 48 45 52 | 45 20 69 64 3d 4e 45 57 |oks WHER|E id=NEW|
|00004250| 2e 62 6f 6f 6b 29 20 49 | 53 20 4e 55 4c 4c 0a 20 |.book) I|S NULL. |
|00004260| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 54 48 45 | | THE|
|00004270| 4e 20 52 41 49 53 45 28 | 41 42 4f 52 54 2c 20 27 |N RAISE(|ABORT, '|
|00004280| 46 6f 72 65 69 67 6e 20 | 6b 65 79 20 76 69 6f 6c |Foreign |key viol|
|00004290| 61 74 69 6f 6e 3a 20 62 | 6f 6f 6b 20 6e 6f 74 20 |ation: b|ook not |
|000042a0| 69 6e 20 62 6f 6f 6b 73 | 27 29 0a 20 20 20 20 20 |in books|'). |
|000042b0| 20 20 20 20 20 20 20 20 | 20 57 48 45 4e 20 28 53 | | WHEN (S|
|000042c0| 45 4c 45 43 54 20 69 64 | 20 66 72 6f 6d 20 73 65 |ELECT id| from se|
|000042d0| 72 69 65 73 20 57 48 45 | 52 45 20 69 64 3d 4e 45 |ries WHE|RE id=NE|
|000042e0| 57 2e 73 65 72 69 65 73 | 29 20 49 53 20 4e 55 4c |W.series|) IS NUL|
|000042f0| 4c 0a 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |L. | |
|00004300| 54 48 45 4e 20 52 41 49 | 53 45 28 41 42 4f 52 54 |THEN RAI|SE(ABORT|
|00004310| 2c 20 27 46 6f 72 65 69 | 67 6e 20 6b 65 79 20 76 |, 'Forei|gn key v|
|00004320| 69 6f 6c 61 74 69 6f 6e | 3a 20 73 65 72 69 65 73 |iolation|: series|
|00004330| 20 6e 6f 74 20 69 6e 20 | 73 65 72 69 65 73 27 29 | not in |series')|
|00004340| 0a 20 20 20 20 20 20 20 | 20 20 20 45 4e 44 3b 0a |. | END;.|
|00004350| 20 20 20 20 20 20 20 20 | 45 4e 44 3b 0a 20 20 20 | |END;. |
|00004360| 20 20 20 20 20 43 52 45 | 41 54 45 20 54 52 49 47 | CRE|ATE TRIG|
|00004370| 47 45 52 20 66 6b 63 5f | 75 70 64 61 74 65 5f 62 |GER fkc_|update_b|
|00004380| 6f 6f 6b 73 5f 73 65 72 | 69 65 73 5f 6c 69 6e 6b |ooks_ser|ies_link|
|00004390| 5f 61 0a 20 20 20 20 20 | 20 20 20 42 45 46 4f 52 |_a. | BEFOR|
|000043a0| 45 20 55 50 44 41 54 45 | 20 4f 46 20 62 6f 6f 6b |E UPDATE| OF book|
|000043b0| 20 4f 4e 20 62 6f 6f 6b | 73 5f 73 65 72 69 65 73 | ON book|s_series|
|000043c0| 5f 6c 69 6e 6b 0a 20 20 | 20 20 20 20 20 20 42 45 |_link. | BE|
|000043d0| 47 49 4e 0a 20 20 20 20 | 20 20 20 20 20 20 20 20 |GIN. | |
|000043e0| 53 45 4c 45 43 54 20 43 | 41 53 45 0a 20 20 20 20 |SELECT C|ASE. |
|000043f0| 20 20 20 20 20 20 20 20 | 20 20 20 20 57 48 45 4e | | WHEN|
|00004400| 20 28 53 45 4c 45 43 54 | 20 69 64 20 66 72 6f 6d | (SELECT| id from|
|00004410| 20 62 6f 6f 6b 73 20 57 | 48 45 52 45 20 69 64 3d | books W|HERE id=|
|00004420| 4e 45 57 2e 62 6f 6f 6b | 29 20 49 53 20 4e 55 4c |NEW.book|) IS NUL|
|00004430| 4c 0a 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |L. | |
|00004440| 20 20 54 48 45 4e 20 52 | 41 49 53 45 28 41 42 4f | THEN R|AISE(ABO|
|00004450| 52 54 2c 20 27 46 6f 72 | 65 69 67 6e 20 6b 65 79 |RT, 'For|eign key|
|00004460| 20 76 69 6f 6c 61 74 69 | 6f 6e 3a 20 62 6f 6f 6b | violati|on: book|
|00004470| 20 6e 6f 74 20 69 6e 20 | 62 6f 6f 6b 73 27 29 0a | not in |books').|
|00004480| 20 20 20 20 20 20 20 20 | 20 20 20 20 45 4e 44 3b | | END;|
|00004490| 0a 20 20 20 20 20 20 20 | 20 45 4e 44 3b 0a 20 20 |. | END;. |
|000044a0| 20 20 20 20 20 20 43 52 | 45 41 54 45 20 54 52 49 | CR|EATE TRI|
|000044b0| 47 47 45 52 20 66 6b 63 | 5f 75 70 64 61 74 65 5f |GGER fkc|_update_|
|000044c0| 62 6f 6f 6b 73 5f 73 65 | 72 69 65 73 5f 6c 69 6e |books_se|ries_lin|
|000044d0| 6b 5f 62 0a 20 20 20 20 | 20 20 20 20 42 45 46 4f |k_b. | BEFO|
|000044e0| 52 45 20 55 50 44 41 54 | 45 20 4f 46 20 73 65 72 |RE UPDAT|E OF ser|
|000044f0| 69 65 20 4f 4e 20 62 6f | 6f 6b 73 5f 73 65 72 69 |ie ON bo|oks_seri|
|00004500| 65 73 5f 6c 69 6e 6b 0a | 20 20 20 20 20 20 20 20 |es_link.| |
|00004510| 42 45 47 49 4e 0a 20 20 | 20 20 20 20 20 20 20 20 |BEGIN. | |
|00004520| 20 20 53 45 4c 45 43 54 | 20 43 41 53 45 0a 20 20 | SELECT| CASE. |
|00004530| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 57 48 | | WH|
|00004540| 45 4e 20 28 53 45 4c 45 | 43 54 20 69 64 20 66 72 |EN (SELE|CT id fr|
|00004550| 6f 6d 20 73 65 72 69 65 | 73 20 57 48 45 52 45 20 |om serie|s WHERE |
|00004560| 69 64 3d 4e 45 57 2e 73 | 65 72 69 65 73 29 20 49 |id=NEW.s|eries) I|
|00004570| 53 20 4e 55 4c 4c 0a 20 | 20 20 20 20 20 20 20 20 |S NULL. | |
|00004580| 20 20 20 20 20 20 20 54 | 48 45 4e 20 52 41 49 53 | T|HEN RAIS|
|00004590| 45 28 41 42 4f 52 54 2c | 20 27 46 6f 72 65 69 67 |E(ABORT,| 'Foreig|
|000045a0| 6e 20 6b 65 79 20 76 69 | 6f 6c 61 74 69 6f 6e 3a |n key vi|olation:|
|000045b0| 20 73 65 72 69 65 73 20 | 6e 6f 74 20 69 6e 20 73 | series |not in s|
|000045c0| 65 72 69 65 73 27 29 0a | 20 20 20 20 20 20 20 20 |eries').| |
|000045d0| 20 20 20 20 45 4e 44 3b | 0a 20 20 20 20 20 20 20 | END;|. |
|000045e0| 20 45 4e 44 3b 0a 20 20 | 20 20 20 20 20 20 43 52 | END;. | CR|
|000045f0| 45 41 54 45 20 54 52 49 | 47 47 45 52 20 66 6b 63 |EATE TRI|GGER fkc|
|00004600| 5f 64 65 6c 65 74 65 5f | 62 6f 6f 6b 73 5f 73 65 |_delete_|books_se|
|00004610| 72 69 65 73 5f 6c 69 6e | 6b 0a 20 20 20 20 20 20 |ries_lin|k. |
|00004620| 20 20 42 45 46 4f 52 45 | 20 44 45 4c 45 54 45 20 | BEFORE| DELETE |
|00004630| 4f 4e 20 73 65 72 69 65 | 73 0a 20 20 20 20 20 20 |ON serie|s. |
|00004640| 20 20 42 45 47 49 4e 0a | 20 20 20 20 20 20 20 20 | BEGIN.| |
|00004650| 20 20 20 20 53 45 4c 45 | 43 54 20 43 41 53 45 0a | SELE|CT CASE.|
|00004660| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00004670| 57 48 45 4e 20 28 53 45 | 4c 45 43 54 20 43 4f 55 |WHEN (SE|LECT COU|
|00004680| 4e 54 28 69 64 29 20 46 | 52 4f 4d 20 62 6f 6f 6b |NT(id) F|ROM book|
|00004690| 73 5f 73 65 72 69 65 73 | 5f 6c 69 6e 6b 20 57 48 |s_series|_link WH|
|000046a0| 45 52 45 20 62 6f 6f 6b | 3d 4f 4c 44 2e 62 6f 6f |ERE book|=OLD.boo|
|000046b0| 6b 29 20 3e 20 30 0a 20 | 20 20 20 20 20 20 20 20 |k) > 0. | |
|000046c0| 20 20 20 20 20 20 20 54 | 48 45 4e 20 52 41 49 53 | T|HEN RAIS|
|000046d0| 45 28 41 42 4f 52 54 2c | 20 27 46 6f 72 65 69 67 |E(ABORT,| 'Foreig|
|000046e0| 6e 20 6b 65 79 20 76 69 | 6f 6c 61 74 69 6f 6e 3a |n key vi|olation:|
|000046f0| 20 73 65 72 69 65 73 20 | 69 73 20 73 74 69 6c 6c | series |is still|
|00004700| 20 72 65 66 65 72 65 6e | 63 65 64 27 29 0a 20 20 | referen|ced'). |
|00004710| 20 20 20 20 20 20 20 20 | 20 20 45 4e 44 3b 0a 20 | | END;. |
|00004720| 20 20 20 20 20 20 20 45 | 4e 44 3b 0a 0a 20 20 20 | E|ND;.. |
|00004730| 20 20 20 20 20 2f 2a 2a | 2a 2a 20 72 61 74 69 6e | /**|** ratin|
|00004740| 67 73 20 74 61 62 6c 65 | 20 2a 2a 2a 2a 2f 0a 0a |gs table| ****/..|
|00004750| 20 20 20 20 20 20 20 20 | 43 52 45 41 54 45 20 54 | |CREATE T|
|00004760| 41 42 4c 45 20 72 61 74 | 69 6e 67 73 20 28 20 69 |ABLE rat|ings ( i|
|00004770| 64 20 20 20 49 4e 54 45 | 47 45 52 20 50 52 49 4d |d INTE|GER PRIM|
|00004780| 41 52 59 20 4b 45 59 2c | 0a 20 20 20 20 20 20 20 |ARY KEY,|. |
|00004790| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|000047a0| 20 20 20 20 20 20 20 20 | 72 61 74 69 6e 67 20 49 | |rating I|
|000047b0| 4e 54 45 47 45 52 20 43 | 48 45 43 4b 28 72 61 74 |NTEGER C|HECK(rat|
|000047c0| 69 6e 67 20 3e 20 2d 31 | 20 41 4e 44 20 72 61 74 |ing > -1| AND rat|
|000047d0| 69 6e 67 20 3c 20 31 31 | 29 2c 0a 20 20 20 20 20 |ing < 11|),. |
|000047e0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|000047f0| 20 20 20 20 20 20 20 20 | 20 20 55 4e 49 51 55 45 | | UNIQUE|
|00004800| 20 28 72 61 74 69 6e 67 | 29 0a 20 20 20 20 20 20 | (rating|). |
|00004810| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00004820| 20 20 20 20 20 20 20 29 | 3b 0a 20 20 20 20 20 20 | )|;. |
|00004830| 20 20 49 4e 53 45 52 54 | 20 49 4e 54 4f 20 72 61 | INSERT| INTO ra|
|00004840| 74 69 6e 67 73 20 28 72 | 61 74 69 6e 67 29 20 56 |tings (r|ating) V|
|00004850| 41 4c 55 45 53 20 28 30 | 29 3b 0a 20 20 20 20 20 |ALUES (0|);. |
|00004860| 20 20 20 49 4e 53 45 52 | 54 20 49 4e 54 4f 20 72 | INSER|T INTO r|
|00004870| 61 74 69 6e 67 73 20 28 | 72 61 74 69 6e 67 29 20 |atings (|rating) |
|00004880| 56 41 4c 55 45 53 20 28 | 31 29 3b 0a 20 20 20 20 |VALUES (|1);. |
|00004890| 20 20 20 20 49 4e 53 45 | 52 54 20 49 4e 54 4f 20 | INSE|RT INTO |
|000048a0| 72 61 74 69 6e 67 73 20 | 28 72 61 74 69 6e 67 29 |ratings |(rating)|
|000048b0| 20 56 41 4c 55 45 53 20 | 28 32 29 3b 0a 20 20 20 | VALUES |(2);. |
|000048c0| 20 20 20 20 20 49 4e 53 | 45 52 54 20 49 4e 54 4f | INS|ERT INTO|
|000048d0| 20 72 61 74 69 6e 67 73 | 20 28 72 61 74 69 6e 67 | ratings| (rating|
|000048e0| 29 20 56 41 4c 55 45 53 | 20 28 33 29 3b 0a 20 20 |) VALUES| (3);. |
|000048f0| 20 20 20 20 20 20 49 4e | 53 45 52 54 20 49 4e 54 | IN|SERT INT|
|00004900| 4f 20 72 61 74 69 6e 67 | 73 20 28 72 61 74 69 6e |O rating|s (ratin|
|00004910| 67 29 20 56 41 4c 55 45 | 53 20 28 34 29 3b 0a 20 |g) VALUE|S (4);. |
|00004920| 20 20 20 20 20 20 20 49 | 4e 53 45 52 54 20 49 4e | I|NSERT IN|
|00004930| 54 4f 20 72 61 74 69 6e | 67 73 20 28 72 61 74 69 |TO ratin|gs (rati|
|00004940| 6e 67 29 20 56 41 4c 55 | 45 53 20 28 35 29 3b 0a |ng) VALU|ES (5);.|
|00004950| 20 20 20 20 20 20 20 20 | 49 4e 53 45 52 54 20 49 | |INSERT I|
|00004960| 4e 54 4f 20 72 61 74 69 | 6e 67 73 20 28 72 61 74 |NTO rati|ngs (rat|
|00004970| 69 6e 67 29 20 56 41 4c | 55 45 53 20 28 36 29 3b |ing) VAL|UES (6);|
|00004980| 0a 20 20 20 20 20 20 20 | 20 49 4e 53 45 52 54 20 |. | INSERT |
|00004990| 49 4e 54 4f 20 72 61 74 | 69 6e 67 73 20 28 72 61 |INTO rat|ings (ra|
|000049a0| 74 69 6e 67 29 20 56 41 | 4c 55 45 53 20 28 37 29 |ting) VA|LUES (7)|
|000049b0| 3b 0a 20 20 20 20 20 20 | 20 20 49 4e 53 45 52 54 |;. | INSERT|
|000049c0| 20 49 4e 54 4f 20 72 61 | 74 69 6e 67 73 20 28 72 | INTO ra|tings (r|
|000049d0| 61 74 69 6e 67 29 20 56 | 41 4c 55 45 53 20 28 38 |ating) V|ALUES (8|
|000049e0| 29 3b 0a 20 20 20 20 20 | 20 20 20 49 4e 53 45 52 |);. | INSER|
|000049f0| 54 20 49 4e 54 4f 20 72 | 61 74 69 6e 67 73 20 28 |T INTO r|atings (|
|00004a00| 72 61 74 69 6e 67 29 20 | 56 41 4c 55 45 53 20 28 |rating) |VALUES (|
|00004a10| 39 29 3b 0a 20 20 20 20 | 20 20 20 20 49 4e 53 45 |9);. | INSE|
|00004a20| 52 54 20 49 4e 54 4f 20 | 72 61 74 69 6e 67 73 20 |RT INTO |ratings |
|00004a30| 28 72 61 74 69 6e 67 29 | 20 56 41 4c 55 45 53 20 |(rating)| VALUES |
|00004a40| 28 31 30 29 3b 0a 0a 20 | 20 20 20 20 20 20 20 43 |(10);.. | C|
|00004a50| 52 45 41 54 45 20 54 41 | 42 4c 45 20 62 6f 6f 6b |REATE TA|BLE book|
|00004a60| 73 5f 72 61 74 69 6e 67 | 73 5f 6c 69 6e 6b 20 28 |s_rating|s_link (|
|00004a70| 20 69 64 20 49 4e 54 45 | 47 45 52 20 50 52 49 4d | id INTE|GER PRIM|
|00004a80| 41 52 59 20 4b 45 59 2c | 0a 20 20 20 20 20 20 20 |ARY KEY,|. |
|00004a90| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00004aa0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00004ab0| 20 20 20 62 6f 6f 6b 20 | 49 4e 54 45 47 45 52 20 | book |INTEGER |
|00004ac0| 4e 4f 54 20 4e 55 4c 4c | 2c 0a 20 20 20 20 20 20 |NOT NULL|,. |
|00004ad0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00004ae0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00004af0| 20 20 20 20 72 61 74 69 | 6e 67 20 49 4e 54 45 47 | rati|ng INTEG|
|00004b00| 45 52 20 4e 4f 54 20 4e | 55 4c 4c 2c 0a 20 20 20 |ER NOT N|ULL,. |
|00004b10| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00004b20| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00004b30| 20 20 20 20 20 20 20 55 | 4e 49 51 55 45 28 62 6f | U|NIQUE(bo|
|00004b40| 6f 6b 2c 20 72 61 74 69 | 6e 67 29 0a 20 20 20 20 |ok, rati|ng). |
|00004b50| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00004b60| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00004b70| 20 20 20 20 29 3b 0a 20 | 20 20 20 20 20 20 20 43 | );. | C|
|00004b80| 52 45 41 54 45 20 49 4e | 44 45 58 20 62 6f 6f 6b |REATE IN|DEX book|
|00004b90| 73 5f 72 61 74 69 6e 67 | 73 5f 6c 69 6e 6b 5f 62 |s_rating|s_link_b|
|00004ba0| 69 64 78 20 4f 4e 20 62 | 6f 6f 6b 73 5f 72 61 74 |idx ON b|ooks_rat|
|00004bb0| 69 6e 67 73 5f 6c 69 6e | 6b 20 28 62 6f 6f 6b 29 |ings_lin|k (book)|
|00004bc0| 3b 0a 20 20 20 20 20 20 | 20 20 43 52 45 41 54 45 |;. | CREATE|
|00004bd0| 20 49 4e 44 45 58 20 62 | 6f 6f 6b 73 5f 72 61 74 | INDEX b|ooks_rat|
|00004be0| 69 6e 67 73 5f 6c 69 6e | 6b 5f 61 69 64 78 20 4f |ings_lin|k_aidx O|
|00004bf0| 4e 20 62 6f 6f 6b 73 5f | 72 61 74 69 6e 67 73 5f |N books_|ratings_|
|00004c00| 6c 69 6e 6b 20 28 72 61 | 74 69 6e 67 29 3b 0a 0a |link (ra|ting);..|
|00004c10| 20 20 20 20 20 20 20 20 | 43 52 45 41 54 45 20 54 | |CREATE T|
|00004c20| 52 49 47 47 45 52 20 66 | 6b 63 5f 69 6e 73 65 72 |RIGGER f|kc_inser|
|00004c30| 74 5f 62 6f 6f 6b 73 5f | 72 61 74 69 6e 67 73 5f |t_books_|ratings_|
|00004c40| 6c 69 6e 6b 0a 20 20 20 | 20 20 20 20 20 42 45 46 |link. | BEF|
|00004c50| 4f 52 45 20 49 4e 53 45 | 52 54 20 4f 4e 20 62 6f |ORE INSE|RT ON bo|
|00004c60| 6f 6b 73 5f 72 61 74 69 | 6e 67 73 5f 6c 69 6e 6b |oks_rati|ngs_link|
|00004c70| 0a 20 20 20 20 20 20 20 | 20 42 45 47 49 4e 0a 20 |. | BEGIN. |
|00004c80| 20 20 20 20 20 20 20 20 | 20 53 45 4c 45 43 54 20 | | SELECT |
|00004c90| 43 41 53 45 0a 20 20 20 | 20 20 20 20 20 20 20 20 |CASE. | |
|00004ca0| 20 20 20 57 48 45 4e 20 | 28 53 45 4c 45 43 54 20 | WHEN |(SELECT |
|00004cb0| 69 64 20 66 72 6f 6d 20 | 62 6f 6f 6b 73 20 57 48 |id from |books WH|
|00004cc0| 45 52 45 20 69 64 3d 4e | 45 57 2e 62 6f 6f 6b 29 |ERE id=N|EW.book)|
|00004cd0| 20 49 53 20 4e 55 4c 4c | 0a 20 20 20 20 20 20 20 | IS NULL|. |
|00004ce0| 20 20 20 20 20 20 20 54 | 48 45 4e 20 52 41 49 53 | T|HEN RAIS|
|00004cf0| 45 28 41 42 4f 52 54 2c | 20 27 46 6f 72 65 69 67 |E(ABORT,| 'Foreig|
|00004d00| 6e 20 6b 65 79 20 76 69 | 6f 6c 61 74 69 6f 6e 3a |n key vi|olation:|
|00004d10| 20 62 6f 6f 6b 20 6e 6f | 74 20 69 6e 20 62 6f 6f | book no|t in boo|
|00004d20| 6b 73 27 29 0a 20 20 20 | 20 20 20 20 20 20 20 20 |ks'). | |
|00004d30| 20 20 20 57 48 45 4e 20 | 28 53 45 4c 45 43 54 20 | WHEN |(SELECT |
|00004d40| 69 64 20 66 72 6f 6d 20 | 72 61 74 69 6e 67 73 20 |id from |ratings |
|00004d50| 57 48 45 52 45 20 69 64 | 3d 4e 45 57 2e 72 61 74 |WHERE id|=NEW.rat|
|00004d60| 69 6e 67 29 20 49 53 20 | 4e 55 4c 4c 0a 20 20 20 |ing) IS |NULL. |
|00004d70| 20 20 20 20 20 20 20 20 | 20 20 20 54 48 45 4e 20 | | THEN |
|00004d80| 52 41 49 53 45 28 41 42 | 4f 52 54 2c 20 27 46 6f |RAISE(AB|ORT, 'Fo|
|00004d90| 72 65 69 67 6e 20 6b 65 | 79 20 76 69 6f 6c 61 74 |reign ke|y violat|
|00004da0| 69 6f 6e 3a 20 72 61 74 | 69 6e 67 20 6e 6f 74 20 |ion: rat|ing not |
|00004db0| 69 6e 20 72 61 74 69 6e | 67 73 27 29 0a 20 20 20 |in ratin|gs'). |
|00004dc0| 20 20 20 20 20 20 20 45 | 4e 44 3b 0a 20 20 20 20 | E|ND;. |
|00004dd0| 20 20 20 20 45 4e 44 3b | 0a 20 20 20 20 20 20 20 | END;|. |
|00004de0| 20 43 52 45 41 54 45 20 | 54 52 49 47 47 45 52 20 | CREATE |TRIGGER |
|00004df0| 66 6b 63 5f 75 70 64 61 | 74 65 5f 62 6f 6f 6b 73 |fkc_upda|te_books|
|00004e00| 5f 72 61 74 69 6e 67 73 | 5f 6c 69 6e 6b 5f 61 0a |_ratings|_link_a.|
|00004e10| 20 20 20 20 20 20 20 20 | 42 45 46 4f 52 45 20 55 | |BEFORE U|
|00004e20| 50 44 41 54 45 20 4f 46 | 20 62 6f 6f 6b 20 4f 4e |PDATE OF| book ON|
|00004e30| 20 62 6f 6f 6b 73 5f 72 | 61 74 69 6e 67 73 5f 6c | books_r|atings_l|
|00004e40| 69 6e 6b 0a 20 20 20 20 | 20 20 20 20 42 45 47 49 |ink. | BEGI|
|00004e50| 4e 0a 20 20 20 20 20 20 | 20 20 20 20 20 20 53 45 |N. | SE|
|00004e60| 4c 45 43 54 20 43 41 53 | 45 0a 20 20 20 20 20 20 |LECT CAS|E. |
|00004e70| 20 20 20 20 20 20 20 20 | 20 20 57 48 45 4e 20 28 | | WHEN (|
|00004e80| 53 45 4c 45 43 54 20 69 | 64 20 66 72 6f 6d 20 62 |SELECT i|d from b|
|00004e90| 6f 6f 6b 73 20 57 48 45 | 52 45 20 69 64 3d 4e 45 |ooks WHE|RE id=NE|
|00004ea0| 57 2e 62 6f 6f 6b 29 20 | 49 53 20 4e 55 4c 4c 0a |W.book) |IS NULL.|
|00004eb0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00004ec0| 54 48 45 4e 20 52 41 49 | 53 45 28 41 42 4f 52 54 |THEN RAI|SE(ABORT|
|00004ed0| 2c 20 27 46 6f 72 65 69 | 67 6e 20 6b 65 79 20 76 |, 'Forei|gn key v|
|00004ee0| 69 6f 6c 61 74 69 6f 6e | 3a 20 62 6f 6f 6b 20 6e |iolation|: book n|
|00004ef0| 6f 74 20 69 6e 20 62 6f | 6f 6b 73 27 29 0a 20 20 |ot in bo|oks'). |
|00004f00| 20 20 20 20 20 20 20 20 | 20 20 45 4e 44 3b 0a 20 | | END;. |
|00004f10| 20 20 20 20 20 20 20 45 | 4e 44 3b 0a 20 20 20 20 | E|ND;. |
|00004f20| 20 20 20 20 43 52 45 41 | 54 45 20 54 52 49 47 47 | CREA|TE TRIGG|
|00004f30| 45 52 20 66 6b 63 5f 75 | 70 64 61 74 65 5f 62 6f |ER fkc_u|pdate_bo|
|00004f40| 6f 6b 73 5f 72 61 74 69 | 6e 67 73 5f 6c 69 6e 6b |oks_rati|ngs_link|
|00004f50| 5f 62 0a 20 20 20 20 20 | 20 20 20 42 45 46 4f 52 |_b. | BEFOR|
|00004f60| 45 20 55 50 44 41 54 45 | 20 4f 46 20 72 61 74 69 |E UPDATE| OF rati|
|00004f70| 6e 67 20 4f 4e 20 62 6f | 6f 6b 73 5f 72 61 74 69 |ng ON bo|oks_rati|
|00004f80| 6e 67 73 5f 6c 69 6e 6b | 0a 20 20 20 20 20 20 20 |ngs_link|. |
|00004f90| 20 42 45 47 49 4e 0a 20 | 20 20 20 20 20 20 20 20 | BEGIN. | |
|00004fa0| 20 20 20 53 45 4c 45 43 | 54 20 43 41 53 45 0a 20 | SELEC|T CASE. |
|00004fb0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 57 | | W|
|00004fc0| 48 45 4e 20 28 53 45 4c | 45 43 54 20 69 64 20 66 |HEN (SEL|ECT id f|
|00004fd0| 72 6f 6d 20 72 61 74 69 | 6e 67 73 20 57 48 45 52 |rom rati|ngs WHER|
|00004fe0| 45 20 69 64 3d 4e 45 57 | 2e 72 61 74 69 6e 67 29 |E id=NEW|.rating)|
|00004ff0| 20 49 53 20 4e 55 4c 4c | 0a 20 20 20 20 20 20 20 | IS NULL|. |
|00005000| 20 20 20 20 20 20 20 20 | 20 54 48 45 4e 20 52 41 | | THEN RA|
|00005010| 49 53 45 28 41 42 4f 52 | 54 2c 20 27 46 6f 72 65 |ISE(ABOR|T, 'Fore|
|00005020| 69 67 6e 20 6b 65 79 20 | 76 69 6f 6c 61 74 69 6f |ign key |violatio|
|00005030| 6e 3a 20 72 61 74 69 6e | 67 20 6e 6f 74 20 69 6e |n: ratin|g not in|
|00005040| 20 72 61 74 69 6e 67 73 | 27 29 0a 20 20 20 20 20 | ratings|'). |
|00005050| 20 20 20 20 20 20 20 45 | 4e 44 3b 0a 20 20 20 20 | E|ND;. |
|00005060| 20 20 20 20 45 4e 44 3b | 0a 0a 20 20 20 20 20 20 | END;|.. |
|00005070| 20 20 2f 2a 2a 2a 2a 20 | 64 61 74 61 20 74 61 62 | /**** |data tab|
|00005080| 6c 65 20 2a 2a 2a 2a 2f | 0a 20 20 20 20 20 20 20 |le ****/|. |
|00005090| 20 43 52 45 41 54 45 20 | 54 41 42 4c 45 20 64 61 | CREATE |TABLE da|
|000050a0| 74 61 20 28 20 69 64 20 | 20 20 20 20 49 4e 54 45 |ta ( id | INTE|
|000050b0| 47 45 52 20 50 52 49 4d | 41 52 59 20 4b 45 59 2c |GER PRIM|ARY KEY,|
|000050c0| 0a 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |. | |
|000050d0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 62 6f 6f | | boo|
|000050e0| 6b 20 20 20 49 4e 54 45 | 47 45 52 20 4e 4f 4e 20 |k INTE|GER NON |
|000050f0| 4e 55 4c 4c 2c 0a 20 20 | 20 20 20 20 20 20 20 20 |NULL,. | |
|00005100| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00005110| 20 20 66 6f 72 6d 61 74 | 20 54 45 58 54 20 4e 4f | format| TEXT NO|
|00005120| 4e 20 4e 55 4c 4c 20 43 | 4f 4c 4c 41 54 45 20 4e |N NULL C|OLLATE N|
|00005130| 4f 43 41 53 45 2c 0a 20 | 20 20 20 20 20 20 20 20 |OCASE,. | |
|00005140| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00005150| 20 20 20 75 6e 63 6f 6d | 70 72 65 73 73 65 64 5f | uncom|pressed_|
|00005160| 73 69 7a 65 20 49 4e 54 | 45 47 45 52 20 4e 4f 4e |size INT|EGER NON|
|00005170| 20 4e 55 4c 4c 2c 0a 20 | 20 20 20 20 20 20 20 20 | NULL,. | |
|00005180| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00005190| 20 20 20 64 61 74 61 20 | 20 20 42 4c 4f 42 20 4e | data | BLOB N|
|000051a0| 4f 4e 20 4e 55 4c 4c 2c | 0a 20 20 20 20 20 20 20 |ON NULL,|. |
|000051b0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|000051c0| 20 20 20 20 20 55 4e 49 | 51 55 45 28 62 6f 6f 6b | UNI|QUE(book|
|000051d0| 2c 20 66 6f 72 6d 61 74 | 29 0a 20 20 20 20 20 20 |, format|). |
|000051e0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|000051f0| 20 20 20 20 29 3b 0a 20 | 20 20 20 20 20 20 20 43 | );. | C|
|00005200| 52 45 41 54 45 20 49 4e | 44 45 58 20 64 61 74 61 |REATE IN|DEX data|
|00005210| 5f 69 64 78 20 4f 4e 20 | 64 61 74 61 20 28 62 6f |_idx ON |data (bo|
|00005220| 6f 6b 29 3b 0a 20 20 20 | 20 20 20 20 20 43 52 45 |ok);. | CRE|
|00005230| 41 54 45 20 54 52 49 47 | 47 45 52 20 66 6b 63 5f |ATE TRIG|GER fkc_|
|00005240| 64 61 74 61 5f 69 6e 73 | 65 72 74 0a 20 20 20 20 |data_ins|ert. |
|00005250| 20 20 20 20 42 45 46 4f | 52 45 20 49 4e 53 45 52 | BEFO|RE INSER|
|00005260| 54 20 4f 4e 20 64 61 74 | 61 0a 20 20 20 20 20 20 |T ON dat|a. |
|00005270| 20 20 42 45 47 49 4e 0a | 20 20 20 20 20 20 20 20 | BEGIN.| |
|00005280| 20 20 20 20 53 45 4c 45 | 43 54 20 43 41 53 45 0a | SELE|CT CASE.|
|00005290| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|000052a0| 57 48 45 4e 20 28 53 45 | 4c 45 43 54 20 69 64 20 |WHEN (SE|LECT id |
|000052b0| 66 72 6f 6d 20 62 6f 6f | 6b 73 20 57 48 45 52 45 |from boo|ks WHERE|
|000052c0| 20 69 64 3d 4e 45 57 2e | 62 6f 6f 6b 29 20 49 53 | id=NEW.|book) IS|
|000052d0| 20 4e 55 4c 4c 0a 20 20 | 20 20 20 20 20 20 20 20 | NULL. | |
|000052e0| 20 20 20 20 20 20 54 48 | 45 4e 20 52 41 49 53 45 | TH|EN RAISE|
|000052f0| 28 41 42 4f 52 54 2c 20 | 27 46 6f 72 65 69 67 6e |(ABORT, |'Foreign|
|00005300| 20 6b 65 79 20 76 69 6f | 6c 61 74 69 6f 6e 3a 20 | key vio|lation: |
|00005310| 62 6f 6f 6b 20 6e 6f 74 | 20 69 6e 20 62 6f 6f 6b |book not| in book|
|00005320| 73 27 29 0a 20 20 20 20 | 20 20 20 20 20 20 20 20 |s'). | |
|00005330| 45 4e 44 3b 0a 20 20 20 | 20 20 20 20 20 45 4e 44 |END;. | END|
|00005340| 3b 0a 20 20 20 20 20 20 | 20 20 43 52 45 41 54 45 |;. | CREATE|
|00005350| 20 54 52 49 47 47 45 52 | 20 66 6b 63 5f 64 61 74 | TRIGGER| fkc_dat|
|00005360| 61 5f 75 70 64 61 74 65 | 0a 20 20 20 20 20 20 20 |a_update|. |
|00005370| 20 42 45 46 4f 52 45 20 | 55 50 44 41 54 45 20 4f | BEFORE |UPDATE O|
|00005380| 46 20 62 6f 6f 6b 20 4f | 4e 20 64 61 74 61 0a 20 |F book O|N data. |
|00005390| 20 20 20 20 20 20 20 42 | 45 47 49 4e 0a 20 20 20 | B|EGIN. |
|000053a0| 20 20 20 20 20 20 20 20 | 20 53 45 4c 45 43 54 20 | | SELECT |
|000053b0| 43 41 53 45 0a 20 20 20 | 20 20 20 20 20 20 20 20 |CASE. | |
|000053c0| 20 20 20 20 20 57 48 45 | 4e 20 28 53 45 4c 45 43 | WHE|N (SELEC|
|000053d0| 54 20 69 64 20 66 72 6f | 6d 20 62 6f 6f 6b 73 20 |T id fro|m books |
|000053e0| 57 48 45 52 45 20 69 64 | 3d 4e 45 57 2e 62 6f 6f |WHERE id|=NEW.boo|
|000053f0| 6b 29 20 49 53 20 4e 55 | 4c 4c 0a 20 20 20 20 20 |k) IS NU|LL. |
|00005400| 20 20 20 20 20 20 20 20 | 20 20 20 54 48 45 4e 20 | | THEN |
|00005410| 52 41 49 53 45 28 41 42 | 4f 52 54 2c 20 27 46 6f |RAISE(AB|ORT, 'Fo|
|00005420| 72 65 69 67 6e 20 6b 65 | 79 20 76 69 6f 6c 61 74 |reign ke|y violat|
|00005430| 69 6f 6e 3a 20 62 6f 6f | 6b 20 6e 6f 74 20 69 6e |ion: boo|k not in|
|00005440| 20 62 6f 6f 6b 73 27 29 | 0a 20 20 20 20 20 20 20 | books')|. |
|00005450| 20 20 20 20 20 45 4e 44 | 3b 0a 20 20 20 20 20 20 | END|;. |
|00005460| 20 20 45 4e 44 3b 0a 0a | 20 20 20 20 20 20 20 20 | END;..| |
|00005470| 2f 2a 2a 2a 2a 20 63 6f | 76 65 72 73 20 74 61 62 |/**** co|vers tab|
|00005480| 6c 65 20 2a 2a 2a 2a 2f | 0a 20 20 20 20 20 20 20 |le ****/|. |
|00005490| 20 43 52 45 41 54 45 20 | 54 41 42 4c 45 20 63 6f | CREATE |TABLE co|
|000054a0| 76 65 72 73 20 28 20 69 | 64 20 49 4e 54 45 47 45 |vers ( i|d INTEGE|
|000054b0| 52 20 50 52 49 4d 41 52 | 59 20 4b 45 59 2c 0a 20 |R PRIMAR|Y KEY,. |
|000054c0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|000054d0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 62 6f 6f | | boo|
|000054e0| 6b 20 49 4e 54 45 47 45 | 52 20 4e 4f 4e 20 4e 55 |k INTEGE|R NON NU|
|000054f0| 4c 4c 2c 0a 20 20 20 20 | 20 20 20 20 20 20 20 20 |LL,. | |
|00005500| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00005510| 20 20 75 6e 63 6f 6d 70 | 72 65 73 73 65 64 5f 73 | uncomp|ressed_s|
|00005520| 69 7a 65 20 49 4e 54 45 | 47 45 52 20 4e 4f 4e 20 |ize INTE|GER NON |
|00005530| 4e 55 4c 4c 2c 0a 20 20 | 20 20 20 20 20 20 20 20 |NULL,. | |
|00005540| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00005550| 20 20 20 20 64 61 74 61 | 20 42 4c 4f 42 20 4e 4f | data| BLOB NO|
|00005560| 4e 20 4e 55 4c 4c 2c 0a | 20 20 20 20 20 20 20 20 |N NULL,.| |
|00005570| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00005580| 20 20 20 20 20 20 55 4e | 49 51 55 45 28 62 6f 6f | UN|IQUE(boo|
|00005590| 6b 29 0a 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |k). | |
|000055a0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 29 | | )|
|000055b0| 3b 0a 20 20 20 20 20 20 | 20 20 43 52 45 41 54 45 |;. | CREATE|
|000055c0| 20 49 4e 44 45 58 20 63 | 6f 76 65 72 73 5f 69 64 | INDEX c|overs_id|
|000055d0| 78 20 4f 4e 20 63 6f 76 | 65 72 73 20 28 62 6f 6f |x ON cov|ers (boo|
|000055e0| 6b 29 3b 0a 20 20 20 20 | 20 20 20 20 43 52 45 41 |k);. | CREA|
|000055f0| 54 45 20 54 52 49 47 47 | 45 52 20 66 6b 63 5f 63 |TE TRIGG|ER fkc_c|
|00005600| 6f 76 65 72 73 5f 69 6e | 73 65 72 74 0a 20 20 20 |overs_in|sert. |
|00005610| 20 20 20 20 20 42 45 46 | 4f 52 45 20 49 4e 53 45 | BEF|ORE INSE|
|00005620| 52 54 20 4f 4e 20 63 6f | 76 65 72 73 0a 20 20 20 |RT ON co|vers. |
|00005630| 20 20 20 20 20 42 45 47 | 49 4e 0a 20 20 20 20 20 | BEG|IN. |
|00005640| 20 20 20 20 20 20 20 53 | 45 4c 45 43 54 20 43 41 | S|ELECT CA|
|00005650| 53 45 0a 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |SE. | |
|00005660| 20 20 20 57 48 45 4e 20 | 28 53 45 4c 45 43 54 20 | WHEN |(SELECT |
|00005670| 69 64 20 66 72 6f 6d 20 | 62 6f 6f 6b 73 20 57 48 |id from |books WH|
|00005680| 45 52 45 20 69 64 3d 4e | 45 57 2e 62 6f 6f 6b 29 |ERE id=N|EW.book)|
|00005690| 20 49 53 20 4e 55 4c 4c | 0a 20 20 20 20 20 20 20 | IS NULL|. |
|000056a0| 20 20 20 20 20 20 20 20 | 20 54 48 45 4e 20 52 41 | | THEN RA|
|000056b0| 49 53 45 28 41 42 4f 52 | 54 2c 20 27 46 6f 72 65 |ISE(ABOR|T, 'Fore|
|000056c0| 69 67 6e 20 6b 65 79 20 | 76 69 6f 6c 61 74 69 6f |ign key |violatio|
|000056d0| 6e 3a 20 62 6f 6f 6b 20 | 6e 6f 74 20 69 6e 20 62 |n: book |not in b|
|000056e0| 6f 6f 6b 73 27 29 0a 20 | 20 20 20 20 20 20 20 20 |ooks'). | |
|000056f0| 20 20 20 45 4e 44 3b 0a | 20 20 20 20 20 20 20 20 | END;.| |
|00005700| 45 4e 44 3b 0a 20 20 20 | 20 20 20 20 20 43 52 45 |END;. | CRE|
|00005710| 41 54 45 20 54 52 49 47 | 47 45 52 20 66 6b 63 5f |ATE TRIG|GER fkc_|
|00005720| 63 6f 76 65 72 73 5f 75 | 70 64 61 74 65 0a 20 20 |covers_u|pdate. |
|00005730| 20 20 20 20 20 20 42 45 | 46 4f 52 45 20 55 50 44 | BE|FORE UPD|
|00005740| 41 54 45 20 4f 46 20 62 | 6f 6f 6b 20 4f 4e 20 63 |ATE OF b|ook ON c|
|00005750| 6f 76 65 72 73 0a 20 20 | 20 20 20 20 20 20 42 45 |overs. | BE|
|00005760| 47 49 4e 0a 20 20 20 20 | 20 20 20 20 20 20 20 20 |GIN. | |
|00005770| 53 45 4c 45 43 54 20 43 | 41 53 45 0a 20 20 20 20 |SELECT C|ASE. |
|00005780| 20 20 20 20 20 20 20 20 | 20 20 20 20 57 48 45 4e | | WHEN|
|00005790| 20 28 53 45 4c 45 43 54 | 20 69 64 20 66 72 6f 6d | (SELECT| id from|
|000057a0| 20 62 6f 6f 6b 73 20 57 | 48 45 52 45 20 69 64 3d | books W|HERE id=|
|000057b0| 4e 45 57 2e 62 6f 6f 6b | 29 20 49 53 20 4e 55 4c |NEW.book|) IS NUL|
|000057c0| 4c 0a 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |L. | |
|000057d0| 20 20 54 48 45 4e 20 52 | 41 49 53 45 28 41 42 4f | THEN R|AISE(ABO|
|000057e0| 52 54 2c 20 27 46 6f 72 | 65 69 67 6e 20 6b 65 79 |RT, 'For|eign key|
|000057f0| 20 76 69 6f 6c 61 74 69 | 6f 6e 3a 20 62 6f 6f 6b | violati|on: book|
|00005800| 20 6e 6f 74 20 69 6e 20 | 62 6f 6f 6b 73 27 29 0a | not in |books').|
|00005810| 20 20 20 20 20 20 20 20 | 20 20 20 20 45 4e 44 3b | | END;|
|00005820| 0a 20 20 20 20 20 20 20 | 20 45 4e 44 3b 0a 0a 20 |. | END;.. |
|00005830| 20 20 20 20 20 20 20 2f | 2a 2a 2a 2a 20 63 6f 6d | /|**** com|
|00005840| 6d 65 6e 74 73 20 74 61 | 62 6c 65 20 2a 2a 2a 2a |ments ta|ble ****|
|00005850| 2f 0a 20 20 20 20 20 20 | 20 20 43 52 45 41 54 45 |/. | CREATE|
|00005860| 20 54 41 42 4c 45 20 63 | 6f 6d 6d 65 6e 74 73 20 | TABLE c|omments |
|00005870| 28 20 69 64 20 49 4e 54 | 45 47 45 52 20 50 52 49 |( id INT|EGER PRI|
|00005880| 4d 41 52 59 20 4b 45 59 | 2c 0a 20 20 20 20 20 20 |MARY KEY|,. |
|00005890| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|000058a0| 20 20 20 20 20 20 20 20 | 62 6f 6f 6b 20 49 4e 54 | |book INT|
|000058b0| 45 47 45 52 20 4e 4f 4e | 20 4e 55 4c 4c 2c 0a 20 |EGER NON| NULL,. |
|000058c0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|000058d0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 74 65 78 | | tex|
|000058e0| 74 20 54 45 58 54 20 4e | 4f 4e 20 4e 55 4c 4c 20 |t TEXT N|ON NULL |
|000058f0| 43 4f 4c 4c 41 54 45 20 | 4e 4f 43 41 53 45 2c 0a |COLLATE |NOCASE,.|
|00005900| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00005910| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 55 4e | | UN|
|00005920| 49 51 55 45 28 62 6f 6f | 6b 29 0a 20 20 20 20 20 |IQUE(boo|k). |
|00005930| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00005940| 20 20 20 20 20 20 20 29 | 3b 0a 20 20 20 20 20 20 | )|;. |
|00005950| 20 20 43 52 45 41 54 45 | 20 49 4e 44 45 58 20 63 | CREATE| INDEX c|
|00005960| 6f 6d 6d 65 6e 74 73 5f | 69 64 78 20 4f 4e 20 63 |omments_|idx ON c|
|00005970| 6f 6d 6d 65 6e 74 73 20 | 28 62 6f 6f 6b 29 3b 0a |omments |(book);.|
|00005980| 20 20 20 20 20 20 20 20 | 43 52 45 41 54 45 20 54 | |CREATE T|
|00005990| 52 49 47 47 45 52 20 66 | 6b 63 5f 63 6f 6d 6d 65 |RIGGER f|kc_comme|
|000059a0| 6e 74 73 5f 69 6e 73 65 | 72 74 0a 20 20 20 20 20 |nts_inse|rt. |
|000059b0| 20 20 20 42 45 46 4f 52 | 45 20 49 4e 53 45 52 54 | BEFOR|E INSERT|
|000059c0| 20 4f 4e 20 63 6f 6d 6d | 65 6e 74 73 0a 20 20 20 | ON comm|ents. |
|000059d0| 20 20 20 20 20 42 45 47 | 49 4e 0a 20 20 20 20 20 | BEG|IN. |
|000059e0| 20 20 20 20 20 20 20 53 | 45 4c 45 43 54 20 43 41 | S|ELECT CA|
|000059f0| 53 45 0a 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |SE. | |
|00005a00| 20 20 20 57 48 45 4e 20 | 28 53 45 4c 45 43 54 20 | WHEN |(SELECT |
|00005a10| 69 64 20 66 72 6f 6d 20 | 62 6f 6f 6b 73 20 57 48 |id from |books WH|
|00005a20| 45 52 45 20 69 64 3d 4e | 45 57 2e 62 6f 6f 6b 29 |ERE id=N|EW.book)|
|00005a30| 20 49 53 20 4e 55 4c 4c | 0a 20 20 20 20 20 20 20 | IS NULL|. |
|00005a40| 20 20 20 20 20 20 20 20 | 20 54 48 45 4e 20 52 41 | | THEN RA|
|00005a50| 49 53 45 28 41 42 4f 52 | 54 2c 20 27 46 6f 72 65 |ISE(ABOR|T, 'Fore|
|00005a60| 69 67 6e 20 6b 65 79 20 | 76 69 6f 6c 61 74 69 6f |ign key |violatio|
|00005a70| 6e 3a 20 62 6f 6f 6b 20 | 6e 6f 74 20 69 6e 20 62 |n: book |not in b|
|00005a80| 6f 6f 6b 73 27 29 0a 20 | 20 20 20 20 20 20 20 20 |ooks'). | |
|00005a90| 20 20 20 45 4e 44 3b 0a | 20 20 20 20 20 20 20 20 | END;.| |
|00005aa0| 45 4e 44 3b 0a 20 20 20 | 20 20 20 20 20 43 52 45 |END;. | CRE|
|00005ab0| 41 54 45 20 54 52 49 47 | 47 45 52 20 66 6b 63 5f |ATE TRIG|GER fkc_|
|00005ac0| 63 6f 6d 6d 65 6e 74 73 | 5f 75 70 64 61 74 65 0a |comments|_update.|
|00005ad0| 20 20 20 20 20 20 20 20 | 42 45 46 4f 52 45 20 55 | |BEFORE U|
|00005ae0| 50 44 41 54 45 20 4f 46 | 20 62 6f 6f 6b 20 4f 4e |PDATE OF| book ON|
|00005af0| 20 63 6f 6d 6d 65 6e 74 | 73 0a 20 20 20 20 20 20 | comment|s. |
|00005b00| 20 20 42 45 47 49 4e 0a | 20 20 20 20 20 20 20 20 | BEGIN.| |
|00005b10| 20 20 20 20 53 45 4c 45 | 43 54 20 43 41 53 45 0a | SELE|CT CASE.|
|00005b20| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00005b30| 57 48 45 4e 20 28 53 45 | 4c 45 43 54 20 69 64 20 |WHEN (SE|LECT id |
|00005b40| 66 72 6f 6d 20 62 6f 6f | 6b 73 20 57 48 45 52 45 |from boo|ks WHERE|
|00005b50| 20 69 64 3d 4e 45 57 2e | 62 6f 6f 6b 29 20 49 53 | id=NEW.|book) IS|
|00005b60| 20 4e 55 4c 4c 0a 20 20 | 20 20 20 20 20 20 20 20 | NULL. | |
|00005b70| 20 20 20 20 20 20 54 48 | 45 4e 20 52 41 49 53 45 | TH|EN RAISE|
|00005b80| 28 41 42 4f 52 54 2c 20 | 27 46 6f 72 65 69 67 6e |(ABORT, |'Foreign|
|00005b90| 20 6b 65 79 20 76 69 6f | 6c 61 74 69 6f 6e 3a 20 | key vio|lation: |
|00005ba0| 62 6f 6f 6b 20 6e 6f 74 | 20 69 6e 20 62 6f 6f 6b |book not| in book|
|00005bb0| 73 27 29 0a 20 20 20 20 | 20 20 20 20 20 20 20 20 |s'). | |
|00005bc0| 45 4e 44 3b 0a 20 20 20 | 20 20 20 20 20 45 4e 44 |END;. | END|
|00005bd0| 3b 0a 0a 20 20 20 20 20 | 20 20 20 2f 2a 2a 2a 2a |;.. | /****|
|00005be0| 20 48 61 6e 64 6c 65 20 | 64 65 6c 65 74 69 6f 6e | Handle |deletion|
|00005bf0| 20 6f 66 20 62 6f 6f 6b | 20 2a 2a 2a 2a 2f 0a 20 | of book| ****/. |
|00005c00| 20 20 20 20 20 20 20 43 | 52 45 41 54 45 20 54 52 | C|REATE TR|
|00005c10| 49 47 47 45 52 20 62 6f | 6f 6b 73 5f 64 65 6c 65 |IGGER bo|oks_dele|
|00005c20| 74 65 5f 74 72 67 0a 20 | 20 20 20 20 20 20 20 41 |te_trg. | A|
|00005c30| 46 54 45 52 20 44 45 4c | 45 54 45 20 4f 4e 20 62 |FTER DEL|ETE ON b|
|00005c40| 6f 6f 6b 73 0a 20 20 20 | 20 20 20 20 20 42 45 47 |ooks. | BEG|
|00005c50| 49 4e 0a 20 20 20 20 20 | 20 20 20 20 20 20 20 44 |IN. | D|
|00005c60| 45 4c 45 54 45 20 46 52 | 4f 4d 20 62 6f 6f 6b 73 |ELETE FR|OM books|
|00005c70| 5f 61 75 74 68 6f 72 73 | 5f 6c 69 6e 6b 20 57 48 |_authors|_link WH|
|00005c80| 45 52 45 20 62 6f 6f 6b | 3d 4f 4c 44 2e 69 64 3b |ERE book|=OLD.id;|
|00005c90| 0a 20 20 20 20 20 20 20 | 20 20 20 20 20 44 45 4c |. | DEL|
|00005ca0| 45 54 45 20 46 52 4f 4d | 20 62 6f 6f 6b 73 5f 70 |ETE FROM| books_p|
|00005cb0| 75 62 6c 69 73 68 65 72 | 73 5f 6c 69 6e 6b 20 57 |ublisher|s_link W|
|00005cc0| 48 45 52 45 20 62 6f 6f | 6b 3d 4f 4c 44 2e 69 64 |HERE boo|k=OLD.id|
|00005cd0| 3b 0a 20 20 20 20 20 20 | 20 20 20 20 20 20 44 45 |;. | DE|
|00005ce0| 4c 45 54 45 20 46 52 4f | 4d 20 62 6f 6f 6b 73 5f |LETE FRO|M books_|
|00005cf0| 72 61 74 69 6e 67 73 5f | 6c 69 6e 6b 20 57 48 45 |ratings_|link WHE|
|00005d00| 52 45 20 62 6f 6f 6b 3d | 4f 4c 44 2e 69 64 3b 0a |RE book=|OLD.id;.|
|00005d10| 20 20 20 20 20 20 20 20 | 20 20 20 20 44 45 4c 45 | | DELE|
|00005d20| 54 45 20 46 52 4f 4d 20 | 62 6f 6f 6b 73 5f 73 65 |TE FROM |books_se|
|00005d30| 72 69 65 73 5f 6c 69 6e | 6b 20 57 48 45 52 45 20 |ries_lin|k WHERE |
|00005d40| 62 6f 6f 6b 3d 4f 4c 44 | 2e 69 64 3b 0a 20 20 20 |book=OLD|.id;. |
|00005d50| 20 20 20 20 20 20 20 20 | 20 44 45 4c 45 54 45 20 | | DELETE |
|00005d60| 46 52 4f 4d 20 62 6f 6f | 6b 73 5f 74 61 67 73 5f |FROM boo|ks_tags_|
|00005d70| 6c 69 6e 6b 20 57 48 45 | 52 45 20 62 6f 6f 6b 3d |link WHE|RE book=|
|00005d80| 4f 4c 44 2e 69 64 3b 0a | 20 20 20 20 20 20 20 20 |OLD.id;.| |
|00005d90| 20 20 20 20 44 45 4c 45 | 54 45 20 46 52 4f 4d 20 | DELE|TE FROM |
|00005da0| 64 61 74 61 20 57 48 45 | 52 45 20 62 6f 6f 6b 3d |data WHE|RE book=|
|00005db0| 4f 4c 44 2e 69 64 3b 0a | 20 20 20 20 20 20 20 20 |OLD.id;.| |
|00005dc0| 20 20 20 20 44 45 4c 45 | 54 45 20 46 52 4f 4d 20 | DELE|TE FROM |
|00005dd0| 63 6f 76 65 72 73 20 57 | 48 45 52 45 20 62 6f 6f |covers W|HERE boo|
|00005de0| 6b 3d 4f 4c 44 2e 69 64 | 3b 0a 20 20 20 20 20 20 |k=OLD.id|;. |
|00005df0| 20 20 20 20 20 20 44 45 | 4c 45 54 45 20 46 52 4f | DE|LETE FRO|
|00005e00| 4d 20 63 6f 6d 6d 65 6e | 74 73 20 57 48 45 52 45 |M commen|ts WHERE|
|00005e10| 20 62 6f 6f 6b 3d 4f 4c | 44 2e 69 64 3b 0a 20 20 | book=OL|D.id;. |
|00005e20| 20 20 20 20 20 20 45 4e | 44 3b 0a 0a 20 20 20 20 | EN|D;.. |
|00005e30| 20 20 20 20 2f 2a 2a 2a | 2a 20 56 69 65 77 73 20 | /***|* Views |
|00005e40| 2a 2a 2a 2a 2f 0a 20 20 | 20 20 20 20 20 20 43 52 |****/. | CR|
|00005e50| 45 41 54 45 20 56 49 45 | 57 20 6d 65 74 61 20 41 |EATE VIE|W meta A|
|00005e60| 53 0a 20 20 20 20 20 20 | 20 20 53 45 4c 45 43 54 |S. | SELECT|
|00005e70| 20 69 64 2c 20 74 69 74 | 6c 65 2c 0a 20 20 20 20 | id, tit|le,. |
|00005e80| 20 20 20 20 20 20 20 20 | 20 20 20 28 53 45 4c 45 | | (SELE|
|00005e90| 43 54 20 63 6f 6e 63 61 | 74 28 6e 61 6d 65 29 20 |CT conca|t(name) |
|00005ea0| 46 52 4f 4d 20 61 75 74 | 68 6f 72 73 20 57 48 45 |FROM aut|hors WHE|
|00005eb0| 52 45 20 61 75 74 68 6f | 72 73 2e 69 64 20 49 4e |RE autho|rs.id IN|
|00005ec0| 20 28 53 45 4c 45 43 54 | 20 61 75 74 68 6f 72 20 | (SELECT| author |
|00005ed0| 66 72 6f 6d 20 62 6f 6f | 6b 73 5f 61 75 74 68 6f |from boo|ks_autho|
|00005ee0| 72 73 5f 6c 69 6e 6b 20 | 57 48 45 52 45 20 62 6f |rs_link |WHERE bo|
|00005ef0| 6f 6b 3d 62 6f 6f 6b 73 | 2e 69 64 29 29 20 61 75 |ok=books|.id)) au|
|00005f00| 74 68 6f 72 73 2c 0a 20 | 20 20 20 20 20 20 20 20 |thors,. | |
|00005f10| 20 20 20 20 20 20 28 53 | 45 4c 45 43 54 20 6e 61 | (S|ELECT na|
|00005f20| 6d 65 20 46 52 4f 4d 20 | 70 75 62 6c 69 73 68 65 |me FROM |publishe|
|00005f30| 72 73 20 57 48 45 52 45 | 20 70 75 62 6c 69 73 68 |rs WHERE| publish|
|00005f40| 65 72 73 2e 69 64 20 49 | 4e 20 28 53 45 4c 45 43 |ers.id I|N (SELEC|
|00005f50| 54 20 70 75 62 6c 69 73 | 68 65 72 20 66 72 6f 6d |T publis|her from|
|00005f60| 20 62 6f 6f 6b 73 5f 70 | 75 62 6c 69 73 68 65 72 | books_p|ublisher|
|00005f70| 73 5f 6c 69 6e 6b 20 57 | 48 45 52 45 20 62 6f 6f |s_link W|HERE boo|
|00005f80| 6b 3d 62 6f 6f 6b 73 2e | 69 64 29 29 20 70 75 62 |k=books.|id)) pub|
|00005f90| 6c 69 73 68 65 72 2c 0a | 20 20 20 20 20 20 20 20 |lisher,.| |
|00005fa0| 20 20 20 20 20 20 20 28 | 53 45 4c 45 43 54 20 72 | (|SELECT r|
|00005fb0| 61 74 69 6e 67 20 46 52 | 4f 4d 20 72 61 74 69 6e |ating FR|OM ratin|
|00005fc0| 67 73 20 57 48 45 52 45 | 20 72 61 74 69 6e 67 73 |gs WHERE| ratings|
|00005fd0| 2e 69 64 20 49 4e 20 28 | 53 45 4c 45 43 54 20 72 |.id IN (|SELECT r|
|00005fe0| 61 74 69 6e 67 20 66 72 | 6f 6d 20 62 6f 6f 6b 73 |ating fr|om books|
|00005ff0| 5f 72 61 74 69 6e 67 73 | 5f 6c 69 6e 6b 20 57 48 |_ratings|_link WH|
|00006000| 45 52 45 20 62 6f 6f 6b | 3d 62 6f 6f 6b 73 2e 69 |ERE book|=books.i|
|00006010| 64 29 29 20 72 61 74 69 | 6e 67 2c 0a 20 20 20 20 |d)) rati|ng,. |
|00006020| 20 20 20 20 20 20 20 20 | 20 20 20 74 69 6d 65 73 | | times|
|00006030| 74 61 6d 70 2c 0a 20 20 | 20 20 20 20 20 20 20 20 |tamp,. | |
|00006040| 20 20 20 20 20 28 53 45 | 4c 45 43 54 20 4d 41 58 | (SE|LECT MAX|
|00006050| 28 75 6e 63 6f 6d 70 72 | 65 73 73 65 64 5f 73 69 |(uncompr|essed_si|
|00006060| 7a 65 29 20 46 52 4f 4d | 20 64 61 74 61 20 57 48 |ze) FROM| data WH|
|00006070| 45 52 45 20 62 6f 6f 6b | 3d 62 6f 6f 6b 73 2e 69 |ERE book|=books.i|
|00006080| 64 29 20 73 69 7a 65 2c | 0a 20 20 20 20 20 20 20 |d) size,|. |
|00006090| 20 20 20 20 20 20 20 20 | 28 53 45 4c 45 43 54 20 | |(SELECT |
|000060a0| 63 6f 6e 63 61 74 28 6e | 61 6d 65 29 20 46 52 4f |concat(n|ame) FRO|
|000060b0| 4d 20 74 61 67 73 20 57 | 48 45 52 45 20 74 61 67 |M tags W|HERE tag|
|000060c0| 73 2e 69 64 20 49 4e 20 | 28 53 45 4c 45 43 54 20 |s.id IN |(SELECT |
|000060d0| 74 61 67 20 66 72 6f 6d | 20 62 6f 6f 6b 73 5f 74 |tag from| books_t|
|000060e0| 61 67 73 5f 6c 69 6e 6b | 20 57 48 45 52 45 20 62 |ags_link| WHERE b|
|000060f0| 6f 6f 6b 3d 62 6f 6f 6b | 73 2e 69 64 29 29 20 74 |ook=book|s.id)) t|
|00006100| 61 67 73 2c 0a 20 20 20 | 20 20 20 20 20 20 20 20 |ags,. | |
|00006110| 20 20 20 20 28 53 45 4c | 45 43 54 20 74 65 78 74 | (SEL|ECT text|
|00006120| 20 46 52 4f 4d 20 63 6f | 6d 6d 65 6e 74 73 20 57 | FROM co|mments W|
|00006130| 48 45 52 45 20 62 6f 6f | 6b 3d 62 6f 6f 6b 73 2e |HERE boo|k=books.|
|00006140| 69 64 29 20 63 6f 6d 6d | 65 6e 74 73 2c 0a 20 20 |id) comm|ents,. |
|00006150| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 28 53 45 | | (SE|
|00006160| 4c 45 43 54 20 6e 61 6d | 65 20 46 52 4f 4d 20 73 |LECT nam|e FROM s|
|00006170| 65 72 69 65 73 20 57 48 | 45 52 45 20 73 65 72 69 |eries WH|ERE seri|
|00006180| 65 73 2e 69 64 20 49 4e | 20 28 53 45 4c 45 43 54 |es.id IN| (SELECT|
|00006190| 20 73 65 72 69 65 73 20 | 46 52 4f 4d 20 62 6f 6f | series |FROM boo|
|000061a0| 6b 73 5f 73 65 72 69 65 | 73 5f 6c 69 6e 6b 20 57 |ks_serie|s_link W|
|000061b0| 48 45 52 45 20 62 6f 6f | 6b 3d 62 6f 6f 6b 73 2e |HERE boo|k=books.|
|000061c0| 69 64 29 29 20 73 65 72 | 69 65 73 2c 0a 20 20 20 |id)) ser|ies,. |
|000061d0| 20 20 20 20 20 20 20 20 | 20 20 20 20 73 6f 72 74 | | sort|
|000061e0| 2c 0a 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |,. | |
|000061f0| 20 28 53 45 4c 45 43 54 | 20 73 6f 72 74 20 46 52 | (SELECT| sort FR|
|00006200| 4f 4d 20 61 75 74 68 6f | 72 73 20 57 48 45 52 45 |OM autho|rs WHERE|
|00006210| 20 61 75 74 68 6f 72 73 | 2e 69 64 20 49 4e 20 28 | authors|.id IN (|
|00006220| 53 45 4c 45 43 54 20 61 | 75 74 68 6f 72 20 66 72 |SELECT a|uthor fr|
|00006230| 6f 6d 20 62 6f 6f 6b 73 | 5f 61 75 74 68 6f 72 73 |om books|_authors|
|00006240| 5f 6c 69 6e 6b 20 57 48 | 45 52 45 20 62 6f 6f 6b |_link WH|ERE book|
|00006250| 3d 62 6f 6f 6b 73 2e 69 | 64 29 29 20 61 75 74 68 |=books.i|d)) auth|
|00006260| 6f 72 73 5f 73 6f 72 74 | 2c 0a 20 20 20 20 20 20 |ors_sort|,. |
|00006270| 20 20 20 20 20 20 20 20 | 20 28 53 45 4c 45 43 54 | | (SELECT|
|00006280| 20 73 6f 72 74 20 46 52 | 4f 4d 20 70 75 62 6c 69 | sort FR|OM publi|
|00006290| 73 68 65 72 73 20 57 48 | 45 52 45 20 70 75 62 6c |shers WH|ERE publ|
|000062a0| 69 73 68 65 72 73 2e 69 | 64 20 49 4e 20 28 53 45 |ishers.i|d IN (SE|
|000062b0| 4c 45 43 54 20 70 75 62 | 6c 69 73 68 65 72 20 66 |LECT pub|lisher f|
|000062c0| 72 6f 6d 20 62 6f 6f 6b | 73 5f 70 75 62 6c 69 73 |rom book|s_publis|
|000062d0| 68 65 72 73 5f 6c 69 6e | 6b 20 57 48 45 52 45 20 |hers_lin|k WHERE |
|000062e0| 62 6f 6f 6b 3d 62 6f 6f | 6b 73 2e 69 64 29 29 20 |book=boo|ks.id)) |
|000062f0| 70 75 62 6c 69 73 68 65 | 72 5f 73 6f 72 74 0a 20 |publishe|r_sort. |
|00006300| 20 20 20 20 20 20 20 46 | 52 4f 4d 20 62 6f 6f 6b | F|ROM book|
|00006310| 73 3b 0a 20 20 20 20 20 | 20 20 20 73 15 00 00 00 |s;. | s....|
|00006320| 70 72 61 67 6d 61 20 75 | 73 65 72 5f 76 65 72 73 |pragma u|ser_vers|
|00006330| 69 6f 6e 3d 31 28 03 00 | 00 00 74 0d 00 00 00 65 |ion=1(..|..t....e|
|00006340| 78 65 63 75 74 65 73 63 | 72 69 70 74 52 14 00 00 |xecutesc|riptR...|
|00006350| 00 52 54 00 00 00 28 01 | 00 00 00 52 39 00 00 00 |.RT...(.|...R9...|
|00006360| 28 00 00 00 00 28 00 00 | 00 00 73 29 00 00 00 73 |(....(..|..s)...s|
|00006370| 69 74 65 2d 70 61 63 6b | 61 67 65 73 5c 63 61 6c |ite-pack|ages\cal|
|00006380| 69 62 72 65 5c 6c 69 62 | 72 61 72 79 5c 64 61 74 |ibre\lib|rary\dat|
|00006390| 61 62 61 73 65 2e 70 79 | 74 0f 00 00 00 63 72 65 |abase.py|t....cre|
|000063a0| 61 74 65 5f 76 65 72 73 | 69 6f 6e 31 95 00 00 00 |ate_vers|ion1....|
|000063b0| 73 0a 00 00 00 00 02 06 | ff 00 9b 07 02 0d 01 63 |s.......|.......c|
|000063c0| 01 00 00 00 01 00 00 00 | 02 00 00 00 43 00 00 00 |........|....C...|
|000063d0| 73 28 00 00 00 7c 00 00 | 69 00 00 64 01 00 83 01 |s(...|..|i..d....|
|000063e0| 00 01 7c 00 00 69 01 00 | 64 02 00 83 01 00 01 7c |..|..i..|d......||
|000063f0| 00 00 69 02 00 83 00 00 | 01 64 00 00 53 28 03 00 |..i.....|.d..S(..|
+--------+-------------------------+-------------------------+--------+--------+
Only 25.0 KB of data is shown above.
