at 1686
1686 $sth=$dbh->prepare("CREATE TABLE ".SQL_ADMIN_TABLE." (".
"num ".get_sql_autoincrement().",". # Entry number, auto-increments
"type TEXT,". # Type of entry (ipban, wordban, etc)
"comment TEXT,". # Comment for the entry
"ival1 TEXT,". # Integer value 1 (usually IP)
"ival2 TEXT,". # Integer value 2 (usually netmask)
"sval1 TEXT". # String value 1
");") or make_error(S_SQLFAIL);
at 1794
sub table_exists($)
{
my ($table)=@_;
my ($sth);
1794 return 0 unless($sth=$dbh->prepare("SELECT * FROM ".$table." LIMIT 1;"));
return 0 unless($sth->execute());
return 1;
}
looks like i have to create tables manually? if so, how to?