| Server IP : 49.231.201.246 / Your IP : 216.73.216.149 Web Server : Apache/2.4.18 (Ubuntu) System : Linux 246 4.4.0-210-generic #242-Ubuntu SMP Fri Apr 16 09:57:56 UTC 2021 x86_64 User : root ( 0) PHP Version : 7.0.33-0ubuntu0.16.04.16 Disable Function : exec,passthru,shell_exec,system,proc_open,popen,pcntl_exec MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /usr/share/webmin/postgresql/ |
Upload File : |
#!/usr/bin/perl
# create_table.cgi
# Create a new table
require './postgresql-lib.pl';
&ReadParse();
&can_edit_db($in{'db'}) || &error($text{'dbase_ecannot'});
&error_setup($text{'table_err'});
$in{'name'} =~ /^\S+$/ || &error($text{'table_ename'});
for($i=0; defined($in{"field_$i"}); $i++) {
next if (!$in{"field_$i"});
$in{"field_$i"} =~ /^\S+$/ ||
&error(&text('table_efield', $in{"field_$i"}));
$in{"type_$i"} || &error(&text('table_etype', $in{"field_$i"}));
if ($in{"size_$i"}) {
if (&is_blob({ 'type' => $in{"type_$i"} })) {
&error(&text('table_eblob', $in{"field_$i"}));
}
$f = sprintf "\"%s\" %s(%s)",
$in{"field_$i"}, $in{"type_$i"}, $in{"size_$i"};
}
else {
$f = sprintf "\"%s\" %s", $in{"field_$i"}, $in{"type_$i"};
}
if ($in{"arr_$i"}) { $f .= "[]"; }
if (!$in{"null_$i"}) { $f .= " not null"; }
if ($in{"key_$i"}) { $f .= " primary key"; }
if ($in{"uniq_$i"}) { $f .= " unique"; }
push(@fields, $f);
}
@fields || &error($text{'table_enone'});
$qt = "e_table($in{'name'});
$sql = "create table $qt (".join(",", @fields).")";
&execute_sql_logged($in{'db'}, $sql);
&webmin_log("create", "table", $in{'name'}, \%in);
&redirect("edit_dbase.cgi?db=$in{'db'}");