spec/dummy/db/structure.sql in metasploit-credential-0.14.8 vs spec/dummy/db/structure.sql in metasploit-credential-1.0.0.pre.rails.pre.4.0b

- old
+ new

@@ -1,10 +1,11 @@ -- -- PostgreSQL database dump -- SET statement_timeout = 0; +SET lock_timeout = 0; SET client_encoding = 'UTF8'; SET standard_conforming_strings = on; SET check_function_bodies = false; SET client_min_messages = warning; @@ -3324,21 +3325,21 @@ 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_fullname; Type: INDEX; Schema: public; Owner: -; Tablespace: +-- Name: index_automatic_exploitation_matches_on_module_detail_id; Type: INDEX; Schema: public; Owner: -; Tablespace: -- -CREATE INDEX index_automatic_exploitation_matches_on_module_fullname ON automatic_exploitation_matches USING btree (module_fullname); +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_ref_id; Type: INDEX; Schema: public; Owner: -; Tablespace: +-- Name: index_automatic_exploitation_matches_on_module_fullname; Type: INDEX; Schema: public; Owner: -; Tablespace: -- -CREATE INDEX index_automatic_exploitation_matches_on_ref_id ON automatic_exploitation_matches USING btree (module_detail_id); +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: -- @@ -3492,28 +3493,28 @@ CREATE UNIQUE INDEX index_metasploit_credential_realms_on_key_and_value ON metasploit_credential_realms USING btree (key, value); -- --- Name: index_module_actions_on_module_detail_id; Type: INDEX; Schema: public; Owner: -; Tablespace: +-- Name: index_module_actions_on_detail_id; Type: INDEX; Schema: public; Owner: -; Tablespace: -- -CREATE INDEX index_module_actions_on_module_detail_id ON module_actions USING btree (detail_id); +CREATE INDEX index_module_actions_on_detail_id ON module_actions USING btree (detail_id); -- --- Name: index_module_archs_on_module_detail_id; Type: INDEX; Schema: public; Owner: -; Tablespace: +-- Name: index_module_archs_on_detail_id; Type: INDEX; Schema: public; Owner: -; Tablespace: -- -CREATE INDEX index_module_archs_on_module_detail_id ON module_archs USING btree (detail_id); +CREATE INDEX index_module_archs_on_detail_id ON module_archs USING btree (detail_id); -- --- Name: index_module_authors_on_module_detail_id; Type: INDEX; Schema: public; Owner: -; Tablespace: +-- Name: index_module_authors_on_detail_id; Type: INDEX; Schema: public; Owner: -; Tablespace: -- -CREATE INDEX index_module_authors_on_module_detail_id ON module_authors USING btree (detail_id); +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: -- @@ -3541,28 +3542,28 @@ CREATE INDEX index_module_details_on_refname ON module_details USING btree (refname); -- --- Name: index_module_mixins_on_module_detail_id; Type: INDEX; Schema: public; Owner: -; Tablespace: +-- Name: index_module_mixins_on_detail_id; Type: INDEX; Schema: public; Owner: -; Tablespace: -- -CREATE INDEX index_module_mixins_on_module_detail_id ON module_mixins USING btree (detail_id); +CREATE INDEX index_module_mixins_on_detail_id ON module_mixins USING btree (detail_id); -- --- Name: index_module_platforms_on_module_detail_id; Type: INDEX; Schema: public; Owner: -; Tablespace: +-- Name: index_module_platforms_on_detail_id; Type: INDEX; Schema: public; Owner: -; Tablespace: -- -CREATE INDEX index_module_platforms_on_module_detail_id ON module_platforms USING btree (detail_id); +CREATE INDEX index_module_platforms_on_detail_id ON module_platforms USING btree (detail_id); -- --- Name: index_module_refs_on_module_detail_id; Type: INDEX; Schema: public; Owner: -; Tablespace: +-- Name: index_module_refs_on_detail_id; Type: INDEX; Schema: public; Owner: -; Tablespace: -- -CREATE INDEX index_module_refs_on_module_detail_id ON module_refs USING btree (detail_id); +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: -- @@ -3583,14 +3584,14 @@ CREATE INDEX index_module_runs_on_user_id ON module_runs USING btree (user_id); -- --- Name: index_module_targets_on_module_detail_id; Type: INDEX; Schema: public; Owner: -; Tablespace: +-- Name: index_module_targets_on_detail_id; Type: INDEX; Schema: public; Owner: -; Tablespace: -- -CREATE INDEX index_module_targets_on_module_detail_id ON module_targets USING btree (detail_id); +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: -- @@ -4056,12 +4057,16 @@ INSERT INTO schema_migrations (version) VALUES ('20150226151459'); INSERT INTO schema_migrations (version) VALUES ('20150312155312'); +INSERT INTO schema_migrations (version) VALUES ('20150317145455'); + INSERT INTO schema_migrations (version) VALUES ('20150326183742'); +INSERT INTO schema_migrations (version) VALUES ('20150421211719'); + INSERT INTO schema_migrations (version) VALUES ('21'); INSERT INTO schema_migrations (version) VALUES ('22'); INSERT INTO schema_migrations (version) VALUES ('23'); @@ -4082,6 +4087,6 @@ INSERT INTO schema_migrations (version) VALUES ('7'); INSERT INTO schema_migrations (version) VALUES ('8'); -INSERT INTO schema_migrations (version) VALUES ('9'); \ No newline at end of file +INSERT INTO schema_migrations (version) VALUES ('9');