---

This section details on the original issue you should resolve

<issue_title>Runner.MySql5 .AsTime() Creates DATETIME Column instead of TIME</issue_title>
<issue_description>With the following input:

 Create.Table("MyTable")
   .WithColumn("MyTimeColumn").AsTime()

I would expect MyTimeColumn to be of type TIME. However, it creates a DATETIME column. After looking at the MySql5TypeMap (linking the MySql4TypeMap since that is where the value originates) I assumed this was by design, but after checking out the PostgresTypeMap I now think it may be an oversight.

Thanks for any clarification!</issue_description>

Comments on the Issue (you are @copilot in this section)

@jzabroski Agree, this is a mess. Starting to build a Google Spreadsheet to help manage some of this.

https://docs.google.com/spreadsheets/d/1CWgsOhae-bGYt8fEKkDM7KsUkjN1BqHaRKN4am5HJsc/edit?usp=sharing</comment_new>
<comment_new>@jzabroski
I wrote a quick LinqPad code spike to prototype extracting all the type map metadata from FluentMigrator.

Requires FluentMigrator.Runner package to be installed via Nuget.

void Main()
{
	var result = System.Reflection.Assembly.Load(typeof(FluentMigrator.Runner.Generators.MySql.MySql4Generator).Assembly.GetName());
	Console.WriteLine(result.FullName);
	var typeMap = result.DefinedTypes.Where(dt => (typeof(FluentMigrator.Runner.Generators.Base.TypeMapBase).IsAssignableFrom(dt.AsType())));
	typeMap.Dump();
	
	result = System.Reflection.Assembly.Load(typeof(FluentMigrator.Runner.Generators.MySql.MySql5Generator).Assembly.GetName());
	Console.WriteLine(result.FullName);
	typeMap = result.DefinedTypes.Where(dt => (typeof(FluentMigrator.Runner.Generators.Base.TypeMapBase).IsAssignableFrom(dt.AsType())));
	typeMap.Dump();
	
	result = System.Reflection.Assembly.Load(typeof(FluentMigrator.Runner.Generators.Firebird.FirebirdGenerator).Assembly.GetName());
	Console.WriteLine(result.FullName);
	typeMap = result.DefinedTypes.Where(dt => (typeof(FluentMigrator.Runner.Generators.Base.TypeMapBase).IsAssignableFrom(dt.AsType())));
	typeMap.Dump();
	
	result = System.Reflection.Assembly.Load(typeof(FluentMigrator.Runner.Generators.DB2.Db2Generator).Assembly.GetName());
	Console.WriteLine(result.FullName);
	typeMap = result.DefinedTypes.Where(dt => (typeof(FluentMigrator.Runner.Generators.Base.TypeMapBase).IsAssignableFrom(dt.AsType())));
	typeMap.Dump();
	
	result = System.Reflection.Assembly.Load(typeof(FluentMigrator.Runner.Generators.Postgres.PostgresGenerator).Assembly.GetName());
	Console.WriteLine(result.FullName);
	typeMap = result.DefinedTypes.Where(dt => (typeof(FluentMigrator.Runner.Generators.Base.TypeMapBase).IsAssignableFrom(dt.AsType())));
	typeMap.Dump();
	
	result = System.Reflection.Assembly.Load(typeof(FluentMigrator.Runner.Generators.SqlAnywhere.SqlAnywhere16Generator).Assembly.GetName());
	Console.WriteLine(result.FullName);
	typeMap = result.DefinedTypes.Where(dt => (typeof(FluentMigrator.Runner.Generators.Base.TypeMapBase).IsAssignableFrom(dt.AsType())));
	typeMap.Dump();
	
	result = System.Reflection.Assembly.Load(typeof(FluentMigrator.Runner.Generators.SQLite.SQLiteGenerator).Assembly.GetName());
	Console.WriteLine(result.FullName);
	typeMap = result.DefinedTypes.Where(dt => (typeof(FluentMigrator.Runner.Generators.Base.TypeMapBase).IsAssignableFrom(dt.AsType())));
	typeMap.Dump();
	
	result = System.Reflection.Assembly.Load(typeof(FluentMigrator.Runner.Generators.Hana.HanaGenerator).Assembly.GetName());
	Console.WriteLine(result.FullName);
	typeMap = result.DefinedTypes.Where(dt => (typeof(FluentMigrator.Runner.Generators.Base.TypeMapBase).IsAssignableFrom(dt.AsType())));
	typeMap.Dump();

	result = System.Reflection.Assembly.Load(typeof(FluentMigrator.Runner.Generators.SqlServer.SqlServer2016Generator).Assembly.GetName());
	Console.WriteLine(result.FullName);
	typeMap = result.DefinedTypes.Where(dt => (typeof(FluentMigrator.Runner.Generators.Base.TypeMapBase).IsAssignableFrom(dt.AsType())));
	typeMap.Dump();	
}

I just need to then walk the ITypeMap data structure to extract all the types. I can then auto-populate the Google SPreadsheet with CsvHelper.</comment_new>