X-Git-Url: https://git.arvados.org/arvados.git/blobdiff_plain/536b8d10f221c438a620e56362eddb8917694af7..04e0f89fe89bccdd0f103b149aed4054a3af53c9:/services/api/db/schema.rb?ds=sidebyside

diff --git a/services/api/db/schema.rb b/services/api/db/schema.rb
index 73b5ff9441..6a032d0d19 100644
--- a/services/api/db/schema.rb
+++ b/services/api/db/schema.rb
@@ -11,19 +11,20 @@
 #
 # It's strongly recommended to check this file into your version control system.
 
-ActiveRecord::Schema.define(:version => 20130608053730) do
+ActiveRecord::Schema.define(:version => 20131007180607) 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   "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"
-    t.string   "default_owner"
+    t.string   "default_owner_uuid"
+    t.text     "scopes",                  :default => "---\n- all\n", :null => false
   end
 
   add_index "api_client_authorizations", ["api_client_id"], :name => "index_api_client_authorizations_on_api_client_id"
@@ -33,14 +34,15 @@ ActiveRecord::Schema.define(:version => 20130608053730) do
 
   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.string   "owner_uuid"
+    t.string   "modified_by_client_uuid"
+    t.string   "modified_by_user_uuid"
     t.datetime "modified_at"
     t.string   "name"
     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"
@@ -48,34 +50,34 @@ ActiveRecord::Schema.define(:version => 20130608053730) do
   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.string   "uuid",                    :null => false
+    t.string   "owner_uuid",              :null => false
+    t.string   "modified_by_client_uuid"
+    t.string   "modified_by_user_uuid"
     t.datetime "modified_at"
     t.string   "name"
     t.string   "key_type"
-    t.string   "authorized_user"
+    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", "expires_at"], :name => "index_authorized_keys_on_authorized_user_and_expires_at"
+  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"
+    t.string   "owner_uuid"
     t.datetime "created_at"
-    t.string   "modified_by_client"
-    t.string   "modified_by_user"
+    t.string   "modified_by_client_uuid"
+    t.string   "modified_by_user_uuid"
     t.datetime "modified_at"
     t.string   "portable_data_hash"
     t.string   "name"
     t.integer  "redundancy"
-    t.string   "redundancy_confirmed_by_client"
+    t.string   "redundancy_confirmed_by_client_uuid"
     t.datetime "redundancy_confirmed_at"
     t.integer  "redundancy_confirmed_as"
     t.datetime "updated_at"
@@ -110,10 +112,10 @@ ActiveRecord::Schema.define(:version => 20130608053730) do
 
   create_table "groups", :force => true do |t|
     t.string   "uuid"
-    t.string   "owner"
+    t.string   "owner_uuid"
     t.datetime "created_at"
-    t.string   "modified_by_client"
-    t.string   "modified_by_user"
+    t.string   "modified_by_client_uuid"
+    t.string   "modified_by_user_uuid"
     t.datetime "modified_at"
     t.string   "name"
     t.text     "description"
@@ -124,11 +126,24 @@ ActiveRecord::Schema.define(:version => 20130608053730) do
   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_uuid",              :null => false
+    t.string   "modified_by_client_uuid"
+    t.string   "modified_by_user_uuid"
+    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.string   "modified_by_client"
-    t.string   "modified_by_user"
+    t.string   "owner_uuid"
+    t.string   "modified_by_client_uuid"
+    t.string   "modified_by_user_uuid"
     t.datetime "modified_at"
     t.string   "job_uuid"
     t.integer  "sequence"
@@ -138,8 +153,8 @@ ActiveRecord::Schema.define(:version => 20130608053730) do
     t.boolean  "success"
     t.datetime "created_at"
     t.datetime "updated_at"
-    t.string   "created_by_job_task"
-    t.integer  "qsequence",           :limit => 8
+    t.string   "created_by_job_task_uuid"
+    t.integer  "qsequence",                :limit => 8
   end
 
   add_index "job_tasks", ["created_at"], :name => "index_job_tasks_on_created_at"
@@ -151,16 +166,16 @@ ActiveRecord::Schema.define(:version => 20130608053730) do
 
   create_table "jobs", :force => true do |t|
     t.string   "uuid"
-    t.string   "owner"
-    t.string   "modified_by_client"
-    t.string   "modified_by_user"
+    t.string   "owner_uuid"
+    t.string   "modified_by_client_uuid"
+    t.string   "modified_by_user_uuid"
     t.datetime "modified_at"
     t.string   "submit_id"
     t.string   "script"
     t.string   "script_version"
     t.text     "script_parameters"
-    t.string   "cancelled_by_client"
-    t.string   "cancelled_by_user"
+    t.string   "cancelled_by_client_uuid"
+    t.string   "cancelled_by_user_uuid"
     t.datetime "cancelled_at"
     t.datetime "started_at"
     t.datetime "finished_at"
@@ -170,10 +185,10 @@ ActiveRecord::Schema.define(:version => 20130608053730) do
     t.datetime "created_at"
     t.datetime "updated_at"
     t.string   "priority"
-    t.string   "is_locked_by"
+    t.string   "is_locked_by_uuid"
     t.string   "log"
     t.text     "tasks_summary"
