Show default value when adding a row

diff --git a/mysql/view_table.cgi b/mysql/view_table.cgi
index 4f9ea3a..5941de6 100755 (executable)
--- a/mysql/view_table.cgi
+++ b/mysql/view_table.cgi
@@ -258,7 +258,9 @@ if ($total || $in{'new'}) {
        # Add an empty row for inserting
        $realrows = scalar(@data);
        if ($in{'new'}) {
-               push(@data, [ map { undef } @str ]);
+               push(@data, [ map { $_->{'default'} eq 'NULL' ? '' :
+                                   $_->{'default'} eq 'CURRENT_TIMESTAMP' ? '':
+                                     $_->{'default'} } @str ]);
                $row{$realrows} = 1;
                }