Changeset 80847

Timestamp:

07/18/11 15:44:59 (4 years ago)

Author:

derek@…

Message:

Updated schema

• Removed month,year from installed_ports
• Added index on installed_ports, ports, os_statistics

File:

• branches/gsoc11-statistics/stats-server/db/schema.rb (modified) (4 diffs)

branches/gsoc11-statistics/stats-server/db/schema.rb

@@ -11 +11 @@
 # It's strongly recommended to check this file into your version control system.
 
-ActiveRecord::Schema.define(:version => 20110716021834) do
+ActiveRecord::Schema.define(:version => 20110718213618) do
 
   create_table "categories", :force => true do |t|
@@ -23 +23 @@
     t.string   "version"
     t.text     "variants"
-    t.string   "month"
-    t.string   "year"
     t.datetime "created_at"
     t.datetime "updated_at"
     t.integer  "user_id"
   end
+
+  add_index "installed_ports", ["port_id"], :name => "index_installed_ports_on_port_id"
+  add_index "installed_ports", ["user_id"], :name => "index_installed_ports_on_user_id"
 
   create_table "os_statistics", :force => true do |t|
@@ -42 +43 @@
     t.integer  "user_id"
   end
+
+  add_index "os_statistics", ["user_id"], :name => "index_os_statistics_on_user_id"
 
   create_table "ports", :force => true do |t|
@@ -58 +61 @@
   end
 
+  add_index "ports", ["name"], :name => "index_ports_on_name"
+
   create_table "submissions", :force => true do |t|
     t.string   "data"