-- MySQL dump 10.10
--
-- Host: 127.0.0.1    Database: nessus
-- ------------------------------------------------------
-- Server version	5.0.24a

CREATE DATABASE `nessus`;
USE `nessus`;

--
-- Table structure for table `results`
--

DROP TABLE IF EXISTS `results`;
CREATE TABLE `results` (
  `id` int(11) NOT NULL auto_increment,
  `domain` varchar(40) NOT NULL default '',
  `host` varchar(40) NOT NULL default '',
  `service` varchar(255) NOT NULL default '',
  `scriptid` smallint(5) default NULL,
  `riskval` tinyint(1) default '0',
  `msg1` text,
  `msg2` text,
  PRIMARY KEY  (`id`),
  KEY `host` (`host`),
  KEY `host_2` (`host`,`service`)
) ENGINE=MyISAM;

--
-- Table structure for table `timestamps`
--

DROP TABLE IF EXISTS `timestamps`;
CREATE TABLE `timestamps` (
  `id` int(11) NOT NULL auto_increment,
  `unused` varchar(40) NOT NULL default '',
  `host` varchar(40) NOT NULL default '',
  `progress` varchar(40) NOT NULL default '',
  `timestamp` varchar(40) NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`),
  KEY `host` (`host`)
) ENGINE=MyISAM;