Types are specified using a definition when either creating or altering a table. The most common are VARCHAR(length) and INT(length) where length is a number that specifies how many characters can be stored within the column. Below is (or will soon be) a full list and a short description for each. Remember, when using INT, that any value inserted into the database that begins with a 0 (zero) will have the zero dropped. In such cases where you will need the preceding zeros to be stored, you should use VARCHAR() instead.

Type	Description
TINYINT(length)	An integer with a value range of 0 - 255. And a signed range of -128 to +127. Can also be INT1(length)
SMALLINT(length)	An integer with a value range of 0 - 65535. And a signed range of -32768 to +32767. Can also be INT2(length)

@tables = $VAR{db}->listtables

$VAR{db} = Mysql->connect($DBHOST, $DBNAME, $DBUSER, $DBPASS);