-my $status = $dbi->selectall_arrayref("SHOW COLUMNS FROM $table WHERE Field = 'freesidestatus'");
-if( ! @$status ) {
- print "Adding freesidestatus column...\n";
- $dbi->do("ALTER TABLE $table ADD COLUMN freesidestatus varchar(32)")
- or die $dbi->errstr;
+
+# check for existence of freesidestatus
+if ( $engine =~ /^mysql/ ) {
+ my $status = $dbi->selectall_arrayref("SHOW COLUMNS FROM $table WHERE Field = 'freesidestatus'");
+ if( ! @$status ) {
+ log_msg( warn => "Adding freesidestatus column" );
+ $dbi->do("ALTER TABLE $table ADD COLUMN freesidestatus varchar(32)")
+ or log_and_die( error => $dbi->errstr );
+ } else {
+ log_msg( info => "freesidestatus column present" );
+ }
+}
+
+my @cols = ();
+if ( $opt{V} >= 12 ) {
+
+ push @cols, qw( id )
+ unless $opt{Q};
+
+ push @cols, qw( start answer );
+
+ if ( $engine =~ /^Pg/ ) {
+ push @cols, "'end'";
+ } else {
+ push @cols, "end";
+ }
+
+} else {
+ push @cols, qw( calldate );