From 7d6b0f37bf50907bc0664e177c1c8c8cc697b4f8 Mon Sep 17 00:00:00 2001 From: Radhika Chippada Date: Mon, 5 Jan 2015 16:36:31 -0500 Subject: [PATCH] 4523: set description size to 2**17, which seems to be the upper limit for indexing. --- .../20141208174553_descriptions_are_strings.rb | 2 +- services/api/db/structure.sql | 12 ++++++------ 2 files changed, 7 insertions(+), 7 deletions(-) diff --git a/services/api/db/migrate/20141208174553_descriptions_are_strings.rb b/services/api/db/migrate/20141208174553_descriptions_are_strings.rb index 412b427c72..3c21755dc0 100644 --- a/services/api/db/migrate/20141208174553_descriptions_are_strings.rb +++ b/services/api/db/migrate/20141208174553_descriptions_are_strings.rb @@ -5,7 +5,7 @@ class DescriptionsAreStrings < ActiveRecord::Migration def up tables_with_description_column.each do |table| - change_column table.to_sym, :description, :string, :limit => 2**19 + change_column table.to_sym, :description, :string, :limit => 2**17 end end diff --git a/services/api/db/structure.sql b/services/api/db/structure.sql index 91fc27866f..2cf8473527 100644 --- a/services/api/db/structure.sql +++ b/services/api/db/structure.sql @@ -167,7 +167,7 @@ CREATE TABLE collections ( uuid character varying(255), manifest_text text, name character varying(255), - description character varying(524288), + description character varying(131072), properties text, expires_at date ); @@ -272,7 +272,7 @@ CREATE TABLE groups ( modified_by_user_uuid character varying(255), modified_at timestamp without time zone, name character varying(255) NOT NULL, - description character varying(524288), + description character varying(131072), updated_at timestamp without time zone NOT NULL, group_class character varying(255) ); @@ -431,7 +431,7 @@ CREATE TABLE jobs ( supplied_script_version character varying(255), docker_image_locator character varying(255), priority integer DEFAULT 0 NOT NULL, - description character varying(524288), + description character varying(131072), state character varying(255), arvados_sdk_version character varying(255) ); @@ -685,9 +685,9 @@ CREATE TABLE pipeline_instances ( properties text, state character varying(255), components_summary text, + description character varying(131072), started_at timestamp without time zone, - finished_at timestamp without time zone, - description character varying(524288) + finished_at timestamp without time zone ); @@ -725,7 +725,7 @@ CREATE TABLE pipeline_templates ( name character varying(255), components text, updated_at timestamp without time zone NOT NULL, - description character varying(524288) + description character varying(131072) ); -- 2.30.2