#
# It's strongly recommended to check this file into your version control system.
-ActiveRecord::Schema.define(:version => 20130116215213) do
+ActiveRecord::Schema.define(:version => 20130318002138) do
+
+ create_table "api_client_authorizations", :force => true do |t|
+ t.string "api_token", :null => false
+ t.integer "api_client_id", :null => false
+ t.integer "user_id", :null => false
+ t.string "created_by_ip_address"
+ t.string "last_used_by_ip_address"
+ t.datetime "last_used_at"
+ t.datetime "expires_at"
+ t.datetime "created_at"
+ t.datetime "updated_at"
+ end
+
+ add_index "api_client_authorizations", ["api_client_id"], :name => "index_api_client_authorizations_on_api_client_id"
+ add_index "api_client_authorizations", ["api_token"], :name => "index_api_client_authorizations_on_api_token", :unique => true
+ add_index "api_client_authorizations", ["expires_at"], :name => "index_api_client_authorizations_on_expires_at"
+ add_index "api_client_authorizations", ["user_id"], :name => "index_api_client_authorizations_on_user_id"
+
+ 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.datetime "modified_at"
+ t.string "name"
+ t.string "url_prefix"
+ t.datetime "created_at"
+ 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|
t.string "locator"
- t.string "created_by_client"
- t.string "created_by_user"
+ t.string "owner"
t.datetime "created_at"
t.string "modified_by_client"
t.string "modified_by_user"
t.integer "redundancy_confirmed_as"
t.datetime "updated_at"
t.string "uuid"
+ 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 "metadata", :force => true do |t|
+ 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 "created_by_client"
- t.string "created_by_user"
+ t.string "owner"
t.datetime "created_at"
t.string "modified_by_client"
t.string "modified_by_user"
t.datetime "modified_at"
- t.string "target_uuid"
- t.string "target_kind"
- t.integer "native_target_id"
- t.string "native_target_type"
- t.string "metadata_class"
- t.string "key"
- t.string "value"
+ t.string "tail_uuid"
+ t.string "tail_kind"
+ t.string "link_class"
+ t.string "name"
+ t.string "head_uuid"
+ t.text "properties"
+ t.datetime "updated_at"
+ 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
+
+ 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 "object_kind"
+ t.string "object_uuid"
+ t.datetime "event_at"
+ t.string "event_type"
+ t.text "summary"
t.text "info"
+ t.datetime "created_at"
t.datetime "updated_at"
+ t.datetime "modified_at"
end
- add_index "metadata", ["uuid"], :name => "index_metadata_on_uuid", :unique => true
+ 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"
+ add_index "logs", ["uuid"], :name => "index_logs_on_uuid", :unique => true
create_table "nodes", :force => true do |t|
t.string "uuid"
- t.string "created_by_client"
- t.string "created_by_user"
+ t.string "owner"
t.datetime "created_at"
t.string "modified_by_client"
t.string "modified_by_user"
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
create_table "pipeline_invocations", :force => true do |t|
t.string "uuid"
- t.string "created_by_client"
- t.string "created_by_user"
+ t.string "owner"
t.datetime "created_at"
t.string "modified_by_client"
t.string "modified_by_user"
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|
t.string "uuid"
- t.string "created_by_client"
- t.string "created_by_user"
+ t.string "owner"
t.datetime "created_at"
t.string "modified_by_client"
t.string "modified_by_user"
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|
+ create_table "specimens", :force => true do |t|
t.string "uuid"
- t.string "created_by_client"
- t.string "created_by_user"
+ 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.string "material"
t.datetime "updated_at"
+ t.text "properties"
end
- add_index "projects", ["uuid"], :name => "index_projects_on_uuid", :unique => true
+ 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 "specimens", :force => true do |t|
+ create_table "users", :force => true do |t|
t.string "uuid"
- t.string "created_by_client"
- t.string "created_by_user"
+ t.string "owner"
t.datetime "created_at"
t.string "modified_by_client"
t.string "modified_by_user"
t.datetime "modified_at"
- t.string "material"
+ t.string "email"
+ t.string "first_name"
+ t.string "last_name"
+ t.string "identity_url"
+ t.boolean "is_admin"
+ t.text "prefs"
t.datetime "updated_at"
end
- add_index "specimens", ["uuid"], :name => "index_specimens_on_uuid", :unique => true
+ 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