DROP TABLE NESSUS_PLUGINS CASCADE CONSTRAINTS ; 

CREATE TABLE NESSUS_PLUGINS ( 
  NESSUSID     NUMBER        NOT NULL, 
  FILE_NAME    VARCHAR2 (100)  NOT NULL, 
  NAME         VARCHAR2 (100)  NOT NULL, 
  FAMILY       VARCHAR2 (50), 
  CATEGORY     NUMBER, 
  SUMMARY      VARCHAR2 (2000), 
  DESCRIPTION  VARCHAR2 (4000), 
  CVE_ID       VARCHAR2 (16),
  BUGTRAQ_ID   NUMBER,
  COPYRIGHT    VARCHAR2 (150) ) ;




DROP TABLE NESSUS_REQUIRED_PORTS CASCADE CONSTRAINTS ; 

CREATE TABLE NESSUS_REQUIRED_PORTS ( 
  ID          NUMBER, 
  NESSUSID    NUMBER        NOT NULL, 
  PORT_VALUE  VARCHAR2 (80) ) ; 




DROP TABLE NESSUS_CHECK_DEPENDENCIES CASCADE CONSTRAINTS ; 

CREATE TABLE NESSUS_CHECK_DEPENDENCIES ( 
  ID        NUMBER, 
  NESSUSID  NUMBER        NOT NULL, 
  INDEP_ID  NUMBER        NOT NULL ) ; 
