+# encoding: UTF-8
# This file is auto-generated from the current state of the database. Instead
# of editing this file, please use the migrations feature of Active Record to
# incrementally modify your database, and then regenerate this schema definition.
#
# It's strongly recommended to check this file into your version control system.
-ActiveRecord::Schema.define(:version => 20121016005009) do
+ActiveRecord::Schema.define(:version => 20130123180228) 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 "created_by_client"
+ t.string "created_by_user"
+ 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", ["uuid"], :name => "index_api_clients_on_uuid", :unique => true
create_table "collections", :force => true do |t|
t.string "locator"
- t.string "create_by_client"
+ t.string "created_by_client"
t.string "created_by_user"
t.datetime "created_at"
t.string "modified_by_client"
t.datetime "redundancy_confirmed_at"
t.integer "redundancy_confirmed_as"
t.datetime "updated_at"
+ t.string "uuid"
+ end
+
+ add_index "collections", ["uuid"], :name => "index_collections_on_uuid", :unique => true
+
+ create_table "logs", :force => true do |t|
+ t.string "uuid"
+ t.string "created_by_client"
+ t.string "created_by_user"
+ 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 "logs", ["event_at"], :name => "index_logs_on_event_at"
+ add_index "logs", ["event_type"], :name => "index_logs_on_event_type"
+ 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 "metadata", :force => true do |t|
+ t.string "uuid"
+ t.string "created_by_client"
+ t.string "created_by_user"
+ t.datetime "created_at"
+ t.string "modified_by_client"
+ t.string "modified_by_user"
+ t.datetime "modified_at"
+ t.string "tail"
+ t.string "tail_kind"
+ t.integer "native_target_id"
+ t.string "native_target_type"
+ t.string "metadata_class"
+ t.string "name"
+ t.string "head"
+ t.text "info"
+ t.datetime "updated_at"
+ t.string "head_kind"
+ end
+
+ add_index "metadata", ["head"], :name => "index_metadata_on_head"
+ add_index "metadata", ["head_kind"], :name => "index_metadata_on_head_kind"
+ add_index "metadata", ["tail"], :name => "index_metadata_on_tail"
+ add_index "metadata", ["tail_kind"], :name => "index_metadata_on_tail_kind"
+ add_index "metadata", ["uuid"], :name => "index_metadata_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.datetime "created_at"
+ t.string "modified_by_client"
+ t.string "modified_by_user"
+ t.datetime "modified_at"
+ t.integer "slot_number"
+ t.string "hostname"
+ t.string "domain"
+ t.string "ip_address"
+ t.datetime "first_ping_at"
+ t.datetime "last_ping_at"
+ t.text "info"
+ t.datetime "updated_at"
+ end
+
+ add_index "nodes", ["hostname"], :name => "index_nodes_on_hostname", :unique => true
+ 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.datetime "created_at"
+ t.string "modified_by_client"
+ t.string "modified_by_user"
+ t.datetime "modified_at"
+ t.string "pipeline_uuid"
+ t.string "name"
+ t.text "components"
+ t.boolean "success"
+ t.boolean "active", :default => false
+ t.datetime "updated_at"
+ end
+
+ 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.datetime "created_at"
+ t.string "modified_by_client"
+ t.string "modified_by_user"
+ t.datetime "modified_at"
+ t.string "name"
+ t.text "components"
+ t.datetime "updated_at"
+ end
+
+ add_index "pipelines", ["uuid"], :name => "index_pipelines_on_uuid", :unique => true
+
+ create_table "projects", :force => true do |t|
+ t.string "uuid"
+ t.string "created_by_client"
+ t.string "created_by_user"
+ 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 "created_by_client"
+ t.string "created_by_user"
+ t.datetime "created_at"
+ t.string "modified_by_client"
+ t.string "modified_by_user"
+ t.datetime "modified_at"
+ t.string "material"
+ t.datetime "updated_at"
+ end
+
+ add_index "specimens", ["uuid"], :name => "index_specimens_on_uuid", :unique => true
+
+ create_table "users", :force => true do |t|
+ t.string "uuid"
+ t.string "created_by_client"
+ t.string "created_by_user"
+ t.datetime "created_at"
+ t.string "modified_by_client"
+ t.string "modified_by_user"
+ t.datetime "modified_at"
+ 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 "users", ["uuid"], :name => "index_users_on_uuid", :unique => true
+
end
projects / arvados.git / blobdiff