Contents

class CreateMyreplicatorExports < ActiveRecord::Migration
  def change
    create_table :myreplicator_exports do |t|
      t.string :source_schema
      t.string :destination_schema
      t.string :table_name
      t.string :incremental_column
      t.string :max_incremental_value
      t.string :incremental_column_type
      t.string :export_to, :default => "destination_db"
      t.string :export_type, :default => "incremental"
      t.string :s3_path
      t.string :cron
      t.string :state, :default => "new"
      t.text :error
      t.boolean :active, :default => true
      t.integer :exporter_pid
      t.datetime :export_started_at, :default => nil
      t.datetime :export_finished_at, :default => nil
      t.timestamps
    end  
    add_index :myreplicator_exports, [:source_schema, :destination_schema, :table_name], :unique => true, :name => "unique_index"
  end

  def self.down
    drop_table :myreplicator_exports
  end
  
end

Version data entries

40 entries across 40 versions & 1 rubygems

Version	Path
myreplicator-1.1.31	db/migrate/20121025191622_create_myreplicator_exports.rb
myreplicator-1.1.30	db/migrate/20121025191622_create_myreplicator_exports.rb
myreplicator-1.1.29	db/migrate/20121025191622_create_myreplicator_exports.rb
myreplicator-1.1.28	db/migrate/20121025191622_create_myreplicator_exports.rb
myreplicator-1.1.27	db/migrate/20121025191622_create_myreplicator_exports.rb
myreplicator-1.1.26	db/migrate/20121025191622_create_myreplicator_exports.rb
myreplicator-1.1.25	db/migrate/20121025191622_create_myreplicator_exports.rb
myreplicator-1.1.24	db/migrate/20121025191622_create_myreplicator_exports.rb
myreplicator-1.1.23	db/migrate/20121025191622_create_myreplicator_exports.rb
myreplicator-1.1.22	db/migrate/20121025191622_create_myreplicator_exports.rb
myreplicator-1.1.21	db/migrate/20121025191622_create_myreplicator_exports.rb
myreplicator-1.1.20	db/migrate/20121025191622_create_myreplicator_exports.rb
myreplicator-1.1.19	db/migrate/20121025191622_create_myreplicator_exports.rb
myreplicator-1.1.18	db/migrate/20121025191622_create_myreplicator_exports.rb
myreplicator-1.1.17	db/migrate/20121025191622_create_myreplicator_exports.rb
myreplicator-1.1.16	db/migrate/20121025191622_create_myreplicator_exports.rb
myreplicator-1.1.15	db/migrate/20121025191622_create_myreplicator_exports.rb
myreplicator-1.1.13	db/migrate/20121025191622_create_myreplicator_exports.rb
myreplicator-1.1.12	db/migrate/20121025191622_create_myreplicator_exports.rb
myreplicator-1.1.11	db/migrate/20121025191622_create_myreplicator_exports.rb