ActiveRecord::Schema.define(:version => 0) do
create_table :posts, :force => true do |t|
  t.column :name, :string
  t.column :created_at, :datetime, :null => false
  t.column :updated_at, :datetime, :null => false
end

create_table :comments, :force => true do |t|
  t.column :post_id, :integer
  t.column :author, :string
  t.column :body, :text
  t.column :created_at, :datetime, :null => false
  t.column :updated_at, :datetime, :null => false
end

create_table :hits, :force => true do |t|
  t.column :post_id, :integer
  t.column :ip, :string
  t.column :created_at, :datetime, :null => false
  t.column :updated_at, :datetime, :null => false
end

create_table :trackbacks, :force => true do |t|
  t.column :post_id, :integer
  t.column :url, :string
  t.column :description, :string
  t.column :created_at, :datetime, :null => false
  t.column :updated_at, :datetime, :null => false
end

create_table :votes, :force => true do |t|
  t.column :post_id, :integer
  t.column :created_at, :datetime, :null => false
  t.column :updated_at, :datetime, :null => false
end

create_table :post_popularities, :force => true do |t|
  t.column :post_id, :integer

  t.column :daily_score, :float, :default => 0
  t.column :weekly_score, :float, :default => 0       
  t.column :monthly_score, :float, :default => 0       
  t.column :yearly_score, :float, :default => 0                   
  t.column :total_score, :float, :default => 0

  t.column :week_created_at_score, :float, :default => 0
  t.column :month_created_at_score, :float, :default => 0
  t.column :year_created_at_score, :float, :default => 0


  t.column :today_created_at, :datetime
  t.column :week_created_at, :datetime
  t.column :month_created_at, :datetime                               
  t.column :year_created_at, :datetime
  t.column :total_created_at, :datetime      
end
end