Since I actually use this and want to automate it, I propose these 2
simple change to make it work better. I am not sure if the "IF EXISTS"
works everywhere or not, so...
Index: nessus/cli.c
===================================================================
--- nessus/cli.c (revision 1597)
+++ nessus/cli.c (working copy)
@@ -558,7 +558,7 @@
cli_sql_dump_plugins(cli)
struct cli_args * cli;
{
- printf("DROP TABLE plugins;\n");
+ printf("DROP TABLE IF EXISTS plugins;\n");
printf("CREATE TABLE plugins (\n");
printf(" oid varchar(50) NOT NULL,\n");
printf(" name varchar(255),\n");
@@ -571,7 +571,7 @@
printf(" cve_id varchar(255),\n");
printf(" bugtraq_id varchar(255),\n");
printf(" xref blob,\n");
- printf(" primary key (id));\n");
+ printf(" primary key (oid));\n");
_cli_sql_dump_plugins(Context->plugins);
_cli_sql_dump_plugins(Context->scanners);
}
--
MadHat (at) Unspecific.com
"The true man wants two things: danger and play.
For that reason he wants woman, as the most dangerous plaything."
- Friedrich Nietzsche
_______________________________________________
Openvas-devel mailing list
Openvas-devel@wald.intevation.org
http://lists.wald.intevation.org/mailman/listinfo/openvas-devel
