#
# It's strongly recommended to check this file into your version control system.
-ActiveRecord::Schema.define(:version => 20130528134100) 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"
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