def clear_sequence_setup(rep_prefix, table_name)
sequence_table_name = "#{rep_prefix}_sequences"
if tables.include?(sequence_table_name)
trigger_name = "#{rep_prefix}_#{table_name}_sequence"
trigger_row = select_one("select * from information_schema.triggers\nwhere trigger_schema = database()\nand trigger_name = '\#{trigger_name}'\n")
if trigger_row
execute "DROP TRIGGER `#{trigger_name}`"
execute "delete from #{sequence_table_name} where name = '#{table_name}'"
unless select_one("select * from #{sequence_table_name}")
drop_table sequence_table_name.to_sym
end
end
end
end