ActiveRecord::Schema.define :version => 0 do create_table "tags", :force => true do |t| t.column "name", :string end create_table "taggings", :force => true do |t| t.column "tag_id", :integer t.column "taggable_id", :integer t.column "taggable_type", :string t.column "created_at", :datetime end create_table "users", :force => true do |t| t.column "name", :string end create_table "issues", :force => true do |t| t.column "description", :string t.column "closed", :boolean t.column "cached_tag_list", :string t.column "user_id", :integer t.column "views", :integer, :default => 0 t.column "total_views", :integer, :default => 0 end create_table "votes", :force => true do |t| t.references "votable", :polymorphic => true t.references "voter", :polymorphic => true t.boolean "vote_flag" t.string "vote_scope" t.integer "vote_weight" t.timestamps end # add_index :votes, [:votable_id, :votable_type] # add_index :votes, [:voter_id, :voter_type] # add_index :votes, [:voter_id, :voter_type, :vote_scope] # add_index :votes, [:votable_id, :votable_type, :vote_scope] create_table :voters, :force => true do |t| t.string :name end create_table :not_voters, :force => true do |t| t.string :name end create_table :votables, :force => true do |t| t.string :name end create_table :votable_voters, :force => true do |t| t.string :name end create_table :sti_votables, :force => true do |t| t.string :name t.string :type end create_table :sti_not_votables, :force => true do |t| t.string :name t.string :type end create_table :not_votables, :force => true do |t| t.string :name end create_table :votable_caches, :force => true do |t| t.string :name t.integer :cached_votes_total t.integer :cached_votes_score t.integer :cached_votes_up t.integer :cached_votes_down t.integer :cached_weighted_total t.integer :cached_weighted_score t.float :cached_weighted_average t.integer :cached_scoped_test_votes_total t.integer :cached_scoped_test_votes_score t.integer :cached_scoped_test_votes_up t.integer :cached_scoped_test_votes_down t.integer :cached_scoped_weighted_total t.integer :cached_scoped_weighted_score t.float :cached_scoped_weighted_average end create_table :viewings, :force => true do |t| t.column :viewer_id, :integer t.column :viewed_id, :integer t.column :viewed_type, :string t.column :ip, :string, :limit => '24' t.column :created_at, :datetime end end