migration.rb in say_when-1.0.0

- old
+ new

@@ -1,11 +1,12 @@
+# encoding: utf-8
+
 class CreateSayWhenTables < ActiveRecord::Migration
 
   def self.up
 
     create_table :say_when_jobs, :force => true do |t|
-
       t.string    :group
       t.string    :name
 
       t.string    :status
 
@@ -23,28 +24,28 @@
       t.text      :data
 
       t.string    :scheduled_type
       t.integer   :scheduled_id
 
-      t.timestamps
+      t.timestamps null: false
     end
 
+    add_index :say_when_jobs, [:next_fire_at, :status]
+    add_index :say_when_jobs, [:scheduled_type, :scheduled_id]
+
     create_table :say_when_job_executions, :force => true do |t|
       t.integer  :job_id
       t.string   :status
       t.text     :result
       t.datetime :start_at
       t.datetime :end_at
     end
 
-    add_index :say_when_jobs, :status
-    add_index :say_when_jobs, :next_fire_at
-    add_index :say_when_jobs, [:next_fire_at, :status]
-    add_index :say_when_jobs, [:last_fire_at, :status]
+    add_index :say_when_job_executions, :job_id
+    add_index :say_when_job_executions, [:status, :start_at, :end_at]
   end
 
   def self.down
     drop_table :say_when_job_executions
     drop_table :say_when_jobs
   end
-
 end