39 lines
1.2 KiB
Perl
Executable File
39 lines
1.2 KiB
Perl
Executable File
#!/usr/local/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'}");
|
|
|
|
|