description character varying(524288),
properties text,
expires_at date,
- file_names character varying(4096)
+ file_names character varying(8192)
);
properties text,
state character varying(255),
components_summary text,
- description character varying(524288),
started_at timestamp without time zone,
- finished_at timestamp without time zone
+ finished_at timestamp without time zone,
+ description character varying(524288)
);
CREATE UNIQUE INDEX collection_owner_uuid_name_unique ON collections USING btree (owner_uuid, name);
+--
+-- Name: collections_manifest_full_text_search_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
+--
+
+CREATE INDEX collections_manifest_full_text_search_idx ON collections USING gin (to_tsvector('english'::regconfig, translate(manifest_text, '/.'::text, ' '::text)));
+
+
--
-- Name: collections_search_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
--
CREATE INDEX nodes_search_index ON nodes USING btree (uuid, owner_uuid, modified_by_client_uuid, modified_by_user_uuid, hostname, domain, ip_address, job_uuid);
+--
+-- Name: pipeline_instances_components_full_text_search_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
+--
+
+CREATE INDEX pipeline_instances_components_full_text_search_idx ON pipeline_instances USING gin (to_tsvector('english'::regconfig, translate(components, '/.'::text, ' '::text)));
+
+
--
-- Name: pipeline_instances_search_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
--
INSERT INTO schema_migrations (version) VALUES ('20141208174653');
-INSERT INTO schema_migrations (version) VALUES ('20141208185217');
\ No newline at end of file
+INSERT INTO schema_migrations (version) VALUES ('20141208185217');
+
+INSERT INTO schema_migrations (version) VALUES ('20150116142953');
\ No newline at end of file