X-Git-Url: https://git.arvados.org/arvados.git/blobdiff_plain/e72f00ff0eb6870f17596e5d624106525859cd06..621df817c1ffcf6b4a681975c5477e62b2d65b0a:/db/schema.rb

diff --git a/db/schema.rb b/db/schema.rb
index 4557611b28..8507e0cdf2 100644
--- a/db/schema.rb
+++ b/db/schema.rb
@@ -11,12 +11,42 @@
 #
 # It's strongly recommended to check this file into your version control system.
 
-ActiveRecord::Schema.define(:version => 20130107181109) do
+ActiveRecord::Schema.define(:version => 20130128202518) 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", ["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"
@@ -31,23 +61,151 @@ ActiveRecord::Schema.define(:version => 20130107181109) do
     t.string   "uuid"
   end
 
-  create_table "metadata", :force => true do |t|
+  add_index "collections", ["uuid"], :name => "index_collections_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.string   "tail_uuid"
+    t.string   "tail_kind"
     t.integer  "native_target_id"
     t.string   "native_target_type"
-    t.string   "metadata_class"
-    t.string   "key"
-    t.string   "value"
+    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", ["head_kind"], :name => "index_links_on_head_kind"
+  add_index "links", ["head_uuid"], :name => "index_links_on_head_uuid"
+  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 "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 "nodes", :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.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   "owner"
+    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   "owner"
+    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   "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 "projects", ["uuid"], :name => "index_projects_on_uuid", :unique => true
+
+  create_table "specimens", :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   "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   "owner"
+    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