home *** CD-ROM | disk | FTP | other *** search
open in: 
MacOS 8.1
|
Win98
|
DOS
view JSON data
|
view as text
This file was processed as: DiskDupe Disk Image
(archive/diskDupeDiskImage).
You can browse this item here: 33.ddi
hex view+--------+-------------------------+-------------------------+--------+--------+
|00000000| 49 4d 00 00 00 00 00 00 | 00 00 02 00 00 00 00 00 |IM......|........|
|00000010| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000020| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000030| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000040| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000050| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000060| 00 00 00 00 01 01 00 00 | 00 01 01 02 00 00 00 01 |........|........|
|00000070| 01 03 00 00 00 01 01 04 | 00 00 00 01 01 05 00 00 |........|........|
|00000080| 00 01 01 06 00 00 00 01 | 01 07 00 00 00 01 01 08 |........|........|
|00000090| 00 00 00 01 01 09 00 00 | 00 01 01 0a 00 00 00 01 |........|........|
|000000a0| 01 0b 00 00 00 01 01 0c | 00 00 00 01 01 0d 00 00 |........|........|
|000000b0| 00 01 01 0e 00 00 00 01 | 01 0f 00 00 00 01 01 10 |........|........|
|000000c0| 00 00 00 01 01 11 00 00 | 00 01 01 12 00 00 00 01 |........|........|
|000000d0| 01 13 00 00 00 01 01 14 | 00 00 00 01 01 15 00 00 |........|........|
|000000e0| 00 01 01 16 00 00 00 01 | 01 17 00 00 00 01 01 18 |........|........|
|000000f0| 00 00 00 01 01 19 00 00 | 00 01 01 1a 00 00 00 01 |........|........|
|00000100| 01 1b 00 00 00 01 01 1c | 00 00 00 01 01 1d 00 00 |........|........|
|00000110| 00 01 01 1e 00 00 00 01 | 01 1f 00 00 00 01 01 20 |........|....... |
|00000120| 00 00 00 01 01 21 00 00 | 00 01 01 22 00 00 00 01 |.....!..|..."....|
|00000130| 01 23 00 00 00 01 01 24 | 00 00 00 01 01 25 00 00 |.#.....$|.....%..|
|00000140| 00 01 01 26 00 00 00 01 | 01 27 00 00 00 01 01 28 |...&....|.'.....(|
|00000150| 00 00 00 01 01 29 00 00 | 00 01 01 2a 00 00 00 01 |.....)..|...*....|
|00000160| 01 2b 00 00 00 01 01 2c | 00 00 00 01 01 2d 00 00 |.+.....,|.....-..|
|00000170| 00 01 01 2e 00 00 00 01 | 01 2f 00 00 00 01 01 30 |........|./.....0|
|00000180| 00 00 00 01 01 31 00 00 | 00 01 01 32 00 00 00 01 |.....1..|...2....|
|00000190| 01 33 00 00 00 01 01 34 | 00 00 00 01 01 35 00 00 |.3.....4|.....5..|
|000001a0| 00 01 01 36 00 00 00 01 | 01 37 00 00 00 01 01 38 |...6....|.7.....8|
|000001b0| 00 00 00 01 01 39 00 00 | 00 01 01 3a 00 00 00 01 |.....9..|...:....|
|000001c0| 01 3b 00 00 00 01 01 3c | 00 00 00 01 01 3d 00 00 |.;.....<|.....=..|
|000001d0| 00 01 01 3e 00 00 00 01 | 01 3f 00 00 00 01 01 40 |...>....|.?.....@|
|000001e0| 00 00 00 01 01 41 00 00 | 00 01 01 42 00 00 00 01 |.....A..|...B....|
|000001f0| 01 43 00 00 00 01 01 44 | 00 00 00 01 01 45 00 00 |.C.....D|.....E..|
|00000200| 00 01 01 46 00 00 00 01 | 01 47 00 00 00 01 01 48 |...F....|.G.....H|
|00000210| 00 00 00 01 01 49 00 00 | 00 01 01 4a 00 00 00 01 |.....I..|...J....|
|00000220| 01 4b 00 00 00 01 01 4c | 00 00 00 01 01 4d 00 00 |.K.....L|.....M..|
|00000230| 00 01 01 4e 00 00 00 01 | 01 4f 00 00 00 01 01 50 |...N....|.O.....P|
|00000240| 00 00 00 01 01 51 00 00 | 00 01 01 52 00 00 00 01 |.....Q..|...R....|
|00000250| 01 53 00 00 00 01 01 54 | 00 00 00 01 01 55 00 00 |.S.....T|.....U..|
|00000260| 00 01 01 56 00 00 00 01 | 01 57 00 00 00 01 01 58 |...V....|.W.....X|
|00000270| 00 00 00 01 01 59 00 00 | 00 01 01 5a 00 00 00 01 |.....Y..|...Z....|
|00000280| 01 5b 00 00 00 01 01 5c | 00 00 00 01 01 5d 00 00 |.[.....\|.....]..|
|00000290| 00 01 01 5e 00 00 00 01 | 01 5f 00 00 00 01 01 60 |...^....|._.....`|
|000002a0| 00 00 00 01 01 61 00 00 | 00 01 01 62 00 00 00 01 |.....a..|...b....|
|000002b0| 01 63 00 00 00 01 01 64 | 00 00 00 01 01 65 00 00 |.c.....d|.....e..|
|000002c0| 00 01 01 66 00 00 00 01 | 01 67 00 00 00 01 01 68 |...f....|.g.....h|
|000002d0| 00 00 00 01 01 69 00 00 | 00 01 01 6a 00 00 00 01 |.....i..|...j....|
|000002e0| 01 6b 00 00 00 01 01 6c | 00 00 00 01 01 6d 00 00 |.k.....l|.....m..|
|000002f0| 00 01 01 6e 00 00 00 01 | 01 6f 00 00 00 01 01 70 |...n....|.o.....p|
|00000300| 00 00 00 01 01 71 00 00 | 00 01 01 72 00 00 00 01 |.....q..|...r....|
|00000310| 01 73 00 00 00 01 01 74 | 00 00 00 01 01 75 00 00 |.s.....t|.....u..|
|00000320| 00 01 01 76 00 00 00 01 | 01 77 00 00 00 01 01 78 |...v....|.w.....x|
|00000330| 00 00 00 01 01 79 00 00 | 00 01 01 7a 00 00 00 01 |.....y..|...z....|
|00000340| 01 7b 00 00 00 01 01 7c | 00 00 00 01 01 7d 00 00 |.{.....||.....}..|
|00000350| 00 01 01 7e 00 00 00 01 | 01 7f 00 00 00 01 01 80 |...~....|........|
|00000360| 00 00 00 01 01 81 00 00 | 00 01 01 82 00 00 00 01 |........|........|
|00000370| 01 83 00 00 00 01 01 84 | 00 00 00 01 01 85 00 00 |........|........|
|00000380| 00 01 01 86 00 00 00 01 | 01 87 00 00 00 01 01 88 |........|........|
|00000390| 00 00 00 01 01 89 00 00 | 00 01 01 8a 00 00 00 01 |........|........|
|000003a0| 01 8b 00 00 00 01 01 8c | 00 00 00 01 01 8d 00 00 |........|........|
|000003b0| 00 01 01 8e 00 00 00 01 | 01 8f 00 00 00 01 01 90 |........|........|
|000003c0| 00 00 00 01 01 91 00 00 | 00 01 01 92 00 00 00 01 |........|........|
|000003d0| 01 93 00 00 00 01 01 94 | 00 00 00 01 01 95 00 00 |........|........|
|000003e0| 00 01 01 96 00 00 00 01 | 01 97 00 00 00 01 01 98 |........|........|
|000003f0| 00 00 00 01 01 99 00 00 | 00 01 01 9a 00 00 00 01 |........|........|
|00000400| 01 9b 00 00 00 01 01 9c | 00 00 00 01 01 9d 00 00 |........|........|
|00000410| 00 01 01 9e 00 00 00 01 | 01 9f 00 00 00 01 01 a0 |........|........|
|00000420| 00 00 00 01 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000430| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000440| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000450| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000460| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000470| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000480| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000490| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000004a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000004b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000004c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000004d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000004e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000004f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000500| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000510| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000520| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000530| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000540| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000550| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000560| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000570| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000580| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000590| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000005a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000005b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000005c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000005d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000005e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000005f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000600| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000610| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000620| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000630| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000640| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000650| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000660| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000670| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000680| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000690| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000006a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000006b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000006c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000006d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000006e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000006f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000700| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000710| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000720| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000730| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000740| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000750| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000760| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000770| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000780| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000790| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000007a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000007b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000007c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000007d0| 00 00 00 00 00 00 00 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 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000800| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000810| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000820| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000830| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000840| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000850| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000860| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000870| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000880| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000890| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000008a0| 00 00 00 00 00 00 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 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000008d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000008e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000008f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000900| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000910| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000920| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000930| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000940| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000950| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000960| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000970| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000980| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000990| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000009a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000009b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000009c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000009d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000009e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000009f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000a00| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000a10| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000a20| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000a30| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000a40| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000a50| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000a60| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000a70| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000a80| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000a90| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000aa0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000ab0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000ac0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000ad0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000ae0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000af0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000b00| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000b10| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000b20| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000b30| 00 00 00 00 00 00 00 00 | 00 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 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000b60| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000b70| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000b80| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000b90| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000ba0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000bb0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000bc0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000bd0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000be0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000bf0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000c00| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000c10| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000c20| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000c30| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000c40| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000c50| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000c60| 00 00 00 00 00 00 00 00 | 00 00 00 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 | 00 00 00 00 00 00 00 00 |........|........|
|00000c90| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000ca0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000cb0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000cc0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000cd0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000ce0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000cf0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000d00| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000d10| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000d20| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000d30| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000d40| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000d50| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000d60| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000d70| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000d80| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000d90| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000da0| 00 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 00 00 |........|........|
|00000dc0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000dd0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000de0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000df0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000e00| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000e10| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000e20| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|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 00 00 00 00 00 00 |........|........|
|00000e50| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000e60| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000e70| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000e80| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000e90| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000ea0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000eb0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|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 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000ef0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000f00| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000f10| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000f20| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000f30| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000f40| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000f50| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|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 00 00 00 00 00 00 00 |........|........|
|00000f80| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000f90| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000fa0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000fb0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000fc0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000fd0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000fe0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000ff0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001000| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001010| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001020| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001030| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001040| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001050| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001060| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001070| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001080| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001090| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000010a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000010b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000010c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000010d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000010e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000010f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001100| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001110| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001120| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001130| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001140| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001150| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001160| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001170| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001180| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001190| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000011a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000011b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000011c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000011d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000011e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000011f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001200| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001210| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001220| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001230| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001240| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001250| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001260| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001270| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001280| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001290| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000012a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000012b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000012c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000012d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000012e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000012f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001300| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001310| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001320| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001330| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001340| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001350| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001360| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001370| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001380| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001390| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000013a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000013b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000013c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000013d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000013e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000013f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001400| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001410| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001420| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001430| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001440| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001450| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001460| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001470| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001480| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001490| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000014a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000014b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000014c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000014d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000014e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000014f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001500| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001510| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001520| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001530| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001540| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001550| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001560| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001570| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001580| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001590| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000015a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000015b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000015c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000015d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000015e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000015f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001600| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001610| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001620| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001630| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001640| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001650| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001660| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001670| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001680| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001690| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000016a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000016b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000016c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000016d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000016e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000016f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001700| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001710| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001720| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001730| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001740| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001750| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001760| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001770| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001780| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001790| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000017a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000017b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000017c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000017d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000017e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000017f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001800| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001810| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001820| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001830| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001840| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001850| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001860| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001870| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001880| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001890| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000018a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000018b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000018c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000018d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000018e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000018f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001900| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001910| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001920| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001930| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001940| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001950| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001960| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001970| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001980| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001990| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000019a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|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 00 00 00 |........|........|
|000019d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000019e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000019f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001a00| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001a10| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001a20| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001a30| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|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 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001a60| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001a70| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001a80| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001a90| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001aa0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001ab0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001ac0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001ad0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001ae0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001af0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001b00| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001b10| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001b20| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001b30| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001b40| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001b50| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001b60| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001b70| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001b80| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001b90| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001ba0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001bb0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001bc0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001bd0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001be0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001bf0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001c00| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001c10| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001c20| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001c30| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001c40| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001c50| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001c60| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001c70| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001c80| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001c90| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001ca0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001cb0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001cc0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001cd0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001ce0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001cf0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001d00| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001d10| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001d20| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001d30| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001d40| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001d50| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001d60| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001d70| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001d80| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001d90| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001da0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001db0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001dc0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001dd0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001de0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001df0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001e00| 30 37 30 37 30 37 30 30 | 30 34 35 30 30 31 31 33 |07070700|04500113|
|00001e10| 32 37 30 34 30 37 37 37 | 30 30 30 33 31 31 30 30 |27040777|00031100|
|00001e20| 30 30 36 32 30 30 30 30 | 31 30 30 30 30 30 30 30 |00620000|10000000|
|00001e30| 30 34 37 36 34 35 37 36 | 32 35 34 30 30 30 30 30 |04764576|25400000|
|00001e40| 32 30 30 30 30 30 30 30 | 30 30 30 30 2e 00 30 37 |20000000|0000..07|
|00001e50| 30 37 30 37 30 30 30 34 | 35 30 30 31 31 33 33 30 |07070004|50011330|
|00001e60| 30 34 30 37 35 35 30 30 | 30 33 31 31 30 30 30 30 |04075500|03110000|
|00001e70| 36 32 30 30 30 30 30 33 | 30 30 30 30 30 30 30 34 |62000003|00000004|
|00001e80| 37 36 34 35 37 35 37 31 | 33 30 30 30 30 30 36 30 |76457571|30000060|
|00001e90| 30 30 30 30 30 30 30 30 | 30 30 61 64 6d 69 6e 00 |00000000|00admin.|
|00001ea0| 30 37 30 37 30 37 30 30 | 30 34 35 30 30 31 31 33 |07070700|04500113|
|00001eb0| 33 31 31 30 30 34 34 34 | 30 30 30 33 31 31 30 30 |31100444|00031100|
|00001ec0| 30 30 36 32 30 30 30 30 | 30 31 30 30 30 30 30 30 |00620000|01000000|
|00001ed0| 30 34 37 36 34 35 37 35 | 37 31 33 30 30 30 30 32 |04764575|71300002|
|00001ee0| 35 30 30 30 30 30 30 30 | 31 34 31 36 61 64 6d 69 |50000000|1416admi|
|00001ef0| 6e 2f 64 72 6f 70 74 61 | 62 6c 65 73 2e 73 71 6c |n/dropta|bles.sql|
|00001f00| 00 72 65 6d 20 0a 72 65 | 6d 20 24 48 65 61 64 65 |.rem .re|m $Heade|
|00001f10| 72 3a 20 64 72 6f 70 74 | 61 62 6c 65 73 2e 73 71 |r: dropt|ables.sq|
|00001f20| 6c 2c 76 20 36 2e 34 20 | 38 39 2f 31 31 2f 31 35 |l,v 6.4 |89/11/15|
|00001f30| 20 31 34 3a 31 37 3a 31 | 30 20 61 74 61 6d 20 45 | 14:17:1|0 atam E|
|00001f40| 78 70 20 24 20 64 72 6f | 70 74 61 62 6c 65 73 2e |xp $ dro|ptables.|
|00001f50| 73 71 6c 20 0a 72 65 6d | 20 0a 72 65 6d 0a 72 65 |sql .rem| .rem.re|
|00001f60| 6d 20 44 72 6f 70 20 61 | 6c 6c 20 74 68 65 20 74 |m Drop a|ll the t|
|00001f70| 61 62 6c 65 73 20 61 6e | 64 20 76 69 65 77 20 63 |ables an|d view c|
|00001f80| 72 65 61 74 65 64 20 69 | 6e 20 69 61 64 74 61 62 |reated i|n iadtab|
|00001f90| 6c 65 73 2e 73 71 6c 20 | 61 6e 64 20 69 61 64 76 |les.sql |and iadv|
|00001fa0| 69 65 77 73 2e 73 71 6c | 0a 72 65 6d 0a 0a 73 70 |iews.sql|.rem..sp|
|00001fb0| 6f 6f 6c 20 64 72 6f 70 | 74 61 62 6c 65 73 2e 6c |ool drop|tables.l|
|00001fc0| 69 73 0a 0a 64 72 6f 70 | 20 74 61 62 6c 65 20 66 |is..drop| table f|
|00001fd0| 6f 72 6d 5f 61 70 70 5f | 0a 2f 0a 64 72 6f 70 20 |orm_app_|./.drop |
|00001fe0| 74 61 62 6c 65 20 66 6f | 72 6d 5f 62 6c 6b 5f 0a |table fo|rm_blk_.|
|00001ff0| 2f 0a 64 72 6f 70 20 74 | 61 62 6c 65 20 66 6f 72 |/.drop t|able for|
|00002000| 6d 5f 66 6c 64 5f 0a 2f | 0a 64 72 6f 70 20 74 61 |m_fld_./|.drop ta|
|00002010| 62 6c 65 20 66 6f 72 6d | 5f 74 72 69 67 67 65 72 |ble form|_trigger|
|00002020| 5f 0a 2f 0a 64 72 6f 70 | 20 74 61 62 6c 65 20 66 |_./.drop| table f|
|00002030| 6f 72 6d 5f 74 72 67 5f | 0a 2f 0a 64 72 6f 70 20 |orm_trg_|./.drop |
|00002040| 74 61 62 6c 65 20 66 6f | 72 6d 5f 73 71 6c 74 78 |table fo|rm_sqltx|
|00002050| 74 5f 0a 2f 0a 64 72 6f | 70 20 74 61 62 6c 65 20 |t_./.dro|p table |
|00002060| 66 6f 72 6d 5f 70 61 67 | 65 5f 0a 2f 0a 64 72 6f |form_pag|e_./.dro|
|00002070| 70 20 74 61 62 6c 65 20 | 66 6f 72 6d 5f 6d 61 70 |p table |form_map|
|00002080| 5f 0a 2f 0a 64 72 6f 70 | 20 74 61 62 6c 65 20 66 |_./.drop| table f|
|00002090| 6f 72 6d 5f 63 6f 6d 6d | 65 6e 74 5f 0a 2f 0a 64 |orm_comm|ent_./.d|
|000020a0| 72 6f 70 20 74 61 62 6c | 65 20 66 6f 72 6d 5f 72 |rop tabl|e form_r|
|000020b0| 65 66 65 72 65 6e 63 65 | 5f 0a 2f 0a 64 72 6f 70 |eference|_./.drop|
|000020c0| 20 74 61 62 6c 65 20 66 | 6f 72 6d 5f 70 72 6f 63 | table f|orm_proc|
|000020d0| 65 64 75 72 65 5f 0a 2f | 0a 64 72 6f 70 20 76 69 |edure_./|.drop vi|
|000020e0| 65 77 20 66 6f 72 6d 5f | 61 70 70 0a 2f 0a 64 72 |ew form_|app./.dr|
|000020f0| 6f 70 20 76 69 65 77 20 | 66 6f 72 6d 5f 62 6c 6b |op view |form_blk|
|00002100| 0a 2f 0a 64 72 6f 70 20 | 76 69 65 77 20 66 6f 72 |./.drop |view for|
|00002110| 6d 5f 66 6c 64 0a 2f 0a | 64 72 6f 70 20 76 69 65 |m_fld./.|drop vie|
|00002120| 77 20 66 6f 72 6d 5f 74 | 72 69 67 67 65 72 0a 2f |w form_t|rigger./|
|00002130| 0a 64 72 6f 70 20 76 69 | 65 77 20 66 6f 72 6d 5f |.drop vi|ew form_|
|00002140| 74 72 67 0a 2f 0a 64 72 | 6f 70 20 76 69 65 77 20 |trg./.dr|op view |
|00002150| 66 6f 72 6d 5f 73 71 6c | 74 78 74 0a 2f 0a 64 72 |form_sql|txt./.dr|
|00002160| 6f 70 20 76 69 65 77 20 | 66 6f 72 6d 5f 70 61 67 |op view |form_pag|
|00002170| 65 0a 2f 0a 64 72 6f 70 | 20 76 69 65 77 20 66 6f |e./.drop| view fo|
|00002180| 72 6d 5f 6d 61 70 0a 2f | 0a 64 72 6f 70 20 76 69 |rm_map./|.drop vi|
|00002190| 65 77 20 66 6f 72 6d 5f | 63 6f 6d 6d 65 6e 74 0a |ew form_|comment.|
|000021a0| 2f 0a 64 72 6f 70 20 76 | 69 65 77 20 66 6f 72 6d |/.drop v|iew form|
|000021b0| 5f 72 65 66 65 72 65 6e | 63 65 0a 2f 0a 64 72 6f |_referen|ce./.dro|
|000021c0| 70 20 76 69 65 77 20 66 | 6f 72 6d 5f 70 72 6f 63 |p view f|orm_proc|
|000021d0| 65 64 75 72 65 0a 2f 0a | 64 72 6f 70 20 63 6c 75 |edure./.|drop clu|
|000021e0| 73 74 65 72 20 66 6f 72 | 6d 5f 74 61 62 6c 65 73 |ster for|m_tables|
|000021f0| 20 69 6e 63 6c 75 64 69 | 6e 67 20 74 61 62 6c 65 | includi|ng table|
|00002200| 73 0a 2f 0a 0a 73 70 6f | 6f 6c 20 6f 66 66 0a 30 |s./..spo|ol off.0|
|00002210| 37 30 37 30 37 30 30 30 | 34 35 30 30 31 31 33 33 |70707000|45001133|
|00002220| 32 31 30 30 34 34 34 30 | 30 30 33 31 31 30 30 30 |21004440|00311000|
|00002230| 30 36 32 30 30 30 30 30 | 31 30 30 30 30 30 30 30 |06200000|10000000|
|00002240| 34 37 36 34 35 37 35 37 | 31 33 30 30 30 30 32 32 |47645757|13000022|
|00002250| 30 30 30 30 30 30 30 32 | 32 30 33 61 64 6d 69 6e |00000002|203admin|
|00002260| 2f 69 61 64 64 72 6f 70 | 2e 73 71 6c 00 72 65 6d |/iaddrop|.sql.rem|
|00002270| 0a 72 65 6d 20 24 48 65 | 61 64 65 72 3a 20 69 61 |.rem $He|ader: ia|
|00002280| 64 64 72 6f 70 2e 73 71 | 6c 2c 76 20 33 30 30 31 |ddrop.sq|l,v 3001|
|00002290| 32 30 30 2e 31 20 38 39 | 2f 31 32 2f 30 35 20 31 |200.1 89|/12/05 1|
|000022a0| 34 3a 31 36 3a 34 34 20 | 72 63 73 20 45 78 70 20 |4:16:44 |rcs Exp |
|000022b0| 24 20 69 61 64 64 72 6f | 70 2e 73 71 6c 20 43 6f |$ iaddro|p.sql Co|
|000022c0| 70 79 72 20 28 63 29 20 | 31 39 38 39 20 4f 72 61 |pyr (c) |1989 Ora|
|000022d0| 63 6c 65 0a 72 65 6d 0a | 72 65 6d 20 53 51 4c 46 |cle.rem.|rem SQLF|
|000022e0| 4f 52 4d 53 33 30 33 30 | 30 31 32 2c 44 55 41 35 |ORMS3030|012,DUA5|
|000022f0| 30 3a 5b 46 52 45 45 5a | 45 5f 53 51 4c 46 4f 52 |0:[FREEZ|E_SQLFOR|
|00002300| 4d 53 33 30 2e 53 51 4c | 2e 33 30 30 31 32 5d 0a |MS30.SQL|.30012].|
|00002310| 52 65 6d 20 43 6f 70 79 | 72 69 67 68 74 20 28 63 |Rem Copy|right (c|
|00002320| 29 20 31 39 38 38 20 62 | 79 20 4f 72 61 63 6c 65 |) 1988 b|y Oracle|
|00002330| 20 43 6f 72 70 6f 72 61 | 74 69 6f 6e 0a 52 65 6d | Corpora|tion.Rem|
|00002340| 20 4e 41 4d 45 0a 52 65 | 6d 20 20 20 20 49 41 44 | NAME.Re|m IAD|
|00002350| 44 52 4f 50 2e 53 51 4c | 20 2d 20 44 72 6f 70 20 |DROP.SQL| - Drop |
|00002360| 53 51 4c 2a 46 6f 72 6d | 73 27 20 74 61 62 6c 65 |SQL*Form|s' table|
|00002370| 73 2c 20 76 69 65 77 73 | 20 61 6e 64 20 73 79 6e |s, views| and syn|
|00002380| 6f 6e 79 6d 73 2e 0a 52 | 65 6d 20 20 46 55 4e 43 |onyms..R|em FUNC|
|00002390| 54 49 4f 4e 0a 52 65 6d | 20 20 4e 4f 54 45 53 0a |TION.Rem| NOTES.|
|000023a0| 52 65 6d 20 20 4d 4f 44 | 49 46 49 45 44 0a 52 65 |Rem MOD|IFIED.Re|
|000023b0| 6d 20 20 20 48 73 69 20 | 20 20 20 20 20 20 20 31 |m Hsi | 1|
|000023c0| 31 2f 30 37 2f 38 39 20 | 2d 20 43 72 65 61 74 69 |1/07/89 |- Creati|
|000023d0| 6f 6e 0a 52 65 6d 0a 0a | 73 70 6f 6f 6c 20 69 61 |on.Rem..|spool ia|
|000023e0| 64 64 72 6f 70 2e 6c 69 | 73 0a 0a 52 65 6d 0a 52 |ddrop.li|s..Rem.R|
|000023f0| 65 6d 20 20 44 72 6f 70 | 20 61 6c 6c 20 74 61 62 |em Drop| all tab|
|00002400| 6c 65 73 20 69 6e 20 74 | 68 65 20 63 6c 75 73 74 |les in t|he clust|
|00002410| 65 72 0a 52 65 6d 20 0a | 64 72 6f 70 20 63 6c 75 |er.Rem .|drop clu|
|00002420| 73 74 65 72 20 66 6f 72 | 6d 5f 74 61 62 6c 65 73 |ster for|m_tables|
|00002430| 20 69 6e 63 6c 75 64 69 | 6e 67 20 74 61 62 6c 65 | includi|ng table|
|00002440| 73 0a 2f 0a 0a 52 65 6d | 0a 52 65 6d 20 20 44 72 |s./..Rem|.Rem Dr|
|00002450| 6f 70 20 76 69 65 77 73 | 0a 52 65 6d 0a 64 72 6f |op views|.Rem.dro|
|00002460| 70 20 76 69 65 77 20 66 | 6f 72 6d 5f 61 70 70 0a |p view f|orm_app.|
|00002470| 2f 0a 64 72 6f 70 20 76 | 69 65 77 20 66 6f 72 6d |/.drop v|iew form|
|00002480| 5f 62 6c 6b 0a 2f 0a 64 | 72 6f 70 20 76 69 65 77 |_blk./.d|rop view|
|00002490| 20 66 6f 72 6d 5f 66 6c | 64 0a 2f 0a 64 72 6f 70 | form_fl|d./.drop|
|000024a0| 20 76 69 65 77 20 66 6f | 72 6d 5f 74 72 69 67 67 | view fo|rm_trigg|
|000024b0| 65 72 0a 2f 0a 64 72 6f | 70 20 76 69 65 77 20 66 |er./.dro|p view f|
|000024c0| 6f 72 6d 5f 74 72 67 0a | 2f 0a 64 72 6f 70 20 76 |orm_trg.|/.drop v|
|000024d0| 69 65 77 20 66 6f 72 6d | 5f 73 71 6c 74 78 74 0a |iew form|_sqltxt.|
|000024e0| 2f 0a 64 72 6f 70 20 76 | 69 65 77 20 66 6f 72 6d |/.drop v|iew form|
|000024f0| 5f 70 61 67 65 0a 2f 0a | 64 72 6f 70 20 76 69 65 |_page./.|drop vie|
|00002500| 77 20 66 6f 72 6d 5f 6d | 61 70 0a 2f 0a 64 72 6f |w form_m|ap./.dro|
|00002510| 70 20 76 69 65 77 20 66 | 6f 72 6d 5f 63 6f 6d 6d |p view f|orm_comm|
|00002520| 65 6e 74 0a 2f 0a 64 72 | 6f 70 20 76 69 65 77 20 |ent./.dr|op view |
|00002530| 66 6f 72 6d 5f 72 65 66 | 65 72 65 6e 63 65 0a 2f |form_ref|erence./|
|00002540| 0a 64 72 6f 70 20 76 69 | 65 77 20 66 6f 72 6d 5f |.drop vi|ew form_|
|00002550| 70 72 6f 63 65 64 75 72 | 65 0a 2f 0a 52 65 6d 0a |procedur|e./.Rem.|
|00002560| 52 65 6d 20 20 44 72 6f | 70 20 73 79 6e 6f 6e 79 |Rem Dro|p synony|
|00002570| 6d 73 0a 52 65 6d 0a 64 | 72 6f 70 20 70 75 62 6c |ms.Rem.d|rop publ|
|00002580| 69 63 20 73 79 6e 6f 6e | 79 6d 20 66 6f 72 6d 5f |ic synon|ym form_|
|00002590| 61 70 70 0a 2f 0a 64 72 | 6f 70 20 70 75 62 6c 69 |app./.dr|op publi|
|000025a0| 63 20 73 79 6e 6f 6e 79 | 6d 20 66 6f 72 6d 5f 62 |c synony|m form_b|
|000025b0| 6c 6b 0a 2f 0a 64 72 6f | 70 20 70 75 62 6c 69 63 |lk./.dro|p public|
|000025c0| 20 73 79 6e 6f 6e 79 6d | 20 66 6f 72 6d 5f 66 6c | synonym| form_fl|
|000025d0| 64 0a 2f 0a 64 72 6f 70 | 20 70 75 62 6c 69 63 20 |d./.drop| public |
|000025e0| 73 79 6e 6f 6e 79 6d 20 | 66 6f 72 6d 5f 70 61 67 |synonym |form_pag|
|000025f0| 65 0a 2f 0a 64 72 6f 70 | 20 70 75 62 6c 69 63 20 |e./.drop| public |
|00002600| 73 79 6e 6f 6e 79 6d 20 | 66 6f 72 6d 5f 6d 61 70 |synonym |form_map|
|00002610| 0a 2f 0a 64 72 6f 70 20 | 70 75 62 6c 69 63 20 73 |./.drop |public s|
|00002620| 79 6e 6f 6e 79 6d 20 66 | 6f 72 6d 5f 73 71 6c 74 |ynonym f|orm_sqlt|
|00002630| 78 74 0a 2f 0a 64 72 6f | 70 20 70 75 62 6c 69 63 |xt./.dro|p public|
|00002640| 20 73 79 6e 6f 6e 79 6d | 20 66 6f 72 6d 5f 74 72 | synonym| form_tr|
|00002650| 67 0a 2f 0a 64 72 6f 70 | 20 70 75 62 6c 69 63 20 |g./.drop| public |
|00002660| 73 79 6e 6f 6e 79 6d 20 | 66 6f 72 6d 5f 74 72 69 |synonym |form_tri|
|00002670| 67 67 65 72 0a 2f 0a 64 | 72 6f 70 20 70 75 62 6c |gger./.d|rop publ|
|00002680| 69 63 20 73 79 6e 6f 6e | 79 6d 20 66 6f 72 6d 5f |ic synon|ym form_|
|00002690| 63 6f 6d 6d 65 6e 74 0a | 2f 0a 64 72 6f 70 20 70 |comment.|/.drop p|
|000026a0| 75 62 6c 69 63 20 73 79 | 6e 6f 6e 79 6d 20 66 6f |ublic sy|nonym fo|
|000026b0| 72 6d 5f 72 65 66 65 72 | 65 6e 63 65 0a 2f 0a 64 |rm_refer|ence./.d|
|000026c0| 72 6f 70 20 70 75 62 6c | 69 63 20 73 79 6e 6f 6e |rop publ|ic synon|
|000026d0| 79 6d 20 66 6f 72 6d 5f | 70 72 6f 63 65 64 75 72 |ym form_|procedur|
|000026e0| 65 0a 2f 0a 0a 73 70 6f | 6f 6c 20 6f 66 66 0a 0a |e./..spo|ol off..|
|000026f0| 30 37 30 37 30 37 30 30 | 30 34 35 30 30 31 31 33 |07070700|04500113|
|00002700| 33 33 31 30 30 34 34 34 | 30 30 30 33 31 31 30 30 |33100444|00031100|
|00002710| 30 30 36 32 30 30 30 30 | 30 31 30 30 30 30 30 30 |00620000|01000000|
|00002720| 30 34 37 36 34 35 37 35 | 37 31 33 30 30 30 30 32 |04764575|71300002|
|00002730| 33 30 30 30 30 30 30 30 | 34 36 33 34 61 64 6d 69 |30000000|4634admi|
|00002740| 6e 2f 69 61 64 67 72 61 | 6e 74 2e 73 71 6c 00 72 |n/iadgra|nt.sql.r|
|00002750| 65 6d 0a 72 65 6d 20 24 | 48 65 61 64 65 72 3a 20 |em.rem $|Header: |
|00002760| 69 61 64 67 72 61 6e 74 | 2e 73 71 6c 2c 76 20 33 |iadgrant|.sql,v 3|
|00002770| 30 30 31 34 30 30 2e 31 | 20 39 30 2f 30 32 2f 32 |001400.1| 90/02/2|
|00002780| 37 20 31 34 3a 34 33 3a | 34 35 20 72 63 73 20 45 |7 14:43:|45 rcs E|
|00002790| 78 70 20 24 20 69 61 64 | 67 72 61 6e 74 2e 73 71 |xp $ iad|grant.sq|
|000027a0| 6c 20 43 6f 70 79 72 20 | 28 63 29 20 31 39 38 39 |l Copyr |(c) 1989|
|000027b0| 20 4f 72 61 63 6c 65 0a | 72 65 6d 0a 72 65 6d 20 | Oracle.|rem.rem |
|000027c0| 53 51 4c 46 4f 52 4d 53 | 33 30 33 30 30 31 34 2c |SQLFORMS|3030014,|
|000027d0| 44 55 41 35 30 3a 5b 46 | 52 45 45 5a 45 5f 53 51 |DUA50:[F|REEZE_SQ|
|000027e0| 4c 46 4f 52 4d 53 33 30 | 2e 53 51 4c 2e 33 30 30 |LFORMS30|.SQL.300|
|000027f0| 31 34 5d 0a 52 65 6d 20 | 43 6f 70 79 72 69 67 68 |14].Rem |Copyrigh|
|00002800| 74 20 28 63 29 20 31 39 | 38 38 20 62 79 20 4f 72 |t (c) 19|88 by Or|
|00002810| 61 63 6c 65 20 43 6f 72 | 70 6f 72 61 74 69 6f 6e |acle Cor|poration|
|00002820| 0a 52 65 6d 20 4e 41 4d | 45 0a 52 65 6d 20 20 20 |.Rem NAM|E.Rem |
|00002830| 20 49 41 44 47 52 41 4e | 54 53 2e 53 51 4c 20 2d | IADGRAN|TS.SQL -|
|00002840| 20 47 72 61 6e 74 20 70 | 72 69 76 69 6c 65 67 65 | Grant p|rivilege|
|00002850| 73 20 61 6e 64 20 63 72 | 65 61 74 65 20 73 79 6e |s and cr|eate syn|
|00002860| 6f 6e 79 6d 73 20 6f 6e | 20 74 61 62 6c 65 73 2e |onyms on| tables.|
|00002870| 0a 52 65 6d 20 20 46 55 | 4e 43 54 49 4f 4e 0a 52 |.Rem FU|NCTION.R|
|00002880| 65 6d 20 20 4e 4f 54 45 | 53 0a 52 65 6d 20 20 4d |em NOTE|S.Rem M|
|00002890| 4f 44 49 46 49 45 44 0a | 52 65 6d 20 20 20 45 69 |ODIFIED.|Rem Ei|
|000028a0| 63 68 65 72 20 20 20 20 | 20 30 32 2f 30 35 2f 39 |cher | 02/05/9|
|000028b0| 30 20 2d 20 43 72 65 61 | 74 69 6f 6e 0a 52 65 6d |0 - Crea|tion.Rem|
|000028c0| 20 20 20 45 69 63 68 65 | 72 20 20 20 20 20 30 32 | Eiche|r 02|
|000028d0| 2f 30 35 2f 39 30 20 2d | 20 52 65 6e 61 6d 65 64 |/05/90 -| Renamed|
|000028e0| 20 66 72 6f 6d 20 69 61 | 64 67 72 61 6e 74 73 2e | from ia|dgrants.|
|000028f0| 73 71 6c 2c 20 72 65 6e | 61 6d 65 64 20 73 70 6f |sql, ren|amed spo|
|00002900| 6f 6c 20 66 69 6c 65 0a | 52 65 6d 20 20 20 46 69 |ol file.|Rem Fi|
|00002910| 6e 65 20 20 20 20 20 20 | 20 30 31 2f 32 35 2f 38 |ne | 01/25/8|
|00002920| 39 20 2d 20 54 4f 55 43 | 48 0a 52 65 6d 20 20 20 |9 - TOUC|H.Rem |
|00002930| 48 73 69 20 20 20 20 20 | 20 20 20 30 38 2f 33 31 |Hsi | 08/31|
|00002940| 2f 38 38 20 2d 20 43 68 | 61 6e 67 65 20 74 61 62 |/88 - Ch|ange tab|
|00002950| 6c 65 73 27 20 6e 61 6d | 65 0a 52 65 6d 20 20 20 |les' nam|e.Rem |
|00002960| 48 73 69 20 20 20 20 20 | 20 20 20 30 38 2f 33 31 |Hsi | 08/31|
|00002970| 2f 38 38 20 2d 20 43 72 | 65 61 74 69 6f 6e 0a 52 |/88 - Cr|eation.R|
|00002980| 65 6d 0a 73 70 6f 6f 6c | 20 69 61 64 67 72 61 6e |em.spool| iadgran|
|00002990| 74 2e 6c 69 73 0a 67 72 | 61 6e 74 20 73 65 6c 65 |t.lis.gr|ant sele|
|000029a0| 63 74 2c 20 69 6e 73 65 | 72 74 2c 20 75 70 64 61 |ct, inse|rt, upda|
|000029b0| 74 65 2c 20 64 65 6c 65 | 74 65 0a 6f 6e 20 20 20 |te, dele|te.on |
|000029c0| 20 73 79 73 74 65 6d 2e | 66 6f 72 6d 5f 61 70 70 | system.|form_app|
|000029d0| 0a 74 6f 20 20 20 20 70 | 75 62 6c 69 63 0a 2f 0a |.to p|ublic./.|
|000029e0| 67 72 61 6e 74 20 73 65 | 6c 65 63 74 2c 20 69 6e |grant se|lect, in|
|000029f0| 73 65 72 74 2c 20 75 70 | 64 61 74 65 2c 20 64 65 |sert, up|date, de|
|00002a00| 6c 65 74 65 0a 6f 6e 20 | 20 20 20 73 79 73 74 65 |lete.on | syste|
|00002a10| 6d 2e 66 6f 72 6d 5f 62 | 6c 6b 0a 74 6f 20 20 20 |m.form_b|lk.to |
|00002a20| 20 70 75 62 6c 69 63 0a | 2f 0a 67 72 61 6e 74 20 | public.|/.grant |
|00002a30| 73 65 6c 65 63 74 2c 20 | 69 6e 73 65 72 74 2c 20 |select, |insert, |
|00002a40| 75 70 64 61 74 65 2c 20 | 64 65 6c 65 74 65 0a 6f |update, |delete.o|
|00002a50| 6e 20 20 20 20 73 79 73 | 74 65 6d 2e 66 6f 72 6d |n sys|tem.form|
|00002a60| 5f 66 6c 64 0a 74 6f 20 | 20 20 20 70 75 62 6c 69 |_fld.to | publi|
|00002a70| 63 0a 2f 0a 67 72 61 6e | 74 20 73 65 6c 65 63 74 |c./.gran|t select|
|00002a80| 2c 20 69 6e 73 65 72 74 | 2c 20 75 70 64 61 74 65 |, insert|, update|
|00002a90| 2c 20 64 65 6c 65 74 65 | 0a 6f 6e 20 20 20 20 73 |, delete|.on s|
|00002aa0| 79 73 74 65 6d 2e 66 6f | 72 6d 5f 70 61 67 65 0a |ystem.fo|rm_page.|
|00002ab0| 74 6f 20 20 20 20 70 75 | 62 6c 69 63 0a 2f 0a 67 |to pu|blic./.g|
|00002ac0| 72 61 6e 74 20 73 65 6c | 65 63 74 2c 20 69 6e 73 |rant sel|ect, ins|
|00002ad0| 65 72 74 2c 20 75 70 64 | 61 74 65 2c 20 64 65 6c |ert, upd|ate, del|
|00002ae0| 65 74 65 0a 6f 6e 20 20 | 20 20 73 79 73 74 65 6d |ete.on | system|
|00002af0| 2e 66 6f 72 6d 5f 6d 61 | 70 0a 74 6f 20 20 20 20 |.form_ma|p.to |
|00002b00| 70 75 62 6c 69 63 0a 2f | 0a 67 72 61 6e 74 20 73 |public./|.grant s|
|00002b10| 65 6c 65 63 74 2c 20 69 | 6e 73 65 72 74 2c 20 75 |elect, i|nsert, u|
|00002b20| 70 64 61 74 65 2c 20 64 | 65 6c 65 74 65 0a 6f 6e |pdate, d|elete.on|
|00002b30| 20 20 20 20 73 79 73 74 | 65 6d 2e 66 6f 72 6d 5f | syst|em.form_|
|00002b40| 73 71 6c 74 78 74 0a 74 | 6f 20 20 20 20 70 75 62 |sqltxt.t|o pub|
|00002b50| 6c 69 63 0a 2f 0a 67 72 | 61 6e 74 20 73 65 6c 65 |lic./.gr|ant sele|
|00002b60| 63 74 2c 20 69 6e 73 65 | 72 74 2c 20 75 70 64 61 |ct, inse|rt, upda|
|00002b70| 74 65 2c 20 64 65 6c 65 | 74 65 0a 6f 6e 20 20 20 |te, dele|te.on |
|00002b80| 20 73 79 73 74 65 6d 2e | 66 6f 72 6d 5f 74 72 67 | system.|form_trg|
|00002b90| 0a 74 6f 20 20 20 20 70 | 75 62 6c 69 63 0a 2f 0a |.to p|ublic./.|
|00002ba0| 67 72 61 6e 74 20 73 65 | 6c 65 63 74 2c 20 69 6e |grant se|lect, in|
|00002bb0| 73 65 72 74 2c 20 75 70 | 64 61 74 65 2c 20 64 65 |sert, up|date, de|
|00002bc0| 6c 65 74 65 0a 6f 6e 20 | 20 20 20 73 79 73 74 65 |lete.on | syste|
|00002bd0| 6d 2e 66 6f 72 6d 5f 74 | 72 69 67 67 65 72 0a 74 |m.form_t|rigger.t|
|00002be0| 6f 20 20 20 20 70 75 62 | 6c 69 63 0a 2f 0a 67 72 |o pub|lic./.gr|
|00002bf0| 61 6e 74 20 73 65 6c 65 | 63 74 2c 20 69 6e 73 65 |ant sele|ct, inse|
|00002c00| 72 74 2c 20 75 70 64 61 | 74 65 2c 20 64 65 6c 65 |rt, upda|te, dele|
|00002c10| 74 65 0a 6f 6e 20 20 20 | 20 73 79 73 74 65 6d 2e |te.on | system.|
|00002c20| 66 6f 72 6d 5f 63 6f 6d | 6d 65 6e 74 0a 74 6f 20 |form_com|ment.to |
|00002c30| 20 20 20 70 75 62 6c 69 | 63 0a 2f 0a 67 72 61 6e | publi|c./.gran|
|00002c40| 74 20 73 65 6c 65 63 74 | 2c 20 69 6e 73 65 72 74 |t select|, insert|
|00002c50| 2c 20 75 70 64 61 74 65 | 2c 20 64 65 6c 65 74 65 |, update|, delete|
|00002c60| 0a 6f 6e 20 20 20 20 73 | 79 73 74 65 6d 2e 66 6f |.on s|ystem.fo|
|00002c70| 72 6d 5f 72 65 66 65 72 | 65 6e 63 65 0a 74 6f 20 |rm_refer|ence.to |
|00002c80| 20 20 20 70 75 62 6c 69 | 63 0a 2f 0a 67 72 61 6e | publi|c./.gran|
|00002c90| 74 20 73 65 6c 65 63 74 | 2c 20 69 6e 73 65 72 74 |t select|, insert|
|00002ca0| 2c 20 75 70 64 61 74 65 | 2c 20 64 65 6c 65 74 65 |, update|, delete|
|00002cb0| 0a 6f 6e 20 20 20 20 73 | 79 73 74 65 6d 2e 66 6f |.on s|ystem.fo|
|00002cc0| 72 6d 5f 70 72 6f 63 65 | 64 75 72 65 0a 74 6f 20 |rm_proce|dure.to |
|00002cd0| 20 20 20 70 75 62 6c 69 | 63 0a 2f 0a 64 72 6f 70 | publi|c./.drop|
|00002ce0| 20 70 75 62 6c 69 63 20 | 73 79 6e 6f 6e 79 6d 20 | public |synonym |
|00002cf0| 66 6f 72 6d 5f 61 70 70 | 0a 2f 0a 63 72 65 61 74 |form_app|./.creat|
|00002d00| 65 20 70 75 62 6c 69 63 | 20 73 79 6e 6f 6e 79 6d |e public| synonym|
|00002d10| 20 66 6f 72 6d 5f 61 70 | 70 0a 66 6f 72 20 20 20 | form_ap|p.for |
|00002d20| 20 73 79 73 74 65 6d 2e | 66 6f 72 6d 5f 61 70 70 | system.|form_app|
|00002d30| 0a 2f 0a 64 72 6f 70 20 | 70 75 62 6c 69 63 20 73 |./.drop |public s|
|00002d40| 79 6e 6f 6e 79 6d 20 66 | 6f 72 6d 5f 62 6c 6b 0a |ynonym f|orm_blk.|
|00002d50| 2f 0a 63 72 65 61 74 65 | 20 70 75 62 6c 69 63 20 |/.create| public |
|00002d60| 73 79 6e 6f 6e 79 6d 20 | 66 6f 72 6d 5f 62 6c 6b |synonym |form_blk|
|00002d70| 0a 66 6f 72 20 20 20 20 | 73 79 73 74 65 6d 2e 66 |.for |system.f|
|00002d80| 6f 72 6d 5f 62 6c 6b 0a | 2f 0a 64 72 6f 70 20 70 |orm_blk.|/.drop p|
|00002d90| 75 62 6c 69 63 20 73 79 | 6e 6f 6e 79 6d 20 66 6f |ublic sy|nonym fo|
|00002da0| 72 6d 5f 66 6c 64 0a 2f | 0a 63 72 65 61 74 65 20 |rm_fld./|.create |
|00002db0| 70 75 62 6c 69 63 20 73 | 79 6e 6f 6e 79 6d 20 66 |public s|ynonym f|
|00002dc0| 6f 72 6d 5f 66 6c 64 0a | 66 6f 72 20 20 20 20 73 |orm_fld.|for s|
|00002dd0| 79 73 74 65 6d 2e 66 6f | 72 6d 5f 66 6c 64 0a 2f |ystem.fo|rm_fld./|
|00002de0| 0a 64 72 6f 70 20 70 75 | 62 6c 69 63 20 73 79 6e |.drop pu|blic syn|
|00002df0| 6f 6e 79 6d 20 66 6f 72 | 6d 5f 70 61 67 65 0a 2f |onym for|m_page./|
|00002e00| 0a 63 72 65 61 74 65 20 | 70 75 62 6c 69 63 20 73 |.create |public s|
|00002e10| 79 6e 6f 6e 79 6d 20 66 | 6f 72 6d 5f 70 61 67 65 |ynonym f|orm_page|
|00002e20| 0a 66 6f 72 20 20 20 20 | 73 79 73 74 65 6d 2e 66 |.for |system.f|
|00002e30| 6f 72 6d 5f 70 61 67 65 | 0a 2f 0a 64 72 6f 70 20 |orm_page|./.drop |
|00002e40| 70 75 62 6c 69 63 20 73 | 79 6e 6f 6e 79 6d 20 66 |public s|ynonym f|
|00002e50| 6f 72 6d 5f 6d 61 70 0a | 2f 0a 63 72 65 61 74 65 |orm_map.|/.create|
|00002e60| 20 70 75 62 6c 69 63 20 | 73 79 6e 6f 6e 79 6d 20 | public |synonym |
|00002e70| 66 6f 72 6d 5f 6d 61 70 | 0a 66 6f 72 20 20 20 20 |form_map|.for |
|00002e80| 73 79 73 74 65 6d 2e 66 | 6f 72 6d 5f 6d 61 70 0a |system.f|orm_map.|
|00002e90| 2f 0a 64 72 6f 70 20 70 | 75 62 6c 69 63 20 73 79 |/.drop p|ublic sy|
|00002ea0| 6e 6f 6e 79 6d 20 66 6f | 72 6d 5f 73 71 6c 74 78 |nonym fo|rm_sqltx|
|00002eb0| 74 0a 2f 0a 63 72 65 61 | 74 65 20 70 75 62 6c 69 |t./.crea|te publi|
|00002ec0| 63 20 73 79 6e 6f 6e 79 | 6d 20 66 6f 72 6d 5f 73 |c synony|m form_s|
|00002ed0| 71 6c 74 78 74 0a 66 6f | 72 20 20 20 20 73 79 73 |qltxt.fo|r sys|
|00002ee0| 74 65 6d 2e 66 6f 72 6d | 5f 73 71 6c 74 78 74 0a |tem.form|_sqltxt.|
|00002ef0| 2f 0a 64 72 6f 70 20 70 | 75 62 6c 69 63 20 73 79 |/.drop p|ublic sy|
|00002f00| 6e 6f 6e 79 6d 20 66 6f | 72 6d 5f 74 72 67 0a 2f |nonym fo|rm_trg./|
|00002f10| 0a 63 72 65 61 74 65 20 | 70 75 62 6c 69 63 20 73 |.create |public s|
|00002f20| 79 6e 6f 6e 79 6d 20 66 | 6f 72 6d 5f 74 72 67 0a |ynonym f|orm_trg.|
|00002f30| 66 6f 72 20 20 20 20 73 | 79 73 74 65 6d 2e 66 6f |for s|ystem.fo|
|00002f40| 72 6d 5f 74 72 67 0a 2f | 0a 64 72 6f 70 20 70 75 |rm_trg./|.drop pu|
|00002f50| 62 6c 69 63 20 73 79 6e | 6f 6e 79 6d 20 66 6f 72 |blic syn|onym for|
|00002f60| 6d 5f 74 72 69 67 67 65 | 72 0a 2f 0a 63 72 65 61 |m_trigge|r./.crea|
|00002f70| 74 65 20 70 75 62 6c 69 | 63 20 73 79 6e 6f 6e 79 |te publi|c synony|
|00002f80| 6d 20 66 6f 72 6d 5f 74 | 72 69 67 67 65 72 0a 66 |m form_t|rigger.f|
|00002f90| 6f 72 20 20 20 20 73 79 | 73 74 65 6d 2e 66 6f 72 |or sy|stem.for|
|00002fa0| 6d 5f 74 72 69 67 67 65 | 72 0a 2f 0a 64 72 6f 70 |m_trigge|r./.drop|
|00002fb0| 20 70 75 62 6c 69 63 20 | 73 79 6e 6f 6e 79 6d 20 | public |synonym |
|00002fc0| 66 6f 72 6d 5f 63 6f 6d | 6d 65 6e 74 0a 2f 0a 63 |form_com|ment./.c|
|00002fd0| 72 65 61 74 65 20 70 75 | 62 6c 69 63 20 73 79 6e |reate pu|blic syn|
|00002fe0| 6f 6e 79 6d 20 66 6f 72 | 6d 5f 63 6f 6d 6d 65 6e |onym for|m_commen|
|00002ff0| 74 0a 66 6f 72 20 20 20 | 20 73 79 73 74 65 6d 2e |t.for | system.|
|00003000| 66 6f 72 6d 5f 63 6f 6d | 6d 65 6e 74 0a 2f 0a 64 |form_com|ment./.d|
|00003010| 72 6f 70 20 70 75 62 6c | 69 63 20 73 79 6e 6f 6e |rop publ|ic synon|
|00003020| 79 6d 20 66 6f 72 6d 5f | 72 65 66 65 72 65 6e 63 |ym form_|referenc|
|00003030| 65 0a 2f 0a 63 72 65 61 | 74 65 20 70 75 62 6c 69 |e./.crea|te publi|
|00003040| 63 20 73 79 6e 6f 6e 79 | 6d 20 66 6f 72 6d 5f 72 |c synony|m form_r|
|00003050| 65 66 65 72 65 6e 63 65 | 0a 66 6f 72 20 20 20 20 |eference|.for |
|00003060| 73 79 73 74 65 6d 2e 66 | 6f 72 6d 5f 72 65 66 65 |system.f|orm_refe|
|00003070| 72 65 6e 63 65 0a 2f 0a | 64 72 6f 70 20 70 75 62 |rence./.|drop pub|
|00003080| 6c 69 63 20 73 79 6e 6f | 6e 79 6d 20 66 6f 72 6d |lic syno|nym form|
|00003090| 5f 70 72 6f 63 65 64 75 | 72 65 0a 2f 0a 63 72 65 |_procedu|re./.cre|
|000030a0| 61 74 65 20 70 75 62 6c | 69 63 20 73 79 6e 6f 6e |ate publ|ic synon|
|000030b0| 79 6d 20 66 6f 72 6d 5f | 70 72 6f 63 65 64 75 72 |ym form_|procedur|
|000030c0| 65 0a 66 6f 72 20 20 20 | 20 73 79 73 74 65 6d 2e |e.for | system.|
|000030d0| 66 6f 72 6d 5f 70 72 6f | 63 65 64 75 72 65 0a 2f |form_pro|cedure./|
|000030e0| 0a 73 70 6f 6f 6c 20 6f | 66 66 0a 30 37 30 37 30 |.spool o|ff.07070|
|000030f0| 37 30 30 30 34 35 30 30 | 31 31 33 33 34 31 30 30 |70004500|11334100|
|00003100| 34 34 34 30 30 30 33 31 | 31 30 30 30 30 36 32 30 |44400031|10000620|
|00003110| 30 30 30 30 31 30 30 30 | 30 30 30 30 34 37 36 34 |00001000|00004764|
|00003120| 35 37 35 37 31 33 30 30 | 30 30 32 33 30 30 30 30 |57571300|00230000|
|00003130| 30 30 30 34 30 31 30 61 | 64 6d 69 6e 2f 69 61 64 |0004010a|dmin/iad|
|00003140| 69 6e 64 65 78 2e 73 71 | 6c 00 72 65 6d 0a 72 65 |index.sq|l.rem.re|
|00003150| 6d 20 24 48 65 61 64 65 | 72 3a 20 69 61 64 69 6e |m $Heade|r: iadin|
|00003160| 64 65 78 2e 73 71 6c 2c | 76 20 33 30 30 31 34 30 |dex.sql,|v 300140|
|00003170| 30 2e 31 20 39 30 2f 30 | 32 2f 32 37 20 31 34 3a |0.1 90/0|2/27 14:|
|00003180| 34 36 3a 35 34 20 72 63 | 73 20 45 78 70 20 24 20 |46:54 rc|s Exp $ |
|00003190| 69 61 64 69 6e 64 65 78 | 2e 73 71 6c 20 43 6f 70 |iadindex|.sql Cop|
|000031a0| 79 72 20 28 63 29 20 31 | 39 38 39 20 4f 72 61 63 |yr (c) 1|989 Orac|
|000031b0| 6c 65 0a 72 65 6d 0a 72 | 65 6d 20 53 51 4c 46 4f |le.rem.r|em SQLFO|
|000031c0| 52 4d 53 33 30 33 30 30 | 31 34 2c 44 55 41 35 30 |RMS30300|14,DUA50|
|000031d0| 3a 5b 46 52 45 45 5a 45 | 5f 53 51 4c 46 4f 52 4d |:[FREEZE|_SQLFORM|
|000031e0| 53 33 30 2e 53 51 4c 2e | 33 30 30 31 34 5d 0a 52 |S30.SQL.|30014].R|
|000031f0| 65 6d 20 43 6f 70 79 72 | 69 67 68 74 20 28 63 29 |em Copyr|ight (c)|
|00003200| 20 31 39 38 38 20 62 79 | 20 4f 72 61 63 6c 65 20 | 1988 by| Oracle |
|00003210| 43 6f 72 70 6f 72 61 74 | 69 6f 6e 0a 52 65 6d 20 |Corporat|ion.Rem |
|00003220| 4e 41 4d 45 0a 52 65 6d | 20 20 20 20 49 41 44 49 |NAME.Rem| IADI|
|00003230| 4e 44 45 58 45 53 2e 53 | 51 4c 20 2d 20 43 72 65 |NDEXES.S|QL - Cre|
|00003240| 61 74 65 20 69 6e 64 65 | 78 65 73 20 6f 6e 20 66 |ate inde|xes on f|
|00003250| 6f 72 6d 27 73 20 74 61 | 62 6c 65 73 0a 52 65 6d |orm's ta|bles.Rem|
|00003260| 20 20 46 55 4e 43 54 49 | 4f 4e 0a 52 65 6d 20 20 | FUNCTI|ON.Rem |
|00003270| 4e 4f 54 45 53 0a 52 65 | 6d 20 20 4d 4f 44 49 46 |NOTES.Re|m MODIF|
|00003280| 49 45 44 0a 52 65 6d 20 | 20 20 45 69 63 68 65 72 |IED.Rem | Eicher|
|00003290| 20 20 20 20 20 30 32 2f | 30 35 2f 39 30 20 2d 20 | 02/|05/90 - |
|000032a0| 43 72 65 61 74 69 6f 6e | 0a 52 65 6d 20 20 20 45 |Creation|.Rem E|
|000032b0| 69 63 68 65 72 20 20 20 | 20 20 30 32 2f 30 35 2f |icher | 02/05/|
|000032c0| 39 30 20 2d 20 52 65 6e | 61 6d 65 64 20 66 72 6f |90 - Ren|amed fro|
|000032d0| 6d 20 69 61 64 69 6e 64 | 65 78 65 73 2e 73 71 6c |m iadind|exes.sql|
|000032e0| 20 61 6e 64 20 72 65 6e | 61 6d 65 20 73 70 6f 6f | and ren|ame spoo|
|000032f0| 6c 20 66 69 6c 65 0a 52 | 65 6d 20 20 20 48 73 69 |l file.R|em Hsi|
|00003300| 20 20 20 20 20 20 20 20 | 30 32 2f 31 34 2f 38 39 | |02/14/89|
|00003310| 20 2d 20 43 72 65 61 74 | 65 20 69 6e 64 65 78 20 | - Creat|e index |
|00003320| 6f 6e 20 63 6c 75 73 74 | 65 72 20 66 6f 72 6d 5f |on clust|er form_|
|00003330| 74 61 62 6c 65 73 20 28 | 56 33 2e 30 2e 35 29 0a |tables (|V3.0.5).|
|00003340| 52 65 6d 20 20 20 46 69 | 6e 65 20 20 20 20 20 20 |Rem Fi|ne |
|00003350| 20 30 31 2f 32 35 2f 38 | 39 20 2d 20 54 4f 55 43 | 01/25/8|9 - TOUC|
|00003360| 48 0a 52 65 6d 20 20 20 | 46 69 6e 65 20 20 20 20 |H.Rem |Fine |
|00003370| 20 20 20 31 32 2f 30 38 | 2f 38 38 20 2d 20 46 6f | 12/08|/88 - Fo|
|00003380| 6c 64 20 69 6e 20 55 4e | 49 58 20 70 6f 72 74 69 |ld in UN|IX porti|
|00003390| 6e 67 20 63 68 61 6e 67 | 65 73 0a 52 65 6d 20 20 |ng chang|es.Rem |
|000033a0| 20 48 73 69 20 20 20 20 | 20 20 20 20 30 38 2f 33 | Hsi | 08/3|
|000033b0| 31 2f 38 38 20 2d 20 43 | 68 61 6e 67 65 20 74 61 |1/88 - C|hange ta|
|000033c0| 62 6c 65 73 27 20 6e 61 | 6d 65 0a 52 65 6d 20 20 |bles' na|me.Rem |
|000033d0| 20 48 73 69 20 20 20 20 | 20 20 20 20 30 38 2f 32 | Hsi | 08/2|
|000033e0| 36 2f 38 38 20 2d 20 43 | 72 65 61 74 69 6f 6e 0a |6/88 - C|reation.|
|000033f0| 52 65 6d 0a 0a 73 70 6f | 6f 6c 20 69 61 64 69 6e |Rem..spo|ol iadin|
|00003400| 64 65 78 2e 6c 69 73 0a | 0a 64 72 6f 70 20 69 6e |dex.lis.|.drop in|
|00003410| 64 65 78 20 69 66 6f 72 | 6d 5f 61 70 70 0a 2f 0a |dex ifor|m_app./.|
|00003420| 63 72 65 61 74 65 20 69 | 6e 64 65 78 20 69 66 6f |create i|ndex ifo|
|00003430| 72 6d 5f 61 70 70 0a 6f | 6e 20 63 6c 75 73 74 65 |rm_app.o|n cluste|
|00003440| 72 20 66 6f 72 6d 5f 74 | 61 62 6c 65 73 0a 2f 0a |r form_t|ables./.|
|00003450| 64 72 6f 70 20 69 6e 64 | 65 78 20 69 66 6f 72 6d |drop ind|ex iform|
|00003460| 5f 61 70 70 6e 61 6d 0a | 2f 0a 63 72 65 61 74 65 |_appnam.|/.create|
|00003470| 20 75 6e 69 71 75 65 20 | 69 6e 64 65 78 20 69 66 | unique |index if|
|00003480| 6f 72 6d 5f 61 70 70 6e | 61 6d 0a 6f 6e 20 66 6f |orm_appn|am.on fo|
|00003490| 72 6d 5f 61 70 70 28 61 | 70 70 6f 77 6e 65 72 2c |rm_app(a|ppowner,|
|000034a0| 61 70 70 6e 61 6d 65 29 | 0a 2f 0a 64 72 6f 70 20 |appname)|./.drop |
|000034b0| 69 6e 64 65 78 20 69 66 | 6f 72 6d 5f 62 6c 6b 0a |index if|orm_blk.|
|000034c0| 2f 0a 63 72 65 61 74 65 | 20 75 6e 69 71 75 65 20 |/.create| unique |
|000034d0| 69 6e 64 65 78 20 69 66 | 6f 72 6d 5f 62 6c 6b 0a |index if|orm_blk.|
|000034e0| 6f 6e 20 66 6f 72 6d 5f | 62 6c 6b 28 62 6c 6b 61 |on form_|blk(blka|
|000034f0| 70 6f 77 6e 65 72 2c 62 | 6c 6b 61 70 6e 61 6d 65 |powner,b|lkapname|
|00003500| 2c 62 6c 6b 6e 61 6d 65 | 29 0a 2f 0a 64 72 6f 70 |,blkname|)./.drop|
|00003510| 20 69 6e 64 65 78 20 69 | 66 6f 72 6d 5f 66 6c 64 | index i|form_fld|
|00003520| 0a 2f 0a 63 72 65 61 74 | 65 20 75 6e 69 71 75 65 |./.creat|e unique|
|00003530| 20 69 6e 64 65 78 20 69 | 66 6f 72 6d 5f 66 6c 64 | index i|form_fld|
|00003540| 0a 6f 6e 20 66 6f 72 6d | 5f 66 6c 64 28 66 6c 64 |.on form|_fld(fld|
|00003550| 61 70 6f 77 6e 65 72 2c | 66 6c 64 61 70 6e 61 6d |apowner,|fldapnam|
|00003560| 65 2c 66 6c 64 62 6c 6b | 2c 66 6c 64 6e 61 6d 65 |e,fldblk|,fldname|
|00003570| 29 0a 2f 0a 64 72 6f 70 | 20 69 6e 64 65 78 20 69 |)./.drop| index i|
|00003580| 66 6f 72 6d 5f 74 72 67 | 0a 2f 0a 63 72 65 61 74 |form_trg|./.creat|
|00003590| 65 20 75 6e 69 71 75 65 | 20 69 6e 64 65 78 20 69 |e unique| index i|
|000035a0| 66 6f 72 6d 5f 74 72 67 | 0a 6f 6e 20 66 6f 72 6d |form_trg|.on form|
|000035b0| 5f 74 72 67 28 74 72 67 | 61 70 6f 77 6e 65 72 2c |_trg(trg|apowner,|
|000035c0| 74 72 67 61 70 6e 61 6d | 65 2c 74 72 67 62 6c 6b |trgapnam|e,trgblk|
|000035d0| 2c 74 72 67 66 6c 64 2c | 74 72 67 74 79 70 65 2c |,trgfld,|trgtype,|
|000035e0| 74 72 67 73 65 71 29 0a | 2f 0a 64 72 6f 70 20 69 |trgseq).|/.drop i|
|000035f0| 6e 64 65 78 20 69 66 6f | 72 6d 5f 74 72 69 67 67 |ndex ifo|rm_trigg|
|00003600| 65 72 0a 2f 0a 63 72 65 | 61 74 65 20 75 6e 69 71 |er./.cre|ate uniq|
|00003610| 75 65 20 69 6e 64 65 78 | 20 69 66 6f 72 6d 5f 74 |ue index| iform_t|
|00003620| 72 69 67 67 65 72 0a 6f | 6e 20 66 6f 72 6d 5f 74 |rigger.o|n form_t|
|00003630| 72 69 67 67 65 72 28 74 | 72 69 67 61 70 6f 77 6e |rigger(t|rigapown|
|00003640| 65 72 2c 74 72 69 67 61 | 70 6e 61 6d 65 2c 74 72 |er,triga|pname,tr|
|00003650| 69 67 62 6c 6b 2c 74 72 | 69 67 66 6c 64 2c 74 72 |igblk,tr|igfld,tr|
|00003660| 69 67 74 79 70 65 29 0a | 2f 0a 64 72 6f 70 20 69 |igtype).|/.drop i|
|00003670| 6e 64 65 78 20 69 66 6f | 72 6d 5f 73 71 6c 74 78 |ndex ifo|rm_sqltx|
|00003680| 74 0a 2f 0a 63 72 65 61 | 74 65 20 75 6e 69 71 75 |t./.crea|te uniqu|
|00003690| 65 20 69 6e 64 65 78 20 | 69 66 6f 72 6d 5f 73 71 |e index |iform_sq|
|000036a0| 6c 74 78 74 0a 6f 6e 20 | 66 6f 72 6d 5f 73 71 6c |ltxt.on |form_sql|
|000036b0| 74 78 74 28 73 71 74 61 | 70 6f 77 6e 65 72 2c 73 |txt(sqta|powner,s|
|000036c0| 71 74 61 70 6e 61 6d 65 | 2c 73 71 74 6e 6f 2c 73 |qtapname|,sqtno,s|
|000036d0| 71 74 6c 69 6e 65 29 0a | 2f 0a 64 72 6f 70 20 69 |qtline).|/.drop i|
|000036e0| 6e 64 65 78 20 69 66 6f | 72 6d 5f 70 61 67 65 0a |ndex ifo|rm_page.|
|000036f0| 2f 0a 63 72 65 61 74 65 | 20 75 6e 69 71 75 65 20 |/.create| unique |
|00003700| 69 6e 64 65 78 20 69 66 | 6f 72 6d 5f 70 61 67 65 |index if|orm_page|
|00003710| 0a 6f 6e 20 66 6f 72 6d | 5f 70 61 67 65 28 70 61 |.on form|_page(pa|
|00003720| 67 61 70 6f 77 6e 65 72 | 2c 70 61 67 61 70 6e 61 |gapowner|,pagapna|
|00003730| 6d 65 2c 70 61 67 6e 75 | 6d 29 0a 2f 0a 64 72 6f |me,pagnu|m)./.dro|
|00003740| 70 20 69 6e 64 65 78 20 | 69 66 6f 72 6d 5f 6d 61 |p index |iform_ma|
|00003750| 70 0a 2f 0a 63 72 65 61 | 74 65 20 75 6e 69 71 75 |p./.crea|te uniqu|
|00003760| 65 20 69 6e 64 65 78 20 | 69 66 6f 72 6d 5f 6d 61 |e index |iform_ma|
|00003770| 70 0a 6f 6e 20 66 6f 72 | 6d 5f 6d 61 70 28 6d 61 |p.on for|m_map(ma|
|00003780| 70 61 70 6f 77 6e 65 72 | 2c 6d 61 70 61 70 6e 61 |papowner|,mapapna|
|00003790| 6d 65 2c 6d 61 70 70 61 | 67 65 2c 6d 61 70 6c 69 |me,mappa|ge,mapli|
|000037a0| 6e 65 2c 6d 61 70 67 72 | 70 68 29 0a 2f 0a 64 72 |ne,mapgr|ph)./.dr|
|000037b0| 6f 70 20 69 6e 64 65 78 | 20 69 66 6f 72 6d 5f 63 |op index| iform_c|
|000037c0| 6f 6d 6d 65 6e 74 0a 2f | 0a 63 72 65 61 74 65 20 |omment./|.create |
|000037d0| 75 6e 69 71 75 65 20 69 | 6e 64 65 78 20 69 66 6f |unique i|ndex ifo|
|000037e0| 72 6d 5f 63 6f 6d 6d 65 | 6e 74 0a 6f 6e 20 66 6f |rm_comme|nt.on fo|
|000037f0| 72 6d 5f 63 6f 6d 6d 65 | 6e 74 28 63 6d 74 61 70 |rm_comme|nt(cmtap|
|00003800| 6f 77 6e 65 72 2c 63 6d | 74 61 70 6e 61 6d 65 2c |owner,cm|tapname,|
|00003810| 63 6d 74 70 72 6f 63 2c | 63 6d 74 62 6c 6b 2c 63 |cmtproc,|cmtblk,c|
|00003820| 6d 74 66 6c 64 2c 63 6d | 74 74 72 67 74 79 70 2c |mtfld,cm|ttrgtyp,|
|00003830| 63 6d 74 74 72 67 73 65 | 71 2c 0a 63 6d 74 6c 69 |cmttrgse|q,.cmtli|
|00003840| 6e 65 29 0a 2f 0a 64 72 | 6f 70 20 69 6e 64 65 78 |ne)./.dr|op index|
|00003850| 20 69 66 6f 72 6d 5f 72 | 65 66 65 72 65 6e 63 65 | iform_r|eference|
|00003860| 0a 2f 0a 63 72 65 61 74 | 65 20 75 6e 69 71 75 65 |./.creat|e unique|
|00003870| 20 69 6e 64 65 78 20 69 | 66 6f 72 6d 5f 72 65 66 | index i|form_ref|
|00003880| 65 72 65 6e 63 65 0a 6f | 6e 20 66 6f 72 6d 5f 72 |erence.o|n form_r|
|00003890| 65 66 65 72 65 6e 63 65 | 28 72 65 66 61 70 6f 77 |eference|(refapow|
|000038a0| 6e 65 72 2c 72 65 66 61 | 70 6e 61 6d 65 2c 72 65 |ner,refa|pname,re|
|000038b0| 66 62 6c 6b 2c 72 65 66 | 66 6c 64 2c 72 65 66 74 |fblk,ref|fld,reft|
|000038c0| 72 67 74 79 70 2c 72 65 | 66 70 72 6f 63 29 0a 2f |rgtyp,re|fproc)./|
|000038d0| 0a 64 72 6f 70 20 69 6e | 64 65 78 20 69 66 6f 72 |.drop in|dex ifor|
|000038e0| 6d 5f 70 72 6f 63 65 64 | 75 72 65 0a 2f 0a 63 72 |m_proced|ure./.cr|
|000038f0| 65 61 74 65 20 75 6e 69 | 71 75 65 20 69 6e 64 65 |eate uni|que inde|
|00003900| 78 20 69 66 6f 72 6d 5f | 70 72 6f 63 65 64 75 72 |x iform_|procedur|
|00003910| 65 0a 6f 6e 20 66 6f 72 | 6d 5f 70 72 6f 63 65 64 |e.on for|m_proced|
|00003920| 75 72 65 28 70 72 6f 63 | 61 70 6f 77 6e 65 72 2c |ure(proc|apowner,|
|00003930| 70 72 6f 63 61 70 6e 61 | 6d 65 2c 70 72 6f 63 6e |procapna|me,procn|
|00003940| 61 6d 65 29 0a 2f 0a 0a | 73 70 6f 6f 6c 20 6f 66 |ame)./..|spool of|
|00003950| 66 0a 30 37 30 37 30 37 | 30 30 30 34 35 30 30 31 |f.070707|00045001|
|00003960| 31 33 33 35 31 30 30 34 | 34 34 30 30 30 33 31 31 |13351004|44000311|
|00003970| 30 30 30 30 36 32 30 30 | 30 30 30 31 30 30 30 30 |00006200|00010000|
|00003980| 30 30 30 34 37 36 34 35 | 37 35 37 31 33 30 30 30 |00047645|75713000|
|00003990| 30 32 33 30 30 30 30 30 | 30 31 33 35 34 32 61 64 |02300000|013542ad|
|000039a0| 6d 69 6e 2f 69 61 64 74 | 61 62 6c 65 2e 73 71 6c |min/iadt|able.sql|
|000039b0| 00 72 65 6d 0a 72 65 6d | 20 24 48 65 61 64 65 72 |.rem.rem| $Header|
|000039c0| 3a 20 69 61 64 74 61 62 | 6c 65 2e 73 71 6c 2c 76 |: iadtab|le.sql,v|
|000039d0| 20 33 30 30 31 34 30 30 | 2e 31 20 39 30 2f 30 32 | 3001400|.1 90/02|
|000039e0| 2f 32 37 20 31 34 3a 35 | 36 3a 35 37 20 72 63 73 |/27 14:5|6:57 rcs|
|000039f0| 20 45 78 70 20 24 20 69 | 61 64 74 61 62 6c 65 2e | Exp $ i|adtable.|
|00003a00| 73 71 6c 20 43 6f 70 79 | 72 20 28 63 29 20 31 39 |sql Copy|r (c) 19|
|00003a10| 38 39 20 4f 72 61 63 6c | 65 0a 72 65 6d 0a 72 65 |89 Oracl|e.rem.re|
|00003a20| 6d 20 53 51 4c 46 4f 52 | 4d 53 33 30 33 30 30 31 |m SQLFOR|MS303001|
|00003a30| 34 2c 44 55 41 35 30 3a | 5b 46 52 45 45 5a 45 5f |4,DUA50:|[FREEZE_|
|00003a40| 53 51 4c 46 4f 52 4d 53 | 33 30 2e 53 51 4c 2e 33 |SQLFORMS|30.SQL.3|
|00003a50| 30 30 31 34 5d 0a 52 65 | 6d 20 43 6f 70 79 72 69 |0014].Re|m Copyri|
|00003a60| 67 68 74 20 28 63 29 20 | 31 39 38 38 20 62 79 20 |ght (c) |1988 by |
|00003a70| 4f 72 61 63 6c 65 20 43 | 6f 72 70 6f 72 61 74 69 |Oracle C|orporati|
|00003a80| 6f 6e 0a 52 65 6d 20 4e | 41 4d 45 0a 52 65 6d 20 |on.Rem N|AME.Rem |
|00003a90| 20 20 20 49 41 44 54 41 | 42 4c 45 53 2e 53 51 4c | IADTA|BLES.SQL|
|00003aa0| 20 2d 20 43 72 65 61 74 | 65 20 53 51 4c 2a 46 6f | - Creat|e SQL*Fo|
|00003ab0| 72 6d 73 27 20 74 61 62 | 6c 65 73 2e 0a 52 65 6d |rms' tab|les..Rem|
|00003ac0| 20 20 46 55 4e 43 54 49 | 4f 4e 0a 52 65 6d 20 20 | FUNCTI|ON.Rem |
|00003ad0| 4e 4f 54 45 53 0a 52 65 | 6d 20 20 4d 4f 44 49 46 |NOTES.Re|m MODIF|
|00003ae0| 49 45 44 0a 52 65 6d 20 | 20 20 45 69 63 68 65 72 |IED.Rem | Eicher|
|00003af0| 20 20 20 20 20 30 32 2f | 30 35 2f 39 30 20 2d 20 | 02/|05/90 - |
|00003b00| 43 72 65 61 74 69 6f 6e | 0a 52 65 6d 20 20 20 45 |Creation|.Rem E|
|00003b10| 69 63 68 65 72 20 20 20 | 20 20 30 32 2f 30 35 2f |icher | 02/05/|
|00003b20| 39 30 20 2d 20 52 65 6e | 61 6d 65 20 66 72 6f 6d |90 - Ren|ame from|
|00003b30| 20 69 61 64 74 61 62 6c | 65 73 2e 73 71 6c 20 2d | iadtabl|es.sql -|
|00003b40| 20 72 65 6e 61 6d 65 20 | 73 70 6f 6f 6c 20 66 69 | rename |spool fi|
|00003b50| 6c 65 0a 52 65 6d 20 20 | 20 48 73 69 20 20 20 20 |le.Rem | Hsi |
|00003b60| 20 20 20 20 30 33 2f 32 | 37 2f 38 39 20 2d 20 41 | 03/2|7/89 - A|
|00003b70| 64 64 20 63 6f 6c 75 6d | 6e 73 20 74 6f 20 46 4f |dd colum|ns to FO|
|00003b80| 52 4d 5f 46 4c 44 20 66 | 6f 72 20 65 64 69 74 6f |RM_FLD f|or edito|
|00003b90| 72 20 61 74 74 72 69 62 | 75 74 65 73 20 28 56 33 |r attrib|utes (V3|
|00003ba0| 2e 30 2e 36 29 0a 52 65 | 6d 20 20 20 48 73 69 20 |.0.6).Re|m Hsi |
|00003bb0| 20 20 20 20 20 20 20 30 | 33 2f 30 36 2f 38 39 20 | 0|3/06/89 |
|00003bc0| 2d 20 43 6c 75 73 74 65 | 72 69 6e 67 20 53 51 4c |- Cluste|ring SQL|
|00003bd0| 2a 46 6f 72 6d 73 27 20 | 74 61 62 6c 65 73 20 28 |*Forms' |tables (|
|00003be0| 56 33 2e 30 2e 35 29 0a | 52 65 6d 20 20 20 48 73 |V3.0.5).|Rem Hs|
|00003bf0| 69 20 20 20 20 20 20 20 | 20 30 32 2f 32 31 2f 38 |i | 02/21/8|
|00003c00| 39 20 2d 20 41 64 64 20 | 63 6f 6c 75 6d 6e 73 20 |9 - Add |columns |
|00003c10| 74 6f 20 46 4f 52 4d 5f | 41 50 50 20 66 6f 72 20 |to FORM_|APP for |
|00003c20| 6d 65 6e 75 2f 6d 6f 75 | 73 65 20 73 75 70 70 6f |menu/mou|se suppo|
|00003c30| 72 74 20 28 56 33 2e 30 | 2e 35 29 0a 52 65 6d 20 |rt (V3.0|.5).Rem |
|00003c40| 20 20 48 73 69 20 20 20 | 20 20 20 20 20 30 32 2f | Hsi | 02/|
|00003c50| 31 35 2f 38 39 20 2d 20 | 41 64 64 20 63 6f 6c 75 |15/89 - |Add colu|
|00003c60| 6d 6e 20 54 52 49 47 50 | 4c 53 51 4c 20 74 6f 20 |mn TRIGP|LSQL to |
|00003c70| 74 61 62 6c 65 20 46 4f | 52 4d 5f 54 52 49 47 47 |table FO|RM_TRIGG|
|00003c80| 45 52 20 28 56 33 2e 30 | 2e 35 29 0a 52 65 6d 20 |ER (V3.0|.5).Rem |
|00003c90| 20 20 48 73 69 20 20 20 | 20 20 20 20 20 30 32 2f | Hsi | 02/|
|00003ca0| 31 35 2f 38 39 20 2d 20 | 43 68 61 6e 67 65 20 72 |15/89 - |Change r|
|00003cb0| 65 66 66 6f 77 6e 65 72 | 20 61 6e 64 20 72 65 66 |effowner| and ref|
|00003cc0| 66 61 70 70 20 74 6f 20 | 6e 6f 74 20 6e 75 6c 6c |fapp to |not null|
|00003cd0| 20 28 56 33 2e 30 2e 35 | 29 0a 52 65 6d 20 20 20 | (V3.0.5|).Rem |
|00003ce0| 46 69 6e 65 20 20 20 20 | 20 20 20 30 31 2f 32 35 |Fine | 01/25|
|00003cf0| 2f 38 39 20 2d 20 54 4f | 55 43 48 0a 52 65 6d 20 |/89 - TO|UCH.Rem |
|00003d00| 20 20 48 73 69 20 20 20 | 20 20 20 20 20 31 30 2f | Hsi | 10/|
|00003d10| 31 37 2f 38 38 20 2d 20 | 43 68 61 6e 67 65 20 6d |17/88 - |Change m|
|00003d20| 61 70 74 65 78 74 20 61 | 6e 64 20 70 61 67 74 69 |aptext a|nd pagti|
|00003d30| 74 6c 65 20 74 6f 20 63 | 68 61 72 28 32 35 35 29 |tle to c|har(255)|
|00003d40| 20 28 56 33 2e 30 2e 33 | 29 0a 52 65 6d 20 20 20 | (V3.0.3|).Rem |
|00003d50| 48 73 69 20 20 20 20 20 | 20 20 20 31 30 2f 31 31 |Hsi | 10/11|
|00003d60| 2f 38 38 20 2d 20 41 64 | 64 20 63 6f 6c 75 6d 6e |/88 - Ad|d column|
|00003d70| 20 42 4c 4b 43 4f 4c 53 | 45 43 20 74 6f 20 74 61 | BLKCOLS|EC to ta|
|00003d80| 62 6c 65 20 46 4f 52 4d | 5f 42 4c 4b 20 28 56 33 |ble FORM|_BLK (V3|
|00003d90| 2e 30 2e 33 29 0a 52 65 | 6d 20 20 20 48 73 69 20 |.0.3).Re|m Hsi |
|00003da0| 20 20 20 20 20 20 20 31 | 30 2f 31 31 2f 38 38 20 | 1|0/11/88 |
|00003db0| 2d 20 43 68 61 6e 67 65 | 20 63 6f 6c 75 6d 6e 20 |- Change| column |
|00003dc0| 46 4c 44 54 59 50 45 20 | 74 6f 20 63 68 61 72 28 |FLDTYPE |to char(|
|00003dd0| 38 29 20 28 56 33 2e 30 | 2e 33 29 0a 52 65 6d 20 |8) (V3.0|.3).Rem |
|00003de0| 20 20 48 73 69 20 20 20 | 20 20 20 20 20 30 38 2f | Hsi | 08/|
|00003df0| 33 31 2f 38 38 20 2d 20 | 43 68 61 6e 67 65 20 74 |31/88 - |Change t|
|00003e00| 61 62 6c 65 73 27 20 6e | 61 6d 65 20 28 46 4f 52 |ables' n|ame (FOR|
|00003e10| 4d 5f 78 78 78 29 20 28 | 56 33 2e 30 2e 31 29 0a |M_xxx) (|V3.0.1).|
|00003e20| 52 65 6d 20 20 20 48 73 | 69 20 20 20 20 20 20 20 |Rem Hs|i |
|00003e30| 20 30 38 2f 32 36 2f 38 | 38 20 2d 20 43 72 65 61 | 08/26/8|8 - Crea|
|00003e40| 74 69 6f 6e 20 28 56 33 | 2e 30 2e 31 29 0a 52 65 |tion (V3|.0.1).Re|
|00003e50| 6d 0a 52 65 6d 0a 0a 73 | 70 6f 6f 6c 20 69 61 64 |m.Rem..s|pool iad|
|00003e60| 74 61 62 6c 65 2e 6c 69 | 73 0a 0a 52 65 6d 0a 52 |table.li|s..Rem.R|
|00003e70| 65 6d 20 20 43 72 65 61 | 74 65 20 63 6c 75 73 74 |em Crea|te clust|
|00003e80| 65 72 0a 52 65 6d 20 0a | 63 72 65 61 74 65 20 63 |er.Rem .|create c|
|00003e90| 6c 75 73 74 65 72 20 66 | 6f 72 6d 5f 74 61 62 6c |luster f|orm_tabl|
|00003ea0| 65 73 0a 28 20 61 70 70 | 6f 77 6e 65 72 20 63 68 |es.( app|owner ch|
|00003eb0| 61 72 28 33 30 29 2c 0a | 20 20 61 70 70 6e 61 6d |ar(30),.| appnam|
|00003ec0| 65 20 20 63 68 61 72 28 | 33 30 29 20 29 0a 2f 0a |e char(|30) )./.|
|00003ed0| 0a 52 65 6d 0a 52 65 6d | 20 20 43 72 65 61 74 65 |.Rem.Rem| Create|
|00003ee0| 20 74 61 62 6c 65 73 0a | 52 65 6d 0a 63 72 65 61 | tables.|Rem.crea|
|00003ef0| 74 65 20 74 61 62 6c 65 | 20 66 6f 72 6d 5f 61 70 |te table| form_ap|
|00003f00| 70 0a 28 0a 20 20 20 61 | 70 70 6f 77 6e 65 72 09 |p.(. a|ppowner.|
|00003f10| 63 68 61 72 28 33 30 29 | 20 20 20 6e 6f 74 20 6e |char(30)| not n|
|00003f20| 75 6c 6c 2c 0a 20 20 20 | 61 70 70 6e 61 6d 65 09 |ull,. |appname.|
|00003f30| 63 68 61 72 28 33 30 29 | 20 20 20 6e 6f 74 20 6e |char(30)| not n|
|00003f40| 75 6c 6c 2c 0a 20 20 20 | 61 70 70 74 69 74 6c 65 |ull,. |apptitle|
|00003f50| 09 63 68 61 72 28 38 30 | 29 2c 0a 20 20 20 61 70 |.char(80|),. ap|
|00003f60| 70 76 61 75 6e 69 74 20 | 09 63 68 61 72 28 36 29 |pvaunit |.char(6)|
|00003f70| 2c 0a 20 20 20 61 70 70 | 6d 6f 75 73 65 20 09 63 |,. app|mouse .c|
|00003f80| 68 61 72 28 36 29 2c 0a | 20 20 20 61 70 70 6d 6e |har(6),.| appmn|
|00003f90| 75 61 70 6c 20 09 63 68 | 61 72 28 33 30 29 2c 0a |uapl .ch|ar(30),.|
|00003fa0| 20 20 20 61 70 70 6d 6e | 75 6e 61 6d 20 09 63 68 | appmn|unam .ch|
|00003fb0| 61 72 28 33 30 29 2c 0a | 20 20 20 61 70 70 6d 6e |ar(30),.| appmn|
|00003fc0| 75 67 72 70 20 09 63 68 | 61 72 28 33 30 29 0a 29 |ugrp .ch|ar(30).)|
|00003fd0| 0a 63 6c 75 73 74 65 72 | 20 66 6f 72 6d 5f 74 61 |.cluster| form_ta|
|00003fe0| 62 6c 65 73 20 28 20 61 | 70 70 6f 77 6e 65 72 2c |bles ( a|ppowner,|
|00003ff0| 20 61 70 70 6e 61 6d 65 | 20 29 0a 2f 0a 0a 63 72 | appname| )./..cr|
|00004000| 65 61 74 65 20 74 61 62 | 6c 65 20 66 6f 72 6d 5f |eate tab|le form_|
|00004010| 62 6c 6b 0a 28 0a 20 20 | 20 62 6c 6b 61 70 6f 77 |blk.(. | blkapow|
|00004020| 6e 65 72 20 63 68 61 72 | 28 33 30 29 09 20 20 20 |ner char|(30). |
|00004030| 6e 6f 74 20 6e 75 6c 6c | 2c 0a 20 20 20 62 6c 6b |not null|,. blk|
|00004040| 61 70 6e 61 6d 65 20 20 | 63 68 61 72 28 33 30 29 |apname |char(30)|
|00004050| 09 20 20 20 6e 6f 74 20 | 6e 75 6c 6c 2c 0a 20 20 |. not |null,. |
|00004060| 20 62 6c 6b 6e 61 6d 65 | 20 20 20 20 63 68 61 72 | blkname| char|
|00004070| 28 33 30 29 09 20 20 20 | 6e 6f 74 20 6e 75 6c 6c |(30). |not null|
|00004080| 2c 0a 20 20 20 62 6c 6b | 64 65 73 63 20 20 20 20 |,. blk|desc |
|00004090| 63 68 61 72 28 36 30 29 | 2c 0a 20 20 20 62 6c 6b |char(60)|,. blk|
|000040a0| 68 69 64 65 20 20 20 20 | 63 68 61 72 28 31 29 2c |hide |char(1),|
|000040b0| 0a 20 20 20 62 6c 6b 73 | 65 71 20 20 20 20 20 6e |. blks|eq n|
|000040c0| 75 6d 62 65 72 2c 0a 20 | 20 20 62 6c 6b 75 6e 71 |umber,. | blkunq|
|000040d0| 6b 65 79 20 20 63 68 61 | 72 28 31 29 2c 0a 20 20 |key cha|r(1),. |
|000040e0| 20 62 6c 6b 63 74 72 6c | 20 20 20 20 63 68 61 72 | blkctrl| char|
|000040f0| 28 31 29 2c 0a 20 20 20 | 62 6c 6b 63 6f 6c 73 65 |(1),. |blkcolse|
|00004100| 63 20 20 63 68 61 72 28 | 31 29 2c 0a 20 20 20 62 |c char(|1),. b|
|00004110| 6c 6b 74 6f 77 6e 65 72 | 20 20 63 68 61 72 28 33 |lktowner| char(3|
|00004120| 30 29 2c 0a 20 20 20 62 | 6c 6b 74 6e 61 6d 65 20 |0),. b|lktname |
|00004130| 20 20 63 68 61 72 28 33 | 30 29 2c 0a 20 20 20 62 | char(3|0),. b|
|00004140| 6c 6b 6e 6f 72 65 63 20 | 20 20 6e 75 6d 62 65 72 |lknorec | number|
|00004150| 2c 0a 20 20 20 62 6c 6b | 6e 6f 62 75 66 20 20 20 |,. blk|nobuf |
|00004160| 6e 75 6d 62 65 72 2c 0a | 20 20 20 62 6c 6b 62 6c |number,.| blkbl|
|00004170| 69 6e 20 20 20 20 6e 75 | 6d 62 65 72 2c 0a 20 20 |in nu|mber,. |
|00004180| 20 62 6c 6b 6c 6e 72 63 | 20 20 20 20 6e 75 6d 62 | blklnrc| numb|
|00004190| 65 72 2c 0a 20 20 20 62 | 6c 6b 61 72 73 69 7a 20 |er,. b|lkarsiz |
|000041a0| 20 20 6e 75 6d 62 65 72 | 2c 0a 20 20 20 62 6c 6b | number|,. blk|
|000041b0| 6f 62 79 73 71 6c 20 20 | 6e 75 6d 62 65 72 0a 29 |obysql |number.)|
|000041c0| 0a 63 6c 75 73 74 65 72 | 20 66 6f 72 6d 5f 74 61 |.cluster| form_ta|
|000041d0| 62 6c 65 73 20 28 20 62 | 6c 6b 61 70 6f 77 6e 65 |bles ( b|lkapowne|
|000041e0| 72 2c 20 62 6c 6b 61 70 | 6e 61 6d 65 20 29 0a 2f |r, blkap|name )./|
|000041f0| 0a 0a 63 72 65 61 74 65 | 20 74 61 62 6c 65 20 66 |..create| table f|
|00004200| 6f 72 6d 5f 66 6c 64 0a | 28 0a 20 20 20 66 6c 64 |orm_fld.|(. fld|
|00004210| 61 70 6f 77 6e 65 72 20 | 63 68 61 72 28 33 30 29 |apowner |char(30)|
|00004220| 09 20 20 20 6e 6f 74 20 | 6e 75 6c 6c 2c 0a 20 20 |. not |null,. |
|00004230| 20 66 6c 64 61 70 6e 61 | 6d 65 20 20 63 68 61 72 | fldapna|me char|
|00004240| 28 33 30 29 09 20 20 20 | 6e 6f 74 20 6e 75 6c 6c |(30). |not null|
|00004250| 2c 0a 20 20 20 66 6c 64 | 62 6c 6b 20 20 20 20 20 |,. fld|blk |
|00004260| 63 68 61 72 28 33 30 29 | 09 20 20 20 6e 6f 74 20 |char(30)|. not |
|00004270| 6e 75 6c 6c 2c 0a 20 20 | 20 66 6c 64 6e 61 6d 65 |null,. | fldname|
|00004280| 20 20 20 20 63 68 61 72 | 28 33 30 29 09 20 20 20 | char|(30). |
|00004290| 6e 6f 74 20 6e 75 6c 6c | 2c 0a 20 20 20 66 6c 64 |not null|,. fld|
|000042a0| 73 65 71 20 20 20 20 20 | 6e 75 6d 62 65 72 2c 0a |seq |number,.|
|000042b0| 20 20 20 66 6c 64 74 79 | 70 65 20 20 20 20 63 68 | fldty|pe ch|
|000042c0| 61 72 28 38 29 2c 0a 20 | 20 20 66 6c 64 6c 65 6e |ar(8),. | fldlen|
|000042d0| 20 20 20 20 20 6e 75 6d | 62 65 72 2c 0a 20 20 20 | num|ber,. |
|000042e0| 66 6c 64 64 6c 65 6e 20 | 20 20 20 6e 75 6d 62 65 |flddlen | numbe|
|000042f0| 72 2c 0a 20 20 20 66 6c | 64 71 6c 65 6e 20 20 20 |r,. fl|dqlen |
|00004300| 20 6e 75 6d 62 65 72 2c | 0a 20 20 20 66 6c 64 62 | number,|. fldb|
|00004310| 74 61 62 20 20 20 20 63 | 68 61 72 28 31 29 2c 0a |tab c|har(1),.|
|00004320| 20 20 20 66 6c 64 6b 65 | 79 20 20 20 20 20 63 68 | fldke|y ch|
|00004330| 61 72 28 31 29 2c 0a 20 | 20 20 66 6c 64 63 6b 62 |ar(1),. | fldckb|
|00004340| 6c 6b 20 20 20 63 68 61 | 72 28 33 30 29 2c 0a 20 |lk cha|r(30),. |
|00004350| 20 20 66 6c 64 63 6b 66 | 6c 64 20 20 20 63 68 61 | fldckf|ld cha|
|00004360| 72 28 33 30 29 2c 0a 20 | 20 20 66 6c 64 64 66 6c |r(30),. | flddfl|
|00004370| 74 20 20 20 20 63 68 61 | 72 28 38 30 29 2c 0a 20 |t cha|r(80),. |
|00004380| 20 20 66 6c 64 64 69 73 | 70 20 20 20 20 63 68 61 | flddis|p cha|
|00004390| 72 28 31 29 2c 0a 20 20 | 20 66 6c 64 70 61 67 65 |r(1),. | fldpage|
|000043a0| 20 20 20 20 6e 75 6d 62 | 65 72 2c 0a 20 20 20 66 | numb|er,. f|
|000043b0| 6c 64 6c 69 6e 65 20 20 | 20 20 6e 75 6d 62 65 72 |ldline | number|
|000043c0| 2c 0a 20 20 20 66 6c 64 | 63 6f 6c 20 20 20 20 20 |,. fld|col |
|000043d0| 6e 75 6d 62 65 72 2c 0a | 20 20 20 66 6c 64 70 72 |number,.| fldpr|
|000043e0| 6f 6d 70 74 20 20 63 68 | 61 72 28 38 30 29 2c 0a |ompt ch|ar(80),.|
|000043f0| 20 20 20 66 6c 64 70 72 | 61 62 6f 76 20 20 63 68 | fldpr|abov ch|
|00004400| 61 72 28 31 29 2c 0a 20 | 20 20 66 6c 64 70 72 72 |ar(1),. | fldprr|
|00004410| 70 74 20 20 20 63 68 61 | 72 28 31 29 2c 0a 20 20 |pt cha|r(1),. |
|00004420| 20 66 6c 64 65 6e 74 65 | 72 20 20 20 63 68 61 72 | fldente|r char|
|00004430| 28 31 29 2c 0a 20 20 20 | 66 6c 64 71 75 65 72 79 |(1),. |fldquery|
|00004440| 20 20 20 63 68 61 72 28 | 31 29 2c 0a 20 20 20 66 | char(|1),. f|
|00004450| 6c 64 75 70 64 61 74 65 | 20 20 63 68 61 72 28 31 |ldupdate| char(1|
|00004460| 29 2c 0a 20 20 20 66 6c | 64 75 70 64 6e 75 6c 20 |),. fl|dupdnul |
|00004470| 20 63 68 61 72 28 31 29 | 2c 0a 20 20 20 66 6c 64 | char(1)|,. fld|
|00004480| 6d 61 6e 64 20 20 20 20 | 63 68 61 72 28 31 29 2c |mand |char(1),|
|00004490| 0a 20 20 20 66 6c 64 66 | 69 78 65 64 20 20 20 63 |. fldf|ixed c|
|000044a0| 68 61 72 28 31 29 2c 0a | 20 20 20 66 6c 64 73 6b |har(1),.| fldsk|
|000044b0| 69 70 20 20 20 20 63 68 | 61 72 28 31 29 2c 0a 20 |ip ch|ar(1),. |
|000044c0| 20 20 66 6c 64 68 69 64 | 65 20 20 20 20 63 68 61 | fldhid|e cha|
|000044d0| 72 28 31 29 2c 0a 20 20 | 20 66 6c 64 61 75 74 6f |r(1),. | fldauto|
|000044e0| 68 6c 70 20 63 68 61 72 | 28 31 29 2c 0a 20 20 20 |hlp char|(1),. |
|000044f0| 66 6c 64 75 70 70 65 72 | 20 20 20 63 68 61 72 28 |fldupper| char(|
|00004500| 31 29 2c 0a 20 20 20 66 | 6c 64 6c 6f 76 74 69 74 |1),. f|ldlovtit|
|00004510| 20 20 63 68 61 72 28 36 | 30 29 2c 0a 20 20 20 66 | char(6|0),. f|
|00004520| 6c 64 6c 6f 76 73 71 6c | 20 20 6e 75 6d 62 65 72 |ldlovsql| number|
|00004530| 2c 0a 20 20 20 66 6c 64 | 6c 6f 76 78 20 20 20 20 |,. fld|lovx |
|00004540| 6e 75 6d 62 65 72 2c 0a | 20 20 20 66 6c 64 6c 6f |number,.| fldlo|
|00004550| 76 79 20 20 20 20 6e 75 | 6d 62 65 72 2c 0a 20 20 |vy nu|mber,. |
|00004560| 20 66 6c 64 6c 6f 77 20 | 20 20 20 20 63 68 61 72 | fldlow | char|
|00004570| 28 33 30 29 2c 0a 20 20 | 20 66 6c 64 68 69 20 20 |(30),. | fldhi |
|00004580| 20 20 20 20 63 68 61 72 | 28 33 30 29 2c 0a 20 20 | char|(30),. |
|00004590| 20 66 6c 64 76 61 6c 70 | 61 74 6e 20 63 68 61 72 | fldvalp|atn char|
|000045a0| 28 38 30 29 2c 0a 20 20 | 20 66 6c 64 64 69 73 6d |(80),. | flddism|
|000045b0| 61 73 6b 20 63 68 61 72 | 28 38 30 29 2c 0a 20 20 |ask char|(80),. |
|000045c0| 20 66 6c 64 68 65 6c 70 | 20 20 20 20 63 68 61 72 | fldhelp| char|
|000045d0| 28 38 30 29 2c 0a 20 20 | 20 66 6c 64 65 64 74 78 |(80),. | fldedtx|
|000045e0| 20 20 20 20 6e 75 6d 62 | 65 72 2c 0a 20 20 20 66 | numb|er,. f|
|000045f0| 6c 64 65 64 74 79 20 20 | 20 20 6e 75 6d 62 65 72 |ldedty | number|
|00004600| 2c 0a 20 20 20 66 6c 64 | 65 64 74 77 72 70 20 20 |,. fld|edtwrp |
|00004610| 63 68 61 72 28 31 29 2c | 0a 20 20 20 66 6c 64 65 |char(1),|. flde|
|00004620| 64 74 74 69 74 20 20 63 | 68 61 72 28 32 35 35 29 |dttit c|har(255)|
|00004630| 2c 0a 20 20 20 66 6c 64 | 65 64 74 62 74 69 74 20 |,. fld|edtbtit |
|00004640| 63 68 61 72 28 32 35 35 | 29 0a 29 0a 63 6c 75 73 |char(255|).).clus|
|00004650| 74 65 72 20 66 6f 72 6d | 5f 74 61 62 6c 65 73 20 |ter form|_tables |
|00004660| 28 20 66 6c 64 61 70 6f | 77 6e 65 72 2c 20 66 6c |( fldapo|wner, fl|
|00004670| 64 61 70 6e 61 6d 65 20 | 29 0a 2f 0a 0a 63 72 65 |dapname |)./..cre|
|00004680| 61 74 65 20 74 61 62 6c | 65 20 66 6f 72 6d 5f 74 |ate tabl|e form_t|
|00004690| 72 69 67 67 65 72 0a 28 | 0a 20 20 20 74 72 69 67 |rigger.(|. trig|
|000046a0| 61 70 6f 77 6e 65 72 20 | 63 68 61 72 28 33 30 29 |apowner |char(30)|
|000046b0| 09 20 20 20 6e 6f 74 20 | 6e 75 6c 6c 2c 0a 20 20 |. not |null,. |
|000046c0| 20 74 72 69 67 61 70 6e | 61 6d 65 20 20 63 68 61 | trigapn|ame cha|
|000046d0| 72 28 33 30 29 09 20 20 | 20 6e 6f 74 20 6e 75 6c |r(30). | not nul|
|000046e0| 6c 2c 0a 20 20 20 74 72 | 69 67 62 6c 6b 20 20 20 |l,. tr|igblk |
|000046f0| 20 20 63 68 61 72 28 33 | 30 29 2c 0a 20 20 20 74 | char(3|0),. t|
|00004700| 72 69 67 66 6c 64 20 20 | 20 20 20 63 68 61 72 28 |rigfld | char(|
|00004710| 33 30 29 2c 0a 20 20 20 | 74 72 69 67 74 79 70 65 |30),. |trigtype|
|00004720| 20 20 20 20 63 68 61 72 | 28 33 30 29 20 20 20 20 | char|(30) |
|00004730| 6e 6f 74 20 6e 75 6c 6c | 2c 0a 20 20 20 74 72 69 |not null|,. tri|
|00004740| 67 64 65 73 63 20 20 20 | 20 63 68 61 72 28 32 30 |gdesc | char(20|
|00004750| 29 2c 0a 20 20 20 74 72 | 69 67 68 69 64 65 20 20 |),. tr|ighide |
|00004760| 20 20 63 68 61 72 28 31 | 29 2c 0a 20 20 20 74 72 | char(1|),. tr|
|00004770| 69 67 70 6c 73 71 6c 20 | 20 20 63 68 61 72 28 31 |igplsql | char(1|
|00004780| 29 0a 29 0a 63 6c 75 73 | 74 65 72 20 66 6f 72 6d |).).clus|ter form|
|00004790| 5f 74 61 62 6c 65 73 20 | 28 20 74 72 69 67 61 70 |_tables |( trigap|
|000047a0| 6f 77 6e 65 72 2c 20 74 | 72 69 67 61 70 6e 61 6d |owner, t|rigapnam|
|000047b0| 65 20 29 0a 2f 0a 0a 63 | 72 65 61 74 65 20 74 61 |e )./..c|reate ta|
|000047c0| 62 6c 65 20 66 6f 72 6d | 5f 74 72 67 0a 28 0a 20 |ble form|_trg.(. |
|000047d0| 20 20 74 72 67 61 70 6f | 77 6e 65 72 20 63 68 61 | trgapo|wner cha|
|000047e0| 72 28 33 30 29 09 20 20 | 20 6e 6f 74 20 6e 75 6c |r(30). | not nul|
|000047f0| 6c 2c 0a 20 20 20 74 72 | 67 61 70 6e 61 6d 65 20 |l,. tr|gapname |
|00004800| 20 63 68 61 72 28 33 30 | 29 09 20 20 20 6e 6f 74 | char(30|). not|
|00004810| 20 6e 75 6c 6c 2c 0a 20 | 20 20 74 72 67 62 6c 6b | null,. | trgblk|
|00004820| 20 20 20 20 20 63 68 61 | 72 28 33 30 29 2c 0a 20 | cha|r(30),. |
|00004830| 20 20 74 72 67 66 6c 64 | 20 20 20 20 20 63 68 61 | trgfld| cha|
|00004840| 72 28 33 30 29 2c 0a 20 | 20 20 74 72 67 74 79 70 |r(30),. | trgtyp|
|00004850| 65 20 20 20 20 63 68 61 | 72 28 33 30 29 09 20 20 |e cha|r(30). |
|00004860| 20 6e 6f 74 20 6e 75 6c | 6c 2c 0a 20 20 20 74 72 | not nul|l,. tr|
|00004870| 67 73 65 71 20 20 20 20 | 20 6e 75 6d 62 65 72 2c |gseq | number,|
|00004880| 0a 20 20 20 74 72 67 6c | 61 62 65 6c 20 20 20 63 |. trgl|abel c|
|00004890| 68 61 72 28 33 30 29 2c | 0a 20 20 20 74 72 67 73 |har(30),|. trgs|
|000048a0| 71 6c 20 20 20 20 20 6e | 75 6d 62 65 72 2c 0a 20 |ql n|umber,. |
|000048b0| 20 20 74 72 67 63 75 72 | 73 20 20 20 20 63 68 61 | trgcur|s cha|
|000048c0| 72 28 31 29 2c 0a 20 20 | 20 74 72 67 6d 76 65 20 |r(1),. | trgmve |
|000048d0| 20 20 20 20 63 68 61 72 | 28 31 29 2c 0a 20 20 20 | char|(1),. |
|000048e0| 74 72 67 69 6e 76 20 20 | 20 20 20 63 68 61 72 28 |trginv | char(|
|000048f0| 31 29 2c 0a 20 20 20 74 | 72 67 72 6f 6c 6c 20 20 |1),. t|rgroll |
|00004900| 20 20 63 68 61 72 28 31 | 29 2c 0a 20 20 20 74 72 | char(1|),. tr|
|00004910| 67 73 6c 61 62 20 20 20 | 20 63 68 61 72 28 33 30 |gslab | char(30|
|00004920| 29 2c 0a 20 20 20 74 72 | 67 66 6c 61 62 20 20 20 |),. tr|gflab |
|00004930| 20 63 68 61 72 28 33 30 | 29 2c 0a 20 20 20 74 72 | char(30|),. tr|
|00004940| 67 6d 73 67 20 20 20 20 | 20 63 68 61 72 28 38 30 |gmsg | char(80|
|00004950| 29 0a 29 0a 63 6c 75 73 | 74 65 72 20 66 6f 72 6d |).).clus|ter form|
|00004960| 5f 74 61 62 6c 65 73 20 | 28 20 74 72 67 61 70 6f |_tables |( trgapo|
|00004970| 77 6e 65 72 2c 20 74 72 | 67 61 70 6e 61 6d 65 20 |wner, tr|gapname |
|00004980| 29 0a 2f 0a 0a 63 72 65 | 61 74 65 20 74 61 62 6c |)./..cre|ate tabl|
|00004990| 65 20 66 6f 72 6d 5f 73 | 71 6c 74 78 74 0a 28 0a |e form_s|qltxt.(.|
|000049a0| 20 20 20 73 71 74 61 70 | 6f 77 6e 65 72 20 63 68 | sqtap|owner ch|
|000049b0| 61 72 28 33 30 29 09 20 | 20 20 6e 6f 74 20 6e 75 |ar(30). | not nu|
|000049c0| 6c 6c 2c 0a 20 20 20 73 | 71 74 61 70 6e 61 6d 65 |ll,. s|qtapname|
|000049d0| 20 20 63 68 61 72 28 33 | 30 29 09 20 20 20 6e 6f | char(3|0). no|
|000049e0| 74 20 6e 75 6c 6c 2c 0a | 20 20 20 73 71 74 6e 6f |t null,.| sqtno|
|000049f0| 20 20 20 20 20 20 6e 75 | 6d 62 65 72 09 20 20 20 | nu|mber. |
|00004a00| 6e 6f 74 20 6e 75 6c 6c | 2c 0a 20 20 20 73 71 74 |not null|,. sqt|
|00004a10| 6c 69 6e 65 20 20 20 20 | 6e 75 6d 62 65 72 2c 0a |line |number,.|
|00004a20| 20 20 20 73 71 74 74 65 | 78 74 20 20 20 20 63 68 | sqtte|xt ch|
|00004a30| 61 72 28 38 30 29 0a 29 | 0a 63 6c 75 73 74 65 72 |ar(80).)|.cluster|
|00004a40| 20 66 6f 72 6d 5f 74 61 | 62 6c 65 73 20 28 20 73 | form_ta|bles ( s|
|00004a50| 71 74 61 70 6f 77 6e 65 | 72 2c 20 73 71 74 61 70 |qtapowne|r, sqtap|
|00004a60| 6e 61 6d 65 20 29 0a 2f | 0a 0a 63 72 65 61 74 65 |name )./|..create|
|00004a70| 20 74 61 62 6c 65 20 66 | 6f 72 6d 5f 70 61 67 65 | table f|orm_page|
|00004a80| 0a 28 0a 20 20 20 70 61 | 67 61 70 6f 77 6e 65 72 |.(. pa|gapowner|
|00004a90| 20 63 68 61 72 28 33 30 | 29 09 20 20 20 6e 6f 74 | char(30|). not|
|00004aa0| 20 6e 75 6c 6c 2c 0a 20 | 20 20 70 61 67 61 70 6e | null,. | pagapn|
|00004ab0| 61 6d 65 20 20 63 68 61 | 72 28 33 30 29 09 20 20 |ame cha|r(30). |
|00004ac0| 20 6e 6f 74 20 6e 75 6c | 6c 2c 0a 20 20 20 70 61 | not nul|l,. pa|
|00004ad0| 67 6e 75 6d 20 20 20 20 | 20 6e 75 6d 62 65 72 09 |gnum | number.|
|00004ae0| 20 20 20 6e 6f 74 20 6e | 75 6c 6c 2c 0a 20 20 20 | not n|ull,. |
|00004af0| 70 61 67 74 69 74 6c 65 | 20 20 20 63 68 61 72 28 |pagtitle| char(|
|00004b00| 32 35 35 29 2c 0a 20 20 | 20 70 61 67 78 73 69 7a |255),. | pagxsiz|
|00004b10| 20 20 20 20 6e 75 6d 62 | 65 72 2c 0a 20 20 20 70 | numb|er,. p|
|00004b20| 61 67 79 73 69 7a 20 20 | 20 20 6e 75 6d 62 65 72 |agysiz | number|
|00004b30| 2c 0a 20 20 20 70 61 67 | 76 77 78 73 20 20 20 20 |,. pag|vwxs |
|00004b40| 6e 75 6d 62 65 72 2c 0a | 20 20 20 70 61 67 76 77 |number,.| pagvw|
|00004b50| 79 73 20 20 20 20 6e 75 | 6d 62 65 72 2c 0a 20 20 |ys nu|mber,. |
|00004b60| 20 70 61 67 76 77 70 78 | 30 20 20 20 6e 75 6d 62 | pagvwpx|0 numb|
|00004b70| 65 72 2c 0a 20 20 20 70 | 61 67 76 77 70 79 30 20 |er,. p|agvwpy0 |
|00004b80| 20 20 6e 75 6d 62 65 72 | 2c 0a 20 20 20 70 61 67 | number|,. pag|
|00004b90| 76 77 73 78 30 20 20 20 | 6e 75 6d 62 65 72 2c 0a |vwsx0 |number,.|
|00004ba0| 20 20 20 70 61 67 76 77 | 73 79 30 20 20 20 6e 75 | pagvw|sy0 nu|
|00004bb0| 6d 62 65 72 2c 0a 20 20 | 20 70 61 67 70 6f 70 75 |mber,. | pagpopu|
|00004bc0| 70 20 20 20 63 68 61 72 | 28 31 29 2c 0a 20 20 20 |p char|(1),. |
|00004bd0| 70 61 67 62 6f 72 64 65 | 72 20 20 63 68 61 72 28 |pagborde|r char(|
|00004be0| 31 29 2c 0a 20 20 20 70 | 61 67 64 69 73 6c 76 20 |1),. p|agdislv |
|00004bf0| 20 20 63 68 61 72 28 31 | 29 2c 0a 20 20 20 70 61 | char(1|),. pa|
|00004c00| 67 68 73 63 72 6c 20 20 | 20 63 68 61 72 28 31 29 |ghscrl | char(1)|
|00004c10| 2c 0a 20 20 20 70 61 67 | 76 73 63 72 6c 20 20 20 |,. pag|vscrl |
|00004c20| 63 68 61 72 28 31 29 0a | 29 0a 63 6c 75 73 74 65 |char(1).|).cluste|
|00004c30| 72 20 66 6f 72 6d 5f 74 | 61 62 6c 65 73 20 28 20 |r form_t|ables ( |
|00004c40| 70 61 67 61 70 6f 77 6e | 65 72 2c 20 70 61 67 61 |pagapown|er, paga|
|00004c50| 70 6e 61 6d 65 20 29 0a | 2f 0a 0a 63 72 65 61 74 |pname ).|/..creat|
|00004c60| 65 20 74 61 62 6c 65 20 | 66 6f 72 6d 5f 6d 61 70 |e table |form_map|
|00004c70| 0a 28 0a 20 20 20 6d 61 | 70 61 70 6f 77 6e 65 72 |.(. ma|papowner|
|00004c80| 20 63 68 61 72 28 33 30 | 29 09 20 20 20 6e 6f 74 | char(30|). not|
|00004c90| 20 6e 75 6c 6c 2c 0a 20 | 20 20 6d 61 70 61 70 6e | null,. | mapapn|
|00004ca0| 61 6d 65 20 20 63 68 61 | 72 28 33 30 29 09 20 20 |ame cha|r(30). |
|00004cb0| 20 6e 6f 74 20 6e 75 6c | 6c 2c 0a 20 20 20 6d 61 | not nul|l,. ma|
|00004cc0| 70 70 61 67 65 20 20 20 | 20 6e 75 6d 62 65 72 09 |ppage | number.|
|00004cd0| 20 20 20 6e 6f 74 20 6e | 75 6c 6c 2c 0a 20 20 20 | not n|ull,. |
|00004ce0| 6d 61 70 6c 69 6e 65 20 | 20 20 20 6e 75 6d 62 65 |mapline | numbe|
|00004cf0| 72 2c 0a 20 20 20 6d 61 | 70 67 72 70 68 20 20 20 |r,. ma|pgrph |
|00004d00| 20 63 68 61 72 28 31 29 | 2c 0a 20 20 20 6d 61 70 | char(1)|,. map|
|00004d10| 74 65 78 74 20 20 20 20 | 63 68 61 72 28 32 35 35 |text |char(255|
|00004d20| 29 0a 29 0a 63 6c 75 73 | 74 65 72 20 66 6f 72 6d |).).clus|ter form|
|00004d30| 5f 74 61 62 6c 65 73 20 | 28 20 6d 61 70 61 70 6f |_tables |( mapapo|
|00004d40| 77 6e 65 72 2c 20 6d 61 | 70 61 70 6e 61 6d 65 20 |wner, ma|papname |
|00004d50| 29 0a 2f 0a 0a 63 72 65 | 61 74 65 20 74 61 62 6c |)./..cre|ate tabl|
|00004d60| 65 20 66 6f 72 6d 5f 63 | 6f 6d 6d 65 6e 74 0a 28 |e form_c|omment.(|
|00004d70| 0a 20 20 20 63 6d 74 61 | 70 6f 77 6e 65 72 20 63 |. cmta|powner c|
|00004d80| 68 61 72 28 33 30 29 09 | 20 20 20 6e 6f 74 20 6e |har(30).| not n|
|00004d90| 75 6c 6c 2c 0a 20 20 20 | 63 6d 74 61 70 6e 61 6d |ull,. |cmtapnam|
|00004da0| 65 20 20 63 68 61 72 28 | 33 30 29 09 20 20 20 6e |e char(|30). n|
|00004db0| 6f 74 20 6e 75 6c 6c 2c | 0a 20 20 20 63 6d 74 70 |ot null,|. cmtp|
|00004dc0| 72 6f 63 20 20 20 20 63 | 68 61 72 28 33 30 29 2c |roc c|har(30),|
|00004dd0| 0a 20 20 20 63 6d 74 62 | 6c 6b 20 20 20 20 20 63 |. cmtb|lk c|
|00004de0| 68 61 72 28 33 30 29 2c | 0a 20 20 20 63 6d 74 66 |har(30),|. cmtf|
|00004df0| 6c 64 20 20 20 20 20 63 | 68 61 72 28 33 30 29 2c |ld c|har(30),|
|00004e00| 0a 20 20 20 63 6d 74 74 | 72 67 74 79 70 20 20 63 |. cmtt|rgtyp c|
|00004e10| 68 61 72 28 33 30 29 2c | 0a 20 20 20 63 6d 74 74 |har(30),|. cmtt|
|00004e20| 72 67 73 65 71 20 20 6e | 75 6d 62 65 72 2c 0a 20 |rgseq n|umber,. |
|00004e30| 20 20 63 6d 74 6c 69 6e | 65 20 20 20 20 6e 75 6d | cmtlin|e num|
|00004e40| 62 65 72 2c 0a 20 20 20 | 63 6d 74 74 65 78 74 20 |ber,. |cmttext |
|00004e50| 20 20 20 63 68 61 72 28 | 38 30 29 0a 29 0a 63 6c | char(|80).).cl|
|00004e60| 75 73 74 65 72 20 66 6f | 72 6d 5f 74 61 62 6c 65 |uster fo|rm_table|
|00004e70| 73 20 28 20 63 6d 74 61 | 70 6f 77 6e 65 72 2c 20 |s ( cmta|powner, |
|00004e80| 63 6d 74 61 70 6e 61 6d | 65 20 29 0a 2f 0a 0a 63 |cmtapnam|e )./..c|
|00004e90| 72 65 61 74 65 20 74 61 | 62 6c 65 20 66 6f 72 6d |reate ta|ble form|
|00004ea0| 5f 72 65 66 65 72 65 6e | 63 65 0a 28 0a 20 20 20 |_referen|ce.(. |
|00004eb0| 72 65 66 61 70 6f 77 6e | 65 72 20 63 68 61 72 28 |refapown|er char(|
|00004ec0| 33 30 29 09 20 20 20 6e | 6f 74 20 6e 75 6c 6c 2c |30). n|ot null,|
|00004ed0| 0a 20 20 20 72 65 66 61 | 70 6e 61 6d 65 20 20 63 |. refa|pname c|
|00004ee0| 68 61 72 28 33 30 29 09 | 20 20 20 6e 6f 74 20 6e |har(30).| not n|
|00004ef0| 75 6c 6c 2c 0a 20 20 20 | 72 65 66 62 6c 6b 20 20 |ull,. |refblk |
|00004f00| 20 20 20 63 68 61 72 28 | 33 30 29 2c 0a 20 20 20 | char(|30),. |
|00004f10| 72 65 66 66 6c 64 20 20 | 20 20 20 63 68 61 72 28 |reffld | char(|
|00004f20| 33 30 29 2c 0a 20 20 20 | 72 65 66 74 72 67 74 79 |30),. |reftrgty|
|00004f30| 70 20 20 63 68 61 72 28 | 33 30 29 2c 0a 20 20 20 |p char(|30),. |
|00004f40| 72 65 66 70 72 6f 63 20 | 20 20 20 63 68 61 72 28 |refproc | char(|
|00004f50| 33 30 29 2c 0a 20 20 20 | 72 65 66 66 6f 77 6e 65 |30),. |reffowne|
|00004f60| 72 20 20 63 68 61 72 28 | 33 30 29 09 20 20 20 6e |r char(|30). n|
|00004f70| 6f 74 20 6e 75 6c 6c 2c | 0a 20 20 20 72 65 66 66 |ot null,|. reff|
|00004f80| 61 70 70 20 20 20 20 63 | 68 61 72 28 33 30 29 09 |app c|har(30).|
|00004f90| 20 20 20 6e 6f 74 20 6e | 75 6c 6c 2c 20 0a 20 20 | not n|ull, . |
|00004fa0| 20 72 65 66 66 62 6c 6b | 20 20 20 20 63 68 61 72 | reffblk| char|
|00004fb0| 28 33 30 29 2c 0a 20 20 | 20 72 65 66 66 66 6c 64 |(30),. | refffld|
|00004fc0| 20 20 20 20 63 68 61 72 | 28 33 30 29 2c 0a 20 20 | char|(30),. |
|00004fd0| 20 72 65 66 66 74 72 67 | 74 79 70 20 63 68 61 72 | refftrg|typ char|
|00004fe0| 28 33 30 29 2c 0a 20 20 | 20 72 65 66 66 70 72 6f |(30),. | reffpro|
|00004ff0| 63 20 20 20 63 68 61 72 | 28 33 30 29 0a 29 0a 63 |c char|(30).).c|
|00005000| 6c 75 73 74 65 72 20 66 | 6f 72 6d 5f 74 61 62 6c |luster f|orm_tabl|
|00005010| 65 73 20 28 20 72 65 66 | 61 70 6f 77 6e 65 72 2c |es ( ref|apowner,|
|00005020| 20 72 65 66 61 70 6e 61 | 6d 65 20 29 0a 2f 0a 0a | refapna|me )./..|
|00005030| 63 72 65 61 74 65 20 74 | 61 62 6c 65 20 66 6f 72 |create t|able for|
|00005040| 6d 5f 70 72 6f 63 65 64 | 75 72 65 0a 28 0a 20 20 |m_proced|ure.(. |
|00005050| 20 70 72 6f 63 61 70 6f | 77 6e 65 72 20 63 68 61 | procapo|wner cha|
|00005060| 72 28 33 30 29 09 20 20 | 20 6e 6f 74 20 6e 75 6c |r(30). | not nul|
|00005070| 6c 2c 0a 20 20 20 70 72 | 6f 63 61 70 6e 61 6d 65 |l,. pr|ocapname|
|00005080| 20 20 63 68 61 72 28 33 | 30 29 09 20 20 20 6e 6f | char(3|0). no|
|00005090| 74 20 6e 75 6c 6c 2c 0a | 20 20 20 70 72 6f 63 6e |t null,.| procn|
|000050a0| 61 6d 65 20 20 20 20 63 | 68 61 72 28 33 30 29 09 |ame c|har(30).|
|000050b0| 20 20 20 6e 6f 74 20 6e | 75 6c 6c 2c 0a 20 20 20 | not n|ull,. |
|000050c0| 70 72 6f 63 74 65 78 74 | 20 20 20 20 6e 75 6d 62 |proctext| numb|
|000050d0| 65 72 0a 29 0a 63 6c 75 | 73 74 65 72 20 66 6f 72 |er.).clu|ster for|
|000050e0| 6d 5f 74 61 62 6c 65 73 | 20 28 20 70 72 6f 63 61 |m_tables| ( proca|
|000050f0| 70 6f 77 6e 65 72 2c 20 | 70 72 6f 63 61 70 6e 61 |powner, |procapna|
|00005100| 6d 65 20 29 0a 2f 0a 0a | 73 70 6f 6f 6c 20 6f 66 |me )./..|spool of|
|00005110| 66 0a 0a 30 37 30 37 30 | 37 30 30 30 34 35 30 30 |f..07070|70004500|
|00005120| 31 31 33 33 36 31 30 30 | 34 34 34 30 30 30 33 31 |11336100|44400031|
|00005130| 31 30 30 30 30 36 32 30 | 30 30 30 30 31 30 30 30 |10000620|00001000|
|00005140| 30 30 30 30 34 37 36 34 | 35 37 35 37 31 33 30 30 |00004764|57571300|
|00005150| 30 30 32 32 30 30 30 30 | 30 30 31 30 35 35 35 61 |00220000|0010555a|
|00005160| 64 6d 69 6e 2f 69 61 64 | 76 69 65 77 2e 73 71 6c |dmin/iad|view.sql|
|00005170| 00 72 65 6d 0a 72 65 6d | 20 24 48 65 61 64 65 72 |.rem.rem| $Header|
|00005180| 3a 20 69 61 64 76 69 65 | 77 2e 73 71 6c 2c 76 20 |: iadvie|w.sql,v |
|00005190| 33 30 30 31 34 30 30 2e | 31 20 39 30 2f 30 32 2f |3001400.|1 90/02/|
|000051a0| 32 37 20 31 34 3a 35 37 | 3a 35 36 20 72 63 73 20 |27 14:57|:56 rcs |
|000051b0| 45 78 70 20 24 20 69 61 | 64 76 69 65 77 2e 73 71 |Exp $ ia|dview.sq|
|000051c0| 6c 20 43 6f 70 79 72 20 | 28 63 29 20 31 39 38 39 |l Copyr |(c) 1989|
|000051d0| 20 4f 72 61 63 6c 65 0a | 72 65 6d 0a 72 65 6d 20 | Oracle.|rem.rem |
|000051e0| 53 51 4c 46 4f 52 4d 53 | 33 30 33 30 30 31 34 2c |SQLFORMS|3030014,|
|000051f0| 44 55 41 35 30 3a 5b 46 | 52 45 45 5a 45 5f 53 51 |DUA50:[F|REEZE_SQ|
|00005200| 4c 46 4f 52 4d 53 33 30 | 2e 53 51 4c 2e 33 30 30 |LFORMS30|.SQL.300|
|00005210| 31 34 5d 0a 52 65 6d 20 | 43 6f 70 79 72 69 67 68 |14].Rem |Copyrigh|
|00005220| 74 20 28 63 29 20 31 39 | 38 38 20 62 79 20 4f 72 |t (c) 19|88 by Or|
|00005230| 61 63 6c 65 20 43 6f 72 | 70 6f 72 61 74 69 6f 6e |acle Cor|poration|
|00005240| 0a 52 65 6d 20 4e 41 4d | 45 0a 52 65 6d 20 20 20 |.Rem NAM|E.Rem |
|00005250| 20 49 41 44 56 49 45 57 | 53 2e 53 51 4c 20 2d 20 | IADVIEW|S.SQL - |
|00005260| 43 72 65 61 74 65 20 76 | 69 65 77 73 20 74 6f 20 |Create v|iews to |
|00005270| 72 65 73 74 72 69 63 74 | 20 74 61 62 6c 65 20 61 |restrict| table a|
|00005280| 63 63 65 73 73 2e 0a 52 | 65 6d 20 20 46 55 4e 43 |ccess..R|em FUNC|
|00005290| 54 49 4f 4e 0a 52 65 6d | 20 20 4e 4f 54 45 53 0a |TION.Rem| NOTES.|
|000052a0| 52 65 6d 20 20 4d 4f 44 | 49 46 49 45 44 0a 52 65 |Rem MOD|IFIED.Re|
|000052b0| 6d 20 20 20 45 69 63 68 | 65 72 20 20 20 20 20 30 |m Eich|er 0|
|000052c0| 32 2f 30 35 2f 39 30 20 | 2d 20 43 72 65 61 74 69 |2/05/90 |- Creati|
|000052d0| 6f 6e 0a 52 65 6d 20 20 | 20 45 69 63 68 65 72 20 |on.Rem | Eicher |
|000052e0| 20 20 20 20 30 32 2f 30 | 35 2f 39 30 20 2d 20 52 | 02/0|5/90 - R|
|000052f0| 65 6e 61 6d 65 20 66 72 | 6f 6d 20 69 61 64 76 69 |ename fr|om iadvi|
|00005300| 65 77 73 2e 73 71 6c 20 | 2d 20 72 65 6e 61 6d 65 |ews.sql |- rename|
|00005310| 20 73 70 6f 6f 6c 20 66 | 69 6c 65 0a 52 65 6d 20 | spool f|ile.Rem |
|00005320| 20 20 45 69 63 68 65 72 | 20 20 20 20 20 31 32 2f | Eicher| 12/|
|00005330| 30 36 2f 38 39 20 2d 20 | 41 64 64 20 57 49 54 48 |06/89 - |Add WITH|
|00005340| 20 43 48 45 43 4b 20 4f | 50 54 49 4f 4e 0a 52 65 | CHECK O|PTION.Re|
|00005350| 6d 20 20 20 48 73 69 20 | 20 20 20 20 20 20 20 30 |m Hsi | 0|
|00005360| 33 2f 30 36 2f 38 39 20 | 2d 20 43 6c 75 73 74 65 |3/06/89 |- Cluste|
|00005370| 72 69 6e 67 20 74 61 62 | 6c 65 73 20 28 56 33 2e |ring tab|les (V3.|
|00005380| 30 2e 35 29 0a 52 65 6d | 20 20 20 46 69 6e 65 20 |0.5).Rem| Fine |
|00005390| 20 20 20 20 20 20 30 31 | 2f 32 35 2f 38 39 20 2d | 01|/25/89 -|
|000053a0| 20 54 4f 55 43 48 0a 52 | 65 6d 20 20 20 46 69 6e | TOUCH.R|em Fin|
|000053b0| 65 20 20 20 20 20 20 20 | 31 32 2f 30 38 2f 38 38 |e |12/08/88|
|000053c0| 20 2d 20 46 6f 6c 64 20 | 69 6e 20 55 4e 49 58 20 | - Fold |in UNIX |
|000053d0| 70 6f 72 74 69 6e 67 20 | 63 68 61 6e 67 65 73 0a |porting |changes.|
|000053e0| 52 65 6d 20 20 20 48 73 | 69 20 20 20 20 20 20 20 |Rem Hs|i |
|000053f0| 20 30 38 2f 33 31 2f 38 | 38 20 2d 20 43 68 61 6e | 08/31/8|8 - Chan|
|00005400| 67 65 20 74 61 62 6c 65 | 73 27 20 6e 61 6d 65 0a |ge table|s' name.|
|00005410| 52 65 6d 20 20 20 48 73 | 69 20 20 20 20 20 20 20 |Rem Hs|i |
|00005420| 20 30 38 2f 32 36 2f 38 | 38 20 2d 20 43 72 65 61 | 08/26/8|8 - Crea|
|00005430| 74 69 6f 6e 0a 52 65 6d | 0a 0a 73 70 6f 6f 6c 20 |tion.Rem|..spool |
|00005440| 69 61 64 76 69 65 77 2e | 6c 69 73 0a 0a 64 72 6f |iadview.|lis..dro|
|00005450| 70 20 76 69 65 77 20 66 | 6f 72 6d 5f 61 70 70 0a |p view f|orm_app.|
|00005460| 2f 0a 64 72 6f 70 20 76 | 69 65 77 20 66 6f 72 6d |/.drop v|iew form|
|00005470| 5f 62 6c 6b 0a 2f 0a 64 | 72 6f 70 20 76 69 65 77 |_blk./.d|rop view|
|00005480| 20 66 6f 72 6d 5f 66 6c | 64 0a 2f 0a 64 72 6f 70 | form_fl|d./.drop|
|00005490| 20 76 69 65 77 20 66 6f | 72 6d 5f 74 72 69 67 67 | view fo|rm_trigg|
|000054a0| 65 72 0a 2f 0a 64 72 6f | 70 20 76 69 65 77 20 66 |er./.dro|p view f|
|000054b0| 6f 72 6d 5f 74 72 67 0a | 2f 0a 64 72 6f 70 20 76 |orm_trg.|/.drop v|
|000054c0| 69 65 77 20 66 6f 72 6d | 5f 73 71 6c 74 78 74 0a |iew form|_sqltxt.|
|000054d0| 2f 0a 64 72 6f 70 20 76 | 69 65 77 20 66 6f 72 6d |/.drop v|iew form|
|000054e0| 5f 70 61 67 65 0a 2f 0a | 64 72 6f 70 20 76 69 65 |_page./.|drop vie|
|000054f0| 77 20 66 6f 72 6d 5f 6d | 61 70 0a 2f 0a 64 72 6f |w form_m|ap./.dro|
|00005500| 70 20 76 69 65 77 20 66 | 6f 72 6d 5f 63 6f 6d 6d |p view f|orm_comm|
|00005510| 65 6e 74 0a 2f 0a 64 72 | 6f 70 20 76 69 65 77 20 |ent./.dr|op view |
|00005520| 66 6f 72 6d 5f 72 65 66 | 65 72 65 6e 63 65 0a 2f |form_ref|erence./|
|00005530| 0a 64 72 6f 70 20 76 69 | 65 77 20 66 6f 72 6d 5f |.drop vi|ew form_|
|00005540| 70 72 6f 63 65 64 75 72 | 65 0a 2f 0a 64 72 6f 70 |procedur|e./.drop|
|00005550| 20 76 69 65 77 20 66 6f | 72 6d 5f 61 75 74 68 75 | view fo|rm_authu|
|00005560| 73 65 72 0a 2f 0a 64 72 | 6f 70 20 76 69 65 77 20 |ser./.dr|op view |
|00005570| 66 6f 72 6d 5f 75 73 65 | 72 0a 2f 0a 72 65 6e 61 |form_use|r./.rena|
|00005580| 6d 65 20 66 6f 72 6d 5f | 61 70 70 20 74 6f 20 66 |me form_|app to f|
|00005590| 6f 72 6d 5f 61 70 70 5f | 0a 2f 0a 72 65 6e 61 6d |orm_app_|./.renam|
|000055a0| 65 20 66 6f 72 6d 5f 62 | 6c 6b 20 74 6f 20 66 6f |e form_b|lk to fo|
|000055b0| 72 6d 5f 62 6c 6b 5f 0a | 2f 0a 72 65 6e 61 6d 65 |rm_blk_.|/.rename|
|000055c0| 20 66 6f 72 6d 5f 66 6c | 64 20 74 6f 20 66 6f 72 | form_fl|d to for|
|000055d0| 6d 5f 66 6c 64 5f 0a 2f | 20 0a 72 65 6e 61 6d 65 |m_fld_./| .rename|
|000055e0| 20 66 6f 72 6d 5f 74 72 | 69 67 67 65 72 20 74 6f | form_tr|igger to|
|000055f0| 20 66 6f 72 6d 5f 74 72 | 69 67 67 65 72 5f 0a 2f | form_tr|igger_./|
|00005600| 0a 72 65 6e 61 6d 65 20 | 66 6f 72 6d 5f 74 72 67 |.rename |form_trg|
|00005610| 20 74 6f 20 66 6f 72 6d | 5f 74 72 67 5f 0a 2f 0a | to form|_trg_./.|
|00005620| 72 65 6e 61 6d 65 20 66 | 6f 72 6d 5f 73 71 6c 74 |rename f|orm_sqlt|
|00005630| 78 74 20 74 6f 20 66 6f | 72 6d 5f 73 71 6c 74 78 |xt to fo|rm_sqltx|
|00005640| 74 5f 0a 2f 0a 72 65 6e | 61 6d 65 20 66 6f 72 6d |t_./.ren|ame form|
|00005650| 5f 70 61 67 65 20 74 6f | 20 66 6f 72 6d 5f 70 61 |_page to| form_pa|
|00005660| 67 65 5f 0a 2f 0a 72 65 | 6e 61 6d 65 20 66 6f 72 |ge_./.re|name for|
|00005670| 6d 5f 6d 61 70 20 74 6f | 20 66 6f 72 6d 5f 6d 61 |m_map to| form_ma|
|00005680| 70 5f 0a 2f 0a 72 65 6e | 61 6d 65 20 66 6f 72 6d |p_./.ren|ame form|
|00005690| 5f 63 6f 6d 6d 65 6e 74 | 20 74 6f 20 66 6f 72 6d |_comment| to form|
|000056a0| 5f 63 6f 6d 6d 65 6e 74 | 5f 0a 2f 0a 72 65 6e 61 |_comment|_./.rena|
|000056b0| 6d 65 20 66 6f 72 6d 5f | 72 65 66 65 72 65 6e 63 |me form_|referenc|
|000056c0| 65 20 74 6f 20 66 6f 72 | 6d 5f 72 65 66 65 72 65 |e to for|m_refere|
|000056d0| 6e 63 65 5f 0a 2f 0a 72 | 65 6e 61 6d 65 20 66 6f |nce_./.r|ename fo|
|000056e0| 72 6d 5f 70 72 6f 63 65 | 64 75 72 65 20 74 6f 20 |rm_proce|dure to |
|000056f0| 66 6f 72 6d 5f 70 72 6f | 63 65 64 75 72 65 5f 0a |form_pro|cedure_.|
|00005700| 2f 0a 63 72 65 61 74 65 | 20 74 61 62 6c 65 20 66 |/.create| table f|
|00005710| 6f 72 6d 5f 75 73 65 72 | 5f 0a 28 0a 20 20 20 75 |orm_user|_.(. u|
|00005720| 73 72 61 70 6f 77 6e 65 | 72 20 20 20 63 68 61 72 |srapowne|r char|
|00005730| 28 33 30 29 09 20 6e 6f | 74 20 6e 75 6c 6c 2c 0a |(30). no|t null,.|
|00005740| 20 20 20 75 73 72 61 70 | 6e 61 6d 65 09 63 68 61 | usrap|name.cha|
|00005750| 72 28 33 30 29 09 20 6e | 6f 74 20 6e 75 6c 6c 2c |r(30). n|ot null,|
|00005760| 0a 20 20 20 75 73 72 75 | 73 65 72 20 20 20 09 63 |. usru|ser .c|
|00005770| 68 61 72 28 33 30 29 20 | 20 20 09 20 6e 6f 74 20 |har(30) | . not |
|00005780| 6e 75 6c 6c 0a 29 0a 63 | 6c 75 73 74 65 72 20 66 |null.).c|luster f|
|00005790| 6f 72 6d 5f 74 61 62 6c | 65 73 20 28 20 75 73 72 |orm_tabl|es ( usr|
|000057a0| 61 70 6f 77 6e 65 72 2c | 20 75 73 72 61 70 6e 61 |apowner,| usrapna|
|000057b0| 6d 65 20 29 0a 2f 0a 64 | 72 6f 70 20 69 6e 64 65 |me )./.d|rop inde|
|000057c0| 78 20 69 66 6f 72 6d 5f | 75 73 65 72 0a 2f 0a 63 |x iform_|user./.c|
|000057d0| 72 65 61 74 65 20 75 6e | 69 71 75 65 20 69 6e 64 |reate un|ique ind|
|000057e0| 65 78 20 69 66 6f 72 6d | 5f 75 73 65 72 0a 6f 6e |ex iform|_user.on|
|000057f0| 20 66 6f 72 6d 5f 75 73 | 65 72 5f 28 75 73 72 61 | form_us|er_(usra|
|00005800| 70 6f 77 6e 65 72 2c 75 | 73 72 61 70 6e 61 6d 65 |powner,u|srapname|
|00005810| 2c 75 73 72 75 73 65 72 | 29 0a 2f 0a 63 72 65 61 |,usruser|)./.crea|
|00005820| 74 65 20 76 69 65 77 20 | 66 6f 72 6d 5f 61 75 74 |te view |form_aut|
|00005830| 68 75 73 65 72 20 61 73 | 0a 20 20 73 65 6c 65 63 |huser as|. selec|
|00005840| 74 20 2a 20 66 72 6f 6d | 20 66 6f 72 6d 5f 75 73 |t * from| form_us|
|00005850| 65 72 5f 0a 20 20 20 77 | 68 65 72 65 20 75 73 72 |er_. w|here usr|
|00005860| 75 73 65 72 20 3d 20 75 | 73 65 72 0a 20 20 20 20 |user = u|ser. |
|00005870| 20 20 6f 72 20 75 73 72 | 75 73 65 72 20 3d 20 27 | or usr|user = '|
|00005880| 50 55 42 4c 49 43 27 0a | 20 20 77 69 74 68 20 63 |PUBLIC'.| with c|
|00005890| 68 65 63 6b 20 6f 70 74 | 69 6f 6e 0a 2f 0a 63 72 |heck opt|ion./.cr|
|000058a0| 65 61 74 65 20 76 69 65 | 77 20 66 6f 72 6d 5f 75 |eate vie|w form_u|
|000058b0| 73 65 72 20 61 73 0a 20 | 20 73 65 6c 65 63 74 20 |ser as. | select |
|000058c0| 2a 20 66 72 6f 6d 20 66 | 6f 72 6d 5f 75 73 65 72 |* from f|orm_user|
|000058d0| 5f 0a 20 20 20 77 68 65 | 72 65 20 75 73 72 61 70 |_. whe|re usrap|
|000058e0| 6f 77 6e 65 72 20 3d 20 | 75 73 65 72 0a 20 20 77 |owner = |user. w|
|000058f0| 69 74 68 20 63 68 65 63 | 6b 20 6f 70 74 69 6f 6e |ith chec|k option|
|00005900| 0a 2f 0a 63 72 65 61 74 | 65 20 76 69 65 77 20 66 |./.creat|e view f|
|00005910| 6f 72 6d 5f 61 70 70 20 | 61 73 20 0a 20 20 73 65 |orm_app |as . se|
|00005920| 6c 65 63 74 20 2a 20 66 | 72 6f 6d 20 66 6f 72 6d |lect * f|rom form|
|00005930| 5f 61 70 70 5f 0a 20 20 | 20 77 68 65 72 65 20 61 |_app_. | where a|
|00005940| 70 70 6f 77 6e 65 72 20 | 3d 20 75 73 65 72 0a 20 |ppowner |= user. |
|00005950| 20 20 20 20 20 6f 72 20 | 28 20 61 70 70 6f 77 6e | or |( appown|
|00005960| 65 72 2c 20 61 70 70 6e | 61 6d 65 20 29 20 69 6e |er, appn|ame ) in|
|00005970| 0a 09 20 28 20 73 65 6c | 65 63 74 20 75 73 72 61 |.. ( sel|ect usra|
|00005980| 70 6f 77 6e 65 72 2c 20 | 75 73 72 61 70 6e 61 6d |powner, |usrapnam|
|00005990| 65 20 66 72 6f 6d 20 66 | 6f 72 6d 5f 61 75 74 68 |e from f|orm_auth|
|000059a0| 75 73 65 72 20 29 0a 20 | 20 77 69 74 68 20 63 68 |user ). | with ch|
|000059b0| 65 63 6b 20 6f 70 74 69 | 6f 6e 0a 2f 0a 63 72 65 |eck opti|on./.cre|
|000059c0| 61 74 65 20 76 69 65 77 | 20 66 6f 72 6d 5f 62 6c |ate view| form_bl|
|000059d0| 6b 20 61 73 0a 20 20 73 | 65 6c 65 63 74 20 2a 20 |k as. s|elect * |
|000059e0| 66 72 6f 6d 20 66 6f 72 | 6d 5f 62 6c 6b 5f 0a 20 |from for|m_blk_. |
|000059f0| 20 20 77 68 65 72 65 20 | 62 6c 6b 61 70 6f 77 6e | where |blkapown|
|00005a00| 65 72 20 3d 20 75 73 65 | 72 0a 20 20 20 20 20 20 |er = use|r. |
|00005a10| 6f 72 20 28 20 62 6c 6b | 61 70 6f 77 6e 65 72 2c |or ( blk|apowner,|
|00005a20| 20 62 6c 6b 61 70 6e 61 | 6d 65 20 29 20 69 6e 20 | blkapna|me ) in |
|00005a30| 0a 09 20 28 20 73 65 6c | 65 63 74 20 75 73 72 61 |.. ( sel|ect usra|
|00005a40| 70 6f 77 6e 65 72 2c 20 | 75 73 72 61 70 6e 61 6d |powner, |usrapnam|
|00005a50| 65 20 66 72 6f 6d 20 66 | 6f 72 6d 5f 61 75 74 68 |e from f|orm_auth|
|00005a60| 75 73 65 72 20 29 0a 20 | 20 77 69 74 68 20 63 68 |user ). | with ch|
|00005a70| 65 63 6b 20 6f 70 74 69 | 6f 6e 0a 2f 0a 63 72 65 |eck opti|on./.cre|
|00005a80| 61 74 65 20 76 69 65 77 | 20 66 6f 72 6d 5f 66 6c |ate view| form_fl|
|00005a90| 64 20 61 73 0a 20 20 73 | 65 6c 65 63 74 20 2a 20 |d as. s|elect * |
|00005aa0| 66 72 6f 6d 20 66 6f 72 | 6d 5f 66 6c 64 5f 0a 20 |from for|m_fld_. |
|00005ab0| 20 20 77 68 65 72 65 20 | 66 6c 64 61 70 6f 77 6e | where |fldapown|
|00005ac0| 65 72 20 3d 20 75 73 65 | 72 0a 20 20 20 20 20 20 |er = use|r. |
|00005ad0| 6f 72 20 28 20 66 6c 64 | 61 70 6f 77 6e 65 72 2c |or ( fld|apowner,|
|00005ae0| 20 66 6c 64 61 70 6e 61 | 6d 65 20 29 20 69 6e 0a | fldapna|me ) in.|
|00005af0| 09 20 28 20 73 65 6c 65 | 63 74 20 75 73 72 61 70 |. ( sele|ct usrap|
|00005b00| 6f 77 6e 65 72 2c 20 75 | 73 72 61 70 6e 61 6d 65 |owner, u|srapname|
|00005b10| 20 66 72 6f 6d 20 66 6f | 72 6d 5f 61 75 74 68 75 | from fo|rm_authu|
|00005b20| 73 65 72 20 29 0a 20 20 | 77 69 74 68 20 63 68 65 |ser ). |with che|
|00005b30| 63 6b 20 6f 70 74 69 6f | 6e 0a 2f 0a 63 72 65 61 |ck optio|n./.crea|
|00005b40| 74 65 20 76 69 65 77 20 | 66 6f 72 6d 5f 74 72 69 |te view |form_tri|
|00005b50| 67 67 65 72 20 61 73 0a | 20 20 73 65 6c 65 63 74 |gger as.| select|
|00005b60| 20 2a 20 66 72 6f 6d 20 | 66 6f 72 6d 5f 74 72 69 | * from |form_tri|
|00005b70| 67 67 65 72 5f 0a 20 20 | 20 77 68 65 72 65 20 74 |gger_. | where t|
|00005b80| 72 69 67 61 70 6f 77 6e | 65 72 20 3d 20 75 73 65 |rigapown|er = use|
|00005b90| 72 0a 20 20 20 20 20 20 | 6f 72 20 28 20 74 72 69 |r. |or ( tri|
|00005ba0| 67 61 70 6f 77 6e 65 72 | 2c 20 74 72 69 67 61 70 |gapowner|, trigap|
|00005bb0| 6e 61 6d 65 20 29 20 69 | 6e 0a 09 20 28 20 73 65 |name ) i|n.. ( se|
|00005bc0| 6c 65 63 74 20 75 73 72 | 61 70 6f 77 6e 65 72 2c |lect usr|apowner,|
|00005bd0| 20 75 73 72 61 70 6e 61 | 6d 65 20 66 72 6f 6d 20 | usrapna|me from |
|00005be0| 66 6f 72 6d 5f 61 75 74 | 68 75 73 65 72 20 29 0a |form_aut|huser ).|
|00005bf0| 20 20 77 69 74 68 20 63 | 68 65 63 6b 20 6f 70 74 | with c|heck opt|
|00005c00| 69 6f 6e 0a 2f 0a 63 72 | 65 61 74 65 20 76 69 65 |ion./.cr|eate vie|
|00005c10| 77 20 66 6f 72 6d 5f 74 | 72 67 20 61 73 0a 20 20 |w form_t|rg as. |
|00005c20| 73 65 6c 65 63 74 20 2a | 20 66 72 6f 6d 20 66 6f |select *| from fo|
|00005c30| 72 6d 5f 74 72 67 5f 0a | 20 20 20 77 68 65 72 65 |rm_trg_.| where|
|00005c40| 20 74 72 67 61 70 6f 77 | 6e 65 72 20 3d 20 75 73 | trgapow|ner = us|
|00005c50| 65 72 0a 20 20 20 20 20 | 20 6f 72 20 28 20 74 72 |er. | or ( tr|
|00005c60| 67 61 70 6f 77 6e 65 72 | 2c 20 74 72 67 61 70 6e |gapowner|, trgapn|
|00005c70| 61 6d 65 20 29 20 69 6e | 0a 09 20 28 20 73 65 6c |ame ) in|.. ( sel|
|00005c80| 65 63 74 20 75 73 72 61 | 70 6f 77 6e 65 72 2c 20 |ect usra|powner, |
|00005c90| 75 73 72 61 70 6e 61 6d | 65 20 66 72 6f 6d 20 66 |usrapnam|e from f|
|00005ca0| 6f 72 6d 5f 61 75 74 68 | 75 73 65 72 20 29 0a 20 |orm_auth|user ). |
|00005cb0| 20 77 69 74 68 20 63 68 | 65 63 6b 20 6f 70 74 69 | with ch|eck opti|
|00005cc0| 6f 6e 0a 2f 0a 63 72 65 | 61 74 65 20 76 69 65 77 |on./.cre|ate view|
|00005cd0| 20 66 6f 72 6d 5f 73 71 | 6c 74 78 74 20 61 73 0a | form_sq|ltxt as.|
|00005ce0| 20 20 73 65 6c 65 63 74 | 20 2a 20 66 72 6f 6d 20 | select| * from |
|00005cf0| 66 6f 72 6d 5f 73 71 6c | 74 78 74 5f 0a 20 20 20 |form_sql|txt_. |
|00005d00| 77 68 65 72 65 20 73 71 | 74 61 70 6f 77 6e 65 72 |where sq|tapowner|
|00005d10| 20 3d 20 75 73 65 72 0a | 20 20 20 20 20 20 6f 72 | = user.| or|
|00005d20| 20 28 20 73 71 74 61 70 | 6f 77 6e 65 72 2c 20 73 | ( sqtap|owner, s|
|00005d30| 71 74 61 70 6e 61 6d 65 | 20 29 20 69 6e 0a 09 20 |qtapname| ) in.. |
|00005d40| 28 20 73 65 6c 65 63 74 | 20 75 73 72 61 70 6f 77 |( select| usrapow|
|00005d50| 6e 65 72 2c 20 75 73 72 | 61 70 6e 61 6d 65 20 66 |ner, usr|apname f|
|00005d60| 72 6f 6d 20 66 6f 72 6d | 5f 61 75 74 68 75 73 65 |rom form|_authuse|
|00005d70| 72 20 29 0a 20 20 77 69 | 74 68 20 63 68 65 63 6b |r ). wi|th check|
|00005d80| 20 6f 70 74 69 6f 6e 0a | 2f 0a 63 72 65 61 74 65 | option.|/.create|
|00005d90| 20 76 69 65 77 20 66 6f | 72 6d 5f 70 61 67 65 20 | view fo|rm_page |
|00005da0| 61 73 0a 20 20 73 65 6c | 65 63 74 20 2a 20 66 72 |as. sel|ect * fr|
|00005db0| 6f 6d 20 66 6f 72 6d 5f | 70 61 67 65 5f 0a 20 20 |om form_|page_. |
|00005dc0| 20 77 68 65 72 65 20 70 | 61 67 61 70 6f 77 6e 65 | where p|agapowne|
|00005dd0| 72 20 3d 20 75 73 65 72 | 0a 20 20 20 20 20 20 6f |r = user|. o|
|00005de0| 72 20 28 20 70 61 67 61 | 70 6f 77 6e 65 72 2c 20 |r ( paga|powner, |
|00005df0| 70 61 67 61 70 6e 61 6d | 65 20 29 20 69 6e 0a 09 |pagapnam|e ) in..|
|00005e00| 20 28 20 73 65 6c 65 63 | 74 20 75 73 72 61 70 6f | ( selec|t usrapo|
|00005e10| 77 6e 65 72 2c 20 75 73 | 72 61 70 6e 61 6d 65 20 |wner, us|rapname |
|00005e20| 66 72 6f 6d 20 66 6f 72 | 6d 5f 61 75 74 68 75 73 |from for|m_authus|
|00005e30| 65 72 20 29 0a 20 20 77 | 69 74 68 20 63 68 65 63 |er ). w|ith chec|
|00005e40| 6b 20 6f 70 74 69 6f 6e | 0a 2f 0a 63 72 65 61 74 |k option|./.creat|
|00005e50| 65 20 76 69 65 77 20 66 | 6f 72 6d 5f 6d 61 70 20 |e view f|orm_map |
|00005e60| 61 73 0a 20 20 73 65 6c | 65 63 74 20 2a 20 66 72 |as. sel|ect * fr|
|00005e70| 6f 6d 20 66 6f 72 6d 5f | 6d 61 70 5f 0a 20 20 20 |om form_|map_. |
|00005e80| 77 68 65 72 65 20 6d 61 | 70 61 70 6f 77 6e 65 72 |where ma|papowner|
|00005e90| 20 3d 20 75 73 65 72 0a | 20 20 20 20 20 20 6f 72 | = user.| or|
|00005ea0| 20 28 20 6d 61 70 61 70 | 6f 77 6e 65 72 2c 20 6d | ( mapap|owner, m|
|00005eb0| 61 70 61 70 6e 61 6d 65 | 20 29 20 69 6e 0a 09 20 |apapname| ) in.. |
|00005ec0| 28 20 73 65 6c 65 63 74 | 20 75 73 72 61 70 6f 77 |( select| usrapow|
|00005ed0| 6e 65 72 2c 20 75 73 72 | 61 70 6e 61 6d 65 20 66 |ner, usr|apname f|
|00005ee0| 72 6f 6d 20 66 6f 72 6d | 5f 61 75 74 68 75 73 65 |rom form|_authuse|
|00005ef0| 72 20 29 0a 20 20 77 69 | 74 68 20 63 68 65 63 6b |r ). wi|th check|
|00005f00| 20 6f 70 74 69 6f 6e 0a | 2f 0a 63 72 65 61 74 65 | option.|/.create|
|00005f10| 20 76 69 65 77 20 66 6f | 72 6d 5f 63 6f 6d 6d 65 | view fo|rm_comme|
|00005f20| 6e 74 20 61 73 0a 20 20 | 73 65 6c 65 63 74 20 2a |nt as. |select *|
|00005f30| 20 66 72 6f 6d 20 66 6f | 72 6d 5f 63 6f 6d 6d 65 | from fo|rm_comme|
|00005f40| 6e 74 5f 0a 20 20 20 77 | 68 65 72 65 20 63 6d 74 |nt_. w|here cmt|
|00005f50| 61 70 6f 77 6e 65 72 20 | 3d 20 75 73 65 72 0a 20 |apowner |= user. |
|00005f60| 20 20 20 20 20 6f 72 20 | 28 20 63 6d 74 61 70 6f | or |( cmtapo|
|00005f70| 77 6e 65 72 2c 20 63 6d | 74 61 70 6e 61 6d 65 20 |wner, cm|tapname |
|00005f80| 29 20 69 6e 20 0a 09 20 | 28 20 73 65 6c 65 63 74 |) in .. |( select|
|00005f90| 20 75 73 72 61 70 6f 77 | 6e 65 72 2c 20 75 73 72 | usrapow|ner, usr|
|00005fa0| 61 70 6e 61 6d 65 20 66 | 72 6f 6d 20 66 6f 72 6d |apname f|rom form|
|00005fb0| 5f 61 75 74 68 75 73 65 | 72 20 29 0a 20 20 77 69 |_authuse|r ). wi|
|00005fc0| 74 68 20 63 68 65 63 6b | 20 6f 70 74 69 6f 6e 0a |th check| option.|
|00005fd0| 2f 0a 63 72 65 61 74 65 | 20 76 69 65 77 20 66 6f |/.create| view fo|
|00005fe0| 72 6d 5f 72 65 66 65 72 | 65 6e 63 65 20 61 73 0a |rm_refer|ence as.|
|00005ff0| 20 20 73 65 6c 65 63 74 | 20 2a 20 66 72 6f 6d 20 | select| * from |
|00006000| 66 6f 72 6d 5f 72 65 66 | 65 72 65 6e 63 65 5f 0a |form_ref|erence_.|
|00006010| 20 20 20 77 68 65 72 65 | 20 72 65 66 61 70 6f 77 | where| refapow|
|00006020| 6e 65 72 20 3d 20 75 73 | 65 72 0a 20 20 20 20 20 |ner = us|er. |
|00006030| 20 6f 72 20 28 20 72 65 | 66 61 70 6f 77 6e 65 72 | or ( re|fapowner|
|00006040| 2c 20 72 65 66 61 70 6e | 61 6d 65 20 29 20 69 6e |, refapn|ame ) in|
|00006050| 20 0a 09 20 28 20 73 65 | 6c 65 63 74 20 75 73 72 | .. ( se|lect usr|
|00006060| 61 70 6f 77 6e 65 72 2c | 20 75 73 72 61 70 6e 61 |apowner,| usrapna|
|00006070| 6d 65 20 66 72 6f 6d 20 | 66 6f 72 6d 5f 61 75 74 |me from |form_aut|
|00006080| 68 75 73 65 72 20 29 0a | 20 20 77 69 74 68 20 63 |huser ).| with c|
|00006090| 68 65 63 6b 20 6f 70 74 | 69 6f 6e 0a 2f 0a 63 72 |heck opt|ion./.cr|
|000060a0| 65 61 74 65 20 76 69 65 | 77 20 66 6f 72 6d 5f 70 |eate vie|w form_p|
|000060b0| 72 6f 63 65 64 75 72 65 | 20 61 73 0a 20 20 73 65 |rocedure| as. se|
|000060c0| 6c 65 63 74 20 2a 20 66 | 72 6f 6d 20 66 6f 72 6d |lect * f|rom form|
|000060d0| 5f 70 72 6f 63 65 64 75 | 72 65 5f 0a 20 20 20 77 |_procedu|re_. w|
|000060e0| 68 65 72 65 20 70 72 6f | 63 61 70 6f 77 6e 65 72 |here pro|capowner|
|000060f0| 20 3d 20 75 73 65 72 0a | 20 20 20 20 20 20 6f 72 | = user.| or|
|00006100| 20 28 20 70 72 6f 63 61 | 70 6f 77 6e 65 72 2c 20 | ( proca|powner, |
|00006110| 70 72 6f 63 61 70 6e 61 | 6d 65 20 29 20 69 6e 20 |procapna|me ) in |
|00006120| 0a 09 20 28 20 73 65 6c | 65 63 74 20 75 73 72 61 |.. ( sel|ect usra|
|00006130| 70 6f 77 6e 65 72 2c 20 | 75 73 72 61 70 6e 61 6d |powner, |usrapnam|
|00006140| 65 20 66 72 6f 6d 20 66 | 6f 72 6d 5f 61 75 74 68 |e from f|orm_auth|
|00006150| 75 73 65 72 20 29 0a 20 | 20 77 69 74 68 20 63 68 |user ). | with ch|
|00006160| 65 63 6b 20 6f 70 74 69 | 6f 6e 0a 2f 0a 67 72 61 |eck opti|on./.gra|
|00006170| 6e 74 20 73 65 6c 65 63 | 74 0a 6f 6e 20 20 20 20 |nt selec|t.on |
|00006180| 73 79 73 74 65 6d 2e 66 | 6f 72 6d 5f 61 75 74 68 |system.f|orm_auth|
|00006190| 75 73 65 72 0a 74 6f 20 | 20 20 20 70 75 62 6c 69 |user.to | publi|
|000061a0| 63 0a 2f 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |c./ | |
|000061b0| 20 20 20 20 20 0a 67 72 | 61 6e 74 20 73 65 6c 65 | .gr|ant sele|
|000061c0| 63 74 2c 20 69 6e 73 65 | 72 74 2c 20 75 70 64 61 |ct, inse|rt, upda|
|000061d0| 74 65 2c 20 64 65 6c 65 | 74 65 0a 6f 6e 20 20 20 |te, dele|te.on |
|000061e0| 20 73 79 73 74 65 6d 2e | 66 6f 72 6d 5f 75 73 65 | system.|form_use|
|000061f0| 72 0a 74 6f 20 20 20 20 | 70 75 62 6c 69 63 0a 2f |r.to |public./|
|00006200| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00006210| 20 20 0a 64 72 6f 70 20 | 70 75 62 6c 69 63 20 73 | .drop |public s|
|00006220| 79 6e 6f 6e 79 6d 20 66 | 6f 72 6d 5f 61 75 74 68 |ynonym f|orm_auth|
|00006230| 75 73 65 72 0a 2f 0a 63 | 72 65 61 74 65 20 70 75 |user./.c|reate pu|
|00006240| 62 6c 69 63 20 73 79 6e | 6f 6e 79 6d 20 66 6f 72 |blic syn|onym for|
|00006250| 6d 5f 61 75 74 68 75 73 | 65 72 0a 66 6f 72 20 20 |m_authus|er.for |
|00006260| 20 20 73 79 73 74 65 6d | 2e 66 6f 72 6d 5f 61 75 | system|.form_au|
|00006270| 74 68 75 73 65 72 0a 2f | 0a 64 72 6f 70 20 70 75 |thuser./|.drop pu|
|00006280| 62 6c 69 63 20 73 79 6e | 6f 6e 79 6d 20 66 6f 72 |blic syn|onym for|
|00006290| 6d 5f 75 73 65 72 0a 2f | 0a 63 72 65 61 74 65 20 |m_user./|.create |
|000062a0| 70 75 62 6c 69 63 20 73 | 79 6e 6f 6e 79 6d 20 66 |public s|ynonym f|
|000062b0| 6f 72 6d 5f 75 73 65 72 | 0a 66 6f 72 20 20 20 20 |orm_user|.for |
|000062c0| 73 79 73 74 65 6d 2e 66 | 6f 72 6d 5f 75 73 65 72 |system.f|orm_user|
|000062d0| 0a 2f 0a 0a 73 70 6f 6f | 6c 20 6f 66 66 0a 30 37 |./..spoo|l off.07|
|000062e0| 30 37 30 37 30 30 30 34 | 35 30 30 31 31 33 33 37 |07070004|50011337|
|000062f0| 30 34 30 37 35 35 30 30 | 30 33 31 31 30 30 30 30 |04075500|03110000|
|00006300| 36 32 30 30 30 30 30 32 | 30 30 30 30 30 30 30 34 |62000002|00000004|
|00006310| 37 36 34 35 37 35 37 37 | 33 30 30 30 30 31 37 30 |76457577|30000170|
|00006320| 30 30 30 30 30 30 30 30 | 30 30 61 64 6d 69 6e 2f |00000000|00admin/|
|00006330| 72 65 73 6f 75 72 63 65 | 00 30 37 30 37 30 37 30 |resource|.0707070|
|00006340| 30 30 34 35 30 30 31 31 | 33 34 30 31 30 30 36 34 |00450011|34010064|
|00006350| 34 30 30 30 33 31 31 30 | 30 30 30 36 32 30 30 30 |40003110|00062000|
|00006360| 30 30 31 30 30 30 30 30 | 30 30 34 37 36 34 35 37 |00100000|00476457|
|00006370| 35 37 31 36 30 30 30 30 | 33 30 30 30 30 30 30 30 |57160000|30000000|
|00006380| 34 30 30 30 30 61 64 6d | 69 6e 2f 72 65 73 6f 75 |40000adm|in/resou|
|00006390| 72 63 65 2f 33 32 37 38 | 6d 34 2e 72 00 ff 52 45 |rce/3278|m4.r..RE|
|000063a0| 53 00 04 00 00 23 89 00 | ae 00 00 06 78 61 70 70 |S....#..|....xapp|
|000063b0| 6c 69 00 05 00 07 61 70 | 70 76 65 72 73 00 00 00 |li....ap|pvers...|
|000063c0| 00 01 00 01 00 01 00 00 | 00 00 00 00 01 01 00 00 |........|........|
|000063d0| 00 ff 00 01 00 00 00 00 | 01 00 00 00 07 61 70 70 |........|.....app|
|000063e0| 6e 61 6d 65 09 00 00 00 | 01 00 01 00 00 00 00 00 |name....|........|
|000063f0| 00 00 00 00 07 61 70 70 | 64 65 73 63 09 00 00 00 |.....app|desc....|
+--------+-------------------------+-------------------------+--------+--------+
Only 25.0 KB of data is shown above.
