spec/dummy/db/structure.sql in metasploit-credential-1.1.0 vs spec/dummy/db/structure.sql in metasploit-credential-2.0.0
- old
+ new
@@ -66,11 +66,11 @@
CREATE TABLE automatic_exploitation_match_results (
id integer NOT NULL,
match_id integer,
run_id integer,
- state character varying(255) NOT NULL,
+ state character varying NOT NULL,
created_at timestamp without time zone NOT NULL,
updated_at timestamp without time zone NOT NULL
);
@@ -130,16 +130,16 @@
--
CREATE TABLE automatic_exploitation_matches (
id integer NOT NULL,
module_detail_id integer,
- state character varying(255),
+ state character varying,
nexpose_data_vulnerability_definition_id integer,
created_at timestamp without time zone NOT NULL,
updated_at timestamp without time zone NOT NULL,
match_set_id integer,
- matchable_type character varying(255),
+ matchable_type character varying,
matchable_id integer,
module_fullname text
);
@@ -262,11 +262,11 @@
pass character varying(4096),
active boolean DEFAULT true,
proof character varying(4096),
ptype character varying(256),
source_id integer,
- source_type character varying(255)
+ source_type character varying
);
--
-- Name: creds_id_seq; Type: SEQUENCE; Schema: public; Owner: -
@@ -294,15 +294,15 @@
CREATE TABLE events (
id integer NOT NULL,
workspace_id integer,
host_id integer,
created_at timestamp without time zone,
- name character varying(255),
+ name character varying,
updated_at timestamp without time zone,
critical boolean,
seen boolean,
- username character varying(255),
+ username character varying,
info text
);
--
@@ -333,17 +333,17 @@
host_id integer,
service_id integer,
vuln_id integer,
attempted_at timestamp without time zone,
exploited boolean,
- fail_reason character varying(255),
- username character varying(255),
+ fail_reason character varying,
+ username character varying,
module text,
session_id integer,
loot_id integer,
port integer,
- proto character varying(255),
+ proto character varying,
fail_detail text
);
--
@@ -407,14 +407,14 @@
CREATE TABLE host_details (
id integer NOT NULL,
host_id integer,
nx_console_id integer,
nx_device_id integer,
- src character varying(255),
- nx_site_name character varying(255),
- nx_site_importance character varying(255),
- nx_scan_template character varying(255),
+ src character varying,
+ nx_site_name character varying,
+ nx_site_importance character varying,
+ nx_scan_template character varying,
nx_risk_score double precision
);
--
@@ -442,19 +442,19 @@
CREATE TABLE hosts (
id integer NOT NULL,
created_at timestamp without time zone,
address inet NOT NULL,
- mac character varying(255),
- comm character varying(255),
- name character varying(255),
- state character varying(255),
- os_name character varying(255),
- os_flavor character varying(255),
- os_sp character varying(255),
- os_lang character varying(255),
- arch character varying(255),
+ mac character varying,
+ comm character varying,
+ name character varying,
+ state character varying,
+ os_name character varying,
+ os_flavor character varying,
+ os_sp character varying,
+ os_lang character varying,
+ arch character varying,
workspace_id integer NOT NULL,
updated_at timestamp without time zone,
purpose text,
info character varying(65536),
comments text,
@@ -464,11 +464,11 @@
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(255)
+ detected_arch character varying
);
--
-- Name: hosts_id_seq; Type: SEQUENCE; Schema: public; Owner: -
@@ -570,11 +570,11 @@
ltype character varying(512),
path character varying(1024),
data text,
created_at timestamp without time zone NOT NULL,
updated_at timestamp without time zone NOT NULL,
- content_type character varying(255),
+ content_type character varying,
name text,
info text,
module_run_id integer
);
@@ -638,11 +638,11 @@
--
CREATE TABLE metasploit_credential_cores (
id integer NOT NULL,
origin_id integer NOT NULL,
- origin_type character varying(255) NOT NULL,
+ origin_type character varying NOT NULL,
private_id integer,
public_id integer,
realm_id integer,
workspace_id integer NOT NULL,
created_at timestamp without time zone NOT NULL,
@@ -676,12 +676,12 @@
CREATE TABLE metasploit_credential_logins (
id integer NOT NULL,
core_id integer NOT NULL,
service_id integer NOT NULL,
- access_level character varying(255),
- status character varying(255) NOT NULL,
+ access_level character varying,
+ status character varying NOT NULL,
last_attempted_at timestamp without time zone,
created_at timestamp without time zone NOT NULL,
updated_at timestamp without time zone NOT NULL
);
@@ -867,15 +867,15 @@
-- Name: metasploit_credential_privates; Type: TABLE; Schema: public; Owner: -; Tablespace:
--
CREATE TABLE metasploit_credential_privates (
id integer NOT NULL,
- type character varying(255) NOT NULL,
+ type character varying NOT NULL,
data text NOT NULL,
created_at timestamp without time zone NOT NULL,
updated_at timestamp without time zone NOT NULL,
- jtr_format character varying(255)
+ jtr_format character varying
);
--
-- Name: metasploit_credential_privates_id_seq; Type: SEQUENCE; Schema: public; Owner: -
@@ -900,14 +900,14 @@
-- Name: metasploit_credential_publics; Type: TABLE; Schema: public; Owner: -; Tablespace:
--
CREATE TABLE metasploit_credential_publics (
id integer NOT NULL,
- username character varying(255) NOT NULL,
+ username character varying NOT NULL,
created_at timestamp without time zone NOT NULL,
updated_at timestamp without time zone NOT NULL,
- type character varying(255) NOT NULL
+ type character varying NOT NULL
);
--
-- Name: metasploit_credential_publics_id_seq; Type: SEQUENCE; Schema: public; Owner: -
@@ -932,12 +932,12 @@
-- Name: metasploit_credential_realms; Type: TABLE; Schema: public; Owner: -; Tablespace:
--
CREATE TABLE metasploit_credential_realms (
id integer NOT NULL,
- key character varying(255) NOT NULL,
- value character varying(255) NOT NULL,
+ key character varying NOT NULL,
+ value character varying NOT NULL,
created_at timestamp without time zone NOT NULL,
updated_at timestamp without time zone NOT NULL
);
@@ -1088,22 +1088,22 @@
CREATE TABLE module_details (
id integer NOT NULL,
mtime timestamp without time zone,
file text,
- mtype character varying(255),
+ mtype character varying,
refname text,
fullname text,
name text,
rank integer,
description text,
- license character varying(255),
+ license character varying,
privileged boolean,
disclosure_date timestamp without time zone,
default_target integer,
default_action text,
- stance character varying(255),
+ stance character varying,
ready boolean
);
--
@@ -1221,20 +1221,20 @@
CREATE TABLE module_runs (
id integer NOT NULL,
attempted_at timestamp without time zone,
fail_detail text,
- fail_reason character varying(255),
+ fail_reason character varying,
module_fullname text,
port integer,
- proto character varying(255),
+ proto character varying,
session_id integer,
- status character varying(255),
+ status character varying,
trackable_id integer,
- trackable_type character varying(255),
+ trackable_type character varying,
user_id integer,
- username character varying(255),
+ username character varying,
created_at timestamp without time zone NOT NULL,
updated_at timestamp without time zone NOT NULL
);
@@ -1438,11 +1438,11 @@
--
CREATE TABLE report_templates (
id integer NOT NULL,
workspace_id integer DEFAULT 1 NOT NULL,
- created_by character varying(255),
+ created_by character varying,
path character varying(1024),
name text,
created_at timestamp without time zone NOT NULL,
updated_at timestamp without time zone NOT NULL
);
@@ -1472,12 +1472,12 @@
--
CREATE TABLE reports (
id integer NOT NULL,
workspace_id integer DEFAULT 1 NOT NULL,
- created_by character varying(255),
- rtype character varying(255),
+ created_by character varying,
+ rtype character varying,
path character varying(1024),
options text,
created_at timestamp without time zone NOT NULL,
updated_at timestamp without time zone NOT NULL,
downloaded_at timestamp without time zone,
@@ -1510,12 +1510,12 @@
--
CREATE TABLE routes (
id integer NOT NULL,
session_id integer,
- subnet character varying(255),
- netmask character varying(255)
+ subnet character varying,
+ netmask character varying
);
--
-- Name: routes_id_seq; Type: SEQUENCE; Schema: public; Owner: -
@@ -1539,11 +1539,11 @@
--
-- Name: schema_migrations; Type: TABLE; Schema: public; Owner: -; Tablespace:
--
CREATE TABLE schema_migrations (
- version character varying(255) NOT NULL
+ version character varying NOT NULL
);
--
-- Name: services; Type: TABLE; Schema: public; Owner: -; Tablespace:
@@ -1553,12 +1553,12 @@
id integer NOT NULL,
host_id integer,
created_at timestamp without time zone,
port integer NOT NULL,
proto character varying(16) NOT NULL,
- state character varying(255),
- name character varying(255),
+ state character varying,
+ name character varying,
updated_at timestamp without time zone,
info text
);
@@ -1586,15 +1586,15 @@
--
CREATE TABLE session_events (
id integer NOT NULL,
session_id integer,
- etype character varying(255),
+ etype character varying,
command bytea,
output bytea,
- remote_path character varying(255),
- local_path character varying(255),
+ remote_path character varying,
+ local_path character varying,
created_at timestamp without time zone
);
--
@@ -1621,20 +1621,20 @@
--
CREATE TABLE sessions (
id integer NOT NULL,
host_id integer,
- stype character varying(255),
- via_exploit character varying(255),
- via_payload character varying(255),
- "desc" character varying(255),
+ stype character varying,
+ via_exploit character varying,
+ via_payload character varying,
+ "desc" character varying,
port integer,
- platform character varying(255),
+ platform character varying,
datastore text,
opened_at timestamp without time zone NOT NULL,
closed_at timestamp without time zone,
- close_reason character varying(255),
+ close_reason character varying,
local_id integer,
last_seen timestamp without time zone,
module_run_id integer
);
@@ -1827,16 +1827,16 @@
--
CREATE TABLE tasks (
id integer NOT NULL,
workspace_id integer DEFAULT 1 NOT NULL,
- created_by character varying(255),
- module character varying(255),
+ created_by character varying,
+ module character varying,
completed_at timestamp without time zone,
path character varying(1024),
- info character varying(255),
- description character varying(255),
+ info character varying,
+ description character varying,
progress integer,
options text,
error text,
created_at timestamp without time zone NOT NULL,
updated_at timestamp without time zone NOT NULL,
@@ -1869,20 +1869,20 @@
-- Name: users; Type: TABLE; Schema: public; Owner: -; Tablespace:
--
CREATE TABLE users (
id integer NOT NULL,
- username character varying(255),
- crypted_password character varying(255),
- password_salt character varying(255),
- persistence_token character varying(255),
+ username character varying,
+ crypted_password character varying,
+ password_salt character varying,
+ persistence_token character varying,
created_at timestamp without time zone NOT NULL,
updated_at timestamp without time zone NOT NULL,
- fullname character varying(255),
- email character varying(255),
- phone character varying(255),
- company character varying(255),
+ fullname character varying,
+ email character varying,
+ phone character varying,
+ company character varying,
prefs character varying(524288),
admin boolean DEFAULT true NOT NULL
);
@@ -1912,12 +1912,12 @@
CREATE TABLE vuln_attempts (
id integer NOT NULL,
vuln_id integer,
attempted_at timestamp without time zone,
exploited boolean,
- fail_reason character varying(255),
- username character varying(255),
+ fail_reason character varying,
+ username character varying,
module text,
session_id integer,
loot_id integer,
fail_detail text
);
@@ -1948,30 +1948,30 @@
CREATE TABLE vuln_details (
id integer NOT NULL,
vuln_id integer,
cvss_score double precision,
- cvss_vector character varying(255),
- title character varying(255),
+ cvss_vector character varying,
+ title character varying,
description text,
solution text,
proof bytea,
nx_console_id integer,
nx_device_id integer,
- nx_vuln_id character varying(255),
+ nx_vuln_id character varying,
nx_severity double precision,
nx_pci_severity double precision,
nx_published timestamp without time zone,
nx_added timestamp without time zone,
nx_modified timestamp without time zone,
nx_tags text,
nx_vuln_status text,
nx_proof_key text,
- src character varying(255),
+ src character varying,
nx_scan_id integer,
nx_vulnerable_since timestamp without time zone,
- nx_pci_compliance_status character varying(255)
+ nx_pci_compliance_status character varying
);
--
-- Name: vuln_details_id_seq; Type: SEQUENCE; Schema: public; Owner: -
@@ -1999,18 +1999,18 @@
CREATE TABLE vulns (
id integer NOT NULL,
host_id integer,
service_id integer,
created_at timestamp without time zone,
- name character varying(255),
+ name character varying,
updated_at timestamp without time zone,
info character varying(65536),
exploited_at timestamp without time zone,
vuln_detail_count integer DEFAULT 0,
vuln_attempt_count integer DEFAULT 0,
origin_id integer,
- origin_type character varying(255)
+ origin_type character varying
);
--
-- Name: vulns_id_seq; Type: SEQUENCE; Schema: public; Owner: -
@@ -2181,22 +2181,22 @@
web_site_id integer NOT NULL,
created_at timestamp without time zone NOT NULL,
updated_at timestamp without time zone NOT NULL,
path text NOT NULL,
method character varying(1024) NOT NULL,
- params text NOT NULL,
+ params text,
pname text,
risk integer NOT NULL,
name character varying(1024) NOT NULL,
query text,
category text NOT NULL,
confidence integer NOT NULL,
description text,
blame text,
request bytea,
proof bytea NOT NULL,
- owner character varying(255),
+ owner character varying,
payload text
);
--
@@ -2222,11 +2222,11 @@
-- Name: wmap_requests; Type: TABLE; Schema: public; Owner: -; Tablespace:
--
CREATE TABLE wmap_requests (
id integer NOT NULL,
- host character varying(255),
+ host character varying,
address inet,
port integer,
ssl integer,
meth character varying(32),
path text,
@@ -2264,11 +2264,11 @@
-- Name: wmap_targets; Type: TABLE; Schema: public; Owner: -; Tablespace:
--
CREATE TABLE wmap_targets (
id integer NOT NULL,
- host character varying(255),
+ host character varying,
address inet,
port integer,
ssl integer,
selected integer,
created_at timestamp without time zone,
@@ -2309,11 +2309,11 @@
-- Name: workspaces; Type: TABLE; Schema: public; Owner: -; Tablespace:
--
CREATE TABLE workspaces (
id integer NOT NULL,
- name character varying(255),
+ 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,
@@ -4074,10 +4074,12 @@
INSERT INTO schema_migrations (version) VALUES ('20150421211719');
INSERT INTO schema_migrations (version) VALUES ('20150514182921');
+INSERT INTO schema_migrations (version) VALUES ('20160415153312');
+
INSERT INTO schema_migrations (version) VALUES ('21');
INSERT INTO schema_migrations (version) VALUES ('22');
INSERT INTO schema_migrations (version) VALUES ('23');
@@ -4099,5 +4101,6 @@
INSERT INTO schema_migrations (version) VALUES ('7');
INSERT INTO schema_migrations (version) VALUES ('8');
INSERT INTO schema_migrations (version) VALUES ('9');
+