Commit af4fa0bd

mo khan <mo@mokhan.ca>
2014-01-18 05:33:05
create activities table.
1 parent 753777a
db/migrate/20140118052950_create_activities_table.rb
@@ -0,0 +1,14 @@
+class CreateActivitiesTable < ActiveRecord::Migration
+  def change
+    create_table :activities do |t|
+      t.integer :subject_id, null: false
+      t.string :subject_type, null: false
+      t.integer :user_id, null: false
+      t.timestamps null: false
+    end
+
+    add_index :activities, :subject_id
+    add_index :activities, :subject_type
+    add_index :activities, :user_id
+  end
+end
db/schema.rb
@@ -11,11 +11,38 @@
 #
 # It's strongly recommended that you check this file into your version control system.
 
-ActiveRecord::Schema.define(version: 20131230060957) do
+ActiveRecord::Schema.define(version: 20140118052950) do
 
   # These are extensions that must be enabled in order to support this database
   enable_extension "plpgsql"
 
+  create_table "active_admin_comments", force: true do |t|
+    t.integer  "resource_id",   null: false
+    t.string   "resource_type", null: false
+    t.integer  "author_id"
+    t.string   "author_type"
+    t.text     "body"
+    t.datetime "created_at"
+    t.datetime "updated_at"
+    t.string   "namespace"
+  end
+
+  add_index "active_admin_comments", ["author_type", "author_id"], name: "index_active_admin_comments_on_author_type_and_author_id", using: :btree
+  add_index "active_admin_comments", ["namespace"], name: "index_active_admin_comments_on_namespace", using: :btree
+  add_index "active_admin_comments", ["resource_type", "resource_id"], name: "index_active_admin_comments_on_resource_type_and_resource_id", using: :btree
+
+  create_table "activities", force: true do |t|
+    t.integer  "subject_id",   null: false
+    t.string   "subject_type", null: false
+    t.integer  "user_id",      null: false
+    t.datetime "created_at",   null: false
+    t.datetime "updated_at",   null: false
+  end
+
+  add_index "activities", ["subject_id"], name: "index_activities_on_subject_id", using: :btree
+  add_index "activities", ["subject_type"], name: "index_activities_on_subject_type", using: :btree
+  add_index "activities", ["user_id"], name: "index_activities_on_user_id", using: :btree
+
   create_table "avatars", force: true do |t|
     t.integer  "user_id"
     t.datetime "created_at",        null: false