varchars need a length or mysql is unhappy

[freeside.git] / FS / FS / Schema.pm

diff --git a/FS/FS/Schema.pm b/FS/FS/Schema.pm
index ceb0909..430efd9 100644 (file)
--- a/FS/FS/Schema.pm
+++ b/FS/FS/Schema.pm
@@ -1409,8 +1409,8 @@ sub tables_hashref {
 
     'fcc477map' => {
       'columns' => [
-        'formkey', 'varchar', '', '', '', '', 
-        'formvalue', 'text', 'NULL', '', '', '', 
+        'formkey',   'varchar',     '', 255, '', '',
+        'formvalue',    'text', 'NULL',  '', '', '',
       ],
       'primary_key' => 'formkey',
       'unique'      => [],
@@ -2868,6 +2868,7 @@ sub tables_hashref {
       'unique' => [],
       'index' => [ [ 'calldate' ],
                    [ 'src' ], [ 'dst' ], [ 'dcontext' ], [ 'charged_party' ],
+                   [ 'lastapp' ],
                    ['accountcode'], ['uniqueid'], ['carrierid'], ['cdrid'],
                    [ 'sessionnum' ], [ 'subscriber' ],
                    [ 'freesidestatus' ], [ 'freesiderewritestatus' ],