[80847] branches/gsoc11-statistics/stats-server/db/schema.rb

[derek at macports.org]

Revision: 80847
          http://trac.macports.org/changeset/80847
Author:   derek at macports.org
Date:     2011-07-18 15:44:59 -0700 (Mon, 18 Jul 2011)
Log Message:
-----------
Updated schema

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

Modified Paths:
--------------
    branches/gsoc11-statistics/stats-server/db/schema.rb

Modified: branches/gsoc11-statistics/stats-server/db/schema.rb
===================================================================
--- branches/gsoc11-statistics/stats-server/db/schema.rb	2011-07-18 22:43:29 UTC (rev 80846)
+++ branches/gsoc11-statistics/stats-server/db/schema.rb	2011-07-18 22:44:59 UTC (rev 80847)
@@ -10,7 +10,7 @@
 #
 # 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|
     t.string   "name"
@@ -22,13 +22,14 @@
     t.integer  "port_id"
     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|
     t.datetime "created_at"
     t.datetime "updated_at"
@@ -42,6 +43,8 @@
     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|
     t.string   "name"
     t.string   "path"
@@ -57,6 +60,8 @@
     t.datetime "updated_at"
   end
 
+  add_index "ports", ["name"], :name => "index_ports_on_name"
+
   create_table "submissions", :force => true do |t|
     t.string   "data"
     t.datetime "created_at"
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macosforge.org/pipermail/macports-changes/attachments/20110718/72548cc4/attachment.html>