-- $Id: update019-020.sql,v 1.4 2004/11/24 11:12:33 carneeki Exp $

-- Drop unused table: actions
DROP TABLE `actions`;

-- Drop redundant table: nessus_multiple
DROP TABLE `nessus_multiple`;

-- Drop unused table: nessus_servers_actions
DROP TABLE `nessus_servers_actions`;

-- Drop unused table: nessus_servers_actions
ALTER TABLE `nessus_settings_preferences`,
  CHANGE `id` `id` varchar(255)   NULL ,
  DROP PRIMARY KEY;

-- Modify table: nessus_preferences
ALTER TABLE `nessus_preferences`,
  DROP PRIMARY KEY,
  ADD PRIMARY KEY (nessus_id);

-- Update table: inprotect_settings
-- For inprotect version

UPDATE `inprotect_settings` SET `version`="0.20";
