Programming Languages Suite

home *** CD-ROM | disk | FTP | other *** search
/ Programming Languages Suite / ProgramD2.iso / Database Designers / Erwin 3.0 / ERWIN / V2_CMS.TAR < prev
Tape Archive | 1995-01-06 | 350.0 KB
open in:
MacOS 8.1 extracted |
Win98 extracted |
DOS extracted
view JSON data |
view as text

This file was processed as: Tape Archive (archive/tar).

You can browse this item here: V2_CMS.TAR
Confidence	Program	Detection	Match Type	Support
`100%`	dexvert	Tape Archive `(archive/tar)`	magic	Supported
`100%`	file	POSIX tar archive	default
`99%`	file	POSIX tar archive, directory ./v2_cms/, mode 0040775, uid 0000013, gid 0013563, size 00000000000, seconds 05703114442, user sybase, group sybase, devmaj 0000040, devmin 0000200	default
`98%`	file	data	default
`62%`	TrID	TAR - Tape ARchive (POSIX)	default
`37%`	TrID	TAR - Tape ARchive (directory)	default
`100%`	siegfried	x-fmt/265 Tape Archive Format	default
`100%`	lsar	Tar	default
`100%`	gt2	TAR Archiv gefunden (Auflistung ist deaktiviert)	default
`100%`	disktype	POSIX tar archive	default
`100%`	detectItEasy	Archive: tar	default
`100%`	binwalkID	POSIX tar archive, owner user name: "/"	default
`100%`	xdgMime	application/x-tar	default
hex view
+--------+-------------------------+-------------------------+--------+--------+
|00000000| 2e 2f 76 32 5f 63 6d 73 | 2f 00 00 00 00 00 00 00 |./v2_cms|/.......|
|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 30 30 34 30 | 37 37 35 00 30 30 30 30 |....0040|775.0000|
|00000070| 30 31 33 00 30 30 31 33 | 35 36 33 00 30 30 30 30 |013.0013|563.0000|
|00000080| 30 30 30 30 30 30 30 00 | 30 35 37 30 33 31 31 34 |0000000.|05703114|
|00000090| 34 34 32 00 30 30 31 33 | 32 35 32 00 35 00 00 00 |442.0013|252.5...|
|000000a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000000b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000000c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000000d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000000e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000000f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000100| 00 75 73 74 61 72 00 30 | 30 73 79 62 61 73 65 00 |.ustar.0|0sybase.|
|00000110| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000120| 00 00 00 00 00 00 00 00 | 00 73 79 62 61 73 65 00 |........|.sybase.|
|00000130| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000140| 00 00 00 00 00 00 00 00 | 00 30 30 30 30 30 34 30 |........|.0000040|
|00000150| 00 30 30 30 30 32 30 30 | 00 00 00 00 00 00 00 00 |.0000200|........|
|00000160| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000170| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000180| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000190| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000001a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000001b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000001c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000001d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000001e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000001f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000200| 2e 2f 76 32 5f 63 6d 73 | 2f 74 61 62 6c 65 2f 00 |./v2_cms|/table/.|
|00000210| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000220| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000230| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000240| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000250| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000260| 00 00 00 00 30 30 34 30 | 37 37 35 00 30 30 30 30 |....0040|775.0000|
|00000270| 30 31 33 00 30 30 31 33 | 35 36 33 00 30 30 30 30 |013.0013|563.0000|
|00000280| 30 30 30 30 30 30 30 00 | 30 35 37 30 33 31 31 34 |0000000.|05703114|
|00000290| 33 34 33 00 30 30 31 34 | 33 34 31 00 35 00 00 00 |343.0014|341.5...|
|000002a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000002b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000002c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000002d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000002e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000002f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000300| 00 75 73 74 61 72 00 30 | 30 73 79 62 61 73 65 00 |.ustar.0|0sybase.|
|00000310| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000320| 00 00 00 00 00 00 00 00 | 00 73 79 62 61 73 65 00 |........|.sybase.|
|00000330| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000340| 00 00 00 00 00 00 00 00 | 00 30 30 30 30 30 34 30 |........|.0000040|
|00000350| 00 30 30 30 30 32 30 30 | 00 00 00 00 00 00 00 00 |.0000200|........|
|00000360| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000370| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000380| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000390| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000003a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000003b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000003c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000003d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000003e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000003f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000400| 2e 2f 76 32 5f 63 6d 73 | 2f 74 61 62 6c 65 2f 72 |./v2_cms|/table/r|
|00000410| 65 66 5f 74 61 62 6c 65 | 2f 00 00 00 00 00 00 00 |ef_table|/.......|
|00000420| 00 00 00 00 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 30 30 34 30 | 37 37 35 00 30 30 30 30 |....0040|775.0000|
|00000470| 30 31 33 00 30 30 31 33 | 35 36 33 00 30 30 30 30 |013.0013|563.0000|
|00000480| 30 30 30 30 30 30 30 00 | 30 35 37 30 33 31 31 36 |0000000.|05703116|
|00000490| 31 37 31 00 30 30 31 36 | 32 36 35 00 35 00 00 00 |171.0016|265.5...|
|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 75 73 74 61 72 00 30 | 30 73 79 62 61 73 65 00 |.ustar.0|0sybase.|
|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 73 79 62 61 73 65 00 |........|.sybase.|
|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 30 30 30 30 30 34 30 |........|.0000040|
|00000550| 00 30 30 30 30 32 30 30 | 00 00 00 00 00 00 00 00 |.0000200|........|
|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| 2e 2f 76 32 5f 63 6d 73 | 2f 74 61 62 6c 65 2f 72 |./v2_cms|/table/r|
|00000610| 65 66 5f 74 61 62 6c 65 | 2f 72 65 66 5f 61 63 63 |ef_table|/ref_acc|
|00000620| 6f 75 6e 74 5f 61 63 74 | 69 6f 6e 2e 74 61 62 00 |ount_act|ion.tab.|
|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 30 31 30 30 | 36 36 34 00 30 30 30 30 |....0100|664.0000|
|00000670| 30 31 33 00 30 30 31 33 | 35 36 33 00 30 30 30 30 |013.0013|563.0000|
|00000680| 30 30 30 30 34 34 37 00 | 30 35 37 30 33 30 34 33 |0000447.|05703043|
|00000690| 37 34 36 00 30 30 32 32 | 36 31 33 00 30 00 00 00 |746.0022|613.0...|
|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 75 73 74 61 72 00 30 | 30 73 79 62 61 73 65 00 |.ustar.0|0sybase.|
|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 73 79 62 61 73 65 00 |........|.sybase.|
|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 30 30 30 30 30 34 30 |........|.0000040|
|00000750| 00 30 30 30 30 32 30 30 | 00 00 00 00 00 00 00 00 |.0000200|........|
|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| 2f 2a 20 53 43 43 53 20 | 49 6e 66 6f 72 6d 61 74 |/* SCCS |Informat|
|00000810| 69 6f 6e 3a 09 25 57 25 | 20 25 47 25 20 2a 2f 0a |ion:.%W%| %G% */.|
|00000820| 0a 75 73 65 20 76 32 5f | 63 6d 73 0a 67 6f 0a 0a |.use v2_|cms.go..|
|00000830| 69 66 20 65 78 69 73 74 | 73 20 28 73 65 6c 65 63 |if exist|s (selec|
|00000840| 74 20 2a 20 66 72 6f 6d | 20 73 79 73 6f 62 6a 65 |t * from| sysobje|
|00000850| 63 74 73 20 77 68 65 72 | 65 0a 20 20 20 6e 61 6d |cts wher|e.   nam|
|00000860| 65 20 3d 20 22 72 65 66 | 5f 61 63 63 6f 75 6e 74 |e = "ref|_account|
|00000870| 5f 61 63 74 69 6f 6e 22 | 20 61 6e 64 20 74 79 70 |_action"| and typ|
|00000880| 65 20 3d 20 22 55 22 29 | 0a 20 20 44 52 4f 50 20 |e = "U")|.  DROP |
|00000890| 54 41 42 4c 45 20 72 65 | 66 5f 61 63 63 6f 75 6e |TABLE re|f_accoun|
|000008a0| 74 5f 61 63 74 69 6f 6e | 0a 67 6f 0a 0a 43 52 45 |t_action|.go..CRE|
|000008b0| 41 54 45 20 54 41 42 4c | 45 20 72 65 66 5f 61 63 |ATE TABL|E ref_ac|
|000008c0| 63 6f 75 6e 74 5f 61 63 | 74 69 6f 6e 0a 20 20 20 |count_ac|tion.   |
|000008d0| 20 20 20 28 63 6f 64 65 | 20 20 20 20 20 20 09 63 |   (code|      .c|
|000008e0| 6f 64 65 20 20 20 20 20 | 20 20 20 4e 4f 54 20 4e |ode     |   NOT N|
|000008f0| 55 4c 4c 2c 0a 20 20 20 | 20 20 20 20 64 65 73 63 |ULL,.   |    desc|
|00000900| 72 69 70 74 69 6f 6e 20 | 20 20 20 20 20 76 61 72 |ription |     var|
|00000910| 63 68 61 72 28 35 30 29 | 20 4e 4f 54 20 4e 55 4c |char(50)| NOT NUL|
|00000920| 4c 0a 29 0a 67 6f 0a 3a | 36 30 30 33 3a 73 79 62 |L.).go.:|6003:syb|
|00000930| 61 73 65 2c 72 6f 6f 74 | 0a 64 65 76 3a 3a 31 35 |ase,root|.dev::15|
|00000940| 3a 64 65 76 31 2c 64 65 | 76 32 2c 64 65 76 33 2c |:dev1,de|v2,dev3,|
|00000950| 64 65 76 34 2c 64 65 76 | 35 2c 64 65 76 36 2c 64 |dev4,dev|5,dev6,d|
|00000960| 65 76 37 2c 64 65 76 38 | 2c 64 65 76 39 2c 64 65 |ev7,dev8|,dev9,de|
|00000970| 76 31 30 0a 31 3a 38 3a | 30 30 30 30 2d 6c 70 28 |v10.1:8:|0000-lp(|
|00000980| 30 30 30 30 29 3a 2f 75 | 73 72 2f 73 70 6f 6f 6c |0000):/u|sr/spool|
|00000990| 2f 6c 70 3a 0a 73 79 62 | 61 73 65 3a 78 3a 31 31 |/lp:.syb|ase:x:11|
|000009a0| 3a 36 30 30 33 3a 53 59 | 42 41 53 45 20 69 64 3a |:6003:SY|BASE id:|
|000009b0| 2f 6f 70 74 2f 73 79 62 | 61 73 65 3a 2f 62 69 6e |/opt/syb|ase:/bin|
|000009c0| 2f 6b 73 68 0a 66 66 61 | 72 6f 6f 71 69 3a 78 3a |/ksh.ffa|rooqi:x:|
|000009d0| 31 30 30 3a 36 30 30 30 | 31 3a 46 75 61 64 20 46 |100:6000|1:Fuad F|
|000009e0| 61 72 6f 6f 71 69 3a 2f | 65 78 70 6f 72 74 2f 68 |arooqi:/|export/h|
|000009f0| 6f 6d 65 2f 66 66 61 72 | 6f 6f 71 69 3a 2f 62 69 |ome/ffar|ooqi:/bi|
|00000a00| 2e 2f 76 32 5f 63 6d 73 | 2f 74 61 62 6c 65 2f 72 |./v2_cms|/table/r|
|00000a10| 65 66 5f 74 61 62 6c 65 | 2f 72 65 66 5f 61 63 63 |ef_table|/ref_acc|
|00000a20| 6f 75 6e 74 5f 61 75 74 | 68 6f 72 69 7a 61 74 69 |ount_aut|horizati|
|00000a30| 6f 6e 2e 74 61 62 00 00 | 00 00 00 00 00 00 00 00 |on.tab..|........|
|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 30 31 30 30 | 36 36 34 00 30 30 30 30 |....0100|664.0000|
|00000a70| 30 31 33 00 30 30 31 33 | 35 36 33 00 30 30 30 30 |013.0013|563.0000|
|00000a80| 30 30 30 30 34 37 34 00 | 30 35 37 30 33 30 34 33 |0000474.|05703043|
|00000a90| 37 34 37 00 30 30 32 34 | 32 33 37 00 30 00 00 00 |747.0024|237.0...|
|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 75 73 74 61 72 00 30 | 30 73 79 62 61 73 65 00 |.ustar.0|0sybase.|
|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 73 79 62 61 73 65 00 |........|.sybase.|
|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 30 30 30 30 30 34 30 |........|.0000040|
|00000b50| 00 30 30 30 30 32 30 30 | 00 00 00 00 00 00 00 00 |.0000200|........|
|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| 2f 2a 20 53 43 43 53 20 | 49 6e 66 6f 72 6d 61 74 |/* SCCS |Informat|
|00000c10| 69 6f 6e 3a 09 25 57 25 | 20 25 47 25 20 2a 2f 0a |ion:.%W%| %G% */.|
|00000c20| 0a 75 73 65 20 76 32 5f | 63 6d 73 0a 67 6f 0a 0a |.use v2_|cms.go..|
|00000c30| 69 66 20 65 78 69 73 74 | 73 20 28 73 65 6c 65 63 |if exist|s (selec|
|00000c40| 74 20 2a 20 66 72 6f 6d | 20 73 79 73 6f 62 6a 65 |t * from| sysobje|
|00000c50| 63 74 73 20 77 68 65 72 | 65 0a 20 20 20 6e 61 6d |cts wher|e.   nam|
|00000c60| 65 20 3d 20 22 72 65 66 | 5f 61 63 63 6f 75 6e 74 |e = "ref|_account|
|00000c70| 5f 61 75 74 68 6f 72 69 | 7a 61 74 69 6f 6e 22 20 |_authori|zation" |
|00000c80| 61 6e 64 20 74 79 70 65 | 20 3d 20 22 55 22 29 0a |and type| = "U").|
|00000c90| 20 20 44 52 4f 50 20 54 | 41 42 4c 45 20 72 65 66 |  DROP T|ABLE ref|
|00000ca0| 5f 61 63 63 6f 75 6e 74 | 5f 61 75 74 68 6f 72 69 |_account|_authori|
|00000cb0| 7a 61 74 69 6f 6e 0a 67 | 6f 0a 0a 43 52 45 41 54 |zation.g|o..CREAT|
|00000cc0| 45 20 54 41 42 4c 45 20 | 72 65 66 5f 61 63 63 6f |E TABLE |ref_acco|
|00000cd0| 75 6e 74 5f 61 75 74 68 | 6f 72 69 7a 61 74 69 6f |unt_auth|orizatio|
|00000ce0| 6e 0a 20 20 20 20 20 20 | 28 63 6f 64 65 20 20 20 |n.      |(code   |
|00000cf0| 20 20 20 09 63 6f 64 65 | 20 20 20 20 20 20 20 20 |   .code|        |
|00000d00| 4e 4f 54 20 4e 55 4c 4c | 2c 0a 20 20 20 20 20 20 |NOT NULL|,.      |
|00000d10| 20 64 65 73 63 72 69 70 | 74 69 6f 6e 20 20 20 20 | descrip|tion    |
|00000d20| 20 20 76 61 72 63 68 61 | 72 28 35 30 29 20 4e 4f |  varcha|r(50) NO|
|00000d30| 54 20 4e 55 4c 4c 0a 29 | 0a 67 6f 0a 00 00 01 80 |T NULL.)|.go.....|
|00000d40| 00 20 72 65 66 5f 64 65 | 70 6f 73 69 74 5f 74 79 |. ref_de|posit_ty|
|00000d50| 70 65 2e 74 61 62 00 6e | 00 0e b0 4f 00 00 01 a0 |pe.tab.n|...O....|
|00000d60| 00 20 72 65 66 5f 63 6f | 6e 74 61 63 74 5f 74 79 |. ref_co|ntact_ty|
|00000d70| 70 65 2e 74 61 62 00 73 | 00 0e b0 50 00 00 01 c0 |pe.tab.s|...P....|
|00000d80| 00 24 72 65 66 5f 63 72 | 65 64 69 74 5f 72 65 66 |.$ref_cr|edit_ref|
|00000d90| 5f 74 79 70 65 2e 74 61 | 62 00 b0 4f 00 0e b0 51 |_type.ta|b..O...Q|
|00000da0| 00 00 01 d8 00 1c 72 65 | 66 5f 69 64 5f 74 79 70 |......re|f_id_typ|
|00000db0| 65 2e 74 61 62 00 00 29 | 00 0e b0 52 00 00 02 00 |e.tab..)|...R....|
|00000dc0| 00 2c 72 65 66 5f 63 75 | 73 74 5f 72 65 6c 61 74 |.,ref_cu|st_relat|
|00000dd0| 69 6f 6e 73 68 69 70 5f | 63 6f 64 65 2e 74 61 62 |ionship_|code.tab|
|00000de0| 00 00 01 d8 00 0e b0 53 | 00 00 02 24 00 24 72 65 |.......S|...$.$re|
|00000df0| 66 5f 63 75 73 74 6f 6d | 65 72 5f 63 61 74 65 67 |f_custom|er_categ|
|00000e00| 2e 2f 76 32 5f 63 6d 73 | 2f 74 61 62 6c 65 2f 72 |./v2_cms|/table/r|
|00000e10| 65 66 5f 74 61 62 6c 65 | 2f 72 65 66 5f 61 63 63 |ef_table|/ref_acc|
|00000e20| 6f 75 6e 74 5f 73 74 61 | 74 75 73 2e 74 61 62 00 |ount_sta|tus.tab.|
|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 30 31 30 30 | 36 36 34 00 30 30 30 30 |....0100|664.0000|
|00000e70| 30 31 33 00 30 30 31 33 | 35 36 33 00 30 30 30 30 |013.0013|563.0000|
|00000e80| 30 30 30 30 34 34 37 00 | 30 35 37 30 33 30 34 33 |0000447.|05703043|
|00000e90| 37 34 37 00 30 30 32 32 | 36 36 32 00 30 00 00 00 |747.0022|662.0...|
|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 75 73 74 61 72 00 30 | 30 73 79 62 61 73 65 00 |.ustar.0|0sybase.|
|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 73 79 62 61 73 65 00 |........|.sybase.|
|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 30 30 30 30 30 34 30 |........|.0000040|
|00000f50| 00 30 30 30 30 32 30 30 | 00 00 00 00 00 00 00 00 |.0000200|........|
|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| 2f 2a 20 53 43 43 53 20 | 49 6e 66 6f 72 6d 61 74 |/* SCCS |Informat|
|00001010| 69 6f 6e 3a 09 25 57 25 | 20 25 47 25 20 2a 2f 0a |ion:.%W%| %G% */.|
|00001020| 0a 75 73 65 20 76 32 5f | 63 6d 73 0a 67 6f 0a 0a |.use v2_|cms.go..|
|00001030| 69 66 20 65 78 69 73 74 | 73 20 28 73 65 6c 65 63 |if exist|s (selec|
|00001040| 74 20 2a 20 66 72 6f 6d | 20 73 79 73 6f 62 6a 65 |t * from| sysobje|
|00001050| 63 74 73 20 77 68 65 72 | 65 0a 20 20 20 6e 61 6d |cts wher|e.   nam|
|00001060| 65 20 3d 20 22 72 65 66 | 5f 61 63 63 6f 75 6e 74 |e = "ref|_account|
|00001070| 5f 73 74 61 74 75 73 22 | 20 61 6e 64 20 74 79 70 |_status"| and typ|
|00001080| 65 20 3d 20 22 55 22 29 | 0a 20 20 44 52 4f 50 20 |e = "U")|.  DROP |
|00001090| 54 41 42 4c 45 20 72 65 | 66 5f 61 63 63 6f 75 6e |TABLE re|f_accoun|
|000010a0| 74 5f 73 74 61 74 75 73 | 0a 67 6f 0a 0a 43 52 45 |t_status|.go..CRE|
|000010b0| 41 54 45 20 54 41 42 4c | 45 20 72 65 66 5f 61 63 |ATE TABL|E ref_ac|
|000010c0| 63 6f 75 6e 74 5f 73 74 | 61 74 75 73 0a 20 20 20 |count_st|atus.   |
|000010d0| 20 20 20 28 63 6f 64 65 | 20 20 20 20 20 20 09 63 |   (code|      .c|
|000010e0| 6f 64 65 20 20 20 20 20 | 20 20 20 4e 4f 54 20 4e |ode     |   NOT N|
|000010f0| 55 4c 4c 2c 0a 20 20 20 | 20 20 20 20 64 65 73 63 |ULL,.   |    desc|
|00001100| 72 69 70 74 69 6f 6e 20 | 20 20 20 20 20 76 61 72 |ription |     var|
|00001110| 63 68 61 72 28 35 30 29 | 20 4e 4f 54 20 4e 55 4c |char(50)| NOT NUL|
|00001120| 4c 0a 29 0a 67 6f 0a 79 | 70 65 2e 74 61 62 00 79 |L.).go.y|pe.tab.y|
|00001130| 00 0e b0 4f 00 00 01 a0 | 00 20 72 65 66 5f 63 6f |...O....|. ref_co|
|00001140| 6e 74 61 63 74 5f 74 79 | 70 65 2e 74 61 62 00 79 |ntact_ty|pe.tab.y|
|00001150| 00 0e b0 50 00 00 01 c0 | 00 24 72 65 66 5f 63 72 |...P....|.$ref_cr|
|00001160| 65 64 69 74 5f 72 65 66 | 5f 74 79 70 65 2e 74 61 |edit_ref|_type.ta|
|00001170| 62 00 2e 74 00 0e b0 51 | 00 00 01 d8 00 1c 72 65 |b..t...Q|......re|
|00001180| 66 5f 69 64 5f 74 79 70 | 65 2e 74 61 62 00 65 66 |f_id_typ|e.tab.ef|
|00001190| 00 0e b0 52 00 00 02 00 | 00 2c 72 65 66 5f 63 75 |...R....|.,ref_cu|
|000011a0| 73 74 5f 72 65 6c 61 74 | 69 6f 6e 73 68 69 70 5f |st_relat|ionship_|
|000011b0| 63 6f 64 65 2e 74 61 62 | 00 0e b0 52 00 0e b0 53 |code.tab|...R...S|
|000011c0| 00 00 02 24 00 24 72 65 | 66 5f 63 75 73 74 6f 6d |...$.$re|f_custom|
|000011d0| 65 72 5f 63 61 74 65 67 | 6f 72 79 2e 74 61 62 00 |er_categ|ory.tab.|
|000011e0| 00 0e b0 54 00 00 02 44 | 00 24 72 65 66 5f 72 65 |...T...D|.$ref_re|
|000011f0| 63 6f 6d 6d 65 63 74 5f | 74 79 70 65 2e 74 61 62 |commect_|type.tab|
|00001200| 2e 2f 76 32 5f 63 6d 73 | 2f 74 61 62 6c 65 2f 72 |./v2_cms|/table/r|
|00001210| 65 66 5f 74 61 62 6c 65 | 2f 72 65 66 5f 61 63 74 |ef_table|/ref_act|
|00001220| 69 6f 6e 2e 74 61 62 00 | 00 00 00 00 00 00 00 00 |ion.tab.|........|
|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 30 31 30 30 | 36 36 34 00 30 30 30 30 |....0100|664.0000|
|00001270| 30 31 33 00 30 30 31 33 | 35 36 33 00 30 30 30 30 |013.0013|563.0000|
|00001280| 30 30 30 30 34 31 34 00 | 30 35 37 30 33 30 34 33 |0000414.|05703043|
|00001290| 37 34 37 00 30 30 32 31 | 30 37 32 00 30 00 00 00 |747.0021|072.0...|
|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 75 73 74 61 72 00 30 | 30 73 79 62 61 73 65 00 |.ustar.0|0sybase.|
|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 73 79 62 61 73 65 00 |........|.sybase.|
|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 30 30 30 30 30 34 30 |........|.0000040|
|00001350| 00 30 30 30 30 32 30 30 | 00 00 00 00 00 00 00 00 |.0000200|........|
|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| 2f 2a 20 53 43 43 53 20 | 49 6e 66 6f 72 6d 61 74 |/* SCCS |Informat|
|00001410| 69 6f 6e 3a 09 25 57 25 | 20 25 47 25 20 2a 2f 0a |ion:.%W%| %G% */.|
|00001420| 0a 75 73 65 20 76 32 5f | 63 6d 73 20 0a 67 6f 0a |.use v2_|cms .go.|
|00001430| 0a 69 66 20 65 78 69 73 | 74 73 20 28 73 65 6c 65 |.if exis|ts (sele|
|00001440| 63 74 20 2a 20 66 72 6f | 6d 20 73 79 73 6f 62 6a |ct * fro|m sysobj|
|00001450| 65 63 74 73 20 77 68 65 | 72 65 0a 20 20 20 6e 61 |ects whe|re.   na|
|00001460| 6d 65 20 3d 20 22 72 65 | 66 5f 61 63 74 69 6f 6e |me = "re|f_action|
|00001470| 22 20 61 6e 64 20 74 79 | 70 65 20 3d 20 22 55 22 |" and ty|pe = "U"|
|00001480| 29 0a 20 20 44 52 4f 50 | 20 54 41 42 4c 45 20 72 |).  DROP| TABLE r|
|00001490| 65 66 5f 61 63 74 69 6f | 6e 0a 67 6f 0a 0a 43 52 |ef_actio|n.go..CR|
|000014a0| 45 41 54 45 20 54 41 42 | 4c 45 20 72 65 66 5f 61 |EATE TAB|LE ref_a|
|000014b0| 63 74 69 6f 6e 0a 20 20 | 20 20 20 20 28 63 6f 64 |ction.  |    (cod|
|000014c0| 65 20 20 20 20 20 20 09 | 63 6f 64 65 20 20 20 20 |e      .|code    |
|000014d0| 4e 4f 54 20 4e 55 4c 4c | 2c 0a 20 20 20 20 20 20 |NOT NULL|,.      |
|000014e0| 20 64 65 73 63 72 69 70 | 74 69 6f 6e 20 20 20 20 | descrip|tion    |
|000014f0| 20 20 76 61 72 63 68 61 | 72 28 35 30 29 20 4e 4f |  varcha|r(50) NO|
|00001500| 54 20 4e 55 4c 4c 0a 29 | 0a 67 6f 0a 00 0e b0 4f |T NULL.)|.go....O|
|00001510| 00 00 01 a0 00 20 72 65 | 66 5f 63 6f 6e 74 61 63 |..... re|f_contac|
|00001520| 74 5f 74 79 70 65 2e 74 | 61 62 00 74 00 0e b0 50 |t_type.t|ab.t...P|
|00001530| 00 00 01 c0 00 24 72 65 | 66 5f 63 72 65 64 69 74 |.....$re|f_credit|
|00001540| 5f 72 65 66 5f 74 79 70 | 65 2e 74 61 62 00 00 79 |_ref_typ|e.tab..y|
|00001550| 00 0e b0 51 00 00 01 d8 | 00 1c 72 65 66 5f 69 64 |...Q....|..ref_id|
|00001560| 5f 74 79 70 65 2e 74 61 | 62 00 79 70 00 0e b0 52 |_type.ta|b.yp...R|
|00001570| 00 00 02 00 00 2c 72 65 | 66 5f 63 75 73 74 5f 72 |.....,re|f_cust_r|
|00001580| 65 6c 61 74 69 6f 6e 73 | 68 69 70 5f 63 6f 64 65 |elations|hip_code|
|00001590| 2e 74 61 62 00 00 02 00 | 00 0e b0 53 00 00 02 24 |.tab....|...S...$|
|000015a0| 00 24 72 65 66 5f 63 75 | 73 74 6f 6d 65 72 5f 63 |.$ref_cu|stomer_c|
|000015b0| 61 74 65 67 6f 72 79 2e | 74 61 62 00 00 0e b0 54 |ategory.|tab....T|
|000015c0| 00 00 02 44 00 24 72 65 | 66 5f 72 65 63 6f 6d 6d |...D.$re|f_recomm|
|000015d0| 65 63 74 5f 74 79 70 65 | 2e 74 61 62 00 61 62 00 |ect_type|.tab.ab.|
|000015e0| 00 0e b0 55 00 00 02 64 | 00 20 72 65 66 5f 70 75 |...U...d|. ref_pu|
|000015f0| 62 6c 69 73 68 5f 63 6f | 64 65 2e 74 61 62 00 62 |blish_co|de.tab.b|
|00001600| 2e 2f 76 32 5f 63 6d 73 | 2f 74 61 62 6c 65 2f 72 |./v2_cms|/table/r|
|00001610| 65 66 5f 74 61 62 6c 65 | 2f 72 65 66 5f 61 73 73 |ef_table|/ref_ass|
|00001620| 6f 63 5f 6e 75 6d 5f 74 | 79 70 65 2e 74 61 62 00 |oc_num_t|ype.tab.|
|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 30 31 30 30 | 36 36 34 00 30 30 30 30 |....0100|664.0000|
|00001670| 30 31 33 00 30 30 31 33 | 35 36 33 00 30 30 30 30 |013.0013|563.0000|
|00001680| 30 30 30 30 34 34 34 00 | 30 35 37 30 33 30 34 33 |0000444.|05703043|
|00001690| 37 35 30 00 30 30 32 32 | 36 34 32 00 30 00 00 00 |750.0022|642.0...|
|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 75 73 74 61 72 00 30 | 30 73 79 62 61 73 65 00 |.ustar.0|0sybase.|
|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 73 79 62 61 73 65 00 |........|.sybase.|
|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 30 30 30 30 30 34 30 |........|.0000040|
|00001750| 00 30 30 30 30 32 30 30 | 00 00 00 00 00 00 00 00 |.0000200|........|
|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| 2f 2a 20 53 43 43 53 20 | 49 6e 66 6f 72 6d 61 74 |/* SCCS |Informat|
|00001810| 69 6f 6e 3a 09 25 57 25 | 20 25 47 25 20 2a 2f 0a |ion:.%W%| %G% */.|
|00001820| 0a 75 73 65 20 76 32 5f | 63 6d 73 20 0a 67 6f 0a |.use v2_|cms .go.|
|00001830| 0a 69 66 20 65 78 69 73 | 74 73 20 28 73 65 6c 65 |.if exis|ts (sele|
|00001840| 63 74 20 2a 20 66 72 6f | 6d 20 73 79 73 6f 62 6a |ct * fro|m sysobj|
|00001850| 65 63 74 73 20 77 68 65 | 72 65 0a 20 20 20 6e 61 |ects whe|re.   na|
|00001860| 6d 65 20 3d 20 22 72 65 | 66 5f 61 73 73 6f 63 5f |me = "re|f_assoc_|
|00001870| 6e 75 6d 5f 74 79 70 65 | 22 20 61 6e 64 20 74 79 |num_type|" and ty|
|00001880| 70 65 20 3d 20 22 55 22 | 29 0a 20 20 44 52 4f 50 |pe = "U"|).  DROP|
|00001890| 20 54 41 42 4c 45 20 72 | 65 66 5f 61 73 73 6f 63 | TABLE r|ef_assoc|
|000018a0| 5f 6e 75 6d 5f 74 79 70 | 65 0a 67 6f 0a 0a 43 52 |_num_typ|e.go..CR|
|000018b0| 45 41 54 45 20 54 41 42 | 4c 45 20 72 65 66 5f 61 |EATE TAB|LE ref_a|
|000018c0| 73 73 6f 63 5f 6e 75 6d | 5f 74 79 70 65 0a 20 20 |ssoc_num|_type.  |
|000018d0| 20 20 20 20 28 63 6f 64 | 65 20 20 20 20 20 20 09 |    (cod|e      .|
|000018e0| 63 6f 64 65 20 20 20 20 | 4e 4f 54 20 4e 55 4c 4c |code    |NOT NULL|
|000018f0| 2c 0a 20 20 20 20 20 20 | 20 64 65 73 63 72 69 70 |,.      | descrip|
|00001900| 74 69 6f 6e 20 20 20 20 | 20 20 76 61 72 63 68 61 |tion    |  varcha|
|00001910| 72 28 35 30 29 20 4e 4f | 54 20 4e 55 4c 4c 0a 29 |r(50) NO|T NULL.)|
|00001920| 0a 67 6f 0a 5f 72 65 66 | 5f 74 79 70 65 2e 74 61 |.go._ref|_type.ta|
|00001930| 62 00 01 c0 00 0e b0 51 | 00 00 01 d8 00 1c 72 65 |b......Q|......re|
|00001940| 66 5f 69 64 5f 74 79 70 | 65 2e 74 61 62 00 00 79 |f_id_typ|e.tab..y|
|00001950| 00 0e b0 52 00 00 02 00 | 00 2c 72 65 66 5f 63 75 |...R....|.,ref_cu|
|00001960| 73 74 5f 72 65 6c 61 74 | 69 6f 6e 73 68 69 70 5f |st_relat|ionship_|
|00001970| 63 6f 64 65 2e 74 61 62 | 00 5f 63 75 00 0e b0 53 |code.tab|._cu...S|
|00001980| 00 00 02 24 00 24 72 65 | 66 5f 63 75 73 74 6f 6d |...$.$re|f_custom|
|00001990| 65 72 5f 63 61 74 65 67 | 6f 72 79 2e 74 61 62 00 |er_categ|ory.tab.|
|000019a0| 00 0e b0 54 00 00 02 44 | 00 24 72 65 66 5f 72 65 |...T...D|.$ref_re|
|000019b0| 63 6f 6d 6d 65 63 74 5f | 74 79 70 65 2e 74 61 62 |commect_|type.tab|
|000019c0| 00 00 02 44 00 0e b0 55 | 00 00 02 64 00 20 72 65 |...D...U|...d. re|
|000019d0| 66 5f 70 75 62 6c 69 73 | 68 5f 63 6f 64 65 2e 74 |f_publis|h_code.t|
|000019e0| 61 62 00 55 00 0e b0 56 | 00 00 02 80 00 1c 72 65 |ab.U...V|......re|
|000019f0| 66 5f 6f 72 67 5f 74 79 | 70 65 2e 74 61 62 00 62 |f_org_ty|pe.tab.b|
|00001a00| 2e 2f 76 32 5f 63 6d 73 | 2f 74 61 62 6c 65 2f 72 |./v2_cms|/table/r|
|00001a10| 65 66 5f 74 61 62 6c 65 | 2f 72 65 66 5f 62 69 6c |ef_table|/ref_bil|
|00001a20| 6c 69 6e 67 5f 74 79 70 | 65 2e 74 61 62 00 00 00 |ling_typ|e.tab...|
|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 30 31 30 30 | 36 36 34 00 30 30 30 30 |....0100|664.0000|
|00001a70| 30 31 33 00 30 30 31 33 | 35 36 33 00 30 30 30 30 |013.0013|563.0000|
|00001a80| 30 30 30 30 34 32 30 00 | 30 35 37 30 33 30 34 33 |0000420.|05703043|
|00001a90| 37 35 30 00 30 30 32 32 | 32 36 35 00 30 00 00 00 |750.0022|265.0...|
|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 75 73 74 61 72 00 30 | 30 73 79 62 61 73 65 00 |.ustar.0|0sybase.|
|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 73 79 62 61 73 65 00 |........|.sybase.|
|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 30 30 30 30 30 34 30 |........|.0000040|
|00001b50| 00 30 30 30 30 32 30 30 | 00 00 00 00 00 00 00 00 |.0000200|........|
|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| 2f 2a 20 53 43 43 53 20 | 49 6e 66 6f 72 6d 61 74 |/* SCCS |Informat|
|00001c10| 69 6f 6e 3a 09 25 57 25 | 20 25 47 25 20 2a 2f 0a |ion:.%W%| %G% */.|
|00001c20| 0a 75 73 65 20 76 32 5f | 63 6d 73 20 0a 67 6f 0a |.use v2_|cms .go.|
|00001c30| 0a 69 66 20 65 78 69 73 | 74 73 20 28 73 65 6c 65 |.if exis|ts (sele|
|00001c40| 63 74 20 31 20 66 72 6f | 6d 20 73 79 73 6f 62 6a |ct 1 fro|m sysobj|
|00001c50| 65 63 74 73 0a 09 09 77 | 68 65 72 65 20 6e 61 6d |ects...w|here nam|
|00001c60| 65 20 3d 20 22 72 65 66 | 5f 62 69 6c 6c 69 6e 67 |e = "ref|_billing|
|00001c70| 5f 74 79 70 65 22 20 61 | 6e 64 0a 09 09 20 20 20 |_type" a|nd...   |
|00001c80| 20 20 20 74 79 70 65 20 | 3d 20 22 55 22 29 0a 09 |   type |= "U")..|
|00001c90| 64 72 6f 70 20 74 61 62 | 6c 65 20 72 65 66 5f 62 |drop tab|le ref_b|
|00001ca0| 69 6c 6c 69 6e 67 5f 74 | 79 70 65 0a 0a 67 6f 0a |illing_t|ype..go.|
|00001cb0| 0a 63 72 65 61 74 65 20 | 74 61 62 6c 65 20 72 65 |.create |table re|
|00001cc0| 66 5f 62 69 6c 6c 69 6e | 67 5f 74 79 70 65 20 28 |f_billin|g_type (|
|00001cd0| 0a 09 74 79 70 65 09 09 | 63 6f 64 65 09 09 4e 4f |..type..|code..NO|
|00001ce0| 54 20 4e 55 4c 4c 2c 0a | 09 64 65 73 63 72 69 70 |T NULL,.|.descrip|
|00001cf0| 74 69 6f 6e 09 76 61 72 | 63 68 61 72 28 35 30 29 |tion.var|char(50)|
|00001d00| 09 4e 4f 54 20 4e 55 4c | 4c 0a 29 0a 0a 67 6f 0a |.NOT NUL|L.)..go.|
|00001d10| 00 0e b0 51 00 00 01 d8 | 00 1c 72 65 66 5f 69 64 |...Q....|..ref_id|
|00001d20| 5f 74 79 70 65 2e 74 61 | 62 00 79 70 00 0e b0 52 |_type.ta|b.yp...R|
|00001d30| 00 00 02 00 00 2c 72 65 | 66 5f 63 75 73 74 5f 72 |.....,re|f_cust_r|
|00001d40| 65 6c 61 74 69 6f 6e 73 | 68 69 70 5f 63 6f 64 65 |elations|hip_code|
|00001d50| 2e 74 61 62 00 00 02 00 | 00 0e b0 53 00 00 02 24 |.tab....|...S...$|
|00001d60| 00 24 72 65 66 5f 63 75 | 73 74 6f 6d 65 72 5f 63 |.$ref_cu|stomer_c|
|00001d70| 61 74 65 67 6f 72 79 2e | 74 61 62 00 00 0e b0 54 |ategory.|tab....T|
|00001d80| 00 00 02 44 00 24 72 65 | 66 5f 72 65 63 6f 6d 6d |...D.$re|f_recomm|
|00001d90| 65 63 74 5f 74 79 70 65 | 2e 74 61 62 00 61 62 00 |ect_type|.tab.ab.|
|00001da0| 00 0e b0 55 00 00 02 64 | 00 20 72 65 66 5f 70 75 |...U...d|. ref_pu|
|00001db0| 62 6c 69 73 68 5f 63 6f | 64 65 2e 74 61 62 00 62 |blish_co|de.tab.b|
|00001dc0| 00 0e b0 56 00 00 02 80 | 00 1c 72 65 66 5f 6f 72 |...V....|..ref_or|
|00001dd0| 67 5f 74 79 70 65 2e 74 | 61 62 00 6f 00 0e b0 57 |g_type.t|ab.o...W|
|00001de0| 00 00 02 a0 00 24 72 65 | 66 5f 64 65 66 61 75 6c |.....$re|f_defaul|
|00001df0| 74 5f 73 74 61 74 75 73 | 2e 74 61 62 00 62 00 62 |t_status|.tab.b.b|
|00001e00| 2e 2f 76 32 5f 63 6d 73 | 2f 74 61 62 6c 65 2f 72 |./v2_cms|/table/r|
|00001e10| 65 66 5f 74 61 62 6c 65 | 2f 72 65 66 5f 63 61 72 |ef_table|/ref_car|
|00001e20| 64 5f 74 79 70 65 2e 74 | 61 62 00 00 00 00 00 00 |d_type.t|ab......|
|00001e30| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001e40| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001e50| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001e60| 00 00 00 00 30 31 30 30 | 36 36 34 00 30 30 30 30 |....0100|664.0000|
|00001e70| 30 31 33 00 30 30 31 33 | 35 36 33 00 30 30 30 30 |013.0013|563.0000|
|00001e80| 30 30 30 30 34 30 37 00 | 30 35 37 30 33 30 34 33 |0000407.|05703043|
|00001e90| 37 35 30 00 30 30 32 31 | 35 36 33 00 30 00 00 00 |750.0021|563.0...|
|00001ea0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001eb0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001ec0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001ed0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001ee0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001ef0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001f00| 00 75 73 74 61 72 00 30 | 30 73 79 62 61 73 65 00 |.ustar.0|0sybase.|
|00001f10| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001f20| 00 00 00 00 00 00 00 00 | 00 73 79 62 61 73 65 00 |........|.sybase.|
|00001f30| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001f40| 00 00 00 00 00 00 00 00 | 00 30 30 30 30 30 34 30 |........|.0000040|
|00001f50| 00 30 30 30 30 32 30 30 | 00 00 00 00 00 00 00 00 |.0000200|........|
|00001f60| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001f70| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001f80| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001f90| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001fa0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001fb0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001fc0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001fd0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001fe0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001ff0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002000| 2f 2a 20 53 43 43 53 20 | 49 6e 66 6f 72 6d 61 74 |/* SCCS |Informat|
|00002010| 69 6f 6e 3a 09 25 57 25 | 20 25 47 25 20 2a 2f 0a |ion:.%W%| %G% */.|
|00002020| 0a 75 73 65 20 76 32 5f | 63 6d 73 20 0a 67 6f 0a |.use v2_|cms .go.|
|00002030| 0a 69 66 20 65 78 69 73 | 74 73 20 28 73 65 6c 65 |.if exis|ts (sele|
|00002040| 63 74 20 31 20 66 72 6f | 6d 20 73 79 73 6f 62 6a |ct 1 fro|m sysobj|
|00002050| 65 63 74 73 0a 09 09 77 | 68 65 72 65 20 6e 61 6d |ects...w|here nam|
|00002060| 65 20 3d 20 22 72 65 66 | 5f 63 61 72 64 5f 74 79 |e = "ref|_card_ty|
|00002070| 70 65 22 20 61 6e 64 0a | 09 09 20 20 20 20 20 20 |pe" and.|..      |
|00002080| 74 79 70 65 20 3d 20 22 | 55 22 29 0a 09 64 72 6f |type = "|U")..dro|
|00002090| 70 20 74 61 62 6c 65 20 | 72 65 66 5f 63 61 72 64 |p table |ref_card|
|000020a0| 5f 74 79 70 65 0a 0a 67 | 6f 0a 0a 63 72 65 61 74 |_type..g|o..creat|
|000020b0| 65 20 74 61 62 6c 65 20 | 72 65 66 5f 63 61 72 64 |e table |ref_card|
|000020c0| 5f 74 79 70 65 20 28 0a | 09 74 79 70 65 09 09 63 |_type (.|.type..c|
|000020d0| 6f 64 65 09 09 4e 4f 54 | 20 4e 55 4c 4c 2c 0a 09 |ode..NOT| NULL,..|
|000020e0| 64 65 73 63 72 69 70 74 | 69 6f 6e 09 76 61 72 63 |descript|ion.varc|
|000020f0| 68 61 72 28 35 30 29 09 | 4e 4f 54 20 4e 55 4c 4c |har(50).|NOT NULL|
|00002100| 0a 29 0a 0a 67 6f 0a 61 | 62 00 74 61 00 0e b0 52 |.)..go.a|b.ta...R|
|00002110| 00 00 02 00 00 2c 72 65 | 66 5f 63 75 73 74 5f 72 |.....,re|f_cust_r|
|00002120| 65 6c 61 74 69 6f 6e 73 | 68 69 70 5f 63 6f 64 65 |elations|hip_code|
|00002130| 2e 74 61 62 00 2c 72 65 | 00 0e b0 53 00 00 02 24 |.tab.,re|...S...$|
|00002140| 00 24 72 65 66 5f 63 75 | 73 74 6f 6d 65 72 5f 63 |.$ref_cu|stomer_c|
|00002150| 61 74 65 67 6f 72 79 2e | 74 61 62 00 00 0e b0 54 |ategory.|tab....T|
|00002160| 00 00 02 44 00 24 72 65 | 66 5f 72 65 63 6f 6d 6d |...D.$re|f_recomm|
|00002170| 65 63 74 5f 74 79 70 65 | 2e 74 61 62 00 0e b0 54 |ect_type|.tab...T|
|00002180| 00 0e b0 55 00 00 02 64 | 00 20 72 65 66 5f 70 75 |...U...d|. ref_pu|
|00002190| 62 6c 69 73 68 5f 63 6f | 64 65 2e 74 61 62 00 00 |blish_co|de.tab..|
|000021a0| 00 0e b0 56 00 00 02 80 | 00 1c 72 65 66 5f 6f 72 |...V....|..ref_or|
|000021b0| 67 5f 74 79 70 65 2e 74 | 61 62 00 74 00 0e b0 57 |g_type.t|ab.t...W|
|000021c0| 00 00 02 a0 00 24 72 65 | 66 5f 64 65 66 61 75 6c |.....$re|f_defaul|
|000021d0| 74 5f 73 74 61 74 75 73 | 2e 74 61 62 00 0e b0 57 |t_status|.tab...W|
|000021e0| 00 0e b0 58 00 00 02 c0 | 00 20 72 65 66 5f 61 64 |...X....|. ref_ad|
|000021f0| 64 72 65 73 73 5f 74 79 | 70 65 2e 74 61 62 00 62 |dress_ty|pe.tab.b|
|00002200| 2e 2f 76 32 5f 63 6d 73 | 2f 74 61 62 6c 65 2f 72 |./v2_cms|/table/r|
|00002210| 65 66 5f 74 61 62 6c 65 | 2f 72 65 66 5f 63 68 61 |ef_table|/ref_cha|
|00002220| 72 67 65 5f 74 79 70 65 | 2e 74 61 62 00 00 00 00 |rge_type|.tab....|
|00002230| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002240| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002250| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002260| 00 00 00 00 30 31 30 30 | 36 36 34 00 30 30 30 30 |....0100|664.0000|
|00002270| 30 31 33 00 30 30 31 33 | 35 36 33 00 30 30 30 30 |013.0013|563.0000|
|00002280| 30 30 30 30 34 35 36 00 | 30 35 37 30 33 30 34 33 |0000456.|05703043|
|00002290| 37 35 31 00 30 30 32 32 | 31 31 30 00 30 00 00 00 |751.0022|110.0...|
|000022a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000022b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000022c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000022d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000022e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000022f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002300| 00 75 73 74 61 72 00 30 | 30 73 79 62 61 73 65 00 |.ustar.0|0sybase.|
|00002310| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002320| 00 00 00 00 00 00 00 00 | 00 73 79 62 61 73 65 00 |........|.sybase.|
|00002330| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002340| 00 00 00 00 00 00 00 00 | 00 30 30 30 30 30 34 30 |........|.0000040|
|00002350| 00 30 30 30 30 32 30 30 | 00 00 00 00 00 00 00 00 |.0000200|........|
|00002360| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002370| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002380| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002390| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000023a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000023b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000023c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000023d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000023e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000023f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002400| 2f 2a 20 53 43 43 53 20 | 49 6e 66 6f 72 6d 61 74 |/* SCCS |Informat|
|00002410| 69 6f 6e 3a 09 25 57 25 | 20 25 47 25 20 2a 2f 0a |ion:.%W%| %G% */.|
|00002420| 0a 75 73 65 20 76 32 5f | 63 6d 73 20 0a 67 6f 0a |.use v2_|cms .go.|
|00002430| 0a 69 66 20 65 78 69 73 | 74 73 20 28 73 65 6c 65 |.if exis|ts (sele|
|00002440| 63 74 20 31 20 66 72 6f | 6d 20 73 79 73 6f 62 6a |ct 1 fro|m sysobj|
|00002450| 65 63 74 73 0a 09 09 77 | 68 65 72 65 20 6e 61 6d |ects...w|here nam|
|00002460| 65 20 3d 20 22 72 65 66 | 5f 63 68 61 72 67 65 5f |e = "ref|_charge_|
|00002470| 74 79 70 65 22 20 61 6e | 64 0a 09 09 20 20 20 20 |type" an|d...    |
|00002480| 20 20 74 79 70 65 20 3d | 20 22 55 22 29 0a 09 64 |  type =| "U")..d|
|00002490| 72 6f 70 20 74 61 62 6c | 65 20 72 65 66 5f 63 68 |rop tabl|e ref_ch|
|000024a0| 61 72 67 65 5f 74 79 70 | 65 0a 0a 67 6f 0a 0a 63 |arge_typ|e..go..c|
|000024b0| 72 65 61 74 65 20 74 61 | 62 6c 65 20 72 65 66 5f |reate ta|ble ref_|
|000024c0| 63 68 61 72 67 65 5f 74 | 79 70 65 20 28 0a 09 74 |charge_t|ype (..t|
|000024d0| 79 70 65 09 09 63 6f 64 | 65 09 09 4e 4f 54 20 4e |ype..cod|e..NOT N|
|000024e0| 55 4c 4c 2c 0a 09 6f 6e | 65 5f 74 69 6d 65 5f 63 |ULL,..on|e_time_c|
|000024f0| 68 61 72 67 65 20 62 6f | 6f 6c 09 09 4e 4f 54 20 |harge bo|ol..NOT |
|00002500| 4e 55 4c 4c 2c 0a 09 64 | 65 73 63 72 69 70 74 69 |NULL,..d|escripti|
|00002510| 6f 6e 09 76 61 72 63 68 | 61 72 28 35 30 29 09 4e |on.varch|ar(50).N|
|00002520| 4f 54 20 4e 55 4c 4c 0a | 29 0a 0a 67 6f 0a 6f 6d |OT NULL.|)..go.om|
|00002530| 65 72 5f 63 61 74 65 67 | 6f 72 79 2e 74 61 62 00 |er_categ|ory.tab.|
|00002540| 00 0e b0 54 00 00 02 44 | 00 24 72 65 66 5f 72 65 |...T...D|.$ref_re|
|00002550| 63 6f 6d 6d 65 63 74 5f | 74 79 70 65 2e 74 61 62 |commect_|type.tab|
|00002560| 00 00 02 44 00 0e b0 55 | 00 00 02 64 00 20 72 65 |...D...U|...d. re|
|00002570| 66 5f 70 75 62 6c 69 73 | 68 5f 63 6f 64 65 2e 74 |f_publis|h_code.t|
|00002580| 61 62 00 55 00 0e b0 56 | 00 00 02 80 00 1c 72 65 |ab.U...V|......re|
|00002590| 66 5f 6f 72 67 5f 74 79 | 70 65 2e 74 61 62 00 00 |f_org_ty|pe.tab..|
|000025a0| 00 0e b0 57 00 00 02 a0 | 00 24 72 65 66 5f 64 65 |...W....|.$ref_de|
|000025b0| 66 61 75 6c 74 5f 73 74 | 61 74 75 73 2e 74 61 62 |fault_st|atus.tab|
|000025c0| 00 00 02 a0 00 0e b0 58 | 00 00 02 c0 00 20 72 65 |.......X|..... re|
|000025d0| 66 5f 61 64 64 72 65 73 | 73 5f 74 79 70 65 2e 74 |f_addres|s_type.t|
|000025e0| 61 62 00 58 00 0e b0 59 | 00 00 02 e0 00 24 72 65 |ab.X...Y|.....$re|
|000025f0| 66 5f 65 6d 70 6c 6f 79 | 6d 65 6e 74 5f 74 79 70 |f_employ|ment_typ|
|00002600| 2e 2f 76 32 5f 63 6d 73 | 2f 74 61 62 6c 65 2f 72 |./v2_cms|/table/r|
|00002610| 65 66 5f 74 61 62 6c 65 | 2f 72 65 66 5f 63 6f 6d |ef_table|/ref_com|
|00002620| 6d 65 6e 74 5f 74 79 70 | 65 2e 74 61 62 00 00 00 |ment_typ|e.tab...|
|00002630| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002640| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002650| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002660| 00 00 00 00 30 31 30 30 | 36 36 34 00 30 30 30 30 |....0100|664.0000|
|00002670| 30 31 33 00 30 30 31 33 | 35 36 33 00 30 30 30 30 |013.0013|563.0000|
|00002680| 30 30 30 30 34 34 32 00 | 30 35 37 30 33 30 34 33 |0000442.|05703043|
|00002690| 37 35 31 00 30 30 32 32 | 33 31 34 00 30 00 00 00 |751.0022|314.0...|
|000026a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000026b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000026c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000026d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000026e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000026f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002700| 00 75 73 74 61 72 00 30 | 30 73 79 62 61 73 65 00 |.ustar.0|0sybase.|
|00002710| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002720| 00 00 00 00 00 00 00 00 | 00 73 79 62 61 73 65 00 |........|.sybase.|
|00002730| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002740| 00 00 00 00 00 00 00 00 | 00 30 30 30 30 30 34 30 |........|.0000040|
|00002750| 00 30 30 30 30 32 30 30 | 00 00 00 00 00 00 00 00 |.0000200|........|
|00002760| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002770| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002780| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002790| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000027a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000027b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000027c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000027d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000027e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000027f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002800| 2f 2a 20 53 43 43 53 20 | 49 6e 66 6f 72 6d 61 74 |/* SCCS |Informat|
|00002810| 69 6f 6e 3a 09 25 57 25 | 20 25 47 25 20 2a 2f 0a |ion:.%W%| %G% */.|
|00002820| 0a 75 73 65 20 76 32 5f | 63 6d 73 20 0a 67 6f 0a |.use v2_|cms .go.|
|00002830| 0a 69 66 20 65 78 69 73 | 74 73 20 28 73 65 6c 65 |.if exis|ts (sele|
|00002840| 63 74 20 2a 20 66 72 6f | 6d 20 73 79 73 6f 62 6a |ct * fro|m sysobj|
|00002850| 65 63 74 73 20 77 68 65 | 72 65 0a 20 20 20 6e 61 |ects whe|re.   na|
|00002860| 6d 65 20 3d 20 22 72 65 | 66 5f 63 6f 6d 6d 65 6e |me = "re|f_commen|
|00002870| 74 5f 74 79 70 65 22 20 | 61 6e 64 20 74 79 70 65 |t_type" |and type|
|00002880| 20 3d 20 22 55 22 29 0a | 20 20 44 52 4f 50 20 54 | = "U").|  DROP T|
|00002890| 41 42 4c 45 20 72 65 66 | 5f 63 6f 6d 6d 65 6e 74 |ABLE ref|_comment|
|000028a0| 5f 74 79 70 65 0a 67 6f | 0a 0a 43 52 45 41 54 45 |_type.go|..CREATE|
|000028b0| 20 54 41 42 4c 45 20 72 | 65 66 5f 63 6f 6d 6d 65 | TABLE r|ef_comme|
|000028c0| 6e 74 5f 74 79 70 65 0a | 20 20 20 20 20 20 28 63 |nt_type.|      (c|
|000028d0| 6f 64 65 20 20 20 20 20 | 20 09 63 6f 64 65 20 20 |ode     | .code  |
|000028e0| 20 20 20 20 20 20 4e 4f | 54 20 4e 55 4c 4c 2c 0a |      NO|T NULL,.|
|000028f0| 20 20 20 20 20 20 20 64 | 65 73 63 72 69 70 74 69 |       d|escripti|
|00002900| 6f 6e 20 20 20 20 20 20 | 76 61 72 63 68 61 72 28 |on      |varchar(|
|00002910| 35 30 29 20 4e 4f 54 20 | 4e 55 4c 4c 0a 29 0a 67 |50) NOT |NULL.).g|
|00002920| 6f 0a b0 54 00 00 02 44 | 00 24 72 65 66 5f 72 65 |o..T...D|.$ref_re|
|00002930| 63 6f 6d 6d 65 63 74 5f | 74 79 70 65 2e 74 61 62 |commect_|type.tab|
|00002940| 00 0e b0 54 00 0e b0 55 | 00 00 02 64 00 20 72 65 |...T...U|...d. re|
|00002950| 66 5f 70 75 62 6c 69 73 | 68 5f 63 6f 64 65 2e 74 |f_publis|h_code.t|
|00002960| 61 62 00 44 00 0e b0 56 | 00 00 02 80 00 1c 72 65 |ab.D...V|......re|
|00002970| 66 5f 6f 72 67 5f 74 79 | 70 65 2e 74 61 62 00 74 |f_org_ty|pe.tab.t|
|00002980| 00 0e b0 57 00 00 02 a0 | 00 24 72 65 66 5f 64 65 |...W....|.$ref_de|
|00002990| 66 61 75 6c 74 5f 73 74 | 61 74 75 73 2e 74 61 62 |fault_st|atus.tab|
|000029a0| 00 0e b0 57 00 0e b0 58 | 00 00 02 c0 00 20 72 65 |...W...X|..... re|
|000029b0| 66 5f 61 64 64 72 65 73 | 73 5f 74 79 70 65 2e 74 |f_addres|s_type.t|
|000029c0| 61 62 00 a0 00 0e b0 59 | 00 00 02 e0 00 24 72 65 |ab.....Y|.....$re|
|000029d0| 66 5f 65 6d 70 6c 6f 79 | 6d 65 6e 74 5f 74 79 70 |f_employ|ment_typ|
|000029e0| 65 2e 74 61 62 00 b0 59 | 00 0e b0 5a 00 00 02 fc |e.tab..Y|...Z....|
|000029f0| 00 20 72 65 66 5f 67 65 | 6e 64 65 72 5f 74 79 70 |. ref_ge|nder_typ|
|00002a00| 2e 2f 76 32 5f 63 6d 73 | 2f 74 61 62 6c 65 2f 72 |./v2_cms|/table/r|
|00002a10| 65 66 5f 74 61 62 6c 65 | 2f 72 65 66 5f 72 65 6c |ef_table|/ref_rel|
|00002a20| 61 74 65 64 5f 74 79 70 | 65 2e 74 61 62 00 00 00 |ated_typ|e.tab...|
|00002a30| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002a40| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002a50| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002a60| 00 00 00 00 30 31 30 30 | 36 36 34 00 30 30 30 30 |....0100|664.0000|
|00002a70| 30 31 33 00 30 30 31 33 | 35 36 33 00 30 30 30 30 |013.0013|563.0000|
|00002a80| 30 30 30 30 34 32 30 00 | 30 35 37 30 33 30 34 33 |0000420.|05703043|
|00002a90| 37 35 36 00 30 30 32 32 | 32 37 33 00 30 00 00 00 |756.0022|273.0...|
|00002aa0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002ab0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002ac0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002ad0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002ae0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002af0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002b00| 00 75 73 74 61 72 00 30 | 30 73 79 62 61 73 65 00 |.ustar.0|0sybase.|
|00002b10| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002b20| 00 00 00 00 00 00 00 00 | 00 73 79 62 61 73 65 00 |........|.sybase.|
|00002b30| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002b40| 00 00 00 00 00 00 00 00 | 00 30 30 30 30 30 34 30 |........|.0000040|
|00002b50| 00 30 30 30 30 32 30 30 | 00 00 00 00 00 00 00 00 |.0000200|........|
|00002b60| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002b70| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002b80| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002b90| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002ba0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002bb0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002bc0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002bd0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002be0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002bf0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002c00| 2f 2a 20 53 43 43 53 20 | 49 6e 66 6f 72 6d 61 74 |/* SCCS |Informat|
|00002c10| 69 6f 6e 3a 09 25 57 25 | 20 25 47 25 20 2a 2f 0a |ion:.%W%| %G% */.|
|00002c20| 0a 75 73 65 20 76 32 5f | 63 6d 73 20 0a 67 6f 0a |.use v2_|cms .go.|
|00002c30| 0a 69 66 20 65 78 69 73 | 74 73 20 28 73 65 6c 65 |.if exis|ts (sele|
|00002c40| 63 74 20 31 20 66 72 6f | 6d 20 73 79 73 6f 62 6a |ct 1 fro|m sysobj|
|00002c50| 65 63 74 73 0a 09 09 77 | 68 65 72 65 20 6e 61 6d |ects...w|here nam|
|00002c60| 65 20 3d 20 22 72 65 66 | 5f 72 65 6c 61 74 65 64 |e = "ref|_related|
|00002c70| 5f 74 79 70 65 22 20 61 | 6e 64 0a 09 09 20 20 20 |_type" a|nd...   |
|00002c80| 20 20 20 74 79 70 65 20 | 3d 20 22 55 22 29 0a 09 |   type |= "U")..|
|00002c90| 64 72 6f 70 20 74 61 62 | 6c 65 20 72 65 66 5f 72 |drop tab|le ref_r|
|00002ca0| 65 6c 61 74 65 64 5f 74 | 79 70 65 0a 0a 67 6f 0a |elated_t|ype..go.|
|00002cb0| 0a 63 72 65 61 74 65 20 | 74 61 62 6c 65 20 72 65 |.create |table re|
|00002cc0| 66 5f 72 65 6c 61 74 65 | 64 5f 74 79 70 65 20 28 |f_relate|d_type (|
|00002cd0| 0a 09 74 79 70 65 09 09 | 63 6f 64 65 09 09 4e 4f |..type..|code..NO|
|00002ce0| 54 20 4e 55 4c 4c 2c 0a | 09 64 65 73 63 72 69 70 |T NULL,.|.descrip|
|00002cf0| 74 69 6f 6e 09 76 61 72 | 63 68 61 72 28 35 30 29 |tion.var|char(50)|
|00002d00| 09 4e 4f 54 20 4e 55 4c | 4c 0a 29 0a 0a 67 6f 0a |.NOT NUL|L.)..go.|
|00002d10| 63 6f 6d 6d 65 63 74 5f | 74 79 70 65 2e 74 61 62 |commect_|type.tab|
|00002d20| 00 0e b0 54 00 0e b0 55 | 00 00 02 64 00 20 72 65 |...T...U|...d. re|
|00002d30| 66 5f 70 75 62 6c 69 73 | 68 5f 63 6f 64 65 2e 74 |f_publis|h_code.t|
|00002d40| 61 62 00 54 00 0e b0 56 | 00 00 02 80 00 1c 72 65 |ab.T...V|......re|
|00002d50| 66 5f 6f 72 67 5f 74 79 | 70 65 2e 74 61 62 00 74 |f_org_ty|pe.tab.t|
|00002d60| 00 0e b0 57 00 00 02 a0 | 00 24 72 65 66 5f 64 65 |...W....|.$ref_de|
|00002d70| 66 61 75 6c 74 5f 73 74 | 61 74 75 73 2e 74 61 62 |fault_st|atus.tab|
|00002d80| 00 0e b0 57 00 0e b0 58 | 00 00 02 c0 00 20 72 65 |...W...X|..... re|
|00002d90| 66 5f 61 64 64 72 65 73 | 73 5f 74 79 70 65 2e 74 |f_addres|s_type.t|
|00002da0| 61 62 00 57 00 0e b0 59 | 00 00 02 e0 00 24 72 65 |ab.W...Y|.....$re|
|00002db0| 66 5f 65 6d 70 6c 6f 79 | 6d 65 6e 74 5f 74 79 70 |f_employ|ment_typ|
|00002dc0| 65 2e 74 61 62 00 b0 59 | 00 0e b0 5a 00 00 02 fc |e.tab..Y|...Z....|
|00002dd0| 00 20 72 65 66 5f 67 65 | 6e 64 65 72 5f 74 79 70 |. ref_ge|nder_typ|
|00002de0| 65 2e 74 61 62 00 b0 59 | 00 0e b0 5b 00 00 03 18 |e.tab..Y|...[....|
|00002df0| 00 1c 72 65 66 5f 68 61 | 6e 64 69 63 61 70 2e 74 |..ref_ha|ndicap.t|
|00002e00| 2e 2f 76 32 5f 63 6d 73 | 2f 74 61 62 6c 65 2f 72 |./v2_cms|/table/r|
|00002e10| 65 66 5f 74 61 62 6c 65 | 2f 72 65 66 5f 64 65 70 |ef_table|/ref_dep|
|00002e20| 6f 73 69 74 5f 74 79 70 | 65 2e 74 61 62 00 00 00 |osit_typ|e.tab...|
|00002e30| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002e40| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002e50| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002e60| 00 00 00 00 30 31 30 30 | 36 36 34 00 30 30 30 30 |....0100|664.0000|
|00002e70| 30 31 33 00 30 30 31 33 | 35 36 33 00 30 30 30 30 |013.0013|563.0000|
|00002e80| 30 30 30 30 34 31 37 00 | 30 35 37 30 33 30 34 33 |0000417.|05703043|
|00002e90| 37 35 32 00 30 30 32 32 | 33 32 34 00 30 00 00 00 |752.0022|324.0...|
|00002ea0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002eb0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002ec0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002ed0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002ee0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002ef0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002f00| 00 75 73 74 61 72 00 30 | 30 73 79 62 61 73 65 00 |.ustar.0|0sybase.|
|00002f10| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002f20| 00 00 00 00 00 00 00 00 | 00 73 79 62 61 73 65 00 |........|.sybase.|
|00002f30| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002f40| 00 00 00 00 00 00 00 00 | 00 30 30 30 30 30 34 30 |........|.0000040|
|00002f50| 00 30 30 30 30 32 30 30 | 00 00 00 00 00 00 00 00 |.0000200|........|
|00002f60| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002f70| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002f80| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002f90| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002fa0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002fb0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002fc0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002fd0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002fe0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002ff0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003000| 2f 2a 20 53 43 43 53 20 | 49 6e 66 6f 72 6d 61 74 |/* SCCS |Informat|
|00003010| 69 6f 6e 3a 09 25 57 25 | 20 25 47 25 20 2a 2f 0a |ion:.%W%| %G% */.|
|00003020| 0a 75 73 65 20 76 32 5f | 63 6d 73 0a 67 6f 0a 0a |.use v2_|cms.go..|
|00003030| 69 66 20 65 78 69 73 74 | 73 20 28 73 65 6c 65 63 |if exist|s (selec|
|00003040| 74 20 31 20 66 72 6f 6d | 20 73 79 73 6f 62 6a 65 |t 1 from| sysobje|
|00003050| 63 74 73 0a 09 09 77 68 | 65 72 65 20 6e 61 6d 65 |cts...wh|ere name|
|00003060| 20 3d 20 22 72 65 66 5f | 64 65 70 6f 73 69 74 5f | = "ref_|deposit_|
|00003070| 74 79 70 65 22 20 61 6e | 64 0a 09 09 20 20 20 20 |type" an|d...    |
|00003080| 20 20 74 79 70 65 20 3d | 20 22 55 22 29 0a 09 64 |  type =| "U")..d|
|00003090| 72 6f 70 20 74 61 62 6c | 65 20 72 65 66 5f 64 65 |rop tabl|e ref_de|
|000030a0| 70 6f 73 69 74 5f 74 79 | 70 65 0a 0a 67 6f 0a 0a |posit_ty|pe..go..|
|000030b0| 63 72 65 61 74 65 20 74 | 61 62 6c 65 20 72 65 66 |create t|able ref|
|000030c0| 5f 64 65 70 6f 73 69 74 | 5f 74 79 70 65 20 28 0a |_deposit|_type (.|
|000030d0| 09 74 79 70 65 09 09 63 | 6f 64 65 09 09 4e 4f 54 |.type..c|ode..NOT|
|000030e0| 20 4e 55 4c 4c 2c 0a 09 | 64 65 73 63 72 69 70 74 | NULL,..|descript|
|000030f0| 69 6f 6e 09 76 61 72 63 | 68 61 72 28 35 30 29 09 |ion.varc|har(50).|
|00003100| 4e 4f 54 20 4e 55 4c 4c | 0a 29 0a 0a 67 6f 0a 65 |NOT NULL|.)..go.e|
|00003110| 66 5f 70 75 62 6c 69 73 | 68 5f 63 6f 64 65 2e 74 |f_publis|h_code.t|
|00003120| 61 62 00 54 00 0e b0 56 | 00 00 02 80 00 1c 72 65 |ab.T...V|......re|
|00003130| 66 5f 6f 72 67 5f 74 79 | 70 65 2e 74 61 62 00 74 |f_org_ty|pe.tab.t|
|00003140| 00 0e b0 57 00 00 02 a0 | 00 24 72 65 66 5f 64 65 |...W....|.$ref_de|
|00003150| 66 61 75 6c 74 5f 73 74 | 61 74 75 73 2e 74 61 62 |fault_st|atus.tab|
|00003160| 00 0e b0 57 00 0e b0 58 | 00 00 02 c0 00 20 72 65 |...W...X|..... re|
|00003170| 66 5f 61 64 64 72 65 73 | 73 5f 74 79 70 65 2e 74 |f_addres|s_type.t|
|00003180| 61 62 00 57 00 0e b0 59 | 00 00 02 e0 00 24 72 65 |ab.W...Y|.....$re|
|00003190| 66 5f 65 6d 70 6c 6f 79 | 6d 65 6e 74 5f 74 79 70 |f_employ|ment_typ|
|000031a0| 65 2e 74 61 62 00 b0 59 | 00 0e b0 5a 00 00 02 fc |e.tab..Y|...Z....|
|000031b0| 00 20 72 65 66 5f 67 65 | 6e 64 65 72 5f 74 79 70 |. ref_ge|nder_typ|
|000031c0| 65 2e 74 61 62 00 b0 59 | 00 0e b0 5b 00 00 03 18 |e.tab..Y|...[....|
|000031d0| 00 1c 72 65 66 5f 68 61 | 6e 64 69 63 61 70 2e 74 |..ref_ha|ndicap.t|
|000031e0| 61 62 00 61 00 0e b0 5c | 00 00 03 34 00 1c 72 65 |ab.a...\|...4..re|
|000031f0| 66 5f 6c 61 6e 67 75 61 | 67 65 2e 74 61 62 00 74 |f_langua|ge.tab.t|
|00003200| 2e 2f 76 32 5f 63 6d 73 | 2f 74 61 62 6c 65 2f 72 |./v2_cms|/table/r|
|00003210| 65 66 5f 74 61 62 6c 65 | 2f 72 65 66 5f 63 6f 6e |ef_table|/ref_con|
|00003220| 74 61 63 74 5f 74 79 70 | 65 2e 74 61 62 00 00 00 |tact_typ|e.tab...|
|00003230| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003240| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003250| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003260| 00 00 00 00 30 31 30 30 | 36 36 34 00 30 30 30 30 |....0100|664.0000|
|00003270| 30 31 33 00 30 30 31 33 | 35 36 33 00 30 30 30 30 |013.0013|563.0000|
|00003280| 30 30 30 30 34 34 31 00 | 30 35 37 30 33 30 34 37 |0000441.|05703047|
|00003290| 31 30 37 00 30 30 32 32 | 33 30 33 00 30 00 00 00 |107.0022|303.0...|
|000032a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000032b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000032c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000032d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000032e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000032f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003300| 00 75 73 74 61 72 00 30 | 30 73 79 62 61 73 65 00 |.ustar.0|0sybase.|
|00003310| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003320| 00 00 00 00 00 00 00 00 | 00 73 79 62 61 73 65 00 |........|.sybase.|
|00003330| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003340| 00 00 00 00 00 00 00 00 | 00 30 30 30 30 30 34 30 |........|.0000040|
|00003350| 00 30 30 30 30 32 30 30 | 00 00 00 00 00 00 00 00 |.0000200|........|
|00003360| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003370| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003380| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003390| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000033a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000033b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000033c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000033d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000033e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000033f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003400| 2f 2a 20 53 43 43 53 20 | 49 6e 66 6f 72 6d 61 74 |/* SCCS |Informat|
|00003410| 69 6f 6e 3a 09 25 57 25 | 20 25 47 25 20 2a 2f 0a |ion:.%W%| %G% */.|
|00003420| 0a 75 73 65 20 76 32 5f | 63 6d 73 0a 67 6f 0a 0a |.use v2_|cms.go..|
|00003430| 69 66 20 65 78 69 73 74 | 73 20 28 73 65 6c 65 63 |if exist|s (selec|
|00003440| 74 20 2a 20 66 72 6f 6d | 20 73 79 73 6f 62 6a 65 |t * from| sysobje|
|00003450| 63 74 73 20 77 68 65 72 | 65 0a 20 20 20 6e 61 6d |cts wher|e.   nam|
|00003460| 65 20 3d 20 22 72 65 66 | 5f 63 6f 6e 74 61 63 74 |e = "ref|_contact|
|00003470| 5f 74 79 70 65 22 20 61 | 6e 64 20 74 79 70 65 20 |_type" a|nd type |
|00003480| 3d 20 22 55 22 29 0a 20 | 20 44 52 4f 50 20 54 41 |= "U"). | DROP TA|
|00003490| 42 4c 45 20 72 65 66 5f | 63 6f 6e 74 61 63 74 5f |BLE ref_|contact_|
|000034a0| 74 79 70 65 0a 67 6f 0a | 0a 43 52 45 41 54 45 20 |type.go.|.CREATE |
|000034b0| 54 41 42 4c 45 20 72 65 | 66 5f 63 6f 6e 74 61 63 |TABLE re|f_contac|
|000034c0| 74 5f 74 79 70 65 0a 20 | 20 20 20 20 20 28 74 79 |t_type. |     (ty|
|000034d0| 70 65 20 20 20 20 20 20 | 09 63 6f 64 65 20 20 20 |pe      |.code   |
|000034e0| 20 20 20 20 20 4e 4f 54 | 20 4e 55 4c 4c 2c 0a 20 |     NOT| NULL,. |
|000034f0| 20 20 20 20 20 20 64 65 | 73 63 72 69 70 74 69 6f |      de|scriptio|
|00003500| 6e 20 20 20 20 20 20 76 | 61 72 63 68 61 72 28 35 |n      v|archar(5|
|00003510| 30 29 20 4e 4f 54 20 4e | 55 4c 4c 0a 29 0a 67 6f |0) NOT N|ULL.).go|
|00003520| 0a 0e b0 57 00 00 02 a0 | 00 24 72 65 66 5f 64 65 |...W....|.$ref_de|
|00003530| 66 61 75 6c 74 5f 73 74 | 61 74 75 73 2e 74 61 62 |fault_st|atus.tab|
|00003540| 00 0e b0 57 00 0e b0 58 | 00 00 02 c0 00 20 72 65 |...W...X|..... re|
|00003550| 66 5f 61 64 64 72 65 73 | 73 5f 74 79 70 65 2e 74 |f_addres|s_type.t|
|00003560| 61 62 00 57 00 0e b0 59 | 00 00 02 e0 00 24 72 65 |ab.W...Y|.....$re|
|00003570| 66 5f 65 6d 70 6c 6f 79 | 6d 65 6e 74 5f 74 79 70 |f_employ|ment_typ|
|00003580| 65 2e 74 61 62 00 b0 59 | 00 0e b0 5a 00 00 02 fc |e.tab..Y|...Z....|
|00003590| 00 20 72 65 66 5f 67 65 | 6e 64 65 72 5f 74 79 70 |. ref_ge|nder_typ|
|000035a0| 65 2e 74 61 62 00 b0 59 | 00 0e b0 5b 00 00 03 18 |e.tab..Y|...[....|
|000035b0| 00 1c 72 65 66 5f 68 61 | 6e 64 69 63 61 70 2e 74 |..ref_ha|ndicap.t|
|000035c0| 61 62 00 61 00 0e b0 5c | 00 00 03 34 00 1c 72 65 |ab.a...\|...4..re|
|000035d0| 66 5f 6c 61 6e 67 75 61 | 67 65 2e 74 61 62 00 74 |f_langua|ge.tab.t|
|000035e0| 00 0e b0 5d 00 00 03 54 | 00 24 72 65 66 5f 6c 69 |...]...T|.$ref_li|
|000035f0| 6e 65 5f 63 6c 61 73 73 | 5f 63 6f 64 65 2e 74 61 |ne_class|_code.ta|
|00003600| 2e 2f 76 32 5f 63 6d 73 | 2f 74 61 62 6c 65 2f 72 |./v2_cms|/table/r|
|00003610| 65 66 5f 74 61 62 6c 65 | 2f 72 65 66 5f 63 72 65 |ef_table|/ref_cre|
|00003620| 64 69 74 5f 72 65 66 5f | 74 79 70 65 2e 74 61 62 |dit_ref_|type.tab|
|00003630| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003640| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003650| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003660| 00 00 00 00 30 31 30 30 | 36 36 34 00 30 30 30 30 |....0100|664.0000|
|00003670| 30 31 33 00 30 30 31 33 | 35 36 33 00 30 30 30 30 |013.0013|563.0000|
|00003680| 30 30 30 30 34 35 37 00 | 30 35 37 30 33 30 34 33 |0000457.|05703043|
|00003690| 37 35 31 00 30 30 32 32 | 37 36 36 00 30 00 00 00 |751.0022|766.0...|
|000036a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000036b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000036c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000036d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000036e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000036f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003700| 00 75 73 74 61 72 00 30 | 30 73 79 62 61 73 65 00 |.ustar.0|0sybase.|
|00003710| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003720| 00 00 00 00 00 00 00 00 | 00 73 79 62 61 73 65 00 |........|.sybase.|
|00003730| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003740| 00 00 00 00 00 00 00 00 | 00 30 30 30 30 30 34 30 |........|.0000040|
|00003750| 00 30 30 30 30 32 30 30 | 00 00 00 00 00 00 00 00 |.0000200|........|
|00003760| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003770| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003780| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003790| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000037a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000037b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000037c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000037d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000037e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000037f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003800| 2f 2a 20 53 43 43 53 20 | 49 6e 66 6f 72 6d 61 74 |/* SCCS |Informat|
|00003810| 69 6f 6e 3a 09 25 57 25 | 20 25 47 25 20 2a 2f 0a |ion:.%W%| %G% */.|
|00003820| 0a 75 73 65 20 76 32 5f | 63 6d 73 20 0a 67 6f 0a |.use v2_|cms .go.|
|00003830| 0a 69 66 20 65 78 69 73 | 74 73 20 28 73 65 6c 65 |.if exis|ts (sele|
|00003840| 63 74 20 2a 20 66 72 6f | 6d 20 73 79 73 6f 62 6a |ct * fro|m sysobj|
|00003850| 65 63 74 73 20 77 68 65 | 72 65 0a 20 20 20 6e 61 |ects whe|re.   na|
|00003860| 6d 65 20 3d 20 22 72 65 | 66 5f 63 72 65 64 69 74 |me = "re|f_credit|
|00003870| 5f 72 65 66 5f 74 79 70 | 65 22 20 61 6e 64 20 74 |_ref_typ|e" and t|
|00003880| 79 70 65 20 3d 20 22 55 | 22 29 0a 20 20 44 52 4f |ype = "U|").  DRO|
|00003890| 50 20 54 41 42 4c 45 20 | 72 65 66 5f 63 72 65 64 |P TABLE |ref_cred|
|000038a0| 69 74 5f 72 65 66 5f 74 | 79 70 65 0a 67 6f 0a 0a |it_ref_t|ype.go..|
|000038b0| 43 52 45 41 54 45 20 54 | 41 42 4c 45 20 72 65 66 |CREATE T|ABLE ref|
|000038c0| 5f 63 72 65 64 69 74 5f | 72 65 66 5f 74 79 70 65 |_credit_|ref_type|
|000038d0| 0a 20 20 20 20 20 20 28 | 63 6f 64 65 20 20 20 20 |.      (|code    |
|000038e0| 20 20 20 20 20 20 20 20 | 63 6f 64 65 20 20 20 20 |        |code    |
|000038f0| 20 20 20 20 4e 4f 54 20 | 4e 55 4c 4c 2c 0a 20 20 |    NOT |NULL,.  |
|00003900| 20 20 20 20 20 64 65 73 | 63 72 69 70 74 69 6f 6e |     des|cription|
|00003910| 20 20 20 20 20 76 61 72 | 63 68 61 72 28 35 30 29 |     var|char(50)|
|00003920| 20 4e 4f 54 20 4e 55 4c | 4c 0a 29 0a 67 6f 0a 65 | NOT NUL|L.).go.e|
|00003930| 66 5f 61 64 64 72 65 73 | 73 5f 74 79 70 65 2e 74 |f_addres|s_type.t|
|00003940| 61 62 00 57 00 0e b0 59 | 00 00 02 e0 00 24 72 65 |ab.W...Y|.....$re|
|00003950| 66 5f 65 6d 70 6c 6f 79 | 6d 65 6e 74 5f 74 79 70 |f_employ|ment_typ|
|00003960| 65 2e 74 61 62 00 b0 59 | 00 0e b0 5a 00 00 02 fc |e.tab..Y|...Z....|
|00003970| 00 20 72 65 66 5f 67 65 | 6e 64 65 72 5f 74 79 70 |. ref_ge|nder_typ|
|00003980| 65 2e 74 61 62 00 b0 59 | 00 0e b0 5b 00 00 03 18 |e.tab..Y|...[....|
|00003990| 00 1c 72 65 66 5f 68 61 | 6e 64 69 63 61 70 2e 74 |..ref_ha|ndicap.t|
|000039a0| 61 62 00 61 00 0e b0 5c | 00 00 03 34 00 1c 72 65 |ab.a...\|...4..re|
|000039b0| 66 5f 6c 61 6e 67 75 61 | 67 65 2e 74 61 62 00 74 |f_langua|ge.tab.t|
|000039c0| 00 0e b0 5d 00 00 03 54 | 00 24 72 65 66 5f 6c 69 |...]...T|.$ref_li|
|000039d0| 6e 65 5f 63 6c 61 73 73 | 5f 63 6f 64 65 2e 74 61 |ne_class|_code.ta|
|000039e0| 62 00 b0 5d 00 0e b0 5e | 00 00 03 70 00 20 72 65 |b..]...^|...p. re|
|000039f0| 66 5f 6e 75 6d 62 65 72 | 5f 74 79 70 65 2e 74 61 |f_number|_type.ta|
|00003a00| 2e 2f 76 32 5f 63 6d 73 | 2f 74 61 62 6c 65 2f 72 |./v2_cms|/table/r|
|00003a10| 65 66 5f 74 61 62 6c 65 | 2f 72 65 66 5f 69 64 5f |ef_table|/ref_id_|
|00003a20| 74 79 70 65 2e 74 61 62 | 00 00 00 00 00 00 00 00 |type.tab|........|
|00003a30| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003a40| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003a50| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003a60| 00 00 00 00 30 31 30 30 | 36 36 34 00 30 30 30 30 |....0100|664.0000|
|00003a70| 30 31 33 00 30 30 31 33 | 35 36 33 00 30 30 30 30 |013.0013|563.0000|
|00003a80| 30 30 30 30 34 31 37 00 | 30 35 37 30 33 30 34 33 |0000417.|05703043|
|00003a90| 37 35 33 00 30 30 32 31 | 32 35 32 00 30 00 00 00 |753.0021|252.0...|
|00003aa0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003ab0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003ac0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003ad0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003ae0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003af0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003b00| 00 75 73 74 61 72 00 30 | 30 73 79 62 61 73 65 00 |.ustar.0|0sybase.|
|00003b10| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003b20| 00 00 00 00 00 00 00 00 | 00 73 79 62 61 73 65 00 |........|.sybase.|
|00003b30| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003b40| 00 00 00 00 00 00 00 00 | 00 30 30 30 30 30 34 30 |........|.0000040|
|00003b50| 00 30 30 30 30 32 30 30 | 00 00 00 00 00 00 00 00 |.0000200|........|
|00003b60| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003b70| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003b80| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003b90| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003ba0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003bb0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003bc0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003bd0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003be0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003bf0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003c00| 2f 2a 20 53 43 43 53 20 | 49 6e 66 6f 72 6d 61 74 |/* SCCS |Informat|
|00003c10| 69 6f 6e 3a 09 25 57 25 | 20 25 47 25 20 2a 2f 0a |ion:.%W%| %G% */.|
|00003c20| 0a 75 73 65 20 76 32 5f | 63 6d 73 20 0a 67 6f 0a |.use v2_|cms .go.|
|00003c30| 0a 69 66 20 65 78 69 73 | 74 73 20 28 73 65 6c 65 |.if exis|ts (sele|
|00003c40| 63 74 20 2a 20 66 72 6f | 6d 20 73 79 73 6f 62 6a |ct * fro|m sysobj|
|00003c50| 65 63 74 73 20 77 68 65 | 72 65 0a 20 20 20 6e 61 |ects whe|re.   na|
|00003c60| 6d 65 20 3d 20 22 72 65 | 66 5f 69 64 5f 74 79 70 |me = "re|f_id_typ|
|00003c70| 65 22 20 61 6e 64 20 74 | 79 70 65 20 3d 20 22 55 |e" and t|ype = "U|
|00003c80| 22 29 0a 20 20 44 52 4f | 50 20 54 41 42 4c 45 20 |").  DRO|P TABLE |
|00003c90| 72 65 66 5f 69 64 5f 74 | 79 70 65 0a 67 6f 0a 0a |ref_id_t|ype.go..|
|00003ca0| 43 52 45 41 54 45 20 54 | 41 42 4c 45 20 72 65 66 |CREATE T|ABLE ref|
|00003cb0| 5f 69 64 5f 74 79 70 65 | 0a 20 20 20 20 20 20 28 |_id_type|.      (|
|00003cc0| 74 79 70 65 20 20 20 20 | 20 20 09 63 68 61 72 28 |type    |  .char(|
|00003cd0| 32 29 20 4e 4f 54 20 4e | 55 4c 4c 2c 0a 20 20 20 |2) NOT N|ULL,.   |
|00003ce0| 20 20 20 20 64 65 73 63 | 72 69 70 74 69 6f 6e 20 |    desc|ription |
|00003cf0| 20 20 20 20 20 76 61 72 | 63 68 61 72 28 35 30 29 |     var|char(50)|
|00003d00| 20 4e 4f 54 20 4e 55 4c | 4c 0a 29 0a 67 6f 0a 64 | NOT NUL|L.).go.d|
|00003d10| 64 72 65 73 73 5f 74 79 | 70 65 2e 74 61 62 00 62 |dress_ty|pe.tab.b|
|00003d20| 00 0e b0 59 00 00 02 e0 | 00 24 72 65 66 5f 65 6d |...Y....|.$ref_em|
|00003d30| 70 6c 6f 79 6d 65 6e 74 | 5f 74 79 70 65 2e 74 61 |ployment|_type.ta|
|00003d40| 62 00 00 57 00 0e b0 5a | 00 00 02 fc 00 20 72 65 |b..W...Z|..... re|
|00003d50| 66 5f 67 65 6e 64 65 72 | 5f 74 79 70 65 2e 74 61 |f_gender|_type.ta|
|00003d60| 62 00 74 61 00 0e b0 5b | 00 00 03 18 00 1c 72 65 |b.ta...[|......re|
|00003d70| 66 5f 68 61 6e 64 69 63 | 61 70 2e 74 61 62 00 70 |f_handic|ap.tab.p|
|00003d80| 00 0e b0 5c 00 00 03 34 | 00 1c 72 65 66 5f 6c 61 |...\...4|..ref_la|
|00003d90| 6e 67 75 61 67 65 2e 74 | 61 62 00 63 00 0e b0 5d |nguage.t|ab.c...]|
|00003da0| 00 00 03 54 00 24 72 65 | 66 5f 6c 69 6e 65 5f 63 |...T.$re|f_line_c|
|00003db0| 6c 61 73 73 5f 63 6f 64 | 65 2e 74 61 62 00 00 74 |lass_cod|e.tab..t|
|00003dc0| 00 0e b0 5e 00 00 03 70 | 00 20 72 65 66 5f 6e 75 |...^...p|. ref_nu|
|00003dd0| 6d 62 65 72 5f 74 79 70 | 65 2e 74 61 62 00 74 61 |mber_typ|e.tab.ta|
|00003de0| 00 0e b0 5f 00 00 03 90 | 00 20 72 65 66 5f 6f 72 |..._....|. ref_or|
|00003df0| 64 65 72 5f 72 65 61 73 | 6f 6e 2e 74 61 62 00 61 |der_reas|on.tab.a|
|00003e00| 2e 2f 76 32 5f 63 6d 73 | 2f 74 61 62 6c 65 2f 72 |./v2_cms|/table/r|
|00003e10| 65 66 5f 74 61 62 6c 65 | 2f 72 65 66 5f 63 75 73 |ef_table|/ref_cus|
|00003e20| 74 5f 72 65 6c 61 74 69 | 6f 6e 73 68 69 70 5f 63 |t_relati|onship_c|
|00003e30| 6f 64 65 2e 74 61 62 00 | 00 00 00 00 00 00 00 00 |ode.tab.|........|
|00003e40| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003e50| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003e60| 00 00 00 00 30 31 30 30 | 36 36 34 00 30 30 30 30 |....0100|664.0000|
|00003e70| 30 31 33 00 30 30 31 33 | 35 36 33 00 30 30 30 30 |013.0013|563.0000|
|00003e80| 30 30 30 30 34 35 37 00 | 30 35 37 30 33 30 34 33 |0000457.|05703043|
|00003e90| 37 35 31 00 30 30 32 34 | 33 35 30 00 30 00 00 00 |751.0024|350.0...|
|00003ea0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003eb0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003ec0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003ed0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003ee0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003ef0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003f00| 00 75 73 74 61 72 00 30 | 30 73 79 62 61 73 65 00 |.ustar.0|0sybase.|
|00003f10| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003f20| 00 00 00 00 00 00 00 00 | 00 73 79 62 61 73 65 00 |........|.sybase.|
|00003f30| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003f40| 00 00 00 00 00 00 00 00 | 00 30 30 30 30 30 34 30 |........|.0000040|
|00003f50| 00 30 30 30 30 32 30 30 | 00 00 00 00 00 00 00 00 |.0000200|........|
|00003f60| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003f70| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003f80| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003f90| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003fa0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003fb0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003fc0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003fd0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003fe0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003ff0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004000| 2f 2a 20 53 43 43 53 20 | 49 6e 66 6f 72 6d 61 74 |/* SCCS |Informat|
|00004010| 69 6f 6e 3a 09 25 57 25 | 20 25 47 25 20 2a 2f 0a |ion:.%W%| %G% */.|
|00004020| 0a 75 73 65 20 76 32 5f | 63 6d 73 20 0a 67 6f 0a |.use v2_|cms .go.|
|00004030| 0a 69 66 20 65 78 69 73 | 74 73 20 28 73 65 6c 65 |.if exis|ts (sele|
|00004040| 63 74 20 31 20 66 72 6f | 6d 20 73 79 73 6f 62 6a |ct 1 fro|m sysobj|
|00004050| 65 63 74 73 0a 09 09 77 | 68 65 72 65 20 6e 61 6d |ects...w|here nam|
|00004060| 65 20 3d 20 22 72 65 66 | 5f 63 75 73 74 5f 72 65 |e = "ref|_cust_re|
|00004070| 6c 61 74 69 6f 6e 73 68 | 69 70 5f 63 6f 64 65 22 |lationsh|ip_code"|
|00004080| 20 61 6e 64 0a 09 09 20 | 20 20 20 20 20 74 79 70 | and... |     typ|
|00004090| 65 20 3d 20 22 55 22 29 | 0a 09 64 72 6f 70 20 74 |e = "U")|..drop t|
|000040a0| 61 62 6c 65 20 72 65 66 | 5f 63 75 73 74 5f 72 65 |able ref|_cust_re|
|000040b0| 6c 61 74 69 6f 6e 73 68 | 69 70 5f 63 6f 64 65 0a |lationsh|ip_code.|
|000040c0| 0a 67 6f 0a 0a 63 72 65 | 61 74 65 20 74 61 62 6c |.go..cre|ate tabl|
|000040d0| 65 20 72 65 66 5f 63 75 | 73 74 5f 72 65 6c 61 74 |e ref_cu|st_relat|
|000040e0| 69 6f 6e 73 68 69 70 5f | 63 6f 64 65 20 28 0a 09 |ionship_|code (..|
|000040f0| 63 6f 64 65 09 09 63 6f | 64 65 09 09 4e 4f 54 20 |code..co|de..NOT |
|00004100| 4e 55 4c 4c 2c 0a 09 64 | 65 73 63 72 69 70 74 69 |NULL,..d|escripti|
|00004110| 6f 6e 09 09 76 61 72 63 | 68 61 72 28 35 30 29 09 |on..varc|har(50).|
|00004120| 4e 4f 54 20 4e 55 4c 4c | 0a 29 0a 0a 67 6f 0a fc |NOT NULL|.)..go..|
|00004130| 00 20 72 65 66 5f 67 65 | 6e 64 65 72 5f 74 79 70 |. ref_ge|nder_typ|
|00004140| 65 2e 74 61 62 00 b0 5a | 00 0e b0 5b 00 00 03 18 |e.tab..Z|...[....|
|00004150| 00 1c 72 65 66 5f 68 61 | 6e 64 69 63 61 70 2e 74 |..ref_ha|ndicap.t|
|00004160| 61 62 00 61 00 0e b0 5c | 00 00 03 34 00 1c 72 65 |ab.a...\|...4..re|
|00004170| 66 5f 6c 61 6e 67 75 61 | 67 65 2e 74 61 62 00 70 |f_langua|ge.tab.p|
|00004180| 00 0e b0 5d 00 00 03 54 | 00 24 72 65 66 5f 6c 69 |...]...T|.$ref_li|
|00004190| 6e 65 5f 63 6c 61 73 73 | 5f 63 6f 64 65 2e 74 61 |ne_class|_code.ta|
|000041a0| 62 00 03 54 00 0e b0 5e | 00 00 03 70 00 20 72 65 |b..T...^|...p. re|
|000041b0| 66 5f 6e 75 6d 62 65 72 | 5f 74 79 70 65 2e 74 61 |f_number|_type.ta|
|000041c0| 62 00 b0 5e 00 0e b0 5f | 00 00 03 90 00 20 72 65 |b..^..._|..... re|
|000041d0| 66 5f 6f 72 64 65 72 5f | 72 65 61 73 6f 6e 2e 74 |f_order_|reason.t|
|000041e0| 61 62 00 5f 00 0e b0 60 | 00 00 03 ac 00 20 72 65 |ab._...`|..... re|
|000041f0| 66 5f 70 61 79 5f 6d 65 | 74 68 6f 64 2e 74 61 62 |f_pay_me|thod.tab|
|00004200| 2e 2f 76 32 5f 63 6d 73 | 2f 74 61 62 6c 65 2f 72 |./v2_cms|/table/r|
|00004210| 65 66 5f 74 61 62 6c 65 | 2f 72 65 66 5f 63 75 73 |ef_table|/ref_cus|
|00004220| 74 6f 6d 65 72 5f 63 61 | 74 65 67 6f 72 79 2e 74 |tomer_ca|tegory.t|
|00004230| 61 62 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |ab......|........|
|00004240| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004250| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004260| 00 00 00 00 30 31 30 30 | 36 36 34 00 30 30 30 30 |....0100|664.0000|
|00004270| 30 31 33 00 30 30 31 33 | 35 36 33 00 30 30 30 30 |013.0013|563.0000|
|00004280| 30 30 30 30 35 32 36 00 | 30 35 37 30 33 30 34 33 |0000526.|05703043|
|00004290| 37 35 31 00 30 30 32 33 | 33 35 32 00 30 00 00 00 |751.0023|352.0...|
|000042a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000042b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000042c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000042d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000042e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000042f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004300| 00 75 73 74 61 72 00 30 | 30 73 79 62 61 73 65 00 |.ustar.0|0sybase.|
|00004310| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004320| 00 00 00 00 00 00 00 00 | 00 73 79 62 61 73 65 00 |........|.sybase.|
|00004330| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004340| 00 00 00 00 00 00 00 00 | 00 30 30 30 30 30 34 30 |........|.0000040|
|00004350| 00 30 30 30 30 32 30 30 | 00 00 00 00 00 00 00 00 |.0000200|........|
|00004360| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004370| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004380| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004390| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000043a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000043b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000043c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000043d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000043e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000043f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004400| 2f 2a 20 53 43 43 53 20 | 49 6e 66 6f 72 6d 61 74 |/* SCCS |Informat|
|00004410| 69 6f 6e 3a 09 25 57 25 | 20 25 47 25 20 2a 2f 0a |ion:.%W%| %G% */.|
|00004420| 0a 75 73 65 20 76 32 5f | 63 6d 73 20 0a 67 6f 0a |.use v2_|cms .go.|
|00004430| 0a 69 66 20 65 78 69 73 | 74 73 20 28 73 65 6c 65 |.if exis|ts (sele|
|00004440| 63 74 20 2a 20 66 72 6f | 6d 20 73 79 73 6f 62 6a |ct * fro|m sysobj|
|00004450| 65 63 74 73 20 77 68 65 | 72 65 0a 20 20 20 6e 61 |ects whe|re.   na|
|00004460| 6d 65 20 3d 20 22 72 65 | 66 5f 63 75 73 74 6f 6d |me = "re|f_custom|
|00004470| 65 72 5f 63 61 74 65 67 | 6f 72 79 22 20 61 6e 64 |er_categ|ory" and|
|00004480| 20 74 79 70 65 20 3d 20 | 22 55 22 29 0a 20 20 44 | type = |"U").  D|
|00004490| 52 4f 50 20 54 41 42 4c | 45 20 72 65 66 5f 63 75 |ROP TABL|E ref_cu|
|000044a0| 73 74 6f 6d 65 72 5f 63 | 61 74 65 67 6f 72 79 0a |stomer_c|ategory.|
|000044b0| 67 6f 0a 0a 43 52 45 41 | 54 45 20 54 41 42 4c 45 |go..CREA|TE TABLE|
|000044c0| 20 72 65 66 5f 63 75 73 | 74 6f 6d 65 72 5f 63 61 | ref_cus|tomer_ca|
|000044d0| 74 65 67 6f 72 79 0a 20 | 20 20 20 20 20 28 63 6f |tegory. |     (co|
|000044e0| 64 65 20 20 20 20 20 20 | 63 6f 64 65 20 20 20 20 |de      |code    |
|000044f0| 20 20 20 20 4e 4f 54 20 | 4e 55 4c 4c 2c 0a 20 20 |    NOT |NULL,.  |
|00004500| 20 20 20 20 20 6e 61 6d | 65 20 20 20 20 20 20 76 |     nam|e      v|
|00004510| 61 72 63 68 61 72 28 33 | 30 29 20 4e 4f 54 20 4e |archar(3|0) NOT N|
|00004520| 55 4c 4c 2c 0a 20 20 20 | 20 20 20 20 64 65 73 63 |ULL,.   |    desc|
|00004530| 72 69 70 74 69 6f 6e 20 | 20 20 20 20 76 61 72 63 |ription |    varc|
|00004540| 68 61 72 28 35 30 29 20 | 4e 4f 54 20 4e 55 4c 4c |har(50) |NOT NULL|
|00004550| 0a 29 0a 67 6f 0a b0 5d | 00 00 03 54 00 24 72 65 |.).go..]|...T.$re|
|00004560| 66 5f 6c 69 6e 65 5f 63 | 6c 61 73 73 5f 63 6f 64 |f_line_c|lass_cod|
|00004570| 65 2e 74 61 62 00 75 61 | 00 0e b0 5e 00 00 03 70 |e.tab.ua|...^...p|
|00004580| 00 20 72 65 66 5f 6e 75 | 6d 62 65 72 5f 74 79 70 |. ref_nu|mber_typ|
|00004590| 65 2e 74 61 62 00 73 73 | 00 0e b0 5f 00 00 03 90 |e.tab.ss|..._....|
|000045a0| 00 20 72 65 66 5f 6f 72 | 64 65 72 5f 72 65 61 73 |. ref_or|der_reas|
|000045b0| 6f 6e 2e 74 61 62 00 72 | 00 0e b0 60 00 00 03 ac |on.tab.r|...`....|
|000045c0| 00 20 72 65 66 5f 70 61 | 79 5f 6d 65 74 68 6f 64 |. ref_pa|y_method|
|000045d0| 2e 74 61 62 00 65 72 5f | 00 0e b0 61 00 00 03 cc |.tab.er_|...a....|
|000045e0| 00 20 72 65 66 5f 6f 72 | 64 65 72 5f 73 74 61 74 |. ref_or|der_stat|
|000045f0| 75 73 2e 74 61 62 00 65 | 00 0e b0 62 00 00 04 00 |us.tab.e|...b....|
|00004600| 2e 2f 76 32 5f 63 6d 73 | 2f 74 61 62 6c 65 2f 72 |./v2_cms|/table/r|
|00004610| 65 66 5f 74 61 62 6c 65 | 2f 72 65 66 5f 72 65 63 |ef_table|/ref_rec|
|00004620| 6f 6d 6d 65 63 74 5f 74 | 79 70 65 2e 74 61 62 00 |ommect_t|ype.tab.|
|00004630| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004640| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004650| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004660| 00 00 00 00 30 31 30 30 | 36 36 34 00 30 30 30 30 |....0100|664.0000|
|00004670| 30 31 33 00 30 30 31 33 | 35 36 33 00 30 30 30 30 |013.0013|563.0000|
|00004680| 30 30 30 30 34 32 35 00 | 30 35 37 30 33 30 34 33 |0000425.|05703043|
|00004690| 37 35 36 00 30 30 32 32 | 36 33 36 00 30 00 00 00 |756.0022|636.0...|
|000046a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000046b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000046c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000046d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000046e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000046f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004700| 00 75 73 74 61 72 00 30 | 30 73 79 62 61 73 65 00 |.ustar.0|0sybase.|
|00004710| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004720| 00 00 00 00 00 00 00 00 | 00 73 79 62 61 73 65 00 |........|.sybase.|
|00004730| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004740| 00 00 00 00 00 00 00 00 | 00 30 30 30 30 30 34 30 |........|.0000040|
|00004750| 00 30 30 30 30 32 30 30 | 00 00 00 00 00 00 00 00 |.0000200|........|
|00004760| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004770| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004780| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004790| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000047a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000047b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000047c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000047d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000047e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000047f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004800| 2f 2a 20 53 43 43 53 20 | 49 6e 66 6f 72 6d 61 74 |/* SCCS |Informat|
|00004810| 69 6f 6e 3a 09 25 57 25 | 20 25 47 25 20 2a 2f 0a |ion:.%W%| %G% */.|
|00004820| 0a 75 73 65 20 76 32 5f | 63 6d 73 0a 67 6f 0a 0a |.use v2_|cms.go..|
|00004830| 69 66 20 65 78 69 73 74 | 73 20 28 73 65 6c 65 63 |if exist|s (selec|
|00004840| 74 20 31 20 66 72 6f 6d | 20 73 79 73 6f 62 6a 65 |t 1 from| sysobje|
|00004850| 63 74 73 0a 09 09 77 68 | 65 72 65 20 6e 61 6d 65 |cts...wh|ere name|
|00004860| 20 3d 20 22 72 65 66 5f | 72 65 63 6f 6e 6e 65 63 | = "ref_|reconnec|
|00004870| 74 5f 74 79 70 65 22 20 | 61 6e 64 0a 09 09 20 20 |t_type" |and...  |
|00004880| 20 20 20 20 74 79 70 65 | 20 3d 20 22 55 22 29 0a |    type| = "U").|
|00004890| 09 64 72 6f 70 20 74 61 | 62 6c 65 20 72 65 66 5f |.drop ta|ble ref_|
|000048a0| 72 65 63 6f 6e 6e 65 63 | 74 5f 74 79 70 65 0a 0a |reconnec|t_type..|
|000048b0| 67 6f 0a 0a 63 72 65 61 | 74 65 20 74 61 62 6c 65 |go..crea|te table|
|000048c0| 20 72 65 66 5f 72 65 63 | 6f 6e 6e 65 63 74 5f 74 | ref_rec|onnect_t|
|000048d0| 79 70 65 20 28 0a 09 74 | 79 70 65 09 09 63 6f 64 |ype (..t|ype..cod|
|000048e0| 65 09 09 4e 4f 54 20 4e | 55 4c 4c 2c 0a 09 64 65 |e..NOT N|ULL,..de|
|000048f0| 73 63 72 69 70 74 69 6f | 6e 09 76 61 72 63 68 61 |scriptio|n.varcha|
|00004900| 72 28 35 30 29 09 4e 4f | 54 20 4e 55 4c 4c 0a 29 |r(50).NO|T NULL.)|
|00004910| 0a 0a 67 6f 0a 0e b0 5c | 00 00 03 34 00 1c 72 65 |..go...\|...4..re|
|00004920| 66 5f 6c 61 6e 67 75 61 | 67 65 2e 74 61 62 00 63 |f_langua|ge.tab.c|
|00004930| 00 0e b0 5d 00 00 03 54 | 00 24 72 65 66 5f 6c 69 |...]...T|.$ref_li|
|00004940| 6e 65 5f 63 6c 61 73 73 | 5f 63 6f 64 65 2e 74 61 |ne_class|_code.ta|
|00004950| 62 00 00 65 00 0e b0 5e | 00 00 03 70 00 20 72 65 |b..e...^|...p. re|
|00004960| 66 5f 6e 75 6d 62 65 72 | 5f 74 79 70 65 2e 74 61 |f_number|_type.ta|
|00004970| 62 00 74 61 00 0e b0 5f | 00 00 03 90 00 20 72 65 |b.ta..._|..... re|
|00004980| 66 5f 6f 72 64 65 72 5f | 72 65 61 73 6f 6e 2e 74 |f_order_|reason.t|
|00004990| 61 62 00 61 00 0e b0 60 | 00 00 03 ac 00 20 72 65 |ab.a...`|..... re|
|000049a0| 66 5f 70 61 79 5f 6d 65 | 74 68 6f 64 2e 74 61 62 |f_pay_me|thod.tab|
|000049b0| 00 6e 2e 74 00 0e b0 61 | 00 00 03 cc 00 20 72 65 |.n.t...a|..... re|
|000049c0| 66 5f 6f 72 64 65 72 5f | 73 74 61 74 75 73 2e 74 |f_order_|status.t|
|000049d0| 61 62 00 62 00 0e b0 62 | 00 00 04 00 00 24 72 65 |ab.b...b|.....$re|
|000049e0| 66 5f 6f 72 67 61 6e 69 | 7a 61 74 69 6f 6e 5f 74 |f_organi|zation_t|
|000049f0| 79 70 65 2e 74 61 62 00 | 00 0e b0 63 00 00 04 24 |ype.tab.|...c...$|
|00004a00| 2e 2f 76 32 5f 63 6d 73 | 2f 74 61 62 6c 65 2f 72 |./v2_cms|/table/r|
|00004a10| 65 66 5f 74 61 62 6c 65 | 2f 72 65 66 5f 70 75 62 |ef_table|/ref_pub|
|00004a20| 6c 69 73 68 5f 63 6f 64 | 65 2e 74 61 62 00 00 00 |lish_cod|e.tab...|
|00004a30| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004a40| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004a50| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004a60| 00 00 00 00 30 31 30 30 | 36 36 34 00 30 30 30 30 |....0100|664.0000|
|00004a70| 30 31 33 00 30 30 31 33 | 35 36 33 00 30 30 30 30 |013.0013|563.0000|
|00004a80| 30 30 30 30 34 33 36 00 | 30 35 37 30 33 30 34 33 |0000436.|05703043|
|00004a90| 37 35 36 00 30 30 32 32 | 32 36 31 00 30 00 00 00 |756.0022|261.0...|
|00004aa0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004ab0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004ac0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004ad0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004ae0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004af0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004b00| 00 75 73 74 61 72 00 30 | 30 73 79 62 61 73 65 00 |.ustar.0|0sybase.|
|00004b10| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004b20| 00 00 00 00 00 00 00 00 | 00 73 79 62 61 73 65 00 |........|.sybase.|
|00004b30| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004b40| 00 00 00 00 00 00 00 00 | 00 30 30 30 30 30 34 30 |........|.0000040|
|00004b50| 00 30 30 30 30 32 30 30 | 00 00 00 00 00 00 00 00 |.0000200|........|
|00004b60| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004b70| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004b80| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004b90| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004ba0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004bb0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004bc0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004bd0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004be0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004bf0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004c00| 2f 2a 20 53 43 43 53 20 | 49 6e 66 6f 72 6d 61 74 |/* SCCS |Informat|
|00004c10| 69 6f 6e 3a 09 25 57 25 | 20 25 47 25 20 2a 2f 0a |ion:.%W%| %G% */.|
|00004c20| 0a 75 73 65 20 76 32 5f | 63 6d 73 20 0a 67 6f 0a |.use v2_|cms .go.|
|00004c30| 0a 69 66 20 65 78 69 73 | 74 73 20 28 73 65 6c 65 |.if exis|ts (sele|
|00004c40| 63 74 20 2a 20 66 72 6f | 6d 20 73 79 73 6f 62 6a |ct * fro|m sysobj|
|00004c50| 65 63 74 73 20 77 68 65 | 72 65 0a 20 20 20 6e 61 |ects whe|re.   na|
|00004c60| 6d 65 20 3d 20 22 72 65 | 66 5f 70 75 62 6c 69 73 |me = "re|f_publis|
|00004c70| 68 5f 63 6f 64 65 22 20 | 61 6e 64 20 74 79 70 65 |h_code" |and type|
|00004c80| 20 3d 20 22 55 22 29 0a | 20 20 44 52 4f 50 20 54 | = "U").|  DROP T|
|00004c90| 41 42 4c 45 20 72 65 66 | 5f 70 75 62 6c 69 73 68 |ABLE ref|_publish|
|00004ca0| 5f 63 6f 64 65 0a 67 6f | 0a 0a 43 52 45 41 54 45 |_code.go|..CREATE|
|00004cb0| 20 54 41 42 4c 45 20 72 | 65 66 5f 70 75 62 6c 69 | TABLE r|ef_publi|
|00004cc0| 73 68 5f 63 6f 64 65 0a | 20 20 20 20 20 20 28 63 |sh_code.|      (c|
|00004cd0| 6f 64 65 20 20 20 20 20 | 20 09 63 6f 64 65 20 20 |ode     | .code  |
|00004ce0| 20 20 4e 4f 54 20 4e 55 | 4c 4c 2c 0a 20 20 20 20 |  NOT NU|LL,.    |
|00004cf0| 20 20 20 64 65 73 63 72 | 69 70 74 69 6f 6e 20 20 |   descr|iption  |
|00004d00| 20 20 20 20 76 61 72 63 | 68 61 72 28 35 30 29 20 |    varc|har(50) |
|00004d10| 4e 4f 54 20 4e 55 4c 4c | 0a 29 0a 67 6f 0a 5f 63 |NOT NULL|.).go._c|
|00004d20| 6c 61 73 73 5f 63 6f 64 | 65 2e 74 61 62 00 00 63 |lass_cod|e.tab..c|
|00004d30| 00 0e b0 5e 00 00 03 70 | 00 20 72 65 66 5f 6e 75 |...^...p|. ref_nu|
|00004d40| 6d 62 65 72 5f 74 79 70 | 65 2e 74 61 62 00 74 61 |mber_typ|e.tab.ta|
|00004d50| 00 0e b0 5f 00 00 03 90 | 00 20 72 65 66 5f 6f 72 |..._....|. ref_or|
|00004d60| 64 65 72 5f 72 65 61 73 | 6f 6e 2e 74 61 62 00 61 |der_reas|on.tab.a|
|00004d70| 00 0e b0 60 00 00 03 ac | 00 20 72 65 66 5f 70 61 |...`....|. ref_pa|
|00004d80| 79 5f 6d 65 74 68 6f 64 | 2e 74 61 62 00 6e 2e 74 |y_method|.tab.n.t|
|00004d90| 00 0e b0 61 00 00 03 cc | 00 20 72 65 66 5f 6f 72 |...a....|. ref_or|
|00004da0| 64 65 72 5f 73 74 61 74 | 75 73 2e 74 61 62 00 62 |der_stat|us.tab.b|
|00004db0| 00 0e b0 62 00 00 04 00 | 00 24 72 65 66 5f 6f 72 |...b....|.$ref_or|
|00004dc0| 67 61 6e 69 7a 61 74 69 | 6f 6e 5f 74 79 70 65 2e |ganizati|on_type.|
|00004dd0| 74 61 62 00 00 0e b0 63 | 00 00 04 24 00 24 72 65 |tab....c|...$.$re|
|00004de0| 66 5f 70 72 69 6d 61 72 | 79 5f 49 58 43 5f 63 6f |f_primar|y_IXC_co|
|00004df0| 64 65 2e 74 61 62 00 00 | 00 0e b0 64 00 00 04 44 |de.tab..|...d...D|
|00004e00| 2e 2f 76 32 5f 63 6d 73 | 2f 74 61 62 6c 65 2f 72 |./v2_cms|/table/r|
|00004e10| 65 66 5f 74 61 62 6c 65 | 2f 72 65 66 5f 6f 72 67 |ef_table|/ref_org|
|00004e20| 5f 74 79 70 65 2e 74 61 | 62 00 00 00 00 00 00 00 |_type.ta|b.......|
|00004e30| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004e40| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004e50| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004e60| 00 00 00 00 30 31 30 30 | 36 36 34 00 30 30 30 30 |....0100|664.0000|
|00004e70| 30 31 33 00 30 30 31 33 | 35 36 33 00 30 30 30 30 |013.0013|563.0000|
|00004e80| 30 30 30 30 34 32 32 00 | 30 35 37 30 33 30 34 33 |0000422.|05703043|
|00004e90| 37 35 34 00 30 30 32 31 | 34 34 32 00 30 00 00 00 |754.0021|442.0...|
|00004ea0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004eb0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004ec0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004ed0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004ee0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004ef0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004f00| 00 75 73 74 61 72 00 30 | 30 73 79 62 61 73 65 00 |.ustar.0|0sybase.|
|00004f10| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004f20| 00 00 00 00 00 00 00 00 | 00 73 79 62 61 73 65 00 |........|.sybase.|
|00004f30| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004f40| 00 00 00 00 00 00 00 00 | 00 30 30 30 30 30 34 30 |........|.0000040|
|00004f50| 00 30 30 30 30 32 30 30 | 00 00 00 00 00 00 00 00 |.0000200|........|
|00004f60| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004f70| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004f80| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004f90| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004fa0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004fb0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004fc0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004fd0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004fe0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004ff0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005000| 2f 2a 20 53 43 43 53 20 | 49 6e 66 6f 72 6d 61 74 |/* SCCS |Informat|
|00005010| 69 6f 6e 3a 09 25 57 25 | 20 25 47 25 20 2a 2f 0a |ion:.%W%| %G% */.|
|00005020| 0a 75 73 65 20 76 32 5f | 63 6d 73 20 0a 67 6f 0a |.use v2_|cms .go.|
|00005030| 0a 69 66 20 65 78 69 73 | 74 73 20 28 73 65 6c 65 |.if exis|ts (sele|
|00005040| 63 74 20 2a 20 66 72 6f | 6d 20 73 79 73 6f 62 6a |ct * fro|m sysobj|
|00005050| 65 63 74 73 20 77 68 65 | 72 65 0a 20 20 20 6e 61 |ects whe|re.   na|
|00005060| 6d 65 20 3d 20 22 72 65 | 66 5f 6f 72 67 5f 74 79 |me = "re|f_org_ty|
|00005070| 70 65 22 20 61 6e 64 20 | 74 79 70 65 20 3d 20 22 |pe" and |type = "|
|00005080| 55 22 29 0a 20 20 44 52 | 4f 50 20 54 41 42 4c 45 |U").  DR|OP TABLE|
|00005090| 20 72 65 66 5f 6f 72 67 | 5f 74 79 70 65 0a 67 6f | ref_org|_type.go|
|000050a0| 0a 0a 43 52 45 41 54 45 | 20 54 41 42 4c 45 20 72 |..CREATE| TABLE r|
|000050b0| 65 66 5f 6f 72 67 5f 74 | 79 70 65 0a 20 20 20 20 |ef_org_t|ype.    |
|000050c0| 20 20 28 74 79 70 65 20 | 20 20 20 20 20 09 63 68 |  (type |     .ch|
|000050d0| 61 72 28 32 29 20 4e 4f | 54 20 4e 55 4c 4c 2c 0a |ar(2) NO|T NULL,.|
|000050e0| 20 20 20 20 20 20 20 64 | 65 73 63 72 69 70 74 69 |       d|escripti|
|000050f0| 6f 6e 20 20 20 20 20 20 | 76 61 72 63 68 61 72 28 |on      |varchar(|
|00005100| 35 30 29 20 4e 4f 54 20 | 4e 55 4c 4c 0a 29 0a 67 |50) NOT |NULL.).g|
|00005110| 6f 0a b0 5e 00 00 03 70 | 00 20 72 65 66 5f 6e 75 |o..^...p|. ref_nu|
|00005120| 6d 62 65 72 5f 74 79 70 | 65 2e 74 61 62 00 00 63 |mber_typ|e.tab..c|
|00005130| 00 0e b0 5f 00 00 03 90 | 00 20 72 65 66 5f 6f 72 |..._....|. ref_or|
|00005140| 64 65 72 5f 72 65 61 73 | 6f 6e 2e 74 61 62 00 61 |der_reas|on.tab.a|
|00005150| 00 0e b0 60 00 00 03 ac | 00 20 72 65 66 5f 70 61 |...`....|. ref_pa|
|00005160| 79 5f 6d 65 74 68 6f 64 | 2e 74 61 62 00 62 00 61 |y_method|.tab.b.a|
|00005170| 00 0e b0 61 00 00 03 cc | 00 20 72 65 66 5f 6f 72 |...a....|. ref_or|
|00005180| 64 65 72 5f 73 74 61 74 | 75 73 2e 74 61 62 00 74 |der_stat|us.tab.t|
|00005190| 00 0e b0 62 00 00 04 00 | 00 24 72 65 66 5f 6f 72 |...b....|.$ref_or|
|000051a0| 67 61 6e 69 7a 61 74 69 | 6f 6e 5f 74 79 70 65 2e |ganizati|on_type.|
|000051b0| 74 61 62 00 00 0e b0 63 | 00 00 04 24 00 24 72 65 |tab....c|...$.$re|
|000051c0| 66 5f 70 72 69 6d 61 72 | 79 5f 49 58 43 5f 63 6f |f_primar|y_IXC_co|
|000051d0| 64 65 2e 74 61 62 00 63 | 00 0e b0 64 00 00 04 44 |de.tab.c|...d...D|
|000051e0| 00 20 72 65 66 5f 70 72 | 69 6f 72 69 74 79 5f 63 |. ref_pr|iority_c|
|000051f0| 6f 64 65 2e 74 61 62 00 | 00 0e b0 65 00 00 04 6c |ode.tab.|...e...l|
|00005200| 2e 2f 76 32 5f 63 6d 73 | 2f 74 61 62 6c 65 2f 72 |./v2_cms|/table/r|
|00005210| 65 66 5f 74 61 62 6c 65 | 2f 72 65 66 5f 64 65 66 |ef_table|/ref_def|
|00005220| 61 75 6c 74 5f 73 74 61 | 74 75 73 2e 74 61 62 00 |ault_sta|tus.tab.|
|00005230| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005240| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005250| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005260| 00 00 00 00 30 31 30 30 | 36 36 34 00 30 30 30 30 |....0100|664.0000|
|00005270| 30 31 33 00 30 30 31 33 | 35 36 33 00 30 30 30 30 |013.0013|563.0000|
|00005280| 30 30 30 30 34 33 30 00 | 30 35 37 30 33 30 34 33 |0000430.|05703043|
|00005290| 37 35 32 00 30 30 32 32 | 36 33 36 00 30 00 00 00 |752.0022|636.0...|
|000052a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000052b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000052c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000052d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000052e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000052f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005300| 00 75 73 74 61 72 00 30 | 30 73 79 62 61 73 65 00 |.ustar.0|0sybase.|
|00005310| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005320| 00 00 00 00 00 00 00 00 | 00 73 79 62 61 73 65 00 |........|.sybase.|
|00005330| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005340| 00 00 00 00 00 00 00 00 | 00 30 30 30 30 30 34 30 |........|.0000040|
|00005350| 00 30 30 30 30 32 30 30 | 00 00 00 00 00 00 00 00 |.0000200|........|
|00005360| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005370| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005380| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005390| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000053a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000053b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000053c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000053d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000053e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000053f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005400| 2f 2a 20 53 43 43 53 20 | 49 6e 66 6f 72 6d 61 74 |/* SCCS |Informat|
|00005410| 69 6f 6e 3a 09 25 57 25 | 20 25 47 25 20 2a 2f 0a |ion:.%W%| %G% */.|
|00005420| 0a 75 73 65 20 76 32 5f | 63 6d 73 20 0a 67 6f 0a |.use v2_|cms .go.|
|00005430| 0a 69 66 20 65 78 69 73 | 74 73 20 28 73 65 6c 65 |.if exis|ts (sele|
|00005440| 63 74 20 31 20 66 72 6f | 6d 20 73 79 73 6f 62 6a |ct 1 fro|m sysobj|
|00005450| 65 63 74 73 0a 09 09 77 | 68 65 72 65 20 6e 61 6d |ects...w|here nam|
|00005460| 65 20 3d 20 22 72 65 66 | 5f 64 65 66 61 75 6c 74 |e = "ref|_default|
|00005470| 5f 73 74 61 74 75 73 22 | 20 61 6e 64 0a 09 09 20 |_status"| and... |
|00005480| 20 20 20 20 20 74 79 70 | 65 20 3d 20 22 55 22 29 |     typ|e = "U")|
|00005490| 0a 09 64 72 6f 70 20 74 | 61 62 6c 65 20 72 65 66 |..drop t|able ref|
|000054a0| 5f 64 65 66 61 75 6c 74 | 5f 73 74 61 74 75 73 0a |_default|_status.|
|000054b0| 0a 67 6f 0a 0a 63 72 65 | 61 74 65 20 74 61 62 6c |.go..cre|ate tabl|
|000054c0| 65 20 72 65 66 5f 64 65 | 66 61 75 6c 74 5f 73 74 |e ref_de|fault_st|
|000054d0| 61 74 75 73 20 28 0a 09 | 73 74 61 74 75 73 09 09 |atus (..|status..|
|000054e0| 63 6f 64 65 09 09 4e 4f | 54 20 4e 55 4c 4c 2c 0a |code..NO|T NULL,.|
|000054f0| 09 64 65 73 63 72 69 70 | 74 69 6f 6e 09 76 61 72 |.descrip|tion.var|
|00005500| 63 68 61 72 28 35 30 29 | 09 4e 4f 54 20 4e 55 4c |char(50)|.NOT NUL|
|00005510| 4c 0a 29 0a 0a 67 6f 0a | 00 00 03 90 00 20 72 65 |L.)..go.|..... re|
|00005520| 66 5f 6f 72 64 65 72 5f | 72 65 61 73 6f 6e 2e 74 |f_order_|reason.t|
|00005530| 61 62 00 5f 00 0e b0 60 | 00 00 03 ac 00 20 72 65 |ab._...`|..... re|
|00005540| 66 5f 70 61 79 5f 6d 65 | 74 68 6f 64 2e 74 61 62 |f_pay_me|thod.tab|
|00005550| 00 0e b0 60 00 0e b0 61 | 00 00 03 cc 00 20 72 65 |...`...a|..... re|
|00005560| 66 5f 6f 72 64 65 72 5f | 73 74 61 74 75 73 2e 74 |f_order_|status.t|
|00005570| 61 62 00 61 00 0e b0 62 | 00 00 04 00 00 24 72 65 |ab.a...b|.....$re|
|00005580| 66 5f 6f 72 67 61 6e 69 | 7a 61 74 69 6f 6e 5f 74 |f_organi|zation_t|
|00005590| 79 70 65 2e 74 61 62 00 | 00 0e b0 63 00 00 04 24 |ype.tab.|...c...$|
|000055a0| 00 24 72 65 66 5f 70 72 | 69 6d 61 72 79 5f 49 58 |.$ref_pr|imary_IX|
|000055b0| 43 5f 63 6f 64 65 2e 74 | 61 62 00 24 00 0e b0 64 |C_code.t|ab.$...d|
|000055c0| 00 00 04 44 00 20 72 65 | 66 5f 70 72 69 6f 72 69 |...D. re|f_priori|
|000055d0| 74 79 5f 63 6f 64 65 2e | 74 61 62 00 00 0e b0 65 |ty_code.|tab....e|
|000055e0| 00 00 04 6c 00 2c 72 65 | 66 5f 70 72 6f 64 5f 72 |...l.,re|f_prod_r|
|000055f0| 65 6c 61 74 69 6f 6e 73 | 68 69 70 5f 63 6f 64 65 |elations|hip_code|
|00005600| 2e 2f 76 32 5f 63 6d 73 | 2f 74 61 62 6c 65 2f 72 |./v2_cms|/table/r|
|00005610| 65 66 5f 74 61 62 6c 65 | 2f 72 65 66 5f 61 64 64 |ef_table|/ref_add|
|00005620| 72 65 73 73 5f 74 79 70 | 65 2e 74 61 62 00 00 00 |ress_typ|e.tab...|
|00005630| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005640| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005650| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005660| 00 00 00 00 30 31 30 30 | 36 36 34 00 30 30 30 30 |....0100|664.0000|
|00005670| 30 31 33 00 30 30 31 33 | 35 36 33 00 30 30 30 30 |013.0013|563.0000|
|00005680| 30 30 30 30 34 32 31 00 | 30 35 37 30 33 30 34 33 |0000421.|05703043|
|00005690| 37 35 30 00 30 30 32 32 | 32 37 33 00 30 00 00 00 |750.0022|273.0...|
|000056a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000056b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000056c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000056d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000056e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000056f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005700| 00 75 73 74 61 72 00 30 | 30 73 79 62 61 73 65 00 |.ustar.0|0sybase.|
|00005710| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005720| 00 00 00 00 00 00 00 00 | 00 73 79 62 61 73 65 00 |........|.sybase.|
|00005730| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005740| 00 00 00 00 00 00 00 00 | 00 30 30 30 30 30 34 30 |........|.0000040|
|00005750| 00 30 30 30 30 32 30 30 | 00 00 00 00 00 00 00 00 |.0000200|........|
|00005760| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005770| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005780| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005790| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000057a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000057b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000057c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000057d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000057e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000057f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005800| 2f 2a 20 53 43 43 53 20 | 49 6e 66 6f 72 6d 61 74 |/* SCCS |Informat|
|00005810| 69 6f 6e 3a 09 25 57 25 | 20 25 47 25 20 2a 2f 0a |ion:.%W%| %G% */.|
|00005820| 0a 75 73 65 20 76 32 5f | 63 6d 73 20 0a 67 6f 0a |.use v2_|cms .go.|
|00005830| 0a 69 66 20 65 78 69 73 | 74 73 20 28 73 65 6c 65 |.if exis|ts (sele|
|00005840| 63 74 20 31 20 66 72 6f | 6d 20 73 79 73 6f 62 6a |ct 1 fro|m sysobj|
|00005850| 65 63 74 73 0a 09 09 77 | 68 65 72 65 20 6e 61 6d |ects...w|here nam|
|00005860| 65 20 3d 20 22 72 65 66 | 5f 61 64 64 72 65 73 73 |e = "ref|_address|
|00005870| 5f 74 79 70 65 22 20 61 | 6e 64 0a 09 09 20 20 20 |_type" a|nd...   |
|00005880| 20 20 20 74 79 70 65 20 | 3d 20 22 55 22 29 0a 09 |   type |= "U")..|
|00005890| 64 72 6f 70 20 74 61 62 | 6c 65 20 72 65 66 5f 61 |drop tab|le ref_a|
|000058a0| 64 64 72 65 73 73 5f 74 | 79 70 65 0a 0a 67 6f 0a |ddress_t|ype..go.|
|000058b0| 0a 63 72 65 61 74 65 20 | 74 61 62 6c 65 20 72 65 |.create |table re|
|000058c0| 66 5f 61 64 64 72 65 73 | 73 5f 74 79 70 65 20 0a |f_addres|s_type .|
|000058d0| 28 0a 09 74 79 70 65 09 | 09 63 6f 64 65 09 09 4e |(..type.|.code..N|
|000058e0| 4f 54 20 4e 55 4c 4c 2c | 0a 09 64 65 73 63 72 69 |OT NULL,|..descri|
|000058f0| 70 74 69 6f 6e 09 76 61 | 72 63 68 61 72 28 35 30 |ption.va|rchar(50|
|00005900| 29 09 4e 4f 54 20 4e 55 | 4c 4c 0a 29 0a 0a 67 6f |).NOT NU|LL.)..go|
|00005910| 0a 0e b0 60 00 00 03 ac | 00 20 72 65 66 5f 70 61 |...`....|. ref_pa|
|00005920| 79 5f 6d 65 74 68 6f 64 | 2e 74 61 62 00 6e 2e 74 |y_method|.tab.n.t|
|00005930| 00 0e b0 61 00 00 03 cc | 00 20 72 65 66 5f 6f 72 |...a....|. ref_or|
|00005940| 64 65 72 5f 73 74 61 74 | 75 73 2e 74 61 62 00 62 |der_stat|us.tab.b|
|00005950| 00 0e b0 62 00 00 04 00 | 00 24 72 65 66 5f 6f 72 |...b....|.$ref_or|
|00005960| 67 61 6e 69 7a 61 74 69 | 6f 6e 5f 74 79 70 65 2e |ganizati|on_type.|
|00005970| 74 61 62 00 00 0e b0 63 | 00 00 04 24 00 24 72 65 |tab....c|...$.$re|
|00005980| 66 5f 70 72 69 6d 61 72 | 79 5f 49 58 43 5f 63 6f |f_primar|y_IXC_co|
|00005990| 64 65 2e 74 61 62 00 00 | 00 0e b0 64 00 00 04 44 |de.tab..|...d...D|
|000059a0| 00 20 72 65 66 5f 70 72 | 69 6f 72 69 74 79 5f 63 |. ref_pr|iority_c|
|000059b0| 6f 64 65 2e 74 61 62 00 | 00 0e b0 65 00 00 04 6c |ode.tab.|...e...l|
|000059c0| 00 2c 72 65 66 5f 70 72 | 6f 64 5f 72 65 6c 61 74 |.,ref_pr|od_relat|
|000059d0| 69 6f 6e 73 68 69 70 5f | 63 6f 64 65 2e 74 61 62 |ionship_|code.tab|
|000059e0| 00 00 04 6c 00 0e b0 66 | 00 00 04 84 00 1c 72 65 |...l...f|......re|
|000059f0| 66 5f 70 72 6f 64 75 63 | 74 2e 74 61 62 00 64 65 |f_produc|t.tab.de|
|00005a00| 2e 2f 76 32 5f 63 6d 73 | 2f 74 61 62 6c 65 2f 72 |./v2_cms|/table/r|
|00005a10| 65 66 5f 74 61 62 6c 65 | 2f 72 65 66 5f 65 6d 70 |ef_table|/ref_emp|
|00005a20| 6c 6f 79 6d 65 6e 74 5f | 74 79 70 65 2e 74 61 62 |loyment_|type.tab|
|00005a30| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005a40| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005a50| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005a60| 00 00 00 00 30 31 30 30 | 36 36 34 00 30 30 30 30 |....0100|664.0000|
|00005a70| 30 31 33 00 30 30 31 33 | 35 36 33 00 30 30 30 30 |013.0013|563.0000|
|00005a80| 30 30 30 30 34 33 31 00 | 30 35 37 30 33 30 34 33 |0000431.|05703043|
|00005a90| 37 35 32 00 30 30 32 33 | 30 34 32 00 30 00 00 00 |752.0023|042.0...|
|00005aa0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005ab0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005ac0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005ad0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005ae0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005af0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005b00| 00 75 73 74 61 72 00 30 | 30 73 79 62 61 73 65 00 |.ustar.0|0sybase.|
|00005b10| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005b20| 00 00 00 00 00 00 00 00 | 00 73 79 62 61 73 65 00 |........|.sybase.|
|00005b30| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005b40| 00 00 00 00 00 00 00 00 | 00 30 30 30 30 30 34 30 |........|.0000040|
|00005b50| 00 30 30 30 30 32 30 30 | 00 00 00 00 00 00 00 00 |.0000200|........|
|00005b60| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005b70| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005b80| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005b90| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005ba0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005bb0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005bc0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005bd0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005be0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005bf0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005c00| 2f 2a 20 53 43 43 53 20 | 49 6e 66 6f 72 6d 61 74 |/* SCCS |Informat|
|00005c10| 69 6f 6e 3a 09 25 57 25 | 20 25 47 25 20 2a 2f 0a |ion:.%W%| %G% */.|
|00005c20| 0a 75 73 65 20 76 32 5f | 63 6d 73 20 0a 67 6f 0a |.use v2_|cms .go.|
|00005c30| 0a 69 66 20 65 78 69 73 | 74 73 20 28 73 65 6c 65 |.if exis|ts (sele|
|00005c40| 63 74 20 31 20 66 72 6f | 6d 20 73 79 73 6f 62 6a |ct 1 fro|m sysobj|
|00005c50| 65 63 74 73 0a 09 09 77 | 68 65 72 65 20 6e 61 6d |ects...w|here nam|
|00005c60| 65 20 3d 20 22 72 65 66 | 5f 65 6d 70 6c 6f 79 6d |e = "ref|_employm|
|00005c70| 65 6e 74 5f 74 79 70 65 | 22 20 61 6e 64 0a 09 09 |ent_type|" and...|
|00005c80| 20 20 20 20 20 20 74 79 | 70 65 20 3d 20 22 55 22 |      ty|pe = "U"|
|00005c90| 29 0a 09 64 72 6f 70 20 | 74 61 62 6c 65 20 72 65 |)..drop |table re|
|00005ca0| 66 5f 65 6d 70 6c 6f 79 | 6d 65 6e 74 5f 74 79 70 |f_employ|ment_typ|
|00005cb0| 65 0a 0a 67 6f 0a 0a 63 | 72 65 61 74 65 20 74 61 |e..go..c|reate ta|
|00005cc0| 62 6c 65 20 72 65 66 5f | 65 6d 70 6c 6f 79 6d 65 |ble ref_|employme|
|00005cd0| 6e 74 5f 74 79 70 65 20 | 28 0a 09 74 79 70 65 09 |nt_type |(..type.|
|00005ce0| 09 63 6f 64 65 09 09 4e | 4f 54 20 4e 55 4c 4c 2c |.code..N|OT NULL,|
|00005cf0| 0a 09 64 65 73 63 72 69 | 70 74 69 6f 6e 09 76 61 |..descri|ption.va|
|00005d00| 72 63 68 61 72 28 35 30 | 29 09 4e 4f 54 20 4e 55 |rchar(50|).NOT NU|
|00005d10| 4c 4c 0a 29 0a 0a 67 6f | 0a 20 72 65 66 5f 6f 72 |LL.)..go|. ref_or|
|00005d20| 64 65 72 5f 73 74 61 74 | 75 73 2e 74 61 62 00 74 |der_stat|us.tab.t|
|00005d30| 00 0e b0 62 00 00 04 00 | 00 24 72 65 66 5f 6f 72 |...b....|.$ref_or|
|00005d40| 67 61 6e 69 7a 61 74 69 | 6f 6e 5f 74 79 70 65 2e |ganizati|on_type.|
|00005d50| 74 61 62 00 00 0e b0 63 | 00 00 04 24 00 24 72 65 |tab....c|...$.$re|
|00005d60| 66 5f 70 72 69 6d 61 72 | 79 5f 49 58 43 5f 63 6f |f_primar|y_IXC_co|
|00005d70| 64 65 2e 74 61 62 00 63 | 00 0e b0 64 00 00 04 44 |de.tab.c|...d...D|
|00005d80| 00 20 72 65 66 5f 70 72 | 69 6f 72 69 74 79 5f 63 |. ref_pr|iority_c|
|00005d90| 6f 64 65 2e 74 61 62 00 | 00 0e b0 65 00 00 04 6c |ode.tab.|...e...l|
|00005da0| 00 2c 72 65 66 5f 70 72 | 6f 64 5f 72 65 6c 61 74 |.,ref_pr|od_relat|
|00005db0| 69 6f 6e 73 68 69 70 5f | 63 6f 64 65 2e 74 61 62 |ionship_|code.tab|
|00005dc0| 00 2c 72 65 00 0e b0 66 | 00 00 04 84 00 1c 72 65 |.,re...f|......re|
|00005dd0| 66 5f 70 72 6f 64 75 63 | 74 2e 74 61 62 00 61 62 |f_produc|t.tab.ab|
|00005de0| 00 0e b0 67 00 00 04 a4 | 00 20 72 65 66 5f 70 72 |...g....|. ref_pr|
|00005df0| 6f 64 75 63 74 5f 74 79 | 70 65 2e 74 61 62 00 65 |oduct_ty|pe.tab.e|
|00005e00| 2e 2f 76 32 5f 63 6d 73 | 2f 74 61 62 6c 65 2f 72 |./v2_cms|/table/r|
|00005e10| 65 66 5f 74 61 62 6c 65 | 2f 72 65 66 5f 67 65 6e |ef_table|/ref_gen|
|00005e20| 64 65 72 5f 74 79 70 65 | 2e 74 61 62 00 00 00 00 |der_type|.tab....|
|00005e30| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005e40| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005e50| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005e60| 00 00 00 00 30 31 30 30 | 36 36 34 00 30 30 30 30 |....0100|664.0000|
|00005e70| 30 31 33 00 30 30 31 33 | 35 36 33 00 30 30 30 30 |013.0013|563.0000|
|00005e80| 30 30 30 30 34 33 30 00 | 30 35 37 30 33 30 34 33 |0000430.|05703043|
|00005e90| 37 35 32 00 30 30 32 32 | 31 31 34 00 30 00 00 00 |752.0022|114.0...|
|00005ea0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005eb0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005ec0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005ed0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005ee0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005ef0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005f00| 00 75 73 74 61 72 00 30 | 30 73 79 62 61 73 65 00 |.ustar.0|0sybase.|
|00005f10| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005f20| 00 00 00 00 00 00 00 00 | 00 73 79 62 61 73 65 00 |........|.sybase.|
|00005f30| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005f40| 00 00 00 00 00 00 00 00 | 00 30 30 30 30 30 34 30 |........|.0000040|
|00005f50| 00 30 30 30 30 32 30 30 | 00 00 00 00 00 00 00 00 |.0000200|........|
|00005f60| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005f70| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005f80| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005f90| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005fa0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005fb0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005fc0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005fd0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005fe0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005ff0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00006000| 2f 2a 20 53 43 43 53 20 | 49 6e 66 6f 72 6d 61 74 |/* SCCS |Informat|
|00006010| 69 6f 6e 3a 09 25 57 25 | 20 25 47 25 20 2a 2f 0a |ion:.%W%| %G% */.|
|00006020| 0a 75 73 65 20 76 32 5f | 63 6d 73 20 0a 67 6f 0a |.use v2_|cms .go.|
|00006030| 0a 69 66 20 65 78 69 73 | 74 73 20 28 73 65 6c 65 |.if exis|ts (sele|
|00006040| 63 74 20 2a 20 66 72 6f | 6d 20 73 79 73 6f 62 6a |ct * fro|m sysobj|
|00006050| 65 63 74 73 20 77 68 65 | 72 65 0a 20 20 20 6e 61 |ects whe|re.   na|
|00006060| 6d 65 20 3d 20 22 72 65 | 66 5f 67 65 6e 64 65 72 |me = "re|f_gender|
|00006070| 5f 74 79 70 65 22 20 61 | 6e 64 20 74 79 70 65 20 |_type" a|nd type |
|00006080| 3d 20 22 55 22 29 0a 20 | 20 44 52 4f 50 20 54 41 |= "U"). | DROP TA|
|00006090| 42 4c 45 20 72 65 66 5f | 67 65 6e 64 65 72 5f 74 |BLE ref_|gender_t|
|000060a0| 79 70 65 0a 67 6f 0a 0a | 43 52 45 41 54 45 20 54 |ype.go..|CREATE T|
|000060b0| 41 42 4c 45 20 72 65 66 | 5f 67 65 6e 64 65 72 5f |ABLE ref|_gender_|
|000060c0| 74 79 70 65 0a 20 20 20 | 20 20 20 28 74 79 70 65 |type.   |   (type|
|000060d0| 20 20 20 20 20 20 63 68 | 61 72 28 31 29 20 4e 4f |      ch|ar(1) NO|
|000060e0| 54 20 4e 55 4c 4c 2c 0a | 20 20 20 20 20 20 20 64 |T NULL,.|       d|
|000060f0| 65 73 63 72 69 70 74 69 | 6f 6e 20 20 20 20 20 76 |escripti|on     v|
|00006100| 61 72 63 68 61 72 28 37 | 29 20 4e 4f 54 20 4e 55 |archar(7|) NOT NU|
|00006110| 4c 4c 0a 29 0a 67 6f 0a | 66 5f 6f 72 67 61 6e 69 |LL.).go.|f_organi|
|00006120| 7a 61 74 69 6f 6e 5f 74 | 79 70 65 2e 74 61 62 00 |zation_t|ype.tab.|
|00006130| 00 0e b0 63 00 00 04 24 | 00 24 72 65 66 5f 70 72 |...c...$|.$ref_pr|
|00006140| 69 6d 61 72 79 5f 49 58 | 43 5f 63 6f 64 65 2e 74 |imary_IX|C_code.t|
|00006150| 61 62 00 00 00 0e b0 64 | 00 00 04 44 00 20 72 65 |ab.....d|...D. re|
|00006160| 66 5f 70 72 69 6f 72 69 | 74 79 5f 63 6f 64 65 2e |f_priori|ty_code.|
|00006170| 74 61 62 00 00 0e b0 65 | 00 00 04 6c 00 2c 72 65 |tab....e|...l.,re|
|00006180| 66 5f 70 72 6f 64 5f 72 | 65 6c 61 74 69 6f 6e 73 |f_prod_r|elations|
|00006190| 68 69 70 5f 63 6f 64 65 | 2e 74 61 62 00 00 04 6c |hip_code|.tab...l|
|000061a0| 00 0e b0 66 00 00 04 84 | 00 1c 72 65 66 5f 70 72 |...f....|..ref_pr|
|000061b0| 6f 64 75 63 74 2e 74 61 | 62 00 64 65 00 0e b0 67 |oduct.ta|b.de...g|
|000061c0| 00 00 04 a4 00 20 72 65 | 66 5f 70 72 6f 64 75 63 |..... re|f_produc|
|000061d0| 74 5f 74 79 70 65 2e 74 | 61 62 00 61 00 0e b0 68 |t_type.t|ab.a...h|
|000061e0| 00 00 04 c4 00 20 72 65 | 66 5f 72 65 71 75 65 73 |..... re|f_reques|
|000061f0| 74 5f 74 79 70 65 2e 74 | 61 62 00 74 00 0e b0 69 |t_type.t|ab.t...i|
|00006200| 2e 2f 76 32 5f 63 6d 73 | 2f 74 61 62 6c 65 2f 72 |./v2_cms|/table/r|
|00006210| 65 66 5f 74 61 62 6c 65 | 2f 72 65 66 5f 68 61 6e |ef_table|/ref_han|
|00006220| 64 69 63 61 70 2e 74 61 | 62 00 00 00 00 00 00 00 |dicap.ta|b.......|
|00006230| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00006240| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00006250| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00006260| 00 00 00 00 30 31 30 30 | 36 36 34 00 30 30 30 30 |....0100|664.0000|
|00006270| 30 31 33 00 30 30 31 33 | 35 36 33 00 30 30 30 30 |013.0013|563.0000|
|00006280| 30 30 30 30 34 32 35 00 | 30 35 37 30 33 30 34 33 |0000425.|05703043|
|00006290| 37 35 33 00 30 30 32 31 | 33 36 33 00 30 00 00 00 |753.0021|363.0...|
|000062a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000062b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000062c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000062d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000062e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000062f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00006300| 00 75 73 74 61 72 00 30 | 30 73 79 62 61 73 65 00 |.ustar.0|0sybase.|
|00006310| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00006320| 00 00 00 00 00 00 00 00 | 00 73 79 62 61 73 65 00 |........|.sybase.|
|00006330| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00006340| 00 00 00 00 00 00 00 00 | 00 30 30 30 30 30 34 30 |........|.0000040|
|00006350| 00 30 30 30 30 32 30 30 | 00 00 00 00 00 00 00 00 |.0000200|........|
|00006360| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00006370| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00006380| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00006390| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000063a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000063b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000063c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000063d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000063e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000063f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
+--------+-------------------------+-------------------------+--------+--------+
Only 25.0 KB of data is shown above.