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.integer :transporter_pid
      t.integer :loader_pid
      t.datetime :export_started_at, :default => nil
      t.datetime :export_finished_at, :default => nil
      t.datetime :load_started_at, :default => nil
      t.datetime :load_finished_at, :default => nil
      t.datetime :transfer_started_at, :default => nil
      t.datetime :transfer_finished_at, :default => nil
      t.timestamps
      t.boolean :analyze_constraints, :default => false
      t.boolean :nightly_refresh, :default => false
      t.integer :nightly_refresh_frequency, :default => nil
      t.datetime :nightly_refresh_last_run, :default => nil
      t.string :removing_special_chars, :default => nil
    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

18 entries across 18 versions & 1 rubygems

Version	Path
myreplicator-1.1.73	db/migrate/20121025191622_create_myreplicator_exports.rb
myreplicator-1.1.71	db/migrate/20121025191622_create_myreplicator_exports.rb
myreplicator-1.1.69	db/migrate/20121025191622_create_myreplicator_exports.rb
myreplicator-1.1.68	db/migrate/20121025191622_create_myreplicator_exports.rb
myreplicator-1.1.67	db/migrate/20121025191622_create_myreplicator_exports.rb
myreplicator-1.1.66	db/migrate/20121025191622_create_myreplicator_exports.rb
myreplicator-1.1.65	db/migrate/20121025191622_create_myreplicator_exports.rb
myreplicator-1.1.64	db/migrate/20121025191622_create_myreplicator_exports.rb
myreplicator-1.1.63	db/migrate/20121025191622_create_myreplicator_exports.rb
myreplicator-1.1.62	db/migrate/20121025191622_create_myreplicator_exports.rb
myreplicator-1.1.61	db/migrate/20121025191622_create_myreplicator_exports.rb
myreplicator-1.1.58	db/migrate/20121025191622_create_myreplicator_exports.rb
myreplicator-1.1.57	db/migrate/20121025191622_create_myreplicator_exports.rb
myreplicator-1.1.56	db/migrate/20121025191622_create_myreplicator_exports.rb
myreplicator-1.1.55	db/migrate/20121025191622_create_myreplicator_exports.rb
myreplicator-1.1.54	db/migrate/20121025191622_create_myreplicator_exports.rb
myreplicator-1.1.53	db/migrate/20121025191622_create_myreplicator_exports.rb
myreplicator-1.1.52	db/migrate/20121025191622_create_myreplicator_exports.rb