#
# It's strongly recommended to check this file into your version control system.
-ActiveRecord::Schema.define(:version => 20130415020241) do
+ActiveRecord::Schema.define(:version => 20130627184333) do
create_table "api_client_authorizations", :force => true do |t|
t.string "api_token", :null => false
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", :null => false
+ t.string "modified_by_client"
+ t.string "modified_by_user"
+ 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"
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", :null => false
+ t.string "modified_by_client"
+ t.string "modified_by_user"
+ 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.boolean "success"
t.datetime "created_at"
t.datetime "updated_at"
+ t.string "created_by_job_task"
+ t.integer "qsequence", :limit => 8
end
add_index "job_tasks", ["created_at"], :name => "index_job_tasks_on_created_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 "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.datetime "modified_at"
+ 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.datetime "last_read_at"
+ t.datetime "last_write_at"
+ t.datetime "last_ping_at"
+ t.datetime "created_at"
+ t.datetime "updated_at"
+ t.string "service_host"
+ t.integer "service_port"
+ t.boolean "service_ssl_flag"
+ 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 "links", :force => true do |t|
t.string "uuid"
t.string "owner"
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
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", :null => false
+ t.string "modified_by_client"
+ t.string "modified_by_user"
+ 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"
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", :null => false
+ t.string "modified_by_client"
+ t.string "modified_by_user"
+ 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.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", :null => false
+ t.string "modified_by_client"
+ t.string "modified_by_user"
+ 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
projects / arvados.git / blobdiff