types[:bigint] = { :name => "bigint", :limit => 20 }
types[:double] = { :name => "double" }
types[:bigint_pk] = { :name => "bigint(20) DEFAULT NULL auto_increment PRIMARY KEY" }
+ types[:bigint_pk_64] = { :name => "bigint(64) DEFAULT NULL auto_increment PRIMARY KEY" }
+ types[:bigint_auto_64] = { :name => "bigint(64) DEFAULT NULL auto_increment" }
+ types[:bigint_auto_11] = { :name => "bigint(11) DEFAULT NULL auto_increment" }
+ types[:bigint_auto_20] = { :name => "bigint(20) DEFAULT NULL auto_increment" }
types
end
def innodb_table
return { :id => false, :force => true, :options => "ENGINE=InnoDB" }
end
+
+ def innodb_option
+ return "ENGINE=InnoDB"
+ end
+
+ def change_engine (table_name, engine)
+ execute "ALTER TABLE #{table_name} ENGINE = #{engine}"
+ end
+
+ def add_fulltext_index (table_name, column)
+ execute "CREATE FULLTEXT INDEX `#{table_name}_#{column}_idx` ON `#{table_name}` (`#{column}`)"
+ end
+
+ def alter_column_nwr_enum (table_name, column)
+ execute "alter table #{table_name} change column #{column} #{column} enum('node','way','relation');"
+ end
end
end
end