home *** CD-ROM | disk | FTP | other *** search
| AllFusion ERwin data | 1998-01-28 | 397.4 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: 'V2.41 ERwi'
| default (weak)
|
|
hex view+--------+-------------------------+-------------------------+--------+--------+
|00000000| 56 32 2e 34 31 20 45 52 | 77 69 00 00 00 00 ac c2 |V2.41 ER|wi......|
|00000010| 00 00 b6 c2 00 00 01 00 | 00 00 01 00 00 00 00 00 |........|........|
|00000020| 00 00 01 00 00 00 01 00 | 00 00 07 00 00 00 07 00 |........|........|
|00000030| 00 00 01 00 00 00 00 00 | 00 00 00 00 00 00 01 00 |........|........|
|00000040| 00 00 00 00 00 00 00 00 | 00 00 15 00 01 00 00 00 |........|........|
|00000050| 01 00 00 00 01 00 00 00 | ae 00 00 00 59 1b 00 00 |........|....Y...|
|00000060| 00 00 00 00 18 00 00 00 | 09 00 00 00 00 00 00 00 |........|........|
|00000070| 00 00 00 00 07 00 00 00 | 01 00 00 00 00 00 00 00 |........|........|
|00000080| 00 00 00 00 02 f0 40 00 | 32 00 00 00 28 c3 00 00 |......@.|2...(...|
|00000090| 14 00 00 00 b0 c2 00 00 | 28 00 00 00 01 00 00 00 |........|(.......|
|000000a0| 0b 00 08 00 43 48 41 52 | 28 31 38 29 00 00 00 00 |....CHAR|(18)....|
|000000b0| 00 00 00 00 00 00 13 00 | 58 25 4b 65 79 54 79 70 |........|X%KeyTyp|
|000000c0| 65 25 54 61 62 6c 65 4e | 61 6d 65 00 00 00 00 0d |e%TableN|ame.....|
|000000d0| 00 25 45 6e 74 69 74 79 | 4e 61 6d 65 28 29 00 00 |.%Entity|Name()..|
|000000e0| 00 00 00 00 01 00 02 00 | 00 00 00 00 07 00 4e 6f |........|......No|
|000000f0| 74 65 20 49 44 ff ff 00 | 00 00 01 00 09 00 4e 6f |te ID...|......No|
|00000100| 74 65 20 54 65 78 74 ff | ff 00 00 00 00 00 00 00 |te Text.|........|
|00000110| 0c 00 00 00 01 00 00 00 | 19 00 00 00 00 01 00 00 |........|........|
|00000120| 00 1a 00 00 00 00 01 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000130| 00 00 00 00 00 00 00 00 | 00 00 00 00 14 00 00 00 |........|........|
|00000140| 00 02 00 00 00 1a 00 00 | 00 00 02 00 00 00 00 00 |........|........|
|00000150| 00 00 00 04 00 00 00 00 | 00 00 00 00 01 00 00 00 |........|........|
|00000160| 00 00 00 00 00 01 00 00 | 00 00 00 00 00 00 01 00 |........|........|
|00000170| 00 00 00 00 00 00 00 02 | 00 00 00 00 00 00 00 00 |........|........|
|00000180| 25 00 00 00 0c 00 00 00 | 17 00 44 4d 4e 5f 44 49 |%.......|..DMN_DI|
|00000190| 41 47 52 41 4d 5f 4f 50 | 54 49 4f 4e 5f 4e 41 4d |AGRAM_OP|TION_NAM|
|000001a0| 45 00 00 05 00 00 00 01 | 00 00 00 0f 00 00 00 00 |E.......|........|
|000001b0| 01 00 00 00 64 00 00 00 | 00 01 00 00 00 0f 00 00 |....d...|........|
|000001c0| 00 00 04 00 00 00 00 00 | 00 00 00 02 00 00 00 00 |........|........|
|000001d0| 00 00 00 00 42 00 00 00 | 05 00 00 00 06 00 44 4f |....B...|......DO|
|000001e0| 5f 41 43 44 00 00 00 00 | 00 00 00 00 00 00 00 00 |_ACD....|........|
|000001f0| 05 00 00 00 06 00 44 4f | 5f 41 43 49 00 00 00 00 |......DO|_ACI....|
|00000200| 00 00 00 00 00 00 00 00 | 05 00 00 00 06 00 44 4f |........|......DO|
|00000210| 5f 41 43 55 00 00 00 00 | 00 00 00 00 00 00 00 00 |_ACU....|........|
|00000220| 05 00 00 00 05 00 44 4f | 5f 41 4b 00 00 00 00 00 |......DO|_AK.....|
|00000230| 00 00 00 00 00 00 00 05 | 00 00 00 05 00 44 4f 5f |........|.....DO_|
|00000240| 41 49 00 00 00 00 00 00 | 00 00 00 00 00 00 05 00 |AI......|........|
|00000250| 00 00 06 00 44 4f 5f 41 | 50 44 00 00 00 00 00 00 |....DO_A|PD......|
|00000260| 00 00 00 00 00 00 05 00 | 00 00 06 00 44 4f 5f 41 |........|....DO_A|
|00000270| 50 49 00 00 00 00 00 00 | 00 00 00 00 00 00 05 00 |PI......|........|
|00000280| 00 00 06 00 44 4f 5f 41 | 50 55 00 00 00 00 00 00 |....DO_A|PU......|
|00000290| 00 00 00 00 00 00 05 00 | 00 00 05 00 44 4f 5f 41 |........|....DO_A|
|000002a0| 52 00 00 00 00 00 00 00 | 00 00 00 00 00 05 00 00 |R.......|........|
|000002b0| 00 05 00 44 4f 5f 43 50 | 00 00 00 00 00 00 00 00 |...DO_CP|........|
|000002c0| 00 00 00 00 05 00 00 00 | 05 00 44 4f 5f 44 44 00 |........|..DO_DD.|
|000002d0| 00 00 00 00 00 00 00 00 | 00 00 00 05 00 00 00 05 |........|........|
|000002e0| 00 44 4f 5f 44 4c 00 00 | 00 00 00 00 00 00 00 00 |.DO_DL..|........|
|000002f0| 00 00 05 00 00 00 05 00 | 44 4f 5f 44 4e 00 00 00 |........|DO_DN...|
|00000300| 00 00 00 00 00 00 00 00 | 00 05 00 00 00 05 00 44 |........|.......D|
|00000310| 4f 5f 45 45 00 00 00 00 | 00 00 00 00 00 00 00 00 |O_EE....|........|
|00000320| 05 00 00 00 05 00 44 4f | 5f 45 48 00 00 00 00 00 |......DO|_EH.....|
|00000330| 00 00 00 00 00 00 00 05 | 00 00 00 05 00 44 4f 5f |........|.....DO_|
|00000340| 45 57 00 00 00 00 00 00 | 00 00 00 00 00 00 05 00 |EW......|........|
|00000350| 00 00 05 00 44 4f 5f 46 | 43 00 00 00 00 00 00 00 |....DO_F|C.......|
|00000360| 00 00 00 00 00 05 00 00 | 00 05 00 44 4f 5f 46 45 |........|...DO_FE|
|00000370| 00 00 00 00 00 00 00 00 | 00 00 00 00 05 00 00 00 |........|........|
|00000380| 05 00 44 4f 5f 46 47 00 | 00 00 00 00 00 00 00 00 |..DO_FG.|........|
|00000390| 00 00 00 05 00 00 00 05 | 00 44 4f 5f 46 48 00 00 |........|.DO_FH..|
|000003a0| 00 00 00 00 00 00 00 00 | 00 00 05 00 00 00 05 00 |........|........|
|000003b0| 44 4f 5f 46 49 00 00 00 | 00 00 00 00 00 00 00 00 |DO_FI...|........|
|000003c0| 00 05 00 00 00 05 00 44 | 4f 5f 46 4b 00 00 00 00 |.......D|O_FK....|
|000003d0| 00 00 00 00 00 00 00 00 | 05 00 00 00 05 00 44 4f |........|......DO|
|000003e0| 5f 46 4e 00 00 00 00 00 | 00 00 00 00 00 00 00 05 |_FN.....|........|
|000003f0| 00 00 00 05 00 44 4f 5f | 46 4f 00 00 00 00 00 00 |.....DO_|FO......|
|00000400| 00 00 00 00 00 00 05 00 | 00 00 05 00 44 4f 5f 46 |........|....DO_F|
|00000410| 50 00 00 00 00 00 00 00 | 00 00 00 00 00 05 00 00 |P.......|........|
|00000420| 00 05 00 44 4f 5f 46 51 | 00 00 00 00 00 00 00 00 |...DO_FQ|........|
|00000430| 00 00 00 00 05 00 00 00 | 05 00 44 4f 5f 46 53 00 |........|..DO_FS.|
|00000440| 00 00 00 00 00 00 00 00 | 00 00 00 05 00 00 00 05 |........|........|
|00000450| 00 44 4f 5f 46 55 00 00 | 00 00 00 00 00 00 00 00 |.DO_FU..|........|
|00000460| 00 00 05 00 00 00 05 00 | 44 4f 5f 46 57 00 00 00 |........|DO_FW...|
|00000470| 00 00 00 00 00 00 00 00 | 00 05 00 00 00 06 00 44 |........|.......D|
|00000480| 4f 5f 49 43 44 00 00 00 | 00 00 00 00 00 00 00 00 |O_ICD...|........|
|00000490| 00 05 00 00 00 06 00 44 | 4f 5f 49 43 49 00 00 00 |.......D|O_ICI...|
|000004a0| 00 00 00 00 00 00 00 00 | 00 05 00 00 00 06 00 44 |........|.......D|
|000004b0| 4f 5f 49 43 55 00 00 00 | 00 00 00 00 00 00 00 00 |O_ICU...|........|
|000004c0| 00 05 00 00 00 06 00 44 | 4f 5f 49 50 44 00 00 00 |.......D|O_IPD...|
|000004d0| 00 00 00 00 00 00 00 00 | 00 05 00 00 00 06 00 44 |........|.......D|
|000004e0| 4f 5f 49 50 49 00 00 00 | 00 00 00 00 00 00 00 00 |O_IPI...|........|
|000004f0| 00 05 00 00 00 06 00 44 | 4f 5f 49 50 55 00 00 00 |.......D|O_IPU...|
|00000500| 00 00 00 00 00 00 00 00 | 00 05 00 00 00 05 00 44 |........|.......D|
|00000510| 4f 5f 4c 47 00 00 00 00 | 00 00 00 00 00 00 00 00 |O_LG....|........|
|00000520| 05 00 00 00 06 00 44 4f | 5f 4e 43 44 00 00 00 00 |......DO|_NCD....|
|00000530| 00 00 00 00 00 00 00 00 | 05 00 00 00 06 00 44 4f |........|......DO|
|00000540| 5f 4e 43 49 00 00 00 00 | 00 00 00 00 00 00 00 00 |_NCI....|........|
|00000550| 05 00 00 00 06 00 44 4f | 5f 4e 43 55 00 00 00 00 |......DO|_NCU....|
|00000560| 00 00 00 00 00 00 00 00 | 05 00 00 00 05 00 44 4f |........|......DO|
|00000570| 5f 4e 4e 00 00 00 00 00 | 00 00 00 00 00 00 00 05 |_NN.....|........|
|00000580| 00 00 00 06 00 44 4f 5f | 4e 50 44 00 00 00 00 00 |.....DO_|NPD.....|
|00000590| 00 00 00 00 00 00 00 05 | 00 00 00 06 00 44 4f 5f |........|.....DO_|
|000005a0| 4e 50 49 00 00 00 00 00 | 00 00 00 00 00 00 00 05 |NPI.....|........|
|000005b0| 00 00 00 06 00 44 4f 5f | 4e 50 55 00 00 00 00 00 |.....DO_|NPU.....|
|000005c0| 00 00 00 00 00 00 00 05 | 00 00 00 05 00 44 4f 5f |........|.....DO_|
|000005d0| 4f 50 00 00 00 00 00 00 | 00 00 00 00 00 00 05 00 |OP......|........|
|000005e0| 00 00 05 00 44 4f 5f 50 | 46 00 00 00 00 00 00 00 |....DO_P|F.......|
|000005f0| 00 00 00 00 00 05 00 00 | 00 05 00 44 4f 5f 50 47 |........|...DO_PG|
|00000600| 00 00 00 00 00 00 00 00 | 00 00 00 00 05 00 00 00 |........|........|
|00000610| 05 00 44 4f 5f 52 43 00 | 00 00 00 00 00 00 00 00 |..DO_RC.|........|
|00000620| 00 00 00 05 00 00 00 05 | 00 44 4f 5f 52 45 00 00 |........|.DO_RE..|
|00000630| 00 00 00 00 00 00 00 00 | 00 00 05 00 00 00 05 00 |........|........|
|00000640| 44 4f 5f 52 56 00 00 00 | 00 00 00 00 00 00 00 00 |DO_RV...|........|
|00000650| 00 05 00 00 00 06 00 44 | 4f 5f 53 43 44 00 00 00 |.......D|O_SCD...|
|00000660| 00 00 00 00 00 00 00 00 | 00 05 00 00 00 06 00 44 |........|.......D|
|00000670| 4f 5f 53 43 49 00 00 00 | 00 00 00 00 00 00 00 00 |O_SCI...|........|
|00000680| 00 05 00 00 00 06 00 44 | 4f 5f 53 43 55 00 00 00 |.......D|O_SCU...|
|00000690| 00 00 00 00 00 00 00 00 | 00 05 00 00 00 05 00 44 |........|.......D|
|000006a0| 4f 5f 53 44 00 00 00 00 | 00 00 00 00 00 00 00 00 |O_SD....|........|
|000006b0| 05 00 00 00 06 00 44 4f | 5f 53 50 44 00 00 00 00 |......DO|_SPD....|
|000006c0| 00 00 00 00 00 00 00 00 | 05 00 00 00 06 00 44 4f |........|......DO|
|000006d0| 5f 53 50 49 00 00 00 00 | 00 00 00 00 00 00 00 00 |_SPI....|........|
|000006e0| 05 00 00 00 06 00 44 4f | 5f 53 50 55 00 00 00 00 |......DO|_SPU....|
|000006f0| 00 00 00 00 00 00 00 00 | 05 00 00 00 05 00 44 4f |........|......DO|
|00000700| 5f 53 54 00 00 00 00 00 | 00 00 00 00 00 00 00 05 |_ST.....|........|
|00000710| 00 00 00 05 00 44 4f 5f | 54 44 00 00 00 00 00 00 |.....DO_|TD......|
|00000720| 00 00 00 00 00 00 05 00 | 00 00 05 00 44 4f 5f 55 |........|....DO_U|
|00000730| 4e 00 00 00 00 00 00 00 | 00 00 00 00 00 05 00 00 |N.......|........|
|00000740| 00 05 00 44 4f 5f 56 57 | 00 00 00 00 00 00 00 00 |...DO_VW|........|
|00000750| 00 00 00 00 05 00 00 00 | 05 00 44 4f 5f 58 4c 00 |........|..DO_XL.|
|00000760| 00 00 00 00 00 00 00 00 | 00 00 00 05 00 00 00 05 |........|........|
|00000770| 00 44 4f 5f 59 4c 00 00 | 00 00 00 00 00 00 00 00 |.DO_YL..|........|
|00000780| 00 00 05 00 00 00 06 00 | 44 4f 5f 45 49 44 00 00 |........|DO_EID..|
|00000790| 00 00 00 00 00 00 00 00 | 00 00 05 00 00 00 06 00 |........|........|
|000007a0| 44 4f 5f 41 49 44 00 00 | 00 00 00 00 00 00 00 00 |DO_AID..|........|
|000007b0| 00 00 05 00 00 00 06 00 | 44 4f 5f 52 49 44 00 00 |........|DO_RID..|
|000007c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000007d0| 00 00 01 00 00 00 01 00 | 00 00 00 00 00 00 00 00 |........|........|
|000007e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000007f0| 00 00 00 00 0c 00 00 00 | 12 00 56 4c 44 5f 41 54 |........|..VLD_AT|
|00000800| 54 52 49 42 55 54 45 5f | 54 59 50 45 00 00 05 00 |TRIBUTE_|TYPE....|
|00000810| 00 00 01 00 00 00 0f 00 | 00 00 00 01 00 00 00 64 |........|.......d|
|00000820| 00 00 00 00 01 00 00 00 | 0f 00 00 00 00 04 00 00 |........|........|
|00000830| 00 00 00 00 00 00 02 00 | 00 00 00 00 00 00 00 02 |........|........|
|00000840| 00 00 00 05 00 00 00 07 | 00 27 41 54 5f 50 4b 27 |........|.'AT_PK'|
|00000850| 16 00 50 72 69 6d 61 72 | 79 20 6b 65 79 20 61 74 |..Primar|y key at|
|00000860| 74 72 69 62 75 74 65 2e | 00 00 00 00 00 00 00 00 |tribute.|........|
|00000870| 00 00 05 00 00 00 07 00 | 27 41 54 5f 4e 4b 27 12 |........|'AT_NK'.|
|00000880| 00 4e 6f 6e 2d 6b 65 79 | 20 61 74 74 72 69 62 75 |.Non-key| attribu|
|00000890| 74 65 2e 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |te......|........|
|000008a0| 00 01 00 00 00 01 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000008b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000008c0| 00 00 00 0c 00 00 00 0f | 00 56 4c 44 5f 43 41 52 |........|.VLD_CAR|
|000008d0| 44 49 4e 41 4c 49 54 59 | 00 00 05 00 00 00 01 00 |DINALITY|........|
|000008e0| 00 00 0f 00 00 00 00 01 | 00 00 00 64 00 00 00 00 |........|...d....|
|000008f0| 01 00 00 00 0f 00 00 00 | 00 04 00 00 00 00 00 00 |........|........|
|00000900| 00 00 02 00 00 00 00 00 | 00 00 00 06 00 00 00 05 |........|........|
|00000910| 00 00 00 06 00 43 54 5f | 5a 4f 4d 11 00 5a 65 72 |.....CT_|ZOM..Zer|
|00000920| 6f 20 4f 6e 65 20 6f 72 | 20 4d 6f 72 65 2e 00 00 |o One or| More...|
|00000930| 00 00 00 00 00 00 00 00 | 05 00 00 00 05 00 43 54 |........|......CT|
|00000940| 5f 5a 4d 11 00 5a 65 72 | 6f 20 4f 6e 65 20 6f 72 |_ZM..Zer|o One or|
|00000950| 20 4d 6f 72 65 2e 00 00 | 00 00 00 00 00 00 00 00 | More...|........|
|00000960| 05 00 00 00 05 00 43 54 | 5f 5a 52 10 00 5a 65 72 |......CT|_ZR..Zer|
|00000970| 6f 20 6f 72 20 4f 6e 65 | 20 28 5a 29 2e 00 00 00 |o or One| (Z)....|
|00000980| 00 00 00 00 00 00 00 05 | 00 00 00 04 00 43 54 5f |........|.....CT_|
|00000990| 5a 10 00 5a 65 72 6f 20 | 6f 72 20 4f 6e 65 20 28 |Z..Zero |or One (|
|000009a0| 5a 29 2e 00 00 00 00 00 | 00 00 00 00 00 05 00 00 |Z)......|........|
|000009b0| 00 05 00 43 54 5f 50 52 | 10 00 4f 6e 65 20 6f 72 |...CT_PR|..One or|
|000009c0| 20 4d 6f 72 65 20 28 50 | 29 2e 00 00 00 00 00 00 | More (P|).......|
|000009d0| 00 00 00 00 05 00 00 00 | 04 00 43 54 5f 50 10 00 |........|..CT_P..|
|000009e0| 4f 6e 65 20 6f 72 20 4d | 6f 72 65 20 28 50 29 2e |One or M|ore (P).|
|000009f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 01 00 |........|........|
|00000a00| 00 00 01 00 00 00 00 00 | 50 00 00 00 00 00 00 00 |........|P.......|
|00000a10| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000a20| 0c 00 00 00 15 00 56 4c | 44 5f 43 48 49 4c 44 5f |......VL|D_CHILD_|
|00000a30| 44 45 4c 45 54 45 5f 52 | 55 4c 45 00 00 05 00 00 |DELETE_R|ULE.....|
|00000a40| 00 01 00 00 00 0f 00 00 | 00 00 01 00 00 00 64 00 |........|......d.|
|00000a50| 00 00 00 01 00 00 00 0f | 00 00 00 00 04 00 00 00 |........|........|
|00000a60| 00 00 00 00 00 02 00 00 | 00 00 00 00 00 00 04 00 |........|........|
|00000a70| 00 00 05 00 00 00 08 00 | 27 44 52 5f 43 52 45 27 |........|'DR_CRE'|
|00000a80| 15 00 43 68 69 6c 64 20 | 44 65 6c 65 74 65 20 52 |..Child |Delete R|
|00000a90| 65 73 74 72 69 63 74 00 | 00 00 00 00 00 00 00 00 |estrict.|........|
|00000aa0| 00 05 00 00 00 08 00 27 | 44 52 5f 43 43 41 27 14 |.......'|DR_CCA'.|
|00000ab0| 00 43 68 69 6c 64 20 44 | 65 6c 65 74 65 20 43 61 |.Child D|elete Ca|
|00000ac0| 73 63 61 64 65 00 00 00 | 00 00 00 00 00 00 00 05 |scade...|........|
|00000ad0| 00 00 00 08 00 27 44 52 | 5f 43 53 4e 27 15 00 43 |.....'DR|_CSN'..C|
|00000ae0| 68 69 6c 64 20 44 65 6c | 65 74 65 20 53 65 74 20 |hild Del|ete Set |
|00000af0| 4e 75 6c 6c 00 00 00 00 | 00 00 00 00 00 00 05 00 |Null....|........|
|00000b00| 00 00 08 00 27 44 52 5f | 43 53 44 27 18 00 43 68 |....'DR_|CSD'..Ch|
|00000b10| 69 6c 64 20 44 65 6c 65 | 74 65 20 53 65 74 20 44 |ild Dele|te Set D|
|00000b20| 65 66 61 75 6c 74 00 00 | 00 00 00 00 00 00 00 00 |efault..|........|
|00000b30| 00 00 00 00 01 00 00 00 | 01 00 00 00 00 00 00 00 |........|........|
|00000b40| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000b50| 00 00 00 00 00 00 0c 00 | 00 00 15 00 56 4c 44 5f |........|....VLD_|
|00000b60| 43 48 49 4c 44 5f 49 4e | 53 45 52 54 5f 52 55 4c |CHILD_IN|SERT_RUL|
|00000b70| 45 00 00 05 00 00 00 01 | 00 00 00 0f 00 00 00 00 |E.......|........|
|00000b80| 01 00 00 00 64 00 00 00 | 00 01 00 00 00 0f 00 00 |....d...|........|
|00000b90| 00 00 04 00 00 00 00 00 | 00 00 00 02 00 00 00 00 |........|........|
|00000ba0| 00 00 00 00 04 00 00 00 | 05 00 00 00 07 00 27 49 |........|......'I|
|00000bb0| 52 5f 52 45 27 15 00 43 | 68 69 6c 64 20 49 6e 73 |R_RE'..C|hild Ins|
|00000bc0| 65 72 74 20 52 65 73 74 | 72 69 63 74 00 00 00 00 |ert Rest|rict....|
|00000bd0| 00 00 00 00 00 00 05 00 | 00 00 07 00 27 49 52 5f |........|....'IR_|
|00000be0| 43 41 27 14 00 43 68 69 | 6c 64 20 49 6e 73 65 72 |CA'..Chi|ld Inser|
|00000bf0| 74 20 43 61 73 63 61 64 | 65 00 00 00 00 00 00 00 |t Cascad|e.......|
|00000c00| 00 00 00 05 00 00 00 07 | 00 27 49 52 5f 53 4e 27 |........|.'IR_SN'|
|00000c10| 15 00 43 68 69 6c 64 20 | 49 6e 73 65 72 74 20 53 |..Child |Insert S|
|00000c20| 65 74 20 4e 75 6c 6c 00 | 00 00 00 00 00 00 00 00 |et Null.|........|
|00000c30| 00 05 00 00 00 07 00 27 | 49 52 5f 53 44 27 18 00 |.......'|IR_SD'..|
|00000c40| 43 68 69 6c 64 20 49 6e | 73 65 72 74 20 53 65 74 |Child In|sert Set|
|00000c50| 20 44 65 66 61 75 6c 74 | 00 00 00 00 00 00 00 00 | Default|........|
|00000c60| 00 00 00 00 00 00 01 00 | 00 00 01 00 00 00 00 00 |........|........|
|00000c70| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000c80| 00 00 00 00 00 00 00 00 | 0c 00 00 00 15 00 56 4c |........|......VL|
|00000c90| 44 5f 43 48 49 4c 44 5f | 55 50 44 41 54 45 5f 52 |D_CHILD_|UPDATE_R|
|00000ca0| 55 4c 45 00 00 05 00 00 | 00 01 00 00 00 0f 00 00 |ULE.....|........|
|00000cb0| 00 00 01 00 00 00 64 00 | 00 00 00 01 00 00 00 0f |......d.|........|
|00000cc0| 00 00 00 00 04 00 00 00 | 00 00 00 00 00 02 00 00 |........|........|
|00000cd0| 00 00 00 00 00 00 04 00 | 00 00 05 00 00 00 08 00 |........|........|
|00000ce0| 27 55 52 5f 43 52 45 27 | 15 00 43 68 69 6c 64 20 |'UR_CRE'|..Child |
|00000cf0| 55 70 64 61 74 65 20 52 | 65 73 74 72 69 63 74 00 |Update R|estrict.|
|00000d00| 00 00 00 00 00 00 00 00 | 00 05 00 00 00 08 00 27 |........|.......'|
|00000d10| 55 52 5f 43 43 41 27 14 | 00 43 68 69 6c 64 20 55 |UR_CCA'.|.Child U|
|00000d20| 70 64 61 74 65 20 43 61 | 73 63 61 64 65 00 00 00 |pdate Ca|scade...|
|00000d30| 00 00 00 00 00 00 00 05 | 00 00 00 08 00 27 55 52 |........|.....'UR|
|00000d40| 5f 43 53 4e 27 15 00 43 | 68 69 6c 64 20 55 70 64 |_CSN'..C|hild Upd|
|00000d50| 61 74 65 20 53 65 74 20 | 4e 75 6c 6c 00 00 00 00 |ate Set |Null....|
|00000d60| 00 00 00 00 00 00 05 00 | 00 00 08 00 27 55 52 5f |........|....'UR_|
|00000d70| 43 53 44 27 18 00 43 68 | 69 6c 64 20 55 70 64 61 |CSD'..Ch|ild Upda|
|00000d80| 74 65 20 53 65 74 20 44 | 65 66 61 75 6c 74 00 00 |te Set D|efault..|
|00000d90| 00 00 00 00 00 00 00 00 | 00 00 00 00 01 00 00 00 |........|........|
|00000da0| 01 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000db0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 0c 00 |........|........|
|00000dc0| 00 00 0e 00 56 4c 44 5f | 43 4f 4c 4f 52 5f 54 59 |....VLD_|COLOR_TY|
|00000dd0| 50 45 00 00 05 00 00 00 | 01 00 00 00 0f 00 00 00 |PE......|........|
|00000de0| 00 01 00 00 00 64 00 00 | 00 00 01 00 00 00 0f 00 |.....d..|........|
|00000df0| 00 00 00 04 00 00 00 00 | 00 00 00 00 02 00 00 00 |........|........|
|00000e00| 00 00 00 00 00 01 00 00 | 00 05 00 00 00 08 00 27 |........|.......'|
|00000e10| 54 58 5f 43 4f 4c 27 0f | 00 43 6f 6c 6f 72 20 54 |TX_COL'.|.Color T|
|00000e20| 79 70 65 20 43 6f 64 65 | 00 00 00 00 00 00 00 00 |ype Code|........|
|00000e30| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000e40| 00 00 00 00 00 00 00 00 | 00 00 0c 00 00 00 0d 00 |........|........|
|00000e50| 56 4c 44 5f 44 46 4c 54 | 5f 54 59 50 45 00 00 05 |VLD_DFLT|_TYPE...|
|00000e60| 00 00 00 01 00 00 00 0f | 00 00 00 00 01 00 00 00 |........|........|
|00000e70| 64 00 00 00 00 01 00 00 | 00 0f 00 00 00 00 04 00 |d.......|........|
|00000e80| 00 00 00 00 00 00 00 02 | 00 00 00 00 00 00 00 00 |........|........|
|00000e90| 01 00 00 00 05 00 00 00 | 08 00 27 44 45 46 56 41 |........|..'DEFVA|
|00000ea0| 4c 27 1c 00 54 79 70 65 | 20 63 6f 64 65 20 66 6f |L'..Type| code fo|
|00000eb0| 72 20 45 52 57 49 4e 20 | 44 45 46 41 55 4c 54 2e |r ERWIN |DEFAULT.|
|00000ec0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000ed0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000ee0| 00 00 0c 00 00 00 0f 00 | 56 4c 44 5f 44 4f 4d 41 |........|VLD_DOMA|
|00000ef0| 49 4e 5f 54 59 50 45 00 | 00 05 00 00 00 01 00 00 |IN_TYPE.|........|
|00000f00| 00 0f 00 00 00 00 01 00 | 00 00 64 00 00 00 00 01 |........|..d.....|
|00000f10| 00 00 00 0f 00 00 00 00 | 04 00 00 00 00 00 00 00 |........|........|
|00000f20| 00 02 00 00 00 00 00 00 | 00 00 01 00 00 00 05 00 |........|........|
|00000f30| 00 00 08 00 27 44 4f 4d | 41 49 4e 27 19 00 54 79 |....'DOM|AIN'..Ty|
|00000f40| 70 65 20 63 6f 64 65 20 | 66 6f 72 20 43 2f 53 20 |pe code |for C/S |
|00000f50| 44 4f 4d 41 49 4e 2e 00 | 00 00 00 00 00 00 00 00 |DOMAIN..|........|
|00000f60| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000f70| 00 00 00 00 00 00 00 00 | 00 0c 00 00 00 11 00 56 |........|.......V|
|00000f80| 4c 44 5f 44 4f 4d 41 49 | 4e 50 56 5f 54 59 50 45 |LD_DOMAI|NPV_TYPE|
|00000f90| 00 00 05 00 00 00 01 00 | 00 00 0f 00 00 00 00 01 |........|........|
|00000fa0| 00 00 00 64 00 00 00 00 | 01 00 00 00 0f 00 00 00 |...d....|........|
|00000fb0| 00 04 00 00 00 00 00 00 | 00 00 02 00 00 00 00 00 |........|........|
|00000fc0| 00 00 00 15 00 00 00 05 | 00 00 00 06 00 43 44 5f |........|.....CD_|
|00000fd0| 4e 41 4d 15 00 41 74 74 | 72 69 62 75 74 65 20 46 |NAM..Att|ribute F|
|00000fe0| 69 65 6c 64 20 4e 61 6d | 65 2e 00 00 00 00 00 00 |ield Nam|e.......|
|00000ff0| 00 00 00 00 05 00 00 00 | 06 00 43 44 5f 54 59 50 |........|..CD_TYP|
|00001000| 14 00 41 74 74 72 69 62 | 75 74 65 20 44 61 74 61 |..Attrib|ute Data|
|00001010| 20 54 79 70 65 2e 00 00 | 00 00 00 00 00 00 00 00 | Type...|........|
|00001020| 05 00 00 00 06 00 43 44 | 5f 56 41 4c 48 00 41 74 |......CD|_VALH.At|
|00001030| 74 72 69 62 75 74 65 20 | 56 61 6c 69 64 61 74 69 |tribute |Validati|
|00001040| 6f 6e 20 52 75 6c 65 2e | 20 20 52 65 66 65 72 65 |on Rule.| Refere|
|00001050| 6e 63 65 20 74 6f 20 74 | 68 65 20 43 2f 53 20 56 |nce to t|he C/S V|
|00001060| 41 4c 49 44 41 54 49 4f | 4e 20 52 55 4c 45 20 6f |ALIDATIO|N RULE o|
|00001070| 62 6a 65 63 74 2e 00 00 | 00 00 00 00 00 00 00 00 |bject...|........|
|00001080| 05 00 00 00 06 00 43 44 | 5f 44 45 46 38 00 41 74 |......CD|_DEF8.At|
|00001090| 74 72 69 62 75 74 65 20 | 44 65 66 61 75 6c 74 2e |tribute |Default.|
|000010a0| 20 20 52 65 66 65 72 65 | 6e 63 65 20 74 6f 20 74 | Refere|nce to t|
|000010b0| 68 65 20 43 2f 53 20 44 | 45 46 41 55 4c 54 20 6f |he C/S D|EFAULT o|
|000010c0| 62 6a 65 63 74 2e 00 00 | 00 00 00 00 00 00 00 00 |bject...|........|
|000010d0| 05 00 00 00 06 00 43 44 | 5f 4e 55 4c 16 00 41 74 |......CD|_NUL..At|
|000010e0| 74 72 69 62 75 74 65 20 | 4e 75 6c 6c 20 4f 70 74 |tribute |Null Opt|
|000010f0| 69 6f 6e 2e 00 00 00 00 | 00 00 00 00 00 00 05 00 |ion.....|........|
|00001100| 00 00 06 00 43 44 5f 50 | 4e 4d 1a 00 50 6f 77 65 |....CD_P|NM..Powe|
|00001110| 72 20 42 75 69 6c 64 65 | 72 20 43 6f 6c 75 6d 6e |r Builde|r Column|
|00001120| 20 4e 61 6d 65 2e 00 00 | 00 00 00 00 00 00 00 00 | Name...|........|
|00001130| 05 00 00 00 06 00 43 44 | 5f 50 49 44 18 00 50 6f |......CD|_PID..Po|
|00001140| 77 65 72 20 42 75 69 6c | 64 65 72 20 43 6f 6c 75 |wer Buil|der Colu|
|00001150| 6d 6e 20 49 64 2e 00 00 | 00 00 00 00 00 00 00 00 |mn Id...|........|
|00001160| 05 00 00 00 06 00 43 44 | 5f 50 4c 42 14 00 50 6f |......CD|_PLB..Po|
|00001170| 77 65 72 20 42 75 69 6c | 64 65 72 20 4c 61 62 65 |wer Buil|der Labe|
|00001180| 6c 2e 00 00 00 00 00 00 | 00 00 00 00 05 00 00 00 |l.......|........|
|00001190| 06 00 43 44 5f 50 4c 50 | 1d 00 50 6f 77 65 72 20 |..CD_PLP|..Power |
|000011a0| 42 75 69 6c 64 65 72 20 | 4c 61 62 65 6c 20 50 6f |Builder |Label Po|
|000011b0| 73 69 74 69 6f 6e 2e 00 | 00 00 00 00 00 00 00 00 |sition..|........|
|000011c0| 00 05 00 00 00 06 00 43 | 44 5f 50 48 44 15 00 50 |.......C|D_PHD..P|
|000011d0| 6f 77 65 72 20 42 75 69 | 6c 64 65 72 20 48 65 61 |ower Bui|lder Hea|
|000011e0| 64 65 72 2e 00 00 00 00 | 00 00 00 00 00 00 05 00 |der.....|........|
|000011f0| 00 00 06 00 43 44 5f 50 | 48 50 1e 00 50 6f 77 65 |....CD_P|HP..Powe|
|00001200| 72 20 42 75 69 6c 64 65 | 72 20 48 65 61 64 65 72 |r Builde|r Header|
|00001210| 20 50 6f 73 69 74 69 6f | 6e 2e 00 00 00 00 00 00 | Positio|n.......|
|00001220| 00 00 00 00 05 00 00 00 | 06 00 43 44 5f 50 4a 54 |........|..CD_PJT|
|00001230| 1b 00 50 6f 77 65 72 20 | 42 75 69 6c 64 65 72 20 |..Power |Builder |
|00001240| 4a 75 73 74 69 66 79 20 | 66 6c 61 67 2e 00 00 00 |Justify |flag....|
|00001250| 00 00 00 00 00 00 00 05 | 00 00 00 06 00 43 44 5f |........|.....CD_|
|00001260| 50 4d 4b 13 00 50 6f 77 | 65 72 20 42 75 69 6c 64 |PMK..Pow|er Build|
|00001270| 65 72 20 4d 61 73 6b 2e | 00 00 00 00 00 00 00 00 |er Mask.|........|
|00001280| 00 00 05 00 00 00 06 00 | 43 44 5f 50 43 53 13 00 |........|CD_PCS..|
|00001290| 50 6f 77 65 72 20 42 75 | 69 6c 64 65 72 20 43 61 |Power Bu|ilder Ca|
|000012a0| 73 65 2e 00 00 00 00 00 | 00 00 00 00 00 05 00 00 |se......|........|
|000012b0| 00 06 00 43 44 5f 50 48 | 54 15 00 50 6f 77 65 72 |...CD_PH|T..Power|
|000012c0| 20 42 75 69 6c 64 65 72 | 20 48 65 69 67 68 74 2e | Builder| Height.|
|000012d0| 00 00 00 00 00 00 00 00 | 00 00 05 00 00 00 06 00 |........|........|
|000012e0| 43 44 5f 50 57 44 14 00 | 50 6f 77 65 72 20 42 75 |CD_PWD..|Power Bu|
|000012f0| 69 6c 64 65 72 20 57 69 | 64 74 68 2e 00 00 00 00 |ilder Wi|dth.....|
|00001300| 00 00 00 00 00 00 05 00 | 00 00 06 00 43 44 5f 50 |........|....CD_P|
|00001310| 54 52 1c 00 50 6f 77 65 | 72 20 42 75 69 6c 64 65 |TR..Powe|r Builde|
|00001320| 72 20 72 65 6c 61 74 65 | 64 20 76 61 6c 75 65 2e |r relate|d value.|
|00001330| 00 00 00 00 00 00 00 00 | 00 00 05 00 00 00 06 00 |........|........|
|00001340| 43 44 5f 50 42 4d 15 00 | 50 6f 77 65 72 20 42 75 |CD_PBM..|Power Bu|
|00001350| 69 6c 64 65 72 20 42 69 | 74 6d 61 70 2e 00 00 00 |ilder Bi|tmap....|
|00001360| 00 00 00 00 00 00 00 05 | 00 00 00 06 00 43 44 5f |........|.....CD_|
|00001370| 50 49 4e 1c 00 50 6f 77 | 65 72 20 42 75 69 6c 64 |PIN..Pow|er Build|
|00001380| 65 72 20 49 6e 69 74 69 | 61 6c 20 56 61 6c 75 65 |er Initi|al Value|
|00001390| 2e 00 00 00 00 00 00 00 | 00 00 00 05 00 00 00 06 |........|........|
|000013a0| 00 43 44 5f 50 43 4d 16 | 00 50 6f 77 65 72 20 42 |.CD_PCM.|.Power B|
|000013b0| 75 69 6c 64 65 72 20 43 | 6f 6d 6d 65 6e 74 2e 00 |uilder C|omment..|
|000013c0| 00 00 00 00 00 00 00 00 | 00 05 00 00 00 06 00 43 |........|.......C|
|000013d0| 44 5f 50 45 44 4d 00 50 | 6f 77 65 72 20 42 75 69 |D_PEDM.P|ower Bui|
|000013e0| 6c 64 65 72 20 45 64 69 | 74 20 53 74 79 6c 65 2e |lder Edi|t Style.|
|000013f0| 20 20 52 65 66 65 72 65 | 6e 63 65 20 74 6f 20 61 | Refere|nce to a|
|00001400| 20 70 68 79 73 69 63 61 | 6c 20 6f 62 6a 65 63 74 | physica|l object|
|00001410| 20 6f 66 20 74 79 70 65 | 20 65 64 69 74 20 73 74 | of type| edit st|
|00001420| 79 6c 65 2e 00 00 00 00 | 00 00 00 00 00 00 00 00 |yle.....|........|
|00001430| 00 00 01 00 00 00 01 00 | 00 00 00 00 50 00 00 00 |........|....P...|
|00001440| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001450| 00 00 00 00 0c 00 00 00 | 15 00 56 4c 44 5f 45 4e |........|..VLD_EN|
|00001460| 54 5f 50 48 59 53 50 52 | 4f 50 5f 54 59 50 45 00 |T_PHYSPR|OP_TYPE.|
|00001470| 00 05 00 00 00 01 00 00 | 00 0f 00 00 00 00 01 00 |........|........|
|00001480| 00 00 64 00 00 00 00 01 | 00 00 00 0f 00 00 00 00 |..d.....|........|
|00001490| 04 00 00 00 00 00 00 00 | 00 02 00 00 00 00 00 00 |........|........|
|000014a0| 00 00 12 00 00 00 05 00 | 00 00 06 00 45 50 5f 44 |........|....EP_D|
|000014b0| 41 54 1b 00 45 6e 74 69 | 74 79 20 73 61 6d 70 6c |AT..Enti|ty sampl|
|000014c0| 65 20 69 6e 73 74 61 6e | 63 65 20 64 61 74 61 00 |e instan|ce data.|
|000014d0| 00 00 00 00 00 00 00 00 | 00 05 00 00 00 06 00 45 |........|.......E|
|000014e0| 50 5f 51 52 59 13 00 45 | 6e 74 69 74 79 20 73 61 |P_QRY..E|ntity sa|
|000014f0| 6d 70 6c 65 20 71 75 65 | 72 79 00 00 00 00 00 00 |mple que|ry......|
|00001500| 00 00 00 00 05 00 00 00 | 06 00 45 50 5f 53 45 47 |........|..EP_SEG|
|00001510| 1a 00 53 79 62 61 73 65 | 2c 20 53 51 4c 20 53 65 |..Sybase|, SQL Se|
|00001520| 72 76 65 72 20 53 45 47 | 4d 45 4e 54 00 00 00 00 |rver SEG|MENT....|
|00001530| 00 00 00 00 00 00 05 00 | 00 00 06 00 45 50 5f 54 |........|....EP_T|
|00001540| 42 4e 1a 00 45 6e 74 69 | 74 79 20 50 68 79 73 69 |BN..Enti|ty Physi|
|00001550| 63 61 6c 20 54 61 62 6c | 65 20 4e 61 6d 65 00 00 |cal Tabl|e Name..|
|00001560| 00 00 00 00 00 00 00 00 | 05 00 00 00 06 00 50 50 |........|......PP|
|00001570| 5f 46 52 47 16 00 4f 52 | 41 43 4c 45 20 46 52 45 |_FRG..OR|ACLE FRE|
|00001580| 45 4c 49 53 54 20 47 52 | 4f 55 50 53 00 00 00 00 |ELIST GR|OUPS....|
|00001590| 00 00 00 00 00 00 05 00 | 00 00 06 00 50 50 5f 46 |........|....PP_F|
|000015a0| 52 4c 10 00 4f 52 41 43 | 4c 45 20 46 52 45 45 4c |RL..ORAC|LE FREEL|
|000015b0| 49 53 54 53 00 00 00 00 | 00 00 00 00 00 00 05 00 |ISTS....|........|
|000015c0| 00 00 06 00 50 50 5f 49 | 4e 49 0e 00 4f 52 41 43 |....PP_I|NI..ORAC|
|000015d0| 4c 45 20 49 4e 49 54 49 | 41 4c 00 00 00 00 00 00 |LE INITI|AL......|
|000015e0| 00 00 00 00 05 00 00 00 | 06 00 50 50 5f 49 4e 54 |........|..PP_INT|
|000015f0| 0f 00 4f 52 41 43 4c 45 | 20 49 4e 49 54 52 41 4e |..ORACLE| INITRAN|
|00001600| 53 00 00 00 00 00 00 00 | 00 00 00 05 00 00 00 06 |S.......|........|
|00001610| 00 50 50 5f 4d 4e 45 11 | 00 4f 52 41 43 4c 45 20 |.PP_MNE.|.ORACLE |
|00001620| 4d 49 4e 45 58 54 45 4e | 54 53 00 00 00 00 00 00 |MINEXTEN|TS......|
|00001630| 00 00 00 00 05 00 00 00 | 06 00 50 50 5f 4d 58 45 |........|..PP_MXE|
|00001640| 11 00 4f 52 41 43 4c 45 | 20 4d 41 58 45 58 54 45 |..ORACLE| MAXEXTE|
|00001650| 4e 54 53 00 00 00 00 00 | 00 00 00 00 00 05 00 00 |NTS.....|........|
|00001660| 00 06 00 50 50 5f 4d 58 | 54 0f 00 4f 52 41 43 4c |...PP_MX|T..ORACL|
|00001670| 45 20 4d 41 58 54 52 41 | 4e 53 00 00 00 00 00 00 |E MAXTRA|NS......|
|00001680| 00 00 00 00 05 00 00 00 | 06 00 50 50 5f 4e 58 54 |........|..PP_NXT|
|00001690| 0b 00 4f 52 41 43 4c 45 | 20 4e 45 58 54 00 00 00 |..ORACLE| NEXT...|
|000016a0| 00 00 00 00 00 00 00 05 | 00 00 00 06 00 50 50 5f |........|.....PP_|
|000016b0| 4f 50 54 0e 00 4f 52 41 | 43 4c 45 20 4f 50 54 49 |OPT..ORA|CLE OPTI|
|000016c0| 4d 41 4c 00 00 00 00 00 | 00 00 00 00 00 05 00 00 |MAL.....|........|
|000016d0| 00 06 00 50 50 5f 50 43 | 46 13 00 4f 52 41 43 4c |...PP_PC|F..ORACL|
|000016e0| 45 20 50 65 72 63 65 6e | 74 20 46 72 65 65 00 00 |E Percen|t Free..|
|000016f0| 00 00 00 00 00 00 00 00 | 05 00 00 00 06 00 50 50 |........|......PP|
|00001700| 5f 50 43 49 12 00 4f 52 | 41 43 4c 45 20 50 43 54 |_PCI..OR|ACLE PCT|
|00001710| 49 4e 43 52 45 41 53 45 | 00 00 00 00 00 00 00 00 |INCREASE|........|
|00001720| 00 00 05 00 00 00 06 00 | 50 50 5f 50 43 55 13 00 |........|PP_PCU..|
|00001730| 4f 52 41 43 4c 45 20 50 | 65 72 63 65 6e 74 20 55 |ORACLE P|ercent U|
|00001740| 73 65 64 00 00 00 00 00 | 00 00 00 00 00 05 00 00 |sed.....|........|
|00001750| 00 06 00 50 50 5f 53 54 | 4f 0e 00 4f 52 41 43 4c |...PP_ST|O..ORACL|
|00001760| 45 20 53 54 4f 52 41 47 | 45 00 00 00 00 00 00 00 |E STORAG|E.......|
|00001770| 00 00 00 05 00 00 00 06 | 00 50 50 5f 54 53 50 12 |........|.PP_TSP.|
|00001780| 00 4f 52 41 43 4c 45 20 | 54 61 62 6c 65 20 53 70 |.ORACLE |Table Sp|
|00001790| 61 63 65 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |ace.....|........|
|000017a0| 00 00 00 00 00 01 00 00 | 00 52 01 40 63 6f 6c 20 |........|.R.@col |
|000017b0| 3d 20 27 50 50 5f 54 53 | 50 27 20 4f 52 20 40 63 |= 'PP_TS|P' OR @c|
|000017c0| 6f 6c 20 3d 20 27 50 50 | 5f 50 43 46 27 20 4f 52 |ol = 'PP|_PCF' OR|
|000017d0| 20 40 63 6f 6c 20 3d 20 | 27 50 50 5f 50 43 55 27 | @col = |'PP_PCU'|
|000017e0| 20 4f 52 20 40 63 6f 6c | 20 3d 20 27 50 50 5f 49 | OR @col| = 'PP_I|
|000017f0| 4e 54 27 20 4f 52 20 40 | 63 6f 6c 20 3d 20 27 50 |NT' OR @|col = 'P|
|00001800| 50 5f 4d 58 54 27 20 4f | 52 20 40 63 6f 6c 20 3d |P_MXT' O|R @col =|
|00001810| 20 27 50 50 5f 49 4e 49 | 27 20 4f 52 20 40 63 6f | 'PP_INI|' OR @co|
|00001820| 6c 20 3d 20 27 50 50 5f | 53 54 4f 27 20 4f 52 20 |l = 'PP_|STO' OR |
|00001830| 40 63 6f 6c 20 3d 20 27 | 50 50 5f 4e 58 54 27 20 |@col = '|PP_NXT' |
|00001840| 4f 52 20 40 63 6f 6c 20 | 3d 20 27 50 50 5f 4d 4e |OR @col |= 'PP_MN|
|00001850| 45 27 20 4f 52 20 40 63 | 6f 6c 20 3d 20 27 50 50 |E' OR @c|ol = 'PP|
|00001860| 5f 4d 58 45 27 20 4f 52 | 20 40 63 6f 6c 20 3d 20 |_MXE' OR| @col = |
|00001870| 27 50 50 5f 50 43 49 27 | 20 4f 52 20 40 63 6f 6c |'PP_PCI'| OR @col|
|00001880| 20 3d 20 27 50 50 5f 4f | 50 54 27 20 4f 52 20 40 | = 'PP_O|PT' OR @|
|00001890| 63 6f 6c 20 3d 20 27 50 | 50 5f 46 52 4c 27 20 4f |col = 'P|P_FRL' O|
|000018a0| 52 20 40 63 6f 6c 20 3d | 20 27 50 50 5f 46 52 47 |R @col =| 'PP_FRG|
|000018b0| 27 20 4f 52 20 40 63 6f | 6c 20 3d 20 27 45 50 5f |' OR @co|l = 'EP_|
|000018c0| 53 45 47 27 20 4f 52 20 | 40 63 6f 6c 20 3d 20 27 |SEG' OR |@col = '|
|000018d0| 45 50 5f 54 42 4e 27 20 | 4f 52 20 40 63 6f 6c 20 |EP_TBN' |OR @col |
|000018e0| 3d 20 27 45 50 5f 51 52 | 59 27 20 4f 52 20 40 63 |= 'EP_QR|Y' OR @c|
|000018f0| 6f 6c 20 3d 20 27 45 50 | 5f 44 41 54 27 50 00 00 |ol = 'EP|_DAT'P..|
|00001900| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001910| 00 00 00 00 00 0c 00 00 | 00 0f 00 56 4c 44 5f 45 |........|...VLD_E|
|00001920| 4e 54 49 54 59 5f 54 59 | 50 45 00 00 05 00 00 00 |NTITY_TY|PE......|
|00001930| 01 00 00 00 0f 00 00 00 | 00 01 00 00 00 64 00 00 |........|.....d..|
|00001940| 00 00 01 00 00 00 0f 00 | 00 00 00 04 00 00 00 00 |........|........|
|00001950| 00 00 00 00 02 00 00 00 | 00 00 00 00 00 02 00 00 |........|........|
|00001960| 00 05 00 00 00 07 00 27 | 45 54 5f 49 45 27 12 00 |.......'|ET_IE'..|
|00001970| 49 6e 64 65 70 65 6e 64 | 65 6e 74 20 45 6e 74 69 |Independ|ent Enti|
|00001980| 74 79 00 00 00 00 00 00 | 00 00 00 00 05 00 00 00 |ty......|........|
|00001990| 07 00 27 45 54 5f 44 45 | 27 10 00 44 65 70 65 6e |..'ET_DE|'..Depen|
|000019a0| 64 65 6e 74 20 45 6e 74 | 69 74 79 00 00 00 00 00 |dent Ent|ity.....|
|000019b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000019c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 0c 00 00 |........|........|
|000019d0| 00 0d 00 56 4c 44 5f 46 | 4f 4e 54 5f 54 59 50 45 |...VLD_F|ONT_TYPE|
|000019e0| 00 00 05 00 00 00 01 00 | 00 00 0f 00 00 00 00 01 |........|........|
|000019f0| 00 00 00 64 00 00 00 00 | 01 00 00 00 0f 00 00 00 |...d....|........|
|00001a00| 00 04 00 00 00 00 00 00 | 00 00 02 00 00 00 00 00 |........|........|
|00001a10| 00 00 00 01 00 00 00 05 | 00 00 00 08 00 27 54 58 |........|.....'TX|
|00001a20| 5f 46 4e 54 27 0e 00 46 | 6f 6e 74 20 54 79 70 65 |_FNT'..F|ont Type|
|00001a30| 20 43 6f 64 65 00 00 00 | 00 00 00 00 00 00 00 00 | Code...|........|
|00001a40| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001a50| 00 00 00 00 00 00 00 0c | 00 00 00 10 00 56 4c 44 |........|.....VLD|
|00001a60| 5f 47 42 4c 54 4d 50 4c | 5f 52 55 4c 45 00 00 05 |_GBLTMPL|_RULE...|
|00001a70| 00 00 00 01 00 00 00 0f | 00 00 00 00 01 00 00 00 |........|........|
|00001a80| 64 00 00 00 00 01 00 00 | 00 0f 00 00 00 00 04 00 |d.......|........|
|00001a90| 00 00 00 00 00 00 00 02 | 00 00 00 00 00 00 00 00 |........|........|
|00001aa0| 21 00 00 00 05 00 00 00 | 05 00 44 52 5f 52 45 17 |!.......|..DR_RE.|
|00001ab0| 00 50 61 72 65 6e 74 20 | 44 65 6c 65 74 65 20 52 |.Parent |Delete R|
|00001ac0| 65 73 74 72 69 63 74 2e | 00 00 00 00 00 00 00 00 |estrict.|........|
|00001ad0| 00 00 05 00 00 00 05 00 | 44 52 5f 43 41 16 00 50 |........|DR_CA..P|
|00001ae0| 61 72 65 6e 74 20 44 65 | 6c 65 74 65 20 43 61 73 |arent De|lete Cas|
|00001af0| 63 61 64 65 2e 00 00 00 | 00 00 00 00 00 00 00 05 |cade....|........|
|00001b00| 00 00 00 05 00 44 52 5f | 53 4e 17 00 50 61 72 65 |.....DR_|SN..Pare|
|00001b10| 6e 74 20 44 65 6c 65 74 | 65 20 53 65 74 20 4e 75 |nt Delet|e Set Nu|
|00001b20| 6c 6c 2e 00 00 00 00 00 | 00 00 00 00 00 05 00 00 |ll......|........|
|00001b30| 00 05 00 44 52 5f 53 44 | 1a 00 50 61 72 65 6e 74 |...DR_SD|..Parent|
|00001b40| 20 44 65 6c 65 74 65 20 | 53 65 74 20 44 65 66 61 | Delete |Set Defa|
|00001b50| 75 6c 74 2e 00 00 00 00 | 00 00 00 00 00 00 05 00 |ult.....|........|
|00001b60| 00 00 05 00 55 52 5f 52 | 45 17 00 50 61 72 65 6e |....UR_R|E..Paren|
|00001b70| 74 20 55 70 64 61 74 65 | 20 52 65 73 74 72 69 63 |t Update| Restric|
|00001b80| 74 2e 00 00 00 00 00 00 | 00 00 00 00 05 00 00 00 |t.......|........|
|00001b90| 05 00 55 52 5f 43 41 16 | 00 50 61 72 65 6e 74 20 |..UR_CA.|.Parent |
|00001ba0| 55 70 64 61 74 65 20 43 | 61 73 63 61 64 65 2e 00 |Update C|ascade..|
|00001bb0| 00 00 00 00 00 00 00 00 | 00 05 00 00 00 05 00 55 |........|.......U|
|00001bc0| 52 5f 53 4e 17 00 50 61 | 72 65 6e 74 20 55 70 64 |R_SN..Pa|rent Upd|
|00001bd0| 61 74 65 20 53 65 74 20 | 4e 75 6c 6c 2e 00 00 00 |ate Set |Null....|
|00001be0| 00 00 00 00 00 00 00 05 | 00 00 00 05 00 55 52 5f |........|.....UR_|
|00001bf0| 53 44 1a 00 50 61 72 65 | 6e 74 20 55 70 64 61 74 |SD..Pare|nt Updat|
|00001c00| 65 20 53 65 74 20 44 65 | 66 61 75 6c 74 2e 00 00 |e Set De|fault...|
|00001c10| 00 00 00 00 00 00 00 00 | 05 00 00 00 06 00 49 52 |........|......IR|
|00001c20| 5f 50 52 45 17 00 50 61 | 72 65 6e 74 20 49 6e 73 |_PRE..Pa|rent Ins|
|00001c30| 65 72 74 20 52 65 73 74 | 72 69 63 74 2e 00 00 00 |ert Rest|rict....|
|00001c40| 00 00 00 00 00 00 00 05 | 00 00 00 06 00 49 52 5f |........|.....IR_|
|00001c50| 50 43 41 16 00 50 61 72 | 65 6e 74 20 49 6e 73 65 |PCA..Par|ent Inse|
|00001c60| 72 74 20 43 61 73 63 61 | 64 65 2e 00 00 00 00 00 |rt Casca|de......|
|00001c70| 00 00 00 00 00 05 00 00 | 00 06 00 49 52 5f 50 53 |........|...IR_PS|
|00001c80| 4e 17 00 50 61 72 65 6e | 74 20 49 6e 73 65 72 74 |N..Paren|t Insert|
|00001c90| 20 53 65 74 20 4e 75 6c | 6c 2e 00 00 00 00 00 00 | Set Nul|l.......|
|00001ca0| 00 00 00 00 05 00 00 00 | 06 00 49 52 5f 50 53 44 |........|..IR_PSD|
|00001cb0| 1a 00 50 61 72 65 6e 74 | 20 49 6e 73 65 72 74 20 |..Parent| Insert |
|00001cc0| 53 65 74 20 44 65 66 61 | 75 6c 74 2e 00 00 00 00 |Set Defa|ult.....|
|00001cd0| 00 00 00 00 00 00 05 00 | 00 00 06 00 44 52 5f 43 |........|....DR_C|
|00001ce0| 52 45 15 00 43 68 69 6c | 64 20 44 65 6c 65 74 65 |RE..Chil|d Delete|
|00001cf0| 20 43 61 73 63 61 64 65 | 2e 00 00 00 00 00 00 00 | Cascade|........|
|00001d00| 00 00 00 05 00 00 00 06 | 00 44 52 5f 43 43 41 15 |........|.DR_CCA.|
|00001d10| 00 43 68 69 6c 64 20 44 | 65 6c 65 74 65 20 43 61 |.Child D|elete Ca|
|00001d20| 73 63 61 64 65 2e 00 00 | 00 00 00 00 00 00 00 00 |scade...|........|
|00001d30| 05 00 00 00 06 00 44 52 | 5f 43 53 4e 16 00 43 68 |......DR|_CSN..Ch|
|00001d40| 69 6c 64 20 44 65 6c 65 | 74 65 20 53 65 74 20 4e |ild Dele|te Set N|
|00001d50| 75 6c 6c 2e 00 00 00 00 | 00 00 00 00 00 00 05 00 |ull.....|........|
|00001d60| 00 00 06 00 44 52 5f 43 | 53 44 19 00 43 68 69 6c |....DR_C|SD..Chil|
|00001d70| 64 20 44 65 6c 65 74 65 | 20 53 65 74 20 44 65 66 |d Delete| Set Def|
|00001d80| 61 75 6c 74 2e 00 00 00 | 00 00 00 00 00 00 00 05 |ault....|........|
|00001d90| 00 00 00 06 00 55 52 5f | 43 52 45 16 00 43 68 69 |.....UR_|CRE..Chi|
|00001da0| 6c 64 20 55 70 64 61 74 | 65 20 52 65 73 74 72 69 |ld Updat|e Restri|
|00001db0| 63 74 2e 00 00 00 00 00 | 00 00 00 00 00 05 00 00 |ct......|........|
|00001dc0| 00 06 00 55 52 5f 43 43 | 41 15 00 43 68 69 6c 64 |...UR_CC|A..Child|
|00001dd0| 20 55 70 64 61 74 65 20 | 43 61 73 63 61 64 65 2e | Update |Cascade.|
|00001de0| 00 00 00 00 00 00 00 00 | 00 00 05 00 00 00 06 00 |........|........|
|00001df0| 55 52 5f 43 53 4e 16 00 | 43 68 69 6c 64 20 55 70 |UR_CSN..|Child Up|
|00001e00| 64 61 74 65 20 53 65 74 | 20 4e 75 6c 6c 2e 00 00 |date Set| Null...|
|00001e10| 00 00 00 00 00 00 00 00 | 05 00 00 00 06 00 55 52 |........|......UR|
|00001e20| 5f 43 53 44 19 00 43 68 | 69 6c 64 20 55 70 64 61 |_CSD..Ch|ild Upda|
|00001e30| 74 65 20 53 65 74 20 44 | 65 66 61 75 6c 74 2e 00 |te Set D|efault..|
|00001e40| 00 00 00 00 00 00 00 00 | 00 05 00 00 00 05 00 49 |........|.......I|
|00001e50| 52 5f 52 45 16 00 43 68 | 69 6c 64 20 49 6e 73 65 |R_RE..Ch|ild Inse|
|00001e60| 72 74 20 52 65 73 74 72 | 69 63 74 2e 00 00 00 00 |rt Restr|ict.....|
|00001e70| 00 00 00 00 00 00 05 00 | 00 00 05 00 49 52 5f 43 |........|....IR_C|
|00001e80| 41 15 00 43 68 69 6c 64 | 20 49 6e 73 65 72 74 20 |A..Child| Insert |
|00001e90| 43 61 73 63 61 64 65 2e | 00 00 00 00 00 00 00 00 |Cascade.|........|
|00001ea0| 00 00 05 00 00 00 05 00 | 49 52 5f 53 4e 16 00 43 |........|IR_SN..C|
|00001eb0| 68 69 6c 64 20 49 6e 73 | 65 72 74 20 53 65 74 20 |hild Ins|ert Set |
|00001ec0| 4e 75 6c 6c 2e 00 00 00 | 00 00 00 00 00 00 00 05 |Null....|........|
|00001ed0| 00 00 00 05 00 49 52 5f | 53 44 19 00 43 68 69 6c |.....IR_|SD..Chil|
|00001ee0| 64 20 49 6e 73 65 72 74 | 20 53 65 74 20 44 65 66 |d Insert| Set Def|
|00001ef0| 61 75 6c 74 2e 00 00 00 | 00 00 00 00 00 00 00 05 |ault....|........|
|00001f00| 00 00 00 05 00 54 52 5f | 55 48 1e 00 44 65 66 61 |.....TR_|UH..Defa|
|00001f10| 75 6c 74 20 55 70 64 61 | 74 65 20 54 72 69 67 67 |ult Upda|te Trigg|
|00001f20| 65 72 20 48 65 61 64 65 | 72 2e 00 00 00 00 00 00 |er Heade|r.......|
|00001f30| 00 00 00 00 05 00 00 00 | 05 00 54 52 5f 55 46 1e |........|..TR_UF.|
|00001f40| 00 44 65 66 61 75 6c 74 | 20 55 70 64 61 74 65 20 |.Default| Update |
|00001f50| 54 72 69 67 67 65 72 20 | 46 6f 6f 74 65 72 2e 00 |Trigger |Footer..|
|00001f60| 00 00 00 00 00 00 00 00 | 00 05 00 00 00 05 00 54 |........|.......T|
|00001f70| 52 5f 44 48 1e 00 44 65 | 66 61 75 6c 74 20 44 65 |R_DH..De|fault De|
|00001f80| 6c 65 74 65 20 54 72 69 | 67 67 65 72 20 48 65 61 |lete Tri|gger Hea|
|00001f90| 64 65 72 2e 00 00 00 00 | 00 00 00 00 00 00 05 00 |der.....|........|
|00001fa0| 00 00 05 00 54 52 5f 44 | 46 1e 00 44 65 66 61 75 |....TR_D|F..Defau|
|00001fb0| 6c 74 20 44 65 6c 65 74 | 65 20 54 72 69 67 67 65 |lt Delet|e Trigge|
|00001fc0| 72 20 46 6f 6f 74 65 72 | 2e 00 00 00 00 00 00 00 |r Footer|........|
|00001fd0| 00 00 00 05 00 00 00 05 | 00 54 52 5f 49 48 1e 00 |........|.TR_IH..|
|00001fe0| 44 65 66 61 75 6c 74 20 | 49 6e 73 65 72 74 20 54 |Default |Insert T|
|00001ff0| 72 69 67 67 65 72 20 48 | 65 61 64 65 72 2e 00 00 |rigger H|eader...|
|00002000| 00 00 00 00 00 00 00 00 | 05 00 00 00 05 00 54 52 |........|......TR|
|00002010| 5f 49 46 1e 00 44 65 66 | 61 75 6c 74 20 49 6e 73 |_IF..Def|ault Ins|
|00002020| 65 72 74 20 54 72 69 67 | 67 65 72 20 46 6f 6f 74 |ert Trig|ger Foot|
|00002030| 65 72 2e 00 00 00 00 00 | 00 00 00 00 00 05 00 00 |er......|........|
|00002040| 00 05 00 54 52 5f 43 48 | 1e 00 44 65 66 61 75 6c |...TR_CH|..Defaul|
|00002050| 74 20 43 75 73 74 6f 6d | 20 54 72 69 67 67 65 72 |t Custom| Trigger|
|00002060| 20 48 65 61 64 65 72 2e | 00 00 00 00 00 00 00 00 | Header.|........|
|00002070| 00 00 05 00 00 00 05 00 | 54 52 5f 43 46 1e 00 44 |........|TR_CF..D|
|00002080| 65 66 61 75 6c 74 20 43 | 75 73 74 6f 6d 20 54 72 |efault C|ustom Tr|
|00002090| 69 67 67 65 72 20 46 6f | 6f 74 65 72 2e 00 00 00 |igger Fo|oter....|
|000020a0| 00 00 00 00 00 00 00 05 | 00 00 00 05 00 54 52 5f |........|.....TR_|
|000020b0| 43 42 1c 00 44 65 66 61 | 75 6c 74 20 43 75 73 74 |CB..Defa|ult Cust|
|000020c0| 6f 6d 20 54 72 69 67 67 | 65 72 20 42 6f 64 79 2e |om Trigg|er Body.|
|000020d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000020e0| 00 00 01 00 00 00 b8 01 | 40 63 6f 6c 20 3d 20 27 |........|@col = '|
|000020f0| 44 52 5f 52 45 27 20 4f | 52 20 40 63 6f 6c 20 3d |DR_RE' O|R @col =|
|00002100| 20 27 44 52 5f 43 41 27 | 20 4f 52 20 40 63 6f 6c | 'DR_CA'| OR @col|
|00002110| 20 3d 20 27 44 52 5f 53 | 4e 27 20 4f 52 20 40 63 | = 'DR_S|N' OR @c|
|00002120| 6f 6c 20 3d 20 27 44 52 | 5f 53 44 27 20 4f 52 20 |ol = 'DR|_SD' OR |
|00002130| 40 63 6f 6c 20 3d 20 27 | 55 52 5f 52 45 27 20 4f |@col = '|UR_RE' O|
|00002140| 52 20 40 63 6f 6c 20 3d | 20 27 55 52 5f 43 41 27 |R @col =| 'UR_CA'|
|00002150| 20 4f 52 20 40 63 6f 6c | 20 3d 20 27 55 52 5f 53 | OR @col| = 'UR_S|
|00002160| 4e 27 20 4f 52 20 40 63 | 6f 6c 20 3d 20 27 55 52 |N' OR @c|ol = 'UR|
|00002170| 5f 53 44 27 20 4f 52 20 | 40 63 6f 6c 20 3d 20 27 |_SD' OR |@col = '|
|00002180| 49 52 5f 50 52 45 27 20 | 4f 52 20 40 63 6f 6c 20 |IR_PRE' |OR @col |
|00002190| 3d 20 27 49 52 5f 50 43 | 41 27 20 4f 52 20 40 63 |= 'IR_PC|A' OR @c|
|000021a0| 6f 6c 20 3d 20 27 49 52 | 5f 50 53 4e 27 20 4f 52 |ol = 'IR|_PSN' OR|
|000021b0| 20 40 63 6f 6c 20 3d 20 | 27 49 52 5f 50 53 44 27 | @col = |'IR_PSD'|
|000021c0| 20 4f 52 20 40 63 6f 6c | 20 3d 20 27 44 52 5f 43 | OR @col| = 'DR_C|
|000021d0| 52 45 27 20 4f 52 20 40 | 63 6f 6c 20 3d 20 27 44 |RE' OR @|col = 'D|
|000021e0| 52 5f 43 43 41 27 20 4f | 52 20 40 63 6f 6c 20 3d |R_CCA' O|R @col =|
|000021f0| 20 27 44 52 5f 43 53 4e | 27 20 4f 52 20 40 63 6f | 'DR_CSN|' OR @co|
|00002200| 6c 20 3d 20 27 44 52 5f | 43 53 44 27 20 4f 52 20 |l = 'DR_|CSD' OR |
|00002210| 40 63 6f 6c 20 3d 20 27 | 55 52 5f 43 52 45 27 20 |@col = '|UR_CRE' |
|00002220| 4f 52 20 40 63 6f 6c 20 | 3d 20 27 55 52 5f 43 43 |OR @col |= 'UR_CC|
|00002230| 41 27 20 4f 52 20 40 63 | 6f 6c 20 3d 20 27 55 52 |A' OR @c|ol = 'UR|
|00002240| 5f 43 53 4e 27 20 4f 52 | 20 40 63 6f 6c 20 3d 20 |_CSN' OR| @col = |
|00002250| 27 55 52 5f 43 53 44 27 | 20 4f 52 20 40 63 6f 6c |'UR_CSD'| OR @col|
|00002260| 20 3d 20 27 49 52 5f 52 | 45 27 20 4f 52 20 40 63 | = 'IR_R|E' OR @c|
|00002270| 6f 6c 20 3d 20 27 49 52 | 5f 43 41 27 20 4f 52 20 |ol = 'IR|_CA' OR |
|00002280| 40 63 6f 6c 20 3d 20 27 | 49 52 5f 53 4e 27 20 4f |@col = '|IR_SN' O|
|00002290| 52 20 40 63 6f 6c 20 3d | 20 27 49 52 5f 53 44 27 |R @col =| 'IR_SD'|
|000022a0| 50 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |P.......|........|
|000022b0| 00 00 00 00 00 00 00 00 | 0c 00 00 00 15 00 56 4c |........|......VL|
|000022c0| 44 5f 49 44 58 5f 50 48 | 59 53 50 52 4f 50 5f 54 |D_IDX_PH|YSPROP_T|
|000022d0| 59 50 45 00 00 05 00 00 | 00 01 00 00 00 0f 00 00 |YPE.....|........|
|000022e0| 00 00 01 00 00 00 64 00 | 00 00 00 01 00 00 00 0f |......d.|........|
|000022f0| 00 00 00 00 04 00 00 00 | 00 00 00 00 00 02 00 00 |........|........|
|00002300| 00 00 00 00 00 00 17 00 | 00 00 05 00 00 00 06 00 |........|........|
|00002310| 45 50 5f 41 4c 52 14 00 | 53 79 62 61 73 65 20 41 |EP_ALR..|Sybase A|
|00002320| 4c 4c 4f 57 5f 44 55 50 | 5f 52 4f 57 00 00 00 00 |LLOW_DUP|_ROW....|
|00002330| 00 00 00 00 00 00 05 00 | 00 00 06 00 45 50 5f 44 |........|....EP_D|
|00002340| 50 52 0e 00 53 79 62 61 | 73 65 20 44 55 50 5f 52 |PR..Syba|se DUP_R|
|00002350| 4f 57 00 00 00 00 00 00 | 00 00 00 00 05 00 00 00 |OW......|........|
|00002360| 06 00 45 50 5f 46 49 4c | 11 00 53 79 62 61 73 65 |..EP_FIL|..Sybase|
|00002370| 20 46 49 4c 4c 46 41 43 | 54 4f 52 00 00 00 00 00 | FILLFAC|TOR.....|
|00002380| 00 00 00 00 00 05 00 00 | 00 06 00 45 50 5f 49 47 |........|...EP_IG|
|00002390| 44 15 00 53 79 62 61 73 | 65 20 49 47 4e 4f 52 45 |D..Sybas|e IGNORE|
|000023a0| 5f 44 55 50 5f 4b 45 59 | 00 00 00 00 00 00 00 00 |_DUP_KEY|........|
|000023b0| 00 00 05 00 00 00 06 00 | 45 50 5f 49 47 52 15 00 |........|EP_IGR..|
|000023c0| 53 79 62 61 73 65 20 49 | 47 4e 4f 52 45 5f 44 55 |Sybase I|GNORE_DU|
|000023d0| 50 5f 52 4f 57 00 00 00 | 00 00 00 00 00 00 00 05 |P_ROW...|........|
|000023e0| 00 00 00 06 00 45 50 5f | 53 45 47 1a 00 53 79 62 |.....EP_|SEG..Syb|
|000023f0| 61 73 65 2c 20 53 51 4c | 20 53 65 72 76 65 72 20 |ase, SQL| Server |
|00002400| 53 45 47 4d 45 4e 54 00 | 00 00 00 00 00 00 00 00 |SEGMENT.|........|
|00002410| 00 05 00 00 00 06 00 45 | 50 5f 53 52 54 12 00 53 |.......E|P_SRT..S|
|00002420| 79 62 61 73 65 20 53 4f | 52 54 45 44 5f 44 41 54 |ybase SO|RTED_DAT|
|00002430| 41 00 00 00 00 00 00 00 | 00 00 00 05 00 00 00 06 |A.......|........|
|00002440| 00 50 50 5f 46 52 47 16 | 00 4f 52 41 43 4c 45 20 |.PP_FRG.|.ORACLE |
|00002450| 46 52 45 45 4c 49 53 54 | 20 47 52 4f 55 50 53 00 |FREELIST| GROUPS.|
|00002460| 00 00 00 00 00 00 00 00 | 00 05 00 00 00 06 00 50 |........|.......P|
|00002470| 50 5f 46 52 4c 10 00 4f | 52 41 43 4c 45 20 46 52 |P_FRL..O|RACLE FR|
|00002480| 45 45 4c 49 53 54 53 00 | 00 00 00 00 00 00 00 00 |EELISTS.|........|
|00002490| 00 05 00 00 00 06 00 50 | 50 5f 49 4e 49 0e 00 4f |.......P|P_INI..O|
|000024a0| 52 41 43 4c 45 20 49 4e | 49 54 49 41 4c 00 00 00 |RACLE IN|ITIAL...|
|000024b0| 00 00 00 00 00 00 00 05 | 00 00 00 06 00 50 50 5f |........|.....PP_|
|000024c0| 49 4e 54 0f 00 4f 52 41 | 43 4c 45 20 49 4e 49 54 |INT..ORA|CLE INIT|
|000024d0| 52 41 4e 53 00 00 00 00 | 00 00 00 00 00 00 05 00 |RANS....|........|
|000024e0| 00 00 06 00 50 50 5f 4d | 4e 45 11 00 4f 52 41 43 |....PP_M|NE..ORAC|
|000024f0| 4c 45 20 4d 49 4e 45 58 | 54 45 4e 54 53 00 00 00 |LE MINEX|TENTS...|
|00002500| 00 00 00 00 00 00 00 05 | 00 00 00 06 00 50 50 5f |........|.....PP_|
|00002510| 4d 58 45 11 00 4f 52 41 | 43 4c 45 20 4d 41 58 45 |MXE..ORA|CLE MAXE|
|00002520| 58 54 45 4e 54 53 00 00 | 00 00 00 00 00 00 00 00 |XTENTS..|........|
|00002530| 05 00 00 00 06 00 50 50 | 5f 4d 58 54 0f 00 4f 52 |......PP|_MXT..OR|
|00002540| 41 43 4c 45 20 4d 41 58 | 54 52 41 4e 53 00 00 00 |ACLE MAX|TRANS...|
|00002550| 00 00 00 00 00 00 00 05 | 00 00 00 06 00 50 50 5f |........|.....PP_|
|00002560| 4e 4f 53 0d 00 4f 52 41 | 43 4c 45 20 4e 4f 53 4f |NOS..ORA|CLE NOSO|
|00002570| 52 54 00 00 00 00 00 00 | 00 00 00 00 05 00 00 00 |RT......|........|
|00002580| 06 00 50 50 5f 4e 58 54 | 0b 00 4f 52 41 43 4c 45 |..PP_NXT|..ORACLE|
|00002590| 20 4e 45 58 54 00 00 00 | 00 00 00 00 00 00 00 05 | NEXT...|........|
|000025a0| 00 00 00 06 00 50 50 5f | 4f 50 54 0e 00 4f 52 41 |.....PP_|OPT..ORA|
|000025b0| 43 4c 45 20 4f 50 54 49 | 4d 41 4c 00 00 00 00 00 |CLE OPTI|MAL.....|
|000025c0| 00 00 00 00 00 05 00 00 | 00 06 00 50 50 5f 50 43 |........|...PP_PC|
|000025d0| 46 13 00 4f 52 41 43 4c | 45 20 50 65 72 63 65 6e |F..ORACL|E Percen|
|000025e0| 74 20 46 72 65 65 00 00 | 00 00 00 00 00 00 00 00 |t Free..|........|
|000025f0| 05 00 00 00 06 00 50 50 | 5f 50 43 49 12 00 4f 52 |......PP|_PCI..OR|
|00002600| 41 43 4c 45 20 50 43 54 | 49 4e 43 52 45 41 53 45 |ACLE PCT|INCREASE|
|00002610| 00 00 00 00 00 00 00 00 | 00 00 05 00 00 00 06 00 |........|........|
|00002620| 50 50 5f 50 43 55 13 00 | 4f 52 41 43 4c 45 20 50 |PP_PCU..|ORACLE P|
|00002630| 65 72 63 65 6e 74 20 55 | 73 65 64 00 00 00 00 00 |ercent U|sed.....|
|00002640| 00 00 00 00 00 05 00 00 | 00 06 00 50 50 5f 53 49 |........|...PP_SI|
|00002650| 5a 0b 00 4f 52 41 43 4c | 45 20 53 49 5a 45 00 00 |Z..ORACL|E SIZE..|
|00002660| 00 00 00 00 00 00 00 00 | 05 00 00 00 06 00 50 50 |........|......PP|
|00002670| 5f 53 54 4f 0e 00 4f 52 | 41 43 4c 45 20 53 54 4f |_STO..OR|ACLE STO|
|00002680| 52 41 47 45 00 00 00 00 | 00 00 00 00 00 00 05 00 |RAGE....|........|
|00002690| 00 00 06 00 50 50 5f 54 | 53 50 12 00 4f 52 41 43 |....PP_T|SP..ORAC|
|000026a0| 4c 45 20 54 61 62 6c 65 | 20 53 70 61 63 65 00 00 |LE Table| Space..|
|000026b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000026c0| 01 00 00 00 00 00 50 00 | 00 00 00 00 00 00 00 00 |......P.|........|
|000026d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 0c 00 |........|........|
|000026e0| 00 00 0e 00 56 4c 44 5f | 49 4e 44 45 58 5f 54 59 |....VLD_|INDEX_TY|
|000026f0| 50 45 00 00 05 00 00 00 | 01 00 00 00 0f 00 00 00 |PE......|........|
|00002700| 00 01 00 00 00 64 00 00 | 00 00 01 00 00 00 0f 00 |.....d..|........|
|00002710| 00 00 00 04 00 00 00 00 | 00 00 00 00 02 00 00 00 |........|........|
|00002720| 00 00 00 00 00 04 00 00 | 00 05 00 00 00 05 00 49 |........|.......I|
|00002730| 54 5f 41 4b 1b 00 41 6c | 74 65 72 6e 61 74 65 20 |T_AK..Al|ternate |
|00002740| 4b 65 79 20 55 6e 69 71 | 75 65 20 49 6e 64 65 78 |Key Uniq|ue Index|
|00002750| 2e 00 00 00 00 00 00 00 | 00 00 00 05 00 00 00 05 |........|........|
|00002760| 00 49 54 5f 50 4b 19 00 | 50 72 69 6d 61 72 79 20 |.IT_PK..|Primary |
|00002770| 4b 65 79 20 55 6e 69 71 | 75 65 20 49 6e 64 65 78 |Key Uniq|ue Index|
|00002780| 2e 00 00 00 00 00 00 00 | 00 00 00 05 00 00 00 05 |........|........|
|00002790| 00 49 54 5f 49 45 21 00 | 49 6e 76 65 72 73 69 6f |.IT_IE!.|Inversio|
|000027a0| 6e 20 45 6e 74 72 79 20 | 4e 6f 6e 2d 55 6e 69 71 |n Entry |Non-Uniq|
|000027b0| 75 65 20 49 6e 64 65 78 | 2e 00 00 00 00 00 00 00 |ue Index|........|
|000027c0| 00 00 00 05 00 00 00 05 | 00 49 54 5f 49 46 1d 00 |........|.IT_IF..|
|000027d0| 46 6f 72 65 69 67 6e 20 | 4b 65 79 20 4e 6f 6e 2d |Foreign |Key Non-|
|000027e0| 55 6e 69 71 75 65 20 49 | 6e 64 65 78 2e 00 00 00 |Unique I|ndex....|
|000027f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 01 |........|........|
|00002800| 00 00 00 00 00 50 00 00 | 00 00 00 00 00 00 00 00 |.....P..|........|
|00002810| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 0c 00 00 |........|........|
|00002820| 00 0d 00 56 4c 44 5f 4e | 55 4c 4c 5f 52 55 4c 45 |...VLD_N|ULL_RULE|
|00002830| 00 00 05 00 00 00 01 00 | 00 00 0f 00 00 00 00 01 |........|........|
|00002840| 00 00 00 64 00 00 00 00 | 01 00 00 00 0f 00 00 00 |...d....|........|
|00002850| 00 04 00 00 00 00 00 00 | 00 00 02 00 00 00 00 00 |........|........|
|00002860| 00 00 00 02 00 00 00 05 | 00 00 00 07 00 27 4e 52 |........|.....'NR|
|00002870| 5f 4e 41 27 0d 00 4e 75 | 6c 6c 73 20 41 6c 6c 6f |_NA'..Nu|lls Allo|
|00002880| 77 65 64 00 00 00 00 00 | 00 00 00 00 00 05 00 00 |wed.....|........|
|00002890| 00 07 00 27 4e 52 5f 4e | 4e 27 10 00 4e 6f 20 4e |...'NR_N|N'..No N|
|000028a0| 75 6c 6c 73 20 41 6c 6c | 6f 77 65 64 00 00 00 00 |ulls All|owed....|
|000028b0| 00 00 00 00 00 00 00 00 | 00 00 01 00 00 00 01 00 |........|........|
|000028c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000028d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 0c 00 00 00 |........|........|
|000028e0| 16 00 56 4c 44 5f 50 41 | 52 45 4e 54 5f 44 45 4c |..VLD_PA|RENT_DEL|
|000028f0| 45 54 45 5f 52 55 4c 45 | 00 00 05 00 00 00 01 00 |ETE_RULE|........|
|00002900| 00 00 0f 00 00 00 00 01 | 00 00 00 64 00 00 00 00 |........|...d....|
|00002910| 01 00 00 00 0f 00 00 00 | 00 04 00 00 00 00 00 00 |........|........|
|00002920| 00 00 02 00 00 00 00 00 | 00 00 00 04 00 00 00 05 |........|........|
|00002930| 00 00 00 07 00 27 44 52 | 5f 52 45 27 16 00 50 61 |.....'DR|_RE'..Pa|
|00002940| 72 65 6e 74 20 44 65 6c | 65 74 65 20 52 65 73 74 |rent Del|ete Rest|
|00002950| 72 69 63 74 00 00 00 00 | 00 00 00 00 00 00 05 00 |rict....|........|
|00002960| 00 00 07 00 27 44 52 5f | 43 41 27 15 00 50 61 72 |....'DR_|CA'..Par|
|00002970| 65 6e 74 20 44 65 6c 65 | 74 65 20 43 61 73 63 61 |ent Dele|te Casca|
|00002980| 64 65 00 00 00 00 00 00 | 00 00 00 00 05 00 00 00 |de......|........|
|00002990| 07 00 27 44 52 5f 53 4e | 27 16 00 50 61 72 65 6e |..'DR_SN|'..Paren|
|000029a0| 74 20 44 65 6c 65 74 65 | 20 53 65 74 20 4e 75 6c |t Delete| Set Nul|
|000029b0| 6c 00 00 00 00 00 00 00 | 00 00 00 05 00 00 00 07 |l.......|........|
|000029c0| 00 27 44 52 5f 53 44 27 | 19 00 50 61 72 65 6e 74 |.'DR_SD'|..Parent|
|000029d0| 20 44 65 6c 65 74 65 20 | 53 65 74 20 44 65 66 61 | Delete |Set Defa|
|000029e0| 75 6c 74 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |ult.....|........|
|000029f0| 00 01 00 00 00 01 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002a00| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002a10| 00 00 00 0c 00 00 00 16 | 00 56 4c 44 5f 50 41 52 |........|.VLD_PAR|
|00002a20| 45 4e 54 5f 49 4e 53 45 | 52 54 5f 52 55 4c 45 32 |ENT_INSE|RT_RULE2|
|00002a30| 00 40 56 41 4c 55 45 20 | 49 4e 20 28 27 49 52 5f |.@VALUE |IN ('IR_|
|00002a40| 50 52 45 27 2c 20 27 49 | 52 5f 50 43 41 27 2c 20 |PRE', 'I|R_PCA', |
|00002a50| 27 49 52 5f 50 53 4e 27 | 2c 20 27 49 52 5f 50 53 |'IR_PSN'|, 'IR_PS|
|00002a60| 44 27 29 05 00 00 00 01 | 00 00 00 0f 00 00 00 00 |D').....|........|
|00002a70| 01 00 00 00 64 00 00 00 | 00 01 00 00 00 0f 00 00 |....d...|........|
|00002a80| 00 00 04 00 00 00 00 00 | 00 00 00 02 00 00 00 00 |........|........|
|00002a90| 00 00 00 00 04 00 00 00 | 05 00 00 00 08 00 27 49 |........|......'I|
|00002aa0| 52 5f 50 52 45 27 16 00 | 50 61 72 65 6e 74 20 49 |R_PRE'..|Parent I|
|00002ab0| 6e 73 65 72 74 20 52 65 | 73 74 72 69 63 74 00 00 |nsert Re|strict..|
|00002ac0| 00 00 00 00 00 00 00 00 | 05 00 00 00 08 00 27 49 |........|......'I|
|00002ad0| 52 5f 50 43 41 27 15 00 | 50 61 72 65 6e 74 20 49 |R_PCA'..|Parent I|
|00002ae0| 6e 73 65 72 74 20 43 61 | 73 63 61 64 65 00 00 00 |nsert Ca|scade...|
|00002af0| 00 00 00 00 00 00 00 05 | 00 00 00 08 00 27 49 52 |........|.....'IR|
|00002b00| 5f 50 53 4e 27 16 00 50 | 61 72 65 6e 74 20 49 6e |_PSN'..P|arent In|
|00002b10| 73 65 72 74 20 53 65 74 | 20 4e 75 6c 6c 00 00 00 |sert Set| Null...|
|00002b20| 00 00 00 00 00 00 00 05 | 00 00 00 08 00 27 49 52 |........|.....'IR|
|00002b30| 5f 50 53 44 27 19 00 50 | 61 72 65 6e 74 20 49 6e |_PSD'..P|arent In|
|00002b40| 73 65 72 74 20 53 65 74 | 20 44 65 66 61 75 6c 74 |sert Set| Default|
|00002b50| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 01 00 |........|........|
|00002b60| 00 00 01 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002b70| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002b80| 0c 00 00 00 16 00 56 4c | 44 5f 50 41 52 45 4e 54 |......VL|D_PARENT|
|00002b90| 5f 55 50 44 41 54 45 5f | 52 55 4c 45 00 00 05 00 |_UPDATE_|RULE....|
|00002ba0| 00 00 01 00 00 00 0f 00 | 00 00 00 01 00 00 00 64 |........|.......d|
|00002bb0| 00 00 00 00 01 00 00 00 | 0f 00 00 00 00 04 00 00 |........|........|
|00002bc0| 00 00 00 00 00 00 02 00 | 00 00 00 00 00 00 00 04 |........|........|
|00002bd0| 00 00 00 05 00 00 00 07 | 00 27 55 52 5f 52 45 27 |........|.'UR_RE'|
|00002be0| 16 00 50 61 72 65 6e 74 | 20 55 70 64 61 74 65 20 |..Parent| Update |
|00002bf0| 52 65 73 74 72 69 63 74 | 00 00 00 00 00 00 00 00 |Restrict|........|
|00002c00| 00 00 05 00 00 00 07 00 | 27 55 52 5f 43 41 27 15 |........|'UR_CA'.|
|00002c10| 00 50 61 72 65 6e 74 20 | 55 70 64 61 74 65 20 43 |.Parent |Update C|
|00002c20| 61 73 63 61 64 65 00 00 | 00 00 00 00 00 00 00 00 |ascade..|........|
|00002c30| 05 00 00 00 07 00 27 55 | 52 5f 53 4e 27 16 00 50 |......'U|R_SN'..P|
|00002c40| 61 72 65 6e 74 20 55 70 | 64 61 74 65 20 53 65 74 |arent Up|date Set|
|00002c50| 20 4e 75 6c 6c 00 00 00 | 00 00 00 00 00 00 00 05 | Null...|........|
|00002c60| 00 00 00 07 00 27 55 52 | 5f 53 44 27 19 00 50 61 |.....'UR|_SD'..Pa|
|00002c70| 72 65 6e 74 20 55 70 64 | 61 74 65 20 53 65 74 20 |rent Upd|ate Set |
|00002c80| 44 65 66 61 75 6c 74 00 | 00 00 00 00 00 00 00 00 |Default.|........|
|00002c90| 00 00 00 00 00 01 00 00 | 00 01 00 00 00 00 00 00 |........|........|
|00002ca0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002cb0| 00 00 00 00 00 00 00 0c | 00 00 00 10 00 56 4c 44 |........|.....VLD|
|00002cc0| 5f 50 48 59 53 4f 42 4a | 5f 54 59 50 45 00 00 05 |_PHYSOBJ|_TYPE...|
|00002cd0| 00 00 00 01 00 00 00 0f | 00 00 00 00 01 00 00 00 |........|........|
|00002ce0| 64 00 00 00 00 01 00 00 | 00 0f 00 00 00 00 04 00 |d.......|........|
|00002cf0| 00 00 00 00 00 00 00 02 | 00 00 00 00 00 00 00 00 |........|........|
|00002d00| 04 00 00 00 05 00 00 00 | 08 00 27 45 50 5f 53 45 |........|..'EP_SE|
|00002d10| 47 27 19 00 53 79 62 61 | 73 65 2f 53 51 4c 20 53 |G'..Syba|se/SQL S|
|00002d20| 65 72 76 65 72 20 53 65 | 67 6d 65 6e 74 00 00 00 |erver Se|gment...|
|00002d30| 00 00 00 00 00 00 00 05 | 00 00 00 08 00 27 50 50 |........|.....'PP|
|00002d40| 5f 44 42 53 27 0f 00 4f | 52 41 43 4c 45 20 44 61 |_DBS'..O|RACLE Da|
|00002d50| 74 61 62 61 73 65 00 00 | 00 00 00 00 00 00 00 00 |tabase..|........|
|00002d60| 05 00 00 00 08 00 27 50 | 50 5f 52 42 53 27 17 00 |......'P|P_RBS'..|
|00002d70| 4f 52 41 43 4c 45 20 52 | 6f 6c 6c 62 61 63 6b 20 |ORACLE R|ollback |
|00002d80| 53 65 67 6d 65 6e 74 00 | 00 00 00 00 00 00 00 00 |Segment.|........|
|00002d90| 00 05 00 00 00 08 00 27 | 50 50 5f 54 53 50 27 12 |.......'|PP_TSP'.|
|00002da0| 00 4f 52 41 43 4c 45 20 | 54 61 62 6c 65 20 53 70 |.ORACLE |Table Sp|
|00002db0| 61 63 65 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |ace.....|........|
|00002dc0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002dd0| 00 00 00 00 00 0c 00 00 | 00 16 00 56 4c 44 5f 50 |........|...VLD_P|
|00002de0| 4f 42 4a 5f 50 48 59 53 | 50 52 4f 50 5f 54 59 50 |OBJ_PHYS|PROP_TYP|
|00002df0| 45 00 00 05 00 00 00 01 | 00 00 00 0f 00 00 00 00 |E.......|........|
|00002e00| 01 00 00 00 64 00 00 00 | 00 01 00 00 00 0f 00 00 |....d...|........|
|00002e10| 00 00 04 00 00 00 00 00 | 00 00 00 02 00 00 00 00 |........|........|
|00002e20| 00 00 00 00 1b 00 00 00 | 05 00 00 00 06 00 50 50 |........|......PP|
|00002e30| 5f 41 52 43 11 00 4f 52 | 41 43 4c 45 20 41 52 43 |_ARC..OR|ACLE ARC|
|00002e40| 48 49 56 45 4c 4f 47 00 | 00 00 00 00 00 00 00 00 |HIVELOG.|........|
|00002e50| 00 05 00 00 00 06 00 50 | 50 5f 43 48 52 0e 00 4f |.......P|P_CHR..O|
|00002e60| 52 41 43 4c 45 20 43 48 | 41 52 53 45 54 00 00 00 |RACLE CH|ARSET...|
|00002e70| 00 00 00 00 00 00 00 05 | 00 00 00 06 00 50 50 5f |........|.....PP_|
|00002e80| 43 54 52 18 00 4f 52 41 | 43 4c 45 20 43 4f 4e 54 |CTR..ORA|CLE CONT|
|00002e90| 52 4f 4c 46 49 4c 45 5f | 52 45 55 53 45 00 00 00 |ROLFILE_|REUSE...|
|00002ea0| 00 00 00 00 00 00 00 05 | 00 00 00 06 00 50 50 5f |........|.....PP_|
|00002eb0| 44 41 54 0f 00 4f 52 41 | 43 4c 45 20 44 41 54 41 |DAT..ORA|CLE DATA|
|00002ec0| 46 49 4c 45 00 00 00 00 | 00 00 00 00 00 00 05 00 |FILE....|........|
|00002ed0| 00 00 06 00 50 50 5f 45 | 58 43 10 00 4f 52 41 43 |....PP_E|XC..ORAC|
|00002ee0| 4c 45 20 45 58 43 4c 55 | 53 49 56 45 00 00 00 00 |LE EXCLU|SIVE....|
|00002ef0| 00 00 00 00 00 00 05 00 | 00 00 06 00 50 50 5f 46 |........|....PP_F|
|00002f00| 52 47 16 00 4f 52 41 43 | 4c 45 20 46 52 45 45 4c |RG..ORAC|LE FREEL|
|00002f10| 49 53 54 20 47 52 4f 55 | 50 53 00 00 00 00 00 00 |IST GROU|PS......|
|00002f20| 00 00 00 00 05 00 00 00 | 06 00 50 50 5f 46 52 4c |........|..PP_FRL|
|00002f30| 10 00 4f 52 41 43 4c 45 | 20 46 52 45 45 4c 49 53 |..ORACLE| FREELIS|
|00002f40| 54 53 00 00 00 00 00 00 | 00 00 00 00 05 00 00 00 |TS......|........|
|00002f50| 06 00 50 50 5f 49 4e 49 | 0e 00 4f 52 41 43 4c 45 |..PP_INI|..ORACLE|
|00002f60| 20 49 4e 49 54 49 41 4c | 00 00 00 00 00 00 00 00 | INITIAL|........|
|00002f70| 00 00 05 00 00 00 06 00 | 50 50 5f 49 4e 54 0f 00 |........|PP_INT..|
|00002f80| 4f 52 41 43 4c 45 20 49 | 4e 49 54 52 41 4e 53 00 |ORACLE I|NITRANS.|
|00002f90| 00 00 00 00 00 00 00 00 | 00 05 00 00 00 06 00 50 |........|.......P|
|00002fa0| 50 5f 4c 47 46 0e 00 4f | 52 41 43 4c 45 20 4c 4f |P_LGF..O|RACLE LO|
|00002fb0| 47 46 49 4c 45 00 00 00 | 00 00 00 00 00 00 00 05 |GFILE...|........|
|00002fc0| 00 00 00 06 00 50 50 5f | 4d 4e 45 11 00 4f 52 41 |.....PP_|MNE..ORA|
|00002fd0| 43 4c 45 20 4d 49 4e 45 | 58 54 45 4e 54 53 00 00 |CLE MINE|XTENTS..|
|00002fe0| 00 00 00 00 00 00 00 00 | 05 00 00 00 06 00 50 50 |........|......PP|
|00002ff0| 5f 4d 58 44 13 00 4f 52 | 41 43 4c 45 20 4d 41 58 |_MXD..OR|ACLE MAX|
|00003000| 44 41 54 41 46 49 4c 45 | 53 00 00 00 00 00 00 00 |DATAFILE|S.......|
|00003010| 00 00 00 05 00 00 00 06 | 00 50 50 5f 4d 58 45 11 |........|.PP_MXE.|
|00003020| 00 4f 52 41 43 4c 45 20 | 4d 41 58 45 58 54 45 4e |.ORACLE |MAXEXTEN|
|00003030| 54 53 00 00 00 00 00 00 | 00 00 00 00 05 00 00 00 |TS......|........|
|00003040| 06 00 50 50 5f 4d 58 46 | 12 00 4f 52 41 43 4c 45 |..PP_MXF|..ORACLE|
|00003050| 20 4d 41 58 4c 4f 47 46 | 49 4c 45 53 00 00 00 00 | MAXLOGF|ILES....|
|00003060| 00 00 00 00 00 00 05 00 | 00 00 06 00 50 50 5f 4d |........|....PP_M|
|00003070| 58 48 11 00 4f 52 41 43 | 4c 45 20 4d 41 58 4c 4f |XH..ORAC|LE MAXLO|
|00003080| 47 48 49 53 54 00 00 00 | 00 00 00 00 00 00 00 05 |GHIST...|........|
|00003090| 00 00 00 06 00 50 50 5f | 4d 58 49 13 00 4f 52 41 |.....PP_|MXI..ORA|
|000030a0| 43 4c 45 20 4d 41 58 49 | 4e 53 54 41 4e 43 45 53 |CLE MAXI|NSTANCES|
|000030b0| 00 00 00 00 00 00 00 00 | 00 00 05 00 00 00 06 00 |........|........|
|000030c0| 50 50 5f 4d 58 4d 14 00 | 4f 52 41 43 4c 45 20 4d |PP_MXM..|ORACLE M|
|000030d0| 41 58 4c 4f 47 4d 45 4d | 42 45 52 53 00 00 00 00 |AXLOGMEM|BERS....|
|000030e0| 00 00 00 00 00 00 05 00 | 00 00 06 00 50 50 5f 4d |........|....PP_M|
|000030f0| 58 54 0f 00 4f 52 41 43 | 4c 45 20 4d 41 58 54 52 |XT..ORAC|LE MAXTR|
|00003100| 41 4e 53 00 00 00 00 00 | 00 00 00 00 00 05 00 00 |ANS.....|........|
|00003110| 00 06 00 50 50 5f 4e 58 | 54 0b 00 4f 52 41 43 4c |...PP_NX|T..ORACL|
|00003120| 45 20 4e 45 58 54 00 00 | 00 00 00 00 00 00 00 00 |E NEXT..|........|
|00003130| 05 00 00 00 06 00 50 50 | 5f 4f 46 4c 0e 00 4f 52 |......PP|_OFL..OR|
|00003140| 41 43 4c 45 20 4f 46 46 | 4c 49 4e 45 00 00 00 00 |ACLE OFF|LINE....|
|00003150| 00 00 00 00 00 00 05 00 | 00 00 06 00 50 50 5f 4f |........|....PP_O|
|00003160| 50 54 0e 00 4f 52 41 43 | 4c 45 20 4f 50 54 49 4d |PT..ORAC|LE OPTIM|
|00003170| 41 4c 00 00 00 00 00 00 | 00 00 00 00 05 00 00 00 |AL......|........|
|00003180| 06 00 50 50 5f 50 43 46 | 13 00 4f 52 41 43 4c 45 |..PP_PCF|..ORACLE|
|00003190| 20 50 65 72 63 65 6e 74 | 20 46 72 65 65 00 00 00 | Percent| Free...|
|000031a0| 00 00 00 00 00 00 00 05 | 00 00 00 06 00 50 50 5f |........|.....PP_|
|000031b0| 50 43 49 12 00 4f 52 41 | 43 4c 45 20 50 43 54 49 |PCI..ORA|CLE PCTI|
|000031c0| 4e 43 52 45 41 53 45 00 | 00 00 00 00 00 00 00 00 |NCREASE.|........|
|000031d0| 00 05 00 00 00 06 00 50 | 50 5f 50 43 55 13 00 4f |.......P|P_PCU..O|
|000031e0| 52 41 43 4c 45 20 50 65 | 72 63 65 6e 74 20 55 73 |RACLE Pe|rcent Us|
|000031f0| 65 64 00 00 00 00 00 00 | 00 00 00 00 05 00 00 00 |ed......|........|
|00003200| 06 00 50 50 5f 50 55 42 | 0d 00 4f 52 41 43 4c 45 |..PP_PUB|..ORACLE|
|00003210| 20 50 55 42 4c 49 43 00 | 00 00 00 00 00 00 00 00 | PUBLIC.|........|
|00003220| 00 05 00 00 00 06 00 50 | 50 5f 53 54 4f 0e 00 4f |.......P|P_STO..O|
|00003230| 52 41 43 4c 45 20 53 54 | 4f 52 41 47 45 00 00 00 |RACLE ST|ORAGE...|
|00003240| 00 00 00 00 00 00 00 05 | 00 00 00 06 00 50 50 5f |........|.....PP_|
|00003250| 54 53 50 12 00 4f 52 41 | 43 4c 45 20 54 61 62 6c |TSP..ORA|CLE Tabl|
|00003260| 65 20 53 70 61 63 65 00 | 00 00 00 00 00 00 00 00 |e Space.|........|
|00003270| 00 00 00 00 00 00 00 00 | 00 01 00 00 00 52 01 40 |........|.....R.@|
|00003280| 63 6f 6c 20 3d 20 27 50 | 50 5f 54 53 50 27 20 4f |col = 'P|P_TSP' O|
|00003290| 52 20 40 63 6f 6c 20 3d | 20 27 50 50 5f 50 43 46 |R @col =| 'PP_PCF|
|000032a0| 27 20 4f 52 20 40 63 6f | 6c 20 3d 20 27 50 50 5f |' OR @co|l = 'PP_|
|000032b0| 50 43 55 27 20 4f 52 20 | 40 63 6f 6c 20 3d 20 27 |PCU' OR |@col = '|
|000032c0| 50 50 5f 49 4e 54 27 20 | 4f 52 20 40 63 6f 6c 20 |PP_INT' |OR @col |
|000032d0| 3d 20 27 50 50 5f 4d 58 | 54 27 20 4f 52 20 40 63 |= 'PP_MX|T' OR @c|
|000032e0| 6f 6c 20 3d 20 27 50 50 | 5f 49 4e 49 27 20 4f 52 |ol = 'PP|_INI' OR|
|000032f0| 20 40 63 6f 6c 20 3d 20 | 27 50 50 5f 53 54 4f 27 | @col = |'PP_STO'|
|00003300| 20 4f 52 20 40 63 6f 6c | 20 3d 20 27 50 50 5f 4e | OR @col| = 'PP_N|
|00003310| 58 54 27 20 4f 52 20 40 | 63 6f 6c 20 3d 20 27 50 |XT' OR @|col = 'P|
|00003320| 50 5f 4d 4e 45 27 20 4f | 52 20 40 63 6f 6c 20 3d |P_MNE' O|R @col =|
|00003330| 20 27 50 50 5f 4d 58 45 | 27 20 4f 52 20 40 63 6f | 'PP_MXE|' OR @co|
|00003340| 6c 20 3d 20 27 50 50 5f | 50 43 49 27 20 4f 52 20 |l = 'PP_|PCI' OR |
|00003350| 40 63 6f 6c 20 3d 20 27 | 50 50 5f 4f 50 54 27 20 |@col = '|PP_OPT' |
|00003360| 4f 52 20 40 63 6f 6c 20 | 3d 20 27 50 50 5f 46 52 |OR @col |= 'PP_FR|
|00003370| 4c 27 20 4f 52 20 40 63 | 6f 6c 20 3d 20 27 50 50 |L' OR @c|ol = 'PP|
|00003380| 5f 46 52 47 27 20 4f 52 | 20 40 63 6f 6c 20 3d 20 |_FRG' OR| @col = |
|00003390| 27 45 50 5f 53 45 47 27 | 20 4f 52 20 40 63 6f 6c |'EP_SEG'| OR @col|
|000033a0| 20 3d 20 27 45 50 5f 54 | 42 4e 27 20 4f 52 20 40 | = 'EP_T|BN' OR @|
|000033b0| 63 6f 6c 20 3d 20 27 45 | 50 5f 51 52 59 27 20 4f |col = 'E|P_QRY' O|
|000033c0| 52 20 40 63 6f 6c 20 3d | 20 27 45 50 5f 44 41 54 |R @col =| 'EP_DAT|
|000033d0| 27 50 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |'P......|........|
|000033e0| 00 00 00 00 00 00 00 00 | 00 0c 00 00 00 11 00 56 |........|.......V|
|000033f0| 4c 44 5f 52 45 46 49 4e | 54 45 47 5f 52 55 4c 45 |LD_REFIN|TEG_RULE|
|00003400| 00 00 05 00 00 00 01 00 | 00 00 0f 00 00 00 00 01 |........|........|
|00003410| 00 00 00 64 00 00 00 00 | 01 00 00 00 0f 00 00 00 |...d....|........|
|00003420| 00 04 00 00 00 00 00 00 | 00 00 02 00 00 00 00 00 |........|........|
|00003430| 00 00 00 18 00 00 00 05 | 00 00 00 05 00 44 52 5f |........|.....DR_|
|00003440| 52 45 17 00 50 61 72 65 | 6e 74 20 44 65 6c 65 74 |RE..Pare|nt Delet|
|00003450| 65 20 52 65 73 74 72 69 | 63 74 2e 00 00 00 00 00 |e Restri|ct......|
|00003460| 00 00 00 00 00 05 00 00 | 00 05 00 44 52 5f 43 41 |........|...DR_CA|
|00003470| 16 00 50 61 72 65 6e 74 | 20 44 65 6c 65 74 65 20 |..Parent| Delete |
|00003480| 43 61 73 63 61 64 65 2e | 00 00 00 00 00 00 00 00 |Cascade.|........|
|00003490| 00 00 05 00 00 00 05 00 | 44 52 5f 53 4e 17 00 50 |........|DR_SN..P|
|000034a0| 61 72 65 6e 74 20 44 65 | 6c 65 74 65 20 53 65 74 |arent De|lete Set|
|000034b0| 20 4e 75 6c 6c 2e 00 00 | 00 00 00 00 00 00 00 00 | Null...|........|
|000034c0| 05 00 00 00 05 00 44 52 | 5f 53 44 1a 00 50 61 72 |......DR|_SD..Par|
|000034d0| 65 6e 74 20 44 65 6c 65 | 74 65 20 53 65 74 20 44 |ent Dele|te Set D|
|000034e0| 65 66 61 75 6c 74 2e 00 | 00 00 00 00 00 00 00 00 |efault..|........|
|000034f0| 00 05 00 00 00 05 00 55 | 52 5f 52 45 17 00 50 61 |.......U|R_RE..Pa|
|00003500| 72 65 6e 74 20 55 70 64 | 61 74 65 20 52 65 73 74 |rent Upd|ate Rest|
|00003510| 72 69 63 74 2e 00 00 00 | 00 00 00 00 00 00 00 05 |rict....|........|
|00003520| 00 00 00 05 00 55 52 5f | 43 41 16 00 50 61 72 65 |.....UR_|CA..Pare|
|00003530| 6e 74 20 55 70 64 61 74 | 65 20 43 61 73 63 61 64 |nt Updat|e Cascad|
|00003540| 65 2e 00 00 00 00 00 00 | 00 00 00 00 05 00 00 00 |e.......|........|
|00003550| 05 00 55 52 5f 53 4e 17 | 00 50 61 72 65 6e 74 20 |..UR_SN.|.Parent |
|00003560| 55 70 64 61 74 65 20 53 | 65 74 20 4e 75 6c 6c 2e |Update S|et Null.|
|00003570| 00 00 00 00 00 00 00 00 | 00 00 05 00 00 00 05 00 |........|........|
|00003580| 55 52 5f 53 44 1a 00 50 | 61 72 65 6e 74 20 55 70 |UR_SD..P|arent Up|
|00003590| 64 61 74 65 20 53 65 74 | 20 44 65 66 61 75 6c 74 |date Set| Default|
|000035a0| 2e 00 00 00 00 00 00 00 | 00 00 00 05 00 00 00 06 |........|........|
|000035b0| 00 49 52 5f 50 52 45 17 | 00 50 61 72 65 6e 74 20 |.IR_PRE.|.Parent |
|000035c0| 49 6e 73 65 72 74 20 52 | 65 73 74 72 69 63 74 2e |Insert R|estrict.|
|000035d0| 00 00 00 00 00 00 00 00 | 00 00 05 00 00 00 06 00 |........|........|
|000035e0| 49 52 5f 50 43 41 16 00 | 50 61 72 65 6e 74 20 49 |IR_PCA..|Parent I|
|000035f0| 6e 73 65 72 74 20 43 61 | 73 63 61 64 65 2e 00 00 |nsert Ca|scade...|
|00003600| 00 00 00 00 00 00 00 00 | 05 00 00 00 06 00 49 52 |........|......IR|
|00003610| 5f 50 53 4e 17 00 50 61 | 72 65 6e 74 20 49 6e 73 |_PSN..Pa|rent Ins|
|00003620| 65 72 74 20 53 65 74 20 | 4e 75 6c 6c 2e 00 00 00 |ert Set |Null....|
|00003630| 00 00 00 00 00 00 00 05 | 00 00 00 06 00 49 52 5f |........|.....IR_|
|00003640| 50 53 44 1a 00 50 61 72 | 65 6e 74 20 49 6e 73 65 |PSD..Par|ent Inse|
|00003650| 72 74 20 53 65 74 20 44 | 65 66 61 75 6c 74 2e 00 |rt Set D|efault..|
|00003660| 00 00 00 00 00 00 00 00 | 00 05 00 00 00 06 00 44 |........|.......D|
|00003670| 52 5f 43 52 45 15 00 43 | 68 69 6c 64 20 44 65 6c |R_CRE..C|hild Del|
|00003680| 65 74 65 20 43 61 73 63 | 61 64 65 2e 00 00 00 00 |ete Casc|ade.....|
|00003690| 00 00 00 00 00 00 05 00 | 00 00 06 00 44 52 5f 43 |........|....DR_C|
|000036a0| 43 41 15 00 43 68 69 6c | 64 20 44 65 6c 65 74 65 |CA..Chil|d Delete|
|000036b0| 20 43 61 73 63 61 64 65 | 2e 00 00 00 00 00 00 00 | Cascade|........|
|000036c0| 00 00 00 05 00 00 00 06 | 00 44 52 5f 43 53 4e 16 |........|.DR_CSN.|
|000036d0| 00 43 68 69 6c 64 20 44 | 65 6c 65 74 65 20 53 65 |.Child D|elete Se|
|000036e0| 74 20 4e 75 6c 6c 2e 00 | 00 00 00 00 00 00 00 00 |t Null..|........|
|000036f0| 00 05 00 00 00 06 00 44 | 52 5f 43 53 44 19 00 43 |.......D|R_CSD..C|
|00003700| 68 69 6c 64 20 44 65 6c | 65 74 65 20 53 65 74 20 |hild Del|ete Set |
|00003710| 44 65 66 61 75 6c 74 2e | 00 00 00 00 00 00 00 00 |Default.|........|
|00003720| 00 00 05 00 00 00 06 00 | 55 52 5f 43 52 45 16 00 |........|UR_CRE..|
|00003730| 43 68 69 6c 64 20 55 70 | 64 61 74 65 20 52 65 73 |Child Up|date Res|
|00003740| 74 72 69 63 74 2e 00 00 | 00 00 00 00 00 00 00 00 |trict...|........|
|00003750| 05 00 00 00 06 00 55 52 | 5f 43 43 41 15 00 43 68 |......UR|_CCA..Ch|
|00003760| 69 6c 64 20 55 70 64 61 | 74 65 20 43 61 73 63 61 |ild Upda|te Casca|
|00003770| 64 65 2e 00 00 00 00 00 | 00 00 00 00 00 05 00 00 |de......|........|
|00003780| 00 06 00 55 52 5f 43 53 | 4e 16 00 43 68 69 6c 64 |...UR_CS|N..Child|
|00003790| 20 55 70 64 61 74 65 20 | 53 65 74 20 4e 75 6c 6c | Update |Set Null|
|000037a0| 2e 00 00 00 00 00 00 00 | 00 00 00 05 00 00 00 06 |........|........|
|000037b0| 00 55 52 5f 43 53 44 19 | 00 43 68 69 6c 64 20 55 |.UR_CSD.|.Child U|
|000037c0| 70 64 61 74 65 20 53 65 | 74 20 44 65 66 61 75 6c |pdate Se|t Defaul|
|000037d0| 74 2e 00 00 00 00 00 00 | 00 00 00 00 05 00 00 00 |t.......|........|
|000037e0| 05 00 49 52 5f 52 45 16 | 00 43 68 69 6c 64 20 49 |..IR_RE.|.Child I|
|000037f0| 6e 73 65 72 74 20 52 65 | 73 74 72 69 63 74 2e 00 |nsert Re|strict..|
|00003800| 00 00 00 00 00 00 00 00 | 00 05 00 00 00 05 00 49 |........|.......I|
|00003810| 52 5f 43 41 15 00 43 68 | 69 6c 64 20 49 6e 73 65 |R_CA..Ch|ild Inse|
|00003820| 72 74 20 43 61 73 63 61 | 64 65 2e 00 00 00 00 00 |rt Casca|de......|
|00003830| 00 00 00 00 00 05 00 00 | 00 05 00 49 52 5f 53 4e |........|...IR_SN|
|00003840| 16 00 43 68 69 6c 64 20 | 49 6e 73 65 72 74 20 53 |..Child |Insert S|
|00003850| 65 74 20 4e 75 6c 6c 2e | 00 00 00 00 00 00 00 00 |et Null.|........|
|00003860| 00 00 05 00 00 00 05 00 | 49 52 5f 53 44 19 00 43 |........|IR_SD..C|
|00003870| 68 69 6c 64 20 49 6e 73 | 65 72 74 20 53 65 74 20 |hild Ins|ert Set |
|00003880| 44 65 66 61 75 6c 74 2e | 00 00 00 00 00 00 00 00 |Default.|........|
|00003890| 00 00 00 00 00 00 00 00 | 00 00 01 00 00 00 00 00 |........|........|
|000038a0| 50 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |P.......|........|
|000038b0| 00 00 00 00 00 00 00 00 | 0c 00 00 00 12 00 56 4c |........|......VL|
|000038c0| 44 5f 52 45 4c 5f 50 43 | 45 4e 54 5f 54 59 50 45 |D_REL_PC|ENT_TYPE|
|000038d0| 00 00 05 00 00 00 01 00 | 00 00 0f 00 00 00 00 01 |........|........|
|000038e0| 00 00 00 64 00 00 00 00 | 01 00 00 00 0f 00 00 00 |...d....|........|
|000038f0| 00 04 00 00 00 00 00 00 | 00 00 02 00 00 00 00 00 |........|........|
|00003900| 00 00 00 04 00 00 00 05 | 00 00 00 05 00 45 54 5f |........|.....ET_|
|00003910| 49 45 13 00 49 6e 64 65 | 70 65 6e 64 65 6e 74 20 |IE..Inde|pendent |
|00003920| 45 6e 74 69 74 79 2e 00 | 00 00 00 00 00 00 00 00 |Entity..|........|
|00003930| 00 05 00 00 00 05 00 45 | 54 5f 44 45 11 00 44 65 |.......E|T_DE..De|
|00003940| 70 65 6e 64 65 6e 74 20 | 45 6e 74 69 74 79 2e 00 |pendent |Entity..|
|00003950| 00 00 00 00 00 00 00 00 | 00 05 00 00 00 05 00 53 |........|.......S|
|00003960| 54 5f 43 53 11 00 43 6f | 6d 70 6c 65 74 65 20 73 |T_CS..Co|mplete s|
|00003970| 75 62 74 79 70 65 2e 00 | 00 00 00 00 00 00 00 00 |ubtype..|........|
|00003980| 00 05 00 00 00 05 00 53 | 54 5f 49 53 13 00 49 6e |.......S|T_IS..In|
|00003990| 63 6f 6d 70 6c 65 74 65 | 20 73 75 62 74 79 70 65 |complete| subtype|
|000039a0| 2e 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000039b0| 00 00 00 01 00 00 00 20 | 00 40 63 6f 6c 20 3d 20 |....... |.@col = |
|000039c0| 27 45 54 5f 49 45 27 20 | 4f 52 20 40 63 6f 6c 20 |'ET_IE' |OR @col |
|000039d0| 3d 20 27 45 54 5f 44 45 | 27 50 00 00 00 00 00 00 |= 'ET_DE|'P......|
|000039e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000039f0| 00 0c 00 00 00 15 00 56 | 4c 44 5f 52 45 4c 41 54 |.......V|LD_RELAT|
|00003a00| 49 4f 4e 53 48 49 50 5f | 54 59 50 45 2e 00 40 56 |IONSHIP_|TYPE..@V|
|00003a10| 41 4c 55 45 20 49 4e 20 | 28 27 52 54 5f 49 44 27 |ALUE IN |('RT_ID'|
|00003a20| 2c 20 27 52 54 5f 4e 49 | 27 2c 20 27 52 54 5f 53 |, 'RT_NI|', 'RT_S|
|00003a30| 43 27 2c 20 27 52 54 5f | 4d 4d 27 29 05 00 00 00 |C', 'RT_|MM')....|
|00003a40| 01 00 00 00 0f 00 00 00 | 00 01 00 00 00 64 00 00 |........|.....d..|
|00003a50| 00 00 01 00 00 00 0f 00 | 00 00 00 04 00 00 00 00 |........|........|
|00003a60| 00 00 00 00 02 00 00 00 | 00 00 00 00 00 04 00 00 |........|........|
|00003a70| 00 05 00 00 00 07 00 27 | 52 54 5f 49 44 27 19 00 |.......'|RT_ID'..|
|00003a80| 49 64 65 6e 74 69 66 79 | 69 6e 67 20 72 65 6c 61 |Identify|ing rela|
|00003a90| 74 69 6f 6e 73 68 69 70 | 2e 00 00 00 00 00 00 00 |tionship|........|
|00003aa0| 00 00 00 05 00 00 00 07 | 00 27 52 54 5f 4e 49 27 |........|.'RT_NI'|
|00003ab0| 1d 00 4e 6f 6e 2d 69 64 | 65 6e 74 69 66 79 69 6e |..Non-id|entifyin|
|00003ac0| 67 20 72 65 6c 61 74 69 | 6f 6e 73 68 69 70 2e 00 |g relati|onship..|
|00003ad0| 00 00 00 00 00 00 00 00 | 00 05 00 00 00 07 00 27 |........|.......'|
|00003ae0| 52 54 5f 53 43 27 19 00 | 53 75 62 74 79 70 65 20 |RT_SC'..|Subtype |
|00003af0| 52 65 6c 61 74 69 6f 6e | 73 68 69 70 20 4c 65 67 |Relation|ship Leg|
|00003b00| 2e 00 00 00 00 00 00 00 | 00 00 00 05 00 00 00 07 |........|........|
|00003b10| 00 27 52 54 5f 4d 4d 27 | 1a 00 4d 61 6e 79 2d 74 |.'RT_MM'|..Many-t|
|00003b20| 6f 2d 6d 61 6e 79 20 72 | 65 6c 61 74 69 6f 6e 73 |o-many r|elations|
|00003b30| 68 69 70 2e 00 00 00 00 | 00 00 00 00 00 00 00 00 |hip.....|........|
|00003b40| 00 00 01 00 00 00 01 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003b50| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003b60| 00 00 00 00 0c 00 00 00 | 13 00 56 4c 44 5f 52 50 |........|..VLD_RP|
|00003b70| 54 5f 4f 50 54 5f 4d 56 | 5f 54 59 50 45 10 00 40 |T_OPT_MV|_TYPE..@|
|00003b80| 56 41 4c 55 45 20 49 4e | 20 28 30 2c 20 31 29 05 |VALUE IN| (0, 1).|
|00003b90| 00 00 00 01 00 00 00 0f | 00 00 00 00 01 00 00 00 |........|........|
|00003ba0| 64 00 00 00 00 01 00 00 | 00 0f 00 00 00 00 04 00 |d.......|........|
|00003bb0| 00 00 00 00 00 00 00 02 | 00 00 00 00 00 00 00 00 |........|........|
|00003bc0| 02 00 00 00 05 00 00 00 | 01 00 30 1b 00 4f 70 74 |........|..0..Opt|
|00003bd0| 69 6f 6e 20 69 73 20 6e | 6f 74 20 6d 75 6c 74 69 |ion is n|ot multi|
|00003be0| 2d 76 61 6c 75 65 64 2e | 00 00 00 00 00 00 00 00 |-valued.|........|
|00003bf0| 00 00 05 00 00 00 01 00 | 31 17 00 4f 70 74 69 6f |........|1..Optio|
|00003c00| 6e 20 69 73 20 6d 75 6c | 74 69 2d 76 61 6c 75 65 |n is mul|ti-value|
|00003c10| 64 2e 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |d.......|........|
|00003c20| 01 00 00 00 01 00 00 00 | 00 00 50 00 00 00 00 00 |........|..P.....|
|00003c30| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003c40| 00 00 0c 00 00 00 0c 00 | 56 4c 44 5f 52 50 54 5f |........|VLD_RPT_|
|00003c50| 54 59 50 45 00 00 05 00 | 00 00 01 00 00 00 0f 00 |TYPE....|........|
|00003c60| 00 00 00 01 00 00 00 64 | 00 00 00 00 01 00 00 00 |.......d|........|
|00003c70| 0f 00 00 00 00 04 00 00 | 00 00 00 00 00 00 02 00 |........|........|
|00003c80| 00 00 00 00 00 00 00 05 | 00 00 00 05 00 00 00 06 |........|........|
|00003c90| 00 52 45 5f 45 4e 54 0e | 00 45 6e 74 69 74 79 20 |.RE_ENT.|.Entity |
|00003ca0| 52 65 70 6f 72 74 2e 00 | 00 00 00 00 00 00 00 00 |Report..|........|
|00003cb0| 00 05 00 00 00 06 00 52 | 45 5f 52 45 4c 14 00 52 |.......R|E_REL..R|
|00003cc0| 65 6c 61 74 69 6f 6e 73 | 68 69 70 20 52 65 70 6f |elations|hip Repo|
|00003cd0| 72 74 2e 00 00 00 00 00 | 00 00 00 00 00 05 00 00 |rt......|........|
|00003ce0| 00 06 00 52 45 5f 41 54 | 54 11 00 41 74 74 72 69 |...RE_AT|T..Attri|
|00003cf0| 62 75 74 65 20 52 65 70 | 6f 72 74 2e 00 00 00 00 |bute Rep|ort.....|
|00003d00| 00 00 00 00 00 00 05 00 | 00 00 06 00 52 45 5f 43 |........|....RE_C|
|00003d10| 4f 4e 12 00 43 6f 6e 73 | 74 72 61 69 6e 74 20 52 |ON..Cons|traint R|
|00003d20| 65 70 6f 72 74 2e 00 00 | 00 00 00 00 00 00 00 00 |eport...|........|
|00003d30| 05 00 00 00 06 00 52 45 | 5f 53 43 48 0e 00 53 63 |......RE|_SCH..Sc|
|00003d40| 68 65 6d 61 20 52 65 70 | 6f 72 74 2e 00 00 00 00 |hema Rep|ort.....|
|00003d50| 00 00 00 00 00 00 00 00 | 00 00 01 00 00 00 01 00 |........|........|
|00003d60| 00 00 00 00 50 00 00 00 | 00 00 00 00 00 00 00 00 |....P...|........|
|00003d70| 00 00 00 00 00 00 00 00 | 00 00 00 00 0c 00 00 00 |........|........|
|00003d80| 10 00 56 4c 44 5f 53 55 | 42 54 59 50 45 5f 54 59 |..VLD_SU|BTYPE_TY|
|00003d90| 50 45 00 00 05 00 00 00 | 01 00 00 00 0f 00 00 00 |PE......|........|
|00003da0| 00 01 00 00 00 64 00 00 | 00 00 01 00 00 00 0f 00 |.....d..|........|
|00003db0| 00 00 00 04 00 00 00 00 | 00 00 00 00 02 00 00 00 |........|........|
|00003dc0| 00 00 00 00 00 02 00 00 | 00 05 00 00 00 07 00 27 |........|.......'|
|00003dd0| 53 54 5f 43 53 27 70 00 | 43 6f 6d 70 6c 65 74 65 |ST_CS'p.|Complete|
|00003de0| 20 45 52 57 49 4e 20 53 | 55 42 54 59 50 45 20 52 | ERWIN S|UBTYPE R|
|00003df0| 45 4c 41 54 49 4f 4e 53 | 48 49 50 2e 20 20 45 61 |ELATIONS|HIP. Ea|
|00003e00| 63 68 20 69 6e 73 74 61 | 6e 63 65 20 6f 66 20 74 |ch insta|nce of t|
|00003e10| 68 65 0d 0a 67 65 6e 65 | 72 61 6c 69 7a 61 74 69 |he..gene|ralizati|
|00003e20| 6f 6e 20 62 65 6c 6f 6e | 67 73 20 74 6f 20 6f 6e |on belon|gs to on|
|00003e30| 65 20 61 6e 64 20 6f 6e | 6c 79 20 6f 6e 65 20 63 |e and on|ly one c|
|00003e40| 61 74 65 67 6f 72 79 2e | 00 00 00 00 00 00 00 00 |ategory.|........|
|00003e50| 00 00 05 00 00 00 07 00 | 27 53 54 5f 49 53 27 71 |........|'ST_IS'q|
|00003e60| 00 49 6e 63 6f 6d 70 6c | 65 74 65 20 45 52 57 49 |.Incompl|ete ERWI|
|00003e70| 4e 20 53 55 42 54 59 50 | 45 20 52 45 4c 41 54 49 |N SUBTYP|E RELATI|
|00003e80| 4f 4e 53 48 49 50 2e 20 | 20 45 61 63 68 20 69 6e |ONSHIP. | Each in|
|00003e90| 73 74 61 6e 63 65 20 6f | 66 20 74 68 65 20 0d 0a |stance o|f the ..|
|00003ea0| 67 65 6e 65 72 61 6c 69 | 7a 61 74 69 6f 6e 20 62 |generali|zation b|
|00003eb0| 65 6c 6f 6e 67 73 20 74 | 6f 20 7a 65 72 6f 2c 20 |elongs t|o zero, |
|00003ec0| 6f 72 20 6f 6e 65 20 63 | 61 74 65 67 6f 72 69 65 |or one c|ategorie|
|00003ed0| 73 2e 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |s.......|........|
|00003ee0| 01 00 00 00 01 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003ef0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003f00| 00 00 0c 00 00 00 0f 00 | 56 4c 44 5f 54 41 52 47 |........|VLD_TARG|
|00003f10| 45 54 5f 44 42 4d 53 00 | 00 05 00 00 00 01 00 00 |ET_DBMS.|........|
|00003f20| 00 0f 00 00 00 00 01 00 | 00 00 64 00 00 00 00 01 |........|..d.....|
|00003f30| 00 00 00 0f 00 00 00 00 | 04 00 00 00 00 00 00 00 |........|........|
|00003f40| 00 02 00 00 00 00 00 00 | 00 00 0e 00 00 00 05 00 |........|........|
|00003f50| 00 00 07 00 27 54 44 5f | 55 4e 27 17 00 55 6e 73 |....'TD_|UN'..Uns|
|00003f60| 75 70 70 6f 72 74 65 64 | 20 54 61 72 67 65 74 20 |upported| Target |
|00003f70| 44 42 4d 53 00 00 00 00 | 00 00 00 00 00 00 05 00 |DBMS....|........|
|00003f80| 00 00 07 00 27 54 44 5f | 4e 57 27 0b 00 4e 65 74 |....'TD_|NW'..Net|
|00003f90| 77 61 72 65 20 53 51 4c | 00 00 00 00 00 00 00 00 |ware SQL|........|
|00003fa0| 00 00 05 00 00 00 07 00 | 27 54 44 5f 44 42 27 03 |........|'TD_DB'.|
|00003fb0| 00 44 42 32 00 00 00 00 | 00 00 00 00 00 00 05 00 |.DB2....|........|
|00003fc0| 00 00 07 00 27 54 44 5f | 53 42 27 0d 00 47 75 70 |....'TD_|SB'..Gup|
|00003fd0| 74 61 20 53 51 4c 42 61 | 73 65 00 00 00 00 00 00 |ta SQLBa|se......|
|00003fe0| 00 00 00 00 05 00 00 00 | 07 00 27 54 44 5f 53 53 |........|..'TD_SS|
|00003ff0| 27 14 00 4d 69 63 72 6f | 73 6f 66 74 20 53 51 4c |'..Micro|soft SQL|
|00004000| 20 53 65 72 76 65 72 00 | 00 00 00 00 00 00 00 00 | Server.|........|
|00004010| 00 05 00 00 00 07 00 27 | 54 44 5f 53 59 27 06 00 |.......'|TD_SY'..|
|00004020| 53 79 62 61 73 65 00 00 | 00 00 00 00 00 00 00 00 |Sybase..|........|
|00004030| 05 00 00 00 07 00 27 54 | 44 5f 4f 52 27 06 00 4f |......'T|D_OR'..O|
|00004040| 52 41 43 4c 45 00 00 00 | 00 00 00 00 00 00 00 05 |RACLE...|........|
|00004050| 00 00 00 07 00 27 54 44 | 5f 49 4e 27 06 00 49 6e |.....'TD|_IN'..In|
|00004060| 67 72 65 73 00 00 00 00 | 00 00 00 00 00 00 05 00 |gres....|........|
|00004070| 00 00 07 00 27 54 44 5f | 49 58 27 08 00 49 6e 66 |....'TD_|IX'..Inf|
|00004080| 6f 72 6d 69 78 00 00 00 | 00 00 00 00 00 00 00 05 |ormix...|........|
|00004090| 00 00 00 07 00 27 54 44 | 5f 52 44 27 03 00 52 44 |.....'TD|_RD'..RD|
|000040a0| 42 00 00 00 00 00 00 00 | 00 00 00 05 00 00 00 07 |B.......|........|
|000040b0| 00 27 54 44 5f 44 34 27 | 08 00 44 42 61 73 65 20 |.'TD_D4'|..DBase |
|000040c0| 49 56 00 00 00 00 00 00 | 00 00 00 00 05 00 00 00 |IV......|........|
|000040d0| 07 00 27 54 44 5f 44 33 | 27 0a 00 44 42 61 73 65 |..'TD_D3|'..DBase|
|000040e0| 20 49 49 49 2b 00 00 00 | 00 00 00 00 00 00 00 05 | III+...|........|
|000040f0| 00 00 00 07 00 27 54 44 | 5f 46 50 27 10 00 4d 69 |.....'TD|_FP'..Mi|
|00004100| 63 72 6f 73 6f 66 74 20 | 46 6f 78 50 72 6f 00 00 |crosoft |FoxPro..|
|00004110| 00 00 00 00 00 00 00 00 | 05 00 00 00 07 00 27 54 |........|......'T|
|00004120| 44 5f 43 4c 27 07 00 43 | 6c 69 70 70 65 72 00 00 |D_CL'..C|lipper..|
|00004130| 00 00 00 00 00 00 00 00 | 00 00 00 00 01 00 00 00 |........|........|
|00004140| 01 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004150| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 0c 00 |........|........|
|00004160| 00 00 0b 00 56 4c 44 5f | 54 42 5f 54 59 50 45 00 |....VLD_|TB_TYPE.|
|00004170| 00 05 00 00 00 01 00 00 | 00 0f 00 00 00 00 01 00 |........|........|
|00004180| 00 00 64 00 00 00 00 01 | 00 00 00 0f 00 00 00 00 |..d.....|........|
|00004190| 04 00 00 00 00 00 00 00 | 00 02 00 00 00 00 00 00 |........|........|
|000041a0| 00 00 01 00 00 00 05 00 | 00 00 07 00 27 54 42 5f |........|....'TB_|
|000041b0| 54 42 27 19 00 54 79 70 | 65 20 63 6f 64 65 20 66 |TB'..Typ|e code f|
|000041c0| 6f 72 20 54 45 58 54 20 | 42 4c 4f 43 4b 2e 00 00 |or TEXT |BLOCK...|
|000041d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000041e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000041f0| 0c 00 00 00 0e 00 56 4c | 44 5f 54 45 4d 50 4c 5f |......VL|D_TEMPL_|
|00004200| 54 59 50 45 00 00 05 00 | 00 00 01 00 00 00 0f 00 |TYPE....|........|
|00004210| 00 00 00 01 00 00 00 64 | 00 00 00 00 01 00 00 00 |.......d|........|
|00004220| 0f 00 00 00 00 04 00 00 | 00 00 00 00 00 00 02 00 |........|........|
|00004230| 00 00 00 00 00 00 00 02 | 00 00 00 05 00 00 00 05 |........|........|
|00004240| 00 54 52 5f 55 53 16 00 | 55 73 65 72 20 44 65 66 |.TR_US..|User Def|
|00004250| 69 6e 65 64 20 54 65 6d | 70 6c 61 74 65 2e 00 00 |ined Tem|plate...|
|00004260| 00 00 00 00 00 00 00 00 | 05 00 00 00 05 00 54 52 |........|......TR|
|00004270| 5f 42 49 12 00 42 75 69 | 6c 74 2d 49 6e 20 54 65 |_BI..Bui|lt-In Te|
|00004280| 6d 70 6c 61 74 65 2e 00 | 00 00 00 00 00 00 00 00 |mplate..|........|
|00004290| 00 00 00 00 00 01 00 00 | 00 01 00 00 00 00 00 50 |........|.......P|
|000042a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000042b0| 00 00 00 00 00 00 00 0c | 00 00 00 10 00 56 4c 44 |........|.....VLD|
|000042c0| 5f 54 52 49 47 47 45 52 | 5f 54 59 50 45 00 00 05 |_TRIGGER|_TYPE...|
|000042d0| 00 00 00 01 00 00 00 0f | 00 00 00 00 01 00 00 00 |........|........|
|000042e0| 64 00 00 00 00 01 00 00 | 00 0f 00 00 00 00 04 00 |d.......|........|
|000042f0| 00 00 00 00 00 00 00 02 | 00 00 00 00 00 00 00 00 |........|........|
|00004300| 07 00 00 00 05 00 00 00 | 04 00 54 52 5f 44 0f 00 |........|..TR_D..|
|00004310| 44 65 6c 65 74 65 20 54 | 72 69 67 67 65 72 2e 00 |Delete T|rigger..|
|00004320| 00 00 00 00 00 00 00 00 | 00 05 00 00 00 04 00 54 |........|.......T|
|00004330| 52 5f 55 0f 00 55 70 64 | 61 74 65 20 54 72 69 67 |R_U..Upd|ate Trig|
|00004340| 67 65 72 2e 00 00 00 00 | 00 00 00 00 00 00 05 00 |ger.....|........|
|00004350| 00 00 04 00 54 52 5f 49 | 0f 00 49 6e 73 65 72 74 |....TR_I|..Insert|
|00004360| 20 54 72 69 67 67 65 72 | 2e 00 00 00 00 00 00 00 | Trigger|........|
|00004370| 00 00 00 05 00 00 00 05 | 00 54 52 5f 44 55 1a 00 |........|.TR_DU..|
|00004380| 44 65 6c 65 74 65 20 61 | 6e 64 20 55 70 64 61 74 |Delete a|nd Updat|
|00004390| 65 20 54 72 69 67 67 65 | 72 2e 00 00 00 00 00 00 |e Trigge|r.......|
|000043a0| 00 00 00 00 05 00 00 00 | 05 00 54 52 5f 44 49 1a |........|..TR_DI.|
|000043b0| 00 44 65 6c 65 74 65 20 | 61 6e 64 20 49 6e 73 65 |.Delete |and Inse|
|000043c0| 72 74 20 54 72 69 67 67 | 65 72 2e 00 00 00 00 00 |rt Trigg|er......|
|000043d0| 00 00 00 00 00 05 00 00 | 00 05 00 54 52 5f 49 55 |........|...TR_IU|
|000043e0| 1a 00 49 6e 73 65 72 74 | 20 61 6e 64 20 55 70 64 |..Insert| and Upd|
|000043f0| 61 74 65 20 54 72 69 67 | 67 65 72 2e 00 00 00 00 |ate Trig|ger.....|
|00004400| 00 00 00 00 00 00 05 00 | 00 00 06 00 54 52 5f 44 |........|....TR_D|
|00004410| 49 55 22 00 44 65 6c 65 | 74 65 2c 20 49 6e 73 65 |IU".Dele|te, Inse|
|00004420| 72 74 20 61 6e 64 20 55 | 70 64 61 74 65 20 54 72 |rt and U|pdate Tr|
|00004430| 69 67 67 65 72 2e 00 00 | 00 00 00 00 00 00 00 00 |igger...|........|
|00004440| 00 00 00 00 01 00 00 00 | 01 00 00 00 00 00 50 00 |........|......P.|
|00004450| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004460| 00 00 00 00 00 00 0c 00 | 00 00 18 00 56 4c 44 5f |........|....VLD_|
|00004470| 56 41 4c 49 44 41 54 49 | 4f 4e 5f 52 55 4c 45 5f |VALIDATI|ON_RULE_|
|00004480| 54 59 50 45 00 00 05 00 | 00 00 01 00 00 00 0f 00 |TYPE....|........|
|00004490| 00 00 00 01 00 00 00 64 | 00 00 00 00 01 00 00 00 |.......d|........|
|000044a0| 0f 00 00 00 00 04 00 00 | 00 00 00 00 00 00 02 00 |........|........|
|000044b0| 00 00 00 00 00 00 00 02 | 00 00 00 05 00 00 00 08 |........|........|
|000044c0| 00 27 56 52 5f 43 4c 49 | 27 16 00 43 6c 69 65 6e |.'VR_CLI|'..Clien|
|000044d0| 74 20 56 61 6c 69 64 61 | 74 69 6f 6e 20 52 75 6c |t Valida|tion Rul|
|000044e0| 65 00 00 00 00 00 00 00 | 00 00 00 05 00 00 00 08 |e.......|........|
|000044f0| 00 27 56 52 5f 53 56 52 | 27 16 00 53 65 72 76 65 |.'VR_SVR|'..Serve|
|00004500| 72 20 56 61 6c 69 64 61 | 74 69 6f 6e 20 52 75 6c |r Valida|tion Rul|
|00004510| 65 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |e.......|........|
|00004520| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004530| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004540| 00 00 00 08 00 00 00 01 | 00 00 00 1e 00 00 00 00 |........|........|
|00004550| 01 00 00 00 32 00 00 00 | 00 01 00 00 00 00 00 00 |....2...|........|
|00004560| 00 00 00 00 00 00 00 00 | 00 00 00 02 00 00 00 00 |........|........|
|00004570| 00 00 00 00 04 00 00 00 | 00 00 00 00 00 04 00 00 |........|........|
|00004580| 00 00 00 00 00 00 02 00 | 00 00 00 00 00 00 00 0e |........|........|
|00004590| 00 00 00 08 00 00 00 10 | 00 65 72 77 69 6e 5f 69 |........|.erwin_i|
|000045a0| 64 5f 64 65 66 61 75 6c | 74 02 00 2d 31 00 00 00 |d_defaul|t..-1...|
|000045b0| 00 00 00 00 00 00 00 00 | 00 00 00 08 00 00 00 12 |........|........|
|000045c0| 00 65 72 77 69 6e 5f 6e | 61 6d 65 5f 64 65 66 61 |.erwin_n|ame_defa|
|000045d0| 75 6c 74 26 00 27 73 79 | 73 6e 61 6d 65 27 20 2b |ult&.'sy|sname' +|
|000045e0| 20 63 6f 6e 76 65 72 74 | 28 76 61 72 63 68 61 72 | convert|(varchar|
|000045f0| 2c 67 65 74 64 61 74 65 | 28 29 29 00 00 00 00 00 |,getdate|()).....|
|00004600| 00 00 00 00 00 00 00 00 | 00 08 00 00 00 12 00 65 |........|.......e|
|00004610| 72 77 69 6e 5f 74 79 70 | 65 5f 64 65 66 61 75 6c |rwin_typ|e_defaul|
|00004620| 74 07 00 27 54 44 5f 3f | 3f 27 00 00 00 00 00 00 |t..'TD_?|?'......|
|00004630| 00 00 00 00 00 00 00 00 | 08 00 00 00 10 00 46 69 |........|......Fi|
|00004640| 6c 6c 20 57 69 74 68 20 | 53 70 61 63 65 73 00 00 |ll With |Spaces..|
|00004650| 06 00 73 70 61 63 65 73 | 00 00 00 00 00 00 00 00 |..spaces|........|
|00004660| 00 00 00 00 08 00 00 00 | 13 00 53 65 74 20 54 6f |........|..Set To|
|00004670| 20 45 6d 70 74 79 20 53 | 74 72 69 6e 67 00 00 05 | Empty S|tring...|
|00004680| 00 65 6d 70 74 79 00 00 | 00 00 00 00 00 00 00 00 |.empty..|........|
|00004690| 00 00 08 00 00 00 0b 00 | 53 65 74 20 54 6f 20 4e |........|Set To N|
|000046a0| 75 6c 6c 00 00 04 00 6e | 75 6c 6c 00 00 00 00 00 |ull....n|ull.....|
|000046b0| 00 00 00 00 00 00 00 08 | 00 00 00 0b 00 53 65 74 |........|.....Set|
|000046c0| 20 54 6f 20 5a 65 72 6f | 00 00 01 00 30 00 00 00 | To Zero|....0...|
|000046d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000046e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000046f0| 00 00 00 00 00 00 00 05 | 00 00 00 01 00 0d 00 54 |........|.......T|
|00004700| 65 6d 70 6c 61 74 65 20 | 4e 61 6d 65 22 00 00 00 |emplate |Name"...|
|00004710| 00 01 00 0d 00 54 65 6d | 70 6c 61 74 65 20 43 6f |.....Tem|plate Co|
|00004720| 64 65 00 00 00 00 00 00 | 00 0d 00 54 65 6d 70 6c |de......|...Templ|
|00004730| 61 74 65 20 54 79 70 65 | 00 00 00 00 00 00 00 0f |ate Type|........|
|00004740| 00 54 65 6d 70 6c 61 74 | 65 20 43 53 58 20 49 64 |.Templat|e CSX Id|
|00004750| 00 00 00 00 00 02 00 00 | 00 00 00 00 00 00 9e 00 |........|........|
|00004760| 00 00 05 00 00 00 16 00 | 50 41 52 45 4e 54 20 55 |........|PARENT U|
|00004770| 50 44 41 54 45 20 52 45 | 53 54 52 49 43 54 22 02 |PDATE RE|STRICT".|
|00004780| 20 20 2f 2a 20 45 52 77 | 69 6e 20 42 75 69 6c 74 | /* ERw|in Built|
|00004790| 69 6e 20 25 44 61 74 65 | 74 69 6d 65 20 2a 2f 0d |in %Date|time */.|
|000047a0| 0a 20 20 2f 2a 20 25 50 | 61 72 65 6e 74 20 25 56 |. /* %P|arent %V|
|000047b0| 65 72 62 50 68 72 61 73 | 65 20 25 43 68 69 6c 64 |erbPhras|e %Child|
|000047c0| 20 4f 4e 20 50 41 52 45 | 4e 54 20 55 50 44 41 54 | ON PARE|NT UPDAT|
|000047d0| 45 20 52 45 53 54 52 49 | 43 54 20 2a 2f 0d 0a 20 |E RESTRI|CT */.. |
|000047e0| 20 69 66 0d 0a 20 20 20 | 20 2f 2a 20 25 25 4a 6f | if.. | /* %%Jo|
|000047f0| 69 6e 50 4b 50 4b 28 3a | 25 25 4f 6c 64 2c 3a 25 |inPKPK(:|%%Old,:%|
|00004800| 25 4e 65 77 2c 22 20 3c | 3e 20 22 2c 22 20 6f 72 |%New," <|> "," or|
|00004810| 20 22 29 20 2a 2f 0d 0a | 20 20 20 20 25 4a 6f 69 | ") */..| %Joi|
|00004820| 6e 50 4b 50 4b 28 3a 25 | 4f 6c 64 2c 3a 25 4e 65 |nPKPK(:%|Old,:%Ne|
|00004830| 77 2c 22 20 3c 3e 20 22 | 2c 22 20 6f 72 20 22 29 |w," <> "|," or ")|
|00004840| 0d 0a 20 20 74 68 65 6e | 0d 0a 20 20 20 20 73 65 |.. then|.. se|
|00004850| 6c 65 63 74 20 63 6f 75 | 6e 74 28 2a 29 20 69 6e |lect cou|nt(*) in|
|00004860| 74 6f 20 6e 75 6d 72 6f | 77 73 0d 0a 20 20 20 20 |to numro|ws.. |
|00004870| 20 20 66 72 6f 6d 20 25 | 43 68 69 6c 64 0d 0a 20 | from %|Child.. |
|00004880| 20 20 20 20 20 77 68 65 | 72 65 0d 0a 20 20 20 20 | whe|re.. |
|00004890| 20 20 20 20 2f 2a 20 20 | 25 25 4a 6f 69 6e 46 4b | /* |%%JoinFK|
|000048a0| 50 4b 28 25 43 68 69 6c | 64 2c 3a 25 25 4f 6c 64 |PK(%Chil|d,:%%Old|
|000048b0| 2c 22 20 3d 20 22 2c 22 | 20 61 6e 64 22 29 20 2a |," = ","| and") *|
|000048c0| 2f 0d 0a 20 20 20 20 20 | 20 20 20 25 4a 6f 69 6e |/.. | %Join|
|000048d0| 46 4b 50 4b 28 25 43 68 | 69 6c 64 2c 3a 25 4f 6c |FKPK(%Ch|ild,:%Ol|
|000048e0| 64 2c 22 20 3d 20 22 2c | 22 20 61 6e 64 22 29 3b |d," = ",|" and");|
|000048f0| 0d 0a 20 20 20 20 69 66 | 20 28 6e 75 6d 72 6f 77 |.. if| (numrow|
|00004900| 73 20 3e 20 30 29 0d 0a | 20 20 20 20 74 68 65 6e |s > 0)..| then|
|00004910| 20 0d 0a 20 20 20 20 20 | 20 72 61 69 73 65 5f 61 | .. | raise_a|
|00004920| 70 70 6c 69 63 61 74 69 | 6f 6e 5f 65 72 72 6f 72 |pplicati|on_error|
|00004930| 28 0d 0a 20 20 20 20 20 | 20 20 20 2d 32 30 30 30 |(.. | -2000|
|00004940| 35 2c 0d 0a 20 20 20 20 | 20 20 20 20 27 43 61 6e |5,.. | 'Can|
|00004950| 6e 6f 74 20 55 50 44 41 | 54 45 20 22 25 50 61 72 |not UPDA|TE "%Par|
|00004960| 65 6e 74 22 20 62 65 63 | 61 75 73 65 20 22 25 43 |ent" bec|ause "%C|
|00004970| 68 69 6c 64 22 20 65 78 | 69 73 74 73 2e 27 0d 0a |hild" ex|ists.'..|
|00004980| 20 20 20 20 20 20 29 3b | 0d 0a 20 20 20 20 65 6e | );|.. en|
|00004990| 64 20 69 66 3b 0d 0a 20 | 20 65 6e 64 20 69 66 3b |d if;.. | end if;|
|000049a0| 0d 0a 10 27 00 00 00 00 | 00 00 00 00 00 00 05 00 |...'....|........|
|000049b0| 00 00 15 00 50 41 52 45 | 4e 54 20 55 50 44 41 54 |....PARE|NT UPDAT|
|000049c0| 45 20 43 41 53 43 41 44 | 45 c4 01 20 20 2f 2a 20 |E CASCAD|E.. /* |
|000049d0| 45 52 77 69 6e 20 42 75 | 69 6c 74 69 6e 20 25 44 |ERwin Bu|iltin %D|
|000049e0| 61 74 65 74 69 6d 65 20 | 2a 2f 0d 0a 20 20 2f 2a |atetime |*/.. /*|
|000049f0| 20 25 50 61 72 65 6e 74 | 20 25 56 65 72 62 50 68 | %Parent| %VerbPh|
|00004a00| 72 61 73 65 20 25 43 68 | 69 6c 64 20 4f 4e 20 50 |rase %Ch|ild ON P|
|00004a10| 41 52 45 4e 54 20 55 50 | 44 41 54 45 20 43 41 53 |ARENT UP|DATE CAS|
|00004a20| 43 41 44 45 20 2a 2f 0d | 0a 20 20 69 66 0d 0a 20 |CADE */.|. if.. |
|00004a30| 20 20 20 2f 2a 20 25 25 | 4a 6f 69 6e 50 4b 50 4b | /* %%|JoinPKPK|
|00004a40| 28 3a 25 25 4f 6c 64 2c | 3a 25 25 4e 65 77 2c 22 |(:%%Old,|:%%New,"|
|00004a50| 20 3c 3e 20 22 2c 22 20 | 6f 72 20 22 29 20 2a 2f | <> "," |or ") */|
|00004a60| 0d 0a 20 20 20 20 25 4a | 6f 69 6e 50 4b 50 4b 28 |.. %J|oinPKPK(|
|00004a70| 3a 25 4f 6c 64 2c 3a 25 | 4e 65 77 2c 22 20 3c 3e |:%Old,:%|New," <>|
|00004a80| 20 22 2c 22 20 6f 72 20 | 22 29 0d 0a 20 20 74 68 | "," or |").. th|
|00004a90| 65 6e 0d 0a 20 20 20 20 | 75 70 64 61 74 65 20 25 |en.. |update %|
|00004aa0| 43 68 69 6c 64 0d 0a 20 | 20 20 20 20 20 73 65 74 |Child.. | set|
|00004ab0| 0d 0a 20 20 20 20 20 20 | 20 20 2f 2a 20 20 25 25 |.. | /* %%|
|00004ac0| 4a 6f 69 6e 46 4b 50 4b | 28 25 43 68 69 6c 64 2c |JoinFKPK|(%Child,|
|00004ad0| 3a 25 25 4e 65 77 2c 22 | 20 3d 20 22 2c 22 2c 22 |:%%New,"| = ",","|
|00004ae0| 29 20 2a 2f 0d 0a 20 20 | 20 20 20 20 20 20 25 4a |) */.. | %J|
|00004af0| 6f 69 6e 46 4b 50 4b 28 | 25 43 68 69 6c 64 2c 3a |oinFKPK(|%Child,:|
|00004b00| 25 4e 65 77 2c 22 20 3d | 20 22 2c 22 2c 22 29 0d |%New," =| ",",").|
|00004b10| 0a 20 20 20 20 20 20 77 | 68 65 72 65 0d 0a 20 20 |. w|here.. |
|00004b20| 20 20 20 20 20 20 2f 2a | 20 20 25 25 4a 6f 69 6e | /*| %%Join|
|00004b30| 46 4b 50 4b 28 25 43 68 | 69 6c 64 2c 3a 25 25 4f |FKPK(%Ch|ild,:%%O|
|00004b40| 6c 64 2c 22 20 3d 20 22 | 2c 22 20 61 6e 64 22 29 |ld," = "|," and")|
|00004b50| 20 2a 2f 0d 0a 20 20 20 | 20 20 20 20 20 25 4a 6f | */.. | %Jo|
|00004b60| 69 6e 46 4b 50 4b 28 25 | 43 68 69 6c 64 2c 3a 25 |inFKPK(%|Child,:%|
|00004b70| 4f 6c 64 2c 22 20 3d 20 | 22 2c 22 20 61 6e 64 22 |Old," = |"," and"|
|00004b80| 29 3b 0d 0a 20 20 65 6e | 64 20 69 66 3b 0d 0a 11 |);.. en|d if;...|
|00004b90| 27 00 00 00 00 00 00 00 | 00 00 00 05 00 00 00 16 |'.......|........|
|00004ba0| 00 50 41 52 45 4e 54 20 | 55 50 44 41 54 45 20 53 |.PARENT |UPDATE S|
|00004bb0| 45 54 20 4e 55 4c 4c 81 | 01 20 20 2f 2a 20 25 50 |ET NULL.|. /* %P|
|00004bc0| 61 72 65 6e 74 20 25 56 | 65 72 62 50 68 72 61 73 |arent %V|erbPhras|
|00004bd0| 65 20 25 43 68 69 6c 64 | 20 4f 4e 20 50 41 52 45 |e %Child| ON PARE|
|00004be0| 4e 54 20 55 50 44 41 54 | 45 20 53 45 54 20 4e 55 |NT UPDAT|E SET NU|
|00004bf0| 4c 4c 20 2a 2f 0d 0a 20 | 20 69 66 0d 0a 20 20 20 |LL */.. | if.. |
|00004c00| 20 2f 2a 20 25 25 4a 6f | 69 6e 50 4b 50 4b 28 3a | /* %%Jo|inPKPK(:|
|00004c10| 25 25 4f 6c 64 2c 3a 25 | 25 4e 65 77 2c 22 20 3c |%%Old,:%|%New," <|
|00004c20| 3e 20 22 2c 22 20 6f 72 | 20 22 20 2a 2f 0d 0a 20 |> "," or| " */.. |
|00004c30| 20 20 20 25 4a 6f 69 6e | 50 4b 50 4b 28 3a 25 4f | %Join|PKPK(:%O|
|00004c40| 6c 64 2c 3a 25 4e 65 77 | 2c 22 20 3c 3e 20 22 2c |ld,:%New|," <> ",|
|00004c50| 22 20 6f 72 20 22 29 0d | 0a 20 20 74 68 65 6e 0d |" or ").|. then.|
|00004c60| 0a 20 20 20 20 75 70 64 | 61 74 65 20 25 43 68 69 |. upd|ate %Chi|
|00004c70| 6c 64 0d 0a 20 20 20 20 | 20 20 73 65 74 0d 0a 20 |ld.. | set.. |
|00004c80| 20 20 20 20 20 20 20 2f | 2a 20 25 25 53 65 74 46 | /|* %%SetF|
|00004c90| 4b 28 25 43 68 69 6c 64 | 2c 4e 55 4c 4c 29 20 2a |K(%Child|,NULL) *|
|00004ca0| 2f 0d 0a 20 20 20 20 20 | 20 20 20 25 53 65 74 46 |/.. | %SetF|
|00004cb0| 4b 28 25 43 68 69 6c 64 | 2c 4e 55 4c 4c 29 0d 0a |K(%Child|,NULL)..|
|00004cc0| 20 20 20 20 20 20 77 68 | 65 72 65 0d 0a 20 20 20 | wh|ere.. |
|00004cd0| 20 20 20 20 20 2f 2a 20 | 25 25 4a 6f 69 6e 46 4b | /* |%%JoinFK|
|00004ce0| 50 4b 28 25 43 68 69 6c | 64 2c 3a 25 25 4f 6c 64 |PK(%Chil|d,:%%Old|
|00004cf0| 2c 22 20 3d 20 22 2c 22 | 2c 22 29 20 2a 2f 0d 0a |," = ","|,") */..|
|00004d00| 20 20 20 20 20 20 20 20 | 25 4a 6f 69 6e 46 4b 50 | |%JoinFKP|
|00004d10| 4b 28 25 43 68 69 6c 64 | 2c 3a 25 4f 6c 64 2c 22 |K(%Child|,:%Old,"|
|00004d20| 20 3d 20 22 2c 22 20 61 | 6e 64 22 29 3b 0d 0a 20 | = "," a|nd");.. |
|00004d30| 20 65 6e 64 20 69 66 3b | 0d 0a 12 27 00 00 00 00 | end if;|...'....|
|00004d40| 00 00 00 00 00 00 05 00 | 00 00 16 00 50 41 52 45 |........|....PARE|
|00004d50| 4e 54 20 44 45 4c 45 54 | 45 20 52 45 53 54 52 49 |NT DELET|E RESTRI|
|00004d60| 43 54 af 01 20 20 20 20 | 2f 2a 20 45 52 77 69 6e |CT.. |/* ERwin|
|00004d70| 20 42 75 69 6c 74 69 6e | 20 25 44 61 74 65 74 69 | Builtin| %Dateti|
|00004d80| 6d 65 20 2a 2f 0d 0a 20 | 20 20 20 2f 2a 20 25 50 |me */.. | /* %P|
|00004d90| 61 72 65 6e 74 20 25 56 | 65 72 62 50 68 72 61 73 |arent %V|erbPhras|
|00004da0| 65 20 25 43 68 69 6c 64 | 20 4f 4e 20 50 41 52 45 |e %Child| ON PARE|
|00004db0| 4e 54 20 44 45 4c 45 54 | 45 20 52 45 53 54 52 49 |NT DELET|E RESTRI|
|00004dc0| 43 54 20 2a 2f 0d 0a 20 | 20 20 20 73 65 6c 65 63 |CT */.. | selec|
|00004dd0| 74 20 63 6f 75 6e 74 28 | 2a 29 20 69 6e 74 6f 20 |t count(|*) into |
|00004de0| 6e 75 6d 72 6f 77 73 0d | 0a 20 20 20 20 20 20 66 |numrows.|. f|
|00004df0| 72 6f 6d 20 25 43 68 69 | 6c 64 0d 0a 20 20 20 20 |rom %Chi|ld.. |
|00004e00| 20 20 77 68 65 72 65 0d | 0a 20 20 20 20 20 20 20 | where.|. |
|00004e10| 20 2f 2a 20 20 25 25 4a | 6f 69 6e 46 4b 50 4b 28 | /* %%J|oinFKPK(|
|00004e20| 25 43 68 69 6c 64 2c 3a | 25 25 4f 6c 64 2c 22 20 |%Child,:|%%Old," |
|00004e30| 3d 20 22 2c 22 20 61 6e | 64 22 29 20 2a 2f 0d 0a |= "," an|d") */..|
|00004e40| 20 20 20 20 20 20 20 20 | 25 4a 6f 69 6e 46 4b 50 | |%JoinFKP|
|00004e50| 4b 28 25 43 68 69 6c 64 | 2c 3a 25 4f 6c 64 2c 22 |K(%Child|,:%Old,"|
|00004e60| 20 3d 20 22 2c 22 20 61 | 6e 64 22 29 3b 0d 0a 20 | = "," a|nd");.. |
|00004e70| 20 20 20 69 66 20 28 6e | 75 6d 72 6f 77 73 20 3e | if (n|umrows >|
|00004e80| 20 30 29 0d 0a 20 20 20 | 20 74 68 65 6e 0d 0a 20 | 0).. | then.. |
|00004e90| 20 20 20 20 20 72 61 69 | 73 65 5f 61 70 70 6c 69 | rai|se_appli|
|00004ea0| 63 61 74 69 6f 6e 5f 65 | 72 72 6f 72 28 0d 0a 20 |cation_e|rror(.. |
|00004eb0| 20 20 20 20 20 20 20 2d | 32 30 30 30 31 2c 0d 0a | -|20001,..|
|00004ec0| 20 20 20 20 20 20 20 20 | 27 43 61 6e 6e 6f 74 20 | |'Cannot |
|00004ed0| 44 45 4c 45 54 45 20 22 | 25 50 61 72 65 6e 74 22 |DELETE "|%Parent"|
|00004ee0| 20 62 65 63 61 75 73 65 | 20 22 25 43 68 69 6c 64 | because| "%Child|
|00004ef0| 22 20 65 78 69 73 74 73 | 2e 27 0d 0a 20 20 20 20 |" exists|.'.. |
|00004f00| 20 20 29 3b 0d 0a 20 20 | 20 20 65 6e 64 20 69 66 | );.. | end if|
|00004f10| 3b 0d 0a 14 27 00 00 00 | 00 00 00 00 00 00 00 05 |;...'...|........|
|00004f20| 00 00 00 15 00 50 41 52 | 45 4e 54 20 44 45 4c 45 |.....PAR|ENT DELE|
|00004f30| 54 45 20 43 41 53 43 41 | 44 45 ed 00 20 20 20 20 |TE CASCA|DE.. |
|00004f40| 2f 2a 20 45 52 77 69 6e | 20 42 75 69 6c 74 69 6e |/* ERwin| Builtin|
|00004f50| 20 25 44 61 74 65 74 69 | 6d 65 20 2a 2f 0d 0a 20 | %Dateti|me */.. |
|00004f60| 20 20 20 2f 2a 20 25 50 | 61 72 65 6e 74 20 25 56 | /* %P|arent %V|
|00004f70| 65 72 62 50 68 72 61 73 | 65 20 25 43 68 69 6c 64 |erbPhras|e %Child|
|00004f80| 20 4f 4e 20 50 41 52 45 | 4e 54 20 44 45 4c 45 54 | ON PARE|NT DELET|
|00004f90| 45 20 43 41 53 43 41 44 | 45 20 2a 2f 0d 0a 20 20 |E CASCAD|E */.. |
|00004fa0| 20 20 64 65 6c 65 74 65 | 20 66 72 6f 6d 20 25 43 | delete| from %C|
|00004fb0| 68 69 6c 64 0d 0a 20 20 | 20 20 20 20 77 68 65 72 |hild.. | wher|
|00004fc0| 65 0d 0a 20 20 20 20 20 | 20 20 20 2f 2a 20 20 25 |e.. | /* %|
|00004fd0| 25 4a 6f 69 6e 46 4b 50 | 4b 28 25 43 68 69 6c 64 |%JoinFKP|K(%Child|
|00004fe0| 2c 3a 25 25 4f 6c 64 2c | 22 20 3d 20 22 2c 22 20 |,:%%Old,|" = "," |
|00004ff0| 61 6e 64 22 29 20 2a 2f | 0d 0a 20 20 20 20 20 20 |and") */|.. |
|00005000| 20 20 25 4a 6f 69 6e 46 | 4b 50 4b 28 25 43 68 69 | %JoinF|KPK(%Chi|
|00005010| 6c 64 2c 3a 25 4f 6c 64 | 2c 22 20 3d 20 22 2c 22 |ld,:%Old|," = ","|
|00005020| 20 61 6e 64 22 29 3b 0d | 0a 15 27 00 00 00 00 00 | and");.|..'.....|
|00005030| 00 00 00 00 00 05 00 00 | 00 16 00 50 41 52 45 4e |........|...PAREN|
|00005040| 54 20 44 45 4c 45 54 45 | 20 53 45 54 20 4e 55 4c |T DELETE| SET NUL|
|00005050| 4c 34 01 20 20 20 20 2f | 2a 20 45 52 77 69 6e 20 |L4. /|* ERwin |
|00005060| 42 75 69 6c 74 69 6e 20 | 25 44 61 74 65 74 69 6d |Builtin |%Datetim|
|00005070| 65 20 2a 2f 0d 0a 20 20 | 20 20 2f 2a 20 25 50 61 |e */.. | /* %Pa|
|00005080| 72 65 6e 74 20 25 56 65 | 72 62 50 68 72 61 73 65 |rent %Ve|rbPhrase|
|00005090| 20 25 43 68 69 6c 64 20 | 4f 4e 20 50 41 52 45 4e | %Child |ON PAREN|
|000050a0| 54 20 44 45 4c 45 54 45 | 20 53 45 54 20 4e 55 4c |T DELETE| SET NUL|
|000050b0| 4c 20 2a 2f 0d 0a 20 20 | 20 20 75 70 64 61 74 65 |L */.. | update|
|000050c0| 20 25 43 68 69 6c 64 0d | 0a 20 20 20 20 20 20 73 | %Child.|. s|
|000050d0| 65 74 0d 0a 20 20 20 20 | 20 20 20 20 2f 2a 20 25 |et.. | /* %|
|000050e0| 25 53 65 74 46 4b 28 25 | 43 68 69 6c 64 2c 4e 55 |%SetFK(%|Child,NU|
|000050f0| 4c 4c 29 20 2a 2f 0d 0a | 20 20 20 20 20 20 20 20 |LL) */..| |
|00005100| 25 53 65 74 46 4b 28 25 | 43 68 69 6c 64 2c 4e 55 |%SetFK(%|Child,NU|
|00005110| 4c 4c 29 0d 0a 20 20 20 | 20 20 20 77 68 65 72 65 |LL).. | where|
|00005120| 0d 0a 20 20 20 20 20 20 | 20 20 2f 2a 20 25 25 4a |.. | /* %%J|
|00005130| 6f 69 6e 46 4b 50 4b 28 | 25 43 68 69 6c 64 2c 3a |oinFKPK(|%Child,:|
|00005140| 25 25 4f 6c 64 2c 22 20 | 3d 20 22 2c 22 20 61 6e |%%Old," |= "," an|
|00005150| 64 22 29 20 2a 2f 0d 0a | 20 20 20 20 20 20 20 20 |d") */..| |
|00005160| 25 4a 6f 69 6e 46 4b 50 | 4b 28 25 43 68 69 6c 64 |%JoinFKP|K(%Child|
|00005170| 2c 3a 25 4f 6c 64 2c 22 | 20 3d 20 22 2c 22 20 61 |,:%Old,"| = "," a|
|00005180| 6e 64 22 29 3b 0d 0a 16 | 27 00 00 00 00 00 00 00 |nd");...|'.......|
|00005190| 00 00 00 05 00 00 00 15 | 00 43 48 49 4c 44 20 49 |........|.CHILD I|
|000051a0| 4e 53 45 52 54 20 52 45 | 53 54 52 49 43 54 26 02 |NSERT RE|STRICT&.|
|000051b0| 20 20 20 20 2f 2a 20 45 | 52 77 69 6e 20 42 75 69 | /* E|Rwin Bui|
|000051c0| 6c 74 69 6e 20 25 44 61 | 74 65 74 69 6d 65 20 2a |ltin %Da|tetime *|
|000051d0| 2f 0d 0a 20 20 20 20 2f | 2a 20 25 50 61 72 65 6e |/.. /|* %Paren|
|000051e0| 74 20 25 56 65 72 62 50 | 68 72 61 73 65 20 25 43 |t %VerbP|hrase %C|
|000051f0| 68 69 6c 64 20 4f 4e 20 | 43 48 49 4c 44 20 49 4e |hild ON |CHILD IN|
|00005200| 53 45 52 54 20 52 45 53 | 54 52 49 43 54 20 2a 2f |SERT RES|TRICT */|
|00005210| 0d 0a 20 20 20 20 73 65 | 6c 65 63 74 20 63 6f 75 |.. se|lect cou|
|00005220| 6e 74 28 2a 29 20 69 6e | 74 6f 20 6e 75 6d 72 6f |nt(*) in|to numro|
|00005230| 77 73 0d 0a 20 20 20 20 | 20 20 66 72 6f 6d 20 25 |ws.. | from %|
|00005240| 50 61 72 65 6e 74 0d 0a | 20 20 20 20 20 20 77 68 |Parent..| wh|
|00005250| 65 72 65 0d 0a 20 20 20 | 20 20 20 20 20 2f 2a 20 |ere.. | /* |
|00005260| 25 25 4a 6f 69 6e 46 4b | 50 4b 28 3a 25 25 4e 65 |%%JoinFK|PK(:%%Ne|
|00005270| 77 2c 25 50 61 72 65 6e | 74 2c 22 20 3d 20 22 2c |w,%Paren|t," = ",|
|00005280| 22 20 61 6e 64 22 29 20 | 2a 2f 0d 0a 20 20 20 20 |" and") |*/.. |
|00005290| 20 20 20 20 25 4a 6f 69 | 6e 46 4b 50 4b 28 3a 25 | %Joi|nFKPK(:%|
|000052a0| 4e 65 77 2c 25 50 61 72 | 65 6e 74 2c 22 20 3d 20 |New,%Par|ent," = |
|000052b0| 22 2c 22 20 61 6e 64 22 | 29 3b 0d 0a 20 20 20 20 |"," and"|);.. |
|000052c0| 69 66 20 28 0d 0a 20 20 | 20 20 20 20 2f 2a 20 25 |if (.. | /* %|
|000052d0| 25 4e 6f 74 6e 75 6c 6c | 46 4b 28 3a 25 25 4e 65 |%Notnull|FK(:%%Ne|
|000052e0| 77 2c 22 20 69 73 20 6e | 6f 74 20 6e 75 6c 6c 20 |w," is n|ot null |
|000052f0| 61 6e 64 22 29 20 2a 2f | 0d 0a 20 20 20 20 20 20 |and") */|.. |
|00005300| 25 4e 6f 74 6e 75 6c 6c | 46 4b 28 3a 25 4e 65 77 |%Notnull|FK(:%New|
|00005310| 2c 22 20 69 73 20 6e 6f | 74 20 6e 75 6c 6c 20 61 |," is no|t null a|
|00005320| 6e 64 22 29 0d 0a 20 20 | 20 20 20 20 6e 75 6d 72 |nd").. | numr|
|00005330| 6f 77 73 20 3d 20 30 0d | 0a 20 20 20 20 29 0d 0a |ows = 0.|. )..|
|00005340| 20 20 20 20 74 68 65 6e | 0d 0a 20 20 20 20 20 20 | then|.. |
|00005350| 72 61 69 73 65 5f 61 70 | 70 6c 69 63 61 74 69 6f |raise_ap|plicatio|
|00005360| 6e 5f 65 72 72 6f 72 28 | 0d 0a 20 20 20 20 20 20 |n_error(|.. |
|00005370| 20 20 2d 32 30 30 30 32 | 2c 0d 0a 20 20 20 20 20 | -20002|,.. |
|00005380| 20 20 20 27 43 61 6e 6e | 6f 74 20 49 4e 53 45 52 | 'Cann|ot INSER|
|00005390| 54 20 22 25 43 68 69 6c | 64 22 20 62 65 63 61 75 |T "%Chil|d" becau|
|000053a0| 73 65 20 22 25 50 61 72 | 65 6e 74 22 20 64 6f 65 |se "%Par|ent" doe|
|000053b0| 73 20 6e 6f 74 20 65 78 | 69 73 74 2e 27 0d 0a 20 |s not ex|ist.'.. |
|000053c0| 20 20 20 20 20 29 3b 0d | 0a 20 20 20 20 65 6e 64 | );.|. end|
|000053d0| 20 69 66 3b 0d 0a 18 27 | 00 00 00 00 00 00 00 00 | if;...'|........|
|000053e0| 00 00 05 00 00 00 14 00 | 43 48 49 4c 44 20 49 4e |........|CHILD IN|
|000053f0| 53 45 52 54 20 43 41 53 | 43 41 44 45 05 02 20 20 |SERT CAS|CADE.. |
|00005400| 2f 2a 20 45 52 77 69 6e | 20 42 75 69 6c 74 69 6e |/* ERwin| Builtin|
|00005410| 20 25 44 61 74 65 74 69 | 6d 65 20 2a 2f 0d 0a 20 | %Dateti|me */.. |
|00005420| 20 2f 2a 20 25 50 61 72 | 65 6e 74 20 25 56 65 72 | /* %Par|ent %Ver|
|00005430| 62 50 68 72 61 73 65 20 | 25 43 68 69 6c 64 20 4f |bPhrase |%Child O|
|00005440| 4e 20 43 48 49 4c 44 20 | 49 4e 53 45 52 54 20 43 |N CHILD |INSERT C|
|00005450| 41 53 43 41 44 45 20 2a | 2f 0d 0a 20 20 20 20 69 |ASCADE *|/.. i|
|00005460| 6e 73 65 72 74 20 69 6e | 74 6f 20 25 50 61 72 65 |nsert in|to %Pare|
|00005470| 6e 74 20 28 25 50 61 72 | 65 6e 74 50 4b 28 22 2c |nt (%Par|entPK(",|
|00005480| 22 2c 29 29 0d 0a 20 20 | 20 20 20 20 73 65 6c 65 |",)).. | sele|
|00005490| 63 74 20 25 43 68 69 6c | 64 46 4b 28 22 2c 22 2c |ct %Chil|dFK(",",|
|000054a0| 29 0d 0a 20 20 20 20 20 | 20 20 20 66 72 6f 6d 20 |).. | from |
|000054b0| 25 43 68 69 6c 64 0d 0a | 20 20 20 20 20 20 20 20 |%Child..| |
|000054c0| 77 68 65 72 65 0d 0a 20 | 20 20 20 20 20 20 20 20 |where.. | |
|000054d0| 20 2f 2a 20 25 25 4e 6f | 74 6e 75 6c 6c 46 4b 28 | /* %%No|tnullFK(|
|000054e0| 3a 25 25 4e 65 77 2c 22 | 20 69 73 20 6e 6f 74 20 |:%%New,"| is not |
|000054f0| 6e 75 6c 6c 20 61 6e 64 | 22 29 20 2a 2f 0d 0a 20 |null and|") */.. |
|00005500| 20 20 20 20 20 20 20 20 | 20 25 4e 6f 74 6e 75 6c | | %Notnul|
|00005510| 6c 46 4b 28 3a 25 4e 65 | 77 2c 22 20 69 73 20 6e |lFK(:%Ne|w," is n|
|00005520| 6f 74 20 6e 75 6c 6c 20 | 61 6e 64 22 29 0d 0a 20 |ot null |and").. |
|00005530| 20 20 20 20 20 20 20 20 | 20 6e 6f 74 20 65 78 69 | | not exi|
|00005540| 73 74 73 20 28 0d 0a 20 | 20 20 20 20 20 20 20 20 |sts (.. | |
|00005550| 20 20 20 73 65 6c 65 63 | 74 20 2a 20 66 72 6f 6d | selec|t * from|
|00005560| 20 25 50 61 72 65 6e 74 | 0d 0a 20 20 20 20 20 20 | %Parent|.. |
|00005570| 20 20 20 20 20 20 20 20 | 77 68 65 72 65 0d 0a 20 | |where.. |
|00005580| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 2f | | /|
|00005590| 2a 20 25 25 4a 6f 69 6e | 46 4b 50 4b 28 3a 25 25 |* %%Join|FKPK(:%%|
|000055a0| 4e 65 77 2c 25 50 61 72 | 65 6e 74 2c 22 20 3d 20 |New,%Par|ent," = |
|000055b0| 22 2c 22 20 61 6e 64 22 | 29 20 2a 2f 0d 0a 20 20 |"," and"|) */.. |
|000055c0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 25 4a | | %J|
|000055d0| 6f 69 6e 46 4b 50 4b 28 | 3a 25 4e 65 77 2c 25 50 |oinFKPK(|:%New,%P|
|000055e0| 61 72 65 6e 74 2c 22 20 | 3d 20 22 2c 22 20 61 6e |arent," |= "," an|
|000055f0| 64 22 29 0d 0a 20 20 20 | 20 20 20 20 20 20 20 29 |d").. | )|
|00005600| 3b 0d 0a 19 27 00 00 00 | 00 00 00 00 00 00 00 05 |;...'...|........|
|00005610| 00 00 00 14 00 43 48 49 | 4c 44 20 49 4e 53 45 52 |.....CHI|LD INSER|
|00005620| 54 20 53 45 54 4e 55 4c | 4c fe 01 20 20 20 20 2f |T SETNUL|L.. /|
|00005630| 2a 20 45 52 77 69 6e 20 | 42 75 69 6c 74 69 6e 20 |* ERwin |Builtin |
|00005640| 25 44 61 74 65 74 69 6d | 65 20 2a 2f 0d 0a 20 20 |%Datetim|e */.. |
|00005650| 20 20 2f 2a 20 25 50 61 | 72 65 6e 74 20 25 56 65 | /* %Pa|rent %Ve|
|00005660| 72 62 50 68 72 61 73 65 | 20 25 43 68 69 6c 64 20 |rbPhrase| %Child |
|00005670| 4f 4e 20 43 48 49 4c 44 | 20 49 4e 53 45 52 54 20 |ON CHILD| INSERT |
|00005680| 53 45 54 20 4e 55 4c 4c | 20 2a 2f 0d 0a 20 20 20 |SET NULL| */.. |
|00005690| 20 75 70 64 61 74 65 20 | 25 43 68 69 6c 64 0d 0a | update |%Child..|
|000056a0| 20 20 20 20 20 20 73 65 | 74 0d 0a 20 20 20 20 20 | se|t.. |
|000056b0| 20 20 20 2f 2a 20 25 25 | 53 65 74 46 4b 28 25 43 | /* %%|SetFK(%C|
|000056c0| 68 69 6c 64 2c 4e 55 4c | 4c 29 20 2a 2f 0d 0a 20 |hild,NUL|L) */.. |
|000056d0| 20 20 20 20 20 20 20 25 | 53 65 74 46 4b 28 25 43 | %|SetFK(%C|
|000056e0| 68 69 6c 64 2c 4e 55 4c | 4c 29 0d 0a 20 20 20 20 |hild,NUL|L).. |
|000056f0| 20 20 77 68 65 72 65 0d | 0a 20 20 20 20 20 20 20 | where.|. |
|00005700| 20 6e 6f 74 20 65 78 69 | 73 74 73 20 28 0d 0a 20 | not exi|sts (.. |
|00005710| 20 20 20 20 20 20 20 20 | 20 73 65 6c 65 63 74 20 | | select |
|00005720| 2a 20 66 72 6f 6d 20 25 | 50 61 72 65 6e 74 0d 0a |* from %|Parent..|
|00005730| 20 20 20 20 20 20 20 20 | 20 20 20 20 77 68 65 72 | | wher|
|00005740| 65 0d 0a 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |e.. | |
|00005750| 20 2f 2a 20 25 25 4a 6f | 69 6e 46 4b 50 4b 28 3a | /* %%Jo|inFKPK(:|
|00005760| 25 25 4e 65 77 2c 25 50 | 61 72 65 6e 74 2c 22 20 |%%New,%P|arent," |
|00005770| 3d 20 22 2c 22 20 61 6e | 64 22 29 20 2a 2f 0d 0a |= "," an|d") */..|
|00005780| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 25 4a | | %J|
|00005790| 6f 69 6e 46 4b 50 4b 28 | 3a 25 4e 65 77 2c 25 50 |oinFKPK(|:%New,%P|
|000057a0| 61 72 65 6e 74 2c 22 20 | 3d 20 22 2c 22 20 61 6e |arent," |= "," an|
|000057b0| 64 22 29 0d 0a 20 20 20 | 20 20 20 20 20 29 20 61 |d").. | ) a|
|000057c0| 6e 64 0d 0a 20 20 20 20 | 20 20 20 20 2f 2a 20 25 |nd.. | /* %|
|000057d0| 25 4a 6f 69 6e 50 4b 50 | 4b 28 25 43 68 69 6c 64 |%JoinPKP|K(%Child|
|000057e0| 2c 3a 25 25 4e 65 77 2c | 22 20 3d 20 22 2c 22 20 |,:%%New,|" = "," |
|000057f0| 61 6e 64 22 29 20 2a 2f | 0d 0a 20 20 20 20 20 20 |and") */|.. |
|00005800| 20 20 25 4a 6f 69 6e 50 | 4b 50 4b 28 25 43 68 69 | %JoinP|KPK(%Chi|
|00005810| 6c 64 2c 3a 25 4e 65 77 | 2c 22 20 3d 20 22 2c 22 |ld,:%New|," = ","|
|00005820| 20 61 6e 64 22 29 3b 0d | 0a 1a 27 00 00 00 00 00 | and");.|..'.....|
|00005830| 00 00 00 00 00 05 00 00 | 00 15 00 43 48 49 4c 44 |........|...CHILD|
|00005840| 20 55 50 44 41 54 45 20 | 52 45 53 54 52 49 43 54 | UPDATE |RESTRICT|
|00005850| 02 02 20 20 2f 2a 20 45 | 52 77 69 6e 20 42 75 69 |.. /* E|Rwin Bui|
|00005860| 6c 74 69 6e 20 25 44 61 | 74 65 74 69 6d 65 20 2a |ltin %Da|tetime *|
|00005870| 2f 0d 0a 20 20 2f 2a 20 | 25 50 61 72 65 6e 74 20 |/.. /* |%Parent |
|00005880| 25 56 65 72 62 50 68 72 | 61 73 65 20 25 43 68 69 |%VerbPhr|ase %Chi|
|00005890| 6c 64 20 4f 4e 20 43 48 | 49 4c 44 20 55 50 44 41 |ld ON CH|ILD UPDA|
|000058a0| 54 45 20 52 45 53 54 52 | 49 43 54 20 2a 2f 0d 0a |TE RESTR|ICT */..|
|000058b0| 20 20 73 65 6c 65 63 74 | 20 63 6f 75 6e 74 28 2a | select| count(*|
|000058c0| 29 20 69 6e 74 6f 20 6e | 75 6d 72 6f 77 73 0d 0a |) into n|umrows..|
|000058d0| 20 20 20 20 66 72 6f 6d | 20 25 50 61 72 65 6e 74 | from| %Parent|
|000058e0| 0d 0a 20 20 20 20 77 68 | 65 72 65 0d 0a 20 20 20 |.. wh|ere.. |
|000058f0| 20 20 20 2f 2a 20 25 25 | 4a 6f 69 6e 46 4b 50 4b | /* %%|JoinFKPK|
|00005900| 28 3a 25 25 4e 65 77 2c | 25 50 61 72 65 6e 74 2c |(:%%New,|%Parent,|
|00005910| 22 20 3d 20 22 2c 22 20 | 61 6e 64 22 29 20 2a 2f |" = "," |and") */|
|00005920| 0d 0a 20 20 20 20 20 20 | 25 4a 6f 69 6e 46 4b 50 |.. |%JoinFKP|
|00005930| 4b 28 3a 25 4e 65 77 2c | 25 50 61 72 65 6e 74 2c |K(:%New,|%Parent,|
|00005940| 22 20 3d 20 22 2c 22 20 | 61 6e 64 22 29 3b 0d 0a |" = "," |and");..|
|00005950| 20 20 69 66 20 28 0d 0a | 20 20 20 20 2f 2a 20 25 | if (..| /* %|
|00005960| 25 4e 6f 74 6e 75 6c 6c | 46 4b 28 3a 25 25 4e 65 |%Notnull|FK(:%%Ne|
|00005970| 77 2c 22 20 69 73 20 6e | 6f 74 20 6e 75 6c 6c 20 |w," is n|ot null |
|00005980| 61 6e 64 22 29 20 2a 2f | 0d 0a 20 20 20 20 25 4e |and") */|.. %N|
|00005990| 6f 74 6e 75 6c 6c 46 4b | 28 3a 25 4e 65 77 2c 22 |otnullFK|(:%New,"|
|000059a0| 20 69 73 20 6e 6f 74 20 | 6e 75 6c 6c 20 61 6e 64 | is not |null and|
|000059b0| 22 29 0d 0a 20 20 20 20 | 6e 75 6d 72 6f 77 73 20 |").. |numrows |
|000059c0| 3d 20 30 0d 0a 20 20 29 | 0d 0a 20 20 74 68 65 6e |= 0.. )|.. then|
|000059d0| 0d 0a 20 20 20 20 72 61 | 69 73 65 5f 61 70 70 6c |.. ra|ise_appl|
|000059e0| 69 63 61 74 69 6f 6e 5f | 65 72 72 6f 72 28 0d 0a |ication_|error(..|
|000059f0| 20 20 20 20 20 20 2d 32 | 30 30 30 37 2c 0d 0a 20 | -2|0007,.. |
|00005a00| 20 20 20 20 20 27 43 61 | 6e 6e 6f 74 20 55 50 44 | 'Ca|nnot UPD|
|00005a10| 41 54 45 20 22 25 43 68 | 69 6c 64 22 20 62 65 63 |ATE "%Ch|ild" bec|
|00005a20| 61 75 73 65 20 22 25 50 | 61 72 65 6e 74 22 20 64 |ause "%P|arent" d|
|00005a30| 6f 65 73 20 6e 6f 74 20 | 65 78 69 73 74 2e 27 0d |oes not |exist.'.|
|00005a40| 0a 20 20 20 20 29 3b 0d | 0a 20 20 65 6e 64 20 69 |. );.|. end i|
|00005a50| 66 3b 0d 0a 1c 27 00 00 | 00 00 00 00 00 00 00 00 |f;...'..|........|
|00005a60| 05 00 00 00 14 00 43 48 | 49 4c 44 20 55 50 44 41 |......CH|ILD UPDA|
|00005a70| 54 45 20 43 41 53 43 41 | 44 45 05 02 20 20 2f 2a |TE CASCA|DE.. /*|
|00005a80| 20 45 52 77 69 6e 20 42 | 75 69 6c 74 69 6e 20 25 | ERwin B|uiltin %|
|00005a90| 44 61 74 65 74 69 6d 65 | 20 2a 2f 0d 0a 20 20 2f |Datetime| */.. /|
|00005aa0| 2a 20 25 50 61 72 65 6e | 74 20 25 56 65 72 62 50 |* %Paren|t %VerbP|
|00005ab0| 68 72 61 73 65 20 25 43 | 68 69 6c 64 20 4f 4e 20 |hrase %C|hild ON |
|00005ac0| 43 48 49 4c 44 20 55 50 | 44 41 54 45 20 43 41 53 |CHILD UP|DATE CAS|
|00005ad0| 43 41 44 45 20 2a 2f 0d | 0a 20 20 20 20 69 6e 73 |CADE */.|. ins|
|00005ae0| 65 72 74 20 69 6e 74 6f | 20 25 50 61 72 65 6e 74 |ert into| %Parent|
|00005af0| 20 28 25 50 61 72 65 6e | 74 50 4b 28 22 2c 22 2c | (%Paren|tPK(",",|
|00005b00| 29 29 0d 0a 20 20 20 20 | 20 20 73 65 6c 65 63 74 |)).. | select|
|00005b10| 20 25 43 68 69 6c 64 46 | 4b 28 22 2c 22 2c 29 0d | %ChildF|K(",",).|
|00005b20| 0a 20 20 20 20 20 20 20 | 20 66 72 6f 6d 20 25 43 |. | from %C|
|00005b30| 68 69 6c 64 0d 0a 20 20 | 20 20 20 20 20 20 77 68 |hild.. | wh|
|00005b40| 65 72 65 0d 0a 20 20 20 | 20 20 20 20 20 20 20 2f |ere.. | /|
|00005b50| 2a 20 25 25 4e 6f 74 6e | 75 6c 6c 46 4b 28 3a 25 |* %%Notn|ullFK(:%|
|00005b60| 25 4e 65 77 2c 22 20 69 | 73 20 6e 6f 74 20 6e 75 |%New," i|s not nu|
|00005b70| 6c 6c 20 61 6e 64 22 29 | 20 2a 2f 0d 0a 20 20 20 |ll and")| */.. |
|00005b80| 20 20 20 20 20 20 20 25 | 4e 6f 74 6e 75 6c 6c 46 | %|NotnullF|
|00005b90| 4b 28 3a 25 4e 65 77 2c | 22 20 69 73 20 6e 6f 74 |K(:%New,|" is not|
|00005ba0| 20 6e 75 6c 6c 20 61 6e | 64 22 29 0d 0a 20 20 20 | null an|d").. |
|00005bb0| 20 20 20 20 20 20 20 6e | 6f 74 20 65 78 69 73 74 | n|ot exist|
|00005bc0| 73 20 28 0d 0a 20 20 20 | 20 20 20 20 20 20 20 20 |s (.. | |
|00005bd0| 20 73 65 6c 65 63 74 20 | 2a 20 66 72 6f 6d 20 25 | select |* from %|
|00005be0| 50 61 72 65 6e 74 0d 0a | 20 20 20 20 20 20 20 20 |Parent..| |
|00005bf0| 20 20 20 20 20 20 77 68 | 65 72 65 0d 0a 20 20 20 | wh|ere.. |
|00005c00| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 2f 2a 20 | | /* |
|00005c10| 25 25 4a 6f 69 6e 46 4b | 50 4b 28 3a 25 25 4e 65 |%%JoinFK|PK(:%%Ne|
|00005c20| 77 2c 25 50 61 72 65 6e | 74 2c 22 20 3d 20 22 2c |w,%Paren|t," = ",|
|00005c30| 22 20 61 6e 64 22 29 20 | 2a 2f 0d 0a 20 20 20 20 |" and") |*/.. |
|00005c40| 20 20 20 20 20 20 20 20 | 20 20 20 20 25 4a 6f 69 | | %Joi|
|00005c50| 6e 46 4b 50 4b 28 3a 25 | 4e 65 77 2c 25 50 61 72 |nFKPK(:%|New,%Par|
|00005c60| 65 6e 74 2c 22 20 3d 20 | 22 2c 22 20 61 6e 64 22 |ent," = |"," and"|
|00005c70| 29 0d 0a 20 20 20 20 20 | 20 20 20 20 20 29 3b 0d |).. | );.|
|00005c80| 0a 1d 27 00 00 00 00 00 | 00 00 00 00 00 05 00 00 |..'.....|........|
|00005c90| 00 14 00 43 48 49 4c 44 | 20 55 50 44 41 54 45 20 |...CHILD| UPDATE |
|00005ca0| 53 45 54 4e 55 4c 4c fe | 01 20 20 20 20 2f 2a 20 |SETNULL.|. /* |
|00005cb0| 45 52 77 69 6e 20 42 75 | 69 6c 74 69 6e 20 25 44 |ERwin Bu|iltin %D|
|00005cc0| 61 74 65 74 69 6d 65 20 | 2a 2f 0d 0a 20 20 20 20 |atetime |*/.. |
|00005cd0| 2f 2a 20 25 50 61 72 65 | 6e 74 20 25 56 65 72 62 |/* %Pare|nt %Verb|
|00005ce0| 50 68 72 61 73 65 20 25 | 43 68 69 6c 64 20 4f 4e |Phrase %|Child ON|
|00005cf0| 20 43 48 49 4c 44 20 55 | 50 44 41 54 45 20 53 45 | CHILD U|PDATE SE|
|00005d00| 54 20 4e 55 4c 4c 20 2a | 2f 0d 0a 20 20 20 20 75 |T NULL *|/.. u|
|00005d10| 70 64 61 74 65 20 25 43 | 68 69 6c 64 0d 0a 20 20 |pdate %C|hild.. |
|00005d20| 20 20 20 20 73 65 74 0d | 0a 20 20 20 20 20 20 20 | set.|. |
|00005d30| 20 2f 2a 20 25 25 53 65 | 74 46 4b 28 25 43 68 69 | /* %%Se|tFK(%Chi|
|00005d40| 6c 64 2c 4e 55 4c 4c 29 | 20 2a 2f 0d 0a 20 20 20 |ld,NULL)| */.. |
|00005d50| 20 20 20 20 20 25 53 65 | 74 46 4b 28 25 43 68 69 | %Se|tFK(%Chi|
|00005d60| 6c 64 2c 4e 55 4c 4c 29 | 0d 0a 20 20 20 20 20 20 |ld,NULL)|.. |
|00005d70| 77 68 65 72 65 0d 0a 20 | 20 20 20 20 20 20 20 6e |where.. | n|
|00005d80| 6f 74 20 65 78 69 73 74 | 73 20 28 0d 0a 20 20 20 |ot exist|s (.. |
|00005d90| 20 20 20 20 20 20 20 73 | 65 6c 65 63 74 20 2a 20 | s|elect * |
|00005da0| 66 72 6f 6d 20 25 50 61 | 72 65 6e 74 0d 0a 20 20 |from %Pa|rent.. |
|00005db0| 20 20 20 20 20 20 20 20 | 20 20 77 68 65 72 65 0d | | where.|
|00005dc0| 0a 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 2f |. | /|
|00005dd0| 2a 20 25 25 4a 6f 69 6e | 46 4b 50 4b 28 3a 25 25 |* %%Join|FKPK(:%%|
|00005de0| 4e 65 77 2c 25 50 61 72 | 65 6e 74 2c 22 20 3d 20 |New,%Par|ent," = |
|00005df0| 22 2c 22 20 61 6e 64 22 | 29 20 2a 2f 0d 0a 20 20 |"," and"|) */.. |
|00005e00| 20 20 20 20 20 20 20 20 | 20 20 20 20 25 4a 6f 69 | | %Joi|
|00005e10| 6e 46 4b 50 4b 28 3a 25 | 4e 65 77 2c 25 50 61 72 |nFKPK(:%|New,%Par|
|00005e20| 65 6e 74 2c 22 20 3d 20 | 22 2c 22 20 61 6e 64 22 |ent," = |"," and"|
|00005e30| 29 0d 0a 20 20 20 20 20 | 20 20 20 29 20 61 6e 64 |).. | ) and|
|00005e40| 0d 0a 20 20 20 20 20 20 | 20 20 2f 2a 20 25 25 4a |.. | /* %%J|
|00005e50| 6f 69 6e 50 4b 50 4b 28 | 25 43 68 69 6c 64 2c 3a |oinPKPK(|%Child,:|
|00005e60| 25 25 4e 65 77 2c 22 20 | 3d 20 22 2c 22 20 61 6e |%%New," |= "," an|
|00005e70| 64 22 29 20 2a 2f 0d 0a | 20 20 20 20 20 20 20 20 |d") */..| |
|00005e80| 25 4a 6f 69 6e 50 4b 50 | 4b 28 25 43 68 69 6c 64 |%JoinPKP|K(%Child|
|00005e90| 2c 3a 25 4e 65 77 2c 22 | 20 3d 20 22 2c 22 20 61 |,:%New,"| = "," a|
|00005ea0| 6e 64 22 29 3b 0d 0a 1e | 27 00 00 00 00 00 00 00 |nd");...|'.......|
|00005eb0| 00 00 00 05 00 00 00 15 | 00 43 48 49 4c 44 20 44 |........|.CHILD D|
|00005ec0| 45 4c 45 54 45 20 52 45 | 53 54 52 49 43 54 a9 01 |ELETE RE|STRICT..|
|00005ed0| 20 20 20 20 2f 2a 20 45 | 52 77 69 6e 20 42 75 69 | /* E|Rwin Bui|
|00005ee0| 6c 74 69 6e 20 25 44 61 | 74 65 74 69 6d 65 20 2a |ltin %Da|tetime *|
|00005ef0| 2f 0d 0a 20 20 20 20 2f | 2a 20 25 50 61 72 65 6e |/.. /|* %Paren|
|00005f00| 74 20 25 56 65 72 62 50 | 68 72 61 73 65 20 25 43 |t %VerbP|hrase %C|
|00005f10| 68 69 6c 64 20 4f 4e 20 | 43 48 49 4c 44 20 44 45 |hild ON |CHILD DE|
|00005f20| 4c 45 54 45 20 52 45 53 | 54 52 49 43 54 20 2a 2f |LETE RES|TRICT */|
|00005f30| 0d 0a 20 20 20 20 73 65 | 6c 65 63 74 20 63 6f 75 |.. se|lect cou|
|00005f40| 6e 74 28 2a 29 20 69 6e | 74 6f 20 6e 75 6d 72 6f |nt(*) in|to numro|
|00005f50| 77 73 20 66 72 6f 6d 20 | 25 50 61 72 65 6e 74 0d |ws from |%Parent.|
|00005f60| 0a 20 20 20 20 20 20 77 | 68 65 72 65 0d 0a 20 20 |. w|here.. |
|00005f70| 20 20 20 20 20 20 2f 2a | 20 25 25 4a 6f 69 6e 46 | /*| %%JoinF|
|00005f80| 4b 50 4b 28 3a 25 25 4f | 6c 64 2c 25 50 61 72 65 |KPK(:%%O|ld,%Pare|
|00005f90| 6e 74 2c 22 20 3d 20 22 | 2c 22 20 61 6e 64 22 29 |nt," = "|," and")|
|00005fa0| 20 2a 2f 0d 0a 20 20 20 | 20 20 20 20 20 25 4a 6f | */.. | %Jo|
|00005fb0| 69 6e 46 4b 50 4b 28 3a | 25 4f 6c 64 2c 25 50 61 |inFKPK(:|%Old,%Pa|
|00005fc0| 72 65 6e 74 2c 22 20 3d | 20 22 2c 22 20 61 6e 64 |rent," =| "," and|
|00005fd0| 22 29 3b 0d 0a 20 20 20 | 20 69 66 20 28 6e 75 6d |");.. | if (num|
|00005fe0| 72 6f 77 73 20 3e 20 30 | 29 0d 0a 20 20 20 20 74 |rows > 0|).. t|
|00005ff0| 68 65 6e 0d 0a 20 20 20 | 20 20 20 72 61 69 73 65 |hen.. | raise|
|00006000| 5f 61 70 70 6c 69 63 61 | 74 69 6f 6e 5f 65 72 72 |_applica|tion_err|
|00006010| 6f 72 28 0d 0a 20 20 20 | 20 20 20 20 20 2d 32 30 |or(.. | -20|
|00006020| 30 31 30 2c 0d 0a 20 20 | 20 20 20 20 20 20 27 43 |010,.. | 'C|
|00006030| 61 6e 6e 6f 74 20 44 45 | 4c 45 54 45 20 22 25 43 |annot DE|LETE "%C|
|00006040| 68 69 6c 64 22 20 62 65 | 63 61 75 73 65 20 22 25 |hild" be|cause "%|
|00006050| 50 61 72 65 6e 74 22 20 | 65 78 69 73 74 73 2e 27 |Parent" |exists.'|
|00006060| 0d 0a 20 20 20 20 20 20 | 29 3b 0d 0a 20 20 20 20 |.. |);.. |
|00006070| 65 6e 64 20 69 66 3b 0d | 0a 20 27 00 00 00 00 00 |end if;.|. '.....|
|00006080| 00 00 00 00 00 05 00 00 | 00 14 00 43 48 49 4c 44 |........|...CHILD|
|00006090| 20 44 45 4c 45 54 45 20 | 43 41 53 43 41 44 45 ee | DELETE |CASCADE.|
|000060a0| 00 20 20 20 20 2f 2a 20 | 45 52 77 69 6e 20 42 75 |. /* |ERwin Bu|
|000060b0| 69 6c 74 69 6e 20 25 44 | 61 74 65 74 69 6d 65 20 |iltin %D|atetime |
|000060c0| 2a 2f 0d 0a 20 20 20 20 | 2f 2a 20 25 50 61 72 65 |*/.. |/* %Pare|
|000060d0| 6e 74 20 25 56 65 72 62 | 50 68 72 61 73 65 20 25 |nt %Verb|Phrase %|
|000060e0| 43 68 69 6c 64 20 4f 4e | 20 43 48 49 4c 44 20 44 |Child ON| CHILD D|
|000060f0| 45 4c 45 54 45 20 43 41 | 53 43 41 44 45 20 2a 2f |ELETE CA|SCADE */|
|00006100| 0d 0a 20 20 20 20 64 65 | 6c 65 74 65 20 66 72 6f |.. de|lete fro|
|00006110| 6d 20 25 50 61 72 65 6e | 74 0d 0a 20 20 20 20 20 |m %Paren|t.. |
|00006120| 20 77 68 65 72 65 0d 0a | 20 20 20 20 20 20 20 20 | where..| |
|00006130| 2f 2a 20 25 25 4a 6f 69 | 6e 46 4b 50 4b 28 3a 25 |/* %%Joi|nFKPK(:%|
|00006140| 25 4f 6c 64 2c 25 50 61 | 72 65 6e 74 2c 22 20 3d |%Old,%Pa|rent," =|
|00006150| 20 22 2c 22 20 61 6e 64 | 22 29 20 2a 2f 0d 0a 20 | "," and|") */.. |
|00006160| 20 20 20 20 20 20 20 25 | 4a 6f 69 6e 46 4b 50 4b | %|JoinFKPK|
|00006170| 28 3a 25 4f 6c 64 2c 25 | 50 61 72 65 6e 74 2c 22 |(:%Old,%|Parent,"|
|00006180| 20 3d 20 22 2c 22 20 61 | 6e 64 22 29 3b 0d 0a 21 | = "," a|nd");..!|
|00006190| 27 00 00 00 00 00 00 00 | 00 00 00 05 00 00 00 16 |'.......|........|
|000061a0| 00 50 41 52 45 4e 54 20 | 49 4e 53 45 52 54 20 52 |.PARENT |INSERT R|
|000061b0| 45 53 54 52 49 43 54 a9 | 01 20 20 20 20 2f 2a 20 |ESTRICT.|. /* |
|000061c0| 45 52 77 69 6e 20 42 75 | 69 6c 74 69 6e 20 25 44 |ERwin Bu|iltin %D|
|000061d0| 61 74 65 74 69 6d 65 20 | 2a 2f 0d 0a 20 20 20 20 |atetime |*/.. |
|000061e0| 2f 2a 20 25 50 61 72 65 | 6e 74 20 25 56 65 72 62 |/* %Pare|nt %Verb|
|000061f0| 50 68 72 61 73 65 20 25 | 43 68 69 6c 64 20 4f 4e |Phrase %|Child ON|
|00006200| 20 50 41 52 45 4e 54 20 | 49 4e 53 45 52 54 20 52 | PARENT |INSERT R|
|00006210| 45 53 54 52 49 43 54 20 | 2a 2f 0d 0a 20 20 20 20 |ESTRICT |*/.. |
|00006220| 73 65 6c 65 63 74 20 63 | 6f 75 6e 74 28 2a 29 20 |select c|ount(*) |
|00006230| 69 6e 74 6f 20 6e 75 6d | 72 6f 77 73 20 66 72 6f |into num|rows fro|
|00006240| 6d 20 25 43 68 69 6c 64 | 0d 0a 20 20 20 20 20 20 |m %Child|.. |
|00006250| 77 68 65 72 65 0d 0a 20 | 20 20 20 20 20 20 20 2f |where.. | /|
|00006260| 2a 20 25 25 4a 6f 69 6e | 46 4b 50 4b 28 25 43 68 |* %%Join|FKPK(%Ch|
|00006270| 69 6c 64 2c 3a 25 25 4e | 65 77 2c 22 20 3d 20 22 |ild,:%%N|ew," = "|
|00006280| 2c 22 20 61 6e 64 22 29 | 20 2a 2f 0d 0a 20 20 20 |," and")| */.. |
|00006290| 20 20 20 20 20 25 4a 6f | 69 6e 46 4b 50 4b 28 25 | %Jo|inFKPK(%|
|000062a0| 43 68 69 6c 64 2c 3a 25 | 4e 65 77 2c 22 20 3d 20 |Child,:%|New," = |
|000062b0| 22 2c 22 20 61 6e 64 22 | 29 3b 0d 0a 20 20 20 20 |"," and"|);.. |
|000062c0| 69 66 20 28 6e 75 6d 72 | 6f 77 73 20 3d 20 30 29 |if (numr|ows = 0)|
|000062d0| 0d 0a 20 20 20 20 74 68 | 65 6e 0d 0a 20 20 20 20 |.. th|en.. |
|000062e0| 20 20 72 61 69 73 65 5f | 61 70 70 6c 69 63 61 74 | raise_|applicat|
|000062f0| 69 6f 6e 5f 65 72 72 6f | 72 28 0d 0a 20 20 20 20 |ion_erro|r(.. |
|00006300| 20 20 20 20 2d 32 30 30 | 31 31 2c 0d 0a 20 20 20 | -200|11,.. |
|00006310| 20 20 20 20 20 27 43 61 | 6e 6e 6f 74 20 49 4e 53 | 'Ca|nnot INS|
|00006320| 45 52 54 20 22 25 50 61 | 72 65 6e 74 22 20 62 65 |ERT "%Pa|rent" be|
|00006330| 63 61 75 73 65 20 22 25 | 43 68 69 6c 64 22 20 64 |cause "%|Child" d|
|00006340| 6f 65 73 20 6e 6f 74 2e | 27 0d 0a 20 20 20 20 20 |oes not.|'.. |
|00006350| 20 29 3b 0d 0a 20 20 20 | 20 65 6e 64 20 69 66 3b | );.. | end if;|
|00006360| 0d 0a 24 27 00 00 00 00 | 00 00 00 00 00 00 05 00 |..$'....|........|
|00006370| 00 00 0d 00 55 50 44 41 | 54 45 20 48 45 41 44 45 |....UPDA|TE HEADE|
|00006380| 52 ae 00 63 72 65 61 74 | 65 20 74 72 69 67 67 65 |R..creat|e trigge|
|00006390| 72 20 74 25 31 41 63 74 | 69 6f 6e 5f 25 32 37 54 |r t%1Act|ion_%27T|
|000063a0| 61 62 6c 65 4e 61 6d 65 | 20 61 66 74 65 72 20 25 |ableName| after %|
|000063b0| 41 63 74 69 6f 6e 20 6f | 6e 20 25 54 61 62 6c 65 |Action o|n %Table|
|000063c0| 4e 61 6d 65 20 66 6f 72 | 20 65 61 63 68 20 72 6f |Name for| each ro|
|000063d0| 77 0d 0a 2d 2d 20 45 52 | 77 69 6e 20 42 75 69 6c |w..-- ER|win Buil|
|000063e0| 74 69 6e 20 25 44 61 74 | 65 74 69 6d 65 0d 0a 2d |tin %Dat|etime..-|
|000063f0| 2d 20 25 41 63 74 69 6f | 6e 20 74 72 69 67 67 65 |- %Actio|n trigge|
+--------+-------------------------+-------------------------+--------+--------+
Only 25.0 KB of data is shown above.
