home *** CD-ROM | disk | FTP | other *** search
| AllFusion ERwin data | 1995-01-05 | 201.3 KB |
open in: 
MacOS 8.1
|
Win98
|
DOS
view JSON data
|
view as text
This file was processed as: AllFusion ERwin data
(other/allFusionERwinData).
This format is not currently supported by dexvert.
| Confidence | Program | Detection | Match Type | Support
|
|---|
| 1%
| dexvert
| AllFusion ERwin data (other/allFusionERwinData)
| magic
| Unsupported |
| 100%
| file
| data
| default
| |
| 100%
| TrID
| AllFusion ERwin data
| default
| |
| 100%
| gt2
| Kopftext: 'V1.74 ERwi'
| default (weak)
|
|
hex view+--------+-------------------------+-------------------------+--------+--------+
|00000000| 56 31 2e 37 34 20 45 52 | 77 69 1c 00 0c 00 00 00 |V1.74 ER|wi......|
|00000010| 00 00 90 01 00 00 00 00 | 00 00 00 00 41 72 69 61 |........|....Aria|
|00000020| 6c 00 0a 00 86 02 f6 e6 | 9d 1d 17 01 86 02 61 17 |l.......|......a.|
|00000030| d7 41 32 e7 cf 66 00 00 | 00 00 cf 66 01 00 00 00 |.A2..f..|...f....|
|00000040| 28 00 2c 00 01 00 01 00 | 01 00 01 00 00 00 00 00 |(.,.....|........|
|00000050| 00 00 01 00 00 00 00 00 | 00 00 00 00 00 00 08 00 |........|........|
|00000060| 00 00 03 00 01 00 ad 00 | 5b 1b 01 00 01 00 00 00 |........|[.......|
|00000070| 01 00 04 00 62 6f 6f 6c | 02 00 00 00 07 00 4e 6f |....bool|......No|
|00000080| 74 65 20 49 44 ff ff 00 | 00 00 01 00 09 00 4e 6f |te ID...|......No|
|00000090| 74 65 20 54 65 78 74 ff | ff 00 00 00 00 00 04 00 |te Text.|........|
|000000a0| 01 00 0b 00 44 6f 6d 61 | 69 6e 20 4e 61 6d 65 c8 |....Doma|in Name.|
|000000b0| 00 00 00 00 01 00 0b 00 | 44 6f 6d 61 69 6e 20 52 |........|Domain R|
|000000c0| 75 6c 65 00 00 00 00 00 | 01 00 0a 00 44 6f 6d 61 |ule.....|....Doma|
|000000d0| 69 6e 20 53 65 74 00 00 | 00 00 00 00 00 12 00 44 |in Set..|.......D|
|000000e0| 6f 6d 61 69 6e 20 55 73 | 61 67 65 20 43 6f 75 6e |omain Us|age Coun|
|000000f0| 74 00 00 00 00 00 01 00 | 04 00 09 00 62 6f 6f 6c |t.......|....bool|
|00000100| 5f 72 75 6c 65 14 00 40 | 56 41 4c 55 45 20 49 4e |_rule..@|VALUE IN|
|00000110| 20 28 27 46 27 2c 20 27 | 54 27 29 02 00 01 00 09 | ('F', '|T').....|
|00000120| 00 45 6c 65 6d 20 4e 61 | 6d 65 14 00 00 00 00 01 |.Elem Na|me......|
|00000130| 00 08 00 45 6c 65 6d 20 | 44 65 66 64 00 00 00 00 |...Elem |Defd....|
|00000140| 02 00 02 00 01 00 46 00 | 00 02 00 01 00 54 00 00 |......F.|.....T..|
|00000150| 00 00 02 00 01 00 0c 00 | 44 65 66 61 75 6c 74 20 |........|Default |
|00000160| 4e 61 6d 65 1e 00 00 00 | 00 01 00 0c 00 44 65 66 |Name....|.....Def|
|00000170| 61 75 6c 74 20 52 75 6c | 65 64 00 00 00 00 01 00 |ault Rul|ed......|
|00000180| 02 00 09 00 62 6f 6f 6c | 5f 64 66 6c 74 03 00 27 |....bool|_dflt..'|
|00000190| 46 27 07 00 01 00 06 00 | 44 6f 6d 61 69 6e 12 00 |F'......|Domain..|
|000001a0| 00 00 00 01 00 09 00 44 | 61 74 61 20 54 79 70 65 |.......D|ata Type|
|000001b0| 13 00 00 00 00 00 00 0b | 00 4e 75 6c 6c 20 4f 70 |........|.Null Op|
|000001c0| 74 69 6f 6e 12 00 00 00 | 00 01 00 0a 00 4f 6c 64 |tion....|.....Old|
|000001d0| 20 44 6f 6d 61 69 6e 12 | 00 00 00 00 00 00 06 00 | Domain.|........|
|000001e0| 44 65 6c 65 74 65 12 00 | 00 00 00 02 00 06 00 44 |Delete..|.......D|
|000001f0| 6f 6d 61 69 6e 0e 00 00 | 00 00 02 00 07 00 44 65 |omain...|......De|
|00000200| 66 61 75 6c 74 0e 00 00 | 00 00 05 00 07 00 04 00 |fault...|........|
|00000210| 62 6f 6f 6c 07 00 63 68 | 61 72 28 31 29 00 00 00 |bool..ch|ar(1)...|
|00000220| 00 00 00 00 00 00 00 07 | 00 04 00 63 6f 64 65 07 |........|...code.|
|00000230| 00 63 68 61 72 28 32 29 | 00 00 00 00 00 00 ff ff |.char(2)|........|
|00000240| ff ff 07 00 02 00 69 64 | 03 00 69 6e 74 00 00 00 |......id|..int...|
|00000250| 00 00 00 ff ff ff ff 07 | 00 06 00 72 65 61 73 6f |........|...reaso|
|00000260| 6e 07 00 63 68 61 72 28 | 33 29 01 00 00 00 00 00 |n..char(|3)......|
|00000270| ff ff ff ff 07 00 09 00 | 73 69 74 65 5f 63 6f 64 |........|site_cod|
|00000280| 65 07 00 63 68 61 72 28 | 33 29 00 00 00 00 00 00 |e..char(|3)......|
|00000290| ff ff ff ff 00 00 03 00 | 01 00 0d 00 54 65 6d 70 |........|....Temp|
|000002a0| 6c 61 74 65 20 4e 61 6d | 65 22 00 00 00 00 01 00 |late Nam|e"......|
|000002b0| 0d 00 54 65 6d 70 6c 61 | 74 65 20 43 6f 64 65 00 |..Templa|te Code.|
|000002c0| 00 00 00 00 00 00 0d 00 | 54 65 6d 70 6c 61 74 65 |........|Template|
|000002d0| 20 54 79 70 65 00 00 00 | 00 00 21 00 03 00 16 00 | Type...|..!.....|
|000002e0| 50 41 52 45 4e 54 20 55 | 50 44 41 54 45 20 52 45 |PARENT U|PDATE RE|
|000002f0| 53 54 52 49 43 54 f7 01 | 20 20 2f 2a 20 45 52 77 |STRICT..| /* ERw|
|00000300| 69 6e 20 42 75 69 6c 74 | 69 6e 20 25 44 61 74 65 |in Built|in %Date|
|00000310| 74 69 6d 65 20 2a 2f 0d | 0a 20 20 2f 2a 20 25 50 |time */.|. /* %P|
|00000320| 61 72 65 6e 74 20 25 56 | 65 72 62 50 68 72 61 73 |arent %V|erbPhras|
|00000330| 65 20 25 43 68 69 6c 64 | 20 4f 4e 20 50 41 52 45 |e %Child| ON PARE|
|00000340| 4e 54 20 55 50 44 41 54 | 45 20 52 45 53 54 52 49 |NT UPDAT|E RESTRI|
|00000350| 43 54 20 2a 2f 0d 0a 20 | 20 69 66 0d 0a 20 20 20 |CT */.. | if.. |
|00000360| 20 2f 2a 20 25 25 50 61 | 72 65 6e 74 50 4b 28 22 | /* %%Pa|rentPK("|
|00000370| 20 6f 72 22 2c 75 70 64 | 61 74 65 29 20 2a 2f 0d | or",upd|ate) */.|
|00000380| 0a 20 20 20 20 25 50 61 | 72 65 6e 74 50 4b 28 22 |. %Pa|rentPK("|
|00000390| 20 6f 72 22 2c 75 70 64 | 61 74 65 29 0d 0a 20 20 | or",upd|ate).. |
|000003a0| 62 65 67 69 6e 0d 0a 20 | 20 20 20 69 66 20 65 78 |begin.. | if ex|
|000003b0| 69 73 74 73 20 28 0d 0a | 20 20 20 20 20 20 73 65 |ists (..| se|
|000003c0| 6c 65 63 74 20 2a 20 66 | 72 6f 6d 20 64 65 6c 65 |lect * f|rom dele|
|000003d0| 74 65 64 2c 25 43 68 69 | 6c 64 0d 0a 20 20 20 20 |ted,%Chi|ld.. |
|000003e0| 20 20 77 68 65 72 65 0d | 0a 20 20 20 20 20 20 20 | where.|. |
|000003f0| 20 2f 2a 20 20 25 25 4a | 6f 69 6e 46 4b 50 4b 28 | /* %%J|oinFKPK(|
|00000400| 25 43 68 69 6c 64 2c 64 | 65 6c 65 74 65 64 2c 22 |%Child,d|eleted,"|
|00000410| 20 3d 20 22 2c 22 20 61 | 6e 64 22 29 20 2a 2f 0d | = "," a|nd") */.|
|00000420| 0a 20 20 20 20 20 20 20 | 20 25 4a 6f 69 6e 46 4b |. | %JoinFK|
|00000430| 50 4b 28 25 43 68 69 6c | 64 2c 64 65 6c 65 74 65 |PK(%Chil|d,delete|
|00000440| 64 2c 22 20 3d 20 22 2c | 22 20 61 6e 64 22 29 0d |d," = ",|" and").|
|00000450| 0a 20 20 20 20 29 0d 0a | 20 20 20 20 62 65 67 69 |. )..| begi|
|00000460| 6e 0d 0a 20 20 20 20 20 | 20 73 65 6c 65 63 74 20 |n.. | select |
|00000470| 40 65 72 72 6e 6f 20 20 | 3d 20 33 30 30 30 35 2c |@errno |= 30005,|
|00000480| 0d 0a 20 20 20 20 20 20 | 20 20 20 20 20 20 20 40 |.. | @|
|00000490| 65 72 72 6d 73 67 20 3d | 20 27 43 61 6e 6e 6f 74 |errmsg =| 'Cannot|
|000004a0| 20 55 50 44 41 54 45 20 | 22 25 50 61 72 65 6e 74 | UPDATE |"%Parent|
|000004b0| 22 20 62 65 63 61 75 73 | 65 20 22 25 43 68 69 6c |" becaus|e "%Chil|
|000004c0| 64 22 20 65 78 69 73 74 | 73 2e 27 0d 0a 20 20 20 |d" exist|s.'.. |
|000004d0| 20 20 20 67 6f 74 6f 20 | 65 72 72 6f 72 0d 0a 20 | goto |error.. |
|000004e0| 20 20 20 65 6e 64 0d 0a | 20 20 65 6e 64 0d 0a 10 | end..| end...|
|000004f0| 27 03 00 15 00 50 41 52 | 45 4e 54 20 55 50 44 41 |'....PAR|ENT UPDA|
|00000500| 54 45 20 43 41 53 43 41 | 44 45 ff 02 20 20 2f 2a |TE CASCA|DE.. /*|
|00000510| 20 45 52 77 69 6e 20 42 | 75 69 6c 74 69 6e 20 25 | ERwin B|uiltin %|
|00000520| 44 61 74 65 74 69 6d 65 | 20 2a 2f 0d 0a 20 20 2f |Datetime| */.. /|
|00000530| 2a 20 25 50 61 72 65 6e | 74 20 25 56 65 72 62 50 |* %Paren|t %VerbP|
|00000540| 68 72 61 73 65 20 25 43 | 68 69 6c 64 20 4f 4e 20 |hrase %C|hild ON |
|00000550| 50 41 52 45 4e 54 20 55 | 50 44 41 54 45 20 43 41 |PARENT U|PDATE CA|
|00000560| 53 43 41 44 45 20 2a 2f | 0d 0a 20 20 69 66 0d 0a |SCADE */|.. if..|
|00000570| 20 20 20 20 2f 2a 20 25 | 25 50 61 72 65 6e 74 50 | /* %|%ParentP|
|00000580| 4b 28 22 20 6f 72 22 2c | 75 70 64 61 74 65 29 20 |K(" or",|update) |
|00000590| 2a 2f 0d 0a 20 20 20 20 | 25 50 61 72 65 6e 74 50 |*/.. |%ParentP|
|000005a0| 4b 28 22 20 6f 72 22 2c | 75 70 64 61 74 65 29 0d |K(" or",|update).|
|000005b0| 0a 20 20 62 65 67 69 6e | 0d 0a 20 20 20 20 69 66 |. begin|.. if|
|000005c0| 20 40 6e 75 6d 72 6f 77 | 73 20 3d 20 31 0d 0a 20 | @numrow|s = 1.. |
|000005d0| 20 20 20 62 65 67 69 6e | 0d 0a 20 20 20 20 20 20 | begin|.. |
|000005e0| 73 65 6c 65 63 74 20 25 | 4a 6f 69 6e 50 4b 50 4b |select %|JoinPKPK|
|000005f0| 28 40 69 6e 73 2c 69 6e | 73 65 72 74 65 64 2c 22 |(@ins,in|serted,"|
|00000600| 20 3d 20 22 2c 22 2c 20 | 22 29 0d 0a 20 20 20 20 | = ",", |").. |
|00000610| 20 20 20 20 66 72 6f 6d | 20 69 6e 73 65 72 74 65 | from| inserte|
|00000620| 64 0d 0a 20 20 20 20 20 | 20 75 70 64 61 74 65 20 |d.. | update |
|00000630| 25 43 68 69 6c 64 0d 0a | 20 20 20 20 20 20 73 65 |%Child..| se|
|00000640| 74 0d 0a 20 20 20 20 20 | 20 20 20 2f 2a 20 20 25 |t.. | /* %|
|00000650| 25 4a 6f 69 6e 46 4b 50 | 4b 28 25 43 68 69 6c 64 |%JoinFKP|K(%Child|
|00000660| 2c 40 69 6e 73 2c 22 20 | 3d 20 22 2c 22 2c 22 29 |,@ins," |= ",",")|
|00000670| 20 2a 2f 0d 0a 20 20 20 | 20 20 20 20 20 25 4a 6f | */.. | %Jo|
|00000680| 69 6e 46 4b 50 4b 28 25 | 43 68 69 6c 64 2c 40 69 |inFKPK(%|Child,@i|
|00000690| 6e 73 2c 22 20 3d 20 22 | 2c 22 2c 22 29 0d 0a 20 |ns," = "|,",").. |
|000006a0| 20 20 20 20 20 66 72 6f | 6d 20 25 43 68 69 6c 64 | fro|m %Child|
|000006b0| 2c 69 6e 73 65 72 74 65 | 64 2c 64 65 6c 65 74 65 |,inserte|d,delete|
|000006c0| 64 0d 0a 20 20 20 20 20 | 20 77 68 65 72 65 0d 0a |d.. | where..|
|000006d0| 20 20 20 20 20 20 20 20 | 2f 2a 20 20 25 25 4a 6f | |/* %%Jo|
|000006e0| 69 6e 46 4b 50 4b 28 25 | 43 68 69 6c 64 2c 64 65 |inFKPK(%|Child,de|
|000006f0| 6c 65 74 65 64 2c 22 20 | 3d 20 22 2c 22 20 61 6e |leted," |= "," an|
|00000700| 64 22 29 20 2a 2f 0d 0a | 20 20 20 20 20 20 20 20 |d") */..| |
|00000710| 25 4a 6f 69 6e 46 4b 50 | 4b 28 25 43 68 69 6c 64 |%JoinFKP|K(%Child|
|00000720| 2c 64 65 6c 65 74 65 64 | 2c 22 20 3d 20 22 2c 22 |,deleted|," = ","|
|00000730| 20 61 6e 64 22 29 0d 0a | 20 20 20 20 65 6e 64 0d | and")..| end.|
|00000740| 0a 20 20 20 20 65 6c 73 | 65 0d 0a 20 20 20 20 62 |. els|e.. b|
|00000750| 65 67 69 6e 0d 0a 20 20 | 20 20 20 20 73 65 6c 65 |egin.. | sele|
|00000760| 63 74 20 40 65 72 72 6e | 6f 20 3d 20 33 30 30 30 |ct @errn|o = 3000|
|00000770| 36 2c 0d 0a 20 20 20 20 | 20 20 20 20 20 20 20 20 |6,.. | |
|00000780| 20 40 65 72 72 6d 73 67 | 20 3d 20 27 43 61 6e 6e | @errmsg| = 'Cann|
|00000790| 6f 74 20 63 61 73 63 61 | 64 65 20 22 25 50 61 72 |ot casca|de "%Par|
|000007a0| 65 6e 74 22 20 55 50 44 | 41 54 45 20 62 65 63 61 |ent" UPD|ATE beca|
|000007b0| 75 73 65 20 6d 6f 72 65 | 20 74 68 61 6e 20 6f 6e |use more| than on|
|000007c0| 65 20 72 6f 77 20 68 61 | 73 20 62 65 65 6e 20 61 |e row ha|s been a|
|000007d0| 66 66 65 63 74 65 64 2e | 27 0d 0a 20 20 20 20 20 |ffected.|'.. |
|000007e0| 20 72 61 69 73 65 72 72 | 6f 72 20 40 65 72 72 6e | raiserr|or @errn|
|000007f0| 6f 20 40 65 72 72 6d 73 | 67 0d 0a 20 20 20 20 65 |o @errms|g.. e|
|00000800| 6e 64 0d 0a 20 20 65 6e | 64 0d 0a 11 27 03 00 16 |nd.. en|d...'...|
|00000810| 00 50 41 52 45 4e 54 20 | 55 50 44 41 54 45 20 53 |.PARENT |UPDATE S|
|00000820| 45 54 20 4e 55 4c 4c a4 | 01 20 20 2f 2a 20 45 52 |ET NULL.|. /* ER|
|00000830| 77 69 6e 20 42 75 69 6c | 74 69 6e 20 25 44 61 74 |win Buil|tin %Dat|
|00000840| 65 74 69 6d 65 20 2a 2f | 0d 0a 20 20 2f 2a 20 25 |etime */|.. /* %|
|00000850| 50 61 72 65 6e 74 20 25 | 56 65 72 62 50 68 72 61 |Parent %|VerbPhra|
|00000860| 73 65 20 25 43 68 69 6c | 64 20 4f 4e 20 50 41 52 |se %Chil|d ON PAR|
|00000870| 45 4e 54 20 55 50 44 41 | 54 45 20 53 45 54 20 4e |ENT UPDA|TE SET N|
|00000880| 55 4c 4c 20 2a 2f 0d 0a | 20 20 69 66 0d 0a 20 20 |ULL */..| if.. |
|00000890| 20 20 2f 2a 20 25 25 50 | 61 72 65 6e 74 50 4b 28 | /* %%P|arentPK(|
|000008a0| 22 20 6f 72 22 2c 75 70 | 64 61 74 65 29 20 2a 2f |" or",up|date) */|
|000008b0| 0d 0a 20 20 20 20 25 50 | 61 72 65 6e 74 50 4b 28 |.. %P|arentPK(|
|000008c0| 22 20 6f 72 22 2c 75 70 | 64 61 74 65 29 0d 0a 20 |" or",up|date).. |
|000008d0| 20 62 65 67 69 6e 0d 0a | 20 20 20 20 75 70 64 61 | begin..| upda|
|000008e0| 74 65 20 25 43 68 69 6c | 64 0d 0a 20 20 20 20 20 |te %Chil|d.. |
|000008f0| 20 73 65 74 0d 0a 20 20 | 20 20 20 20 20 20 2f 2a | set.. | /*|
|00000900| 20 25 25 53 65 74 46 4b | 28 25 43 68 69 6c 64 2c | %%SetFK|(%Child,|
|00000910| 4e 55 4c 4c 29 20 2a 2f | 0d 0a 20 20 20 20 20 20 |NULL) */|.. |
|00000920| 20 20 25 53 65 74 46 4b | 28 25 43 68 69 6c 64 2c | %SetFK|(%Child,|
|00000930| 4e 55 4c 4c 29 0d 0a 20 | 20 20 20 20 20 66 72 6f |NULL).. | fro|
|00000940| 6d 20 25 43 68 69 6c 64 | 2c 64 65 6c 65 74 65 64 |m %Child|,deleted|
|00000950| 0d 0a 20 20 20 20 20 20 | 77 68 65 72 65 0d 0a 20 |.. |where.. |
|00000960| 20 20 20 20 20 20 20 2f | 2a 20 25 25 4a 6f 69 6e | /|* %%Join|
|00000970| 46 4b 50 4b 28 25 43 68 | 69 6c 64 2c 64 65 6c 65 |FKPK(%Ch|ild,dele|
|00000980| 74 65 64 2c 22 20 3d 20 | 22 2c 22 20 61 6e 64 22 |ted," = |"," and"|
|00000990| 29 20 2a 2f 0d 0a 20 20 | 20 20 20 20 20 20 25 4a |) */.. | %J|
|000009a0| 6f 69 6e 46 4b 50 4b 28 | 25 43 68 69 6c 64 2c 64 |oinFKPK(|%Child,d|
|000009b0| 65 6c 65 74 65 64 2c 22 | 20 3d 20 22 2c 22 20 61 |eleted,"| = "," a|
|000009c0| 6e 64 22 29 0d 0a 20 20 | 65 6e 64 0d 0a 12 27 03 |nd").. |end...'.|
|000009d0| 00 16 00 50 41 52 45 4e | 54 20 44 45 4c 45 54 45 |...PAREN|T DELETE|
|000009e0| 20 52 45 53 54 52 49 43 | 54 a4 01 20 20 20 20 2f | RESTRIC|T.. /|
|000009f0| 2a 20 45 52 77 69 6e 20 | 42 75 69 6c 74 69 6e 20 |* ERwin |Builtin |
|00000a00| 25 44 61 74 65 74 69 6d | 65 20 2a 2f 0d 0a 20 20 |%Datetim|e */.. |
|00000a10| 20 20 2f 2a 20 25 50 61 | 72 65 6e 74 20 25 56 65 | /* %Pa|rent %Ve|
|00000a20| 72 62 50 68 72 61 73 65 | 20 25 43 68 69 6c 64 20 |rbPhrase| %Child |
|00000a30| 4f 4e 20 50 41 52 45 4e | 54 20 44 45 4c 45 54 45 |ON PAREN|T DELETE|
|00000a40| 20 52 45 53 54 52 49 43 | 54 20 2a 2f 0d 0a 20 20 | RESTRIC|T */.. |
|00000a50| 20 20 69 66 20 65 78 69 | 73 74 73 20 28 0d 0a 20 | if exi|sts (.. |
|00000a60| 20 20 20 20 20 73 65 6c | 65 63 74 20 2a 20 66 72 | sel|ect * fr|
|00000a70| 6f 6d 20 64 65 6c 65 74 | 65 64 2c 25 43 68 69 6c |om delet|ed,%Chil|
|00000a80| 64 0d 0a 20 20 20 20 20 | 20 77 68 65 72 65 0d 0a |d.. | where..|
|00000a90| 20 20 20 20 20 20 20 20 | 2f 2a 20 20 25 25 4a 6f | |/* %%Jo|
|00000aa0| 69 6e 46 4b 50 4b 28 25 | 43 68 69 6c 64 2c 64 65 |inFKPK(%|Child,de|
|00000ab0| 6c 65 74 65 64 2c 22 20 | 3d 20 22 2c 22 20 61 6e |leted," |= "," an|
|00000ac0| 64 22 29 20 2a 2f 0d 0a | 20 20 20 20 20 20 20 20 |d") */..| |
|00000ad0| 25 4a 6f 69 6e 46 4b 50 | 4b 28 25 43 68 69 6c 64 |%JoinFKP|K(%Child|
|00000ae0| 2c 64 65 6c 65 74 65 64 | 2c 22 20 3d 20 22 2c 22 |,deleted|," = ","|
|00000af0| 20 61 6e 64 22 29 0d 0a | 20 20 20 20 29 0d 0a 20 | and")..| ).. |
|00000b00| 20 20 20 62 65 67 69 6e | 0d 0a 20 20 20 20 20 20 | begin|.. |
|00000b10| 73 65 6c 65 63 74 20 40 | 65 72 72 6e 6f 20 20 3d |select @|errno =|
|00000b20| 20 33 30 30 30 31 2c 0d | 0a 20 20 20 20 20 20 20 | 30001,.|. |
|00000b30| 20 20 20 20 20 20 40 65 | 72 72 6d 73 67 20 3d 20 | @e|rrmsg = |
|00000b40| 27 43 61 6e 6e 6f 74 20 | 44 45 4c 45 54 45 20 22 |'Cannot |DELETE "|
|00000b50| 25 50 61 72 65 6e 74 22 | 20 62 65 63 61 75 73 65 |%Parent"| because|
|00000b60| 20 22 25 43 68 69 6c 64 | 22 20 65 78 69 73 74 73 | "%Child|" exists|
|00000b70| 2e 27 0d 0a 20 20 20 20 | 20 20 67 6f 74 6f 20 65 |.'.. | goto e|
|00000b80| 72 72 6f 72 0d 0a 20 20 | 20 20 65 6e 64 0d 0a 14 |rror.. | end...|
|00000b90| 27 03 00 15 00 50 41 52 | 45 4e 54 20 44 45 4c 45 |'....PAR|ENT DELE|
|00000ba0| 54 45 20 43 41 53 43 41 | 44 45 05 01 20 20 20 20 |TE CASCA|DE.. |
|00000bb0| 2f 2a 20 45 52 77 69 6e | 20 42 75 69 6c 74 69 6e |/* ERwin| Builtin|
|00000bc0| 20 25 44 61 74 65 74 69 | 6d 65 20 2a 2f 0d 0a 20 | %Dateti|me */.. |
|00000bd0| 20 20 20 2f 2a 20 25 50 | 61 72 65 6e 74 20 25 56 | /* %P|arent %V|
|00000be0| 65 72 62 50 68 72 61 73 | 65 20 25 43 68 69 6c 64 |erbPhras|e %Child|
|00000bf0| 20 4f 4e 20 50 41 52 45 | 4e 54 20 44 45 4c 45 54 | ON PARE|NT DELET|
|00000c00| 45 20 43 41 53 43 41 44 | 45 20 2a 2f 0d 0a 20 20 |E CASCAD|E */.. |
|00000c10| 20 20 64 65 6c 65 74 65 | 20 25 43 68 69 6c 64 0d | delete| %Child.|
|00000c20| 0a 20 20 20 20 20 20 66 | 72 6f 6d 20 25 43 68 69 |. f|rom %Chi|
|00000c30| 6c 64 2c 64 65 6c 65 74 | 65 64 0d 0a 20 20 20 20 |ld,delet|ed.. |
|00000c40| 20 20 77 68 65 72 65 0d | 0a 20 20 20 20 20 20 20 | where.|. |
|00000c50| 20 2f 2a 20 20 25 25 4a | 6f 69 6e 46 4b 50 4b 28 | /* %%J|oinFKPK(|
|00000c60| 25 43 68 69 6c 64 2c 64 | 65 6c 65 74 65 64 2c 22 |%Child,d|eleted,"|
|00000c70| 20 3d 20 22 2c 22 20 61 | 6e 64 22 29 20 2a 2f 0d | = "," a|nd") */.|
|00000c80| 0a 20 20 20 20 20 20 20 | 20 25 4a 6f 69 6e 46 4b |. | %JoinFK|
|00000c90| 50 4b 28 25 43 68 69 6c | 64 2c 64 65 6c 65 74 65 |PK(%Chil|d,delete|
|00000ca0| 64 2c 22 20 3d 20 22 2c | 22 20 61 6e 64 22 29 0d |d," = ",|" and").|
|00000cb0| 0a 15 27 03 00 16 00 50 | 41 52 45 4e 54 20 44 45 |..'....P|ARENT DE|
|00000cc0| 4c 45 54 45 20 53 45 54 | 20 4e 55 4c 4c 51 01 20 |LETE SET| NULLQ. |
|00000cd0| 20 20 20 2f 2a 20 45 52 | 77 69 6e 20 42 75 69 6c | /* ER|win Buil|
|00000ce0| 74 69 6e 20 25 44 61 74 | 65 74 69 6d 65 20 2a 2f |tin %Dat|etime */|
|00000cf0| 0d 0a 20 20 20 20 2f 2a | 20 25 50 61 72 65 6e 74 |.. /*| %Parent|
|00000d00| 20 25 56 65 72 62 50 68 | 72 61 73 65 20 25 43 68 | %VerbPh|rase %Ch|
|00000d10| 69 6c 64 20 4f 4e 20 50 | 41 52 45 4e 54 20 44 45 |ild ON P|ARENT DE|
|00000d20| 4c 45 54 45 20 53 45 54 | 20 4e 55 4c 4c 20 2a 2f |LETE SET| NULL */|
|00000d30| 0d 0a 20 20 20 20 75 70 | 64 61 74 65 20 25 43 68 |.. up|date %Ch|
|00000d40| 69 6c 64 0d 0a 20 20 20 | 20 20 20 73 65 74 0d 0a |ild.. | set..|
|00000d50| 20 20 20 20 20 20 20 20 | 2f 2a 20 25 25 53 65 74 | |/* %%Set|
|00000d60| 46 4b 28 25 43 68 69 6c | 64 2c 4e 55 4c 4c 29 20 |FK(%Chil|d,NULL) |
|00000d70| 2a 2f 0d 0a 20 20 20 20 | 20 20 20 20 25 53 65 74 |*/.. | %Set|
|00000d80| 46 4b 28 25 43 68 69 6c | 64 2c 4e 55 4c 4c 29 0d |FK(%Chil|d,NULL).|
|00000d90| 0a 20 20 20 20 20 20 66 | 72 6f 6d 20 25 43 68 69 |. f|rom %Chi|
|00000da0| 6c 64 2c 64 65 6c 65 74 | 65 64 0d 0a 20 20 20 20 |ld,delet|ed.. |
|00000db0| 20 20 77 68 65 72 65 0d | 0a 20 20 20 20 20 20 20 | where.|. |
|00000dc0| 20 2f 2a 20 25 25 4a 6f | 69 6e 46 4b 50 4b 28 25 | /* %%Jo|inFKPK(%|
|00000dd0| 43 68 69 6c 64 2c 64 65 | 6c 65 74 65 64 2c 22 20 |Child,de|leted," |
|00000de0| 3d 20 22 2c 22 20 61 6e | 64 22 29 20 2a 2f 0d 0a |= "," an|d") */..|
|00000df0| 20 20 20 20 20 20 20 20 | 25 4a 6f 69 6e 46 4b 50 | |%JoinFKP|
|00000e00| 4b 28 25 43 68 69 6c 64 | 2c 64 65 6c 65 74 65 64 |K(%Child|,deleted|
|00000e10| 2c 22 20 3d 20 22 2c 22 | 20 61 6e 64 22 29 0d 0a |," = ","| and")..|
|00000e20| 16 27 03 00 15 00 43 48 | 49 4c 44 20 49 4e 53 45 |.'....CH|ILD INSE|
|00000e30| 52 54 20 52 45 53 54 52 | 49 43 54 ee 02 20 20 2f |RT RESTR|ICT.. /|
|00000e40| 2a 20 45 52 77 69 6e 20 | 42 75 69 6c 74 69 6e 20 |* ERwin |Builtin |
|00000e50| 25 44 61 74 65 74 69 6d | 65 20 2a 2f 0d 0a 20 20 |%Datetim|e */.. |
|00000e60| 2f 2a 20 25 50 61 72 65 | 6e 74 20 25 56 65 72 62 |/* %Pare|nt %Verb|
|00000e70| 50 68 72 61 73 65 20 25 | 43 68 69 6c 64 20 4f 4e |Phrase %|Child ON|
|00000e80| 20 43 48 49 4c 44 20 49 | 4e 53 45 52 54 20 52 45 | CHILD I|NSERT RE|
|00000e90| 53 54 52 49 43 54 20 2a | 2f 0d 0a 20 20 69 66 0d |STRICT *|/.. if.|
|00000ea0| 0a 20 20 20 20 2f 2a 20 | 25 25 43 68 69 6c 64 46 |. /* |%%ChildF|
|00000eb0| 4b 28 22 20 6f 72 22 2c | 75 70 64 61 74 65 29 20 |K(" or",|update) |
|00000ec0| 2a 2f 0d 0a 20 20 20 20 | 25 43 68 69 6c 64 46 4b |*/.. |%ChildFK|
|00000ed0| 28 22 20 6f 72 22 2c 75 | 70 64 61 74 65 29 0d 0a |(" or",u|pdate)..|
|00000ee0| 20 20 62 65 67 69 6e 0d | 0a 20 20 20 20 73 65 6c | begin.|. sel|
|00000ef0| 65 63 74 20 40 6e 75 6c | 6c 63 6e 74 20 3d 20 30 |ect @nul|lcnt = 0|
|00000f00| 0d 0a 20 20 20 20 73 65 | 6c 65 63 74 20 40 76 61 |.. se|lect @va|
|00000f10| 6c 69 64 63 6e 74 20 3d | 20 63 6f 75 6e 74 28 2a |lidcnt =| count(*|
|00000f20| 29 0d 0a 20 20 20 20 20 | 20 66 72 6f 6d 20 69 6e |).. | from in|
|00000f30| 73 65 72 74 65 64 2c 25 | 50 61 72 65 6e 74 0d 0a |serted,%|Parent..|
|00000f40| 20 20 20 20 20 20 20 20 | 77 68 65 72 65 0d 0a 20 | |where.. |
|00000f50| 20 20 20 20 20 20 20 20 | 20 2f 2a 20 25 25 4a 6f | | /* %%Jo|
|00000f60| 69 6e 46 4b 50 4b 28 69 | 6e 73 65 72 74 65 64 2c |inFKPK(i|nserted,|
|00000f70| 25 50 61 72 65 6e 74 29 | 20 2a 2f 0d 0a 20 20 20 |%Parent)| */.. |
|00000f80| 20 20 20 20 20 20 20 25 | 4a 6f 69 6e 46 4b 50 4b | %|JoinFKPK|
|00000f90| 28 69 6e 73 65 72 74 65 | 64 2c 25 50 61 72 65 6e |(inserte|d,%Paren|
|00000fa0| 74 29 0d 0a 20 20 20 20 | 2f 2a 20 25 25 4e 6f 74 |t).. |/* %%Not|
|00000fb0| 6e 75 6c 6c 46 4b 28 69 | 6e 73 65 72 74 65 64 2c |nullFK(i|nserted,|
|00000fc0| 22 20 69 73 20 6e 75 6c | 6c 22 2c 22 73 65 6c 65 |" is nul|l","sele|
|00000fd0| 63 74 20 40 6e 75 6c 6c | 63 6e 74 20 3d 20 63 6f |ct @null|cnt = co|
|00000fe0| 75 6e 74 28 2a 29 20 66 | 72 6f 6d 20 69 6e 73 65 |unt(*) f|rom inse|
|00000ff0| 72 74 65 64 20 77 68 65 | 72 65 22 2c 22 20 6f 72 |rted whe|re"," or|
|00001000| 22 29 20 2a 2f 0d 0a 20 | 20 20 20 25 4e 6f 74 6e |") */.. | %Notn|
|00001010| 75 6c 6c 46 4b 28 69 6e | 73 65 72 74 65 64 2c 22 |ullFK(in|serted,"|
|00001020| 20 69 73 20 6e 75 6c 6c | 22 2c 22 73 65 6c 65 63 | is null|","selec|
|00001030| 74 20 40 6e 75 6c 6c 63 | 6e 74 20 3d 20 63 6f 75 |t @nullc|nt = cou|
|00001040| 6e 74 28 2a 29 20 66 72 | 6f 6d 20 69 6e 73 65 72 |nt(*) fr|om inser|
|00001050| 74 65 64 20 77 68 65 72 | 65 22 2c 22 20 6f 72 22 |ted wher|e"," or"|
|00001060| 29 0d 0a 20 20 20 20 69 | 66 20 40 76 61 6c 69 64 |).. i|f @valid|
|00001070| 63 6e 74 20 2b 20 40 6e | 75 6c 6c 63 6e 74 20 21 |cnt + @n|ullcnt !|
|00001080| 3d 20 40 6e 75 6d 72 6f | 77 73 0d 0a 20 20 20 20 |= @numro|ws.. |
|00001090| 62 65 67 69 6e 0d 0a 20 | 20 20 20 20 20 73 65 6c |begin.. | sel|
|000010a0| 65 63 74 20 40 65 72 72 | 6e 6f 20 20 3d 20 33 30 |ect @err|no = 30|
|000010b0| 30 30 32 2c 0d 0a 20 20 | 20 20 20 20 20 20 20 20 |002,.. | |
|000010c0| 20 20 20 40 65 72 72 6d | 73 67 20 3d 20 27 43 61 | @errm|sg = 'Ca|
|000010d0| 6e 6e 6f 74 20 49 4e 53 | 45 52 54 20 22 25 43 68 |nnot INS|ERT "%Ch|
|000010e0| 69 6c 64 22 20 62 65 63 | 61 75 73 65 20 22 25 50 |ild" bec|ause "%P|
|000010f0| 61 72 65 6e 74 22 20 64 | 6f 65 73 20 6e 6f 74 20 |arent" d|oes not |
|00001100| 65 78 69 73 74 2e 27 0d | 0a 20 20 20 20 20 20 67 |exist.'.|. g|
|00001110| 6f 74 6f 20 65 72 72 6f | 72 0d 0a 20 20 20 20 65 |oto erro|r.. e|
|00001120| 6e 64 0d 0a 20 20 65 6e | 64 0d 0a 18 27 03 00 14 |nd.. en|d...'...|
|00001130| 00 43 48 49 4c 44 20 49 | 4e 53 45 52 54 20 43 41 |.CHILD I|NSERT CA|
|00001140| 53 43 41 44 45 48 02 20 | 20 2f 2a 20 45 52 77 69 |SCADEH. | /* ERwi|
|00001150| 6e 20 42 75 69 6c 74 69 | 6e 20 25 44 61 74 65 74 |n Builti|n %Datet|
|00001160| 69 6d 65 20 2a 2f 0d 0a | 20 20 2f 2a 20 25 50 61 |ime */..| /* %Pa|
|00001170| 72 65 6e 74 20 25 56 65 | 72 62 50 68 72 61 73 65 |rent %Ve|rbPhrase|
|00001180| 20 25 43 68 69 6c 64 20 | 4f 4e 20 43 48 49 4c 44 | %Child |ON CHILD|
|00001190| 20 49 4e 53 45 52 54 20 | 43 41 53 43 41 44 45 20 | INSERT |CASCADE |
|000011a0| 2a 2f 0d 0a 20 20 69 66 | 0d 0a 20 20 20 20 2f 2a |*/.. if|.. /*|
|000011b0| 20 25 25 43 68 69 6c 64 | 46 4b 28 22 20 6f 72 22 | %%Child|FK(" or"|
|000011c0| 2c 75 70 64 61 74 65 29 | 20 2a 2f 0d 0a 20 20 20 |,update)| */.. |
|000011d0| 20 25 43 68 69 6c 64 46 | 4b 28 22 20 6f 72 22 2c | %ChildF|K(" or",|
|000011e0| 75 70 64 61 74 65 29 0d | 0a 20 20 62 65 67 69 6e |update).|. begin|
|000011f0| 0d 0a 20 20 20 20 69 6e | 73 65 72 74 20 25 50 61 |.. in|sert %Pa|
|00001200| 72 65 6e 74 20 28 25 50 | 61 72 65 6e 74 50 4b 28 |rent (%P|arentPK(|
|00001210| 22 2c 22 2c 29 29 0d 0a | 20 20 20 20 20 20 73 65 |",",))..| se|
|00001220| 6c 65 63 74 20 25 43 68 | 69 6c 64 46 4b 28 22 2c |lect %Ch|ildFK(",|
|00001230| 22 2c 29 0d 0a 20 20 20 | 20 20 20 66 72 6f 6d 20 |",).. | from |
|00001240| 20 20 69 6e 73 65 72 74 | 65 64 0d 0a 20 20 20 20 | insert|ed.. |
|00001250| 20 20 77 68 65 72 65 0d | 0a 20 20 20 20 20 20 20 | where.|. |
|00001260| 20 2f 2a 20 25 25 4e 6f | 74 6e 75 6c 6c 46 4b 28 | /* %%No|tnullFK(|
|00001270| 69 6e 73 65 72 74 65 64 | 2c 22 20 69 73 20 6e 6f |inserted|," is no|
|00001280| 74 20 6e 75 6c 6c 20 61 | 6e 64 22 29 20 2a 2f 0d |t null a|nd") */.|
|00001290| 0a 20 20 20 20 20 20 20 | 20 25 4e 6f 74 6e 75 6c |. | %Notnul|
|000012a0| 6c 46 4b 28 69 6e 73 65 | 72 74 65 64 2c 22 20 69 |lFK(inse|rted," i|
|000012b0| 73 20 6e 6f 74 20 6e 75 | 6c 6c 20 61 6e 64 22 29 |s not nu|ll and")|
|000012c0| 0d 0a 20 20 20 20 20 20 | 20 20 6e 6f 74 20 65 78 |.. | not ex|
|000012d0| 69 73 74 73 20 28 0d 0a | 20 20 20 20 20 20 20 20 |ists (..| |
|000012e0| 20 20 73 65 6c 65 63 74 | 20 2a 20 66 72 6f 6d 20 | select| * from |
|000012f0| 25 50 61 72 65 6e 74 0d | 0a 20 20 20 20 20 20 20 |%Parent.|. |
|00001300| 20 20 20 77 68 65 72 65 | 0d 0a 20 20 20 20 20 20 | where|.. |
|00001310| 20 20 20 20 20 20 2f 2a | 20 25 25 4a 6f 69 6e 46 | /*| %%JoinF|
|00001320| 4b 50 4b 28 69 6e 73 65 | 72 74 65 64 2c 25 50 61 |KPK(inse|rted,%Pa|
|00001330| 72 65 6e 74 2c 22 20 3d | 20 22 2c 22 20 61 6e 64 |rent," =| "," and|
|00001340| 22 29 20 2a 2f 0d 0a 20 | 20 20 20 20 20 20 20 20 |") */.. | |
|00001350| 20 20 20 25 4a 6f 69 6e | 46 4b 50 4b 28 69 6e 73 | %Join|FKPK(ins|
|00001360| 65 72 74 65 64 2c 25 50 | 61 72 65 6e 74 2c 22 20 |erted,%P|arent," |
|00001370| 3d 20 22 2c 22 20 61 6e | 64 22 29 0d 0a 20 20 20 |= "," an|d").. |
|00001380| 20 20 20 20 20 29 0d 0a | 20 20 65 6e 64 0d 0a 19 | )..| end...|
|00001390| 27 03 00 14 00 43 48 49 | 4c 44 20 49 4e 53 45 52 |'....CHI|LD INSER|
|000013a0| 54 20 53 45 54 4e 55 4c | 4c 6e 02 20 20 2f 2a 20 |T SETNUL|Ln. /* |
|000013b0| 45 52 77 69 6e 20 42 75 | 69 6c 74 69 6e 20 25 44 |ERwin Bu|iltin %D|
|000013c0| 61 74 65 74 69 6d 65 20 | 2a 2f 0d 0a 20 20 2f 2a |atetime |*/.. /*|
|000013d0| 20 25 50 61 72 65 6e 74 | 20 25 56 65 72 62 50 68 | %Parent| %VerbPh|
|000013e0| 72 61 73 65 20 25 43 68 | 69 6c 64 20 4f 4e 20 43 |rase %Ch|ild ON C|
|000013f0| 48 49 4c 44 20 49 4e 53 | 45 52 54 20 53 45 54 20 |HILD INS|ERT SET |
|00001400| 4e 55 4c 4c 20 2a 2f 0d | 0a 20 20 69 66 0d 0a 20 |NULL */.|. if.. |
|00001410| 20 20 20 2f 2a 20 25 25 | 43 68 69 6c 64 46 4b 28 | /* %%|ChildFK(|
|00001420| 22 20 6f 72 22 2c 75 70 | 64 61 74 65 29 20 2a 2f |" or",up|date) */|
|00001430| 0d 0a 20 20 20 20 25 43 | 68 69 6c 64 46 4b 28 22 |.. %C|hildFK("|
|00001440| 20 6f 72 22 2c 75 70 64 | 61 74 65 29 0d 0a 20 20 | or",upd|ate).. |
|00001450| 62 65 67 69 6e 0d 0a 20 | 20 20 20 75 70 64 61 74 |begin.. | updat|
|00001460| 65 20 25 43 68 69 6c 64 | 0d 0a 20 20 20 20 20 20 |e %Child|.. |
|00001470| 73 65 74 0d 0a 20 20 20 | 20 20 20 20 20 2f 2a 20 |set.. | /* |
|00001480| 25 25 53 65 74 46 4b 28 | 25 43 68 69 6c 64 2c 4e |%%SetFK(|%Child,N|
|00001490| 55 4c 4c 29 20 2a 2f 0d | 0a 20 20 20 20 20 20 20 |ULL) */.|. |
|000014a0| 20 25 53 65 74 46 4b 28 | 25 43 68 69 6c 64 2c 4e | %SetFK(|%Child,N|
|000014b0| 55 4c 4c 29 0d 0a 20 20 | 20 20 20 20 66 72 6f 6d |ULL).. | from|
|000014c0| 20 25 43 68 69 6c 64 2c | 69 6e 73 65 72 74 65 64 | %Child,|inserted|
|000014d0| 0d 0a 20 20 20 20 20 20 | 77 68 65 72 65 0d 0a 20 |.. |where.. |
|000014e0| 20 20 20 20 20 20 20 2f | 2a 20 25 25 4a 6f 69 6e | /|* %%Join|
|000014f0| 50 4b 50 4b 28 25 43 68 | 69 6c 64 2c 69 6e 73 65 |PKPK(%Ch|ild,inse|
|00001500| 72 74 65 64 2c 22 20 3d | 20 22 2c 22 20 61 6e 64 |rted," =| "," and|
|00001510| 22 29 20 2a 2f 0d 0a 20 | 20 20 20 20 20 20 20 25 |") */.. | %|
|00001520| 4a 6f 69 6e 50 4b 50 4b | 28 25 43 68 69 6c 64 2c |JoinPKPK|(%Child,|
|00001530| 69 6e 73 65 72 74 65 64 | 2c 22 20 3d 20 22 2c 22 |inserted|," = ","|
|00001540| 20 61 6e 64 22 29 20 61 | 6e 64 0d 0a 20 20 20 20 | and") a|nd.. |
|00001550| 20 20 20 20 6e 6f 74 20 | 65 78 69 73 74 73 20 28 | not |exists (|
|00001560| 0d 0a 20 20 20 20 20 20 | 20 20 20 20 73 65 6c 65 |.. | sele|
|00001570| 63 74 20 2a 20 66 72 6f | 6d 20 25 50 61 72 65 6e |ct * fro|m %Paren|
|00001580| 74 0d 0a 20 20 20 20 20 | 20 20 20 20 20 77 68 65 |t.. | whe|
|00001590| 72 65 0d 0a 20 20 20 20 | 20 20 20 20 20 20 20 20 |re.. | |
|000015a0| 2f 2a 20 25 25 4a 6f 69 | 6e 46 4b 50 4b 28 69 6e |/* %%Joi|nFKPK(in|
|000015b0| 73 65 72 74 65 64 2c 25 | 50 61 72 65 6e 74 2c 22 |serted,%|Parent,"|
|000015c0| 20 3d 20 22 2c 22 20 61 | 6e 64 22 29 20 2a 2f 0d | = "," a|nd") */.|
|000015d0| 0a 20 20 20 20 20 20 20 | 20 20 20 20 20 25 4a 6f |. | %Jo|
|000015e0| 69 6e 46 4b 50 4b 28 69 | 6e 73 65 72 74 65 64 2c |inFKPK(i|nserted,|
|000015f0| 25 50 61 72 65 6e 74 2c | 22 20 3d 20 22 2c 22 20 |%Parent,|" = "," |
|00001600| 61 6e 64 22 29 0d 0a 20 | 20 20 20 20 20 20 20 29 |and").. | )|
|00001610| 0d 0a 20 20 65 6e 64 0d | 0a 1a 27 03 00 15 00 43 |.. end.|..'....C|
|00001620| 48 49 4c 44 20 55 50 44 | 41 54 45 20 52 45 53 54 |HILD UPD|ATE REST|
|00001630| 52 49 43 54 ee 02 20 20 | 2f 2a 20 45 52 77 69 6e |RICT.. |/* ERwin|
|00001640| 20 42 75 69 6c 74 69 6e | 20 25 44 61 74 65 74 69 | Builtin| %Dateti|
|00001650| 6d 65 20 2a 2f 0d 0a 20 | 20 2f 2a 20 25 50 61 72 |me */.. | /* %Par|
|00001660| 65 6e 74 20 25 56 65 72 | 62 50 68 72 61 73 65 20 |ent %Ver|bPhrase |
|00001670| 25 43 68 69 6c 64 20 4f | 4e 20 43 48 49 4c 44 20 |%Child O|N CHILD |
|00001680| 55 50 44 41 54 45 20 52 | 45 53 54 52 49 43 54 20 |UPDATE R|ESTRICT |
|00001690| 2a 2f 0d 0a 20 20 69 66 | 0d 0a 20 20 20 20 2f 2a |*/.. if|.. /*|
|000016a0| 20 25 25 43 68 69 6c 64 | 46 4b 28 22 20 6f 72 22 | %%Child|FK(" or"|
|000016b0| 2c 75 70 64 61 74 65 29 | 20 2a 2f 0d 0a 20 20 20 |,update)| */.. |
|000016c0| 20 25 43 68 69 6c 64 46 | 4b 28 22 20 6f 72 22 2c | %ChildF|K(" or",|
|000016d0| 75 70 64 61 74 65 29 0d | 0a 20 20 62 65 67 69 6e |update).|. begin|
|000016e0| 0d 0a 20 20 20 20 73 65 | 6c 65 63 74 20 40 6e 75 |.. se|lect @nu|
|000016f0| 6c 6c 63 6e 74 20 3d 20 | 30 0d 0a 20 20 20 20 73 |llcnt = |0.. s|
|00001700| 65 6c 65 63 74 20 40 76 | 61 6c 69 64 63 6e 74 20 |elect @v|alidcnt |
|00001710| 3d 20 63 6f 75 6e 74 28 | 2a 29 0d 0a 20 20 20 20 |= count(|*).. |
|00001720| 20 20 66 72 6f 6d 20 69 | 6e 73 65 72 74 65 64 2c | from i|nserted,|
|00001730| 25 50 61 72 65 6e 74 0d | 0a 20 20 20 20 20 20 20 |%Parent.|. |
|00001740| 20 77 68 65 72 65 0d 0a | 20 20 20 20 20 20 20 20 | where..| |
|00001750| 20 20 2f 2a 20 25 25 4a | 6f 69 6e 46 4b 50 4b 28 | /* %%J|oinFKPK(|
|00001760| 69 6e 73 65 72 74 65 64 | 2c 25 50 61 72 65 6e 74 |inserted|,%Parent|
|00001770| 29 20 2a 2f 0d 0a 20 20 | 20 20 20 20 20 20 20 20 |) */.. | |
|00001780| 25 4a 6f 69 6e 46 4b 50 | 4b 28 69 6e 73 65 72 74 |%JoinFKP|K(insert|
|00001790| 65 64 2c 25 50 61 72 65 | 6e 74 29 0d 0a 20 20 20 |ed,%Pare|nt).. |
|000017a0| 20 2f 2a 20 25 25 4e 6f | 74 6e 75 6c 6c 46 4b 28 | /* %%No|tnullFK(|
|000017b0| 69 6e 73 65 72 74 65 64 | 2c 22 20 69 73 20 6e 75 |inserted|," is nu|
|000017c0| 6c 6c 22 2c 22 73 65 6c | 65 63 74 20 40 6e 75 6c |ll","sel|ect @nul|
|000017d0| 6c 63 6e 74 20 3d 20 63 | 6f 75 6e 74 28 2a 29 20 |lcnt = c|ount(*) |
|000017e0| 66 72 6f 6d 20 69 6e 73 | 65 72 74 65 64 20 77 68 |from ins|erted wh|
|000017f0| 65 72 65 22 2c 22 20 6f | 72 22 29 20 2a 2f 0d 0a |ere"," o|r") */..|
|00001800| 20 20 20 20 25 4e 6f 74 | 6e 75 6c 6c 46 4b 28 69 | %Not|nullFK(i|
|00001810| 6e 73 65 72 74 65 64 2c | 22 20 69 73 20 6e 75 6c |nserted,|" is nul|
|00001820| 6c 22 2c 22 73 65 6c 65 | 63 74 20 40 6e 75 6c 6c |l","sele|ct @null|
|00001830| 63 6e 74 20 3d 20 63 6f | 75 6e 74 28 2a 29 20 66 |cnt = co|unt(*) f|
|00001840| 72 6f 6d 20 69 6e 73 65 | 72 74 65 64 20 77 68 65 |rom inse|rted whe|
|00001850| 72 65 22 2c 22 20 6f 72 | 22 29 0d 0a 20 20 20 20 |re"," or|").. |
|00001860| 69 66 20 40 76 61 6c 69 | 64 63 6e 74 20 2b 20 40 |if @vali|dcnt + @|
|00001870| 6e 75 6c 6c 63 6e 74 20 | 21 3d 20 40 6e 75 6d 72 |nullcnt |!= @numr|
|00001880| 6f 77 73 0d 0a 20 20 20 | 20 62 65 67 69 6e 0d 0a |ows.. | begin..|
|00001890| 20 20 20 20 20 20 73 65 | 6c 65 63 74 20 40 65 72 | se|lect @er|
|000018a0| 72 6e 6f 20 20 3d 20 33 | 30 30 30 37 2c 0d 0a 20 |rno = 3|0007,.. |
|000018b0| 20 20 20 20 20 20 20 20 | 20 20 20 20 40 65 72 72 | | @err|
|000018c0| 6d 73 67 20 3d 20 27 43 | 61 6e 6e 6f 74 20 55 50 |msg = 'C|annot UP|
|000018d0| 44 41 54 45 20 22 25 43 | 68 69 6c 64 22 20 62 65 |DATE "%C|hild" be|
|000018e0| 63 61 75 73 65 20 22 25 | 50 61 72 65 6e 74 22 20 |cause "%|Parent" |
|000018f0| 64 6f 65 73 20 6e 6f 74 | 20 65 78 69 73 74 2e 27 |does not| exist.'|
|00001900| 0d 0a 20 20 20 20 20 20 | 67 6f 74 6f 20 65 72 72 |.. |goto err|
|00001910| 6f 72 0d 0a 20 20 20 20 | 65 6e 64 0d 0a 20 20 65 |or.. |end.. e|
|00001920| 6e 64 0d 0a 1c 27 03 00 | 14 00 43 48 49 4c 44 20 |nd...'..|..CHILD |
|00001930| 55 50 44 41 54 45 20 43 | 41 53 43 41 44 45 48 02 |UPDATE C|ASCADEH.|
|00001940| 20 20 2f 2a 20 45 52 77 | 69 6e 20 42 75 69 6c 74 | /* ERw|in Built|
|00001950| 69 6e 20 25 44 61 74 65 | 74 69 6d 65 20 2a 2f 0d |in %Date|time */.|
|00001960| 0a 20 20 2f 2a 20 25 50 | 61 72 65 6e 74 20 25 56 |. /* %P|arent %V|
|00001970| 65 72 62 50 68 72 61 73 | 65 20 25 43 68 69 6c 64 |erbPhras|e %Child|
|00001980| 20 4f 4e 20 43 48 49 4c | 44 20 55 50 44 41 54 45 | ON CHIL|D UPDATE|
|00001990| 20 43 41 53 43 41 44 45 | 20 2a 2f 0d 0a 20 20 69 | CASCADE| */.. i|
|000019a0| 66 0d 0a 20 20 20 20 2f | 2a 20 25 25 43 68 69 6c |f.. /|* %%Chil|
|000019b0| 64 46 4b 28 22 20 6f 72 | 22 2c 75 70 64 61 74 65 |dFK(" or|",update|
|000019c0| 29 20 2a 2f 0d 0a 20 20 | 20 20 25 43 68 69 6c 64 |) */.. | %Child|
|000019d0| 46 4b 28 22 20 6f 72 22 | 2c 75 70 64 61 74 65 29 |FK(" or"|,update)|
|000019e0| 0d 0a 20 20 62 65 67 69 | 6e 0d 0a 20 20 20 20 69 |.. begi|n.. i|
|000019f0| 6e 73 65 72 74 20 25 50 | 61 72 65 6e 74 20 28 25 |nsert %P|arent (%|
|00001a00| 50 61 72 65 6e 74 50 4b | 28 22 2c 22 2c 29 29 0d |ParentPK|(",",)).|
|00001a10| 0a 20 20 20 20 20 20 73 | 65 6c 65 63 74 20 25 43 |. s|elect %C|
|00001a20| 68 69 6c 64 46 4b 28 22 | 2c 22 2c 29 0d 0a 20 20 |hildFK("|,",).. |
|00001a30| 20 20 20 20 66 72 6f 6d | 20 20 20 69 6e 73 65 72 | from| inser|
|00001a40| 74 65 64 0d 0a 20 20 20 | 20 20 20 77 68 65 72 65 |ted.. | where|
|00001a50| 0d 0a 20 20 20 20 20 20 | 20 20 2f 2a 20 25 25 4e |.. | /* %%N|
|00001a60| 6f 74 6e 75 6c 6c 46 4b | 28 69 6e 73 65 72 74 65 |otnullFK|(inserte|
|00001a70| 64 2c 22 20 69 73 20 6e | 6f 74 20 6e 75 6c 6c 20 |d," is n|ot null |
|00001a80| 61 6e 64 22 29 20 2a 2f | 0d 0a 20 20 20 20 20 20 |and") */|.. |
|00001a90| 20 20 25 4e 6f 74 6e 75 | 6c 6c 46 4b 28 69 6e 73 | %Notnu|llFK(ins|
|00001aa0| 65 72 74 65 64 2c 22 20 | 69 73 20 6e 6f 74 20 6e |erted," |is not n|
|00001ab0| 75 6c 6c 20 61 6e 64 22 | 29 0d 0a 20 20 20 20 20 |ull and"|).. |
|00001ac0| 20 20 20 6e 6f 74 20 65 | 78 69 73 74 73 20 28 0d | not e|xists (.|
|00001ad0| 0a 20 20 20 20 20 20 20 | 20 20 20 73 65 6c 65 63 |. | selec|
|00001ae0| 74 20 2a 20 66 72 6f 6d | 20 25 50 61 72 65 6e 74 |t * from| %Parent|
|00001af0| 0d 0a 20 20 20 20 20 20 | 20 20 20 20 77 68 65 72 |.. | wher|
|00001b00| 65 0d 0a 20 20 20 20 20 | 20 20 20 20 20 20 20 2f |e.. | /|
|00001b10| 2a 20 25 25 4a 6f 69 6e | 46 4b 50 4b 28 69 6e 73 |* %%Join|FKPK(ins|
|00001b20| 65 72 74 65 64 2c 25 50 | 61 72 65 6e 74 2c 22 20 |erted,%P|arent," |
|00001b30| 3d 20 22 2c 22 20 61 6e | 64 22 29 20 2a 2f 0d 0a |= "," an|d") */..|
|00001b40| 20 20 20 20 20 20 20 20 | 20 20 20 20 25 4a 6f 69 | | %Joi|
|00001b50| 6e 46 4b 50 4b 28 69 6e | 73 65 72 74 65 64 2c 25 |nFKPK(in|serted,%|
|00001b60| 50 61 72 65 6e 74 2c 22 | 20 3d 20 22 2c 22 20 61 |Parent,"| = "," a|
|00001b70| 6e 64 22 29 0d 0a 20 20 | 20 20 20 20 20 20 29 0d |nd").. | ).|
|00001b80| 0a 20 20 65 6e 64 0d 0a | 1d 27 03 00 14 00 43 48 |. end..|.'....CH|
|00001b90| 49 4c 44 20 55 50 44 41 | 54 45 20 53 45 54 4e 55 |ILD UPDA|TE SETNU|
|00001ba0| 4c 4c 6f 02 20 20 2f 2a | 20 45 52 77 69 6e 20 42 |LLo. /*| ERwin B|
|00001bb0| 75 69 6c 74 69 6e 20 25 | 44 61 74 65 74 69 6d 65 |uiltin %|Datetime|
|00001bc0| 20 2a 2f 0d 0a 20 20 2f | 2a 20 25 50 61 72 65 6e | */.. /|* %Paren|
|00001bd0| 74 20 25 56 65 72 62 50 | 68 72 61 73 65 20 25 43 |t %VerbP|hrase %C|
|00001be0| 68 69 6c 64 20 4f 4e 20 | 43 48 49 4c 44 20 55 50 |hild ON |CHILD UP|
|00001bf0| 44 41 54 45 20 53 45 54 | 20 4e 55 4c 4c 20 2a 2f |DATE SET| NULL */|
|00001c00| 0d 0a 20 20 69 66 0d 0a | 20 20 20 20 2f 2a 20 25 |.. if..| /* %|
|00001c10| 25 43 68 69 6c 64 46 4b | 28 22 20 6f 72 22 2c 75 |%ChildFK|(" or",u|
|00001c20| 70 64 61 74 65 29 20 2a | 2f 0d 0a 20 20 20 20 25 |pdate) *|/.. %|
|00001c30| 43 68 69 6c 64 46 4b 28 | 22 20 6f 72 22 2c 75 70 |ChildFK(|" or",up|
|00001c40| 64 61 74 65 29 0d 0a 20 | 20 62 65 67 69 6e 0d 0a |date).. | begin..|
|00001c50| 20 20 20 20 75 70 64 61 | 74 65 20 25 43 68 69 6c | upda|te %Chil|
|00001c60| 64 0d 0a 20 20 20 20 20 | 20 73 65 74 0d 0a 20 20 |d.. | set.. |
|00001c70| 20 20 20 20 20 20 2f 2a | 20 25 25 53 65 74 46 4b | /*| %%SetFK|
|00001c80| 28 25 43 68 69 6c 64 2c | 4e 55 4c 4c 29 20 2a 2f |(%Child,|NULL) */|
|00001c90| 0d 0a 20 20 20 20 20 20 | 20 20 25 53 65 74 46 4b |.. | %SetFK|
|00001ca0| 28 25 43 68 69 6c 64 2c | 4e 55 4c 4c 29 0d 0a 20 |(%Child,|NULL).. |
|00001cb0| 20 20 20 20 20 66 72 6f | 6d 20 25 43 68 69 6c 64 | fro|m %Child|
|00001cc0| 2c 69 6e 73 65 72 74 65 | 64 0d 0a 20 20 20 20 20 |,inserte|d.. |
|00001cd0| 20 77 68 65 72 65 0d 0a | 20 20 20 20 20 20 20 20 | where..| |
|00001ce0| 2f 2a 20 25 25 4a 6f 69 | 6e 50 4b 50 4b 28 25 43 |/* %%Joi|nPKPK(%C|
|00001cf0| 68 69 6c 64 2c 69 6e 73 | 65 72 74 65 64 2c 22 20 |hild,ins|erted," |
|00001d00| 3d 20 22 2c 22 20 61 6e | 64 22 29 20 2a 2f 0d 0a |= "," an|d") */..|
|00001d10| 20 20 20 20 20 20 20 20 | 25 4a 6f 69 6e 50 4b 50 | |%JoinPKP|
|00001d20| 4b 28 25 43 68 69 6c 64 | 2c 69 6e 73 65 72 74 65 |K(%Child|,inserte|
|00001d30| 64 2c 22 20 3d 20 22 2c | 22 20 61 6e 64 22 29 20 |d," = ",|" and") |
|00001d40| 61 6e 64 20 0d 0a 20 20 | 20 20 20 20 20 20 6e 6f |and .. | no|
|00001d50| 74 20 65 78 69 73 74 73 | 20 28 0d 0a 20 20 20 20 |t exists| (.. |
|00001d60| 20 20 20 20 20 20 73 65 | 6c 65 63 74 20 2a 20 66 | se|lect * f|
|00001d70| 72 6f 6d 20 25 50 61 72 | 65 6e 74 0d 0a 20 20 20 |rom %Par|ent.. |
|00001d80| 20 20 20 20 20 20 20 77 | 68 65 72 65 0d 0a 20 20 | w|here.. |
|00001d90| 20 20 20 20 20 20 20 20 | 20 20 2f 2a 20 25 25 4a | | /* %%J|
|00001da0| 6f 69 6e 46 4b 50 4b 28 | 69 6e 73 65 72 74 65 64 |oinFKPK(|inserted|
|00001db0| 2c 25 50 61 72 65 6e 74 | 2c 22 20 3d 20 22 2c 22 |,%Parent|," = ","|
|00001dc0| 20 61 6e 64 22 29 20 2a | 2f 0d 0a 20 20 20 20 20 | and") *|/.. |
|00001dd0| 20 20 20 20 20 20 20 25 | 4a 6f 69 6e 46 4b 50 4b | %|JoinFKPK|
|00001de0| 28 69 6e 73 65 72 74 65 | 64 2c 25 50 61 72 65 6e |(inserte|d,%Paren|
|00001df0| 74 2c 22 20 3d 20 22 2c | 22 20 61 6e 64 22 29 0d |t," = ",|" and").|
|00001e00| 0a 20 20 20 20 20 20 20 | 20 29 0d 0a 20 20 65 6e |. | ).. en|
|00001e10| 64 0d 0a 1e 27 03 00 15 | 00 43 48 49 4c 44 20 44 |d...'...|.CHILD D|
|00001e20| 45 4c 45 54 45 20 52 45 | 53 54 52 49 43 54 67 02 |ELETE RE|STRICTg.|
|00001e30| 20 20 20 20 2f 2a 20 45 | 52 77 69 6e 20 42 75 69 | /* E|Rwin Bui|
|00001e40| 6c 74 69 6e 20 25 44 61 | 74 65 74 69 6d 65 20 2a |ltin %Da|tetime *|
|00001e50| 2f 0d 0a 20 20 20 20 2f | 2a 20 25 50 61 72 65 6e |/.. /|* %Paren|
|00001e60| 74 20 25 56 65 72 62 50 | 68 72 61 73 65 20 25 43 |t %VerbP|hrase %C|
|00001e70| 68 69 6c 64 20 4f 4e 20 | 43 48 49 4c 44 20 44 45 |hild ON |CHILD DE|
|00001e80| 4c 45 54 45 20 52 45 53 | 54 52 49 43 54 20 2a 2f |LETE RES|TRICT */|
|00001e90| 0d 0a 20 20 20 20 69 66 | 20 65 78 69 73 74 73 20 |.. if| exists |
|00001ea0| 28 73 65 6c 65 63 74 20 | 2a 20 66 72 6f 6d 20 64 |(select |* from d|
|00001eb0| 65 6c 65 74 65 64 2c 25 | 50 61 72 65 6e 74 0d 0a |eleted,%|Parent..|
|00001ec0| 20 20 20 20 20 20 77 68 | 65 72 65 0d 0a 20 20 20 | wh|ere.. |
|00001ed0| 20 20 20 20 20 2f 2a 20 | 25 25 4a 6f 69 6e 46 4b | /* |%%JoinFK|
|00001ee0| 50 4b 28 64 65 6c 65 74 | 65 64 2c 25 50 61 72 65 |PK(delet|ed,%Pare|
|00001ef0| 6e 74 2c 22 20 3d 20 22 | 2c 22 20 61 6e 64 22 29 |nt," = "|," and")|
|00001f00| 20 2a 2f 0d 0a 20 20 20 | 20 20 20 20 20 25 4a 6f | */.. | %Jo|
|00001f10| 69 6e 46 4b 50 4b 28 64 | 65 6c 65 74 65 64 2c 25 |inFKPK(d|eleted,%|
|00001f20| 50 61 72 65 6e 74 2c 22 | 20 3d 20 22 2c 22 20 61 |Parent,"| = "," a|
|00001f30| 6e 64 22 29 20 61 6e 64 | 0d 0a 20 20 20 20 20 20 |nd") and|.. |
|00001f40| 20 20 6e 6f 74 20 65 78 | 69 73 74 73 20 28 0d 0a | not ex|ists (..|
|00001f50| 20 20 20 20 20 20 20 20 | 20 20 73 65 6c 65 63 74 | | select|
|00001f60| 20 2a 20 66 72 6f 6d 20 | 25 43 68 69 6c 64 0d 0a | * from |%Child..|
|00001f70| 20 20 20 20 20 20 20 20 | 20 20 77 68 65 72 65 0d | | where.|
|00001f80| 0a 20 20 20 20 20 20 20 | 20 20 20 20 20 2f 2a 20 |. | /* |
|00001f90| 25 25 4a 6f 69 6e 46 4b | 50 4b 28 25 43 68 69 6c |%%JoinFK|PK(%Chil|
|00001fa0| 64 2c 25 50 61 72 65 6e | 74 2c 22 20 3d 20 22 2c |d,%Paren|t," = ",|
|00001fb0| 22 20 61 6e 64 22 29 20 | 2a 2f 0d 0a 20 20 20 20 |" and") |*/.. |
|00001fc0| 20 20 20 20 20 20 20 20 | 25 4a 6f 69 6e 46 4b 50 | |%JoinFKP|
|00001fd0| 4b 28 25 43 68 69 6c 64 | 2c 25 50 61 72 65 6e 74 |K(%Child|,%Parent|
|00001fe0| 2c 22 20 3d 20 22 2c 22 | 20 61 6e 64 22 29 0d 0a |," = ","| and")..|
|00001ff0| 20 20 20 20 20 20 20 20 | 29 0d 0a 20 20 20 20 29 | |).. )|
|00002000| 0d 0a 20 20 20 20 62 65 | 67 69 6e 0d 0a 20 20 20 |.. be|gin.. |
|00002010| 20 20 20 73 65 6c 65 63 | 74 20 40 65 72 72 6e 6f | selec|t @errno|
|00002020| 20 20 3d 20 33 30 30 31 | 30 2c 0d 0a 20 20 20 20 | = 3001|0,.. |
|00002030| 20 20 20 20 20 20 20 20 | 20 40 65 72 72 6d 73 67 | | @errmsg|
|00002040| 20 3d 20 27 43 61 6e 6e | 6f 74 20 44 45 4c 45 54 | = 'Cann|ot DELET|
|00002050| 45 20 6c 61 73 74 20 22 | 25 43 68 69 6c 64 22 20 |E last "|%Child" |
|00002060| 62 65 63 61 75 73 65 20 | 22 25 50 61 72 65 6e 74 |because |"%Parent|
|00002070| 22 20 65 78 69 73 74 73 | 2e 27 0d 0a 20 20 20 20 |" exists|.'.. |
|00002080| 20 20 67 6f 74 6f 20 65 | 72 72 6f 72 0d 0a 20 20 | goto e|rror.. |
|00002090| 20 20 65 6e 64 0d 0a 20 | 27 03 00 14 00 43 48 49 | end.. |'....CHI|
|000020a0| 4c 44 20 44 45 4c 45 54 | 45 20 43 41 53 43 41 44 |LD DELET|E CASCAD|
|000020b0| 45 cc 01 20 20 20 20 2f | 2a 20 45 52 77 69 6e 20 |E.. /|* ERwin |
|000020c0| 42 75 69 6c 74 69 6e 20 | 25 44 61 74 65 74 69 6d |Builtin |%Datetim|
|000020d0| 65 20 2a 2f 0d 0a 20 20 | 20 20 2f 2a 20 25 50 61 |e */.. | /* %Pa|
|000020e0| 72 65 6e 74 20 25 56 65 | 72 62 50 68 72 61 73 65 |rent %Ve|rbPhrase|
|000020f0| 20 25 43 68 69 6c 64 20 | 4f 4e 20 43 48 49 4c 44 | %Child |ON CHILD|
|00002100| 20 44 45 4c 45 54 45 20 | 43 41 53 43 41 44 45 20 | DELETE |CASCADE |
|00002110| 2a 2f 0d 0a 20 20 20 20 | 64 65 6c 65 74 65 20 25 |*/.. |delete %|
|00002120| 50 61 72 65 6e 74 0d 0a | 20 20 20 20 20 20 66 72 |Parent..| fr|
|00002130| 6f 6d 20 25 50 61 72 65 | 6e 74 2c 64 65 6c 65 74 |om %Pare|nt,delet|
|00002140| 65 64 0d 0a 20 20 20 20 | 20 20 77 68 65 72 65 0d |ed.. | where.|
|00002150| 0a 20 20 20 20 20 20 20 | 20 2f 2a 20 25 25 4a 6f |. | /* %%Jo|
|00002160| 69 6e 46 4b 50 4b 28 64 | 65 6c 65 74 65 64 2c 25 |inFKPK(d|eleted,%|
|00002170| 50 61 72 65 6e 74 2c 22 | 20 3d 20 22 2c 22 20 61 |Parent,"| = "," a|
|00002180| 6e 64 22 29 20 2a 2f 0d | 0a 20 20 20 20 20 20 20 |nd") */.|. |
|00002190| 20 25 4a 6f 69 6e 46 4b | 50 4b 28 64 65 6c 65 74 | %JoinFK|PK(delet|
|000021a0| 65 64 2c 25 50 61 72 65 | 6e 74 2c 22 20 3d 20 22 |ed,%Pare|nt," = "|
|000021b0| 2c 22 20 61 6e 64 22 29 | 20 61 6e 64 0d 0a 20 20 |," and")| and.. |
|000021c0| 20 20 20 20 20 20 6e 6f | 74 20 65 78 69 73 74 73 | no|t exists|
|000021d0| 20 28 0d 0a 20 20 20 20 | 20 20 20 20 20 20 73 65 | (.. | se|
|000021e0| 6c 65 63 74 20 2a 20 66 | 72 6f 6d 20 25 43 68 69 |lect * f|rom %Chi|
|000021f0| 6c 64 0d 0a 20 20 20 20 | 20 20 20 20 20 20 77 68 |ld.. | wh|
|00002200| 65 72 65 0d 0a 20 20 20 | 20 20 20 20 20 20 20 20 |ere.. | |
|00002210| 20 2f 2a 20 25 25 4a 6f | 69 6e 46 4b 50 4b 28 25 | /* %%Jo|inFKPK(%|
|00002220| 43 68 69 6c 64 2c 25 50 | 61 72 65 6e 74 2c 22 20 |Child,%P|arent," |
|00002230| 3d 20 22 2c 22 20 61 6e | 64 22 29 20 2a 2f 0d 0a |= "," an|d") */..|
|00002240| 20 20 20 20 20 20 20 20 | 20 20 20 20 25 4a 6f 69 | | %Joi|
|00002250| 6e 46 4b 50 4b 28 25 43 | 68 69 6c 64 2c 25 50 61 |nFKPK(%C|hild,%Pa|
|00002260| 72 65 6e 74 2c 22 20 3d | 20 22 2c 22 20 61 6e 64 |rent," =| "," and|
|00002270| 22 29 0d 0a 20 20 20 20 | 20 20 20 20 29 0d 0a 21 |").. | )..!|
|00002280| 27 03 00 16 00 50 41 52 | 45 4e 54 20 49 4e 53 45 |'....PAR|ENT INSE|
|00002290| 52 54 20 52 45 53 54 52 | 49 43 54 e8 01 20 20 20 |RT RESTR|ICT.. |
|000022a0| 20 2f 2a 20 45 52 77 69 | 6e 20 42 75 69 6c 74 69 | /* ERwi|n Builti|
|000022b0| 6e 20 25 44 61 74 65 74 | 69 6d 65 20 2a 2f 0d 0a |n %Datet|ime */..|
|000022c0| 20 20 20 20 2f 2a 20 25 | 50 61 72 65 6e 74 20 25 | /* %|Parent %|
|000022d0| 56 65 72 62 50 68 72 61 | 73 65 20 25 43 68 69 6c |VerbPhra|se %Chil|
|000022e0| 64 20 4f 4e 20 50 41 52 | 45 4e 54 20 49 4e 53 45 |d ON PAR|ENT INSE|
|000022f0| 52 54 20 52 45 53 54 52 | 49 43 54 20 2a 2f 0d 0a |RT RESTR|ICT */..|
|00002300| 20 20 20 20 69 66 20 65 | 78 69 73 74 73 20 28 73 | if e|xists (s|
|00002310| 65 6c 65 63 74 20 2a 20 | 66 72 6f 6d 20 69 6e 73 |elect * |from ins|
|00002320| 65 72 74 65 64 0d 0a 20 | 20 20 20 20 20 77 68 65 |erted.. | whe|
|00002330| 72 65 20 6e 6f 74 20 65 | 78 69 73 74 73 20 28 0d |re not e|xists (.|
|00002340| 0a 20 20 20 20 20 20 20 | 20 20 20 73 65 6c 65 63 |. | selec|
|00002350| 74 20 2a 20 66 72 6f 6d | 20 25 43 68 69 6c 64 0d |t * from| %Child.|
|00002360| 0a 20 20 20 20 20 20 20 | 20 20 20 77 68 65 72 65 |. | where|
|00002370| 0d 0a 20 20 20 20 20 20 | 20 20 20 20 20 20 2f 2a |.. | /*|
|00002380| 20 25 25 4a 6f 69 6e 46 | 4b 50 4b 28 25 43 68 69 | %%JoinF|KPK(%Chi|
|00002390| 6c 64 2c 69 6e 73 65 72 | 74 65 64 2c 22 20 3d 20 |ld,inser|ted," = |
|000023a0| 22 2c 22 20 61 6e 64 22 | 29 20 2a 2f 0d 0a 20 20 |"," and"|) */.. |
|000023b0| 20 20 20 20 20 20 20 20 | 20 20 25 4a 6f 69 6e 46 | | %JoinF|
|000023c0| 4b 50 4b 28 25 43 68 69 | 6c 64 2c 69 6e 73 65 72 |KPK(%Chi|ld,inser|
|000023d0| 74 65 64 2c 22 20 3d 20 | 22 2c 22 20 61 6e 64 22 |ted," = |"," and"|
|000023e0| 29 0d 0a 20 20 20 20 20 | 20 29 0d 0a 20 20 20 20 |).. | ).. |
|000023f0| 29 0d 0a 20 20 20 20 62 | 65 67 69 6e 0d 0a 20 20 |).. b|egin.. |
|00002400| 20 20 20 20 73 65 6c 65 | 63 74 20 40 65 72 72 6e | sele|ct @errn|
|00002410| 6f 20 20 3d 20 33 30 30 | 31 31 2c 0d 0a 20 20 20 |o = 300|11,.. |
|00002420| 20 20 20 20 20 20 20 20 | 20 20 40 65 72 72 6d 73 | | @errms|
|00002430| 67 20 3d 20 27 43 61 6e | 6e 6f 74 20 49 4e 53 45 |g = 'Can|not INSE|
|00002440| 52 54 20 22 25 50 61 72 | 65 6e 74 22 20 62 65 63 |RT "%Par|ent" bec|
|00002450| 61 75 73 65 20 22 25 43 | 68 69 6c 64 22 20 64 6f |ause "%C|hild" do|
|00002460| 65 73 20 6e 6f 74 2e 27 | 0d 0a 20 20 20 20 20 20 |es not.'|.. |
|00002470| 67 6f 74 6f 20 65 72 72 | 6f 72 0d 0a 20 20 20 20 |goto err|or.. |
|00002480| 65 6e 64 0d 0a 24 27 03 | 00 0d 00 55 50 44 41 54 |end..$'.|...UPDAT|
|00002490| 45 20 48 45 41 44 45 52 | 56 01 63 72 65 61 74 65 |E HEADER|V.create|
|000024a0| 20 74 72 69 67 67 65 72 | 20 74 25 31 41 63 74 69 | trigger| t%1Acti|
|000024b0| 6f 6e 5f 25 32 37 54 61 | 62 6c 65 4e 61 6d 65 20 |on_%27Ta|bleName |
|000024c0| 6f 6e 20 25 54 61 62 6c | 65 4e 61 6d 65 20 66 6f |on %Tabl|eName fo|
|000024d0| 72 20 25 41 63 74 69 6f | 6e 20 61 73 0d 0a 2f 2a |r %Actio|n as../*|
|000024e0| 20 45 52 77 69 6e 20 42 | 75 69 6c 74 69 6e 20 25 | ERwin B|uiltin %|
|000024f0| 44 61 74 65 74 69 6d 65 | 20 2a 2f 0d 0a 2f 2a 20 |Datetime| */../* |
|00002500| 25 41 63 74 69 6f 6e 20 | 74 72 69 67 67 65 72 20 |%Action |trigger |
|00002510| 6f 6e 20 25 54 61 62 6c | 65 4e 61 6d 65 20 2a 2f |on %Tabl|eName */|
|00002520| 0d 0a 62 65 67 69 6e 0d | 0a 20 20 64 65 63 6c 61 |..begin.|. decla|
|00002530| 72 65 20 20 40 6e 75 6d | 72 6f 77 73 20 69 6e 74 |re @num|rows int|
|00002540| 2c 0d 0a 20 20 20 20 20 | 20 20 20 20 20 20 40 6e |,.. | @n|
|00002550| 75 6c 6c 63 6e 74 20 69 | 6e 74 2c 0d 0a 20 20 20 |ullcnt i|nt,.. |
|00002560| 20 20 20 20 20 20 20 20 | 40 76 61 6c 69 64 63 6e | |@validcn|
|00002570| 74 20 69 6e 74 2c 0d 0a | 20 20 20 20 20 20 20 20 |t int,..| |
|00002580| 20 20 20 25 50 4b 44 65 | 63 6c 28 2c 40 69 6e 73 | %PKDe|cl(,@ins|
|00002590| 29 2c 0d 0a 20 20 20 20 | 20 20 20 20 20 20 20 40 |),.. | @|
|000025a0| 65 72 72 6e 6f 20 20 20 | 69 6e 74 2c 0d 0a 20 20 |errno |int,.. |
|000025b0| 20 20 20 20 20 20 20 20 | 20 40 65 72 72 6d 73 67 | | @errmsg|
|000025c0| 20 20 76 61 72 63 68 61 | 72 28 32 35 35 29 0d 0a | varcha|r(255)..|
|000025d0| 0d 0a 20 20 73 65 6c 65 | 63 74 20 40 6e 75 6d 72 |.. sele|ct @numr|
|000025e0| 6f 77 73 20 3d 20 40 40 | 72 6f 77 63 6f 75 6e 74 |ows = @@|rowcount|
|000025f0| 28 27 03 00 0d 00 55 50 | 44 41 54 45 20 46 4f 4f |('....UP|DATE FOO|
|00002600| 54 45 52 74 00 20 20 2f | 2a 20 45 52 77 69 6e 20 |TERt. /|* ERwin |
|00002610| 42 75 69 6c 74 69 6e 20 | 25 44 61 74 65 74 69 6d |Builtin |%Datetim|
|00002620| 65 20 2a 2f 0d 0a 20 20 | 72 65 74 75 72 6e 0d 0a |e */.. |return..|
|00002630| 65 72 72 6f 72 3a 0d 0a | 20 20 20 20 72 61 69 73 |error:..| rais|
|00002640| 65 72 72 6f 72 20 40 65 | 72 72 6e 6f 20 40 65 72 |error @e|rrno @er|
|00002650| 72 6d 73 67 0d 0a 20 20 | 20 20 72 6f 6c 6c 62 61 |rmsg.. | rollba|
|00002660| 63 6b 20 74 72 61 6e 73 | 61 63 74 69 6f 6e 0d 0a |ck trans|action..|
|00002670| 65 6e 64 0d 0a 67 6f 0d | 0a 29 27 03 00 0d 00 44 |end..go.|.)'....D|
|00002680| 45 4c 45 54 45 20 48 45 | 41 44 45 52 c9 00 63 72 |ELETE HE|ADER..cr|
|00002690| 65 61 74 65 20 74 72 69 | 67 67 65 72 20 74 25 31 |eate tri|gger t%1|
|000026a0| 41 63 74 69 6f 6e 5f 25 | 32 37 54 61 62 6c 65 4e |Action_%|27TableN|
|000026b0| 61 6d 65 20 6f 6e 20 25 | 54 61 62 6c 65 4e 61 6d |ame on %|TableNam|
|000026c0| 65 20 66 6f 72 20 25 41 | 63 74 69 6f 6e 20 61 73 |e for %A|ction as|
|000026d0| 0d 0a 2f 2a 20 45 52 77 | 69 6e 20 42 75 69 6c 74 |../* ERw|in Built|
|000026e0| 69 6e 20 25 44 61 74 65 | 74 69 6d 65 20 2a 2f 0d |in %Date|time */.|
|000026f0| 0a 2f 2a 20 25 41 63 74 | 69 6f 6e 20 74 72 69 67 |./* %Act|ion trig|
|00002700| 67 65 72 20 6f 6e 20 25 | 54 61 62 6c 65 4e 61 6d |ger on %|TableNam|
|00002710| 65 20 2a 2f 0d 0a 62 65 | 67 69 6e 0d 0a 20 20 64 |e */..be|gin.. d|
|00002720| 65 63 6c 61 72 65 20 20 | 40 65 72 72 6e 6f 20 20 |eclare |@errno |
|00002730| 20 69 6e 74 2c 0d 0a 20 | 20 20 20 20 20 20 20 20 | int,.. | |
|00002740| 20 20 40 65 72 72 6d 73 | 67 20 20 76 61 72 63 68 | @errms|g varch|
|00002750| 61 72 28 32 35 35 29 2a | 27 03 00 0d 00 44 45 4c |ar(255)*|'....DEL|
|00002760| 45 54 45 20 46 4f 4f 54 | 45 52 78 00 20 20 20 20 |ETE FOOT|ERx. |
|00002770| 2f 2a 20 45 52 77 69 6e | 20 42 75 69 6c 74 69 6e |/* ERwin| Builtin|
|00002780| 20 25 44 61 74 65 74 69 | 6d 65 20 2a 2f 0d 0a 20 | %Dateti|me */.. |
|00002790| 20 20 20 72 65 74 75 72 | 6e 0d 0a 65 72 72 6f 72 | retur|n..error|
|000027a0| 3a 0d 0a 20 20 20 20 72 | 61 69 73 65 72 72 6f 72 |:.. r|aiserror|
|000027b0| 20 40 65 72 72 6e 6f 20 | 40 65 72 72 6d 73 67 0d | @errno |@errmsg.|
|000027c0| 0a 20 20 20 20 72 6f 6c | 6c 62 61 63 6b 20 74 72 |. rol|lback tr|
|000027d0| 61 6e 73 61 63 74 69 6f | 6e 0d 0a 65 6e 64 0d 0a |ansactio|n..end..|
|000027e0| 67 6f 0d 0a 2b 27 03 00 | 0d 00 49 4e 53 45 52 54 |go..+'..|..INSERT|
|000027f0| 20 48 45 41 44 45 52 3a | 01 63 72 65 61 74 65 20 | HEADER:|.create |
|00002800| 74 72 69 67 67 65 72 20 | 74 25 31 41 63 74 69 6f |trigger |t%1Actio|
|00002810| 6e 5f 25 32 37 54 61 62 | 6c 65 4e 61 6d 65 20 6f |n_%27Tab|leName o|
|00002820| 6e 20 25 54 61 62 6c 65 | 4e 61 6d 65 20 66 6f 72 |n %Table|Name for|
|00002830| 20 25 41 63 74 69 6f 6e | 20 61 73 0d 0a 2f 2a 20 | %Action| as../* |
|00002840| 45 52 77 69 6e 20 42 75 | 69 6c 74 69 6e 20 25 44 |ERwin Bu|iltin %D|
|00002850| 61 74 65 74 69 6d 65 20 | 2a 2f 0d 0a 2f 2a 20 25 |atetime |*/../* %|
|00002860| 41 63 74 69 6f 6e 20 74 | 72 69 67 67 65 72 20 6f |Action t|rigger o|
|00002870| 6e 20 25 54 61 62 6c 65 | 4e 61 6d 65 20 2a 2f 0d |n %Table|Name */.|
|00002880| 0a 62 65 67 69 6e 0d 0a | 20 20 64 65 63 6c 61 72 |.begin..| declar|
|00002890| 65 20 20 40 6e 75 6d 72 | 6f 77 73 20 69 6e 74 2c |e @numr|ows int,|
|000028a0| 0d 0a 20 20 20 20 20 20 | 20 20 20 20 20 40 6e 75 |.. | @nu|
|000028b0| 6c 6c 63 6e 74 20 69 6e | 74 2c 0d 0a 20 20 20 20 |llcnt in|t,.. |
|000028c0| 20 20 20 20 20 20 20 40 | 76 61 6c 69 64 63 6e 74 | @|validcnt|
|000028d0| 20 69 6e 74 2c 0d 0a 20 | 20 20 20 20 20 20 20 20 | int,.. | |
|000028e0| 20 20 40 65 72 72 6e 6f | 20 20 20 69 6e 74 2c 0d | @errno| int,.|
|000028f0| 0a 20 20 20 20 20 20 20 | 20 20 20 20 40 65 72 72 |. | @err|
|00002900| 6d 73 67 20 20 76 61 72 | 63 68 61 72 28 32 35 35 |msg var|char(255|
|00002910| 29 0d 0a 0d 0a 20 20 73 | 65 6c 65 63 74 20 40 6e |).... s|elect @n|
|00002920| 75 6d 72 6f 77 73 20 3d | 20 40 40 72 6f 77 63 6f |umrows =| @@rowco|
|00002930| 75 6e 74 2c 27 03 00 0d | 00 49 4e 53 45 52 54 20 |unt,'...|.INSERT |
|00002940| 46 4f 4f 54 45 52 74 00 | 20 20 2f 2a 20 45 52 77 |FOOTERt.| /* ERw|
|00002950| 69 6e 20 42 75 69 6c 74 | 69 6e 20 25 44 61 74 65 |in Built|in %Date|
|00002960| 74 69 6d 65 20 2a 2f 0d | 0a 20 20 72 65 74 75 72 |time */.|. retur|
|00002970| 6e 0d 0a 65 72 72 6f 72 | 3a 0d 0a 20 20 20 20 72 |n..error|:.. r|
|00002980| 61 69 73 65 72 72 6f 72 | 20 40 65 72 72 6e 6f 20 |aiserror| @errno |
|00002990| 40 65 72 72 6d 73 67 0d | 0a 20 20 20 20 72 6f 6c |@errmsg.|. rol|
|000029a0| 6c 62 61 63 6b 20 74 72 | 61 6e 73 61 63 74 69 6f |lback tr|ansactio|
|000029b0| 6e 0d 0a 65 6e 64 0d 0a | 67 6f 0d 0a 2d 27 03 00 |n..end..|go..-'..|
|000029c0| 15 00 43 55 53 54 4f 4d | 20 54 52 49 47 47 45 52 |..CUSTOM| TRIGGER|
|000029d0| 20 48 45 41 44 45 52 46 | 00 63 72 65 61 74 65 20 | HEADERF|.create |
|000029e0| 74 72 69 67 67 65 72 20 | 25 54 72 69 67 67 65 72 |trigger |%Trigger|
|000029f0| 4e 61 6d 65 20 6f 6e 20 | 25 54 61 62 6c 65 4e 61 |Name on |%TableNa|
|00002a00| 6d 65 0d 0a 20 20 66 6f | 72 20 25 41 63 74 69 6f |me.. fo|r %Actio|
|00002a10| 6e 73 28 22 2c 22 29 0d | 0a 20 20 61 73 0d 0a 2e |ns(",").|. as...|
|00002a20| 27 03 00 15 00 43 55 53 | 54 4f 4d 20 54 52 49 47 |'....CUS|TOM TRIG|
|00002a30| 47 45 52 20 46 4f 4f 54 | 45 52 04 00 67 6f 0d 0a |GER FOOT|ER..go..|
|00002a40| 2f 27 03 00 1b 00 43 55 | 53 54 4f 4d 20 54 52 49 |/'....CU|STOM TRI|
|00002a50| 47 47 45 52 20 44 45 46 | 41 55 4c 54 20 42 4f 44 |GGER DEF|AULT BOD|
|00002a60| 59 2b 02 63 72 65 61 74 | 65 20 74 72 69 67 67 65 |Y+.creat|e trigge|
|00002a70| 72 20 25 54 72 69 67 67 | 65 72 4e 61 6d 65 20 6f |r %Trigg|erName o|
|00002a80| 6e 20 25 54 61 62 6c 65 | 4e 61 6d 65 0d 0a 20 20 |n %Table|Name.. |
|00002a90| 66 6f 72 20 25 41 63 74 | 69 6f 6e 73 28 22 2c 22 |for %Act|ions(","|
|00002aa0| 29 0d 0a 20 20 61 73 0d | 0a 2f 2a 20 45 52 77 69 |).. as.|./* ERwi|
|00002ab0| 6e 20 42 75 69 6c 74 69 | 6e 20 25 44 61 74 65 74 |n Builti|n %Datet|
|00002ac0| 69 6d 65 20 2a 2f 0d 0a | 2f 2a 20 25 41 63 74 69 |ime */..|/* %Acti|
|00002ad0| 6f 6e 73 28 22 2c 22 29 | 20 74 72 69 67 67 65 72 |ons(",")| trigger|
|00002ae0| 20 6f 6e 20 25 54 61 62 | 6c 65 4e 61 6d 65 20 2a | on %Tab|leName *|
|00002af0| 2f 0d 0a 2f 2a 20 64 65 | 66 61 75 6c 74 20 62 6f |/../* de|fault bo|
|00002b00| 64 79 20 66 6f 72 20 25 | 54 72 69 67 67 65 72 4e |dy for %|TriggerN|
|00002b10| 61 6d 65 20 2a 2f 0d 0a | 62 65 67 69 6e 0d 0a 20 |ame */..|begin.. |
|00002b20| 20 64 65 63 6c 61 72 65 | 20 20 40 6e 75 6d 72 6f | declare| @numro|
|00002b30| 77 73 20 69 6e 74 2c 0d | 0a 20 20 20 20 20 20 20 |ws int,.|. |
|00002b40| 20 20 20 20 40 6e 75 6c | 6c 63 6e 74 20 69 6e 74 | @nul|lcnt int|
|00002b50| 2c 0d 0a 20 20 20 20 20 | 20 20 20 20 20 20 40 76 |,.. | @v|
|00002b60| 61 6c 69 64 63 6e 74 20 | 69 6e 74 2c 0d 0a 20 20 |alidcnt |int,.. |
|00002b70| 20 20 20 20 20 20 20 20 | 20 25 50 4b 44 65 63 6c | | %PKDecl|
|00002b80| 28 2c 40 69 6e 73 29 2c | 0d 0a 20 20 20 20 20 20 |(,@ins),|.. |
|00002b90| 20 20 20 20 20 40 65 72 | 72 6e 6f 20 20 20 69 6e | @er|rno in|
|00002ba0| 74 2c 0d 0a 20 20 20 20 | 20 20 20 20 20 20 20 40 |t,.. | @|
|00002bb0| 65 72 72 6d 73 67 20 20 | 76 61 72 63 68 61 72 28 |errmsg |varchar(|
|00002bc0| 32 35 35 29 0d 0a 0d 0a | 20 20 73 65 6c 65 63 74 |255)....| select|
|00002bd0| 20 40 6e 75 6d 72 6f 77 | 73 20 3d 20 40 40 72 6f | @numrow|s = @@ro|
|00002be0| 77 63 6f 75 6e 74 0d 0a | 25 46 6f 72 45 61 63 68 |wcount..|%ForEach|
|00002bf0| 43 68 69 6c 64 52 65 6c | 28 29 20 7b 0d 0a 20 20 |ChildRel|() {.. |
|00002c00| 25 52 65 6c 54 65 6d 70 | 6c 61 74 65 0d 0a 7d 0d |%RelTemp|late..}.|
|00002c10| 0a 25 46 6f 72 45 61 63 | 68 50 61 72 65 6e 74 52 |.%ForEac|hParentR|
|00002c20| 65 6c 28 29 20 7b 0d 0a | 20 20 25 52 65 6c 54 65 |el() {..| %RelTe|
|00002c30| 6d 70 6c 61 74 65 0d 0a | 7d 0d 0a 20 20 72 65 74 |mplate..|}.. ret|
|00002c40| 75 72 6e 0d 0a 65 72 72 | 6f 72 3a 0d 0a 20 20 20 |urn..err|or:.. |
|00002c50| 20 72 61 69 73 65 72 72 | 6f 72 20 40 65 72 72 6e | raiserr|or @errn|
|00002c60| 6f 20 40 65 72 72 6d 73 | 67 0d 0a 20 20 20 20 72 |o @errms|g.. r|
|00002c70| 6f 6c 6c 62 61 63 6b 20 | 74 72 61 6e 73 61 63 74 |ollback |transact|
|00002c80| 69 6f 6e 0d 0a 65 6e 64 | 0d 0a 67 6f 0d 0a 30 27 |ion..end|..go..0'|
|00002c90| 03 00 19 00 50 41 52 45 | 4e 54 20 55 50 44 41 54 |....PARE|NT UPDAT|
|00002ca0| 45 20 53 45 54 20 44 45 | 46 41 55 4c 54 92 00 2f |E SET DE|FAULT../|
|00002cb0| 2a 20 45 52 77 69 6e 20 | 42 75 69 6c 74 69 6e 20 |* ERwin |Builtin |
|00002cc0| 25 44 61 74 65 74 69 6d | 65 20 2a 2f 0d 0a 2f 2a |%Datetim|e */../*|
|00002cd0| 20 25 50 61 72 65 6e 74 | 20 25 56 65 72 62 50 68 | %Parent| %VerbPh|
|00002ce0| 72 61 73 65 20 25 43 68 | 69 6c 64 20 4f 4e 20 50 |rase %Ch|ild ON P|
|00002cf0| 41 52 45 4e 54 20 55 50 | 44 41 54 45 20 53 45 54 |ARENT UP|DATE SET|
|00002d00| 20 44 45 46 41 55 4c 54 | 20 2a 2f 0d 0a 2f 2a 20 | DEFAULT| */../* |
|00002d10| 41 70 70 6c 69 63 61 74 | 69 6f 6e 20 73 70 65 63 |Applicat|ion spec|
|00002d20| 69 66 69 63 2e 20 20 4c | 65 66 74 20 6f 75 74 20 |ific. L|eft out |
|00002d30| 69 6e 74 65 6e 74 69 6f | 6e 61 6c 6c 79 2e 20 2a |intentio|nally. *|
|00002d40| 2f 13 27 03 00 19 00 50 | 41 52 45 4e 54 20 44 45 |/.'....P|ARENT DE|
|00002d50| 4c 45 54 45 20 53 45 54 | 20 44 45 46 41 55 4c 54 |LETE SET| DEFAULT|
|00002d60| 92 00 2f 2a 20 45 52 77 | 69 6e 20 42 75 69 6c 74 |../* ERw|in Built|
|00002d70| 69 6e 20 25 44 61 74 65 | 74 69 6d 65 20 2a 2f 0d |in %Date|time */.|
|00002d80| 0a 2f 2a 20 25 50 61 72 | 65 6e 74 20 25 56 65 72 |./* %Par|ent %Ver|
|00002d90| 62 50 68 72 61 73 65 20 | 25 43 68 69 6c 64 20 4f |bPhrase |%Child O|
|00002da0| 4e 20 50 41 52 45 4e 54 | 20 44 45 4c 45 54 45 20 |N PARENT| DELETE |
|00002db0| 53 45 54 20 44 45 46 41 | 55 4c 54 20 2a 2f 0d 0a |SET DEFA|ULT */..|
|00002dc0| 2f 2a 20 41 70 70 6c 69 | 63 61 74 69 6f 6e 20 73 |/* Appli|cation s|
|00002dd0| 70 65 63 69 66 69 63 2e | 20 20 4c 65 66 74 20 6f |pecific.| Left o|
|00002de0| 75 74 20 69 6e 74 65 6e | 74 69 6f 6e 61 6c 6c 79 |ut inten|tionally|
|00002df0| 2e 20 2a 2f 17 27 03 00 | 19 00 50 41 52 45 4e 54 |. */.'..|..PARENT|
|00002e00| 20 49 4e 53 45 52 54 20 | 53 45 54 20 44 45 46 41 | INSERT |SET DEFA|
|00002e10| 55 4c 54 92 00 2f 2a 20 | 45 52 77 69 6e 20 42 75 |ULT../* |ERwin Bu|
|00002e20| 69 6c 74 69 6e 20 25 44 | 61 74 65 74 69 6d 65 20 |iltin %D|atetime |
|00002e30| 2a 2f 0d 0a 2f 2a 20 25 | 50 61 72 65 6e 74 20 25 |*/../* %|Parent %|
|00002e40| 56 65 72 62 50 68 72 61 | 73 65 20 25 43 68 69 6c |VerbPhra|se %Chil|
|00002e50| 64 20 4f 4e 20 50 41 52 | 45 4e 54 20 49 4e 53 45 |d ON PAR|ENT INSE|
|00002e60| 52 54 20 53 45 54 20 44 | 45 46 41 55 4c 54 20 2a |RT SET D|EFAULT *|
|00002e70| 2f 0d 0a 2f 2a 20 41 70 | 70 6c 69 63 61 74 69 6f |/../* Ap|plicatio|
|00002e80| 6e 20 73 70 65 63 69 66 | 69 63 2e 20 20 4c 65 66 |n specif|ic. Lef|
|00002e90| 74 20 6f 75 74 20 69 6e | 74 65 6e 74 69 6f 6e 61 |t out in|tentiona|
|00002ea0| 6c 6c 79 2e 20 2a 2f 27 | 27 03 00 18 00 43 48 49 |lly. */'|'....CHI|
|00002eb0| 4c 44 20 49 4e 53 45 52 | 54 20 53 45 54 20 44 45 |LD INSER|T SET DE|
|00002ec0| 46 41 55 4c 54 91 00 2f | 2a 20 45 52 77 69 6e 20 |FAULT../|* ERwin |
|00002ed0| 42 75 69 6c 74 69 6e 20 | 25 44 61 74 65 74 69 6d |Builtin |%Datetim|
|00002ee0| 65 20 2a 2f 0d 0a 2f 2a | 20 25 50 61 72 65 6e 74 |e */../*| %Parent|
|00002ef0| 20 25 56 65 72 62 50 68 | 72 61 73 65 20 25 43 68 | %VerbPh|rase %Ch|
|00002f00| 69 6c 64 20 4f 4e 20 43 | 48 49 4c 44 20 49 4e 53 |ild ON C|HILD INS|
|00002f10| 45 52 54 20 53 45 54 20 | 44 45 46 41 55 4c 54 20 |ERT SET |DEFAULT |
|00002f20| 2a 2f 0d 0a 2f 2a 20 41 | 70 70 6c 69 63 61 74 69 |*/../* A|pplicati|
|00002f30| 6f 6e 20 73 70 65 63 69 | 66 69 63 2e 20 20 4c 65 |on speci|fic. Le|
|00002f40| 66 74 20 6f 75 74 20 69 | 6e 74 65 6e 74 69 6f 6e |ft out i|ntention|
|00002f50| 61 6c 6c 79 2e 20 2a 2f | 1b 27 03 00 18 00 43 48 |ally. */|.'....CH|
|00002f60| 49 4c 44 20 55 50 44 41 | 54 45 20 53 45 54 20 44 |ILD UPDA|TE SET D|
|00002f70| 45 46 41 55 4c 54 91 00 | 2f 2a 20 45 52 77 69 6e |EFAULT..|/* ERwin|
|00002f80| 20 42 75 69 6c 74 69 6e | 20 25 44 61 74 65 74 69 | Builtin| %Dateti|
|00002f90| 6d 65 20 2a 2f 0d 0a 2f | 2a 20 25 50 61 72 65 6e |me */../|* %Paren|
|00002fa0| 74 20 25 56 65 72 62 50 | 68 72 61 73 65 20 25 43 |t %VerbP|hrase %C|
|00002fb0| 68 69 6c 64 20 4f 4e 20 | 43 48 49 4c 44 20 55 50 |hild ON |CHILD UP|
|00002fc0| 44 41 54 45 20 53 45 54 | 20 44 45 46 41 55 4c 54 |DATE SET| DEFAULT|
|00002fd0| 20 2a 2f 0d 0a 2f 2a 20 | 41 70 70 6c 69 63 61 74 | */../* |Applicat|
|00002fe0| 69 6f 6e 20 73 70 65 63 | 69 66 69 63 2e 20 20 4c |ion spec|ific. L|
|00002ff0| 65 66 74 20 6f 75 74 20 | 69 6e 74 65 6e 74 69 6f |eft out |intentio|
|00003000| 6e 61 6c 6c 79 2e 20 2a | 2f 1f 27 03 00 18 00 43 |nally. *|/.'....C|
|00003010| 48 49 4c 44 20 44 45 4c | 45 54 45 20 53 45 54 20 |HILD DEL|ETE SET |
|00003020| 44 45 46 41 55 4c 54 91 | 00 2f 2a 20 45 52 77 69 |DEFAULT.|./* ERwi|
|00003030| 6e 20 42 75 69 6c 74 69 | 6e 20 25 44 61 74 65 74 |n Builti|n %Datet|
|00003040| 69 6d 65 20 2a 2f 0d 0a | 2f 2a 20 25 50 61 72 65 |ime */..|/* %Pare|
|00003050| 6e 74 20 25 56 65 72 62 | 50 68 72 61 73 65 20 25 |nt %Verb|Phrase %|
|00003060| 43 68 69 6c 64 20 4f 4e | 20 43 48 49 4c 44 20 44 |Child ON| CHILD D|
|00003070| 45 4c 45 54 45 20 53 45 | 54 20 44 45 46 41 55 4c |ELETE SE|T DEFAUL|
|00003080| 54 20 2a 2f 0d 0a 2f 2a | 20 41 70 70 6c 69 63 61 |T */../*| Applica|
|00003090| 74 69 6f 6e 20 73 70 65 | 63 69 66 69 63 2e 20 20 |tion spe|cific. |
|000030a0| 4c 65 66 74 20 6f 75 74 | 20 69 6e 74 65 6e 74 69 |Left out| intenti|
|000030b0| 6f 6e 61 6c 6c 79 2e 20 | 2a 2f 23 27 03 00 15 00 |onally. |*/#'....|
|000030c0| 43 48 49 4c 44 20 44 45 | 4c 45 54 45 20 53 45 54 |CHILD DE|LETE SET|
|000030d0| 20 4e 55 4c 4c 8e 00 2f | 2a 20 45 52 77 69 6e 20 | NULL../|* ERwin |
|000030e0| 42 75 69 6c 74 69 6e 20 | 25 44 61 74 65 74 69 6d |Builtin |%Datetim|
|000030f0| 65 20 2a 2f 0d 0a 2f 2a | 20 25 50 61 72 65 6e 74 |e */../*| %Parent|
|00003100| 20 25 56 65 72 62 50 68 | 72 61 73 65 20 25 43 68 | %VerbPh|rase %Ch|
|00003110| 69 6c 64 20 4f 4e 20 43 | 48 49 4c 44 20 44 45 4c |ild ON C|HILD DEL|
|00003120| 45 54 45 20 53 45 54 20 | 4e 55 4c 4c 20 2a 2f 0d |ETE SET |NULL */.|
|00003130| 0a 2f 2a 20 41 70 70 6c | 69 63 61 74 69 6f 6e 20 |./* Appl|ication |
|00003140| 73 70 65 63 69 66 69 63 | 2e 20 20 4c 65 66 74 20 |specific|. Left |
|00003150| 6f 75 74 20 69 6e 74 65 | 6e 74 69 6f 6e 61 6c 6c |out inte|ntionall|
|00003160| 79 2e 20 2a 2f 22 27 03 | 00 16 00 50 41 52 45 4e |y. */"'.|...PAREN|
|00003170| 54 20 49 4e 53 45 52 54 | 20 53 45 54 20 4e 55 4c |T INSERT| SET NUL|
|00003180| 4c 8f 00 2f 2a 20 45 52 | 77 69 6e 20 42 75 69 6c |L../* ER|win Buil|
|00003190| 74 69 6e 20 25 44 61 74 | 65 74 69 6d 65 20 2a 2f |tin %Dat|etime */|
|000031a0| 0d 0a 2f 2a 20 25 50 61 | 72 65 6e 74 20 25 56 65 |../* %Pa|rent %Ve|
|000031b0| 72 62 50 68 72 61 73 65 | 20 25 43 68 69 6c 64 20 |rbPhrase| %Child |
|000031c0| 4f 4e 20 50 41 52 45 4e | 54 20 49 4e 53 45 52 54 |ON PAREN|T INSERT|
|000031d0| 20 53 45 54 20 4e 55 4c | 4c 20 2a 2f 0d 0a 2f 2a | SET NUL|L */../*|
|000031e0| 20 41 70 70 6c 69 63 61 | 74 69 6f 6e 20 73 70 65 | Applica|tion spe|
|000031f0| 63 69 66 69 63 2e 20 20 | 4c 65 66 74 20 6f 75 74 |cific. |Left out|
|00003200| 20 69 6e 74 65 6e 74 69 | 6f 6e 61 6c 6c 79 2e 20 | intenti|onally. |
|00003210| 2a 2f 26 27 03 00 15 00 | 50 41 52 45 4e 54 20 49 |*/&'....|PARENT I|
|00003220| 4e 53 45 52 54 20 43 41 | 53 43 41 44 45 8e 00 2f |NSERT CA|SCADE../|
|00003230| 2a 20 45 52 77 69 6e 20 | 42 75 69 6c 74 69 6e 20 |* ERwin |Builtin |
|00003240| 25 44 61 74 65 74 69 6d | 65 20 2a 2f 0d 0a 2f 2a |%Datetim|e */../*|
|00003250| 20 25 50 61 72 65 6e 74 | 20 25 56 65 72 62 50 68 | %Parent| %VerbPh|
|00003260| 72 61 73 65 20 25 43 68 | 69 6c 64 20 4f 4e 20 50 |rase %Ch|ild ON P|
|00003270| 41 52 45 4e 54 20 49 4e | 53 45 52 54 20 43 41 53 |ARENT IN|SERT CAS|
|00003280| 43 41 44 45 20 2a 2f 0d | 0a 2f 2a 20 41 70 70 6c |CADE */.|./* Appl|
|00003290| 69 63 61 74 69 6f 6e 20 | 73 70 65 63 69 66 69 63 |ication |specific|
|000032a0| 2e 20 20 4c 65 66 74 20 | 6f 75 74 20 69 6e 74 65 |. Left |out inte|
|000032b0| 6e 74 69 6f 6e 61 6c 6c | 79 2e 20 2a 2f 25 27 02 |ntionall|y. */%'.|
|000032c0| 00 03 00 0d 00 54 65 6d | 70 6c 61 74 65 20 4e 61 |.....Tem|plate Na|
|000032d0| 6d 65 22 00 00 00 00 02 | 00 0f 00 54 65 6d 70 6c |me".....|...Templ|
|000032e0| 61 74 65 20 48 61 6e 64 | 6c 65 00 00 00 00 00 00 |ate Hand|le......|
|000032f0| 00 03 00 01 00 0c 00 50 | 75 72 70 6f 73 65 20 54 |.......P|urpose T|
|00003300| 65 78 74 22 00 00 00 00 | 00 00 07 00 50 75 72 70 |ext"....|....Purp|
|00003310| 6f 73 65 00 00 00 00 00 | 02 00 0f 00 54 65 6d 70 |ose.....|....Temp|
|00003320| 6c 61 74 65 20 48 61 6e | 64 6c 65 22 00 00 00 00 |late Han|dle"....|
|00003330| 21 00 03 00 14 00 43 48 | 49 4c 44 20 44 45 4c 45 |!.....CH|ILD DELE|
|00003340| 54 45 20 43 41 53 43 41 | 44 45 21 27 21 27 ff ff |TE CASCA|DE!'!'..|
|00003350| 03 00 15 00 43 48 49 4c | 44 20 44 45 4c 45 54 45 |....CHIL|D DELETE|
|00003360| 20 52 45 53 54 52 49 43 | 54 20 27 20 27 ff ff 03 | RESTRIC|T ' '...|
|00003370| 00 18 00 43 48 49 4c 44 | 20 44 45 4c 45 54 45 20 |...CHILD| DELETE |
|00003380| 53 45 54 20 44 45 46 41 | 55 4c 54 23 27 23 27 ff |SET DEFA|ULT#'#'.|
|00003390| ff 03 00 15 00 43 48 49 | 4c 44 20 44 45 4c 45 54 |.....CHI|LD DELET|
|000033a0| 45 20 53 45 54 20 4e 55 | 4c 4c 22 27 22 27 ff ff |E SET NU|LL"'"'..|
|000033b0| 03 00 14 00 43 48 49 4c | 44 20 49 4e 53 45 52 54 |....CHIL|D INSERT|
|000033c0| 20 43 41 53 43 41 44 45 | 19 27 19 27 ff ff 03 00 | CASCADE|.'.'....|
|000033d0| 15 00 43 48 49 4c 44 20 | 49 4e 53 45 52 54 20 52 |..CHILD |INSERT R|
|000033e0| 45 53 54 52 49 43 54 18 | 27 18 27 ff ff 03 00 18 |ESTRICT.|'.'.....|
|000033f0| 00 43 48 49 4c 44 20 49 | 4e 53 45 52 54 20 53 45 |.CHILD I|NSERT SE|
|00003400| 54 20 44 45 46 41 55 4c | 54 1b 27 1b 27 ff ff 03 |T DEFAUL|T.'.'...|
|00003410| 00 15 00 43 48 49 4c 44 | 20 49 4e 53 45 52 54 20 |...CHILD| INSERT |
|00003420| 53 45 54 20 4e 55 4c 4c | 1a 27 1a 27 ff ff 03 00 |SET NULL|.'.'....|
|00003430| 14 00 43 48 49 4c 44 20 | 55 50 44 41 54 45 20 43 |..CHILD |UPDATE C|
|00003440| 41 53 43 41 44 45 1d 27 | 1d 27 ff ff 03 00 15 00 |ASCADE.'|.'......|
|00003450| 43 48 49 4c 44 20 55 50 | 44 41 54 45 20 52 45 53 |CHILD UP|DATE RES|
|00003460| 54 52 49 43 54 1c 27 1c | 27 ff ff 03 00 18 00 43 |TRICT.'.|'......C|
|00003470| 48 49 4c 44 20 55 50 44 | 41 54 45 20 53 45 54 20 |HILD UPD|ATE SET |
|00003480| 44 45 46 41 55 4c 54 1f | 27 1f 27 ff ff 03 00 15 |DEFAULT.|'.'.....|
|00003490| 00 43 48 49 4c 44 20 55 | 50 44 41 54 45 20 53 45 |.CHILD U|PDATE SE|
|000034a0| 54 20 4e 55 4c 4c 1e 27 | 1e 27 ff ff 03 00 1b 00 |T NULL.'|.'......|
|000034b0| 43 55 53 54 4f 4d 20 54 | 52 49 47 47 45 52 20 44 |CUSTOM T|RIGGER D|
|000034c0| 45 46 41 55 4c 54 20 42 | 4f 44 59 30 27 30 27 ff |EFAULT B|ODY0'0'.|
|000034d0| ff 03 00 15 00 43 55 53 | 54 4f 4d 20 54 52 49 47 |.....CUS|TOM TRIG|
|000034e0| 47 45 52 20 46 4f 4f 54 | 45 52 2f 27 2f 27 ff ff |GER FOOT|ER/'/'..|
|000034f0| 03 00 15 00 43 55 53 54 | 4f 4d 20 54 52 49 47 47 |....CUST|OM TRIGG|
|00003500| 45 52 20 48 45 41 44 45 | 52 2e 27 2e 27 ff ff 03 |ER HEADE|R.'.'...|
|00003510| 00 15 00 50 41 52 45 4e | 54 20 44 45 4c 45 54 45 |...PAREN|T DELETE|
|00003520| 20 43 41 53 43 41 44 45 | 15 27 15 27 ff ff 03 00 | CASCADE|.'.'....|
|00003530| 16 00 50 41 52 45 4e 54 | 20 44 45 4c 45 54 45 20 |..PARENT| DELETE |
|00003540| 52 45 53 54 52 49 43 54 | 14 27 14 27 ff ff 03 00 |RESTRICT|.'.'....|
|00003550| 19 00 50 41 52 45 4e 54 | 20 44 45 4c 45 54 45 20 |..PARENT| DELETE |
|00003560| 53 45 54 20 44 45 46 41 | 55 4c 54 17 27 17 27 ff |SET DEFA|ULT.'.'.|
|00003570| ff 03 00 16 00 50 41 52 | 45 4e 54 20 44 45 4c 45 |.....PAR|ENT DELE|
|00003580| 54 45 20 53 45 54 20 4e | 55 4c 4c 16 27 16 27 ff |TE SET N|ULL.'.'.|
|00003590| ff 03 00 15 00 50 41 52 | 45 4e 54 20 49 4e 53 45 |.....PAR|ENT INSE|
|000035a0| 52 54 20 43 41 53 43 41 | 44 45 25 27 25 27 ff ff |RT CASCA|DE%'%'..|
|000035b0| 03 00 16 00 50 41 52 45 | 4e 54 20 49 4e 53 45 52 |....PARE|NT INSER|
|000035c0| 54 20 52 45 53 54 52 49 | 43 54 24 27 24 27 ff ff |T RESTRI|CT$'$'..|
|000035d0| 03 00 19 00 50 41 52 45 | 4e 54 20 49 4e 53 45 52 |....PARE|NT INSER|
|000035e0| 54 20 53 45 54 20 44 45 | 46 41 55 4c 54 27 27 27 |T SET DE|FAULT'''|
|000035f0| 27 ff ff 03 00 16 00 50 | 41 52 45 4e 54 20 49 4e |'......P|ARENT IN|
|00003600| 53 45 52 54 20 53 45 54 | 20 4e 55 4c 4c 26 27 26 |SERT SET| NULL&'&|
|00003610| 27 ff ff 03 00 15 00 50 | 41 52 45 4e 54 20 55 50 |'......P|ARENT UP|
|00003620| 44 41 54 45 20 43 41 53 | 43 41 44 45 11 27 11 27 |DATE CAS|CADE.'.'|
|00003630| ff ff 03 00 16 00 50 41 | 52 45 4e 54 20 55 50 44 |......PA|RENT UPD|
|00003640| 41 54 45 20 52 45 53 54 | 52 49 43 54 10 27 10 27 |ATE REST|RICT.'.'|
|00003650| ff ff 03 00 19 00 50 41 | 52 45 4e 54 20 55 50 44 |......PA|RENT UPD|
|00003660| 41 54 45 20 53 45 54 20 | 44 45 46 41 55 4c 54 13 |ATE SET |DEFAULT.|
|00003670| 27 13 27 ff ff 03 00 16 | 00 50 41 52 45 4e 54 20 |'.'.....|.PARENT |
|00003680| 55 50 44 41 54 45 20 53 | 45 54 20 4e 55 4c 4c 12 |UPDATE S|ET NULL.|
|00003690| 27 12 27 ff ff 03 00 15 | 00 54 52 49 47 47 45 52 |'.'.....|.TRIGGER|
|000036a0| 20 44 45 4c 45 54 45 20 | 46 4f 4f 54 45 52 2b 27 | DELETE |FOOTER+'|
|000036b0| 2b 27 ff ff 03 00 15 00 | 54 52 49 47 47 45 52 20 |+'......|TRIGGER |
|000036c0| 44 45 4c 45 54 45 20 48 | 45 41 44 45 52 2a 27 2a |DELETE H|EADER*'*|
|000036d0| 27 ff ff 03 00 15 00 54 | 52 49 47 47 45 52 20 49 |'......T|RIGGER I|
|000036e0| 4e 53 45 52 54 20 46 4f | 4f 54 45 52 2d 27 2d 27 |NSERT FO|OTER-'-'|
|000036f0| ff ff 03 00 15 00 54 52 | 49 47 47 45 52 20 49 4e |......TR|IGGER IN|
|00003700| 53 45 52 54 20 48 45 41 | 44 45 52 2c 27 2c 27 ff |SERT HEA|DER,','.|
|00003710| ff 03 00 15 00 54 52 49 | 47 47 45 52 20 55 50 44 |.....TRI|GGER UPD|
|00003720| 41 54 45 20 46 4f 4f 54 | 45 52 29 27 29 27 ff ff |ATE FOOT|ER)')'..|
|00003730| 03 00 15 00 54 52 49 47 | 47 45 52 20 55 50 44 41 |....TRIG|GER UPDA|
|00003740| 54 45 20 48 45 41 44 45 | 52 28 27 28 27 ff ff 10 |TE HEADE|R('('...|
|00003750| 27 14 27 18 27 1c 27 00 | 00 00 00 00 00 12 27 16 |'.'.'.'.|......'.|
|00003760| 27 1a 27 1e 27 00 00 00 | 00 00 00 10 27 14 27 18 |'.'.'...|....'.'.|
|00003770| 27 1c 27 00 00 00 00 00 | 00 11 27 15 27 18 27 1c |'.'.....|..'.'.'.|
|00003780| 27 00 00 00 00 00 00 04 | 00 55 00 04 00 72 61 74 |'.......|.U...rat|
|00003790| 65 00 00 00 00 0d 00 5e | 00 04 00 6e 61 6d 65 00 |e......^|...name.|
|000037a0| 00 00 00 13 00 5f 00 12 | 00 74 72 75 65 20 63 6f |....._..|.true co|
|000037b0| 6e 64 69 74 69 6f 6e 20 | 69 6e 64 00 00 00 00 16 |ndition |ind.....|
|000037c0| 00 55 00 14 00 62 65 67 | 69 6e 20 65 66 66 65 63 |.U...beg|in effec|
|000037d0| 74 69 76 65 20 64 61 74 | 65 00 00 00 00 17 00 55 |tive dat|e......U|
|000037e0| 00 12 00 65 6e 64 20 65 | 66 66 65 63 74 69 76 65 |...end e|ffective|
|000037f0| 20 64 61 74 65 00 00 00 | 00 19 00 5e 00 0b 00 70 | date...|...^...p|
|00003800| 72 6f 76 69 64 65 72 20 | 69 64 00 00 00 00 1a 00 |rovider |id......|
|00003810| 5e 00 14 00 73 74 61 6e | 64 61 72 64 20 73 79 73 |^...stan|dard sys|
|00003820| 74 65 6d 20 63 6f 64 65 | 00 00 00 00 1b 00 55 00 |tem code|......U.|
|00003830| 0f 00 63 61 74 61 6c 6f | 67 5f 72 61 74 65 5f 69 |..catalo|g_rate_i|
|00003840| 64 00 00 00 00 23 00 63 | 00 04 00 74 79 70 65 00 |d....#.c|...type.|
|00003850| 00 00 00 24 00 63 00 04 | 00 6e 61 6d 65 00 00 00 |...$.c..|.name...|
|00003860| 00 25 00 64 00 0f 00 72 | 75 6c 65 20 62 65 67 69 |.%.d...r|ule begi|
|00003870| 6e 20 64 61 74 65 00 00 | 00 00 26 00 64 00 0d 00 |n date..|..&.d...|
|00003880| 72 75 6c 65 20 65 6e 64 | 20 64 61 74 65 00 00 00 |rule end| date...|
|00003890| 00 28 00 63 00 11 00 72 | 61 74 65 20 72 75 6c 65 |.(.c...r|ate rule|
|000038a0| 20 74 79 70 65 20 69 64 | 00 00 00 00 2b 00 67 00 | type id|....+.g.|
|000038b0| 11 00 70 65 72 20 75 6e | 69 74 20 72 61 74 65 20 |..per un|it rate |
|000038c0| 69 6e 64 00 00 00 00 2c | 00 67 00 0f 00 74 69 65 |ind....,|.g...tie|
|000038d0| 72 65 64 20 72 61 74 65 | 20 69 6e 64 00 00 00 00 |red rate| ind....|
|000038e0| 2d 00 67 00 0a 00 6c 6f | 77 20 61 6d 6f 75 6e 74 |-.g...lo|w amount|
|000038f0| 00 00 00 00 2e 00 67 00 | 0b 00 68 69 67 68 20 61 |......g.|..high a|
|00003900| 6d 6f 75 6e 74 00 00 00 | 00 2f 00 65 00 0f 00 72 |mount...|./.e...r|
|00003910| 75 6c 65 20 62 65 67 69 | 6e 20 74 69 6d 65 00 00 |ule begi|n time..|
|00003920| 00 00 30 00 65 00 0d 00 | 72 75 6c 65 20 65 6e 64 |..0.e...|rule end|
|00003930| 20 74 69 6d 65 00 00 00 | 00 54 00 74 00 06 00 63 | time...|.T.t...c|
|00003940| 6f 75 6e 74 79 00 00 00 | 00 55 00 74 00 0b 00 70 |ounty...|.U.t...p|
|00003950| 6f 73 74 61 6c 20 63 6f | 64 65 00 00 00 00 58 00 |ostal co|de....X.|
|00003960| 74 00 08 00 7a 69 70 20 | 63 6f 64 65 00 00 00 00 |t...zip |code....|
|00003970| 59 00 74 00 0c 00 63 6f | 75 6e 74 72 79 20 6e 61 |Y.t...co|untry na|
|00003980| 6d 65 00 00 00 00 5a 00 | 74 00 05 00 73 74 61 74 |me....Z.|t...stat|
|00003990| 65 00 00 00 00 5b 00 74 | 00 04 00 63 69 74 79 00 |e....[.t|...city.|
|000039a0| 00 00 00 5c 00 74 00 0e | 00 75 6e 69 74 20 74 79 |...\.t..|.unit ty|
|000039b0| 70 65 20 63 6f 64 65 00 | 00 00 00 5d 00 74 00 0f |pe code.|...].t..|
|000039c0| 00 75 6e 69 74 20 69 64 | 65 6e 74 69 66 69 65 72 |.unit id|entifier|
|000039d0| 00 00 00 00 5e 00 74 00 | 0a 00 74 72 61 63 74 20 |....^.t.|..tract |
|000039e0| 63 6f 64 65 00 00 00 00 | 5f 00 74 00 13 00 73 74 |code....|_.t...st|
|000039f0| 72 75 63 74 75 72 65 20 | 74 79 70 65 20 63 6f 64 |ructure |type cod|
|00003a00| 65 00 00 00 00 60 00 74 | 00 14 00 73 74 72 75 63 |e....`.t|...struc|
|00003a10| 74 75 72 65 20 69 64 65 | 6e 74 69 66 69 65 72 00 |ture ide|ntifier.|
|00003a20| 00 00 00 61 00 74 00 19 | 00 73 74 72 65 65 74 20 |...a.t..|.street |
|00003a30| 73 75 66 66 69 78 20 64 | 69 72 65 63 74 69 6f 6e |suffix d|irection|
|00003a40| 61 6c 00 00 00 00 62 00 | 74 00 0d 00 73 74 72 65 |al....b.|t...stre|
|00003a50| 65 74 20 73 75 66 66 69 | 78 00 00 00 00 63 00 74 |et suffi|x....c.t|
|00003a60| 00 18 00 73 74 72 65 65 | 74 20 6e 75 6d 62 65 72 |...stree|t number|
|00003a70| 20 66 72 61 63 74 69 6f | 6e 61 6c 00 00 00 00 64 | fractio|nal....d|
|00003a80| 00 74 00 0d 00 73 74 72 | 65 65 74 20 6e 75 6d 62 |.t...str|eet numb|
|00003a90| 65 72 00 00 00 00 65 00 | 74 00 0b 00 73 74 72 65 |er....e.|t...stre|
|00003aa0| 65 74 20 6e 61 6d 65 00 | 00 00 00 79 00 7c 00 0d |et name.|...y.|..|
|00003ab0| 00 64 61 74 65 20 6f 66 | 20 62 69 72 74 68 00 00 |.date of| birth..|
|00003ac0| 00 00 7b 00 7c 00 0b 00 | 6e 61 6d 65 20 73 75 66 |..{.|...|name suf|
|00003ad0| 66 69 78 00 00 00 00 7d | 00 7c 00 08 00 6e 69 63 |fix....}|.|...nic|
|00003ae0| 6b 6e 61 6d 65 00 00 00 | 00 7e 00 7d 00 06 00 74 |kname...|.~.}...t|
|00003af0| 61 78 20 69 64 00 00 00 | 00 80 00 7d 00 0f 00 63 |ax id...|...}...c|
|00003b00| 6f 6e 74 72 61 63 74 20 | 6e 75 6d 62 65 72 00 00 |ontract |number..|
|00003b10| 00 00 81 00 7d 00 15 00 | 68 6f 6d 65 20 6f 66 66 |....}...|home off|
|00003b20| 69 63 65 20 69 6e 64 69 | 63 61 74 6f 72 00 00 00 |ice indi|cator...|
|00003b30| 00 82 00 7d 00 18 00 73 | 74 61 6e 64 61 72 64 20 |...}...s|tandard |
|00003b40| 69 6e 64 75 73 74 72 69 | 61 6c 20 63 6f 64 65 00 |industri|al code.|
|00003b50| 00 00 00 84 00 7e 00 11 | 00 74 61 78 20 65 78 65 |.....~..|.tax exe|
|00003b60| 6d 70 74 20 6e 75 6d 62 | 65 72 00 00 00 00 85 00 |mpt numb|er......|
|00003b70| 7e 00 0f 00 74 61 78 20 | 65 78 65 6d 70 74 20 63 |~...tax |exempt c|
|00003b80| 6f 64 65 00 00 00 00 87 | 00 7f 00 12 00 65 6e 64 |ode.....|.....end|
|00003b90| 20 65 66 66 65 63 74 69 | 76 65 20 64 61 74 65 00 | effecti|ve date.|
|00003ba0| 00 00 00 88 00 7f 00 14 | 00 62 65 67 69 6e 20 65 |........|.begin e|
|00003bb0| 66 66 65 63 74 69 76 65 | 20 64 61 74 65 00 00 00 |ffective| date...|
|00003bc0| 00 89 00 7f 00 0b 00 73 | 74 61 74 75 73 20 63 6f |.......s|tatus co|
|00003bd0| 64 65 00 00 00 00 93 00 | 87 00 12 00 74 65 72 6d |de......|....term|
|00003be0| 69 6e 61 74 69 6f 6e 20 | 72 65 61 73 6f 6e 00 00 |ination |reason..|
|00003bf0| 00 00 94 00 87 00 10 00 | 74 65 72 6d 69 6e 61 74 |........|terminat|
|00003c00| 69 6f 6e 20 64 61 74 65 | 00 00 00 00 95 00 87 00 |ion date|........|
|00003c10| 16 00 65 66 66 65 63 74 | 69 76 65 20 62 69 6c 6c |..effect|ive bill|
|00003c20| 69 6e 67 20 64 61 74 65 | 00 00 00 00 97 00 88 00 |ing date|........|
|00003c30| 0b 00 73 74 61 74 75 73 | 20 63 6f 64 65 00 00 00 |..status| code...|
|00003c40| 00 9b 00 89 00 08 00 71 | 75 61 6e 74 69 74 79 00 |.......q|uantity.|
|00003c50| 00 00 00 9c 00 88 00 08 | 00 6f 72 64 65 72 20 69 |........|.order i|
|00003c60| 64 00 00 00 00 9d 00 89 | 00 0b 00 69 74 65 6d 20 |d.......|...item |
|00003c70| 6e 75 6d 62 65 72 00 00 | 00 00 a3 00 8c 00 0b 00 |number..|........|
|00003c80| 6c 69 6e 65 20 6e 75 6d | 62 65 72 00 00 00 00 a9 |line num|ber.....|
|00003c90| 00 8c 00 13 00 74 65 6c | 65 70 68 6f 6e 65 20 6e |.....tel|ephone n|
|00003ca0| 75 6d 62 65 72 20 69 64 | 00 00 00 00 af 00 8f 00 |umber id|........|
|00003cb0| 12 00 72 65 6c 61 74 65 | 64 20 70 72 6f 64 75 63 |..relate|d produc|
|00003cc0| 74 20 69 64 00 00 00 00 | bc 00 8c 00 08 00 6e 70 |t id....|......np|
|00003cd0| 61 20 63 6f 64 65 00 00 | 00 00 bd 00 8c 00 07 00 |a code..|........|
|00003ce0| 6e 70 61 20 6e 78 78 00 | 00 00 00 cc 00 7e 00 06 |npa nxx.|.....~..|
|00003cf0| 00 74 61 78 20 69 64 00 | 00 00 00 d5 00 67 00 0d |.tax id.|.....g..|
|00003d00| 00 6e 75 6d 20 70 72 65 | 63 69 73 69 6f 6e 00 00 |.num pre|cision..|
|00003d10| 00 00 d6 00 67 00 09 00 | 6e 75 6d 20 73 63 61 6c |....g...|num scal|
|00003d20| 65 00 00 00 00 f1 00 73 | 00 10 00 74 65 6c 65 70 |e......s|...telep|
|00003d30| 68 6f 6e 65 20 6e 75 6d | 62 65 72 00 00 00 00 f2 |hone num|ber.....|
|00003d40| 00 73 00 17 00 74 65 6c | 65 70 68 6f 6e 65 20 6e |.s...tel|ephone n|
|00003d50| 75 6d 62 65 72 20 73 75 | 66 66 69 78 00 00 00 00 |umber su|ffix....|
|00003d60| f7 00 7c 00 09 00 6c 61 | 73 74 20 6e 61 6d 65 00 |..|...la|st name.|
|00003d70| 00 00 00 f8 00 7c 00 0a | 00 66 69 72 73 74 20 6e |.....|..|.first n|
|00003d80| 61 6d 65 00 00 00 00 f9 | 00 7c 00 05 00 74 69 74 |ame.....|.|...tit|
|00003d90| 6c 65 00 00 00 00 fa 00 | 7c 00 0b 00 67 65 6e 64 |le......||...gend|
|00003da0| 65 72 20 74 79 70 65 00 | 00 00 00 fb 00 7c 00 0f |er type.|.....|..|
|00003db0| 00 65 6d 70 6c 6f 79 6d | 65 6e 74 20 74 79 70 65 |.employm|ent type|
|00003dc0| 00 00 00 00 04 01 98 00 | 0f 00 63 72 65 64 69 74 |........|..credit|
|00003dd0| 20 72 65 66 20 64 61 74 | 65 00 00 00 00 05 01 98 | ref dat|e.......|
|00003de0| 00 18 00 63 72 65 64 69 | 74 20 72 65 66 20 61 63 |...credi|t ref ac|
|00003df0| 63 74 20 65 78 70 20 64 | 61 74 65 00 00 00 00 06 |ct exp d|ate.....|
|00003e00| 01 98 00 0f 00 63 72 65 | 64 69 74 20 72 65 66 20 |.....cre|dit ref |
|00003e10| 74 79 70 65 00 00 00 00 | 07 01 98 00 0f 00 63 72 |type....|......cr|
|00003e20| 65 64 69 74 20 72 65 66 | 20 6e 61 6d 65 00 00 00 |edit ref| name...|
|00003e30| 00 08 01 98 00 19 00 63 | 72 65 64 69 74 20 72 65 |.......c|redit re|
|00003e40| 66 20 61 63 63 6f 75 6e | 74 20 6e 75 6d 62 65 72 |f accoun|t number|
|00003e50| 00 00 00 00 0b 01 7d 00 | 16 00 6f 72 67 61 6e 69 |......}.|..organi|
|00003e60| 7a 61 74 69 6f 6e 20 74 | 79 70 65 20 63 6f 64 65 |zation t|ype code|
|00003e70| 00 00 00 00 0d 01 7d 00 | 04 00 6e 61 6d 65 00 00 |......}.|..name..|
|00003e80| 00 00 14 01 9c 00 14 00 | 64 65 66 65 72 72 65 64 |........|deferred|
|00003e90| 20 64 65 70 6f 73 69 74 | 20 69 6e 64 00 00 00 00 | deposit| ind....|
|00003ea0| 15 01 9c 00 17 00 64 65 | 66 65 72 72 65 64 20 64 |......de|ferred d|
|00003eb0| 65 70 6f 73 69 74 20 70 | 65 72 69 6f 64 00 00 00 |eposit p|eriod...|
|00003ec0| 00 1a 01 9a 00 11 00 72 | 65 6c 61 74 69 6f 6e 73 |.......r|elations|
|00003ed0| 68 69 70 20 63 6f 64 65 | 00 00 00 00 1b 01 8f 00 |hip code|........|
|00003ee0| 11 00 72 65 6c 61 74 69 | 6f 6e 73 68 69 70 20 63 |..relati|onship c|
|00003ef0| 6f 64 65 00 00 00 00 20 | 01 9d 00 14 00 62 65 67 |ode.... |.....beg|
|00003f00| 69 6e 20 65 66 66 65 63 | 74 69 76 65 20 64 61 74 |in effec|tive dat|
|00003f10| 65 00 00 00 00 21 01 9d | 00 12 00 65 6e 64 20 65 |e....!..|...end e|
|00003f20| 66 66 65 63 74 69 76 65 | 20 64 61 74 65 00 00 00 |ffective| date...|
|00003f30| 00 22 01 9d 00 04 00 72 | 61 74 65 00 00 00 00 2d |.".....r|ate....-|
|00003f40| 01 9f 00 0a 00 70 72 6f | 64 75 63 74 20 69 64 00 |.....pro|duct id.|
|00003f50| 00 00 00 31 01 a1 00 09 | 00 63 61 72 64 20 74 79 |...1....|.card ty|
|00003f60| 70 65 00 00 00 00 32 01 | a1 00 0b 00 63 61 72 64 |pe....2.|....card|
|00003f70| 20 6e 75 6d 62 65 72 00 | 00 00 00 33 01 a1 00 0b | number.|...3....|
|00003f80| 00 68 6f 6c 64 65 72 20 | 6e 61 6d 65 00 00 00 00 |.holder |name....|
|00003f90| 34 01 a1 00 0f 00 65 78 | 70 69 72 61 74 69 6f 6e |4.....ex|piration|
|00003fa0| 20 64 61 74 65 00 00 00 | 00 37 01 9c 00 10 00 64 | date...|.7.....d|
|00003fb0| 69 73 70 6f 73 69 74 69 | 6f 6e 20 64 61 74 65 00 |ispositi|on date.|
|00003fc0| 00 00 00 39 01 9c 00 0c | 00 64 65 70 6f 73 69 74 |...9....|.deposit|
|00003fd0| 20 74 79 70 65 00 00 00 | 00 3a 01 9c 00 10 00 64 | type...|.:.....d|
|00003fe0| 69 73 70 6f 73 69 74 69 | 6f 6e 20 74 79 70 65 00 |ispositi|on type.|
|00003ff0| 00 00 00 41 01 55 00 0c | 00 66 72 61 6e 63 68 69 |...A.U..|.franchi|
|00004000| 73 65 20 69 64 00 00 00 | 00 49 01 a4 00 13 00 6c |se id...|.I.....l|
|00004010| 61 6e 67 75 61 67 65 20 | 70 72 65 66 65 72 65 6e |anguage |preferen|
|00004020| 63 65 00 00 00 00 4a 01 | a4 00 09 00 6e 6f 20 63 |ce....J.|....no c|
|00004030| 6f 70 69 65 73 00 00 00 | 00 4b 01 a4 00 0b 00 73 |opies...|.K.....s|
|00004040| 74 75 66 66 65 72 20 69 | 6e 64 00 00 00 00 4c 01 |tuffer i|nd....L.|
|00004050| a5 00 09 00 62 69 6c 6c | 20 64 61 74 65 00 00 00 |....bill| date...|
|00004060| 00 4d 01 a5 00 0b 00 62 | 69 6c 6c 20 61 6d 6f 75 |.M.....b|ill amou|
|00004070| 6e 74 00 00 00 00 4e 01 | a5 00 0e 00 61 64 6a 75 |nt....N.|....adju|
|00004080| 73 74 6d 65 6e 74 20 61 | 6d 74 00 00 00 00 4f 01 |stment a|mt....O.|
|00004090| a5 00 13 00 61 64 6a 75 | 73 74 6d 65 6e 74 20 72 |....adju|stment r|
|000040a0| 73 6e 20 63 6f 64 65 00 | 00 00 00 50 01 a5 00 0f |sn code.|...P....|
|000040b0| 00 61 64 6a 75 73 74 6d | 65 6e 74 20 64 61 74 65 |.adjustm|ent date|
|000040c0| 00 00 00 00 55 01 a7 00 | 0a 00 6d 65 73 73 61 67 |....U...|..messag|
|000040d0| 65 20 69 64 00 00 00 00 | 56 01 a7 00 14 00 62 65 |e id....|V.....be|
|000040e0| 67 69 6e 20 65 66 66 65 | 63 74 69 76 65 20 64 61 |gin effe|ctive da|
|000040f0| 74 65 00 00 00 00 57 01 | a7 00 12 00 65 6e 64 20 |te....W.|....end |
|00004100| 65 66 66 65 63 74 69 76 | 65 20 64 61 74 65 00 00 |effectiv|e date..|
|00004110| 00 00 58 01 a7 00 0e 00 | 62 69 6c 6c 20 70 6c 61 |..X.....|bill pla|
|00004120| 63 65 6d 65 6e 74 00 00 | 00 00 59 01 a7 00 0c 00 |cement..|..Y.....|
|00004130| 6d 65 73 73 61 67 65 20 | 74 65 78 74 00 00 00 00 |message |text....|
|00004140| 5a 01 a8 00 0f 00 72 65 | 6d 69 74 74 61 6e 63 65 |Z.....re|mittance|
|00004150| 20 64 61 74 65 00 00 00 | 00 5b 01 a8 00 0e 00 72 | date...|.[.....r|
|00004160| 65 6d 69 74 74 61 6e 63 | 65 20 61 6d 74 00 00 00 |emittanc|e amt...|
|00004170| 00 5c 01 a8 00 0c 00 64 | 69 73 70 75 74 65 64 20 |.\.....d|isputed |
|00004180| 61 6d 74 00 00 00 00 5d | 01 a8 00 11 00 64 69 73 |amt....]|.....dis|
|00004190| 70 75 74 65 64 20 72 73 | 6e 20 63 6f 64 65 00 00 |puted rs|n code..|
|000041a0| 00 00 5e 01 a8 00 0d 00 | 64 69 73 70 75 74 65 64 |..^.....|disputed|
|000041b0| 20 64 61 74 65 00 00 00 | 00 5f 01 a8 00 07 00 63 | date...|._.....c|
|000041c0| 6f 6d 6d 65 6e 74 00 00 | 00 00 64 01 a9 00 0c 00 |omment..|..d.....|
|000041d0| 64 69 73 70 75 74 65 64 | 20 61 6d 74 00 00 00 00 |disputed| amt....|
|000041e0| 6f 01 a4 00 0f 00 62 69 | 6c 6c 20 6d 65 64 69 61 |o.....bi|ll media|
|000041f0| 20 63 6f 64 65 00 00 00 | 00 71 01 ab 00 09 00 62 | code...|.q.....b|
|00004200| 61 6e 6b 20 6e 61 6d 65 | 00 00 00 00 72 01 ab 00 |ank name|....r...|
|00004210| 06 00 61 63 68 20 69 64 | 00 00 00 00 73 01 ab 00 |..ach id|....s...|
|00004220| 13 00 62 61 6e 6b 20 61 | 63 63 6f 75 6e 74 20 6e |..bank a|ccount n|
|00004230| 75 6d 62 65 72 00 00 00 | 00 75 01 ac 00 08 00 63 |umber...|.u.....c|
|00004240| 79 63 6c 65 20 69 64 00 | 00 00 00 76 01 ac 00 14 |ycle id.|...v....|
|00004250| 00 62 65 67 69 6e 20 65 | 66 66 65 63 74 69 76 65 |.begin e|ffective|
|00004260| 20 64 61 74 65 00 00 00 | 00 77 01 ac 00 12 00 65 | date...|.w.....e|
|00004270| 6e 64 20 65 66 66 65 63 | 74 69 76 65 20 64 61 74 |nd effec|tive dat|
|00004280| 65 00 00 00 00 78 01 ac | 00 09 00 62 69 6c 6c 20 |e....x..|...bill |
|00004290| 64 61 74 65 00 00 00 00 | 79 01 ac 00 08 00 64 75 |date....|y.....du|
|000042a0| 65 20 64 61 74 65 00 00 | 00 00 80 01 b1 00 08 00 |e date..|........|
|000042b0| 6f 63 63 20 74 79 70 65 | 00 00 00 00 81 01 b1 00 |occ type|........|
|000042c0| 0a 00 6f 63 63 20 61 6d | 6f 75 6e 74 00 00 00 00 |..occ am|ount....|
|000042d0| 82 01 b1 00 0f 00 6f 63 | 63 20 64 65 73 63 72 69 |......oc|c descri|
|000042e0| 70 74 69 6f 6e 00 00 00 | 00 83 01 b1 00 08 00 6f |ption...|.......o|
|000042f0| 63 63 20 64 61 74 65 00 | 00 00 00 87 01 87 00 08 |cc date.|........|
|00004300| 00 71 75 61 6e 74 69 74 | 79 00 00 00 00 8b 01 8b |.quantit|y.......|
|00004310| 00 0f 00 74 61 78 20 65 | 78 65 6d 70 74 20 63 6f |...tax e|xempt co|
|00004320| 64 65 00 00 00 00 8d 01 | b2 00 12 00 73 65 72 76 |de......|....serv|
|00004330| 69 63 65 20 61 64 64 72 | 65 73 73 20 69 64 00 00 |ice addr|ess id..|
|00004340| 00 00 8e 01 b2 00 13 00 | 73 74 72 65 65 74 20 6e |........|street n|
|00004350| 61 6d 65 20 73 6f 75 6e | 64 65 78 00 00 00 00 8f |ame soun|dex.....|
|00004360| 01 b2 00 0b 00 73 74 72 | 65 65 74 20 6e 61 6d 65 |.....str|eet name|
|00004370| 00 00 00 00 90 01 b2 00 | 0d 00 73 74 72 65 65 74 |........|..street|
|00004380| 20 6e 75 6d 62 65 72 00 | 00 00 00 92 01 b2 00 0d | number.|........|
|00004390| 00 73 74 72 65 65 74 20 | 73 75 66 66 69 78 00 00 |.street |suffix..|
|000043a0| 00 00 93 01 b2 00 19 00 | 73 74 72 65 65 74 20 73 |........|street s|
|000043b0| 75 66 66 69 78 20 64 69 | 72 65 63 74 69 6f 6e 61 |uffix di|rectiona|
|000043c0| 6c 00 00 00 00 94 01 b2 | 00 14 00 73 74 72 75 63 |l.......|...struc|
|000043d0| 74 75 72 65 20 69 64 65 | 6e 74 69 66 69 65 72 00 |ture ide|ntifier.|
|000043e0| 00 00 00 95 01 b2 00 13 | 00 73 74 72 75 63 74 75 |........|.structu|
|000043f0| 72 65 20 74 79 70 65 20 | 63 6f 64 65 00 00 00 00 |re type |code....|
|00004400| 97 01 b2 00 0f 00 75 6e | 69 74 20 69 64 65 6e 74 |......un|it ident|
|00004410| 69 66 69 65 72 00 00 00 | 00 98 01 b2 00 0e 00 75 |ifier...|.......u|
|00004420| 6e 69 74 20 74 79 70 65 | 20 63 6f 64 65 00 00 00 |nit type| code...|
|00004430| 00 99 01 b2 00 04 00 63 | 69 74 79 00 00 00 00 9a |.......c|ity.....|
|00004440| 01 b2 00 05 00 73 74 61 | 74 65 00 00 00 00 9c 01 |.....sta|te......|
|00004450| b2 00 08 00 7a 69 70 20 | 63 6f 64 65 00 00 00 00 |....zip |code....|
|00004460| 9e 01 b2 00 0a 00 7a 69 | 70 20 70 6c 75 73 20 34 |......zi|p plus 4|
|00004470| 00 00 00 00 a1 01 b2 00 | 0b 00 64 69 76 69 73 69 |........|..divisi|
|00004480| 6f 6e 20 69 64 00 00 00 | 00 a2 01 b2 00 0c 00 66 |on id...|.......f|
|00004490| 72 61 6e 63 68 69 73 65 | 20 69 64 00 00 00 00 a6 |ranchise| id.....|
|000044a0| 01 74 00 0a 00 7a 69 70 | 20 70 6c 75 73 20 34 00 |.t...zip| plus 4.|
|000044b0| 00 00 00 a7 01 b2 00 06 | 00 63 6f 75 6e 74 79 00 |........|.county.|
|000044c0| 00 00 00 a8 01 9f 00 0c | 00 70 72 6f 64 75 63 74 |........|.product|
|000044d0| 20 6e 61 6d 65 00 00 00 | 00 a9 01 9f 00 12 00 70 | name...|.......p|
|000044e0| 72 6f 64 75 63 74 20 73 | 68 6f 72 74 20 6e 61 6d |roduct s|hort nam|
|000044f0| 65 00 00 00 00 aa 01 9f | 00 13 00 70 72 6f 64 75 |e.......|...produ|
|00004500| 63 74 20 64 65 73 63 72 | 69 70 74 69 6f 6e 00 00 |ct descr|iption..|
|00004510| 00 00 ab 01 9f 00 13 00 | 67 65 6e 65 72 61 6c 20 |........|general |
|00004520| 6c 65 64 67 65 72 20 63 | 6f 64 65 00 00 00 00 ac |ledger c|ode.....|
|00004530| 01 9f 00 0c 00 70 72 6f | 64 75 63 74 20 74 79 70 |.....pro|duct typ|
|00004540| 65 00 00 00 00 ad 01 b2 | 00 0d 00 63 61 72 72 69 |e.......|...carri|
|00004550| 65 72 20 72 6f 75 74 65 | 00 00 00 00 ae 01 b2 00 |er route|........|
|00004560| 0f 00 73 63 68 65 64 75 | 6c 69 6e 67 20 61 72 65 |..schedu|ling are|
|00004570| 61 00 00 00 00 b1 01 b2 | 00 07 00 63 6f 6d 70 61 |a.......|...compa|
|00004580| 6e 79 00 00 00 00 b8 01 | b3 00 0c 00 62 69 6c 6c |ny......|....bill|
|00004590| 69 6e 67 20 74 79 70 65 | 00 00 00 00 b9 01 b3 00 |ing type|........|
|000045a0| 0e 00 70 72 6f 6a 65 63 | 74 20 6e 75 6d 62 65 72 |..projec|t number|
|000045b0| 00 00 00 00 bb 01 b2 00 | 06 00 73 74 61 74 75 73 |........|..status|
|000045c0| 00 00 00 00 bc 01 b2 00 | 12 00 73 74 61 74 75 73 |........|..status|
|000045d0| 20 63 68 61 6e 67 65 20 | 64 61 74 65 00 00 00 00 | change |date....|
|000045e0| bd 01 b3 00 08 00 67 72 | 6f 75 70 20 69 64 00 00 |......gr|oup id..|
|000045f0| 00 00 be 01 b3 00 0b 00 | 65 6e 74 69 74 79 20 6e |........|entity n|
|00004600| 61 6d 65 00 00 00 00 c0 | 01 74 00 0d 00 63 61 72 |ame.....|.t...car|
|00004610| 72 69 65 72 20 72 6f 75 | 74 65 00 00 00 00 c2 01 |rier rou|te......|
|00004620| b5 00 0b 00 64 65 73 63 | 72 69 70 74 69 6f 6e 00 |....desc|ription.|
|00004630| 00 00 00 c3 01 b5 00 0a | 00 77 6f 72 6b 20 75 6e |........|.work un|
|00004640| 69 74 73 00 00 00 00 c6 | 01 be 00 0c 00 72 65 71 |its.....|.....req|
|00004650| 75 65 73 74 20 64 61 74 | 65 00 00 00 00 c7 01 bf |uest dat|e.......|
|00004660| 00 0d 00 63 61 6c 65 6e | 64 61 72 20 64 61 74 65 |...calen|dar date|
|00004670| 00 00 00 00 c8 01 bf 00 | 0e 00 64 65 66 61 75 6c |........|..defaul|
|00004680| 74 20 73 74 61 74 75 73 | 00 00 00 00 c9 01 c0 00 |t status|........|
|00004690| 0f 00 72 65 73 6f 75 72 | 63 65 20 73 74 61 74 75 |..resour|ce statu|
|000046a0| 73 00 00 00 00 ca 01 c1 | 00 0b 00 72 65 73 6f 75 |s.......|...resou|
|000046b0| 72 63 65 20 69 64 00 00 | 00 00 cc 01 c1 00 15 00 |rce id..|........|
|000046c0| 64 65 66 61 75 6c 74 20 | 68 6f 75 72 73 20 70 65 |default |hours pe|
|000046d0| 72 20 64 61 79 00 00 00 | 00 cd 01 c1 00 16 00 64 |r day...|.......d|
|000046e0| 65 66 61 75 6c 74 20 68 | 6f 75 72 73 20 70 65 72 |efault h|ours per|
|000046f0| 20 77 65 65 6b 00 00 00 | 00 d3 01 c5 00 0a 00 64 | week...|.......d|
|00004700| 65 70 61 72 74 6d 65 6e | 74 00 00 00 00 d5 01 c5 |epartmen|t.......|
|00004710| 00 0a 00 77 6f 72 6b 20 | 75 6e 69 74 73 00 00 00 |...work |units...|
|00004720| 00 d6 01 c5 00 12 00 61 | 75 74 68 6f 72 69 7a 61 |.......a|uthoriza|
|00004730| 74 69 6f 6e 20 63 6f 64 | 65 00 00 00 00 d7 01 c4 |tion cod|e.......|
|00004740| 00 12 00 64 65 66 61 75 | 6c 74 20 73 74 61 72 74 |...defau|lt start|
|00004750| 20 74 69 6d 65 00 00 00 | 00 d8 01 c4 00 10 00 64 | time...|.......d|
|00004760| 65 66 61 75 6c 74 20 65 | 6e 64 20 74 69 6d 65 00 |efault e|nd time.|
|00004770| 00 00 00 d9 01 be 00 06 | 00 73 74 61 74 75 73 00 |........|.status.|
|00004780| 00 00 00 dd 01 c6 00 06 | 00 73 74 61 74 75 73 00 |........|.status.|
|00004790| 00 00 00 e8 01 a9 00 13 | 00 61 6d 74 20 33 30 20 |........|.amt 30 |
|000047a0| 64 61 79 20 70 61 73 74 | 20 64 75 65 00 00 00 00 |day past| due....|
|000047b0| e9 01 a9 00 13 00 61 6d | 74 20 36 30 20 64 61 79 |......am|t 60 day|
|000047c0| 20 70 61 73 74 20 64 75 | 65 00 00 00 00 ea 01 a9 | past du|e.......|
|000047d0| 00 13 00 61 6d 74 20 39 | 30 20 64 61 79 20 70 61 |...amt 9|0 day pa|
|000047e0| 73 74 20 64 75 65 00 00 | 00 00 eb 01 a9 00 14 00 |st due..|........|
|000047f0| 61 6d 74 20 31 32 30 20 | 64 61 79 20 70 61 73 74 |amt 120 |day past|
|00004800| 20 64 75 65 00 00 00 00 | ec 01 b2 00 11 00 63 65 | due....|......ce|
|00004810| 6e 73 75 73 20 74 72 61 | 63 74 20 63 6f 64 65 00 |nsus tra|ct code.|
|00004820| 00 00 00 ed 01 b2 00 0c | 00 62 6c 6f 63 6b 20 6e |........|.block n|
|00004830| 75 6d 62 65 72 00 00 00 | 00 ee 01 b2 00 0c 00 62 |umber...|.......b|
|00004840| 6c 6f 63 6b 20 73 75 66 | 66 69 78 00 00 00 00 f0 |lock suf|fix.....|
|00004850| 01 b2 00 08 00 67 65 6f | 20 63 6f 64 65 00 00 00 |.....geo| code...|
|00004860| 00 f1 01 88 00 07 00 75 | 73 65 72 20 69 64 00 00 |.......u|ser id..|
|00004870| 00 00 f2 01 88 00 0c 00 | 6f 72 64 65 72 20 72 65 |........|order re|
|00004880| 61 73 6f 6e 00 00 00 00 | f3 01 c1 00 0d 00 72 65 |ason....|......re|
|00004890| 73 6f 75 72 63 65 20 74 | 79 70 65 00 00 00 00 01 |source t|ype.....|
|000048a0| 02 b2 00 19 00 73 74 72 | 65 65 74 20 70 72 65 66 |.....str|eet pref|
|000048b0| 69 78 20 64 69 72 65 63 | 74 69 6f 6e 61 6c 00 00 |ix direc|tional..|
|000048c0| 00 00 03 02 74 00 19 00 | 73 74 72 65 65 74 5f 70 |....t...|street_p|
|000048d0| 72 65 66 69 78 5f 64 69 | 72 65 63 74 69 6f 6e 61 |refix_di|rectiona|
|000048e0| 6c 00 00 00 00 18 02 d1 | 00 02 00 4c 43 00 00 00 |l.......|...LC...|
|000048f0| 00 21 02 7c 00 09 00 69 | 64 20 6e 75 6d 62 65 72 |.!.|...i|d number|
|00004900| 00 00 00 00 23 02 d3 00 | 12 00 66 65 61 74 75 72 |....#...|..featur|
|00004910| 65 20 70 72 6f 64 75 63 | 74 20 69 64 00 00 00 00 |e produc|t id....|
|00004920| 2c 02 8c 00 15 00 54 4e | 20 73 74 61 74 75 73 20 |,.....TN| status |
|00004930| 63 68 61 6e 67 65 20 64 | 61 74 65 00 00 00 00 33 |change d|ate....3|
|00004940| 02 db 00 04 00 64 61 74 | 65 00 00 00 00 34 02 db |.....dat|e....4..|
|00004950| 00 09 00 64 61 74 65 20 | 74 79 70 65 00 00 00 00 |...date |type....|
|00004960| 44 02 80 00 0d 00 63 61 | 74 65 67 6f 72 79 20 63 |D.....ca|tegory c|
|00004970| 6f 64 65 00 00 00 00 45 | 02 b5 00 0b 00 61 63 74 |ode....E|.....act|
|00004980| 69 6f 6e 20 63 6f 64 65 | 00 00 00 00 48 02 cf 00 |ion code|....H...|
|00004990| 0d 00 68 61 6e 64 69 63 | 61 70 20 63 6f 64 65 00 |..handic|ap code.|
|000049a0| 00 00 00 49 02 7c 00 07 | 00 69 64 20 74 79 70 65 |...I.|..|.id type|
|000049b0| 00 00 00 00 4d 02 8c 00 | 0f 00 6c 69 6e 65 20 63 |....M...|..line c|
|000049c0| 6c 61 73 73 20 63 6f 64 | 65 00 00 00 00 4e 02 8c |lass cod|e....N..|
|000049d0| 00 11 00 72 65 71 75 65 | 73 74 20 74 79 70 65 20 |...reque|st type |
|000049e0| 63 6f 64 65 00 00 00 00 | 4f 02 8c 00 0b 00 6e 75 |code....|O.....nu|
|000049f0| 6d 62 65 72 20 74 79 70 | 65 00 00 00 00 50 02 a4 |mber typ|e....P..|
|00004a00| 00 0f 00 70 61 79 20 6d | 65 74 68 6f 64 20 63 6f |...pay m|ethod co|
|00004a10| 64 65 00 00 00 00 51 02 | a4 00 12 00 70 61 79 20 |de....Q.|....pay |
|00004a20| 6d 65 74 68 6f 64 20 63 | 6f 6d 6d 65 6e 74 00 00 |method c|omment..|
|00004a30| 00 00 52 02 c2 00 0a 00 | 73 6b 69 6c 6c 20 63 6f |..R.....|skill co|
|00004a40| 64 65 00 00 00 00 53 02 | c5 00 0a 00 73 6b 69 6c |de....S.|....skil|
|00004a50| 6c 20 63 6f 64 65 00 00 | 00 00 56 02 8c 00 09 00 |l code..|..V.....|
|00004a60| 54 4e 20 73 74 61 74 75 | 73 00 00 00 00 57 02 73 |TN statu|s....W.s|
|00004a70| 00 15 00 74 65 6c 65 70 | 68 6f 6e 65 20 6e 75 6d |...telep|hone num|
|00004a80| 62 65 72 20 74 79 70 65 | 00 00 00 00 58 02 de 00 |ber type|....X...|
|00004a90| 0c 00 63 6f 6d 6d 65 6e | 74 20 74 79 70 65 00 00 |..commen|t type..|
|00004aa0| 00 00 59 02 de 00 0c 00 | 63 6f 6d 6d 65 6e 74 20 |..Y.....|comment |
|00004ab0| 64 61 74 65 00 00 00 00 | 5a 02 de 00 07 00 63 6f |date....|Z.....co|
|00004ac0| 6d 6d 65 6e 74 00 00 00 | 00 5b 02 7d 00 0c 00 6e |mment...|.[.}...n|
|00004ad0| 61 6d 65 20 73 6f 75 6e | 64 65 78 00 00 00 00 96 |ame soun|dex.....|
|00004ae0| 02 7c 00 0e 00 6d 69 64 | 64 6c 65 20 69 6e 69 74 |.|...mid|dle init|
|00004af0| 69 61 6c 00 00 00 00 97 | 02 7c 00 09 00 6a 6f 62 |ial.....|.|...job|
|00004b00| 20 74 69 74 6c 65 00 00 | 00 00 a1 02 7c 00 0c 00 | title..|....|...|
|00004b10| 6e 61 6d 65 20 73 6f 75 | 6e 64 65 78 00 00 00 00 |name sou|ndex....|
|00004b20| a2 02 d1 00 0e 00 61 73 | 73 6f 63 20 6e 75 6d 20 |......as|soc num |
|00004b30| 74 79 70 65 00 00 00 00 | a3 02 d1 00 08 00 6e 70 |type....|......np|
|00004b40| 61 20 63 6f 64 65 00 00 | 00 00 a4 02 d1 00 07 00 |a code..|........|
|00004b50| 6e 70 61 20 6e 78 78 00 | 00 00 00 a5 02 d1 00 0b |npa nxx.|........|
|00004b60| 00 6c 69 6e 65 20 6e 75 | 6d 62 65 72 00 00 00 00 |.line nu|mber....|
|00004b70| a6 02 8c 00 0f 00 69 6e | 20 70 72 6f 63 65 73 73 |......in| process|
|00004b80| 20 66 6c 61 67 00 00 00 | 00 aa 02 89 00 10 00 74 | flag...|.......t|
|00004b90| 65 6c 65 70 68 6f 6e 65 | 20 6e 75 6d 62 65 72 00 |elephone| number.|
|00004ba0| 00 00 00 ac 02 e0 00 08 | 00 74 61 78 20 63 6f 64 |........|.tax cod|
|00004bb0| 65 00 00 00 00 ae 02 74 | 00 0c 00 70 72 69 6d 61 |e......t|...prima|
|00004bc0| 72 79 20 73 69 74 65 00 | 00 00 00 af 02 73 00 0c |ry site.|.....s..|
|00004bd0| 00 70 72 69 6d 61 72 79 | 20 73 69 74 65 00 00 00 |.primary| site...|
|00004be0| 00 b1 02 98 00 0c 00 70 | 72 69 6d 61 72 79 20 73 |.......p|rimary s|
|00004bf0| 69 74 65 00 00 00 00 b3 | 02 9c 00 0c 00 70 72 69 |ite.....|.....pri|
|00004c00| 6d 61 72 79 20 73 69 74 | 65 00 00 00 00 b5 02 a1 |mary sit|e.......|
|00004c10| 00 0c 00 70 72 69 6d 61 | 72 79 20 73 69 74 65 00 |...prima|ry site.|
|00004c20| 00 00 00 b6 02 80 00 0c | 00 70 72 69 6d 61 72 79 |........|.primary|
|00004c30| 20 73 69 74 65 00 00 00 | 00 b7 02 7d 00 0c 00 70 | site...|...}...p|
|00004c40| 72 69 6d 61 72 79 20 73 | 69 74 65 00 00 00 00 b8 |rimary s|ite.....|
|00004c50| 02 7e 00 0c 00 70 72 69 | 6d 61 72 79 20 73 69 74 |.~...pri|mary sit|
|00004c60| 65 00 00 00 00 b9 02 7f | 00 0c 00 70 72 69 6d 61 |e.......|...prima|
|00004c70| 72 79 20 73 69 74 65 00 | 00 00 00 ba 02 de 00 0c |ry site.|........|
|00004c80| 00 70 72 69 6d 61 72 79 | 20 73 69 74 65 00 00 00 |.primary| site...|
|00004c90| 00 bb 02 7c 00 0c 00 70 | 72 69 6d 61 72 79 20 73 |...|...p|rimary s|
|00004ca0| 69 74 65 00 00 00 00 bc | 02 9a 00 0c 00 70 72 69 |ite.....|.....pri|
|00004cb0| 6d 61 72 79 20 73 69 74 | 65 00 00 00 00 bd 02 87 |mary sit|e.......|
|00004cc0| 00 0c 00 70 72 69 6d 61 | 72 79 20 73 69 74 65 00 |...prima|ry site.|
|00004cd0| 00 00 00 be 02 88 00 0c | 00 70 72 69 6d 61 72 79 |........|.primary|
|00004ce0| 20 73 69 74 65 00 00 00 | 00 c0 02 cf 00 0c 00 70 | site...|.......p|
|00004cf0| 72 69 6d 61 72 79 20 73 | 69 74 65 00 00 00 00 c2 |rimary s|ite.....|
|00004d00| 02 89 00 0c 00 70 72 69 | 6d 61 72 79 20 73 69 74 |.....pri|mary sit|
|00004d10| 65 00 00 00 00 c3 02 d1 | 00 0c 00 70 72 69 6d 61 |e.......|...prima|
|00004d20| 72 79 20 73 69 74 65 00 | 00 00 00 c4 02 9f 00 0c |ry site.|........|
|00004d30| 00 70 72 69 6d 61 72 79 | 20 73 69 74 65 00 00 00 |.primary| site...|
|00004d40| 00 c5 02 b5 00 0c 00 70 | 72 69 6d 61 72 79 20 73 |.......p|rimary s|
|00004d50| 69 74 65 00 00 00 00 c6 | 02 8c 00 0c 00 70 72 69 |ite.....|.....pri|
|00004d60| 6d 61 72 79 20 73 69 74 | 65 00 00 00 00 c7 02 d3 |mary sit|e.......|
|00004d70| 00 0c 00 70 72 69 6d 61 | 72 79 20 73 69 74 65 00 |...prima|ry site.|
|00004d80| 00 00 00 c8 02 8b 00 0c | 00 70 72 69 6d 61 72 79 |........|.primary|
|00004d90| 20 73 69 74 65 00 00 00 | 00 ca 02 db 00 0c 00 70 | site...|.......p|
|00004da0| 72 69 6d 61 72 79 20 73 | 69 74 65 00 00 00 00 cb |rimary s|ite.....|
|00004db0| 02 8a 00 0c 00 70 72 69 | 6d 61 72 79 20 73 69 74 |.....pri|mary sit|
|00004dc0| 65 00 00 00 00 cc 02 be | 00 0c 00 70 72 69 6d 61 |e.......|...prima|
|00004dd0| 72 79 20 73 69 74 65 00 | 00 00 00 cd 02 8f 00 0c |ry site.|........|
|00004de0| 00 70 72 69 6d 61 72 79 | 20 73 69 74 65 00 00 00 |.primary| site...|
|00004df0| 00 ce 02 5e 00 0c 00 70 | 72 69 6d 61 72 79 20 73 |...^...p|rimary s|
|00004e00| 69 74 65 00 00 00 00 cf | 02 55 00 0c 00 70 72 69 |ite.....|.U...pri|
|00004e10| 6d 61 72 79 20 73 69 74 | 65 00 00 00 00 d0 02 5f |mary sit|e......_|
|00004e20| 00 0c 00 70 72 69 6d 61 | 72 79 20 73 69 74 65 00 |...prima|ry site.|
|00004e30| 00 00 00 d1 02 65 00 0c | 00 70 72 69 6d 61 72 79 |.....e..|.primary|
|00004e40| 20 73 69 74 65 00 00 00 | 00 d2 02 c1 00 0c 00 70 | site...|.......p|
|00004e50| 72 69 6d 61 72 79 20 73 | 69 74 65 00 00 00 00 d3 |rimary s|ite.....|
|00004e60| 02 c2 00 0c 00 70 72 69 | 6d 61 72 79 20 73 69 74 |.....pri|mary sit|
|00004e70| 65 00 00 00 00 d4 02 66 | 00 0c 00 70 72 69 6d 61 |e......f|...prima|
|00004e80| 72 79 20 73 69 74 65 00 | 00 00 00 d5 02 64 00 0c |ry site.|.....d..|
|00004e90| 00 70 72 69 6d 61 72 79 | 20 73 69 74 65 00 00 00 |.primary| site...|
|00004ea0| 00 d6 02 67 00 0c 00 70 | 72 69 6d 61 72 79 20 73 |...g...p|rimary s|
|00004eb0| 69 74 65 00 00 00 00 d7 | 02 c0 00 0c 00 70 72 69 |ite.....|.....pri|
|00004ec0| 6d 61 72 79 20 73 69 74 | 65 00 00 00 00 d8 02 c4 |mary sit|e.......|
|00004ed0| 00 0c 00 70 72 69 6d 61 | 72 79 20 73 69 74 65 00 |...prima|ry site.|
|00004ee0| 00 00 00 d9 02 bf 00 0c | 00 70 72 69 6d 61 72 79 |........|.primary|
|00004ef0| 20 73 69 74 65 00 00 00 | 00 da 02 c5 00 0c 00 70 | site...|.......p|
|00004f00| 72 69 6d 61 72 79 20 73 | 69 74 65 00 00 00 00 dc |rimary s|ite.....|
|00004f10| 02 c6 00 0c 00 70 72 69 | 6d 61 72 79 20 73 69 74 |.....pri|mary sit|
|00004f20| 65 00 00 00 00 df 02 c9 | 00 0c 00 70 72 69 6d 61 |e.......|...prima|
|00004f30| 72 79 20 73 69 74 65 00 | 00 00 00 e1 02 ac 00 0c |ry site.|........|
|00004f40| 00 70 72 69 6d 61 72 79 | 20 73 69 74 65 00 00 00 |.primary| site...|
|00004f50| 00 e3 02 a4 00 0c 00 70 | 72 69 6d 61 72 79 20 73 |.......p|rimary s|
|00004f60| 69 74 65 00 00 00 00 e6 | 02 ab 00 0c 00 70 72 69 |ite.....|.....pri|
|00004f70| 6d 61 72 79 20 73 69 74 | 65 00 00 00 00 e8 02 9d |mary sit|e.......|
|00004f80| 00 0c 00 70 72 69 6d 61 | 72 79 20 73 69 74 65 00 |...prima|ry site.|
|00004f90| 00 00 00 eb 02 b2 00 0c | 00 70 72 69 6d 61 72 79 |........|.primary|
|00004fa0| 20 73 69 74 65 00 00 00 | 00 ec 02 e0 00 0c 00 70 | site...|.......p|
|00004fb0| 72 69 6d 61 72 79 20 73 | 69 74 65 00 00 00 00 ed |rimary s|ite.....|
|00004fc0| 02 b3 00 0c 00 70 72 69 | 6d 61 72 79 20 73 69 74 |.....pri|mary sit|
|00004fd0| 65 00 00 00 00 ee 02 b1 | 00 0c 00 70 72 69 6d 61 |e.......|...prima|
|00004fe0| 72 79 20 73 69 74 65 00 | 00 00 00 ef 02 a7 00 0c |ry site.|........|
|00004ff0| 00 70 72 69 6d 61 72 79 | 20 73 69 74 65 00 00 00 |.primary| site...|
|00005000| 00 f0 02 74 00 0e 00 64 | 69 73 74 72 69 62 20 74 |...t...d|istrib t|
|00005010| 6f 20 70 75 62 00 00 00 | 00 f1 02 74 00 0e 00 64 |o pub...|...t...d|
|00005020| 69 73 74 72 69 62 20 74 | 6f 20 6e 62 63 00 00 00 |istrib t|o nbc...|
|00005030| 00 f2 02 63 00 0c 00 70 | 72 69 6d 61 72 79 20 73 |...c...p|rimary s|
|00005040| 69 74 65 00 00 00 00 f3 | 02 73 00 0e 00 64 69 73 |ite.....|.s...dis|
|00005050| 74 72 69 62 20 74 6f 20 | 70 75 62 00 00 00 00 f4 |trib to |pub.....|
|00005060| 02 73 00 0e 00 64 69 73 | 74 72 69 62 20 74 6f 20 |.s...dis|trib to |
|00005070| 6e 62 63 00 00 00 00 f7 | 02 98 00 0e 00 64 69 73 |nbc.....|.....dis|
|00005080| 74 72 69 62 20 74 6f 20 | 70 75 62 00 00 00 00 f9 |trib to |pub.....|
|00005090| 02 98 00 0e 00 64 69 73 | 74 72 69 62 20 74 6f 20 |.....dis|trib to |
|000050a0| 6e 62 63 00 00 00 00 fc | 02 9c 00 0e 00 64 69 73 |nbc.....|.....dis|
|000050b0| 74 72 69 62 20 74 6f 20 | 70 75 62 00 00 00 00 fd |trib to |pub.....|
|000050c0| 02 9c 00 0e 00 64 69 73 | 74 72 69 62 20 74 6f 20 |.....dis|trib to |
|000050d0| 6e 62 63 00 00 00 00 00 | 03 7d 00 0e 00 64 69 73 |nbc.....|.}...dis|
|000050e0| 74 72 69 62 20 74 6f 20 | 70 75 62 00 00 00 00 01 |trib to |pub.....|
|000050f0| 03 7d 00 0e 00 64 69 73 | 74 72 69 62 20 74 6f 20 |.}...dis|trib to |
|00005100| 6e 62 63 00 00 00 00 02 | 03 80 00 0e 00 64 69 73 |nbc.....|.....dis|
|00005110| 74 72 69 62 20 74 6f 20 | 70 75 62 00 00 00 00 03 |trib to |pub.....|
|00005120| 03 80 00 0e 00 64 69 73 | 74 72 69 62 20 74 6f 20 |.....dis|trib to |
|00005130| 6e 62 63 00 00 00 00 04 | 03 a1 00 0e 00 64 69 73 |nbc.....|.....dis|
|00005140| 74 72 69 62 20 74 6f 20 | 70 75 62 00 00 00 00 05 |trib to |pub.....|
|00005150| 03 a1 00 0e 00 64 69 73 | 74 72 69 62 20 74 6f 20 |.....dis|trib to |
|00005160| 6e 62 63 00 00 00 00 06 | 03 de 00 0e 00 64 69 73 |nbc.....|.....dis|
|00005170| 74 72 69 62 20 74 6f 20 | 70 75 62 00 00 00 00 07 |trib to |pub.....|
|00005180| 03 de 00 0e 00 64 69 73 | 74 72 69 62 20 74 6f 20 |.....dis|trib to |
|00005190| 6e 62 63 00 00 00 00 08 | 03 7f 00 0e 00 64 69 73 |nbc.....|.....dis|
|000051a0| 74 72 69 62 20 74 6f 20 | 70 75 62 00 00 00 00 09 |trib to |pub.....|
|000051b0| 03 7f 00 0e 00 64 69 73 | 74 72 69 62 20 74 6f 20 |.....dis|trib to |
|000051c0| 6e 62 63 00 00 00 00 0a | 03 7e 00 0e 00 64 69 73 |nbc.....|.~...dis|
|000051d0| 74 72 69 62 20 74 6f 20 | 70 75 62 00 00 00 00 0b |trib to |pub.....|
|000051e0| 03 7e 00 0e 00 64 69 73 | 74 72 69 62 20 74 6f 20 |.~...dis|trib to |
|000051f0| 6e 62 63 00 00 00 00 0c | 03 7c 00 0e 00 64 69 73 |nbc.....|.|...dis|
|00005200| 74 72 69 62 20 74 6f 20 | 70 75 62 00 00 00 00 0d |trib to |pub.....|
|00005210| 03 7c 00 0e 00 64 69 73 | 74 72 69 62 20 74 6f 20 |.|...dis|trib to |
|00005220| 6e 62 63 00 00 00 00 0e | 03 9a 00 0e 00 64 69 73 |nbc.....|.....dis|
|00005230| 74 72 69 62 20 74 6f 20 | 70 75 62 00 00 00 00 0f |trib to |pub.....|
|00005240| 03 9a 00 0e 00 64 69 73 | 74 72 69 62 20 74 6f 20 |.....dis|trib to |
|00005250| 6e 62 63 00 00 00 00 12 | 03 88 00 0e 00 64 69 73 |nbc.....|.....dis|
|00005260| 74 72 69 62 20 74 6f 20 | 70 75 62 00 00 00 00 13 |trib to |pub.....|
|00005270| 03 88 00 0e 00 64 69 73 | 74 72 69 62 20 74 6f 20 |.....dis|trib to |
|00005280| 6e 62 63 00 00 00 00 15 | 03 87 00 0e 00 64 69 73 |nbc.....|.....dis|
|00005290| 74 72 69 62 20 74 6f 20 | 6e 62 63 00 00 00 00 16 |trib to |nbc.....|
|000052a0| 03 cf 00 0e 00 64 69 73 | 74 72 69 62 20 74 6f 20 |.....dis|trib to |
|000052b0| 70 75 62 00 00 00 00 17 | 03 cf 00 0e 00 64 69 73 |pub.....|.....dis|
|000052c0| 74 72 69 62 20 74 6f 20 | 6e 62 63 00 00 00 00 1a |trib to |nbc.....|
|000052d0| 03 89 00 0e 00 64 69 73 | 74 72 69 62 20 74 6f 20 |.....dis|trib to |
|000052e0| 70 75 62 00 00 00 00 1b | 03 89 00 0e 00 64 69 73 |pub.....|.....dis|
|000052f0| 74 72 69 62 20 74 6f 20 | 6e 62 63 00 00 00 00 1c |trib to |nbc.....|
|00005300| 03 d1 00 0e 00 64 69 73 | 74 72 69 62 20 74 6f 20 |.....dis|trib to |
|00005310| 70 75 62 00 00 00 00 1d | 03 d1 00 0e 00 64 69 73 |pub.....|.....dis|
|00005320| 74 72 69 62 20 74 6f 20 | 6e 62 63 00 00 00 00 1e |trib to |nbc.....|
|00005330| 03 8c 00 0e 00 64 69 73 | 74 72 69 62 20 74 6f 20 |.....dis|trib to |
|00005340| 70 75 62 00 00 00 00 1f | 03 8c 00 0e 00 64 69 73 |pub.....|.....dis|
|00005350| 74 72 69 62 20 74 6f 20 | 6e 62 63 00 00 00 00 20 |trib to |nbc.... |
|00005360| 03 d3 00 0e 00 64 69 73 | 74 72 69 62 20 74 6f 20 |.....dis|trib to |
|00005370| 70 75 62 00 00 00 00 21 | 03 d3 00 0e 00 64 69 73 |pub....!|.....dis|
|00005380| 74 72 69 62 20 74 6f 20 | 6e 62 63 00 00 00 00 22 |trib to |nbc...."|
|00005390| 03 8b 00 0e 00 64 69 73 | 74 72 69 62 20 74 6f 20 |.....dis|trib to |
|000053a0| 70 75 62 00 00 00 00 23 | 03 8b 00 0e 00 64 69 73 |pub....#|.....dis|
|000053b0| 74 72 69 62 20 74 6f 20 | 6e 62 63 00 00 00 00 26 |trib to |nbc....&|
|000053c0| 03 db 00 0e 00 64 69 73 | 74 72 69 62 20 74 6f 20 |.....dis|trib to |
|000053d0| 70 75 62 00 00 00 00 27 | 03 db 00 0e 00 64 69 73 |pub....'|.....dis|
|000053e0| 74 72 69 62 20 74 6f 20 | 6e 62 63 00 00 00 00 28 |trib to |nbc....(|
|000053f0| 03 8a 00 0e 00 64 69 73 | 74 72 69 62 20 74 6f 20 |.....dis|trib to |
|00005400| 70 75 62 00 00 00 00 29 | 03 8a 00 0e 00 64 69 73 |pub....)|.....dis|
|00005410| 74 72 69 62 20 74 6f 20 | 6e 62 63 00 00 00 00 2a |trib to |nbc....*|
|00005420| 03 be 00 0e 00 64 69 73 | 74 72 69 62 20 74 6f 20 |.....dis|trib to |
|00005430| 70 75 62 00 00 00 00 2b | 03 be 00 0e 00 64 69 73 |pub....+|.....dis|
|00005440| 74 72 69 62 20 74 6f 20 | 6e 62 63 00 00 00 00 2c |trib to |nbc....,|
|00005450| 03 8f 00 0e 00 64 69 73 | 74 72 69 62 20 74 6f 20 |.....dis|trib to |
|00005460| 70 75 62 00 00 00 00 2d | 03 8f 00 0e 00 64 69 73 |pub....-|.....dis|
|00005470| 74 72 69 62 20 74 6f 20 | 6e 62 63 00 00 00 00 2e |trib to |nbc.....|
|00005480| 03 5f 00 0e 00 64 69 73 | 74 72 69 62 20 74 6f 20 |._...dis|trib to |
|00005490| 70 75 62 00 00 00 00 2f | 03 5f 00 0e 00 64 69 73 |pub..../|._...dis|
|000054a0| 74 72 69 62 20 74 6f 20 | 6e 62 63 00 00 00 00 30 |trib to |nbc....0|
|000054b0| 03 55 00 0e 00 64 69 73 | 74 72 69 62 20 74 6f 20 |.U...dis|trib to |
|000054c0| 70 75 62 00 00 00 00 31 | 03 55 00 0e 00 64 69 73 |pub....1|.U...dis|
|000054d0| 74 72 69 62 20 74 6f 20 | 6e 62 63 00 00 00 00 32 |trib to |nbc....2|
|000054e0| 03 5e 00 0e 00 64 69 73 | 74 72 69 62 20 74 6f 20 |.^...dis|trib to |
|000054f0| 70 75 62 00 00 00 00 33 | 03 5e 00 0e 00 64 69 73 |pub....3|.^...dis|
|00005500| 74 72 69 62 20 74 6f 20 | 6e 62 63 00 00 00 00 34 |trib to |nbc....4|
|00005510| 03 63 00 0e 00 64 69 73 | 74 72 69 62 20 74 6f 20 |.c...dis|trib to |
|00005520| 70 75 62 00 00 00 00 35 | 03 63 00 0e 00 64 69 73 |pub....5|.c...dis|
|00005530| 74 72 69 62 20 74 6f 20 | 6e 62 63 00 00 00 00 36 |trib to |nbc....6|
|00005540| 03 65 00 0e 00 64 69 73 | 74 72 69 62 20 74 6f 20 |.e...dis|trib to |
|00005550| 70 75 62 00 00 00 00 37 | 03 65 00 0e 00 64 69 73 |pub....7|.e...dis|
|00005560| 74 72 69 62 20 74 6f 20 | 6e 62 63 00 00 00 00 38 |trib to |nbc....8|
|00005570| 03 c1 00 0e 00 64 69 73 | 74 72 69 62 20 74 6f 20 |.....dis|trib to |
|00005580| 70 75 62 00 00 00 00 39 | 03 c1 00 0e 00 64 69 73 |pub....9|.....dis|
|00005590| 74 72 69 62 20 74 6f 20 | 6e 62 63 00 00 00 00 3a |trib to |nbc....:|
|000055a0| 03 66 00 0e 00 64 69 73 | 74 72 69 62 20 74 6f 20 |.f...dis|trib to |
|000055b0| 70 75 62 00 00 00 00 3b | 03 66 00 0e 00 64 69 73 |pub....;|.f...dis|
|000055c0| 74 72 69 62 20 74 6f 20 | 6e 62 63 00 00 00 00 3c |trib to |nbc....<|
|000055d0| 03 c2 00 0e 00 64 69 73 | 74 72 69 62 20 74 6f 20 |.....dis|trib to |
|000055e0| 70 75 62 00 00 00 00 3d | 03 c2 00 0e 00 64 69 73 |pub....=|.....dis|
|000055f0| 74 72 69 62 20 74 6f 20 | 6e 62 63 00 00 00 00 3e |trib to |nbc....>|
|00005600| 03 64 00 0e 00 64 69 73 | 74 72 69 62 20 74 6f 20 |.d...dis|trib to |
|00005610| 70 75 62 00 00 00 00 3f | 03 64 00 0e 00 64 69 73 |pub....?|.d...dis|
|00005620| 74 72 69 62 20 74 6f 20 | 6e 62 63 00 00 00 00 40 |trib to |nbc....@|
|00005630| 03 67 00 0e 00 64 69 73 | 74 72 69 62 20 74 6f 20 |.g...dis|trib to |
|00005640| 70 75 62 00 00 00 00 41 | 03 67 00 0e 00 64 69 73 |pub....A|.g...dis|
|00005650| 74 72 69 62 20 74 6f 20 | 6e 62 63 00 00 00 00 42 |trib to |nbc....B|
|00005660| 03 c0 00 0e 00 64 69 73 | 74 72 69 62 20 74 6f 20 |.....dis|trib to |
|00005670| 70 75 62 00 00 00 00 43 | 03 c0 00 0e 00 64 69 73 |pub....C|.....dis|
|00005680| 74 72 69 62 20 74 6f 20 | 6e 62 63 00 00 00 00 44 |trib to |nbc....D|
|00005690| 03 c4 00 0e 00 64 69 73 | 74 72 69 62 20 74 6f 20 |.....dis|trib to |
|000056a0| 70 75 62 00 00 00 00 45 | 03 c4 00 0e 00 64 69 73 |pub....E|.....dis|
|000056b0| 74 72 69 62 20 74 6f 20 | 6e 62 63 00 00 00 00 46 |trib to |nbc....F|
|000056c0| 03 bf 00 0e 00 64 69 73 | 74 72 69 62 20 74 6f 20 |.....dis|trib to |
|000056d0| 70 75 62 00 00 00 00 47 | 03 bf 00 0e 00 64 69 73 |pub....G|.....dis|
|000056e0| 74 72 69 62 20 74 6f 20 | 6e 62 63 00 00 00 00 48 |trib to |nbc....H|
|000056f0| 03 c5 00 0e 00 64 69 73 | 74 72 69 62 20 74 6f 20 |.....dis|trib to |
|00005700| 70 75 62 00 00 00 00 49 | 03 c5 00 0e 00 64 69 73 |pub....I|.....dis|
|00005710| 74 72 69 62 20 74 6f 20 | 6e 62 63 00 00 00 00 4c |trib to |nbc....L|
|00005720| 03 c6 00 0e 00 64 69 73 | 74 72 69 62 20 74 6f 20 |.....dis|trib to |
|00005730| 70 75 62 00 00 00 00 4d | 03 c6 00 0e 00 64 69 73 |pub....M|.....dis|
|00005740| 74 72 69 62 20 74 6f 20 | 6e 62 63 00 00 00 00 52 |trib to |nbc....R|
|00005750| 03 c9 00 0e 00 64 69 73 | 74 72 69 62 20 74 6f 20 |.....dis|trib to |
|00005760| 70 75 62 00 00 00 00 53 | 03 c9 00 0e 00 64 69 73 |pub....S|.....dis|
|00005770| 74 72 69 62 20 74 6f 20 | 6e 62 63 00 00 00 00 56 |trib to |nbc....V|
|00005780| 03 ac 00 0e 00 64 69 73 | 74 72 69 62 20 74 6f 20 |.....dis|trib to |
|00005790| 70 75 62 00 00 00 00 57 | 03 ac 00 0e 00 64 69 73 |pub....W|.....dis|
|000057a0| 74 72 69 62 20 74 6f 20 | 6e 62 63 00 00 00 00 5a |trib to |nbc....Z|
|000057b0| 03 a4 00 0e 00 64 69 73 | 74 72 69 62 20 74 6f 20 |.....dis|trib to |
|000057c0| 70 75 62 00 00 00 00 5b | 03 a4 00 0e 00 64 69 73 |pub....[|.....dis|
|000057d0| 74 72 69 62 20 74 6f 20 | 6e 62 63 00 00 00 00 5e |trib to |nbc....^|
|000057e0| 03 ab 00 0e 00 64 69 73 | 74 72 69 62 20 74 6f 20 |.....dis|trib to |
|000057f0| 70 75 62 00 00 00 00 5f | 03 ab 00 0e 00 64 69 73 |pub...._|.....dis|
|00005800| 74 72 69 62 20 74 6f 20 | 6e 62 63 00 00 00 00 64 |trib to |nbc....d|
|00005810| 03 9d 00 0e 00 64 69 73 | 74 72 69 62 20 74 6f 20 |.....dis|trib to |
|00005820| 70 75 62 00 00 00 00 65 | 03 9d 00 0e 00 64 69 73 |pub....e|.....dis|
|00005830| 74 72 69 62 20 74 6f 20 | 6e 62 63 00 00 00 00 6a |trib to |nbc....j|
|00005840| 03 b2 00 0e 00 64 69 73 | 74 72 69 62 20 74 6f 20 |.....dis|trib to |
|00005850| 70 75 62 00 00 00 00 6b | 03 b2 00 0e 00 64 69 73 |pub....k|.....dis|
|00005860| 74 72 69 62 20 74 6f 20 | 6e 62 63 00 00 00 00 6c |trib to |nbc....l|
|00005870| 03 e0 00 0e 00 64 69 73 | 74 72 69 62 20 74 6f 20 |.....dis|trib to |
|00005880| 70 75 62 00 00 00 00 6d | 03 e0 00 0e 00 64 69 73 |pub....m|.....dis|
|00005890| 74 72 69 62 20 74 6f 20 | 6e 62 63 00 00 00 00 6e |trib to |nbc....n|
|000058a0| 03 b3 00 0e 00 64 69 73 | 74 72 69 62 20 74 6f 20 |.....dis|trib to |
|000058b0| 70 75 62 00 00 00 00 6f | 03 b3 00 0e 00 64 69 73 |pub....o|.....dis|
|000058c0| 74 72 69 62 20 74 6f 20 | 6e 62 63 00 00 00 00 70 |trib to |nbc....p|
|000058d0| 03 b1 00 0e 00 64 69 73 | 74 72 69 62 20 74 6f 20 |.....dis|trib to |
|000058e0| 70 75 62 00 00 00 00 71 | 03 b1 00 0e 00 64 69 73 |pub....q|.....dis|
|000058f0| 74 72 69 62 20 74 6f 20 | 6e 62 63 00 00 00 00 72 |trib to |nbc....r|
|00005900| 03 a7 00 0e 00 64 69 73 | 74 72 69 62 20 74 6f 20 |.....dis|trib to |
|00005910| 70 75 62 00 00 00 00 73 | 03 a7 00 0e 00 64 69 73 |pub....s|.....dis|
|00005920| 74 72 69 62 20 74 6f 20 | 6e 62 63 00 00 00 00 76 |trib to |nbc....v|
|00005930| 03 87 00 0e 00 64 69 73 | 74 72 69 62 20 74 6f 20 |.....dis|trib to |
|00005940| 70 75 62 00 00 00 00 77 | 03 9f 00 0e 00 64 69 73 |pub....w|.....dis|
|00005950| 74 72 69 62 20 74 6f 20 | 70 75 62 00 00 00 00 78 |trib to |pub....x|
|00005960| 03 9f 00 0e 00 64 69 73 | 74 72 69 62 20 74 6f 20 |.....dis|trib to |
|00005970| 6e 62 63 00 00 00 00 79 | 03 b5 00 0e 00 64 69 73 |nbc....y|.....dis|
|00005980| 74 72 69 62 20 74 6f 20 | 70 75 62 00 00 00 00 7a |trib to |pub....z|
|00005990| 03 b5 00 0e 00 64 69 73 | 74 72 69 62 20 74 6f 20 |.....dis|trib to |
|000059a0| 6e 62 63 00 00 00 00 7b | 03 c6 00 0a 00 74 72 6f |nbc....{|.....tro|
|000059b0| 75 62 6c 65 20 69 64 00 | 00 00 00 7c 03 c6 00 0d |uble id.|...|....|
|000059c0| 00 70 72 69 6f 72 69 74 | 79 20 63 6f 64 65 00 00 |.priorit|y code..|
|000059d0| 00 00 7d 03 c6 00 0a 00 | 74 72 6f 75 62 6c 65 20 |..}.....|trouble |
|000059e0| 74 6e 00 00 00 00 7e 03 | c6 00 04 00 64 61 74 65 |tn....~.|....date|
|000059f0| 00 00 00 00 80 03 e2 00 | 0c 00 63 6f 6e 74 61 63 |........|..contac|
|00005a00| 74 20 64 61 74 65 00 00 | 00 00 83 03 e2 00 0b 00 |t date..|........|
|00005a10| 63 62 72 20 63 6f 6d 6d | 65 6e 74 00 00 00 00 84 |cbr comm|ent.....|
|00005a20| 03 e2 00 07 00 75 73 65 | 72 20 69 64 00 00 00 00 |.....use|r id....|
|00005a30| 85 03 c9 00 0f 00 72 65 | 73 6f 6c 75 74 69 6f 6e |......re|solution|
|00005a40| 20 63 6f 64 65 00 00 00 | 00 8a 03 e2 00 10 00 63 | code...|.......c|
|00005a50| 6f 6e 74 61 63 74 20 65 | 76 65 6e 74 20 69 64 00 |ontact e|vent id.|
|00005a60| 00 00 00 92 03 8b 00 0c | 00 70 75 62 6c 69 73 68 |........|.publish|
|00005a70| 20 63 6f 64 65 00 00 00 | 00 95 03 e2 00 0e 00 64 | code...|.......d|
|00005a80| 69 73 74 72 69 62 20 74 | 6f 20 70 75 62 00 00 00 |istrib t|o pub...|
|00005a90| 00 96 03 e2 00 0e 00 64 | 69 73 74 72 69 62 20 74 |.......d|istrib t|
|00005aa0| 6f 20 6e 62 63 00 00 00 | 00 97 03 e4 00 0e 00 64 |o nbc...|.......d|
|00005ab0| 69 73 74 72 69 62 20 74 | 6f 20 70 75 62 00 00 00 |istrib t|o pub...|
|00005ac0| 00 98 03 e4 00 0e 00 64 | 69 73 74 72 69 62 20 74 |.......d|istrib t|
|00005ad0| 6f 20 6e 62 63 00 00 00 | 00 9e 03 e2 00 11 00 63 |o nbc...|.......c|
|00005ae0| 6f 6e 74 61 63 74 20 6c | 61 73 74 20 6e 61 6d 65 |ontact l|ast name|
|00005af0| 00 00 00 00 9f 03 e2 00 | 12 00 63 6f 6e 74 61 63 |........|..contac|
|00005b00| 74 20 66 69 72 73 74 20 | 6e 61 6d 65 00 00 00 00 |t first |name....|
|00005b10| a0 03 e2 00 16 00 63 6f | 6e 74 61 63 74 20 6d 69 |......co|ntact mi|
|00005b20| 64 64 6c 65 20 69 6e 69 | 74 69 61 6c 00 00 00 00 |ddle ini|tial....|
|00005b30| a4 03 e2 00 0d 00 63 6f | 6e 74 61 63 74 20 74 69 |......co|ntact ti|
|00005b40| 74 6c 65 00 00 00 00 a5 | 03 e2 00 09 00 63 62 72 |tle.....|.....cbr|
|00005b50| 20 74 69 74 6c 65 00 00 | 00 00 a6 03 e2 00 13 00 | title..|........|
|00005b60| 69 72 61 74 65 20 63 75 | 73 74 6f 6d 65 72 20 66 |irate cu|stomer f|
|00005b70| 6c 61 67 00 00 00 00 a7 | 03 e2 00 0c 00 63 6f 6e |lag.....|.....con|
|00005b80| 74 61 63 74 20 74 79 70 | 65 00 00 00 00 a8 03 7f |tact typ|e.......|
|00005b90| 00 0a 00 61 63 63 6f 75 | 6e 74 20 69 64 00 00 00 |...accou|nt id...|
|00005ba0| 00 ae 03 ed 00 0e 00 65 | 66 66 65 63 74 69 76 65 |.......e|ffective|
|00005bb0| 20 64 61 74 65 00 00 00 | 00 af 03 ed 00 08 00 65 | date...|.......e|
|00005bc0| 6e 64 20 64 61 74 65 00 | 00 00 00 b2 03 74 00 0a |nd date.|.....t..|
|00005bd0| 00 61 64 64 72 65 73 73 | 20 69 64 00 00 00 00 b4 |.address| id.....|
|00005be0| 03 f1 00 0e 00 65 66 66 | 65 63 74 69 76 65 20 64 |.....eff|ective d|
|00005bf0| 61 74 65 00 00 00 00 b5 | 03 f1 00 08 00 65 6e 64 |ate.....|.....end|
|00005c00| 20 64 61 74 65 00 00 00 | 00 b6 03 9a 00 12 00 72 | date...|.......r|
|00005c10| 65 6c 61 74 65 64 20 61 | 63 63 6f 75 6e 74 20 69 |elated a|ccount i|
|00005c20| 64 00 00 00 00 b7 03 e4 | 00 0c 00 74 72 6f 75 62 |d.......|...troub|
|00005c30| 6c 65 20 63 6f 64 65 00 | 00 00 00 b8 03 e4 00 0c |le code.|........|
|00005c40| 00 70 72 69 6d 61 72 79 | 20 73 69 74 65 00 00 00 |.primary| site...|
|00005c50| 00 b9 03 74 00 0c 00 61 | 64 64 72 65 73 73 20 74 |...t...a|ddress t|
|00005c60| 79 70 65 00 00 00 00 ba | 03 f3 00 0e 00 61 64 64 |ype.....|.....add|
|00005c70| 6c 20 75 6e 69 74 20 74 | 79 70 65 00 00 00 00 bb |l unit t|ype.....|
|00005c80| 03 f3 00 10 00 61 64 64 | 6c 20 75 6e 69 74 20 6e |.....add|l unit n|
|00005c90| 75 6d 62 65 72 00 00 00 | 00 bd 03 7c 00 0d 00 65 |umber...|...|...e|
|00005ca0| 6d 70 6c 6f 79 65 72 20 | 6e 61 6d 65 00 00 00 00 |mployer |name....|
|00005cb0| be 03 7c 00 14 00 6c 65 | 6e 67 74 68 20 6f 66 20 |..|...le|ngth of |
|00005cc0| 65 6d 70 6c 6f 79 6d 65 | 6e 74 00 00 00 00 bf 03 |employme|nt......|
|00005cd0| 7c 00 0d 00 6f 77 6e 65 | 72 73 68 69 70 20 69 6e ||...owne|rship in|
|00005ce0| 64 00 00 00 00 c4 03 74 | 00 15 00 70 6f 73 74 61 |d......t|...posta|
|00005cf0| 6c 20 63 6f 6d 6d 75 6e | 69 74 79 20 6e 61 6d 65 |l commun|ity name|
|00005d00| 00 00 00 00 c5 03 f3 00 | 16 00 61 64 64 6c 20 73 |........|..addl s|
|00005d10| 74 72 65 65 74 20 64 65 | 73 63 72 69 70 74 6f 72 |treet de|scriptor|
|00005d20| 00 00 00 00 c6 03 b2 00 | 15 00 70 6f 73 74 61 6c |........|..postal|
|00005d30| 20 63 6f 6d 6d 75 6e 69 | 74 79 20 6e 61 6d 65 00 | communi|ty name.|
|00005d40| 00 00 00 c7 03 f4 00 0e | 00 61 64 64 6c 20 75 6e |........|.addl un|
|00005d50| 69 74 20 74 79 70 65 00 | 00 00 00 c8 03 f4 00 10 |it type.|........|
|00005d60| 00 61 64 64 6c 20 75 6e | 69 74 20 6e 75 6d 62 65 |.addl un|it numbe|
|00005d70| 72 00 00 00 00 ca 03 f4 | 00 16 00 61 64 64 6c 20 |r.......|...addl |
|00005d80| 73 74 72 65 65 74 20 64 | 65 73 63 72 69 70 74 6f |street d|escripto|
|00005d90| 72 00 00 00 00 cb 03 f1 | 00 0b 00 61 64 64 72 65 |r.......|...addre|
|00005da0| 73 73 20 75 73 65 00 00 | 00 00 cc 03 f1 00 0c 00 |ss use..|........|
|00005db0| 70 72 69 6d 61 72 79 20 | 73 69 74 65 00 00 00 00 |primary |site....|
|00005dc0| cd 03 f1 00 0e 00 64 69 | 73 74 72 69 62 20 74 6f |......di|strib to|
|00005dd0| 20 70 75 62 00 00 00 00 | cf 03 f4 00 0c 00 70 72 | pub....|......pr|
|00005de0| 69 6d 61 72 79 20 73 69 | 74 65 00 00 00 00 d0 03 |imary si|te......|
|00005df0| f4 00 0e 00 64 69 73 74 | 72 69 62 20 74 6f 20 70 |....dist|rib to p|
|00005e00| 75 62 00 00 00 00 d2 03 | f1 00 0e 00 64 69 73 74 |ub......|....dist|
|00005e10| 72 69 62 20 74 6f 20 6e | 62 63 00 00 00 00 d3 03 |rib to n|bc......|
|00005e20| f3 00 0c 00 70 72 69 6d | 61 72 79 20 73 69 74 65 |....prim|ary site|
|00005e30| 00 00 00 00 d4 03 f3 00 | 0e 00 64 69 73 74 72 69 |........|..distri|
|00005e40| 62 20 74 6f 20 70 75 62 | 00 00 00 00 d5 03 f3 00 |b to pub|........|
|00005e50| 0e 00 64 69 73 74 72 69 | 62 20 74 6f 20 6e 62 63 |..distri|b to nbc|
|00005e60| 00 00 00 00 d6 03 f4 00 | 0e 00 64 69 73 74 72 69 |........|..distri|
|00005e70| 62 20 74 6f 20 6e 62 63 | 00 00 00 00 d7 03 f5 00 |b to nbc|........|
|00005e80| 09 00 62 69 6c 6c 20 64 | 61 74 65 00 00 00 00 d8 |..bill d|ate.....|
|00005e90| 03 f5 00 0b 00 70 61 67 | 65 20 6e 75 6d 62 65 72 |.....pag|e number|
|00005ea0| 00 00 00 00 d9 03 f5 00 | 0b 00 6c 69 6e 65 20 6e |........|..line n|
|00005eb0| 75 6d 62 65 72 00 00 00 | 00 da 03 f5 00 0f 00 73 |umber...|.......s|
|00005ec0| 65 71 75 65 6e 63 65 20 | 6e 75 6d 62 65 72 00 00 |equence |number..|
|00005ed0| 00 00 db 03 f5 00 0b 00 | 70 72 69 6e 74 20 69 6d |........|print im|
|00005ee0| 61 67 65 00 00 00 00 dc | 03 c2 00 10 00 73 6b 69 |age.....|.....ski|
|00005ef0| 6c 6c 20 65 78 70 65 72 | 69 65 6e 63 65 00 00 00 |ll exper|ience...|
|00005f00| 00 e0 03 c6 00 0f 00 72 | 65 73 6f 6c 75 74 69 6f |.......r|esolutio|
|00005f10| 6e 20 64 61 74 65 00 00 | 00 00 e1 03 e2 00 0c 00 |n date..|........|
|00005f20| 70 72 69 6d 61 72 79 20 | 73 69 74 65 00 00 00 00 |primary |site....|
|00005f30| e2 03 e2 00 09 00 63 62 | 72 20 70 68 6f 6e 65 00 |......cb|r phone.|
|00005f40| 00 00 00 e3 03 c6 00 0b | 00 72 65 73 6f 6c 76 65 |........|.resolve|
|00005f50| 72 20 69 64 00 00 00 00 | e4 03 55 00 10 00 63 68 |r id....|..U...ch|
|00005f60| 61 72 67 65 20 74 79 70 | 65 20 63 6f 64 65 00 00 |arge typ|e code..|
|00005f70| 00 00 e6 03 f6 00 07 00 | 70 6f 72 74 5f 69 64 00 |........|port_id.|
|00005f80| 00 00 00 e7 03 f7 00 0b | 00 73 77 69 74 63 68 5f |........|.switch_|
|00005f90| 63 6c 6c 69 00 00 00 00 | e8 03 f7 00 0d 00 73 77 |clli....|......sw|
|00005fa0| 69 74 63 68 5f 6d 6f 64 | 75 6c 65 00 00 00 00 e9 |itch_mod|ule.....|
|00005fb0| 03 f7 00 10 00 69 64 63 | 75 5f 75 6e 69 74 5f 6e |.....idc|u_unit_n|
|00005fc0| 75 6d 62 65 72 00 00 00 | 00 ea 03 f7 00 08 00 72 |umber...|.......r|
|00005fd0| 64 74 5f 63 6c 6c 69 00 | 00 00 00 eb 03 f7 00 12 |dt_clli.|........|
|00005fe0| 00 72 65 6d 6f 74 65 5f | 74 65 72 6d 69 6e 61 6c |.remote_|terminal|
|00005ff0| 5f 69 64 00 00 00 00 ec | 03 f8 00 0c 00 63 6f 6d |_id.....|.....com|
|00006000| 6d 65 6e 74 20 74 79 70 | 65 00 00 00 00 ed 03 f8 |ment typ|e.......|
|00006010| 00 0c 00 63 6f 6d 6d 65 | 6e 74 20 64 61 74 65 00 |...comme|nt date.|
|00006020| 00 00 00 ee 03 f8 00 07 | 00 63 6f 6d 6d 65 6e 74 |........|.comment|
|00006030| 00 00 00 00 ef 03 8a 00 | 0f 00 62 65 67 69 6e 20 |........|..begin |
|00006040| 73 65 6c 6c 20 64 61 74 | 65 00 00 00 00 f0 03 8a |sell dat|e.......|
|00006050| 00 0d 00 65 6e 64 20 73 | 65 6c 6c 20 64 61 74 65 |...end s|ell date|
|00006060| 00 00 00 00 f1 03 be 00 | 0d 00 77 6f 72 6b 20 6f |........|..work o|
|00006070| 72 64 65 72 20 69 64 00 | 00 00 00 f2 03 e2 00 08 |rder id.|........|
|00006080| 00 63 62 72 20 6e 61 6d | 65 00 00 00 00 f3 03 f9 |.cbr nam|e.......|
|00006090| 00 0d 00 64 61 74 65 20 | 61 73 73 69 67 6e 65 64 |...date |assigned|
|000060a0| 00 00 00 00 f4 03 f9 00 | 0d 00 64 69 73 70 61 74 |........|..dispat|
|000060b0| 63 68 20 70 6f 6f 6c 00 | 00 00 00 f5 03 f9 00 10 |ch pool.|........|
|000060c0| 00 64 69 73 70 61 74 63 | 68 20 63 6f 6d 6d 65 6e |.dispatc|h commen|
|000060d0| 74 00 00 00 00 f6 03 f9 | 00 0f 00 65 73 74 69 6d |t.......|...estim|
|000060e0| 61 74 65 64 20 75 6e 69 | 74 73 00 00 00 00 f7 03 |ated uni|ts......|
|000060f0| f9 00 0b 00 61 63 74 69 | 6f 6e 20 63 6f 64 65 00 |....acti|on code.|
|00006100| 00 00 00 f8 03 c6 00 0b | 00 61 73 73 69 67 6e 65 |........|.assigne|
|00006110| 64 20 74 6f 00 00 00 00 | fa 03 c6 00 0b 00 61 63 |d to....|......ac|
|00006120| 63 65 70 74 65 64 20 62 | 79 00 00 00 00 fb 03 fa |cepted b|y.......|
|00006130| 00 0c 00 6c 69 73 74 69 | 6e 67 20 63 6f 64 65 00 |...listi|ng code.|
|00006140| 00 00 00 fc 03 fb 00 0d | 00 6c 69 73 74 69 6e 67 |........|.listing|
|00006150| 20 74 69 74 6c 65 00 00 | 00 00 fd 03 fb 00 11 00 | title..|........|
|00006160| 66 69 72 73 74 20 6e 61 | 6d 65 20 70 68 72 61 73 |first na|me phras|
|00006170| 65 00 00 00 00 fe 03 fb | 00 09 00 6c 61 73 74 20 |e.......|...last |
|00006180| 6e 61 6d 65 00 00 00 00 | ff 03 fc 00 10 00 6e 6f |name....|......no|
|00006190| 6e 2d 70 72 69 6d 61 72 | 79 20 63 69 74 79 00 00 |n-primar|y city..|
|000061a0| 00 00 00 04 fc 00 07 00 | 61 64 64 72 65 73 73 00 |........|address.|
|000061b0| 00 00 00 01 04 fd 00 05 | 00 63 6f 6c 6f 72 00 00 |........|.color..|
|000061c0| 00 00 02 04 fd 00 04 00 | 63 61 73 65 00 00 00 00 |........|case....|
|000061d0| 03 04 fd 00 04 00 66 6f | 6e 74 00 00 00 00 04 04 |......fo|nt......|
|000061e0| fd 00 0a 00 66 6f 6e 74 | 20 73 74 79 6c 65 00 00 |....font| style..|
|000061f0| 00 00 05 04 fd 00 09 00 | 66 6f 6e 74 20 73 69 7a |........|font siz|
|00006200| 65 00 00 00 00 06 04 fe | 00 13 00 6c 69 73 74 65 |e.......|...liste|
|00006210| 64 20 70 68 6f 6e 65 20 | 70 68 72 61 73 65 00 00 |d phone |phrase..|
|00006220| 00 00 08 04 00 01 0e 00 | 63 61 70 74 69 6f 6e 20 |........|caption |
|00006230| 70 68 72 61 73 65 00 00 | 00 00 09 04 01 01 12 00 |phrase..|........|
|00006240| 73 75 62 2d 63 61 70 74 | 69 6f 6e 20 70 68 72 61 |sub-capt|ion phra|
|00006250| 73 65 00 00 00 00 0a 04 | 00 01 0a 00 63 61 70 74 |se......|....capt|
|00006260| 69 6f 6e 20 69 64 00 00 | 00 00 0b 04 fb 00 0a 00 |ion id..|........|
|00006270| 6c 69 73 74 69 6e 67 20 | 69 64 00 00 00 00 0c 04 |listing |id......|
|00006280| fb 00 0c 00 6c 6e 5f 66 | 6f 72 6d 61 74 5f 69 64 |....ln_f|ormat_id|
|00006290| 00 00 00 00 0d 04 fb 00 | 0d 00 66 6e 70 5f 66 6f |........|..fnp_fo|
|000062a0| 72 6d 61 74 5f 69 64 00 | 00 00 00 0e 04 fb 00 0c |rmat_id.|........|
|000062b0| 00 6c 74 5f 66 6f 72 6d | 61 74 5f 69 64 00 00 00 |.lt_form|at_id...|
|000062c0| 00 0f 04 fc 00 0b 00 61 | 5f 66 6f 72 6d 61 74 5f |.......a|_format_|
|000062d0| 69 64 00 00 00 00 10 04 | fc 00 0d 00 6e 70 63 5f |id......|....npc_|
|000062e0| 66 6f 72 6d 61 74 5f 69 | 64 00 00 00 00 11 04 fe |format_i|d.......|
|000062f0| 00 0d 00 6c 70 70 5f 66 | 6f 72 6d 61 74 5f 69 64 |...lpp_f|ormat_id|
|00006300| 00 00 00 00 12 04 00 01 | 0c 00 63 70 5f 66 6f 72 |........|..cp_for|
|00006310| 6d 61 74 5f 69 64 00 00 | 00 00 13 04 01 01 0d 00 |mat_id..|........|
|00006320| 73 63 70 5f 66 6f 72 6d | 61 74 5f 69 64 00 00 00 |scp_form|at_id...|
|00006330| 00 14 04 fd 00 09 00 66 | 6f 72 6d 61 74 20 69 64 |.......f|ormat id|
|00006340| 00 00 00 00 15 04 ed 00 | 0b 00 70 72 69 6d 61 72 |........|..primar|
|00006350| 79 20 49 58 43 00 00 00 | 00 16 04 e0 00 12 00 73 |y IXC...|.......s|
|00006360| 75 62 6a 65 63 74 20 74 | 6f 20 74 61 78 20 61 6d |ubject t|o tax am|
|00006370| 74 00 00 00 00 17 04 7c | 00 10 00 61 75 74 68 6f |t......||...autho|
|00006380| 72 69 7a 61 74 69 6f 6e | 20 69 64 00 00 00 00 18 |rization| id.....|
|00006390| 04 74 00 0a 00 69 6e 20 | 63 61 72 65 20 6f 66 00 |.t...in |care of.|
|000063a0| 00 00 00 19 04 7c 00 13 | 00 6c 61 6e 67 75 61 67 |.....|..|.languag|
|000063b0| 65 20 70 72 65 66 65 72 | 65 6e 63 65 00 00 00 00 |e prefer|ence....|
|000063c0| 1a 04 7f 00 12 00 73 65 | 72 76 69 63 65 20 61 64 |......se|rvice ad|
|000063d0| 64 72 65 73 73 20 69 64 | 00 00 00 00 1e 04 b2 00 |dress id|........|
|000063e0| 13 00 6e 75 6d 62 65 72 | 20 6f 66 20 6c 6f 63 61 |..number| of loca|
|000063f0| 74 69 6f 6e 73 00 00 00 | 00 1f 04 02 01 0f 00 62 |tions...|.......b|
+--------+-------------------------+-------------------------+--------+--------+
Only 25.0 KB of data is shown above.
