X-Git-Url: https://git.arvados.org/arvados.git/blobdiff_plain/247c69eae2f2f37171032be889ebf414830350c3..64f3cccd176b214b2e9a571c54973c4e546c606a:/services/api/db/schema.rb?ds=sidebyside diff --git a/services/api/db/schema.rb b/services/api/db/schema.rb index af64a56dba..80325d2eee 100644 --- a/services/api/db/schema.rb +++ b/services/api/db/schema.rb @@ -11,7 +11,7 @@ # # It's strongly recommended to check this file into your version control system. -ActiveRecord::Schema.define(:version => 20130523060213) do +ActiveRecord::Schema.define(:version => 20130708182912) do create_table "api_client_authorizations", :force => true do |t| t.string "api_token", :null => false @@ -23,7 +23,7 @@ ActiveRecord::Schema.define(:version => 20130523060213) do t.datetime "expires_at" t.datetime "created_at" t.datetime "updated_at" - t.string "default_owner" + t.string "default_owner_uuid" end add_index "api_client_authorizations", ["api_client_id"], :name => "index_api_client_authorizations_on_api_client_id" @@ -33,31 +33,50 @@ ActiveRecord::Schema.define(:version => 20130523060213) do create_table "api_clients", :force => true do |t| t.string "uuid" - t.string "owner" - t.string "modified_by_client" - t.string "modified_by_user" + t.string "owner_uuid" + t.string "modified_by_client_uuid" + t.string "modified_by_user_uuid" t.datetime "modified_at" t.string "name" t.string "url_prefix" t.datetime "created_at" t.datetime "updated_at" + t.boolean "is_trusted", :default => false 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 "authorized_keys", :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 "name" + t.string "key_type" + t.string "authorized_user_uuid" + t.text "public_key" + t.datetime "expires_at" + t.datetime "created_at" + t.datetime "updated_at" + 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", ["uuid"], :name => "index_authorized_keys_on_uuid", :unique => true + create_table "collections", :force => true do |t| t.string "locator" - t.string "owner" + t.string "owner_uuid" t.datetime "created_at" - t.string "modified_by_client" - t.string "modified_by_user" + 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" + t.string "redundancy_confirmed_by_client_uuid" t.datetime "redundancy_confirmed_at" t.integer "redundancy_confirmed_as" t.datetime "updated_at" @@ -92,10 +111,10 @@ ActiveRecord::Schema.define(:version => 20130523060213) do create_table "groups", :force => true do |t| t.string "uuid" - t.string "owner" + t.string "owner_uuid" t.datetime "created_at" - t.string "modified_by_client" - t.string "modified_by_user" + t.string "modified_by_client_uuid" + t.string "modified_by_user_uuid" t.datetime "modified_at" t.string "name" t.text "description" @@ -106,11 +125,24 @@ ActiveRecord::Schema.define(:version => 20130523060213) do add_index "groups", ["modified_at"], :name => "index_groups_on_modified_at" add_index "groups", ["uuid"], :name => "index_groups_on_uuid", :unique => true + create_table "humans", :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.text "properties" + t.datetime "created_at" + t.datetime "updated_at" + end + + add_index "humans", ["uuid"], :name => "index_humans_on_uuid", :unique => true + create_table "job_tasks", :force => true do |t| t.string "uuid" - t.string "owner" - t.string "modified_by_client" - t.string "modified_by_user" + t.string "owner_uuid" + t.string "modified_by_client_uuid" + t.string "modified_by_user_uuid" t.datetime "modified_at" t.string "job_uuid" t.integer "sequence" @@ -120,8 +152,8 @@ ActiveRecord::Schema.define(:version => 20130523060213) do t.boolean "success" t.datetime "created_at" t.datetime "updated_at" - t.string "created_by_job_task" - t.integer "qsequence" + t.string "created_by_job_task_uuid" + t.integer "qsequence", :limit => 8 end add_index "job_tasks", ["created_at"], :name => "index_job_tasks_on_created_at" @@ -133,16 +165,16 @@ ActiveRecord::Schema.define(:version => 20130523060213) do create_table "jobs", :force => true do |t| t.string "uuid" - t.string "owner" - t.string "modified_by_client" - t.string "modified_by_user" + t.string "owner_uuid" + t.string "modified_by_client_uuid" + t.string "modified_by_user_uuid" t.datetime "modified_at" t.string "submit_id" t.string "script" t.string "script_version" t.text "script_parameters" - t.string "cancelled_by_client" - t.string "cancelled_by_user" + t.string "cancelled_by_client_uuid" + t.string "cancelled_by_user_uuid" t.datetime "cancelled_at" t.datetime "started_at" t.datetime "finished_at" @@ -152,7 +184,7 @@ ActiveRecord::Schema.define(:version => 20130523060213) do t.datetime "created_at" t.datetime "updated_at" t.string "priority" - t.string "is_locked_by" + t.string "is_locked_by_uuid" t.string "log" t.text "tasks_summary" t.text "resource_limits" @@ -168,18 +200,18 @@ ActiveRecord::Schema.define(:version => 20130523060213) do add_index "jobs", ["uuid"], :name => "index_jobs_on_uuid", :unique => true create_table "keep_disks", :force => true do |t| - t.string "uuid", :null => false - t.string "owner", :null => false - t.string "modified_by_client" - t.string "modified_by_user" + 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 "ping_secret", :null => false + t.string "ping_secret", :null => false t.string "node_uuid" t.string "filesystem_uuid" t.integer "bytes_total" t.integer "bytes_free" - t.boolean "is_readable", :default => true, :null => false - t.boolean "is_writable", :default => true, :null => false + t.boolean "is_readable", :default => true, :null => false + t.boolean "is_writable", :default => true, :null => false t.datetime "last_read_at" t.datetime "last_write_at" t.datetime "last_ping_at" @@ -198,10 +230,10 @@ ActiveRecord::Schema.define(:version => 20130523060213) do create_table "links", :force => true do |t| t.string "uuid" - t.string "owner" + t.string "owner_uuid" t.datetime "created_at" - t.string "modified_by_client" - t.string "modified_by_user" + t.string "modified_by_client_uuid" + t.string "modified_by_user_uuid" t.datetime "modified_at" t.string "tail_uuid" t.string "tail_kind" @@ -223,9 +255,9 @@ ActiveRecord::Schema.define(:version => 20130523060213) do create_table "logs", :force => true do |t| t.string "uuid" - t.string "owner" - t.string "modified_by_client" - t.string "modified_by_user" + t.string "owner_uuid" + t.string "modified_by_client_uuid" + t.string "modified_by_user_uuid" t.string "object_kind" t.string "object_uuid" t.datetime "event_at" @@ -248,10 +280,10 @@ ActiveRecord::Schema.define(:version => 20130523060213) do create_table "nodes", :force => true do |t| t.string "uuid" - t.string "owner" + t.string "owner_uuid" t.datetime "created_at" - t.string "modified_by_client" - t.string "modified_by_user" + t.string "modified_by_client_uuid" + t.string "modified_by_user_uuid" t.datetime "modified_at" t.integer "slot_number" t.string "hostname" @@ -264,23 +296,23 @@ ActiveRecord::Schema.define(:version => 20130523060213) do 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", ["hostname"], :name => "index_nodes_on_hostname" 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 create_table "pipeline_instances", :force => true do |t| t.string "uuid" - t.string "owner" + t.string "owner_uuid" t.datetime "created_at" - t.string "modified_by_client" - t.string "modified_by_user" + 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.boolean "active", :default => false t.datetime "updated_at" t.text "properties" end @@ -291,10 +323,10 @@ ActiveRecord::Schema.define(:version => 20130523060213) do create_table "pipeline_templates", :force => true do |t| t.string "uuid" - t.string "owner" + t.string "owner_uuid" t.datetime "created_at" - t.string "modified_by_client" - t.string "modified_by_user" + t.string "modified_by_client_uuid" + t.string "modified_by_user_uuid" t.datetime "modified_at" t.string "name" t.text "components" @@ -305,12 +337,28 @@ ActiveRecord::Schema.define(:version => 20130523060213) do add_index "pipeline_templates", ["modified_at"], :name => "index_pipeline_templates_on_modified_at" add_index "pipeline_templates", ["uuid"], :name => "index_pipeline_templates_on_uuid", :unique => true + create_table "repositories", :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 "name" + t.string "fetch_url" + t.string "push_url" + t.datetime "created_at" + t.datetime "updated_at" + end + + add_index "repositories", ["name"], :name => "index_repositories_on_name", :unique => true + add_index "repositories", ["uuid"], :name => "index_repositories_on_uuid", :unique => true + create_table "specimens", :force => true do |t| t.string "uuid" - t.string "owner" + t.string "owner_uuid" t.datetime "created_at" - t.string "modified_by_client" - t.string "modified_by_user" + t.string "modified_by_client_uuid" + t.string "modified_by_user_uuid" t.datetime "modified_at" t.string "material" t.datetime "updated_at" @@ -321,12 +369,27 @@ ActiveRecord::Schema.define(:version => 20130523060213) do add_index "specimens", ["modified_at"], :name => "index_specimens_on_modified_at" add_index "specimens", ["uuid"], :name => "index_specimens_on_uuid", :unique => true + create_table "traits", :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 "name" + t.text "properties" + t.datetime "created_at" + t.datetime "updated_at" + end + + add_index "traits", ["name"], :name => "index_traits_on_name" + add_index "traits", ["uuid"], :name => "index_traits_on_uuid", :unique => true + create_table "users", :force => true do |t| t.string "uuid" - t.string "owner" + t.string "owner_uuid" t.datetime "created_at" - t.string "modified_by_client" - t.string "modified_by_user" + t.string "modified_by_client_uuid" + t.string "modified_by_user_uuid" t.datetime "modified_at" t.string "email" t.string "first_name" @@ -336,10 +399,25 @@ ActiveRecord::Schema.define(:version => 20130523060213) do t.text "prefs" t.datetime "updated_at" t.string "default_owner" + t.boolean "is_active", :default => false 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 + create_table "virtual_machines", :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 "hostname" + t.datetime "created_at" + t.datetime "updated_at" + end + + 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