Sha256: 683e8aa4f28121b8b8397f435b8fb7973df2d17a32828b8026b8861af662c67f

Contents?: true

Size: 1.25 KB

Versions: 7

Compression:

Stored size: 1.25 KB

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
    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

7 entries across 7 versions & 1 rubygems

Version Path
myreplicator-1.1.38 db/migrate/20121025191622_create_myreplicator_exports.rb
myreplicator-1.1.37 db/migrate/20121025191622_create_myreplicator_exports.rb
myreplicator-1.1.36 db/migrate/20121025191622_create_myreplicator_exports.rb
myreplicator-1.1.35 db/migrate/20121025191622_create_myreplicator_exports.rb
myreplicator-1.1.34 db/migrate/20121025191622_create_myreplicator_exports.rb
myreplicator-1.1.33 db/migrate/20121025191622_create_myreplicator_exports.rb
myreplicator-1.1.32 db/migrate/20121025191622_create_myreplicator_exports.rb