Sha256: 48f581d7b6c680c9deced8b701a6804ec8cec625c5865ad56b8ceadac05b423a
Contents?: true
Size: 1.82 KB
Versions: 3
Compression:
Stored size: 1.82 KB
Contents
class CreateTamedBeastTables < ActiveRecord::Migration def self.up create_table "forums" do |t| t.string "name" t.string "description" t.integer "topics_count", :default => 0 t.integer "posts_count", :default => 0 t.integer "position" t.text "description_html" end create_table "posts" do |t| t.integer "user_id" t.integer "topic_id" t.text "body" t.datetime "created_at" t.datetime "updated_at" t.integer "forum_id" t.text "body_html" end add_index "posts", ["forum_id", "created_at"], :name => "index_posts_on_forum_id" add_index "posts", ["user_id", "created_at"], :name => "index_posts_on_user_id" add_index "posts", ["topic_id", "created_at"], :name => "index_posts_on_topic_id" create_table "topics" do |t| t.integer "forum_id" t.integer "user_id" t.string "title" t.datetime "created_at" t.datetime "updated_at" t.integer "hits", :default => 0 t.integer "sticky", :default => 0 t.integer "posts_count", :default => 0 t.datetime "replied_at" t.boolean "locked", :default => false t.integer "replied_by" t.integer "last_post_id" end add_index "topics", ["forum_id"], :name => "index_topics_on_forum_id" add_index "topics", ["forum_id", "sticky", "replied_at"], :name => "index_topics_on_sticky_and_replied_at" add_index "topics", ["forum_id", "replied_at"], :name => "index_topics_on_forum_id_and_replied_at" add_column :users, :posts_count, :integer, :default => 0 add_column :users, :last_seen_at, :datetime end def self.down remove_column :users, :posts_count remove_column :users, :last_seen_at drop_table :topics drop_table :posts drop_table :forums end end
Version data entries
3 entries across 3 versions & 1 rubygems