oyouareatubeo

Tweet DB

Dec 11th, 2011
66
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Ruby 0.78 KB | None | 0 0
  1. class CreateTweetTable < Sequel::Migration
  2.  
  3. def up
  4.   create_table :tweets do
  5.     primary_key :id
  6.     String :username
  7.     String :location
  8.     Time :created_at
  9.     Time :time_zone
  10.     String :lang
  11.     String :text
  12.     Integer :guid
  13.     Integer :in_reply_to_user_id
  14.     Integer :in_reply_to_status_id
  15.     String :retweeted
  16.     String :protected
  17.     String :verified
  18.     String :description
  19.     Integer :followers_count
  20.     String :url
  21.     String :name
  22.     Integer :statuses_count
  23.     String :screen_name
  24.     String :place
  25.     Integer :retweet_count
  26.     Integer :favourites_count
  27.     String :geo_enabled
  28.     Integer :friends_count
  29.     String :entities
  30.     String :source
  31.     String :geo
  32.     String :coordinates
  33.    end
  34. end
  35.  
  36. def down
  37.     drop_table(:tweets)
  38. end
  39.  
  40. end
  41.  
Advertisement
Add Comment
Please, Sign In to add comment