Tickets :: [#6763] TINYINT should not be used in the sql scripts

Summary	TINYINT should not be used in the sql scripts
Queue	Horde Base
Queue Version	3.2
Type	Bug
State	Resolved
Priority	1. Low
Owners	mrubinsk (at) horde (dot) org
Requester	lst_hoe02 (at) kwsoft (dot) de
Created	05/27/2008 (6243 days ago)
Due
Updated	05/27/2008 (6243 days ago)
Assigned
Resolved	05/27/2008 (6243 days ago)
Github Issue Link
Github Pull Request
Milestone
Patch	Yes

05/27/2008 02:23:17 PM	Michael Rubinsky	Comment #2 Assigned to Michael Rubinsky State ⇒ Resolved	Reply to this comment
Changed, but not exactly as you patched. (mySQL specific scripts can keep the TINYINT, and also changed datatypes across all upgrade/creation scripts to be consistent) Thanks for the report! http://lists.horde.org/archives/cvs/Week-of-Mon-20080526/079012.html

05/27/2008 09:17:55 AM	lst_hoe02 (at) kwsoft (dot) de	Comment #1 Priority ⇒ 1. Low New Attachment: patche-tinyint.ZIP Patch ⇒ Yes Milestone ⇒ Queue ⇒ Horde Base Summary ⇒ TINYINT should not be used in the sql scripts Type ⇒ Bug State ⇒ Unconfirmed	Reply to this comment
The datatype TINYINT is not valid for eg. PostgreSQL. It is more portable to use SMALLINT instead.