From 10959765b68cd7ca39774dc3fe9e6b48baca822b Mon Sep 17 00:00:00 2001 From: Holger Amann Date: Fri, 22 Jan 2010 10:18:18 +0800 Subject: [PATCH] Added support for bigint columns --- mysql2psql | 5 +++++ 1 file changed, 5 insertions(+) diff --git a/mysql2psql b/mysql2psql index 555687f..9f293b4 100755 --- a/mysql2psql +++ b/mysql2psql @@ -30,6 +30,8 @@ class MysqlReader def convert_type(type) case type + when /bigint/ + "bigint" when "tinyint(1)" "boolean" when /tinyint/ @@ -211,6 +213,9 @@ class PostgresWriter < Writer when "integer" default = " DEFAULT #{column[:default].nil? ? 'NULL' : column[:default].to_i}" if default "integer" + when "bigint" + default = " DEFAULT #{column[:default].nil? ? 'NULL' : column[:default].to_i}" if default + "bigint" when "tinyint" default = " DEFAULT #{column[:default].nil? ? 'NULL' : column[:default].to_i}" if default "smallint" -- 2.1.4