X-Git-Url: https://git.arvados.org/arvados.git/blobdiff_plain/da1614ac6d9b1b2aeba6267b304ce70c1726b608..df91e9651a0075415a257be97f0a92be061141d3:/services/api/db/schema.rb diff --git a/services/api/db/schema.rb b/services/api/db/schema.rb index fc8e43601e..256fa3977e 100644 --- a/services/api/db/schema.rb +++ b/services/api/db/schema.rb @@ -11,7 +11,9 @@ # # It's strongly recommended to check this file into your version control system. -ActiveRecord::Schema.define(:version => 20140423132913) do +ActiveRecord::Schema.define(:version => 20140627210837) do + + create_table "api_client_authorizations", :force => true do |t| t.string "api_token", :null => false @@ -64,23 +66,22 @@ ActiveRecord::Schema.define(:version => 20140423132913) do t.datetime "updated_at", :null => false end - add_index "authorized_keys", ["authorized_user_uuid", "expires_at"], :name => "index_authorized_keys_on_authorized_user_uuid_and_expires_at" + add_index "authorized_keys", ["authorized_user_uuid", "expires_at"], :name => "index_authkeys_on_user_and_expires_at" add_index "authorized_keys", ["uuid"], :name => "index_authorized_keys_on_uuid", :unique => true create_table "collections", :force => true do |t| t.string "locator" t.string "owner_uuid" - t.datetime "created_at" + t.datetime "created_at", :null => false t.string "modified_by_client_uuid" t.string "modified_by_user_uuid" t.datetime "modified_at" t.string "portable_data_hash" - t.string "name" t.integer "redundancy" t.string "redundancy_confirmed_by_client_uuid" t.datetime "redundancy_confirmed_at" t.integer "redundancy_confirmed_as" - t.datetime "updated_at" + t.datetime "updated_at", :null => false t.string "uuid" t.text "manifest_text" end @@ -104,8 +105,8 @@ ActiveRecord::Schema.define(:version => 20140423132913) do t.string "repository_name" t.string "sha1" t.string "message" - t.datetime "created_at" - t.datetime "updated_at" + t.datetime "created_at", :null => false + t.datetime "updated_at", :null => false end add_index "commits", ["repository_name", "sha1"], :name => "index_commits_on_repository_name_and_sha1", :unique => true @@ -120,9 +121,11 @@ ActiveRecord::Schema.define(:version => 20140423132913) do t.string "name" t.text "description" t.datetime "updated_at", :null => false + t.string "group_class" end add_index "groups", ["created_at"], :name => "index_groups_on_created_at" + add_index "groups", ["group_class"], :name => "index_groups_on_group_class" add_index "groups", ["modified_at"], :name => "index_groups_on_modified_at" add_index "groups", ["uuid"], :name => "index_groups_on_uuid", :unique => true @@ -133,8 +136,8 @@ ActiveRecord::Schema.define(:version => 20140423132913) do t.string "modified_by_user_uuid" t.datetime "modified_at" t.text "properties" - t.datetime "created_at" - t.datetime "updated_at" + t.datetime "created_at", :null => false + t.datetime "updated_at", :null => false end add_index "humans", ["uuid"], :name => "index_humans_on_uuid", :unique => true @@ -182,8 +185,8 @@ ActiveRecord::Schema.define(:version => 20140423132913) do t.boolean "running" t.boolean "success" t.string "output" - t.datetime "created_at" - t.datetime "updated_at" + t.datetime "created_at", :null => false + t.datetime "updated_at", :null => false t.string "priority" t.string "is_locked_by_uuid" t.string "log" @@ -192,6 +195,8 @@ ActiveRecord::Schema.define(:version => 20140423132913) do t.boolean "nondeterministic" t.string "repository" t.boolean "output_is_persistent", :default => false, :null => false + t.string "supplied_script_version" + t.string "docker_image_locator" end add_index "jobs", ["created_at"], :name => "index_jobs_on_created_at" @@ -221,21 +226,34 @@ ActiveRecord::Schema.define(:version => 20140423132913) do t.datetime "last_ping_at" t.datetime "created_at", :null => false t.datetime "updated_at", :null => false - t.string "service_host" - t.integer "service_port" - t.boolean "service_ssl_flag" + t.string "keep_service_uuid" end add_index "keep_disks", ["filesystem_uuid"], :name => "index_keep_disks_on_filesystem_uuid" add_index "keep_disks", ["last_ping_at"], :name => "index_keep_disks_on_last_ping_at" add_index "keep_disks", ["node_uuid"], :name => "index_keep_disks_on_node_uuid" - add_index "keep_disks", ["service_host", "service_port", "last_ping_at"], :name => "keep_disks_service_host_port_ping_at_index" add_index "keep_disks", ["uuid"], :name => "index_keep_disks_on_uuid", :unique => true + create_table "keep_services", :force => true do |t| + t.string "uuid", :null => false + t.string "owner_uuid", :null => false + t.string "modified_by_client_uuid" + t.string "modified_by_user_uuid" + t.datetime "modified_at" + t.string "service_host" + t.integer "service_port" + t.boolean "service_ssl_flag" + t.string "service_type" + t.datetime "created_at", :null => false + t.datetime "updated_at", :null => false + end + + add_index "keep_services", ["uuid"], :name => "index_keep_services_on_uuid", :unique => true + create_table "links", :force => true do |t| t.string "uuid" t.string "owner_uuid" - t.datetime "created_at" + t.datetime "created_at", :null => false t.string "modified_by_client_uuid" t.string "modified_by_user_uuid" t.datetime "modified_at" @@ -244,14 +262,13 @@ ActiveRecord::Schema.define(:version => 20140423132913) do t.string "name" t.string "head_uuid" t.text "properties" - t.datetime "updated_at" - t.string "head_kind" - t.string "tail_kind" + t.datetime "updated_at", :null => false end add_index "links", ["created_at"], :name => "index_links_on_created_at" add_index "links", ["head_uuid"], :name => "index_links_on_head_uuid" add_index "links", ["modified_at"], :name => "index_links_on_modified_at" + add_index "links", ["tail_uuid", "name"], :name => "links_tail_name_unique_if_link_class_name", :unique => true, :where => "((link_class)::text = 'name'::text)" add_index "links", ["tail_uuid"], :name => "index_links_on_tail_uuid" add_index "links", ["uuid"], :name => "index_links_on_uuid", :unique => true @@ -305,17 +322,17 @@ ActiveRecord::Schema.define(:version => 20140423132913) do create_table "pipeline_instances", :force => true do |t| t.string "uuid" t.string "owner_uuid" - t.datetime "created_at" + t.datetime "created_at", :null => false t.string "modified_by_client_uuid" t.string "modified_by_user_uuid" t.datetime "modified_at" t.string "pipeline_template_uuid" t.string "name" t.text "components" - t.boolean "success" - t.boolean "active", :default => false - t.datetime "updated_at" + t.datetime "updated_at", :null => false t.text "properties" + t.string "state" + t.text "components_summary" end add_index "pipeline_instances", ["created_at"], :name => "index_pipeline_instances_on_created_at" @@ -332,6 +349,7 @@ ActiveRecord::Schema.define(:version => 20140423132913) do t.string "name" t.text "components" t.datetime "updated_at", :null => false + t.text "description" end add_index "pipeline_templates", ["created_at"], :name => "index_pipeline_templates_on_created_at" @@ -421,4 +439,5 @@ ActiveRecord::Schema.define(:version => 20140423132913) do add_index "virtual_machines", ["hostname"], :name => "index_virtual_machines_on_hostname" add_index "virtual_machines", ["uuid"], :name => "index_virtual_machines_on_uuid", :unique => true + end