| Server IP : 104.21.93.65 / Your IP : 104.23.243.50 Web Server : Apache System : Linux server.localhost.com 6.8.0-85-generic #85-Ubuntu SMP PREEMPT_DYNAMIC Thu Sep 18 15:26:59 UTC 2025 x86_64 User : pahana ( 1029) PHP Version : 7.4.33 Disable Function : pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_get_handler,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,pcntl_async_signals,pcntl_unshare, MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : OFF | Sudo : ON | Pkexec : OFF Directory : /usr/share/usermin/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'}");