Sha256: 4bdd77fe5c9b9e3affab76105d609506d7821db127bddd4e039cd59eccb4ba03
Contents?: true
Size: 652 Bytes
Versions: 93
Compression:
Stored size: 652 Bytes
Contents
class SampleData < ActiveRecord::Migration
def up
execute "drop table if EXISTS myreplicator.my_test"
sql =<<EOT
CREATE TABLE IF NOT EXISTS `myreplicator`.`my_test` (
`id` INT NULL AUTO_INCREMENT ,
`desc` VARCHAR(45) NULL ,
`updated_at` DATETIME NULL ,
PRIMARY KEY (`id`) );
EOT
execute sql
execute "INSERT INTO `myreplicator`.`my_test` (`id`, `desc`, `updated_at`) VALUES (1, 'test 1', '2012-10-31 10:10:00');"
execute "INSERT INTO `myreplicator`.`my_test` (`id`, `desc`, `updated_at`) VALUES (2, '2', '2012-10-31 10:11:00');"
end
def down
execute "drop table if EXISTS myreplicator.my_test"
end
end
Version data entries
93 entries across 93 versions & 1 rubygems