X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=FS%2FFS%2FSchema.pm;h=95515cc6e9ecfd1fbbd9d41d727e89157f5850df;hb=81666084b755dcc1a5850f4df4501f300f6b364c;hp=26fa08dd0f68a426e452b233b7ea1588bea41320;hpb=4321924ff5a68868a7ee622920fd4bbd53d6475f;p=freeside.git diff --git a/FS/FS/Schema.pm b/FS/FS/Schema.pm index 26fa08dd0..95515cc6e 100644 --- a/FS/FS/Schema.pm +++ b/FS/FS/Schema.pm @@ -1190,6 +1190,8 @@ sub tables_hashref { 'paystate', 'varchar', 'NULL', $char_d, '', '', 'paytype', 'varchar', 'NULL', $char_d, '', '', 'payip', 'varchar', 'NULL', 15, '', '', + 'paycardtype', 'varchar', 'NULL', $char_d, '', '', + 'geocode', 'varchar', 'NULL', 20, '', '', 'censustract', 'varchar', 'NULL', 20, '', '', # 7 to save space? 'censusyear', 'char', 'NULL', 4, '', '', @@ -1231,6 +1233,7 @@ sub tables_hashref { [ 'archived' ], [ 'ship_locationnum' ], [ 'bill_locationnum' ], + [ 'paycardtype' ], ], }, @@ -3911,6 +3914,7 @@ sub tables_hashref { 'unique' => [], 'index' => [ [ 'calldate' ], [ 'src' ], [ 'dst' ], [ 'dcontext' ], [ 'charged_party' ], + [ 'startdate' ], [ 'lastapp' ], ['accountcode'], ['uniqueid'], ['carrierid'], ['cdrid'], [ 'sessionnum' ], [ 'subscriber' ],