aboutsummaryrefslogtreecommitdiffstats
path: root/db/migrate
diff options
context:
space:
mode:
authorre4k <re4k@re4k.info>2013-03-09 19:48:53 +0900
committerre4k <re4k@re4k.info>2013-03-09 19:48:53 +0900
commit11d5c2683fe0f296280fa4b717db92b1d358d704 (patch)
treeeeb7b773f072a668ab6668f99162dcdc9932c132 /db/migrate
parent4ba0b50fc998c9b47b74adc31b6422f7dddcd199 (diff)
downloadaclog-11d5c2683fe0f296280fa4b717db92b1d358d704.tar.gz
* Fix #1
* Increase worker
Diffstat (limited to 'db/migrate')
-rw-r--r--db/migrate/20130225123010_create_accounts.rb10
-rw-r--r--db/migrate/20130226145932_create_users.rb13
-rw-r--r--db/migrate/20130226150329_create_tweets.rb13
-rw-r--r--db/migrate/20130226150829_create_favorites.rb8
-rw-r--r--db/migrate/20130226151042_create_retweets.rb8
5 files changed, 52 insertions, 0 deletions
diff --git a/db/migrate/20130225123010_create_accounts.rb b/db/migrate/20130225123010_create_accounts.rb
new file mode 100644
index 0000000..6856539
--- /dev/null
+++ b/db/migrate/20130225123010_create_accounts.rb
@@ -0,0 +1,10 @@
+class CreateAccounts < ActiveRecord::Migration
+ def change
+ create_table :accounts do |t|
+ t.string :oauth_token
+ t.string :oauth_token_secret
+
+ t.timestamps
+ end
+ end
+end
diff --git a/db/migrate/20130226145932_create_users.rb b/db/migrate/20130226145932_create_users.rb
new file mode 100644
index 0000000..1c863d2
--- /dev/null
+++ b/db/migrate/20130226145932_create_users.rb
@@ -0,0 +1,13 @@
+class CreateUsers < ActiveRecord::Migration
+ def change
+ create_table :users do |t|
+ t.string :screen_name
+ t.string :name
+ t.text :profile_image_url
+
+ t.timestamps
+ end
+
+ add_index :users, :screen_name
+ end
+end
diff --git a/db/migrate/20130226150329_create_tweets.rb b/db/migrate/20130226150329_create_tweets.rb
new file mode 100644
index 0000000..393b26e
--- /dev/null
+++ b/db/migrate/20130226150329_create_tweets.rb
@@ -0,0 +1,13 @@
+class CreateTweets < ActiveRecord::Migration
+ def change
+ create_table :tweets do |t|
+ t.text :text
+ t.text :source
+ t.references :user, :limit => 8
+ t.datetime :tweeted_at
+
+ t.integer :favorites_count
+ t.integer :retweets_count
+ end
+ end
+end
diff --git a/db/migrate/20130226150829_create_favorites.rb b/db/migrate/20130226150829_create_favorites.rb
new file mode 100644
index 0000000..d8b34fb
--- /dev/null
+++ b/db/migrate/20130226150829_create_favorites.rb
@@ -0,0 +1,8 @@
+class CreateFavorites < ActiveRecord::Migration
+ def change
+ create_table :favorites do |t|
+ t.references :tweet, :limit => 8
+ t.references :user, :limit => 8
+ end
+ end
+end
diff --git a/db/migrate/20130226151042_create_retweets.rb b/db/migrate/20130226151042_create_retweets.rb
new file mode 100644
index 0000000..a2eb3cf
--- /dev/null
+++ b/db/migrate/20130226151042_create_retweets.rb
@@ -0,0 +1,8 @@
+class CreateRetweets < ActiveRecord::Migration
+ def change
+ create_table :retweets do |t|
+ t.references :tweet, :limit => 8
+ t.references :user, :limit => 8
+ end
+ end
+end