| 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/mysql/ |
Upload File : |
#!/usr/bin/perl
# create_table.cgi
# Create a new table
require './mysql-lib.pl';
&ReadParse();
&can_edit_db($in{'db'}) || &error($text{'dbase_ecannot'});
$access{'edonly'} && &error($text{'dbase_ecannot'});
&error_setup($text{'table_err'});
$in{'name'} =~ /^\S+$/ || &error($text{'table_ename'});
if ($in{'copy'} || $in{'copytable'}) {
local ($db, $table) = $in{'copy'} ? split(/\./, $in{'copy'})
: ($in{'copydb'}, $in{'copytable'});
foreach $f (&table_structure($db, $table)) {
local $copy = "estr($f->{'field'})." $f->{'type'}";
$copy .= " not null" if (!$f->{'null'});
if ($f->{'key'} eq 'PRI') {
$copy .= " primary key";
}
$copy .= " default '$f->{'default'}'"
if ($f->{'default'} ne '' && $f->{'default'} ne 'NULL');
$copy .= " $f->{'extra'}" if ($f->{'extra'});
push(@fields, $copy);
}
}
@sql = &parse_table_form(\@fields, $in{'name'});
foreach $sql (@sql) {
&execute_sql_logged($in{'db'}, $sql);
}
&webmin_log("create", "table", $in{'name'}, \%in);
&redirect("edit_dbase.cgi?db=$in{'db'}");