-    t.text     "resource_limits"
+    t.text     "runtime_constraints"
   end
 
   add_index "jobs", ["created_at"], :name => "index_jobs_on_created_at"
@@ -186,18 +201,18 @@ ActiveRecord::Schema.define(:version => 20130608053730) do
   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.string   "uuid",                                      :null => false
+    t.string   "owner_uuid",                                :null => false
+    t.string   "modified_by_client_uuid"
+    t.string   "modified_by_user_uuid"
     t.datetime "modified_at"
-    t.string   "ping_secret",                          :null => false
+    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.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"
@@ -216,10 +231,10 @@ ActiveRecord::Schema.define(:version => 20130608053730) do
 
   create_table "links", :force => true do |t|
     t.string   "uuid"
-    t.string   "owner"
+    t.string   "owner_uuid"
     t.datetime "created_at"
-    t.string   "modified_by_client"
-    t.string   "modified_by_user"
+    t.string   "modified_by_client_uuid"
+    t.string   "modified_by_user_uuid"
     t.datetime "modified_at"
     t.string   "tail_uuid"
     t.string   "tail_kind"
@@ -241,9 +256,9 @@ ActiveRecord::Schema.define(:version => 20130608053730) do
 
   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   "owner_uuid"
+    t.string   "modified_by_client_uuid"
+    t.string   "modified_by_user_uuid"
     t.string   "object_kind"
     t.string   "object_uuid"
     t.datetime "event_at"
@@ -266,10 +281,10 @@ ActiveRecord::Schema.define(:version => 20130608053730) do
 
   create_table "nodes", :force => true do |t|
     t.string   "uuid"
-    t.string   "owner"
+    t.string   "owner_uuid"
     t.datetime "created_at"
-    t.string   "modified_by_client"
-    t.string   "modified_by_user"
+    t.string   "modified_by_client_uuid"
+    t.string   "modified_by_user_uuid"
     t.datetime "modified_at"
     t.integer  "slot_number"
     t.string   "hostname"
@@ -289,16 +304,16 @@ ActiveRecord::Schema.define(:version => 20130608053730) do
 
   create_table "pipeline_instances", :force => true do |t|
     t.string   "uuid"
-    t.string   "owner"
+    t.string   "owner_uuid"
     t.datetime "created_at"
-    t.string   "modified_by_client"
-    t.string   "modified_by_user"
+    t.string   "modified_by_client_uuid"
+    t.string   "modified_by_user_uuid"
     t.datetime "modified_at"
     t.string   "pipeline_template_uuid"
     t.string   "name"
     t.text     "components"
     t.boolean  "success"
-    t.boolean  "active",                 :default => false
+    t.boolean  "active",                  :default => false
     t.datetime "updated_at"
     t.text     "properties"
   end
@@ -309,10 +324,10 @@ ActiveRecord::Schema.define(:version => 20130608053730) do
 
   create_table "pipeline_templates", :force => true do |t|
     t.string   "uuid"
-    t.string   "owner"
+    t.string   "owner_uuid"
     t.datetime "created_at"
-    t.string   "modified_by_client"
-    t.string   "modified_by_user"
+    t.string   "modified_by_client_uuid"
+    t.string   "modified_by_user_uuid"
     t.datetime "modified_at"
     t.string   "name"
     t.text     "components"
@@ -323,12 +338,28 @@ ActiveRecord::Schema.define(:version => 20130608053730) do
   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_uuid",              :null => false
+    t.string   "modified_by_client_uuid"
+    t.string   "modified_by_user_uuid"
+    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"
+    t.string   "owner_uuid"
     t.datetime "created_at"
-    t.string   "modified_by_client"
-    t.string   "modified_by_user"
+    t.string   "modified_by_client_uuid"
+    t.string   "modified_by_user_uuid"
     t.datetime "modified_at"
     t.string   "material"
     t.datetime "updated_at"
@@ -339,12 +370,27 @@ ActiveRecord::Schema.define(:version => 20130608053730) do
   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_uuid",              :null => false
+    t.string   "modified_by_client_uuid"
+    t.string   "modified_by_user_uuid"
+    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.string   "owner_uuid"
     t.datetime "created_at"
-    t.string   "modified_by_client"
-    t.string   "modified_by_user"
+    t.string   "modified_by_client_uuid"
+    t.string   "modified_by_user_uuid"
     t.datetime "modified_at"
     t.string   "email"
     t.string   "first_name"
@@ -353,7 +399,8 @@ ActiveRecord::Schema.define(:version => 20130608053730) do
     t.boolean  "is_admin"
     t.text     "prefs"
     t.datetime "updated_at"
-    t.string   "default_owner"
+    t.string   "default_owner_uuid"
+    t.boolean  "is_active",               :default => false
   end
 
   add_index "users", ["created_at"], :name => "index_users_on_created_at"
@@ -361,10 +408,10 @@ ActiveRecord::Schema.define(:version => 20130608053730) do
   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.string   "uuid",                    :null => false
+    t.string   "owner_uuid",              :null => false
+    t.string   "modified_by_client_uuid"
+    t.string   "modified_by_user_uuid"
     t.datetime "modified_at"
     t.string   "hostname"
     t.datetime "created_at"