diff options
| author | ivan <ivan> | 1998-10-14 07:05:06 +0000 |
|---|---|---|
| committer | ivan <ivan> | 1998-10-14 07:05:06 +0000 |
| commit | d914c9c9f2e73f58c3bd9b70738747d2c7e6c05b (patch) | |
| tree | ca2a2976b5cabcc2247c50f208f42cb8e9352266 /bin/fs-setup | |
| parent | ecff5bc54b3e6be7a963af807ff39786bd3103f6 (diff) | |
1.1.4 release, fix postgresql
Diffstat (limited to 'bin/fs-setup')
| -rwxr-xr-x | bin/fs-setup | 12 |
1 files changed, 6 insertions, 6 deletions
diff --git a/bin/fs-setup b/bin/fs-setup index 45332d85c..22891ec0f 100755 --- a/bin/fs-setup +++ b/bin/fs-setup @@ -68,7 +68,7 @@ my($char_d) = 80; #default maxlength for text fields #my(@date_type) = ( 'timestamp', '', '' ); my(@date_type) = ( 'int', 'NULL', '' ); -my(@perl_type) = ( 'long varchar', 'NULL', '' ); +my(@perl_type) = ( 'varchar', 'NULL', '' ); my(@money_type); if (datasrc =~ m/Pg/) { #Pg can't do decimal(10,2) @money_type = ( 'money', '', '' ); @@ -315,7 +315,7 @@ sub tables_hash_hack { 'columns' => [ 'taxnum', 'int', '', '', 'state', 'char', '', 2, #two letters max in US... elsewhere? - 'county', 'varchar', '', $char_d, + 'county', 'varchar', 'NULL', $char_d, 'tax', 'real', '', '', #tax % ], 'primary_key' => 'taxnum', @@ -353,7 +353,7 @@ sub tables_hash_hack { 'state', 'char', '', 2, 'zip', 'varchar', '', 10, 'country', 'char', '', 2, - 'trancode', 'TINYINT', '', '', + 'trancode', 'int', '', '', 'cardnum', 'varchar', '', 16, 'exp', @date_type, 'payname', 'varchar', 'NULL', $char_d, @@ -476,8 +476,8 @@ sub tables_hash_hack { 'username', 'varchar', '', $username_len, #unique (& remove dup code) '_password', 'varchar', '', 25, #13 for encryped pw's plus ' *SUSPENDED* 'popnum', 'int', 'NULL', '', - 'uid', 'bigint', 'NULL', '', - 'gid', 'bigint', 'NULL', '', + 'uid', 'int', 'NULL', '', + 'gid', 'int', 'NULL', '', 'finger', 'varchar', 'NULL', $char_d, 'dir', 'varchar', 'NULL', $char_d, 'shell', 'varchar', 'NULL', $char_d, @@ -493,7 +493,7 @@ sub tables_hash_hack { 'columns' => [ 'svcnum', 'int', '', '', 'domsvc', 'int', '', '', - 'domuid', 'bigint', '', '', + 'domuid', 'int', '', '', 'domuser', 'varchar', '', $char_d, ], 'primary_key' => 'svcnum', |