[80567] branches/gsoc11-statistics/stats-server/db

[derek at macports.org]

Revision: 80567
          http://trac.macports.org/changeset/80567
Author:   derek at macports.org
Date:     2011-07-14 22:34:28 -0700 (Thu, 14 Jul 2011)
Log Message:
-----------
-Created a Users table with a uuid field
-Removed uuid field from os_statistics
-Added user_id field to os_statistics which will reference a row id in the Users table

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

Added Paths:
-----------
    branches/gsoc11-statistics/stats-server/db/migrate/20110714161719_create_users.rb
    branches/gsoc11-statistics/stats-server/db/migrate/20110714162748_remove_uuid_from_os_statistics.rb
    branches/gsoc11-statistics/stats-server/db/migrate/20110714162815_add_user_id_to_os_statistics.rb

Added: branches/gsoc11-statistics/stats-server/db/migrate/20110714161719_create_users.rb
===================================================================
--- branches/gsoc11-statistics/stats-server/db/migrate/20110714161719_create_users.rb	                        (rev 0)
+++ branches/gsoc11-statistics/stats-server/db/migrate/20110714161719_create_users.rb	2011-07-15 05:34:28 UTC (rev 80567)
@@ -0,0 +1,13 @@
+class CreateUsers < ActiveRecord::Migration
+  def self.up
+    create_table :users do |t|
+      t.string :uuid
+
+      t.timestamps
+    end
+  end
+
+  def self.down
+    drop_table :users
+  end
+end

Added: branches/gsoc11-statistics/stats-server/db/migrate/20110714162748_remove_uuid_from_os_statistics.rb
===================================================================
--- branches/gsoc11-statistics/stats-server/db/migrate/20110714162748_remove_uuid_from_os_statistics.rb	                        (rev 0)
+++ branches/gsoc11-statistics/stats-server/db/migrate/20110714162748_remove_uuid_from_os_statistics.rb	2011-07-15 05:34:28 UTC (rev 80567)
@@ -0,0 +1,9 @@
+class RemoveUuidFromOsStatistics < ActiveRecord::Migration
+  def self.up
+    remove_column :os_statistics, :uuid
+  end
+
+  def self.down
+    add_column :os_statistics, :uuid, :string
+  end
+end
\ No newline at end of file

Added: branches/gsoc11-statistics/stats-server/db/migrate/20110714162815_add_user_id_to_os_statistics.rb
===================================================================
--- branches/gsoc11-statistics/stats-server/db/migrate/20110714162815_add_user_id_to_os_statistics.rb	                        (rev 0)
+++ branches/gsoc11-statistics/stats-server/db/migrate/20110714162815_add_user_id_to_os_statistics.rb	2011-07-15 05:34:28 UTC (rev 80567)
@@ -0,0 +1,9 @@
+class AddUserIdToOsStatistics < ActiveRecord::Migration
+  def self.up
+    add_column :os_statistics, :user_id, :integer
+  end
+
+  def self.down
+    remove_column :os_statistics, :user_id
+  end
+end

Modified: branches/gsoc11-statistics/stats-server/db/schema.rb
===================================================================
--- branches/gsoc11-statistics/stats-server/db/schema.rb	2011-07-15 05:22:44 UTC (rev 80566)
+++ branches/gsoc11-statistics/stats-server/db/schema.rb	2011-07-15 05:34:28 UTC (rev 80567)
@@ -10,7 +10,7 @@
 #
 # It's strongly recommended to check this file into your version control system.
 
-ActiveRecord::Schema.define(:version => 20110713220512) do
+ActiveRecord::Schema.define(:version => 20110714162815) do
 
   create_table "categories", :force => true do |t|
     t.string   "name"
@@ -30,7 +30,6 @@
   end
 
   create_table "os_statistics", :force => true do |t|
-    t.string   "uuid"
     t.datetime "created_at"
     t.datetime "updated_at"
     t.string   "macports_version"
@@ -40,6 +39,7 @@
     t.string   "build_arch"
     t.string   "xcode_version"
     t.string   "gcc_version"
+    t.integer  "user_id"
   end
 
   create_table "ports", :force => true do |t|
@@ -63,4 +63,10 @@
     t.datetime "updated_at"
   end
 
+  create_table "users", :force => true do |t|
+    t.string   "uuid"
+    t.datetime "created_at"
+    t.datetime "updated_at"
+  end
+
 end
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macosforge.org/pipermail/macports-changes/attachments/20110714/f3a26cf9/attachment.html>