/ Programmer Plus 2007 / Programmer-Plus-2007.iso / Programming / SQL and Data Base / Logic Works ERwin 3.5 / data.1 / MOVIEDIM.ER1

< prev

next >

MacOS 8.1

Win98

DOS

view JSON data

view as text

+--------+-------------------------+-------------------------+--------+--------+
|00000000| 56 32 2e 34 31 20 45 52 | 77 69 00 00 00 00 ac c2 |V2.41 ER|wi......|
|00000010| 00 00 b4 c2 00 00 01 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000020| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000030| 00 00 01 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000040| 00 00 00 00 00 00 00 00 | 00 00 15 00 00 00 00 00 |........|........|
|00000050| 00 00 00 00 03 00 00 00 | ac 00 00 00 5b 1b 00 00 |........|....[...|
|00000060| 00 00 00 00 19 00 00 00 | 09 00 00 00 00 00 00 00 |........|........|
|00000070| 00 00 00 00 06 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000080| 00 00 00 00 02 00 40 01 | 32 00 00 00 28 c3 00 00 |......@.|2...(...|
|00000090| 14 00 00 00 b0 c2 00 00 | 28 00 00 00 03 00 00 00 |........|(.......|
|000000a0| 0b 00 08 00 43 48 41 52 | 28 31 38 29 00 00 00 00 |....CHAR|(18)....|
|000000b0| 00 00 00 00 00 00 13 00 | 58 25 4b 65 79 54 79 70 |........|X%KeyTyp|
|000000c0| 65 25 54 61 62 6c 65 4e | 61 6d 65 0d 00 25 45 6e |e%TableN|ame..%En|
|000000d0| 74 69 74 79 4e 61 6d 65 | 28 29 00 00 00 00 00 00 |tityName|()......|
|000000e0| 00 00 02 00 00 00 02 00 | 00 00 00 00 07 00 4e 6f |........|......No|
|000000f0| 74 65 20 49 44 ff ff 00 | 00 00 01 00 09 00 4e 6f |te ID...|......No|
|00000100| 74 65 20 54 65 78 74 ff | ff 00 00 00 00 00 00 00 |te Text.|........|
|00000110| 0c 00 00 00 01 00 00 00 | 19 00 00 00 00 01 00 00 |........|........|
|00000120| 00 1a 00 00 00 00 01 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000130| 00 00 00 00 00 00 00 00 | 00 00 00 00 14 00 00 00 |........|........|
|00000140| 00 02 00 00 00 1a 00 00 | 00 00 02 00 00 00 00 00 |........|........|
|00000150| 00 00 00 04 00 00 00 00 | 00 00 00 00 01 00 00 00 |........|........|
|00000160| 00 00 00 00 00 01 00 00 | 00 00 00 00 00 00 01 00 |........|........|
|00000170| 00 00 00 00 00 00 00 02 | 00 00 00 00 00 00 00 00 |........|........|
|00000180| 01 00 00 00 00 00 00 00 | 08 00 00 00 01 00 00 00 |........|........|
|00000190| 1e 00 00 00 00 01 00 00 | 00 32 00 00 00 00 01 00 |........|.2......|
|000001a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000001b0| 02 00 00 00 00 00 00 00 | 00 04 00 00 00 00 00 00 |........|........|
|000001c0| 00 00 04 00 00 00 00 00 | 00 00 00 02 00 00 00 00 |........|........|
|000001d0| 00 00 00 00 06 00 00 00 | 08 00 00 00 11 00 43 55 |........|......CU|
|000001e0| 52 52 45 4e 54 5f 54 49 | 4d 45 53 54 41 4d 50 11 |RRENT_TI|MESTAMP.|
|000001f0| 00 43 55 52 52 45 4e 54 | 5f 54 49 4d 45 53 54 41 |.CURRENT|_TIMESTA|
|00000200| 4d 50 00 00 03 00 00 00 | 00 00 00 00 00 00 00 00 |MP......|........|
|00000210| 08 00 00 00 0c 00 43 55 | 52 52 45 4e 54 5f 55 53 |......CU|RRENT_US|
|00000220| 45 52 0c 00 43 55 52 52 | 45 4e 54 5f 55 53 45 52 |ER..CURR|ENT_USER|
|00000230| 00 00 03 00 00 00 00 00 | 00 00 00 00 00 00 08 00 |........|........|
|00000240| 00 00 04 00 4e 55 4c 4c | 04 00 4e 55 4c 4c 00 00 |....NULL|..NULL..|
|00000250| 03 00 00 00 00 00 00 00 | 00 00 00 00 08 00 00 00 |........|........|
|00000260| 0c 00 53 45 53 53 49 4f | 4e 5f 55 53 45 52 0c 00 |..SESSIO|N_USER..|
|00000270| 53 45 53 53 49 4f 4e 5f | 55 53 45 52 00 00 03 00 |SESSION_|USER....|
|00000280| 00 00 00 00 00 00 00 00 | 00 00 08 00 00 00 04 00 |........|........|
|00000290| 55 53 45 52 04 00 55 53 | 45 52 00 00 03 00 00 00 |USER..US|ER......|
|000002a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 05 00 |........|........|
|000002b0| 00 00 01 00 0d 00 54 65 | 6d 70 6c 61 74 65 20 4e |......Te|mplate N|
|000002c0| 61 6d 65 22 00 00 00 00 | 01 00 0d 00 54 65 6d 70 |ame"....|....Temp|
|000002d0| 6c 61 74 65 20 43 6f 64 | 65 00 00 00 00 00 00 00 |late Cod|e.......|
|000002e0| 0d 00 54 65 6d 70 6c 61 | 74 65 20 54 79 70 65 00 |..Templa|te Type.|
|000002f0| 00 00 00 00 00 00 0f 00 | 54 65 6d 70 6c 61 74 65 |........|Template|
|00000300| 20 43 53 58 20 49 64 00 | 00 00 00 00 02 00 00 00 | CSX Id.|........|
|00000310| 00 00 00 00 00 23 00 00 | 00 05 00 00 00 16 00 50 |.....#..|.......P|
|00000320| 41 52 45 4e 54 20 55 50 | 44 41 54 45 20 52 45 53 |ARENT UP|DATE RES|
|00000330| 54 52 49 43 54 f7 01 20 | 20 2f 2a 20 45 52 77 69 |TRICT.. | /* ERwi|
|00000340| 6e 20 42 75 69 6c 74 69 | 6e 20 25 44 61 74 65 74 |n Builti|n %Datet|
|00000350| 69 6d 65 20 2a 2f 0d 0a | 20 20 2f 2a 20 25 50 61 |ime */..|  /* %Pa|
|00000360| 72 65 6e 74 20 25 56 65 | 72 62 50 68 72 61 73 65 |rent %Ve|rbPhrase|
|00000370| 20 25 43 68 69 6c 64 20 | 4f 4e 20 50 41 52 45 4e | %Child |ON PAREN|
|00000380| 54 20 55 50 44 41 54 45 | 20 52 45 53 54 52 49 43 |T UPDATE| RESTRIC|
|00000390| 54 20 2a 2f 0d 0a 20 20 | 69 66 0d 0a 20 20 20 20 |T */..  |if..    |
|000003a0| 2f 2a 20 25 25 50 61 72 | 65 6e 74 50 4b 28 22 20 |/* %%Par|entPK(" |
|000003b0| 6f 72 22 2c 75 70 64 61 | 74 65 29 20 2a 2f 0d 0a |or",upda|te) */..|
|000003c0| 20 20 20 20 25 50 61 72 | 65 6e 74 50 4b 28 22 20 |    %Par|entPK(" |
|000003d0| 6f 72 22 2c 75 70 64 61 | 74 65 29 0d 0a 20 20 62 |or",upda|te)..  b|
|000003e0| 65 67 69 6e 0d 0a 20 20 | 20 20 69 66 20 65 78 69 |egin..  |  if exi|
|000003f0| 73 74 73 20 28 0d 0a 20 | 20 20 20 20 20 73 65 6c |sts (.. |     sel|
|00000400| 65 63 74 20 2a 20 66 72 | 6f 6d 20 64 65 6c 65 74 |ect * fr|om delet|
|00000410| 65 64 2c 25 43 68 69 6c | 64 0d 0a 20 20 20 20 20 |ed,%Chil|d..     |
|00000420| 20 77 68 65 72 65 0d 0a | 20 20 20 20 20 20 20 20 | where..|        |
|00000430| 2f 2a 20 20 25 25 4a 6f | 69 6e 46 4b 50 4b 28 25 |/*  %%Jo|inFKPK(%|
|00000440| 43 68 69 6c 64 2c 64 65 | 6c 65 74 65 64 2c 22 20 |Child,de|leted," |
|00000450| 3d 20 22 2c 22 20 61 6e | 64 22 29 20 2a 2f 0d 0a |= "," an|d") */..|
|00000460| 20 20 20 20 20 20 20 20 | 25 4a 6f 69 6e 46 4b 50 |        |%JoinFKP|
|00000470| 4b 28 25 43 68 69 6c 64 | 2c 64 65 6c 65 74 65 64 |K(%Child|,deleted|
|00000480| 2c 22 20 3d 20 22 2c 22 | 20 61 6e 64 22 29 0d 0a |," = ","| and")..|
|00000490| 20 20 20 20 29 0d 0a 20 | 20 20 20 62 65 67 69 6e |    ).. |   begin|
|000004a0| 0d 0a 20 20 20 20 20 20 | 73 65 6c 65 63 74 20 40 |..      |select @|
|000004b0| 65 72 72 6e 6f 20 20 3d | 20 33 30 30 30 35 2c 0d |errno  =| 30005,.|
|000004c0| 0a 20 20 20 20 20 20 20 | 20 20 20 20 20 20 40 65 |.       |      @e|
|000004d0| 72 72 6d 73 67 20 3d 20 | 27 43 61 6e 6e 6f 74 20 |rrmsg = |'Cannot |
|000004e0| 55 50 44 41 54 45 20 22 | 25 50 61 72 65 6e 74 22 |UPDATE "|%Parent"|
|000004f0| 20 62 65 63 61 75 73 65 | 20 22 25 43 68 69 6c 64 | because| "%Child|
|00000500| 22 20 65 78 69 73 74 73 | 2e 27 0d 0a 20 20 20 20 |" exists|.'..    |
|00000510| 20 20 67 6f 74 6f 20 65 | 72 72 6f 72 0d 0a 20 20 |  goto e|rror..  |
|00000520| 20 20 65 6e 64 0d 0a 20 | 20 65 6e 64 0d 0a 10 27 |  end.. | end...'|
|00000530| 00 00 00 00 00 00 00 00 | 00 00 05 00 00 00 15 00 |........|........|
|00000540| 50 41 52 45 4e 54 20 55 | 50 44 41 54 45 20 43 41 |PARENT U|PDATE CA|
|00000550| 53 43 41 44 45 f1 02 20 | 20 2f 2a 20 45 52 77 69 |SCADE.. | /* ERwi|
|00000560| 6e 20 42 75 69 6c 74 69 | 6e 20 25 44 61 74 65 74 |n Builti|n %Datet|
|00000570| 69 6d 65 20 2a 2f 0d 0a | 20 20 2f 2a 20 25 50 61 |ime */..|  /* %Pa|
|00000580| 72 65 6e 74 20 25 56 65 | 72 62 50 68 72 61 73 65 |rent %Ve|rbPhrase|
|00000590| 20 25 43 68 69 6c 64 20 | 4f 4e 20 50 41 52 45 4e | %Child |ON PAREN|
|000005a0| 54 20 55 50 44 41 54 45 | 20 43 41 53 43 41 44 45 |T UPDATE| CASCADE|
|000005b0| 20 2a 2f 0d 0a 20 20 69 | 66 0d 0a 20 20 20 20 2f | */..  i|f..    /|
|000005c0| 2a 20 25 25 50 61 72 65 | 6e 74 50 4b 28 22 20 6f |* %%Pare|ntPK(" o|
|000005d0| 72 22 2c 75 70 64 61 74 | 65 29 20 2a 2f 0d 0a 20 |r",updat|e) */.. |
|000005e0| 20 20 20 25 50 61 72 65 | 6e 74 50 4b 28 22 20 6f |   %Pare|ntPK(" o|
|000005f0| 72 22 2c 75 70 64 61 74 | 65 29 0d 0a 20 20 62 65 |r",updat|e)..  be|
|00000600| 67 69 6e 0d 0a 20 20 20 | 20 69 66 20 40 6e 75 6d |gin..   | if @num|
|00000610| 72 6f 77 73 20 3d 20 31 | 0d 0a 20 20 20 20 62 65 |rows = 1|..    be|
|00000620| 67 69 6e 0d 0a 20 20 20 | 20 20 20 73 65 6c 65 63 |gin..   |   selec|
|00000630| 74 20 25 4a 6f 69 6e 50 | 4b 50 4b 28 40 69 6e 73 |t %JoinP|KPK(@ins|
|00000640| 2c 69 6e 73 65 72 74 65 | 64 2c 22 20 3d 20 22 2c |,inserte|d," = ",|
|00000650| 22 2c 20 22 29 0d 0a 20 | 20 20 20 20 20 20 20 66 |", ").. |       f|
|00000660| 72 6f 6d 20 69 6e 73 65 | 72 74 65 64 0d 0a 20 20 |rom inse|rted..  |
|00000670| 20 20 20 20 75 70 64 61 | 74 65 20 25 43 68 69 6c |    upda|te %Chil|
|00000680| 64 0d 0a 20 20 20 20 20 | 20 73 65 74 0d 0a 20 20 |d..     | set..  |
|00000690| 20 20 20 20 20 20 2f 2a | 20 20 25 25 4a 6f 69 6e |      /*|  %%Join|
|000006a0| 46 4b 50 4b 28 25 43 68 | 69 6c 64 2c 40 69 6e 73 |FKPK(%Ch|ild,@ins|
|000006b0| 2c 22 20 3d 20 22 2c 22 | 2c 22 29 20 2a 2f 0d 0a |," = ","|,") */..|
|000006c0| 20 20 20 20 20 20 20 20 | 25 4a 6f 69 6e 46 4b 50 |        |%JoinFKP|
|000006d0| 4b 28 25 43 68 69 6c 64 | 2c 40 69 6e 73 2c 22 20 |K(%Child|,@ins," |
|000006e0| 3d 20 22 2c 22 2c 22 29 | 0d 0a 20 20 20 20 20 20 |= ",",")|..      |
|000006f0| 66 72 6f 6d 20 25 43 68 | 69 6c 64 2c 69 6e 73 65 |from %Ch|ild,inse|
|00000700| 72 74 65 64 2c 64 65 6c | 65 74 65 64 0d 0a 20 20 |rted,del|eted..  |
|00000710| 20 20 20 20 77 68 65 72 | 65 0d 0a 20 20 20 20 20 |    wher|e..     |
|00000720| 20 20 20 2f 2a 20 20 25 | 25 4a 6f 69 6e 46 4b 50 |   /*  %|%JoinFKP|
|00000730| 4b 28 25 43 68 69 6c 64 | 2c 64 65 6c 65 74 65 64 |K(%Child|,deleted|
|00000740| 2c 22 20 3d 20 22 2c 22 | 20 61 6e 64 22 29 20 2a |," = ","| and") *|
|00000750| 2f 0d 0a 20 20 20 20 20 | 20 20 20 25 4a 6f 69 6e |/..     |   %Join|
|00000760| 46 4b 50 4b 28 25 43 68 | 69 6c 64 2c 64 65 6c 65 |FKPK(%Ch|ild,dele|
|00000770| 74 65 64 2c 22 20 3d 20 | 22 2c 22 20 61 6e 64 22 |ted," = |"," and"|
|00000780| 29 0d 0a 20 20 20 20 65 | 6e 64 0d 0a 20 20 20 20 |)..    e|nd..    |
|00000790| 65 6c 73 65 0d 0a 20 20 | 20 20 62 65 67 69 6e 0d |else..  |  begin.|
|000007a0| 0a 20 20 20 20 20 20 73 | 65 6c 65 63 74 20 40 65 |.      s|elect @e|
|000007b0| 72 72 6e 6f 20 3d 20 33 | 30 30 30 36 2c 0d 0a 20 |rrno = 3|0006,.. |
|000007c0| 20 20 20 20 20 20 20 20 | 20 20 20 20 40 65 72 72 |        |    @err|
|000007d0| 6d 73 67 20 3d 20 27 43 | 61 6e 6e 6f 74 20 63 61 |msg = 'C|annot ca|
|000007e0| 73 63 61 64 65 20 22 25 | 50 61 72 65 6e 74 22 20 |scade "%|Parent" |
|000007f0| 55 50 44 41 54 45 20 62 | 65 63 61 75 73 65 20 6d |UPDATE b|ecause m|
|00000800| 6f 72 65 20 74 68 61 6e | 20 6f 6e 65 20 72 6f 77 |ore than| one row|
|00000810| 20 68 61 73 20 62 65 65 | 6e 20 61 66 66 65 63 74 | has bee|n affect|
|00000820| 65 64 2e 27 0d 0a 20 20 | 20 20 20 20 67 6f 74 6f |ed.'..  |    goto|
|00000830| 20 65 72 72 6f 72 0d 0a | 20 20 20 20 65 6e 64 0d | error..|    end.|
|00000840| 0a 20 20 65 6e 64 0d 0a | 11 27 00 00 00 00 00 00 |.  end..|.'......|
|00000850| 00 00 00 00 05 00 00 00 | 16 00 50 41 52 45 4e 54 |........|..PARENT|
|00000860| 20 55 50 44 41 54 45 20 | 53 45 54 20 4e 55 4c 4c | UPDATE |SET NULL|
|00000870| a4 01 20 20 2f 2a 20 45 | 52 77 69 6e 20 42 75 69 |..  /* E|Rwin Bui|
|00000880| 6c 74 69 6e 20 25 44 61 | 74 65 74 69 6d 65 20 2a |ltin %Da|tetime *|
|00000890| 2f 0d 0a 20 20 2f 2a 20 | 25 50 61 72 65 6e 74 20 |/..  /* |%Parent |
|000008a0| 25 56 65 72 62 50 68 72 | 61 73 65 20 25 43 68 69 |%VerbPhr|ase %Chi|
|000008b0| 6c 64 20 4f 4e 20 50 41 | 52 45 4e 54 20 55 50 44 |ld ON PA|RENT UPD|
|000008c0| 41 54 45 20 53 45 54 20 | 4e 55 4c 4c 20 2a 2f 0d |ATE SET |NULL */.|
|000008d0| 0a 20 20 69 66 0d 0a 20 | 20 20 20 2f 2a 20 25 25 |.  if.. |   /* %%|
|000008e0| 50 61 72 65 6e 74 50 4b | 28 22 20 6f 72 22 2c 75 |ParentPK|(" or",u|
|000008f0| 70 64 61 74 65 29 20 2a | 2f 0d 0a 20 20 20 20 25 |pdate) *|/..    %|
|00000900| 50 61 72 65 6e 74 50 4b | 28 22 20 6f 72 22 2c 75 |ParentPK|(" or",u|
|00000910| 70 64 61 74 65 29 0d 0a | 20 20 62 65 67 69 6e 0d |pdate)..|  begin.|
|00000920| 0a 20 20 20 20 75 70 64 | 61 74 65 20 25 43 68 69 |.    upd|ate %Chi|
|00000930| 6c 64 0d 0a 20 20 20 20 | 20 20 73 65 74 0d 0a 20 |ld..    |  set.. |
|00000940| 20 20 20 20 20 20 20 2f | 2a 20 25 25 53 65 74 46 |       /|* %%SetF|
|00000950| 4b 28 25 43 68 69 6c 64 | 2c 4e 55 4c 4c 29 20 2a |K(%Child|,NULL) *|
|00000960| 2f 0d 0a 20 20 20 20 20 | 20 20 20 25 53 65 74 46 |/..     |   %SetF|
|00000970| 4b 28 25 43 68 69 6c 64 | 2c 4e 55 4c 4c 29 0d 0a |K(%Child|,NULL)..|
|00000980| 20 20 20 20 20 20 66 72 | 6f 6d 20 25 43 68 69 6c |      fr|om %Chil|
|00000990| 64 2c 64 65 6c 65 74 65 | 64 0d 0a 20 20 20 20 20 |d,delete|d..     |
|000009a0| 20 77 68 65 72 65 0d 0a | 20 20 20 20 20 20 20 20 | where..|        |
|000009b0| 2f 2a 20 25 25 4a 6f 69 | 6e 46 4b 50 4b 28 25 43 |/* %%Joi|nFKPK(%C|
|000009c0| 68 69 6c 64 2c 64 65 6c | 65 74 65 64 2c 22 20 3d |hild,del|eted," =|
|000009d0| 20 22 2c 22 20 61 6e 64 | 22 29 20 2a 2f 0d 0a 20 | "," and|") */.. |
|000009e0| 20 20 20 20 20 20 20 25 | 4a 6f 69 6e 46 4b 50 4b |       %|JoinFKPK|
|000009f0| 28 25 43 68 69 6c 64 2c | 64 65 6c 65 74 65 64 2c |(%Child,|deleted,|
|00000a00| 22 20 3d 20 22 2c 22 20 | 61 6e 64 22 29 0d 0a 20 |" = "," |and").. |
|00000a10| 20 65 6e 64 0d 0a 12 27 | 00 00 00 00 00 00 00 00 | end...'|........|
|00000a20| 00 00 05 00 00 00 16 00 | 50 41 52 45 4e 54 20 44 |........|PARENT D|
|00000a30| 45 4c 45 54 45 20 52 45 | 53 54 52 49 43 54 a4 01 |ELETE RE|STRICT..|
|00000a40| 20 20 20 20 2f 2a 20 45 | 52 77 69 6e 20 42 75 69 |    /* E|Rwin Bui|
|00000a50| 6c 74 69 6e 20 25 44 61 | 74 65 74 69 6d 65 20 2a |ltin %Da|tetime *|
|00000a60| 2f 0d 0a 20 20 20 20 2f | 2a 20 25 50 61 72 65 6e |/..    /|* %Paren|
|00000a70| 74 20 25 56 65 72 62 50 | 68 72 61 73 65 20 25 43 |t %VerbP|hrase %C|
|00000a80| 68 69 6c 64 20 4f 4e 20 | 50 41 52 45 4e 54 20 44 |hild ON |PARENT D|
|00000a90| 45 4c 45 54 45 20 52 45 | 53 54 52 49 43 54 20 2a |ELETE RE|STRICT *|
|00000aa0| 2f 0d 0a 20 20 20 20 69 | 66 20 65 78 69 73 74 73 |/..    i|f exists|
|00000ab0| 20 28 0d 0a 20 20 20 20 | 20 20 73 65 6c 65 63 74 | (..    |  select|
|00000ac0| 20 2a 20 66 72 6f 6d 20 | 64 65 6c 65 74 65 64 2c | * from |deleted,|
|00000ad0| 25 43 68 69 6c 64 0d 0a | 20 20 20 20 20 20 77 68 |%Child..|      wh|
|00000ae0| 65 72 65 0d 0a 20 20 20 | 20 20 20 20 20 2f 2a 20 |ere..   |     /* |
|00000af0| 20 25 25 4a 6f 69 6e 46 | 4b 50 4b 28 25 43 68 69 | %%JoinF|KPK(%Chi|
|00000b00| 6c 64 2c 64 65 6c 65 74 | 65 64 2c 22 20 3d 20 22 |ld,delet|ed," = "|
|00000b10| 2c 22 20 61 6e 64 22 29 | 20 2a 2f 0d 0a 20 20 20 |," and")| */..   |
|00000b20| 20 20 20 20 20 25 4a 6f | 69 6e 46 4b 50 4b 28 25 |     %Jo|inFKPK(%|
|00000b30| 43 68 69 6c 64 2c 64 65 | 6c 65 74 65 64 2c 22 20 |Child,de|leted," |
|00000b40| 3d 20 22 2c 22 20 61 6e | 64 22 29 0d 0a 20 20 20 |= "," an|d")..   |
|00000b50| 20 29 0d 0a 20 20 20 20 | 62 65 67 69 6e 0d 0a 20 | )..    |begin.. |
|00000b60| 20 20 20 20 20 73 65 6c | 65 63 74 20 40 65 72 72 |     sel|ect @err|
|00000b70| 6e 6f 20 20 3d 20 33 30 | 30 30 31 2c 0d 0a 20 20 |no  = 30|001,..  |
|00000b80| 20 20 20 20 20 20 20 20 | 20 20 20 40 65 72 72 6d |        |   @errm|
|00000b90| 73 67 20 3d 20 27 43 61 | 6e 6e 6f 74 20 44 45 4c |sg = 'Ca|nnot DEL|
|00000ba0| 45 54 45 20 22 25 50 61 | 72 65 6e 74 22 20 62 65 |ETE "%Pa|rent" be|
|00000bb0| 63 61 75 73 65 20 22 25 | 43 68 69 6c 64 22 20 65 |cause "%|Child" e|
|00000bc0| 78 69 73 74 73 2e 27 0d | 0a 20 20 20 20 20 20 67 |xists.'.|.      g|
|00000bd0| 6f 74 6f 20 65 72 72 6f | 72 0d 0a 20 20 20 20 65 |oto erro|r..    e|
|00000be0| 6e 64 0d 0a 14 27 00 00 | 00 00 00 00 00 00 00 00 |nd...'..|........|
|00000bf0| 05 00 00 00 15 00 50 41 | 52 45 4e 54 20 44 45 4c |......PA|RENT DEL|
|00000c00| 45 54 45 20 43 41 53 43 | 41 44 45 05 01 20 20 20 |ETE CASC|ADE..   |
|00000c10| 20 2f 2a 20 45 52 77 69 | 6e 20 42 75 69 6c 74 69 | /* ERwi|n Builti|
|00000c20| 6e 20 25 44 61 74 65 74 | 69 6d 65 20 2a 2f 0d 0a |n %Datet|ime */..|
|00000c30| 20 20 20 20 2f 2a 20 25 | 50 61 72 65 6e 74 20 25 |    /* %|Parent %|
|00000c40| 56 65 72 62 50 68 72 61 | 73 65 20 25 43 68 69 6c |VerbPhra|se %Chil|
|00000c50| 64 20 4f 4e 20 50 41 52 | 45 4e 54 20 44 45 4c 45 |d ON PAR|ENT DELE|
|00000c60| 54 45 20 43 41 53 43 41 | 44 45 20 2a 2f 0d 0a 20 |TE CASCA|DE */.. |
|00000c70| 20 20 20 64 65 6c 65 74 | 65 20 25 43 68 69 6c 64 |   delet|e %Child|
|00000c80| 0d 0a 20 20 20 20 20 20 | 66 72 6f 6d 20 25 43 68 |..      |from %Ch|
|00000c90| 69 6c 64 2c 64 65 6c 65 | 74 65 64 0d 0a 20 20 20 |ild,dele|ted..   |
|00000ca0| 20 20 20 77 68 65 72 65 | 0d 0a 20 20 20 20 20 20 |   where|..      |
|00000cb0| 20 20 2f 2a 20 20 25 25 | 4a 6f 69 6e 46 4b 50 4b |  /*  %%|JoinFKPK|
|00000cc0| 28 25 43 68 69 6c 64 2c | 64 65 6c 65 74 65 64 2c |(%Child,|deleted,|
|00000cd0| 22 20 3d 20 22 2c 22 20 | 61 6e 64 22 29 20 2a 2f |" = "," |and") */|
|00000ce0| 0d 0a 20 20 20 20 20 20 | 20 20 25 4a 6f 69 6e 46 |..      |  %JoinF|
|00000cf0| 4b 50 4b 28 25 43 68 69 | 6c 64 2c 64 65 6c 65 74 |KPK(%Chi|ld,delet|
|00000d00| 65 64 2c 22 20 3d 20 22 | 2c 22 20 61 6e 64 22 29 |ed," = "|," and")|
|00000d10| 0d 0a 15 27 00 00 00 00 | 00 00 00 00 00 00 05 00 |...'....|........|
|00000d20| 00 00 16 00 50 41 52 45 | 4e 54 20 44 45 4c 45 54 |....PARE|NT DELET|
|00000d30| 45 20 53 45 54 20 4e 55 | 4c 4c 51 01 20 20 20 20 |E SET NU|LLQ.    |
|00000d40| 2f 2a 20 45 52 77 69 6e | 20 42 75 69 6c 74 69 6e |/* ERwin| Builtin|
|00000d50| 20 25 44 61 74 65 74 69 | 6d 65 20 2a 2f 0d 0a 20 | %Dateti|me */.. |
|00000d60| 20 20 20 2f 2a 20 25 50 | 61 72 65 6e 74 20 25 56 |   /* %P|arent %V|
|00000d70| 65 72 62 50 68 72 61 73 | 65 20 25 43 68 69 6c 64 |erbPhras|e %Child|
|00000d80| 20 4f 4e 20 50 41 52 45 | 4e 54 20 44 45 4c 45 54 | ON PARE|NT DELET|
|00000d90| 45 20 53 45 54 20 4e 55 | 4c 4c 20 2a 2f 0d 0a 20 |E SET NU|LL */.. |
|00000da0| 20 20 20 75 70 64 61 74 | 65 20 25 43 68 69 6c 64 |   updat|e %Child|
|00000db0| 0d 0a 20 20 20 20 20 20 | 73 65 74 0d 0a 20 20 20 |..      |set..   |
|00000dc0| 20 20 20 20 20 2f 2a 20 | 25 25 53 65 74 46 4b 28 |     /* |%%SetFK(|
|00000dd0| 25 43 68 69 6c 64 2c 4e | 55 4c 4c 29 20 2a 2f 0d |%Child,N|ULL) */.|
|00000de0| 0a 20 20 20 20 20 20 20 | 20 25 53 65 74 46 4b 28 |.       | %SetFK(|
|00000df0| 25 43 68 69 6c 64 2c 4e | 55 4c 4c 29 0d 0a 20 20 |%Child,N|ULL)..  |
|00000e00| 20 20 20 20 66 72 6f 6d | 20 25 43 68 69 6c 64 2c |    from| %Child,|
|00000e10| 64 65 6c 65 74 65 64 0d | 0a 20 20 20 20 20 20 77 |deleted.|.      w|
|00000e20| 68 65 72 65 0d 0a 20 20 | 20 20 20 20 20 20 2f 2a |here..  |      /*|
|00000e30| 20 25 25 4a 6f 69 6e 46 | 4b 50 4b 28 25 43 68 69 | %%JoinF|KPK(%Chi|
|00000e40| 6c 64 2c 64 65 6c 65 74 | 65 64 2c 22 20 3d 20 22 |ld,delet|ed," = "|
|00000e50| 2c 22 20 61 6e 64 22 29 | 20 2a 2f 0d 0a 20 20 20 |," and")| */..   |
|00000e60| 20 20 20 20 20 25 4a 6f | 69 6e 46 4b 50 4b 28 25 |     %Jo|inFKPK(%|
|00000e70| 43 68 69 6c 64 2c 64 65 | 6c 65 74 65 64 2c 22 20 |Child,de|leted," |
|00000e80| 3d 20 22 2c 22 20 61 6e | 64 22 29 0d 0a 16 27 00 |= "," an|d")...'.|
|00000e90| 00 00 00 00 00 00 00 00 | 00 05 00 00 00 15 00 43 |........|.......C|
|00000ea0| 48 49 4c 44 20 49 4e 53 | 45 52 54 20 52 45 53 54 |HILD INS|ERT REST|
|00000eb0| 52 49 43 54 f0 02 20 20 | 2f 2a 20 45 52 77 69 6e |RICT..  |/* ERwin|
|00000ec0| 20 42 75 69 6c 74 69 6e | 20 25 44 61 74 65 74 69 | Builtin| %Dateti|
|00000ed0| 6d 65 20 2a 2f 0d 0a 20 | 20 2f 2a 20 25 50 61 72 |me */.. | /* %Par|
|00000ee0| 65 6e 74 20 25 56 65 72 | 62 50 68 72 61 73 65 20 |ent %Ver|bPhrase |
|00000ef0| 25 43 68 69 6c 64 20 4f | 4e 20 43 48 49 4c 44 20 |%Child O|N CHILD |
|00000f00| 49 4e 53 45 52 54 20 52 | 45 53 54 52 49 43 54 20 |INSERT R|ESTRICT |
|00000f10| 2a 2f 0d 0a 20 20 69 66 | 0d 0a 20 20 20 20 2f 2a |*/..  if|..    /*|
|00000f20| 20 25 25 43 68 69 6c 64 | 46 4b 28 22 20 6f 72 22 | %%Child|FK(" or"|
|00000f30| 2c 75 70 64 61 74 65 29 | 20 2a 2f 0d 0a 20 20 20 |,update)| */..   |
|00000f40| 20 25 43 68 69 6c 64 46 | 4b 28 22 20 6f 72 22 2c | %ChildF|K(" or",|
|00000f50| 75 70 64 61 74 65 29 0d | 0a 20 20 62 65 67 69 6e |update).|.  begin|
|00000f60| 0d 0a 20 20 20 20 73 65 | 6c 65 63 74 20 40 6e 75 |..    se|lect @nu|
|00000f70| 6c 6c 63 6e 74 20 3d 20 | 30 0d 0a 20 20 20 20 73 |llcnt = |0..    s|
|00000f80| 65 6c 65 63 74 20 40 76 | 61 6c 69 64 63 6e 74 20 |elect @v|alidcnt |
|00000f90| 3d 20 63 6f 75 6e 74 28 | 2a 29 0d 0a 20 20 20 20 |= count(|*)..    |
|00000fa0| 20 20 66 72 6f 6d 20 69 | 6e 73 65 72 74 65 64 2c |  from i|nserted,|
|00000fb0| 25 50 61 72 65 6e 74 0d | 0a 20 20 20 20 20 20 20 |%Parent.|.       |
|00000fc0| 20 77 68 65 72 65 0d 0a | 20 20 20 20 20 20 20 20 | where..|        |
|00000fd0| 20 20 2f 2a 20 25 25 4a | 6f 69 6e 46 4b 50 4b 28 |  /* %%J|oinFKPK(|
|00000fe0| 69 6e 73 65 72 74 65 64 | 2c 25 50 61 72 65 6e 74 |inserted|,%Parent|
|00000ff0| 29 20 2a 2f 0d 0a 20 20 | 20 20 20 20 20 20 20 20 |) */..  |        |
|00001000| 25 4a 6f 69 6e 46 4b 50 | 4b 28 69 6e 73 65 72 74 |%JoinFKP|K(insert|
|00001010| 65 64 2c 25 50 61 72 65 | 6e 74 29 0d 0a 20 20 20 |ed,%Pare|nt)..   |
|00001020| 20 2f 2a 20 25 25 4e 6f | 74 6e 75 6c 6c 46 4b 28 | /* %%No|tnullFK(|
|00001030| 69 6e 73 65 72 74 65 64 | 2c 22 20 69 73 20 6e 75 |inserted|," is nu|
|00001040| 6c 6c 22 2c 22 73 65 6c | 65 63 74 20 40 6e 75 6c |ll","sel|ect @nul|
|00001050| 6c 63 6e 74 20 3d 20 63 | 6f 75 6e 74 28 2a 29 20 |lcnt = c|ount(*) |
|00001060| 66 72 6f 6d 20 69 6e 73 | 65 72 74 65 64 20 77 68 |from ins|erted wh|
|00001070| 65 72 65 22 2c 22 20 61 | 6e 64 22 29 20 2a 2f 0d |ere"," a|nd") */.|
|00001080| 0a 20 20 20 20 25 4e 6f | 74 6e 75 6c 6c 46 4b 28 |.    %No|tnullFK(|
|00001090| 69 6e 73 65 72 74 65 64 | 2c 22 20 69 73 20 6e 75 |inserted|," is nu|
|000010a0| 6c 6c 22 2c 22 73 65 6c | 65 63 74 20 40 6e 75 6c |ll","sel|ect @nul|
|000010b0| 6c 63 6e 74 20 3d 20 63 | 6f 75 6e 74 28 2a 29 20 |lcnt = c|ount(*) |
|000010c0| 66 72 6f 6d 20 69 6e 73 | 65 72 74 65 64 20 77 68 |from ins|erted wh|
|000010d0| 65 72 65 22 2c 22 20 61 | 6e 64 22 29 0d 0a 20 20 |ere"," a|nd")..  |
|000010e0| 20 20 69 66 20 40 76 61 | 6c 69 64 63 6e 74 20 2b |  if @va|lidcnt +|
|000010f0| 20 40 6e 75 6c 6c 63 6e | 74 20 21 3d 20 40 6e 75 | @nullcn|t != @nu|
|00001100| 6d 72 6f 77 73 0d 0a 20 | 20 20 20 62 65 67 69 6e |mrows.. |   begin|
|00001110| 0d 0a 20 20 20 20 20 20 | 73 65 6c 65 63 74 20 40 |..      |select @|
|00001120| 65 72 72 6e 6f 20 20 3d | 20 33 30 30 30 32 2c 0d |errno  =| 30002,.|
|00001130| 0a 20 20 20 20 20 20 20 | 20 20 20 20 20 20 40 65 |.       |      @e|
|00001140| 72 72 6d 73 67 20 3d 20 | 27 43 61 6e 6e 6f 74 20 |rrmsg = |'Cannot |
|00001150| 49 4e 53 45 52 54 20 22 | 25 43 68 69 6c 64 22 20 |INSERT "|%Child" |
|00001160| 62 65 63 61 75 73 65 20 | 22 25 50 61 72 65 6e 74 |because |"%Parent|
|00001170| 22 20 64 6f 65 73 20 6e | 6f 74 20 65 78 69 73 74 |" does n|ot exist|
|00001180| 2e 27 0d 0a 20 20 20 20 | 20 20 67 6f 74 6f 20 65 |.'..    |  goto e|
|00001190| 72 72 6f 72 0d 0a 20 20 | 20 20 65 6e 64 0d 0a 20 |rror..  |  end.. |
|000011a0| 20 65 6e 64 0d 0a 18 27 | 00 00 00 00 00 00 00 00 | end...'|........|
|000011b0| 00 00 05 00 00 00 14 00 | 43 48 49 4c 44 20 49 4e |........|CHILD IN|
|000011c0| 53 45 52 54 20 43 41 53 | 43 41 44 45 48 02 20 20 |SERT CAS|CADEH.  |
|000011d0| 2f 2a 20 45 52 77 69 6e | 20 42 75 69 6c 74 69 6e |/* ERwin| Builtin|
|000011e0| 20 25 44 61 74 65 74 69 | 6d 65 20 2a 2f 0d 0a 20 | %Dateti|me */.. |
|000011f0| 20 2f 2a 20 25 50 61 72 | 65 6e 74 20 25 56 65 72 | /* %Par|ent %Ver|
|00001200| 62 50 68 72 61 73 65 20 | 25 43 68 69 6c 64 20 4f |bPhrase |%Child O|
|00001210| 4e 20 43 48 49 4c 44 20 | 49 4e 53 45 52 54 20 43 |N CHILD |INSERT C|
|00001220| 41 53 43 41 44 45 20 2a | 2f 0d 0a 20 20 69 66 0d |ASCADE *|/..  if.|
|00001230| 0a 20 20 20 20 2f 2a 20 | 25 25 43 68 69 6c 64 46 |.    /* |%%ChildF|
|00001240| 4b 28 22 20 6f 72 22 2c | 75 70 64 61 74 65 29 20 |K(" or",|update) |
|00001250| 2a 2f 0d 0a 20 20 20 20 | 25 43 68 69 6c 64 46 4b |*/..    |%ChildFK|
|00001260| 28 22 20 6f 72 22 2c 75 | 70 64 61 74 65 29 0d 0a |(" or",u|pdate)..|
|00001270| 20 20 62 65 67 69 6e 0d | 0a 20 20 20 20 69 6e 73 |  begin.|.    ins|
|00001280| 65 72 74 20 25 50 61 72 | 65 6e 74 20 28 25 50 61 |ert %Par|ent (%Pa|
|00001290| 72 65 6e 74 50 4b 28 22 | 2c 22 2c 29 29 0d 0a 20 |rentPK("|,",)).. |
|000012a0| 20 20 20 20 20 73 65 6c | 65 63 74 20 25 43 68 69 |     sel|ect %Chi|
|000012b0| 6c 64 46 4b 28 22 2c 22 | 2c 29 0d 0a 20 20 20 20 |ldFK(","|,)..    |
|000012c0| 20 20 66 72 6f 6d 20 20 | 20 69 6e 73 65 72 74 65 |  from  | inserte|
|000012d0| 64 0d 0a 20 20 20 20 20 | 20 77 68 65 72 65 0d 0a |d..     | where..|
|000012e0| 20 20 20 20 20 20 20 20 | 2f 2a 20 25 25 4e 6f 74 |        |/* %%Not|
|000012f0| 6e 75 6c 6c 46 4b 28 69 | 6e 73 65 72 74 65 64 2c |nullFK(i|nserted,|
|00001300| 22 20 69 73 20 6e 6f 74 | 20 6e 75 6c 6c 20 61 6e |" is not| null an|
|00001310| 64 22 29 20 2a 2f 0d 0a | 20 20 20 20 20 20 20 20 |d") */..|        |
|00001320| 25 4e 6f 74 6e 75 6c 6c | 46 4b 28 69 6e 73 65 72 |%Notnull|FK(inser|
|00001330| 74 65 64 2c 22 20 69 73 | 20 6e 6f 74 20 6e 75 6c |ted," is| not nul|
|00001340| 6c 20 61 6e 64 22 29 0d | 0a 20 20 20 20 20 20 20 |l and").|.       |
|00001350| 20 6e 6f 74 20 65 78 69 | 73 74 73 20 28 0d 0a 20 | not exi|sts (.. |
|00001360| 20 20 20 20 20 20 20 20 | 20 73 65 6c 65 63 74 20 |        | select |
|00001370| 2a 20 66 72 6f 6d 20 25 | 50 61 72 65 6e 74 0d 0a |* from %|Parent..|
|00001380| 20 20 20 20 20 20 20 20 | 20 20 77 68 65 72 65 0d |        |  where.|
|00001390| 0a 20 20 20 20 20 20 20 | 20 20 20 20 20 2f 2a 20 |.       |     /* |
|000013a0| 25 25 4a 6f 69 6e 46 4b | 50 4b 28 69 6e 73 65 72 |%%JoinFK|PK(inser|
|000013b0| 74 65 64 2c 25 50 61 72 | 65 6e 74 2c 22 20 3d 20 |ted,%Par|ent," = |
|000013c0| 22 2c 22 20 61 6e 64 22 | 29 20 2a 2f 0d 0a 20 20 |"," and"|) */..  |
|000013d0| 20 20 20 20 20 20 20 20 | 20 20 25 4a 6f 69 6e 46 |        |  %JoinF|
|000013e0| 4b 50 4b 28 69 6e 73 65 | 72 74 65 64 2c 25 50 61 |KPK(inse|rted,%Pa|
|000013f0| 72 65 6e 74 2c 22 20 3d | 20 22 2c 22 20 61 6e 64 |rent," =| "," and|
|00001400| 22 29 0d 0a 20 20 20 20 | 20 20 20 20 29 0d 0a 20 |")..    |    ).. |
|00001410| 20 65 6e 64 0d 0a 19 27 | 00 00 00 00 00 00 00 00 | end...'|........|
|00001420| 00 00 05 00 00 00 14 00 | 43 48 49 4c 44 20 49 4e |........|CHILD IN|
|00001430| 53 45 52 54 20 53 45 54 | 4e 55 4c 4c 6e 02 20 20 |SERT SET|NULLn.  |
|00001440| 2f 2a 20 45 52 77 69 6e | 20 42 75 69 6c 74 69 6e |/* ERwin| Builtin|
|00001450| 20 25 44 61 74 65 74 69 | 6d 65 20 2a 2f 0d 0a 20 | %Dateti|me */.. |
|00001460| 20 2f 2a 20 25 50 61 72 | 65 6e 74 20 25 56 65 72 | /* %Par|ent %Ver|
|00001470| 62 50 68 72 61 73 65 20 | 25 43 68 69 6c 64 20 4f |bPhrase |%Child O|
|00001480| 4e 20 43 48 49 4c 44 20 | 49 4e 53 45 52 54 20 53 |N CHILD |INSERT S|
|00001490| 45 54 20 4e 55 4c 4c 20 | 2a 2f 0d 0a 20 20 69 66 |ET NULL |*/..  if|
|000014a0| 0d 0a 20 20 20 20 2f 2a | 20 25 25 43 68 69 6c 64 |..    /*| %%Child|
|000014b0| 46 4b 28 22 20 6f 72 22 | 2c 75 70 64 61 74 65 29 |FK(" or"|,update)|
|000014c0| 20 2a 2f 0d 0a 20 20 20 | 20 25 43 68 69 6c 64 46 | */..   | %ChildF|
|000014d0| 4b 28 22 20 6f 72 22 2c | 75 70 64 61 74 65 29 0d |K(" or",|update).|
|000014e0| 0a 20 20 62 65 67 69 6e | 0d 0a 20 20 20 20 75 70 |.  begin|..    up|
|000014f0| 64 61 74 65 20 25 43 68 | 69 6c 64 0d 0a 20 20 20 |date %Ch|ild..   |
|00001500| 20 20 20 73 65 74 0d 0a | 20 20 20 20 20 20 20 20 |   set..|        |
|00001510| 2f 2a 20 25 25 53 65 74 | 46 4b 28 25 43 68 69 6c |/* %%Set|FK(%Chil|
|00001520| 64 2c 4e 55 4c 4c 29 20 | 2a 2f 0d 0a 20 20 20 20 |d,NULL) |*/..    |
|00001530| 20 20 20 20 25 53 65 74 | 46 4b 28 25 43 68 69 6c |    %Set|FK(%Chil|
|00001540| 64 2c 4e 55 4c 4c 29 0d | 0a 20 20 20 20 20 20 66 |d,NULL).|.      f|
|00001550| 72 6f 6d 20 25 43 68 69 | 6c 64 2c 69 6e 73 65 72 |rom %Chi|ld,inser|
|00001560| 74 65 64 0d 0a 20 20 20 | 20 20 20 77 68 65 72 65 |ted..   |   where|
|00001570| 0d 0a 20 20 20 20 20 20 | 20 20 2f 2a 20 25 25 4a |..      |  /* %%J|
|00001580| 6f 69 6e 50 4b 50 4b 28 | 25 43 68 69 6c 64 2c 69 |oinPKPK(|%Child,i|
|00001590| 6e 73 65 72 74 65 64 2c | 22 20 3d 20 22 2c 22 20 |nserted,|" = "," |
|000015a0| 61 6e 64 22 29 20 2a 2f | 0d 0a 20 20 20 20 20 20 |and") */|..      |
|000015b0| 20 20 25 4a 6f 69 6e 50 | 4b 50 4b 28 25 43 68 69 |  %JoinP|KPK(%Chi|
|000015c0| 6c 64 2c 69 6e 73 65 72 | 74 65 64 2c 22 20 3d 20 |ld,inser|ted," = |
|000015d0| 22 2c 22 20 61 6e 64 22 | 29 20 61 6e 64 0d 0a 20 |"," and"|) and.. |
|000015e0| 20 20 20 20 20 20 20 6e | 6f 74 20 65 78 69 73 74 |       n|ot exist|
|000015f0| 73 20 28 0d 0a 20 20 20 | 20 20 20 20 20 20 20 73 |s (..   |       s|
|00001600| 65 6c 65 63 74 20 2a 20 | 66 72 6f 6d 20 25 50 61 |elect * |from %Pa|
|00001610| 72 65 6e 74 0d 0a 20 20 | 20 20 20 20 20 20 20 20 |rent..  |        |
|00001620| 77 68 65 72 65 0d 0a 20 | 20 20 20 20 20 20 20 20 |where.. |        |
|00001630| 20 20 20 2f 2a 20 25 25 | 4a 6f 69 6e 46 4b 50 4b |   /* %%|JoinFKPK|
|00001640| 28 69 6e 73 65 72 74 65 | 64 2c 25 50 61 72 65 6e |(inserte|d,%Paren|
|00001650| 74 2c 22 20 3d 20 22 2c | 22 20 61 6e 64 22 29 20 |t," = ",|" and") |
|00001660| 2a 2f 0d 0a 20 20 20 20 | 20 20 20 20 20 20 20 20 |*/..    |        |
|00001670| 25 4a 6f 69 6e 46 4b 50 | 4b 28 69 6e 73 65 72 74 |%JoinFKP|K(insert|
|00001680| 65 64 2c 25 50 61 72 65 | 6e 74 2c 22 20 3d 20 22 |ed,%Pare|nt," = "|
|00001690| 2c 22 20 61 6e 64 22 29 | 0d 0a 20 20 20 20 20 20 |," and")|..      |
|000016a0| 20 20 29 0d 0a 20 20 65 | 6e 64 0d 0a 1a 27 00 00 |  )..  e|nd...'..|
|000016b0| 00 00 00 00 00 00 00 00 | 05 00 00 00 15 00 43 48 |........|......CH|
|000016c0| 49 4c 44 20 55 50 44 41 | 54 45 20 52 45 53 54 52 |ILD UPDA|TE RESTR|
|000016d0| 49 43 54 f0 02 20 20 2f | 2a 20 45 52 77 69 6e 20 |ICT..  /|* ERwin |
|000016e0| 42 75 69 6c 74 69 6e 20 | 25 44 61 74 65 74 69 6d |Builtin |%Datetim|
|000016f0| 65 20 2a 2f 0d 0a 20 20 | 2f 2a 20 25 50 61 72 65 |e */..  |/* %Pare|
|00001700| 6e 74 20 25 56 65 72 62 | 50 68 72 61 73 65 20 25 |nt %Verb|Phrase %|
|00001710| 43 68 69 6c 64 20 4f 4e | 20 43 48 49 4c 44 20 55 |Child ON| CHILD U|
|00001720| 50 44 41 54 45 20 52 45 | 53 54 52 49 43 54 20 2a |PDATE RE|STRICT *|
|00001730| 2f 0d 0a 20 20 69 66 0d | 0a 20 20 20 20 2f 2a 20 |/..  if.|.    /* |
|00001740| 25 25 43 68 69 6c 64 46 | 4b 28 22 20 6f 72 22 2c |%%ChildF|K(" or",|
|00001750| 75 70 64 61 74 65 29 20 | 2a 2f 0d 0a 20 20 20 20 |update) |*/..    |
|00001760| 25 43 68 69 6c 64 46 4b | 28 22 20 6f 72 22 2c 75 |%ChildFK|(" or",u|
|00001770| 70 64 61 74 65 29 0d 0a | 20 20 62 65 67 69 6e 0d |pdate)..|  begin.|
|00001780| 0a 20 20 20 20 73 65 6c | 65 63 74 20 40 6e 75 6c |.    sel|ect @nul|
|00001790| 6c 63 6e 74 20 3d 20 30 | 0d 0a 20 20 20 20 73 65 |lcnt = 0|..    se|
|000017a0| 6c 65 63 74 20 40 76 61 | 6c 69 64 63 6e 74 20 3d |lect @va|lidcnt =|
|000017b0| 20 63 6f 75 6e 74 28 2a | 29 0d 0a 20 20 20 20 20 | count(*|)..     |
|000017c0| 20 66 72 6f 6d 20 69 6e | 73 65 72 74 65 64 2c 25 | from in|serted,%|
|000017d0| 50 61 72 65 6e 74 0d 0a | 20 20 20 20 20 20 20 20 |Parent..|        |
|000017e0| 77 68 65 72 65 0d 0a 20 | 20 20 20 20 20 20 20 20 |where.. |        |
|000017f0| 20 2f 2a 20 25 25 4a 6f | 69 6e 46 4b 50 4b 28 69 | /* %%Jo|inFKPK(i|
|00001800| 6e 73 65 72 74 65 64 2c | 25 50 61 72 65 6e 74 29 |nserted,|%Parent)|
|00001810| 20 2a 2f 0d 0a 20 20 20 | 20 20 20 20 20 20 20 25 | */..   |       %|
|00001820| 4a 6f 69 6e 46 4b 50 4b | 28 69 6e 73 65 72 74 65 |JoinFKPK|(inserte|
|00001830| 64 2c 25 50 61 72 65 6e | 74 29 0d 0a 20 20 20 20 |d,%Paren|t)..    |
|00001840| 2f 2a 20 25 25 4e 6f 74 | 6e 75 6c 6c 46 4b 28 69 |/* %%Not|nullFK(i|
|00001850| 6e 73 65 72 74 65 64 2c | 22 20 69 73 20 6e 75 6c |nserted,|" is nul|
|00001860| 6c 22 2c 22 73 65 6c 65 | 63 74 20 40 6e 75 6c 6c |l","sele|ct @null|
|00001870| 63 6e 74 20 3d 20 63 6f | 75 6e 74 28 2a 29 20 66 |cnt = co|unt(*) f|
|00001880| 72 6f 6d 20 69 6e 73 65 | 72 74 65 64 20 77 68 65 |rom inse|rted whe|
|00001890| 72 65 22 2c 22 20 61 6e | 64 22 29 20 2a 2f 0d 0a |re"," an|d") */..|
|000018a0| 20 20 20 20 25 4e 6f 74 | 6e 75 6c 6c 46 4b 28 69 |    %Not|nullFK(i|
|000018b0| 6e 73 65 72 74 65 64 2c | 22 20 69 73 20 6e 75 6c |nserted,|" is nul|
|000018c0| 6c 22 2c 22 73 65 6c 65 | 63 74 20 40 6e 75 6c 6c |l","sele|ct @null|
|000018d0| 63 6e 74 20 3d 20 63 6f | 75 6e 74 28 2a 29 20 66 |cnt = co|unt(*) f|
|000018e0| 72 6f 6d 20 69 6e 73 65 | 72 74 65 64 20 77 68 65 |rom inse|rted whe|
|000018f0| 72 65 22 2c 22 20 61 6e | 64 22 29 0d 0a 20 20 20 |re"," an|d")..   |
|00001900| 20 69 66 20 40 76 61 6c | 69 64 63 6e 74 20 2b 20 | if @val|idcnt + |
|00001910| 40 6e 75 6c 6c 63 6e 74 | 20 21 3d 20 40 6e 75 6d |@nullcnt| != @num|
|00001920| 72 6f 77 73 0d 0a 20 20 | 20 20 62 65 67 69 6e 0d |rows..  |  begin.|
|00001930| 0a 20 20 20 20 20 20 73 | 65 6c 65 63 74 20 40 65 |.      s|elect @e|
|00001940| 72 72 6e 6f 20 20 3d 20 | 33 30 30 30 37 2c 0d 0a |rrno  = |30007,..|
|00001950| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 40 65 72 |        |     @er|
|00001960| 72 6d 73 67 20 3d 20 27 | 43 61 6e 6e 6f 74 20 55 |rmsg = '|Cannot U|
|00001970| 50 44 41 54 45 20 22 25 | 43 68 69 6c 64 22 20 62 |PDATE "%|Child" b|
|00001980| 65 63 61 75 73 65 20 22 | 25 50 61 72 65 6e 74 22 |ecause "|%Parent"|
|00001990| 20 64 6f 65 73 20 6e 6f | 74 20 65 78 69 73 74 2e | does no|t exist.|
|000019a0| 27 0d 0a 20 20 20 20 20 | 20 67 6f 74 6f 20 65 72 |'..     | goto er|
|000019b0| 72 6f 72 0d 0a 20 20 20 | 20 65 6e 64 0d 0a 20 20 |ror..   | end..  |
|000019c0| 65 6e 64 0d 0a 1c 27 00 | 00 00 00 00 00 00 00 00 |end...'.|........|
|000019d0| 00 05 00 00 00 14 00 43 | 48 49 4c 44 20 55 50 44 |.......C|HILD UPD|
|000019e0| 41 54 45 20 43 41 53 43 | 41 44 45 48 02 20 20 2f |ATE CASC|ADEH.  /|
|000019f0| 2a 20 45 52 77 69 6e 20 | 42 75 69 6c 74 69 6e 20 |* ERwin |Builtin |
|00001a00| 25 44 61 74 65 74 69 6d | 65 20 2a 2f 0d 0a 20 20 |%Datetim|e */..  |
|00001a10| 2f 2a 20 25 50 61 72 65 | 6e 74 20 25 56 65 72 62 |/* %Pare|nt %Verb|
|00001a20| 50 68 72 61 73 65 20 25 | 43 68 69 6c 64 20 4f 4e |Phrase %|Child ON|
|00001a30| 20 43 48 49 4c 44 20 55 | 50 44 41 54 45 20 43 41 | CHILD U|PDATE CA|
|00001a40| 53 43 41 44 45 20 2a 2f | 0d 0a 20 20 69 66 0d 0a |SCADE */|..  if..|
|00001a50| 20 20 20 20 2f 2a 20 25 | 25 43 68 69 6c 64 46 4b |    /* %|%ChildFK|
|00001a60| 28 22 20 6f 72 22 2c 75 | 70 64 61 74 65 29 20 2a |(" or",u|pdate) *|
|00001a70| 2f 0d 0a 20 20 20 20 25 | 43 68 69 6c 64 46 4b 28 |/..    %|ChildFK(|
|00001a80| 22 20 6f 72 22 2c 75 70 | 64 61 74 65 29 0d 0a 20 |" or",up|date).. |
|00001a90| 20 62 65 67 69 6e 0d 0a | 20 20 20 20 69 6e 73 65 | begin..|    inse|
|00001aa0| 72 74 20 25 50 61 72 65 | 6e 74 20 28 25 50 61 72 |rt %Pare|nt (%Par|
|00001ab0| 65 6e 74 50 4b 28 22 2c | 22 2c 29 29 0d 0a 20 20 |entPK(",|",))..  |
|00001ac0| 20 20 20 20 73 65 6c 65 | 63 74 20 25 43 68 69 6c |    sele|ct %Chil|
|00001ad0| 64 46 4b 28 22 2c 22 2c | 29 0d 0a 20 20 20 20 20 |dFK(",",|)..     |
|00001ae0| 20 66 72 6f 6d 20 20 20 | 69 6e 73 65 72 74 65 64 | from   |inserted|
|00001af0| 0d 0a 20 20 20 20 20 20 | 77 68 65 72 65 0d 0a 20 |..      |where.. |
|00001b00| 20 20 20 20 20 20 20 2f | 2a 20 25 25 4e 6f 74 6e |       /|* %%Notn|
|00001b10| 75 6c 6c 46 4b 28 69 6e | 73 65 72 74 65 64 2c 22 |ullFK(in|serted,"|
|00001b20| 20 69 73 20 6e 6f 74 20 | 6e 75 6c 6c 20 61 6e 64 | is not |null and|
|00001b30| 22 29 20 2a 2f 0d 0a 20 | 20 20 20 20 20 20 20 25 |") */.. |       %|
|00001b40| 4e 6f 74 6e 75 6c 6c 46 | 4b 28 69 6e 73 65 72 74 |NotnullF|K(insert|
|00001b50| 65 64 2c 22 20 69 73 20 | 6e 6f 74 20 6e 75 6c 6c |ed," is |not null|
|00001b60| 20 61 6e 64 22 29 0d 0a | 20 20 20 20 20 20 20 20 | and")..|        |
|00001b70| 6e 6f 74 20 65 78 69 73 | 74 73 20 28 0d 0a 20 20 |not exis|ts (..  |
|00001b80| 20 20 20 20 20 20 20 20 | 73 65 6c 65 63 74 20 2a |        |select *|
|00001b90| 20 66 72 6f 6d 20 25 50 | 61 72 65 6e 74 0d 0a 20 | from %P|arent.. |
|00001ba0| 20 20 20 20 20 20 20 20 | 20 77 68 65 72 65 0d 0a |        | where..|
|00001bb0| 20 20 20 20 20 20 20 20 | 20 20 20 20 2f 2a 20 25 |        |    /* %|
|00001bc0| 25 4a 6f 69 6e 46 4b 50 | 4b 28 69 6e 73 65 72 74 |%JoinFKP|K(insert|
|00001bd0| 65 64 2c 25 50 61 72 65 | 6e 74 2c 22 20 3d 20 22 |ed,%Pare|nt," = "|
|00001be0| 2c 22 20 61 6e 64 22 29 | 20 2a 2f 0d 0a 20 20 20 |," and")| */..   |
|00001bf0| 20 20 20 20 20 20 20 20 | 20 25 4a 6f 69 6e 46 4b |        | %JoinFK|
|00001c00| 50 4b 28 69 6e 73 65 72 | 74 65 64 2c 25 50 61 72 |PK(inser|ted,%Par|
|00001c10| 65 6e 74 2c 22 20 3d 20 | 22 2c 22 20 61 6e 64 22 |ent," = |"," and"|
|00001c20| 29 0d 0a 20 20 20 20 20 | 20 20 20 29 0d 0a 20 20 |)..     |   )..  |
|00001c30| 65 6e 64 0d 0a 1d 27 00 | 00 00 00 00 00 00 00 00 |end...'.|........|
|00001c40| 00 05 00 00 00 14 00 43 | 48 49 4c 44 20 55 50 44 |.......C|HILD UPD|
|00001c50| 41 54 45 20 53 45 54 4e | 55 4c 4c 6f 02 20 20 2f |ATE SETN|ULLo.  /|
|00001c60| 2a 20 45 52 77 69 6e 20 | 42 75 69 6c 74 69 6e 20 |* ERwin |Builtin |
|00001c70| 25 44 61 74 65 74 69 6d | 65 20 2a 2f 0d 0a 20 20 |%Datetim|e */..  |
|00001c80| 2f 2a 20 25 50 61 72 65 | 6e 74 20 25 56 65 72 62 |/* %Pare|nt %Verb|
|00001c90| 50 68 72 61 73 65 20 25 | 43 68 69 6c 64 20 4f 4e |Phrase %|Child ON|
|00001ca0| 20 43 48 49 4c 44 20 55 | 50 44 41 54 45 20 53 45 | CHILD U|PDATE SE|
|00001cb0| 54 20 4e 55 4c 4c 20 2a | 2f 0d 0a 20 20 69 66 0d |T NULL *|/..  if.|
|00001cc0| 0a 20 20 20 20 2f 2a 20 | 25 25 43 68 69 6c 64 46 |.    /* |%%ChildF|
|00001cd0| 4b 28 22 20 6f 72 22 2c | 75 70 64 61 74 65 29 20 |K(" or",|update) |
|00001ce0| 2a 2f 0d 0a 20 20 20 20 | 25 43 68 69 6c 64 46 4b |*/..    |%ChildFK|
|00001cf0| 28 22 20 6f 72 22 2c 75 | 70 64 61 74 65 29 0d 0a |(" or",u|pdate)..|
|00001d00| 20 20 62 65 67 69 6e 0d | 0a 20 20 20 20 75 70 64 |  begin.|.    upd|
|00001d10| 61 74 65 20 25 43 68 69 | 6c 64 0d 0a 20 20 20 20 |ate %Chi|ld..    |
|00001d20| 20 20 73 65 74 0d 0a 20 | 20 20 20 20 20 20 20 2f |  set.. |       /|
|00001d30| 2a 20 25 25 53 65 74 46 | 4b 28 25 43 68 69 6c 64 |* %%SetF|K(%Child|
|00001d40| 2c 4e 55 4c 4c 29 20 2a | 2f 0d 0a 20 20 20 20 20 |,NULL) *|/..     |
|00001d50| 20 20 20 25 53 65 74 46 | 4b 28 25 43 68 69 6c 64 |   %SetF|K(%Child|
|00001d60| 2c 4e 55 4c 4c 29 0d 0a | 20 20 20 20 20 20 66 72 |,NULL)..|      fr|
|00001d70| 6f 6d 20 25 43 68 69 6c | 64 2c 69 6e 73 65 72 74 |om %Chil|d,insert|
|00001d80| 65 64 0d 0a 20 20 20 20 | 20 20 77 68 65 72 65 0d |ed..    |  where.|
|00001d90| 0a 20 20 20 20 20 20 20 | 20 2f 2a 20 25 25 4a 6f |.       | /* %%Jo|
|00001da0| 69 6e 50 4b 50 4b 28 25 | 43 68 69 6c 64 2c 69 6e |inPKPK(%|Child,in|
|00001db0| 73 65 72 74 65 64 2c 22 | 20 3d 20 22 2c 22 20 61 |serted,"| = "," a|
|00001dc0| 6e 64 22 29 20 2a 2f 0d | 0a 20 20 20 20 20 20 20 |nd") */.|.       |
|00001dd0| 20 25 4a 6f 69 6e 50 4b | 50 4b 28 25 43 68 69 6c | %JoinPK|PK(%Chil|
|00001de0| 64 2c 69 6e 73 65 72 74 | 65 64 2c 22 20 3d 20 22 |d,insert|ed," = "|
|00001df0| 2c 22 20 61 6e 64 22 29 | 20 61 6e 64 20 0d 0a 20 |," and")| and .. |
|00001e00| 20 20 20 20 20 20 20 6e | 6f 74 20 65 78 69 73 74 |       n|ot exist|
|00001e10| 73 20 28 0d 0a 20 20 20 | 20 20 20 20 20 20 20 73 |s (..   |       s|
|00001e20| 65 6c 65 63 74 20 2a 20 | 66 72 6f 6d 20 25 50 61 |elect * |from %Pa|
|00001e30| 72 65 6e 74 0d 0a 20 20 | 20 20 20 20 20 20 20 20 |rent..  |        |
|00001e40| 77 68 65 72 65 0d 0a 20 | 20 20 20 20 20 20 20 20 |where.. |        |
|00001e50| 20 20 20 2f 2a 20 25 25 | 4a 6f 69 6e 46 4b 50 4b |   /* %%|JoinFKPK|
|00001e60| 28 69 6e 73 65 72 74 65 | 64 2c 25 50 61 72 65 6e |(inserte|d,%Paren|
|00001e70| 74 2c 22 20 3d 20 22 2c | 22 20 61 6e 64 22 29 20 |t," = ",|" and") |
|00001e80| 2a 2f 0d 0a 20 20 20 20 | 20 20 20 20 20 20 20 20 |*/..    |        |
|00001e90| 25 4a 6f 69 6e 46 4b 50 | 4b 28 69 6e 73 65 72 74 |%JoinFKP|K(insert|
|00001ea0| 65 64 2c 25 50 61 72 65 | 6e 74 2c 22 20 3d 20 22 |ed,%Pare|nt," = "|
|00001eb0| 2c 22 20 61 6e 64 22 29 | 0d 0a 20 20 20 20 20 20 |," and")|..      |
|00001ec0| 20 20 29 0d 0a 20 20 65 | 6e 64 0d 0a 1e 27 00 00 |  )..  e|nd...'..|
|00001ed0| 00 00 00 00 00 00 00 00 | 05 00 00 00 15 00 43 48 |........|......CH|
|00001ee0| 49 4c 44 20 44 45 4c 45 | 54 45 20 52 45 53 54 52 |ILD DELE|TE RESTR|
|00001ef0| 49 43 54 67 02 20 20 20 | 20 2f 2a 20 45 52 77 69 |ICTg.   | /* ERwi|
|00001f00| 6e 20 42 75 69 6c 74 69 | 6e 20 25 44 61 74 65 74 |n Builti|n %Datet|
|00001f10| 69 6d 65 20 2a 2f 0d 0a | 20 20 20 20 2f 2a 20 25 |ime */..|    /* %|
|00001f20| 50 61 72 65 6e 74 20 25 | 56 65 72 62 50 68 72 61 |Parent %|VerbPhra|
|00001f30| 73 65 20 25 43 68 69 6c | 64 20 4f 4e 20 43 48 49 |se %Chil|d ON CHI|
|00001f40| 4c 44 20 44 45 4c 45 54 | 45 20 52 45 53 54 52 49 |LD DELET|E RESTRI|
|00001f50| 43 54 20 2a 2f 0d 0a 20 | 20 20 20 69 66 20 65 78 |CT */.. |   if ex|
|00001f60| 69 73 74 73 20 28 73 65 | 6c 65 63 74 20 2a 20 66 |ists (se|lect * f|
|00001f70| 72 6f 6d 20 64 65 6c 65 | 74 65 64 2c 25 50 61 72 |rom dele|ted,%Par|
|00001f80| 65 6e 74 0d 0a 20 20 20 | 20 20 20 77 68 65 72 65 |ent..   |   where|
|00001f90| 0d 0a 20 20 20 20 20 20 | 20 20 2f 2a 20 25 25 4a |..      |  /* %%J|
|00001fa0| 6f 69 6e 46 4b 50 4b 28 | 64 65 6c 65 74 65 64 2c |oinFKPK(|deleted,|
|00001fb0| 25 50 61 72 65 6e 74 2c | 22 20 3d 20 22 2c 22 20 |%Parent,|" = "," |
|00001fc0| 61 6e 64 22 29 20 2a 2f | 0d 0a 20 20 20 20 20 20 |and") */|..      |
|00001fd0| 20 20 25 4a 6f 69 6e 46 | 4b 50 4b 28 64 65 6c 65 |  %JoinF|KPK(dele|
|00001fe0| 74 65 64 2c 25 50 61 72 | 65 6e 74 2c 22 20 3d 20 |ted,%Par|ent," = |
|00001ff0| 22 2c 22 20 61 6e 64 22 | 29 20 61 6e 64 0d 0a 20 |"," and"|) and.. |
|00002000| 20 20 20 20 20 20 20 6e | 6f 74 20 65 78 69 73 74 |       n|ot exist|
|00002010| 73 20 28 0d 0a 20 20 20 | 20 20 20 20 20 20 20 73 |s (..   |       s|
|00002020| 65 6c 65 63 74 20 2a 20 | 66 72 6f 6d 20 25 43 68 |elect * |from %Ch|
|00002030| 69 6c 64 0d 0a 20 20 20 | 20 20 20 20 20 20 20 77 |ild..   |       w|
|00002040| 68 65 72 65 0d 0a 20 20 | 20 20 20 20 20 20 20 20 |here..  |        |
|00002050| 20 20 2f 2a 20 25 25 4a | 6f 69 6e 46 4b 50 4b 28 |  /* %%J|oinFKPK(|
|00002060| 25 43 68 69 6c 64 2c 25 | 50 61 72 65 6e 74 2c 22 |%Child,%|Parent,"|
|00002070| 20 3d 20 22 2c 22 20 61 | 6e 64 22 29 20 2a 2f 0d | = "," a|nd") */.|
|00002080| 0a 20 20 20 20 20 20 20 | 20 20 20 20 20 25 4a 6f |.       |     %Jo|
|00002090| 69 6e 46 4b 50 4b 28 25 | 43 68 69 6c 64 2c 25 50 |inFKPK(%|Child,%P|
|000020a0| 61 72 65 6e 74 2c 22 20 | 3d 20 22 2c 22 20 61 6e |arent," |= "," an|
|000020b0| 64 22 29 0d 0a 20 20 20 | 20 20 20 20 20 29 0d 0a |d")..   |     )..|
|000020c0| 20 20 20 20 29 0d 0a 20 | 20 20 20 62 65 67 69 6e |    ).. |   begin|
|000020d0| 0d 0a 20 20 20 20 20 20 | 73 65 6c 65 63 74 20 40 |..      |select @|
|000020e0| 65 72 72 6e 6f 20 20 3d | 20 33 30 30 31 30 2c 0d |errno  =| 30010,.|
|000020f0| 0a 20 20 20 20 20 20 20 | 20 20 20 20 20 20 40 65 |.       |      @e|
|00002100| 72 72 6d 73 67 20 3d 20 | 27 43 61 6e 6e 6f 74 20 |rrmsg = |'Cannot |
|00002110| 44 45 4c 45 54 45 20 6c | 61 73 74 20 22 25 43 68 |DELETE l|ast "%Ch|
|00002120| 69 6c 64 22 20 62 65 63 | 61 75 73 65 20 22 25 50 |ild" bec|ause "%P|
|00002130| 61 72 65 6e 74 22 20 65 | 78 69 73 74 73 2e 27 0d |arent" e|xists.'.|
|00002140| 0a 20 20 20 20 20 20 67 | 6f 74 6f 20 65 72 72 6f |.      g|oto erro|
|00002150| 72 0d 0a 20 20 20 20 65 | 6e 64 0d 0a 20 27 00 00 |r..    e|nd.. '..|
|00002160| 00 00 00 00 00 00 00 00 | 05 00 00 00 14 00 43 48 |........|......CH|
|00002170| 49 4c 44 20 44 45 4c 45 | 54 45 20 43 41 53 43 41 |ILD DELE|TE CASCA|
|00002180| 44 45 cc 01 20 20 20 20 | 2f 2a 20 45 52 77 69 6e |DE..    |/* ERwin|
|00002190| 20 42 75 69 6c 74 69 6e | 20 25 44 61 74 65 74 69 | Builtin| %Dateti|
|000021a0| 6d 65 20 2a 2f 0d 0a 20 | 20 20 20 2f 2a 20 25 50 |me */.. |   /* %P|
|000021b0| 61 72 65 6e 74 20 25 56 | 65 72 62 50 68 72 61 73 |arent %V|erbPhras|
|000021c0| 65 20 25 43 68 69 6c 64 | 20 4f 4e 20 43 48 49 4c |e %Child| ON CHIL|
|000021d0| 44 20 44 45 4c 45 54 45 | 20 43 41 53 43 41 44 45 |D DELETE| CASCADE|
|000021e0| 20 2a 2f 0d 0a 20 20 20 | 20 64 65 6c 65 74 65 20 | */..   | delete |
|000021f0| 25 50 61 72 65 6e 74 0d | 0a 20 20 20 20 20 20 66 |%Parent.|.      f|
|00002200| 72 6f 6d 20 25 50 61 72 | 65 6e 74 2c 64 65 6c 65 |rom %Par|ent,dele|
|00002210| 74 65 64 0d 0a 20 20 20 | 20 20 20 77 68 65 72 65 |ted..   |   where|
|00002220| 0d 0a 20 20 20 20 20 20 | 20 20 2f 2a 20 25 25 4a |..      |  /* %%J|
|00002230| 6f 69 6e 46 4b 50 4b 28 | 64 65 6c 65 74 65 64 2c |oinFKPK(|deleted,|
|00002240| 25 50 61 72 65 6e 74 2c | 22 20 3d 20 22 2c 22 20 |%Parent,|" = "," |
|00002250| 61 6e 64 22 29 20 2a 2f | 0d 0a 20 20 20 20 20 20 |and") */|..      |
|00002260| 20 20 25 4a 6f 69 6e 46 | 4b 50 4b 28 64 65 6c 65 |  %JoinF|KPK(dele|
|00002270| 74 65 64 2c 25 50 61 72 | 65 6e 74 2c 22 20 3d 20 |ted,%Par|ent," = |
|00002280| 22 2c 22 20 61 6e 64 22 | 29 20 61 6e 64 0d 0a 20 |"," and"|) and.. |
|00002290| 20 20 20 20 20 20 20 6e | 6f 74 20 65 78 69 73 74 |       n|ot exist|
|000022a0| 73 20 28 0d 0a 20 20 20 | 20 20 20 20 20 20 20 73 |s (..   |       s|
|000022b0| 65 6c 65 63 74 20 2a 20 | 66 72 6f 6d 20 25 43 68 |elect * |from %Ch|
|000022c0| 69 6c 64 0d 0a 20 20 20 | 20 20 20 20 20 20 20 77 |ild..   |       w|
|000022d0| 68 65 72 65 0d 0a 20 20 | 20 20 20 20 20 20 20 20 |here..  |        |
|000022e0| 20 20 2f 2a 20 25 25 4a | 6f 69 6e 46 4b 50 4b 28 |  /* %%J|oinFKPK(|
|000022f0| 25 43 68 69 6c 64 2c 25 | 50 61 72 65 6e 74 2c 22 |%Child,%|Parent,"|
|00002300| 20 3d 20 22 2c 22 20 61 | 6e 64 22 29 20 2a 2f 0d | = "," a|nd") */.|
|00002310| 0a 20 20 20 20 20 20 20 | 20 20 20 20 20 25 4a 6f |.       |     %Jo|
|00002320| 69 6e 46 4b 50 4b 28 25 | 43 68 69 6c 64 2c 25 50 |inFKPK(%|Child,%P|
|00002330| 61 72 65 6e 74 2c 22 20 | 3d 20 22 2c 22 20 61 6e |arent," |= "," an|
|00002340| 64 22 29 0d 0a 20 20 20 | 20 20 20 20 20 29 0d 0a |d")..   |     )..|
|00002350| 21 27 00 00 00 00 00 00 | 00 00 00 00 05 00 00 00 |!'......|........|
|00002360| 16 00 50 41 52 45 4e 54 | 20 49 4e 53 45 52 54 20 |..PARENT| INSERT |
|00002370| 52 45 53 54 52 49 43 54 | e8 01 20 20 20 20 2f 2a |RESTRICT|..    /*|
|00002380| 20 45 52 77 69 6e 20 42 | 75 69 6c 74 69 6e 20 25 | ERwin B|uiltin %|
|00002390| 44 61 74 65 74 69 6d 65 | 20 2a 2f 0d 0a 20 20 20 |Datetime| */..   |
|000023a0| 20 2f 2a 20 25 50 61 72 | 65 6e 74 20 25 56 65 72 | /* %Par|ent %Ver|
|000023b0| 62 50 68 72 61 73 65 20 | 25 43 68 69 6c 64 20 4f |bPhrase |%Child O|
|000023c0| 4e 20 50 41 52 45 4e 54 | 20 49 4e 53 45 52 54 20 |N PARENT| INSERT |
|000023d0| 52 45 53 54 52 49 43 54 | 20 2a 2f 0d 0a 20 20 20 |RESTRICT| */..   |
|000023e0| 20 69 66 20 65 78 69 73 | 74 73 20 28 73 65 6c 65 | if exis|ts (sele|
|000023f0| 63 74 20 2a 20 66 72 6f | 6d 20 69 6e 73 65 72 74 |ct * fro|m insert|
|00002400| 65 64 0d 0a 20 20 20 20 | 20 20 77 68 65 72 65 20 |ed..    |  where |
|00002410| 6e 6f 74 20 65 78 69 73 | 74 73 20 28 0d 0a 20 20 |not exis|ts (..  |
|00002420| 20 20 20 20 20 20 20 20 | 73 65 6c 65 63 74 20 2a |        |select *|
|00002430| 20 66 72 6f 6d 20 25 43 | 68 69 6c 64 0d 0a 20 20 | from %C|hild..  |
|00002440| 20 20 20 20 20 20 20 20 | 77 68 65 72 65 0d 0a 20 |        |where.. |
|00002450| 20 20 20 20 20 20 20 20 | 20 20 20 2f 2a 20 25 25 |        |   /* %%|
|00002460| 4a 6f 69 6e 46 4b 50 4b | 28 25 43 68 69 6c 64 2c |JoinFKPK|(%Child,|
|00002470| 69 6e 73 65 72 74 65 64 | 2c 22 20 3d 20 22 2c 22 |inserted|," = ","|
|00002480| 20 61 6e 64 22 29 20 2a | 2f 0d 0a 20 20 20 20 20 | and") *|/..     |
|00002490| 20 20 20 20 20 20 20 25 | 4a 6f 69 6e 46 4b 50 4b |       %|JoinFKPK|
|000024a0| 28 25 43 68 69 6c 64 2c | 69 6e 73 65 72 74 65 64 |(%Child,|inserted|
|000024b0| 2c 22 20 3d 20 22 2c 22 | 20 61 6e 64 22 29 0d 0a |," = ","| and")..|
|000024c0| 20 20 20 20 20 20 29 0d | 0a 20 20 20 20 29 0d 0a |      ).|.    )..|
|000024d0| 20 20 20 20 62 65 67 69 | 6e 0d 0a 20 20 20 20 20 |    begi|n..     |
|000024e0| 20 73 65 6c 65 63 74 20 | 40 65 72 72 6e 6f 20 20 | select |@errno  |
|000024f0| 3d 20 33 30 30 31 31 2c | 0d 0a 20 20 20 20 20 20 |= 30011,|..      |
|00002500| 20 20 20 20 20 20 20 40 | 65 72 72 6d 73 67 20 3d |       @|errmsg =|
|00002510| 20 27 43 61 6e 6e 6f 74 | 20 49 4e 53 45 52 54 20 | 'Cannot| INSERT |
|00002520| 22 25 50 61 72 65 6e 74 | 22 20 62 65 63 61 75 73 |"%Parent|" becaus|
|00002530| 65 20 22 25 43 68 69 6c | 64 22 20 64 6f 65 73 20 |e "%Chil|d" does |
|00002540| 6e 6f 74 2e 27 0d 0a 20 | 20 20 20 20 20 67 6f 74 |not.'.. |     got|
|00002550| 6f 20 65 72 72 6f 72 0d | 0a 20 20 20 20 65 6e 64 |o error.|.    end|
|00002560| 0d 0a 24 27 00 00 00 00 | 00 00 00 00 00 00 05 00 |..$'....|........|
|00002570| 00 00 0d 00 55 50 44 41 | 54 45 20 48 45 41 44 45 |....UPDA|TE HEADE|
|00002580| 52 aa 01 63 72 65 61 74 | 65 20 74 72 69 67 67 65 |R..creat|e trigge|
|00002590| 72 20 74 25 31 41 63 74 | 69 6f 6e 5f 25 32 37 54 |r t%1Act|ion_%27T|
|000025a0| 61 62 6c 65 4e 61 6d 65 | 20 6f 6e 20 25 54 61 62 |ableName| on %Tab|
|000025b0| 6c 65 4e 61 6d 65 20 66 | 6f 72 20 25 41 63 74 69 |leName f|or %Acti|
|000025c0| 6f 6e 20 61 73 0d 0a 2f | 2a 20 45 52 77 69 6e 20 |on as../|* ERwin |
|000025d0| 42 75 69 6c 74 69 6e 20 | 25 44 61 74 65 74 69 6d |Builtin |%Datetim|
|000025e0| 65 20 2a 2f 0d 0a 2f 2a | 20 25 41 63 74 69 6f 6e |e */../*| %Action|
|000025f0| 20 74 72 69 67 67 65 72 | 20 6f 6e 20 25 54 61 62 | trigger| on %Tab|
|00002600| 6c 65 4e 61 6d 65 20 2a | 2f 0d 0a 62 65 67 69 6e |leName *|/..begin|
|00002610| 0d 0a 20 20 64 65 63 6c | 61 72 65 20 20 40 6e 75 |..  decl|are  @nu|
|00002620| 6d 72 6f 77 73 20 69 6e | 74 2c 0d 0a 20 20 20 20 |mrows in|t,..    |
|00002630| 20 20 20 20 20 20 20 40 | 6e 75 6c 6c 63 6e 74 20 |       @|nullcnt |
|00002640| 69 6e 74 2c 0d 0a 20 20 | 20 20 20 20 20 20 20 20 |int,..  |        |
|00002650| 20 40 76 61 6c 69 64 63 | 6e 74 20 69 6e 74 2c 0d | @validc|nt int,.|
|00002660| 0a 20 20 20 20 20 20 20 | 20 20 20 20 25 50 4b 44 |.       |    %PKD|
|00002670| 65 63 6c 28 2c 40 69 6e | 73 29 25 64 65 63 6c 28 |ecl(,@in|s)%decl(|
|00002680| 62 43 6f 6d 6d 61 2c 30 | 29 25 46 6f 72 45 61 63 |bComma,0|)%ForEac|
|00002690| 68 41 74 74 28 29 20 7b | 25 69 66 28 25 41 74 74 |hAtt() {|%if(%Att|
|000026a0| 49 73 50 6b 29 20 7b 25 | 3d 28 62 43 6f 6d 6d 61 |IsPk) {%|=(bComma|
|000026b0| 2c 31 29 7d 20 7d 25 69 | 66 20 28 25 3d 3d 28 25 |,1)} }%i|f (%==(%|
|000026c0| 3a 62 43 6f 6d 6d 61 2c | 31 29 29 20 7b 2c 7d 0d |:bComma,|1)) {,}.|
|000026d0| 0a 20 20 20 20 20 20 20 | 20 20 20 20 40 65 72 72 |.       |    @err|
|000026e0| 6e 6f 20 20 20 69 6e 74 | 2c 0d 0a 20 20 20 20 20 |no   int|,..     |
|000026f0| 20 20 20 20 20 20 40 65 | 72 72 6d 73 67 20 20 76 |      @e|rrmsg  v|
|00002700| 61 72 63 68 61 72 28 32 | 35 35 29 0d 0a 0d 0a 20 |archar(2|55).... |
|00002710| 20 73 65 6c 65 63 74 20 | 40 6e 75 6d 72 6f 77 73 | select |@numrows|
|00002720| 20 3d 20 40 40 72 6f 77 | 63 6f 75 6e 74 28 27 00 | = @@row|count('.|
|00002730| 00 00 00 00 00 00 00 00 | 00 05 00 00 00 0d 00 55 |........|.......U|
|00002740| 50 44 41 54 45 20 46 4f | 4f 54 45 52 74 00 20 20 |PDATE FO|OTERt.  |
|00002750| 2f 2a 20 45 52 77 69 6e | 20 42 75 69 6c 74 69 6e |/* ERwin| Builtin|
|00002760| 20 25 44 61 74 65 74 69 | 6d 65 20 2a 2f 0d 0a 20 | %Dateti|me */.. |
|00002770| 20 72 65 74 75 72 6e 0d | 0a 65 72 72 6f 72 3a 0d | return.|.error:.|
|00002780| 0a 20 20 20 20 72 61 69 | 73 65 72 72 6f 72 20 40 |.    rai|serror @|
|00002790| 65 72 72 6e 6f 20 40 65 | 72 72 6d 73 67 0d 0a 20 |errno @e|rrmsg.. |
|000027a0| 20 20 20 72 6f 6c 6c 62 | 61 63 6b 20 74 72 61 6e |   rollb|ack tran|
|000027b0| 73 61 63 74 69 6f 6e 0d | 0a 65 6e 64 0d 0a 67 6f |saction.|.end..go|
|000027c0| 0d 0a 29 27 00 00 00 00 | 00 00 00 00 00 00 05 00 |..)'....|........|
|000027d0| 00 00 0d 00 44 45 4c 45 | 54 45 20 48 45 41 44 45 |....DELE|TE HEADE|
|000027e0| 52 c9 00 63 72 65 61 74 | 65 20 74 72 69 67 67 65 |R..creat|e trigge|
|000027f0| 72 20 74 25 31 41 63 74 | 69 6f 6e 5f 25 32 37 54 |r t%1Act|ion_%27T|
|00002800| 61 62 6c 65 4e 61 6d 65 | 20 6f 6e 20 25 54 61 62 |ableName| on %Tab|
|00002810| 6c 65 4e 61 6d 65 20 66 | 6f 72 20 25 41 63 74 69 |leName f|or %Acti|
|00002820| 6f 6e 20 61 73 0d 0a 2f | 2a 20 45 52 77 69 6e 20 |on as../|* ERwin |
|00002830| 42 75 69 6c 74 69 6e 20 | 25 44 61 74 65 74 69 6d |Builtin |%Datetim|
|00002840| 65 20 2a 2f 0d 0a 2f 2a | 20 25 41 63 74 69 6f 6e |e */../*| %Action|
|00002850| 20 74 72 69 67 67 65 72 | 20 6f 6e 20 25 54 61 62 | trigger| on %Tab|
|00002860| 6c 65 4e 61 6d 65 20 2a | 2f 0d 0a 62 65 67 69 6e |leName *|/..begin|
|00002870| 0d 0a 20 20 64 65 63 6c | 61 72 65 20 20 40 65 72 |..  decl|are  @er|
|00002880| 72 6e 6f 20 20 20 69 6e | 74 2c 0d 0a 20 20 20 20 |rno   in|t,..    |
|00002890| 20 20 20 20 20 20 20 40 | 65 72 72 6d 73 67 20 20 |       @|errmsg  |
|000028a0| 76 61 72 63 68 61 72 28 | 32 35 35 29 2a 27 00 00 |varchar(|255)*'..|
|000028b0| 00 00 00 00 00 00 00 00 | 05 00 00 00 0d 00 44 45 |........|......DE|
|000028c0| 4c 45 54 45 20 46 4f 4f | 54 45 52 78 00 20 20 20 |LETE FOO|TERx.   |
|000028d0| 20 2f 2a 20 45 52 77 69 | 6e 20 42 75 69 6c 74 69 | /* ERwi|n Builti|
|000028e0| 6e 20 25 44 61 74 65 74 | 69 6d 65 20 2a 2f 0d 0a |n %Datet|ime */..|
|000028f0| 20 20 20 20 72 65 74 75 | 72 6e 0d 0a 65 72 72 6f |    retu|rn..erro|
|00002900| 72 3a 0d 0a 20 20 20 20 | 72 61 69 73 65 72 72 6f |r:..    |raiserro|
|00002910| 72 20 40 65 72 72 6e 6f | 20 40 65 72 72 6d 73 67 |r @errno| @errmsg|
|00002920| 0d 0a 20 20 20 20 72 6f | 6c 6c 62 61 63 6b 20 74 |..    ro|llback t|
|00002930| 72 61 6e 73 61 63 74 69 | 6f 6e 0d 0a 65 6e 64 0d |ransacti|on..end.|
|00002940| 0a 67 6f 0d 0a 2b 27 00 | 00 00 00 00 00 00 00 00 |.go..+'.|........|
|00002950| 00 05 00 00 00 0d 00 49 | 4e 53 45 52 54 20 48 45 |.......I|NSERT HE|
|00002960| 41 44 45 52 3a 01 63 72 | 65 61 74 65 20 74 72 69 |ADER:.cr|eate tri|
|00002970| 67 67 65 72 20 74 25 31 | 41 63 74 69 6f 6e 5f 25 |gger t%1|Action_%|
|00002980| 32 37 54 61 62 6c 65 4e | 61 6d 65 20 6f 6e 20 25 |27TableN|ame on %|
|00002990| 54 61 62 6c 65 4e 61 6d | 65 20 66 6f 72 20 25 41 |TableNam|e for %A|
|000029a0| 63 74 69 6f 6e 20 61 73 | 0d 0a 2f 2a 20 45 52 77 |ction as|../* ERw|
|000029b0| 69 6e 20 42 75 69 6c 74 | 69 6e 20 25 44 61 74 65 |in Built|in %Date|
|000029c0| 74 69 6d 65 20 2a 2f 0d | 0a 2f 2a 20 25 41 63 74 |time */.|./* %Act|
|000029d0| 69 6f 6e 20 74 72 69 67 | 67 65 72 20 6f 6e 20 25 |ion trig|ger on %|
|000029e0| 54 61 62 6c 65 4e 61 6d | 65 20 2a 2f 0d 0a 62 65 |TableNam|e */..be|
|000029f0| 67 69 6e 0d 0a 20 20 64 | 65 63 6c 61 72 65 20 20 |gin..  d|eclare  |
|00002a00| 40 6e 75 6d 72 6f 77 73 | 20 69 6e 74 2c 0d 0a 20 |@numrows| int,.. |
|00002a10| 20 20 20 20 20 20 20 20 | 20 20 40 6e 75 6c 6c 63 |        |  @nullc|
|00002a20| 6e 74 20 69 6e 74 2c 0d | 0a 20 20 20 20 20 20 20 |nt int,.|.       |
|00002a30| 20 20 20 20 40 76 61 6c | 69 64 63 6e 74 20 69 6e |    @val|idcnt in|
|00002a40| 74 2c 0d 0a 20 20 20 20 | 20 20 20 20 20 20 20 40 |t,..    |       @|
|00002a50| 65 72 72 6e 6f 20 20 20 | 69 6e 74 2c 0d 0a 20 20 |errno   |int,..  |
|00002a60| 20 20 20 20 20 20 20 20 | 20 40 65 72 72 6d 73 67 |        | @errmsg|
|00002a70| 20 20 76 61 72 63 68 61 | 72 28 32 35 35 29 0d 0a |  varcha|r(255)..|
|00002a80| 0d 0a 20 20 73 65 6c 65 | 63 74 20 40 6e 75 6d 72 |..  sele|ct @numr|
|00002a90| 6f 77 73 20 3d 20 40 40 | 72 6f 77 63 6f 75 6e 74 |ows = @@|rowcount|
|00002aa0| 2c 27 00 00 00 00 00 00 | 00 00 00 00 05 00 00 00 |,'......|........|
|00002ab0| 0d 00 49 4e 53 45 52 54 | 20 46 4f 4f 54 45 52 74 |..INSERT| FOOTERt|
|00002ac0| 00 20 20 2f 2a 20 45 52 | 77 69 6e 20 42 75 69 6c |.  /* ER|win Buil|
|00002ad0| 74 69 6e 20 25 44 61 74 | 65 74 69 6d 65 20 2a 2f |tin %Dat|etime */|
|00002ae0| 0d 0a 20 20 72 65 74 75 | 72 6e 0d 0a 65 72 72 6f |..  retu|rn..erro|
|00002af0| 72 3a 0d 0a 20 20 20 20 | 72 61 69 73 65 72 72 6f |r:..    |raiserro|
|00002b00| 72 20 40 65 72 72 6e 6f | 20 40 65 72 72 6d 73 67 |r @errno| @errmsg|
|00002b10| 0d 0a 20 20 20 20 72 6f | 6c 6c 62 61 63 6b 20 74 |..    ro|llback t|
|00002b20| 72 61 6e 73 61 63 74 69 | 6f 6e 0d 0a 65 6e 64 0d |ransacti|on..end.|
|00002b30| 0a 67 6f 0d 0a 2d 27 00 | 00 00 00 00 00 00 00 00 |.go..-'.|........|
|00002b40| 00 05 00 00 00 15 00 43 | 55 53 54 4f 4d 20 54 52 |.......C|USTOM TR|
|00002b50| 49 47 47 45 52 20 48 45 | 41 44 45 52 46 00 63 72 |IGGER HE|ADERF.cr|
|00002b60| 65 61 74 65 20 74 72 69 | 67 67 65 72 20 25 54 72 |eate tri|gger %Tr|
|00002b70| 69 67 67 65 72 4e 61 6d | 65 20 6f 6e 20 25 54 61 |iggerNam|e on %Ta|
|00002b80| 62 6c 65 4e 61 6d 65 0d | 0a 20 20 66 6f 72 20 25 |bleName.|.  for %|
|00002b90| 41 63 74 69 6f 6e 73 28 | 22 2c 22 29 0d 0a 20 20 |Actions(|",")..  |
|00002ba0| 61 73 0d 0a 2e 27 00 00 | 00 00 00 00 00 00 00 00 |as...'..|........|
|00002bb0| 05 00 00 00 15 00 43 55 | 53 54 4f 4d 20 54 52 49 |......CU|STOM TRI|
|00002bc0| 47 47 45 52 20 46 4f 4f | 54 45 52 00 00 00 00 00 |GGER FOO|TER.....|
|00002bd0| 00 00 00 00 00 00 00 00 | 00 05 00 00 00 15 00 43 |........|.......C|
|00002be0| 55 53 54 4f 4d 20 54 52 | 49 47 47 45 52 20 46 4f |USTOM TR|IGGER FO|
|00002bf0| 4f 54 45 52 00 00 00 00 | 00 00 00 00 00 00 00 00 |OTER....|........|
|00002c00| 00 00 05 00 00 00 15 00 | 43 55 53 54 4f 4d 20 54 |........|CUSTOM T|
|00002c10| 52 49 47 47 45 52 20 46 | 4f 4f 54 45 52 04 00 67 |RIGGER F|OOTER..g|
|00002c20| 6f 0d 0a 2f 27 00 00 00 | 00 00 00 00 00 00 00 05 |o../'...|........|
|00002c30| 00 00 00 1b 00 43 55 53 | 54 4f 4d 20 54 52 49 47 |.....CUS|TOM TRIG|
|00002c40| 47 45 52 20 44 45 46 41 | 55 4c 54 20 42 4f 44 59 |GER DEFA|ULT BODY|
|00002c50| 7f 02 63 72 65 61 74 65 | 20 74 72 69 67 67 65 72 |..create| trigger|
|00002c60| 20 25 54 72 69 67 67 65 | 72 4e 61 6d 65 20 6f 6e | %Trigge|rName on|
|00002c70| 20 25 54 61 62 6c 65 4e | 61 6d 65 0d 0a 20 20 66 | %TableN|ame..  f|
|00002c80| 6f 72 20 25 41 63 74 69 | 6f 6e 73 28 22 2c 22 29 |or %Acti|ons(",")|
|00002c90| 0d 0a 20 20 61 73 0d 0a | 2f 2a 20 45 52 77 69 6e |..  as..|/* ERwin|
|00002ca0| 20 42 75 69 6c 74 69 6e | 20 25 44 61 74 65 74 69 | Builtin| %Dateti|
|00002cb0| 6d 65 20 2a 2f 0d 0a 2f | 2a 20 25 41 63 74 69 6f |me */../|* %Actio|
|00002cc0| 6e 73 28 22 2c 22 29 20 | 74 72 69 67 67 65 72 20 |ns(",") |trigger |
|00002cd0| 6f 6e 20 25 54 61 62 6c | 65 4e 61 6d 65 20 2a 2f |on %Tabl|eName */|
|00002ce0| 0d 0a 2f 2a 20 64 65 66 | 61 75 6c 74 20 62 6f 64 |../* def|ault bod|
|00002cf0| 79 20 66 6f 72 20 25 54 | 72 69 67 67 65 72 4e 61 |y for %T|riggerNa|
|00002d00| 6d 65 20 2a 2f 0d 0a 62 | 65 67 69 6e 0d 0a 20 20 |me */..b|egin..  |
|00002d10| 64 65 63 6c 61 72 65 20 | 20 40 6e 75 6d 72 6f 77 |declare | @numrow|
|00002d20| 73 20 69 6e 74 2c 0d 0a | 20 20 20 20 20 20 20 20 |s int,..|        |
|00002d30| 20 20 20 40 6e 75 6c 6c | 63 6e 74 20 69 6e 74 2c |   @null|cnt int,|
|00002d40| 0d 0a 20 20 20 20 20 20 | 20 20 20 20 20 40 76 61 |..      |     @va|
|00002d50| 6c 69 64 63 6e 74 20 69 | 6e 74 2c 0d 0a 20 20 20 |lidcnt i|nt,..   |
|00002d60| 20 20 20 20 20 20 20 20 | 25 50 4b 44 65 63 6c 28 |        |%PKDecl(|
|00002d70| 2c 40 69 6e 73 29 25 64 | 65 63 6c 28 62 43 6f 6d |,@ins)%d|ecl(bCom|
|00002d80| 6d 61 2c 30 29 25 46 6f | 72 45 61 63 68 41 74 74 |ma,0)%Fo|rEachAtt|
|00002d90| 28 29 20 7b 25 69 66 28 | 25 41 74 74 49 73 50 6b |() {%if(|%AttIsPk|
|00002da0| 29 20 7b 25 3d 28 62 43 | 6f 6d 6d 61 2c 31 29 7d |) {%=(bC|omma,1)}|
|00002db0| 20 7d 25 69 66 20 28 25 | 3d 3d 28 25 3a 62 43 6f | }%if (%|==(%:bCo|
|00002dc0| 6d 6d 61 2c 31 29 29 20 | 7b 2c 7d 0d 0a 20 20 20 |mma,1)) |{,}..   |
|00002dd0| 20 20 20 20 20 20 20 20 | 40 65 72 72 6e 6f 20 20 |        |@errno  |
|00002de0| 20 69 6e 74 2c 0d 0a 20 | 20 20 20 20 20 20 20 20 | int,.. |        |
|00002df0| 20 20 40 65 72 72 6d 73 | 67 20 20 76 61 72 63 68 |  @errms|g  varch|
|00002e00| 61 72 28 32 35 35 29 0d | 0a 0d 0a 20 20 73 65 6c |ar(255).|...  sel|
|00002e10| 65 63 74 20 40 6e 75 6d | 72 6f 77 73 20 3d 20 40 |ect @num|rows = @|
|00002e20| 40 72 6f 77 63 6f 75 6e | 74 0d 0a 25 46 6f 72 45 |@rowcoun|t..%ForE|
|00002e30| 61 63 68 43 68 69 6c 64 | 52 65 6c 28 29 20 7b 0d |achChild|Rel() {.|
|00002e40| 0a 20 20 25 52 65 6c 54 | 65 6d 70 6c 61 74 65 0d |.  %RelT|emplate.|
|00002e50| 0a 7d 0d 0a 25 46 6f 72 | 45 61 63 68 50 61 72 65 |.}..%For|EachPare|
|00002e60| 6e 74 52 65 6c 28 29 20 | 7b 0d 0a 20 20 25 52 65 |ntRel() |{..  %Re|
|00002e70| 6c 54 65 6d 70 6c 61 74 | 65 0d 0a 7d 0d 0a 20 20 |lTemplat|e..}..  |
|00002e80| 72 65 74 75 72 6e 0d 0a | 65 72 72 6f 72 3a 0d 0a |return..|error:..|
|00002e90| 20 20 20 20 72 61 69 73 | 65 72 72 6f 72 20 40 65 |    rais|error @e|
|00002ea0| 72 72 6e 6f 20 40 65 72 | 72 6d 73 67 0d 0a 20 20 |rrno @er|rmsg..  |
|00002eb0| 20 20 72 6f 6c 6c 62 61 | 63 6b 20 74 72 61 6e 73 |  rollba|ck trans|
|00002ec0| 61 63 74 69 6f 6e 0d 0a | 65 6e 64 0d 0a 67 6f 0d |action..|end..go.|
|00002ed0| 0a 30 27 00 00 00 00 00 | 00 00 00 00 00 05 00 00 |.0'.....|........|
|00002ee0| 00 19 00 50 41 52 45 4e | 54 20 55 50 44 41 54 45 |...PAREN|T UPDATE|
|00002ef0| 20 53 45 54 20 44 45 46 | 41 55 4c 54 92 00 2f 2a | SET DEF|AULT../*|
|00002f00| 20 45 52 77 69 6e 20 42 | 75 69 6c 74 69 6e 20 25 | ERwin B|uiltin %|
|00002f10| 44 61 74 65 74 69 6d 65 | 20 2a 2f 0d 0a 2f 2a 20 |Datetime| */../* |
|00002f20| 25 50 61 72 65 6e 74 20 | 25 56 65 72 62 50 68 72 |%Parent |%VerbPhr|
|00002f30| 61 73 65 20 25 43 68 69 | 6c 64 20 4f 4e 20 50 41 |ase %Chi|ld ON PA|
|00002f40| 52 45 4e 54 20 55 50 44 | 41 54 45 20 53 45 54 20 |RENT UPD|ATE SET |
|00002f50| 44 45 46 41 55 4c 54 20 | 2a 2f 0d 0a 2f 2a 20 41 |DEFAULT |*/../* A|
|00002f60| 70 70 6c 69 63 61 74 69 | 6f 6e 20 73 70 65 63 69 |pplicati|on speci|
|00002f70| 66 69 63 2e 20 20 4c 65 | 66 74 20 6f 75 74 20 69 |fic.  Le|ft out i|
|00002f80| 6e 74 65 6e 74 69 6f 6e | 61 6c 6c 79 2e 20 2a 2f |ntention|ally. */|
|00002f90| 13 27 00 00 00 00 00 00 | 00 00 00 00 05 00 00 00 |.'......|........|
|00002fa0| 19 00 50 41 52 45 4e 54 | 20 44 45 4c 45 54 45 20 |..PARENT| DELETE |
|00002fb0| 53 45 54 20 44 45 46 41 | 55 4c 54 92 00 2f 2a 20 |SET DEFA|ULT../* |
|00002fc0| 45 52 77 69 6e 20 42 75 | 69 6c 74 69 6e 20 25 44 |ERwin Bu|iltin %D|
|00002fd0| 61 74 65 74 69 6d 65 20 | 2a 2f 0d 0a 2f 2a 20 25 |atetime |*/../* %|
|00002fe0| 50 61 72 65 6e 74 20 25 | 56 65 72 62 50 68 72 61 |Parent %|VerbPhra|
|00002ff0| 73 65 20 25 43 68 69 6c | 64 20 4f 4e 20 50 41 52 |se %Chil|d ON PAR|
|00003000| 45 4e 54 20 44 45 4c 45 | 54 45 20 53 45 54 20 44 |ENT DELE|TE SET D|
|00003010| 45 46 41 55 4c 54 20 2a | 2f 0d 0a 2f 2a 20 41 70 |EFAULT *|/../* Ap|
|00003020| 70 6c 69 63 61 74 69 6f | 6e 20 73 70 65 63 69 66 |plicatio|n specif|
|00003030| 69 63 2e 20 20 4c 65 66 | 74 20 6f 75 74 20 69 6e |ic.  Lef|t out in|
|00003040| 74 65 6e 74 69 6f 6e 61 | 6c 6c 79 2e 20 2a 2f 17 |tentiona|lly. */.|
|00003050| 27 00 00 00 00 00 00 00 | 00 00 00 05 00 00 00 19 |'.......|........|
|00003060| 00 50 41 52 45 4e 54 20 | 49 4e 53 45 52 54 20 53 |.PARENT |INSERT S|
|00003070| 45 54 20 44 45 46 41 55 | 4c 54 92 00 2f 2a 20 45 |ET DEFAU|LT../* E|
|00003080| 52 77 69 6e 20 42 75 69 | 6c 74 69 6e 20 25 44 61 |Rwin Bui|ltin %Da|
|00003090| 74 65 74 69 6d 65 20 2a | 2f 0d 0a 2f 2a 20 25 50 |tetime *|/../* %P|
|000030a0| 61 72 65 6e 74 20 25 56 | 65 72 62 50 68 72 61 73 |arent %V|erbPhras|
|000030b0| 65 20 25 43 68 69 6c 64 | 20 4f 4e 20 50 41 52 45 |e %Child| ON PARE|
|000030c0| 4e 54 20 49 4e 53 45 52 | 54 20 53 45 54 20 44 45 |NT INSER|T SET DE|
|000030d0| 46 41 55 4c 54 20 2a 2f | 0d 0a 2f 2a 20 41 70 70 |FAULT */|../* App|
|000030e0| 6c 69 63 61 74 69 6f 6e | 20 73 70 65 63 69 66 69 |lication| specifi|
|000030f0| 63 2e 20 20 4c 65 66 74 | 20 6f 75 74 20 69 6e 74 |c.  Left| out int|
|00003100| 65 6e 74 69 6f 6e 61 6c | 6c 79 2e 20 2a 2f 27 27 |entional|ly. */''|
|00003110| 00 00 00 00 00 00 00 00 | 00 00 05 00 00 00 18 00 |........|........|
|00003120| 43 48 49 4c 44 20 49 4e | 53 45 52 54 20 53 45 54 |CHILD IN|SERT SET|
|00003130| 20 44 45 46 41 55 4c 54 | 91 00 2f 2a 20 45 52 77 | DEFAULT|../* ERw|
|00003140| 69 6e 20 42 75 69 6c 74 | 69 6e 20 25 44 61 74 65 |in Built|in %Date|
|00003150| 74 69 6d 65 20 2a 2f 0d | 0a 2f 2a 20 25 50 61 72 |time */.|./* %Par|
|00003160| 65 6e 74 20 25 56 65 72 | 62 50 68 72 61 73 65 20 |ent %Ver|bPhrase |
|00003170| 25 43 68 69 6c 64 20 4f | 4e 20 43 48 49 4c 44 20 |%Child O|N CHILD |
|00003180| 49 4e 53 45 52 54 20 53 | 45 54 20 44 45 46 41 55 |INSERT S|ET DEFAU|
|00003190| 4c 54 20 2a 2f 0d 0a 2f | 2a 20 41 70 70 6c 69 63 |LT */../|* Applic|
|000031a0| 61 74 69 6f 6e 20 73 70 | 65 63 69 66 69 63 2e 20 |ation sp|ecific. |
|000031b0| 20 4c 65 66 74 20 6f 75 | 74 20 69 6e 74 65 6e 74 | Left ou|t intent|
|000031c0| 69 6f 6e 61 6c 6c 79 2e | 20 2a 2f 1b 27 00 00 00 |ionally.| */.'...|
|000031d0| 00 00 00 00 00 00 00 05 | 00 00 00 18 00 43 48 49 |........|.....CHI|
|000031e0| 4c 44 20 55 50 44 41 54 | 45 20 53 45 54 20 44 45 |LD UPDAT|E SET DE|
|000031f0| 46 41 55 4c 54 91 00 2f | 2a 20 45 52 77 69 6e 20 |FAULT../|* ERwin |
|00003200| 42 75 69 6c 74 69 6e 20 | 25 44 61 74 65 74 69 6d |Builtin |%Datetim|
|00003210| 65 20 2a 2f 0d 0a 2f 2a | 20 25 50 61 72 65 6e 74 |e */../*| %Parent|
|00003220| 20 25 56 65 72 62 50 68 | 72 61 73 65 20 25 43 68 | %VerbPh|rase %Ch|
|00003230| 69 6c 64 20 4f 4e 20 43 | 48 49 4c 44 20 55 50 44 |ild ON C|HILD UPD|
|00003240| 41 54 45 20 53 45 54 20 | 44 45 46 41 55 4c 54 20 |ATE SET |DEFAULT |
|00003250| 2a 2f 0d 0a 2f 2a 20 41 | 70 70 6c 69 63 61 74 69 |*/../* A|pplicati|
|00003260| 6f 6e 20 73 70 65 63 69 | 66 69 63 2e 20 20 4c 65 |on speci|fic.  Le|
|00003270| 66 74 20 6f 75 74 20 69 | 6e 74 65 6e 74 69 6f 6e |ft out i|ntention|
|00003280| 61 6c 6c 79 2e 20 2a 2f | 1f 27 00 00 00 00 00 00 |ally. */|.'......|
|00003290| 00 00 00 00 05 00 00 00 | 18 00 43 48 49 4c 44 20 |........|..CHILD |
|000032a0| 44 45 4c 45 54 45 20 53 | 45 54 20 44 45 46 41 55 |DELETE S|ET DEFAU|
|000032b0| 4c 54 91 00 2f 2a 20 45 | 52 77 69 6e 20 42 75 69 |LT../* E|Rwin Bui|
|000032c0| 6c 74 69 6e 20 25 44 61 | 74 65 74 69 6d 65 20 2a |ltin %Da|tetime *|
|000032d0| 2f 0d 0a 2f 2a 20 25 50 | 61 72 65 6e 74 20 25 56 |/../* %P|arent %V|
|000032e0| 65 72 62 50 68 72 61 73 | 65 20 25 43 68 69 6c 64 |erbPhras|e %Child|
|000032f0| 20 4f 4e 20 43 48 49 4c | 44 20 44 45 4c 45 54 45 | ON CHIL|D DELETE|
|00003300| 20 53 45 54 20 44 45 46 | 41 55 4c 54 20 2a 2f 0d | SET DEF|AULT */.|
|00003310| 0a 2f 2a 20 41 70 70 6c | 69 63 61 74 69 6f 6e 20 |./* Appl|ication |
|00003320| 73 70 65 63 69 66 69 63 | 2e 20 20 4c 65 66 74 20 |specific|.  Left |
|00003330| 6f 75 74 20 69 6e 74 65 | 6e 74 69 6f 6e 61 6c 6c |out inte|ntionall|
|00003340| 79 2e 20 2a 2f 23 27 00 | 00 00 00 00 00 00 00 00 |y. */#'.|........|
|00003350| 00 05 00 00 00 15 00 43 | 48 49 4c 44 20 44 45 4c |.......C|HILD DEL|
|00003360| 45 54 45 20 53 45 54 20 | 4e 55 4c 4c 8e 00 2f 2a |ETE SET |NULL../*|
|00003370| 20 45 52 77 69 6e 20 42 | 75 69 6c 74 69 6e 20 25 | ERwin B|uiltin %|
|00003380| 44 61 74 65 74 69 6d 65 | 20 2a 2f 0d 0a 2f 2a 20 |Datetime| */../* |
|00003390| 25 50 61 72 65 6e 74 20 | 25 56 65 72 62 50 68 72 |%Parent |%VerbPhr|
|000033a0| 61 73 65 20 25 43 68 69 | 6c 64 20 4f 4e 20 43 48 |ase %Chi|ld ON CH|
|000033b0| 49 4c 44 20 44 45 4c 45 | 54 45 20 53 45 54 20 4e |ILD DELE|TE SET N|
|000033c0| 55 4c 4c 20 2a 2f 0d 0a | 2f 2a 20 41 70 70 6c 69 |ULL */..|/* Appli|
|000033d0| 63 61 74 69 6f 6e 20 73 | 70 65 63 69 66 69 63 2e |cation s|pecific.|
|000033e0| 20 20 4c 65 66 74 20 6f | 75 74 20 69 6e 74 65 6e |  Left o|ut inten|
|000033f0| 74 69 6f 6e 61 6c 6c 79 | 2e 20 2a 2f 22 27 00 00 |tionally|. */"'..|
|00003400| 00 00 00 00 00 00 00 00 | 05 00 00 00 16 00 50 41 |........|......PA|
|00003410| 52 45 4e 54 20 49 4e 53 | 45 52 54 20 53 45 54 20 |RENT INS|ERT SET |
|00003420| 4e 55 4c 4c 8f 00 2f 2a | 20 45 52 77 69 6e 20 42 |NULL../*| ERwin B|
|00003430| 75 69 6c 74 69 6e 20 25 | 44 61 74 65 74 69 6d 65 |uiltin %|Datetime|
|00003440| 20 2a 2f 0d 0a 2f 2a 20 | 25 50 61 72 65 6e 74 20 | */../* |%Parent |
|00003450| 25 56 65 72 62 50 68 72 | 61 73 65 20 25 43 68 69 |%VerbPhr|ase %Chi|
|00003460| 6c 64 20 4f 4e 20 50 41 | 52 45 4e 54 20 49 4e 53 |ld ON PA|RENT INS|
|00003470| 45 52 54 20 53 45 54 20 | 4e 55 4c 4c 20 2a 2f 0d |ERT SET |NULL */.|
|00003480| 0a 2f 2a 20 41 70 70 6c | 69 63 61 74 69 6f 6e 20 |./* Appl|ication |
|00003490| 73 70 65 63 69 66 69 63 | 2e 20 20 4c 65 66 74 20 |specific|.  Left |
|000034a0| 6f 75 74 20 69 6e 74 65 | 6e 74 69 6f 6e 61 6c 6c |out inte|ntionall|
|000034b0| 79 2e 20 2a 2f 26 27 00 | 00 00 00 00 00 00 00 00 |y. */&'.|........|
|000034c0| 00 05 00 00 00 15 00 50 | 41 52 45 4e 54 20 49 4e |.......P|ARENT IN|
|000034d0| 53 45 52 54 20 43 41 53 | 43 41 44 45 8e 00 2f 2a |SERT CAS|CADE../*|
|000034e0| 20 45 52 77 69 6e 20 42 | 75 69 6c 74 69 6e 20 25 | ERwin B|uiltin %|
|000034f0| 44 61 74 65 74 69 6d 65 | 20 2a 2f 0d 0a 2f 2a 20 |Datetime| */../* |
|00003500| 25 50 61 72 65 6e 74 20 | 25 56 65 72 62 50 68 72 |%Parent |%VerbPhr|
|00003510| 61 73 65 20 25 43 68 69 | 6c 64 20 4f 4e 20 50 41 |ase %Chi|ld ON PA|
|00003520| 52 45 4e 54 20 49 4e 53 | 45 52 54 20 43 41 53 43 |RENT INS|ERT CASC|
|00003530| 41 44 45 20 2a 2f 0d 0a | 2f 2a 20 41 70 70 6c 69 |ADE */..|/* Appli|
|00003540| 63 61 74 69 6f 6e 20 73 | 70 65 63 69 66 69 63 2e |cation s|pecific.|
|00003550| 20 20 4c 65 66 74 20 6f | 75 74 20 69 6e 74 65 6e |  Left o|ut inten|
|00003560| 74 69 6f 6e 61 6c 6c 79 | 2e 20 2a 2f 25 27 00 00 |tionally|. */%'..|
|00003570| 00 00 00 00 00 00 00 00 | 02 00 00 00 03 00 0d 00 |........|........|
|00003580| 54 65 6d 70 6c 61 74 65 | 20 4e 61 6d 65 22 00 00 |Template| Name"..|
|00003590| 00 00 02 00 0f 00 54 65 | 6d 70 6c 61 74 65 20 48 |......Te|mplate H|
|000035a0| 61 6e 64 6c 65 00 00 00 | 00 00 00 00 00 00 03 00 |andle...|........|
|000035b0| 00 00 01 00 0c 00 50 75 | 72 70 6f 73 65 20 54 65 |......Pu|rpose Te|
|000035c0| 78 74 22 00 00 00 00 00 | 00 07 00 50 75 72 70 6f |xt".....|...Purpo|
|000035d0| 73 65 00 00 00 00 00 02 | 00 0f 00 54 65 6d 70 6c |se......|...Templ|
|000035e0| 61 74 65 20 48 61 6e 64 | 6c 65 22 00 00 00 00 22 |ate Hand|le"...."|
|000035f0| 00 00 00 03 00 00 00 14 | 00 43 48 49 4c 44 20 44 |........|.CHILD D|
|00003600| 45 4c 45 54 45 20 43 41 | 53 43 41 44 45 21 27 00 |ELETE CA|SCADE!'.|
|00003610| 00 21 27 ff ff 03 00 00 | 00 15 00 43 48 49 4c 44 |.!'.....|...CHILD|
|00003620| 20 44 45 4c 45 54 45 20 | 52 45 53 54 52 49 43 54 | DELETE |RESTRICT|
|00003630| 20 27 00 00 20 27 ff ff | 03 00 00 00 18 00 43 48 | '.. '..|......CH|
|00003640| 49 4c 44 20 44 45 4c 45 | 54 45 20 53 45 54 20 44 |ILD DELE|TE SET D|
|00003650| 45 46 41 55 4c 54 23 27 | 00 00 23 27 ff ff 03 00 |EFAULT#'|..#'....|
|00003660| 00 00 15 00 43 48 49 4c | 44 20 44 45 4c 45 54 45 |....CHIL|D DELETE|
|00003670| 20 53 45 54 20 4e 55 4c | 4c 22 27 00 00 22 27 ff | SET NUL|L"'.."'.|
|00003680| ff 03 00 00 00 14 00 43 | 48 49 4c 44 20 49 4e 53 |.......C|HILD INS|
|00003690| 45 52 54 20 43 41 53 43 | 41 44 45 19 27 00 00 19 |ERT CASC|ADE.'...|
|000036a0| 27 ff ff 03 00 00 00 15 | 00 43 48 49 4c 44 20 49 |'.......|.CHILD I|
|000036b0| 4e 53 45 52 54 20 52 45 | 53 54 52 49 43 54 18 27 |NSERT RE|STRICT.'|
|000036c0| 00 00 18 27 ff ff 03 00 | 00 00 18 00 43 48 49 4c |...'....|....CHIL|
|000036d0| 44 20 49 4e 53 45 52 54 | 20 53 45 54 20 44 45 46 |D INSERT| SET DEF|
|000036e0| 41 55 4c 54 1b 27 00 00 | 1b 27 ff ff 03 00 00 00 |AULT.'..|.'......|
|000036f0| 15 00 43 48 49 4c 44 20 | 49 4e 53 45 52 54 20 53 |..CHILD |INSERT S|
|00003700| 45 54 20 4e 55 4c 4c 1a | 27 00 00 1a 27 ff ff 03 |ET NULL.|'...'...|
|00003710| 00 00 00 14 00 43 48 49 | 4c 44 20 55 50 44 41 54 |.....CHI|LD UPDAT|
|00003720| 45 20 43 41 53 43 41 44 | 45 1d 27 00 00 1d 27 ff |E CASCAD|E.'...'.|
|00003730| ff 03 00 00 00 15 00 43 | 48 49 4c 44 20 55 50 44 |.......C|HILD UPD|
|00003740| 41 54 45 20 52 45 53 54 | 52 49 43 54 1c 27 00 00 |ATE REST|RICT.'..|
|00003750| 1c 27 ff ff 03 00 00 00 | 18 00 43 48 49 4c 44 20 |.'......|..CHILD |
|00003760| 55 50 44 41 54 45 20 53 | 45 54 20 44 45 46 41 55 |UPDATE S|ET DEFAU|
|00003770| 4c 54 1f 27 00 00 1f 27 | ff ff 03 00 00 00 15 00 |LT.'...'|........|
|00003780| 43 48 49 4c 44 20 55 50 | 44 41 54 45 20 53 45 54 |CHILD UP|DATE SET|
|00003790| 20 4e 55 4c 4c 1e 27 00 | 00 1e 27 ff ff 03 00 00 | NULL.'.|..'.....|
|000037a0| 00 1b 00 43 55 53 54 4f | 4d 20 54 52 49 47 47 45 |...CUSTO|M TRIGGE|
|000037b0| 52 20 44 45 46 41 55 4c | 54 20 42 4f 44 59 30 27 |R DEFAUL|T BODY0'|
|000037c0| 00 00 30 27 ff ff 03 00 | 00 00 15 00 43 55 53 54 |..0'....|....CUST|
|000037d0| 4f 4d 20 54 52 49 47 47 | 45 52 20 46 4f 4f 54 45 |OM TRIGG|ER FOOTE|
|000037e0| 52 2f 27 00 00 2f 27 ff | ff 03 00 00 00 15 00 43 |R/'../'.|.......C|
|000037f0| 55 53 54 4f 4d 20 54 52 | 49 47 47 45 52 20 48 45 |USTOM TR|IGGER HE|
|00003800| 41 44 45 52 2e 27 00 00 | 2e 27 ff ff 03 00 00 00 |ADER.'..|.'......|
|00003810| 15 00 50 41 52 45 4e 54 | 20 44 45 4c 45 54 45 20 |..PARENT| DELETE |
|00003820| 43 41 53 43 41 44 45 15 | 27 00 00 15 27 ff ff 03 |CASCADE.|'...'...|
|00003830| 00 00 00 16 00 50 41 52 | 45 4e 54 20 44 45 4c 45 |.....PAR|ENT DELE|
|00003840| 54 45 20 52 45 53 54 52 | 49 43 54 14 27 00 00 14 |TE RESTR|ICT.'...|
|00003850| 27 ff ff 03 00 00 00 19 | 00 50 41 52 45 4e 54 20 |'.......|.PARENT |
|00003860| 44 45 4c 45 54 45 20 53 | 45 54 20 44 45 46 41 55 |DELETE S|ET DEFAU|
|00003870| 4c 54 17 27 00 00 17 27 | ff ff 03 00 00 00 16 00 |LT.'...'|........|
|00003880| 50 41 52 45 4e 54 20 44 | 45 4c 45 54 45 20 53 45 |PARENT D|ELETE SE|
|00003890| 54 20 4e 55 4c 4c 16 27 | 00 00 16 27 ff ff 03 00 |T NULL.'|...'....|
|000038a0| 00 00 15 00 50 41 52 45 | 4e 54 20 49 4e 53 45 52 |....PARE|NT INSER|
|000038b0| 54 20 43 41 53 43 41 44 | 45 25 27 00 00 25 27 ff |T CASCAD|E%'..%'.|
|000038c0| ff 03 00 00 00 16 00 50 | 41 52 45 4e 54 20 49 4e |.......P|ARENT IN|
|000038d0| 53 45 52 54 20 52 45 53 | 54 52 49 43 54 24 27 00 |SERT RES|TRICT$'.|
|000038e0| 00 24 27 ff ff 03 00 00 | 00 19 00 50 41 52 45 4e |.$'.....|...PAREN|
|000038f0| 54 20 49 4e 53 45 52 54 | 20 53 45 54 20 44 45 46 |T INSERT| SET DEF|
|00003900| 41 55 4c 54 27 27 00 00 | 27 27 ff ff 03 00 00 00 |AULT''..|''......|
|00003910| 16 00 50 41 52 45 4e 54 | 20 49 4e 53 45 52 54 20 |..PARENT| INSERT |
|00003920| 53 45 54 20 4e 55 4c 4c | 26 27 00 00 26 27 ff ff |SET NULL|&'..&'..|
|00003930| 03 00 00 00 15 00 50 41 | 52 45 4e 54 20 55 50 44 |......PA|RENT UPD|
|00003940| 41 54 45 20 43 41 53 43 | 41 44 45 11 27 00 00 11 |ATE CASC|ADE.'...|
|00003950| 27 ff ff 03 00 00 00 16 | 00 50 41 52 45 4e 54 20 |'.......|.PARENT |
|00003960| 55 50 44 41 54 45 20 52 | 45 53 54 52 49 43 54 10 |UPDATE R|ESTRICT.|
|00003970| 27 00 00 10 27 ff ff 03 | 00 00 00 19 00 50 41 52 |'...'...|.....PAR|
|00003980| 45 4e 54 20 55 50 44 41 | 54 45 20 53 45 54 20 44 |ENT UPDA|TE SET D|
|00003990| 45 46 41 55 4c 54 13 27 | 00 00 13 27 ff ff 03 00 |EFAULT.'|...'....|
|000039a0| 00 00 16 00 50 41 52 45 | 4e 54 20 55 50 44 41 54 |....PARE|NT UPDAT|
|000039b0| 45 20 53 45 54 20 4e 55 | 4c 4c 12 27 00 00 12 27 |E SET NU|LL.'...'|
|000039c0| ff ff 03 00 00 00 14 00 | 52 41 49 53 45 20 45 58 |........|RAISE EX|
|000039d0| 43 45 50 54 49 4f 4e 20 | 50 52 4f 43 31 27 00 00 |CEPTION |PROC1'..|
|000039e0| 00 00 ff ff 03 00 00 00 | 15 00 54 52 49 47 47 45 |........|..TRIGGE|
|000039f0| 52 20 44 45 4c 45 54 45 | 20 46 4f 4f 54 45 52 2b |R DELETE| FOOTER+|
|00003a00| 27 00 00 2b 27 ff ff 03 | 00 00 00 15 00 54 52 49 |'..+'...|.....TRI|
|00003a10| 47 47 45 52 20 44 45 4c | 45 54 45 20 48 45 41 44 |GGER DEL|ETE HEAD|
|00003a20| 45 52 2a 27 00 00 2a 27 | ff ff 03 00 00 00 15 00 |ER*'..*'|........|
|00003a30| 54 52 49 47 47 45 52 20 | 49 4e 53 45 52 54 20 46 |TRIGGER |INSERT F|
|00003a40| 4f 4f 54 45 52 2d 27 00 | 00 2d 27 ff ff 03 00 00 |OOTER-'.|.-'.....|
|00003a50| 00 15 00 54 52 49 47 47 | 45 52 20 49 4e 53 45 52 |...TRIGG|ER INSER|
|00003a60| 54 20 48 45 41 44 45 52 | 2c 27 00 00 2c 27 ff ff |T HEADER|,'..,'..|
|00003a70| 03 00 00 00 15 00 54 52 | 49 47 47 45 52 20 55 50 |......TR|IGGER UP|
|00003a80| 44 41 54 45 20 46 4f 4f | 54 45 52 29 27 00 00 29 |DATE FOO|TER)'..)|
|00003a90| 27 ff ff 03 00 00 00 15 | 00 54 52 49 47 47 45 52 |'.......|.TRIGGER|
|00003aa0| 20 55 50 44 41 54 45 20 | 48 45 41 44 45 52 28 27 | UPDATE |HEADER('|
|00003ab0| 00 00 28 27 ff ff 06 00 | 00 00 01 00 00 00 23 00 |..('....|......#.|
|00003ac0| 00 00 00 01 00 00 00 40 | 00 00 00 00 00 00 00 00 |.......@|........|
|00003ad0| 09 00 00 00 00 04 00 00 | 00 00 00 00 00 00 04 00 |........|........|
|00003ae0| 00 00 00 00 00 00 00 02 | 00 00 00 00 00 00 00 00 |........|........|
|00003af0| 00 00 00 00 01 00 00 00 | 02 00 00 00 00 00 00 00 |........|........|
|00003b00| 00 00 00 00 00 06 00 00 | 00 01 00 00 00 23 00 00 |........|.....#..|
|00003b10| 00 00 01 00 00 00 40 00 | 00 00 00 00 00 00 00 09 |......@.|........|
|00003b20| 00 00 00 00 04 00 00 00 | 00 00 00 00 00 04 00 00 |........|........|
|00003b30| 00 00 00 00 00 00 02 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003b40| 00 00 00 06 00 00 00 01 | 00 00 00 1a 00 00 00 00 |........|........|
|00003b50| 01 00 00 00 40 00 00 00 | 00 00 00 00 00 09 00 00 |....@...|........|
|00003b60| 00 00 04 00 00 00 00 00 | 00 00 00 04 00 00 00 00 |........|........|
|00003b70| 00 00 00 00 02 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003b80| 00 01 00 00 00 02 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003b90| 00 00 06 00 00 00 01 00 | 00 00 1a 00 00 00 00 01 |........|........|
|00003ba0| 00 00 00 40 00 00 00 00 | 00 00 00 00 09 00 00 00 |...@....|........|
|00003bb0| 00 04 00 00 00 00 00 00 | 00 00 04 00 00 00 00 00 |........|........|
|00003bc0| 00 00 00 02 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003bd0| 10 27 14 27 18 27 1c 27 | 00 00 00 00 00 00 12 27 |.'.'.'.'|.......'|
|00003be0| 16 27 1a 27 1e 27 00 00 | 00 00 00 00 10 27 14 27 |.'.'.'..|.....'.'|
|00003bf0| 18 27 1c 27 00 00 00 00 | 00 00 11 27 15 27 18 27 |.'.'....|...'.'.'|
|00003c00| 1c 27 00 00 00 00 00 00 | 07 00 00 00 01 00 00 00 |.'......|........|
|00003c10| 00 00 00 00 00 04 00 00 | 00 00 00 00 00 00 02 00 |........|........|
|00003c20| 00 00 00 00 00 00 00 02 | 00 00 00 00 00 00 00 00 |........|........|
|00003c30| 02 00 00 00 00 00 00 00 | 00 04 00 00 00 00 00 00 |........|........|
|00003c40| 00 00 04 00 00 00 00 00 | 00 00 00 07 00 00 00 07 |........|........|
|00003c50| 00 00 00 13 00 44 65 66 | 61 75 6c 74 20 45 6e 74 |.....Def|ault Ent|
|00003c60| 69 74 79 20 49 63 6f 6e | f0 0a 00 00 28 00 00 00 |ity Icon|....(...|
|00003c70| 1e 00 00 00 1e 00 00 00 | 01 00 18 00 00 00 00 00 |........|........|
|00003c80| c8 0a 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003c90| 00 00 00 00 bf bf bf bf | bf bf 7f 7f 7f 7f 7f 7f |........|........|
|00003ca0| 7f 7f 7f 7f 7f 7f 7f 7f | 7f 7f 7f 7f 7f 7f 7f 7f |........|........|
|00003cb0| 7f 7f 7f 7f 7f 7f 7f 7f | 7f 7f 7f 7f 7f 7f 7f 7f |........|........|
|00003cc0| 7f 7f 7f 7f 7f 7f 7f 7f | 7f 7f 7f 7f 7f 7f 7f 7f |........|........|
|00003cd0| 7f 7f 7f 7f 7f 7f 7f 7f | 7f 7f 7f 7f 7f 7f 7f 7f |........|........|
|00003ce0| 7f 7f 7f 7f 7f 7f 7f 7f | bf bf bf bf bf bf 00 00 |........|........|
|00003cf0| bf bf bf ff ff ff 7f 7f | 7f 7f 7f 7f 7f 7f 7f 7f |........|........|
|00003d00| 7f 7f 7f 7f 7f 7f 7f 7f | 7f 7f 7f 7f 7f 7f 7f 7f |........|........|
|00003d10| 7f 7f 7f 7f 7f 7f 7f 7f | 7f 7f 7f 7f 7f 7f 7f 7f |........|........|
|00003d20| 7f 7f 7f 7f 7f 7f 7f 7f | 7f 7f 7f 7f 7f 7f 7f 7f |........|........|
|00003d30| 7f 7f 7f 7f 7f 7f 7f 7f | 7f 7f 7f 7f 7f 7f 7f 7f |........|........|
|00003d40| 7f 7f 7f 7f 7f 7f 7f bf | bf bf 00 00 ff ff ff bf |........|........|
|00003d50| bf bf bf bf bf bf bf bf | bf bf bf bf bf bf bf bf |........|........|
|00003d60| bf bf bf bf bf bf bf bf | bf bf bf bf bf bf bf bf |........|........|
|00003d70| bf bf bf bf bf bf bf bf | bf bf bf bf bf bf bf bf |........|........|
|00003d80| bf bf bf bf bf bf bf bf | bf bf bf bf bf bf bf bf |........|........|
|00003d90| bf bf bf bf bf bf bf bf | bf bf bf bf bf 7f 7f 7f |........|........|
|00003da0| 7f 7f 7f 7f 7f 7f 00 00 | ff ff ff bf bf bf bf bf |........|........|
|00003db0| bf bf bf bf bf bf bf bf | bf bf bf bf bf bf bf bf |........|........|
|00003dc0| bf bf bf bf bf bf bf bf | bf bf bf bf bf bf bf bf |........|........|
|00003dd0| bf bf bf bf bf bf bf bf | bf bf bf bf bf bf bf bf |........|........|
|00003de0| bf bf bf bf bf bf bf bf | bf bf bf bf bf bf bf bf |........|........|
|00003df0| bf bf bf bf bf bf bf bf | bf bf bf bf 7f 7f 7f 7f |........|........|
|00003e00| 7f 7f 00 00 ff ff ff bf | bf bf bf bf bf bf bf bf |........|........|
|00003e10| bf bf bf bf bf bf bf bf | bf bf bf bf bf bf bf bf |........|........|
|00003e20| bf bf bf bf bf bf bf bf | bf bf bf bf bf bf bf bf |........|........|
|00003e30| bf bf bf bf bf bf bf bf | bf bf bf bf bf bf bf bf |........|........|
|00003e40| bf bf bf bf bf bf bf bf | bf bf bf bf bf bf bf bf |........|........|
|00003e50| bf bf bf bf bf bf bf bf | 7f 7f 7f 7f 7f 7f 00 00 |........|........|
|00003e60| ff ff ff bf bf bf bf bf | bf bf bf bf bf bf bf bf |........|........|
|00003e70| bf bf bf bf bf bf bf bf | bf bf bf bf bf bf bf bf |........|........|
|00003e80| bf bf bf bf bf bf bf bf | bf bf bf bf bf bf bf bf |........|........|
|00003e90| bf bf bf bf bf bf bf bf | bf bf bf bf bf bf bf bf |........|........|
|00003ea0| bf bf bf bf bf bf bf bf | bf bf bf bf bf bf bf bf |........|........|
|00003eb0| bf bf bf bf 7f 7f 7f 7f | 7f 7f 00 00 ff ff ff bf |........|........|
|00003ec0| bf bf bf bf bf bf bf bf | bf bf bf bf bf bf bf bf |........|........|
|00003ed0| bf bf bf bf bf bf bf bf | bf bf bf bf bf bf bf bf |........|........|
|00003ee0| bf bf bf bf bf bf bf bf | bf bf bf bf bf bf bf bf |........|........|
|00003ef0| bf bf bf bf bf bf bf bf | bf bf bf bf bf bf bf bf |........|........|
|00003f00| bf bf bf bf bf bf bf bf | bf bf bf bf bf bf bf bf |........|........|
|00003f10| 7f 7f 7f 7f 7f 7f 00 00 | ff ff ff bf bf bf bf bf |........|........|
|00003f20| bf bf bf bf bf bf bf bf | bf bf bf bf bf bf bf bf |........|........|
|00003f30| bf bf bf bf bf bf bf bf | bf bf bf bf bf bf bf bf |........|........|
|00003f40| bf bf bf bf bf bf bf bf | bf bf bf bf bf bf bf bf |........|........|
|00003f50| bf bf bf bf bf bf bf bf | bf bf bf bf bf bf bf bf |........|........|
|00003f60| bf bf bf bf bf bf bf bf | bf bf bf bf 7f 7f 7f 7f |........|........|
|00003f70| 7f 7f 00 00 ff ff ff bf | bf bf bf bf bf bf bf bf |........|........|
|00003f80| bf bf bf bf bf bf bf bf | bf bf bf bf bf bf bf bf |........|........|
|00003f90| bf bf bf bf bf bf bf bf | bf bf bf bf bf bf bf bf |........|........|
|00003fa0| bf bf bf bf bf bf bf bf | bf bf bf bf bf bf bf bf |........|........|
|00003fb0| bf bf bf bf bf bf bf bf | bf bf bf bf bf bf bf bf |........|........|
|00003fc0| bf bf bf bf bf bf bf bf | 7f 7f 7f 7f 7f 7f 00 00 |........|........|
|00003fd0| ff ff ff bf bf bf bf bf | bf bf bf bf bf bf bf bf |........|........|
|00003fe0| bf bf bf bf bf bf bf bf | bf bf bf bf bf bf bf bf |........|........|
|00003ff0| bf bf bf bf bf bf bf bf | bf bf bf bf bf bf bf bf |........|........|
|00004000| bf bf bf bf bf bf bf bf | bf bf bf bf bf bf bf bf |........|........|
|00004010| bf bf bf bf bf bf bf bf | bf bf bf bf bf bf bf bf |........|........|
|00004020| bf bf bf bf 7f 7f 7f 7f | 7f 7f 00 00 ff ff ff bf |........|........|
|00004030| bf bf bf bf bf bf bf bf | bf bf bf bf bf bf bf bf |........|........|
|00004040| bf bf bf bf bf bf bf bf | bf bf bf bf bf bf bf bf |........|........|
|00004050| bf bf bf bf bf bf bf bf | bf bf bf bf bf bf bf bf |........|........|
|00004060| bf bf bf bf bf bf bf bf | bf bf bf bf bf bf bf bf |........|........|
|00004070| bf bf bf bf bf bf bf bf | bf bf bf bf bf bf bf bf |........|........|
|00004080| 7f 7f 7f 7f 7f 7f 00 00 | ff ff ff bf bf bf bf bf |........|........|
|00004090| bf bf bf bf bf bf bf bf | bf bf bf bf bf bf bf bf |........|........|
|000040a0| bf bf bf bf bf bf bf bf | bf bf bf bf bf bf bf bf |........|........|
|000040b0| bf bf bf bf bf bf bf bf | bf bf bf bf bf bf bf bf |........|........|
|000040c0| bf bf bf bf bf bf bf bf | bf bf bf bf bf bf bf bf |........|........|
|000040d0| bf bf bf bf bf bf bf bf | bf bf bf bf 7f 7f 7f 7f |........|........|
|000040e0| 7f 7f 00 00 ff ff ff bf | bf bf bf bf bf bf bf bf |........|........|
|000040f0| bf bf bf bf bf bf bf bf | bf bf bf bf bf bf bf bf |........|........|
|00004100| bf bf bf bf bf bf bf bf | bf bf bf bf bf bf bf bf |........|........|
|00004110| bf bf bf bf bf bf bf bf | bf bf bf bf bf bf bf bf |........|........|
|00004120| bf bf bf bf bf bf bf bf | bf bf bf bf bf bf bf bf |........|........|
|00004130| bf bf bf bf bf bf bf bf | 7f 7f 7f 7f 7f 7f 00 00 |........|........|
|00004140| ff ff ff bf bf bf bf bf | bf bf bf bf bf bf bf bf |........|........|
|00004150| bf bf bf bf bf bf bf bf | bf bf bf bf bf bf bf bf |........|........|
|00004160| bf bf bf bf bf bf bf bf | bf bf bf bf bf bf bf bf |........|........|
|00004170| bf bf bf bf bf bf bf bf | bf bf bf bf bf bf bf bf |........|........|
|00004180| bf bf bf bf bf bf bf bf | bf bf bf bf bf bf bf bf |........|........|
|00004190| bf bf bf bf 7f 7f 7f 7f | 7f 7f 00 00 ff ff ff bf |........|........|
|000041a0| bf bf bf bf bf bf bf bf | bf bf bf bf bf bf bf bf |........|........|
|000041b0| bf bf bf bf bf bf bf bf | bf bf bf bf bf bf bf bf |........|........|
|000041c0| bf bf bf bf bf bf bf bf | bf bf bf bf bf bf bf bf |........|........|
|000041d0| bf bf bf bf bf bf bf bf | bf bf bf bf bf bf bf bf |........|........|
|000041e0| bf bf bf bf bf bf bf bf | bf bf bf bf bf bf bf bf |........|........|
|000041f0| 7f 7f 7f 7f 7f 7f 00 00 | ff ff ff bf bf bf bf bf |........|........|
|00004200| bf bf bf bf bf bf bf bf | bf bf bf bf bf bf bf bf |........|........|
|00004210| bf bf bf bf bf bf bf bf | bf bf bf bf bf bf bf bf |........|........|
|00004220| bf bf bf bf bf bf bf bf | bf bf bf bf bf bf bf bf |........|........|
|00004230| bf bf bf bf bf bf bf bf | bf bf bf bf bf bf bf bf |........|........|
|00004240| bf bf bf bf bf bf bf bf | bf bf bf bf 7f 7f 7f 7f |........|........|
|00004250| 7f 7f 00 00 ff ff ff bf | bf bf bf bf bf bf bf bf |........|........|
|00004260| bf bf bf bf bf bf bf bf | bf bf bf bf bf bf bf bf |........|........|
|00004270| bf bf bf bf bf bf bf bf | bf bf bf bf bf bf bf bf |........|........|
|00004280| bf bf bf bf bf bf bf bf | bf bf bf bf bf bf bf bf |........|........|
|00004290| bf bf bf bf bf bf bf bf | bf bf bf bf bf bf bf bf |........|........|
|000042a0| bf bf bf bf bf bf bf bf | 7f 7f 7f 7f 7f 7f 00 00 |........|........|
|000042b0| ff ff ff bf bf bf bf bf | bf bf bf bf bf bf bf bf |........|........|
|000042c0| bf bf bf bf bf bf bf bf | bf bf bf bf bf bf bf bf |........|........|
|000042d0| bf bf bf bf bf bf bf bf | bf bf bf bf bf bf bf bf |........|........|
|000042e0| bf bf bf bf bf bf bf bf | bf bf bf bf bf bf bf bf |........|........|
|000042f0| bf bf bf bf bf bf bf bf | bf bf bf bf bf bf bf bf |........|........|
|00004300| bf bf bf bf 7f 7f 7f 7f | 7f 7f 00 00 ff ff ff bf |........|........|
|00004310| bf bf bf bf bf bf bf bf | bf bf bf bf bf bf bf bf |........|........|
|00004320| bf bf bf bf bf bf bf bf | bf bf bf bf bf bf bf bf |........|........|
|00004330| bf bf bf bf bf bf bf bf | bf bf bf bf bf bf bf bf |........|........|
|00004340| bf bf bf bf bf bf bf bf | bf bf bf bf bf bf bf bf |........|........|
|00004350| bf bf bf bf bf bf bf bf | bf bf bf bf bf bf bf bf |........|........|
|00004360| 7f 7f 7f 7f 7f 7f 00 00 | ff ff ff bf bf bf bf bf |........|........|
|00004370| bf bf bf bf bf bf bf bf | bf bf bf bf bf bf bf bf |........|........|
|00004380| bf bf bf bf bf bf bf bf | bf bf bf bf bf bf bf bf |........|........|
|00004390| bf bf bf bf bf bf bf bf | bf bf bf bf bf bf bf bf |........|........|
|000043a0| bf bf bf bf bf bf bf bf | bf bf bf bf bf bf bf bf |........|........|
|000043b0| bf bf bf bf bf bf bf bf | bf bf bf bf 7f 7f 7f 7f |........|........|
|000043c0| 7f 7f 00 00 ff ff ff bf | bf bf bf bf bf bf bf bf |........|........|
|000043d0| bf bf bf bf bf bf bf bf | bf bf bf bf bf bf bf bf |........|........|
|000043e0| bf bf bf bf bf bf bf bf | bf bf bf bf bf bf bf bf |........|........|
|000043f0| bf bf bf bf bf bf bf bf | bf bf bf bf bf bf bf bf |........|........|
|00004400| bf bf bf bf bf bf bf bf | bf bf bf bf bf bf bf bf |........|........|
|00004410| bf bf bf bf bf bf bf bf | 7f 7f 7f 7f 7f 7f 00 00 |........|........|
|00004420| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00004430| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00004440| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00004450| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00004460| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00004470| ff ff ff ff 7f 7f 7f 7f | 7f 7f 00 00 ff ff ff 7f |........|........|
|00004480| 7f 7f 7f 7f 7f 7f 7f 7f | 7f 7f 7f 7f 7f 7f 7f 7f |........|........|
|00004490| 7f 7f 7f 7f 7f 7f 7f 7f | 7f 7f 7f 7f 7f 7f 7f 7f |........|........|
|000044a0| 7f 7f 7f 7f 7f 7f 7f 7f | 7f 7f 7f 7f 7f 7f 7f 7f |........|........|
|000044b0| 7f 7f 7f 7f 7f 7f 7f 7f | 7f 7f 7f 7f 7f 7f 7f 7f |........|........|
|000044c0| 7f 7f 7f 7f 7f 7f 7f 7f | 7f 7f 7f 7f 7f 7f 7f 7f |........|........|
|000044d0| 7f 7f 7f 7f 7f 7f 00 00 | ff ff ff ff ff 00 ff ff |........|........|
|000044e0| 00 ff ff 00 ff ff 00 ff | ff 00 ff ff 00 ff ff 00 |........|........|
|000044f0| ff ff 00 ff ff 00 ff ff | 00 ff ff 00 ff ff 00 ff |........|........|
|00004500| ff 00 ff ff 00 ff ff 00 | ff ff 00 ff ff 00 ff ff |........|........|
|00004510| 00 ff ff 00 ff ff 00 ff | ff 00 ff ff 00 ff ff 00 |........|........|
|00004520| ff ff 00 ff ff 00 ff ff | 00 ff ff 00 7f 7f 7f 7f |........|........|
|00004530| 7f 7f 00 00 ff ff ff ff | ff 00 ff ff 00 ff ff 00 |........|........|
|00004540| ff ff 00 ff ff 00 ff ff | 00 ff ff 00 ff ff 00 ff |........|........|
|00004550| ff 00 ff ff 00 ff ff 00 | ff ff 00 ff ff 00 ff ff |........|........|
|00004560| 00 ff ff 00 ff ff 00 ff | ff 00 ff ff 00 ff ff 00 |........|........|
|00004570| ff ff 00 ff ff 00 ff ff | 00 ff ff 00 ff ff 00 ff |........|........|
|00004580| ff 00 ff ff 00 ff ff 00 | 7f 7f 7f 7f 7f 7f 00 00 |........|........|
|00004590| ff ff ff ff ff 00 ff ff | 00 ff ff 00 ff ff 00 ff |........|........|
|000045a0| ff 00 ff ff 00 ff ff 00 | ff ff 00 ff ff 00 ff ff |........|........|
|000045b0| 00 ff ff 00 ff ff 00 ff | ff 00 ff ff 00 ff ff 00 |........|........|
|000045c0| ff ff 00 ff ff 00 ff ff | 00 ff ff 00 ff ff 00 ff |........|........|
|000045d0| ff 00 ff ff 00 ff ff 00 | ff ff 00 ff ff 00 ff ff |........|........|
|000045e0| 00 ff ff 00 7f 7f 7f 7f | 7f 7f 00 00 ff ff ff ff |........|........|
|000045f0| ff 00 ff ff 00 ff ff 00 | ff ff 00 ff ff 00 ff ff |........|........|
|00004600| 00 ff ff 00 ff ff 00 ff | ff 00 ff ff 00 ff ff 00 |........|........|
|00004610| ff ff 00 ff ff 00 ff ff | 00 ff ff 00 ff ff 00 ff |........|........|
|00004620| ff 00 ff ff 00 ff ff 00 | ff ff 00 ff ff 00 ff ff |........|........|
|00004630| 00 ff ff 00 ff ff 00 ff | ff 00 ff ff 00 ff ff 00 |........|........|
|00004640| 7f 7f 7f 7f 7f 7f 00 00 | ff ff ff ff ff 00 ff ff |........|........|
|00004650| 00 ff ff 00 ff ff 00 ff | ff 00 ff ff 00 ff ff 00 |........|........|
|00004660| ff ff 00 ff ff 00 ff ff | 00 ff ff 00 ff ff 00 ff |........|........|
|00004670| ff 00 ff ff 00 ff ff 00 | ff ff 00 ff ff 00 ff ff |........|........|
|00004680| 00 ff ff 00 ff ff 00 ff | ff 00 ff ff 00 ff ff 00 |........|........|
|00004690| ff ff 00 ff ff 00 ff ff | 00 7f 7f 7f 7f 7f 7f 7f |........|........|
|000046a0| 7f 7f 00 00 bf bf bf ff | ff ff ff ff 00 ff ff 00 |........|........|
|000046b0| ff ff 00 ff ff 00 ff ff | 00 ff ff 00 ff ff 00 ff |........|........|
|000046c0| ff 00 ff ff 00 ff ff 00 | ff ff 00 ff ff 00 ff ff |........|........|
|000046d0| 00 ff ff 00 ff ff 00 ff | ff 00 ff ff 00 ff ff 00 |........|........|
|000046e0| ff ff 00 ff ff 00 ff ff | 00 ff ff 00 ff ff 00 ff |........|........|
|000046f0| ff 00 ff ff 00 7f 7f 7f | 7f 7f 7f bf bf bf 00 00 |........|........|
|00004700| bf bf bf bf bf bf ff ff | ff ff ff ff ff ff ff ff |........|........|
|00004710| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00004720| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00004730| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00004740| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00004750| ff ff ff ff bf bf bf bf | bf bf 00 00 41 00 00 00 |........|....A...|
|00004760| 00 00 00 00 07 00 00 00 | 19 00 44 65 66 61 75 6c |........|..Defaul|
|00004770| 74 20 45 6e 74 69 74 79 | 20 53 6d 61 6c 6c 20 49 |t Entity| Small I|
|00004780| 63 6f 6e 68 03 00 00 28 | 00 00 00 11 00 00 00 10 |conh...(|........|
|00004790| 00 00 00 01 00 18 00 00 | 00 00 00 40 03 00 00 00 |........|...@....|
|000047a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 ff |........|........|
|000047b0| ff ff 7f 7f 7f 7f 7f 7f | 7f 7f 7f 7f 7f 7f 7f 7f |........|........|
|000047c0| 7f 7f 7f 7f 7f 7f 7f 7f | 7f 7f 7f 7f 7f 7f 7f 7f |........|........|
|000047d0| 7f 7f 7f 7f 7f 7f 7f 7f | 7f 7f 7f 7f ff ff ff ff |........|........|
|000047e0| ff ff 00 ff ff ff 7f 7f | 7f 7f 7f 7f 7f 7f 7f 7f |........|........|
|000047f0| 7f 7f 7f 7f 7f 7f 7f 7f | 7f 7f 7f 7f 7f 7f 7f 7f |........|........|
|00004800| 7f 7f 7f 7f 7f 7f 7f 7f | 7f 7f 7f 7f 7f 7f 7f 7f |........|........|
|00004810| 7f 7f 7f fe ff ff 00 bf | bf bf bf bf bf bf bf bf |........|........|
|00004820| bf bf bf bf bf bf bf bf | bf bf bf bf bf bf bf bf |........|........|
|00004830| bf bf bf bf bf bf bf bf | bf bf bf bf bf bf bf bf |........|........|
|00004840| bf 7f 7f 7f 7f 7f 7f fe | fe 7f 00 bf bf bf bf bf |........|........|
|00004850| bf bf bf bf bf bf bf bf | bf bf bf bf bf bf bf bf |........|........|
|00004860| bf bf bf bf bf bf bf bf | bf bf bf bf bf bf bf bf |........|........|
|00004870| bf bf bf bf bf bf bf bf | 7f 7f 7f fe fe 7f 00 bf |........|........|
|00004880| bf bf bf bf bf bf bf bf | bf bf bf bf bf bf bf bf |........|........|
|00004890| bf bf bf bf bf bf bf bf | bf bf bf bf bf bf bf bf |........|........|
|000048a0| bf bf bf bf bf bf bf bf | bf bf bf bf 7f 7f 7f fe |........|........|
|000048b0| fe 7f 00 bf bf bf bf bf | bf bf bf bf bf bf bf bf |........|........|
|000048c0| bf bf bf bf bf bf bf bf | bf bf bf bf bf bf bf bf |........|........|
|000048d0| bf bf bf bf bf bf bf bf | bf bf bf bf bf bf bf bf |........|........|
|000048e0| 7f 7f 7f fe fe 7f 00 bf | bf bf bf bf bf bf bf bf |........|........|
|000048f0| bf bf bf bf bf bf bf bf | bf bf bf bf bf bf bf bf |........|........|
|00004900| bf bf bf bf bf bf bf bf | bf bf bf bf bf bf bf bf |........|........|
|00004910| bf bf bf bf 7f 7f 7f fe | fe 7f 00 bf bf bf bf bf |........|........|
|00004920| bf bf bf bf bf bf bf bf | bf bf bf bf bf bf bf bf |........|........|
|00004930| bf bf bf bf bf bf bf bf | bf bf bf bf bf bf bf bf |........|........|
|00004940| bf bf bf bf bf bf bf bf | 7f 7f 7f fe fe 7f 00 bf |........|........|
|00004950| bf bf bf bf bf bf bf bf | bf bf bf bf bf bf bf bf |........|........|
|00004960| bf bf bf bf bf bf bf bf | bf bf bf bf bf bf bf bf |........|........|
|00004970| bf bf bf bf bf bf bf bf | bf bf bf bf 7f 7f 7f fe |........|........|
|00004980| fe 7f 00 bf bf bf bf bf | bf bf bf bf bf bf bf bf |........|........|
|00004990| bf bf bf bf bf bf bf bf | bf bf bf bf bf bf bf bf |........|........|
|000049a0| bf bf bf bf bf bf bf bf | bf bf bf bf bf bf bf bf |........|........|
|000049b0| 7f 7f 7f fe fe 7f 00 bf | bf bf bf bf bf bf bf bf |........|........|
|000049c0| bf bf bf bf bf bf bf bf | bf bf bf bf bf bf bf bf |........|........|
|000049d0| bf bf bf bf bf bf bf bf | bf bf bf bf bf bf bf bf |........|........|
|000049e0| bf bf bf bf 7f 7f 7f fe | fe 7f 00 7f 7f 7f 7f 7f |........|........|
|000049f0| 7f 7f 7f 7f 7f 7f 7f 7f | 7f 7f 7f 7f 7f 7f 7f 7f |........|........|
|00004a00| 7f 7f 7f 7f 7f 7f 7f 7f | 7f 7f 7f 7f 7f 7f 7f 7f |........|........|
|00004a10| 7f 7f 7f 7f 7f 7f 7f 7f | 7f 7f 7f fe fe 7f 00 ff |........|........|
|00004a20| ff 00 ff ff 00 ff ff 00 | ff ff 00 ff ff 00 ff ff |........|........|
|00004a30| 00 ff ff 00 ff ff 00 ff | ff 00 ff ff 00 ff ff 00 |........|........|
|00004a40| ff ff 00 ff ff 00 ff ff | 00 ff ff 00 7f 7f 7f fe |........|........|
|00004a50| fe 7f 00 ff ff 00 ff ff | 00 ff ff 00 ff ff 00 ff |........|........|
|00004a60| ff 00 ff ff 00 ff ff 00 | ff ff 00 ff ff 00 ff ff |........|........|
|00004a70| 00 ff ff 00 ff ff 00 ff | ff 00 ff ff 00 ff ff 00 |........|........|
|00004a80| 7f 7f 7f fe fe 7f 00 ff | ff 00 ff ff 00 ff ff 00 |........|........|
|00004a90| ff ff 00 ff ff 00 ff ff | 00 ff ff 00 ff ff 00 ff |........|........|
|00004aa0| ff 00 ff ff 00 ff ff 00 | ff ff 00 ff ff 00 ff ff |........|........|
|00004ab0| 00 ff ff 00 7f 7f 7f fe | fe 7f 00 ff ff ff ff ff |........|........|
|00004ac0| 00 ff ff 00 ff ff 00 ff | ff 00 ff ff 00 ff ff 00 |........|........|
|00004ad0| ff ff 00 ff ff 00 ff ff | 00 ff ff 00 ff ff 00 ff |........|........|
|00004ae0| ff 00 ff ff 00 7f 7f 7f | 7f 7f 7f fe ff ff 00 80 |........|........|
|00004af0| 00 00 00 00 00 00 00 07 | 00 00 00 16 00 44 65 66 |........|.....Def|
|00004b00| 61 75 6c 74 20 3c 75 6e | 6b 6e 6f 77 6e 3e 20 49 |ault <un|known> I|
|00004b10| 63 6f 6e 68 02 00 00 28 | 00 00 00 10 00 00 00 0c |conh...(|........|
|00004b20| 00 00 00 01 00 18 00 00 | 00 00 00 40 02 00 00 00 |........|...@....|
|00004b30| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 ff |........|........|
|00004b40| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00004b50| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00004b60| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00004b70| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00004b80| ff ff ff ff ff 00 00 ff | 00 00 ff ff ff ff ff ff |........|........|
|00004b90| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00004ba0| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00004bb0| ff ff ff ff ff 00 00 ff | 00 00 ff ff ff ff ff ff |........|........|
|00004bc0| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00004bd0| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00004be0| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00004bf0| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00004c00| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00004c10| ff ff ff ff ff 00 00 ff | 00 00 ff ff ff ff ff ff |........|........|
|00004c20| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00004c30| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00004c40| ff ff ff ff ff ff ff ff | 00 00 ff 00 00 ff ff ff |........|........|
|00004c50| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00004c60| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00004c70| ff ff ff ff ff ff ff ff | ff ff ff 00 00 ff 00 00 |........|........|
|00004c80| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00004c90| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff 00 |........|........|
|00004ca0| 00 ff 00 00 ff ff ff ff | ff ff ff 00 00 ff 00 00 |........|........|
|00004cb0| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00004cc0| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff 00 |........|........|
|00004cd0| 00 ff 00 00 ff ff ff ff | ff ff ff 00 00 ff 00 00 |........|........|
|00004ce0| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00004cf0| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00004d00| ff ff 00 00 ff 00 00 ff | 00 00 ff 00 00 ff ff ff |........|........|
|00004d10| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00004d20| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00004d30| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00004d40| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00004d50| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00004d60| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00004d70| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff 02 |........|........|
|00004d80| 00 00 00 00 00 00 00 07 | 00 00 00 13 00 44 65 66 |........|.....Def|
|00004d90| 61 75 6c 74 20 53 74 72 | 69 6e 67 20 49 63 6f 6e |ault Str|ing Icon|
|00004da0| 68 03 00 00 28 00 00 00 | 11 00 00 00 10 00 00 00 |h...(...|........|
|00004db0| 01 00 18 00 00 00 00 00 | 40 03 00 00 00 00 00 00 |........|@.......|
|00004dc0| 00 00 00 00 00 00 00 00 | 00 00 00 00 ff ff ff ff |........|........|
|00004dd0| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00004de0| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00004df0| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff 00 |........|........|
|00004e00| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00004e10| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00004e20| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00004e30| ff ff ff 00 ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00004e40| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00004e50| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00004e60| ff ff ff ff ff ff ff 00 | ff ff ff ff ff ff ff ff |........|........|
|00004e70| ff ff ff ff ff ff ff ff | ff ff bf bf bf bf bf bf |........|........|
|00004e80| bf bf bf bf bf bf bf bf | bf ff ff ff ff ff ff ff |........|........|
|00004e90| ff ff ff ff ff ff ff ff | ff ff ff 00 ff ff ff ff |........|........|
|00004ea0| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff bf bf |........|........|
|00004eb0| bf 7f 00 00 7f 00 00 7f | 00 00 bf bf bf bf bf bf |........|........|
|00004ec0| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff 00 |........|........|
|00004ed0| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff bf |........|........|
|00004ee0| bf bf bf bf bf 7f 00 00 | bf bf bf bf bf bf 7f 00 |........|........|
|00004ef0| 00 bf bf bf bf bf bf ff | ff ff ff ff ff ff ff ff |........|........|
|00004f00| ff ff ff 00 ff ff ff 7f | 00 00 bf bf bf bf bf bf |........|........|
|00004f10| bf bf bf 7f 00 00 bf bf | bf 7f 00 00 bf bf bf bf |........|........|
|00004f20| bf bf 7f 00 00 bf bf bf | bf bf bf bf bf bf bf bf |........|........|
|00004f30| bf ff ff ff ff ff ff 00 | ff ff ff 7f 00 00 bf bf |........|........|
|00004f40| bf bf bf bf bf bf bf 7f | 00 00 bf bf bf 7f 00 00 |........|........|
|00004f50| bf bf bf bf bf bf 7f 00 | 00 bf bf bf 7f 00 00 7f |........|........|
|00004f60| 00 00 bf bf bf bf bf bf | ff ff ff 00 ff ff ff 7f |........|........|
|00004f70| 00 00 7f 00 00 7f 00 00 | 7f 00 00 7f 00 00 bf bf |........|........|
|00004f80| bf 7f 00 00 7f 00 00 7f | 00 00 bf bf bf 7f 00 00 |........|........|
|00004f90| bf bf bf bf bf bf 7f 00 | 00 bf bf bf ff ff ff 00 |........|........|
|00004fa0| ff ff ff ff ff ff 7f 00 | 00 bf bf bf 7f 00 00 bf |........|........|
|00004fb0| bf bf bf bf bf 7f 00 00 | bf bf bf bf bf bf bf bf |........|........|
|00004fc0| bf 7f 00 00 bf bf bf bf | bf bf bf bf bf bf bf bf |........|........|
|00004fd0| ff ff ff 00 ff ff ff ff | ff ff 7f 00 00 bf bf bf |........|........|
|00004fe0| 7f 00 00 bf bf bf bf bf | bf 7f 00 00 bf bf bf bf |........|........|
|00004ff0| bf bf bf bf bf 7f 00 00 | bf bf bf bf bf bf 7f 00 |........|........|
|00005000| 00 bf bf bf ff ff ff 00 | ff ff ff ff ff ff 7f 00 |........|........|
|00005010| 00 bf bf bf 7f 00 00 bf | bf bf bf bf bf bf bf bf |........|........|
|00005020| bf bf bf bf bf bf bf bf | bf bf bf bf 7f 00 00 7f |........|........|
|00005030| 00 00 bf bf bf bf bf bf | ff ff ff 00 ff ff ff ff |........|........|
|00005040| ff ff bf bf bf 7f 00 00 | bf bf bf bf bf bf ff ff |........|........|
|00005050| ff ff ff ff ff ff ff ff | ff ff ff ff ff bf bf bf |........|........|
|00005060| bf bf bf bf bf bf bf bf | bf ff ff ff ff ff ff 00 |........|........|
|00005070| ff ff ff ff ff ff bf bf | bf 7f 00 00 bf bf bf ff |........|........|
|00005080| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00005090| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|000050a0| ff ff ff 00 ff ff ff ff | ff ff bf bf bf bf bf bf |........|........|
|000050b0| bf bf bf ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|000050c0| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|000050d0| ff ff ff ff ff ff ff 00 | ff ff ff ff ff ff ff ff |........|........|
|000050e0| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|000050f0| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00005100| ff ff ff ff ff ff ff ff | ff ff ff 00 20 00 00 00 |........|.... ...|
|00005110| 00 00 00 00 07 00 00 00 | 13 00 44 65 66 61 75 6c |........|..Defaul|
|00005120| 74 20 4e 75 6d 62 65 72 | 20 49 63 6f 6e 68 03 00 |t Number| Iconh..|
|00005130| 00 28 00 00 00 11 00 00 | 00 10 00 00 00 01 00 18 |.(......|........|
|00005140| 00 00 00 00 00 40 03 00 | 00 00 00 00 00 00 00 00 |.....@..|........|
|00005150| 00 00 00 00 00 00 00 00 | 00 ff ff ff ff ff ff ff |........|........|
|00005160| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00005170| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00005180| ff ff ff ff ff ff ff ff | ff ff ff ff 00 ff ff ff |........|........|
|00005190| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|000051a0| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|000051b0| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|000051c0| 00 ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|000051d0| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|000051e0| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|000051f0| ff ff ff ff 00 ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00005200| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00005210| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00005220| ff ff ff ff ff ff ff ff | 00 ff ff ff ff ff ff ff |........|........|
|00005230| 00 00 ff 00 00 ff ff ff | ff 00 00 ff 00 00 ff ff |........|........|
|00005240| ff ff ff ff ff 00 00 ff | 00 00 ff ff ff ff 00 00 |........|........|
|00005250| ff 00 00 ff ff ff ff ff | ff ff ff ff 00 ff ff ff |........|........|
|00005260| ff ff ff ff 00 00 ff 00 | 00 ff ff ff ff 00 00 ff |........|........|
|00005270| 00 00 ff ff ff ff ff ff | ff 00 00 ff 00 00 ff ff |........|........|
|00005280| ff ff 00 00 ff 00 00 ff | ff ff ff ff ff ff ff ff |........|........|
|00005290| 00 ff ff ff ff ff ff ff | 00 00 ff 00 00 ff ff ff |........|........|
|000052a0| ff 00 00 ff 00 00 ff ff | ff ff ff ff ff 00 00 ff |........|........|
|000052b0| 00 00 ff ff ff ff 00 00 | ff 00 00 ff ff ff ff ff |........|........|
|000052c0| ff ff ff ff 00 ff ff ff | ff 00 00 ff 00 00 ff 00 |........|........|
|000052d0| 00 ff 00 00 ff 00 00 ff | 00 00 ff 00 00 ff 00 00 |........|........|
|000052e0| ff 00 00 ff 00 00 ff 00 | 00 ff 00 00 ff 00 00 ff |........|........|
|000052f0| 00 00 ff ff ff ff ff ff | 00 ff ff ff ff ff ff ff |........|........|
|00005300| 00 00 ff 00 00 ff ff ff | ff 00 00 ff 00 00 ff ff |........|........|
|00005310| ff ff ff ff ff 00 00 ff | 00 00 ff ff ff ff 00 00 |........|........|
|00005320| ff 00 00 ff ff ff ff ff | ff ff ff ff 00 ff ff ff |........|........|
|00005330| ff 00 00 ff 00 00 ff 00 | 00 ff 00 00 ff 00 00 ff |........|........|
|00005340| 00 00 ff 00 00 ff 00 00 | ff 00 00 ff 00 00 ff 00 |........|........|
|00005350| 00 ff 00 00 ff 00 00 ff | 00 00 ff ff ff ff ff ff |........|........|
|00005360| 00 ff ff ff ff ff ff ff | 00 00 ff 00 00 ff ff ff |........|........|
|00005370| ff 00 00 ff 00 00 ff ff | ff ff ff ff ff 00 00 ff |........|........|
|00005380| 00 00 ff ff ff ff 00 00 | ff 00 00 ff ff ff ff ff |........|........|
|00005390| ff ff ff ff 00 ff ff ff | ff ff ff ff 00 00 ff 00 |........|........|
|000053a0| 00 ff ff ff ff 00 00 ff | 00 00 ff ff ff ff ff ff |........|........|
|000053b0| ff 00 00 ff 00 00 ff ff | ff ff 00 00 ff 00 00 ff |........|........|
|000053c0| ff ff ff ff ff ff ff ff | 00 ff ff ff ff ff ff ff |........|........|
|000053d0| 00 00 ff 00 00 ff ff ff | ff 00 00 ff 00 00 ff ff |........|........|
|000053e0| ff ff ff ff ff 00 00 ff | 00 00 ff ff ff ff 00 00 |........|........|
|000053f0| ff 00 00 ff ff ff ff ff | ff ff ff ff 00 ff ff ff |........|........|
|00005400| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00005410| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00005420| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00005430| 00 ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00005440| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00005450| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00005460| ff ff ff ff 00 ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00005470| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00005480| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00005490| ff ff ff ff ff ff ff ff | 00 10 00 00 00 00 00 00 |........|........|
|000054a0| 00 07 00 00 00 15 00 44 | 65 66 61 75 6c 74 20 44 |.......D|efault D|
|000054b0| 61 74 65 74 69 6d 65 20 | 49 63 6f 6e f8 02 00 00 |atetime |Icon....|
|000054c0| 28 00 00 00 10 00 00 00 | 0f 00 00 00 01 00 18 00 |(.......|........|
|000054d0| 00 00 00 00 d0 02 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000054e0| 00 00 00 00 00 00 00 00 | ff ff ff ff ff ff ff ff |........|........|
|000054f0| ff ff ff ff ff ff ff 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005500| 00 00 00 00 00 00 00 00 | 00 ff ff ff ff ff ff ff |........|........|
|00005510| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00005520| ff 00 00 7f 00 00 7f 00 | 00 ff 00 00 ff 00 00 ff |........|........|
|00005530| 00 00 ff 00 00 ff 00 00 | ff 00 00 00 ff ff ff ff |........|........|
|00005540| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00005550| ff 00 00 ff 00 00 ff 00 | 00 ff 00 00 7f 00 00 7f |........|........|
|00005560| 00 00 7f 00 00 7f 00 00 | ff 00 00 ff 00 00 00 ff |........|........|
|00005570| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff 00 00 |........|........|
|00005580| 7f 00 00 ff 00 00 7f 00 | 00 7f ff ff ff ff ff ff |........|........|
|00005590| ff ff ff ff ff ff 00 00 | 7f 00 00 ff 00 00 ff 00 |........|........|
|000055a0| 00 00 ff ff ff ff ff ff | ff ff ff 00 00 7f 00 00 |........|........|
|000055b0| ff 00 00 7f ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|000055c0| ff ff ff ff ff ff ff ff | ff ff ff ff 00 00 7f 00 |........|........|
|000055d0| 00 ff 00 00 00 ff ff ff | 00 00 7f 00 00 ff 00 00 |........|........|
|000055e0| ff ff ff ff ff ff ff 00 | 00 00 ff ff ff ff ff ff |........|........|
|000055f0| ff ff ff ff ff ff ff ff | ff ff ff ff 00 00 7f 00 |........|........|
|00005600| 00 ff 00 00 ff 00 00 00 | 00 00 7f 00 00 ff ff ff |........|........|
|00005610| ff ff ff ff ff ff ff ff | ff ff 00 00 00 ff ff ff |........|........|
|00005620| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff 00 |........|........|
|00005630| 00 7f 00 00 ff 00 00 00 | 00 00 7f 00 00 ff ff ff |........|........|
|00005640| ff ff ff ff ff ff ff ff | ff ff ff ff ff 7f 00 00 |........|........|
|00005650| 7f 00 00 7f 00 00 7f 00 | 00 ff ff ff ff ff ff 00 |........|........|
|00005660| 00 7f 00 00 ff 00 00 00 | 00 00 7f 00 00 ff ff ff |........|........|
|00005670| ff ff ff ff ff ff ff ff | ff ff ff ff ff 7f 00 00 |........|........|
|00005680| 00 00 00 ff ff ff ff ff | ff ff ff ff ff ff ff 00 |........|........|
|00005690| 00 7f 00 00 ff 00 00 00 | 00 00 7f 00 00 ff ff ff |........|........|
|000056a0| ff ff ff ff ff ff ff ff | ff ff ff ff ff 7f 00 00 |........|........|
|000056b0| ff ff ff 00 00 00 ff ff | ff ff ff ff ff ff ff 00 |........|........|
|000056c0| 00 7f 00 00 ff 00 00 00 | 00 00 7f 00 00 ff 00 00 |........|........|
|000056d0| ff ff ff ff ff ff ff ff | ff ff ff ff ff 7f 00 00 |........|........|
|000056e0| ff ff ff ff ff ff ff ff | ff ff ff ff 00 00 7f 00 |........|........|
|000056f0| 00 ff 00 00 ff 00 00 00 | ff ff ff 00 00 7f 00 00 |........|........|
|00005700| ff 00 00 7f ff ff ff ff | ff ff ff ff ff 7f 00 00 |........|........|
|00005710| ff ff ff ff ff ff ff ff | ff ff ff ff 00 00 7f 00 |........|........|
|00005720| 00 ff 00 00 00 ff ff ff | ff ff ff ff ff ff 00 00 |........|........|
|00005730| 7f 00 00 ff 00 00 7f 00 | 00 7f ff ff ff ff ff ff |........|........|
|00005740| ff ff ff ff ff ff 00 00 | 7f 00 00 ff 00 00 ff 00 |........|........|
|00005750| 00 00 ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00005760| ff 00 00 ff 00 00 ff 00 | 00 ff 00 00 7f 00 00 7f |........|........|
|00005770| 00 00 7f 00 00 7f 00 00 | ff 00 00 ff 00 00 00 ff |........|........|
|00005780| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00005790| ff 00 00 7f 00 00 7f 00 | 00 ff 00 00 ff 00 00 ff |........|........|
|000057a0| 00 00 ff 00 00 ff 00 00 | ff 00 00 00 ff ff ff ff |........|........|
|000057b0| ff ff ff ff ff ff ff ff | 08 00 00 00 00 00 00 00 |........|........|
|000057c0| 07 00 00 00 11 00 44 65 | 66 61 75 6c 74 20 42 6c |......De|fault Bl|
|000057d0| 6f 62 20 49 63 6f 6e 68 | 03 00 00 28 00 00 00 11 |ob Iconh|...(....|
|000057e0| 00 00 00 10 00 00 00 01 | 00 18 00 00 00 00 00 40 |........|.......@|
|000057f0| 03 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005800| 00 00 00 ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00005810| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00005820| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00005830| ff ff ff ff ff ff 00 ff | ff ff ff ff ff ff ff ff |........|........|
|00005840| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00005850| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00005860| ff ff ff ff ff ff ff ff | ff ff 00 ff ff ff ff ff |........|........|
|00005870| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00005880| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00005890| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff 00 ff |........|........|
|000058a0| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff 00 00 |........|........|
|000058b0| 00 00 00 00 00 00 00 00 | 00 00 ff ff ff ff ff ff |........|........|
|000058c0| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|000058d0| ff ff 00 ff ff ff ff ff | ff ff ff ff ff ff ff 00 |........|........|
|000058e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000058f0| 00 ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00005900| ff ff ff ff ff ff 00 ff | ff ff ff ff ff ff ff ff |........|........|
|00005910| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005920| 00 00 00 00 00 00 00 00 | ff ff ff ff ff ff ff ff |........|........|
|00005930| ff ff ff ff ff ff ff ff | ff ff 00 ff ff ff ff ff |........|........|
|00005940| ff 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005950| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 ff |........|........|
|00005960| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff 00 ff |........|........|
|00005970| ff ff ff ff ff 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005980| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005990| 00 00 00 ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|000059a0| ff ff 00 ff ff ff ff ff | ff 00 00 00 00 00 00 00 |........|........|
|000059b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000059c0| 00 00 00 00 00 00 00 ff | ff ff ff ff ff ff ff ff |........|........|
|000059d0| ff ff ff ff ff ff 00 ff | ff ff ff ff ff 00 00 00 |........|........|
|000059e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000059f0| 00 00 00 00 00 00 00 00 | 00 00 00 ff ff ff ff ff |........|........|
|00005a00| ff ff ff ff ff ff ff ff | ff ff 00 ff ff ff ff ff |........|........|
|00005a10| ff ff ff ff 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005a20| 00 00 00 00 00 00 00 00 | 00 00 00 00 ff ff ff ff |........|........|
|00005a30| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff 00 ff |........|........|
|00005a40| ff ff ff ff ff ff ff ff | ff ff ff 00 00 00 00 00 |........|........|
|00005a50| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 ff ff ff |........|........|
|00005a60| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00005a70| ff ff 00 ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00005a80| ff ff 00 00 00 00 00 00 | 00 00 00 00 00 00 ff ff |........|........|
|00005a90| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00005aa0| ff ff ff ff ff ff 00 ff | ff ff ff ff ff ff ff ff |........|........|
|00005ab0| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00005ac0| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00005ad0| ff ff ff ff ff ff ff ff | ff ff 00 ff ff ff ff ff |........|........|
|00005ae0| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00005af0| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00005b00| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff 00 ff |........|........|
|00005b10| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00005b20| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00005b30| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00005b40| ff ff 00 04 00 00 00 00 | 00 00 00 0f 00 00 00 01 |........|........|
|00005b50| 00 00 00 00 00 00 00 00 | 01 00 00 00 00 00 00 00 |........|........|
|00005b60| 00 01 00 00 00 00 00 00 | 00 00 01 00 00 00 00 00 |........|........|
|00005b70| 00 00 00 01 00 00 00 00 | 00 00 00 00 02 00 00 00 |........|........|
|00005b80| 00 00 00 00 00 02 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005b90| 00 00 00 00 00 00 00 01 | 00 00 00 00 00 00 00 00 |........|........|
|00005ba0| 01 00 00 00 00 00 00 00 | 00 01 00 00 00 00 00 00 |........|........|
|00005bb0| 00 00 01 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005bc0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 01 00 00 |........|........|
|00005bd0| 00 00 00 00 00 00 01 00 | 00 00 0f 00 00 00 10 00 |........|........|
|00005be0| 4d 6f 76 69 65 20 52 65 | 6e 74 61 6c 20 50 4f 53 |Movie Re|ntal POS|
|00005bf0| 08 00 4c 57 4d 6f 76 69 | 65 73 0b 00 4c 6f 67 69 |..LWMovi|es..Logi|
|00005c00| 63 20 57 6f 72 6b 73 0a | 00 53 51 4c 20 53 65 72 |c Works.|.SQL Ser|
|00005c10| 76 65 72 00 00 06 00 00 | 00 01 00 00 00 1e 00 00 |ver.....|........|
|00005c20| 00 00 00 00 00 00 00 00 | 00 00 00 02 00 00 00 00 |........|........|
|00005c30| 00 00 00 00 02 00 00 00 | 00 00 00 00 00 02 00 00 |........|........|
|00005c40| 00 00 00 00 00 00 01 00 | 00 00 00 00 00 00 00 02 |........|........|
|00005c50| 00 00 00 06 00 00 00 13 | 00 4d 4f 56 49 45 5f 52 |........|.MOVIE_R|
|00005c60| 45 4e 54 41 4c 5f 52 45 | 43 4f 52 44 00 00 00 00 |ENTAL_RE|CORD....|
|00005c70| 06 00 00 00 01 00 00 00 | 1e 00 00 00 00 01 00 00 |........|........|
|00005c80| 00 1e 00 00 00 00 01 00 | 00 00 1e 00 00 00 00 00 |........|........|
|00005c90| 00 00 00 00 00 00 00 00 | 02 00 00 00 00 00 00 00 |........|........|
|00005ca0| 00 02 00 00 00 00 00 00 | 00 00 01 00 00 00 06 00 |........|........|
|00005cb0| 00 00 11 00 6d 6f 76 69 | 65 5f 63 6f 70 79 5f 6e |....movi|e_copy_n|
|00005cc0| 75 6d 62 65 72 03 00 69 | 6e 74 00 00 00 00 00 00 |umber..i|nt......|
|00005cd0| 00 00 06 00 00 00 0a 00 | 4d 4f 56 49 45 5f 43 4f |........|MOVIE_CO|
|00005ce0| 50 59 00 00 00 00 06 00 | 00 00 01 00 00 00 1e 00 |PY......|........|
|00005cf0| 00 00 00 01 00 00 00 1e | 00 00 00 00 01 00 00 00 |........|........|
|00005d00| 1e 00 00 00 00 00 00 00 | 00 00 00 00 00 00 02 00 |........|........|
|00005d10| 00 00 00 00 00 00 00 02 | 00 00 00 00 00 00 00 00 |........|........|
|00005d20| 01 00 00 00 06 00 00 00 | 11 00 6d 6f 76 69 65 5f |........|..movie_|
|00005d30| 63 6f 70 79 5f 6e 75 6d | 62 65 72 03 00 69 6e 74 |copy_num|ber..int|
|00005d40| 00 00 00 00 00 00 00 00 | 00 00 00 00 14 00 43 3a |........|......C:|
|00005d50| 5c 45 52 57 33 4d 4d 5c | 6d 6f 76 69 65 73 2e 65 |\ERW3MM\|movies.e|
|00005d60| 72 31 00 00 03 00 36 2e | 78 00 00 00 00 00 00 02 |r1....6.|x.......|
|00005d70| 00 00 00 00 00 04 00 00 | 00 02 00 00 00 1e 00 00 |........|........|
|00005d80| 00 00 03 00 00 00 28 00 | 00 00 00 04 00 00 00 00 |......(.|........|
|00005d90| 00 00 00 00 02 00 00 00 | 1e 00 00 00 00 00 00 00 |........|........|
|00005da0| 00 04 00 00 00 02 00 00 | 00 28 00 00 00 00 00 00 |........|.(......|
|00005db0| 00 00 28 00 00 00 00 04 | 00 00 00 00 00 00 00 00 |..(.....|........|
|00005dc0| 02 00 00 00 28 00 00 00 | 00 00 00 00 00 07 00 00 |....(...|........|
|00005dd0| 00 02 00 00 00 28 00 00 | 00 00 02 00 00 00 00 00 |.....(..|........|
|00005de0| 00 00 00 02 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005df0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 04 00 |........|........|
|00005e00| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005e10| 06 00 00 00 07 00 00 00 | ff ff ff ff 02 00 00 00 |........|........|
|00005e20| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005e30| 00 00 10 00 00 00 02 00 | 00 00 02 00 00 00 08 00 |........|........|
|00005e40| 63 68 61 72 28 31 38 29 | 02 00 00 00 05 00 00 00 |char(18)|........|
|00005e50| 00 00 00 00 02 00 00 00 | 01 00 00 00 08 00 25 41 |........|......%A|
|00005e60| 74 74 4e 61 6d 65 02 00 | 00 00 ea 03 00 00 09 00 |ttName..|........|
|00005e70| 25 41 74 74 4e 61 6d 65 | 3a 02 00 00 00 ec 03 00 |%AttName|:.......|
|00005e80| 00 08 00 25 41 74 74 4e | 61 6d 65 02 00 00 00 19 |...%AttN|ame.....|
|00005e90| 00 00 00 07 00 25 41 74 | 74 44 65 66 02 00 00 00 |.....%At|tDef....|
|00005ea0| 1d 00 00 00 0a 00 25 44 | 6f 6d 61 69 6e 44 65 66 |......%D|omainDef|
|00005eb0| 02 00 00 00 1e 00 00 00 | 0b 00 25 44 6f 6d 61 69 |........|..%Domai|
|00005ec0| 6e 4e 61 6d 65 02 00 00 | 00 b8 0b 00 00 0a 00 25 |nName...|.......%|
|00005ed0| 41 74 74 44 6f 6d 61 69 | 6e 02 00 00 00 f6 03 00 |AttDomai|n.......|
|00005ee0| 00 07 00 25 41 74 74 44 | 65 66 02 00 00 00 eb 03 |...%AttD|ef......|
|00005ef0| 00 00 17 00 00 00 02 00 | 00 00 ed 03 00 00 19 00 |........|........|
|00005f00| 00 00 02 00 00 00 ee 03 | 00 00 17 00 00 00 02 00 |........|........|
|00005f10| 00 00 f0 03 00 00 1a 00 | 00 00 02 00 00 00 f4 03 |........|........|
|00005f20| 00 00 6e 00 00 00 02 00 | 00 00 e2 05 00 00 79 00 |..n.....|......y.|
|00005f30| 00 00 07 00 00 00 04 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005f40| 00 00 07 00 00 00 00 00 | 00 00 02 00 00 00 00 00 |........|........|
|00005f50| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005f60| 02 00 00 00 02 00 00 00 | 21 00 00 00 09 00 3c 75 |........|!.....<u|
|00005f70| 6e 6b 6e 6f 77 6e 3e 02 | 00 00 00 1f 00 00 00 02 |nknown>.|........|
|00005f80| 00 08 00 00 00 03 00 00 | 00 00 00 00 00 04 00 00 |........|........|
|00005f90| 00 07 00 00 00 01 00 00 | 00 02 00 00 00 00 00 00 |........|........|
|00005fa0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 03 |........|........|
|00005fb0| 00 00 00 02 00 00 00 21 | 00 00 00 04 00 42 6c 6f |.......!|.....Blo|
|00005fc0| 62 02 00 00 00 1f 00 00 | 00 06 00 02 00 00 00 02 |b.......|........|
|00005fd0| 00 00 00 06 00 62 69 6e | 61 72 79 0c 00 00 00 08 |.....bin|ary.....|
|00005fe0| 00 00 00 00 00 00 00 03 | 00 00 00 07 00 00 00 01 |........|........|
|00005ff0| 00 00 00 02 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00006000| 00 00 00 00 00 00 00 00 | 00 03 00 00 00 02 00 00 |........|........|
|00006010| 00 21 00 00 00 08 00 44 | 61 74 65 74 69 6d 65 02 |.!.....D|atetime.|
|00006020| 00 00 00 1f 00 00 00 05 | 00 02 00 00 00 02 00 00 |........|........|
|00006030| 00 08 00 64 61 74 65 74 | 69 6d 65 0b 00 00 00 07 |...datet|ime.....|
|00006040| 00 00 00 00 00 00 00 03 | 00 00 00 07 00 00 00 01 |........|........|
|00006050| 00 00 00 02 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00006060| 00 00 00 00 00 00 00 00 | 00 03 00 00 00 02 00 00 |........|........|
|00006070| 00 21 00 00 00 06 00 4e | 75 6d 62 65 72 02 00 00 |.!.....N|umber...|
|00006080| 00 1f 00 00 00 04 00 02 | 00 00 00 02 00 00 00 03 |........|........|
|00006090| 00 69 6e 74 0a 00 00 00 | 06 00 00 00 00 00 00 00 |.int....|........|
|000060a0| 03 00 00 00 07 00 00 00 | 01 00 00 00 02 00 00 00 |........|........|
|000060b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000060c0| 00 00 03 00 00 00 02 00 | 00 00 21 00 00 00 06 00 |........|..!.....|
|000060d0| 53 74 72 69 6e 67 02 00 | 00 00 1f 00 00 00 03 00 |String..|........|
|000060e0| 02 00 00 00 02 00 00 00 | 0b 00 76 61 72 63 68 61 |........|..varcha|
|000060f0| 72 28 32 30 29 09 00 00 | 00 05 00 00 00 00 00 00 |r(20)...|........|
|00006100| 00 03 00 00 00 01 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00006110| 00 00 04 00 00 00 01 00 | 00 00 03 00 00 00 01 00 |........|........|
|00006120| 00 00 04 00 00 00 01 00 | 00 00 02 00 00 00 01 00 |........|........|
|00006130| 00 00 1b 00 00 00 01 00 | 00 00 02 00 00 00 01 ae |........|........|
|00006140| 14 00 00 00 00 00 01 00 | 09 00 00 00 00 00 00 00 |........|........|
|00006150| 00 00 b6 00 00 00 02 ae | 0a 00 55 64 70 4b 65 79 |........|..UdpKey|
|00006160| 4c 69 73 74 03 ae 0a 00 | 01 00 00 4b 65 79 20 49 |List....|...Key I|
|00006170| 44 00 03 ae 0c 00 02 00 | 00 4b 65 79 20 4e 61 6d |D.......|.Key Nam|
|00006180| 65 00 03 ae 0d 00 01 00 | 00 4b 65 79 20 46 6c 61 |e.......|.Key Fla|
|00006190| 67 73 00 03 ae 0b 00 02 | 00 00 4b 65 79 20 44 65 |gs......|..Key De|
|000061a0| 66 00 03 ae 0c 00 01 00 | 00 4b 65 79 20 54 79 70 |f.......|.Key Typ|
|000061b0| 65 00 03 ae 0f 00 02 00 | 00 4b 65 79 20 44 65 66 |e.......|.Key Def|
|000061c0| 61 75 6c 74 00 03 ae 0b | 00 01 00 00 4b 65 79 20 |ault....|....Key |
|000061d0| 53 65 71 00 03 ae 0c 00 | 02 00 00 4b 65 79 20 4c |Seq.....|...Key L|
|000061e0| 69 73 74 00 03 ae 0c 00 | 01 00 00 4b 65 79 20 4d |ist.....|...Key M|
|000061f0| 4d 49 64 00 00 00 00 00 | 05 00 00 00 01 00 00 00 |MId.....|........|
|00006200| 28 00 00 00 00 00 00 00 | 00 28 00 00 00 00 01 00 |(.......|.(......|
|00006210| 00 00 00 00 00 00 00 00 | 00 00 00 28 00 00 00 00 |........|...(....|
|00006220| 02 00 00 00 00 00 00 00 | 00 06 00 00 00 05 00 00 |........|........|
|00006230| 00 12 00 52 65 66 72 65 | 73 68 20 4d 4f 56 49 45 |...Refre|sh MOVIE|
|00006240| 20 64 61 74 61 01 00 00 | 00 00 00 00 00 00 00 05 | data...|........|
|00006250| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 05 |........|........|
|00006260| 00 00 00 0f 00 42 61 63 | 6b 75 70 20 61 6c 6c 20 |.....Bac|kup all |
|00006270| 64 61 74 61 03 00 00 00 | 00 00 00 00 00 00 05 00 |data....|........|
|00006280| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 05 00 |........|........|
|00006290| 00 00 13 00 41 72 63 68 | 69 76 65 20 6f 6c 64 20 |....Arch|ive old |
|000062a0| 72 65 63 6f 72 64 73 05 | 00 00 00 24 00 41 72 63 |records.|...$.Arc|
|000062b0| 68 69 76 65 20 72 65 63 | 6f 72 64 73 20 6f 6c 64 |hive rec|ords old|
|000062c0| 65 72 20 74 68 61 6e 20 | 39 30 20 64 61 79 73 2e |er than |90 days.|
|000062d0| 20 00 00 00 00 05 00 00 | 00 00 00 00 00 00 00 00 | .......|........|
|000062e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000062f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00006300| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00006310| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00006320| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00006330| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00006340| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00006350| 00 00 00 00 00 00 00 01 | 04 09 10 00 00 00 00 00 |........|........|
|00006360| 00 0a 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00006370| 00 90 01 00 00 00 00 00 | 00 07 02 01 22 41 72 69 |........|...."Ari|
|00006380| 61 6c 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |al......|........|
|00006390| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 f3 ff ff |........|........|
|000063a0| ff 00 00 00 00 ff ff ff | ff 00 00 00 00 00 00 ff |........|........|
|000063b0| ff 00 00 00 00 00 00 01 | 00 ff ff ff 00 ff ff 00 |........|........|
|000063c0| 00 00 00 ff ff ff ff 00 | 00 00 00 00 00 ff ff 01 |........|........|
|000063d0| 00 00 00 01 00 01 00 ff | ff ff 00 ff ff ff 00 ff |........|........|
|000063e0| ff ff 00 ff ff ff 00 ff | ff ff 00 ff ff ff 00 ff |........|........|
|000063f0| ff ff 00 ff ff ff 00 ff | ff ff 00 ff ff ff 00 ff |........|........|
+--------+-------------------------+-------------------------+--------+--------+