According to the documentation a small unsigned int covers the range of 0-65535 which is more than enough to cover the maximum value a short (roughly 32000) can be (item id/meta). Code: CREATE TABLE quicksell( id INT AUTO_INCREMENT PRIMARY KEY, itemid SMALLINT UNSIGNED NOT NULL, itemdmg SMALLINT UNSIGNED DEFAULT 0, price SMALLINT(25000) UNSIGNED NOT NULL );
The number behind SMALLINT is approximately the number of digits of the SMALLINT (i.e. the display width). You don't need to add a number behind the type. Usually, you don't need to set this number at all. SMALLINT is always stored as 16 bits, and you can't set any range for it (except UNSIGNED), nor would it affect the performance etc. Reference: http://stackoverflow.com/a/4055587/3990767