X-Git-Url: https://git.arvados.org/arvados.git/blobdiff_plain/3623d1e89b3e756c8a558449e6a433744c2015d1..e130e62a0d042ca653dadc0a2274627360328c4a:/db/schema.rb diff --git a/db/schema.rb b/db/schema.rb index f2deccbb2a..cab044df8c 100644 --- a/db/schema.rb +++ b/db/schema.rb @@ -11,7 +11,7 @@ # # It's strongly recommended to check this file into your version control system. -ActiveRecord::Schema.define(:version => 20130130205749) do +ActiveRecord::Schema.define(:version => 20130318002138) do create_table "api_client_authorizations", :force => true do |t| t.string "api_token", :null => false @@ -42,6 +42,8 @@ ActiveRecord::Schema.define(:version => 20130130205749) do t.datetime "updated_at" end + add_index "api_clients", ["created_at"], :name => "index_api_clients_on_created_at" + add_index "api_clients", ["modified_at"], :name => "index_api_clients_on_modified_at" add_index "api_clients", ["uuid"], :name => "index_api_clients_on_uuid", :unique => true create_table "collections", :force => true do |t| @@ -62,8 +64,85 @@ ActiveRecord::Schema.define(:version => 20130130205749) do t.text "manifest_text" end + add_index "collections", ["created_at"], :name => "index_collections_on_created_at" + add_index "collections", ["modified_at"], :name => "index_collections_on_modified_at" add_index "collections", ["uuid"], :name => "index_collections_on_uuid", :unique => true + create_table "groups", :force => true do |t| + t.string "uuid" + t.string "owner" + t.datetime "created_at" + t.string "modified_by_client" + t.string "modified_by_user" + t.datetime "modified_at" + t.string "name" + t.text "description" + t.datetime "updated_at" + end + + add_index "groups", ["created_at"], :name => "index_groups_on_created_at" + add_index "groups", ["modified_at"], :name => "index_groups_on_modified_at" + add_index "groups", ["uuid"], :name => "index_groups_on_uuid", :unique => true + + create_table "job_steps", :force => true do |t| + t.string "uuid" + t.string "owner" + t.string "modified_by_client" + t.string "modified_by_user" + t.datetime "modified_at" + t.string "job_uuid" + t.integer "sequence" + t.text "parameters" + t.text "output" + t.float "progress" + t.boolean "success" + t.datetime "created_at" + t.datetime "updated_at" + end + + add_index "job_steps", ["created_at"], :name => "index_job_steps_on_created_at" + add_index "job_steps", ["job_uuid"], :name => "index_job_steps_on_job_uuid" + add_index "job_steps", ["modified_at"], :name => "index_job_steps_on_modified_at" + add_index "job_steps", ["sequence"], :name => "index_job_steps_on_sequence" + add_index "job_steps", ["success"], :name => "index_job_steps_on_success" + add_index "job_steps", ["uuid"], :name => "index_job_steps_on_uuid", :unique => true + + create_table "jobs", :force => true do |t| + t.string "uuid" + t.string "owner" + t.string "modified_by_client" + t.string "modified_by_user" + t.datetime "modified_at" + t.string "submit_id" + t.string "command" + t.string "command_version" + t.text "command_parameters" + t.string "cancelled_by_client" + t.string "cancelled_by_user" + t.datetime "cancelled_at" + t.datetime "started_at" + t.datetime "finished_at" + t.boolean "running" + t.boolean "success" + t.string "output" + t.datetime "created_at" + t.datetime "updated_at" + t.string "priority" + t.string "is_locked_by" + t.string "log" + t.text "tasks_summary" + t.text "resource_limits" + end + + add_index "jobs", ["command"], :name => "index_jobs_on_command" + add_index "jobs", ["created_at"], :name => "index_jobs_on_created_at" + add_index "jobs", ["finished_at"], :name => "index_jobs_on_finished_at" + add_index "jobs", ["modified_at"], :name => "index_jobs_on_modified_at" + add_index "jobs", ["output"], :name => "index_jobs_on_output" + add_index "jobs", ["started_at"], :name => "index_jobs_on_started_at" + add_index "jobs", ["submit_id"], :name => "index_jobs_on_submit_id", :unique => true + add_index "jobs", ["uuid"], :name => "index_jobs_on_uuid", :unique => true + create_table "links", :force => true do |t| t.string "uuid" t.string "owner" @@ -73,8 +152,6 @@ ActiveRecord::Schema.define(:version => 20130130205749) do t.datetime "modified_at" t.string "tail_uuid" t.string "tail_kind" - t.integer "native_target_id" - t.string "native_target_type" t.string "link_class" t.string "name" t.string "head_uuid" @@ -83,8 +160,10 @@ ActiveRecord::Schema.define(:version => 20130130205749) do t.string "head_kind" end + add_index "links", ["created_at"], :name => "index_links_on_created_at" add_index "links", ["head_kind"], :name => "index_links_on_head_kind" 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_kind"], :name => "index_links_on_tail_kind" add_index "links", ["tail_uuid"], :name => "index_links_on_tail_uuid" add_index "links", ["uuid"], :name => "index_links_on_uuid", :unique => true @@ -105,8 +184,10 @@ ActiveRecord::Schema.define(:version => 20130130205749) do t.datetime "modified_at" end + add_index "logs", ["created_at"], :name => "index_logs_on_created_at" add_index "logs", ["event_at"], :name => "index_logs_on_event_at" add_index "logs", ["event_type"], :name => "index_logs_on_event_type" + add_index "logs", ["modified_at"], :name => "index_logs_on_modified_at" add_index "logs", ["object_kind"], :name => "index_logs_on_object_kind" add_index "logs", ["object_uuid"], :name => "index_logs_on_object_uuid" add_index "logs", ["summary"], :name => "index_logs_on_summary" @@ -129,7 +210,9 @@ ActiveRecord::Schema.define(:version => 20130130205749) do t.datetime "updated_at" end + add_index "nodes", ["created_at"], :name => "index_nodes_on_created_at" add_index "nodes", ["hostname"], :name => "index_nodes_on_hostname", :unique => true + add_index "nodes", ["modified_at"], :name => "index_nodes_on_modified_at" add_index "nodes", ["slot_number"], :name => "index_nodes_on_slot_number", :unique => true add_index "nodes", ["uuid"], :name => "index_nodes_on_uuid", :unique => true @@ -146,8 +229,11 @@ ActiveRecord::Schema.define(:version => 20130130205749) do t.boolean "success" t.boolean "active", :default => false t.datetime "updated_at" + t.text "properties" end + add_index "pipeline_invocations", ["created_at"], :name => "index_pipeline_invocations_on_created_at" + add_index "pipeline_invocations", ["modified_at"], :name => "index_pipeline_invocations_on_modified_at" add_index "pipeline_invocations", ["uuid"], :name => "index_pipeline_invocations_on_uuid", :unique => true create_table "pipelines", :force => true do |t| @@ -162,22 +248,10 @@ ActiveRecord::Schema.define(:version => 20130130205749) do t.datetime "updated_at" end + add_index "pipelines", ["created_at"], :name => "index_pipelines_on_created_at" + add_index "pipelines", ["modified_at"], :name => "index_pipelines_on_modified_at" add_index "pipelines", ["uuid"], :name => "index_pipelines_on_uuid", :unique => true - create_table "projects", :force => true do |t| - t.string "uuid" - t.string "owner" - t.datetime "created_at" - t.string "modified_by_client" - t.string "modified_by_user" - t.datetime "modified_at" - t.string "name" - t.text "description" - t.datetime "updated_at" - end - - add_index "projects", ["uuid"], :name => "index_projects_on_uuid", :unique => true - create_table "specimens", :force => true do |t| t.string "uuid" t.string "owner" @@ -190,6 +264,8 @@ ActiveRecord::Schema.define(:version => 20130130205749) do t.text "properties" end + add_index "specimens", ["created_at"], :name => "index_specimens_on_created_at" + add_index "specimens", ["modified_at"], :name => "index_specimens_on_modified_at" add_index "specimens", ["uuid"], :name => "index_specimens_on_uuid", :unique => true create_table "users", :force => true do |t| @@ -208,6 +284,8 @@ ActiveRecord::Schema.define(:version => 20130130205749) do t.datetime "updated_at" end + add_index "users", ["created_at"], :name => "index_users_on_created_at" + add_index "users", ["modified_at"], :name => "index_users_on_modified_at" add_index "users", ["uuid"], :name => "index_users_on_uuid", :unique => true end