home *** CD-ROM | disk | FTP | other *** search
| AllFusion ERwin data | 1997-02-16 | 33.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 3b 00 14 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 3f 1b 82 02 64 e6 | 98 88 17 01 82 02 61 17 |l.?...d.|......a.|
|00000030| 67 2c 02 00 ff 0c 00 00 | 6e e6 3f 1b 01 00 00 00 |g,......|n.?.....|
|00000040| 24 00 2c 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |$.,.....|........|
|00000050| 00 00 01 00 00 00 00 00 | 00 00 00 00 01 00 08 00 |........|........|
|00000060| 01 00 03 00 01 00 ae 00 | 5b 1b 00 00 01 00 00 00 |........|[.......|
|00000070| 01 00 08 00 43 48 41 52 | 28 31 38 29 02 00 00 00 |....CHAR|(18)....|
|00000080| 07 00 4e 6f 74 65 20 49 | 44 ff ff 00 00 00 01 00 |..Note I|D.......|
|00000090| 09 00 4e 6f 74 65 20 54 | 65 78 74 ff ff 00 00 00 |..Note T|ext.....|
|000000a0| 00 00 04 00 01 00 0b 00 | 44 6f 6d 61 69 6e 20 4e |........|Domain N|
|000000b0| 61 6d 65 c8 00 00 00 00 | 01 00 0b 00 44 6f 6d 61 |ame.....|....Doma|
|000000c0| 69 6e 20 52 75 6c 65 00 | 00 00 00 00 01 00 0a 00 |in Rule.|........|
|000000d0| 44 6f 6d 61 69 6e 20 53 | 65 74 00 00 00 00 00 00 |Domain S|et......|
|000000e0| 00 12 00 44 6f 6d 61 69 | 6e 20 55 73 61 67 65 20 |...Domai|n Usage |
|000000f0| 43 6f 75 6e 74 00 00 00 | 00 00 00 00 02 00 01 00 |Count...|........|
|00000100| 0c 00 44 65 66 61 75 6c | 74 20 4e 61 6d 65 1e 00 |..Defaul|t Name..|
|00000110| 00 00 00 01 00 0c 00 44 | 65 66 61 75 6c 74 20 52 |.......D|efault R|
|00000120| 75 6c 65 64 00 00 00 00 | 00 00 07 00 01 00 06 00 |uled....|........|
|00000130| 44 6f 6d 61 69 6e 12 00 | 00 00 00 01 00 09 00 44 |Domain..|.......D|
|00000140| 61 74 61 20 54 79 70 65 | 13 00 00 00 00 00 00 0b |ata Type|........|
|00000150| 00 4e 75 6c 6c 20 4f 70 | 74 69 6f 6e 12 00 00 00 |.Null Op|tion....|
|00000160| 00 01 00 0a 00 4f 6c 64 | 20 44 6f 6d 61 69 6e 12 |.....Old| Domain.|
|00000170| 00 00 00 00 00 00 06 00 | 44 65 6c 65 74 65 12 00 |........|Delete..|
|00000180| 00 00 00 02 00 06 00 44 | 6f 6d 61 69 6e 0e 00 00 |.......D|omain...|
|00000190| 00 00 02 00 07 00 44 65 | 66 61 75 6c 74 0e 00 00 |......De|fault...|
|000001a0| 00 00 00 00 01 00 03 00 | 01 00 0d 00 54 65 6d 70 |........|....Temp|
|000001b0| 6c 61 74 65 20 4e 61 6d | 65 22 00 00 00 00 01 00 |late Nam|e"......|
|000001c0| 0d 00 54 65 6d 70 6c 61 | 74 65 20 43 6f 64 65 00 |..Templa|te Code.|
|000001d0| 00 00 00 00 00 00 0d 00 | 54 65 6d 70 6c 61 74 65 |........|Template|
|000001e0| 20 54 79 70 65 00 00 00 | 00 00 21 00 03 00 16 00 | Type...|..!.....|
|000001f0| 50 41 52 45 4e 54 20 55 | 50 44 41 54 45 20 52 45 |PARENT U|PDATE RE|
|00000200| 53 54 52 49 43 54 ad 01 | 20 20 20 20 2f 2a 20 45 |STRICT..| /* E|
|00000210| 52 77 69 6e 20 42 75 69 | 6c 74 69 6e 20 25 44 61 |Rwin Bui|ltin %Da|
|00000220| 74 65 74 69 6d 65 20 2a | 2f 0d 0a 20 20 20 20 2f |tetime *|/.. /|
|00000230| 2a 20 25 50 61 72 65 6e | 74 20 25 56 65 72 62 50 |* %Paren|t %VerbP|
|00000240| 68 72 61 73 65 20 25 43 | 68 69 6c 64 20 4f 4e 20 |hrase %C|hild ON |
|00000250| 50 41 52 45 4e 54 20 55 | 50 44 41 54 45 20 52 45 |PARENT U|PDATE RE|
|00000260| 53 54 52 49 43 54 20 2a | 2f 0d 0a 20 20 20 20 73 |STRICT *|/.. s|
|00000270| 65 6c 65 63 74 20 63 6f | 75 6e 74 28 2a 29 20 69 |elect co|unt(*) i|
|00000280| 6e 74 6f 20 6e 75 6d 72 | 6f 77 73 0d 0a 20 20 20 |nto numr|ows.. |
|00000290| 20 20 20 66 72 6f 6d 20 | 25 43 68 69 6c 64 0d 0a | from |%Child..|
|000002a0| 20 20 20 20 20 20 77 68 | 65 72 65 0d 0a 20 20 20 | wh|ere.. |
|000002b0| 20 20 20 20 20 2f 2a 20 | 20 25 25 4a 6f 69 6e 46 | /* | %%JoinF|
|000002c0| 4b 50 4b 28 25 43 68 69 | 6c 64 2c 3a 6f 6c 64 2c |KPK(%Chi|ld,:old,|
|000002d0| 22 20 3d 20 22 2c 22 20 | 61 6e 64 22 29 20 2a 2f |" = "," |and") */|
|000002e0| 0d 0a 20 20 20 20 20 20 | 20 20 25 4a 6f 69 6e 46 |.. | %JoinF|
|000002f0| 4b 50 4b 28 25 43 68 69 | 6c 64 2c 3a 6f 6c 64 2c |KPK(%Chi|ld,:old,|
|00000300| 22 20 3d 20 22 2c 22 20 | 61 6e 64 22 29 3b 0d 0a |" = "," |and");..|
|00000310| 20 20 20 20 69 66 20 28 | 6e 75 6d 72 6f 77 73 20 | if (|numrows |
|00000320| 3e 20 30 29 0d 0a 20 20 | 20 20 74 68 65 6e 20 0d |> 0).. | then .|
|00000330| 0a 20 20 20 20 20 20 72 | 61 69 73 65 5f 61 70 70 |. r|aise_app|
|00000340| 6c 69 63 61 74 69 6f 6e | 5f 65 72 72 6f 72 28 0d |lication|_error(.|
|00000350| 0a 20 20 20 20 20 20 20 | 20 2d 32 30 30 30 35 2c |. | -20005,|
|00000360| 0d 0a 20 20 20 20 20 20 | 20 20 27 43 61 6e 6e 6f |.. | 'Canno|
|00000370| 74 20 55 50 44 41 54 45 | 20 22 25 50 61 72 65 6e |t UPDATE| "%Paren|
|00000380| 74 22 20 62 65 63 61 75 | 73 65 20 22 25 43 68 69 |t" becau|se "%Chi|
|00000390| 6c 64 22 20 65 78 69 73 | 74 73 2e 27 0d 0a 20 20 |ld" exis|ts.'.. |
|000003a0| 20 20 20 20 29 3b 0d 0a | 20 20 20 20 65 6e 64 20 | );..| end |
|000003b0| 69 66 3b 0d 0a 10 27 03 | 00 15 00 50 41 52 45 4e |if;...'.|...PAREN|
|000003c0| 54 20 55 50 44 41 54 45 | 20 43 41 53 43 41 44 45 |T UPDATE| CASCADE|
|000003d0| b8 01 20 20 2f 2a 20 45 | 52 77 69 6e 20 42 75 69 |.. /* E|Rwin Bui|
|000003e0| 6c 74 69 6e 20 25 44 61 | 74 65 74 69 6d 65 20 2a |ltin %Da|tetime *|
|000003f0| 2f 0d 0a 20 20 2f 2a 20 | 25 50 61 72 65 6e 74 20 |/.. /* |%Parent |
|00000400| 25 56 65 72 62 50 68 72 | 61 73 65 20 25 43 68 69 |%VerbPhr|ase %Chi|
|00000410| 6c 64 20 4f 4e 20 50 41 | 52 45 4e 54 20 55 50 44 |ld ON PA|RENT UPD|
|00000420| 41 54 45 20 43 41 53 43 | 41 44 45 20 2a 2f 0d 0a |ATE CASC|ADE */..|
|00000430| 20 20 69 66 0d 0a 20 20 | 20 20 2f 2a 20 25 25 4a | if.. | /* %%J|
|00000440| 6f 69 6e 50 4b 50 4b 28 | 3a 6f 6c 64 2c 3a 6e 65 |oinPKPK(|:old,:ne|
|00000450| 77 2c 22 20 3c 3e 20 22 | 2c 22 20 6f 72 20 22 29 |w," <> "|," or ")|
|00000460| 20 2a 2f 0d 0a 20 20 20 | 20 25 4a 6f 69 6e 50 4b | */.. | %JoinPK|
|00000470| 50 4b 28 3a 6f 6c 64 2c | 3a 6e 65 77 2c 22 20 3c |PK(:old,|:new," <|
|00000480| 3e 20 22 2c 22 20 6f 72 | 20 22 29 0d 0a 20 20 74 |> "," or| ").. t|
|00000490| 68 65 6e 0d 0a 20 20 20 | 20 75 70 64 61 74 65 20 |hen.. | update |
|000004a0| 25 43 68 69 6c 64 0d 0a | 20 20 20 20 20 20 73 65 |%Child..| se|
|000004b0| 74 0d 0a 20 20 20 20 20 | 20 20 20 2f 2a 20 20 25 |t.. | /* %|
|000004c0| 25 4a 6f 69 6e 46 4b 50 | 4b 28 25 43 68 69 6c 64 |%JoinFKP|K(%Child|
|000004d0| 2c 3a 6e 65 77 2c 22 20 | 3d 20 22 2c 22 2c 22 29 |,:new," |= ",",")|
|000004e0| 20 2a 2f 0d 0a 20 20 20 | 20 20 20 20 20 25 4a 6f | */.. | %Jo|
|000004f0| 69 6e 46 4b 50 4b 28 25 | 43 68 69 6c 64 2c 3a 6e |inFKPK(%|Child,:n|
|00000500| 65 77 2c 22 20 3d 20 22 | 2c 22 2c 22 29 0d 0a 20 |ew," = "|,",").. |
|00000510| 20 20 20 20 20 77 68 65 | 72 65 0d 0a 20 20 20 20 | whe|re.. |
|00000520| 20 20 20 20 2f 2a 20 20 | 25 25 4a 6f 69 6e 46 4b | /* |%%JoinFK|
|00000530| 50 4b 28 25 43 68 69 6c | 64 2c 3a 6f 6c 64 2c 22 |PK(%Chil|d,:old,"|
|00000540| 20 3d 20 22 2c 22 20 61 | 6e 64 22 29 20 2a 2f 0d | = "," a|nd") */.|
|00000550| 0a 20 20 20 20 20 20 20 | 20 25 4a 6f 69 6e 46 4b |. | %JoinFK|
|00000560| 50 4b 28 25 43 68 69 6c | 64 2c 3a 6f 6c 64 2c 22 |PK(%Chil|d,:old,"|
|00000570| 20 3d 20 22 2c 22 20 61 | 6e 64 22 29 3b 0d 0a 20 | = "," a|nd");.. |
|00000580| 20 65 6e 64 20 69 66 3b | 0d 0a 11 27 03 00 16 00 | end if;|...'....|
|00000590| 50 41 52 45 4e 54 20 55 | 50 44 41 54 45 20 53 45 |PARENT U|PDATE SE|
|000005a0| 54 20 4e 55 4c 4c 75 01 | 20 20 2f 2a 20 25 50 61 |T NULLu.| /* %Pa|
|000005b0| 72 65 6e 74 20 25 56 65 | 72 62 50 68 72 61 73 65 |rent %Ve|rbPhrase|
|000005c0| 20 25 43 68 69 6c 64 20 | 4f 4e 20 50 41 52 45 4e | %Child |ON PAREN|
|000005d0| 54 20 55 50 44 41 54 45 | 20 53 45 54 20 4e 55 4c |T UPDATE| SET NUL|
|000005e0| 4c 20 2a 2f 0d 0a 20 20 | 69 66 0d 0a 20 20 20 20 |L */.. |if.. |
|000005f0| 2f 2a 20 25 25 4a 6f 69 | 6e 50 4b 50 4b 28 3a 6f |/* %%Joi|nPKPK(:o|
|00000600| 6c 64 2c 3a 6e 65 77 2c | 22 20 3c 3e 20 22 2c 22 |ld,:new,|" <> ","|
|00000610| 20 6f 72 20 22 20 2a 2f | 0d 0a 20 20 20 20 25 4a | or " */|.. %J|
|00000620| 6f 69 6e 50 4b 50 4b 28 | 3a 6f 6c 64 2c 3a 6e 65 |oinPKPK(|:old,:ne|
|00000630| 77 2c 22 20 3c 3e 20 22 | 2c 22 20 6f 72 20 22 29 |w," <> "|," or ")|
|00000640| 0d 0a 20 20 74 68 65 6e | 0d 0a 20 20 20 20 75 70 |.. then|.. up|
|00000650| 64 61 74 65 20 25 43 68 | 69 6c 64 0d 0a 20 20 20 |date %Ch|ild.. |
|00000660| 20 20 20 73 65 74 0d 0a | 20 20 20 20 20 20 20 20 | set..| |
|00000670| 2f 2a 20 25 25 53 65 74 | 46 4b 28 25 43 68 69 6c |/* %%Set|FK(%Chil|
|00000680| 64 2c 4e 55 4c 4c 29 20 | 2a 2f 0d 0a 20 20 20 20 |d,NULL) |*/.. |
|00000690| 20 20 20 20 25 53 65 74 | 46 4b 28 25 43 68 69 6c | %Set|FK(%Chil|
|000006a0| 64 2c 4e 55 4c 4c 29 0d | 0a 20 20 20 20 20 20 77 |d,NULL).|. w|
|000006b0| 68 65 72 65 0d 0a 20 20 | 20 20 20 20 20 20 2f 2a |here.. | /*|
|000006c0| 20 25 25 4a 6f 69 6e 46 | 4b 50 4b 28 25 43 68 69 | %%JoinF|KPK(%Chi|
|000006d0| 6c 64 2c 3a 6f 6c 64 2c | 22 20 3d 20 22 2c 22 2c |ld,:old,|" = ",",|
|000006e0| 22 29 20 2a 2f 0d 0a 20 | 20 20 20 20 20 20 20 25 |") */.. | %|
|000006f0| 4a 6f 69 6e 46 4b 50 4b | 28 25 43 68 69 6c 64 2c |JoinFKPK|(%Child,|
|00000700| 3a 6f 6c 64 2c 22 20 3d | 20 22 2c 22 2c 22 29 3b |:old," =| ",",");|
|00000710| 0d 0a 20 20 65 6e 64 20 | 69 66 3b 0d 0a 12 27 03 |.. end |if;...'.|
|00000720| 00 16 00 50 41 52 45 4e | 54 20 44 45 4c 45 54 45 |...PAREN|T DELETE|
|00000730| 20 52 45 53 54 52 49 43 | 54 ac 01 20 20 20 20 2f | RESTRIC|T.. /|
|00000740| 2a 20 45 52 77 69 6e 20 | 42 75 69 6c 74 69 6e 20 |* ERwin |Builtin |
|00000750| 25 44 61 74 65 74 69 6d | 65 20 2a 2f 0d 0a 20 20 |%Datetim|e */.. |
|00000760| 20 20 2f 2a 20 25 50 61 | 72 65 6e 74 20 25 56 65 | /* %Pa|rent %Ve|
|00000770| 72 62 50 68 72 61 73 65 | 20 25 43 68 69 6c 64 20 |rbPhrase| %Child |
|00000780| 4f 4e 20 50 41 52 45 4e | 54 20 44 45 4c 45 54 45 |ON PAREN|T DELETE|
|00000790| 20 52 45 53 54 52 49 43 | 54 20 2a 2f 0d 0a 20 20 | RESTRIC|T */.. |
|000007a0| 20 20 73 65 6c 65 63 74 | 20 63 6f 75 6e 74 28 2a | select| count(*|
|000007b0| 29 20 69 6e 74 6f 20 6e | 75 6d 72 6f 77 73 0d 0a |) into n|umrows..|
|000007c0| 20 20 20 20 20 20 66 72 | 6f 6d 20 25 43 68 69 6c | fr|om %Chil|
|000007d0| 64 0d 0a 20 20 20 20 20 | 20 77 68 65 72 65 0d 0a |d.. | where..|
|000007e0| 20 20 20 20 20 20 20 20 | 2f 2a 20 20 25 25 4a 6f | |/* %%Jo|
|000007f0| 69 6e 46 4b 50 4b 28 25 | 43 68 69 6c 64 2c 3a 6f |inFKPK(%|Child,:o|
|00000800| 6c 64 2c 22 20 3d 20 22 | 2c 22 20 61 6e 64 22 29 |ld," = "|," and")|
|00000810| 20 2a 2f 0d 0a 20 20 20 | 20 20 20 20 20 25 4a 6f | */.. | %Jo|
|00000820| 69 6e 46 4b 50 4b 28 25 | 43 68 69 6c 64 2c 3a 6f |inFKPK(%|Child,:o|
|00000830| 6c 64 2c 22 20 3d 20 22 | 2c 22 20 61 6e 64 22 29 |ld," = "|," and")|
|00000840| 3b 0d 0a 20 20 20 20 69 | 66 20 28 6e 75 6d 72 6f |;.. i|f (numro|
|00000850| 77 73 20 3e 20 30 29 0d | 0a 20 20 20 20 74 68 65 |ws > 0).|. the|
|00000860| 6e 0d 0a 20 20 20 20 20 | 20 72 61 69 73 65 5f 61 |n.. | raise_a|
|00000870| 70 70 6c 69 63 61 74 69 | 6f 6e 5f 65 72 72 6f 72 |pplicati|on_error|
|00000880| 28 0d 0a 20 20 20 20 20 | 20 20 20 2d 32 30 30 30 |(.. | -2000|
|00000890| 31 2c 0d 0a 20 20 20 20 | 20 20 20 20 27 43 61 6e |1,.. | 'Can|
|000008a0| 6e 6f 74 20 44 45 4c 45 | 54 45 20 22 25 50 61 72 |not DELE|TE "%Par|
|000008b0| 65 6e 74 22 20 62 65 63 | 61 75 73 65 20 22 25 43 |ent" bec|ause "%C|
|000008c0| 68 69 6c 64 22 20 65 78 | 69 73 74 73 2e 27 0d 0a |hild" ex|ists.'..|
|000008d0| 20 20 20 20 20 20 29 3b | 0d 0a 20 20 20 20 65 6e | );|.. en|
|000008e0| 64 20 69 66 3b 0d 0a 14 | 27 03 00 15 00 50 41 52 |d if;...|'....PAR|
|000008f0| 45 4e 54 20 44 45 4c 45 | 54 45 20 43 41 53 43 41 |ENT DELE|TE CASCA|
|00000900| 44 45 ea 00 20 20 20 20 | 2f 2a 20 45 52 77 69 6e |DE.. |/* ERwin|
|00000910| 20 42 75 69 6c 74 69 6e | 20 25 44 61 74 65 74 69 | Builtin| %Dateti|
|00000920| 6d 65 20 2a 2f 0d 0a 20 | 20 20 20 2f 2a 20 25 50 |me */.. | /* %P|
|00000930| 61 72 65 6e 74 20 25 56 | 65 72 62 50 68 72 61 73 |arent %V|erbPhras|
|00000940| 65 20 25 43 68 69 6c 64 | 20 4f 4e 20 50 41 52 45 |e %Child| ON PARE|
|00000950| 4e 54 20 44 45 4c 45 54 | 45 20 43 41 53 43 41 44 |NT DELET|E CASCAD|
|00000960| 45 20 2a 2f 0d 0a 20 20 | 20 20 64 65 6c 65 74 65 |E */.. | delete|
|00000970| 20 66 72 6f 6d 20 25 43 | 68 69 6c 64 0d 0a 20 20 | from %C|hild.. |
|00000980| 20 20 20 20 77 68 65 72 | 65 0d 0a 20 20 20 20 20 | wher|e.. |
|00000990| 20 20 20 2f 2a 20 20 25 | 25 4a 6f 69 6e 46 4b 50 | /* %|%JoinFKP|
|000009a0| 4b 28 25 43 68 69 6c 64 | 2c 3a 6f 6c 64 2c 22 20 |K(%Child|,:old," |
|000009b0| 3d 20 22 2c 22 20 61 6e | 64 22 29 20 2a 2f 0d 0a |= "," an|d") */..|
|000009c0| 20 20 20 20 20 20 20 20 | 25 4a 6f 69 6e 46 4b 50 | |%JoinFKP|
|000009d0| 4b 28 25 43 68 69 6c 64 | 2c 3a 6f 6c 64 2c 22 20 |K(%Child|,:old," |
|000009e0| 3d 20 22 2c 22 20 61 6e | 64 22 29 3b 0d 0a 15 27 |= "," an|d");...'|
|000009f0| 03 00 16 00 50 41 52 45 | 4e 54 20 44 45 4c 45 54 |....PARE|NT DELET|
|00000a00| 45 20 53 45 54 20 4e 55 | 4c 4c 31 01 20 20 20 20 |E SET NU|LL1. |
|00000a10| 2f 2a 20 45 52 77 69 6e | 20 42 75 69 6c 74 69 6e |/* ERwin| Builtin|
|00000a20| 20 25 44 61 74 65 74 69 | 6d 65 20 2a 2f 0d 0a 20 | %Dateti|me */.. |
|00000a30| 20 20 20 2f 2a 20 25 50 | 61 72 65 6e 74 20 25 56 | /* %P|arent %V|
|00000a40| 65 72 62 50 68 72 61 73 | 65 20 25 43 68 69 6c 64 |erbPhras|e %Child|
|00000a50| 20 4f 4e 20 50 41 52 45 | 4e 54 20 44 45 4c 45 54 | ON PARE|NT DELET|
|00000a60| 45 20 53 45 54 20 4e 55 | 4c 4c 20 2a 2f 0d 0a 20 |E SET NU|LL */.. |
|00000a70| 20 20 20 75 70 64 61 74 | 65 20 25 43 68 69 6c 64 | updat|e %Child|
|00000a80| 0d 0a 20 20 20 20 20 20 | 73 65 74 0d 0a 20 20 20 |.. |set.. |
|00000a90| 20 20 20 20 20 2f 2a 20 | 25 25 53 65 74 46 4b 28 | /* |%%SetFK(|
|00000aa0| 25 43 68 69 6c 64 2c 4e | 55 4c 4c 29 20 2a 2f 0d |%Child,N|ULL) */.|
|00000ab0| 0a 20 20 20 20 20 20 20 | 20 25 53 65 74 46 4b 28 |. | %SetFK(|
|00000ac0| 25 43 68 69 6c 64 2c 4e | 55 4c 4c 29 0d 0a 20 20 |%Child,N|ULL).. |
|00000ad0| 20 20 20 20 77 68 65 72 | 65 0d 0a 20 20 20 20 20 | wher|e.. |
|00000ae0| 20 20 20 2f 2a 20 25 25 | 4a 6f 69 6e 46 4b 50 4b | /* %%|JoinFKPK|
|00000af0| 28 25 43 68 69 6c 64 2c | 3a 6f 6c 64 2c 22 20 3d |(%Child,|:old," =|
|00000b00| 20 22 2c 22 20 61 6e 64 | 22 29 20 2a 2f 0d 0a 20 | "," and|") */.. |
|00000b10| 20 20 20 20 20 20 20 25 | 4a 6f 69 6e 46 4b 50 4b | %|JoinFKPK|
|00000b20| 28 25 43 68 69 6c 64 2c | 3a 6f 6c 64 2c 22 20 3d |(%Child,|:old," =|
|00000b30| 20 22 2c 22 20 61 6e 64 | 22 29 3b 0d 0a 16 27 03 | "," and|");...'.|
|00000b40| 00 15 00 43 48 49 4c 44 | 20 49 4e 53 45 52 54 20 |...CHILD| INSERT |
|00000b50| 52 45 53 54 52 49 43 54 | 20 02 20 20 20 20 2f 2a |RESTRICT| . /*|
|00000b60| 20 45 52 77 69 6e 20 42 | 75 69 6c 74 69 6e 20 25 | ERwin B|uiltin %|
|00000b70| 44 61 74 65 74 69 6d 65 | 20 2a 2f 0d 0a 20 20 20 |Datetime| */.. |
|00000b80| 20 2f 2a 20 25 50 61 72 | 65 6e 74 20 25 56 65 72 | /* %Par|ent %Ver|
|00000b90| 62 50 68 72 61 73 65 20 | 25 43 68 69 6c 64 20 4f |bPhrase |%Child O|
|00000ba0| 4e 20 43 48 49 4c 44 20 | 49 4e 53 45 52 54 20 52 |N CHILD |INSERT R|
|00000bb0| 45 53 54 52 49 43 54 20 | 2a 2f 0d 0a 20 20 20 20 |ESTRICT |*/.. |
|00000bc0| 73 65 6c 65 63 74 20 63 | 6f 75 6e 74 28 2a 29 20 |select c|ount(*) |
|00000bd0| 69 6e 74 6f 20 6e 75 6d | 72 6f 77 73 0d 0a 20 20 |into num|rows.. |
|00000be0| 20 20 20 20 66 72 6f 6d | 20 25 50 61 72 65 6e 74 | from| %Parent|
|00000bf0| 0d 0a 20 20 20 20 20 20 | 77 68 65 72 65 0d 0a 20 |.. |where.. |
|00000c00| 20 20 20 20 20 20 20 2f | 2a 20 25 25 4a 6f 69 6e | /|* %%Join|
|00000c10| 46 4b 50 4b 28 3a 6e 65 | 77 2c 25 50 61 72 65 6e |FKPK(:ne|w,%Paren|
|00000c20| 74 2c 22 20 3d 20 22 2c | 22 20 61 6e 64 22 29 20 |t," = ",|" and") |
|00000c30| 2a 2f 0d 0a 20 20 20 20 | 20 20 20 20 25 4a 6f 69 |*/.. | %Joi|
|00000c40| 6e 46 4b 50 4b 28 3a 6e | 65 77 2c 25 50 61 72 65 |nFKPK(:n|ew,%Pare|
|00000c50| 6e 74 2c 22 20 3d 20 22 | 2c 22 20 61 6e 64 22 29 |nt," = "|," and")|
|00000c60| 3b 0d 0a 20 20 20 20 69 | 66 20 28 0d 0a 20 20 20 |;.. i|f (.. |
|00000c70| 20 20 20 2f 2a 20 25 25 | 4e 6f 74 6e 75 6c 6c 46 | /* %%|NotnullF|
|00000c80| 4b 28 3a 6e 65 77 2c 22 | 20 69 73 20 6e 6f 74 20 |K(:new,"| is not |
|00000c90| 6e 75 6c 6c 20 61 6e 64 | 22 29 20 2a 2f 0d 0a 20 |null and|") */.. |
|00000ca0| 20 20 20 20 20 25 4e 6f | 74 6e 75 6c 6c 46 4b 28 | %No|tnullFK(|
|00000cb0| 3a 6e 65 77 2c 22 20 69 | 73 20 6e 6f 74 20 6e 75 |:new," i|s not nu|
|00000cc0| 6c 6c 20 61 6e 64 22 29 | 0d 0a 20 20 20 20 20 20 |ll and")|.. |
|00000cd0| 6e 75 6d 72 6f 77 73 20 | 3d 20 30 0d 0a 20 20 20 |numrows |= 0.. |
|00000ce0| 20 29 0d 0a 20 20 20 20 | 74 68 65 6e 0d 0a 20 20 | ).. |then.. |
|00000cf0| 20 20 20 20 72 61 69 73 | 65 5f 61 70 70 6c 69 63 | rais|e_applic|
|00000d00| 61 74 69 6f 6e 5f 65 72 | 72 6f 72 28 0d 0a 20 20 |ation_er|ror(.. |
|00000d10| 20 20 20 20 20 20 2d 32 | 30 30 30 32 2c 0d 0a 20 | -2|0002,.. |
|00000d20| 20 20 20 20 20 20 20 27 | 43 61 6e 6e 6f 74 20 49 | '|Cannot I|
|00000d30| 4e 53 45 52 54 20 22 25 | 43 68 69 6c 64 22 20 62 |NSERT "%|Child" b|
|00000d40| 65 63 61 75 73 65 20 22 | 25 50 61 72 65 6e 74 22 |ecause "|%Parent"|
|00000d50| 20 64 6f 65 73 20 6e 6f | 74 20 65 78 69 73 74 2e | does no|t exist.|
|00000d60| 27 0d 0a 20 20 20 20 20 | 20 29 3b 0d 0a 20 20 20 |'.. | );.. |
|00000d70| 20 65 6e 64 20 69 66 3b | 0d 0a 18 27 03 00 14 00 | end if;|...'....|
|00000d80| 43 48 49 4c 44 20 49 4e | 53 45 52 54 20 43 41 53 |CHILD IN|SERT CAS|
|00000d90| 43 41 44 45 fc 01 20 20 | 2f 2a 20 45 52 77 69 6e |CADE.. |/* ERwin|
|00000da0| 20 42 75 69 6c 74 69 6e | 20 25 44 61 74 65 74 69 | Builtin| %Dateti|
|00000db0| 6d 65 20 2a 2f 0d 0a 20 | 20 2f 2a 20 25 50 61 72 |me */.. | /* %Par|
|00000dc0| 65 6e 74 20 25 56 65 72 | 62 50 68 72 61 73 65 20 |ent %Ver|bPhrase |
|00000dd0| 25 43 68 69 6c 64 20 4f | 4e 20 43 48 49 4c 44 20 |%Child O|N CHILD |
|00000de0| 49 4e 53 45 52 54 20 43 | 41 53 43 41 44 45 20 2a |INSERT C|ASCADE *|
|00000df0| 2f 0d 0a 20 20 20 20 69 | 6e 73 65 72 74 20 69 6e |/.. i|nsert in|
|00000e00| 74 6f 20 25 50 61 72 65 | 6e 74 20 28 25 50 61 72 |to %Pare|nt (%Par|
|00000e10| 65 6e 74 50 4b 28 22 2c | 22 2c 29 29 0d 0a 20 20 |entPK(",|",)).. |
|00000e20| 20 20 20 20 73 65 6c 65 | 63 74 20 25 43 68 69 6c | sele|ct %Chil|
|00000e30| 64 46 4b 28 22 2c 22 2c | 29 0d 0a 20 20 20 20 20 |dFK(",",|).. |
|00000e40| 20 20 20 66 72 6f 6d 20 | 6e 65 77 0d 0a 20 20 20 | from |new.. |
|00000e50| 20 20 20 20 20 77 68 65 | 72 65 0d 0a 20 20 20 20 | whe|re.. |
|00000e60| 20 20 20 20 20 20 2f 2a | 20 25 25 4e 6f 74 6e 75 | /*| %%Notnu|
|00000e70| 6c 6c 46 4b 28 3a 6e 65 | 77 2c 22 20 69 73 20 6e |llFK(:ne|w," is n|
|00000e80| 6f 74 20 6e 75 6c 6c 20 | 61 6e 64 22 29 20 2a 2f |ot null |and") */|
|00000e90| 0d 0a 20 20 20 20 20 20 | 20 20 20 20 25 4e 6f 74 |.. | %Not|
|00000ea0| 6e 75 6c 6c 46 4b 28 3a | 6e 65 77 2c 22 20 69 73 |nullFK(:|new," is|
|00000eb0| 20 6e 6f 74 20 6e 75 6c | 6c 20 61 6e 64 22 29 0d | not nul|l and").|
|00000ec0| 0a 20 20 20 20 20 20 20 | 20 20 20 6e 6f 74 20 65 |. | not e|
|00000ed0| 78 69 73 74 73 20 28 0d | 0a 20 20 20 20 20 20 20 |xists (.|. |
|00000ee0| 20 20 20 20 20 73 65 6c | 65 63 74 20 2a 20 66 72 | sel|ect * fr|
|00000ef0| 6f 6d 20 25 50 61 72 65 | 6e 74 0d 0a 20 20 20 20 |om %Pare|nt.. |
|00000f00| 20 20 20 20 20 20 20 20 | 20 20 77 68 65 72 65 0d | | where.|
|00000f10| 0a 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |. | |
|00000f20| 20 2f 2a 20 25 25 4a 6f | 69 6e 46 4b 50 4b 28 3a | /* %%Jo|inFKPK(:|
|00000f30| 6e 65 77 2c 25 50 61 72 | 65 6e 74 2c 22 20 3d 20 |new,%Par|ent," = |
|00000f40| 22 2c 22 20 61 6e 64 22 | 29 20 2a 2f 0d 0a 20 20 |"," and"|) */.. |
|00000f50| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 25 4a | | %J|
|00000f60| 6f 69 6e 46 4b 50 4b 28 | 3a 6e 65 77 2c 25 50 61 |oinFKPK(|:new,%Pa|
|00000f70| 72 65 6e 74 2c 22 20 3d | 20 22 2c 22 20 61 6e 64 |rent," =| "," and|
|00000f80| 22 29 0d 0a 20 20 20 20 | 20 20 20 20 20 20 29 3b |").. | );|
|00000f90| 0d 0a 19 27 03 00 14 00 | 43 48 49 4c 44 20 49 4e |...'....|CHILD IN|
|00000fa0| 53 45 52 54 20 53 45 54 | 4e 55 4c 4c f8 01 20 20 |SERT SET|NULL.. |
|00000fb0| 20 20 2f 2a 20 45 52 77 | 69 6e 20 42 75 69 6c 74 | /* ERw|in Built|
|00000fc0| 69 6e 20 25 44 61 74 65 | 74 69 6d 65 20 2a 2f 0d |in %Date|time */.|
|00000fd0| 0a 20 20 20 20 2f 2a 20 | 25 50 61 72 65 6e 74 20 |. /* |%Parent |
|00000fe0| 25 56 65 72 62 50 68 72 | 61 73 65 20 25 43 68 69 |%VerbPhr|ase %Chi|
|00000ff0| 6c 64 20 4f 4e 20 43 48 | 49 4c 44 20 49 4e 53 45 |ld ON CH|ILD INSE|
|00001000| 52 54 20 53 45 54 20 4e | 55 4c 4c 20 2a 2f 0d 0a |RT SET N|ULL */..|
|00001010| 20 20 20 20 75 70 64 61 | 74 65 20 25 43 68 69 6c | upda|te %Chil|
|00001020| 64 0d 0a 20 20 20 20 20 | 20 73 65 74 0d 0a 20 20 |d.. | set.. |
|00001030| 20 20 20 20 20 20 2f 2a | 20 25 25 53 65 74 46 4b | /*| %%SetFK|
|00001040| 28 25 43 68 69 6c 64 2c | 4e 55 4c 4c 29 20 2a 2f |(%Child,|NULL) */|
|00001050| 0d 0a 20 20 20 20 20 20 | 20 20 25 53 65 74 46 4b |.. | %SetFK|
|00001060| 28 25 43 68 69 6c 64 2c | 4e 55 4c 4c 29 0d 0a 20 |(%Child,|NULL).. |
|00001070| 20 20 20 20 20 77 68 65 | 72 65 0d 0a 20 20 20 20 | whe|re.. |
|00001080| 20 20 20 20 6e 6f 74 20 | 65 78 69 73 74 73 20 28 | not |exists (|
|00001090| 0d 0a 20 20 20 20 20 20 | 20 20 20 20 73 65 6c 65 |.. | sele|
|000010a0| 63 74 20 2a 20 66 72 6f | 6d 20 25 50 61 72 65 6e |ct * fro|m %Paren|
|000010b0| 74 0d 0a 20 20 20 20 20 | 20 20 20 20 20 20 20 77 |t.. | w|
|000010c0| 68 65 72 65 0d 0a 20 20 | 20 20 20 20 20 20 20 20 |here.. | |
|000010d0| 20 20 20 20 2f 2a 20 25 | 25 4a 6f 69 6e 46 4b 50 | /* %|%JoinFKP|
|000010e0| 4b 28 3a 6e 65 77 2c 25 | 50 61 72 65 6e 74 2c 22 |K(:new,%|Parent,"|
|000010f0| 20 3d 20 22 2c 22 20 61 | 6e 64 22 29 20 2a 2f 0d | = "," a|nd") */.|
|00001100| 0a 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 25 |. | %|
|00001110| 4a 6f 69 6e 46 4b 50 4b | 28 3a 6e 65 77 2c 25 50 |JoinFKPK|(:new,%P|
|00001120| 61 72 65 6e 74 2c 22 20 | 3d 20 22 2c 22 20 61 6e |arent," |= "," an|
|00001130| 64 22 29 0d 0a 20 20 20 | 20 20 20 20 20 29 20 61 |d").. | ) a|
|00001140| 6e 64 0d 0a 20 20 20 20 | 20 20 20 20 2f 2a 20 25 |nd.. | /* %|
|00001150| 25 4a 6f 69 6e 50 4b 50 | 4b 28 25 43 68 69 6c 64 |%JoinPKP|K(%Child|
|00001160| 2c 3a 6e 65 77 2c 22 20 | 3d 20 22 2c 22 20 61 6e |,:new," |= "," an|
|00001170| 64 22 29 20 2a 2f 0d 0a | 20 20 20 20 20 20 20 20 |d") */..| |
|00001180| 25 4a 6f 69 6e 50 4b 50 | 4b 28 25 43 68 69 6c 64 |%JoinPKP|K(%Child|
|00001190| 2c 3a 6e 65 77 2c 22 20 | 3d 20 22 2c 22 20 61 6e |,:new," |= "," an|
|000011a0| 64 22 29 3b 0d 0a 1a 27 | 03 00 15 00 43 48 49 4c |d");...'|....CHIL|
|000011b0| 44 20 55 50 44 41 54 45 | 20 52 45 53 54 52 49 43 |D UPDATE| RESTRIC|
|000011c0| 54 20 02 20 20 20 20 2f | 2a 20 45 52 77 69 6e 20 |T . /|* ERwin |
|000011d0| 42 75 69 6c 74 69 6e 20 | 25 44 61 74 65 74 69 6d |Builtin |%Datetim|
|000011e0| 65 20 2a 2f 0d 0a 20 20 | 20 20 2f 2a 20 25 50 61 |e */.. | /* %Pa|
|000011f0| 72 65 6e 74 20 25 56 65 | 72 62 50 68 72 61 73 65 |rent %Ve|rbPhrase|
|00001200| 20 25 43 68 69 6c 64 20 | 4f 4e 20 43 48 49 4c 44 | %Child |ON CHILD|
|00001210| 20 55 50 44 41 54 45 20 | 52 45 53 54 52 49 43 54 | UPDATE |RESTRICT|
|00001220| 20 2a 2f 0d 0a 20 20 20 | 20 73 65 6c 65 63 74 20 | */.. | select |
|00001230| 63 6f 75 6e 74 28 2a 29 | 20 69 6e 74 6f 20 6e 75 |count(*)| into nu|
|00001240| 6d 72 6f 77 73 0d 0a 20 | 20 20 20 20 20 66 72 6f |mrows.. | fro|
|00001250| 6d 20 25 50 61 72 65 6e | 74 0d 0a 20 20 20 20 20 |m %Paren|t.. |
|00001260| 20 77 68 65 72 65 0d 0a | 20 20 20 20 20 20 20 20 | where..| |
|00001270| 2f 2a 20 25 25 4a 6f 69 | 6e 46 4b 50 4b 28 3a 6e |/* %%Joi|nFKPK(:n|
|00001280| 65 77 2c 25 50 61 72 65 | 6e 74 2c 22 20 3d 20 22 |ew,%Pare|nt," = "|
|00001290| 2c 22 20 61 6e 64 22 29 | 20 2a 2f 0d 0a 20 20 20 |," and")| */.. |
|000012a0| 20 20 20 20 20 25 4a 6f | 69 6e 46 4b 50 4b 28 3a | %Jo|inFKPK(:|
|000012b0| 6e 65 77 2c 25 50 61 72 | 65 6e 74 2c 22 20 3d 20 |new,%Par|ent," = |
|000012c0| 22 2c 22 20 61 6e 64 22 | 29 3b 0d 0a 20 20 20 20 |"," and"|);.. |
|000012d0| 69 66 20 28 0d 0a 20 20 | 20 20 20 20 2f 2a 20 25 |if (.. | /* %|
|000012e0| 25 4e 6f 74 6e 75 6c 6c | 46 4b 28 3a 6e 65 77 2c |%Notnull|FK(:new,|
|000012f0| 22 20 69 73 20 6e 6f 74 | 20 6e 75 6c 6c 20 61 6e |" is not| null an|
|00001300| 64 22 29 20 2a 2f 0d 0a | 20 20 20 20 20 20 25 4e |d") */..| %N|
|00001310| 6f 74 6e 75 6c 6c 46 4b | 28 3a 6e 65 77 2c 22 20 |otnullFK|(:new," |
|00001320| 69 73 20 6e 6f 74 20 6e | 75 6c 6c 20 61 6e 64 22 |is not n|ull and"|
|00001330| 29 0d 0a 20 20 20 20 20 | 20 6e 75 6d 72 6f 77 73 |).. | numrows|
|00001340| 20 3d 20 30 0d 0a 20 20 | 20 20 29 0d 0a 20 20 20 | = 0.. | ).. |
|00001350| 20 74 68 65 6e 0d 0a 20 | 20 20 20 20 20 72 61 69 | then.. | rai|
|00001360| 73 65 5f 61 70 70 6c 69 | 63 61 74 69 6f 6e 5f 65 |se_appli|cation_e|
|00001370| 72 72 6f 72 28 0d 0a 20 | 20 20 20 20 20 20 20 2d |rror(.. | -|
|00001380| 32 30 30 30 37 2c 0d 0a | 20 20 20 20 20 20 20 20 |20007,..| |
|00001390| 27 43 61 6e 6e 6f 74 20 | 55 50 44 41 54 45 20 22 |'Cannot |UPDATE "|
|000013a0| 25 43 68 69 6c 64 22 20 | 62 65 63 61 75 73 65 20 |%Child" |because |
|000013b0| 22 25 50 61 72 65 6e 74 | 22 20 64 6f 65 73 20 6e |"%Parent|" does n|
|000013c0| 6f 74 20 65 78 69 73 74 | 2e 27 0d 0a 20 20 20 20 |ot exist|.'.. |
|000013d0| 20 20 29 3b 0d 0a 20 20 | 20 20 65 6e 64 20 69 66 | );.. | end if|
|000013e0| 3b 0d 0a 1c 27 03 00 14 | 00 43 48 49 4c 44 20 55 |;...'...|.CHILD U|
|000013f0| 50 44 41 54 45 20 43 41 | 53 43 41 44 45 ff 01 20 |PDATE CA|SCADE.. |
|00001400| 20 2f 2a 20 45 52 77 69 | 6e 20 42 75 69 6c 74 69 | /* ERwi|n Builti|
|00001410| 6e 20 25 44 61 74 65 74 | 69 6d 65 20 2a 2f 0d 0a |n %Datet|ime */..|
|00001420| 20 20 2f 2a 20 25 50 61 | 72 65 6e 74 20 25 56 65 | /* %Pa|rent %Ve|
|00001430| 72 62 50 68 72 61 73 65 | 20 25 43 68 69 6c 64 20 |rbPhrase| %Child |
|00001440| 4f 4e 20 43 48 49 4c 44 | 20 55 50 44 41 54 45 20 |ON CHILD| UPDATE |
|00001450| 43 41 53 43 41 44 45 20 | 2a 2f 0d 0a 20 20 20 20 |CASCADE |*/.. |
|00001460| 69 6e 73 65 72 74 20 69 | 6e 74 6f 20 25 50 61 72 |insert i|nto %Par|
|00001470| 65 6e 74 20 28 25 50 61 | 72 65 6e 74 50 4b 28 22 |ent (%Pa|rentPK("|
|00001480| 2c 22 2c 29 29 0d 0a 20 | 20 20 20 20 20 73 65 6c |,",)).. | sel|
|00001490| 65 63 74 20 25 43 68 69 | 6c 64 46 4b 28 22 2c 22 |ect %Chi|ldFK(","|
|000014a0| 2c 29 0d 0a 20 20 20 20 | 20 20 20 20 66 72 6f 6d |,).. | from|
|000014b0| 20 25 43 68 69 6c 64 0d | 0a 20 20 20 20 20 20 20 | %Child.|. |
|000014c0| 20 77 68 65 72 65 0d 0a | 20 20 20 20 20 20 20 20 | where..| |
|000014d0| 20 20 2f 2a 20 25 25 4e | 6f 74 6e 75 6c 6c 46 4b | /* %%N|otnullFK|
|000014e0| 28 3a 6e 65 77 2c 22 20 | 69 73 20 6e 6f 74 20 6e |(:new," |is not n|
|000014f0| 75 6c 6c 20 61 6e 64 22 | 29 20 2a 2f 0d 0a 20 20 |ull and"|) */.. |
|00001500| 20 20 20 20 20 20 20 20 | 25 4e 6f 74 6e 75 6c 6c | |%Notnull|
|00001510| 46 4b 28 3a 6e 65 77 2c | 22 20 69 73 20 6e 6f 74 |FK(:new,|" is not|
|00001520| 20 6e 75 6c 6c 20 61 6e | 64 22 29 0d 0a 20 20 20 | null an|d").. |
|00001530| 20 20 20 20 20 20 20 6e | 6f 74 20 65 78 69 73 74 | n|ot exist|
|00001540| 73 20 28 0d 0a 20 20 20 | 20 20 20 20 20 20 20 20 |s (.. | |
|00001550| 20 73 65 6c 65 63 74 20 | 2a 20 66 72 6f 6d 20 25 | select |* from %|
|00001560| 50 61 72 65 6e 74 0d 0a | 20 20 20 20 20 20 20 20 |Parent..| |
|00001570| 20 20 20 20 20 20 77 68 | 65 72 65 0d 0a 20 20 20 | wh|ere.. |
|00001580| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 2f 2a 20 | | /* |
|00001590| 25 25 4a 6f 69 6e 46 4b | 50 4b 28 3a 6e 65 77 2c |%%JoinFK|PK(:new,|
|000015a0| 25 50 61 72 65 6e 74 2c | 22 20 3d 20 22 2c 22 20 |%Parent,|" = "," |
|000015b0| 61 6e 64 22 29 20 2a 2f | 0d 0a 20 20 20 20 20 20 |and") */|.. |
|000015c0| 20 20 20 20 20 20 20 20 | 20 20 25 4a 6f 69 6e 46 | | %JoinF|
|000015d0| 4b 50 4b 28 3a 6e 65 77 | 2c 25 50 61 72 65 6e 74 |KPK(:new|,%Parent|
|000015e0| 2c 22 20 3d 20 22 2c 22 | 20 61 6e 64 22 29 0d 0a |," = ","| and")..|
|000015f0| 20 20 20 20 20 20 20 20 | 20 20 29 3b 0d 0a 1d 27 | | );...'|
|00001600| 03 00 14 00 43 48 49 4c | 44 20 55 50 44 41 54 45 |....CHIL|D UPDATE|
|00001610| 20 53 45 54 4e 55 4c 4c | f8 01 20 20 20 20 2f 2a | SETNULL|.. /*|
|00001620| 20 45 52 77 69 6e 20 42 | 75 69 6c 74 69 6e 20 25 | ERwin B|uiltin %|
|00001630| 44 61 74 65 74 69 6d 65 | 20 2a 2f 0d 0a 20 20 20 |Datetime| */.. |
|00001640| 20 2f 2a 20 25 50 61 72 | 65 6e 74 20 25 56 65 72 | /* %Par|ent %Ver|
|00001650| 62 50 68 72 61 73 65 20 | 25 43 68 69 6c 64 20 4f |bPhrase |%Child O|
|00001660| 4e 20 43 48 49 4c 44 20 | 55 50 44 41 54 45 20 53 |N CHILD |UPDATE S|
|00001670| 45 54 20 4e 55 4c 4c 20 | 2a 2f 0d 0a 20 20 20 20 |ET NULL |*/.. |
|00001680| 75 70 64 61 74 65 20 25 | 43 68 69 6c 64 0d 0a 20 |update %|Child.. |
|00001690| 20 20 20 20 20 73 65 74 | 0d 0a 20 20 20 20 20 20 | set|.. |
|000016a0| 20 20 2f 2a 20 25 25 53 | 65 74 46 4b 28 25 43 68 | /* %%S|etFK(%Ch|
|000016b0| 69 6c 64 2c 4e 55 4c 4c | 29 20 2a 2f 0d 0a 20 20 |ild,NULL|) */.. |
|000016c0| 20 20 20 20 20 20 25 53 | 65 74 46 4b 28 25 43 68 | %S|etFK(%Ch|
|000016d0| 69 6c 64 2c 4e 55 4c 4c | 29 0d 0a 20 20 20 20 20 |ild,NULL|).. |
|000016e0| 20 77 68 65 72 65 0d 0a | 20 20 20 20 20 20 20 20 | where..| |
|000016f0| 6e 6f 74 20 65 78 69 73 | 74 73 20 28 0d 0a 20 20 |not exis|ts (.. |
|00001700| 20 20 20 20 20 20 20 20 | 73 65 6c 65 63 74 20 2a | |select *|
|00001710| 20 66 72 6f 6d 20 25 50 | 61 72 65 6e 74 0d 0a 20 | from %P|arent.. |
|00001720| 20 20 20 20 20 20 20 20 | 20 20 20 77 68 65 72 65 | | where|
|00001730| 0d 0a 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |.. | |
|00001740| 2f 2a 20 25 25 4a 6f 69 | 6e 46 4b 50 4b 28 3a 6e |/* %%Joi|nFKPK(:n|
|00001750| 65 77 2c 25 50 61 72 65 | 6e 74 2c 22 20 3d 20 22 |ew,%Pare|nt," = "|
|00001760| 2c 22 20 61 6e 64 22 29 | 20 2a 2f 0d 0a 20 20 20 |," and")| */.. |
|00001770| 20 20 20 20 20 20 20 20 | 20 20 20 25 4a 6f 69 6e | | %Join|
|00001780| 46 4b 50 4b 28 3a 6e 65 | 77 2c 25 50 61 72 65 6e |FKPK(:ne|w,%Paren|
|00001790| 74 2c 22 20 3d 20 22 2c | 22 20 61 6e 64 22 29 0d |t," = ",|" and").|
|000017a0| 0a 20 20 20 20 20 20 20 | 20 29 20 61 6e 64 0d 0a |. | ) and..|
|000017b0| 20 20 20 20 20 20 20 20 | 2f 2a 20 25 25 4a 6f 69 | |/* %%Joi|
|000017c0| 6e 50 4b 50 4b 28 25 43 | 68 69 6c 64 2c 3a 6e 65 |nPKPK(%C|hild,:ne|
|000017d0| 77 2c 22 20 3d 20 22 2c | 22 20 61 6e 64 22 29 20 |w," = ",|" and") |
|000017e0| 2a 2f 0d 0a 20 20 20 20 | 20 20 20 20 25 4a 6f 69 |*/.. | %Joi|
|000017f0| 6e 50 4b 50 4b 28 25 43 | 68 69 6c 64 2c 3a 6e 65 |nPKPK(%C|hild,:ne|
|00001800| 77 2c 22 20 3d 20 22 2c | 22 20 61 6e 64 22 29 3b |w," = ",|" and");|
|00001810| 0d 0a 1e 27 03 00 15 00 | 43 48 49 4c 44 20 44 45 |...'....|CHILD DE|
|00001820| 4c 45 54 45 20 52 45 53 | 54 52 49 43 54 a6 01 20 |LETE RES|TRICT.. |
|00001830| 20 20 20 2f 2a 20 45 52 | 77 69 6e 20 42 75 69 6c | /* ER|win Buil|
|00001840| 74 69 6e 20 25 44 61 74 | 65 74 69 6d 65 20 2a 2f |tin %Dat|etime */|
|00001850| 0d 0a 20 20 20 20 2f 2a | 20 25 50 61 72 65 6e 74 |.. /*| %Parent|
|00001860| 20 25 56 65 72 62 50 68 | 72 61 73 65 20 25 43 68 | %VerbPh|rase %Ch|
|00001870| 69 6c 64 20 4f 4e 20 43 | 48 49 4c 44 20 44 45 4c |ild ON C|HILD DEL|
|00001880| 45 54 45 20 52 45 53 54 | 52 49 43 54 20 2a 2f 0d |ETE REST|RICT */.|
|00001890| 0a 20 20 20 20 73 65 6c | 65 63 74 20 63 6f 75 6e |. sel|ect coun|
|000018a0| 74 28 2a 29 20 69 6e 74 | 6f 20 6e 75 6d 72 6f 77 |t(*) int|o numrow|
|000018b0| 73 20 66 72 6f 6d 20 25 | 50 61 72 65 6e 74 0d 0a |s from %|Parent..|
|000018c0| 20 20 20 20 20 20 77 68 | 65 72 65 0d 0a 20 20 20 | wh|ere.. |
|000018d0| 20 20 20 20 20 2f 2a 20 | 25 25 4a 6f 69 6e 46 4b | /* |%%JoinFK|
|000018e0| 50 4b 28 3a 6f 6c 64 2c | 25 50 61 72 65 6e 74 2c |PK(:old,|%Parent,|
|000018f0| 22 20 3d 20 22 2c 22 20 | 61 6e 64 22 29 20 2a 2f |" = "," |and") */|
|00001900| 0d 0a 20 20 20 20 20 20 | 20 20 25 4a 6f 69 6e 46 |.. | %JoinF|
|00001910| 4b 50 4b 28 3a 6f 6c 64 | 2c 25 50 61 72 65 6e 74 |KPK(:old|,%Parent|
|00001920| 2c 22 20 3d 20 22 2c 22 | 20 61 6e 64 22 29 3b 0d |," = ","| and");.|
|00001930| 0a 20 20 20 20 69 66 20 | 28 6e 75 6d 72 6f 77 73 |. if |(numrows|
|00001940| 20 3e 20 30 29 0d 0a 20 | 20 20 20 74 68 65 6e 0d | > 0).. | then.|
|00001950| 0a 20 20 20 20 20 20 72 | 61 69 73 65 5f 61 70 70 |. r|aise_app|
|00001960| 6c 69 63 61 74 69 6f 6e | 5f 65 72 72 6f 72 28 0d |lication|_error(.|
|00001970| 0a 20 20 20 20 20 20 20 | 20 2d 32 30 30 31 30 2c |. | -20010,|
|00001980| 0d 0a 20 20 20 20 20 20 | 20 20 27 43 61 6e 6e 6f |.. | 'Canno|
|00001990| 74 20 44 45 4c 45 54 45 | 20 22 25 43 68 69 6c 64 |t DELETE| "%Child|
|000019a0| 22 20 62 65 63 61 75 73 | 65 20 22 25 50 61 72 65 |" becaus|e "%Pare|
|000019b0| 6e 74 22 20 65 78 69 73 | 74 73 2e 27 0d 0a 20 20 |nt" exis|ts.'.. |
|000019c0| 20 20 20 20 29 3b 0d 0a | 20 20 20 20 65 6e 64 20 | );..| end |
|000019d0| 69 66 3b 0d 0a 20 27 03 | 00 14 00 43 48 49 4c 44 |if;.. '.|...CHILD|
|000019e0| 20 44 45 4c 45 54 45 20 | 43 41 53 43 41 44 45 eb | DELETE |CASCADE.|
|000019f0| 00 20 20 20 20 2f 2a 20 | 45 52 77 69 6e 20 42 75 |. /* |ERwin Bu|
|00001a00| 69 6c 74 69 6e 20 25 44 | 61 74 65 74 69 6d 65 20 |iltin %D|atetime |
|00001a10| 2a 2f 0d 0a 20 20 20 20 | 2f 2a 20 25 50 61 72 65 |*/.. |/* %Pare|
|00001a20| 6e 74 20 25 56 65 72 62 | 50 68 72 61 73 65 20 25 |nt %Verb|Phrase %|
|00001a30| 43 68 69 6c 64 20 4f 4e | 20 43 48 49 4c 44 20 44 |Child ON| CHILD D|
|00001a40| 45 4c 45 54 45 20 43 41 | 53 43 41 44 45 20 2a 2f |ELETE CA|SCADE */|
|00001a50| 0d 0a 20 20 20 20 64 65 | 6c 65 74 65 20 66 72 6f |.. de|lete fro|
|00001a60| 6d 20 25 50 61 72 65 6e | 74 0d 0a 20 20 20 20 20 |m %Paren|t.. |
|00001a70| 20 77 68 65 72 65 0d 0a | 20 20 20 20 20 20 20 20 | where..| |
|00001a80| 2f 2a 20 25 25 4a 6f 69 | 6e 46 4b 50 4b 28 3a 6f |/* %%Joi|nFKPK(:o|
|00001a90| 6c 64 2c 25 50 61 72 65 | 6e 74 2c 22 20 3d 20 22 |ld,%Pare|nt," = "|
|00001aa0| 2c 22 20 61 6e 64 22 29 | 20 2a 2f 0d 0a 20 20 20 |," and")| */.. |
|00001ab0| 20 20 20 20 20 25 4a 6f | 69 6e 46 4b 50 4b 28 3a | %Jo|inFKPK(:|
|00001ac0| 6f 6c 64 2c 25 50 61 72 | 65 6e 74 2c 22 20 3d 20 |old,%Par|ent," = |
|00001ad0| 22 2c 22 20 61 6e 64 22 | 29 3b 0d 0a 21 27 03 00 |"," and"|);..!'..|
|00001ae0| 16 00 50 41 52 45 4e 54 | 20 49 4e 53 45 52 54 20 |..PARENT| INSERT |
|00001af0| 52 45 53 54 52 49 43 54 | a6 01 20 20 20 20 2f 2a |RESTRICT|.. /*|
|00001b00| 20 45 52 77 69 6e 20 42 | 75 69 6c 74 69 6e 20 25 | ERwin B|uiltin %|
|00001b10| 44 61 74 65 74 69 6d 65 | 20 2a 2f 0d 0a 20 20 20 |Datetime| */.. |
|00001b20| 20 2f 2a 20 25 50 61 72 | 65 6e 74 20 25 56 65 72 | /* %Par|ent %Ver|
|00001b30| 62 50 68 72 61 73 65 20 | 25 43 68 69 6c 64 20 4f |bPhrase |%Child O|
|00001b40| 4e 20 50 41 52 45 4e 54 | 20 49 4e 53 45 52 54 20 |N PARENT| INSERT |
|00001b50| 52 45 53 54 52 49 43 54 | 20 2a 2f 0d 0a 20 20 20 |RESTRICT| */.. |
|00001b60| 20 73 65 6c 65 63 74 20 | 63 6f 75 6e 74 28 2a 29 | select |count(*)|
|00001b70| 20 69 6e 74 6f 20 6e 75 | 6d 72 6f 77 73 20 66 72 | into nu|mrows fr|
|00001b80| 6f 6d 20 25 43 68 69 6c | 64 0d 0a 20 20 20 20 20 |om %Chil|d.. |
|00001b90| 20 77 68 65 72 65 0d 0a | 20 20 20 20 20 20 20 20 | where..| |
|00001ba0| 2f 2a 20 25 25 4a 6f 69 | 6e 46 4b 50 4b 28 25 43 |/* %%Joi|nFKPK(%C|
|00001bb0| 68 69 6c 64 2c 3a 6e 65 | 77 2c 22 20 3d 20 22 2c |hild,:ne|w," = ",|
|00001bc0| 22 20 61 6e 64 22 29 20 | 2a 2f 0d 0a 20 20 20 20 |" and") |*/.. |
|00001bd0| 20 20 20 20 25 4a 6f 69 | 6e 46 4b 50 4b 28 25 43 | %Joi|nFKPK(%C|
|00001be0| 68 69 6c 64 2c 3a 6e 65 | 77 2c 22 20 3d 20 22 2c |hild,:ne|w," = ",|
|00001bf0| 22 20 61 6e 64 22 29 3b | 0d 0a 20 20 20 20 69 66 |" and");|.. if|
|00001c00| 20 28 6e 75 6d 72 6f 77 | 73 20 3d 20 30 29 0d 0a | (numrow|s = 0)..|
|00001c10| 20 20 20 20 74 68 65 6e | 0d 0a 20 20 20 20 20 20 | then|.. |
|00001c20| 72 61 69 73 65 5f 61 70 | 70 6c 69 63 61 74 69 6f |raise_ap|plicatio|
|00001c30| 6e 5f 65 72 72 6f 72 28 | 0d 0a 20 20 20 20 20 20 |n_error(|.. |
|00001c40| 20 20 2d 32 30 30 31 31 | 2c 0d 0a 20 20 20 20 20 | -20011|,.. |
|00001c50| 20 20 20 27 43 61 6e 6e | 6f 74 20 49 4e 53 45 52 | 'Cann|ot INSER|
|00001c60| 54 20 22 25 50 61 72 65 | 6e 74 22 20 62 65 63 61 |T "%Pare|nt" beca|
|00001c70| 75 73 65 20 22 25 43 68 | 69 6c 64 22 20 64 6f 65 |use "%Ch|ild" doe|
|00001c80| 73 20 6e 6f 74 2e 27 0d | 0a 20 20 20 20 20 20 29 |s not.'.|. )|
|00001c90| 3b 0d 0a 20 20 20 20 65 | 6e 64 20 69 66 3b 0d 0a |;.. e|nd if;..|
|00001ca0| 24 27 03 00 0d 00 55 50 | 44 41 54 45 20 48 45 41 |$'....UP|DATE HEA|
|00001cb0| 44 45 52 ae 00 63 72 65 | 61 74 65 20 74 72 69 67 |DER..cre|ate trig|
|00001cc0| 67 65 72 20 74 25 31 41 | 63 74 69 6f 6e 5f 25 32 |ger t%1A|ction_%2|
|00001cd0| 37 54 61 62 6c 65 4e 61 | 6d 65 20 61 66 74 65 72 |7TableNa|me after|
|00001ce0| 20 25 41 63 74 69 6f 6e | 20 6f 6e 20 25 54 61 62 | %Action| on %Tab|
|00001cf0| 6c 65 4e 61 6d 65 20 66 | 6f 72 20 65 61 63 68 20 |leName f|or each |
|00001d00| 72 6f 77 0d 0a 2d 2d 20 | 45 52 77 69 6e 20 42 75 |row..-- |ERwin Bu|
|00001d10| 69 6c 74 69 6e 20 25 44 | 61 74 65 74 69 6d 65 0d |iltin %D|atetime.|
|00001d20| 0a 2d 2d 20 25 41 63 74 | 69 6f 6e 20 74 72 69 67 |.-- %Act|ion trig|
|00001d30| 67 65 72 20 6f 6e 20 25 | 54 61 62 6c 65 4e 61 6d |ger on %|TableNam|
|00001d40| 65 20 0d 0a 64 65 63 6c | 61 72 65 20 6e 75 6d 72 |e ..decl|are numr|
|00001d50| 6f 77 73 20 49 4e 54 45 | 47 45 52 3b 0d 0a 62 65 |ows INTE|GER;..be|
|00001d60| 67 69 6e 28 27 03 00 0d | 00 55 50 44 41 54 45 20 |gin('...|.UPDATE |
|00001d70| 46 4f 4f 54 45 52 25 00 | 2d 2d 20 45 52 77 69 6e |FOOTER%.|-- ERwin|
|00001d80| 20 42 75 69 6c 74 69 6e | 20 25 44 61 74 65 74 69 | Builtin| %Dateti|
|00001d90| 6d 65 0d 0a 65 6e 64 3b | 0d 0a 2f 0d 0a 29 27 03 |me..end;|../..)'.|
|00001da0| 00 0d 00 44 45 4c 45 54 | 45 20 48 45 41 44 45 52 |...DELET|E HEADER|
|00001db0| ae 00 63 72 65 61 74 65 | 20 74 72 69 67 67 65 72 |..create| trigger|
|00001dc0| 20 74 25 31 41 63 74 69 | 6f 6e 5f 25 32 37 54 61 | t%1Acti|on_%27Ta|
|00001dd0| 62 6c 65 4e 61 6d 65 20 | 61 66 74 65 72 20 25 41 |bleName |after %A|
|00001de0| 63 74 69 6f 6e 20 6f 6e | 20 25 54 61 62 6c 65 4e |ction on| %TableN|
|00001df0| 61 6d 65 20 66 6f 72 20 | 65 61 63 68 20 72 6f 77 |ame for |each row|
|00001e00| 0d 0a 2d 2d 20 45 52 77 | 69 6e 20 42 75 69 6c 74 |..-- ERw|in Built|
|00001e10| 69 6e 20 25 44 61 74 65 | 74 69 6d 65 0d 0a 2d 2d |in %Date|time..--|
|00001e20| 20 25 41 63 74 69 6f 6e | 20 74 72 69 67 67 65 72 | %Action| trigger|
|00001e30| 20 6f 6e 20 25 54 61 62 | 6c 65 4e 61 6d 65 20 0d | on %Tab|leName .|
|00001e40| 0a 64 65 63 6c 61 72 65 | 20 6e 75 6d 72 6f 77 73 |.declare| numrows|
|00001e50| 20 49 4e 54 45 47 45 52 | 3b 0d 0a 62 65 67 69 6e | INTEGER|;..begin|
|00001e60| 2a 27 03 00 0d 00 44 45 | 4c 45 54 45 20 46 4f 4f |*'....DE|LETE FOO|
|00001e70| 54 45 52 25 00 2d 2d 20 | 45 52 77 69 6e 20 42 75 |TER%.-- |ERwin Bu|
|00001e80| 69 6c 74 69 6e 20 25 44 | 61 74 65 74 69 6d 65 0d |iltin %D|atetime.|
|00001e90| 0a 65 6e 64 3b 0d 0a 2f | 0d 0a 2b 27 03 00 0d 00 |.end;../|..+'....|
|00001ea0| 49 4e 53 45 52 54 20 48 | 45 41 44 45 52 ae 00 63 |INSERT H|EADER..c|
|00001eb0| 72 65 61 74 65 20 74 72 | 69 67 67 65 72 20 74 25 |reate tr|igger t%|
|00001ec0| 31 41 63 74 69 6f 6e 5f | 25 32 37 54 61 62 6c 65 |1Action_|%27Table|
|00001ed0| 4e 61 6d 65 20 61 66 74 | 65 72 20 25 41 63 74 69 |Name aft|er %Acti|
|00001ee0| 6f 6e 20 6f 6e 20 25 54 | 61 62 6c 65 4e 61 6d 65 |on on %T|ableName|
|00001ef0| 20 66 6f 72 20 65 61 63 | 68 20 72 6f 77 0d 0a 2d | for eac|h row..-|
|00001f00| 2d 20 45 52 77 69 6e 20 | 42 75 69 6c 74 69 6e 20 |- ERwin |Builtin |
|00001f10| 25 44 61 74 65 74 69 6d | 65 0d 0a 2d 2d 20 25 41 |%Datetim|e..-- %A|
|00001f20| 63 74 69 6f 6e 20 74 72 | 69 67 67 65 72 20 6f 6e |ction tr|igger on|
|00001f30| 20 25 54 61 62 6c 65 4e | 61 6d 65 20 0d 0a 64 65 | %TableN|ame ..de|
|00001f40| 63 6c 61 72 65 20 6e 75 | 6d 72 6f 77 73 20 49 4e |clare nu|mrows IN|
|00001f50| 54 45 47 45 52 3b 0d 0a | 62 65 67 69 6e 2c 27 03 |TEGER;..|begin,'.|
|00001f60| 00 0d 00 49 4e 53 45 52 | 54 20 46 4f 4f 54 45 52 |...INSER|T FOOTER|
|00001f70| 25 00 2d 2d 20 45 52 77 | 69 6e 20 42 75 69 6c 74 |%.-- ERw|in Built|
|00001f80| 69 6e 20 25 44 61 74 65 | 74 69 6d 65 0d 0a 65 6e |in %Date|time..en|
|00001f90| 64 3b 0d 0a 2f 0d 0a 2d | 27 03 00 15 00 43 55 53 |d;../..-|'....CUS|
|00001fa0| 54 4f 4d 20 54 52 49 47 | 47 45 52 20 48 45 41 44 |TOM TRIG|GER HEAD|
|00001fb0| 45 52 60 00 63 72 65 61 | 74 65 20 74 72 69 67 67 |ER`.crea|te trigg|
|00001fc0| 65 72 20 25 54 72 69 67 | 67 65 72 4e 61 6d 65 0d |er %Trig|gerName.|
|00001fd0| 0a 20 20 25 46 69 72 65 | 20 25 41 63 74 69 6f 6e |. %Fire| %Action|
|00001fe0| 73 28 22 20 6f 72 20 22 | 29 0d 0a 20 20 6f 6e 20 |s(" or "|).. on |
|00001ff0| 25 54 61 62 6c 65 4e 61 | 6d 65 0d 0a 20 20 25 52 |%TableNa|me.. %R|
|00002000| 65 66 43 6c 61 75 73 65 | 0d 0a 20 20 25 53 63 6f |efClause|.. %Sco|
|00002010| 70 65 0d 0a 2e 27 03 00 | 15 00 43 55 53 54 4f 4d |pe...'..|..CUSTOM|
|00002020| 20 54 52 49 47 47 45 52 | 20 46 4f 4f 54 45 52 00 | TRIGGER| FOOTER.|
|00002030| 00 00 00 03 00 1b 00 43 | 55 53 54 4f 4d 20 54 52 |.......C|USTOM TR|
|00002040| 49 47 47 45 52 20 44 45 | 46 41 55 4c 54 20 42 4f |IGGER DE|FAULT BO|
|00002050| 44 59 21 01 63 72 65 61 | 74 65 20 74 72 69 67 67 |DY!.crea|te trigg|
|00002060| 65 72 20 25 54 72 69 67 | 67 65 72 4e 61 6d 65 0d |er %Trig|gerName.|
|00002070| 0a 20 20 25 46 69 72 65 | 20 25 41 63 74 69 6f 6e |. %Fire| %Action|
|00002080| 73 28 22 20 6f 72 20 22 | 29 0d 0a 20 20 6f 6e 20 |s(" or "|).. on |
|00002090| 25 54 61 62 6c 65 4e 61 | 6d 65 0d 0a 20 20 25 52 |%TableNa|me.. %R|
|000020a0| 65 66 43 6c 61 75 73 65 | 0d 0a 20 20 25 53 63 6f |efClause|.. %Sco|
|000020b0| 70 65 0d 0a 2f 2a 20 45 | 52 77 69 6e 20 42 75 69 |pe../* E|Rwin Bui|
|000020c0| 6c 74 69 6e 20 25 44 61 | 74 65 74 69 6d 65 20 2a |ltin %Da|tetime *|
|000020d0| 2f 0d 0a 2f 2a 20 64 65 | 66 61 75 6c 74 20 62 6f |/../* de|fault bo|
|000020e0| 64 79 20 66 6f 72 20 25 | 54 72 69 67 67 65 72 4e |dy for %|TriggerN|
|000020f0| 61 6d 65 20 2a 2f 0d 0a | 64 65 63 6c 61 72 65 20 |ame */..|declare |
|00002100| 6e 75 6d 72 6f 77 73 20 | 49 4e 54 45 47 45 52 3b |numrows |INTEGER;|
|00002110| 0d 0a 62 65 67 69 6e 0d | 0a 25 46 6f 72 45 61 63 |..begin.|.%ForEac|
|00002120| 68 43 68 69 6c 64 52 65 | 6c 28 29 20 7b 0d 0a 20 |hChildRe|l() {.. |
|00002130| 20 25 52 65 6c 54 65 6d | 70 6c 61 74 65 0d 0a 7d | %RelTem|plate..}|
|00002140| 0d 0a 25 46 6f 72 45 61 | 63 68 50 61 72 65 6e 74 |..%ForEa|chParent|
|00002150| 52 65 6c 28 29 20 7b 0d | 0a 20 20 25 52 65 6c 54 |Rel() {.|. %RelT|
|00002160| 65 6d 70 6c 61 74 65 0d | 0a 7d 0d 0a 65 6e 64 3b |emplate.|.}..end;|
|00002170| 0d 0a 2f 0d 0a 30 27 03 | 00 19 00 50 41 52 45 4e |../..0'.|...PAREN|
|00002180| 54 20 55 50 44 41 54 45 | 20 53 45 54 20 44 45 46 |T UPDATE| SET DEF|
|00002190| 41 55 4c 54 92 00 2f 2a | 20 45 52 77 69 6e 20 42 |AULT../*| ERwin B|
|000021a0| 75 69 6c 74 69 6e 20 25 | 44 61 74 65 74 69 6d 65 |uiltin %|Datetime|
|000021b0| 20 2a 2f 0d 0a 2f 2a 20 | 25 50 61 72 65 6e 74 20 | */../* |%Parent |
|000021c0| 25 56 65 72 62 50 68 72 | 61 73 65 20 25 43 68 69 |%VerbPhr|ase %Chi|
|000021d0| 6c 64 20 4f 4e 20 50 41 | 52 45 4e 54 20 55 50 44 |ld ON PA|RENT UPD|
|000021e0| 41 54 45 20 53 45 54 20 | 44 45 46 41 55 4c 54 20 |ATE SET |DEFAULT |
|000021f0| 2a 2f 0d 0a 2f 2a 20 41 | 70 70 6c 69 63 61 74 69 |*/../* A|pplicati|
|00002200| 6f 6e 20 73 70 65 63 69 | 66 69 63 2e 20 20 4c 65 |on speci|fic. Le|
|00002210| 66 74 20 6f 75 74 20 69 | 6e 74 65 6e 74 69 6f 6e |ft out i|ntention|
|00002220| 61 6c 6c 79 2e 20 2a 2f | 13 27 03 00 19 00 50 41 |ally. */|.'....PA|
|00002230| 52 45 4e 54 20 44 45 4c | 45 54 45 20 53 45 54 20 |RENT DEL|ETE SET |
|00002240| 44 45 46 41 55 4c 54 92 | 00 2f 2a 20 45 52 77 69 |DEFAULT.|./* ERwi|
|00002250| 6e 20 42 75 69 6c 74 69 | 6e 20 25 44 61 74 65 74 |n Builti|n %Datet|
|00002260| 69 6d 65 20 2a 2f 0d 0a | 2f 2a 20 25 50 61 72 65 |ime */..|/* %Pare|
|00002270| 6e 74 20 25 56 65 72 62 | 50 68 72 61 73 65 20 25 |nt %Verb|Phrase %|
|00002280| 43 68 69 6c 64 20 4f 4e | 20 50 41 52 45 4e 54 20 |Child ON| PARENT |
|00002290| 44 45 4c 45 54 45 20 53 | 45 54 20 44 45 46 41 55 |DELETE S|ET DEFAU|
|000022a0| 4c 54 20 2a 2f 0d 0a 2f | 2a 20 41 70 70 6c 69 63 |LT */../|* Applic|
|000022b0| 61 74 69 6f 6e 20 73 70 | 65 63 69 66 69 63 2e 20 |ation sp|ecific. |
|000022c0| 20 4c 65 66 74 20 6f 75 | 74 20 69 6e 74 65 6e 74 | Left ou|t intent|
|000022d0| 69 6f 6e 61 6c 6c 79 2e | 20 2a 2f 17 27 03 00 19 |ionally.| */.'...|
|000022e0| 00 50 41 52 45 4e 54 20 | 49 4e 53 45 52 54 20 53 |.PARENT |INSERT S|
|000022f0| 45 54 20 44 45 46 41 55 | 4c 54 92 00 2f 2a 20 45 |ET DEFAU|LT../* E|
|00002300| 52 77 69 6e 20 42 75 69 | 6c 74 69 6e 20 25 44 61 |Rwin Bui|ltin %Da|
|00002310| 74 65 74 69 6d 65 20 2a | 2f 0d 0a 2f 2a 20 25 50 |tetime *|/../* %P|
|00002320| 61 72 65 6e 74 20 25 56 | 65 72 62 50 68 72 61 73 |arent %V|erbPhras|
|00002330| 65 20 25 43 68 69 6c 64 | 20 4f 4e 20 50 41 52 45 |e %Child| ON PARE|
|00002340| 4e 54 20 49 4e 53 45 52 | 54 20 53 45 54 20 44 45 |NT INSER|T SET DE|
|00002350| 46 41 55 4c 54 20 2a 2f | 0d 0a 2f 2a 20 41 70 70 |FAULT */|../* App|
|00002360| 6c 69 63 61 74 69 6f 6e | 20 73 70 65 63 69 66 69 |lication| specifi|
|00002370| 63 2e 20 20 4c 65 66 74 | 20 6f 75 74 20 69 6e 74 |c. Left| out int|
|00002380| 65 6e 74 69 6f 6e 61 6c | 6c 79 2e 20 2a 2f 27 27 |entional|ly. */''|
|00002390| 03 00 18 00 43 48 49 4c | 44 20 49 4e 53 45 52 54 |....CHIL|D INSERT|
|000023a0| 20 53 45 54 20 44 45 46 | 41 55 4c 54 91 00 2f 2a | SET DEF|AULT../*|
|000023b0| 20 45 52 77 69 6e 20 42 | 75 69 6c 74 69 6e 20 25 | ERwin B|uiltin %|
|000023c0| 44 61 74 65 74 69 6d 65 | 20 2a 2f 0d 0a 2f 2a 20 |Datetime| */../* |
|000023d0| 25 50 61 72 65 6e 74 20 | 25 56 65 72 62 50 68 72 |%Parent |%VerbPhr|
|000023e0| 61 73 65 20 25 43 68 69 | 6c 64 20 4f 4e 20 43 48 |ase %Chi|ld ON CH|
|000023f0| 49 4c 44 20 49 4e 53 45 | 52 54 20 53 45 54 20 44 |ILD INSE|RT SET D|
|00002400| 45 46 41 55 4c 54 20 2a | 2f 0d 0a 2f 2a 20 41 70 |EFAULT *|/../* Ap|
|00002410| 70 6c 69 63 61 74 69 6f | 6e 20 73 70 65 63 69 66 |plicatio|n specif|
|00002420| 69 63 2e 20 20 4c 65 66 | 74 20 6f 75 74 20 69 6e |ic. Lef|t out in|
|00002430| 74 65 6e 74 69 6f 6e 61 | 6c 6c 79 2e 20 2a 2f 1b |tentiona|lly. */.|
|00002440| 27 03 00 18 00 43 48 49 | 4c 44 20 55 50 44 41 54 |'....CHI|LD UPDAT|
|00002450| 45 20 53 45 54 20 44 45 | 46 41 55 4c 54 91 00 2f |E SET DE|FAULT../|
|00002460| 2a 20 45 52 77 69 6e 20 | 42 75 69 6c 74 69 6e 20 |* ERwin |Builtin |
|00002470| 25 44 61 74 65 74 69 6d | 65 20 2a 2f 0d 0a 2f 2a |%Datetim|e */../*|
|00002480| 20 25 50 61 72 65 6e 74 | 20 25 56 65 72 62 50 68 | %Parent| %VerbPh|
|00002490| 72 61 73 65 20 25 43 68 | 69 6c 64 20 4f 4e 20 43 |rase %Ch|ild ON C|
|000024a0| 48 49 4c 44 20 55 50 44 | 41 54 45 20 53 45 54 20 |HILD UPD|ATE SET |
|000024b0| 44 45 46 41 55 4c 54 20 | 2a 2f 0d 0a 2f 2a 20 41 |DEFAULT |*/../* A|
|000024c0| 70 70 6c 69 63 61 74 69 | 6f 6e 20 73 70 65 63 69 |pplicati|on speci|
|000024d0| 66 69 63 2e 20 20 4c 65 | 66 74 20 6f 75 74 20 69 |fic. Le|ft out i|
|000024e0| 6e 74 65 6e 74 69 6f 6e | 61 6c 6c 79 2e 20 2a 2f |ntention|ally. */|
|000024f0| 1f 27 03 00 18 00 43 48 | 49 4c 44 20 44 45 4c 45 |.'....CH|ILD DELE|
|00002500| 54 45 20 53 45 54 20 44 | 45 46 41 55 4c 54 91 00 |TE SET D|EFAULT..|
|00002510| 2f 2a 20 45 52 77 69 6e | 20 42 75 69 6c 74 69 6e |/* ERwin| Builtin|
|00002520| 20 25 44 61 74 65 74 69 | 6d 65 20 2a 2f 0d 0a 2f | %Dateti|me */../|
|00002530| 2a 20 25 50 61 72 65 6e | 74 20 25 56 65 72 62 50 |* %Paren|t %VerbP|
|00002540| 68 72 61 73 65 20 25 43 | 68 69 6c 64 20 4f 4e 20 |hrase %C|hild ON |
|00002550| 43 48 49 4c 44 20 44 45 | 4c 45 54 45 20 53 45 54 |CHILD DE|LETE SET|
|00002560| 20 44 45 46 41 55 4c 54 | 20 2a 2f 0d 0a 2f 2a 20 | DEFAULT| */../* |
|00002570| 41 70 70 6c 69 63 61 74 | 69 6f 6e 20 73 70 65 63 |Applicat|ion spec|
|00002580| 69 66 69 63 2e 20 20 4c | 65 66 74 20 6f 75 74 20 |ific. L|eft out |
|00002590| 69 6e 74 65 6e 74 69 6f | 6e 61 6c 6c 79 2e 20 2a |intentio|nally. *|
|000025a0| 2f 23 27 03 00 15 00 43 | 48 49 4c 44 20 44 45 4c |/#'....C|HILD DEL|
|000025b0| 45 54 45 20 53 45 54 20 | 4e 55 4c 4c 8e 00 2f 2a |ETE SET |NULL../*|
|000025c0| 20 45 52 77 69 6e 20 42 | 75 69 6c 74 69 6e 20 25 | ERwin B|uiltin %|
|000025d0| 44 61 74 65 74 69 6d 65 | 20 2a 2f 0d 0a 2f 2a 20 |Datetime| */../* |
|000025e0| 25 50 61 72 65 6e 74 20 | 25 56 65 72 62 50 68 72 |%Parent |%VerbPhr|
|000025f0| 61 73 65 20 25 43 68 69 | 6c 64 20 4f 4e 20 43 48 |ase %Chi|ld ON CH|
|00002600| 49 4c 44 20 44 45 4c 45 | 54 45 20 53 45 54 20 4e |ILD DELE|TE SET N|
|00002610| 55 4c 4c 20 2a 2f 0d 0a | 2f 2a 20 41 70 70 6c 69 |ULL */..|/* Appli|
|00002620| 63 61 74 69 6f 6e 20 73 | 70 65 63 69 66 69 63 2e |cation s|pecific.|
|00002630| 20 20 4c 65 66 74 20 6f | 75 74 20 69 6e 74 65 6e | Left o|ut inten|
|00002640| 74 69 6f 6e 61 6c 6c 79 | 2e 20 2a 2f 22 27 03 00 |tionally|. */"'..|
|00002650| 16 00 50 41 52 45 4e 54 | 20 49 4e 53 45 52 54 20 |..PARENT| INSERT |
|00002660| 53 45 54 20 4e 55 4c 4c | 8f 00 2f 2a 20 45 52 77 |SET NULL|../* ERw|
|00002670| 69 6e 20 42 75 69 6c 74 | 69 6e 20 25 44 61 74 65 |in Built|in %Date|
|00002680| 74 69 6d 65 20 2a 2f 0d | 0a 2f 2a 20 25 50 61 72 |time */.|./* %Par|
|00002690| 65 6e 74 20 25 56 65 72 | 62 50 68 72 61 73 65 20 |ent %Ver|bPhrase |
|000026a0| 25 43 68 69 6c 64 20 4f | 4e 20 50 41 52 45 4e 54 |%Child O|N PARENT|
|000026b0| 20 49 4e 53 45 52 54 20 | 53 45 54 20 4e 55 4c 4c | INSERT |SET NULL|
|000026c0| 20 2a 2f 0d 0a 2f 2a 20 | 41 70 70 6c 69 63 61 74 | */../* |Applicat|
|000026d0| 69 6f 6e 20 73 70 65 63 | 69 66 69 63 2e 20 20 4c |ion spec|ific. L|
|000026e0| 65 66 74 20 6f 75 74 20 | 69 6e 74 65 6e 74 69 6f |eft out |intentio|
|000026f0| 6e 61 6c 6c 79 2e 20 2a | 2f 26 27 03 00 15 00 50 |nally. *|/&'....P|
|00002700| 41 52 45 4e 54 20 49 4e | 53 45 52 54 20 43 41 53 |ARENT IN|SERT CAS|
|00002710| 43 41 44 45 8e 00 2f 2a | 20 45 52 77 69 6e 20 42 |CADE../*| ERwin B|
|00002720| 75 69 6c 74 69 6e 20 25 | 44 61 74 65 74 69 6d 65 |uiltin %|Datetime|
|00002730| 20 2a 2f 0d 0a 2f 2a 20 | 25 50 61 72 65 6e 74 20 | */../* |%Parent |
|00002740| 25 56 65 72 62 50 68 72 | 61 73 65 20 25 43 68 69 |%VerbPhr|ase %Chi|
|00002750| 6c 64 20 4f 4e 20 50 41 | 52 45 4e 54 20 49 4e 53 |ld ON PA|RENT INS|
|00002760| 45 52 54 20 43 41 53 43 | 41 44 45 20 2a 2f 0d 0a |ERT CASC|ADE */..|
|00002770| 2f 2a 20 41 70 70 6c 69 | 63 61 74 69 6f 6e 20 73 |/* Appli|cation s|
|00002780| 70 65 63 69 66 69 63 2e | 20 20 4c 65 66 74 20 6f |pecific.| Left o|
|00002790| 75 74 20 69 6e 74 65 6e | 74 69 6f 6e 61 6c 6c 79 |ut inten|tionally|
|000027a0| 2e 20 2a 2f 25 27 02 00 | 03 00 0d 00 54 65 6d 70 |. */%'..|....Temp|
|000027b0| 6c 61 74 65 20 4e 61 6d | 65 22 00 00 00 00 02 00 |late Nam|e"......|
|000027c0| 0f 00 54 65 6d 70 6c 61 | 74 65 20 48 61 6e 64 6c |..Templa|te Handl|
|000027d0| 65 00 00 00 00 00 00 00 | 03 00 01 00 0c 00 50 75 |e.......|......Pu|
|000027e0| 72 70 6f 73 65 20 54 65 | 78 74 22 00 00 00 00 00 |rpose Te|xt".....|
|000027f0| 00 07 00 50 75 72 70 6f | 73 65 00 00 00 00 00 02 |...Purpo|se......|
|00002800| 00 0f 00 54 65 6d 70 6c | 61 74 65 20 48 61 6e 64 |...Templ|ate Hand|
|00002810| 6c 65 22 00 00 00 00 21 | 00 03 00 14 00 43 48 49 |le"....!|.....CHI|
|00002820| 4c 44 20 44 45 4c 45 54 | 45 20 43 41 53 43 41 44 |LD DELET|E CASCAD|
|00002830| 45 21 27 21 27 ff ff 03 | 00 15 00 43 48 49 4c 44 |E!'!'...|...CHILD|
|00002840| 20 44 45 4c 45 54 45 20 | 52 45 53 54 52 49 43 54 | DELETE |RESTRICT|
|00002850| 20 27 20 27 ff ff 03 00 | 18 00 43 48 49 4c 44 20 | ' '....|..CHILD |
|00002860| 44 45 4c 45 54 45 20 53 | 45 54 20 44 45 46 41 55 |DELETE S|ET DEFAU|
|00002870| 4c 54 23 27 23 27 ff ff | 03 00 15 00 43 48 49 4c |LT#'#'..|....CHIL|
|00002880| 44 20 44 45 4c 45 54 45 | 20 53 45 54 20 4e 55 4c |D DELETE| SET NUL|
|00002890| 4c 22 27 22 27 ff ff 03 | 00 14 00 43 48 49 4c 44 |L"'"'...|...CHILD|
|000028a0| 20 49 4e 53 45 52 54 20 | 43 41 53 43 41 44 45 19 | INSERT |CASCADE.|
|000028b0| 27 19 27 ff ff 03 00 15 | 00 43 48 49 4c 44 20 49 |'.'.....|.CHILD I|
|000028c0| 4e 53 45 52 54 20 52 45 | 53 54 52 49 43 54 18 27 |NSERT RE|STRICT.'|
|000028d0| 18 27 ff ff 03 00 18 00 | 43 48 49 4c 44 20 49 4e |.'......|CHILD IN|
|000028e0| 53 45 52 54 20 53 45 54 | 20 44 45 46 41 55 4c 54 |SERT SET| DEFAULT|
|000028f0| 1b 27 1b 27 ff ff 03 00 | 15 00 43 48 49 4c 44 20 |.'.'....|..CHILD |
|00002900| 49 4e 53 45 52 54 20 53 | 45 54 20 4e 55 4c 4c 1a |INSERT S|ET NULL.|
|00002910| 27 1a 27 ff ff 03 00 14 | 00 43 48 49 4c 44 20 55 |'.'.....|.CHILD U|
|00002920| 50 44 41 54 45 20 43 41 | 53 43 41 44 45 1d 27 1d |PDATE CA|SCADE.'.|
|00002930| 27 ff ff 03 00 15 00 43 | 48 49 4c 44 20 55 50 44 |'......C|HILD UPD|
|00002940| 41 54 45 20 52 45 53 54 | 52 49 43 54 1c 27 1c 27 |ATE REST|RICT.'.'|
|00002950| ff ff 03 00 18 00 43 48 | 49 4c 44 20 55 50 44 41 |......CH|ILD UPDA|
|00002960| 54 45 20 53 45 54 20 44 | 45 46 41 55 4c 54 1f 27 |TE SET D|EFAULT.'|
|00002970| 1f 27 ff ff 03 00 15 00 | 43 48 49 4c 44 20 55 50 |.'......|CHILD UP|
|00002980| 44 41 54 45 20 53 45 54 | 20 4e 55 4c 4c 1e 27 1e |DATE SET| NULL.'.|
|00002990| 27 ff ff 03 00 1b 00 43 | 55 53 54 4f 4d 20 54 52 |'......C|USTOM TR|
|000029a0| 49 47 47 45 52 20 44 45 | 46 41 55 4c 54 20 42 4f |IGGER DE|FAULT BO|
|000029b0| 44 59 30 27 30 27 ff ff | 03 00 15 00 43 55 53 54 |DY0'0'..|....CUST|
|000029c0| 4f 4d 20 54 52 49 47 47 | 45 52 20 46 4f 4f 54 45 |OM TRIGG|ER FOOTE|
|000029d0| 52 2f 27 00 00 ff ff 03 | 00 15 00 43 55 53 54 4f |R/'.....|...CUSTO|
|000029e0| 4d 20 54 52 49 47 47 45 | 52 20 48 45 41 44 45 52 |M TRIGGE|R HEADER|
|000029f0| 2e 27 2e 27 ff ff 03 00 | 15 00 50 41 52 45 4e 54 |.'.'....|..PARENT|
|00002a00| 20 44 45 4c 45 54 45 20 | 43 41 53 43 41 44 45 15 | DELETE |CASCADE.|
|00002a10| 27 15 27 ff ff 03 00 16 | 00 50 41 52 45 4e 54 20 |'.'.....|.PARENT |
|00002a20| 44 45 4c 45 54 45 20 52 | 45 53 54 52 49 43 54 14 |DELETE R|ESTRICT.|
|00002a30| 27 14 27 ff ff 03 00 19 | 00 50 41 52 45 4e 54 20 |'.'.....|.PARENT |
|00002a40| 44 45 4c 45 54 45 20 53 | 45 54 20 44 45 46 41 55 |DELETE S|ET DEFAU|
|00002a50| 4c 54 17 27 17 27 ff ff | 03 00 16 00 50 41 52 45 |LT.'.'..|....PARE|
|00002a60| 4e 54 20 44 45 4c 45 54 | 45 20 53 45 54 20 4e 55 |NT DELET|E SET NU|
|00002a70| 4c 4c 16 27 16 27 ff ff | 03 00 15 00 50 41 52 45 |LL.'.'..|....PARE|
|00002a80| 4e 54 20 49 4e 53 45 52 | 54 20 43 41 53 43 41 44 |NT INSER|T CASCAD|
|00002a90| 45 25 27 25 27 ff ff 03 | 00 16 00 50 41 52 45 4e |E%'%'...|...PAREN|
|00002aa0| 54 20 49 4e 53 45 52 54 | 20 52 45 53 54 52 49 43 |T INSERT| RESTRIC|
|00002ab0| 54 24 27 24 27 ff ff 03 | 00 19 00 50 41 52 45 4e |T$'$'...|...PAREN|
|00002ac0| 54 20 49 4e 53 45 52 54 | 20 53 45 54 20 44 45 46 |T INSERT| SET DEF|
|00002ad0| 41 55 4c 54 27 27 27 27 | ff ff 03 00 16 00 50 41 |AULT''''|......PA|
|00002ae0| 52 45 4e 54 20 49 4e 53 | 45 52 54 20 53 45 54 20 |RENT INS|ERT SET |
|00002af0| 4e 55 4c 4c 26 27 26 27 | ff ff 03 00 15 00 50 41 |NULL&'&'|......PA|
|00002b00| 52 45 4e 54 20 55 50 44 | 41 54 45 20 43 41 53 43 |RENT UPD|ATE CASC|
|00002b10| 41 44 45 11 27 11 27 ff | ff 03 00 16 00 50 41 52 |ADE.'.'.|.....PAR|
|00002b20| 45 4e 54 20 55 50 44 41 | 54 45 20 52 45 53 54 52 |ENT UPDA|TE RESTR|
|00002b30| 49 43 54 10 27 10 27 ff | ff 03 00 19 00 50 41 52 |ICT.'.'.|.....PAR|
|00002b40| 45 4e 54 20 55 50 44 41 | 54 45 20 53 45 54 20 44 |ENT UPDA|TE SET D|
|00002b50| 45 46 41 55 4c 54 13 27 | 13 27 ff ff 03 00 16 00 |EFAULT.'|.'......|
|00002b60| 50 41 52 45 4e 54 20 55 | 50 44 41 54 45 20 53 45 |PARENT U|PDATE SE|
|00002b70| 54 20 4e 55 4c 4c 12 27 | 12 27 ff ff 03 00 15 00 |T NULL.'|.'......|
|00002b80| 54 52 49 47 47 45 52 20 | 44 45 4c 45 54 45 20 46 |TRIGGER |DELETE F|
|00002b90| 4f 4f 54 45 52 2b 27 2b | 27 ff ff 03 00 15 00 54 |OOTER+'+|'......T|
|00002ba0| 52 49 47 47 45 52 20 44 | 45 4c 45 54 45 20 48 45 |RIGGER D|ELETE HE|
|00002bb0| 41 44 45 52 2a 27 2a 27 | ff ff 03 00 15 00 54 52 |ADER*'*'|......TR|
|00002bc0| 49 47 47 45 52 20 49 4e | 53 45 52 54 20 46 4f 4f |IGGER IN|SERT FOO|
|00002bd0| 54 45 52 2d 27 2d 27 ff | ff 03 00 15 00 54 52 49 |TER-'-'.|.....TRI|
|00002be0| 47 47 45 52 20 49 4e 53 | 45 52 54 20 48 45 41 44 |GGER INS|ERT HEAD|
|00002bf0| 45 52 2c 27 2c 27 ff ff | 03 00 15 00 54 52 49 47 |ER,','..|....TRIG|
|00002c00| 47 45 52 20 55 50 44 41 | 54 45 20 46 4f 4f 54 45 |GER UPDA|TE FOOTE|
|00002c10| 52 29 27 29 27 ff ff 03 | 00 15 00 54 52 49 47 47 |R)')'...|...TRIGG|
|00002c20| 45 52 20 55 50 44 41 54 | 45 20 48 45 41 44 45 52 |ER UPDAT|E HEADER|
|00002c30| 28 27 28 27 ff ff 10 27 | 14 27 18 27 1c 27 00 00 |('('...'|.'.'.'..|
|00002c40| 00 00 00 00 12 27 16 27 | 1a 27 1e 27 00 00 00 00 |.....'.'|.'.'....|
|00002c50| 00 00 10 27 14 27 18 27 | 1c 27 00 00 00 00 00 00 |...'.'.'|.'......|
|00002c60| 11 27 15 27 18 27 1c 27 | 00 00 00 00 00 00 01 00 |.'.'.'.'|........|
|00002c70| 01 00 07 00 43 4d 50 5f | 54 59 50 00 00 00 00 02 |....CMP_|TYP.....|
|00002c80| 00 01 00 06 00 43 4d 50 | 5f 4e 4d 00 00 00 00 03 |.....CMP|_NM.....|
|00002c90| 00 03 00 06 00 53 59 53 | 5f 43 44 00 00 00 00 04 |.....SYS|_CD.....|
|00002ca0| 00 03 00 06 00 53 59 53 | 5f 4e 4d 00 00 00 00 05 |.....SYS|_NM.....|
|00002cb0| 00 04 00 06 00 53 45 43 | 5f 43 44 00 00 00 00 06 |.....SEC|_CD.....|
|00002cc0| 00 04 00 06 00 53 45 43 | 5f 4e 4d 00 00 00 00 07 |.....SEC|_NM.....|
|00002cd0| 00 05 00 06 00 4e 45 54 | 5f 43 44 00 00 00 00 08 |.....NET|_CD.....|
|00002ce0| 00 05 00 06 00 4e 45 54 | 5f 4e 4d 00 00 00 00 1a |.....NET|_NM.....|
|00002cf0| 00 08 00 07 00 43 4f 4d | 50 5f 43 44 00 00 00 00 |.....COM|P_CD....|
|00002d00| 1b 00 08 00 07 00 43 4f | 4d 50 5f 4e 4d 00 00 00 |......CO|MP_NM...|
|00002d10| 00 1c 00 08 00 09 00 43 | 4f 4d 50 5f 41 44 44 31 |.......C|OMP_ADD1|
|00002d20| 00 00 00 00 1d 00 08 00 | 09 00 43 4f 4d 50 5f 41 |........|..COMP_A|
|00002d30| 44 44 32 00 00 00 00 1e | 00 08 00 04 00 43 49 54 |DD2.....|.....CIT|
|00002d40| 59 00 00 00 00 1f 00 08 | 00 0b 00 4d 44 5f 43 48 |Y.......|...MD_CH|
|00002d50| 41 49 52 4d 41 4e 00 00 | 00 00 20 00 08 00 0e 00 |AIRMAN..|.. .....|
|00002d60| 4d 44 5f 43 48 52 4d 41 | 4e 5f 44 45 53 47 00 00 |MD_CHRMA|N_DESG..|
|00002d70| 00 00 21 00 08 00 05 00 | 50 4f 5f 43 44 00 00 00 |..!.....|PO_CD...|
|00002d80| 00 22 00 08 00 06 00 54 | 45 4c 5f 4e 4f 00 00 00 |.".....T|EL_NO...|
|00002d90| 00 23 00 08 00 09 00 45 | 4d 41 49 4c 5f 41 44 44 |.#.....E|MAIL_ADD|
|00002da0| 00 00 00 00 24 00 08 00 | 06 00 4e 4f 5f 45 4d 50 |....$...|..NO_EMP|
|00002db0| 00 00 00 00 25 00 08 00 | 07 00 42 55 53 5f 41 43 |....%...|..BUS_AC|
|00002dc0| 54 00 00 00 00 26 00 08 | 00 07 00 4d 55 4c 5f 4e |T....&..|...MUL_N|
|00002dd0| 41 54 00 00 00 00 27 00 | 08 00 09 00 4a 4f 49 4e |AT....'.|....JOIN|
|00002de0| 5f 56 45 4e 54 00 00 00 | 00 28 00 08 00 06 00 47 |_VENT...|.(.....G|
|00002df0| 52 50 5f 4e 4d 00 00 00 | 00 29 00 08 00 06 00 4e |RP_NM...|.).....N|
|00002e00| 4f 5f 42 52 4e 00 00 00 | 00 2c 00 09 00 05 00 4d |O_BRN...|.,.....M|
|00002e10| 4f 44 45 4c 00 00 00 00 | 2d 00 09 00 08 00 50 55 |ODEL....|-.....PU|
|00002e20| 52 5f 59 45 41 52 00 00 | 00 00 2e 00 09 00 08 00 |R_YEAR..|........|
|00002e30| 53 50 45 43 49 46 49 43 | 00 00 00 00 2f 00 09 00 |SPECIFIC|..../...|
|00002e40| 06 00 4d 45 4d 4f 52 59 | 00 00 00 00 30 00 09 00 |..MEMORY|....0...|
|00002e50| 06 00 48 5f 44 49 53 4b | 00 00 00 00 31 00 09 00 |..H_DISK|....1...|
|00002e60| 04 00 54 45 52 4d 00 00 | 00 00 32 00 09 00 08 00 |..TERM..|..2.....|
|00002e70| 50 52 49 4e 54 45 52 53 | 00 00 00 00 33 00 09 00 |PRINTERS|....3...|
|00002e80| 08 00 50 4c 4f 54 54 45 | 52 53 00 00 00 00 34 00 |..PLOTTE|RS....4.|
|00002e90| 09 00 08 00 44 49 53 4b | 5f 44 52 56 00 00 00 00 |....DISK|_DRV....|
|00002ea0| 35 00 09 00 08 00 54 41 | 50 45 5f 44 52 56 00 00 |5.....TA|PE_DRV..|
|00002eb0| 00 00 36 00 09 00 04 00 | 43 4f 4d 4d 00 00 00 00 |..6.....|COMM....|
|00002ec0| 37 00 09 00 09 00 4e 4f | 5f 4f 46 5f 50 43 53 00 |7.....NO|_OF_PCS.|
|00002ed0| 00 00 00 38 00 09 00 09 | 00 50 52 4f 43 45 53 53 |...8....|.PROCESS|
|00002ee0| 4f 52 00 00 00 00 39 00 | 09 00 05 00 55 4e 49 54 |OR....9.|....UNIT|
|00002ef0| 53 00 00 00 00 3b 00 0a | 00 0a 00 4e 4f 5f 4f 46 |S....;..|...NO_OF|
|00002f00| 5f 54 45 52 4d 00 00 00 | 00 3c 00 0b 00 06 00 5a |_TERM...|.<.....Z|
|00002f10| 4f 4e 5f 4e 4d 00 00 00 | 00 3d 00 0b 00 07 00 4d |ON_NM...|.=.....M|
|00002f20| 41 43 48 49 4e 45 00 00 | 00 00 3e 00 0b 00 04 00 |ACHINE..|..>.....|
|00002f30| 4d 41 4b 45 00 00 00 00 | 3f 00 0b 00 0a 00 53 50 |MAKE....|?.....SP|
|00002f40| 45 43 49 46 49 43 2f 32 | 00 00 00 00 40 00 0b 00 |ECIFIC/2|....@...|
|00002f50| 0b 00 4e 4f 5f 4f 46 5f | 55 53 45 52 53 00 00 00 |..NO_OF_|USERS...|
|00002f60| 00 41 00 0b 00 07 00 4f | 50 52 5f 53 59 53 00 00 |.A.....O|PR_SYS..|
|00002f70| 00 00 42 00 0b 00 08 00 | 4c 41 4e 47 55 41 47 45 |..B.....|LANGUAGE|
|00002f80| 00 00 00 00 43 00 0b 00 | 0c 00 44 42 53 5f 4d 41 |....C...|..DBS_MA|
|00002f90| 4e 41 47 4d 4e 54 00 00 | 00 00 44 00 0b 00 09 00 |NAGMNT..|..D.....|
|00002fa0| 57 4f 52 44 5f 50 52 4f | 43 00 00 00 00 45 00 0b |WORD_PRO|C....E..|
|00002fb0| 00 0d 00 53 50 52 45 41 | 44 5f 53 48 45 45 54 53 |...SPREA|D_SHEETS|
|00002fc0| 00 00 00 00 46 00 0c 00 | 06 00 56 4e 44 5f 43 44 |....F...|..VND_CD|
|00002fd0| 00 00 00 00 47 00 0c 00 | 06 00 56 4e 44 5f 4e 4d |....G...|..VND_NM|
|00002fe0| 00 00 00 00 48 00 0c 00 | 07 00 56 4e 44 5f 41 44 |....H...|..VND_AD|
|00002ff0| 44 00 00 00 00 49 00 0c | 00 08 00 56 4e 44 5f 41 |D....I..|...VND_A|
|00003000| 44 44 31 00 00 00 00 4a | 00 0c 00 07 00 56 4e 44 |DD1....J|.....VND|
|00003010| 5f 54 45 4c 00 00 00 00 | 4b 00 0c 00 07 00 56 4e |_TEL....|K.....VN|
|00003020| 44 5f 46 41 58 00 00 00 | 00 4c 00 0c 00 08 00 59 |D_FAX...|.L.....Y|
|00003030| 45 41 52 5f 50 55 52 00 | 00 00 00 4d 00 0c 00 08 |EAR_PUR.|...M....|
|00003040| 00 59 45 41 52 5f 4d 4e | 54 00 00 00 00 4e 00 0d |.YEAR_MN|T....N..|
|00003050| 00 09 00 4f 50 52 5f 53 | 59 53 2f 32 00 00 00 00 |...OPR_S|YS/2....|
|00003060| 4f 00 0d 00 09 00 4e 4f | 5f 4f 46 5f 55 53 52 00 |O.....NO|_OF_USR.|
|00003070| 00 00 00 50 00 0e 00 08 | 00 50 52 47 5f 4c 41 4e |...P....|.PRG_LAN|
|00003080| 47 00 00 00 00 51 00 0e | 00 0b 00 44 42 53 5f 4d |G....Q..|...DBS_M|
|00003090| 41 4e 47 4d 4e 54 00 00 | 00 00 52 00 0e 00 0b 00 |ANGMNT..|..R.....|
|000030a0| 57 4f 52 44 5f 50 52 4f | 43 2f 32 00 00 00 00 53 |WORD_PRO|C/2....S|
|000030b0| 00 0e 00 08 00 53 50 52 | 44 5f 53 48 54 00 00 00 |.....SPR|D_SHT...|
|000030c0| 00 54 00 0e 00 07 00 50 | 52 45 53 45 4e 54 00 00 |.T.....P|RESENT..|
|000030d0| 00 00 55 00 0e 00 0c 00 | 44 45 53 4b 5f 50 55 42 |..U.....|DESK_PUB|
|000030e0| 4c 49 53 48 00 00 00 00 | 56 00 0e 00 08 00 43 4f |LISH....|V.....CO|
|000030f0| 4d 4d 5f 4e 45 54 00 00 | 00 00 57 00 0e 00 06 00 |MM_NET..|..W.....|
|00003100| 4f 54 48 45 52 53 00 00 | 00 00 58 00 0f 00 06 00 |OTHERS..|..X.....|
|00003110| 53 4f 55 52 43 45 00 00 | 00 00 59 00 0f 00 0a 00 |SOURCE..|..Y.....|
|00003120| 53 4f 46 54 5f 48 4f 55 | 53 45 00 00 00 00 5a 00 |SOFT_HOU|SE....Z.|
|00003130| 10 00 08 00 4e 4f 5f 45 | 4d 50 2f 32 00 00 00 00 |....NO_E|MP/2....|
|00003140| 5b 00 10 00 07 00 52 45 | 50 5f 54 4f 31 00 00 00 |[.....RE|P_TO1...|
|00003150| 00 5c 00 10 00 07 00 52 | 45 50 5f 54 4f 32 00 00 |.\.....R|EP_TO2..|
|00003160| 00 00 5d 00 10 00 07 00 | 52 45 50 5f 54 4f 33 00 |..].....|REP_TO3.|
|00003170| 00 00 00 5e 00 10 00 07 | 00 52 45 50 5f 54 4f 34 |...^....|.REP_TO4|
|00003180| 00 00 00 00 5f 00 10 00 | 0a 00 48 49 45 52 41 52 |...._...|..HIERAR|
|00003190| 43 48 59 31 00 00 00 00 | 60 00 10 00 0a 00 48 49 |CHY1....|`.....HI|
|000031a0| 45 52 41 52 43 48 59 32 | 00 00 00 00 61 00 10 00 |ERARCHY2|....a...|
|000031b0| 0a 00 48 49 45 52 41 52 | 43 48 59 33 00 00 00 00 |..HIERAR|CHY3....|
|000031c0| 62 00 10 00 0a 00 48 49 | 45 52 41 52 43 48 59 34 |b.....HI|ERARCHY4|
|000031d0| 00 00 00 00 63 00 10 00 | 07 00 52 45 4d 41 52 4b |....c...|..REMARK|
|000031e0| 53 00 00 00 00 64 00 11 | 00 09 00 50 45 52 53 4f |S....d..|...PERSO|
|000031f0| 4e 5f 4e 4d 00 00 00 00 | 65 00 11 00 0a 00 50 45 |N_NM....|e.....PE|
|00003200| 52 53 4f 4e 5f 44 53 47 | 00 00 00 00 66 00 11 00 |RSON_DSG|....f...|
|00003210| 0a 00 50 45 52 53 4f 4e | 5f 51 4c 46 00 00 00 00 |..PERSON|_QLF....|
|00003220| 67 00 11 00 0e 00 50 45 | 52 53 4f 4e 5f 54 45 43 |g.....PE|RSON_TEC|
|00003230| 5f 51 4c 46 00 00 00 00 | 68 00 11 00 0d 00 50 45 |_QLF....|h.....PE|
|00003240| 52 53 4f 4e 5f 43 4f 5f | 45 58 50 00 00 00 00 69 |RSON_CO_|EXP....i|
|00003250| 00 11 00 0d 00 50 45 52 | 53 4f 4e 5f 4f 54 5f 45 |.....PER|SON_OT_E|
|00003260| 58 50 00 00 00 00 00 00 | 0e 00 09 00 11 00 14 05 |XP......|........|
|00003270| 70 0a fc 06 9b 0c 3f 1b | a7 e9 06 00 43 49 33 31 |p.....?.|....CI31|
|00003280| 32 53 54 46 00 01 00 00 | 00 00 00 00 00 00 00 08 |2STF....|........|
|00003290| 00 43 49 33 31 32 53 54 | 46 00 00 1a 00 07 00 43 |.CI312ST|F......C|
|000032a0| 4f 4d 50 5f 43 44 08 00 | 43 48 41 52 28 31 38 29 |OMP_CD..|CHAR(18)|
|000032b0| 01 00 00 00 03 00 2e 31 | 39 00 00 07 00 43 4f 4d |.......1|9....COM|
|000032c0| 50 5f 43 44 00 00 00 00 | 00 00 00 00 00 00 ff ff |P_CD....|........|
|000032d0| 00 00 ff ff ff ff 64 00 | 09 00 50 45 52 53 4f 4e |......d.|..PERSON|
|000032e0| 5f 4e 4d 08 00 43 48 41 | 52 28 31 38 29 00 00 64 |_NM..CHA|R(18)..d|
|000032f0| 00 00 00 00 00 09 00 50 | 45 52 53 4f 4e 5f 4e 4d |.......P|ERSON_NM|
|00003300| 00 00 00 00 00 00 00 00 | 01 00 ff ff 00 00 ff ff |........|........|
|00003310| ff ff 65 00 0a 00 50 45 | 52 53 4f 4e 5f 44 53 47 |..e...PE|RSON_DSG|
|00003320| 08 00 43 48 41 52 28 31 | 38 29 00 00 64 00 00 00 |..CHAR(1|8)..d...|
|00003330| 00 00 0a 00 50 45 52 53 | 4f 4e 5f 44 53 47 00 00 |....PERS|ON_DSG..|
|00003340| 00 00 00 00 00 00 02 00 | ff ff 00 00 ff ff ff ff |........|........|
|00003350| 66 00 0a 00 50 45 52 53 | 4f 4e 5f 51 4c 46 08 00 |f...PERS|ON_QLF..|
|00003360| 43 48 41 52 28 31 38 29 | 00 00 64 00 00 00 00 00 |CHAR(18)|..d.....|
|00003370| 0a 00 50 45 52 53 4f 4e | 5f 51 4c 46 00 00 00 00 |..PERSON|_QLF....|
|00003380| 00 00 00 00 03 00 ff ff | 00 00 ff ff ff ff 67 00 |........|......g.|
|00003390| 0e 00 50 45 52 53 4f 4e | 5f 54 45 43 5f 51 4c 46 |..PERSON|_TEC_QLF|
|000033a0| 08 00 43 48 41 52 28 31 | 38 29 00 00 64 00 00 00 |..CHAR(1|8)..d...|
|000033b0| 00 00 0e 00 50 45 52 53 | 4f 4e 5f 54 45 43 5f 51 |....PERS|ON_TEC_Q|
|000033c0| 4c 46 00 00 00 00 00 00 | 00 00 04 00 ff ff 00 00 |LF......|........|
|000033d0| ff ff ff ff 68 00 0d 00 | 50 45 52 53 4f 4e 5f 43 |....h...|PERSON_C|
|000033e0| 4f 5f 45 58 50 08 00 43 | 48 41 52 28 31 38 29 00 |O_EXP..C|HAR(18).|
|000033f0| 00 64 00 00 00 00 00 0d | 00 50 45 52 53 4f 4e 5f |.d......|.PERSON_|
|00003400| 43 4f 5f 45 58 50 00 00 | 00 00 00 00 00 00 05 00 |CO_EXP..|........|
|00003410| ff ff 00 00 ff ff ff ff | 69 00 0d 00 50 45 52 53 |........|i...PERS|
|00003420| 4f 4e 5f 4f 54 5f 45 58 | 50 08 00 43 48 41 52 28 |ON_OT_EX|P..CHAR(|
|00003430| 31 38 29 00 00 64 00 00 | 00 00 00 0d 00 50 45 52 |18)..d..|.....PER|
|00003440| 53 4f 4e 5f 4f 54 5f 45 | 58 50 00 00 00 00 00 00 |SON_OT_E|XP......|
|00003450| 00 00 06 00 ff ff 00 00 | ff ff ff ff 00 00 0c 00 |........|........|
|00003460| 01 00 04 00 41 4b 49 44 | 06 00 00 00 00 01 00 0a |....AKID|........|
|00003470| 00 49 6e 64 65 78 20 4e | 61 6d 65 20 00 00 00 00 |.Index N|ame ....|
|00003480| 00 00 05 00 23 43 6f 6c | 73 06 00 00 00 00 01 00 |....#Col|s.......|
|00003490| 06 00 55 6e 69 71 75 65 | 08 00 00 00 00 00 00 07 |..Unique|........|
|000034a0| 00 62 44 65 6c 65 74 65 | 00 00 00 00 00 01 00 07 |.bDelete|........|
|000034b0| 00 4b 65 79 45 78 70 72 | 00 00 03 00 0a 0d 20 00 |.KeyExpr|...... .|
|000034c0| 01 00 08 00 41 53 43 2f | 44 45 53 43 05 00 00 00 |....ASC/|DESC....|
|000034d0| 00 01 00 03 00 4d 44 58 | 06 00 00 00 00 01 00 05 |.....MDX|........|
|000034e0| 00 46 4e 41 4d 45 0c 00 | 00 00 00 01 00 03 00 46 |.FNAME..|.......F|
|000034f0| 4f 52 00 00 00 00 00 00 | 00 09 00 43 6c 75 73 74 |OR......|...Clust|
|00003500| 65 72 65 64 06 00 00 00 | 00 02 00 09 00 50 68 79 |ered....|.....Phy|
|00003510| 73 20 50 72 6f 70 00 00 | 00 00 00 01 00 0c 00 02 |s Prop..|........|
|00003520| 00 50 4b 0b 00 58 50 4b | 43 49 33 31 32 53 54 46 |.PK..XPK|CI312STF|
|00003530| 01 00 03 00 59 45 53 00 | 00 00 00 00 00 00 00 00 |....YES.|........|
|00003540| 00 00 00 01 00 02 00 01 | 00 0e 00 50 48 59 53 20 |........|...PHYS |
|00003550| 50 52 4f 50 20 4e 41 4d | 45 00 00 00 00 00 01 00 |PROP NAM|E.......|
|00003560| 0f 00 50 48 59 53 20 50 | 52 4f 50 20 56 41 4c 55 |..PHYS P|ROP VALU|
|00003570| 45 00 00 00 00 00 00 00 | 07 00 01 00 04 00 41 4b |E.......|......AK|
|00003580| 49 44 00 00 00 00 00 02 | 00 03 00 68 45 41 00 00 |ID......|...hEA..|
|00003590| 00 00 00 01 00 08 00 41 | 74 74 20 4e 61 6d 65 20 |.......A|tt Name |
|000035a0| 00 00 00 00 01 00 08 00 | 41 53 43 2f 44 45 53 43 |........|ASC/DESC|
|000035b0| 20 00 00 00 00 00 00 08 | 00 50 6f 73 69 74 69 6f | .......|.Positio|
|000035c0| 6e 06 00 00 00 00 00 00 | 07 00 62 44 65 6c 65 74 |n.......|..bDelet|
|000035d0| 65 00 00 00 00 00 02 00 | 05 00 50 52 4f 50 53 00 |e.......|..PROPS.|
|000035e0| 00 00 00 00 02 00 07 00 | 02 00 50 4b 00 00 07 00 |........|..PK....|
|000035f0| 43 4f 4d 50 5f 43 44 03 | 00 41 53 43 01 00 00 00 |COMP_CD.|.ASC....|
|00003600| 01 00 01 00 04 00 50 52 | 4f 50 0a 00 00 00 00 00 |......PR|OP......|
|00003610| 00 00 00 08 00 01 00 03 | 00 45 50 50 00 00 00 00 |........|.EPP....|
|00003620| 00 00 00 04 00 44 42 4d | 53 00 00 00 00 00 01 00 |.....DBM|S.......|
|00003630| 02 00 50 56 00 00 00 00 | 00 00 00 05 00 45 50 50 |..PV....|.....EPP|
|00003640| 49 44 00 00 00 00 00 00 | 00 04 00 50 56 49 44 00 |ID......|...PVID.|
|00003650| 00 00 00 00 00 00 04 00 | 54 59 50 45 00 00 00 00 |........|TYPE....|
|00003660| 00 00 00 05 00 4f 52 44 | 45 52 00 00 00 00 00 00 |.....ORD|ER......|
|00003670| 00 04 00 53 50 45 43 00 | 00 00 00 00 00 00 00 00 |...SPEC.|........|
|00003680| 00 00 0a 00 01 00 0c 00 | 54 72 69 67 67 65 72 20 |........|Trigger |
|00003690| 4e 61 6d 65 00 00 00 00 | 00 00 00 0c 00 54 72 69 |Name....|.....Tri|
|000036a0| 67 67 65 72 20 54 79 70 | 65 00 00 00 00 00 00 00 |gger Typ|e.......|
|000036b0| 10 00 54 72 69 67 67 65 | 72 20 44 69 73 61 62 6c |..Trigge|r Disabl|
|000036c0| 65 64 00 00 00 00 00 00 | 00 13 00 54 72 69 67 67 |ed......|...Trigg|
|000036d0| 65 72 20 46 69 72 65 20 | 4f 70 74 69 6f 6e 00 00 |er Fire |Option..|
|000036e0| 00 00 00 00 00 0d 00 54 | 72 69 67 67 65 72 20 53 |.......T|rigger S|
|000036f0| 63 6f 70 65 00 00 00 00 | 00 01 00 14 00 4f 6c 64 |cope....|.....Old|
|00003700| 20 43 6f 72 72 65 6c 61 | 74 69 6f 6e 20 4e 61 6d | Correla|tion Nam|
|00003710| 65 00 00 00 00 00 01 00 | 14 00 4e 65 77 20 43 6f |e.......|..New Co|
|00003720| 72 72 65 6c 61 74 69 6f | 6e 20 4e 61 6d 65 00 00 |rrelatio|n Name..|
|00003730| 00 00 00 01 00 0e 00 57 | 68 65 6e 20 43 6f 6e 64 |.......W|hen Cond|
|00003740| 69 74 69 6f 6e 00 00 00 | 00 00 01 00 0c 00 54 72 |ition...|......Tr|
|00003750| 69 67 67 65 72 20 42 6f | 64 79 00 00 00 00 00 02 |igger Bo|dy......|
|00003760| 00 18 00 54 72 69 67 67 | 65 72 20 45 66 66 65 63 |...Trigg|er Effec|
|00003770| 74 65 64 20 43 6f 6c 75 | 6d 6e 73 00 00 00 00 00 |ted Colu|mns.....|
|00003780| 01 00 00 00 00 00 09 00 | 10 00 48 03 74 0a c8 04 |........|..H.t...|
|00003790| 8f 0d 3f 1b a7 e9 06 00 | 43 49 33 31 31 44 50 44 |..?.....|CI311DPD|
|000037a0| 00 01 00 00 00 00 00 00 | 00 00 00 08 00 43 49 33 |........|.....CI3|
|000037b0| 31 31 44 50 44 00 00 1a | 00 07 00 43 4f 4d 50 5f |11DPD...|...COMP_|
|000037c0| 43 44 08 00 43 48 41 52 | 28 31 38 29 01 00 00 00 |CD..CHAR|(18)....|
|000037d0| 03 00 2e 31 36 00 00 07 | 00 43 4f 4d 50 5f 43 44 |...16...|.COMP_CD|
|000037e0| 00 00 00 00 00 00 00 00 | ff ff ff ff 00 00 ff ff |........|........|
|000037f0| ff ff 5a 00 08 00 4e 4f | 5f 45 4d 50 5f 32 08 00 |..Z...NO|_EMP_2..|
|00003800| 43 48 41 52 28 31 38 29 | 00 00 64 00 00 00 00 00 |CHAR(18)|..d.....|
|00003810| 08 00 4e 4f 5f 45 4d 50 | 2f 32 00 00 00 00 00 00 |..NO_EMP|/2......|
|00003820| 00 00 ff ff ff ff 00 00 | ff ff ff ff 5b 00 07 00 |........|....[...|
|00003830| 52 45 50 5f 54 4f 31 08 | 00 43 48 41 52 28 31 38 |REP_TO1.|.CHAR(18|
|00003840| 29 00 00 64 00 00 00 00 | 00 07 00 52 45 50 5f 54 |)..d....|...REP_T|
|00003850| 4f 31 00 00 00 00 00 00 | 00 00 ff ff ff ff 00 00 |O1......|........|
|00003860| ff ff ff ff 5c 00 07 00 | 52 45 50 5f 54 4f 32 08 |....\...|REP_TO2.|
|00003870| 00 43 48 41 52 28 31 38 | 29 00 00 64 00 00 00 00 |.CHAR(18|)..d....|
|00003880| 00 07 00 52 45 50 5f 54 | 4f 32 00 00 00 00 00 00 |...REP_T|O2......|
|00003890| 00 00 ff ff ff ff 00 00 | ff ff ff ff 5d 00 07 00 |........|....]...|
|000038a0| 52 45 50 5f 54 4f 33 08 | 00 43 48 41 52 28 31 38 |REP_TO3.|.CHAR(18|
|000038b0| 29 00 00 64 00 00 00 00 | 00 07 00 52 45 50 5f 54 |)..d....|...REP_T|
|000038c0| 4f 33 00 00 00 00 00 00 | 00 00 ff ff ff ff 00 00 |O3......|........|
|000038d0| ff ff ff ff 5e 00 07 00 | 52 45 50 5f 54 4f 34 08 |....^...|REP_TO4.|
|000038e0| 00 43 48 41 52 28 31 38 | 29 00 00 64 00 00 00 00 |.CHAR(18|)..d....|
|000038f0| 00 07 00 52 45 50 5f 54 | 4f 34 00 00 00 00 00 00 |...REP_T|O4......|
|00003900| 00 00 ff ff ff ff 00 00 | ff ff ff ff 5f 00 0a 00 |........|...._...|
|00003910| 48 49 45 52 41 52 43 48 | 59 31 08 00 43 48 41 52 |HIERARCH|Y1..CHAR|
|00003920| 28 31 38 29 00 00 64 00 | 00 00 00 00 0a 00 48 49 |(18)..d.|......HI|
|00003930| 45 52 41 52 43 48 59 31 | 00 00 00 00 00 00 00 00 |ERARCHY1|........|
|00003940| ff ff ff ff 00 00 ff ff | ff ff 60 00 0a 00 48 49 |........|..`...HI|
|00003950| 45 52 41 52 43 48 59 32 | 08 00 43 48 41 52 28 31 |ERARCHY2|..CHAR(1|
|00003960| 38 29 00 00 64 00 00 00 | 00 00 0a 00 48 49 45 52 |8)..d...|....HIER|
|00003970| 41 52 43 48 59 32 00 00 | 00 00 00 00 00 00 ff ff |ARCHY2..|........|
|00003980| ff ff 00 00 ff ff ff ff | 61 00 0a 00 48 49 45 52 |........|a...HIER|
|00003990| 41 52 43 48 59 33 08 00 | 43 48 41 52 28 31 38 29 |ARCHY3..|CHAR(18)|
|000039a0| 00 00 64 00 00 00 00 00 | 0a 00 48 49 45 52 41 52 |..d.....|..HIERAR|
|000039b0| 43 48 59 33 00 00 00 00 | 00 00 00 00 ff ff ff ff |CHY3....|........|
|000039c0| 00 00 ff ff ff ff 62 00 | 0a 00 48 49 45 52 41 52 |......b.|..HIERAR|
|000039d0| 43 48 59 34 08 00 43 48 | 41 52 28 31 38 29 00 00 |CHY4..CH|AR(18)..|
|000039e0| 64 00 00 00 00 00 0a 00 | 48 49 45 52 41 52 43 48 |d.......|HIERARCH|
|000039f0| 59 34 00 00 00 00 00 00 | 00 00 ff ff ff ff 00 00 |Y4......|........|
|00003a00| ff ff ff ff 63 00 07 00 | 52 45 4d 41 52 4b 53 08 |....c...|REMARKS.|
|00003a10| 00 43 48 41 52 28 31 38 | 29 00 00 64 00 00 00 00 |.CHAR(18|)..d....|
|00003a20| 00 07 00 52 45 4d 41 52 | 4b 53 00 00 00 00 00 00 |...REMAR|KS......|
|00003a30| 00 00 ff ff ff ff 00 00 | ff ff ff ff 00 00 0c 00 |........|........|
|00003a40| 01 00 04 00 41 4b 49 44 | 06 00 00 00 00 01 00 0a |....AKID|........|
|00003a50| 00 49 6e 64 65 78 20 4e | 61 6d 65 20 00 00 00 00 |.Index N|ame ....|
|00003a60| 00 00 05 00 23 43 6f 6c | 73 06 00 00 00 00 01 00 |....#Col|s.......|
|00003a70| 06 00 55 6e 69 71 75 65 | 08 00 00 00 00 00 00 07 |..Unique|........|
|00003a80| 00 62 44 65 6c 65 74 65 | 00 00 00 00 00 01 00 07 |.bDelete|........|
|00003a90| 00 4b 65 79 45 78 70 72 | 00 00 03 00 0a 0d 20 00 |.KeyExpr|...... .|
|00003aa0| 01 00 08 00 41 53 43 2f | 44 45 53 43 05 00 00 00 |....ASC/|DESC....|
|00003ab0| 00 01 00 03 00 4d 44 58 | 06 00 00 00 00 01 00 05 |.....MDX|........|
|00003ac0| 00 46 4e 41 4d 45 0c 00 | 00 00 00 01 00 03 00 46 |.FNAME..|.......F|
|00003ad0| 4f 52 00 00 00 00 00 00 | 00 09 00 43 6c 75 73 74 |OR......|...Clust|
|00003ae0| 65 72 65 64 06 00 00 00 | 00 02 00 09 00 50 68 79 |ered....|.....Phy|
|00003af0| 73 20 50 72 6f 70 00 00 | 00 00 00 01 00 0c 00 02 |s Prop..|........|
|00003b00| 00 50 4b 0b 00 58 50 4b | 43 49 33 31 31 44 50 44 |.PK..XPK|CI311DPD|
|00003b10| 01 00 03 00 59 45 53 00 | 00 00 00 00 00 00 00 00 |....YES.|........|
|00003b20| 00 00 00 01 00 02 00 01 | 00 0e 00 50 48 59 53 20 |........|...PHYS |
|00003b30| 50 52 4f 50 20 4e 41 4d | 45 00 00 00 00 00 01 00 |PROP NAM|E.......|
|00003b40| 0f 00 50 48 59 53 20 50 | 52 4f 50 20 56 41 4c 55 |..PHYS P|ROP VALU|
|00003b50| 45 00 00 00 00 00 00 00 | 07 00 01 00 04 00 41 4b |E.......|......AK|
|00003b60| 49 44 00 00 00 00 00 02 | 00 03 00 68 45 41 00 00 |ID......|...hEA..|
|00003b70| 00 00 00 01 00 08 00 41 | 74 74 20 4e 61 6d 65 20 |.......A|tt Name |
|00003b80| 00 00 00 00 01 00 08 00 | 41 53 43 2f 44 45 53 43 |........|ASC/DESC|
|00003b90| 20 00 00 00 00 00 00 08 | 00 50 6f 73 69 74 69 6f | .......|.Positio|
|00003ba0| 6e 06 00 00 00 00 00 00 | 07 00 62 44 65 6c 65 74 |n.......|..bDelet|
|00003bb0| 65 00 00 00 00 00 02 00 | 05 00 50 52 4f 50 53 00 |e.......|..PROPS.|
|00003bc0| 00 00 00 00 01 00 07 00 | 02 00 50 4b 00 00 07 00 |........|..PK....|
|00003bd0| 43 4f 4d 50 5f 43 44 03 | 00 41 53 43 01 00 00 00 |COMP_CD.|.ASC....|
|00003be0| 01 00 01 00 04 00 50 52 | 4f 50 0a 00 00 00 00 00 |......PR|OP......|
|00003bf0| 00 08 00 01 00 03 00 45 | 50 50 00 00 00 00 00 00 |.......E|PP......|
|00003c00| 00 04 00 44 42 4d 53 00 | 00 00 00 00 01 00 02 00 |...DBMS.|........|
|00003c10| 50 56 00 00 00 00 00 00 | 00 05 00 45 50 50 49 44 |PV......|...EPPID|
|00003c20| 00 00 00 00 00 00 00 04 | 00 50 56 49 44 00 00 00 |........|.PVID...|
|00003c30| 00 00 00 00 04 00 54 59 | 50 45 00 00 00 00 00 00 |......TY|PE......|
|00003c40| 00 05 00 4f 52 44 45 52 | 00 00 00 00 00 00 00 04 |...ORDER|........|
|00003c50| 00 53 50 45 43 00 00 00 | 00 00 00 00 00 00 00 00 |.SPEC...|........|
|00003c60| 0a 00 01 00 0c 00 54 72 | 69 67 67 65 72 20 4e 61 |......Tr|igger Na|
|00003c70| 6d 65 00 00 00 00 00 00 | 00 0c 00 54 72 69 67 67 |me......|...Trigg|
|00003c80| 65 72 20 54 79 70 65 00 | 00 00 00 00 00 00 10 00 |er Type.|........|
|00003c90| 54 72 69 67 67 65 72 20 | 44 69 73 61 62 6c 65 64 |Trigger |Disabled|
|00003ca0| 00 00 00 00 00 00 00 13 | 00 54 72 69 67 67 65 72 |........|.Trigger|
|00003cb0| 20 46 69 72 65 20 4f 70 | 74 69 6f 6e 00 00 00 00 | Fire Op|tion....|
|00003cc0| 00 00 00 0d 00 54 72 69 | 67 67 65 72 20 53 63 6f |.....Tri|gger Sco|
|00003cd0| 70 65 00 00 00 00 00 01 | 00 14 00 4f 6c 64 20 43 |pe......|...Old C|
|00003ce0| 6f 72 72 65 6c 61 74 69 | 6f 6e 20 4e 61 6d 65 00 |orrelati|on Name.|
|00003cf0| 00 00 00 00 01 00 14 00 | 4e 65 77 20 43 6f 72 72 |........|New Corr|
|00003d00| 65 6c 61 74 69 6f 6e 20 | 4e 61 6d 65 00 00 00 00 |elation |Name....|
|00003d10| 00 01 00 0e 00 57 68 65 | 6e 20 43 6f 6e 64 69 74 |.....Whe|n Condit|
|00003d20| 69 6f 6e 00 00 00 00 00 | 01 00 0c 00 54 72 69 67 |ion.....|....Trig|
|00003d30| 67 65 72 20 42 6f 64 79 | 00 00 00 00 00 02 00 18 |ger Body|........|
|00003d40| 00 54 72 69 67 67 65 72 | 20 45 66 66 65 63 74 65 |.Trigger| Effecte|
|00003d50| 64 20 43 6f 6c 75 6d 6e | 73 00 00 00 00 00 01 00 |d Column|s.......|
|00003d60| 00 00 00 00 09 00 0f 00 | fc 07 58 09 7c 09 cf 0a |........|..X.|...|
|00003d70| 3f 1b a7 e9 06 00 43 49 | 33 31 30 50 4b 47 00 01 |?.....CI|310PKG..|
|00003d80| 00 00 00 00 00 00 00 00 | 00 08 00 43 49 33 31 30 |........|...CI310|
|00003d90| 50 4b 47 00 00 1a 00 07 | 00 43 4f 4d 50 5f 43 44 |PKG.....|.COMP_CD|
|00003da0| 08 00 43 48 41 52 28 31 | 38 29 01 00 00 00 03 00 |..CHAR(1|8)......|
|00003db0| 2e 31 34 00 00 07 00 43 | 4f 4d 50 5f 43 44 00 00 |.14....C|OMP_CD..|
|00003dc0| 00 00 00 00 00 00 ff ff | ff ff 00 00 ff ff ff ff |........|........|
|00003dd0| 03 00 06 00 53 59 53 5f | 43 44 08 00 43 48 41 52 |....SYS_|CD..CHAR|
|00003de0| 28 31 38 29 01 00 00 00 | 03 00 2e 31 35 00 00 06 |(18)....|...15...|
|00003df0| 00 53 59 53 5f 43 44 00 | 00 00 00 00 00 00 00 ff |.SYS_CD.|........|
|00003e00| ff ff ff 00 00 ff ff ff | ff 58 00 06 00 53 4f 55 |........|.X...SOU|
|00003e10| 52 43 45 08 00 43 48 41 | 52 28 31 38 29 00 00 64 |RCE..CHA|R(18)..d|
|00003e20| 00 00 00 00 00 06 00 53 | 4f 55 52 43 45 00 00 00 |.......S|OURCE...|
|00003e30| 00 00 00 00 00 ff ff ff | ff 00 00 ff ff ff ff 59 |........|.......Y|
|00003e40| 00 0a 00 53 4f 46 54 5f | 48 4f 55 53 45 08 00 43 |...SOFT_|HOUSE..C|
|00003e50| 48 41 52 28 31 38 29 00 | 00 64 00 00 00 00 00 0a |HAR(18).|.d......|
|00003e60| 00 53 4f 46 54 5f 48 4f | 55 53 45 00 00 00 00 00 |.SOFT_HO|USE.....|
|00003e70| 00 00 00 ff ff ff ff 00 | 00 ff ff ff ff 00 00 0c |........|........|
|00003e80| 00 01 00 04 00 41 4b 49 | 44 06 00 00 00 00 01 00 |.....AKI|D.......|
|00003e90| 0a 00 49 6e 64 65 78 20 | 4e 61 6d 65 20 00 00 00 |..Index |Name ...|
|00003ea0| 00 00 00 05 00 23 43 6f | 6c 73 06 00 00 00 00 01 |.....#Co|ls......|
|00003eb0| 00 06 00 55 6e 69 71 75 | 65 08 00 00 00 00 00 00 |...Uniqu|e.......|
|00003ec0| 07 00 62 44 65 6c 65 74 | 65 00 00 00 00 00 01 00 |..bDelet|e.......|
|00003ed0| 07 00 4b 65 79 45 78 70 | 72 00 00 03 00 0a 0d 20 |..KeyExp|r...... |
|00003ee0| 00 01 00 08 00 41 53 43 | 2f 44 45 53 43 05 00 00 |.....ASC|/DESC...|
|00003ef0| 00 00 01 00 03 00 4d 44 | 58 06 00 00 00 00 01 00 |......MD|X.......|
|00003f00| 05 00 46 4e 41 4d 45 0c | 00 00 00 00 01 00 03 00 |..FNAME.|........|
|00003f10| 46 4f 52 00 00 00 00 00 | 00 00 09 00 43 6c 75 73 |FOR.....|....Clus|
|00003f20| 74 65 72 65 64 06 00 00 | 00 00 02 00 09 00 50 68 |tered...|......Ph|
|00003f30| 79 73 20 50 72 6f 70 00 | 00 00 00 00 01 00 0c 00 |ys Prop.|........|
|00003f40| 02 00 50 4b 0b 00 58 50 | 4b 43 49 33 31 30 50 4b |..PK..XP|KCI310PK|
|00003f50| 47 02 00 03 00 59 45 53 | 00 00 00 00 00 00 00 00 |G....YES|........|
|00003f60| 00 00 00 00 01 00 02 00 | 01 00 0e 00 50 48 59 53 |........|....PHYS|
|00003f70| 20 50 52 4f 50 20 4e 41 | 4d 45 00 00 00 00 00 01 | PROP NA|ME......|
|00003f80| 00 0f 00 50 48 59 53 20 | 50 52 4f 50 20 56 41 4c |...PHYS |PROP VAL|
|00003f90| 55 45 00 00 00 00 00 00 | 00 07 00 01 00 04 00 41 |UE......|.......A|
|00003fa0| 4b 49 44 00 00 00 00 00 | 02 00 03 00 68 45 41 00 |KID.....|....hEA.|
|00003fb0| 00 00 00 00 01 00 08 00 | 41 74 74 20 4e 61 6d 65 |........|Att Name|
|00003fc0| 20 00 00 00 00 01 00 08 | 00 41 53 43 2f 44 45 53 | .......|.ASC/DES|
|00003fd0| 43 20 00 00 00 00 00 00 | 08 00 50 6f 73 69 74 69 |C ......|..Positi|
|00003fe0| 6f 6e 06 00 00 00 00 00 | 00 07 00 62 44 65 6c 65 |on......|...bDele|
|00003ff0| 74 65 00 00 00 00 00 02 | 00 05 00 50 52 4f 50 53 |te......|...PROPS|
|00004000| 00 00 00 00 00 02 00 07 | 00 02 00 50 4b 00 00 07 |........|...PK...|
|00004010| 00 43 4f 4d 50 5f 43 44 | 03 00 41 53 43 01 00 00 |.COMP_CD|..ASC...|
|00004020| 00 01 00 01 00 04 00 50 | 52 4f 50 0a 00 00 00 00 |.......P|ROP.....|
|00004030| 00 00 07 00 02 00 50 4b | 01 00 06 00 53 59 53 5f |......PK|....SYS_|
|00004040| 43 44 03 00 41 53 43 02 | 00 00 00 01 00 01 00 04 |CD..ASC.|........|
|00004050| 00 50 52 4f 50 0a 00 00 | 00 00 00 00 08 00 01 00 |.PROP...|........|
|00004060| 03 00 45 50 50 00 00 00 | 00 00 00 00 04 00 44 42 |..EPP...|......DB|
|00004070| 4d 53 00 00 00 00 00 01 | 00 02 00 50 56 00 00 00 |MS......|...PV...|
|00004080| 00 00 00 00 05 00 45 50 | 50 49 44 00 00 00 00 00 |......EP|PID.....|
|00004090| 00 00 04 00 50 56 49 44 | 00 00 00 00 00 00 00 04 |....PVID|........|
|000040a0| 00 54 59 50 45 00 00 00 | 00 00 00 00 05 00 4f 52 |.TYPE...|......OR|
|000040b0| 44 45 52 00 00 00 00 00 | 00 00 04 00 53 50 45 43 |DER.....|....SPEC|
|000040c0| 00 00 00 00 00 00 00 00 | 00 00 00 0a 00 01 00 0c |........|........|
|000040d0| 00 54 72 69 67 67 65 72 | 20 4e 61 6d 65 00 00 00 |.Trigger| Name...|
|000040e0| 00 00 00 00 0c 00 54 72 | 69 67 67 65 72 20 54 79 |......Tr|igger Ty|
|000040f0| 70 65 00 00 00 00 00 00 | 00 10 00 54 72 69 67 67 |pe......|...Trigg|
|00004100| 65 72 20 44 69 73 61 62 | 6c 65 64 00 00 00 00 00 |er Disab|led.....|
|00004110| 00 00 13 00 54 72 69 67 | 67 65 72 20 46 69 72 65 |....Trig|ger Fire|
|00004120| 20 4f 70 74 69 6f 6e 00 | 00 00 00 00 00 00 0d 00 | Option.|........|
|00004130| 54 72 69 67 67 65 72 20 | 53 63 6f 70 65 00 00 00 |Trigger |Scope...|
|00004140| 00 00 01 00 14 00 4f 6c | 64 20 43 6f 72 72 65 6c |......Ol|d Correl|
|00004150| 61 74 69 6f 6e 20 4e 61 | 6d 65 00 00 00 00 00 01 |ation Na|me......|
|00004160| 00 14 00 4e 65 77 20 43 | 6f 72 72 65 6c 61 74 69 |...New C|orrelati|
|00004170| 6f 6e 20 4e 61 6d 65 00 | 00 00 00 00 01 00 0e 00 |on Name.|........|
|00004180| 57 68 65 6e 20 43 6f 6e | 64 69 74 69 6f 6e 00 00 |When Con|dition..|
|00004190| 00 00 00 01 00 0c 00 54 | 72 69 67 67 65 72 20 42 |.......T|rigger B|
|000041a0| 6f 64 79 00 00 00 00 00 | 02 00 18 00 54 72 69 67 |ody.....|....Trig|
|000041b0| 67 65 72 20 45 66 66 65 | 63 74 65 64 20 43 6f 6c |ger Effe|cted Col|
|000041c0| 75 6d 6e 73 00 00 00 00 | 00 01 00 00 00 00 00 09 |umns....|........|
|000041d0| 00 0e 00 7c 00 9c 08 14 | 02 3f 0b 3f 1b a7 e9 06 |...|....|.?.?....|
|000041e0| 00 43 49 33 30 38 41 50 | 50 00 01 00 00 00 00 00 |.CI308AP|P.......|
|000041f0| 00 00 00 00 08 00 43 49 | 33 30 38 41 50 50 00 00 |......CI|308APP..|
|00004200| 1a 00 07 00 43 4f 4d 50 | 5f 43 44 08 00 43 48 41 |....COMP|_CD..CHA|
|00004210| 52 28 31 38 29 01 00 00 | 00 03 00 2e 31 33 00 00 |R(18)...|....13..|
|00004220| 07 00 43 4f 4d 50 5f 43 | 44 00 00 00 00 00 00 00 |..COMP_C|D.......|
|00004230| 00 ff ff ff ff 00 00 ff | ff ff ff 50 00 08 00 50 |........|...P...P|
|00004240| 52 47 5f 4c 41 4e 47 08 | 00 43 48 41 52 28 31 38 |RG_LANG.|.CHAR(18|
|00004250| 29 00 00 64 00 00 00 00 | 00 08 00 50 52 47 5f 4c |)..d....|...PRG_L|
|00004260| 41 4e 47 00 00 00 00 00 | 00 00 00 ff ff ff ff 00 |ANG.....|........|
|00004270| 00 ff ff ff ff 51 00 0b | 00 44 42 53 5f 4d 41 4e |.....Q..|.DBS_MAN|
|00004280| 47 4d 4e 54 08 00 43 48 | 41 52 28 31 38 29 00 00 |GMNT..CH|AR(18)..|
|00004290| 64 00 00 00 00 00 0b 00 | 44 42 53 5f 4d 41 4e 47 |d.......|DBS_MANG|
|000042a0| 4d 4e 54 00 00 00 00 00 | 00 00 00 ff ff ff ff 00 |MNT.....|........|
|000042b0| 00 ff ff ff ff 52 00 0b | 00 57 4f 52 44 5f 50 52 |.....R..|.WORD_PR|
|000042c0| 4f 43 5f 32 08 00 43 48 | 41 52 28 31 38 29 00 00 |OC_2..CH|AR(18)..|
|000042d0| 64 00 00 00 00 00 0b 00 | 57 4f 52 44 5f 50 52 4f |d.......|WORD_PRO|
|000042e0| 43 2f 32 00 00 00 00 00 | 00 00 00 ff ff ff ff 00 |C/2.....|........|
|000042f0| 00 ff ff ff ff 53 00 08 | 00 53 50 52 44 5f 53 48 |.....S..|.SPRD_SH|
|00004300| 54 08 00 43 48 41 52 28 | 31 38 29 00 00 64 00 00 |T..CHAR(|18)..d..|
|00004310| 00 00 00 08 00 53 50 52 | 44 5f 53 48 54 00 00 00 |.....SPR|D_SHT...|
|00004320| 00 00 00 00 00 ff ff ff | ff 00 00 ff ff ff ff 54 |........|.......T|
|00004330| 00 07 00 50 52 45 53 45 | 4e 54 08 00 43 48 41 52 |...PRESE|NT..CHAR|
|00004340| 28 31 38 29 00 00 64 00 | 00 00 00 00 07 00 50 52 |(18)..d.|......PR|
|00004350| 45 53 45 4e 54 00 00 00 | 00 00 00 00 00 ff ff ff |ESENT...|........|
|00004360| ff 00 00 ff ff ff ff 55 | 00 0c 00 44 45 53 4b 5f |.......U|...DESK_|
|00004370| 50 55 42 4c 49 53 48 08 | 00 43 48 41 52 28 31 38 |PUBLISH.|.CHAR(18|
|00004380| 29 00 00 64 00 00 00 00 | 00 0c 00 44 45 53 4b 5f |)..d....|...DESK_|
|00004390| 50 55 42 4c 49 53 48 00 | 00 00 00 00 00 00 00 ff |PUBLISH.|........|
|000043a0| ff ff ff 00 00 ff ff ff | ff 56 00 08 00 43 4f 4d |........|.V...COM|
|000043b0| 4d 5f 4e 45 54 08 00 43 | 48 41 52 28 31 38 29 00 |M_NET..C|HAR(18).|
|000043c0| 00 64 00 00 00 00 00 08 | 00 43 4f 4d 4d 5f 4e 45 |.d......|.COMM_NE|
|000043d0| 54 00 00 00 00 00 00 00 | 00 ff ff ff ff 00 00 ff |T.......|........|
|000043e0| ff ff ff 57 00 06 00 4f | 54 48 45 52 53 08 00 43 |...W...O|THERS..C|
|000043f0| 48 41 52 28 31 38 29 00 | 00 64 00 00 00 00 00 06 |HAR(18).|.d......|
|00004400| 00 4f 54 48 45 52 53 00 | 00 00 00 00 00 00 00 ff |.OTHERS.|........|
|00004410| ff ff ff 00 00 ff ff ff | ff 00 00 0c 00 01 00 04 |........|........|
|00004420| 00 41 4b 49 44 06 00 00 | 00 00 01 00 0a 00 49 6e |.AKID...|......In|
|00004430| 64 65 78 20 4e 61 6d 65 | 20 00 00 00 00 00 00 05 |dex Name| .......|
|00004440| 00 23 43 6f 6c 73 06 00 | 00 00 00 01 00 06 00 55 |.#Cols..|.......U|
|00004450| 6e 69 71 75 65 08 00 00 | 00 00 00 00 07 00 62 44 |nique...|......bD|
|00004460| 65 6c 65 74 65 00 00 00 | 00 00 01 00 07 00 4b 65 |elete...|......Ke|
|00004470| 79 45 78 70 72 00 00 03 | 00 0a 0d 20 00 01 00 08 |yExpr...|... ....|
|00004480| 00 41 53 43 2f 44 45 53 | 43 05 00 00 00 00 01 00 |.ASC/DES|C.......|
|00004490| 03 00 4d 44 58 06 00 00 | 00 00 01 00 05 00 46 4e |..MDX...|......FN|
|000044a0| 41 4d 45 0c 00 00 00 00 | 01 00 03 00 46 4f 52 00 |AME.....|....FOR.|
|000044b0| 00 00 00 00 00 00 09 00 | 43 6c 75 73 74 65 72 65 |........|Clustere|
|000044c0| 64 06 00 00 00 00 02 00 | 09 00 50 68 79 73 20 50 |d.......|..Phys P|
|000044d0| 72 6f 70 00 00 00 00 00 | 01 00 0c 00 02 00 50 4b |rop.....|......PK|
|000044e0| 0b 00 58 50 4b 43 49 33 | 30 38 41 50 50 01 00 03 |..XPKCI3|08APP...|
|000044f0| 00 59 45 53 00 00 00 00 | 00 00 00 00 00 00 00 00 |.YES....|........|
|00004500| 01 00 02 00 01 00 0e 00 | 50 48 59 53 20 50 52 4f |........|PHYS PRO|
|00004510| 50 20 4e 41 4d 45 00 00 | 00 00 00 01 00 0f 00 50 |P NAME..|.......P|
|00004520| 48 59 53 20 50 52 4f 50 | 20 56 41 4c 55 45 00 00 |HYS PROP| VALUE..|
|00004530| 00 00 00 00 00 07 00 01 | 00 04 00 41 4b 49 44 00 |........|...AKID.|
|00004540| 00 00 00 00 02 00 03 00 | 68 45 41 00 00 00 00 00 |........|hEA.....|
|00004550| 01 00 08 00 41 74 74 20 | 4e 61 6d 65 20 00 00 00 |....Att |Name ...|
|00004560| 00 01 00 08 00 41 53 43 | 2f 44 45 53 43 20 00 00 |.....ASC|/DESC ..|
|00004570| 00 00 00 00 08 00 50 6f | 73 69 74 69 6f 6e 06 00 |......Po|sition..|
|00004580| 00 00 00 00 00 07 00 62 | 44 65 6c 65 74 65 00 00 |.......b|Delete..|
|00004590| 00 00 00 02 00 05 00 50 | 52 4f 50 53 00 00 00 00 |.......P|ROPS....|
|000045a0| 00 01 00 07 00 02 00 50 | 4b 00 00 07 00 43 4f 4d |.......P|K....COM|
|000045b0| 50 5f 43 44 03 00 41 53 | 43 01 00 00 00 01 00 01 |P_CD..AS|C.......|
|000045c0| 00 04 00 50 52 4f 50 0a | 00 00 00 00 00 00 08 00 |...PROP.|........|
|000045d0| 01 00 03 00 45 50 50 00 | 00 00 00 00 00 00 04 00 |....EPP.|........|
|000045e0| 44 42 4d 53 00 00 00 00 | 00 01 00 02 00 50 56 00 |DBMS....|.....PV.|
|000045f0| 00 00 00 00 00 00 05 00 | 45 50 50 49 44 00 00 00 |........|EPPID...|
|00004600| 00 00 00 00 04 00 50 56 | 49 44 00 00 00 00 00 00 |......PV|ID......|
|00004610| 00 04 00 54 59 50 45 00 | 00 00 00 00 00 00 05 00 |...TYPE.|........|
|00004620| 4f 52 44 45 52 00 00 00 | 00 00 00 00 04 00 53 50 |ORDER...|......SP|
|00004630| 45 43 00 00 00 00 00 00 | 00 00 00 00 00 0a 00 01 |EC......|........|
|00004640| 00 0c 00 54 72 69 67 67 | 65 72 20 4e 61 6d 65 00 |...Trigg|er Name.|
|00004650| 00 00 00 00 00 00 0c 00 | 54 72 69 67 67 65 72 20 |........|Trigger |
|00004660| 54 79 70 65 00 00 00 00 | 00 00 00 10 00 54 72 69 |Type....|.....Tri|
|00004670| 67 67 65 72 20 44 69 73 | 61 62 6c 65 64 00 00 00 |gger Dis|abled...|
|00004680| 00 00 00 00 13 00 54 72 | 69 67 67 65 72 20 46 69 |......Tr|igger Fi|
|00004690| 72 65 20 4f 70 74 69 6f | 6e 00 00 00 00 00 00 00 |re Optio|n.......|
|000046a0| 0d 00 54 72 69 67 67 65 | 72 20 53 63 6f 70 65 00 |..Trigge|r Scope.|
|000046b0| 00 00 00 00 01 00 14 00 | 4f 6c 64 20 43 6f 72 72 |........|Old Corr|
|000046c0| 65 6c 61 74 69 6f 6e 20 | 4e 61 6d 65 00 00 00 00 |elation |Name....|
|000046d0| 00 01 00 14 00 4e 65 77 | 20 43 6f 72 72 65 6c 61 |.....New| Correla|
|000046e0| 74 69 6f 6e 20 4e 61 6d | 65 00 00 00 00 00 01 00 |tion Nam|e.......|
|000046f0| 0e 00 57 68 65 6e 20 43 | 6f 6e 64 69 74 69 6f 6e |..When C|ondition|
|00004700| 00 00 00 00 00 01 00 0c | 00 54 72 69 67 67 65 72 |........|.Trigger|
|00004710| 20 42 6f 64 79 00 00 00 | 00 00 02 00 18 00 54 72 | Body...|......Tr|
|00004720| 69 67 67 65 72 20 45 66 | 66 65 63 74 65 64 20 43 |igger Ef|fected C|
|00004730| 6f 6c 75 6d 6e 73 00 00 | 00 00 00 01 00 00 00 00 |olumns..|........|
|00004740| 00 09 00 0d 00 48 08 e0 | 06 c8 09 1b 08 3f 1b a7 |.....H..|.....?..|
|00004750| e9 06 00 43 49 33 30 37 | 53 46 54 00 01 00 00 00 |...CI307|SFT.....|
|00004760| 00 00 00 00 00 00 08 00 | 43 49 33 30 37 53 46 54 |........|CI307SFT|
|00004770| 00 00 1a 00 07 00 43 4f | 4d 50 5f 43 44 08 00 43 |......CO|MP_CD..C|
|00004780| 48 41 52 28 31 38 29 01 | 00 00 00 03 00 2e 31 32 |HAR(18).|......12|
|00004790| 00 00 07 00 43 4f 4d 50 | 5f 43 44 00 00 00 00 00 |....COMP|_CD.....|
|000047a0| 00 00 00 ff ff ff ff 00 | 00 ff ff ff ff 4e 00 09 |........|.....N..|
|000047b0| 00 4f 50 52 5f 53 59 53 | 5f 32 08 00 43 48 41 52 |.OPR_SYS|_2..CHAR|
|000047c0| 28 31 38 29 00 00 64 00 | 00 00 00 00 09 00 4f 50 |(18)..d.|......OP|
|000047d0| 52 5f 53 59 53 2f 32 00 | 00 00 00 00 00 00 00 ff |R_SYS/2.|........|
|000047e0| ff ff ff 00 00 ff ff ff | ff 4f 00 09 00 4e 4f 5f |........|.O...NO_|
|000047f0| 4f 46 5f 55 53 52 08 00 | 43 48 41 52 28 31 38 29 |OF_USR..|CHAR(18)|
|00004800| 00 00 64 00 00 00 00 00 | 09 00 4e 4f 5f 4f 46 5f |..d.....|..NO_OF_|
|00004810| 55 53 52 00 00 00 00 00 | 00 00 00 ff ff ff ff 00 |USR.....|........|
|00004820| 00 ff ff ff ff 00 00 0c | 00 01 00 04 00 41 4b 49 |........|.....AKI|
|00004830| 44 06 00 00 00 00 01 00 | 0a 00 49 6e 64 65 78 20 |D.......|..Index |
|00004840| 4e 61 6d 65 20 00 00 00 | 00 00 00 05 00 23 43 6f |Name ...|.....#Co|
|00004850| 6c 73 06 00 00 00 00 01 | 00 06 00 55 6e 69 71 75 |ls......|...Uniqu|
|00004860| 65 08 00 00 00 00 00 00 | 07 00 62 44 65 6c 65 74 |e.......|..bDelet|
|00004870| 65 00 00 00 00 00 01 00 | 07 00 4b 65 79 45 78 70 |e.......|..KeyExp|
|00004880| 72 00 00 03 00 0a 0d 20 | 00 01 00 08 00 41 53 43 |r...... |.....ASC|
|00004890| 2f 44 45 53 43 05 00 00 | 00 00 01 00 03 00 4d 44 |/DESC...|......MD|
|000048a0| 58 06 00 00 00 00 01 00 | 05 00 46 4e 41 4d 45 0c |X.......|..FNAME.|
|000048b0| 00 00 00 00 01 00 03 00 | 46 4f 52 00 00 00 00 00 |........|FOR.....|
|000048c0| 00 00 09 00 43 6c 75 73 | 74 65 72 65 64 06 00 00 |....Clus|tered...|
|000048d0| 00 00 02 00 09 00 50 68 | 79 73 20 50 72 6f 70 00 |......Ph|ys Prop.|
|000048e0| 00 00 00 00 01 00 0c 00 | 02 00 50 4b 0b 00 58 50 |........|..PK..XP|
|000048f0| 4b 43 49 33 30 37 53 46 | 54 01 00 03 00 59 45 53 |KCI307SF|T....YES|
|00004900| 00 00 00 00 00 00 00 00 | 00 00 00 00 01 00 02 00 |........|........|
|00004910| 01 00 0e 00 50 48 59 53 | 20 50 52 4f 50 20 4e 41 |....PHYS| PROP NA|
|00004920| 4d 45 00 00 00 00 00 01 | 00 0f 00 50 48 59 53 20 |ME......|...PHYS |
|00004930| 50 52 4f 50 20 56 41 4c | 55 45 00 00 00 00 00 00 |PROP VAL|UE......|
|00004940| 00 07 00 01 00 04 00 41 | 4b 49 44 00 00 00 00 00 |.......A|KID.....|
|00004950| 02 00 03 00 68 45 41 00 | 00 00 00 00 01 00 08 00 |....hEA.|........|
|00004960| 41 74 74 20 4e 61 6d 65 | 20 00 00 00 00 01 00 08 |Att Name| .......|
|00004970| 00 41 53 43 2f 44 45 53 | 43 20 00 00 00 00 00 00 |.ASC/DES|C ......|
|00004980| 08 00 50 6f 73 69 74 69 | 6f 6e 06 00 00 00 00 00 |..Positi|on......|
|00004990| 00 07 00 62 44 65 6c 65 | 74 65 00 00 00 00 00 02 |...bDele|te......|
|000049a0| 00 05 00 50 52 4f 50 53 | 00 00 00 00 00 01 00 07 |...PROPS|........|
|000049b0| 00 02 00 50 4b 00 00 07 | 00 43 4f 4d 50 5f 43 44 |...PK...|.COMP_CD|
|000049c0| 03 00 41 53 43 01 00 00 | 00 01 00 01 00 04 00 50 |..ASC...|.......P|
|000049d0| 52 4f 50 0a 00 00 00 00 | 00 00 08 00 01 00 03 00 |ROP.....|........|
|000049e0| 45 50 50 00 00 00 00 00 | 00 00 04 00 44 42 4d 53 |EPP.....|....DBMS|
|000049f0| 00 00 00 00 00 01 00 02 | 00 50 56 00 00 00 00 00 |........|.PV.....|
|00004a00| 00 00 05 00 45 50 50 49 | 44 00 00 00 00 00 00 00 |....EPPI|D.......|
|00004a10| 04 00 50 56 49 44 00 00 | 00 00 00 00 00 04 00 54 |..PVID..|.......T|
|00004a20| 59 50 45 00 00 00 00 00 | 00 00 05 00 4f 52 44 45 |YPE.....|....ORDE|
|00004a30| 52 00 00 00 00 00 00 00 | 04 00 53 50 45 43 00 00 |R.......|..SPEC..|
|00004a40| 00 00 00 00 00 00 00 00 | 00 0a 00 01 00 0c 00 54 |........|.......T|
|00004a50| 72 69 67 67 65 72 20 4e | 61 6d 65 00 00 00 00 00 |rigger N|ame.....|
|00004a60| 00 00 0c 00 54 72 69 67 | 67 65 72 20 54 79 70 65 |....Trig|ger Type|
|00004a70| 00 00 00 00 00 00 00 10 | 00 54 72 69 67 67 65 72 |........|.Trigger|
|00004a80| 20 44 69 73 61 62 6c 65 | 64 00 00 00 00 00 00 00 | Disable|d.......|
|00004a90| 13 00 54 72 69 67 67 65 | 72 20 46 69 72 65 20 4f |..Trigge|r Fire O|
|00004aa0| 70 74 69 6f 6e 00 00 00 | 00 00 00 00 0d 00 54 72 |ption...|......Tr|
|00004ab0| 69 67 67 65 72 20 53 63 | 6f 70 65 00 00 00 00 00 |igger Sc|ope.....|
|00004ac0| 01 00 14 00 4f 6c 64 20 | 43 6f 72 72 65 6c 61 74 |....Old |Correlat|
|00004ad0| 69 6f 6e 20 4e 61 6d 65 | 00 00 00 00 00 01 00 14 |ion Name|........|
|00004ae0| 00 4e 65 77 20 43 6f 72 | 72 65 6c 61 74 69 6f 6e |.New Cor|relation|
|00004af0| 20 4e 61 6d 65 00 00 00 | 00 00 01 00 0e 00 57 68 | Name...|......Wh|
|00004b00| 65 6e 20 43 6f 6e 64 69 | 74 69 6f 6e 00 00 00 00 |en Condi|tion....|
|00004b10| 00 01 00 0c 00 54 72 69 | 67 67 65 72 20 42 6f 64 |.....Tri|gger Bod|
|00004b20| 79 00 00 00 00 00 02 00 | 18 00 54 72 69 67 67 65 |y.......|..Trigge|
|00004b30| 72 20 45 66 66 65 63 74 | 65 64 20 43 6f 6c 75 6d |r Effect|ed Colum|
|00004b40| 6e 73 00 00 00 00 00 01 | 00 00 00 00 00 09 00 0c |ns......|........|
|00004b50| 00 38 00 50 04 b8 01 2f | 07 3f 1b a7 e9 06 00 43 |.8.P.../|.?.....C|
|00004b60| 49 33 30 36 56 4e 44 00 | 01 00 00 00 00 00 00 00 |I306VND.|........|
|00004b70| 00 00 08 00 43 49 33 30 | 36 56 4e 44 00 00 1a 00 |....CI30|6VND....|
|00004b80| 07 00 43 4f 4d 50 5f 43 | 44 08 00 43 48 41 52 28 |..COMP_C|D..CHAR(|
|00004b90| 31 38 29 01 00 00 00 03 | 00 2e 31 30 00 00 07 00 |18).....|..10....|
|00004ba0| 43 4f 4d 50 5f 43 44 00 | 00 00 00 00 00 00 00 ff |COMP_CD.|........|
|00004bb0| ff ff ff 00 00 ff ff ff | ff 1a 00 07 00 43 4f 4d |........|.....COM|
|00004bc0| 50 5f 43 44 08 00 43 48 | 41 52 28 31 38 29 01 00 |P_CD..CH|AR(18)..|
|00004bd0| 00 00 05 00 2e 35 2e 31 | 31 00 00 07 00 43 4f 4d |.....5.1|1....COM|
|00004be0| 50 5f 43 44 00 00 00 00 | 00 00 00 00 ff ff ff ff |P_CD....|........|
|00004bf0| 00 00 ff ff ff ff 01 00 | 07 00 43 4d 50 5f 54 59 |........|..CMP_TY|
|00004c00| 50 08 00 43 48 41 52 28 | 31 38 29 01 00 00 00 05 |P..CHAR(|18).....|
|00004c10| 00 2e 36 2e 31 31 00 00 | 07 00 43 4d 50 5f 54 59 |..6.11..|..CMP_TY|
|00004c20| 50 00 00 00 00 00 00 00 | 00 ff ff ff ff 00 00 ff |P.......|........|
|00004c30| ff ff ff 46 00 06 00 56 | 4e 44 5f 43 44 08 00 43 |...F...V|ND_CD..C|
|00004c40| 48 41 52 28 31 38 29 00 | 00 64 00 00 00 00 00 06 |HAR(18).|.d......|
|00004c50| 00 56 4e 44 5f 43 44 00 | 00 00 00 00 00 00 00 ff |.VND_CD.|........|
|00004c60| ff ff ff 00 00 ff ff ff | ff 47 00 06 00 56 4e 44 |........|.G...VND|
|00004c70| 5f 4e 4d 08 00 43 48 41 | 52 28 31 38 29 00 00 64 |_NM..CHA|R(18)..d|
|00004c80| 00 00 00 00 00 06 00 56 | 4e 44 5f 4e 4d 00 00 00 |.......V|ND_NM...|
|00004c90| 00 00 00 00 00 ff ff ff | ff 00 00 ff ff ff ff 48 |........|.......H|
|00004ca0| 00 07 00 56 4e 44 5f 41 | 44 44 08 00 43 48 41 52 |...VND_A|DD..CHAR|
|00004cb0| 28 31 38 29 00 00 64 00 | 00 00 00 00 07 00 56 4e |(18)..d.|......VN|
|00004cc0| 44 5f 41 44 44 00 00 00 | 00 00 00 00 00 ff ff ff |D_ADD...|........|
|00004cd0| ff 00 00 ff ff ff ff 49 | 00 08 00 56 4e 44 5f 41 |.......I|...VND_A|
|00004ce0| 44 44 31 08 00 43 48 41 | 52 28 31 38 29 00 00 64 |DD1..CHA|R(18)..d|
|00004cf0| 00 00 00 00 00 08 00 56 | 4e 44 5f 41 44 44 31 00 |.......V|ND_ADD1.|
|00004d00| 00 00 00 00 00 00 00 ff | ff ff ff 00 00 ff ff ff |........|........|
|00004d10| ff 4a 00 07 00 56 4e 44 | 5f 54 45 4c 08 00 43 48 |.J...VND|_TEL..CH|
|00004d20| 41 52 28 31 38 29 00 00 | 64 00 00 00 00 00 07 00 |AR(18)..|d.......|
|00004d30| 56 4e 44 5f 54 45 4c 00 | 00 00 00 00 00 00 00 ff |VND_TEL.|........|
|00004d40| ff ff ff 00 00 ff ff ff | ff 4b 00 07 00 56 4e 44 |........|.K...VND|
|00004d50| 5f 46 41 58 08 00 43 48 | 41 52 28 31 38 29 00 00 |_FAX..CH|AR(18)..|
|00004d60| 64 00 00 00 00 00 07 00 | 56 4e 44 5f 46 41 58 00 |d.......|VND_FAX.|
|00004d70| 00 00 00 00 00 00 00 ff | ff ff ff 00 00 ff ff ff |........|........|
|00004d80| ff 4c 00 08 00 59 45 41 | 52 5f 50 55 52 08 00 43 |.L...YEA|R_PUR..C|
|00004d90| 48 41 52 28 31 38 29 00 | 00 64 00 00 00 00 00 08 |HAR(18).|.d......|
|00004da0| 00 59 45 41 52 5f 50 55 | 52 00 00 00 00 00 00 00 |.YEAR_PU|R.......|
|00004db0| 00 ff ff ff ff 00 00 ff | ff ff ff 4d 00 08 00 59 |........|...M...Y|
|00004dc0| 45 41 52 5f 4d 4e 54 08 | 00 43 48 41 52 28 31 38 |EAR_MNT.|.CHAR(18|
|00004dd0| 29 00 00 64 00 00 00 00 | 00 08 00 59 45 41 52 5f |)..d....|...YEAR_|
|00004de0| 4d 4e 54 00 00 00 00 00 | 00 00 00 ff ff ff ff 00 |MNT.....|........|
|00004df0| 00 ff ff ff ff 00 00 0c | 00 01 00 04 00 41 4b 49 |........|.....AKI|
|00004e00| 44 06 00 00 00 00 01 00 | 0a 00 49 6e 64 65 78 20 |D.......|..Index |
|00004e10| 4e 61 6d 65 20 00 00 00 | 00 00 00 05 00 23 43 6f |Name ...|.....#Co|
|00004e20| 6c 73 06 00 00 00 00 01 | 00 06 00 55 6e 69 71 75 |ls......|...Uniqu|
|00004e30| 65 08 00 00 00 00 00 00 | 07 00 62 44 65 6c 65 74 |e.......|..bDelet|
|00004e40| 65 00 00 00 00 00 01 00 | 07 00 4b 65 79 45 78 70 |e.......|..KeyExp|
|00004e50| 72 00 00 03 00 0a 0d 20 | 00 01 00 08 00 41 53 43 |r...... |.....ASC|
|00004e60| 2f 44 45 53 43 05 00 00 | 00 00 01 00 03 00 4d 44 |/DESC...|......MD|
|00004e70| 58 06 00 00 00 00 01 00 | 05 00 46 4e 41 4d 45 0c |X.......|..FNAME.|
|00004e80| 00 00 00 00 01 00 03 00 | 46 4f 52 00 00 00 00 00 |........|FOR.....|
|00004e90| 00 00 09 00 43 6c 75 73 | 74 65 72 65 64 06 00 00 |....Clus|tered...|
|00004ea0| 00 00 02 00 09 00 50 68 | 79 73 20 50 72 6f 70 00 |......Ph|ys Prop.|
|00004eb0| 00 00 00 00 01 00 0c 00 | 02 00 50 4b 0b 00 58 50 |........|..PK..XP|
|00004ec0| 4b 43 49 33 30 36 56 4e | 44 02 00 03 00 59 45 53 |KCI306VN|D....YES|
|00004ed0| 00 00 00 00 00 00 00 00 | 00 00 00 00 01 00 02 00 |........|........|
|00004ee0| 01 00 0e 00 50 48 59 53 | 20 50 52 4f 50 20 4e 41 |....PHYS| PROP NA|
|00004ef0| 4d 45 00 00 00 00 00 01 | 00 0f 00 50 48 59 53 20 |ME......|...PHYS |
|00004f00| 50 52 4f 50 20 56 41 4c | 55 45 00 00 00 00 00 00 |PROP VAL|UE......|
|00004f10| 00 07 00 01 00 04 00 41 | 4b 49 44 00 00 00 00 00 |.......A|KID.....|
|00004f20| 02 00 03 00 68 45 41 00 | 00 00 00 00 01 00 08 00 |....hEA.|........|
|00004f30| 41 74 74 20 4e 61 6d 65 | 20 00 00 00 00 01 00 08 |Att Name| .......|
|00004f40| 00 41 53 43 2f 44 45 53 | 43 20 00 00 00 00 00 00 |.ASC/DES|C ......|
|00004f50| 08 00 50 6f 73 69 74 69 | 6f 6e 06 00 00 00 00 00 |..Positi|on......|
|00004f60| 00 07 00 62 44 65 6c 65 | 74 65 00 00 00 00 00 02 |...bDele|te......|
|00004f70| 00 05 00 50 52 4f 50 53 | 00 00 00 00 00 02 00 07 |...PROPS|........|
|00004f80| 00 02 00 50 4b 00 00 07 | 00 43 4f 4d 50 5f 43 44 |...PK...|.COMP_CD|
|00004f90| 03 00 41 53 43 01 00 00 | 00 01 00 01 00 04 00 50 |..ASC...|.......P|
|00004fa0| 52 4f 50 0a 00 00 00 00 | 00 00 07 00 02 00 50 4b |ROP.....|......PK|
|00004fb0| 02 00 07 00 43 4d 50 5f | 54 59 50 03 00 41 53 43 |....CMP_|TYP..ASC|
|00004fc0| 02 00 00 00 01 00 01 00 | 04 00 50 52 4f 50 0a 00 |........|..PROP..|
|00004fd0| 00 00 00 00 00 08 00 01 | 00 03 00 45 50 50 00 00 |........|...EPP..|
|00004fe0| 00 00 00 00 00 04 00 44 | 42 4d 53 00 00 00 00 00 |.......D|BMS.....|
|00004ff0| 01 00 02 00 50 56 00 00 | 00 00 00 00 00 05 00 45 |....PV..|.......E|
|00005000| 50 50 49 44 00 00 00 00 | 00 00 00 04 00 50 56 49 |PPID....|.....PVI|
|00005010| 44 00 00 00 00 00 00 00 | 04 00 54 59 50 45 00 00 |D.......|..TYPE..|
|00005020| 00 00 00 00 00 05 00 4f | 52 44 45 52 00 00 00 00 |.......O|RDER....|
|00005030| 00 00 00 04 00 53 50 45 | 43 00 00 00 00 00 00 00 |.....SPE|C.......|
|00005040| 00 00 00 00 0a 00 01 00 | 0c 00 54 72 69 67 67 65 |........|..Trigge|
|00005050| 72 20 4e 61 6d 65 00 00 | 00 00 00 00 00 0c 00 54 |r Name..|.......T|
|00005060| 72 69 67 67 65 72 20 54 | 79 70 65 00 00 00 00 00 |rigger T|ype.....|
|00005070| 00 00 10 00 54 72 69 67 | 67 65 72 20 44 69 73 61 |....Trig|ger Disa|
|00005080| 62 6c 65 64 00 00 00 00 | 00 00 00 13 00 54 72 69 |bled....|.....Tri|
|00005090| 67 67 65 72 20 46 69 72 | 65 20 4f 70 74 69 6f 6e |gger Fir|e Option|
|000050a0| 00 00 00 00 00 00 00 0d | 00 54 72 69 67 67 65 72 |........|.Trigger|
|000050b0| 20 53 63 6f 70 65 00 00 | 00 00 00 01 00 14 00 4f | Scope..|.......O|
|000050c0| 6c 64 20 43 6f 72 72 65 | 6c 61 74 69 6f 6e 20 4e |ld Corre|lation N|
|000050d0| 61 6d 65 00 00 00 00 00 | 01 00 14 00 4e 65 77 20 |ame.....|....New |
|000050e0| 43 6f 72 72 65 6c 61 74 | 69 6f 6e 20 4e 61 6d 65 |Correlat|ion Name|
|000050f0| 00 00 00 00 00 01 00 0e | 00 57 68 65 6e 20 43 6f |........|.When Co|
|00005100| 6e 64 69 74 69 6f 6e 00 | 00 00 00 00 01 00 0c 00 |ndition.|........|
|00005110| 54 72 69 67 67 65 72 20 | 42 6f 64 79 00 00 00 00 |Trigger |Body....|
|00005120| 00 02 00 18 00 54 72 69 | 67 67 65 72 20 45 66 66 |.....Tri|gger Eff|
|00005130| 65 63 74 65 64 20 43 6f | 6c 75 6d 6e 73 00 00 00 |ected Co|lumns...|
|00005140| 00 00 01 00 00 00 00 00 | 09 00 0b 00 34 08 94 03 |........|....4...|
|00005150| fc 09 af 06 3f 1b a7 e9 | 06 00 43 49 33 30 35 5a |....?...|..CI305Z|
|00005160| 4f 4e 00 01 00 00 00 00 | 00 00 00 00 00 08 00 43 |ON......|.......C|
|00005170| 49 33 30 35 5a 4f 4e 00 | 00 1a 00 07 00 43 4f 4d |I305ZON.|.....COM|
|00005180| 50 5f 43 44 08 00 43 48 | 41 52 28 31 38 29 01 00 |P_CD..CH|AR(18)..|
|00005190| 00 00 02 00 2e 39 00 00 | 07 00 43 4f 4d 50 5f 43 |.....9..|..COMP_C|
|000051a0| 44 00 00 00 00 00 00 00 | 00 ff ff ff ff 00 00 ff |D.......|........|
|000051b0| ff ff ff 3c 00 06 00 5a | 4f 4e 5f 4e 4d 08 00 43 |...<...Z|ON_NM..C|
|000051c0| 48 41 52 28 31 38 29 00 | 00 64 00 00 00 00 00 06 |HAR(18).|.d......|
|000051d0| 00 5a 4f 4e 5f 4e 4d 00 | 00 00 00 00 00 00 00 ff |.ZON_NM.|........|
|000051e0| ff ff ff 00 00 ff ff ff | ff 3d 00 07 00 4d 41 43 |........|.=...MAC|
|000051f0| 48 49 4e 45 08 00 43 48 | 41 52 28 31 38 29 00 00 |HINE..CH|AR(18)..|
|00005200| 64 00 00 00 00 00 07 00 | 4d 41 43 48 49 4e 45 00 |d.......|MACHINE.|
|00005210| 00 00 00 00 00 00 00 ff | ff ff ff 00 00 ff ff ff |........|........|
|00005220| ff 3e 00 04 00 4d 41 4b | 45 08 00 43 48 41 52 28 |.>...MAK|E..CHAR(|
|00005230| 31 38 29 00 00 64 00 00 | 00 00 00 04 00 4d 41 4b |18)..d..|.....MAK|
|00005240| 45 00 00 00 00 00 00 00 | 00 ff ff ff ff 00 00 ff |E.......|........|
|00005250| ff ff ff 3f 00 0a 00 53 | 50 45 43 49 46 49 43 5f |...?...S|PECIFIC_|
|00005260| 32 08 00 43 48 41 52 28 | 31 38 29 00 00 64 00 00 |2..CHAR(|18)..d..|
|00005270| 00 00 00 0a 00 53 50 45 | 43 49 46 49 43 2f 32 00 |.....SPE|CIFIC/2.|
|00005280| 00 00 00 00 00 00 00 ff | ff ff ff 00 00 ff ff ff |........|........|
|00005290| ff 40 00 0b 00 4e 4f 5f | 4f 46 5f 55 53 45 52 53 |.@...NO_|OF_USERS|
|000052a0| 08 00 43 48 41 52 28 31 | 38 29 00 00 64 00 00 00 |..CHAR(1|8)..d...|
|000052b0| 00 00 0b 00 4e 4f 5f 4f | 46 5f 55 53 45 52 53 00 |....NO_O|F_USERS.|
|000052c0| 00 00 00 00 00 00 00 ff | ff ff ff 00 00 ff ff ff |........|........|
|000052d0| ff 41 00 07 00 4f 50 52 | 5f 53 59 53 08 00 43 48 |.A...OPR|_SYS..CH|
|000052e0| 41 52 28 31 38 29 00 00 | 64 00 00 00 00 00 07 00 |AR(18)..|d.......|
|000052f0| 4f 50 52 5f 53 59 53 00 | 00 00 00 00 00 00 00 ff |OPR_SYS.|........|
|00005300| ff ff ff 00 00 ff ff ff | ff 42 00 08 00 4c 41 4e |........|.B...LAN|
|00005310| 47 55 41 47 45 08 00 43 | 48 41 52 28 31 38 29 00 |GUAGE..C|HAR(18).|
|00005320| 00 64 00 00 00 00 00 08 | 00 4c 41 4e 47 55 41 47 |.d......|.LANGUAG|
|00005330| 45 00 00 00 00 00 00 00 | 00 ff ff ff ff 00 00 ff |E.......|........|
|00005340| ff ff ff 43 00 0c 00 44 | 42 53 5f 4d 41 4e 41 47 |...C...D|BS_MANAG|
|00005350| 4d 4e 54 08 00 43 48 41 | 52 28 31 38 29 00 00 64 |MNT..CHA|R(18)..d|
|00005360| 00 00 00 00 00 0c 00 44 | 42 53 5f 4d 41 4e 41 47 |.......D|BS_MANAG|
|00005370| 4d 4e 54 00 00 00 00 00 | 00 00 00 ff ff ff ff 00 |MNT.....|........|
|00005380| 00 ff ff ff ff 44 00 09 | 00 57 4f 52 44 5f 50 52 |.....D..|.WORD_PR|
|00005390| 4f 43 08 00 43 48 41 52 | 28 31 38 29 00 00 64 00 |OC..CHAR|(18)..d.|
|000053a0| 00 00 00 00 09 00 57 4f | 52 44 5f 50 52 4f 43 00 |......WO|RD_PROC.|
|000053b0| 00 00 00 00 00 00 00 ff | ff ff ff 00 00 ff ff ff |........|........|
|000053c0| ff 45 00 0d 00 53 50 52 | 45 41 44 5f 53 48 45 45 |.E...SPR|EAD_SHEE|
|000053d0| 54 53 08 00 43 48 41 52 | 28 31 38 29 00 00 64 00 |TS..CHAR|(18)..d.|
|000053e0| 00 00 00 00 0d 00 53 50 | 52 45 41 44 5f 53 48 45 |......SP|READ_SHE|
|000053f0| 45 54 53 00 00 00 00 00 | 00 00 00 ff ff ff ff 00 |ETS.....|........|
|00005400| 00 ff ff ff ff 00 00 0c | 00 01 00 04 00 41 4b 49 |........|.....AKI|
|00005410| 44 06 00 00 00 00 01 00 | 0a 00 49 6e 64 65 78 20 |D.......|..Index |
|00005420| 4e 61 6d 65 20 00 00 00 | 00 00 00 05 00 23 43 6f |Name ...|.....#Co|
|00005430| 6c 73 06 00 00 00 00 01 | 00 06 00 55 6e 69 71 75 |ls......|...Uniqu|
|00005440| 65 08 00 00 00 00 00 00 | 07 00 62 44 65 6c 65 74 |e.......|..bDelet|
|00005450| 65 00 00 00 00 00 01 00 | 07 00 4b 65 79 45 78 70 |e.......|..KeyExp|
|00005460| 72 00 00 03 00 0a 0d 20 | 00 01 00 08 00 41 53 43 |r...... |.....ASC|
|00005470| 2f 44 45 53 43 05 00 00 | 00 00 01 00 03 00 4d 44 |/DESC...|......MD|
|00005480| 58 06 00 00 00 00 01 00 | 05 00 46 4e 41 4d 45 0c |X.......|..FNAME.|
|00005490| 00 00 00 00 01 00 03 00 | 46 4f 52 00 00 00 00 00 |........|FOR.....|
|000054a0| 00 00 09 00 43 6c 75 73 | 74 65 72 65 64 06 00 00 |....Clus|tered...|
|000054b0| 00 00 02 00 09 00 50 68 | 79 73 20 50 72 6f 70 00 |......Ph|ys Prop.|
|000054c0| 00 00 00 00 01 00 0c 00 | 02 00 50 4b 0b 00 58 50 |........|..PK..XP|
|000054d0| 4b 43 49 33 30 35 5a 4f | 4e 01 00 03 00 59 45 53 |KCI305ZO|N....YES|
|000054e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 01 00 02 00 |........|........|
|000054f0| 01 00 0e 00 50 48 59 53 | 20 50 52 4f 50 20 4e 41 |....PHYS| PROP NA|
|00005500| 4d 45 00 00 00 00 00 01 | 00 0f 00 50 48 59 53 20 |ME......|...PHYS |
|00005510| 50 52 4f 50 20 56 41 4c | 55 45 00 00 00 00 00 00 |PROP VAL|UE......|
|00005520| 00 07 00 01 00 04 00 41 | 4b 49 44 00 00 00 00 00 |.......A|KID.....|
|00005530| 02 00 03 00 68 45 41 00 | 00 00 00 00 01 00 08 00 |....hEA.|........|
|00005540| 41 74 74 20 4e 61 6d 65 | 20 00 00 00 00 01 00 08 |Att Name| .......|
|00005550| 00 41 53 43 2f 44 45 53 | 43 20 00 00 00 00 00 00 |.ASC/DES|C ......|
|00005560| 08 00 50 6f 73 69 74 69 | 6f 6e 06 00 00 00 00 00 |..Positi|on......|
|00005570| 00 07 00 62 44 65 6c 65 | 74 65 00 00 00 00 00 02 |...bDele|te......|
|00005580| 00 05 00 50 52 4f 50 53 | 00 00 00 00 00 01 00 07 |...PROPS|........|
|00005590| 00 02 00 50 4b 00 00 07 | 00 43 4f 4d 50 5f 43 44 |...PK...|.COMP_CD|
|000055a0| 03 00 41 53 43 01 00 00 | 00 01 00 01 00 04 00 50 |..ASC...|.......P|
|000055b0| 52 4f 50 0a 00 00 00 00 | 00 00 08 00 01 00 03 00 |ROP.....|........|
|000055c0| 45 50 50 00 00 00 00 00 | 00 00 04 00 44 42 4d 53 |EPP.....|....DBMS|
|000055d0| 00 00 00 00 00 01 00 02 | 00 50 56 00 00 00 00 00 |........|.PV.....|
|000055e0| 00 00 05 00 45 50 50 49 | 44 00 00 00 00 00 00 00 |....EPPI|D.......|
|000055f0| 04 00 50 56 49 44 00 00 | 00 00 00 00 00 04 00 54 |..PVID..|.......T|
|00005600| 59 50 45 00 00 00 00 00 | 00 00 05 00 4f 52 44 45 |YPE.....|....ORDE|
|00005610| 52 00 00 00 00 00 00 00 | 04 00 53 50 45 43 00 00 |R.......|..SPEC..|
|00005620| 00 00 00 00 00 00 00 00 | 00 0a 00 01 00 0c 00 54 |........|.......T|
|00005630| 72 69 67 67 65 72 20 4e | 61 6d 65 00 00 00 00 00 |rigger N|ame.....|
|00005640| 00 00 0c 00 54 72 69 67 | 67 65 72 20 54 79 70 65 |....Trig|ger Type|
|00005650| 00 00 00 00 00 00 00 10 | 00 54 72 69 67 67 65 72 |........|.Trigger|
|00005660| 20 44 69 73 61 62 6c 65 | 64 00 00 00 00 00 00 00 | Disable|d.......|
|00005670| 13 00 54 72 69 67 67 65 | 72 20 46 69 72 65 20 4f |..Trigge|r Fire O|
|00005680| 70 74 69 6f 6e 00 00 00 | 00 00 00 00 0d 00 54 72 |ption...|......Tr|
|00005690| 69 67 67 65 72 20 53 63 | 6f 70 65 00 00 00 00 00 |igger Sc|ope.....|
|000056a0| 01 00 14 00 4f 6c 64 20 | 43 6f 72 72 65 6c 61 74 |....Old |Correlat|
|000056b0| 69 6f 6e 20 4e 61 6d 65 | 00 00 00 00 00 01 00 14 |ion Name|........|
|000056c0| 00 4e 65 77 20 43 6f 72 | 72 65 6c 61 74 69 6f 6e |.New Cor|relation|
|000056d0| 20 4e 61 6d 65 00 00 00 | 00 00 01 00 0e 00 57 68 | Name...|......Wh|
|000056e0| 65 6e 20 43 6f 6e 64 69 | 74 69 6f 6e 00 00 00 00 |en Condi|tion....|
|000056f0| 00 01 00 0c 00 54 72 69 | 67 67 65 72 20 42 6f 64 |.....Tri|gger Bod|
|00005700| 79 00 00 00 00 00 02 00 | 18 00 54 72 69 67 67 65 |y.......|..Trigge|
|00005710| 72 20 45 66 66 65 63 74 | 65 64 20 43 6f 6c 75 6d |r Effect|ed Colum|
|00005720| 6e 73 00 00 00 00 00 01 | 00 00 00 00 00 09 00 0a |ns......|........|
|00005730| 00 24 08 f8 01 a4 09 33 | 03 3f 1b a7 e9 06 00 43 |.$.....3|.?.....C|
|00005740| 49 33 30 34 4e 45 54 00 | 01 00 00 00 00 00 00 00 |I304NET.|........|
|00005750| 00 00 08 00 43 49 33 30 | 34 4e 45 54 00 00 07 00 |....CI30|4NET....|
|00005760| 06 00 4e 45 54 5f 43 44 | 08 00 43 48 41 52 28 31 |..NET_CD|..CHAR(1|
|00005770| 38 29 01 00 00 00 02 00 | 2e 38 00 00 06 00 4e 45 |8)......|.8....NE|
|00005780| 54 5f 43 44 00 00 00 00 | 00 00 00 00 ff ff ff ff |T_CD....|........|
|00005790| 00 00 ff ff ff ff 1a 00 | 07 00 43 4f 4d 50 5f 43 |........|..COMP_C|
|000057a0| 44 08 00 43 48 41 52 28 | 31 38 29 01 00 00 00 02 |D..CHAR(|18).....|
|000057b0| 00 2e 37 00 00 07 00 43 | 4f 4d 50 5f 43 44 00 00 |..7....C|OMP_CD..|
|000057c0| 00 00 00 00 00 00 ff ff | ff ff 00 00 ff ff ff ff |........|........|
|000057d0| 3b 00 0a 00 4e 4f 5f 4f | 46 5f 54 45 52 4d 08 00 |;...NO_O|F_TERM..|
|000057e0| 43 48 41 52 28 31 38 29 | 00 00 64 00 00 00 00 00 |CHAR(18)|..d.....|
|000057f0| 0a 00 4e 4f 5f 4f 46 5f | 54 45 52 4d 00 00 00 00 |..NO_OF_|TERM....|
|00005800| 00 00 00 00 ff ff ff ff | 00 00 ff ff ff ff 00 00 |........|........|
|00005810| 0c 00 01 00 04 00 41 4b | 49 44 06 00 00 00 00 01 |......AK|ID......|
|00005820| 00 0a 00 49 6e 64 65 78 | 20 4e 61 6d 65 20 00 00 |...Index| Name ..|
|00005830| 00 00 00 00 05 00 23 43 | 6f 6c 73 06 00 00 00 00 |......#C|ols.....|
|00005840| 01 00 06 00 55 6e 69 71 | 75 65 08 00 00 00 00 00 |....Uniq|ue......|
|00005850| 00 07 00 62 44 65 6c 65 | 74 65 00 00 00 00 00 01 |...bDele|te......|
|00005860| 00 07 00 4b 65 79 45 78 | 70 72 00 00 03 00 0a 0d |...KeyEx|pr......|
|00005870| 20 00 01 00 08 00 41 53 | 43 2f 44 45 53 43 05 00 | .....AS|C/DESC..|
|00005880| 00 00 00 01 00 03 00 4d | 44 58 06 00 00 00 00 01 |.......M|DX......|
|00005890| 00 05 00 46 4e 41 4d 45 | 0c 00 00 00 00 01 00 03 |...FNAME|........|
|000058a0| 00 46 4f 52 00 00 00 00 | 00 00 00 09 00 43 6c 75 |.FOR....|.....Clu|
|000058b0| 73 74 65 72 65 64 06 00 | 00 00 00 02 00 09 00 50 |stered..|.......P|
|000058c0| 68 79 73 20 50 72 6f 70 | 00 00 00 00 00 01 00 0c |hys Prop|........|
|000058d0| 00 02 00 50 4b 0b 00 58 | 50 4b 43 49 33 30 34 4e |...PK..X|PKCI304N|
|000058e0| 45 54 02 00 03 00 59 45 | 53 00 00 00 00 00 00 00 |ET....YE|S.......|
|000058f0| 00 00 00 00 00 01 00 02 | 00 01 00 0e 00 50 48 59 |........|.....PHY|
|00005900| 53 20 50 52 4f 50 20 4e | 41 4d 45 00 00 00 00 00 |S PROP N|AME.....|
|00005910| 01 00 0f 00 50 48 59 53 | 20 50 52 4f 50 20 56 41 |....PHYS| PROP VA|
|00005920| 4c 55 45 00 00 00 00 00 | 00 00 07 00 01 00 04 00 |LUE.....|........|
|00005930| 41 4b 49 44 00 00 00 00 | 00 02 00 03 00 68 45 41 |AKID....|.....hEA|
|00005940| 00 00 00 00 00 01 00 08 | 00 41 74 74 20 4e 61 6d |........|.Att Nam|
|00005950| 65 20 00 00 00 00 01 00 | 08 00 41 53 43 2f 44 45 |e ......|..ASC/DE|
|00005960| 53 43 20 00 00 00 00 00 | 00 08 00 50 6f 73 69 74 |SC .....|...Posit|
|00005970| 69 6f 6e 06 00 00 00 00 | 00 00 07 00 62 44 65 6c |ion.....|....bDel|
|00005980| 65 74 65 00 00 00 00 00 | 02 00 05 00 50 52 4f 50 |ete.....|....PROP|
|00005990| 53 00 00 00 00 00 02 00 | 07 00 02 00 50 4b 00 00 |S.......|....PK..|
|000059a0| 06 00 4e 45 54 5f 43 44 | 03 00 41 53 43 01 00 00 |..NET_CD|..ASC...|
|000059b0| 00 01 00 01 00 04 00 50 | 52 4f 50 0a 00 00 00 00 |.......P|ROP.....|
|000059c0| 00 00 07 00 02 00 50 4b | 01 00 07 00 43 4f 4d 50 |......PK|....COMP|
|000059d0| 5f 43 44 03 00 41 53 43 | 02 00 00 00 01 00 01 00 |_CD..ASC|........|
|000059e0| 04 00 50 52 4f 50 0a 00 | 00 00 00 00 00 08 00 01 |..PROP..|........|
|000059f0| 00 03 00 45 50 50 00 00 | 00 00 00 00 00 04 00 44 |...EPP..|.......D|
|00005a00| 42 4d 53 00 00 00 00 00 | 01 00 02 00 50 56 00 00 |BMS.....|....PV..|
|00005a10| 00 00 00 00 00 05 00 45 | 50 50 49 44 00 00 00 00 |.......E|PPID....|
|00005a20| 00 00 00 04 00 50 56 49 | 44 00 00 00 00 00 00 00 |.....PVI|D.......|
|00005a30| 04 00 54 59 50 45 00 00 | 00 00 00 00 00 05 00 4f |..TYPE..|.......O|
|00005a40| 52 44 45 52 00 00 00 00 | 00 00 00 04 00 53 50 45 |RDER....|.....SPE|
|00005a50| 43 00 00 00 00 00 00 00 | 00 00 00 00 0a 00 01 00 |C.......|........|
|00005a60| 0c 00 54 72 69 67 67 65 | 72 20 4e 61 6d 65 00 00 |..Trigge|r Name..|
|00005a70| 00 00 00 00 00 0c 00 54 | 72 69 67 67 65 72 20 54 |.......T|rigger T|
|00005a80| 79 70 65 00 00 00 00 00 | 00 00 10 00 54 72 69 67 |ype.....|....Trig|
|00005a90| 67 65 72 20 44 69 73 61 | 62 6c 65 64 00 00 00 00 |ger Disa|bled....|
|00005aa0| 00 00 00 13 00 54 72 69 | 67 67 65 72 20 46 69 72 |.....Tri|gger Fir|
|00005ab0| 65 20 4f 70 74 69 6f 6e | 00 00 00 00 00 00 00 0d |e Option|........|
|00005ac0| 00 54 72 69 67 67 65 72 | 20 53 63 6f 70 65 00 00 |.Trigger| Scope..|
|00005ad0| 00 00 00 01 00 14 00 4f | 6c 64 20 43 6f 72 72 65 |.......O|ld Corre|
|00005ae0| 6c 61 74 69 6f 6e 20 4e | 61 6d 65 00 00 00 00 00 |lation N|ame.....|
|00005af0| 01 00 14 00 4e 65 77 20 | 43 6f 72 72 65 6c 61 74 |....New |Correlat|
|00005b00| 69 6f 6e 20 4e 61 6d 65 | 00 00 00 00 00 01 00 0e |ion Name|........|
|00005b10| 00 57 68 65 6e 20 43 6f | 6e 64 69 74 69 6f 6e 00 |.When Co|ndition.|
|00005b20| 00 00 00 00 01 00 0c 00 | 54 72 69 67 67 65 72 20 |........|Trigger |
|00005b30| 42 6f 64 79 00 00 00 00 | 00 02 00 18 00 54 72 69 |Body....|.....Tri|
|00005b40| 67 67 65 72 20 45 66 66 | 65 63 74 65 64 20 43 6f |gger Eff|ected Co|
|00005b50| 6c 75 6d 6e 73 00 00 00 | 00 00 01 00 00 00 00 00 |lumns...|........|
|00005b60| 09 00 09 00 1c 02 c0 01 | 9c 03 07 06 3f 1b a7 e9 |........|....?...|
|00005b70| 06 00 43 49 33 30 32 50 | 46 4d 00 01 00 00 00 00 |..CI302P|FM......|
|00005b80| 00 00 00 00 00 08 00 43 | 49 33 30 32 50 46 4d 00 |.......C|I302PFM.|
|00005b90| 00 1a 00 07 00 43 4f 4d | 50 5f 43 44 08 00 43 48 |.....COM|P_CD..CH|
|00005ba0| 41 52 28 31 38 29 01 00 | 00 00 02 00 2e 35 00 00 |AR(18)..|.....5..|
|00005bb0| 07 00 43 4f 4d 50 5f 43 | 44 00 00 00 00 00 00 00 |..COMP_C|D.......|
|00005bc0| 00 ff ff ff ff 00 00 ff | ff ff ff 01 00 07 00 43 |........|.......C|
|00005bd0| 4d 50 5f 54 59 50 08 00 | 43 48 41 52 28 31 38 29 |MP_TYP..|CHAR(18)|
|00005be0| 01 00 00 00 02 00 2e 36 | 00 00 07 00 43 4d 50 5f |.......6|....CMP_|
|00005bf0| 54 59 50 00 00 00 00 00 | 00 00 00 ff ff ff ff 00 |TYP.....|........|
|00005c00| 00 ff ff ff ff 2c 00 05 | 00 4d 4f 44 45 4c 08 00 |.....,..|.MODEL..|
|00005c10| 43 48 41 52 28 31 38 29 | 00 00 64 00 00 00 00 00 |CHAR(18)|..d.....|
|00005c20| 05 00 4d 4f 44 45 4c 00 | 00 00 00 00 00 00 00 ff |..MODEL.|........|
|00005c30| ff ff ff 00 00 ff ff ff | ff 2d 00 08 00 50 55 52 |........|.-...PUR|
|00005c40| 5f 59 45 41 52 08 00 43 | 48 41 52 28 31 38 29 00 |_YEAR..C|HAR(18).|
|00005c50| 00 64 00 00 00 00 00 08 | 00 50 55 52 5f 59 45 41 |.d......|.PUR_YEA|
|00005c60| 52 00 00 00 00 00 00 00 | 00 ff ff ff ff 00 00 ff |R.......|........|
|00005c70| ff ff ff 2e 00 08 00 53 | 50 45 43 49 46 49 43 08 |.......S|PECIFIC.|
|00005c80| 00 43 48 41 52 28 31 38 | 29 00 00 64 00 00 00 00 |.CHAR(18|)..d....|
|00005c90| 00 08 00 53 50 45 43 49 | 46 49 43 00 00 00 00 00 |...SPECI|FIC.....|
|00005ca0| 00 00 00 ff ff ff ff 00 | 00 ff ff ff ff 2f 00 06 |........|...../..|
|00005cb0| 00 4d 45 4d 4f 52 59 08 | 00 43 48 41 52 28 31 38 |.MEMORY.|.CHAR(18|
|00005cc0| 29 00 00 64 00 00 00 00 | 00 06 00 4d 45 4d 4f 52 |)..d....|...MEMOR|
|00005cd0| 59 00 00 00 00 00 00 00 | 00 ff ff ff ff 00 00 ff |Y.......|........|
|00005ce0| ff ff ff 30 00 06 00 48 | 5f 44 49 53 4b 08 00 43 |...0...H|_DISK..C|
|00005cf0| 48 41 52 28 31 38 29 00 | 00 64 00 00 00 00 00 06 |HAR(18).|.d......|
|00005d00| 00 48 5f 44 49 53 4b 00 | 00 00 00 00 00 00 00 ff |.H_DISK.|........|
|00005d10| ff ff ff 00 00 ff ff ff | ff 31 00 04 00 54 45 52 |........|.1...TER|
|00005d20| 4d 08 00 43 48 41 52 28 | 31 38 29 00 00 64 00 00 |M..CHAR(|18)..d..|
|00005d30| 00 00 00 04 00 54 45 52 | 4d 00 00 00 00 00 00 00 |.....TER|M.......|
|00005d40| 00 ff ff ff ff 00 00 ff | ff ff ff 32 00 08 00 50 |........|...2...P|
|00005d50| 52 49 4e 54 45 52 53 08 | 00 43 48 41 52 28 31 38 |RINTERS.|.CHAR(18|
|00005d60| 29 00 00 64 00 00 00 00 | 00 08 00 50 52 49 4e 54 |)..d....|...PRINT|
|00005d70| 45 52 53 00 00 00 00 00 | 00 00 00 ff ff ff ff 00 |ERS.....|........|
|00005d80| 00 ff ff ff ff 33 00 08 | 00 50 4c 4f 54 54 45 52 |.....3..|.PLOTTER|
|00005d90| 53 08 00 43 48 41 52 28 | 31 38 29 00 00 64 00 00 |S..CHAR(|18)..d..|
|00005da0| 00 00 00 08 00 50 4c 4f | 54 54 45 52 53 00 00 00 |.....PLO|TTERS...|
|00005db0| 00 00 00 00 00 ff ff ff | ff 00 00 ff ff ff ff 34 |........|.......4|
|00005dc0| 00 08 00 44 49 53 4b 5f | 44 52 56 08 00 43 48 41 |...DISK_|DRV..CHA|
|00005dd0| 52 28 31 38 29 00 00 64 | 00 00 00 00 00 08 00 44 |R(18)..d|.......D|
|00005de0| 49 53 4b 5f 44 52 56 00 | 00 00 00 00 00 00 00 ff |ISK_DRV.|........|
|00005df0| ff ff ff 00 00 ff ff ff | ff 35 00 08 00 54 41 50 |........|.5...TAP|
|00005e00| 45 5f 44 52 56 08 00 43 | 48 41 52 28 31 38 29 00 |E_DRV..C|HAR(18).|
|00005e10| 00 64 00 00 00 00 00 08 | 00 54 41 50 45 5f 44 52 |.d......|.TAPE_DR|
|00005e20| 56 00 00 00 00 00 00 00 | 00 ff ff ff ff 00 00 ff |V.......|........|
|00005e30| ff ff ff 36 00 04 00 43 | 4f 4d 4d 08 00 43 48 41 |...6...C|OMM..CHA|
|00005e40| 52 28 31 38 29 00 00 64 | 00 00 00 00 00 04 00 43 |R(18)..d|.......C|
|00005e50| 4f 4d 4d 00 00 00 00 00 | 00 00 00 ff ff ff ff 00 |OMM.....|........|
|00005e60| 00 ff ff ff ff 37 00 09 | 00 4e 4f 5f 4f 46 5f 50 |.....7..|.NO_OF_P|
|00005e70| 43 53 08 00 43 48 41 52 | 28 31 38 29 00 00 64 00 |CS..CHAR|(18)..d.|
|00005e80| 00 00 00 00 09 00 4e 4f | 5f 4f 46 5f 50 43 53 00 |......NO|_OF_PCS.|
|00005e90| 00 00 00 00 00 00 00 ff | ff ff ff 00 00 ff ff ff |........|........|
|00005ea0| ff 38 00 09 00 50 52 4f | 43 45 53 53 4f 52 08 00 |.8...PRO|CESSOR..|
|00005eb0| 43 48 41 52 28 31 38 29 | 00 00 64 00 00 00 00 00 |CHAR(18)|..d.....|
|00005ec0| 09 00 50 52 4f 43 45 53 | 53 4f 52 00 00 00 00 00 |..PROCES|SOR.....|
|00005ed0| 00 00 00 ff ff ff ff 00 | 00 ff ff ff ff 39 00 05 |........|.....9..|
|00005ee0| 00 55 4e 49 54 53 08 00 | 43 48 41 52 28 31 38 29 |.UNITS..|CHAR(18)|
|00005ef0| 00 00 64 00 00 00 00 00 | 05 00 55 4e 49 54 53 00 |..d.....|..UNITS.|
|00005f00| 00 00 00 00 00 00 00 ff | ff ff ff 00 00 ff ff ff |........|........|
|00005f10| ff 00 00 0c 00 01 00 04 | 00 41 4b 49 44 06 00 00 |........|.AKID...|
|00005f20| 00 00 01 00 0a 00 49 6e | 64 65 78 20 4e 61 6d 65 |......In|dex Name|
|00005f30| 20 00 00 00 00 00 00 05 | 00 23 43 6f 6c 73 06 00 | .......|.#Cols..|
|00005f40| 00 00 00 01 00 06 00 55 | 6e 69 71 75 65 08 00 00 |.......U|nique...|
|00005f50| 00 00 00 00 07 00 62 44 | 65 6c 65 74 65 00 00 00 |......bD|elete...|
|00005f60| 00 00 01 00 07 00 4b 65 | 79 45 78 70 72 00 00 03 |......Ke|yExpr...|
|00005f70| 00 0a 0d 20 00 01 00 08 | 00 41 53 43 2f 44 45 53 |... ....|.ASC/DES|
|00005f80| 43 05 00 00 00 00 01 00 | 03 00 4d 44 58 06 00 00 |C.......|..MDX...|
|00005f90| 00 00 01 00 05 00 46 4e | 41 4d 45 0c 00 00 00 00 |......FN|AME.....|
|00005fa0| 01 00 03 00 46 4f 52 00 | 00 00 00 00 00 00 09 00 |....FOR.|........|
|00005fb0| 43 6c 75 73 74 65 72 65 | 64 06 00 00 00 00 02 00 |Clustere|d.......|
|00005fc0| 09 00 50 68 79 73 20 50 | 72 6f 70 00 00 00 00 00 |..Phys P|rop.....|
|00005fd0| 01 00 0c 00 02 00 50 4b | 0b 00 58 50 4b 43 49 33 |......PK|..XPKCI3|
|00005fe0| 30 32 50 46 4d 02 00 03 | 00 59 45 53 00 00 00 00 |02PFM...|.YES....|
|00005ff0| 00 00 00 00 00 00 00 00 | 01 00 02 00 01 00 0e 00 |........|........|
|00006000| 50 48 59 53 20 50 52 4f | 50 20 4e 41 4d 45 00 00 |PHYS PRO|P NAME..|
|00006010| 00 00 00 01 00 0f 00 50 | 48 59 53 20 50 52 4f 50 |.......P|HYS PROP|
|00006020| 20 56 41 4c 55 45 00 00 | 00 00 00 00 00 07 00 01 | VALUE..|........|
|00006030| 00 04 00 41 4b 49 44 00 | 00 00 00 00 02 00 03 00 |...AKID.|........|
|00006040| 68 45 41 00 00 00 00 00 | 01 00 08 00 41 74 74 20 |hEA.....|....Att |
|00006050| 4e 61 6d 65 20 00 00 00 | 00 01 00 08 00 41 53 43 |Name ...|.....ASC|
|00006060| 2f 44 45 53 43 20 00 00 | 00 00 00 00 08 00 50 6f |/DESC ..|......Po|
|00006070| 73 69 74 69 6f 6e 06 00 | 00 00 00 00 00 07 00 62 |sition..|.......b|
|00006080| 44 65 6c 65 74 65 00 00 | 00 00 00 02 00 05 00 50 |Delete..|.......P|
|00006090| 52 4f 50 53 00 00 00 00 | 00 02 00 07 00 02 00 50 |ROPS....|.......P|
|000060a0| 4b 00 00 07 00 43 4f 4d | 50 5f 43 44 03 00 41 53 |K....COM|P_CD..AS|
|000060b0| 43 01 00 00 00 01 00 01 | 00 04 00 50 52 4f 50 0a |C.......|...PROP.|
|000060c0| 00 00 00 00 00 00 07 00 | 02 00 50 4b 01 00 07 00 |........|..PK....|
|000060d0| 43 4d 50 5f 54 59 50 03 | 00 41 53 43 02 00 00 00 |CMP_TYP.|.ASC....|
|000060e0| 01 00 01 00 04 00 50 52 | 4f 50 0a 00 00 00 00 00 |......PR|OP......|
|000060f0| 00 08 00 01 00 03 00 45 | 50 50 00 00 00 00 00 00 |.......E|PP......|
|00006100| 00 04 00 44 42 4d 53 00 | 00 00 00 00 01 00 02 00 |...DBMS.|........|
|00006110| 50 56 00 00 00 00 00 00 | 00 05 00 45 50 50 49 44 |PV......|...EPPID|
|00006120| 00 00 00 00 00 00 00 04 | 00 50 56 49 44 00 00 00 |........|.PVID...|
|00006130| 00 00 00 00 04 00 54 59 | 50 45 00 00 00 00 00 00 |......TY|PE......|
|00006140| 00 05 00 4f 52 44 45 52 | 00 00 00 00 00 00 00 04 |...ORDER|........|
|00006150| 00 53 50 45 43 00 00 00 | 00 00 00 00 00 00 00 00 |.SPEC...|........|
|00006160| 0a 00 01 00 0c 00 54 72 | 69 67 67 65 72 20 4e 61 |......Tr|igger Na|
|00006170| 6d 65 00 00 00 00 00 00 | 00 0c 00 54 72 69 67 67 |me......|...Trigg|
|00006180| 65 72 20 54 79 70 65 00 | 00 00 00 00 00 00 10 00 |er Type.|........|
|00006190| 54 72 69 67 67 65 72 20 | 44 69 73 61 62 6c 65 64 |Trigger |Disabled|
|000061a0| 00 00 00 00 00 00 00 13 | 00 54 72 69 67 67 65 72 |........|.Trigger|
|000061b0| 20 46 69 72 65 20 4f 70 | 74 69 6f 6e 00 00 00 00 | Fire Op|tion....|
|000061c0| 00 00 00 0d 00 54 72 69 | 67 67 65 72 20 53 63 6f |.....Tri|gger Sco|
|000061d0| 70 65 00 00 00 00 00 01 | 00 14 00 4f 6c 64 20 43 |pe......|...Old C|
|000061e0| 6f 72 72 65 6c 61 74 69 | 6f 6e 20 4e 61 6d 65 00 |orrelati|on Name.|
|000061f0| 00 00 00 00 01 00 14 00 | 4e 65 77 20 43 6f 72 72 |........|New Corr|
|00006200| 65 6c 61 74 69 6f 6e 20 | 4e 61 6d 65 00 00 00 00 |elation |Name....|
|00006210| 00 01 00 0e 00 57 68 65 | 6e 20 43 6f 6e 64 69 74 |.....Whe|n Condit|
|00006220| 69 6f 6e 00 00 00 00 00 | 01 00 0c 00 54 72 69 67 |ion.....|....Trig|
|00006230| 67 65 72 20 42 6f 64 79 | 00 00 00 00 00 02 00 18 |ger Body|........|
|00006240| 00 54 72 69 67 67 65 72 | 20 45 66 66 65 63 74 65 |.Trigger| Effecte|
|00006250| 64 20 43 6f 6c 75 6d 6e | 73 00 00 00 00 00 01 00 |d Column|s.......|
|00006260| 00 00 00 00 09 00 08 00 | 08 04 9c 05 08 06 e3 09 |........|........|
|00006270| 3f 1b a7 e9 01 00 43 49 | 33 30 31 43 4d 50 00 01 |?.....CI|301CMP..|
|00006280| 00 00 00 00 00 00 00 00 | 00 08 00 43 49 33 30 31 |........|...CI301|
|00006290| 43 4d 50 00 00 1a 00 07 | 00 43 4f 4d 50 5f 43 44 |CMP.....|.COMP_CD|
|000062a0| 08 00 43 48 41 52 28 31 | 38 29 01 00 00 00 00 00 |..CHAR(1|8)......|
|000062b0| 00 00 07 00 43 4f 4d 50 | 5f 43 44 00 00 00 00 00 |....COMP|_CD.....|
|000062c0| 00 00 00 00 00 ff ff 00 | 00 ff ff ff ff 1b 00 07 |........|........|
|000062d0| 00 43 4f 4d 50 5f 4e 4d | 08 00 43 48 41 52 28 31 |.COMP_NM|..CHAR(1|
|000062e0| 38 29 00 00 64 00 00 00 | 00 00 07 00 43 4f 4d 50 |8)..d...|....COMP|
|000062f0| 5f 4e 4d 00 00 00 00 00 | 00 00 00 02 00 ff ff 00 |_NM.....|........|
|00006300| 00 ff ff ff ff 1c 00 09 | 00 43 4f 4d 50 5f 41 44 |........|.COMP_AD|
|00006310| 44 31 08 00 43 48 41 52 | 28 31 38 29 00 00 64 00 |D1..CHAR|(18)..d.|
|00006320| 00 00 00 00 09 00 43 4f | 4d 50 5f 41 44 44 31 00 |......CO|MP_ADD1.|
|00006330| 00 00 00 00 00 00 00 03 | 00 ff ff 00 00 ff ff ff |........|........|
|00006340| ff 1d 00 09 00 43 4f 4d | 50 5f 41 44 44 32 08 00 |.....COM|P_ADD2..|
|00006350| 43 48 41 52 28 31 38 29 | 00 00 64 00 00 00 00 00 |CHAR(18)|..d.....|
|00006360| 09 00 43 4f 4d 50 5f 41 | 44 44 32 00 00 00 00 00 |..COMP_A|DD2.....|
|00006370| 00 00 00 04 00 ff ff 00 | 00 ff ff ff ff 1e 00 04 |........|........|
|00006380| 00 43 49 54 59 08 00 43 | 48 41 52 28 31 38 29 00 |.CITY..C|HAR(18).|
|00006390| 00 64 00 00 00 00 00 04 | 00 43 49 54 59 00 00 00 |.d......|.CITY...|
|000063a0| 00 00 00 00 00 05 00 ff | ff 00 00 ff ff ff ff 1f |........|........|
|000063b0| 00 0b 00 4d 44 5f 43 48 | 41 49 52 4d 41 4e 08 00 |...MD_CH|AIRMAN..|
|000063c0| 43 48 41 52 28 31 38 29 | 00 00 64 00 00 00 00 00 |CHAR(18)|..d.....|
|000063d0| 0b 00 4d 44 5f 43 48 41 | 49 52 4d 41 4e 00 00 00 |..MD_CHA|IRMAN...|
|000063e0| 00 00 00 00 00 06 00 ff | ff 00 00 ff ff ff ff 20 |........|....... |
|000063f0| 00 0e 00 4d 44 5f 43 48 | 52 4d 41 4e 5f 44 45 53 |...MD_CH|RMAN_DES|
+--------+-------------------------+-------------------------+--------+--------+
Only 25.0 KB of data is shown above.
