From ec16e50b394e928b6810d6d3867de6d6ef918ce5 Mon Sep 17 00:00:00 2001 From: ivan Date: Sat, 19 Mar 2011 02:00:07 +0000 Subject: [PATCH] svc_external.id s/int/bigint/ RT#12060 --- FS/FS/Schema.pm | 34 +++++++++++++++++----------------- 1 file changed, 17 insertions(+), 17 deletions(-) diff --git a/FS/FS/Schema.pm b/FS/FS/Schema.pm index ecfb0e4d2..2bfe11a08 100644 --- a/FS/FS/Schema.pm +++ b/FS/FS/Schema.pm @@ -994,21 +994,21 @@ sub tables_hashref { #for now, just cust_pkg locations 'cust_location' => { #'location' now that its prospects too, but... 'columns' => [ - 'locationnum', 'serial', '', '', '', '', - 'prospectnum', 'int', 'NULL', '', '', '', - 'custnum', 'int', 'NULL', '', '', '', - 'address1', 'varchar', '', $char_d, '', '', - 'address2', 'varchar', 'NULL', $char_d, '', '', - 'city', 'varchar', '', $char_d, '', '', - 'county', 'varchar', 'NULL', $char_d, '', '', - 'state', 'varchar', 'NULL', $char_d, '', '', - 'zip', 'varchar', 'NULL', 10, '', '', - 'country', 'char', '', 2, '', '', - 'geocode', 'varchar', 'NULL', 20, '', '', - 'location_type', 'varchar', 'NULL', 20, '', '', - 'location_number', 'varchar', 'NULL', 20, '', '', - 'location_kind', 'char', 'NULL', 1, '', '', - 'disabled', 'char', 'NULL', 1, '', '', + 'locationnum', 'serial', '', '', '', '', + 'prospectnum', 'int', 'NULL', '', '', '', + 'custnum', 'int', 'NULL', '', '', '', + 'address1', 'varchar', '', $char_d, '', '', + 'address2', 'varchar', 'NULL', $char_d, '', '', + 'city', 'varchar', '', $char_d, '', '', + 'county', 'varchar', 'NULL', $char_d, '', '', + 'state', 'varchar', 'NULL', $char_d, '', '', + 'zip', 'varchar', 'NULL', 10, '', '', + 'country', 'char', '', 2, '', '', + 'geocode', 'varchar', 'NULL', 20, '', '', + 'location_type', 'varchar', 'NULL', 20, '', '', + 'location_number', 'varchar', 'NULL', 20, '', '', + 'location_kind', 'char', 'NULL', 1, '', '', + 'disabled', 'char', 'NULL', 1, '', '', ], 'primary_key' => 'locationnum', 'unique' => [], @@ -2410,8 +2410,8 @@ sub tables_hashref { 'svc_external' => { 'columns' => [ - 'svcnum', 'int', '', '', '', '', - 'id', 'int', 'NULL', '', '', '', + 'svcnum', 'int', '', '', '', '', + 'id', 'bigint', 'NULL', '', '', '', 'title', 'varchar', 'NULL', $char_d, '', '', ], 'primary_key' => 'svcnum', -- 2.11.0