Database Type Map

The Database Type Map is used to create installation scripts using Umil and is used when altering tables in the db_tools class.

Introduction
The Database Type Map was designed to make creating installations for multiple database systems a simple task. Instead of having to write specific install instructions for each separate database system you can write one set of instructions and, using the Database Type Map and db_tools, alter any supported database system with a single command.

With the database table creation support in Umil you can make a single set of instructions for creating a new database table and it will handle the rest, which includes creating the correct query for the specific database system and running the query.

Type Map
Note that with some commands you may enter the Zerofill, example 'INT:11', if the field is a numeric one.

More Information on Zerofill

With some you may enter the length of the field, example 'VARCHAR:255'. This will make a varchar(255) column in MySQL.

In all of the fields supporting this, they will have a colon followed by %d meaning any number may fill the space of the %d.

Text
These should only be used for ASCII characters. If you plan to use it for something like message text read the Unicode Text section