X-Git-Url: https://git.arvados.org/arvados.git/blobdiff_plain/43773cb247a1fb744b57070b715bfa5d53a00822..17e5ba5f533353a7e27beaa75a5141697d9f32ae:/services/api/db/schema.rb

diff --git a/services/api/db/schema.rb b/services/api/db/schema.rb
index 986528b909..c0b6597265 100644
--- a/services/api/db/schema.rb
+++ b/services/api/db/schema.rb
@@ -11,7 +11,7 @@
 #
 # It's strongly recommended to check this file into your version control system.
 
-ActiveRecord::Schema.define(:version => 20130326182917) do
+ActiveRecord::Schema.define(:version => 20130626022810) do
 
   create_table "api_client_authorizations", :force => true do |t|
     t.string   "api_token",               :null => false
@@ -41,12 +41,31 @@ ActiveRecord::Schema.define(:version => 20130326182917) do
     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"
@@ -120,6 +139,8 @@ ActiveRecord::Schema.define(:version => 20130326182917) do
     t.boolean  "success"
     t.datetime "created_at"
     t.datetime "updated_at"
+    t.string   "created_by_job_task"
+    t.integer  "qsequence",           :limit => 8
   end
 
   add_index "job_tasks", ["created_at"], :name => "index_job_tasks_on_created_at"
@@ -165,6 +186,35 @@ ActiveRecord::Schema.define(:version => 20130326182917) do
   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 "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.datetime "modified_at"
+    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.datetime "last_read_at"
+    t.datetime "last_write_at"
+    t.datetime "last_ping_at"
+    t.datetime "created_at"
+    t.datetime "updated_at"
+    t.string   "service_host"
+    t.integer  "service_port"
+    t.boolean  "service_ssl_flag"
+  end
+
+  add_index "keep_disks", ["filesystem_uuid"], :name => "index_keep_disks_on_filesystem_uuid"
+  add_index "keep_disks", ["last_ping_at"], :name => "index_keep_disks_on_last_ping_at"
+  add_index "keep_disks", ["node_uuid"], :name => "index_keep_disks_on_node_uuid"
+  add_index "keep_disks", ["service_host", "service_port", "last_ping_at"], :name => "keep_disks_service_host_port_ping_at_index"
+  add_index "keep_disks", ["uuid"], :name => "index_keep_disks_on_uuid", :unique => true
+
   create_table "links", :force => true do |t|
     t.string   "uuid"
     t.string   "owner"
@@ -233,7 +283,7 @@ ActiveRecord::Schema.define(:version => 20130326182917) do
   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", ["hostname"], :name => "index_nodes_on_hostname"
   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
@@ -274,6 +324,22 @@ ActiveRecord::Schema.define(:version => 20130326182917) 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",              :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"
@@ -305,10 +371,25 @@ ActiveRecord::Schema.define(:version => 20130326182917) do
     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