spec/dummy/db/structure.sql in metasploit-credential-2.0.8 vs spec/dummy/db/structure.sql in metasploit-credential-2.0.9
- old
+ new
@@ -1,15 +1,20 @@
--
-- PostgreSQL database dump
--
+-- Dumped from database version 9.6.1
+-- Dumped by pg_dump version 9.6.1
+
SET statement_timeout = 0;
SET lock_timeout = 0;
+SET idle_in_transaction_session_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SET check_function_bodies = false;
SET client_min_messages = warning;
+SET row_security = off;
--
-- Name: plpgsql; Type: EXTENSION; Schema: -; Owner: -
--
@@ -28,11 +33,11 @@
SET default_tablespace = '';
SET default_with_oids = false;
--
--- Name: api_keys; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: api_keys; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE api_keys (
id integer NOT NULL,
token text,
@@ -59,11 +64,11 @@
ALTER SEQUENCE api_keys_id_seq OWNED BY api_keys.id;
--
--- Name: automatic_exploitation_match_results; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: automatic_exploitation_match_results; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE automatic_exploitation_match_results (
id integer NOT NULL,
match_id integer,
@@ -92,11 +97,11 @@
ALTER SEQUENCE automatic_exploitation_match_results_id_seq OWNED BY automatic_exploitation_match_results.id;
--
--- Name: automatic_exploitation_match_sets; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: automatic_exploitation_match_sets; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE automatic_exploitation_match_sets (
id integer NOT NULL,
workspace_id integer,
@@ -124,11 +129,11 @@
ALTER SEQUENCE automatic_exploitation_match_sets_id_seq OWNED BY automatic_exploitation_match_sets.id;
--
--- Name: automatic_exploitation_matches; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: automatic_exploitation_matches; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE automatic_exploitation_matches (
id integer NOT NULL,
module_detail_id integer,
@@ -161,11 +166,11 @@
ALTER SEQUENCE automatic_exploitation_matches_id_seq OWNED BY automatic_exploitation_matches.id;
--
--- Name: automatic_exploitation_runs; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: automatic_exploitation_runs; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE automatic_exploitation_runs (
id integer NOT NULL,
workspace_id integer,
@@ -194,11 +199,11 @@
ALTER SEQUENCE automatic_exploitation_runs_id_seq OWNED BY automatic_exploitation_runs.id;
--
--- Name: clients; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: clients; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE clients (
id integer NOT NULL,
host_id integer,
@@ -228,31 +233,31 @@
ALTER SEQUENCE clients_id_seq OWNED BY clients.id;
--
--- Name: credential_cores_tasks; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: credential_cores_tasks; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE credential_cores_tasks (
core_id integer,
task_id integer
);
--
--- Name: credential_logins_tasks; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: credential_logins_tasks; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE credential_logins_tasks (
login_id integer,
task_id integer
);
--
--- Name: creds; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: creds; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE creds (
id integer NOT NULL,
service_id integer NOT NULL,
@@ -286,11 +291,11 @@
ALTER SEQUENCE creds_id_seq OWNED BY creds.id;
--
--- Name: events; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: events; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE events (
id integer NOT NULL,
workspace_id integer,
@@ -323,11 +328,11 @@
ALTER SEQUENCE events_id_seq OWNED BY events.id;
--
--- Name: exploit_attempts; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: exploit_attempts; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE exploit_attempts (
id integer NOT NULL,
host_id integer,
@@ -364,11 +369,11 @@
ALTER SEQUENCE exploit_attempts_id_seq OWNED BY exploit_attempts.id;
--
--- Name: exploited_hosts; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: exploited_hosts; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE exploited_hosts (
id integer NOT NULL,
host_id integer NOT NULL,
@@ -399,11 +404,11 @@
ALTER SEQUENCE exploited_hosts_id_seq OWNED BY exploited_hosts.id;
--
--- Name: host_details; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: host_details; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE host_details (
id integer NOT NULL,
host_id integer,
@@ -435,11 +440,11 @@
ALTER SEQUENCE host_details_id_seq OWNED BY host_details.id;
--
--- Name: hosts; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: hosts; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE hosts (
id integer NOT NULL,
created_at timestamp without time zone,
@@ -464,11 +469,12 @@
vuln_count integer DEFAULT 0,
service_count integer DEFAULT 0,
host_detail_count integer DEFAULT 0,
exploit_attempt_count integer DEFAULT 0,
cred_count integer DEFAULT 0,
- detected_arch character varying
+ detected_arch character varying,
+ os_family character varying
);
--
-- Name: hosts_id_seq; Type: SEQUENCE; Schema: public; Owner: -
@@ -488,11 +494,11 @@
ALTER SEQUENCE hosts_id_seq OWNED BY hosts.id;
--
--- Name: hosts_tags; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: hosts_tags; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE hosts_tags (
host_id integer,
tag_id integer,
@@ -518,11 +524,11 @@
ALTER SEQUENCE hosts_tags_id_seq OWNED BY hosts_tags.id;
--
--- Name: listeners; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: listeners; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE listeners (
id integer NOT NULL,
created_at timestamp without time zone NOT NULL,
@@ -557,11 +563,11 @@
ALTER SEQUENCE listeners_id_seq OWNED BY listeners.id;
--
--- Name: loots; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: loots; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE loots (
id integer NOT NULL,
workspace_id integer DEFAULT 1 NOT NULL,
@@ -597,11 +603,11 @@
ALTER SEQUENCE loots_id_seq OWNED BY loots.id;
--
--- Name: macros; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: macros; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE macros (
id integer NOT NULL,
created_at timestamp without time zone NOT NULL,
@@ -632,11 +638,11 @@
ALTER SEQUENCE macros_id_seq OWNED BY macros.id;
--
--- Name: metasploit_credential_cores; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: metasploit_credential_cores; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE metasploit_credential_cores (
id integer NOT NULL,
origin_id integer NOT NULL,
@@ -669,11 +675,11 @@
ALTER SEQUENCE metasploit_credential_cores_id_seq OWNED BY metasploit_credential_cores.id;
--
--- Name: metasploit_credential_logins; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: metasploit_credential_logins; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE metasploit_credential_logins (
id integer NOT NULL,
core_id integer NOT NULL,
@@ -704,11 +710,11 @@
ALTER SEQUENCE metasploit_credential_logins_id_seq OWNED BY metasploit_credential_logins.id;
--
--- Name: metasploit_credential_origin_cracked_passwords; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: metasploit_credential_origin_cracked_passwords; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE metasploit_credential_origin_cracked_passwords (
id integer NOT NULL,
metasploit_credential_core_id integer NOT NULL,
@@ -735,11 +741,11 @@
ALTER SEQUENCE metasploit_credential_origin_cracked_passwords_id_seq OWNED BY metasploit_credential_origin_cracked_passwords.id;
--
--- Name: metasploit_credential_origin_imports; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: metasploit_credential_origin_imports; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE metasploit_credential_origin_imports (
id integer NOT NULL,
filename text NOT NULL,
@@ -767,11 +773,11 @@
ALTER SEQUENCE metasploit_credential_origin_imports_id_seq OWNED BY metasploit_credential_origin_imports.id;
--
--- Name: metasploit_credential_origin_manuals; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: metasploit_credential_origin_manuals; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE metasploit_credential_origin_manuals (
id integer NOT NULL,
user_id integer NOT NULL,
@@ -798,11 +804,11 @@
ALTER SEQUENCE metasploit_credential_origin_manuals_id_seq OWNED BY metasploit_credential_origin_manuals.id;
--
--- Name: metasploit_credential_origin_services; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: metasploit_credential_origin_services; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE metasploit_credential_origin_services (
id integer NOT NULL,
service_id integer NOT NULL,
@@ -830,11 +836,11 @@
ALTER SEQUENCE metasploit_credential_origin_services_id_seq OWNED BY metasploit_credential_origin_services.id;
--
--- Name: metasploit_credential_origin_sessions; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: metasploit_credential_origin_sessions; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE metasploit_credential_origin_sessions (
id integer NOT NULL,
post_reference_name text NOT NULL,
@@ -862,11 +868,11 @@
ALTER SEQUENCE metasploit_credential_origin_sessions_id_seq OWNED BY metasploit_credential_origin_sessions.id;
--
--- Name: metasploit_credential_privates; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: metasploit_credential_privates; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE metasploit_credential_privates (
id integer NOT NULL,
type character varying NOT NULL,
@@ -895,11 +901,11 @@
ALTER SEQUENCE metasploit_credential_privates_id_seq OWNED BY metasploit_credential_privates.id;
--
--- Name: metasploit_credential_publics; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: metasploit_credential_publics; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE metasploit_credential_publics (
id integer NOT NULL,
username character varying NOT NULL,
@@ -927,11 +933,11 @@
ALTER SEQUENCE metasploit_credential_publics_id_seq OWNED BY metasploit_credential_publics.id;
--
--- Name: metasploit_credential_realms; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: metasploit_credential_realms; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE metasploit_credential_realms (
id integer NOT NULL,
key character varying NOT NULL,
@@ -959,11 +965,11 @@
ALTER SEQUENCE metasploit_credential_realms_id_seq OWNED BY metasploit_credential_realms.id;
--
--- Name: mod_refs; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: mod_refs; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE mod_refs (
id integer NOT NULL,
module character varying(1024),
@@ -990,11 +996,11 @@
ALTER SEQUENCE mod_refs_id_seq OWNED BY mod_refs.id;
--
--- Name: module_actions; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: module_actions; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE module_actions (
id integer NOT NULL,
detail_id integer,
@@ -1020,11 +1026,11 @@
ALTER SEQUENCE module_actions_id_seq OWNED BY module_actions.id;
--
--- Name: module_archs; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: module_archs; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE module_archs (
id integer NOT NULL,
detail_id integer,
@@ -1050,11 +1056,11 @@
ALTER SEQUENCE module_archs_id_seq OWNED BY module_archs.id;
--
--- Name: module_authors; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: module_authors; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE module_authors (
id integer NOT NULL,
detail_id integer,
@@ -1081,11 +1087,11 @@
ALTER SEQUENCE module_authors_id_seq OWNED BY module_authors.id;
--
--- Name: module_details; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: module_details; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE module_details (
id integer NOT NULL,
mtime timestamp without time zone,
@@ -1124,11 +1130,11 @@
ALTER SEQUENCE module_details_id_seq OWNED BY module_details.id;
--
--- Name: module_mixins; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: module_mixins; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE module_mixins (
id integer NOT NULL,
detail_id integer,
@@ -1154,11 +1160,11 @@
ALTER SEQUENCE module_mixins_id_seq OWNED BY module_mixins.id;
--
--- Name: module_platforms; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: module_platforms; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE module_platforms (
id integer NOT NULL,
detail_id integer,
@@ -1184,11 +1190,11 @@
ALTER SEQUENCE module_platforms_id_seq OWNED BY module_platforms.id;
--
--- Name: module_refs; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: module_refs; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE module_refs (
id integer NOT NULL,
detail_id integer,
@@ -1214,11 +1220,11 @@
ALTER SEQUENCE module_refs_id_seq OWNED BY module_refs.id;
--
--- Name: module_runs; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: module_runs; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE module_runs (
id integer NOT NULL,
attempted_at timestamp without time zone,
@@ -1256,11 +1262,11 @@
ALTER SEQUENCE module_runs_id_seq OWNED BY module_runs.id;
--
--- Name: module_targets; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: module_targets; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE module_targets (
id integer NOT NULL,
detail_id integer,
@@ -1287,11 +1293,11 @@
ALTER SEQUENCE module_targets_id_seq OWNED BY module_targets.id;
--
--- Name: nexpose_consoles; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: nexpose_consoles; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE nexpose_consoles (
id integer NOT NULL,
created_at timestamp without time zone NOT NULL,
@@ -1328,11 +1334,11 @@
ALTER SEQUENCE nexpose_consoles_id_seq OWNED BY nexpose_consoles.id;
--
--- Name: notes; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: notes; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE notes (
id integer NOT NULL,
created_at timestamp without time zone,
@@ -1366,11 +1372,11 @@
ALTER SEQUENCE notes_id_seq OWNED BY notes.id;
--
--- Name: profiles; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: profiles; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE profiles (
id integer NOT NULL,
created_at timestamp without time zone NOT NULL,
@@ -1400,11 +1406,11 @@
ALTER SEQUENCE profiles_id_seq OWNED BY profiles.id;
--
--- Name: refs; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: refs; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE refs (
id integer NOT NULL,
ref_id integer,
@@ -1432,11 +1438,11 @@
ALTER SEQUENCE refs_id_seq OWNED BY refs.id;
--
--- Name: report_templates; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: report_templates; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE report_templates (
id integer NOT NULL,
workspace_id integer DEFAULT 1 NOT NULL,
@@ -1466,11 +1472,11 @@
ALTER SEQUENCE report_templates_id_seq OWNED BY report_templates.id;
--
--- Name: reports; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: reports; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE reports (
id integer NOT NULL,
workspace_id integer DEFAULT 1 NOT NULL,
@@ -1504,11 +1510,11 @@
ALTER SEQUENCE reports_id_seq OWNED BY reports.id;
--
--- Name: routes; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: routes; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE routes (
id integer NOT NULL,
session_id integer,
@@ -1535,20 +1541,20 @@
ALTER SEQUENCE routes_id_seq OWNED BY routes.id;
--
--- Name: schema_migrations; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: schema_migrations; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE schema_migrations (
version character varying NOT NULL
);
--
--- Name: services; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: services; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE services (
id integer NOT NULL,
host_id integer,
@@ -1580,11 +1586,11 @@
ALTER SEQUENCE services_id_seq OWNED BY services.id;
--
--- Name: session_events; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: session_events; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE session_events (
id integer NOT NULL,
session_id integer,
@@ -1615,11 +1621,11 @@
ALTER SEQUENCE session_events_id_seq OWNED BY session_events.id;
--
--- Name: sessions; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: sessions; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE sessions (
id integer NOT NULL,
host_id integer,
@@ -1657,11 +1663,11 @@
ALTER SEQUENCE sessions_id_seq OWNED BY sessions.id;
--
--- Name: tags; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: tags; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE tags (
id integer NOT NULL,
user_id integer,
@@ -1693,11 +1699,11 @@
ALTER SEQUENCE tags_id_seq OWNED BY tags.id;
--
--- Name: task_creds; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: task_creds; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE task_creds (
id integer NOT NULL,
task_id integer NOT NULL,
@@ -1725,11 +1731,11 @@
ALTER SEQUENCE task_creds_id_seq OWNED BY task_creds.id;
--
--- Name: task_hosts; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: task_hosts; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE task_hosts (
id integer NOT NULL,
task_id integer NOT NULL,
@@ -1757,11 +1763,11 @@
ALTER SEQUENCE task_hosts_id_seq OWNED BY task_hosts.id;
--
--- Name: task_services; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: task_services; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE task_services (
id integer NOT NULL,
task_id integer NOT NULL,
@@ -1789,11 +1795,11 @@
ALTER SEQUENCE task_services_id_seq OWNED BY task_services.id;
--
--- Name: task_sessions; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: task_sessions; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE task_sessions (
id integer NOT NULL,
task_id integer NOT NULL,
@@ -1821,11 +1827,11 @@
ALTER SEQUENCE task_sessions_id_seq OWNED BY task_sessions.id;
--
--- Name: tasks; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: tasks; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE tasks (
id integer NOT NULL,
workspace_id integer DEFAULT 1 NOT NULL,
@@ -1864,11 +1870,11 @@
ALTER SEQUENCE tasks_id_seq OWNED BY tasks.id;
--
--- Name: users; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: users; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE users (
id integer NOT NULL,
username character varying,
@@ -1904,11 +1910,11 @@
ALTER SEQUENCE users_id_seq OWNED BY users.id;
--
--- Name: vuln_attempts; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: vuln_attempts; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE vuln_attempts (
id integer NOT NULL,
vuln_id integer,
@@ -1941,11 +1947,11 @@
ALTER SEQUENCE vuln_attempts_id_seq OWNED BY vuln_attempts.id;
--
--- Name: vuln_details; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: vuln_details; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE vuln_details (
id integer NOT NULL,
vuln_id integer,
@@ -1991,11 +1997,11 @@
ALTER SEQUENCE vuln_details_id_seq OWNED BY vuln_details.id;
--
--- Name: vulns; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: vulns; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE vulns (
id integer NOT NULL,
host_id integer,
@@ -2030,11 +2036,11 @@
ALTER SEQUENCE vulns_id_seq OWNED BY vulns.id;
--
--- Name: vulns_refs; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: vulns_refs; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE vulns_refs (
ref_id integer,
vuln_id integer,
@@ -2060,11 +2066,11 @@
ALTER SEQUENCE vulns_refs_id_seq OWNED BY vulns_refs.id;
--
--- Name: web_forms; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: web_forms; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE web_forms (
id integer NOT NULL,
web_site_id integer NOT NULL,
@@ -2095,11 +2101,11 @@
ALTER SEQUENCE web_forms_id_seq OWNED BY web_forms.id;
--
--- Name: web_pages; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: web_pages; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE web_pages (
id integer NOT NULL,
web_site_id integer NOT NULL,
@@ -2137,11 +2143,11 @@
ALTER SEQUENCE web_pages_id_seq OWNED BY web_pages.id;
--
--- Name: web_sites; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: web_sites; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE web_sites (
id integer NOT NULL,
service_id integer NOT NULL,
@@ -2171,11 +2177,11 @@
ALTER SEQUENCE web_sites_id_seq OWNED BY web_sites.id;
--
--- Name: web_vulns; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: web_vulns; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE web_vulns (
id integer NOT NULL,
web_site_id integer NOT NULL,
@@ -2217,11 +2223,11 @@
ALTER SEQUENCE web_vulns_id_seq OWNED BY web_vulns.id;
--
--- Name: wmap_requests; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: wmap_requests; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE wmap_requests (
id integer NOT NULL,
host character varying,
@@ -2259,11 +2265,11 @@
ALTER SEQUENCE wmap_requests_id_seq OWNED BY wmap_requests.id;
--
--- Name: wmap_targets; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: wmap_targets; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE wmap_targets (
id integer NOT NULL,
host character varying,
@@ -2294,32 +2300,33 @@
ALTER SEQUENCE wmap_targets_id_seq OWNED BY wmap_targets.id;
--
--- Name: workspace_members; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: workspace_members; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE workspace_members (
workspace_id integer NOT NULL,
user_id integer NOT NULL
);
--
--- Name: workspaces; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: workspaces; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE workspaces (
id integer NOT NULL,
name character varying,
created_at timestamp without time zone NOT NULL,
updated_at timestamp without time zone NOT NULL,
boundary character varying(4096),
description character varying(4096),
owner_id integer,
- limit_to_network boolean DEFAULT false NOT NULL
+ limit_to_network boolean DEFAULT false NOT NULL,
+ import_fingerprint boolean DEFAULT false
);
--
-- Name: workspaces_id_seq; Type: SEQUENCE; Schema: public; Owner: -
@@ -2339,1485 +2346,1485 @@
ALTER SEQUENCE workspaces_id_seq OWNED BY workspaces.id;
--
--- Name: id; Type: DEFAULT; Schema: public; Owner: -
+-- Name: api_keys id; Type: DEFAULT; Schema: public; Owner: -
--
ALTER TABLE ONLY api_keys ALTER COLUMN id SET DEFAULT nextval('api_keys_id_seq'::regclass);
--
--- Name: id; Type: DEFAULT; Schema: public; Owner: -
+-- Name: automatic_exploitation_match_results id; Type: DEFAULT; Schema: public; Owner: -
--
ALTER TABLE ONLY automatic_exploitation_match_results ALTER COLUMN id SET DEFAULT nextval('automatic_exploitation_match_results_id_seq'::regclass);
--
--- Name: id; Type: DEFAULT; Schema: public; Owner: -
+-- Name: automatic_exploitation_match_sets id; Type: DEFAULT; Schema: public; Owner: -
--
ALTER TABLE ONLY automatic_exploitation_match_sets ALTER COLUMN id SET DEFAULT nextval('automatic_exploitation_match_sets_id_seq'::regclass);
--
--- Name: id; Type: DEFAULT; Schema: public; Owner: -
+-- Name: automatic_exploitation_matches id; Type: DEFAULT; Schema: public; Owner: -
--
ALTER TABLE ONLY automatic_exploitation_matches ALTER COLUMN id SET DEFAULT nextval('automatic_exploitation_matches_id_seq'::regclass);
--
--- Name: id; Type: DEFAULT; Schema: public; Owner: -
+-- Name: automatic_exploitation_runs id; Type: DEFAULT; Schema: public; Owner: -
--
ALTER TABLE ONLY automatic_exploitation_runs ALTER COLUMN id SET DEFAULT nextval('automatic_exploitation_runs_id_seq'::regclass);
--
--- Name: id; Type: DEFAULT; Schema: public; Owner: -
+-- Name: clients id; Type: DEFAULT; Schema: public; Owner: -
--
ALTER TABLE ONLY clients ALTER COLUMN id SET DEFAULT nextval('clients_id_seq'::regclass);
--
--- Name: id; Type: DEFAULT; Schema: public; Owner: -
+-- Name: creds id; Type: DEFAULT; Schema: public; Owner: -
--
ALTER TABLE ONLY creds ALTER COLUMN id SET DEFAULT nextval('creds_id_seq'::regclass);
--
--- Name: id; Type: DEFAULT; Schema: public; Owner: -
+-- Name: events id; Type: DEFAULT; Schema: public; Owner: -
--
ALTER TABLE ONLY events ALTER COLUMN id SET DEFAULT nextval('events_id_seq'::regclass);
--
--- Name: id; Type: DEFAULT; Schema: public; Owner: -
+-- Name: exploit_attempts id; Type: DEFAULT; Schema: public; Owner: -
--
ALTER TABLE ONLY exploit_attempts ALTER COLUMN id SET DEFAULT nextval('exploit_attempts_id_seq'::regclass);
--
--- Name: id; Type: DEFAULT; Schema: public; Owner: -
+-- Name: exploited_hosts id; Type: DEFAULT; Schema: public; Owner: -
--
ALTER TABLE ONLY exploited_hosts ALTER COLUMN id SET DEFAULT nextval('exploited_hosts_id_seq'::regclass);
--
--- Name: id; Type: DEFAULT; Schema: public; Owner: -
+-- Name: host_details id; Type: DEFAULT; Schema: public; Owner: -
--
ALTER TABLE ONLY host_details ALTER COLUMN id SET DEFAULT nextval('host_details_id_seq'::regclass);
--
--- Name: id; Type: DEFAULT; Schema: public; Owner: -
+-- Name: hosts id; Type: DEFAULT; Schema: public; Owner: -
--
ALTER TABLE ONLY hosts ALTER COLUMN id SET DEFAULT nextval('hosts_id_seq'::regclass);
--
--- Name: id; Type: DEFAULT; Schema: public; Owner: -
+-- Name: hosts_tags id; Type: DEFAULT; Schema: public; Owner: -
--
ALTER TABLE ONLY hosts_tags ALTER COLUMN id SET DEFAULT nextval('hosts_tags_id_seq'::regclass);
--
--- Name: id; Type: DEFAULT; Schema: public; Owner: -
+-- Name: listeners id; Type: DEFAULT; Schema: public; Owner: -
--
ALTER TABLE ONLY listeners ALTER COLUMN id SET DEFAULT nextval('listeners_id_seq'::regclass);
--
--- Name: id; Type: DEFAULT; Schema: public; Owner: -
+-- Name: loots id; Type: DEFAULT; Schema: public; Owner: -
--
ALTER TABLE ONLY loots ALTER COLUMN id SET DEFAULT nextval('loots_id_seq'::regclass);
--
--- Name: id; Type: DEFAULT; Schema: public; Owner: -
+-- Name: macros id; Type: DEFAULT; Schema: public; Owner: -
--
ALTER TABLE ONLY macros ALTER COLUMN id SET DEFAULT nextval('macros_id_seq'::regclass);
--
--- Name: id; Type: DEFAULT; Schema: public; Owner: -
+-- Name: metasploit_credential_cores id; Type: DEFAULT; Schema: public; Owner: -
--
ALTER TABLE ONLY metasploit_credential_cores ALTER COLUMN id SET DEFAULT nextval('metasploit_credential_cores_id_seq'::regclass);
--
--- Name: id; Type: DEFAULT; Schema: public; Owner: -
+-- Name: metasploit_credential_logins id; Type: DEFAULT; Schema: public; Owner: -
--
ALTER TABLE ONLY metasploit_credential_logins ALTER COLUMN id SET DEFAULT nextval('metasploit_credential_logins_id_seq'::regclass);
--
--- Name: id; Type: DEFAULT; Schema: public; Owner: -
+-- Name: metasploit_credential_origin_cracked_passwords id; Type: DEFAULT; Schema: public; Owner: -
--
ALTER TABLE ONLY metasploit_credential_origin_cracked_passwords ALTER COLUMN id SET DEFAULT nextval('metasploit_credential_origin_cracked_passwords_id_seq'::regclass);
--
--- Name: id; Type: DEFAULT; Schema: public; Owner: -
+-- Name: metasploit_credential_origin_imports id; Type: DEFAULT; Schema: public; Owner: -
--
ALTER TABLE ONLY metasploit_credential_origin_imports ALTER COLUMN id SET DEFAULT nextval('metasploit_credential_origin_imports_id_seq'::regclass);
--
--- Name: id; Type: DEFAULT; Schema: public; Owner: -
+-- Name: metasploit_credential_origin_manuals id; Type: DEFAULT; Schema: public; Owner: -
--
ALTER TABLE ONLY metasploit_credential_origin_manuals ALTER COLUMN id SET DEFAULT nextval('metasploit_credential_origin_manuals_id_seq'::regclass);
--
--- Name: id; Type: DEFAULT; Schema: public; Owner: -
+-- Name: metasploit_credential_origin_services id; Type: DEFAULT; Schema: public; Owner: -
--
ALTER TABLE ONLY metasploit_credential_origin_services ALTER COLUMN id SET DEFAULT nextval('metasploit_credential_origin_services_id_seq'::regclass);
--
--- Name: id; Type: DEFAULT; Schema: public; Owner: -
+-- Name: metasploit_credential_origin_sessions id; Type: DEFAULT; Schema: public; Owner: -
--
ALTER TABLE ONLY metasploit_credential_origin_sessions ALTER COLUMN id SET DEFAULT nextval('metasploit_credential_origin_sessions_id_seq'::regclass);
--
--- Name: id; Type: DEFAULT; Schema: public; Owner: -
+-- Name: metasploit_credential_privates id; Type: DEFAULT; Schema: public; Owner: -
--
ALTER TABLE ONLY metasploit_credential_privates ALTER COLUMN id SET DEFAULT nextval('metasploit_credential_privates_id_seq'::regclass);
--
--- Name: id; Type: DEFAULT; Schema: public; Owner: -
+-- Name: metasploit_credential_publics id; Type: DEFAULT; Schema: public; Owner: -
--
ALTER TABLE ONLY metasploit_credential_publics ALTER COLUMN id SET DEFAULT nextval('metasploit_credential_publics_id_seq'::regclass);
--
--- Name: id; Type: DEFAULT; Schema: public; Owner: -
+-- Name: metasploit_credential_realms id; Type: DEFAULT; Schema: public; Owner: -
--
ALTER TABLE ONLY metasploit_credential_realms ALTER COLUMN id SET DEFAULT nextval('metasploit_credential_realms_id_seq'::regclass);
--
--- Name: id; Type: DEFAULT; Schema: public; Owner: -
+-- Name: mod_refs id; Type: DEFAULT; Schema: public; Owner: -
--
ALTER TABLE ONLY mod_refs ALTER COLUMN id SET DEFAULT nextval('mod_refs_id_seq'::regclass);
--
--- Name: id; Type: DEFAULT; Schema: public; Owner: -
+-- Name: module_actions id; Type: DEFAULT; Schema: public; Owner: -
--
ALTER TABLE ONLY module_actions ALTER COLUMN id SET DEFAULT nextval('module_actions_id_seq'::regclass);
--
--- Name: id; Type: DEFAULT; Schema: public; Owner: -
+-- Name: module_archs id; Type: DEFAULT; Schema: public; Owner: -
--
ALTER TABLE ONLY module_archs ALTER COLUMN id SET DEFAULT nextval('module_archs_id_seq'::regclass);
--
--- Name: id; Type: DEFAULT; Schema: public; Owner: -
+-- Name: module_authors id; Type: DEFAULT; Schema: public; Owner: -
--
ALTER TABLE ONLY module_authors ALTER COLUMN id SET DEFAULT nextval('module_authors_id_seq'::regclass);
--
--- Name: id; Type: DEFAULT; Schema: public; Owner: -
+-- Name: module_details id; Type: DEFAULT; Schema: public; Owner: -
--
ALTER TABLE ONLY module_details ALTER COLUMN id SET DEFAULT nextval('module_details_id_seq'::regclass);
--
--- Name: id; Type: DEFAULT; Schema: public; Owner: -
+-- Name: module_mixins id; Type: DEFAULT; Schema: public; Owner: -
--
ALTER TABLE ONLY module_mixins ALTER COLUMN id SET DEFAULT nextval('module_mixins_id_seq'::regclass);
--
--- Name: id; Type: DEFAULT; Schema: public; Owner: -
+-- Name: module_platforms id; Type: DEFAULT; Schema: public; Owner: -
--
ALTER TABLE ONLY module_platforms ALTER COLUMN id SET DEFAULT nextval('module_platforms_id_seq'::regclass);
--
--- Name: id; Type: DEFAULT; Schema: public; Owner: -
+-- Name: module_refs id; Type: DEFAULT; Schema: public; Owner: -
--
ALTER TABLE ONLY module_refs ALTER COLUMN id SET DEFAULT nextval('module_refs_id_seq'::regclass);
--
--- Name: id; Type: DEFAULT; Schema: public; Owner: -
+-- Name: module_runs id; Type: DEFAULT; Schema: public; Owner: -
--
ALTER TABLE ONLY module_runs ALTER COLUMN id SET DEFAULT nextval('module_runs_id_seq'::regclass);
--
--- Name: id; Type: DEFAULT; Schema: public; Owner: -
+-- Name: module_targets id; Type: DEFAULT; Schema: public; Owner: -
--
ALTER TABLE ONLY module_targets ALTER COLUMN id SET DEFAULT nextval('module_targets_id_seq'::regclass);
--
--- Name: id; Type: DEFAULT; Schema: public; Owner: -
+-- Name: nexpose_consoles id; Type: DEFAULT; Schema: public; Owner: -
--
ALTER TABLE ONLY nexpose_consoles ALTER COLUMN id SET DEFAULT nextval('nexpose_consoles_id_seq'::regclass);
--
--- Name: id; Type: DEFAULT; Schema: public; Owner: -
+-- Name: notes id; Type: DEFAULT; Schema: public; Owner: -
--
ALTER TABLE ONLY notes ALTER COLUMN id SET DEFAULT nextval('notes_id_seq'::regclass);
--
--- Name: id; Type: DEFAULT; Schema: public; Owner: -
+-- Name: profiles id; Type: DEFAULT; Schema: public; Owner: -
--
ALTER TABLE ONLY profiles ALTER COLUMN id SET DEFAULT nextval('profiles_id_seq'::regclass);
--
--- Name: id; Type: DEFAULT; Schema: public; Owner: -
+-- Name: refs id; Type: DEFAULT; Schema: public; Owner: -
--
ALTER TABLE ONLY refs ALTER COLUMN id SET DEFAULT nextval('refs_id_seq'::regclass);
--
--- Name: id; Type: DEFAULT; Schema: public; Owner: -
+-- Name: report_templates id; Type: DEFAULT; Schema: public; Owner: -
--
ALTER TABLE ONLY report_templates ALTER COLUMN id SET DEFAULT nextval('report_templates_id_seq'::regclass);
--
--- Name: id; Type: DEFAULT; Schema: public; Owner: -
+-- Name: reports id; Type: DEFAULT; Schema: public; Owner: -
--
ALTER TABLE ONLY reports ALTER COLUMN id SET DEFAULT nextval('reports_id_seq'::regclass);
--
--- Name: id; Type: DEFAULT; Schema: public; Owner: -
+-- Name: routes id; Type: DEFAULT; Schema: public; Owner: -
--
ALTER TABLE ONLY routes ALTER COLUMN id SET DEFAULT nextval('routes_id_seq'::regclass);
--
--- Name: id; Type: DEFAULT; Schema: public; Owner: -
+-- Name: services id; Type: DEFAULT; Schema: public; Owner: -
--
ALTER TABLE ONLY services ALTER COLUMN id SET DEFAULT nextval('services_id_seq'::regclass);
--
--- Name: id; Type: DEFAULT; Schema: public; Owner: -
+-- Name: session_events id; Type: DEFAULT; Schema: public; Owner: -
--
ALTER TABLE ONLY session_events ALTER COLUMN id SET DEFAULT nextval('session_events_id_seq'::regclass);
--
--- Name: id; Type: DEFAULT; Schema: public; Owner: -
+-- Name: sessions id; Type: DEFAULT; Schema: public; Owner: -
--
ALTER TABLE ONLY sessions ALTER COLUMN id SET DEFAULT nextval('sessions_id_seq'::regclass);
--
--- Name: id; Type: DEFAULT; Schema: public; Owner: -
+-- Name: tags id; Type: DEFAULT; Schema: public; Owner: -
--
ALTER TABLE ONLY tags ALTER COLUMN id SET DEFAULT nextval('tags_id_seq'::regclass);
--
--- Name: id; Type: DEFAULT; Schema: public; Owner: -
+-- Name: task_creds id; Type: DEFAULT; Schema: public; Owner: -
--
ALTER TABLE ONLY task_creds ALTER COLUMN id SET DEFAULT nextval('task_creds_id_seq'::regclass);
--
--- Name: id; Type: DEFAULT; Schema: public; Owner: -
+-- Name: task_hosts id; Type: DEFAULT; Schema: public; Owner: -
--
ALTER TABLE ONLY task_hosts ALTER COLUMN id SET DEFAULT nextval('task_hosts_id_seq'::regclass);
--
--- Name: id; Type: DEFAULT; Schema: public; Owner: -
+-- Name: task_services id; Type: DEFAULT; Schema: public; Owner: -
--
ALTER TABLE ONLY task_services ALTER COLUMN id SET DEFAULT nextval('task_services_id_seq'::regclass);
--
--- Name: id; Type: DEFAULT; Schema: public; Owner: -
+-- Name: task_sessions id; Type: DEFAULT; Schema: public; Owner: -
--
ALTER TABLE ONLY task_sessions ALTER COLUMN id SET DEFAULT nextval('task_sessions_id_seq'::regclass);
--
--- Name: id; Type: DEFAULT; Schema: public; Owner: -
+-- Name: tasks id; Type: DEFAULT; Schema: public; Owner: -
--
ALTER TABLE ONLY tasks ALTER COLUMN id SET DEFAULT nextval('tasks_id_seq'::regclass);
--
--- Name: id; Type: DEFAULT; Schema: public; Owner: -
+-- Name: users id; Type: DEFAULT; Schema: public; Owner: -
--
ALTER TABLE ONLY users ALTER COLUMN id SET DEFAULT nextval('users_id_seq'::regclass);
--
--- Name: id; Type: DEFAULT; Schema: public; Owner: -
+-- Name: vuln_attempts id; Type: DEFAULT; Schema: public; Owner: -
--
ALTER TABLE ONLY vuln_attempts ALTER COLUMN id SET DEFAULT nextval('vuln_attempts_id_seq'::regclass);
--
--- Name: id; Type: DEFAULT; Schema: public; Owner: -
+-- Name: vuln_details id; Type: DEFAULT; Schema: public; Owner: -
--
ALTER TABLE ONLY vuln_details ALTER COLUMN id SET DEFAULT nextval('vuln_details_id_seq'::regclass);
--
--- Name: id; Type: DEFAULT; Schema: public; Owner: -
+-- Name: vulns id; Type: DEFAULT; Schema: public; Owner: -
--
ALTER TABLE ONLY vulns ALTER COLUMN id SET DEFAULT nextval('vulns_id_seq'::regclass);
--
--- Name: id; Type: DEFAULT; Schema: public; Owner: -
+-- Name: vulns_refs id; Type: DEFAULT; Schema: public; Owner: -
--
ALTER TABLE ONLY vulns_refs ALTER COLUMN id SET DEFAULT nextval('vulns_refs_id_seq'::regclass);
--
--- Name: id; Type: DEFAULT; Schema: public; Owner: -
+-- Name: web_forms id; Type: DEFAULT; Schema: public; Owner: -
--
ALTER TABLE ONLY web_forms ALTER COLUMN id SET DEFAULT nextval('web_forms_id_seq'::regclass);
--
--- Name: id; Type: DEFAULT; Schema: public; Owner: -
+-- Name: web_pages id; Type: DEFAULT; Schema: public; Owner: -
--
ALTER TABLE ONLY web_pages ALTER COLUMN id SET DEFAULT nextval('web_pages_id_seq'::regclass);
--
--- Name: id; Type: DEFAULT; Schema: public; Owner: -
+-- Name: web_sites id; Type: DEFAULT; Schema: public; Owner: -
--
ALTER TABLE ONLY web_sites ALTER COLUMN id SET DEFAULT nextval('web_sites_id_seq'::regclass);
--
--- Name: id; Type: DEFAULT; Schema: public; Owner: -
+-- Name: web_vulns id; Type: DEFAULT; Schema: public; Owner: -
--
ALTER TABLE ONLY web_vulns ALTER COLUMN id SET DEFAULT nextval('web_vulns_id_seq'::regclass);
--
--- Name: id; Type: DEFAULT; Schema: public; Owner: -
+-- Name: wmap_requests id; Type: DEFAULT; Schema: public; Owner: -
--
ALTER TABLE ONLY wmap_requests ALTER COLUMN id SET DEFAULT nextval('wmap_requests_id_seq'::regclass);
--
--- Name: id; Type: DEFAULT; Schema: public; Owner: -
+-- Name: wmap_targets id; Type: DEFAULT; Schema: public; Owner: -
--
ALTER TABLE ONLY wmap_targets ALTER COLUMN id SET DEFAULT nextval('wmap_targets_id_seq'::regclass);
--
--- Name: id; Type: DEFAULT; Schema: public; Owner: -
+-- Name: workspaces id; Type: DEFAULT; Schema: public; Owner: -
--
ALTER TABLE ONLY workspaces ALTER COLUMN id SET DEFAULT nextval('workspaces_id_seq'::regclass);
--
--- Name: api_keys_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
+-- Name: api_keys api_keys_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY api_keys
ADD CONSTRAINT api_keys_pkey PRIMARY KEY (id);
--
--- Name: automatic_exploitation_match_results_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
+-- Name: automatic_exploitation_match_results automatic_exploitation_match_results_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY automatic_exploitation_match_results
ADD CONSTRAINT automatic_exploitation_match_results_pkey PRIMARY KEY (id);
--
--- Name: automatic_exploitation_match_sets_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
+-- Name: automatic_exploitation_match_sets automatic_exploitation_match_sets_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY automatic_exploitation_match_sets
ADD CONSTRAINT automatic_exploitation_match_sets_pkey PRIMARY KEY (id);
--
--- Name: automatic_exploitation_matches_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
+-- Name: automatic_exploitation_matches automatic_exploitation_matches_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY automatic_exploitation_matches
ADD CONSTRAINT automatic_exploitation_matches_pkey PRIMARY KEY (id);
--
--- Name: automatic_exploitation_runs_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
+-- Name: automatic_exploitation_runs automatic_exploitation_runs_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY automatic_exploitation_runs
ADD CONSTRAINT automatic_exploitation_runs_pkey PRIMARY KEY (id);
--
--- Name: clients_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
+-- Name: clients clients_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY clients
ADD CONSTRAINT clients_pkey PRIMARY KEY (id);
--
--- Name: creds_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
+-- Name: creds creds_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY creds
ADD CONSTRAINT creds_pkey PRIMARY KEY (id);
--
--- Name: events_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
+-- Name: events events_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY events
ADD CONSTRAINT events_pkey PRIMARY KEY (id);
--
--- Name: exploit_attempts_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
+-- Name: exploit_attempts exploit_attempts_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY exploit_attempts
ADD CONSTRAINT exploit_attempts_pkey PRIMARY KEY (id);
--
--- Name: exploited_hosts_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
+-- Name: exploited_hosts exploited_hosts_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY exploited_hosts
ADD CONSTRAINT exploited_hosts_pkey PRIMARY KEY (id);
--
--- Name: host_details_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
+-- Name: host_details host_details_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY host_details
ADD CONSTRAINT host_details_pkey PRIMARY KEY (id);
--
--- Name: hosts_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
+-- Name: hosts hosts_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY hosts
ADD CONSTRAINT hosts_pkey PRIMARY KEY (id);
--
--- Name: hosts_tags_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
+-- Name: hosts_tags hosts_tags_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY hosts_tags
ADD CONSTRAINT hosts_tags_pkey PRIMARY KEY (id);
--
--- Name: listeners_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
+-- Name: listeners listeners_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY listeners
ADD CONSTRAINT listeners_pkey PRIMARY KEY (id);
--
--- Name: loots_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
+-- Name: loots loots_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY loots
ADD CONSTRAINT loots_pkey PRIMARY KEY (id);
--
--- Name: macros_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
+-- Name: macros macros_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY macros
ADD CONSTRAINT macros_pkey PRIMARY KEY (id);
--
--- Name: metasploit_credential_cores_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
+-- Name: metasploit_credential_cores metasploit_credential_cores_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metasploit_credential_cores
ADD CONSTRAINT metasploit_credential_cores_pkey PRIMARY KEY (id);
--
--- Name: metasploit_credential_logins_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
+-- Name: metasploit_credential_logins metasploit_credential_logins_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metasploit_credential_logins
ADD CONSTRAINT metasploit_credential_logins_pkey PRIMARY KEY (id);
--
--- Name: metasploit_credential_origin_cracked_passwords_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
+-- Name: metasploit_credential_origin_cracked_passwords metasploit_credential_origin_cracked_passwords_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metasploit_credential_origin_cracked_passwords
ADD CONSTRAINT metasploit_credential_origin_cracked_passwords_pkey PRIMARY KEY (id);
--
--- Name: metasploit_credential_origin_imports_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
+-- Name: metasploit_credential_origin_imports metasploit_credential_origin_imports_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metasploit_credential_origin_imports
ADD CONSTRAINT metasploit_credential_origin_imports_pkey PRIMARY KEY (id);
--
--- Name: metasploit_credential_origin_manuals_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
+-- Name: metasploit_credential_origin_manuals metasploit_credential_origin_manuals_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metasploit_credential_origin_manuals
ADD CONSTRAINT metasploit_credential_origin_manuals_pkey PRIMARY KEY (id);
--
--- Name: metasploit_credential_origin_services_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
+-- Name: metasploit_credential_origin_services metasploit_credential_origin_services_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metasploit_credential_origin_services
ADD CONSTRAINT metasploit_credential_origin_services_pkey PRIMARY KEY (id);
--
--- Name: metasploit_credential_origin_sessions_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
+-- Name: metasploit_credential_origin_sessions metasploit_credential_origin_sessions_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metasploit_credential_origin_sessions
ADD CONSTRAINT metasploit_credential_origin_sessions_pkey PRIMARY KEY (id);
--
--- Name: metasploit_credential_privates_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
+-- Name: metasploit_credential_privates metasploit_credential_privates_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metasploit_credential_privates
ADD CONSTRAINT metasploit_credential_privates_pkey PRIMARY KEY (id);
--
--- Name: metasploit_credential_publics_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
+-- Name: metasploit_credential_publics metasploit_credential_publics_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metasploit_credential_publics
ADD CONSTRAINT metasploit_credential_publics_pkey PRIMARY KEY (id);
--
--- Name: metasploit_credential_realms_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
+-- Name: metasploit_credential_realms metasploit_credential_realms_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY metasploit_credential_realms
ADD CONSTRAINT metasploit_credential_realms_pkey PRIMARY KEY (id);
--
--- Name: mod_refs_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
+-- Name: mod_refs mod_refs_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY mod_refs
ADD CONSTRAINT mod_refs_pkey PRIMARY KEY (id);
--
--- Name: module_actions_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
+-- Name: module_actions module_actions_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY module_actions
ADD CONSTRAINT module_actions_pkey PRIMARY KEY (id);
--
--- Name: module_archs_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
+-- Name: module_archs module_archs_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY module_archs
ADD CONSTRAINT module_archs_pkey PRIMARY KEY (id);
--
--- Name: module_authors_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
+-- Name: module_authors module_authors_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY module_authors
ADD CONSTRAINT module_authors_pkey PRIMARY KEY (id);
--
--- Name: module_details_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
+-- Name: module_details module_details_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY module_details
ADD CONSTRAINT module_details_pkey PRIMARY KEY (id);
--
--- Name: module_mixins_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
+-- Name: module_mixins module_mixins_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY module_mixins
ADD CONSTRAINT module_mixins_pkey PRIMARY KEY (id);
--
--- Name: module_platforms_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
+-- Name: module_platforms module_platforms_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY module_platforms
ADD CONSTRAINT module_platforms_pkey PRIMARY KEY (id);
--
--- Name: module_refs_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
+-- Name: module_refs module_refs_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY module_refs
ADD CONSTRAINT module_refs_pkey PRIMARY KEY (id);
--
--- Name: module_runs_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
+-- Name: module_runs module_runs_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY module_runs
ADD CONSTRAINT module_runs_pkey PRIMARY KEY (id);
--
--- Name: module_targets_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
+-- Name: module_targets module_targets_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY module_targets
ADD CONSTRAINT module_targets_pkey PRIMARY KEY (id);
--
--- Name: nexpose_consoles_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
+-- Name: nexpose_consoles nexpose_consoles_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY nexpose_consoles
ADD CONSTRAINT nexpose_consoles_pkey PRIMARY KEY (id);
--
--- Name: notes_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
+-- Name: notes notes_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY notes
ADD CONSTRAINT notes_pkey PRIMARY KEY (id);
--
--- Name: profiles_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
+-- Name: profiles profiles_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY profiles
ADD CONSTRAINT profiles_pkey PRIMARY KEY (id);
--
--- Name: refs_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
+-- Name: refs refs_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY refs
ADD CONSTRAINT refs_pkey PRIMARY KEY (id);
--
--- Name: report_templates_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
+-- Name: report_templates report_templates_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY report_templates
ADD CONSTRAINT report_templates_pkey PRIMARY KEY (id);
--
--- Name: reports_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
+-- Name: reports reports_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY reports
ADD CONSTRAINT reports_pkey PRIMARY KEY (id);
--
--- Name: routes_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
+-- Name: routes routes_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY routes
ADD CONSTRAINT routes_pkey PRIMARY KEY (id);
--
--- Name: services_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
+-- Name: services services_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY services
ADD CONSTRAINT services_pkey PRIMARY KEY (id);
--
--- Name: session_events_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
+-- Name: session_events session_events_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY session_events
ADD CONSTRAINT session_events_pkey PRIMARY KEY (id);
--
--- Name: sessions_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
+-- Name: sessions sessions_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY sessions
ADD CONSTRAINT sessions_pkey PRIMARY KEY (id);
--
--- Name: tags_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
+-- Name: tags tags_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY tags
ADD CONSTRAINT tags_pkey PRIMARY KEY (id);
--
--- Name: task_creds_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
+-- Name: task_creds task_creds_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY task_creds
ADD CONSTRAINT task_creds_pkey PRIMARY KEY (id);
--
--- Name: task_hosts_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
+-- Name: task_hosts task_hosts_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY task_hosts
ADD CONSTRAINT task_hosts_pkey PRIMARY KEY (id);
--
--- Name: task_services_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
+-- Name: task_services task_services_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY task_services
ADD CONSTRAINT task_services_pkey PRIMARY KEY (id);
--
--- Name: task_sessions_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
+-- Name: task_sessions task_sessions_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY task_sessions
ADD CONSTRAINT task_sessions_pkey PRIMARY KEY (id);
--
--- Name: tasks_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
+-- Name: tasks tasks_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY tasks
ADD CONSTRAINT tasks_pkey PRIMARY KEY (id);
--
--- Name: users_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
+-- Name: users users_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY users
ADD CONSTRAINT users_pkey PRIMARY KEY (id);
--
--- Name: vuln_attempts_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
+-- Name: vuln_attempts vuln_attempts_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY vuln_attempts
ADD CONSTRAINT vuln_attempts_pkey PRIMARY KEY (id);
--
--- Name: vuln_details_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
+-- Name: vuln_details vuln_details_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY vuln_details
ADD CONSTRAINT vuln_details_pkey PRIMARY KEY (id);
--
--- Name: vulns_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
+-- Name: vulns vulns_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY vulns
ADD CONSTRAINT vulns_pkey PRIMARY KEY (id);
--
--- Name: vulns_refs_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
+-- Name: vulns_refs vulns_refs_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY vulns_refs
ADD CONSTRAINT vulns_refs_pkey PRIMARY KEY (id);
--
--- Name: web_forms_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
+-- Name: web_forms web_forms_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY web_forms
ADD CONSTRAINT web_forms_pkey PRIMARY KEY (id);
--
--- Name: web_pages_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
+-- Name: web_pages web_pages_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY web_pages
ADD CONSTRAINT web_pages_pkey PRIMARY KEY (id);
--
--- Name: web_sites_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
+-- Name: web_sites web_sites_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY web_sites
ADD CONSTRAINT web_sites_pkey PRIMARY KEY (id);
--
--- Name: web_vulns_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
+-- Name: web_vulns web_vulns_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY web_vulns
ADD CONSTRAINT web_vulns_pkey PRIMARY KEY (id);
--
--- Name: wmap_requests_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
+-- Name: wmap_requests wmap_requests_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY wmap_requests
ADD CONSTRAINT wmap_requests_pkey PRIMARY KEY (id);
--
--- Name: wmap_targets_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
+-- Name: wmap_targets wmap_targets_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY wmap_targets
ADD CONSTRAINT wmap_targets_pkey PRIMARY KEY (id);
--
--- Name: workspaces_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
+-- Name: workspaces workspaces_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY workspaces
ADD CONSTRAINT workspaces_pkey PRIMARY KEY (id);
--
--- Name: index_automatic_exploitation_match_results_on_match_id; Type: INDEX; Schema: public; Owner: -; Tablespace:
+-- Name: index_automatic_exploitation_match_results_on_match_id; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX index_automatic_exploitation_match_results_on_match_id ON automatic_exploitation_match_results USING btree (match_id);
--
--- Name: index_automatic_exploitation_match_results_on_run_id; Type: INDEX; Schema: public; Owner: -; Tablespace:
+-- Name: index_automatic_exploitation_match_results_on_run_id; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX index_automatic_exploitation_match_results_on_run_id ON automatic_exploitation_match_results USING btree (run_id);
--
--- Name: index_automatic_exploitation_match_sets_on_user_id; Type: INDEX; Schema: public; Owner: -; Tablespace:
+-- Name: index_automatic_exploitation_match_sets_on_user_id; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX index_automatic_exploitation_match_sets_on_user_id ON automatic_exploitation_match_sets USING btree (user_id);
--
--- Name: index_automatic_exploitation_match_sets_on_workspace_id; Type: INDEX; Schema: public; Owner: -; Tablespace:
+-- Name: index_automatic_exploitation_match_sets_on_workspace_id; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX index_automatic_exploitation_match_sets_on_workspace_id ON automatic_exploitation_match_sets USING btree (workspace_id);
--
--- Name: index_automatic_exploitation_matches_on_module_detail_id; Type: INDEX; Schema: public; Owner: -; Tablespace:
+-- Name: index_automatic_exploitation_matches_on_module_detail_id; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX index_automatic_exploitation_matches_on_module_detail_id ON automatic_exploitation_matches USING btree (module_detail_id);
--
--- Name: index_automatic_exploitation_matches_on_module_fullname; Type: INDEX; Schema: public; Owner: -; Tablespace:
+-- Name: index_automatic_exploitation_matches_on_module_fullname; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX index_automatic_exploitation_matches_on_module_fullname ON automatic_exploitation_matches USING btree (module_fullname);
--
--- Name: index_automatic_exploitation_runs_on_match_set_id; Type: INDEX; Schema: public; Owner: -; Tablespace:
+-- Name: index_automatic_exploitation_runs_on_match_set_id; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX index_automatic_exploitation_runs_on_match_set_id ON automatic_exploitation_runs USING btree (match_set_id);
--
--- Name: index_automatic_exploitation_runs_on_user_id; Type: INDEX; Schema: public; Owner: -; Tablespace:
+-- Name: index_automatic_exploitation_runs_on_user_id; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX index_automatic_exploitation_runs_on_user_id ON automatic_exploitation_runs USING btree (user_id);
--
--- Name: index_automatic_exploitation_runs_on_workspace_id; Type: INDEX; Schema: public; Owner: -; Tablespace:
+-- Name: index_automatic_exploitation_runs_on_workspace_id; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX index_automatic_exploitation_runs_on_workspace_id ON automatic_exploitation_runs USING btree (workspace_id);
--
--- Name: index_hosts_on_name; Type: INDEX; Schema: public; Owner: -; Tablespace:
+-- Name: index_hosts_on_name; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX index_hosts_on_name ON hosts USING btree (name);
--
--- Name: index_hosts_on_os_flavor; Type: INDEX; Schema: public; Owner: -; Tablespace:
+-- Name: index_hosts_on_os_flavor; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX index_hosts_on_os_flavor ON hosts USING btree (os_flavor);
--
--- Name: index_hosts_on_os_name; Type: INDEX; Schema: public; Owner: -; Tablespace:
+-- Name: index_hosts_on_os_name; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX index_hosts_on_os_name ON hosts USING btree (os_name);
--
--- Name: index_hosts_on_purpose; Type: INDEX; Schema: public; Owner: -; Tablespace:
+-- Name: index_hosts_on_purpose; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX index_hosts_on_purpose ON hosts USING btree (purpose);
--
--- Name: index_hosts_on_state; Type: INDEX; Schema: public; Owner: -; Tablespace:
+-- Name: index_hosts_on_state; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX index_hosts_on_state ON hosts USING btree (state);
--
--- Name: index_hosts_on_workspace_id_and_address; Type: INDEX; Schema: public; Owner: -; Tablespace:
+-- Name: index_hosts_on_workspace_id_and_address; Type: INDEX; Schema: public; Owner: -
--
CREATE UNIQUE INDEX index_hosts_on_workspace_id_and_address ON hosts USING btree (workspace_id, address);
--
--- Name: index_loots_on_module_run_id; Type: INDEX; Schema: public; Owner: -; Tablespace:
+-- Name: index_loots_on_module_run_id; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX index_loots_on_module_run_id ON loots USING btree (module_run_id);
--
--- Name: index_metasploit_credential_cores_on_origin_type_and_origin_id; Type: INDEX; Schema: public; Owner: -; Tablespace:
+-- Name: index_metasploit_credential_cores_on_origin_type_and_origin_id; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX index_metasploit_credential_cores_on_origin_type_and_origin_id ON metasploit_credential_cores USING btree (origin_type, origin_id);
--
--- Name: index_metasploit_credential_cores_on_private_id; Type: INDEX; Schema: public; Owner: -; Tablespace:
+-- Name: index_metasploit_credential_cores_on_private_id; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX index_metasploit_credential_cores_on_private_id ON metasploit_credential_cores USING btree (private_id);
--
--- Name: index_metasploit_credential_cores_on_public_id; Type: INDEX; Schema: public; Owner: -; Tablespace:
+-- Name: index_metasploit_credential_cores_on_public_id; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX index_metasploit_credential_cores_on_public_id ON metasploit_credential_cores USING btree (public_id);
--
--- Name: index_metasploit_credential_cores_on_realm_id; Type: INDEX; Schema: public; Owner: -; Tablespace:
+-- Name: index_metasploit_credential_cores_on_realm_id; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX index_metasploit_credential_cores_on_realm_id ON metasploit_credential_cores USING btree (realm_id);
--
--- Name: index_metasploit_credential_cores_on_workspace_id; Type: INDEX; Schema: public; Owner: -; Tablespace:
+-- Name: index_metasploit_credential_cores_on_workspace_id; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX index_metasploit_credential_cores_on_workspace_id ON metasploit_credential_cores USING btree (workspace_id);
--
--- Name: index_metasploit_credential_logins_on_core_id_and_service_id; Type: INDEX; Schema: public; Owner: -; Tablespace:
+-- Name: index_metasploit_credential_logins_on_core_id_and_service_id; Type: INDEX; Schema: public; Owner: -
--
CREATE UNIQUE INDEX index_metasploit_credential_logins_on_core_id_and_service_id ON metasploit_credential_logins USING btree (core_id, service_id);
--
--- Name: index_metasploit_credential_logins_on_service_id_and_core_id; Type: INDEX; Schema: public; Owner: -; Tablespace:
+-- Name: index_metasploit_credential_logins_on_service_id_and_core_id; Type: INDEX; Schema: public; Owner: -
--
CREATE UNIQUE INDEX index_metasploit_credential_logins_on_service_id_and_core_id ON metasploit_credential_logins USING btree (service_id, core_id);
--
--- Name: index_metasploit_credential_origin_imports_on_task_id; Type: INDEX; Schema: public; Owner: -; Tablespace:
+-- Name: index_metasploit_credential_origin_imports_on_task_id; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX index_metasploit_credential_origin_imports_on_task_id ON metasploit_credential_origin_imports USING btree (task_id);
--
--- Name: index_metasploit_credential_origin_manuals_on_user_id; Type: INDEX; Schema: public; Owner: -; Tablespace:
+-- Name: index_metasploit_credential_origin_manuals_on_user_id; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX index_metasploit_credential_origin_manuals_on_user_id ON metasploit_credential_origin_manuals USING btree (user_id);
--
--- Name: index_metasploit_credential_privates_on_type_and_data; Type: INDEX; Schema: public; Owner: -; Tablespace:
+-- Name: index_metasploit_credential_privates_on_type_and_data; Type: INDEX; Schema: public; Owner: -
--
CREATE UNIQUE INDEX index_metasploit_credential_privates_on_type_and_data ON metasploit_credential_privates USING btree (type, data) WHERE (NOT ((type)::text = 'Metasploit::Credential::SSHKey'::text));
--
--- Name: index_metasploit_credential_privates_on_type_and_data_sshkey; Type: INDEX; Schema: public; Owner: -; Tablespace:
+-- Name: index_metasploit_credential_privates_on_type_and_data_sshkey; Type: INDEX; Schema: public; Owner: -
--
CREATE UNIQUE INDEX index_metasploit_credential_privates_on_type_and_data_sshkey ON metasploit_credential_privates USING btree (type, decode(md5(data), 'hex'::text)) WHERE ((type)::text = 'Metasploit::Credential::SSHKey'::text);
--
--- Name: index_metasploit_credential_publics_on_username; Type: INDEX; Schema: public; Owner: -; Tablespace:
+-- Name: index_metasploit_credential_publics_on_username; Type: INDEX; Schema: public; Owner: -
--
CREATE UNIQUE INDEX index_metasploit_credential_publics_on_username ON metasploit_credential_publics USING btree (username);
--
--- Name: index_metasploit_credential_realms_on_key_and_value; Type: INDEX; Schema: public; Owner: -; Tablespace:
+-- Name: index_metasploit_credential_realms_on_key_and_value; Type: INDEX; Schema: public; Owner: -
--
CREATE UNIQUE INDEX index_metasploit_credential_realms_on_key_and_value ON metasploit_credential_realms USING btree (key, value);
--
--- Name: index_module_actions_on_detail_id; Type: INDEX; Schema: public; Owner: -; Tablespace:
+-- Name: index_module_actions_on_detail_id; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX index_module_actions_on_detail_id ON module_actions USING btree (detail_id);
--
--- Name: index_module_archs_on_detail_id; Type: INDEX; Schema: public; Owner: -; Tablespace:
+-- Name: index_module_archs_on_detail_id; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX index_module_archs_on_detail_id ON module_archs USING btree (detail_id);
--
--- Name: index_module_authors_on_detail_id; Type: INDEX; Schema: public; Owner: -; Tablespace:
+-- Name: index_module_authors_on_detail_id; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX index_module_authors_on_detail_id ON module_authors USING btree (detail_id);
--
--- Name: index_module_details_on_description; Type: INDEX; Schema: public; Owner: -; Tablespace:
+-- Name: index_module_details_on_description; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX index_module_details_on_description ON module_details USING btree (description);
--
--- Name: index_module_details_on_mtype; Type: INDEX; Schema: public; Owner: -; Tablespace:
+-- Name: index_module_details_on_mtype; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX index_module_details_on_mtype ON module_details USING btree (mtype);
--
--- Name: index_module_details_on_name; Type: INDEX; Schema: public; Owner: -; Tablespace:
+-- Name: index_module_details_on_name; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX index_module_details_on_name ON module_details USING btree (name);
--
--- Name: index_module_details_on_refname; Type: INDEX; Schema: public; Owner: -; Tablespace:
+-- Name: index_module_details_on_refname; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX index_module_details_on_refname ON module_details USING btree (refname);
--
--- Name: index_module_mixins_on_detail_id; Type: INDEX; Schema: public; Owner: -; Tablespace:
+-- Name: index_module_mixins_on_detail_id; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX index_module_mixins_on_detail_id ON module_mixins USING btree (detail_id);
--
--- Name: index_module_platforms_on_detail_id; Type: INDEX; Schema: public; Owner: -; Tablespace:
+-- Name: index_module_platforms_on_detail_id; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX index_module_platforms_on_detail_id ON module_platforms USING btree (detail_id);
--
--- Name: index_module_refs_on_detail_id; Type: INDEX; Schema: public; Owner: -; Tablespace:
+-- Name: index_module_refs_on_detail_id; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX index_module_refs_on_detail_id ON module_refs USING btree (detail_id);
--
--- Name: index_module_refs_on_name; Type: INDEX; Schema: public; Owner: -; Tablespace:
+-- Name: index_module_refs_on_name; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX index_module_refs_on_name ON module_refs USING btree (name);
--
--- Name: index_module_runs_on_session_id; Type: INDEX; Schema: public; Owner: -; Tablespace:
+-- Name: index_module_runs_on_session_id; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX index_module_runs_on_session_id ON module_runs USING btree (session_id);
--
--- Name: index_module_runs_on_user_id; Type: INDEX; Schema: public; Owner: -; Tablespace:
+-- Name: index_module_runs_on_user_id; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX index_module_runs_on_user_id ON module_runs USING btree (user_id);
--
--- Name: index_module_targets_on_detail_id; Type: INDEX; Schema: public; Owner: -; Tablespace:
+-- Name: index_module_targets_on_detail_id; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX index_module_targets_on_detail_id ON module_targets USING btree (detail_id);
--
--- Name: index_notes_on_ntype; Type: INDEX; Schema: public; Owner: -; Tablespace:
+-- Name: index_notes_on_ntype; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX index_notes_on_ntype ON notes USING btree (ntype);
--
--- Name: index_notes_on_vuln_id; Type: INDEX; Schema: public; Owner: -; Tablespace:
+-- Name: index_notes_on_vuln_id; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX index_notes_on_vuln_id ON notes USING btree (vuln_id);
--
--- Name: index_refs_on_name; Type: INDEX; Schema: public; Owner: -; Tablespace:
+-- Name: index_refs_on_name; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX index_refs_on_name ON refs USING btree (name);
--
--- Name: index_services_on_host_id_and_port_and_proto; Type: INDEX; Schema: public; Owner: -; Tablespace:
+-- Name: index_services_on_host_id_and_port_and_proto; Type: INDEX; Schema: public; Owner: -
--
CREATE UNIQUE INDEX index_services_on_host_id_and_port_and_proto ON services USING btree (host_id, port, proto);
--
--- Name: index_services_on_name; Type: INDEX; Schema: public; Owner: -; Tablespace:
+-- Name: index_services_on_name; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX index_services_on_name ON services USING btree (name);
--
--- Name: index_services_on_port; Type: INDEX; Schema: public; Owner: -; Tablespace:
+-- Name: index_services_on_port; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX index_services_on_port ON services USING btree (port);
--
--- Name: index_services_on_proto; Type: INDEX; Schema: public; Owner: -; Tablespace:
+-- Name: index_services_on_proto; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX index_services_on_proto ON services USING btree (proto);
--
--- Name: index_services_on_state; Type: INDEX; Schema: public; Owner: -; Tablespace:
+-- Name: index_services_on_state; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX index_services_on_state ON services USING btree (state);
--
--- Name: index_sessions_on_module_run_id; Type: INDEX; Schema: public; Owner: -; Tablespace:
+-- Name: index_sessions_on_module_run_id; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX index_sessions_on_module_run_id ON sessions USING btree (module_run_id);
--
--- Name: index_vulns_on_name; Type: INDEX; Schema: public; Owner: -; Tablespace:
+-- Name: index_vulns_on_name; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX index_vulns_on_name ON vulns USING btree (name);
--
--- Name: index_vulns_on_origin_id; Type: INDEX; Schema: public; Owner: -; Tablespace:
+-- Name: index_vulns_on_origin_id; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX index_vulns_on_origin_id ON vulns USING btree (origin_id);
--
--- Name: index_web_forms_on_path; Type: INDEX; Schema: public; Owner: -; Tablespace:
+-- Name: index_web_forms_on_path; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX index_web_forms_on_path ON web_forms USING btree (path);
--
--- Name: index_web_pages_on_path; Type: INDEX; Schema: public; Owner: -; Tablespace:
+-- Name: index_web_pages_on_path; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX index_web_pages_on_path ON web_pages USING btree (path);
--
--- Name: index_web_pages_on_query; Type: INDEX; Schema: public; Owner: -; Tablespace:
+-- Name: index_web_pages_on_query; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX index_web_pages_on_query ON web_pages USING btree (query);
--
--- Name: index_web_sites_on_comments; Type: INDEX; Schema: public; Owner: -; Tablespace:
+-- Name: index_web_sites_on_comments; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX index_web_sites_on_comments ON web_sites USING btree (comments);
--
--- Name: index_web_sites_on_options; Type: INDEX; Schema: public; Owner: -; Tablespace:
+-- Name: index_web_sites_on_options; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX index_web_sites_on_options ON web_sites USING btree (options);
--
--- Name: index_web_sites_on_vhost; Type: INDEX; Schema: public; Owner: -; Tablespace:
+-- Name: index_web_sites_on_vhost; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX index_web_sites_on_vhost ON web_sites USING btree (vhost);
--
--- Name: index_web_vulns_on_method; Type: INDEX; Schema: public; Owner: -; Tablespace:
+-- Name: index_web_vulns_on_method; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX index_web_vulns_on_method ON web_vulns USING btree (method);
--
--- Name: index_web_vulns_on_name; Type: INDEX; Schema: public; Owner: -; Tablespace:
+-- Name: index_web_vulns_on_name; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX index_web_vulns_on_name ON web_vulns USING btree (name);
--
--- Name: index_web_vulns_on_path; Type: INDEX; Schema: public; Owner: -; Tablespace:
+-- Name: index_web_vulns_on_path; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX index_web_vulns_on_path ON web_vulns USING btree (path);
--
--- Name: originating_credential_cores; Type: INDEX; Schema: public; Owner: -; Tablespace:
+-- Name: originating_credential_cores; Type: INDEX; Schema: public; Owner: -
--
CREATE INDEX originating_credential_cores ON metasploit_credential_origin_cracked_passwords USING btree (metasploit_credential_core_id);
--
--- Name: unique_complete_metasploit_credential_cores; Type: INDEX; Schema: public; Owner: -; Tablespace:
+-- Name: unique_complete_metasploit_credential_cores; Type: INDEX; Schema: public; Owner: -
--
-CREATE UNIQUE INDEX unique_complete_metasploit_credential_cores ON metasploit_credential_cores USING btree (workspace_id, realm_id, public_id, private_id) WHERE (((realm_id IS NOT NULL) AND (public_id IS NOT NULL)) AND (private_id IS NOT NULL));
+CREATE UNIQUE INDEX unique_complete_metasploit_credential_cores ON metasploit_credential_cores USING btree (workspace_id, realm_id, public_id, private_id) WHERE ((realm_id IS NOT NULL) AND (public_id IS NOT NULL) AND (private_id IS NOT NULL));
--
--- Name: unique_metasploit_credential_origin_services; Type: INDEX; Schema: public; Owner: -; Tablespace:
+-- Name: unique_metasploit_credential_origin_services; Type: INDEX; Schema: public; Owner: -
--
CREATE UNIQUE INDEX unique_metasploit_credential_origin_services ON metasploit_credential_origin_services USING btree (service_id, module_full_name);
--
--- Name: unique_metasploit_credential_origin_sessions; Type: INDEX; Schema: public; Owner: -; Tablespace:
+-- Name: unique_metasploit_credential_origin_sessions; Type: INDEX; Schema: public; Owner: -
--
CREATE UNIQUE INDEX unique_metasploit_credential_origin_sessions ON metasploit_credential_origin_sessions USING btree (session_id, post_reference_name);
--
--- Name: unique_private_metasploit_credential_cores; Type: INDEX; Schema: public; Owner: -; Tablespace:
+-- Name: unique_private_metasploit_credential_cores; Type: INDEX; Schema: public; Owner: -
--
-CREATE UNIQUE INDEX unique_private_metasploit_credential_cores ON metasploit_credential_cores USING btree (workspace_id, private_id) WHERE (((realm_id IS NULL) AND (public_id IS NULL)) AND (private_id IS NOT NULL));
+CREATE UNIQUE INDEX unique_private_metasploit_credential_cores ON metasploit_credential_cores USING btree (workspace_id, private_id) WHERE ((realm_id IS NULL) AND (public_id IS NULL) AND (private_id IS NOT NULL));
--
--- Name: unique_privateless_metasploit_credential_cores; Type: INDEX; Schema: public; Owner: -; Tablespace:
+-- Name: unique_privateless_metasploit_credential_cores; Type: INDEX; Schema: public; Owner: -
--
-CREATE UNIQUE INDEX unique_privateless_metasploit_credential_cores ON metasploit_credential_cores USING btree (workspace_id, realm_id, public_id) WHERE (((realm_id IS NOT NULL) AND (public_id IS NOT NULL)) AND (private_id IS NULL));
+CREATE UNIQUE INDEX unique_privateless_metasploit_credential_cores ON metasploit_credential_cores USING btree (workspace_id, realm_id, public_id) WHERE ((realm_id IS NOT NULL) AND (public_id IS NOT NULL) AND (private_id IS NULL));
--
--- Name: unique_public_metasploit_credential_cores; Type: INDEX; Schema: public; Owner: -; Tablespace:
+-- Name: unique_public_metasploit_credential_cores; Type: INDEX; Schema: public; Owner: -
--
-CREATE UNIQUE INDEX unique_public_metasploit_credential_cores ON metasploit_credential_cores USING btree (workspace_id, public_id) WHERE (((realm_id IS NULL) AND (public_id IS NOT NULL)) AND (private_id IS NULL));
+CREATE UNIQUE INDEX unique_public_metasploit_credential_cores ON metasploit_credential_cores USING btree (workspace_id, public_id) WHERE ((realm_id IS NULL) AND (public_id IS NOT NULL) AND (private_id IS NULL));
--
--- Name: unique_publicless_metasploit_credential_cores; Type: INDEX; Schema: public; Owner: -; Tablespace:
+-- Name: unique_publicless_metasploit_credential_cores; Type: INDEX; Schema: public; Owner: -
--
-CREATE UNIQUE INDEX unique_publicless_metasploit_credential_cores ON metasploit_credential_cores USING btree (workspace_id, realm_id, private_id) WHERE (((realm_id IS NOT NULL) AND (public_id IS NULL)) AND (private_id IS NOT NULL));
+CREATE UNIQUE INDEX unique_publicless_metasploit_credential_cores ON metasploit_credential_cores USING btree (workspace_id, realm_id, private_id) WHERE ((realm_id IS NOT NULL) AND (public_id IS NULL) AND (private_id IS NOT NULL));
--
--- Name: unique_realmless_metasploit_credential_cores; Type: INDEX; Schema: public; Owner: -; Tablespace:
+-- Name: unique_realmless_metasploit_credential_cores; Type: INDEX; Schema: public; Owner: -
--
-CREATE UNIQUE INDEX unique_realmless_metasploit_credential_cores ON metasploit_credential_cores USING btree (workspace_id, public_id, private_id) WHERE (((realm_id IS NULL) AND (public_id IS NOT NULL)) AND (private_id IS NOT NULL));
+CREATE UNIQUE INDEX unique_realmless_metasploit_credential_cores ON metasploit_credential_cores USING btree (workspace_id, public_id, private_id) WHERE ((realm_id IS NULL) AND (public_id IS NOT NULL) AND (private_id IS NOT NULL));
--
--- Name: unique_schema_migrations; Type: INDEX; Schema: public; Owner: -; Tablespace:
+-- Name: unique_schema_migrations; Type: INDEX; Schema: public; Owner: -
--
CREATE UNIQUE INDEX unique_schema_migrations ON schema_migrations USING btree (version);
--
-- PostgreSQL database dump complete
--
-SET search_path TO "$user",public;
+SET search_path TO "$user", public;
INSERT INTO schema_migrations (version) VALUES ('0');
INSERT INTO schema_migrations (version) VALUES ('1');
@@ -4083,12 +4090,16 @@
INSERT INTO schema_migrations (version) VALUES ('20150514182921');
INSERT INTO schema_migrations (version) VALUES ('20160415153312');
+INSERT INTO schema_migrations (version) VALUES ('20161004165612');
+
INSERT INTO schema_migrations (version) VALUES ('20161107153145');
INSERT INTO schema_migrations (version) VALUES ('20161107203710');
+
+INSERT INTO schema_migrations (version) VALUES ('20161227212223');
INSERT INTO schema_migrations (version) VALUES ('21');
INSERT INTO schema_migrations (version) VALUES ('22');