diff options
| author | ivan <ivan> | 2004-03-12 05:56:12 +0000 |
|---|---|---|
| committer | ivan <ivan> | 2004-03-12 05:56:12 +0000 |
| commit | c9feafc6adba0455c2bc701c6524742df5c940bf (patch) | |
| tree | a89eca05ae543767158341fbb28d8634bab0600d /FS/bin | |
| parent | 36d6c3292b82db7973c5824dfc2e8877f72d05eb (diff) | |
backport some not-incompatible schema changes from 1.5
Diffstat (limited to 'FS/bin')
| -rwxr-xr-x | FS/bin/freeside-setup | 16 |
1 files changed, 8 insertions, 8 deletions
diff --git a/FS/bin/freeside-setup b/FS/bin/freeside-setup index 213dcb947..a6c9a0420 100755 --- a/FS/bin/freeside-setup +++ b/FS/bin/freeside-setup @@ -436,7 +436,7 @@ sub tables_hash_hack { 'custnum', 'int', '', '', '_date', @date_type, 'amount', @money_type, - 'otaker', 'varchar', '', 8, + 'otaker', 'varchar', '', 32, 'reason', 'text', 'NULL', '', 'closed', 'char', 'NULL', 1, ], @@ -466,7 +466,7 @@ sub tables_hash_hack { 'last', 'varchar', '', $char_d, # 'middle', 'varchar', 'NULL', $char_d, 'first', 'varchar', '', $char_d, - 'ss', 'char', 'NULL', 11, + 'ss', 'varchar', 'NULL', 11, 'company', 'varchar', 'NULL', $char_d, 'address1', 'varchar', '', $char_d, 'address2', 'varchar', 'NULL', $char_d, @@ -498,7 +498,7 @@ sub tables_hash_hack { 'paydate', 'varchar', 'NULL', 10, 'payname', 'varchar', 'NULL', $char_d, 'tax', 'char', 'NULL', 1, - 'otaker', 'varchar', '', 8, + 'otaker', 'varchar', '', 32, 'refnum', 'int', '', '', 'referral_custnum', 'int', 'NULL', '', 'comments', 'text', 'NULL', '', @@ -600,7 +600,7 @@ sub tables_hash_hack { 'pkgnum', 'int', '', '', 'custnum', 'int', '', '', 'pkgpart', 'int', '', '', - 'otaker', 'varchar', '', 8, + 'otaker', 'varchar', '', 32, 'setup', @date_type, 'bill', @date_type, 'susp', @date_type, @@ -620,7 +620,7 @@ sub tables_hash_hack { 'custnum', 'int', '', '', '_date', @date_type, 'refund', @money_type, - 'otaker', 'varchar', '', 8, + 'otaker', 'varchar', '', 32, 'reason', 'varchar', '', $char_d, 'payby', 'char', '', 4, # CARD/BILL/COMP, should be index # into payment type table. @@ -823,10 +823,10 @@ sub tables_hash_hack { 'columns' => [ 'recnum', 'int', '', '', 'svcnum', 'int', '', '', - 'reczone', 'varchar', '', $char_d, + 'reczone', 'varchar', '', 255, 'recaf', 'char', '', 2, - 'rectype', 'char', '', 5, - 'recdata', 'varchar', '', $char_d, + 'rectype', 'varchar', '', 5, + 'recdata', 'varchar', '', 255, ], 'primary_key' => 'recnum', 'unique' => [], |